How can I add my Wordpress Site's template to my contribution page? I have a contribution page located here: http://pghchoralarts.org/civicrm/?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=1

I haven't gone through the entire process of testing the PayPal integration yet, but one thing I am having a bit of trouble with is figuring out how to incorporate the rest of my Wordpress theme into this page.  Right now the page is an incomplete, unstyled HTML document, and I want to be able to essentially wrap my WordPress theme around it. Is there a fairly straightforward way to do this?

EDIT: I have narrowed down my issue to the fact that wp_head() in civicrm.php does not get called when it should. I have verified that CiviCRM_For_WordPress->wp_head gets added as a hook in the main wp_head(), but my theme does not call it when the main WordPress wp_head() is called. When I switch to twentyfifteen theme, the wp_head() function in civicrm.php gets called as expected. Any ideas on what may be going wrong?

Sorry, I don't have enough reputation to comment.

As Jon says, you need to go to CMS Database Integration

www.example.com/wp-admin/admin.php?page=CiviCRM&q=civicrm/admin/setting/uf&reset=1

There you have the WordPress users table and the WordPress base page, I would suggest to create an empty page named CiviCRM - slug 'civicrm' and use that page as your base page in the menu mentioned above.

This should be the default behaviour when you install Civi, as Civi automatically creates this page and sets it as the default base page, more info about this here.


Merging contacts not working I am trying to merge 2 contacts (individuals). I search for the contact, select both contacts and select merge. Go through the options. A message saying: Contacts Merged, Name has been updated. Contact ID 1951 has been deleted.

The contacts are not merged and no contacts are deleted.

The log file in ConfigAndLog has this message:

[error] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => exceptionHandler
        )

[code] => -5
[message] => DB Error: already exists
[mode] => 16
[debug_info] => UPDATE  civicrm_account_contact  SET contact_id = 1951 , accounts_contact_id = '2bd64d12-13b0-4188-a708-430aa0bb8f5b' , accounts_display_name = 'Neil T - 1501' , last_sync_date = 20191018151509 , accounts_modified_date = 20191018000000 , accounts_data = 'Array' , accounts_needs_update = 0 , connector_id = 0 , plugin = 'xero' , do_not_sync = 0   WHERE (  civicrm_account_contact.id = 2598 )   [nativecode=1062 ** Duplicate entry '1951-0-xero' for key 'contact_id_plugin']
[type] => DB_Error
[user_info] => UPDATE  civicrm_account_contact  SET contact_id = 1951 , accounts_contact_id = '2bd64d12-13b0-4188-a708-430aa0bb8f5b' , accounts_display_name = 'Neil T - 1501' , last_sync_date = 20191018151509 , accounts_modified_date = 20191018000000 , accounts_data = 'Array' , accounts_needs_update = 0 , connector_id = 0 , plugin = 'xero' , do_not_sync = 0   WHERE (  civicrm_account_contact.id = 2598 )   [nativecode=1062 ** Duplicate entry '1951-0-xero' for key 'contact_id_plugin']
[to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="UPDATE  civicrm_account_contact  SET contact_id = 1951 , accounts_contact_id = '2bd64d12-13b0-4188-a708-430aa0bb8f5b' , accounts_display_name = 'Neil T - 1501' , last_sync_date = 20191018151509 , accounts_modified_date = 20191018000000 , accounts_data = 'Array' , accounts_needs_update = 0 , connector_id = 0 , plugin = 'xero' , do_not_sync = 0   WHERE (  civicrm_account_contact.id = 2598 )   [nativecode=1062 ** Duplicate entry '1951-0-xero' for key 'contact_id_plugin']"]

)

Using latest version of Drupal + Civi

It seems to be an issue with xero (I'm assuming it's an extension/plugin that you have enabled on your site)?

If you are using fuzion's extension, you might want to check if it's already logged as an issue or if there is a solution already

https://github.com/eileenmcnaughton/nz.co.fuzion.civixero


Can we report on contributions by payment processor? Is there support for filtering contribution reports by payment processor?

We have credit card (Authorize.NET) and PayPal (new). How can I report on just PayPal transactions?

The only difference I see is in the transaction ID format. Both payment methods say 'credit card' on the contribution.

There are no such reports in CiviCRM that will filter Contribution by Payment Processor. Payment Processor and Payment Method have different meaning. Payment method can be used by N processor. Here are some solutions

Going forward have your system to use unique payment method for a payment processor with same name and then you can filter the report using Payment method. So that in future it can be tracked easily using payment method. However, for historical data I won't recommend you to update the Payment method since you will need to update in two tables i.e civicrm_contribution.payment_instrument_id and civicrm_financial_trxn.payment_instrument_id. Changes to civicrm_financial_trxn might impact on Bookkeeping entries for those which are exported in batch and closed for accounting period.
Build a custom report for contribution having Payment processor as filter and/or column.
Use AlterReportVar hook to add filter and/or column for existing contribution reports and build query accordingly.

The basic query to retrieve contribution done using payment processor is

SELECT cc.id FROM civicrm_contribution cc
  INNER JOIN civicrm_entity_financial_trxn ceft
    ON ceft.entity_id = cc.id
      AND ceft.entity_table = 'civicrm_contribution'
  INNER JOIN civicrm_financial_trxn cft
    ON cft.id = ceft.financial_trxn_id
WHERE cft.payment_processor_id = 1;


Unable to enable CiviCase When I try to enable CiviCase I get a white screen of death and the following msg:

"A fatal error was triggered: Could not create the MySQL views for CiviCase. Your mysql user needs to have the 'CREATE VIEW' permission"

I cannot find any way to add this permission in PhpAdmin. What should I do?

RESOLVED thanks to help from Hershel:
Unable to enable CiviCase - Definer v Invoker problem maybe

The solution was to enable remote connections for the specific MySQL database.


Scheduled reminders and memberships Looking for a quick answer from someone who may have done this before I spend hours of testing.

I am implementing a "Family" membership where members of family will get the inherited membership of the paying member based on a relationship that I created. This works really well. The paying member shows a membership "Family". The members of the family show a membership "Family (by relationship)".

I want to schedule a reminder for the paying member to renew their family membership, but don't want to send the reminder to the members of the family (some of them are children and while they may have email addresses entered into their record, they shouldn't get emails for membership renewals).

So... if I create a scheduled reminder based on the Family membership, will the (by relationship) members get the reminder?

I'm running CiviCRM 4.7.47 on WordPress 4.9.5

You might be able to use the "Limiting or adding to your recipient" setting and use a smart group to only include primary members or some fairly complicated smart group that pulls only those that are paying members

https://docs.civicrm.org/user/en/latest/email/scheduled-reminders/#limiting-or-adding-to-your-recipient-list


CiviContribute Component Settings not saving settings beyond Enable Tax and Invoicing option I am setting up a fresh install (CiviCRM 5.24.5 / WordPress 5.4.1) but found that once I 'Enable Tax and Invoicing' within CiviContribute Component Settings no changes are saved on that page (I am trying to save changes to the due date, notes, tax term, and tax display settings) other than the 'Enable Tax and Invoicing' option (and I get the settings saved notification).

