Ibstore Trouble

Discussion in 'Gaming' started by Aznsilvrboy, Jan 25, 2006.

  1. Aznsilvrboy

    Aznsilvrboy Well-Known Member

    Posts:
    1,252
    Likes Received:
    0
    Joined:
    Sep 12, 2005
    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?
     
  2. Aznsilvrboy

    Aznsilvrboy Well-Known Member

    Posts:
    1,252
    Likes Received:
    0
    Joined:
    Sep 12, 2005
    bumping this up..
     
  3. slacker

    slacker Well-Known Member

    Posts:
    307
    Likes Received:
    0
    Joined:
    Oct 15, 2005
    um ive never seen that tbh... try opening up the mysql file and looking on line 1 for a mess up of some sort.
     
  4. DiabloDj1

    DiabloDj1 Well-Known Member

    Age:
    33
    Posts:
    5,610
    Likes Received:
    0
    Joined:
    Jan 27, 2005
    Location:
    USA/RI
    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.
     
  5. Arnab11

    Arnab11 Well-Known Member

    Posts:
    382
    Likes Received:
    0
    Joined:
    Mar 27, 2005
    is it after you finish editing or before? cuz I get the error after editing but the store still always works.. ;)
     
  6. Aznsilvrboy

    Aznsilvrboy Well-Known Member

    Posts:
    1,252
    Likes Received:
    0
    Joined:
    Sep 12, 2005
    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..
     
  7. DiabloDj1

    DiabloDj1 Well-Known Member

    Age:
    33
    Posts:
    5,610
    Likes Received:
    0
    Joined:
    Jan 27, 2005
    Location:
    USA/RI
    Yeah it is. Its just a glitch...
     

Share This Page