Thread: sql error ?

Hii,

Why am I receiving these sql errors ? I think something wrong with the search function

PHP Code:

Database error in vBulletin 3.6.10:

Invalid SQL:

               SELECT COUNT(`tubeid`) AS `totalrecords`
               FROM `vbtube_tubes` AS tubes
               WHERE keywords LIKE '%harumi's bad play%' AND active = 1;

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 's bad play%' AND active = 1' at line 3
Error Number : 1064
Date         : Friday, July 25th 2008 @ 08:46:20 AM
Script       : http://forum.nihonomaru.com/vbtube_search.php?do=all
Referrer     : http://forum.nihonomaru.com/vbtube_search.php?do=all
IP Address   : 
Username     : evilguy99
Classname    : vB_Database 


PHP Code:

Database error in vBulletin 3.6.10:

Invalid SQL:

               SELECT COUNT(`tubeid`) AS `totalrecords`
               FROM `vbtube_tubes` AS tubes
               WHERE keywords LIKE '%it's a family affair%' AND active = 1;

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 's a family affair%' AND active = 1' at line 3
Error Number : 1064
Date         : Friday, July 25th 2008 @ 10:05:56 AM
Script       : http://forum.nihonomaru.com/vbtube_search.php?do=all
Referrer     : http://forum.nihonomaru.com/TubeShow-388-34584.html
IP Address   : 
Username     : unknown123456
Classname    : vB_Database 


This is a bug yesterday reported. I fix that. now you can't do anything.

i think i fixed the problem. At least, it is working in my site.

Firstly find the vbtube_search.php page on forum root.

Then find

PHP Code:

// Count for Pages 


line

And immeadiately add below line of code;

PHP Code:

$searchtext = eregi_replace("'","",$searchtext); 


I wish this was the solution of the problem.

Originally Posted by s7v7n

This is a bug yesterday reported. I fix that. now you can't do anything.

Hi Murat what do you mean by "now you can't do anything."

~ Thanks ckusmez i will try that =]