Here is the error message: "ERROR 1064 (42000) at line 415: 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 '@)' at line 1
Creation of MySQL tables succeeded.

Line 415 from "make_mysql_tables" script :

JobId integer NOT NULL,

The script was taken from latest Bacula release.

I'm using this command, when I running the script - ./make_mysql_tables -p






2012/10/3, Dan Langille <dan AT langille DOT org>:
> On 2012-10-01 13:35, George Sokolov wrote:
>> Hello,
>>  I got problems with "make_mysql_tables" script. When I running the
>> script, I got the message about SQL syntax error, under the line 414
>> or 415. My Bacula version is 5.2.6 from Debian back ports repository.
>> MySQL version is 5.1
>>  Any ideas ? Thanks in advance.
>
> 5.2.12 is the latest, first, I'd go to that version.  Yes, I know how
> some operating systems lag behind.  I'm sorry about that.
>
> Can you paste the error message?  Lines 414 or 415, whatever it was...
>
> What command did you issue when using make_mysql_tables?
>
> --
> Dan Langille - http://langille.org/
>

------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users