Forums » Software Installation »
Error during Database tables creation
Added by Rogelio Hernandez-Lopez about 11 years ago
Hi there,
I am trying to install myami-trunk to be able to use K2 images but I am stuck at the step of database initialization
I think I got all the necessary packages and created the databases correctly. I am using the wizard and the system is able to connect to the databases
I got the following message before starting the database initialization
leginondb is ready to import!
projectdb is ready to import!
however when trying to create the tables I got the following error,
Error: CREATE TABLE IF NOT EXISTS SessionData ( `DEF_id` int(16) NOT NULL auto_increment, `DEF_timestamp` timestamp NOT NULL , `name` text null , `REF|UserData|user` int(20) null , `image path` text null , `comment` text null , `hidden` tinyint NOT NULL , `REF|InstrumentData|instrument` int(20) null , `REF|GridHolderData|holder` int(20) null , PRIMARY KEY (`DEF_id`), KEY `DEF_timestamp` (`DEF_timestamp`), KEY `REF|UserData|user` (`REF|UserData|user`), KEY `REF|GridHolderData|holder` (`REF|GridHolderData|holder`), FULLTEXT KEY `name` (`name`) ) ;The used table type doesn't support FULLTEXT indexes
am I missing something? any advice?
I used the troubleshoot page to diagnostic my problem and everything looks fine except that the webserver is unable to find the current Appion version and revision
Unable to find the current Appion version and revision numbers in the "projectdb" database.
thanks for your help,
ROGELIO
Replies (4)
RE: Error during Database tables creation - Added by Anchi Cheng about 11 years ago
Please give OS flavor and version and mysql version numbers.
RE: Error during Database tables creation - Added by Rogelio Hernandez-Lopez about 11 years ago
I am using scientific Linux Release 6.4
MySQL 5.5.34-log by Remi
PHP version: 5.3.3 (cli)
thanks!
RE: Error during Database tables creation - Added by Amber Herold about 11 years ago
Hi Rogelio,
The default storage engine for your version of MySQL is InnoDB. You will need to set the default to MyISAM.
See https://emg.nysbc.org/issues/1564 and http://stackoverflow.com/questions/963534/mysql-fulltext-indexes-issue for more info.
amber
RE: Error during Database tables creation - Added by Rogelio Hernandez-Lopez about 11 years ago
Thanks! that solved the problem of tables creation