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

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

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?

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.

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.