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:
- stop running sphinx processes
killall -9 searchd - 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 
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 
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