Hi @olivierlambert and @ado123 ,
can you try to run the following commands on your zammad run rails c to see what they return. Here an example of my dev system:
[1] pry(main)> TypeLookup.all
TypeLookup Load (0.4ms) SELECT "type_lookups".* FROM "type_lookups"
=> [#<TypeLookup:0x000055d043009768 id: 1, name: "session started", created_at: Mon, 04 Oct 2021 09:20:18 UTC +00:00, updated_at: Mon, 04 Oct 2021 09:20:18 UTC +00:00>,
#<TypeLookup:0x000055d0430094c0 id: 2, name: "update", created_at: Mon, 04 Oct 2021 14:22:14 UTC +00:00, updated_at: Mon, 04 Oct 2021 14:22:14 UTC +00:00>,
#<TypeLookup:0x000055d043009380 id: 3, name: "create", created_at: Mon, 04 Oct 2021 14:22:14 UTC +00:00, updated_at: Mon, 04 Oct 2021 14:22:14 UTC +00:00>]
[2] pry(main)> TypeLookup.by_name('update')
TypeLookup Load (0.5ms) SELECT "type_lookups".* FROM "type_lookups" WHERE "type_lookups"."name" = $1 LIMIT $2 [["name", "update"], ["LIMIT", 1]]
=> 2
[3] pry(main)> TypeLookup.by_name('create')
TypeLookup Load (0.3ms) SELECT "type_lookups".* FROM "type_lookups" WHERE "type_lookups"."name" = $1 LIMIT $2 [["name", "create"], ["LIMIT", 1]]
=> 3
[4] pry(main)> TypeLookup.by_name('session started')
TypeLookup Load (0.6ms) SELECT "type_lookups".* FROM "type_lookups" WHERE "type_lookups"."name" = $1 LIMIT $2 [["name", "session started"], ["LIMIT", 1]]
=> 1