[ts-gen] shim-080326.tgz mysql scripts

[Paul C]

On Thu, Mar 27, 2008 at 04:27:23PM -0400, Billy Pilgrim wrote:
>    Thanks shim now builds fine however I am having a problem with the
>    mysql database creation scripts. A few of generate syntax errors and
>    not all the db tables are created.
>    Does anyone have any thoughts on this!

Could be associated with the "sql-mode=ANSI" in your mysql.cnf file,
and reserved words / function names.

enabling sql-mode=ANSI in my /etc/mysql/my.cnf [i'm debian, not fedora]
reproduces some of your errors concerning 'Version' and 'Position' (below).

I get the impression that POSITION  may be a mysql function name,
 which means there are issues concerning whitespace between the word
 'Position' and the brackets (... ).  ANSI mode seems to enable
 IGNORE_SPACE, so probably altering the space wouldn't help.   You
 could try quoting the words `Position` and `Version` in the files
 (xact.sql and enum.sql), or restart mysqld without the
 "sql-mode=ANSI" line ( but maybe that would have other implications
 for your setup.)

Regards,

Paul 





>    ERROR 1064 (42000): 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 'Version
>    (
>    uid int unsigned ' at line 1

>    ERROR 1064 (42000): 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 'Position
>    (
>    uid int unsigned not null auto_increment primary key,
>    ' at line 1