News:

Join the Facebook Fan Page.

Main Menu

Database error?

Started by Blitzproductions, November 21, 2008, 08:35:11 AM

Previous topic - Next topic

Blitzproductions

My forum went down last night, the funny thing is I haven't touched any of the files in months and I started getting this

Database Error: Can't open file: 'smf_log_online.MYI' (errno: 145)
File: /centralparanormal/forum1/Sources/Subs.php
Line: 2596

any time we try to go to the forum.  I'm not sure what's going on here?  I checked my database with my host and it's active and working.  I'm guessing this may be something simple stupid but I'm not sure what.

Elmacik

Searching sometimes help a lot. :)

You need to repair your table in the database. Just go to phpMyAdmin and run this SQL query:
REPAIR TABLE smf_log_online;
Home of Elmacik

Blitzproductions

I did search around, trust me i've been searching all night lol.  That did fix it though thank you very much!

lesbillgates

I had a very similar error message to Blitzproductions. I did the repair as suggested by Elmacik. It worked - for about five minutes! I now get a different error message:

: Can't open file: 'smf_sessions.MYI' (errno: 145)
/forum/Sources/Load.php
1994

This message is on a blank screen, not my forum homepage like the other one. My forum is http://shareyournovel.com/forum/index.php
Can anybody help, please?

Elmacik

#4
Just do the same repair for the sessions table too. Run this query:
REPAIR TABLE smf_sessions;
Home of Elmacik

lesbillgates

Thanks very much. It's great that this kind of support is available.

IanSmartBottom

#6
I have searched the site and think my answer may be here.

I am getting
Database Error
Please try again. If you come back to this error screen, report the error to an administrator. 

When I try to log in

I am unable to log in after using a small updating from 2.3 to 2.4

would somone be able to put a little more detail on how to find and run the phpmyadmin please.

Or any other fix you might think will work.

Thanks in advance for any help

Ian

IanSmartBottom

I'm sorted now thanx.

Deleted the old forum.
Did a clean install of beta 4

All is sorted now

Ian

IanSmartBottom

Nope

I logged out and am unable to log back in

Database error again.

I have found the phpMyAdmin
And run as said above.

Thanks in advance for any help

Ian

Advertisement: