BUG: Clan Market

Post by **Freenhult** » Thu Jun 07, 2007 7:59 pm

11,520 Spearmen purchased from the market for $6,912,076.
FATAL ERROR: Failed to update player data networth=1094412,savings=6566472960 for user #!
7,125 Archers purchased from the market for $8,550,710.
FATAL ERROR: Failed to update player data networth=1353862,savings=8123174880 for user #!

Uh. Right-o

I bought some units from the CM that were there. Either Nohc's or my Vaca'd buddy.

Post by **Devari** » Thu Jun 07, 2007 10:38 pm

Oh bugger. He's actually reached the limit of the database.

Post by **Devari** » Thu Jun 07, 2007 11:02 pm

Let me make it more clear:

Each column of the player table has a maximum number that can be stored in it. The savings column, like the cash and food columns, are unsigned 32-bit integers - which means their maximum value is 2^32 (or something like that). The numbers you quote are over 2^32, so they don't "fit" in the database. Thus, the error message.

There's really no easy fix, to be honest. 2^32 cash (without factoring) is a little silly to have happening anyway.

Out of interest, did you get the troops or not?

Post by **Freenhult** » Fri Jun 08, 2007 12:45 am

Uh. I do not know. I didn't look. ._.

They aren't for sale anymore.

Post by **Gen. Volkov** » Fri Jun 08, 2007 4:27 am

ROFL, that's scary, the boy has so much stored cash, he's broken the database. *laughs*.

Post by **Devari** » Fri Jun 08, 2007 4:57 am

... No, wait, I'm wrong. My mistake, this isn't the limit at all. I saw more figures than there really were. I'll look into it.

Post by **The Beatles** » Fri Jun 08, 2007 4:57 am

No, it SHOULD NOT fail like that. MySQL has a nasty habit of failing silently on those things. This failed loudly. My guess is it is something else.

Post by **Devari** » Fri Jun 08, 2007 4:58 am

Hehe, see above. I just realized it is far less than 2^32.

Post by **Devari** » Fri Jun 08, 2007 4:59 am

Notice that the user # was undefined... Is that a problem with the error message, or does that indicate something else?

Post by **The Beatles** » Fri Jun 08, 2007 5:01 am

omg ur sp33d i$ 1337.

At a guess, bug with the code, but I am not sure. You might try searching for similar strings on this forum in previous posts.

Post by **Freenhult** » Fri Jun 08, 2007 5:19 am

Uh. I bought like 13k mice and 5k Archers. xD For normal prices. I hit no limit.

I think it meant it couldn't update the other persons. >_>

Post by **The Beatles** » Fri Jun 08, 2007 5:20 am

So what changed recently? (Codebase)

Nuclear Raunch · Post by **Nuclear Raunch** » Fri Jun 08, 2007 5:30 am

The Beatles wrote: So what changed recently? (Codebase)

I dunno but whatever the hell it was it sure introduced a whole slew of bugs. We went months without a bug report and now we're lucky to make it a day.

Post by **Ruddertail** » Fri Jun 08, 2007 5:36 am

The only thing I can think of, and I've mentioned this to Dev and Freen, is the account resurrection thing. Until then, nary a bug report. After that, frequent bugs - and almost all centered on WoA, including the nastiest and most persistent ones.

Post by **Freenhult** » Fri Jun 08, 2007 5:38 am

Yes. If this is the case, a reset might be our only hope....

Frost And Flame Forums

BUG: Clan Market

Members connected in real time