- Joined
- Apr 24, 2013
- Messages
- 1,685
- Reaction score
- 1,133
Especially people who run a Europian server or host their hotel on their Europian PC/Laptop have the problem that furniture doesn't keep it's place where it's stacked once a room is reloaded. There can be two factors which cause this problem:
1. Your MySQL is in strict mode. (causes TRUNCATED errors)
2. Your decimal notation is a , instead of a .
So how the 2@(*&*(# are we going to solve this issue? Well, it's pretty simple.
1. Run this SQL in your database:
And restart your MySQL and emulator. After you've done this, you should check if it worked!!!11!!
Run this SQL in your database:
If your result looks something like
If it didn't, then continue with reading this step.
Go to C:\Program Files\MySQL\MySQL Server 5.1 and click on the my.ini file. Hit CTRL+F and search for 'sql-mode'. It should come up with:
Change that to:
Hit save, restart your MySQL and your emulator and you're fine!
2. Go to start -> Control panel ->
Restart your WEBSERVER (not your whole server, no no no, that’s not necessary) and your emulator and you’re done.
(This is not going to affect the language your keyboard is set to or your Windows is set to)
I hope this was a helpful tutorial for you guys, if you need some extra help, make sure to leave a reaction!
1. Your MySQL is in strict mode. (causes TRUNCATED errors)
2. Your decimal notation is a , instead of a .
So how the 2@(*&*(# are we going to solve this issue? Well, it's pretty simple.
1. Run this SQL in your database:
PHP:
SET @@global.sql_mode = '';
Run this SQL in your database:
PHP:
SELECT @@global.sql_mode;
You must be registered to see links
, you're allright, YEAH YEAH YEAH.If it didn't, then continue with reading this step.
Go to C:\Program Files\MySQL\MySQL Server 5.1 and click on the my.ini file. Hit CTRL+F and search for 'sql-mode'. It should come up with:
PHP:
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
PHP:
sql-mode="NO_STRICT_TRANS_TABLES, NO_ENGINE_SUBSTITUTION"
2. Go to start -> Control panel ->
You must be registered to see links
->
You must be registered to see links
(some servers may call it Region & Language) -> Set the
You must be registered to see links
.Restart your WEBSERVER (not your whole server, no no no, that’s not necessary) and your emulator and you’re done.
(This is not going to affect the language your keyboard is set to or your Windows is set to)
I hope this was a helpful tutorial for you guys, if you need some extra help, make sure to leave a reaction!