Jeff, Same as Nils, everything went OK when I upgraded from 2.2.1 to 2.2.2 with the two SQL statements addon provided on the download page ( done on Fedora 7 and RedHat EL4).
But as a difference, I prefer using a new OTRS install by backuping old dirs/SQL dump then rpm -e old otrs package and then rpm -ivh new package, then i set back all my config changes needed and all my customizations on source code by a home-made shell script using diff and patch against old and new version ... I got some strange things for others packages when rpm -Uvh sometimes ... Best regards, Laurent MINOST Le vendredi 10 août 2007 à 08:34 -0700, Jeff Shepherd a écrit : > Laurent, > I read the announcement. If you read my email I explicitly state that I > ran the script: > > cat DBUpdate-to-2.2.2.sql | mysql -f -u root otrs > > But, I still get the error that this is supposed to fix. > > Whenever I do an update/upgrade, I do the following: > > 1. rpm -U filename > 2. Then, I run the update script as needed for that update. > 3. I then run: > service httpd restart > service mysqld restart > service crond restart > service otrs start > > That's all that I do. Is there something wrong with these steps? > > -Jeff > > Laurent Minost wrote: > > Hi Jeff, > > > > I think you need to read this announcement on top of the download page > > : http://otrs.org/download/ > > > > interested links : > > - > > http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&CategoryID=33&ItemID=192 > > > > <http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&CategoryID=33&ItemID=192> > > - http://lists.otrs.org/pipermail/announce/2007/000076.html > > > > Best regards, > > > > Laurent MINOST > > > > > > Le vendredi 10 août 2007 à 08:01 -0700, Jeff Shepherd a écrit : > >> Hello, > >> > >> I decided to upgrade our OTRS installation on Fedora 3 from 2.2.1 to > >> 2.2.2. After downloading the RPM, then running: > >> > >> rpm -U otrs-2.2.2-01.i386.rpm > >> > >> I ran the MySQL update script that you're supposed to run: > >> > >> cat DBUpdate-to-2.2.2.sql | mysql -f -u root otrs > >> > >> However, when I run that, I get: > >> > >> [EMAIL PROTECTED] scripts]# cat DBUpdate-to-2.2.2.sql | mysql -f -u > >> root otrs > >> ERROR 1060 at line 13: Duplicate column name 'first_response_time' > >> ERROR 1060 at line 14: Duplicate column name 'solution_time' > >> [EMAIL PROTECTED] scripts]# > >> > >> Now, when I try to login to OTRS, I get: > >> > >> > >> * Software error:* > >> > >> Can't use an undefined value as a HASH reference at > >> /opt/otrs//Kernel/System/Ticket/Article.pm line 1409. > >> > >> > >> For help, please send mail to the webmaster, giving this error > >> message and the time > >> and date of the error. > >> > >> Isn't this what the update script is supposed to fix? > >> > >> Our ticket system is now down, any ideas? > >> > >> Thanks for the help! > >> > >> -Jeff > >> > >> > >> _______________________________________________ > >> OTRS mailing list: otrs - Webpage: http://otrs.org/ > >> Archive: http://lists.otrs.org/pipermail/otrs > >> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > >> Support or consulting for your OTRS system? > >> => http://www.otrs.com/ > >> > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > OTRS mailing list: otrs - Webpage: http://otrs.org/ > > Archive: http://lists.otrs.org/pipermail/otrs > > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > > Support or consulting for your OTRS system? > > => http://www.otrs.com/ > > _______________________________________________ > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > Support or consulting for your OTRS system? > => http://www.otrs.com/
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/
