error after upgrade

[volcompresta]

this was what poped up after i upgraded, and clicked the link to finish the upgrade

 

This XML file does not appear to have any style information associated with it. The document tree is shown below.

<action result="fail" error="34"><request result="ok" sqlfile="1.5.4.0"><sqlQuery>SET NAMES 'utf8'</sqlQuery></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>/* PHP:update_customer_default_group(); */</sqlQuery></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>UPDATE `ps_meta` SET `page` = 'supplier' WHERE `page` = 'supply'</sqlQuery></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>ALTER TABLE `ps_image_type` CHANGE `name` `name` VARCHAR( 64 ) NOT NULL</sqlQuery></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>ALTER TABLE `ps_customer` ADD `id_lang` INT UNSIGNED NULL AFTER `id_default_group`</sqlQuery></request><request result="fail" sqlfile="1.5.4.0"><sqlQuery>UPDATE `ps_customer` SET id_lang = (SELECT `value` FROM `ps_configuration` WHERE name = 'PS_LANG_DEFAULT' LIMIT 1)</sqlQuery><sqlMsgError>Table 'estradad_pres954.ps_configuration' doesn't exist</sqlMsgError><sqlNumberError>1146</sqlNumberError></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>UPDATE `ps_customer` c, `ps_orders` o SET c.id_lang = o.id_lang WHERE c.id_customer = o.id_customer</sqlQuery></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>UPDATE `ps_quick_access` SET `link` = 'index.php?controller=AdminCartRules&addcart_rule' WHERE `link` = 'index.php?tab=AdminDiscounts&adddiscount'</sqlQuery></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>ALTER TABLE `ps_order_cart_rule` ADD `free_shipping` tinyint(1) NOT NULL DEFAULT 0 AFTER `value_tax_excl`</sqlQuery></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>UPDATE `ps_order_cart_rule` ocr, `ps_cart_rule` cr SET ocr.free_shipping = 1 WHERE ocr.id_cart_rule = cr.id_cart_rule AND cr.free_shipping = 1</sqlQuery></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>UPDATE `ps_orders` o, `ps_order_cart_rule` ocr SET

o.`total_discounts` = o.total_discounts + o.`total_shipping_tax_incl`,

o.`total_discounts_tax_incl` = o.`total_discounts_tax_incl` + o.`total_shipping_tax_incl`,

o.`total_discounts_tax_excl` = o.`total_discounts_tax_excl` + o.`total_shipping_tax_excl`

WHERE o.id_order = ocr.id_order AND ocr.free_shipping = 1</sqlQuery></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>CREATE TABLE `ps_tab_module_preference` (

`id_tab_module_preference` int(11) NOT NULL auto_increment,

`id_employee` int(11) NOT NULL,

`id_tab` int(11) NOT NULL,

`module` varchar(255) NOT NULL,

PRIMARY KEY (`id_tab_module_preference`),

UNIQUE KEY `employee_module` (`id_employee`, `id_tab`, `module`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>/* PHP:add_new_tab(AdminMarketing, es:Marketing|it:Marketing|en:Marketing|de:Marketing|fr:Marketing, 1); */</sqlQuery></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>/* PHP:p1540_add_missing_columns(); */</sqlQuery></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>ALTER TABLE `ps_stock_available` ADD UNIQUE `product_sqlstock` (`id_product`, `id_product_attribute`, `id_shop`, `id_shop_group`)</sqlQuery></request><request result="fail" sqlfile="1.5.4.0"><sqlQuery>UPDATE ps_configuration SET `value` = '8388608' WHERE `name` = 'PS_PRODUCT_PICTURE_MAX_SIZE' AND `value` <= '524288'</sqlQuery><sqlMsgError>Table 'estradad_pres954.ps_configuration' doesn't exist</sqlMsgError><sqlNumberError>1146</sqlNumberError></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>ALTER TABLE `ps_guest` ADD `mobile_theme` tinyint(1) NOT NULL DEFAULT 0</sqlQuery></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>ALTER TABLE `ps_orders` ADD `mobile_theme` tinyint(1) NOT NULL DEFAULT 0 AFTER `gift_message`</sqlQuery></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>ALTER TABLE `ps_cart` ADD `mobile_theme` tinyint(1) NOT NULL DEFAULT 0 AFTER `gift_message`</sqlQuery></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>ALTER TABLE `ps_address` CHANGE `phone` `phone` varchar(32) default NULL</sqlQuery></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>ALTER TABLE `ps_address` CHANGE `phone_mobile` `phone_mobile` varchar(32) default NULL</sqlQuery></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>/* PHP:update_genders_images(); */</sqlQuery></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>UPDATE `ps_customer` SET `id_gender` = 1 WHERE `email` LIKE '[email protected]' AND `id_customer` = 1 AND `id_gender` = 4</sqlQuery></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>UPDATE `ps_cart_rule_carrier` crc INNER JOIN `ps_carrier` c ON crc.`id_carrier` = c.`id_carrier` SET crc.`id_carrier` = c.`id_reference`</sqlQuery></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>UPDATE `ps_order_payment` SET `order_reference` = LPAD(order_reference, 9 , '0')</sqlQuery></request><request result="ok" sqlfile="1.5.4.0"><sqlQuery>/* PHP:p1540_add_missing_columns(); */</sqlQuery></request><request result="ok" sqlfile="1.5.4.1"><sqlQuery>SET NAMES 'utf8'</sqlQuery></request><request result="ok" sqlfile="1.5.4.1"><sqlQuery>ALTER TABLE `ps_carrier` CHANGE `max_weight` `max_weight` DECIMAL( 20, 6 ) NULL DEFAULT '0'</sqlQuery></request><request result="ok" sqlfile="1.5.4.1"><sqlQuery>DELETE ms.*, hm.* FROM `ps_module_shop` ms INNER JOIN `ps_hook_module` hm USING (`id_module`) INNER JOIN `ps_module` m USING (`id_module`) WHERE m.`name` LIKE 'backwardcompatibility'</sqlQuery></request><request result="ok" sqlfile="1.5.4.1"><sqlQuery>UPDATE `ps_module` SET `active` = 0 WHERE `name` LIKE 'backwardcompatibility'</sqlQuery></request><request result="ok" sqlfile="1.5.4.1"><sqlQuery>ALTER TABLE `ps_orders` CHANGE `reference` `reference` VARCHAR( 10 ) NULL DEFAULT NULL</sqlQuery></request><request result="ok" sqlfile="1.5.4.1"><sqlQuery>ALTER TABLE `ps_order_payment` CHANGE `order_reference` `order_reference` VARCHAR( 10 ) NULL DEFAULT NULL</sqlQuery></request></action>

 

 

any help ? what went wrong

[ubergirl]

I have the same problem. Did you find a solution?

[virtulian]

any solution ?