[otrs] error in upgrade from 2.1.4 to 2.2.0

Jozsef Valkai jvalkai at gmail.com
Tue Apr 10 17:36:23 GMT 2007


Sorry, I dont remember, but I have got another error when I tried
upgrade the real system from 2.1.4 to 2.2.0-beta1.

I upgraded database, and when I create a new ticket with Postmaster.pl
( echo test|mail otrs at localhost):

Apr 10 17:33:59 ubuntu OTRS-CGI-10[4630]:
[Error][Kernel::System::Queue::QueueGet][Line:880]: Found no $ID for
7!
Apr 10 17:33:59 ubuntu OTRS-CGI-10[4630]:
[Error][Kernel::System::Queue::QueueGet][Line:850]: ERROR:  column
q.first_response_time does not exist , SQL: 'SELECT q.name,
q.group_id, q.unlock_timeout,  q.system_address_id, q.salutation_id,
q.signature_id, q.comments, q.valid_id,  q.first_response_time,
q.update_time, q.solution_time,  q.follow_up_id, q.follow_up_lock,
sa.value0, sa.value1, q.id,  q.move_notify, q.state_notify,
q.lock_notify, q.owner_notify, q.default_sign_key,  q.calendar_name
FROM  queue q, system_address sa WHERE  q.system_address_id = sa.id
AND  q.id = 7'


Before created new ticket, I disabled other Agents.

-- 
Valkai Jozsef
+36 70 36 28 147
valkaij at externet.hu
jvalkai at gmail.com
lat:  +47° 30' 43.94"
lon: +19° 9' 9.39"


More information about the otrs mailing list