Error: The database charset can not be changed

Discussion in 'ISPConfig 3 Priority Support' started by variable99, May 20, 2024.

  1. variable99

    variable99 Member HowtoForge Supporter

    I have disabled database via API. And now want to re-enable via ISPC panel. I tick "Active" option and while trying to save new settings receive error:
    "The database charset can not be changed". It is set to "DB-default" and I definitely not changing it.
    Is it possible to re-activate access via MySQL cli?
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    If it says that it gets changed, then it gets changed. Most likely you created the database with a charset not available in ISPConfig GUI or with now charset using the API, which will cause a change of charset when using the GUI. To fix that, manually set the right charset in web_database table for this database and then activate it.
     
  3. variable99

    variable99 Member HowtoForge Supporter

    Ha, the problem was that setting is case sensitive and I have used uppercase UTF8 via API. Damn.
    Solution: set utf8 .
     
    till likes this.

Share This Page