github-starred/open-webui
2
0
Fork 0
mirror of https://github.com/open-webui/open-webui.git synced 2026-05-06 10:58:17 -05:00
Code Issues 1.3k Packages Projects Releases 126 Wiki Activity

[GH-ISSUE #20728] issue: Problem installing from pip #57941

New Issue
Closed
opened 2026-05-05 21:59:21 -05:00 by GiteaMirror · 1 comment
GiteaMirror commented 2026-05-05 21:59:21 -05:00
Owner
Copy Link

Originally created by @bhecquet on GitHub (Jan 16, 2026).
Original GitHub issue: https://github.com/open-webui/open-webui/issues/20728

Check Existing Issues

  • I have searched for any existing and/or related issues.
  • I have searched for any existing and/or related discussions.
  • I have also searched in the CLOSED issues AND CLOSED discussions and found no related items (your issue might already be addressed on the development branch!).
  • I am using the latest version of Open WebUI.

Installation Method

Pip Install

Open WebUI Version

0.7.2

Ollama Version (if applicable)

No response

Operating System

RHE8

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 provided every relevant configuration, setting, and environment variable used in my setup.
  • I have clearly listed every relevant configuration, custom setting, environment variable, and command-line option that influences my setup (such as Docker Compose overrides, .env values, browser settings, authentication configurations, etc).
  • I have documented step-by-step reproduction instructions that are precise, sequential, and leave nothing to interpretation. My steps:
  • Start with the initial platform/version/OS and dependencies used,
  • Specify exact install/launch/configure commands,
  • List URLs visited, user input (incl. example values/emails/passwords if needed),
  • Describe all options and toggles enabled or changed,
  • Include any files or environmental changes,
  • Identify the expected and actual result at each stage,
  • Ensure any reasonably skilled user can follow and hit the same issue.

Expected Behavior

Hello

I'm installing open-webui on linux RHE8 with pip
I did the pip install procedure which finished correctly => version 0.7.2 installed
Then, I wanted to start open-webui using "open-webui server"

I expect open-webui starts

Actual Behavior

At that point, open-webui creates the SQLite database and applies migrations and fails during migration
I've identified 3 failures

/migrations/versions/242a2047eae0_update_chat_table.py
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near "DROP": syntax error [SQL: ALTER TABLE chat DROP COLUMN old_chat]

/migrations/versions/2f1211949ecc_update_message_and_channel_member_table.py
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) Cannot add a NOT NULL column with default value NULL [SQL: ALTER TABLE channel_member ADD COLUMN joined_at BIGINT NOT NULL]

/migrations/versions/b10670c03dd5_update_user_table.py
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near "DROP": syntax error [SQL: ALTER TABLE user DROP COLUMN info]

Steps to Reproduce

I starts from scratch on RHE 8.10
create venv with python 3.11
install open-webui with pip install open-webui
install pysqlite3-binary so that sqlite version is correct
start open-webui

Logs & Screenshots

/migrations/versions/242a2047eae0_update_chat_table.py
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near "DROP": syntax error [SQL: ALTER TABLE chat DROP COLUMN old_chat]

/migrations/versions/2f1211949ecc_update_message_and_channel_member_table.py
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) Cannot add a NOT NULL column with default value NULL [SQL: ALTER TABLE channel_member ADD COLUMN joined_at BIGINT NOT NULL]

/migrations/versions/b10670c03dd5_update_user_table.py
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near "DROP": syntax error [SQL: ALTER TABLE user DROP COLUMN info]

Additional Information

To allow starting, I had to modifiy the 3 migrations files

/migrations/versions/242a2047eae0_update_chat_table.py
op.drop_column("chat", "old_chat")
becomes

with op.batch_alter_table("chat") as batch_op:
    batch_op.drop_column('old_chat')

/migrations/versions/2f1211949ecc_update_message_and_channel_member_table.py

op.add_column(
        "channel_member", sa.Column("joined_at", sa.BigInteger(), nullable=False)
    )

becomes

op.add_column(
        "channel_member", sa.Column("joined_at", sa.BigInteger(), nullable=True)
    )

