inflearn logo
강의

강의

N
챌린지

챌린지

멘토링

멘토링

N
클립

클립

로드맵

로드맵

지식공유

파이썬으로 장고(Django) 공략하기: 입문

데이터 생성

no such table이라고 뜨는 오류좀 봐주세요

10969

Juntaek Lee

작성한 질문수 1

0

1분35초경의 강의를 따라하다가 다음과 같은 에러가 발생합니다.

 

>>> post= Post.objects.create(title="this is title", content="this is content")

Traceback (most recent call last):

  File "/home/beanzsoft/Projects/HelloDjango/venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute

    return self.cursor.execute(sql, params)

  File "/home/beanzsoft/Projects/HelloDjango/venv/lib/python3.6/site-packages/django/db/backends/sqlite3/base.py", line 383, in execute

    return Database.Cursor.execute(self, query, params)

sqlite3.OperationalError: no such table: second_post

 

The above exception was the direct cause of the following exception:

 

Traceback (most recent call last):

  File "<console>", line 1, in <module>

  File "/home/beanzsoft/Projects/HelloDjango/venv/lib/python3.6/site-packages/django/db/models/manager.py", line 82, in manager_method

    return getattr(self.get_queryset(), name)(*args, **kwargs)

  File "/home/beanzsoft/Projects/HelloDjango/venv/lib/python3.6/site-packages/django/db/models/query.py", line 422, in create

    obj.save(force_insert=True, using=self.db)

  File "/home/beanzsoft/Projects/HelloDjango/venv/lib/python3.6/site-packages/django/db/models/base.py", line 741, in save

    force_update=force_update, update_fields=update_fields)

  File "/home/beanzsoft/Projects/HelloDjango/venv/lib/python3.6/site-packages/django/db/models/base.py", line 779, in save_base

    force_update, using, update_fields,

  File "/home/beanzsoft/Projects/HelloDjango/venv/lib/python3.6/site-packages/django/db/models/base.py", line 870, in _save_table

    result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)

  File "/home/beanzsoft/Projects/HelloDjango/venv/lib/python3.6/site-packages/django/db/models/base.py", line 908, in _do_insert

    using=using, raw=raw)

  File "/home/beanzsoft/Projects/HelloDjango/venv/lib/python3.6/site-packages/django/db/models/manager.py", line 82, in manager_method

    return getattr(self.get_queryset(), name)(*args, **kwargs)

  File "/home/beanzsoft/Projects/HelloDjango/venv/lib/python3.6/site-packages/django/db/models/query.py", line 1186, in _insert

    return query.get_compiler(using=using).execute_sql(return_id)

  File "/home/beanzsoft/Projects/HelloDjango/venv/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1335, in execute_sql

    cursor.execute(sql, params)

  File "/home/beanzsoft/Projects/HelloDjango/venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 99, in execute

    return super().execute(sql, params)

  File "/home/beanzsoft/Projects/HelloDjango/venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 67, in execute

    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)

  File "/home/beanzsoft/Projects/HelloDjango/venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers

    return executor(sql, params, many, context)

  File "/home/beanzsoft/Projects/HelloDjango/venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute

    return self.cursor.execute(sql, params)

  File "/home/beanzsoft/Projects/HelloDjango/venv/lib/python3.6/site-packages/django/db/utils.py", line 89, in __exit__

    raise dj_exc_value.with_traceback(traceback) from exc_value

  File "/home/beanzsoft/Projects/HelloDjango/venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute

    return self.cursor.execute(sql, params)

  File "/home/beanzsoft/Projects/HelloDjango/venv/lib/python3.6/site-packages/django/db/backends/sqlite3/base.py", line 383, in execute

    return Database.Cursor.execute(self, query, params)

django.db.utils.OperationalError: no such table: second_post

 

django python

답변 1

2

박순영

django.db.utils.OperationalError: no such table: second_post

 

위 오류로 보아서는 second_post라는 테이블이 sqlite3 디비 내에 존재하지 않는거 같습니다.

python manage.py makemigrations
python manage.py migrate

위의 마이그레이션을 제대로 진행하셨는지 여부와

현재 그 코드가 실행되는 웹 앱이 second라는 이름인지 확인해주세요~

빨간 줄이 뜨네요

0

137

1

import 문장에 빨간줄이 뜹니다.

0

156

1

putty 관련 질문

0

192

1

uWSGI 세팅하기_ 최종 502 bad gateway error

0

809

1

putty 접속관련

0

306

1

[리뷰 삭제하기] 삭제시 path 에러문구나옴.

0

386

1

데이터 새성시 forms.py, models.py 관련문의

0

308

1

'폼으로 데이터 전송하기' 강의 소리가 갑자기 작아짐

0

318

1

[스태틱]index.html 의 이미지를 변경하려면 ?

0

508

1

WARNINGS: ?: (staticfiles.W004) The directory 'C:\projects\first-django\static' in the STATICFILES_DIRS setting does not exist.

0

427

1

사진 넣고 엑박...ㅜㅜ

0

335

0

간단한 웹 페이지 띄우기 강의 10분 후반쯤

0

419

0

리뷰 등록 구현하기 4:26 url 오류

0

347

1

create.html

0

361

1

502 badgateway 오류가 떠요

0

284

0

putty에서 막혔네요 ㅠㅠ

0

355

2

django) 한 폼에 여러 모델 데이터 입력하는 경우

0

328

0

파이참 안에서 가상환경 접속이 안 됩니다.

0

691

1

settings.py

0

306

1

만약 웹앱을 업데이트할경우는 어떻게 해야하나요?

0

375

1

CSS 가운데 정렬 적용 안됨

0

4834

3

NameError: name 'os' is not defined

2

1109

1

1분 26초에 post=Post.objects.create(title="this is title", content="this is content")부분이 실행이 안됩니다.

0

268

1

virtualenv가 설치가 안됩니다..

0

440

1