SQL error following upgrade

[roymogg]

Update - I have removed a latest links VBA module from the directory page and vblinks now loads without error (at least up til now!)

I need to investigate this module first


cheers

RoyMogg




Hi Brian,

I have the following error following the upgrade - can you advise

Can the upgrade be backed out?

cheers

Roy



Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT links.*, links_categories.title FROM bf_adv_links AS links
LEFT JOIN bf_adv_links_categories AS links_categories ON (links.catid = links_categories.catid)
WHERE links.valid = 1 AND links.suspended = 0
ORDER BY rand() DESC
LIMIT 8;

MySQL Error : Unknown column 'links.suspended' in 'where clause'
Error Number : 1054
Request Date : Saturday, August 16th 2008 @ 06:38:52 PM
Error Date : Saturday, August 16th 2008 @ 06:38:52 PM

MySQL Version : 4.1.20

[KW802]

Links.suspended is no longer in the current version of vBa Links.

Instead of "AND links.suspended = 0" try "AND links.open = 1" instead.