Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 83 bytes) in /typo3/sysext/core/Classes/Database/DatabaseConnection.php on line 1038 + TYPO3


Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 83 bytes) in /typo3/sysext/core/Classes/Database/DatabaseConnection.php on line 1038 + TYPO3

Some time we are facing the issue of memory size exhausted in typo3 backend.

We are also facing “Allowed memory size of 134217728 bytes exhausted” issue while we save records in backend module.

Like : Edit page content, Powermail field data, News records or any other field data.

We can set memory limit in php.ini file as well. if we are not able to change on server file then we can also manage it from typo3 configuration.

Following script we have to set in “LocalConfiguration.php” OR you can directly set on the Install Tool set.

$TYPO3_CONF_VARS['SYS']['lockingMode'] = 'disable';

If this is not working for you then you can also set “setMemoryLimit” in your LocalConfiguration file.

$TYPO3_CONF_VARS['SYS']['setMemoryLimit'] = '16M';

Ie that 16 MB must use to run the script. Since it can then sometimes happen that the allocated 16 MB are not enough. so we can set it more from LocalConfiguration file and also manage it from install tool.

i hope it will work for you 🙂

If you have any queries, please do not hesitate to contact me at Jainish Senjaliya

Frontend login security level in sr_feuser_registration


 
Front End User Registration (sr_feuser_register): Frontend login security level must be set to “normal” or to “rsa”.

If this error message generated after install “sr_feuser_register” and then you must have to ser configuration in install tool.

Or you can set it directly in localconf.php file

and also In the localconf or in the install tool, the requested value must be entered. The OldMailAPI is set to 0.

$TYPO3_CONF_VARS ['FE'] ['login security level'] = 'normal';     
$TYPO3_CONF_VARS ['MAIL'] ['substituteOldMailAPI'] = '0 ';    

A small stumbling block had crept in: Instead of ‘FE’ was ‘BE’ is entered. The settings look indeed look almost identical.

If you have any queries, please do not hesitate to contact me at Jainish Senjaliya

How to restrict access of TYPO3 backend


 
IF you want to restrict TYPO3 backend side then you have to set below line in your “localconf.php” file.

$TYPO3_CONF_VARS['BE']['IPmaskList'] = 'XXX.X.XXX.XXX,XX.XXX.XX.XXX,XX.XXX.XXX.XX';

XXX.X.XXX.XXX is stand for IP address.

You can set more than one IP address by comma seprated.

If you have any queries, please do not hesitate to contact me at Jainish Senjaliya

How to move typo3 syslog errors to a file?


By default, the frontend errors and backend errors are written to the syslog table. Eventually this table may become a huge one, if we have some javascript errors or something like that which gets added to the table each time we view the web page. So it’ll be better and more manageable when the errors are written to a file rather than storing in the database table. The below configuration steps may help us to do so.

Create a log file on root.
Eg : /var/www/html/domain-name/syserror.log

Update the typo3conf/localconf.php with the following configuration (changes can be made via install tool settings):

    $TYPO3_CONF_VARS['SYS']['displayErrors'] = ’0′;
    $TYPO3_CONF_VARS['SYS']['devIPmask'] = ‘*’;
    $TYPO3_CONF_VARS['SYS']['errorHandler'] = ‘t3lib_error_ErrorHandler’;
    $TYPO3_CONF_VARS['SYS']['errorHandlerErrors'] = 6135;
    $TYPO3_CONF_VARS['SYS']['exceptionalErrors'] = 4341;
    $TYPO3_CONF_VARS['SYS']['debugExceptionHandler'] = ‘t3lib_error_DebugExceptionHandler’;
    $TYPO3_CONF_VARS['SYS']['productionExceptionHandler'] = ‘t3lib_error_DebugExceptionHandler’;
    $TYPO3_CONF_VARS['SYS']['systemLogLevel'] = ’0′;
    $TYPO3_CONF_VARS['SYS']['systemLog'] = ‘file,/var/www/html/domain-name/syserror.log,1′;
    //Location of the error log file
    $TYPO3_CONF_VARS['SYS']['enable_errorDLOG'] = ’1′;$TYPO3_CONF_VARS['SYS']['enable_exceptionDLOG'] = ’1′;
    $TYPO3_CONF_VARS['SYS']['belogErrorReporting'] = ’0′;

Modify the .htaccess file.

    php_flag display_errors off
    php_flag log_errors off
    php_value error_log /var/www/html/domain-name/syserror.log
    #Location of the error log file

via How to move typo3 syslog errors to a file?

If you have any queries, please do not hesitate to contact me at Jainish Senjaliya