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
=================================
Bookmarks