New Zenner
- Join Date:
- May 2006
- Posts:
- 21
- Plugin Contributions:
- 0
trouble upgrading db for 1.3.5 from 1.3.0
Hi,
I received this error when I ran zc_install and attemped the database upgrade.
1364 Field 'query_keys_list' doesn't have a default value
in:
[REPLACE INTO hbg_query_builder ( query_category , query_name , query_description , query_string ) VALUES ('email,newsletters', 'Administrator', 'Just the email account of the current administrator', 'select 'ADMIN' as customers_firstname, admin_name as customers_lastname, admin_email as customers_email_address from TABLE_ADMIN where admin_id = $SESSION:admin_id');]
Steps to produce this:
-
Copy 1.3.5 over a 1.3.0 installation
-
Brought up the 1.3.5 zc_install
-
clicked through the check
-
On the ZenCart Setup System Inspection page, I scrolled down and used the "database upgrade" button
-
on the database upgrade page, it wanted to install 3 database updates 1.3.0.1, 1.3.0.2, and 1.3.0.5.
-
Typed in the admin account and password and then clicked the upgrade button.
-
Got the error above
-
Went back through the zc_install and database upgrade and now it just wants to install the 1.3.0.5 database update which fails with the above error as well.
-
Wierd...tried the 1.3.0.5 update a few moments ago (about 3-5 minutes have passed) and it worked. Odd.
Bob