I've installed IBStore 3.0 and everything seems fine, except when I try to go to 'edit items' in Admin CP, i get this MySQL error: ------------------------------------------------------------------ mySQL query error: UPDATE ibf_store_categories SET cat_stock= WHERE catid=1 mySQL 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 'WHERE catid=1' at line 1 mySQL error code: Date: Wednesday 25th of January 2006 08:44:25 AM --------------------------------------------------------------- Anyone know what's wrong?
um ive never seen that tbh... try opening up the mysql file and looking on line 1 for a mess up of some sort.
Its a category bug. You can just delete the categories. but keep reading.. To fix it while keeping categories, just add at least one item to the category.
is it after you finish editing or before? cuz I get the error after editing but the store still always works..
I originally had the same catagories as GR, but i had Downloads and Services empty. After I deleted those 2 the 'edit items' function in Admin CP worked fine, however i'm just wondering if that's the case with all IBStore 3.0s..