Thank you, Kestas.

hey one question...are the games still frozen bc one of my games has been "Due Now" for at least 15 minutes

no, that's normal. once someone recorded a 4-hour "due now", but i'm pretty sure that's the longest without outside bugs. unfortunately, there's a really serious outside bug now, so...

@aoe3rules: stop talking nonsense :-P judge is run every 10 mins or so. the games are stopped now

You know its bad when you need to submit a bug report directly to MySQL :-(
http://bugs.mysql.com/bug.php?id=37849

Maybe they'll point out something obvious, but I really cannot see how this is occurring without there being a MySQL problem. Without a doubt the trickiest bug phpdip has ever faced (and yes this is a result of the server move, I just need to make sure whether it's phpdip making incorrect assumptions or if it's a mysql bug)

> and who here hopes this bug also shows up on playdiplomacy.com

i don't know, i've heard that they are causing the recent problems on our site... :-(

Well, if the bug takes a few days to fix, it would be pretty good timing in the states with the upcoming holiday weekend!! :-)

@alamothe: well without knowing about any bugs. and isn't it normally run every five minutes?

i guess... so how could a game be stuck for four hours??

Since it's a problem with the database I've asked that we get moved back. Hopefully that won't take too long, but I've turned up a few minor bugs while looking for the problem, and wrote some useful game reprocessing code today, so it wasn't a complete waste of time.

ok well i found this website through a friend so i never took the time to look at other websites bc i liked this one a lot and a just wasted my time by taking a look at playdiplomacy. I honestly want to know if anyone else has ever played playdiplomacy and which website that you prefer. It looks so tacky the way the map is set up and what everything looks like.

if anyone is offended by my comments i dont care bc its my opinion and you shouldnt worry about it just post your.

Kestas could it be the versions of PhP and MySQL are different on the two servers and thus some of the coding isn't working as intended?

Now that's a pity. MySQL will not support the (slightly) older version. Not too impressive on their part. At least they could have tried to provide an explanation.

This is the response you got from the mySQL bug report???

"Thank you for the feedback.
I am sorry, but we don't backport bug fixes into previous minor versions. As all works as
expected with current version I close the report."

Lame.

It's not that they won't support the older version, it's that it's poor practice to backport bugfixes within a Major release.

Sure. But if they are aware of the bug and have fixed it in the current release they could at least provide a description. Perhaps a workaround could be proposed or figured out.

Why? That sort of thing should be in the release notes.

The strange thing is it works on .24a, and in fact we're moving back to a .24a server to get things working again. The problem is I think Dreamhost may be "updating" all their servers to .45

The final (hopefully) post on this bug:

The bad news is the server was unusable for 24 hours, and I spent 3 hours looking through the code for a bug not in the code.

The good news is I found a couple of minor unrelated bugs and there's now a cool new reprocess feature which can move any game back any number of turns, and reprocess the orders entered in for any of those turns. This means next time this happens it shouldn't take a full 24 hours to know exactly what's going on.

You may have to re-enter retreats/unit-placing orders which you already entered, and retreats/unit-placing orders you already entered may have been seen by your allies. If any games didn't get reprocessed correctly post the details in this thread

http://www.phpdiplomacy.net/board.php?gameID=4499
I have occupied Spain and now my army moves out of Spain but it is still an independent country.

jopms, it's supposed to work that way. Capture (or hold) it in Autumn if you want to keep it.

I already occupied it in the Spring. I need to capture it twice?

You have to hold a supply center in Autumn if you want to keep it.

I think it's still broken. According to the game I'm in (Bat Country) http://phpdiplomacy.net/board.php?gameID=4235 I have 2 supply centres but in the unit placing phase in Autumn it won't let me place my second unit.

You don't have any available supply centers to place a unit. (In the older version, you'd have to choose the option ('Wait until next build turn') or something like that. Now, if you don't have a place to put the build, you just don't get the option.

(FYI that change was introduced in a patch by thewonderllama, not a new version)

Sorry about my ignorance I'm just a noob here but why can't I build in Venice? There aren't any units there. Austria had it in the spring phase but continued moving his army on to Piedmont.

You can only build in your home supply centers, not in other countries, even if you are currently the owner.