I have been getting many conflicts and issues rendering the site over the last week or so and here is a snippet from one of my error logs:
[Mon Sep 23 19:07:52.171692 2019] [proxy_fcgi:error] [pid 31031] [client 127.0.0.1:42155] AH01071: Got error 'PHP message: WordPress database error FUNCTION swnxtfjdfx.ST_X does not exist for query SELECT address_passed, ST_X(point) as lon, ST_Y(point) as lat FROM rjoy_nw18_toolset_maps_address_cache made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/Avada/single.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, WPDD_Layouts_RenderManager->render_template_layout_for_post, apply_filters('get_the_ddlayout'), WP_Hook->apply_filters, get_the_ddlayout, WPDD_Layouts->get_layout_content_for_render, WPDD_Layouts_RenderManager->get_layout_content_for_render, WPDD_Layouts_RenderManager->get_rendered_layout_content, WPDD_layout_render->render, WPDD_layout_render->render_to_html, WPDD_layout->frontend_render, WPDD_layout_row->frontend_render, WPDD_layout_cell->frontend_render, WPDD_layout_cell_text->frontend_render_cell_content, WPDD_layout_cell_text->handle_content_filters, apply_filters('the_content'), WP_Hook->apply_filters, Toolset_Addon_Maps_V...\nPHP message:....
[it keeps going from here depending upon how many mapped items are to show on the page]
I am using Avada and several other plugins, but I thought I would inquire about this issue before pushing everything to staging and backing out as many plugins until the error resolves... and it appears when dealing with Maps.
I have already tried restoring site from a previous backup and incrementally updating Toolset Views, Maps, Forms, etc plugins to see if the problem fixed itself. Unfortunately no updates to the latest versions solve the problem.
Any ideas?
Eric