I am very new to this and have been working my way through using the docs (https://docs.civicrm.org/user/en/latest/contributions/sales-tax-and-vat/) and have set up Financial Account for Sales Tax/VAT just in case but to no effect.  Everything appears to be working normally.

While I want the invoicing, as a small charity we are below the VAT threshold and the VAT rate is set to zero, though setting to 20 makes no difference in the VAT/Sales Tax Financial Account.

I believe this is a regression: follow along here (and do report you're seeing this as well): https://lab.civicrm.org/dev/core/-/issues/1712

And it has been fixed (missed closing it).

You will want to upgrade your CiviCRM to either 5.24.6 or 5.25.0 (we're not sure when the fix went in).


Event white screen of death when user registers for an event I upgraded to CiviCRM 4.6.4 on Joomla 3.4.2 after a year on older versions. I've cloned a previously working but expired event. Registration from the back-end works fine but from the front-end gives this error:

  Fatal error: Call to undefined method CRM_Core_Payment_Form::setPaymentFieldsByProcessor() in /home/***/www/www/administrator/components/com_civicrm/civicrm/CRM/Event/Form/Registration.php on line 388

If I make it an unpaid event (Configure Fees with Paid Event = No), I get a different error:

  Fatal error: Call to undefined method CRM_Core_Payment_Form::buildPaymentForm() in /home/***/www/www/administrator/components/com_civicrm/civicrm/CRM/Core/Payment/ProcessorForm.php on line 114

Advice please!

I solved it.  There seems to be a conflict in this version (Civicrm 4.6.4) with the following extensions:

GoCardless
Smart Debit
UK Direct Debit

When I disabled all three, the problem went away.  One of these extensions must be using the same method call.


CiviCRM Events (WP) - error message "this contact has already been assigned to this event" Getting the error message "civicrm error message Please correct the following errors in the form fields below: This contact has already been assigned to this event."

Oddly, this record is my own. I'm wondering if it's BECAUSE I created the event that I can't add myself. I am the Civi admin.

My name doesn't come up in any registered attendee report and when searching my own record, I am not recorded as being registered to the event. But I can't add myself, either. See below.

Here's what it looks like when I try to add:

So, I'm stumped! It's not life or death, but insights are appreciated in the event it crops up with other contacts as this event progresses. If it crops up with another contact, that could affect the event headcount.

Thanks,

L.

This could be the outcome if you did a 'test' registration.

You can search for 'test' via Find Participants.

If you did, it is possible this would block you from registering again.


CiviMobile “unknown error” on Wordpress I'm trying to use Civimobile but can't sign-on.  I get "unknown error".  I'm using WordPress 5.2.2, PHP 7.2 and CiviCRM 5.15.1.  I installed Civi CRM Api Fix. plugin 1.0.0, and CiviMobileAPI extension 4.0.

I followed the advice in this post Does CiviMobileAPI generate any logs? and install the CiviCRM WP REST API plug-in.  I also renamed the extension directory name so it is just "com.agiliway.civimobileapi".

What else should I do?

Do you have this one?
https://github.com/mecachisenros/civicrm-wp-rest
Or the old one?
This is the updated one and you need this one to work.
(also check the ext directory for civimobileapi make sure that it doesn't include master or anything else)


What is the purpose of the active / disabled buttons for campaigns? I feel like this answer will be super obvious, but I'm unable to find an answer in Civi's documents.  I feel like the campaign status sums up the state of the campaign so I'm just wondering what info the active / disabled fields capture.

Thanks all!

This is so that you can temporarily or permanently remove a campaign from being selected. If you have say 30 campaigns and 20 of them are completed, you don't really want them cluttering up the drop down lists when you create events etc. You only want the active campaigns.


Registration confirmation email uses wrong From email address I use Civi 4.7.27 on Drupal.

When using the back-end form to register a contact to an event, and checking the 'Send Confirmation' checkbox, then the 'Receipt From' email address shown is not the one I want.

I tried to change the general Civi's default 'From Address' to the one that I want, but this did not affect this address.

Where is this email address defined to be the default one for sending registration confirmation emails from?

Clarification - when a user registers by himself using the online registration form, he does receive the confirmation email from the correct address, as it is defined in the 'Online Registration' tab of the event configuration page. The problem only happens for manual back-end registrations.

The email address which is used by default as the 'Receipt From' address, in the 'Register Participant' back-end form is the FIRST email address (with the highest order) defined in the 'FROM Email Addresses' list. NOT the one that is marked as default.

Moving the address I wanted to use by default, to be the first one on the list - solved the problem.


Bounce processing - will fail for G Suite users when Google disables less secure apps in Feb 2021 Google have announced they are stopping support of less secure apps in G Suite in Feb 2021. No new LSA connections will be allowed after Jun 2020.

Google have advised me that the email accounts I'm using for Bounce Processing and Email-to-Activity Processing are affected by this.

Google's advice is "For any other LSA, contact your admin or ask the developer of the app you are using to start supporting OAuth".

Are there any plans for CiviCRM to support connecting to IMAP or POP using OAuth authentication?

Here's a potential workaround for anyone who can set up a non-G-Suite IMAP account. I haven't implemented or tested this.

Continue using your G Suite email address - it has your domain name and Google does SPAM etc processing
Forward email to your non-G-Suite account
Use this second account for Bounce Processing


civicrm login form for individual users How to create a login for individual users in civicrm using WordPress (like membership login)?
Can anyone say how to create it? For this below screenshot i want to create login for users.

1) Create/Edit a profile... In the advance settings:

WordPress user account registration option? = Account Creation required

2) In the profile listing. click More > User Profile Create Mode

This page (for a non-logged in user) should have account (login) creation.


saving mapping fields I have just saved fields for exporting to a new saved mapping field, but it is not coming up as an option when I go back into the database and try to export the same details for another group. I'm clicking "done" after chosing to save the mapping field so I don't know why it doesn't then appear as an option.

1.Check if the actual mapping is saved - /civicrm/admin/mapping?reset=1

(Tip – Mappings only get saved/updated once you physically hit the export button)

2.The use a saved field mapping, the drop down will only appear if you select the “Select fields for export"


Configuring cron using PHP cli method results in Permission denied Centos 7 with selinux set to permissive. Using apache as the user and confirmed apache has execute permissions to the folder and file in plugins/civicrm/civicrm/bin/cli.php

The crontab entry -

1 * * * * apache /etc/php.ini var/www/domainfolder/public_html/wp-content/plugins/civicrm/civicrm/bin/cli.php -s domain.com -u wpuser-cron -p wordpresspasswordhere -e Job -a execute

The error generated is -

X-Cron-Env: <SHELL=/bin/bash>
X-Cron-Env: <PATH=/sbin:/bin:/usr/sbin:/usr/bin>
X-Cron-Env: <MAILTO=root>
X-Cron-Env: <HOME=/usr/share/httpd>
X-Cron-Env: <LOGNAME=apache>
X-Cron-Env: <USER=apache>
Date: Fri, 12 Aug 2016 15:01:01 -0400 (EDT)
Status: RO

/bin/bash: /etc/php.ini: Permission denied

Running it as the user apache definitely seems wrong. I did so just to see that I could get the cron job running properly; then revisit selinux settings to deal with creating a group with the correct permissions and a cron user for this job.

This cron job calls /etc/php.ini as the command, but that file is not an executable (it's the default configuration file for PHP).

(The "Permission denied" error is the same as if you asked "run the script README.TXT" - the file doesn't have exec bit set because it's not a program at all.)

Try this -

1 * * * * apache /usr/bin/php /var/www/example.org/public_html/wp-content/plugins/civicrm/civicrm/bin/cli.php -s domain.com -u wpuser-cron -p wordpresspasswordhere -e Job -a execute

Your PHP path may not actually be /usr/bin/php, so check the correct path by typing which php at a commandline and use that.

  Running it as the user apache definitely seems wrong.

This is OK. It means that CiviCRM when executed from cron and from the web will generate files using the same user - CiviCRM can have issues when it hits file access issues between multiple users, so using a single user for both www and cron is the simplest solution.


Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame When a user tries to create a new membership from the front end we are getting this:

DB Error: already exists
Return to home page.

Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame thrown in /home1/.../public_html/wp-content/plugins/civicrm/civicrm/Civi/Core/Transaction/Manager.php on line 107

When I try to create the membership manually from CiviCRM Dashboard it just churns. This was working until the latest update 4.6.8. We are running Wordpress.

Renewals seem to be unaffected for administrators and for unavailable for others.

I was able to narrow this down to the Member ID extension. Disabled that and the DB Error resolved it's self. ONE member is unable to renew at this time, but I can process manually


How do I find all my Smart Groups, as a type? I can search by Group name under Contacts -> Manage Groups -> Find but that does not find Smart Groups unless 'smart' is part of the name I created for the Group. How can I find all Groups of type Smart Groups?

Curious as to what your use case for this is.

This is currently not part of group search. I suspect its an easy modification to add a checkbox to group search to include (or exclude) smart groups (along with any other criteria mentioned)

The DB query changes to enable this is relatively easy (column saved_search_id is NULL / NOT NULL)

lobo


Auto fill credit card billing name and address information for civicrm event registrant - webform-civicrm integration Is it possible to auto fill the credit card fields when a person registers for an event using the webform-civicrm integration module?

(Clarified that information needed was billing name and address information, not credit card details)

This information can be automatically filled in if the registrant is logged into the website (and has a valid Civi record attached to their website account), or by sending invitation emails with a checksum token inside.

Unfortunately I don't think there is a "same as above" checkbox on the event registration form.


How can I setup a Manage Magazine Subscriptions in CiviMember I'm new to this CiviCRM and it looks great so far. We are looking to using it in out Magazines. But we need the functions as per blog below. How can we do this? thanks.

https://civicrm.org/blog/johnd/civicrm-manage-magazine-subscriptions

Sorry guys, I did not explain it clearly. Basically We have a lot of magazines published every two months. The way we determine what magazine our subscribers can get is by issue number. For example if a subscriber is entitled 1 year of magazine, we will tag him as issue 110-115 (via custom fields). Now, the problem is these issue numbers are associated with a month and year of publish.

Wow! I'm impress to this community!. Thanks for the help!

we (Fuzion) worked with John Derry when getting The Monthly going as a Sub on CiviCRM. There was a lot of nuances they needed particularly involving ensuring that Gift Sub reminders went to the original Giftor etc, etc. I think that since that time they have had internal resources to further finesse their subs process in ways that I cannot explain, but potentially someone at The Monthly could.

But in essence yes you can treat a Subscription as a Membership.

If you detail out really clearly what the exact specs are you need then folk may be able to volunarily help you assess how to achieve this in CiviCRM or you can reach out to one of the Partners for professional advise and support (and customisations/extensions if required).

NOTE: The OP referred to Joomla, for readers who are using Drupal CMS, there are also significant workarounds that can be achieved with either Drupal Webforms or with CiviCRM Entity in terms of finessing the subscription process for the user.

Hope that helps


Can I influence the activity source contact with the membership API Create action? In my project I am using a scheduled job to get street recruitment data from a csv file and create a new membership with the API if required. When the membership is created, an activitiy is also automatically created using the logged in user as the activity source contact. Does anyone know if I can influence this activity source contact with the API?
My workaround is changing the activity once it is generated with the post hook. Works, but is a bit hackish :-)

At this point, no, at least as long as you aren't using the API as the member him/herself.  The relevant line is https://github.com/civicrm/civicrm-core/blob/4.6/CRM/Activity/BAO/Activity.php#L1886:

// create activity with target contacts
$session = CRM_Core_Session::singleton();
$id = $session->get('userID');
if ($id) {
  $activityParams['source_contact_id'] = $id;
  $activityParams['target_contact_id'][] = $activity->contact_id;
}

Basically, CRM_Member_BAO_Membership::create calls CRM_Activity_BAO_Activity::addActivity, and the code above just forces the source contact to be whoever's logged-in.

Ironically, just a few lines above, the activity source contact is set to be the ID set in the contact_id property of the activity object passed to the function from the membership, but this overrides it.


What is the CiviCRM LTS Version, and should I use it or the latest stable release? On the CiviCRM download page there is an LTS version underneath the current one. What's the difference, and which should I use?

LTS stands for Long Term Stable version. It is intended for use on more conservative sites that are more concerned with having a stable CiviCRM environment than with having access to the latest features in CiviCRM. You should decide which type of site yours is.

The LTS version contains all fixes for security vulnerabilities that affect the software, and many but not all of the bug fixes that are available in the stable version. As mentioned, it does not contain the new features made available in more recent versions.

The LTS version tends to be one or two minor versions behind the latest stable version. So a little while after 4.5 was released as the latest stable version, the LTS version switched from 4.2 to 4.4, skipping 4.3. Similarly, in late 2015 likely after 4.7 came out, 4.6 became the LTS version, skipping 4.5. Now that it is April 2016, the expectation is that 4.7 could become the next Long Term Stable release after 4.6, in anticipation of significant changes in 5.0.
But the final decision on this won't likely be made until late 2016 / early 2017.

The benefits of using the LTS (long term stable) release are:

There are fewer unknown bugs in the software since it has been used extensively for a long time.
Upgrading within one release branch like 4.2 or 4.4 is less likely to require extra effort or cause problems than upgrades from 4.2 to 4.3, or 4.4 to 4.5.

Downsides to using LTS include:

Not having access to the features available in more recent versions of CiviCRM.
Not having access to extensions or releases of extensions that are only available for more recent versions of CiviCRM.
Not having access to some bug fixes that are included in more recent versions of CiviCRM (usually ones that are not important or that require a lot of work to backport).


PayPal and Failing IPN's Issues I am currently having issues with PayPal communicating with our website and CiviCRM. Half of the recurring contributions have not shown up over the past couple months and every one-time donation has listed as "Pending/Incomplete Transaction over the past week. Our current version of Civi is 4.4.3. We have checked the URLs and our web host has white-listed all IPN's even though they don't think anything was being blocked. We have also applied a few patches of code from newer versions and we are still having issues. Is anyone else having this problem. This is a bit out of the scope of my knowledge. Thanks.

Does Paypal insist on an SSL certificate? Maybe yours is not compliant?


Is CiviCRM resource intensive? I need to plan requirements for multiple instances of CiviCRM as a Drupal module.

My goal is to "more or less" know how many sites would I be able to put in a single application server (with dedicated database server) with 4 cores CPU and 16 GB memory.

It's tempting to discard this question as being too vague to give an accurate answer to, but capacity planning is a real and difficult challenge.

Is CiviCRM resource intensive?  That depends what you compare it with - compared to a static site, yes.

A CiviCRM site with a few users occasionally looking up a contact needs far fewer resources than one with hundreds of users using it all day long for complex reports.

Are your multiple sites likely to have similar workloads?  Will the sites be used concurrently?  What virtualisation/containerisation are you using?  What memory requirements are there besides Civi?  What other resources might be contended - like network bandwidth or storage?

You could look at the specs offered by the various CiviCRM hosting providers and see what configurations they have arrived at based on their experience of hosting a large number of mixed sites.  If you search this site you will find a few recommendations of 2GB for a VPS.

There are some critical limits, eg if the php memory limit is too low then processes abort, but mostly things "go slow" rather than fail if you try to put "too much" on a server so determining how many sites you can put on your box involves understanding acceptable performance.

In practice, you probably just need to try it and see.  Monitor your resource utilisation and perceived performance and see what effect adding another site has.

Alternatively, use a hosting provider and pay them to figure it out :-)


Howto import CAMT053 XML with CiviBanking Is somebody importing CAMT053 XML from ING or another bank?

We want to import bank statements from ING, a Dutch bank.
ING can export to CSV, but that export does not contain postal adresses.
The CAMT053 XML does.

Maybe you can try the Belgian format. See https://github.com/Project60/org.project60.banking/blob/6dd79b42941eea6e89ba8e8b6475af418fddb2ad/configuration_database/importer/xml/BE_CAMT53_v2.json  . Some discussion about this file can be found at https://github.com/Project60/org.project60.banking/issues/132 .


View mailing in browser- access denied CiviCRM 5.3 (at the moment), Drupal 7.63 Mosaico Ext- 2.0-beta4.1528762072

View Mailing as browser link from emails working fine for logged in users, not for anon

Given view public mailing content prmission to all users. Flushed Civi and drupal caches

Still no access for anon users (yup, it's set as public pages)

Only new factor for me here is the mosaico extension. Anyone else had similar issues? know where else I can look?

Turns out clicking Save when you change permissions really helps.

Craig


Views integration - Missing handler for custom fields on relationships broken since upgrade to 4.7.15 I have a report in views that pulls data from custom fields on a relationship between two contacts.

Since an upgrade to 4.7.15 It is no longer displaying that data and on opening the view I see that the fields have the notice "missing handler"

I've cleared caches and ensured that the Drupal database is fully updated and so on.

Could this may be another symptom of: CRM-19545. PR-417

Can anyone shed light or suggests steps to resolve?

Just ran into the issue when upgrading from 4.7.13 to 4.7.16. Spent way too much time trying to figure it out and far too many views data cache clears/drush cc all.

In case anyone runs across this having the same problem, this is a direct link to the revert patch mentioned above: CRM-19545: Revert CRM-18776 to get back missing custom fields


Getting Groups Associated with Campaigns using REST API CiviCampaign allows you to 'include group(s)' as a part of a Campaign. Is there a way to 'get' which groups have been associated for a given campaign ID using the REST API? The GET API for Campaign doesn't provide this information.
(Sample result below of a GET for Campaign)
{

"is_error": 0,
"version": 3,
"count": 1,
"id": 9,
"values": [
    {
        "id": "9",
        "name": "AAA",
        "title": "AAA",
        "start_date": "2020-10-19 13:35:00",
        "campaign_type_id": "5",
        "is_active": "1",
        "created_id": "202",
        "created_date": "2020-10-19 13:36:07",
        "last_modified_id": "202",
        "last_modified_date": "2020-10-19 13:36:07"
    }
]}

You can download and install Campaign Group API3 extension, this extension should provide Campaign Group api which you can either use as chain api in Campaign api or you can use base as Campaign Group api and fetch all details of campaign by doing join on.
HTH
Pradeep


CiviContribute adding $200 even to every transaction CiviCRM 5.24.4/WP 5.4

Some freakish behavior going on with CiviContribute and Stripe processing. Based on Stripe logs, it looks like its originating with CiviContribute. Everything worked for at least one test transaction before I upgraded to 5.24.4, but, despite several restores and reconfigurations, I haven't been able to charge the right amount.

Here's the deal: if a user opts to make a $25 contribution, CiviContribute sends the charge to Stripe as $225. If they opt for $100, the charge is $300. Exactly $200 every time. Pretty weird.

Problem turned out to be js conflicts with Themefy popup messing up the js files in civicrm.

Disabling the plugin from /wp-admin/plugins.php?plugin_status=all&paged=1&s removes this problem and contributions go through to Stripe as intended


Custom activity types do not appear in report filter When creating a report from a template (specifically the Activity Report) custom case types are not available in the filter list.

In our case, we were creating custom Activity Types and selecting used for "Cases Only."

If we change this to "Contacts and Cases," they appear in the filter list.


CiviMail doesn't save when using Checksum event links Running CiviCRM 5.10.4 and Drupal 7.65.

Trying to send out a bulk email through CiviMail using a checksum link for an event registration.

However when I insert the checksum link, I get an error message when CiviMail tries to autosave, or when I try to manually save:

Sorry an error occurred and your information was not saved

This is the checksum link I'm trying to insert

https://DOMAIN.com/civicrm/event/register?reset=1&id=89&cid={contact.contact_id}&{contact.checksum}

I've also tried with:

https://DOMAIN.com/civicrm/event/register?reset=1&id=89&{contact.checksum}&cid={contact.contact_id}

Have tried testing to save with every move I make when making the email, and have isolated the issue to only happening when I try to use these links (whether it's an image linked to this URL, or text).

I've checked and that is the correct event ID in the URL. I've tried inserting the link in the source code and in the WYSIWYG editor but neither are allowing me to save. I've tried writing out the URL in notepad and copying over from there in case any formatting is being pulled through somehow, but again no luck.

Any idea on where we're going wrong or how to fix this?

Cheers

EDIT: On more investigation, it allows me to save the email when I use the following link. However this creates an extra "cs=" in the URL so the checksums don't work....

The URL I've used this time is:

https://DOMAIN.com/civicrm/event/register?reset=1&id=89&cid={contact.contact_id}&cs={contact.checksum}

I just had this exact same problem.  (I'm on Version 5.25.0, posting over a year later, so an upgrade would not have been the answer)
What "fixed" my problem was to change the order of the parameters so that the checksum parameter was first after the ?
https://DOMAIN.com/WEBFORM?{contact.checksum}&cid1={contact.contact_id}
instead of:
https://DOMAIN.com/WEBFORM?cid1={contact.contact_id}&{contact.checksum}
It is odd that the checksum token inserts "cs=" before it, which breaks the URL validation.


Can't find HTML Snippet in Profiles (Joomla) I'm trying to add a newsletter sign-up form to an external* (Joomla) website. The guidance I've found online says that I should go to Customize » CiviCRM Profile, then click 'More' on right and select 'HTML Form Snippet', but it isn't there.

Does anybody know where it is?

*The CiviCRM installation is under a different Joomla site to the public one where the form's going.

You need to enable remote profiles.  Administer menu » System Settings » Misc.  Unfortunately, from your screenshot I see that you're running Civi 4.7.14.  That version has a known bug, where remote profile setting can't be changed.

I would recommend upgrading to the latest 4.7 (this is a good idea anyway; 4.7.14 has known security bugs), then enable remote profile submission.


I am receiving a "Network Error: Unable to reach the server" error when I try to edit a contact via "edit address" button When I use the "Show Javascript" console, the following error line has appeared: "Failed to load resource: the server responded with a status of 403 (Forbidden)" followed by this url: "http://www.domainname.org/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fajax%2Finline"

Running CiviCRM 5.17.3 via Wordpress

ConfigAndLog reveals nothing.

Given that it's a 403 error, I would check to see if WordFence (or similar "security" plugin for WordPress) is the cause by temporarily disabling it (ideally on a test site).  If you're using Apache, it may be a rogue .htaccess file causing the problem.


Clearing A Report - Contribution Summary I clicked on 'Contribution Details' report and it had a general list of names from my last time playing with it. I clicked on a specific name I wanted to do a report for and tweaked the settings to me needs. Now, I want to change just the contact ID for this report with the same settings. However, there does not appear to be a way to change the contact ID or go back to the original list of names. I want to know how I can clear the settings entirely and/or at least change the contact ID. I already checked the filters section and the contact ID is not listed here to change.

Basically, I am trying to print of the donation history for each of our board members, but I cannot seem to do this from their contact page so trying from this report.

What you have written doesn't make sense to me as when I click on a name in the contribution detail report I am taken through to the contact's record not to a somewhere I can tweak report settings.

You also haven't stated what verion of CiviCRM you are using. The report UI changed dramatically in 4.6 so if you are using a version early than that these instruction won't apply.

Those aside, go to Administer > Civireport > Create new Report from template and select the contribution details report. Filter on the name of one of the board members and tweak the settings to show what you want.

Once you are happy with report, open the title and format tab to give you new report a name and then go to the Access tab to choose where to put in the navigation menu and control access if needed. Then click on the  Create Report button.

You now have a new report instance where changing the name filter will give you an individual report for each board member.

Aside: CiviCRM likes to use names rather than contact ids to identify contacts, perhaps this was a conscious decision not to reduce people to numbers.


What is the best place to update Wordpress user on Contact change I want to update the corresponding fields (i.e. first name, last name) of a wordpress user every time the linked contact is changed either on the frontend or the admin area. I saw in the CiviCRM admin area the same field can be changed in quite few places so is there a hook or something that can be used?

I believe you are looking for something like this:

CiviCRM WordPress Profile Sync

  The CiviCRM WordPress Profile Sync plugin keeps the "First Name", "Last Name", "Email Address" and "Website" fields of a WordPress (and BuddyPress) user profile in sync with the corresponding fields of a CiviCRM contact. The synchronisation takes place regardless of whether the changes are made in WordPress, BuddyPress or CiviCRM.

I guess you could extend that plugin if you want to include CiviCRM custom fileds.

Hope that helps.


Call to undefined function civicrm_initialize() in sites/all/modules/contrib/civicrm_entity/civicrm_entity.module:488 I've just updated Drupal core (to 7.75) and found my site was stuck in maintenance mode, even after it was unticked in configuration. I've had this before and always been able to get round it with a cache clear. Now though, the site won't load to let me clear the cache though the UI. I've been trying to do it through Drush and am getting the following:
Fatal error: Call to undefined function civicrm_initialize() in ~/public_html/sites/all/modules/contrib/civicrm_entity/civicrm_entity.module on line 488
Drush command terminated abnormally due to an unrecoverable     [error]
error.
Error: Call to undefined function civicrm_initialize() in
~/public_html/sites/all/modules/contrib/civicrm_entity/civicrm_entity.module,
line 488
Drush was not able to start (bootstrap) Drupal.                 [error]
Hint: This error can only occur once the database connection has
already been successfully initiated, therefore this error
generally points to a site configuration issue, and not a
problem connecting to the database.

Drush was attempting to connect to:
 Drupal version                :  7.75
 Site URI                      :  http://default
 Database driver               :  mysql
 Database hostname             :  *.*.*.*
 Database port                 :
 Database username             :  *********
 Database name                 :  *********
 Database                      :  Connected
 Default theme                 :  nexus
 Administration theme          :  seven
 PHP executable                :  /usr/local/bin/php
 PHP configuration             :  /usr/local/php56/php.ini
 PHP OS                        :  Linux
 Drush script                  :  ~/drush/drush.php
 Drush version                 :  8.4.5
 Drush temp directory          :  /tmp
 Drush configuration           :
 Drush alias files             :
 Install profile               :  standard
 Drupal root                   :  ~/public_html
 Drupal Settings File          :  sites/default/settings.php
 Site path                     :  sites/default
 File directory path           :  sites/default/files
 Private file directory path   :  sites/default/files/private
 Temporary file directory      :  tmp
 path

I'll guess that you've got a server with insufficient php or mysql configuration, and that in the process of your upgrade, civicrm was disabled for one reason or another.
You can probably just use sql to re-enable it with something like:
update system set status = 1 where name = 'civicrm'

And then use drush to clear all your caches.
The origin of your issue could be one of these settings in php:
post_max_size
max_input_vars
or the mysql configuration of
max_allowed_packet


Are we able to see why a payment failed? Our contribution pages are working for some individuals and for others, payments are failing. Is there a way to see what the cause of this issue is for the payments that are unable to go through?

There are a few places you can check.

Foremost, I would check your payment processor's logs.  Most likely the cards were sent there and declined.  Make sure you don't have any configuration mismatches - e.g. not allowing credit cards from outside your country, or requiring a CVV on the payment processor but not on CiviCRM (though I believe it's mandatory in CiviCRM on the front end these days).
Check your CiviCRM logs.  Their location varies by CMS.  If you're not sure how to interpret them, you may want to open a new question.


How to style contribution and event registration pages? I want to style totally different a contribution page, not even having the general website header, no left menu with the login, nothing.
Just to use its functionality, but create new html for an event registration form, or for a contribution page.

One approach in Drupal would be the ThemeKey + ThemeKey CiviCRM modules. There's a Drupal 7 version of ThemeKey CiviCRM. This allows you to use a different theme for specified Civi pages. So you could create a minimal theme and use that for the desired pages.


re: events and printed "tickets" I just made my first events in CiviCRM, and am wondering about whether the purchaser can print a "ticket".

I assume they get a confirmation email which they could print, but is there an option to print a "ticket"?

My events can be found here:
http://www.keysunitedway.org/civicrm/event/info?id=7&reset=1
http://www.keysunitedway.org/civicrm/event/info?id=8&reset=1

Thank you!

Edit the Workflow Message for the event receipt template to include a ticket at the bottom. You can style it with html/css to look like you want. In order to have the ticket always be at the bottom of the page, you can use nested tables.

Here is a similar question (How) can I add a footer fixed to the page of a message template for printing a pdf?


Wordpress user registration only through CiviCRM We have our site set up so that folk join our group through a Civi profile which then sets up a Wordpress user account. This is as it should be. However we occasionally get registrations directly through the /wp-login.php form which bypass the additional data we want in civi. These are invariably spam registrations that need manually deleting.

We've experimented with plugins Theme My Login and WPS Hide Login but things get complicated without actually resolving the issue of preventing 'back door' registrations.

Is there a simple way to ensure registrations are via CiviCRM?

It looks like you could do the following:

Disable registrations in WordPress entirely (instructions in this SE question), OR
Add a WordPress hook implementation in a custom module which prevents WordPress registration via the regular methods (instructions in this SE question), then
Use that hook to ensure that only the CiviCRM registration flow is allowed. (Use variables unique to only the CiviCRM workflow or WordPress registration workflow to identify whether the user has followed the desired path, and reject otherwise.)


SMTP Connection stopped working Running CiviCRM 5.13.4 on WordPress current version. Everything had been working then we were informed that the site had stopped sending email. I have been trying to re-establish an SMTP connection ever since with no luck.

I have verified the user name and password for the email address using a desktop client
I have verified that the ports are open and that the CiviCRM server is not blocked by our firewall.
I have cloned the site with similar results, except that the clone can connect only connect on port 587, but the production site can not connect at all.
I have been utterly unable to locate any errors from exim, modsecurity or apache on either the CiviCRM server or the mail server.

The only error I get is:

  Mail Not Sent
  Sending test email: From: fppta@mailprocessing.org To: jlyons@rboa.com
  Oops. Your SMTP settings are incorrect. No test mail has been sent. An
  error occurred when CiviCRM attempted to send an email (via SMTP). If
  you received this error after submitting on online contribution or
  event registration - the transaction was completed, but we were unable
  to send the email receipt. The mail library returned the following
  error message:

> Failed to connect to mail.mailprocessing.org:465 [SMTP: Invalid
  response code received from SMTP server while sending email. This is
  often caused by a misconfiguration in Outbound Email settings. Please
  verify the settings at Administer CiviCRM >> Global Settings >>
  Outbound Email (SMTP). (code: -1, response: )] This is probably
  related to a problem in your Outbound Email Settings (Administer
  CiviCRM » System Settings » Outbound Email), OR the FROM email address
  specifically configured for your contribution page or event. Possible
  causes are:   •   Your SMTP Username or Password are incorrect.   •   Your
  SMTP Server (machine) name is incorrect.  •   You need to use a Port
  other than the default port 25 in your environment.   •   Your SMTP
  server is just not responding right now (it is down for some reason).
    •   The FROM Email Address configured for this feature may not be a
  valid sender based on your email service provider rules. Check this
  page for more information.

Where should I look next?

If the same credentials work on one server and not another, there's a good chance that you have php-mcrypt installed on one and not the other.  When php-mcrypt is installed, CiviCRM encrypts the SMTP password, and assumes that any passwords are encrypted.  This can be a problem if your PHP environment changed (in particular, php-mcrypt is deprecated and it's very unusual to see it used with PHP 7.2).

The fix is to re-enter the SMTP password and resave.  Hopefully this solves your problem!


Membership Management Customization: Assessment Sign up Member sign up
I want a process that allows for association members to apply for membership, register and submit documentation related to their certifications .
These then need to be assessed and approved by administrators

Can the CiviCRM system accommodate that?

Regards
Andrew

There is an approach whereby you set up a Membership Status of 'waiting approval' that kicks in at 'join date' and puts the membership in to a non-current status (overridden) - there are some old threads around that may give more pointers eg

https://forum.civicrm.org/index.php%3Ftopic=25771.0.html
membership approval
https://forum.civicrm.org/index.php%3Ftopic=33584.0.html

IN terms of providing documentation, this can be done via a CiviCRM Profile


Session invalidated after returning from PayPal CiviCRM v 4.7.31 I've just upgraded to CiviCRM 4.7.31 from 4.7.30 on Drupal 7 and we've identified an issue which wasn't there previously.  After being redirected to PayPal from a contribution form, the session is invalidated once you return to the site.  I've checked the qvKey from the form to the "return page" (which throws an error) and it is correct. Payments are lodged correctly. Any ideas?

Error log is

$backTrace =
#0 /www/sites/all/modules/civicrm/CRM/Core/Error.php(381): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /www/sites/all/modules/civicrm/CRM/Core/Controller.php(833): CRM_Core_Error::fatal("We can't load the requested web page. This page requires cookies to be enable...")
#2 /www/sites/all/modules/civicrm/CRM/Core/Controller.php(853): CRM_Core_Controller->invalidKeyCommon()
#3 /www/sites/all/modules/civicrm/CRM/Contribute/Controller/Contribution.php(74): CRM_Core_Controller->invalidKeyRedirect()
#4 /www/sites/all/modules/civicrm/CRM/Core/Controller.php(312): CRM_Contribute_Controller_Contribution->invalidKey()
#5 /www/sites/all/modules/civicrm/CRM/Core/Controller.php(204): CRM_Core_Controller->key("CRM_Contribute_Controller_Contribution", TRUE, FALSE)
#6 /www/sites/all/modules/civicrm/CRM/Contribute/Controller/Contribution.php(55): CRM_Core_Controller->__construct("CiviContribute", "null")
#7 /www/sites/all/modules/civicrm/CRM/Core/Invoke.php(304): CRM_Contribute_Controller_Contribution->__construct("CiviContribute", TRUE, "null", NULL, "false")
#8 /www/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:15))
#9 /www/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#10 /www/sites/all/modules/civicrm/drupal/civicrm.module(445): CRM_Core_Invoke::invoke((Array:3))
#11 [internal function](): civicrm_invoke("contribute", "transact")
#12 /www/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:2))
#13 /www/index.php(21): menu_execute_active_handler()
#14 {main}

Update - this was actually unrelated to CiviCRM.  I had not updated the htaccess file correctly after a core upgrade.


How to update a sequence email created by CiviCRM? I'm using WordPress 4.9.8, CiviCRM to 5.4.0, CiviRules 2.1 and E-mail API 1.17.2

I've created a sequence email by CiviRules by steps:

Step 1: After user added to a group G, send email 1

Step 2: After 5' until user added to the group G, send email 2

Step 3: After 10' until user added to the group G, send email 3

If I've created this sequence from start, sequence email sended ok. But if I want to update this sequence by and step like this:

Step 4: After 200' until user added to the group G, send email 4

This sequence created about 15' until user added to the group G, but after 200', no email send to user.

I've tried tick or untick "Don't recheck condition upon processing of delayed action" but nothing happens.

What can I do to make a sequence email and this sequence can update with CiviCRM?

Update 08/08/2018
This is conditions of my CiviRule, I have 4 Rule like that picture, the difference are the number of delay minute and the template mail.

The rule of this picture is created after my user added to group "Thông tin hữu ích". The minutes my user add to this group < 200 minutes but my user can not received email send in the rule delayed 200 minutes

I have a working CiviRule just like the one you are describing (I think) which works fine. I have not created 4 different rules but added  different actions to the same rule. There is a blog post on this here: https://civicrm.org/blog/erikhommel/using-civirules-for-a-petition-journey-at-amnesty-international-vlaanderen

I have included a screenshot of my conditions. Can you see any differences which would explain your problem? I think you need both the group checks, The one (group is) acts on the parameter from the contact add to group, the other one checks if the contact is still in the group when sending mails (to allow the opt out if the contact no longer wants to receive mail).

I also think you'd be better off by adding all 4 actions to this rule rather than have 4 rules.

I will test with the delay of 200 minutes and see if there is a problem there.


Anyone using CiviCRM for Scholarship Management? I'm working with a nonprofit's foundation to find a system to manage the foundation and its scholarships. Is anyone using CiviCRM and any extensions for this purpose? Thanks.

Without information from you this answer is just waving in the dark but here goes.

Assuming a Scholarship involves

an application
a review/decision
a notification of outcome
for succesful, a one-off or series of payments
perhaps a report at the end

Then I would approach this by using CiviCase and a bunch of custom Activity Types.

In an iDrupal world I would then provide the user with forms using webform_civicrm to open and update the status of the Case while also creating or updating the relevant Activities.

I would probably also provide a Drupal View of current applicants so admins can easily click through to a prefilled Webform and make the relevant updates.

Webform can also take care of pushing out the success/failure notifications, or that could be triggered via CiviRules or directly via an Activity to let applicants know the outcome.

HTH


How do I create a Smart Group of Participants using a Custom Data Field in Events? We use the Events module to offer three main types of classes: adult art classes, youth art classes, and professional development workshops. Students register online. What I would like to be able to do is create Smart Groups of Participants based on the subject matter of the class, for example: painting, drawing, or portfolio review, so that we can mail to these groups and let them know about future classes they might be interested in. I created a Custom Data Field called "Class Department" with multiple choice options for the different subjects assigned to the Event types that we use for classes: Class (adult), Class (youth), and Workshop. My issue is that, having done that, I'm unable to use the "Class Department" data field as a search option in Advanced Search, even though I clicked the "is the event searchable?" box. Is this a version issue? We're still on 4.3.11. If this becomes available in later versions, what version does it first become available in?

I checked in 4.4 and 4.6.

It does not work in 4.4, but it does in 4.6.

So, not sure about 4.5, but if you upgrade that far I advise to upgrade to 4.6 anyway, because then you are on the current LTS (Long Term Support) version.


Syntax error from CiviMail I have set up outbound mail and individual mails go fine. But I can't get the CiviMail working to a group. All the members bounce with a Syntax error. I am running CiviCRM 4.7.22 on WordPress 4.8.2. I've included addresses to recipients on different servers so don't think its a remote problem. The Syntax bounce is supposed to indicate an SMTP transaction error, but things work fine when its just a single email to one of the same contacts.

I have seen other SE posts that might relate, but they are with different configurations CiviMail not sending mails in 4.7.6 / Drupal 7 "DB Error: syntax error" and help on wordpress for send mailling

This is exactly like the problem I am having.  I worked with Siteground support and they couldn't figure it out.  They suggested to throttle the outbound to a very small number, which would work for small batches, but ultimately would fail.  At the suggested throttle it would take 8 hours to send out an email to my 500 members.


Event registration fatal error since v5.0.1 When someone registers for an event, it now registers them but crashes on to an error page, stating that "source_contact_id is not a valid integer".

I think this has been happening since Civi 5.0.1

I am using Civi 5.0.2 and Drupal 7.59

The Fatal Error Page from the error log is very long, but here's the first bit:

  $Fatal Error Details = array(3) { ["message"]=> string(40)
  "source_contact_id is not a valid integer" ["code"]=> NULL
  ["exception"]=> object(CiviCRM_API3_Exception)#420 (8) {
  ["extraParams":"CiviCRM_API3_Exception":private]=> array(3) {
  ["is_error"]=> int(1) ["error_message"]=> string(40)
  "source_contact_id is not a valid integer" ["error_code"]=> string(9)
  "undefined" } ["message":protected]=> string(40) "source_contact_id is
  not a valid integer" ["string":"Exception":private]=> string(0) ""
  ["code":protected]=> int(0) ["file":protected]=> string(88)

Anyone else having this problem or have any ideas?

The two versions Stuart mentions are different extensions.

https://civicrm.org/extensions/sparkpost-civicrm-integration is the PESC extension from https://github.com/proexchange/com.pesc.sparkpost and the replacement used by Stuart is the Cividesk extension.

I had the same problem experienced by Stuart with the PESC version on a D6 system running CiviCRM 5.0.0. I seem to have fixed it using Stuart's sleuthing - I simply edited the sparkpost.php file and replaced source_record_id with source_contact_id

Everything seems to now work. (I'll report back if I find other problems).

UPDATE: The latest version 1.3.7 of com.pesc.sparkpost fixes the problem.


If statement not working if the smarty variable is not set I've been trying to figure this out for myself but I am super frustrated at this point! I've got smarty variables and conditional statements working in thank you letters. Well kind of working. Basically I'd like to include the contribution note if the note field is filled in, if it's not show the text "None". I can get the note to display but no matter what set up I've used I can't get it to show "None". I have two donations one with a note, one without. Here is what I've tried so far:

{if $note.note}I'm a note{/if} // works as expected
{if !$note.note}None{/if} // does NOT show the text none as expected

{if $note.note neq""}I'm a note{/if} // works as expected
{if $note.note eq""}None{/if} // does NOT show the text none as expected

{if $note.note}I'm a note{else}None{/if} // outputs "I'm a note" on contribution receipt with a note but still nothing on the contribution that has no note.

{if !$note.note}None{else}I'm a note{/if} // outputs "I'm a note" on contribution receipt with a note but still nothing on the contribution that has no note.

I've also tried capturing a smarty variable and then using it in the if statement.

{capture assign='note_text'}None{/capture}
{if !$note.note}{$note_text}{else}I'm a note{/if} // "None" is still not displayed as it should be.

Can anyone shed some light? (I'm sure a suggestion will be is to write some hook or custom token with this logic already worked in. But I'd really like to know why the if statement isn't working as straightforward as I'd imagined it would. I'd like to use more if statements for mailing labels etc and if I can't get an "else" to work that's a problem.)

(Wordpress 4.4.1 and Civi 4.6.4)

Try this:

{if "{note.note}" eq ""}None{/if}


Mosaico 1.1 - "Unexpected error talking to server" when saving template Just installed Mosaico 1.1 for CiviCRM 5.7.2 on Drupal 7.

Tried to make a dummy template and hit the save button but received an error saying "Unexpected error talking to server - contact us!" It then cleared the image that I had inserted there.

(I followed the steps of 1) installing shoreditch, 2) installing flexmailer, 3) installing mosaico)

Any ideas on what to do?

Have tried asking on the Mosaico github and contacting the developers but no luck.

Cheers,
Josh

We are using Mosaico 2.x for more than a year (currently Version 2.0-beta4) succesfully and without problems. I strongly recommend you use version 2. See Mark Mosaico 2 stable for more info.


Crons are running but System Status is No cron runs have been recorded Hosted (Linux) website on SiteGround + Joomla + CiviCRM

Versions

PHP 7.0.29;
Joomla! 3.8.6;
CiviCRM 4.7.31

Scheduled jobs are administered as documented Calling cron.php with curl

Cron jobs are running. One example:

CiviCRM System Status page reports Cron not running,

Why this post?

There are several similar questions being posted without clear answers.
Support from hosting company is limited at this time on this issue.
No hints in the CiviCRM documentation.
I hope to get support from CiviCRM community.

My question: Why cron runs "are not being recorded"?

Did you check if the cron run is recorded if you call that url manually?
That way you eliminate the possibility of having a typo in the url or an invalid site key.

Some steps you could follow:

is 'curl' installed on the server that executes the cron run?
in the access log of your webserver, do you see the url being called?https://example.org/administrator/components/com_civicrm/civicrm/bin/cron.php
when executing the command from a terminal, do you see an error, for example about an incorrect site-key?
do you see an error message in the website log? (I don't know where Joomla stores messages, in Drupal there is the Watchdog log)


Does Civi CRM have ISO 27001? And is it compliant with ISO 27002 and ISO 27017? Does Civi CRM have ISO 27001?

And is it compliant with ISO 27002 and ISO 27017?

The standards you reference all relate to information security infrastructure and processes. It doesn't look to me like they apply directly at the application layer.

CiviCRM is going to rely on the security of the underlying platform (LAMP stack) and how it's managed. I suggest you rephrase your question with a specific concern about CiviCRM.


CiviMail - How to include an Image in a Header If I want to include an image in a mail, I have the WYSYWYG CKEditor which enables me to do that.

But how can I include an Image in a CiviMail Header ?

In the headers and the footers you don not have the convenience of a WYSYWYG editor. So you have to write HTML. An example of including the logo in the footer is:

 <img src='https://<site>/sites/default/files/logosite.png'/>

However you can create an example mail in de WYSYWYG editor and then use the Source button to examine the generated HTML code. Use this as an example and copy the relevant code bits.


Mailchimp extension terminology: audiences and lists I'm slightly confused by the mailchimp extension. It feels like maybe the extension, the documentation and mailchimp have become out of sync.
Looking at the group settings (civicrm/group?reset=1&action=update&id=N) page, I see four options in the Mailchimp settings box:

Mailchimp list
Mailchimp grouping
Mailchimp group
Are subscriber able to update this grouping from mailchimp?

Looking at mailchimp_civicrm_buildForm(), these form elements should be replaced by terms that sound like the documentation below...

Choose the integration option, called "Membership Sync: Contacts in this group should be subscribed to a Mailchimp List" then choose your list name.
Ensure the tickbox is ticked that says "Ensure lists's webhook settings are correct".

But that is not happening for existing groups. It is happening for a new groups.
Is there a way through?!

Here's what you should be seeing:

OR, if you have "Interest sync" enabled:

Words (Note that Mailchimp does not make this terribly easy to refer to as they have changed the words they use, and also because they use "group" and "grouping" interchangeably)

Mailchimp list - these are now called Audiences at Mailchimp. Nb. Mailchimp is heavily pushing people towards only having one "Audience" (List) and using the following to segment within that list.
Mailchimp [interest] grouping which is a set of...
Mailchimp groups - a list member at mailchimp can be in one or more groups within each grouping. Mailchimp's own forms can be configured to allow members to edit these themselves.
CiviCRM group - self explanatory, but just including to show the distinction between Mailchimp group and CiviCRM group!

The extension requires that you have a "membership group" in CiviCRM which will determine whether someone is subscribed/unsubscribed in the selected Mailchimp audience/list. Optionally, after this, you can sync other CiviCRM groups with mailchimp interest groups within that audience. Adding somone in CiviCRM to a group that is mapped to an interest group does not in itself add them to the list; you need to add people to the group used for membership, too.

It's not clear from your question exactly what you're trying to achieve. If you're trying to sync up an audience called Green Gazette with a CiviCRM group so that adding someone in Civi will add them in Mailchimp (and vice versa), then you should select the "Membership Sync" option, then select your list.

CiviCRM remembers which Mailchimp list/audiences and Mailchimp groups are configured by storing a unique ID from Mailchimp. If you delete that audience/group at Mailchimp that link will be broken.

If you get that error message after doing this, but you've been playing around a bit, I would advise just trying edit and saving the CiviCRM group settings again to see if it's repeatable - I know that some of those messages get added to the session at awkward times so can occasionally display at the wrong time. If you've selected a list but when you press save you always get that error, that sounds like a new bug.

  Personal note: the current mailchimp integration (link) has some limitations that I have discussed in my proposed new mailchimp sync extension. Everyone should feel free to comment (issue queue/PR) and input on my plans there.

EDIT (following your edit with screenshot)

It looks like you're seeing the CiviCRM custom field group fields in the normal CiviCRM way. This means that the .extra.tpl file is not firing; it's not loading in the mailchimp settings template file

.extra.tpl files are deprecated these days; the extension needs updating to use the Regions API. I'm not sure which version of CiviCRM you're using; it's entirely possible that they removed .extra.tpl files or somehow otherwise changed something that means the required template addition is not sourced. I'd start looking there (and also check for JS errors). Interesting that it works for new groups, though.


Mosaico and Imagemagick I am trying to test the Mosaico email template plugin however I am getting an error saying that Imagemagick is not install.

I checked with my hosting provider (Siteground) and they say that the PHP library is already install and that the path is /usr/bin/.

However i am not sure how to make Mosaico see that.

Does any one have this plugin working or any advice on how to fix my issue?

Zeak

We got it working after having issues with the imagemagick message - we did have it but needed to install php5-imagick - also we were thrown by being on nginx but alpha had been geared towards apache so a bunch of paths weren't working.

we provided feedback/workarounds at https://github.com/veda-consulting/uk.co.vedaconsulting.mosaico/issues/12 which resulted in alpha4 being released. assuming you are using that you might need to open an issue on Veda's github.


Statement violates GTID consistency error when creatng new user account in Drupal I’m running CiviCRM 5.16.2 against Drupal 7.67 on 1&1 Ionos hosting. MySQL version is 5.7.27.

When I create a new account in Drupal via the “Create New Account” button on the login screen, once I’ve completed all the fields and press “Create new account”, I get a yellow panel with the following error.

Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
DB Error: unknown error

Then this in the white section underneath:

Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame thrown in /xxxxxxxx/sites/all/modules/civicrm/Civi/Core/Transaction/Manager.php on line 107

The user account appears to have been created when I go to the People section in Drupal. I have tried this on a completely fresh installation/database and the same thing happenes.
I’ve turned on debugging and have got the following further info…

Database Error Code: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions., 1787
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => CREATE TEMPORARY TABLE `civicrm_tmp_e_dedupe_97911c832652885b9b1c932dfbe6530d` (id1 int, weight int, UNIQUE UI_id1 (id1)) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1787 ** Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context.  These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions.]
    [type] => DB_Error
    [user_info] => CREATE TEMPORARY TABLE `civicrm_tmp_e_dedupe_97911c832652885b9b1c932dfbe6530d` (id1 int, weight int, UNIQUE UI_id1 (id1)) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1787 ** Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context.  These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions.]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TEMPORARY TABLE `civicrm_tmp_e_dedupe_97911c832652885b9b1c932dfbe6530d` (id1 int, weight int, UNIQUE UI_id1 (id1)) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1787 ** Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context.  These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions.]"]
)

What is causing this and how do I go about solving it?
Many thanks.

This came up before at https://lab.civicrm.org/dev/cloud-native/issues/9. You might want to ask in there.


Remove required field in Grant Application The Grant module requires "Amount Requested" when entering a grant.  This information may not be available when the grant is created.  Why is this a required field?  How can we make it optional?  Workaround is to make it 0.

I don't think there is a non-coding way to do this. You could try to manipulate the UI with an extension to accept a submission without an amount value. But there may be reasons in the business logic why an amount is required, i.e. you may experience follow-up problems if there are grant records without that value in your database.

So unless this is a serious problem for you, I think your workaround is the best way to go.


Cannot create Survey when Events have 'is required' custom data: is this the fix? This is an issue with 4.7.6 and its reproducible on the Drupal 7 demo site.

Create a custom field called 'X' for Events that is required
Attempt to create a Survey via civicrm/survey/add (enter values and press 'Continue')

Step 2 fails with the error 'X is a required field'

The issue can be fixed by changing line 83 of CRM/Campaign/Form/Survey.php ...

$this->set('type', 'Event');

to

$this->set('type', 'Survey');

This change fixes the problem, but I'm unsure whether there is a deeper issue.

The form that is used by civicrm/survey/add is CRM/Campaign/Form/Survey/Main.php. The parent form is CRM/Campaign/Form/Survey.php. The possibly deeper issue is that the preProcess function of both forms (Main.php and Survey.php) deals with Custom Data.

I feel the child form (Main.php) should leave it to its parent to deal with Custom Data. But I think someone from the Core team might need to look at that.

I've created an issue and a PR for this fix. See https://issues.civicrm.org/jira/browse/CRM-18447 and https://github.com/civicrm/civicrm-core/pull/8188


Error upgrading database in WP: "Queue runner must be configured before execution Just upgraded to 5.27.3. Tried to upgrade database, got "Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
Queue runner must be configured before execution."
Any ideas what a "queue runner" is and how I fix it?
Thanks

I saw a solution for this problem on a Drupal platform and decided to try it: you need to delete all the entries in the civicrm_cache table in your Wordpress database using phpmyadmin before you try and upgrade the database. This resolved the issue for me. Civi version 5.27.4


Automatic discount if participant on other event I want to give automatic discounts to participants if they already are participating in another event.

I have explored the API and have some clues on how to look up participants on "the other event". But I don't understand

How can I check if the current registering contact is in that list
How do I turn this into something that can be applied during/after the registration process
Where do I put that code, or whatever the "something" is

I could not find any documentation for the "automatic discount" part of CiviDiscount. Hints on where to find that are also helpful.

Edit:

I found CiviCRM Additional Events signup which sounded like a good fit but could not get that to work in a quick check, unfortunately.

If CiviDiscount can be offered to those in a Smart Group, you could make a Smart Group of folk signed up to the first event.

Also read CiviDiscount based on group membership if you haven't already in case it gives other hints


Conference Registration with Housing Requirements I am looking for a way to run registration for a conference next summer. In addition to meetings, interest groups and general sign-up, I need to be able to assign housing and coordinate special needs.

The group that I am working with has/had a registration program that broke. It was proprietary and apparently not fixable. I need to show them a program that works, will be long lasting, and not too expensive. Mainly I am looking for help to setup the program and occasional ongoing support when problems occur.

CiviCRM seems like a good choice, but I am just starting to read through the documentation and try it out. While it mostly makes sense, I know that I need a really simple demo to convince others to use this software.

Thanks for any suggestions and pointers to simple examples.

Just wanted to share how a volunteer Admin for one of our projects is handling assets - e.g. Table assignments for Events; Room assignments for Camp; Equipment etc.

Warning: must be abstract thinker - and you'll never look at Tables the same :-)

Let's look at Table assignments for Events - as I have the site open and can pull in some screenshots - to Demo for you how this could work:

Contact Types

CiviCRM will let you create Contact sub-types -> Event Table is a Contact sub-type -> it's a banquet table;

Relationships

CiviCRM will let you define custom Relationship Types between Contacts - so you can define an Has Guest and Is Guest relationship (between Tables and Individuals)

Table View

There are three people sitting at this Table at the moment; As you can see we're using yet another relationship to identify that 'Regular' Table host (for a monthly recurring Event).

Webform CiviCRM

Since you're on Drupal you can add-on Webform CiviCRM - this is maintained by one of CiviCRM's Core Team members @coleman - with that we can now:
a) Email the Regular Table host of the next upcoming Event
b) Regular Table host already has a relationship with a Table (we configure webform_civicrm to automatically load it)
c) We also configure webform_civicrm to also also load the Contacts with whom the Regular Table host has a (normally sits at my table) relationship
d) And b/c it's an Event we also want to know if they actually will attend the next Event -> so we configure webform_civicrm to also offer the option of Event Registration -> RSVP

