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]: Docker exits when trying to save a new series metadata (book) #1369

New Issue
Closed
opened 2026-04-24 23:42:29 +02:00 by adam · 3 comments
adam commented 2026-04-24 23:42:29 +02:00
Owner
Copy Link
Copy Source

Originally created by @jaw8 on GitHub (Sep 12, 2023).

Describe the issue

[2023-09-12 00:50:31] WARN: [ApiRouter] Series id "new-1694479790779" does not exist (ApiRouter.js:595)
node:internal/process/promises:279
triggerUncaughtException(err, true /* fromPromise */);
^
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 Function.findAll (/node_modules/sequelize/lib/model.js:1140:21)
at async Function.findOne (/node_modules/sequelize/lib/model.js:1240:12)
at async Function.getOldByNameAndLibrary (/server/models/Series.js:106:21)
at async ApiRouter.createAuthorsAndSeriesForItemUpdate (/server/routers/ApiRouter.js:600:30) {
name: 'SequelizeDatabaseError',
parent: [Error: SQLITE_ERROR: near "s": syntax error] {
errno: 1,
code: 'SQLITE_ERROR',
 
"SELECT id, name, nameIgnorePrefix, description, createdAt, updatedAt, libraryId FROM series AS series WHERE (name = 'Remembrance of Earth's Past' COLLATE NOCASE AND series.libraryId = 'c37ea42c-92b6-4aaa-9714-da7e6a86657c') LIMIT 1;"
},
original: [Error: SQLITE_ERROR: near "s": syntax error] {
errno: 1,
code: 'SQLITE_ERROR',
 
"SELECT id, name, nameIgnorePrefix, description, createdAt, updatedAt, libraryId FROM series AS series WHERE (name = 'Remembrance of Earth's Past' COLLATE NOCASE AND series.libraryId = 'c37ea42c-92b6-4aaa-9714-da7e6a86657c') LIMIT 1;"
},
sql: "SELECT id, name, nameIgnorePrefix, description, createdAt, updatedAt, libraryId FROM series AS series WHERE (name = 'Remembrance of Earth's Past' COLLATE NOCASE AND series.libraryId = 'c37ea42c-92b6-4aaa-9714-da7e6a86657c') LIMIT 1;",
parameters: {}
}
Config /config /metadata

Steps to reproduce the issue

  1. Edit any audiobook
  2. Add (+) a new series entry (does not already exist in library)
  3. Click Save or Save & Close

Audiobookshelf version

2.4.1

How are you running audiobookshelf?

Docker

Originally created by @jaw8 on GitHub (Sep 12, 2023). ### Describe the issue [2023-09-12 00:50:31] WARN: [ApiRouter] Series id "new-1694479790779" does not exist (ApiRouter.js:595) node:internal/process/promises:279 triggerUncaughtException(err, true /* fromPromise */); ^ 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 Function.findAll (/node_modules/sequelize/lib/model.js:1140:21) at async Function.findOne (/node_modules/sequelize/lib/model.js:1240:12) at async Function.getOldByNameAndLibrary (/server/models/Series.js:106:21) at async ApiRouter.createAuthorsAndSeriesForItemUpdate (/server/routers/ApiRouter.js:600:30) { name: 'SequelizeDatabaseError', parent: [Error: SQLITE_ERROR: near "s": syntax error] { errno: 1, code: 'SQLITE_ERROR',   "SELECT `id`, `name`, `nameIgnorePrefix`, `description`, `createdAt`, `updatedAt`, `libraryId` FROM `series` AS `series` WHERE (name = 'Remembrance of Earth's Past' COLLATE NOCASE AND `series`.`libraryId` = 'c37ea42c-92b6-4aaa-9714-da7e6a86657c') LIMIT 1;" }, original: [Error: SQLITE_ERROR: near "s": syntax error] { errno: 1, code: 'SQLITE_ERROR',   "SELECT `id`, `name`, `nameIgnorePrefix`, `description`, `createdAt`, `updatedAt`, `libraryId` FROM `series` AS `series` WHERE (name = 'Remembrance of Earth's Past' COLLATE NOCASE AND `series`.`libraryId` = 'c37ea42c-92b6-4aaa-9714-da7e6a86657c') LIMIT 1;" }, sql: "SELECT `id`, `name`, `nameIgnorePrefix`, `description`, `createdAt`, `updatedAt`, `libraryId` FROM `series` AS `series` WHERE (name = 'Remembrance of Earth's Past' COLLATE NOCASE AND `series`.`libraryId` = 'c37ea42c-92b6-4aaa-9714-da7e6a86657c') LIMIT 1;", parameters: {} } Config /config /metadata ### Steps to reproduce the issue 1. Edit any audiobook 2. Add (+) a new series entry (does not already exist in library) 3. Click Save or Save & Close ### Audiobookshelf version 2.4.1 ### How are you running audiobookshelf? Docker
adam added the bug label 2026-04-24 23:42:29 +02:00
adam closed this issue 2026-04-24 23:42:29 +02:00
adam commented 2026-04-24 23:42:30 +02:00
Author
Owner
Copy Link
Copy Source

@jaw8 commented on GitHub (Sep 12, 2023):

Likely related to #2076.

Successfully added new series after updating series name from Remembrance of Earth's Past to Remembrance of Earths Past (removed apostrophe, i.e., single quote).

@jaw8 commented on GitHub (Sep 12, 2023): Likely related to #2076. Successfully added new series after updating series name from `Remembrance of Earth's Past` to `Remembrance of Earths Past` (removed apostrophe, i.e., single quote).
adam commented 2026-04-24 23:42:31 +02:00
Author
Owner
Copy Link
Copy Source

@advplyr commented on GitHub (Sep 12, 2023):

Yeah it's the same issue

@advplyr commented on GitHub (Sep 12, 2023): Yeah it's the same issue
adam commented 2026-04-24 23:42:32 +02:00
Author
Owner
Copy Link
Copy Source

@advplyr commented on GitHub (Sep 12, 2023):

Duplicate of #2076

@advplyr commented on GitHub (Sep 12, 2023): Duplicate of #2076
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#1369
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?