[TYPO3-dev] TCA select problem

[Hannes Lau]

On 29.05.17 09:51, devweb wrote:
> Hi,
> I've got a select in my TCA :
>
> 'owner' => array(
>            'exclude' => 1,
>            'label' => 'my label',
>            'config' => array(
>                'type' => 'select',
>                'renderType' => 'selectSingle',
>                'foreign_table' => 'fe_users',
>                'minitems' => 0,
>                'maxitems' => 1,
>                'wizards' => array(
>                    'suggest' => array(
>                        'type' => 'suggest'
>                    ),
>                ),
>            ),
>        ),
>
> The problem is my fe_users table contains more than 36000 users and i've
> got a "Fatal error: Allowed memory size" how can i solve that ? I try to
> put an input with a wizard type "suggest" but input just show the id and
> not the user's name and select a value in then wizard don't put it in
> the input field.


Maybe you could switch to a 'group' field.

https://docs.typo3.org/typo3cms/TCAReference/ColumnsConfig/Type/Group.html

Regards,
Hannes