Database_Exception [ 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 'group by a.id ) as k' at line 1 [ select count(k.id) as dd from (SELECT a.id FROM `sline_hotel` a LEFT JOIN `sline_allorderlist` b ON (a.id=b.aid AND b.typeid=2 AND a.webid=b.webid AND b.classid=8) LEFT JOIN (SELECT COUNT(*) as s_num,productautoid FROM `sline_member_order` WHERE typeid=2 GROUP BY productautoid) AS s ON s.productautoid=a.id WHERE a.ishidden=0 AND FIND_IN_SET('8',a.kindlist) AND a.price BETWEEN 1001 AND group by a.id ) as k ]

MODPATH/database/classes/kohana/database/mysql.php [ 194 ]

189 			{
190 				// This benchmark is worthless
191 				Profiler::delete($benchmark);
192 			}
193 
194 			throw new Database_Exception(':error [ :query ]',
195 				array(':error' => mysql_error($this->_connection), ':query' => $sql),
196 				mysql_errno($this->_connection));
197 		}
198 
199 		if (isset($benchmark))
  1. MODPATH/database/classes/kohana/database/query.php [ 275 ] » Kohana_Database_MySQL->query(arguments)

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

  3. DOCROOT/plugins/hotel/classes/controller/pc/hotel.php [ 217 ] » Model_Hotel::search_result(arguments)

  4. {PHP internal call} » Controller_Pc_Hotel->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 [ 136 ] » Kohana_Request->execute()

Environment