<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>