{"action":"opened","issue":{"url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/issues/6811","repository_url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM","labels_url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/issues/6811/labels{/name}","comments_url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/issues/6811/comments","events_url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/issues/6811/events","html_url":"https://github.com/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/issues/6811","id":330912380,"node_id":"MDU6SXNzdWUzMzA5MTIzODA=","number":6811,"title":"0013772:\nAfter upgrading from the latest 2017 version I can no longer search in addresses and I can not select projects using text-search","user":{"login":"Gloirin","id":24605609,"node_id":"MDQ6VXNlcjI0NjA1NjA5","avatar_url":"https://avatars1.githubusercontent.com/u/24605609?v=4","gravatar_id":"","url":"https://api.github.com/users/Gloirin","html_url":"https://github.com/Gloirin","followers_url":"https://api.github.com/users/Gloirin/followers","following_url":"https://api.github.com/users/Gloirin/following{/other_user}","gists_url":"https://api.github.com/users/Gloirin/gists{/gist_id}","starred_url":"https://api.github.com/users/Gloirin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Gloirin/subscriptions","organizations_url":"https://api.github.com/users/Gloirin/orgs","repos_url":"https://api.github.com/users/Gloirin/repos","events_url":"https://api.github.com/users/Gloirin/events{/privacy}","received_events_url":"https://api.github.com/users/Gloirin/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/milestones/112","html_url":"https://github.com/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/milestone/112","labels_url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/milestones/112/labels","id":3410617,"node_id":"MDk6TWlsZXN0b25lMzQxMDYxNw==","number":112,"title":"2018.02.2 Community Edition","description":null,"creator":{"login":"Gloirin","id":24605609,"node_id":"MDQ6VXNlcjI0NjA1NjA5","avatar_url":"https://avatars1.githubusercontent.com/u/24605609?v=4","gravatar_id":"","url":"https://api.github.com/users/Gloirin","html_url":"https://github.com/Gloirin","followers_url":"https://api.github.com/users/Gloirin/followers","following_url":"https://api.github.com/users/Gloirin/following{/other_user}","gists_url":"https://api.github.com/users/Gloirin/gists{/gist_id}","starred_url":"https://api.github.com/users/Gloirin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Gloirin/subscriptions","organizations_url":"https://api.github.com/users/Gloirin/orgs","repos_url":"https://api.github.com/users/Gloirin/repos","events_url":"https://api.github.com/users/Gloirin/events{/privacy}","received_events_url":"https://api.github.com/users/Gloirin/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":12,"state":"closed","created_at":"2018-06-08T12:05:06Z","updated_at":"2018-06-09T19:15:29Z","due_on":null,"closed_at":"2018-06-08T12:05:06Z"},"comments":0,"created_at":"2018-06-09T19:15:29Z","updated_at":"2018-06-09T19:15:29Z","closed_at":null,"author_association":"NONE","body":"**Reported by weberho on 22 Feb 2018 12:38**\n\n**Version:** 2018.02.1 Community Edition\n\nSending a query results into the following. DB Server is mariadb-10.0.33.\r\n\r\nWARN (4): Tinebase_Server_Json::_handleException::411 Zend_Db_Statement_Exception -&gt; SQLSTATE[HY000]: General error: 1191 Can&#039;t find FULLTEXT index matching the column list, query was: SELECT `addressbook`.`id`, `addressbook`.`n_fileas`, `accounts`.`id` AS `account_id` FROM `tine20_addressbook` AS `addressbook`\r\n LEFT JOIN `tine20_accounts` AS `accounts` ON `addressbook`.`id` = `accounts`.`contact_id` WHERE (`addressbook`.`is_deleted` = 0) AND (((((((`addressbook`.`adr_one_locality`  LIKE (&#039;%weber%&#039;))) OR ((`addressbook`.`email`  LIKE (&#039;%weber%&#039;))) OR ((`addressbook`.`email_home`  LIKE (&#039;%weber%&#039;))) OR ((MATCH (`addressbook`.`note`) AGAINST (&#039;+weber*&#039; IN BOOLEAN MODE))) OR ((`addressbook`.`n_family`  LIKE (&#039;%weber%&#039;))) OR ((`addressbook`.`n_given`  LIKE (&#039;%weber%&#039;))) OR ((`addressbook`.`org_name`  LIKE (&#039;%weber%&#039;))) OR ((`addressbook`.`org_unit`  LIKE (&#039;%weber%&#039;)))))))) AND ((`addressbook`.`container_id` IN (&#039;1&#039;, &#039;17&#039;, &#039;4&#039;, &#039;51&#039;))) AND ((/* is no user */ `accounts`.`id` IS NULL OR /* is user */ (`accounts`.`id` IS NOT NULL  AND `accounts`.`status` != &#039;disabled&#039; AND (`accounts`.`visibility` = &#039;displayed&#039; OR `accounts`.`id` = &#039;3d40322c70b1ca136246a61890ae1fee616a027d&#039;)))) GROUP BY `addressbook`.`id` ORDER BY `n_fileas` ASC LIMIT 50\r\n\r\n\r\nTinebase_Server_Json::_handleException::411 Zend_Db_Statement_Exception -&gt; SQLSTATE[HY000]: General error: 1191 Can&#039;t find FULLTEXT index matching the column list, query was: SELECT `timetracker_timeaccount`.* FROM `tine20_timetracker_timeaccount` AS `timetracker_timeaccount` WHERE (`timetracker_timeaccount`.`is_deleted` = 0) AND (((((`timetracker_timeaccount`.`title`  LIKE (&#039;%refa%&#039;))) OR ((`timetracker_timeaccount`.`number`  LIKE (&#039;%refa%&#039;))) OR ((MATCH (`timetracker_timeaccount`.`description`) AGAINST (&#039;+refa*&#039; IN BOOLEAN MODE)))))) AND ((`timetracker_timeaccount`.`is_open` = 1)) ORDER BY `number` ASC LIMIT 50\n"}}
{"actor":{"display_login":"Gloirin"}}