Neoz Posted August 28, 2011 Share Posted August 28, 2011 Setelah upgrade dari v.1.3.2.3 ke v.1.4.4.1, muncul error: ALTER TABLE `ps_order_detail` ADD `group_reduction` DECIMAL(10, 2) NOT NULL AFTER `reduction_amount` (1060) Duplicate column name 'group_reduction' ALTER TABLE `ps_order_detail` ADD `ecotax_tax_rate` DECIMAL(5, 3) NOT NULL AFTER `ecotax` (1060) Duplicate column name 'ecotax_tax_rate' INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) SELECT 'PS_LOCALE_LANGUAGE', l.`iso_code`, NOW(), NOW() FROM `ps_configuration` c INNER JOIN `ps_lang` l ON (l.`id_lang` = c.`value`) WHERE c.`name` = 'PS_LANG_DEFAULT' (1062) Duplicate entry 'PS_LOCALE_LANGUAGE' for key 'name' INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) SELECT 'PS_LOCALE_COUNTRY', co.`iso_code`, NOW(), NOW() FROM `ps_configuration` c INNER JOIN `ps_country` co ON (co.`id_country` = c.`value`) WHERE c.`name` = 'PS_COUNTRY_DEFAULT' (1062) Duplicate entry 'PS_LOCALE_COUNTRY' for key 'name' Apa ada yang punya solusi ? :( :( :( Link to comment Share on other sites More sharing options...
Syah Jehan Posted October 1, 2011 Share Posted October 1, 2011 mas bro di ps 1.4.4.1 ada beberapa field di beberapa table yang sudah dihilangkan lebih baik database ps yang lama di backup atau di export dulu untuk keamanannya setelah di export jika host memperbolehkan lebih dari 1 database create baru saja untuk ps 1.4.4.1 baru update db yang lam via phpmyadmin sebelum update cek dahulu field-2 yang sebelumnya, modifikasi hasil export-nya baru di update itu yang saya lakukan pada saat saya update database shipping ada beberapa field yang dihilangkan.. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now