Error when navigating to "Sorting" in settings - missing 'bookstack.sort_rules' table? #5196

Closed
opened 2026-02-05 09:47:45 +03:00 by OVERLORD · 3 comments
Owner

Originally created by @SteveMCIW on GitHub (Feb 27, 2025).

Describe the Bug

After upgrading to 25.02 I am unable to load the new "Sorting" page in settings. All that is displayed is "An unknown error occurred" and a button to return home.

Steps to Reproduce

  1. Login to the web interface as a user with admin access (linked to our Active Directory)
  2. Navigate to Settings
  3. Navigate to Sorting

Expected Behaviour

The new Sorting settings page should be displayed

Screenshots or Additional Context

No response

Browser Details

Firefox 135 on Windows 11 23H2

Exact BookStack Version

v25.02

Originally created by @SteveMCIW on GitHub (Feb 27, 2025). ### Describe the Bug After upgrading to 25.02 I am unable to load the new "Sorting" page in settings. All that is displayed is "An unknown error occurred" and a button to return home. ### Steps to Reproduce 1. Login to the web interface as a user with admin access (linked to our Active Directory) 2. Navigate to Settings 3. Navigate to Sorting ### Expected Behaviour The new Sorting settings page should be displayed ### Screenshots or Additional Context _No response_ ### Browser Details Firefox 135 on Windows 11 23H2 ### Exact BookStack Version v25.02
OVERLORD added the 🐛 Bug label 2026-02-05 09:47:45 +03:00
Author
Owner

@SteveMCIW commented on GitHub (Feb 27, 2025):

Looks like I'm missing a table - the laravel.log has this:

[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bookstack.sort_rules' doesn't exist at /var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php:407)

Is a database script meant to run when the upgrade takes place? (I went from 24.12.1 to 25.02 using the steps at https://www.bookstackapp.com/docs/admin/updates/, and it all looked like it went smoothly.

@SteveMCIW commented on GitHub (Feb 27, 2025): Looks like I'm missing a table - the laravel.log has this: `[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bookstack.sort_rules' doesn't exist at /var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php:407) ` Is a database script meant to run when the upgrade takes place? (I went from 24.12.1 to 25.02 using the steps at https://www.bookstackapp.com/docs/admin/updates/, and it all _looked_ like it went smoothly.
Author
Owner

@SteveMCIW commented on GitHub (Feb 27, 2025):

Ignore my posting - somehow I missed out the migrate step!

@SteveMCIW commented on GitHub (Feb 27, 2025): Ignore my posting - somehow I missed out the migrate step!
Author
Owner

@GostrMao commented on GitHub (Mar 5, 2025):

I made the same mistake, for the record. Image

@GostrMao commented on GitHub (Mar 5, 2025): I made the same mistake, for the record. ![Image](https://github.com/user-attachments/assets/a70b3d9b-d70f-4b1a-a58d-4e725dc0fa27)
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/BookStack#5196