Today looking at administration panel in dashbord of WPDataTable I see that there is 12 tables but in wpDataTables page no table is show and the list of created tables is empty.
Sorry, i forgot to send you that file as attachment, here it is.
So, i recommend the best solution will be if you can change the MySQL version installed on the hosting WordPress server, from 5.6x to older 5,5 or any newer ones like 5.7 , 8.0 and newer;
but if you're not able to do that,
then you can upload this PHP file to your FTP and overwrite the file in this path:
Hello,
Today looking at administration panel in dashbord of WPDataTable I see that there is 12 tables but in wpDataTables page no table is show and the list of created tables is empty.
By the way the table can be edit using link like https://www.prometeo2050.org/wp-admin/admin.php?page=wpdatatables-constructor&source&table_id=22 but it not show in table list.
How i can resolve this issue?
I enclose the screenshoot of the dashboard and a screenshot of table listing.
Attached files: Schermata 2023-03-03 alle 12.08.18.png
Schermata 2023-03-03 alle 12.08.25.png
Hi, Paolo.
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 fix that you can use, with an edited code of our plugin.
I am sending you this edited PHP file as attachment,
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
Hi, Paolo.
Sorry, i forgot to send you that file as attachment, here it is.
So, i recommend the best solution will be if you can change the MySQL version installed on the hosting WordPress server, from 5.6x to older 5,5 or any newer ones like 5.7 , 8.0 and newer;
but if you're not able to do that,
then you can upload this PHP file 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 us know how it goes. Thanks.
Attached files: class.wdtbrowsetable.zip
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