Tablespace is missing for a table from storage engine InnoDB

9,166 views
Skip to first unread message

Ifeanyi Chielo

unread,
May 17, 2020, 7:35:44 AM5/17/20
to Django users
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

Kasper Laudrup

unread,
May 17, 2020, 7:41:23 AM5/17/20
to django...@googlegroups.com
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...@googlegroups.com
> <mailto:django-users...@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>.

Ifeanyi Chielo

unread,
May 17, 2020, 8:57:54 AM5/17/20
to django...@googlegroups.com
thanks, I will go through it

Dr. Chielo C. Ifeanyi
Chief Programmer,
Head Webometrics Section
ICT Unit, UNN


To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@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.

Ifeanyi Chielo

unread,
May 17, 2020, 10:05:43 AM5/17/20
to django...@googlegroups.com
I think the full error report below will provide more information on the problem

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
    1.                 return self.cursor.execute(sql, params)
      ...
  • C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\mysql\base.py in execute
    1.             return self.cursor.execute(query, args)
      ...
  • C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\cursors.py in execute
    1.         res = self._query(query)
      ...
  • C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\cursors.py in _query
    1.         db.query(q)
      ...
  • C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\connections.py in query
    1.         _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 in inner
    1.             response = get_response(request)
      ...
  • C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\handlers\base.py in _get_response
    1.                 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
    1.                 response = wrapped_callback(request, *callback_args, **callback_kwargs)
      ...
  • C:\Users\IFEANYI CHIELO\divinecrownapp\pages\views.py in soapprod_form
    1.             form.save()
      ...
  • C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\forms\models.py in save
    1.             self.instance.save()
      ...
  • C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\base.py in save
    1.                        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 in save_base
    1.             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
    1.             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
    1.                                using=using, raw=raw)
      ...
  • C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\manager.py in manager_method
    1.                 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
    1.         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 in execute_sql
    1.                 cursor.execute(sql, params)
      ...
  • C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\utils.py in execute
    1.             return super().execute(sql, params)
      ...
  • C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\utils.py in execute
    1.         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
    1.         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
    1.                 return self.cursor.execute(sql, params)
      ...
  • C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\utils.py in __exit__
    1.                 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
    1.                 return self.cursor.execute(sql, params)
      ...
  • C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\mysql\base.py in execute
    1.             return self.cursor.execute(query, args)
      ...
  • C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\cursors.py in execute
    1.         res = self._query(query)
      ...
  • C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\cursors.py in _query
    1.         db.query(q)
      ...
  • C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\connections.py in query
    1.         _mysql.connection.query(self, query)
      ...

Request information

USER

AnonymousUser

GET

No GET data

POST

VariableValue
csrfmiddlewaretoken
'028gvFjQSbt20DLVTPGhzgNVXvuoLPS2P9ZaHT5UwCo9wiGcZMj8hsw74qEgxGp1'
date
'2020-05-17'
initial-date
'2020-05-17'
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

VariableValue
csrftoken
'FcagzyKaui3Gxaikxe2NX10J7CR4LIxbuj1aLMwe8JYN3PdBDbFEFdJVex1Wxz4a'

META

