Hi, This is not a tool from our distribution. Please send questions about local instances, core galaxy development, or your own tool development to the galaxy-dev@lists.bx.psu.edu mailing list and *not* this galaxy-user mailing list. That said, if you could provide more information about what's going on here (structure of getsitesnotoverlap_tf, etc) I might be able to give a few pointers. Thanks! -Dannon On Feb 15, 2012, at 3:28 AM, La Chi wrote:

hi, will you please help me how can i fix this error' thanks

Traceback (most recent call last): File "/galaxy-dist/tools/ova/getsitesnotoverlap_tf.py", line 60, in ? if __name__ == "__main__": __main__() File "/galaxy-dist/tools/ova/getsitesnotoverlap_tf.py", line 50, in __main__ result_set = connection.execute( "select * from getsitesnotoverlap_tf (" + userid + "," + tfid + "," + bpover + "," + ch + "," + sf +")" ) File "/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.4.egg/sqlalchemy/engine/base.py", line 824, in execute return Connection.executors[c](self, object, multiparams, params) File "/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.4.egg/sqlalchemy/engine/base.py", line 888, in _execute_text return self.__execute_context(context) File "/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.4.egg/sqlalchemy/engine/base.py", line 896, in __execute_context self._cursor_execute(context.cursor, context.statement, context.parameters[0], context=context) File "/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.4.egg/sqlalchemy/engine/base.py", line 950, in _cursor_execute self._handle_dbapi_exception(e, statement, parameters, cursor, context) File "/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.4.egg/sqlalchemy/engine/base.py", line 931, in _handle_dbapi_exception raise exc.DBAPIError.instance(statement, parameters, e, connection_invalidated=is_disconnect) sqlalchemy.exc.ProgrammingError: (ProgrammingError) column "chr1" does not exist LINE 1: select * from getsitesnotoverlap_tf (6,149,-1000,chr1,tf) ^ 'select * from getsitesnotoverlap_tf (6,149,-1000,chr1,tf)' {}

___________________________________________________________ The Galaxy User list should be used for the discussion of Galaxy analysis and other features on the public server at usegalaxy.org. Please keep all replies on the list by using "reply all" in your mail client. For discussion of local Galaxy instances and the Galaxy source code, please use the Galaxy Development list:

http://lists.bx.psu.edu/listinfo/galaxy-dev

To manage your subscriptions to this and other Galaxy lists, please use the interface at:

http://lists.bx.psu.edu/