Unknown column 'limit_database_postgresql' in 'SET' after update 3.3.0p2

Hey guys, I get this error when I try to change limit template for a customer or try include additional template for a customer.

thanks in advance

 

Hi guys, thanks for the quick response.

I ran the suggested script and it failed.
So I executed it line by line. With each executed line, the result was a duplicated field.
And finally, the "sys_message" table already exists.

thanks in advance

 

Hi everyone, I noticed the following error:



MariaDB [dbispconfig]> ALTER TABLE `client` ADD `limit_database_postgresql` INT NOT NULL DEFAULT '-1' AFTER `limit_database`;
ERROR 1118 (42000): 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


Thanks in advance

 

Hi everyone,

The reason for the ERROR 1118 on my server was that the client table had row_format=compact. After changing the row_format to dynamic, I was able to run the script and the error for accessing the limit templates was gone.

Thank you very much