checksetup error migrating bugzilla mysql "The used table type doesn't support FULLTEXT indexes"

[Mauro]

Hi all,
I'm migrating bugzilla from version 3.0.2 to 3.2.3.
I have 2 bugzilla instances running in the same server named "A" and
"B".
Now I created 2 new mysql db called "test.A" and "test.B" to check
the migration.
I successful migrated A to test.A (A is a very small DB because it is
a bugzilla instance not used a lot) but when I was doing the same on B
I got this error while I was running checksetup.pl

Bugzilla now uses the InnoDB storage engine in MySQL for most tables.
Converting tables to InnoDB:
Converting table longdescs2... DBD::mysql::db do failed: The used
table type doesn't support FULLTEXT indexes [for Statement "ALTER
TABLE longdescs2 TYPE = InnoDB"] at Bugzilla/DB/Mysql.pm line 337
Bugzilla::DB::Mysql::bz_setup_database
('Bugzilla::DB::Mysql=HASH(0xa16701c)') called at ./checksetup.pl line
144

I read some similar question on the group but I didn't manage to
understand how to solve the problem.
Of course "PROJECT" variable is correctly set up.

Could you help me?

Thank You

Regards

Mauro

[Max Kanat-Alexander]

Mauro wrote:
> Converting table longdescs2...

There is no such table in standard Bugzilla. You should drop your
longdescs2 table before performing the upgrade. If it is a customization
and contains data that you need, then you will have to decide what to do
about it (I'd assume that if you have such a customization then you have
a thorough-enough understanding of Bugzilla to decide what to do about
the table.)

-Max
--
http://www.everythingsolved.com/
Competent, Friendly Bugzilla and Perl Services. Everything Else, too.

[Mauro]

On Apr 20, 4:24 pm, Max Kanat-Alexander <mka...@bugzilla.org> wrote:
> Mauro wrote:
> > Converting table longdescs2...
>
>         There is no such table in standard Bugzilla. You should drop your

I really don't know who created the table, there has been a lot of
joiners and leavers people here.
I don't think it is possible to remove the table (too may details
added):

mysql> desc longdescs2
-> ;
+-----------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+-------+
| bug_id | mediumint(9) | NO | MUL | | |
| who | mediumint(9) | NO | MUL | | |
| bug_when | datetime | NO | MUL | | |
| work_time | decimal(5,2) | NO | | 0.00 | |
| thetext | mediumtext | YES | MUL | NULL | |
| isprivate | tinyint(4) | NO | | 0 | |
| already_wrapped | tinyint(4) | NO | | 0 | |
+-----------------+--------------+------+-----+---------+-------+

How can I bring it to the new release (eventually manually)?
Export, drop, checksetup again and then import? How to import?
Sorry not so good with mysql :-(

Thank You again

Mauro

[Mauro]

Sorry you are right!
I remind that some time ago we had a problem with some accented words
and to correct the problem we created longdescs2...

[James Kosin]

This looks like a QA worksheet for time spent on the BUG. You would
best ask them, if still present in the BUGZILLA pages for the web.
If not used, you should be able to safely remove the table and continue;
since it seems to only have a tie to the bug_id that is being worked on.
But, I wouldn't do anything more before ASKING!

James