Hi,

We are building a Joomla / CB site for one of our customers and we had a weird error after a Mac user edited his profile in frontend and saved it. It broke his profile while connected and he could not access any page after.

Taking a look at the users table, I saw that the value in params field was looking very strange, I pasted another user params there what corrected the error and then disallow params editing in CB configuration. I then asked a Mac friendyl coworker to register a profile on a Mac using Safari and then edit it in frontend.

While this coworker was going through these stages I looked at the users table. When she registered, the params field was left empty so the registration form does not write it neither with default value nor with something else. I then validated the pictures from the backend and the params field took the default values, until now everything is quite nice.

The situation changed when she began editing her profile in frontend. At the moment she saved it, a second params array was added to the field and while editing once more a third array came but mixed in the second one (attached screenshot).

This time there was no fatal error but that's for sure not a normal behaviour.

Taking a look, at other users in the table, I saw it was not the only one having strange value in params field and some quite different than this one (second screenshot). So probably another browser even if I can not be sure actually.

Anyone has an idea what could be causing that ?

Thanks in advance for your help.

Hi,

I am sorry but even with new user (registered yesterday) the params field gets changed when the profile is saved from frontend. And there is no very old rows in this DB as we began building this website about two month ago so with Joomla 3.6.5 and CB 2.1.2.

CB and Joomla are actually latest version and we have no third party extensions dealing with users except for CB and eventually Geommunity for CB but I think it only reads users nothing else (not sure).

I tried resetting one profile as you said and then edited it in frontend twice, this time with Chrome on Windows. Here is what I have in the DB : {"0":"{\"0\":\"{}\"}"}

I then edited the same profile in CB backend and here is the result : {"0":"{\"0\":\"{}\"}","language":"","editor":"","timezone":"Europe\/Zurich"}

Then back in frontend getting worse: {"0":"{\"0\":\"{\\\"0\\\":\\\"{}\\\"}\",\"language\":\"\",\"editor\":\"\",\"timezone\":\"Europe\\\/Zurich\"}","language":"","editor":"","timezone":"Europe\/Zurich"}

It seems each time I edit it, it adds something so I actually have no Json error but I presume it may change once the profile has been edited often enough and that's probably what happened with the user I encountered this error with.

Are you really sure this behaviour is normal ?

The userparams field is set to be available nowhere and "Allow CMS user parameters" in global CB settings is set to no. When I encountered the problem, I also set the field to be read only to see if it fixes the problem but the result is the same.

This way it should not be changed except when editing the user in Joomla users component. No ?

I you want I can give you an access to the website and DB.