Login TYPO3 6.1 not possible

Question

I have to manage a realy old TYPO3 Vers (6.1.9) I can't login in the BE with any available user Trying to generate a new one via the install tool I get this error:

User not created Error: Field 'TSconfig' doesn't have a default value

I have tried to generate a new user via phpmyadmin - no login possible :-(

the hosting server use mariaDB/mysql and PHP 5.6

Answer 1

Your error message leads to a MariaDB failure, as the field TSconfig in be_users has no default defined. You can fix this manually in your PhpMyAdmin by the following SQL command:

ALTER TABLE be_users
ALTER TSconfig SET DEFAULT '';

After this executing you should be able to create a new backend user via InstallTool.