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, 1772212549, '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=245&company_ids%5B0%5D=1&company_ids%5B1%5D=2&company_ids%5B2%5D=5&access_key=test-zaid_core'";s:8:"response";s:8176:"{"status":"success","data":{"products":[{"id":"401338","product_id":401338,"price":0,"list_price":0,"amount":0,"weight":0,"status":"A","company_id":1,"category_ids":245,"main_category":0,"average_rating":0,"reviews_count":0,"timestamp":1766475163,"updated_timestamp":1766475163,"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":"Coffee","product_str":"Coffee","product_ar":"Coffee","_version_":1852283461869502464,"score":1},{"id":"390936","product_id":390936,"price":180,"list_price":0.5,"amount":20,"weight":0,"status":"A","product_code":"Test XERO- 004","company_id":1,"category_ids":245,"main_category":0,"average_rating":0,"reviews_count":0,"timestamp":1765367523,"updated_timestamp":1765524441,"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":"DWH Wireless video games for tv gaming Retro gaming console with Game Stick 1080p Plug & Play TV Video Game Set for 2 player with 9Emulator for Kids & Old School Station Video Game","product":"DWH Wireless video games for tv gaming Retro gaming console with Game Stick 1080p Plug & Play TV Video Game Set for 2 player with 9Emulator for Kids & Old School Station Video Game","product_str":"DWH Wireless video games for tv gaming Retro gaming console with Game Stick 1080p Plug & Play TV Video Game Set for 2 player with 9Emulator for Kids & Old School Station Video Game","_version_":1851286558158618624,"score":1},{"id":"390935","product_id":390935,"price":180,"list_price":0.5,"amount":20,"weight":0,"status":"A","product_code":"Test XERO- 003","company_id":1,"category_ids":245,"main_category":0,"average_rating":0,"reviews_count":0,"timestamp":1765367523,"updated_timestamp":1765524453,"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":"Edition Wireless for TV HDMI Gaming Plug & Play Video Game 4K HD Game Stick| Wireless Stick with Game Built-in 21,000+ Games & 64Gb, (First Edition)","product":"Edition Wireless for TV HDMI Gaming Plug & Play Video Game 4K HD Game Stick| Wireless Stick with Game Built-in 21,000+ Games & 64Gb, (First Edition)","product_str":"Edition Wireless for TV HDMI Gaming Plug & Play Video Game 4K HD Game Stick| Wireless Stick with Game Built-in 21,000+ Games & 64Gb, (First Edition)","_version_":1851286570728947712,"score":1},{"id":"390934","product_id":390934,"price":180,"list_price":0.5,"amount":20,"weight":0,"status":"A","product_code":"Test XERO- 002","company_id":1,"category_ids":245,"main_category":0,"average_rating":0,"reviews_count":0,"timestamp":1765367523,"updated_timestamp":1765524503,"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":"Edition Wireless for TV HDMI Gaming Plug & Play Video Game 4K HD Game Stick| Wireless Stick with Game Built-in 21,000+ Games & 64Gb, (Standard Edition)","product":"Edition Wireless for TV HDMI Gaming Plug & Play Video Game 4K HD Game Stick| Wireless Stick with Game Built-in 21,000+ Games & 64Gb, (Standard Edition)","product_str":"Edition Wireless for TV HDMI Gaming Plug & Play Video Game 4K HD Game Stick| Wireless Stick with Game Built-in 21,000+ Games & 64Gb, (Standard Edition)","_version_":1851286623617024000,"score":1},{"id":"400927","product_id":400927,"price":0,"list_price":0,"amount":0,"weight":0,"status":"A","company_id":5,"category_ids":245,"main_category":0,"average_rating":0,"reviews_count":0,"timestamp":1766061248,"updated_timestamp":1766061248,"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":"Just for testing five","product":"Just for testing five","product_str":"Just for testing five","_version_":1851849442045460480,"score":1},{"id":"390937","product_id":390937,"price":180,"list_price":0.5,"amount":20,"weight":0,"status":"A","product_code":"Test XERO- 005","company_id":1,"category_ids":245,"main_category":0,"average_rating":0,"reviews_count":0,"timestamp":1765367523,"updated_timestamp":1765524543,"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":"Video Game - 0098","product":"Video Game - 0098","product_str":"Video Game - 0098","_version_":1851286664829206528,"score":1},{"id":"390938","product_id":390938,"price":180,"list_price":0.5,"amount":20,"weight":0,"status":"A","product_code":"Test XERO- 006","company_id":1,"category_ids":245,"main_category":0,"average_rating":0,"reviews_count":0,"timestamp":1765367523,"updated_timestamp":1765524578,"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":"Video Game - 0099","product":"Video Game - 0099","product_str":"Video Game - 0099","_version_":1851286701784170496,"score":1},{"id":"390939","product_id":390939,"price":180,"list_price":0.5,"amount":20,"weight":0,"status":"A","product_code":"Test XERO- 007","company_id":1,"category_ids":245,"main_category":0,"average_rating":0,"reviews_count":0,"timestamp":1765367523,"updated_timestamp":1765524606,"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":"Video Game - 0100","product":"Video Game - 0100","product_str":"Video Game - 0100","_version_":1851286731954847744,"score":1},{"id":"390971","product_id":390971,"price":180,"list_price":0.5,"amount":26,"weight":0,"product_code":"Test XERO- 039","company_id":1,"category_ids":245,"main_category":0,"average_rating":0,"reviews_count":0,"timestamp":1765367523,"updated_timestamp":1765524593,"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":"Video Game - 0132","product":"Video Game - 0132","product_str":"Video Game - 0132","_version_":1851286717821091840,"score":1},{"id":"390972","product_id":390972,"price":180,"list_price":0.5,"amount":27,"weight":0,"product_code":"Test XERO- 040","company_id":1,"category_ids":245,"main_category":0,"average_rating":0,"reviews_count":0,"timestamp":1765367523,"updated_timestamp":1765368198,"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":"Video Game - 0133","product":"Video Game - 0133","product_str":"Video Game - 0133","_version_":1851122726057541632,"score":1},{"id":"390933","product_id":390933,"price":180,"list_price":0.5,"amount":20,"weight":0,"status":"A","product_code":"Test XERO- 001","company_id":1,"category_ids":245,"main_category":0,"average_rating":0,"reviews_count":0,"timestamp":1765367523,"updated_timestamp":1765438851,"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":"Wireless for TV HDMI Gaming Plug & Play Video Game 4K HD Game Stick| Wireless Stick with Game Built-in 21,000+ Games","product":"Wireless for TV HDMI Gaming Plug & Play Video Game 4K HD Game Stick| Wireless Stick with Game Built-in 21,000+ Games","product_str":"Wireless for TV HDMI Gaming Plug & Play Video Game 4K HD Game Stick| Wireless Stick with Game Built-in 21,000+ Games","_version_":1851196810482155520,"score":1},{"id":"401333","product_id":401333,"price":0,"list_price":0,"amount":0,"weight":0,"status":"A","company_id":5,"category_ids":245,"main_category":0,"average_rating":0,"reviews_count":0,"timestamp":1766383375,"updated_timestamp":1766383375,"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":"cap","product":"cap","product_str":"cap","_version_":1852187217062002688,"score":1}],"search":{"numFound":18,"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