[TYPO3-core] RFC #13942: Hiding Option Checkboxes and search fields on "empty" list view does not work

[Jigal van Hemert]

On 8-8-2010 0:10, Sebastian Michaelsen wrote:
> Solution:
> Use $dblist->counter instead to determine if there were any tables
> rendered.

This introduces the following side effect:

When you log into the backend and start the List module without 
selecting a page (the page tree is only available *after* starting the 
List module) this error appears at the bottom:

exec_SELECTquery
caller 	t3lib_DB::exec_SELECTquery
ERROR 	You have an error in your SQL syntax; check the manual that 
corresponds to your MySQL server version for the right syntax to use 
near ') AND (personal=0 OR cruser=2) AND sys_note.deleted=0' at line 1
lastBuiltQuery 	SELECT * FROM sys_note WHERE pid IN () AND (personal=0 
OR cruser=2) AND sys_note.deleted=0
debug_backtrace 	SC_db_list->main#448 // 
recordList->showSysNotesForPage#400 // t3lib_DB->exec_SELECTquery#366 // 
t3lib_DB->debug#259

After reverting the patch the error was gone (as it was before applying 
the patch)

-1 by testing with trunk for now.

-- 
Jigal van Hemert
skype:jigal.van.hemert
msn: jigal at xs4all.nl
http://twitter.com/jigalvh