I have a very simple table.
But when I want to add a new line, there are bugs.If my text is a little bit too long, it doesn't work.
I don't see a character limit per box anywhere.It's just a sentence or two.There wasn't this problem at the initial upload of the array from a csv file.
I would need to remote in your database, and see how the columns are saved as.
If they are saved with the maximum character limit (the longest text in the column), then this can be the issue.
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.
We would like to improve our plugins to help you adapt to the current working conditions, changed due to COVID-19 quarantines. Let us know which features are missing currently to make your remote work more comfortable. Please take wpDataTables Survey and Amelia Survey, it won't be longer than 3 - 5 minutes. Thank you!
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hello again Elise
That worked, thanks.
The issue is as I suspected. You created a single-line string column. In the database, that column is saved as VARCHAR with the character limit set to 255. If I add text with 255 characters, it adds it just fine, but if I exceed that limit, it displays an error. I've changed the column's editor input type to be "multi-line edit", but that doesn't change the behavior, since the database column type is still the same.
For that purpose I installed WP PHPMyAdmin, and changed the type from VARCHAR (255) to TEXT (no limit). Now you're able to add longer strings in that column.
Please keep this in mind when creating new tables. It's always safer to create multi-line string columns, which you can later change to single-line, then vice versa.
Hi again Elise
Unfortunately, you can't reorder rows. Manual tables have a hidden "wdt_ID" column, and you can enable sorting in ascending or descending fashion for that column, but that's it.
If you need to remove filtering, you can go to the "Sorting and Filtering" tab above the table, and disable filtering slider there.
It's very, very, disappointing.
To be able to change the order of the rows seems to me an absolutely basic and essential function of a table.Any free plugin can do that!
Now all I have to do is recreate a table every time I want to change the order of my lines????Is there a type of table with which to do this?
Sorry to disappoint you, but no.
You can't reorder rows in the plugin other than with row IDs. No drag and drop. You could add a "row ID" column, and there add numbers by which the table can be sorted. Then, when you reorder the numbers in that column, rows would change place.
We are looking into adding that, but it's not a part of the plugin yet.