<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Ruslan,<br>
<br>
I don't know if you saw the end of my previous message in this thread,
so here it is again (rt-validator 3.8.2rc1 output). There are many
CachedGroupMembers problems. Should I attempt to allow rt-validator to
fix them (if it can?) See also the seemingly unrelated SQL error.<br>
<br>
As mentioned previously, my RT database works fine with RT 3.6.X but
produces the weird rights errors with 3.8.X. This database has been in
use since 2003. There have been many RT and PostgreSQL upgrades since
then, but there has never been a database problem, to my knowledge.<br>
<br>
I ran the rt-validator from 3.8.2rc1 on my 3.6.7 database, and this is
what I got:<br>
<br>
<tt><b>Name "RT::DatabaseType" used only once: possible typo at
sbin/rt-validator line 133.<br>
<br>
Record #15423 in CachedGroupMembers references not existent record in <br>
CachedGroupMembers<br>
ImmediateParentId => '6585' => GroupId<br>
MemberId => '6329' => MemberId<br>
Via => '15420' => id</b><br>
</tt><br>
[... and 109 more like the previous ...]<br>
<br>
<b><tt>Principal #22 is member of #6585 when #6585 is member of #6166,<br>
but there is no cached GM record that 22 is member of #6166.</tt><br>
</b><br>
[... and 219 more like the previous ...]<br>
<br>
<tt><b>[Wed Dec 17 15:59:28 2008] [warning]: DBD::Pg::st execute
failed: <br>
ERROR: syntax error at or near "WHERE"<br>
LINE 4: WHERE<br>
^ at sbin/rt-validator line 1060. (sbin/rt-validator:1060)<br>
[Wed Dec 17 15:59:28 2008] [crit]: couldn't execute SELECT m.id, g.id, <br>
g.Instance<br>
FROM<br>
Groups g JOIN Attachments m<br>
WHERE<br>
g.Domain = ?<br>
AND g.Type = ?<br>
AND g.id = m.Creator<br>
<br>
Error: ERROR: syntax error at or near "WHERE"<br>
LINE 4: WHERE<br>
^ at sbin/rt-validator line 1060. <br>
(/usr/local/src/rt-3.8.2rc1/sbin/../lib/RT.pm:377)<br>
couldn't execute SELECT m.id, g.id, g.Instance<br>
FROM<br>
Groups g JOIN Attachments m<br>
WHERE<br>
g.Domain = ?<br>
AND g.Type = ?<br>
AND g.id = m.Creator<br>
<br>
Error: ERROR: syntax error at or near "WHERE"<br>
LINE 4: WHERE<br>
^ at sbin/rt-validator line 1060.</b></tt><br>
<br>
<br>
<br>
</body>
</html>