Error when sending mail from Web

RT Users
1

Hi,
I have installed RT 2.0.15 under Pg 7.3.
Quite everything works well except that when I create a ticket or
reply/resolve a ticket ON THE WEB (mail works well), I have errors.

When creating a ticket from the web:

Can’t bind a reference (Class::ReturnValue=HASH(0xc26c524)) at /usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 376, line 103.

Stack:
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm:376]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm:319]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:636]
[/opt/rt2/lib/RT/Ticket.pm:342]
[/opt/rt2/WebRT/html/Ticket/Display.html:87]
[/opt/rt2/WebRT/html/autohandler:58]

When resolving a ticket, the status is changed (see it in the history) but the comment is not recoded. Error I get:
Can’t bind a reference (Class::ReturnValue=HASH(0xc296f5c)) at /usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 376, line 107.

Stack:
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm:376]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:837]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:761]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record/Cachable.pm:106]
[/opt/rt2/lib/RT/Record.pm:140]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:782]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:708]
[/opt/rt2/lib/RT/Transaction.pm:93]
[/opt/rt2/lib/RT/Ticket.pm:2773]
[/opt/rt2/lib/RT/Ticket.pm:1740]
[/opt/rt2/lib/RT/Interface/Web.pm:347]
[/opt/rt2/WebRT/html/Ticket/Display.html:139]

[/opt/rt2/WebRT/html/autohandler:58]

Any idea?
Thanks
-jec

2

Try dropping down to DBIx-SearchBuilder 0.6x. Has anyone else seen this
issue pop up? It’s related to the new error handling in
DBIx-SearchBuilder 0.7x, but I’m not quite sure what’s going on just
yet.

-jOn Fri, Dec 13, 2002 at 11:40:42AM +0100, Jean-Eric Cuendet wrote:

Hi,
I have installed RT 2.0.15 under Pg 7.3.
Quite everything works well except that when I create a ticket or
reply/resolve a ticket ON THE WEB (mail works well), I have errors.

When creating a ticket from the web:

Can’t bind a reference (Class::ReturnValue=HASH(0xc26c524)) at
/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 376, line
103.

Stack:
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm:376]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm:319]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:636]
[/opt/rt2/lib/RT/Ticket.pm:342]
[/opt/rt2/WebRT/html/Ticket/Display.html:87]
[/opt/rt2/WebRT/html/autohandler:58]

When resolving a ticket, the status is changed (see it in the history) but
the comment is not recoded. Error I get:
Can’t bind a reference (Class::ReturnValue=HASH(0xc296f5c)) at
/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 376, line
107.

Stack:
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm:376]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:837]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:761]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record/Cachable.pm:106]
[/opt/rt2/lib/RT/Record.pm:140]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:782]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:708]
[/opt/rt2/lib/RT/Transaction.pm:93]
[/opt/rt2/lib/RT/Ticket.pm:2773]
[/opt/rt2/lib/RT/Ticket.pm:1740]
[/opt/rt2/lib/RT/Interface/Web.pm:347]
[/opt/rt2/WebRT/html/Ticket/Display.html:139]

[/opt/rt2/WebRT/html/autohandler:58]

Any idea?
Thanks
-jec

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

»|« Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

3

Try dropping down to DBIx-SearchBuilder 0.6x. Has anyone else seen this
issue pop up? It’s related to the new error handling in
DBIx-SearchBuilder 0.7x, but I’m not quite sure what’s going on just
yet.

OK, thanks for the answer.
That worksnow!
-jec

4

Hi,
Sorry, I was wrong! It don’t work either with 0.63!
In fact, when I click reply on a ticket, I have a page, then fill the fields, submit, then I have the following error with 0.71 :

Can’t locate object method “return_error” via package “Class::ReturnValue” (perhaps you forgot to load “Class::ReturnValue”?) at /usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 380, line 106.

Stack:
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm:380]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm:89]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle/Pg.pm:49]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:848]
[/opt/rt2/lib/RT/Record.pm:100]
[/opt/rt2/lib/RT/Transaction.pm:84]
[/opt/rt2/lib/RT/Ticket.pm:2773]
[/opt/rt2/lib/RT/Ticket.pm:1740]
[/opt/rt2/lib/RT/Interface/Web.pm:347]
[/opt/rt2/WebRT/html/Ticket/Display.html:139]
[/opt/rt2/WebRT/html/autohandler:58]

With 0.63, when replying:

Can’t locate object method “return_error” via package “Class::ReturnValue” (perhaps you forgot to load “Class::ReturnValue”?) at /usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 380, line 108.

Stack:
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm:380]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm:89]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle/Pg.pm:49]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:848]
[/opt/rt2/lib/RT/Record.pm:100]
[/opt/rt2/lib/RT/Transaction.pm:84]
[/opt/rt2/lib/RT/Ticket.pm:2773]
[/opt/rt2/lib/RT/Ticket.pm:1740]
[/opt/rt2/lib/RT/Interface/Web.pm:347]
[/opt/rt2/WebRT/html/Ticket/Display.html:139]
[/opt/rt2/WebRT/html/autohandler:58]

When I create a new ticket with 0.63:

Can’t locate object method “return_error” via package “Class::ReturnValue” (perhaps you forgot to load “Class::ReturnValue”?) at /usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 380, line 108.

Stack:
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm:380]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm:89]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle/Pg.pm:49]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:848]
[/opt/rt2/lib/RT/Record.pm:100]
[/opt/rt2/lib/RT/Ticket.pm:326]
[/opt/rt2/WebRT/html/Ticket/Display.html:87]
[/opt/rt2/WebRT/html/autohandler:58]

