error opening the index

Segnali · October 15, 2018, 09:26:57 AM

Hi guys, my forum just crashed.

What should I do? This is the error I see:

Bigguy · October 15, 2018, 09:28:36 AM

You'll have to go into phpmyadmin and repair all tables in your database as SMF could not do it. Backup the database first though.

Segnali · October 15, 2018, 09:34:04 AM

Quote from: Bigguy on October 15, 2018, 09:28:36 AM
You'll have to go into phpmyadmin and repair all tables in your database as SMF could not do it. Backup the database first though.

Should I use a backup from now or would it be already damaged?

Luckily I did a back up just yesterday. I do it twice a month, but I have never seen this error. Was an attachment the issue?

Thank you

Bigguy · October 15, 2018, 09:37:01 AM

It looks like it yes. I would not use the backup. Just repair it from phpmyadmin. It should be fine after that. Than you can go into the admin panel and check out the attachments and see what is going on.

Segnali · October 15, 2018, 09:44:15 AM

Quote from: Bigguy on October 15, 2018, 09:37:01 AM
It looks like it yes. I would not use the backup. Just repair it from phpmyadmin. It should be fine after that. Than you can go into the admin panel and check out the attachments and see what is going on.

I have never repaired a db, I can try...if I find the instructions on Google

Thank you

Segnali · October 15, 2018, 09:46:13 AM

I will try these:

https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin

Segnali · October 15, 2018, 09:52:58 AM

easy!!

Forum is back online but I see a warning related to the attachment row, should I worry?

Thank you

Arantor · October 15, 2018, 09:55:28 AM

No, that's probably fine. Do a find/repair from forum admin just to verify that that number is right.

Bigguy · October 15, 2018, 10:01:08 AM

Glad you got it fixed.

Segnali · October 15, 2018, 10:23:24 AM

Quote from: Arantor on October 15, 2018, 09:55:28 AM
No, that's probably fine. Do a find/repair from forum admin just to verify that that number is right.

could you please tell me where is that function?

Thans

Bigguy · October 15, 2018, 10:45:59 AM

Admin panel....forum....attachments & avatars...file maintenance. Check things out in there.

Illori · October 15, 2018, 10:46:50 AM

Quote from: Bigguy on October 15, 2018, 10:45:59 AM
Admin panel....forum....attachments & avatars...file maintenance. Check things out in there.

that is not what Arantor is talking about, he is talking about the database find/repair.

Bigguy · October 15, 2018, 10:49:45 AM

I shoulda read it more closely, sorry for that.

Segnali · October 16, 2018, 07:22:58 AM

Quote from: Illori on October 15, 2018, 10:46:50 AM
Quote from: Bigguy on October 15, 2018, 10:45:59 AM
Admin panel....forum....attachments & avatars...file maintenance. Check things out in there.
that is not what Arantor is talking about, he is talking about the database find/repair.

I really cannot find that

Shambles · October 16, 2018, 07:27:07 AM

Admin >> Maintenance >> Forum Maintenance >> Routine >> Find & Repair any Errors .. Run Task Now

Segnali · October 20, 2018, 12:04:15 PM

Quote from: Sh@mbles on October 16, 2018, 07:27:07 AM
Admin >> Maintenance >> Forum Maintenance >> Routine >> Find & Repair any Errors .. Run Task Now

Thank you, it seems there were no errors.

So I guess problem solved, although I wonder how to prevent it from happening again. Is it possible

Thank you all of you.

Kindred · October 21, 2018, 09:34:54 AM

get a better host?

News:

error opening the index