BookStackApp / BookStack

A platform to create documentation/wiki content built with PHP & Laravel
https://www.bookstackapp.com/
MIT License
14.83k stars 1.86k forks source link

Bookstack SQL error #5147

Open ryanvoorspoels opened 1 month ago

ryanvoorspoels commented 1 month ago

Attempted Debugging

Searched GitHub Issues

Describe the Scenario

We had problems with our server and we reinstall the os en put everything back and now after the login we get a error on bookstack

Exact BookStack Version

latest

Log Content

Illuminate\Database\QueryException SQLSTATE[42S22]: Column not found: 1054 Unknown column 'activities.loggable_id' in 'where clause' (Connection: mysql, SQL: select * from activities where (exists (select entity_id, entity_type, max(owner_id) as owner_id, max(status) as status from joint_permissions where activities.loggable_id = joint_permissions.entity_id and role_id in (1, 3, 4) and activities.loggable_type = joint_permissions.entity_type group by entity_type, entity_id having (status IN (1, 3) or (owner_id = 3 and status != 2)))) and (loggable_type != page or exists (select id from pages where pages.id = activities.loggable_id and activities.loggable_type = page and pages.draft = 0)) order by created_at desc limit 10 offset 0)

Hosting Environment

php8.3 ubuntu server 24.04 apache

ssddanbrown commented 1 month ago

Hi @ryanvoorspoels, When you say "put everything back" what exactly do you mean? Did you restore an old content? Please detail the steps followed there if possible.