Actions
Bug #21147
closedt3lib_sqlparser is not able to parse alias of a joined table
Start date:
2009-09-28
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
4.3
PHP Version:
5.2
Tags:
Complexity:
Is Regression:
Sprint Focus:
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
Actions