Another 5.7 install issue

Permalink 1 user found helpful
5.7 is failing to install, no error logged in the server logs however the install log is below. PHP versions & DB versions are OK, file permissions are ok. PHP resource limits are set high (60sec max execution, 256Mb RAM limit), open basedir is disabled.

Ideas or even pointers to further troubleshooting welcome!

Thanks,

Jim

#0 /var/www/clients/client15/web42/web/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Driver/AnnotationDriver.php(89): Doctrine\ORM\Mapping\MappingException::classIsNotAValidEntityOrMappedSuperClass('Concrete\Core\B...') #1 /var/www/clients/client15/web42/web/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ClassMetadataFactory.php(117): Doctrine\ORM\Mapping\Driver\AnnotationDriver->loadMetadataForClass('Concrete\Core\B...', Object(Doctrine\ORM\Mapping\ClassMetadata)) #2 /var/www/clients/client15/web42/web/concrete/vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/AbstractClassMetadataFactory.php(318): Doctrine\ORM\Mapping\ClassMetadataFactory->doLoadMetadata(Object(Doctrine\ORM\Mapping\ClassMetadata), NULL, false, Array) #3 /var/www/clients/client15/web42/web/concrete/vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/AbstractClassMetadataFactory.php(211): Doctrine\Common\Persistence\Mapping\AbstractClassMetadataFactory->loadMetadata('Concrete\Core\B...') #4 /var/www/clients/client15/web42/web/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(295): Doctrine\Common\Persistence\Mapping\AbstractClassMetadataFactory->getMetadataFor('Concrete\Core\B...') #5 /var/www/clients/client15/web42/web/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1596): Doctrine\ORM\EntityManager->getClassMetadata('Concrete\Core\B...') #6 /var/www/clients/client15/web42/web/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1569): Doctrine\ORM\UnitOfWork->doPersist(Object(Concrete\Core\Block\BlockType\BlockType), Array) #7 /var/www/clients/client15/web42/web/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(624): Doctrine\ORM\UnitOfWork->persist(Object(Concrete\Core\Block\BlockType\BlockType)) #8 /var/www/clients/client15/web42/web/concrete/src/Block/BlockType/BlockType.php(157): Doctrine\ORM\EntityManager->persist(Object(Concrete\Core\Block\BlockType\BlockType)) #9 /var/www/clients/client15/web42/web/concrete/src/Backup/ContentImporter.php(406): Concrete\Core\Block\BlockType\BlockType::installBlockType('core_area_layou...') #10 /var/www/clients/client15/web42/web/concrete/src/Backup/ContentImporter.php(73): Concrete\Core\Backup\ContentImporter->importBlockTypes(Object(SimpleXMLElement)) #11 /var/www/clients/client15/web42/web/concrete/src/Backup/ContentImporter.php(60): Concrete\Core\Backup\ContentImporter->doImport(Object(SimpleXMLElement)) #12 /var/www/clients/client15/web42/web/concrete/src/Package/StartingPointPackage.php(126): Concrete\Core\Backup\ContentImporter->importContentFile('/var/www/client...') #13 [internal function]: Concrete\Core\Package\StartingPointPackage->install_blocktypes() #14 /var/www/clients/client15/web42/web/concrete/controllers/install.php(238): call_user_func(Array) #15 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'install_blockty...') #16 /var/www/clients/client15/web42/web/concrete/src/Controller/AbstractController.php(149): call_user_func_array(Array, Array) #17 /var/www/clients/client15/web42/web/concrete/src/Routing/ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #18 /var/www/clients/client15/web42/web/concrete/src/Routing/Router.php(59): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #19 /var/www/clients/client15/web42/web/concrete/src/Support/Facade/Facade.php(116): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #20 /var/www/clients/client15/web42/web/concrete/src/Application/Application.php(281): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #21 /var/www/clients/client15/web42/web/concrete/src/Application/Application.php(281): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) #22 /var/www/clients/client15/web42/web/concrete/bootstrap/start.php(180): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #23 /var/www/clients/client15/web42/web/concrete/dispatcher.php(36): require('/var/www/client...') #24 /var/www/clients/client15/web42/web/index.php(2): require('/var/www/client...') #25 {main}

 
jwjmurray replied on at Permalink Reply
After a bit more digging it seems it's bombing during the blocktype install - it gets as far as this before throwing the error :-

