= Update from build 77 * Stop tomcat. * Replace the build 77 war with the new war. * Open a postgres client: {{{ sudo -u postgres psql content }}} * Enter the following SQL commands: > **NOTE:** The queries reference the index group and index type ids present in most systems. Only systems upgraded from very old versions or with major changes in the server configuration might have different ids. In this case, determine the ids from the database and change the queries accordingly. The index type used is the Integer indexer.[[br]][[br]]**NOTE:** Make sure that the assigned ids (992 to 999) do not yet exist, or change them accordingly in the query. {{{ insert into index_items(id, fieldname, for_content, for_metadata, for_sys_meta, multiple_results, name, obj_version, search_string, systemic, va_params, index_group_id, index_type_id, search_condition, store_field) values (992, 'parent.relations.translation_root', false, false, true, true, 'parent.relations.translation_root', 0, '/sysMeta/object/relations/parents/id[@type="translation_root"]',false, '',54,57,'true()',false ); insert into index_items(id, fieldname, for_content, for_metadata, for_sys_meta, multiple_results, name, obj_version, search_string, systemic, va_params, index_group_id, index_type_id, search_condition, store_field) values (993, 'child.relations.translation_root', false, false, true, true, 'child.relations.translation_root', 0, '/sysMeta/object/relations/children/id[@type="translation_root"]',false, '',54,57,'true()',false ); insert into index_items(id, fieldname, for_content, for_metadata, for_sys_meta, multiple_results, name, obj_version, search_string, systemic, va_params, index_group_id, index_type_id, search_condition, store_field) values (994, 'parent.relations.translation_source', false, false, true, true, 'parent.relations.translation_source', 0, '/sysMeta/object/relations/parents/id[@type="translation_source"]',false, '',54,57,'true()',false ); insert into index_items(id, fieldname, for_content, for_metadata, for_sys_meta, multiple_results, name, obj_version, search_string, systemic, va_params, index_group_id, index_type_id, search_condition, store_field) values (995, 'child.relations.translation_source', false, false, true, true, 'child.relations.translation_source', 0, '/sysMeta/object/relations/children/id[@type="translation_source"]',false, '',54,57,'true()',false ); insert into index_items(id, fieldname, for_content, for_metadata, for_sys_meta, multiple_results, name, obj_version, search_string, systemic, va_params, index_group_id, index_type_id, search_condition, store_field) values (996, 'parent.relations.child_content', false, false, true, true, 'parent.relations.child_content', 0, '/sysMeta/object/relations/parents/id[@type="child_content"]',false, '',54,57,'true()',false ); insert into index_items(id, fieldname, for_content, for_metadata, for_sys_meta, multiple_results, name, obj_version, search_string, systemic, va_params, index_group_id, index_type_id, search_condition, store_field) values (997, 'child.relations.child_content', false, false, true, true, 'child.relations.child_content', 0, '/sysMeta/object/relations/children/id[@type="child_content"]',false, '',54,57,'true()',false ); insert into index_items(id, fieldname, for_content, for_metadata, for_sys_meta, multiple_results, name, obj_version, search_string, systemic, va_params, index_group_id, index_type_id, search_condition, store_field) values (998, 'parent.relations', false, false, true, true, 'parent.relations', 0, '/sysMeta/object/relations/parents/id',false, '',54,57,'true()',false ); insert into index_items(id, fieldname, for_content, for_metadata, for_sys_meta, multiple_results, name, obj_version, search_string, systemic, va_params, index_group_id, index_type_id, search_condition, store_field) values (999, 'child.relations', false, false, true, true, 'child.relations', 0, '/sysMeta/object/relations/children/id',false, '',54,57,'true()',false ); }}} * Remove all relation resolvers except {{{FixedRelationResolver}}}. {{{ delete from relation_resolvers where name in ('LatestBranchResolver','LatestHeadResolver'); }}} * Delete obsolete index items and index type: {{{ delete from index_items where name in ('index.appname','index.procstate','index.created.time','index.modified.time'); delete from index_types where name = 'xpath.time_indexer'; }}} * Force reindex of all folders and objects: {{{ insert into index_jobs select id,false,'cinnamon.Folder',id from folders; insert into index_jobs select id,false,'cinnamon.ObjectSystemData',id from objects; }}} * Exit the database client: {{{\q}}}. * Start tomcat.