{"action":"created","issue":{"url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/issues/3626","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/3626/labels{/name}","comments_url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/issues/3626/comments","events_url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/issues/3626/events","html_url":"https://github.com/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/issues/3626","id":330852468,"node_id":"MDU6SXNzdWUzMzA4NTI0Njg=","number":3626,"title":"0007158:\nactivesync mit Windows Phone 7.5 causes Zend_Db_Statement_Exception","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":905757886,"node_id":"MDU6TGFiZWw5MDU3NTc4ODY=","url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/labels/ActiveSync","name":"ActiveSync","color":"006b75","default":false},{"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":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/173","html_url":"https://github.com/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/milestone/173","labels_url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/milestones/173/labels","id":3410685,"node_id":"MDk6TWlsZXN0b25lMzQxMDY4NQ==","number":173,"title":"Joey (2012.10.2)","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":70,"state":"closed","created_at":"2018-06-08T12:11:13Z","updated_at":"2018-06-09T05:05:36Z","due_on":null,"closed_at":"2018-06-08T12:11:13Z"},"comments":11,"created_at":"2018-06-09T04:38:12Z","updated_at":"2018-06-10T18:01:42Z","closed_at":"2018-06-09T04:38:18Z","author_association":"NONE","body":"**Reported by Olodin on 26 Sep 2012 20:41**\n\n**Version:** Joey (2012.10.1~beta2)\n\nJust got a new Nokia Lumia 710 with Windows Phone 7.5 and tried to setup activesync.\r\n\r\nBut I get this error in apache error log:\r\n\r\n[Wed Sep 26 22:34:06 2012] [error] [client 192.168.97.161] PHP Fatal error:  Uncaught exception &#039;Zend_Db_Statement_Exception&#039; with message &#039;SQLSTATE[HY000]: General error: 1366 Incorrect string value: &#039;\\\\x86\\\\x0BM\\\\x0B\\\\x86\\\\xE0...&#039; for column &#039;deviceid&#039; at row 1&#039; in /usr/local/www/tine20migrationstest/library/Zend/Db/Statement/Pdo.php:238\\nStack trace:\\n#0 /usr/local/www/tine20migrationstest/library/Zend/Db/Statement.php(284): Zend_Db_Statement_Pdo-&gt;_execute(Array)\\n#1 /usr/local/www/tine20migrationstest/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement-&gt;execute(Array)\\n#2 /usr/local/www/tine20migrationstest/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract-&gt;query(&#039;INSERT INTO `ti...&#039;, Array)\\n#3 /usr/local/www/tine20migrationstest/library/Zend/Db/Adapter/Abstract.php(546): Zend_Db_Adapter_Pdo_Abstract-&gt;query(&#039;INSERT INTO `ti...&#039;, Array)\\n#4 /usr/local/www/tine20migrationstest/library/Syncroton/lib/Syncroton/Backend/ABackend.php(56): Zend_Db_Adapter_Abstract-&gt;insert(&#039;tine20_acsync_d...&#039;, Array)\\n#5 /usr/local/www/tine20migrationstest/library/Syncroton/lib/Syncrot in /usr/local/www/tine20migrationstest/library/Zend/Db/Statement/Pdo.php on line 238\r\n\r\nThese are the last lines of trace log:\r\n2012-09-26T20:20:45+00:00 DEBUG (7): Syncroton_Server::_handlePost::89 REQUEST Array\r\n(   \r\n    [protocolVersion] =&gt; 141\r\n    [command] =&gt; FolderSync\r\n    [deviceId] =&gt; ~F^KM^K~F?^C~T/^OB??w\r\n  [deviceType] =&gt; WP\r\n  [saveInSent] =&gt;\r\n  [collectionId] =&gt;\r\n  [itemId] =&gt;\r\n  [attachmentName] =&gt;\r\n  [userAgent] =&gt; WP\r\n  [policyKey] =&gt;\r\n  [contentType] =&gt; application/vnd.ms-sync\r\n)\r\n\r\nThe account setup on the phone stops with an error and nothing can be synced.\r\n\r\nAny idea?\n\n**Additional information:** http://www.tine20.org/forum/viewtopic.php?f=12&amp;t=11586\n"},"comment":{"url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/issues/comments/396068761","html_url":"https://github.com/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/issues/3626#issuecomment-396068761","issue_url":"https://api.github.com/repos/tine20/Tine-2.0-Open-Source-Groupware-and-CRM/issues/3626","id":396068761,"node_id":"MDEyOklzc3VlQ29tbWVudDM5NjA2ODc2MQ==","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-10T18:01:42Z","updated_at":"2018-06-10T18:01:42Z","author_association":"NONE","body":"**Comment posted by Olodin on 4 Oct 2012 18:19**\n\nJust tested and get the same error as described in #0007186. The phone shows error id 8500201D.\r\n\r\nHere&#039;s the log:\r\n2c774 testuser - 2012-10-04T18:12:00+00:00 WARN (4): Zend_Cache_Core::save() : impossible to save cache (id=getApplicationByName_Tasks)\r\n2c774 testuser - 2012-10-04T18:12:00+00:00 DEBUG (7): Tinebase_Config_Abstract::_loadAllAppConfigsInCache::302 Loading all configs for app ActiveSync\r\n2c774 testuser - 2012-10-04T18:12:00+00:00 DEBUG (7): Tinebase_Config_Abstract::_loadAllAppConfigsInCache::309 Found 0 configs.\r\n2c774 testuser - 2012-10-04T18:12:00+00:00 DEBUG (7): Syncroton_Server::handle::56 REQUEST METHOD: POST\r\n2c774 testuser - 2012-10-04T18:12:00+00:00 DEBUG (7): Syncroton_Server::_handlePost::89 REQUEST Array\r\n(\r\n    [protocolVersion] =&gt; 141\r\n    [command] =&gt; Sync\r\n    [deviceId] =&gt; fcfe778c2f25a57d06d67f755066371e\r\n    [deviceType] =&gt; WP\r\n    [policyKey] =&gt; \r\n    [saveInSent] =&gt; \r\n    [collectionId] =&gt; \r\n    [itemId] =&gt; \r\n    [attachmentName] =&gt; \r\n    [userAgent] =&gt; WP\r\n    [contentType] =&gt; application/vnd.ms-sync\r\n)\r\n\r\n2c774 testuser - 2012-10-04T18:12:00+00:00 DEBUG (7): Syncroton_Command_Wbxml::__construct::146 sync timestamp: 2012-10-04 18:12:00\r\n2c774 testuser - 2012-10-04T18:12:00+00:00 WARN (4): Tinebase_Core::errorHandler::426 simplexml_import_dom() expects parameter 1 to be object, resource given in /usr/local/www/tine20migrationstest/library/Syncroton/lib/Syncroton/Command/Sync.php::116 (2)\r\n2c774 testuser - 2012-10-04T18:12:00+00:00 NOTICE (5): Tinebase_Core::errorHandler::437 Trying to get property of non-object in /usr/local/www/tine20migrationstest/library/Syncroton/lib/Syncroton/Command/Sync.php::130 (8)\r\n2c774 testuser - 2012-10-04T18:12:00+00:00 NOTICE (5): Tinebase_Core::errorHandler::437 Trying to get property of non-object in /usr/local/www/tine20migrationstest/library/Syncroton/lib/Syncroton/Command/Sync.php::130 (8)\r\n2c774 testuser - 2012-10-04T18:12:00+00:00 WARN (4): Tinebase_Core::errorHandler::426 Invalid argument supplied for foreach() in /usr/local/www/tine20migrationstest/library/Syncroton/lib/Syncroton/Command/Sync.php::130 (2)\r\n2c774 testuser - 2012-10-04T18:12:00+00:00 DEBUG (7): Syncroton_Server::_handlePost::163 xml response:\r\n&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;\r\n&lt;!DOCTYPE AirSync PUBLIC &quot;-//AIRSYNC//DTD AirSync//EN&quot; &quot;http://www.microsoft.com/&quot;&gt;\r\n&lt;Sync xmlns=&quot;uri:AirSync&quot; xmlns:Syncroton=&quot;uri:Syncroton&quot;&gt;\r\n  &lt;Collections/&gt;\r\n&lt;/Sync&gt;\r\n\r\nInitial sync works, though, the deviceid is hashed :)"}}
{"actor":{"display_login":"Gloirin"}}