Help me pls.. Nobody can log into forum

Started by hhoban, August 13, 2008, 09:09:24 AM

Previous topic - Next topic

hhoban

Forum was working fine yesterday and today when I go to log in this is what I get. I didn't change anything yesterday we all just posted to it. What do I have to fix to get in. No mods have been added.. the only thing that happened yesterday was we posted to it.

In firefox I get this:
Can't open file: 'smf_log_online.MYI' (errno: 145)
File: /forum/Sources/Subs.php
Line: 2575

Internet Explorer:
Can't open file: 'smf_sessions.MYI' (errno: 145)

hhoban

The rest of the site is working fine. Its just the forum. Can someone please let me know what I need to do to get this fixed. This is what you see when you go to the address now. At least an hour ago you saw the template. Its getting worse and I am not doing anything.




http://www.canadianwarrants.com/forum/index.php

mike_sw

It's mysql at fault here. Optimize the tables from Admin -> Forum Maintenance -> Common Tasks -> Optimize All Tables

hhoban

How do I do that when I can't even get to the log on page for the forum?

What changed that caused this? I sure don't want to wake up to this again.

hhoban

I have run the repair tool. I have accessed the sql server and run a repair and now I am getting 500 Internal Server Error. This is just getting worse. The whole rest of the site is working fine except the forum.

ccbtimewiz


hhoban

No, I don't even have a moderator. There are two admins and I definitely have no problem there.

I can see all the files through ftp and nothing has been altered since yesterday when we were on. Got up this morning to this so I just need help in what to do to get access again.

ccbtimewiz

Quote from: hhoban on August 13, 2008, 03:00:58 PM
No, I don't even have a moderator. There are two admins and I definitely have no problem there.

I can see all the files through ftp and nothing has been altered since yesterday when we were on. Got up this morning to this so I just need help in what to do to get access again.

mod_security has nothing to do with moderators. Please read the link I provided.

hhoban

Did that. Still nothing. Server for the forum is Yahoo and they don't have it. If they just decided to implement it I wouldn't be the only one that just encountered this problem. I am sure there would have been a lot more but anyway. .htaccess uploaded and still no access.

hhoban

I really would appreciate if someone could give me more ideas on what to do. This forum has been down all day now and its nothing to do with my server and I haven't installed any mods for over a month and I am out of ideas.

ccbtimewiz

Please don't bump your topics up in under 24 hours. We're all volunteers here.

`smf_log_online` is apparently damaged, but can be repaired or re-created.
Login to phpMyAdmin and run the following queries.

REPAIR TABLE `smf_log_online`

OPTIMIZE TABLE `smf_log_online`

hhoban

#11
I apologize.. this is just getting so frustrating...

Okay I ran those codes on the smf_log_online and its not getting any errors now. Then I clicked on the whole database. I optimized any tables that gave me the option but when I click on these two here are the errors I get

SQL query: Edit

SHOW KEYS FROM `smf_sessions` ;

MySQL said: Documentation
#1105 - File './data/smf_sessions.MYD' not found (Errcode: 13)

found this to fix the smf_sessions error

http://www.simplemachines.org/community/index.php?topic=169957.msg1084493#msg1084493





SQL query: Edit

SHOW KEYS FROM `smf_log_errors` ;

MySQL said: Documentation
#1105 - File './data/smf_log_errors.MYD' not found (Errcode: 13)

Now I just need to know how to fix the smf_log_error

thanks

hhoban

#12
I am still having problems. I have to open mysql and repair something about 10 times a day right now. Its something different every time but the one error that is contant is:

File './data/smf_log_errors.MYD' not found (Errcode: 13)

Now if someone could please tell me how to rebuild that file like my other error was fixed from this thread below I would very much appreciate it and I would be out of everyone's hair. No matter how many times I repair and optimize its not going away. I have searched everywhere and I can't find the same error posted so I can just use someone else's fix to clean this mess up.

http://www.simplemachines.org/community/index.php?topic=169957.msg1084493#msg1084493

mike_sw

That message tells you that it can't find the physical file where the smf_log_errors table is kept. Please verify you still have the tables in your smf database. 

hhoban

It shows its still there in the database but when I click on it I get the same error. Is there any way to rebuild. I do have a backup of it but its a month old.

青山 素子

You will probably need to contact your host. It appears there is a problem with their database server.
Motoko-chan
Director, Simple Machines

Note: Unless otherwise stated, my posts are not representative of any official position or opinion of Simple Machines.


Advertisement: