CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Member Type error after upgrade
Pages: [1] 2

Author Topic: Member Type error after upgrade  (Read 6115 times)

wjm

  • I post occasionally
  • **
  • Posts: 88
  • Karma: 0
  • CiviCRM version: Latest
  • CMS version: Joomla (Latest)
Member Type error after upgrade
December 11, 2010, 07:36:42 am
Running Joomla 1.15.22. 

Just did a CiviCRM upgrade from 2.2 to 3.3.1.  Got the following error:
Quote
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:

Quote
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:

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

Quote
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:

Quote
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’m new here
  • *
  • Posts: 7
  • Karma: 0
Re: Member Type error after upgrade
December 11, 2010, 08:52:29 am
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]
=> -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

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Member Type error after upgrade
December 11, 2010, 10:01:12 am

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
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

lhsadmin

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
Re: Member Type error after upgrade
December 11, 2010, 10:10:14 am
Quote from: Donald Lobo on December 11, 2010, 10:01:12 am

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 post occasionally
  • **
  • Posts: 88
  • Karma: 0
  • CiviCRM version: Latest
  • CMS version: Joomla (Latest)
Re: Member Type error after upgrade
December 11, 2010, 10:11:24 am
I get the exact same thing.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Member Type error after upgrade
December 11, 2010, 10:34:19 am

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
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

wjm

  • I post occasionally
  • **
  • Posts: 88
  • Karma: 0
  • CiviCRM version: Latest
  • CMS version: Joomla (Latest)
Re: Member Type error after upgrade
December 11, 2010, 10:37:28 am
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

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
Re: Member Type error after upgrade
December 11, 2010, 11:05:48 am
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

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Member Type error after upgrade
December 11, 2010, 11:16:27 am

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
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

wjm

  • I post occasionally
  • **
  • Posts: 88
  • Karma: 0
  • CiviCRM version: Latest
  • CMS version: Joomla (Latest)
Re: Member Type error after upgrade
December 11, 2010, 11:48:23 am
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

  • I post occasionally
  • **
  • Posts: 88
  • Karma: 0
  • CiviCRM version: Latest
  • CMS version: Joomla (Latest)
Re: Member Type error after upgrade
December 11, 2010, 11:51:55 am
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

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Member Type error after upgrade
December 11, 2010, 01:43:25 pm
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
« Last Edit: December 11, 2010, 01:58:58 pm by Donald Lobo »
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

wjm

  • I post occasionally
  • **
  • Posts: 88
  • Karma: 0
  • CiviCRM version: Latest
  • CMS version: Joomla (Latest)
Re: Member Type error after upgrade
December 11, 2010, 02:01:01 pm
I'm a bit green on making changes this way.  Can you advise?

lhsadmin

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
Re: Member Type error after upgrade
December 11, 2010, 02:48:44 pm
I'm also green at doing this...learning as I go along. However the help has been great!

wjm

  • I post occasionally
  • **
  • Posts: 88
  • Karma: 0
  • CiviCRM version: Latest
  • CMS version: Joomla (Latest)
Re: Member Type error after upgrade
December 11, 2010, 03:56:37 pm
OK... I made the changes manually.  It seems to work fine now.
Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Member Type error after upgrade

This forum was archived on 2017-11-26.