Also, it is not possible to create tables with queries that have stored procedures and variables in them.
You can try preparing a MySQL view (which will return the data that you need, call it e.g. “view1” and then build a wpDataTables based on a simple query like "SELECT * FROM view1″).
This library is being updated automatically from github before we release a new version of the plugin. Unfortunately the bug hasn't been fixed in github. We will take a look, but changes like this require testing of all other aspects, to see if it works as it should, and if it's not causing any further conflicts, so we cannot guarantee that it will be included in the next update.
Thank you for your suggestion, but at the moment we will not have that option, because PHP-SQL-Parser has been included because of security reasons.
Hi!
When creating a table in manual mode based on a SQL query
(
SELECT `TDate`, `Drawdown` * 100 AS `Drawdown`,
IF(`Drawdown` = 0, @dd_counter := 0, @dd_counter := @dd_counter + 1) AS `Days Drawdown`
FROM table, (SELECT @dd_counter := 0) AS B2
) - query using user variables in select.
I get an error: "unknown [expr_type] = user_variable in "expression subtree" [0]".
This error gives PHP-SQL-PARSER.
I found a description of this error and a solution: https://github.com/greenlion/PHP-SQL-Parser/issues/225
I use MySQL 8.0.19.
Could you please fix this error in the new release wpdatatables and add the ability to make database queries without applying PHP-SQL-PARSER.
Hello amaslo
Thank you for your purchase.
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
Our logic is based on a PHP SQL parser which has full support for the SQL dialect for the following statement types:
SELECT, INSERT, UPDATE, DELETE, REPLACE, RENAME, SHOW, SET, DROP, CREATE INDEX, CREATE TABLE, EXPLAIN and DESCRIBE.
Some of them are disabled for security reasons.
Also, it is not possible to create tables with queries that have stored procedures and variables in them.
You can try preparing a MySQL view (which will return the data that you need, call it e.g. “view1” and then build a wpDataTables based on a simple query like "SELECT * FROM view1″).
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
Thanks for the answer! I have already solved the problem.
The PHP SQL parser has bug, a solution: https://github.com/greenlion/PHP-SQL-Parser/issues/225
Hi amaslo
Thanks for the solution! I will forward this to our development team, so they can take a look at it, and fix it for one of our future updates.
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 again amaslo
Our development team asked me to forward this:
This library is being updated automatically from github before we release a new version of the plugin. Unfortunately the bug hasn't been fixed in github. We will take a look, but changes like this require testing of all other aspects, to see if it works as it should, and if it's not causing any further conflicts, so we cannot guarantee that it will be included in the next update.
Thank you for your suggestion, but at the moment we will not have that option, because PHP-SQL-Parser has been included because of security reasons.
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