Hi Alex.

Thank you for your purchase.

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.

Best regards.

Hello again Alex.

I am sorry, but I'm not able to get to the log in page:

You may need to whitelist my IP, for me to be able to remote in:

178.148.79.105

Best regards.

Hey Alex.

You added the database name to the query, that's why it broke.

I changed it to this:

SELECT 
* FROM library_view

And it filters through the table correctly now.

As for the spinning circle and loading issue when you make any changes to the table - the console is throwing an error in reference to the custom JS you added in main settings of wpDataTables:

jQuery(function(){
    jQuery(document).ready(function(){
       wpDataTables.table_1.fnSettings().aoColumns[8].bSortable = false;
    });
});

When I delete that, any changes made in the table work without having to refresh the page. Here's the error:

And more details in the attachment.

If you don't need that jQuery, you can remove it, and the issue with table load will disappear as well. If you need it, it will need to be modified in order to bypass the error. The changes do apply, however, so if you change something and reload the page after 5 seconds, everything's good either way.

Best regards.