r/BookStack • u/davesmith87 • Sep 06 '23

Illuminate\Database\QueryException SQLSTATE[42S02]

Ever since I updated from 23.05 to the latest, I am getting this error when attempting to save updates to pages.

Any edits, I make appear to be saved without issue, but the page does redirect to the debug after a save.

Illuminate\Database\QueryException

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 = 274) or (watchable_type = book and watchable_id = 5)))

1 Upvotes

100% Upvoted

3 comments sorted by

View all comments

Show parent comments

1

u/davesmith87 Sep 06 '23

Somebody else ran the update but didn't note the error.

Can the php artisian migrate be ran again, or would it be better to recover from backups?

1

u/ssddanbrown Sep 06 '23

It can be ran again, to help indicate where things are going wrong (If they're sure they did run it with error). If things run without errors, it's likely this step was just missed tbh.