Warning (2): pg_query() [function.pg-query]: Query failed: ERROR:  column Publication.journal_id does not exist at character 101 [CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 152]

Warning (512): SQL Error: ERROR:  column Publication.journal_id does not exist at character 101 [CORE/cake/libs/model/datasources/dbo_source.php, line 512]

Query: SELECT COUNT(*) AS "count" FROM "publication" AS "Publication" LEFT JOIN "journal" AS "Journal" ON ("Publication"."journal_id" = "Journal"."id") LEFT JOIN "protein_target" AS "Target" ON ("Publication"."target_id" = "Target"."csgid_id")  WHERE 1 = 1    
Warning (2): pg_query() [function.pg-query]: Query failed: ERROR:  column Publication.journal_id does not exist at character 3230 [CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 152]

Warning (512): SQL Error: ERROR:  column Publication.journal_id does not exist at character 3230 [CORE/cake/libs/model/datasources/dbo_source.php, line 512]

Query: SELECT "Publication"."id" AS "Publication__id", "Publication"."pmid" AS "Publication__pmid", "Publication"."authors" AS "Publication__authors", "Publication"."title" AS "Publication__title", "Publication"."journal_short" AS "Publication__journal_short", "Publication"."issn" AS "Publication__issn", "Publication"."year" AS "Publication__year", "Publication"."vol" AS "Publication__vol", "Publication"."pages" AS "Publication__pages", "Publication"."center" AS "Publication__center", "Publication"."target_id" AS "Publication__target_id", "Publication"."pdb_id" AS "Publication__pdb_id", "Publication"."type" AS "Publication__type", "Publication"."status" AS "Publication__status", "Publication"."source" AS "Publication__source", "Publication"."remark" AS "Publication__remark", "Publication"."verified" AS "Publication__verified", "Publication"."frozen" AS "Publication__frozen", "Publication"."times_cited" AS "Publication__times_cited", "Publication"."times_cited_update" AS "Publication__times_cited_update", "Publication"."inserted" AS "Publication__inserted", "Publication"."updated" AS "Publication__updated", "Journal"."short" AS "Journal__short", "Journal"."full_name" AS "Journal__full_name", "Journal"."issn" AS "Journal__issn", "Journal"."impact_factor" AS "Journal__impact_factor", "Target"."id" AS "Target__id", "Target"."csgid_id" AS "Target__csgid_id", "Target"."locus_tag" AS "Target__locus_tag", "Target"."ncbi_gi" AS "Target__ncbi_gi", "Target"."ncbi_accession" AS "Target__ncbi_accession", "Target"."ncbi_taxon_id" AS "Target__ncbi_taxon_id", "Target"."ncbi_geneid" AS "Target__ncbi_geneid", "Target"."gene_name" AS "Target__gene_name", "Target"."common_name" AS "Target__common_name", "Target"."sequence" AS "Target__sequence", "Target"."sequence_length" AS "Target__sequence_length", "Target"."dna_sequence" AS "Target__dna_sequence", "Target"."tigr_main_role_id" AS "Target__tigr_main_role_id", "Target"."tigr_sub_role_id" AS "Target__tigr_sub_role_id", "Target"."comment" AS "Target__comment", "Target"."justification" AS "Target__justification", "Target"."priority" AS "Target__priority", "Target"."project" AS "Target__project", "Target"."selection_phase" AS "Target__selection_phase", "Target"."date_selected" AS "Target__date_selected", "Target"."date_approved" AS "Target__date_approved", "Target"."completion_code" AS "Target__completion_code", "Target"."tms" AS "Target__tms", "Target"."sp" AS "Target__sp", "Target"."core_genome" AS "Target__core_genome", "Target"."gram_minus_gene_homolog" AS "Target__gram_minus_gene_homolog", "Target"."gram_plus_gene_homolog" AS "Target__gram_plus_gene_homolog", "Target"."protease_motifs" AS "Target__protease_motifs", "Target"."glycosyl_group_metabolism" AS "Target__glycosyl_group_metabolism", "Target"."cell_wall" AS "Target__cell_wall", "Target"."drug_target_homologs" AS "Target__drug_target_homologs", "Target"."virulence_genes" AS "Target__virulence_genes", "Target"."essential_genes_homologs" AS "Target__essential_genes_homologs", "Target"."dna_binding_motifs" AS "Target__dna_binding_motifs", "Target"."inserted" AS "Target__inserted", "Target"."updated" AS "Target__updated" FROM "publication" AS "Publication" LEFT JOIN "journal" AS "Journal" ON ("Publication"."journal_id" = "Journal"."id") LEFT JOIN "protein_target" AS "Target" ON ("Publication"."target_id" = "Target"."csgid_id")  WHERE 1 = 1    LIMIT 20
Publications
Home    Target List    Selection    Community Requests    XML files    Progress    Homolog Search    Statistics

Publications

Page 0 of 1, showing 1 records out of total, starting on record 0, ending on 

Warning (2): Invalid argument supplied for foreach() [APP/views/publications/index.ctp, line 33]
Pmid Authors Title Journal Issn Year Vol Pages Center Target Pdb Status Times Cited
<< previous
|
next >>