Hi,

I am using schema 32 for my db but apollo seems to think its schema 30..
is there a way to override this behaviour?

INFO : Setting schema to 30 for db fugu5_final on fugu-mysql.datastorage port 3306
INFO : Done initialising driver
INFO : fetching genes...
INFO : Doing initial gene fetch
ERROR: Problem fetching data: Failed to execute sql against database fugu5_final:SELECT g.gene_id, g.seq_region_id, g.seq_region_start, g.seq_region_end, g.seq_region_strand, g.analysis_id, g.type as biotype, NULL as source, g.display_xref_id, NULL as DESCRIPTION, gsi.stable_id, gsi.version, gsi.created_date, gsi.modified_date, x.display_label, exdb.db_name, exdb.status, NULL AS gene_status FROM gene g LEFT JOIN gene_stable_id gsi ON gsi.gene_id=g.gene_id LEFT JOIN xref x ON x.xref_id=g.display_xref_id LEFT JOIN external_db exdb ON exdb.external_db_id=x.external_db_id WHERE g.seq_region_id = 3524 AND g.seq_region_start <= 154185 AND g.seq_region_end >= 153186 AND g.seq_region_start >= -111086 [39.2]; nested exception is:
   java.sql.SQLException: Unknown column 'g.type' in 'field list'

Note: This message may contain confidential information. If this Email/Fax has 
been sent to you by mistake, please notify the sender and delete it 
immediately. Thank you.
_______________________________________________
apollo mailing list
[email protected]
http://mail.fruitfly.org/mailman/listinfo/apollo

Reply via email to