Where do I change the string "Subscription to CiviCRM..." for Stripe payment processor I hesitated to post this as I think the field should be easily findable, but alas I've given up.

I have donation pages set up using stripe (with recurring payments).
The recurring subscription works, but the description is:
"Subscription to CiviCRM every 1 months $50.00"

Where can I change this description passed to Stripe?

The Answer - turn on Stripe receipts, and turn on civiCRM receipts. The item itself cannot be changed (at least that was the answer I found when I explored a long time ago).


What is the proper way to update to the recommended/supported version of Webform CiviCRM module for Drupal 7? Here is what I'm trying to do. I'm trying to update to the latest version of the Webform CiviCRM, however, for right now the only way for me to update is to deactive the module and unistall it. I don't want to go that route.
What would be the best way for me to do it?
Thank you,
Kevin

Excellent :-)
You will want to find out where your module lives -> determine whether it lives in /sites/all/modules or in /sites/default/modules
Download a copy of the latest 7.x-5.x from our drupal.org project page: https://www.drupal.org/project/webform_civicrm
Unpack that tar.gz
Then replace what you have in /sites/all/webform_civicrm or /sites/default/modules/webform_civicrm with that new copy you just downloaded/unpacked using sftp or scp (depending on your access to your site)
Running database updates is a good idea - always do that after you update any module. You can do that by typing /update.php behind your base URL in the browser - or go to Reports -> Status Report and follow link (it should be reporting to you whether there are any pending database updates).


How to display only Time value in User Contact without the Current Date value I have created a custom field selecting date type,selecting the date format and time.Actually I will need only Time field but the system doesn't alow to create
custom field of type date, without selecting a date format and later in webforms I selected Time widget. In webform it is displayed as time field only
But after  the user submits the webform, In civicrm contact current date is also displayed with the time(screenshot)and How to get only the Time value in civicrm?I need this field for time of birth of the user.

Any help?

Since you are using date field it won't allow you to store only time. One option would be to use custom field of type text to only store time or use date field to store DOB with time.

HTH

Pradeep


Case Overview Button Not working I'm using Civi CRM as a local Healthwatch.
I can't see an overview of cases - when I click the button, or try to enact a search, the page below shows.
Any idea how to fix it?

TIA!

Check the civi log for more details. It looks like you're using drupal so it's either under sites/warrington.healthwatchcrm.co.uk/files/civicrm/ConfigAndLog or sites/default/files/civicrm/ConfigAndLog.


How do I Delete Documents I uploaded to CiviEvent? We've uploaded hundreds of documents over the past few years - under the event module (schedules, programs, etc.) - how do we access and delete them now? I can't locate where they are stored.

Go here:

/civicrm/admin/setting/path?reset=1

to find out what the Custom Files Directory is for your instance!

Custom Files Directory:
"Path where documents and images which are attachments to contact records are stored (e.g. contact photos, resumes, contracts, etc.). These attachments are defined using 'file' type custom fields."

ADDED: You'll need access to your server - eg through eg CPanel FileManager - or those who like and have command line access can SSH to their server and then navigate to the custom files directory.


After a CiviCRM update on WordPress the CiviCRM menu has disappeared In some WordPress configurations, after upgrading from CiviCRM 5.11, the CiviCRM navigation menu bar has disappeared.

The problem only happens with certain configuration situations and seems to be related to changes in the asset caching system.

As a quick workaround, you can disable Asset Caching at:
/wp-admin/admin.php?page=CiviCRM&q=civicrm/admin/setting/debug&reset=1


in CiviMail, when using "view in browser" link, how can forward to a friend be disabled? When a person clicks on the view in browser link in an email, the email is generated on a webpage. This webpage also includes any tokens like Forward to a friend, which on this webpage does not work. How can the html for the web-page version of the email be edited to get rid of such token (or the unsubscribe token?)

Try wrapping those items in <span class="hiddenElement"> </span>. Civi's css will hide it on your website, but email clients will not.


How to keep contacts to a GROUP for a limited period? We have kids activity event that runs for a year, for example, event name is KIDS CLUB - 2019. Registration is done by webform. We capture parent details as relationship and added to PARENT GROUP. Kids details added as contact & participant, added to KIDS GROUP. That was easy part!

For the next year we would need to create an event called KIDS CLUB - 2020. Some kids and parent may remain same and some new kids will signup. We do not want to send any related email to those parents who has not signed up for 2020.

How can we remove the parents & kids automatically that would not signup for next year? Perhaps some of you can think of an alternative approach to deal with it. Please feel free to suggest. Thanks

I think you can create a smart group based on Event type and Registration date this year. This will have contacts who will be registered for an event for 2019 and then will be removed automatically when its 2020.

HTH

Pradeep


Custom fields are not pre-populating on profiles added to events, membership, contributions, etc I have some custom contact fields that are not pre-populating the fields on event registrations, memberships, contribution pages, etc. Other fields in the profile pre-populate. When I use the profile in edit mode, the custom fields pre-populate as usual.

This is a fairly new thing, a few months ago, this was not an issue.

Latest Civi/WP

Try applying patch from below PR

https://github.com/civicrm/civicrm-core/pull/16991

https://github.com/civicrm/civicrm-core/pull/16981

HTH

Pradeep


Migrate from Drupal to WordPress - 'DB Error: no such table' I'm following the methodology at https://docs.civicrm.org/sysadmin/en/latest/misc/switching-cms/drupal-to-wordpress/ to migrate from Drupal to WordPress.  After importing the database tables to the WordPress site, I get the error DB Error: no such table in the browser when I try to access the CiviCRM front page.
In the wp-content/uploads/civicrm/ConfigAndLog/CiviCRM.f00.log, I see the following:
Sep 06 22:24:15  [error] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_setting (`component_id`,`contact_id`,`created_date`,`created_id`,`domain_id`,`id`,`is_domain`,`name`,`value`) VALUES
(NULL,NULL,"20200906222415",NULL,"1",NULL,"1","wpLoadPhp","s:34:\"/home/singersin/www/wp/wp-load.php\";")
 [nativecode=1146 ** Table 'singersin_wp1234.log_civicrm_setting' doesn't exist]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_setting (`component_id`,`contact_id`,`created_date`,`created_id`,`domain_id`,`id`,`is_domain`,`name`,`value`) VALUES
(NULL,NULL,"20200906222415",NULL,"1",NULL,"1","wpLoadPhp","s:34:\"/home/singersin/www/wp/wp-load.php\";")
 [nativecode=1146 ** Table 'singersin_wp1234.log_civicrm_setting' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_setting (`component_id`,`contact_id`,`created_date`,`created_id`,`domain_id`,`id`,`is_domain`,`name`,`value`) VALUES
(NULL,NULL,"20200906222415",NULL,"1",NULL,"1","wpLoadPhp","s:34:\"/home/singersin/www/wp/wp-load.php\";")
 [nativecode=1146 ** Table 'singersin_wp1234.log_civicrm_setting' doesn't exist]"]
)

What puzzles me: why is it looking for a table called log_civicrm_setting when it's doing INSERT INTO civicrm_setting?  There is a table called civicrm_setting, all CiviCRM tables are prefixed with civicrm_ in this installation.

This is down to the fact that you probably have logging turned on in your Drupal environment. So the easiest thing to do would be to turn it off before you migrate and turn it back on in Wordpress (Administer -> Misc -> Logging). If you cant do that (or it still doesn't work) then you have a couple of 'hacks' to make get to the point that you can at least get to the settings, including dropping the database triggers on the settings table, and any subsequent tables, until you get to the home page and to the logging page. But I would turn off at the source, thats the easiest approach.


Event Custom Fields not Looking Right with 4.6.27 Upgrade I'm trying to upgrade our site from 4.4.21 to 4.6.27 (latest LTS).  The upgrade process, following the guide, worked as expected and everything looked ok initially.  However, when I try to create a new Event, several custom fields don't work and don't look right.

The contact reference autocomplete-select fields don't auto-complete (nor do they load the little icon next to the field, the js isn't loading).  And the date fields look really off, with two fields and the calendar icon doesn't pop up a calendar.

This is only on custom fields for events.  Standard date fields are fine, it seems.

The only error I could find was in the Console, with this message right as it's loading the custom fields.  I don't see any errors in the apache logs nor on screen (I have debugging turned on).  So I'm at a bit of a loss on how to debug this.

  Error: cannot call methods on autocomplete prior to initialization;
  attempted to call method
  '/civicrm/ajax/contactref?context=customfield&id=129'

I thought it might be some custom module I have, but I've disabled everything and still get these odd custom fields.  Would appreciate help in figuring this out.

Often JS errors after an upgrade are caused by needing to clear the browser cache. Give that a go and retry.

Another approach to resolving this is to try to create new equivalents of those fields once the upgrade has run, and see if they behave in the same way. This is distinct from what you did in your subsequent comment.

John


Divide recurring contributions between financial types I am working on the following scenario. The organization wants to offer anyone that signs up to contribute monthly gets a membership for $100. So if they sign up to donate $50/month the first $100 is the membership dues (non-deductible) and the remaining $500 for that year is considered a donation (deductible).

I have setup the contribution form with a membership type that renews monthly and auto renew is required. That takes care of the payments.

Anyone have an idea on how to record the donations after the initial $100 as a donation that is deductible? It is important to provide the donor a statement at the end of the year for tax purposes.

Any thoughts would be great!

The site is in WordPress 4.9.5 with CiviCRM 5.0.

You might want to configure a price set with two line items, one for the membership and one for the donation. You want them to be monthly recurring, so that after 12 months they've paid for the $100 membership: you'll come close with $8.33 /month.

Alternatively, you can create an extension to do this. We'd be happy to help with that.


Initialization Error when going to Civi CRM dashboard and adding pages/posts I've had Civi CRM integrated in my website for a couple years no with no issues. However recently I've not been able to update any pages or posts or even go into the Civi CRM dashboard. All that shows is this error:

Initialization Error

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => simpleHandler
        )

    [code] => -26
    [message] => DB Error: insufficient permissions
    [mode] => 16
    [debug_info] =>  [nativecode=1044 ** Access denied for user 'rcboa171_civicrm'@'localhost' to database 'rcboa171_saveskahapark_civicrm']
    [type] => DB_Error
    [user_info] =>  [nativecode=1044 ** Access denied for user 'rcboa171_civicrm'@'localhost' to database 'rcboa171_saveskahapark_civicrm']
    [to_string] => [db_error: message="DB Error: insufficient permissions" code=-26 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info=" [nativecode=1044 ** Access denied for user 'rcboa171_civicrm'@'localhost' to database 'rcboa171_saveskahapark_civicrm']"]
)

