I planned to buy your plugin, but I just can’t create a table from Excel because of the constantly occurring error "Column 'pos' cannot be null". For the test, I used different versions of the tables, but the error constantly repeats and in some columns the values disappear. What can be done with this problem?

I sent you two examples by e-mail and message of WP with  link to error in plugin. Thank you for your help!

Hello Aleksandar!

Have you some news for me?

Best regards,

Alexander.

Thank you, Aleksandar!

I found your message right now.

Thanks a lot Aleksandar!

All work correctly now!

I am having the same issue, can you share the fix?

I'm encountering the same error when attempting to 'replace source with source data' or 'replace the entire table...' : 'Column 'pos' cannot be null'. I've never had this issue before (just updated the plugin version). If I create a new table using the same method, it works fine, but not with old tables. Please assist.

thanks for the answer Aleksandar, my headers had unique names, in fact I had been always using and updating those tables in the same way and worked fine.

To me the problem was the updated version on old tables.

I had an old version of the plugin for a while (my license was expired) and it was working fine, but now I bought it again to update it and after updating it, to replace the rows "Replace rows with source data" (from a link in a google sheet) didn't work anymore ('Column 'pos' cannot be null) and it even fails if I try to replace the entire table "Replace the entire table with the source".

The way I managed to do it was if I manually deleted the columns of the table, and then replaced the entire table "Replace the entire table with the source". Which is basically like creating a new table (by the way, if I create new tables using the same method, it works fine. Also If I replace the content of those new tables), but as the table was embedded in many pages of my site I needed the ID not to be modified so I had to do this tedious process in the 34 tables I have.

I had already created the ticket, the 3645404. 

I couldn't wait for the fix, so I redid all the tables myself. I no longer need the fix, but may be some one does... cheers!

Dear Aleksandar,

I write in hope that my post will help those with the same error and also the TMS team with solving the issue.

I had the same problem as Manuel and spent several hours trying to find a solution,

I also believe the problem appeared after an update,

How i got the error:

On a table created in a previous version I tried to do an import using the option "Replace rows with source data".

The result was:

"Column 'pos' cannot be null"

How i fixed it:

I went in the database and did a select in the table "wpdatatables_columns" . There is a column pos.

I noticed that there were a few headers with duplicate pos. (Image attached. The section that is blacked out contains my columns.) The last headers "wdt_created_by", "wdt_created_at", "wdt_last_edited_by" and "wdt_last_edited_at" WERE NOT THERE before my import. The import probably created them with an incorrect pos.

I replaced the pos on the last 4 headers with the values 14, 15, 16, 17 and it appears to be working fine.

Please make sure to send this finding to your development team, since the import functionality is crucial to so many of us.

Kind regards,

Alexandru