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...