[rt-users] warning message on set ReferTo

[Alex Peters]

I can't see any obvious problems based on your error messages.

There seems to be a typo in the code.  Is that directly copied from your
script?

Have you considered enabling debugging from within your script?

On Thu, 18 Dec 2014 5:04 am Payam Poursaied <me at payam124.com> wrote:

> Hi All
> I have created a script which has below command to create a link
> $Ticket->AddLink(Type=>'RefersTo',Target=>$pticket_id,
> RecordTransactiosn=>0)
> ;
>
> When I run the script ReferTo link created, but I got below warning as
> well.
> RT version 4.2.8
> And line 149 of 02.pl is exit line.
>
> Any idea?
>
> [85829] [Wed Dec 17 07:14:20 2014] [warning]: RT::Handle=HASH(0x802572648)
> couldn't execute the query 'SELECT  * FROM Tickets WHERE id = ?' at
> /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Handle.pm line
> 602.
>
> DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x802572648),
> "SELECT  * FROM Tickets WHERE id = ?", 3311056) called at
> /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Record.pm line
> 1234
>
> DBIx::SearchBuilder::Record::_LoadFromSQL(RT::Ticket=HASH(0x80e255cf0),
> "SELECT  * FROM Tickets WHERE id = ?", 3311056) called at
> /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Record.pm line
> 1153
>
> DBIx::SearchBuilder::Record::LoadByCols(RT::Ticket=HASH(0x80e255cf0),
> "id",
> 3311056) called at
> /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Record/Cachable.
> pm
> line 120
>
> DBIx::SearchBuilder::Record::Cachable::LoadByCols(RT::
> Ticket=HASH(0x80e255cf
> 0), "id", 3311056) called at /opt/rt4/lib//RT/Record.pm line 396
>         RT::Record::LoadByCols(RT::Ticket=HASH(0x80e255cf0), "id",
> 3311056)
> called at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/
> SearchBuilder/Record.pm
> line 1168
>         DBIx::SearchBuilder::Record::LoadById(RT::Ticket=HASH(
> 0x80e255cf0),
> 3311056) called at /opt/rt4/lib//RT/Ticket.pm line 146
>         RT::Ticket::Load(RT::Ticket=HASH(0x80e255cf0), 3311056) called at
> /opt/rt4/lib//RT/Ticket.pm line 2581
>         RT::Ticket::_ApplyTransactionBatch(RT::Ticket=HASH(0x80dd1a9f0))
> called at /opt/rt4/lib//RT/Ticket.pm line 2569
>         RT::Ticket::ApplyTransactionBatch(RT::Ticket=HASH(0x80dd1a9f0))
> called at /opt/rt4/lib//RT/Ticket.pm line 2639
>         RT::Ticket::DESTROY(RT::Ticket=HASH(0x80dd1a9f0)) called at 02.pl
> line 149
>         eval {...} called at 02.pl line 149
> (/usr/local/lib/perl5/site_perl/5.14.2/Carp.pm:169)
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20141217/6b5156a7/attachment.htm>