Error on enabling CiviMobileAPI extension After installing the extension CiviMobileAPI, I am getting the below error when I access the contacts page. Can you please have a look and support.

Warning: Invalid argument supplied for foreach() in /home/hisadvocate/www/www/wp-content/extensions/com.agiliway.civimobileapi-3.1/com.agiliway.civimobileapi-3.1/CRM/CiviMobileAPI/ApiWrapper/Activity/Get.php on line 31

I am using the Civi CRM version 5.2.1. Any help?

I created a PR on the CiviMobileAPI that fixes this problem. See https://github.com/agiliway/com.agiliway.civimobileapi/pull/11


Organisation relationship search My organisation is primarily (but not solely) a network of other organisations, so on Civi we have lots of "organisation" contact types, and lots of individual contacts. Some of these individuals are representative or contact person of their organisation to our organisation. I use the relationship tool to connect individuals to organisations as respresentatives (I made a new relationship type), and that works really well.

Some organisations haven't nominated someone to be a rep, or we haven't got them into CiviCRM properly yet (we're still slowly setting up). What I'm struggling to work out is how to run a search of organisations which don't yet have that relationship type with anyone. Is this possible anyhow?

Thanks.

You can use this SQL if you have access to the database directly. Replace the "5" with the actual id of the relationship type you're interested in. If you don't know the id you can see it if you go to admin - customize - relationship types and hover over the view link then you'll see the id in the url in the browser status bar.

select c.display_name from civicrm_contact c left join civicrm_relationship r on (r.contact_id_a=c.id AND r.relationship_type_id=5) where c.contact_type='Organization' and r.id IS NULL;

Depending on which direction you've defined the relationship you may need to replace contact_id_a with contact_id_b above.

I think there's a bug in the CiviReport - Contact Reports - Relationship Report otherwise you might be able to do it from there, setting contact type A to be Organization and relationship to be "Is Empty", but it doesn't seem to recognize the latter properly.


Call event registration with specific language through Wordpress I am using the latest Wordpress with Polylang and CiviCRM versions. I try to call the online event registration form in both German and English, but I don't know how to do it.

How can I force CiviCRM to switch to a specific language?  The &lcMesssages=de_DE parameter has no effect at all, neither does &lang=de.

Inherit language from CMS also does not work - I cannot even see a pattern. When I call CiviCRM from the Dashboard, it's always the current language, just from Wordpress itself, it does not work at all.

But there must be a way to force CiviCRM to use a specific language - or not? Any help is appreciated.

Polylang is not supported by CiviCRM yet but it should change soon : I have just submitted a patch here : https://github.com/civicrm/civicrm-core/pull/11312

If you still have a need for this functionality, you should try it and confirm if it resolves the problem.

To make it work with the patch :

Install Polylang and configure at least 2 languages

Configure CiviCRM in multiligual mode with 2 languages and set "Inherit CMS Language"

In civicrm.settings.php, uncomment as needed lines like : define('CIVICRM_LANGUAGE_MAPPING_xx_XX')  (to resolve ambiguity between language short 'fr' and language long form 'fr_FR' or 'fr_CA')
Create a contribution page and translate at least the title
Add a page with the shortcode to the contribution page and translate it to the second language

You should be able to go to one page you've created and switch language to have another version of the same form


Using checksums to access the civicrm/user dashboard I was under the impression that adding

https://civicrm.org/civicrm/user?reset=1&cid={contact.contact_id}&{contact.checksum}

to in a CiviMail would log someone in to the dashboard but it does not seem to be working for me.

This answer also suggests it so maybe I am doing something wrong.

PS I also tried id in place of cid (see below) but it did not work either.

https://civicrm.org/civicrm/user?reset=1&id={contact.contact_id}&{contact.checksum}

PS https://github.com/civicrm/civicrm-core/blob/master/CRM/Contact/Page/View/UserDashBoard.php does not mention checksums so i am guessing it is not possible...

Checksums can only be used for visitor facing forms like event registration, membership sign up or profile forms. If you have drupal as frontend you can also use it in the webform module. It is not usable for backend screens.

Also see http://wiki.civicrm.org/confluence/display/CRMDOC/Tokens


How to register for event without an email address? Sorry for such a brain dead question but we have people that want to register for our events that have no email address. Hard to imagine in this day and age but it happens. A lot of our contacts are old and not up with all the newfangled internet stuff. I have set up an event registration form that works very well for most, but requires email address. I have googled "civicrm register event email address" and not found anything specific on this issue.

Make email address field not-required on the profile you include on your event online registration form.

If the registering participant does not provide an email address, you could get duplicates in your CiviCRM contacts. See this warning:

  Duplicate Matching Impossible The selected profiles do not contain the
  fields necessary to match registrations with existing contacts. This
  means all anonymous registrations will result in a new contact.


Multi-user, non-organization environment? I'm trying to find a CRM solution that would allow me to 1) hook into an existing "customer"/donor data set, and 2) allow multiple users to keep their own private contact and donation records (i.e. Not a single organization, but a service with a shared database).

Is this something that CiviCRM can be modified to do? Thanks.

CiviCRM could certainly do this, but out of the box, the "maintain your own private contact/donation records" wouldn't scale well.  You'd either use ACL permissions or you use multi-site, which feels like overkill.  I've used both approaches with a handful of segments (12-14 segments, with 1-2 users able to see each segment).

If you wanted to scale well past that, I would write a custom extension to handle your scenario.  I would probably use a "contact reference" field to link contacts to a group of contact owners, then use a permission hook to limit access to folks who have that user as their contact reference.  You could also use groups instead of contact references, which would let a contact have multiple owners.

As for hooking into an "existing" set, you'd need to import the data.  CiviCRM isn't going to be the right tool if the data exclusively lives elsewhere.


When new members sign up an email gets sent to filter.select@gmail.com We are using CiviCRM 4.6.4 in Wordpress.
We have a membership page processed through paypal.
All emails are sending from our own SMTP server.

However, when an email is sent as acknowledgement of signup/payment
for membership, there is also an email being sent to filter.select@gmail.com

What is this email and how do I stop it from being sent?

Unless you some kind of customization that sends out those emails, I can only think of one place should have a look at:

go to "Contributions" --> "Manage Contribution Pages"
next to the contribution page in question, use the link "configure" and then "Thank-You and receipting"
tick the box "Email Receipt to Contributor" (if not ticked already) and check if "filter.select@gmail.com" is in the cc or bcc field.


how to edit WordPress Base Page I have an installation of Wordpress.Civicrm which I have copied to another server using a different domain name

It works great, except the WordPress Base Page is still set at the old domain name and I cannot find where to edit it

I have searched the database and the files, and cannot resolve this
it is shown on
my_website_domain/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fadmin%2Fsetting%2Fuf&reset=1

I want to change it

FROM

my_OLD_domain_name/civicrm

TO

my_NEW_domain_name/civicrm

I hope you can help

thankyou in advance

Neil

You may find this wiki page helpful: Moving an Existing Installation to a New Server or Location


payment page - total not correct when using Tax I have setup a webform to take registrations and payments for events. I have enabled tax to be 10% and have calculated the cost of each event to be 10% less, so Civi will add on the tax to each line item (i assume that this is the only way Civi Tax works). The total is $0.1 by out. Here is why:

$75 - 10% = $68.18 (I have set the Participant Fee to $68.18)

$68.18 * 3 events = 204.54
Add the tax: 204.54 * 0.1 = 20.454 ($20.45, rounded)

$20.45 + 204.54 = $224.99

Edit: Seems like a similar issue to https://github.com/civicrm/civicrm-core/pull/9711 & https://github.com/civicrm/civicrm-core/pull/9710

Are these patches still relevant?

Sales Taxes in CiviCRM are added on checkout - so if you want to get to nice rounded numbers you may need to give your participant_fee a few more decimals.

Glad that worked for you Ben!


https://civicrm.org/extensions/areas causing error Upon installing the extension and then changing the settings so that 'Collapse this set on initial display' and 'Collapse this set in Advanced Search' are marked with yes, the follow warning of "Custom group 'Areas' already exists in Database' appears. How do I fix this error?  We're using Civi 5.0.0

This sounds like a civicrm bug. I have tried locally and have the same error.

I found a work around: you can give the custom group a different title (the title Areas is also used for another group which is reserved).

I have created a bug report: https://lab.civicrm.org/dev/core/issues/141


Need to redirect when permission issue happened on CiviCRM Page I have enabled and configured access for Contribution financial type. When an anonymous user open the a contribute page, it returns the error.

I need to redirect to login page in this case. I don't want to show error page to the user.

Please Help!

You can do this by specifying your custom Fatal Error Handler at Administer -> System Settings -> Debugging and Error Handling.

Enter the name of the function eg myCustomErrorHandler for Fatal Error Handler input field.
Define this function in one of the extension .php file. The param should hold the message of the error and if it matches the permission text msg, you can use redirect function to navigate to the login page. Eg.

function myCustomErrorHandler($params) {
  if ($params['message'] == 'error message') {
    CRM_Utils_System::redirect($urlyouwant);
  }
  return FALSE;
}

Note the return statement in this function. FALSE is required to call the default error handler in case your function wasn't able to do the needful.
return TRUE; will not call the default Error handler in CiviCRM.


Activity get API3 does not return case activity Im using API3 to get activities

My code is

function hook_any_activity_get($cid,$type) {
  $params = [
    'contact_id' => $cid,
    'activity_type_id' => $type,
    'sequential' => 1,
    'is_deleted' => 0,
  ];
  try{
    $result = civicrm_api3('Activity', 'get', $params);
  }
  catch (CiviCRM_API3_Exception $e) {
    // Handle error here.
    $errorMessage = $e->getMessage();
    $errorCode = $e->getErrorCode();
    $errorData = $e->getExtraParams();
    return [
      'is_error' => 1,
      'error_message' => $errorMessage,
      'error_code' => $errorCode,
      'error_data' => $errorData,
    ];
  }
  return $result;
}

This works fine when the activity is created outside of a case.

When the activity is created within a case I get an error

One of parameters  (value: ) is not of the type Positive

I have tried this written into a module and in Drupal rules. Same error.

I'm not seeing anything in backtrace or the CiviCRM log file.

Ive even tried it just by trying to return the activity using the activity ID.

I also tried it by including the case ID

Turns out there is a bug in the CiviMobile extension that is breaking this functionality. Disabling this extension fixes the problem.


Totals Row for Tab with Table Custom Data I have some custom data in a "tab with tables" style.  One of the fields is an integer type.  I'd like to add a summary at the bottom of the table with totals for this field.  Is that possible to do? Any pointers to what hook to use or how I can build it?

Personally I'd do it by adding some javascript code to the page, and just use jQuery to add the totals row.

A super-quick way to do this would be to place the code inside {literal}<script> tags in a .tpl.extra file.


How to allow online renewals for memberships created in the backend? If you created a membership in the admin section, the member is not able to renew the membership using their dashboard.

If you have a link on your site for that membership sign up, the user can renew by going there. But if for some reason there's no public link, it is hard for the user to renew.

This may be the case if you have multiple memberships, with some that are not available to the general public.

You have to modify the contribution so that the system knows which online page needs to be used for renewal. Steps:

Add the membership & payment (must add a payment, $0 works)

Edit the payment - In the Additional details section, choose the appropriate Online contribution page


building an extension: how can I create a multiple-step form? If I just had .php files I would do the following:
step1.php's submit button goes to step2.php. step2.php's submit button goes to step3.php, etc.

The problem is that I need data that the user entered in step1 in order to display step2. For step3 I need data from step2, etc.

I tried creating multiple forms with civix generate:form, but how can I get data entered in previous steps?

There are a bunch of ways to handle this.

Before proceeding down this path, consider if Webform-CiviCRM integration (for Drupal) or Caldera Forms-CiviCRM integration (for WordPress) will work for you - it will save you a lot of work if so.

If that's NOT an option, consider a) storing the data in the database (using the postProcess hook), b) storing the data in the $_SESSION variable, or c) using jQuery to fake having a multi-page form on a single page.


Reply-to address problems when reusing mailings We're currently using 4.6.8 with Drupal 7, and we're currently finding that if you re-use an old mailing, but then change the From address, the Reply-to field remains according to the original mailing and is not changed. The result is that the Reply-to field is set incorrectly, confusing recipients as well as the owner of the incorrect Reply-to email address.  Is anyone else having this problem?

The issue was that the replyto_email field wasn't being updated by angular to pass it back to the database. I believe this was fixed in https://issues.civicrm.org/jira/browse/CRM-17650


CiviMember - How to find members that are in a specified group Under the Memberships menu, when I try to search for members using "Find Membership" the search options do not allow me to search for members that are within a specific group. I can search per project and other criteria, but it is important for me to have the option to search within a group. Can this be done by some custom hook/coding?

I am currently running CiviCRM  4.5.3 on Wordpress.

using advanced search, you can build your own combination of criteria (so you can search contacts on a group AND with specific membership).

By default, it will list the contacts (that belong to that group and have a membership) but (top right corner) you can as well display the result as a list of memberships too


How do I correct the fault causing "file_exists(): open_basedir restriction in effect" Warning: file_exists(): open_basedir restriction in effect. File(/usr/share/doc/php-tcpdf/examples/images/) is not within the allowed path(s): (/nhldata/631/106631/data/web:/usr/local/php55/share/pear:/var/tmp/php:/tmp:/usr/local/php55/lib64) in /nhldata/631/106631/data/web/predigerforum/htdocs/wordpress/wp-content/plugins/civicrm/civicrm/packages/tcpdf/tcpdf_autoconfig.php on line 96

I got this message when I initially installed too. The only workaround seemed to be to insert "@" before the file_exists calls in the referenced PHP files...

There must be some kind of configuration error or permissioning problem that I could not find?

I'm running civiCRM 4.6.2 under the latest Wordpress

Take a look under Administer/System Settings/Directories. It sounds like your directory for Images may be incorrect, or not yet defined.


In CiviMail reports, how do I enable "Add these contacts to Group" for user levels other than Admin? I want to enable other user levels to be able to add contacts to a Group based on a list of results in a CiviMail Report using 'Add these contacts to Group'.

For example, a CiviMail Bounces Report shows 99 "bouncing" (undeliverable) e-mails. I want other user levels besides Admin to be able to add them to a new Group called Bouncing E-mails - 20150410 Outreach Mailing.

As the Admin, I see 'Add these contacts to Group' as an option in the Bounces Report. But other user levels do not see that. I don't see a permission to change under Drupal user permissions.

I have already enabled the available choices for the desired user level already. The choices are: access CiviMail, access CiviMail subscribe/unsubscribe pages, delete in CiviMail and view public CiviMail content.

Joe - Did some snooping in the code, and currently 'administer Reports' is required to expose 'Add Contacts to Group' in any report. Of course 'view all contacts' or some ACL granting permission to a set of contacts is also required or report results will be empty.

I think 'administer Reports' is not the right requirement. 'edit all contacts' or an equivalent ACL allowing editing is required in the rest of the user interface to allow 'add to group' - so I think the same should be true in reports.

https://issues.civicrm.org/jira/browse/CRM-16274


CiviCRM on MariaDB instead of mySQL Has anyone run CiviCRM on MariaDB instead of mySQL

https://mariadb.org/

Running CiviCRM on MariaDB could provide significant speed improvements.

We have mariadb on our newest server, it's a completely transparent replacement. I haven't noticed any major speed change, either better or worse, so I'd take your hope of major speed gain with a pinch of salt.

We switched to it mostly because they seem to do a better job at pushing new features than oracle... and because it looks like 100% the same, as viewed from civi


Set cookies for petitions (and probably other online forms) as session cookies that will expire after signing I set up an online petition using CiviCRM 4.6 on Drupal 7.

During the process, the status of the petition is stored in two cookies ("signed" and "confirmed"), which controls to process flow.

Both cookies are valid for 24 hours.

However, the drawback is, that it is not possible to enter another petition directly after the first one from the same pc - since the cookies remain valid fr 24 hours.

Is there a possibility to to limit the cookie lifetime to the session? So that the cookies are deleted, when the browser window is closed?

Thank in advance!

Aah,

Indeed, the cookie should apply only to the petition (ie contain the petition id).

It's a bug and shouldn't be difficult to fix. Do you or someone in your team have the skills to fix it? PR welcome ;)


