robwent / joomla-json-db-check Goto Github PK

Hi,

I have (just found) this problem on my website horsemanshipmagazine.co.uk.
The checker finds hundreds of JSON failures, all in #__content, column attribs (example of the first one below), all syntax errors, and the website is severely broken when a user logs in and accesses anything other than the home page (I think), however the JSON checker (at http://jsonlint.com/) says there's no problem with this one, or any of the others I've tried.

Any idea what's going on?

{"show_title":"","link_titles":"","show_intro":"","show_section":0,"link_section":"","show_category":0,"link_category":"","show_vote":"","show_author":0,"show_create_date":0,"show_modify_date":"","show_pdf_icon":"","show_print_icon":"","show_ email_icon":"","language":"","keyref":"","readmore":"","show_parent_category":"","link_parent_category":"","link_author":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_hits":"","show_noauth":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}

While manually correcting the rows that the script stated, I noticed some more invalid rows that were not detected.

For example if the params column of the users table states

{""activate"":0

this is not detected (however this got into the database).

@robwent That's correct, I did add the script-file to the site root and browsed to it and I just see a page like this https://github.com/robwent/joomla-json-db-check/blob/master/json-db-check.php

Matt

From the article https://www.joomlashack.com/blog/tutorials/error-decoding-json-data-syntax/ I found this script.

However, after running the script and fixing all errors, site still gives JSON error. I modified the Json.php library per https://forum.joomla.org/viewtopic.php?t=937036 and found that there are still param fields in error. Specifically (with that library mod) I get the error " Error decoding JSON data: Syntax error the bad data is: {""}"

I'm not knowledgeable enough to know what module, etc. is generating this.

I thought I'd let you know, at least, that the script is apparently not finding this "error". Running Joomla 3.7.0

When trying to use the script after upgrade from Joomla 3.10 to 4.40, it failed with

Exception: Failed to start application

Error occured in line 64:

$app = JFactory::getApplication('site');

The exception has been thrown here:

<joomla_dir>/libraries/src/Factory.php:158

     * @throws  \Exception
     */
    public static function getApplication()
    {
        if (!self::$application) {
            throw new \Exception('Failed to start application', 500);
        }
        return self::$application;
    }

Can it be that the way of starting scripts in Joomla has changed somewhere between the versions?

I was able to fix the issue by applying the approach taken here, also considering this post.

After replacing the lines 63-64 with following code, script worked as expected:

    // Instantiate the application.
    $container = \Joomla\CMS\Factory::getContainer();

    $container->alias('session.web', 'session.web.site')
	->alias('session', 'session.web.site')
	->alias('JSession', 'session.web.site')
	->alias(\Joomla\CMS\Session\Session::class, 'session.web.site')
	->alias(\Joomla\Session\Session::class, 'session.web.site')
	->alias(\Joomla\Session\SessionInterface::class, 'session.web.site');

	$app    = $container->get(\Joomla\CMS\Application\SiteApplication::class);

This is of course a "workaround" only, I am not a developer and am not sure about the appropriateness of the code, except that it worked ;).

Can this be addressed / incorporated into some fix?

The script solved my problem by the way, thank you very much! :)

Not something that's been reported with the core content table so probably not something to check globally as it could timeout on large sites.

I have tried running it on my site, with gantry, fluent theme from rockettheme and I still get the error message.

"Error decoding JSON data: Syntax error"

any one got a new version?

Poul

Warning: Invalid argument supplied for foreach() in C:\wamp\www\develop\json-db-check.php on line 124

If it helps anyone, I was able to correct the 3.6.4 JSON upgrade error by using json-db-check.php:

It found and corrected all of my errors except for one. The error can manually be repaired by going into the database "extensions" table and "com_languages" column

I changed this:

{
"administrator":""en-GB"","site":""en-GB""
}

to this:

{
"administrator": ""en-GB"",
"site": ""en-GB""
}

Everything works again. json-db-check.php is genius and thank you @robwent or taking the time to share it

Error displaying the error page: Application Instantiation Error: Failed to start the session because headers have already been sent by "/mywebhost/unicleaning/json-db-check.php" at line 36.

here: http://www.unimancorp.com/unicleaning/administrator/index.php

#__ucm_content has core_params column, it can be added as well.