search error

[BWJ]

When performing a search with either single or multiple selection menu it gives following error:

PHP Code:

Database error in vBulletin 3.7.1:

Invalid SQL:

            SELECT links.linkid
            FROM forumadv_links AS links
            
            LEFT JOIN forumadv_links_cfields_entries AS customfields ON (links.linkid = customfields.lid)
            WHERE (field15 IN('234234') AND ) AND  valid = 1
        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 ') AND  valid = 1
        LIMIT 500' at line 5
Error Number  : 1064 


[Brian]

Thank you for pointing this out. I've applied the fix to the download package here, so if you will download the files again and replace your current links/search.php file with the updated version, that should take care of the issue.
Or, if you would like to apply the fix manually, just look in the file for this line:

PHP Code:

            $condition .= ($strcount ? ' (' : '(') . $cfieldandstring . ' AND '; 


And replace with this:

PHP Code:

            $condition .= iif($condition, ') AND ') . ' (' . $cfieldandstring; 


[BWJ]

Works now! Thank you....

[surfdude]

This did not fix my problem since I have same message as one in the first post. I have first made manual changes to searc.php as suggested and have then downloaded lates package and still no joy.

This is the message I receive:

PHP Code:

Database error in vBulletin 3.7.0:

Invalid SQL:

            SELECT links.linkid
            FROM adv_links AS links
            
            
            WHERE links.name LIKE '% errant  %' OR keywords LIKE '% errant  %' OR description LIKE '% errant  %') AND  valid = 1
        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 ') AND  valid = 1
        LIMIT 500' at line 5
Error Number  : 1064
Request Date  : Monday, June 2nd 2008 @ 01:11:48 PM
Error Date    : Monday, June 2nd 2008 @ 01:11:48 PM
Script        : http://www.xxxxxxxxxxxx.co.uk/links/search.php
Referrer      : http://www.xxxxxxxxxxxx.co.uk/links/search.php
IP Address    : xx.xxx.xxx.xxx
Username      : xxxxxxxxxx
Classname     : vb_database
MySQL Version : 4.1.20 


[Brian]

Thanks for pointing this one out as well. Looks like there's a small issue that can occur if you have full text searching disabled in your vB options. I've just applied the fix to the links/search.php file in the download package here, so if you will download the files again and upload the updated version over your current one, 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:

            foreach ($searchwords AS $sstring) 


And Add this just Above:

PHP Code:

            if (!$vbulletin->options['fulltextsearch'])
            {
                $condition .= '(';
            } 


[surfdude]

That worked.

Your forum is currently using the vBulletin search engine.

To enable the MySQL Fulltext search, we will issue the following two queries...

Thank you.