I am trying to use the Create a table manually option. An error occurs. Here is what was found in the php error log:
WordPress database error Table 'wp_wpdatatable_8' already exists for query CREATE TABLE wp_wpdatatable_8 ( wdt_ID INT( 11 ) NOT NULL AUTO_INCREMENT,`term` VARCHAR(255) , `rate` DECIMAL(16,4) , UNIQUE KEY wdt_ID (wdt_ID)) CHARACTER SET=utf8 COLLATE utf8_general_ci made by do_action('wp_ajax_wpdatatables_create_manual_table'), WP_Hook->do_action, WP_Hook->apply_filters, wdtCreateManualTable, wpDataTableConstructor->generateManualTable
wp_datatable_8 does already exist. How does the table number get determined when creating a table? In the database there are tables wp_wpdatatable_3 thru wp_wpdatatables_60 but there are some skipped numbers. However, 8 was not one.
No problem. Happy New Year to all of you. The wdtGeneratedTablesCount value was 7. I just changed it to be the last table number. Thanks for you help. Keep up the good work with this plug-in.
I am trying to use the Create a table manually option. An error occurs. Here is what was found in the php error log:
WordPress database error Table 'wp_wpdatatable_8' already exists for query CREATE TABLE wp_wpdatatable_8 (
wdt_ID INT( 11 ) NOT NULL AUTO_INCREMENT,`term` VARCHAR(255) , `rate` DECIMAL(16,4) , UNIQUE KEY wdt_ID (wdt_ID)) CHARACTER SET=utf8 COLLATE utf8_general_ci made by do_action('wp_ajax_wpdatatables_create_manual_table'), WP_Hook->do_action, WP_Hook->apply_filters, wdtCreateManualTable, wpDataTableConstructor->generateManualTable
wp_datatable_8 does already exist. How does the table number get determined when creating a table? In the database there are tables wp_wpdatatable_3 thru wp_wpdatatables_60 but there are some skipped numbers. However, 8 was not one.
Thanks
Hi tnconnect,
Thank you for your purchase.
Sorry for late response. We were closed during New Year holidays.
Can you please check in database in wordpress table wp_options what is the value of the option wdtGeneratedTablesCount?
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
No problem. Happy New Year to all of you. The wdtGeneratedTablesCount value was 7. I just changed it to be the last table number. Thanks for you help. Keep up the good work with this plug-in.
Hi tnconnect,
You are welcome. Glad that we help you.
If you have any more issues feel free to open a new ticket, we will gladly help.
We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables