G3-Beta3 install problem - table type doesn't support FULLTEXT indexes

is your MySQL server using innodb as storage engine by default?

looks like we'll need to force the MySQL storage engine of the search_records table to MyISAM. other engines don't support fulltext search index.

see:
http://dev.mysql.com/doc/refman/5.1/en/storage-engines.html

i filed a bug to track this:
https://sourceforge.net/apps/trac/gallery/ticket/774

I'm having this problem, too, when installing. I'm installing on the RackSpace Cloud, using Cloud Sites for maximum scalability. Unfortunately though, there aren't many options to change this on their backend. So, in PHPMyAdmin--

Select your server and login. Then select the database, then click on one of the tables on the left. All I know how to do is by doing each one manually, but there aren't too many of them.
So, once you click the table, click the operations tab. Then under "table options" change the "storage engine" from InnoDB to MyISAM. That's what I think he is recommending.

"InnoDB free: 0 kB" is what it says before I change to the MyISAM option. Does that mean anything to anybody? Perhaps it's out of some kind of allocated memory for an InnoDB process, but I don't know much about databases so I can't really claim any expertise.

The command it is running is ALTER TABLE `items` ENGINE = MYISAM
But I can't apply this to the entire database because when I wipe it clean it just reinstalls tables with InnoDB... Any suggestions on how to get MyISAM to be the default without having root access or SSH access on the server?

I tried the experimental version (28.10.2009 release), the links do not work at all and server gives responses like "cannot find file" or "bad gateway".

How it is possible to fix the problem with MyISAM, so that BETA-3 version could be used?

Just downloaded the latest experimental version, setup goes well the first front pages opens ok, but no internal gallery links in the admin section work!

They simply do not work at all e.g. "Add -> Add photos"

or

e.g. "Admin -> Appearance -> Theme choice" I receive the following message "Bad Gateway. Web server received an invalid response while acting as a gateway or proxy server."

What is the most interesting thing - I have installed and running Gallery2 ver.2.3 on the same web server, but on seperate DB and everything works great!

The only thing that I can think of is that the server OS is Windows based, but it should not have an impact on the gallery, because it uses PHP5 and mysql.

Looking forward to any suggestions?

But why the G2 works like a charm on the same server and the same settings?

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 ;^)