TYPO3 Core

I have catched following Exception while xdebug:

An exception occurred while executing 'ALTER TABLE `tt_address` ADD `uid` INT AUTO_INCREMENT NOT NULL':
Incorrect table definition; there can be only one auto column and it must be defined as a key

Seems that PRIMARY KEY is missing in TYPO3 generated Query:

Query TYPO3: (breaks)
ALTER TABLE `tt_address` ADD `uid` INT AUTO_INCREMENT NOT NULL

Query Adminer: (works)
ALTER TABLE `tt_address` ADD `uid` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
ALTER TABLE `tt_address` ADD `uid` int NOT NULL AUTO_INCREMENT PRIMARY KEY;

OK dear. The row "ALTER TABLE `tt_address` ADD `uid` INT AUTO_INCREMENT NOT NULL" can only work within a CREATE TABLE statement like:

CREATE TABLE `tt_address` (
`tx_maps2_uid` INT NOT NULL,
`uid` INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY `uid`(`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

But not if table tt_address already exists (maps2) without an UID column.

I would prefer you to add PRIMARY KEY to all UID ALTER statements.

Stefan

For now I will try to add column UID in ext_tables.sql of maps2.

Ok... I have found a solution for me. I have added following part in to maps2 Override:

    // ctrl-part has to be present, so TYPO3s DefaultTcaSchema::getPrioritizedFieldNames will create uid and pid
    if (!is_array($GLOBALS['TCA']['tt_address']['ctrl'])) {
        $GLOBALS['TCA']['tt_address']['ctrl'] = [];
    }

This is needed to get a valid table with auto_increment and primary key, as auto_increment can currently NOT be added, if table already exists and does not have UID column.