[Bacula-bugs] [bacula 0001504]: Error when creating tables in MySQL 5.5

[Mantis B. T. <no...@bu...>]

The issue 0001753 has been set as DUPLICATE OF the following issue. 
====================================================================== 
http://bugs.bacula.org/view.php?id=1504 
====================================================================== 
Reported By:                GAMER
Assigned To:                
====================================================================== 
Project:                    bacula
Issue ID:                   1504
Category:                   sql
Reproducibility:            have not tried
Severity:                   minor
Priority:                   normal
Status:                     closed
Resolution:                 fixed
Fixed in Version:           5.0.4
====================================================================== 
Date Submitted:             2010-02-15 14:26 GMT
Last Modified:              2011-07-25 15:23 BST
====================================================================== 
Summary:                    Error when creating tables in MySQL 5.5
Description: 
Mysql-server 5.5 installed.
When execute make_mysql_tables:
ERROR 1064 (42000) at line 316: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to use
near 'MaxValue INTEGER DEFAULT 0,
   CurrentValue INTEGER DEFAULT 0,
   WrapCounter TI' at line 4


Additional Information: 
MaxValue is reserved world in Mysql-5.5

Need the patch:

make_mysql_tables.patch

--- make_mysql_tables.orig      2010-02-15 16:05:14.000000000 +0200
+++ make_mysql_tables   2010-02-15 16:09:50.000000000 +0200
@@ -322,12 +322,12 @@



-CREATE TABLE Counters (
-   Counter TINYBLOB NOT NULL,
-   MinValue INTEGER DEFAULT 0,
-   MaxValue INTEGER DEFAULT 0,
-   CurrentValue INTEGER DEFAULT 0,
-   WrapCounter TINYBLOB NOT NULL,
+CREATE TABLE \`Counters\` (
+   \`Counter\` TINYBLOB NOT NULL,
+   \`MinValue\` INTEGER DEFAULT 0,
+   \`MaxValue\` INTEGER DEFAULT 0,
+   \`CurrentValue\` INTEGER DEFAULT 0,
+   \`WrapCounter\` TINYBLOB NOT NULL,
    PRIMARY KEY (Counter(128))
    );

======================================================================
Relationships       ID      Summary
----------------------------------------------------------------------
has duplicate       0001710 error in make_bacula_tables.mysql
has duplicate       0001753 MySQL 5.5: Can't create mysql tables (M...
====================================================================== 

---------------------------------------------------------------------- 
 (0005274) kern (administrator) - 2010-04-20 13:27
 http://bugs.bacula.org/view.php?id=1504#c5274 
---------------------------------------------------------------------- 
This is due to MySQL polluting the user name space by making more reserved
words. We will probably change the name in the next version of the database. 

---------------------------------------------------------------------- 
 (0005558) kern (administrator) - 2010-08-08 18:02
 http://bugs.bacula.org/view.php?id=1504#c5558 
---------------------------------------------------------------------- 
Fixed in next version -- probably 5.0.4 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-02-15 14:26 GAMER          New Issue                                    
2010-02-15 14:26 GAMER          File Added: make_mysql_tables.patch             
      
2010-04-19 09:22 ebollengier    Summary                  ?rror when creating
tables in MySQL => ?rror when creating tables in MySQL 5.5
2010-04-20 13:27 kern           Note Added: 0005274                          
2010-04-20 13:27 kern           Status                   new => acknowledged 
2010-04-20 13:27 kern           Summary                  ?rror when creating
tables in MySQL 5.5 => Error when creating tables in MySQL 5.5
2010-08-08 18:02 kern           Note Added: 0005558                          
2010-08-08 18:02 kern           Status                   acknowledged => closed
2010-08-08 18:02 kern           Resolution               open => fixed       
2010-08-08 18:02 kern           Fixed in Version          => 5.0.4           
2011-03-19 07:30 ebollengier    Relationship added       has duplicate 0001710
2011-07-25 15:23 marcovw        Relationship added       has duplicate 0001753
======================================================================