Aimy H1 Heading: Context: com_content.article

How to Fix "Error Decoding JSON Data Syntax Error" in Joomla

Here is the relevant transcript for the video:

 A tutorial to fix the error decoding JSON data: syntax errorHey there Joomla fans! Thanks for tuning in again to Cybersalt's Basic Joomla Channel. I'm Tim Davis and today I'm not coming to you from . . . Toronto - though for about 16 years of my life I've lived in Toronto.

A big shout-out to my wife today for being patient with me fixing her Joomla site that broke. Now, most people who know me in real life figure she's patient anyways - it would just have to come with the territory. But a few Joomla updates ago, when we updated her site, something broke and she could no longer log-in to the admin area. She'd get the "Error decoding JSON data: Syntax error." I fixed her site and it was working, but then I undid those fixes because I thought it would make a great tutorial. And that's the subject of this tutorial now, "How to fix the "Error decoding JSON data: Syntax error". Let's head on over to the computer and check it out!

Part of the delay in making this tutorial, re-fixing my wife's site, is because I wanted to have a tutorial up on the channel ready to help backup your database using phpMyAdmin. Because my wife can't log into the backend of her site - and I can't log into it - I can't run any other backup extensions that it uses and I want to make a backup of this database because we're going to be going right into the database and running a little bit of code.

Now that code that I found is in the Joomla forums in a couple of places and I'll paste a link in the description below where you can go and read in one of those locations. I'm also going to place a card above, at the end of the video, and a link in the description below to the tutorial on how to backup your database using phpMyAdmin. It's really important to do that because if something goes wrong while we're running this code and you don't have a backup then your problems have just multiplied.

So, the first thing I want to show you here is that when I go to my wife's site, 88keysbythesea.com/administrator, and try to login, instead of the login form coming up we get this error here; "Error decoding JSON data: Syntax error" and that's the problem that we want to fix.

To do that we're going to go into the cpanel hosting account for this account - cpanel is what I use on Cybersalt Hosting. Once we're logged-in there and once you've backed up your database - REALLY, you REALLY want to do that; use that tutorial that I made - once you log-in to cpanel you're going to go down to phpMyAdmin in the databases section. These sections appear in different orders in different cpanels, so you may have to look around for it. You could even go up to the top right corner and just type PHP and you'll see some options there.

So, if we click on it there or down on that other link, we're taken to a place where we're presented with the databases that belong to this web hosting account. Here's keysbythe_88keys. It's the only database. Information schema serves a different purpose.

We're going to click on that database that runs the Joomla site, keysbythe_88keys, or whatever your database and we'll be presented with the tables that run her site.

Next, we want to click on "SQL." It's here in this SQL tab we have this field where we can post in a command that is going to search a certain table and change some things that will fix that error.

Now here in a Wordpad document, I've got the code that we want to run: "update xxxx_modules set params = '' where params like '%{""}%';". I'll put that code in the description of the video as well so you can cut and paste. What we're going to do is select that whole line, I'm going to right click and copy it, and now I'm going to click in this window to run the SQL query, which is what it is, and click paste. Now, before I click "go" and run this, we need to change the four x's before "_modules" to whatever the prefix is for tables in your database. When I look over here in this column I see on this site it is "cyb." You need to match the prefix replacing the four Xs in this line with whatever the prefixes are for your database - CYB in this case. And so, this SQL query is going to run on the table "modules" in this database - cyb_modules - and it's going to do some looking around and do its thing.

I click go and once it's run it says up here "4 rows affected." That encourages me because if no rows were affected probably nothing was fixed. But now we can go back to the backend login for the site - 88keysbythesea.com/administrator - and I'm just going to enter again and lo and behold there's the login form and the site is fixed and my wife can now finally login to her site and update things for her students and I can finally move on to some other tutorials without the guilt of knowing that her site has been down for a long time.

So, if that fixes the problem that was on your site then that's great. Why not “Like” this video? Or maybe this has just been some sort of helper tutorial for getting into working in the database and fixing something else on your site. If so, I'm glad that helped too. I’d love a thumbs up.

Don't forget to backup your database before you try this. If this was helpful, like I said, please give me a thumbs up. If you haven't subscribed to the channel, please do! Click subscribe and don't forget to ring the bell next to subscribe. That will let you get updates as soon as new videos are posted to the channel.

Thanks for watching. Enjoy your Joomla sites. God bless.


subscribe basic joomla

subscribe cybersalt

earn coins bn

Login Form