Hi CITSTAFF,
Thank you for your purchase.

Sorry for late response. 

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

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 point me to the table id that you have this issue. Thnak you

Hi Kevin,

Yes we notice that before and because of that we are request FTP credentials.

We can try to debug throw the wordpress over the plugins editor. Can you please enable this so we can investigate?

Hi Kevin,

Sorry for late response. 

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

Sorry but we dot see plugins editor when we hover or click on plugins directory. Can you please check?

Hi CITSTAFF,

We understand that, but it's a very difficult to found what cause the issue if we don't have access to code. Can you try to set wpdatatables in local environment and make table with source that you use on live server and see do can you reproduce the same issue? Also can you please  check in server log is there some errors which can help us in investigation? Do you have some firewall on server or some security? Can you please check in database in table wp_wpdatatables is it empty column "content"?

Hi Kevin,

Let us know did you reproduce same issue in local environment. There are a lot of improvements from version 1.6.2 , but the tables should work with latest version.

Hi Kevin,

Can you tell me did you reproduce this issue in local environment? All versions that start with 2. have some logic. Only difference is that higher versions have some new features.

Hi Kevin,

Sorry for misunderstanding, but I understand you that you will test on local environment(on localhost).

If you don't have sensitive data is it possible to provide us credentials for Mysql database so we can use it in separate MySQL connection throw plugin and see is there issue with the database? If is possible please provide us some Sql queries that you use for making tables(that you can't configure) so we can tested in our environment and just click Private reply so nobody can see except us.

Logic with creating tables over MySQL queries is changed from version that starts with 2.(2.0,2.0.2,2.1)

Hi Kevin,

Can you please use that query without prefix of the database and also avoid putting semicolon on end of the query in our query box like this:

SELECT * FROM table_name

and let me know are you still have the issue.

Also you probably have but i must ask do you have data in that table in database?

Hi CITSTAFF,

It is hard to figure out what causing the issue without debugging the code. Can you send us that database so we can tested in our local environment? 

HI Kevin,

Sorry for late response. 

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

We found on table lynching_locations_with_certainty that you don't have unique id that is auto increment, because wpdatatables need column  from which will be used as row identifiers. MUST be a unique auto-increment integer on MySQL side so insert/edit/delete would work correctly! wpDataTables will guess the correct column if it is called. Without that wpdatatables pick victim_id that is not unique integer id. Except that all other features work fine.

Can you tell me also when you get this error did you check in Browser Inspect element->Console is there some errors?

HI Kevin,

We are not sure because with same settings in database we made table from that query in plugin. Can you try to turn on server side processing and then try to make a table from that query?

Hi Kevin,

From query that you post in error we can see that all config data for tables is not pass properly. This query is not related to the table data that you have, then the table config. We can see that error that you get is related with the content column in table wpdatatables in which should be saved table config and query of the table is NULL and it shouldn't be like that and also some of the other config columns that is 0.

Because we don't have access to debug it we can't supposed what causing the issue.

We also setup environment with 1.6 version of plugin and use all tables from sql file that you provide us and make wpdatatables with that version. After that we update plugin with version 2.1 deactivate/activate plugin, clear the cache of the browsers and we can see that tables are working just fine.

Hi Kevin,

Do you have some cache on the server that can cause not applying this changes? Sorry for sentence with predefined values that was for another customer, but he have the same errors and also same issue with inserting data in database that you provide in previous posts. Without debugging we can't be sure what cause the issue.