all price reset to zero - upgrading from 1.4.11 to 1.5.6

[phil044]

Hello all prestashoper

 

 

i try to update with the module auto-upgrade from 1.4.11 to 1.5.6.

 

after the update, all the price was reset to zero and i get this warning message from the module

 

 

[ERROR] SQL 1.5.0.0 1054 in UPDATE ps_stock_mvt sm SET sm.id_stock = IFNULL(( SELECT IFNULL(s.id_stock, 0) FROM ps_stock s WHERE s.id_product = sm.id_product AND s.id_product_attribute = sm.id_product_attribute ORDER BY s.id_shop ), 0): Unknown column 'sm.id_product' in 'where clause'

[ERROR] SQL 1.5.0.1 1146 in INSERT INTO `ps_tax_rule` (`id_tax_rules_group`, `id_country`, `id_state`, `id_tax`, `behavior`, `zipcode_from`, `zipcode_to`, `id_county`, `description`, `state_behavior`, `county_behavior`) SELECT r.`id_tax_rules_group`, r.`id_country`, r.`id_state`, r.`id_tax`, 0, z.`from_zip_code`, z.`to_zip_code`, r.`id_county`, r.`description`, r.`state_behavior`, r.county_behavior FROM `ps_tax_rule` r INNER JOIN `ps_county_zip_code` z ON (z.`id_county` = r.`id_county`): Table 'altishoppresta.ps_county_zip_code' doesn't exist

[ERROR] SQL 1.5.0.1 1054 in UPDATE `ps_tax_rule` SET `behavior` = GREATEST(`state_behavior`, `county_behavior`): Unknown column 'state_behavior' in 'field list'

[ERROR] SQL 1.5.0.1 1054 in DELETE FROM `ps_tax_rule` WHERE `id_county` != 0 AND `zipcode_from` = 0: Unknown column 'id_county' in 'where clause'

[ERROR] SQL 1.5.0.1 1051 in DROP TABLE `ps_county_zip_code`: Unknown table 'ps_county_zip_code'

[ERROR] SQL 1.5.0.1 1051 in DROP TABLE `ps_county`: Unknown table 'ps_county'

[ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `ps_product_download` CHANGE `date_deposit` `date_add` DATETIME NOT NULL: Unknown column 'date_deposit' in 'ps_product_download'

[ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `ps_product_download` CHANGE `physically_filename` `filename` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL: Unknown column 'physically_filename' in 'ps_product_download'

[ERROR] SQL 1.5.0.1 1146 in ALTER TABLE `ps_payment_cc` CHANGE `id_payment_cc` `id_order_payment` INT NOT NULL auto_increment: Table 'altishoppresta.ps_payment_cc' doesn't exist

[ERROR] SQL 1.5.0.1 1146 in ALTER TABLE `ps_payment_cc` ADD `id_order_invoice` varchar(255) NOT NULL AFTER `id_order_payment`: Table 'altishoppresta.ps_payment_cc' doesn't exist

[ERROR] SQL 1.5.0.1 1146 in ALTER TABLE `ps_payment_cc` ADD `payment_method` varchar(255) NOT NULL AFTER `amount`: Table 'altishoppresta.ps_payment_cc' doesn't exist

[ERROR] SQL 1.5.0.1 1146 in ALTER TABLE `ps_payment_cc` ADD `conversion_rate` decimal(13,6) NOT NULL DEFAULT 1 AFTER `payment_method`: Table 'altishoppresta.ps_payment_cc' doesn't exist

[ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `ps_cart_rule_lang` CHANGE `id_discount` `id_cart_rule` int(10) unsigned NOT NULL: Unknown column 'id_discount' in 'ps_cart_rule_lang'

[ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `ps_cart_rule_lang` CHANGE `description` `name` varchar(254) NOT NULL: Unknown column 'description' in 'ps_cart_rule_lang'

[ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `ps_cart_rule_product_rule_value` CHANGE `id_category` `id_item` int(10) unsigned NOT NULL: Unknown column 'id_category' in 'ps_cart_rule_product_rule_value'

[ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `ps_cart_rule_product_rule_value` CHANGE `id_discount` `id_product_rule` int(10) unsigned NOT NULL: Unknown column 'id_discount' in 'ps_cart_rule_product_rule_value'

[ERROR] SQL 1.5.0.1 1054 in INSERT INTO `ps_cart_rule_product_rule` (`id_product_rule`, `id_cart_rule`, `quantity`, `type`) ( SELECT DISTINCT `id_product_rule`, `id_product_rule`, 1, 'categories' FROM `ps_cart_rule_product_rule_value` ): Unknown column 'id_cart_rule' in 'field list'

[ERROR] SQL 1.5.0.1 1146 in ALTER TABLE `ps_cart_discount` CHANGE `id_discount` `id_cart_rule` int(10) unsigned NOT NULL: Table 'altishoppresta.ps_cart_discount' doesn't exist

[ERROR] SQL 1.5.0.1 1146 in ALTER TABLE `ps_order_discount` CHANGE `id_discount` `id_cart_rule` int(10) unsigned NOT NULL: Table 'altishoppresta.ps_order_discount' doesn't exist

[ERROR] SQL 1.5.0.1 1146 in ALTER TABLE `ps_order_discount` CHANGE `id_order_discount` `id_order_cart_rule` int(10) unsigned NOT NULL AUTO_INCREMENT: Table 'altishoppresta.ps_order_discount' doesn't exist

[ERROR] PHP 1.5.0.2 /* Update records before alter tables */ /* PHP:set_stock_available(); */ 1054 - (products)Unknown column 'id_group_shop' in 'field list'

[ERROR] SQL 1.5.0.2 1242 in UPDATE `ps_order_detail` od SET od.`id_order_invoice` = IFNULL(( SELECT oi.`id_order_invoice` FROM `ps_order_invoice` oi WHERE oi.`id_order` = od.`id_order` ), 0): Subquery returns more than 1 row

[ERROR] SQL 1.5.0.2 1242 in INSERT INTO `ps_order_carrier` (`id_order`, `id_carrier`, `id_order_invoice`, `weight`, `shipping_cost_tax_excl`, `shipping_cost_tax_incl`, `tracking_number`, `date_add`) ( SELECT `id_order`, `id_carrier`, ( SELECT oi.`id_order_invoice` FROM `ps_order_invoice` oi WHERE oi.`id_order` = o.`id_order` ), ( SELECT SUM(`product_weight`) FROM `ps_order_detail` od WHERE od.`id_order` = o.`id_order` ), `total_shipping_tax_excl`, `total_shipping_tax_incl`, `shipping_number`, `date_add` FROM `ps_orders` o ): Subquery returns more than 1 row

[ERROR] SQL 1.5.0.4 1054 in INSERT INTO `ps_cart_rule_product_rule_group` (`id_product_rule_group`, `id_cart_rule`, `quantity`) ( SELECT `id_cart_rule`, `id_cart_rule`, `quantity` FROM `ps_cart_rule_product_rule` ): Unknown column 'id_cart_rule' in 'field list'

[ERROR] SQL 1.5.0.4 1054 in ALTER TABLE `ps_cart_rule_product_rule` CHANGE `id_cart_rule` `id_product_rule_group` int(10) unsigned NOT NULL: Unknown column 'id_cart_rule' in 'ps_cart_rule_product_rule'

[ERROR] SQL 1.5.0.5 1054 in INSERT INTO `ps_configuration`(`id_group_shop`, `id_shop`, `name`, `value`, `date_add`, `date_upd`) VALUES (NULL, NULL, 'PS_LOGO', 'logo.jpg', NOw(), NOW()), (NULL, NULL, 'PS_LOGO_MAIL', 'logo_mail.jpg', NOw(), NOW()), (NULL, NULL, 'PS_LOGO_INVOICE', 'logo_invoice.jpg', NOW(), NOW()), (NULL, NULL, 'PS_FAVICON', 'favicon.jpg', NOW(), NOW()), (NULL, NULL, 'PS_STORES_ICON', 'logo_stores.gif', NOW(), NOW()): Unknown column 'id_group_shop' in 'field list'

[ERROR] SQL 1.5.0.9 1051 in DROP TABLE `ps_subdomain`: Unknown table 'ps_subdomain'

[ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `ps_shop_group` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT: Unknown column 'id_group_shop' in 'ps_shop_group'

[ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `ps_shop` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL: Unknown column 'id_group_shop' in 'ps_shop'

[ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `ps_stock_available` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL: Unknown column 'id_group_shop' in 'ps_stock_available'

[ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `ps_cart` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL: Unknown column 'id_group_shop' in 'ps_cart'

[ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `ps_configuration` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NULL: Unknown column 'id_group_shop' in 'ps_configuration'

[ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `ps_connections` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL: Unknown column 'id_group_shop' in 'ps_connections'

[ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `ps_customer` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL: Unknown column 'id_group_shop' in 'ps_customer'

[ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `ps_delivery` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NULL: Unknown column 'id_group_shop' in 'ps_delivery'

[ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `ps_orders` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL: Unknown column 'id_group_shop' in 'ps_orders'

[ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `ps_page_viewed` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL: Unknown column 'id_group_shop' in 'ps_page_viewed'

[ERROR] SQL 1.5.0.10 1242 in INSERT INTO `ps_product_attribute_shop` (`id_product_attribute`, `id_shop`, `wholesale_price`, `price`, `ecotax`, `weight`, `unit_price_impact`, `default_on`, `minimal_quantity`, `available_date`) (SELECT `id_product_attribute`, (SELECT `value` FROM `ps_configuration` WHERE `name` = 'PS_SHOP_DEFAULT'), `wholesale_price`, `price`, `ecotax`, `weight`, `unit_price_impact`, `default_on`, `minimal_quantity`, `available_date` FROM `ps_product_attribute`): Subquery returns more than 1 row

[ERROR] SQL 1.5.0.10 1054 in INSERT INTO `ps_attribute_shop` (`id_attribute`, `id_shop`) (SELECT a.id_attribute, c.id_shop FROM ps_attribute_group_shop a LEFT JOIN ps_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN ps_shop c ON b.id_shop_group = c.id_shop_group): Unknown column 'a.id_attribute' in 'field list'

[ERROR] SQL 1.5.0.10 1146 in INSERT INTO `ps_feature_shop` (`id_feature`, `id_shop`) (SELECT a.id_feature, c.id_shop FROM ps_feature_group_shop a LEFT JOIN ps_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN ps_shop c ON b.id_shop_group = c.id_shop_group): Table 'altishoppresta.ps_feature_group_shop' doesn't exist

[ERROR] SQL 1.5.0.10 1051 in DROP TABLE `ps_feature_group_shop`: Unknown table 'ps_feature_group_shop'

[ERROR] SQL 1.5.0.10 1146 in INSERT INTO `ps_group_shop` (`id_group`, `id_shop`) (SELECT a.id_group, c.id_shop FROM ps_group_group_shop a LEFT JOIN ps_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN ps_shop c ON b.id_shop_group = c.id_shop_group): Table 'altishoppresta.ps_group_group_shop' doesn't exist

[ERROR] SQL 1.5.0.10 1051 in DROP TABLE `ps_group_group_shop`: Unknown table 'ps_group_group_shop'

[ERROR] SQL 1.5.0.10 1146 in INSERT INTO `ps_attribute_group_shop` (`id_attribute_group`, `id_shop`) (SELECT a.id_attribute_group, c.id_shop FROM ps_attribute_group_group_shop a LEFT JOIN ps_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN ps_shop c ON b.id_shop_group = c.id_shop_group): Table 'altishoppresta.ps_attribute_group_group_shop' doesn't exist

[ERROR] SQL 1.5.0.10 1051 in DROP TABLE `ps_attribute_group_group_shop`: Unknown table 'ps_attribute_group_group_shop'

[ERROR] SQL 1.5.0.10 1146 in INSERT INTO `ps_tax_rules_group_shop` (`id_tax_rules_group`, `id_shop`) (SELECT a.id_tax_rules_group, c.id_shop FROM ps_tax_rules_group_group_shop a LEFT JOIN ps_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN ps_shop c ON b.id_shop_group = c.id_shop_group): Table 'altishoppresta.ps_tax_rules_group_group_shop' doesn't exist

[ERROR] SQL 1.5.0.10 1051 in DROP TABLE `ps_tax_rules_group_group_shop`: Unknown table 'ps_tax_rules_group_group_shop'

[ERROR] SQL 1.5.0.10 1146 in INSERT INTO `ps_zone_shop` (`id_zone`, `id_shop`) (SELECT a.id_zone, c.id_shop FROM ps_zone_group_shop a LEFT JOIN ps_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN ps_shop c ON b.id_shop_group = c.id_shop_group): Table 'altishoppresta.ps_zone_group_shop' doesn't exist

[ERROR] SQL 1.5.0.10 1051 in DROP TABLE `ps_zone_group_shop`: Unknown table 'ps_zone_group_shop'

[ERROR] SQL 1.5.0.10 1146 in INSERT INTO `ps_manufacturer_shop` (`id_manufacturer`, `id_shop`) (SELECT a.id_manufacturer, c.id_shop FROM ps_manufacturer_group_shop a LEFT JOIN ps_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN ps_shop c ON b.id_shop_group = c.id_shop_group): Table 'altishoppresta.ps_manufacturer_group_shop' doesn't exist

[ERROR] SQL 1.5.0.10 1051 in DROP TABLE `ps_manufacturer_group_shop`: Unknown table 'ps_manufacturer_group_shop'

[ERROR] SQL 1.5.0.10 1146 in INSERT INTO `ps_supplier_shop` (`id_supplier`, `id_shop`) (SELECT a.id_supplier, c.id_shop FROM ps_supplier_group_shop a LEFT JOIN ps_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN ps_shop c ON b.id_shop_group = c.id_shop_group): Table 'altishoppresta.ps_supplier_group_shop' doesn't exist

[ERROR] SQL 1.5.0.10 1051 in DROP TABLE `ps_supplier_group_shop`: Unknown table 'ps_supplier_group_shop'

[ERROR] SQL 1.5.0.12 1051 in DROP TABLE `ps_accounting_zone_shop`: Unknown table 'ps_accounting_zone_shop'

[ERROR] SQL 1.5.0.12 1051 in DROP TABLE `ps_accounting_product_zone_shop`: Unknown table 'ps_accounting_product_zone_shop'

[ERROR] PHP 1.5.0.12 /* PHP:p15012_add_missing_columns(); */ 1 - UPDATE `ps_order_payment` SET `id_order_invoice` = 0 WHERE `id_order_invoice` LIKE "" OR `id_order_invoice` IS NULLUnknown column 'id_order_invoice' in 'where clause'

[ERROR] SQL 1.5.0.13 1054 in INSERT INTO `ps_order_invoice_payment` (SELECT id_order_invoice, id_order_payment, id_order FROM `ps_order_payment` WHERE id_order_invoice > 0): Unknown column 'id_order_invoice' in 'field list'

[ERROR] SQL 1.5.0.13 1054 in -- Step 2: Add the collumn id_order_reference ALTER TABLE `ps_order_payment` ADD COLUMN `order_reference` VARCHAR(10) AFTER `id_order`, ADD INDEX `order_reference`(`order_reference`): Unknown column 'id_order' in 'ps_order_payment'

[ERROR] PHP 1.5.0.14 /* PHP:p15014_add_missing_columns(); */ 1 - Duplicate column name 'id_shop_group'

[ERROR] PHP 1.5.4.0 /* PHP:p1540_add_missing_columns(); */ 1 - Can't DROP 'product_sqlstock'; check that column/key exists

Erreur(s) détectée(s) pendant la mise à jour.

 

i revert to the previous version(1.4.11) and all the price come back

 

I think this a sql problem

Would appreciate it if anyone has any suggestion.

 

Thanks

PHIL

Edited January 8, 2014 by phil044 (see edit history)

[muktadir]

hi,

 

This needs manual upgrade process. If you need that, please send me a private message.

 

Thanks,

Muktadir

[wiros]

I got simular error during Manual upgrade:

 

<request result="fail" sqlfile="1.5.0.0">

<sqlQuery>

<![CDATA[

UPDATE ps_stock_mvt sm SET sm.id_stock = IFNULL(( SELECT IFNULL(s.id_stock, 0) FROM ps_stock s WHERE s.id_product = sm.id_product AND s.id_product_attribute = sm.id_product_attribute ORDER BY s.id_shop ), 0)

]]>

</sqlQuery>

<sqlMsgError>

 

Can someone advise how to solve this?