trouble to access my site after upgrading to 3.8.0

Thursday 26 October 2006 5:36:44 am

Hi,

I have just upgraded from 3.7.9 to 3.8.0 and I have a small trouble with the URI.
With ezp 3.7 and an URI like:

www.linuxorable.fr/ez_publish

the system went directly to:

www.linuxorable.fr/ez_publish/index.php/linuxorable

Now, with ezp 3.8.0 with www.linuxorable.fr/ez_publish the system goes directly to:

kernel::50
* No database connection could be made, the system might not behave properly.

Is there a file I forgot to configure correctly ?

I set a virtualhost to remove index.php from URI so now I need to type:
www.linuxorable.fr/ez_publish/linuxorable
instead of
www.linuxorable.fr/ez_publish
to not have the error message above.

Regards

Pascal

Ce qui embellit le désert c'est qu'il cache un puits... quelque part... (A. de Saint-Exupéry) - http://luxpopuli.fr/eZ-Publish

Thursday 26 October 2006 10:53:50 am

Hi Claudia,

With or without virtual host I have the same problem.
I'm trying to upgrade directly from 3.7.9 to 3.8.5 (I have dumps of my database)
Well, once I installed the 3.8.5 files in my ezp install directory (ez_publish/) I run the updatedb scripts.

The first is dbupdate-3.6.0-to-3.8.0.sql and run fine. No error.
But each time I want to run the second one, dbupdate-3.8.0-to-3.8.1.sql I get:

ERROR 1061 at line 4: Duplicate key name 'ezkeyword_keyword_id'

Here is the update script:

UPDATE ezsite_data SET value='3.8.1' WHERE name='ezpublish-version';
UPDATE ezsite_data SET value='7' WHERE name='ezpublish-release';

CREATE INDEX ezkeyword_keyword_id ON ezkeyword ( keyword, id );
CREATE INDEX ezkeyword_attr_link_kid_oaid ON ezkeyword_attribute_link ( keyword_id, objectattribute_id );

CREATE INDEX ezurlalias_is_wildcard ON ezurlalias( is_wildcard );

CREATE INDEX eznode_assignment_coid_cov ON eznode_assignment( contentobject_id,contentobject_version );
CREATE INDEX eznode_assignment_is_main ON eznode_assignment( is_main );
CREATE INDEX eznode_assignment_parent_node ON eznode_assignment( parent_node );

In the ezkeyword table there is already a "ezkeyword_keyword_id" index
I am not a mysql expert, so I would like to know if I can remove the lines which want to creat an INDEX if it already exists ?

Regards

Pascal

Ce qui embellit le désert c'est qu'il cache un puits... quelque part... (A. de Saint-Exupéry) - http://luxpopuli.fr/eZ-Publish

Thursday 26 October 2006 1:37:40 pm

Hi Pascal

If you have already the index for the keyword table you can just remove this line from the updatescript. The index was added to a few releases some months ago to fix a performance problem with the keywords and maybe the update script does not consider that the index might already be there.

Regarding the database problem: I still think that eZ does not find a correct default siteaccess. To test that I would change the pagelayout.tpl and grab $access_type.name and also the databasesettings from ezini. Then you can see what access ez uses.

If you still have problems post the sections [SiteSettings] and [SiteAccessSettings] from the override site.ini.

Claudia

Monday 30 October 2006 2:13:02 pm

Hi Claudia,

I have the same access problem with a multi-sites but this time I can't solve it :-(

I have three sites and each one has its own database.
Each site.ini.append.php has these two sections:

Site 1

[SiteSettings]
SiteName=Site 1
SiteURL=xxxxx.fr/index.php/allobroges
MetaDataArray[author]=assoc AT linuxorable.fr - http://www.linuxorable.net/ez_publish/
MetaDataArray[copyright]=eZ systems
MetaDataArray[description]=Site 1
MetaDataArray[keywords]=xx,xxx,xxx,xxx,xxx,xxx
DefaultAccess=allobroges
LoginPage=embedded
SiteList[]=allobroges

[SiteAccessSettings]
CheckValidity=false
RequireUserLogin=flase
ShowHiddenNodes=false
RelatedSiteAccessList[]=allobroges
RelatedSiteAccessList[]=allobroges_admin

Site 2

SiteSettings]
SiteName=Site2
SiteURL=xxxxx.fr/index.php/mpt
MetaDataArray[author]=assoc AT linuxorable.fr - http://www.linuxorable.net/ez_publish/
MetaDataArray[copyright]=eZ systems
MetaDataArray[description]=Site 2
MetaDataArray[keywords]=xx,xxx,xxx,xxx,xxx,xxx
DefaultAccess=mpt
LoginPage=embedded
SiteList[]=mpt

[SiteAccessSettings]
RequireUserLogin=flase
ShowHiddenNodes=false
RelatedSiteAccessList[]=mpt
RelatedSiteAccessList[]=mpt_admin

Site 3

[SiteSettings]
SiteName=Site 3
SiteURL=xxxxx.fr/index.php/accueil
MetaDataArray[author]=assoc AT linuxorable.fr http://www.linuxorable.fr/ez_publish
MetaDataArray[copyright]=eZ systems
MetaDataArray[description]=Site 3
MetaDataArray[keywords]=xx,xxx,xxx,xxx,xxx,xxx
DefaultAccess=accueil
LoginPage=embedded
SiteList[]=accueil

[SiteAccessSettings]
CheckValidity=false
RequireUserLogin=flase
ShowHiddenNodes=false
RelatedSiteAccessList[]=accueil
RelatedSiteAccessList[]=accueil_admin

Site 1 and Site 2 can be accessed with:
http://www.xxxx.fr/mpt
http://www.xxxx.fr/allobroges

but Site 3 can only be accessed with:

http://www.xxxx.fr/index.php/accueil

And like with my previous problem above, if I use

http://www.xxxx.fr/

I get:

kernel::50
    * No database connection could be made, the system might not behave properly.

I followed your advice and I put {$access_type.name} in pagelayout and I get:

accueil

which is well the name of my siteaccess.

I don't have an override/site.ini.append.php file and site.ini contains:

[SiteSettings]
SiteList[]
....
....
....

[SiteAccessSettings]
AvailableSiteAccessList[]=accueil
AvailableSiteAccessList[]=accueil_admin
AvailableSiteAccessList[]=allobroges
AvailableSiteAccessList[]=allobroges_admin
AvailableSiteAccessList[]=mpt
AvailableSiteAccessList[]=mpt_admin
....
....
....

Regards

Pascal

Ce qui embellit le désert c'est qu'il cache un puits... quelque part... (A. de Saint-Exupéry) - http://luxpopuli.fr/eZ-Publish

Friday 03 November 2006 1:17:27 am

Hi Claudia,

Well, the solution to my problem is that it is necessary to have an override/site.ini.append.php file which contains:

[SiteSettings]
DefaultAccess=accueil

It is the minimum this file has to contain if we want the system works fine.

Regards

Pascal

Ce qui embellit le désert c'est qu'il cache un puits... quelque part... (A. de Saint-Exupéry) - http://luxpopuli.fr/eZ-Publish