Forums » Appion and Leginon Web tools »
ERROR on Myamiweb by using the setup wizard
Added by ShinBo Chen over 10 years ago
Configuration using the setup wizard
The last step:Start variables setup:Press Next and then show the below:
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 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
Is that php version or mysql error ?
Someone can give me suggestion or solution?
Many Thanks,
~Shinbo
Replies (3)
RE: ERROR on Myamiweb by using the setup wizard - Added by Anchi Cheng over 10 years ago
You probably have a database default to InnoDB, not MyISAM.
See error while trying to create a processing database for diagnosis and solution.
Is this CentOS or other linux distribution ? CentOS should default to MyISAM last we checked.
RE: ERROR on Myamiweb by using the setup wizard - Added by ShinBo Chen over 10 years ago
I run the system on Ubuntu 13.04 Desktop.
And I've checked I add the MyISAM setting into my.cnf
ShinBo Chen wrote:
Configuration using the setup wizard
The last step:Start variables setup:Press Next and then show the below:
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 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 indexesIs that php version or mysql error ?
Someone can give me suggestion or solution?
Many Thanks,
~Shinbo
RE: ERROR on Myamiweb by using the setup wizard - Added by Anchi Cheng over 10 years ago
Try this mysql command after starting its command line interface as shown in step 13 (checking mysql variable) in Database_Server_Installation.
show table status where name = 'SessionData';
I still think that your my.cnf has not taken effect. Is it possible that the mysql server wasn't restarted after your change in my.cnf ?