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:
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}
oh. is 5.7.0.~ version similar with version 5.6?
because up to 5.7.0.4 version I still can install it...
because up to 5.7.0.4 version I still can install it...
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.
oh ok i think i get it!
thanks
thanks
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.