Installation Issue with the DB

SeanLAllen

I am attempting to install Vanilla, and I received the following error messages, after setting up a database, and putting in the correct credentials:
Unknown storage engine 'MyISAM'

I checked and the default storage engine is InnoDB.

peregrine

good question -

but it thinks you don't

perhaps the error is coming as response from your sql server most likely vanilla is just
passing on the response

what type of sql server?
what type of os?

you could try manually creating a test database with myisam table. add some values and - write a script to read it.

have no idea what you did, what your process, and what step along the way you are.

do you have a vanilla database created? are there any tables.? if so, what.

what version of 2.2 the one master from github, or the one from core downloads in the add-ons section.

localhost? yours?

did you make changes to your sql server? any configuration changes?

did you restart sql server.

we are hunting in the dark without more details.

peregrine

the discussion and comment table is myisam for full text search. otherwise I don't believe the current search mechanism would work. maybe sphinxsearch.

do show engines.

you would want MyIsam support.

maybe you can add with plugin.

or you might somehow add to your config to force the engine.

$Configuration['Database']['ForceStorageEngine'] = true;

or change the FullText variable in the core.

vrijvlinder

Maybe this can help

https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html

http://support.severalnines.com/entries/24434706-Migrate-MyISAM-tables-to-INNODB-using-mysqldump

SeanLAllen

So, if Vanilla needs MyISAM support, then why is it throwing an error saying that it is an unknown engine.
I have MyISAM support on in the DB

peregrine

good question -

but it thinks you don't

perhaps the error is coming as response from your sql server most likely vanilla is just
passing on the response

what type of sql server?
what type of os?

you could try manually creating a test database with myisam table. add some values and - write a script to read it.

have no idea what you did, what your process, and what step along the way you are.

do you have a vanilla database created? are there any tables.? if so, what.

what version of 2.2 the one master from github, or the one from core downloads in the add-ons section.

localhost? yours?

did you make changes to your sql server? any configuration changes?

did you restart sql server.

we are hunting in the dark without more details.

SeanLAllen

Vanilla was just passing on the response, I'm not sure why but when I went to create a table with MyISAM as the engine, it gave me the same error.