Table Management

If we want to move Mark -> to another Table -> we simply -> in his Relationship Tab; divorce/delete his relationship with Table 99 and add a new relationship with another Table:

Housing / Room bookings - can be done just the same

create a webform_civicrm where Contacts register: Contact, Family
Members, Relationships -> and user-select a Relationship option -> to
indicate their preferred Housing (shared, individual, family e.g.)
add payment to the form if this is a paid registration (or deposit);
with token based payment processors you can get Card on File ability
(make it a recurring series with two installments; charge deposit
now; adjust date and $amount if needed and automatically charge the
card for second payment later);
in CiviCRM - you'll be able to move Contact from having a
relationship of type "individual" -> with a Room called "Individual"
-> to having a relationship of type "individual" with Room called "Individual 04" - just as an example.
What we can't do just yet - is have a maximum number of Relationships. So right now we occasionally get too many guests at a
Table! That still requires eyes from an Admin. It will take some code
to add that maximum number of Relationships - I may be able to get
into that at some point.
But everything I've shown here (above) is all out of the Box - if you
can manage to wrap your head around Relationships to Tables and
Rooms;


How do I create contribution pages that record pledges and contributions to households? I'm using CiviCRM 4.5.8 and am setting it up to handle a three year fundraising campaign for our church.

Our church almost exclusively records donations for Households and not for individuals.

