Migrating from old host with 6.5.2 to new host with 7.0.1

Technical assistance
1

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*
2

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.

3

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.

4

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.