Hi. We are trying to implement in one our system interface to OTRS. We decide to use perl interface described on dev.otrs.org . In attachment is my perl script to create TT. This ticket is created but with many errors (second attachment) and cannot be viewed via web because problem with ArticleID. Thanks Juraj Bobek. ____________________________________________________________________________ ___________________ CreateTicket2.pl: #!/usr/bin/perl -w use File::Basename; use FindBin qw($RealBin); use lib dirname($RealBin); use lib dirname($RealBin)."/Kernel/cpan-lib"; use Kernel::Config; use Kernel::System::Time; use Kernel::System::Log; use Kernel::System::DB; use Kernel::System::Ticket; my $ConfigObject = Kernel::Config->new(); my $TimeObject = Kernel::System::Time->new( ConfigObject => $ConfigObject, ); my $LogObject = Kernel::System::Log->new( ConfigObject => $ConfigObject, ); my $DBObject = Kernel::System::DB->new( ConfigObject => $ConfigObject, LogObject => $LogObject, ); my $TicketObject = Kernel::System::Ticket->new( ConfigObject => $ConfigObject, LogObject => $LogObject, DBObject => $DBObject, ); my $TicketID = $TicketObject->TicketCreate( TN => $TicketObject->TicketCreateNumber(), QueueID => 123, # or Queue => 'SomeQueue' Lock => 'unlock', GroupID => 1, Priority => '3 normal' # or PriorityID => 2, State => 'new', # or StateID => 5, CustomerNo => '123465', CustomerUser => 'customer@example.com', UserID => 123, # new owner CreateUserID => 123, ); print "Ticket added. Ticket ID is $TicketID"; # -- exit (0); ____________________________________________________________________________ _______________ Error: Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004 Message: No such TicketID (26)! Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3025 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 345 Module: ./CreateTicket2.pl (v) Line: 39 Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004 Message: No such TicketID (26)! Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3030 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 345 Module: ./CreateTicket2.pl (v) Line: 39 Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004 Message: No such TicketID (26)! Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3035 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 345 Module: ./CreateTicket2.pl (v) Line: 39 Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. DBD::mysql::db do failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , 1, current_timestamp, 1000, current_timestamp, 1000)' at at /opt/otrs/Kernel/System/DB.pm line 376. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004 Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , 1, current_timestamp, 1000, current_timestamp, 1000)' at, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, valid_id, create_time, create_by, change_time, change_by) VALUES ('%%200411041028%%inms%%3 normal%%new%%26', 1, 26, 0, 5, , , , 1, current_timestamp, 1000, current_timestamp, 1000)' Traceback (8901): Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3048 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 345 Module: ./CreateTicket2.pl (v) Line: 39 Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004 Message: No such TicketID (26)! Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::TicketQueueID (v1.19) Line: 608 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3020 Module: Kernel::System::Ticket::SetCustomerData (v1.19) Line: 878 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 353 Module: ./CreateTicket2.pl (v) Line: 39 Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004 Message: No such TicketID (26)! Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3025 Module: Kernel::System::Ticket::SetCustomerData (v1.19) Line: 878 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 353 Module: ./CreateTicket2.pl (v) Line: 39 Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004 Message: No such TicketID (26)! Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3030 Module: Kernel::System::Ticket::SetCustomerData (v1.19) Line: 878 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 353 Module: ./CreateTicket2.pl (v) Line: 39 Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004 Message: No such TicketID (26)! Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3035 Module: Kernel::System::Ticket::SetCustomerData (v1.19) Line: 878 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 353 Module: ./CreateTicket2.pl (v) Line: 39 Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. DBD::mysql::db do failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , , 1, current_timestamp, 1000, current_timestamp, 1000)' at /opt/otrs/Kernel/System/DB.pm line 376. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004 Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , , 1, current_timestamp, 1000, current_timestamp, 1000)' , SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, valid_id, create_time, create_by, change_time, change_by) VALUES ('%%CustomerID=1002\;CustomerUser=jurko@sk15392c.siemens-pse.sk\;', 21, 26, 0, , , , , 1, current_timestamp, 1000, current_timestamp, 1000)' Traceback (8901): Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3048 Module: Kernel::System::Ticket::SetCustomerData (v1.19) Line: 878 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 353 Module: ./CreateTicket2.pl (v) Line: 39 ___________________________________________ S pozdravom (Mit freundlichem Gruß / kind regards) Dipl. Ing. Juraj Bobek Siemens Program and System Engineering s.r.o. IT Developer SMC BI ZA Tel.: +421(41)5055828 Fax: +421(41)5055809 mailto:Juraj.Bobek@siemens.com
Hello, can't help you, but to all of you I'd like to say that thsi is a ****typical*typical ***** situation, which would probably be avoided with automated tests /G -- www.gh-webinteractive.com
Hi. We are trying to implement in one our system interface to OTRS. We decide to use perl interface described on dev.otrs.org . In attachment is my perl script to create TT. This ticket is created but with many errors (second attachment) and cannot be viewed via web because problem with ArticleID. Thanks Juraj Bobek. ____________________________________________________________________________ ___________________ CreateTicket2.pl: #!/usr/bin/perl -w
use File::Basename; use FindBin qw($RealBin); use lib dirname($RealBin); use lib dirname($RealBin)."/Kernel/cpan-lib";
use Kernel::Config; use Kernel::System::Time; use Kernel::System::Log; use Kernel::System::DB; use Kernel::System::Ticket; my $ConfigObject = Kernel::Config->new(); my $TimeObject = Kernel::System::Time->new( ConfigObject => $ConfigObject, ); my $LogObject = Kernel::System::Log->new( ConfigObject => $ConfigObject, ); my $DBObject = Kernel::System::DB->new( ConfigObject => $ConfigObject, LogObject => $LogObject, ); my $TicketObject = Kernel::System::Ticket->new( ConfigObject => $ConfigObject, LogObject => $LogObject, DBObject => $DBObject, );
my $TicketID = $TicketObject->TicketCreate( TN => $TicketObject->TicketCreateNumber(), QueueID => 123, # or Queue => 'SomeQueue' Lock => 'unlock', GroupID => 1, Priority => '3 normal' # or PriorityID => 2, State => 'new', # or StateID => 5, CustomerNo => '123465', CustomerUser => 'customer@example.com', UserID => 123, # new owner CreateUserID => 123, ); print "Ticket added. Ticket ID is $TicketID";
# -- exit (0); ____________________________________________________________________________ _______________ Error:
Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004
Message: No such TicketID (26)!
Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3025 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 345 Module: ./CreateTicket2.pl (v) Line: 39
Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004
Message: No such TicketID (26)!
Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3030 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 345 Module: ./CreateTicket2.pl (v) Line: 39
Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004
Message: No such TicketID (26)!
Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3035 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 345 Module: ./CreateTicket2.pl (v) Line: 39
Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. DBD::mysql::db do failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , 1, current_timestamp, 1000, current_timestamp, 1000)' at at /opt/otrs/Kernel/System/DB.pm line 376. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004
Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , 1, current_timestamp, 1000, current_timestamp, 1000)' at, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, valid_id, create_time, create_by, change_time, change_by) VALUES ('%%200411041028%%inms%%3 normal%%new%%26', 1, 26, 0, 5, , , , 1, current_timestamp, 1000, current_timestamp, 1000)'
Traceback (8901): Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3048 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 345 Module: ./CreateTicket2.pl (v) Line: 39
Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004
Message: No such TicketID (26)!
Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::TicketQueueID (v1.19) Line: 608 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3020 Module: Kernel::System::Ticket::SetCustomerData (v1.19) Line: 878 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 353 Module: ./CreateTicket2.pl (v) Line: 39
Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004
Message: No such TicketID (26)!
Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3025 Module: Kernel::System::Ticket::SetCustomerData (v1.19) Line: 878 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 353 Module: ./CreateTicket2.pl (v) Line: 39
Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004
Message: No such TicketID (26)!
Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3030 Module: Kernel::System::Ticket::SetCustomerData (v1.19) Line: 878 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 353 Module: ./CreateTicket2.pl (v) Line: 39
Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004
Message: No such TicketID (26)!
Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3035 Module: Kernel::System::Ticket::SetCustomerData (v1.19) Line: 878 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 353 Module: ./CreateTicket2.pl (v) Line: 39
Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. DBD::mysql::db do failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , , 1, current_timestamp, 1000, current_timestamp, 1000)' at /opt/otrs/Kernel/System/DB.pm line 376. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004
Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , , 1, current_timestamp, 1000, current_timestamp, 1000)' , SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, valid_id, create_time, create_by, change_time, change_by) VALUES ('%%CustomerID=1002\;CustomerUser=jurko@sk15392c.siemens-pse.sk\;', 21, 26, 0, , , , , 1, current_timestamp, 1000, current_timestamp, 1000)'
Traceback (8901): Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3048 Module: Kernel::System::Ticket::SetCustomerData (v1.19) Line: 878 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 353 Module: ./CreateTicket2.pl (v) Line: 39
___________________________________________ S pozdravom (Mit freundlichem Gruß / kind regards) Dipl. Ing. Juraj Bobek Siemens Program and System Engineering s.r.o. IT Developer SMC BI ZA Tel.: +421(41)5055828 Fax: +421(41)5055809 mailto:Juraj.Bobek@siemens.com
_______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
Hi Bob, bobsmith1@marketweighton.com wrote:
can't help you, but to all of you I'd like to say that thsi is a ****typical*typical ***** situation, which would probably be avoided with automated tests
Not in this case. But anyway, automated tests would be very fine. PS: I still tinking about, I'll answer your emails soon as possible.
/G
Martin Edenhofer -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication!
Hi Bob,
bobsmith1@marketweighton.com wrote:
can't help you, but to all of you I'd like to say that thsi is a ****typical*typical ***** situation, which would probably be avoided with automated tests
Not in this case. But anyway, automated tests would be very fine.
PS: I still tinking about, I'll answer your emails soon as possible.
/G martin okey so I was wrong in this case, but after readign the book extreme programming and getting aquainted with testdriven developemtn I really became a fan of them both, I strongly think it would help the OTRS community. but.....it would mean a new way of working... /G -- www.gh-webinteractive.com
Martin Edenhofer
-- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication!
_______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
Hi Juraj, it's because each ticket needs also an article. That means one ticket has n article. I modified your script and added the ArticleCreate(). This should now working fine. :) PS: I'll answer your pm questions soon as possibe (sorry I was on business travel). Martin Edenhofer -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication! Bobek Juraj wrote:
Hi. We are trying to implement in one our system interface to OTRS. We decide to use perl interface described on dev.otrs.org . In attachment is my perl script to create TT. This ticket is created but with many errors (second attachment) and cannot be viewed via web because problem with ArticleID. Thanks Juraj Bobek. ____________________________________________________________________________ ___________________ CreateTicket2.pl: #!/usr/bin/perl -w
use File::Basename; use FindBin qw($RealBin); use lib dirname($RealBin); use lib dirname($RealBin)."/Kernel/cpan-lib";
use Kernel::Config; use Kernel::System::Time; use Kernel::System::Log; use Kernel::System::DB; use Kernel::System::Ticket; my $ConfigObject = Kernel::Config->new(); my $TimeObject = Kernel::System::Time->new( ConfigObject => $ConfigObject, ); my $LogObject = Kernel::System::Log->new( ConfigObject => $ConfigObject, ); my $DBObject = Kernel::System::DB->new( ConfigObject => $ConfigObject, LogObject => $LogObject, ); my $TicketObject = Kernel::System::Ticket->new( ConfigObject => $ConfigObject, LogObject => $LogObject, DBObject => $DBObject, );
my $TicketID = $TicketObject->TicketCreate( TN => $TicketObject->TicketCreateNumber(), QueueID => 123, # or Queue => 'SomeQueue' Lock => 'unlock', GroupID => 1, Priority => '3 normal' # or PriorityID => 2, State => 'new', # or StateID => 5, CustomerNo => '123465', CustomerUser => 'customer@example.com', UserID => 123, # new owner CreateUserID => 123, ); print "Ticket added. Ticket ID is $TicketID";
# -- exit (0); ____________________________________________________________________________ _______________ Error:
Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004
Message: No such TicketID (26)!
Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3025 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 345 Module: ./CreateTicket2.pl (v) Line: 39
Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004
Message: No such TicketID (26)!
Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3030 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 345 Module: ./CreateTicket2.pl (v) Line: 39
Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004
Message: No such TicketID (26)!
Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3035 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 345 Module: ./CreateTicket2.pl (v) Line: 39
Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. DBD::mysql::db do failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , 1, current_timestamp, 1000, current_timestamp, 1000)' at at /opt/otrs/Kernel/System/DB.pm line 376. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004
Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , 1, current_timestamp, 1000, current_timestamp, 1000)' at, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, valid_id, create_time, create_by, change_time, change_by) VALUES ('%%200411041028%%inms%%3 normal%%new%%26', 1, 26, 0, 5, , , , 1, current_timestamp, 1000, current_timestamp, 1000)'
Traceback (8901): Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3048 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 345 Module: ./CreateTicket2.pl (v) Line: 39
Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004
Message: No such TicketID (26)!
Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::TicketQueueID (v1.19) Line: 608 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3020 Module: Kernel::System::Ticket::SetCustomerData (v1.19) Line: 878 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 353 Module: ./CreateTicket2.pl (v) Line: 39
Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004
Message: No such TicketID (26)!
Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3025 Module: Kernel::System::Ticket::SetCustomerData (v1.19) Line: 878 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 353 Module: ./CreateTicket2.pl (v) Line: 39
Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004
Message: No such TicketID (26)!
Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3030 Module: Kernel::System::Ticket::SetCustomerData (v1.19) Line: 878 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 353 Module: ./CreateTicket2.pl (v) Line: 39
Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004
Message: No such TicketID (26)!
Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3035 Module: Kernel::System::Ticket::SetCustomerData (v1.19) Line: 878 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 353 Module: ./CreateTicket2.pl (v) Line: 39
Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. DBD::mysql::db do failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , , 1, current_timestamp, 1000, current_timestamp, 1000)' at /opt/otrs/Kernel/System/DB.pm line 376. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004
Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , , 1, current_timestamp, 1000, current_timestamp, 1000)' , SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, valid_id, create_time, create_by, change_time, change_by) VALUES ('%%CustomerID=1002\;CustomerUser=jurko@sk15392c.siemens-pse.sk\;', 21, 26, 0, , , , , 1, current_timestamp, 1000, current_timestamp, 1000)'
Traceback (8901): Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3048 Module: Kernel::System::Ticket::SetCustomerData (v1.19) Line: 878 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 353 Module: ./CreateTicket2.pl (v) Line: 39
___________________________________________ S pozdravom (Mit freundlichem Gruß / kind regards) Dipl. Ing. Juraj Bobek Siemens Program and System Engineering s.r.o. IT Developer SMC BI ZA Tel.: +421(41)5055828 Fax: +421(41)5055809 mailto:Juraj.Bobek@siemens.com
------------------------------------------------------------------------
_______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
--
participants (3)
-
Bobek Juraj -
bobsmith1＠marketweighton.com -
Martin Edenhofer