How can I adjust the date widget on Reports The birth date widget on Reports such as the Constituent Detail seems hard coded to allow only dates within the last 20 years. How do I adjust this?

Under Administer > Customize Data and Screens > Date Preferences you can adjust various date settings. In this case it's a little unclear but rather than changing the "Birth and deceased dates" setting you need to adjust the "searchDate" setting which is "Used in search forms and for relationships."
The "Start offset" value is the number of years prior to today that should be allowed in the datepicker.


Using Export Contacts from Search Builder w/ Field Mapping, mapped field's columns not exported Website is running 4.7.25 over Drupal.  I was able to replicate this on this demo site, which is running at version 4.7.28, as well: http://dmaster.demo.civicrm.org/civicrm

Here are the steps to take to replicate the issue:

Selected Search Builder
Set extensive search criteria (like 12 of them)
Set Select Records: to 'all'
Select Export Contacts Action
Search Builder Export Options (Step 2 of 3):
Select Fields to Export checked
Used Saved Field Mapping (note that I get the same problem regardless of my choice here)-- there were 17 fields in my map
All other left at their default
Clicked Continue
Select Fields to Export (Step 3 of 3)
Left at defaults
Clicked Export
Opened resulting downloaded csv.
Columns were NOT as mapped; they seemed to be the fields shown on the search results, rather than what I had in field map.

I have several screen shots, but (sorry) cannot see how to post them here.

My workaround will be to select Primary Fields (80 fields) in the Export dialog,  and just use the 17 columns I want in the resulting .csv.  But, it would be cleaner/simpler for using in any automated processes if this worked correctly, so I thought I'd submit it if it's truly a bug.  Unless someone here can point me to what I'm doing wrong?

Thanks!

There is a JIRA issue for this 'oversight' and has been assigned to one of the Fuzion team to work on as part of a community 'pay-back/investment/pay-forward'.


How to run triggerRebuild URL Apparently I am not allowed to ask for clarification in the post, so can someone please elaborate on this?

Sounds good. To be sure, please execute ///civicrm/menu/rebuild?reset=1&triggerRebuild=1 which fixes the trigger and function definitions in the database."

It looks like I need to do this, but where/how? I asked my hosting provider and they referred me back here.  :/

Sorry for the too terse explanation you received on the other answer, using a shortform that experts are used to. If you are running a Drupal site, example.com, then to rebuild your triggers navigate in your browser (by pasting in the url) to http://example.com/civicrm/menu/rebuild?reset=1&triggerRebuild=1 , for WordPress it is http://example.com/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fmenu%2Frebuild%3Freset%3D1&triggerRebuild=1 , and for Joomla it is https://example.com/administrator/?option=com_civicrm&task=civicrm/menu/rebuild?reset=1&triggerRebuild=1.

Without a reference to your earlier question, I'm not sure which version of CiviCRM you are running. FWIW, I think this fixup may have changed in recent versions.

Make sure you have admin CiviCRM permissions.


Is there a way of recording/exposing when an activity is added to CiviCRM? When adding a custom activity the current time is automatically shown and can be updated. Where people are adding past/ future activities, is the actual time the activtiy is submitted also recorded somewhere in CiviCRM?

Is there a way of extracting this information?

Or should I add an extra date field in the custom data- default set to know to record the submission date?

The creation date of an activity is not, by default, stored in CiviCRM.  Depending on what you want to do, you can:

Create a custom field like you suggested, and write an extension that fills in the value on creation.
Create a custom field, then define a MySQL trigger to fill in the date.  This is less portable, but higher-performance.
You can enable binary logging (aka detailed logging) as described here, which will create log_civicrm_activity.  This is the easiest way to record the date - but doesn't give you a good way to expose this data through the UI.


How to combine event registration fee and sponsorship donation in one price set? I want to have a price set for an event which offers two mutually exclusive options: (1) registration fee for the event (2) a sponsorship fee. Option 1 should register the person as an attendee. Option 2 should not. In other words, the visitor either registers for an event, or makes a donation.
I thought that by putting 0 (zero) into the 'participant count' field for the second option, that it would not increment the participant count for someone who pays the sponsorship fee. But it DOES register the person for the event when all they are doing is making a donation. Am I missing something or can Civi not handle this use case without programming?

