Database_Exception [ 42000 ]: SQLSTATE[42000]: Syntax error or access violation: 1064 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 FIND_IN_SET(161,a.attrid)' at line 1 [ SELECT count(*) as dd FROM `sline_line` a LEFT JOIN `sline_kindorderlist` b ON (a.id=b.aid AND b.typeid=1 AND b.classid=63) LEFT JOIN (SELECT COUNT(*) as s_num,productautoid FROM `sline_member_order` WHERE typeid=1 GROUP BY productautoid) AS s ON s.productautoid=a.id WHERE a.ishidden=0 AND FIND_IN_SET('63',a.kindlist) AND a.price BETWEEN 10001 AND and FIND_IN_SET(161,a.attrid) ]

MODPATH/database/classes/kohana/database/pdo.php [ 160 ]

155 				// This benchmark is worthless
156 				Profiler::delete($benchmark);
157 			}
158 
159 			// Convert the exception in a database exception
160 			throw new Database_Exception(':error [ :query ]',
161 				array(
162 					':error' => $e->getMessage(),
163 					':query' => $sql
164 				),
165 				$e->getCode());
  1. MODPATH/database/classes/kohana/database/query.php [ 275 ] » Kohana_Database_PDO->query(arguments)

  2. DOCROOT/plugins/line/classes/model/line.php [ 369 ] » Kohana_Database_Query->execute()

  3. DOCROOT/plugins/line/classes/controller/pc/line.php [ 94 ] » Model_Line::search_result(arguments)

  4. {PHP internal call} » Controller_Pc_Line->action_list()

  5. SYSPATH/classes/kohana/request/client/internal.php [ 116 ] » ReflectionMethod->invoke(arguments)

  6. SYSPATH/classes/kohana/request/client.php [ 64 ] » Kohana_Request_Client_Internal->execute_request(arguments)

  7. SYSPATH/classes/kohana/request.php [ 1160 ] » Kohana_Request_Client->execute(arguments)

  8. DOCROOT/index.php [ 135 ] » Kohana_Request->execute()

Environment