Merge branch 'release/0.6.9'

1 files changed, 4 insertions, 5 deletions

diff --git a/db/migrate/098_fix_public_body_translations.rb b/db/migrate/098_fix_public_body_translations.rb
index 9bcefb1c0..25f36336f 100644
--- a/db/migrate/098_fix_public_body_translations.rb
+++ b/db/migrate/098_fix_public_body_translations.rb
@@ -15,13 +15,12 @@ class FixPublicBodyTranslations < ActiveRecord::Migration
         where first_letter is null
         ;
       SQL
-      
+
       execute <<-SQL
         update public_body_translations
-          set publication_scheme = public_bodies.publication_scheme
-        from public_bodies
-        where public_body_translations.public_body_id = public_bodies.id
-          and public_body_translations.publication_scheme is null
+          set publication_scheme = (SELECT public_bodies.publication_scheme FROM public_bodies WHERE
+public_body_translations.public_body_id = public_bodies.id )
+        where public_body_translations.publication_scheme is null
         ;
       SQL
     end