Add ticket notification fails
Moderator: crythias
-
- Znuny newbie
- Posts: 6
- Joined: 27 Oct 2017, 12:55
- Znuny Version: 5.0.23
- Real Name: Jesper Villadsen
- Company: Inlogic A/S
Add ticket notification fails
When i try to add a ticket notifrication i get: 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 (?, ?, ?, '2017-10-27 14:25:33' , ?, '2017-10-27 14:25:33' , ?)'
What can i do ??
What can i do ??
Re: Add ticket notification fails
your database seems not to be an OTRS5 database. Did you migrate?
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny newbie
- Posts: 6
- Joined: 27 Oct 2017, 12:55
- Znuny Version: 5.0.23
- Real Name: Jesper Villadsen
- Company: Inlogic A/S
Re: Add ticket notification fails
Yes i upgraded from otrs 3 to 5
Re: Add ticket notification fails
so it seems that somethig went wrong at the update. Please start again
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny newbie
- Posts: 6
- Joined: 27 Oct 2017, 12:55
- Znuny Version: 5.0.23
- Real Name: Jesper Villadsen
- Company: Inlogic A/S
Re: Add ticket notification fails
can i just run all the update scripts agan on the same installation ?jojo wrote:so it seems that somethig went wrong at the update. Please start again
Re: Add ticket notification fails
Hi,
Without having more information about your migration steps, I would recommend to restore your backup and start again completely.
Florian
Without having more information about your migration steps, I would recommend to restore your backup and start again completely.
Florian
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
-
- Znuny newbie
- Posts: 6
- Joined: 27 Oct 2017, 12:55
- Znuny Version: 5.0.23
- Real Name: Jesper Villadsen
- Company: Inlogic A/S
Re: Add ticket notification fails
i Upgraded per otrs guide from 3.3.16 to 4.0.21 and that worked fine.wurzel wrote:Hi,
Without having more information about your migration steps, I would recommend to restore your backup and start again completely.
Florian
I then upgraded again per otrs guide from 4.021 to 5.0.13 which broke the installation. well broke and broke, everything but notifications work.. The standart notifications to customer work but all internal notification stopped and i can't create new ones.
Re: Add ticket notification fails
Hi,
you table should look like this
This is the structure of an OTRS5 database.
what's your structure?
Florian
you table should look like this
Code: Select all
MySQL [otrs]> desc notification_event;
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(200) | NO | UNI | NULL | |
| valid_id | smallint(6) | NO | MUL | NULL | |
| comments | varchar(250) | YES | | NULL | |
| create_time | datetime | NO | | NULL | |
| create_by | int(11) | NO | MUL | NULL | |
| change_time | datetime | NO | | NULL | |
| change_by | int(11) | NO | MUL | NULL | |
+-------------+--------------+------+-----+---------+----------------+
8 rows in set (0.01 sec)
what's your structure?
Florian
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
-
- Znuny newbie
- Posts: 6
- Joined: 27 Oct 2017, 12:55
- Znuny Version: 5.0.23
- Real Name: Jesper Villadsen
- Company: Inlogic A/S
Re: Add ticket notification fails
Hmm...wurzel wrote:Hi,
you table should look like this
This is the structure of an OTRS5 database.Code: Select all
MySQL [otrs]> desc notification_event; +-------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(200) | NO | UNI | NULL | | | valid_id | smallint(6) | NO | MUL | NULL | | | comments | varchar(250) | YES | | NULL | | | create_time | datetime | NO | | NULL | | | create_by | int(11) | NO | MUL | NULL | | | change_time | datetime | NO | | NULL | | | change_by | int(11) | NO | MUL | NULL | | +-------------+--------------+------+-----+---------+----------------+ 8 rows in set (0.01 sec)
what's your structure?
Florian
Mine looks like this:
Code: Select all
mysql> desc notification_event;
+--------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(200) | NO | UNI | NULL | |
| subject | varchar(200) | NO | | NULL | |
| text | text | NO | | NULL | |
| content_type | varchar(250) | NO | | NULL | |
| charset | varchar(100) | NO | | NULL | |
| valid_id | smallint(6) | NO | MUL | NULL | |
| comments | varchar(250) | YES | | NULL | |
| create_time | datetime | NO | | NULL | |
| create_by | int(11) | NO | MUL | NULL | |
| change_time | datetime | NO | | NULL | |
| change_by | int(11) | NO | MUL | NULL | |
+--------------+--------------+------+-----+---------+----------------+
-
- Znuny newbie
- Posts: 6
- Joined: 27 Oct 2017, 12:55
- Znuny Version: 5.0.23
- Real Name: Jesper Villadsen
- Company: Inlogic A/S
Re: Add ticket notification fails
spawnadv wrote:Hmm...wurzel wrote:Hi,
you table should look like this
This is the structure of an OTRS5 database.Code: Select all
MySQL [otrs]> desc notification_event; +-------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(200) | NO | UNI | NULL | | | valid_id | smallint(6) | NO | MUL | NULL | | | comments | varchar(250) | YES | | NULL | | | create_time | datetime | NO | | NULL | | | create_by | int(11) | NO | MUL | NULL | | | change_time | datetime | NO | | NULL | | | change_by | int(11) | NO | MUL | NULL | | +-------------+--------------+------+-----+---------+----------------+ 8 rows in set (0.01 sec)
what's your structure?
Florian
Mine looks like this:
Code: Select all
mysql> desc notification_event; +--------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(200) | NO | UNI | NULL | | | subject | varchar(200) | NO | | NULL | | | text | text | NO | | NULL | | | content_type | varchar(250) | NO | | NULL | | | charset | varchar(100) | NO | | NULL | | | valid_id | smallint(6) | NO | MUL | NULL | | | comments | varchar(250) | YES | | NULL | | | create_time | datetime | NO | | NULL | | | create_by | int(11) | NO | MUL | NULL | | | change_time | datetime | NO | | NULL | | | change_by | int(11) | NO | MUL | NULL | | +--------------+--------------+------+-----+---------+----------------+
did i miss a step ?
Re: Add ticket notification fails
Hi,
seems to be a 4 version structure.
Check
https://github.com/OTRS/otrs/blob/rel-4 ... .mysql.sql
https://github.com/OTRS/otrs/blob/rel-5 ... .mysql.sql
So I assume, your migration failed. You should start with your migration from the beginning.
you could change the structure. But it could be, that more things are messed up. It's up to you. But i would advise against it.
Florian
seems to be a 4 version structure.
Check
https://github.com/OTRS/otrs/blob/rel-4 ... .mysql.sql
https://github.com/OTRS/otrs/blob/rel-5 ... .mysql.sql
So I assume, your migration failed. You should start with your migration from the beginning.
you could change the structure. But it could be, that more things are messed up. It's up to you. But i would advise against it.
Florian
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.