Recent Topics
  1. b2evolution CMS Support Forums
  2. b2evolution Development
  3. Bug reports
  4. Not a bug
  5. [not a bug] 3.3.0-rc1 Upgrade Error

[not a bug] 3.3.0-rc1 Upgrade Error

1 Jul 18, 2009 15:21    

My b2evolution Version: Not Entered

Never a good sign when things stop in the middle and you can't restart the install/upgrade.

Loading: _core/model/__core.install.php
Loading: sessions/model/_sessions.install.php

Checking DB schema version... 9950 : OK.
Renaming tables...OK.
Making sure all tables use desired storage ENGINE...T_groups:innodb
T_settings:innodb
T_global__cache:innodb
T_users:innodb
An unexpected error has occurred!

MySQL error!

The used table type doesn't support FULLTEXT indexes(Errno=1214)

Your query:
ALTER TABLE evo_users ENGINE = innodb

Any suggestions?

Back to top

2 Jul 18, 2009 18:29

Thanks to whomever was on @b2evolution, the solution was to use PhpMyAdmin to delete

FULLTEXT KEY `user_pass` (`user_pass`)

in the Indexes structure of 'evo_users' table. The database upgraded fine from there and blog seems to be operating normally.

I'm do not know if this problem was a holdover from a previous b2 upgrade. I'm not smart enough nor brave enough with MySQL to add something like that to a particular table willy nilly.

Back to top

3 Jul 18, 2009 18:56

We should do

ALTER TABLE evo_users DROP INDEX user_pass


before

ALTER TABLE evo_users ENGINE = innodb

I didn't find this index in 1.10, are you upgrading from 0.9.x ?

Back to top

4 Jul 18, 2009 19:13

Not directly, no, but my first b2 install for this database was a 9.0.12. It's been upgraded a few times over the past three years.

Could it have been a holdover from way back then?

Back to top

5 Jul 18, 2009 19:31

Could it have been a holdover from way back then?

Probably.

Back to top


Form is loading...