PDA

View Full Version : MySQL error in 2.0



Delphivi
10-03-2006, 10:52 AM
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
10-03-2006, 11:13 AM
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

Our Sponsors
 

nealparry
10-04-2006, 07:52 PM
I get the same issue, just to let you know. Only on one site though, which is weird....