/migrations/versions/b10670c03dd5_update_user_table.py
op.drop_column(table, column)
becomes

 with op.batch_alter_table(table) as batch_op:
            batch_op.drop_column(column)

Thanks

Originally created by @bhecquet on GitHub (Jan 16, 2026). Original GitHub issue: https://github.com/open-webui/open-webui/issues/20728 ### Check Existing Issues - [x] I have searched for any existing and/or related issues. - [x] I have searched for any existing and/or related discussions. - [x] I have also searched in the CLOSED issues AND CLOSED discussions and found no related items (your issue might already be addressed on the development branch!). - [x] I am using the latest version of Open WebUI. ### Installation Method Pip Install ### Open WebUI Version 0.7.2 ### Ollama Version (if applicable) _No response_ ### Operating System RHE8 ### 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 **provided every relevant configuration, setting, and environment variable used in my setup.** - [x] I have clearly **listed every relevant configuration, custom setting, environment variable, and command-line option that influences my setup** (such as Docker Compose overrides, .env values, browser settings, authentication configurations, etc). - [x] I have documented **step-by-step reproduction instructions that are precise, sequential, and leave nothing to interpretation**. My steps: - Start with the initial platform/version/OS and dependencies used, - Specify exact install/launch/configure commands, - List URLs visited, user input (incl. example values/emails/passwords if needed), - Describe all options and toggles enabled or changed, - Include any files or environmental changes, - Identify the expected and actual result at each stage, - Ensure any reasonably skilled user can follow and hit the same issue. ### Expected Behavior Hello I'm installing open-webui on linux RHE8 with pip I did the pip install procedure which finished correctly => version 0.7.2 installed Then, I wanted to start open-webui using "open-webui server" I expect open-webui starts ### Actual Behavior At that point, open-webui creates the SQLite database and applies migrations and fails during migration I've identified 3 failures /migrations/versions/242a2047eae0_update_chat_table.py `sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near "DROP": syntax error [SQL: ALTER TABLE chat DROP COLUMN old_chat]` /migrations/versions/2f1211949ecc_update_message_and_channel_member_table.py `sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) Cannot add a NOT NULL column with default value NULL [SQL: ALTER TABLE channel_member ADD COLUMN joined_at BIGINT NOT NULL]` /migrations/versions/b10670c03dd5_update_user_table.py `sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near "DROP": syntax error [SQL: ALTER TABLE user DROP COLUMN info]` ### Steps to Reproduce I starts from scratch on RHE 8.10 create venv with python 3.11 install open-webui with `pip install open-webui` install pysqlite3-binary so that sqlite version is correct start open-webui ### Logs & Screenshots /migrations/versions/242a2047eae0_update_chat_table.py `sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near "DROP": syntax error [SQL: ALTER TABLE chat DROP COLUMN old_chat]` /migrations/versions/2f1211949ecc_update_message_and_channel_member_table.py `sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) Cannot add a NOT NULL column with default value NULL [SQL: ALTER TABLE channel_member ADD COLUMN joined_at BIGINT NOT NULL]` /migrations/versions/b10670c03dd5_update_user_table.py `sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near "DROP": syntax error [SQL: ALTER TABLE user DROP COLUMN info]` ### Additional Information To allow starting, I had to modifiy the 3 migrations files /migrations/versions/242a2047eae0_update_chat_table.py `op.drop_column("chat", "old_chat")` becomes ``` with op.batch_alter_table("chat") as batch_op: batch_op.drop_column('old_chat') ``` /migrations/versions/2f1211949ecc_update_message_and_channel_member_table.py ``` op.add_column( "channel_member", sa.Column("joined_at", sa.BigInteger(), nullable=False) ) ``` becomes ``` op.add_column( "channel_member", sa.Column("joined_at", sa.BigInteger(), nullable=True) ) ``` /migrations/versions/b10670c03dd5_update_user_table.py `op.drop_column(table, column)` becomes ``` with op.batch_alter_table(table) as batch_op: batch_op.drop_column(column) ``` Thanks
GiteaMirror added the bug label 2026-05-05 21:59:22 -05:00
GiteaMirror commented 2026-05-05 21:59:29 -05:00
Author
Owner
Copy Link

@owui-terminator[bot] commented on GitHub (Jan 16, 2026):

