Duplicate tickets listing after Searchbuilder upgrade

Hi,

just installed the latest -03 Searchbuilder from the RT site
and in the “Home” view I see each Tickets I requested TWICE.

Everything neatly sorted alphabetically ,…OK

Only in the “Tickets I requested” each Ticket is shown twice,. same clickable URL.

Yes, restarted apache.

Any ideas ?

Found a bug ?

TIA

Jansen Robert
Network Manager
VUB

What database are you using?
Can you turn on your database’s query-logging facility and send us the
SQL queries RT makes to display that page?

Thanks,
JesseOn Tue, Apr 15, 2003 at 01:41:40AM +0200, Robert Jansen wrote:

Hi,

just installed the latest -03 Searchbuilder from the RT site
and in the “Home” view I see each Tickets I requested TWICE.

Everything neatly sorted alphabetically ,…OK

Only in the “Tickets I requested” each Ticket is shown twice,. same clickable URL.

Yes, restarted apache.

Any ideas ?

Found a bug ?

TIA

Jansen Robert
Network Manager
VUB


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.

What database are you using?

030402 16:34:43 InnoDB: Started
/usr/local/mysql-standard-4.0.12-sun-solaris2.8-sparc/bin/mysqld: ready for connections.
Version: ‘4.0.12-standard’ socket: ‘/tmp/mysql.sock’ port: 3306

Can you turn on your database’s query-logging facility and send us the
SQL queries RT makes to display that page?

Thanks,
Jesse

Sending you the file personaly, is 70Kb, don’t want to load the list with that.

TIA.

Jansen Robert

This one time, at band camp, Robert Jansen wrote:

just installed the latest -03 Searchbuilder from the RT site
and in the “Home” view I see each Tickets I requested TWICE.

Everything neatly sorted alphabetically ,…OK

Only in the “Tickets I requested” each Ticket is shown twice,. same clickable URL.

Yep, I see that too. Postgres backend, DBIx::Searchbuilder 0.81_02. Only
with the “Tickets I requested” pane.

jaq@spacepants.org http://spacepants.org/jaq.gpg

I see it too. expect a fix within the next few hours.On Tue, Apr 15, 2003 at 10:13:59AM +1000, Jamie Wilkinson wrote:

This one time, at band camp, Robert Jansen wrote:

just installed the latest -03 Searchbuilder from the RT site
and in the “Home” view I see each Tickets I requested TWICE.

Everything neatly sorted alphabetically ,…OK

Only in the “Tickets I requested” each Ticket is shown twice,. same clickable URL.

Yep, I see that too. Postgres backend, DBIx::Searchbuilder 0.81_02. Only
with the “Tickets I requested” pane.


jaq@spacepants.org http://spacepants.org/jaq.gpg


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.

I see it too. expect a fix within the next few hours.

Ok. Go grab 0.81_04 and tell me if it does the right thing? There was a
bit of inverted logic.

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

This one time, at band camp, Jesse Vincent wrote:>On Mon, Apr 14, 2003 at 08:21:59PM -0400, Jesse Vincent wrote:

I see it too. expect a fix within the next few hours.

Ok. Go grab 0.81_04 and tell me if it does the right thing? There was a
bit of inverted logic.

Yep, that works. It’s also fixed a bug in the Create New Ticket page with
the Owner dropdown, that was listing each user 4 times. Thanks.

jaq@spacepants.org http://spacepants.org/jaq.gpg

At 11:51 AM +1000 4/15/03, Jamie Wilkinson wrote:

This one time, at band camp, Jesse Vincent wrote:

I see it too. expect a fix within the next few hours.

Ok. Go grab 0.81_04 and tell me if it does the right thing? There was a
bit of inverted logic.

Yep, that works. It’s also fixed a bug in the Create New Ticket page with
the Owner dropdown, that was listing each user 4 times. Thanks.


jaq@spacepants.org http://spacepants.org/jaq.gpg


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

Yes, DBIx::Searchbuilder 0.81_04 fixed the bug on my system (mysql
backend) too.

Thanks Jesse.

But on a sidenote, the buggy 03 version had a sideeffect in that it
sorted all listings alphabetically. Nice. is that a configurable
option somewhere ?

Cheers
Brussels University
Pleinlaan 2
Computer Center VUB/ULB (VUBnet)
Ing. Robert Jansen
B-1050 Brussels
Belgium (Europe)

email: rjansen@vub.ac.be
Tel: +32-2-650.36.94
Secr: +32-2-650.37.38
Fax: +32-2-650.37.40