run_routine/elemental_full/install_blocktypes

Problem with the new elemental theme perhaps?

Jim
mhawke replied on at Permalink Reply
mhawke
I don't have an answer for you but are you using the newest version - 5.7.0.1?
wyso replied on at Permalink Reply
wyso
I do use the 5.7.0.1 version. Here's my error; I reformatted it to make it a bit more easy to read:
#0 /home/u753645484/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'select cParentI...', Array)
#1 /home/u753645484/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(419): Doctrine\DBAL\Connection->executeQuery('select cParentI...', Array)
#2 /home/u753645484/public_html/concrete/src/Database/Connection.php(100): Doctrine\DBAL\Connection->fetchColumn('select cParentI...', Array, 0)
#3 /home/u753645484/public_html/concrete/src/Page/Statistics.php(69): Concrete\Core\Database\Connection->GetOne('select cParentI...', Array)
#4 /home/u753645484/public_html/concrete/src/Page/Page.php(2585): Concrete\Core\Page\Statistics::incrementParents('132')
#5 /home/u753645484/public_html/concrete/src/Page/Single.php(167): Concrete\Core\Page\Page->addStatic(Array)
#6 /home/u753645484/public_html/concrete/src/Backup/ContentImporter.php(161): Concrete\Core\Page\Single::add(Object(SimpleXMLElement), NULL)
#7 /home/u753645484/public_html/concrete/src/Backup/ContentImporter.php(71): Concrete\Core\Backup\ContentImporter->importSinglePageStructure(Object(SimpleXMLElement))
#8 /home/u753645484/public_html/concrete/src/Backup/ContentImporter.php(60): Concrete\Core\Backup\ContentImporter->doImport(Object(SimpleXMLElement))
#9 /home/u753645484/public_html/concrete/src/Package/StartingPointPackage.php(116): Concrete\Core\Backup\ContentImporter->importContentFile('/home/u75364548...')
#10 [internal function]: Concrete\Core\Package\StartingPointPackage->install_required_single_pages()
#11 /home/u753645484/public_html/concrete/controllers/install.php(238): call_user_func(Array)
#12 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'install_require...')
#13 /home/u753645484/public_html/concrete/src/Controller/AbstractController.php(149): call_user_func_array(Array, Array)
#14 /home/u753645484/public_html/concrete/src/Routing/ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array)

Any help appreciated. Congratulations for this new feature of editing as "on fly" - that's what it was really missing. I want to see it in action! :-) Greetings - Andrew.

Edit: same story for the "clean install".
jwjmurray replied on at Permalink Reply
Yes, latest released version direct from the C5 download page. If I get time I may try the latest from Github, for now I've reverted to using the 5.6 series.

I'm thinking bug, primarily because all the pointers I can find seem to be aiming towards a Doctrine definition error - problem is I know precisely zero about Doctrine & haven't really got time to learn right now.

Jim
jwjmurray replied on at Permalink Reply
And just tried again with 5.7.0.3 with no improvement.

Is there any point to continuing to try this, it doesn't look like this bug is getting much traction and I really haven't got time to learn Doctrine just to troubleshoot it.

I *REALLY* don't want to end up putting Wordpress on the server but I'm coming under pressure now from clients and I don't see the sense in investing time/effort into building a full new site on 5.6.x only to have to do it all again for 5.7.x once the bugs get worked out.

Any help anyone- I don't mind getting my hands dirty but I need to know at least what to tinker with!

Jim

Latest error (5.7.0.3) :

