pages can not be installed for Zikula 1.4.2

[rallek]

I tried master and v3.01 as well. In both cases I do get the following error:

Oops! An Error Occurred
The server returned a "500 Internal Server Error".
Something is broken. Please let us know what you were doing when this error occurred. We will fix it as soon as possible. Sorry for any inconvenience caused.

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, "en", null, null, "A", null, null]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'cr_date' cannot be null

I do have a german language pack installed for zikula (uncomplete). I switched off the language settings and choose english as standard. No change.

It seem to be similar to #50

It is a fresh install of zikula 1.4.2 plus scribite and content.

[pheski]

I can confirm: cannot install (on a fresh Zikula 1.4.2) Pages with master, 3.0.0 and cannot install, with the following error message:

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, "en", null, null, "A", null, null]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'cr_date' cannot be null

[Guite]

Which MySQL version do you use?

[pheski]

5.6.25 based on a SQL select version () query.

Would/could this be related to InnoDB vs MyISAM? My host currently defaults to InnoDB which is what I am using, though I have the options of using MyISAM. The documentation in 1.4.2 does not address this that I can see.

Peter

On 2016.05.30, at 2:08 AM, Axel Guckelsberger notifications@github.com wrote:

Which MySQL version do you use?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/zikula-modules/Pages/issues/56#issuecomment-222417991, or mute the thread https://github.com/notifications/unsubscribe/ABFBgdLxEGcd1JPyonwv7VVZ9Kv5hwC7ks5qGn7GgaJpZM4IOcEY.

[Kaik]

I have recently played with Timestampable and other things in Gedmo and as I can see there is no bootstrap.php file in both Pages and Dizkus (Tree) and I bet this null error is due to missing bootstarp.php file. ... RTFM https://github.com/zikula/core/blob/1.4/src/docs/Core-1.x/Doctrine/standardfields.rst#bootstrapphp-file

[detlefmue]

I get similar error message like @pheski but not the same:

Schema-Tool failed with Error 'An exception occurred while executing 'CREATE TABLE pages (pageid INT AUTO_INCREMENT NOT NULL,  ... and more
Initialization of ZikulaPagesModule failed!

Zikula - 1.4.3 Pages - 3.0.1

Question: Where must Pages be located? [A] /modules/Pages or [B] /modules/zikula/pages-module

Would be nice if someone can help. I want to upgrade a running page, adding discussion via Dizkus. So I need a running 1.4.x system.

[detlefmue]

Tested to delete the existing tables pages and pages_category.

Now I get this error:

Oops! An Error Occurred The server returned a "500 Internal Server Error" 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

[nmpetkov]

I tested Pages (current state from master branch), with fresh install of Zikula 1.4.3. I obtained same error, and obviously it is because it is not given data for "cr_date" field. So, I commented line: $this->createIntroPage(); In file PagesModuleInstaller.php.

Then module install in proper way (without intro page), and works at all (create page, view page and other).

[craigh]

and works at all

do you mean that it DOES work or DOES NOT work? (I think something lost in translation here)

[nmpetkov]

Sorry for misunderstanding - "at all" here means "works for things I tested, but I did't tested all features in the module".

[detlefmue]

Changed the Pages files from 3.0.1 to the lastest master-branch und commented the same line in PagesModulInstaller.php as mentioned above ..

Now I get this error ... Class 'Zikula\PagesModule\Entity\CategoryEntity' does not exist Initialization of ZikulaPagesModule failed!

[nmpetkov]

@detlefmue try to delete 2 tables from unsuccessful installation (pages and pages_categories) before to install again, and manually remove all other traces from pages in hooks zikula tables.

[nmpetkov]

Also empty /app/cache directory.

[detlefmue]

Tried all, but it doesn't work, same error message again.

[detlefmue]

Tried once more on a total clean Zikula 1.4.3 .. regarding the change by @nmpetkov .

Get the same error message ..

Class 'Zikula\PagesModule\Entity\CategoryEntity' does not exist Initialization of ZikulaPagesModule failed! :(

[nmpetkov]

@detlefmue Some more info: At the moment I can not install again Zikula, but I uninstalled module Page - it was without propblems. Then I checked - no traces from pages in database (pages and pages_category tables was deleted, in hook tables no records with pages connection. Then I installed Pages - no errors, empty table.

Once again: Zikula 1.4.3 Pages - current state from Github. One change (see picture below):

I can suggest to change to debug mode, and to try again - to provide full trace of the error you obtained. To change to debug mode, open file: app/config/custom_parameters.yml and change debug: true

[detlefmue]

@nmpetkov Done it. But I get the same error message - not a word more.

[nmpetkov]

BTW - your error seems is connected with pages category table. I don't know what this table doing here - it is new to this release in Pages module, In my Zikula 1.3 sites it is missing.

[nmpetkov]

@detlefmue About debug mode: before editing app/config/custom_parameters.yml, you have to change read only attributes to gain write access.

[detlefmue]

This category table is a mystery to me too. Zikula has a category system and the pages module uses it. Don't know why this table is there.

I got the file custom_parameters.ymledited without problems.

[craigh]

@nmpetkov @detlefmue please test with Core-1.4.4

[craigh]

also @Kaik @rallek

please use the latest build

https://github.com/zikula-modules/Pages/archive/master.zip

[craigh]

and @pheski

[Guite]

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