I keep getting this message when trying to open my forum ...

[pamperedparrott]

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

The above keeps coming up and I, nor my members can get into my forum.  Is there a problem with SMF at this time?  This has been happening for 2 days and my members are getting aggrevated - Help 

[ccbtimewiz]

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

Code Select Expand

REPAIR TABLE `smf_sessions`

Code Select Expand

OPTIMIZE TABLE `smf_sessions`

Try running that. Also make sure your MySQL and PHP versions are up to date.

[pamperedparrott]

Do I need to run these on my forum admin page?  Because I can't get in at all ...

[ccbtimewiz]

As I stated, you need to go into your phpMyAdmin.

What is phpMyAdmin?

[pamperedparrott]

Sorry, maybe I'm just ignorate here, but I do not see the SQL tab at the top of that home page.

[ccbtimewiz]

Can you show me a screenshot of your phpMyAdmin?

[pamperedparrott]

http://www.phpmyadmin.net/home_page/index.php [nofollow]

[ccbtimewiz]

That's the phpMyAdmin homepage..

You need to access YOUR phpMyAdmin page. Eg, you need to access your database. The information you need to get into your database should be in your Settings.php file.

[pamperedparrott]

I'm in my phpMyAdmin page, but do not see where I need to insert the codes ... maybe I'm overlooking something.

[pamperedparrott]

I'm in my phpMyAdmin page, but do not see where I need to insert the codes ... maybe I'm overlooking something.

I clicked on the SQL tab to the left and entered teh query you gave me and clicked run ... it came up with an error.

[ccbtimewiz]

What's the error?

[pamperedparrott]

I was able to get it to accept the query codes you gave me and my forum will come up now, but you can't sign in ... in fact, you can't even see the home page, only the sign in area.  Could there be something that needs to be updated in my admin section of my forum?  I can't sign on to get into that area.

[pamperedparrott]

I really need to get my forum back up ... I'm getting emails from my members.

Help ...

[ccbtimewiz]

Link to forum please?

[pamperedparrott]

www.outdoorenvy.com/Forum [nofollow]

[ccbtimewiz]

So ok, you're getting a database error right off the fly.

Do you have any database backups with you? If not, contact your host for one? Because I'm unable to troubleshoot for this if the online session table is working.

[pamperedparrott]

Thanks for trying ... I hope I haven't lost all my post on my forum.

[Rumbaar]

Did you go to your hosts cPanel, then select the phpMyAdmin area of your cPanel.  Then move to your current smf db listed in the left pane.  Then select the table in question and repair the table?

If you are having issue with this kind of basic web site administration you might want to seek the assistance of a trained professional.  At the very least you might want to contact you host and ask them if they can help or if there is the nessary tools in your plans access panel to achieve this task.

[pamperedparrott]

I went into the php file in my file manager and signed into phpMyAdmin area and clicked on the SQL icon to the left and when that page came up, I entered the above codes given to me and ran the query.  It brought my forum page back up instead of it just showing a white page with the error message, but I can't log into my forum - there is an error message on the page to contact the administrator (which is me & I can't fix it) 

[N3RVE]

Open phpMyAdmin (What is phpMyAdmin?), SQL ->

Code (Run) Select Expand


TRUNCATE TABLE `smf_sessions`


-[n3rve]