CODEWITHSUNDEEP
typo3extbasetypo3-7.6.x
Chi
Chi

Reputation: 1410

Typo3 7: memory limit exceeded in backend

I have 2 database tables: 

tx_pg_domain_model_item
fe_groups

It is possible to assign various groups to an item, so in my TCA for tx_pg_domain_model_item it looks something like this: 

    'groups' => array(
        'exclude' => 1,
        'label' => 'groups',
        'config' => array(
            'type' => 'select',
            'renderType' => 'selectMultipleSideBySide',
            'foreign_table' => 'fe_groups',
            'MM' => 'tx_pg_item_groups_group_mm',
            'size' => 5,
            'minitems' => 0,
            'maxitems' => 9999,
        ),
    ),

The problem is, there are a lot of groups and so as the database grew bigger and bigger recently trying to edit an item in the backend no longer worked. I looked at the errorlog and it says this: 

PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted

now my question is: is there another way to do this to make this work? Some kind of lazy loading maybe or can you guys think of any other alternative?

Upvotes: 0

Views: 1052

Answers (2)

Ashish Patel
Ashish Patel

Reputation: 1031

You have to increase your php memory_limit into your php.ini file. for eg.

; Old Limit
; memory_limit = 512M

; New Limit
memory_limit = 1048M

then again restart your apache server.

Upvotes: 0

Thomas Löffler
Thomas Löffler

Reputation: 6174

You should better use group instead of select.

select loads all fe_users while loading your form in the backend. If you have too much users, there will be this memory fatal error.

Upvotes: 1

Related Questions