I started getting this error:
SQL query : select categoryid, category from xcart_categories where categoryid in () order by category
Error code : 1064
Description : 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 category' at line 1
Request URI: /cart.php?mode=add&productid=137164&amount=1
Backtrace:
/include/func/func.db.php:303
/include/func/func.db.php:203
/include/func/func.db.php:483
/ability_minicart_content.php:33
/include/common.php:98 /cart.php:614
-------------------------------------------------
This particular query is found in ability_minicart_content.php on line 33:
Code:
$cart_categories1 = func_query("select categoryid, category from $sql_tbl[categories] where categoryid in (".$cat_list.") order by category");
I'm by no means an expert, so I can't figure out what is causing this but it appears to be something in the ".$cat_list." as indicated by the error:
Code:
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 category' at line 1
I'm running MySQL 5.1.
Thank you