Needs help with the upgrade

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

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

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

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