setup fails: django.db.utils.OperationalError: no such table: chat_trigger

[holtzermann17]

Requirements have been installed, but the next step doesn't work for me.

$ python manage.py setup
python manage.py setup
Traceback (most recent call last):
  File "/home/joe/PolyBotConversation/demo/lib/python3.12/site-packages/django/db/backends/utils.py", line 105, in _execute
    return self.cursor.execute(sql, params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/joe/PolyBotConversation/demo/lib/python3.12/site-packages/django/db/backends/sqlite3/base.py", line 354, in execute
    return super().execute(query, params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
sqlite3.OperationalError: no such table: chat_trigger

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

Traceback (most recent call last):
  File "/home/joe/PolyBotConversation/demo/manage.py", line 19, in <module>
    main()
  File "/home/joe/PolyBotConversation/demo/manage.py", line 15, in main
    execute_from_command_line(sys.argv)
  File "/home/joe/PolyBotConversation/demo/lib/python3.12/site-packages/django/core/management/__init__.py", line 442, in execute_from_command_line
    utility.execute()
  File "/home/joe/PolyBotConversation/demo/lib/python3.12/site-packages/django/core/management/__init__.py", line 436, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/home/joe/PolyBotConversation/demo/lib/python3.12/site-packages/django/core/management/base.py", line 413, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/home/joe/PolyBotConversation/demo/lib/python3.12/site-packages/django/core/management/base.py", line 459, in execute
    output = self.handle(*args, **options)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/joe/PolyBotConversation/demo/chat/management/commands/setup.py", line 20, in handle
    Trigger.objects.get_or_create(name=name)
  File "/home/joe/PolyBotConversation/demo/lib/python3.12/site-packages/django/db/models/manager.py", line 87, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/joe/PolyBotConversation/demo/lib/python3.12/site-packages/django/db/models/query.py", line 948, in get_or_create
    return self.get(**kwargs), False
           ^^^^^^^^^^^^^^^^^^
  File "/home/joe/PolyBotConversation/demo/lib/python3.12/site-packages/django/db/models/query.py", line 645, in get
    num = len(clone)
          ^^^^^^^^^^
  File "/home/joe/PolyBotConversation/demo/lib/python3.12/site-packages/django/db/models/query.py", line 382, in __len__
    self._fetch_all()
  File "/home/joe/PolyBotConversation/demo/lib/python3.12/site-packages/django/db/models/query.py", line 1928, in _fetch_all
    self._result_cache = list(self._iterable_class(self))
                         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/joe/PolyBotConversation/demo/lib/python3.12/site-packages/django/db/models/query.py", line 91, in __iter__
    results = compiler.execute_sql(
              ^^^^^^^^^^^^^^^^^^^^^
  File "/home/joe/PolyBotConversation/demo/lib/python3.12/site-packages/django/db/models/sql/compiler.py", line 1574, in execute_sql
    cursor.execute(sql, params)
  File "/home/joe/PolyBotConversation/demo/lib/python3.12/site-packages/django/db/backends/utils.py", line 122, in execute
    return super().execute(sql, params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/joe/PolyBotConversation/demo/lib/python3.12/site-packages/django/db/backends/utils.py", line 79, in execute
    return self._execute_with_wrappers(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/joe/PolyBotConversation/demo/lib/python3.12/site-packages/django/db/backends/utils.py", line 92, in _execute_with_wrappers
    return executor(sql, params, many, context)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/joe/PolyBotConversation/demo/lib/python3.12/site-packages/django/db/backends/utils.py", line 100, in _execute
    with self.db.wrap_database_errors:
  File "/home/joe/PolyBotConversation/demo/lib/python3.12/site-packages/django/db/utils.py", line 91, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/home/joe/PolyBotConversation/demo/lib/python3.12/site-packages/django/db/backends/utils.py", line 105, in _execute
    return self.cursor.execute(sql, params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/joe/PolyBotConversation/demo/lib/python3.12/site-packages/django/db/backends/sqlite3/base.py", line 354, in execute
    return super().execute(query, params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
django.db.utils.OperationalError: no such table: chat_trigger

[holtzermann17]

I thought, why not see if I can just press on with the next step in the instructions. This helped me get back on track, but it suggests that the README is missing a step!

$ ./bin/python manage.py runserver
Watching for file changes with StatReloader
Watching for file changes with StatReloader
Performing system checks...

System check identified no issues (0 silenced).

You have 38 unapplied migration(s). Your project may not work properly until you apply the migrations for app(s): admin, auth, chat, contenttypes, django_q, sessions.
Run 'python manage.py migrate' to apply them.
March 06, 2025 - 22:49:02
Django version 5.1.1, using settings 'PolyBotConversation.settings'
Starting development server at http://127.0.0.1:8000/
Quit the server with CONTROL-C.

  C-c C-c^Cjoe@Proteus:~/code/PolyBotConversation$ ./bin/python manage.py migrate
./bin/python manage.py migrate
...

The migrations run fine. However... I did get a different error now when I reran the original setup step!

[holtzermann17]

However, that error doesn't seem terribly consequential. Another needed step to use the webapp is:

./bin/python manage.py createsuperuser

So, with that I get it up and running, and can get in. However, when I try to create a chat, I run into another error:

Internal Server Error: /chat/new/
Traceback (most recent call last):
  File "/home/joe/code/PolyBotConversation/lib/python3.12/site-packages/django/core/handlers/exception.py", line 55, in inner
    response = get_response(request)
               ^^^^^^^^^^^^^^^^^^^^^
  File "/home/joe/code/PolyBotConversation/lib/python3.12/site-packages/django/core/handlers/base.py", line 197, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/joe/code/PolyBotConversation/lib/python3.12/site-packages/django/contrib/auth/decorators.py", line 60, in _view_wrapper
    return view_func(request, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/joe/code/PolyBotConversation/chat/views.py", line 31, in chat_new
    participant = Participant.objects.get(participant_type="user", user=request.user)
                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/joe/code/PolyBotConversation/lib/python3.12/site-packages/django/db/models/manager.py", line 87, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/joe/code/PolyBotConversation/lib/python3.12/site-packages/django/db/models/query.py", line 649, in get
    raise self.model.DoesNotExist(
chat.models.Participant.DoesNotExist: Participant matching query does not exist.