FUDforum: Bug Reports » Compatcting Database: Fatal disk space error

Home » FUDforum Development » Bug Reports » Compatcting Database: Fatal disk space error

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

Re: Compatcting Database: Fatal disk space error [message #25861 is a reply to message #25853]

Thu, 23 June 2005 21:07

keneisman

Messages: 68
Registered: May 2005

Karma:

Member

This is what I've found out about munged messages after compacting:

It happens between messages in the same forum, not between forums.
It seems to only be happeing after an edit. New messages don't cause this behavior.
Apparently the foff column in the msg table is being rewritten incorrectly. For instance,
- I have 2 messages in a forum - msg 1 and msg 2
- The foff value for msg 1 is 0, length=251 and the foff value for msg 2 is 251, length=959
- I run the compact messages
- Now foff for msg 1 is 2420,length=251 and foff value for msg 2 is now 2671,length=959
I don't know if the file in the messages directory (msg_10000) is supposed to change or not but it appears as though it hasn't changed.
If I manually reset the foff values to their original settings, my messages are back.

Any idea what I'm doing wrong?
compact.php is version 1.50

Thanks
Ken

Report message to a moderator

[Message index]

		Compatcting Database: Fatal disk space error By: keneisman on Mon, 20 June 2005 16:10
		Re: Compatcting Database: Fatal disk space error By: Ilia on Mon, 20 June 2005 16:31
		Re: Compatcting Database: Fatal disk space error By: keneisman on Mon, 20 June 2005 18:06
		Re: Compatcting Database: Fatal disk space error By: keneisman on Mon, 20 June 2005 18:56
		Re: Compatcting Database: Fatal disk space error By: Ilia on Mon, 20 June 2005 23:43
		Re: Compatcting Database: Fatal disk space error By: keneisman on Tue, 21 June 2005 01:52
		Re: Compatcting Database: Fatal disk space error By: Ilia on Tue, 21 June 2005 13:10
		Re: Compatcting Database: Fatal disk space error By: keneisman on Tue, 21 June 2005 13:19
		Re: Compatcting Database: Fatal disk space error By: Ilia on Tue, 21 June 2005 13:24
		Re: Compatcting Database: Fatal disk space error By: keneisman on Tue, 21 June 2005 17:00
		Re: Compatcting Database: Fatal disk space error By: keneisman on Tue, 21 June 2005 17:10
		Re: Compatcting Database: Fatal disk space error By: keneisman on Tue, 21 June 2005 20:15
		Re: Compatcting Database: Fatal disk space error By: Ilia on Tue, 21 June 2005 20:20
		Re: Compatcting Database: Fatal disk space error By: keneisman on Tue, 21 June 2005 20:50
		Re: Compatcting Database: Fatal disk space error By: Ilia on Tue, 21 June 2005 20:58
		Re: Compatcting Database: Fatal disk space error By: keneisman on Tue, 21 June 2005 21:17
		Re: Compatcting Database: Fatal disk space error By: keneisman on Tue, 21 June 2005 22:07
		Re: Compatcting Database: Fatal disk space error By: Ilia on Wed, 22 June 2005 02:01
		Re: Compatcting Database: Fatal disk space error By: keneisman on Wed, 22 June 2005 13:34
		Re: Compatcting Database: Fatal disk space error By: Ilia on Wed, 22 June 2005 13:42
		Re: Compatcting Database: Fatal disk space error By: keneisman on Wed, 22 June 2005 15:54
		Re: Compatcting Database: Fatal disk space error By: keneisman on Wed, 22 June 2005 21:34
		Re: Compatcting Database: Fatal disk space error By: Ilia on Thu, 23 June 2005 14:58
		Re: Compatcting Database: Fatal disk space error By: keneisman on Thu, 23 June 2005 15:14
		Re: Compatcting Database: Fatal disk space error By: keneisman on Thu, 23 June 2005 21:07
		Re: Compatcting Database: Fatal disk space error By: Ilia on Fri, 24 June 2005 02:31
		Re: Compatcting Database: Fatal disk space error By: keneisman on Fri, 24 June 2005 04:09
		Re: Compatcting Database: Fatal disk space error By: Ilia on Fri, 24 June 2005 17:58

Previous Topic:	Adm lockout..
Next Topic:	Sorting by join date

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 26 02:24:18 GMT 2025

Total time taken to generate the page: 0.04227 seconds