Hi Nils,
I did check the escalation_response_time and escalation_solution_time
tables, they're there. When I run those commands in MySQL again, I get
an "ERROR 1060: Duplicate column name 'escalation_response_time'" and
the same for escalation_solution_time.
I did restart the processes as needed:
service httpd restart
service mysqld restart
service otrs start
Any other suggestions?
-Jeff
Nils Breunese (Lemonbit) wrote:
Jeff Shepherd wrote:
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'
Those errors should be no problem.
Do you have escalation_response_time and escalation_solution_time
columns in your ticket table? If not, you might want to add them (from
http://bugs.otrs.org/show_bug.cgi?id=2020 which was linked in the
official 2.2.2 announcement
(http://lists.otrs.org/pipermail/announce/2007/000076.html)):
ALTER TABLE ticket ADD escalation_response_time INTEGER;
ALTER TABLE ticket ADD escalation_solution_time INTEGER;
[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?
Did you restart otrs and httpd? ('service otrs restart' and 'service
httpd restart')
The upgrade went ok on our systems (CentOS 4).
Nils Breunese
------------------------------------------------------------------------
_______________________________________________
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/