Unable to delete topic

[wizard247]

First of all, when I searched this forum for "unable to delete topic" I received the following message:
"One or all of your search keywords were below 3 characters or you searched for words which are not allowed, such as 'html', 'img', etc, please increase the length of these search keywords or choose different keywords".

Mmmmmm....

Anyway, I am unable to delete a topic which was entered by the previous administrator of our IP Board using the same Admin login.

First of all I see this error message:

twia.org.au Driver Error
There appears to be an error with the database.

If you are seeing this page, it means there was a problem communicating with our database. Sometimes this error is temporary and will go away when you refresh the page. Sometimes the error will need to be fixed by an administrator before the site will become accessible again.

I then hit the refresh button as advised, which provides the following error screen:

An Error Occurred

Sorry, an error occurred. If you are unsure on how to use a feature, or don't know why you got this error message, try looking through the help files for more information.

[#5030] We use an authorization key to verify you really submitted the form, and the authorization key was not supplied with your form submission or was invalid. Please go back, reload the form and try to submit it again.

I have run database checker and have come up with the following error:

ibf_topic_views YN Click here to fix this table, or you can run the following queries manually:

* ALTER TABLE ibf_topic_views ADD views_tid int(10) NOT NULL default '0'

clicking there to fix the table doesn't do anything.

When I go to SQL Toolbox and click on the ibf_topic_views table, the following error comes up:
Can't find file: 'ibf_topic_views' (errno: 2)

This would also explain why all of my topics show zero views?

How do I create that table in my database and is this the reason I am unable to delete a topic?

Thanks for your help,
Wizard247


IP Board version is: 3.0.5



Thanks,
Wizard247

[wizard247]

OK - I was a bit impatient and googled the error message in PHPMyAdmin - I found a suggestion to "drop" the table concerned and recreate it new by running the following SQL query:

CREATE TABLE ibf_topic_views (
views_tid int(10) NOT NULL default 0,
KEY views_tid (views_tid)
);

This has fixed my problem - database is repaired and I was able to delete my topics.

Got the above code from the following source in case anyone is interested:

http://www.invisionmodding.com/topic/48255-resolved-topic-views-are-not-incremented/

Good luck and thanks for reading.

Wizard247