MySQL VAR-CHAR problem and temp. solution

ndee
OFFLINE
Posts: 25
Thanks: 5
Karma: 19

13 years 8 months ago #152971 by ndee

MySQL VAR-CHAR problem and temp. solution was created 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

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)

###################
SPEED UP HELP, read first: Help us help you
###################

The following user(s) said Thank You: darb, heyai

Please Log in or Create an account to join the conversation.

darb
OFFLINE
Posts: 65
Thanks: 0
Karma: 2

13 years 8 months ago #154020 by darb

Replied by darb on topic Re: MySQL VAR-CHAR problem and temp. solution

So will this be fixed in CB 2.0 ?

status?

rgds

Please Log in or Create an account to join the conversation.

darb
OFFLINE
Posts: 65
Thanks: 0
Karma: 2

13 years 8 months ago #154021 by darb

Replied by darb on topic Re: MySQL VAR-CHAR problem and temp. solution

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 or Create an account to join the conversation.

Moderators: beat, nant, krileon