Quote:
|
Originally Posted by edisastersystems
I had a problem upgrading from 4.4.3 to 4.4.5 in my test environment.
The files updated with no problems, but the SQL patch ran into a problem with the line:
ALTER TABLE xcart_stats_pages ADD UNIQUE page (`page`)
I think it's line 394. It said the database was not updated.
However, If I go back to the Patch/Upgrade center. I am now told the current version is 4.4.4 and there are no patches available. Am I able to attempt patching the database again by running the patch.sql file? Should I be concerned that the version says 4.4.4 instead of 4.4.5? I'm not sure what was wrong with the SQL file in the first place, and unfortunately I can't paste the exact error message since I've navigated away from the page and can't get back.
Any help is appreciated.
[Update]: Disregard the question, the issue has been resolved for now by deleting the store statistics.
|
The new version 4.4.5 adds a new UNIQUE KEY on 'page' field in 'xcart_stats_pages' table.
If there are duplicate 'pages' values in 'xcart_stats_pages' table in your original X-Cart database, you will get the error in question during the upgrade.
To solve the problem you should remove the duplicate entries from the table, or simply delete all statistics data from the table.