Installing Concrete 5.7.1 with myisam (doesnt have innodb)

Permalink
Hi all, I want to ask how to install concrete 5.7.1 in server that doesnt have innodb support?
my server only have myisam.

For what I know, C5 already use innodb since 5.5. But up to concrete 5.7.0.4, I still can install on my server. except since 5.7.1, I cant. I think because of max key length error.

I try to follow Remo suggestion in
http://www.concrete5.org/community/forums/installation/no-innodb-su...
but no hope.

please someone help me.


this is what I got:
An exception occurred while executing 'CREATE TABLE Config (configNamespace VARCHAR(255) DEFAULT '' NOT NULL, configGroup VARCHAR(255) NOT NULL, configItem VARCHAR(255) NOT NULL, configValue LONGTEXT DEFAULT NULL, INDEX configGroup (configGroup), PRIMARY KEY(configNamespace, configGroup, configItem)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes.
Trace:
#0 /home/sloki/user/k8717229/sites/c571.merconbambu.com/www/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(811): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'CREATE TABLE Co...') #1 [internal function]: Doctrine\DBAL\Connection->query('CREATE TABLE Co...') #2 /home/sloki/user/k8717229/sites/c571.merconbambu.com/www/concrete/src/Database/Connection/Connection.php(77): call_user_func_array('parent::query', Array) #3 /home/sloki/user/k8717229/sites/c571.merconbambu.com/www/concrete/src/Package/Package.php(182): Concrete\Core\Database\Connection\Connection->query('CREATE TABLE Co...') #4 /home/sloki/user/k8717229/sites/c571.merconbambu.com/www/concrete/src/Package/StartingPointPackage.php(190): Concrete\Core\Package\Package::installDB('/home/sloki/use...') #5 [internal function]: Concrete\Core\Package\StartingPointPackage->install_database() #6 /home/sloki/user/k8717229/sites/c571.merconbambu.com/www/concrete/controllers/install.php(272): call_user_func(Array) #7 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'install_databas...') #8 /home/sloki/user/k8717229/sites/c571.merconbambu.com/www/concrete/src/Controller/AbstractController.php(149): call_user_func_array(Array, Array) #9 /home/sloki/user/k8717229/sites/c571.merconbambu.com/www/concrete/src/Routing/ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #10 /home/sloki/user/k8717229/sites/c571.merconbambu.com/www/concrete/src/Routing/Router.php(59): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #11 /home/sloki/user/k8717229/sites/c571.merconbambu.com/www/concrete/src/Support/Facade/Facade.php(116): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #12 /home/sloki/user/k8717229/sites/c571.merconbambu.com/www/concrete/src/Application/Application.php(317): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #13 /home/sloki/user/k8717229/sites/c571.merconbambu.com/www/concrete/src/Application/Application.php(317): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) #14 /home/sloki/user/k8717229/sites/c571.merconbambu.com/www/concrete/bootstrap/start.php(196): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #15 /home/sloki/user/k8717229/sites/c571.merconbambu.com/www/concrete/dispatcher.php(36): require('/home/sloki/use...') #16 /home/sloki/user/k8717229/sites/c571.merconbambu.com/www/index.php(2): require('/home/sloki/use...') #17 {main}

mkharisecario
View Replies: View Best Answer
andrew replied on at Permalink Best Answer Reply
andrew
This is not something that's going to work – and it's going to cause problems for you in the future if you can't enable InnoDB tables.

In 5.6 we didn't mandate InnoDB tables and not too much of what we were using required it – but in 5.7 we can't support both table types.
mkharisecario replied on at Permalink Reply
mkharisecario
oh. is 5.7.0.~ version similar with version 5.6?
because up to 5.7.0.4 version I still can install it...
mkly replied on at Permalink Reply
mkly
My guess of what he is saying and my knowledge of 5.7 says that although you might be able to get it installed, there are problems beyond that.
mkharisecario replied on at Permalink Reply
mkharisecario
oh ok i think i get it!
thanks