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 CiviEvent (Moderator: Yashodha Chaku) »
  • Changing event subscription not possible?
Pages: [1] 2

Author Topic: Changing event subscription not possible?  (Read 4073 times)

BarisArt

  • Guest
Changing event subscription not possible?
February 27, 2008, 07:26:24 am
Hi all,

if I subscribe (by off-line subscription) a contact to an event, eveything seems fine. I select an amount to pay and record the payment.

All changes later on, by example the registration status, are inpossible.
The options for Event Fee are disabled (which is ok) but there is not one having a value.

Therefore, when I try to submit the form, I get the message that the field Price is empty (which I can't select, because it's disabled).
I cannot generate this in the Sandbox. Can anyone tell my why this error could occur?

See screenshot (in Dutch).

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Changing event subscription not possible?
February 27, 2008, 03:48:19 pm
Did you modify the "label text" for any of the Event Fee options? This would cause the behavior you're seeing (i.e. no apparent selection for Event Fee on an existing event registration record).

By the way, I think the fact that changing the Event Fee label "breaks" the visual link in this screen is probably a bug... but I don't think there's a quick fix for it so it is unlikely to get fixed in 2.0.
Protect your investment in CiviCRM by  becoming a Member!

BarisArt

  • Guest
Re: Changing event subscription not possible?
February 28, 2008, 02:41:27 am
Hi Dave,

I don't think I did. Isn't this just the translation of the label?

I noticed some strange values when I viewed the source of the page (HTML). Mention all the empty <tr> tags..

Code: [Select]
<tr>
  <td class="label"><label>Evenement bedrag(en)</label></td>
</tr>
<tr>
  <td class="label"><label>Contributie zeilkamp</label></td>
  <td><table class="form-layout-compressed">
      <tr> </tr>
      <tr> </tr>
      <tr> </tr>
      <tr> </tr>
      <tr> </tr>
      <tr> </tr>
      <tr> </tr>
      <tr> </tr>
      <tr> </tr>
      <tr>
        <td class="labels font-light">
        <td><tt>( )</tt>Normale contributie&nbsp;-&nbsp;€ 162.50</td>
      </tr>
      <tr> </tr>
      <tr>
        <td class="labels font-light">
        <td><tt>( )</tt>Contributie met recht op subsidie&nbsp;-&nbsp;€ 117.50</td>
      </tr>
      <tr> </tr>
      <tr>
        <td class="labels font-light">
        <td><tt>( )</tt>Leiding&nbsp;-&nbsp;€ 0.00</td>
      </tr>
      <tr> </tr>
    </table></td>
</tr>
<tr>
  <td class="label">&nbsp;</td>
  <td class="description">Event Fee Level (if applicable).</td>
</tr>

Is this normal behaviour?

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Changing event subscription not possible?
February 28, 2008, 10:56:45 am
Ok - based on that HTML snippet - it looks like you're using the "Price Set" functionality for this event - and the foreach loop on the price set fields is spitting out a bunch of empty values. I'll play with this a bit from here to see if I can recreate a general bug in 2.0. But I think the best bet is for you to setup the Price Set / Price Set fields on our demo and see if you can recreate the problem / bug.

You could also add some debug statements to the template  and php files used to render this form, and see if that gives some clues:

templates/CRM/Event/Form/Participant.tpl
CRM/Event/Form/Participant.php
Protect your investment in CiviCRM by  becoming a Member!

BarisArt

  • Guest
Re: Changing event subscription not possible?
February 29, 2008, 01:39:51 am
Hi Dave,

I setup the Price Fields in the Sandbox and here happens the same problem.

Here are the price fields and I created a subscription for this participant.

If I select a price option, and save the subscription, all looks ok. However, when I edit the subscription afterwards, the selected Price Field has not been preselected. If I have already Recorded the Payment, I get the same result as my first topic (see attachment).

Try it yourself. Create a priceset, add some Options (radio) and attach it to an event.
Now create a subscription for a contact and try to edit that subscription afterwards. Won't work.

I hope you can find the bug. Thanks for all your help!

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Changing event subscription not possible?
February 29, 2008, 03:15:30 am
We created similar scenario on demo.

Price set:
 http://drupal.demo.civicrm.org/civicrm/admin/price/field/option?action=browse&reset=1&sid=1&fid=1

Participant record:
http://drupal.demo.civicrm.org/civicrm/contact/view/participant?reset=1&action=update&id=53&cid=104&context=participant

