|
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
|