Manual update to 6.9.1 ends with SQLSTATE[42S02]: Base table or view not found

[Humpix]

I followed the steps to update Lechee manually from 6.5.1: "Update manually" on https://lycheeorg.dev/docs/update.html
After overwriting all files, except those that are excluded, of course, the whole thing ends in an Error 500.

500
HttpException

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd04051bb.user_groups' doesn't exist (Connection: mysql, SQL: select user_groups.*, users_user_groups.user_id as pivot_user_id, users_user_groups.user_group_id as pivot_user_group_id, users_user_groups.role as pivot_role, users_user_groups.created_at as pivot_created_at from user_groups inner join users_user_groups on user_groups.id = users_user_groups.user_group_id where users_user_groups.user_id in (1) order by role asc, name asc)

Go home »

What exactly do I need to do to install the update? Simply overwriting files does not seem to work.
BR and thanks, Mathias

[ildyria]

Did you run the database migration ?

[Humpix]

I think you mean the section in the manual: "Go into the Diagnostic page and click on the Apply migration button." - Unfortunately not, because the 500 error message appears immediately – I can't even access the ‘Diagnostic’ page.
But I already suspected that is the reason. Unfortunately, I'm not familiar enough with databases to be able to do it manually. Is there a trick to start the migration in an other way? BR and thanks!

[Humpix]

OK, I was able to solve it. I had to install a few interim updates: 6.5.1 -> 6.6.14 -> 6.7.2 -> 6.9.1. Somewhere, a migration is probably being performed that is not intended for 6.5.1 directly to 6.9.1. Thanks again for your help! Best regards and all the best!

[ildyria]

Glad to hear your issue is resolved, I will try to install 6.5.1 and see what needs to be fixed to smoothen that experience.