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 PrivateReply so nobody can see them except us.
basically I have a bunch of pages where different data tables are loaded... i can see I have more than 70 data tables and they are used in different pages.
My suggestion for the tables that have less than 2000 entries and if they are server side ( manual or Mysql tables) is to disable the server side processing for them. So for tables that have less than 2000 entries can you please uncheck the server side option.
The plugin simply doesn't allow me to remove the server side processing so I still have the same problem, i.e. the filter functionality returns a "No matching records found" message.
can you please help.
anyway, is this just "MY" problem? also, this was all working very smoothly before last plugin update release.
No, adgwv, it's not just your problem. I have the same issue after updating from 1.7 to 2.0.2. I have a table with over 95 thousand records. In V1.7, Advanced Filtering worked fine with Server Side Processing enabled. In 2.0.2, the result is always "no matching records". Attempting to disable Server Side Processing results in an error.
Bogdan below provided a temporary solution to allow me to disable Server Side Processing for large tables. Albeit this worked for a while, now it doesn't anymore.
Hello, I am having the same issue. I have about 100 tables (all with views) and most have more than 2000 rows. Plug-in will not allow me to turn off server-side processing and filtering is not working. I was hoping to go live this week, but without the filtering, I will have delay.
Edit: I found that I have a semi-colon after the select statements. When I removed this, the filters started working. Hopefully, this works on all the tables.
Hi Bogdan, it's Alessio here, I do work with Antonio.
As for the issue with the filters, unfortunately they are still not working. I created a page with [wpdatatable id=84] only and it does load. Actually that table is like kriptonite because the whole wordpress crashes :O
Can you please help us? Restoring the table is top priority for our website!
Here is the link to the WP dashboard (you should have the access to it if I remember correctly):
as far as I know we made no changes to server - it's running php 5.5 and on our side the plugin (updated to the last version) works all good, besides the problem we have with the server side processing of large tables
This is the link to main WP dashboard link, if it may be of help:
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
Bogdan has gone on vacation so I'll take this ticket.
We notice that you are using table that is not in same database where is wordpress. Because of that my suggestion is to turn on Separate MySQL connection and set connection with that obbligazioniDB database.
Then use query's without concating database name for tables like this:
Also my suggestion is to remove oldest version of plugin from plugin directory, because you can have some issue if you have two same plugin in plugin directory(it doesn't meter if they active or not it should be only one)
a) tables behavior and database connections are working PERFECTLY on all tables (like here for instance http://obbligazioni.io/le-obbligazioni-usd/) . in these tables Server Side processing is NOT ENABLED - so the filters can work properly. These tables are relatively small (1k rows) so all good.
b) EXCEPT the only ONE table that doesn't work (because it's too big 5000+ rows), where we created 2 versions, to isolate the problem
1st version: http://obbligazioni.io/big-list/ (this table has Server Side processing ENABLED - so the FILTERS dont work - but at least the table/page loads)
We are focused on problem with filtering the table and our suggestion will help you. I will try to explain why some of the tables are working and some of the tables are not working
When you make table from query and turn off serverside processing, all the data are loaded so filtering working because javascript is responsible for filtering the data.(it's working because all data is loaded)
When you make table form query with turn on serverside processing, it is loaded just one part of the data, so when you try to filter the data plugin use that query for returning data from database. Because your query contains prefix of the database, wpDataTables server has problems with parsing of the query and building new queries dynamically and that cause resulting no data after filtering.
So when you set Separate Mysql connection to the obbligazioniDB database and then use queries without prefix for database(for example SELECT ISINLINK, DESCRIPTION, MATU, CCY, EXCH, YTMS, RATINGSPB, MINPIECEB FROM BIGTABLE) filter will work.
If you will use some complicated queries then we suggest to 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″.
hi there
today we noticed that Filters are not working on the tables on our website
here is an example
http://obbligazioni.io/le-obbligazioni-usd/
can you please help so that we can resume full functionality.
thanks, Antonio
HI Antonio,
Thank you for your purchase.
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,
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
Hi Antonio,
No problem at all.
Can you please try to make a VIEW in phpmyadmin or any other database management system and see if the query will return the desired results.
Thank you.
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
hi Bogdan
not sure I get what you mean
if I access the DB and I run a SELECT query like this one ... it works
SELECT ISINLINK, DESCRIPTION, MATU, CCY, EXCH, YTMB, SUBORDINATEDB, CALLABLEB, MINPIECEB FROM obbligazioniDB.BIGTABLE
WHERE (CCY LIKE '%USD%')
if I run this
CREATE VIEW myview
AS SELECT ISINLINK FROM obbligazioniDB.BIGTABLE;
it doesnt work.
the SELECT works properly and that why in this page you can see all the "USD" items
http://obbligazioni.io/le-obbligazioni-usd/
problem is when I write in the search boxes under each column and WHATEVER I write, it shows >> "No matching records found"
Hi Antonio,
Can you please check now.
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
yeah - absolutely.
now that page works as a charm.
how do I get the other tables to work like that?
For instance, this page has another table, and it doesn't work properly.
http://obbligazioni.io/big-list/
thanks
Hi Antonio,
Glad that we solved that issue.
Unfortunately i can not access the other link ( attachment) .
Can you please investigate.
Thank you.
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
try this one
http://obbligazioni.io/ita/
basically I have a bunch of pages where different data tables are loaded... i can see I have more than 70 data tables and they are used in different pages.
how to I amend them so that they behave like [wpdatatable id=70], the one here http://obbligazioni.io/le-obbligazioni-usd/ (that you have already modified).?
I have the feeling that you just deactivated the server side processing, is that it?
so basically if the server side processing is active, users cannot "filter" the table? is this interpretation correct?
Hi Antonio,
My suggestion for the tables that have less than 2000 entries and if they are server side ( manual or Mysql tables) is to disable the server side processing for them.
So for tables that have less than 2000 entries can you please uncheck the server side option.
I did that for one of your table.
Let me know the result.
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
alright i ll do it and let you know if any issues.
thanks
Hi Antonio,
You are welcome.
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
hi Bogdan,
I've fixed almost all tables by removing "server side processing". This worked on all tables with less than 1000 entries.
But this fix doesn't work on this page where I have a 5k-row table
http://obbligazioni.io/big-list/
The plugin simply doesn't allow me to remove the server side processing so I still have the same problem, i.e. the filter functionality returns a "No matching records found" message.
can you please help.
anyway, is this just "MY" problem? also, this was all working very smoothly before last plugin update release.
thanks, Antonio
hi Bodgan
this seemed to solve the issue for a while but now it's not working properly again.
it looks like if I ENABLE serverside processing the FILTERS are not working properly on http://obbligazioni.io/big-list/
if I DISABLE serverside process the TABLE is not showing at all on http://obbligazioni.io/big-list/
but the weirdest thing is that if i DISABLE serverside processing
1st the toggle button on wp-admin still shows it's enabled (while it's not)
2nd the table on the wp-admin filters correctly!!
so I think to DISABLE serverside process is the good path BUT the table doesnt load on http://obbligazioni.io/big-list/
I'm attaching few images to make it all clearer.
Hi Antonio,
Can you pleases tell me which number is set from the code that I provided you in the post below.
Is it still 10000.
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
yes it is . I've just checked it.
No, adgwv, it's not just your problem. I have the same issue after updating from 1.7 to 2.0.2. I have a table with over 95 thousand records. In V1.7, Advanced Filtering worked fine with Server Side Processing enabled. In 2.0.2, the result is always "no matching records". Attempting to disable Server Side Processing results in an error.
yeah Chuck - exactly what I'm experiencing.
Bogdan below provided a temporary solution to allow me to disable Server Side Processing for large tables. Albeit this worked for a while, now it doesn't anymore.
so I'm still waiting for the solution.
Hello, I am having the same issue. I have about 100 tables (all with views) and most have more than 2000 rows. Plug-in will not allow me to turn off server-side processing and filtering is not working. I was hoping to go live this week, but without the filtering, I will have delay.
Edit: I found that I have a semi-colon after the select statements. When I removed this, the filters started working. Hopefully, this works on all the tables.
website is working properly...
http://obbligazioni.io/big-list/
Bogdan I feel we are not getting anywhere here... I just to make sure, do you "see" the problem with the "filter" function?
i'm just taking another screenshot so that we are sure.
Hi Antonio,
Now I can see the table without any problems and I can see the issue with the filtering.
Can you just for the testing purposes put the [wpdatatable id=84] on that page and tell me do you still have the issue.
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
Hi Bogdan, it's Alessio here, I do work with Antonio.
As for the issue with the filters, unfortunately they are still not working. I created a page with [wpdatatable id=84] only and it does load. Actually that table is like kriptonite because the whole wordpress crashes :O
Can you please help us? Restoring the table is top priority for our website!
Here is the link to the WP dashboard (you should have the access to it if I remember correctly):
http://obbligazioni.io/wp-admin/post.php?post=2971&action=edit
and here the link to the page:
http://obbligazioni.io/big-list-last/
Thanks a lot, Alessio
Hi Alessio,
I can not even access your plugins page on main WP dashboard.
This can be related to server performance.
Can you please tell me do you have recent changes on your server.
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
Hi Bogdan,
as far as I know we made no changes to server - it's running php 5.5 and on our side the plugin (updated to the last version) works all good, besides the problem we have with the server side processing of large tables
This is the link to main WP dashboard link, if it may be of help:
http://obbligazioni.io/wp-admin/index.php
The page in question - with table 84 - is in Pages >> BIG LIST-LAST
Let me know if you can access the dashboard!
Thanks, Alessio
Hi Alessio,
Can you please tell me did you try to check the server log after this crash and see if there are some errors.
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
Hi Bogdan,
I haven't checked because I am not well acquainted with log files, to be honest.
However I sent you a WeTransfer email with attached what I guess are the files in question.
Please let me know if I got it right.
Thank you!
Alessio
Hi Alessio,
This can be the issue ( attachment )
The both plugin versions are there and that can cause this problems because now I was not able to access our plugin dashboard at all.
Also i investigated your server log and there are no error reports from our plugin.
Can you please tell me did you followed this steps when updating the plugin manualy.
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.
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
hi Bogdan
the one you describe is the procedure we followed to install the new version of the plugin
the plugin dashboard works correctly at this link http://obbligazioni.io/wp-admin/admin.php?page=wpdatatables-administration - I'm attaching a screeshot showing you that plugins are installed and activated correctly.
also the table (5000+ rows) in this page http://obbligazioni.io/big-list/ works correctly (besides the usual filter bug)
while the table (1000+ rows) in this page for example http://obbligazioni.io/le-obbligazioni-usd/ works correctly (INCLUDING the filter, since it's a smaller table).
so essentially it looks like it's just a filter problem with large tables.
I'm attaching you again the screenshot of the filter problem, so that we can stay focused on the problem and find a solution.
Hi Antonio,
Sorry for late response.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
Bogdan has gone on vacation so I'll take this ticket.
We notice that you are using table that is not in same database where is wordpress. Because of that my suggestion is to turn on Separate MySQL connection and set connection with that obbligazioniDB database.
Then use query's without concating database name for tables like this:
Also my suggestion is to remove oldest version of plugin from plugin directory, because you can have some issue if you have two same plugin in plugin directory(it doesn't meter if they active or not it should be only one)
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
HI Milan
thanks for helping out.
I can do what you say but pls consider that
a) tables behavior and database connections are working PERFECTLY on all tables (like here for instance http://obbligazioni.io/le-obbligazioni-usd/) . in these tables Server Side processing is NOT ENABLED - so the filters can work properly. These tables are relatively small (1k rows) so all good.
b) EXCEPT the only ONE table that doesn't work (because it's too big 5000+ rows), where we created 2 versions, to isolate the problem
1st version: http://obbligazioni.io/big-list/ (this table has Server Side processing ENABLED - so the FILTERS dont work - but at least the table/page loads)
2nd version: http://obbligazioni.io/big-list-last/ (this table has Server Side processing NOT ENABLED so the table crashes)
so all your suggestions should focus on this:
- making a (LARGE or SMALL) table work with Server Side processing ENABLED (so solving the filter problem)
it's not a connection problem, it's just the plugin not handling correctly the filters when Server Side process is ENABLED.
Hi Antonio,
We are focused on problem with filtering the table and our suggestion will help you. I will try to explain why some of the tables are working and some of the tables are not working
When you make table from query and turn off serverside processing, all the data are loaded so filtering working because javascript is responsible for filtering the data.(it's working because all data is loaded)
When you make table form query with turn on serverside processing, it is loaded just one part of the data, so when you try to filter the data plugin use that query for returning data from database. Because your query contains prefix of the database, wpDataTables server has problems with parsing of the query and building new queries dynamically and that cause resulting no data after filtering.
So when you set Separate Mysql connection to the obbligazioniDB database and then use queries without prefix for database(for example SELECT ISINLINK, DESCRIPTION, MATU, CCY, EXCH, YTMS, RATINGSPB, MINPIECEB FROM BIGTABLE) filter will work.
If you will use some complicated queries then we suggest to 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″.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Thanks Milan
I applied exactly what you were so kind to explain and now the filters work properly.
We've been struggling with this for MONTHS - not it's all solved thanks to your intervention in couple of days.
I cannot thank you enough.
best, Antonio
Hi Antonio,
You are welcome. Glad that we solved the issue.
If you have any more issues feel free to open a new ticket, we will gladly help.
We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. It means to us. Thanks!
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables