1364 Field 'query_keys_list' doesn't have a default value

[geekgirl]

My current version is 1.3.7. I am trying to upgrade to 1.3.8, and getting this error when I select upgrade that upgrade option:

1364 Field 'query_keys_list' doesn't have a default value
in:
[INSERT INTO zen_query_builder (query_category, query_name, query_description , query_string) VALUES ('email,newsletters', 'Customers who have never completed a purchase', 'For sending newsletter to all customers who registered but have never completed a purchase', 'SELECT DISTINCT c.customers_email_address as customers_email_address, c.customers_lastname as customers_lastname, c.customers_firstname as customers_firstname FROM TABLE_CUSTOMERS c LEFT JOIN TABLE_ORDERS o ON c.customers_id=o.customers_id WHERE o.date_purchased IS NULL');]

I can't seem to get it to do the upgrade. Any suggestions? Or should I just concentrate on trying to import all of the products at the database level so I can just do a fresh install of 1.3.8?

Thanks in advance for any help you might provide!

geekgirl

[DrByte]

Which version checkboxes are checked when you get that error?

Are you attempting the upgrade using v1.3.8 or the newer v1.3.8a files?

[geekgirl]

The upgrade for 1.3.7 to 1.3.8a. I had to reinstall it back to 1.3.7 in order for it to retain the info from the database. When I try the upgrade option it doesn't work.

This is the info from server version:
Zen Cart 1.3.8a

Database Patch Level: 1.3.7

v1.3.7 [2009-03-29 12:31:51] (Version Update 1.3.6->1.3.7)
v1.3.7 [2007-06-04 23:35:56] (Fresh Installation)

Sorry it took so long to respond! I just haven't been concentrating on this broken site, as I can't do much for this personal site unless it's on a weekend.

[DrByte]

Edit your /zc_install/sql/mysql_upgrade_zencart_137_to_138.sql file, using a reliable text editor such as Notepad++

Find the lines that look like this:

#audience list addition: customers who have signed up but never made a purchase
INSERT INTO query_builder (query_category, query_name, query_description , query_string) VALUES ('email,newsletters', 'Customers who have never completed a purchase', 'For sending newsletter to all customers who registered but have never completed a purchase', 'SELECT DISTINCT c.customers_email_address as customers_email_address, c.customers_lastname as customers_lastname, c.customers_firstname as customers_firstname FROM TABLE_CUSTOMERS c LEFT JOIN  TABLE_ORDERS o ON c.customers_id=o.customers_id WHERE o.date_purchased IS NULL');

And add a # to the beginning of the INSERT INTO query_builder ... line. (just like the #audience list addition ... line has.)
Save the file and re-upload it to the same location on the server.
Then the upgrade step should continue fine.