#0 /var/www/clients/client15/web43/web/concrete/vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocParser.php(725): Doctrine\Common\Annotations\AnnotationException::semanticalError('The class "Doct...')
#1 /var/www/clients/client15/web43/web/concrete/vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocParser.php(639): Doctrine\Common\Annotations\DocParser->Annotation()
#2 /var/www/clients/client15/web43/web/concrete/vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocParser.php(334): Doctrine\Common\Annotations\DocParser->Annotations()
#3 /var/www/clients/client15/web43/web/concrete/vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/SimpleAnnotationReader.php(67): Doctrine\Common\Annotations\DocParser->parse('/**? * @Entity?...', 'class Concrete\...')
#4 /var/www/clients/client15/web43/web/concrete/vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/CachedReader.php(83): Doctrine\Common\Annotations\SimpleAnnotationReader->getClassAnnotations(Object(ReflectionClass))
#5 /var/www/clients/client15/web43/web/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Driver/AnnotationDriver.php(63): Doctrine\Common\Annotations\CachedReader->getClassAnnotations(Object(ReflectionClass))
#6 /var/www/clients/client15/web43/web/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ClassMetadataFactory.php(117): Doctrine\ORM\Mapping\Driver\AnnotationDriver->loadMetadataForClass('Concrete\Core\F...', Object(Doctrine\ORM\Mapping\ClassMetadata))
#7 /var/www/clients/client15/web43/web/concrete/vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/AbstractClassMetadataFactory.php(318): Doctrine\ORM\Mapping\ClassMetadataFactory->doLoadMetadata(Object(Doctrine\ORM\Mapping\ClassMetadata), NULL, false, Array)
#8 /var/www/clients/client15/web43/web/concrete/vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/AbstractClassMetadataFactory.php(211): Doctrine\Common\Persistence\Mapping\AbstractClassMetadataFactory->loadMetadata('Concrete\Core\F...')
#9 /var/www/clients/client15/web43/web/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(295): Doctrine\Common\Persistence\Mapping\AbstractClassMetadataFactory->getMetadataFor('Concrete\Core\F...')
#10 /var/www/clients/client15/web43/web/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1596): Doctrine\ORM\EntityManager->getClassMetadata('Concrete\Core\F...')
#11 /var/www/clients/client15/web43/web/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1569): Doctrine\ORM\UnitOfWork->doPersist(Object(Concrete\Core\File\Image\Thumbnail\Type\Type), Array)
#12 /var/www/clients/client15/web43/web/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(624): Doctrine\ORM\UnitOfWork->persist(Object(Concrete\Core\File\Image\Thumbnail\Type\Type))
#13 /var/www/clients/client15/web43/web/concrete/src/File/Image/Thumbnail/Type/Type.php(180): Doctrine\ORM\EntityManager->persist(Object(Concrete\Core\File\Image\Thumbnail\Type\Type))
#14 /var/www/clients/client15/web43/web/concrete/src/Backup/ContentImporter.php(643): Concrete\Core\File\Image\Thumbnail\Type\Type->save()
#15 /var/www/clients/client15/web43/web/concrete/src/Backup/ContentImporter.php(83): Concrete\Core\Backup\ContentImporter->importFileImportantThumbnailTypes(Object(SimpleXMLElement))
#16 /var/www/clients/client15/web43/web/concrete/src/Backup/ContentImporter.php(60): Concrete\Core\Backup\ContentImporter->doImport(Object(SimpleXMLElement))
#17 /var/www/clients/client15/web43/web/concrete/src/Package/StartingPointPackage.php(134): Concrete\Core\Backup\ContentImporter->importContentFile('/var/www/client...')
#18 [internal function]: Concrete\Core\Package\StartingPointPackage->install_themes()
#19 /var/www/clients/client15/web43/web/concrete/controllers/install.php(261): call_user_func(Array)
#20 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'install_themes')
#21 /var/www/clients/client15/web43/web/concrete/src/Controller/AbstractController.php(149): call_user_func_array(Array, Array)
#22 /var/www/clients/client15/web43/web/concrete/src/Routing/ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array)
#23 /var/www/clients/client15/web43/web/concrete/src/Routing/Router.php(59): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array)
#24 /var/www/clients/client15/web43/web/concrete/src/Support/Facade/Facade.php(116): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array)
#25 /var/www/clients/client15/web43/web/concrete/src/Application/Application.php(313): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array)
#26 /var/www/clients/client15/web43/web/concrete/src/Application/Application.php(313): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array)
#27 /var/www/clients/client15/web43/web/concrete/bootstrap/start.php(179): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request))
#28 /var/www/clients/client15/web43/web/concrete/dispatcher.php(36): require('/var/www/client...')
#29 /var/www/clients/client15/web43/web/index.php(2): require('/var/www/client...')
#30 {main}
mhawke replied on at Permalink Reply
mhawke
Is changing servers possible? I use SiteGround and have no problems installing any version of 5.7, 5.7Beta though to 5.7.0.3.
jwjmurray replied on at Permalink Reply
No, that's not possible unfortunately. I can make any changes needed to the box it's on, including upgrading PHP versions etc. but it's pointless unless I know where I should be looking.

