Why do registrants see the error "...List has no rows for assignment to SObject" on the confirmation page?

Situation

Website visitors successfully register for an event but are shown the following error on the confirmation page:

Salesforce Error: sbxe1.sbx_EventsCampaignMember: execution of AfterInsert caused by: System.QueryException: List has no rows for assignment to SObject (sbxe1)

Soapbox creates a Lead in Salesforce but this Lead remains unconverted and not associated with a Campaign.

Solution

It is likely that you are using the Nonprofit Success Pack v2 with the Contacts Settings > Account Model set to "Individual" but no "Individual" Account record exists.

To resolve this:

1. Go to the Accounts tab
2. Click New
3. Create a new account with the title of "Individual"
4. Click Save

That should do the trick! To test, you can attempt to convert an existing Lead by adding it to the appropriate Campaign associated with your Soapbox Event.

For more information of Nonprofit Success Pack Account models, check out NPSP: What is an Account Model? from Salesforce.org.