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
[email protected] [email protected] [email protected]
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
