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