View Single Post
  #361  
Old 08-05-2012, 10:52 AM
 
kevbentz kevbentz is offline
 

Member
  
Join Date: Dec 2011
Posts: 15
 

Default Re: X-Cart Ability Template v4.4.x

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
__________________
X-Cart 5.3.6
Reply With Quote