Installation failed for Version 5.7.5.3: Unable to install database: 42000

Permalink
Trying to install Version 5.7.5.3 on MySQL 5.5 and 5.7 (tried both), but keep running into this showstopper. Thanks for any assistance you can provide.

Unable to install database: 42000.

Trace:
#0 [internal function]: Concrete\Core\Package\StartingPointPackage->install_database() #1 /Library/WebServer/Documents/tuts/concrete/controllers/Install.php(275): call_user_func(Array) #2 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'install_databas...') #3 /Library/WebServer/Documents/tuts/concrete/src/Controller/AbstractController.php(156): call_user_func_array(Array, Array) #4 /Library/WebServer/Documents/tuts/concrete/src/Routing/ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #5 /Library/WebServer/Documents/tuts/concrete/src/Routing/Router.php(115): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #6 /Library/WebServer/Documents/tuts/concrete/src/Support/Facade/Facade.php(119): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #7 /Library/WebServer/Documents/tuts/concrete/src/Application/Application.php(392): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #8 /Library/WebServer/Documents/tuts/concrete/src/Application/Application.php(392): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) #9 /Library/WebServer/Documents/tuts/concrete/bootstrap/start.php(256): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #10 /Library/WebServer/Documents/tuts/concrete/dispatcher.php(36): require('/Library/WebSer...') #11 /Library/WebServer/Documents/tuts/index.php(2): require('/Library/WebSer...') #12 {main}

 
exchangecore replied on at Permalink Best Answer Reply
exchangecore
You should install Version 5.7.5.6 instead, this was a known bug that has been resolved.

https://github.com/concrete5/concrete5/issues/3185...
unsitely replied on at Permalink Reply
Many thanks!
alsmith replied on at Permalink Reply
I have the same issue with fresh install and fresh download.
Version 5.7.5.6


Yet when I check I see the database there with empty tables.
alsmith replied on at Permalink Reply
I have the same issue with fresh install and fresh download.
Version 5.7.5.6


Yet when I check I see the database there with empty tables.
unsitely replied on at Permalink Reply
Yes, it created the tables but then failed shortly afterward and didn't finish under 5.7.5.3. Installing 5.7.5.6 ended up working for me. But I had to drop the database and start all over.
alsmith replied on at Permalink Reply
i deleted the tables 3 times and tried over again. each time still failed.
alsmith replied on at Permalink Reply
Unable to install database: 42000.

Trace:
#0 [internal function]: Concrete\Core\Package\StartingPointPackage->install_database() #1 /home/wwavac/public_html/site/concrete5.7.5.6/concrete/controllers/install.php(293): call_user_func(Array) #2 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'install_databas...') #3 /home/wwavac/public_html/site/concrete5.7.5.6/concrete/src/Controller/AbstractController.php(161): call_user_func_array(Array, Array) #4 /home/wwavac/public_html/site/concrete5.7.5.6/concrete/src/Routing/ControllerRouteCallback.php(27): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #5 /home/wwavac/public_html/site/concrete5.7.5.6/concrete/src/Routing/Router.php(142): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #6 /home/wwavac/public_html/site/concrete5.7.5.6/concrete/src/Support/Facade/Facade.php(119): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #7 /home/wwavac/public_html/site/concrete5.7.5.6/concrete/src/Application/Application.php(434): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #8 /home/wwavac/public_html/site/concrete5.7.5.6/concrete/src/Application/Application.php(434): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) #9 /home/wwavac/public_html/site/concrete5.7.5.6/concrete/bootstrap/start.php(231): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #10 /home/wwavac/public_html/site/concrete5.7.5.6/concrete/dispatcher.php(36): require('/home/wwavac/pu...') #11 /home/wwavac/public_html/site/concrete5.7.5.6/index.php(2): require('/home/wwavac/pu...') #12 {main}
Back
alsmith replied on at Permalink Reply
I think I discovered the issue. The server was not set up to allow innodb tables.
I installed it sucessfully on another server with php5.6.17 and mySQL 5.6.28
alanpalmer replied on at Permalink Reply
I'm having the same issue exactly...however I'm stumped, mostly due to my lack of knowledge, and partly due to my lack of support / tools available via my hosting provider (Network Solutions).

I've tried a myriad of the solutions I've seen posted, however I have yet to crack the issue.