On 5 April 2011 14:31, Phil Stracchino <alaric AT metrocast DOT net> wrote:
> 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
>
Hello, yes I am using MySQL 5.5. As you advised I changed the
following code in the make_mysql_tables script:

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))
  );

However running the script now gives a slightly different but similar
error message:

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 'INTEGER DEFAULT 0,
   CurrentValue INTEGER DEFAULT 0,
   WrapCounter TINYBLOB NO' at line 4

------------------------------------------------------------------------------
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