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

INSERT INTO cscart_logs (`user_id`, `timestamp`, `type`, `action`, `event_type`, `content`, `backtrace`, `company_id`) VALUES (0, 1772238459, '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=3&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:7837:"{"status":"success","data":{"products":[{"id":"393831","product_id":393831,"price":45,"list_price":645,"amount":44,"weight":0.5,"status":"A","product_code":"BIG100044","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1766040999,"updated_timestamp":1766040998,"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 100044","full_description_ar":"Bulk product description 100044","product":"Bulk Product 100044","product_str":"Bulk Product 100044","_version_":1852183765557706754,"score":1},{"id":"393833","product_id":393833,"price":47,"list_price":647,"amount":46,"weight":0.5,"status":"A","product_code":"BIG100046","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1766040999,"updated_timestamp":1766040998,"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 100046","full_description_ar":"Bulk product description 100046","product":"Bulk Product 100046","product_str":"Bulk Product 100046","_version_":1852183765557706755,"score":1},{"id":"393835","product_id":393835,"price":49,"list_price":649,"amount":48,"weight":0.5,"status":"A","product_code":"BIG100048","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1766040999,"updated_timestamp":1766040998,"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 100048","full_description_ar":"Bulk product description 100048","product":"Bulk Product 100048","product_str":"Bulk Product 100048","_version_":1852183765575532544,"score":1},{"id":"393292","product_id":393292,"price":6,"list_price":206,"amount":5,"weight":0.5,"status":"D","product_code":"BIG10005","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 10005","full_description_ar":"Bulk product description 10005","product":"Bulk Product 10005","product_str":"Bulk Product 10005","full_description":"Bulk product description 10005","_version_":1851730827332812800,"score":1},{"id":"393837","product_id":393837,"price":51,"list_price":651,"amount":50,"weight":0.5,"status":"A","product_code":"BIG100050","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1766040999,"updated_timestamp":1766040998,"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 100050","full_description_ar":"Bulk product description 100050","product":"Bulk Product 100050","product_str":"Bulk Product 100050","_version_":1852183765575532545,"score":1},{"id":"393839","product_id":393839,"price":53,"list_price":653,"amount":52,"weight":0.5,"status":"A","product_code":"BIG100052","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1766040999,"updated_timestamp":1766040998,"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 100052","full_description_ar":"Bulk product description 100052","product":"Bulk Product 100052","product_str":"Bulk Product 100052","_version_":1852183765576581120,"score":1},{"id":"393841","product_id":393841,"price":55,"list_price":655,"amount":54,"weight":0.5,"status":"A","product_code":"BIG100054","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1766040999,"updated_timestamp":1766040998,"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 100054","full_description_ar":"Bulk product description 100054","product":"Bulk Product 100054","product_str":"Bulk Product 100054","_version_":1852183765576581121,"score":1},{"id":"393843","product_id":393843,"price":57,"list_price":657,"amount":56,"weight":0.5,"status":"A","product_code":"BIG100056","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1766040999,"updated_timestamp":1766040998,"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 100056","full_description_ar":"Bulk product description 100056","product":"Bulk Product 100056","product_str":"Bulk Product 100056","_version_":1852183765595455488,"score":1},{"id":"393845","product_id":393845,"price":59,"list_price":659,"amount":58,"weight":0.5,"status":"A","product_code":"BIG100058","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1766040999,"updated_timestamp":1766040998,"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 100058","full_description_ar":"Bulk product description 100058","product":"Bulk Product 100058","product_str":"Bulk Product 100058","_version_":1852183765595455489,"score":1},{"id":"393293","product_id":393293,"price":7,"list_price":207,"amount":6,"weight":0.5,"status":"A","product_code":"BIG10006","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 10006","full_description_ar":"Bulk product description 10006","product":"Bulk Product 10006","product_str":"Bulk Product 10006","full_description":"Bulk product description 10006","_version_":1851730831752560640,"score":1},{"id":"393847","product_id":393847,"price":61,"list_price":661,"amount":60,"weight":0.5,"status":"A","product_code":"BIG100060","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1766040999,"updated_timestamp":1766040998,"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 100060","full_description_ar":"Bulk product description 100060","product":"Bulk Product 100060","product_str":"Bulk Product 100060","_version_":1852183765596504064,"score":1},{"id":"393849","product_id":393849,"price":63,"list_price":663,"amount":62,"weight":0.5,"status":"A","product_code":"BIG100062","company_id":1,"category_ids":480,"main_category":480,"average_rating":0,"reviews_count":0,"timestamp":1766040999,"updated_timestamp":1766040998,"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 100062","full_description_ar":"Bulk product description 100062","product":"Bulk Product 100062","product_str":"Bulk Product 100062","_version_":1852183765596504065,"score":1}],"search":{"numFound":79721,"start":24,"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