Most likely, this column is saved as a "Single line string" column, which is saved as VARCHAR with the character limit of 255 in the database.
Please either create a new column as "Multi line string", or access this column's settings, and under "Editing" tab change the type to "Multi Line string". After you do that, you'll need to go in to your database and locate this database table.
Edit its structure and change the type from VARCHAR(255) to TEXT (without any character limit).
Dear Aleksander, thanks for your prompt reply, but i did not rescue to solve it. I changed in WP WpDT the settings of the column: in Data in STRING and in Editing I can select MULTI LINE EDIT.
In MySQL DB, on ARUBA (an usual italian hosting service) I found the Tables, and from wp_wpdatatables_columns I changed STRING in TEXT... but the same error appeared again.
I need only to write more thank one link in the table box, as:
You haven't changed the length of these two columns in the database (Piani Di Studio, Regolamenti E Programmi):
They are still saved as VARCHAR(255). I modified those and changed them to TEXT (without a character limit)
And based on your first screenshot I successfully added multiple anchor tags (links):
Basically, that was causing the issue.
When you want to add long strings (links, hyperlinks, long text, etc) make sure to create Multi-Line String columns. When you create a Single-Line String column, it's saved as VARCHAR(255), and afterward, you would need to change the type within the database, not only in wpDataTables. If you create the table with Multi-Line String as default, the plugin will do that automatically.
I wouldn't know where TablePress saves the database tables, sorry. You'd need to reach out to their support team for that.
Effectively in the MySql db, I did touch the table wp_wpdatatables_columns and not the wp_wpdatatable_5 becouse i thought there was correspondency between number of the table in Wordpress (10) and in the DB (5), and the only similar data i found in _columns...
When I edit a filed (string or url) it accepts only one link or html code...
I need to put 4 or 5 url link in a field, as html test, preferable.
Hello there.
Most likely, this column is saved as a "Single line string" column, which is saved as VARCHAR with the character limit of 255 in the database.
Please either create a new column as "Multi line string", or access this column's settings, and under "Editing" tab change the type to "Multi Line string". After you do that, you'll need to go in to your database and locate this database table.
Edit its structure and change the type from VARCHAR(255) to TEXT (without any character limit).
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Dear Aleksander, thanks for your prompt reply, but i did not rescue to solve it. I changed in WP WpDT the settings of the column: in Data in STRING and in Editing I can select MULTI LINE EDIT.
In MySQL DB, on ARUBA (an usual italian hosting service) I found the Tables, and from wp_wpdatatables_columns I changed STRING in TEXT... but the same error appeared again.
I need only to write more thank one link in the table box, as:
piano di studi ordinamentale
programma
(for example, here above, i copied the HTML but appears as front-end)
I forgot the attachment for help
Hi again.
Can you please provide me with a temporary wp-admin user (Administrator) for your site, along with database access credentials, so I can take a look?
Just make sure to enable the PRIVATE reply, so the credentials are visible only to us.
If I'm not mistaken, the table in question is #10?
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi again, thank you for the credentials.
You haven't changed the length of these two columns in the database (Piani Di Studio, Regolamenti E Programmi):
They are still saved as VARCHAR(255). I modified those and changed them to TEXT (without a character limit)
And based on your first screenshot I successfully added multiple anchor tags (links):
Basically, that was causing the issue.
When you want to add long strings (links, hyperlinks, long text, etc) make sure to create Multi-Line String columns. When you create a Single-Line String column, it's saved as VARCHAR(255), and afterward, you would need to change the type within the database, not only in wpDataTables. If you create the table with Multi-Line String as default, the plugin will do that automatically.
I wouldn't know where TablePress saves the database tables, sorry. You'd need to reach out to their support team for that.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thanks very much Aleksander!
Effectively in the MySql db, I did touch the table wp_wpdatatables_columns and not the wp_wpdatatable_5 becouse i thought there was correspondency between number of the table in Wordpress (10) and in the DB (5), and the only similar data i found in _columns...
well! This is resolved! thanks!
..and I have other questions....... :)
You're welcome, glad I could help.
I just responded to your other ticket but, unfortunately, I won't be able to help you with it.
Please feel free to open a new ticket if you have some other questions, though.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables