Guest Charlie-parlie Posted April 16, 2009 Share Posted April 16, 2009 I have installed Cube Cart version 3 and am currently setting up the store. Today i was testing the freight handling and tried to check out some items to see if it worked correctly. Suddenly my site crashed and I get the error message: MySQL Error Occured 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 '' at line 1 QUERY = SELECT productId, image, price, name, sale_price FROM CubeCart_inventory WHERE `showFeatured` = 1 ORDER BY productId DESC LIMIT I am not that technically savvy and have no idea as to what I should do to fix my site. Does anyone have a clue? Quote Link to comment Share on other sites More sharing options...
keat Posted April 17, 2009 Share Posted April 17, 2009 I have installed Cube Cart version 3 and am currently setting up the store. Today i was testing the freight handling and tried to check out some items to see if it worked correctly. Suddenly my site crashed and I get the error message: MySQL Error Occured 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 '' at line 1 QUERY = SELECT productId, image, price, name, sale_price FROM CubeCart_inventory WHERE `showFeatured` = 1 ORDER BY productId DESC LIMIT I am not that technically savvy and have no idea as to what I should do to fix my site. Does anyone have a clue? Maybe try to change the freight handling to a diferent module. Or you could try to repair the database in your hosting control panel. In my host control panel is a section "My SQL Databases" from here I can check or repair the DBS. Failing that, maybe try to restore the DBS. But I guess as you've only just started building/playing.. a backup was the last thing on your mind..?? 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.