Bug #16508
closedDBAL, Parser Problem
0%
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)
Updated by Franz Holzinger about 18 years ago
Which DBAL driver did you use?
Which file of code did you correct?
Updated by Chris topher over 14 years ago
Not enough information on what was fixed and how.
Since there were now four years without any further feedback we should close this one out.