From 809b89c8165c443c7cda24c25993d0d4d0add9a3 Mon Sep 17 00:00:00 2001 From: "Andrei V. Toutoukine" Date: Thu, 21 May 2009 12:42:23 +0400 Subject: [PATCH] import of the authorized values fails on the step 3 of the web-installation (ru-RU) ERROR 1136 (21S01) at line 1: Column count doesn't match value count at row 1 modified: installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].csv.sql modified: installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].csv.sql modified: installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].csv.sql modified: installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].csv.sql modified: installer/data/mysql/ru-RU/authorised_values/authorised_values_[STACK].csv.sql modified: installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].csv.sql Signed-off-by: Galen Charlton --- .../mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].csv.sql | 2 +- .../mysql/ru-RU/authorised_values/authorised_values_[LOST].csv.sql | 2 +- .../ru-RU/authorised_values/authorised_values_[NOT_LOAN].csv.sql | 2 +- .../ru-RU/authorised_values/authorised_values_[RESTRICTED].csv.sql | 2 +- .../mysql/ru-RU/authorised_values/authorised_values_[STACK].csv.sql | 4 ++-- .../ru-RU/authorised_values/authorised_values_[WITHDRAWN].csv.sql | 2 +- 6 files changed, 7 insertions(+), 7 deletions(-) diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].csv.sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].csv.sql index efb59f9652..a1159f01e2 100755 --- a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].csv.sql +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].csv.sql @@ -1,3 +1,3 @@ -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'DAMAGED','0'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'DAMAGED','0',''); INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 1,'DAMAGED','1','Повреждено'); diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].csv.sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].csv.sql index 85bc393013..25e4cac0ba 100755 --- a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].csv.sql +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].csv.sql @@ -1,4 +1,4 @@ -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'LOST','0'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'LOST','0', ''); INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 1,'LOST','2','Длительная просрочка (утрачено)'); diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].csv.sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].csv.sql index 95a725e171..192c9eb56c 100755 --- a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].csv.sql +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].csv.sql @@ -1,4 +1,4 @@ -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'NOT_LOAN','0'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'NOT_LOAN','0', ''); INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 1,'NOT_LOAN','1','Не для ссуды'); diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].csv.sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].csv.sql index 36bb437bd2..2a201de0c0 100755 --- a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].csv.sql +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].csv.sql @@ -1,3 +1,3 @@ -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'RESTRICTED','0'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'RESTRICTED','0', ''); INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 1,'RESTRICTED','1','Ограниченный доступ'); diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[STACK].csv.sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[STACK].csv.sql index 8493dc1443..7acc61bcdf 100755 --- a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[STACK].csv.sql +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[STACK].csv.sql @@ -1,2 +1,2 @@ -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'STACK','0'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 1,'STACK','1','Особое собрание'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'STACK','0', ''); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 1,'STACK','1','Особое собрание'); \ No newline at end of file diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].csv.sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].csv.sql index 3cefe81c9e..ee179a78b2 100755 --- a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].csv.sql +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].csv.sql @@ -1,3 +1,3 @@ -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'WITHDRAWN','0'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'WITHDRAWN','0', ''); INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 1,'WITHDRAWN','1','Изъято'); -- 2.11.0