Error en actualización en la bd

[netsia]

Buenos días

 

Después de unas decenas de intentos, o pido ayuda.

 

Estoy intentando actualizar desde la versión 1.4.2.5 , he intentado hacia la 1.4.9 y la 1.4.1.0 , pero en ambas y en numerosas ocasiones después de haber seguido fielmente los pasos de la guía http://doc.prestashop.com/pages/viewpage.action?pageId=3506389 me da error a la hora de actulizar mensaje ( Desgraciadamente, 90 Han aparecido errores de SQL)

 

TEngo descargado el listado de errores que da, ¿algo se me escapa relacionado con la base de datos? , solo tiene un usuario la BD , no creo que sea tema de persmisos, ¿Algún consejo?

 

Gracias.

[scorsese]

Buenos dias.

 

Puedes indicar que errores te dan.

[netsia]

Buenos dias.

 

Puedes indicar que errores te dan.

 

 

SET NAMES 'utf8'

()

 

UPDATE `ps_address_format` SET `format`='firstname lastname company address1 address2 city State:name postcode Country:name' WHERE `id_country` = (SELECT `id_country` FROM `ps_country` WHERE `iso_code`='GB')

()

 

UPDATE `ps_country` SET `contains_states` = 1 WHERE `id_country` = 145

()

 

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_LEGACY_IMAGES', '1', NOW(), NOW())

()

 

SET NAMES 'utf8'

()

 

ALTER TABLE `ps_image` MODIFY COLUMN `position` SMALLINT(2) UNSIGNED NOT NULL DEFAULT 0

()

 

INSERT IGNORE INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_OS_CHEQUE', '1', NOW(), NOW()), ('PS_OS_PAYMENT', '2', NOW(), NOW()), ('PS_OS_PREPARATION', '3', NOW(), NOW()), ('PS_OS_SHIPPING', '4', NOW(), NOW()), ('PS_OS_DELIVERED', '5', NOW(), NOW()), ('PS_OS_CANCELED', '6', NOW(), NOW()), ('PS_OS_REFUND', '7', NOW(), NOW()), ('PS_OS_ERROR', '8', NOW(), NOW()), ('PS_OS_OUTOFSTOCK', '9', NOW(), NOW()), ('PS_OS_BANKWIRE', '10', NOW(), NOW()), ('PS_OS_PAYPAL', '11', NOW(), NOW()), ('PS_OS_WS_PAYMENT', '12', NOW(), NOW()), ('PS_IMAGE_QUALITY', 'jpg', NOW(), NOW()), ('PS_PNG_QUALITY', '7', NOW(), NOW()), ('PS_JPEG_QUALITY', '90', NOW(), NOW()), ('PS_COOKIE_LIFETIME_FO', '480', NOW(), NOW()), ('PS_COOKIE_LIFETIME_BO', '480', NOW(), NOW())

()

 

ALTER TABLE `ps_lang` ADD `is_rtl` TINYINT(1) NOT NULL DEFAULT '0'

()

 

UPDATE `ps_country_lang` SET `name` = 'United States' WHERE `name` = 'USA' AND `id_lang` = ( SELECT `id_lang` FROM `ps_lang` WHERE `iso_code` = 'en' LIMIT 1 )

()

 

UPDATE `ps_hook` SET `live_edit` = 1 WHERE `name` = 'leftColumn' OR `name` = 'home' OR `name` = 'rightColumn' OR `name` = 'productfooter' OR `name` = 'payment'

()

 

ALTER TABLE `ps_stock_mvt_reason` MODIFY `sign` TINYINT(1) NOT NULL DEFAULT '1' AFTER `id_stock_mvt_reason`

()

 

UPDATE `ps_tab_lang` SET `name` = 'Geolocation' WHERE `name` = 'Geolocalization'

()

 

UPDATE `ps_tab_lang` SET `name` = 'Counties' WHERE `name` = 'County'

()

 

ALTER TABLE `ps_tax_rule` MODIFY `id_county` INT NOT NULL AFTER `id_country`

()

 

UPDATE `ps_address_format` set `format`='firstname lastname company address1 address2 city, State:name postcode Country:name phone' WHERE `id_country` = (SELECT `id_country` FROM `ps_country` WHERE `iso_code`='US')

()

 

ALTER TABLE `ps_attachment` CHANGE `mime` `mime` VARCHAR(128) NOT NULL

()

 

