I can create new tables no problem but and the Dashboard is showing the correct number of tables I have created but when I try and browse all tables I am receiving: No wpDataTables in the system yet.
This means I can't access to make any changes to my created tables.
Just wanted to notify you that our developers just launched a new Update that has a permanent fix implemented for this issue of the "browse tables page" not showing tables correctly in the back-end.
Please update your plugin to latest Version 5.4.1.
A minor update with bug fixes: BugFix: Fixed issue with browse page not loading when using SQL 5.6.x versions. Other small bug fixes.
I can create new tables no problem but and the Dashboard is showing the correct number of tables I have created but when I try and browse all tables I am receiving: No wpDataTables in the system yet.
This means I can't access to make any changes to my created tables.
Hi, Paul.
If you do not see the tables in the wpDataTables table list, in the back-end;
you most probably have MySQL version 5.6.x installed on the hosting server.
Our developers discovered that the support for MySQL version 5.6 has stopped/
it no longer supports specific JSON functions that our plugin uses to load this 'browse tables' list properly. ( Reference about that here)
The best solution will be to change the MySQL version on the server, either to the older 5.5 ,
or any newer version, such as MySQL 5.7 or 8.0, or higher.
(If you don't know how to do that, please check with your hosting support if they can change the MySQL version on the server).
2. Or, if it is not currently possible for you to change the MySQL version on the hosting server,
our developers made this edited PHP file fix that you can use.
You can download it from my weTransfer on this link;
please upload it to your FTP and overwrite the file in this path:
wp-content/plugins/wpdatatables/source/class.wdtbrowsetable.php
That should fix the issue of tables not loading on the list in the back-end.
Let me know if it 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
Thanks Miloš,
The php file fix worked a treat.
Regards
Paul
Hi, Paul.
Just wanted to notify you that our developers just launched a new Update that has a permanent fix implemented for this issue of the "browse tables page" not showing tables correctly in the back-end.
Please update your plugin to latest Version 5.4.1.
A minor update with bug fixes: BugFix: Fixed issue with browse page not loading when using SQL 5.6.x versions. Other small bug fixes.
Updating the plugin to the latest version
And we recommend to purge cache of the site after updating.
This should fully resolve the issue going forward.
Let us know if you have any questions.
Thank you.
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