Bug #17029

SQL-Error on MySQL4

Added by Franz Koch almost 13 years ago. Updated over 12 years ago.

Status:
Closed
Priority:
Should have
Category:
Extension Manager
Target version:
-
Start date:
2007-02-23
Due date:
% Done:

0%

TYPO3 Version:
4.1
PHP Version:
5.0
Tags:
Complexity:
Is Regression:
Sprint Focus:

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)

0005055.patch View (860 Bytes) Administrator Admin, 2007-02-24 12:32


Related issues

Related to TYPO3 Core - Bug #17033: Unabble to install extentions Closed 2007-02-23

History

#1 Updated by Oliver Hader almost 13 years ago

The attached patch should solve this problem.

#2 Updated by Franz Koch almost 13 years ago

thanks for creating the patch

#3 Updated by Sudara Williams - almost 13 years ago

Thanks for tracking this down, it's definitely a blocker and your fix solved it for me.

sudara

#4 Updated by Staffan Ericsson almost 13 years ago

Can confirm it. And the patch works.

#5 Updated by Oliver Hader almost 13 years ago

Committed to Trunk.

Also available in: Atom PDF