I ran into the same problem last week for mysql on linux (Suse 7). On windows everything went fine but on linux I got the extra comma. But now for the strangest thing of all.... this happened for only one of my two turbine apps !! I have gone over them many times but they are both using the same Torque jar (3.0-b3-dev) and all properties are basically the same. One of the projects consistently produces the extra comma on linux, the other one doesn't..
Any hints towards a solution are very welcome Age > -----Original Message----- > From: Sam Joseph [mailto:[EMAIL PROTECTED]] > Sent: Monday, June 10, 2002 09:34 > To: Turbine Torque Users List > Cc: Turbine Users List > Subject: Re: Weird problem with mySQL syntax on different OS > > > Following up to my earlier mail I have identified that this process of > generating a weird additional comma occurs on both Solaris and Linux, > but not on Windows. > > Basically the xxx-schema.sql file seems to being created differently on > these different OS's. > > Can anybody think of a some OS difference that would affect this SQL > generation process? > > Thanks in advance > > CHEERS> SAM > > Sam Joseph wrote: > > > Hi all, > > > > So I have created this package that includes torque and various stuff. > > I've run it on my windows box against mysql and postgre no problem. > > However when I try the same thing on a linux box (against mysql) the > > main table creation SQL seems to come out all screwy:. e,g, > > > > [torque-insert-sql] Failed to execute: CREATE TABLE KEYWORD ( > > KEYWORD_ID INTEGER NOT NULL, KEYWORD VARCHAR (255) NOT NULL, PRIMARY > > KEY(KEYWORD_ID), INDEX KEYWORD_IDX_1 (KEYWORD_ID), INDEX KEYWORD_IDX_2 > > (KEYWORD), ) > > > > [notice the trailing comma in the above] > > > > whereas on windows I get the correct form > > > > CREATE TABLE KEYWORD ( KEYWORD_ID INTEGER NOT NULL, KEYWORD VARCHAR > > (255) NOT NULL, PRIMARY KEY(KEYWORD_ID), INDEX KEYWORD_IDX_1 > > (KEYWORD_ID), INDEX KEYWORD_IDX_2 (KEYWORD)) > > > > Has anyone had any experience with something like this? > > > > The package I've created is available from > > > > ftp://www.neurogrid.net/pub/installs/torque-ng.tar.gz > > > > if you want to see any of my settings .... > > > > thanks in advance. > > > > CHEERS> SAM > > > > > > -- > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
