mysql upgrading 1.25-1.03.2

[danmcguire]

Hello,

Am upgrading from 1.26 to1.03.02 via fresh install and database upgrade. This is the second site I've upgraded but I have hit a bit of a snag. The site runs and appears fine, but in admin, I get the message that the database needs to be patched/updated.

====================================
Server info says:
Linux 2.6.17.6v2 MySQL 4.1.19-standard
PHP Version: 4.4.2 (Zend: 1.3.0)

Zen Cart 1.3.0.2
Database Patch Level: 1.3.0.1
v1.3.0.2 [2006-07-30 03:03:06] (Version Update 1.3.0.1->1.3.0.2)
v1.2.7 [2006-07-30 02:59:45] (Version Update 1.2.6->1.2.7)
v1.2.6 [2006-07-30 02:58:40] (Version Update 1.2.5->1.2.6)
v1.2.5 [2005-08-09 02:24:01] (Version Update 1.2.4->1.2.5)
v1.2.4 [2005-08-09 02:23:26] (Version Update 1.2.3->1.2.4)
v1.2.3 [2005-08-09 02:22:40] (Version Update 1.2.2->1.2.3)
v1.2.2 [2005-08-09 02:22:12] (Zen-Cart Core Files Version Info)

PHP Version 4.4.2

========================================

When attempting to upgrade via phpadmymin I get the 2 following errors. I have backups of the original database and have upgraded using zc_install, as well as using mysql queries in phpmyadmin. Any help/advice would be great.

======================================
SQL query:
Error

INSERT INTO configuration_group
VALUES (
'30', 'EZ-Pages Settings', 'EZ-Pages Settings', 30, '1'
);

MySQL said: Documentation
#1062 - Duplicate entry '30' for key 1


SQL query:
Error

SQL query: Documentation

# add ability to send newsletters to self
INSERT INTO query_builder( query_category, query_name, query_description, query_string )
VALUES (
'email,newsletters', 'Administrator', 'Just the email account of the current administrator', 'select \'ADMIN\' as customers_firstname, admin_name as customers_lastname, admin_email as customers_email_address from TABLE_ADMIN where admin_id = $SESSION:admin_id'
);

MySQL said: Documentation
#1062 - Duplicate entry 'Administrator' for key 2

=================================

[DrByte]

In the case of those two statement failures, they can be ignored ... since the record they are trying to insert already exists.

If you wish to explicitly skip them, put a # sign in front of the statement in the SQL file you're running.

As for database-version not being set properly, that's an indicator that not all of the SQL statements in that script have been run yet.

Since you're enjoying using phpMyAdmin instead of the recommended use of zc_install to do database upgrades, simply run the rest of the statements again.
If you choose to use zc_install, put the # in front of the two failing statements, and let zc_install do the rest of the work.

[danmcguire]

Thank you Doc.

Per your instructions I commented out the 2 statements. On a freshbackup copy of the database, I ran the zc_install, upgrading the database only. Result, no errors during the upgrade and zencart is happy that the database version is now up to date.
" Zen Cart 1.3.0.2
Database Patch Level: 1.3.0.2"

A big sigh of relief. Now we can go get a pint or 2.

Again, thank you.