From aad4cc7b82b156ce752b2e90441607324c632f44 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@biblibre.com>
Date: Tue, 24 Dec 2013 09:58:38 +0100
Subject: [PATCH] Bug 10138: (follow-up) FIX sql errors
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

There were 2 INSERT in error.

Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com>
Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
I have gone ahead and fixed the typo pointed out by Mathieu:
Endommadgé-> Endommagé

Sample files install without problems, tests look good.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
(cherry picked from commit e81513199cba41a254820347442719a6fd50ec0b)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
(cherry picked from commit 5d5c15f873f6285ef1fdd900c2a15cdac3a9e2c5)
---
 .../data/mysql/fr-FR/1-Obligatoire/authorised_values.sql    | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql b/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql
index 37c74704db..2a33628965 100644
--- a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql
+++ b/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql
@@ -7,8 +7,8 @@ INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES
 INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('SUGGEST','Onéreux','Document trop onéreux');
 INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('SUGGEST','Poldoc','Document ne correspondant pas à notre politique d''acquisition');
 -- OPAC Suggestions reasons
-INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('OPAC_SUG','damaged','L''exemplaire de la bibliothèque est endommagé','L''exemplaire de la bibliothèque est endommagdé');
-INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('OPAC_SUG','bestseller','Bestseller','Bestseller');
+INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('OPAC_SUG','damaged','L''exemplaire de la bibliothèque est endommagé');
+INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('OPAC_SUG','bestseller','Bestseller');
 -- Report groups
 INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('REPORT_GROUP', 'CIRC', 'Circulation');
 INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('REPORT_GROUP', 'CAT', 'Catalogue');
@@ -21,7 +21,7 @@ INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES
 INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('LOST','3','Perdu et remboursé');
 INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('LOST','4','Introuvable');
 -- damaged status of an item
-INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('DAMAGED','1','Endommagdé');
+INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ('DAMAGED','1','Endommagé');
 -- Status codes
 INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'ETAT', '0', 'Empruntable');
 INSERT INTO `authorised_values` ( `category`, `authorised_value`, `lib`) VALUES ( 'ETAT', '1', 'Exclu du prêt');
-- 
2.39.5