How can I create a Contribution Page that allows a person to make Pledges and Contributions that will be linked to their Household?

I am not afraid of custom coding and am currently planning to write a script that automatically shifts all individual pledges to their related household, but if I do that, I still want the contribution page to work for that person to actually make contributions.

Ideally, I'd just use a template override to inject the contact_id of the user's household if there is one or to use the individual contact_id otherwise, but I need some help on how to do that.

I already am comfortable working with template overrides, but I'm asking if anyone knows which template needs to be overridden to get the contact_id in the correct place.

EDIT: SOLUTION CODE

/**
 * Implements hook_civicrm_post
 */
function householdcontributions_civicrm_post($op, $objectName, $objectId, &$objectRef) {
    // the _post hook is called AFTER the object has been written to the database
    // because of that, we need to change the contact_id to the household_contact_id
    // and save
    if($op == 'create' && $objectName == 'Contribution') {

        $current_contact_id = $objectRef->contact_id;
        $real_id = $current_contact_id;

        // look for a household associated with this contact
        $result = civicrm_api3('Relationship', 'get', array(
          'sequential' => 1,
          'relationship_type_id' => 7,
          'contact_id_a' => $current_contact_id
        ));

        // override the contact_id with the newly discovered household id
        if ($result['count'] == 1)
        {
            $household_id = $result['values'][0]['contact_id_b'];
            // $objectRef->contact_id = $household['values'][0]['contact_id_b'];
            $result = civicrm_api3('Contribution', 'create', array(
              'sequential' => 1,
              'id' => $objectId,
              'contact_id' => $household_id,
            ));
        }
    }
}

