Thread

It seems randomly I get the following error when adding a new profile field:

A Database Error Occurred
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_28 varchar(100) NULL DEFAULT NULL

Filename: controllers/cp/members.php

Line Number: 3208

« Back

It happens most times I try to create a new standard member field. Any ideas whatsoever what might be causing this?

It seems the new member field is being created in the DB table ” exp_member_fields” but is not being added as a column to “exp_member_data”

Hi liquilife,

How many custom member fields do you have already and are most of them textareas? MySQL has a limitation on how ‘wide’ a table can be. This means that if you have a lot of large columns, you run into that maximum faster…

You can read more about it here: http://dev.mysql.com/doc/refman/5.6/en/column-count-limit.html

– Wouter

Hi there. We actually only have about 11 custom member fields. They are also set as single line text inputs with a limit of 100 characters. I don’t think we could hit this limit so easily.

Is this a single site or part of a MSM setup? If you look at the exp_member_data table in a SQL manager (like Navicat), can you see how ‘wide’ the table is right now?

For example… I have a site with just 1 custom member field and my row length (or width) is 4096.

You know what? I found two custom profile member fields with a char limit set to 10,000! No idea how that happened, haha. Thanks for the heads up and direction. That was the issue.

I’m glad I was able to point you in the right direction…