Hi! I have a client using front-end editable tables extensively. I set up a "template" and they have been duplicating and changing name and inserting on pages via shortcode. When they got to table 80 they got a message saying the Identifier name was too long. Each table (based on the original "template") is being auto named and has resulted finally in this: wp_wpdatatable_4_4_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1. This field is not editable.
How do I setup to create new table numbers when duplicating?
Unfortunately, you cannot change this in any way. That's how the plugin is creating duplicate tables, and it seems your client reached the database's maximum length for a table name.
What you can do, though, is this:
1. Go into your database, and access this table. Then, click on the Operations tab, and change it's name to (for example) wp_wpdatatable_4_2 (or if that name's taken, change it to something else):
Then, click on GO in the bottom right corner of that section:
2. Go to the database table "wp_wpdatatables", find this table in the list, and edit the content field:
Change it from:
SELECT * FROM wp_wpdatatable_4_4_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1
To this:
SELECT * FROM wp_wpdatatable_4_2
And save that.
The duplicated wpDataTable in the plugin will also change the database table it needs, and you'll keep all your settings for this table:
After that, make sure your client is duplicating this table, not the original one.
Hi! I have a client using front-end editable tables extensively. I set up a "template" and they have been duplicating and changing name and inserting on pages via shortcode. When they got to table 80 they got a message saying the Identifier name was too long. Each table (based on the original "template") is being auto named and has resulted finally in this: wp_wpdatatable_4_4_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1. This field is not editable.
How do I setup to create new table numbers when duplicating?
Please see attached screenshots.
Thanks!
Hello Ben
Unfortunately, you cannot change this in any way. That's how the plugin is creating duplicate tables, and it seems your client reached the database's maximum length for a table name.
What you can do, though, is this:
1. Go into your database, and access this table. Then, click on the Operations tab, and change it's name to (for example) wp_wpdatatable_4_2 (or if that name's taken, change it to something else):
Then, click on GO in the bottom right corner of that section:
2. Go to the database table "wp_wpdatatables", find this table in the list, and edit the content field:
Change it from:
To this:
And save that.
The duplicated wpDataTable in the plugin will also change the database table it needs, and you'll keep all your settings for this table:
After that, make sure your client is duplicating this table, not the original one.
I hope that helps.
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