#105502DB analyzer fails to add uid field to MM table
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;
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
-
Georg Ringer commented and changed status
NewAccepted TYPO3 Version1214 <span data-processor="relativetime" data-value="2026-11-01T07:17:59+00:00" > 11/01/26, 07:17 </span>
still valid