getting problem in product search suggestions

[VirtualSpy]

laravel version 9.48.0 , Aimeos version 2022.10.4 and PHP version 8.1.3 (Win)

i am getting this error many times in console from product search suggestions

Code: Select all

Uncaught (in promise) SyntaxError: Unexpected token '<', "<div class"... is not valid JSON

and getting this in admin log

Code: Select all

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-9 OFFSET 0' at line 7:
SELECT mpro."id"
FROM "mshop_product" mpro
LEFT JOIN "mshop_index_catalog" AS mindca USE INDEX ("idx_msindca_s_ca_lt_po", "unq_msindca_p_s_cid_lt_po") ON mindca."prodid" = mpro."id"
WHERE ( ( mpro."siteid" IN ('','1.') ) AND ( mindca."catid" IS NOT NULL AND mpro."label" LIKE 'hot%' ESCAPE '#' AND ( ( mpro."status" = 1 ) AND ( mpro."type" = 'event' OR mpro."start" IS NULL OR mpro."start" = '2023-02-27 12:26:00' ) ) ) )
GROUP BY mpro."id"
ORDER BY mpro."id" ASC
LIMIT -9 OFFSET 0

[aimeos]

i am getting this error many times in console from product search suggestions

Code: Select all

Uncaught (in promise) SyntaxError: Unexpected token '<', "<div class"... is not valid JSON

Seems like you are either querying the wrong URL or more likely that it's an error page which contains debug/error details.

and getting this in admin log

Code: Select all

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-9 OFFSET 0' at line 7:
LIMIT -9 OFFSET 0

"-9" is not a valid LIMIT value MySQL accepts.