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: fam...@gmail.com
-------- RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA September 26 & 27, 2011 * San Francisco, CA, USA October 18 & 19, 2011 * Washington DC, USA October 31 & November 1, 2011 * Melbourne VIC, Australia November 28 & 29, 2011 * Barcelona, Spain November 28 & 29, 2011