[ensembl-dev] Ensembl plants miss a table

[Nick Langridge]

Hi Daniel,

It looks like SQL shown in your error was dropped from the EG codebase 
for version 18-71 and above.
Please check that your eg-plugins/common dir is using 
branch-ensemblgenomes-19-72.

Specifically, check that the following file is no longer present in your 
codebase:
eg-plugins/common/modules/Bio/EnsEMBL/Compara/DBSQL/XrefAssociationAdaptor.pm

You may want to try removing/backing-up you existing eg-plugins/common 
dir and getting a fresh checkout:
cvs co -r branch-ensemblgenomes-19-72 eg-plugins/common

I hope this solves the problem.

Cheers,
Nick


On 02/08/2013 04:51, ?? wrote:
> Hi Ensembl developers
>
> Our plants mirror misses a database 
> table,'ensembl_compara_plants_19_72.gene_tree_member' which doesn't 
> exist on your ftp server.
>
>
> MSG: Cannot run '
> 	select dbprimary_acc,count(*) as cnt from gene_tree_root r
> 	join gene_tree_node n using (root_id) join gene_tree_member gm using (node_id)	
> 	join member m using (member_id)
> 	join member_xref mg on (m.gene_member_id=mg.member_id)	
> 	where r.root_id=? and mg.db_name=?
> 	group by dbprimary_acc,db_name order by cnt desc, dbprimary_acc asc
> 	' with params '261020 GO' due to error: DBD::mysql::st execute failed: Table
> 	... 'ensembl_compara_plants_19_72.gene_tree_member' doesn't exist at
> 	... /usr/local/ensembl_plants/ensembl/modules/Bio/EnsEMBL/Utils/SqlHelper.pm line 1003.
>
> Please check
>
> Thanks million.
>
> -- 
> Gang Chen
> TILSI
> Taicang Institute For Life Science Information
> Address: A2/162, Renmin South Road, Taicang, 215400, Jiangsu Province, 
> P.R.China
> Phone: (+86)512-82782588
>
>
> _______________________________________________
> Dev mailing list    Dev at ensembl.org
> Posting guidelines and subscribe/unsubscribe info: http://lists.ensembl.org/mailman/listinfo/dev
> Ensembl Blog: http://www.ensembl.info/


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20130807/19afc8fb/attachment.html>