CiviCRM Community Forums (archive)

3.4.7 - Configured a membership price set and used it on a contribution page. When I try to submit the contribution page, I get a form validation message:

Please correct the following errors in the form fields below:

Please select one of the memberships.

Even though I've selected one of the membership options. Can't get past it.

Noticed this page referenced some possible issues with already setup contribution pages: http://wiki.civicrm.org/confluence/display/CRMDOC40/Membership+Price+Sets

So I tried starting with a brand new contribution page, but get the same result.

The problem may be that once you select 'use Membership PRice Set' the section showing your Memberships collapses - so this is an improvement that needs to be made in the code - i suggest you temporarily unselect 'use membership price set' - choose the Memberships you want to use - then reselect the Price Set.
Hope that makes sense since I am writing from memory

Sorry that wasn't the solution Jay.

Kurund - can you look at the issue of being able to set a Membership Contribution Page to be using a Membership Price Set even though no Memberships are selected.

You can see this here on demo
http://drupal.demo.civicrm.org/civicrm/admin/contribute/amount?action=update&reset=1&id=2
If I don't select any Membvership Types and do select the Membership Price Set, then I do not get a warning but the form fails when user tries to join
Database Error Code: Unknown column 'hugi' in 'where clause', 1054
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] =>
SELECT       count( pfv.id ) AS count, pfv.id AS id
FROM         civicrm_price_field_value pfv
INNER JOIN    civicrm_membership_type mt ON mt.id = pfv.membership_type_id
WHERE        pfv.id IN ( hugi )
GROUP BY     mt.member_of_contact_id [nativecode=1054 ** Unknown column 'hugi' in 'where clause']
    [type] => DB_Error
    [user_info] =>
SELECT       count( pfv.id ) AS count, pfv.id AS id
FROM         civicrm_price_field_value pfv
INNER JOIN    civicrm_membership_type mt ON mt.id = pfv.membership_type_id
WHERE        pfv.id IN ( hugi )
GROUP BY     mt.member_of_contact_id [nativecode=1054 ** Unknown column 'hugi' in 'where clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT       count( pfv.id ) AS count, pfv.id AS id
FROM         civicrm_price_field_value pfv
INNER JOIN    civicrm_membership_type mt ON mt.id = pfv.membership_type_id
WHERE        pfv.id IN ( hugi )
GROUP BY     mt.member_of_contact_id [nativecode=1054 ** Unknown column 'hugi' in 'where clause']"]
)
I think the problem is that the PriceSet is selected before the membership types and causes the membership types table to disappear - should the Price Set be shown below the Member Types table so this isn't so confusing to admin.

so i have it working on one site with 3.4.7 but i may have set up that Price Set/membership when it was 3.4.6 - but cloning that working one and saving results in all the Membership Types that were set being lost.

Bug?

dang - my bad - it was the 'make a radio button' option in the price set - i hadn't done that bit - and of course because I had already created a Text/Numeric I wasn't seeing the 'membership' options.

Scenario is Club joins up but pays on a per capita basis.

So I have made a $0 for the Club membership and done the per capita as a numeric @ $10 each - and now  just have to hide the Club $0 since it is the only option and is required/default.

Sweet - sorry for messing with your mind.