Hello,
in newer version of mysql is MaxValue a keyword but it is also a name of
column. In most cases this was already fixed, but not in documentation
and in bacula/src/win32/cats/make_mysql_tables.sql and
bacula/updatedb/update_mysql_tables_5_to_6.
See please attached patches.
Lukas
>From 11348c70c829adab4e5fe54ac7aba367a37aeb06 Mon Sep 17 00:00:00 2001
From: Lukas Nykryn <lnyk...@redhat.com>
Date: Tue, 1 Nov 2011 12:30:27 +0100
Subject: [PATCH] Add quotation around MaxValue
---
docs/manuals/de/developers/catalog.tex | 4 ++--
docs/manuals/en/developers/catalog.tex | 4 ++--
docs/manuals/es/developers/catalog-en.tex | 4 ++--
docs/manuals/fr/developers/catalog.tex | 4 ++--
4 files changed, 8 insertions(+), 8 deletions(-)
diff --git a/docs/manuals/de/developers/catalog.tex b/docs/manuals/de/developers/catalog.tex
index 4994d37..bfb7637 100644
--- a/docs/manuals/de/developers/catalog.tex
+++ b/docs/manuals/de/developers/catalog.tex
@@ -1138,8 +1138,8 @@ CREATE TABLE Version (
INSERT INTO Version (VersionId) VALUES (7);
CREATE TABLE Counters (
Counter TINYBLOB NOT NULL,
- MinValue INTEGER,
- MaxValue INTEGER,
+ `MinValue` INTEGER,
+ `MaxValue` INTEGER,
CurrentValue INTEGER,
WrapCounter TINYBLOB NOT NULL,
PRIMARY KEY (Counter(128))
diff --git a/docs/manuals/en/developers/catalog.tex b/docs/manuals/en/developers/catalog.tex
index 4994d37..bfb7637 100644
--- a/docs/manuals/en/developers/catalog.tex
+++ b/docs/manuals/en/developers/catalog.tex
@@ -1138,8 +1138,8 @@ CREATE TABLE Version (
INSERT INTO Version (VersionId) VALUES (7);
CREATE TABLE Counters (
Counter TINYBLOB NOT NULL,
- MinValue INTEGER,
- MaxValue INTEGER,
+ `MinValue` INTEGER,
+ `MaxValue` INTEGER,
CurrentValue INTEGER,
WrapCounter TINYBLOB NOT NULL,
PRIMARY KEY (Counter(128))
diff --git a/docs/manuals/es/developers/catalog-en.tex b/docs/manuals/es/developers/catalog-en.tex
index 4994d37..bfb7637 100644
--- a/docs/manuals/es/developers/catalog-en.tex
+++ b/docs/manuals/es/developers/catalog-en.tex
@@ -1138,8 +1138,8 @@ CREATE TABLE Version (
INSERT INTO Version (VersionId) VALUES (7);
CREATE TABLE Counters (
Counter TINYBLOB NOT NULL,
- MinValue INTEGER,
- MaxValue INTEGER,
+ `MinValue` INTEGER,
+ `MaxValue` INTEGER,
CurrentValue INTEGER,
WrapCounter TINYBLOB NOT NULL,
PRIMARY KEY (Counter(128))
diff --git a/docs/manuals/fr/developers/catalog.tex b/docs/manuals/fr/developers/catalog.tex
index 4994d37..bfb7637 100644
--- a/docs/manuals/fr/developers/catalog.tex
+++ b/docs/manuals/fr/developers/catalog.tex
@@ -1138,8 +1138,8 @@ CREATE TABLE Version (
INSERT INTO Version (VersionId) VALUES (7);
CREATE TABLE Counters (
Counter TINYBLOB NOT NULL,
- MinValue INTEGER,
- MaxValue INTEGER,
+ `MinValue` INTEGER,
+ `MaxValue` INTEGER,
CurrentValue INTEGER,
WrapCounter TINYBLOB NOT NULL,
PRIMARY KEY (Counter(128))
--
1.7.6.4
>From 8df7f7de94315f5a061a286930c677fa1106333e Mon Sep 17 00:00:00 2001
From: Lukas Nykryn <lnyk...@redhat.com>
Date: Tue, 1 Nov 2011 12:10:51 +0100
Subject: [PATCH] Add missing quotation around MaxValue
---
bacula/src/win32/cats/make_mysql_tables.sql | 4 ++--
bacula/updatedb/update_mysql_tables_5_to_6 | 4 ++--
2 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/bacula/src/win32/cats/make_mysql_tables.sql b/bacula/src/win32/cats/make_mysql_tables.sql
index 86a3c8b..70f7dd0 100644
--- a/bacula/src/win32/cats/make_mysql_tables.sql
+++ b/bacula/src/win32/cats/make_mysql_tables.sql
@@ -306,8 +306,8 @@ CREATE TABLE UnsavedFiles (
CREATE TABLE Counters (
Counter TINYBLOB NOT NULL,
- MinValue INTEGER DEFAULT 0,
- MaxValue INTEGER DEFAULT 0,
+ `MinValue` INTEGER DEFAULT 0,
+ `MaxValue` INTEGER DEFAULT 0,
CurrentValue INTEGER DEFAULT 0,
WrapCounter TINYBLOB NOT NULL,
PRIMARY KEY (Counter(128))
diff --git a/bacula/updatedb/update_mysql_tables_5_to_6 b/bacula/updatedb/update_mysql_tables_5_to_6
index 9834228..196c948 100755
--- a/bacula/updatedb/update_mysql_tables_5_to_6
+++ b/bacula/updatedb/update_mysql_tables_5_to_6
@@ -79,8 +79,8 @@ DROP TABLE Counters;
CREATE TABLE Counters (
Counter TINYBLOB NOT NULL,
- MinValue INTEGER,
- MaxValue INTEGER,
+ \`MinValue\` INTEGER DEFAULT 0,
+ \`MaxValue\` INTEGER DEFAULT 0,
CurrentValue INTEGER,
WrapCounter TINYBLOB NOT NULL,
PRIMARY KEY (Counter(128))
--
1.7.6.4
------------------------------------------------------------------------------
RSA® Conference 2012
Save $700 by Nov 18
Register now
http://p.sf.net/sfu/rsa-sfdev2dev1
_______________________________________________
Bacula-devel mailing list
Bacula-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-devel
