Hello Damian

Thank you for your purchase.

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.

Also, please tell me which query you used, so I can try and replicate the issue when I log in.

Hello again Damian.

I'm sorry, but I still can't access the page:

Are you able to access it, because this seems like a whole other issue than what I used to see, when Serbia was not white-listed?

Hey Damian

Actually, there's no need for that. I found the issue.

You have the "wpDataTables Integration for Forminator Forms" add-on installed, but you don't have the Forminator plugin installed. It was throwing a 500 - server error, and when I disabled that add-on, I was able to create a MySQL query-based table.

Hey Damian.

This is a server error and it's usually happening when the server can't or won't process the request. You can try flushing your server's DNS cache (flush all cache altogether, for that matter), and try constructing your query without back-ticks ( ` ) and without calling the table name if all columns are pulled from the same table.

For example, in the Listing Basic table, you would need to modify the headers in the database first so they're not `Short Description`, but instead `Short_Description` or something like that, so then you'd be able to change the query to this:

SELECT Province,
       Town,
       Category,
       Keywords,
       Business_Name,
       Short_Description
FROM Listings

Using back-ticks can cause some issues with the plugin. It never caused these 400 - bad request errors, but it's worth a shot.

You can also check with your hosting provider if they have an error log about this error.

Hi again Damian

I forwarded this ticket to our developers, and as soon as I hear from them I will let you know.

Would you be able to provide us with FTP and Database access credentials (again, in a PRIVATE response)? These errors, however, are usually caused by something on the server, not data or any of the plugins you may have installed, but let's wait for our developers' opinion.

Hey Damian

Thank you for the new FTP credentials.

I tried to duplicate the site using All-In-One WP Migration, but that doesn't seem to work on a multisite installation, or your multisite configuration doesn't allow it to run, so I couldn't duplicate the site.

I forwarded the ticket to our developers again, and as soon as I hear from them I will let you know.

Unfortunately, we can't add additional emails when responding to tickets.

Hello again Damian.

Something is causing a conflict. Whether it's a plugin or the theme we can't say for sure because when we refresh the page it tries to save it, but when you try again it returns this error because the JSON is not valid and it doesn't reach the back-end at all.

This is being added before sending accent graves ( ` ) instead of the regular single quote ( ' ) and that's why it breaks.

Can you please change the theme and see if the issue is resolved? If not, then please deactivate all other plugins except for our plugin, refresh the page where the issue is, and see if it is resolved (it should be). If it is, then start activating other plugins one by one, and after each activation refresh the page to see if the issue reoccurred. Once it does reoccur, you will have found the plugin causing the issue.

If this doesn't help, please send us the duplicated (migrated) site, so we can test locally.

Hello Damian

Thank you for getting back to me, but we can't duplicate the site like that.

You can install the Duplicator plugin. It will generate a couple of files that you can send me (along with the log-in credentials), and then I can create an exact copy of your website, see what the issue is and try to resolve it.

The Duplicator plugin can export only up to 500MB of data, so if your site is bigger than that, please use the All-in-One WP Migration plugin.

Please note that the files will be too large to attach to the ticket, so you can upload them via wetransfer.com and just send me the link.

It's not the back-ticks (accent graves) in the query, but in the JSON that's being returned:

This is the JSON that returns the table's configuration and the query has nothing to do with it. In fact, the query that's being used here is as simple as it can be:

So, that's not generated by our plugin, but instead a conflict with something else on your site.

If you manage to generate a duplicated site using the All-in-One WP Migration plugin, our developers will debug it, and see if they can find the culprit. If you're not able to do it, do we have your permission to log in with the credentials you previously created, and create the duplicated site ourselves?

Hi again Damian

The All-In-One WP Migration plugin is actually free, and I used it yesterday on a site that was over 5GB in size, so you should have no issues with it, nor would you have to pay anything.

It is not impossible to duplicate the site this way, but our developers don't practice it since it takes a lot of time and we have a lot of users that require our attention. Using the Duplicator plugin for smaller sites, or All-In-One WP Migration for larger sites is a lot faster and literally takes 5 minutes to set it up locally.

If you're still facing issues with this, let me know and I can log into your account and duplicate the site with your approval, of course.

Hi again Damian.

I was not aware of this multi-site limitation with All-In-One WP Migration, thank you.

You can change the site, of course. Make sure to deactivate the license in wpDataTables settings/Activation, activate it on another website and then activate the purchase code again through settings.

Hi again Damian

There's nothing else you need to do when moving the license to another site - simply deactivate it on one domain and activate it on another domain, and that's it.

If you need some further assistance, please feel free to reach out to us.