I do something very similar with my church. the actual donation is credited to the individual who made it with a soft credit going to the household. This allows us to do reporting by either household or individual.


Resend email to non-openers We would like to be able to resend a mailing (or send an edited version of the original mailing) to recipients who did not open the original mailing.
While there are workarounds — such as creating a new group — they take extra steps and can be especially confusing when trying to add a useful unsubscribe link.
A similar question was previously posted here in February 2019. I am wondering if any progress has been made on this feature?
Thank you!

Welcome to SE CiviCRM, Your request can be done via smart group as a work around to avoid 10 step process you can implement an extension that would calculate the recipients based on 'Re-use' mailing link or a drop down of previous mailing lists


Receipting for multiple event registrations via webform We have a webform that allows you to register multiple people for multiple events. Once they have paid we would like them to receive an email receipt that they can print out and bring along to the event. How would we go about doing this?

Options we have explored are:

Webform emails: Yes you can format these to provide all the bits of information from the webform and format it however you like BUT it gets triggered to send as soon as you have submitted the form ie got pushed through to the payment page hence the email gets sent even if you do not then complete the payment.
If you have receipting on on the event then an event registration confirmation email gets sent. This only gets sent once the payment is completed but the email does not contain the correct information about all the events and participants.

Issues with the email are:

If you register contact 1 for event A and B and contact 2 for event A and C
then under the Event Information and Location heading it refers to event C and under event price there is an item for participant 1 and participant 2 referencing event A.

