Database_Exception [ 1064 ]: 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 '-20' at line 1 [ SELECT `products`.`pr_id` AS `pr_id`, `products`.`pr_code` AS `pr_code`, `products`.`pr_supplier_code` AS `pr_supplier_code`, `products`.`pr_is_acc` AS `pr_is_acc`, `products`.`pr_acc_product` AS `pr_acc_product`, `products`.`pr_acc_order` AS `pr_acc_order`, `products`.`pr_name` AS `pr_name`, `products`.`pr_barcode` AS `pr_barcode`, `products`.`pr_ma_id` AS `pr_ma_id`, `products`.`pr_desc` AS `pr_desc`, `products`.`pr_custom_stariff_number` AS `pr_custom_stariff_number`, `products`.`pr_product_category` AS `pr_product_category`, `products`.`pr_vat_id` AS `pr_vat_id`, `products`.`pr_weight` AS `pr_weight`, `products`.`pr_width` AS `pr_width`, `products`.`pr_height` AS `pr_height`, `products`.`pr_depth` AS `pr_depth`, `products`.`pr_qty_package` AS `pr_qty_package`, `products`.`pr_qty_level` AS `pr_qty_level`, `products`.`pr_qty_pallet` AS `pr_qty_pallet`, `products`.`pr_enabled` AS `pr_enabled`, `products`.`pr_tqu_id` AS `pr_tqu_id`, `products`.`pr_is_deleted` AS `pr_is_deleted`, `products`.`pr_guarantee_months` AS `pr_guarantee_months`, `products`.`pr_best_before_is_day` AS `pr_best_before_is_day`, `products`.`pr_best_before_value` AS `pr_best_before_value`, `products`.`pr_web_name` AS `pr_web_name`, `products`.`pr_web_description` AS `pr_web_description`, `products`.`pr_web_url` AS `pr_web_url`, `products`.`pr_strexa` AS `pr_strexa`, `products`.`pr_strexb` AS `pr_strexb`, `products`.`pr_strexc` AS `pr_strexc`, `products`.`pr_strexd` AS `pr_strexd`, `products`.`pr_dateexa` AS `pr_dateexa`, `products`.`pr_dateexb` AS `pr_dateexb`, `products`.`pr_numexa` AS `pr_numexa`, `products`.`pr_numexb` AS `pr_numexb`, `products`.`pr_numexc` AS `pr_numexc`, `products`.`pr_boolexa` AS `pr_boolexa`, `products`.`pr_boolexb` AS `pr_boolexb`, `products`.`pr_is_run_out` AS `pr_is_run_out`, `products`.`pr_is_sell_banned` AS `pr_is_sell_banned`, `products`.`pr_is_buy_banned` AS `pr_is_buy_banned`, `products`.`pr_slug` AS `pr_slug`, `products`.`pr_is_new` AS `pr_is_new`, `products`.`pr_properties` AS `pr_properties` FROM `products` AS `products` JOIN `manufacturers` ON (`products`.`pr_ma_id` = `manufacturers`.`ma_id`) JOIN `product_prices` AS `price` ON (`price`.`prpr_pr_id` = `pr_id` AND `price`.`prpr_tpt_id` = 1 AND `price`.`prpr_cu_id` = 1 AND `price`.`prpr_enabled` = 1) WHERE (`manufacturers`.`ma_name` LIKE '%horsefeathers%' OR `products`.`pr_name` LIKE '%horsefeathers%' OR `products`.`pr_code` LIKE '%horsefeathers%' OR `products`.`pr_custom_stariff_number` LIKE '%horsefeathers%' OR `products`.`pr_barcode` LIKE '%horsefeathers%' OR CONCAT_WS(" ",manufacturers.ma_name,products.pr_name) LIKE '%horsefeathers%' OR CONCAT_WS(" ",manufacturers.ma_name,products.pr_name,products.pr_custom_stariff_number) LIKE '%horsefeathers%') AND `products`.`pr_id` IN ('649', '764', '774', '792', '930', '935', '943', '947', '953', '954', '980', '974', '1002', '1004', '1005', '1029', '1038', '1042', '1055', '1059', '1069', '1071', '1101', '1104', '1106', '1098', '1119', '1126', '1142', '1141', '1146', '1148', '1153', '1168', '1171', '1179', '1185', '1188', '1199', '1213', '1218', '3327', '1233', '1244', '1248', '1258', '1260', '1262', '1309', '1328', '1352', '1356', '1359', '1365', '1374', '1403', '1424', '1430', '1431', '1433', '1450', '1451', '1456', '1461', '1486', '1492', '1497', '1503', '1513', '1576', '1588', '1589', '1590', '1592', '1596', '1621', '1635', '1636', '1638', '1650', '1660', '1662', '1670', '1672', '1673', '1675', '1677', '1678', '1679', '1680', '1690', '1695', '1696', '1699', '1700', '1701', '1705', '1712', '1713', '1714', '1720', '1722', '1729', '1730', '1732', '1733', '1736', '1742', '1746', '1749', '1751', '1753', '1754', '1758', '1759', '1765', '1766', '1767', '1769', '1770', '1772', '1773', '1774', '1775', '1776', '1777', '1778', '1781', '1782', '1783', '1784', '1785', '1786', '1788', '1790', '1791', '1792', '1793', '1794', '1796', '1799', '1802', '1806', '1811', '1818', '1821', '1822', '1823', '1833', '1854', '1864', '1876', '1925', '1927', '1934', '1947', '1993', '2040', '2044', '2045', '2075', '2152', '2164', '2235', '2270', '2273', '2277', '2290', '2292', '2302', '2303', '2305', '2330', '2333', '2342', '2361', '2363', '2365', '2370', '2375', '2377', '2381', '2386', '2444', '2445', '2456', '2467', '2470', '2471', '2476', '2482', '2484', '2492', '2495', '2496', '2498', '2500', '2502', '2505', '2526', '2534', '2537', '2565', '2575', '2580', '2630', '2635', '2639', '2643', '2646', '2647', '2655', '2657', '2668', '2676', '2700', '2704', '3834', '2740', '2743', '2749', '2757', '2758', '2759', '2760', NULL, '2765', '2785', '2795', '2813', '2823', '2834', '2874', '2884', '2885', '2977', '2979', '2984', '3037', '3040', '3041', '3043', '3047', '3053', '3084', '3101', '3103', '3104', '3107', '3109', '3111', '3113', '3114', '3115', '3116', '3117', '3123', '3125', '3137', '3142', '3143', '3147', '3154', '3163', '3168', '3173', '3174', '3196', '3206', '3220', '3222', '3241', '3247', '3252', '3257', '3260', '3261', '3263', '3269', '3273', '3309', '3316', '3320', '3992', '3352', '3356', '3362', '3366', '3374', '3382', '3420', '3430', '3431', '3432', '3442', '3444', '3456', '3457', '3458', '3463', '3469', '3473', '3474', '3479', '3482', '3484', '3486', '3490', '3491', '3492', '3493', '3494', '3523', '3524', '3525', '3526', '3527', '3529', '3530', '3531', '3532', '3553', '3558', '3563', '3565', '3573', '3579', '3584', '3585', '3589', '3591', '3592', '3595', '3602', '3312', '3656', '3657', '3213', '3670', '3673', '3674', '3677', '3678', '3679', '3681', '3686', '3688', '3690', '3691', '3692', '3695', '3696', '3697', '3705', '3710', '3713', '3714', '3717', '3718', '3732', '3733', '3735', '3736', '3740', '3749', '3755', '3757', '3763', '3765', '3767', '3768', '3770', '2464', '3772', '3773', '3774', '3797', '3807', '3815', '3853', '3856', '3857', '3859', '3862', '3863', '3864', '3866', '3867', '3868', '3871', '3875', '3877', '3878', '3879', '3880', '3885', '3887', '3890', '3891', '3895', '3897', '3903', '3910', '3911', '3914', '3915', '3916', '3918', '3921', '3922', '3924', '3925', '3927', '3929', '3930', '3931', '3932', '3933', '3950', '3951', '3953', '3957', '3959', '3961', '3965', '3303', '4001', '4010', '4011', '4012', '4014', '4016', '4032', '4035', '4037', '4040', '4041', '4047', '4051', '4083', '4091', '4117', '4145', '4169', '4182', '4186', '4203', '4204', '4212', '4213', '4217', '4221', '4224', '4229', '1242', '4234', '4236', '4242', '4246', '4250', '4254', '4257', '4265', '4273', '4276', '4278', '4279', '4281', '4319', '4324', '3324', '3323', '3322', '4360', '4366', '4367', '4400', '4409', '4413', '4432', '4439', '4441', '3310', '4799', '4802', '4478', '4485', '4488', '4499', '4511', '4517', '4524', '4525', '4530', '4548', '4552', '4580', '4582', '4587', '4590', '4593', '4597', '4602', '4606', '4609', '4616', '4618', '4621', '4622', '4623', '4624', '4630', '4631', '4632', '4634', '4638', '4648', '4655', '4657', '4658', '4669', '4674', '4676', '4681', '4682', '4683', '4684', '4685', '4689', '4699', '4701', '4703', '4705', '4706', '4708', '4726', '4727', '4728', '4729', '4740', '4744', '4038', '4757', '4765', '4774', '4775', '4470', '3321', '4796', '4808', '4809', '4810', '4811', '4819', '4821', '4824', '4832', '4452', '4859', '4861', '4864', '4870', '4877', '4882', '4890', '4891', '4897', '4902', '4915', '4906', '4921', '4928', '4933', '4939', '4927', '4948', '4958', '4960', '4962', '4966', '4996', '4998', '5011', '5038', '4456', '5062', '5065', '5066', '5067', '5068', '5073', '5077', '5096', '5122', '5136', '5149', '5152', '5164', '5186', '5187', '5188', '5192', '5201', '4450', '4449', '5232', '5236', '5241', '5245', '5248', '5250', '5306', '5315', '5324', '5333', '5337', '5114', '5347', '5360', '5361', '5362', '5365', '5367', '5386', '5387', '5388', '5395', '5396', '5397', '5400', '5401', '5406', '5409', '5411', '5413', '5416', '5418', '5419', '5422', '5425', '5428', '5429', '5434', '5437', '5453', '5456', '5461', '5463', '5471', '5473', '5475', '5476', '5477', '5479', '5483', '5497', '5501', '5506', '5517', '5518', '5523', '5525', '5526', '5529', '5533', '5538', '5544', '5545', '5546', '5548', '5556', '5557', '5559', '5560', '5569', '5562', '5570', '5580', '5582', '4721', '5537', '5539', '5536', '5527', '5528', '5531', '5625', '5628', '5630', '5636', '5637', '5638', '5639', '5640', '5645', '5647', '5665', '5681', '5687', '5701', '5708', '5711', '4404', '5720', '5722', '5732', '5733', '5746', '5749', '5753', '5757', '5768', '5770', '5773', '5776', '5534', '5783', '5785', '5793', '5797', '5798', '5804', '5808', '5810', '5812', '5815', '5817', '5819', '5822', '5824', '5827', '5829', '5831', '5833', '5835', '5838', '5841', '5844', '5846', '5848', '5853', '5857', '5860', '5864', '5865', '5866', '5868', '5870', '5608', '4431', '5878', '5880', '5882', '5883', '5887', '5888', '5900', '5907', '5541', '5915', '5924', '5927', '5932', '5941', '5943', '5947', '5957', '5959', '5962', '5963', '5966', '5971', '5972', '5973', '5974', '5984', '5985', '5986', '6000', '6003', '6009', '6021', '6022', '6030', '6039', '6043', '6050', '6051', '6055', '6061', '6062', '6068', '6071', '6074', '6078', '6082', '6086', '6091', '6097', '6104', '6112', '6117', '6124', '6125', '6127', '5970', '6133', '6138', '6137', '6144', '6145', '6147', '6149', '6152', '6157', '6162', '6163', '6164', '6165', '6166', '6168', '6175', '6217', '6185', '6186', '6190', '6192', '6193', '6194', '6196', '6198', '6199', '6201', '6202', '6207', '6208', '6209', '6211', '6213', '6220', '6222', '6225', '6226', '5782', '6230', '6231', '6232', '6233', '6234', '6463', '6239', '6240', '6402', '6242', '6243', '6244', '6245', '6246', '6247', '6248', '6250', '6654', '6252', '6253', '6254', '6255', '6257', '6258', '6261', '6264', '6268', '6272', '6278', '6283', '6285', '6290', '6291', '6294', '6296', '6298', '6299', '6303', '6308', '6088', '6314', '6315', '6320', '6321', '6323', '6324', '6325', '6327', '6328', '6329', '6330', '6335', '6336', '6337', '6341', '6346', '6348', '6350', '6353', '6355', '6358', '6361', '6364', '6237', '6367', '6369', '6372', '6373', '6374', '5591', '6382', '6383', '6395', '6396', '6397', '6398', '6401', '6407', '6390', '6413', '6415', '6418', '6420', '6423', '6427', '6432', '6434', '6439', '6440', '6447', '6448', '6449', '6450', '6459', '6406', '6493', '6495', '6498', '6502', '6504', '6507', '6510', '5532', '6519', '6528', '6532', '6535', '6538', '6542', '6545', '6549', '6550', '6551', '6552', '6553', '6556', '6559', '6562', '6563', '6569', '6571', '6575', '6576', '6580', '6581', '6582', '6583', '6589', '6591', '6593', '6597', '6601', '6605', '6608', '6612', '6615', '6619', '6629', '6631', '6643', '6648', '6649', '6657', '6658', '6659', '6660', '6666', '6667', '6668', '6669', '6670', '6671', '6673', '6674', '6675', '6683', '6684', '6685', '6686', '6692', '6693', '6694', '6695', '6698', '6701', '6704', '6705', '6707', '6711', '6714', '6718', '6720', '6722', '6724', '6726', '6728', '6731', '6734', '6736', '6740', '6744', '6746', '6749', '6752', '6755', '6759', '6763', '6766', '6768', '6771', '6775', '6781', '6783', '6785', '6788', '6795', '6797', '6799', '6800', '6802', '6805', '6808', '6812', '6814', '6816', '6817', '6820', '6823', '6824', '6825', '6826', '6827', '6828', '6829', '6830', '6831', '6832', '6833', '6834', '6835', '6836', '6837', '6838', '6839', '6842', '6845', '6846', '6849', '6851', '6853', '6856', '6859', '6861', '6866', '6868', '6871', '6872', '6873', '6875', '6876', '6877', '6878', '6879', '6880', '6881', '6882', '6883', '6884', '6885', '6888', '6891', '6892', '6359', '6894', '6344', '6345', '6900', '6904', '6906') AND (`pr_is_acc` = 1 OR ((`pr_is_acc` = 0 OR `pr_is_acc` IS NULL) AND (`pr_acc_product` IS NULL OR `pr_acc_product` = ''))) AND `pr_enabled` = 1 LIMIT 20 OFFSET -20 ]

