1 (edited by Wingthor 2021-03-06 17:45:12)

Topic: Error: OperationalError(1054,... SQL Error (1118): Row size too large.

iRedMail 1.3.2
Deployed: downloadable installer
Linux: Ubuntu focal
Store mail accounts: MySQL
Web server (Apache or Nginx): Both
- Manage mail accounts with iRedAdmin-Pro?: No

"Unknown column 'mailboxfolder' in 'field list when adding new user from iRedAdmin (1.2 (MySQL) )

I have upgraded iredmail due to upgrade of Ubuntu. Mail server working fine. I have some issues, apparently I have upgrade from a pro version and ended up with a community edition. I do not know where to find license... Anyway...

Problem is during upgrade "Upgrade iRedMail from 0.9.9 to 1.0" Section UpgradeMySQL/MariaDB special there is file to be downloaded: (https://docs.iredmail.org/upgrade.iredm … db-special) iredmail.mysql in this file, there is two lines of SQL commands. When running this commands on my MySQL server, I get this message:

"/* SQL 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 */"

So question is, how do I solve this?

Regards
Wingthor

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: Error: OperationalError(1054,... SQL Error (1118): Row size too large.

Which SQL command caused the error?