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>
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
📋 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)
e537651fix: 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
devbranch.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
Changelog Entry
Fixed
🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.