Quote:
|
Originally Posted by kevbentz
I've edited the code and the error went away...
code should read:
Code:
$cart_categories1 = func_query("select categoryid, category from $sql_tbl[categories] where categoryid in ('".$cat_list."') order by category");
|
I am also getting the 1064 error from ability_minicart_content.php. However when I try and edit the php file to make the correction that kevenbentz identified it looks like it is encrypted so I can't edit it to manually correct the syntax......
I am on version 1.03 of Ability - don't particular want to have to re-install the whole thing if I can help it.
Any ideas how I should proceed ?
Error message
[22-Mar-2013 18:29:49] (shop: 22-Mar-2013 18:29:41) SQL error:
Site :
http://svsponline.co.uk
....
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: /login.php
Backtrace:
/home/svsponli/public_html/include/func/func.db.php:303
/home/svsponli/public_html/include/func/func.db.php:203
/home/svsponli/public_html/include/func/func.db.php:483
/home/svsponli/public_html/ability_minicart_content.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:21
/home/svsponli/public_html/ability_minicart_content.php(1) : eval()'d code(1) : eval()'d code:1
/home/svsponli/public_html/ability_minicart_content.php(1) : eval()'d code:1
/home/svsponli/public_html/ability_minicart_content.php:1
/home/svsponli/public_html/include/common.php:98
/home/svsponli/public_html/login.php:54
-------------------------------------------------