weaselbringer Posted September 3, 2009 Share Posted September 3, 2009 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_INCREMENTALTER TABLE `ps_attribute_impact` CHANGE `id_attribute_impact` `id_attribute_impact` INT(10) UNSIGNED NOT NULL AUTO_INCREMENTALTER TABLE `ps_customization` CHANGE `id_customization` `id_customization` INT(10) UNSIGNED NOT NULL AUTO_INCREMENTALTER TABLE `ps_customization_field` CHANGE `id_customization_field` `id_customization_field` INT(10) UNSIGNED NOT NULL AUTO_INCREMENTALTER 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 2INSERT 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` = 1UPDATE `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 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