Project

General

Profile

Actions
Copy link

Feature #17372

closed

t3lib_pageSelect::enableFields not usable with table Aliases

Added by Stefan Aebischer over 17 years ago. Updated over 9 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2007-06-11
Due date:
% Done:

0%

Estimated time:
PHP Version:
4.3
Tags:
Complexity:
Sprint Focus:

Description

Right now its not possible to use a table alias like " SELECT * FROM tt_content AS c ..." in combination with the method enableFIelds.

because the query will result in something like this:

"SELECT * FROM tt_content AS c WHERE ... AND tt_content.deleted = 0 .."

This query will result in the SQL errror:
"ERROR 1109: Unknown table 'tt_content' in where clause"

added a patch
(issue imported from #M5770)

Files

enableFieldsTableAlias.diff (3.2 KB) enableFieldsTableAlias.diff Administrator Admin, 2007-06-11 11:42
Actions
Copy link
 #1

Updated by Simon Schaufelberger almost 13 years ago

  • Target version deleted (0)

this is a must have!

check in the function for the TCA of the table but use the alias in the sql.

Actions
Copy link
 #2

Updated by Alexander Opitz almost 10 years ago

  • Description updated (diff)
  • Status changed from New to Needs Feedback

Hi,

does the problem still exists within newer versions of TYPO3 CMS (6.2.9)?

Actions
Copy link
 #3

Updated by Alexander Opitz over 9 years ago

  • Status changed from Needs Feedback to Closed

No feedback within the last 90 days => closing this issue.

If you think that this is the wrong decision or experience this issue again, then please write to the mailing list typo3.teams.bugs with issue number and an explanation or open a new ticket and add a relation to this ticket number.

Actions
Copy link

Also available in: Atom PDF