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.pyin_executereturn self.cursor.execute(sql, params)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\mysql\base.pyinexecutereturn self.cursor.execute(query, args)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\cursors.pyinexecuteres = self._query(query)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\cursors.pyin_querydb.query(q)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\connections.pyinquery_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.pyininnerresponse = get_response(request)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\handlers\base.pyin_get_responseresponse = self.process_exception_by_middleware(e, request)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\handlers\base.pyin_get_responseresponse = wrapped_callback(request, *callback_args, **callback_kwargs)
...
C:\Users\IFEANYI CHIELO\divinecrownapp\pages\views.pyinsoapprod_formform.save()
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\forms\models.pyinsaveself.instance.save()
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\base.pyinsaveforce_update=force_update, update_fields=update_fields)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\base.pyinsave_baseupdated = 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.pyin_save_tableresult = 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.pyin_do_insertusing=using, raw=raw)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\manager.pyinmanager_methodreturn getattr(self.get_queryset(), name)(*args, **kwargs)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\query.pyin_insertreturn 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.pyinexecute_sqlcursor.execute(sql, params)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\utils.pyinexecutereturn super().execute(sql, params)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\utils.pyinexecutereturn 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.pyin_execute_with_wrappersreturn executor(sql, params, many, context)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\utils.pyin_executereturn self.cursor.execute(sql, params)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\utils.pyin__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.pyin_executereturn self.cursor.execute(sql, params)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\mysql\base.pyinexecutereturn self.cursor.execute(query, args)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\cursors.pyinexecuteres = self._query(query)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\cursors.pyin_querydb.query(q)
...
C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\connections.pyinquery_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