Share » Forums » Install & configuration » Needs help with the upgrade

Needs help with the upgrade

Needs help with the upgrade

Tuesday 26 August 2008 1:17:47 pm - 7 replies

Author Message

André R.

Tuesday 26 August 2008 2:27:53 pm

If you enable debugOutput it might give some clues.

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Xavier Dutoit

Tuesday 26 August 2008 11:22:50 pm

TRUNCATE: command not found

What's the mysql version you're using ?

X+

http://www.sydesy.com

Erland Flaten

Wednesday 27 August 2008 3:04:51 am

Thanks for quick response:

Attn. André:
I have enabled the debug output. Its only visible in the admin interface.
http://nuna0000.no.ezpublish10.ezdeal.no/siteadmin

There where a lot of errors like:

eZContentObjectTreeNode::pathWithNames() failed to fetch path of node 15, falling back to generated url entries. Run updateniceurls.php to fix the problem.

The second time I tried to click on a link in the admin interface most of those error where gone. There are still some as you can see. Cache clearing in admin doesent seems to work?
Tried cache clearing with terminal and it didnt work:

ezpublish10:~/www/bin/shell$ clearcache.sh
-bash_nuna0000noezpublish10ezdealno: clearcache.sh: command not found

I tried to run the nice url update again:

ezpublish10:~/www$ php bin/php/updateniceurls.php --fetch-limit=100
Note: any errors encountered will be logged to urlalias_error.log
Using fetch limit: 100
Starting updates for Home, 119 nodes
........................................................ 46.22% 2s 55/119
........................................................ 93.28% 0s 111/119
.......
Updated 0/119 for Home

Starting updates for Users, 12 nodes
............
Updated 0/12 for Users

Starting updates for Media, 21 nodes
.....................
Updated 0/21 for Media

Starting updates for Setup, 1 nodes
.
Updated 0/1 for Setup

Starting updates for Design, 1 nodes
.
Updated 0/1 for Design


Total update 5/159
Node time taken: 3s
Total time taken: 3s
ezpublish10:~/www$ 

Attn. Xavier: Its MySQL client version: 5.0.26
and PHP extensions: mysqli

I will look more in to this in the afternoon.

Erland Flaten
Lilllehammer, Norway

Erland Flaten

Wednesday 27 August 2008 11:16:24 am

I have turned on ( DebugOutput=enabled ) the display of errormessages in the file site.ini in the folder settings.

This gives error messages in admin siteaccess, but non in the websiteinterface. One message is:

Query error: Unknown column 'e0.alias_redirects' in 'field list'. Query: SELECT e0.id AS e0_id, e0.link AS e0_link, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.is_alias AS e0_is_alias, e0.alias_redirects AS e0_alias_redirects, e1.id AS e1_id, e1.link AS e1_link, e1.text AS e1_text, e1.text_md5 AS e1_text_md5, e1.is_alias AS e1_is_alias, e1.action AS e1_action, e1.alias_redirects AS e1_alias_redirects
FROM ezurlalias_ml e0, ezurlalias_ml e1
WHERE e0.parent = 0 AND (e0.lang_mask & 7 > 0) AND e0.text_md5 =  MD5( 'user' ) 
AND e1.parent = e0.link AND (e1.lang_mask & 7 > 0) AND e1.text_md5 =  MD5( 'login' ) 
LIMIT 0, 1

I tried to run the clearcache.sh to be able to se more errors. Also unsucessfull:

ezpublish10:~/www/bin/shell$ clearcache.sh
-bash_nuna0000noezpublish10ezdealno: clearcache.sh: command not found
ezpublish10:~/www/bin/shell$ 

I cant do anything in the admin interface. Cant run clear cache...
Any suggestions what to try?

Erland Flaten
Lilllehammer, Norway

André R.

Wednesday 27 August 2008 2:00:25 pm

Looks like your url_alais table is broken, might be faster to just set up the content again on a clean 4.0.1 install then figuring out where you went wrong in the 4.0.0 -> 4.0.1 update.

As for:
> I tried to run the clearcache.sh to be able to se more errors. Also unsucessfull:

clearcace.sh where removed a couple a versions ago, here is how to clear cache:
http://ez.no/doc/ez_publish/technical_manual/4_0/reference/scripts/generic/ezcache_php

Also mentioned explicit in the last couple of upgrade docs:
http://ez.no/doc/ez_publish/upgrading/upgrading_to_4_0/from_4_0_x_to_4_0_y#eztoc98307_5

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Erland Flaten

Thursday 28 August 2008 10:15:10 am

OK I am also thinking about ding just that. I am unpacking the new 4.01 on my mac. Then updating the distribution files as described. Then I will use FTP and move the 4.01 and replacing the files on the webserver.

Before I start on any thing related to the databse I will use phpmyadmin and use the "import" thing to get the old database back to the mysql databaseserver.

Is this is the right way to do it? Time will show..

Question. Will a copy of EZ from my mac have the right permissions to run on a remote webserver?

Erland Flaten
Lilllehammer, Norway

André R.

Thursday 28 August 2008 11:36:02 am

> Question. Will a copy of EZ from my mac have the right permissions to run on a remote webserver?

No, permissions are normally not included when transferring over ftp. So take a look at chmod and chown, probably also mentioned somewhere in the docs as well.

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

You must be logged in to post messages in this topic!

36 542 Users on board!

Forums menu