I’ve submitted the site for Google to take it off the naughty list. We’re just waiting for them at this point.
I was able to cure what was breaking in the forum by upgrading to the latest version of the software. At least, it’s cured as far as I can tell, so I’ve brought it back online.
The hosting company is still working on the server. Something may break again with no warning, especially since I’ve made substantial changes to the site compared to what is in their backup. At least I won’t have to go through several dozen manual database changes again. The automated database update choked on our 220K posts.
From our webhost:
Due to issues with the RAID controller, we have replaced the hardware for this server and we are restoring all data from our backup server to the new hardware. During this process, the data on the backup server will be mounted directly over NFS to allow your hosting services to remain online for the duration of the process.
If you’ve tried to read anything since the server came back online, you know that something isn’t working correctly. I’m going to wait until the restore is finished to look into this; I suspect it will clear itself up at that point.
The database is safe. The problem (a sort of hard drive failure) affected only the server with the program that formats and displays the messages in the database.
There are still quite a few things that aren’t in the right place. Don’t be surprised if the site goes down for a half hour or so of maintenance at random times.
But I think I’ve caught everything that would make it difficult to navigate, read, or post to the new forum. Let me know if something is still whacked. That includes the colors. (The “Post a New Topic” page was showing up as a plain white background with white text boxes and black letters. I’m crossing my fingers that I’ve caught everything like that.)
User names and passwords appear to have come through just fine. I did find an archive with the avatars, but we lost the links between user and avatar. You’ll find them in a gallery called “OldAttic” available in your profile.
Most of your old bookmarks will no longer work, as the new forum uses a completely different post naming scheme.
Not everything is just right yet, so I’m keeping the board offline until I have a chance to fix things like reading and posting permissions. For the moment, though, I’m taking myself and my day-long migraine back to bed. (And yes, I’ve taken drugs. Enough to look over the conversion results and type this up.) More tomorrow, I hope.
This is me the last few days. Emergencies at the office capped by 28 hours straight Thursday and Friday, followed by an attempt at enforcing some detox time. I was mainlining caffeine there for a while, but got the whole mess out the door before I had to switch over to an IV drip. The hands acquire shakes….
Somewhere in there, Invision contacted me about reviewing the conversion results. There are problems, the major one being that the threads came in with the posts in reverse order, so it’s all going back to Invision for a redo. The other major problem, that it at first appears that some fora are missing, is a result of the hack the old forum used to make multi-level categories. The missing fora are simply out of place. I suspect that will end up being fixed by hand, though I’ll ask the conversion guys if there’s a quick fix for it via script. Less major, but still annoying, is that the quote boxes aren’t always rendering. This is something I’ve seen before with IPB and at that time had to do with extraneous newlines and other codes among the quote tags. Might be fixable with a search / replace in the database.
In other news, the avatars are missing in action. That directory in my latest backup ist kaput. I was looking for an older backup to see if I could recover some of them, at least, when all hell broke out at work. Hope everyone still has copies of their avatars handy, because I have more overtime coming up over the next couple of weeks. Half the office is out on vacation next week, which kinda leaves me as ranking noncom and the only one qualified to convince Excel to do calculus.
So I’m going to stop babbling now and try to catch a couple of hours of sleep. More info when I have it.
A quick update on the database conversion. The member data tables have been converted, and the forum tree is mostly in place. (I may have to tweak it a bit before I reopen the forum.) I do still need to find the avatars directory in my last site backup and get that back into place.
I plan to purge the forum list and the member list down to the Attic only once the conversion is complete. We still have a lot of members from the Flat Dereth Society who haven’t visited since that monarchy dissolved several years ago. There were some attempts at adding areas for other games that never got off the ground. If someone is really attached to the handful of posts in, say, the Star Wars Galaxies section, please let me know.
We’re running into memory issues with the conversion, I assume because we’re a very wordy bunch.
We may have to take the site offline to complete the conversion. DO NOT PANIC. </Hawkwind>
In case of sonic attack, er, the site going offline, I will post updates at gamejag.wordpress.com.
Invision has asked for FTP access to our server to begin live testing of the database conversion. I do not have a definite ETA for the beginning of the actual conversion.
Meanwhile, I have a VERY preliminary test site up at ipbtest.gamejag.net. Will those of you with display concerns please let me know if there are problems with the current default skin and theme? I will be testing and tweaking a scheme for moving the novels pages into Drupal in addition to exploring / testing the admin functions, so don’t be surprised if posts, forums, or novels randomly appear and disappear.
Ursula: That address is no longer good. Email me at oystergirl at gamejag.com.