Database didn't upgrade

[tstagl]

I just tried to upgrade from 3.1.0 to 3.2.0. During the database upgrade section, I saw all the tables being touched, but I got the following error:

for table: Table_Definition...FAILED

Error #1283: Column 'Table_Name' cannot be part of FULL TEXT index.

I'm clueless. Anyone out there seen anythng like this?

After restoring from a DB backup, the site seems to work. The only exception I get is that when I enter the Control Panel, I get a Database Mismatch! notice telling me that the database version (3.1.0) does not match the version number of the files (3.2.0).

[Jamie]

I just tried to upgrade from 3.1.0 to 3.2.0. During the database upgrade section, I saw all the tables being touched, but I got the following error:

for table: Table_Definition...FAILED

Error #1283: Column 'Table_Name' cannot be part of FULL TEXT index.

I'm clueless. Anyone out there seen anythng like this?

You have a full text index created for the column Table_Name in the table Table_Definition. That is not normally present and should not be. If you delete that index in phpMyAdmin the upgrade will probably complete.

1. Open phpMyAdmin
2. Select your database on the left side
3. Click the link for table Table_Definition
4. Click the Structure tab at the top of the table
5. Scroll to the bottom on the right side. You should see the index listed under Indexes. Click the red X to remove it.
6. Confirm

After restoring from a DB backup, the site seems to work. The only exception I get is that when I enter the Control Panel, I get a Database Mismatch! notice telling me that the database version (3.1.0) does not match the version number of the files (3.2.0).

If an upgrade fails and you revert the database to the prior version, you also need to revert your files to that same version. If you don't, you'll see exactly what you are seeing now.

[tstagl]

Wow, thanks for the quick reply. I did as you suggested and things improved, but the upgrade didn't finish. At the "changing all table columns to utf8" step, it failed again.

I received the following error:

Error #1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARACTER SET utf8 COLLATE utf8_unicode_ci' at line 1

The mySQL version I'm using is 5.0.77.

Any ideas would be helpful. Thanks.

[Jamie]

I don't know what's causing that. I'd need to attempt the upgrade myself to determine that.

[tstagl]

Jamie, thanks for giving it a try in this forum. I'll be opening a support ticket shortly.