Although my pages view fine from the front end and I can upload media.

Has anyone seen this before? Why would this be happening now? I haven't done any updates to my database or touched/changed anything in the last few months as it's pretty big site and I'm worried about updating the plugin or cms.

Any advice would be appreciated!

It looks like CiviCRM is unable to access the CiviCRM database.  This is often separate from the content management system database (i.e. the database for WordPress, Drupal or Joomla).  This means that you may be able to access and log in to your website, but not access CiviCRM.

I'm not sure why this has happened in your case but I would suggest that you check your hosting package and see if there have been any changes to the databases or database users.  You should also check that the database settings in your CiviCRM settings file are correct.


Contribution count does not reflect number of contributions I have just noticed that the contribution count does not equate to the number of contributions. I have not been able to narrow down the circumstances.

From the screenshot, it seems like the first contribution is done via test mode.

FYI, test contributions are not included in the count on the tabs. Though not sure why the second one is not included. Can you add a little more information for the second row of how it is done, civi version etc ?

Update: Also make sure the financial_type_id used for the contribution is enabled from Administer -> CiviContribute -> Financial Types.

Path - civicrm/admin/financial/financialType?reset=1.


Where do I find and change user interface displays? I want to edit the data-entry of events. the mask now shows the "thank you sent" field on a new event, but not on changing an existing event (it should be the other way round).
how are these displays called, i.e. where do I find them - and how can I edit them? in the menu "administration -> customize data and screens" the event-creens don't show up (some other screens are also missing)

thanks for a hint

Any fields that are showing on a front-facing contribution or event page would be managed through the configuration of each contribution or event page (or the price sets or profiles associated with them) - to find the configuration area of a given contribution or event page:

Contributions > Manage Contribution Pages > Scroll to find the contribution page of interest, then click on the "Configure" hyperlink and select the area you wish to configure
Events > Manage Events > Scroll to find the event page of interest, then click on the "Configure" hyperlink and select the area you wish to configure

If you are referring to a back office registration (e.g. Event > Register Event Participant), then custom code would be required to change the data entry form.

Hope this helps,
Tamar


Are private contribution pages a thing? We want to restrict our member signup page ( a contribution page ) to people who have registered to our Drupal site.  Also, we'd want to have public contribution pages not associated with membership be accessible without login.

In Drupal, I could make the permissions for "CiviContribute: make online contributions" be not accessible for unauthenticated users, but then I wouldn't be able to have the public contribution pages accessible.

Is there such thing as a private contribution page?  Or is there some other way of achieving our goal that I don't know about?

Thanks!

A short bit of custom code could take care of this (using the hook_civicrm_preProcess hook I think).  It would need to check if the current page is your "sign-up" contribution page, and if it is, make sure that the user is currently logged in.  If not, it would redirect to wherever you need.

Not positive this code is perfect, but it should get you pretty darn close...

function hook_civicrm_preProcess($formName, &$form) {

  $form_id = 7;   // set this to the specific form_id you wish to limit access to
  $redirect_path = 'home';  // set this to the url to redirect to if not logged in

  if ($formName == "CRM_Contribute_Form_Contribution_Main" && $form->_id == $form_id) {
    if (!user_is_logged_in()) {
      drupal_goto($redirect_path);
    }
  }

}


Determine client of new case from within hook I'm setting up CiviCase with a new case type of 'Press Release'. We only have one press officer, but want other staff (those who more often deal directly with our members) to be able to open cases. So I wanted a case role of 'Press Officer', as the case manager, automatically given to a particular cid for all cases of that type.

My first thought for this was a post hook, but when you create a case, what you get in the post hook has no client contact IDs set yet. (This isn't a case of CRM-15914, it's not there if I do an explicit Case.get on that case ID either.) The problem is, clients are added to the case (inserted into civicrm_case_contact) only after the post hook is fired for the case creation, and adding a client has no hooks of its own.

How can I automatically assign a role to someone other than the creator when a case is created?

The post hook does not perform as expected for cases :-) I have done some mods to do exactly what you are doing: automatically assigning a role. I have done this in 2 ways:

using the post hook on the Activity Open Case
using the caseSummary hook and checking if there is no other activity than Open Case. In this case I still allow the user to override what I have done as it would then have more activities than just Open Case

A refactor of CiviCRM Case is still on my wish list :-)


HTML code for two-paged PDF What HTML-code snippet must be included so when you create a PDF in CiviCRM, you would create a two-paged PDF?

One contact, one PDF, two pages, and the desired page break at a position of my own choice.

Any help is much appreciated.

Try:

Works for us, using wkhtmltopdf rather than the default.


Email a user when they are assigned as case manager? Can anyone advise on the best way of sending an email to a newly assigned case manager/advisor? (ie to a specific case relationship when it is first made)

I've looked at the civirules extension but could only get it to send to both parties (client as well) and without any case specific tokens to tell them what it was regarding..

thanks!

For sending a message to new case managers - I would suggest using Scheduled Reminders.

Create a new group "Case Managers". Add all case managers to the group.
Set a Scheduled Reminder on "Activity" of type "Open Case".
Limit recipients to members of the group "Case Managers".

With regard to the tokens - there has been recent work to support case tokens on activities.  See CRM-19767 and the accompanying casetokens extension.  Note that I'm not sure that this will extend the functionality to Scheduled Reminders - but if it doesn't, I imagine it will get a coder 80% of the way there.


images in emails not displayed in Gmail clients (browser or mobile) For months/years we have been battling Google support on fixing an issue we're seeing so I'm wondering if others have come across the same thing.

Images in emails sent by CiviCRM (CiviMail or just via "send email") do not display in Gmail clients (both browser-based and mobile, e.g. Android app).

They do display perfectly when the very same email is being viewed in any other non-Gmail client (yes, even Outlook gets this right).

The images are publicly/globally available, but Google replaces the image URL with a proxy URL of sorts. E.g. they turn this:
https://www.evergreenmtb.org/media/civicrm/persist/contribute/images/images/newsletter-header-evergreen-kittitas.jpg

to this (which gets you a 404 error when accessed directly):
https://ci5.googleusercontent.com/proxy/e-K9WkNS0vJgrFL_anW3XB4jzMkNZsp-DOm7d04zIaqOY-o-UXAQF9o3FvrKJAGi2VD_fjUnyJ2xg_ywd8kBe7n22rJoBTzD2HaFilJOKK9zab8GkvkCKodIpv4s7aNA2BwPIoQER03tyR_vZZ4qFiFwO6B2uYSDF1Pjioo-zB6Hg6No6qsx=s0-d-e1-ft#https://www.evergreenmtb.org/media/civicrm/persist/contribute/images/images/newsletter-header-evergreen-kittitas.jpg

Display images "always" option is selected in Gmail settings, the sender is saved as a contact, etc.

I sent Google a gazillion examples, including email source files, HAR files, you name it, but to-date no dice.

Any thoughts? Thanks!

thanks for the hint; solved this by whitelisting the following domains in WHM in the "Add IP to Firewall" section:

ci3.googleusercontent.com
ci4.googleusercontent.com
ci5.googleusercontent.com
ci6.googleusercontent.com


Premoderation for webform submission before contact record change We've a Webform which picks and updates existing contact's data. Is it possible to add a "check data" step somehow after webform submission has been made but before actual contact record change? There seems to be no corresponded event-condition-action chain in Rules/Webform Rules/CiviRules.

Suggest you look at giving users only the option to create Draft webform submissions (maybe just hide 'submit' via js) - then you take over and do the actual Submission


Contribution recorded but no membership created when account creation is used We are seeing this on Drupal 7.4.2 / CiviCRM 4.6.13 instance

A new (anonymous) user makes a contribution (using price sets) to sign up for a membership. The profile forces an account creation.

The contribution is recorded but no membership is created. The Drupal contact is created too. Has any one seen this?

Update: this was due to a rule/trigger that redirected members on login. Disabling the trigger has resolved the problem.

Oh no! It looks like you've found a bug!

Here's how to take care of this pesky critter:

1) Check in the Drupal watchdog and civicrm log files for messages that occurred around about the same time as the contribution.

2) Establish if the contact was created in CiviCRM (your post doesn't explicitly say it was). If so, is it tied to the contribution and Drupal user?

3) If the answer to the above is yes, establish if you can create memberships on that user with the CiviCRM api.

4) If the answer to 3) is yes, then it should be possible to establish where in the code the critter is, put breakpoints around it (or use debug output or die commands) to establish where the error is. Finding out what parameters are going in is usually the thing to do here - so many times SQL queries end up trying to insert an illegal empty string or similar.

When you have that information, you have enough to file a bug report with the core team!

Hope that helps,

John


Can form submissions dedupe and "fill" instead of "override"? while deduping in a contact import, you can choose whether you want new data to "fill" or "override".
is there a way to enable this feature for a form submission?
example would be an event registration
if a woman already in civi named Cindy Weiner registers for an event with her email address that we have on file, but used "weiner family" for first and last names, or used an email address that we have as a secondary one, we want her submission to be matched to the contact we have on file with the same email address, but we don't want it to override any fields.
is there any way to accomplish this?
Follow up solution, which I think is very simple to implement:  Limit any given email address to one contact.  This would allow us to use very lenient dedupe rules for and always connect contacts.  You could add any address or phone number that doesn't match, as a secondary one.
What do you think?

There is a partial solution available called the No overwrite extension which will prevent users from changing their name. But this only works if they are logged into your website already.

For non-logged in (anonymous) users, CiviCRM has to "guess" who it is by using its dedupe rules. You can configure which rule the event page uses here:

However there is no solution I know of to filter the information submitted - it will overwrite existing records if CiviCRM finds a match.


Credit card fields do not show after updating I upgraded to CiviCRM 5.0.0 on Friday and our contribution pages do not show the credit card fields any more. I have attempted to re-save the contribution pages and payment processor information. When I try to edit the payment processor, I get the following page. I am not sure what else to try, thank you.

