| log-in error for admin and everyone else [message #19914] |
Thu, 16 September 2004 16:07  |
zeeislandboy
Messages: 5
Registered: September 2004
Karma: 0
|
Junior Member |
|
|
I get the following log-in error (as soon as log-in link is pressed) when I try to log in as admin. My users get the same error. I've tried this both from IE and Netscape with the same results. How do I get around this?
Fatal error: SQL Error has occured, please contact the administrator of the forum and have them review the forum's SQL query log in /home/coastgui/public_html/forum/include/theme/default/err.inc on line 102
I've tried replacing the err.inc file via my ftp program (GoLive) but access is denied.
I've tried registering as a new user, and I get logged in, but then I get the same error when the new user tires to log out.
Here's one more clue (or coincidence). I've recently received a huge amount of e-mail that my server is flagging as having viruses. But the senders' addresses of much of this spam are addresses that I recognize as being related to the subject matter of my forum. Could the forum have been hacked for the e-mails of registered users, and could such hacking have caused the log-in issue? The timing seems about the same.
I'm not sure which forum version I'm running, but it has worked perfectly for at least a couple of years, so I've never upgraded.
The address is
http://www.coastguides.com/forum/index.php?channel=coastguides.com
Thanks.
[Updated on: Thu, 16 September 2004 17:10] Report message to a moderator |
|
|
|
| Re: log-in error for admin and everyone else [message #19917 is a reply to message #19914] |
Thu, 16 September 2004 18:16  |
zeeislandboy
Messages: 5
Registered: September 2004
Karma: 0
|
Junior Member |
|
|
Here's a new twist. Accessed my sql database (called cgforumdb.fud23) via my host and all files (.fud23) OK except cgforumdb.fud23_ses. Attmepted to repair with host's mysql software, resulting in the following report:
cgforumdb.fud23_ses
warning : Table is marked as crashed and last repair failed
warning : 3 clients is using or hasn't closed the table properly
warning : Size of indexfile is: 6872064 Should be: 5392384
error : Found 60057 keys of 60056
error : Corrupt
After thuis attempted fix, I casn't even get tot he forum without getting the error I was getting before when trying to log in.
Is there a way to fix the .ses file or reinstall just it without affecting the others? Would simply updating my version of FUD forum resolve this?
I'm out of my league here.
[Updated on: Thu, 16 September 2004 18:19] Report message to a moderator |
|
|
|
|
|
| Re: log-in error for admin and everyone else [message #19920 is a reply to message #19919] |
Thu, 16 September 2004 19:29 |
zeeislandboy
Messages: 5
Registered: September 2004
Karma: 0
|
Junior Member |
|
|
Thank you, thank you. I emptied the fud23_ses table and voila! Up and running.
For the newbies like me, here's how I did it:
I have MySQL on my server, which allows me to see the database files. I'm a novice to all of this, so I might not get all the terms right. Once you see the files, find your fud23_ses file. All this contains is info about the current sessions, so you can empty it without affecting your forum. You want to "empty" it, not "drop" it (these are the terms in MySQL. I assume "drop" means delete, but I'm not sure). Sinced fud23_ses will probably be "in use," you'll need to check the box next to the file and use the small pull-down list to chose "empty". And that's it. When you look at the list of files, you'll now see that it is not in use and contains 0 records. Next time you or someone else logs onto your forum, the fud23_ses file gets filled up with fresh info (and hopefully you won't see the error message!).
[Updated on: Thu, 16 September 2004 19:46] Report message to a moderator |
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]