VariableValue
ALLUSERSPROFILE
'C:\\ProgramData'
APPDATA
'C:\\Users\\IFEANYI CHIELO\\AppData\\Roaming'
ASL.LOG
'Destination=file'
COMMONPROGRAMFILES
'C:\\Program Files\\Common Files'
COMMONPROGRAMFILES(X86)
'C:\\Program Files (x86)\\Common Files'
COMMONPROGRAMW6432
'C:\\Program Files\\Common Files'
COMPUTERNAME
'ANYIJESUINFOTEC'
COMSPEC
'C:\\WINDOWS\\system32\\cmd.exe'
CONTENT_LENGTH
'353'
CONTENT_TYPE
'application/x-www-form-urlencoded'
CSRF_COOKIE
'FcagzyKaui3Gxaikxe2NX10J7CR4LIxbuj1aLMwe8JYN3PdBDbFEFdJVex1Wxz4a'
C_EM64T_REDIST11
'C:\\Program Files (x86)\\Common Files\\Intel\\Shared Files\\cpp\\'
DJANGO_SETTINGS_MODULE
'divinecrownapp.settings'
DRIVERDATA
'C:\\Windows\\System32\\Drivers\\DriverData'
FPS_BROWSER_APP_PROFILE_STRING
'Internet Explorer'
FPS_BROWSER_USER_PROFILE_STRING
'Default'
GATEWAY_INTERFACE
'CGI/1.1'
GOOGLE_API_KEY
'no'
GOOGLE_DEFAULT_CLIENT_ID
'no'
GOOGLE_DEFAULT_CLIENT_SECRET
'no'
HOMEDRIVE
'C:'
HOMEPATH
'\\Users\\IFEANYI CHIELO'
HTTP_ACCEPT
'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9'
HTTP_ACCEPT_ENCODING
'gzip, deflate, br'
HTTP_ACCEPT_LANGUAGE
'en-US,en;q=0.9'
HTTP_CACHE_CONTROL
'max-age=0'
HTTP_CONNECTION
'keep-alive'
HTTP_COOKIE
'csrftoken=FcagzyKaui3Gxaikxe2NX10J7CR4LIxbuj1aLMwe8JYN3PdBDbFEFdJVex1Wxz4a'
HTTP_HOST
'localhost:8000'
HTTP_ORIGIN
'http://localhost:8000'
HTTP_REFERER
'http://localhost:8000/'
HTTP_SEC_FETCH_DEST
'document'
HTTP_SEC_FETCH_MODE
'navigate'
HTTP_SEC_FETCH_SITE
'same-origin'
HTTP_SEC_FETCH_USER
'?1'
HTTP_UPGRADE_INSECURE_REQUESTS
'1'
HTTP_USER_AGENT
('Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like '
 'Gecko) Chrome/81.0.4044.138 Safari/537.36')
LOCALAPPDATA
'C:\\Users\\IFEANYI CHIELO\\AppData\\Local'
LOGONSERVER
'\\\\ANYIJESUINFOTEC'
NUMBER_OF_PROCESSORS
'4'
ONEDRIVE
'C:\\Users\\IFEANYI CHIELO\\OneDrive'
ONEDRIVECONSUMER
'C:\\Users\\IFEANYI CHIELO\\OneDrive'
OS
'Windows_NT'
PATH
('C:\\ProgramData\\Oracle\\Java\\javapath;C:\\Program Files (x86)\\Common '
 'Files\\Intel\\Shared '
 'Files\\cpp\\bin\\Intel64;C:\\WINDOWS\\system32;C:\\WINDOWS;C:\\WINDOWS\\System32\\Wbem;C:\\WINDOWS\\System32\\WindowsPowerShell\\v1.0\\;C:\\WINDOWS\\system32\\config\\systemprofile\\.dnx\\bin;C:\\Program '
 'Files\\Microsoft DNX\\Dnvm\\;C:\\Program Files\\Microsoft SQL '
 'Server\\130\\Tools\\Binn\\;C:\\Program Files (x86)\\Windows '
 'Kits\\10\\Windows Performance '
 'Toolkit\\;C:\\WINDOWS\\System32\\OpenSSH\\;C:\\Program Files\\Microsoft SQL '
 'Server\\120\\Tools\\Binn\\;C:\\Users\\IFEANYI '
 'CHIELO\\AppData\\Local\\Programs\\Python\\Python37\\Scripts\\;C:\\Users\\IFEANYI '
 'CHIELO\\AppData\\Local\\Programs\\Python\\Python37\\;C:\\Users\\IFEANYI '
 'CHIELO\\AppData\\Local\\Microsoft\\WindowsApps;;C:\\Users\\IFEANYI '
 'CHIELO\\AppData\\Local\\Programs\\Microsoft VS Code\\bin')
