Changes between Version 14 and Version 15 of DespoinaLog/2010/12/08

Timestamp:

2010-12-08T15:01:20+01:00 (14 years ago)

Author:

antonak

Comment:

--

DespoinaLog/2010/12/08

@@ -1 +1 @@
  * When importing bbmri mysql table , table structures change --> exception .
    * [http://www.abbeyworkshop.com/howto/lamp/MySQL_Export_Backup/index.html Try to export / import one table at a time] :  mysqldump5 -u root -p bbmri biobank >biobank.mysql / mysqldump5 -u root -p bbmri_old biobank >biobank.mysql /  mysql5 -u root -p bbmri < biobank.mysql / mysql5 -u root -p bbmri < ontologyTerm.mysql
+
+== Inconsistency with !OntologyTerm table  ==
  * org.molgenis.framework.db.!DatabaseException: Unknown column '!OntologyTerm.!__Type' in 'where clause'
    * Was this produced after the import ? (generate gcc, update db -> test if it is shown --> import -> test if it's there)
@@ -39 +41 @@
 === '''mysql> update  !OntologyTerm set !__Type="!OntologyTerm"''' ===
 === '''problem solved ! ''' ===
- * 
- * * mysql> describe biobanks;
+== Inconsistency with Biobanks table  ==
+* mysql> describe biobanks;
+
  * ERROR 1146 (42S02): Table 'bbmri.biobanks' doesn't exist
  * mysql> describe biobank;
@@ -69 +72 @@
  * +-------------+--------------------------------+------+-----+---------+-------+
 
-Missing fields :          id          name         Investigation         ontologyReference         Individuals         Species         PanelType         FounderPanels         Acronym         Institutes         Publications         Category         Type         Contacts         Topics         Materials         Size         LastUpdate         Description
+=== But according to the model this is the complete list of fields : ===
+===  *  id 
+ * name 
+ * Investigation 
+ * ontologyReference 
+ *  Individuals 
+ *  Species 
+ * PanelType 
+ * FounderPanels 
+ *  Acronym 
+ *  Institutes 
+ *  Publications 
+ *  Category 
+ *  Type 
+ *  Contacts 
+ *  Topics 
+ *  Materials 
+ *  Size 
+ * LastUpdate 
+ *  Description
+
+ ===