Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » Help! Data loss - message files.
Show: Today's Messages :: Unread Messages :: Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Return to the default flat view Create a new topic Submit Reply
Help! Data loss - message files. [message #28760] Wed, 09 November 2005 21:42 Go to previous message
tangledweb is currently offline  tangledweb   Australia
Messages: 9
Registered: November 2005
Junior Member
add to buddy list
ignore all messages by this user
About three weeks ago I put up a FUDforum for a club. All was humming along nicely, until today.

The front page seemed to be 12 hours out of sync with what was actually happening. In the admin options I ran the consistency checker, which reported no problems but made no difference.

I ran compact messages, which came up with a blank screen (in firefox) but blinked up some errors briefly.

The following errors are in the source of the admin page after refreshing, but something similar had blinked up the first time.

<br>Disabling the forum for the duration of maintenance run<br><br>Please wait while forum is being compacted.<br>This may take a while depending on the size of your forum.<br>

Compacting normal messages...<br>
<br />
<b>Warning</b>: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in <b> /mounted-storage/home7/sub001/sc13992-BUGP/vichorse/FUDforum/include/theme/ default/db.inc </b> on line <b>128</b><br />
100% Done<br>
Compacting private messages...<br>
<br />
<b>Warning</b>: fopen(/mounted-storage/home7/sub001/sc13992-BUGP/vichorse/FUDforum/messages /private): failed to open stream: No such file or directory in <b> /mounted-storage/home7/sub001/sc13992-BUGP/vichorse/FUDforum/include/theme/ default/private.inc </b> on line <b>197</b><br />

<br />
<b>Warning</b>: fseek(): supplied argument is not a valid stream resource in <b> /mounted-storage/home7/sub001/sc13992-BUGP/vichorse/FUDforum/include/theme/ default/private.inc </b> on line <b>198</b><br />
<br />
<b>Warning</b>: fread(): supplied argument is not a valid stream resource in <b> /mounted-storage/home7/sub001/sc13992-BUGP/vichorse/FUDforum/include/theme/ default/private.inc </b> on line <b>199</b><br />
<br />

<b>Warning</b>: fclose(): supplied argument is not a valid stream resource in <b> /mounted-storage/home7/sub001/sc13992-BUGP/vichorse/FUDforum/include/theme/ default/private.inc </b> on line <b>200</b><br />
FATAL ERROR: system has ran out of disk space<br>

The messages directory is now basically empty so all forums come up with message titles, but blank content.

Now can anybody help:
1: I don't suppose the compact process made temporary copies in some non-obvious location? Any other recovery tips?

2: I am using a cheap host, so I am not optimistic about getting a recent backup (or perhaps any backup). If I get an old one, is there a way to bring the DB into sync with what I actually have in message files? The consistency checker does not seem to have a problem with there being 1000s of messages in the DB but no message files, so I get fseek errors when trying to view pages. If I have no backup, I can probably just truncate some tables, but if I get a partial recovery, it would be nice not to have to do too much risky manual tinkering.

3: It should not have happened. Despite the error message, I don't think the system was out of disk space. Even if it was, deleting all message files should not be the outcome. If one failed, the others should not have been attempted. If the compaction process is risky (which it clearly is at least in my particular case) how about a warning to make a backup before running it?

As you might imagine, I am fairly disappointed by this. I would appreciate any help you can give me before 300 people beat down my door wanting to know what happened to their messages.
[Message index]
Read Message
Read Message
Read Message
Previous Topic: Banned user keeps coming back
Next Topic: Mass emails do not include recipients' email address
Goto Forum:

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 10 14:22:38 EDT 2021

Total time taken to generate the page: 0.00740 seconds