TYPO3 Core

When installing from scratch typo3 4.0.4 with mysql 5, the creation of the admin user fails silently (and is being reported as sucessful : why not display a mysql_error() when the request fails ?). After enabling mysql logging, I was able to capture the create admin query which is in my case :
INSERT INTO be_users
(
username,
password,
admin,
uc,
fileoper_perms,
tstamp,
crdate
) VALUES (
'hyptique',
'5f756609613af47ba8ef6808695f77c7',
'1',
'',
'7',
'1166784931',
'1166784931'
)

I typed into phpMyadmin and the request fails with the following error :
#14916 - Field 'usergroup' doesn't have a default value

Now if you look at the table definition created from the install tool, you will notice the field 'usergroup' (which is not present into the create admin query thus falls back to default value) is specified as NOT NULL and doesn't have a default value.

The same goes for many other fields in the be_users table.

(issue imported from #M4691)