I think the full error report below will provide more information on the problem
Using settings module
OperationalError at /
(1030, 'Got error 194 "Tablespace is missing for a table" from storage engine InnoDB')
Request Method: | POST |
---|---|
Request URL: | http://localhost:8000/ |
Django Version: | 2.1.5 |
Exception Type: | OperationalError |
Exception Value: | (1030, 'Got error 194 "Tablespace is missing for a table" from storage engine InnoDB') |
Exception Location: | C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\connections.py in query, line 239 |
Python Executable: | C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\python.exe |
Python Version: | 3.7.2 |
Python Path: | ['C:\\Users\\IFEANYI CHIELO\\divinecrownapp', 'C:\\Users\\IFEANYI ' 'CHIELO\\AppData\\Local\\Programs\\Python\\Python37\\python37.zip', 'C:\\Users\\IFEANYI CHIELO\\AppData\\Local\\Programs\\Python\\Python37\\DLLs', 'C:\\Users\\IFEANYI CHIELO\\AppData\\Local\\Programs\\Python\\Python37\\lib', 'C:\\Users\\IFEANYI CHIELO\\AppData\\Local\\Programs\\Python\\Python37', 'C:\\Users\\IFEANYI ' 'CHIELO\\AppData\\Local\\Programs\\Python\\Python37\\lib\\site-packages'] |
Server time: | Sun, 17 May 2020 13:08:00 +0000 |
Traceback Switch to copy-and-paste view
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\utils.py
in_execute
return self.cursor.execute(sql, params)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\mysql\base.py
inexecute
return self.cursor.execute(query, args)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\cursors.py
inexecute
res = self._query(query)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\cursors.py
in_query
db.query(q)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\connections.py
inquery
_mysql.connection.query(self, query)
...
The above exception ((1030, 'Got error 194 "Tablespace is missing for a table" from storage engine InnoDB')) was the direct cause of the following exception:
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\handlers\exception.py
ininner
response = get_response(request)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\handlers\base.py
in_get_response
response = self.process_exception_by_middleware(e, request)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\handlers\base.py
in_get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
...
C:\Users\IFEANYI CHIELO\divinecrownapp\pages\views.py
insoapprod_form
form.save()
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\forms\models.py
insave
self.instance.save()
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\base.py
insave
force_update=force_update, update_fields=update_fields)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\base.py
insave_base
updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\base.py
in_save_table
result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\base.py
in_do_insert
using=using, raw=raw)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\manager.py
inmanager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\query.py
in_insert
return query.get_compiler(using=using).execute_sql(return_id)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\sql\compiler.py
inexecute_sql
cursor.execute(sql, params)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\utils.py
inexecute
return super().execute(sql, params)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\utils.py
inexecute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\utils.py
in_execute_with_wrappers
return executor(sql, params, many, context)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\utils.py
in_execute
return self.cursor.execute(sql, params)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\utils.py
in__exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\utils.py
in_execute
return self.cursor.execute(sql, params)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\mysql\base.py
inexecute
return self.cursor.execute(query, args)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\cursors.py
inexecute
res = self._query(query)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\cursors.py
in_query
db.query(q)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\connections.py
inquery
_mysql.connection.query(self, query)
...
Request information
USER
AnonymousUser
GET
No GET data
POST
Variable | Value |
---|---|
csrfmiddlewaretoken | |
date | |
initial-date | |
Serial_White_Guava | |
Serial_White_Premium | |
Soft_Flower_Body_Wash | |
Soft_Flower_Fresh | |
Soft_Flower_Orange_Lightening | |
Soft_Flower_Carot_Lightening | |
Soft_Flower_Papaya_Extract | |
Soft_Flower_Extra_Lightening | |
Serial_White_Papaya_4in1 |
FILES
No FILES data
COOKIES
Variable | Value |
---|---|
csrftoken |
META
Variable | Value |
---|---|
ALLUSERSPROFILE | |
APPDATA | |
ASL.LOG | |
COMMONPROGRAMFILES | |
COMMONPROGRAMFILES(X86) | |
COMMONPROGRAMW6432 | |
COMPUTERNAME | |
COMSPEC | |
CONTENT_LENGTH | |
CONTENT_TYPE | |
CSRF_COOKIE | |
C_EM64T_REDIST11 | |
DJANGO_SETTINGS_MODULE | |
DRIVERDATA | |
FPS_BROWSER_APP_PROFILE_STRING | |
FPS_BROWSER_USER_PROFILE_STRING | |
GATEWAY_INTERFACE | |
GOOGLE_API_KEY | |
GOOGLE_DEFAULT_CLIENT_ID | |
GOOGLE_DEFAULT_CLIENT_SECRET | |
HOMEDRIVE | |
HOMEPATH | |
HTTP_ACCEPT | |
HTTP_ACCEPT_ENCODING | |
HTTP_ACCEPT_LANGUAGE | |
HTTP_CACHE_CONTROL | |
HTTP_CONNECTION | |
HTTP_COOKIE | |
HTTP_HOST | |
HTTP_ORIGIN | |
HTTP_REFERER | |
HTTP_SEC_FETCH_DEST | |
HTTP_SEC_FETCH_MODE | |
HTTP_SEC_FETCH_SITE | |
HTTP_SEC_FETCH_USER | |
HTTP_UPGRADE_INSECURE_REQUESTS | |
HTTP_USER_AGENT | |
LOCALAPPDATA | |
LOGONSERVER | |
NUMBER_OF_PROCESSORS | |
ONEDRIVE | |
ONEDRIVECONSUMER | |
OS | |
PATH | |
PATHEXT | |
PATH_INFO | |
PROCESSOR_ARCHITECTURE | |
PROCESSOR_IDENTIFIER | |
PROCESSOR_LEVEL | |
PROCESSOR_REVISION | |
PROGRAMDATA | |
PROGRAMFILES | |
PROGRAMFILES(X86) | |
PROGRAMW6432 | |
PSMODULEPATH | |
PUBLIC | |
QUERY_STRING | |
REMOTE_ADDR | |
REMOTE_HOST | |
REQUEST_METHOD | |
RUN_MAIN | |
SCRIPT_NAME | |
SERVER_NAME | |
SERVER_PORT | |
SERVER_PROTOCOL | |
SERVER_SOFTWARE | |
SESSIONNAME | |
SYSTEMDRIVE | |
SYSTEMROOT | |
TEMP | |
TMP | |
USERDOMAIN | |
USERDOMAIN_ROAMINGPROFILE | |
USERNAME | |
USERPROFILE | |
VBOX_MSI_INSTALL_PATH | |
VS140COMNTOOLS | |
WINDIR | |
wsgi.errors | |
wsgi.file_wrapper | |
wsgi.input | |
wsgi.multiprocess | |
wsgi.multithread | |
wsgi.run_once | |
wsgi.url_scheme | |
wsgi.version |
Settings
Using settings module divinecrownapp.settings
Setting | Value |
---|---|
ABSOLUTE_URL_OVERRIDES | |
ADMINS | |
ALLOWED_HOSTS | |
APPEND_SLASH | |
AUTHENTICATION_BACKENDS | |
AUTH_PASSWORD_VALIDATORS | |
AUTH_USER_MODEL | |
BASE_DIR | |
CACHES | |
CACHE_MIDDLEWARE_ALIAS | |
CACHE_MIDDLEWARE_KEY_PREFIX | |
CACHE_MIDDLEWARE_SECONDS | |
CRISPY_TEMPLATE_PACK | |
CSRF_COOKIE_AGE | |
CSRF_COOKIE_DOMAIN | |
CSRF_COOKIE_HTTPONLY | |
CSRF_COOKIE_NAME | |
CSRF_COOKIE_PATH | |
CSRF_COOKIE_SAMESITE | |
CSRF_COOKIE_SECURE | |
CSRF_FAILURE_VIEW | |
CSRF_HEADER_NAME | |
CSRF_TRUSTED_ORIGINS | |
CSRF_USE_SESSIONS | |
DATABASES | |
DATABASE_ROUTERS | |
DATA_UPLOAD_MAX_MEMORY_SIZE | |
DATA_UPLOAD_MAX_NUMBER_FIELDS | |
DATETIME_FORMAT | |
DATETIME_INPUT_FORMATS | |
DATE_FORMAT | |
DATE_INPUT_FORMATS | |
DEBUG | |
DEBUG_PROPAGATE_EXCEPTIONS | |
DECIMAL_SEPARATOR | |
DEFAULT_CHARSET | |
DEFAULT_CONTENT_TYPE | |
DEFAULT_EXCEPTION_REPORTER_FILTER | |
DEFAULT_FILE_STORAGE | |
DEFAULT_FROM_EMAIL | |
DEFAULT_INDEX_TABLESPACE | |
DEFAULT_TABLESPACE | |
DISALLOWED_USER_AGENTS | |
EMAIL_BACKEND | |
EMAIL_HOST | |
EMAIL_HOST_PASSWORD | |
EMAIL_HOST_USER | |
EMAIL_PORT | |
EMAIL_SSL_CERTFILE | |
EMAIL_SSL_KEYFILE | |
EMAIL_SUBJECT_PREFIX | |
EMAIL_TIMEOUT | |
EMAIL_USE_LOCALTIME | |
EMAIL_USE_SSL | |
EMAIL_USE_TLS | |
FILE_CHARSET | |
FILE_UPLOAD_DIRECTORY_PERMISSIONS | |
FILE_UPLOAD_HANDLERS | |
FILE_UPLOAD_MAX_MEMORY_SIZE | |
FILE_UPLOAD_PERMISSIONS | |
FILE_UPLOAD_TEMP_DIR | |
FIRST_DAY_OF_WEEK | |
FIXTURE_DIRS | |
FORCE_SCRIPT_NAME | |
FORMAT_MODULE_PATH | |
FORM_RENDERER | |
IGNORABLE_404_URLS | |
INSTALLED_APPS | |
INTERNAL_IPS | |
LANGUAGES | |
LANGUAGES_BIDI | |
LANGUAGE_CODE | |
LANGUAGE_COOKIE_AGE | |
LANGUAGE_COOKIE_DOMAIN | |
LANGUAGE_COOKIE_NAME | |
LANGUAGE_COOKIE_PATH | |
LOCALE_PATHS | |
LOGGING | |
LOGGING_CONFIG | |
LOGIN_REDIRECT_URL | |
LOGIN_URL | |
LOGOUT_REDIRECT_URL | |
MANAGERS | |
MEDIA_ROOT | |
MEDIA_URL | |
MESSAGE_STORAGE | |
MIDDLEWARE | |
MIGRATION_MODULES | |
MONTH_DAY_FORMAT | |
NUMBER_GROUPING | |
PASSWORD_HASHERS | |
PASSWORD_RESET_TIMEOUT_DAYS | |
PREPEND_WWW | |
ROOT_URLCONF | |
SECRET_KEY | |
SECURE_BROWSER_XSS_FILTER | |
SECURE_CONTENT_TYPE_NOSNIFF | |
SECURE_HSTS_INCLUDE_SUBDOMAINS | |
SECURE_HSTS_PRELOAD | |
SECURE_HSTS_SECONDS | |
SECURE_PROXY_SSL_HEADER | |
SECURE_REDIRECT_EXEMPT | |
SECURE_SSL_HOST | |
SECURE_SSL_REDIRECT | |
SERVER_EMAIL | |
SESSION_CACHE_ALIAS | |
SESSION_COOKIE_AGE | |
SESSION_COOKIE_DOMAIN | |
SESSION_COOKIE_HTTPONLY | |
SESSION_COOKIE_NAME | |
SESSION_COOKIE_PATH | |
SESSION_COOKIE_SAMESITE | |
SESSION_COOKIE_SECURE | |
SESSION_ENGINE | |
SESSION_EXPIRE_AT_BROWSER_CLOSE | |
SESSION_FILE_PATH | |
SESSION_SAVE_EVERY_REQUEST | |
SESSION_SERIALIZER | |
SETTINGS_MODULE | |
SHORT_DATETIME_FORMAT | |
SHORT_DATE_FORMAT | |
SIGNING_BACKEND | |
SILENCED_SYSTEM_CHECKS | |
STATICFILES_DIRS | |
STATICFILES_FINDERS | |
STATICFILES_STORAGE | |
STATIC_ROOT | |
STATIC_URL | |
TEMPLATES | |
TEST_NON_SERIALIZED_APPS | |
TEST_RUNNER | |
THOUSAND_SEPARATOR | |
TIME_FORMAT | |
TIME_INPUT_FORMATS | |
TIME_ZONE | |
USE_I18N | |
USE_L10N | |
USE_THOUSAND_SEPARATOR | |
USE_TZ | |
USE_X_FORWARDED_HOST | |
USE_X_FORWARDED_PORT | |
WSGI_APPLICATION | |
X_FRAME_OPTIONS | |
YEAR_MONTH_FORMAT |
You're seeing this error because you have DEBUG = True
in your Django settings file. Change that to False
, and Djang
Dr. Chielo C. Ifeanyi
Chief Programmer,
Chief Programmer,
Head Webometrics Section
ICT Unit, UNN
ICT Unit, UNN
On Sun, May 17, 2020 at 1:56 PM Ifeanyi Chielo <ifeanyi.chielo@unn.edu.ng> wrote:
thanks, I will go through itDr. Chielo C. Ifeanyi
Chief Programmer,Head Webometrics Section
ICT Unit, UNNOn Sun, May 17, 2020 at 12:40 PM Kasper Laudrup <laudrup@stacktrace.dk> wrote:Hi Ifeanyi,
On 17/05/2020 13.35, Ifeanyi Chielo wrote:
> Dear all
> I am unable to access my phpmyadmin tables either via django or
> directtly, I always meet this error. " #1030 - Got error 194 "Tablespace
> is missing for a table" from storage engine InnoDB"
> Please I need your assistance
>
I think you would have a much better chance of getting assistance here:
https://www.phpmyadmin.net/support/
Kind regards,
Kasper Laudrup
> --
> You received this message because you are subscribed to the Google
> Groups "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to django-users+unsubscribe@googlegroups.com
> <mailto:django-users+unsubscribe@googlegroups.com>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/565b0156-b1f2-4c34-8e04-55081573bb2a%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/565b0156-b1f2-4c34-8e04-55081573bb2a%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/56425dfd-3e17-c21f-3bb6-d765ccc1d82e%40stacktrace.dk.
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAOcS8H15mensrXwvAHcFYAHOO%3DuJmasPW8jhhAC8xYHixNA7jA%40mail.gmail.com.
No comments:
Post a Comment