{"action":"created","issue":{"url":"https://api.github.com/repos/RunestoneInteractive/RunestoneServer/issues/754","repository_url":"https://api.github.com/repos/RunestoneInteractive/RunestoneServer","labels_url":"https://api.github.com/repos/RunestoneInteractive/RunestoneServer/issues/754/labels{/name}","comments_url":"https://api.github.com/repos/RunestoneInteractive/RunestoneServer/issues/754/comments","events_url":"https://api.github.com/repos/RunestoneInteractive/RunestoneServer/issues/754/events","html_url":"https://github.com/RunestoneInteractive/RunestoneServer/issues/754","id":166717784,"number":754,"title":"new web2py ticket","user":{"login":"bnmnetp","id":51115,"avatar_url":"https://avatars.githubusercontent.com/u/51115?v=3","gravatar_id":"","url":"https://api.github.com/users/bnmnetp","html_url":"https://github.com/bnmnetp","followers_url":"https://api.github.com/users/bnmnetp/followers","following_url":"https://api.github.com/users/bnmnetp/following{/other_user}","gists_url":"https://api.github.com/users/bnmnetp/gists{/gist_id}","starred_url":"https://api.github.com/users/bnmnetp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bnmnetp/subscriptions","organizations_url":"https://api.github.com/users/bnmnetp/orgs","repos_url":"https://api.github.com/users/bnmnetp/repos","events_url":"https://api.github.com/users/bnmnetp/events{/privacy}","received_events_url":"https://api.github.com/users/bnmnetp/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-07-21T01:24:50Z","updated_at":"2016-07-22T18:45:13Z","closed_at":"2016-07-22T18:45:12Z","body":"**Raised by:** courselib@interactivepython.org<br>\n``` Traceback (most recent call last):\n  File \"/home/bnmnetp/webapps/uwsgi_runestone/web2py/gluon/restricted.py\", line 212, in restricted\n    exec ccode in environment\n  File \"/home/bnmnetp/webapps/uwsgi_runestone/web2py/applications/runestone/controllers/designer.py\", line 184, in \n  File \"/home/bnmnetp/webapps/uwsgi_runestone/web2py/gluon/globals.py\", line 194, in \n    self._caller = lambda f: f()\n  File \"/home/bnmnetp/webapps/uwsgi_runestone/web2py/gluon/tools.py\", line 3022, in f\n    return action(*a, **b)\n  File \"/home/bnmnetp/webapps/uwsgi_runestone/web2py/applications/runestone/controllers/designer.py\", line 163, in delete_course\n    db(db.courses.id == courseid).delete()\n  File \"/home/bnmnetp/webapps/uwsgi_runestone/web2py/gluon/dal.py\", line 9968, in delete\n    ret = db._adapter.delete(tablename,self.query)\n  File \"/home/bnmnetp/webapps/uwsgi_runestone/web2py/gluon/dal.py\", line 1475, in delete\n    self.execute(sql)\n  File \"/home/bnmnetp/webapps/uwsgi_runestone/web2py/gluon/dal.py\", line 1784, in execute\n    return self.log_execute(*a, **b)\n  File \"/home/bnmnetp/webapps/uwsgi_runestone/web2py/gluon/dal.py\", line 1778, in log_execute\n    ret = self.cursor.execute(command, *a[1:], **b)\nIntegrityError: update or delete on table \"courses\" violates foreign key constraint \"course_fk\" on table \"user_courses\"\nDETAIL:  Key (id)=(1772) is still referenced from table \"user_courses\".\n\n ```<br><br>"},"comment":{"url":"https://api.github.com/repos/RunestoneInteractive/RunestoneServer/issues/comments/234624329","html_url":"https://github.com/RunestoneInteractive/RunestoneServer/issues/754#issuecomment-234624329","issue_url":"https://api.github.com/repos/RunestoneInteractive/RunestoneServer/issues/754","id":234624329,"user":{"login":"bnmnetp","id":51115,"avatar_url":"https://avatars.githubusercontent.com/u/51115?v=3","gravatar_id":"","url":"https://api.github.com/users/bnmnetp","html_url":"https://github.com/bnmnetp","followers_url":"https://api.github.com/users/bnmnetp/followers","following_url":"https://api.github.com/users/bnmnetp/following{/other_user}","gists_url":"https://api.github.com/users/bnmnetp/gists{/gist_id}","starred_url":"https://api.github.com/users/bnmnetp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bnmnetp/subscriptions","organizations_url":"https://api.github.com/users/bnmnetp/orgs","repos_url":"https://api.github.com/users/bnmnetp/repos","events_url":"https://api.github.com/users/bnmnetp/events{/privacy}","received_events_url":"https://api.github.com/users/bnmnetp/received_events","type":"User","site_admin":false},"created_at":"2016-07-22T18:45:12Z","updated_at":"2016-07-22T18:45:12Z","body":"Fixed:  Added on delete cascade to the constraint, and modified the model"}}
{"actor":{"display_login":"bnmnetp"}}