MySQL VAR-CHAR problem and temp. solution

13 years 2 months ago #152971 by ndee
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
type="sql:varchar(255)"
and replace with
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)

###################
SPEED UP HELP, read first: Help us help you
###################
The following user(s) said Thank You: darb, heyai

Please Log in to join the conversation.

13 years 2 months ago #154020 by darb
So will this be fixed in CB 2.0 ?

status?

rgds

Please Log in to join the conversation.

13 years 2 months ago #154021 by darb
Nope didnt work for me still got this annoying problem .. a show stopper for CB and a show stopper for my site..waiting to long for a solution for this now...:angry:

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.207 seconds

Facebook Twitter LinkedIn