Skip to Content Skip to Menu

params-Field in __users "to long to be editable"

  • GUEST
8 years 4 months ago - 8 years 4 months ago #281680 by
Hi CB-Team,

1. You provide exact Joomla version
3.5.1

2. You provide exact Community Builder version and make sure that it is the latest
2.0.14

3. You provide exact PHP version and MYSQL version
PHP 7.0.4, MySQLi 5.5.49-0

4. You provide exact steps so we can replicate the exact issue you are seeing on our clean install
Open and Save Profile in Frontend. Look in phpMyAdmin, users-table > params: Value grows with every Save from

default:

"{"admin_style":"","admin_language":"","language":"","editor":"","helpsite":"","timezone":"Europe\/Vienna"}"

to (2nd Save):

"{"admin_style":"","admin_language":"","language":"","editor":"","helpsite":"","timezone":"Europe\/Vienna","0":"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"Europe\\\/Vienna\",\"0\":\"

to (3rd Save):

"{"admin_style":"","admin_language":"","language":"","editor":"","helpsite":"","timezone":"Europe\/Vienna","0":"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"Europe\\\/Vienna\",\"0\":\"{\\\"admin_style\\\":\\\"\\\",\\\"admin_language\\\":\\\"\\\",\\\"language\\\":\\\"\\\",\\\"editor\\\":\\\"\\\",\\\"helpsite\\\":\\\"\\\",\\\"timezone\\\":\\\"Europe\\\\\\\/Vienna\\\"}\"}"}"

and so on.

5. You give exact details of complete error message or behavior you are seeing
Noticed first that i can't login from Frontend. Using "Error-Report" got Message that can't saved cause Memory-Limit is reached.

Looking in user-Table see Message at params-Value: "Because of its length,
this column might not be editable"

Set Value back to default all works well.

Regards
Last edit: 8 years 4 months ago by .

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

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
8 years 4 months ago #281710 by nant
we don't handle params storage.. that's joomla.. just like username, etc..
we tested - could not confirm

Please try to confirm this on a clean Joomla/CB install

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

  • GUEST
8 years 4 months ago #281715 by
Thanks for your Information, now i can go on looking for the Culprit. Have a nice Day.

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

  • GUEST
8 years 4 months ago #281770 by
Hi nant,

my Setting in Field "_UE_USERPARAMS" was to hide all Parameters. If showing one Parameter like "Frontend Language" all is fine now.

So it looks like the Behaviour wrote in first Message comes from CB, if all Parameters in Field "_UE_USERPARAMS" are hidden.

Regards

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

Moderators: beatnantkrileon
Powered by Kunena Forum