issue: SQLite Note Table Error on Fresh Installation #5046

New Issue

GiteaMirror · 2025-11-11T16:10:37-06:00

GiteaMirror commented

2025-11-11 16:10:37 -06:00

Originally created by @manwallet on GitHub (May 5, 2025).

Check Existing Issues

I have searched the existing issues and discussions.
I am using the latest version of Open WebUI.

Installation Method

Git Clone

Open WebUI Version

v0.6.6

Ollama Version (if applicable)

No response

Operating System

docker 27.5.1 macos 15.5

Browser (if applicable)

No response

Confirmation

I have read and followed all instructions in README.md.
I am using the latest version of both Open WebUI and Ollama.
I have included the browser console logs.
I have included the Docker container logs.
I have listed steps to reproduce the bug in detail.

Expected Behavior

The Notes feature should work properly when accessing it from the sidebar menu.

Actual Behavior

When attempting to access the Notes feature, the application throws a SQLite database error indicating that the "note" table does not exist:
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: note [SQL: SELECT note.id AS note_id, note.user_id AS note_user_id, note.title AS note_title, note.data AS note_data, note.meta AS note_meta, note.access_control AS note_access_control, note.created_at AS note_created_at, note.updated_at AS note_updated_at FROM note ORDER BY note.updated_at DESC] (Background on this error at: https://sqlalche.me/e/20/e3q8)

Steps to Reproduce

Log in to the application
Navigate to the Notes section from the sidebar menu
Observe the SQLite error in the logs

Logs & Screenshots

File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1983, in _exec_single_context self._handle_dbapi_exception( File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2352, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context self.dialect.do_execute( File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 942, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: note [SQL: SELECT note.id AS note_id, note.user_id AS note_user_id, note.title AS note_title, note.data AS note_data, note.meta AS note_meta, note.access_control AS note_access_control, note.created_at AS note_created_at, note.updated_at AS note_updated_at FROM note ORDER BY note.updated_at DESC] (Background on this error at: https://sqlalche.me/e/20/e3q8)

Additional Information

Originally created by @manwallet on GitHub (May 5, 2025). ### Check Existing Issues - [x] I have searched the existing issues and discussions. - [x] I am using the latest version of Open WebUI. ### Installation Method Git Clone ### Open WebUI Version v0.6.6 ### Ollama Version (if applicable) _No response_ ### Operating System docker 27.5.1 macos 15.5 ### Browser (if applicable) _No response_ ### Confirmation - [x] I have read and followed all instructions in `README.md`. - [x] I am using the latest version of **both** Open WebUI and Ollama. - [x] I have included the browser console logs. - [x] I have included the Docker container logs. - [x] I have listed steps to reproduce the bug in detail. ### Expected Behavior The Notes feature should work properly when accessing it from the sidebar menu. ### Actual Behavior When attempting to access the Notes feature, the application throws a SQLite database error indicating that the "note" table does not exist: `sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: note [SQL: SELECT note.id AS note_id, note.user_id AS note_user_id, note.title AS note_title, note.data AS note_data, note.meta AS note_meta, note.access_control AS note_access_control, note.created_at AS note_created_at, note.updated_at AS note_updated_at FROM note ORDER BY note.updated_at DESC] (Background on this error at: https://sqlalche.me/e/20/e3q8)` ### Steps to Reproduce Log in to the application Navigate to the Notes section from the sidebar menu Observe the SQLite error in the logs ### Logs & Screenshots `File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1983, in _exec_single_context self._handle_dbapi_exception( File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2352, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context self.dialect.do_execute( File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 942, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: note [SQL: SELECT note.id AS note_id, note.user_id AS note_user_id, note.title AS note_title, note.data AS note_data, note.meta AS note_meta, note.access_control AS note_access_control, note.created_at AS note_created_at, note.updated_at AS note_updated_at FROM note ORDER BY note.updated_at DESC] (Background on this error at: https://sqlalche.me/e/20/e3q8)` ### Additional Information

GiteaMirror added the bug label 2025-11-11 16:10:37 -06:00

GiteaMirror closed this issue

2025-11-11 16:10:37 -06:00

GiteaMirror commented

2025-11-11 16:10:38 -06:00

@tjbck commented on GitHub (May 6, 2025):

We can't seem to reproduce, keep us updated!

@tjbck commented on GitHub (May 6, 2025): We can't seem to reproduce, keep us updated!

GiteaMirror referenced this issue

2026-04-19 20:25:35 -05:00

[GH-ISSUE #5046] Feature Req: Web Search URL shortcut #13841

GiteaMirror referenced this issue