[Resolved] "The site is experiencing technical difficulties." Message

[Author]

Posts

[maxfieldB]

I am trying to:
View my site - however I instead am receiving a message which reads "The site is experiencing technical difficulties." - it appears that this issue has affected other toolset users reading through the tech support tickets. Can you help me resolve it?

Link to a page where the issue can be seen:
hidden link

I expected to see:
My website

Instead, I got:
An error message which reads "The site is experiencing technical difficulties."

[Minesh]

Hello. Thank you for contacting the Toolset support.

I checked the site link you shared: hidden link but I do not see the error message you reported.

Is it solved? if no, Can you please share more details when exactly it happens? When you try to activate a specific Toolset plugin?

Once you share more details about when exactly this issue happens I'll be able to guide you in the right direction.

[maxfieldB]

Hello there,

Unfortunately this issue is not predictable, it comes and goes and we are unable to understand what conditions cause it.

However our server errors checked immediately afterward seem to indicate Toolset as the source of the error - specifically the custom post type of "Adult Programs" which are being shown on a large map on our homepage, around 800 items.

Attaching server error below. Our technical contact at Dreamhost Hosting Service encouraged us to reach out to you. Thanks!

[Mon Nov 25 15:32:53.466986 2019] [core:error] [pid 15625] [client 73.202.187.50:55104] End of script output before headers: index.php, referer: hidden link

[maxfieldB]

Secondly, when I login to the dashboard, I see another error - not sure if it's related, but according to Safari Console is also being cause by Toolset Types plugin. Attaching image below:

[Minesh]

First of all - as you acknowledge that you are trying to display map with almost 800 pins (still this is not confirmed that the issue is related to this but its worth to check).

This is not the recommended way as it will require too much server resources as well as the majority of the problem here is in rendering API, and we can't control it. It's simply too much.

So, to ensure that the issue is related to the map where you display 800 pins, what if you try to add pagination to your view using which you display the map.

More info:
=> https://toolset.com/documentation/beyond-the-basics/paginate-lists-of-content/

Do you see any difference?

[maxfieldB]

Hello Minesh,

I don't think that it, since we've had 800+ records for the last month, and this error only started appearing sporadically over the last week. Our user experience relies on showing all 800 so we prefer not to add pagination from a product design perspective. I'm attaching a few other responses I've seen on toolset to this same error message while reading through the support forum - one was actually from you, and sounds similar to what I indicated above where there was one specific post, "Queens Public Library," that was causing problems.

Do you think that is related to the problem we are having? Is there any way to check?

[Minesh]

Well - the screenshot you shared from replies are both different. I do not see any concrete relations.

With my reply which you shared with screenshot - the user was not using Toolset Maps plugin.
=> https://toolset.com/forums/topic/content-templatessingle-page-the-site-is-experiencing-technical-difficulties/#post-1355029

Regarding Christian's reply:
=> you can check if the same module is active on your server or not.

Now, to troubleshoot this further, I need access details first so I can check first what is going on.

*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.

I have set the next reply to private which means only you and I have access to it.

[maxfieldB]

Should I send you a duplicator package?

Now that we have migrated it to our new server - we are able to see more detail around the error logs - pasting below, does this help?

[Mon Dec 02 08:13:47.603548 2019] [php7:notice] [pid 18804] [client 107.3.129.220:12120] WordPress database error Duplicate entry '150 Broadway 20th Floor, New York, NY 10038.' for key 'PRIMARY' for query INSERT INTO wp_j3urba_toolset_maps_address_cache ( `address_passed`, `address`, `point` ) VALUES ( '150 Broadway 20th Floor, New York, NY 10038.', '150 Broadway 20th Floor, New York, NY 10006, USA', ST_PointFromText('POINT(-74.010143 40.709189)') ) /* From [tnycstaging.wpengine.com/] in [/nas/content/live/tnycstaging/wp-content/plugins/toolset-maps/includes/toolset-common-functions.php:1219] */ made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/h-code/page.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, vc_do_shortcode, WPBakeryShortCode->output, WPBakeryShortCode->content, WPBakeryShortCode->loadTemplate, require('/plugins/js_composer/include/templates/shortcodes/vc_section.php'), wpb_js_remove_wpautop, do_shortcode, preg_replace_callback, do_shortcode_tag, hcode_row, do_shortcode, preg_replace_callback, do_shortcode_tag, vc_column, do_shortcode, preg_replace_callback, do_shortcode_tag, vc_column_text, hcode_remove_wpautop, do_shortcode, preg_replace_callback, do_shortcode_tag, WP_Views->short_tag_wpv_view, WP_Views->render_view_ex, WP_Views->render_view, wpv_do_shortcode, apply_filters('wpv-pre-do-shortcode'), WP_Hook->apply_filters, Toolset_Addon_Maps_Views->run_shortcodes, do_shortcode, preg_replace_callback, do_shortcode_tag, Toolset_Addon_Maps_Views->marker_shortcode, Toolset_Addon_Maps_Common::get_coordinates, Toolset_Addon_Maps_Common::get_coordinates_new, Toolset_Addon_Maps_Common::update_cached_coordinates

[Minesh]

What if you try to repair your table for the MySQL error.

*** Please make a FULL BACKUP of your database and website.***
Again, another reminder to make a full backup of your site's database. This is really important.

Once you took database backup,
What if you try to Repair wp_j3urba_toolset_maps_address_cache database table to fix the primary key issue.

If you have access to the database with phpMyAdmin access details, you can repair a table by performing the steps given with the following link:
=> hidden link

Please note that you only need to repair wp_j3urba_toolset_maps_address_cache database table, so do not select all tables.

Do you see any issue after you repair the wp_j3urba_toolset_maps_address_cache database table?