Error in Membership Types

[Miami Digital]

Running on Drupal 6.20. I started getting this error after I let autocomplete fill in the organization it belonged to without selecting it through the select button. When I went to add another membership type. The following error occurred:

Sorry. A non-recoverable error has occurred.
DB Error: no such field

Code: [Select]

Database Error Code: Unknown column 'label_' in 'field list', 1054
Additional Details:
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']"]
)
Can anyone please direct me in how to correct this issue? I don't want to start tinkering this the db as am a noob when it comes to civicrm. =/ Thanks in advance guys.[/code]

[Kiran Jagtap]

here is the related thread : http://forum.civicrm.org/index.php/topic,17241.msg72971.html#msg72971

kiran

[Miami Digital]

Code: [Select]

UPDATE  civicrm_membership_type
SET  relationship_type_id = NULL,  relationship_direction = NULL
WHERE  relationship_type_id = 'Array' OR relationship_type_id IS NULL;
Sure Enough. That fixed it. Kiran, your the best. I thank you!

[Miami Digital]

Something I have to add, Now every time I add a new membership type. The error happens again. I run the script again and it clears.

[Kiran Jagtap]

you need to integrate php patch also to avoid errors on new membership type add.

No worry, we are about to roll CiviCRM v3.3.2 stable ( might be tomorrow )
and which has all corrected code.

kiran

[Miami Digital]

Any word on the 3.3.2 stable code release?

[Donald Lobo]

sometime in the next week or so

lobo