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]: Searching immediately crashes server [v2.19.1] #2566

New Issue
Closed
opened 2026-04-25 00:08:27 +02:00 by adam · 5 comments
adam commented 2026-04-25 00:08:27 +02:00
Owner
Copy Link
Copy Source

Originally created by @aerlenbach on GitHub (Feb 12, 2025).

What happened?

Running v2.19.1 on Docker Desktop Portainer on M1 Mac mini

Accessing server via iPhone 16 pro & ABS beta app

Attempted to search for audiobook or podcast in ABS iOS beta app results in server crash.

What did you expect to happen?

attempted to search for audiobook or podcast in ABS iOS beta app would result in search results appearing.

Steps to reproduce the issue

  1. open ABS beta app on iOS.
  2. attempt to search for podcast or audiobook
  3. as soon as you begin typing in search bar, the server crashes.

Audiobookshelf version

v2.19.1

How are you running audiobookshelf?

Docker

What OS is your Audiobookshelf server hosted from?

macOS

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

None

Logs

see attachment. too long for this text field.

Additional Notes

crash_logs.txt

Originally created by @aerlenbach on GitHub (Feb 12, 2025). ### What happened? Running v2.19.1 on Docker Desktop Portainer on M1 Mac mini Accessing server via iPhone 16 pro & ABS beta app Attempted to search for audiobook or podcast in ABS iOS beta app results in server crash. ### What did you expect to happen? attempted to search for audiobook or podcast in ABS iOS beta app would result in search results appearing. ### Steps to reproduce the issue 1. open ABS beta app on iOS. 2. attempt to search for podcast or audiobook 3. as soon as you begin typing in search bar, the server crashes. ### Audiobookshelf version v2.19.1 ### How are you running audiobookshelf? Docker ### What OS is your Audiobookshelf server hosted from? macOS ### If the issue is being seen in the UI, what browsers are you seeing the problem on? None ### Logs ```shell see attachment. too long for this text field. ``` ### Additional Notes [crash_logs.txt](https://github.com/user-attachments/files/18763793/crash_logs.txt)
adam added the bug label 2026-04-25 00:08:27 +02:00
adam closed this issue 2026-04-25 00:08:27 +02:00
adam commented 2026-04-25 00:08:28 +02:00
Author
Owner
Copy Link
Copy Source

@ahetek commented on GitHub (Feb 12, 2025):

I got the same problem.
Right after upgrade to 2.19.1 (docker) when i try to search i get:

Unhandled rejection: Error at Database. (/node_modules/sequelize/lib/dialects/sqlite/query.js:185:27) at /node_modules/sequelize/lib/dialects/sqlite/query.js:183:50 at new Promise () at Query.run (/node_modules/sequelize/lib/dialects/sqlite/query.js:183:12) at /node_modules/sequelize/lib/sequelize.js:315:28 at async SQLiteQueryInterface.select (/node_modules/sequelize/lib/dialects/abstract/query-interface.js:407:12) at async book.findAll (/node_modules/sequelize/lib/model.js:1140:21) at async Object.search (/server/utils/queries/libraryItemsBookFilters.js:1042:19) at async ApiRouter.search (/server/controllers/LibraryController.js:953:21) { name: 'SequelizeDatabaseError', parent: [Error: SQLITE_ERROR: ambiguous column name: title]

@ahetek commented on GitHub (Feb 12, 2025): I got the same problem. Right after upgrade to 2.19.1 (docker) when i try to search i get: Unhandled rejection: Error at Database.<anonymous> (/node_modules/sequelize/lib/dialects/sqlite/query.js:185:27) at /node_modules/sequelize/lib/dialects/sqlite/query.js:183:50 at new Promise (<anonymous>) at Query.run (/node_modules/sequelize/lib/dialects/sqlite/query.js:183:12) at /node_modules/sequelize/lib/sequelize.js:315:28 at async SQLiteQueryInterface.select (/node_modules/sequelize/lib/dialects/abstract/query-interface.js:407:12) at async book.findAll (/node_modules/sequelize/lib/model.js:1140:21) at async Object.search (/server/utils/queries/libraryItemsBookFilters.js:1042:19) at async ApiRouter.search (/server/controllers/LibraryController.js:953:21) { name: 'SequelizeDatabaseError', parent: [Error: SQLITE_ERROR: ambiguous column name: title]
adam commented 2026-04-25 00:08:28 +02:00
Author
Owner
Copy Link
Copy Source

@D3r3k23 commented on GitHub (Feb 12, 2025):

After upgrading, it's crashing when I go to the Library tab for my podcasts library. The audiobooks library seems to work.

crash_logs.txt

@D3r3k23 commented on GitHub (Feb 12, 2025): After upgrading, it's crashing when I go to the Library tab for my podcasts library. The audiobooks library seems to work. [crash_logs.txt](https://github.com/user-attachments/files/18764773/crash_logs.txt)
adam commented 2026-04-25 00:08:28 +02:00
Author
Owner
Copy Link
Copy Source

@thehijacker commented on GitHub (Feb 12, 2025):

Same problem also for me. On 2.19.1. I tried to search but it crashes.

[Error: SQLITE_ERROR: ambiguous column name: title]

@thehijacker commented on GitHub (Feb 12, 2025): Same problem also for me. On 2.19.1. I tried to search but it crashes. `[Error: SQLITE_ERROR: ambiguous column name: title]`
adam commented 2026-04-25 00:08:28 +02:00
Author
Owner
Copy Link
Copy Source

@mikiher commented on GitHub (Feb 12, 2025):

This is a duplicate of #3966

@mikiher commented on GitHub (Feb 12, 2025): This is a duplicate of #3966
adam commented 2026-04-25 00:08:29 +02:00
Author
Owner
Copy Link
Copy Source

@advplyr commented on GitHub (Feb 12, 2025):

Fixed in 2.19.2

@advplyr commented on GitHub (Feb 12, 2025): Fixed in 2.19.2
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#2566
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?