Hi,

Today I installed the latest versions of both ARI Datatables and Smart Content on my Joomla site. I am also using the latest 3.6.4 version of Joomla.

I am now seeing that every time I attempt to open any of the ARI DataTables modules I get the error shown in the attached screen grab.

The error "decoding JSON data: Syntax error". In the frontend of the website all seems to work fine.

Any ideas?

Ken

Sorry, here is the screen grab.

I was wrong, the frontend processing of data NO longer works correctly. All the ARI modules return NO data. This is a serious issue.

I have rolled back to ARIDataTables version 1.15.12 and then re-installed both of the following files,

class.LoadAll.php
class.PrepareIn.php

These you provided me as customizations for processing the IN statements in SQL.

The ARI modules are all returning NO DATA. Why?

Let me add some final information that may help debug this issue.

The JSON issue is related to the Joomla version, and the problem exists since 3.6.3. It is a known issue. I rolled back to Joomla 3.6.3 and the JSON issue remains.

I researched and it is a result of tighter syntax in the newer Joomla versions since 3.6.3 all done to tighten security. Extensions with poor syntax for JSON calls are now rejected outright. Start there.

I was able to restore the frontend working correctly after restoring from backup. The new version of ARIDataTables replaced the file "class.LoadAll.php" and removed the line that loads the custom "PrepareIn"filter you created.

Will I have to do this every time an update is installed? Why? Why not just add that line to the standard file and include the "PrepareIn" filter? Why leave this as a manual process? This is a recipe for disaster. It is only a filter, just add to the base product!

Let me know when you have a solution to the JSON issue. Right now I cannot access any of my ARI datatables modules via the backend.

Ken

Update "ARI Data Tables" module to the latest version (1.15.13). It fixes the problem with "JSON" error message.

"PrepareIn" is a custom module so we don't include to a standard version of the extension.

Regards,
ARI Soft