<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Daniel,<br>
<br>
It looks like SQL shown in your error was dropped from the EG
codebase for version 18-71 and above.<br>
Please check that your eg-plugins/common dir is using
branch-ensemblgenomes-19-72.<br>
<br>
Specifically, check that the following file is no longer present in
your codebase:<br>
eg-plugins/common/modules/Bio/EnsEMBL/Compara/DBSQL/XrefAssociationAdaptor.pm<br>
<br>
You may want to try removing/backing-up you existing
eg-plugins/common dir and getting a fresh checkout: <br>
cvs co -r branch-ensemblgenomes-19-72 eg-plugins/common<br>
<br>
I hope this solves the problem.<br>
<br>
Cheers,<br>
Nick<br>
<br>
<br>
<div class="moz-cite-prefix">On 02/08/2013 04:51, 陈岗 wrote:<br>
</div>
<blockquote
cite="mid:CABjKtWZYAx+1gtFWPEMiO0q7yePKkrtG6ParJy+eJcmuhdjUwg@mail.gmail.com"
type="cite">
<div dir="ltr">Hi Ensembl developers
<div><br>
</div>
<div>Our plants mirror misses a database table,'<span
style="color:rgb(85,85,85);font-family:'Courier
New',Courier,monospace;font-size:13px">ensembl_compara_plants_19_72.gene_tree_member'
which doesn't exist on your ftp server.</span></div>
<div><span style="color:rgb(85,85,85);font-family:'Courier
New',Courier,monospace;font-size:13px"><br>
</span></div>
<div><span style="color:rgb(85,85,85);font-family:'Courier
New',Courier,monospace;font-size:13px"><br>
</span></div>
<div>
<pre class="" style="font-family:'Courier New',Courier,monospace;font-size:13px;margin-top:0px;color:rgb(85,85,85)"><pre class="" style="font-family:'Courier New',Courier,monospace;margin-top:0px">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.</pre></pre>
</div>
<div><font color="#555555" face="Courier New, Courier,
monospace"><br>
</font></div>
<div><font color="#555555" face="Courier New, Courier,
monospace">Please check </font></div>
<div><font color="#555555" face="Courier New, Courier,
monospace"><br>
</font></div>
<div><font color="#555555" face="Courier New, Courier,
monospace">Thanks million.<br>
</font>
<div><br>
</div>
-- <br>
<div><font face="verdana, sans-serif" size="1">Gang Chen</font></div>
<div><font face="verdana, sans-serif" size="1">TILSI</font></div>
<div><font face="verdana, sans-serif" size="1"><span
style="background-color:rgb(255,255,255)">Taicang
Institute For Life Science Information</span><br
style="background-color:rgb(255,255,255)">
<span style="background-color:rgb(255,255,255)">Address:
A2/162, Renmin South Road, Taicang, 215400, Jiangsu
Province, P.R.China</span><br
style="background-color:rgb(255,255,255)">
<span style="background-color:rgb(255,255,255)">Phone:
(+86)512-82782588</span></font></div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Dev mailing list <a class="moz-txt-link-abbreviated" href="mailto:Dev@ensembl.org">Dev@ensembl.org</a>
Posting guidelines and subscribe/unsubscribe info: <a class="moz-txt-link-freetext" href="http://lists.ensembl.org/mailman/listinfo/dev">http://lists.ensembl.org/mailman/listinfo/dev</a>
Ensembl Blog: <a class="moz-txt-link-freetext" href="http://www.ensembl.info/">http://www.ensembl.info/</a>
</pre>
</blockquote>
<br>
<br>
</body>
</html>