Jump to content

Some System Errors after upgrade to 5.2.0. Help!


globimagen

Recommended Posts

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 

 

select_all.gifMarcar 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]
Link to comment
Share on other sites

Guest theartifactcompany

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Guest theartifactcompany

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.

Link to comment
Share on other sites

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)

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...