Project

General

Profile

Actions

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

Also available in: Atom PDF