Project

General

Profile

Actions

Bug #16508

closed

DBAL, Parser Problem

Added by old_drindt over 17 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Should have
Category:
Communication
Target version:
-
Start date:
2006-08-30
Due date:
% Done:

0%

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

Description

The following Query told me the debug backtrace isn't valid:

SELECT uid AS sqlRet
FROM fe_users
WHERE
CONCAT (',',usergroup,',') LIKE '%,2,%' AND disable=0

this query is builded through:
$res=$GLOBALS['TYPO3_DB']->exec_SELECTquery("uid AS sqlRet","fe_users","CONCAT (',',usergroup,',') LIKE '%,{$uidLodge},%' AND disable=0");

The problem results from the space between "CONCAT" and the following bracket.
if i correct the code above to:
$res=$GLOBALS['TYPO3_DB']->exec_SELECTquery("uid AS sqlRet","fe_users","CONCAT LIKE '%,{$uidLodge},%' AND disable=0");

then works fine. I have tried some other sql functions but currently only the concat seems to be affected.

(issue imported from #M4123)

Actions

Also available in: Atom PDF