Warning: mysql_query() [function.mysql-query]: Unable to save result set in /domains/zinc12/htdocs/lib/sql/MySQLDatabase.php on line 67
exception 'SQLQueryException' with message 'MySQL client ran out of memory' in /domains/zinc12/htdocs/lib/sql/MySQLDatabase.php:69 Stack trace: #0 /domains/zinc12/htdocs/lib/sql/MySQLDatabase.php(54): MySQLDatabase->rawQuery('? SELECT...') #1 /domains/zinc12/htdocs/lib/sql/MySQLDatabase.php(63): MySQLDatabase->bufferedQuery('? SELECT...') #2 /domains/zinc12/htdocs/lib/zinc/reporter/ZincAnnotationReports.php(640): MySQLDatabase->query('? SELECT...', Array) #3 /domains/zinc12/htdocs/lib/zinc/reporter/ZincAnnotationReports.php(1123): ZincAnnotationPhenologReport->run(Array) #4 /domains/zinc12/htdocs/browse/targets/detail.php(60): ZincAnnotationManager::targetPhenologs(Object(ZincTarget)) #5 {main}
SELECT pl.gene_sp1 AS source_gene_species, d1.phenotype AS source_description, pl.gene_sp2 AS dest_gene_species, d2.phenotype AS dest_description FROM tannotation AS ta INNER JOIN genedesc AS gd ON (ta.external=gd.genecode AND ta.extttype_fk=5) INNER JOIN phenotype AS pt ON gd.pheno_gene_id=pt.numbr INNER JOIN phenolog AS pl ON pl.gene_sp1 = pt.code INNER JOIN pheno_desc AS d1 ON pl.pheno_desc_fk=d1.phenodesc_id INNER JOIN pheno_desc AS d2 ON pl.pheno_desc2_fk=d2.phenodesc_id WHERE ta.uniprot='RENI_MACMU'