Robsta Posted November 8, 2005 Share Posted November 8, 2005 (edited) Hello.... usual story... I followed the instructions .... ummm... sorry. On a more serious note. I was running 3.0.4 on a test server. I decided to upgrade, and followed the upgrade notes. This is my first upgrade of CubeCart. I renamed the 'global.inc.php' so the server file was not overwritten. Then proceeded to upload all the files other than the 'install' directory. Copied the 3.0.4-3.0.5 'upgrade.php' file to the root of the shop, then run it. So far so good, upgrade success. Log into the admin, no problems. On the front end, log in as a customer, added item to cart, ok. Click on go to cart, no probs. Click on 'Continue', bang. The error below appears... MySQL Error Occured 1146: Table 'mydb.shop_CubeCart_Modules' doesn't exist QUERY = SELECT folder FROM shop_CubeCart_Modules WHERE module='shipping' AND status = 1 Did I miss something? Apart from that table, which is not in the database (confirmed through phpmyadmin). I had a search for 'CubeCart_Modules' in the forum, only one post came up, seemingly unrelated. Any ideas? Thanks in advance. Edit: Just found a related post here. But no solutions... which fields need to be re-added? Edited November 8, 2005 by Robsta Quote Link to comment Share on other sites More sharing options...
Robsta Posted November 9, 2005 Author Share Posted November 9, 2005 This is the demo shop if it helps... www.inspired-solutions.net/shop Quote Link to comment Share on other sites More sharing options...
Guest sunshine Posted November 10, 2005 Share Posted November 10, 2005 Looks Nice, I see you resolved it :D Quote Link to comment Share on other sites More sharing options...
Robsta Posted November 10, 2005 Author Share Posted November 10, 2005 Looks Nice, I see you resolved it Hi Sunshine... thanks. No haven't solved it. The problem occurs when you click on 'continue' after viewing the checkout (post login). Quote Link to comment Share on other sites More sharing options...
Guest sunshine Posted November 10, 2005 Share Posted November 10, 2005 I bet if you explain the problem with further detail, someone can give you a better answer. Quote Link to comment Share on other sites More sharing options...
Guest sunshine Posted November 10, 2005 Share Posted November 10, 2005 Do you have a test account you can provide? Quote Link to comment Share on other sites More sharing options...
Robsta Posted November 10, 2005 Author Share Posted November 10, 2005 I bet if you explain the problem with further detail, someone can give you a better answer. I would be happy to... if I knew the extra details which might help? I'm new to CubeCart, so still learning it's quirks and upgrade routines. I have detailed pretty much what I did to upgrade. Quote Link to comment Share on other sites More sharing options...
Robsta Posted November 10, 2005 Author Share Posted November 10, 2005 (edited) Do you have a test account you can provide? Certainly... [login details now removed]. Thanks. Edited November 10, 2005 by Robsta Quote Link to comment Share on other sites More sharing options...
Guest sunshine Posted November 10, 2005 Share Posted November 10, 2005 Hi Robsta, Tried logging in with that pass info and it failed. Plus, my mistake, I thought your problem was something else. In your first post, you did state it was an upgrade and that the problem was a missing table. Did you add the missing table to mysql yet? I don't think the 3.04 to 3.05 upgrade affected that aspect of the cart, so I would begin by checking your Step1.inc in includes/content and also content/cart. You can compare them in Winmerge to the orignal. You should also know, CC3.06 is coming out shortly per the heaven above. Quote Link to comment Share on other sites More sharing options...
Robsta Posted November 10, 2005 Author Share Posted November 10, 2005 Thanks for looking sunshine. The login details were for the front end account login, to show you the error. If you require admin login, please let me know. Yes, it was an upgrade from 3.0.4 to 3.0.5. The upgrade completed successfully, but there is now an error when you now proceed from the cart page after the upgrade. I had been testing with the paypal sandbox quite a bit with 3.0.4, so I know the cart worked before the upgrade. I have not added the missing table. I didn't want to start messing with it until I knew a little more about the problem (and advice from you wonderful people ) I have compared the two files mentioned with the 3.0.5 shipped files, they are identical. Maybe I should wait till 3.0.6 and install a clean copy. Thanks. Quote Link to comment Share on other sites More sharing options...
Robsta Posted November 10, 2005 Author Share Posted November 10, 2005 Ok. I've gone into my backup and exported the create table script for the module table. Run it to create the 3.0.4 version table. This seems to fix the problem. I'm wondering why/how this table was deleted during the upgrade? As this is the only time it could have been. :D Quote Link to comment Share on other sites More sharing options...
Guest sunshine Posted November 10, 2005 Share Posted November 10, 2005 That I really can't explain because it's not the same table Thankfully, you've got it working! Quote Link to comment Share on other sites More sharing options...
Robsta Posted November 10, 2005 Author Share Posted November 10, 2005 That I really can't explain because it's not the same table Thankfully, you've got it working! It is the same table as the error indicates (shown at the top of the page), shop_CubeCart_Modules. Thanks for your help and suggestions Sunshine. Much appreciated. :D 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.