Hi, Jason 

Sorry for the delay

Is this table an SQL table?

Can you please show me the Query you used?

It is possible the issue is with our SQL parser.

See if you have accent graves around table name, if so - remove it.

For the MySQL engine, we are dynamically adding the accent grave ( ` ), so there's no need to use it around the table name in the query. If you were to delete them, searching and filtering should work just fine.

-

Tell me if that fixed the issue?

If not,

can i also see the back-end, if possible?

Please provide me a temporary WP-admin (administrator) user 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 parties. 

You can write credentials here just check PRIVATE Reply so nobody can see them except us.

And point me to the table ID, please.

Thank you

Hi, Jason

I can see on this Query, for example

SELECT * FROM `wp_posts` WHERE `post_type` LIKE 'product'

You have the accent graves (`) around table name wp_posts.  Try to remove them, like this :

SELECT * FROM wp_posts WHERE `post_type` LIKE 'product'

-

If that does not help, I will give you important information about our SQL parser.

In some situations, using certain functions within SQL, the wpDataTables server has problems with parsing the query and building new queries dynamically (rarely happens, but does sometimes).

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, calculation functions and search may not work properly if you include:

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

• Please do not use “LIMIT” in the SELECT statement. wpDataTables adds it automatically and it will be overridden.
• Please do not use “ORDER BY” in the SELECT statement. wpDataTables has its own sorting engine so it makes no sense to use MySQL’s sorting, since it will be overridden. Also, server-side processing feature adds this part of statement automatically when users trigger the sorting on the front-end, and having it in initial statement may cause the table to crash.

-

To avoid this, can you please prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.

- If you need help creating a View and use it with our plugin, here is our video with an example.

Let us know if this helped.

Thank you