Jump to content

upgrade dari 1.2.5.0 ke 1.3.1 , database error


Recommended Posts

salam kawan2

saya upgrade ps dari 1.2.5.0 ke 1.3.1. pada proses instalasi/upgrading muncul pesan database error, diantaranya:

SET NAMES 'utf8'

/* ##################################### */ /* STRUCTURE */ /* ##################################### */ ALTER TABLE `ps_product` CHANGE `reduction_from` `reduction_from` DATE NOT NULL DEFAULT '1970-01-01', CHANGE `reduction_to` `reduction_to` DATE NOT NULL DEFAULT '1970-01-01'

ALTER TABLE `ps_order_detail` CHANGE `tax_rate` `tax_rate` DECIMAL(10, 3) NOT NULL DEFAULT '0.000'

ALTER TABLE `ps_group` ADD `price_display_method` TINYINT NOT NULL DEFAULT 0 AFTER `reduction`

(1060) Duplicate column name 'price_display_method'
CREATE TABLE `ps_carrier_group` ( `id_carrier` int(10) unsigned NOT NULL, `id_group` int(10) unsigned NOT NULL, UNIQUE KEY `id_carrier` (`id_carrier`,`id_group`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_carrier_group' already exists
ALTER TABLE `ps_country` ADD `need_identification_number` TINYINT( 1 ) NOT NULL

(1060) Duplicate column name 'need_identification_number'
ALTER TABLE `ps_customer` ADD `dni` VARCHAR( 16 ) NULL AFTER `firstname`

(1060) Duplicate column name 'dni'
ALTER TABLE `ps_image` ADD INDEX `product_position` (`id_product`, `position`)

(1061) Duplicate key name 'product_position'
ALTER TABLE `ps_hook_module` ADD INDEX `id_module` (`id_module`)

(1061) Duplicate key name 'id_module'
ALTER TABLE `ps_customer` ADD INDEX `id_customer_passwd` (`id_customer`, `passwd`)

(1061) Duplicate key name 'id_customer_passwd'
ALTER TABLE `ps_tag` ADD INDEX `id_lang` (`id_lang`)

(1061) Duplicate key name 'id_lang'
ALTER TABLE `ps_customer_group` ADD INDEX `id_customer` (`id_customer`)

(1061) Duplicate key name 'id_customer'
ALTER TABLE `ps_category_group` ADD INDEX `id_category` (`id_category`)

(1061) Duplicate key name 'id_category'
ALTER TABLE `ps_image` ADD INDEX `id_product_cover` (`id_product`, `cover`)

(1061) Duplicate key name 'id_product_cover'
ALTER TABLE `ps_employee` ADD INDEX `id_employee_passwd` (`id_employee`, `passwd`)

(1061) Duplicate key name 'id_employee_passwd'
ALTER TABLE `ps_product_attribute` ADD INDEX `product_default` (`id_product`, `default_on`)

(1061) Duplicate key name 'product_default'
ALTER TABLE `ps_product_download` ADD INDEX `product_active` (`id_product`, `active`)

(1061) Duplicate key name 'product_active'
ALTER TABLE `ps_tab` ADD INDEX `class_name` (`class_name`)

(1061) Duplicate key name 'class_name'
ALTER TABLE `ps_module_currency` ADD INDEX `id_module` (`id_module`)

(1061) Duplicate key name 'id_module'
ALTER TABLE `ps_product_attribute_combination` ADD INDEX `id_product_attribute` (`id_product_attribute`)

(1061) Duplicate key name 'id_product_attribute'
ALTER TABLE `ps_orders` ADD INDEX `invoice_number` (`invoice_number`)

(1061) Duplicate key name 'invoice_number'
ALTER TABLE `ps_product_tag` ADD INDEX `id_tag` (`id_tag`)

(1061) Duplicate key name 'id_tag'
ALTER TABLE `ps_cms_lang` CHANGE `id_cms` `id_cms` INT(10) UNSIGNED NOT NULL

ALTER TABLE `ps_tax` CHANGE `rate` `rate` DECIMAL(10, 3) NOT NULL

ALTER TABLE `ps_order_detail` ADD `discount_quantity_applied` TINYINT(1) NOT NULL DEFAULT 0 AFTER `ecotax`

(1060) Duplicate column name 'discount_quantity_applied'
ALTER TABLE `ps_orders` ADD `total_products_wt` DECIMAL(10, 2) NOT NULL AFTER `total_products`

(1060) Duplicate column name 'total_products_wt'
/* ##################################### */ /* CONTENTS */ /* ##################################### */ UPDATE `ps_group` SET `price_display_method` = (SELECT `value` FROM `ps_configuration` WHERE `name` = 'PS_PRICE_DISPLAY')

UPDATE `ps_configuration` SET `value` = ROUND(value / (1 + ( SELECT rate FROM ( SELECT t.`rate`, COUNT(*) n FROM `ps_orders` o LEFT JOIN `ps_carrier` c ON (o.`id_carrier` = c.`id_carrier`) LEFT JOIN `ps_tax` t ON (t.`id_tax` = c.`id_tax`) WHERE c.`deleted` = 0 AND c.`shipping_handling` = 1 GROUP BY o.`id_carrier` ORDER BY n DESC LIMIT 1 ) myrate ) / 100), 6) WHERE `name` = 'PS_SHIPPING_HANDLING'

DELETE FROM `ps_configuration` WHERE `name` = 'PS_PRICE_DISPLAY'

DELETE FROM `ps_product_attachment` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`)

DELETE FROM `ps_discount_quantity` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`)

DELETE FROM `ps_pack` WHERE `id_product_pack` NOT IN (SELECT `id_product` FROM `ps_product`) OR `id_product_item` NOT IN (SELECT `id_product` FROM `ps_product`)

DELETE FROM `ps_product_sale` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`)

DELETE FROM `ps_scene_products` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`)

DELETE FROM `ps_search_index` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`)

DELETE FROM `ps_search_word` WHERE `id_word` NOT IN (SELECT `id_word` FROM `ps_search_index`)

DELETE FROM `ps_tag` WHERE `id_lang` NOT IN (SELECT `id_lang` FROM `ps_lang`)

DELETE FROM `ps_search_word` WHERE `id_lang` NOT IN (SELECT `id_lang` FROM `ps_lang`)

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PRESTASTORE_LIVE', 1, NOW(), NOW()), ('PS_SHOW_ALL_MODULES', 0, NOW(), NOW()), ('PS_BACKUP_ALL', 0, NOW(), NOW()), ('PS_1_3_UPDATE_DATE', NOW(), NOW(), NOW()), ('PS_PRICE_ROUND_MODE', 2, NOW(), NOW())

(1062) Duplicate entry 'PRESTASTORE_LIVE' for key 2
INSERT INTO `ps_hook` (`name`, `title`, `description`, `position`) VALUES ('createAccountTop', 'Block above the form for create an account', NULL , '1'), ('backOfficeHeader', 'Administration panel header', NULL , '0'), ('backOfficeTop', 'Administration panel top hover the tabs', NULL , '1'), ('backOfficeFooter', 'Administration panel footer', NULL , '1')

(1062) Duplicate entry 'createAccountTop' for key 2
INSERT INTO `ps_carrier_group` (id_carrier, id_group) (SELECT id_carrier, id_group FROM ps_carrier c, ps_group g WHERE c.active = 1) 

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