Changes between Initial Version and Version 1 of Public/Docs/CinnamonWarBuildDocs/UpdateBuild77To105


Ignore:
Timestamp:
Sep 11, 2019, 10:11:12 AM (17 months ago)
Author:
Administrator
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Public/Docs/CinnamonWarBuildDocs/UpdateBuild77To105

    v1 v1  
     1= Update from build 77
     2* Stop tomcat.
     3* Replace the build 77 war with the new war.
     4* Open a postgres client:
     5{{{
     6sudo -u postgres psql content
     7}}}
     8* Enter the following SQL commands:
     9> **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.
     10{{{
     11insert 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)
     12values (992, 'parent.relations.translation_root', false, false, true, true, 'parent.relations.translation_root', 0, '/sysMeta/object/relations/parents/id[@type="translation_root"]',false, '<vaParams/>',54,57,'true()',false );
     13
     14insert 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)
     15values (993, 'child.relations.translation_root', false, false, true, true, 'child.relations.translation_root', 0, '/sysMeta/object/relations/children/id[@type="translation_root"]',false, '<vaParams/>',54,57,'true()',false );
     16
     17insert 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)
     18values (994, 'parent.relations.translation_source', false, false, true, true, 'parent.relations.translation_source', 0, '/sysMeta/object/relations/parents/id[@type="translation_source"]',false, '<vaParams/>',54,57,'true()',false );
     19
     20insert 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)
     21values (995, 'child.relations.translation_source', false, false, true, true, 'child.relations.translation_source', 0, '/sysMeta/object/relations/children/id[@type="translation_source"]',false, '<vaParams/>',54,57,'true()',false );
     22
     23insert 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)
     24values (996, 'parent.relations.child_content', false, false, true, true, 'parent.relations.child_content', 0, '/sysMeta/object/relations/parents/id[@type="child_content"]',false, '<vaParams/>',54,57,'true()',false );
     25
     26insert 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)
     27values (997, 'child.relations.child_content', false, false, true, true, 'child.relations.child_content', 0, '/sysMeta/object/relations/children/id[@type="child_content"]',false, '<vaParams/>',54,57,'true()',false );
     28
     29insert 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)
     30values (998, 'parent.relations', false, false, true, true, 'parent.relations', 0, '/sysMeta/object/relations/parents/id',false, '<vaParams/>',54,57,'true()',false );
     31
     32insert 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)
     33values (999, 'child.relations', false, false, true, true, 'child.relations', 0, '/sysMeta/object/relations/children/id',false, '<vaParams/>',54,57,'true()',false );
     34}}}
     35* Remove all relation resolvers except {{{FixedRelationResolver}}}.
     36{{{
     37delete from relation_resolvers where name in ('LatestBranchResolver','LatestHeadResolver');
     38}}}
     39* Delete obsolete index items and index type:
     40{{{
     41delete from index_items where name in ('index.appname','index.procstate','index.created.time','index.modified.time');
     42delete from index_types where name = 'xpath.time_indexer';
     43}}}
     44* Force reindex of all folders and objects:
     45{{{
     46insert into index_jobs select id,false,'cinnamon.Folder',id from folders;
     47insert into index_jobs select id,false,'cinnamon.ObjectSystemData',id from objects;
     48}}}
     49* Exit the database client: {{{\q}}}.
     50* Start tomcat.