5.7 Install Fails - SQLSTATE[42S02] and Base table or view not found: 1146
Permalink
Hi,
I've installed 5.7.3.1 a few times now and have had no problems. However on this server I'm getting stuck immediately after having filled out the details of the site & database. The install instantly comes back with an error:
An exception occurred while executing 'select count(asID) from btFormAnswerSet': SQLSTATE[42S02]: Base table or view not found: 1146 Table 'emma5276_ll2.btFormAnswerSet' doesn't exist.
If I look in the database, it's quite right - there's absolutely nothing in there. The server conforms to the requirements, with Apache Version 2.2.29, PHP Version 5.4.38, MySQL Version 5.5.42-cll and all the other items available.
Here's the trace:
#0 /home/emma5276/public_html/new/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'select count(as...', Array) #1 /home/emma5276/public_html/new/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(419): Doctrine\DBAL\Connection->executeQuery('select count(as...', Array) #2 /home/emma5276/public_html/new/concrete/src/Database/Connection/Connection.php(118): Doctrine\DBAL\Connection->fetchColumn('select count(as...', Array, 0) #3 /home/emma5276/public_html/new/concrete/blocks/form/statistics.php(53): Concrete\Core\Database\Connection\Connection->GetOne('select count(as...', Array) #4 /home/emma5276/public_html/new/concrete/blocks/form/statistics.php(20): Concrete\Block\Form\Statistics::getTotalSubmissionsBetween() #5 /home/emma5276/public_html/new/concrete/blocks/dashboard_site_activity/controller.php(44): Concrete\Block\Form\Statistics::getTotalSubmissions() #6 [internal function]: Concrete\Block\DashboardSiteActivity\Controller->view() #7 /home/emma5276/public_html/new/concrete/src/Controller/AbstractController.php(156): call_user_func_array(Array, Array) #8 /home/emma5276/public_html/new/concrete/src/Controller/AbstractController.php(147): Concrete\Core\Controller\AbstractController->runAction('view', Array) #9 /home/emma5276/public_html/new/concrete/src/Block/BlockController.php(570): Concrete\Core\Controller\AbstractController->runTask('view', Array) #10 /home/emma5276/public_html/new/concrete/src/Package/StartingPointPackage.php(79): Concrete\Core\Block\BlockController->setupAndRun('view') #11 [internal function]: Concrete\Core\Package\StartingPointPackage->precache() #12 /home/emma5276/public_html/new/concrete/controllers/install.php(286): call_user_func(Array) #13 [internal function]: Concrete\Controller\Install->run_routine('elemental_blank', 'precache') #14 /home/emma5276/public_html/new/concrete/src/Controller/AbstractController.php(156): call_user_func_array(Array, Array) #15 /home/emma5276/public_html/new/concrete/src/Routing/ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #16 /home/emma5276/public_html/new/concrete/src/Routing/Router.php(59): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #17 /home/emma5276/public_html/new/concrete/src/Support/Facade/Facade.php(116): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #18 /home/emma5276/public_html/new/concrete/src/Application/Application.php(342): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #19 /home/emma5276/public_html/new/concrete/src/Application/Application.php(342): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) #20 /home/emma5276/public_html/new/concrete/bootstrap/start.php(196): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #21 /home/emma5276/public_html/new/concrete/dispatcher.php(36): require('/home/emma5276/...') #22 /home/emma5276/public_html/new/index.php(2): require('/home/emma5276/...') #23 {main}
I've installed 5.7.3.1 a few times now and have had no problems. However on this server I'm getting stuck immediately after having filled out the details of the site & database. The install instantly comes back with an error:
An exception occurred while executing 'select count(asID) from btFormAnswerSet': SQLSTATE[42S02]: Base table or view not found: 1146 Table 'emma5276_ll2.btFormAnswerSet' doesn't exist.
If I look in the database, it's quite right - there's absolutely nothing in there. The server conforms to the requirements, with Apache Version 2.2.29, PHP Version 5.4.38, MySQL Version 5.5.42-cll and all the other items available.
Here's the trace:
#0 /home/emma5276/public_html/new/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'select count(as...', Array) #1 /home/emma5276/public_html/new/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(419): Doctrine\DBAL\Connection->executeQuery('select count(as...', Array) #2 /home/emma5276/public_html/new/concrete/src/Database/Connection/Connection.php(118): Doctrine\DBAL\Connection->fetchColumn('select count(as...', Array, 0) #3 /home/emma5276/public_html/new/concrete/blocks/form/statistics.php(53): Concrete\Core\Database\Connection\Connection->GetOne('select count(as...', Array) #4 /home/emma5276/public_html/new/concrete/blocks/form/statistics.php(20): Concrete\Block\Form\Statistics::getTotalSubmissionsBetween() #5 /home/emma5276/public_html/new/concrete/blocks/dashboard_site_activity/controller.php(44): Concrete\Block\Form\Statistics::getTotalSubmissions() #6 [internal function]: Concrete\Block\DashboardSiteActivity\Controller->view() #7 /home/emma5276/public_html/new/concrete/src/Controller/AbstractController.php(156): call_user_func_array(Array, Array) #8 /home/emma5276/public_html/new/concrete/src/Controller/AbstractController.php(147): Concrete\Core\Controller\AbstractController->runAction('view', Array) #9 /home/emma5276/public_html/new/concrete/src/Block/BlockController.php(570): Concrete\Core\Controller\AbstractController->runTask('view', Array) #10 /home/emma5276/public_html/new/concrete/src/Package/StartingPointPackage.php(79): Concrete\Core\Block\BlockController->setupAndRun('view') #11 [internal function]: Concrete\Core\Package\StartingPointPackage->precache() #12 /home/emma5276/public_html/new/concrete/controllers/install.php(286): call_user_func(Array) #13 [internal function]: Concrete\Controller\Install->run_routine('elemental_blank', 'precache') #14 /home/emma5276/public_html/new/concrete/src/Controller/AbstractController.php(156): call_user_func_array(Array, Array) #15 /home/emma5276/public_html/new/concrete/src/Routing/ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #16 /home/emma5276/public_html/new/concrete/src/Routing/Router.php(59): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #17 /home/emma5276/public_html/new/concrete/src/Support/Facade/Facade.php(116): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #18 /home/emma5276/public_html/new/concrete/src/Application/Application.php(342): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #19 /home/emma5276/public_html/new/concrete/src/Application/Application.php(342): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) #20 /home/emma5276/public_html/new/concrete/bootstrap/start.php(196): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #21 /home/emma5276/public_html/new/concrete/dispatcher.php(36): require('/home/emma5276/...') #22 /home/emma5276/public_html/new/index.php(2): require('/home/emma5276/...') #23 {main}
No, it's a brand new installation...
Have you checked that there is create table permission for the database username and password you are using for your concrete5 installation.
Yes, the db user has full privileges including create table.
Just tried and succeeded in installing v5.6.3.3 - no problems with that, so it's definitely something with 5.7.
Despite there being no message saying to disable eAccelerator, I added the following to my php.ini file and install was successful:
eaccelerator.enable 0
eaccelerator.optimizer 0
eaccelerator.enable 0
eaccelerator.optimizer 0
Are you moving concrete5 installation from one server to another?