Issue Feature Closed

#17372t3lib_pageSelect::enableFields not usable with table Aliases

Stefan Aebischer 06/11/07, 11:42 updated 06/15/15, 10:26

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)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.