[rt-users] Error running rt-validator

2011-12-19 Thread Arnon Clark 

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

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

2011-12-19 Thread Brent Wiese 

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?


Did you run the DB upgrade scripts?

RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston  March 5  6, 2012