FUDforum: How To » HELP - messages disappeared after database repair

Home » FUDforum » How To » HELP - messages disappeared after database repair

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

Re: HELP - messages disappeared after database repair [message #158825 is a reply to message #158824]

Wed, 01 April 2009 13:26

naudefj

Messages: 3771
Registered: December 2004

Karma:

Senior Member
Administrator
Core Developer

Maybe it wasn't just your DB that got corrupted. Please check and let us know. I would also like to know what version of FUDforum you're using and what "admin routine" you followed.

To trace the message path:

1. Pick a message and write down its message number (look for something like "message #528" in the header).

2. Query the file_id and offset where the message is stored. For example:

SELECT file_id, foff, length FROM fud28_msg WHERE id = 528;
10000	976757	2092

3. Look for the file with the selected file_id in your messages directory - in our case msg_10000.

4. Check if the file contains the message body at the selected offset:

$ od -a -j 976757 -b 2092  msg_10000

Best of luck.

Frank

Report message to a moderator

[Message index]

		HELP - messages disappeared after database repair By: michiamano on Wed, 01 April 2009 04:26
		Re: HELP - messages disappeared after database repair By: naudefj on Wed, 01 April 2009 09:15
		Re: HELP - messages disappeared after database repair By: michiamano on Wed, 01 April 2009 12:49
		Re: HELP - messages disappeared after database repair By: naudefj on Wed, 01 April 2009 13:26

Previous Topic:	NNTP Server Message Cancellation
Next Topic:	How-To Upgrade to New Version

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 03:27:22 GMT 2024

Total time taken to generate the page: 0.04059 seconds