External_search_in_use problem

I modify the timeout but it’s still broken

I just a new thing

Jun 06 18:02:08 ip-172-31-15-131 sharetri2[1152]: App 2379 stdout: {"method":"HEAD","path":"/","format":"html","controller":"HomepageController","action":"index","status":301,"duration":82.4
Jun 06 18:03:29 ip-172-31-15-131 sharetri2[1152]: App 2379 stdout: {"method":"GET","path":"/","format":"html","controller":"HomepageController","action":"index","status":200,"duration":26429
Jun 06 18:03:42 ip-172-31-15-131 sharetri2[1152]: App 2379 stdout: {"marketplace_id":1,"tag":"listing_index_service","free":"Error connecting to Sphinx via the MySQL protocol. Error connecti
Jun 06 18:03:47 ip-172-31-15-131 sharetri2[1152]: App 2379 stdout: {"method":"GET","path":"/","format":"html","controller":"HomepageController","action":"index","status":500,"duration":7789.

“Error connecting to Sphinx via the MySQL protocol” I don’t know how to resolve it, I know the server is good, I just test to connect to it (Being a AWS server, It’s an external database)

Does anyone know how to solve this problem?

You should do following:

  1. stop running sphinx processes
    killall -9 searchd
  2. restart sphinx
    RAILS_ENV=production rake ts:rebuild

That works ! Thank you !

Do you know how to put a popup on the main page ?

I’d like to give an information to my community and I don’t know how to write something on the main page

I also would like to put my chatbox on my website, so know how to modify html file is mandatory for me :confused:

I tried to use the patch but when I restart Sphinx I get this error:

ERROR: index ‘listing_delta’: sql_range_query: Expression #20 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘sharetribe_production.locations.latitude’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (DSN=mysql://sharetribe:***@localhost:3306/sharetribe_production).
ERROR: index ‘listing_delta’: sql_range_query: Expression #20 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘sharetribe_production.locations.latitude’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (DSN=mysql://sharetribe:***@localhost:3306/sharetribe_production).

I guess this is related to the mysql database.

see this fix for group by https://github.com/sharetribe/sharetribe/pull/3256#issuecomment-400919987

Thanks for this awesome patch, what is the radius size used, and is it possible to change the radius size?

Hello,

I would like to use this most essential patch with Sharetribe 10, but I believe it’s not compatible anymore (patch fails to apply)… Would anyone know if there is a way to get through with that ? @zenik, I believe you were the one who came up with this solution ?

Thanks a lot for your help !

EDIT : in the end I managed to get through, sorry ! I had to apply the patch manually for one of the files, then I had to follow the instructions given in this post https://www.sharetribe.com/community/t/will-the-new-improved-search-function-on-sharetribe-com-come-to-the-open-source-version/107/27 to get the search working again

1 Like

Good to hear, @Pierre-Louis_de_Lapo!

And thanks a lot for sharing the solution, that surely will help other visitors of that forum :slight_smile: Great spirit here, much appreciated!

Applying the patch worked like a charm. Funny thing is that when I set location to private to show listing locations approximate wit a radius, the whole map disappears. On the homepage looking on the map, it still shows the map with exact locations.

Applying the patch, feedback is given that 1 of 4 parts where already part of an upstream patch.

Any thoughts on what causes this problem?

Hi @Lennard
You need to enable Google Maps static API for your google maps API key. Hopefully, this will work.
Please let me know if I can still assist you with any issues or implementations in your marketplace application.

Regards,
Aman
Email - mailtoamanam@gmail.com
https://www.upwork.com/freelancers/~0186c7b9e674fc8699

That was indeed the problem. Static API was not allowed in Google cloud console. Much appreciated Aman. Thank you