I dropped table coupon_aggregated_updated and reinstalled using Connect. Table was recreated and site looks fine.
This is a “me too” post.
During an upgrade using Magento Connect from 1.4.1 - 1.4.2 - 1.5.0 - 1.5.1 - 1.6.0 - 1.6.1. I took one step at a time going up in single level increments. The following error implies that coupon_aggregarted_updated was created in a previous step and 1.6.1 wants to do it again and cannot because it already exists. Am I reading that correctly? Would removing the table coupon_aggregated_updated help?
Exception during cache and session cleaning: Error in file: "/var/www/app/code/core/Mage/SalesRule/sql/salesrule_setup/upgrade-22.214.171.124-126.96.36.199.php" - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'coupon_aggregated_updated' already exists
Also, what happens if I choose “uninstall” from Magento Connect?