The error reporting is woeful (yes, I know, that's PHP's fault) and gives no clue as to where I should be looking. I'm not going to randomly go changing things in the hope of hitting on the problem.

I've met or exceeded every system requirement that's been published, the server is well specified and will run 5.6.x happily with no issues.

I can tell it's bombing somewhere during the theme installation but that's all. Other than the stack trace there are no errors at all being logged, making it all but impossible for anyone other than a Concrete 5 dev to find the problem.

Judging from the sheer number of install error posts recently this isn't uncommon and I can see it really becoming a source of serious frustration unless something is done to make the error reporting *much* more useful during the installation phase.

Jim
mkly replied on at Permalink Reply
mkly
@jwjmurray You wouldn't happen to be using PHP 5.6?
jwjmurray replied on at Permalink Reply
Nope, it's 5.3 though I can upgrade if need be (and probably will later this year - one client has a couple compatibility issues I need to fix before I throw the switch).

Jim
mkly replied on at Permalink Reply
mkly
@jwjmurray I wouldn't think about upgrading PHP. I was just ruling a few ideas I had that might be causing this.
andrew replied on at Permalink Reply
andrew
Would you be comfortable granting one of temporary FTP or SSH access? If so, you could email me the information at andrew@concrete5.org? We could take a look. We'd like to get all these straggling installation issues documented or fixed by 5.7.1 (as well as make sure our error reporting is more useful – as you say these stack traces aren't very useful.)
jwjmurray replied on at Permalink Reply
Andrew,

There's no problem arranging FTP access, I'll mail you FTP details shortly. I'll need to check the setup for SSH - we don't normally allow SSH access other than to our own team so there's a few more hoops to jump through to enable that.

Thanks for the interest and for any help!

Jim
wyso replied on at Permalink Reply
wyso
Thank you all for your commitment. Concrete5 team rules!
Pinguinweb replied on at Permalink Reply
Pinguinweb
What was the solution in this case? I have exactly the same problem.
andrew replied on at Permalink Reply
andrew
I just fixed jwmurray's issue on his server. The fix was to disable eAccelerator, which has an (rather poorly documented, but, I guess we can't throw stones) incompatibility with Doctrine's PHP file annotation system.
okapi replied on at Permalink Reply
okapi
These are the errors that i get during the installation process of Concrete5 5.7.0.4, which stops seconds after beginning to create database tables:

