On Apr 5, 2011, at 2:00 PM, Kernel Panic wrote:

> On 5 April 2011 18:46, Phil Stracchino <alaric AT metrocast DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users