Maintenence: 2009-09-27 01:00 UTC, Web server downtime

Announcements about major changes in Haven & Hearth.
User avatar
loftar
Posts: 9096
Joined: Fri Apr 03, 2009 7:05 am
Location: Your character database

Maintenence: 2009-09-27 01:00 UTC, Web server downtime

Post by loftar »

Just to let you know, I'll be migrating the phpBB database from sqlite to MySQL later tonight, and to make sure all database locks are released, I'll need to bring the whole web server down. I won't shut down the game server, so technically, you'll be able to keep playing, but the minimap will stop working (since it's served over HTTP), and if your client needs to download some resource that it hasn't already cached, it will crash and burn.

Hopefully, it won't take long, but who knows. Either way, this fix should improve the forum performance a lot.
"Object-oriented design is the roman numerals of computing." -- Rob Pike
User avatar
loftar
Posts: 9096
Joined: Fri Apr 03, 2009 7:05 am
Location: Your character database

Re: Maintenence: 2009-09-27 01:00 UTC, Web server downtime

Post by loftar »

So there, it seems to be working now, and I think I got all the forum data over as it should be. It wasn't entirely trivial, though, so please tell me if the forum does something unusually strange.
"Object-oriented design is the roman numerals of computing." -- Rob Pike
kobnach
Posts: 671
Joined: Wed Jun 10, 2009 5:04 am

Re: Maintenence: 2009-09-27 01:00 UTC, Web server downtime

Post by kobnach »

loftar wrote:So there, it seems to be working now, and I think I got all the forum data over as it should be. It wasn't entirely trivial, though, so please tell me if the forum does something unusually strange.
I tried create a new topic in the bug forum; it fails with


General Error
SQL ERROR [ mysql4 ]

Field 'topic_id' doesn't have a default value [1364]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

Please notify the board administrator or webmaster: fredrik@dolda2000.com
User avatar
loftar
Posts: 9096
Joined: Fri Apr 03, 2009 7:05 am
Location: Your character database

Re: Maintenence: 2009-09-27 01:00 UTC, Web server downtime

Post by loftar »

Indeed, I noticed too. It should be fixed now.
"Object-oriented design is the roman numerals of computing." -- Rob Pike
User avatar
theTrav
Posts: 3464
Joined: Fri May 29, 2009 11:25 pm

Re: Maintenence: 2009-09-27 01:00 UTC, Web server downtime

Post by theTrav »

Did you by any chance migrate said sql server to a different piece of hardware?

Return to “Announcements”