If you register contact 1 for event A and B and contact 2 for event C and D then under the Event Information and Location heading it refers to event D  and under event price there is just one item for one participant to event A.

Neither of these emails made reference to who participant 1 and 2 were.

This needed a fix in core. Have raised a JIRA for it at https://issues.civicrm.org/jira/browse/CRM-20657. Hopefully it should be merged in 4.7.21 version.

Fix submitted at https://github.com/civicrm/civicrm-core/pull/10439


How do I troubleshoot DB Error: connect failed on a new installation on Wordpress? I am following the detailed instructions to install Civi under Wordpress. I am running a local development Wordpress site using MariaDB 10. I have downloaded and activated the CiviCRM plugin. The CiviCRM installer is accessible. I have created a new empty database and user for CiviCRM and I can get a full "Green" ("You're ready to install") from the installer. But when I click on "Check requirements and install" I get an error:

"Cannot open mysql://[user]:[password]@localhost:3307/[path_to_database]?new_link=true: DB Error: connect failed."

The server port number is correct for this installation.

Any idea where I can look for more detail on why the connection fails at this stage?

The php mysql extension is no longer supported. Need to use mysqli. See
https://civicrm.org/blog/totten/psa-please-verify-php-extension-mysqli

The web server log might also indicate the error.


Delete Change Log for 1 contact We are trying to delete the change log for 1 user. We want to complete remove their address and information on our system. There a way to delete the change log for 1 contact in CiviCRM?

