Only blank page instead of login page after update to version 5.3

Hi,

I have a running Zammad Version 5.2.3 on a Debian 10 machine. Debian has all updates till yesterday. Only the Zammad update is missing.

I tried multimple times to do the update like I did in the past and like described here: Updating Zammad — Zammad documentation

While the update everything looks normal, I can’t see any error messages.

After the update I only see a white page instead of the login page.

If I go to “show sourcecode” there is quite some stuff, so I think the problem is not coming from nginx oder because Zammad is not running.

Accidentaly I had a ticket open in another browser while I did one of my many tries to update the system and the system seemd to work (I could go to other tickets) till I logged off… white page.

Any hints?

Thanks,
Christian.

1 Like

Not sure which installation type you’re running at as the page you’ve linked is a blanko page for like all types…

The log file should tell you what’s wrong through.

Actually I encountered the same issue after upgrade, i.e. I am getting a blank page at login.
When checking the log file (production.log) I can see this error message:

I, [2023-01-20T00:11:45.756229 #125-113280]  INFO -- : Started GET "/" for 172.17.11.51 at 2023-01-20 00:11:45 +0100
I, [2023-01-20T00:11:45.770844 #125-113280]  INFO -- : Processing by InitController#index as HTML
I, [2023-01-20T00:11:45.783918 #125-113280]  INFO -- :   Rendered init/index.html.erb within layouts/application (Duration: 0.5ms | Allocations: 47)
I, [2023-01-20T00:11:45.786156 #125-113280]  INFO -- :   Rendered layout layouts/application.html.erb (Duration: 2.8ms | Allocations: 623)
I, [2023-01-20T00:11:45.788820 #125-113280]  INFO -- : Completed 200 OK in 18ms (Views: 3.7ms | ActiveRecord: 4.2ms | Allocations: 2927)
I, [2023-01-20T00:11:46.001897 #125-111880]  INFO -- : Started POST "/api/v1/signshow" for 172.17.11.51 at 2023-01-20 00:11:46 +0100
I, [2023-01-20T00:11:46.015765 #125-111880]  INFO -- : Processing by SessionsController#show as JSON
I, [2023-01-20T00:11:46.015929 #125-111880]  INFO -- :   Parameters: {"fingerprint"=>"171270394"}
E, [2023-01-20T00:11:46.057849 #125-111880] ERROR -- : PG::UndefinedTable: ERROR:  relation "user_overview_sortings" does not exist
LINE 1: ...zations"."user_id" = "users"."id" LEFT OUTER JOIN "user_over...

Can anyone pls advise what did I wrong and what’s more important: how can I heal it / it is our production server now completely unusable…
thx

I’m having the same issue. I just upgraded our server from 3.6.0 to 5.3.1 and after resolving the Elasticsearch plugin issues and reindexing, I still only receive a blank screen at the login page. The Zammad logon is on the browser tab and nothing else. I’ve tried Edge and Brave browsers with the same result. production.log file shows the same error as listed in the comment above.

I, [2023-01-21T16:44:08.426118 #899-112100]  INFO -- :   Rendered layout layouts/application.html.erb (Duration: 0.8ms | Allocations: 622)
I, [2023-01-21T16:44:08.427099 #899-112100]  INFO -- : Completed 200 OK in 6ms (Views: 1.1ms | ActiveRecord: 0.9ms | Allocations: 3037)
I, [2023-01-21T16:44:08.596266 #899-111880]  INFO -- : Started POST "/api/v1/signshow" for 69.1.96.242 at 2023-01-21 16:44:08 -0800
I, [2023-01-21T16:44:08.600345 #899-111880]  INFO -- : Processing by SessionsController#show as JSON
I, [2023-01-21T16:44:08.600392 #899-111880]  INFO -- :   Parameters: {"fingerprint"=>"1078227506"}
E, [2023-01-21T16:44:08.610958 #899-111880] ERROR -- : PG::UndefinedTable: ERROR:  relation "user_overview_sortings" does not exist
LINE 1: ...zations"."user_id" = "users"."id" LEFT OUTER JOIN "user_over...

Sorry for the delay. My problem is gone, and I don’t know why. Steps I did:

  1. My system runs on an VM, so it is very easy after a crash to go back to the previous snapshot.
  2. I wrote myself a little bash script based on the actual Zammad update documentation.
  3. I did all debian updates for my machine manually step by step without the Zammad update. So in the end only the Zammad update was missing. System worked, so I took another snapshot of the vm.
  4. I startet my bash script for the Zammad update.
  5. Worked on the first try. Systems runs now on newest version.

I don’t know what exactly caused the problem. Maybe I needed the Debian updates first? Maybe I typed always (had multiple tries) something wrong for the Zammad update?

Thanks,
Christian.

I saw this exact behavior also on an Ubuntu 20 LTS with package install. When I just did a lazy “apt-upgrade -y” there were some big error messages flashing by about being unable to communicate iwth postregsql.

What I did was “apt-mark hold zammad*” and then I just upgraded everything else, and rebooted. I then further verified that there were no pending updates; I had a few but they were all OS stuff, so I did those too.

Last step, “apt-mark unhold zammad*” and then upgraded zammad with an apt-get upgrade and the upgrade went fine and the database got upgraded properly, and the UI and system is functional.

So something with doing a big upgrade of a lot, including Elasticsearch, caused an issue communciating with the database - maybe, in fact, the database components upgrade. Leaving Zammad untouched until the rest of the OS got patched did the trick.

Damned fine thing I snapshotted before starting, or I’d have been restoring a backup.

Just a small side note even through it’s fixed for you guys already.
This is indicating a non successful migration and thus a non successful update installation.

This should be fixable by running /opt/zammad/contrib/packager.io/postinstall.sh on package installations. Source code installation users should repeat the update steps “upgrade your database” and “synchronize Zammad’s translation files” mentioned in the documentation: Updating Zammad — Zammad System Documentation documentation

2 Likes

Just ran into the same issue updating from 5.1 (package) on Ubuntu 18.04 - scary moment! But all is well now. MrGeneration’s advice to run postinstall.sh helped, thanks.

Today I updated my install from packages from version 5.1 to 5.4.1 and was also only seeing a blank page webgui.

Checking var/log/zammad/production.log does show many errors, for example:

[2023-04-13T01:34:33.914470#240680-116460] ERROR – : thread_client 111740 exited with error #<ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: relation “user_overview_sortings” does not exist
LINE 8: WHERE a.attrelid = ‘“user_overview_sortings”’::regclass
E, [2023-04-13T01:35:22.971811#240680-112060] ERROR – : thread_client 111860 exited with error #<ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: relation “user_overview_sortings” does not exist
LINE 8: WHERE a.attrelid = ‘“user_overview_sortings”’::regclass
E, [2023-04-13T01:35:22.971931#240680-112060] ERROR – : /opt/zammad/vendor/bundle/ruby/3.1.0/gems/activerecord-6.1.7.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:19:in exec' E, [2023-04-13T01:35:23.748580#240680-112640] ERROR -- : thread_client 111960 exited with error #<ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: relation "user_overview_sortings" does not exist LINE 8: WHERE a.attrelid = '"user_overview_sortings"'::regclass E, [2023-04-13T01:35:23.748667#240680-112640] ERROR -- : /opt/zammad/vendor/bundle/ruby/3.1.0/gems/activerecord-6.1.7.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:19:in exec’
E, [2023-04-13T01:35:24.684143#240680-116460] ERROR – : thread_client 111740 exited with error #<ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: relation “user_overview_sortings” does not exist
LINE 8: WHERE a.attrelid = ‘“user_overview_sortings”’::regclass
E, [2023-04-13T01:35:24.684225#240680-116460] ERROR – : /opt/zammad/vendor/bundle/ruby/3.1.0/gems/activerecord-6.1.7.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:19:in exec' E, [2023-04-13T01:35:33.121462#240680-112060] ERROR -- : thread_client 111860 exited with error #<ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: relation "user_overview_sortings" does not exist LINE 8: WHERE a.attrelid = '"user_overview_sortings"'::regclass E, [2023-04-13T01:35:33.121582#240680-112060] ERROR -- : /opt/zammad/vendor/bundle/ruby/3.1.0/gems/activerecord-6.1.7.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:19:in exec’

I found this forum post and tried this:

After running postinstall.sh the system appears to be updated to 5.4.1 and appears to be working correctly.

Should I be concerned that the update process was unsuccessful because of the log errors and should I rollback the system to prior snapshot and run the update first with “apt-mark hold zammad*” ?
Or should running the postinstall.sh operation not hide or cause any latent issues after the errors during update?

Thanks

Simply ensure you’re not updating Zammad and postgres at the same time.
If your system automatically updates unattended, mark zammad on-hold and only update Zammad when you have to / want to.

Had the same Problem after updating to 5.4.1
Just here to say thank you to MrGeneration → /opt/zammad/contrib/packager.io/postinstall.sh did the job.

1 Like

So, I’ve been at this for a couple of hours now, but I can’t seem to find a solution to my login page being blank. I have tried the solution posted by MrGeneration, but I still end up with a blank screen.

When I did my apt update, apt upgrade the Zammad update did throw a bunch of database-related errors, but when running the postinstall.sh file it finished up nicely.

In this case, I was updating from 5.3.1 to 6.0.0

My production log has no errors, and my already logged-in session in my browser works! But I can’t open Zammad in a new browser or on my phone. I’ve asked around and it seems to be persistent. Logged-in sessions work fine, but once logged out, the screen goes blank.

@dm-andreas > Are there any errors logged in your browser’s console?

Just making sure as it might be happening in this case, there is a bug currently that results in a blank page when you’re on ticket overview pages while logged out, see

In Firefox developer edition I get an error in console:

XHRPOST
https://support.dentalmedia.dk/api/v1/signshow
[HTTP/1.1 422 Unprocessable Entity 286ms]

Edit: I used a snapshot back to 5.3.1 and then tried the solution where you hold back Zammad updates so Postgres doesn’t update simultaneously, and of course, it worked right out of the gates.

In my desperate attempts to get the login screen back, I may have borked my Zammad install even more, so I got to the point where I couldn’t log in anymore, with the error above.

Did you check this message in more detail? What about the production.log? You need to provide more information, otherwise, it’s kind of impossible to help you. :smile:

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