Database Error (SQL_CALC_FOUND_ROWS)
Started to get this reports recently after update to RC3.
Code:
Database error in vBulletin 4.2.3 Beta 2:
Invalid SQL:
SELECT SQL_CALC_FOUND_ROWS `page`.`pageid` AS `itemid` FROM `vb_vw_page` `page` LEFT JOIN `vb_vw_categoryitem` `ci` ON (`ci`.`pageid` = `page`.`pageid`)
LEFT JOIN `vb_vw_route` `i` ON (`page`.`pageid` = `i`.`itemid` AND `i`.`itemtypeid` = 1) WHERE `page`.`areaid` IN () AND `page`.`visible` = 1 AND `page`.`pageid` NOT IN (77) AND `ci`.`itemcategoryid` = 77 ORDER BY `i`.`sortkey` ASC, `i`.`parentprefixid` ASC LIMIT 0,200;
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 `page`.`visible` = 1 AND `page`.`pageid` NOT IN (77) AND `ci`.`itemcate' at line 2
Error Number : 1064
Request Date : Friday, October 10th 2014 @ 12:05:05 PM
Error Date : Friday, October 10th 2014 @ 12:05:05 PM
Script : hxxp://rpgmaker.su/wiki/Категории/Категория:Боевые-системы?do=listing
Referrer :
IP Address : 141.8.189.122
Username : Unregistered
Classname : vB_Database
MySQL Version :