[rt-users] howto stay logged in and force owner change?

[Stephan Uhlmann]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tuesday 10 February 2004 18:26, Michael S. Liebman wrote:
> Steal the ticket first and then reassign it. Of course, that means the
> manager must have StealTicket rights to the queue.
[...]
> No, not the Jumbo view of a ticket. If you do a search, there will be
> a link between the list of found tickets and the refine search box
> "Update all these tickets at once." That's the bulk update
> facility. When you click on that link, you will be able to change a
> variety of things related to all the tickets you select en masse.

Ah. Ok. There are many ways to Rome. I missed both ;-) Thank you!

My problem with the users not being able to stay logged in I fixed by adding a 
line to share/html/Elements/SetupSessionCookie. Here's the diff:

- --- SetupSessionCookie.old      2004-01-02 22:23:39.000000000 +0100
+++ SetupSessionCookie  2004-02-10 18:51:49.000000000 +0100
@@ -71,6 +71,7 @@
     if ( !$cookies{$cookiename} ) {
         my $cookie = new CGI::Cookie(
             -name  => $cookiename,
+            -expires => '+10y',
             -value => $session{_session_id},
             -path  => '/',
         );

For me it's ok, to hardcode that directly in the file (just have to remember 
that when doing upgrades), but maybe developers could make that an 
configurable option in future RT releases? I guess it would be useful for 
other people, too.


Then I have a new problem. When I want to add a watcher to a queue I get the 
error message "Group not found". Sometimes. On most queues it works. But on 
some queues not. When it's not working it does not matter if I want to add a 
user or a group. It also does not matter if I want to add the watcher as Cc 
or AdminCc. Always the same error message.
All queues were created with RT version 3.0.6. A recent upgrade to version 
3.0.8 didn't help. I run MySQL version 3.23.55. I had SearchBuilder module 
version 0.92 and upgraded now to version 0.96. Still no luck.

I get the following error messages when hitting the "Go!" to find my group:

Feb 10 19:59:13 caesar RT: DBD::mysql::st execute failed: You have an error in 
your SQL syntax near '))  ' at line 1 
at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm line 234.  
(/opt/rt-3-0-8/lib/RT.pm:247)
Feb 10 19:59:13 caesar RT: DBIx::SearchBuilder error:You have an error in your 
SQL syntax near '))  ' at line 1         Query String is SELECT 
count(main.id) FROM GroupMembers main  WHERE ((main.GroupId = ))    
(/opt/rt-3-0-8/lib/RT.pm:247)
Feb 10 19:59:13 caesar RT: DBD::mysql::st fetchrow_array failed: fetch() 
without execute() at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm 
line 248.  (/opt/rt-3-0-8/lib/RT.pm:247)
Feb 10 19:59:13 caesar RT: DBD::mysql::st execute failed: You have an error in 
your SQL syntax near '))  ' at line 1 
at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm line 234.  
(/opt/rt-3-0-8/lib/RT.pm:247)
Feb 10 19:59:13 caesar RT: DBIx::SearchBuilder error:You have an error in your 
SQL syntax near '))  ' at line 1         Query String is SELECT 
count(main.id) FROM GroupMembers main  WHERE ((main.GroupId = ))    
(/opt/rt-3-0-8/lib/RT.pm:247)
Feb 10 19:59:13 caesar RT: DBD::mysql::st fetchrow_array failed: fetch() 
without execute() at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm 
line 248.  (/opt/rt-3-0-8/lib/RT.pm:247)

I get these errors when I click on "Save Changes" after selecting my group to 
add as AdminCc watcher:

Feb 10 19:59:47 caesar RT: Adding a watcher 128 to AdminCc
Feb 10 19:59:47 caesar RT: DBD::mysql::st execute failed: You have an error in 
your SQL syntax near '))  ' at line 1 
at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm line 234.  
(/opt/rt-3-0-8/lib/RT.pm:247)
Feb 10 19:59:47 caesar RT: DBIx::SearchBuilder error:You have an error in your 
SQL syntax near '))  ' at line 1         Query String is SELECT 
count(main.id) FROM GroupMembers main  WHERE ((main.GroupId = ))    
(/opt/rt-3-0-8/lib/RT.pm:247)
Feb 10 19:59:47 caesar RT: DBD::mysql::st fetchrow_array failed: fetch() 
without execute() at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm 
line 248.  (/opt/rt-3-0-8/lib/RT.pm:247)
Feb 10 19:59:47 caesar RT: DBD::mysql::st execute failed: You have an error in 
your SQL syntax near '))  ' at line 1 
at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm line 234.  
(/opt/rt-3-0-8/lib/RT.pm:247)
Feb 10 19:59:47 caesar RT: DBIx::SearchBuilder error:You have an error in your 
SQL syntax near '))  ' at line 1         Query String is SELECT 
count(main.id) FROM GroupMembers main  WHERE ((main.GroupId = ))    
(/opt/rt-3-0-8/lib/RT.pm:247)
Feb 10 19:59:47 caesar RT: DBD::mysql::st fetchrow_array failed: fetch() 
without execute() at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm 
line 248.  (/opt/rt-3-0-8/lib/RT.pm:247)

RT somehow seems to forget the GoupId of the group I want to add. I looked 
into the HTML source of the page where I can select my group and in the form 
it says:
<SELECT NAME ="Queue-AddWatcher-Principal-128">
which seems correct to me (128 is the Id of my group). Maybe that information 
helps you helping me locating the bug.

I saw in the rt-users archive that other people have/had this problem, too, 
but I didn't see any answer emails with a solution. I hope somebody can help 
me now.


Cheers,
Stephan
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQFAKSvM0TAeRPnvmyERAgoNAJ9KO5s5pRTperXGxfrJdhFKvwGfjACfTEG7
lgmybe8kxJ2gBHk9vp33kZY=
=pxI6
-----END PGP SIGNATURE-----