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, 1772195982, '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=286&company_ids%5B0%5D=1&company_ids%5B1%5D=2&company_ids%5B2%5D=5&access_key=test-zaid_core'";s:8:"response";s:8348:"{"status":"success","data":{"products":[{"id":"400946","product_id":400946,"price":383.85,"list_price":568.25,"amount":41,"weight":21.3,"status":"A","product_code":"FBT030495","company_id":2,"category_ids":286,"main_category":286,"average_rating":0,"reviews_count":0,"timestamp":1766144404,"updated_timestamp":1766144577,"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":"Air Drone 258","full_description_ar":"Air Drone 258 \u2014 high quality, tested and ready to ship. Generated sample data for CS-Cart import.","product":"Air Drone 258","product_str":"Air Drone 258","_version_":1852183765408808961,"score":1},{"id":"400983","product_id":400983,"price":385.27,"list_price":439.75,"amount":152,"weight":20.95,"status":"A","product_code":"PTD078372","company_id":5,"category_ids":286,"main_category":286,"average_rating":0,"reviews_count":0,"timestamp":1766144404,"updated_timestamp":1766144644,"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":"Air Mixer 492","full_description_ar":"Air Mixer 492 \u2014 high quality, tested and ready to ship. Generated sample data for CS-Cart import.","product":"Air Mixer 492","product_str":"Air Mixer 492","_version_":1852183765410906113,"score":1},{"id":"401173","product_id":401173,"price":1606.62,"list_price":2110.24,"amount":107,"weight":16.79,"status":"A","product_code":"LBX159195","company_id":5,"category_ids":286,"main_category":286,"average_rating":0,"reviews_count":0,"timestamp":1766144439,"updated_timestamp":1766145142,"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":"Air Sofa 626","full_description_ar":"Air Sofa 626 \u2014 high quality, tested and ready to ship. Generated sample data for CS-Cart import.","product":"Air Sofa 626","product_str":"Air Sofa 626","_version_":1852183765411954690,"score":1},{"id":"401141","product_id":401141,"price":132.35,"list_price":185.65,"amount":410,"weight":20.27,"status":"A","product_code":"ZQW278217","company_id":2,"category_ids":286,"main_category":286,"average_rating":0,"reviews_count":0,"timestamp":1766144439,"updated_timestamp":1766145016,"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":"Eco Bottle 593","full_description_ar":"Eco Bottle 593 \u2014 high quality, tested and ready to ship. Generated sample data for CS-Cart import.","product":"Eco Bottle 593","product_str":"Eco Bottle 593","_version_":1852199369014509569,"score":1},{"id":"400973","product_id":400973,"price":608.02,"list_price":782.54,"amount":240,"weight":12.02,"status":"A","product_code":"SDB029671","company_id":1,"category_ids":286,"main_category":286,"average_rating":0,"reviews_count":0,"timestamp":1766144404,"updated_timestamp":1766144644,"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":"Lite Sofa 283","full_description_ar":"Lite Sofa 283 \u2014 high quality, tested and ready to ship. Generated sample data for CS-Cart import.","product":"Lite Sofa 283","product_str":"Lite Sofa 283","_version_":1852199371072864256,"score":1},{"id":"401250","product_id":401250,"price":293.49,"list_price":384.85,"amount":129,"weight":0.4,"status":"A","product_code":"TBI792189","company_id":5,"category_ids":286,"main_category":286,"average_rating":0,"reviews_count":0,"timestamp":1766144456,"updated_timestamp":1766144403,"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":"Max Shirt 989","full_description_ar":"Max Shirt 989 \u2014 high quality, tested and ready to ship. Generated sample data for CS-Cart import.","product":"Max Shirt 989","product_str":"Max Shirt 989","_version_":1852199371074961417,"score":1},{"id":"400955","product_id":400955,"price":221.26,"list_price":278.78,"amount":412,"weight":13.51,"status":"A","product_code":"LSI653527","company_id":5,"category_ids":286,"main_category":286,"average_rating":0,"reviews_count":0,"timestamp":1766144404,"updated_timestamp":1766144577,"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":"Mini Watch 139","full_description_ar":"Mini Watch 139 \u2014 high quality, tested and ready to ship. Generated sample data for CS-Cart import.","product":"Mini Watch 139","product_str":"Mini Watch 139","_version_":1852199371396874241,"score":1},{"id":"400932","product_id":400932,"price":553.68,"list_price":709.06,"amount":366,"weight":16.28,"status":"A","product_code":"FTR804025","company_id":2,"category_ids":286,"main_category":286,"average_rating":0,"reviews_count":0,"timestamp":1766144404,"updated_timestamp":1766144577,"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":"Pro Phone 859","full_description_ar":"Pro Phone 859 \u2014 high quality, tested and ready to ship. Generated sample data for CS-Cart import.","product":"Pro Phone 859","product_str":"Pro Phone 859","_version_":1851952494583742464,"score":1},{"id":"401050","product_id":401050,"price":1765.08,"list_price":2028.42,"amount":308,"weight":2.77,"status":"A","product_code":"EXZ349998","company_id":2,"category_ids":286,"main_category":286,"average_rating":0,"reviews_count":0,"timestamp":1766144423,"updated_timestamp":1766144767,"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":"Ultra Shirt 527","full_description_ar":"Ultra Shirt 527 \u2014 high quality, tested and ready to ship. Generated sample data for CS-Cart import.","product":"Ultra Shirt 527","product_str":"Ultra Shirt 527","_version_":1852208048579280898,"score":1},{"id":"21914","product_id":21914,"price":65000,"list_price":201,"amount":0,"weight":0.5,"status":"A","product_code":"Pinkphone022#2345","company_id":1,"category_ids":[286,166],"main_category":166,"average_rating":0,"reviews_count":0,"timestamp":1763567708,"updated_timestamp":1764761195,"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","attr_18":"91","attr_549":"1244","attr_548":"1195","attr_15":"39","product_ar":"Bulk Product 10000","full_description_ar":"Bulk product description 10000","product":"iPhone 16 128 GB: 5G Mobile Phone with Camera Control, A18 Chip and a Big Boost in Battery Life. Works with AirPods; Pink","product_str":"iPhone 16 128 GB: 5G Mobile Phone with Camera Control, A18 Chip and a Big Boost in Battery Life. Works with AirPods; Pink","_version_":1851158136622153728,"score":1},{"id":"116547","product_id":116547,"price":21700,"list_price":417,"amount":0,"weight":0.5,"status":"A","product_code":"BIG104716","company_id":1,"category_ids":[166,286],"main_category":286,"average_rating":0,"reviews_count":0,"timestamp":1763675084,"updated_timestamp":1764761480,"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","attr_18":"91","attr_549":"1211","product_ar":"Bulk Product 104716","full_description_ar":"Bulk product description 104716","product":"iPhone 17 Pro Max 256 GB: 17.42 cm (6.9\u2033) Display with Promotion, A19 Pro Chip, Best Battery Life in Any iPhone Ever, Pro Fusion Camera System, Center Stage Front Camera; Cosmic Orange","product_str":"iPhone 17 Pro Max 256 GB: 17.42 cm (6.9\u2033) Display with Promotion, A19 Pro Chip, Best Battery Life in Any iPhone Ever, Pro Fusion Camera System, Center Stage Front Camera; Cosmic Orange","_version_":1851158136622153729,"score":1}],"search":{"numFound":11,"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