Your host apparently doesn't know much about MySQL. If they couldn't read the error message and know what it means when you first told them about it, then they really ought not to be in the hosting business.
Originally Posted by magibson
"b" refers to an "alias", which in this case refers to the table named "banners":
(and "bh" refers to the "banners_history" table)
Here's how to do it yourself:
[select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = 1 and b.banners_id = bh.banners_id group by b.banners_id, b.expires_date, b.expires_impressions]
1. log in to phpMyAdmin
2. on the left column, choose your database from the pulldown list
3. click on the banners table
4. now on the right-hand side of the screen you see several tabs. Click on the Operations tab.
5. click on the "repair table" link