[Bug]: SQLITE ERROR after upgrade to 2.19.1 #2563

New Issue

Closed

opened 2026-04-25 00:08:25 +02:00 by adam · 7 comments

adam commented 2026-04-25 00:08:25 +02:00

Owner

Copy Link

Copy Source

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

What happened?

Just found out server ( container ) crashed upgraded to 2.19.1. Causing by SQLite error. Downgarde to 2.19.0 fixes the problem temporary.

What did you expect to happen?

Server ( container ) crashs

Steps to reproduce the issue

1. Update to 2.19.1
2. Open library from browser
3. Server crashs

Audiobookshelf version

2.19.1

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

[2025-02-12 00:34:28.109] FATAL: [Server] 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 Promise.all (index 1)
    at async book.findAndCountAll (/node_modules/sequelize/lib/model.js:1322:27)
    at async findAndCountAll (/server/utils/queries/libraryItemsBookFilters.js:358:22) {
  name: 'SequelizeDatabaseError',
  parent: [Error: SQLITE_ERROR: ambiguous column name: titleIgnorePrefix] {
    errno: 1,
    code: 'SQLITE_ERROR',
    sql: 'SELECT `book`.`id`, `book`.`title`, `book`.`titleIgnorePrefix`, `book`.`subtitle`, `book`.`publishedYear`, `book`.`publishedDate`, `book`.`publisher`, `book`.`description`, `book`.`isbn`, `book`.`asin`, `book`.`language`, `book`.`explicit`, `book`.`abridged`, `book`.`coverPath`, `book`.`duration`, `book`.`narrators`, `book`.`audioFiles`, `book`.`ebookFile`, `book`.`chapters`, `book`.`tags`, `book`.`genres`, `book`.`createdAt`, `book`.`updatedAt`, IFNULL((SELECT s.nameIgnorePrefix FROM bookSeries AS bs, series AS s WHERE bs.seriesId = s.id AND bs.bookId = book.id AND bs.id IN ("a8d4e2a9-d590-4d9a-95e6-c006e20ee8b3", "bc70cbf2-bdc3-4cda-ac52-ed976a2ec71c", "32f082f9-2624-42b8-9601-65b2448562b8", "ab648a42-9aec-4eff-9078-7dedb544a057", "2bb67e78-219f-41c5-ace3-b8574932a130", "815d5c92-e2f1-482a-9a8f-403c66efa70b", "35db596c-cdb6-420b-b8f1-f85f2f3fc5d8", "6dff178a-93c8-416b-a9e8-7d0af0c95fe7", "8fc8839d-1071-4fcd-a641-48024923c723", "ce5fb669-d6d4-4afd-aeff-28bc3b106c32")), titleIgnorePrefix) AS `display_title`, `libraryItem`.`id` AS `libraryItem.id`, `libraryItem`.`ino` AS `libraryItem.ino`, `libraryItem`.`path` AS `libraryItem.path`, `libraryItem`.`relPath` AS `libraryItem.relPath`, `libraryItem`.`mediaId` AS `libraryItem.mediaId`, `libraryItem`.`mediaType` AS `libraryItem.mediaType`, `libraryItem`.`isFile` AS `libraryItem.isFile`, `libraryItem`.`isMissing` AS `libraryItem.isMissing`, `libraryItem`.`isInvalid` AS `libraryItem.isInvalid`, `libraryItem`.`mtime` AS `libraryItem.mtime`, `libraryItem`.`ctime` AS `libraryItem.ctime`, `libraryItem`.`birthtime` AS `libraryItem.birthtime`, `libraryItem`.`size` AS `libraryItem.size`, `libraryItem`.`lastScan` AS `libraryItem.lastScan`, `libraryItem`.`lastScanVersion` AS `libraryItem.lastScanVersion`, `libraryItem`.`libraryFiles` AS `libraryItem.libraryFiles`, `libraryItem`.`extraData` AS `libraryItem.extraData`, `libraryItem`.`title` AS `libraryItem.title`, `libraryItem`.`titleIgnorePrefix` AS `libraryItem.titleIgnorePrefix`, `libraryItem`.`createdAt` AS `libraryItem.createdAt`, `libraryItem`.`updatedAt` AS `libraryItem.updatedAt`, `libraryItem`.`libraryId` AS `libraryItem.libraryId`, `libraryItem`.`libraryFolderId` AS `libraryItem.libraryFolderId` FROM `books` AS `book` INNER JOIN `libraryItems` AS `libraryItem` ON `book`.`id` = `libraryItem`.`mediaId` AND (`libraryItem`.`libraryId` = \'24f3a2fa-f4ee-4b07-9cc6-f4586f701e03\' AND `libraryItem`.`mediaType` = \'book\') WHERE (`book`.`id` NOT IN (\'8f0d60a2-985e-4856-a1af-1238522e9b2f\', \'d7b1692e-a065-4542-a1e1-dc43056d3443\', \'27715340-7bd5-4f20-abe3-64daa749c22f\', \'112c1b81-d163-45de-a079-e75e9bbf37d3\', \'bba9fd11-574d-4413-9fcd-84c14cf01446\', \'7e5d8fe8-8e32-479a-87e4-3bc90d9a3dcb\', \'ae0caed4-eb84-4cca-b881-058c1274b1af\', \'74cc46e7-ebdf-48b4-b693-d38a77f5bd26\', \'480d07b3-1fe9-4214-82fa-23036128bf54\', \'6037450d-5b00-4e24-9c7c-374c47a85c23\', \'8b3d4add-fac0-4f33-aebd-a86031410163\', \'c90b4639-1b4d-4395-b266-d0ec803ad75e\', \'d929eaa4-a498-439b-8521-5dda14bbb9a6\', \'b00a29db-773e-4973-85f3-58de19c4b805\', \'592ce413-d480-4e82-8892-957fa0582932\', \'7206eba9-aaa4-43d4-bc94-5ced20b883e9\', \'bc5a43b8-204b-4afb-a85c-305a6b4b8a28\', \'a2e303ca-f3ef-46f3-90bc-494d7b253cb0\', \'1a818232-8ac5-4438-9483-e7e58eee386c\', \'fc7c8084-1092-4f38-abd3-f8253b17c33d\', \'d0577cde-c262-44e2-bd17-e8c85d2df5cc\', \'4cce5241-5521-4411-a1df-1722318e70e0\')) ORDER BY libraryItem.createdAt DESC LIMIT 0, 54;'
  },
  original: [Error: SQLITE_ERROR: ambiguous column name: titleIgnorePrefix] {
    errno: 1,
    code: 'SQLITE_ERROR',
    sql: 'SELECT `book`.`id`, `book`.`title`, `book`.`titleIgnorePrefix`, `book`.`subtitle`, `book`.`publishedYear`, `book`.`publishedDate`, `book`.`publisher`, `book`.`description`, `book`.`isbn`, `book`.`asin`, `book`.`language`, `book`.`explicit`, `book`.`abridged`, `book`.`coverPath`, `book`.`duration`, `book`.`narrators`, `book`.`audioFiles`, `book`.`ebookFile`, `book`.`chapters`, `book`.`tags`, `book`.`genres`, `book`.`createdAt`, `book`.`updatedAt`, IFNULL((SELECT s.nameIgnorePrefix FROM bookSeries AS bs, series AS s WHERE bs.seriesId = s.id AND bs.bookId = book.id AND bs.id IN ("a8d4e2a9-d590-4d9a-95e6-c006e20ee8b3", "bc70cbf2-bdc3-4cda-ac52-ed976a2ec71c", "32f082f9-2624-42b8-9601-65b2448562b8", "ab648a42-9aec-4eff-9078-7dedb544a057", "2bb67e78-219f-41c5-ace3-b8574932a130", "815d5c92-e2f1-482a-9a8f-403c66efa70b", "35db596c-cdb6-420b-b8f1-f85f2f3fc5d8", "6dff178a-93c8-416b-a9e8-7d0af0c95fe7", "8fc8839d-1071-4fcd-a641-48024923c723", "ce5fb669-d6d4-4afd-aeff-28bc3b106c32")), titleIgnorePrefix) AS `display_title`, `libraryItem`.`id` AS `libraryItem.id`, `libraryItem`.`ino` AS `libraryItem.ino`, `libraryItem`.`path` AS `libraryItem.path`, `libraryItem`.`relPath` AS `libraryItem.relPath`, `libraryItem`.`mediaId` AS `libraryItem.mediaId`, `libraryItem`.`mediaType` AS `libraryItem.mediaType`, `libraryItem`.`isFile` AS `libraryItem.isFile`, `libraryItem`.`isMissing` AS `libraryItem.isMissing`, `libraryItem`.`isInvalid` AS `libraryItem.isInvalid`, `libraryItem`.`mtime` AS `libraryItem.mtime`, `libraryItem`.`ctime` AS `libraryItem.ctime`, `libraryItem`.`birthtime` AS `libraryItem.birthtime`, `libraryItem`.`size` AS `libraryItem.size`, `libraryItem`.`lastScan` AS `libraryItem.lastScan`, `libraryItem`.`lastScanVersion` AS `libraryItem.lastScanVersion`, `libraryItem`.`libraryFiles` AS `libraryItem.libraryFiles`, `libraryItem`.`extraData` AS `libraryItem.extraData`, `libraryItem`.`title` AS `libraryItem.title`, `libraryItem`.`titleIgnorePrefix` AS `libraryItem.titleIgnorePrefix`, `libraryItem`.`createdAt` AS `libraryItem.createdAt`, `libraryItem`.`updatedAt` AS `libraryItem.updatedAt`, `libraryItem`.`libraryId` AS `libraryItem.libraryId`, `libraryItem`.`libraryFolderId` AS `libraryItem.libraryFolderId` FROM `books` AS `book` INNER JOIN `libraryItems` AS `libraryItem` ON `book`.`id` = `libraryItem`.`mediaId` AND (`libraryItem`.`libraryId` = \'24f3a2fa-f4ee-4b07-9cc6-f4586f701e03\' AND `libraryItem`.`mediaType` = \'book\') WHERE (`book`.`id` NOT IN (\'8f0d60a2-985e-4856-a1af-1238522e9b2f\', \'d7b1692e-a065-4542-a1e1-dc43056d3443\', \'27715340-7bd5-4f20-abe3-64daa749c22f\', \'112c1b81-d163-45de-a079-e75e9bbf37d3\', \'bba9fd11-574d-4413-9fcd-84c14cf01446\', \'7e5d8fe8-8e32-479a-87e4-3bc90d9a3dcb\', \'ae0caed4-eb84-4cca-b881-058c1274b1af\', \'74cc46e7-ebdf-48b4-b693-d38a77f5bd26\', \'480d07b3-1fe9-4214-82fa-23036128bf54\', \'6037450d-5b00-4e24-9c7c-374c47a85c23\', \'8b3d4add-fac0-4f33-aebd-a86031410163\', \'c90b4639-1b4d-4395-b266-d0ec803ad75e\', \'d929eaa4-a498-439b-8521-5dda14bbb9a6\', \'b00a29db-773e-4973-85f3-58de19c4b805\', \'592ce413-d480-4e82-8892-957fa0582932\', \'7206eba9-aaa4-43d4-bc94-5ced20b883e9\', \'bc5a43b8-204b-4afb-a85c-305a6b4b8a28\', \'a2e303ca-f3ef-46f3-90bc-494d7b253cb0\', \'1a818232-8ac5-4438-9483-e7e58eee386c\', \'fc7c8084-1092-4f38-abd3-f8253b17c33d\', \'d0577cde-c262-44e2-bd17-e8c85d2df5cc\', \'4cce5241-5521-4411-a1df-1722318e70e0\')) ORDER BY libraryItem.createdAt DESC LIMIT 0, 54;'
  },
  sql: 'SELECT `book`.`id`, `book`.`title`, `book`.`titleIgnorePrefix`, `book`.`subtitle`, `book`.`publishedYear`, `book`.`publishedDate`, `book`.`publisher`, `book`.`description`, `book`.`isbn`, `book`.`asin`, `book`.`language`, `book`.`explicit`, `book`.`abridged`, `book`.`coverPath`, `book`.`duration`, `book`.`narrators`, `book`.`audioFiles`, `book`.`ebookFile`, `book`.`chapters`, `book`.`tags`, `book`.`genres`, `book`.`createdAt`, `book`.`updatedAt`, IFNULL((SELECT s.nameIgnorePrefix FROM bookSeries AS bs, series AS s WHERE bs.seriesId = s.id AND bs.bookId = book.id AND bs.id IN ("a8d4e2a9-d590-4d9a-95e6-c006e20ee8b3", "bc70cbf2-bdc3-4cda-ac52-ed976a2ec71c", "32f082f9-2624-42b8-9601-65b2448562b8", "ab648a42-9aec-4eff-9078-7dedb544a057", "2bb67e78-219f-41c5-ace3-b8574932a130", "815d5c92-e2f1-482a-9a8f-403c66efa70b", "35db596c-cdb6-420b-b8f1-f85f2f3fc5d8", "6dff178a-93c8-416b-a9e8-7d0af0c95fe7", "8fc8839d-1071-4fcd-a641-48024923c723", "ce5fb669-d6d4-4afd-aeff-28bc3b106c32")), titleIgnorePrefix) AS `display_title`, `libraryItem`.`id` AS `libraryItem.id`, `libraryItem`.`ino` AS `libraryItem.ino`, `libraryItem`.`path` AS `libraryItem.path`, `libraryItem`.`relPath` AS `libraryItem.relPath`, `libraryItem`.`mediaId` AS `libraryItem.mediaId`, `libraryItem`.`mediaType` AS `libraryItem.mediaType`, `libraryItem`.`isFile` AS `libraryItem.isFile`, `libraryItem`.`isMissing` AS `libraryItem.isMissing`, `libraryItem`.`isInvalid` AS `libraryItem.isInvalid`, `libraryItem`.`mtime` AS `libraryItem.mtime`, `libraryItem`.`ctime` AS `libraryItem.ctime`, `libraryItem`.`birthtime` AS `libraryItem.birthtime`, `libraryItem`.`size` AS `libraryItem.size`, `libraryItem`.`lastScan` AS `libraryItem.lastScan`, `libraryItem`.`lastScanVersion` AS `libraryItem.lastScanVersion`, `libraryItem`.`libraryFiles` AS `libraryItem.libraryFiles`, `libraryItem`.`extraData` AS `libraryItem.extraData`, `libraryItem`.`title` AS `libraryItem.title`, `libraryItem`.`titleIgnorePrefix` AS `libraryItem.titleIgnorePrefix`, `libraryItem`.`createdAt` AS `libraryItem.createdAt`, `libraryItem`.`updatedAt` AS `libraryItem.updatedAt`, `libraryItem`.`libraryId` AS `libraryItem.libraryId`, `libraryItem`.`libraryFolderId` AS `libraryItem.libraryFolderId` FROM `books` AS `book` INNER JOIN `libraryItems` AS `libraryItem` ON `book`.`id` = `libraryItem`.`mediaId` AND (`libraryItem`.`libraryId` = \'24f3a2fa-f4ee-4b07-9cc6-f4586f701e03\' AND `libraryItem`.`mediaType` = \'book\') WHERE (`book`.`id` NOT IN (\'8f0d60a2-985e-4856-a1af-1238522e9b2f\', \'d7b1692e-a065-4542-a1e1-dc43056d3443\', \'27715340-7bd5-4f20-abe3-64daa749c22f\', \'112c1b81-d163-45de-a079-e75e9bbf37d3\', \'bba9fd11-574d-4413-9fcd-84c14cf01446\', \'7e5d8fe8-8e32-479a-87e4-3bc90d9a3dcb\', \'ae0caed4-eb84-4cca-b881-058c1274b1af\', \'74cc46e7-ebdf-48b4-b693-d38a77f5bd26\', \'480d07b3-1fe9-4214-82fa-23036128bf54\', \'6037450d-5b00-4e24-9c7c-374c47a85c23\', \'8b3d4add-fac0-4f33-aebd-a86031410163\', \'c90b4639-1b4d-4395-b266-d0ec803ad75e\', \'d929eaa4-a498-439b-8521-5dda14bbb9a6\', \'b00a29db-773e-4973-85f3-58de19c4b805\', \'592ce413-d480-4e82-8892-957fa0582932\', \'7206eba9-aaa4-43d4-bc94-5ced20b883e9\', \'bc5a43b8-204b-4afb-a85c-305a6b4b8a28\', \'a2e303ca-f3ef-46f3-90bc-494d7b253cb0\', \'1a818232-8ac5-4438-9483-e7e58eee386c\', \'fc7c8084-1092-4f38-abd3-f8253b17c33d\', \'d0577cde-c262-44e2-bd17-e8c85d2df5cc\', \'4cce5241-5521-4411-a1df-1722318e70e0\')) ORDER BY libraryItem.createdAt DESC LIMIT 0, 54;',

Additional Notes

No response

Originally created by @kobemtl on GitHub (Feb 12, 2025). ### What happened? Just found out server ( container ) crashed upgraded to 2.19.1. Causing by SQLite error. Downgarde to 2.19.0 fixes the problem temporary. ### What did you expect to happen? Server ( container ) crashs ### Steps to reproduce the issue 1. Update to 2.19.1 2. Open library from browser 3. Server crashs ### Audiobookshelf version 2.19.1 ### 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 [2025-02-12 00:34:28.109] FATAL: [Server] 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 Promise.all (index 1) at async book.findAndCountAll (/node_modules/sequelize/lib/model.js:1322:27) at async findAndCountAll (/server/utils/queries/libraryItemsBookFilters.js:358:22) { name: 'SequelizeDatabaseError', parent: [Error: SQLITE_ERROR: ambiguous column name: titleIgnorePrefix] { errno: 1, code: 'SQLITE_ERROR', sql: 'SELECT `book`.`id`, `book`.`title`, `book`.`titleIgnorePrefix`, `book`.`subtitle`, `book`.`publishedYear`, `book`.`publishedDate`, `book`.`publisher`, `book`.`description`, `book`.`isbn`, `book`.`asin`, `book`.`language`, `book`.`explicit`, `book`.`abridged`, `book`.`coverPath`, `book`.`duration`, `book`.`narrators`, `book`.`audioFiles`, `book`.`ebookFile`, `book`.`chapters`, `book`.`tags`, `book`.`genres`, `book`.`createdAt`, `book`.`updatedAt`, IFNULL((SELECT s.nameIgnorePrefix FROM bookSeries AS bs, series AS s WHERE bs.seriesId = s.id AND bs.bookId = book.id AND bs.id IN ("a8d4e2a9-d590-4d9a-95e6-c006e20ee8b3", "bc70cbf2-bdc3-4cda-ac52-ed976a2ec71c", "32f082f9-2624-42b8-9601-65b2448562b8", "ab648a42-9aec-4eff-9078-7dedb544a057", "2bb67e78-219f-41c5-ace3-b8574932a130", "815d5c92-e2f1-482a-9a8f-403c66efa70b", "35db596c-cdb6-420b-b8f1-f85f2f3fc5d8", "6dff178a-93c8-416b-a9e8-7d0af0c95fe7", "8fc8839d-1071-4fcd-a641-48024923c723", "ce5fb669-d6d4-4afd-aeff-28bc3b106c32")), titleIgnorePrefix) AS `display_title`, `libraryItem`.`id` AS `libraryItem.id`, `libraryItem`.`ino` AS `libraryItem.ino`, `libraryItem`.`path` AS `libraryItem.path`, `libraryItem`.`relPath` AS `libraryItem.relPath`, `libraryItem`.`mediaId` AS `libraryItem.mediaId`, `libraryItem`.`mediaType` AS `libraryItem.mediaType`, `libraryItem`.`isFile` AS `libraryItem.isFile`, `libraryItem`.`isMissing` AS `libraryItem.isMissing`, `libraryItem`.`isInvalid` AS `libraryItem.isInvalid`, `libraryItem`.`mtime` AS `libraryItem.mtime`, `libraryItem`.`ctime` AS `libraryItem.ctime`, `libraryItem`.`birthtime` AS `libraryItem.birthtime`, `libraryItem`.`size` AS `libraryItem.size`, `libraryItem`.`lastScan` AS `libraryItem.lastScan`, `libraryItem`.`lastScanVersion` AS `libraryItem.lastScanVersion`, `libraryItem`.`libraryFiles` AS `libraryItem.libraryFiles`, `libraryItem`.`extraData` AS `libraryItem.extraData`, `libraryItem`.`title` AS `libraryItem.title`, `libraryItem`.`titleIgnorePrefix` AS `libraryItem.titleIgnorePrefix`, `libraryItem`.`createdAt` AS `libraryItem.createdAt`, `libraryItem`.`updatedAt` AS `libraryItem.updatedAt`, `libraryItem`.`libraryId` AS `libraryItem.libraryId`, `libraryItem`.`libraryFolderId` AS `libraryItem.libraryFolderId` FROM `books` AS `book` INNER JOIN `libraryItems` AS `libraryItem` ON `book`.`id` = `libraryItem`.`mediaId` AND (`libraryItem`.`libraryId` = \'24f3a2fa-f4ee-4b07-9cc6-f4586f701e03\' AND `libraryItem`.`mediaType` = \'book\') WHERE (`book`.`id` NOT IN (\'8f0d60a2-985e-4856-a1af-1238522e9b2f\', \'d7b1692e-a065-4542-a1e1-dc43056d3443\', \'27715340-7bd5-4f20-abe3-64daa749c22f\', \'112c1b81-d163-45de-a079-e75e9bbf37d3\', \'bba9fd11-574d-4413-9fcd-84c14cf01446\', \'7e5d8fe8-8e32-479a-87e4-3bc90d9a3dcb\', \'ae0caed4-eb84-4cca-b881-058c1274b1af\', \'74cc46e7-ebdf-48b4-b693-d38a77f5bd26\', \'480d07b3-1fe9-4214-82fa-23036128bf54\', \'6037450d-5b00-4e24-9c7c-374c47a85c23\', \'8b3d4add-fac0-4f33-aebd-a86031410163\', \'c90b4639-1b4d-4395-b266-d0ec803ad75e\', \'d929eaa4-a498-439b-8521-5dda14bbb9a6\', \'b00a29db-773e-4973-85f3-58de19c4b805\', \'592ce413-d480-4e82-8892-957fa0582932\', \'7206eba9-aaa4-43d4-bc94-5ced20b883e9\', \'bc5a43b8-204b-4afb-a85c-305a6b4b8a28\', \'a2e303ca-f3ef-46f3-90bc-494d7b253cb0\', \'1a818232-8ac5-4438-9483-e7e58eee386c\', \'fc7c8084-1092-4f38-abd3-f8253b17c33d\', \'d0577cde-c262-44e2-bd17-e8c85d2df5cc\', \'4cce5241-5521-4411-a1df-1722318e70e0\')) ORDER BY libraryItem.createdAt DESC LIMIT 0, 54;' }, original: [Error: SQLITE_ERROR: ambiguous column name: titleIgnorePrefix] { errno: 1, code: 'SQLITE_ERROR', sql: 'SELECT `book`.`id`, `book`.`title`, `book`.`titleIgnorePrefix`, `book`.`subtitle`, `book`.`publishedYear`, `book`.`publishedDate`, `book`.`publisher`, `book`.`description`, `book`.`isbn`, `book`.`asin`, `book`.`language`, `book`.`explicit`, `book`.`abridged`, `book`.`coverPath`, `book`.`duration`, `book`.`narrators`, `book`.`audioFiles`, `book`.`ebookFile`, `book`.`chapters`, `book`.`tags`, `book`.`genres`, `book`.`createdAt`, `book`.`updatedAt`, IFNULL((SELECT s.nameIgnorePrefix FROM bookSeries AS bs, series AS s WHERE bs.seriesId = s.id AND bs.bookId = book.id AND bs.id IN ("a8d4e2a9-d590-4d9a-95e6-c006e20ee8b3", "bc70cbf2-bdc3-4cda-ac52-ed976a2ec71c", "32f082f9-2624-42b8-9601-65b2448562b8", "ab648a42-9aec-4eff-9078-7dedb544a057", "2bb67e78-219f-41c5-ace3-b8574932a130", "815d5c92-e2f1-482a-9a8f-403c66efa70b", "35db596c-cdb6-420b-b8f1-f85f2f3fc5d8", "6dff178a-93c8-416b-a9e8-7d0af0c95fe7", "8fc8839d-1071-4fcd-a641-48024923c723", "ce5fb669-d6d4-4afd-aeff-28bc3b106c32")), titleIgnorePrefix) AS `display_title`, `libraryItem`.`id` AS `libraryItem.id`, `libraryItem`.`ino` AS `libraryItem.ino`, `libraryItem`.`path` AS `libraryItem.path`, `libraryItem`.`relPath` AS `libraryItem.relPath`, `libraryItem`.`mediaId` AS `libraryItem.mediaId`, `libraryItem`.`mediaType` AS `libraryItem.mediaType`, `libraryItem`.`isFile` AS `libraryItem.isFile`, `libraryItem`.`isMissing` AS `libraryItem.isMissing`, `libraryItem`.`isInvalid` AS `libraryItem.isInvalid`, `libraryItem`.`mtime` AS `libraryItem.mtime`, `libraryItem`.`ctime` AS `libraryItem.ctime`, `libraryItem`.`birthtime` AS `libraryItem.birthtime`, `libraryItem`.`size` AS `libraryItem.size`, `libraryItem`.`lastScan` AS `libraryItem.lastScan`, `libraryItem`.`lastScanVersion` AS `libraryItem.lastScanVersion`, `libraryItem`.`libraryFiles` AS `libraryItem.libraryFiles`, `libraryItem`.`extraData` AS `libraryItem.extraData`, `libraryItem`.`title` AS `libraryItem.title`, `libraryItem`.`titleIgnorePrefix` AS `libraryItem.titleIgnorePrefix`, `libraryItem`.`createdAt` AS `libraryItem.createdAt`, `libraryItem`.`updatedAt` AS `libraryItem.updatedAt`, `libraryItem`.`libraryId` AS `libraryItem.libraryId`, `libraryItem`.`libraryFolderId` AS `libraryItem.libraryFolderId` FROM `books` AS `book` INNER JOIN `libraryItems` AS `libraryItem` ON `book`.`id` = `libraryItem`.`mediaId` AND (`libraryItem`.`libraryId` = \'24f3a2fa-f4ee-4b07-9cc6-f4586f701e03\' AND `libraryItem`.`mediaType` = \'book\') WHERE (`book`.`id` NOT IN (\'8f0d60a2-985e-4856-a1af-1238522e9b2f\', \'d7b1692e-a065-4542-a1e1-dc43056d3443\', \'27715340-7bd5-4f20-abe3-64daa749c22f\', \'112c1b81-d163-45de-a079-e75e9bbf37d3\', \'bba9fd11-574d-4413-9fcd-84c14cf01446\', \'7e5d8fe8-8e32-479a-87e4-3bc90d9a3dcb\', \'ae0caed4-eb84-4cca-b881-058c1274b1af\', \'74cc46e7-ebdf-48b4-b693-d38a77f5bd26\', \'480d07b3-1fe9-4214-82fa-23036128bf54\', \'6037450d-5b00-4e24-9c7c-374c47a85c23\', \'8b3d4add-fac0-4f33-aebd-a86031410163\', \'c90b4639-1b4d-4395-b266-d0ec803ad75e\', \'d929eaa4-a498-439b-8521-5dda14bbb9a6\', \'b00a29db-773e-4973-85f3-58de19c4b805\', \'592ce413-d480-4e82-8892-957fa0582932\', \'7206eba9-aaa4-43d4-bc94-5ced20b883e9\', \'bc5a43b8-204b-4afb-a85c-305a6b4b8a28\', \'a2e303ca-f3ef-46f3-90bc-494d7b253cb0\', \'1a818232-8ac5-4438-9483-e7e58eee386c\', \'fc7c8084-1092-4f38-abd3-f8253b17c33d\', \'d0577cde-c262-44e2-bd17-e8c85d2df5cc\', \'4cce5241-5521-4411-a1df-1722318e70e0\')) ORDER BY libraryItem.createdAt DESC LIMIT 0, 54;' }, sql: 'SELECT `book`.`id`, `book`.`title`, `book`.`titleIgnorePrefix`, `book`.`subtitle`, `book`.`publishedYear`, `book`.`publishedDate`, `book`.`publisher`, `book`.`description`, `book`.`isbn`, `book`.`asin`, `book`.`language`, `book`.`explicit`, `book`.`abridged`, `book`.`coverPath`, `book`.`duration`, `book`.`narrators`, `book`.`audioFiles`, `book`.`ebookFile`, `book`.`chapters`, `book`.`tags`, `book`.`genres`, `book`.`createdAt`, `book`.`updatedAt`, IFNULL((SELECT s.nameIgnorePrefix FROM bookSeries AS bs, series AS s WHERE bs.seriesId = s.id AND bs.bookId = book.id AND bs.id IN ("a8d4e2a9-d590-4d9a-95e6-c006e20ee8b3", "bc70cbf2-bdc3-4cda-ac52-ed976a2ec71c", "32f082f9-2624-42b8-9601-65b2448562b8", "ab648a42-9aec-4eff-9078-7dedb544a057", "2bb67e78-219f-41c5-ace3-b8574932a130", "815d5c92-e2f1-482a-9a8f-403c66efa70b", "35db596c-cdb6-420b-b8f1-f85f2f3fc5d8", "6dff178a-93c8-416b-a9e8-7d0af0c95fe7", "8fc8839d-1071-4fcd-a641-48024923c723", "ce5fb669-d6d4-4afd-aeff-28bc3b106c32")), titleIgnorePrefix) AS `display_title`, `libraryItem`.`id` AS `libraryItem.id`, `libraryItem`.`ino` AS `libraryItem.ino`, `libraryItem`.`path` AS `libraryItem.path`, `libraryItem`.`relPath` AS `libraryItem.relPath`, `libraryItem`.`mediaId` AS `libraryItem.mediaId`, `libraryItem`.`mediaType` AS `libraryItem.mediaType`, `libraryItem`.`isFile` AS `libraryItem.isFile`, `libraryItem`.`isMissing` AS `libraryItem.isMissing`, `libraryItem`.`isInvalid` AS `libraryItem.isInvalid`, `libraryItem`.`mtime` AS `libraryItem.mtime`, `libraryItem`.`ctime` AS `libraryItem.ctime`, `libraryItem`.`birthtime` AS `libraryItem.birthtime`, `libraryItem`.`size` AS `libraryItem.size`, `libraryItem`.`lastScan` AS `libraryItem.lastScan`, `libraryItem`.`lastScanVersion` AS `libraryItem.lastScanVersion`, `libraryItem`.`libraryFiles` AS `libraryItem.libraryFiles`, `libraryItem`.`extraData` AS `libraryItem.extraData`, `libraryItem`.`title` AS `libraryItem.title`, `libraryItem`.`titleIgnorePrefix` AS `libraryItem.titleIgnorePrefix`, `libraryItem`.`createdAt` AS `libraryItem.createdAt`, `libraryItem`.`updatedAt` AS `libraryItem.updatedAt`, `libraryItem`.`libraryId` AS `libraryItem.libraryId`, `libraryItem`.`libraryFolderId` AS `libraryItem.libraryFolderId` FROM `books` AS `book` INNER JOIN `libraryItems` AS `libraryItem` ON `book`.`id` = `libraryItem`.`mediaId` AND (`libraryItem`.`libraryId` = \'24f3a2fa-f4ee-4b07-9cc6-f4586f701e03\' AND `libraryItem`.`mediaType` = \'book\') WHERE (`book`.`id` NOT IN (\'8f0d60a2-985e-4856-a1af-1238522e9b2f\', \'d7b1692e-a065-4542-a1e1-dc43056d3443\', \'27715340-7bd5-4f20-abe3-64daa749c22f\', \'112c1b81-d163-45de-a079-e75e9bbf37d3\', \'bba9fd11-574d-4413-9fcd-84c14cf01446\', \'7e5d8fe8-8e32-479a-87e4-3bc90d9a3dcb\', \'ae0caed4-eb84-4cca-b881-058c1274b1af\', \'74cc46e7-ebdf-48b4-b693-d38a77f5bd26\', \'480d07b3-1fe9-4214-82fa-23036128bf54\', \'6037450d-5b00-4e24-9c7c-374c47a85c23\', \'8b3d4add-fac0-4f33-aebd-a86031410163\', \'c90b4639-1b4d-4395-b266-d0ec803ad75e\', \'d929eaa4-a498-439b-8521-5dda14bbb9a6\', \'b00a29db-773e-4973-85f3-58de19c4b805\', \'592ce413-d480-4e82-8892-957fa0582932\', \'7206eba9-aaa4-43d4-bc94-5ced20b883e9\', \'bc5a43b8-204b-4afb-a85c-305a6b4b8a28\', \'a2e303ca-f3ef-46f3-90bc-494d7b253cb0\', \'1a818232-8ac5-4438-9483-e7e58eee386c\', \'fc7c8084-1092-4f38-abd3-f8253b17c33d\', \'d0577cde-c262-44e2-bd17-e8c85d2df5cc\', \'4cce5241-5521-4411-a1df-1722318e70e0\')) ORDER BY libraryItem.createdAt DESC LIMIT 0, 54;', ``` ### Additional Notes _No response_

adam added the bug label 2026-04-25 00:08:25 +02:00

adam closed this issue 2026-04-25 00:08:26 +02:00

adam commented 2026-04-25 00:08:26 +02:00

Author

Owner

Copy Link

Copy Source

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

I see exactly same error

@olegch commented on GitHub (Feb 12, 2025): I see exactly same error

adam commented 2026-04-25 00:08:26 +02:00

Author

Owner

Copy Link

Copy Source

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

I am getting a very similar error after upgrading to 2.19.1.

• Downgrading to 2.19.0 allows the search to function again.

I can open in the browser and app, but as soon as I attempt to use the search box, in either, it crashed with the error below:

[2025-02-11 22:54:03.875] FATAL: [Server] 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] {
    errno: 1,
    code: 'SQLITE_ERROR',
    sql: "SELECT `book`.`id`, `book`.`title`, `book`.`titleIgnorePrefix`, `book`.`subtitle`, `book`.`publishedYear`, `book`.`publishedDate`, `book`.`publisher`, `book`.`description`, `book`.`isbn`, `book`.`asin`, `book`.`language`, `book`.`explicit`, `book`.`abridged`, `book`.`coverPath`, `book`.`duration`, `book`.`narrators`, `book`.`audioFiles`, `book`.`ebookFile`, `book`.`chapters`, `book`.`tags`, `book`.`genres`, `book`.`createdAt`, `book`.`updatedAt`, `libraryItem`.`id` AS `libraryItem.id`, `libraryItem`.`ino` AS `libraryItem.ino`, `libraryItem`.`path` AS `libraryItem.path`, `libraryItem`.`relPath` AS `libraryItem.relPath`, `libraryItem`.`mediaId` AS `libraryItem.mediaId`, `libraryItem`.`mediaType` AS `libraryItem.mediaType`, `libraryItem`.`isFile` AS `libraryItem.isFile`, `libraryItem`.`isMissing` AS `libraryItem.isMissing`, `libraryItem`.`isInvalid` AS `libraryItem.isInvalid`, `libraryItem`.`mtime` AS `libraryItem.mtime`, `libraryItem`.`ctime` AS `libraryItem.ctime`, `libraryItem`.`birthtime` AS `libraryItem.birthtime`, `libraryItem`.`size` AS `libraryItem.size`, `libraryItem`.`lastScan` AS `libraryItem.lastScan`, `libraryItem`.`lastScanVersion` AS `libraryItem.lastScanVersion`, `libraryItem`.`libraryFiles` AS `libraryItem.libraryFiles`, `libraryItem`.`extraData` AS `libraryItem.extraData`, `libraryItem`.`title` AS `libraryItem.title`, `libraryItem`.`titleIgnorePrefix` AS `libraryItem.titleIgnorePrefix`, `libraryItem`.`createdAt` AS `libraryItem.createdAt`, `libraryItem`.`updatedAt` AS `libraryItem.updatedAt`, `libraryItem`.`libraryId` AS `libraryItem.libraryId`, `libraryItem`.`libraryFolderId` AS `libraryItem.libraryFolderId` FROM `books` AS `book` INNER JOIN `libraryItems` AS `libraryItem` ON `book`.`id` = `libraryItem`.`mediaId` AND (`libraryItem`.`libraryId` = 'f06138b9-f713-4fe9-ad09-e3fa7cf07f19' AND `libraryItem`.`mediaType` = 'book') WHERE ((unaccent(title) LIKE '%lee%' OR unaccent(subtitle) LIKE '%lee%' OR `book`.`asin` LIKE '%lee%' OR `book`.`isbn` LIKE '%lee%')) LIMIT 0, 3;"
  },
  original: [Error: SQLITE_ERROR: ambiguous column name: title] {
    errno: 1,
    code: 'SQLITE_ERROR',
    sql: "SELECT `book`.`id`, `book`.`title`, `book`.`titleIgnorePrefix`, `book`.`subtitle`, `book`.`publishedYear`, `book`.`publishedDate`, `book`.`publisher`, `book`.`description`, `book`.`isbn`, `book`.`asin`, `book`.`language`, `book`.`explicit`, `book`.`abridged`, `book`.`coverPath`, `book`.`duration`, `book`.`narrators`, `book`.`audioFiles`, `book`.`ebookFile`, `book`.`chapters`, `book`.`tags`, `book`.`genres`, `book`.`createdAt`, `book`.`updatedAt`, `libraryItem`.`id` AS `libraryItem.id`, `libraryItem`.`ino` AS `libraryItem.ino`, `libraryItem`.`path` AS `libraryItem.path`, `libraryItem`.`relPath` AS `libraryItem.relPath`, `libraryItem`.`mediaId` AS `libraryItem.mediaId`, `libraryItem`.`mediaType` AS `libraryItem.mediaType`, `libraryItem`.`isFile` AS `libraryItem.isFile`, `libraryItem`.`isMissing` AS `libraryItem.isMissing`, `libraryItem`.`isInvalid` AS `libraryItem.isInvalid`, `libraryItem`.`mtime` AS `libraryItem.mtime`, `libraryItem`.`ctime` AS `libraryItem.ctime`, `libraryItem`.`birthtime` AS `libraryItem.birthtime`, `libraryItem`.`size` AS `libraryItem.size`, `libraryItem`.`lastScan` AS `libraryItem.lastScan`, `libraryItem`.`lastScanVersion` AS `libraryItem.lastScanVersion`, `libraryItem`.`libraryFiles` AS `libraryItem.libraryFiles`, `libraryItem`.`extraData` AS `libraryItem.extraData`, `libraryItem`.`title` AS `libraryItem.title`, `libraryItem`.`titleIgnorePrefix` AS `libraryItem.titleIgnorePrefix`, `libraryItem`.`createdAt` AS `libraryItem.createdAt`, `libraryItem`.`updatedAt` AS `libraryItem.updatedAt`, `libraryItem`.`libraryId` AS `libraryItem.libraryId`, `libraryItem`.`libraryFolderId` AS `libraryItem.libraryFolderId` FROM `books` AS `book` INNER JOIN `libraryItems` AS `libraryItem` ON `book`.`id` = `libraryItem`.`mediaId` AND (`libraryItem`.`libraryId` = 'f06138b9-f713-4fe9-ad09-e3fa7cf07f19' AND `libraryItem`.`mediaType` = 'book') WHERE ((unaccent(title) LIKE '%lee%' OR unaccent(subtitle) LIKE '%lee%' OR `book`.`asin` LIKE '%lee%' OR `book`.`isbn` LIKE '%lee%')) LIMIT 0, 3;"
  },
  sql: "SELECT `book`.`id`, `book`.`title`, `book`.`titleIgnorePrefix`, `book`.`subtitle`, `book`.`publishedYear`, `book`.`publishedDate`, `book`.`publisher`, `book`.`description`, `book`.`isbn`, `book`.`asin`, `book`.`language`, `book`.`explicit`, `book`.`abridged`, `book`.`coverPath`, `book`.`duration`, `book`.`narrators`, `book`.`audioFiles`, `book`.`ebookFile`, `book`.`chapters`, `book`.`tags`, `book`.`genres`, `book`.`createdAt`, `book`.`updatedAt`, `libraryItem`.`id` AS `libraryItem.id`, `libraryItem`.`ino` AS `libraryItem.ino`, `libraryItem`.`path` AS `libraryItem.path`, `libraryItem`.`relPath` AS `libraryItem.relPath`, `libraryItem`.`mediaId` AS `libraryItem.mediaId`, `libraryItem`.`mediaType` AS `libraryItem.mediaType`, `libraryItem`.`isFile` AS `libraryItem.isFile`, `libraryItem`.`isMissing` AS `libraryItem.isMissing`, `libraryItem`.`isInvalid` AS `libraryItem.isInvalid`, `libraryItem`.`mtime` AS `libraryItem.mtime`, `libraryItem`.`ctime` AS `libraryItem.ctime`, `libraryItem`.`birthtime` AS `libraryItem.birthtime`, `libraryItem`.`size` AS `libraryItem.size`, `libraryItem`.`lastScan` AS `libraryItem.lastScan`, `libraryItem`.`lastScanVersion` AS `libraryItem.lastScanVersion`, `libraryItem`.`libraryFiles` AS `libraryItem.libraryFiles`, `libraryItem`.`extraData` AS `libraryItem.extraData`, `libraryItem`.`title` AS `libraryItem.title`, `libraryItem`.`titleIgnorePrefix` AS `libraryItem.titleIgnorePrefix`, `libraryItem`.`createdAt` AS `libraryItem.createdAt`, `libraryItem`.`updatedAt` AS `libraryItem.updatedAt`, `libraryItem`.`libraryId` AS `libraryItem.libraryId`, `libraryItem`.`libraryFolderId` AS `libraryItem.libraryFolderId` FROM `books` AS `book` INNER JOIN `libraryItems` AS `libraryItem` ON `book`.`id` = `libraryItem`.`mediaId` AND (`libraryItem`.`libraryId` = 'f06138b9-f713-4fe9-ad09-e3fa7cf07f19' AND `libraryItem`.`mediaType` = 'book') WHERE ((unaccent(title) LIKE '%lee%' OR unaccent(subtitle) LIKE '%lee%' OR `book`.`asin` LIKE '%lee%' OR `book`.`isbn` LIKE '%lee%')) LIMIT 0, 3;",
  parameters: {}
} 
promise: Promise {
  <rejected> 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] {
      errno: 1,
      code: 'SQLITE_ERROR',
      sql: "SELECT `book`.`id`, `book`.`title`, `book`.`titleIgnorePrefix`, `book`.`subtitle`, `book`.`publishedYear`, `book`.`publishedDate`, `book`.`publisher`, `book`.`description`, `book`.`isbn`, `book`.`asin`, `book`.`language`, `book`.`explicit`, `book`.`abridged`, `book`.`coverPath`, `book`.`duration`, `book`.`narrators`, `book`.`audioFiles`, `book`.`ebookFile`, `book`.`chapters`, `book`.`tags`, `book`.`genres`, `book`.`createdAt`, `book`.`updatedAt`, `libraryItem`.`id` AS `libraryItem.id`, `libraryItem`.`ino` AS `libraryItem.ino`, `libraryItem`.`path` AS `libraryItem.path`, `libraryItem`.`relPath` AS `libraryItem.relPath`, `libraryItem`.`mediaId` AS `libraryItem.mediaId`, `libraryItem`.`mediaType` AS `libraryItem.mediaType`, `libraryItem`.`isFile` AS `libraryItem.isFile`, `libraryItem`.`isMissing` AS `libraryItem.isMissing`, `libraryItem`.`isInvalid` AS `libraryItem.isInvalid`, `libraryItem`.`mtime` AS `libraryItem.mtime`, `libraryItem`.`ctime` AS `libraryItem.ctime`, `libraryItem`.`birthtime` AS `libraryItem.birthtime`, `libraryItem`.`size` AS `libraryItem.size`, `libraryItem`.`lastScan` AS `libraryItem.lastScan`, `libraryItem`.`lastScanVersion` AS `libraryItem.lastScanVersion`, `libraryItem`.`libraryFiles` AS `libraryItem.libraryFiles`, `libraryItem`.`extraData` AS `libraryItem.extraData`, `libraryItem`.`title` AS `libraryItem.title`, `libraryItem`.`titleIgnorePrefix` AS `libraryItem.titleIgnorePrefix`, `libraryItem`.`createdAt` AS `libraryItem.createdAt`, `libraryItem`.`updatedAt` AS `libraryItem.updatedAt`, `libraryItem`.`libraryId` AS `libraryItem.libraryId`, `libraryItem`.`libraryFolderId` AS `libraryItem.libraryFolderId` FROM `books` AS `book` INNER JOIN `libraryItems` AS `libraryItem` ON `book`.`id` = `libraryItem`.`mediaId` AND (`libraryItem`.`libraryId` = 'f06138b9-f713-4fe9-ad09-e3fa7cf07f19' AND `libraryItem`.`mediaType` = 'book') WHERE ((unaccent(title) LIKE '%lee%' OR unaccent(subtitle) LIKE '%lee%' OR `book`.`asin` LIKE '%lee%' OR `book`.`isbn` LIKE '%lee%')) LIMIT 0, 3;"
    },
    original: [Error: SQLITE_ERROR: ambiguous column name: title] {
      errno: 1,
      code: 'SQLITE_ERROR',
      sql: "SELECT `book`.`id`, `book`.`title`, `book`.`titleIgnorePrefix`, `book`.`subtitle`, `book`.`publishedYear`, `book`.`publishedDate`, `book`.`publisher`, `book`.`description`, `book`.`isbn`, `book`.`asin`, `book`.`language`, `book`.`explicit`, `book`.`abridged`, `book`.`coverPath`, `book`.`duration`, `book`.`narrators`, `book`.`audioFiles`, `book`.`ebookFile`, `book`.`chapters`, `book`.`tags`, `book`.`genres`, `book`.`createdAt`, `book`.`updatedAt`, `libraryItem`.`id` AS `libraryItem.id`, `libraryItem`.`ino` AS `libraryItem.ino`, `libraryItem`.`path` AS `libraryItem.path`, `libraryItem`.`relPath` AS `libraryItem.relPath`, `libraryItem`.`mediaId` AS `libraryItem.mediaId`, `libraryItem`.`mediaType` AS `libraryItem.mediaType`, `libraryItem`.`isFile` AS `libraryItem.isFile`, `libraryItem`.`isMissing` AS `libraryItem.isMissing`, `libraryItem`.`isInvalid` AS `libraryItem.isInvalid`, `libraryItem`.`mtime` AS `libraryItem.mtime`, `libraryItem`.`ctime` AS `libraryItem.ctime`, `libraryItem`.`birthtime` AS `libraryItem.birthtime`, `libraryItem`.`size` AS `libraryItem.size`, `libraryItem`.`lastScan` AS `libraryItem.lastScan`, `libraryItem`.`lastScanVersion` AS `libraryItem.lastScanVersion`, `libraryItem`.`libraryFiles` AS `libraryItem.libraryFiles`, `libraryItem`.`extraData` AS `libraryItem.extraData`, `libraryItem`.`title` AS `libraryItem.title`, `libraryItem`.`titleIgnorePrefix` AS `libraryItem.titleIgnorePrefix`, `libraryItem`.`createdAt` AS `libraryItem.createdAt`, `libraryItem`.`updatedAt` AS `libraryItem.updatedAt`, `libraryItem`.`libraryId` AS `libraryItem.libraryId`, `libraryItem`.`libraryFolderId` AS `libraryItem.libraryFolderId` FROM `books` AS `book` INNER JOIN `libraryItems` AS `libraryItem` ON `book`.`id` = `libraryItem`.`mediaId` AND (`libraryItem`.`libraryId` = 'f06138b9-f713-4fe9-ad09-e3fa7cf07f19' AND `libraryItem`.`mediaType` = 'book') WHERE ((unaccent(title) LIKE '%lee%' OR unaccent(subtitle) LIKE '%lee%' OR `book`.`asin` LIKE '%lee%' OR `book`.`isbn` LIKE '%lee%')) LIMIT 0, 3;"
    },
    sql: "SELECT `book`.`id`, `book`.`title`, `book`.`titleIgnorePrefix`, `book`.`subtitle`, `book`.`publishedYear`, `book`.`publishedDate`, `book`.`publisher`, `book`.`description`, `book`.`isbn`, `book`.`asin`, `book`.`language`, `book`.`explicit`, `book`.`abridged`, `book`.`coverPath`, `book`.`duration`, `book`.`narrators`, `book`.`audioFiles`, `book`.`ebookFile`, `book`.`chapters`, `book`.`tags`, `book`.`genres`, `book`.`createdAt`, `book`.`updatedAt`, `libraryItem`.`id` AS `libraryItem.id`, `libraryItem`.`ino` AS `libraryItem.ino`, `libraryItem`.`path` AS `libraryItem.path`, `libraryItem`.`relPath` AS `libraryItem.relPath`, `libraryItem`.`mediaId` AS `libraryItem.mediaId`, `libraryItem`.`mediaType` AS `libraryItem.mediaType`, `libraryItem`.`isFile` AS `libraryItem.isFile`, `libraryItem`.`isMissing` AS `libraryItem.isMissing`, `libraryItem`.`isInvalid` AS `libraryItem.isInvalid`, `libraryItem`.`mtime` AS `libraryItem.mtime`, `libraryItem`.`ctime` AS `libraryItem.ctime`, `libraryItem`.`birthtime` AS `libraryItem.birthtime`, `libraryItem`.`size` AS `libraryItem.size`, `libraryItem`.`lastScan` AS `libraryItem.lastScan`, `libraryItem`.`lastScanVersion` AS `libraryItem.lastScanVersion`, `libraryItem`.`libraryFiles` AS `libraryItem.libraryFiles`, `libraryItem`.`extraData` AS `libraryItem.extraData`, `libraryItem`.`title` AS `libraryItem.title`, `libraryItem`.`titleIgnorePrefix` AS `libraryItem.titleIgnorePrefix`, `libraryItem`.`createdAt` AS `libraryItem.createdAt`, `libraryItem`.`updatedAt` AS `libraryItem.updatedAt`, `libraryItem`.`libraryId` AS `libraryItem.libraryId`, `libraryItem`.`libraryFolderId` AS `libraryItem.libraryFolderId` FROM `books` AS `book` INNER JOIN `libraryItems` AS `libraryItem` ON `book`.`id` = `libraryItem`.`mediaId` AND (`libraryItem`.`libraryId` = 'f06138b9-f713-4fe9-ad09-e3fa7cf07f19' AND `libraryItem`.`mediaType` = 'book') WHERE ((unaccent(title) LIKE '%lee%' OR unaccent(subtitle) LIKE '%lee%' OR `book`.`asin` LIKE '%lee%' OR `book`.`isbn` LIKE '%lee%')) LIMIT 0, 3;",
    parameters: {}
  }
}

