Upgrade 5.0.27 to 6.0.6 fails on DB structure upgrade :(

Moderator: crythias

Post Reply
soulbuster
OTRS newbie
Posts: 1
Joined: 23 Mar 2018, 12:49
OTRS Version?: 5.0.27

Upgrade 5.0.27 to 6.0.6 fails on DB structure upgrade :(

Post by soulbuster » 23 Mar 2018, 13:11

Dear Community,

while upgrading to the newest version of OTRS I get the following Error:

Code: Select all

[Wed Jan 10 20:33:42 2018] DBUpdate-to-6.pl: DBD::mysql::db do failed: Can't create table 'dynamic_field_obj_id_name' (errno: 13) at /opt/otrs/Kernel/System/DB.pm line 470.
ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-10 Perl: 5.20.2 OS: linux Time: Wed Jan 10 20:33:42 2018

 Message: Can't create table 'dynamic_field_obj_id_name' (errno: 13), SQL: 'CREATE TABLE dynamic_field_obj_id_name (
    object_id INTEGER NOT NULL AUTO_INCREMENT,
    object_name VARCHAR (200) NOT NULL,
    object_type VARCHAR (100) NOT NULL,
    PRIMARY KEY(object_id),
    UNIQUE INDEX dynamic_field_object_name (object_name, object_type)
)'

 Traceback (8853):
   Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 349
   Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 297
   Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::DynamicFieldChanges::Run Line: 52
   Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::Run Line: 134
   Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
   Module: scripts::DBUpdateTo6::Run Line: 69
   Module: ./DBUpdate-to-6.pl Line: 89
Anybody out there got an idea how to fix that :S ??

Kind regards

Post Reply