Author |
Topic: Database Cruft (Read 1199 times) |
|
James Fingas
Uberpuzzler
Gender: 
Posts: 949
|
William,
You have probably noticed the broken entry in the Medium section. In case you haven't, here's a screen shot (there's no other way to send you a link!). Notice that the URL is broken. It looks like some bad data somehow got into the database.
|
|
 IP Logged |
Doc, I'm addicted to advice! What should I do?
|
|
|
ThudnBlunder
wu::riddles Moderator
Uberpuzzler
The dewdrop slides into the shining Sea
Gender:
Posts: 4489
|
 |
Re: Database Cruft
« Reply #1 on: Nov 25th, 2003, 10:16pm » |
 Quote  Modify
|
And it seems that one can no longer post attachments to that Section either. 
|
|
IP Logged |
THE MEEK SHALL INHERIT THE EARTH.....................................................................er, if that's all right with the rest of you.
|
|
|
towr
wu::riddles Moderator
Uberpuzzler
Some people are average, some are just mean.
Gender:
Posts: 13730
|
|
Re: Database Cruft
« Reply #2 on: Nov 26th, 2003, 12:17am » |
Quote Modify
|
hmm.. I can now only see/access one thread in the what am I section..
It seems like the problem is getting worse..
|
|
IP Logged |
Wikipedia, Google, Mathworld, Integer sequence DB
|
|
|
william wu
wu::riddles Administrator
Gender:
Posts: 1291
|
|
Re: Database Cruft
« Reply #4 on: Nov 26th, 2003, 1:33am » |
Quote Modify
|
The attachment problem is now fixed. My webspace had gone over quota, so the system crapped out when you tried to write a new file. Normally I'd be aware of how I'm doing with respect to the quota, but apparently a 13 mb core dump file was recently generated in my YaBB directory, and this unexpected large chunk of data caused the quota excession.
With regards to the seemingly lost What Am I threads, I have a backup of the forum from November 14th. So never fear, most content will be restored eventually -- I probably won't restore it until the mystery thread in the medium forum is resolved.
Edit 2:04 AM 11/26/2003: The thread files were not deleted. Instead, somehow the file which lists which threads should be displayed in the What Am I forum got modified. This is an easy fix, but I opt to restore it later for debugging reasons.
|
| « Last Edit: Nov 26th, 2003, 2:08am by william wu » |
IP Logged |
[ wu ] : http://wuriddles.com / http://forums.wuriddles.com
|
|
|
william wu
wu::riddles Administrator
Gender:
Posts: 1291
|
|
Re: Database Cruft
« Reply #5 on: Nov 26th, 2003, 10:08pm » |
Quote Modify
|
Turned to not be an easy fix, but in any case, the bad data has been removed, and all threads have been recovered (apparently the easy, medium, and hard section had recently lost hundreds of threads.)
There were a handful of threads for which YaBB could not determine which forum they belonged to. I had YaBB move these threads to a temporary new board titled "Orphan Threads". I was able to move most of these orphan threads back to their original locations by using either content inspection, my memory, or backup files from yesterday. However, there are a few orphan threads for which I don't know where they used to be. If you know where one of these threads belonged, just post to that thread, and a moderator or myself will eventually move it accordingly. Your help will be most appreciated. (And if you're a moderator and remember where the thread was, feel free to just move it.)
|
|
IP Logged |
[ wu ] : http://wuriddles.com / http://forums.wuriddles.com
|
|
|
|
RIDDLES SITE
WRITE MATH!
Home 
Help 
Search 
Members 
Login 
Register
Reply
Notify of replies
Send Topic
Print