Unknown column 'disable_symlinknotowner' in 'field list' error

Discussion in 'Installation/Configuration' started by Norm Powroz, Nov 2, 2024.

  1. Norm Powroz

    Norm Powroz New Member

    Like other people. I'm getting this error when I attempt to change anything in the Custom php.ini section in the Options tab. The error pops up when I attempt to save the changes.
    I followed the corrections given in the Priority support area for someone else experiencing this same problem. however, when I execute the SQL:
    ALTER TABLE `web_domain` ADD `disable_symlinknotowner` enum('n','y') NOT NULL default 'n' AFTER `last_jailkit_hash`;
    I get the error:
    #1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

    Any suggestion?
    Thanks
    Norm
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Which ISPConfig version do you use on which operating system and which MariaDB version does your server use?
     
  3. Norm Powroz

    Norm Powroz New Member

    The server uses the latest patch level of ISPConfig (3.2.12p1) running on CentOS 7, with MariaDB 10.6.18.
     
  4. Mr.X123

    Mr.X123 New Member

    Hi, I see the same error message as of today. Running Debian 10, with php8.2 and isp version 3.2.12p1.
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    Ok, and did you run the SQL query mentioned din the first post to fix it?
     
  6. Mr.X123

    Mr.X123 New Member

    Hi Till, now I altered my DB as well. Its working like a charm .-) Thanks ! How could this happen?
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    Seems as if database changes in the last ISPConfig update could not be applied. It is the SQL change file install/sql/incremental/upd_0100.sql. Maybe you change the MySQL root password and did not set the new password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf file?
     

Share This Page