this works fine with sqlite.
But now if I configure my installation to work with mysql, then I get this error on the initial python manage.py migrate
:
[00:04:05] Traceback (most recent call last):
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
[00:04:05] return self.cursor.execute(sql, params)
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 73, in execute
[00:04:05] return self.cursor.execute(query, args)
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
[00:04:05] res = self._query(query)
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
[00:04:05] db.query(q)
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/MySQLdb/connections.py", line 259, in query
[00:04:05] _mysql.connection.query(self, query)
[00:04:05] MySQLdb._exceptions.ProgrammingError: (1146, "Table 'basxconnect.core_vocabulary' doesn't exist")
[00:04:05]
[00:04:05] The above exception was the direct cause of the following exception:
[00:04:05]
[00:04:05] Traceback (most recent call last):
[00:04:05] File "/home/django/basxconnect_demo/manage.py", line 23, in <module>
[00:04:05] main()
[00:04:05] File "/home/django/basxconnect_demo/manage.py", line 19, in main
[00:04:05] execute_from_command_line(sys.argv)
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/django/core/management/__init__.py", line 419, in execute_from_command_line
[00:04:05] utility.execute()
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/django/core/management/__init__.py", line 395, in execute
[00:04:05] django.setup()
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/django/__init__.py", line 24, in setup
[00:04:05] apps.populate(settings.INSTALLED_APPS)
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/django/apps/registry.py", line 122, in populate
[00:04:05] app_config.ready()
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/basxconnect/core/apps.py", line 30, in ready
[00:04:05] Vocabulary.objects.get_or_create(slug=slug, defaults={"name": name})
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/django/db/models/manager.py", line 85, in manager_method
[00:04:05] return getattr(self.get_queryset(), name)(*args, **kwargs)
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/django/db/models/query.py", line 581, in get_or_create
[00:04:05] return self.get(**kwargs), False
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/django/db/models/query.py", line 431, in get
[00:04:05] num = len(clone)
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/django/db/models/query.py", line 262, in __len__
[00:04:05] self._fetch_all()
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/django/db/models/query.py", line 1324, in _fetch_all
[00:04:05] self._result_cache = list(self._iterable_class(self))
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/django/db/models/query.py", line 51, in __iter__
[00:04:05] results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1175, in execute_sql
[00:04:05] cursor.execute(sql, params)
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 98, in execute
[00:04:05] return super().execute(sql, params)
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 66, in execute
[00:04:05] return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
[00:04:05] return executor(sql, params, many, context)
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
[00:04:05] return self.cursor.execute(sql, params)
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/django/db/utils.py", line 90, in __exit__
[00:04:05] raise dj_exc_value.with_traceback(traceback) from exc_value
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
[00:04:05] return self.cursor.execute(sql, params)
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 73, in execute
[00:04:05] return self.cursor.execute(query, args)
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
[00:04:05] res = self._query(query)
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
[00:04:05] db.query(q)
[00:04:05] File "/home/django/basxconnect_demo/.venv/lib/python3.9/site-packages/MySQLdb/connections.py", line 259, in query
[00:04:05] _mysql.connection.query(self, query)
[00:04:05] django.db.utils.ProgrammingError: (1146, "Table 'basxconnect.core_vocabulary' doesn't exist")
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'OPTIONS': {
'read_default_file': '/home/django/my.cnf',
},
}
}