
Hello, On Tue, Apr 10, 2007 at 05:36:23PM +0200, Jozsef Valkai wrote:
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@localhost):
That command does not work. You have to pipe the message into the PostMaster.pl module which can be found in $OTRSHOME/bin directory.
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'
This looks like an broken update. I can not say what went wrong without access to your system :(.
Before created new ticket, I disabled other Agents.
That should be no problem.
Valkai Jozsef
-- Christian ((otrs)) :: OTRS GmbH :: Norsk-Data-Strasse 1 :: 61352 Bad Homburg Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! Geschäftsführer: André Mindermann, Martin Edenhofer Handelsregister: HRB 9452 Bad Homburg Steuernummer: 003/240/97521