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/