#0 /home/.sites/web/concrete57/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(811): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'CREATE TABLE Co...') 
#1 [internal function]: Doctrine\DBAL\Connection->query('CREATE TABLE Co...') 
#2 /home/.sites/web/concrete57/concrete/src/Database/Connection/Connection.php(77): call_user_func_array('parent::query', Array) 
#3 /home/.sites/web/concrete57/concrete/src/Package/Package.php(178): Concrete\Core\Database\Connection\Connection->query('CREATE TABLE Co...') 
#4 /home/.sites/web/concrete57/concrete/src/Package/StartingPointPackage.php(190): Concrete\Core\Package\Package::installDB('/home/.sites/95...') 
#5 [internal function]: Concrete\Core\Package\StartingPointPackage->install_database() 
#6 /home/.sites/web/concrete57/concrete/controllers/install.php(261): call_user_func(Array) 
#7 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'install_databas...') 
#8 /home/.sites/web/concrete57/concrete/src/Controller/AbstractController.php(149): call_user_func_array(Array, Array) 
#9 /home/.sites/web/concrete57/concrete/src/Routing/ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) 
#10 /home/.sites/web/concrete57/concrete/src/Routing/Router.php(59): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) 
#11 /home/.sites/web/concrete57/concrete/src/Support/Facade/Facade.php(116): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) 
#12 /home/.sites/web/concrete57/concrete/src/Application/Application.php(313): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) 
#13 /home/.sites/web/concrete57/concrete/src/Application/Application.php(313): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) 
#14 /home/.sites/web/concrete57/concrete/bootstrap/start.php(179): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request))
andrew replied on at Permalink Best Answer Reply
andrew
FYI – to anyone having this issue, I was able to fix it by disabling eAccelerator, with which our database and Object mapping library, Doctrine ORM, is incompatible.
wyso replied on at Permalink Reply
wyso
This guy rocks...! He's got correct answers in almost every case! :P I didn't check the solution yet, though, because I already got rid of my free PHP 5.4 server... BIG UP for Andrew!! :) Oh, and his name rocks too!
Greetings - Andrew :P :)
Edit: "CTO and core team leader of concrete5." - this explains a bit...! ;D
jwjmurray replied on at Permalink Reply
I would like to take the time to publicly thank Andrew for his help and assistance in resolving what was a very awkward error. The level of help provided went far beyond anything anyone could expect from an open-source project and exceeded the support available for many paid-for applications considerably!

Thank you again - I now have a happy customer and an understanding of where to look if I should see this problem again!

Thanks,

Jim
andrew replied on at Permalink Reply
andrew
Thanks Jim, that's great to hear. As you might imagine we are really uncovering certain installation issues that we haven't seen before ;) so it's definitely on our mind to fix them as quickly as we can. Glad to hear things are back on track.
okapi replied on at Permalink Reply
okapi
Sorry for being so stupid... but what does that mean, what do i have to do? I'm on a shared host, and i don't know whether eAccelerator is installed or not. Php-info.php doesn't tell.
Will concrete5 5.7 never install on a server with eAccelerator enabled? Or will there be a version in the future that will install anyway?
jwjmurray replied on at Permalink Reply
To pass on what Andrew told me :

Add the following lines the the .htaccess file

php_flag eaccelerator.enable 0
php_flag eaccelerator.optimizer 0

That will disable eaccelerator as long as your host supports the use of the directive in an .htaccess file (you'll need to confirm that with your host - my advice would be to try it and then contact them if it doesn't work)

If your problem is the same as the one I had that should fix it.

HTH,

Jim
wyso replied on at Permalink Reply
wyso
I recommend the phrase "disable eacellerator" via Google! ;-) (it will show exactly the same solution btw, + some more)
Greetings
okapi replied on at Permalink Reply
okapi
Thank you, Jim. But when i do so, i immdiately get an Internal Server Error.
taddeus replied on at Permalink Reply
taddeus
Hi to all,
i'm trying to install concrete 5.7.0.4 on a remote linux server with eaccelerator library not installed, but i'm getting this message during DB's tables creation.
Can anyone help me?

