Searching Bug

[ckusmez]

Hi !

I realized something wrong at search area. For example in one video i wrote keywords by this order : keyword1 keyword2 keyword3 keyword4 keyword5 keyword6

when i search only keyword1,...keyword6 there exist no problem.

when i search keyword1+keyword2 no problem

But if i search keyword6+keyword3 at the same time searching system can't find any video.

Can you fix that bug ?

[s7v7n]

I'll check this issue...

[ckusmez]

I've just noticed a bug again in search area. when i'm searchin sally's car. There exist a database error.

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT COUNT(`tubeid`) AS `totalrecords`
FROM `vbtube_tubes` AS tubes
WHERE keywords LIKE '%delail'in%' 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 '%' AND active = 1' at line 3
Error Number : 1064
Request Date : Friday, July 25th 2008 @ 12:48:07 AM
Error Date : Friday, July 25th 2008 @ 12:48:07 AM
Script : http://forum.............net/vbtube_search.php?do=all
Referrer : http://forum..............net/vbtube_search.php?do=all
IP Address : 85.101.58.95
Username : admin
Classname : vB_Database
MySQL Version : 4.1.22-standard

There is a problem (') with this sign. Can you fix it ?

[ckusmez]

I found a bug again in search area. (this problem caused by turkish charachters)

i want to search "çanta" word. and there exist 30+ result. And when i push the second page it can't find any video. when i saw the link it was ../search-all/2-çanta.html

This rewrite rules makes mistake for turkish characters.

PHP Code:

'vbtube_search\.php\?do=all&searchtext=(.*)&page=(.*)' => 'search-all/$2-$1.html'