x
ChatBox

Please log in with password to access chatbox.
visitor stats
Index | Back | Reply | New Topic

Help

Minicity isn't working
2009-07-23 20:00
repentignyHi

I stopped receiving visits to my city today, and when I try to go to another city I get this Error message on the city page:

INSERT INTO CityEvent (date,type,cityId) VALUES ('2009-07-23 21:58:48', 'birth', 1700390) Duplicate entry '2147483647' for key 1

Am I the only one?

thanks for helping me
2009-07-23 20:06
repentignyI saw in the chatbox that a lot of people have the same problem... I guess it's not my computer.

Sorry for the post
2009-07-23 22:26
DanHello.

I am afraid it is every mmc that is having the problem.

Keep looking at your city to see if the problem is soved.

Dan
2009-07-24 02:47
EkkythumpDoes anyone actually know the reason for these errors? Is there any word from Motion Twin about it? As Ceymore says in the chatbox, the French version is working fine. It is just Myminicity that is not working. I do not know about their other games because I do not want to play them.
Does anyone have a hotline to Motion Twin?
2009-07-24 22:45
EkkythumpI have been given this useful insight by a colleague:


To a computer geek, the reason is clear. If you look at the message, you will spot:
Duplicate entry '2147483647' for key 1

That large number is 2 to the power 31 -1, or in other words, the largest number you can store in a 32-bit database field. The MMC people evidently didn't think they would reach 2 billion views, but they have.

The easiest fix would be to increase the field width to 64 bits, which would increase the highest number to 9223372036854775807 - over 4 billion times higher. The trouble is that they will probably have to re-write a lot of their code to incorporate the change, to say nothing of how long it will take their database to make the change.
2009-07-24 23:50
Jasainthis stinks I hope they fix it!
2009-07-31 00:23
FredIs Mini City not working again or am I the only unlucky one?