Hi, Geoffrey 

Sorry for the delay

I can see what the issue is, you have clearly shown the details in the Video , thanks for that.

We are not able to reproduce it on our Test site,  so i would like to check out your back-end setup and the database, if thats' OK,  and we should be able to tell you more after that.

Please provide me a temporary WP-admin (administrator) user for your site where this happens, 

and if you could allow me access to the database ( either a link with access + credentials for PhPMyAdmin or cPanel , or you could install WP PhPMyAdmin plugin, that can work as well),

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.

And please point me to the table ID.  Thanks.

Hi, Geoffrey 

My apologies for the late response.

We had a New Years break and are back,   will do our best to be quick with our responses going forward.

I wish you a Happy New Year, and all the best in 2023!

-

Thank you for the access, i was able to access and took some time to check all the details.

I am immediately able to see exactly the behaviour as you have shown, on your table,  and i also made a copy of the Manual Table.

Despite best efforts, i still can't figure it out.

If i make an SQL dump of your table and import to my Test database, over there i am able to add new columns without the strange behaviour.

I will get help from senior colleagues and i will keep you posted, we will do our best to get to the bottom of this issue.

Thank you for your patience and cooperation.

Hey, Geoffrey 

First, i wish to apologise for all the waiting time.

Despite best efforts, i still didn't isolate the root of this behaviour on your site.

We have raised the urgency on this since you have already been waiting for so long.

I am expecting to have an update for you very soon.

Of course, i will let you know if our 2nd Tier Team needs any additional detail or access from your end.

Thank you for your patience and cooperation.

As soon as they advise, we will report back immediately.

Hey, Geoffrey 

Sorry once again that it took us such a long time, thank you for all the patience.

- We got help from our developers on this.

They will work on improving this behaviour in the future, at the moment here is a workaround solution.

You will be able to change this behaviour in a PHP file, if you edit with any text/code editor,  the file is in :

../wp-content/plugins/wpdatatables/source/class.constructor.php

you can use CTRL+F   to search and replace any "VARCHAR(2000)"  to "TEXT",  and then the new columns will be created without character limit.

You would have to do this at every update for the time being, because the update will revert it to default;

but our developers are working to implement a better solution soon. I don't have an ETA on it, though, but they will do their best to be as soon as possible.

You can certainly follow our changeLog page if you'd like, where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

Let me know if this works for you. Thank you