And when I click back in the browser, and then submit again, no more
error, but a message saying the entry is duplicated. But the comment is
not stored in the ticket…
Any idea?
Thanks alot.
-jec

PS: BTW, what are RT 2.1.9 and RT 3.0 ? Are there prod ready? What’s new?

5

Ok. Next fix I’d like you to test with searchbuilder 0.73:

Ticket::Create has the following lines:

 InitialPriority => undef,
     FinalPriority => undef,

fairly near the top. try replacing them with:

     InitialPriority => "0",
     FinalPriority => "0",On Mon, Dec 16, 2002 at 09:48:04AM +0100, Jean-Eric Cuendet wrote:

Try dropping down to DBIx-SearchBuilder 0.6x. Has anyone else seen this
issue pop up? It’s related to the new error handling in
DBIx-SearchBuilder 0.7x, but I’m not quite sure what’s going on just
yet.

OK, thanks for the answer.
That worksnow!
-jec

»|« Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

6

So, I have the error even with that.
Some infos:

  • I have Pg 7.3 . Is it the problem? Should I go back to 7.2?
  • I put again SearchBuilder 0.73
  • I changed in /opt/rt2/lib/RT/Ticket.pm line 188:
    InitialPriority => undef,
    FinalPriority => undef,
    to
    InitialPriority => “0”,
    FinalPriority => “0”,
    OK?
  • Restarted Apache
  • Then I have the following stack:

Can’t bind a reference (Class::ReturnValue=HASH(0x8cecf50)) at /usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 376, line 197.

Stack:
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm:376]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:837]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:761]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record/Cachable.pm:106]
[/opt/rt2/lib/RT/Record.pm:140]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:782]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:708]
[/opt/rt2/lib/RT/Transaction.pm:93]
[/opt/rt2/lib/RT/Ticket.pm:2775]
[/opt/rt2/lib/RT/Ticket.pm:1691]
[/opt/rt2/lib/RT/Interface/Web.pm:338]
[/opt/rt2/WebRT/html/Ticket/Display.html:139]

Thanks for your help…
And ready to test other things.
-jec

7

Another thing worst noting, is that when doing Reply to ticket, then if
I just change the status from open->resolved, it works, no error.
But if I put a comment before Submitting, then I have the error
mentionned below.
-jec

Jean-Eric Cuendet wrote:

So, I have the error even with that.
Some infos:

  • I have Pg 7.3 . Is it the problem? Should I go back to 7.2?
  • I put again SearchBuilder 0.73
  • I changed in /opt/rt2/lib/RT/Ticket.pm line 188:
    InitialPriority => undef,
    FinalPriority => undef,
    to
    InitialPriority => “0”,
    FinalPriority => “0”,
    OK?
  • Restarted Apache
  • Then I have the following stack:

Can’t bind a reference (Class::ReturnValue=HASH(0x8cecf50)) at
/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 376,
line 197.

Stack:
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm:376]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:837]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:761]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record/Cachable.pm:106]
[/opt/rt2/lib/RT/Record.pm:140]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:782]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:708]
[/opt/rt2/lib/RT/Transaction.pm:93]
[/opt/rt2/lib/RT/Ticket.pm:2775]
[/opt/rt2/lib/RT/Ticket.pm:1691]
[/opt/rt2/lib/RT/Interface/Web.pm:338]
[/opt/rt2/WebRT/html/Ticket/Display.html:139]

Thanks for your help…
And ready to test other things.
-jec

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Jean-Eric Cuendet
Linkvest SA
Av des Baumettes 9, 1020 Renens Switzerland
Tel +41 21 632 9043 Fax +41 21 632 9090
E-mail: jean-eric.cuendet@linkvest.com
http://www.linkvest.com

8

I dropped PostgreSQL 7.3 and installed 7.2
All is fine now.
BTW, do you plan to add 7.3 support or is it a low priority task?
Thanks for your help.
-jec

Jean-Eric Cuendet wrote:

Another thing worst noting, is that when doing Reply to ticket, then
if I just change the status from open->resolved, it works, no error.
But if I put a comment before Submitting, then I have the error
mentionned below.
-jec

Jean-Eric Cuendet wrote:

So, I have the error even with that.
Some infos:

  • I have Pg 7.3 . Is it the problem? Should I go back to 7.2?
  • I put again SearchBuilder 0.73
  • I changed in /opt/rt2/lib/RT/Ticket.pm line 188:
    InitialPriority => undef,
    FinalPriority => undef,
    to
    InitialPriority => “0”,
    FinalPriority => “0”,
    OK?
  • Restarted Apache
  • Then I have the following stack:

Can’t bind a reference (Class::ReturnValue=HASH(0x8cecf50)) at
/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line
376, line 197.

Stack:
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm:376]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:837]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:761]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record/Cachable.pm:106]
[/opt/rt2/lib/RT/Record.pm:140]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:782]
[/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm:708]
[/opt/rt2/lib/RT/Transaction.pm:93]
[/opt/rt2/lib/RT/Ticket.pm:2775]
[/opt/rt2/lib/RT/Ticket.pm:1691]
[/opt/rt2/lib/RT/Interface/Web.pm:338]
[/opt/rt2/WebRT/html/Ticket/Display.html:139]

Thanks for your help…
And ready to test other things.
-jec

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Jean-Eric Cuendet
Linkvest SA
Av des Baumettes 9, 1020 Renens Switzerland
Tel +41 21 632 9043 Fax +41 21 632 9090
E-mail: jean-eric.cuendet@linkvest.com
http://www.linkvest.com