globimagen Posted January 24, 2013 Share Posted January 24, 2013 Hi, yesterday i upgrade my cubecart storefrom 5.1.5 to 5.2.0. http;//www.globosmexicoshop.com/shop i copy the new files to the store and run the setup it said it finish sucessfully but, at the control panel several system errors are reported, can you help me Here i post the errors Marcar todos/eliminar selección de todos Con seleccionado: File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:35 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:35 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:35 File: [dashboard.index.inc.php] Line: [246] "SELECT SQL_CALC_FOUND_ROWS I.name ,I.stock_level AS I_stock_level, I.stock_warning AS I_stock_warning, I.product_id, M.stock_level AS M_stock_level, M.use_stock as M_use_stock, M.cached_name FROM `CubeCart_inventory` AS `I` LEFT JOIN `CubeCart_option_matrix` AS `M` on `I`.`product_id` = `M`.`product_id` WHERE use_stock_level = 1 AND ((M.use_stock = 1 AND M.status = 1 AND M.stock_level <= 0) OR ((I.stock_warning > 0 AND I.stock_level <= I.stock_warning) OR (I.stock_warning <= 0 AND I.stock_level <= 0))) ORDER BY I.stock_level ASC LIMIT 25 OFFSET 0;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:35 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:35 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:35 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:35 File: [catalogue.class.php] Line: [288] "SELECT MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `CubeCart_option_matrix` LIMIT 1;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:31 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:31 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:31 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:31 File: [catalogue.class.php] Line: [288] "SELECT MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `CubeCart_option_matrix` LIMIT 1;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:29 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:29 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:29 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:29 File: [catalogue.class.php] Line: [288] "SELECT MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `CubeCart_option_matrix` LIMIT 1;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:29 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:29 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:29 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:29 File: [catalogue.class.php] Line: [288] "SELECT MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `CubeCart_option_matrix` LIMIT 1;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:29 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:29 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:29 File: [catalogue.class.php] Line: [288] "SELECT MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `CubeCart_option_matrix` LIMIT 1;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:29 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:29 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:29 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:29 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:29 File: [catalogue.class.php] Line: [288] "SELECT MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `CubeCart_option_matrix` LIMIT 1;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:28 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:28 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:28 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:28 File: [catalogue.class.php] Line: [288] "SELECT MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `CubeCart_option_matrix` LIMIT 1;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:28 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:28 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:28 File: [catalogue.class.php] Line: [288] "SELECT MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `CubeCart_option_matrix` LIMIT 1;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:28 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:27 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:27 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:27 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:27 File: [catalogue.class.php] Line: [288] "SELECT MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `CubeCart_option_matrix` LIMIT 1;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:27 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:27 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:27 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:27 File: [catalogue.class.php] Line: [288] "SELECT MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `CubeCart_option_matrix` LIMIT 1;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:26 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:26 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:26 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:26 File: [catalogue.class.php] Line: [288] "SELECT MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `CubeCart_option_matrix` LIMIT 1;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:25 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:25 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:25 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:25 File: [catalogue.class.php] Line: [288] "SELECT MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `CubeCart_option_matrix` LIMIT 1;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:23 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:23 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:23 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:23 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:23 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:23 File: [catalogue.class.php] Line: [288] "SELECT MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `CubeCart_option_matrix` LIMIT 1;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:23 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:22 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:22 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:22 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:22 File: [catalogue.class.php] Line: [288] "SELECT MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `CubeCart_option_matrix` LIMIT 1;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:22 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:22 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:22 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:22 File: [catalogue.class.php] Line: [484] "SELECT * FROM `CubeCart_option_matrix` ;" - Table 'globosme_shop.CubeCart_option_matrix' doesn't exist Hoy, 00:22 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:22 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:21 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist Hoy, 00:21 File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'globosme_shop.CubeCart_code_snippet' doesn't exist 1 2 > … 3 [Ver todo] Quote Link to comment Share on other sites More sharing options...
Guest theartifactcompany Posted January 24, 2013 Share Posted January 24, 2013 I'm getting the same thing. Over and over. I'll clear the log and literally dozens more errors citing that table are popping up. Did the upgrade forget to create that table? Quote Link to comment Share on other sites More sharing options...
globimagen Posted January 24, 2013 Author Share Posted January 24, 2013 Dont know... i also run the repair of database in maintenance but nothing happen error are going on an on Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 24, 2013 Share Posted January 24, 2013 Yes and no. The problem as I see it (and alluded to by Devellion) is that the sequence of upgrade scripts should be: CC5.1.4 CC5.1.5 CC5.2.0b1 CC5.2.0 Instead, I think it might be: CC5.1.4 CC5.1.5 CC5.2.0 (and stops) CC5.2.0b1 (is where all the new and important stuff is) I think Devellion has said there is a modified CC520 that was just put up for download, I don't have it yet, so I don't know if that fixed it. If you have the skills, you can manually feed the SQL commands to the database. See the file: setupdbupgrade5.2.0b1.sql Quote Link to comment Share on other sites More sharing options...
Guest theartifactcompany Posted January 24, 2013 Share Posted January 24, 2013 Dangit. I JUST got my tweaks reinstalled in 5.2.0 and went live again today. Another update? Quote Link to comment Share on other sites More sharing options...
Guest theartifactcompany Posted January 24, 2013 Share Posted January 24, 2013 So what. backup my site, and retry the upgrade? or start from scratch? Quote Link to comment Share on other sites More sharing options...
globimagen Posted January 24, 2013 Author Share Posted January 24, 2013 i dont have the skills to do that. Any suggestion Quote Link to comment Share on other sites More sharing options...
Guest theartifactcompany Posted January 24, 2013 Share Posted January 24, 2013 Meh. I had to go into phpMyAdmin on my cPanel and edit the SQL queries in 5.2.0.sql to add the missing tables. Error Free now. Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 24, 2013 Share Posted January 24, 2013 Some suggestions you might consider -- each has a different amount of work involved and different probabilities of success: * Submit a support ticket and ask Devellion to make the database changes * Restore the backup to CC515 (probably just the files as the database wasn't altered, then upgrade to B1 with this package: http://www.cubecart.com/download/5.2.0b1/zip Then immediately upgrade to RTM with this package: http://www.cubecart.com/download/5.2.0/zip * Politely ask for assistance from any of the Commercial members over at www.cubecartforums.org I've just downloaded (let's call it CC5.2.0.1) and compared it against CC5.2.0, and found: * upgrade scripts found in files named '5.2.0b1' have been moved to files named '5.2.0' and '5.2.0b1' removed (which means, after you have restored to CC515, you don't need the 520b1 middle step) * IridiumCorp payment gateway * A change to what Google Analytics reports * Fix to a faulty fetch of getting the stock level of a product (I think stock levels were not deleted, it just looked that way on the frontend, but the backend should have shown correctly) Quote Link to comment Share on other sites More sharing options...
globimagen Posted January 24, 2013 Author Share Posted January 24, 2013 just to do it right. i erase the files from the web then i upload the backup files then i upload the b1 update and run it and then the next one its ok? Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 24, 2013 Share Posted January 24, 2013 This is how I would do it. Put the files you backed up back on the site. Examine the database table CubeCart_history. If you find a record with version 5.2.0b1 or 5.2.0, delete them. Go to the admin screen Maintenance, Upgrade tab and upgrade from there. 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.