Project

General

Profile

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 indexes

Is 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 ?

    (1-3/3)