search

zikula-modules / Pages

Simple HTML Pages
https://ziku.la/
18 stars 4 forks source link

can not install 3.0.1 under zk 1.4.5 #63

Closed rallek closed 4 years ago

rallek commented 7 years ago

Because I do have some trouble ( #62 ) with Pages I want to be shure There is nothing left, what I do wrong. Theme is cleared as well.

I deleted Pages and want to reinstall it. But that leades to the following stack trace. No idea what I did wrong.

[1] Doctrine\DBAL\Exception\NotNullConstraintViolationException: An exception occurred while executing 'INSERT INTO pages (title, metadescription, metakeywords, urltitle, content, counter, displaywrapper, displaytitle, displaycreated, displayupdated, displaytextinfo, displayprint, language, cr_date, lu_date, obj_status, cr_uid, lu_uid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["Welcome to Pages content manager", "", "", "welcome-to-pages-content-manager", "This is a demonstration page. You can use Pages to create simple static content pages. It is excellent if you only need basic html for your pages. You can also utilize the Scribite module for WYSIWYG content creation. It is well suited for informational articles, documents and other \"long term\" type content items.<br \/><br \/>Pages is a hookable module which allows you to hook EZComments or other hook providers to extend the capabilities of your module.", 0, 1, 1, 1, 1, 1, 1, "de", null, null, "A", null, null]:

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'cr_date' cannot be null
    at n/a
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 112

    at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception occurred while executing 'INSERT INTO pages (title, metadescription, metakeywords, urltitle, content, counter, displaywrapper, displaytitle, displaycreated, displayupdated, displaytextinfo, displayprint, language, cr_date, lu_date, obj_status, cr_uid, lu_uid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["Welcome to Pages content manager", "", "", "welcome-to-pages-content-manager", "This is a demonstration page. You can use Pages to create simple static content pages. It is excellent if you only need basic html for your pages. You can also utilize the Scribite module for WYSIWYG content creation. It is well suited for informational articles, documents and other \"long term\" type content items.<br \/><br \/>Pages is a hookable module which allows you to hook EZComments or other hook providers to extend the capabilities of your module.", 0, 1, 1, 1, 1, 1, 1, "de", null, null, "A", null, null]:

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'cr_date' cannot be null', object(PDOException))
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 128

    at Doctrine\DBAL\DBALException::driverExceptionDuringQuery(object(Driver), object(PDOException), 'INSERT INTO pages (title, metadescription, metakeywords, urltitle, content, counter, displaywrapper, displaytitle, displaycreated, displayupdated, displaytextinfo, displayprint, language, cr_date, lu_date, obj_status, cr_uid, lu_uid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)', array('Welcome to Pages content manager', '', '', 'welcome-to-pages-content-manager', 'This is a demonstration page. You can use Pages to create simple static content pages. It is excellent if you only need basic html for your pages. You can also utilize the Scribite module for WYSIWYG content creation. It is well suited for informational articles, documents and other "long term" type content items.<br /><br />Pages is a hookable module which allows you to hook EZComments or other hook providers to extend the capabilities of your module.', '0', '1', '1', '1', '1', '1', '1', 'de', null, null, 'A', null, null))
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php line 178

    at Doctrine\DBAL\Statement->execute()
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php line 281

    at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts()
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php line 1014

    at Doctrine\ORM\UnitOfWork->executeInserts(object(ClassMetadata))
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php line 378

    at Doctrine\ORM\UnitOfWork->commit(null)
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php line 356

    at Doctrine\ORM\EntityManager->flush()
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/modules/Pages/PagesModuleInstaller.php line 250

    at Zikula\PagesModule\PagesModuleInstaller->createIntroPage()
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/modules/Pages/PagesModuleInstaller.php line 92

    at Zikula\PagesModule\PagesModuleInstaller->install()
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/system/ExtensionsModule/Helper/ExtensionHelper.php line 84

    at Zikula\ExtensionsModule\Helper\ExtensionHelper->install(object(ExtensionEntity))
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/system/ExtensionsModule/Controller/ModuleController.php line 329

    at Zikula\ExtensionsModule\Controller\ModuleController->installAction(object(Zikula_Request_Http), object(ExtensionEntity))
        in  line 

    at call_user_func_array(array(object(ModuleController), 'installAction'), array(object(Zikula_Request_Http), object(ExtensionEntity)))
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 144

    at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Zikula_Request_Http), '1')
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 64

    at Symfony\Component\HttpKernel\HttpKernel->handle(object(Zikula_Request_Http), '1', true)
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/DependencyInjection/ContainerAwareHttpKernel.php line 69

    at Symfony\Component\HttpKernel\DependencyInjection\ContainerAwareHttpKernel->handle(object(Zikula_Request_Http), '1', true)
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php line 185

    at Symfony\Component\HttpKernel\Kernel->handle(object(Zikula_Request_Http))
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/index.php line 23