I needed to delete everything inside the sites/default/files/civicrm/templates_c/ directory;

rm -R sites/default/files/civicrm/templates_c/*


smart groups based on membership broken after upgrade from 4.6.4 to 4.6.5 Smart groups that are based upon advanced search membership are broken after upgrade from 4.6.4 to 4.6.5.  After the upgrade, the groups have everyone in the database.  When you select contacts in group and then click on the edit smart group search criteria you get the advanced search form.  The section for membership is expanded but the group is not selected nor is membership status filled in.

I can fix the groups but it's a bit of a pain.

I looked at the criteria in the civicrm_groups after the upgrade.  It looks the same as before the upgrade and doesn't work.  Once you manually fix them then the criteria is different.  I'm not sure if the civicrm_membership_cache is messed up or if the criteria isn't getting update.

It seems like a bug to me. Please raise a issue on Civicrm Issue tracker


Read-only access to CiviCRM I would like to enable members of our Board of Directors to view our CiviCRM database without giving them permission to make changes.  I.e., read-only access.  Can this be done?

You didn't specify which CMS you're using but between your CMS permissioning and Civi ACLs, that should be possible.  See here for some info: http://book.civicrm.org/user/initial-set-up/permissions-and-access-control/

Just a thought to consider though... if you want to present particular sets of data to your board members in a simplified way, creating Views (if you're using Drupal) or similar presentations might be a viable alternative.  Sometimes the back-end, administrative angle of Civi can be a bit confusing for folks who don't use it regularly, particularly if they're not very technical.

Hope this helps,
Lesley


List all Profiles in a group when using "Profile Search Form" as a Joomla menu item I have a Job Postings profile that gets recorded on a contribution form. The user is then added to a "Job Postings" group. I'd like to have a Profile Search Form on a Joomla page (menu item) that automatically loads every profile record in that group into a list.
Currently, I have it set up to where the user would have to hit search without any filters to populate the list. Like in these images below:
What you see on page load:

What you see after the user hits "Search" with no filters. (all records are returned):

I'd like the query in that second image ("Displaying Results where: Groups(s) in Job Posting...AND...Group Status 'Added') to be the default search on page load, so that the user gets the whole list of job postings automatically, and then can filter with the search criteria if he or she likes.
Right now I am looking into the Listing.tpl file located at: /administrator/components/com_civicrm/civicrm/templates/CRM/Profile/Page  and have noticed a variable named $qill that seems to hold the search criteria, and some other variables like $row and $search that also control how information is shown on these types of pages. Maybe there is something that can be done with these variables somehow (if I can find where they get defined)? Is there a simple answer to this I am missing?

It looks like force=1 url searching works for profiles too, so just provide a menu link to the page with force=1 on the end of the url, e.g. https://your.site/civicrm/profile?gid=1&reset=1&force=1
See https://docs.civicrm.org/user/en/latest/the-user-interface/searching-url-support/


Can we enable deleting/modifying incoming emails? the activities of type incoming emails seems to be hardcoded to not have the edit or delete button, even for admin.

Some of my users need to be able to delete it (eg. if it's a spam email) or edit it (if it's mangled somehow). Is there an option?

Would it make sense to write an extension to allow it? It isn't an issue of permission, as if you alter the url, you can still delete them

X+

Yes, that should be fine. I think the original reasons behind not including it were some combination of:

a. It was for the CiviCase folks, where we did not want to delete anything

b. It was used internally, so spam was not an issue


Searching for SMS Campaigns I am unable to search Campaigns in my sent SMS's. It appears that the field for searching archive SMS's via campaign has disappeared

It appears that there was a JS conflict with WPMU custom sidebars after an update to the Word Press plugin. The file was wpmu-ui.3.min.js under Word Press 4.7.3.


Newsletter sign up form on wordpress I've installed for the first time civiCRM.. and he is great...
I have a wordpress website so I was wonderind what is the correct procedure to set up a newsletter subscription form.
Thank you

Essentially you want to display a form on your wordpress that takes in the personal details (name, email address) of your subscriber.  these details will be fed into the civicrm on your wordpress and where the civimail module will pick up to send the newsletter to.

In quicksteps:
1. Create Profile (under Admin)
2. Select the fields required for this profile, these are fields that will appear in the subscription form
3. Expose the profile in the wordpress page (refer How do I expose CiviCRM forms in WordPress?)

You can refer to this website on setting up the form on wordpress in details:
https://docs.civicrm.org/sysadmin/en/latest/integration/wordpress/forms/


Can you pull the emails collected through a "form" and dump them into a Civi CRM group? If I create a form that will collect email addresses, can those email addresses be exported or added to a Civi CRM group for later mailings?  I am trying to find a way to collect emails on the front end of our website then add them tour interest group mailing list on the back end without having to manually create a new contact that will then be able to be added to the group.

Welcome to SE!  There are several ways to add email addresses to a mailing list. See this section in the User Guide.
What CMS are you using?  On Drupal, you can use webforms.  On WordPress you can use Caldera Forms or Contact Form 7
The GDPR extension also provides a page for people to choose which groups they want to belong to.


CiviCRM Installer Errors - Can't change DB settings I can't get past the install page (/wp-admin/admin.php?page=civicrm-install). The installer prepopulates to my WordPress DB settings and won't take the CiviCRM DB settings I put in. I input the MySQL server, username, password and DB settings and hit the Re-check Requirements button and it fails. Below it shows the Database details, not with the data I input in the fields above but rather with the original WordPress DB server and database.

Is there any way to change the "default" values that the page is coming up with or install without using the installer? I didn't find any tricks around this problem. This is a WordPress Multisite network installed on AWS (Ubuntu 14.04/WP 4.6.1/CiviCRM 4.7.11).

There is an issue in the installer for 4.7.   I created https://issues.civicrm.org/jira/browse/CRM-19279  to track the issue.   With Christian's help I created a PR - https://github.com/civicrm/civicrm-core/pull/9029  I have tested this locally and on one of our test sites and it works.

I'd appreciate any testing that can be done with this to make it a merge candidate.


Access denied when I want to "Display and Edit Custom Fields" I have Access denied when : Administer > ... > Custom Data > Display and Edit Custom Fields

I notice that "www." is added between htpps:// and my site name :
https://bapa-lacellesaintcloud.com/drupal/index.php?q=civicrm/admin/custom/group&reset=1
is moved to :
https://www.bapa-lacellesaintcloud.com/drupal/index.php?q=civicrm/admin/custom/group/field&reset=1&action=browse&gid=1

... and I get the right form when I (manually) remove this "www." from the URL

Why (how ?) is this "www." added ?

BTW : I don't have this error on 2 test sites which are not https but only http ; All my sites have been upgraded to 4.7.2, but I am not sure that this problem was not there before.

Take a look at this answer.  Another possibility is that your web server has a rewrite that adds the www.  Another possibility is that there's an .htaccess file in your CMS's path that's adding a rewrite.


How to send receipt for previous event sign ups? I set up an event registration form without enabling confirmation emails. We just got a request for a receipt from a registrant. I can't find a way to send a confirmation/receipt email to them a day after they signed up. Or a way for the user to access a receipt on our site. (I have since changed our sign up form to include the auto confirmation email.)

CiviCRM 4.5.6, WordPress 4.1.1

You might want to test the following:

Navigate to Administer Communications > Message Templates, select System Messages, then beside Events - Receipt only. Leave this window open and open another to Administer Communications > Message Templates, and click New template. Copy the subject, html body and text body from system receipt message into you new user one, give it a name and save it.
Navigate to Find Participants, select a registration of your own user for testing (you may need to create one first), then for action select Send email to participants. On the next page, select your new template and send the message. If the receipt looks good in your inbox, repeat this step but sending to unreceipted participant.


How can I deal with "internal server error" during installer? I'm trying to install, but it gives me this error:

  The server encountered an internal error or misconfiguration and was
  unable to complete your request. Please contact the server
  administrator, webmaster@.... and inform them of the time the error
  occurred, and anything you might have done that may have caused the
  error. More information about this error may be available in the
  server error log. Additionally, a 404 Not Found error was encountered
  while trying to use an ErrorDocument to handle the request.

LOG:

File does not exist: /home/master-folder/public_html/my-domain/500.shtml, referer: my-domain. /wp-admin/options-general.php?page=civicrm-install
File does not exist: /home/master-folder/public_html/my-domain/500.shtml, referer: my-domain. /wp-admin/options-general.php?page=civicrm-install
File does not exist: /home/master-folder/public_html/my-domain/404.shtml, referer: my-domain. /wp-login.php?redirect_to=http%3A%2F%2Fmy-domain.com%2Fwp-admin%2F&reauth=1
File does not exist: /home/master-folder/public_html/my-domain/favicon.ico, referer: my-domain. /wp-login.php?redirect_to=http%3A%2F%2Fmy-domain.com%2Fwp-admin%2F&reauth=1
File does not exist: /home/master-folder/public_html/my-domain/404.shtml
File does not exist: /home/master-folder/public_html/my-domain/demo
File does not exist: /home/master-folder/public_html/my-domain/404.shtml
File does not exist: /home/master-folder/public_html/my-domain/robots.txt

thanks

Is this before displaying the first step of install or once you start the install?

If this is during the installation, it might mean that your timeout is configured in a way that it considers the page dead before it properly has the time to finish the install.

You might want to workaround that by either changing the configuration to allow longer running pages, or try installing from the commandline (using wp-cli).

If it is before displaying anything, it might be that you haven't used the proper url or didn't put the files at the right place or...

If you follow the steps on that page, it should get you a running civi:

http://wiki.civicrm.org/confluence/display/CRMDOC/Installing+CiviCRM+for+WordPress


Does this view error mean CiviCRM has lost some MySQL DB perms? The last CiviCRM upgrade I was running, I received a couple of the same DB errors. Sanitized, minimally, the error was as follows:

#7 /srv/www/sites/d1.orgname.org/www/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
#8 /srv/www/sites/d1.orgname.org/www/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("CREATE OR REPLACE VIEW civicrm_domain_view AS SELECT * FROM civicrm_domain")

Does that mean that CiviCRM has lost some of its MySQL DB permissions and I must rebuild the DB (according to these instructions) ?

I went looking for where in the CiviCRM source code that view is mentioned, and found:

$ grep -r civicrm_domain_view *
CRM/Core/DAO.php:      $dao->query('CREATE OR REPLACE VIEW civicrm_domain_view AS SELECT * FROM civicrm_domain');
CRM/Core/DAO.php:          $dao->query('DROP VIEW IF EXISTS civicrm_domain_view');
CRM/Core/DAO.php:          $dao->query('DROP VIEW IF EXISTS civicrm_domain_view');
CRM/Core/DAO.php:      $dao->query('DROP VIEW IF EXISTS civicrm_domain_view');

I tried running this via PHPMyAdmin:

SELECT *
FROM civicrm_domain_view;

And receive an error that the view does not exist.
"#1146 - Table 'd1_civicrm.civicrm_domain_view' doesn't exist"

Next I tried executing:

CREATE OR REPLACE VIEW civicrm_domain_view AS SELECT * FROM civicrm_domain

which told me the MySQL ID did not have permissions to create the view.

So I checked, what do you know that was not a permission I granted to the CiviCRM ID. I provisioned the MySQL account according to these instructions. They do not state that the Create_view_priv perm is required, if this is even the correct perm. (I just saw the word "view" and looked there first.)

Suggestions?

I am thankful,

Michael

You're on the right track--when you see a MySQL error and you can't see what's wrong with it, try it out manually.  It seemed like a permission problem on the face of it, and the error you got was a lack of permissions.
I think the wiki just threw you off with how it is written.  It does say,

  Also, to enable CiviCase you should set CREATE VIEW permission.

That's just in this aside just before the main list.

Now, if you don't use CiviCase, you still might try granting that permission and trying it out--I wouldn't put it past someone to change Civi without updating the wiki! Many of us would never notice--I typically give that permission to the DB user as part of a standard setup, and I bet many others do too.


How to add new membership if renewed after old membership expired (native CiviCRM / Drupal) Consider this:

Wilma becomes a member on 1 Jan 2016, but does not renew at the end of the year.
(so throughout 2017, 2018, Wilma is not a member)
Wilma joins again in Jan 2019.

According to the documentation, CiviMember will find the original membership and change the start date to 1 Jan 2019 and the end date to 31 Dec 2019, and set the status to live (or new etc.)

This now looks like Wilma has been a member since 1 Jan 2016, but that's not the case.

Is there a way to have CiviMember create a new membership and leave old expired ones (i.e. those with "member: No" configured for their membership status) as-was?

There's a similar question that seems to be focussed on a WordPress/Caldera forms environment, but I'm asking about CiviCRM's native forms, hence the separate question.

I do not believe this is possible as of CiviCRM 5.4 at least.

The logic is coded in civicrm/CRM/Member/BAO/Membership.php so the only way to override this is with a core override file, which is a maintenance headache since it will need re-working on ever upgrade.

This patch seems to make it work as I think it should:

diff --git a/civicrm/CRM/Member/BAO/Membership.php b/all/modules/civicrm/CRM/Member/BAO/Membership.php
index 18269014..7713ee9e 100644
--- a/civicrm/CRM/Member/BAO/Membership.php
+++ b/civicrm/CRM/Member/BAO/Membership.php
@@ -1860,6 +1860,14 @@ INNER JOIN  civicrm_contact contact ON ( contact.id = membership.contact_id AND
     $currentMembership = CRM_Member_BAO_Membership::getContactMembership($contactID, $membershipTypeID,
       $is_test, $membershipID, TRUE
     );
+
+    // -------Begin patch to create new memberships if last one had expired-------
+    if ($currentMembership && !$currentMembership['is_current_member']) {
+      // Force a new membership.
+      $currentMembership = NULL;
+    }
+    // -------End patch to create new memberships if last one had expired-------
+
     if ($currentMembership) {
       $renewalMode = TRUE;


Webform CiviCRM country field Just wonder if there is a way to show country name in country field while keeping the field readonly/"disabled" on webforms? For example, you want users to see their countries but not editing them. The closest I can get is to change the field type to textfield and "disable" it but it shows the country code instead of country name.

If you're creating a link from elsewhere that pre-populates the information, you could use a Drupal Views block that displays the country field as read-only.  (For reference: Displaying a Views block with a CiviCRM-enabled webform)


How to install the missing countries When adding a new contact, I want to insert the address including the country. However, in the drop-down menu, only a few countries are listed.
How can I add missing countries to the drop-down menu at the address field?

From the CiviCRM menu -

Administer > Localization > Languages, Currency, Location.

Select required countries from the 'Available Countries' option.

CiviCRM help on this option -

Which countries are available in the Country selection field when adding or editing contact addresses. Profile and Custom 'Country' fields also use this setting. To include ALL countries, leave the right-hand box empty.


React with CiviCRM APIs I am trying to use the CiviCRM APIs from my React application. Which API methods would be the one recommended or easy to do with React application ? The easiest would be REST but since my page and civicrm will be hosted on the same machine, I prefer not to go down the REST route.

I read that CiviMobile uses react but didn't get too much information on its implementation.

Any recommendation and also examples or tutorials that I can reference ?

thanks.

I have no idea what your React application is so I am not going to be able to answer your question easily :-)

There is an API section in the CiviCRM Developer Guide that should help you: https://docs.civicrm.org/dev/en/latest/api/


How do I disable custom css on frontend with Wordpress? I currently have a custom CSS file specified in Settings > Resource URLS. In this CSS file I override some civicrm.css styles to make the CiviCRM admin screens look a little more like the Wordpress admin area. However, I would like to disable this file when viewing frontend pages e.g. contribution pages.

I've tried the basic usage of the Wordpress wp_dequeue_script option but I can't find what the handle is for this file, so this doesn't work.

Note: I have successfully disabled the standard civicrm.css on my front end pages with this code in functions.php suggested by another user:

function rs_remove_civicrm_styles() {

  global $civicrm_root;

  if (empty($civicrm_root)) {
   return;
  }

  $civicrm_css = CRM_Core_Resources::singleton()->getUrl('civicrm', 'css/civicrm.css', TRUE);
  CRM_Core_Region::instance('html-header')->update($civicrm_css, array('disabled' => TRUE));

}

But I'm not sure same method can be used for the custom css file?

It might be simpler to just tweak the css to apply only to the admin pages using body.wp-admin (there may be more specific CiviCRM or WP classes you can use).


Problem with contribution - redirect to Home Page I have two types of contribution page (for different purposes) one requires sign in and the other does not.
When a user goes to go to either contribution page for the very first time and clicks on confirm payment, the system goes into an endless loop that ends up on the Home page.  If from there one goes to the  contribution page again, it works fine.

Any Ideas what could be causing this?  Oddly it does not happen when someone registers to an event.

Please any feedback is welcome, I need this fixed before the end of ther year.

Thank you

Edited:

I figured out the problem, but not yet the solution.  it has to do with the URL intial URL has www.xxxx.com once it is sent back to the Home page the URL is xxxx.com (no www)

the setting in the civicrm.settings.php does not have the www.  Is this right???  should it have the www???  any help is appreciated.

thank you

Fixed!!!

CIVICRM_UF_BASEURL has to have www


Measure open rates for standard emails from Civi, not from Civimail Is it possible to measure open rates and/or click-throughs from a particular scheduled reminder email?

Civimail has well developed functionality for open rates and clickthroughs etc, but we have a use case that calls for people to receive an email from a scheduled reminder at the time when they sign up to a group (the email will be sent as a result of an activity generated when they sign up to the group.)

The people are signing up on paper, so there's no problem with spam nor need for double opt-in. Our volunteers are then going to enter people into a webform and at that point the system will send them an email.

We'd like to measure open rates and/or click-throughs from that email.

Is there any cunning trick to make this possible?

If not we can of course adapt our procedures to send mailshots from CiviMail to people every 4 or 6 hours... but that manual process is an additional complexity.

We can also pull these people into MailChimp and do it from there, but we'd lose quite a bit of data possibilities if we did it that way.

Hence my question.

Thanks for your help.

Not sure you'd class this as cunning or hacky but we have a trick & some code. Essentially we've changed scheduled reminders to send from CiviMail rather than triggering it's own one-shot emails. Workflow something like this

Set up a regular email in CiviMail complete with tracking
Send to a test group of internal emails
Set up your scheduled reminder, with our code the interface can now select previously sent CiviMail emails instead of building the email in Scheduled reminders
What ever triggers the email triggers it and the corresponding email adddress is added to the email spool for the CiviMail email, next cron Civi notices the spool has one more email compared to sent emails and sends it's to the extra email.

It's not perfect as the activity date is on the original CiviMail send, which is something I want to clean up. Talk to Parvez @ Veda he should be able to supplt you with the code.


Custom Data Set - Saves but does will not display I created a custom data set of type Tab with Table that accepts multiple entries, and I have added this to the New Individual form.

I can then create a new individual and hit save, after which time the Tab with the custom data fields is displayed. I can enter data into the custom data fields and save it.  After I save, the count displays that it has been created, but nothing appears in the list/table except a message that says "No records of type '' found."

Is this a bug?

Sounds like a bug, which version of CiviCRM are you using? Which version of which CMS are you using?

Can you repeat it on
http://dmaster.demo.civicrm.org
or
http://wpmaster.demo.civicrm.org
?


Drupal Block on Specific CiviEvent Page (How to?) I can use this with PHP visibility feature to get a block to show on the Event Page.

<?php
$match = FALSE;
if (current_path() == 'civicrm/event/register' && isset($_GET['id']) && $_GET['id'] == 74) { $match = TRUE; }
return $match;
?>

However, if they submit the first page and there is a validation error, they get sent back to the URL of: /civicrm/event/register and the visibility setting no longer works.

Does anyone have a way to fix this?

Drupal 7.x CiviCRM 5.5

One option is to use .extra.tpl files to load the data you wish to display, rather than the block.  An explanation of the technique is here.  This avoids having to worry about whether something that's in scope for CiviCRM isn't in scope for the PHP visibility block.

Another is to check the value of the $_REQUEST or $_POST supervariables for some element that is specific to this page (e.g. I'm guessing the page ID is in there somewhere).  If so, you could test for the presence of that value.


After upgrade, System Status page is empty, but issues display in popup I've just upgraded from 4.4 to 4.7.20.  Everything seems to be working as expected, except that the "System Status" page is empty. Just blank where there should be the "CiviCRM System Status" widget.  However, I know there are some issues because the footer displays "System Status: Error", and when I log in I see a CivicRM system popup messages listing the issues I need to fix.

When I try to load the System Status page, there are no errors in the CiviCRM logs or in the Joomla/PHP logs. The Firebug console gives a warning "Empty string passed to getElementById()." and references [docroot]/media/jui/js/jquery.min.js

Seems to be similar to this problem

System Status page empty and status remains 'critical' after updating from 4.7.8 to 4.7.11 on Drupal 6

though I am on Joomla not Drupal. And there doesn't seem to be a resolution in that post.

I also found this post (Status Error and blank status page) but I checked and all my permissions seem to be correct.

Ideas?

Well, I'm not sure this is a long-term solution, but it is a workaround....

In one of the Angular posts (Status page angular load error) I found this:

  another work-around should be going to "Administer => System Settings => Debugging" and disabling the "Asset Cache"

That's brought my System Status page back, but I don't like the thought of not using a performance enhancement.


Search custom fields with multiple records I'm not really sure how to describe this but  hopefully I can describe it clear enough.

I created a custom field set that holds borrowing information for items (like tools, equipment, etc.). It has 3 fields (actually more, but here 3 is enough to describe the problem): Item name, Date borrowed, Date returned.

A contact can borrow multiple items at once.

Is there a way to search for contacts who have not borrowed any item in the last 6 months?

Thank you.

One way is to do an exclude search.

Create a smart group that has all the people who have borrowed a tool in the last 6 month.  Create another smart group that contains everyone.

Under Search => Custom Searches you should find the custom search "Include / Exclude Contacts in a Group / Tag".

Include your group that contains everyone.
Exclude your group that contains the people who have borrowed.
This should result in the people who haven't borrowed.


Contribution form displaying in footer of WordPress site after form submission On a Wordpress site which uses the theme "Enlightenment" I have used civicrm shortcode to embed a civi Contribution form on a wp page. All is well until I click the Confirm Contribution button.. the next page that is returned (Contribution confirmation page) has the form results replicated in the wp/enlightenment footer

a part of the footer as it appears before contribution submission: http://imgur.com/UaFsXKK

same part of the wp footer as it appears after submission..
http://imgur.com/Sujo2ht

I've studied the page source for these two cases and it appears that civi's

It seems that the problem is related to the civContribution webform submission - any ideas on why the proper style inheritance would be lost after form submission and how/where I can fix this problem?

I realize this is a case of Enlightenment probably doing something the civiContribute doesn't expect but since all is well before form submission I suspect that there could be a civi way to fix this.

I installed the plugin Multiple Themes (https://wordpress.org/plugins/jonradio-multiple-themes/) which allows me to set a different wp theme (e.g. Twenty Fifteen) just for the /?page=CiviCRM pages. Now I no longer have the replicated webform problem. The Contribution page appears has a different look & feel but I'm ok with this. Thanks so much for the help Andrew.


Can't add custom field to form I'm trying to add a custom field to the Event form programmatically.

So far, I've created a new extension and enabled it, with hook_civicrm_buildForm function in a PHP file. The function's being executed as I can get it stop at a breakpoint. I'm using the addEntityRef method to add a new field.

/**
 * Implements hook_civicrm_buildForm()
 *
 * Adds a field for linking a parent event
 *
 * @param string $formName
 * @param CRM_Event_Form_ManageEvent_EventInfo $form
 * @return void
 */
