Kryptronic Software Support Forum

Hi Nick

Please can you look at this error which has started. Only happens if I go to Store>Catalog>Product Offers and click Add Item

Script Execution Error
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 'ORDER BY sortorder ASC' at line 1
File: /core-private/core/CORE_DB/ext/mysqli.php Line: 963 Error Number: 256

Debug report:
CORE_Display::load_object: Cached object returned: CORE_DB_1 Class: CORE_DB

CORE_DB_mysqli::xsql_do: The MySQLi extension executed statement: SELECT cid, cname, cdescription FROM core_columndefs WHERE cid LIKE 'ecom_pricemap.%' ORDER BY cid ASC

CORE_DB_mysqli::xsql_do: The MySQLi extension executed statement: SELECT selectid, selectname, selectvalue FROM core_selectcustom WHERE selectid='core.taxstateprov' OR selectid='core.taxcountry' OR selectid='core.taxclass' ORDER BY selectorder ASC

CORE_Error::error: Fatal error encountered: 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 'ORDER BY sortorder ASC' at line 1


Happens in both live and test site. I have swapped back to the standard code files, cleared product, inventory and pricemap tables, and reloaded database definitions.
Still get same error.
I can clone a product and save it correctly, so I can get around the error. I have also checked and it doesn't happen if I add a new category or new inventory item.

Thanks
Rob

Last edited by zanart (05-27-2024 08:05:41)