The participant count is only participants for the particular price set field. You're right that no matter what you do in the price set, the contact will be registered for the event. You could instead ignore who is registered for the event and just look at who is registered for the relevant price set field and use that as your group of registered participants. That might be less than ideal.
Otherwise, this sounds like a job for Webform CiviCRM, assuming you're on Drupal. Be warned though, that Webform CiviCRM will force you to use line items to record the donation and registration. I could be wrong, but I don't think Webform will allow you to record two different financial types depending on user selections.


Event Info Page error with Joomla we've just started using CiviCRM events.  I've followed the process to get the event set up.  I can test-drive the link and it works fine but if I go to the live online registration I get an error page that says I don't have permission to access the page.
I've tried setting the public permission to allowed for "CiviEvent: register for events" to Allowed but it doesn't save when I change the permission.
Any ideas where i need to look for the error.  I'm using CiviCRM 4.7.7 and Joomla! 3.5.1
Thanks
Emma

This is an ACL issue. If users can login, then register it is simpler.
If you are allowing anonymous users then you have a tiny bit of configuration to do to enable anonymous users.
Have to race out to a client for the day, i can send you info tonight with some screen captures, but also maybe you can look up the instructions in the manuals, it works quite nicely when configured.
CiviCRM » Administer CiviCRM » Access Control

For more reference please give a read https://book.civicrm.org/user/current/initial-set-up/permissions-and-access-control/

Also can you just double check that you have the event checked off as a "public event".


New fields failed to get created properly, resulting in DB errors In adding new custom fields to an existing set, things recently went wrong.  New entries were added in the civicrm_custom_field table, but the corresponding columns were not added to that field set's table.  This resulted in DB Error: no such field breaking the UI display of existing cases.  Deleting the rows from the custom_field table solved the errors so that existing cases can be viewed.

Now new cases cannot be created.  When the new case form is submitted the case gets partially added to the db (but is not visible via the UI) and a blank error screen with message DB Constraint Violation - case_type_id should possibly be marked as mandatory for Case,get API. If so, please raise a bug report. appears.  Creating a new case (or trying to) adds 83000 new lines to the log file and near the top of that entry is [nativecode=1054 ** Unknown column 'a_to_civicrm_value_special_case_fields_8._name_of_deleted_field_157' in 'field list'].  That seems confusing since "a_to_" is not actually part of the table's name, and "_name_of_deleted_field_157" isn't in the civicrm_custom_field table.  Are custom fields recorded/stored anywhere aside from civicrm_custom_field and the fieldset they're contained by?

Also, the field and case id's seem to have their incrementing messed up... the id#s appear to increment by 1 but there are several numbers skipped.  Is that a problem?  With the fields I deleted the row and column back to the last increment, 148, but when adding a new field its id was 155.  Can missing id's (149-154 in this case) be problematic?

Is there anything you can suggest or point me towards in getting this working?

edits:

131 rows in civicrm_custom_field table
CiviCRM 5.13.4

As Demerit mentioned, you have the same issues I reported. I don't think it's about the number of fields that's the issue, but the combination of data types. If you are receiving that error, be careful if your site is live because some of your cases will hit an error and you won't be able to view the case page.

Here's what I did:

If possible, you will want to delete all the custom fields and the custom group itself. Do it in phpmyadmin because it's faster. Once you have cleared the data, split the 65 fields into two custom groups. The error should go away.

If you can't delete the custom group because you already have data, delete the custom fields and then create a new custom group to split off some of those fields.


Webform integration for event registration I use webform integration for event registration, and this has worked smoothly in the past. Users can select which of several events they would like. I don't believe I've changed anything about the setup to break it, but I guess I must have updated something without noticing. Now, however, anyone who uses this form becomes registered for all events listed. The webform results page shows which event an individual chose, but the contacts are registered for all the events in civicrm. This is wreaking havoc, as you can imagine. Has anyone else run into this issue? How did you fix it?

Can you check if "User Select" is still part of the Events list on the CiviCRM tab?

It MIGHT be somehow possible that the Webform field still exists but lost connection to the CiviCRM functionality. In that case the visitor still choses the event in the webform, but CiviCRM registers to all events.


Scheduled reminders not being sent All,

Scheduled reminders worked last year, but are not working this year.

I had made some changes to the Outbound Mail settings, but a) I set these back as they were and b) test emails come through just fine.

To sidestep the issue of 'day before membership end date', I entered today's date. When I manually executed 'Send Scheduled Reminders', the system reported that the job had completed, but no emails were sent and no errors were logged.

I just learned that things are not quite as 'simple' as I had hoped: At least one person received the reminder that I manually sent, but at least one person did not. I am among the 'at least one who did not' and I know that there are absolutely no email filters on the recipient side - so what happened?

In v4.4 and v4.5 there is a known problem with membership reminders. Only one reminder email of each type will ever be sent to each member, not one each year, just one for that member forever. (Unless you have repeat turned on, but I think that is unlikely for membership renewal reminders as that creates another set of problems.)

It means you need to create copies of your existing reminders every 12 months (assuming you have one year memberships).

Things are different in v4.6, so if you are on v4.6 this answer will be irrelevant for you.


Implement CiviCrm SAML with Google Suite as IDP provider I'm helping a small charity in volunteer capacity, most of their work was done on the spreadsheets earlier, they have now started using civicrm for their events and contributions as well as membership, and emails.

They have an intranet built using google suite, and now want to integrate Civicrm with intranet site using SAML authentication for civicrm.

there config is CiviCRM 5.8.2 on drupal 7 - I’ve looked around and tried for extensions for implementing SAML on Civicrm (service provider) using Google as IDP provider, but have not got end to end instructions. Can someone please point me in right direction? I'ld be very thankful and happy to document the step by step instructions and share with all once done.

Civi uses the CMS for authentication so the question is about configuring Drupal 7 (in your case) with Google SAML IDP.

I've not tried it, but a bit of googling shows a few links that look promising:

Drupal SAML Authentication module
Set up your own custom SAML application


Should deleted Participant contributions appear in the report Event Income Report? At Event Income Report (both Detail and Summary), in the results, contacts deleted with contributions are counted.

I tested it in dmaster and have the same behavior.

Obviously, it's because in the SQL sentence it doesn't appear the contact.is_deleted = 0 in the where clause.

The reason for that behavior is that CiviCRM considers still valid deleted contacts contributions and refuses to delete them.

So, what do you think? It's a bug that needs to be fixed? Create a custom Report? An extension?

Thanks for answering!

Not deleting financial information when a registration is deleted is by design so that organizations can pass audits. One wouldn't want an employee to delete some registrants and pocket the money if there is no checkin at the event, for example.

If you would like to sponsor an extension to optionally change this behaviour it should be fairly simple to create, depending on how you want to approach things.


How to get max_amount, min_amount from Contribution Page Issue: Coding wordpress plugin for civicontribute widget, I need to get some variables in order to build the progress bar.

When I use civicrm_api3('contribution_page', 'getfields'); it returns a lot of information which does not seem to be accessible when using civicrm_api3('contribution_page', 'get', $params);.

May some of you put a bot of light on how to get this data?

PS. May it be easier to code an alternative template for the widget?

Thanks!

what is that you have in the param?

I would suggest you to use the api explorer, it should guide you and the generated code can be copy/pasted in your plugin

Just to be clear: the min_amount and max_amount are the amounts a user CAN enter, it doesn't show how much has been given already. for that, you should look at the contribution api.getcount (and filter it by contribution_page)


Could not find a valid session key when submitting Petition Help needed. The error below is received when I click on the submit button for a petition (survey). This function has been working fine for several months. There are no customisations in place in this area.
Wordpress was updated to 5.5.1. - The error only occurred since this last upgrade occurred.
CiviCRM 5.27.1
PHP 7.3.17
(
    [message] => 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 administrator 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: Base URL is http://example.org, but some users are accessing the page via http://www.example.org or a domain alias like http://myotherexample.org.

Error type: Could not find a valid session key.
    [code] =>
)

Sep 04 14:04:55  [debug] $backTrace = #0 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(354): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(817): CRM_Core_Error::fatal("We can't load the requested web page. This page requires cookies to be enable...")
#2 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(812): CRM_Core_Controller->invalidKeyCommon()
#3 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(296): CRM_Core_Controller->invalidKey()
#4 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(190): CRM_Core_Controller->key("CRM_Campaign_Form_Petition_Signature", TRUE, FALSE)
#5 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller/Simple.php(50): CRM_Core_Controller->__construct("Sign Petition", TRUE, NULL, "CRM_Campaign_Form_Petition_Signature", TRUE, FALSE)
#6 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/Utils/Wrapper.php(62): CRM_Core_Controller_Simple->__construct("CRM_Campaign_Form_Petition_Signature", "Sign Petition", NULL, FALSE, FALSE, FALSE, FALSE)
#7 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(285): CRM_Utils_Wrapper->run("CRM_Campaign_Form_Petition_Signature", "Sign Petition", (Array:0))
#8 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(68): CRM_Core_Invoke::runItem((Array:14))
#9 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke((Array:3))
#10 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm.php(1537): CRM_Core_Invoke::invoke((Array:3))
#11 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/includes/civicrm.basepage.php(352): CiviCRM_For_WordPress->invoke()
#12 /home/cremorne/www/www/devwp2/wp-includes/class-wp-hook.php(287): CiviCRM_For_WordPress_Basepage->basepage_handler(Object(WP))
#13 /home/cremorne/www/www/devwp2/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters(NULL, (Array:1))
#14 /home/cremorne/www/www/devwp2/wp-includes/plugin.php(544): WP_Hook->do_action((Array:1))
#15 /home/cremorne/www/www/devwp2/wp-includes/class-wp.php(758): do_action_ref_array("wp", (Array:1))
#16 /home/cremorne/www/www/devwp2/wp-includes/functions.php(1285): WP->main("")
#17 /home/cremorne/www/www/devwp2/wp-blog-header.php(16): wp()
#18 /home/cremorne/www/www/devwp2/index.php(17): require("/home/cremorne/www/www/devwp2/wp-blog-header.php")
#19 {main}

