Upgrade from 5.2 to 5.3 debian (no access)

Technical assistance
1

Infos:

  • Used Zammad version: 5.3
  • Used Zammad installation type: (source, package, docker-compose, …)
  • Operating system: debian 10
  • Browser + version: FF last

Expected behavior:

I would like access to zammad

Actual behavior:

When I try to connect to zammad, I can see the logo during loading and then white page.

Steps to reproduce the behavior:

I updated zammad from 5.2 to 5.3 with apt
I reloaded the cache as requested.

When I try to connect to zammad, I can see the logo during loading and then white page

I checked production.log

I can see an error but I’m not sure to understand it

E, [2022-12-17T04:18:48.522646 #4632-113160] ERROR -- : PG::UndefinedTable: ERROR:  relation "user_overview_sortings" does not exist
LINE 1: ...zations"."user_id" = "users"."id" LEFT OUTER JOIN "user_over...
                                                             ^
 (ActiveRecord::StatementInvalid)
app/models/application_model/can_associations.rb:154:in `attributes_with_association_ids'
app/models/user/assets.rb:35:in `assets'
lib/session_helper.rb:18:in `default_collections'
lib/session_helper.rb:5:in `json_hash'
app/controllers/sessions_controller.rb:45:in `show'
app/controllers/application_controller/has_download.rb:21:in `block (4 levels) in <module:HasDownload>'
app/controllers/application_controller/has_download.rb:20:in `block (3 levels) in <module:HasDownload>'
app/controllers/application_controller/has_download.rb:19:in `block (2 levels) in <module:HasDownload>'
app/controllers/application_controller/handles_transitions.rb:16:in `handle_transaction'
I, [2022-12-17T04:18:48.524885 #4632-113160]  INFO -- : Completed 422 Unprocessable Entity in 15ms (Views: 0.2ms | ActiveRecord: 3.7ms | Allocations: 8330)
E, [2022-12-17T04:18:48.977990 #5616-112300] ERROR -- : thread_client 112220 exited with error #<ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR:  relation "user_overview_sortings" does not exist
LINE 1: ...zations"."user_id" = "users"."id" LEFT OUTER JOIN "user_over...
                                                             ^
>
E, [2022-12-17T04:18:48.978038 #5616-112300] ERROR -- : /opt/zammad/vendor/bundle/ruby/3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/postgresql_adapter.rb:672:in `exec_params'
  /opt/zammad/vendor/bundle/ruby/3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/postgresql_adapter.rb:672:in `block (2 levels) in exec_no_cache'

Is someone can help me?

2

I believe there are database changes during the update that you need to step through. Did you log into your server to do the update, or was it an unattended update?

1 Like
3

Hello,
Thank you for your reply.

I just used apt upgrade as usually.

Is there some script to check if database has been updated. Or to finished the process?

4

haaa but I’m stupid. I just need to do
zammad run rake db:migrate

2 Likes
5

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.