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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Configuring fees
Pages: [1]

Author Topic: Configuring fees  (Read 482 times)

sustperf

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 3.23
  • CMS version: Drupal
  • MySQL version: 5.2.13
  • PHP version: 5.0.92
Configuring fees
June 09, 2011, 07:29:38 am
Hello,

I am brand new to CiviCRM, attempting what seems like it should be a straightforward change: we had a discount set called "early registration" set to expire on June 2 when I realized the date really needed to be June 9. I clicked the calendar to change the date and saved the change, but now I get the following error when attempting to register for the event:

"Sorry. A non-recoverable error has occurred...is not of type String"

I have tried several fixes, including removing the discount altogether, but the only way I can get the registration to come up is by using an alternate, existing Price Set (the alternate price set isn't actually the right one for this event - I was just trying it for test purposes).

I would really appreciate suggestions!

Thanks,

Kai

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Configuring fees
June 09, 2011, 10:17:34 am
Sounds like a bug. However I wasn't able to recreate it on the current stable version (3.4.2). Assuming you're using the default Input Date settings (dates are formatted as MM/DD/YYYY after you select them in the calendar) - then it looks like this has been fixed in recent version(s).

If you need an immediate fix and have the ability to access your database via phpMyAdmin or mysql command line - then you can update the discount end date 'manually' in the DB.

You need to update the end_date column in the civicrm_discount table, using the format YYYY-MM-DD
2011-06-09

Using phpMyAdmin, you can do this in your web browser. Otherwise assuming you only have one event discount set the currently expires on June 2, you can use this query:

UPDATE civicrm_discount
SET end_date = '2011-06-09'
WHERE end_date = '2011-06-02';
Protect your investment in CiviCRM by  becoming a Member!

sustperf

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 3.23
  • CMS version: Drupal
  • MySQL version: 5.2.13
  • PHP version: 5.0.92
Re: Configuring fees
June 09, 2011, 12:20:57 pm
Thanks a lot Dave. I was able to resolve it by creating a work around pricing set, but I am glad to know about the manual edit option you outlined below in case I encounter this again.

Cheers,

Kai

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Configuring fees

This forum was archived on 2017-11-26.