I've installed the wpdatatables v2.4 plugin which I've just purchased, and cannot create any table based on SQL query.
Below in an error I see on the red popup window . Please help me sort it out.
There was an error while trying to save the table! parsererror Handle the form{"table":{"id":4,"title":"New wpDataTable","show_title":1,"table_type":"mysql","connection":"","content":"select id from 42_clients","filtering":1 ...
If your MySQL-query based wpDataTable doesn’t work correctly with server-side processing, probably this is happening because wpDataTables server has problems with parsing of the query and building new queries dynamically (rarely happens, but does sometimes). To avoid this please prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.
Please note some this when working with the server-side processing feature:
Please do not use “LIMIT” in the SELECT statement. wpDataTables adds it automatically and it will be overridden.
Please do not use “ORDER BY” in the SELECT statement. wpDataTables has its own sorting engine so it makes no sense to use MySQL’s sorting, since it will be overridden. Also, server-side processing feature adds this part of statement automatically when users trigger the sorting on the front-end, and having it in initial statement may cause the table to crash.
If this doesn't help, could you please show us the query here, and 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.
I was running simple query like 'select * from wp_posts'. Tried different combinations with and without listing the fields in select statement, but no luck.
I logged in and saw what you're talking about. There could be a few things causing the issue.
So, please tell me - did you update the previous version of wpDataTables, or is this a brand new install? If so, I see you managed to create a few tables, so I need to know if you can remember when did this start happening?
I tried to modify our class.wdttools.php file, but came up with an error (see attachment). Basically, something is preventing me from modifying the files without FTP access.
Do you have mod_security enabled, or some security plugin installed? This can cause a JSON response like this, because it breaks before loading anything on the page. That is it can't pass the admin-ajax call, and we're using the WordPress' built-in admin-ajax.
Please let me know if disabling mod_security or the security plugin resolves the issue. Please try to remember if you changed anything right before the issue came up. Also, if not, could you provide me with FTP and PHPMyAdmin access, so I can try something in our plugin there?
Yes, previously I had lite version installed, but it couldn't let me create tables based on SQL. Then someone borrowed me the 2.1 version for test. I've managed to make the tables, and they were working fine for few days. Then everything broken up and I've started to see the errors I've posted before. SO I've removed plugin and all the data related to wpdatatables from wp_posts table. And decided to setup the officially bought plugin. But after setup I see the same errors.
Will check details about mod_security and let you know.
Is there a way to completely cleanup all the data related to wpdatatables and reinstall the plugin from scratch. I suspect there is some piece of older code or somethings cached in DB or some file outside the plugin folder, which prevents plugin from correct work...
I was playing around with fix for editing data from wp interface and found out that one of other plugins prevents files from being saved correctly. After de-activation of this plugin wptableforms started working correctly... I have some other questions still but I think it is better to create separate topic for them.
I've installed the wpdatatables v2.4 plugin which I've just purchased, and cannot create any table based on SQL query.
Below in an error I see on the red popup window . Please help me sort it out.
There was an error while trying to save the table! parsererror Handle the form{"table":{"id":4,"title":"New wpDataTable","show_title":1,"table_type":"mysql","connection":"","content":"select id from 42_clients","filtering":1 ...
See the full error text in attach.
Hello mastaBo.
Thank you for your purchase.
If your MySQL-query based wpDataTable doesn’t work correctly with server-side processing, probably this is happening because wpDataTables server has problems with parsing of the query and building new queries dynamically (rarely happens, but does sometimes). To avoid this please prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.
Please note some this when working with the server-side processing feature:
If this doesn't help, could you please show us the query here, and 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
Hello Alexandar,
I was running simple query like 'select * from wp_posts'. Tried different combinations with and without listing the fields in select statement, but no luck.
Will share the tmp account with you.
Regards,
Vladimir
In some cases I can see an error like in attachment as well.
Hello Vladimir.
Sorry for the late response.
I logged in and saw what you're talking about. There could be a few things causing the issue.
So, please tell me - did you update the previous version of wpDataTables, or is this a brand new install? If so, I see you managed to create a few tables, so I need to know if you can remember when did this start happening?
I tried to modify our class.wdttools.php file, but came up with an error (see attachment). Basically, something is preventing me from modifying the files without FTP access.
Do you have mod_security enabled, or some security plugin installed? This can cause a JSON response like this, because it breaks before loading anything on the page. That is it can't pass the admin-ajax call, and we're using the WordPress' built-in admin-ajax.
Please let me know if disabling mod_security or the security plugin resolves the issue. Please try to remember if you changed anything right before the issue came up. Also, if not, could you provide me with FTP and PHPMyAdmin access, so I can try something in our plugin there?
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
Hello Alexandar,
Thanks for you reply.
Yes, previously I had lite version installed, but it couldn't let me create tables based on SQL. Then someone borrowed me the 2.1 version for test. I've managed to make the tables, and they were working fine for few days. Then everything broken up and I've started to see the errors I've posted before. SO I've removed plugin and all the data related to wpdatatables from wp_posts table. And decided to setup the officially bought plugin. But after setup I see the same errors.
Will check details about mod_security and let you know.
Is there a way to completely cleanup all the data related to wpdatatables and reinstall the plugin from scratch. I suspect there is some piece of older code or somethings cached in DB or some file outside the plugin folder, which prevents plugin from correct work...
Regards, Vladimir
Hello Alexandar,
I was playing around with fix for editing data from wp interface and found out that one of other plugins prevents files from being saved correctly. After de-activation of this plugin wptableforms started working correctly... I have some other questions still but I think it is better to create separate topic for them.
Thanks for your help.
Vladimir
Hi Vladimir,
Hope that everything will work now.
If you have any more issues or questions feel free to open a new ticket.
Best regards.
Kind Regards,
Miloš Jovanović
[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