<p dir="ltr">I can't see any obvious problems based on your error messages.</p>
<p dir="ltr">There seems to be a typo in the code. Is that directly copied from your script?</p>
<p dir="ltr">Have you considered enabling debugging from within your script?<br>
</p>
<br><div class="gmail_quote">On Thu, 18 Dec 2014 5:04 am Payam Poursaied <<a href="mailto:me@payam124.com">me@payam124.com</a>> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi All<br>
I have created a script which has below command to create a link<br>
$Ticket->AddLink(Type=>'<u></u>RefersTo',Target=>$pticket_id,<u></u>RecordTransactiosn=>0)<br>
;<br>
<br>
When I run the script ReferTo link created, but I got below warning as well.<br>
RT version 4.2.8<br>
And line 149 of <a href="http://02.pl" target="_blank">02.pl</a> is exit line.<br>
<br>
Any idea?<br>
<br>
[85829] [Wed Dec 17 07:14:20 2014] [warning]: RT::Handle=HASH(0x802572648)<br>
couldn't execute the query 'SELECT * FROM Tickets WHERE id = ?' at<br>
/usr/local/lib/perl5/site_<u></u>perl/5.14.2/DBIx/<u></u>SearchBuilder/Handle.pm line 602.<br>
<br>
DBIx::SearchBuilder::Handle::<u></u>SimpleQuery(RT::Handle=HASH(<u></u>0x802572648),<br>
"SELECT * FROM Tickets WHERE id = ?", 3311056) called at<br>
/usr/local/lib/perl5/site_<u></u>perl/5.14.2/DBIx/<u></u>SearchBuilder/Record.pm line 1234<br>
<br>
DBIx::SearchBuilder::Record::_<u></u>LoadFromSQL(RT::Ticket=HASH(<u></u>0x80e255cf0),<br>
"SELECT * FROM Tickets WHERE id = ?", 3311056) called at<br>
/usr/local/lib/perl5/site_<u></u>perl/5.14.2/DBIx/<u></u>SearchBuilder/Record.pm line 1153<br>
<br>
DBIx::SearchBuilder::Record::<u></u>LoadByCols(RT::Ticket=HASH(<u></u>0x80e255cf0), "id",<br>
3311056) called at<br>
/usr/local/lib/perl5/site_<u></u>perl/5.14.2/DBIx/<u></u>SearchBuilder/Record/Cachable.<u></u>pm<br>
line 120<br>
<br>
DBIx::SearchBuilder::Record::<u></u>Cachable::LoadByCols(RT::<u></u>Ticket=HASH(0x80e255cf<br>
0), "id", 3311056) called at /opt/rt4/lib//RT/Record.pm line 396<br>
RT::Record::LoadByCols(RT::<u></u>Ticket=HASH(0x80e255cf0), "id", 3311056)<br>
called at /usr/local/lib/perl5/site_<u></u>perl/5.14.2/DBIx/<u></u>SearchBuilder/Record.pm<br>
line 1168<br>
DBIx::SearchBuilder::Record::<u></u>LoadById(RT::Ticket=HASH(<u></u>0x80e255cf0),<br>
3311056) called at /opt/rt4/lib//RT/Ticket.pm line 146<br>
RT::Ticket::Load(RT::Ticket=<u></u>HASH(0x80e255cf0), 3311056) called at<br>
/opt/rt4/lib//RT/Ticket.pm line 2581<br>
RT::Ticket::_<u></u>ApplyTransactionBatch(RT::<u></u>Ticket=HASH(0x80dd1a9f0))<br>
called at /opt/rt4/lib//RT/Ticket.pm line 2569<br>
RT::Ticket::<u></u>ApplyTransactionBatch(RT::<u></u>Ticket=HASH(0x80dd1a9f0))<br>
called at /opt/rt4/lib//RT/Ticket.pm line 2639<br>
RT::Ticket::DESTROY(RT::<u></u>Ticket=HASH(0x80dd1a9f0)) called at <a href="http://02.pl" target="_blank">02.pl</a><br>
line 149<br>
eval {...} called at <a href="http://02.pl" target="_blank">02.pl</a> line 149<br>
(/usr/local/lib/perl5/site_<u></u>perl/5.14.2/Carp.pm:169)<br>
<br>
</blockquote></div>