[Gmod-help] bulkfiles errors

[Barry Dancis]

Hi--

  I am using the GMODTools to unload a genome for submission to genbank. I am getting the error:
  
  DBD::Pg::st execute failed: ERROR:  column "chromosome" does not exist
LINE 19:   featcv.name in ( chromosome )    
                            ^ at lib/Bio/GMOD/Bulkfiles.pm line 2464.

I printed the query and got a similar error when executing it with psql. If I added quotes to give:

   featcv.name in ( 'chromosome' )

the query worked just fine. It seems to me the query generator should have added the quotes as opposed to requiring the quotes to be in an xml file. My question is which pm and what line is where the ${golden_path} in the sql query is replaced so that I can modify it to add quotes to the replacement if they are not already there?

I am also getting the error:

DBD::Pg::db do failed: ERROR:  syntax error at or near "0"
LINE 22:     and (cv.name in ( ARRAY(0x8b39e9c) ))
                                     ^ at lib/Bio/GMOD/Bulkfiles.pm line 2376.

and when I look at the actual query text, there are 3 different subqueries which have that error. 
Seaching the xml's, I found 4 places in chadogenepagessql.xml, all with the form:

    and (cv.name in ( ${featureprops} ))

Obviously, the array is not being converted into a quoted, comma separated list as is required. Can someone point me to the place in the code where the substitution is occurring so that I can fix it.

Thanks,

Barry

ps It's been almost a week since I changed my email address on Sourceforge to barry.dancis at digiconasp.com, but it is still going to my old address. It there somewhere else that I have to change it.

B^)