Hi,
as discussed for CB 2.0 there should be a kind of partitoning of the comprofiler table.
see:
www.joomlapolis.com/forum/130-cb-123-general-discussion/124757-cb-20-ideas-discussions?limit=6&start=54#141584
A temporary solution is to use tinytext instead of varchar(255). Maybe devs can make this standard with CB 1.x series too. Tinytext has the same amount of chars but does not have the mysql varchar problem, no matter how many fields you create.
components/com_comprofiler/plugin/user/plug_cbcore/cb.core.xml
search for
Code:
type="sql:varchar(255)"
and replace with
Code:
type="sql:tinytext"
If you have the fileplugin installed do the same to components/com_comprofiler/plugin/user/plug_cbfilefield/cb.filefield.xml or any other field type plugin installed using varchar(255)
