[Amenadiel]

I suggest a little fix.

I was receiving this weird SQL error on my mail (it's VB's way to alert me when something goes wrong)

Database error in vBulletin 3.7.0:

Invalid SQL:
INSERT into vb_google_searches VALUES ('pavilion tx1332 drivers xp                                                                                                                                                                \"megaupload.com/\"|\"badongo.com/file/\"|\"rapidshare.com/files\"|\"mediafire.com/?\"|\"gigasize.com/get.php\"|\"seriesyonkis.com/\"','http://www.chw.net/foro/showthread.php?t=150369\',1);

MySQL Error   : Duplicate entry 'pavilion tx1332 drivers xp                                      ' for key 1
Error Number  : 1062
Request Date  : Tuesday, May 27th 2008 @ 04:10:48 PM
Error Date    : Tuesday, May 27th 2008 @ 04:10:48 PM
Script        : http://www.chw.net/foro/aqui-tienen-los-driver-del-tx1330la-t150369.html
Referrer      : http://www.google.es/custom?cx=005259712913702778262:h0v4n2t74pm&cof=GFNT%3A%23444444%3BGALT%3A%23444444%3BCX%3ADaleYa%252Ecom%3BVLC%3A%23663399%3BDIV%3A%23336699%3BFORID%3A0%3BT%3A%236600FF%3BALC%3A%23330000%3BLC%3A%23330000%3BGIMP%3A%23444444%3BBGC%3A%23DFE5FC%3BAH%3Aleft&q=pavilion+tx1332+drivers+xp++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++"megaupload.com/"|"badongo.com/file/"|"rapidshare.com/files"|"mediafire.com/?"|"gigasize.com/get.php"|"seriesyonkis.com/"&btnG=B%C3%BAsqueda&cx=005259712913702778262%3Ah0v4n2t74pm
IP Address    : 190.198.248.43
Username      : Unregistered
Classname     : vB_Database_MySQLi
MySQL Version :

After a bit of tinkering, I found out that the field kw on the vb_google_searches table is 255 chars long, so two strings of, let's say, 260 chars, whose 255 first chars are identical, would trigger a duplicate key error. ?Why? Because the search_cloud script will check for a 260 chars $search variable without finding coincidences.

Ok, perhaps I'm not explaining myself enough, but if you guys get this error, I solved it cropping the $search variable to 254 chars.

In search_cloud.php find

$this->_logHit(strtolower($search),$pageURL);

add BEFORE

$search=substr($search,0,254);

and that's it