getting fatal error on install.
Permalink
I have several sites with concrete 5, but am no means a master.
Went to put latests Concrete 5 up for a new site. Got the following error. I have all folders of the install set to 777 for now for the setup so there was not an issue, but below is the problem I hit.
An exception occurred while executing 'CREATE TABLE btExpressForm (bID INT UNSIGNED NOT NULL, exFormID CHAR(36) DEFAULT NULL COMMENT '(DC2Type:guid)', submitLabel VARCHAR(255) DEFAULT 'Submit', thankyouMsg TEXT DEFAULT NULL, notifyMeOnSubmission TINYINT(1) DEFAULT '0' NOT NULL, recipientEmail VARCHAR(255) DEFAULT NULL, displayCaptcha INT DEFAULT 1, redirectCID INT DEFAULT 0, replyToEmailControlID VARCHAR(255) DEFAULT NULL, addFilesToSet INT DEFAULT 0, PRIMARY KEY(bID)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB': SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'btExpressForm' already exists.
Trace:
#0 /home6/ravenint/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(116): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException)) #1 /home6/ravenint/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(945): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Concrete\Core\Database\Driver\PDOMySqlConcrete5\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'CREATE TABLE bt...') #2 [internal function]: Doctrine\DBAL\Connection->query('CREATE TABLE bt...') #3 /home6/ravenint/public_html/concrete/src/Database/Connection/Connection.php(72): call_user_func_array('parent::query', Array) #4 /home6/ravenint/public_html/concrete/src/Package/Package.php(704): Concrete\Core\Database\Connection\Connection->query('CREATE TABLE bt...') #5 /home6/ravenint/public_html/concrete/src/Block/BlockController.php(112): Concrete\Core\Package\Package::installDB('/home6/ravenint...') #6 /home6/ravenint/public_html/concrete/src/Block/BlockType/BlockType.php(67): Concrete\Core\Block\BlockController->install('/home6/ravenint...') #7 /home6/ravenint/public_html/concrete/src/Backup/ContentImporter/Importer/Routine/ImportBlockTypesRoutine.php(23): Concrete\Core\Block\BlockType\BlockType::installBlockType('express_form') #8 /home6/ravenint/public_html/concrete/src/Backup/ContentImporter.php(45): Concrete\Core\Backup\ContentImporter\Importer\Routine\ImportBlockTypesRoutine->import(Object(SimpleXMLElement)) #9 /home6/ravenint/public_html/concrete/src/Backup/ContentImporter.php(19): Concrete\Core\Backup\ContentImporter->import(Object(SimpleXMLElement)) #10 /home6/ravenint/public_html/concrete/src/Package/StartingPointPackage.php(248): Concrete\Core\Backup\ContentImporter->importContentFile('/home6/ravenint...') #11 /home6/ravenint/public_html/concrete/src/Package/StartingPointPackage.php(161): Concrete\Core\Package\StartingPointPackage->install_blocktypes() #12 /home6/ravenint/public_html/concrete/controllers/install.php(385): Concrete\Core\Package\StartingPointPackage->executeInstallRoutine('install_blockty...') #13 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'install_blockty...') #14 /home6/ravenint/public_html/concrete/src/Controller/AbstractController.php(172): call_user_func_array(Array, Array) #15 /home6/ravenint/public_html/concrete/src/Routing/ControllerRouteCallback.php(27): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #16 /home6/ravenint/public_html/concrete/src/Routing/Router.php(149): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #17 /home6/ravenint/public_html/concrete/src/Http/DefaultDispatcher.php(112): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #18 /home6/ravenint/public_html/concrete/src/Http/DefaultDispatcher.php(53): Concrete\Core\Http\DefaultDispatcher->handleDispatch(Object(Concrete\Core\Http\Request)) #19 /home6/ravenint/public_html/concrete/src/Http/Middleware/DispatcherDelegate.php(39): Concrete\Core\Http\DefaultDispatcher->dispatch(Object(Concrete\Core\Http\Request)) #20 /home6/ravenint/public_html/concrete/src/Http/Middleware/ThumbnailMiddleware.php(61): Concrete\Core\Http\Middleware\DispatcherDelegate->next(Object(Concrete\Core\Http\Request)) #21 /home6/ravenint/public_html/concrete/src/Http/Middleware/MiddlewareDelegate.php(38): Concrete\Core\Http\Middleware\ThumbnailMiddleware->process(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Http\Middleware\DispatcherDelegate)) #22 /home6/ravenint/public_html/concrete/src/Http/Middleware/FrameOptionsMiddleware.php(39): Concrete\Core\Http\Middleware\MiddlewareDelegate->next(Object(Concrete\Core\Http\Request)) #23 /home6/ravenint/public_html/concrete/src/Http/Middleware/MiddlewareDelegate.php(38): Concrete\Core\Http\Middleware\FrameOptionsMiddleware->process(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Http\Middleware\MiddlewareDelegate)) #24 /home6/ravenint/public_html/concrete/src/Http/Middleware/CookieMiddleware.php(37): Concrete\Core\Http\Middleware\MiddlewareDelegate->next(Object(Concrete\Core\Http\Request)) #25 /home6/ravenint/public_html/concrete/src/Http/Middleware/MiddlewareDelegate.php(38): Concrete\Core\Http\Middleware\CookieMiddleware->process(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Http\Middleware\MiddlewareDelegate)) #26 /home6/ravenint/public_html/concrete/src/Http/Middleware/ApplicationMiddleware.php(29): Concrete\Core\Http\Middleware\MiddlewareDelegate->next(Object(Concrete\Core\Http\Request)) #27 /home6/ravenint/public_html/concrete/src/Http/Middleware/MiddlewareDelegate.php(38): Concrete\Core\Http\Middleware\ApplicationMiddleware->process(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Http\Middleware\MiddlewareDelegate)) #28 /home6/ravenint/public_html/concrete/src/Http/Middleware/MiddlewareStack.php(86): Concrete\Core\Http\Middleware\MiddlewareDelegate->next(Object(Concrete\Core\Http\Request)) #29 /home6/ravenint/public_html/concrete/src/Http/DefaultServer.php(85): Concrete\Core\Http\Middleware\MiddlewareStack->process(Object(Concrete\Core\Http\Request)) #30 /home6/ravenint/public_html/concrete/src/Foundation/Runtime/Run/DefaultRunner.php(100): Concrete\Core\Http\DefaultServer->handleRequest(Object(Concrete\Core\Http\Request)) #31 /home6/ravenint/public_html/concrete/src/Foundation/Runtime/DefaultRuntime.php(102): Concrete\Core\Foundation\Runtime\Run\DefaultRunner->run() #32 /home6/ravenint/public_html/concrete/dispatcher.php(39): Concrete\Core\Foundation\Runtime\DefaultRuntime->run() #33 /home6/ravenint/public_html/index.php(3): require('/home6/ravenint...') #34 {main}
Hope someone has some insight.
Went to put latests Concrete 5 up for a new site. Got the following error. I have all folders of the install set to 777 for now for the setup so there was not an issue, but below is the problem I hit.
An exception occurred while executing 'CREATE TABLE btExpressForm (bID INT UNSIGNED NOT NULL, exFormID CHAR(36) DEFAULT NULL COMMENT '(DC2Type:guid)', submitLabel VARCHAR(255) DEFAULT 'Submit', thankyouMsg TEXT DEFAULT NULL, notifyMeOnSubmission TINYINT(1) DEFAULT '0' NOT NULL, recipientEmail VARCHAR(255) DEFAULT NULL, displayCaptcha INT DEFAULT 1, redirectCID INT DEFAULT 0, replyToEmailControlID VARCHAR(255) DEFAULT NULL, addFilesToSet INT DEFAULT 0, PRIMARY KEY(bID)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB': SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'btExpressForm' already exists.
Trace:
#0 /home6/ravenint/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(116): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException)) #1 /home6/ravenint/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(945): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Concrete\Core\Database\Driver\PDOMySqlConcrete5\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'CREATE TABLE bt...') #2 [internal function]: Doctrine\DBAL\Connection->query('CREATE TABLE bt...') #3 /home6/ravenint/public_html/concrete/src/Database/Connection/Connection.php(72): call_user_func_array('parent::query', Array) #4 /home6/ravenint/public_html/concrete/src/Package/Package.php(704): Concrete\Core\Database\Connection\Connection->query('CREATE TABLE bt...') #5 /home6/ravenint/public_html/concrete/src/Block/BlockController.php(112): Concrete\Core\Package\Package::installDB('/home6/ravenint...') #6 /home6/ravenint/public_html/concrete/src/Block/BlockType/BlockType.php(67): Concrete\Core\Block\BlockController->install('/home6/ravenint...') #7 /home6/ravenint/public_html/concrete/src/Backup/ContentImporter/Importer/Routine/ImportBlockTypesRoutine.php(23): Concrete\Core\Block\BlockType\BlockType::installBlockType('express_form') #8 /home6/ravenint/public_html/concrete/src/Backup/ContentImporter.php(45): Concrete\Core\Backup\ContentImporter\Importer\Routine\ImportBlockTypesRoutine->import(Object(SimpleXMLElement)) #9 /home6/ravenint/public_html/concrete/src/Backup/ContentImporter.php(19): Concrete\Core\Backup\ContentImporter->import(Object(SimpleXMLElement)) #10 /home6/ravenint/public_html/concrete/src/Package/StartingPointPackage.php(248): Concrete\Core\Backup\ContentImporter->importContentFile('/home6/ravenint...') #11 /home6/ravenint/public_html/concrete/src/Package/StartingPointPackage.php(161): Concrete\Core\Package\StartingPointPackage->install_blocktypes() #12 /home6/ravenint/public_html/concrete/controllers/install.php(385): Concrete\Core\Package\StartingPointPackage->executeInstallRoutine('install_blockty...') #13 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'install_blockty...') #14 /home6/ravenint/public_html/concrete/src/Controller/AbstractController.php(172): call_user_func_array(Array, Array) #15 /home6/ravenint/public_html/concrete/src/Routing/ControllerRouteCallback.php(27): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #16 /home6/ravenint/public_html/concrete/src/Routing/Router.php(149): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #17 /home6/ravenint/public_html/concrete/src/Http/DefaultDispatcher.php(112): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #18 /home6/ravenint/public_html/concrete/src/Http/DefaultDispatcher.php(53): Concrete\Core\Http\DefaultDispatcher->handleDispatch(Object(Concrete\Core\Http\Request)) #19 /home6/ravenint/public_html/concrete/src/Http/Middleware/DispatcherDelegate.php(39): Concrete\Core\Http\DefaultDispatcher->dispatch(Object(Concrete\Core\Http\Request)) #20 /home6/ravenint/public_html/concrete/src/Http/Middleware/ThumbnailMiddleware.php(61): Concrete\Core\Http\Middleware\DispatcherDelegate->next(Object(Concrete\Core\Http\Request)) #21 /home6/ravenint/public_html/concrete/src/Http/Middleware/MiddlewareDelegate.php(38): Concrete\Core\Http\Middleware\ThumbnailMiddleware->process(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Http\Middleware\DispatcherDelegate)) #22 /home6/ravenint/public_html/concrete/src/Http/Middleware/FrameOptionsMiddleware.php(39): Concrete\Core\Http\Middleware\MiddlewareDelegate->next(Object(Concrete\Core\Http\Request)) #23 /home6/ravenint/public_html/concrete/src/Http/Middleware/MiddlewareDelegate.php(38): Concrete\Core\Http\Middleware\FrameOptionsMiddleware->process(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Http\Middleware\MiddlewareDelegate)) #24 /home6/ravenint/public_html/concrete/src/Http/Middleware/CookieMiddleware.php(37): Concrete\Core\Http\Middleware\MiddlewareDelegate->next(Object(Concrete\Core\Http\Request)) #25 /home6/ravenint/public_html/concrete/src/Http/Middleware/MiddlewareDelegate.php(38): Concrete\Core\Http\Middleware\CookieMiddleware->process(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Http\Middleware\MiddlewareDelegate)) #26 /home6/ravenint/public_html/concrete/src/Http/Middleware/ApplicationMiddleware.php(29): Concrete\Core\Http\Middleware\MiddlewareDelegate->next(Object(Concrete\Core\Http\Request)) #27 /home6/ravenint/public_html/concrete/src/Http/Middleware/MiddlewareDelegate.php(38): Concrete\Core\Http\Middleware\ApplicationMiddleware->process(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Http\Middleware\MiddlewareDelegate)) #28 /home6/ravenint/public_html/concrete/src/Http/Middleware/MiddlewareStack.php(86): Concrete\Core\Http\Middleware\MiddlewareDelegate->next(Object(Concrete\Core\Http\Request)) #29 /home6/ravenint/public_html/concrete/src/Http/DefaultServer.php(85): Concrete\Core\Http\Middleware\MiddlewareStack->process(Object(Concrete\Core\Http\Request)) #30 /home6/ravenint/public_html/concrete/src/Foundation/Runtime/Run/DefaultRunner.php(100): Concrete\Core\Http\DefaultServer->handleRequest(Object(Concrete\Core\Http\Request)) #31 /home6/ravenint/public_html/concrete/src/Foundation/Runtime/DefaultRuntime.php(102): Concrete\Core\Foundation\Runtime\Run\DefaultRunner->run() #32 /home6/ravenint/public_html/concrete/dispatcher.php(39): Concrete\Core\Foundation\Runtime\DefaultRuntime->run() #33 /home6/ravenint/public_html/index.php(3): require('/home6/ravenint...') #34 {main}
Hope someone has some insight.
Are you using a newly-created database? If not, do so (or at least drop all of the database's tables).
Of course, if there's anything in the current database that you want to keep, back it up first!
Of course, if there's anything in the current database that you want to keep, back it up first!
This is a fresh install, and I tried deleting the DB and recreating, used a different DB name as well.
An exception occurred while executing 'CREATE TABLE btCoreStackDisplay (bID INT UNSIGNED NOT NULL, stID INT UNSIGNED NOT NULL, INDEX stID (stID), PRIMARY KEY(bID)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB': SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'btCoreStackDisplay' already exists.
Trace:
#0 /home6/ravenint/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(116): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException)) #1 /home6/ravenint/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(945): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Concrete\Core\Database\Driver\PDOMySqlConcrete5\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'CREATE TABLE bt...') #2 [internal function]: Doctrine\DBAL\Connection->query('CREATE TABLE bt...') #3 /home6/ravenint/public_html/concrete/src/Database/Connection/Connection.php(74): call_user_func_array('parent::query', Array) #4 /home6/ravenint/public_html/concrete/src/Package/Package.php(1208): Concrete\Core\Database\Connection\Connection->query('CREATE TABLE bt...') #5 /home6/ravenint/public_html/concrete/src/Block/BlockController.php(108): Concrete\Core\Package\Package::installDB('/home6/ravenint...') #6 /home6/ravenint/public_html/concrete/src/Block/BlockType/BlockType.php(154): Concrete\Core\Block\BlockController->install('/home6/ravenint...') #7 /home6/ravenint/public_html/concrete/src/Backup/ContentImporter.php(403): Concrete\Core\Block\BlockType\BlockType::installBlockType('core_stack_disp...') #8 /home6/ravenint/public_html/concrete/src/Backup/ContentImporter.php(71): Concrete\Core\Backup\ContentImporter->importBlockTypes(Object(SimpleXMLElement)) #9 /home6/ravenint/public_html/concrete/src/Backup/ContentImporter.php(58): Concrete\Core\Backup\ContentImporter->doImport(Object(SimpleXMLElement)) #10 /home6/ravenint/public_html/concrete/src/Package/StartingPointPackage.php(203): Concrete\Core\Backup\ContentImporter->importContentFile('/home6/ravenint...') #11 [internal function]: Concrete\Core\Package\StartingPointPackage->install_blocktypes() #12 /home6/ravenint/public_html/concrete/controllers/install.php(294): call_user_func(Array) #13 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'install_blockty...') #14 /home6/ravenint/public_html/concrete/src/Controller/AbstractController.php(161): call_user_func_array(Array, Array) #15 /home6/ravenint/public_html/concrete/src/Routing/ControllerRouteCallback.php(27): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #16 /home6/ravenint/public_html/concrete/src/Routing/Router.php(142): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #17 /home6/ravenint/public_html/concrete/src/Support/Facade/Facade.php(119): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #18 /home6/ravenint/public_html/concrete/src/Application/Application.php(446): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #19 /home6/ravenint/public_html/concrete/src/Application/Application.php(446): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) #20 /home6/ravenint/public_html/concrete/bootstrap/start.php(230): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #21 /home6/ravenint/public_html/concrete/dispatcher.php(36): require('/home6/ravenint...') #22 /home6/ravenint/public_html/index.php(2): require('/home6/ravenint...') #23 {main}
Back
Any ideas?