starred/audiobookshelf
1
0
Fork 0
mirror of https://github.com/advplyr/audiobookshelf.git synced 2026-05-30 23:40:40 +02:00
Code Issues 1.0k Packages Projects Releases 10 Wiki Activity

[Bug]: issue modifying sqlite #2896

New Issue
Closed
opened 2026-04-25 00:11:41 +02:00 by adam · 2 comments
adam commented 2026-04-25 00:11:41 +02:00
Owner
Copy Link
Copy Source

Originally created by @mkomarinski on GitHub (Jul 15, 2025).

What happened?

Using Docker compose on Ubuntu. I locked myself out of my administrative account and thought I could break in via the sqlite database but trying to access anything in the sqlite file gives me an error:

sqlite> .tables
Error: malformed database schema (update_library_items_author_names_on_book_authors_insert) - near "ORDER": syntax error

What did you expect to happen?

Able to e.g. see tables using .tables

Steps to reproduce the issue

  1. Shut down docker instance
  2. sqlite3 absdatabase.sqlite
  3. .tables

Audiobookshelf version

2.26.0

How are you running audiobookshelf?

Docker

What OS is your Audiobookshelf server hosted from?

Linux

If the issue is being seen in the UI, what browsers are you seeing the problem on?

None

Logs

Additional Notes

No response

Originally created by @mkomarinski on GitHub (Jul 15, 2025). ### What happened? Using Docker compose on Ubuntu. I locked myself out of my administrative account and thought I could break in via the sqlite database but trying to access anything in the sqlite file gives me an error: ``` sqlite> .tables Error: malformed database schema (update_library_items_author_names_on_book_authors_insert) - near "ORDER": syntax error ``` ### What did you expect to happen? Able to e.g. see tables using .tables ### Steps to reproduce the issue 1. Shut down docker instance 2. sqlite3 absdatabase.sqlite 3. .tables ### Audiobookshelf version 2.26.0 ### How are you running audiobookshelf? Docker ### What OS is your Audiobookshelf server hosted from? Linux ### If the issue is being seen in the UI, what browsers are you seeing the problem on? None ### Logs ```shell ``` ### Additional Notes _No response_
adam added the bug label 2026-04-25 00:11:41 +02:00
adam closed this issue 2026-04-25 00:11:41 +02:00
adam commented 2026-04-25 00:11:41 +02:00
Author
Owner
Copy Link
Copy Source

@nichwall commented on GitHub (Jul 15, 2025):

Duplicate of https://github.com/advplyr/audiobookshelf/issues/4134. You need to be using at least SQLite 3.44.0, released in November of 2023.

@nichwall commented on GitHub (Jul 15, 2025): Duplicate of https://github.com/advplyr/audiobookshelf/issues/4134. You need to be using at least SQLite 3.44.0, released in November of 2023.
adam commented 2026-04-25 00:11:41 +02:00
Author
Owner
Copy Link
Copy Source

@mkomarinski commented on GitHub (Jul 15, 2025):

Sigh. Thought I searched. The current release on Debian is insufficient and there's no backport. Sent the sqlite file to a recent Ubuntu system and I was able to correct my problem.

@mkomarinski commented on GitHub (Jul 15, 2025): Sigh. Thought I searched. The current release on Debian is insufficient and there's no backport. Sent the sqlite file to a recent Ubuntu system and I was able to correct my problem.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
authentication
backlog
bug
chapter editor
config-issue
ebooks
encoding/embedding
enhancement
help wanted
listening sessions & progress
planned
possible plugin
progress sync
pull-request
Mirrored from GitHub Pull Request
 sorting/filtering/searching
unable to reproduce
upload
users & permissions
waiting
No Label bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
adam (Adam Melkus)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/audiobookshelf#2896
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?