#0 /home/mhd-01/www.mysite.com/htdocs/newindex/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(811): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'CREATE TABLE Co...') 
#1 [internal function]: Doctrine\DBAL\Connection->query('CREATE TABLE Co...') 
#2 /home/mhd-01/www.mysite.com/htdocs/newindex/concrete/src/Database/Connection/Connection.php(77): call_user_func_array('parent::query', Array) 
#3 /home/mhd-01/www.mysite.com/htdocs/newindex/concrete/src/Package/Package.php(178): Concrete\Core\Database\Connection\Connection->query('CREATE TABLE Co...') 
#4 /home/mhd-01/www.mysite.com/htdocs/newindex/concrete/src/Package/StartingPointPackage.php(190): Concrete\Core\Package\Package::installDB('/home/mhd-01/ww...') 
#5 [internal function]: Concrete\Core\Package\StartingPointPackage->install_database() 
#6 /home/mhd-01/www.mysite.com/htdocs/newindex/concrete/controllers/install.php(261): call_user_func(Array) 
#7 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'install_databas...') 
#8 /home/mhd-01/www.mysite.com/htdocs/newindex/concrete/src/Controller/AbstractController.php(149): call_user_func_array(Array, Array) 
#9 /home/mhd-01/www.mysite.com/htdocs/newindex/concrete/src/Routing/ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) 
#10 /home/mhd-01/www.mysite.com/htdocs/newindex/concrete/src/Routing/Router.php(59): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) 
#11 /home/mhd-01/www.mysite.com/htdocs/newindex/concrete/src/Support/Facade/Facade.php(116): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) 
#12 /home/mhd-01/www.mysite.com/htdocs/newindex/concrete/src/Application/Application.php(313): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) 
#13 /home/mhd-01/www.mysite.com/htdocs/newindex/concrete/src/Application/Application.php(313): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) 
#14 /home/mhd-01/www.mysite.com/htdocs/newindex/concrete/bootstrap/start.php(179): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request))
okapi replied on at Permalink Reply
okapi
Same here. Still can't install Concrete5 5.7.0.4.
andrew replied on at Permalink Reply
andrew
Can you grant SFTP and shell access for a temporary time to your server? If so, you can PM me the details and I can have someone take a look.
okapi replied on at Permalink Reply
okapi
Hopefully taddeus can, i’m on a shared server with only web root access, if that helps? i can also provide access to php-info if this is of interest…
taddeus replied on at Permalink Reply
taddeus
Unfortunately, i'm on a shared server. I don't have shell access.
I can configure only these php parameters (switch on/off):

- allow url fopen
- curl
- sqlite
- mcrypt

Thank you.
JohntheFish replied on at Permalink Reply
JohntheFish
I just tried to install on windows XP (yes, ancient) WAMP. Get the same error, with or without sample content. eaccelerator.enable = 0 etc makes no difference.

