Search bug - missing _SQLJoin, 3.0.11rc2

RT Developers
1

I have a ticket that has two parts, one plain text ASCII and one HTML text

Tickets | New Search, Ticket attachment content matches 209.80.7.69 .

On 3.0.10, I get five matches. On 3.0.11rc2 I get zero. Both instances are
pointing at the same db. Both running perl 5.8.4. .10 is on Red Hat 8 -
.11 is on FreeBSD 4.9.

On .11rc2, I get the following error during the search:

root@help1 (/opt/rt3/etc/) 180> [Sun May 16 06:19:09 2004] [error]: Can’t
locate object method “_SQLJoin” via package “RT::Tickets” at
/opt/rt3/lib/RT/Tickets_Overlay.pm line 550.

Stack:
[/opt/rt3/lib/RT/Tickets_Overlay.pm:550]
[/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm:280]
[/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm:362]
[/opt/rt3/lib/RT/Tickets_Overlay.pm:2063]
[/opt/rt3/lib/RT/Tickets_Overlay.pm:1773]
[/opt/rt3/share/html/Search/Listing.html:104]
[/opt/rt3/share/html/autohandler:196]
(/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm:363)

I’m not clueful enough to debug futher.

matthew zeier, Sr. Network Engineer | “Nothing in life is to be feared.
InteleNet Communications, Inc. | It is only to be understood.”
(949) 784-7904 | - Marie Curie

2

This actually happens with any search on Ticket content.From: “matthew zeier” mrz@intelenet.net
To: rt-devel@lists.fsck.com
Sent: Sunday, May 16, 2004 12:12 AM
Subject: [Rt-devel] search bug - missing _SQLJoin, 3.0.11rc2

I have a ticket that has two parts, one plain text ASCII and one HTML text
(sent from an Outlook client). There’s an IP address in the ticket
content.

Tickets | New Search, Ticket attachment content matches 209.80.7.69 .

On 3.0.10, I get five matches. On 3.0.11rc2 I get zero. Both instances
are
pointing at the same db. Both running perl 5.8.4. .10 is on Red Hat 8 -
.11 is on FreeBSD 4.9.

On .11rc2, I get the following error during the search:

root@help1 (/opt/rt3/etc/) 180> [Sun May 16 06:19:09 2004] [error]: Can’t
locate object method “_SQLJoin” via package “RT::Tickets” at
/opt/rt3/lib/RT/Tickets_Overlay.pm line 550.

Stack:
[/opt/rt3/lib/RT/Tickets_Overlay.pm:550]
[/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm:280]
[/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm:362]
[/opt/rt3/lib/RT/Tickets_Overlay.pm:2063]
[/opt/rt3/lib/RT/Tickets_Overlay.pm:1773]
[/opt/rt3/share/html/Search/Listing.html:104]
[/opt/rt3/share/html/autohandler:196]
(/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm:363)

I’m not clueful enough to debug futher.

–
matthew zeier, Sr. Network Engineer | “Nothing in life is to be feared.
InteleNet Communications, Inc. | It is only to be understood.”
(949) 784-7904 | - Marie Curie

Rt-devel mailing list
Rt-devel@lists.bestpractical.com
The rt-devel Archives

3

root@help1 (/opt/rt3/etc/) 180> [Sun May 16 06:19:09 2004] [error]: Can’t
locate object method “_SQLJoin” via package “RT::Tickets” at
/opt/rt3/lib/RT/Tickets_Overlay.pm line 550.

That’s weird. Does your Tickets_Overlay_SQL.pm have C< sub _SQLJoin >?

-R

4

root@help1 (/opt/rt3/etc/) 180> [Sun May 16 06:19:09 2004] [error]:
Can’t
locate object method “_SQLJoin” via package “RT::Tickets” at
/opt/rt3/lib/RT/Tickets_Overlay.pm line 550.

That’s weird. Does your Tickets_Overlay_SQL.pm have C< sub _SQLJoin >?

No -

