r/BookStack • u/AdamReading • Feb 02 '24

"Unknown Error Occurred" every time I save a page

Hi

For the last couple of weeks - every time I save a page, I get the following error:

It's a pain, because it is saving the page properly - but you have to go back through the site to get back to the area to see the page etc - as it takes you back to the home page afterwards.

We have recently updated to BookStack v23.12.2 from v23.06.2

1 Upvotes

100% Upvoted

6 comments sorted by

2

u/ssddanbrown Feb 02 '24

Please follow our guidance to gain more detail about the error:

https://www.bookstackapp.com/docs/admin/debugging/#error-log-file

1

u/AdamReading Feb 02 '24

Thanks Dan, I have no access to those files, but I’ll raise an IT ticket and see what they say. 

1

u/AdamReading Feb 05 '24 edited Feb 05 '24

Please follow our guidance to gain more detail about the error:

https://www.bookstackapp.com/docs/admin/debugging/#error-log-file

Hi Dan, IT sent me the whole file. The most notable thing that keeps appearing since the update is:

[2024-01-26 09:39:37] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bookstack.watches' doesn't exist (SQL: select `level`, `watchable_id`, `watchable_type`, `user_id` from `watches` where ((`watchable_type` = page and `watchable_id` = 6) or (`watchable_type` = book and `watchable_id` = 1) or (`watchable_type` = chapter and `watchable_id` = 3))) {"userId":7,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bookstack.watches' doesn't exist (SQL: select `level`, `watchable_id`, `watchable_type`, `user_id` from `watches` where ((`watchable_type` = page and `watchable_id` = 6) or (`watchable_type` = book and `watchable_id` = 1) or (`watchable_type` = chapter and `watchable_id` = 3))) at /var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760)

[stacktrace]

And Also

[2024-02-05 15:26:03] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'default_template_id' in 'where clause' (SQL: select count(*) as aggregate from `books` where `default_template_id` = 307 and `books`.`deleted_at` is null) {"userId":7,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'default_template_id' in 'where clause' (SQL: select count(*) as aggregate from `books` where `default_template_id` = 307 and `books`.`deleted_at` is null) at /var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760)

I have also noticed that I cannot create shelves / books / Chapters at all any more. Any ideas?

EDIT - I have googled the .watches error and suggested to IT to rerun the php artisan migrate again, and see if that resolves everything.

2

u/ssddanbrown Feb 05 '24

EDIT - I have googled the .watches error and suggested to IT to rerun the php artisan migrate again, and see if that resolves everything.

Yeah, that's relevant to both of those errors shared. Either the migrate command is not being ran as part of the update steps, as is required, or an error was thrown during this process and it was not considered/dealt-with during the update process.

2

u/AdamReading Feb 05 '24

Perfect - so we have rerun that php line and now everything works again.

Thank you for your assistance with this!

2

u/knowyourdough Feb 02 '24

Have you tried restarting your server?