Issues from a default installation

[slightlychilled]

On a default installation I get a failure of

Security Error
The requested address was not found on this server.

Request blackholed due to "csrf" violation.

and then when trying to publish all nodes to the added site we have thew following error:

Database Error
Error: SQLSTATE[HY000]: General error: 1364 Field 'created' doesn't have a default value

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace
CORE/Cake/Model/Datasource/DboSource.php line 2923 → PDOStatement->execute()
CORE/Cake/Model/Model.php line 2014 → DboSource->insertMulti(SitesNode, array, array)
CORE/Cake/Model/Model.php line 1845 → Model->_saveMulti(array, string, Mysql)
CORE/Cake/Model/Model.php line 2238 → Model->save(array, array)
CORE/Cake/Model/Model.php line 2169 → Model->saveMany(array, array)
APP/Plugin/Sites/Model/Site.php line 91 → Model->saveAll(array)
APP/Plugin/Sites/Controller/SitesController.php line 131 → Site->publish_all(string, Node)
[internal function] → SitesController->admin_publish_nodes(string)
CORE/Cake/Controller/Controller.php line 490 → ReflectionMethod->invokeArgs(SitesController, array)
CORE/Cake/Routing/Dispatcher.php line 185 → Controller->invokeAction(CakeRequest)
CORE/Cake/Routing/Dispatcher.php line 160 → Dispatcher->_invoke(SitesController, CakeRequest, CakeResponse)
APP/webroot/index.php line 96 → Dispatcher->dispatch(CakeRequest, CakeResponse)

[slightlychilled]

Additionally even though a 'theme' exists in the Themes list I am unable to 'publish' it and the site set as a default does not pull in the theme.

Subsequently, when adding a second domain this one pulls in the theme even though it is not active.

[slightlychilled]

Publish all blocks generates this error:

Database Error
Error: SQLSTATE[HY000]: General error: 1364 Field 'title' doesn't have a default value

SQL Query: INSERT INTO clean.blocks (updated, created, weight) VALUES ('2014-03-26 19:08:12', '2014-03-26 19:08:12', 1)

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace
CORE/Cake/Model/Datasource/DboSource.php line 458 → PDOStatement->execute(array)
CORE/Cake/Model/Datasource/DboSource.php line 424 → DboSource->_execute(string, array)
CORE/Cake/Model/Datasource/DboSource.php line 1004 → DboSource->execute(string)
CORE/Cake/Model/Model.php line 1832 → DboSource->create(Block, array, array)
CORE/Cake/Model/Model.php line 2331 → Model->save(array, array)
CORE/Cake/Model/Model.php line 2176 → Model->saveAssociated(array, array)
APP/Plugin/Sites/Model/Site.php line 91 → Model->saveAll(array)
APP/Plugin/Sites/Controller/SitesController.php line 144 → Site->publish_all(string, Block)
[internal function] → SitesController->admin_publish_blocks(string)
CORE/Cake/Controller/Controller.php line 490 → ReflectionMethod->invokeArgs(SitesController, array)
CORE/Cake/Routing/Dispatcher.php line 185 → Controller->invokeAction(CakeRequest)
CORE/Cake/Routing/Dispatcher.php line 160 → Dispatcher->_invoke(SitesController, CakeRequest, CakeResponse)
APP/webroot/index.php line 96 → Dispatcher->dispatch(CakeRequest, CakeResponse)

[slightlychilled]

publish all nodes generates this error

Database Error
Error: SQLSTATE[HY000]: General error: 1364 Field 'created' doesn't have a default value

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace
CORE/Cake/Model/Datasource/DboSource.php line 2923 → PDOStatement->execute()
CORE/Cake/Model/Model.php line 2014 → DboSource->insertMulti(SitesNode, array, array)
CORE/Cake/Model/Model.php line 1845 → Model->_saveMulti(array, string, Mysql)
CORE/Cake/Model/Model.php line 2238 → Model->save(array, array)
CORE/Cake/Model/Model.php line 2169 → Model->saveMany(array, array)
APP/Plugin/Sites/Model/Site.php line 91 → Model->saveAll(array)
APP/Plugin/Sites/Controller/SitesController.php line 131 → Site->publish_all(string, Node)
[internal function] → SitesController->admin_publish_nodes(string)
CORE/Cake/Controller/Controller.php line 490 → ReflectionMethod->invokeArgs(SitesController, array)
CORE/Cake/Routing/Dispatcher.php line 185 → Controller->invokeAction(CakeRequest)
CORE/Cake/Routing/Dispatcher.php line 160 → Dispatcher->_invoke(SitesController, CakeRequest, CakeResponse)
APP/webroot/index.php line 96 → Dispatcher->dispatch(CakeRequest, CakeResponse)

[slightlychilled]

OK, so have discovered it is the same issue as I was having with croogo 1.5.6 where fields did not have default values set in the database.. However, when I now publish nodes to a site I am getting duplicate content.

[rchavik]

Please see if this workaround can solve your problem