Issue Bug Closed

#12378Error with JOIN in new extension manager

Steffen Kamper 01/19/11, 21:05 updated 12/13/14, 23:41

Description

When i have the repository list and click without searching on column “Relevance” i get the following fatal error from DBAL:

DBAL fatal error: No handler found in handler_getFromTableList() for: "cache_extensions INNER JOIN (SELECT *, MAX(intversion) AS maxintversion FROM cache_extensions GROUP BY extkey) AS cache_extensions2 ON cache_extensions.extkey = cache_extensions2.extkey" (SQL engine parse ERROR: No join table found in parseFromTables()!: near "(SELECT *, MAX(intversion) AS maxintversion FROM c")

It’s obvious that DBAL expects tablename for the JOIN, but it’s a subquery.
I think this is the first part in core where such subquery is used :)

Reviews 0

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