Issue Bug Closed

#17029SQL-Error on MySQL4

Franz Koch 02/23/07, 12:03 updated 03/13/07, 15:18

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.