function myExtension_civicrm_buildForm($formName, &$form) {

  if ($formName == 'CRM_Event_Form_ManageEvent_EventInfo') {

    $form->addEntityRef('my_field', ts('My Field'), [
      'entity' => 'Event',
      'placeholder' => ts('- any -'),
      'select' => ['minimumInputLength' => 0],
    ]);

    $form->buildQuickForm();
  }
}

I've followed other posts by adding a template file named my_field.tpl in my extension's templates directory with the contents:

  Parent Event:
  {$form.my_field.html}

{* Reposition the above block after the Event Type field *}

But I am struggling to get the field to appear.
TIA

There are multiple ways to do this. One is to use a .extra.tpl which has to have the same path and first part of the name as the original .tpl where you want it to get inserted. If you name it that way the tpl file will get picked up automatically. So in this case the original .tpl that controls that event screen is in templates/CRM/Event/Form/ManageEvent/EventInfo.tpl, so you want to make a file templates/CRM/Event/Form/ManageEvent/EventInfo.extra.tpl

Another way is like in your original question but then you're missing the line from the docs (https://docs.civicrm.org/dev/en/latest/hooks/hook_civicrm_buildForm/) that says

CRM_Core_Region::instance('page-body')->add(array(
  'template' => "{$templatePath}/testfield.tpl"
));

