Hi there,
Thanks for the great plugin, everything was working well, until today when we got an error message " the table 'wp_wpdatatables_columns' is full".
Can I confirm that there is actually a limit to the number of tables that can be created? did not see any statement in the documentation whether or not it is limitless or limited. In our nature of business, we can easily have more than a couple of tables in one post per day, and more than 20 posts per day.
There is virtually no limit to the number of tables you can create with wpDataTables. wp_wpdatatables_columns is the database table where the plugin stores information about tables, so column types, filter types, predefined values (if any), sorting rules, and so on. The internal representation of a MySQL table has a maximum row size limit of 65,535 bytes, and if there's an issue, it's probably on the database side of things.
With this in mind, can you please provide me a temporary C-Panel (PHPMyAdmin) login and 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.
Hi there, Thanks for the great plugin, everything was working well, until today when we got an error message " the table 'wp_wpdatatables_columns' is full".
Can I confirm that there is actually a limit to the number of tables that can be created? did not see any statement in the documentation whether or not it is limitless or limited. In our nature of business, we can easily have more than a couple of tables in one post per day, and more than 20 posts per day.
Hello ssessments.
Thank you for your purchase.
There is virtually no limit to the number of tables you can create with wpDataTables. wp_wpdatatables_columns is the database table where the plugin stores information about tables, so column types, filter types, predefined values (if any), sorting rules, and so on. The internal representation of a MySQL table has a maximum row size limit of 65,535 bytes, and if there's an issue, it's probably on the database side of things.
With this in mind, can you please provide me a temporary C-Panel (PHPMyAdmin) login and 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.
Best regards.
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