Bug #19239
Cannot log in to backend
| Status: | Resolved | Start date: | 2008-08-20 | |
|---|---|---|---|---|
| Priority: | Should have | Due date: | ||
| Assigned To: | Chris topher | % Done: | 0% |
|
| Category: | - | Spent time: | - | |
| Target version: | - | |||
| TYPO3 Version: | 4.2 | Is Regression: | ||
| PHP Version: | 5.2 | Sprint Focus: | ||
| Complexity: |
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)
Related issues
History
#1 Updated by Rob Vonk almost 7 years ago
Do you have more than one BE user? None works?
Can you create a new Admin user from the install tool?
#2 Updated by Rob Vonk almost 7 years ago
Or could it be that it's duplicate of this?
#3 Updated by Brian Lamb about 6 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;';
#4 Updated by Chris topher about 5 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.