TYPO3 Core

I was installing the newest version of Typo3 (version 4.1.5) and could not understand why the admin user wasn't created until I found out that the following setting in the my.ini setup file for MySQL caused the problem:

1. Set the SQL mode to strict
   sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

There are several fields in the be_user table which doesn't have a default value, and hence inserting the admin user record in this table kept failing.

I am very new to Typo3 and probably not the right one to submit any fix for a problem this size, because I created a user record manually based on the information I could get by enabling the sql error tracer and when I logged into Typo3 I got another database related error for the be_session table.

I updated my.ini commenting out the sql-mode setting and now everything works as expected.

I am running Typo3 on Apache/2.2.3 (Win32) PHP/5.2.1-dev mod_mono/1.1.17 on my Window XP Professional with a MySQL database version 5.0.15-nt.
(issue imported from #M7091)