Hi shikha,

We currently have this issue which only happens for server-side processing tables when you have caching active on the page.

1. Can you check the Browser Console, when this happens, do you see a console error like "Invalid JSON response"?

If so, it could be an issue with cache if you use server-side option.

Our developers are intensively working to resolve this issue, as soon as possible. I can't say an ETA on it, unfortunately.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

-

For the time being, the only two possible solutions will be:

1.  To disable caching only for pages where you have the tables, or perhaps disable caching entirely, if possible.

Most caching Plugins have the option to add URL's that will be excluded, so if possible, see if you can add the Pages with tables there, and that should solve it for now.

2. Or you can try disabling the server-side processing option in your Table.

For the Manual Tables, it is not possible to disable server-side processing,

but you can make a new SQL Query based table from the same data which is stored in a Manual Table.

This is how that is done.

First, check what is the MySQL Table name inside the Editing settings,

then make an SQL Query like : 

 SELECT * FROM TableName  

For any SQL Query based Table which has less than 2 thousand rows, you will be able to toggle server-side processing in the Data Source settings.

Let me know if that helps and if you have any questions. 

2. Or, if this does not help, can you send me remote Admin access to the back-end so I can check your table, etc?

Please provide me a temporary WP-admin (administrator) user for your website where this happens, 

as well as FTP credentials and access to the database ( either link with credentials for PHPmyAdmin, or access to Hosting Panel),

so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

You can write credentials here just check PRIVATE Reply so nobody can see them except us.

And please confirm the Table ID.

Thank you.

Hi shikha,

1. In regards to Page being unstable sometime, as you said, when scrolling the Page, we are unable to reproduce that.

Can you send me the URL of that Page and we can check it out?

If you can also send me back-end Admin access.

Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

You can write credentials here just check PRIVATE Reply so nobody can see them except us.

And confirm the Table ID, please.

2. If you disable server-side processing, you can't edit this table, but other than that, as long as it has less than 2 thousand rows, you should not see any hit to the loading performance.

The server-side processing is made to be used for very large tables, as per this documentation, and you can also see how our very large SQL table of a bit more than 2 million rows loads on this Page, so it uses AJAX to only load the visible rows, one page at a time to reduce server load;

but for smaller tables ( less than 2K rows) it should pose no performance issues.

Only in case if you 'stack' multiple tables on the same Page, then all the rows will accumulate together from all tables from the Page.

For example, let's say if you plan to place three SQL query Tables and each has 2000 rows.

Then, you would have slower load on that Page, because now it is loading 6000 rows everything at the same time in the HTML of the Page.

If you reach ~5 to 6000 rows in one Table, or multiple tables but placed together on same Page, then you should enable server-side option for better loading performance.

Let me know if you have any questions about that, and we will keep following up on the first issue you described, the page being unstable when scrolling.

Hi shikha,

I am sorry, but we are unable to provide any live meetings or calls, our Support is only provided via this ticket system, but we will do our best to raise the priority on this case since it is a critical issue.

1. In regards to those unstable issues when scrolling the Page :

Can you check does the table work and look OK on the Back-End, I presume these issues just happen on front-end version?

If that is the case, then you probably have a front-end conflict on Site.

wpDataTables is a WYSIWYG (What You See Is What You Get) concept-based plugin.

 This means that the table should look the same both in the back-end and in the front-end. 

If your front-end table looks and behaves differently than in the back-end, this usually implies that there is another plugin (or the current theme) that's changing the behavior of our plugin.

Can you please change the theme and see if the issue is resolved?

 If not, then please deactivate all other plugins except for our plugin, refresh the page where the issue is, and see if it is resolved (it should be).

 If it is, then start activating other plugins one by one, and after each activation refresh the page to see if the issue reoccurred. 

Once it does reoccur, you will have found the plugin causing the issue.

Let me know if you isolate a conflict with these steps.

2. If that does not help to isolate it, please record a Video of your screen and show us how the issue manifests on your end, since we can not reproduce it and can't remotely access it.

3. For the 'table freezing' issue during filtering :

Since you confirm it does not happen when you disable server-side processing, this is the issue I mentioned before.

There can be two ways, maybe the best way is to simply exclude that URL from caching.

Most Caching Plugins have an easy option to just exclude the URL of the Pages with Tables from caching and that should solve that issue.

-

Or, you can disable the server-side option for that table if you wish.

4. Check if the Filtering works on back-end with Server-side processing enabled.

If it does not work on back-end, then your SQL Query has some issue with our SQL Parser when server-side is combined.

I will advise on that :

Could you show me the SQL Query that was used for this table - and I can advise if maybe some small modification/correction is needed to get the search to work?

-

But you can also check these points to save time if you wish.

Our logic is based on a PHP SQL parser which has full support for the SQL dialect for the following statement types

SELECT, INSERT, UPDATE, DELETE, REPLACE, RENAME, SHOW, SET, DROP, CREATE INDEX, CREATE TABLE, EXPLAIN and DESCRIBE.

Some of them are disabled for security reasons.

Filtering, sorting, and search may not work properly if you include:

• Accent graves ( ` ) around the table name
• JOIN functions
• UNION functions
• CONCAT functions
• sub-queries

-

So, first you can check for accent graves around the table name, if you have this, remove it...

Then, see if you used CONCAT to create any column.

If so, go into this column setting, and disable it from "global search" in the Filtering tab.

-

-

If none of that helps,

you can try preparing a MySQL view (which will return the data that you need, call it e.g. “view1” and then build a wpDataTables based on a simple query like "SELECT * FROM view1″.

 If you need help with that, you can see our video, where we show an example of using View in our plugin.

-

Let me know If that helped, and i can take a look at the Query, as well.

Please note : If you send us a Video, if it shows any sensitive details, send it as a PRIVATE reply, for security, then only we can see it.

If the video gets too large, upload it anywhere like weTransfer or GoogleDrive and send me a download link.

Thank you.

Hi shikha,

Sorry, I just remembered one bug we had for scrolling of Pages when we had Fixed Headers or columns combined with specific table settings.

This was fixed in the later/new versions, so can you please confirm which wpDataTables version you have installed?

If it is not the latest 6.5.3, please follow these steps and update it to the latest version;

Then purge cache of your Site and refresh the Page, check if you can still see that unstable scrolling issue?

If it remains the same with latest version, then revert to the steps from my last reply such as checking the steps advised, send us a Video if needed, and we will keep following up until we isolate it with you.

Thank you.