Forums / Install & configuration / upgrade error 3.3-4 - 3.9.2

upgrade error 3.3-4 - 3.9.2

Author Message

James Ward

Tuesday 05 June 2007 11:42:57 am

Hi All,
I'm attempting a big upgrade here and have hit problems early. Per the documentation at:
http://ez.no/doc/ez_publish/upgrading/upgrading_to_3_4/from_3_3_5_to_3_4_0

I ran the sql statements to get to 3.3-5 then the sql for 3.4.0 however when I run the updateremoteid.php the script errors out due to incorrect columns in the ezcontentclass table. Here is the error:

Error: (eZMySQLDB)
Query error: Unknown column 'serialized_name_list' in 'field list'. Query: SELECT id, version, serialized_name_list, identifier, contentobject_name, creator_id, modifier_id,
created, remote_id, modified, is_container, always_available, language_mask, initial_language_id,
sort_field, sort_order
FROM ezcontentclass
WHERE version='0'
ORDER BY id ASC

and here is a description of the ezcontentclass table as it currently appears:
mysql> describe ezcontentclass;
+--------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+--------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| version | int(11) | | PRI | 0 | |
| name | varchar(255) | YES | | NULL | |
| identifier | varchar(50) | | | | |
| contentobject_name | varchar(255) | YES | | NULL | |
| creator_id | int(11) | | | 0 | |
| modifier_id | int(11) | | | 0 | |
| created | int(11) | | | 0 | |
| modified | int(11) | | | 0 | |
| remote_id | varchar(100) | | | | |
+--------------------+--------------+------+-----+---------+----------------+
10 rows in set (0.00 sec)

Obviously this table is missing a lot of columns. I don't see any sql statements in the upgrade scripts that create those columns. Are the upgrade scripts incomplete, documented incorrectly, or am I missing something? Thanks in advance.

working at www.wardnet.com
blogging at www.jamesward.ca

James Ward

Wednesday 06 June 2007 7:56:13 am

Got it working. The documentation I cited above is incomplete:

php update/common/scripts/updateremoteid.php

should be:

php update/common/scripts/updateremoteid.php -s example

I was missing the siteaccess parameter at the end.

Cheers!

working at www.wardnet.com
blogging at www.jamesward.ca