Trying to add a notification for newly created tickets which seems to have disappeared when upgrading to 5.0.13
(As an aside: The documentation says "your existing ticket notifications have been migrated into the list of ticket notifications, but deactivated. You have also received the new default ticket notifications, active by default." but "Update on customer status change" is the only entry now in the Ticket Notification section.)
When creating the notification, I have filled out all mandatory fields, and when submitting I receive the following error:
Field 'subject' doesn't have a default value, SQL: ' INSERT INTO notification_event (name, valid_id, comments, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, '2016-10-27 18:20:52' , ?, '2016-10-27 18:20:52' , ?)'
Googling around, I have found that this could sometimes be caused by MySQL having STRICT_TRANS_TABLES enabled. That is the default as of MySQL 5.7.5. Should I disable this or is there an error in the actual OTRS code?
Creation of ticket notification failing
Moderator: crythias
-
- Znuny newbie
- Posts: 11
- Joined: 29 Apr 2014, 01:43
- Znuny Version: 3.3.6
- Real Name: Ron Garcia_Vidal
- Company: Riomar Group
-
- Znuny newbie
- Posts: 11
- Joined: 29 Apr 2014, 01:43
- Znuny Version: 3.3.6
- Real Name: Ron Garcia_Vidal
- Company: Riomar Group
Re: Creation of ticket notification failing
I still haven't been able to create new notifications because of this issue. Is this a known bug? Has anyone found a workaround?
-
- Znuny newbie
- Posts: 11
- Joined: 29 Apr 2014, 01:43
- Znuny Version: 3.3.6
- Real Name: Ron Garcia_Vidal
- Company: Riomar Group
Re: Creation of ticket notification failing
Barring being able to fix this issue, or in addition to, why did the default new ticket notifications go away in version 5?
-
- Administrator
- Posts: 4253
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Creation of ticket notification failing
What's your table engine type? MyIsam or InnoDB?
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
- Znuny newbie
- Posts: 11
- Joined: 29 Apr 2014, 01:43
- Znuny Version: 3.3.6
- Real Name: Ron Garcia_Vidal
- Company: Riomar Group
-
- Administrator
- Posts: 4253
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Creation of ticket notification failing
I still miss the subject field in the error message, the subject is a mandatory field/column. What was your value for the subject field?RiomarGroup wrote: When creating the notification, I have filled out all mandatory fields, and when submitting I receive the following error:
Field 'subject' doesn't have a default value, SQL: ' INSERT INTO notification_event (name, valid_id, comments, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, '2016-10-27 18:20:52' , ?, '2016-10-27 18:20:52' , ?)'
Did you tried it with another browser?
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
- Znuny newbie
- Posts: 11
- Joined: 29 Apr 2014, 01:43
- Znuny Version: 3.3.6
- Real Name: Ron Garcia_Vidal
- Company: Riomar Group
Re: Creation of ticket notification failing
The Subject I used is: "Ticket Created: <OTRS_TICKET_Title>"
I have only tried this in Firefox. I will try Chrome later.
I have only tried this in Firefox. I will try Chrome later.