honestly, I would just drop the topic views table and recreate it using
create table ubbt_TOPIC_VIEWS (
TOPIC_ID int(11) unsigned not null,
index topic_ndx (TOPIC_ID)
) TYPE=heap
If you're like me and give this a try to clear up an error, change TYPE=heap to ENGINE=MEMORY
Thank you Giz for keeping hope alive