After Upgrade: Unfortunately, 16 SQL errors have occurred.

[hblueair]

Hi there,

I got 16 SQL errors when I upload the new version. Do you know why would this happen??

Thanks,
Hebee

ALTER TABLE cp_order_detail ADD product_ean13 VARCHAR(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL AFTER product_price

(1060) Duplicate column name 'product_ean13'
ALTER TABLE cp_order_detail ADD product_quantity_return INT(10) UNSIGNED NOT NULL DEFAULT 0 AFTER product_quantity

(1060) Duplicate column name 'product_quantity_return'
ALTER TABLE cp_state ADD tax_behavior SMALLINT(1) NOT NULL DEFAULT 0 AFTER iso_code

(1060) Duplicate column name 'tax_behavior'
ALTER TABLE cp_product ADD reduction_from DATE NOT NULL AFTER reduction_percent

(1060) Duplicate column name 'reduction_from'
ALTER TABLE cp_product ADD reduction_to DATE NOT NULL AFTER reduction_from

(1060) Duplicate column name 'reduction_to'
ALTER TABLE cp_range_weight ADD id_carrier INTEGER UNSIGNED DEFAULT NULL AFTER id_range_weight

(1060) Duplicate column name 'id_carrier'
ALTER TABLE cp_range_weight DROP INDEX range_weight_index, ADD UNIQUE range_weight_unique (delimiter1, delimiter2, id_carrier)

(1091) Can't DROP 'range_weight_index'; check that column/key exists
ALTER TABLE cp_range_price ADD id_carrier INTEGER UNSIGNED DEFAULT NULL AFTER id_range_price

(1060) Duplicate column name 'id_carrier'
ALTER TABLE cp_range_price DROP INDEX range_price_index, ADD UNIQUE range_price_unique (delimiter1, delimiter2, id_carrier)

(1091) Can't DROP 'range_price_index'; check that column/key exists
/* CONTENTS */ /* One request per insert, if one die, other can be inserted */ INSERT INTO cp_hook (`name`, `title`, `description`, `position`) VALUES ('adminCustomers', 'Display in Back-Office, tab AdminCustomers', 'Launch modules when the tab AdminCustomers is displayed on back-office.', 0)

INSERT INTO cp_hook (`name`, `title`, `description`, `position`) VALUES ('createAccount', 'Successful customer create account', 'Called when new customer create account successfuled', 0)

INSERT INTO cp_hook (`name`, `title`, `description`, `position`) VALUES ('customerAccount', 'Customer account page display in front office', 'Called when a customer access to his account.', 1)

INSERT INTO cp_hook (`name`, `title`, `description`, `position`) VALUES ('orderSlip', 'Called when a order slip is created', 'Called when a quantity of one product change in an order.', 0)

INSERT INTO cp_hook (`name`, `title`, `description`, `position`) VALUES ('productTab', 'Tabs on product page', 'Called on order product page tabs', 0)

INSERT INTO cp_hook (`name`, `title`, `description`, `position`) VALUES ('productTabContent', 'Content of tabs on product page', 'Called on order product page tabs', 0)

INSERT INTO cp_hook (`name`, `title`, `description`, `position`) VALUES ('shoppingCart', 'Shopping cart footer', 'Display some specific informations on the shopping cart page', 0)

INSERT INTO `cp_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_MAIL_TYPE', '3', NOW(), NOW())

INSERT INTO `cp_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_TOKEN_ENABLE', '0', NOW(), NOW())

INSERT INTO `cp_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_GIFT_WRAPPING_PRICE', '0', NOW(), NOW())

/* NEW RANGES */ INSERT IGNORE INTO cp_range_price ( id_carrier, delimiter1, delimiter2 ) (SELECT c.id_carrier, rp.delimiter1, rp.delimiter2 FROM cp_range_price rp CROSS JOIN cp_carrier c WHERE c.deleted = 0 AND c.active = 1 )

INSERT IGNORE INTO cp_range_weight ( id_carrier, delimiter1, delimiter2 ) (SELECT c.id_carrier, rp.delimiter1, rp.delimiter2 FROM cp_range_price rp CROSS JOIN cp_carrier c WHERE c.deleted = 0 AND c.active = 1 )

DELETE FROM cp_range_price WHERE id_carrier IS NULL

DELETE FROM cp_range_weight WHERE id_carrier IS NULL

/* CONFIGURATION VARIABLE */ /* STRUCTURE */ SET NAMES 'utf8'

ALTER TABLE cp_orders ADD total_wrapping DECIMAL(10,2) NOT NULL DEFAULT 0 AFTER total_shipping

(1060) Duplicate column name 'total_wrapping'
ALTER TABLE cp_carrier ADD range_behavior TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER shipping_handling

(1060) Duplicate column name 'range_behavior'
ALTER TABLE cp_order_detail ADD product_supplier_reference VARCHAR(32) NULL AFTER product_reference

(1060) Duplicate column name 'product_supplier_reference'
ALTER TABLE cp_product ADD supplier_reference VARCHAR(32) NULL AFTER reference

(1060) Duplicate column name 'supplier_reference'
ALTER TABLE cp_product_attribute ADD supplier_reference VARCHAR(32) NULL AFTER reference

(1060) Duplicate column name 'supplier_reference'
ALTER TABLE cp_customer ADD UNIQUE customer_email(email(128))

(1061) Duplicate key name 'customer_email'
ALTER TABLE cp_product_download ADD active TINYINT(1) UNSIGNED NOT NULL DEFAULT 1 AFTER nb_downloadable

(1060) Duplicate column name 'active'
/* CONTENTS */ INSERT INTO cp_hook (`name`, `title`, `description`, `position`) VALUES ('createAccountForm', 'Customer account creation form', 'Display some information on the form to create a customer account', 1)

INSERT INTO `cp_lang` (`name`, `active`, `iso_code`) VALUES ('Român� (Romanian)', 0, 'ro'), ('�εοελληνική (Greek)', 0, 'gr'), ('Sloven�ina (Slovak)', 0, 'sk')

/* CONFIGURATION VARIABLE */

[DrÿSs']

Hi,

It seems that you have executed 2 times the updater (cannot create new column because already created, cannot delete old column because already deleted).

However this should not be a problem for you shop, is it working nice ?

[hblueair]

Hi there,

Nope, the front page just got "Hack attempt" in the middle, what should I do?

Do you mean I have to set up the database again?

Thanks,
Hebee

[DrÿSs']

Your database seems to be corrupted.

Can I have access to your FTP ?

Thanks

[cloudseat]

Hi Phillippe, sorry to hijack the thread but I'm having the same problem (4 errors - see this post). Can I give you my ftp access too?
I was thinking of installing a clean version of 1.2.0.5 and then importing the non-corrupted fields into the new DB.
Is that a good idea?