Hi Ruslan,
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.
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.
I ran the rt-validator from 3.8.2rc1 on my 3.6.7 database, and this is
what I got:
*Name "RT::DatabaseType" used only once: possible typo at
sbin/rt-validator line 133.
Record #15423 in CachedGroupMembers references not existent record in
CachedGroupMembers
ImmediateParentId => '6585' => GroupId
MemberId => '6329' => MemberId
Via => '15420' => id*
[... and 109 more like the previous ...]
*Principal #22 is member of #6585 when #6585 is member of #6166,
but there is no cached GM record that 22 is member of #6166.
*
[... and 219 more like the previous ...]
*[Wed Dec 17 15:59:28 2008] [warning]: DBD::Pg::st execute failed:
ERROR: syntax error at or near "WHERE"
LINE 4: WHERE
^ at sbin/rt-validator line 1060. (sbin/rt-validator:1060)
[Wed Dec 17 15:59:28 2008] [crit]: couldn't execute SELECT m.id, g.id,
g.Instance
FROM
Groups g JOIN Attachments m
WHERE
g.Domain = ?
AND g.Type = ?
AND g.id = m.Creator
Error: ERROR: syntax error at or near "WHERE"
LINE 4: WHERE
^ at sbin/rt-validator line 1060.
(/usr/local/src/rt-3.8.2rc1/sbin/../lib/RT.pm:377)
couldn't execute SELECT m.id, g.id, g.Instance
FROM
Groups g JOIN Attachments m
WHERE
g.Domain = ?
AND g.Type = ?
AND g.id = m.Creator
Error: ERROR: syntax error at or near "WHERE"
LINE 4: WHERE
^ at sbin/rt-validator line 1060.*
_______________________________________________
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
