0 Error decoding JSON data: Syntax error

Hi,

We have a Joomla 3.6.5 site with the latest version of CB and CB Subs. This is a community membership site. The site displays user profiles for members to search on.

Back in Feb. we had a use that was having trouble logging in. When you tried to edit the user record in the backend you go the message:
0 Error decoding JSON data: Syntax error

I found this post: www.joomlapolis.com/forum/153-professional-member-support/235097-solved-0-error-decoding-json-data-syntax-error
I found that his params field of his user table record was corrupted, so large that it couldn't be edited. I ran the update command: The user could then login again and the admin could edit his record in the backend. The biggest issue is that the user list could not be displayed on the page that this user was on, white screen of death. Not good for a community membership site.

We then ran a global update on all users and set their params field back to {}.

Yesterday we had another user that couldn't login and one of the member list pages would not display. This user has the same problem where their params field is huge. I ran the update command on that user, and they can now login and be edited.

The problem is that somehow user records params are getting 'corrupted' and becoming huge. It looks like it is users that do a lot of updating to their user
profile that get this problem. Could there be something in the CB code that 'corrupts' the params field when a user updates their CB profile?

Thank you.

CB can not corrupt the params. It may have in a much older release around the time they changed params to JSON, but since then we've no issues with saving params. So only very old user rows may have issues, but once the fix query is ran you should have no further problems.