HI jordirubira,
Thank you for your purchase.

Can you please tell me are there any more errors in the console or in the server log so I can see which error or files may cause this issue.

Best regards.

Hi jordirubira,

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.

HI jordirubira,

If you take a look at our documentation you will see this notice:

Please note that MySQL query constructor is not an ‘ultimate generator’, it should be consider a helper that constructs a suggestion of a query trying to ‘guess’ what you want. We constantly work on improving it, but SQL is such a complicated and flexible language that full automation for constructing queries is hardly possible. So the more complicated your request is, the higher is the chance that it will not return exactly what you need. Play around with the resulting query to achieve better results.

Our suggestion when you have queries like this is to make a VIEW in phpmyadmin or any other database management system to see if the query is returning the right results.
If the query is returning the right result you can use that query as an input ( SELECT * FROM VIEW ) when creating tables with Add from data source option.

Best regards.

Hi jordirubira,

The error 

Unknown column 'advanced_settings' in 'field list' 

refers that the plugin just needs to be deactivated/activated again.

Glad that you found a solution, hope that everything is working fine now.

If you have any more issues feel free to open a new ticket.

Best regards.