craigfh Posted September 29, 2008 Share Posted September 29, 2008 I am having problems with the REbuild Category Product Count with Cube Cart Version 4.1.1 Running PHP Version: 4.2.6 MySql Version: 4.0.27-standard When I run "Rebuild category product count" I get the following error. MySQL Error Occured Error Message: 1064: 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 'SELECT DISTINCT productId FROM CubeCart_inventory WHERE disable SQL: DELETE FROM CubeCart_cats_idx WHERE productId NOT IN (SELECT DISTINCT productId FROM CubeCart_inventory WHERE disabled = '0') Is there any way to fix this? Thanks Craig Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.