error 500 after update to 4477865bf9bcf43521003635ce3cd2bc7e5bb3ba

[Beeta]

Hello I'm getting a similar problem as in this topic.

plus images of the products in the homepage seams gone.

and in the backend I’m getting errors about the price tab

During the the update the process fialed with "internal server error".

I have db fixes to do but I can't, clicking fix toapply fix throw for example:

 

Oh snap! We have encountered an error
Unknown column 'width' in 'tb_product_attribute'
Details

Unknown column 'width' in 'tb_product_attribute'

Now I have the front-end product pages throwing 500 this error:

ThirtyBeesDatabaseException

Unknown column 'product_attribute_shop.width' in 'field list'

in file classes/Product.php at line 6265

SQL

SELECT ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
					a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
					IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
					product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
					product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`,
					product_attribute_shop.`width`, product_attribute_shop.`height`, product_attribute_shop.`depth`
				FROM `tb_product_attribute` pa
				 INNER JOIN tb_product_attribute_shop product_attribute_shop
		ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
				 LEFT JOIN tb_stock_available stock
			ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
				LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
				LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
				LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
				LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
				LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
				 INNER JOIN tb_attribute_shop attribute_shop
		ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
				WHERE pa.`id_product` = 42002
					AND al.`id_lang` = 2
					AND agl.`id_lang` = 2
				GROUP BY id_attribute_group, id_product_attribute
				ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC

Source file: classes/Product.php

6246:					IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
6247:					product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
6248:					product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`,
6249:					product_attribute_shop.`width`, product_attribute_shop.`height`, product_attribute_shop.`depth`
6250:				FROM `'._DB_PREFIX_.'product_attribute` pa
6251:				'.Shop::addSqlAssociation('product_attribute', 'pa').'
6252:				'.static::sqlStock('pa', 'pa').'
6253:				LEFT JOIN `'._DB_PREFIX_.'product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
6254:				LEFT JOIN `'._DB_PREFIX_.'attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
6255:				LEFT JOIN `'._DB_PREFIX_.'attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
6256:				LEFT JOIN `'._DB_PREFIX_.'attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
6257:				LEFT JOIN `'._DB_PREFIX_.'attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
6258:				'.Shop::addSqlAssociation('attribute', 'a').'
6259:				WHERE pa.`id_product` = '.(int) $this->id.'
6260:					AND al.`id_lang` = '.(int) $idLang.'
6261:					AND agl.`id_lang` = '.(int) $idLang.'
6262:				GROUP BY id_attribute_group, id_product_attribute
6263:				ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC';
6264:
6265:        return Db::readOnly()->getArray($sql);
6266:    }
6267:
6268:    /**
6269:     * Get product accessories
6270:     *
6271:     * @param int $idLang Language id
6272:     * @param bool $active
6273:     *
6274:     * @return array|false Product accessories
6275:     *

Stack trace

PHP version: 7.4.33.  Code revision: bf2fe6fcbed5b2fc29504ca4a0ac044705bcc1bf build for PHP 7.4

 

Edited December 8 by Beeta

[datakick]

You need to figure out why the db migration failed. Look into collectlogs, or your server error logs, for more info.

[Beeta]

20 hours ago, datakick said:

You need to figure out why the db migration failed. Look into collectlogs, or your server error logs, for more info.

as I can't find anything specific in the log I'm restoring the last backup (daily) and then try the update again.

Trying again after the snapshot restore and Core Updater gave me Internal Server Error again:

I found this on nginx access log (nothing in nginx error log):

The last two I think was me reloading the page o something similar.

Have you any idee where can I search for more information?

Right now I'm going to restore the last snapshot and postpone the update

Edited December 9 by datakick
removed sensitive data

[datakick]

Install collectlogs module

[the.rampage.rado]

47 minutes ago, datakick said:

Install collectlogs module

It looks like that in Module list:



After you install it go and try the update again and post the information that is present in Collect PHP Logs.