The version You have is about 2 or 3 years old. How many tables do You have?
Which PHP version do You use?
Just in case, create a backup to all the tables and to the plugin, because updating to the newest version from a version this old could result in some issues.
We released version 2.4 last week.
My suggestion is to update the plugin manually by following these steps:
I tried recreating the issue locally. I installed wpDataTables 1.6 and updated WordPress to 5.0.1; created two tables - one manually and one using a SQL query, but I couldn't replicate the issue.
Please provide me a temporary WP-admin login 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 party. You can write credentials here just check Private Reply so nobody can see them except us.
Thank you for your effort trying to help. The tables contain sensitive data and my company would not allow to do that.
In my first message you will find attached a screenshot with the DevTools error screenshot. It is a WP multi-site 5.0.1 if this makes any difference. When WP was <5 it was working fine (with the same multi-site installation).
After further investigations I saw in the DevTools console it is something related with _ (underscores / lodash?) the exact error is attached in the screenshot. Probably datatables bundles lodash / underscores? and now in WordPress 5.0.1 wordpress also shiped its own version of lodash ==> incompatibility.
Please read the Vendor paragraph from here - it says WordPress is now bundling lodash which could generate trouble
After inspection, we found that lodash doesn't have anything to do with the issue You're having. It could, however, be linked to some server settings, theme settings, other plugins, etc.
We successfully tested wpDataTables 1.6.0 with WordPress 5.0.1 in our local environment, and they displayed normally on a live site. We've created the tables using all possible methods our plugin offers, and couldn't replicate the issue You're describing.
Our advice would be to update the plugin after all. Previous versions of the plugin may not be secure or stable and are available for testing purposes only.
The same server settings, theme settings and other plugins were working fine before WordPress 5.0 update and are working fine now after upgrading. I have difficulties only with wpDatatables. I only describe the current troubles and don't get me wrong I am not saying wpDatatables is not a good product it is quite the opposite I am very happy what I could do with your plugin.
Can you please give me a brief description what kind of work should I expect to do when upgrading from 1.6 to wpDatatables 2.4? What kind of manual work I am expected to do? What might break and I will need to manually correct? I am curious to get an idea of the amount of work required to upgrade wpDatatables when there are ~80 tables (all are SQL query based).
I understand what You mean. We thank You for those kind words!
Honestly, I cannot say how much work You'll have on Your hands. Good thing is that all Your tables are SQL query based, so they shouldn't give You that many issues like Excel, CSV or Google Spreadsheet tables would. There have been a lot of design and layout changes since 1.6, and You can see and test the newest version on our sandbox site.
Please, please, make sure to back up everything.
Before You update, the only other solution I would have for You would be for me to send You the 1.6.1 version I used for testing with WP 5.0.1. Also, if (when) You decide to update to 2.4 I can send 1.6.1 to You in case 2.4 doesn't work the way You'd expect it to.
The tables settings will remain or will be lost after upgrading? If I only replace the wpDatatables1.6 folder with a new wpDatatables 2.4 folder in the plugins folder what results should I expect?
I can't say if all table settings would be lost. If You follow the update manual from our documentation, it should only update the plugin without affecting the tables. However, as I mentioned, since this is an old version of the plugin, a lot of the settings have been moved, changed or even removed. Therefore, I cannot exactly say what's going to happen with the tables when You update the plugin (replace the wpDataTables folder).
IMPORTANT: Do NOT delete the old version from WP-admin (by clicking “Delete” in the plugins page). If you do, you will lose all your tables!
OK - I'll try to ask SiteGround to rollback to the previous version of WordPress before 5.0 and also ask them to "lock" my WordPress installation so it will never upgrade to 5.0 - for me it is more important to have the current solution working reliably than to have the newest and the greatest.
Thank you for trying to help. I hope that by rolling back WP will continue to work the way it was last week. I don't see any reason why not - the JS error should disappear after rolling back and the database content I don't think was affected by the upgrade (and I hope it was not). Just last Friday I finished +1 month of additional work with that solution (after many more months before) so if Monday morning the immediate week all crashes because of an auto-update and I have to start all over again this will be bad for me. Auto-updates are nice when done on simple software which works but when done on top of some serious customization work which starts to fail after - this is not nice.
It went fine SiteGround restored the database also I only had to manually re-enter 1 record in the database. All the rest is fine the same it was before the incident. Thank you for your help.
wpDatatables
Some feedback now (constructive, I hope) - I am a heavy user of wpDatatables and it helped me a ton. I have a strong developer background in Java mostly but enough in WordPress and PHP also. I am also aware of your new versions of wpDatatables and what they contain. If I am to suggest you a feature for wpDatatables it is to add, in addition to the existing User Interface based settings, an PHP API to define the same wpdatatables settings. The UI settings are great and should remain there and the PHP api should be an addition (which should "mirror" the UI settings).
Being a developer I still see value in wpDatatables (vs. the plain Datatables.net let's say) but when I reached having 80 tables it became a little cumbersome to manage all the tables using the UI - the WordPress UI interface is slow to click and open and for searching things - At that point I wished to be able to define my tables in an PHP api, to do modifications in PHP and then to checkin changes on github. Now I cannot do github checkin for the tables "source code" because settings are saved in the database through the UI. I see a lot of value in wpDatatables but when thinking to the next implemetation I have a doubt "why I don't do directly in Laravel? there I can check-in in github and have a nice developer workflow" - For WordPress using new tools like https://roots.io (BedRock, Sage) I can start using github more for WordPress too - but wpDatatables does not have a PHP api for developers ==> so I am forced to do things the "old WP way, using the user interface and not by checking code on github"
wpReportBuilder
I am also a customer of wpReportBuilder. Consider adding PDF generation as a new feature. All business users are using PDF but not all business users are using Word. The same add PDF generation as a complementary feature to your existing Word and Excel generations.Word is good to be used as "templating" engine the way you use it already - but PDF is better suited for generating the reports - everybody can open PDF documents.
Thank You for Your feedback. It is much appreciated.
I forwarded Your suggestions to our development team, for them to review and maybe consider adding in one of our next updates. We do carefully follow customers requirements and try to implement most of them if they appear in requests from time to time, so we will add this to our idea list and look into some possible solutions on plugin side in the future.
Please see attachment
Hello 22459.
Thank You for Your purchase.
The version You have is about 2 or 3 years old. How many tables do You have?
Which PHP version do You use?
Just in case, create a backup to all the tables and to the plugin, because updating to the newest version from a version this old could result in some issues.
We released version 2.4 last week.
My suggestion is to update the plugin manually by following these steps:
1.) Download zip from this link
2.) Use FTP to open /yourwordpressfolder/wp-content/plugins
3.) Delete existing wpdatatables folder.
4.) Upload previously downloaded wpdatatables folder through FTP to plugins folder (unzip it)
5.) Go to WP-admin panel, open Plugins section.
6.) Deactivate wpDataTables, and then activate it again.
7.) Clear server and browser cache
IMPORTANT: Do NOT delete the old version from WP-admin (by clicking “Delete” in the plugins page) if you don’t want to lose all your tables!
Please let me know if the plugin works after update.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
I cannot update because I have 70+ tables and If I update I need to do changes and test all over again which will take lots of time.
I understand, 22459.
Can You tell me which PHP version are You using?
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Debug Information
WordPress Version: 5.0.1
PHP Version: 7.0.33
MySQL Version: 5.6.40
Any news on this?
Hello again 22459.
I tried recreating the issue locally. I installed wpDataTables 1.6 and updated WordPress to 5.0.1; created two tables - one manually and one using a SQL query, but I couldn't replicate the issue.
Please provide me a temporary WP-admin login 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 party. You can write credentials here just check Private Reply so nobody can see them except us.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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 Aleksandar,
Thank you for your effort trying to help. The tables contain sensitive data and my company would not allow to do that.
In my first message you will find attached a screenshot with the DevTools error screenshot. It is a WP multi-site 5.0.1 if this makes any difference. When WP was <5 it was working fine (with the same multi-site installation).
Please see attached.
After further investigations I saw in the DevTools console it is something related with _ (underscores / lodash?)
the exact error is attached in the screenshot. Probably datatables bundles lodash / underscores? and now in WordPress 5.0.1 wordpress also shiped its own version of lodash ==> incompatibility.
Please read the Vendor paragraph from here - it says WordPress is now bundling lodash which could generate trouble
https://make.wordpress.org/core/tag/5-0/
Hello again 22459.
After inspection, we found that lodash doesn't have anything to do with the issue You're having. It could, however, be linked to some server settings, theme settings, other plugins, etc.
We successfully tested wpDataTables 1.6.0 with WordPress 5.0.1 in our local environment, and they displayed normally on a live site. We've created the tables using all possible methods our plugin offers, and couldn't replicate the issue You're describing.
Our advice would be to update the plugin after all. Previous versions of the plugin may not be secure or stable and are available for testing purposes only.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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 Aleksandar,
The same server settings, theme settings and other plugins were working fine before WordPress 5.0 update and are working fine now after upgrading. I have difficulties only with wpDatatables. I only describe the current troubles and don't get me wrong I am not saying wpDatatables is not a good product it is quite the opposite I am very happy what I could do with your plugin.
Can you please give me a brief description what kind of work should I expect to do when upgrading from 1.6 to wpDatatables 2.4? What kind of manual work I am expected to do? What might break and I will need to manually correct? I am curious to get an idea of the amount of work required to upgrade wpDatatables when there are ~80 tables (all are SQL query based).
Thank you.
Hello again 22459.
I understand what You mean. We thank You for those kind words!
Honestly, I cannot say how much work You'll have on Your hands. Good thing is that all Your tables are SQL query based, so they shouldn't give You that many issues like Excel, CSV or Google Spreadsheet tables would. There have been a lot of design and layout changes since 1.6, and You can see and test the newest version on our sandbox site.
Please, please, make sure to back up everything.
Before You update, the only other solution I would have for You would be for me to send You the 1.6.1 version I used for testing with WP 5.0.1. Also, if (when) You decide to update to 2.4 I can send 1.6.1 to You in case 2.4 doesn't work the way You'd expect it to.
Please let me know what You decided.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
The tables settings will remain or will be lost after upgrading? If I only replace the wpDatatables1.6 folder with a new wpDatatables 2.4 folder in the plugins folder what results should I expect?
Hello again.
I can't say if all table settings would be lost. If You follow the update manual from our documentation, it should only update the plugin without affecting the tables. However, as I mentioned, since this is an old version of the plugin, a lot of the settings have been moved, changed or even removed. Therefore, I cannot exactly say what's going to happen with the tables when You update the plugin (replace the wpDataTables folder).
IMPORTANT: Do NOT delete the old version from WP-admin (by clicking “Delete” in the plugins page). If you do, you will lose all your tables!
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
OK - I'll try to ask SiteGround to rollback to the previous version of WordPress before 5.0 and also ask them to "lock" my WordPress installation so it will never upgrade to 5.0 - for me it is more important to have the current solution working reliably than to have the newest and the greatest.
I understand, 22459.
If, however, You still experience some issues when You rollback to the previous version, please let us know so that we can try help You out.
I hope You won't have any issues, though.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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 Aleksandar,
Thank you for trying to help. I hope that by rolling back WP will continue to work the way it was last week. I don't see any reason why not - the JS error should disappear after rolling back and the database content I don't think was affected by the upgrade (and I hope it was not). Just last Friday I finished +1 month of additional work with that solution (after many more months before) so if Monday morning the immediate week all crashes because of an auto-update and I have to start all over again this will be bad for me. Auto-updates are nice when done on simple software which works but when done on top of some serious customization work which starts to fail after - this is not nice.
Yes, I fully agree.
Updating WordPress, or rollback for that matter, shouldn't have any effect on the plugins whatsoever.
Also, make sure to disable auto-update if everything goes back to what it was before the update. Just in case.
Best of luck, and please let me know how it went.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
It went fine SiteGround restored the database also I only had to manually re-enter 1 record in the database. All the rest is fine the same it was before the incident. Thank you for your help.
wpDatatables
Some feedback now (constructive, I hope) - I am a heavy user of wpDatatables and it helped me a ton. I have a strong developer background in Java mostly but enough in WordPress and PHP also. I am also aware of your new versions of wpDatatables and what they contain. If I am to suggest you a feature for wpDatatables it is to add, in addition to the existing User Interface based settings, an PHP API to define the same wpdatatables settings. The UI settings are great and should remain there and the PHP api should be an addition (which should "mirror" the UI settings).
Being a developer I still see value in wpDatatables (vs. the plain Datatables.net let's say) but when I reached having 80 tables it became a little cumbersome to manage all the tables using the UI - the WordPress UI interface is slow to click and open and for searching things - At that point I wished to be able to define my tables in an PHP api, to do modifications in PHP and then to checkin changes on github. Now I cannot do github checkin for the tables "source code" because settings are saved in the database through the UI. I see a lot of value in wpDatatables but when thinking to the next implemetation I have a doubt "why I don't do directly in Laravel? there I can check-in in github and have a nice developer workflow" - For WordPress using new tools like https://roots.io (BedRock, Sage) I can start using github more for WordPress too - but wpDatatables does not have a PHP api for developers ==> so I am forced to do things the "old WP way, using the user interface and not by checking code on github"
wpReportBuilder
I am also a customer of wpReportBuilder. Consider adding PDF generation as a new feature. All business users are using PDF but not all business users are using Word. The same add PDF generation as a complementary feature to your existing Word and Excel generations. Word is good to be used as "templating" engine the way you use it already - but PDF is better suited for generating the reports - everybody can open PDF documents.
Hello 22459.
Thank You for Your feedback. It is much appreciated.
I forwarded Your suggestions to our development team, for them to review and maybe consider adding in one of our next updates. We do carefully follow customers requirements and try to implement most of them if they appear in requests from time to time, so we will add this to our idea list and look into some possible solutions on plugin side in the future.
Until then - best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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