PATHEXT
'.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC;.CPL'
PATH_INFO
'/'
PROCESSOR_ARCHITECTURE
'AMD64'
PROCESSOR_IDENTIFIER
'Intel64 Family 6 Model 78 Stepping 3, GenuineIntel'
PROCESSOR_LEVEL
'6'
PROCESSOR_REVISION
'4e03'
PROGRAMDATA
'C:\\ProgramData'
PROGRAMFILES
'C:\\Program Files'
PROGRAMFILES(X86)
'C:\\Program Files (x86)'
PROGRAMW6432
'C:\\Program Files'
PSMODULEPATH
('C:\\Users\\IFEANYI CHIELO\\Documents\\WindowsPowerShell\\Modules;C:\\Program '
 'Files\\WindowsPowerShell\\Modules;C:\\WINDOWS\\system32\\WindowsPowerShell\\v1.0\\Modules\\')
PUBLIC
'C:\\Users\\Public'
QUERY_STRING
''
REMOTE_ADDR
'127.0.0.1'
REMOTE_HOST
''
REQUEST_METHOD
'POST'
RUN_MAIN
'true'
SCRIPT_NAME
''
SERVER_NAME
'hlrcv.stage.adobe.com'
SERVER_PORT
'8000'
SERVER_PROTOCOL
'HTTP/1.1'
SERVER_SOFTWARE
'WSGIServer/0.2'
SESSIONNAME
'Console'
SYSTEMDRIVE
'C:'
SYSTEMROOT
'C:\\WINDOWS'
TEMP
'C:\\Users\\IFEANY~1\\AppData\\Local\\Temp'
TMP
'C:\\Users\\IFEANY~1\\AppData\\Local\\Temp'
USERDOMAIN
'ANYIJESUINFOTEC'
USERDOMAIN_ROAMINGPROFILE
'ANYIJESUINFOTEC'
USERNAME
'IFEANYI CHIELO'
USERPROFILE
'C:\\Users\\IFEANYI CHIELO'
VBOX_MSI_INSTALL_PATH
'C:\\Program Files\\Oracle\\VirtualBox\\'
VS140COMNTOOLS
'C:\\Program Files (x86)\\Microsoft Visual Studio 14.0\\Common7\\Tools\\'
WINDIR
'C:\\WINDOWS'
wsgi.errors
<_io.TextIOWrapper name='<stderr>' mode='w' encoding='utf-8'>
wsgi.file_wrapper
''
wsgi.input
<django.core.handlers.wsgi.LimitedStream object at 0x00000145CAADC4A8>
wsgi.multiprocess
False
wsgi.multithread
True
wsgi.run_once
False
wsgi.url_scheme
'http'
wsgi.version
(1, 0)

Settings

Using settings module divinecrownapp.settings

