? Success

User tests: Successful: Unsuccessful:

avatar chivitli
chivitli
5 Mar 2014

In #__user_profiles table profile_value has been defined as varchar(255). This makes it quite limited for many custom fields which could be added to it, like various user descriptions. With this change the field is altered to text type instead, to enable storing of longer values.

No impact on the current entries. To test, enable user profile plugin, insert a few custom values, save, apply sql, make sure nothing changed, then apply some more changes to the profile.

Tracker: http://joomlacode.org/gf/project/joomla/tracker/?action=TrackerItemEdit&tracker_item_id=33426&start=0

avatar chivitli chivitli - open - 5 Mar 2014
avatar wilsonge
wilsonge - comment - 5 Mar 2014

Don't forget to do this for the other db types as well (if needed - I haven't checked)

avatar chivitli chivitli - change - 6 Mar 2014
Title
User profiles extending limited
[#33426] User profiles extending limited
avatar chivitli
chivitli - comment - 6 Mar 2014

@wilsonge

Thanks George, I would have definitely forget it otherwise :)

avatar brianteeman
brianteeman - comment - 8 Apr 2014

This patch is ok for upgrades but dont you also have to update the sql scripts in the /installation for new installs

avatar wilsonge
wilsonge - comment - 8 Apr 2014

Yarp

avatar chivitli
chivitli - comment - 8 Apr 2014

Right, updated the installation files as well, thanks to both of you

avatar Kubik-Rubik
Kubik-Rubik - comment - 26 Jul 2014

I like this change, I also encountered some limitations with this field. Please update the PR with the lastest update SQL files and then we can add this.

avatar Kubik-Rubik Kubik-Rubik - reference | - 26 Jul 14
avatar Kubik-Rubik
Kubik-Rubik - comment - 26 Jul 2014

PR Updated - #3982

avatar mbabker
mbabker - comment - 3 Aug 2014

Closed in favor of #3982

avatar mbabker mbabker - change - 3 Aug 2014
Status New Closed
Closed_Date 0000-00-00 00:00:00 2014-08-03 16:58:06
avatar mbabker mbabker - close - 3 Aug 2014

Add a Comment

Login with GitHub to post a comment