Project

General

Profile

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

    (1-4/4)