Accidentally Deleted Default Agent Notification (i.e. Agent::OwnerUpdate)

[zyousafi]

Okay so something really strange happened. I was making some HTML for the default agent notifications in OTRS; however it seems in the process, and I have no idea how this happened, the "Agent::OwnerUpdate" was deleted. I can see the notification in the list; however when I click on the notification itself the page turns blank. All of the other notifications are working absolutely okay; however this one, for some reason, is no longer working and I don't know how to get it back. Is there a way for me to restore the default agent notifications in OTRS without having to restore the entire database?

Any help that anyone could provide in this regard would be truly appreciated. I really hope there is some copy and paste solution to this.

[crythias]

only english?

SQL:
This assumes the id is '33'

Back up your notifications table prior to making these changes. Your data is your responsibility.

Code: Select all

DELETE FROM `notifications` WHERE id = 33;
INSERT INTO `notifications` (`id`, `notification_type`, `notification_charset`, `notification_language`, `subject`, `text`, `content_type`, `create_time`, `create_by`, `change_time`, `change_by`) VALUES
(33, 'Agent::OwnerUpdate', 'utf-8', 'en', 'Ticket owner assigned to you! (<OTRS_CUSTOMER_SUBJECT[24]>)', 'Hi <OTRS_UserFirstname>,<br />\n<br />\nTicket [<OTRS_TICKET_TicketNumber>] from <OTRS_CUSTOMER_UserCustomerID> (<OTRS_CUSTOMER_DATA_UserFirstName>) &nbsp;is assigned to you by <OTRS_CURRENT_UserFirstname> <OTRS_CURRENT_UserLastname>.<br />\n<br />\nComment:<br />\n<br />\n<OTRS_COMMENT><br />\n<br />\n<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom;TicketID=<OTRS_TICKET_TicketID><br />\n<br />\nYour OTRS Notification Master', 'text/html', '2014-05-05 09:25:24', 3, '2014-05-05 09:25:24', 3);

There is no support for this. It may not work, and if not, you should know how to recover from backup.
Manipulating the tables directly is not supported by this forum or OTRS.

[zyousafi]

Thank you for the prompt response crythias. You got me thinking in the right direction.

What I did to fix this issue was that I connected to the database and I went into the "notifications" table. When I got there what I saw was that the "notification_type" for this particular field was empty. I ran a simple "Update" query and added a value (i.e. "Agent::OwnerUpdate") into the field and the notification is working like a charm again!