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 »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Membership status table - both English and local entries
Pages: [1]

Author Topic: Membership status table - both English and local entries  (Read 739 times)

Ed van Leeuwen

  • I post occasionally
  • **
  • Posts: 68
  • Karma: 1
  • CiviCRM version: 4.7
  • CMS version: Drupal 7.x
  • MySQL version: MariaDB 10
Membership status table - both English and local entries
August 08, 2010, 01:39:28 am
I have had trouble filtering only the current members for some time. Cause of this is that in the membership status table I had Dutch entries along with English entries (e.g. 'huidig' and 'current'). The members originally were given a Dutch status, but the interface now only shows the English variant. So a search did not give any results.

As the English entries have a higher record number, I think it went wrong in the process upgrading from 3.0 to 3.1.

I will try to solve this via the database. Please let me know if I overlooked anything in upgrade notes or that I should report it as a bug.

Ed van Leeuwen

  • I post occasionally
  • **
  • Posts: 68
  • Karma: 1
  • CiviCRM version: 4.7
  • CMS version: Drupal 7.x
  • MySQL version: MariaDB 10
Re: Membership status table - both English and local entries
August 08, 2010, 02:00:53 am
Solved this by issueing 'update member_ship set status_id = x where status_id = y'. x should be one of the new entries, y the corresponding old entry.

(Note that renaming the old ones to English does not do the trick.)

Ed van Leeuwen

  • I post occasionally
  • **
  • Posts: 68
  • Karma: 1
  • CiviCRM version: 4.7
  • CMS version: Drupal 7.x
  • MySQL version: MariaDB 10
Re: Membership status table - both English and local entries
August 22, 2010, 07:40:03 am
Still would like to know though how to get the status descriptions in Dutch. Anyone have a suggestion?

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: Membership status table - both English and local entries
August 22, 2010, 09:26:12 am

i suspect this is a bug in the core code base and will need a fix there. If you can take a look at the code and figure out what we need to change please do submit a patch

if you can file an issue with detailed steps on how to reproduce it (i.e. we should use an internal handle name, rather than the label) that would be great and very helpful

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

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Membership status table - both English and local entries

This forum was archived on 2017-11-26.