Ship In Cart

[plamastus]

Hi,

Phoenix 1.0.8.0
Ship_In_Cart_5.6_Phoenix_Cart

I nee help fixing a duplicate key problem, I previously installed this addon and the public_html directory had problems, so I restored the backup. Apparently my backup did not have Ship_In_Cart_5.6_Phoenix_Cart, but the keys are in the database. I am getting the following error when I try to install.

1062 - Duplicate entry 'MODULE_CONTENT_SC_SHIPPING_VERSION' for key 'uq_configuration_key'

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, set_function) VALUES ('Current Version', 'MODULE_CONTENT_SC_SHIPPING_VERSION', '5.2.', 'Version info. It is read only', '6', '1', NOW(), 'cm_sc_shipping::readonly(')

and

1062 - Duplicate entry 'MODULE_CONTENT_SC_ORDER_TOTAL_VERSION' for key 'uq_configuration_key'

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, set_function) VALUES ('Current Version', 'MODULE_CONTENT_SC_ORDER_TOTAL_VERSION', '5.2.', 'Version info. It is read only', '6', '1', NOW(), 'cm_sc_order_total::readonly(')

Thanks for any help,

Patrick

[raiwa]

Hi,
To fix the error, you have to manually delete all configuration entries of the ship in cart Modules in the database:
IN ANY CASE, BACKUP THE DATABASE FIRST !!!
In the database administration program (phpMy Admin):
Select the table “configuration”,
Search: Column: “configuration_key”,
Operator: “like% ...%”,
Value: “MODULE_CONTENT_SC_SHIPPING_”,
Delete all entries in the search result.
Do the same for:
Value: “MODULE_CONTENT_SC_ORDER_TOTAL_”,
Then install the modules in Admin.


PS: Backup your database more often before applying changes. If your DB backup is correct, this shouldn't happen.