[rt-users] Solved : Re: Error running rt-validator

[Arnon Clark]

Curse my over-exuberance.

I forgot step 6b in the readme. Obviously Validator is going to fail if 
the DB schema is off, and other assorted dumbs.

Many thanks to Kevin's swift and accurate catch of it on the chat-room!

RTFM. Always RTFM.

Thanks!

A

On 11-12-19 10:39 AM, Arnon Clark wrote:
> Hey folks,
>
> I'm trying to run validator and am running into the following error :
>
> Executing query: SELECT m.id, g.id, g.Instance
> FROM
>     Groups g JOIN ACL m ON g.id = m.LastUpdatedBy
> WHERE
>     g.Domain = ?
>     AND g.Type = ?
>
>
> [Mon Dec 19 15:38:54 2011] [warning]: DBD::mysql::st execute failed: 
> Unknown column 'm.LastUpdatedBy' in 'on clause' at ./sbin/rt-validator 
> line 1078. (./sbin/rt-validator:1078)
> [Mon Dec 19 15:38:54 2011] [crit]: DBD::mysql::st execute failed: 
> Unknown column 'm.LastUpdatedBy' in 'on clause' at ./sbin/rt-validator 
> line 1078. (/home/arnon/rt-4.0.4/sbin/../lib/RT.pm:341)
> DBD::mysql::st execute failed: Unknown column 'm.LastUpdatedBy' in 'on 
> clause' at ./sbin/rt-validator line 1078.
>
> Circumstances :
>
> I've got a clean install of 4.0.4, bringing in a DB from 3.8.7
>
>
> I import the mysql dump I made, run the vulnerable passwords, 
> shrink-transactions and shrink cgm scripts, but when I check with 
> validator, I get that error. Any suggestions?
>
> Regards, and thanks
>
> Arnon
>
>
> --------
> RT Training Sessions (http://bestpractical.com/services/training.html)
> * Boston  March 5 & 6, 2012