I have just purchased your plugin having tested it in the sandbox. I am getting errors when trying to build a table from a CPT I have created using pods. When I drag the fields I want to have displayed in the table, I get the following errors:
If I include the field for the Post Title (project-board.title_with_link_to_post) I get this error message:
No results found. Please check if this query is correct! Table Constructor needs a query that returns data to build a wpDataTable. Error: Unknown column 'posts_project' in 'on clause'
If I remove that field and only use fields that were created in my CPT I get the following error message:
No results found. Please check if this query is correct! Table Constructor needs a query that returns data to build a wpDataTable. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN (SELECT project_board_meta_client_tbl_posts.ID as id, meta_value, met' at line 5
I am wondering if this is a MySQL version issue, but would like your comments on this. In both cases no results were found and I know that there are three custom posts on the system.
If you take a look at our documentation you will see this notice
Please note that MySQL query constructor is not an ‘ultimate generator’, it should be consider a helper that constructs a suggestion of a query trying to ‘guess’ what you want. We constantly work on improving it, but SQL is such a complicated and flexible language that full automation for constructing queries is hardly possible. So the more complicated your request is, the higher is the chance that it will not return exactly what you need. Play around with the resulting query to achieve better results.
Can you 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 if you can write me here which table/columns do you use in the wizard so I can try to reproduce the issue.
I logged in successfully and test it out by myself.
The "issue" is like i assumed and it is related with the MySQL query constructor because it is not an ‘ultimate generator’.
My suggestion is when you have some complex queries like this is to make a VIEW in phpmyadmin or any other database management system and see if the query is returning the right result. If the result is good you can use that query as in input when creating tables with Add from data source option.
Just to let you know I managed to solve my issue. The problem resolved around the fact that I called my CPT project-board and apparently mySQL doesn't really like hyphens. I changed the name to project_board and your plugin worked like a dream. :)
Just thought I would mention it in case any other user had a similar issue.
Glad to hear that you managed to find a solution, good job.
And thank you for sharing it with us and other users.
If you like our plugin and support we'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. It means a lot to us.
Thanks.
Dear Sirs,
I have just purchased your plugin having tested it in the sandbox. I am getting errors when trying to build a table from a CPT I have created using pods. When I drag the fields I want to have displayed in the table, I get the following errors:
If I include the field for the Post Title (project-board.title_with_link_to_post) I get this error message:
No results found. Please check if this query is correct! Table Constructor needs a query that returns data to build a wpDataTable.
Error: Unknown column 'posts_project' in 'on clause'
If I remove that field and only use fields that were created in my CPT I get the following error message:
No results found. Please check if this query is correct! Table Constructor needs a query that returns data to build a wpDataTable.
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN (SELECT project_board_meta_client_tbl_posts.ID as id, meta_value, met' at line 5
I am wondering if this is a MySQL version issue, but would like your comments on this. In both cases no results were found and I know that there are three custom posts on the system.
I look forward to hearing from you.
Kind regards,
Ian
Hi Ian,
Thank you for your purchase.
If you take a look at our documentation you will see this notice
Please note that MySQL query constructor is not an ‘ultimate generator’, it should be consider a helper that constructs a suggestion of a query trying to ‘guess’ what you want. We constantly work on improving it, but SQL is such a complicated and flexible language that full automation for constructing queries is hardly possible. So the more complicated your request is, the higher is the chance that it will not return exactly what you need. Play around with the resulting query to achieve better results.
Can you 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 if you can write me here which table/columns do you use in the wizard so I can try to reproduce 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 Ian,
I logged in successfully and test it out by myself.
The "issue" is like i assumed and it is related with the MySQL query constructor because it is not an ‘ultimate generator’.
My suggestion is when you have some complex queries like this is to make a VIEW in phpmyadmin or any other database management system and see if the query is returning the right result. If the result is good you can use that query as in input when creating tables with Add from data source option.
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
Bogdan,
Just to let you know I managed to solve my issue. The problem resolved around the fact that I called my CPT project-board and apparently mySQL doesn't really like hyphens. I changed the name to project_board and your plugin worked like a dream. :)
Just thought I would mention it in case any other user had a similar issue.
Kind regards,
Ian
HI Ian,
Glad to hear that you managed to find a solution, good job.
And thank you for sharing it with us and other users.
If you like our plugin and support we'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. It means a lot to us. Thanks.
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