Forums

Error When Installing 5.7.1

Permalink
Hi all,
I have problem with 5.7.1 installation.
At first I try to upgrade with replacing concrete folder method. Its ok when I upgrade to 5.7.0.3 before.

But when I try to upgrade to 5.7.1 there's error that mention about block...something (sorry I dont remember).
Then I try to clean install. Unfortunately then show this error.

this happen when installation just starting in database. Also this never happen when I try to install previous version of concrete 5.7.
what the difference between concrete 5.7.0.3 and 5.7.1 database?

I already try Remo solution to change the engine code (/concrete/config/db.xml) from innodb but no luck.

please anyone can help me? :)

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/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/merconbambu.com/www/concrete/src/Database/Connection/Connection.php(77): call_user_func_array('parent::query', Array) #3 /home/sloki/user/k8717229/sites/merconbambu.com/www/concrete/src/Package/Package.php(182): Concrete\Core\Database\Connection\Connection->query('CREATE TABLE Co...') #4 /home/sloki/user/k8717229/sites/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/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/merconbambu.com/www/concrete/src/Controller/AbstractController.php(149): call_user_func_array(Array, Array) #9 /home/sloki/user/k8717229/sites/merconbambu.com/www/concrete/src/Routing/ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #10 /home/sloki/user/k8717229/sites/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/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/merconbambu.com/www/concrete/src/Application/Application.php(317): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #13 /home/sloki/user/k8717229/sites/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/merconbambu.com/www/concrete/bootstrap/start.php(196): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #15 /home/sloki/user/k8717229/sites/merconbambu.com/www/concrete/dispatcher.php(36): require('/home/sloki/use...') #16 /home/sloki/user/k8717229/sites/merconbambu.com/www/index.php(2): require('/home/sloki/use...') #17 {main}
mkharisecario
 
shaolinsteyr1 replied on at Permalink Reply
same here with 5.7.1, php 5.5, MyISAM. I tried to install concrete5 in a subdirectory on my hosted webspace with e new created mysql db.
Deaktivating eaccelerator in .htaccess leads to internal server error.
is "lower_case_table_names=0" the problem as mentioned in a post?

here is my error-output:
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/.sites/29/site1794/web/WebsiteNeu/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/.sites/29/site1794/web/WebsiteNeu/concrete/src/Database/Connection/Connection.php(77): call_user_func_array('parent::query', Array) #3 /home/.sites/29/site1794/web/WebsiteNeu/concrete/src/Package/Package.php(182): Concrete\Core\Database\Connection\Connection->query('CREATE TABLE Co...') #4 /home/.sites/29/site1794/web/WebsiteNeu/concrete/src/Package/StartingPointPackage.php(190): Concrete\Core\Package\Package::installDB('/home/.sites/29...') #5 [internal function]: Concrete\Core\Package\StartingPointPackage->install_database() #6 /home/.sites/29/site1794/web/WebsiteNeu/concrete/controllers/install.php(272): call_user_func(Array) #7 [internal function]: Concrete\Controller\Install->run_routine('elemental_blank', 'install_databas...') #8 /home/.sites/29/site1794/web/WebsiteNeu/concrete/src/Controller/AbstractController.php(149): call_user_func_array(Array, Array) #9 /home/.sites/29/site1794/web/WebsiteNeu/concrete/src/Routing/ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #10 /home/.sites/29/site1794/web/WebsiteNeu/concrete/src/Routing/Router.php(59): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #11 /home/.sites/29/site1794/web/WebsiteNeu/concrete/src/Support/Facade/Facade.php(116): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #12 /home/.sites/29/site1794/web/WebsiteNeu/concrete/src/Application/Application.php(317): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #13 /home/.sites/29/site1794/web/WebsiteNeu/concrete/src/Application/Application.php(317): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) #14 /home/.sites/29/site1794/web/WebsiteNeu/concrete/bootstrap/start.php(196): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #15 /home/.sites/29/site1794/web/WebsiteNeu/concrete/dispatcher.php(36): require('/home/.sites/29...') #16 /home/.sites/29/site1794/web/WebsiteNeu/index.php(2): require('/home/.sites/29...') #17 {main}



thanks to all
shaolinsteyr1 replied on at Permalink Reply
I created now mysqldb with innodb format and it's working.
Lupo777 replied on at Permalink Reply
Lupo777
I am new to concrete5 and tried to install the new version 5.7.1. , but I am getting this error message: 
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/.sites/114/site1912/web/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/.sites/114/site1912/web/concrete/src/Database/Connection/Connection.php(77): call_user_func_array('parent::query', Array) #3 /home/.sites/114/site1912/web/concrete/src/Package/Package.php(182): Concrete\Core\Database\Connection\Connection->query('CREATE TABLE Co...') #4 /home/.sites/114/site1912/web/concrete/src/Package/StartingPointPackage.php(190): Concrete\Core\Package\Package::installDB('/home/.sites/11...') #5 [internal function]: Concrete\Core\Package\StartingPointPackage->install_database() #6 /home/.sites/114/site1912/web/concrete/controllers/install.php(272): call_user_func(Array) #7 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'install_databas...') #8 /home/.sites/114/site1912/web/concrete/src/Controller/AbstractController.php(149): call_user_func_array(Array, Array) #9 /home/.sites/114/site1912/web/concrete/src/Routing/ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #10 /home/.sites/114/site1912/web/concrete/src/Routing/Router.php(59): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #11 /home/.sites/114/site1912/web/concrete/src/Support/Facade/Facade.php(116): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #12 /home/.sites/114/site1912/web/concrete/src/Application/Application.php(317): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #13 /home/.sites/114/site1912/web/concrete/src/Application/Application.php(317): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) #14 /home/.sites/114/site1912/web/concrete/bootstrap/start.php(196): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #15 /home/.sites/114/site1912/web/concrete/dispatcher.php(36): require('/home/.sites/11...') #16 /home/.sites/114/site1912/web/index.php(2): require('/home/.sites/11...') #17 {main}


Can anybody help me please!
shaolinsteyr1 replied on at Permalink Reply
Hello,

you have to use a mysql db with innodb support, otherwise look at this thread:http://www.concrete5.org/community/forums/installation/no-innodb-su...
Lupo777 replied on at Permalink Reply
Lupo777
Thanks a lot for your fast response!!! I had to activate innodb at my webhost... Now everything works perfect!!! I am so happy! Thanks!!!
mkharisecario replied on at Permalink Reply
mkharisecario
I do this but not working :(