Mail channel not running after Upgrade to 6.2

Technical assistance
1
  • Used Zammad version: 6.2.0-1701867011.fdb4b0b7.bookworm
  • Used Zammad installation type: package
  • Operating system: Debian 12 (Server)
  • Browser + version: Firefox 120.0.1

Expected behavior: E-Mail channel works, Mails can be sent and received cia Zammad

Actual behavior: No Mails are processed

Steps to reproduce the behavior: Install the new Zammad Version 6.2

Since we upgraded to Zammad 6.2 yersterday, we get these error messages:
grafik
grafik

We are using Zammad just within our cooperation and therefore do not need any SSL certificates. Is there any way to get Zammad to work as it did before the Update?

Thanks a lot!

Marcel

2

Hi @Marcel1. Please make sure to (re-)execute migrations, the database table is missing right now.

3

Thanks a lot for your advice. Is there any documentation on how to “execute migrations”?
All I know from Zammad documentation basically is:
run
$ apt update
$ apt upgrade

and you will be fine. I did this (the second time now) and Zammad doesn´t really work anymore. Isn´t the installation routine supposed to do all the migrations?
I´m just seriously asking because we have to figure out here, if it is even possible to handle Zammad with a minimum of Linux knowledge. No offence at all!

4

Try /opt/zammad/contrib/packager.io/postinstall.sh
I think it starts the migration.

After that I would clear the cache by zammad run rails r "Rails.cache.clear"

3 Likes
5

Hey Dennis1993,

this did the trick and turns out to be a real life saver. Thanks a thousand times!!!

1 Like
6

The postinstall.sh does not just run the database migrations, but also locale and translation syncs apart other parts.

As this is being called during the upgrade, this doesn’t hurt to rerun at all and actually is better than just the mere rake db:migrate to ensure consistency. (We don’t know what else might fail if e.g. the Database was not available during upgrade)

1 Like
7

Thanks. This just helped me too. I’m going to leave the Error Message in Text Form below to help others locate the thread. Due to the picture i had a bit of a hard time locationg this Thread:

Channel: Email::Account in  Can't use Channel::Driver::Imap: #<ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR:  relation ""ssl_certificates"" does not exist
LINE 9:  WHERE a.attrelid = '""ssl_certificates""'::regclass
                            ^

(I had the issue because we still used postgressql-9.4 and after the db upgrade to 13 i saw the error)

1 Like
8

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