Problem with update to Bookstack 25.11.0 #5492

New Issue

OVERLORD · 2026-02-05T10:06:45+03:00

OVERLORD commented

2026-02-05 10:06:45 +03:00

Originally created by @reddexx on GitHub (Nov 11, 2025).

Attempted Debugging

I have read the debugging page

Searched GitHub Issues

I have searched GitHub for the issue.

Describe the Scenario

Hi after update come this SQL Error, missing a Column (entities.id)

I used the Repo from
solidnerd/docker-bookstack

Exact BookStack Version

25.11.0

Log Content

SQL Error
Illuminate\Database\QueryException
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entities.id' in 'on clause' (Connection: mysql, SQL: select * from `entities` left join `entity_page_data` on `entity_page_data`.`page_id` = `entities`.`id` where (`draft` = 0 or (`draft` = 1 and `owned_by` = 3)) and (exists (select `entity_id`, `entity_type`, max(owner_id) as owner_id, max(status) as status from `joint_permissions` where `entities`.`id` = `joint_permissions`.`entity_id` and `joint_permissions`.`entity_type` = page and `role_id` in (1, 18, 22) group by `entity_type`, `entity_id` having (status IN (1, 3) or (owner_id = 3 and status != 2)))) and exists (select * from `entities` as `laravel_reserved_0` left join `entity_container_data` on `entity_container_data`.`entity_id` = `entities`.`id` and `entity_container_data`.`entity_type` = book where `laravel_reserved_0`.`id` = `entities`.`book_id` and `slug` = windows-server and `type` = book) and `slug` = windows-fehlercode-liste and `type` = page and `entities`.`deleted_at` is null limit 1)

Hosting Environment

Docker Container from Repo: solidnerd/docker-bookstack

Originally created by @reddexx on GitHub (Nov 11, 2025). ### Attempted Debugging - [x] I have read the debugging page ### Searched GitHub Issues - [x] I have searched GitHub for the issue. ### Describe the Scenario Hi after update come this SQL Error, missing a Column (entities.id) I used the Repo from solidnerd/docker-bookstack ### Exact BookStack Version 25.11.0 ### Log Content ```text SQL Error Illuminate\Database\QueryException SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entities.id' in 'on clause' (Connection: mysql, SQL: select * from `entities` left join `entity_page_data` on `entity_page_data`.`page_id` = `entities`.`id` where (`draft` = 0 or (`draft` = 1 and `owned_by` = 3)) and (exists (select `entity_id`, `entity_type`, max(owner_id) as owner_id, max(status) as status from `joint_permissions` where `entities`.`id` = `joint_permissions`.`entity_id` and `joint_permissions`.`entity_type` = page and `role_id` in (1, 18, 22) group by `entity_type`, `entity_id` having (status IN (1, 3) or (owner_id = 3 and status != 2)))) and exists (select * from `entities` as `laravel_reserved_0` left join `entity_container_data` on `entity_container_data`.`entity_id` = `entities`.`id` and `entity_container_data`.`entity_type` = book where `laravel_reserved_0`.`id` = `entities`.`book_id` and `slug` = windows-server and `type` = book) and `slug` = windows-fehlercode-liste and `type` = page and `entities`.`deleted_at` is null limit 1) ``` ### Hosting Environment Docker Container from Repo: solidnerd/docker-bookstack

OVERLORD added the 🐕 Support label 2026-02-05 10:06:45 +03:00

OVERLORD closed this issue

2026-02-05 10:06:47 +03:00

OVERLORD commented

2026-02-05 10:06:49 +03:00

@oyksoft commented on GitHub (Nov 11, 2025):

Same problem.

[2025-11-11 10:01:57] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entities.id' in 'on clause' (Connection: mysql, SQL: select * from `entities` left join `entity_page_data` on `entity_page_data`.`page_id` = `entities`.`id` where (`draft` = 0 or (`draft` = 1 and `owned_by` = 1)) and (exists (select `entity_id`, `entity_type`, max(owner_id) as owner_id, max(status) as status from `joint_permissions` where `entities`.`id` = `joint_permissions`.`entity_id` and `joint_permissions`.`entity_type` = page and `role_id` in (1) group by `entity_type`, `entity_id` having (status IN (1, 3) or (owner_id = 1 and status != 2)))) and exists (select * from `entities` as `laravel_reserved_0` left join `entity_container_data` on `entity_container_data`.`entity_id` = `entities`.`id` and `entity_container_data`.`entity_type` = book where `laravel_reserved_0`.`id` = `entities`.`book_id` and `slug` = vhshub and `type` = book) and `slug` = 1 and `type` = page and `entities`.`deleted_at` is null limit 1) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entities.id' in 'on clause' (Connection: mysql, SQL: select * from `entities` left join `entity_page_data` on `entity_page_data`.`page_id` = `entities`.`id` where (`draft` = 0 or (`draft` = 1 and `owned_by` = 1)) and (exists (select `entity_id`, `entity_type`, max(owner_id) as owner_id, max(status) as status from `joint_permissions` where `entities`.`id` = `joint_permissions`.`entity_id` and `joint_permissions`.`entity_type` = page and `role_id` in (1) group by `entity_type`, `entity_id` having (status IN (1, 3) or (owner_id = 1 and status != 2)))) and exists (select * from `entities` as `laravel_reserved_0` left join `entity_container_data` on `entity_container_data`.`entity_id` = `entities`.`id` and `entity_container_data`.`entity_type` = book where `laravel_reserved_0`.`id` = `entities`.`book_id` and `slug` = vhshub and `type` = book) and `slug` = 1 and `type` = page and `entities`.`deleted_at` is null limit 1) at D:\\PHPProject\\BookStack\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:824)

