Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2005
    Posts
    3
    Plugin Contributions
    0

    Default Update database from 1.2.6 to 1.3.0.1

    While trying to update database from verison 1.2.6 to 1.3.01 I get an error:

    1136 Column count doesn't match value count at row 1
    in:
    [INSERT INTO zen_configuration_group VALUES (30, 'EZ-Pages Settings', 'EZ-Pages Settings', 30, '1');]

    Any suggestions how to solve this problem?

  2. #2
    Join Date
    Jan 2004
    Location
    N of San Antonio TX
    Posts
    9,106
    Plugin Contributions
    11

    Default Re: Update database from 1.2.6 to 1.3.0.1

    first question is "did you get the full 1.3.0.1 or just the upgrade?"

    Sounds like you might have missed the database update in basic 1.3.

    If you did not get the FULL 1.3.1, get it and do the database update through the zc_install.

    HTH

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

    Default Re: Update database from 1.2.6 to 1.3.0.1

    Actually, it sounds like you've altered the structure of the configuration_group table to have more or fewer fields than normal.

    What mods have you installed on your old shop?
    .

    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.

  4. #4
    Join Date
    Mar 2005
    Posts
    3
    Plugin Contributions
    0

    Default Re: Update database from 1.2.6 to 1.3.0.1

    Quote Originally Posted by DrByte
    Actually, it sounds like you've altered the structure of the configuration_group table to have more or fewer fields than normal.

    What mods have you installed on your old shop?
    In the meantime I figured out that configuration_group is containing additional column language_id. This is why it fails. Might be that this column results from installing a modification. Main reason for the bug is: Original update script is not explicitly defining the column names for insert statement. This is why it fails.

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

    Default Re: Update database from 1.2.6 to 1.3.0.1

    Here's the complete insert content:
    Code:
    INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (30, 'EZ-Pages Settings', 'EZ-Pages Settings', 30, 1);
    .

    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.

  6. #6
    Join Date
    Dec 2005
    Posts
    11
    Plugin Contributions
    0

    Default Re: Update database from 1.2.6 to 1.3.0.1

    This is a question: so finally upgrading from 1.2.6 to 1.3.0.1 needs following steps:

    0. backup old site and old db
    1. download 1.3.0.1 full pack fron sourceforge
    2. upload and overvrite all files (templates and langs overides will still your old)
    3. run zc_install/upgrade.php
    4. correct any error could be in the templates.

    is this the procedure?

    Moreover old plugins and old templates will work also with 1.3.x?

  7. #7
    Join Date
    Jan 2004
    Location
    N of San Antonio TX
    Posts
    9,106
    Plugin Contributions
    11

    Default Re: Update database from 1.2.6 to 1.3.0.1

    Tassoman,
    There are instructions in the docs that you download and this thread from Ajeh is excellent advice when upgrading.

  8. #8
    Join Date
    Jan 2005
    Location
    Virginia, USA
    Posts
    6
    Plugin Contributions
    0

    Default Re: Update database from 1.2.6 to 1.3.0.1

    My first two attempts at this upgrade failed miserably ;) Fortunately, I made backups immediately before each attempt. I think I'm going to wait a little longer so that more of the addon scripts are updated and available. I'd really like to see the SEFU, Froogle, and a few of the other really popular ones integrated into the core so that it's not such a pain to go through these upgrades. Thanks for the link DBLTOE, I'll have to visit that before I make my next attempt.
    Technical Values
    Get in on the Biggest launch of the year!
    SEO Cash Cow
    Offer will close when the limited number of available packages are sold out.

 

 

Similar Threads

  1. v151 How to update product from mage database?
    By thanhv in forum General Questions
    Replies: 2
    Last Post: 21 Mar 2013, 07:38 AM
  2. Replies: 2
    Last Post: 9 Jan 2013, 03:20 PM
  3. Database Won't Update from 1.3.8 to 1.3.9
    By Aevalin in forum Upgrading from 1.3.x to 1.3.9
    Replies: 4
    Last Post: 5 Jun 2011, 06:39 PM
  4. Update database from 1.3.8 to 1.3.9
    By bargincircus in forum Upgrading from 1.3.x to 1.3.9
    Replies: 3
    Last Post: 4 Dec 2010, 05:47 PM
  5. Update to 1.3.8a Probblems after Database Update
    By wirnsperger in forum Installing on a Linux/Unix Server
    Replies: 0
    Last Post: 4 Feb 2010, 06:41 PM

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