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, 1772196222, '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=499&company_ids%5B0%5D=1&company_ids%5B1%5D=2&company_ids%5B2%5D=5&access_key=test-zaid_core'";s:8:"response";s:8552:"{"status":"success","data":{"products":[{"id":"400950","product_id":400950,"price":567.1,"list_price":579.6,"amount":170,"weight":19.3,"status":"A","product_code":"FIR852906","company_id":1,"category_ids":499,"main_category":499,"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 Mixer 378","full_description_ar":"Air Mixer 378 \u2014 high quality, tested and ready to ship. Generated sample data for CS-Cart import.","product":"Air Mixer 378","product_str":"Air Mixer 378","_version_":1852183765410906112,"score":1},{"id":"400989","product_id":400989,"price":23.75,"list_price":29.17,"amount":154,"weight":5.06,"status":"A","product_code":"UXR143564","company_id":2,"category_ids":499,"main_category":499,"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":"Classic Watch 782","full_description_ar":"Classic Watch 782 \u2014 high quality, tested and ready to ship. Generated sample data for CS-Cart import.","product":"Classic Watch 782","product_str":"Classic Watch 782","_version_":1852199369013461001,"score":1},{"id":"401284","product_id":401284,"price":856.83,"list_price":933.06,"amount":35,"weight":12.34,"status":"A","product_code":"XUI107330","company_id":2,"category_ids":499,"main_category":499,"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":"Classic Watch 887","full_description_ar":"Classic Watch 887 \u2014 high quality, tested and ready to ship. Generated sample data for CS-Cart import.","product":"Classic Watch 887","product_str":"Classic Watch 887","_version_":1852199369014509568,"score":1},{"id":"400948","product_id":400948,"price":1345.02,"list_price":1434.1,"amount":178,"weight":22.03,"status":"A","product_code":"HIT049902","company_id":2,"category_ids":499,"main_category":499,"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":"Eco Chair 234","full_description_ar":"Eco Chair 234 \u2014 high quality, tested and ready to ship. Generated sample data for CS-Cart import.","product":"Eco Chair 234","product_str":"Eco Chair 234","_version_":1852199369014509572,"score":1},{"id":"401325","product_id":401325,"price":325.31,"list_price":353.25,"amount":386,"weight":13.47,"status":"A","product_code":"NSG505021","company_id":5,"category_ids":499,"main_category":499,"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":"Eco Sofa 460","full_description_ar":"Eco Sofa 460 \u2014 high quality, tested and ready to ship. Generated sample data for CS-Cart import.","product":"Eco Sofa 460","product_str":"Eco Sofa 460","_version_":1852199369308110849,"score":1},{"id":"400966","product_id":400966,"price":1340.57,"list_price":1413.03,"amount":13,"weight":23.23,"status":"A","product_code":"OFS716718","company_id":2,"category_ids":499,"main_category":499,"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 Mixer 584","full_description_ar":"Lite Mixer 584 \u2014 high quality, tested and ready to ship. Generated sample data for CS-Cart import.","product":"Lite Mixer 584","product_str":"Lite Mixer 584","_version_":1852199369328033792,"score":1},{"id":"400956","product_id":400956,"price":144.6,"list_price":184.68,"amount":98,"weight":10.57,"status":"A","product_code":"RII873344","company_id":1,"category_ids":499,"main_category":499,"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":"Lite Sofa 541","full_description_ar":"Lite Sofa 541 \u2014 high quality, tested and ready to ship. Generated sample data for CS-Cart import.","product":"Lite Sofa 541","product_str":"Lite Sofa 541","_version_":1852199371073912834,"score":1},{"id":"400938","product_id":400938,"price":131.74,"list_price":182.37,"amount":174,"weight":2.88,"status":"A","product_code":"JZN980765","company_id":2,"category_ids":499,"main_category":499,"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":"Max Book 710","full_description_ar":"Max Book 710 \u2014 high quality, tested and ready to ship. Generated sample data for CS-Cart import.","product":"Max Book 710","product_str":"Max Book 710","_version_":1852199371073912836,"score":1},{"id":"401283","product_id":401283,"price":1915.8,"list_price":2363.1,"amount":479,"weight":1.99,"status":"A","product_code":"CPJ768111","company_id":2,"category_ids":499,"main_category":499,"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":"Mini Bottle 825","full_description_ar":"Mini Bottle 825 \u2014 high quality, tested and ready to ship. Generated sample data for CS-Cart import.","product":"Mini Bottle 825","product_str":"Mini Bottle 825","_version_":1852199371369611264,"score":1},{"id":"401329","product_id":401329,"price":1850.95,"list_price":2558.77,"amount":392,"weight":14.59,"status":"A","product_code":"ZBZ359187","company_id":2,"category_ids":499,"main_category":499,"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":"Mini Bottle 859","full_description_ar":"Mini Bottle 859 \u2014 high quality, tested and ready to ship. Generated sample data for CS-Cart import.","product":"Mini Bottle 859","product_str":"Mini Bottle 859","_version_":1852199371372756992,"score":1},{"id":"400947","product_id":400947,"price":1724.33,"list_price":1900.44,"amount":366,"weight":7.92,"status":"A","product_code":"KYO500653","company_id":2,"category_ids":499,"main_category":499,"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 Camera 791","full_description_ar":"Pro Camera 791 \u2014 high quality, tested and ready to ship. Generated sample data for CS-Cart import.","product":"Pro Camera 791","product_str":"Pro Camera 791","_version_":1851952494216740868,"score":1},{"id":"401172","product_id":401172,"price":695.28,"list_price":883.09,"amount":144,"weight":0.72,"status":"A","product_code":"GQX208371","company_id":2,"category_ids":499,"main_category":499,"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":"Ultra Bottle 784","full_description_ar":"Ultra Bottle 784 \u2014 high quality, tested and ready to ship. Generated sample data for CS-Cart import.","product":"Ultra Bottle 784","product_str":"Ultra Bottle 784","_version_":1851952497876271105,"score":1}],"search":{"numFound":12,"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