On 04/05/11 08:05, Kernel Panic wrote:
> Hello everyone,
> 
> I orginally posted my problem on the FreeBSD forums here:
> 
> http://forums.freebsd.org/showthread.php?p=130088#post130088
> 
> I was asked by the port maintainer to try the Bacula mail lists. My
> problem is that when I try to run the database setup scripts supplied
> with Bacula as specified in:
> 
> http://www.bacula.org/5.0.x-manuals/en/main/main/Installing_Configuring_MySQ.html#SECTION004220000000000000000
> 
> it generates the following error when running the ./make_mysql_tables script:
> 
> 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
> 
> Can anyone help me?

You're using MySQL 5.5, aren't you?


Good choice.  But ...  MAXVALUE is a reserved word in MySQL 5.5.  So
you'll need to modify the script and change
     MaxValue INTEGER DEFAULT 0,
     CurrentValue INTEGER DEFAULT 0,
     WrapCounter TI
to
     `MaxValue` INTEGER DEFAULT 0,
     CurrentValue INTEGER DEFAULT 0,
     WrapCounter TI

That should do it.

-- 
  Phil Stracchino, CDK#2     DoD#299792458     ICBM: 43.5607, -71.355
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT org
  Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
                 It's not the years, it's the mileage.

------------------------------------------------------------------------------
Xperia(TM) PLAY
It's a major breakthrough. An authentic gaming
smartphone on the nation's most reliable network.
And it wants your games.
http://p.sf.net/sfu/verizon-sfdev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users