SQL error in cron script

[roymogg]

Hi Brian,

I have picked up the following sql error error - can you advise what to correct.

cheers

Roy


Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT * FROM bf_adv_links WHERE suspended = 0 AND open > 0;

MySQL Error : Unknown column 'suspended' in 'where clause'
Error Number : 1054
Request Date : Wednesday, September 3rd 2008 @ 07:03:59 AM
Error Date : Wednesday, September 3rd 2008 @ 07:04:06 AM
Script : http://www.example.co.uk/exampleforum/cron.php?rand=20933
Referrer : http://www.example.co.uk/exampleforum/sendmessage.php
IP Address :
Username : Unregistered
Classname : vb_database
MySQL Version :

[Brian]

That would mean that the files in your includes/cron folder were not updated when you upgraded to v3.0. Delete the 3 vba_links_*.php files from that folder, re-upload them from the download package, and that should take care of the issue.

[Our Sponsors]

[roymogg]

Hi Brian,

Thanks for your reply the error remained and I have traced this back to an add-on for a links directory site map at VBSEO and found the offending line of script.

I have logged a support message over at VBSEO and I expect to have to remove the

WHERE suspended = 0 segment ( I think a suspended col is no longer in 3.01 - can you confirm?)

The add-on is disabled at the moment

thanks for your reply even though it was not a problem with the links dir software.

regards

Roy

[Brian]

Ahhh, I figured it was just an old cron job of ours. If you change 'suspended = 0' there to 'valid != 2' then that should take care of the issue.

[Our Sponsors]

[roymogg]

Hi Brian,

Many thanks for this support for a script that was not yours - this solved the issue and the site maps are now running fine.

I posted the change on VBSEO

thanks

Roy

Ahhh, I figured it was just an old cron job of ours. If you change 'suspended = 0' there to 'valid != 2' then that should take care of the issue.