Plus Emulator R2 Solve UPDATE sql

[HardBest]

How to solve? :/

 

[Jerry]

Disable strict mode.

Run this query:

SET sql_mode = '';

Reboot emulator and you're good to go!

 

[Central]

Disable strict mode.

Run this query:

SET sql_mode = '';

Reboot emulator and you're good to go!

Or you can disable it fully as this just only activated strict mode again when you restart your vps.

To disable it fully, here's the steps:

Step 1: Go to C:/Program Files/MySQL/my.ini
Step 2: Locate "sql-mode"
Step 3: It looks like: sql-mode="NO_AUTO_***********"
Step 4: Remove everything in the speech marks so it then looks like this: sql-mode=""
Step 5: Save the Document then close it
Step 6: Right click the start menu and click "Command Prompt (Admin)
Step 7: Type: net stop MySQL
Step 8: Type: net start MySQL
And now sql will never be in strict mode!

 

[Anglo]

Or you can take a look at the screenshot and see it's trying to update the exit_timestamp with the value 1499739649,7621 - it's using a comma not a decimal, their set decimal is wrong.