Hello Vad.

Thank you for your purchase.

Issues like this usually occur when you're creating a table with multiple JOINS or CONCAT functions.

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, please tell me what's the table ID, so I know where to look.

Best regards.

Hi again Vad.

I am sorry to inform you that, unfortunately, Skype, Zoom and other types of support other than tickets is not included in the support of the plugin.

What I can say, though, is that the query may be an issue here. Is this the query you used in our query box? If that is true, it needs to be changed.

You must have a table created in your database, and please try avoiding the [ ] brackets. So, if you create a table like this:

CREATE TABLE `JJEDS_functions`(
[WWID] [int] NULL,
[name] [nvarchar](255) NULL,
[function_group] [nvarchar](255) NULL,
[function] [nvarchar](255) NULL,
[valid_from] [date] NULL,
[valid_to] [date] NULL,
[RecordID] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]

you can create a table in wpDataTables like this:

SELECT * FROM JJEDS_functions

And that should work just fine.

The query above may not be correct, but you see what I mean.

Best regards.

Hello badun.

Thanks for the update. 

We've never had issues with this until now, or at least it wasn't reported to us. I will forward it to our development team, to see if there's anything they can do to correct the issue.

Best regards.

Sorry Vad.

Usually these issues occur when there's something wrong with the table in the database. For instance - if you haven't configured a unique, primary column, or some other setting got stuck and is not allowing the table to delete the row, but it returns a message that it does.

Please provide me a temporary WP-admin login for your site where this happens, and also PHPMyAdmin (C-Panel) access, 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.

Alright Vad, sorry about asking for the credentials again.

1. We have not had any issues with the databases, regardless of if they are saved as dbo or dba, but I will forward it to our developers, so they can take a look. I cannot give you an ETA, since there are a lot of priority tasks, and like I already mentioned - we haven't had an issue like this before.

2. This may sound too simple, but have you tried creating a new table with our plugin using the same query? Some previous settings may have been stored in wp_wpdatatables_columns which are preventing the row from being deleted. It's a simple test, but known to have solved the issue previously. If you're still having the same issue, can you at least export the table from the database and send it to me, so I can try it locally, and see if it behaves the same?

There are no ticket numbers provided for resolving issues with the plugin. I'll get back to you as soon as I hear back from our developers.

Best regards.