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

[Sebastian Michaelsen]

Am 09.08.10 10:30, schrieb 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.
>

At the moment I can not think of why reading the variable 
$dblist->counter can cause an SQL-Error. But I'll test it this evening.

Thanks for your review.