Is there a way to trigger a DB schema update?
I've just copied the live DB which is 1.8 to a development host which has 1.9.3.3 installed. The frontend is displaying correctly but I can't get into /admin as some of the metadata tables are missing columns.
For example I'm getting the following logged in var/report
a:5:{i:0;s:698:"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sales_bestsellers_aggregated_yearly.product_type_id' in 'field list', query was: SELECT COUNT(*) FROM (SELECT MAX(DATE_FORMAT(period, '%Y-%m-%d')) AS
period
, SUM(qty_ordered) ASqty_ordered
,sales_bestsellers_aggregated_yearly
.product_id
, MAX(product_name) ASproduct_name
, MAX(product_price) ASproduct_price
,sales_bestsellers_aggregated_yearly
.product_type_id
FROMsales_bestsellers_aggregated_yearly
WHERE (EXISTS (SELECT 1 FROMcatalog_product_entity
ASexisted_products
WHERE (sales_bestsellers_aggregated_yearly.product_id = existed_products.entity_id))) AND (store_id IN(0)) GROUP BYproduct_id
LIMIT 5) ASt
";i:1;s:5064:"#0 /public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)