Bug #19239
closed
Cannot log in to backend
0%
Description
A few months ago we upgraded to Typo3 version 4.2 and everything was okay.
Last week we upgraded our MySQL server from 5.0 to 5.1 and now I cannot log in to the backend. I was able to log in with MySQL 5.0 and Typo3 4.2.
Also, the website displays properly so it is accessing the database for that at least.
(issue imported from #M9203)
Updated by Rob Vonk over 15 years ago
Do you have more than one BE user? None works?
Can you create a new Admin user from the install tool?
Updated by Rob Vonk over 15 years ago
Or could it be that it's duplicate of this?
Updated by Brian Lamb almost 15 years ago
We were able to solve this by adding the following the to localconf.php file:
$TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET SESSION sql_mode=MYSQL40;'.chr(10).'SET NAMES utf8;';
Updated by Chris topher about 14 years ago
Setting sql-mode=MYSQL4 solves this problem. You can do so in in the my.ini of mysql or in the TYPO3 Install Tool using $TYPO3_CONF_VARS['SYS']['setDBinit'].
Resolved as duplicate of #15295.
Updated by