If this is your first visit, check our documentation. To post, register or login.
Forums / Upgrading from 1.2 to 1.3.x / BIG Problem with upgrade

BIG Problem with upgrade

Locked

Started by path2u on 27 Jul 2006, 9:10 PM · Views: 1,926

Results 1 to 1 of 1
This thread is locked. New replies are disabled.
27 Jul 2006, 9:10 PM
#1
path2u avatar

path2u

New Zenner

Join Date:
Apr 2005
Posts:
10
Plugin Contributions:
0

BIG Problem with upgrade

I have no idea what is has happened, but the other day I upgraded our store from 1.2.4 to 1.3.0.2. Everything seemed to have worked just fine, however ... until orders started rolling in. When I upgraded I made DB copy from with phpmyadmin and called it DB2, as well as making duplicate of entire zencart store directory. Then I ran upgrade and changed config files.
It seems that since the upgrade, a few new customers signed up, but never showed up in the DB. That would not be that big of a deal, except ... several orders always occuring in sequence one after the other would occur as being paid for under this new customers info and card, yet with another customers email and phone number.
So someone who placed no orders got 3 notifications that they did in the same day.
Now, the credit card appears to be the correct one, even though it is a non existent member in the DB, verify by looking in phpmyadmin as well.
I hope that was easier to follow than it was to write ... ha ha.
I found a table titled upgrade exception with the following info inside if this means anything. I have had to revert the store and DB back to old versions for now ... luckily I made good backups, but I am at a loss for what occured.
Any suggestions would be very welcome.
Thanks,
Jesse
old store( currently active ) is at lightworker.com/store
newstore ( maintenance mode ) is at lightworker.com/store2

1 mysql_upgrade_zencart_127_to_130.sql Cannot drop index idx_categories_parent_id_zen on ... 2006-07-25 10:15:47 ALTER TABLE categories DROP INDEX idx_categories_p...
2 mysql_upgrade_zencart_127_to_130.sql Cannot drop index idx_customer_id_zen on table cou... 2006-07-25 10:15:47 ALTER TABLE coupon_gv_customer DROP INDEX idx_cust...
3 mysql_upgrade_zencart_127_to_130.sql Cannot drop index idx_paypal_paypal_ipn_id_zen on ... 2006-07-25 10:15:47 ALTER TABLE paypal DROP INDEX idx_paypal_paypal_ip...
4 mysql_upgrade_zencart_127_to_130.sql Cannot drop index idx_prod_opt_val_id_zen on table... 2006-07-25 10:15:47 ALTER TABLE products_options_values DROP INDEX idx...
5 mysql_upgrade_zencart_130_to_1301.sql Cannot insert configuration_group_title "EZ-Pages ... 2006-07-25 10:15:47 INSERT INTO configuration_group VALUES ('30', 'EZ-...
6 mysql_upgrade_zencart_1301_to_1302.sql Cannot insert configuration_key "UPLOAD_PREFIX" be... 2006-07-25 10:15:47 INSERT INTO configuration (configuration_title, co...
7 mysql_upgrade_zencart_1301_to_1302.sql Cannot insert configuration_key "TEXT_PREFIX" beca... 2006-07-25 10:15:47 INSERT INTO configuration (configuration_title, co...