Bug #21147
closed
t3lib_sqlparser is not able to parse alias of a joined table
0%
Description
See bug #17072 for an old problem related to this and more recently, with feeditadvanced, having DBAL installed makes use of Core's SQL parser and gives this error:
DBAL fatal error: No handler found in handler_getFromTableList() for: "sys_lockedrecords AS locks LEFT JOIN be_users AS user ON locks.userid=user.uid" (SQL engine parse ERROR: No join fields found in parseFromTables()!: near "user ON locks.userid=user.uid ")
It could be possible to remove the alias part of the join in the corresponding query ("AS user") and this would work but I find it more useful to make the Core SQL parser a bit more powerful.
(issue imported from #M12071)
Files
Updated by Oliver Hader about 15 years ago
Committed to SVN Trunk (rev. 6082)
Still pending for TYPO3_4-2 and TYPO3_4-1
Updated by Christian Kuhn over 14 years ago
Resolved in 4.3.0beta1
This won't go to 4.1 / 4.2 any longer.