{"action":"created","issue":{"url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/issues/4227","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/4227/labels{/name}","comments_url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/issues/4227/comments","events_url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/issues/4227/events","html_url":"https://github.com/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/issues/4227","id":330861691,"node_id":"MDU6SXNzdWUzMzA4NjE2OTE=","number":4227,"title":"0008404:\nPreferences do not work with Postgres","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":[{"id":850704803,"node_id":"MDU6TGFiZWw4NTA3MDQ4MDM=","url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/labels/Bug","name":"Bug","color":"b60205","default":false},{"id":958772934,"node_id":"MDU6TGFiZWw5NTg3NzI5MzQ=","url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/labels/Mantis","name":"Mantis","color":"795ec1","default":false},{"id":850704446,"node_id":"MDU6TGFiZWw4NTA3MDQ0NDY=","url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/labels/Tinebase","name":"Tinebase","color":"89eda9","default":false},{"id":958773120,"node_id":"MDU6TGFiZWw5NTg3NzMxMjA=","url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/labels/high%20priority","name":"high priority","color":"d30ad3","default":false}],"state":"closed","locked":false,"assignee":{"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},"assignees":[{"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}],"milestone":{"url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/milestones/127","html_url":"https://github.com/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/milestone/127","labels_url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/milestones/127/labels","id":3410632,"node_id":"MDk6TWlsZXN0b25lMzQxMDYzMg==","number":127,"title":"Collin (2013.10.1~beta1)","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":0,"closed_issues":146,"state":"closed","created_at":"2018-06-08T12:06:36Z","updated_at":"2018-06-09T08:38:25Z","due_on":null,"closed_at":"2018-06-08T12:06:36Z"},"comments":5,"created_at":"2018-06-09T07:22:07Z","updated_at":"2018-06-10T21:50:32Z","closed_at":"2018-06-09T07:22:14Z","author_association":"NONE","body":"**Reported by cassiano.dalpizzol on 21 May 2013 13:20**\n\n**Version:** git master\n\nWhen using Postgres as database the Preferences tab do not work.\r\n\r\nIt happens only on the master branch, kristina branch is ok.\r\n\r\non the log the folowing lines are logged\r\n\r\n7668e dc66d 90799127000 - 2013-05-21T13:05:05+00:00 INFO (6): Tinebase_Server_Json::_handle::187 is JSON request. method: Tinebase.searchPreferencesForApplication\r\n7668e dc66d 90799127000 - 2013-05-21T13:05:05+00:00 DEBUG (7): Tinebase_Frontend_Json::searchPreferencesForApplication::765 Got 5 preferences for app Tinebase\r\n7668e dc66d 90799127000 - 2013-05-21T13:05:05+00:00 WARN (4): Tinebase_Server_Json::_handleException::253 Zend_Db_Statement_Exception -&gt; SQLSTATE[42883]: Undefined function: 7 ERRO:  operador não existe: character varying = integer\r\nLINE 1: ... LIKE &#039;locale&#039;)) AND ((&quot;preferences&quot;.&quot;account_id&quot; = 0)) AND ...\r\n                                                             ^\r\nHINT:  Nenhum operador corresponde com o nome e o(s) tipo(s) de argumento(s) informados. Você precisa adicionar conversões de tipo explícitas.\r\n7668e dc66d 90799127000 - 2013-05-21T13:05:05+00:00 NOTICE (5): Tinebase_Server_Json::_logExceptionTrace::320 #0 .../library/Zend/Db/Statement.php(284): Zend_Db_Statement_Pdo-&gt;_execute(Array)\r\n#1 .../library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement-&gt;execute(Array)\r\n#2 .../library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract-&gt;query(Object(Zend_Db_Select), Array)\r\n#3 .../Tinebase/Backend/Sql/Abstract.php(679): Zend_Db_Adapter_Pdo_Abstract-&gt;query(Object(Zend_Db_Select))\r\n#4 .../Tinebase/Backend/Sql/Abstract.php(501): Tinebase_Backend_Sql_Abstract-&gt;_fetch(Object(Zend_Db_Select))\r\n#5 .../Tinebase/Preference/Abstract.php(170): Tinebase_Backend_Sql_Abstract-&gt;search(Object(Tinebase_Model_PreferenceFilter), NULL, false)\r\n#6 .../Tinebase/Preference/Abstract.php(700): Tinebase_Preference_Abstract-&gt;search(Object(Tinebase_Model_PreferenceFilter))\r\n#7 .../Tinebase/Preference/Abstract.php(496): Tinebase_Preference_Abstract-&gt;_getDefaultPreference(&#039;locale&#039;)\r\n#8 .../Tinebase/Frontend/Json.php(1023): Tinebase_Preference_Abstract-&gt;resolveOptions(Object(Tinebase_Model_Preference))\r\n#9 .../Tinebase/Frontend/Json.php(770): Tinebase_Frontend_Json-&gt;_multipleRecordsToJson(Object(Tinebase_Record_RecordSet), Object(Tinebase_Model_PreferenceFilter))\r\n#10 [internal function]: Tinebase_Frontend_Json-&gt;searchPreferencesForApplication(&#039;Tinebase&#039;, &#039;&#039;)\r\n#11 .../library/Zend/Server/Abstract.php(232): call_user_func_array(Array, Array)\r\n#12 .../Zend/Json/Server.php(558): Zend_Server_Abstract-&gt;_dispatch(Object(Zend_Server_Method_Definition), Array)\r\n#13 .../Zend/Json/Server.php(197): Zend_Json_Server-&gt;_handle()\r\n#14 .../Tinebase/Server/Json.php(231): Zend_Json_Server-&gt;handle(Object(Zend_Json_Server_Request))\r\n#15 .../Tinebase/Server/Json.php(101): Tinebase_Server_Json-&gt;_handle(Object(Zend_Json_Server_Request))\r\n#16 .../Tinebase/Core.php(230): Tinebase_Server_Json-&gt;handle()\r\n#17 .../index.php(17): Tinebase_Core::dispatchRequest()\r\n#18 {main}\n\n**Steps to reproduce:** Log in tine20 on a Postgres instalation.\r\n\r\ntry to open the preferences tab \n"},"comment":{"url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/issues/comments/396084723","html_url":"https://github.com/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/issues/4227#issuecomment-396084723","issue_url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/issues/4227","id":396084723,"node_id":"MDEyOklzc3VlQ29tbWVudDM5NjA4NDcyMw==","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},"created_at":"2018-06-10T21:50:32Z","updated_at":"2018-06-10T21:50:32Z","author_association":"NONE","body":"**Comment posted by pschuele on 24 May 2013 09:46**\n\nit looks like we still have a problem here:\r\n\r\n1) Tinebase_PreferenceTest::testSearchCalendarPreferencesForAnyone\r\n[exec] Zend_Db_Statement_Exception: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: character varying = integer\r\n[exec] LINE 1: ...preferences&quot; WHERE ((((&quot;preferences&quot;.&quot;account_id&quot; = 0)) AND ...\r\n[exec] ^\r\n[exec] HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.\r\n[exec] \r\n[exec] &lt;http://ci.tine20.org/job/tine20pgsql/ws/tine20/Tinebase/Backend/Sql/Abstract.php&gt;:679\r\n[exec] &lt;http://ci.tine20.org/job/tine20pgsql/ws/tine20/Tinebase/Backend/Sql/Abstract.php&gt;:501\r\n[exec] &lt;http://ci.tine20.org/job/tine20pgsql/ws/tine20/Tinebase/Preference/Abstract.php&gt;:170\r\n[exec] &lt;http://ci.tine20.org/job/tine20pgsql/ws/tine20/Tinebase/Frontend/Json.php&gt;:763\r\n[exec]"}}
{"actor":{"display_login":"Gloirin"}}