Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2009
    Posts
    123
    Plugin Contributions
    0

    Default Error in DB upgrade

    Immediately after clicking upgrade DB getting this:

    Code:
    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]

  2. #2
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

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

  3. #3
    Join Date
    Feb 2009
    Posts
    123
    Plugin Contributions
    0

    Default Re: Error in DB upgrade

    Quote Originally Posted by DrByte View Post
    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]

  4. #4
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

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

  5. #5
    Join Date
    Feb 2009
    Posts
    123
    Plugin Contributions
    0

    Default Re: Error in DB upgrade

    Quote Originally Posted by DrByte View Post
    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! 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]

 

 

Similar Threads

  1. Error on upgrade 1.3.0.2 to 1.3.7
    By bobdog in forum Upgrading from 1.3.x to 1.3.9
    Replies: 4
    Last Post: 8 Apr 2007, 03:25 AM
  2. Upgrade to 1.2.7 Error
    By audradh in forum Installing on a Linux/Unix Server
    Replies: 2
    Last Post: 17 May 2006, 09:14 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR