On Apr 5, 2011, at 2:00 PM, Kernel Panic wrote: > On 5 April 2011 18:46, Phil Stracchino <ala...@metrocast.net> wrote: >> On 04/05/11 12:57, Kernel Panic wrote: >>> 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 >> >> Oh, right, this is being done in a shell script as a here document, >> isn't it...? >> >> ` is a shell metacharacter. You'll have to escape those with a backslash: >> >> \`MaxValue\` INTEGER ... >> >> >> In the long term, this field should really be renamed.
In the meantime, if the OP submits a patch to the FreeBSD system, I will get it committed. I'm a bit preoccupied at present. :) ------------------------------------------------------------------------------ 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