root@help1 (/opt/rt3/lib/RT/) 190> grep _SQLJoin Tickets_Overlay_SQL.pm
root@help1 (/opt/rt3/lib/RT/) 191> grep _SQLJoin
~mrz/work/build/RT/rt-3.0.11rc2/lib/RT/Tickets_Overlay_SQL.pm

Not in the dist either.

matthew zeier - “Nothing in life is to be feared. It is only to be
understood.” - Marie Curie

5

That’s weird. Does your Tickets_Overlay_SQL.pm have C< sub _SQLJoin >?
No -
root@help1 (/opt/rt3/lib/RT/) 190> grep _SQLJoin Tickets_Overlay_SQL.pm
root@help1 (/opt/rt3/lib/RT/) 191> grep _SQLJoin
~mrz/work/build/RT/rt-3.0.11rc2/lib/RT/Tickets_Overlay_SQL.pm

Not in the dist either.

Not in the repository either. That’s definitely wrong. I’ll open a
ticket.

A quick fix is to add:

sub SQLJoin {
my $this = shift;
$this->SUPER::Join(@,
SUBCLAUSE => ‘ticketsql’);
}

to your Tickets_Overlay_SQL.pm

-R

6

Looks like a bugfix backported from RT 3.1 was improperly applied.
RC3 should be up momentarily.On Sun, May 16, 2004 at 07:30:47PM -0700, matthew zeier wrote:

On May 16, 2004, at 11:05 AM, Robert Spier wrote:

root@help1 (/opt/rt3/etc/) 180> [Sun May 16 06:19:09 2004] [error]:
Can’t
locate object method “_SQLJoin” via package “RT::Tickets” at
/opt/rt3/lib/RT/Tickets_Overlay.pm line 550.

That’s weird. Does your Tickets_Overlay_SQL.pm have C< sub _SQLJoin >?

No -

root@help1 (/opt/rt3/lib/RT/) 190> grep _SQLJoin Tickets_Overlay_SQL.pm
root@help1 (/opt/rt3/lib/RT/) 191> grep _SQLJoin
~mrz/work/build/RT/rt-3.0.11rc2/lib/RT/Tickets_Overlay_SQL.pm

Not in the dist either.

–
matthew zeier - “Nothing in life is to be feared. It is only to be
understood.” - Marie Curie

Rt-devel mailing list
Rt-devel@lists.bestpractical.com
The rt-devel Archives

7

Looks like a bugfix backported from RT 3.1 was improperly applied.
RC3 should be up momentarily.

I take it back. A new build platform has turned up a couple regressions
with the new code that I need to look into in more detail. And 3 am
isn’t the right time to do that.

Jesse
8

All better now.

I’ll await rc3 before complaining more :)----- Original Message -----
From: “Robert Spier” rspier@pobox.com
To: “matthew zeier” mrz@intelenet.net
Cc: rt-devel@lists.fsck.com
Sent: Sunday, May 16, 2004 7:47 PM
Subject: Re: [Rt-devel] search bug - missing _SQLJoin, 3.0.11rc2

That’s weird. Does your Tickets_Overlay_SQL.pm have C< sub _SQLJoin
?
No -
root@help1 (/opt/rt3/lib/RT/) 190> grep _SQLJoin Tickets_Overlay_SQL.pm
root@help1 (/opt/rt3/lib/RT/) 191> grep _SQLJoin
~mrz/work/build/RT/rt-3.0.11rc2/lib/RT/Tickets_Overlay_SQL.pm

Not in the dist either.

Not in the repository either. That’s definitely wrong. I’ll open a
ticket.

A quick fix is to add:

sub SQLJoin {
my $this = shift;
$this->SUPER::Join(@,
SUBCLAUSE => ‘ticketsql’);
}

to your Tickets_Overlay_SQL.pm

-R

9

All better now.

I’ll await rc3 before complaining more.

Do you have other issues you’re seeing? If so, I’d dearly love to
address them BEFORE another release.