Upgrade 3.7.5 -> 3.8.2 fails

Tuesday 25 July 2006 5:45:37 am

Hi,

I'm trying (for the first time) to upgrade my ezPublish 3.7.5 installation to 3.8.2. I've followed the steps in the upgrade description to the word. After this, I go to my site and receive the setup page. The documentation doesn't state if this is supposed to happen, which I do find a little suspicious...

Anyway, I walk through the wizard fixing a couple of permission issues along the way. At the end of it all, I get this message:

The setup wizard was not able to complete the creation of your selected sites.

The following errors were detected:

    * EZSW-004Failed inserting data to mysql
      Table 'ezapprove_items' already exists
    * EZSW-040Failed to initialize site package 'plain_site'

If you think you have fixed the errors you can try and click the "Retry" button.

...and this is where my ideas end. I've tried probably a dozen times by now. I've dropped & recreated my 3.7.5 database as well as removed & unpacked the 3.8.2 source to the hard disk.

The ezpublish error log contain a lot of "Access denied for user 'root'@'localhost' (using password: NO)" which I find strange. My siteaccess has a different user and password specified, and it obcviously works during the setup as there's a message in it which corresponds to the table that already exists.

Help?

What am I doing wrong?

Tuesday 25 July 2006 6:50:21 am

Yes,

As I wrote in my message, I have followed it, step by step, word by word, about a dozen times.

Wednesday 02 August 2006 4:21:08 am

Hi,

there was one change in settings/site.ini (Locale had been changed from eng-GB to eng-US) which seems to have been behind this whole debacle. I did get a notice about this and checked it, but assumed it would not be a problem. Apparently it was... :-/

Now I don't end up in the setup wizard when accessing the 3.8.2 site any longer. Unfortunately, all is yet not well. Accessing the site, I get an "Object is unavailable" error. If I access the admin siteaccess, I get an "Error / kernel (3)" message in the top left corner. and this message in the middle of the screen:

"The requested page could not be displayed. (3)

The requested object is not available.

Possible reasons:

* The ID number of the object is incorrect. Please check the URL for spelling mistakes.
* The object is no longer available."

Any ideas?

Friday 04 August 2006 1:11:17 am

Hi Sebastian,

it appears related, but not the same. I've run the updatemultilingual.php script without any obvious problems (and I'm running MySQL, not postgres).

I've enabled all likely (and unlikely) debug outputs as well. It executes the same SQL statement as the support incident you referred to which returns 0 rows. after that I get an error message about "Error ocurred using URI: /index.php"

I just ran the "Database consistency check" under Setup->Upgrade check in in my 3.8.2 installation after upgrading, which suggested a number of "ALTER TABLE" statements to get my database in sync with what the released version should look like. executed the changes but no difference...

This is what it suggested I needed to do:

ALTER TABLE ezkeyword ADD INDEX ezkeyword_keyword_id ( keyword, id );
ALTER TABLE ezkeyword_attribute_link ADD INDEX ezkeyword_attr_link_kid_oaid ( keyword_id, objectattribute_id );
ALTER TABLE eznode_assignment ADD INDEX eznode_assignment_coid_cov ( contentobject_id, contentobject_version );
ALTER TABLE eznode_assignment ADD INDEX eznode_assignment_is_main ( is_main );
ALTER TABLE eznode_assignment ADD INDEX eznode_assignment_parent_node ( parent_node );
ALTER TABLE ezurlalias ADD INDEX ezurlalias_is_wildcard ( is_wildcard );

Any further ideas?