<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'><div dir='ltr'>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
<div dir="ltr">Hi,<br><br>I upgraded our Ensembl mirror from release 64 to 65. When I tried to search a gene, I got the folllowing error messages in the apache log flie:<br><br>DBD::mysql::db selectall_arrayref failed: Unknown column 'g.translation_id' in 'where clause' at .../ensembl_65/modules/EnsEMBL/Web/Factory/Search.pm line 93.<br><br>DBD::mysql::db selectall_arrayref failed: Unknown column 'g.stable_id' in 'field list' at .../ensembl_65/modules/EnsEMBL/Web/Factory/Search.pm line 93.<br><br>I changed line 523 in Search.pm FROM:<br>"SELECT concat( display_label ), '$db', 'Transcript', 'peptide' from object_xref as ox, xref as x<br>TO:<br>"SELECT concat( display_label ), '$db', 'Transcript', 'peptide' from translation_stable_id as g, object_xref as ox, xref as x<br><br> and line 530 in Search.pm FROM:<br>"SELECT distinct(g.stable_id), concat( display_label ), '$db', 'Transcript', 'peptide' from object_xref as ox, xref as x<br>TO:<br>"SELECT distinct(g.stable_id), concat( display_label ), '$db', 'Transcript', 'peptide' from translation_stable_id as g, object_xref as ox, xref as x<br><br>then the browser started working.<br><br>Is this a bug?<br><br>Thanks,<br><br>Zhibin Lu<br>Bioinformatics Support: Databases & Applications<br><br>Ontario Institute for Cancer Research <br>MaRS Centre, South Tower<br>101 College Street, Suite 800<br>Toronto, Ontario, Canada M5G 0A3<br> <br>Tel: 647-260-7944<br>Toll-free: 1-866-678-6427<br>www.oicr.on.ca<br><br></div>
</div></body>
</html>