🔍 Similar Issues Found

I found some existing issues that might be related to this one. Please check if any of these are duplicates or contain helpful solutions:

  1. #20682 issue: pip error pymilvus grpcio with 0.7.2
    by dromeuf • Jan 15, 2026 • bug

  2. #16066 issue: Fails to pip install
    by SolshineCode • Jul 27, 2025 • bug

  3. #20117 issue: pip install -U open-webui[all] installs old version, but not pip install -U open-webui
    by Sly777 • Dec 22, 2025 • bug

  4. #16190 issue: stuck installing
    by ShellieKoala • Jul 31, 2025 • bug

  5. #16444 issue: bug with pip install open-webui
    by sahara12352 • Aug 10, 2025 • bug

Show 5 more related issues

  1. #20037 issue: Error Installing on Debian 12
    by luizgsbraz • Dec 19, 2025 • bug

  2. #16189 issue: pip not working on ubuntu
    by si-open • Jul 31, 2025 • bug

  3. #15878 issue: Cannot pip update to latest version
    by iChristGit • Jul 19, 2025 • bug

  4. #14873 issue: ERROR: No matching distribution found for open-webui
    by pleabargain • Jun 11, 2025 • bug

  5. #20086 issue: Update & New Install fails | ModuleNotFoundError: No module named 'langchain_classic'
    by averageaidude • Dec 22, 2025 • bug

💡 Tips:

  • If this is a duplicate, please consider closing this issue and adding any additional details to the existing one
  • If you found a solution in any of these issues, please share it here to help others

This comment was generated automatically by a bot. Please react with a 👍 if this comment was helpful, or a 👎 if it was not.

<!-- gh-comment-id:3760210921 --> @owui-terminator[bot] commented on GitHub (Jan 16, 2026): 🔍 **Similar Issues Found** I found some existing issues that might be related to this one. Please check if any of these are duplicates or contain helpful solutions: 1. [#20682](https://github.com/open-webui/open-webui/issues/20682) **issue: pip error pymilvus grpcio with 0.7.2** *by dromeuf • Jan 15, 2026 • `bug`* 2. [#16066](https://github.com/open-webui/open-webui/issues/16066) **issue: Fails to pip install** *by SolshineCode • Jul 27, 2025 • `bug`* 3. [#20117](https://github.com/open-webui/open-webui/issues/20117) **issue: `pip install -U open-webui[all]` installs old version, but not `pip install -U open-webui`** *by Sly777 • Dec 22, 2025 • `bug`* 4. [#16190](https://github.com/open-webui/open-webui/issues/16190) **issue: stuck installing** *by ShellieKoala • Jul 31, 2025 • `bug`* 5. [#16444](https://github.com/open-webui/open-webui/issues/16444) **issue: bug with pip install open-webui** *by sahara12352 • Aug 10, 2025 • `bug`* <details> <summary>Show 5 more related issues</summary> 6. [#20037](https://github.com/open-webui/open-webui/issues/20037) **issue: Error Installing on Debian 12** *by luizgsbraz • Dec 19, 2025 • `bug`* 7. [#16189](https://github.com/open-webui/open-webui/issues/16189) **issue: pip not working on ubuntu** *by si-open • Jul 31, 2025 • `bug`* 8. [#15878](https://github.com/open-webui/open-webui/issues/15878) **issue: Cannot pip update to latest version** *by iChristGit • Jul 19, 2025 • `bug`* 9. [#14873](https://github.com/open-webui/open-webui/issues/14873) **issue: ERROR: No matching distribution found for open-webui** *by pleabargain • Jun 11, 2025 • `bug`* 10. [#20086](https://github.com/open-webui/open-webui/issues/20086) **issue: Update & New Install fails | ModuleNotFoundError: No module named 'langchain_classic'** *by averageaidude • Dec 22, 2025 • `bug`* </details> --- 💡 **Tips:** - If this is a duplicate, please consider closing this issue and adding any additional details to the existing one - If you found a solution in any of these issues, please share it here to help others *This comment was generated automatically by a bot.* Please react with a 👍 if this comment was helpful, or a 👎 if it was not.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
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 Label bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/open-webui#57941
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?