2.0 sponsored cron - Error: Unknown column 'link.sponsored_notif_sent'....

[Tech25]

alrighty.... aside from the fact I am totally lost as to how to get crons to work in 2.0, I triggered sponsored cron manually in the browser and got the following error:

Error: Unknown column 'link.sponsored_notif_sent' in 'where clause'

SELECT `link`.*, `cat`.`path`, `cat`.`id` `id_category`, `plan`.`cost` `plan_cost`, `link`.`sponsored_start` + INTERVAL `plan`.`period` DAY `sponsored_end` FROM `links` `link` LEFT JOIN `plans` `plan` ON `link`.`sponsored_plan_id` = `plan`.`id` LEFT JOIN `link_categories` `l_c` ON `link`.`id` = `l_c`.`id_link` LEFT JOIN `categories` `cat` ON `l_c`.`id_category` = `cat`.`id` WHERE `link`.`sponsored` = '1' AND `link`.`sponsored_start` + INTERVAL `plan`.`period` DAY - INTERVAL 1 DAY < NOW() AND `link`.`sponsored_notif_sent` = '0' AND `l_c`.`crossed` = '0'
Can someone offer a suggestion on how to fix this.... as I understand it, the php files in the 2.0 cron folder shouldn't display anything as they are to be used by cron.

thanks oodles ad I do apologise for all the questions as of late.


All the best

Roy

[Tech25]

ok, small update, just for yuks I downloaded the cron package from the downloadsite which contained cron.php and sponsored_cron.php.

I tried running these two and cron.php seems to work without generating any errors, but when I hit sponsored_cron.php with a web browser I get this error message now....

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/xxxxxxxx/public_html/cron/sponsored_cron.php on line 103

Any feedback on what could be causing this? LOL

Anyways, this seems to be the most pressing because I have a 1 day test account that has been active for two days, I'm thinking these crons aren't doing their job in their current state. Must have plans expire. THis is the last tweak I need to do before I can go live **grins** All the rest can wait lol

Sorry to be such a pain.... just trying to get all this sorted on an extremely tight schedule.:crazy-be:

All the best!

Roy H.

[jarppa heino]

alrighty.... aside from the fact I am totally lost as to how to get crons to work in 2.0, I triggered sponsored cron manually in the browser and got the following error:


Can someone offer a suggestion on how to fix this.... as I understand it, the php files in the 2.0 cron folder shouldn't display anything as they are to be used by cron.

thanks oodles ad I do apologise for all the questions as of late.


All the best

Roy

I have the same problem. I opened ticket for it, let's see when we get answer.

EDIT: I just added "sponsored_notif_sent" column in the links table and now it works.

[Tech25]

great.... lol I suck at sql stuff... what would I run to do that?

[jarppa heino]

Hi, you might try following sql command


ALTER TABLE `links` ADD `sponsored_notif_sent` INT( 1 ) NULL ;


If you're using phpmyadmin, Choose your database and click SQL tab at top of the page and copy + paste the code above into the textarea.

This is just my unofficial fix, hope devs will post correct column structure.

[Tech25]

thanks much - error message has been eliminated.... now to see if it fixes the issue of sponsored links not expiring.

[Tech25]

no joy - this is starting to get depressing:(

any suggestions anyone?