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)

lhsadmin

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
Re: Member Type error after upgrade
December 11, 2010, 04:41:30 pm
Quote from: Donald Lobo on 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


1. My Test Member1 was created after I upgraded to 3.3.
2. I change the DB entry that read Aray to NULL with success. But same issue occurs ever time I try to make a new membership type.
3. The only way I can get this issue to resolve is to delete the new membership type in my DB or to set the relationship_type_id to NULL (its default is Aray).

rixon

  • Guest
Re: Member Type error after upgrade
December 12, 2010, 02:49:51 am
I had the same problem, it applied to an upgrade from 3.2.5 to 3.3.1.  There was no data other than test data populated prior to upgrade.

The patch worked, though.  I changed the Array to NULL manually, then applied the patch.

If anyone else needs to do this, assuming the patch is saved to newmembertypes.patch, you can apply the patch with:

cd /<wwwroot>/drupal/sites/all/modules/civicrm
patch CRM/Member/Form/MembershipType.php newmembertypes.patch

Good luck!

And THANKS Lobo for the QUICK fix!  Awesome!

-Paul

wjm

  • I post occasionally
  • **
  • Posts: 88
  • Karma: 0
  • CiviCRM version: Latest
  • CMS version: Joomla (Latest)
Re: Member Type error after upgrade
December 12, 2010, 05:24:33 am
Will this fix be included in an upcoming release??

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 12, 2010, 07:25:38 am

yes, we'll test and fix this for 3.3.2

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 12, 2010, 11:02:01 am
Thank you for adding this in the next upgrade. I feel helpless as I can point out the issues but I'm not good enough at some code fixes to make changes. I'll have to wait for the update so I'm sure I don't make a code error.

I'm sure it's part of the same issue but for those reading this and trying to make changes to current membership types please consider it might not work. I just changed the amount for an existing member type and the system issued an error code when I submitted the change. However the public membership area of the site shows the change (though I have no way of seeing this from the civi admin panel as any area of the membership admin area shows a DB error).

Bottom line for those looking to update their membership types and any membership data under membership types (in Civic 3.1.1)... The change may happen but the admin panel will not allow you to work under your membership types. Again sorry for pointing our flaws without knowing how to insert some of the new code.     

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 12, 2010, 12:41:55 pm
No hassle with pointing the flaws. Submitting a detailed bug report and helping us identify and fix bugs is indeed quite important

You can help the project in other ways. One big way could be by contributing to one of the Make-It-Happen's for 3.4. A list and description of the projects is here:

http://civicrm.org/blogs/eileen/whats-happening-next-make-it-happen

You can also help the project by filling out the information on how/why/where you use CiviCRM

http://civicrm.org/civicrm/profile/create?reset=1&gid=15

lobo
« Last Edit: December 12, 2010, 12:43:57 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

malks

  • I post occasionally
  • **
  • Posts: 81
  • Karma: 7
  • CiviCRM version: 3.4.x 4.x
  • CMS version: Drupal 6.22
  • MySQL version: 5.1.x
  • PHP version: 5.3.x
Re: Member Type error after upgrade
December 14, 2010, 06:05:00 pm
Just to confirm, patch fixed the problem for me.  This was against a fresh install of 3.3.1.

Thanks,
Anthony.

Dinkie

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
Re: Member Type error after upgrade
December 17, 2010, 07:11:04 am
Quote
If anyone else needs to do this, assuming the patch is saved to newmembertypes.patch, you can apply the patch with:
cd /<wwwroot>/drupal/sites/all/modules/civicrm
patch CRM/Member/Form/MembershipType.php newmembertypes.patch

I need to ask the same question - how do you apply the patch?  I opened the file indicated but can't see that code.
Changing the 'array' in the database fixed the problem but would like to fix it more permanently.
I am working with Joomla.

Thanks

palladio

  • Guest
Re: Member Type error after upgrade
December 18, 2010, 07:07:36 am
Quote from: Donald Lobo on 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


Hello All,

I am seeing the exact same error as the others.

Can you please explain the steps to apply the patch you referred to?



Thanks so much.

Andrew

marcdeshon

  • Guest
Re: Member Type error after upgrade
January 03, 2011, 11:14:52 pm
I hate having problems like this and no support.  This is what I did to fix the problem- it worked.

1) Log into your database
(However you need to login- do it.  I use Internet By Demand, so for me I logged into my hosting control center and went to
Databases >> MySQL.  Then,  Edit button >> View Details >>  Input: Database Name + Password.)

2) Go to the Query Window
(I click on a little button that says "Query Window" when I hover over it.)

3) Paste this code in the window:

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;
4) Then click OK, or RUN, or EXECUTE, or whatever your supposed to do to get it in there.

5) Next, I go and find the file:
{CiviCRM Root}/sites/all/modules/CRM/Member/Form/MembershipType.php

6) Then, integrate this patch: http://paste2.org/p/1136880

To integrate the patch
+ sign implies : You need to add this code line.
- sign implies : You need to remove this code line.


It was a long & manual process, but it worked for me.  What I noticed is that the first steps were necessary to "reset" the database, and the second set of steps were necessary to fix the problem.  Hope this helps.

marcdeshon

  • Guest
Re: Member Type error after upgrade
January 03, 2011, 11:17:31 pm
Also, this thread was helpful:

http://forum.civicrm.org/index.php/topic,17241.0.html

Erik Hopp

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
Re: Member Type error after upgrade
January 04, 2011, 04:46:30 pm
Hi all,

I just wanted to chime in and say that I'm using Drupal 6.19 / CiviCRM 3.3.1 and I ran into this issue as well. I was attempting to update a membership from Rolling to Fixed and found the Array inserted into the Relationship Type ID field as well. Applying the patch that Lobo cited fixed the issue for me as well.

Thanks!

Erik

macdoggie

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
Re: Member Type error after upgrade
January 05, 2011, 04:10:54 pm
I wanted to report that I too experienced this issue upgrading from CiviCRM 3.12 => 3.3.1
This patch + database update from array to NULL also resolved my issue.

thanks so much for a great product and support!

wjm

  • I post occasionally
  • **
  • Posts: 88
  • Karma: 0
  • CiviCRM version: Latest
  • CMS version: Joomla (Latest)
Re: Member Type error after upgrade
January 11, 2011, 05:59:40 pm
I just upgraded to 3.3.2.  I don't see this issue (although it is possible that the file which I manually updated was not touched in the upgrade).

Can someone confirm that this was fixed?  Is there a link to the bug?

herongrace

  • I’m new here
  • *
  • Posts: 27
  • Karma: 1
Re: Member Type error after upgrade
February 09, 2011, 05:51:43 pm
Thanks everybody! This fix worked for me, too. Much appreciated!
Oh, btw, the note about significance of the the "+" and "-" at the beginning of each line in the patch was a crucial tidbit of info for me.

Thanks!
herongrace
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.