6 years ago
Topic

Hi

In the USER content type we have so many fields that we can't just add new fields whatever max_input_vars we set!

We had to create the additional fields from the FIELDS manager 

1- if we set STANDARD / USER  storage telling "linked to the content type USER" we get the message :

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


2- if we set the field as TEXT the error message remains


3-if we set CUSTOM/FREE/#__cck_store_form_user storage it creates a NEW table: #__cck_store_item_cck_store_form_user !!!


HOW can I just create a new field stored in a new column of the #__cck_store_form_user table please ?


thanks


cyril

Get a VIP membership
4229 Posts
Kadministrator
6 years ago
1
Level 1

Didn't we discuss this already?

6 years ago
0
Level 2

You are right Klas but I couldn't find where :(

Anyway the solution was simply to modify, in phpMyadmin, some of the existing columns of #__cck_store_form_user from Varchar to TEXT.

I put it here so that it could help some other facing such an issue

Thanks

cyril

Get a VIP membership