to tell it the path and name of your template file. Otherwise it doesn't know about your .tpl file.


Climbing Gym Management I would like to know if CiviCRM is the right choice to manage contacts and entrances of a climbing Gym.
At present we manage subscrition manually with forms, and sell single entrance tickets and multiple prepaid entrance cards.
I would like to store the contacts subscribed with expiry date, track every entrance and manage the balance of the 12 entrance pre paid card.
Is this possible using native CiviCRM or extensions ?

Thank you very much !

civicrm doesn't have an out-of-the-box solution for the 'tracking every entrance and manage the balance of the 12 entrance pre paid card', but that said, there are ways you can work through this I expect. I know we did a solution once upon a time for a Museum which also offered a 'subscription' which we implemented as a 'membership'.

The difficulty as I see it with the 12 entry card, is that you don't have a timeframe - hence membership isn't appropriate - nor is it an Event.

You could make a special Contribution type that has a custom field with checkbox for 1 through 12, and have that come up on the system so you can add an extra tick on it, or use Activities and somehow track the count on them (perhaps even like a Case).

Maybe someone else can suggest an Extension that I am not aware of.


Repeat Contributions Report - Where Is Data Pulling From? We are new to CiviCRM and have just started importing data and running checks. We have imported the last five years of our donor contribution information and all of the data is correct in the BOOKKEEPING TRANSACTIONS REPORT but when running a REPEAT CONTRIBUTIONS REPORT the totals don't match even though the listed transactions and totals match the BOOKKEEPING TRANSACTIONS and our imported csv file. All of the filters and dates are identical. We thought this might have to do with merged or deleted records? We did permanently delete records that included contributions was this incorrect?

Any hints are appreciated - Thank You, Kim

CiviCRM has a notion of recurring contributions that is slightly more than just repeated transactions with the same information. Users can set up a series of contributions on a monthly or annual basis (or actually daily or weekly) that will charge an online payment processor appropriately. There is a separate table for storing the information about the recurrence, civicrm_contribution_recur, which is accessible via the API. Note that you can connect contributions to the appropriate record in this table by setting civicrm_contribution.contribution_recur_id.


way to test stripe recurring failed payment Whenever recurring payment failed due to change in card number, card expiring, cancellation of credit card, or the card issuer not recognising the payment. I have to sent notification to user. Stripe have inbuilt functionality to sent notification but does not have way to customize the message sent to user.

I have to sent that message through civicrm.

CiviCRM already have functionality to handle 'invoice.payment_failed' event type which change status to 'Failed'. On top of that i have to send email notification to user.

Main question is, how do i generate testing scenario through CiviCRM to receive 'payment_failed' notification.

I think you can use unit test to check Failed recurring from stripe extension. It does cover most of the test for IPN.

You can find more details about the unit test here.

HTH

Pradeep


How is "recent" defined when using recentmenu extension? the recentmenu extension is a nice feature.   How does it define recent?   by number - e.g. last 12 items?  Or date?   this week, etc.

You can set preference by going to Administer > System Settings > Misc (Undelete, PDF,.......)


Update custom field from other custom data I'm trying to use a php hook to automatically create a relationship between two contacts. Let me set the stage for you.

Meeting Extender: a custom data set that extends the meeting activity(activity entity). It basically records a few custom fields, two of which are contact references(think pitcher and pitchee). These two fields would be two integers referring to contact A and contact B. Basically, I want to write a hook that creates a relationship, called Pitched to (A to B) and been Pitched(B to A).

The pipeline

A meeting is created, in the custom field set Google is saved as contact A and Apple is saved as contact B. The hook should realize a new activity has been created, check if the Pitched relationship exists between Google --> Apple and if not create it.

This was my attempt so far(in an extension)

function checkActivityMakeRelationship_civicrm_post($op, $objectName, $objectId, &$objectRef) {
/* This file checks if an activity was created and if so
 */

    if(($op == 'create' || $op == 'edit') && $objectName == 'Activity') {
        $result = civicrm_api3('Relationship', 'create', array(
        'sequential' => 1,
        'contact_id_a' => **integer-referring-to-contact-a**,
        'contact_id_b' => **integer-referring-to-contact-b**,
        'relationship_type_id' => 11,//this is the relationship type for pitched
    ));
    }
}

Ignoring the 'relationship-already-exists' check for now, how to I find the correct integers for the contact A and contact B i just entered in to my custom data set. I imagine it is a part of $op but I'm not sure how to access it. Any help is appreciated, thanks.
V

PS: I'm running wordpress 4.2.4 and civicrm 4.6.6

SO I was able to figure this out, turns out I wasn't able to reference the custom data directly from the activity object but had to use the api to grab the custom data related to that activity object.

function checkActivityMakeRelationship_civicrm_post($op, $objectName, $objectId, &$objectRef) {
/* This function checks if a specific activity was created and if so makes a related relationship
*/

if(($op == 'create' || $op == 'edit') && $objectName == 'Activity') {
    $params = array(
        'sequential' => 1,
        'id' => $objectId,
        'return' => "custom_50,custom_51",//replace with your specific custom
    );
    $activity = civicrm_api3('Activity', 'get', $params);
    $contact_a_id = (int)$activity[values][0]['custom_50_id'];//note the appended _id
    $contact_b_id = (int)$activity[values][0]['custom_51_id'];// appended _id
    $result = civicrm_api3('Relationship', 'create', array(
    'sequential' => 1,
    'contact_id_a' => $contact_a_id,
    'contact_id_b' => $contact_b_id,
    'relationship_type_id' => 11,//your specific relationship id
    ));
}

}


