Adding new membership type fails in 3.3.1

[palladio]

All,

Since upgrading to CiviCRM 3.3.1 on Joomla 1.5.22, when adding a new membership type we get the following error page:

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

Code: [Select]

Error Details
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']"]
)

Return to home page.

Return to home page.


Is anybody able to assist?

All help would be most appreciated.

Andrew
[/code]

[Kiran Jagtap]

Related issue is here http://issues.civicrm.org/jira/browse/CRM-7206
also we have already fixed for CiviCRM v3.3.2

could you please fire following query on your database.

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;
               
To avoid subsequent error on creating new membership type, you need to integrate this patch : http://paste2.org/p/1136880

To integrate above patch, go to CRM/Member/Form/MembershipType.php
+ sign implies : You need to add this code line.
- sign implies : You need to remove this code line.

Also fixed code will be part of CiviCRM v3.3.2 stable release, and we'll roll in next week or so.

Thanks,
Kiran