Comments (2)
@KimTom89
.env 없을때는 정상 작동하지 않네요.
확인 바랍니다.
from g6.
.env, DB 없을 경우 다음과 같은 오류가 나오네요.
INFO: Will watch for changes in these directories: ['/home/ubuntu/gnu6']
INFO: Uvicorn running on http://127.0.0.1:8000 (Press CTRL+C to quit)
INFO: Started reloader process [167884] using WatchFiles
경고: .env 파일이 없습니다. 설치를 진행해 주세요.
Process SpawnProcess-1:
Traceback (most recent call last):
File "/home/ubuntu/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1969, in _exec_single_context
self.dialect.do_execute(
File "/home/ubuntu/.local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: no such table: g6_config
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap
self.run()
File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run
self._target(*self._args, **self._kwargs)
File "/home/ubuntu/.local/lib/python3.10/site-packages/uvicorn/_subprocess.py", line 76, in subprocess_started
target(sockets=sockets)
File "/home/ubuntu/.local/lib/python3.10/site-packages/uvicorn/server.py", line 61, in run
return asyncio.run(self.serve(sockets=sockets))
File "/usr/lib/python3.10/asyncio/runners.py", line 44, in run
return loop.run_until_complete(main)
File "uvloop/loop.pyx", line 1517, in uvloop.loop.Loop.run_until_complete
File "/home/ubuntu/.local/lib/python3.10/site-packages/uvicorn/server.py", line 68, in serve
config.load()
File "/home/ubuntu/.local/lib/python3.10/site-packages/uvicorn/config.py", line 467, in load
self.loaded_app = import_from_string(self.app)
File "/home/ubuntu/.local/lib/python3.10/site-packages/uvicorn/importer.py", line 21, in import_from_string
module = importlib.import_module(module_str)
File "/usr/lib/python3.10/importlib/__init__.py", line 126, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 1050, in _gcd_import
File "<frozen importlib._bootstrap>", line 1027, in _find_and_load
File "<frozen importlib._bootstrap>", line 1006, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 688, in _load_unlocked
File "<frozen importlib._bootstrap_external>", line 883, in exec_module
File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
File "/home/ubuntu/gnu6/main.py", line 12, in <module>
from lib.common import *
File "/home/ubuntu/gnu6/lib/common.py", line 76, in <module>
TEMPLATES_DIR = get_theme_from_db()
File "/home/ubuntu/gnu6/lib/common.py", line 64, in get_theme_from_db
config = db.query(Config).first()
File "/home/ubuntu/.local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2748, in first
return self.limit(1)._iter().first() # type: ignore
File "/home/ubuntu/.local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2847, in _iter
result: Union[ScalarResult[_T], Result[_T]] = self.session.execute(
File "/home/ubuntu/.local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2308, in execute
return self._execute_internal(
File "/home/ubuntu/.local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2190, in _execute_internal
result: Result[Any] = compile_state_cls.orm_execute_statement(
File "/home/ubuntu/.local/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 293, in orm_execute_statement
result = conn.execute(
File "/home/ubuntu/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1416, in execute
return meth(
File "/home/ubuntu/.local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 516, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/ubuntu/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1639, in _execute_clauseelement
ret = self._execute_context(
File "/home/ubuntu/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1848, in _execute_context
return self._exec_single_context(
File "/home/ubuntu/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1988, in _exec_single_context
self._handle_dbapi_exception(
File "/home/ubuntu/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2343, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/home/ubuntu/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1969, in _exec_single_context
self.dialect.do_execute(
File "/home/ubuntu/.local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: g6_config
[SQL: SELECT g6_config.cf_id AS g6_config_cf_id, g6_config.cf_title AS g6_config_cf_title, g6_config.cf_theme AS g6_config_cf_theme, g6_config.cf_admin AS g6_config_cf_admin, g6_config.cf_admin_email AS g6_config_cf_admin_email, g6_config.cf_admin_email_name AS g6_config_cf_admin_email_name, g6_config.cf_add_script AS g6_config_cf_add_script, g6_config.cf_use_point AS g6_config_cf_use_point, g6_config.cf_point_term AS g6_config_cf_point_term, g6_config.cf_use_copy_log AS g6_config_cf_use_copy_log, g6_config.cf_use_email_certify AS g6_config_cf_use_email_certify, g6_config.cf_login_point AS g6_config_cf_login_point, g6_config.cf_cut_name AS g6_config_cf_cut_name, g6_config.cf_nick_modify AS g6_config_cf_nick_modify, g6_config.cf_new_skin AS g6_config_cf_new_skin, g6_config.cf_new_rows AS g6_config_cf_new_rows, g6_config.cf_search_skin AS g6_config_cf_search_skin, g6_config.cf_connect_skin AS g6_config_cf_connect_skin, g6_config.cf_faq_skin AS g6_config_cf_faq_skin, g6_config.cf_read_point AS g6_config_cf_read_point, g6_config.cf_write_point AS g6_config_cf_write_point, g6_config.cf_comment_point AS g6_config_cf_comment_point, g6_config.cf_download_point AS g6_config_cf_download_point, g6_config.cf_write_pages AS g6_config_cf_write_pages, g6_config.cf_mobile_pages AS g6_config_cf_mobile_pages, g6_config.cf_link_target AS g6_config_cf_link_target, g6_config.cf_bbs_rewrite AS g6_config_cf_bbs_rewrite, g6_config.cf_delay_sec AS g6_config_cf_delay_sec, g6_config.cf_filter AS g6_config_cf_filter, g6_config.cf_possible_ip AS g6_config_cf_possible_ip, g6_config.cf_intercept_ip AS g6_config_cf_intercept_ip, g6_config.cf_analytics AS g6_config_cf_analytics, g6_config.cf_add_meta AS g6_config_cf_add_meta, g6_config.cf_syndi_token AS g6_config_cf_syndi_token, g6_config.cf_syndi_except AS g6_config_cf_syndi_except, g6_config.cf_member_skin AS g6_config_cf_member_skin, g6_config.cf_use_homepage AS g6_config_cf_use_homepage, g6_config.cf_req_homepage AS g6_config_cf_req_homepage, g6_config.cf_use_tel AS g6_config_cf_use_tel, g6_config.cf_req_tel AS g6_config_cf_req_tel, g6_config.cf_use_hp AS g6_config_cf_use_hp, g6_config.cf_req_hp AS g6_config_cf_req_hp, g6_config.cf_use_addr AS g6_config_cf_use_addr, g6_config.cf_req_addr AS g6_config_cf_req_addr, g6_config.cf_use_signature AS g6_config_cf_use_signature, g6_config.cf_req_signature AS g6_config_cf_req_signature, g6_config.cf_use_profile AS g6_config_cf_use_profile, g6_config.cf_req_profile AS g6_config_cf_req_profile, g6_config.cf_register_level AS g6_config_cf_register_level, g6_config.cf_register_point AS g6_config_cf_register_point, g6_config.cf_icon_level AS g6_config_cf_icon_level, g6_config.cf_use_recommend AS g6_config_cf_use_recommend, g6_config.cf_recommend_point AS g6_config_cf_recommend_point, g6_config.cf_leave_day AS g6_config_cf_leave_day, g6_config.cf_search_part AS g6_config_cf_search_part, g6_config.cf_email_use AS g6_config_cf_email_use, g6_config.cf_email_wr_super_admin AS g6_config_cf_email_wr_super_admin, g6_config.cf_email_wr_group_admin AS g6_config_cf_email_wr_group_admin, g6_config.cf_email_wr_board_admin AS g6_config_cf_email_wr_board_admin, g6_config.cf_email_wr_write AS g6_config_cf_email_wr_write, g6_config.cf_email_wr_comment_all AS g6_config_cf_email_wr_comment_all, g6_config.cf_email_mb_super_admin AS g6_config_cf_email_mb_super_admin, g6_config.cf_email_mb_member AS g6_config_cf_email_mb_member, g6_config.cf_email_po_super_admin AS g6_config_cf_email_po_super_admin, g6_config.cf_prohibit_id AS g6_config_cf_prohibit_id, g6_config.cf_prohibit_email AS g6_config_cf_prohibit_email, g6_config.cf_new_del AS g6_config_cf_new_del, g6_config.cf_memo_del AS g6_config_cf_memo_del, g6_config.cf_visit_del AS g6_config_cf_visit_del, g6_config.cf_popular_del AS g6_config_cf_popular_del, g6_config.cf_optimize_date AS g6_config_cf_optimize_date, g6_config.cf_use_member_icon AS g6_config_cf_use_member_icon, g6_config.cf_member_icon_size AS g6_config_cf_member_icon_size, g6_config.cf_member_icon_width AS g6_config_cf_member_icon_width, g6_config.cf_member_icon_height AS g6_config_cf_member_icon_height, g6_config.cf_member_img_size AS g6_config_cf_member_img_size, g6_config.cf_member_img_width AS g6_config_cf_member_img_width, g6_config.cf_member_img_height AS g6_config_cf_member_img_height, g6_config.cf_login_minutes AS g6_config_cf_login_minutes, g6_config.cf_image_extension AS g6_config_cf_image_extension, g6_config.cf_flash_extension AS g6_config_cf_flash_extension, g6_config.cf_movie_extension AS g6_config_cf_movie_extension, g6_config.cf_formmail_is_member AS g6_config_cf_formmail_is_member, g6_config.cf_page_rows AS g6_config_cf_page_rows, g6_config.cf_mobile_page_rows AS g6_config_cf_mobile_page_rows, g6_config.cf_visit AS g6_config_cf_visit, g6_config.cf_max_po_id AS g6_config_cf_max_po_id, g6_config.cf_stipulation AS g6_config_cf_stipulation, g6_config.cf_privacy AS g6_config_cf_privacy, g6_config.cf_open_modify AS g6_config_cf_open_modify, g6_config.cf_memo_send_point AS g6_config_cf_memo_send_point, g6_config.cf_mobile_new_skin AS g6_config_cf_mobile_new_skin, g6_config.cf_mobile_search_skin AS g6_config_cf_mobile_search_skin, g6_config.cf_mobile_connect_skin AS g6_config_cf_mobile_connect_skin, g6_config.cf_mobile_faq_skin AS g6_config_cf_mobile_faq_skin, g6_config.cf_mobile_member_skin AS g6_config_cf_mobile_member_skin, g6_config.cf_captcha_mp3 AS g6_config_cf_captcha_mp3, g6_config.cf_editor AS g6_config_cf_editor, g6_config.cf_cert_use AS g6_config_cf_cert_use, g6_config.cf_cert_find AS g6_config_cf_cert_find, g6_config.cf_cert_ipin AS g6_config_cf_cert_ipin, g6_config.cf_cert_hp AS g6_config_cf_cert_hp, g6_config.cf_cert_simple AS g6_config_cf_cert_simple, g6_config.cf_cert_kg_cd AS g6_config_cf_cert_kg_cd, g6_config.cf_cert_kg_mid AS g6_config_cf_cert_kg_mid, g6_config.cf_cert_kcb_cd AS g6_config_cf_cert_kcb_cd, g6_config.cf_cert_kcp_cd AS g6_config_cf_cert_kcp_cd, g6_config.cf_lg_mid AS g6_config_cf_lg_mid, g6_config.cf_lg_mert_key AS g6_config_cf_lg_mert_key, g6_config.cf_cert_limit AS g6_config_cf_cert_limit, g6_config.cf_cert_req AS g6_config_cf_cert_req, g6_config.cf_sms_use AS g6_config_cf_sms_use, g6_config.cf_sms_type AS g6_config_cf_sms_type, g6_config.cf_icode_id AS g6_config_cf_icode_id, g6_config.cf_icode_pw AS g6_config_cf_icode_pw, g6_config.cf_icode_server_ip AS g6_config_cf_icode_server_ip, g6_config.cf_icode_server_port AS g6_config_cf_icode_server_port, g6_config.cf_icode_token_key AS g6_config_cf_icode_token_key, g6_config.cf_googl_shorturl_apikey AS g6_config_cf_googl_shorturl_apikey, g6_config.cf_social_login_use AS g6_config_cf_social_login_use, g6_config.cf_social_servicelist AS g6_config_cf_social_servicelist, g6_config.cf_payco_clientid AS g6_config_cf_payco_clientid, g6_config.cf_payco_secret AS g6_config_cf_payco_secret, g6_config.cf_facebook_appid AS g6_config_cf_facebook_appid, g6_config.cf_facebook_secret AS g6_config_cf_facebook_secret, g6_config.cf_twitter_key AS g6_config_cf_twitter_key, g6_config.cf_twitter_secret AS g6_config_cf_twitter_secret, g6_config.cf_google_clientid AS g6_config_cf_google_clientid, g6_config.cf_google_secret AS g6_config_cf_google_secret, g6_config.cf_naver_clientid AS g6_config_cf_naver_clientid, g6_config.cf_naver_secret AS g6_config_cf_naver_secret, g6_config.cf_kakao_rest_key AS g6_config_cf_kakao_rest_key, g6_config.cf_kakao_client_secret AS g6_config_cf_kakao_client_secret, g6_config.cf_kakao_js_apikey AS g6_config_cf_kakao_js_apikey, g6_config.cf_captcha AS g6_config_cf_captcha, g6_config.cf_recaptcha_site_key AS g6_config_cf_recaptcha_site_key, g6_config.cf_recaptcha_secret_key AS g6_config_cf_recaptcha_secret_key, g6_config.cf_1_subj AS g6_config_cf_1_subj, g6_config.cf_2_subj AS g6_config_cf_2_subj, g6_config.cf_3_subj AS g6_config_cf_3_subj, g6_config.cf_4_subj AS g6_config_cf_4_subj, g6_config.cf_5_subj AS g6_config_cf_5_subj, g6_config.cf_6_subj AS g6_config_cf_6_subj, g6_config.cf_7_subj AS g6_config_cf_7_subj, g6_config.cf_8_subj AS g6_config_cf_8_subj, g6_config.cf_9_subj AS g6_config_cf_9_subj, g6_config.cf_10_subj AS g6_config_cf_10_subj, g6_config.cf_1 AS g6_config_cf_1, g6_config.cf_2 AS g6_config_cf_2, g6_config.cf_3 AS g6_config_cf_3, g6_config.cf_4 AS g6_config_cf_4, g6_config.cf_5 AS g6_config_cf_5, g6_config.cf_6 AS g6_config_cf_6, g6_config.cf_7 AS g6_config_cf_7, g6_config.cf_8 AS g6_config_cf_8, g6_config.cf_9 AS g6_config_cf_9, g6_config.cf_10 AS g6_config_cf_10
FROM g6_config
LIMIT ? OFFSET ?]
[parameters: (1, 0)]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
from g6.
Related Issues (20)
- 토큰 비밀키 미적용 이슈... HOT 3
- API: 비회원 댓글 관련 HOT 1
- 쪽지 보내기 포인트 버그 및 추가 이슈 HOT 1
- 이메일 보내기 및 수신 기능 이슈 HOT 9
- 관리자 화면 특정 메뉴 500에러 발생 이슈 및 요청 건의 HOT 2
- 게시글 조회 시 반복적으로 조회수 올라가는 이슈
- [건의] 업데이트 패치 파일만 업로드 해주실수 없나요?ㅠ HOT 1
- [rest_api] 정확한 판단 및 내용을 확인할 수 없어 이슈 등록 HOT 2
- [rest_api] 게시글 / 댓글 등록 시 딜레이 미적용 현상
- [rest_api] 게시글 목록 수 출력 오류
- QA MAIL TEMPLATE 적용 누락 부분
- [건의?] 비밀번호 재확인 api 호출
- [python] 로그인 이후 회원가입 재시도 시 정상적으로 회원가입 되는 이슈
- 메일 템플릿 태그 요소가 그대로 보여지는 이슈
- [rest_api] 자동 저장 이슈 2가지
- [rest_api] 미사용 api 제보
- [rest_api][1차수정] 최근 게시물 출력 이슈
- [python] 관리자가 게시글을 수정할 수 없는 이슈
- CORS Misconfiguration 취약점 제보합니다. HOT 3
- [python] 공지 작성 시 게시글 + 공지 두개가 되는 현상
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from g6.