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

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

Locked

Views: 2,302

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
2 Aug 2011, 1:57 PM
#1
scrat avatar

scrat

Zen Follower

Join Date:
Dec 2005
Posts:
451
Plugin Contributions:
0

[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:

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.

2 Aug 2011, 2:06 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: [fixed] 1.5.0 BETA - 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:```
ALTER TABLE admin_activity_log ADD COLUMN gzpost mediumblob NOT NULL;

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

2 Aug 2011, 2:57 PM
#3
scrat avatar

scrat

Zen Follower

Join Date:
Dec 2005
Posts:
451
Plugin Contributions:
0

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

Thank you, installed OK.