I'm trying to upgrade my shop on a test install and appear to have issues upgrading the database.
Running the zc_install database upgrade from 1.2.7 through 1.3.7 gives the following errors at the top:
And the following at the bottom:127 statements processed.
11 statements processed.
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.
9 statements processed.
62 statements processed.
32 statements processed.
12 statements processed.
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.
After this, I click re-check and it says the sniffer says no database upgrade is needed.SKIPPED: Cannot insert configuration_group_title "EZ-Pages Settings" because it already exists
SKIPPED: Cannot insert configuration_group_title "EZ-Pages Settings" because it already exists
SKIPPED: Cannot insert configuration_group_title "EZ-Pages Settings" because it already exists
SKIPPED: Cannot insert configuration_group_title "EZ-Pages Settings" because it already exists
SKIPPED: Cannot insert configuration_group_title "EZ-Pages Settings" because it already exists
SKIPPED: Cannot insert configuration_group_title "EZ-Pages Settings" because it already exists
SKIPPED: Cannot insert configuration_group_title "EZ-Pages Settings" because it already exists
SKIPPED: Cannot insert configuration_group_title "EZ-Pages Settings" because it already exists
SKIPPED: Cannot insert configuration_group_title "EZ-Pages Settings" because it already exists
SKIPPED: Cannot insert configuration_group_title "EZ-Pages Settings" because it already exists
SKIPPED: Cannot insert configuration_key "DEFINE_PAGE_NOT_FOUND_STATUS" because it already exists
SKIPPED: Cannot insert configuration_key "DEFINE_PAGE_NOT_FOUND_STATUS" because it already exists
SKIPPED: Cannot insert configuration_key "DEFINE_PAGE_NOT_FOUND_STATUS" because it already exists
SKIPPED: Cannot insert configuration_key "DEFINE_PAGE_NOT_FOUND_STATUS" because it already exists
Logging in to the admin section after this I get the error:
Tools->Server/Version Information reports that my databse is 1.2.7 and that I am running ZenCart 1.3.7.Your database appears to need patching to a higher level. See Tools->Server Information to review patch levels.
On the main page of the admin section where I assume the "New Orders" section should be displayed, this is returned:
When I go to Catalog->Categories/Products, only the first category is displayed and this error is shown on the page:1054 Unknown column 'startdate' in 'field list'
in:
[select startdate, counter, session_counter from zen_counter_history order by startdate DESC limit 10]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
However, all categories are shown in the drop-down and I can navigate through products in the admin section.1146 Table 'calban_zc.zen_meta_tags_categories_description' doesn't exist
in:
[select metatags_keywords from zen_meta_tags_categories_description where categories_id = '58' and language_id = '1']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
I'm at a loss of what to do at this point, any advice would be much apreciated.
Bookmarks