| Help! Data loss - message files. [message #28760] |
Thu, 10 November 2005 02:42  |
tangledweb
Messages: 9
Registered: November 2005
Karma:
|
Junior Member |
|
|
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.
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]