Bug #17968
closed
Strict sql-mode setting prevents creation of admin user in install tool
0%
Description
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:
- 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)
Updated by Thomas Bindzus over 16 years ago
Sorry I guess being new to this bug tracking system also means making some mistakes! I have seen several issues reported related to the strict setting.
What I don't understand is why an updated tables.sql which I was able to find attached to one of the other issues has not become a part of the 4.1.5 which I have just downloaded, since it was reported for version 4.0.
Updated by Steffen Heinrich over 16 years ago
This is bug http://bugs.typo3.org/view.php?id=4693
I am also new to typo3, but I think that it is not so easy, and that there are probably many more related spots of less exposure waiting to be fixed.
(and, you should probably have taken a look at the "View Issues" page before opening a new ticket)
Updated by