{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/core/issues/13495","repository_url":"https://api.github.com/repos/owncloud/core","labels_url":"https://api.github.com/repos/owncloud/core/issues/13495/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/core/issues/13495/comments","events_url":"https://api.github.com/repos/owncloud/core/issues/13495/events","html_url":"https://github.com/owncloud/core/issues/13495","id":54835629,"number":13495,"title":"Overview page of pending+rejected shares","user":{"login":"schiessle","id":1589737,"avatar_url":"https://avatars.githubusercontent.com/u/1589737?v=3","gravatar_id":"","url":"https://api.github.com/users/schiessle","html_url":"https://github.com/schiessle","followers_url":"https://api.github.com/users/schiessle/followers","following_url":"https://api.github.com/users/schiessle/following{/other_user}","gists_url":"https://api.github.com/users/schiessle/gists{/gist_id}","starred_url":"https://api.github.com/users/schiessle/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/schiessle/subscriptions","organizations_url":"https://api.github.com/users/schiessle/orgs","repos_url":"https://api.github.com/users/schiessle/repos","events_url":"https://api.github.com/users/schiessle/events{/privacy}","received_events_url":"https://api.github.com/users/schiessle/received_events","type":"User","site_admin":false},"labels":[{"id":12406436,"url":"https://api.github.com/repos/owncloud/core/labels/enhancement","name":"enhancement","color":"02e10c","default":true},{"id":18122325,"url":"https://api.github.com/repos/owncloud/core/labels/feature:sharing","name":"feature:sharing","color":"d4c5f9","default":false},{"id":120033373,"url":"https://api.github.com/repos/owncloud/core/labels/sev2-high","name":"sev2-high","color":"fc2929","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/owncloud/core/milestones/11","html_url":"https://github.com/owncloud/core/milestone/11","labels_url":"https://api.github.com/repos/owncloud/core/milestones/11/labels","id":697149,"number":11,"title":"backlog","description":"","creator":{"login":"MTRichards","id":1818977,"avatar_url":"https://avatars.githubusercontent.com/u/1818977?v=3","gravatar_id":"","url":"https://api.github.com/users/MTRichards","html_url":"https://github.com/MTRichards","followers_url":"https://api.github.com/users/MTRichards/followers","following_url":"https://api.github.com/users/MTRichards/following{/other_user}","gists_url":"https://api.github.com/users/MTRichards/gists{/gist_id}","starred_url":"https://api.github.com/users/MTRichards/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MTRichards/subscriptions","organizations_url":"https://api.github.com/users/MTRichards/orgs","repos_url":"https://api.github.com/users/MTRichards/repos","events_url":"https://api.github.com/users/MTRichards/events{/privacy}","received_events_url":"https://api.github.com/users/MTRichards/received_events","type":"User","site_admin":false},"open_issues":947,"closed_issues":476,"state":"open","created_at":"2014-06-20T19:52:03Z","updated_at":"2016-12-23T16:24:21Z","due_on":null,"closed_at":null},"comments":32,"created_at":"2015-01-20T02:14:02Z","updated_at":"2016-12-23T18:26:16Z","closed_at":null,"body":"If a user unshares a file from themself there is no way to bring the share back. We should have a sidebar entry \"rejected shares\" (or similar) which lists all shares a user unshared from themself until the owner unshares the file. This enabled the user to bring back a share if they unshared the file by accident. Currently there is no way to bring back a share after the user unshared it from themself.\n"},"comment":{"url":"https://api.github.com/repos/owncloud/core/issues/comments/269028344","html_url":"https://github.com/owncloud/core/issues/13495#issuecomment-269028344","issue_url":"https://api.github.com/repos/owncloud/core/issues/13495","id":269028344,"user":{"login":"kernelpanic01","id":24663335,"avatar_url":"https://avatars.githubusercontent.com/u/24663335?v=3","gravatar_id":"","url":"https://api.github.com/users/kernelpanic01","html_url":"https://github.com/kernelpanic01","followers_url":"https://api.github.com/users/kernelpanic01/followers","following_url":"https://api.github.com/users/kernelpanic01/following{/other_user}","gists_url":"https://api.github.com/users/kernelpanic01/gists{/gist_id}","starred_url":"https://api.github.com/users/kernelpanic01/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kernelpanic01/subscriptions","organizations_url":"https://api.github.com/users/kernelpanic01/orgs","repos_url":"https://api.github.com/users/kernelpanic01/repos","events_url":"https://api.github.com/users/kernelpanic01/events{/privacy}","received_events_url":"https://api.github.com/users/kernelpanic01/received_events","type":"User","site_admin":false},"created_at":"2016-12-23T18:26:15Z","updated_at":"2016-12-23T18:26:15Z","body":"@mapeze \r\nmysql> show databases;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| information_schema |\r\n| owncloud           |\r\n+--------------------+\r\n2 rows in set (0.00 sec)\r\n\r\nmysql> use owncloud\r\nReading table information for completion of table and column names\r\nYou can turn off this feature to get a quicker startup with -A\r\n\r\nDatabase changed\r\nmysql> CREATE TRIGGER `_UndoUserShareDeleteOrRename` BEFORE INSERT ON `oc_share`\r\n    ->     FOR EACH ROW BEGIN\r\n    ->     IF (NEW.share_type=2) THEN\r\n    ->     signal sqlstate '45000';\r\nERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4\r\nmysql>     END IF;\r\nERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END IF' at line 1\r\nmysql>     END;\r\nERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END' at line 1\r\nmysql> CREATE TRIGGER `_UndoUserShareDeleteOrRename` BEFORE INSERT ON 'oc_share' FOR EACH ROW BEGIN IF (NEW.share_type=2) THEN signal sqlstate '45000';\r\nERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''oc_share' FOR EACH ROW BEGIN IF (NEW.share_type=2) THEN signal sqlstate '45000'' at line 1\r\nmysql>\r\nmysql>\r\nmysql> CREATE TRIGGER `_UndoUserShareDeleteOrRename` BEFORE INSERT ON `oc_share` FOR EACH ROW BEGIN IF (NEW.share_type=2) THEN signal sqlstate '45000';\r\nERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1\r\n"}}
{"actor":{"display_login":"kernelpanic01"}}