Jump to content

6.28 to 6.29 Upgraded partially. Database still 6.28


B.F
 Share

Recommended Posts

Hello,
The update was partial.  It seems that the database cannot be updated.

It says that there is an error but none is written. What I found when It start again the installation is the following info :

mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $ MySQL 5.5+

Thanks for your help

 

Link to comment
Share on other sites

@B.F, please try to determine if the database user that CubeCart is using has CREATE TEMPORARY TABLES permissions.

If you are on a hosted environment, you may need to ask your hosting technical support to determine this. Perhaps the database tool provided in your hosting control panel, phpMyAdmin, can show this to you.

You got an error, but we would like to know what reported the error: a CubeCart error message, a PHP error message, an error message from the database that got passed along that eventually was displayed on your web browser? And what the error message actually said - if it was revealed.

Link to comment
Share on other sites

Assuming your store is already at 6.2.8 please follow these steps.

1. Login to with SSH: (replace username with your MySQL username and example.com with your hostname.)

ssh [email protected]

2. Login to MySQL (replace username with your MySQL username)

mysql -u username -p

3. Enter your password 

4. Select the database to update (replace database_name with your database name)

USE database_name

5. Run the following SQL (if you have a database prefix amend the table names accordingly). This can take up to 30 minutes or more in some cases.

ALTER TABLE `CubeCart_cookie_consent` ADD `log_hash` VARCHAR(32) NOT NULL;
ALTER TABLE `CubeCart_cookie_consent` ADD `url_shown` VARCHAR(255) NOT NULL;
UPDATE `CubeCart_cookie_consent` SET `log_hash` = MD5(`log`);
ALTER TABLE `CubeCart_cookie_consent` ADD INDEX(`log_hash`);
CREATE TEMPORARY TABLE `tmp_cookie_table` (SELECT * FROM `CubeCart_cookie_consent` GROUP BY `log_hash`,`session_id`);
TRUNCATE `CubeCart_cookie_consent`;
INSERT INTO `CubeCart_cookie_consent` (SELECT * FROM `tmp_cookie_table`);
DROP TEMPORARY TABLE `tmp_cookie_table`;
INSERT INTO `CubeCart_history` (`version`, `time`) VALUES ('6.2.9', UNIX_TIMESTAMP());

6. Delete the setup folder. 

Your store will now be at 6.2.9.

Link to comment
Share on other sites

  • 2 weeks later...
40 minutes ago, -=Mike=- said:

Its not even updating here.

Uploaded all files with ftp, then in browser to /setup/ and choose upgrade and press continu then nothing happens ???

Thx but dont know how to edit mysql  can go to phpmyadmin and to cubecart cookie consent but then im lost.

Lot more problems says last version cubecart is (upgrade history) 6.2.6 while backup says 6.2.8

Link to comment
Share on other sites

  • 2 months later...
  • 1 year later...

For every freshly installed package (CC644, for example), there is a folder that contains numerous files that have all the SQL statements necessary to add, delete, whatever necessary to get the database schema from where it is at (CC622 schema, for example) to the very next version (CC623 schema, for example), then to the next version (CC624 schema, for example). One by one, these files are executed to bring the database, through each intermediate version's schema, to the current version's schema.

The starting point is the highest version logged in the existing database CubeCart_history table. For each intermediate version's file, the Setup system will log that version in the History table.

 

Link to comment
Share on other sites

Is this what you mean by History (from the Admin site) I did not do these upgrades; just new-installed 6.4. What does this mean?

Upgrade History

CubeCart Version Date
6.4.4 Wednesday, 1 December 2021
6.4.3 Tuesday, 30 November 2021
6.4.2 Sunday, 24 January 2021
6.4.1 Friday, 20 November 2020
6.4.0 Friday, 20 November 2020
6.2.9 Monday, 14 September 2020
6.2.8 Thursday, 6 February 2020
6.2.7 Thursday, 6 February 2020
6.2.6 Thursday, 6 February 2020
6.2.3 Thursday, 6 February 2020
6.2.2 Sunday, 24 February 2019

 

Link to comment
Share on other sites

On the Admin pages, I can see: Customers, Orders, Transaction Log, Mailing List, Product Options, Promotional Codes, Email Log, Documents, Images, Logos, Extensions

Not there are: Categories, Products, Store Settings/General,

Very peculiar... not sure wherre to go with this.

Link to comment
Share on other sites

I don't recall 'Logos" being in the File Manager section of the Navigation pane. Still, in this File Manager section, you have Documents, but not Downloads, have Images, but not Email Templates, and not Contact Form? And "Store Settings/General"? That should simply be "Store Settings".

If you are sharing a database, then this Upgrade History page reflects the store that did have the Setup system executed. For that store (of which you are using it's database for this store), it was upgraded from CC622 (itself installed Feb 2019) directly* to CC628 on Feb 2020. Then to CC629, then to CC641, then to CC642.

What I am very suspicious about are the entries for CC643 and the very next day CC644. A "fresh" installation, to my mind, also includes a separate database dedicated to that installation. Since this new installation is using a database belonging to a different installation, the new installation logged its date of installation in the other installation's CubeCart_history table.

* By directly, I mean there was not the sequence of having to install each intervening version. Each version in its download package has all the scripts from all the prior versions going all the way back to CC400 -- and CubeCart will update an existing database as far back from that if necessary, to the current version, in one step.

Edited by bsmither
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.

 Share

×
×
  • Create New...