#33827: Use of old MySQL version generate unknown default_storage_engine but no
way
to remove/replace parameter by storage_engine
-------------------------------------+-------------------------------------
Reporter: rv2931 | Owner: nobody
Type: | Status: new
Uncategorized |
Component: | Version: 4.0
Uncategorized | Keywords: Mysql, database,
Severity: Normal | database.backends, storage_engine
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
Hi
I meet the error
{{{
(1193, "Unknown system variable 'default_storage_engine'")
}}}
because I'm using an old MySQL version that is waiting for storage_engine
and not default_storage_engine
I've tried to add storage_engine in configuration but the
default_storage_engin is still used, maybe in addition to storage_engine,
and so still generate the error
{{{
DATABASES:{
'default':{}
'mysqldb': {
'ENGINE': 'django.db.backends.mysql',
'HOST': '<url>',
'PORT': '3306',
'USER': '<user>',
'PASSWORD': '<password>',
'NAME': 'bi_entrepot',
'STORAGE_ENGINE': 'MyISAM',
'OPTIONS': {
'init_command': 'SET storage_engine=MyISAM',
}
}
}}}
I looked for solution but didn't find any way to solve my situation
because I have to use this old version of MySQL
--
Ticket URL: <https://code.djangoproject.com/ticket/33827>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/01070181d284238c-5a4b8a08-abd3-4407-a545-168248be170d-000000%40eu-central-1.amazonses.com.
