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?
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
#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?
Is there an easy way to fix it ? phpmyadmin and create the column ?
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