Hi  Jorge,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

Please note that the official support language is English, and we have to use Google Translator to try and understand other languages. Since a lot can be lost in translation, we apologize in advance if we misunderstood some segments of your message, and we also ask you to please translate your future messages to English.

Thank you for your understanding.

-

Yes, we had another user with this same error during SQL Queries for our Tables.

Can you please check these details :

1. Please check if any of your SQL Table has this symbol  < (less than) in any origin Column Header?

"<" is an opening HTML script tag, and it's automatically being flagged as a potential SQL injection threat, so if this symbol is in any of your Headers, please remove it.

2. Also, we had a case when a user made "line breaks" in the SQL Query for Column names,

here are just two comparison screenshots to summarize what we changed exactly, first how it was before :

And after the change :

as you see,  two instances in that user SQL Query where there are new lines/line breaks in the Query syntax, here is a screenshot of this, so for example, instead of this Column name being "Settle price" ( on one line),

in the user Query it was

 "Settle

Price" 

( with a line break).

So please check your SQL Query for each of these Tables, and make sure that none of them have a line break in the SQL Query syntax like that,

then it should be fixed.

Let us know if that helps.

Hi  Jorge,

sorry, actualy now when i took another look from your screenshot, it seems you have multiple "SELECT" statements in the same Query,

that will not work with our SQL Parser.

it seems something is not correct with your Syntax.

Can you confirm if you run the same Query, does it return the data in your Database Management Tool,

(such as PHPMyAdmin)?

-

If the Query runs successfully in your DB management Tool,

our Plugin is still not the same as a DB management tool, and is not meant to be used as one.

Everything in our Plugin runs through an SQL Parser, which has certain limitations.

-

Could you send us the full SQL Query that was used for this table -

 and I can advise if maybe some small modification/correction is needed to get the search to work?

-

But you can also check these points to save time if you wish.

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.

Filtering, sorting, and search may not work properly if you include:

• Accent graves ( ` ) around the table name
• JOIN functions
• UNION functions
• CONCAT functions
• sub-queries

-

So, first you can check for accent graves around the table name, if you have this, remove it...

Then, see if you used CONCAT to create any column.

If so, go into this column setting, and disable it from "global search" in the Filtering tab.

-

-

If none of that helps,

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″.

 If you need help with that, you can see our video, where we show an example of using View in our plugin.

-

Let me know If that helped, and i can take a look at the Query, as well.

Thank you.