It depends on what you are trying to do.
If you want the complete removal of the contact, together with related entities (like address, activities, event participations etc.), then permanently deleting the contact will delete all the associated entities.
If you just want to remove the change log for that 1 contact without deleting the contact, you can run a simple SQL query to delete it. For a contact with the contact id 57 you would run this:
DELETE FROM `civicrm_log` WHERE entity_table LIKE 'civicrm_contact' and entity_id = 57

Beware, if you used something like Drupal webforms, then the data can still be there in the webform submissions, even though you deleted it form CiviCRM.


How to setup Civicrm for using FPO addresses I have a client that needs to use FPO addresses for contacts and members.  Is there something that needs to be configured in CiviCRM for this capability?

Carl

The list of states isn't editable by the end user, so it will require filing a bug to get APO, FPO (and whatever the third one is) added as state. In the meantime, I recommend using APO as the city, and not filling in the state or country (per USPS recommendations).


After upgrade to 4.7.31 send mail - recipients - "no recepients" After upgrade to 4.7.31 / working with Wordpress 4.9.4
I face problems with sending mass e-mails (Rundschreiben): I can choose groups (mailing list groups) in the recipients section, but the estimation shows "no recepients"; I can send test emails to a single email address or a group, and it works. I can start the sending process, but no e-mails are being sent. Any hints on how to solve this problem?

I resolved this by going to Adminstrater > System Settings > Clean up cache and update paths. Click the Clean up cache button.


Webform conditions with memberships I have a webform where our users can add new contacts to CiviCRM.  This form creates an activity record.  And this form should create a membership for these contacts. The membership has some custom fields; let's say field Reason and has values "Good, Bad, Audit" and a Referral field that contains the name of a person.

So far, this is standard CiviCRM Webform.  I can create the new contact record, create their membership, and populate the membership custom field with the option that the user selects.

Now, this webform allows users to select existing contacts.  Those existing contacts already have a membership, and already have a value in that Reason field.

My goal is that for existing contacts, IF the user selects "Audit" for the reason field, then the membership does not update.  So the membership record, membership type, membership dates, Referral custom field and Reason custom field should stay the same as what they were previously.  But this only happens if the Reason custom field is selected as "Audit".  For any other reason field value, the membership should update as normal.

What I have tried:

I can't figure out how to do this using webform conditionals.  Is there a way?  I would need to somehow capture the contact's membership field values before the user submits the contact.
Could I do this with a webform hook?  In that case, which hook should I be looking at so that it processes before the webform/civicrm integration?
I looked at using CiviRules, with the Webform CiviRules integration, but this seems to fire after the webform is submitted.

Thank you

I think you could use hook_webform_submission_presave

http://api.drupal.psu.edu/api/drupal/modules%21contrib%21webform%21webform.api.php/group/webform_hooks/nittany7