@oyksoft commented on GitHub (Nov 11, 2025): Same problem. ``` [2025-11-11 10:01:57] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entities.id' in 'on clause' (Connection: mysql, SQL: select * from `entities` left join `entity_page_data` on `entity_page_data`.`page_id` = `entities`.`id` where (`draft` = 0 or (`draft` = 1 and `owned_by` = 1)) and (exists (select `entity_id`, `entity_type`, max(owner_id) as owner_id, max(status) as status from `joint_permissions` where `entities`.`id` = `joint_permissions`.`entity_id` and `joint_permissions`.`entity_type` = page and `role_id` in (1) group by `entity_type`, `entity_id` having (status IN (1, 3) or (owner_id = 1 and status != 2)))) and exists (select * from `entities` as `laravel_reserved_0` left join `entity_container_data` on `entity_container_data`.`entity_id` = `entities`.`id` and `entity_container_data`.`entity_type` = book where `laravel_reserved_0`.`id` = `entities`.`book_id` and `slug` = vhshub and `type` = book) and `slug` = 1 and `type` = page and `entities`.`deleted_at` is null limit 1) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entities.id' in 'on clause' (Connection: mysql, SQL: select * from `entities` left join `entity_page_data` on `entity_page_data`.`page_id` = `entities`.`id` where (`draft` = 0 or (`draft` = 1 and `owned_by` = 1)) and (exists (select `entity_id`, `entity_type`, max(owner_id) as owner_id, max(status) as status from `joint_permissions` where `entities`.`id` = `joint_permissions`.`entity_id` and `joint_permissions`.`entity_type` = page and `role_id` in (1) group by `entity_type`, `entity_id` having (status IN (1, 3) or (owner_id = 1 and status != 2)))) and exists (select * from `entities` as `laravel_reserved_0` left join `entity_container_data` on `entity_container_data`.`entity_id` = `entities`.`id` and `entity_container_data`.`entity_type` = book where `laravel_reserved_0`.`id` = `entities`.`book_id` and `slug` = vhshub and `type` = book) and `slug` = 1 and `type` = page and `entities`.`deleted_at` is null limit 1) at D:\\PHPProject\\BookStack\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:824) ```

OVERLORD commented

2026-02-05 10:06:51 +03:00

@ssddanbrown commented on GitHub (Nov 11, 2025):

Hi @reddexx and @oyksoft,

Assuming you're also using an older version of MySQL, this will be the same issue as raised in #5877, for which a fix is under-way for release today.
Let me know if you're not using a MySQL <= 5.7 though.

@ssddanbrown commented on GitHub (Nov 11, 2025): Hi @reddexx and @oyksoft, Assuming you're also using an older version of MySQL, this will be the same issue as raised in #5877, for which a fix is under-way for release today. Let me know if you're not using a MySQL <= 5.7 though.

OVERLORD commented

2026-02-05 10:06:51 +03:00

@reddexx commented on GitHub (Nov 11, 2025):

i need a update 🤣

Thanks for your Support :)

@reddexx commented on GitHub (Nov 11, 2025): <img width="99" height="32" alt="Image" src="https://github.com/user-attachments/assets/b032e878-b3a2-4c98-b57d-dba40fdda4a7" /> i need a update 🤣 Thanks for your Support :)

OVERLORD commented

2026-02-05 10:06:52 +03:00

@ssddanbrown commented on GitHub (Nov 11, 2025):

Yeah, for next release I'm planning to bump up the minimums in our requirements to help encourage users to move on to supported database versions (supported by the database software vendors).

I released BookStack v25.11.1 earlier today which should address this without needing to update the DB right now:
https://github.com/BookStackApp/BookStack/releases/tag/v25.11.1

I'll therefore go ahead and close this off.

@ssddanbrown commented on GitHub (Nov 11, 2025): Yeah, for next release I'm planning to bump up the minimums in our requirements to help encourage users to move on to supported database versions (supported by the database software vendors). I released BookStack v25.11.1 earlier today which should address this without needing to update the DB right now: https://github.com/BookStackApp/BookStack/releases/tag/v25.11.1 I'll therefore go ahead and close this off.

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/BookStack#5492