Path problem for webhooks and other internal resources I suddenly have a path problem on one of the sites I look after. I just updated to Civi 5.28.3 and wordpress was already at 5.5. I can't swear that the problem occurred because of the upgrade though.
The problem manifests itself when some URLs are built. I can see it in the webhook paths (missing the host and directory path):
Stripe Webhook missing or needs update! Expected webhook path is: ?civiwp=CiviCRM&q=civicrm%2Fpayment%2Fipn%2F4

and I have noticed the same behaviour for various placeholders in the Mosaico extension when i use the inspector to look at the code sent to the browser.
I looked at the resource path settings and they all look ok and are a match for the same settings on a working civicrm site I have.

I have done a slow scroll through civicrm.settings.php, but have seen nothing that seems concerning. The site was seemingly working last week before the upgrade. I suppose I could roll back, but I'd rather not if I can simply find where the path is being set and fix that.
Any thoughts?
UPDATE:
I have, as suggested followed the threads in the post linked below, but all of my paths report correctly when viewed in the admin settings pages (see above) or when queried on the command line:
root@kaos01:/var/www/civi.sitename.org/wordpress# cv path -d [civicrm.files]
/var/www/civi.sitename.org/wordpress/wp-content/uploads/civicrm
root@kaos01:/var/www/civi.sitename.org/wordpress# cv url -d [civicrm.files]
"https://civi.sitename.org/wp-content/uploads/civicrm"

I have also explicitly set the civicrm.files path and url variables in civicrm.settings.php
$civicrm_paths['civicrm.files']['path'] = '/var/www/civi.sitename.org/wordpress/wp-content/uploads/civicrm';
$civicrm_paths['civicrm.files']['url'] = 'https://civi.sitename.org/wp-content/uploads/civicrm';

Certainly, it seems clear that the URL string is missing when needed, but I can't figure out where else to look.
I have now discovered the problem on a second site.
FURTHER UPDATE:
Though the problem is occurring in multiple places I'm focussing on the STripe plugin as it makes it very visible. The MJWshared extension uses CRM_Utils_System::url to assemble the needed webhook url. it seems clear that CRM_Utils_System::url is not finding the base part is needs, but it is not clear to me how that function goes about finding the bits it needs.

This Question is related.
Extensions will read the path and URL so going through the steps in taht question should help.
You will need to update the stripe webhook as well.


Session Key issues after upgrading from 4.4 to 4.6 I've upgraded from 4.4 to 4.6.10 on Drupal 7.41. I'm getting the following issue when attempting to make a contribution:

  We can't load the requested web page. This page requires cookies to be
  enabled in your browser settings. Please check this setting and enable
  cookies (if they are not enabled). Then try again. If this error
  persists, contact the site adminstrator for assistance.Site Administrators: This error may indicate that users are
  accessing this page using a domain or URL other than the configured
  Base URL. EXAMPLE: ...Error type: Could not find a
  valid session key.

I didn't have this problem before updating to 4.6.10.

I have cookies enabled.

I have confirmed that the Civi and Drupal base URLs are the same and match what is in the address bar of my browser.

Drupal caching is currently disabled.

I have a user 0 in my Drupal database.

Finally and this is the weird thing, when I get the error if I click the back button and resubmit the form it works fine.

Does anyone have a solution or work around for this problem?

Updates

Turns out while the message references sessions it has to do with the contribution page losing the ID but it's an issue with the payment plugin.

Turns out while the error message is about the session key the issue is with the stripe payment processor plug-in.  I'll raise the issue on the plug-in's issue queue.


How to add a tag or group to a set of pre-existing contacts via import? I have a list of contacts (names and email addresses). I know that all of these contacts are in the Civi database, but I want to add a tag or a group to all of them, and i have the list in a CSV file. What I should be able to do is simply import the contacts, setting 'Update' or perhaps 'Fill' as my duplicate matching option, and set the tag and/or group to be set in the import settings. Just tried it - several times, using various different options, and it failed every time, reporting that 0 records had been tagged (or added to the group). This is with Civi 4.7.19.

Is there a specific set of options that I need to know about to get this to work? This post (How to tag a contact when importing possible duplicates) suggests that this should just work. I followed that example and it failed.

To bypass this problem, I use Yes/No custom field to import the data "Belonging to A group". Then I use an advanced search to select those contacts and add them to the A group.


Eway recurring - Any method to record invoice reference and description? Eway provides a way to add invoice ref and description by adding params like InvoiceDescription and InvoiceReference in alterPaymentProcessorParams hook provided by civicrm.
Unfortunately this does not work for recurring payments.
Eway does not seem to provide any flexibility to set Invoice reference or Invoice Description for a recurring payment. See the parameter that could be set - https://eway.io/api-v3/#recurring-payments.
Any thoughts for an alternative way to set these field values?
We are using Eway recurring extension to record payments in civi - https://civicrm.org/extensions/eway-recurring-payment-processor

ok - this has fixed for us and the reason was the incorrect param sent to the ProcessPayment operation. The correct way of sending the invoice params is -

$client = CRM_Core_Payment_EwayUtils::getClient($params['payment_processor_id']);
$endPoint = 'https://www.eway.com.au/gateway/managedpayment/ProcessPayment';

$paymentInfo = array(
  'man:managedCustomerID' => $params['managed_customer_id'],
  'man:amount' => $params['amount_in_cents'],
  'man:invoiceReference' => $params['invoice_id'],
  'man:invoiceDescription' => $params['description'],
);
$result = $client->call('man:ProcessPayment', $paymentInfo, '', $endPoint);

Note the correct usage of man:invoiceReference and man:invoiceDescription. It should be case-sensitive.


How can I disable households? Our organization does not use households. As a training/usability issue for our volunteers, we would like to disable the concept entirely or at least hide them from view. There does not appear to be a mechanism to do so, however.

This feature has been requested for some time; there is a 2008 thread asking essentially the same question, but unfortunately it leads only to other dead-end threads. A feature request for the 3.0 branch was summarily closed for lack of activity.

If there remains no configuration mechanism to remove households, has anyone developed a comprehensive list of places where households are referenced? For instance, we can remove the navigation menu items from the UI, disable the reports, and use CSS to hide mentions on some forms. We would prefer, going this route, to override a template to remove the option, but we haven't been able to locate such a template or templates.

The same question, presumably, could be applied for anyone who does not use individuals or organizations as contact types.

Households can be disabled globally by disabling that contact type. This is not exposed to the UI but is still pretty easy to do:

From the api explorer (Support -> Developer -> Api Explorer) make the following selections:

With a direct sql query:

UPDATE civicrm_contact_type SET is_active = 0 WHERE name = 'Household';

Note: there may be a few places left in the UI that are hard-coded with households still available, but the above will handle the vast majority.

Addendum: You may also want to disable the Household profile. This will remove the "New Household" links from contact autocomplete form elements. Run the following query to do that in MySQL:

update civicrm_uf_group set is_active = 0 where name = 'new_household';

(thanks to comment from @bgm).


Wordpress quick contact search render glitch I have been trying to fettle this for a few hours - when quick searching for a contact on Wordpress, the results appear behind the Wordpress admin menu.  I can't see anyone else who has reported this issue, is it a known problem?

Latest Shoreditch enabled (and only happens with Shoreditch enabled), Civi 5.10.0, WP 5.0.3

Thank you!

(PS, personal data shown in this image is a fake contact)

Whilst the extension page https://civicrm.org/extensions/shoreditch says that Shoreditch is CMS independent, the release notes https://github.com/civicrm/org.civicrm.shoreditch say that Drupal is a requirement, so I don't think you can expect it to work.  Much as I would love to have it on Wordpress.


New Install "MYSql Server Has Gone Away" Good evening, I'm new here and trying to get CiviCRM installed for the first time (volunteer sysadmin for a non-profit).
I think I have gone through all of the steps to troubleshoot but I suspect I am missing something.
Relevant Versions:

CiviCRM - 5.27.3
WordPress - 5.4.2 (Multi-Site enabled but only primary site exists)
Azure MySQL instance - 5.7.29-log
Linux (Separate from MySQL) - "Ubuntu 18.04.4 LTS"
PHP - PHP 7.2.24-0ubuntu0.18.04.6 (cli) (built: May 26 2020 13:09:11) ( NTS )
NGINX - nginx/1.14.0 (Ubuntu)

Attempted adjustments:

Initially ran into SSL issues (Had MySQL set to SSL Enforce) Found some requests to adjust CiviCRM to accommodate this but in the meantime turned off enforcement to try and get the install to work. (This got me to the error below, all other changes listed have had no impact)
Ran as admin user
Updated MySQL config options (Timeouts, Innodb, max sizes, etc.)
Updated php.ini settings (timeouts, reconnect, etc.)
Repaired/Optimized Wordpress DB
Manually ran in civicrm.mysql to create tables
Followed XKCD Flowchart (https://xkcd.com/627/) regarding "MySQL Server has gone away"
Searched for install logs to try and find what was causing the error (failed to locate)
Ended up here, the results from the check seem to contradict (connection works well for all things EXCEPT knowing if the server is there)

Thanks for any ideas/direction.

+1 for the xkcd reference.
There's some work being done on SSL but for the "server exists" error this is a known issue for azure. See https://lab.civicrm.org/dev/core/-/issues/1206
Briefly, just comment out the body of the check it mentions and instead make it always return TRUE: https://github.com/civicrm/civicrm-core/blob/5.16.2/install/index.php#L1036


How do I add a new table to my extension? I have added tables to my database by writing SQL commands in a sql folder as specified in the given link.
Add a database upgrader / Installer / uninstaller.

What I am exactly looking for is a method to access these tables, do I need to write direct SQL for adding records to the table or I should create corresponding DAO and BAO to access the table.

How to create DAO and BAO for a given table in an extension?

What I did for the sepa extension is a bit of a hack, but worked ok:

write the xml schema files, as you have them on the (development version) core and run xml/phpGencode.php to generate the dao, that you then copy into the extension folders and voila, you got the tables ready to use (for a few more lines, you got the api files, worthwhile IMO)

The process is now detailed in our developer book


CiviRules - where is the data stored in the database? - backdating I've got a CiviRule that triggers when a membership is added and is delayed by 3 months, but i want to back date it for existing memberships, ie any membership less than 90 days old (if it was 88 days old, my rule would act in 2 days time)

Assuming there's not a clever way of doing this up front, i'm happy to manipulate things directly in the database, but haven't found anything but the civirule_rule_log which actually changes on triggered conditions - where is the part that acts?

thanks!

Be really careful of what you are doing. But the delayed actions are stored in the civicrm_queue_item database table.

The column release_time indicates the date from which the action is going to be executed. The data for the action is stored as a serialized data blob in the column data.


Shouldn't CRM_Core_PseudoConstant::get localize parameter be setted to TRUE by default? Some translations are missing in non-english language (french in my case), because of the fact that localize's parameter is set to FALSE by default with no way to change it via configuration.

So my question is why that ? And not the opposite ? And best of all why not when the language is not english set localize to TRUE.

Case statuses are user-defined option values (configurations). If you have installed CiviCRM initially in English, then switched the language, you will have to edit/translate the case statuses manually in: Administer > Case > Case statuses (/civicrm/admin/options/case_status?reset=1).


smart groups showing on tab CiviCRM 4.5.8(really any version, I think) and WP 4.2.4.

In a contact record the Groups tab will show a number.  This is the number of the "Regular Groups".  Is it possible to also show/combine the Smart Groups number on the Groups tab as well?

Gary,

the quick answer is no ....the way CiviCRM stores the groups for a contacts is different than the way CiviCRM determines which smart groups a contact is in. There is one group table that references which contact is in which group.  This table does not contain smart group references.

See the CiviCRM group architecture here


Enable Volunteer Opportunity Listing with Wordpress I am using CiviVolunteer with wordpress and I am trying to enable the volunteer Opportunity Listing. I tried the following link the http://address-to-your-site/civicrm/vol/#/volunteer/opportunities link with my domain and I am not able to see it. I have angular profiles enabled, and I granted access to AJAX API and CiviVolunteer: register to volunteer to anonymous users, but I am still not able to see this list publicly. Is there something else wordpress users need to do to view the volunteer opportunity listing?

If your wordpress install will not show volunteer opportunities, this is what worked for me:

/civicrm/?page=CiviCRM&q=civicrm/vol/#/volunteer/opportunities

instead of:
/civicrm/vol/#/volunteer/opportunities


Exporting custom profile questions Is there a way to export custom profile questions? Either as a event report or just in general?

Yes you can export Custom Data. If those fields are used for Contacts rather than eg Participants it is probably easiest to do this via Adv Search. Find the contacts you want. Then
- go to Actions and
- select 'Export Contacts' and then click on
- Select Fields for Export
- then choose the fields you want to export
- once you have done this you can Save your Export Mapping and choose it another time

If the data was stored on the Participant record then you might find this easier to do via Find Participants

If you are not sure if the Custom Fields are used for Contacts or for Participants (look in the Custom Field Set page at /civicrm/admin/custom/group?reset=1 and see what it says it is Used For.


The charts on the civicontribute dashboard do not display Trying to figure out why the charts on the my WordPress / CiviCRM 4.7.27 CiviContribute dashboard are not displaying. We see no errors on the front end, but no charts appear.

Anybody have any good ideas on why this may be happening?

This is usually because of flash player not allowing to load on all sites. I added the site in allowed section for flash. Here is what i did

Navigate to Chrome settings >> Privacy and Security >> Content Settings >> Flash.
Add site url under allow section.

HTH

Pradeep


Login Fails For One Account, But Not For Others A user on our client's CiviCRM site [CiviCRM(4.6.5)/Drupal(7.36)] is having trouble with her login. Each time she attempts to login, she is greeted with an error indicating that she has entered her password incorrectly.
Testing her login from another location/network, I am able to login using her credentials.
Using a JoinMe session to share her screen, I am able to login to CiviCRM using my credentials (as well as several others), but when I use hers, her login fails.
I have cleared the cache on her browser, cleared caches on CiviCRM, and have tried updating her user-password, but get the same results each time I attempt to login from her PC (Windows10).
It seems that there is something wrong with her account, but I have directly inspected her user-record in the Drupal users table and can find no anomalies which would explain why she cannot login. Her user-roles are all correct as well, but still she cannot login.
Has anyone else had this problem with one of their CiviCRM users?

Just to clarify, this appears to be a Drupal issue, not a CiviCRM issue as Civi is not involved in checking passwords. I'm just fishing here, but I would try the following:

Clear the Drupal caches.
Delete relevant cookies in the browser.
See if you can login using a different browser on the same machine.
Change the users password.


Is there a "best" forum for suggesting improvements to CiviCRM? As a developer, when I have an idea for a feature improvement to CiviCRM, and am interested in helping to make that happen (submitting a patch and tests, for example), what's the best place to start a conversation about things like a) whether it's a good idea, b) how it might be made into a better idea, c) whether it's likely to be desirable in core or better as an extension, etc.?

Channels I can think of include these, in no particular order:

One of the lists at http://lists.civicrm.org/lists/
One of the boards at forum.civicrm.org
IRC (#civicrm on freenode)
This StackExchange site.

Edit: I guess I'm wondering if there even is a definitive "best" forum for such discussions.

I think it would be useful to ask a self-serving question in SE and then answer it yourself. I think SE has a more public audience and hence improvements get noticed.

In addition, I would suggest starting off on one of the new chat.civicrm.org channels depending on whether it is 'hey i have this new idea' (maybe town square) or 'i need to insert x in to y while not breaking z' perhaps in the developer chat.

hth


Silent error when accessing php API has not logged in user I'm having a strange problem using the CRM API thru PhP (i.e. not REST or AJAX). I'm trying to build a donations counter which tracks the total amount of contributions made under a specific contribution source. Everything works when I'm logged in. But when I'm not, I get a silent php error and my theme breaks. The only thing I can guess is that it might be related to user permissions. So I gave not logged in users the ability to Access CiviCRM and View Contributions. I can confirm this works using the dashboard. But I still cant get the API calls to work without breaking the site.

Things I have tried:

Adding 'check_permissions' => false to the call
Surrounding the calls in a try / catch block
Switching user context in d7 to the root user and then back again.

Maybe it's not even a permissions problem after all..?

CiviCRM version is 4.7 with Drupal 7.

The recommended way to include the necessary files to run the php API is to call civicrm_initialize() before the API call.


CiviCRM (Drupal 7) Problem sending bulk emails Before anything I hope you can escuse my poor english and little technical knoledge.

We are working with CiviCRM (4.2.7) on Drupal () and the function of bulk mail have sudenly stopped working.

You can prepare and redact an email and even send it, but the email is never sendt, keeping you waiting and waiting forever.

We dont have this problem sending individual mails, only with the bulk mail function.

I wonder if anyone have ever sufferd similar problems and what have they done to fix this.

Can someone help us?

Thank you all

Sending bulk emails depend on execution of scheduled jobs present at civicrm/admin/job?reset=1 URL path OR Administer -> System Settings -> Scheduled Jobs navigation menu.

The name of the job is Send Scheduled Mailings. Pls check if this job is enabled and running on your site.

Also, check the status of the bulk mail you created via civimail.

If the status is scheduled - the mailing is awaiting the execution of the scheduled job.
If it is "Completed" - the mailing is sent to the recipients.

For more info - check https://docs.civicrm.org/user/en/latest/email/mass-mailings-using-civimail/


Module or extension to use for tracking agreements? I'm looking for a module or extension that has been written for tracking contracts/agreements between organizations within CiviCRM (on drupal). We would like to be able to track all the activities that happen related to that agreement within CiviCRM.

I thought Cases might be a good way to do this, but they are started based on a single contact.

You can setup CiviCase to enable multiple clients per case, by editing your xml/configuration/Settings.xml file. Set <AllowMultipleCaseClients>1</AllowMultipleCaseClients>


Wordpress base page error I need help with base pages for wordpress.
I am getting a civicrm system error:
CiviCRM relies upon a base page in WordPress, but it is not published.
On the setting page, there is the text:
By default, CiviCRM will generate front-facing pages using the home page at https://idahonativeplants.org/ as its base. If you want to use a different template for CiviCRM pages, set the path here.
The base page is set to the default home page of the site. I do not understand why I get this error, the page most definitely is published.
Wordpress Version 5.5.1
CiviCRM 5.29.1

That message is misleading and we'll need to fix that.   Using the home page as the base page just won't work.  A WP Page needs to be created and set as the base page.
There should be (depending on your version) a System Alert that reads:
CiviCRM relies upon a base page in WordPress at http://example.org/, but it is missing. The default is https://example.org/civicrm, which does exist on this site. You can set the correct base page in the WordPress integration settings.

CiviCRM needs a WP page set as the basepage.  This should be set in wp-admin/admin.php?page=CiviCRM&q=civicrm/admin/setting/uf&reset=1  New installs create 'civicrm' as a WP Page and set that as the basepage.


Making a simple contribution page template I am using CiviCRM 4.7.24 on Drupal 7.56.

I want to embed in a different website an iframe that shows a simple contribution form of CiviContribute, and styles it according to the website.

I would like to create a simple, blank, template that only shows the donation amount and email address, and submit button. Without any Civi styles like the header, the navigation, etc.
And I can't find which template is the right one to edit.

The page I would like to edit is:
domain/en/civicrm/contribute/transact?reset=1&id=2

How can I locate the relevant template? Is there already a clean blank contribution template I could use?

The template would not have anything to do with the styling to make it look like the rest of your website. Styling is in the CSS files. If you do not want to see the header, etc. just use display:none in your CSS file.

But... Are you talking about not seeing the embedded website header, nav, etc? If so, that has nothing to do with Civi templates. If this is case, the simple fix is also CSS display:none


Add Donations to Event Registration Form I'm trying to give people an option to add donations to special projects when they register for a particular event. We could just point folks to the contributions pages, but it would be more effective/convenient to just roll the donations into the event registration form.

Any advice on a strategy to accomplish this?

What I've tried so far:

A developer friend suggested adding custom profile fields to the
Register.tpl template and then saving the donation amounts to the
custom fields using an ajax call. I've got that working.
I'm not sure how to add my custom donation field values to the event
amounts, which would be needed in order to actually charge people for
their donations during the event confirmation and payment pages.
(I've tried using the postProcess and buildForm hooks, but don't see
how/where to change the "amounts" values.)

(CiviCRM 4.1.6; Drupal 6)

Simply set up an additional line item for a donation in a Price Set.

This is how I do it... the Price Set definition:

And then how the 'Optional Donation' is defined:

And a preview of this in action:

Feel free to give it a whirl on my website - and make a donation if you like it! :-)
http://www.breinton.com/book/hipp-abbate


