PG::UndefinedTable: ERROR: relation "groups_text_modules" does not exist ( Textbausteine / Text Modules)


  • Used Zammad version: 3.1 (Upgraded from 2.9)
  • Used Zammad installation source: Debian package
  • Operating system: Debian Linux
  • Browser + version: All of them

Expected behavior:

  • Create a new Textbaustein should work

Actual behavior:

  • After clickink on Save, red error message flash:

    PG::UndefinedTable: ERROR: relation “groups_text_modules” does not exist LINE 8: WHERE a.attrelid = ‘“groups_text_modules”’::r… ^ : SELECT a.attname, format_type(a.atttypid, a.atttypmod), pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod, c.collname, col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation WHERE a.attrelid = ‘“groups_text_modules”’::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum

zammad run rake db:migrate

solved my issue