View | Details | Raw Unified | Return to bug 31383
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_31383.pl (-1 / +8 lines)
Lines 44-49 return { Link Here
44
                for my $translated_content ( @$translated_contents ) {
44
                for my $translated_content ( @$translated_contents ) {
45
                    $sth_insert->execute($content->{id}, $translated_content->{title}, $translated_content->{content}, $translated_content->{lang}, $translated_content->{updated_on});
45
                    $sth_insert->execute($content->{id}, $translated_content->{title}, $translated_content->{content}, $translated_content->{lang}, $translated_content->{updated_on});
46
                }
46
                }
47
48
                # Delete duplicates
49
                $q = q{
50
                    DELETE FROM additional_contents
51
                    WHERE category=? AND code=? AND id<>? AND
52
                };
53
                $q .= defined $content->{branchcode} ? " branchcode = ?" : " branchcode IS NULL";
54
                $dbh->do($q, undef, $content->{category}, $content->{code}, $content->{id}, $content->{branchcode});
47
            }
55
            }
48
            $dbh->do(q{
56
            $dbh->do(q{
49
                ALTER TABLE additional_contents
57
                ALTER TABLE additional_contents
50
- 

Return to bug 31383