Following the documentation UPGRADING.mysql
Step 5 works (changing to my database bname, user and password)
5. Apply the RT 3.8 schema upgrades. Included in RT is the script etc/upgrade/upgrade-mysql-schema.pl that will generate the appropriate SQL queries:
perl etc/upgrade/upgrade-mysql-schema.pl db user pass > queries.sql
Step 7 fails:
7. Apply the queries. Note that this step can take a while; it may also require additional space on your hard drive comparable with size of your tables.
mysql -u root -p rt3 < queries.sql
[root@rt ~/rt-5.0.1] # mysql -u root -p rt5 < queries.sql
Enter password:
ERROR 1283 (HY000) at line 11: Column ‘Content’ cannot be part of FULLTEXT index
When I go step by step the the queries.sql, I find a single SQL command that fails:
mysql> ALTER TABLE Attachments MODIFY Content LONGBLOB NULL DEFAULT NULL;
ERROR 1283 (HY000): Column ‘Content’ cannot be part of FULLTEXT index
Is it safe to continue without this one modification? Or is there a way to resolve it safely?