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 #1

Updated by Franz Holzinger over 17 years ago

Which DBAL driver did you use?
Which file of code did you correct?

Actions #2

Updated by Chris topher about 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.

Actions #3

Updated by Benni Mack over 5 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF