5.7.4.2 install on Blue Host

Permalink
I followed all the basic installation instructions various times and get a different error each time half way through install. This was the latest: What am I doing wrong?

An exception occurred while executing 'INSERT INTO BlockTypes (btIgnorePageThemeGridFrameworkContainer, btHandle, btName, btDescription, btCopyWhenPropagate, btIncludeAll, btIsInternal, btSupportsInlineEdit, btSupportsInlineAdd, btInterfaceHeight, btInterfaceWidth, pkgID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [0, "core_area_layout", "Area Layout", "Proxy block for area layouts.", 0, 0, 1, 1, 1, "400", "400", 0]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'core_area_layout' for key 'btHandle'.

Trace:
#0 /home1/rockymtv/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 /home1/rockymtv/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(172): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Concrete\Core\Database\Driver\PDOMySqlConcrete5\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'INSERT INTO Blo...', Array) #2 /home1/rockymtv/public_html/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/BasicEntityPersister.php(279): Doctrine\DBAL\Statement->execute() #3 /home1/rockymtv/public_html/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(966): Doctrine\ORM\Persisters\BasicEntityPersister->executeInserts() #4 /home1/rockymtv/public_html/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(335): Doctrine\ORM\UnitOfWork->executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata)) #5 /home1/rockymtv/public_html/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(340): Doctrine\ORM\UnitOfWork->commit(NULL) #6 /home1/rockymtv/public_html/concrete/src/Block/BlockType/BlockType.php(178): Doctrine\ORM\EntityManager->flush() #7 /home1/rockymtv/public_html/concrete/src/Backup/ContentImporter.php(406): Concrete\Core\Block\BlockType\BlockType::installBlockType('core_area_layou...') #8 /home1/rockymtv/public_html/concrete/src/Backup/ContentImporter.php(73): Concrete\Core\Backup\ContentImporter->importBlockTypes(Object(SimpleXMLElement)) #9 /home1/rockymtv/public_html/concrete/src/Backup/ContentImporter.php(60): Concrete\Core\Backup\ContentImporter->doImport(Object(SimpleXMLElement)) #10 /home1/rockymtv/public_html/concrete/src/Package/StartingPointPackage.php(188): Concrete\Core\Backup\ContentImporter->importContentFile('/home1/rockymtv...') #11 [internal function]: Concrete\Core\Package\StartingPointPackage->install_blocktypes() #12 /home1/rockymtv/public_html/concrete/controllers/install.php(264): call_user_func(Array) #13 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'install_blockty...') #14 /home1/rockymtv/public_html/concrete/src/Controller/AbstractController.php(156): call_user_func_array(Array, Array) #15 /home1/rockymtv/public_html/concrete/src/Routing/ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #16 /home1/rockymtv/public_html/concrete/src/Routing/Router.php(59): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #17 /home1/rockymtv/public_html/concrete/src/Support/Facade/Facade.php(119): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #18 /home1/rockymtv/public_html/concrete/src/Application/Application.php(366): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #19 /home1/rockymtv/public_html/concrete/src/Application/Application.php(366): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) #20 /home1/rockymtv/public_html/concrete/bootstrap/start.php(217): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #21 /home1/rockymtv/public_html/concrete/dispatcher.php(36): require('/home1/rockymtv...') #22 /home1/rockymtv/public_html/index.php(2): require('/home1/rockymtv...') #23 {main}

View Replies:
surfsupjoe125 replied on at Permalink Reply
surfsupjoe125
Hi there,

I have only installed manually but this is how I do it.

You are either placing the files directly in your root or in a folder for that particular site should you have addon domains. Upload the C5 zip file to either location. Once the file is there, extract the files into the root or that folder for an additional domain. You will see the concrete5.7.4.2.zip and a new folder named concrete5.7.4.2. Copy all of the files and move them into your newly named folder or the root. you can now see all of C5 folders and files where they are suppose to be. You can now delete the other empty folder and .zip file should you choose to do so.

