[fixed] 1.5.0 BETA - PHP Fatal Error: 1101 - 'gzpost' can't have default value

[Scrat]

I thought I would have a look at the new 'beta' version, to see what we can look forward too but I am getting this error:

PHP Fatal Error: 1101 - BLOB/TEXT Column 'gzpost' can't have default value

when trying to upgrade the database from 1.3.8 to 1.5.
It seems its when upgrading 1.3.9 to 1.5 but also I get a white screen with 'WARNING: An Error occurred, please refresh the page and try again'
between each database upgrade.

PHP 5.3.1
MySQL 5.1.39

Beta version 07292011.

[DrByte]

Remove the " default ''" from line 56 of your /zc_install/sql/mysql_upgrade_zencart_139_to_150.sql file, so that the line looks like this:

ALTER TABLE admin_activity_log ADD COLUMN gzpost mediumblob NOT NULL;

[Scrat]

Thank you, installed OK.