Error During Installation btVideo
Permalink
Downloaded concrete 8 locally, installed and ran. Tried to load to website on asmallorage but their php version is 5.4.45, so dumped and loaded concrete5.7.5.13. All went well untill the following error: 1050 Table 'btVideo' already exists. I found this same error reported by ptomask on 9/06/16 with no replies. I'm new to concrete and CMS in general (old shcool Perl programmer for all of my other sites) so no idea how to "fix" an installer. Any suggestions?
An exception occurred while executing 'CREATE TABLE btVideo (bID INT UNSIGNED NOT NULL, webmfID INT UNSIGNED DEFAULT 0, oggfID INT UNSIGNED DEFAULT 0, posterfID INT UNSIGNED DEFAULT 0, mp4fID INT UNSIGNED DEFAULT 0, width INT UNSIGNED DEFAULT NULL, height INT UNSIGNED DEFAULT NULL, PRIMARY KEY(bID)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB': SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'btVideo' already exists. Trace: #0 /home/coasthillsrun/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 /home/coasthillsrun/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 /home/coasthillsrun/public_html/concrete/src/Database/Connection/Connection.php(74): call_user_func_array('parent::query', Array) #4 /home/coasthillsrun/public_html/concrete/src/Package/Package.php(1208): Concrete\Core\Database\Connection\Connection->query('CREATE TABLE bt...') #5 /home/coasthillsrun/public_html/concrete/src/Block/BlockController.php(108): Concrete\Core\Package\Package::installDB('/home/coasthill...') #6 /home/coasthillsrun/public_html/concrete/src/Block/BlockType/BlockType.php(154): Concrete\Core\Block\BlockController->install('/home/coasthill...') #7 /home/coasthillsrun/public_html/concrete/src/Backup/ContentImporter.php(403): Concrete\Core\Block\BlockType\BlockType::installBlockType('video') #8 /home/coasthillsrun/public_html/concrete/src/Backup/ContentImporter.php(71): Concrete\Core\Backup\ContentImporter->importBlockTypes(Object(SimpleXMLElement)) #9 /home/coasthillsrun/public_html/concrete/src/Backup/ContentImporter.php(58): Concrete\Core\Backup\ContentImporter->doImport(Object(SimpleXMLElement)) #10 /home/coasthillsrun/public_html/concrete/src/Package/StartingPointPackage.php(203): Concrete\Core\Backup\ContentImporter->importContentFile('/home/coasthill...') #11 [internal function]: Concrete\Core\Package\StartingPointPackage->install_blocktypes() #12 /home/coasthillsrun/public_html/concrete/controllers/install.php(294): call_user_func(Array) #13 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'install_blockty...') #14 /home/coasthillsrun/public_html/concrete/src/Controller/AbstractController.php(161): call_user_func_array(Array, Array) #15 /home/coasthillsrun/public_html/concrete/src/Routing/ControllerRouteCallback.php(27): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #16 /home/coasthillsrun/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 /home/coasthillsrun/public_html/concrete/src/Support/Facade/Facade.php(119): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #18 /home/coasthillsrun/public_html/concrete/src/Application/Application.php(446): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #19 /home/coasthillsrun/public_html/concrete/src/Application/Application.php(446): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) #20 /home/coasthillsrun/public_html/concrete/bootstrap/start.php(230): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #21 /home/coasthillsrun/public_html/concrete/dispatcher.php(36): require('/home/coasthill...') #22 /home/coasthillsrun/public_html/index.php(2): require('/home/coasthill...') #23 {main}
Uhhhm, scratch that. I found I could update the PHP version within cPanel (who knew?) so I did that and will try to install version 8. Sorry to waste your time. Have a great day!
Same problem with version 8, but different table. Black box installations pretty much suck ... at least time-wise.
An exception occurred while executing 'CREATE TABLE btImageSlider (bID INT UNSIGNED NOT NULL, navigationType INT UNSIGNED DEFAULT 0, timeout INT UNSIGNED DEFAULT NULL, speed INT UNSIGNED DEFAULT NULL, noAnimate INT UNSIGNED DEFAULT NULL, pause INT UNSIGNED DEFAULT NULL, maxWidth INT UNSIGNED DEFAULT NULL, PRIMARY KEY(bID)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB': SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'btImageSlider' already exists.
If you've already had some failed installation attempts, the database may not be empty. Try dropping all its tables, or just deleting and recreating it.
Back it up first, if you've ever had any joy out of it.
Back it up first, if you've ever had any joy out of it.
