Index: openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.10.0d13-5.10.0d14.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.10.0d13-5.10.0d14.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.10.0d13-5.10.0d14.sql 25 Aug 2020 16:27:37 -0000 1.1.2.1 +++ openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.10.0d13-5.10.0d14.sql 2 Sep 2020 11:25:49 -0000 1.1.2.2 @@ -5,4 +5,5 @@ update lang_message_keys set object_id = cast(split_part(message_key, '_', 3) as integer) where package_key = 'acs-translations' - and message_key like 'group_title_%'; + and message_key like 'group_title_%' + and exists (select 1 from acs_objects where object_id = cast(split_part(message_key, '_', 3) as integer)); Index: openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-5.10.0d13-5.10.0d14.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-5.10.0d13-5.10.0d14.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-5.10.0d13-5.10.0d14.sql 25 Aug 2020 16:27:37 -0000 1.1.2.1 +++ openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-5.10.0d13-5.10.0d14.sql 2 Sep 2020 11:25:49 -0000 1.1.2.2 @@ -4,4 +4,5 @@ update lang_message_keys set object_id = cast(split_part(message_key, '_', 3) as integer) where package_key = 'acs-translations' - and message_key like 'group_title_%'; + and message_key like 'group_title_%' + and exists (select 1 from acs_objects where object_id = cast(split_part(message_key, '_', 3) as integer));