[GH-ISSUE #1280] Search database issues #730

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

Originally created by @zachron on GitHub (Feb 12, 2021).
Original GitHub issue: https://github.com/koel/koel/issues/1280

i upgraded to 5.0.2 and the TNTSearch seems to be broken..

when i try to do a search , in the storage/logs/laravel.log is produces this:
[2021-02-12 18:40:40] production.ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database {"userId":2,"exception":"[object] (PDOException(code: HY000): SQLSTATE[HY000]: General error: 8 attempt to write a readonly database at /usr/share/nginx/koel/vendor/teamtnt/tntsearch/src/TNTSearch.php:399)
(if you need the full stacktrace i can provide it)
I followed all the upgrade instructions and everything else seems to be working fine. Any help is appreciated.

Originally created by @zachron on GitHub (Feb 12, 2021). Original GitHub issue: https://github.com/koel/koel/issues/1280 i upgraded to 5.0.2 and the TNTSearch seems to be broken.. when i try to do a search , in the storage/logs/laravel.log is produces this: `[2021-02-12 18:40:40] production.ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database {"userId":2,"exception":"[object] (PDOException(code: HY000): SQLSTATE[HY000]: General error: 8 attempt to write a readonly database at /usr/share/nginx/koel/vendor/teamtnt/tntsearch/src/TNTSearch.php:399) ` (if you need the full stacktrace i can provide it) I followed all the upgrade instructions and everything else seems to be working fine. Any help is appreciated.
kerem closed this issue 2026-02-26 02:34:06 +03:00
Author
Owner

@phanan commented on GitHub (Feb 15, 2021):

What's the content under storage/search-indexes and is the directory (and its content) writable?

<!-- gh-comment-id:779290216 --> @phanan commented on GitHub (Feb 15, 2021): What's the content under `storage/search-indexes` and is the directory (and its content) writable?
Author
Owner

@zachron commented on GitHub (Feb 15, 2021):

is the directory (and its content) writable?

that is what the issue was, that directory was not writeable, i fixed that and now it works. thank you for your help.

<!-- gh-comment-id:779345157 --> @zachron commented on GitHub (Feb 15, 2021): > is the directory (and its content) writable? that is what the issue was, that directory was not writeable, i fixed that and now it works. thank you for your help.
Author
Owner

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

Had a very similar issue which didn't allow me to edit song metadata. For me it was the storage/framework subdirectory. Probably happened because I ran php artisan serve as root.

chown -R <user> storage/ fixed it.

(Just for the future reader.)

<!-- gh-comment-id:786336293 --> @ghost commented on GitHub (Feb 26, 2021): Had a very similar issue which didn't allow me to edit song metadata. For me it was the `storage/framework` subdirectory. Probably happened because I ran `php artisan serve` as root. `chown -R <user> storage/` fixed it. (Just for the future reader.)
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#730
No description provided.