Add ticket notification fails

[spawnadv]

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

[jojo]

your database seems not to be an OTRS5 database. Did you migrate?

[spawnadv]

Yes i upgraded from otrs 3 to 5

[jojo]

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

[spawnadv]

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 ?

[wurzel]

Hi,

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

Florian

[spawnadv]

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

[wurzel]

Hi,

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)

This is the structure of an OTRS5 database.

what's your structure?

Florian

[spawnadv]

Hi,

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)

This is the structure of an OTRS5 database.

what's your structure?

Florian

Hmm...
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    |                |
+--------------+--------------+------+-----+---------+----------------+

[spawnadv]

Hi,

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)

This is the structure of an OTRS5 database.

what's your structure?

Florian

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

[wurzel]

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