Next go the Database section of Cpanel and create your database for this site. Make sure you create a user for the database and give yourself full adminstrative rights. now you can call up the site in a browser and it should start the installation process. You will have to input the required info like your DB name, DB username, etc. Once that is complete, C5 should install. I have failed to create the DB user and did not give myself rights which caused loading errors.

Not sure if you have done these steps or not but wanted to share in case it might help you.

Good luck,
surfsupjoe125 replied on at Permalink Reply
surfsupjoe125
Hi there,

I have only installed manually but this is how I do it.

You are either placing the files directly in your root or in a folder for that particular site should you have addon domains. Upload the C5 zip file to either location. Once the file is there, extract the files into the root or that folder for an additional domain. You will see the concrete5.7.4.2.zip and a new folder named concrete5.7.4.2. Copy all of the files and move them into your newly named folder or the root. you can now see all of C5 folders and files where they are suppose to be. You can now delete the other empty folder and .zip file should you choose to do so.

Next go the Database section of Cpanel and create your database for this site. Make sure you create a user for the database and give yourself full adminstrative rights. now you can call up the site in a browser and it should start the installation process. You will have to input the required info like your DB name, DB username, etc. Once that is complete, C5 should install. I have failed to create the DB user and did not give myself rights which caused loading errors.

Not sure if you have done these steps or not but wanted to share in case it might help you.

Good luck,
10317976 replied on at Permalink Reply
Darn it, That is exactly what I did. I even gave the specific folders world writable permissions and gave my database user full access. C5 seemed to be installing just fine and then threw this error.
mnakalay replied on at Permalink Reply
mnakalay
I am not 100% sure but it looks like it failed the first time and then you kept trying to install on the same database with tables present from the previous attempt.

You need to empty your database before trying a new install.

If you did, sorry, just ignore this comment :)
10317976 replied on at Permalink Reply
I made that mistake after the first fail. So I created a whole new data base for the next 2 reinstall. What is crazy is that I did 2 identical installs and got 2 different error messages. I even wiped all my concrete 5 files and reinstalled them from the zip file.
mnakalay replied on at Permalink Reply
mnakalay
Last idea I have, check with Bluehost if your plan meets the requirements:
PHP 5.3.3. or greater
PHP Safe Mode Off
PHP Memory Limit at least 64 MB
MySQL 5.1.5 or Higher

Maybe ask specifically for the MySQL version
10317976 replied on at Permalink Reply
PHP 5.4.4
MySQL 5.5.42-37
sql.safe_mode=off
PHP Memory 128MB
10317976 replied on at Permalink Reply
I get a different error every time I try to reinstall

An exception occurred while executing 'insert into WorkflowTypes (wftHandle, wftName, pkgID) values (?, ?, ?)' with params [{"0":"basic"}, {"0":"Basic Workflow"}, 0]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'basic' for key 'wftHandle'.

Trace:
#0 /home1/rockymtv/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 /home1/rockymtv/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Concrete\Core\Database\Driver\PDOMySqlConcrete5\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'insert into Wor...', Array) #2 /home1/rockymtv/public_html/concrete/src/Database/Connection/Connection.php(61): Doctrine\DBAL\Connection->executeQuery('insert into Wor...', Array) #3 /home1/rockymtv/public_html/concrete/src/Workflow/Type.php(82): Concrete\Core\Database\Connection\Connection->Execute('insert into Wor...', Array) #4 /home1/rockymtv/public_html/concrete/src/Backup/ContentImporter.php(421): Concrete\Core\Workflow\Type::add(Object(SimpleXMLElement), Object(SimpleXMLElement), NULL) #5 /home1/rockymtv/public_html/concrete/src/Backup/ContentImporter.php(91): Concrete\Core\Backup\ContentImporter->importWorkflowTypes(Object(SimpleXMLElement)) #6 /home1/rockymtv/public_html/concrete/src/Backup/ContentImporter.php(60): Concrete\Core\Backup\ContentImporter->doImport(Object(SimpleXMLElement)) #7 /home1/rockymtv/public_html/concrete/src/Package/StartingPointPackage.php(403): Concrete\Core\Backup\ContentImporter->importContentFile('/home1/rockymtv...') #8 [internal function]: Concrete\Core\Package\StartingPointPackage->install_permissions() #9 /home1/rockymtv/public_html/concrete/controllers/install.php(264): call_user_func(Array) #10 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'install_permiss...') #11 /home1/rockymtv/public_html/concrete/src/Controller/AbstractController.php(156): call_user_func_array(Array, Array) #12 /home1/rockymtv/public_html/concrete/src/Routing/ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #13 /home1/rockymtv/public_html/concrete/src/Routing/Router.php(59): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #14 /home1/rockymtv/public_html/concrete/src/Support/Facade/Facade.php(119): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #15 /home1/rockymtv/public_html/concrete/src/Application/Application.php(366): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #16 /home1/rockymtv/public_html/concrete/src/Application/Application.php(366): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) #17 /home1/rockymtv/public_html/concrete/bootstrap/start.php(217): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #18 /home1/rockymtv/public_html/concrete/dispatcher.php(36): require('/home1/rockymtv...') #19 /home1/rockymtv/public_html/index.php(2): require('/home1/rockymtv...') #20 {main}
10317976 replied on at Permalink Reply
Here is another one. Crazy that I can't get it to give me the same error twice!

