TYPO3 Core

Sorry I've forgot something.
This error only comes if I create a new record. If I press the save Button or edit an existing record then comes no error.
Maybe the "###REC_FIELD_sys_language_uid###" marker is not set correctly if
- the record is not saved
- maxitems is 1

Hi,

i found a workaround - I use this expression:
CAST

So if the marker is empty it will be converted to 0

Hi Steffen,

your workaround sounds good.

Is the cast expression standard sql?

A while ago I created a patch for the 4.1 branch.
Maybe the patch is of help.

I have added patches for trunk (4.3), 4.2 and 4.1 which correct the odd situation.

As mentioned in my note from 2008-04-30 this can easily be fixed with the patches attached.

This odd situation does only appear if you use a ###REC_FIELD_*### marker inside the foreign_table_where configuration.

$TCA['tx_faqs']['columns']['similar_faq']['config']['foreign_table_where'] = ' AND tx_faqs.deleted=0 AND tx_faqs.pid IN (103) AND tx_faqs.sys_language_uid=###REC_FIELD_sys_language_uid### ORDER BY tx_faqs.question ASC'

The example above would only list other records if they have the same sys_language_uid which keeps the list smaller if you have more than 2 languages on your TYPO3 installation.

Unassigning the issue from myself.