Attempting to edit an existing entry in MySQL bases wpDataTable - get an error msg in top right corner then it locks up with endless loop animation (screen cap attached).
From error log:
[27-Feb-2021 14:46:10 UTC] PHP Fatal error: Uncaught Error: Call to a member function format() on bool in /opt/bitnami/apache2/htdocs/wp/wp-content/plugins/wpdatatables/controllers/wdt_ajax_actions.php:331 Stack trace: #0 /opt/bitnami/apache2/htdocs/wp/wp-includes/class-wp-hook.php(287): wdtSaveTableFrontend('') #1 /opt/bitnami/apache2/htdocs/wp/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters('', Array) #2 /opt/bitnami/apache2/htdocs/wp/wp-includes/plugin.php(484): WP_Hook->do_action(Array) #3 /opt/bitnami/apache2/htdocs/wp/wp-admin/admin-ajax.php(199): do_action('wp_ajax_nopriv_...') #4 {main} thrown in /opt/bitnami/apache2/htdocs/wp/wp-content/plugins/wpdatatables/controllers/wdt_ajax_actions.php on line 331
Thank you for your purchase, and sorry for the inconvenience.
If I'm not mistaken, this is happening on front-end? With that in mind, it could be the query that's causing the issue - can you show it to me, please?
Only one MySQL table can be edited at a time. Queries from multiple tables with joins cannot be used as an editable feature, since SQL UPDATE and INSERT statements are generated automatically, and there currently is no way to update multiple tables
Hey Aleksandar, sorry for delay - brutal couple days! Yes it's on the front end and my query was a simple "SELECT * from wp_registration". I've just returned to troubleshooting and found that it's due to attempting to save an incorrect date format. If you type (for example) "-4-06-27" into a date field, you may be able to recreate the same. So now that I know about it, it's not an emergency problem however it should likely be addressed. Cheers, Scott
It's definitely that, and it will be forwarded to our development team for review. I don't know if they'll be able to fix it (skipping the first dash), but if there's a way, they'll surely try.
Attempting to edit an existing entry in MySQL bases wpDataTable - get an error msg in top right corner then it locks up with endless loop animation (screen cap attached).
From error log:
[27-Feb-2021 14:46:10 UTC] PHP Fatal error: Uncaught Error: Call to a member function format() on bool in /opt/bitnami/apache2/htdocs/wp/wp-content/plugins/wpdatatables/controllers/wdt_ajax_actions.php:331
Stack trace:
#0 /opt/bitnami/apache2/htdocs/wp/wp-includes/class-wp-hook.php(287): wdtSaveTableFrontend('')
#1 /opt/bitnami/apache2/htdocs/wp/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters('', Array)
#2 /opt/bitnami/apache2/htdocs/wp/wp-includes/plugin.php(484): WP_Hook->do_action(Array)
#3 /opt/bitnami/apache2/htdocs/wp/wp-admin/admin-ajax.php(199): do_action('wp_ajax_nopriv_...')
#4 {main}
thrown in /opt/bitnami/apache2/htdocs/wp/wp-content/plugins/wpdatatables/controllers/wdt_ajax_actions.php on line 331
Hello Scott
Thank you for your purchase, and sorry for the inconvenience.
If I'm not mistaken, this is happening on front-end? With that in mind, it could be the query that's causing the issue - can you show it to me, please?
Only one MySQL table can be edited at a time. Queries from multiple tables with joins cannot be used as an editable feature, since SQL UPDATE and INSERT statements are generated automatically, and there currently is no way to update multiple tables
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
Hey Aleksandar, sorry for delay - brutal couple days! Yes it's on the front end and my query was a simple "SELECT * from wp_registration". I've just returned to troubleshooting and found that it's due to attempting to save an incorrect date format. If you type (for example) "-4-06-27" into a date field, you may be able to recreate the same. So now that I know about it, it's not an emergency problem however it should likely be addressed. Cheers, Scott
Thanks for letting me know, Scott!
It's definitely that, and it will be forwarded to our development team for review. I don't know if they'll be able to fix it (skipping the first dash), but if there's a way, they'll surely try.
Thanks for the feedback!
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