Project

General

Profile

Actions

Bug #17968

closed

Strict sql-mode setting prevents creation of admin user in install tool

Added by Thomas Bindzus almost 17 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Should have
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2008-01-06
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.1
PHP Version:
5.2
Tags:
Complexity:
Is Regression:
Sprint Focus:

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:

  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)


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #80035: Strict MySQL sql_mode breaks workspacesClosed2017-02-27

Actions
Actions #1

Updated by Thomas Bindzus almost 17 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.

Actions #2

Updated by Steffen Heinrich almost 17 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)

Actions #3

Updated by Benni Mack about 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF