[rt-users] Ticket Data Seems Broken

[Tim Gustafson]

> If you are on RT 3.8.3 and newer then you can use
> rt-validator to check consistency of the DB.

This mostly worked.  It ran and fixed enough stuff to make this particular ticket display properly, but then reported:

DBD::mysql::st execute failed: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay at /usr/local/sbin/rt-validator line 1058, <STDIN> line 6.

So, I have to fiddle some mySQL paramateres, apparently, and then try again.  But at least this record is fixed now.  Thanks!

Tim Gustafson
Baskin School of Engineering
UC Santa Cruz
tjg at soe.ucsc.edu
831-459-5354