eman81
03-02-2012, 09:16 AM
Hi I have some problem with search in my site. When I try to find the word "диета" threre is appear sql error : site http://jenyne.ru
but another queries is ok
Database error in vBulletin 4.1.11:
Invalid SQL:
SELECT
fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,
a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings, a.displayorder,
at.contenttypes
FROM vb_attachment AS a
INNER JOIN vb_filedata AS fd ON (fd.filedataid = a.filedataid)
LEFT JOIN vb_attachmenttype AS at ON (at.extension = fd.extension)
WHERE
a.contentid IN (158,159,160,163,168,170,171,173,174,175,177,178,1 82,184,189,190,)
AND
a.contenttypeid = 18
ORDER BY a.contentid, a.displayorder;
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
a.contenttypeid = 18
ORDER BY a.contentid, a.displayorder' at line 10
Error Number : 1064
Request Date : Friday, March 2nd 2012 @ 02:08:36 PM
Error Date : Friday, March 2nd 2012 @ 02:08:36 PM
Script : http://jenyne.ru/search.php?searchid=102793
Referrer : http://jenyne.ru/search.php?searchid=102794
IP Address : 93.185.67.62
Classname : vB_Database
MySQL Version : 5.0.26-log
but another queries is ok
Database error in vBulletin 4.1.11:
Invalid SQL:
SELECT
fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,
a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings, a.displayorder,
at.contenttypes
FROM vb_attachment AS a
INNER JOIN vb_filedata AS fd ON (fd.filedataid = a.filedataid)
LEFT JOIN vb_attachmenttype AS at ON (at.extension = fd.extension)
WHERE
a.contentid IN (158,159,160,163,168,170,171,173,174,175,177,178,1 82,184,189,190,)
AND
a.contenttypeid = 18
ORDER BY a.contentid, a.displayorder;
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
a.contenttypeid = 18
ORDER BY a.contentid, a.displayorder' at line 10
Error Number : 1064
Request Date : Friday, March 2nd 2012 @ 02:08:36 PM
Error Date : Friday, March 2nd 2012 @ 02:08:36 PM
Script : http://jenyne.ru/search.php?searchid=102793
Referrer : http://jenyne.ru/search.php?searchid=102794
IP Address : 93.185.67.62
Classname : vB_Database
MySQL Version : 5.0.26-log