8 | | * Database contents cannot be shown .!; |
9 | | * 21400 ERROR [JDBCDatabase] executeQuery(select count(*) as num_rows FROM Biobank INNER JOIN Panel ON (Biobank.id = Panel.id) INNER JOIN !ObservationTarget ON (Biobank.id = !ObservationTarget.id) INNER JOIN !ObservationElement ON (Biobank.id = !ObservationElement.id) LEFT JOIN Investigation AS xref_Investigation ON xref_Investigation.id = !ObservationElement.Investigation LEFT JOIN !OntologyTerm AS xref_ontologyReference ON xref_ontologyReference.id = !ObservationElement.ontologyReference LEFT JOIN !OntologyTerm AS xref_Species ON xref_Species.id = Panel.Species LEFT JOIN !OntologyTerm AS xref_PanelType ON xref_PanelType.id = Panel.!PanelType LEFT JOIN !OntologyTerm AS xref_Category ON xref_Category.id = Biobank.Category WHERE !ObservationElement.!__Type = 'Biobank')com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bbmri.observationelement' doesn't exist |
10 | | |
11 | | |
| 8 | * Database contents cannot be shown .!; |
| 9 | * 21400 ERROR [JDBCDatabase] executeQuery(select count(*) as num_rows FROM Biobank INNER JOIN Panel ON (Biobank.id = Panel.id) INNER JOIN !ObservationTarget ON (Biobank.id = !ObservationTarget.id) INNER JOIN !ObservationElement ON (Biobank.id = !ObservationElement.id) LEFT JOIN Investigation AS xref_Investigation ON xref_Investigation.id = !ObservationElement.Investigation LEFT JOIN !OntologyTerm AS xref_ontologyReference ON xref_ontologyReference.id = !ObservationElement.ontologyReference LEFT JOIN !OntologyTerm AS xref_Species ON xref_Species.id = Panel.Species LEFT JOIN !OntologyTerm AS xref_PanelType ON xref_PanelType.id = Panel.!PanelType LEFT JOIN !OntologyTerm AS xref_Category ON xref_Category.id = Biobank.Category WHERE !ObservationElement.!__Type = 'Biobank')com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bbmri.observationelement' doesn't exist |
| 10 | * * mysql> create table !ObservationElement (id int(11) NOT NULL); |
| 11 | * Query OK, 0 rows affected (0.41 sec) |
| 12 | * |