Slow Down Error

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Author

Posts
November 9, 2019 at 10:58 am #516489

Dave
Full Member

Post count: 205

Hi guys,

I’ve been getting intermittent timeouts and slow-downs on my website since migrating the site to a new server. The site can be working fine and responding very quickly, but then every 1-2 minutes, it randomly slows down, stops loading pages and won’t load locations when you try to use the location switcher.

I’ve been working with my host to pinpoint what’s doing it, and they can see that errors are intermittently being logged to the error_log in the wp-admin directory (‘/home/whatsonh/public_html/wp-admin/error_log’):
[08-Nov-2019 17:17:17 UTC] WordPress database error Unknown column ‘location_id’ in ‘where clause’ for query SELECT post_id FROM wp_geodir_gd_place_detail WHERE location_id = 1026 made by do_action(‘geodirectory_page_gd-settings’), WP_Hook->do_action, WP_Hook->apply_filters, GeoDir_Admin_Menus->settings_page, GeoDir_Admin_Settings::output, include(‘/plugins/geodirectory/includes/admin/views/html-admin-settings.php’), do_action(‘geodir_settings_locations’), WP_Hook->do_action, WP_Hook->apply_filters, GeoDir_Location_Settings_Locations->output, GeoDir_Admin_Settings::output_fields, do_action(‘geodir_admin_field_cities_page’), WP_Hook->do_action, WP_Hook->apply_filters, GeoDir_Location_Settings_Locations->cities_page, spl_autoload_call, GeoDir_Location_Autoloader->autoload, GeoDir_Location_Autoloader->load_file, include_once(‘/plugins/geodir_location_manager/includes/admin/class-geodir-location-admin-cities.php’), GeoDir_Location_Admin_Cities->__construct, GeoDir_Location_Admin_Cities->actions, GeoDir_Location_Admin_Cities->bulk_actions, GeoDir_Location_Admin_Cities->delete_city, geodir_location_delete_by_id

Can you please help?

Thanks,
Dave

November 9, 2019 at 11:00 am #516490

Dave
Full Member

Post count: 205

This reply has been marked as private.

November 9, 2019 at 3:21 pm #516495

Alex Rollin
Moderator

Post count: 27815

Try looking up location 1026 and finding which page is dedicated to that. If I recall you have custom pages for some locations.

November 11, 2019 at 8:45 am #516564

Dave
Full Member

Post count: 205

Hi Alex,

Not sure exactly what you mean about custom pages. I only use one of the built-in Listimia theme pages for all locations. I’ve not customised any specifically.

I had a look through all cities and can’t find location 1026. I tried to look in the database but can’t see where the data is stored for locations and the location ID’s. Do you know where I can find it?

Thanks,
Dave

November 11, 2019 at 10:18 am #516580

Alex Rollin
Moderator

Post count: 27815

What is the site URL so we can check the settings?

Find locations listed out in

GD – Settings – Locations (tab) – Cities

November 11, 2019 at 11:54 am #516600

Dave
Full Member

Post count: 205

Hi Alex,

Site is whatsonhub.co.uk (ftp and login details in previous messages).

I’ve checked that section for the location with ID 1026 but cannot see it. I’ve checked all 89 pages too.

Is there anywhere in the DB that I may find the same location details / ID?

Thanks,
Dave

November 12, 2019 at 7:42 am #516706

Naveen Giri
Moderator

Post count: 1559

hi DAVID,

I have checked site seems slow down sometime unexpectedly. I checked logs file but not found any Gd specific error or not even any other
public_html/error_log

where do you get above error?
can you tell me steps to reproduce it. where can i check it?
it will be better, if you can send cpanel details in private reply.

Thanks

November 12, 2019 at 9:35 am #516718

Dave
Full Member

Post count: 205

This reply has been marked as private.

November 13, 2019 at 3:12 pm #516974

Dave
Full Member

Post count: 205

Hi Naveen,

Any news on this please? I urgently need to pinpoint why this slowdown error is happening as it’s stopping us from going live.

Thanks, Dave

November 13, 2019 at 4:27 pm #516988

Naveen Giri
Moderator

Post count: 1559

Hi DAVID,

I checked but haven’t noticed any slow down cause.
I will assign to Kiran, he will reply on it soon.

Thanks

November 13, 2019 at 5:04 pm #516993

Dave
Full Member

Post count: 205

Hi Naveen,

Thanks, but you don’t need to necessarily try to spot the slow down. My server guys have already identified that the error is on the code I’ve previously pasted into this thread.

So what I’m mainly after please is this:

1) A way to identify location 1026 as per Alex’s suggestion
OR
2) Understand what that error code I’ve supplied, actually means and hopefully you guys can fix.

If you can please help me ASAP on this it’d really help as I’m looking to launch as soon as this error is fixed.

Thanks,
Dave

November 14, 2019 at 5:58 am #517090
Kiran
Moderator

Post count: 7069
Hi Dave,

I have enabled debugging via wp-config.php and checked various pages from front-end and from back-end. I don’t see any issue on those pages.

—

The slow downs were happening intermittently just while I was either browsing on the front end, or trying to publish content on the back end.

I checked front-end pages and pages loaded normally without slowdown. There are many plugins so hard to identify which plugin causing slowdown. Do you have staging(test) site? Please try disabling non GD plugins on staging site to check the speed. This will help us to identify if any plugin causing slowdown.

—
I only seen following repeated errors in /wp-content/debug.log file
```
[14-Nov-2019 05:33:58 UTC] PHP Notice:  Undefined property: stdClass::$url in .../wp-content/plugins/indeed-membership-pro/classes/Filters.php on line 26
```
I searched within database but could not find any item for location 1026. It looks like error raised during delete location. I checked error you posted and it happened from function geodir_location_delete_by_id() which is used to delete location. I tried add new location and delete location but could not recreate that error.

Best Regards,
Kiran
November 14, 2019 at 4:04 pm #517155

Dave
Full Member

Post count: 205

Thanks Kiran, that’s a big help.

When I disable the membership plugin that’s generating that error, the slowdown thing goes away and we’re all good.

It seems to be something to do with the modal from that plugin, conflicting with yours from the location switcher… I think?

Either way, I’ll contact their support team and see what can be done.

Thanks for your help.
Dave

November 14, 2019 at 6:42 pm #517184

Alex Rollin
Moderator

Post count: 27815

Excellent,

Next time you can try a sustained test of GD only plugins on a staging server and enable other plugins one by one to isolate the issue.

November 14, 2019 at 8:23 pm #517214

Dave
Full Member

Post count: 205

Yeah thanks Alex, will do.

I did do that this time, but there was the wp-cron problem at the same time so disabling plugins wasn’t working. With my server guys spotting both errors at the same time, that’s why I came to you about 1 of them.

The plugin that’s causing this error, is a membership one which can restrict content based on a user’s level, handles all membership payments etc.

I know you guys do UsersWP which can handle the membership side (registration, login, etc), but do you recommend a plugin that can restrict pages/posts and handle subscriptions that works well with GD and UsersWP?
Author

Posts