[GH-ISSUE #7029] Search fails with 500 Internal server error #53240

New Issue

Closed

opened 2026-05-05 14:28:47 -05:00 by GiteaMirror · 2 comments

GiteaMirror commented 2026-05-05 14:28:47 -05:00

Owner

Copy Link

Copy Source

Originally created by @jakerdy on GitHub (Nov 19, 2024).
Original GitHub issue: https://github.com/open-webui/open-webui/issues/7029

Bug Report

---

Installation Method

It works as python application without docker.

I just created venv, installed open_webui and setup systemd service so that it starts automatically.

Environment

• Open WebUI Version: v0.3.35
• Ollama (if applicable): 0.3.13
• Operating System: Ubuntu server 22.04.3
• Browser (if applicable): Chrome 130.0

Expected Behavior:

Search should work without errors.

Actual Behavior:

Browser shows 500 Error in Network tab of Dev-Tools. Console logged that fetch failed. In ui just infinitly spinning spinner, and nothing happens.

Description

Bug Summary:
I don't know what exactly breaks search but it not working for me. Maybe it some nasty characters in titles that returned from sketchy ollama models, maybe something else.

I also tried creating new user, that has no history. Made 2 new chats with OpenAI, that returns valid titles. But still, 500 Internal Server Error.

Logs and Screenshots

Browser Console Logs:

Python Server Logs:

ERROR:    Exception in ASGI application
Traceback (most recent call last):
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
    self.dialect.do_execute(
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 941, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: near ">>": syntax error
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/uvicorn/protocols/http/httptools_impl.py", line 401, in run_asgi
    result = await app(  # type: ignore[func-returns-value]
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/uvicorn/middleware/proxy_headers.py", line 70, in __call__
    return await self.app(scope, receive, send)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/fastapi/applications.py", line 1054, in __call__
    await super().__call__(scope, receive, send)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/applications.py", line 123, in __call__
    await self.middleware_stack(scope, receive, send)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/errors.py", line 186, in __call__
    raise exc
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/errors.py", line 164, in __call__
    await self.app(scope, receive, _send)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 189, in __call__
    with collapse_excgroups():
  File "/usr/lib/python3.11/contextlib.py", line 155, in __exit__
    self.gen.throw(typ, value, traceback)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_utils.py", line 93, in collapse_excgroups
    raise exc
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 261, in wrap
    await func()
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 217, in stream_response
    return await super().stream_response(send)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 250, in stream_response
    async for chunk in self.body_iterator:
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 181, in body_stream
    raise app_exc
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 151, in coro
    await self.app(scope, receive_or_disconnect, send_no_error)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 189, in __call__
    with collapse_excgroups():
  File "/usr/lib/python3.11/contextlib.py", line 155, in __exit__
    self.gen.throw(typ, value, traceback)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_utils.py", line 93, in collapse_excgroups
    raise exc
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 261, in wrap
    await func()
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 217, in stream_response
    return await super().stream_response(send)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 250, in stream_response
    async for chunk in self.body_iterator:
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 181, in body_stream
    raise app_exc
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 151, in coro
    await self.app(scope, receive_or_disconnect, send_no_error)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 189, in __call__
    with collapse_excgroups():
  File "/usr/lib/python3.11/contextlib.py", line 155, in __exit__
    self.gen.throw(typ, value, traceback)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_utils.py", line 93, in collapse_excgroups
    raise exc
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 261, in wrap
    await func()
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 217, in stream_response
    return await super().stream_response(send)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 250, in stream_response
    async for chunk in self.body_iterator:
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 181, in body_stream
    raise app_exc
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 151, in coro
    await self.app(scope, receive_or_disconnect, send_no_error)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 189, in __call__
    with collapse_excgroups():
  File "/usr/lib/python3.11/contextlib.py", line 155, in __exit__
    self.gen.throw(typ, value, traceback)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_utils.py", line 93, in collapse_excgroups
    raise exc
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 261, in wrap
    await func()
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 217, in stream_response
    return await super().stream_response(send)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 250, in stream_response
    async for chunk in self.body_iterator:
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 181, in body_stream
    raise app_exc
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 151, in coro
    await self.app(scope, receive_or_disconnect, send_no_error)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 189, in __call__
    with collapse_excgroups():
  File "/usr/lib/python3.11/contextlib.py", line 155, in __exit__
    self.gen.throw(typ, value, traceback)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_utils.py", line 93, in collapse_excgroups
    raise exc
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 261, in wrap
    await func()
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 217, in stream_response
    return await super().stream_response(send)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 250, in stream_response
    async for chunk in self.body_iterator:
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 181, in body_stream
    raise app_exc
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 151, in coro
    await self.app(scope, receive_or_disconnect, send_no_error)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/cors.py", line 85, in __call__
    await self.app(scope, receive, send)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 189, in __call__
    with collapse_excgroups():
  File "/usr/lib/python3.11/contextlib.py", line 155, in __exit__
    self.gen.throw(typ, value, traceback)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_utils.py", line 93, in collapse_excgroups
    raise exc
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 261, in wrap
    await func()
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 217, in stream_response
    return await super().stream_response(send)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 250, in stream_response
    async for chunk in self.body_iterator:
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 181, in body_stream
    raise app_exc
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 151, in coro
    await self.app(scope, receive_or_disconnect, send_no_error)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 189, in __call__
    with collapse_excgroups():
  File "/usr/lib/python3.11/contextlib.py", line 155, in __exit__
    self.gen.throw(typ, value, traceback)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_utils.py", line 93, in collapse_excgroups
    raise exc
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 261, in wrap
    await func()
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 217, in stream_response
    return await super().stream_response(send)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 250, in stream_response
    async for chunk in self.body_iterator:
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 181, in body_stream
    raise app_exc
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 151, in coro
    await self.app(scope, receive_or_disconnect, send_no_error)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 189, in __call__
    with collapse_excgroups():
  File "/usr/lib/python3.11/contextlib.py", line 155, in __exit__
    self.gen.throw(typ, value, traceback)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_utils.py", line 93, in collapse_excgroups
    raise exc
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 261, in wrap
    await func()
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 217, in stream_response
    return await super().stream_response(send)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 250, in stream_response
    async for chunk in self.body_iterator:
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 181, in body_stream
    raise app_exc
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 151, in coro
    await self.app(scope, receive_or_disconnect, send_no_error)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/exceptions.py", line 65, in __call__
    await wrap_app_handling_exceptions(self.app, conn)(scope, receive, send)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_exception_handler.py", line 64, in wrapped_app
    raise exc
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
    await app(scope, receive, sender)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/routing.py", line 756, in __call__
    await self.middleware_stack(scope, receive, send)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/routing.py", line 776, in app
    await route.handle(scope, receive, send)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/routing.py", line 485, in handle
    await self.app(scope, receive, send)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/fastapi/applications.py", line 1054, in __call__
    await super().__call__(scope, receive, send)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/applications.py", line 123, in __call__
    await self.middleware_stack(scope, receive, send)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/errors.py", line 186, in __call__
    raise exc
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/errors.py", line 164, in __call__
    await self.app(scope, receive, _send)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/cors.py", line 85, in __call__
    await self.app(scope, receive, send)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/exceptions.py", line 65, in __call__
    await wrap_app_handling_exceptions(self.app, conn)(scope, receive, send)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_exception_handler.py", line 64, in wrapped_app
    raise exc
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
    await app(scope, receive, sender)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/routing.py", line 756, in __call__
    await self.middleware_stack(scope, receive, send)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/routing.py", line 776, in app
    await route.handle(scope, receive, send)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/routing.py", line 297, in handle
    await self.app(scope, receive, send)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/routing.py", line 77, in app
    await wrap_app_handling_exceptions(app, request)(scope, receive, send)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_exception_handler.py", line 64, in wrapped_app
    raise exc
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
    await app(scope, receive, sender)
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/routing.py", line 72, in app
    response = await func(request)
               ^^^^^^^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/fastapi/routing.py", line 278, in app
    raw_response = await run_endpoint_function(
                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/fastapi/routing.py", line 191, in run_endpoint_function
    return await dependant.call(**values)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/open_webui/apps/webui/routers/chats.py", line 149, in search_user_chats
    for chat in Chats.get_chats_by_user_id_and_search_text(
                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/open_webui/apps/webui/models/chats.py", line 568, in get_chats_by_user_id_and_search_text
    all_chats = query.offset(skip).limit(limit).all()
                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2673, in all
    return self._iter().all()  # type: ignore
           ^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2827, in _iter
    result: Union[ScalarResult[_T], Result[_T]] = self.session.execute(
                                                  ^^^^^^^^^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2362, in execute
    return self._execute_internal(
           ^^^^^^^^^^^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2247, in _execute_internal
    result: Result[Any] = compile_state_cls.orm_execute_statement(
                          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/orm/context.py", line 293, in orm_execute_statement
    result = conn.execute(
             ^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1418, in execute
    return meth(
           ^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 515, in _execute_on_connection
    return connection._execute_clauseelement(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1640, in _execute_clauseelement
    ret = self._execute_context(
          ^^^^^^^^^^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
    return self._exec_single_context(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
    self._handle_dbapi_exception(
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
    self.dialect.do_execute(
  File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 941, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near ">>": syntax error
[SQL: SELECT chat.id AS chat_id, chat.user_id AS chat_user_id, chat.title AS chat_title, chat.chat AS chat_chat, chat.created_at AS chat_created_at, chat.updated_at AS chat_updated_at, chat.share_id AS chat_share_id, chat.archived AS chat_archived, chat.pinned AS chat_pinned, chat.meta AS chat_meta, chat.folder_id AS chat_folder_id
FROM chat
WHERE chat.user_id = ? AND chat.archived = 0 AND (lower(chat.title) LIKE lower(?) OR
                            EXISTS (
                                SELECT 1
                                FROM json_each(Chat.chat, '$.messages') AS message
                                WHERE LOWER(message.value->>'content') LIKE '%' || ? || '%'
                            )
                            ) ORDER BY chat.updated_at DESC
 LIMIT ? OFFSET ?]
[parameters: ('2d105115-89d8-4e58-9ed4-64279956c9b6', '%conver%', 'conver', 60, 0)]
(Background on this error at: https://sqlalche.me/e/20/e3q8)

Originally created by @jakerdy on GitHub (Nov 19, 2024). Original GitHub issue: https://github.com/open-webui/open-webui/issues/7029 # Bug Report --- ## Installation Method It works as python application without docker. I just created venv, installed open_webui and setup systemd service so that it starts automatically. ## Environment - **Open WebUI Version:** v0.3.35 - **Ollama (if applicable):** 0.3.13 - **Operating System:** Ubuntu server 22.04.3 - **Browser (if applicable):** Chrome 130.0 ## Expected Behavior: Search should work without errors. ## Actual Behavior: Browser shows 500 Error in Network tab of Dev-Tools. Console logged that fetch failed. In ui just infinitly spinning spinner, and nothing happens. ## Description **Bug Summary:** I don't know what exactly breaks search but it not working for me. Maybe it some nasty characters in titles that returned from sketchy ollama models, maybe something else. I also tried creating new user, that has no history. Made 2 new chats with OpenAI, that returns valid titles. But still, 500 Internal Server Error. ## Logs and Screenshots **Browser Console Logs:**  **Python Server Logs:** ``` ERROR: Exception in ASGI application Traceback (most recent call last): File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context self.dialect.do_execute( File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 941, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: near ">>": syntax error The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/uvicorn/protocols/http/httptools_impl.py", line 401, in run_asgi result = await app( # type: ignore[func-returns-value] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/uvicorn/middleware/proxy_headers.py", line 70, in __call__ return await self.app(scope, receive, send) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/fastapi/applications.py", line 1054, in __call__ await super().__call__(scope, receive, send) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/applications.py", line 123, in __call__ await self.middleware_stack(scope, receive, send) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/errors.py", line 186, in __call__ raise exc File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/errors.py", line 164, in __call__ await self.app(scope, receive, _send) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 189, in __call__ with collapse_excgroups(): File "/usr/lib/python3.11/contextlib.py", line 155, in __exit__ self.gen.throw(typ, value, traceback) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_utils.py", line 93, in collapse_excgroups raise exc File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 261, in wrap await func() File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 217, in stream_response return await super().stream_response(send) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 250, in stream_response async for chunk in self.body_iterator: File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 181, in body_stream raise app_exc File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 151, in coro await self.app(scope, receive_or_disconnect, send_no_error) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 189, in __call__ with collapse_excgroups(): File "/usr/lib/python3.11/contextlib.py", line 155, in __exit__ self.gen.throw(typ, value, traceback) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_utils.py", line 93, in collapse_excgroups raise exc File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 261, in wrap await func() File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 217, in stream_response return await super().stream_response(send) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 250, in stream_response async for chunk in self.body_iterator: File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 181, in body_stream raise app_exc File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 151, in coro await self.app(scope, receive_or_disconnect, send_no_error) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 189, in __call__ with collapse_excgroups(): File "/usr/lib/python3.11/contextlib.py", line 155, in __exit__ self.gen.throw(typ, value, traceback) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_utils.py", line 93, in collapse_excgroups raise exc File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 261, in wrap await func() File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 217, in stream_response return await super().stream_response(send) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 250, in stream_response async for chunk in self.body_iterator: File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 181, in body_stream raise app_exc File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 151, in coro await self.app(scope, receive_or_disconnect, send_no_error) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 189, in __call__ with collapse_excgroups(): File "/usr/lib/python3.11/contextlib.py", line 155, in __exit__ self.gen.throw(typ, value, traceback) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_utils.py", line 93, in collapse_excgroups raise exc File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 261, in wrap await func() File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 217, in stream_response return await super().stream_response(send) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 250, in stream_response async for chunk in self.body_iterator: File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 181, in body_stream raise app_exc File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 151, in coro await self.app(scope, receive_or_disconnect, send_no_error) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 189, in __call__ with collapse_excgroups(): File "/usr/lib/python3.11/contextlib.py", line 155, in __exit__ self.gen.throw(typ, value, traceback) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_utils.py", line 93, in collapse_excgroups raise exc File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 261, in wrap await func() File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 217, in stream_response return await super().stream_response(send) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 250, in stream_response async for chunk in self.body_iterator: File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 181, in body_stream raise app_exc File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 151, in coro await self.app(scope, receive_or_disconnect, send_no_error) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/cors.py", line 85, in __call__ await self.app(scope, receive, send) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 189, in __call__ with collapse_excgroups(): File "/usr/lib/python3.11/contextlib.py", line 155, in __exit__ self.gen.throw(typ, value, traceback) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_utils.py", line 93, in collapse_excgroups raise exc File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 261, in wrap await func() File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 217, in stream_response return await super().stream_response(send) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 250, in stream_response async for chunk in self.body_iterator: File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 181, in body_stream raise app_exc File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 151, in coro await self.app(scope, receive_or_disconnect, send_no_error) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 189, in __call__ with collapse_excgroups(): File "/usr/lib/python3.11/contextlib.py", line 155, in __exit__ self.gen.throw(typ, value, traceback) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_utils.py", line 93, in collapse_excgroups raise exc File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 261, in wrap await func() File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 217, in stream_response return await super().stream_response(send) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 250, in stream_response async for chunk in self.body_iterator: File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 181, in body_stream raise app_exc File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 151, in coro await self.app(scope, receive_or_disconnect, send_no_error) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 189, in __call__ with collapse_excgroups(): File "/usr/lib/python3.11/contextlib.py", line 155, in __exit__ self.gen.throw(typ, value, traceback) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_utils.py", line 93, in collapse_excgroups raise exc File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 261, in wrap await func() File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 217, in stream_response return await super().stream_response(send) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/responses.py", line 250, in stream_response async for chunk in self.body_iterator: File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 181, in body_stream raise app_exc File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/base.py", line 151, in coro await self.app(scope, receive_or_disconnect, send_no_error) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/exceptions.py", line 65, in __call__ await wrap_app_handling_exceptions(self.app, conn)(scope, receive, send) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_exception_handler.py", line 64, in wrapped_app raise exc File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app await app(scope, receive, sender) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/routing.py", line 756, in __call__ await self.middleware_stack(scope, receive, send) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/routing.py", line 776, in app await route.handle(scope, receive, send) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/routing.py", line 485, in handle await self.app(scope, receive, send) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/fastapi/applications.py", line 1054, in __call__ await super().__call__(scope, receive, send) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/applications.py", line 123, in __call__ await self.middleware_stack(scope, receive, send) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/errors.py", line 186, in __call__ raise exc File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/errors.py", line 164, in __call__ await self.app(scope, receive, _send) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/cors.py", line 85, in __call__ await self.app(scope, receive, send) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/middleware/exceptions.py", line 65, in __call__ await wrap_app_handling_exceptions(self.app, conn)(scope, receive, send) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_exception_handler.py", line 64, in wrapped_app raise exc File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app await app(scope, receive, sender) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/routing.py", line 756, in __call__ await self.middleware_stack(scope, receive, send) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/routing.py", line 776, in app await route.handle(scope, receive, send) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/routing.py", line 297, in handle await self.app(scope, receive, send) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/routing.py", line 77, in app await wrap_app_handling_exceptions(app, request)(scope, receive, send) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_exception_handler.py", line 64, in wrapped_app raise exc File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app await app(scope, receive, sender) File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/starlette/routing.py", line 72, in app response = await func(request) ^^^^^^^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/fastapi/routing.py", line 278, in app raw_response = await run_endpoint_function( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/fastapi/routing.py", line 191, in run_endpoint_function return await dependant.call(**values) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/open_webui/apps/webui/routers/chats.py", line 149, in search_user_chats for chat in Chats.get_chats_by_user_id_and_search_text( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/open_webui/apps/webui/models/chats.py", line 568, in get_chats_by_user_id_and_search_text all_chats = query.offset(skip).limit(limit).all() ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2673, in all return self._iter().all() # type: ignore ^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2827, in _iter result: Union[ScalarResult[_T], Result[_T]] = self.session.execute( ^^^^^^^^^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2362, in execute return self._execute_internal( ^^^^^^^^^^^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2247, in _execute_internal result: Result[Any] = compile_state_cls.orm_execute_statement( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/orm/context.py", line 293, in orm_execute_statement result = conn.execute( ^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1418, in execute return meth( ^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 515, in _execute_on_connection return connection._execute_clauseelement( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1640, in _execute_clauseelement ret = self._execute_context( ^^^^^^^^^^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context return self._exec_single_context( ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context self._handle_dbapi_exception( File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context self.dialect.do_execute( File "/mnt/ssd/sd/apps/open-webui/venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 941, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near ">>": syntax error [SQL: SELECT chat.id AS chat_id, chat.user_id AS chat_user_id, chat.title AS chat_title, chat.chat AS chat_chat, chat.created_at AS chat_created_at, chat.updated_at AS chat_updated_at, chat.share_id AS chat_share_id, chat.archived AS chat_archived, chat.pinned AS chat_pinned, chat.meta AS chat_meta, chat.folder_id AS chat_folder_id FROM chat WHERE chat.user_id = ? AND chat.archived = 0 AND (lower(chat.title) LIKE lower(?) OR EXISTS ( SELECT 1 FROM json_each(Chat.chat, '$.messages') AS message WHERE LOWER(message.value->>'content') LIKE '%' || ? || '%' ) ) ORDER BY chat.updated_at DESC LIMIT ? OFFSET ?] [parameters: ('2d105115-89d8-4e58-9ed4-64279956c9b6', '%conver%', 'conver', 60, 0)] (Background on this error at: https://sqlalche.me/e/20/e3q8) ```

GiteaMirror closed this issue 2026-05-05 14:28:48 -05:00

GiteaMirror commented 2026-05-05 14:28:50 -05:00

Author

Owner

Copy Link

Copy Source

@jakerdy commented on GitHub (Nov 19, 2024):

Some insights from ChatGPT:

The error you are encountering is due to the use of >> in your SQL query, which is not valid syntax for SQLite. In the query, this syntax is being used in the expression message.value->>'content' which is a PostgreSQL-specific operator for querying JSON data.

SQLite does not support the ->> operator. Instead, SQLite uses its own set of functions to work with JSON data. If you need to query JSON content in SQLite, you should use the json_extract() function.

Here’s how you can modify your query to be compatible with SQLite:

SELECT chat.id AS chat_id, chat.user_id AS chat_user_id, chat.title AS chat_title, 
       chat.chat AS chat_chat, chat.created_at AS chat_created_at, 
       chat.updated_at AS chat_updated_at, chat.share_id AS chat_share_id, 
       chat.archived AS chat_archived, chat.pinned AS chat_pinned, 
       chat.meta AS chat_meta, chat.folder_id AS chat_folder_id 
FROM chat 
WHERE chat.user_id = ? 
  AND chat.archived = 0 
  AND (
      lower(chat.title) LIKE lower(?) 
      OR EXISTS (
          SELECT 1 
          FROM json_each(chat.chat, '$.messages') AS message 
          WHERE LOWER(json_extract(message.value, '$.content')) 
          LIKE '%' || ? || '%'
      )
  ) 
ORDER BY chat.updated_at DESC  
LIMIT ? OFFSET ?

Explanation:

• Replace message.value->>'content' with json_extract(message.value, '$.content'). This function extracts the content of the JSON field content from message.value.

Points to Consider:

• Make sure that the JSON structure you're querying is correct and properly indexed, otherwise the performance might be affected.
• Double-check that all tables and JSON fields you're referencing do indeed exist and that their paths are correctly specified.
• SQLite's support for JSON is not as comprehensive as some other databases like PostgreSQL, so ensure that your data is modelled appropriately.

<!-- gh-comment-id:2485220899 --> @jakerdy commented on GitHub (Nov 19, 2024): Some insights from ChatGPT: The error you are encountering is due to the use of `>>` in your SQL query, which is not valid syntax for SQLite. In the query, this syntax is being used in the expression `message.value->>'content'` which is a PostgreSQL-specific operator for querying JSON data. SQLite does not support the `->>` operator. Instead, SQLite uses its own set of functions to work with JSON data. If you need to query JSON content in SQLite, you should use the `json_extract()` function. Here’s how you can modify your query to be compatible with SQLite: ```sql SELECT chat.id AS chat_id, chat.user_id AS chat_user_id, chat.title AS chat_title, chat.chat AS chat_chat, chat.created_at AS chat_created_at, chat.updated_at AS chat_updated_at, chat.share_id AS chat_share_id, chat.archived AS chat_archived, chat.pinned AS chat_pinned, chat.meta AS chat_meta, chat.folder_id AS chat_folder_id FROM chat WHERE chat.user_id = ? AND chat.archived = 0 AND ( lower(chat.title) LIKE lower(?) OR EXISTS ( SELECT 1 FROM json_each(chat.chat, '$.messages') AS message WHERE LOWER(json_extract(message.value, '$.content')) LIKE '%' || ? || '%' ) ) ORDER BY chat.updated_at DESC LIMIT ? OFFSET ? ``` **Explanation:** - Replace `message.value->>'content'` with `json_extract(message.value, '$.content')`. This function extracts the content of the JSON field `content` from `message.value`. **Points to Consider:** - Make sure that the JSON structure you're querying is correct and properly indexed, otherwise the performance might be affected. - Double-check that all tables and JSON fields you're referencing do indeed exist and that their paths are correctly specified. - SQLite's support for JSON is not as comprehensive as some other databases like PostgreSQL, so ensure that your data is modelled appropriately.

GiteaMirror commented 2026-05-05 14:28:52 -05:00

Author

Owner

Copy Link

Copy Source

@jakerdy commented on GitHub (Nov 19, 2024):

Ok, I found exact place where it breaks:
https://github.com/open-webui/open-webui/blob/96c865404d36637eafadb6d2dd2365c85d452648/backend/open_webui/apps/webui/models/chats.py#L477

I changed it from: WHERE LOWER(message.value->>'content') to WHERE LOWER(json_extract(message.value, '$.content')) and it stats working.

<!-- gh-comment-id:2485290151 --> @jakerdy commented on GitHub (Nov 19, 2024): Ok, I found exact place where it breaks: https://github.com/open-webui/open-webui/blob/96c865404d36637eafadb6d2dd2365c85d452648/backend/open_webui/apps/webui/models/chats.py#L477 I changed it from: `WHERE LOWER(message.value->>'content')` to `WHERE LOWER(json_extract(message.value, '$.content'))` and it stats working.

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

main

dev

v0.11.1

v0.11.0

v0.10.2

v0.10.1

v0.10.0

v0.9.6

v0.9.5

v0.9.4

v0.9.3

v0.9.2

v0.9.1

v0.9.0

v0.8.12

v0.8.11

v0.8.10

v0.8.9

v0.8.8

v0.8.7

v0.8.6

v0.8.5

v0.8.4

v0.8.3

v0.8.2

v0.8.1

v0.8.0

v0.7.2

v0.7.1

v0.7.0

v0.6.43

v0.6.42

v0.6.41

v0.6.40

v0.6.39

v0.6.38

v0.6.37

v0.6.36

v0.6.35

v0.6.34

v0.6.33

v0.6.32

v0.6.31

v0.6.30

v0.6.29

v0.6.28

v0.6.27

v0.6.26

v0.6.25

v0.6.24

v0.6.23

v0.6.22

v0.6.21

v0.6.20

v0.6.19

v0.6.18

v0.6.17

v0.6.16

v0.6.15

v0.6.14

v0.6.13

v0.6.12

v0.6.11

v0.6.10

v0.6.9

v0.6.8

v0.6.7

v0.6.6

v0.6.5

v0.6.4

v0.6.3

v0.6.2

v0.6.1

v0.6.0

v0.5.20

v0.5.19

v0.5.18

v0.5.17

v0.5.16

v0.5.15

v0.5.14

v0.5.13

v0.5.12

v0.5.11

v0.5.10

v0.5.9

v0.5.8

v0.5.7

v0.5.6

v0.5.5

v0.5.4

v0.5.3

v0.5.2

v0.5.1

v0.5.0

v0.4.8

v0.4.7

v0.4.6

v0.4.5

v0.4.4

v0.4.3

v0.4.2

v0.4.1

v0.4.0

v0.3.35

v0.3.34

v0.3.33

v0.3.32

v0.3.31

v0.3.30

v0.3.29

v0.3.28

v0.3.27

v0.3.26

v0.3.25

v0.3.24

v0.3.23

v0.3.22

v0.3.21

v0.3.20

v0.3.19

v0.3.18

v0.3.17

v0.3.16

v0.3.15

v0.3.14

v0.3.13

v0.3.12

v0.3.11

v0.3.10

v0.3.9

v0.3.8

v0.3.7

v0.3.6

v0.3.5

v0.3.4

v0.3.3

v0.3.2

v0.3.1

v0.3.0

v0.2.5

v0.2.4

v0.2.3

v0.2.2

v0.2.1

v0.2.0

v0.1.125

v0.1.124

v0.1.123

v0.1.122

v0.1.121

v0.1.120

v0.1.119

v0.1.118

v0.1.117

v0.1.116

v0.1.115

v0.1.114

v0.1.113

v0.1.112

v0.1.111

v0.1.110

v0.1.109

v0.1.108

v0.1.107

v0.1.106

v0.1.105

v0.1.104

v0.1.103

v0.1.102

Labels

Clear labels

bug

confirmed

confirmed issue

core

documentation

enhancement

good first issue

help wanted

non-core

pull-request

Mirrored from GitHub Pull Request

python

question

testing wanted

No labels

Milestone

No items

No Milestone

Projects

Clear projects

No projects

Assignees

Clear assignees

GiteaMirror ninjasurge (Kaehlen Rog)

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/open-webui#53240