Fatal Error
Good day, I am getting a fatal error on my WP dashboard caused by FluentForms. Please could someone let me know where I can get some help? Thank you
What error are you getting? Can you share the error log or lines?
Error Details
\=============
An error of type E_ERROR was caused in line 127 of the file /home/betterfoods/htdocs/betterfoods.co.za/wp-content/plugins/fluentform/vendor/wpfluent/framework/src/WPFluent/Database/Query/WPDBConnection.php. Error message: Uncaught Exception: Unknown column 'wp_COUNT(wp_fluentform_submissions.id)' in 'field list' in /home/betterfoods/htdocs/betterfoods.co.za/wp-content/plugins/fluentform/vendor/wpfluent/framework/src/WPFluent/Database/Query/WPDBConnection.php:127
Stack trace:
#0 /home/betterfoods/htdocs/betterfoods.co.za/wp-content/plugins/fluentform/vendor/wpfluent/framework/src/WPFluent/Database/Query/Builder.php(1627): FluentForm\Framework\Database\Query\WPDBConnection->select()
#1 /home/betterfoods/htdocs/betterfoods.co.za/wp-content/plugins/fluentform/vendor/wpfluent/framework/src/WPFluent/Database/Query/Builder.php(1613): FluentForm\Framework\Database\Query\Builder->runSelect()
#2 /home/betterfoods/htdocs/betterfoods.co.za/wp-content/plugins/fluentform/vendor/wpfluent/framework/src/WPFluent/Database/Orm/Builder.php(627): FluentForm\Framework\Database\Query\Builder->get()
#3 /home/betterfoods/htdocs/betterfoods.co.za/wp-content/plugins/fluentform/vendor/wpfluent/framework/src/WPFluent/Database/Orm/Builder.php(318): FluentForm\Framework\Database\Orm\Builder->getModels()
#4 /home/betterfoods/htdocs/betterfoods.co.za/wp-content/plugins/fluentform/app/Modules/DashboardWidgetModule.php(47): FluentForm\Framework\Database\Orm\Builder->get()
#5 /home/betterfoods/htdocs/betterfoods.co.za/wp-content/plugins/fluentform/app/Hooks/actions.php(138): FluentForm\App\Modules\DashboardWidgetModule->showStat()
#6 /home/betterfoods/htdocs/betterfoods.co.za/wp-admin/includes/template.php(1453): FluentForm\Framework\Foundation\Application->{closure:{closure:/home/betterfoods/htdocs/betterfoods.co.za/wp-content/plugins/fluentform/app/Hooks/actions.php:131}:137}()
#7 /home/betterfoods/htdocs/betterfoods.co.za/wp-admin/includes/dashboard.php(271): do_meta_boxes()
#8 /home/betterfoods/htdocs/betterfoods.co.za/wp-admin/index.php(204): wp_dashboard()
#9 {main}
Next FluentForm\Framework\Database\QueryException: Unknown column 'wp_COUNT(wp_fluentform_submissions.id)' in 'field list' (SQL: select `wp_fluentform_forms`.`title`, `wp_fluentform_submissions`.`form_id`, `wp_COUNT(wp_fluentform_submissions`.`id)` as `total`, `wp_MAX(wp_fluentform_submissions`.`id)` as `max_id`, `SUM(CASE` as `wp_fluentform_submissions.status` from `wp_fluentform_submissions` inner join `wp_fluentform_forms` on `wp_fluentform_forms`.`id` = `wp_fluentform_submissions`.`form_id` group by `wp_fluentform_submissions`.`form_id` order by `max_id` desc limit 10) in /home/betterfoods/htdocs/betterfoods.co.za/wp-content/plugins/fluentform/vendor/wpfluent/framework/src/WPFluent/Database/Query/WPDBConnection.php:127
Stack trace:
#0 /home/betterfoods/htdocs/betterfoods.co.za/wp-content/plugins/fluentform/vendor/wpfluent/framework/src/WPFluent/Database/Query/Builder.php(1627): FluentForm\Framework\Database\Query\WPDBConnection->select()
#1 /home/betterfoods/htdocs/betterfoods.co.za/wp-content/plugins/fluentform/vendor/wpfluent/framework/src/WPFluent/Database/Query/Builder.php(1613): FluentForm\Framework\Database\Query\Builder->runSelect()
#2 /home/betterfoods/htdocs/betterfoods.co.za/wp-content/plugins/fluentform/vendor/wpfluent/framework/src/WPFluent/Database/Orm/Builder.php(627): FluentForm\Framework\Database\Query\Builder->get()
#3 /home/betterfoods/htdocs/betterfoods.co.za/wp-content/plugins/fluentform/vendor/wpfluent/framework/src/WPFluent/Database/Orm/Builder.php(318): FluentForm\Framework\Database\Orm\Builder->getModels()
#4 /home/betterfoods/htdocs/betterfoods.co.za/wp-content/plugins/fluentform/app/Modules/DashboardWidgetModule.php(47): FluentForm\Framework\Database\Orm\Builder->get()
#5 /home/betterfoods/htdocs/betterfoods.co.za/wp-content/plugins/fluentform/app/Hooks/actions.php(138): FluentForm\App\Modules\DashboardWidgetModule->showStat()
#6 /home/betterfoods/htdocs/betterfoods.co.za/wp-admin/includes/template.php(1453): FluentForm\Framework\Foundation\Application->{closure:{closure:/home/betterfoods/htdocs/betterfoods.co.za/wp-content/plugins/fluentform/app/Hooks/actions.php:131}:137}()
#7 /home/betterfoods/htdocs/betterfoods.co.za/wp-admin/includes/dashboard.php(271): do_meta_boxes()
#8 /home/betterfoods/htdocs/betterfoods.co.za/wp-admin/index.php(204): wp_dashboard()
#9 {main}
thrown
Clive Brandon looks like a very site specific issue. Would you please open a support ticket so our team can take a look.
Clive Brandon Local is lekker. 🇿🇦❤️😊
WordPress version 6.9.1
Active theme: TastyDaily - Child (version 1.0)
Current plugin: Fluent Forms (version 6.1.15)
PHP version 8.5.0
ok, will do.. thank you very much. This is happening on 2 of our sites. Both on the dashboard, different themes and different servers though.
ok, I deleted the plugin.. downloaded the fluentform.6.1.16 version.. did the update that was available and still same issue.. I did however disable Bulk Edit Products, Prices & Attributes for Woocommerce plugin and the forms are now working again. Seems to have been a conflict with the bulk edit products and pricing.
Clive Brandon can you share the URL of the Bulk Edit Products, Prices & Attributes for Woocommerce so we can check and find the issue.
https://woocommerce.com/products/bulk-edit-products-prices-and-attributes/
I have not tried to update that plugin yet but will do on a test site, when I get a chance. We're not using the bulk edit plugin at the moment on the live sites.