But hook_civicrm_pre might be better
https://docs.civicrm.org/dev/en/latest/hooks/hook_civicrm_pre/


Webform Contributions Error Since Last Update Running Civi 5.28.0, I have recently upgraded Stripe Extension :

STRIPE PAYMENT PROCESSOR to 6.5.1
MJWSHARED to 0.9.4

Since then, payments via webforms fail in unexpected Error.
How can I retreive a working configuration ?

Install contribution transaction api extension...


How to delete Field Mapping How do you delete field mapping you saved?  Have done a lot of work and learning system and now built up a bunch I won't use again but can't find anywhere in guide/online how to get rid of them.

Go to :

  Administer -> System Settings -> Import/Export Mappings

There you can find all existing mappings and you can delete unwanted mappings there.

Check below link for more details :

https://wiki.civicrm.org/confluence/display/CRMDOC/Import-Export+Mappings


Expired memberships being erased by new memberships using Webform we have a problem with expired members renewing.

When they renew using our webform, the old membership is replaced completely with the new membership. This means we lose the key 'member since' data.

They also show as a new member and not a current member which presents problems for us.

This does not happen when someone is in the grace period.
This does not happen if we manually renew the expired membership.

We use webform civicrm intergration with paypal standard. Drupal 7. Latest version of webforms and civicrm intergration. CIVICRM 4.5.8.

Any help resolving this issue would be much appreciated.

Thanks,
Andy

Sounds like you want to check out how to send existing members a renewal link via CiviMail. Webform CiviCRM provides you a handy link on the CiviCRM tab and an explanation.

The key concept here is that you can send contacts a special/unique-to-them link to the renewal page that bakes in their existing contact id so that the page already knows them and their membership, making the renewal easier for them and for CiviCRM.


Email addresses being set to on-hold bounce due to Away responses We just discovered that we have several hundred contacts whose email addresses have been set to on-hold bounce due to Away responses.  Apparently the 3 bounce maximum is also being applies to emails with Away responses.  How do we change this?  Also, is there a time maximum interval for the 3 bounces, after which old bounce history is discarded?  Thanks for any light that can be shed on this.

You can change the hold_threshold in civicrm_mailing_bounce_type table for Away to your own choice. By default it is set to 30. Not sure why your system is set to 3.

I dont think if there is any way to discard old bounces unless you delete from civicrm_mailing_event_bounce table. Probably good idea to write a script that runs on cron job to delete the entries of certain bounce type and X days old.

Cheers

Pradeep


Load sample data after installation I forgot to tick the box to install the sample data. Is there a way to do it after installation? I tried loading civicrm_sample.mysql but that didn't seem to load everything.

If it's a new install it might be simplest to just drop/recreate the database, remove the civicrm.settings.php file, and run the installer again.

The file with the sample data is sql/civicrm_generated.mysql, but it overlaps with sql/civicrm_data.mysql. You either use one or the other. If you just import the generated file now you'd get conflicts/duplicates for things like phone types etc.


Generating a new SITE_KEY One of my clients' webhosts posted the SITE_KEY of their site on a publicly accessible webpage.  How do I generate a new SITE_KEY with the same random process that generated the original?

Any source of unknown data should be fine - I'd use a command like this just because it's quicker:

head -n 1000 /dev/urandom | md5sum


ValueComparison null error when adding 'Last contribution is more than n days ago or is n days ago' as condition I'm trying to set up a rule in CiviRules that will send an e-mail n days after a contribution was made.

When I try to save the condition parameters I get an error message.

Can anyone confirm that this is a bug, or am I messing up something?

Error log:

2020/02/06 13:20:26 [error] 8317#8317: *280630 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught TypeError: Argument 1 passed to civicrm_api3() must be of the type string, null given, called in .../shared/uploads/sites/5/civicrm/ext/org.civicoop.civirules/CRM/CivirulesConditions/Generic/ValueComparison.php on line 125 and defined in .../releases/20200204155448/web/app/plugins/civicrm/civicrm/api/api.php:84

Stack trace:

#0 .../shared/uploads/sites/5/civicrm/ext/org.civicoop.civirules/CRM/CivirulesConditions/Generic/ValueComparison.php(125): civicrm_api3(NULL, 'getfields', Array)
#1 .../shared/uploads/sites/5/civicrm/ext/org.civicoop.civirules/CRM/CivirulesConditions/Generic/ValueComparison.php(73): CRM_CivirulesConditions_Generic_ValueComparison->isDateField(NULL, NULL)
#2 .../shared/uploads/sites/5/civicrm/ext/org.civicoop.civirules/CRM/CivirulesConditions/Contribution/LastContribution.php(64): CRM_CivirulesConditions_Generic_ValueComparison->ge" while reading response header from upstream, client: [...], server: [...], request: "GET /wp/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcivirule%2Fform%2Frule&reset=1&action=update&id=2 HTTP/2.0", upstream: "fastcgi://unix:/var/run/php-fpm-wordpress.sock:", host: [...], referrer: [...]/wp/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcivirules%2Fform%2Frulesview&reset=1"

I reproduced the bug on the demo site:

It might well be, but this is not the way I would specify the rule. This condition was for something pretty different, I do not recollect what exactly.

I would specify that the action is send email but the delay is xxxx number of days?

Like so:


How does WP BuddyPress integrate with CiviCRM Members? I read from Tim Otten on this stack that "WP BuddyPress is a substantial system which has an upcoming Civi integration." Could someone tell me more about it ? I am on the verge to install BuddyPress because it seems easier to use but I want my data to integrate to CiviCRM in any case. Is it possible now or will it be and when ?

I believe it's related to this post: https://civicrm.org/blogs/haystack/working-civicrm-46-wordpress that also notes the BuddyPress Groups Sync:
https://wordpress.org/plugins/bp-groups-civicrm-sync/


Format Contribution Form Using Pricesets We are creating a contribution page using a price set which is new to us. The format is a little weird. Is there a way to align the email address with the entries above it? Or can we eliminate the email address above the 'Donor Info' like and include it into the profile below? See image below.
Thanks in advance.
Using Civicrm 4.7.8 and Joomla 3.5.1

(source: corvair.org)

For a short-term solution, consider adding some css to your page that fixes the styling.

For the medium-term, check out issue CRM-15067 which aims to solve this problem.


How best to rearrange the order of the address fields on the New individual/contact from? I'd like to play with order and layout of the address fields on the New Individual form.  I understand that in the localisation setting s this can be achieved but I am not having any luck with the for a NEW individual/contact.  Is there not a .php file that i can edit the HTML output and manually rearrange the order of the fields?  Is this the best approach? Thanks, Joe.

I would recommend you create a little jQuery to move the fields around (something like you see here: template jQuery example)

And then place the created template with jQuery on the appropriate form (which will probably be CRM_Contact_Form_Edit_Address) using the alterContent hook (something like what you see here: alterContext hook example

Although this is not exactly what you want, it shows the approach. Does that help or is the confusion only growing?


Custom options on CiviEvent registration forms to handle breakout session choices A common need in event registration systems is the ability to allow participants to select from a list of concurrent "breakout" sessions that will occur in various time slots during the course of the event.

I know this could be achieved using custom fields in a profile inserted into the event Online Registration form. I don't like this because (1) it's "clumsy" as Dave Greenberg admits (and the average user will not enjoy the process of creating a custom field group, custom fields/options, and including them in a profile—no way!), and (2) Some of the fields/options will only be used one time and would clutter up the permanent list of custom fields in the system.

Ideas on alternatives are welcome!

I've tried a bunch of approaches, and price sets are definitely the best approach here.

Create a "Select" price set for each group of concurrent sessions (e.g. "Workshop Session 1", "Workshop Session 2", etc.).
This also allows you to charge different amounts for different sessions, if some incur an additional cost.
The price set options selected will be stored on the participant record as "Fee Level", and can be easily searched/displayed.


How to modify unsupervised dedupe rule In some of my CiviCRM database, i have contacts who share the same email.
I don't want people to modify the wrong contact when filling a public anonymous form.

To avoid that, I'd like the unsupervised dedupe rule for individual to be Email + First Name.

When i go to the UI (/civicrm/contact/deduperules?reset=1&action=browse) i see it's not possible to change the default rule.
Is there any problem to expect if i disable the default rule in the database by setting is_active = 0 and create a new unsupervised rule ?

EDIT

I see there is no is_active field so i guess i will have to either delete, either changed it to a General type of rule.

The question is the same - is there any problem to expect ?

On our site we simply created a new rule, and chose the 'Unsupervised' option when creating it.

That creates the rule, and marks it as the default 'Unsupervised' one. The old default is downgraded to a 'General' rule. If it was a built-in rule then it stays 'reserved' so you can't edit it.

I don't think there's any need to delete them, or fiddle in the database =]


How to delete sample data? When I accepted sample data on install I did not realize there would be 200 contacts added with no clear way to get rid of them. How do I delete these contacts?

The quickest way is to:

Run a contribution search with no criteria. You will have a result page with all of them.
For the Select Records option, choose All Records.
For the Actions option, choose Delete Contributions.
Repeat for contacts with Advanced Search; type "Sample Data" into the "Contact Source" field to find all sample contacts and then bulk delete them. This will cascade down to delete events, activities, etc. You'll also get a message that your own record can't be deleted, so there's no concern about wiping yourself out of the system.


When are scheduled reminders sent? We are in the process of setting up some renewal reminders for lapsed members. The reminder is set to be sent 7 days after the membership end date.
What I wanted to check is whether this reminder will be sent to members whose end date is exactly 7 days before or if it will be sent to members whose end date is 7 days or more? i.e. will it be sent to members that expired 8 days ago, 14 days ago, 2 years ago etc?
I presume that it is an exact match. Could someone confirm this (and ideally point to where this is in the code)?
What I don't want to do is send the reminder to every former member including those that expired years ago.

Schedule reminders configured for all the available entities except for participant will send reminder on exact same day match in your case it would be on 7th day after expiry date.
For events participant its different, in current version of civi if you have configured send reminder for event start date after 7 days than it will send reminder for all the participant whose event start date is past 7 days