We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
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