I created a manual table, and now I want to add some columns to it.
I can add a column, and it shows 'success'. But when I save the table, the new column disappears.
There are already 27 columns in this table.
One column is a website, and uses that the URL column type. When I look in cPanel, it shows this field as varchar(2000). I tried to create a new column in cPanel for 'socialmedia', varchar(2000), and it won't let me save a VARCHAR that large. So I saved it as varchar(255).
That worked, but the column I created in cPanel does not show up in the table in the wpDataTables table I see in wp-admin.
I think the issue was the size of the varchar fields. With a couple of URL fields and a couple of Email fields, along with about 10 'select' fields, all created as varchar (2000), it was just too many for that one table in the database to handle.
I got around it by making the URL and Email fields plain string fields, and creating a separate options table with a single column for 'yes' or 'no' and then linking the main table select fields to that. Then I was able to get all the columns (fields) I needed.
I'm not sure why all those field types need to be so large. It might be helpful to be able to specify a field size when the columns are created. Like for a URL, varchar (100) instead of varchar (2000). For a large table with lots of columns, that would be more effective.
If there is a way to do that now, and I'm just missing it, please let me know.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
I can see what you mean. To be honest, i did not check this yet, to see how many characters a URL column gets by default, but just tested it with a new Manual table;
1st Column is URL, second one One-Line String, third is Multi-Line string as TEXT...
I will have to check this with our developers to see if this is the intended behaviour, and is there anything we can do to create a selection, to choose the character limit for the other columns, other than one-line, and multi-line strings ( VarChar 255 versus TEXT)...
As soon as they respond, i will come back to you. Thank you for your patience.
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.
I am delighted to hear that this has worked. Thank you for letting us know. Anything else that we could assist with, please don't hesitate to create new tickets,
and our devs will certainly do their best to implement a permanent solution as soon as possible.
Good afternoon,
I created a manual table, and now I want to add some columns to it.
I can add a column, and it shows 'success'. But when I save the table, the new column disappears.
There are already 27 columns in this table.
One column is a website, and uses that the URL column type. When I look in cPanel, it shows this field as varchar(2000). I tried to create a new column in cPanel for 'socialmedia', varchar(2000), and it won't let me save a VARCHAR that large. So I saved it as varchar(255).
That worked, but the column I created in cPanel does not show up in the table in the wpDataTables table I see in wp-admin.
Any suggestions?
Thanks,
Mark
I think the issue was the size of the varchar fields. With a couple of URL fields and a couple of Email fields, along with about 10 'select' fields, all created as varchar (2000), it was just too many for that one table in the database to handle.
I got around it by making the URL and Email fields plain string fields, and creating a separate options table with a single column for 'yes' or 'no' and then linking the main table select fields to that. Then I was able to get all the columns (fields) I needed.
I'm not sure why all those field types need to be so large. It might be helpful to be able to specify a field size when the columns are created. Like for a URL, varchar (100) instead of varchar (2000). For a large table with lots of columns, that would be more effective.
If there is a way to do that now, and I'm just missing it, please let me know.
- Mark
Hi, Mark
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
I can see what you mean. To be honest, i did not check this yet, to see how many characters a URL column gets by default, but just tested it with a new Manual table;
1st Column is URL, second one One-Line String, third is Multi-Line string as TEXT...
I will have to check this with our developers to see if this is the intended behaviour, and is there anything we can do to create a selection, to choose the character limit for the other columns, other than one-line, and multi-line strings ( VarChar 255 versus TEXT)...
As soon as they respond, i will come back to you. Thank you for your patience.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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, Milos, and I certainly understand you all might be busy.
Just to reiterate, the single-select and multi-select also created varchar (2000) in my instance.
I look forward to hearing what is determined.
- Mark
Hi, Mark
Thank you very much for your patience with this.
I am still waiting to confirm this with our 2nd level Team, sorry about such long waiting time.
I will make sure to add this detail to the information as well,
that the single-select and multi-select also created varchar (2000) on your end.
Thanks for this update, i will let you know as soon as they respond.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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, Mark
The developers advised me on this.
Sorry that it took us such a long time, thank you for all the patience.
-
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.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Thank you, Milos
I appreciate your checking into this and coming back with a work-around solution until the issue is addressed in the plugin code.
And I always appreciate your team's responsiveness to support tickets.
Regards,
Mark
Hi, Mark
Sorry for the late response time once again.
-
I am delighted to hear that this has worked. Thank you for letting us know. Anything else that we could assist with, please don't hesitate to create new tickets,
and our devs will certainly do their best to implement a permanent solution as soon as possible.
Thanks.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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