silviu_25 Posted October 18, 2013 Share Posted October 18, 2013 Hello, I neeh help ASAP, I try to upgrade from 1.4.11.0 to 1.5.6.0 I updated module "1-Click Upgrade" to last version "v1.2.2-1-Click Upgrade - AutoUpgrade.zip" I followed twice all instructions from here: http://doc.prestashop.com/display/PS15/Automatic+update but I had some errors after upgrade: [ERROR] SQL 1.5.0.0 1054 in INSERT INTO `shop` (`id_shop`, `id_group_shop`, `name`, `id_category`, `id_theme`, `active`, `deleted`) VALUES (1, 1, (SELECT value FROM `configuration` WHERE name = 'PS_SHOP_NAME'), 1, 1, 1, 0): Unknown column 'id_group_shop' in 'field list' [ERROR] SQL 1.5.0.0 1054 in INSERT INTO `stock` (id_product, id_product_attribute, id_shop, quantity) (SELECT id_product, id_product_attribute, 1, quantity FROM product_attribute): Unknown column 'id_shop' in 'field list' [ERROR] SQL 1.5.0.0 1054 in INSERT INTO `stock` (id_product, id_product_attribute, id_shop, quantity) (SELECT id_product, 0, 1, IF( (SELECT COUNT(*) FROM product_attribute pa WHERE p.id_product = pa.id_product) > 0, (SELECT SUM(pa2.quantity) FROM product_attribute pa2 WHERE p.id_product = pa2.id_product), quantity ) FROM product p): Unknown column 'id_shop' in 'field list' [ERROR] SQL 1.5.0.0 1054 in UPDATE stock_mvt sm SET sm.id_stock = IFNULL(( SELECT IFNULL(s.id_stock, 0) FROM 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 's.id_shop' in 'order clause' [ERROR] SQL 1.5.0.0 1054 in INSERT INTO `attribute_group_shop` (id_group_shop, id_attribute) (SELECT 1, id_attribute FROM `attribute`): Unknown column 'id_group_shop' in 'field list' [ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `cart_rule_lang` CHANGE `id_discount` `id_cart_rule` int(10) unsigned NOT NULL: Unknown column 'id_discount' in 'cart_rule_lang' [ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `cart_rule_lang` CHANGE `description` `name` varchar(254) NOT NULL: Unknown column 'description' in 'cart_rule_lang' [ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `cart_rule_product_rule_value` CHANGE `id_category` `id_item` int(10) unsigned NOT NULL: Unknown column 'id_category' in 'cart_rule_product_rule_value' [ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `cart_rule_product_rule_value` CHANGE `id_discount` `id_product_rule` int(10) unsigned NOT NULL: Unknown column 'id_discount' in 'cart_rule_product_rule_value' [ERROR] SQL 1.5.0.1 1054 in INSERT INTO `cart_rule_product_rule` (`id_product_rule`, `id_cart_rule`, `quantity`, `type`) ( SELECT DISTINCT `id_product_rule`, `id_product_rule`, 1, 'categories' FROM `cart_rule_product_rule_value` ): Unknown column 'id_cart_rule' in 'field list' [ERROR] PHP 1.5.0.2 /* Update records before alter tables */ /* PHP:set_stock_available(); */ 1054 - (attributes)Unknown column 'id_group_shop' in 'field list' [ERROR] SQL 1.5.0.2 1054 in INSERT IGNORE INTO `order_payment` (`id_order_invoice`, `id_order`, `id_currency`, `amount`, `payment_method`, `conversion_rate`, `date_add`) ( SELECT ( SELECT oi.`id_order_invoice` FROM `order_invoice` oi WHERE oi.`id_order` = o.`id_order` ), o.`id_order`, o.`id_currency`, o.`total_paid_real`, o.`payment`, o.`conversion_rate`, o.`date_add` FROM `orders` o LEFT JOIN `order_payment` op ON (op.`id_order` = o.`id_order`) WHERE op.`id_order_payment` IS NULL ): Unknown column 'op.id_order' in 'on clause' [ERROR] SQL 1.5.0.4 1054 in INSERT INTO `cart_rule_product_rule_group` (`id_product_rule_group`, `id_cart_rule`, `quantity`) ( SELECT `id_cart_rule`, `id_cart_rule`, `quantity` FROM `cart_rule_product_rule` ): Unknown column 'id_cart_rule' in 'field list' [ERROR] SQL 1.5.0.4 1054 in ALTER TABLE `cart_rule_product_rule` CHANGE `id_cart_rule` `id_product_rule_group` int(10) unsigned NOT NULL: Unknown column 'id_cart_rule' in 'cart_rule_product_rule' [ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `shop` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL: Unknown column 'id_group_shop' in 'shop' [ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `stock_available` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL: Unknown column 'id_group_shop' in 'stock_available' [ERROR] SQL 1.5.0.10 1054 in INSERT INTO `attribute_shop` (`id_attribute`, `id_shop`) (SELECT a.id_attribute, c.id_shop FROM attribute_group_shop a LEFT JOIN shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN shop c ON b.id_shop_group = c.id_shop_group): Unknown column 'a.id_attribute' in 'field list' [ERROR] PHP 1.5.0.12 /* PHP:p15012_add_missing_columns(); */ 1 - UPDATE `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 `order_invoice_payment` (SELECT id_order_invoice, id_order_payment, id_order FROM `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 `order_payment` ADD COLUMN `order_reference` VARCHAR(10) AFTER `id_order`, ADD INDEX `order_reference`(`order_reference`): Unknown column 'id_order' in 'order_payment' Warning detected during upgrade. after "Upgrade complete, but warnings has been found." admin panel is looking good but on front-end "Oops, something went wrong. Try to refresh this page or feel free to contact us if the problem persists." I searched for this problem and I followed this : http://forge.prestashop.com/browse/PSCFV-10526?focusedCommentId=77774&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-77774 " but it does not help me, same issue. please anyone help me. Thank you! Link to comment Share on other sites More sharing options...
NemoPS Posted October 18, 2013 Share Posted October 18, 2013 Can you try turning on errors as described in my signature? it looks like some tables were not created Link to comment Share on other sites More sharing options...
silviu_25 Posted October 18, 2013 Author Share Posted October 18, 2013 (edited) Can you try turning on errors as described in my signature? it looks like some tables were not created Ok, i turned ON, and now? should I try again to update? I forgot to mention that I turn off Backup options because is gave me other errors Here is error log if I use "Backup my files and database" and "Backup my images": Analyzing the situation ...Shop deactivated. Now downloading (this can takes some times )... Download complete. Now extracting Extract complete. removing sample files... All sample files removed. Now backup files. [Ajax / Server Error for action backupFiles] textStatus: "error " errorThrown:"Internal Server Error " jqXHR: " Here is Activity Log after I turn On errors (this is from small window): [ERROR] SQL 1.5.0.0 1054 in INSERT INTO `shop` (`id_shop`, `id_group_shop`, `name`, `id_category`, `id_theme`, `active`, `deleted`) VALUES (1, 1, (SELECT value FROM `configuration` WHERE name = 'PS_SHOP_NAME'), 1, 1, 1, 0): Unknown column 'id_group_shop' in 'field list' [ERROR] SQL 1.5.0.0 1054 in INSERT INTO `stock` (id_product, id_product_attribute, id_shop, quantity) (SELECT id_product, id_product_attribute, 1, quantity FROM product_attribute): Unknown column 'id_shop' in 'field list' [ERROR] SQL 1.5.0.0 1054 in INSERT INTO `stock` (id_product, id_product_attribute, id_shop, quantity) (SELECT id_product, 0, 1, IF( (SELECT COUNT(*) FROM product_attribute pa WHERE p.id_product = pa.id_product) > 0, (SELECT SUM(pa2.quantity) FROM product_attribute pa2 WHERE p.id_product = pa2.id_product), quantity ) FROM product p): Unknown column 'id_shop' in 'field list' [ERROR] SQL 1.5.0.0 1054 in UPDATE stock_mvt sm SET sm.id_stock = IFNULL(( SELECT IFNULL(s.id_stock, 0) FROM 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 's.id_shop' in 'order clause' [ERROR] SQL 1.5.0.0 1054 in INSERT INTO `attribute_group_shop` (id_group_shop, id_attribute) (SELECT 1, id_attribute FROM `attribute`): Unknown column 'id_group_shop' in 'field list' [ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `cart_rule_lang` CHANGE `id_discount` `id_cart_rule` int(10) unsigned NOT NULL: Unknown column 'id_discount' in 'cart_rule_lang' [ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `cart_rule_lang` CHANGE `description` `name` varchar(254) NOT NULL: Unknown column 'description' in 'cart_rule_lang' [ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `cart_rule_product_rule_value` CHANGE `id_category` `id_item` int(10) unsigned NOT NULL: Unknown column 'id_category' in 'cart_rule_product_rule_value' [ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `cart_rule_product_rule_value` CHANGE `id_discount` `id_product_rule` int(10) unsigned NOT NULL: Unknown column 'id_discount' in 'cart_rule_product_rule_value' [ERROR] SQL 1.5.0.1 1054 in INSERT INTO `cart_rule_product_rule` (`id_product_rule`, `id_cart_rule`, `quantity`, `type`) ( SELECT DISTINCT `id_product_rule`, `id_product_rule`, 1, 'categories' FROM `cart_rule_product_rule_value` ): Unknown column 'id_cart_rule' in 'field list' [ERROR] PHP 1.5.0.2 /* Update records before alter tables */ /* PHP:set_stock_available(); */ 1054 - (attributes)Unknown column 'id_group_shop' in 'field list' [ERROR] SQL 1.5.0.2 1054 in INSERT IGNORE INTO `order_payment` (`id_order_invoice`, `id_order`, `id_currency`, `amount`, `payment_method`, `conversion_rate`, `date_add`) ( SELECT ( SELECT oi.`id_order_invoice` FROM `order_invoice` oi WHERE oi.`id_order` = o.`id_order` ), o.`id_order`, o.`id_currency`, o.`total_paid_real`, o.`payment`, o.`conversion_rate`, o.`date_add` FROM `orders` o LEFT JOIN `order_payment` op ON (op.`id_order` = o.`id_order`) WHERE op.`id_order_payment` IS NULL ): Unknown column 'op.id_order' in 'on clause' [ERROR] SQL 1.5.0.4 1054 in INSERT INTO `cart_rule_product_rule_group` (`id_product_rule_group`, `id_cart_rule`, `quantity`) ( SELECT `id_cart_rule`, `id_cart_rule`, `quantity` FROM `cart_rule_product_rule` ): Unknown column 'id_cart_rule' in 'field list' [ERROR] SQL 1.5.0.4 1054 in ALTER TABLE `cart_rule_product_rule` CHANGE `id_cart_rule` `id_product_rule_group` int(10) unsigned NOT NULL: Unknown column 'id_cart_rule' in 'cart_rule_product_rule' [ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `shop` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL: Unknown column 'id_group_shop' in 'shop' [ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `stock_available` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL: Unknown column 'id_group_shop' in 'stock_available' [ERROR] SQL 1.5.0.10 1054 in INSERT INTO `attribute_shop` (`id_attribute`, `id_shop`) (SELECT a.id_attribute, c.id_shop FROM attribute_group_shop a LEFT JOIN shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN shop c ON b.id_shop_group = c.id_shop_group): Unknown column 'a.id_attribute' in 'field list' [ERROR] PHP 1.5.0.12 /* PHP:p15012_add_missing_columns(); */ 1 - UPDATE `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 `order_invoice_payment` (SELECT id_order_invoice, id_order_payment, id_order FROM `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 `order_payment` ADD COLUMN `order_reference` VARCHAR(10) AFTER `id_order`, ADD INDEX `order_reference`(`order_reference`): Unknown column 'id_order' in 'order_payment' Warning detected during upgrade. Unable to open zipFile /home/***/public_html/admin***/autoupgrade/tmp/wexpay.zip Unable to open zipFile /home/***/public_html/admin***/autoupgrade/tmp/wexpay.zip And here is from large window: errors.txt Edited October 18, 2013 by silviu_25 (see edit history) Link to comment Share on other sites More sharing options...
silviu_25 Posted October 18, 2013 Author Share Posted October 18, 2013 anyone can help with this please? or if not, how can I export all store data (images, products, attributes, etc...) and import it in a clean install of 1.5.6.0 ? Link to comment Share on other sites More sharing options...
NemoPS Posted October 18, 2013 Share Posted October 18, 2013 Visit the front office and see what it says with errors turned on Link to comment Share on other sites More sharing options...
silviu_25 Posted October 18, 2013 Author Share Posted October 18, 2013 nothing, no error, no warnings... everything is ok Link to comment Share on other sites More sharing options...
thepofo Posted November 26, 2013 Share Posted November 26, 2013 nothing, no error, no warnings... everything is ok I have the same issues, did you manage to solve it, or is the shop just working correctly even with these errors. Link to comment Share on other sites More sharing options...
silviu_25 Posted November 26, 2013 Author Share Posted November 26, 2013 I have the same issues, did you manage to solve it, or is the shop just working correctly even with these errors. I did not found a sollution for this. I updated manualy database and files, took me 3 days but .. now is ok Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now