Jump to content
Sign in to follow this  
Lustfull

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

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

Share this post


Link to post
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'

Share this post


Link to post
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
Sign in to follow this  

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More