Actions
Bug #16508
closedDBAL, Parser Problem
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