Unable to install database: 42000
Permalink
I am trying to install C5 and am getting the following error. I can see all the tables being created in the database via myphpadmin, but I can't complete the installation process. I had to upload all of the C5 files via ftp, but i did not get any error messages that files did not copy over. I am trying to install Concrete5.7.5.9.
Below is a copy of the error message I received. I don't know what it means. I'm a power design user, not a back end developer, however I HAVE successfully installed on other web hosts. I'm working with a different web host for my client (aplus.net) so not sure if it is a server problem or a C5 problem. Hoping someone can help or point me in the right direction.
Unable to install database: 42000.
Trace:
#0 [internal function]: Concrete\Core\Package\StartingPointPackage->install_database() #1 /services17/webpages/util/r/a/randygarber.site.aplus.net/public/c5/concrete/controllers/install.php(294): call_user_func(Array) #2 [internal function]: Concrete\Controller\Install->run_routine('elemental_blank', 'install_databas...') #3 /services17/webpages/util/r/a/randygarber.site.aplus.net/public/c5/concrete/src/Controller/AbstractController.php(161): call_user_func_array(Array, Array) #4 /services17/webpages/util/r/a/randygarber.site.aplus.net/public/c5/concrete/src/Routing/ControllerRouteCallback.php(27): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #5 /services17/webpages/util/r/a/randygarber.site.aplus.net/public/c5/concrete/src/Routing/Router.php(142): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #6 /services17/webpages/util/r/a/randygarber.site.aplus.net/public/c5/concrete/src/Support/Facade/Facade.php(119): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #7 /services17/webpages/util/r/a/randygarber.site.aplus.net/public/c5/concrete/src/Application/Application.php(446): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #8 /services17/webpages/util/r/a/randygarber.site.aplus.net/public/c5/concrete/src/Application/Application.php(446): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) #9 /services17/webpages/util/r/a/randygarber.site.aplus.net/public/c5/concrete/bootstrap/start.php(230): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #10 /services17/webpages/util/r/a/randygarber.site.aplus.net/public/c5/concrete/dispatcher.php(36): require('/services17/web...') #11 /services17/webpages/util/r/a/randygarber.site.aplus.net/public/c5/index.php(2): require('/services17/web...') #12 {main}
Do I need to change any of these permissions on the database?
See attached screen grab.
Below is a copy of the error message I received. I don't know what it means. I'm a power design user, not a back end developer, however I HAVE successfully installed on other web hosts. I'm working with a different web host for my client (aplus.net) so not sure if it is a server problem or a C5 problem. Hoping someone can help or point me in the right direction.
Unable to install database: 42000.
Trace:
#0 [internal function]: Concrete\Core\Package\StartingPointPackage->install_database() #1 /services17/webpages/util/r/a/randygarber.site.aplus.net/public/c5/concrete/controllers/install.php(294): call_user_func(Array) #2 [internal function]: Concrete\Controller\Install->run_routine('elemental_blank', 'install_databas...') #3 /services17/webpages/util/r/a/randygarber.site.aplus.net/public/c5/concrete/src/Controller/AbstractController.php(161): call_user_func_array(Array, Array) #4 /services17/webpages/util/r/a/randygarber.site.aplus.net/public/c5/concrete/src/Routing/ControllerRouteCallback.php(27): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #5 /services17/webpages/util/r/a/randygarber.site.aplus.net/public/c5/concrete/src/Routing/Router.php(142): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #6 /services17/webpages/util/r/a/randygarber.site.aplus.net/public/c5/concrete/src/Support/Facade/Facade.php(119): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #7 /services17/webpages/util/r/a/randygarber.site.aplus.net/public/c5/concrete/src/Application/Application.php(446): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #8 /services17/webpages/util/r/a/randygarber.site.aplus.net/public/c5/concrete/src/Application/Application.php(446): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) #9 /services17/webpages/util/r/a/randygarber.site.aplus.net/public/c5/concrete/bootstrap/start.php(230): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #10 /services17/webpages/util/r/a/randygarber.site.aplus.net/public/c5/concrete/dispatcher.php(36): require('/services17/web...') #11 /services17/webpages/util/r/a/randygarber.site.aplus.net/public/c5/index.php(2): require('/services17/web...') #12 {main}
Do I need to change any of these permissions on the database?
See attached screen grab.
Do a "grant all on databasename.* to 'databaseUser'@'localhost' identified by 'password'" and try again
Thanks. But where do i do that?
Sorry for such a late reply as I just saw this. It would be done from either the mysql command line or using a tool like phpMyAdmin.
Thanks! I ended up having to move to another host, as the one for this account wouldn't allow certain access to the server that C5 requires.
Good to here you got it settled!
