Malc Stewart

Hi Stiofan,

Further to this I have a slow log report and some information from the server support team at 1and1.

They have said:

“We have found that your server is doing some queries that has some serious problems. Looking at your database, you only have 191,176 rows at the time of writing in the database, but the SQL queries are searching upwards of a million rows. I believe this is the reason some pages are having troubles. We got the second and third queries by searching for restaurants in Gloucester and then changing results page, whilst the first is pulled from the slow log.”

I have attached the log file they sent me.

Let me know about your preferred option for accessing the database from my previous message and I’ll set that up.

Thanks again Stiofan

Best regards

Malc

Hi Stiofan,

Thanks for coming back – I’ve changed the widgets I’m aware of to no longer use Random:

DD Homepage Area 2 >

1. GD > Popular Post View: Featured, FROM Random TO A-Z
2. GD > Popular Post View: A selection to tempt you…, FROM Random TO Latest

GD Home Content Section >

1. GD > Popular Post View: Search Results, FROM Random TO Latest
2. GD > Popular Post View: Venue Spotlight > Post Category, FROM All TO Restaurants
3. GD > Popular Post View: Venue Spotlight, FROM Random TO A-Z

This has made no difference in respect of the problem we are experiencing.

To be clear about our problem: If from the homepage I enter the search term “Noodle” in the first search field and leave the second field blank, the search results take 1 minute and 17 seconds to come in. If I repeat that search (without closing the browser) it takes 4.1 seconds. Similarly on another browser the search result will be quick. Change the search term to “Noodles” plural, and we’re back to over a minute to get a result. To experience what we’re seeing I would suggest you try something like “Bangladeshi” as I haven’t used that search term.

Although we purchased and activated GD Booster, I have disabled it again, and I’m not really noticing any difference, so whilst testing this problem we’re leaving it disabled.

If we use the “Near me” search the results came in in 6.6 seconds.

The problem we have, therefore, is that users searching using the search field – the main purpose of our directory, will simply not use our site a second time, completely negating our business. I don’t know if it has any relevance but the form search returns the URL https://dinnerdata.co.uk/?geodir_search=1&stype=gd_place&s=Noodle&snear=&sgeo_lat=&sgeo_lon=, and the “Near me” search returns https://dinnerdata.co.uk/location/me/. Your own instructions in GD Booster comment on use of unfriendly permalinks, which the https://dinnerdata.co.uk/?geodir_search=1&stype=gd_place&s=Noodle&snear=&sgeo_lat=&sgeo_lon= seems to be an example of?

Our broadband download speed is over 25MB on wifi, and equivalent tests on cellular mobiles have had no better luck.

Obviously a bit of a critical problem for us here, so very grateful for an answer to this.

Many thanks

Best regards

Malc

Hi again,

Further to my previous note, I have (temporarily) fixed the search problem by amending Multilocations > Location Settings > GEO DIRECTORY LOCATION SETTINGS to Enable default country, instead of Enable Selected Countries.

We did have Enable Selected Countries set with Ireland and United Kingdom, with both of these added via the Add/Edit location tab, and showing under SEO settings, but this wasn’t preventing the search using USA lat long.

Is this me not getting the settings right, or is it a possible bug?

Regards

Malc

Hi Guust,

Deactivated BuddyBoss Wall, and reactivated Advanced search and the problem is the same.

Some autocomplete searches worked – eg “Tapas”, others didn’t – eg “restaurant”. As it is now a live site we have reversed the activation again and deactivated Advanced Search

We need BuddyBoss Wall anyway for our service, so perhaps we can apply for a refund and look again at purchasing the product when the integration problem is resolved?

Thanks

Malc

Thank Paolo,

Apart from managing to feel a bit of an idiot, I’ve learnt now that I need to pay more attention to the “Find” settings which I had turned on to whole words only, so missed favorites when looking for favorite.

We have one other main issue which I’ve already raised separately about subdomains throwing a fatal error since we upgraded. I’ll look out for follow-up on that from there.

Thanks again

Malc

Thanks guys, will try updating tomorrow morning and will let you know.

If I still have problems I’ll open up FTP access for you

Cheers

Malc