Bug #90127
closedambiguous column name title when editing content elements
100%
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
Updated by Daniel Siepmann almost 5 years ago
- Assignee set to Daniel Siepmann
- Target version set to Candidate for patchlevel
Updated by Gerrit Code Review almost 5 years ago
- Status changed from New to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/62927
Updated by Gerrit Code Review almost 5 years ago
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/62929
Updated by Gerrit Code Review almost 5 years ago
Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/62929
Updated by Gerrit Code Review almost 5 years ago
Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/62929
Updated by Benni Mack almost 5 years ago
- Related to Bug #70677: Sorting of foreign records in TCA type select added
Updated by Gerrit Code Review almost 5 years ago
Patch set 1 for branch 9.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/62937
Updated by Daniel Siepmann almost 5 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset c2b99dd9fbada3ce4b5d0adc367190086985b62a.