[2] Doctrine\DBAL\Driver\PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'cr_date' cannot be null
    at n/a
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php line 93

    at Doctrine\DBAL\Driver\PDOStatement->execute(null)
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php line 168

    at Doctrine\DBAL\Statement->execute()
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php line 281

    at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts()
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php line 1014

    at Doctrine\ORM\UnitOfWork->executeInserts(object(ClassMetadata))
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php line 378

    at Doctrine\ORM\UnitOfWork->commit(null)
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php line 356

    at Doctrine\ORM\EntityManager->flush()
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/modules/Pages/PagesModuleInstaller.php line 250

    at Zikula\PagesModule\PagesModuleInstaller->createIntroPage()
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/modules/Pages/PagesModuleInstaller.php line 92

    at Zikula\PagesModule\PagesModuleInstaller->install()
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/system/ExtensionsModule/Helper/ExtensionHelper.php line 84

    at Zikula\ExtensionsModule\Helper\ExtensionHelper->install(object(ExtensionEntity))
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/system/ExtensionsModule/Controller/ModuleController.php line 329

    at Zikula\ExtensionsModule\Controller\ModuleController->installAction(object(Zikula_Request_Http), object(ExtensionEntity))
        in  line 

    at call_user_func_array(array(object(ModuleController), 'installAction'), array(object(Zikula_Request_Http), object(ExtensionEntity)))
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 144

    at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Zikula_Request_Http), '1')
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 64

    at Symfony\Component\HttpKernel\HttpKernel->handle(object(Zikula_Request_Http), '1', true)
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/DependencyInjection/ContainerAwareHttpKernel.php line 69

    at Symfony\Component\HttpKernel\DependencyInjection\ContainerAwareHttpKernel->handle(object(Zikula_Request_Http), '1', true)
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php line 185

    at Symfony\Component\HttpKernel\Kernel->handle(object(Zikula_Request_Http))
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/index.php line 23

[3] PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'cr_date' cannot be null
    at n/a
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php line 91

    at PDOStatement->execute(null)
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php line 91

    at Doctrine\DBAL\Driver\PDOStatement->execute(null)
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php line 168

    at Doctrine\DBAL\Statement->execute()
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php line 281

    at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts()
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php line 1014

    at Doctrine\ORM\UnitOfWork->executeInserts(object(ClassMetadata))
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php line 378

    at Doctrine\ORM\UnitOfWork->commit(null)
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php line 356

    at Doctrine\ORM\EntityManager->flush()
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/modules/Pages/PagesModuleInstaller.php line 250

    at Zikula\PagesModule\PagesModuleInstaller->createIntroPage()
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/modules/Pages/PagesModuleInstaller.php line 92

    at Zikula\PagesModule\PagesModuleInstaller->install()
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/system/ExtensionsModule/Helper/ExtensionHelper.php line 84

    at Zikula\ExtensionsModule\Helper\ExtensionHelper->install(object(ExtensionEntity))
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/system/ExtensionsModule/Controller/ModuleController.php line 329

    at Zikula\ExtensionsModule\Controller\ModuleController->installAction(object(Zikula_Request_Http), object(ExtensionEntity))
        in  line 

    at call_user_func_array(array(object(ModuleController), 'installAction'), array(object(Zikula_Request_Http), object(ExtensionEntity)))
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 144

    at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Zikula_Request_Http), '1')
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 64

    at Symfony\Component\HttpKernel\HttpKernel->handle(object(Zikula_Request_Http), '1', true)
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/DependencyInjection/ContainerAwareHttpKernel.php line 69

    at Symfony\Component\HttpKernel\DependencyInjection\ContainerAwareHttpKernel->handle(object(Zikula_Request_Http), '1', true)
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php line 185

    at Symfony\Component\HttpKernel\Kernel->handle(object(Zikula_Request_Http))
        in /home/www/www.oldtimer-ig-osnabrueck.de/test/Zikula_Core-1.4.5/index.php line 23
rallek commented 7 years ago

I do not know what is wrong here. What I did as a work around: I set the in the database the state for pages to 3. The pages tables have been created. I put back my backup to these tables. At the end I recreated the routes. Now it is working again.

No idea what is going wrong with my installation. I leave this open until someone is saying his pages installation is running fine under zk1.4.5

Guite commented 4 years ago

Closing since this issue is outdated and Pages 4.0.0 provides a complete rewrite.