In standard mode when we try and save/update a table it says :
"Error! There was an error trying to save a new row!"
and in the browser console it says "Failed to load resource: the server responded with a status of 500 (Internal Server Error) /wp-admin/admin-ajax.php:1"
In Excel mode when we try and save it gives a JavaScript error :
Please provide me a temporary 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.
Also point me on table id where this is happening so we can investigate.
From your log file we can see that you have Fatal error:
Call to undefined function mb_convert_encoding()
It looks like your PHP installation doesn’t have mbstring installed. Go through this guide, which will give you more information on how to install it: http://php.net/manual/en/mbstring.installation.php
If you don’t have that much access on your server, contact your hosting provider and ask them to do it for you.
Installing MBString has allowed us to save changes to table data in standard mode. But when we try and edit a column and change something like the column data type we get "There was an error while trying to save the table! Internal Server Error" and the debug log shows :
[17-Aug-2018 01:45:46 UTC] PHP Notice: Undefined variable: colObjs in /public_html/wp-content/plugins/wpdatatables/source/class.wpdatatable.php on line 1681
[17-Aug-2018 01:45:54 UTC] PHP Notice: Undefined variable: mysql_table_name in /public_html/wp-content/plugins/wpdatatables/source/class.wdtconfigcontroller.php on line 568
[17-Aug-2018 01:45:54 UTC] PHP Fatal error: Uncaught Error: Cannot access empty property in /public_html/wp-content/plugins/wpdatatables/source/class.wdtconfigcontroller.php:568
Stack trace:
#0 /public_html/wp-content/plugins/wpdatatables/source/class.wdtconfigcontroller.php(48): WDTConfigController::saveColumns(Array, Object(WPDataTable), 7)
#1 /public_html/wp-content/plugins/wpdatatables/controllers/wdt_admin_ajax_actions.php(51): WDTConfigController::saveTableConfig(Object(stdClass))
#2 /public_html/wp-includes/class-wp-hook.php(286): wdtSaveTableWithColumns('')
#3 /public_html/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters('', Array)
#4 /public_html/wp-includes/plugin.php(453): WP_Hook->do_action(Array)
#5 /public_html/wp-admin/admin-ajax.php(100): do_action('wp_ajax_wpdatat...')
#6 {main} thrown in /public_html/wp-content/plugins/wpdatatables/source/class.wdtconfigcontroller.php on line 568
Can you please tell me which version of plugin you are using? (We can't login in with credentials that you provide to check this)
Those notices and that fatal error because of issue with mysql table name was fix in latest version of plugin which is 2.2.3. We didn't release auto update yet but you can update the plugin manually by following this steps:
We are unable to edit any of our WPDataTables.
In standard mode when we try and save/update a table it says :
"Error! There was an error trying to save a new row!"
and in the browser console it says "Failed to load resource: the server responded with a status of 500 (Internal Server Error) /wp-admin/admin-ajax.php:1"
In Excel mode when we try and save it gives a JavaScript error :
function(){return f&&(c&&!b&&(h=f.length-1,g.push(c)),function d(b){n.each(b,function(b,c){n.isFunction(c)?a.unique&&j.has(c)||f.push(c):c&&c.length&&"string"!==n.type(c)&&d(c)})}(arguments),c&&!b&&i()),this}
We have updated the plugin to the latest version (2.2.1)
We have tried both WordPress and 'use separate MySQL connection' (the test MYSQL settings says 'Success')
Our INFO page reports the following :
We urgently need to get this working again.
Thanks,
Jason
Hi Jason,
Thank you for your purchase.
Please provide me a temporary 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.
Also point me on table id where this is happening so we can investigate.
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
Hi Jason,
From your log file we can see that you have Fatal error:
It looks like your PHP installation doesn’t have
mbstring
installed.Go through this guide, which will give you more information on how to install it: http://php.net/manual/en/mbstring.installation.php
If you don’t have that much access on your server, contact your hosting provider and ask them to do it for you.
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
Hello Milan,
Installing MBString has allowed us to save changes to table data in standard mode. But when we try and edit a column and change something like the column data type we get "There was an error while trying to save the table! Internal Server Error" and the debug log shows :
Thanks,
Jason
Hi Jason,
Can you please tell me which version of plugin you are using? (We can't login in with credentials that you provide to check this)
Those notices and that fatal error because of issue with mysql table name was fix in latest version of plugin which is 2.2.3. We didn't release auto update yet but you can update the plugin manually by following this steps:
1.) Download zip from this link
2.) Use FTP to open /yourwordpressfolder/wp-content/plugins
3.) Delete existing wpdatatables folder.
4.) Upload previously downloaded wpdatatables folder through FTP to plugins folder (unzip it)
5.) Go to WP-admin panel, open Plugins section.
6.) Deactivate wpDataTables, and then activate it again.
7.) Clear server and browser cache
IMPORTANT: Do NOT delete the old version from WP-admin (by clicking “Delete” in the plugins page) if you don’t want to lose all your tables!
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