@mkentala commented on GitHub (Feb 12, 2025): I am getting a very similar error after upgrading to `2.19.1`. - Downgrading to `2.19.0` allows the `search` to function again. I can open in the browser and app, but as soon as I attempt to use the `search` box, in either, it crashed with the error below: ``` [2025-02-11 22:54:03.875] FATAL: [Server] 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] { errno: 1, code: 'SQLITE_ERROR', sql: "SELECT `book`.`id`, `book`.`title`, `book`.`titleIgnorePrefix`, `book`.`subtitle`, `book`.`publishedYear`, `book`.`publishedDate`, `book`.`publisher`, `book`.`description`, `book`.`isbn`, `book`.`asin`, `book`.`language`, `book`.`explicit`, `book`.`abridged`, `book`.`coverPath`, `book`.`duration`, `book`.`narrators`, `book`.`audioFiles`, `book`.`ebookFile`, `book`.`chapters`, `book`.`tags`, `book`.`genres`, `book`.`createdAt`, `book`.`updatedAt`, `libraryItem`.`id` AS `libraryItem.id`, `libraryItem`.`ino` AS `libraryItem.ino`, `libraryItem`.`path` AS `libraryItem.path`, `libraryItem`.`relPath` AS `libraryItem.relPath`, `libraryItem`.`mediaId` AS `libraryItem.mediaId`, `libraryItem`.`mediaType` AS `libraryItem.mediaType`, `libraryItem`.`isFile` AS `libraryItem.isFile`, `libraryItem`.`isMissing` AS `libraryItem.isMissing`, `libraryItem`.`isInvalid` AS `libraryItem.isInvalid`, `libraryItem`.`mtime` AS `libraryItem.mtime`, `libraryItem`.`ctime` AS `libraryItem.ctime`, `libraryItem`.`birthtime` AS `libraryItem.birthtime`, `libraryItem`.`size` AS `libraryItem.size`, `libraryItem`.`lastScan` AS `libraryItem.lastScan`, `libraryItem`.`lastScanVersion` AS `libraryItem.lastScanVersion`, `libraryItem`.`libraryFiles` AS `libraryItem.libraryFiles`, `libraryItem`.`extraData` AS `libraryItem.extraData`, `libraryItem`.`title` AS `libraryItem.title`, `libraryItem`.`titleIgnorePrefix` AS `libraryItem.titleIgnorePrefix`, `libraryItem`.`createdAt` AS `libraryItem.createdAt`, `libraryItem`.`updatedAt` AS `libraryItem.updatedAt`, `libraryItem`.`libraryId` AS `libraryItem.libraryId`, `libraryItem`.`libraryFolderId` AS `libraryItem.libraryFolderId` FROM `books` AS `book` INNER JOIN `libraryItems` AS `libraryItem` ON `book`.`id` = `libraryItem`.`mediaId` AND (`libraryItem`.`libraryId` = 'f06138b9-f713-4fe9-ad09-e3fa7cf07f19' AND `libraryItem`.`mediaType` = 'book') WHERE ((unaccent(title) LIKE '%lee%' OR unaccent(subtitle) LIKE '%lee%' OR `book`.`asin` LIKE '%lee%' OR `book`.`isbn` LIKE '%lee%')) LIMIT 0, 3;" }, original: [Error: SQLITE_ERROR: ambiguous column name: title] { errno: 1, code: 'SQLITE_ERROR', sql: "SELECT `book`.`id`, `book`.`title`, `book`.`titleIgnorePrefix`, `book`.`subtitle`, `book`.`publishedYear`, `book`.`publishedDate`, `book`.`publisher`, `book`.`description`, `book`.`isbn`, `book`.`asin`, `book`.`language`, `book`.`explicit`, `book`.`abridged`, `book`.`coverPath`, `book`.`duration`, `book`.`narrators`, `book`.`audioFiles`, `book`.`ebookFile`, `book`.`chapters`, `book`.`tags`, `book`.`genres`, `book`.`createdAt`, `book`.`updatedAt`, `libraryItem`.`id` AS `libraryItem.id`, `libraryItem`.`ino` AS `libraryItem.ino`, `libraryItem`.`path` AS `libraryItem.path`, `libraryItem`.`relPath` AS `libraryItem.relPath`, `libraryItem`.`mediaId` AS `libraryItem.mediaId`, `libraryItem`.`mediaType` AS `libraryItem.mediaType`, `libraryItem`.`isFile` AS `libraryItem.isFile`, `libraryItem`.`isMissing` AS `libraryItem.isMissing`, `libraryItem`.`isInvalid` AS `libraryItem.isInvalid`, `libraryItem`.`mtime` AS `libraryItem.mtime`, `libraryItem`.`ctime` AS `libraryItem.ctime`, `libraryItem`.`birthtime` AS `libraryItem.birthtime`, `libraryItem`.`size` AS `libraryItem.size`, `libraryItem`.`lastScan` AS `libraryItem.lastScan`, `libraryItem`.`lastScanVersion` AS `libraryItem.lastScanVersion`, `libraryItem`.`libraryFiles` AS `libraryItem.libraryFiles`, `libraryItem`.`extraData` AS `libraryItem.extraData`, `libraryItem`.`title` AS `libraryItem.title`, `libraryItem`.`titleIgnorePrefix` AS `libraryItem.titleIgnorePrefix`, `libraryItem`.`createdAt` AS `libraryItem.createdAt`, `libraryItem`.`updatedAt` AS `libraryItem.updatedAt`, `libraryItem`.`libraryId` AS `libraryItem.libraryId`, `libraryItem`.`libraryFolderId` AS `libraryItem.libraryFolderId` FROM `books` AS `book` INNER JOIN `libraryItems` AS `libraryItem` ON `book`.`id` = `libraryItem`.`mediaId` AND (`libraryItem`.`libraryId` = 'f06138b9-f713-4fe9-ad09-e3fa7cf07f19' AND `libraryItem`.`mediaType` = 'book') WHERE ((unaccent(title) LIKE '%lee%' OR unaccent(subtitle) LIKE '%lee%' OR `book`.`asin` LIKE '%lee%' OR `book`.`isbn` LIKE '%lee%')) LIMIT 0, 3;" }, sql: "SELECT `book`.`id`, `book`.`title`, `book`.`titleIgnorePrefix`, `book`.`subtitle`, `book`.`publishedYear`, `book`.`publishedDate`, `book`.`publisher`, `book`.`description`, `book`.`isbn`, `book`.`asin`, `book`.`language`, `book`.`explicit`, `book`.`abridged`, `book`.`coverPath`, `book`.`duration`, `book`.`narrators`, `book`.`audioFiles`, `book`.`ebookFile`, `book`.`chapters`, `book`.`tags`, `book`.`genres`, `book`.`createdAt`, `book`.`updatedAt`, `libraryItem`.`id` AS `libraryItem.id`, `libraryItem`.`ino` AS `libraryItem.ino`, `libraryItem`.`path` AS `libraryItem.path`, `libraryItem`.`relPath` AS `libraryItem.relPath`, `libraryItem`.`mediaId` AS `libraryItem.mediaId`, `libraryItem`.`mediaType` AS `libraryItem.mediaType`, `libraryItem`.`isFile` AS `libraryItem.isFile`, `libraryItem`.`isMissing` AS `libraryItem.isMissing`, `libraryItem`.`isInvalid` AS `libraryItem.isInvalid`, `libraryItem`.`mtime` AS `libraryItem.mtime`, `libraryItem`.`ctime` AS `libraryItem.ctime`, `libraryItem`.`birthtime` AS `libraryItem.birthtime`, `libraryItem`.`size` AS `libraryItem.size`, `libraryItem`.`lastScan` AS `libraryItem.lastScan`, `libraryItem`.`lastScanVersion` AS `libraryItem.lastScanVersion`, `libraryItem`.`libraryFiles` AS `libraryItem.libraryFiles`, `libraryItem`.`extraData` AS `libraryItem.extraData`, `libraryItem`.`title` AS `libraryItem.title`, `libraryItem`.`titleIgnorePrefix` AS `libraryItem.titleIgnorePrefix`, `libraryItem`.`createdAt` AS `libraryItem.createdAt`, `libraryItem`.`updatedAt` AS `libraryItem.updatedAt`, `libraryItem`.`libraryId` AS `libraryItem.libraryId`, `libraryItem`.`libraryFolderId` AS `libraryItem.libraryFolderId` FROM `books` AS `book` INNER JOIN `libraryItems` AS `libraryItem` ON `book`.`id` = `libraryItem`.`mediaId` AND (`libraryItem`.`libraryId` = 'f06138b9-f713-4fe9-ad09-e3fa7cf07f19' AND `libraryItem`.`mediaType` = 'book') WHERE ((unaccent(title) LIKE '%lee%' OR unaccent(subtitle) LIKE '%lee%' OR `book`.`asin` LIKE '%lee%' OR `book`.`isbn` LIKE '%lee%')) LIMIT 0, 3;", parameters: {} } promise: Promise { <rejected> 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] { errno: 1, code: 'SQLITE_ERROR', sql: "SELECT `book`.`id`, `book`.`title`, `book`.`titleIgnorePrefix`, `book`.`subtitle`, `book`.`publishedYear`, `book`.`publishedDate`, `book`.`publisher`, `book`.`description`, `book`.`isbn`, `book`.`asin`, `book`.`language`, `book`.`explicit`, `book`.`abridged`, `book`.`coverPath`, `book`.`duration`, `book`.`narrators`, `book`.`audioFiles`, `book`.`ebookFile`, `book`.`chapters`, `book`.`tags`, `book`.`genres`, `book`.`createdAt`, `book`.`updatedAt`, `libraryItem`.`id` AS `libraryItem.id`, `libraryItem`.`ino` AS `libraryItem.ino`, `libraryItem`.`path` AS `libraryItem.path`, `libraryItem`.`relPath` AS `libraryItem.relPath`, `libraryItem`.`mediaId` AS `libraryItem.mediaId`, `libraryItem`.`mediaType` AS `libraryItem.mediaType`, `libraryItem`.`isFile` AS `libraryItem.isFile`, `libraryItem`.`isMissing` AS `libraryItem.isMissing`, `libraryItem`.`isInvalid` AS `libraryItem.isInvalid`, `libraryItem`.`mtime` AS `libraryItem.mtime`, `libraryItem`.`ctime` AS `libraryItem.ctime`, `libraryItem`.`birthtime` AS `libraryItem.birthtime`, `libraryItem`.`size` AS `libraryItem.size`, `libraryItem`.`lastScan` AS `libraryItem.lastScan`, `libraryItem`.`lastScanVersion` AS `libraryItem.lastScanVersion`, `libraryItem`.`libraryFiles` AS `libraryItem.libraryFiles`, `libraryItem`.`extraData` AS `libraryItem.extraData`, `libraryItem`.`title` AS `libraryItem.title`, `libraryItem`.`titleIgnorePrefix` AS `libraryItem.titleIgnorePrefix`, `libraryItem`.`createdAt` AS `libraryItem.createdAt`, `libraryItem`.`updatedAt` AS `libraryItem.updatedAt`, `libraryItem`.`libraryId` AS `libraryItem.libraryId`, `libraryItem`.`libraryFolderId` AS `libraryItem.libraryFolderId` FROM `books` AS `book` INNER JOIN `libraryItems` AS `libraryItem` ON `book`.`id` = `libraryItem`.`mediaId` AND (`libraryItem`.`libraryId` = 'f06138b9-f713-4fe9-ad09-e3fa7cf07f19' AND `libraryItem`.`mediaType` = 'book') WHERE ((unaccent(title) LIKE '%lee%' OR unaccent(subtitle) LIKE '%lee%' OR `book`.`asin` LIKE '%lee%' OR `book`.`isbn` LIKE '%lee%')) LIMIT 0, 3;" }, original: [Error: SQLITE_ERROR: ambiguous column name: title] { errno: 1, code: 'SQLITE_ERROR', sql: "SELECT `book`.`id`, `book`.`title`, `book`.`titleIgnorePrefix`, `book`.`subtitle`, `book`.`publishedYear`, `book`.`publishedDate`, `book`.`publisher`, `book`.`description`, `book`.`isbn`, `book`.`asin`, `book`.`language`, `book`.`explicit`, `book`.`abridged`, `book`.`coverPath`, `book`.`duration`, `book`.`narrators`, `book`.`audioFiles`, `book`.`ebookFile`, `book`.`chapters`, `book`.`tags`, `book`.`genres`, `book`.`createdAt`, `book`.`updatedAt`, `libraryItem`.`id` AS `libraryItem.id`, `libraryItem`.`ino` AS `libraryItem.ino`, `libraryItem`.`path` AS `libraryItem.path`, `libraryItem`.`relPath` AS `libraryItem.relPath`, `libraryItem`.`mediaId` AS `libraryItem.mediaId`, `libraryItem`.`mediaType` AS `libraryItem.mediaType`, `libraryItem`.`isFile` AS `libraryItem.isFile`, `libraryItem`.`isMissing` AS `libraryItem.isMissing`, `libraryItem`.`isInvalid` AS `libraryItem.isInvalid`, `libraryItem`.`mtime` AS `libraryItem.mtime`, `libraryItem`.`ctime` AS `libraryItem.ctime`, `libraryItem`.`birthtime` AS `libraryItem.birthtime`, `libraryItem`.`size` AS `libraryItem.size`, `libraryItem`.`lastScan` AS `libraryItem.lastScan`, `libraryItem`.`lastScanVersion` AS `libraryItem.lastScanVersion`, `libraryItem`.`libraryFiles` AS `libraryItem.libraryFiles`, `libraryItem`.`extraData` AS `libraryItem.extraData`, `libraryItem`.`title` AS `libraryItem.title`, `libraryItem`.`titleIgnorePrefix` AS `libraryItem.titleIgnorePrefix`, `libraryItem`.`createdAt` AS `libraryItem.createdAt`, `libraryItem`.`updatedAt` AS `libraryItem.updatedAt`, `libraryItem`.`libraryId` AS `libraryItem.libraryId`, `libraryItem`.`libraryFolderId` AS `libraryItem.libraryFolderId` FROM `books` AS `book` INNER JOIN `libraryItems` AS `libraryItem` ON `book`.`id` = `libraryItem`.`mediaId` AND (`libraryItem`.`libraryId` = 'f06138b9-f713-4fe9-ad09-e3fa7cf07f19' AND `libraryItem`.`mediaType` = 'book') WHERE ((unaccent(title) LIKE '%lee%' OR unaccent(subtitle) LIKE '%lee%' OR `book`.`asin` LIKE '%lee%' OR `book`.`isbn` LIKE '%lee%')) LIMIT 0, 3;" }, sql: "SELECT `book`.`id`, `book`.`title`, `book`.`titleIgnorePrefix`, `book`.`subtitle`, `book`.`publishedYear`, `book`.`publishedDate`, `book`.`publisher`, `book`.`description`, `book`.`isbn`, `book`.`asin`, `book`.`language`, `book`.`explicit`, `book`.`abridged`, `book`.`coverPath`, `book`.`duration`, `book`.`narrators`, `book`.`audioFiles`, `book`.`ebookFile`, `book`.`chapters`, `book`.`tags`, `book`.`genres`, `book`.`createdAt`, `book`.`updatedAt`, `libraryItem`.`id` AS `libraryItem.id`, `libraryItem`.`ino` AS `libraryItem.ino`, `libraryItem`.`path` AS `libraryItem.path`, `libraryItem`.`relPath` AS `libraryItem.relPath`, `libraryItem`.`mediaId` AS `libraryItem.mediaId`, `libraryItem`.`mediaType` AS `libraryItem.mediaType`, `libraryItem`.`isFile` AS `libraryItem.isFile`, `libraryItem`.`isMissing` AS `libraryItem.isMissing`, `libraryItem`.`isInvalid` AS `libraryItem.isInvalid`, `libraryItem`.`mtime` AS `libraryItem.mtime`, `libraryItem`.`ctime` AS `libraryItem.ctime`, `libraryItem`.`birthtime` AS `libraryItem.birthtime`, `libraryItem`.`size` AS `libraryItem.size`, `libraryItem`.`lastScan` AS `libraryItem.lastScan`, `libraryItem`.`lastScanVersion` AS `libraryItem.lastScanVersion`, `libraryItem`.`libraryFiles` AS `libraryItem.libraryFiles`, `libraryItem`.`extraData` AS `libraryItem.extraData`, `libraryItem`.`title` AS `libraryItem.title`, `libraryItem`.`titleIgnorePrefix` AS `libraryItem.titleIgnorePrefix`, `libraryItem`.`createdAt` AS `libraryItem.createdAt`, `libraryItem`.`updatedAt` AS `libraryItem.updatedAt`, `libraryItem`.`libraryId` AS `libraryItem.libraryId`, `libraryItem`.`libraryFolderId` AS `libraryItem.libraryFolderId` FROM `books` AS `book` INNER JOIN `libraryItems` AS `libraryItem` ON `book`.`id` = `libraryItem`.`mediaId` AND (`libraryItem`.`libraryId` = 'f06138b9-f713-4fe9-ad09-e3fa7cf07f19' AND `libraryItem`.`mediaType` = 'book') WHERE ((unaccent(title) LIKE '%lee%' OR unaccent(subtitle) LIKE '%lee%' OR `book`.`asin` LIKE '%lee%' OR `book`.`isbn` LIKE '%lee%')) LIMIT 0, 3;", parameters: {} } } ```

