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?

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

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?

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.

Here's the complete insert content:```
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);

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?

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

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.