Creation of ticket notification failing

Moderator: crythias

Locked
RiomarGroup
Znuny newbie
Posts: 11
Joined: 29 Apr 2014, 01:43
Znuny Version: 3.3.6
Real Name: Ron Garcia_Vidal
Company: Riomar Group

Creation of ticket notification failing

Post by RiomarGroup »

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?
RiomarGroup
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

Post by RiomarGroup »

I still haven't been able to create new notifications because of this issue. Is this a known bug? Has anyone found a workaround?
RiomarGroup
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

Post by RiomarGroup »

Barring being able to fix this issue, or in addition to, why did the default new ticket notifications go away in version 5?
root
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

Post by root »

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 ?
RiomarGroup
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

Post by RiomarGroup »

InnoDB
root
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

Post by root »

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' , ?)'
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?

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 ?
RiomarGroup
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

Post by RiomarGroup »

The Subject I used is: "Ticket Created: <OTRS_TICKET_Title>"

I have only tried this in Firefox. I will try Chrome later.
Locked