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.
-
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
"Object-oriented design is the roman numerals of computing." -- Rob Pike
-
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
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
I tried create a new topic in the bug forum; it fails withloftar 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.
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
-
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
Indeed, I noticed too. It should be fixed now.
"Object-oriented design is the roman numerals of computing." -- Rob Pike
-
theTrav
- Posts: 3464
- Joined: Fri May 29, 2009 11:25 pm
Re: Maintenence: 2009-09-27 01:00 UTC, Web server downtime
Did you by any chance migrate said sql server to a different piece of hardware?