Error running rt-validator

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

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?

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!

AOn 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