SMF Personal Messages Database Error

[32v]

I inherited an SMF a few years ago. I do some semi-regular maintenance and try to keep everything up to date. The forum has run without any problems until yesterday. When I logged on I got a popup that I had received a PM. When I went to My Messages, I received the following error message.

Database Error

Table './db469901217/smf_personal_messages' is marked as crashed and last (automatic?) repair failed
File: /homepages/11/d132647312/htdocs/Amfone/Amforum/Sources/Load.php
Line: 2233

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


I cannot get to the admin section of the forum, or any other section for that matter. I connected to the server via SSH (getting at the very edge of my skill set) and tried running the existing upgrade.php file on the server. It ran but did not fix the problem. Do I need to upload a newer version of upgrade PHP? Or are some other actions in order.

Thanks in advance for any help.

[vbgamer45]

Try to run this mysql command on your database. If you have phpmyadmin run it via that

REPAIR TABLE smf_personal_messages;

[32v]

Thanks. That was quick! Did that and got this report:

Table                                                    Op           Msg_type   Msg_text
db469901217.smf_personal_messages   repair   error   Can't create new tempfile: './db469901217/smf_pers...
db469901217.smf_personal_messages   repair   status   Operation failed

[vbgamer45]

Can't see the whole error you might need to contact your host.
Might be out of disk space or a permission issue.

[32v]

A bit more detail on the error.

db469901217.smf_personal_messages   repair   error   Can't create new tempfile: './db469901217/smf_personal_messages.TMD'
db469901217.smf_personal_messages   repair   status   Operation failed


Should not be a disk space problem.

Used Disk Space :   11,743.00 MB of 141,947.00 MB (activated) - max. available: 141,947.00 MB*
Transfer Volume :   15940 MB of 1200000 MB have been used
File Usage :   82925 of 1048576 files in use

[32v]

Ran analyze on the table:

db469901217.smf_personal_messages   analyze   Error   Table './db469901217/smf_personal_messages' is marked as crashed and last (automatic?) repair failed
db469901217.smf_personal_messages   analyze   Error   Table 'smf_personal_messages' is marked as crashed and last (automatic?) repair failed
db469901217.smf_personal_messages   analyze   error   Corrupt

[Illori]

you are best to contact your host, nothing else we can really do for you at this point.

[32v]

What should I ask my host to do?

What happens if I drop the offending table with phpMyAdmin?

BTW, the forum appears to by running normally for other users.

[Arantor]

Dropping the table will break the PM system entirely.

[Kindred]

do not drop that table... That will cause ALL SORTS of errors - even if you just empty that table, it would cause errors.

what to tell your host?    "Help me fix this" is a good start.

table crashes are an issue on the host side of things, 99% of the time...

[32v]

OK. Not trying to be stupid, but I haven't dealt with this sort of thing before. Off to call the host.

Thanks.

[32v]

Talked to the host. They restarted/reset the database which did nothing. All they offered was a back up of the db from a day prior to the crash and recommend replacing the offending table in the existing db from the backup. Is this advisable?

[vbgamer45]

Yes I would do that at this point. But just make sure they replace only smf_personal_messages table

[32v]

They won't do it. I have to do it. They claim it can be done in phpMyAdmin.

[vbgamer45]

Do you have the backup file?
You can drop the table in phpmyadmin

The backup file just make sure it is just that table in the sql file...If it's the whole database you have just pull that one table and entries out of it.

[32v]

I have a backup of the entire db.

I haven't messed with phpmyadim much. I'm hoping that it will be semi-obvious on how to replace the corrupted table with a hopefully good one from the backup db.

[vbgamer45]

It is not that obvious easy to drop the table in phpmyadmin but you would have to grab just the table and the inserts for the table from the backup file.