Project

General

Profile

Actions

Bug #90127

closed

ambiguous column name title when editing content elements

Added by Daniel Siepmann over 4 years ago. Updated about 4 years ago.

Status:
Closed
Priority:
Should have
Category:
DataHandler aka TCEmain
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

Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #70677: Sorting of foreign records in TCA type selectClosed2015-10-14

Actions
Actions #1

Updated by Daniel Siepmann over 4 years ago

  • Assignee set to Daniel Siepmann
  • Target version set to Candidate for patchlevel
Actions #2

Updated by Gerrit Code Review over 4 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

Actions #3

Updated by Gerrit Code Review over 4 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

Actions #4

Updated by Gerrit Code Review over 4 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

Actions #5

Updated by Gerrit Code Review over 4 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

Actions #6

Updated by Benni Mack over 4 years ago

  • Related to Bug #70677: Sorting of foreign records in TCA type select added
Actions #7

Updated by Gerrit Code Review over 4 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

Actions #8

Updated by Daniel Siepmann over 4 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #9

Updated by Benni Mack about 4 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF