Known issue with MySQL 5 default install

[Joel]

Today, i came across an issue that affects, but is not limited to POG.

MySQL 5 is less lax than mysql4 out-of-the-box. By default the mysql 5
setup installs mysql in "Strict" mode, which among other things, makes
it not accept queries which try to insert empty strings ('') into a INT
or any numeric field.

Thus, POG will most probably *not* work with a default mysql 5 install
unless you turn off the mysql strict mode. To do so:

Open 'my.ini' in your MySQL install folder - the config file. And
comment out the command near the top that turns on the 'strict' mode.

i.e put a # sign in front of this line:
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

This should fix any issues that you may have with MySQL 5. This is
actually a widespread problem with other web apps and scripts out
there, but we'll try to reduce the dependency on non-strict mode in the
next versions of POG...

Hope this helps.

Joel

[Joel]

Oh. and you need to restart mysql after making the change to the
configuration file..

[Joel]

After some more reading, it seems that this only affects Default MySQL
5 install on Windows....

Ok, this is the last message I'll post today.

Joel