[SOLVED] 0 - Error decoding JSON data: Syntax error

7 years 5 months ago #287396 by krileon
Replied by krileon on topic 0 Error decoding JSON data: Syntax error
I'm not sure what's causing parameters to malform on save, but my guess is an older release of Joomla or even older release of CB. If possible try to just find the affected rows and reset those only otherwise user parameters for each user will be reset.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in to join the conversation.

7 years 5 months ago #287426 by ricco1
Replied by ricco1 on topic 0 Error decoding JSON data: Syntax error
Hi, I've got the same problem. So, is it not save to update to Joomla! 3.6.4?

Please Log in to join the conversation.

7 years 5 months ago #287431 by Onkel Tom
Replied by Onkel Tom on topic 0 Error decoding JSON data: Syntax error
You should update your Joomla installation to version 3.6.4 immediately! It is a security fix, that repairs a very critical issue: A hacker can create accounts with administrator privileges, even when you have disabled log in or the creation of accounts! All Joomla installations from V 3.4 are affected from this issue.
So to stay on an old version means you give up your website.

It is important to see what the JASON error causes: Its not the update itself. In the update of Joomla the developers built in a check, whether JASON decoded parameters are presented correctly or not. In case if not, it throws the error we are talking about. The problem is, that those incorrect parameters were written into the database a long time ago by components or plugins. Sometimes this may have been done also during the creation of a website by using a copying routine. In dont know what exactly it was. In my case the Jason error was caused by those mess of /// and .... and """ in the params column of the user table. I have been using Community Builder for a long time and the params therefore have been written only by CB. Maybe that a malicious peace of code in Joomla did the rest, but the result was a chaotic string in the params column. In case you dont want to review every single line manually and correct this into a correct string readable for the JASON routine, then just use this mysql Statement to let your server do the work:

UPDATE `XXXX_users` SET `params` = '{}'.

Please note: XXXX has to be replaced by your database-prefix, that your Joomla uses in your MYSQL database.

Keep in mind, what Krileon said above: This will reset ALL user parameters to default state.

Its up to you, what you prefer to do. But YOU HAVE TO DO IT. :) if you dont want to present your website to hackers as a nice peace of cake.

Best regards
Tom
The following user(s) said Thank You: krileon, ricco1

Please Log in to join the conversation.

7 years 4 months ago #288811 by edmundcheong
Replied by edmundcheong on topic 0 - Error decoding JSON data: Syntax error

krileon wrote: We don't use Joomlas object classes so we never call stringToObject, which appears to be the problem. Most likely it's in Joomlas user object or some sort of loading behavior for a system plugin or modules parameters. In short it's a problem in Joomlas own database tables. Probably the easiest way to fix it is manually review the _modules and _extensions database tables then ensure the params columns have valid json.



In my case, user list are failing..

I get the Error decoding JSON data: Syntax error after upgrading.. corrected a user list with an advance filter where fieldname = '' previously i just left the fieldname "equal to" blank (leaving the field empty at basic mode) bu by adding the = ' ' it corrected the issue..

I have another problem where I had another filter where cb_completedby equal to [cb:userdata field="email" user="#me" /]

It seems that CB substitution cant work.. be cause of the / in the [cb:userdata field="email" user="#me" /]

Please Log in to join the conversation.

7 years 4 months ago #288812 by edmundcheong
Replied by edmundcheong on topic 0 - Error decoding JSON data: Syntax error

UPDATE `XXXX_users` SET `params` = '{}'.

Please note: XXXX has to be replaced by your database-prefix, that your Joomla uses in your MYSQL database.

Keep in mind, what Krileon said above: This will reset ALL user parameters to default state.


This worked! Thanks man.. Somehow the params column is screwing everything on CB.. after setting everything to '{}', everything worked!

For those who are comfortable in setting params` = '{}', copy the table first.. ;)

Please Log in to join the conversation.

7 years 1 month ago #292095 by JerryK132
I have an odd variant of this problem.
I'm using the current Joomla/CB/CBSubs.

I was able to tick two subscription plan items in a users subscription details on the CB User Management Edit screen. Something like Delete and Unsubscribe (I can't remember exactly) on two different subscriptions. I then saved and got the error being discussed in this topic. All attempts to edit that member resulted in the same error, but other members were unaffected.

Having read this thread, I replaced the contents of params for this member (only) with {} and all is now well. The stuff I replaced had no closing bracket, but a lot of slashes, etc. What was not clear to me from this thread was whether the contents of params was important or not, so I was reluctant to clear them all, but as my problem was just the one member (which I could list but not edit nor delete) I took the risk and all seems fine.

Thought it might be useful to others and also to Krileon as regards the cause of the problem.
Thanks

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.259 seconds

Facebook Twitter LinkedIn