Actions
Bug #90127
closedambiguous column name title when editing content elements
Status:
Closed
Priority:
Should have
Assignee:
Category:
DataHandler aka TCEmain
Target version:
Start date:
2020-01-16
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
10
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
When editing content elements, the following error is displayed when using sqlite:
Database Error
SQLSTATE[HY000]: General error: 1 ambiguous column name: title. A SQL error occurred. This may indicate a schema mismatch between TCA and the database. Try running database compare in the Install Tool.
This comes from fe_group field, where no sorting is defined. TYPO3 will add the ordering from CTRL section of foreign table without prefixing the table name.
In combination with pages, this results into "ambiguous column name: title":
SELECT "fe_groups"."uid", "fe_groups"."title", "fe_groups"."hidden" FROM "fe_groups", "pages" WHERE ( 1=1) AND ("pages"."uid" = "fe_groups"."pid") AND (("fe_groups"."deleted" = 0) AND ("pages"."deleted" = 0)) ORDER BY "title" ASC
Actions