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]: connection to SQLite-DB by using ODBC now (2.20.0) failed #2712

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

Originally created by @Gru0810 on GitHub (Apr 9, 2025).

What happened?

On my first NAS I have ABS Media Server 2.8.0 installed. I create a ODBC-connection to the related SQLite-DB and all works fine. I can get the date from all tables.
for example "Books":

Image

On my new NAS I have the latest Version 2.20.0 installed and I also create a equivalent ODBC-connection with the same driver.
But when I try to receive data I get this error:

Image

What did you expect to happen?

get a stable connection the a Table in SQLite-db of ABS MediaServer ( as with 2.8.0)

Steps to reproduce the issue

  1. create MS Access DB
  2. create User-DNS by ODBC Admin tool
  3. try to create a connected Table by using the User-DNS

Audiobookshelf version

2.2.0.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 @Gru0810 on GitHub (Apr 9, 2025). ### What happened? On my first NAS I have ABS Media Server 2.8.0 installed. I create a ODBC-connection to the related SQLite-DB and all works fine. I can get the date from all tables. for example "Books": ![Image](https://github.com/user-attachments/assets/89113e10-ae3a-4776-9527-d911977561d4) On my new NAS I have the latest Version 2.20.0 installed and I also create a equivalent ODBC-connection with the same driver. But when I try to receive data I get this error: ![Image](https://github.com/user-attachments/assets/229d730a-f452-459d-a8a2-2e2fc87deb31) ### What did you expect to happen? get a stable connection the a Table in SQLite-db of ABS MediaServer ( as with 2.8.0) ### Steps to reproduce the issue 1. create MS Access DB 2. create User-DNS by ODBC Admin tool 3. try to create a connected Table by using the User-DNS ### Audiobookshelf version 2.2.0.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:09:47 +02:00
adam closed this issue 2026-04-25 00:09:47 +02:00
adam commented 2026-04-25 00:09:47 +02:00
Author
Owner
Copy Link
Copy Source

@nichwall commented on GitHub (Apr 9, 2025):

Duplicate of https://github.com/advplyr/audiobookshelf/issues/4134

Looks like you are using an out of date SQLite

@nichwall commented on GitHub (Apr 9, 2025): Duplicate of https://github.com/advplyr/audiobookshelf/issues/4134 Looks like you are using an out of date SQLite
adam commented 2026-04-25 00:09:48 +02:00
Author
Owner
Copy Link
Copy Source

@Vito0912 commented on GitHub (Apr 9, 2025):

ABS uses a new SQLite version.

If I recall correctly, there was a user who also used that browser on their NAS, and there is no available version that supports that version.

This is not really an issue with ABS, but with the software you are using to read the SQLite file.

Related to https://github.com/advplyr/audiobookshelf/issues/4134

Edit: Arg, nichwall was faster

@Vito0912 commented on GitHub (Apr 9, 2025): ABS uses a new SQLite version. If I recall correctly, there was a user who also used that browser on their NAS, and there is no available version that supports that version. This is not really an issue with ABS, but with the software you are using to read the SQLite file. Related to https://github.com/advplyr/audiobookshelf/issues/4134 Edit: Arg, nichwall was faster
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#2712
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?