adam commented 2026-04-25 00:08:26 +02:00

Author

Owner

Copy Link

Copy Source

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

I am receiving the exact same error :(

@drexxy01 commented on GitHub (Feb 12, 2025): I am receiving the exact same error :(

adam commented 2026-04-25 00:08:26 +02:00

Author

Owner

Copy Link

Copy Source

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

Sorry about this. Will send a fix soon.

@mikiher commented on GitHub (Feb 12, 2025): Sorry about this. Will send a fix soon.

adam commented 2026-04-25 00:08:27 +02:00

Author

Owner

Copy Link

Copy Source

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

Getting similar behaviour in Unraid docker container with server crashing. Able to connect locally and remotely but as soon as I open Podcasts library view, the container crashes.

@DrBazUK commented on GitHub (Feb 12, 2025): Getting similar behaviour in Unraid docker container with server crashing. Able to connect locally and remotely but as soon as I open Podcasts library view, the container crashes.

adam commented 2026-04-25 00:08:27 +02:00

Author

Owner

Copy Link

Copy Source

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

Debian downgrade guide

If you are on debian and need to downgrade, you can use:

sudo apt-get install audiobookshelf="2.19.0"

General Warning: Always check for possible migrations in the previous update(s), which may or may not work when downgrading.
A downgrade without the proper destructive-migrations might result in invalid database states.

Use on your own risk!

@xcy7e commented on GitHub (Feb 12, 2025): ### Debian downgrade guide If you are on debian and need to downgrade, you can use: ```bash sudo apt-get install audiobookshelf="2.19.0" ``` > **General Warning:** Always check for possible migrations in the previous update(s), which may or may not work when downgrading. > A downgrade without the proper destructive-migrations might result in invalid database states. Use on your own risk!

adam commented 2026-04-25 00:08:27 +02:00

Author

Owner

Copy Link

Copy Source

@github-actions[bot] commented on GitHub (Feb 12, 2025):

Fixed in v2.19.2.

@github-actions[bot] commented on GitHub (Feb 12, 2025): Fixed in [v2.19.2](https://github.com/advplyr/audiobookshelf/releases/tag/v2.19.2).

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

master

book_tags_genres_dedupe

episode_download_fallback

Issue-4540-SortBy-StartedDate-and-FinishedDate

episode_meta_tagging

fix_authorize_race_condition

redirect_transcode_requests

progress_updated_sort

fix_ereader_socket_event

fix_change_empty_root_password

fix_podcast_session_track_index

fix_set_token

session_modal_user

localize_durations

fix_oidc_create_user

jwt_auth_refactor

fix_scanner_deleting_single_file_books

fix_mediaprogress_updatedat_2

experimental_next_client

podcast_episode_duration

episode-timestamps-clickable

book_author_secondary_sort_title

podcast_useragents

pathexists_user_access

fix_pathexists_join

book_author_secondary_sort

clean_duplicate_mediaprogress

sanitize_html_description

trix_prevent_attachments

check_path_api_fix

fix_mediaprogress_updatedat

increase_express_json_limit

fix_dockerfile_nunicode

search_episodes

audiobook_tools_update

episode_secondary_sorts

hls_stream_url_update

new_session_track_endpoint

audiobook_tools_enhancements

watcher_rescans_update

player_track_tooltip

fix_exclude_prefixes_crash

socket_item_events

fix_podcast_episode_scanner_promise

new_stats_controller

count_cache_for_userpermissions

parsing-opf-v3

validate_migration_files

fix-quick-match-all-crash

fix-chapter-end-sleep-timer

stringify_sequelize_query

remove-col-ambiguity

fix_next_prev_edit_description

details_trim_whitespace

fix_content_url_basepath

fix_logger_fatal

progress_bar_visibility

batch-edit-populate-map-details

feed_generator_updates

bookmark-modal-updates

migrate-library-item-in-scanner

migrate-new-library-items

migrate-podcasts-new-library-item-2

migrate-podcasts-new-library-item

fix-remove-episode-from-playlist

playback-session-use-new-library-item

refactor-library-item

fix-heatmap-caption

feed-episodes-upsert

share-media-player-media-session-api

remove-old-playlist

remove_old_collection_object

plugin-implementation-demo

feed_migration

refactor-feeds-from-item

fix_remove_authors_no_books

v2.17.3-fk-constraints-migration

migrations-first-upgrade

sqlite_2

feature/nuxt-target-server

waveform

sqlite

playlists

video

v2.35.1

v2.35.0

v2.34.0

v2.33.2

v2.33.1

v2.33.0

v2.32.1

v2.32.0

v2.31.0

v2.30.0

v2.29.0

v2.28.0

v2.27.0

v2.26.3

v2.26.2

v2.26.1

v2.26.0

v2.25.1

v2.25.0

v2.24.0

v2.23.0

v2.22.0

v2.21.0

v2.20.0

v2.19.5

v2.19.4

v2.19.3

v2.19.2

v2.19.1

v2.19.0

v2.18.1

v2.18.0

v2.17.7

v2.17.6

v2.17.5

v2.17.4

v2.17.3

v2.17.2

v2.17.1

v2.17.0

v2.16.2

v2.16.1

v2.16.0

v2.15.1

v2.15.0

v2.14.0

v2.13.4

v2.13.3

v2.13.2

v2.13.1

v2.13.0

v2.12.3

v2.12.2

v2.12.1

v2.12.0

v2.11.0

v2.10.1

v2.10.0

v2.9.0

v2.8.1

v2.8.0

v2.7.2

v2.7.1

v2.7.0

v2.6.0

v2.5.0

v2.4.4

v2.4.3

v2.4.2

v2.4.1

v2.4.0

v2.3.5

v2.3.4

v2.3.3

v2.3.2

v2.3.1

v2.3.0

v2.2.23

v2.2.22

v2.2.21

v2.2.20

v2.2.19

v2.2.18

v2.2.17

v2.2.16

v2.2.15

v2.2.14

v2.2.13

v2.2.12

v2.2.11

v2.2.10

v2.2.9

v2.2.8

v2.2.7

v2.2.6

v2.2.5

v2.2.4

v2.2.3

v2.2.2

v2.2.1

v2.2.0

v2.1.5

v2.1.4

v2.1.3

v2.1.2

v2.1.1

v2.1.0

v2.0.24

v2.0.23

v2.0.22

v2.0.21

v2.0.20

v2.0.19

v2.0.18

v2.0.17

v2.0.16

v2.0.15

v2.0.14

v2.0.13

v2.0.12

v2.0.11

v2.0.10

v2.0.9

v2.0.8

v2.0.7

v2.0.6

v2.0.5

v2.0.4

v2.0.3

v2.0.2

v2.0.1

v1.7.2

v1.7.1

v1.7.0

v1.6.0

v1.5.5

v1.5.0

v1.4.11

v1.4.9

v1.4.7

v1.4.6

v1.4.4

v1.4.2

v1.4.0

v1.4.1

v1.3.4

v1.3.3

v1.3.1

v1.2.8

v1.2.6

v1.2.5

v1.2.4

v1.2.1

v1.1.15

v1.1.14

v1.1.13

v1.1.12

v1.1.11

v1.1.10

v1.1.9

v1.1.8

v1.0.0

0.9.61-beta.0

0.9.61-beta

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

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/audiobookshelf#2563