report to show all my outstanding activity I want to be able to pull a report that shows all the activity that i have recorded, for scheduled, completed and ongoing.
How do i do this please?

You could base the report on the standard Activity report which can be found at Reports>All Reports>Activity Details.
If you are not too familiar with how reports and report templates work check this chapter of the User Guide: https://docs.civicrm.org/user/en/latest/reporting/what-is-civireport/


Is there a way to produce automated welcome emails for individuals who sign up to receive our newsletter? I want to figure out if we can create automated email sequences in CiviCRM. So, for example, if someone signs up for our newsletter, they get an email immediately that has some of our "best of" information, for example, and then 1 week later, they get another email that has some information about the impacts we're having in the community, but it's all automated through CiviCRM. We have two automated buttons that appear whenever anyone is added to our database or signs up to volunteer or to attend an event. The buttons ask if the individual would like to receive our newsletter and the second button asks if they would like to be sent volunteer opportunities. We'd like to be able to craft an email that will be generated and sent to everyone who selects 'yes' on these two options.

As @ericG suggested the CiviRules extension can do this. You can find the CiviRules extension here: https://civicrm.org/extensions/civirules and documentation on the extension is here: https://docs.civicrm.org/civirules/en/latest/.

If you want to send an email you will also need the Email API extension: https://civicrm.org/extensions/e-mail-api


How to set custom relative date filters I noticed that the relative date filters (e.g. "This week", "Previous quarter) have some new options available in 4.7, and I heard that you can now customize them to create new options.  I don't know how to do this, though.

I see them in Administer - System Settings - Option Groups, but it doesn't have any definition of what they are.  Neither Administer - Customize Data and Screens - Date Preferences nor Administer - Localization - Date Formats have them.

Specifically, I'd like to add something like "Empty or prior to this year".  I know that this might be a bit much to ask even if I can customize it, but I thought I'd find where I could edit the settings.

So I think I was jumping the gun with my excitement about this.

I found the issue on Jira, which has been updated to say the custom filter creation has been bumped to 4.8.  The work-in-progress code that Jon was working on is at https://github.com/civicrm/civicrm-core/pull/6307


Recurring contributions fail with PayPal Pro - "DPRP is disabled for this client" We recently set it so that members can sign up for a recurring donation.  All of our payments for recurring donations are failing, though. You can see in the attached picture that there are three failed recurring payments.  One of them is mine, and I know that I entered the payment information correctly, so the payment should not have failed.  I've recently, successfully, made other payments on this site with the exact same payment information.

We recently upgraded to CiviCRM 5.3.2 from 4.6.28.  We are using Drupal 7.60.
We are using PayPal as our payment processor.

List of recent contributions, showing failed recurring payments:

Membership page for my membership, showing pending membership and failed payment.

Ends up that the issue was that we do not have the Recurring Payments module enabled in our PayPal account.  When someone submits a recurring contribution, they get a warning stating "DPRP is disabled for this client".


Can I disable syncing when WordPress users create accounts? I have a CiviCRM database on my WordPress site. When new members sign up for our organization they create a CiviCRM account via the profile. Later they create accounts in WordPress to access certain members-only sections of the site. I do not want these WordPress accounts to sync. How can I disable that feature? I am now getting many duplicate records (and I need to allow duplicates as we have individual records -- children -- with same email -- parent).

You can unhook CiviCRM's hook callbacks like this:

add_action( 'plugins_loaded', 'my_disable_civi_user_sync' );
function my_disable_civi_user_sync() {
    if ( ! function_exists( 'civi_wp' ) ) return;
    remove_action( 'user_register', array( civi_wp()->users, 'update_user' ) );
    remove_action( 'profile_update', array( civi_wp()->users, 'update_user' ) );
    remove_action( 'deleted_user', array( civi_wp()->users, 'delete_user_ufmatch' ), 10 );
}

Disclaimer: this is untested code. You may need to hook into a later action, e.g. init.


CiviCRM WordPress doesn't work suddenly Not sure where I went wrong.

I recently installed the CiviCRM WordPress plugin.

I also installed a number of other plugins, but one of them that was installed after Civi was an SSO one.

I wouldn't think this would negatively affect anything, especially Civi, but apparently it did!

I've tried deactivating the SSO plugin, and seeing if Civi would work, and to no avail.

I even tried deactivating, deleting, and re-installing the Civi plugin 3 times. Still nothing.

As shown in the image, I get the following bit of text on the screen when I go to the CiviCRM tab in my dashboard:

Configure Your Dashboard
Refresh Dashboard Data
Welcome to your Home Dashboard
Your dashboard provides a one-screen view of the data that's most important to you. Graphical or tabular data is pulled from the reports you select, and is displayed in 'dashlets' (sections of the dashboard).

Have absolutely no idea what I'm doing wrong. I really would rather not do a fresh install of WordPress... I already have quite a bit of other things set up, custom styling on my front end, etc.

FIXED!

My issue was with the resource URL.

Update the following file: example.org/wp-content/uploads/civicrm/civicrm.settings.php

Approx. line 82: $civicrm_setting['URL Preferences']['userFrameworkResourceURL'] = 'https://example.org/wp-content/plugins/civicrm/civicrm';

I had put an SSL certificate on via my host (SiteGround), just before this issue started happening, which was messing it up.

All the paths need to have https: in them.

Shoutout to Jon G for his help and patience!


Why can I not add relationships? Freshly installed on latest Wordpress, I am simply not able to add relationships to contacts.

I have created one contact of type ORGANIZATION and one of type INDIVIDUAL and no matter what I try, I can not create relationships between them. The dropdownbox always gives "Loading failed".

I replicated the install locally in a virtual machine and everything works as expected.

Also, I notice that the local install is faster than the non-local (bluehost shared, memory limit 200M).

You've correctly isolated the problem to your Bluehost server configuration - and also found that their shared hosting may not be up to your needs!  You may want to get a VPS (I like Linode and Koumbit), or you may want to find shared hosting that can support CiviCRM (like CiviHosting).  Your performance problems will only get worse as you increase the size of your database.

But back to your problem - check out this post to troubleshoot.  My guess is that Bluehost has mod_security or some php.ini setting that's causing an AJAX call to fail.  This page will help you identify exactly what's failing.  Note that if you're looking to move to another host anyway, this may not be worth your aggravation!


Disabling automatic inheritance for Member type relationship One of our client would like to use the CiviMember module to setup memberships for organisation they work with. They offer a subscription service where an organisation is a member and as part of that membership 5 users can access specific content on the website.

Reading through the document I see that this can easily be setup. However, the issue is that the client would like to have an approval workflow process instead of just allowing people to signup from the front end of the site and get automatically attached to an organisation i.e. the client would like to verify the person signing up for the organisation membership before allowing them to access information on the site.

In the CiviBook it says Use this field to configure Membership Types where memberships are automatically granted to related contacts. However, we would like to stop memberships being automatically granted.

I tried the option of not assigning a relationship type to the Membership option but then the Max related option disappears. Is there any way to stop this from automatically happening or am I missing something in the setup.

This is a Drupal 7 website using CiviCRM 4.6.11.

Thanks in advance.

Might this be a question of which Relationship you are using this on. Eg you could create a new Relationship Type of 'associate of' to link the individual to the organisation.

When individuals sign up, they get the usual 'employee of' relationship. And then the admins for the client can 'verify' by also giving that contact an 'associate of' Relationship


Mail merge export issue I've had a good search and not seen anyone asking a similar question - I'm testing out the mail merge function to see if it will work for our next mailing. I'm able to export labels as a PDF from an advanced search without any issues. However, any tests I do trying to export a .pdf, .odt, or .docx mail merged document produces a corrupted file - PDF readers all say the document is "damaged" and .docx and .odt produces a file with an awful lot of nonsense in it!

Anyone faced anything similar and found a solution?

Edit

After a bit of googling and messing around, I managed to get it to export the text I wanted in a HTML format. .docx and .odt documents are corrupted, pdfs won't open. At the top of the HTML and .docx documents there is a message saying "Notice: No file uploaded in Unknown on line 0". If I work it out I'll post here, but I can't find any others with similar problems. I've tried on multiple browsers and machines.

I've also tried to export contact data as a .csv file, again without luck. The file is corrupted with just a huge quantity of unintelligible symbols.

Edit 2!

We are running version 5.5.1

Based on the "Notice" in the comment you posted above, it sounds like the issue is one of headers already being sent.

When you generate a .pdf/.docx/.odt file, the web server sends the exact set of bits and bytes necessary to generate that file.  However, it assumes that no other data is being sent.  If, before the document is generated, additional data is sent, you'll get a corrupt document.  It looks like that's what you're experiencing.

Check out the answer here: Error when printing PDF letter or mailing label from search results list.  It gives links that explain how to suppress notices on your live site, which should resolve this issue.


administrative checklist on multisite We have a multisite on WP that shares one db.

I am unclear if some settings are universal or if some are unique to each site. I'm referencing: administer > administrative console > configuration checklist.

So for instance, do I need to configure search or display settings for each site or will they inherit the network level site? And also for things like recaptcha and USPS address standardization.

Thanks!

All of those settings are set per-site.

If you're more comfortable looking at things at the SQL level, you can check out everything stored in civicrm_setting.  Note the presence of a domain_id field; each domain ID corresponds to one of the sites (see civicrm_domain to map them).

It's pretty safe to use SQL to copy those settings if you need to bulk change them.  There used to be an extension that let you change the settings in bulk; the name escapes me right now, but it doesn't work with modern CiviCRM anyway.