MySQL Help

[AsPeRiTy]

Well I installed ibstore 3.0.2 for my forum and this error comes up when i try to edit items via ACP.

mySQL query error: UPDATE ibf_store_categories SET cat_stock= WHERE catid=4

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=4' at line 1
mySQL error code:
Date: Saturday 06th of August 2005 04:28:31 PM

Since it says to check the manual that corresponds to the sql, does that mean that you guys can like tell me what to do to my mysql to make it work or can you help me with this problem etc.

Thanks

 

[o0slowpaul0o]

Trying running the install again.

If not, goto (If you have IPB 2.0.x) go to Admin> SQL Manangment> SQL Tool Box.

Run this code in the query box.

UPDATE ibf_store_categories SET cat_stock= WHERE catid=4

Or do the same in PHPmyAdmin. If that don't work, I dunno.

 

[AsPeRiTy]

thanks for all the help man! rerunning the installer worked great!