Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount! Get 20% off now with code SPOOKY-2024!

MySQL VAR-CHAR problem and temp. solution

  • ndee
  • ndee
  • OFFLINE
  • Posts: 25
  • Thanks: 5
  • Karma: 19
13 years 8 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
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
  • darb
  • OFFLINE
  • Posts: 65
  • Thanks: 0
  • Karma: 2
13 years 8 months ago #154020 by darb
So will this be fixed in CB 2.0 ?

status?

rgds

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

  • darb
  • darb
  • OFFLINE
  • Posts: 65
  • Thanks: 0
  • Karma: 2
13 years 8 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 or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum