Issue Bug Accepted Quiet

#105502DB analyzer fails to add uid field to MM table

Franz Holzinger 10/28/24, 17:03 updated 11/01/26, 07:17

Description

The DB analyzer adds a field ‘uid’ to a MM table. However this always fails with error messages
:

Database update failed.

Error: Incorrect table definition; there can be only one auto column and it must be defined as a key

Error: Key column “uid” does not exist in table

ALTER TABLE `tx_mbiproductscategories_mm` ADD `uid` INT UNSIGNED AUTO_INCREMENT NOT NULL

Solution: (by Garvin Hicking)

ALTER TABLE tx_mbiproductscategories_mm ADD COLUMN uid INT UNSIGNED AUTO_INCREMENT PRIMARY KEY;

Select Tree for tt_products category

Slack

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.

Fix this issue

Start the commit message of your patch with this. Add what the patch does, and the versions it goes to in "Releases:". How to create a patch

Commit message
[BUGFIX] DB analyzer fails to add uid field to MM table Resolves: #105502 Releases: main

History 1

  1. Georg Ringer commented and changed status New Accepted TYPO3 Version 12 14 <span data-processor="relativetime" data-value="2026-11-01T07:17:59+00:00" > 11/01/26, 07:17 </span>

    still valid