Upgrading from 2.0.7 to 2.1.0 breaks admin functionality

[alexgoodeyos]

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

[achitakayoh]

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

[pgoetzin]

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?

[pgoetzin]

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

[pgoetzin]

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