Hi! I have created a "dashboard" page using wpDataTables for an online yarn shop. The multiselect box and select boxes don't recognize some of the data that is in the table. For example, there is data for yarn x in the table, but "no data" is returned. The text and check box filters seem to be working fine, but I'd prefer to use the multiselect box.
The url I included in this ticket links to another ticket where someone seems to have been having a similar problem.
That other ticket's owner had issues with drop-downs not even opening up, and it was a conflict with the bootstrap.js files with some other plugin, not related.
How was this table created? If it is an SQL Query based table, what query are you using?
So far I have noticed the issue with the product_name column in the customer_order_history table and the product_details table. Each is saved as a view in phpMyAdmin The SQL code for each view is attached.
So, if these are views in the database, wpDataTables shouldn't have any issues pulling them with:
SELECT * FROM wpdatatables_product_details
and
SELECT * FROM wpdatatables_customer_order_history
If it still doesn't work, 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.
127.0.0.1 is localhost. If you can confirm you're trying to connect to a localhost database, please try changing the address to "localhost", so not the IP address but literally "localhost" (without quotation marks).
I contacted the administrator of the db to confirm if it is a localhost. I'll post another reply when he responds. I am connecting to the db remotely through phpMyAdmin.
I tried changing the host to "localhost" and it allowed me to successfully create the connection, but when I tried to update my SQL query to...
SELECT * FROM wpdatatables_customer_order_history
I got this message:
Rendered query: SELECT * FROM wpdatatables_customer_order_history LIMIT 10 MySQL said: Table 'snapshot_miayarn.wpdatatables_customer_order_history' doesn't exist
It looks like wpDataTables is still connecting to the "snapshot_miayarn" database EVEN THOUGH I defined the database name as "wp_miayarn".
The solution was to delete and recreate all the tables and charts after changing the host name to "localhost"! This is a very inconvenient feature of wpDataTables. Alas.
I have one more question for you: The table-following charts only reflect the first page of records shown in the table. Is there a setting that makes it so the chart will reflect all data (not just the first page)?
The plugin saves settings in wp_wpdatatables table in the database, so when you created the tables, the old address was probably used, and the table could not be generated because it tried to pull the data from a connection that didn't work.
For the chart to follow table filtering of the entire table, you need to create an SQL query based table which has the option to turn server-side processing off, or use a table linked to an existing data source (Excel, CSV, Google Spreadsheet, etc). In that case, the chart will show all data in the table, even though you're displaying only some rows, but when you filter the table, it will show the filtered chart.
Just like on our landing page - the cryptocurrency table and chart.
When I turn server-side processing ON I am able to access all data, but the table following charts reflect only the rows shown in the active page in the table.
When I turn server-side processing OFF I am UNable to access all data, but the table following charts reflect ALL rows (with the exception of filtered rows)
As it's happening, it looks like I have a choice between accessing all of the data and reflecting all rows in the table following charts.
Is there a solution to this or is this a limitation of wpDataTables?
What do you mean, you're unable to access all data when you turn off Server-side? You should still see your entire table, but it is not loading from the server, but through JavaScript. I can still see the whole table, even with server-side turned off:
What you're showing me here should not be possible.
Issues with filtering should appear with Server-side set to ON, not vice versa, like you say. Tables with non-server-side processing pull all data from the table, so it should be displaying the filtering values.
However, since you're using a separate DB connection, what happens on your end may be true. I can see that "hiking trail " is saved with a space, so that may cause the issue. I tried filtering "wool boucle" and that works fine in a non-server-side table.
So, this is where you're supposed to be taking a look first - correcting any potential issues like extra spaces, and so on, because combining features of non-server-side and server-side like you showed me in your PDF file is not possible.
Hi! I have created a "dashboard" page using wpDataTables for an online yarn shop. The multiselect box and select boxes don't recognize some of the data that is in the table. For example, there is data for yarn x in the table, but "no data" is returned. The text and check box filters seem to be working fine, but I'd prefer to use the multiselect box.
The url I included in this ticket links to another ticket where someone seems to have been having a similar problem.
Hello sjaraha
That other ticket's owner had issues with drop-downs not even opening up, and it was a conflict with the bootstrap.js files with some other plugin, not related.
How was this table created? If it is an SQL Query based table, what query are you using?
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
So far I have noticed the issue with the product_name column in the customer_order_history table and the product_details table. Each is saved as a view in phpMyAdmin The SQL code for each view is attached.
Hi again sjaraha
So, if these are views in the database, wpDataTables shouldn't have any issues pulling them with:
and
If it still doesn't work, 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.
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 reply. I tried to make a separate database connection to wp_miayarn, but when I tested it wpDataTables returned this error:
wpDataTables could not connect to mysql server. mysql said: There was a problem with your SQL connection - MySQL server has gone away
Hi again sjaraha
127.0.0.1 is localhost. If you can confirm you're trying to connect to a localhost database, please try changing the address to "localhost", so not the IP address but literally "localhost" (without quotation marks).
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,
I contacted the administrator of the db to confirm if it is a localhost. I'll post another reply when he responds. I am connecting to the db remotely through phpMyAdmin.
I tried changing the host to "localhost" and it allowed me to successfully create the connection, but when I tried to update my SQL query to...
I got this message:
Rendered query: SELECT * FROM wpdatatables_customer_order_history LIMIT 10
MySQL said: Table 'snapshot_miayarn.wpdatatables_customer_order_history' doesn't exist
It looks like wpDataTables is still connecting to the "snapshot_miayarn" database EVEN THOUGH I defined the database name as "wp_miayarn".
Hi Aleksandar!
The solution was to delete and recreate all the tables and charts after changing the host name to "localhost"! This is a very inconvenient feature of wpDataTables. Alas.
I have one more question for you: The table-following charts only reflect the first page of records shown in the table. Is there a setting that makes it so the chart will reflect all data (not just the first page)?
Hi sjaraha
The plugin saves settings in wp_wpdatatables table in the database, so when you created the tables, the old address was probably used, and the table could not be generated because it tried to pull the data from a connection that didn't work.
For the chart to follow table filtering of the entire table, you need to create an SQL query based table which has the option to turn server-side processing off, or use a table linked to an existing data source (Excel, CSV, Google Spreadsheet, etc). In that case, the chart will show all data in the table, even though you're displaying only some rows, but when you filter the table, it will show the filtered chart.
Just like on our landing page - the cryptocurrency table and chart.
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 Aleksander,
When I turn server-side processing ON I am able to access all data, but the table following charts reflect only the rows shown in the active page in the table.
When I turn server-side processing OFF I am UNable to access all data, but the table following charts reflect ALL rows (with the exception of filtered rows)
As it's happening, it looks like I have a choice between accessing all of the data and reflecting all rows in the table following charts.
Is there a solution to this or is this a limitation of wpDataTables?
Hi again sjaraha
What do you mean, you're unable to access all data when you turn off Server-side? You should still see your entire table, but it is not loading from the server, but through JavaScript. I can still see the whole table, even with server-side turned off:
It's exactly the same as when you turn it on.
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,
I was not clear before. I've attached a pdf with screenshots to better explain the issue.
Thanks for your help.
Best,
Ess
Hi again sjaraha
What you're showing me here should not be possible.
Issues with filtering should appear with Server-side set to ON, not vice versa, like you say. Tables with non-server-side processing pull all data from the table, so it should be displaying the filtering values.
However, since you're using a separate DB connection, what happens on your end may be true. I can see that "hiking trail " is saved with a space, so that may cause the issue. I tried filtering "wool boucle" and that works fine in a non-server-side table.
So, this is where you're supposed to be taking a look first - correcting any potential issues like extra spaces, and so on, because combining features of non-server-side and server-side like you showed me in your PDF file is not possible.
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,
It was the trailing spaces. Thanks for your help.
Best,
Ess
Great news Ess
I'm glad this is resolved.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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