CiviCRM Community Forums (archive)

Dear,

First of all, best wishes for 2011 to the support team !

After upgrading my civicrm 3.2 to 3.3.1 yesterday (which was done 'successfully'), I wanted to update today the membership statuses (since it's the first of january).
Since previous memberships were for six months only and now a membership is one year, I wanted to update the 'membership types' for duration and membership fee. This produced the following error:  

------------------------------------------------------------------------------

Sorry, er is een onherstelbare fout opgetreden.  
DB Error: no such field
Fout Details
Database foutcode: Unknown column 'label_' in 'field list', 1054
Aanvullende gegevens:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT  id, label_  
 FROM civicrm_relationship_type
 
 WHERE (  civicrm_relationship_type.id = 0 )  
 
 
 
 [nativecode=1054 ** Unknown column 'label_' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT  id, label_  
 FROM civicrm_relationship_type
 
 WHERE (  civicrm_relationship_type.id = 0 )  
 
 
 
 [nativecode=1054 ** Unknown column 'label_' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT  id, label_  
 FROM civicrm_relationship_type
 
 WHERE (  civicrm_relationship_type.id = 0 )  
 
 
 
 [nativecode=1054 ** Unknown column 'label_' in 'field list']"]
)

Terug naar startpagina.
------------------------------------------------------------------

I found a link that the membership status 'deceased' should exist. It does and it is active.
The dutch equivalent for deceased is 'overleden'. This seems to be a separate status, and this one is not active.
I am not able to activate it though. Civicrm complains that the status already exists and that a start date is mandatory.


--------------------------------------------------------

   /civicrm/admin/member/membershipStatus

Deceased         (active)    
Overleden         (not active)

---------------------------------------------------------

Now every time I want to see or just select the membership type (by surfing to .../civicrm/admin/member/membershipType) I get the above fatal error, which made me worried.


***************************
This thread showed the solution: http://forum.civicrm.org/index.php/topic,17241.0.html though on every modification you'll have to execute the query again.
Apparently there exists a fix which will be available in the next version.

[ticket can be closed/archived]



[/code]