Database error while creating a site from template

[dwenzel]

Hi @Oktopuce

I just started to evaluate your extension:

• TYPO3 9.5.14
• PHP 7.3
• installed it via composer
• did a typo3cms database:updateschema
• emptied all caches
• created a simple page tree within an existing root. All page in this tree are set to hidden
• configured the extension settings (basic.commonMountPointUid = 0,basic.modelsPid = 57, basic.sitesPid = 1)
• started the wizard on page id 1
• entered a site name on page Mandstory informations
• chose some values for name and folder
• set group prefix and base folder name on page Optional Information
• hit the next button

Instead of displaying the next wizard page an error message was displayed

An exception occurred while executing 'UPDATE pages SET title = ?, hidden = ? WHERE uid = ?' with params ["Joh foo", false, 60]: Incorrect integer value: '' for column db.pages.hidden at row 1

It seems the query is invalid. (boolean instead of integer)

Do you have any suggestions?

[Oktopuce]

Hi Dirk,

Thanks for the feedback.
I couldn't reproduce the issue but can you try to change this line in file site_generator/Classes/Wizard/StateUpdateHomePage.php

from this :

$this->updateHomePage($context->getSiteData(), (bool)$settings['siteGenerator']['wizard']['hideHomePage']);

to this :

$this->updateHomePage($context->getSiteData(), (int)$settings['siteGenerator']['wizard']['hideHomePage']);

and tell me if it works.

I think you have a database configuration less permissive than mine.

Thx,
Florian

[Oktopuce]

Bug fix with version 1.1.2

[dwenzel]

Merci beaucoup!