{"action":"created","issue":{"url":"https://api.github.com/repos/camptocamp/c2cgeoportal/issues/1535","labels_url":"https://api.github.com/repos/camptocamp/c2cgeoportal/issues/1535/labels{/name}","comments_url":"https://api.github.com/repos/camptocamp/c2cgeoportal/issues/1535/comments","events_url":"https://api.github.com/repos/camptocamp/c2cgeoportal/issues/1535/events","html_url":"https://github.com/camptocamp/c2cgeoportal/issues/1535","id":102123094,"number":1535,"title":"[1.6] WSGI an PHP conflict","user":{"login":"gnerred","id":1989467,"avatar_url":"https://avatars.githubusercontent.com/u/1989467?v=3","gravatar_id":"","url":"https://api.github.com/users/gnerred","html_url":"https://github.com/gnerred","followers_url":"https://api.github.com/users/gnerred/followers","following_url":"https://api.github.com/users/gnerred/following{/other_user}","gists_url":"https://api.github.com/users/gnerred/gists{/gist_id}","starred_url":"https://api.github.com/users/gnerred/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gnerred/subscriptions","organizations_url":"https://api.github.com/users/gnerred/orgs","repos_url":"https://api.github.com/users/gnerred/repos","events_url":"https://api.github.com/users/gnerred/events{/privacy}","received_events_url":"https://api.github.com/users/gnerred/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/camptocamp/c2cgeoportal/labels/Workaround","name":"Workaround","color":"207de5"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":14,"created_at":"2015-08-20T11:56:12Z","updated_at":"2015-09-09T08:23:56Z","closed_at":null,"body":"I've upgrade to 1.6.2, and now I've an error 500 with FTS. It worked well in 1.6.1. I'm not able to run step 3 of upgrade, because it checks FTS and get an error. \r\n\r\nThanks\r\n\r\nBase application : \r\nhttp://preprodnew.cartoriviera.ch/\r\n\r\nFTS that returns an error 500 : \r\nhttp://preprodnew.cartoriviera.ch/preprod/wsgi/fulltextsearch?limit=100&partitionlimit=40&query=123&_dc=1440071418492&callback=stcCallback1001\r\n\r\nContent of Apache log : \r\n[Thu Aug 20 13:50:40.738890 2015] [wsgi:error] [pid 15921] 2015-08-20 13:50:40,738 INFO  [sqlalchemy.engine.base.Engine][MainThread] SELECT anon_1.id AS anon_1_id, anon_1.label AS anon_1_label, anon_1.params AS anon_1_params, anon_1.layer_name AS anon_1_layer_name, ST_AsBinary(anon_1.the_geom) AS anon_1_the_geom \r\n[Thu Aug 20 13:50:40.738901 2015] [wsgi:error] [pid 15921] FROM (SELECT main.tsearch.id AS id, main.tsearch.label AS label, main.tsearch.layer_name AS layer_name, main.tsearch.role_id AS role_id, main.tsearch.public AS public, main.tsearch.ts AS ts, main.tsearch.the_geom AS the_geom, main.tsearch.params AS params, row_number() OVER (PARTITION BY main.tsearch.layer_name ORDER BY ts_rank_cd(ts, to_tsquery('french', '123:*'), 2|8) DESC, main.tsearch.label) AS row_number \r\n[Thu Aug 20 13:50:40.738905 2015] [wsgi:error] [pid 15921] FROM main.tsearch \r\n[Thu Aug 20 13:50:40.738908 2015] [wsgi:error] [pid 15921] WHERE ts @@ to_tsquery('french', '123:*') AND main.tsearch.public IS true) AS anon_1 \r\n[Thu Aug 20 13:50:40.738911 2015] [wsgi:error] [pid 15921] WHERE anon_1.row_number <= %(row_number_1)s \r\n[Thu Aug 20 13:50:40.738913 2015] [wsgi:error] [pid 15921]  LIMIT %(param_1)s\r\n[Thu Aug 20 13:50:40.739016 2015] [wsgi:error] [pid 15921] 2015-08-20 13:50:40,738 INFO  [sqlalchemy.engine.base.Engine][MainThread] {'row_number_1': 40, 'param_1': 100}\r\n[Thu Aug 20 13:50:40.757199 2015] [wsgi:error] [pid 12806] [client 10.200.40.150:42217] Truncated or oversized response headers received from daemon process 'c2cgeoportal:preprod': /var/www/vhosts/cartoriviera_preprod/private/cartoriviera_geomapfish/apache/application.wsgi\r\n"},"comment":{"url":"https://api.github.com/repos/camptocamp/c2cgeoportal/issues/comments/138822410","html_url":"https://github.com/camptocamp/c2cgeoportal/issues/1535#issuecomment-138822410","issue_url":"https://api.github.com/repos/camptocamp/c2cgeoportal/issues/1535","id":138822410,"user":{"login":"yjacolin","id":660191,"avatar_url":"https://avatars.githubusercontent.com/u/660191?v=3","gravatar_id":"","url":"https://api.github.com/users/yjacolin","html_url":"https://github.com/yjacolin","followers_url":"https://api.github.com/users/yjacolin/followers","following_url":"https://api.github.com/users/yjacolin/following{/other_user}","gists_url":"https://api.github.com/users/yjacolin/gists{/gist_id}","starred_url":"https://api.github.com/users/yjacolin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yjacolin/subscriptions","organizations_url":"https://api.github.com/users/yjacolin/orgs","repos_url":"https://api.github.com/users/yjacolin/repos","events_url":"https://api.github.com/users/yjacolin/events{/privacy}","received_events_url":"https://api.github.com/users/yjacolin/received_events","type":"User","site_admin":false},"created_at":"2015-09-09T08:23:56Z","updated_at":"2015-09-09T08:23:56Z","body":"For information and history. We installed fpm-php now in the server. "}}