The used table type doesn't support FULLTEXT indexes

cnakamoto
cnakamoto's picture

Joined: 2009-11-12
Posts: 10
Posted: Thu, 2009-11-12 20:13

I get the following error when I run the installer for the first time:

Quote:
Oops!

Something unexpected happened and we can't finish your install. We'll try to provide some details about the specific problem below.

Failed to create tables in your database:The used table type doesn't support FULLTEXT indexes

I am using a MySQL database on Amazon RDS, but I don't see why this should matter.

I will try using a local database and report back.

Craig
 
cnakamoto
cnakamoto's picture

Joined: 2009-11-12
Posts: 10
Posted: Thu, 2009-11-12 20:31

I tried again using a local MySQL database and it worked just fine. Not sure why AWS should give this error. It is just MySQL 5.1...
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16503
Posted: Fri, 2009-11-13 03:22

What version of MySQL is on Amazon RDS?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
 
Gork

Joined: 2008-09-09
Posts: 31
Posted: Mon, 2009-11-16 02:22

MyIsam tables in MySQL support FULLTEXT while InnoDB tables do not. I believe the installation default for new tables in MySQL is InnoDB.

I ran across this same error and changed MySQL to create MyIsam tables by default and had no further problems. Maybe this is related to the problem you're having too?
 
cnakamoto
cnakamoto's picture

Joined: 2009-11-12
Posts: 10
Posted: Mon, 2009-11-16 16:21

nivekiam, it is v5.1 as per my previous comment

gork, I never thought that the table creation scripts wouldn't specify a table type, but if they don't, and the default table type in Amazon RDS is not MyIsam then that is probably exactly what the problem is. Unless I repost, that is the answer, I will go and confirm right now. Thanks for your help!
 
horustwohawks

Joined: 2009-12-13
Posts: 6
Posted: Sun, 2009-12-13 18:56

I am posting this in the threads I find with this problem.. I had this today as well...

After downloading Gallery 3 Beta 3 FROM THE MAIN PAGE I get the error:
"The used table type doesn't support FULLTEXT indexes"

This is because as of mySQL version 5 the default table type is INNO, not MyISAM -->> confirmed.

Someone had posted this link for updating as a fix...
http://github.com/gallery/gallery3/commit/9d76797b17d65540a903ef37eee6edca3e83108b
HOWEVER,
It appears the commits listed in that link are not included in gal3 Beta 3, which is weird because the date is correct.
??? why ???

GET THE RIGHT ONE HERE -->>
I had to go to the github tree and download the latest release (beta 3 in swing).
Here's the link..
http://github.com/gallery/gallery3/tree/

This not only has all the sept changes, but its current thru today, and it installs just fine ;^)

Cheers ;^)
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16503
Posted: Mon, 2009-12-14 14:31

please don't post the same post in multiple theads:

Beta3 was a milestone release and was released on 9/12. The fixes you linked to were done on 9/16. So there's no way they could have ever made it into B3. What probably happened is that once B3 was released, more people tried it, someone found the bug, reported it, and it was fixed a few days later.

http://codex.gallery2.org/Gallery3:Upgrading

____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here