Seems to be working fine.  Sandbox is running on trunk(few things might be broken), so can you please check this on demo ( which is on v2.0 branch)

thanx

kurund
Found this reply helpful? Support CiviCRM

BarisArt

  • Guest
Re: Changing event subscription not possible?
February 29, 2008, 04:31:28 am
Hi Kurund,

thanks for your fast reply.
Indeed it's working on this installation.

So please tell me, what could I do to get my problem solved? Re-install the current CiviCRM?
Wait untill the next release?

Thanx,

Baris

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Changing event subscription not possible?
February 29, 2008, 04:38:34 am
If you don't care too much about data, best way would be uninstall current CiviCRM version and install CiviCRM v2.0beta3

Otherwise follow : http://civicrm.org/node/296

HTH

kurund
Found this reply helpful? Support CiviCRM

BarisArt

  • Guest
Re: Changing event subscription not possible?
March 06, 2008, 02:42:29 am
Hi guys,

Today I updated CiviCRM to beta5, but the Price field problem still occurs.

I reproduced it in Demo, please see http://drupal.demo.civicrm.org/civicrm/contact/view/participant?reset=1&action=update&id=68&cid=106&context=participant

On this participants event overview, the Fee level has the right value (Mango), but if I edit the registration, no price option is selected.

I checked the database and tried to find where the key of this option is saved. Strangely, if I check the table civicrm_participant there is no column with a link to the selected price option. What I see is a column 'event_level', which stores the label for the price option. The data in this field is the label surrounded by a strange space (wider than a space, smaller than a tab). Maybe this is the cause of the problem? (eg. 'Normale contributie')

Please help! Is there a change that I can browse the Demo database to see if I can find differences with mine?

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Changing event subscription not possible?
March 06, 2008, 03:06:26 am
We will investigate and get back to you.

thanx

kurund
Found this reply helpful? Support CiviCRM

BarisArt

  • Guest
Re: Changing event subscription not possible?
March 26, 2008, 05:18:41 am
Kurund,

did you find anything? The problem still occurs on my installation. I made a fresh install of 2.01 and transferred the data. Because it works on the demo (http://drupal.demo.civicrm.org/civicrm/contact/view/participant?reset=1&action=update&id=52&cid=105&context=participant), it should have anything to do with my settings. I tried to track down where the selected price field is saved, but I cannot find it in the database.

Can anyone here explain me how the selected price field (from a price set) on a offline registration is saved in the database? The only thing I can find is the field 'event level' in the table civicrm_participant.

Quote
event_level: Populate with the label (text) associated with a fee level for paid events with multiple levels. Note that we store the label value and not the key.

So this can't be it..
« Last Edit: March 26, 2008, 05:22:32 am by BarisArt »

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Changing event subscription not possible?
March 26, 2008, 10:44:03 am
Check the civicrm_line_item table which stores the detailed values for  price set contribution and event registration (participant) items. Hopefully the values there will give some clues.
Protect your investment in CiviCRM by  becoming a Member!

BarisArt

  • Guest
Re: Changing event subscription not possible?
March 26, 2008, 02:44:50 pm
Hmm,

this could be the problem!
It contains 3 values of entity civicrm_contribution, but the entity_id values doesn't exist in the table contributions (old contributions, already deleted).

All three records have 'option_group_id' value 0.

It seems that no new records are added to line_item. What could cause this problem? Can it have anything to do with my currency settings? Or translation?

Thanks, we're finally getting near the cause of the problem!

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Changing event subscription not possible?
March 27, 2008, 08:43:01 am
I think you'll need to go through the steps of creating a new instance of your problem case, checking the DB state each step of the way, in order to narrow this down further. We have had some instances where the code wasn't handled a translation configuration properly (i.e. using English strings to control conditional operations etc.) - so that could be it.
Protect your investment in CiviCRM by  becoming a Member!

pidex

  • Guest
Re: Changing event subscription not possible?
February 27, 2009, 08:26:18 am
Hi guys

I have the same issue whenever someone register from front and if I edit the particiapnt from backend I dont get the selected package for registration..

Please can anyone let me know is there any solutions for this. My Live site is on crucial stage. we have live registraion are going on and I am not able to udpate some of the parameters like notes from backend for that particular particiapnt.

Thanks
Hemal

Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Changing event subscription not possible?

This forum was archived on 2017-11-26.