Actions
Bug #105502
open
DB analyzer fails to add uid field to MM table
Status:
New
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2024-10-26
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
12
PHP Version:
8.2
Tags:
Complexity:
Is Regression:
Sprint Focus:
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;No data to display
Actions