Cookiecutter-django error en migrate

Hola,

Estoy probando cookiecutter-django pero no estoy pudiendo hacerlo andar, ya tengo todo setead (incluyendo las variables de entorno) y al hacer el migrate me dice que no encuentra una tabla y no estoy pudiendo solucionarlo ni encontrar soluciones en internet.

(venv) javier@jm:~/proyectos/finanzas/sist_gestion/system_help_me$ python manage.py makemigrations
Migrations for 'users':
  system_help_me/users/migrations/0001_initial.py
    - Create model User
(venv) javier@jm:~/proyectos/finanzas/sist_gestion/system_help_me$ python manage.py migrate
Operations to perform:
  Apply all migrations: account, admin, auth, contenttypes, sessions, sites, socialaccount, users
Running migrations:
  Applying sites.0003_set_site_domain_and_name...Traceback (most recent call last):
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 82, in _execute
    return self.cursor.execute(sql)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/backends/sqlite3/base.py", line 421, in execute
    return Database.Cursor.execute(self, query)
sqlite3.OperationalError: no such table: django_site_id_seq

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/manage.py", line 31, in <module>
    execute_from_command_line(sys.argv)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/core/management/__init__.py", line 419, in execute_from_command_line
    utility.execute()
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/core/management/__init__.py", line 413, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/core/management/base.py", line 354, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/core/management/base.py", line 398, in execute
    output = self.handle(*args, **options)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/core/management/base.py", line 89, in wrapped
    res = handle_func(*args, **kwargs)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/core/management/commands/migrate.py", line 244, in handle
    post_migrate_state = executor.migrate(
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/migrations/executor.py", line 117, in migrate
    state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards
    state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/migrations/executor.py", line 227, in apply_migration
    state = migration.apply(state, schema_editor)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/migrations/migration.py", line 126, in apply
    operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/migrations/operations/special.py", line 190, in database_forwards
    self.code(from_state.apps, schema_editor)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/system_help_me/contrib/sites/migrations/0003_set_site_domain_and_name.py", line 40, in update_site_forward
    _update_or_create_site_with_sequence(
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/system_help_me/contrib/sites/migrations/0003_set_site_domain_and_name.py", line 28, in _update_or_create_site_with_sequence
    cursor.execute("SELECT last_value from django_site_id_seq")
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 98, in execute
    return super().execute(sql, params)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 66, in execute
    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/utils.py", line 90, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 82, in _execute
    return self.cursor.execute(sql)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/backends/sqlite3/base.py", line 421, in execute
    return Database.Cursor.execute(self, query)
django.db.utils.OperationalError: no such table: django_site_id_seq
(venv) javier@jm:~/proyectos/finanzas/sist_gestion/system_help_me$ python manage.py migrate --run-syncdb
Operations to perform:
  Synchronize unmigrated apps: allauth, anymail, crispy_bootstrap5, crispy_forms, forms, messages, staticfiles
  Apply all migrations: account, admin, auth, contenttypes, sessions, sites, socialaccount, users
Synchronizing apps without migrations:
  Creating tables...
    Running deferred SQL...
Running migrations:
  Applying sites.0003_set_site_domain_and_name...Traceback (most recent call last):
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 82, in _execute
    return self.cursor.execute(sql)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/backends/sqlite3/base.py", line 421, in execute
    return Database.Cursor.execute(self, query)
sqlite3.OperationalError: no such table: django_site_id_seq

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/manage.py", line 31, in <module>
    execute_from_command_line(sys.argv)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/core/management/__init__.py", line 419, in execute_from_command_line
    utility.execute()
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/core/management/__init__.py", line 413, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/core/management/base.py", line 354, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/core/management/base.py", line 398, in execute
    output = self.handle(*args, **options)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/core/management/base.py", line 89, in wrapped
    res = handle_func(*args, **kwargs)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/core/management/commands/migrate.py", line 244, in handle
    post_migrate_state = executor.migrate(
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/migrations/executor.py", line 117, in migrate
    state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards
    state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/migrations/executor.py", line 227, in apply_migration
    state = migration.apply(state, schema_editor)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/migrations/migration.py", line 126, in apply
    operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/migrations/operations/special.py", line 190, in database_forwards
    self.code(from_state.apps, schema_editor)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/system_help_me/contrib/sites/migrations/0003_set_site_domain_and_name.py", line 40, in update_site_forward
    _update_or_create_site_with_sequence(
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/system_help_me/contrib/sites/migrations/0003_set_site_domain_and_name.py", line 28, in _update_or_create_site_with_sequence
    cursor.execute("SELECT last_value from django_site_id_seq")
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 98, in execute
    return super().execute(sql, params)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 66, in execute
    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/utils.py", line 90, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 82, in _execute
    return self.cursor.execute(sql)
  File "/home/javier/proyectos/finanzas/sist_gestion/system_help_me/venv/lib/python3.9/site-packages/django/db/backends/sqlite3/base.py", line 421, in execute
    return Database.Cursor.execute(self, query)
django.db.utils.OperationalError: no such table: django_site_id_seq
(venv) javier@jm:~/proyectos/finanzas/sist_gestion/system_help_me$ 

Alguien tiene alguna idea de por donde puede venir el problema?

Gracias,

Javier.

1 me gusta

Hola!
Parece que alguien más tuvo el error Error with sites migration when using sqlite backend · Issue #3587 · cookiecutter/cookiecutter-django · GitHub

Cabe destacar lo que menciona en el issue sobre que sqlite no es oficialmente soportado por django-cookiecutter.

Entiendo que con la Release 2022.01.11 · cookiecutter/cookiecutter-django · GitHub no tendrías este problema, ya que fue en la siguiente que se introdujo el cambio en la migración que te da error.

Muchas gracias. Justo se me soluciono reemplazar sqlite con postgresql.