[eluser]Bart v B[/eluser]
You can start to modify youre mysql database to tell him that you want to have everything in stric_mode.
Code:
# first we check wich mode..
SELECT @@session.sql_mode;
# change the mode..
SET SESSION sql_mode = 'TRADITIONAL,ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO';
#now we see the new mode..
SELECT @@session.sql_mode;
EDIT if you want to have this mode, you need to modify your my.ini.
First turn mysql off.
Then seach in your my.ini this line:
sql_mode =
Change that to:
sql_mode = TRADITIONAL,ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO
Start the mysql server again.
Now it's alway's the right setting