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=14...' at line 1 (1064)

INSERT INTO cscart_logs (`user_id`, `timestamp`, `type`, `action`, `event_type`, `content`, `backtrace`, `company_id`) VALUES (0, 1772249460, 'requests', 'http', 'N', 'a:3:{s:3:"url";s:34:"https://dev.ecartify.com/index.php";s:7:"request";s:216:"'dispatch=sg_solr_products.get_products&lang_code=en&items_per_page=12&page=14&sort_by=product&sort_order=asc&category_ids=480&company_ids%5B0%5D=1&company_ids%5B1%5D=2&company_ids%5B2%5D=5&access_key=test-zaid_core'";s:8:"response";s:7852:"{"status":"success","data":{"products":[{"id":"394051","product_id":394051,"price":265,"list_price":165,"amount":64,"weight":0.5,"status":"A","product_code":"BIG100264","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1766041191,"updated_timestamp":1766041127,"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":"Bulk Product 100264","full_description_ar":"Bulk product description 100264","product":"Bulk Product 100264","product_str":"Bulk Product 100264","_version_":1851921286898384896,"score":1},{"id":"394053","product_id":394053,"price":267,"list_price":167,"amount":66,"weight":0.5,"status":"A","product_code":"BIG100266","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1766041191,"updated_timestamp":1766041127,"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":"Bulk Product 100266","full_description_ar":"Bulk product description 100266","product":"Bulk Product 100266","product_str":"Bulk Product 100266","_version_":1851921286898384897,"score":1},{"id":"394055","product_id":394055,"price":269,"list_price":169,"amount":68,"weight":0.5,"status":"A","product_code":"BIG100268","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1766041191,"updated_timestamp":1766041127,"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":"Bulk Product 100268","full_description_ar":"Bulk product description 100268","product":"Bulk Product 100268","product_str":"Bulk Product 100268","_version_":1851921286904676352,"score":1},{"id":"393314","product_id":393314,"price":28,"list_price":228,"amount":27,"weight":0.5,"status":"D","product_code":"BIG10027","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1765887450,"updated_timestamp":1765887449,"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,"product_ar":"Bulk Product 10027","full_description_ar":"Bulk product description 10027","product":"Bulk Product 10027","product_str":"Bulk Product 10027","full_description":"Bulk product description 10027","_version_":1851754385595432960,"score":1},{"id":"394057","product_id":394057,"price":271,"list_price":171,"amount":70,"weight":0.5,"status":"A","product_code":"BIG100270","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1766041191,"updated_timestamp":1766041127,"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":"Bulk Product 100270","full_description_ar":"Bulk product description 100270","product":"Bulk Product 100270","product_str":"Bulk Product 100270","_version_":1851921286905724928,"score":1},{"id":"394059","product_id":394059,"price":273,"list_price":173,"amount":72,"weight":0.5,"status":"A","product_code":"BIG100272","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1766041191,"updated_timestamp":1766041127,"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":"Bulk Product 100272","full_description_ar":"Bulk product description 100272","product":"Bulk Product 100272","product_str":"Bulk Product 100272","_version_":1851921286906773504,"score":1},{"id":"394062","product_id":394062,"price":275,"list_price":175,"amount":74,"weight":0.5,"status":"A","product_code":"BIG100274","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1766041259,"updated_timestamp":1766041258,"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":"Bulk Product 100274","full_description_ar":"Bulk product description 100274","product":"Bulk Product 100274","product_str":"Bulk Product 100274","_version_":1851921286906773505,"score":1},{"id":"394064","product_id":394064,"price":277,"list_price":177,"amount":76,"weight":0.5,"status":"A","product_code":"BIG100276","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1766041259,"updated_timestamp":1766041258,"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":"Bulk Product 100276","full_description_ar":"Bulk product description 100276","product":"Bulk Product 100276","product_str":"Bulk Product 100276","_version_":1851921286923550720,"score":1},{"id":"394066","product_id":394066,"price":279,"list_price":179,"amount":78,"weight":0.5,"status":"A","product_code":"BIG100278","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1766041259,"updated_timestamp":1766041258,"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":"Bulk Product 100278","full_description_ar":"Bulk product description 100278","product":"Bulk Product 100278","product_str":"Bulk Product 100278","_version_":1851921286924599296,"score":1},{"id":"393315","product_id":393315,"price":29,"list_price":229,"amount":28,"weight":0.5,"status":"A","product_code":"BIG10028","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1765887450,"updated_timestamp":1765887449,"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,"product_ar":"Bulk Product 10028","full_description_ar":"Bulk product description 10028","product":"Bulk Product 10028","product_str":"Bulk Product 10028","full_description":"Bulk product description 10028","_version_":1851754387067633664,"score":1},{"id":"394068","product_id":394068,"price":281,"list_price":181,"amount":80,"weight":0.5,"status":"A","product_code":"BIG100280","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1766041259,"updated_timestamp":1766041258,"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":"Bulk Product 100280","full_description_ar":"Bulk product description 100280","product":"Bulk Product 100280","product_str":"Bulk Product 100280","_version_":1851921286924599297,"score":1},{"id":"394070","product_id":394070,"price":283,"list_price":183,"amount":82,"weight":0.5,"status":"A","product_code":"BIG100282","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1766041259,"updated_timestamp":1766041258,"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":"Bulk Product 100282","full_description_ar":"Bulk product description 100282","product":"Bulk Product 100282","product_str":"Bulk Product 100282","_version_":1851921286925647872,"score":1}],"search":{"numFound":79721,"start":156,"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