[sebastian-michalk]

Hello,

migration from OTRS 6 -> OTOBO 10.0.10, running on Apache Server.

Everything worked fine so far until i wanted to create a new Queue, i get the following Error:

Field ‚move_notify‘ doesn’t have a default value, SQL: ‚INSERT INTO queue (name, group_id, unlock_timeout, system_address_id, calendar_name, default_sign_key, salutation_id, signature_id, first_response_time, first_response_notify, update_time, update_notify, solution_time, solution_notify, follow_up_id, follow_up_lock, valid_id, comments, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ‚2021-07-30 07:40:09‘, ?, ‚2021-07-30 07:40:09′, ?)‘

 

The Migration Script was successful, however it seems there is someting wrong with the database?

Help would be really appreciated.

[sebastian-michalk]

Edit:

Error log from Apache2 Server:

 

[Fri Jul 30 13:34:37 2021] -e: DBD::mysql::db do failed: Field ‚move_notify‘ doesn’t have a default value at /opt/otobo/Kernel/System/DB.pm line 609.
ERROR: OTOBO-CGI-10 Perl: 5.32.1 OS: linux Time: Fri Jul 30 11:34:37 2021

Message: Field ‚move_notify‘ doesn’t have a default value, SQL: ‚INSERT INTO queue (name, group_id, unlock_timeout, system_address_id, calendar_name, default_sign_key, salutation_id, signature_id, first_response_time, first_response_notify, update_time, update_notify, solution_time, solution_notify, follow_up_id, follow_up_lock, valid_id, comments, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ‚2021-07-30 11:34:37‘, ?, ‚2021-07-30 11:34:37′, ?)‘

RemoteAddress: x.x.x.x
RequestURI: /otobo/index.pl

Traceback (988):
Module: Kernel::System::Queue::QueueAdd Line: 852
Module: Kernel::Modules::AdminQueue::Run Line: 477
Module: Kernel::System::Web::InterfaceAgent::Run Line: 1257
Module: ModPerl::ROOT::ModPerl::Registry::opt_otobo_bin_cgi_2dbin_index_2epl::handler Line: 37
Module: (eval) (v1.99) Line: 207
Module: ModPerl::RegistryCooker::run (v1.99) Line: 207
Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 173
Module: ModPerl::Registry::handler (v1.99) Line: 32

 

[sebastian-michalk]

We fixed it.

 

For anyone interested:

The marked rows have to be set to: NULL

[bes]

Hallo,

ich habe in OTOBO nachgesehen was mit mit z.B. move_notify los ist. In der Standardinstallation gibt es kein move_notify. Das legt nahe dass die vier fraglichen Attribute durch ein OTOBO Packet in das System gelangt ist. Haben Sie ein Paket installiert, dass dafür verantwortlich sein könnte? Wenn ja, dann könnten wir prüfen ob es da einen echten Konflikt gibt. Es kann natürlich aber auch sein dass im OTRS Paket NULLs auch verboten waren, die Beschränkung aber nachträglich deaktiviert worden ist.

Viele Grüße,

Bernhard

 

 

[Autor]

Beiträge