Hello barrstard6.

Thank You for Your purchase.

Sorry for late response. 

Our company is located in Serbia and our working time is from 10:00 to 17:00 CET. business days.

Before we go into any more troubleshooting and details, can I ask You to delete the ";" from the end of the query, and let me know if that resolves the issue?

Best regards.

Hello Guy.

Ok, now I'd like to take a look at this.

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.

Also, if You could provide me with Your PHPMyAdmin database credentials, so that I can go in and take a look at the database itself.

Best regards.

Hello again Guy.

Could You also provide me with the link to the database, please?

Best regards.

Also, I cannot access the dashboard (see attachment). I can only log-in to Your web-site.

Can You, please, check if this is an administrator account?

Best regards.

Yes, that works, but only as a member log-in.

When I try to open the dashboard, it comes up with "My account" (see attachment).

Best regards.

Hello again, Guy.

I may not need the database access after all.

It looks like the user_id column is not unique, and since it is being used as the ID column for editing it is displaying that error. What You need to do is to add or select an ID column that is unique, and set it up on the MySQL side as AUTO INCREMENT integers. This way wpDataTables will be able to add the data to the table.

Please let me know how it went.

I wish You a good night, sir.

Best regards.

Hello again Guy.

Dont forget that the wp_usermeta table is unique in its structure and I am calling the SQL query to a different format. Is that the issue?

We inspected the error and found the issue is indeed with the different format (see attachment1).

This error showed the first error in line - it didn't find the "membership_type" column. It'd go on like this for all the other columns, because "wp_usermeta" has only four columns (see attachment2).

Unfortunately, updating the wp_usermeta as a serialized PHP array is not possible at the moment. It is possible to get it, but not edit.

I am sorry for any inconvenience this may cause.

Best regards.

Hello again, Guy.

I am sorry to disappoint You, but this cannot be done with the plugin's built-in features. Even changing the column input type doesn't change the content to be a valid link. I tried something, which I believe You already have - set the column type to be a string with one-line edit, and creating prefix as <a href="link= and suffix as "></a> but that didn't do anything either.

What You can try to do is to create a query that creates a new column, which has to CONCAT prefix, usermeta, suffix and return that column which will be recognized as link or to be recognized as a string (and in this case it will contain href and all necessary tags).

Unfortunately, writing queries like this doesn't fall under included support for the plugin.

Best regards.