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}

 
Pluto replied on at Permalink Reply
Pluto
hello nthorpe
Are you moving concrete5 installation from one server to another?
nthorpe replied on at Permalink Reply
No, it's a brand new installation...
Pluto replied on at Permalink Reply
Pluto
Have you checked that there is create table permission for the database username and password you are using for your concrete5 installation.
nthorpe replied on at Permalink Reply
Yes, the db user has full privileges including create table.
nthorpe replied on at Permalink Reply
Just tried and succeeded in installing v5.6.3.3 - no problems with that, so it's definitely something with 5.7.
nthorpe replied on at Permalink Best Answer Reply
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