Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL errors after opening user settings #1009

Open
Kolatzek opened this issue Feb 4, 2025 · 0 comments
Open

SQL errors after opening user settings #1009

Kolatzek opened this issue Feb 4, 2025 · 0 comments

Comments

@Kolatzek
Copy link

Kolatzek commented Feb 4, 2025

strange behaviour after clicking on "User settings"
Shows nothing in frontend but an SQL issue in Background

To Reproduce
Steps to reproduce the behavior:

  1. Go to 'Prefereces'
  2. Click on 'user settings' in 'chatbot, prompt...'
  3. See error

showing settings page
there are no settings to set. But after that click many things are strange in the gui: Help -> about will not open. In console will be repeated still the same

2025-02-04 21:03:26,407 - AI Runner - DEBUG - main_window.py - closeEvent - 647 - Quitting
2025-02-04 21:03:26,407 - AI Runner - DEBUG - main_window.py - save_state - 766 - Saving window state
Traceback (most recent call last):
  File "airunner/windows/main/main_window.py", line 648, in closeEvent
  File "airunner/windows/main/main_window.py", line 768, in save_state
  File "airunner/windows/main/settings_mixin.py", line 669, in save_window_settings
  File "airunner/windows/main/settings_mixin.py", line 286, in window_settings
  File "airunner/windows/main/settings_mixin.py", line 666, in load_window_settings
  File "sqlalchemy/orm/query.py", line 2754, in first
  File "sqlalchemy/orm/query.py", line 2853, in _iter
  File "sqlalchemy/orm/session.py", line 2365, in execute
  File "sqlalchemy/orm/session.py", line 2241, in _execute_internal
  File "sqlalchemy/orm/session.py", line 2110, in _connection_for_bind
  File "<string>", line 2, in _connection_for_bind
  File "sqlalchemy/orm/state_changes.py", line 103, in _go
  File "sqlalchemy/orm/session.py", line 973, in _raise_for_prerequisite_state
sqlalchemy.exc.PendingRollbackError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (sqlite3.IntegrityError) NOT NULL constraint failed: users.username
[SQL: INSERT INTO users (username) VALUES (?)]
[parameters: (None,)]
(Background on this error at: https://sqlalche.me/e/20/gkpj) (Background on this error at: https://sqlalche.me/e/20/7s2a)

and after closing this app you can read there

QThread: Destroyed while thread is still running
Abgebrochen (Speicherabzug geschrieben)

which means core dump

Screenshots
not applicable

Desktop:

  • OS: "Ubuntu 24.04.1 LTS"
  • Version: the latest version of ai-runner-ubuntu.zip

Hints for other problems

  • something ist missing by python
controlnet_aux/mediapipe_face/mediapipe_face_common.py:7: UserWarning: The module 'mediapipe' is not installed. The package will have limited functionality. Please install it using the command: pip install 'mediapipe'
  • Installation of "espeak-data:amd64" from ubuntu repository sould help any people with TTS errors (a requirement to OS side)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants
@Kolatzek and others