There isn't a max number of columns, but there is a database (MySQL) limit on the length of column headers in the tables.
Please provide me:
A temporary WP-admin login for your site where this happens
Database Access (PHPMyAdmin or cPanel)
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.
Hi
As soon as I add more then 14 columns, the 15th one get deleted and all the rest of my columns get re-ordered
Is there a max of columns I can add?
Its very frustrating
Regards
Albe
Hello Albe
Thank you for your purchase.
There isn't a max number of columns, but there is a database (MySQL) limit on the length of column headers in the tables.
Please provide me:
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.
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 Aleksandar
I went into mySQL and see each new column I created was save as a VARCHAR (2000)
I have changed it to VARCHAR (20) as I only use YES/ NO
Now its working, I could add more columns with ease.
Thanks for the feedback
Regards
Albe
Great news, Albe
Thanks for letting me know.
I don't know why it was saved as VARCHAR (2000). Multi-line columns should be saved as TEXT (no limit).
Anyway, I'm glad to hear the issue is resolved.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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