Error on upgrade from 4.0.16 to 5.0.7-01
Moderator: crythias
-
- Znuny newbie
- Posts: 23
- Joined: 09 Mar 2016, 18:04
- Znuny Version: 3.3.5
- Company: www.google.pt
Error on upgrade from 4.0.16 to 5.0.7-01
Hello all,
Iam getting the following error when executing DBUpdate-to-5.pl
Step 7 of 17: Migrate notifications to event based notifications...ERROR: OTRS-DBUpdate-to-5.pl-9 Perl: 5.10.1 OS: linux Time: Tue Mar 29 22:33:36 2016
Message: Can't add notification 'Old Ticket new note notification ( Duplicate Name )', notification already exists!
Traceback (2091):
Module: Kernel::System::NotificationEvent::NotificationAdd Line: 271
Module: main::_MigrateNotifications Line: 1109
Module: ./DBUpdate-to-5.pl Line: 162
error.
[Tue Mar 29 22:33:36 2016] DBUpdate-to-5.pl: Died at ./DBUpdate-to-5.pl line 167.
Can anyone help with this?
Tks
Iam getting the following error when executing DBUpdate-to-5.pl
Step 7 of 17: Migrate notifications to event based notifications...ERROR: OTRS-DBUpdate-to-5.pl-9 Perl: 5.10.1 OS: linux Time: Tue Mar 29 22:33:36 2016
Message: Can't add notification 'Old Ticket new note notification ( Duplicate Name )', notification already exists!
Traceback (2091):
Module: Kernel::System::NotificationEvent::NotificationAdd Line: 271
Module: main::_MigrateNotifications Line: 1109
Module: ./DBUpdate-to-5.pl Line: 162
error.
[Tue Mar 29 22:33:36 2016] DBUpdate-to-5.pl: Died at ./DBUpdate-to-5.pl line 167.
Can anyone help with this?
Tks
Last edited by arestas on 30 Mar 2016, 12:06, edited 1 time in total.
-
- Znuny newbie
- Posts: 23
- Joined: 09 Mar 2016, 18:04
- Znuny Version: 3.3.5
- Company: www.google.pt
Re: Error on upgrade from 4 to 5
Can anyone help me with this??
Can i comment in the DBUpdate-to-5.pl the part where it will check the step 7??
Is this a good workaround?
Regards,
Lostrans
Can i comment in the DBUpdate-to-5.pl the part where it will check the step 7??
Is this a good workaround?
Regards,
Lostrans
-
- Znuny newbie
- Posts: 23
- Joined: 09 Mar 2016, 18:04
- Znuny Version: 3.3.5
- Company: www.google.pt
Re: Error on upgrade from 4.0.16 to 5.0.7-01
Can anyone help me with this? :
Regards,
Lostrans
Regards,
Lostrans
Re: Error on upgrade from 4.0.16 to 5.0.7-01
Did you run the migration script more than one time? You can not comment anything in the migration script as it will lead at least to data loss.
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny newbie
- Posts: 23
- Joined: 09 Mar 2016, 18:04
- Znuny Version: 3.3.5
- Company: www.google.pt
Re: Error on upgrade from 4.0.16 to 5.0.7-01
YEap, Have run it a few times and always stops with this error.
-
- Znuny newbie
- Posts: 23
- Joined: 09 Mar 2016, 18:04
- Znuny Version: 3.3.5
- Company: www.google.pt
Re: Error on upgrade from 4.0.16 to 5.0.7-01
YEap, Have run it a few times and always stops with this error.
Have made a few checks like permissions and database configuration and all is ok...
Have made a few checks like permissions and database configuration and all is ok...
Re: Error on upgrade from 4.0.16 to 5.0.7-01
did you revert to original 4.0.x database before running again?
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny newbie
- Posts: 23
- Joined: 09 Mar 2016, 18:04
- Znuny Version: 3.3.5
- Company: www.google.pt
Re: Error on upgrade from 4.0.16 to 5.0.7-01
In my first upgrade try ive made v3 to v4 and v4 to v5. this upgrade failed. So ive decided to roll back. Have put the snapshot on the otrs vm and have restore the backup i have made from the otrs database.
After i understand what went wrong in the first upgrade (it were the packages versions) ive decided to upgrade the OTRS platform again.
The upgrade from V3 to V4 went well but the upgrade from v4 to v5 is returning the reported error. Notice that this error didn't happen on the first upgrade from v4 to v5.
Because upgrade from v4 to v5 has failed i have installed just the v4 and that the current production version.
So what i am thinking is that the V5 adds new columns to the db. when running the upgrade script to v5 it returns the reported error because the field that script is trying to create already exists.
If this is what is happening i could comment this lines and skip step 7.
Could really use some help here
After i understand what went wrong in the first upgrade (it were the packages versions) ive decided to upgrade the OTRS platform again.
The upgrade from V3 to V4 went well but the upgrade from v4 to v5 is returning the reported error. Notice that this error didn't happen on the first upgrade from v4 to v5.
Because upgrade from v4 to v5 has failed i have installed just the v4 and that the current production version.
So what i am thinking is that the V5 adds new columns to the db. when running the upgrade script to v5 it returns the reported error because the field that script is trying to create already exists.
If this is what is happening i could comment this lines and skip step 7.
Could really use some help here
-
- Znuny newbie
- Posts: 23
- Joined: 09 Mar 2016, 18:04
- Znuny Version: 3.3.5
- Company: www.google.pt
Re: Error on upgrade from 4.0.16 to 5.0.7-01
This error still happening when i try to upgrade to V5.
Can anyone help me with this?
Can anyone help me with this?
-
- Znuny newbie
- Posts: 23
- Joined: 09 Mar 2016, 18:04
- Znuny Version: 3.3.5
- Company: www.google.pt
Re: Error on upgrade from 4.0.16 to 5.0.7-01
Well, Solved it.
This happens because the table already have the record.
i had 'Old Ticket new note notification' and Old Ticket new note notification ( Duplicate Name ) rows in the table.
Ive deleted and have rerun the upgrade script.
This solved my problem.
Regards
This happens because the table already have the record.
i had 'Old Ticket new note notification' and Old Ticket new note notification ( Duplicate Name ) rows in the table.
Ive deleted and have rerun the upgrade script.
This solved my problem.
Regards