MODPATH/var/www/vhosts/wakeshop.eu/httpdocs/core/mysqli/classes/Database/MySQLi.php [ 175 ]

170 			{
171 				// This benchmark is worthless
172 				Profiler::delete($benchmark);
173 			}
174 
175 			throw new Database_Exception(':error [ :query ]',
176 				array(':error' => mysqli_error($this->_connection), ':query' => $sql),
177 				mysqli_errno($this->_connection));
178 		}
179 
180 		if (isset($benchmark))
  1. MODPATH/var/www/vhosts/wakeshop.eu/httpdocs/core/database/classes/Kohana/Database/Query.php [ 251 ] » Database_MySQLi->query(arguments)

  2. MODPATH/var/www/vhosts/wakeshop.eu/httpdocs/core/orm/classes/Kohana/ORM.php [ 1060 ] » Kohana_Database_Query->execute(arguments)

  3. MODPATH/var/www/vhosts/wakeshop.eu/httpdocs/core/orm/classes/Kohana/ORM.php [ 1001 ] » Kohana_ORM->_load_result(arguments)

  4. MODPATH/var/www/vhosts/wakeshop.eu/httpdocs/core/orm/classes/Traits/ORM/Searchable.php [ 156 ] » Kohana_ORM->find_all()

  5. MODPATH/var/www/vhosts/wakeshop.eu/httpdocs/core/orm/classes/Traits/ORM/Searchable.php [ 140 ] » ORM->findAllRecords(arguments)

  6. MODPATH/var/www/vhosts/wakeshop.eu/httpdocs/core/orm/classes/Traits/ORM/Searchable.php [ 263 ] » ORM->find_all(arguments)

  7. APPPATH/classes/Business/Products.php [ 460 ] » ORM->getForPage(arguments)

  8. APPPATH/classes/Controller/Products.php [ 42 ] » Business\Products->autocomplete(arguments)

  9. SYSPATH/classes/Controller.php [ 25 ] » Controller_Products->action_search()

  10. {PHP internal call} » Controller->execute()

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

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

  13. SYSPATH/classes/Request.php [ 85 ] » Kohana_Request_Client->execute(arguments)

  14. MODPATH/var/www/vhosts/wakeshop.eu/httpdocs/frontend/index.php [ 121 ] » Request->execute()

Environment