DB Issue

[Calista]

So, this morning my server went down. It's older and this is not unusual. I had it restarted and when it came back up, the forums appeared to be working.

Until you actually clicked on a link to a post which gives the following error:
Table './icchat_smf/smf_topics' is marked as crashed and last (automatic?) repair failed

When you click on a message board, I (as admin) get this error:
Database Error
Table './icchat_smf/smf_topics' is marked as crashed and last (automatic?) repair failed
File: /home/icchat/public_html/forum/Sources/MessageIndex.php
Line: 461

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.18, while your database is at version 1.1.7. The above error might possibly go away if you execute the latest version of upgrade.php.

First thing I did was call my host and ask them to restart the server again.
Then I called and they checked: everything is running correctly, but for some reason the SMF forums are not connecting with the database.

So I uploaded and ran the upgrade.php file..

I got this error:

Upgrading...
Updating Settings.php... Successful.

Warning: file(/home/icchat/public_html/forum/upgrade_1-1.sql) [function.file]: failed to open stream: No such file or directory in /home/icchat/public_html/forum/upgrade.php on line 1127

Warning: implode() [function.implode]: Invalid arguments passed in /home/icchat/public_html/forum/upgrade.php on line 1144

Warning: Invalid argument supplied for foreach() in /home/icchat/public_html/forum/upgrade.php on line 1146
Successful.
   Updating version number... done.
Taking the forum out of maintenance mode... Successful.
Upgrade Complete

And now I'm getting this error when I click on a message board:

Database Error
Table './icchat_smf/smf_topics' is marked as crashed and last (automatic?) repair failed
File: /home/icchat/public_html/forum/Sources/MessageIndex.php
Line: 461

I did a check and looking at my "Detailed Version Check"

SMF File   Your Version   Current Version
SMF Package   SMF 1.1.18   SMF 1.1.17
Sources   1.1.18   1.1.18
Default Templates   1.1.12   1.1.12
Language Files   1.1.18   1.1.18
Current Templates   1.0   1.1

Which was a little odd, I thought.

At any rate, my host has done everything they can on their end for me (or that they are willing to do)----

What's going on here and how can I fix it?
Thanks in advance for the help!

-Cal

[Gary]

Hm... in phpMyAdmin have you tried running

Code Select Expand

REPAIR TABLE 'smf_topics';

[ziycon]

If Gary's suggestion doesn't work try this.

REPAIR TABLE 'smf_topics' USE_FRM;

[a10]

I did a check and looking at my "Detailed Version Check"
SMF File   Your Version   Current Version
SMF Package   SMF 1.1.18   SMF 1.1.17
Which was a little odd, I thought.

? Same here, says 1.1.17 as current.

[Arantor]

Somebody didn't update the site database when 1.1.18 was released.

[Calista]

Somebody didn't update the site database when 1.1.18 was released.

How do I fix THAT?

[Arantor]

You don't. It's not your site or your database that needs to be updated.

[ziycon]

Have you stopped getting the table crash errors?