I'm getting this same error when I tried to upgrade
from 1.5.3 to 1.5.4. I've been using 1.5.3 with
InnoDB. It won't create the full text indexes because
InnoDB does not support full text indexes.
That complicates my upgrade a little bit. I need to
change my existing database from InnoDB to MyISAM
prior to upgrading to 1.5.4.
What is the best way to do this? Would it be best to
run an alter table statement on all tables? or is it
best to create a new database from the 1.5.3 setup
files and then select into from the current table to
the new table?
My MySQL skills are mediocre at best. I'm looking for
an easy way to do this without too much pain.
I'm an Eventum WIMP. Windows 2000, IIS5, MYSQL
4.1.11.
Travis
--- Joao Prado Maia <jpm@stripped> wrote:
> Brian,
>
> > I'm trying to install release 1.5.4 from scratch.
> When select
> > "Create Database" and begin the install, the
> process is
> > interrupted with the following error:
> >
> > An Error Was Found
> >
> > Details: The used table type doesn't support
> FULLTEXT indexes
> >
>
> Hmm, interesting. I guess your default table type in
> MySQL is set to
> InnoDB, right? Those tables really need to be set to
> MyISAM. We'll fix
> that for the next release.
>
> In the meantime, you can open
> /path-to-eventum/setup/schema.sql and
> change all of the CREATE TABLE statements to have "
> TYPE=MyISAM;", like
> so:
>
> CREATE TABLE %TABLE_PREFIX%issue_association (
> isa_issue_id int(10) unsigned NOT NULL default 0,
> isa_associated_id int(10) unsigned NOT NULL
> default 0,
> KEY isa_issue_id (isa_issue_id,isa_associated_id)
> );
>
> To:
>
> CREATE TABLE %TABLE_PREFIX%issue_association (
> isa_issue_id int(10) unsigned NOT NULL default 0,
> isa_associated_id int(10) unsigned NOT NULL
> default 0,
> KEY isa_issue_id (isa_issue_id,isa_associated_id)
> ) TYPE=MyISAM;
>
> Let me know if that works.
>
> --Joao
>
>
> --
> Eventum Users Mailing List
> For list archives:
> http://lists.mysql.com/eventum-users
> To unsubscribe:
>
http://lists.mysql.com/eventum-users?unsub=1
>
>
__________________________________
Discover Yahoo!
Have fun online with music videos, cool games, IM and more. Check it out!
http://discover.yahoo.com/online.html
