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/

Reply via email to