FUDforum: Bug Reports » Database problem in fud30

Home » FUDforum Development » Bug Reports » Database problem in fud30_ses sessions table

Show: Today's Messages :: Polls :: Message Navigator

Database problem in fud30_ses sessions table [message #183073]

Mon, 07 October 2013 07:26

randomserver

Messages: 3
Registered: January 2011

Karma:

Junior Member

I have found a systematic error in the sessions table. The "ses" sessions table
occasionally report that the table has crashed. Due to this nothing can be displayed;
the entire forum is just blank.

Finding a source bug could be difficult, and if this is a hard-drive problem
nothing can be found. I suspect that a hacker-script enter some special
angry URL, and the session number is transferred to the database and some error
occurs. I have the logs, but I don't know what to look for.

The solution that I use now is that I "drop table" and then create a new empty
one using an SQL obtained from a forum that still works.

My thought is that:
To test-read the table, and monitor the error codes.
If the table is plain inaccessible, drop and then write
a new table by an external script.

There might also be problems with other tables that are updated frequently,
but I have not detected any problem elsewhere.

RANDOMSERVER
http://www.randomserver.dyndns.org

Report message to a moderator

[Message index]

		Database problem in fud30_ses sessions table By: randomserver on Mon, 07 October 2013 07:26
		Re: Database problem in fud30_ses sessions table By: naudefj on Mon, 07 October 2013 08:56

Previous Topic:	Use Aliases on groupmgr problem
Next Topic:	Images take too much space

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 15:42:46 GMT 2024

Total time taken to generate the page: 0.03708 seconds