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