{"action":"created","issue":{"url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/582","repository_url":"https://api.github.com/repos/salesagility/SuiteCRM","labels_url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/582/labels{/name}","comments_url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/582/comments","events_url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/582/events","html_url":"https://github.com/salesagility/SuiteCRM/issues/582","id":112326399,"number":582,"title":"User photo and activitystream photo","user":{"login":"jobvector","id":15199551,"avatar_url":"https://avatars.githubusercontent.com/u/15199551?v=3","gravatar_id":"","url":"https://api.github.com/users/jobvector","html_url":"https://github.com/jobvector","followers_url":"https://api.github.com/users/jobvector/followers","following_url":"https://api.github.com/users/jobvector/following{/other_user}","gists_url":"https://api.github.com/users/jobvector/gists{/gist_id}","starred_url":"https://api.github.com/users/jobvector/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jobvector/subscriptions","organizations_url":"https://api.github.com/users/jobvector/orgs","repos_url":"https://api.github.com/users/jobvector/repos","events_url":"https://api.github.com/users/jobvector/events{/privacy}","received_events_url":"https://api.github.com/users/jobvector/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/salesagility/SuiteCRM/labels/bug","name":"bug","color":"e11d21"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2015-10-20T09:40:30Z","updated_at":"2016-08-19T19:09:32Z","closed_at":null,"body":"After adding the **\"Photo\" field** by use of the SuiteCRM Studio to the User->DetailView and User->EditView on a clean SuiteCRM (7.3.1) installation and uploading a user photo resulted in the following:\r\n\r\nUser->EditView: Uploading the image\r\n![bildschirmfoto 2015-10-20 um 10 58 16](https://cloud.githubusercontent.com/assets/15199551/10602996/1bcd8896-771c-11e5-822a-4bce3a6a1621.png)\r\n\r\nUser->DetailView\r\n![bildschirmfoto 2015-10-20 um 10 58 39](https://cloud.githubusercontent.com/assets/15199551/10603052/50a3cba2-771c-11e5-97c3-9045d815f35f.png)\r\n\r\nUser->EditView: Clicking on the image link\r\n![bildschirmfoto 2015-10-20 um 10 58 52](https://cloud.githubusercontent.com/assets/15199551/10603102/7b2c35e4-771c-11e5-995a-220aa78560d7.png)\r\n\r\n-> results in\r\n![bildschirmfoto 2015-10-20 um 11 20 01](https://cloud.githubusercontent.com/assets/15199551/10603119/8f217dde-771c-11e5-9c37-f280678e31b8.png)\r\n\r\nChecking all the permissions (Linux) and changing the /upload/ folder to 775 did not fox the problem.\r\nAfterwards, the sugarcrm.log printed the following error:\r\n*Query Failed: SELECT photo FROM users LEFT JOIN users_cstm cstm ON cstm.id_c = users.id WHERE users.id= '1': MySQL error 1146: Table 'suitecrm_clean.users_cstm' doesn't exist*\r\n\r\nCreating the users_cstm table in the suitecrm database and doing a quick repair and rebuild fixed that issue.\r\n\r\nNow the test picture ist shown in the DetailView\r\n![bildschirmfoto 2015-10-20 um 11 25 00](https://cloud.githubusercontent.com/assets/15199551/10603247/454ee768-771d-11e5-8e2d-23e98af8a45d.png)\r\n\r\nIssue: Trying to change the image does not update the photo field.\r\n-> Only by manually removing the image in the upload folder and \"removing\" the image in the GUI lets a user upload a different image.\r\n\r\nAdditionally the **activitystream** doesn't load the appropriate user image, just displaying a placeholder.\r\n![bildschirmfoto 2015-10-20 um 11 29 31](https://cloud.githubusercontent.com/assets/15199551/10603352/de1301fa-771d-11e5-9c67-114eab6c5150.png)\r\n\r\nLooking into the native SuiteCRM code in the *SugarFeed module -> SugarFeed.php -> fetchReplies()* it appears that there are still issues, i.e. the *user->picture* field does not exist in SuiteCRM.\r\n![bildschirmfoto 2015-10-20 um 11 37 21](https://cloud.githubusercontent.com/assets/15199551/10603590/21424246-771f-11e5-9dbe-51c67b5d002e.png)\r\n\r\nSuiteCRM Version: 7.3.1\r\n"},"comment":{"url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/comments/241108263","html_url":"https://github.com/salesagility/SuiteCRM/issues/582#issuecomment-241108263","issue_url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/582","id":241108263,"user":{"login":"jshwhitlow","id":17415608,"avatar_url":"https://avatars.githubusercontent.com/u/17415608?v=3","gravatar_id":"","url":"https://api.github.com/users/jshwhitlow","html_url":"https://github.com/jshwhitlow","followers_url":"https://api.github.com/users/jshwhitlow/followers","following_url":"https://api.github.com/users/jshwhitlow/following{/other_user}","gists_url":"https://api.github.com/users/jshwhitlow/gists{/gist_id}","starred_url":"https://api.github.com/users/jshwhitlow/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jshwhitlow/subscriptions","organizations_url":"https://api.github.com/users/jshwhitlow/orgs","repos_url":"https://api.github.com/users/jshwhitlow/repos","events_url":"https://api.github.com/users/jshwhitlow/events{/privacy}","received_events_url":"https://api.github.com/users/jshwhitlow/received_events","type":"User","site_admin":false},"created_at":"2016-08-19T19:09:32Z","updated_at":"2016-08-19T19:09:32Z","body":"@jobvector were you able to get a fix for this problem, or have they patched this bug? I ran into this issue recently and was looking for a fix to the problem."}}
{"actor":{"display_login":"jshwhitlow"}}