SQL error after updating #4418

Closed
opened 2026-02-05 08:51:00 +03:00 by OVERLORD · 2 comments
Owner

Originally created by @magaiverpr on GitHub (Jan 19, 2024).

Describe the Bug

Hello,

After updating 23.10.4 to 23.12.1, I cannot create books anymore. Reverting to 23.10.4 resolve the problem.

Message error after enabling APP_DEBUG=TRUE:

Illuminate\Database\QueryException
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'description_html' in 'field list' (SQL: insert into books (name, description_html, description, created_by, updated_by, owned_by, slug, updated_at, created_at) values (Encaminhador de emails, , , 3, 3, 3, encaminhador-de-emails, 2024-01-19 16:19:12, 2024-01-19 16:19:12))

Steps to Reproduce

  • Update to 23.12.1
  • Try to create a new book

Expected Behaviour

Create the book normally

Screenshots or Additional Context

Using Container in Azure ambient.
image used: lscr.io/linuxserver/bookstack:23.12.1

Browser Details

Edge

Exact BookStack Version

23.12.1

Originally created by @magaiverpr on GitHub (Jan 19, 2024). ### Describe the Bug Hello, After updating 23.10.4 to 23.12.1, I cannot create books anymore. Reverting to 23.10.4 resolve the problem. Message error after enabling APP_DEBUG=TRUE: Illuminate\Database\QueryException SQLSTATE[42S22]: Column not found: 1054 Unknown column 'description_html' in 'field list' (SQL: insert into `books` (`name`, `description_html`, `description`, `created_by`, `updated_by`, `owned_by`, `slug`, `updated_at`, `created_at`) values (Encaminhador de emails, , , 3, 3, 3, encaminhador-de-emails, 2024-01-19 16:19:12, 2024-01-19 16:19:12)) ### Steps to Reproduce - Update to 23.12.1 - Try to create a new book ### Expected Behaviour Create the book normally ### Screenshots or Additional Context Using Container in Azure ambient. image used: lscr.io/linuxserver/bookstack:23.12.1 ### Browser Details Edge ### Exact BookStack Version 23.12.1
OVERLORD added the 🐛 Bug label 2026-02-05 08:51:00 +03:00
Author
Owner

@ssddanbrown commented on GitHub (Jan 19, 2024):

Check the container logs when starting your bookstack container.
The error indicates the database has not been updated to the expected format, which is a process that runs at start-up for that container image.

@ssddanbrown commented on GitHub (Jan 19, 2024): Check the container logs when starting your bookstack container. The error indicates the database has not been updated to the expected format, which is a process that runs at start-up for that container image.
Author
Owner

@magaiverpr commented on GitHub (Jan 19, 2024):

Thanks!

Had to set up sql_generate_invisible_primary_key=OFF in mysql

@magaiverpr commented on GitHub (Jan 19, 2024): Thanks! Had to set up sql_generate_invisible_primary_key=OFF in mysql
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/BookStack#4418