Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2005
    Location
    United Kingdom
    Posts
    576
    Plugin Contributions
    0

    Default Database Upgrade Error / V1.5.1 to V1.5.5 / Data too long for column

    Hi,

    My 1.5.5 site is already built so I'm now just importing my live database and running a database upgrade. When doing so I get the following error:

    [24-Mar-2018 23:50:36 UTC] MySQL error 1406 encountered during zc_install:
    Data too long for column 'shipping_method' at row 5748
    ALTER TABLE zen_orders MODIFY shipping_method VARCHAR(255) NOT NULL DEFAULT '';
    Any advice on how to fix this please?

    Brent

  2. #2
    Join Date
    Mar 2005
    Location
    United Kingdom
    Posts
    576
    Plugin Contributions
    0

    Default Re: Database Upgrade Error / V1.5.1 to V1.5.5 / Data too long for column

    OK I ran the following and it seems to have worked the second time. Looking in phpMyAdmin the table has been updated.

    PHP Code:
    ALTER TABLE orders MODIFY shipping_method VARCHAR(255NOT NULL DEFAULT ''

  3. #3
    Join Date
    Jul 2012
    Posts
    15,022
    Plugin Contributions
    17

    Default Re: Database Upgrade Error / V1.5.1 to V1.5.5 / Data too long for column

    Quote Originally Posted by Brent View Post
    OK I ran the following and it seems to have worked the second time. Looking in phpMyAdmin the table has been updated.

    PHP Code:
    ALTER TABLE orders MODIFY shipping_method VARCHAR(255NOT NULL DEFAULT ''
    Umm, but if the above query were to be run specifically against this database knowing the information from both posts, then the query should have been as entered in phpmyadmin:
    PHP Code:
    ALTER TABLE zen_orders MODIFY shipping_method VARCHAR(255NOT NULL DEFAULT ''
    Adding the prefix of zen_ to the table name as reported from the first post.

    Therefore, question whether the verification of the update was correct and if the action really took place. (or, that there was a slight mistake in posting, not sure which or what elese it may have been.)
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...
    Upgraded to Zen Cart V1.5.3 from V1.5.1 from V1.5.0 from V1.3.9h

  4. #4
    Join Date
    Mar 2005
    Location
    United Kingdom
    Posts
    576
    Plugin Contributions
    0

    Default Re: Database Upgrade Error / V1.5.1 to V1.5.5 / Data too long for column

    Quote Originally Posted by mc12345678 View Post
    Therefore, question whether the verification of the update was correct and if the action really took place. (or, that there was a slight mistake in posting, not sure which or what elese it may have been.)
    The post was correct but I could have been more explicit. Apologies.

    I ran the query via my cart so I didn't need the prefix. The problem was reproducible though as I ran the upgrade a further 6 times trying to solve my issue with Image Handler 5 and every time this table failed to update. I then fixed via either phpMyAdmin or my cart.

    I may need to run the upgrade again as I'm still stuck with IH so could give further feedback if needed.

 

 

Similar Threads

  1. Data too long for column
    By yd29999 in forum General Questions
    Replies: 0
    Last Post: 8 Sep 2017, 06:45 PM
  2. Direct Bank Deposit - 1406 Data too long for column 'shipping_method'
    By remoteone in forum Addon Payment Modules
    Replies: 13
    Last Post: 31 Mar 2009, 12:24 AM
  3. New Products column too long
    By ckosloff in forum Customization from the Admin
    Replies: 2
    Last Post: 14 Nov 2008, 12:01 AM
  4. 1406 Data too long for column "last_page_url" at row 1
    By time4fishing in forum PayPal Website Payments Pro support
    Replies: 2
    Last Post: 11 Jan 2008, 01:00 AM
  5. Data too long for column 'shipping_method' - Big Royal Mail
    By pwhyles in forum Addon Shipping Modules
    Replies: 3
    Last Post: 9 Nov 2006, 08:49 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