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

[Kevin Falcone]

On Wed, Aug 24, 2011 at 02:32:10PM +0100, Francisco Amaro wrote:
>    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.

I'm not aware of an RT version that had a User ID 0.
Sounds like someone renumbered your RT_System user manually in the
database, or that you have database corruption.

You can try taking a backup and fixing this manually, but if it is
corruption, there may be other problems.

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110824/135c2218/attachment.sig>