[prev in list] [next in list] [prev in thread] [next in thread] 

List:       bacula-bugs
Subject:    [Bacula-bugs] [bacula 0001504]: Error when creating tables in MySQL
From:       Mantis Bug Tracker <nobody () baculabugs ! unixathome ! org>
Date:       2011-03-19 7:31:00
Message-ID: 4bf0634d0ebe4a3a47af857bb3905975 () bugs ! bacula ! org
[Download RAW message or body]


The issue 0001710 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:              2010-08-08 17:02 GMT
====================================================================== 
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
====================================================================== 

---------------------------------------------------------------------- 
 (0005274) kern (administrator) - 2010-04-20 12: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 17: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-02-15 14:27 GAMER          Issue Monitored: GAMER                       
2010-04-19 08:22 ebollengier    Summary                  ?rror when creating
tables in MySQL => ?rror when creating tables in MySQL 5.5
2010-04-20 12:27 kern           Note Added: 0005274                          
2010-04-20 12:27 kern           Status                   new => acknowledged 
2010-04-20 12:27 kern           Summary                  ?rror when creating
tables in MySQL 5.5 => Error when creating tables in MySQL 5.5
2010-04-21 19:01 mnalis         Issue Monitored: mnalis                      
2010-05-19 13:40 HenrikJ        Issue Monitored: HenrikJ                     
2010-08-08 17:02 kern           Note Added: 0005558                          
2010-08-08 17:02 kern           Status                   acknowledged => closed
2010-08-08 17:02 kern           Resolution               open => fixed       
2010-08-08 17:02 kern           Fixed in Version          => 5.0.4           
2011-03-19 07:30 ebollengier    Relationship added       has duplicate 0001710
======================================================================


------------------------------------------------------------------------------
Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d
_______________________________________________
Bacula-bugs mailing list
Bacula-bugs@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-bugs
[prev in list] [next in list] [prev in thread] [next in thread]