[PR #2311] [CLOSED] fix: migrations 007_add_user_last_active_at syntax error #7753

New Issue

GiteaMirror · 2025-11-11T17:34:59-06:00

GiteaMirror commented

2025-11-11 17:34:59 -06:00

📋 Pull Request Information

Original PR: https://github.com/open-webui/open-webui/pull/2311
Author: @sinute
Created: 5/16/2024
Status: ❌ Closed

Base: dev ← Head: fix-migrations-007_add_user_last_active_at

📝 Commits (1)

e537651 fix: migrations 007_add_user_last_active_at syntax error

📊 Changes

1 file changed (+2 additions, -2 deletions)

View changed files

📝 backend/apps/web/internal/migrations/007_add_user_last_active_at.py (+2 -2)

📄 Description

Pull Request Checklist

Target branch: Pull requests should target the dev branch.
Description: Briefly describe the changes in this pull request.
Changelog: Ensure a changelog entry following the format of Keep a Changelog is added at the bottom of the PR description.
Documentation: Have you updated relevant documentation Open WebUI Docs, or other documentation sources?
Dependencies: Are there any new dependencies? Have you updated the dependency versions in the documentation?
Testing: Have you written and run sufficient tests for the changes?
Code Review: Have you self-reviewed your code and addressed any coding standard issues?

Description

fix migrations(007_add_user_last_active_at) syntax error in mysql

when i want to run a clean installation with mysql (DATABASE_URL=mysql://xxxxx) , got an syntax error

Migration failed: 007_add_user_last_active_at

pymysql.err.ProgrammingError: (1064, 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'"user" SET created_at = timestamp, updated_at = timestamp, last_active_at = time\' at line 1')

but i found an fix here, changed from the right to incorrect

so im not sure if will be some side effects to restore it :(

Changelog Entry

Fixed

Syntax error in 007_add_user_last_active_at

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/open-webui/open-webui/pull/2311 **Author:** [@sinute](https://github.com/sinute) **Created:** 5/16/2024 **Status:** ❌ Closed **Base:** `dev` ← **Head:** `fix-migrations-007_add_user_last_active_at` --- ### 📝 Commits (1) - [`e537651`](https://github.com/open-webui/open-webui/commit/e537651809e4de1ce13851db899d5f379aad7b17) fix: migrations 007_add_user_last_active_at syntax error ### 📊 Changes **1 file changed** (+2 additions, -2 deletions) <details> <summary>View changed files</summary> 📝 `backend/apps/web/internal/migrations/007_add_user_last_active_at.py` (+2 -2) </details> ### 📄 Description ## Pull Request Checklist - [x] **Target branch:** Pull requests should target the `dev` branch. - [x] **Description:** Briefly describe the changes in this pull request. - [x] **Changelog:** Ensure a changelog entry following the format of [Keep a Changelog](https://keepachangelog.com/) is added at the bottom of the PR description. - [ ] **Documentation:** Have you updated relevant documentation [Open WebUI Docs](https://github.com/open-webui/docs), or other documentation sources? - [ ] **Dependencies:** Are there any new dependencies? Have you updated the dependency versions in the documentation? - [ ] **Testing:** Have you written and run sufficient tests for the changes? - [ ] **Code Review:** Have you self-reviewed your code and addressed any coding standard issues? --- ## Description fix migrations(007_add_user_last_active_at) syntax error in mysql when i want to run a clean installation with mysql (DATABASE_URL=mysql://xxxxx) , got an syntax error ``` Migration failed: 007_add_user_last_active_at pymysql.err.ProgrammingError: (1064, 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'"user" SET created_at = timestamp, updated_at = timestamp, last_active_at = time\' at line 1') ``` > but i found an [fix](https://github.com/open-webui/open-webui/commit/71a75bccf5e177815d711a102790252139e30d24) here, changed from the right to incorrect > > so im not sure if will be some side effects to restore it :( --- ### Changelog Entry ### Fixed - Syntax error in 007_add_user_last_active_at --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>

GiteaMirror added the pull-request label 2025-11-11 17:34:59 -06:00

GiteaMirror closed this issue

2025-11-11 17:34:59 -06:00

GiteaMirror referenced this issue

2026-04-19 21:07:56 -05:00

[GH-ISSUE #7753] Docker cannot find the URL to "pull" the image #14875

GiteaMirror referenced this issue

2026-04-25 04:37:05 -05:00

[GH-ISSUE #7753] Docker cannot find the URL to "pull" the image #30403

GiteaMirror referenced this issue

2026-05-05 14:52:48 -05:00

[GH-ISSUE #7753] Docker cannot find the URL to "pull" the image #53541