Issue Bug Closed

#16508DBAL, Parser Problem

old_drindt 08/30/06, 14:31 updated 10/02/18, 12:33

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)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.