Skip Navigation

[Resolved] I can't resolve an error in my logs that shows an issue with Map function

This support ticket is created 5 years, 2 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Hong_Kong (GMT+08:00)

This topic contains 2 replies, has 2 voices.

Last updated by Eric 5 years, 2 months ago.

Assisted by: Luo Yang.

Author
Posts
#1346621

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

#1346823

Dear Eric,

In your debug logs, there is a missing Mysql function.

Which MySQL server version are you using?
According to our document:
https://toolset.com/toolset-requirements/
These are the minimum requirements to run Toolset plugins:
...
MySQL 5.6 and above.

It is the same requirement as WordPress:
https://wordpress.org/support/article/requirements/

#1350641

Yes, that was the problem... I upgraded MySQL as well as PHP to get up to date. All is working better now.

Thank you!