More red errors on upgrade, help please

[gdb7973]

Hi all, further to my previous error, well yes I managed to correct that, but wow the following errors came up, they are in the attacthchment too.............Any assistance appreciated.

 

Cheers

 

 

[ERROR] SQL 1.4.5.0 1060 in ALTER TABLE `ps_discount` ADD `include_tax` TINYINT(1) NOT NULL DEFAULT '0': Duplicate column name 'include_tax'

 

[OK] SQL 1.4.5.0 UPDATE `ps_order_detail` SET `product_price` = `product_price` /( 1-(`group_reduction`/100))

[OK] SQL 1.4.5.0 DELETE FROM `ps_configuration` WHERE name IN ('PS_LAYERED_BITLY_USERNAME', 'PS_LAYERED_BITLY_API_KEY', 'PS_LAYERED_SHARE') LIMIT 3

[OK] SQL 1.4.5.0 ALTER TABLE `ps_delivery` CHANGE `price` `price` DECIMAL(20, 6) NOT NULL

[OK] SQL 1.4.5.0 ALTER TABLE `ps_store` CHANGE `latitude` `latitude` DECIMAL(10, 8) NULL DEFAULT NULL

[OK] SQL 1.4.5.0 ALTER TABLE `ps_store` CHANGE `longitude` `longitude` DECIMAL(10, 8) NULL DEFAULT NULL

 

[ERROR] SQL 1.4.5.0 1062 in INSERT INTO `ps_hook` (`name`, `title`, `description`, `position`, `live_edit`) VALUES ('attributeGroupForm', 'Add fields to the form "attribute group"', 'Add fields to the form "attribute group"', 0, 0), ('afterSaveAttributeGroup', 'On saving attribute group', 'On saving attribute group', 0, 0), ('afterDeleteAttributeGroup', 'On deleting attribute group', 'On deleting "attribute group', 0, 0), ('featureForm', 'Add fields to the form "feature"', 'Add fields to the form "feature"', 0, 0), ('afterSaveFeature', 'On saving attribute feature', 'On saving attribute feature', 0, 0), ('afterDeleteFeature', 'On deleting attribute feature', 'On deleting attribute feature', 0, 0), ('afterSaveProduct', 'On saving products', 'On saving products', 0, 0), ('productListAssign', 'Assign product list to a category', 'Assign product list to a category', 0, 0), ('postProcessAttributeGroup', 'On post-process in admin attribute group', 'On post-process in admin attribute group', 0, 0), ('postProcessFeature', 'On post-process in admin feature', 'On post-process in admin feature', 0, 0), ('featureValueForm', 'Add fields to the form "feature value"', 'Add fields to the form "feature value"', 0, 0), ('postProcessFeatureValue', 'On post-process in admin feature value', 'On post-process in admin feature value', 0, 0), ('afterDeleteFeatureValue', 'On deleting attribute feature value', 'On deleting attribute feature value', 0, 0), ('afterSaveFeatureValue', 'On saving attribute feature value', 'On saving attribute feature value', 0, 0), ('attributeForm', 'Add fields to the form "feature value"', 'Add fields to the form "feature value"', 0, 0), ('postProcessAttribute', 'On post-process in admin feature value', 'On post-process in admin feature value', 0, 0), ('afterDeleteAttribute', 'On deleting attribute feature value', 'On deleting attribute feature value', 0, 0), ('afterSaveAttribute', 'On saving attribute feature value', 'On saving attribute feature value', 0, 0): Duplicate entry 'attributeGroupForm' for key 2

 

[ERROR] SQL 1.4.5.0 1060 in ALTER TABLE `ps_employee` ADD `bo_show_screencast` TINYINT(1) NOT NULL DEFAULT '1' AFTER `bo_uimode`: Duplicate column name 'bo_show_screencast'

 

[OK] SQL 1.4.5.0 UPDATE `ps_country` SET id_zone = (SELECT id_zone FROM `ps_zone` WHERE name = 'Oceania' LIMIT 1) WHERE iso_code = 'KI' LIMIT 1

 

[ERROR] SQL 1.4.5.0 1060 in ALTER TABLE `ps_lang` ADD `date_format_lite` char(32) NOT NULL DEFAULT 'Y-m-d' AFTER language_code: Duplicate column name 'date_format_lite'

 

[ERROR] SQL 1.4.5.0 1060 in ALTER TABLE `ps_lang` ADD `date_format_full` char(32) NOT NULL DEFAULT 'Y-m-d H:i:s' AFTER date_format_lite: Duplicate column name 'date_format_full'

 

[OK] SQL 1.4.5.0 UPDATE `ps_lang` SET `date_format_lite` = 'd/m/Y' WHERE `iso_code` IN ('fr', 'es', 'it')

[OK] SQL 1.4.5.0 UPDATE `ps_lang` SET `date_format_full` = 'd/m/Y H:i:s' WHERE `iso_code` IN ('fr', 'es', 'it')

