Select statement error on logout

I’ve got an error that seems to show up in /var/log/messages when I log out
of RT3 version 3.0.7_1, as shown below. Looks like a select statement got
fouled up somewhere in the code:

Dec 22 22:42:03 testrt RT: DBD::mysql::st execute failed: You have an error
in your SQL syntax. Check the manual that corresponds to your MySQL server
version for the right syntax to use near ‘NULL’ at line 1 at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
opt/rt3/lib/RT.pm:247)

Dec 22 22:42:03 testrt RT: RT::Handle=HASH(0x93b7e34) couldn’t execute the
query ‘SELECT * FROM Users WHERE Name ?’ at
usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.
(/opt/rt3/lib/RT.pm:247)

I’ve grep’ed through the entire /opt/rt3 installation area as well as
/usr/lib and haven’t been able to find the file in which this SQL statement
is located. Even if I found it, I probably wouldn’t be able to identify
what should be after “name” in the statement. Oddly enough it doesn’t seem
to affect the logout or application, at least so far.

Can anyone shed some light on what might be causing the error and how to go
about correcting it? It seems like it might be some bad/old code lying
around.

Thanks in advance.

Regards,

-Jim Ficarra

I’ve got an error that seems to show up in /var/log/messages when I log out
of RT3 version 3.0.7_1, as shown below. Looks like a select statement got
fouled up somewhere in the code:

I’ve seen that error but not traced it to logout. You can reproduce it
by clicking the logout button?

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

I can definitely reproduce it…every time I log out it shows up. Thanks
for any help you can provide.

By the way, Jesse…great product. I’ve been using RT2 for about 1 1/2
years now. I’m excited about upgrading to RT3.

-JimFrom: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Tuesday, December 23, 2003 12:35 AM
To: Jim Ficarra
Cc: rt-users@lists.fsck.com
Subject: Re: [rt-users] Select statement error on logout

I’ve got an error that seems to show up in /var/log/messages when I log
out
of RT3 version 3.0.7_1, as shown below. Looks like a select statement got
fouled up somewhere in the code:

I’ve seen that error but not traced it to logout. You can reproduce it
by clicking the logout button?

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

Jesse,

FYI, I can also reproduce it when I load index.html. It shows up before I
can even log in.

-Jim FicarraFrom: Jim Ficarra
Sent: Tuesday, December 23, 2003 12:45 AM
To: Jesse Vincent
Cc: rt-users@lists.fsck.com
Subject: RE: [rt-users] Select statement error on logout

I can definitely reproduce it…every time I log out it shows up. Thanks
for any help you can provide.

By the way, Jesse…great product. I’ve been using RT2 for about 1 1/2
years now. I’m excited about upgrading to RT3.

-Jim

From: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Tuesday, December 23, 2003 12:35 AM
To: Jim Ficarra
Cc: rt-users@lists.fsck.com
Subject: Re: [rt-users] Select statement error on logout

I’ve got an error that seems to show up in /var/log/messages when I log
out
of RT3 version 3.0.7_1, as shown below. Looks like a select statement got
fouled up somewhere in the code:

I’ve seen that error but not traced it to logout. You can reproduce it
by clicking the logout button?

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