cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrading from 2.0.7 to 2.1.0 breaks admin functionality

Upgrading from 2.0.7 to 2.1.0 breaks admin functionality

Hi,

 

After upgrading from 2.0.7 from 2.1.0 certain functionality has broken in the admin interface (possibly elsewhere) due to an update to the file vendor/magento/module-sales/Setup/InstallSchema.php which adds a new column base_grand_total to the sales_invoice_grid not having an equivalent update to vendor/magento/module-sales/Setup/UpgradeSchema.php which means the column only get's added on new installs.

 

Can you please confirm this issue and update on when a new release will be made to resolve this problem?

 

Kind Regards

 

Alex

4 REPLIES

Re: Upgrading from 2.0.7 to 2.1.0 breaks admin functionality

Same problem + unable to create product (icon turns forever…)

Re: Upgrading from 2.0.7 to 2.1.0 breaks admin functionality

same for me.

 

[2016-07-06 10:22:46] main.CRITICAL: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'base_grand_total' in 'field list' in httpdocs/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 httpdocs/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 httpdocs/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array)

 

are there more columns missing ? 

 

Is there a official bug report open?

Re: Upgrading from 2.0.7 to 2.1.0 breaks admin functionality

Is there an easy way to fix it ? phpmyadmin and create the column ?

Re: Upgrading from 2.0.7 to 2.1.0 breaks admin functionality

https://github.com/magento/magento2/issues/4785 fixed my problem

 

ALTER TABLE sales_invoice_grid ADD base_grand_total decimal(12,4) AFTER grand_total;

 

worked for me