Bug 10138: (follow-up) FIX sql errors

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)

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 37c7470..2a33628 100644 (file)
--- 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');