Project

General

Profile

Actions

Bug #16652

closed

mysql_fetch_assoc If in tca select->maxitems > 1 AND foreign_table_where contains "sys_language_uid = ###REC_FIELD_sys_langu...

Added by Sascha Egerer over 17 years ago. Updated over 10 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2006-10-18
Due date:
% Done:

0%

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

Description

I have createt an extension. When I write the following in the tca.php File I get the an error:
"config" => Array (
"type" => "select",
"foreign_table" => "xxx",
"foreign_table_where" => "AND xxx.sys_language_uid = ###REC_FIELD_sys_language_uid### ORDER BY xxx.name",
"maxitems" => 100,
....
)

I get this error if I create a record of this type:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in xxx/htdocs/typo3_src-4.0/t3lib/class.t3lib_db.php on line 801

The error comes only if "###REC_FIELD_sys_language_uid### " is in the "foreign_table_where" AND "maxitems" is higher then 1.
If I set "maxitems" = 1 or I delete the part "AND xxx.sys_language_uid = ###REC_FIELD_sys_language_uid###" the error does not come.

(sorry if my english is not so good.... ;-) )

(issue imported from #M4405)


Files

rec_field.patch (1.04 KB) rec_field.patch Administrator Admin, 2008-04-30 12:02
TYPO3_4-1-rec_field.patch (1.08 KB) TYPO3_4-1-rec_field.patch Administrator Admin, 2009-07-03 10:21
TYPO3_4-2-rec_field.patch (1.21 KB) TYPO3_4-2-rec_field.patch Administrator Admin, 2009-07-03 10:22
TYPO3_trunk-rec_field.patch (1.21 KB) TYPO3_trunk-rec_field.patch Administrator Admin, 2009-07-03 10:22

Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Feature #17500: Localization of child recordsClosedOliver Hader2007-08-06

Actions
Actions

Also available in: Atom PDF