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 'a.themelist) ORDER BY IFNULL(b.displayorder,9999) asc,a.modtime desc,a.addtime D' at line 15 [ SELECT a.id, a.webid, a.sellpoint, a.aid, a.kindlist, a.title, a.litpic, a.shownum, a.price, a.price_date, a.satisfyscore, a.bookcount, a.attrid, a.iconlist, a.carkindid FROM sline_car a LEFT JOIN `sline_allorderlist` b ON (a.id=b.aid and b.typeid=3) WHERE a.ishidden=0 AND FIND_IN_SET(,a.themelist) ORDER BY IFNULL(b.displayorder,9999) asc,a.modtime desc,a.addtime DESC ]

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/car/classes/taglib/car.php [ 377 ] » Kohana_Database_Query->execute()

  3. DOCROOT/plugins/car/classes/taglib/car.php [ 98 ] » Taglib_Car::get_car_by_themeid(arguments)

  4. DOCROOT/data/cache/v5/tplcache/default/zhuanti/index.php [ 125 ] » Taglib_Car::query(arguments)

  5. APPPATH/classes/stourweb/view.php [ 65 ] » include(arguments)

  6. DOCROOT/tools/classes/class/view.php [ 420 ] » Stourweb_View->capture(arguments)

  7. APPPATH/classes/stourweb/controller.php [ 114 ] » Class_View->render()

  8. APPPATH/classes/controller/zhuanti.php [ 59 ] » Stourweb_Controller->display(arguments)

  9. {PHP internal call} » Controller_Zhuanti->action_index()

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

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

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

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

Environment