[rt-users] can't alter table: attachments

[Tom Vier]

I successfully changed all my rt tables, except attachments to innodb. 
I'm running mysql 4.0.24 and this is what happens:

ALTER TABLE `Attachments` TYPE = innodb

#1214 - The used table type doesn't support FULLTEXT indexes


Also, i get these in my logs (since Attachments is in myisam format);

Jun 17 08:05:42 opteron-prime RT: DBD::mysql::db rollback failed: 
Warning:  Some non-transactional changed tables couldn't be rolled back 
at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 721. 
(/usr/share/request-tracker3.4/lib/RT.pm:277)
Jun 17 08:06:14 opteron-prime RT: DBD::mysql::db rollback failed: 
Warning:  Some non-transactional changed tables couldn't be rolled back 
at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 721. 
(/usr/share/request-tracker3.4/lib/RT.pm:277)
Jun 17 08:17:09 opteron-prime rsyncd[8387]: name lookup failed for 
192.168.255.91: Name or service not known
Jun 17 08:33:06 opteron-prime RT: DBD::mysql::db rollback failed: 
Warning:  Some non-transactional changed tables couldn't be rolled back 
at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 721. 
(/usr/share/request-tracker3.4/lib/RT.pm:277)
Jun 17 08:36:54 opteron-prime RT: DBD::mysql::db rollback failed: 
Warning:  Some non-transactional changed tables couldn't be rolled back 
at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 721. 
(/usr/share/request-tracker3.4/lib/RT.pm:277)
Jun 17 08:37:08 opteron-prime rsyncd[8566]: name lookup failed for 
192.168.255.91: Name or service not known
Jun 17 08:40:29 opteron-prime RT: DBD::mysql::db rollback failed: 
Warning:  Some non-transactional changed tables couldn't be rolled back 
at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 721. 
(/usr/share/request-tracker3.4/lib/RT.pm:277)
Jun 17 08:41:53 opteron-prime RT: DBD::mysql::db rollback failed: 
Warning:  Some non-transactional changed tables couldn't be rolled back 
at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 721. 
(/usr/share/request-tracker3.4/lib/RT.pm:277)
Jun 17 08:41:57 opteron-prime RT: DBD::mysql::db rollback failed: 
Warning:  Some non-transactional changed tables couldn't be rolled back 
at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 721. 
(/usr/share/request-tracker3.4/lib/RT.pm:277)
Jun 17 08:42:20 opteron-prime RT: DBD::mysql::db rollback failed: 
Warning:  Some non-transactional changed tables couldn't be rolled back 
at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 721. 
(/usr/share/request-tracker3.4/lib/RT.pm:277)
Jun 17 08:52:58 opteron-prime RT: DBD::mysql::db rollback failed: 
Warning:  Some non-transactional changed tables couldn't be rolled back 
at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 721. 
(/usr/share/request-tracker3.4/lib/RT.pm:277)


tia!

-- Tom