TYPO3 Core

When the flag 'Enable extensions without review (basic security check)' is activated there are no search results in the EM. In a small debug-session I found out that the a SQL-statement is not compatible with my MySQL 4.1.4 installation. It all worked with RC1, so I suppose the bug is due to the latest changes from Karsten. To make it work with MySQL4 again, the term only has to be in brackets - see below.

PS: I hope that I categorized this report correctly as blocker for 4.1

In class.em_xmlhandler.php line 74:

----Current - not working----
$where.= ' AND NOT reviewstate < 0';
-------------------------------------

----working----------------------
$where.= ' AND NOT (reviewstate < 0)';
-------------------------------------
(issue imported from #M5055)