Zen Cart Logo
Forums / Upgrading from 1.3.x to 1.3.9 / trouble upgrading db for 1.3.5 from 1.3.0

trouble upgrading db for 1.3.5 from 1.3.0

Locked

Views: 3,142

Results 1 to 1 of 1
This thread is locked. New replies are disabled.
4 Sep 2006, 6:48 PM
#1
brownrv avatar

brownrv

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:

  1. Copy 1.3.5 over a 1.3.0 installation

  2. Brought up the 1.3.5 zc_install

  3. clicked through the check

  4. On the ZenCart Setup System Inspection page, I scrolled down and used the "database upgrade" button

  5. 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.

  6. Typed in the admin account and password and then clicked the upgrade button.

  7. Got the error above

  8. 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.

  9. Wierd...tried the 1.3.0.5 update a few moments ago (about 3-5 minutes have passed) and it worked. Odd.

Bob