[GH-ISSUE #1284] SQLSTATE[HY000]: General error: 8 attempt to write a readonly database #737

Closed
opened 2026-02-26 02:34:08 +03:00 by kerem · 2 comments
Owner

Originally created by @ghost on GitHub (Feb 24, 2021).
Original GitHub issue: https://github.com/koel/koel/issues/1284

Describe the bug
When I change the artist name / song name / album or any other metadata via the webinterface and I click "Update", the dialog disappears, the processing animation appears but then the dialog pops up again and the information is left unchanged.

When inspecting with the browser console, it reveals the following error:

Uncaught (in promise) Error: Request failed with status code 500
    exports https://music.filiuspatris.net/js/app.js?id=c628ace5c58f1b8a5ab7:2
    exports https://music.filiuspatris.net/js/app.js?id=c628ace5c58f1b8a5ab7:2
    onreadystatechange https://music.filiuspatris.net/js/app.js?id=c628ace5c58f1b8a5ab7:2

And the nginx reverse proxy logs this request: (I have the nginx configuration recommended by Laravel with some additions from the example)

10.0.0.11 - - [24/Feb/2021:10:16:48 +0100] "PUT /api/songs HTTP/1.1" 500 14047 "https://music.filiuspatris.net/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:85.0) Gecko/20100101 Firefox/85.0"

To reproduce
Steps to reproduce the behavior:

  1. Go to 'All Songs'
  2. Click on 'Edit'
  3. Edit the metadata and click update
  4. Don't see error, but also don't see updated informations

Expected behavior
After the processing animation the dialog disappears and the information is changed.

Environment

  • Koel version: v5.0.2
  • OS: Arch Linux
  • Browser: Firefox 85
  • PHP version: 8.0.2
  • Node version: v15.9.0

I'll be happy to provide any additional infos!

Originally created by @ghost on GitHub (Feb 24, 2021). Original GitHub issue: https://github.com/koel/koel/issues/1284 **Describe the bug** When I change the artist name / song name / album or any other metadata via the webinterface and I click "Update", the dialog disappears, the processing animation appears but then the dialog pops up again and the information is left unchanged. When inspecting with the browser console, it reveals the following error: ``` Uncaught (in promise) Error: Request failed with status code 500 exports https://music.filiuspatris.net/js/app.js?id=c628ace5c58f1b8a5ab7:2 exports https://music.filiuspatris.net/js/app.js?id=c628ace5c58f1b8a5ab7:2 onreadystatechange https://music.filiuspatris.net/js/app.js?id=c628ace5c58f1b8a5ab7:2 ``` And the nginx reverse proxy logs this request: (I have the nginx configuration recommended by [Laravel](https://laravel.com/docs/8.x/deployment#nginx) with some additions from the example) ``` 10.0.0.11 - - [24/Feb/2021:10:16:48 +0100] "PUT /api/songs HTTP/1.1" 500 14047 "https://music.filiuspatris.net/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:85.0) Gecko/20100101 Firefox/85.0" ``` **To reproduce** Steps to reproduce the behavior: 1. Go to 'All Songs' 2. Click on 'Edit' 3. Edit the metadata and click update 4. Don't see error, but also don't see updated informations **Expected behavior** After the processing animation the dialog disappears and the information is changed. **Environment** - Koel version: v5.0.2 - OS: Arch Linux - Browser: Firefox 85 - PHP version: 8.0.2 - Node version: v15.9.0 I'll be happy to provide any additional infos!
kerem closed this issue 2026-02-26 02:34:08 +03:00
Author
Owner

@ghost commented on GitHub (Feb 25, 2021):

I'm quite sure now after some testing that it has to do with the passing of the nginx proxy, because hosting with php artisan serve works.

I'll close, since it's outside the scope of this repo but I will keep this issue updated when I find the solution, for others.

<!-- gh-comment-id:786310562 --> @ghost commented on GitHub (Feb 25, 2021): I'm quite sure now after some testing that it has to do with the passing of the nginx proxy, because hosting with `php artisan serve` works. I'll close, since it's outside the scope of this repo but I will keep this issue updated when I find the solution, for others.
Author
Owner

@ghost commented on GitHub (Feb 26, 2021):

Solved it. Turned out to be the same as #1280. (See this reply)

<!-- gh-comment-id:786336836 --> @ghost commented on GitHub (Feb 26, 2021): Solved it. Turned out to be the same as #1280. (See [this reply](https://github.com/koel/koel/issues/1280#issuecomment-786336293))
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/koel-koel#737
No description provided.