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