Issue Bug Closed

#21147t3lib_sqlparser is not able to parse alias of a joined table

Xavier Perseguers 09/28/09, 21:47 updated 08/06/10, 13:26

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)

Reviews 0

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