[OK] SQL 1.4.5.0 UPDATE `ps_lang` SET `date_format_lite` = 'd.m.Y' WHERE `iso_code` = 'de'

[OK] SQL 1.4.5.0 UPDATE `ps_lang` SET `date_format_full` = 'd.m.Y H:i:s' WHERE `iso_code` = 'de'

[OK] SQL 1.4.5.0 UPDATE `ps_lang` SET `date_format_lite` = 'm/d/Y' WHERE `iso_code` = 'en'

[OK] SQL 1.4.5.0 UPDATE `ps_lang` SET `date_format_full` = 'm/d/Y H:i:s' WHERE `iso_code` = 'en'

[OK] SQL 1.4.5.0 ALTER IGNORE TABLE `ps_specific_price_priority` ADD UNIQUE ( `id_product` )

[OK] SQL 1.4.5.1 SET NAMES 'utf8'

[OK] SQL 1.4.6.0 SET NAMES 'utf8'

[OK] PHP1.4.6.0 /* PHP:update_order_canada(); */

[OK] SQL 1.4.6.0 CREATE TABLE IF NOT EXISTS `ps_compare` ( `id_compare` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_customer` int(10) unsigned NOT NULL, PRIMARY KEY (`id_compare`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8

 

[ERROR] SQL 1.4.6.0 1091 in ALTER TABLE `ps_compare_product` DROP `id_compare_product` , DROP `id_guest` , DROP `id_customer`: Can't DROP 'id_compare_product'; check that column/key exists

 

[ERROR] SQL 1.4.6.0 1060 in ALTER TABLE `ps_compare_product` ADD `id_compare` int(10) unsigned NOT NULL, ADD PRIMARY KEY( `id_compare`, `id_product`): Duplicate column name 'id_compare'

 

[OK] SQL 1.4.6.0 ALTER TABLE `ps_store` CHANGE `latitude` `latitude` DECIMAL(11, 8) NULL DEFAULT NULL

[OK] SQL 1.4.6.0 ALTER TABLE `ps_store` CHANGE `longitude` `longitude` DECIMAL(11, 8) NULL DEFAULT NULL

 

[ERROR] SQL 1.4.6.0 1068 in ALTER TABLE `ps_address_format` ADD PRIMARY KEY (`id_country`): Multiple primary key defined

 

[ERROR] SQL 1.4.6.0 1091 in ALTER TABLE `ps_address_format` DROP INDEX `country`: Can't DROP 'country'; check that column/key exists

 

[OK] PHP1.4.6.0 /* PHP:hook_blocksearch_on_header(); */

[OK] SQL 1.4.6.1 SET NAMES 'utf8'

[OK] PHP1.4.6.1 /* PHP:add_module_to_hook(authorizeaim, header); */

[OK] SQL 1.4.6.2 SET NAMES 'utf8'

[OK] SQL 1.4.6.2 INSERT IGNORE INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_LIMIT_UPLOAD_IMAGE_VALUE', '2', NOW(), NOW()), ('PS_LIMIT_UPLOAD_FILE_VALUE', '2', NOW(), NOW())

[OK] SQL 1.4.7.0 SET NAMES 'utf8'

[OK] PHP1.4.7.0 /* PHP:category_product_index_unique(); */

[OK] SQL 1.4.7.0 CREATE TABLE IF NOT EXISTS `ps_order_tax` ( `id_order` int(11) NOT NULL, `tax_name` varchar(40) NOT NULL, `tax_rate` decimal(6,3) NOT NULL, `amount` decimal(20,6) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8

 

[ERROR] SQL 1.4.7.0 1062 in INSERT INTO `ps_hook` (`name`, `title`, `description`, `position`, `live_edit`) VALUES ('frontCanonicalRedirect', 'Front Canonical Redirect', 'Check for 404 errors before canonical redirects', 0, 0): Duplicate entry 'frontCanonicalRedirect' for key 2

 

[OK] PHP1.4.7.0 /* PHP:update_module_pagesnotfound(); */

 

[ERROR] SQL 1.4.7.0 1060 in ALTER TABLE `ps_order_state` ADD COLUMN `deleted` tinyint(1) UNSIGNED NOT NULL default '0' AFTER `delivery`: Duplicate column name 'deleted'

 

[OK] SQL 1.4.7.1 SET NAMES 'utf8'

[OK] SQL 1.4.7.2 SET NAMES 'utf8'

[OK] SQL 1.4.7.3 SET NAMES 'utf8'

[OK] SQL 1.4.8.0 SET NAMES 'utf8'

[OK] SQL 1.4.8.0 ALTER TABLE `ps_feature_product` ADD INDEX `id_product`(`id_product`)

[OK] SQL 1.4.8.1 SET NAMES 'utf8'

[OK] SQL 1.4.8.2 SET NAMES 'utf8'

End of process

new errors.pdf

[gdb7973]

I thought it may be to difficult for anyone to assist.