Have been able to get over the session key error by installing a fresh install of WP and CiviCRM, then restoring Wordpress and CiviCRM DBs, repointing wp_config.php and CiviCRM.settings.php. Also had to rename my table prefixes in wp_config.php to match my restored tables. The caches get created once you start up CiviCRM and do things. Testing so far all functionality is working again. Hopefully this may help someone should you come across this issue which is pretty horrible.


Check numbers in reports My client took great pains to record check numbers and payment amounts and wants to produce an event payment report which includes the check numbers associated with each registration. I can get everything in the report except the check numbers. I have confirmed that the check numbers are entered, they just aren't appearing the report.  I've done this with standard reports and extended reports and the output is roughly the same. They need this report for their board. Any ideas of how we get there from here?

I did look at Bookkeeping report doesn't record check number for financial account/type but I'm not sure that it's the same issue and that item was never resolved that I see.

A workaround might be to run the contribution detail report filtering to event fees and select columns Source and Check Number, then do an excel vlookup() to cross-reference Source against the Event name in the event participants list (which I'm guessing is the report you're looking at).


Quickly entering attendance with barcodes I use CiviCRM for a non-profit organization that, among other things, organizes a yearly funweek for children. This year, we introduce event badges with a barcode. I was hoping to be able to use this to quickly register the actual attendance for each day.
The barcode value is entered into the External ID field of each child's contact record. On the event registration I have custom fields for each day of the week.
Our plan was to have one of the volunteers scan each barcode as the children enter the building, then I could easily add the event id, presence and an indicator of the day to this list as that would be the same for each line.
Unfortunately this doesn't seem to work, because it doesn't seem to be possible to update event registrations unless I know the event registration id. Knowing the External ID and Event ID is apparently not enough to make a match. I find this odd as I think it is illogical to have one person register twice for the same event.
Is there a way around it except by exporting all attendees and using the export as a lookup-table to add the event registration id to the import-file?

Maurice - we did something similar for a large event this year with multiple series of workshops running simultaneously.

Every participant was pre-registered in Civi. Each workshop was added as a separate Event in Civi. We printed barcodes of the participants' Internal Contact ID onto cheap Avery mailing labels - something like 3 inches by 2 inches - using the Event Badge template in Civi, and just pasted the labels on the back of the registration badge holder.

We then created a shared spreadsheet in Google Drive, with a worksheet for each workshop, and set up a volunteer at the entrance of each workshop with a wifi-connected laptop and a USB barcode scanner.

All the volunteer had to do was scan each bar code into the worksheet. It worked pretty well. One hitch was the size of the bar code produced from Civi is a little small, and we used cheap (we got them for about $10 each) old CueCat USB scanners I found through eBay. We then just imported the Participant IDs and updated the Event status for each workshop Participant as Attended.

Just in case, we had plain old paper sign in sheets for each workshop available and used those in some instances.

The biggest challenge of this technique is having enough volunteers, with available laptops, set up in advance with the USB scanner (and the correct driver software!) and decent wifi. Wifi isn't required but it was handy to have the scanned-in Internal Contact IDs for each Participant appear live in Google Drive while they were scanned in for the workshop.


Deleting a site on WP multisite deletes civicrm uploads folder's contents Similar to the behavior of this Upgrading WP to 5.0.1 deletes civicrm uploads folder, I had deactivated then decided to delete a site on our WP multisite. Once I clicked delete I got a fatal error (sorry I did not copy) that referenced line 916 of civicrm.php file. Deactivating CiviCRM plugin got the multisite backup.

require_once 'CRM/Core/ClassLoader.php';
      CRM_Core_ClassLoader::singleton()->register();

Then I saw that the uploads/civicrm folder was empty. It had the /ext /uploads and /template_c folder but they were all empty. The rest were gone.

We restored the directory from backup and now it works. Anyways, this is a word of caution.

Question is, why did this happen?

Deleting a site in WP triggers deleting sites/nn/uploads folder contents. Unfortunately, that site still had a civicrm symlink pointing to /uploads/civicrm which the delete trigger followed and subsequently deleted.

Don't use symlinks. I removed without issue. Instead you can define resource paths in civicrm.settings.php file. Will take a look at updating docs.


custom fields type "Select Date" are broken as of 4.7 I was wondering if someone else has encountered this issue and if there is resolution: https://issues.civicrm.org/jira/browse/CRM-18379

Yes I did, and I posted a fix to that issue. You can find it under the "links" section.


How can I make a civi event registration form that collects the individual's information as well as the organization to which they are affiliated? How can I make a Civi event registration form that collects the individual's information as well as the organization to which they are affiliated? Would I have to use a webform? We're on 4.6.8, Drupal.

I have a number of webforms where the user is logged in and we have set the auto-complete to be based on the relationship between the user and their organisation.

Contact 1 is the individual and Contact 2 is the organisation.

I would imagine that using non-logged in users is similar, depending on how exposed the organisation list is? Would it make two contacts if there were none matching then create a relationship?


"Forward this email" creates contacts with e-mail and no first/last name If you click the "Forward this Email" link on a CiviMail mailing, you get a screen that allows you to create records with no first/last name (see attached screenshot).  Moreover, there's nothing to indicate how they got into CiviCRM.  What would be the best fix for this?

Force someone to enter a first/last name (similar to "Tell-a-Friend" on event reg);
Create an activity (or even relationship) linking this user to the user who submitted their mail - again, similar to Tell-A-Friend;
something else entirely?

I understand the need to make it easy to forward an e-mail without giving additional information - but it's also not OK to have records with no way to tell how they got into the system.

I think that page has not changed since it was first implemented. I'd probably vote for the following changes:

a. Add optional form fields first name and last name

b. Create an activity to make it similar to tell-a-friend, which is kinda the same concept


Why can't I create a payment processor in multisite? I have a multisite setup with a payment processor defined in one site. When I try to create one in the other site, it does not save and I get this error: "Expected one PaymentProcessor but found 2".

Are you using the same payment processor naming for both? You must give it a unique name.


CiviCRM Entity, Display tags name in contact Here's what I'm trying to do.
I installed CiviCRM with CiviCRM Entities. + few other modules.

At Structure -> CiviCRM Entity -> CiviCRM Contact -> Add custom field (CiviCRM Entity Reference)

I did add a custom field called tags. Connected to Tag Entity. It will appear in display. But tags are numbers.

Now i need to fetch tag names from Tag Entity.

I tried to add it in Contact and with Tag Entity itself.
Did try to add custom field just like Contact.

(Target: Tag, Join: Tag ID, Host Source: ID).

It won't work.
Apparently there's no way to get Tag from Tag Entity for me.

I wonder what's going wrong in here. Can anybody help?

I need to add an option "Tag ID" in the Host Source Column field setting of the CiviCRM Entity Reference module to make this work.

It won't take much to add it.
Look in your code to the matching file, add:

'tag_id' => 'Tag ID (Entity Tag)',

https://github.com/eileenmcnaughton/civicrm_entity/blob/7.x-2.x/modules/civicrm_entity_reference_field/civicrm_entity_reference_field.module#L148

Then you can add another CiviCRM Entity Reference Field to the Entity tag entity type:
admin/structure/civicrm-entity/civicrm_entity_tag/fields
Target Entity: Tag
Target ID: Tag ID
Host source column: Tag ID (Entity Tag)

Set this field to render in a view mode on the entity tag manage display area:

admin/structure/civicrm-entity/civicrm_entity_tag/display

This will render the tag entity, you can configure which fields of the tag entity show by configuring a view mode and configuring to use it on the render

admin/structure/civicrm-entity/civicrm_tag/display

Now back at your Contact, make sure and render the view mode of Entity Tag, that renders the right view mode of the Tag entity, and you'll be rocking.

I will add a PR to CiviCRM Entity to add the one line of code necessary to make it work out of the box, but it may be a couple weeks before the next release goes out.


Mosaico mail template URL's don't function properly I'm using Mosaico to create a mail template. I have 4 different tokens in the email (2 web links and 2 Mailto: addresses).  When the test email comes through everything looks good but the live segments all open the same webpage for some reason. Any ideas?

Paul, welcome to CiviCRM stackechange. when you have clickthrough enabled for the mailing CiviCRM replaces those url into trackable url so that Civi can track clicks for mailing. Check you Resource url setting (Administer >> System Settings >> Resource url .. click on '?' under the help area), Make sure [civicrm.path] is set correctly. Try sending the same email by replacing the path for CiviCRM resource url field.


Contributions not showing Thank You Screen I'm testing through migrating from joomla to wordpress. My developemnt site is set up in Wordpress 4.2.2 and Civi 4.6.3. I'm having an issue with contributions, when you make a contribution the thank you page is skipped and the user is dropped back to the original contribution page (it's blank, like it redirects there.) The contribution is successful and an email is sent so I'm at a loss for what is happening.

I've checked the civi log and the error log, there's nothing there. I also tried to reproduce it on the demo site, no dice. I've turned off all plugins in wordpress and removed my custom php file.

The one thought I have is that all my urls seem to be using &2f rather then the forward slash for any "/" that occur after the "?page=CiviCRM" . I was thinking it might be a related problem since the URLs works with checksums??

Any idea what else I can do to solve this!?

So I finally figured out what was causing this - but it created another small hiccup. In Wordpress' theme customizer if you set any sort of static front page that's when things start breaking. I tested a bunch of different pages, the civiCRM page that is set as the base page, a page with a contribution on it overridden content and non-overridden. All these pages had the same result - the thank you page on civi generated donate links doesn't show up. (I also tested different themes, it wasn't theme based.)

But.....if you show a lists of posts as your home page the thank you page does show up! Which works for now but is problematic as you can't publish more than one post ever. If you only have one post published it shows the whole post on the home page. Once you have more than one it shows excerpts - which for me is awkward. I like my home page to be a donation page.

I couldn't reproduce this on the demo server as we (understandably) don't have access to the Wordpress settings. I'd love some feedback if I'm the only one who has noticed this or if anyone has found a workaround.


Drupal View query for select fields produces different results that CiviCRM I have a civicrm custom field for languages spoken like
English
French
German
...

You can have multiple selections.
SO a contact might select
English
French

from the listing.
If I do a search for "French" in CiviCRM it returns contacts correctly.
If I do it in Drupal via an exposed filter in a View, it returns no contacts.
If I do a Drupal search for English, it returns the contact.
It seems like it only returns a result if the item being searched is the first in the list - in this case English.
Ive tried allow multiple selection in the View filter and so on, with no result.
I want it to produce the correct results.
Any ideas? Thanks as always.

