Forums / Install & configuration / Needs help with the upgrade

Needs help with the upgrade

Author Message

Erland Flaten

Tuesday 26 August 2008 1:17:47 pm

After attempting to upgrade from 4.0 to 4.01, my site is now sick and confused.

The site is not launched so its not too critical:

http://nuna0000.no.ezpublish10.ezdeal.no/

Readers can’t access any links and the look of the websiteinterface extension has been changed from blue to grey. Trying a link on the frontpage gives an error message that the URL is wrong or that the log-in is necessary. The password for the Admin doesn’t work anymore.

What I did to upgrade was this:
- I copied all “distribution files” with FTP (Transmit) from webserver to my local computer (OS X) .

- On my mac I had an unzipped version of 4.01. I replaced the distribution files in this 4.01 version with the ones from the webserver.

- Then I run the “fixobjectremoteid.php” result: “Found 0 non-unique content object remote IDs.”
This was done locally on the mac.

-Then I deleted all files in the www-directory where the 4.0 installations was. Then I copied the 4.01, with the distribution files from 4.0, back to the webserver.

- Then I run database upgrade. The result after the database upgrade and the stuff with the migration table can be viewed at:

http://www.nuna.no/to401unixing.txt

At the page above you can see the rest of my actions on the terminal. Which is:

- php extension/ezurlaliasmigration/scripts/migrate.php --create-migration-table

- then:
ezpublish10:~/www$ php extension/ezurlaliasmigration/scripts/migrate.php -s nor

( I did the “TRUNCATE ezurlalias_ml;” in phpmyadmin after I first tried it on the Terminal )

- And then :
ezpublish10:~/www$ php bin/php/updateniceurls.php --fetch-limit=100

Then:
php extension/ezurlaliasmigration/scripts/migrate.php --restore

Last:
ezpublish10:~/www$ php bin/php/ezcache.php --clear-all --purge

Any faults in actions or results that stands out or any hints what to do next?

I have bacup of the database and the 4.0 files. But they are locale an then maybe with wrong permisssions.

I have run the modfix but it dident help.

Erland Flaten
Lilllehammer, Norway

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