Project

General

Profile

Actions

Bug #16508

closed

DBAL, Parser Problem

Added by old_drindt about 18 years ago. Updated about 6 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 about 18 years ago

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

Actions #2

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.

Actions #3

Updated by Benni Mack about 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF