|
Wednesday 19 October 2005 11:57:22 am
Hi there,
Suddenly all the content on our site doesnt show. Can not see it in admin also.Users are also gonne only admin users still there. Media lib also no objects. And everything in the mid coloun in the the admin is gonne. so can not create any new things. I run a upgrade check in database just to see what it says (dont know if thats right to do to check):
The database is not consistent with the distribution database. To synchronize your database with the distribution setup, run the following SQL commands:
ALTER TABLE ezsubtree_expiry ADD COLUMN cache_file varchar(255) NOT NULL DEFAULT '';
ALTER TABLE ezsubtree_expiry ADD COLUMN subtree int(11) DEFAULT NULL;
ALTER TABLE ezsubtree_expiry ADD INDEX ezsubtree_expiry_subtree ( subtree );
ALTER TABLE ezuser_setting ADD COLUMN is_enabled int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezuser_setting ADD COLUMN max_login int(11) DEFAULT NULL;
ALTER TABLE ezuser_setting ADD COLUMN user_id int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezuser_setting ADD PRIMARY KEY ( user_id ); Then is ran it once more and this came: The database is not consistent with the distribution database. To synchronize your database with the distribution setup, run the following SQL commands:
ALTER TABLE ezbasket ADD COLUMN id int(11) NOT NULL AUTO_INCREMENT;
ALTER TABLE ezbasket ADD COLUMN order_id int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezbasket ADD COLUMN productcollection_id int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezbasket ADD COLUMN session_id varchar(255) NOT NULL DEFAULT '';
ALTER TABLE ezbasket ADD PRIMARY KEY ( id );
ALTER TABLE ezbasket ADD INDEX ezbasket_session_id ( session_id );
ALTER TABLE ezcontentobject ADD COLUMN contentclass_id int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezcontentobject ADD COLUMN current_version int(11) DEFAULT NULL;
ALTER TABLE ezcontentobject ADD COLUMN id int(11) NOT NULL AUTO_INCREMENT;
ALTER TABLE ezcontentobject ADD COLUMN is_published int(11) DEFAULT NULL;
ALTER TABLE ezcontentobject ADD COLUMN modified int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezcontentobject ADD COLUMN name varchar(255) DEFAULT NULL;
ALTER TABLE ezcontentobject ADD COLUMN owner_id int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezcontentobject ADD COLUMN published int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezcontentobject ADD COLUMN remote_id varchar(100) DEFAULT NULL;
ALTER TABLE ezcontentobject ADD COLUMN section_id int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezcontentobject ADD COLUMN status int(11) DEFAULT '0';
ALTER TABLE ezcontentobject ADD PRIMARY KEY ( id );
ALTER TABLE ezcontentobject_attribute ADD COLUMN attribute_original_id int(11) DEFAULT '0';
ALTER TABLE ezcontentobject_attribute ADD COLUMN contentclassattribute_id int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezcontentobject_attribute ADD COLUMN contentobject_id int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezcontentobject_attribute ADD COLUMN data_float float DEFAULT NULL;
ALTER TABLE ezcontentobject_attribute ADD COLUMN data_int int(11) DEFAULT NULL;
ALTER TABLE ezcontentobject_attribute ADD COLUMN data_text longtext;
ALTER TABLE ezcontentobject_attribute ADD COLUMN data_type_string varchar(50) DEFAULT '';
ALTER TABLE ezcontentobject_attribute ADD COLUMN id int(11) NOT NULL AUTO_INCREMENT;
ALTER TABLE ezcontentobject_attribute ADD COLUMN language_code varchar(20) NOT NULL DEFAULT '';
ALTER TABLE ezcontentobject_attribute ADD COLUMN sort_key_int int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezcontentobject_attribute ADD COLUMN sort_key_string varchar(255) NOT NULL DEFAULT '';
ALTER TABLE ezcontentobject_attribute ADD COLUMN version int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezcontentobject_attribute ADD PRIMARY KEY ( id, version );
ALTER TABLE ezcontentobject_attribute ADD INDEX ezcontentobject_attribute_co_id_ver_lang_code ( contentobject_id, version, language_code );
ALTER TABLE ezcontentobject_attribute ADD INDEX ezcontentobject_attribute_contentobject_id ( contentobject_id );
ALTER TABLE ezcontentobject_attribute ADD INDEX ezcontentobject_attribute_language_code ( language_code );
ALTER TABLE ezcontentobject_attribute ADD INDEX sort_key_int ( sort_key_int );
ALTER TABLE ezcontentobject_attribute ADD INDEX sort_key_string ( sort_key_string );
ALTER TABLE ezcontentobject_tree ADD COLUMN contentobject_id int(11) DEFAULT NULL;
ALTER TABLE ezcontentobject_tree ADD COLUMN contentobject_is_published int(11) DEFAULT NULL;
ALTER TABLE ezcontentobject_tree ADD COLUMN contentobject_version int(11) DEFAULT NULL;
ALTER TABLE ezcontentobject_tree ADD COLUMN depth int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezcontentobject_tree ADD COLUMN is_hidden int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezcontentobject_tree ADD COLUMN is_invisible int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezcontentobject_tree ADD COLUMN main_node_id int(11) DEFAULT NULL;
ALTER TABLE ezcontentobject_tree ADD COLUMN modified_subnode int(11) DEFAULT '0';
ALTER TABLE ezcontentobject_tree ADD COLUMN node_id int(11) NOT NULL AUTO_INCREMENT;
ALTER TABLE ezcontentobject_tree ADD COLUMN parent_node_id int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezcontentobject_tree ADD COLUMN path_identification_string longtext;
ALTER TABLE ezcontentobject_tree ADD COLUMN path_string varchar(255) NOT NULL DEFAULT '';
ALTER TABLE ezcontentobject_tree ADD COLUMN priority int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezcontentobject_tree ADD COLUMN remote_id varchar(100) NOT NULL DEFAULT '';
ALTER TABLE ezcontentobject_tree ADD COLUMN sort_field int(11) DEFAULT '1';
ALTER TABLE ezcontentobject_tree ADD COLUMN sort_order int(11) DEFAULT '1';
ALTER TABLE ezcontentobject_tree ADD PRIMARY KEY ( node_id );
ALTER TABLE ezcontentobject_tree ADD INDEX ezcontentobject_tree_co_id ( contentobject_id );
ALTER TABLE ezcontentobject_tree ADD INDEX ezcontentobject_tree_depth ( depth );
ALTER TABLE ezcontentobject_tree ADD INDEX ezcontentobject_tree_p_node_id ( parent_node_id );
ALTER TABLE ezcontentobject_tree ADD INDEX ezcontentobject_tree_path ( path_string );
ALTER TABLE ezcontentobject_tree ADD INDEX ezcontentobject_tree_path_ident ( path_identification_string );
ALTER TABLE ezcontentobject_tree ADD INDEX modified_subnode ( modified_subnode );
ALTER TABLE ezcontentobject_version ADD COLUMN contentobject_id int(11) DEFAULT NULL;
ALTER TABLE ezcontentobject_version ADD COLUMN created int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezcontentobject_version ADD COLUMN creator_id int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezcontentobject_version ADD COLUMN id int(11) NOT NULL AUTO_INCREMENT;
ALTER TABLE ezcontentobject_version ADD COLUMN modified int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezcontentobject_version ADD COLUMN status int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezcontentobject_version ADD COLUMN user_id int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezcontentobject_version ADD COLUMN version int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezcontentobject_version ADD COLUMN workflow_event_pos int(11) DEFAULT '0';
ALTER TABLE ezcontentobject_version ADD PRIMARY KEY ( id );
ALTER TABLE ezcontentobject_version ADD INDEX idx_object_version_objver ( contentobject_id, version );
ALTER TABLE eznode_assignment ADD COLUMN contentobject_id int(11) DEFAULT NULL;
ALTER TABLE eznode_assignment ADD COLUMN contentobject_version int(11) DEFAULT NULL;
ALTER TABLE eznode_assignment ADD COLUMN from_node_id int(11) DEFAULT '0';
ALTER TABLE eznode_assignment ADD COLUMN id int(11) NOT NULL AUTO_INCREMENT;
ALTER TABLE eznode_assignment ADD COLUMN is_main int(11) NOT NULL DEFAULT '0';
ALTER TABLE eznode_assignment ADD COLUMN parent_node int(11) DEFAULT NULL;
ALTER TABLE eznode_assignment ADD COLUMN parent_remote_id varchar(100) NOT NULL DEFAULT '';
ALTER TABLE eznode_assignment ADD COLUMN remote_id int(11) NOT NULL DEFAULT '0';
ALTER TABLE eznode_assignment ADD COLUMN sort_field int(11) DEFAULT '1';
ALTER TABLE eznode_assignment ADD COLUMN sort_order int(11) DEFAULT '1';
ALTER TABLE eznode_assignment ADD PRIMARY KEY ( id );
ALTER TABLE ezsubtree_expiry ADD COLUMN cache_file varchar(255) NOT NULL DEFAULT '';
ALTER TABLE ezsubtree_expiry ADD COLUMN subtree int(11) DEFAULT NULL;
ALTER TABLE ezsubtree_expiry ADD INDEX ezsubtree_expiry_subtree ( subtree );
ALTER TABLE ezuser_setting ADD COLUMN is_enabled int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezuser_setting ADD COLUMN max_login int(11) DEFAULT NULL;
ALTER TABLE ezuser_setting ADD COLUMN user_id int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezuser_setting ADD PRIMARY KEY ( user_id );
System upgrade check Whats happening? Anyone please help.
Thanks
Ole
|