Updating from OTRS 6.0.10 to OTRS 6.0.28

[MarcusLanvers]

Hey guys,
so I'm totally new to OTRS and need to update a system from 6.0.10 to a new bugfix version 6.0.28. I am following this tutorial on how to update:
https://doc.otrs.com/doc/manual/admin/6 ... ating.html
When running the

Code: Select all

UpdateDB-to-6.pl

script I get duplicated ID errors, when trying to fix the DB by removing the given entries I only get even more duplication errors.
So the questions I have are:
Do I actually need to run the script when updating to a bugfix version?
If I do need to run the script, what is an aspect of OTRS I should look into to understand the errors I'm getting?

Some of the errors I'm getting:

Code: Select all

Message: Duplicate entry '11' for key 'PRIMARY', SQL: 'INSERT INTO notification_event (name, valid_id, comments, create_by, create_time, change_by, change_time)
    VALUES
    ('Ticket email delivery failure notification', 1, '', 1, '2020-07-10 06:48:31', 1, '2020-07-10 06:48:31')'

Code: Select all

ERROR: OTRS-otrs.Console.pl-Dev::Code::CPANAudit-48 Perl: 5.22.1 OS: linux Time: Fri Jul 10 07:24:16 2020

 Message: Duplicate entry '2414' for key 'PRIMARY', SQL: '
                INSERT INTO sysconfig_default (
                    name,description,navigation,is_invisible,is_readonly,is_required,is_valid,has_configlevel,user_modification_possible,user_modification_active,user_preferences_group,xml_content_raw,xml_content_parsed,xml_filename,effective_value,is_dirty,exclusive_lock_guid,create_time,create_by,change_time,change_by
                )VALUES ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,'2020-07-10 07:24:16',?,'2020-07-10 07:24:16',? ), ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,'2020-07-10 07:24:16',?,'2020-07-10 07:24:16',? ) , ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,'2020-07-10 07:24:16',?,'2020-07-10 07:24:16',? ) , ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,'2020-07-10 07:24:16',?,'2020-07-10 07:24:16',? ) , ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,'2020-07-10 07:24:16',?,'2020-07-10 07:24:16',? ) , ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,'2020-07-10 07:24:16',?,'2020-07-10 07:24:16',? ) , ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,'2020-07-10 07:24:16',?,'2020-07-10 07:24:16',? ) , ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,'2020-07-10 07:24:16',?,'2020-07-10 07:24:16',? ) , ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,'2020-07-10 07:24:16',?,'2020-07-10 07:24:16',? ) , ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,'2020-07-10 07:24:16',?,'2020-07-10 07:24:16',? ) '

Greetings
Marcus Lanvers

[zzz]

E: See skullz answer below.

[skullz]

As per official docs,

Screenshot_20200710-201506.jpg

[MarcusLanvers]

Hey zzz
Thanks for the fast reply!
I will try to update my system without using the script and reply once I have it running or see that it won't work.
@skullz:
I saw that too when looking at the docs, but it felt weird to me that I would have to update something as essential like the DB when updating not even a minor version. As developer, I would normally only do drastic changes like that in Major updates.

Thanks for the replies.

[zzz]

Hello again,

Skullz is actually right.
The script might still make some changes, depending on the version you're coming from, to fix bugs, and straighten the database up.

You should follow the documentation. It could be possible that the script has a bug, but I can't verify that.

Are there any errors in the SupportDataCollector?

Best regards
Emin