( ! ) Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))WHERE p.status = '1' AND p.disable = '0' AND p2b.product_id IN(58,61,75,76,...' at line 3 in /var/www/site-dev/system/library/db/mysqli.php on line 18
( ! ) mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))WHERE p.status = '1' AND p.disable = '0' AND p2b.product_id IN(58,61,75,76,...' at line 3 in /var/www/site-dev/system/library/db/mysqli.php on line 18
Call Stack
#TimeMemoryFunctionLocation
10.0000359488{main}( ).../index.php:0
20.0004371632start( $application_config = 'catalog' ).../index.php:11
30.0004373040require_once( '/var/www/site-dev/system/framework.php ).../startup.php:105
40.0019466664Front->dispatch( $action = class Action { private $id = 'startup/router'; private $route = 'startup/router'; private $method = 'index' }, $error = class Action { private $id = 'error/not_found'; private $route = 'error/not_found'; private $method = 'index' } ).../framework.php:71
50.0070794288Front->execute( $action = class Action { private $id = 'startup/router'; private $route = 'startup/router'; private $method = 'index' } ).../front.php:29
60.0070794288Action->execute( $registry = class Registry { private $data = ['config' => class Config { ... }, 'load' => class Loader { ... }, 'request' => class Request { ... }, 'response' => class Response { ... }, 'db' => class DB { ... }, 'session' => class Session { ... }, 'cache' => class Cache { ... }, 'language' => class Language { ... }, 'document' => class Document { ... }, 'translit' => class Translit { ... }, 'model_localisation_language' => class Proxy { ... }, 'http_scheme' => 'https', 'http_host' => 'www.danswinkel.nl', 'url' => class Url { ... }, 'model_tool_common' => class Proxy { ... }, 'model_tool_image' => class Proxy { ... }, 'customer' => class Cart\Customer { ... }, 'currency' => class Cart\Currency { ... }, 'tax' => class Tax { ... }, 'cart' => class Cart\Cart { ... }, 'total' => class Cart\Total { ... }, 'model_catalog_product_clear' => class Proxy { ... }, 'product' => class Service\Product { ... }, 'model_checkout_order_clear' => class Proxy { ... }, 'order' => class Service\Order { ... }, 'encryption' => class Encryption { ... }, 'length' => class Length { ... }, 'log' => class Log { ... }, 'model_catalog_page_param' => class Proxy { ... }] }, $args = ??? ).../front.php:34
70.0070794496ControllerStartupRouter->index( ).../action.php:55
80.0070794744Action->execute( $registry = class Registry { private $data = ['config' => class Config { ... }, 'load' => class Loader { ... }, 'request' => class Request { ... }, 'response' => class Response { ... }, 'db' => class DB { ... }, 'session' => class Session { ... }, 'cache' => class Cache { ... }, 'language' => class Language { ... }, 'document' => class Document { ... }, 'translit' => class Translit { ... }, 'model_localisation_language' => class Proxy { ... }, 'http_scheme' => 'https', 'http_host' => 'www.danswinkel.nl', 'url' => class Url { ... }, 'model_tool_common' => class Proxy { ... }, 'model_tool_image' => class Proxy { ... }, 'customer' => class Cart\Customer { ... }, 'currency' => class Cart\Currency { ... }, 'tax' => class Tax { ... }, 'cart' => class Cart\Cart { ... }, 'total' => class Cart\Total { ... }, 'model_catalog_product_clear' => class Proxy { ... }, 'product' => class Service\Product { ... }, 'model_checkout_order_clear' => class Proxy { ... }, 'order' => class Service\Order { ... }, 'encryption' => class Encryption { ... }, 'length' => class Length { ... }, 'log' => class Log { ... }, 'model_catalog_page_param' => class Proxy { ... }] }, $args = ??? ).../router.php:18
90.0070795072ControllerProductPageParam->index( ).../action.php:55
100.2540861160Service\Product->getProductPageParamBadges( $data = ['page_param_id' => '130', 'category_ids' => [], 'pv_ids' => [0 => '9', 1 => '74', 2 => '111', 3 => '112', 4 => '181', 5 => '182', 6 => '187', 7 => '338', 8 => '352', 9 => '479', 10 => '500', 11 => '501', 12 => '790', 13 => '792', 14 => '793', 15 => '804', 16 => '807', 17 => '830', 18 => '842', 19 => '844'], 'p_count' => 2, 'multiple_params' => [], 'badges' => [], 'price_from' => '', 'price_to' => '', 'sort' => 'default', 'order' => 'desc', 'page' => 1, 'limit' => '24'], $badges = ['bestseller' => ['code' => 'bestseller', 'color' => '#d1c5c5', 'css_class' => '', 'name' => 'Bestseller', 'short_description' => 'Bestseller', 'is_filter' => '1', 'is_sort' => '1', 'image' => 'https://www.danswinkel.nl/image/badge/bestseller/bestseller.svg', 'description' => 'Bestseller', 'sort_order' => '2'], 'eco' => ['code' => 'eco', 'color' => '#b6d1bb', 'css_class' => '', 'name' => 'ECO', 'short_description' => 'ECO', 'is_filter' => '1', 'is_sort' => '1', 'image' => 'https://www.danswinkel.nl/image/badge/eco/eco.svg', 'description' => 'ECO', 'sort_order' => '3'], 'rad' => ['code' => 'rad', 'color' => '#e0cee0', 'css_class' => '', 'name' => 'RAD', 'short_description' => 'RAD geschikte balletkleding', 'is_filter' => '1', 'is_sort' => '1', 'image' => 'https://www.danswinkel.nl/image/badge/rad/rad.svg', 'description' => 'Geschikte balletkleding voor Royal Academy of Dance (RAD) lessen.', 'sort_order' => '4'], 'uitverkocht' => ['code' => 'uitverkocht', 'color' => '#f4cccc', 'css_class' => '', 'name' => 'Uitverkocht', 'short_description' => 'Uitverkocht', 'is_filter' => '0', 'is_sort' => '0', 'image' => 'https://www.danswinkel.nl/image/badge/uitverkocht/uitverkocht.svg', 'description' => 'Uitverkocht', 'sort_order' => '4']] ).../page_param.php:303
110.2540861536Proxy->__call( $key = 'getProductPageParamBadges', $args = [0 => ['page_param_id' => '130', 'category_ids' => [...], 'pv_ids' => [...], 'p_count' => 2, 'multiple_params' => [...], 'badges' => [...], 'price_from' => '', 'price_to' => '', 'sort' => 'default', 'order' => 'desc', 'page' => 1, 'limit' => '24'], 1 => ['bestseller' => [...], 'eco' => [...], 'rad' => [...], 'uitverkocht' => [...]]] ).../product.php:71
120.2540862320Loader->{closure:/var/www/site-dev/system/engine/loader.php:108-138}( $args = [0 => ['page_param_id' => '130', 'category_ids' => [...], 'pv_ids' => [...], 'p_count' => 2, 'multiple_params' => [...], 'badges' => [...], 'price_from' => '', 'price_to' => '', 'sort' => 'default', 'order' => 'desc', 'page' => 1, 'limit' => '24'], 1 => ['bestseller' => [...], 'eco' => [...], 'rad' => [...], 'uitverkocht' => [...]]], [0 => ['page_param_id' => '130', 'category_ids' => [...], 'pv_ids' => [...], 'p_count' => 2, 'multiple_params' => [...], 'badges' => [...], 'price_from' => '', 'price_to' => '', 'sort' => 'default', 'order' => 'desc', 'page' => 1, 'limit' => '24'], 1 => ['bestseller' => [...], 'eco' => [...], 'rad' => [...], 'uitverkocht' => [...]]] ).../proxy.php:25
130.2540863648ModelCatalogProductClear->getProductPageParamBadges( $criteria = ['page_param_id' => '130', 'category_ids' => [], 'pv_ids' => [0 => '9', 1 => '74', 2 => '111', 3 => '112', 4 => '181', 5 => '182', 6 => '187', 7 => '338', 8 => '352', 9 => '479', 10 => '500', 11 => '501', 12 => '790', 13 => '792', 14 => '793', 15 => '804', 16 => '807', 17 => '830', 18 => '842', 19 => '844'], 'p_count' => 2, 'multiple_params' => [], 'badges' => [], 'price_from' => '', 'price_to' => '', 'sort' => 'default', 'order' => 'desc', 'page' => 1, 'limit' => '24'], $db_badges = ['bestseller' => ['code' => 'bestseller', 'color' => '#d1c5c5', 'css_class' => '', 'name' => 'Bestseller', 'short_description' => 'Bestseller', 'is_filter' => '1', 'is_sort' => '1', 'image' => 'https://www.danswinkel.nl/image/badge/bestseller/bestseller.svg', 'description' => 'Bestseller', 'sort_order' => '2'], 'eco' => ['code' => 'eco', 'color' => '#b6d1bb', 'css_class' => '', 'name' => 'ECO', 'short_description' => 'ECO', 'is_filter' => '1', 'is_sort' => '1', 'image' => 'https://www.danswinkel.nl/image/badge/eco/eco.svg', 'description' => 'ECO', 'sort_order' => '3'], 'rad' => ['code' => 'rad', 'color' => '#e0cee0', 'css_class' => '', 'name' => 'RAD', 'short_description' => 'RAD geschikte balletkleding', 'is_filter' => '1', 'is_sort' => '1', 'image' => 'https://www.danswinkel.nl/image/badge/rad/rad.svg', 'description' => 'Geschikte balletkleding voor Royal Academy of Dance (RAD) lessen.', 'sort_order' => '4'], 'uitverkocht' => ['code' => 'uitverkocht', 'color' => '#f4cccc', 'css_class' => '', 'name' => 'Uitverkocht', 'short_description' => 'Uitverkocht', 'is_filter' => '0', 'is_sort' => '0', 'image' => 'https://www.danswinkel.nl/image/badge/uitverkocht/uitverkocht.svg', 'description' => 'Uitverkocht', 'sort_order' => '4']] ).../loader.php:132
140.3743942960DB->query( $sql = 'SELECT p2b.badge_code, COUNT(DISTINCT p2b.product_id) AS p_count\n FROM product_to_badge p2b\n INNER JOIN product p ON (p2b.product_id = p.product_id) INNER JOIN product_to_category p2c ON (p2c.product_id = p.product_id AND p2c.category_id IN())WHERE p.status = \'1\' AND p.disable = \'0\' AND p2b.product_id IN(58,61,75,76,103,138,145,147,148,150,154,192,208,217,219,227,229,255,257,279,309,549,595,599,671,673,692,694,695,696,697,699,700,702,706,709,710,713,717,718,720,721,722,730,732,746,752'..., $params = ??? ).../product_clear.php:5181
150.3743942960DB\MySQLi->query( $sql = 'SELECT p2b.badge_code, COUNT(DISTINCT p2b.product_id) AS p_count\n FROM product_to_badge p2b\n INNER JOIN product p ON (p2b.product_id = p.product_id) INNER JOIN product_to_category p2c ON (p2c.product_id = p.product_id AND p2c.category_id IN())WHERE p.status = \'1\' AND p.disable = \'0\' AND p2b.product_id IN(58,61,75,76,103,138,145,147,148,150,154,192,208,217,219,227,229,255,257,279,309,549,595,599,671,673,692,694,695,696,697,699,700,702,706,709,710,713,717,718,720,721,722,730,732,746,752'..., [] ).../db.php:16
160.3743942960query( $query = 'SELECT p2b.badge_code, COUNT(DISTINCT p2b.product_id) AS p_count\n FROM product_to_badge p2b\n INNER JOIN product p ON (p2b.product_id = p.product_id) INNER JOIN product_to_category p2c ON (p2c.product_id = p.product_id AND p2c.category_id IN())WHERE p.status = \'1\' AND p.disable = \'0\' AND p2b.product_id IN(58,61,75,76,103,138,145,147,148,150,154,192,208,217,219,227,229,255,257,279,309,549,595,599,671,673,692,694,695,696,697,699,700,702,706,709,710,713,717,718,720,721,722,730,732,746,752'... ).../mysqli.php:18