On Fri, Nov 7, 2008 at 9:55 AM, John <[EMAIL PROTECTED]> wrote: > what version are you migrating from? im certain UPGRADING.mysql applies... > it says at line 13/14: > > If you're upgrading RT from versions prior to 3.8.0 then you MUST follow > instructions below.
Thanks John, I missed that RT wasn't using the collation when it originally created the database, despite the database version. Updating the database collation and restarting apache appears to have corrected the problem while searching. Since my mysql server was on another host, I copied schema.mysql-4.0-4.1.pl to that host and ran: perl schema.mysql-4.0-4.1.pl rtdb root > sql.rtdb mysql -u root rtdb < sql.rtdb _______________________________________________ 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