If you haven't upgraded Civi to 5.28.4 than apply below patch
https://patch-diff.githubusercontent.com/raw/civicrm/civicrm-drupal/pull/617.patch
https://patch-diff.githubusercontent.com/raw/civicrm/civicrm-drupal/pull/618.patch


CiviCRM - Installing on Wordpress Hosted in AWS DB Error I was testing out CiviCRM as part of a project I am working on and decided to host it in AWS on a WordPress site.  After downloading the newest version (5.10.4), I then uploaded the Zip file to my site.  I activated the plugin and proceeded to install CiviCRM accordingly.

To make my life easier, I created a new user with admin permissions and created a separate database for CiviCRM.  So far, so good.  I kick off the installation and everything shows up as good and the message you get post install pops up letting you know about settings, etc.  Shortly after this message appears, I get the dreaded db error message due to a syntax issue.

I looked at the logs and noticed that there is a fatal error that is one part syntax and another part where the actual tables don't seem to be within the database that CiviCRM created during installation.  I have tried a few different variants, such as older versions of CiviCRM, some cases where I did not create the separate database and user which spun off different errors, but there seems to be a theme of some type of syntax error (Mind you, I am not writing this SQL, the application is generating it).  Also, the tables this is referencing, don't seem to be anywhere in the MySQL database, which is confusing to me.  See below for a snip of the log file with what I am receiving.  Any assistance or advice you all can give as to why this is occurring and how I can possibly remedy it?

Thank you in advance!

