Jump to content

Unfortunately 1 SQL errors have occured


Recommended Posts

Going form 1.2.0.2 get this error - Going to latest version 1.2.2.0
- can anything be done?

SET NAMES 'utf8'

/* ##################################### */ /* STRUCTURE */ /* ##################################### */ ALTER TABLE `ps_customization` ADD `quantity_refunded` INT NOT NULL DEFAULT '0'

ALTER TABLE `ps_customization` ADD `quantity_returned` INT NOT NULL DEFAULT '0'

ALTER TABLE `ps_alias` CHANGE `id_alias` `id_alias` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT

ALTER TABLE `ps_attribute_impact` CHANGE `id_attribute_impact` `id_attribute_impact` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT

ALTER TABLE `ps_customization` CHANGE `id_customization` `id_customization` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT

ALTER TABLE `ps_customization_field` CHANGE `id_customization_field` `id_customization_field` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT

ALTER TABLE `ps_subdomain` CHANGE `id_subdomain` `id_subdomain` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT

/* ##################################### */ /* CONTENTS */ /* ##################################### */ INSERT INTO ps_hook (`name`, `title`, `description`, `position`) VALUES ('postUpdateOrderStatus', 'Post update of order status', NULL, 0)

(1062) Duplicate entry 'postUpdateOrderStatus' for key 2
INSERT INTO `ps_search_engine` (`server`,`getvar`) VALUES ('bing.com','q')

INSERT INTO `ps_hook_module` (`id_module`, `id_hook`, `position`) VALUES (19, 9, 1)

/* PHP:decode_content(); */

SET NAMES 'utf8'

/* ##################################### */ /* STRUCTURE */ /* ##################################### */ /* ##################################### */ /* CONTENTS */ /* ##################################### */ /* PHP:decode_content(); */

SET NAMES 'utf8'

/* ##################################### */ /* STRUCTURE */ /* ##################################### */ /* ##################################### */ /* CONTENTS */ /* ##################################### */ UPDATE `ps_order_state_lang` SET `name` = 'Shipped' WHERE `id_order_state` = 4 AND `id_lang` = 1

UPDATE `ps_order_state_lang` SET `template` = 'shipped' WHERE `id_order_state` = 4 AND `template` = 'shipping'

/* PHP:reorderpositions(); */

SET NAMES 'utf8'

/* ##################################### */ /* STRUCTURE */ /* ##################################### */ ALTER TABLE `ps_configuration` DROP INDEX `configuration_name`

ALTER TABLE `ps_order_detail` ADD `product_quantity_in_stock` INT(10) NOT NULL DEFAULT 0 AFTER `product_quantity`

ALTER TABLE `ps_order_detail` ADD `product_quantity_reinjected` INT(10) UNSIGNED NOT NULL DEFAULT 0 AFTER `product_quantity_return`

/* ##################################### */ /* CONTENTS */ /* ##################################### */ UPDATE `ps_product` SET `out_of_stock` = 0 WHERE `id_product` IN ((SELECT `id_product` FROM `ps_product_download`))

SET NAMES 'utf8'

/* ##################################### */ /* STRUCTURE */ /* ##################################### */ /* ##################################### */ /* CONTENTS */ /* ##################################### */ /* PHP:update_modules_sql(); */

SET NAMES 'utf8'

/* ##################################### */ /* STRUCTURE */ /* ##################################### */ /* ##################################### */ /* CONTENTS */ /* ##################################### */ SET NAMES 'utf8'

/* ##################################### */ /* STRUCTURE */ /* ##################################### */ /* ##################################### */ /* CONTENTS */ /* ##################################### */ INSERT INTO ps_configuration (name, value, date_add, date_upd) VALUES ('PS_THEME_V11', 0, NOW(), NOW())

/* PHP */ /* PHP:update_carrier_url(); */

/* PHP:moduleReinstaller('blocksearch'); */

SET NAMES 'utf8'

ALTER TABLE `ps_discount_category` ADD INDEX ( `id_discount` )

DELETE FROM `ps_delivery` WHERE `id_range_weight` != NULL AND `id_range_weight` NOT IN (SELECT `id_range_weight` FROM `ps_range_weight`)

DELETE FROM `ps_delivery` WHERE `id_range_price` != NULL AND `id_range_weight` NOT IN (SELECT `id_range_price` FROM `ps_range_price`)

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