I've had rt-3.6.3 running for awhile, while I was on vacation users were complaining that the changes to tickets were not saved. My manager was poking around and found seg fault messages in the Apache logs. I ran mysqlcheck on the databases (we have replication running) and the tables seem fine. I checked /var/log/messages and I see this error message when the seq fault occurs,
Jul 26 13:36:51 dots1a RT: DBD::mysql::st execute failed: Unknown column 'main.0xa00c930' in 'order clause' at /usr/local/perl-5.8.8/lib/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505. (/usr/local/perl-5.8.8/lib/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505) Jul 26 13:36:51 dots1a RT: RT::Handle=HASH(0x9af88ac) couldn't execute the query 'SELECT main.* FROM Tickets main WHERE (main.Status != 'deleted') AND ( ( main.Owner = '10' ) AND ( main.Status = 'new' OR main.Status = 'open' ) ) AND ( 'main.0xa00c930' <= this doesn't look good any ideas? Thanks. -- Scott T. Hildreth <[EMAIL PROTECTED]> _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
