gistfile1.php

emergency
Description

Exception (SQLException) - Could not execute query [Native 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 '2112,2114,2139,2141,2142,2143,2144,2145,2151,281,296,298,300,315,326,327,343,344' at line 1] [User Info: SELECT item_id,category_id FROM items2categories WHERE item_id IN (,2112,2114,2139,2141,2142,2143,2144,2145,2151,281,296,298,300,315,326,327,343,344,346,347,380,381,385,389,406,407,408,427,428,429,430,431,435,436,438,439,55,56)]
Source File

/usr/home/users/dimitar/MAS/mas-kt/heavymetal/lib/3rdparty/creole/drivers/mysqli/MySQLiConnection.php (line: 208)

00201:     {
00202:         self::$sql[] = $sql;
00203:         $this->lastQuery =& self::$sql[count(self::$sql)-1]; /* reference to the last executed sql */
00204:         //$this->lastQuery = $sql;
00205:  
00206:         $result = @mysqli_query($this->dblink, $sql);
00207:         if (!$result) {
00208: throw new SQLException('Could not execute query', mysqli_error($this->dblink), $sql);
00209:         }
00210:         return new MySQLiResultSet($this, $result, $fetchmode);
00211:     }
00212: 
00213:     function executeMultiQuery($sql, $fetchmode = null)
00214:     {
00215:         self::$sql[] = $sql;
00216:         $this->lastQuery =& self::$sql[count(self::$sql)-1]; /* reference to the last executed sql */

Stack Trace

#0 /usr/home/users/dimitar/MAS/mas-kt/heavymetal/lib/3rdparty/creole/common/PreparedStatementCommon.php(306): MySQLiConnection->executeQuery('SELECT item_id,...', NULL)
#1 /usr/home/users/dimitar/MAS/mas-kt/heavymetal/lib/3rdparty/creole/common/ConnectionEx.php(17): PreparedStatementCommon->executeQuery(Array)
#2 /usr/home/users/dimitar/MAS/mas-kt/heavymetal/lib/rudolf/record.php(3755): ConnectionEx->prepareEx('SELECT item_id,...', Array)
#3 /usr/home/users/dimitar/MAS/mas-kt/heavymetal/lib/rudolf/record.php(3769): rudolf_record::q('SELECT item_id,...', Array)
#4 /usr/home/users/dimitar/MAS/mas-kt/heavymetal/lib/refine_v2.php(1036): rudolf_record::f('SELECT item_id,...')
#5 /usr/home/users/dimitar/MAS/mas-kt/heavymetal/lib/refine_v2.php(1054): refine_v2::get_item_ids_cat_ids(Array)
#6 /usr/home/users/dimitar/MAS/mas-kt/heavymetal/lib/refine_v2.php(619): refine_v2::set_categories_count(Array, '1')
#7 /usr/home/users/dimitar/MAS/mas-kt/heavymetal/lib/refine_v2.php(196): refine_v2::set_additional_vars()
#8 /usr/home/users/dimitar/MAS/mas-kt/heavymetal/lib/page/search.php(172): refine_v2::refine(Object(item))
#9 /usr/home/users/dimitar/MAS/mas-kt/heavymetal/lib/page/seek.php(153): page_search->index()
#10 [internal function]: page_seek::inventory_search(NULL, Array)
#11 /usr/home/users/dimitar/MAS/mas-kt/heavymetal/lib/mas.php(187): call_user_func_array(Array, Array)
#12 /usr/home/users/dimitar/MAS/mas-kt/heavymetal/lib/page/seek.php(73): mas->__call('dispatch_search...', Array)
#13 /usr/home/users/dimitar/MAS/mas-kt/heavymetal/lib/page/seek.php(73): mas->dispatch_search_inventory(Array)
#14 /usr/home/users/dimitar/MAS/mas-kt/heavymetal/lib/controller.php(217): page_seek->index(Array)
#15 /usr/home/users/dimitar/MAS/mas-kt/heavymetal/lib/page.php(144): controller->invoke('index', Array)
#16 /usr/home/users/dimitar/MAS/mas-kt/heavymetal/lib/index.php(53): page->invoke('index', Array)
#17 /usr/home/users/dimitar/MAS/mas-kt/html/index.php(8): require('/usr/home/users...')
#18 {main}