Guest Posted March 5, 2008 Share Posted March 5, 2008 I get this error message when trying to view a product: SQL: SELECT B.*, T.option_name, T.option_type, M.value_name FROM CubeCart_options_bot AS B LEFT JOIN CubeCart_options_mid AS M ON B.value_id = M.value_id, CubeCart_options_top AS T WHERE B.option_id = T.option_id AND B.product = 74 ORDER BY T.option_name ASC I have no idea what to do with this. I'm afraid that a fresh install will not fix the problem because it's somewhere in the coding for the database. Does anyone know what this error means? http://segwaynm.com Quote Link to comment Share on other sites More sharing options...
Ausy Posted March 5, 2008 Share Posted March 5, 2008 Did you upgrade your store recently? Looks like a missing field in the database. CubeCart_options_top, the field option_type is missing? You can manually add it in phpmyadmin. Quote Link to comment Share on other sites More sharing options...
Guest Brivtech Posted March 5, 2008 Share Posted March 5, 2008 Indeed, it seems like the upgrade script hasn't been run properly, and the database field has been left out. Quote Link to comment Share on other sites More sharing options...
Guest Posted March 5, 2008 Share Posted March 5, 2008 That was it! I had just upgraded the store and everything seemed to be working fine for about 15 minutes then, my server had a database crash. I couldn't get it to work after he fixed his side. He probably reloaded the old database over the new script. I just added the field "option_type" and it works fine. Thank you. 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.