I love your Plugin we have been using it for years.
We just updated from 1.7.2 to Version 2.5.1 and now when we filter data it shows “Showing 0 to 0 of 0 entries (filtered from 3,625 total entries)” when “Server-side processing” is turned on, We did not have this issue on 1.7.2 (If we use a table less then 2,000 entries and “Server-side processing" turned off the Filter works correctly)
The filtering works correctly when “Server-side processing” is turned off, but we need to have it turned on for editing. Side note editing works with no issues.
Is there any known issues with RDS on AWS? We are happy to renew Support if that would help.
Any extra ports other then 3306 needed for the "Server-side processing"?
We'll try and help you out without renewing support. Please note, though, that we do not provide support via Skype, Zoom, TeamViewer or similar, only through tickets.
What I can do is log into your website and see what I can find.
When looking at your screenshot, I can first recommend one thing: Change the sql query to this:
SELECT * FROM hmr
and see if that works. if it doesn't, include the database as well, but without accent graves ( ` ).
From version 2.3 we've implemented a feature that you can use multiple separate DB connections for MySQL, MSSQL and PostgreSQL. For MySQL engine we are dynamically adding the accent grave ( ` ), so there's no need to use it around the table name in the query. If you were to delete them, searching and filtering should work just fine.
So WP Data Tables plugin will run normally with "Server Side Processing" turned off BUT when it turns on, automatically at 2,000 rows, all queries will need to be rewritten that have ( ` ) removed or the filters stop working. That sounds like a time bomb for new users who copy as paste from views MYSQL workbench to WP Data Tables, They are just filled with ( ` ).
I will make a backup of our wordpress then start rewriting our 200 tables now. How would I include the Schema name with the above changes?
IE
SELECT * FROM hmrex.hmr
OR
SELECT * FROM hmrex2.hmr
~~~~~~~~~~~~~~~~~
SELECT * FROM hmrex hmr
OR
SELECT * FROM hmrex2 hmr
Both do not work for filtering
I have to remove the hmrex or hmrex2 as well for the filtering to start working again. Is there any way to just use the old "feature"? or another way around this issue?
"It just Worked" before the changes. Now there will be a mismatch between what we write in MYSQL workbench and WP Data Tables and that is worrying.
Side-note - our dashboard is internal and the URL I use will not work for you, as you are outside the network. Please let me know if you need any more screenshots.
Is there anything in your road map to resolved the above issue?
Like I mentioned in my previous replies - from version 2.3 we implemented separate DB connections, and that is when we had to rewrite the code, and using accent graves ( ` ) proved to have issues like you're experiencing now.
1.7.2 was released over 2 years ago, and a lot has changed since then. I can forward the issue to our development team, so they can take a look at it, though, but it is something we've been battling with.
Another thing you can try is creating a view in the database using your original query, and then pulling that query through wpDataTables, like
SELECT * FROM view
That should also help.
If I understood you correctly - this doesn't return any results?
SELECT * FROM hmr
It should, though, since hmrex is the name of the database, right? And hmr is the name of the table?
For the SQL See Private Post
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Select
*
from DB-1.table
Left Join
DB-2.table On (DB-1.id = DB-2.id)
Where
DB-2.id NOT IN (0)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
(Also See Screenshots)
Both Tables would contain `id` for their respective tables.
The above SQL works with server-side processing off and again stops working when Server-side Processing turned back on.
IF I removed ether (DB-1 or DB-2 ) then it fails but If I leave it there then the filters stop working with Server side turned on.
I am unsure if the (`) is the issue, it looks like the DB name.
After a brief inspection, I can say that you were right and it looks like the DB name is the issue with the mentioned tables, and having a dash in it probably causes it to break. I've seen users with issues with the DB names when they added a dot inside the name, so wpDT considered that a db within a db, then followed by a table. However, these users needed to rewrite a table or two, and you have over 150.
Unfortunately, I don't see any quick way around this issue, and neither solution is actually great. You can either revert to 1.7.2 or go about manually changing the queries, and/or DB names. We've had the issue with the accent graves since v.2.3 and it has been present ever since. Our development team is working on finding a fix for the issue, but I cannot say when or if it is going to be implemented.
The logic was changed after v.2.0 so queries that are a bit more complicated return errors like this.
Unfortunately, the best option now is to roll back to 1.7.2. If you can create a staging/testing website with 2.7.1 (released today), and connect this database as a separate DB, I'll try and help you out within the next 2 weeks (too much work, can't make it sooner), so that you can update the plugin, and receive all future updates.
My suggestion is to roll back manually by following these steps:
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!
1. Download the zip folder I've attached here
2. Use FTP to open /your_wordpress_folder/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!
We had to re-add the data base connection Also we had to redo out Custom "URL Link" buttons `SELECT concat("/home/moredata/ ||", count(*)) FROM DB.table` (I have attached Screen shot in case you where interested)
Due to the button changes between the two versions.
But they were expected, Other then that It looks like its up and running again.
Its been a while since I have seen the older interface, it still looks good :)
Thank you for your help with this.
I have made a backup any I am happy to test any new versions if you would like, But it the urgency on solving this is gone as the search is working again.
I'm sorry that you had to do this, but as long as the business is running, right?
Please feel free to download the full version from Envato, and install it on localhost or a non-public website. There you can test all features, and if you have time see how you can get around this issue.
If you ever need any assistance from us, please feel free to open a new ticket, and we'll gladly help.
Hi Support,
I love your Plugin we have been using it for years.
We just updated from 1.7.2 to Version 2.5.1 and now when we filter data it shows “Showing 0 to 0 of 0 entries (filtered from 3,625 total entries)” when “Server-side processing” is turned on, We did not have this issue on 1.7.2
(If we use a table less then 2,000 entries and “Server-side processing" turned off the Filter works correctly)
The filtering works correctly when “Server-side processing” is turned off, but we need to have it turned on for editing.
Side note editing works with no issues.
Is there any known issues with RDS on AWS?
We are happy to renew Support if that would help.
Any extra ports other then 3306 needed for the "Server-side processing"?
Warm Regards
Daniel
Hello Daniel.
Thank you for being our long-term customer.
We'll try and help you out without renewing support. Please note, though, that we do not provide support via Skype, Zoom, TeamViewer or similar, only through tickets.
What I can do is log into your website and see what I can find.
When looking at your screenshot, I can first recommend one thing: Change the sql query to this:
and see if that works. if it doesn't, include the database as well, but without accent graves ( ` ).
From version 2.3 we've implemented a feature that you can use multiple separate DB connections for MySQL, MSSQL and PostgreSQL. For MySQL engine we are dynamically adding the accent grave ( ` ), so there's no need to use it around the table name in the query. If you were to delete them, searching and filtering should work just fine.
Please let me know.
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,
So WP Data Tables plugin will run normally with "Server Side Processing" turned off BUT when it turns on, automatically at 2,000 rows, all queries will need to be rewritten that have ( ` ) removed or the filters stop working. That sounds like a time bomb for new users who copy as paste from views MYSQL workbench to WP Data Tables, They are just filled with ( ` ).
I will make a backup of our wordpress then start rewriting our 200 tables now.
How would I include the Schema name with the above changes?
IE
I have to remove the hmrex or hmrex2 as well for the filtering to start working again. Is there any way to just use the old "feature"? or another way around this issue?
"It just Worked" before the changes. Now there will be a mismatch between what we write in MYSQL workbench and WP Data Tables and that is worrying.
Side-note - our dashboard is internal and the URL I use will not work for you, as you are outside the network.
Please let me know if you need any more screenshots.
Is there anything in your road map to resolved the above issue?
Warm Regards
Daniel
Hi again Daniel.
Like I mentioned in my previous replies - from version 2.3 we implemented separate DB connections, and that is when we had to rewrite the code, and using accent graves ( ` ) proved to have issues like you're experiencing now.
1.7.2 was released over 2 years ago, and a lot has changed since then. I can forward the issue to our development team, so they can take a look at it, though, but it is something we've been battling with.
Another thing you can try is creating a view in the database using your original query, and then pulling that query through wpDataTables, like
That should also help.
If I understood you correctly - this doesn't return any results?
It should, though, since hmrex is the name of the database, right? And hmr is the name of the table?
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,
So we do have more then one:
1. DB-1
2. DB-2
Both Tables would contain `id` for their respective tables.
The above SQL works with server-side processing off and again stops working when Server-side Processing turned back on.
IF I removed ether (DB-1 or DB-2 ) then it fails but If I leave it there then the filters stop working with Server side turned on.
I am unsure if the (`) is the issue, it looks like the DB name.
How can I resolve this?
Daniel
Hello Daniel.
Yeah, I do have a static IP:
178.148.79.105
Unfortunately TeamViewer is not a possibility, and I don't use openVPN.
Let's try with the IP address.
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 again Daniel.
I got a new laptop, and we moved to a new building. Unfortunately, I don't believe the IP address I have now is static.
This is the IP address I have now: 82.117.217.10
That is why I'm getting redirected to the Amazon Web Server log-in page.
Is there another way I could remote in?
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
Hey Daniel
I did manage to log in.
After a brief inspection, I can say that you were right and it looks like the DB name is the issue with the mentioned tables, and having a dash in it probably causes it to break. I've seen users with issues with the DB names when they added a dot inside the name, so wpDT considered that a db within a db, then followed by a table. However, these users needed to rewrite a table or two, and you have over 150.
Unfortunately, I don't see any quick way around this issue, and neither solution is actually great. You can either revert to 1.7.2 or go about manually changing the queries, and/or DB names. We've had the issue with the accent graves since v.2.3 and it has been present ever since. Our development team is working on finding a fix for the issue, but I cannot say when or if it is going to be implemented.
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,
Is there a good way to revert?
I can use our backup from 3 months ago, but ideally I would just like to roll back WP data table.
Right now we are displaying all data and using "control F" instead of a search (works but is really slow)
It only stops working when you use the search within WPDT updating/editing works with no issues,
Is there any backup search we could use?
Or could I have a roll back WP data table patch?
Warm Regards
Daniel
Hello again Daniel.
The logic was changed after v.2.0 so queries that are a bit more complicated return errors like this.
Unfortunately, the best option now is to roll back to 1.7.2. If you can create a staging/testing website with 2.7.1 (released today), and connect this database as a separate DB, I'll try and help you out within the next 2 weeks (too much work, can't make it sooner), so that you can update the plugin, and receive all future updates.
My suggestion is to roll back manually by following these steps:
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!
1. Download the zip folder I've attached here
2. Use FTP to open /your_wordpress_folder/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!
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,
Roll back completed. :D
We had to re-add the data base connection
Also we had to redo out Custom "URL Link" buttons `SELECT concat("/home/moredata/ ||", count(*)) FROM DB.table` (I have attached Screen shot in case you where interested)
Due to the button changes between the two versions.
But they were expected, Other then that It looks like its up and running again.
Its been a while since I have seen the older interface, it still looks good :)
Thank you for your help with this.
I have made a backup any I am happy to test any new versions if you would like, But it the urgency on solving this is gone as the search is working again.
Thanks again :)
Warm Regards
Daniel
Hi again Daniel.
You're welcome.
I'm sorry that you had to do this, but as long as the business is running, right?
Please feel free to download the full version from Envato, and install it on localhost or a non-public website. There you can test all features, and if you have time see how you can get around this issue.
If you ever need any assistance from us, please feel free to open a new ticket, and we'll gladly help.
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