Trigger Email notification

Technical assistance
1

Infos:

  • Used Zammad version: 6.1.0-1701163867.5a81e629.focal
  • Used Zammad installation type: (source, package, docker-compose, …)
  • Operating system: Ubuntu 20.04.6
  • Browser + version: Edge 119.0.2151.97

Expected behavior:

  • sent Email to User when an Agent adds a Note to Ticket via Trigger

Actual behavior:

  • no Email Notification to User

Steps to reproduce the behavior:

  • Add a Note to a Ticket

production.log

I, [2023-12-05T08:29:05.466592#867-73860] INFO – : Execute trigger (neue Notiz/6) for this object (Ticket:3997/Loop:1)
E, [2023-12-05T08:29:05.470040#867-73860] ERROR – : undefined method `each’ for nil:NilClass

  map.each do |minutes, count|
     ^^^^^ (NoMethodError)

app/models/ticket.rb:1238:in block in send_email_notification' app/models/ticket.rb:1188:in each’
app/models/ticket.rb:1188:in send_email_notification' app/models/ticket.rb:729:in block in perform_changes’
app/models/ticket.rb:721:in each' app/models/ticket.rb:721:in perform_changes’
app/models/ticket.rb:905:in block (2 levels) in perform_triggers' app/models/ticket.rb:855:in block in perform_triggers’
app/models/transaction.rb:17:in block in execute' app/models/transaction.rb:14:in execute’
app/models/transaction.rb:26:in execute' app/models/ticket.rb:854:in perform_triggers’
app/models/transaction/trigger.rb:40:in perform' lib/transaction_dispatcher.rb:61:in execute_single_backend’
lib/transaction_dispatcher.rb:47:in block (3 levels) in perform' lib/transaction_dispatcher.rb:46:in each’
lib/transaction_dispatcher.rb:46:in block (2 levels) in perform' lib/transaction_dispatcher.rb:43:in each_value’
lib/transaction_dispatcher.rb:43:in block in perform' lib/transaction_dispatcher.rb:42:in each_value’
lib/transaction_dispatcher.rb:42:in perform' lib/transaction_dispatcher.rb:17:in commit’
app/controllers/application_controller/handles_transitions.rb:18:in `handle_transaction’

2

Hi @martindost. Your Zammad instance is missing at least one migration, this is why this error is shown. Please make sure to (re-)execute migrations.

3

Hi @fliebe92,

thanks for your reply.

I tried to execute migrations
Result:
== 20230726082734 SMIMEMetaInformationTable: migrating ========================
– change_table(:smime_certificates)
rake aborted!
StandardError: An error has occurred, all later migrations canceled:

No indexes found on smime_certificates with the options provided.

I tried to execute /opt/zammad/contrib/packager.io/postinstall.sh
Result:
fett gedruckter Text# database.yml found. Updating db…
== 20230726082734 SMIMEMetaInformationTable: migrating ========================
– change_table(:smime_certificates)
rake aborted!
StandardError: An error has occurred, all later migrations canceled:

No indexes found on smime_certificates with the options provided.

4

Somehow your database table smime_certificates has the wrong structure. Mh.

5

i removed the lines in the migration script with command to remove the not existing indexes

now the migration was successful

thank you

6

This topic was automatically closed 360 days after the last reply. New replies are no longer allowed.