OTRS Windows upgrade from 2.4.7 with ITSM 2.1 to 3.0.4

Moderator: crythias

Locked
jhelzer
Znuny newbie
Posts: 2
Joined: 04 Jan 2011, 01:13
Znuny Version: 2.4.7

OTRS Windows upgrade from 2.4.7 with ITSM 2.1 to 3.0.4

Post by jhelzer »

Hello all,

I recently started the upgrade process from 2.4.7 with ITSM to 3.0 running on Windows. I have successfully performed the following tasks:
  • Created a Database Dump
    Made a backup copy of Config.pm
    Made a backup copy of ZZZAuto.pm
    Ran the Windows uninstall for 2.4.7
    Rebooted (per the uninstaller)
    Installed the OTRS3.0.4 Windows install
    copied the config.pm file back to c:\program files\otrs\otrs\kernel
The next step according to the Youtube video and old instructions from 2.2 to 2.3 is to run the DBUpdate-to-3.0.mysql.sql database script. When running this script I get the following error: ERROR 1060 (42S21) at line 7: Duplicate column name 'archive_flag'

Does anyone have any ideas?

Regards,

Jarrod
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: OTRS Windows upgrade from 2.4.7 with ITSM 2.1 to 3.0.4

Post by jojo »

you forgot to delete the database otrs after installation of the new version.

But, OTRS 3.0 is available only without ITSM Modules at the moment, so you should not upgrade right now.
"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
jhelzer
Znuny newbie
Posts: 2
Joined: 04 Jan 2011, 01:13
Znuny Version: 2.4.7

Re: OTRS Windows upgrade from 2.4.7 with ITSM 2.1 to 3.0.4

Post by jhelzer »

jojo wrote:you forgot to delete the database otrs after installation of the new version.

But, OTRS 3.0 is available only without ITSM Modules at the moment, so you should not upgrade right now.
jojo,

Thank you very much for the help. I'll wait on the ITSM.

Regards,

Jarrod
Locked