#17029SQL-Error on MySQL4
Description
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)
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.