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:
>>
>>   [root@calltrkr 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'
>>   [root@calltrkr 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/