[fixed] 1.5.0 BETA - PHP Fatal Error: 1101 - 'gzpost' can't have default value
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:
Code:
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.
Re: PHP Fatal Error: 1101 - 'gzpost' can't have default value
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:
Code:
ALTER TABLE admin_activity_log ADD COLUMN gzpost mediumblob NOT NULL;
Re: PHP Fatal Error: 1101 - 'gzpost' can't have default value