Migrating from old host with 6.5.2 to new host with 7.0.1

[mpkhs]

Infos:

• Used Zammad version: 6.5.2 and 7.0.1
• Used Zammad installation type: package
• Operating system: AlmaLinux 8.10 and 9.7
• Browser + version: -

Expected behavior:

• Install CentOS 9 based distro (AlmaLinux 9) to install Zammad version 6.5.2 or above to migrate data.

Actual behavior:

• Since CentOS 8 is no longer supported, I am stuck with my deployment on version 6.5.2 that’s on AlmaLinux 8 and need to migrate to a new host. I reinstalled a new host with AlmaLinux 9 but the only versions available seem to be 7.0.0 and 7.0.1. But now I can’t migrate as I have the issue that after doing a backup & restore, the new host doesn’t allow login because of the error:

PG::UndefinedTable: ERROR: relation "ai_agents" does not exist LINE 10: WHERE a.attrelid = '"ai_agents"'::regclass ^

Steps to reproduce the behavior:

• dnf list --showduplicates
• dnf downgrade zammad-6*

[tweis]

We encountered this message after migrating from Zammad 6.5.x to Zammad 7.x.

The migration was to a Debian 13 installation. After the first boot, we received the exact same message. After running
zammad run rake zammad:searchindex:rebuild
the message disappeared and login was possible. Of course, I can’t guarantee that an index rebuild will help in your case. A backup or snapshot before attempting this would certainly be highly recommended.
A backup or snapshot is recommended before performing this action.

[MrGeneration]

PG::UndefinedTable indicates missing database migrations.
You seemed to have skipped steps in the migration.

Anyway, a simple execution of /opt/zammad/contrib/packager.io/postinstall.sh should be good enough.

[mpkhs]

Thank you for the solution and thanks @tweis for the suggestion. All that was needed was indeed the DB migration. I’m sure I’ve missed it somewhere in the steps but it’s now working.