SettingValue
ABSOLUTE_URL_OVERRIDES
{}
ADMINS
[]
ALLOWED_HOSTS
[]
APPEND_SLASH
True
AUTHENTICATION_BACKENDS
['django.contrib.auth.backends.ModelBackend']
AUTH_PASSWORD_VALIDATORS
'********************'
AUTH_USER_MODEL
'auth.User'
BASE_DIR
'C:\\Users\\IFEANYI CHIELO\\divinecrownapp'
CACHES
{'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}
CACHE_MIDDLEWARE_ALIAS
'default'
CACHE_MIDDLEWARE_KEY_PREFIX
'********************'
CACHE_MIDDLEWARE_SECONDS
600
CRISPY_TEMPLATE_PACK
'bootstrap4'
CSRF_COOKIE_AGE
31449600
CSRF_COOKIE_DOMAIN
None
CSRF_COOKIE_HTTPONLY
False
CSRF_COOKIE_NAME
'csrftoken'
CSRF_COOKIE_PATH
'/'
CSRF_COOKIE_SAMESITE
'Lax'
CSRF_COOKIE_SECURE
False
CSRF_FAILURE_VIEW
'django.views.csrf.csrf_failure'
CSRF_HEADER_NAME
'HTTP_X_CSRFTOKEN'
CSRF_TRUSTED_ORIGINS
[]
CSRF_USE_SESSIONS
False
DATABASES
{'default': {'ATOMIC_REQUESTS': False,
             'AUTOCOMMIT': True,
             'CONN_MAX_AGE': 0,
             'ENGINE': 'django.db.backends.mysql',
             'HOST': 'localhost',
             'NAME': 'divinecrownapp',
             'OPTIONS': {'init_command': "SET sql_mode='STRICT_TRANS_TABLES'"},
             'PASSWORD': '********************',
             'PORT': '',
             'TEST': {'CHARSET': None,
                      'COLLATION': None,
                      'MIRROR': None,
                      'NAME': None},
             'TIME_ZONE': None,
             'USER': 'root'}}
DATABASE_ROUTERS
[]
DATA_UPLOAD_MAX_MEMORY_SIZE
2621440
DATA_UPLOAD_MAX_NUMBER_FIELDS
1000
DATETIME_FORMAT
'N j, Y, P'
DATETIME_INPUT_FORMATS
['%Y-%m-%d %H:%M:%S',
 '%Y-%m-%d %H:%M:%S.%f',
 '%Y-%m-%d %H:%M',
 '%Y-%m-%d',
 '%m/%d/%Y %H:%M:%S',
 '%m/%d/%Y %H:%M:%S.%f',
 '%m/%d/%Y %H:%M',
 '%m/%d/%Y',
 '%m/%d/%y %H:%M:%S',
 '%m/%d/%y %H:%M:%S.%f',
 '%m/%d/%y %H:%M',
 '%m/%d/%y']
DATE_FORMAT
'N j, Y'
DATE_INPUT_FORMATS
['%Y-%m-%d',
 '%m/%d/%Y',
 '%m/%d/%y',
 '%b %d %Y',
 '%b %d, %Y',
 '%d %b %Y',
 '%d %b, %Y',
 '%B %d %Y',
 '%B %d, %Y',
 '%d %B %Y',
 '%d %B, %Y']
DEBUG
True
DEBUG_PROPAGATE_EXCEPTIONS
False
DECIMAL_SEPARATOR
'.'
DEFAULT_CHARSET
'utf-8'
DEFAULT_CONTENT_TYPE
'text/html'
DEFAULT_EXCEPTION_REPORTER_FILTER
'django.views.debug.SafeExceptionReporterFilter'
DEFAULT_FILE_STORAGE
'django.core.files.storage.FileSystemStorage'
DEFAULT_FROM_EMAIL
'webmaster@localhost'
DEFAULT_INDEX_TABLESPACE
''
DEFAULT_TABLESPACE
''
DISALLOWED_USER_AGENTS
[]
EMAIL_BACKEND
'django.core.mail.backends.smtp.EmailBackend'
EMAIL_HOST
'localhost'
EMAIL_HOST_PASSWORD
'********************'
EMAIL_HOST_USER
''
EMAIL_PORT
25
EMAIL_SSL_CERTFILE
None
EMAIL_SSL_KEYFILE
'********************'
EMAIL_SUBJECT_PREFIX
'[Django] '
EMAIL_TIMEOUT
None
EMAIL_USE_LOCALTIME
False
EMAIL_USE_SSL
False
EMAIL_USE_TLS
False
FILE_CHARSET
'utf-8'
FILE_UPLOAD_DIRECTORY_PERMISSIONS
None
FILE_UPLOAD_HANDLERS
['django.core.files.uploadhandler.MemoryFileUploadHandler',
 'django.core.files.uploadhandler.TemporaryFileUploadHandler']
FILE_UPLOAD_MAX_MEMORY_SIZE
2621440
FILE_UPLOAD_PERMISSIONS
None
FILE_UPLOAD_TEMP_DIR
None
FIRST_DAY_OF_WEEK
0
FIXTURE_DIRS
[]
FORCE_SCRIPT_NAME
None
FORMAT_MODULE_PATH
None
FORM_RENDERER
'django.forms.renderers.DjangoTemplates'
IGNORABLE_404_URLS
[]
INSTALLED_APPS
['django.contrib.admin',
 'django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.messages',
 'django.contrib.staticfiles',
 'pages.apps.PagesConfig',
 'corsheaders',
 'crispy_forms']
INTERNAL_IPS
[]
LANGUAGES
[('af', 'Afrikaans'),
 ('ar', 'Arabic'),
 ('ast', 'Asturian'),
 ('az', 'Azerbaijani'),
 ('bg', 'Bulgarian'),
 ('be', 'Belarusian'),
 ('bn', 'Bengali'),
 ('br', 'Breton'),
 ('bs', 'Bosnian'),
 ('ca', 'Catalan'),
 ('cs', 'Czech'),
 ('cy', 'Welsh'),
 ('da', 'Danish'),
 ('de', 'German'),
 ('dsb', 'Lower Sorbian'),
 ('el', 'Greek'),
 ('en', 'English'),
 ('en-au', 'Australian English'),
 ('en-gb', 'British English'),
 ('eo', 'Esperanto'),
 ('es', 'Spanish'),
 ('es-ar', 'Argentinian Spanish'),
 ('es-co', 'Colombian Spanish'),
 ('es-mx', 'Mexican Spanish'),
 ('es-ni', 'Nicaraguan Spanish'),
 ('es-ve', 'Venezuelan Spanish'),
 ('et', 'Estonian'),
 ('eu', 'Basque'),
 ('fa', 'Persian'),
 ('fi', 'Finnish'),
 ('fr', 'French'),
 ('fy', 'Frisian'),
 ('ga', 'Irish'),
 ('gd', 'Scottish Gaelic'),
 ('gl', 'Galician'),
 ('he', 'Hebrew'),
 ('hi', 'Hindi'),
 ('hr', 'Croatian'),
 ('hsb', 'Upper Sorbian'),
 ('hu', 'Hungarian'),
 ('ia', 'Interlingua'),
 ('id', 'Indonesian'),
 ('io', 'Ido'),
 ('is', 'Icelandic'),
 ('it', 'Italian'),
 ('ja', 'Japanese'),
 ('ka', 'Georgian'),
 ('kab', 'Kabyle'),
 ('kk', 'Kazakh'),
 ('km', 'Khmer'),
 ('kn', 'Kannada'),
 ('ko', 'Korean'),
 ('lb', 'Luxembourgish'),
 ('lt', 'Lithuanian'),
 ('lv', 'Latvian'),
 ('mk', 'Macedonian'),
 ('ml', 'Malayalam'),
 ('mn', 'Mongolian'),
 ('mr', 'Marathi'),
 ('my', 'Burmese'),
 ('nb', 'Norwegian Bokmål'),
 ('ne', 'Nepali'),
 ('nl', 'Dutch'),
 ('nn', 'Norwegian Nynorsk'),
 ('os', 'Ossetic'),
 ('pa', 'Punjabi'),
 ('pl', 'Polish'),
 ('pt', 'Portuguese'),
 ('pt-br', 'Brazilian Portuguese'),
 ('ro', 'Romanian'),
 ('ru', 'Russian'),
 ('sk', 'Slovak'),
 ('sl', 'Slovenian'),
 ('sq', 'Albanian'),
 ('sr', 'Serbian'),
 ('sr-latn', 'Serbian Latin'),
 ('sv', 'Swedish'),
 ('sw', 'Swahili'),
 ('ta', 'Tamil'),
 ('te', 'Telugu'),
 ('th', 'Thai'),
 ('tr', 'Turkish'),
 ('tt', 'Tatar'),
 ('udm', 'Udmurt'),
 ('uk', 'Ukrainian'),
 ('ur', 'Urdu'),
 ('vi', 'Vietnamese'),
 ('zh-hans', 'Simplified Chinese'),
 ('zh-hant', 'Traditional Chinese')]
LANGUAGES_BIDI
['he', 'ar', 'fa', 'ur']
LANGUAGE_CODE
'en-us'
LANGUAGE_COOKIE_AGE
None
LANGUAGE_COOKIE_DOMAIN
None
LANGUAGE_COOKIE_NAME
'django_language'
LANGUAGE_COOKIE_PATH
'/'
LOCALE_PATHS
[]
LOGGING
{}
LOGGING_CONFIG
'logging.config.dictConfig'
LOGIN_REDIRECT_URL
'/accounts/profile/'
LOGIN_URL
'/accounts/login/'
LOGOUT_REDIRECT_URL
None
MANAGERS
[]
MEDIA_ROOT
''
MEDIA_URL
''
MESSAGE_STORAGE
'django.contrib.messages.storage.fallback.FallbackStorage'
MIDDLEWARE
['django.middleware.security.SecurityMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.common.CommonMiddleware',
 'django.middleware.csrf.CsrfViewMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware',
 'django.middleware.clickjacking.XFrameOptionsMiddleware',
 'corsheaders.middleware.CorsMiddleware']
MIGRATION_MODULES
{}
MONTH_DAY_FORMAT
'F j'
NUMBER_GROUPING
0
PASSWORD_HASHERS
'********************'
PASSWORD_RESET_TIMEOUT_DAYS
'********************'
PREPEND_WWW
False
ROOT_URLCONF
'divinecrownapp.urls'
SECRET_KEY
'********************'
SECURE_BROWSER_XSS_FILTER
False
SECURE_CONTENT_TYPE_NOSNIFF
False
SECURE_HSTS_INCLUDE_SUBDOMAINS
False
SECURE_HSTS_PRELOAD
False
SECURE_HSTS_SECONDS
0
SECURE_PROXY_SSL_HEADER
None
SECURE_REDIRECT_EXEMPT
[]
SECURE_SSL_HOST
None
SECURE_SSL_REDIRECT
False
SERVER_EMAIL
'root@localhost'
SESSION_CACHE_ALIAS
'default'
SESSION_COOKIE_AGE
1209600
SESSION_COOKIE_DOMAIN
None
SESSION_COOKIE_HTTPONLY
True
SESSION_COOKIE_NAME
'sessionid'
SESSION_COOKIE_PATH
'/'
SESSION_COOKIE_SAMESITE
'Lax'
SESSION_COOKIE_SECURE
False
SESSION_ENGINE
'django.contrib.sessions.backends.db'
SESSION_EXPIRE_AT_BROWSER_CLOSE
False
SESSION_FILE_PATH
None
SESSION_SAVE_EVERY_REQUEST
False
SESSION_SERIALIZER
'django.contrib.sessions.serializers.JSONSerializer'
SETTINGS_MODULE
'divinecrownapp.settings'
SHORT_DATETIME_FORMAT
'm/d/Y P'
SHORT_DATE_FORMAT
'm/d/Y'
SIGNING_BACKEND
'django.core.signing.TimestampSigner'
SILENCED_SYSTEM_CHECKS
[]
STATICFILES_DIRS
[]
STATICFILES_FINDERS
['django.contrib.staticfiles.finders.FileSystemFinder',
 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
STATICFILES_STORAGE
'django.contrib.staticfiles.storage.StaticFilesStorage'
STATIC_ROOT
None
STATIC_URL
'/static/'
TEMPLATES
[{'APP_DIRS': True,
  'BACKEND': 'django.template.backends.django.DjangoTemplates',
  'DIRS': ['C:\\Users\\IFEANYI CHIELO\\divinecrownapp\\templates'],
  'OPTIONS': {'context_processors': ['django.template.context_processors.debug',
                                     'django.template.context_processors.request',
                                     'django.contrib.auth.context_processors.auth',
                                     'django.contrib.messages.context_processors.messages']}}]
TEST_NON_SERIALIZED_APPS
[]
TEST_RUNNER
'django.test.runner.DiscoverRunner'
THOUSAND_SEPARATOR
','
TIME_FORMAT
'P'
TIME_INPUT_FORMATS
['%H:%M:%S', '%H:%M:%S.%f', '%H:%M']
TIME_ZONE
'UTC'
USE_I18N
True
USE_L10N
True
USE_THOUSAND_SEPARATOR
False
USE_TZ
True
USE_X_FORWARDED_HOST
False
USE_X_FORWARDED_PORT
False
WSGI_APPLICATION
'divinecrownapp.wsgi.application'
X_FRAME_OPTIONS
'SAMEORIGIN'
YEAR_MONTH_FORMAT
'F Y'

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,
Head Webometrics Section
ICT Unit, UNN

Kasper Laudrup

unread,
May 17, 2020, 10:22:31 AM5/17/20
to django...@googlegroups.com
Hi Ifeanyi,

On 17/05/2020 16.04, Ifeanyi Chielo wrote:
> I think the full error report below will provide more information on the
> problem
>

That's an error from MySQL. I doubt this is related to Django.

This was what I could find:

https://bobcares.com/blog/mysql-tablespace-is-missing-for-table/

Kind regards,

Kasper Laudrup
Reply all
Reply to author
Forward
0 new messages