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

7 years 11 months ago - 7 years 11 months ago #281680 by franz.wohlkoenig
params-Field in __users "to long to be editable" was created by franz.wohlkoenig
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

Please Log in to join the conversation.

7 years 11 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 to join the conversation.

7 years 11 months ago #281715 by franz.wohlkoenig
Replied by franz.wohlkoenig on topic params-Field in __users "to long to be editable"
Thanks for your Information, now i can go on looking for the Culprit. Have a nice Day.

Please Log in to join the conversation.

7 years 11 months ago #281770 by franz.wohlkoenig
Replied by franz.wohlkoenig on topic params-Field in __users "to long to be editable"
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 to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.182 seconds

Facebook Twitter LinkedIn