trying to install 5.7.5.13 and got this error. any help?
Permalink
Unable to install database: 42000.
Trace:
#0 [internal function]: Concrete\Core\Package\StartingPointPackage->install_database() #1 /home/vol7_4/xtreemhost.com/xth_20207154/htdocs/concrete/controllers/install.php(294): call_user_func(Array) #2 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'install_databas...') #3 /home/vol7_4/xtreemhost.com/xth_20207154/htdocs/concrete/src/Controller/AbstractController.php(161): call_user_func_array(Array, Array) #4 /home/vol7_4/xtreemhost.com/xth_20207154/htdocs/concrete/src/Routing/ControllerRouteCallback.php(27): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #5 /home/vol7_4/xtreemhost.com/xth_20207154/htdocs/concrete/src/Routing/Router.php(142): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #6 /home/vol7_4/xtreemhost.com/xth_20207154/htdocs/concrete/src/Support/Facade/Facade.php(119): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #7 /home/vol7_4/xtreemhost.com/xth_20207154/htdocs/concrete/src/Application/Application.php(446): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #8 /home/vol7_4/xtreemhost.com/xth_20207154/htdocs/concrete/bootstrap/start.php(230): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #9 /home/vol7_4/xtreemhost.com/xth_20207154/htdocs/concrete/dispatcher.php(36): require('/home/vol7_4/xt...') #10 /home/vol7_4/xtreemhost.com/xth_20207154/htdocs/index.php(2): require('/home/vol7_4/xt...') #11 {main}
Trace:
#0 [internal function]: Concrete\Core\Package\StartingPointPackage->install_database() #1 /home/vol7_4/xtreemhost.com/xth_20207154/htdocs/concrete/controllers/install.php(294): call_user_func(Array) #2 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'install_databas...') #3 /home/vol7_4/xtreemhost.com/xth_20207154/htdocs/concrete/src/Controller/AbstractController.php(161): call_user_func_array(Array, Array) #4 /home/vol7_4/xtreemhost.com/xth_20207154/htdocs/concrete/src/Routing/ControllerRouteCallback.php(27): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #5 /home/vol7_4/xtreemhost.com/xth_20207154/htdocs/concrete/src/Routing/Router.php(142): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #6 /home/vol7_4/xtreemhost.com/xth_20207154/htdocs/concrete/src/Support/Facade/Facade.php(119): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #7 /home/vol7_4/xtreemhost.com/xth_20207154/htdocs/concrete/src/Application/Application.php(446): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #8 /home/vol7_4/xtreemhost.com/xth_20207154/htdocs/concrete/bootstrap/start.php(230): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #9 /home/vol7_4/xtreemhost.com/xth_20207154/htdocs/concrete/dispatcher.php(36): require('/home/vol7_4/xt...') #10 /home/vol7_4/xtreemhost.com/xth_20207154/htdocs/index.php(2): require('/home/vol7_4/xt...') #11 {main}
CAN SOMEONE PLZ HELP? OMG
Some things to check:
- db user must have enough rights on the database to create table...
- PHP_MEMORY-LIMIT: 64Mb at least
- db connect: if the port is needed, add it in the "database.php" ('port'=>'12345') or in the field server in the install screen: add ";port=12345" (ex: "localhost;port=12345")
- make a local install, and upload all files and the DB (with phpmyadmn). Be carrefull: in Windows, tables are written in lowercase: you must change the "my.ini" to allow uppercase (add "lower_case_table_names=0"). After upload, you can change the files "database.php" and "concrete.php".
- is the server set up to allow innodb tables
- db user must have enough rights on the database to create table...
- PHP_MEMORY-LIMIT: 64Mb at least
- db connect: if the port is needed, add it in the "database.php" ('port'=>'12345') or in the field server in the install screen: add ";port=12345" (ex: "localhost;port=12345")
- make a local install, and upload all files and the DB (with phpmyadmn). Be carrefull: in Windows, tables are written in lowercase: you must change the "my.ini" to allow uppercase (add "lower_case_table_names=0"). After upload, you can change the files "database.php" and "concrete.php".
- is the server set up to allow innodb tables
where can I find these settings?
Those are things on your server, each server is different so if you don't know where to find them you should contact your host.
