[SOLVED] MySQL VAR-CHAR problem / max. No. of fields limit

Hi,

this MySQL VAR-CHAR Limitation has been around for a while now. I set up a testinstall and played with CBSubs profiles, now after setting up 98 fields this error popped up. Especially with CBSubs and different profiles this is limit is reached sooner or later by bigger community sites.

I also suggested a temporary solution here: www.joomlapolis.com/forum/146-general/152971-mysql-var-char-problem-and-temp-solution

How is this solved with CB 2.0?

It would be great if fields are not stored in one table as now in comprofiler. We have now 350 fields and only about 50-70 are releated to each CBSubs plan. Now all fields are loaded for each user, even if they are not related.

I know this was not a problem before CBSubs was available as there was only 1 profile, but now with the flexibility of CBSubs this DB design is limited. I hope you find a flexible and performant solution and are aware of this problem.

Thanks.

How is this solved with CB 2.0?

We've plans to redo how fields are stored so there won't be a limit anymore. Everything's still in design phase, we've not implemented anything.

We are aware of the issues with fields limit; most installs won't hit this limit and be unaffected, but a few will. We'll be working for CB 2.0 to implement a more acceptable solution to handle large field usage.

Hi Kyle,

thank you for the info. Great to hear that you guys are aware of that.