( i don't thin eAccelerator is installed anyway)
JohntheFish replied on at Permalink Reply
JohntheFish
Commenting out a line in \concrete\src\Package\StartingPointPackage.php enabled a successful install. My mySQL ability doesn't go as far as understanding what it does. But please no-one take my word for that and don't risk this hack on a production server.

protected function indexAdditionalDatabaseFields() {
      $db = Loader::db();
        $db->Execute('alter table PagePaths add index (`cPath` (255))');
        $db->Execute('alter table Groups add index (`gPath` (255))');
        $db->Execute('CREATE INDEX ipFrom ON SignupRequests (ipFrom(32))');
        $db->Execute('CREATE UNIQUE INDEX ips ON UserBannedIPs (ipFrom(32), ipTo(32))');
        /*$db->Execute(
            'alter table QueueMessages add FOREIGN KEY (`queue_id`) REFERENCES `Queues` (`queue_id`) ON DELETE CASCADE ON UPDATE CASCADE'
        );*/
    }
JohntheFish replied on at Permalink Reply
JohntheFish
Now trying to apply that missing SQL through phpMyAdmin, get a SQL error, so maybe that is what lies behind this.
alter table QueueMessages add FOREIGN KEY (`queue_id`) REFERENCES `Queues` (`queue_id`) ON DELETE CASCADE ON UPDATE CASCADE
MySQL said: Documentation
#1005 - Can't create table 'c57devel.#sql-88c_115' (errno: 150)
goutnet replied on at Permalink Reply
Just my two cents here, can you check your MySQL version (must be up to 5.2 I think to take this kind of request),

and what is the table engine for that table ? (MyISAM just ignores foreign keys constraints, so should be Innodb, but then some more info must be available in the innodb log).
JohntheFish replied on at Permalink Reply
JohntheFish
mysql 5.5.10
Table types are all InnoDB
okapi replied on at Permalink Reply
okapi
MyISAM here and MySql 5.5.
andrew replied on at Permalink Reply
andrew
If you try and apply the index again, and then type this query in:

SHOW ENGINE INNODB STATUS


Do you get any more helpful error messages?
JohntheFish replied on at Permalink Reply
JohntheFish
=====================================
141016 18:53:37 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 28 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 2390 1_second, 2390 sleeps, 224 10_second, 196 background, 196 flush
srv_master_thread log flush and writes: 2448
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 384, signal count 389
Mutex spin waits 411, rounds 3816, OS waits 102
RW-shared spins 245, rounds 7350, OS waits 245
mkly replied on at Permalink Reply
mkly
@JohnTheFish Can you run these MySQL Commands?
show columns from Queues;
show columns from QueueMessages;

show table status where Name LIKE 'Queues' OR Name LIKE 'QueueMessages';

I almost wonder if this has something to do with the database not being dropped fully and then recreated? Is this an upgrade and not fresh install?
JohntheFish replied on at Permalink Reply
JohntheFish
goutnet replied on at Permalink Reply
Weird, even though the query failed, the foreign key is still there.

Sounds like we are trying to create a fk that already is here in the first place, was it a clean install?
JohntheFish replied on at Permalink Reply
JohntheFish
The install had failed multiple times, as far as I am aware with exactly the same error. After each install failure I dropped all the tables (or the c5 installer would have complained).

If the error was caused because the key already exists, then it must have been created by one of the prior failed installs and then not been cleared out when I dropped all the tables, so causing subsequent failures. Maybe the fix to the installer would be to either check for the existence of the foreign key before creating it, or delete it before creating it. Or maybe this is a false lead and the statement will continue to fail anyway.
JohntheFish replied on at Permalink Reply
JohntheFish
A completely freshly created database, first attempt to install, exactly the same issue. StartingPointPackage.php(211).
JohntheFish replied on at Permalink Reply
JohntheFish
Diagnostics
=====================================
141017  8:59:49 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 3 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 2724 1_second, 2724 sleeps, 255 10_second, 223 background, 223 flush
srv_master_thread log flush and writes: 2785
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 411, signal count 416
Mutex spin waits 427, rounds 3963, OS waits 105
RW-shared spins 269, rounds 8070, OS waits 268


http://awesomescreenshot.com/0a23odike7...
http://awesomescreenshot.com/0bd3odiv8a...
http://awesomescreenshot.com/0723odj83a...
andrew replied on at Permalink Reply
andrew
If you run

"show variables like '%lower%'"

from within MySQL or phpMyAdmin, what's the value of "lower_case_table_names" ? If it's set to 0 you might have a problem:

0 = "Table and database names are stored on disk using the lettercase specified in the CREATE TABLE or CREATE DATABASE statement. Name comparisons are case sensitive. You should not set this variable to 0 if you are running MySQL on a system that has case-insensitive file names (such as Windows or Mac OS X). If you force this variable to 0 with --lower-case-table-names=0 on a case-insensitive file system and access MyISAM tablenames using different lettercases, index corruption may result."
JohntheFish replied on at Permalink Reply
JohntheFish
Yes, I have had lower_case_table_names=0 set on my Windows system for the last few years, so as to keep case of table names portable with my Linux systems and to ensure that any code I write uses the exact table name, not a case invariant corruption of it.

My interpretation is that it would only cause the issues mentioned if any code fails to respect the case of table names. Respect the case and everything is compatible with =0. As concrete5 is respecting table name case (or it would fail under Linux) and these were fresh installs, is that really the issue?
SmoothPixel replied on at Permalink Reply
SmoothPixel
TL;DR: for MySQL on Windows try setting lower_case_table_names=2.

I have had problems with MySQL lower_case_table_names since first using C5. Like JohntheFish, my workaround has been to set lower_case_table_names=0.

Installing Concrete5.8 for the first time, I encountered this error:

Unable to install database: An exception occurred while executing 'ALTER TABLE QueueMessages ADD CONSTRAINT FK_7C04D76477B5BAE FOREIGN KEY (queue_id) REFERENCES Queues (queue_id) ON UPDATE CASCADE ON DELETE CASCADE': SQLSTATE[HY000]: General error: 1005 Can't create table 'TestDB.#sql-778_18' (errno: 150).

I resolved the issue by setting lower_case_table_names=2. I had assumed that 0 or 1 were the only acceptable values, but I found some advice in MySQL Workbench saying:

"Should be set to 2 if you are using a case-insensitive file system."

Apparently, 2 is the default setting for Macs (also a case-insensitive file system), so I'm guessing it's the best bet for Windows too.

Win7, IIS7.5, PHP7.1.6, MySQL 5.5.17.
shaolinsteyr1 replied on at Permalink Reply
Hi to all,

same here with 5.7.1, php 5.5, MyISAM. I tried to install concrete5 in a subdirectory on my hosted webspace with e new created mysql db.
Deaktivating eaccelerator in .htaccess leads to internal server error.
is "lower_case_table_names=0" the problem as mentioned in a post?

here is my error-output:
An exception occurred while executing 'CREATE TABLE Config (configNamespace VARCHAR(255) DEFAULT '' NOT NULL, configGroup VARCHAR(255) NOT NULL, configItem VARCHAR(255) NOT NULL, configValue LONGTEXT DEFAULT NULL, INDEX configGroup (configGroup), PRIMARY KEY(configNamespace, configGroup, configItem)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes.
Trace:
#0 /home/.sites/29/site1794/web/WebsiteNeu/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(811): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'CREATE TABLE Co...') #1 [internal function]: Doctrine\DBAL\Connection->query('CREATE TABLE Co...') #2 /home/.sites/29/site1794/web/WebsiteNeu/concrete/src/Database/Connection/Connection.php(77): call_user_func_array('parent::query', Array) #3 /home/.sites/29/site1794/web/WebsiteNeu/concrete/src/Package/Package.php(182): Concrete\Core\Database\Connection\Connection->query('CREATE TABLE Co...') #4 /home/.sites/29/site1794/web/WebsiteNeu/concrete/src/Package/StartingPointPackage.php(190): Concrete\Core\Package\Package::installDB('/home/.sites/29...') #5 [internal function]: Concrete\Core\Package\StartingPointPackage->install_database() #6 /home/.sites/29/site1794/web/WebsiteNeu/concrete/controllers/install.php(272): call_user_func(Array) #7 [internal function]: Concrete\Controller\Install->run_routine('elemental_blank', 'install_databas...') #8 /home/.sites/29/site1794/web/WebsiteNeu/concrete/src/Controller/AbstractController.php(149): call_user_func_array(Array, Array) #9 /home/.sites/29/site1794/web/WebsiteNeu/concrete/src/Routing/ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #10 /home/.sites/29/site1794/web/WebsiteNeu/concrete/src/Routing/Router.php(59): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #11 /home/.sites/29/site1794/web/WebsiteNeu/concrete/src/Support/Facade/Facade.php(116): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #12 /home/.sites/29/site1794/web/WebsiteNeu/concrete/src/Application/Application.php(317): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #13 /home/.sites/29/site1794/web/WebsiteNeu/concrete/src/Application/Application.php(317): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) #14 /home/.sites/29/site1794/web/WebsiteNeu/concrete/bootstrap/start.php(196): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #15 /home/.sites/29/site1794/web/WebsiteNeu/concrete/dispatcher.php(36): require('/home/.sites/29...') #16 /home/.sites/29/site1794/web/WebsiteNeu/index.php(2): require('/home/.sites/29...') #17 {main}


thanks to all