[ERROR] SQL 1.5.0.0 1054 in INSERT INTO `shop`...

[silviu_25]

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!

[NemoPS]

Can you try turning on errors as described in my signature? it looks like some tables were not created

[silviu_25]

  On 10/18/2013 at 7:26 AM, Nemo1 said:

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)

[silviu_25]

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 ?

[NemoPS]

Visit the front office and see what it says with errors turned on

[silviu_25]

nothing, no error, no warnings... everything is ok

[thepofo]

  On 10/18/2013 at 8:14 PM, silviu_25 said:

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.

[silviu_25]

  On 11/26/2013 at 8:17 PM, thepofo said:

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