Hi, I just did an experimental upgrade on our otrs system and run into the problem that I cannot create new tickets with the Phone or Email button. I get the following error: Software error: Modification of non-creatable array value attempted, subscript -1 at /opt/otrs//Kernel/Output/HTML/Agent.pm line 432. When I check the log I see the following: Wed Nov 17 16:16:38 2004 error OTRS-CGI-10 Found no $ID for 5! Wed Nov 17 16:16:38 2004 error OTRS-CGI-10 Unknown column 'q.default_sign_key' in 'field list', 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.escalation_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 FROM queue q, system_address sa WHERE q.system_address_id = sa.id AND q.id = 5' Wed Nov 17 16:16:38 2004 error OTRS-CGI-10 Found no $ID for 31! Wed Nov 17 16:16:38 2004 error OTRS-CGI-10 Unknown column 'q.default_sign_key' in 'field list', 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.escalation_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 FROM queue q, system_address sa WHERE q.system_address_id = sa.id AND q.id = 31' Wed Nov 17 16:16:38 2004 error OTRS-CGI-10 Found no $ID for 19! Wed Nov 17 16:16:38 2004 error OTRS-CGI-10 Unknown column 'q.default_sign_key' in 'field list', 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.escalation_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 FROM queue q, system_address sa WHERE q.system_address_id = sa.id AND q.id = 19' Wed Nov 17 16:16:38 2004 error OTRS-CGI-10 Found no $ID for 24! Wed Nov 17 16:16:38 2004 error OTRS-CGI-10 Unknown column 'q.default_sign_key' in 'field list', 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.escalation_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 FROM queue q, system_address sa WHERE q.system_address_id = sa.id AND q.id = 24' Wed Nov 17 16:16:38 2004 error OTRS-CGI-10 Found no $ID for 20! Wed Nov 17 16:16:38 2004 error OTRS-CGI-10 Unknown column 'q.default_sign_key' in 'field list', 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.escalation_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 FROM queue q, system_address sa WHERE q.system_address_id = sa.id AND q.id = 20' Wed Nov 17 16:16:38 2004 error OTRS-CGI-10 Found no $ID for 14! Wed Nov 17 16:16:38 2004 error OTRS-CGI-10 Unknown column 'q.default_sign_key' in 'field list', 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.escalation_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 FROM queue q, system_address sa WHERE q.system_address_id = sa.id AND q.id = 14' Wed Nov 17 16:16:38 2004 error OTRS-CGI-10 Found no $ID for 3! Wed Nov 17 16:16:38 2004 error OTRS-CGI-10 Unknown column 'q.default_sign_key' in 'field list', SQL: 'SELECT q.name, q.group_id, q.unlock_timeout, q.system_address_id, q.salutation_id, q.signatu Regards, Jorick Astrego IBM Certified System Administrator - Lotus Notes and Domino Quality On-Line® Hengelosestraat 501 P.O. Box 1414 NL-7500 BK Enschede the Netherlands Phone +31 53 4809090 Fax +31 53 4342040 Internet http://www.qualityonline.com
participants (1)
-
Jorick Astrego