{"action":"created","issue":{"url":"https://api.github.com/repos/sih4sing5hong5/tai5-uan5_gian5-gi2_phing5-tai5/issues/146","repository_url":"https://api.github.com/repos/sih4sing5hong5/tai5-uan5_gian5-gi2_phing5-tai5","labels_url":"https://api.github.com/repos/sih4sing5hong5/tai5-uan5_gian5-gi2_phing5-tai5/issues/146/labels{/name}","comments_url":"https://api.github.com/repos/sih4sing5hong5/tai5-uan5_gian5-gi2_phing5-tai5/issues/146/comments","events_url":"https://api.github.com/repos/sih4sing5hong5/tai5-uan5_gian5-gi2_phing5-tai5/issues/146/events","html_url":"https://github.com/sih4sing5hong5/tai5-uan5_gian5-gi2_phing5-tai5/issues/146","id":169751019,"number":146,"title":"正規化表馬上匯入資料庫失敗","user":{"login":"thewayiam","id":4479861,"avatar_url":"https://avatars.githubusercontent.com/u/4479861?v=3","gravatar_id":"","url":"https://api.github.com/users/thewayiam","html_url":"https://github.com/thewayiam","followers_url":"https://api.github.com/users/thewayiam/followers","following_url":"https://api.github.com/users/thewayiam/following{/other_user}","gists_url":"https://api.github.com/users/thewayiam/gists{/gist_id}","starred_url":"https://api.github.com/users/thewayiam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thewayiam/subscriptions","organizations_url":"https://api.github.com/users/thewayiam/orgs","repos_url":"https://api.github.com/users/thewayiam/repos","events_url":"https://api.github.com/users/thewayiam/events{/privacy}","received_events_url":"https://api.github.com/users/thewayiam/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-08-06T15:19:26Z","updated_at":"2016-08-06T17:15:32Z","closed_at":null,"body":"1. 一個是資料庫問題如下 log\r\n2. 一個是正規化表裡面沒的流水號 49469 居然還是會去做＠@\r\n\r\n/工作/正規化表馬上匯入資料庫\r\n#142  #134 \r\n```\r\n[2016-08-06 22:55:53,600: ERROR/MainProcess] Task 臺灣言語平臺.tasks.半瞑自sheets掠轉資料庫[b47a30df-595d-4e60-b6db-844dbc8e50c8] raised unexpected: IntegrityError('null value in column \"愛藏起來\" violates not-null constraint\\nDETAIL:  Failing row contains (49469, f, null, null, 27813, null, 0, 0, null).\\n',)\r\nTraceback (most recent call last):\r\n  File \"/home/django/git/taigi-neologism/server-side/venv/lib/python3.4/site-packages/celery/app/trace.py\", line 240, in trace_task\r\n    R = retval = fun(*args, **kwargs)\r\n  File \"/home/django/git/taigi-neologism/server-side/venv/lib/python3.4/site-packages/celery/app/trace.py\", line 438, in __protected_call__\r\n    return self.run(*args, **kwargs)\r\n  File \"/home/django/git/taigi-neologism/server-side/venv/lib/python3.4/site-packages/臺灣言語平臺/tasks.py\", line 15, in 半瞑自sheets掠轉資料庫\r\n    正規化sheet表.全部整理到資料庫()\r\n  File \"/home/django/git/taigi-neologism/server-side/venv/lib/python3.4/site-packages/臺灣言語平臺/正規化團隊模型.py\", line 29, in 全部整理到資料庫\r\n    sheet資料.整理到資料庫()\r\n  File \"/home/django/git/taigi-neologism/server-side/venv/lib/python3.4/site-packages/臺灣言語平臺/正規化團隊模型.py\", line 93, in 整理到資料庫\r\n    正規化sheet表.正規化文本自sheet加轉資料庫(這筆資料)\r\n  File \"/home/django/git/taigi-neologism/server-side/venv/lib/python3.4/site-packages/臺灣言語平臺/正規化團隊模型.py\", line 148, in 正規化文本自sheet加轉資料庫\r\n    臺羅,\r\n  File \"/home/django/git/taigi-neologism/server-side/venv/lib/python3.4/site-packages/臺灣言語平臺/項目模型.py\", line 189, in 對正規化sheet校對母語文本\r\n    舊文本項目 = 平臺項目表.objects.get(pk=文本項目編號)\r\n  File \"/home/django/git/taigi-neologism/server-side/venv/lib/python3.4/site-packages/臺灣言語平臺/項目模型.py\", line 197, in _校對母語文本\r\n    '文本資料': 新文本,\r\n  File \"/home/django/git/taigi-neologism/server-side/venv/lib/python3.4/site-packages/django/db/models/manager.py\", line 122, in manager_method\r\n    return getattr(self.get_queryset(), name)(*args, **kwargs)\r\n  File \"/home/django/git/taigi-neologism/server-side/venv/lib/python3.4/site-packages/django/db/models/query.py\", line 401, in create\r\n    obj.save(force_insert=True, using=self.db)\r\n  File \"/home/django/git/taigi-neologism/server-side/venv/lib/python3.4/site-packages/django/db/models/base.py\", line 708, in save\r\n    force_update=force_update, update_fields=update_fields)\r\n  File \"/home/django/git/taigi-neologism/server-side/venv/lib/python3.4/site-packages/django/db/models/base.py\", line 736, in save_base\r\n    updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)\r\n  File \"/home/django/git/taigi-neologism/server-side/venv/lib/python3.4/site-packages/django/db/models/base.py\", line 820, in _save_table\r\n    result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)\r\n  File \"/home/django/git/taigi-neologism/server-side/venv/lib/python3.4/site-packages/django/db/models/base.py\", line 859, in _do_insert\r\n    using=using, raw=raw)\r\n  File \"/home/django/git/taigi-neologism/server-side/venv/lib/python3.4/site-packages/django/db/models/manager.py\", line 122, in manager_method\r\n    return getattr(self.get_queryset(), name)(*args, **kwargs)\r\n  File \"/home/django/git/taigi-neologism/server-side/venv/lib/python3.4/site-packages/django/db/models/query.py\", line 1039, in _insert\r\n    return query.get_compiler(using=using).execute_sql(return_id)\r\n  File \"/home/django/git/taigi-neologism/server-side/venv/lib/python3.4/site-packages/django/db/models/sql/compiler.py\", line 1060, in execute_sql\r\n    cursor.execute(sql, params)\r\n  File \"/home/django/git/taigi-neologism/server-side/venv/lib/python3.4/site-packages/django/db/backends/utils.py\", line 64, in execute\r\n    return self.cursor.execute(sql, params)\r\n  File \"/home/django/git/taigi-neologism/server-side/venv/lib/python3.4/site-packages/django/db/utils.py\", line 95, in __exit__\r\n    six.reraise(dj_exc_type, dj_exc_value, traceback)\r\n  File \"/home/django/git/taigi-neologism/server-side/venv/lib/python3.4/site-packages/django/utils/six.py\", line 685, in reraise\r\n    raise value.with_traceback(tb)\r\n  File \"/home/django/git/taigi-neologism/server-side/venv/lib/python3.4/site-packages/django/db/backends/utils.py\", line 64, in execute\r\n    return self.cursor.execute(sql, params)\r\ndjango.db.utils.IntegrityError: null value in column \"愛藏起來\" violates not-null constraint\r\nDETAIL:  Failing row contains (49469, f, null, null, 27813, null, 0, 0, null).\r\n```"},"comment":{"url":"https://api.github.com/repos/sih4sing5hong5/tai5-uan5_gian5-gi2_phing5-tai5/issues/comments/238034398","html_url":"https://github.com/sih4sing5hong5/tai5-uan5_gian5-gi2_phing5-tai5/issues/146#issuecomment-238034398","issue_url":"https://api.github.com/repos/sih4sing5hong5/tai5-uan5_gian5-gi2_phing5-tai5/issues/146","id":238034398,"user":{"login":"thewayiam","id":4479861,"avatar_url":"https://avatars.githubusercontent.com/u/4479861?v=3","gravatar_id":"","url":"https://api.github.com/users/thewayiam","html_url":"https://github.com/thewayiam","followers_url":"https://api.github.com/users/thewayiam/followers","following_url":"https://api.github.com/users/thewayiam/following{/other_user}","gists_url":"https://api.github.com/users/thewayiam/gists{/gist_id}","starred_url":"https://api.github.com/users/thewayiam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thewayiam/subscriptions","organizations_url":"https://api.github.com/users/thewayiam/orgs","repos_url":"https://api.github.com/users/thewayiam/repos","events_url":"https://api.github.com/users/thewayiam/events{/privacy}","received_events_url":"https://api.github.com/users/thewayiam/received_events","type":"User","site_admin":false},"created_at":"2016-08-06T17:15:32Z","updated_at":"2016-08-06T17:15:32Z","body":"應該是django migrate 後 celery 沒重啟"}}
{"actor":{"display_login":"thewayiam"}}