Jump to content

Upgrade 1.4.4.1 Error


Recommended Posts

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

  • 1 month later...

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...