Error in DB upgrade

14 Feb 2012, 2:23 PM

#1

Zen Follower

Join Date:: Feb 2009
Posts:: 125
Plugin Contributions:: 0

Error in DB upgrade

Immediately after clicking upgrade DB getting this:

1101 BLOB/TEXT column 'gzpost' can't have a default value
in:
[ALTER TABLE admin_activity_log ADD COLUMN gzpost mediumblob NOT NULL default '';]

It leaves site in down for maintenance mode.

My install: was Vanilla 1.3.9h, now 1.5.5b, Apache 2.4, PHP 7.0.6, MySQL 5.5.8 64b, Windows 7 64b, 8GB RAM, i3 3.3gHz
Modules: [Payment=Paypal] [Shipping=Canada Post 1.5.3 merged] [nonCAPTCHA]

14 Feb 2012, 11:50 PM

#2

drbyte

Sensei

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

Re: Error in DB upgrade

MySQL version?
Is this a Windows server or a Linux server?

.
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.

15 Feb 2012, 1:27 AM

#3

one_tall_man

Zen Follower

Join Date:: Feb 2009
Posts:: 125
Plugin Contributions:: 0

Re: Error in DB upgrade

DrByte:

MySQL version?
Is this a Windows server or a Linux server?

The ZenCart is being installed onto a Fedora 14 machine with Apache/PHP.
DB server is Windows 7 64bit with MySQL 5.5.8 (64bit too).

My install: was Vanilla 1.3.9h, now 1.5.5b, Apache 2.4, PHP 7.0.6, MySQL 5.5.8 64b, Windows 7 64b, 8GB RAM, i3 3.3gHz
Modules: [Payment=Paypal] [Shipping=Canada Post 1.5.3 merged] [nonCAPTCHA]

15 Feb 2012, 1:37 AM

#4

drbyte

Sensei

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

Re: Error in DB upgrade

Seems to be something amuck with Windows implementation of MySQL that's causing confusion for various users.

Change the DB schema in your /zc_install/sql/mysql_upgrade_zencart_139_to_150.sql file and remove the "DEFAULT '' " part from the line that's throwing the error.

http://www.zen-cart.com/forum/showthread.php?t=191117

.
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.

15 Feb 2012, 3:56 AM

#5

one_tall_man

Zen Follower

Join Date:: Feb 2009
Posts:: 125
Plugin Contributions:: 0

Re: Error in DB upgrade

DrByte:

Seems to be something amuck with Windows implementation of MySQL that's causing confusion for various users.

Change the DB schema in your /zc_install/sql/mysql_upgrade_zencart_139_to_150.sql file and remove the "DEFAULT '' " part from the line that's throwing the error.

http://www.zen-cart.com/forum/showthread.php?t=191117

I see. Thank you for looking into this so promptly! :clap: I'll stay on 1.3.9 until something stable comes up, as I have no resources for this kind of troubleshooting (this business only accepts money orders, so more security of 1.5 is not a burning issue).

My install: was Vanilla 1.3.9h, now 1.5.5b, Apache 2.4, PHP 7.0.6, MySQL 5.5.8 64b, Windows 7 64b, 8GB RAM, i3 3.3gHz
Modules: [Payment=Paypal] [Shipping=Canada Post 1.5.3 merged] [nonCAPTCHA]