Mar 02 23 : 46 : 59 [info] Creating canary TABLE Mar 02 23 : 47 : 05 [info] $FATAL Error Details = Array([callback] = > Array([0] = > CRM_Core_Error [1] = > handle) [code] = > - 2 [message] = > DB Error: syntax error [mode] = > 16 [debug_info] = > SELECT v.label AS label, v.name AS value, v.grouping AS grouping FROM civicrm_option_value v
    ,civicrm_option_group g WHERE v.option_group_id = g.id
    AND g.name = 'languages'
    AND g.is_active = 1
    AND v.is_active = 1
    AND (
        v.component_id IS NULL
        OR v.component_id IN (
            SELECT id
            FROM civicrm_component
            WHERE name IN (
                    "CiviEvent"
                    ,"CiviContribute"
                    ,"CiviMember"
                    ,"CiviMail"
                    ,"CiviReport"
                    ,"CiviPledge"
                    )
            )
        ) ORDER BY v.weight [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'grouping FROM   civicrm_option_value v, civicrm_option_group g WHERE  v.o' at line 1] [type] = > DB_Error [user_info] = > SELECT v.label AS label, v.name AS value, v.grouping AS grouping FROM civicrm_option_value v
    ,civicrm_option_group g WHERE v.option_group_id = g.id
    AND g.name = 'languages'
    AND g.is_active = 1
    AND v.is_active = 1
    AND (
        v.component_id IS NULL
        OR v.component_id IN (
            SELECT id
            FROM civicrm_component
            WHERE name IN (
                    "CiviEvent"
                    ,"CiviContribute"
                    ,"CiviMember"
                    ,"CiviMail"
                    ,"CiviReport"
                    ,"CiviPledge"
                    )
            )
        ) ORDER BY v.weight [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'grouping FROM   civicrm_option_value v, civicrm_option_group g

Is it mysql 8? Grouping is a reserved word in mysql 8 and civicrm doesn't officially support it yet.


Stripe card number field not showing since upgrade to 6.6 The block to enter credit card info is not showing up on my registration form so when submitted it does not go to Stripe...
Civi 5.36.1
Drupal 7.80

I removed the "US" country code from the Stripe settings and the credit card block appeared. Not sure why but at least I have a working registration form.


How to chain api calls i.e. GETFIELD contact for fieldID after doing GET profile on profileID? I want to join the below api calls-
API 1
http://ec2-3-6-40-236.ap-south-1.compute.amazonaws.com/civicrm/sites/all/modules/civicrm/extern/rest.php?entity=Profile&action=get&api_key=userkey&key=sitekey&json={"sequential":1,"profile_id":22}

RESULT 1
{

"is_error": 0,
"version": 3,
"count": 1,
"values": {
    "custom_64": "",
    "custom_65": "",
    "custom_66": "",
    "custom_46": "",
    "custom_47": "",
    "custom_48": "",
    "custom_62": "",
    "custom_50": "",
    "custom_51": "",
    "custom_63": "",
    "custom_53": "",
    "custom_54": "",
    "custom_55": "",
    "custom_56": "",
    "custom_57": ""
  }
}

API 2
http://ec2-3-6-40-236.ap-south-1.compute.amazonaws.com/civicrm/sites/all/modules/civicrm/extern/rest.php?entity=Contact&action=getfield&api_key=userkey&key=sitekey&json={"name":"custom_62","action":"get"}

RESULT 2
    {

    "is_error": 0,
    "version": 3,
    "count": 31,
    "values": {
        "id": "62",
        "label": "Relationship with Guardian",
        "headerPattern": "//",
        "title": "Relationship with Guardian",
        "custom_field_id": "62",
        "groupTitle": "Voter Details",
        "data_type": "String",
        "name": "custom_62",
        "type": 2,
        "html_type": "Radio",
        "default_value": null,
        "text_length": "255",
        "options_per_line": "2",
        "custom_group_id": "28",
        "extends": "Individual",
        "is_search_range": "0",
        "extends_entity_column_value": [
            "Voter"
        ],
        "extends_entity_column_id": null,
        "is_view": null,
        "is_multiple": "0",
        "option_group_id": "121",
        "date_format": null,
        "time_format": null,
        "is_required": null,
        "table_name": "civicrm_value_voter_details_28",
        "column_name": "relationship_with_guardian_62",
        "serialize": null,
        "where": "civicrm_value_voter_details_28.relationship_with_guardian_62",
        "extends_table": "civicrm_contact",
        "search_table": "contact_a",
        "pseudoconstant": {
            "optionGroupName": "relationship_with_guardian_20201110084841",
            "optionEditPath": "civicrm/admin/options/relationship_with_guardian_20201110084841"
        }
    }
}

I have tried with this api call-
http://ec2-3-6-40-236.ap-south-1.compute.amazonaws.com/civicrm/sites/all/modules/civicrm/extern/rest.php?entity=Profile&action=get&api_key=userkey&key=sitekey&json={"sequential":1,"profile_id":22,"api.Contact.getfield":{"name":"$value","action":"get"}}

But I got this error :(
    {

    "fields": [
        "name"
    ],
    "error_code": "mandatory_missing",
    "entity": "Profile",
    "action": "get",
    "is_error": 1,
    "error_message": "Error in call to Contact_getfield : Mandatory key(s) missing from params array: name"
}

Please help.

You probably want the UFField entity, not Profile ...  try:
entity=UFField&action=get&api_key=userkey&key=sitekey&json={"sequential":1,"profile_id":22}

Then you can chain getfield:
entity=UFField&action=get&api_key=userkey&key=sitekey&json={"sequential":1,
"uf_group_id":22,
"api.Contact.getfield":{"action":"get","name":"$value.field_name"}}

That assumes the custom fields are for Contacts.


Existing organizations getting updated when new person signs up with the same org name We have a civi membership contribution form that is on behalf of an organization. Right now, when new members sign up, if their organization has the same name as an existing organization, civi renews and updates the existing organization instead of creating a new organization. And the new member also gets added to the existing organization.

The dedupe rules for contacts don’t seem to have an effect on organizations for "on behalf of" contribution forms.

What is the best way to make sure a new organization is created and a new membership is created every time a user signs up?

I am wondering if you really want the membership form to be "on behalf of" an organization.

That feature is designed to be used when the organization is to be the member, (eg for a trade association) but, because organizations can't fill in forms, a person has to sign up "on behalf of" the organization. The organization can only have one membership, so when someone else comes along to sign up 'on behalf of' the organization they are effectively renewing that membership and will be added to that organization.

It sounds like you want the individual to have the membership, but you want to know that they belong to a particular organization.  If that is the case then your memberships should be for individuals, you should not let contacts sign up "on behalf of organizations" and you should include the "employee of" field in the profile on your membership form so that you have a relationship created between the organization record and the individual's record.


Does anyone use CiviCRM behind a Web Application Firewall? We're looking at deployment for a client who's sensitive to being hacked, so we want to put CiviCRM behind, say, nginx running mod_security2.  Has anyone used a WAF with CiviCRM that can share recommendations?

we have a slightly different approach for an enhanced security architecture using a proxy-server plus vpn. If you are interested, please sind more information plus code on GitHub, there was also a session on last year's CiviCon.

Let me know if you have any questions regarding CiviProxy.

Kind Regards
Fabian


Handling null values in tokens in civimail (and elsewhere) Has anyone developed an extension to handle null values in tokens?

For example:

Sending an email to a contact with no first name:

Dear {first.name}, will end up as  -> Dear ,

It appears that previously in 3.3 it was possible to use {first.name | default text}

Additionally a long while ago there was some discussion about reviving this behaviour.

Following this there was this post about how to change the behaviour site wide, however to enable more personalised emails (both in terms of the sender and recipient) would be great to allow for this to be done on a per email basis as well.

Following that I can only spot this SE question referencing the issue last year.

We used the Dave's Blog https://civicrm.org/blog/dave-greenberg/civimail-how-to-add-default-values-for-empty-tokens

The blog provides a sample code and the hook which need to be used. We added the same tokenValues() hook to the extension and it works great in replacing all the empty token values with the one specified in the hook.


Fix For "Incorrect Resource URL" Not Working I am getting the error "Incorrect Resource URL" and seeing 404 for URLs that go to "undefinedjs/jquery/jquery.crmAjaxTable.js" and many instances of the error "Unable to reach the server. Please refresh this page in your browser and try again."

I have tried resetting the URL (/admin/setting/updateConfigBackend?reset=1), adding a static path (civicrm/admin/setting/url?reset=1) and doing an override (https://docs.civicrm.org/sysadmin/en/latest/customize/settings/).

I am seeing the error in the UI and viewing the 404 using the browser console.  I am also using the CV command from the command line and see that the generated path from  (/admin/setting/updateConfigBackend?reset=1) does not match what I would expect.

[root@domain default]# cv path -c userFrameworkResourceURL
https://crm.domian.org//home/user/public_html/sites/all/modules/civicrm

I think the URL should be https://crm.domian.org/sites/all/modules/civicrm.

This started when upgrading a Drupal 7 site to 4.7.28.

Help with this is greatly appreciated. I am out of ideas.

Thanks!

We've had basic authentication active on the installation which broke the check. After adding the server IP to the whitelist the error disappeared.


Change log rollback not restricted to a single contact Not so much a question as a development request...

We manually add/edit records but also do a lot of importing into Civi.
When some errors were found on a particular contact record we used the 'revert these changes' button in the change log expecting it to revert only the update to the single specific contact record.

Unfortunately because the changes were as the result of an import into civi for approximately 650 contacts it rolled back all changes across all 650 records.

Because we could not unpick which specific import it was (there were a number of imports against these 650) we then had to delete all 650 contacts and re-import from scratch.

Not sure where to put the request for future development, but it would be great to be able to choose between a revert against a single record versus the full import set...

That sounds frustrating. Thanks for sharing your experience. Feature requests should be made in CiviCRM's issue tracker.


View uploaded documents without having to download them every time - Wordpress I am not a developer, just a charity volunteer so bear with me please!!...

I would like to find a way to simply view files uploaded to contacts (for example under Activities, or Notes) without downloading them every time.

Example, I want to save a PDF of a letter under a Note. But every time I want to view the PDF, it downloads it, clogging up my PC....

How do I get around this problem??

Thank you and apologies if this is a super duper easy question...

Thanks

Anna

As Pradeep implies, this isn't a CiviCRM issue but a web browser configuration issue.

I'm not sure what web browser you're using, but in Firefox, when I click on a PDF in an activity (see "1" below), I get a pop-up where I can select "Open With" (2) and "Do this automatically for files like this from now on" (3).  I imagine similar options exist for all the major web browsers.


how to keep previous values of custom Membership fields upon renewal Civi 5.15.1, WP 5.3.2

My organization provides low-cost farm plots to farmers. We use Civi purely back-end (no website exposure). Each farmer can have multiple plots, which we have implemented in Civi as multiple separate "Farm Plot" Memberships. Farmers usually keep the same plots year after year, so when we renew each Membership, the "Assigned Plot Number" field carries over, which is exactly what we need for that field.

However, we also need to record whether each farmer cleaned up each of their plots at year's end ("Plot Condition"), and we need to keep that information tied to that specific period/plot/farmer. When we renew the Membership, last year's value will carry over to the new year, which is NOT what we want for this field.

We considered switching how we handle Farm Plots from Memberships to Contributions (b/c they're already time-specific). But the plot assignments happen well before plot payments come in, which happens well before we assess Plot Condition. So we'd have to log the Contribution at the start of the year so the plot# is there (no more easy renewal carry-over from last year), set Contribution Status to Pending until we receive payment, and edit the record again at year's end to add Plot Condition. Yuck.

Could anyone suggest any alternatives (other than using Notes)? Many thanks!

Suggest you consider using Activities since these offer greater flexibility imo.

Cases could also be considered with each plot of land representing a Case.

Either ways you end up with an annual Activity for "Plot Condition" etc etc


PHP version matters or not? I've been running certain 5.6 for a long while and wondering if I ever should migrate to 7.0 or just leave alone. Installation instructions say 7.0 is recommended but so is 5.6

Anyone have opinions on this?

---Update:  I have upgraded my WordPress site to 7.2 without too much trouble.  However the Drupal 7 / Civi site when I tried to update, I got 503 errors and had to roll back.  I think there are some really tight controls the consulting firm put into place.  I kept reading about FastCGI and NGINX and had no idea.  I do not know about these and if they are used.  I know that FPM is used.  I want to update before year end but I am scared.  Anyone?

A few considerations:

1) You want to be running a version that has security support. See https://secure.php.net/supported-versions.php  Both 5.6 & 7.0 have support to Dec 2018.  Beyond that, you need 7.1+ (although 7.1 is not currently recommended for use with CiviCRM - https://docs.civicrm.org/sysadmin/en/latest/requirements/)

2) php 7 is faster than 5.6.  See http://www.zend.com/en/resources/php7_infographic  Why not run the faster version?

3) Maintaining support for old versions of php is a drain on development resources and prevents CiviCRM taking advantage of new php features.

So, yes upgrade to 7.0 now (providing you are on the current 4.7.* release) and expect to keep upgrading.

[Edit: prompted by Graham's comment.]

Php requirements links:

Drupal 7
Drupal 8
Wordpress
Joomla!
Backdrop


Joomla CiviCRM Upgrade 4.3.9 to 4.4.x version I am unable to upgrade 4.3.9 version into new version ..

I am getting this error : Error: Consolidate activity contacts

Type    DB_Error
Code    -2
Message DB Error: syntax error
Mode    16
UserInfo    UPDATE civicrm_option_value SET is_reserved = 1 WHERE option_group_id = 62 AND value IN (2, , 3) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 3)' at line 3]
DebugInfo   UPDATE civicrm_option_value SET is_reserved = 1 WHERE option_group_id = 62 AND value IN (2, , 3) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 3)' at line 3]

It seems that you may have deleted the 'Activity Assignees' option from the 'activity_contacts' option group. That's what the missing id is supposed to refer to in IN (2, , 3)


How to find out who created an event? Is there an easy way to find out who created an event like how we are able to see who created an email?

CiviCRM DOES store that information, but doesn't expose it to the user interface.  So you have two choices:

Check with SQL.  This will give a list of all events with creators:

select ce.id, ce.title, cc.display_name from civicrm_event ce JOIN civicrm_contact cc on ce.created_id = cc.id;

Add WHERE ce.id = x before the semicolon at the end to just show a single event (where x is the event's ID).

I wrote an extension that allows you to view (and change) the name from the user interface called Edit Event Manager.


How can I add PHP as content with HTML editor? Using Drupal 7 with CIVI crm 5.x

I'm doing some testing with this:

 Hello World'; ?>

Paste it in source code, but then it strips it out like this:

Hello World

With Drupal I can tweak things so this can work, but how do I do it with CIVI CRM or it is even possible?

I believe its not possible to add php code in CiviCRM text area or ckeditor fields. I guess for security reasons it doesn't allow you to add any code snippets. Alternate solution is to use hook to alter the content of the field by using tokens.


Signature error using AWS SNS/SMS to send SMS message using Civi extension - uk.compucorp.civicrm.amazonsns AWS Error - Error Sending SMS through Amazon SNS [SignatureDoesNotMatch]: - The request signature we calculated does not match the signature you provided.
Using amazonsns extension.    Can send individual messages using AWS console but errors when sending individual or mass sms from Civi.    AWS user has full permissions for SNS.    AWS mentions Version 4 generates signing key derived from signing access key rather than secret access key itself.
Any suggestions for troubleshooting this issue?   Is extension generating the signing key using V4?
Thank you.

Found the problem.   AWS has an option for a user to have either console usage or programmatic or both.
need to set programmatic use  when creating the user and permissions for SNS as needed.  Full SNS access permissions seem to work fine.


How to make a single form that works with an individual, and organisation and their Relationship in Wordpress Most of the Memberships for my organisation reside with Organisations which are then represented by a named individual.

Is it possible using CiviCRM in Wordpress to design a website form which collects the Individual data such as first name & last name AND Organisation data such as Organisation Name and then ties the two together by setting the Relationship as Employer<-->Employee.

There seem to be some solutions available for Drupal users such as Webform Integration or CiviRelate.

Any ideas on how one might do this in wordpress?

Sounds like you might need to set your Membership page up so that it is 'on behalf of' ie so the Membership is created for the Org, and the Individual becomes permissioned 'current employee of' that Org.
The 'on behalf of, settings are on the Contribution 'Title' tab. The profile it offers by default is a 'reserved' Profile (so is on the Reserved 'tab' on Profiles), but you can clone it, change the clone and use that if you don't like what the default one offers by way of fields.


Duplicate contact when i log with this one Apparently when i'm trying to log with a contact, this one is duplicate :-/
Someone said that it could be because the wp email is different of civi email but in my case both are the same. If someone knows how to resolve it :)

Have a nice day

You can dedupe contacts in two ways in CiviCRM.

The first one to do a search and find both contacts and then check the checkbox in front of both contacts and select the Merge Contacts from the action list (screenshot is in Dutch).

The other way is from the dedupe functionality under the Contacts --> Dedupe menu.

You have to select a rule and it will try to find matching contacts which you could then merge.


Drupal Webform / CiviEvent showing private events and closed registration events We are using Drupal Webforms to allow people to register for CiviEvents. We are using the Live Options setting for the Event Selection. Our issue is that we are seeing in the Live Options list events that are PRIVATE (not marked public) and events that have registration closed. The only way to stop them from showing is to make them inactive events. This then causes all schedule reminders to stop being sent.

Question:  Other than use Static Options, how to we make events that are private and/or no longer open for registration stop showing?

CiviCRM 4.7.6 and Drupal 7.51

Thanks!
Sheila

If your organization can fund an hour or two of development via the paid issue queue we could get that filter added to the webform-civicrm module to prevent unwanted events from showing.


custom public participant listing we use wordpress and civicrm to allow our members to register for sports events.
I would like to display in an article for all authenticated member, the list of registered people to all of the week events.
My first intention was to custom or create a public participant list that already exist but :

it is only for one event
I don't know how to add the Role (ie Animateur or Participant or Invité) and the comment of the participant (both information entered in the custom profile registration)

Need your advise
Regards,
Hervé

I would use content views wordpress plugin along with content views civicrm integration plugin and data processor civi extension to list what you want.


CiviMail: Email marked as 'Draft and Unscheduled' but outgoing mail log says it's been sent Civi 5.13.5, Drupal 7.67.

Hey everyone,

A colleague tried to send out a mailing through CiviMail to a smart group that we have been using for a few months now.

She tried to send the email but received this error message (unfortunately she didn't send a screenshot, only this text)

  Error
  Unrecognized value for setting 'flexmailer_traditional'

We do have flexmailer currently installed and enabled as I've been trying to get Mosaico to work for months (no success), but we have previously successfully sent out mass mailings on CiviMail while Flexmailer has been enabled, without receiving this error message.

The email is still listed on Mailings > Draft and Unscheduled Mailings (/civicrm/mailing/browse/unscheduled?reset=1&scheduled=false), with the status marked as 'Unscheduled'.  It is not listed on the Mailings > Scheduled and Sent Mailings page.

Any idea on why this has happened, and how I can fix it and/or ensure that it doesn't happen in the future?

Thanks in advanced!

I've corrected this when it has happened by clearing the cache (Administer>System Settings>Cleanup Caches).


How to find out the URL of my search results and edit the columns in the results? Using CiviCRM 5.x and Drupal 7 on localhost.

2 Questions:

1- How to fetch URL that has a full lists of contacts. Right now I can copy they URL, but when I flush the cache the URL changes, so I would need something like Path Auto for this?

2- How to modify the fields the table list view of contact

I'm attaching the screen capture for demonstration purposes:

You can configure profile to use as contact search. You can also control the result columns in profile search. To display contact result by default you can append force=1 in url.

Ref: https://docs.civicrm.org/user/en/latest/the-user-interface/searching/#views-for-display-contacts

You can create smart group which holds all the contacts and use the contacts link from Manage group page to use as a url.

Use contact search url and apend force=1 to display contact by default.

HTH

Pradeep


An active PHP session was detected I'm running CiviCRM v5.32.2 and the CiviCRM WP REST API v0.1 plugin in Wordpress v5.6.
In Wordpress Site Health Status i get this warning:
An active PHP session was detected

A PHP session was created by a session_start() function call. This interferes with REST API and loopback requests. The session should be closed by session_write_close() before making any HTTP requests.

Do you know if this error is related to CiviCRM, and what to do about it?

The same questions was asked at WordPress Site Health contains critical errors unless CiviCRM is disabled and had some good answers.
Summary:

Yes CiviCRM is to blame for the notice.
No - it's not a real problem.
Plugins exists to suppress the notice.


Mailer Limited to 10 Groups On a Drupal 7.56 / CiviCRM 4.7.27 site, since the last update, when making a mailer we can only add 10 groups and then it doesn't allow us to add more.

Previously it worked for more than 10 groups.

I see no errors in front end nor back end.

This is a known (fixed) bug, CRM-21468.  You can apply the patch manually if you feel comfortable; otherwise, it will be fixed in CiviCRM 4.7.29.


Safe to uninstall Mosaico extension? Last April, I installed the Mosaico extension on CiviCRM / WordPress. Although the install seemed to be successful (Mosaico shows up in the list of extensions as enabled), I get a message "ImageMagick is not installed" when I go to the CiviCRM dashboard.

I'd like to now to uninstall Mosaico. I found these instructions:

In order to uninstall extension, you need to disable it first - once disabled, you will see the "Uninstall" link. Click it in order to completely remove the extension from your system, including permanent deletion all of its custom data. To preserve the data, take a backup before uninstalling. (https://docs.civicrm.org/sysadmin/en/latest/customize/extensions/)

As far as I know I have never really used Mosaico.  I do have a backup of the database and all files, but I'm just wondering before I proceed if uninstalling could cause any problems, or if there's anything else I might need to know.

Thanks!

Mosaico doesn't create any custom data in CiviCRM, so it is safe to Uninstall the extension. However, any template created in Mosaico will be lost.

To uninstall the extension you will need to disable it.


Activities and Nodes in One Calendar I currently use Drupal's Calendar module to display CiviCRM activities on a Views Calendar. I also have another content type that displays nodes on a Views Calendar. Is it possible to display both CiviCRM activites and content type nodes in one calendar?

I tried the CiviCRM Entity module, but activities don't seem to be available as a field.

Drupal Views starts off with a base table - do you want to look at:  User, Nodes, CiviCRM activities and so on.

So if the base table is Nodes, then it's looking at nodes for the date info and displaying them.

If the base table is CiviCRM Activities, it's looking at those for the date info and displaying them.

But currently in Views you cannot combine this data. They are two separate views.

Back in the forums there has always been discussions about combining Drupal node dates and CiviCRM event dates - it's the same problem.

So out of the box there is not really a solution for this.


'DB Error - No Such Table' -- CiviCase in Drupal 7 I have a Drupal 7 + CiviCRM database with CiviCase.
This is a fairly new install. I would say CiviCRM was installed fresh about 3-4 months ago. As of now, CiviCRM has been upgraded to the latest current version, 5.25.0.

I noticed the following problem on 5.24, but as this is still a new install in development, its possible the problem has been there since the beginning.

When I go to Cases -> Dashboard, I see:

  DB Error: no such table

Additionally, when I go to view a Contact, and then click the "Cases" tab, I see the follow message in the upper right of the screen:

  Unable to reach the server. Please refresh this page in your browser
  and try again.

How should I go about fixing this?
It seems like the entire table structure is missing?

There is no production data in the CiviCase extension yet, so if it is possible to just do a complete fresh install of just that portion of CiviCRM, I can do that. I just don't know how I would do that safely without affecting the work I've done to other portions of the Drupal and CiviCRM database.

Here is the backtrace for when I see the DB error:

#9 /home/lapavnhy/example.com/sites/all/modules/civicrm/packages/DB/DataObject.php(2696): DB_common->query(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")#10 /home/lapavnhy/example.com/sites/all/modules/civicrm/packages/DB/DataObject.php(1829): DB_DataObject->_query(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")
#11 /home/lapavnhy/example.com/sites/all/modules/civicrm/CRM/Core/DAO.php(421): DB_DataObject->query(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")
#12 /home/lapavnhy/example.com/sites/all/modules/civicrm/CRM/Core/DAO.php(1540): CRM_Core_DAO->query(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...", TRUE)#13 /home/lapavnhy/example.com/sites/all/modules/civicrm/CRM/Case/BAO/Case.php(537): CRM_Core_DAO::singleValueQuery(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")
#14 /home/lapavnhy/example.com/sites/all/modules/civicrm/CRM/Case/Page/DashBoard.php(71): CRM_Case_BAO_Case::getCases(NULL, (Array:0), "dashboard", TRUE)
#15 /home/lapavnhy/example.com/sites/all/modules/civicrm/CRM/Case/Page/DashBoard.php(100): CRM_Case_Page_DashBoard->preProcess()
#16 /home/lapavnhy/example.com/sites/all/modules/civicrm/CRM/Core/Invoke.php(311): CRM_Case_Page_DashBoard->run((Array:2), NULL)
#17 /home/lapavnhy/example.com/sites/all/modules/civicrm/CRM/Core/Invoke.php(68): CRM_Core_Invoke::runItem((Array:15))
#18 /home/lapavnhy/example.com/sites/all/modules/civicrm/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke((Array:2))
#19 /home/lapavnhy/example.com/sites/all/modules/civicrm/drupal/civicrm.module(454): CRM_Core_Invoke::invoke((Array:2))
#20 /home/lapavnhy/example.com/includes/menu.inc(527): civicrm_invoke("case")
#21 /home/lapavnhy/example.com/index.php(21): menu_execute_active_handler()
#22 {main}

As confirmed in chat the views hadn't been created and disabling and reenabling civicase at Administer - System Settings - Components fixed it.


Using hook_civicrm_tabset; why doesn't my tab focus when linked to via url? I've added a tab adjacent to the event "Info and Settings" configuration tab, using hook_civicrm_tabset(), but when I link to the URL for that tab, the "Info and Settings" tab is displayed. This behavior is different from that of native tabs, such as "Location": I can type in the URL for that tab, and the tab is correctly selected.

Question: How can I get my "My Settings" tab to display itself from a URL in a way that's equivalent to the behavior of native tabs such as Location?

Here are some examples of native URLs that work as expected, and my custom tab which does not.

"Info and Settings" tab
http://example.l/civicrm/event/manage/settings?reset=1&action=update&id=23

"Location" tab
http://example.l/civicrm/event/manage/location?reset=1&action=update&id=23

"My Settings" tab
http://example.l/civicrm/event/manage/mysettings?reset=1&action=update&id=23

Example code (slightly redacted for public viewing)

/**
 * Implements hook_civicrm_tabset().
 *
 * @link https://docs.civicrm.org/dev/en/latest/hooks/hook_civicrm_tabset/
 */
function myextension_civicrm_tabset($tabsetName, &$tabs, $context) {
  if ($tabsetName == 'civicrm/event/manage') {
    if ($eventId = CRM_Utils_Array::value('event_id', $context)) {
      $tab['mysettings'] = array(
        'title' => E::ts('My Settings'),
        'link' => NULL, // 'link' is automatically provided if we're under the 'civicrm/event/manage' path.
        'class' => 'ajaxForm', // allows form to re-load itself on save.
        'valid' => _myextension_EventHasMySettings($eventId), // indicates whether tab has actively used settings.
        'active' => TRUE,
        'current' => FALSE, // setting this to FALSE prevents the tab from pre-loading
                            // focus when the page is loaded.
      );
    }
    else {
      $tab['mysettings'] = array(
        'title' => E::ts('My Settings'),
        'url' => 'civicrm/event/manage/mysettings',
        'field' => 'is_my_settings',
      );
    }
    //Insert this tab into position 1
    $tabs = array_merge(
      array_slice($tabs, 0, 1),
      $tab,
      array_slice($tabs, 1)
    );
  }

  // Set mysettings tab as enabled/disabled in configuration popup-menu, on manage events listing screen.
  if ($tabsetName == 'civicrm/event/manage/rows' && $eventId = CRM_Utils_Array::value('event_id', $context)) {
    $tabs[$eventId]['is_my_settings'] = _myextension_EventHasMySettings($eventId);
  }
}

You will need to add below line in your preprocess() function.

$this->assign('selectedChild', 'mysettings');


Export Activities associated with CiviCase We're currently discussing whether it's possible to use the activities recorded in a Case (including the scheduled activities in a timeline), export them into Excel and convert it into a Gantt chart, but I can't see a way to export all activities associated with a Case. When I look at the options in the Civi Reports, it will only export the most recent activity. Would Drupal Views be any use?

Yes, you would be able to do that with Drupal Views. There is also an extension that provides the Case Activities with the API: https://civicrm.org/extensions/caseactivity-api


Contribution import fails for all records with error "No matching Contact found" I successfully imported contributions from csv files, up to 4.6.3.  Now when I try to import using the same saved mapping, in Joomla with 4.6.6, every record fails with the error

No matching Contact found for (person@example.com )

Is anyone else having trouble under 4.6.6?  My field mappings look correct, and the contact email addresses do exist as contacts in the database.

The only change to the file CRM/Contribution/Import/Parser/Contribution.php between 4.6.0 and 4.6.6 is the addition at line 263 of:

$params['contact_type'] = 'Contribution';

Commenting this out seems to fix my problem.  My contribution imports are based on matching the individual contact by email address, so I'm guessing that this line broke things by forcing a lookup by contribution ID.

Should I file a bug report?


PayPal Contributions listed as Pending (Incomplete Transaction) I'm running CiviCRM on the latest version of Wordpress and since the beginning of December, when I upgraded CivicCRM to 4.7.14 (although it is possible that it started when I upgraded to 4.7.13, I don't have the exact dates I did the upgrade), I've had an issue with PayPal standard contributions being listed as "Pending (Incomplete Transaction)". As a result, membership renewals are not being renewed and receipts are not being sent to our members.

After digging around, I was able to confirm that the Paypal IPN appears to be working. I'm able to see the IPN message logged in the civicrm_system_log table after every transaction. I've put an example of one such message from the system log below, with personally identifying information blocked out:

  {"page":"CiviCRM","q":"civicrm/payment/ipn/1","noheader":"1","transaction_subject":"","payment_date":"04:19:32
  Dec 22, 2016
  PST","txn_type":"web_accept","last_name":"doe","residence_country":"US","item_name":"416-497-Membership
  Renew","payment_gross":"50.00","mc_currency":"USD","business":"organization@clubname.org","payment_type":"instant","protection_eligibility":"Ineligible","verify_sign":"AqNs9DpWzUAQyDfgFPwuR482uwS5AjALjQykxLxxxxxxxxxx.xxxxxxxx","payer_status":"unverified","payer_email":"john@johndoe.com","txn_id":"89J243361xxxxxxxx","quantity":"1","receiver_email":"organization@clubname.org","first_name":"john","invoice":"54e25fc0c32d4d259e6f0a1aaxxxxxxxx","payer_id":"T72CDJGxxxxxx","receiver_id":"ZHZCAVNxxxxxx","item_number":"","payment_status":"Completed","payment_fee":"1.40","mc_fee":"1.40","mc_gross":"50.00","custom":"{\"module\":\"contribute\",\"contactID\":\"416\",\"contributionID\":497,\"membershipID\":\"380\",\"contributionRecurID\":86,\"contributionPageID\":\"1\"}","charset":"windows-1252","notify_version":"3.8","ipn_track_id":"f0958f92xxxx","IDS_request_uri":"/membership/?page=CiviCRM&q=civicrm/payment/ipn/1&","IDS_user_agent":"PayPal
  IPN ( https://www.paypal.com/ipn )"}

However, CiviContribute never seems to update the status of the contribution. I did notice that the content of the IPN messages in the system_log prior to December looked entirely different than the new IPN messages look.

Also, for what it is worth, I've also noticed that all contribution transactions are being marked in CiviCRM as being set to auto-renew. I was able to confirm that it is doing it without the end-user requesting it when I duplicated it in a PayPal sandbox session. After filling out a contribution form, I went and looked in CiviCRM and my test transaction was also set to auto-renew. I don't know if this is a related issue, or a separate problem entirely.

Any help or insight is greatly appreciated, as this bug has returned our membership management to an almost entirely manual operation once again!

See this thread - I have to overwrite ipn.php with an old version after every upgrade, to get payments working again Paypal payments - Pending (Incomplete Transaction)


Joomla loadmodule or loadposition inside CiviCRM please how can I use {loadmodule xxx} or {loadposition xxx} inside:
- an event description
- a profile intro field

Thank you

I don't think that you can do that, at least not without programming. Event descriptions and profile intro fields are rendered by CiviCRM, not Joomla, and CiviCRM does not process Joomla plugins.

If you have the event page linked to a Joomla menu item then of course you can display a module elsewhere on the page (outside of the CiviCRM-generated content).


Choosing Payment Method disables Continue/Contribute buttons Running CiviCRM 5.12.4 and Joomla 3.9.5.
I am having a continuing problem with the Payment Method on paid events and registrations. We use Paypal and Pay Later on both profiles/events.
Paypal is the default. Leaving that without changing the payment option, the Continue/Contribute button works as expected. If you make any change to the payment options, the Continue/Contribute button gets disabled.
For online registration I created two profiles, one for Paypal and another for Pay Later. Ok workaround. For the event I cannot do that as we have a maximum number of attendant spaces.
I think this might be Joomla related as I found mention using Drupal, but the workaround doesn't fix the problem.
This is our first paid event and fixing this is critical for us. Any help or suggestions would be greatly appreciated.
Thanks.
Edit: The following error was noted when switching from Paypal to Pay Later.

TypeError: CRM.loadPage is not a function[Learn More] index.php:835:7
buildPaymentBlock https://www.rbsportsboosters.com/index.php?option=com_civicrm&task=civicrm/event/register&Itemid=1129&id=33&reset=1:835

<anonymous> https://www.rbsportsboosters.com/index.php?option=com_civicrm&task=civicrm/event/register&Itemid=1129&id=33&reset=1:839

jQuery 2

We are on Joomla 3.95 and CiviCRM 5.9.1. I do not understand why you would need two profiles for your event, as the 'Fee' tab allows both credit card processing and the pay later option. See:

https://docs.civicrm.org/user/en/latest/events/creating-an-event/


CiviCRM with Contact form 7 I have contact form 7 with CiviCRM integration. How can I get API settings? https://prnt.sc/kdqylc

the Contact Form 7 with CiviCRM extension is meant as a basis for developers, it does not DO anything in itself. It enables sending data from a Contact Form to CiviCRM if you enter the data in the Contact Form in the correct way. But then something needs to happen on the CiviCRM side to. If you have developer skills, there is an example here: https://github.com/CiviCooP/be.werkmetzin.wpcivi

The API settings required are the site key and the API key required for CiviCRM API access. You can find more information here: https://docs.civicrm.org/dev/en/latest/api/interfaces/#rest.


Why can't I export a Contact Detail report to CSV? I have a problem with civireport. Since I've created and saved one report I can't export it anymore to csv. First, the export to csv was missing. I've tried this...

http://forum.civicrm.org/index.php?topic=22773.0

...but nothing happened.
Then I tried this...

http://forum.civicrm.org/index.php?topic=17001.0

...which gave me back the export to csv button, but now, when I click it , I only get a 288 bytes CSV . There's no data at all.
I've also found this ...

https://issues.civicrm.org/jira/browse/CRM-4831

...but as you can see it was closed without fixing.

I really need to get this fixed. My organization NEEDS the export report functionality.

Iván Lago

IT Engineer at Engineers Without Borders Galicia

More info:

Server version: Apache/2.2.22 (Debian)

CMS: Drupal 7.36

CiviCRM version:4.6.0

PHP: 5.4.39-0+deb7u2

MySQL: 5.5.41-0+wheezy1

The report you are trying to export (Contact Detail) does not currently support that feature. That particular report presents a variety of information that does not lend itself easily to be represented in a single spreadsheet.

You could use a similar report, such as Contact Summary, and export that.

Or you could use your programming expertise and creativity to find a way to make that report generate an exportable spreadsheet.

CiviCRM is an open-source project and new features come from community contributions of code or funding. The issue you referenced was closed due to lack of participation. Community members such as yourself could change this by stepping up to make it happen.


how can I change the contact type for one contact (to/from individual/household/organization)? All contacts have a type of either "individual", "household", or "organization".

How can I change this type for an existing contact?

Say you want to convert from an individual to a household. One very hack-ish way is as follows:

Create a new household with the desired household name.
Note the "contact id" values for the individual (INDIVIDUALID) and for the newly created household (HOUSEHOLDID). (You can find this "contact id" value at the bottom of the screen when viewing the contact where it says something like "CiviCRM ID: 2345". Also this id value is in the URL of the page where you view the contact.)
Manually navigate to the following URL where you will merge the two contacts. In this URL you will have to replace "HOUSEHOLDID" with the id value for your newly created household and replace "INDIVIDUALID" with the id for the individual you want to "convert" to a household.

http://example.com/civicrm/contact/merge?reset=1&cid=HOUSEHOLDID&oid=INDIVIDUALID&action=update
Check all boxes, except make sure "contact type" and any "name" fields are un-checked
Merge the individual into the household.


Allow only 1 selection in a price set with multiple price fields We offer individual and joint membership with a couple of different rates for each type. I have created a price set that has 2 price fields and each price field has a couple of options. I want to set the price set so that only one option can be ticked across both price fields. There isn't an option for this and but I hope someone has a solution. I can put all types of membership into 1 price field but it reduces the system options and makes laying out the contribution page harder. Any help appreciated.

Yes, the price fields are independent, and the design limits you to putting all the membership types/flavours into one price field if you need to force only one.

Of course, you could write some javascript to do something like what you want, though that would be a bit of a hack.

A simple alternative is to create separate contribution/membership pages for each membership type - so the visitor would be presented with different links for each membership type before getting a form. That allows your form to be simpler and have additional membership-type-specific messaging and behaviour.


Hook for contact view Is there any hook that can be used for logging contact views? We need to create report for that and first of course need to put that information to database.

With contact view, I guess you mean when a contact summary page for a specific id is loaded you want me to increment a count number and store it in DB to display it in the report.
Currently, there is no such feature in core civicrm. You need to add a custom extension to add this functionality. See more details to build a simple ext at https://docs.civicrm.org/dev/en/latest/extensions/civix/. Some basic steps would be -

Add a custom field to extend Contact eg View Count.

Use hook_civicrm_summary to increment the value of this field for a specific contact ID.

You can use this custom field to show on any report provided by civicrm.


Unwanted CiviRule email sent to Admin I have a client with a simple set-up. When A assigns an activity to B with C, then B and C get notified per e-mail with a special template. But also D (me i.e Admin) and I'm not mentioned in any of the civirule and this address doesn't either show up in any parameter for e-mails.
Is there a way to prevent this?

There is no strange behaviour, just lack of information ;-) A trainee was using this e-mail address to create 'Activity'