DataBase Error When Searching

[Spika]

I have installed VBA LD without problems and the users can view and add new links, but Today I get two erros:

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)
			
			WHERE  (links.userid IN(93)) ANDlinks.valid IN(0, 1, 2)
		ORDER BY links.name ASC LIMIT 500;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ANDlinks.valid IN(0, 1, 2)
		ORDER BY links.name ASC LIMIT 500' at line 5 Error Number  : 1064 Request Date  : Monday, December 29th 2008 @ 12:12:19 PM
Error Date    : Monday, December 29th 2008 @ 12:12:19 PM
Script        : http://www.gstrail.es/foro/links/search.php
Referrer      : http://www.gstrail.es/foro/links/search.php
IP Address    : 77.208.27.196
Username      : lawan
Classname     : vB_Database
MySQL Version : 5.0.45

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)
			
			WHERE  (links.userid IN(93)) ANDlinks.valid IN(0, 1, 2) links.catid IN(1,1,2,3,16,15) AND 
		ORDER BY links.name ASC LIMIT 500;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ANDlinks.valid IN(0, 1, 2) links.catid IN(1,1,2,3,16,15) AND 
		ORDER BY links.n' at line 5
Error Number  : 1064
Request Date  : Monday, December 29th 2008 @ 12:12:09 PM
Error Date    : Monday, December 29th 2008 @ 12:12:09 PM
Script        : http://www.gstrail.es/foro/links/search.php
Referrer      : http://www.gstrail.es/foro/links/search.php
IP Address    : 77.208.27.196
Username      : lawan
Classname     : vB_Database
MySQL Version : 5.0.45

Thanks

[Brian]

Thank you for pointing this out. I've just updated the links/search.php file in the download package here to include the fix, so if you will download the files again and update that one on your server, that should take care of the issue.
Or if you would rather apply the fix manually, just look in the file for this line:

PHP Code:

    $condition .= 'links.' . ($permissions['adminpermissions'] & $vbulletin->bf_ugp_adminpermissions['cancontrolpanel'] ? 'valid IN(0, 1, 2)' : 'valid = 1'); 


And replace with this:

PHP Code:

    $condition .= ' links.' . ($permissions['adminpermissions'] & $vbulletin->bf_ugp_adminpermissions['cancontrolpanel'] ? 'valid IN(0, 1, 2)' : 'valid = 1'); 


(just adding a space between ' and links)

[Spika]

Thank you very much!

[Spika]

The fix don´t avoid the error,
Today I have recived two more:

Database error in vBulletin 3.7.4:

Invalid SQL:

			SELECT links.linkid
			FROM vb_adv_links AS links
			
			
			WHERE (links.name LIKE '%gs %' OR keywords LIKE '%gs %' OR description LIKE '%gs %' AND links.name LIKE '%team %' OR keywords LIKE '%team %' OR description LIKE '%team %') AND  links.valid = 1 links.catid IN(1,1,2,3,16,15) AND 
		ORDER BY links.name ASC LIMIT 500;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'links.catid IN(1,1,2,3,16,15) AND 
		ORDER BY links.name ASC LIMIT 500' at line 5 Error Number  : 1064 Request Date  : Sunday, January 4th 2009 @ 06:04:31 PM
Error Date    : Sunday, January 4th 2009 @ 06:04:31 PM
Script        : http://www.gstrail.es/foro/links/search.php
Referrer      : http://www.gstrail.es/foro/links/search.php
IP Address    : 85.56.155.25
Username      : Titan
Classname     : vB_Database
MySQL Version :