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) »
  • Error: The Zero amount facility is only for the valid members
Pages: [1]

Author Topic: Error: The Zero amount facility is only for the valid members  (Read 2992 times)

hhelgesen

  • I’m new here
  • *
  • Posts: 25
  • Karma: 0
    • California Jaycees
Error: The Zero amount facility is only for the valid members
September 22, 2008, 11:10:45 pm
I have created this on the Drupal Test-site [drupal.demo.civicrm.org]

I created the Price Set; Election Convention, I created the event; Election Convention

After logging out, I try to register as a non-member/non-user

Some of the registration tickets is of no charge, and when I try to complete the registration, I get this error

Quote
Please correct the following errors in the form fields below:
The Zero amount facility is only for the valid members


Is this an error, or I am just not getting it?

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: Error: The Zero amount facility is only for the valid members
September 23, 2008, 06:19:35 am
Quote
Please correct the following errors in the form fields below:
The Zero amount facility is only for the valid members

You get above error, when you have price set with zero amount.
For more details check : http://issues.civicrm.org/jira/browse/CRM-2534

Kurund
Found this reply helpful? Support CiviCRM

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: Error: The Zero amount facility is only for the valid members
September 23, 2008, 10:05:27 am

also price sets does not support "0" value pricesets. this should be considered a missing feature. I suspect we'll fix it in a 2.x / 3.x version

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

hhelgesen

  • I’m new here
  • *
  • Posts: 25
  • Karma: 0
    • California Jaycees
Re: Error: The Zero amount facility is only for the valid members
September 23, 2008, 11:33:55 am
The Interesting fact here, is that the total Event Fees is NOT zero - But there a ONE price field, that are selected that are Zero!...

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: Error: The Zero amount facility is only for the valid members
September 23, 2008, 11:39:28 am

can you reproduce this setup on our demo machine and then let us know the url of the event and what we need to do to recreate the error

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

hhelgesen

  • I’m new here
  • *
  • Posts: 25
  • Karma: 0
    • California Jaycees
Re: Error: The Zero amount facility is only for the valid members
September 23, 2008, 12:26:23 pm
Make sure you are not logged in

http://drupal.demo.civicrm.org/civicrm/event/register&id=6&reset=1&action=preview

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Error: The Zero amount facility is only for the valid members
September 23, 2008, 02:18:16 pm
Thanks for reproducing. This is a bug which hopefully will be fixed before the next distribution. You can track progress on this re-opened issue (and read my comment describing the correct / expected behavior) at:

http://issues.civicrm.org/jira/browse/CRM-2534#action_24107
Protect your investment in CiviCRM by  becoming a Member!

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Error: The Zero amount facility is only for the valid members
September 24, 2008, 01:15:00 pm
This should be fixed now. Would be great if you can retest your case with beta 6 or on the public demo. Thx!
Protect your investment in CiviCRM by  becoming a Member!

hhelgesen

  • I’m new here
  • *
  • Posts: 25
  • Karma: 0
    • California Jaycees
Re: Error: The Zero amount facility is only for the valid members
September 24, 2008, 02:54:07 pm

I tried using http://drupal.demo.civicrm.org/civicrm/event/register&id=6&reset=1&action=preview again, and I still got the error -- I am guessing it wasn't updated to Beta 6 yet?


Please correct the following errors in the form fields below:

    * The Zero amount facility is only for the valid members

hhelgesen

  • I’m new here
  • *
  • Posts: 25
  • Karma: 0
    • California Jaycees
Re: Error: The Zero amount facility is only for the valid members
September 24, 2008, 04:07:34 pm
I installed Beta 6, and was sucessfull in registering -

HOWEVER - Now I get this one:

Quote
backTrace

/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 138
, handle,
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 912
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 966
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 574
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2394
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 1587
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 144
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 862
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Contact/BAO/Query.php, executeQuery, 2779
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Contact/BAO/Contact.php, apiQuery, 882
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Contact/BAO/Contact.php, getHierContactDetails, 1081
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Event/Form/Registration/Confirm.php, createProfileContact, 712
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Event/Form/Registration/Confirm.php, updateContactFields, 372
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php, postProcess, 247
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Core/StateMachine.php, mainProcess, 166
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 63
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php, handle, 232
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php, run, 197
/var/www/cajaycees/components/com_civicrm/civicrm.php, invoke, 73
/var/www/cajaycees/components/com_civicrm/civicrm.php, civicrm_invoke, 24
/var/www/cajaycees/libraries/joomla/application/component/helper.php, require_once, 162
/var/www/cajaycees/includes/application.php, renderComponent, 124
/var/www/cajaycees/index.php, dispatch, 68

backTrace

/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 150
, handle,
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 912
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 966
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 574
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2394
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 1587
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 144
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 862
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Contact/BAO/Query.php, executeQuery, 2779
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Contact/BAO/Contact.php, apiQuery, 882
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Contact/BAO/Contact.php, getHierContactDetails, 1081
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Event/Form/Registration/Confirm.php, createProfileContact, 712
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Event/Form/Registration/Confirm.php, updateContactFields, 372
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php, postProcess, 247
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Core/StateMachine.php, mainProcess, 166
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 63
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php, handle, 232
/var/www/cajaycees/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php, run, 197
/var/www/cajaycees/components/com_civicrm/civicrm.php, invoke, 73
/var/www/cajaycees/components/com_civicrm/civicrm.php, civicrm_invoke, 24
/var/www/cajaycees/libraries/joomla/application/component/helper.php, require_once, 162
/var/www/cajaycees/includes/application.php, renderComponent, 124
/var/www/cajaycees/index.php, dispatch, 68

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    DB Error: no such field

    Database Error Code: Unknown column 'Billing-address.name' in 'field list', 1054

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
    • [1] => handle
            )

       
Code: [Select]
=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT DISTINCT(contact_a.id) as contact_id, contact_a.contact_type  as `contact_type`, contact_a.first_name  as `first_name`, contact_a.last_name  as `last_name`, contact_a.household_name  as `household_name`, IF ( contact_a.contact_type = 'Individual', NULL, contact_a.organization_name ) AS organization_name, gender.value as gender_id, gender.label as gender, individual_prefix.value as individual_prefix_id, individual_prefix.label as individual_prefix, individual_suffix.value as individual_suffix_id, individual_suffix.label as individual_suffix, `1-location_type`.id as `1-location_type_id`, `1-location_type`.name as `1-location_type`, `1-address`.id as `1-address_id`, `1-address`.street_address as `1-street_address`, `1-address`.supplemental_address_1 as `1-supplemental_address_1`, `1-address`.city as `1-city`, `1-state_province`.id as `1-state_province_id`, `1-state_province`.abbreviation as `1-state_province`, `1-email`.id as `1-email_id`, `1-email`.email as `1-email`, `Billing-location_type`.id as `Billing-location_type_id`, `Billing-location_type`.name as `Billing-location_type`, `Billing-address`.id as `Billing-address_id`, `Billing-address`.name as `Billing-address_name`, `Billing-email`.id as `Billing-email_id`, `Billing-email`.email as `Billing-email`  FROM civicrm_contact contact_a
LEFT JOIN civicrm_address `1-address` ON (`1-address`.contact_id = contact_a.id AND `1-address`.is_primary = 1) 
LEFT JOIN civicrm_address `Billing-address` ON (`Billing-address`.contact_id = contact_a.id AND `Billing-address`.location_type_id = 5) 
LEFT JOIN civicrm_state_province `1-state_province` ON `1-state_province`.id = `1-address`.state_province_id 
LEFT JOIN civicrm_email `1-email` ON contact_a.id = `1-email`.contact_id AND `1-email`.is_primary = 1 
LEFT JOIN civicrm_email `Billing-email` ON contact_a.id = `Billing-email`.contact_id AND `Billing-email`.location_type_id = 5 
LEFT JOIN civicrm_location_type `1-location_type` ON (  ( `1-address`.location_type_id = `1-location_type`.id ) OR ( `1-email`.location_type_id = `1-location_type`.id ) ) 
LEFT JOIN civicrm_location_type `Billing-location_type` ON (  ( `Billing-address`.location_type_id = `Billing-location_type`.id ) OR ( `Billing-email`.location_type_id = `Billing-location_type`.id ) )  LEFT JOIN civicrm_option_group option_group_gender ON (option_group_gender.name = 'gender') LEFT JOIN civicrm_option_value gender ON (contact_a.gender_id = gender.value AND option_group_gender.id = gender.option_group_id)  LEFT JOIN civicrm_option_group option_group_prefix ON (option_group_prefix.name = 'individual_prefix') LEFT JOIN civicrm_option_value individual_prefix ON (contact_a.prefix_id = individual_prefix.value AND option_group_prefix.id = individual_prefix.option_group_id )  LEFT JOIN civicrm_option_group option_group_suffix ON (option_group_suffix.name = 'individual_suffix') LEFT JOIN civicrm_option_value individual_suffix ON (contact_a.suffix_id = individual_suffix.value AND option_group_suffix.id = individual_suffix.option_group_id )  WHERE  ( contact_a.id = 77 )  GROUP BY contact_a.id LIMIT 0, 25  [nativecode=1054 ** Unknown column 'Billing-address.name' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT DISTINCT(contact_a.id) as contact_id, contact_a.contact_type  as `contact_type`, contact_a.first_name  as `first_name`, contact_a.last_name  as `last_name`, contact_a.household_name  as `household_name`, IF ( contact_a.contact_type = 'Individual', NULL, contact_a.organization_name ) AS organization_name, gender.value as gender_id, gender.label as gender, individual_prefix.value as individual_prefix_id, individual_prefix.label as individual_prefix, individual_suffix.value as individual_suffix_id, individual_suffix.label as individual_suffix, `1-location_type`.id as `1-location_type_id`, `1-location_type`.name as `1-location_type`, `1-address`.id as `1-address_id`, `1-address`.street_address as `1-street_address`, `1-address`.supplemental_address_1 as `1-supplemental_address_1`, `1-address`.city as `1-city`, `1-state_province`.id as `1-state_province_id`, `1-state_province`.abbreviation as `1-state_province`, `1-email`.id as `1-email_id`, `1-email`.email as `1-email`, `Billing-location_type`.id as `Billing-location_type_id`, `Billing-location_type`.name as `Billing-location_type`, `Billing-address`.id as `Billing-address_id`, `Billing-address`.name as `Billing-address_name`, `Billing-email`.id as `Billing-email_id`, `Billing-email`.email as `Billing-email`  FROM civicrm_contact contact_a
LEFT JOIN civicrm_address `1-address` ON (`1-address`.contact_id = contact_a.id AND `1-address`.is_primary = 1) 
LEFT JOIN civicrm_address `Billing-address` ON (`Billing-address`.contact_id = contact_a.id AND `Billing-address`.location_type_id = 5) 
LEFT JOIN civicrm_state_province `1-state_province` ON `1-state_province`.id = `1-address`.state_province_id 
LEFT JOIN civicrm_email `1-email` ON contact_a.id = `1-email`.contact_id AND `1-email`.is_primary = 1 
LEFT JOIN civicrm_email `Billing-email` ON contact_a.id = `Billing-email`.contact_id AND `Billing-email`.location_type_id = 5 
LEFT JOIN civicrm_location_type `1-location_type` ON (  ( `1-address`.location_type_id = `1-location_type`.id ) OR ( `1-email`.location_type_id = `1-location_type`.id ) ) 
LEFT JOIN civicrm_location_type `Billing-location_type` ON (  ( `Billing-address`.location_type_id = `Billing-location_type`.id ) OR ( `Billing-email`.location_type_id = `Billing-location_type`.id ) )  LEFT JOIN civicrm_option_group option_group_gender ON (option_group_gender.name = 'gender') LEFT JOIN civicrm_option_value gender ON (contact_a.gender_id = gender.value AND option_group_gender.id = gender.option_group_id)  LEFT JOIN civicrm_option_group option_group_prefix ON (option_group_prefix.name = 'individual_prefix') LEFT JOIN civicrm_option_value individual_prefix ON (contact_a.prefix_id = individual_prefix.value AND option_group_prefix.id = individual_prefix.option_group_id )  LEFT JOIN civicrm_option_group option_group_suffix ON (option_group_suffix.name = 'individual_suffix') LEFT JOIN civicrm_option_value individual_suffix ON (contact_a.suffix_id = individual_suffix.value AND option_group_suffix.id = individual_suffix.option_group_id )  WHERE  ( contact_a.id = 77 )  GROUP BY contact_a.id LIMIT 0, 25  [nativecode=1054 ** Unknown column 'Billing-address.name' 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 DISTINCT(contact_a.id) as contact_id, contact_a.contact_type  as `contact_type`, contact_a.first_name  as `first_name`, contact_a.last_name  as `last_name`, contact_a.household_name  as `household_name`, IF ( contact_a.contact_type = 'Individual', NULL, contact_a.organization_name ) AS organization_name, gender.value as gender_id, gender.label as gender, individual_prefix.value as individual_prefix_id, individual_prefix.label as individual_prefix, individual_suffix.value as individual_suffix_id, individual_suffix.label as individual_suffix, `1-location_type`.id as `1-location_type_id`, `1-location_type`.name as `1-location_type`, `1-address`.id as `1-address_id`, `1-address`.street_address as `1-street_address`, `1-address`.supplemental_address_1 as `1-supplemental_address_1`, `1-address`.city as `1-city`, `1-state_province`.id as `1-state_province_id`, `1-state_province`.abbreviation as `1-state_province`, `1-email`.id as `1-email_id`, `1-email`.email as `1-email`, `Billing-location_type`.id as `Billing-location_type_id`, `Billing-location_type`.name as `Billing-location_type`, `Billing-address`.id as `Billing-address_id`, `Billing-address`.name as `Billing-address_name`, `Billing-email`.id as `Billing-email_id`, `Billing-email`.email as `Billing-email`  FROM civicrm_contact contact_a
LEFT JOIN civicrm_address `1-address` ON (`1-address`.contact_id = contact_a.id AND `1-address`.is_primary = 1) 
LEFT JOIN civicrm_address `Billing-address` ON (`Billing-address`.contact_id = contact_a.id AND `Billing-address`.location_type_id = 5) 
LEFT JOIN civicrm_state_province `1-state_province` ON `1-state_province`.id = `1-address`.state_province_id 
LEFT JOIN civicrm_email `1-email` ON contact_a.id = `1-email`.contact_id AND `1-email`.is_primary = 1 
LEFT JOIN civicrm_email `Billing-email` ON contact_a.id = `Billing-email`.contact_id AND `Billing-email`.location_type_id = 5 
LEFT JOIN civicrm_location_type `1-location_type` ON (  ( `1-address`.location_type_id = `1-location_type`.id ) OR ( `1-email`.location_type_id = `1-location_type`.id ) ) 
LEFT JOIN civicrm_location_type `Billing-location_type` ON (  ( `Billing-address`.location_type_id = `Billing-location_type`.id ) OR ( `Billing-email`.location_type_id = `Billing-location_type`.id ) )  LEFT JOIN civicrm_option_group option_group_gender ON (option_group_gender.name = 'gender') LEFT JOIN civicrm_option_value gender ON (contact_a.gender_id = gender.value AND option_group_gender.id = gender.option_group_id)  LEFT JOIN civicrm_option_group option_group_prefix ON (option_group_prefix.name = 'individual_prefix') LEFT JOIN civicrm_option_value individual_prefix ON (contact_a.prefix_id = individual_prefix.value AND option_group_prefix.id = individual_prefix.option_group_id )  LEFT JOIN civicrm_option_group option_group_suffix ON (option_group_suffix.name = 'individual_suffix') LEFT JOIN civicrm_option_value individual_suffix ON (contact_a.suffix_id = individual_suffix.value AND option_group_suffix.id = individual_suffix.option_group_id )  WHERE  ( contact_a.id = 77 )  GROUP BY contact_a.id LIMIT 0, 25  [nativecode=1054 ** Unknown column 'Billing-address.name' in 'field list']"]
)

[/quote]

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: Error: The Zero amount facility is only for the valid members
September 24, 2008, 10:36:31 pm
hhelgesen:

Can you give exact steps to replicate above errors. Also try to replicate on http://drupal.demo.civicrm.org and if you are able to replicate file and issue for this in jira.

thanx

Kurund
Found this reply helpful? Support CiviCRM

hhelgesen

  • I’m new here
  • *
  • Posts: 25
  • Karma: 0
    • California Jaycees
Re: Error: The Zero amount facility is only for the valid members
September 25, 2008, 01:55:41 pm
it now works just fine on the drupal demo -

I guess that I have to re-install 2.1 beta 6 on my server, sigh
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Error: The Zero amount facility is only for the valid members

This forum was archived on 2017-11-26.