PDA

View Full Version : Database Error When Searching by Username


Spika
01-02-2009, 04:10 PM
Hello again, I have this error:

Database error in vBulletin 3.7.4:

Invalid SQL:

SELECT links.linkid
FROM vb_adv_links AS links
LEFT JOIN vb_adv_links_posts AS posts ON (posts.linkid = links.linkid) LEFT JOIN vb_adv_links_posts AS posts ON (posts.linkid = links.linkid)

WHERE (links.userid IN(79) OR posts.userid IN(79)) AND links.valid IN(0, 1, 2)
ORDER BY links.name ASC LIMIT 500;

MySQL Error : Not unique table/alias: 'posts'
Error Number : 1066
Request Date : Friday, January 2nd 2009 @ 12:38:22 PM
Error Date : Friday, January 2nd 2009 @ 12:38:22 PM
Script : http://www.gstrail.es/foro/links/search.php
Referrer : http://www.gstrail.es/foro/links/search.php
IP Address : 212.15.224.103
Username : JOUGS
Classname : vB_Database
MySQL Version : 5.0.45


Thanks

Brian
01-05-2009, 01:27 PM
Thank you for pointing this out. I've just applied the fix to the links/search.php file, so if you will download the files from here again and update that one on your server, that should take care of the issue.

Our Sponsors
 

Spika
01-06-2009, 03:00 PM
Thanks again!