Jump to content

Unfortunately, 4 SQL errors have occurred.


Recommended Posts

Tried to upgrade v1.3.2 to latest v1.4.1.0 got these errors:


Your shop version is now 1.4.1.0

Unfortunately, 4 SQL errors have occurred.

ALTER TABLE `ps_order_detail` ADD `reduction_percent` DECIMAL(10, 2) NOT NULL AFTER `product_price`

(1060) Duplicate column name 'reduction_percent'

ALTER TABLE `ps_order_detail` ADD `reduction_amount` DECIMAL(20, 6) NOT NULL AFTER `reduction_percent`

(1060) Duplicate column name 'reduction_amount'

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_1_3_2_UPDATE_DATE', NOW(), NOW(), NOW())

(1062) Duplicate entry 'PS_1_3_2_UPDATE_DATE' for key 2

ALTER TABLE `ps_zone` DROP `enabled`

(1091) Can't DROP 'enabled'; check that column/key exists


How can fix this?

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