@@ -, +, @@ --- installer/data/mysql/db_revs/230600006.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) --- a/installer/data/mysql/db_revs/230600006.pl +++ a/installer/data/mysql/db_revs/230600006.pl @@ -8,7 +8,7 @@ return { my ( $dbh, $out ) = @$args{qw(dbh out)}; $dbh->do(q{ - INSERT INTO systempreferences (`variable`,`value`,`explanation`,`options`,`type`) + INSERT IGNORE INTO systempreferences (`variable`,`value`,`explanation`,`options`,`type`) VALUES ('DefaultPatronSearchMethod','starts_with','Allows staff to set a default method when searching for patrons with autocomplete','starts_with|contains','Choice'); }); --