> 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 [email protected] 831-459-5354 _______________________________________________ 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
