Tygh\Exceptions\AException

Message

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 'dispatch=sg_solr_products.get_products&lang_code=en&items_per_page=12&page=1&...' at line 1 (1064)

INSERT INTO cscart_logs (`user_id`, `timestamp`, `type`, `action`, `event_type`, `content`, `backtrace`, `company_id`) VALUES (0, 1772195901, 'requests', 'http', 'N', 'a:3:{s:3:"url";s:34:"https://dev.ecartify.com/index.php";s:7:"request";s:215:"'dispatch=sg_solr_products.get_products&lang_code=en&items_per_page=12&page=1&sort_by=product&sort_order=asc&category_ids=166&company_ids%5B0%5D=1&company_ids%5B1%5D=2&company_ids%5B2%5D=5&access_key=test-zaid_core'";s:8:"response";s:7970:"{"status":"success","data":{"products":[{"id":"116545","product_id":116545,"price":95000,"list_price":415,"amount":10,"weight":0.5,"status":"A","product_code":"Apple0987","company_id":1,"category_ids":[166,298],"main_category":298,"average_rating":0,"reviews_count":0,"timestamp":1763675084,"updated_timestamp":1765538136,"product_type":"P","shipping_freight":0,"sales_amount":0,"length":0,"width":0,"height":0,"popularity":0,"free_shipping":"N","min_qty":0,"max_qty":0,"qty_step":0,"attr_18":"91","attr_549":"1200","attr_15":"39","attr_16":"77","attr_17":"48","product_ar":"Bulk Product 104714","full_description_ar":"Bulk product description 104714","product":"Apple 2025 MacBook Air (13-inch, Apple M4 chip with 10-core CPU and 8-core GPU, 16GB Unified Memory, 256GB) - Starlight","product_str":"Apple 2025 MacBook Air (13-inch, Apple M4 chip with 10-core CPU and 8-core GPU, 16GB Unified Memory, 256GB) - Starlight","_version_":1851640170228482048,"score":1},{"id":"391037","product_id":391037,"price":200006,"list_price":10007,"amount":10,"weight":0,"status":"A","product_code":"Mobiles001#010","company_id":1,"category_ids":[235,478,166],"main_category":166,"average_rating":0,"reviews_count":0,"timestamp":1765524963,"updated_timestamp":1765526006,"product_type":"P","shipping_freight":0,"sales_amount":0,"length":0,"width":0,"height":0,"popularity":0,"free_shipping":"N","min_qty":0,"max_qty":0,"qty_step":0,"attr_18":"91","attr_549":"1198","product_ar":"Apple iPhone 13 (128GB) - Green","product":"Apple iPhone 13 (128GB) - Green","product_str":"Apple iPhone 13 (128GB) - Green","_version_":1851640172585680896,"score":1},{"id":"391032","product_id":391032,"price":200001,"list_price":10002,"amount":10,"weight":0,"status":"A","product_code":"Mobiles001#005","company_id":1,"category_ids":[235,478,166],"main_category":166,"average_rating":0,"reviews_count":0,"timestamp":1765524963,"updated_timestamp":1765525916,"product_type":"P","shipping_freight":0,"sales_amount":0,"length":0,"width":0,"height":0,"popularity":0,"free_shipping":"N","min_qty":0,"max_qty":0,"qty_step":0,"attr_18":"91","product_ar":"Apple iPhone 14 (256 GB) - Starlight","product":"Apple iPhone 14 (256 GB) - Starlight","product_str":"Apple iPhone 14 (256 GB) - Starlight","_version_":1851640174057881600,"score":1},{"id":"391031","product_id":391031,"price":200000,"list_price":10001,"amount":10,"weight":0,"status":"A","product_code":"Mobiles001#004","company_id":1,"category_ids":[478,166],"main_category":166,"average_rating":0,"reviews_count":0,"timestamp":1765524963,"updated_timestamp":1765526712,"product_type":"P","shipping_freight":0,"sales_amount":0,"length":0,"width":0,"height":0,"popularity":0,"free_shipping":"N","min_qty":0,"max_qty":0,"qty_step":0,"attr_18":"91","product_ar":"Apple iPhone 15 (128 GB) - Green","product":"Apple iPhone 15 (128 GB)","product_str":"Apple iPhone 15 (128 GB)","_version_":1851640175408447488,"score":1},{"id":"391030","product_id":391030,"price":199999,"list_price":10000,"amount":10,"weight":0,"status":"A","product_code":"Mobiles001#003","company_id":1,"category_ids":[235,478,166],"main_category":166,"average_rating":0,"reviews_count":0,"timestamp":1765524963,"updated_timestamp":1765534406,"product_type":"P","shipping_freight":0,"sales_amount":0,"length":0,"width":0,"height":0,"popularity":0,"free_shipping":"N","min_qty":0,"max_qty":0,"qty_step":0,"attr_18":"91","attr_549":"1199","product_ar":"Apple iPhone 15 (128 GB) - Blue","product":"Apple iPhone 15 (128 GB) - Blue","product_str":"Apple iPhone 15 (128 GB) - Blue","_version_":1851640176859676672,"score":1},{"id":"12702","product_id":12702,"price":1999,"list_price":2499,"amount":0,"weight":0.9,"status":"A","product_code":"NP4008","company_id":1,"category_ids":166,"main_category":166,"average_rating":0,"reviews_count":0,"timestamp":1763556622,"updated_timestamp":1763556603,"product_type":"P","shipping_freight":0,"sales_amount":0,"length":0,"width":0,"height":0,"popularity":0,"min_qty":0,"max_qty":0,"qty_step":0,"free_shipping":"N","product_ar":"Gaming Keyboard","full_description_ar":"RGB gaming keyboard with fast response","product":"Gaming Keyboard","product_str":"Gaming Keyboard","_version_":1851156626033082370,"score":1},{"id":"312043","product_id":312043,"price":45.5,"list_price":60,"amount":0,"weight":0.8,"status":"A","product_code":"2P002","company_id":1,"category_ids":166,"main_category":166,"average_rating":0,"reviews_count":0,"timestamp":1764335665,"updated_timestamp":1764659305,"product_type":"P","shipping_freight":0,"sales_amount":0,"length":0,"width":0,"height":0,"popularity":0,"min_qty":0,"max_qty":0,"qty_step":0,"free_shipping":"N","product_ar":"Gaming Keyboard","full_description_ar":"Mechanical gaming keyboard with RGB","product":"Gaming Keyboard","product_str":"Gaming Keyboard","_version_":1851156626033082371,"score":1},{"id":"312051","product_id":312051,"price":150,"list_price":200,"amount":0,"weight":0.9,"status":"A","product_code":"P010","company_id":1,"category_ids":166,"main_category":166,"average_rating":0,"reviews_count":0,"timestamp":1764335665,"updated_timestamp":1764591352,"product_type":"P","shipping_freight":0,"sales_amount":0,"length":0,"width":0,"height":0,"popularity":0,"min_qty":0,"max_qty":0,"qty_step":0,"free_shipping":"N","product_ar":"Graphic Tablet","full_description_ar":"Digital graphic drawing tablet","product":"Graphic Tablet","product_str":"Graphic Tablet","_version_":1851156626034130949,"score":1},{"id":"312048","product_id":312048,"price":55,"list_price":70,"amount":0,"weight":0.4,"status":"A","product_code":"P007","company_id":1,"category_ids":166,"main_category":166,"average_rating":0,"reviews_count":0,"timestamp":1764335665,"updated_timestamp":1764591352,"product_type":"P","shipping_freight":0,"sales_amount":0,"length":0,"width":0,"height":0,"popularity":0,"min_qty":0,"max_qty":0,"qty_step":0,"free_shipping":"N","product_ar":"HD Webcam","full_description_ar":"1080p HD webcam for streaming","product":"HD Webcam","product_str":"HD Webcam","_version_":1851158136266686465,"score":1},{"id":"12712","product_id":12712,"price":1499,"list_price":1999,"amount":0,"weight":0.4,"status":"A","product_code":"NP40018","company_id":1,"category_ids":166,"main_category":166,"average_rating":0,"reviews_count":0,"timestamp":1763556622,"updated_timestamp":1763556603,"product_type":"P","shipping_freight":0,"sales_amount":0,"length":0,"width":0,"height":0,"popularity":0,"min_qty":0,"max_qty":0,"qty_step":0,"free_shipping":"N","product_ar":"Headphones","full_description_ar":"Comfort-fit wired headphones","product":"Headphones","product_str":"Headphones","_version_":1851158136266686466,"score":1},{"id":"12710","product_id":12710,"price":899,"list_price":1299,"amount":0,"weight":0.3,"status":"A","product_code":"NP40016","company_id":1,"category_ids":166,"main_category":166,"average_rating":0,"reviews_count":0,"timestamp":1763556622,"updated_timestamp":1763556603,"product_type":"P","shipping_freight":0,"sales_amount":0,"length":0,"width":0,"height":0,"popularity":0,"min_qty":0,"max_qty":0,"qty_step":0,"free_shipping":"N","product_ar":"Smart Plug","full_description_ar":"Smart plug that works with voice assistants","product":"Smart Plug","product_str":"Smart Plug","_version_":1851185563634237441,"score":1},{"id":"12698","product_id":12698,"price":2599,"list_price":2999,"amount":0,"weight":0.2,"status":"A","product_code":"NP4004","company_id":1,"category_ids":166,"main_category":166,"average_rating":0,"reviews_count":0,"timestamp":1763556622,"updated_timestamp":1763556603,"product_type":"P","shipping_freight":0,"sales_amount":0,"length":0,"width":0,"height":0,"popularity":0,"min_qty":0,"max_qty":0,"qty_step":0,"free_shipping":"N","product_ar":"Sports Watch","full_description_ar":"Sports watch with heart-rate sensor","product":"Sports Watch","product_str":"Sports Watch","_version_":1851185564971171844,"score":1}],"search":{"numFound":23,"start":0,"maxScore":1,"numFoundExact":true}}}";}', '', 0)

Error at

app/Tygh/Database/Connection.php, line: 1713

Backtrace

File:app/Tygh/Database/Connection.php
Line:1490
Function:throwError
File:app/Tygh/Database/Connection.php
Line:700
Function:execQuery
File:app/functions/fn.database.php
Line:138
Function:query
File:app/controllers/common/debugger.php
Line:63
Function:db_query
File:app/functions/fn.control.php
Line:729
Function:include
File:app/functions/fn.control.php
Line:460
Function:fn_run_controller
File:index.php
Line:19
Function:fn_dispatch