On 5 April 2011 14:31, Phil Stracchino <ala...@metrocast.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 > ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.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@lists.sourceforge.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users