Error 1305: FUNCTION gitea.strftime does not exist #3781

New Issue

GiteaMirror · 2025-11-02T05:25:05-06:00

GiteaMirror commented

2025-11-02 05:25:05 -06:00

Originally created by @ramlev on GitHub (Aug 14, 2019).

Gitea version (or commit ref): 1.9.0 built with GNU Make 4.2.1, go1.12.7 : bindata, sqlite, sqlite_unlock_notify
Git version:2.22.0
Operating system: docker and the image: gitea/gitea:1.9
Database (use [x]):
- PostgreSQL
- [x ] MySQL (mariadb)
- MSSQL
- SQLite
Can you reproduce the bug at https://try.gitea.io:
- Yes (provide example URL)
- [x ] No
- Not relevant
Log gist:

Description

When logging in, the heatmap keeps loading, and if i try the endpoint through the Swagger API, i get this response

{
"message": "Error 1305: FUNCTION gitea.strftime does not exist",
"url": "https://my.host.com/api/swagger"
}

Originally created by @ramlev on GitHub (Aug 14, 2019). - Gitea version (or commit ref): 1.9.0 built with GNU Make 4.2.1, go1.12.7 : bindata, sqlite, sqlite_unlock_notify - Git version:2.22.0 - Operating system: docker and the image: gitea/gitea:1.9 - Database (use `[x]`): - [ ] PostgreSQL - [x ] MySQL (mariadb) - [ ] MSSQL - [ ] SQLite - Can you reproduce the bug at https://try.gitea.io: - [ ] Yes (provide example URL) - [x ] No - [ ] Not relevant - Log gist: ## Description When logging in, the heatmap keeps loading, and if i try the endpoint through the Swagger API, i get this response { "message": "Error 1305: FUNCTION gitea.strftime does not exist", "url": "https://my.host.com/api/swagger" }

GiteaMirror closed this issue

2025-11-02 05:25:05 -06:00

GiteaMirror commented

2025-11-02 05:25:06 -06:00

@jolheiser commented on GitHub (Aug 14, 2019):

Did you change your database settings without a restart?
That error is Gitea trying to run a SQLite function in the DB.
c42bde719e/models/user_heatmap.go (L25)

@jolheiser commented on GitHub (Aug 14, 2019): Did you change your database settings without a restart? That error is Gitea trying to run a SQLite function in the DB. https://github.com/go-gitea/gitea/blob/c42bde719ecf2dd8757453bed18e082d14c1d3fa/models/user_heatmap.go#L25

GiteaMirror commented

2025-11-02 05:25:06 -06:00

@ramlev commented on GitHub (Aug 14, 2019):

/close

Docker container restart, and everything works.

@ramlev commented on GitHub (Aug 14, 2019): /close Docker container restart, and everything works.

GiteaMirror referenced this issue

2025-11-02 12:25:52 -06:00

[PR #3781] [MERGED] Fix typo in deleteUser #17081

GiteaMirror referenced this issue

2025-11-02 12:25:53 -06:00

[PR #3783] [MERGED] Fix typo in deleteUser (#3781) #17082