Changes between Version 8 and Version 9 of DespoinaLog/2010/12/08


Ignore:
Timestamp:
2010-12-08T14:16:15+01:00 (14 years ago)
Author:
antonak
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DespoinaLog/2010/12/08

    v8 v9  
    33 * org.molgenis.framework.db.!DatabaseException: Unknown column '!OntologyTerm.!__Type' in 'where clause'
    44   * Was this produced after the import ? (generate gcc, update db -> test if it is shown --> import -> test if it's there)
    5    * So this is the '''PROBLEM ''' for !OntologyTerm :
     5   * So this is the '''PROBLEM ''' for !OntologyTerm :
    66   * * mysql> describe !OntologyTerm;
    77   * +---------------+--------------------------------+------+-----+---------+----------------+
    … …  
    2929   * +---------------+--------------+------+-----+---------+----------------+
    3030   * 5 rows in set (0.01 sec)
    31    * '''SOLUTION''' 
     31   * '''SOLUTION'''
    3232     * mysql> alter table bbmri_old.!OntologyTerm change term name varchar(255) ;
    3333     * Query OK, 164 rows affected (0.32 sec)
    34      * Records: 164  Duplicates: 0  Warnings: 0
    35      *      * mysql> alter table bbmri_old.!OntologyTerm add column !__Type enum('!OntologyTerm','Species')  ; 
     34     * Records: 164  Duplicates: 0  Warnings: 0
     35     * * mysql> alter table bbmri_old.!OntologyTerm add column !__Type enum('!OntologyTerm','Species')  ;
    3636     * Query OK, 164 rows affected (0.11 sec)
    37      * Records: 164  Duplicates: 0  Warnings: 0
     37     * Records: 164  Duplicates: 0  Warnings: 0
     38     *      * mysql> alter table bbmri_old.!OntologyTerm add column termPath varchar(1024);
    3839     *
    3940   *
    … …  
    6667 * | id          | int(11)                        | NO   | PRI | NULL    |       |
    6768 * +-------------+--------------------------------+------+-----+---------+-------+
    68  * 7 rows in set (0.00 sec) *'''Note:''' See [http://gbic.target.rug.nl/trac/molgenis/wiki/WikiFormatting WikiFormatting] and [http://gbic.target.rug.nl/trac/molgenis/wiki/TracWiki TracWiki] for help on editing wiki content.Change informationComment about this change (optional):[[BR]]Tag under: ([http://gbic.target.rug.nl/trac/molgenis/tags view all tags])[[BR]] Page is read-only      Last modified by antonak, 12/08/10 13:50:50 ([http://gbic.target.rug.nl/trac/molgenis/timeline?from=2010-12-08T13%3A50%3A50%2B01%3A00&precision=second 6 minutes] ago)
     69 * 7 rows in set (0.00 sec) *'''Note:''' See [http://gbic.target.rug.nl/trac/molgenis/wiki/WikiFormatting WikiFormatting] and [http://gbic.target.rug.nl/trac/molgenis/wiki/TracWiki TracWiki] for help on editing wiki content.Change informationComment about this change (optional):[[BR]]Tag under: ([http://gbic.target.rug.nl/trac/molgenis/tags view all tags])[[BR]] Page is read-only      Last modified by antonak, 12/08/10 13:50:50 ([http://gbic.target.rug.nl/trac/molgenis/timeline?from=2010-12-08T13%3A50%3A50%2B01%3A00&precision=second 6 minutes] ago)