CREATE TABLE IF NOT EXISTS `ps_compare_product` ( `id_compare_product` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_product` int(10) unsigned NOT NULL, `id_guest` int(10) unsigned NOT NULL, `id_customer` int(10) unsigned NOT NULL, `date_add` datetime NOT NULL, `date_upd` datetime NOT NULL, PRIMARY KEY (`id_compare_product`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8

()

 

DELETE FROM `ps_configuration` WHERE name = 'PS_LAYERED_NAVIGATION_CHECKBOXES' LIMIT 1

()

 

/* PHP:alter_productcomments_guest_index(); */

 

SET NAMES 'utf8'

()

 

SET NAMES 'utf8'

()

 

INSERT IGNORE INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_RESTRICT_DELIVERED_COUNTRIES', '0', NOW(), NOW())

()

 

UPDATE `ps_country_lang` SET `name` = 'United States' WHERE `name` = 'United State'

()

 

ALTER TABLE `ps_discount` ADD `include_tax` TINYINT(1) NOT NULL DEFAULT '0'

()

 

UPDATE `ps_order_detail` SET `product_price` = `product_price` /( 1-(`group_reduction`/100))

()

 

DELETE FROM `ps_configuration` WHERE name IN ('PS_LAYERED_BITLY_USERNAME', 'PS_LAYERED_BITLY_API_KEY', 'PS_LAYERED_SHARE') LIMIT 3

()

 

ALTER TABLE `ps_delivery` CHANGE `price` `price` DECIMAL(20, 6) NOT NULL

()

 

ALTER TABLE `ps_store` CHANGE `latitude` `latitude` DECIMAL(10, 8) NULL DEFAULT NULL

()

 

ALTER TABLE `ps_store` CHANGE `longitude` `longitude` DECIMAL(10, 8) NULL DEFAULT NULL

()

 

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)

()

 

ALTER TABLE `ps_employee` ADD `bo_show_screencast` TINYINT(1) NOT NULL DEFAULT '1' AFTER `bo_uimode`

()

 

UPDATE `ps_country` SET id_zone = (SELECT id_zone FROM `ps_zone` WHERE name = 'Oceania' LIMIT 1) WHERE iso_code = 'KI' LIMIT 1

()

 

ALTER TABLE `ps_lang` ADD `date_format_lite` char(32) NOT NULL DEFAULT 'Y-m-d' AFTER language_code

()

 

ALTER TABLE `ps_lang` ADD `date_format_full` char(32) NOT NULL DEFAULT 'Y-m-d H:i:s' AFTER date_format_lite

()

 

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

()

 

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

()

 

UPDATE `ps_lang` SET `date_format_lite` = 'd.m.Y' WHERE `iso_code` = 'de'

()

 

UPDATE `ps_lang` SET `date_format_full` = 'd.m.Y H:i:s' WHERE `iso_code` = 'de'

()

 

UPDATE `ps_lang` SET `date_format_lite` = 'm/d/Y' WHERE `iso_code` = 'en'

()

 

UPDATE `ps_lang` SET `date_format_full` = 'm/d/Y H:i:s' WHERE `iso_code` = 'en'

()

 

ALTER IGNORE TABLE `ps_specific_price_priority` ADD UNIQUE (`id_product`)

()

 

SET NAMES 'utf8'

()

 

SET NAMES 'utf8'

()

 

/* PHP:update_order_canada(); */

 

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

()

 

ALTER TABLE `ps_compare_product` DROP `id_compare_product` , DROP `id_guest` , DROP `id_customer`

()

 

ALTER TABLE `ps_compare_product` ADD `id_compare` int(10) unsigned NOT NULL, ADD PRIMARY KEY(`id_compare`, `id_product`)

()

 

ALTER TABLE `ps_store` CHANGE `latitude` `latitude` DECIMAL(11, 8) NULL DEFAULT NULL

()

 

ALTER TABLE `ps_store` CHANGE `longitude` `longitude` DECIMAL(11, 8) NULL DEFAULT NULL

()

 

ALTER TABLE `ps_address_format` ADD PRIMARY KEY (`id_country`)

()

 

ALTER TABLE `ps_address_format` DROP INDEX `country`

()

 

/* PHP:hook_blocksearch_on_header(); */

 

SET NAMES 'utf8'

()

 

/* PHP:add_module_to_hook(authorizeaim, header); */

 

SET NAMES 'utf8'

()

 

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())

()

 

SET NAMES 'utf8'

()

 

/* PHP:category_product_index_unique(); */

 

CREATE TABLE IF NOT EXISTS `ps_order_tax` ( `id_order` int(10) 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

()

 

INSERT INTO `ps_hook` (`name`, `title`, `description`, `position`, `live_edit`) VALUES ('frontCanonicalRedirect', 'Front Canonical Redirect', 'Check for 404 errors before canonical redirects', 0, 0)

()

 

/* PHP:update_module_pagesnotfound(); */

 

ALTER TABLE `ps_order_state` ADD COLUMN `deleted` tinyint(1) UNSIGNED NOT NULL default '0' AFTER `delivery`

()

 

SET NAMES 'utf8'

()

 

SET NAMES 'utf8'

()

 

SET NAMES 'utf8'

()

 

SET NAMES 'utf8'

()

 

ALTER TABLE `ps_feature_product` ADD INDEX `id_product`(`id_product`)

()

 

SET NAMES 'utf8'

()

 

SET NAMES 'utf8'

()

 

SET NAMES 'utf8'

()

 

SET NAMES 'utf8'

()

 

ALTER TABLE `ps_image` ADD UNIQUE KEY `idx_product_image` (`id_image` , `id_product` , `cover`)

()

 

/* PHP:clean_category_product(); */