An exception occurred while executing 'insert into Collections (cID, cHandle, cDateAdded, cDateModified) values (?, ?, ?, ?)' with params [1, "home", "2015-06-23 16:33:54", "2015-06-23 16:33:54"]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'.

Trace:
#0 /home1/rockymtv/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 /home1/rockymtv/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Concrete\Core\Database\Driver\PDOMySqlConcrete5\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'insert into Col...', Array) #2 /home1/rockymtv/public_html/concrete/src/Database/Connection/Connection.php(69): Doctrine\DBAL\Connection->executeQuery('insert into Col...', Array) #3 /home1/rockymtv/public_html/concrete/src/Page/Collection/Collection.php(105): Concrete\Core\Database\Connection\Connection->query('insert into Col...', Array) #4 /home1/rockymtv/public_html/concrete/src/Page/Page.php(2812): Concrete\Core\Page\Collection\Collection::addCollection(Array) #5 /home1/rockymtv/public_html/concrete/src/Package/StartingPointPackage.php(121): Concrete\Core\Page\Page::addHomePage() #6 [internal function]: Concrete\Core\Package\StartingPointPackage->add_home_page() #7 /home1/rockymtv/public_html/concrete/controllers/install.php(264): call_user_func(Array) #8 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'add_home_page') #9 /home1/rockymtv/public_html/concrete/src/Controller/AbstractController.php(156): call_user_func_array(Array, Array) #10 /home1/rockymtv/public_html/concrete/src/Routing/ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #11 /home1/rockymtv/public_html/concrete/src/Routing/Router.php(59): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #12 /home1/rockymtv/public_html/concrete/src/Support/Facade/Facade.php(119): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #13 /home1/rockymtv/public_html/concrete/src/Application/Application.php(366): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #14 /home1/rockymtv/public_html/concrete/src/Application/Application.php(366): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) #15 /home1/rockymtv/public_html/concrete/bootstrap/start.php(217): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #16 /home1/rockymtv/public_html/concrete/dispatcher.php(36): require('/home1/rockymtv...') #17 /home1/rockymtv/public_html/index.php(2): require('/home1/rockymtv...') #18 {main}
mnakalay replied on at Permalink Reply
mnakalay
It's actually always the same error except it happens at different points: a table field marked as primary key with no duplicate allowed is trying to save a second time with the same value.

If you hadn't started again with a totally new database I'd say that's the problem.

After some research, it appears you're not the only one having that problem nobody seems to have a final answer though.

Let's try something: delete the database (not empty, delete) create a new one and make sure that when selecting the type you select utf8_general_ci then try installing again.

Fingers crossed
10317976 replied on at Permalink Reply
So, I tried everything, Finally I got Mojo Marketplace to make an install script, which still would not work for me, however I called in to Blue Host and they did it from their end, the install script worked...beyond weird!!! So Resolution is, now that there is an install script, just call Blue Host and they will help you. (they are not helpful on a raw install)