Thread

I am trying to add custom member fields to my site, and after adding 10 or so successfully, I get this whenever I add one.

Error Number: 1118

Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs

ALTER table exp_member_data add column m_field_id_24 varchar(100) NULL DEFAULT NULL

Filename: controllers/cp/members.php

Line Number: 3208

I haven’t found any info in a forum search, so any help would be much appreciated.

Thank you! I’m running EE 2.5.2

Anyone run into this error before? Could really use some help.

Hi liquilife,

I have seen the error before, and I’m sorry you hit this snag!

What it is telling you is that MySQL thinks the row you are adding to in the database is too “long”. Rows in MySQL can have 4096 columns, or take up a certain amour of disk space - this row is exceeding the disk space amount.

I think we should have a look, but keep in mind, we are out over Thanksgiving. It very well may be Monday before we can log in.

Be on the lookout for an email from EllisLab!

Cheers,