TYPO3 Core

Matthias Eberlein wrote:

Hello TYPO3 People,
after a git pull TYPO3_6-1 i get in INSTALL TOOL DB Compare this db table error.

ALTER TABLE be_users CHANGE userMods userMods text;
Current value: varchar(255) default NULL

CREATE TABLE ( ( categories int(11) NOT NULL default '0' );

then Compare get the db error

CREATE TABLE ( ( categories int(11) NOT NULL default '0' );
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( ( categories int(11) NOT NULL default '0' )' at line 1

I think that have somthing to do with this [BUGFIX] be_users.userMods is too small to hold all modules https://review.typo3.org/#/c/20885/

greetings
matthias

Tested on 2 Systems. One fresh Installation without any Installed Not System Extension.

I have this issue in 6.1.1-dev but not in 6.2-dev

The problem is that $GLOBALS['TYPO3_CONF_VARS']['SYS']['defaultCategorizedTables'] isn't set (or an empty value) so that CategoryRegistry tries to add a category to an empty table name.

In 6.2 this defaults to 'pages,tt_content'

Was introduced with #38972

After a fresh installation of 6.1.1 I had the same problem. Setting $GLOBALS['TYPO3_CONF_VARS']['SYS']['defaultCategorizedTables'] in Install Tool to 'pages,tt_content' helped me. Thx.

Patch set 2 for branch master has been pushed to the review server.
It is available at https://review.typo3.org/20938

Patch set 3 for branch master has been pushed to the review server.
It is available at https://review.typo3.org/20938

Patch set 4 for branch master has been pushed to the review server.
It is available at https://review.typo3.org/20938