[TYPO3-dam-devel] RFC #9652: Unknown column 'tx_dam.uid' after clicking 'wrong'

[Dan Osipov]

FYI, I'm temporarily withdrawing this patch - it doesn't work as 
desired. I'll see what can be done to resolve the bug.

Dan Osipov
Calkins Media
http://danosipov.com/blog/

Dan Osipov wrote:
> Team,
> 
> This is a SVN patch request.
> Branches: trunk, 1.1
> BT Reference: http://bugs.typo3.org/view.php?id=9652
> http://bugs.typo3.org/view.php?id=11200
> 
> Problem: SQL errors in Info module
> 
> Solution: Error comes from combinations of tables in FROM and a JOIN. So 
> this doesn't work:
> SELECT * FROM t1, t2 LEFT JOIN t3 ON t1.uid=t3.uid
> but this does:
> SELECT * FROM t1 JOIN t2 LEFT JOIN t3 ON t1.uid=t3.uid
> 
> Another error came from including the where clause from previous queries 
> without having the tables in the FROM part of the query.
>