Project

General

Profile

Actions

Bug #15348

closed

Invalid argument supplied for foreach() in class.ux_t3lib_db.php

Added by old_pekue almost 19 years ago. Updated over 18 years ago.

Status:
Closed
Priority:
Should have
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2006-01-03
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

while trying to parse the string

(t3ver_oid=9 || uid=9) AND tt_content.deleted=0

t3lib_sqlparser::parseWhereClause encounters an error and returns a string.
ux_t3lib_DB::_quoteWhereClause expects an array as first parameter and dies therefore with "Invalid argument supplied for foreach() in /var/www/xxxxxxxx/typo3/sysext/dbal/class.ux_t3lib_db.php on line 957"

$TYPO3_CONF_VARS['EXTCONF']['dbal']['handlerCfg'] = array (
'_DEFAULT' => array (
'type' => 'native',
)
);
(issue imported from #M2162)

Actions #1

Updated by Karsten Dambekalns almost 19 years ago

This is caused by the use of non-ANSI SQL. || is a concatenation operator, not the same as OR. If you use
(t3ver_oid=9 OR uid=9) AND tt_content.deleted=0
it works fine.

Actions

Also available in: Atom PDF