When I enter text in the column filters that is obviously in the cells below it, the search comes back with no results. It is the same case with global search.
EG Enter "Au" into the Title column or "Au into the Global search field.
The aaa2 table was working before the recent upgrade to 2.0.1
Any ideas as it is driving me bonkers?
(PS: How do you enter a valid "Related URL" as each time I do so I get an error message telling me that it is invalid. I am trying to enter "http://www.keepwerking.co.uk/aaa2/")
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.
Also point me to the table ID so I can take a look.
I thought I was being clever in just "hiding" the old plug in folders by changing their names! Of course WordPress will pick them up no matter what if they are still in the PlugIns folder!
As I said "Doh!"
Anyway ... I therefore removed completely all 3 versions and then re-uploaded v2.01.
But, alas, that was not the issue. That table is still not able to be searched on correctly.
(Please note I deleted table 20 that I gave you in the private example. Please refer to the newly built table 27)
I have discovered something though....
I think it has something to do with the SQL. Why? Well that's really the only difference between table 10 which works and table 27 which does not. So...... I experimented.
In my example table 27, I changed the SQL to the simple...
select company from collection
This works fine.
However if I revert the SQL to what it is now it does not work. Again, it's strange for me, as it WAS working prior to v2
The log in details I gave you earlier are still valid.
Can you please try to make a VIEW from this query in phpmyadmin or any other database management system and see if it is returning the desired results.
Phew ... I've had to learn a bit to do that. i.e. I have never used views :/
So... I created the view ... then amended the table to use that view ... but that did not work fully.
The resultant table allowed searching to work as expected EXCEPT for the Title column.
However I noticed that one of the columns "Title" ended up as a BLOB type in the view. All other columns ended up as Text.
After a bit of searching using Google I created my view using
CONVERT(`Title` USING utf8)
Now my table works fine.
So... Do you know why I had to use a VIEW rather than a table? i.e. What are the rules? Or was this a little bug that has been discovered? Or is this just a limitation of wpDataTables?
(PS I was going to create another table with the results of my query .. but VIEWS appears to be the better "tool" to use)
When you have some complex queries like your from the example, we always suggest to make a VIEW to see if everything is ok with the query. Like that you find that something is wrong with the Title column so you changed that and you can use that query now as an input for creating tables.
This is not a limitation this is just some steps that sometimes must be taken in order to solve the issue.
If you go to
http://www.keepwerking.co.uk/aaa2/
You will see a table.
When I enter text in the column filters that is obviously in the cells below it, the search comes back with no results. It is the same case with global search.
EG Enter "Au" into the Title column or "Au into the Global search field.
I have another table http://www.keepwerking.co.uk/concertcountdown/ that works fine.
The aaa2 table was working before the recent upgrade to 2.0.1
Any ideas as it is driving me bonkers?
(PS: How do you enter a valid "Related URL" as each time I do so I get an error message telling me that it is invalid. I am trying to enter "http://www.keepwerking.co.uk/aaa2/")
Hi jcsatujp,
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.
Also point me to the table ID so I can take a look.
Did you try to enter the link like this
www.keepwerking.co.uk/aaa2
Best regards.
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 John,
The first thing I noticed is that you have 3 of our plugin versions installed which can be the issue. ( attachment)
Before I investigate can you please tell me did you follow this steps when updating the plugin
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.
The versions 1.7.2 and 2.0 should not be visible in the dashboard so I think the issue is there in the proper updating the plugin.
Best regards.
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
Doh! Talk about feeling like an idiot!
I thought I was being clever in just "hiding" the old plug in folders by changing their names! Of course WordPress will pick them up no matter what if they are still in the PlugIns folder!
As I said "Doh!"
Anyway ... I therefore removed completely all 3 versions and then re-uploaded v2.01.
But, alas, that was not the issue. That table is still not able to be searched on correctly.
(Please note I deleted table 20 that I gave you in the private example. Please refer to the newly built table 27)
I have discovered something though....
I think it has something to do with the SQL. Why? Well that's really the only difference between table 10 which works and table 27 which does not. So...... I experimented.
In my example table 27, I changed the SQL to the simple...
select company
from collection
This works fine.
However if I revert the SQL to what it is now it does not work. Again, it's strange for me, as it WAS working prior to v2
The log in details I gave you earlier are still valid.
Hi John,
Can you please try to make a VIEW from this query in phpmyadmin or any other database management system and see if it is returning the desired results.
Best regards.
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
Phew ... I've had to learn a bit to do that. i.e. I have never used views :/
So... I created the view ... then amended the table to use that view ... but that did not work fully.
The resultant table allowed searching to work as expected EXCEPT for the Title column.
However I noticed that one of the columns "Title" ended up as a BLOB type in the view. All other columns ended up as Text.
After a bit of searching using Google I created my view usingCONVERT(`Title` USING utf8)
Now my table works fine.
So... Do you know why I had to use a VIEW rather than a table? i.e. What are the rules? Or was this a little bug that has been discovered? Or is this just a limitation of wpDataTables?
(PS I was going to create another table with the results of my query .. but VIEWS appears to be the better "tool" to use)
HI John,
When you have some complex queries like your from the example, we always suggest to make a VIEW to see if everything is ok with the query. Like that you find that something is wrong with the Title column so you changed that and you can use that query now as an input for creating tables.
This is not a limitation this is just some steps that sometimes must be taken in order to solve the issue.
Hope that everything is working fine.
Best regards.
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
Thank you.
Yes I'm happy.
Please close the call.
Hi John,
You are welcome.
Best regards.
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