Out of range value for column 'database_quota' at row 1

Discussion in 'ISPConfig 3 Priority Support' started by Turbanator, Apr 29, 2017.

  1. Turbanator

    Turbanator Member HowtoForge Supporter

    Perfect Jessie - Mysql 5.6.36
    Tried to add a new database in ISPC 3.1.2 and received this error after I saved.
    Out of range value for column 'database_quota' at row 1
    any ideas?
     
  2. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    which quota did you set? You can also try to change the db-structure for web_database:
    Code:
    ALTER TABLE `web_database` CHANGE `database_quota` `database_quota` int(11) unsigned NOT NULL DEFAULT '0';
     
  3. Turbanator

    Turbanator Member HowtoForge Supporter

    I don't have any quotas set. This was while creating a new db.
    I made the change as requested. mysql returned
    ERROR 1265 (01000): Data truncated for column 'database_quota' at row 6
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Which value was shown in the quota field when you created the database?
     
  5. Turbanator

    Turbanator Member HowtoForge Supporter

    It shows -1
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Try to remove the 'unsigned' attribute from the database_quota field in the web_database table, the easiest way is probably to use PHPMyAdmin for that.
     
  7. Turbanator

    Turbanator Member HowtoForge Supporter

    that seemed to have worked. Since I'm on a multiserver setup, should I do the same to the other server...or only if I have issues?
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    Please change it on the slaves as well.
     
  9. Turbanator

    Turbanator Member HowtoForge Supporter

    thank you
     

Share This Page