Member Type error after upgrade

[wjm]

Running Joomla 1.15.22. 

Just did a CiviCRM upgrade from 2.2 to 3.3.1.  Got the following error:

Warning: file_put_contents(<snip>/administrator/components/com_civicrm/civicrm/packages/IDS/vendors/htmlpurifier/HTMLPurifier/Injector/AutoParagraph.php): failed to open stream: Not a directory in <snip>/libraries/joomla/filesystem/file.php on line 304

I noticed the problem was that there is already a file in the directory above name "Injector".  So, I renamed it and did the reinstall.  Then I got a similar error:

Warning: file_put_contents(<snip>/administrator/components/com_civicrm/civicrm/packages/IDS/vendors/htmlpurifier/HTMLPurifier/Language/messages/en-x-testmini.php): failed to open stream: Not a directory in <snip>/libraries/joomla/filesystem/file.php on line 304

So, like I did before, I renamed file "Language" and restarted. 

Upgrade then completed with no errors and I got this:

CiviCRM
CiviCRM component files have been UPGRADED succesfully.

Please run the CiviCRM Database Upgrade Utility now. This utility will check your database and perform any needed upgrades.

Also review the Upgrade Guide for any additional steps required to complete this upgrade.

So, I ran the database upgrade utility, and that also went fine.

CiviCRM upgrade was successful.

Email Greeting, Postal Greeting and Postal Addressee values have been stored for all contact records based on the system default formats. If you want to use a different format for any of these contact fields - you can run the provided command line script to update contacts to a different format (learn more...)

Date Input Format has been set to mm/dd/yy format. If you want to use a different format please check Administer CiviCRM » Global Settings » Date Formats.

Return to CiviCRM home page.
Have you registered this site at CiviCRM.org? If not, please help strengthen the CiviCRM ecosystem by taking a few minutes to fill out the site registration form. The information collected will help us prioritize improvements, target our communications and build the community. If you have a technical role for this site, be sure to check "Keep in Touch" to receive technical updates (a low volume mailing list).

Next, I decide to poke around the admin... I go it "Administer | CiviMember | Membership Type"

It displays properly, but I notice that I need to modify one of my types from rolling to fixed.  So I go in to the record to make the change... hit save, and get the following error:

Sorry. A non-recoverable error has occurred.
DB Error: no such field
Error Details
Database Error Code: Unknown column 'label_' in 'field list', 1054
Additional Details:

Array
(
    [callback] => Array
        (
           

• => 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.

Thoughts?

[lhsadmin]

I have the same issue with the following error code.
How I got here to the error message: 
1. Upgraded CiviCRM from 2.2 to 3.3.1 without issue (including database upgrade via Civi admin panel)
2. Added another membership type via Administer CiviCRM -->Membership Types.
3. After adding the new membership type I was not able to add another membership type or gain entry to the membership type list following Membership Types--->Membership Types or via the main menu links.

No other issues seem to be showing up after upgrade. Here's my error message...please help but know I do not understand databases. 

DB Error: no such field
Error Details
Database Error Code: Unknown column 'label_' in 'field list', 1054
Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

Code: [Select] [nofollow]

=> -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.



[Donald Lobo]

can either of u'll do the foll:

1. Enable backtrace (administer civicrm >> Global settings >> debugging)

2. do the same steps to reproduce the above error.

3. You'll see a trace of functions and files, can you copy-and-paste that trace here

thanx

lobo

[lhsadmin]

can either of u'll do the foll:

1. Enable backtrace (administer civicrm >> Global settings >> debugging)

2. do the same steps to reproduce the above error.

3. You'll see a trace of functions and files, can you copy-and-paste that trace here

thanx

lobo

Here's mine:
backTrace
<snip>administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 159
, handle,
<snip>administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 931
<snip>administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 968
<snip>administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 564
<snip>administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
<snip>administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
<snip>administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
<snip>administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
<snip>administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2421
<snip>administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 442
<snip>administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, find, 723
<snip>administrator/components/com_civicrm/civicrm/CRM/Member/Page/MembershipType.php, getFieldValue, 177
<snip>administrator/components/com_civicrm/civicrm/CRM/Member/Page/MembershipType.php, browse, 130
<snip>administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php, run, 219
<snip>administrator/components/com_civicrm/admin.civicrm.php, invoke, 77
<snip>administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 45
<snip>/libraries/joomla/application/component/helper.php, require_once, 162
<snip>administrator/includes/application.php, renderComponent, 136
<snip>administrator/index.php, dispatch, 67
<snip>administrator/index2.php, include, 14

[wjm]

I get the exact same thing.

[Donald Lobo]

There was some new code introduced in 3.3.1 to enhance that. I suspect there is something that is triggering a bug with your data set. Can you please run the following sql in your mysql db (you'll need to use mysql shell or PHPMyAdmin)

select id, name, relationship_type_id, relationship_direction from civicrm_membership_type;

can you please cut-n-paste the result from the above query

thanx

lobo

[wjm]

id Membership Id   name Name of Membership Type   relationship_type_id    relationship_direction
   Edit    Delete    1    General Membership    NULL    NULL
   Edit    Delete    2    President's Council    Array    NULL
   Edit    Delete    3    400 Club    NULL    NULL
   Edit    Delete    4    Republican Leadership Council    NULL    NULL
   Edit    Delete    5    Chairman's Council    NULL    NULL
   Edit    Delete    6    Century Club    NULL    NULL

[lhsadmin]

id   name   relationship_type_id   relationship_direction
1   name   NULL   NULL
2   name   NULL   NULL
3   name   NULL   NULL
4   name   NULL   NULL
5   name   NULL   NULL
6   name   NULL   NULL
7   name   NULL   NULL
8   name   NULL   NULL
9   Test Member1   Array   NULL

[Donald Lobo]

hmmm

not sure how that "Array" is getting into item 9 (Test Member1 or President's Council). Was this an old pre-upgrade membership type or was this created in 3.3?

if pre-upgrade, can u'll check the old DB and cut-n-paste the same values

thanx

lobo

[wjm]

From before upgrade:

id Membership Id   name Name of Membership Type   relationship_type_id FK to Relationship Type ID   relationship_direction
   Edit    Delete    1    General Membership    NULL    NULL
   Edit    Delete    2    President's Council    NULL    NULL
   Edit    Delete    3    400 Club    NULL    NULL
   Edit    Delete    4    Republican Leadership Council    NULL    NULL
   Edit    Delete    5    Chairman's Council    NULL    NULL
   Edit    Delete    6    Century Club    NULL    NULL

[wjm]

So... I went into the database and manually changed "ARRAY" to Null.  Problem went away.  Then, I went in and modified one of the member type records... got the error again, and see the "Array" type back in the field.

[Donald Lobo]

can u do the foll:

1. reset the db entry to NULL from array

2. apply the following patch: http://paste2.org/p/1136880

3. repeat the process

i cant reproduce it, hence the request

thanx

lobo

[wjm]

I'm a bit green on making changes this way.  Can you advise?

[lhsadmin]

I'm also green at doing this...learning as I go along. However the help has been great!

[wjm]

OK... I made the changes manually.  It seems to work fine now.