Database_Exception [ 1064 ]: [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 `webshop_product`.`id` ORDER BY `wpvp`.`price`' at line 1 ( SELECT `webshop_product`.`id` AS `id`, `webshop_product`.`title` AS `title`, `webshop_product`.`url` AS `url`, `webshop_product`.`item_number` AS `item_number`, `webshop_product`.`size` AS `size`, `webshop_product`.`description` AS `description`, `webshop_product`.`image` AS `image`, `webshop_product`.`flags` AS `flags`, `webshop_product`.`webshop_quantity` AS `webshop_quantity`, `webshop_product`.`vat` AS `vat`, `webshop_product`.`hidden` AS `hidden`, `webshop_product`.`created` AS `created`, `webshop_product`.`boxtype_id` AS `boxtype_id`, `webshop_product`.`grapetype_id` AS `grapetype_id`, `webshop_product`.`winenature_id` AS `winenature_id`, `webshop_product`.`winencolor_id` AS `winencolor_id`, `webshop_product`.`alcohol_content` AS `alcohol_content`, `webshop_product`.`award_description` AS `award_description`, `webshop_product`.`vintage` AS `vintage`, `webshop_product`.`meta_description` AS `meta_description`, `webshop_product`.`meta_keywords` AS `meta_keywords`, `webshop_product`.`meta_title` AS `meta_title`, `webshop_product`.`discontinued_product` AS `discontinued_product` FROM `webshop_products` AS `webshop_product` JOIN `webshop_products_webshop_categories` AS `wpwc` ON (`webshop_product`.`id` = `wpwc`.`webshop_product_id`) JOIN `webshop_product_variations` AS `wpv` ON (`wpv`.`webshop_product_id` = `webshop_product`.`id`) JOIN `webshop_product_variation_prices` AS `wpvp` ON (`wpv`.`id` = `wpvp`.`webshop_product_variation_id`) JOIN `language_values` AS `lv_hidden` ON (`lv_hidden`.`word_id` = `webshop_product`.`hidden` AND `lv_hidden`.`language_id` = 1) WHERE `lv_hidden`.`value` = 0 AND `wpwc`.`webshop_category_id` IN () GROUP BY `webshop_product`.`id` ORDER BY `wpvp`.`price` )

MODPATH/mysqli/classes/Kohana/Database/MySQLi.php [ 182 ]

177 			{
178 				// This benchmark is worthless
179 				Profiler::delete($benchmark);
180 			}
181 
182 			throw new Database_Exception('[:code] :error ( :query )', array(
183 				':code' => $this->_connection->errno,
184 				':error' => $this->_connection->error,
185 				':query' => $sql,
186 			), $this->_connection->errno);
187 		}
  1. MODPATH/database/classes/Kohana/Database/Query.php [ 251 ] » Kohana_Database_MySQLi->query(arguments)

  2. MODPATH/orm/classes/Kohana/ORM.php [ 1063 ] » Kohana_Database_Query->execute(arguments)

  3. MODPATH/orm/classes/Kohana/ORM.php [ 1004 ] » Kohana_ORM->_load_result(arguments)

  4. APPPATH/classes/Controller/Portlet/Countries.php [ 86 ] » Kohana_ORM->find_all()

  5. APPPATH/classes/Controller/Portlet/Countries.php [ 51 ] » Controller_Portlet_Countries->get_products(arguments)

  6. SYSPATH/classes/Kohana/Controller.php [ 84 ] » Controller_Portlet_Countries->action_show_list()

  7. {PHP internal call} » Kohana_Controller->execute()

  8. SYSPATH/classes/Kohana/Request/Client/Internal.php [ 97 ] » ReflectionMethod->invoke(arguments)

  9. SYSPATH/classes/Kohana/Request/Client.php [ 114 ] » Kohana_Request_Client_Internal->execute_request(arguments)

  10. SYSPATH/classes/Kohana/Request.php [ 997 ] » Kohana_Request_Client->execute(arguments)

  11. APPPATH/classes/Controller/Site.php [ 120 ] » Kohana_Request->execute()

  12. APPPATH/classes/Controller/Site.php [ 54 ] » Controller_Site->load_portlets()

  13. SYSPATH/classes/Kohana/Controller.php [ 69 ] » Controller_Site->before()

  14. {PHP internal call} » Kohana_Controller->execute()

  15. SYSPATH/classes/Kohana/Request/Client/Internal.php [ 97 ] » ReflectionMethod->invoke(arguments)

  16. SYSPATH/classes/Kohana/Request/Client.php [ 114 ] » Kohana_Request_Client_Internal->execute_request(arguments)

  17. SYSPATH/classes/Kohana/Request.php [ 997 ] » Kohana_Request_Client->execute(arguments)

  18. DOCROOT/index.php [ 132 ] » Kohana_Request->execute()

Environment