We have seen this issue multiple times, with multiple tables. It is a sporadic issue, which makes diagnosing it and explaining it to our customer even more difficult.
Simply put, a wpDataTable that's been created and running for months just stops showing data. There's been no changes to the wordpress element, or the website. The SQL runs just fine from the wpDataTables dashboard and shows data. The SQL shows data from the database engine directly. Other wpDatatables continue to work just fine.
Forcing a reload in chrome with shiftl-F5 does not work either.
The only change is that the underlying table that the wpdatatables table is reading from is periodically refreshed. Which makes me think perhaps this is some sort of caching issue. But we need a solution so that end users always see the data, which is kind of thepoint of our buying and using the plugin.
Sorry for the late response. Our team is cut in half due to Covid-19 infections, so our response times are longer than usual. Thank you for your patience!
. Intermittent issues are extremely hard to resolve. We haven't been able to replicate the issue on your website, so we can't say what happens.
Can you try to catch the issue as it happens, with an error in a console log, or perhaps in a server log; possibly recording a video when it happens, and we will absolutely do the best we can to try and advise?
I tried the page again at the front end, and I did see what you mean. At first, the page did not load at all, but after waiting a bit, and refreshing, everything loaded correctly. We will try to help as much as possible(sorry for the large amount of info, but we will try to cover all possibilities).
- 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. In this case, as we see, 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 behaviour 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.
;
- These kinds of issues can happen for a few reasons, but they always happen for server-side tables (MySQL, manual, or imported tables).
- Check again if you have any errors, notices, warnings in your console. If there are, resolve them first because they are interrupting wpDataTables' admin-ajax calls and the errors returned are referring to either bad Ajax or bad JSON response.
Another thing that could be causing this is cache( as you mentioned earlier, correctly). If the data is being cached on the page, the returned data is not the same, or not at least what wpDataTables is expecting to see, so the error occurs. Try clearing all cache from your website and browser, and then prevent the pages containing wpDataTables from being cached.
Last, it could be the data in the table(s) - if the data is not the type that it should be (for example, a non-numerical value in an integer or a float column), or if the data has been changed for a formula column. Try creating a new table from the source table and see if it's going to cause errors. If it doesn't (after excluding cache as the cause), look for differences between data, filters, etc.
We have seen this issue multiple times, with multiple tables. It is a sporadic issue, which makes diagnosing it and explaining it to our customer even more difficult.
Simply put, a wpDataTable that's been created and running for months just stops showing data. There's been no changes to the wordpress element, or the website. The SQL runs just fine from the wpDataTables dashboard and shows data. The SQL shows data from the database engine directly. Other wpDatatables continue to work just fine.
Forcing a reload in chrome with shiftl-F5 does not work either.
The only change is that the underlying table that the wpdatatables table is reading from is periodically refreshed. Which makes me think perhaps this is some sort of caching issue. But we need a solution so that end users always see the data, which is kind of thepoint of our buying and using the plugin.
Hi, Todd.
Sorry for the late response. Our team is cut in half due to Covid-19 infections, so our response times are longer than usual. Thank you for your patience!
. Intermittent issues are extremely hard to resolve. We haven't been able to replicate the issue on your website, so we can't say what happens.
Can you try to catch the issue as it happens, with an error in a console log, or perhaps in a server log; possibly recording a video when it happens, and we will absolutely do the best we can to try and advise?
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
https://apptour.org/zdb-men-pro-combined/
This link is not showing data as we speak (2/7/22, 9;25pm EST)
Same issue.
Here's that same wpdatatable, clearly showing data, within the wp-admin dashboard:
I've got wp-admin console access, but do not see server or error logs.
Hi, Todd.
I tried the page again at the front end, and I did see what you mean. At first, the page did not load at all, but after waiting a bit, and refreshing, everything loaded correctly. We will try to help as much as possible(sorry for the large amount of info, but we will try to cover all possibilities).
- 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. In this case, as we see, 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 behaviour 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.
;
- These kinds of issues can happen for a few reasons, but they always happen for server-side tables (MySQL, manual, or imported tables).
- Check again if you have any errors, notices, warnings in your console. If there are, resolve them first because they are interrupting wpDataTables' admin-ajax calls and the errors returned are referring to either bad Ajax or bad JSON response.
Another thing that could be causing this is cache( as you mentioned earlier, correctly). If the data is being cached on the page, the returned data is not the same, or not at least what wpDataTables is expecting to see, so the error occurs. Try clearing all cache from your website and browser, and then prevent the pages containing wpDataTables from being cached.
Last, it could be the data in the table(s) - if the data is not the type that it should be (for example, a non-numerical value in an integer or a float column), or if the data has been changed for a formula column. Try creating a new table from the source table and see if it's going to cause errors. If it doesn't (after excluding cache as the cause), look for differences between data, filters, etc.
I hope that helps.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables