BLOB/TEXT column 'products_options_values' can't have a default value ??

Quote:

---

Originally Posted by xplorer

I was also facing same problem.

thanx for the help.
zencart is working now.

---

And another soul rescued here, thanks! :smile:

Just want to share, I had the same going from 1.3.0.2 --> 1.3.5 in the route to 1.3.7

It started with
1101 BLOB/TEXT column 'query_description' can't have a default value
in:
[ALTER TABLE zen_dog_query_builder CHANGE COLUMN query_description query_description TEXT NOT NULL default '';]

when upgrading dB from 1.3.0.2 to 1.3.5.

After a number of delete database and reimport, I found that removing default '' in the following lines worked.

ALTER TABLE query_builder CHANGE COLUMN query_description query_description TEXT NOT NULL default '';

ALTER TABLE query_builder CHANGE COLUMN query_string query_string TEXT NOT NULL default '';

ALTER TABLE query_builder CHANGE COLUMN query_keys_list query_keys_list TEXT NOT NULL default '';

Quote:

---

Originally Posted by DrByte

Hmmm ... hadn't ran into that one yet.

You'll have to edit the /zc_install/sql/mysql_zencart.sql file and search for "BLOB " and remove the default '' following it (leaving the , )

There are 2 BLOB references with default values, and 3 TEXT references with default values.
- customers_basket_attributes (BLOB)
- orders_products_attributes (BLOB)
- query_builder (TEXT x 3)

These will be remedied in the next release.

---

This issue still exists in the 1302-to-135.sql file for the query_builder fields.

Mark

Quote:

---

Originally Posted by mriffey

This issue still exists in the 1302-to-135.sql file for the query_builder fields.

Mark

---

Correct - it's fixed in the upcoming v1.3.8 fileset.

Updating 1.37 to 1.38 (mysql_upgrade_zencart_137_to_138.sql) getting the same error.

Code:

---

ERROR 1364 (HY000) at line 62: Field 'query_keys_list' doesn't have a default value

---

Quote:

---

Originally Posted by smap

Updating 1.37 to 1.38 (mysql_upgrade_zencart_137_to_138.sql) getting the same error.

Code:

---

ERROR 1364 (HY000) at line 62: Field 'query_keys_list' doesn't have a default value

---

---

Hmm, sorry upon 2nd look I'm not sure this is related.

My live/server version of MySQL is 4.1.22. My dev/local version of MySQL is 5.0.27 (where the upgrade/error was occurring). I reconfigured the dev instance and unchecked 'strict mode' and this error went away.