Problem upgrade from 3.5 to 3.6 (Ubuntu Package 3.6)

Hello Zammad Community,

after the update to version 3.6 we had a problem with a missing sql collumn stats_storable_type.

This fixed the problem for us:
sudo zammad run rake db:migrate --trace

  • Used Zammad version: 3.5
  • Used Zammad installation source: package
  • Operating system: Ubuntu 20.04.1 LTS
  • Browser + version: Chrome 86 & Firefox 83
  • DB Server + version: PostgreSQL 10.15

Expected behavior:

Full functional Zammad updated to version 3.6

Actual behavior:

  • PG::UndefinedColumn: ERROR: column statsstores.statsstorable_type does not exist LINE 1: …ELECT "statsstores".* FROM "statsstores" WHERE "stats_sto… ^ : SELECT "statsstores".* FROM "statsstores" WHERE "statsstores"."statsstorabletype" = $1 AND "statsstores"."statsstorableid" = $2 AND "stats_stores"."key" = $3 LIMIT $4

Steps to reproduce the behavior:

Steps to FIX the behavior:

sudo zammad run rake db:migrate --trace

2 Likes

Thanks very much! I updated ubuntu yesterday and ran into the exact same issue.

Just run zammad run rails c db:migrate --trace and it will fix it.

2 Likes