Jump to content

Något för proffsen att bita i!!


Lustfull

Recommended Posts

Jaha då skulle man försöka sig på att uppdatera till v.1.3.5.
Nemas problemas till en bit in i install där får jag upp felmeddelande(måånga fel) se bifogad fil.

Fattar nada så mitt hopp står till proffsen här.
Kan jag korrigera felen eller ska jag lägga ner och köra på den versionen jag har i dag(1.3.1.1 - 1.003s som funkar)??
H
sussi

Link to comment
Share on other sites

Felmeddelandet

Sussi

SET NAMES 'utf8'

SET NAMES 'utf8'

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

(1060) Duplicate column name 'reduction_percent'
ALTER TABLE `pps_order_detail` ADD `reduction_amount` DECIMAL(20, 6) NOT NULL AFTER `reduction_percent`

(1060) Duplicate column name 'reduction_amount'
ALTER TABLE `pps_country` CHANGE `need_identification_number` `need_identification_number` TINYINT(1) NOT NULL DEFAULT '0'

INSERT INTO `pps_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 `pps_search_index` CHANGE `weight` `weight` SMALLINT(4) unsigned NOT NULL DEFAULT '1'

ALTER TABLE `pps_image` DROP INDEX `product_position`, ADD UNIQUE `product_position` (`id_product`, `position`)

ALTER TABLE `pps_zone` DROP `enabled`

(1091) Can't DROP 'enabled'; check that column/key exists
SET @id_hook = (SELECT id_hook FROM pps_hook WHERE name = 'backOfficeHeader')

SET @position = (SELECT IFNULL(MAX(position),0)+1 FROM pps_hook_module WHERE id_hook = @id_hook)

INSERT IGNORE INTO pps_hook_module (id_hook, id_module, position) VALUES (@id_hook, (SELECT id_module FROM pps_module WHERE name = 'statsbestcustomers'), @position)

SET @position = @position + 1

INSERT IGNORE INTO pps_hook_module (id_hook, id_module, position) VALUES (@id_hook, (SELECT id_module FROM pps_module WHERE name = 'statsbestproducts'), @position)

SET @position = @position + 1

INSERT IGNORE INTO pps_hook_module (id_hook, id_module, position) VALUES (@id_hook, (SELECT id_module FROM pps_module WHERE name = 'statsbestvouchers'), @position)

SET @position = @position + 1

INSERT IGNORE INTO pps_hook_module (id_hook, id_module, position) VALUES (@id_hook, (SELECT id_module FROM pps_module WHERE name = 'statsbestcategories'), @position)

SET @position = @position + 1

INSERT IGNORE INTO pps_hook_module (id_hook, id_module, position) VALUES (@id_hook, (SELECT id_module FROM pps_module WHERE name = 'statsbestcarriers'), @position)

SET NAMES 'utf8'

ALTER TABLE `pps_state` CHANGE `iso_code` `iso_code` CHAR(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL

SET NAMES 'utf8'

ALTER TABLE `pps_order_detail` ADD `group_reduction` DECIMAL(10, 2) NOT NULL AFTER `reduction_amount`

(1060) Duplicate column name 'group_reduction'
ALTER TABLE `pps_order_detail` ADD `ecotax_tax_rate` DECIMAL(5, 3) NOT NULL AFTER `ecotax`

(1060) Duplicate column name 'ecotax_tax_rate'
ALTER TABLE `pps_product` CHANGE `ecotax` `ecotax` DECIMAL(21, 6) NOT NULL DEFAULT '0.00'

INSERT INTO `pps_configuration` (`name`, `value`, `date_add`, `date_upd`) SELECT 'PS_LOCALE_LANGUAGE', l.`iso_code`, NOW(), NOW() FROM `pps_configuration` c INNER JOIN `pps_lang` l ON (l.`id_lang` = c.`value`) WHERE c.`name` = 'PS_LANG_DEFAULT'

(1062) Duplicate entry 'PS_LOCALE_LANGUAGE' for key 2
INSERT INTO `pps_configuration` (`name`, `value`, `date_add`, `date_upd`) SELECT 'PS_LOCALE_COUNTRY', co.`iso_code`, NOW(), NOW() FROM `pps_configuration` c INNER JOIN `pps_country` co ON (co.`id_country` = c.`value`) WHERE c.`name` = 'PS_COUNTRY_DEFAULT'

(1062) Duplicate entry 'PS_LOCALE_COUNTRY' for key 2
SET NAMES 'utf8'

SET NAMES 'utf8'

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