Znuny Open Source Ticketsystem

Hi,

you table should look like this

MySQL [otrs]> desc notification_event;
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI ...

Hi,

you table should look like this

MySQL [otrs]> desc notification_event;
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI ...

Hi,

Without having more information about your migration steps, I would recommend to restore your backup and start again completely.

Florian

i Upgraded per otrs guide from 3.3.16 to 4.0.21 and that worked fine.
I then upgraded again per otrs guide from 4.021 to 5.0.13 which broke the ...

jojo wrote:so it seems that somethig went wrong at the update. Please start again

can i just run all the update scripts agan on the same installation ?

Yes i upgraded from otrs 3 to 5

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