Welcome to the PufferPanel community forums! If you need help please register an account and post in the Support category.

Error 500 when switching languages



  • I accidentally switched the language to Dutch, but when I try to switch it to English (US), I get hit with a page with
    Server Error
    We're sorry! The server encountered an internal error and was unable to complete your request. Please try again later.
    error 500

    From /srv/pufferpanel/logs/exception.log

    [2017-06-04 16-42-31] Klein\Exceptions\UnhandledException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'language' at row 1 #22001 in /srv/pufferpanel/vendor/klein/klein/src/Klein/Klein.php:954 caused by PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'language' at row 1 #22001 in /srv/pufferpanel/vendor/j4mie/idiorm/idiorm.php:503  @  https://panel.myserver.com/admin/account/new  @@  exception--2017-06-04--15-56--a68cc51b77.html
    [2017-06-04 16-42-46] Klein\Exceptions\UnhandledException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'language' at row 1 #22001 in /srv/pufferpanel/vendor/klein/klein/src/Klein/Klein.php:954 caused by PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'language' at row 1 #22001 in /srv/pufferpanel/vendor/j4mie/idiorm/idiorm.php:503  @  https://panel.myserver.com/language/en_US  @@  exception--2017-06-04--16-14--6051042db8.html
    [2017-06-04 16-45-41] Klein\Exceptions\UnhandledException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'language' at row 1 #22001 in /srv/pufferpanel/vendor/klein/klein/src/Klein/Klein.php:954 caused by PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'language' at row 1 #22001 in /srv/pufferpanel/vendor/j4mie/idiorm/idiorm.php:503  @  https://panel.myserver.com/language/en_US  @@  exception--2017-06-04--16-14--6051042db8.html
    

    Any help would be apprecited, thanks

    (Also, this happens when I try to add a new user account.)



  • Solution from puffrfish on the Discord/IRC

    @Nystrata
    mysql -u root -p
    USE pufferpanel;
    ALTER TABLE users MODIFY language varchar(10) NOT NULL DEFAULT 'en_US';
    exit;


Log in to reply
 

3
Online

666
Users

708
Topics

3.2k
Posts

Looks like your connection to PufferPanel Community was lost, please wait while we try to reconnect.