[rt-users] Error, couldn't load 0 from the users database

[Francisco Amaro]

Hello all,

We are having a problem with our RT install, after a few years of almost
flawless service, today we noticed that emails weren't being sent.
We are using version 3.4.5, on Linux (FC4, MySQL 4.1).

The web interface works just fine, we can login, create/modify/close
tickets,
etc, but no emails are sent.

There is no apparent problem with the machine or the MySQL database,
and this is what appears on the RT log:

[Wed Aug 24 12:23:50 2011] [err]: Couldn't load 0 from the users database.
 (/opt/rt3/lib/RT/CurrentUser.pm:146)
[Wed Aug 24 12:23:50 2011] [warning]: Use of uninitialized value in
concatenation (.) or string at /opt/rt3/lib/RT/Principal_Overlay.pm line
425. (/opt/rt3/lib/RT.pm:287)
[Wed Aug 24 12:23:50 2011] [warning]: 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 'AND ((ACL.ObjectType
= 'RT::Queue' AND ACL.ObjectId = 1) OR (ACL.ObjectType = 'R' at line 1 at
/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 505.
(/opt/rt3/lib/RT.pm:287)
[Wed Aug 24 12:23:50 2011] [warning]: RT::Handle=HASH(0x80c27d90) couldn't
execute the query 'SELECT ACL.id from ACL, Groups, Principals,
CachedGroupMembers ...

And them a few lines of failed SQL syntax erros and failed querys.

We browsed the users table, user ID 0 is there, no problem. A MySQL
check_table
didn't returned any errors. The only thing we saw that seemed strange was
that there
is reference to a user 1 on the LastUpdatedBy field, but there is no user 1
id.

Any thoughts on this ?




-- 
Francisco Amaro
Email: famaro at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110824/95dc1bfb/attachment.htm>