If you have an older version, can you please update your Plugin?
Here is a guide if you need advice on how to do this :
The most important step is to check this option;
In the main plugin settings/'Prevent deleting tables in database'.
When you have that enabled, it means that all your tables, settings and charts will remain safe in your WordPress Database, so you can safely update the plugin.
If you activated the purchase code in wpDataTables Settings/Activation, the update should be offered in the Plugins section. On some WordPress installations, you need to deactivate the plugin first in order to see the update offered, so please try that.
If that doesn't work, try going through Dashboard/Updates. See if you can update the plugin through there, and if that doesn't work either, you can follow the manual update procedures from this Guide :
Hello,
We have used your plugin for a while, and now we have paid version.
Since we have upgraded, we could not create a tables.
We cant create a table, could you please assist me in this question ?
Our IT support provided me the error log down below.
Also the error screenshot is attached.
WordPress database error Table 'pm_wpdatatable_2' already exists for query CREATE TABLE pm_wpdatatable_2 (
wdt_ID INT( 11 ) NOT NULL AUTO_INCREMENT,`newcolumn` VARCHAR(255) , `newcolumn1` VARCHAR(255) , `newcolumn2` VARCHAR(255) , `newcolumn3` VARCHAR(255) , 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, W3TCDbCache_WpdbNew->query, W3TCDbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TCDbCache_WpdbNew->query, W3TCDbCache_WpdbInjection->query, W3TCDbCache_WpdbNew->default_query
[27-Jun-2024 08:12:28 UTC] PHP Fatal error: Uncaught Exception: There was an error when trying to create the table on MySQL side: Table 'pm_wpdatatable_2' already exists in /var/www/pm-relaunch/wp-content/plugins/wpdatatables/source/class.constructor.php:429
Stack trace:
#0 /var/www/pm-relaunch/wp-content/plugins/wpdatatables/controllers/wdt_admin_ajax_actions.php(339): wpDataTableConstructor->generateManualTable()
#1 /var/www/pm-relaunch/wp-includes/class-wp-hook.php(324): wdtCreateManualTable()
#2 /var/www/pm-relaunch/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#3 /var/www/pm-relaunch/wp-includes/plugin.php(517): WP_Hook->do_action()
#4 /var/www/pm-relaunch/wp-admin/admin-ajax.php(192): do_action()
#5 {main}
thrown in /var/www/pm-relaunch/wp-content/plugins/wpdatatables/source/class.constructor.php on line 429
Attached files: datatables.png
Hi Stanislavs,
I can see from your screenshot, this seems to be a very old wpDatatables version, looking at the interface, buttons and so on...
Can you please check in your Plugins List, what is the version of your currently installed wpDataTables showing?
The latest one should be version 6.5.3.
If you have an older version, can you please update your Plugin?
Here is a guide if you need advice on how to do this :
The most important step is to check this option;
In the main plugin settings/'Prevent deleting tables in database'.
When you have that enabled, it means that all your tables, settings and charts will remain safe in your WordPress Database, so you can safely update the plugin.
If you activated the purchase code in wpDataTables Settings/Activation, the update should be offered in the Plugins section. On some WordPress installations, you need to deactivate the plugin first in order to see the update offered, so please try that.
If that doesn't work, try going through Dashboard/Updates. See if you can update the plugin through there, and if that doesn't work either, you can follow the manual update procedures from this Guide :
Updating the plugin to the latest version
After you install the latest version, please try to create the table again and check if the issue is solved.
Let me know how it goes.
Thank you.
Kind Regards,
Miloš Jovanović
[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