Forums / Install & configuration / Missing root node Cleandata.sql

Missing root node Cleandata.sql

Author Message

H-Works Agency

Tuesday 21 June 2005 5:46:43 am

WHy my root node is missing when installing manually kernelschema + cleandata.sql in my mysql database ?

Do i have to set it manually ? If yes, how can i do that ?

Please help - Thanx

EZP is Great

Daniel Beyer

Tuesday 21 June 2005 7:22:47 am

I suggest you initialise your database with the setup-wizard that comes with eZ publish and that is executed the first time you access a new eZ publish installation (or if you set "CheckValidity=true" in section "[SiteAccessSettings]" of site.ini). If you don't do that and initalise your database with the two .sql files you used, the locale of your objects in the db might be wrong. The setup-wizzard look which languages you want to use and set the correct values in the database. You can do the same thing by hand. Search for "eng-GB" in your database in change it to your locale "ger-DE" or "ita-IT" or whatever contentobjectlocale you use. This is most likly the problem you have with your database causing the problem you have no root-node.

As I said: I recommend the setup-wizard to initially setup a new eZ publish installation!

To check if this is really the problem without changing anything in the database, add this to your /settings/override/site.ini:

[RegionalSettings]
ContentObjectLocale=eng-GB

If you now have a root-node you definitely located your problem (wrong locale in your database).

Daniel Beyer
_________________________________
YMC AG
Kreuzlingen, Switzerland
web: www.ymc.ch
____________________________________

H-Works Agency

Wednesday 22 June 2005 4:55:52 am

You are the best ! Thanx a lot, was a very clear response. You were right it was a locale problem.

I tried to use the wizard install but i had an error message in ez..collection.php

Well thanx a lot as now i can set up my sites by hands.

EZP is Great

Ɓukasz Serwatka

Wednesday 22 June 2005 6:01:25 am

Hi Martin,

I suppouse that you have read this article, but if not please look at:
http://ez.no/ez_publish/documentation/installation/manual_installation/manual_configuration_of_ez_publish

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog