MySQL error in 2.0

[Delphivi]

Hi people,

This is the second time i get an email about this MySQL error


Database error in vBulletin 3.6.1:

Invalid SQL:

SELECT linkid, name, links.catid, userid, username, dateline, links.lastpostdateline, title
FROM vb3_adv_links AS links
LEFT JOIN vb3_adv_links_categories AS categories USING (catid)
WHERE links.dateline > 1159765215 AND suspended = 0 AND valid = 1;

MySQL Error : Column 'valid' in where clause is ambiguous
Error Number : 1052
Date : Tuesday, October 3rd 2006 @ 09:38:15 AM
Script : /cron.php?&rand=412548
Referrer : /online.php
IP Address : **********
Username : Unregistered
Classname : vb_database


thought you wanted to know :)

[KW802]

Delphivi,

Thanks for the heads up. It's a known issue that Brian is addressing in this thread...

http://www.vbadvanced.com/forum/showthread.php?t=18061

[nealparry]

I get the same issue, just to let you know. Only on one site though, which is weird....