Bug #15601

class.t3lib_befunc uses wrong sql statement

Added by Christian Welzel almost 15 years ago. Updated over 14 years ago.

Status:
Closed
Priority:
Should have
Category:
-
Target version:
-
Start date:
2006-02-09
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.0
PHP Version:
4
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

... in line 3459:
list($count) = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows('count(*)','sys_refindex','1');

this must be
list($count) = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows('count(*)','sys_refindex','1=1');

or else errors occur in postgresql.

(issue imported from #M2528)

#1

Updated by Christian Welzel almost 15 years ago

And the second failure is, that the if statement checks for "if (!$count['count(*)'])", but postgres returns only "count" as result row name.
so the comparions does fail although 1760 is returned.

so please give a proper name to "count()" ! eg. "count() AS count".

Also available in: Atom PDF