View alerts messages I just installed 4.7.25.  All messages said success.  However, when I enter CiviCRM in my Joomla site, I see several warnings like No Cron running, etc. When I click on "View alerts...", the screen empties.   Did a file/script get missed?  Should I reinstall?  Thanks for your help.

Welcome to the world of CiviCRM!  A few things to note:

Joomla 3.8 changed the location of some files, breaking CiviCRM on Joomla.  Some of these problems were fixed in CiviCRM 4.7.27, which was released yesterday.  The other bugs were fixed, but not in time to make the testing phase for Civi 4.7.27.  They'll be in Civi 4.7.28, releasing December 6, 2017.  If you feel comfortable applying patches manually, see CRM-21203 and CRM-21208.  Otherwise, you need to wait for the new release.
Like Joomla, CiviCRM doesn't set up cron on its own - you must set it up yourself.  However, scheduled jobs tend to be more important in CiviCRM (e.g. you can't send out a mass mailing without cron, or auto-update membership statuses). Instructions to set up cron vary widely depending on your host - if you have direct access to cron, you can use the instructions on this page: https://docs.civicrm.org/sysadmin/en/latest/setup/jobs/.  If you use CPanel, WHM, AlternC, etc., you can set up cron through the control panel.

Note that the cron instructions are a bit messy, and have been rewritten, but the rewrite hasn't been fully edited yet.


Smart Group relative date criteria not saving There is a history of a bug in which Smart Groups do not store the proper relative date ("Next 60 days") criteria, but rather convert the relative date into a hard date ("3 Jan 2018" to "4 Mar 2018"). This bug was noticed starting with v. 4.7.x and was. supposedly fixed in 4.7.13 I'm still having this issue in 4.7.27 (Joomla 3.8.2).

Anyone else notice this recurring? Any advice?

I recall we've experienced this for quite a number of fields in Advanced Search. Some of them are - Event Dates, Registration Dates and some date filters in Case section.

I did a patch to fix this for us but missed to update core for some reason. If the above fields fail for you, can you try applying this patch and see if it works for you?

Opened a JIRA for this issue with a PR https://github.com/civicrm/civicrm-core/pull/11486.


Some problems to add email account in CiviMail CiviCRM I am trying to configure the email address to send messages. I am trying to use a Google Workspace user with custom domain.
Some values that I have are the following:
Server: smtp.gmail.com
Username: myemail@apapacheautismo.org
Local part: (empty)
Email domain: apapacheautismo.org
Email return path: (empty)
Protocol: IMAP
Origin: (empty)
Use SSL ?: Yes
Used for: "Bounce Processing"

An error occured while sending or receiving mail. The IMAP server did not accept the username and/or password: A0001 NO [AUTHENTICATIONFAILED] Invalid credentials (Failure). (See log for more details.)
I have already verified username and password and they are correct.

First step would be to use Server: imap.gmail.com. smtp.gmail.com is for outgoing mail and Bounce Processing is for checking incoming mail.
Second step would be to verify that Less secure app access is enabled in Gmail.
If that doesn't solve the problem, here are the settings that work for me with Google Apps for bounce processing, same as what you have but using POP instead of IMAP:
Server: pop.gmail.com Protocol: POP3
Optionally, add Local part: myemail+ if you want VERP processing.


Deduping's "No of contacts to find matches for" field definition When you go to "Use Rule" on the "Find and Merge Duplicate Contacts" page, you get a new page that has 2 fields, one called "Select Group" and the other called "No of contacts to find matches for" with a default value of 3.  What is this second field and how does it work?  The documentation I've found so far doesn't include it.

I'm on wordpress 4.7.3 and civicrm 4.7.18.

Thanks,
Ruth

I'm on the same version and this is the view that I'm seeing. Haven't seen what you are referring to...


What's the problem with this state province crash? I migrated at the weekend from 4.6.22 to 4.7.19 and all went smoothly. But now users get the following problem when updating a contact's address. They get 'Unable to reach network' but looking in ConfigandLog I see this line prior to the fatal error:    /home/rsvpadmi/public_html/sites/all/modules/civicrm/CRM/Utils/Geocode/Google.php(87): CRM_Core_DAO::getFieldValue("CRM_Core_DAO_StateProvince", "null")

I 'fixed' the problem by switching off Google maps in 'Mapping and Geocoding'. In fact, maps were being displayed OK but users just couldn't update an address.
Anyone have any clues as to what the problem is?

This sounds consistent with hitting a rate limit in Google Maps API.

If so, the fix would be to disable geocoding (as you've done) or to configure a valid API key associated with payment details so Google can bill you for geocoding.

I recently observed similar behaviour when a client was viewing large numbers of contacts in a proximity smart group - possibly this triggered a mass lookup of contacts who lacked geographic co-ordinates.

Your CiviCRM debug log may have more information.


Getting an error 500 (PHP memory allocation) when adding event participant We've got a 4.6.10 CiviCRM site which has been running without fuss for a while. Now, when adding an event participant, we get an error 500. The process of adding the participant works fine (they appear in the list of participants) but the receipt does not get sent out and the page never returns. In the Apache error log, I see the following :

Allowed memory size of 536870912 bytes exhausted (tried to allocate 474218496 bytes) in /var/www/html/sites/all/modules/civicrm/CRM/Core/Error.php on line 550

The memory limit was actually 128M but it was increased, just in case. As you might guess, it makes no difference. I decided to set "display_errors = 1" in my php.ini, but that just gives me a completely white screen without the 500 error displayed.

Any thoughts or ideas on how to figure this one out would be greatly appreciated.

-- Marcel

It might be that the pdf receipt format is too complex, try to disable sending them, see if it makes a difference

It's under admin > setting > misc

"Attach PDF copy to receipts"

If you need to send the pdf, I recommend you to let civi use a dedicated software to generate the pdf instead of the default (doing it in php, that uses tons of memory), it's a setting in the same page:
"Path to wkhtmltopdf executable"

you'll need to install this software on your server.


How can I add a tag to a tag set? Using CiviCRM 4.7.16. I create a new tag and I want to add it to a tag set. But when I click on the Parent Tag pull down menu, it only shows tags that have not been assigned to a set. Tag sets are not shown. This is the case when both creating a new tag and editing a tag. I can't see another way to add a tag to a tag set.
Is this a bug?

You may be right that this is a bug in 4.7.16. Fortunately it has been solved in 4.7.17.

This release includes a redesigned tag management screen with numerous improvements.

Update: 4.7.17 has been released.


CiviCRM Architecture - CiviCRM directory structure Can anybody help me understand the architecture and directory structure of the civicrm. I found this post written in 2006 which doesn't seems to be valid for newer version.

this is still mostly valid, with the addition of the api folder that contains, you guessed it, the api goodness.

You might have several folders missing depending on how you install it. eg all the test and xml folders are only there if you install a full/development environment, not if you download the pre-packaged production version

What is missing or unclear?


Any procedure to upgrade Joomla 2.5.28 to Joomla 3.5 with CiviCRM 4.4.4? I am in the throes of making the upgrade captioned above. If there was a documented procedure or a list of potential issues to help I would be grateful. Maybe I should upgrade CiviCRM to a leter version first??

The first issue to raise is that CiviCRM 4.4 is not necessarily compatible with Joomla 3.5 according to this post: https://civicrm.org/blog/colemanw/announcing-civicrm-445  Since CiviCRM 4.6 apparently is compatible with Joomla 2.5, I suggest upgrading Civi first from 4.4 to 4.6.  Most CiviCRM documentation has to do with upgrading CiviCRM, rather than upgrading Joomla, so I'm not prepared to give advice on Joomla upgrades specifically.


How to configure the MIGS Omnipay gateway? I'm trying to combine MIGS and omnipay.

Steps
1. Download omnipay 2.5 https://civicrm.org/extensions/omnipay-multiprocessor-extension

sudo -u apache wget https://github.com/eileenmcnaughton/nz.co.fuzion.omnipaymultiprocessor/archive/2.5.zip
sudo -u apache curl -s http://getcomposer.org/installer | sudo -u apache php
sudo mkdir /usr/share/httpd/.composer
sudo chown apache /usr/share/httpd/.composer

Unzip into files/civicrm/ext
Require MIGS: sudo -u apache ./composer.phar -v require omnipay/migs

I had to do a bit of hacking about. php7.0 and some dependency troubles.

Edit vendor/omnipay/tests/composer.json - make dev

sudo -u apache mkdir /srv/web/docdownload.com.au/web/files/civicrm/ext/nz.co.fuzion.omnipaymultiprocessor-2.5/vendor/sebastian/global-state/src
sudo -u apache mkdir /srv/web/docdownload.com.au/web/files/civicrm/ext/nz.co.fuzion.omnipaymultiprocessor-2.5/vendor/sebastian/comparator/src
sudo -u apache mkdir /srv/web/docdownload.com.au/web/files/civicrm/ext/nz.co.fuzion.omnipaymultiprocessor-2.5/vendor/sebastian/diff/src/

Result

Using version ^2.2 for omnipay/migs
./composer.json has been updated

The omnipay extension is registered.

Registering MIGS with omnipay. I want an on-site, pass by xml processor.

I created a file Metadata/omnipay_Migs_TwoParty.mgd.php, cleared caches.  I tried registering the payments processor and cannot see it in the list. Administration > System Settings > payment processors - civicrm/admin/paymentProcessor.

What goes into the metadata file omnipay_Migs_TwoParty.mgd.php? Has anybody created one before? Is there a document reference? Reverse engineer? Debug until it works? I created the minimum.

 return array(
   array(
    'name' => 'OmniPay - Migs_TwoParty',
    'entity' => 'payment_processor_type',
    'metadata' => array(
  ),
  'params' => array(
    'version' => 3,
    'title' => 'OmniPay - Migs_TwoParty',
    'name' => 'omnipay_Migs_TwoParty',
    'description' => 'Omnipay Migs_TwoParty Onsite processing',
    // DO NOT CHANGE: Labels are used as Omnipay gateway properties.
    'user_name_label' => 'Api Key',
    'password_label' => 'Password',
    // When ready we need to add signature_label & figure out how to pass through to tpl.
    //'signature_label' => 'Public Key (if wishing to use Client Encryption - recommended)',
    'class_name' => 'Payment_OmnipayMultiProcessor',
    'url_site_default' => 'http://unused.com',
    'url_api_default' => 'http://unused.com',
    'url_recur_default' => 'http://unused.com',
    'url_site_test_default' => 'http://unused.com',
    'url_recur_test_default' => 'http://unused.com',
    'url_api_test_default' => 'http://unused.com',
    'billing_mode' => 1,
    'payment_type' => 1,
    'is_recur' => 1,
    ),
  ),
);

I got this to work with the following meta-data file. omnipay_Migs_TwoParty.mgd.php. Since the field in the code is merchantAccessCode I changed the label for passwords to "Merchant access code'. Both the debugger and the error message show this.

return [
 [
   'name' => 'OmniPay - MIGS',
   'entity' => 'payment_processor_type',
   'params' => array(
     'version' => 3,
     'title' => 'OmniPay - MIGS',
     'name' => 'Migs_TwoParty',
     'description' => 'Omnipay MIGS',
     // DO NOT CHANGE: Labels are used as Omnipay gateway properties.
    'user_name_label' => 'Merchant Id',
    'password_label' => 'Merchant access code',
    'signature_label' => 'Secure Hash',
    'class_name' => 'Payment_OmnipayMultiProcessor',
    'url_site_default' => 'http://unused.com',
    'url_api_default' => 'http://unused.com',
    'url_recur_default' => 'http://unused.com',
    'url_site_test_default' => 'http://unused.com',
    'url_recur_test_default' => 'http://unused.com',
    'url_api_test_default' => 'http://unused.com',
    'billing_mode' => 1,
    'payment_type' => 1,
    'is_recur' => 1,
   ),
 ]
];


Error when trying to create a public form using a profile with a Grant field I am trying to create a publicly accessible grant application page using a CiviCRM profile with form fields for Grant record information.

To test this, I created a profile with only one Grant-record field in it.

When I then create a Wordpress post using the shortcode for the profile, it gives this error: "Profile search, view and edit are not supported for Profiles which include fields for more than one record type."

If I change the form to have just one field of some other type of field (with no Grant field), for example, Individual - Birth Date, then it works just fine.

Does anyone know how to fix this?

You'll need the Grant Application Pages extension to do what you want.  I believe Caldera Forms CiviCRM  will also do the trick, and give you some more flexibility to boot - but I'll admit I haven't tried that approach.


How do I get my contribution form fields on the same line I have bootstrap Joomla theme and it is changing the format of form fields. I understand that this is a CSS issue but my question is how can I get my live contribution page to look like the test page within civicrm?

I'm still finding my way around civicrm so it looks like no style was applied to civicrm or the template css file takes precedence. I used some of the style setting from civicrm.css in the custom css section of the template and this fixed the issue. There is problem a cleaner way to use the civicrm style sheet but for now this worked for me.


Can one show participantID on event reminder? We're intending to use an event's participant ID as a pseudo-registration code, i.e. a quick way for us to correlate who shows up to events. Because of that, we are asking our event participants to know their participant ID when they arrive.
So far, we've adapted the ThankYou.tpl event registration confirmation page to show the user their participant ID by adding the following:

{ts 1=$participantIDs.0}Your registration number is: %1{/ts}

and we've adjusted the template for the event registration email to show $participantID as well (inside Mailings -> Message Templates -> System Workflow Messages -> Events - Registration Confirmation and Receipt (on-line)).
Now, we'd like to add that value on to a reminder message. We've set up the reminder template under Mailings -> Message Templates -> User driven messages and are able to get the reminders to send correctly, but it's not clear how to get the participant ID to show up. It's certainly not listed within the available tokens.
Is there a way to add a participant id to a template there? Can I link participant_id to the available tokens in some way?

Unless writing an extension implementing token processor its not possible to fetch the participant id in reminders.
If you familiar with smarty and the contact will have only one participant for a event than you can try below snippet in your reminder message template
{capture assign=eventID}{event.event_id}{/capture}
{capture assign=contactId}{contact.contact_id}{/capture}

{crmAPI var='result' entity='Participant' action='getvalue' sequential=0 return="id" event_id=$eventID contact_id=$contactId}
{foreach from=$result.values item=participant}
 Participant Id - {$participant.id}
{/foreach}


after upgrade, can't edit Contact Details fields (Custom Addressee and de-selected subtypes errors) I've just updated a Joomla 2.5.28 site from an older version of CiviCRM (4.4) to the latest 4.7.29.  Now I can't edit any of the fields under the "Contact Details" pane for existing records.

There are two errors:

When editing these fields for contacts that have custom subtypes, a popup appears saying "One or more contact subtypes have been de-selected from the list for this contact. Any custom data associated with de-selected subtype will be removed as long as the contact does not have a contact subtype still selected. Click OK to proceed, or Cancel to review your changes before saving."
For all contacts (including custom subtypes from item 1 above), saving doesn't work and throws this error:  "Custom Addressee is a required field if Addressee is of type Customized."

It's also interesting that I can create NEW records of contact subtypes, but get the errors again if I try to update the Contact Details of the new record.

I found this post (Why after importing contact records were Addressee field values set to "Customized" for records where Custom Addressee had a null value?) which seems to address issue #1, but I'm a bit stumped as to issue #2.  And I didn't want to try the correction suggested in this post until I knew if the two issues could be related.

Site details:
Joomla 2.5.28
CiviCRM 4.7.29

I feel this issue is documented  and fixed at CRM-21180. You can try by applying patch or wait for 4.7.30 release.


setting path and url for [civicrm.files] after much digging around I have discovered that  [civcicrm.files] is set incorrectly for some reason during install.

i'm hoping this will go some way to explaining the odd and inconsistent system status behaviour i am seeing around system status messages

I've found a post here
Set [civicrm.files]
explainig how to set the variable during via the civicrm.settings.php file

still doesn't seem to have fixed my problem though so I am wondering if I have set the values correctly.

Do I need a '/' on the end of either / neither / both path and url?

You can refer the paths by clicking on the question mark at top of page on Settings - Resource URLs which says

  These settings define the URLs used to access CiviCRM resources (CSS
  files, Javascript files, images, etc.).

  You may configure these settings using absolute URLs or URL variables.

as shown in the image below.


Is CiviCRM SAML 2.0 compatible? I would like to know if CiviCRM conforms to the SAML 2.0 standard for user authentication

Thanks

Norma Tovey

CiviCRM itself does not have user authentication. CiviCRM runs within a CMS: Wordpress, Drupal, Joomla or Backdrop. So IMO the question should be: does the CMS you will be using conform to the SAML 2.0 standard?


Is there CiviContribute API documentation? I'm wondering which CiviContribute API calls are required to make a donation happen. For example, I'm assuming that I don't need to make any calls to PayPal or Stripe, because the CiviContribute API will do this under the hood.

I'm using the REST api, but probably general CiviContribute API documentation would suffice.

Is there any documentation of the process for making a donation with the API, and which calls are needed in a typical scenario?

I do not know what you want to achieve exactly, but the API that I use is called Contribution. It creates a contribution in CiviCRM but it does not automatically make calls to PayPal or Stripe.

And I am glad it does not because most NGO's in my corner of the world (Northern Europe) hardly use PayPal and have never heard of Stripe. They want all their payments processed with SEPA, which probably you never heard of.

Documentation on the API can be found here: https://docs.civicrm.org/dev/en/latest/api/


How to search for contacts not in a group through the Search Builder I'm trying to search for contacts who do NOT belong to a given group. I'm using the Search Builder.

For Record Type, I select Contacts. Then for Field, I select Group(s). Then I select the ≠ operator. And finally I select the group name.

The problem is that it adds a search criteria that I didn't specify. After making the search, it displays my search criteria as:

Group(s) ≠ MyGroupName ...AND...
Group Status "Added"

I did not specify any group status and in this context it doesn't make sense for the Search Builder to automatically add it. So, am I doing something wrong or does this seem like a bug?

You could also use the custom search Include/Exclude, which lets you search for contacts who are not member of a group


CiviDiscount Automatic Discounts Not Working on Events Using CiviDiscount 3.3, CiviCRM 4.7.1.9 and Wordpress 4.7.5.

When attempting to create an automatic discount for members of type, with status new, current, and grace period or even any current status, I am unable to get a discount to automatically appear on any membership or event pages. The code I created works, but won't automatically apply for members. This also means anyone with the code, even non-members can use it. What am I doing wrong?

Your setup looks correct. This should provide a 10% discount to members. They must be logged in to their WordPress account in order to receive the discount otherwise the system will not recognize them as members.

I recommend using a randomly generated code. This makes it difficult for random visitors to guess the code.


Bulk assign contribution page based on contribution type? Issue: We migrated about 5000 contacts from one CRM to CiviCRM.

The organization required historical data to be moved over, but also changed their membership pricing scheme which has been resolved with price sets + custom contribution page.

Members migrated over need to be assigned to this new contribution page so they can renew online.

All their contributions involving membership was tagged as "Member Dues". Unfortunately, we cannot seem to bulk assign this to the new contribution page.

Any ideas?

Have you tried exporting those member dues contributions (including their contribution IDs as well as their Civi contact IDs), adding a column for contribution page ID, and importing that information back in as an update of the existing contributions?  If you've not tried that, it might be worth testing with a small subset of those member payments to see if you get the results you expect as far as updating the information.

Lesley


Webform contribution for multiple items? In a webform, I want to offer a selection of prices and quantities (like a simple price set).

For example:

  Thing A  $10  [quantity box]
  Thing B  $20  [quantity box]

I've added a Contribution on the webform and ticked the box to add the contribution amount to the form. It seems like it should just be a matter of changing the widget type for the contribution amount to the right thing ... but I haven't found the right widget :-(

'Select options' lets me select 0/1 of each item, but not a user-entered quantity.

What widget type will do that?  Alternatively, any other suggestions for structuring the webform to achieve this?

[I want to use a webform for its other features that I don't get with a priceset and contribution page.]

(Drupal 7, CiviCRM 4.6.18)

How about something like this:

Finite quantities for each item (if you have too many - make them select lists).
Calculate the Contribution Amount w/ some jQuery - [just like on CiviCRM contribution pages] - OR - if you don't have too many combinations - you can do this via Webform Conditionals - so no code required.


Reports show 4 warnings after upgrading from 5.4 to 5.10 I run Civi on Drupal. After upgrading from 5.4.0 to 5.10.0, any report I open shows 4 warnings at the top:

Warning: Illegal string offset 'attr' in HTML_QuickForm_advmultiselect->toHtml() (line 807 of /home/tamera/www/dev/sites/all/modules/civicrm/packages/HTML/QuickForm/advmultiselect.php).

Warning: Illegal string offset 'text' in HTML_QuickForm_advmultiselect->toHtml() (line 808 of /home/tamera/www/dev/sites/all/modules/civicrm/packages/HTML/QuickForm/advmultiselect.php).

Warning: Illegal string offset 'attr' in HTML_QuickForm_advmultiselect->toHtml() (line 821 of /home/tamera/www/dev/sites/all/modules/civicrm/packages/HTML/QuickForm/advmultiselect.php).

Warning: Illegal string offset 'text' in HTML_QuickForm_advmultiselect->toHtml() (line 822 of /home/tamera/www/dev/sites/all/modules/civicrm/packages/HTML/QuickForm/advmultiselect.php).

Any ideas?

These are fields that have been phased out. Deleting these reports and creating them anew from the core report templates will have solved the problem.


How to prevent public use of profile, while still allowing use via HTML snippet I would like to disable access to specific profiles via their public URL, while still allowing HTML snippet access, i.e. I'd like to allow POST only. Is this possible?
We have fake spam contacts entering our database from https://secure.wildsight.ca/civicrm/profile/create?gid=56&reset=1. This profile is only used via HTML snippet on our other website and there is no need for it be available at this URL.
Disabling use of the profile for Standalone Form or Directory prevents any submissions from the snippet. ReCaptcha doesn't seem to be preventing these submissions.

You could probably do it at the webserver level, e.g. in apache using <LocationMatch> and then <Limit>. Untested, and you might have to fiddle or put it in the right place for clean/non-clean urls, or for specific gid params:
<LocationMatch "^/civicrm/profile/create">
  <Limit GET>
    # allow just my own IP
    Require ip my.own.ip.address
  </Limit>
</LocationMatch>


Call to undefined function getRequiredMarker() - CiViCRM I have setup CiViCRM with Drupal. Setup was completed successfully without any errors.

After Login into Drupal as Admin, while I'm visiting new event create page  using menu -> Events -> New Event, I got blank page nothing else.

When I checked the error log it says:

PHP Fatal error:  Call to undefined function getRequiredMarker() in /var/www/html/xx-civicrm/sites/default/files/civicrm/templates_c/en_US/%%89/896/89673E6E%%ProfileTemplates.tpl.php on line 64, referer: http://xxxxxxx.com/civicrm?reset=1

But I found that function "getRequiredMarker()" in a js file:

/sites/all/modules/civicrm/js/view/crm.designer.js

So what is the issue here? What is the solution here?

Any help would be appreciated. Thanks.

I found the issue:

It is because of asp_tags extension. Need to turn off it.

Either turn off it from php.ini file(globally disable)

OR

by putting this line in .htaccess file(locally disable)

php_flag asp_tags off


CiviCRM Integration wtih WhatsApp CiviCRM SMS integration is a powerful feature. However, with many people moving to use instant messaging services like WhatsApp, has there been any move to integrate CiviCRM with and instant messenger, in particular, WhatsApp? Our organization has recently moved its bulk SMS database over to WhatsApp, as 90% of our members use WhatsApp. Being a non-profit, we gain from not having to pay for sending bulk SMS's.

They haven't been any to my knowledge, but assuming whatsapp as an api to post messages, it shouldn't be too complicated to implement.

If you are interested, you could write an extension and use the searchtask hook to add a "send via whatsapp" action
http://wiki.civicrm.org/confluence/display/CRMDOC/hook_civicrm_searchTasks


Problem with new Pay Later contributions showing as Completed I'm a very new CiviCRm user. And pretty new to WordPress so I apologise if this is a user error. I'm doing suitability testing.

WordPress 4.8

CiviCRM 4.7.20

I have created a Contribution page to take memberships. I believe I've selected the options I need for membership types and pricing.

At the moment, I ONLY have a Pay Later option. I haven't tried yet with PayPal or similar.

So in my test I create a new user, put in the information needed. And submit it.

I then go and find that user, and look at the relevant contribution. It shows as completed, not pending.

Obviously this is incorrect.

Any thoughts on what I'm doing wrong?

Thanks,
Norman

It depends highly on the membership amount you display on the contribution page. If the amount is 0, there is no pending state needed and contribution directly gets set to Completed.

So, I think you should check the Minimum Fee set for the membership type you've selected on this page.


My hosting company does not support SUPER privilege - can I use CiviCRM with them? I finally after a week and 3 tickets got CiviCRM/Joomla to install on my Startlogic hosted server, but I can't add anything to the database.  The final response I got from Startlogic support was "Hello Michael, We apologize for any inconvenience this has caused you. It looks like the extension which you are trying to install requires super privilege which is not supported. Also, we do not support binary logging which the extension requires. Thus, you are receiving the error message. You can try using any alternative extension and check."  At this point I think they are blowing me off and about to go through the headache of switching hosts.
Is there anything I can do get CiviCRM to work on the Startlogic server, as they seem not to want to help.

There are only two scenarios in which CiviCRM requires the SUPER privilege:

You're using a very old version of MySQL.  Versions of MySQL 5.1.6 and higher support the TRIGGER permission.  Before that, SUPER was necessary.  MySQL 5.1 reached its "end of life" at the end of 2013.  No modern server should have it installed.
You're attempting to use the advanced logging feature: Administer menu » System Settings » Misc, Logging set to Yes.  If you need this feature, you really need a VPS.

All that said - @Christia is right.  StartLogic is entry-level hosting.  CiviCRM has heftier requirements than entry-level hosting gives you.  Expect poor performance unless you move hosts.


Why would two distinctly separate custom fields share the same options? Why would two distinctly separate custom fields {Constituent Info and Contribution Info} share the same options? How do I go about separating them? If I try to delete any option I get this notification.

These Multiple Choice Options are shared by the following custom fields: Marital Status, Appeal

Civi allows you to set the same Options to be available on multiple fields. You do this by selecting an existing set of Options when creating the field, rather than creating a new set.

If you require different options for the second field then yes set that field to "Create a new set of options"

However that will mess with any existing data you may have. I would suggest you create a new Field with the new set of options, then, if required, you may be able to figure out how to review the existing data and use Batch Update via Profile to add the relevant data to the new field.


Not able to print contribution invoice CMS: Drupal 7

CiviCRM: 4.7.31

"CiviCRM: access Contact Dashboard" permission is set for authenticated user and logged in user has "CiviCRM: view my invoices" permission also.

User can access contact dashboard page with buttons to print invoice for contributions but get access denied message unless "CiviContribute: access CiviContribute" permission is also assigned to user role.

To print invoice the user should either have access CiviContribute or view my invoice permission. "CiviPay: access CiviPay" permission doesn't come with CiviCRM install. I feel CiviPay extension might be conflicting with Print invoice as the extension may be using same url as of print invoice i.e civicrm/contribute/invoice.

Pradeep


How to save email adresses having weird, rare format? One of our contacts has a weird, rare email format:
name-@web.de

I did not know, that having a - in front of @ is even possible. It is the correct adress and the adress reaches its owner. Regardless of how clever it is, having such an adress, I do have the problem: I cannot save it in the contact field. An error message: invalid email adress appears.
Does anybody know how to force civicrm to accept the weird email format?

using:

CiviCRM 5.31.0.

Looks like the email validation inside CiviCRM does not like that pattern. If it is a valid email address that validation would have to be changed. You can do that yourself with a PR (https://docs.civicrm.org/dev/en/latest/core/contributing/) or at least raise it as an issue (https://docs.civicrm.org/dev/en/latest/tools/issue-tracking/#guidelines). Thanks!


Errors Tracking Opens We are having an issue with tracking opens for mailing. Click throughs track fine but opens do not. I inserted the URL for the tracking image into my browser and got a 500 error. I get the following in the PHP error log:

 [19-Feb-2020 16:37:18 UTC] PHP Fatal error:  Uncaught Exception: Function "is_admin()" is missing, even though WordPress is the user framework. in /home/mysite/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/Base.php:264
Stack trace:
#0 /home/mysite/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/System.php(203): CRM_Utils_System_Base->theme('__construct(-19, 16, Array, 'INSERT INTO civ...')
#5 /home/mysite/public_html/wp-content/plug in /home/mysite/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/Base.php on line 264

We get the following in the CiviCRM log:

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

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_mailing_event_opened (event_queue_id , time_stamp ) VALUES ( 34 ,  20200219164337 )  [nativecode=1054 ** Unknown column 'j.start_date' in 'where clause']
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_mailing_event_opened (event_queue_id , time_stamp ) VALUES ( 34 ,  20200219164337 )  [nativecode=1054 ** Unknown column 'j.start_date' in 'where clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_mailing_event_opened (event_queue_id , time_stamp ) VALUES ( 34 ,  20200219164337 )  [nativecode=1054 ** Unknown column 'j.start_date' in 'where clause']"]
)

Site is WordPress 5.3.2, CiviCRM 5.22.1

The "DB Error: no such field" bit in your error message is your key clue.

The missing field is listed as "Unknown column 'j.start_date' in 'where clause'", but it's not showing any more of the sql to know which table that comes from.

I dug through some code, and I'm pretty sure it's supposed to be coming from the civicrm_mailing_job.

So - either that table isn't getting joined properly (likely a code issue), or else that field is missing in that table in your instance.

Since 5.22.1 is fresh out the door, it could be a code issue.


Edit Multi-Value / Multi-Record Fields in Profiles I really need to allow WordPress users to submit their work experience via a page and shortcode... I've read here that it's not possible to allow a multi-value set of fields to be edited via a profile (being embedded into a WordPress page): Multi-value fields in profiles - how to?

...but these docs show it happening with a really tempting screenshot (search for "work experience" to find the section): http://book.civicrm.org/user/current/organising-your-data/profiles/

...so I wondered if it was now possible somehow or if this documentation was incorrect? Perhaps it's only possible with Drupal? We're stuck with Wordpress atm.

****** EDIT ***** Re-created issue on http://wpmaster.demo.civicrm.org/**

To recreate this issue, create a multi-value custom field group, then set up a profile and add the fields (following documentation). Try to test the profile in Create Mode, the error is thrown:-

"Sorry but we are not able to provide this at the moment.
The requested Profile (gid=14) is not configured to be used for 'Profile' edit and view forms in its Settings. Contact the site administrator if you need assistance."

PHP Warnings:-
Warning: Invalid argument supplied for foreach() in /srv/buildkit/build/wpmaster/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/CustomOption.php on line 84 Warning: Invalid argument supplied for foreach() in /srv/buildkit/build/wpmaster/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/CustomOption.php on line 84 Warning: Invalid argument supplied for foreach() in /srv/buildkit/build/wpmaster/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/CustomOption.php on line 84 Warning: fopen(/srv/buildkit/build/wpmaster/wp-content/uploads/civicrm/ConfigAndLog/CiviCRM.8ae48cedfddd4cf1265fa95ce1274dd9.log): failed to open stream: Permission denied in /srv/buildkit/build/wpmaster/wp-content/plugins/civicrm/civicrm/packages/Log/file.php on line 216 Warning: fopen(/srv/buildkit/build/wpmaster/wp-content/uploads/civicrm/ConfigAndLog/CiviCRM.8ae48cedfddd4cf1265fa95ce1274dd9.log): failed to open stream: Permission denied in /srv/buildkit/build/wpmaster/wp-content/plugins/civicrm/civicrm/packages/Log/file.php on line 216

Seems the only workaround is to use the "Edit" mode for the profile, rather than "Create" mode.

The limitation being this will only work for logged in users.


How do I sort the bookkeeping report by date? How do I sort the bookkeeping report by date (descending)?

I have sorted by contribution ID but this isn't exactly by date and when you are looking for a transaction it is easy to assume that it hasn't been made when scanning by date, especially if it is on the next page.

Can export and sort the exported data, but this makes people think the report is not working.

It is #20 on the civicrm demo site dmaster.demo.civicrm.org/civicrm/report/instance/20

It may be worth trying Fuzion's Extended Report extension which offers other reports eg "Bookkeeping with extra fields "


How can I easily identify recurring contributions that failed to be recorded or failed to occur Anyone have a good recipe or a report for finding folk who had a recurring payment due in say the last 2 weeks but for whom no contribution was received?

I can see ways to do this with Smart Groups and Include/Exclude or via Drupal Views - but thought there might already be a better solution - looks like iATS have an email notification (nice)

Here is a View (well a pair of them actually)


Permissions for new files under tempates_c/en_US created using 751 permission which does not allow write for group After templates_c and en_US files are removed/deleted, Civi will recreate new folders and files.  (This is recommended when upgrading Civi).   Running as Apache these folders/files are then re-created with Apache as owner and group along with a 751 permission

This creates other problems.  Drush running as a different user (other than Apache) can be denied access. Changing owners via other commands can cause other failures - as only Apache as owner has write access.

If these permissions were set as 775 (or 771), the problem would not occur.  Is there a reason why these are set to 751?    Where is this permission defined when new folders and files are created?   There are workarounds but but have other consequences that are not desirable.  (Other SE postings suggest things like 777 permissions - also not good.)

I always # sudo -u apache drush [command] when running drush anyway. That way if drush creates new files or directories they JustWork(tm) in drupal.


Can a contact be registered for an event through another event After some wrangling with ideas on how to make registration easier for participants I've come up against a problem and wonder if CiviCRM can even be used to fix the issue without a tremendous amount of custom coding. I'm looking for ideas on how to overcome the issue.

Brief site description
Our site runs 10 events a year for two groups: Students and Instructors. Members from both groups log in and sign up for events they will attend. Instructors don't pay but Students do. In fact, Students receive a discount if they sign up for more than one event. If they sign up for a single event early, they get a discount but early and 'bulk' discounts are not combined.

Easy Registration
Rather than create 20 events (10 for students, 10 for instructors) I create 2 'super registration' events (one for students, one for instructors) that allows registration to any or all of the events. In the event I have a checkbox list with 5 choices, of which any number of choice can be selected.

Event 1: Apr 29-30 Event 2: June 1-2, Event 3: July 10-11 etc . . .

Pricing is listed as:

ONE Event: $100
TWO Events: $180
THREE Events: $270
 . . . .

Problem 1: I cannot find a method to force the number of event choices to the correct corresponding price. For example, Student picks Event 1 and 3, but then only picks ONE Event for pricing 'accidentally' paying for one, rather than two events. This requires 'administrative intervention' in the form of an email (Dear user so sorry to see you can't count. Pay for the correct number of events or we're only signing you up for the number you paid for). Be great if I could somehow count the number of selected events and force that price.

Is there a way to do this?

Problem 2: While using CiviReports and Excel is fine to manage the two super events I was wonder if I could use CiviCRM to manage all events. I was thinking, create my user accessible 'super event' but also create admin-access only events to track which users are actually going to which event. For example:

Event List
Student Registration event - allow users to sign up for any number of events
Student Event 1 (for admins only) - Track whose coming to event 1
Student Event 2 (for admins only) - Track whose coming to event 2
Student Event 3 (for admins only) - Track whose coming to event 3

dito for instructors

Is there a way to do this?

I've considered the shopping cart but it still forces users to pick each event, put it in a cart, pay and the bulk pricing becomes tricky as the percentage of discount changes depending on number of events picked. The shopping cart is still a bit creaky too. The 'super event' is pretty popular with users so I'd like to keep it.

I certainly would investigate the CiviDiscount extension: https://civicrm.org/extensions/cividiscount

It might already bring functionality that would be close to what you need, if not... it has it's own API, so a custom extension that would meet your needs would be smaller with CiviDiscount then without.


Deleting email addresses from list Some people have asked to be removed from our email list.  How do I do that? I've tried just deleting the name but I can't make it permanent

Several interpretations here.

If 'remove from email list' is the equivalent to 'unsub from group x which is used for a Mailing List' then you should be able to 'remove' them directly from the group.

If it means 'stop sending me any bulk mailings' then you can set their email to "on hold"

if it means 'never ever email you' you can set their record to Do Not Email which should stop even one to one emails from the system


Note Field Appearing and Dissappearing When entering a new contact, I have an option to enter a Note in the editing mode. However, if I don't use that field when I enter the contact for the first time, the next time I open that contact in the editing mode, I don't see that field - the only place I see it is in the Notes Tab in the View Mode. Is there some option to always keep this field in the both modes?
Also, is there an option to see Notes in the Summary Tab or only in the Notes Tab?
Thanks!

What you're seeing is correct. The reason is mostly because you can have multiple notes, so it gets its own tab.

If you only want one "note" per contact and want it to always appear, you can create a custom field, e.g. called "comments" (to distinguish from notes), and then it will appear on the summary tab and in edit mode in an accordian section.


Status of form/profile usability Could someone give an update on the status of creating more usable form/profiles without using Drupal's Webform?  (Especially iin regards Wordpress but preferable CMS agnostic)

I'm certain I'm not the only WP user struggling with form creation that is annoyed with the 'use Webform' response to nearly every form/profile question. It seems obvious to me that this is a major usability issue with CiviCRM that has been avoided for years due to the crutch of Webform.

And yes, I have heard also of a mysterious gravity forms plugin (with a big annual fee to use it), but this just perpetuates one of the main flaws in your otherwise amazing system.

/rant.

More usable forms/profiles is a major goal of CiviCRM 5.0.

Creating a form creator that's flexible enough to meet the varied needs of many constituencies is a lot of work.  Unfortunately, while CiviCRM is free to use, it's not free to write.  Most of the folks who complain aren't willing to fund (or do) the work.  Using Webform is certainly a crutch, but in a world without unlimited developer resources, you can understand why someone wrote the CiviCRM-Webform integration rather than try to do it all from scratch.

I have no way of knowing which camp you fall into - but for everyone with this same question who hasn't contributed, please consider the many ways in which you can help make more usable forms/profiles a reality.


Unable to schedule ANY reminders I am not able to schedule any reminders.  This happens whens pretty much everywhere.. whether I'm trying to set this up for Events, or even generally in CiviCRM > Administrator > Communications > Schedule Reminders

Anyone have any idea what is going on?  This is the only error I get..

FYI:  Powered by CiviCRM 5.6.0

  Error: Call to undefined method
  CRM_Admin_Form_ScheduleReminders::setContext() in
  CRM_Admin_Form_ScheduleReminders->buildQuickForm() (line 69 of
  .../sites/all/modules/civicrm/CRM/Admin/Form/ScheduleReminders.php).

I found the issue..  I tracked it down to the fact that I'm using custom templates to modify CiviCRM.

the civicrm/CRM/Core/Form.php file has been updated to a new version while my custom version I had in the Custom Template Directory was still using the older version.

I synced them up and everything is working fine now.


Error: Stripe.js token was not passed! Report this message to the site administrator" for Stripe extension I have following configuration: CiviCRM version - 4.6.2 Stripe version: 1.9.1

I have configured stripe on site and using it on contribution page and trying to use with "PayPal payment processor" and "Pay-later option".

After submitting the contribution I have getting the error as follows:

"Error: Stripe.js token was not passed! Report this message to the site administrator"

Is above error getting due to compatibility issue? Because on https://civicrm.org/extensions/stripe-payment-processor/ in this page compatibility for stripe with CiviCRM version for 4.4 and 4.5 is mentioned

Please guide!!!

I have this problem also.
It's a known issue with version 1.9.1 You can view the Github thread here.
The developer says his latest commit may have  fixed the issue.


Only admin can access event registration page I've created a view with a block of upcoming civicrm events with links to the online registration pages. Only the administrator can get to the registration page. Anonymous and authorized users get this message:

"Sorry but we are not able to provide this at the moment.
XML data could not be loaded. Make sure you specified the correct path.

Return to home page."

Anonymous and authorized users have permission for
CiviEvent:register for events, CiviEvent:view event info , CiviCRM:access all custom data.

The CiviEvent is setup to allow online registration.

There are some steps in the original comment you might want to do first but this link has the solution that worked for a few people.   https://forum.civicrm.org/index.php?topic=23855.msg100253#msg100253

Try:

rm -rf sites/all/files/civicrm/ConfigAndLog/

CiviCRM will rebuild the ConfigAndLog folder.

-Steve


How is case end date set? I've just found this on one site. I have some (not all) cases of a given case type. There case status is set to a "closed" status. But the case does not have an end date.

I cannot find a way to update the case end date from the manage case screen.

This seems to effect cases where status was changed between July 17 and October 18
Cases amended before and since have an end date recorded

Cases with other closed statusses all have end dates as expected.

I guess I can find the related case status change activities, and then manually adjust the case end dates from cpanel (only a dozen or so cases affected).

Just left scratching my head, is all.

I think if you resave the status it will update the case end date. On Manage case screen click on pencil icon just next to 'Status: Resolved'. Save the form without doing any changes.(Please check the activity date time field under Activity Details  if it has correct date).

Cheers

Pradeep


Trying to run Civi cron Jobs using Drupal cron? I'm running Civicrm 4.4.7 on Pantheon.

I added the module called 'Elysa Cron' to my Drupal site which allows the option of running Civi cron whenever Drupal cron is run. The status report in Drupal shows that Civicron is running but nothing happens in Civicrm.
Any idea what can be the issue?

Just to summarize all the places to look. If you've chosen to try to run CiviCRM cron from Drupal, you need the civicrm_cron module. Then in the Elysia Cron settings: admin/config/system/cron/settings take a look at the settings for the civicrm_cron job and make sure it's enabled. It's probably called: civicrm_cron_cron. Though if you're seeing civicrm_cron in watchdog then it's being called.

The next step is to check that you can manually run cron by executing the cronjob by entering the url for the cronjob in the url (with the site key set in civicrm.settings.php), by using a drush command, or by clicking the Execute Now button next to the scheduled job in Administer > System Settings > Scheduled Jobs. Make sure those scheduled jobs are enabled and have a frequent enough schedule. (More info here: http://wiki.civicrm.org/confluence/display/CRMDOC/Managing+Scheduled+Jobs#ManagingScheduledJobs-Command-lineSyntaxforRunningJobs).

If the scheduled jobs are working but still not being called from Drupal, then you may want to see if you're able to get them to run via third-party cron service such as EasyCron and create a cronjob such as
*/15 * * * * wget -O - -q -t 1 'http://mysite.org/sites/all/modules/civicrm/bin/cron.php?name=username&pass=password&key=site-key'.

I'm also running CiviCRM 4.4.14 on Pantheon and I'm using an external cronjob to call Elysia Cron and it's triggering CiviCRM cron. So I know that in general it should work.


iATS Extension Working, but Throwing Errors iATS 1.5.3 is throwing the following errors (1.5.0 was too) on Civi 4.7.10 running under Drupal 7.50 on CentOS:

Notice: Undefined index: config_backend in _iats_civicrm_domain_info() (line 202 of /home/ourbase/public_html/wcc/sites/default/files/civicrm/upload/com.iatspayments.civicrm-1.5.3/com.iatspayments.civicrm-1.5.3/iats.php).
Notice: Undefined index: config_backend in _iats_civicrm_domain_info() (line 202 of /home/ourbase/public_html/wcc/sites/default/files/civicrm/upload/com.iatspayments.civicrm-1.5.3/com.iatspayments.civicrm-1.5.3/iats.php).
Warning: simplexml_load_file(http://wcc.ourbase.us/sites/default/files/civicrm/upload/com.iatspayments.civicrm-1.5.3/com.iatspayments.civicrm-1.5.3/info.xml): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in iATS_Service_Request::iats_extension_version() (line 728 of /home/ourbase/public_html/wcc/sites/default/files/civicrm/upload/com.iatspayments.civicrm-1.5.3/com.iatspayments.civicrm-1.5.3/CRM/iATS/iATSService.php).
Notice: Trying to get property of non-object in iATS_Service_Request::iats_extension_version() (line 729 of /home/ourbase/public_html/wcc/sites/default/files/civicrm/upload/com.iatspayments.civicrm-1.5.3/com.iatspayments.civicrm-1.5.3/CRM/iATS/iATSService.php).

Transactions seem to go through, so my focus is on getting these errors to not display. Either by correcting the errors or suppressing the notifications. In regards to the latter, I have error reporting turned off everywhere I'm aware of (php settings in cPanel, civicrm itself)

To suppress notices/warnings on Drupal go here:
/admin/config/development/logging

and hit: none
(you'll want 'none' on any production site);

Would you please open up on issue in our GitHub queue:
https://github.com/iATSPayments/com.iatspayments.civicrm

paste in your notices - and also let us know exactly what type of transaction you're executing when these notices occur? Frontend/backend; Credit Card; ACHEFT; SWIPE; one-time/recurring; Contribution; Membership or Event etc.


LMS with CiviCRM/drupal integration? Looking for recommendations on Learning Management Systems (LMS) that work with drupal/CiviCRM. Thanks.

It's difficult to answer your question without more details about what KIND of integration you're looking for, but I can give two answers:

If you're looking for a Learning Record Store (LRS), a native Drupal LRS exists, and CiviCRM integration for it exists too.
Some integration with Moodle exists via CiviMoodle - you can register someone for a CiviCRM event, and they're signed up for one or more corresponding events  in Moodle (with user creation if necessary).
There's also some custom integration for pulling grades back into CiviCRM from Moodle, but would need some love from a developer to fit someone's situation.


How can I mass edit country or city values of many contacts? In Drupal you've got something like views bulk operations and 'modify entity values' but in CiviCRM that is not available.
I have read in the documentation that this be accomplished using 'Profiles', but I find it rather difficult to understand.
Can someone please explain in simple steps, how to bulk edit the country field of multiple contacts?

Profiles are used for so many unrelated things that it's kind of ridiculous.  Here is the minimum needed to bulk edit country for a bunch of contacts.

Create a new profile.  Don't worry about any of the settings besides the name, which you might call "Country Update".
Once you save it, you'll be shown the New Profile Field screen.  For Field Name, select Contacts, then Country, then Primary (or whatever location type you prefer).  Don't worry about any other fields, and click Save.

You now have a profile with a single field in it--the field you want to bulk update.  You could potentially skip these steps by using an existing profile with Country in it.

Search for the contacts you want to update.  Check the boxes or select all records (the maximum to batch update at once is 100, and they have to be the same contact type--individuals, households, or organizations), and select Batch Update via Profile in the Actions drop-down.
Find your "Country Update" profile in the list, and select Continue.
You'll see the list of contacts and a field for each contact's country.  To set them all in one go, set the first contact's country, and then click the copy icon in the header.  That will copy all the way down the column.  Click Update Contacts, and you're done.

Once you get the gist, you can set up more complicated profiles and set multiple fields in one sitting.


Help! Multiple choice value vs lable I created a set of custom questions that are of the type multiple choice. I entered the labels like "Blue", "Green", "Orange", and left the values at 1,2,3

When I run a report in civiCRM, the column for my multiple choice question shows the label.

But, when I export the data, I see the corresponding values (1,2,3) instead of the labels.

But I need the label in my report, not the values.

Thought maybe I could just edit the multiple choice answers and copy the label text to the value column, but realized that the values 1,2,3 were being stored in the database in the custom data set civicrm_value_ table, so when I run the report in civiCRM, the column for the multiple choice question was blank (and no value was exported).

Trying to resolve this, I thought maybe I could update the column in the civicrm_value_ to store the value (replacing 1 with "Blue", 2 with "Green", 3 with "Orange").

But same result -- blank column in the report.

So question is -- how can I fix my problem? I need to update the multiple choice and copy the label to the value field, and update the existing data submitted so that it has the new text value instead of the old numeric value...

This is definitely bug in report. You can either fix the code so that it is exported as label or use the same text for label and value for the options when creating.

Eg For Blue use Label - Blue and value - Blue.


Use Create Mode Profile - Selection fields shown twice Joomla 3.5.1
Civicrm 4.7.7

I have created a custom profile, used for volunteer registration.
When the form is loaded on the joomla front end in create mode, any fields that are either multiselect, or simply select, show the selections field twice.
First field shows default as "-none-" and the second shows "Select some options".

See here for example:

Any help will be appreciated.

Thanks

This sounds like a theme related issue and if you try a more standard Joomla theme for the civicrm pages then you might find the problem disappears in which case you then know that you need to either switch theme or resolve some css issues.


Disable geocoding for contacts but not for events Is it possible to disable geocoding for contacts but still use it for events?

I am working with an organisation that has data protection concerns about sending their beneficiaries contact details to Google or Yahoo for geocoding so they would like this option turned off for contacts.  However, it would be useful to have geocoding enabled for events so that the event page can show the location on a map.

Is this possible?

Off the top of my head, I think geocoding like this is an all or nothing thing. You can manually add the lat/long to an event location, so assuming that you don't have a whole lot of events, this should be pretty much acceptable (and just leave geocoding turned off).

With that said, no real contact details are shared with Google/Yahoo. A street address is simply sent to the geocoder without any names, or anything, and the lat/long is returned. No personally identifiable info is shared.


How does CiviCRM make the link between uploaded pdfs and the database table? I want to import many pdfs into Civi and so need to make the link between the uploaded pdf and the database table.  I used the UI to upload a sample pdf (calke_walk.pdf) and looking at the db table, the field in question contains an int(10) unsigned   with a value of 8.  The uploaded pdf has a file name of Calke_walk_a0e8f5791bb72c5b53c253f4fa66fd2f.pdf    In Civi's UI the file has a url that ends with &id=8&eid=28308  The clue there is the &id=8 I guess, but is there more to this that I need to know?

Try using the attachment api, it will handle the nitty-gritty for you.


How can you set webform to create a new relationship rather than update an expired relationship when the relationship type and person is the same? Using webform to create relationships in CiviCRM. If contact 1 already has a existing relationship of the correct type to contact 2 even if it is expired it will update that relationship.

We would like to track when they had a relationship to X.
Is there a way we can enter the relationship information through a webform and have it create a new relationship with X rather than updating their previous relationship to X?

We are using Drupal 7, CiviCRM 4.7 (also happening on 4.6.25) webform_civicrm 7.x-4.16

This has been resolved in https://github.com/colemanw/webform_civicrm/pull/75

This PR provides a field on the Additional options tab under CiviCRM on your webform so you can set it on a per webform basis. If you check the box then if there is an existing relationship of the same type with the other contact then it will create a new relationship record with the new start date rather than updating the old one.


User account fields missing from create user account profile I've built two profiles to create user accounts
1) Volunteers
Adds contacts to volunteers group to sync with volunteer role
2) Volunteer Managerss
Adds contacts to volunteer managers group to sync with volunteer managers role

Both worked fine last week

Went to review the Vol manager profile today and none of the user acct fields (choose username, enterpassword etc) were visible on the profile. But the fields still showed in the volunteer profile.

Have been tinkering with profile settings, saving and unsaving. Can't make them reappear.

Both profiles have same settings:
profiles set as standalone form.
acct creation required checked.
Site visitors can create own accounts set in drupal config.
anon users can use profiles in create mode in drupal permissions.

Went to look at the volunteer profile a few minutes ago, and although it was showing user fields earlier, now the fields are missing from both profiles.

Gah!

Any help/ suggestion will be much appreciated!

drupal 7.59
civi 5.3.1

You will need to check few things

Check if the profile has create user account option enabled.
Check drupal settings if Anonymous user is allowed to create account(Configuration >> Account Settings).
Make sure your profile has email field and is primary or uses default location type


Why can't certain Civimail Mailings be reused? About half of the mailings we send are missing the "reuse" option in the action links on the "Scheduled and Sent Mailings" screen. Is this because they are sent to a search results rather than to a mailing group?

The Re-Use link does not appear if either:

The user does not have at least one of the permissions (Create mailing OR access civimail)

or:

If the mailing was created from Find Search >> Email - schedule/send via CiviMail (which creates hidden smart group) and have Unsubscribe Group field set.

Thanks

Pradeep


Contribution Page Include Profile Dropdown not displayed I am relatively new to CiviCRM and it is really great.

But now i came to the first problem, which i am not able to solve.

I want to include profiles to a contribution page and in the documentation it says there should be a dropdown box but in my case there is no dropdown as you can see on the image. I already tried to delete the cache as suggested in another post. But that didnt work neither.

Can someone help me? Am I doing something wrong or is it a bug?

Greetings and thanks in advance
Max

I solved the issue by deactivating several plugins

its probably a javascript problem

Thanks


CIVIRM adding characters to Event name on submission to Paypal, payment received but shows as "pending, incomplete payment" I'm currently running CIVICRM 4.7.4 with the most current version 7 release of Drupal and am running into an issue with event names when transmitted to Paypal. For example, the event name in CIVICRM is "3V2016 - Module 3 - Instructional Design" but it displays in PayPal as "1679-2049-3V2016 - Modul..." I tried this out by registering myself, and the same thing happened. I can't see any setting in CIVICRM to handle this and it worked fine before upgrading to 4.7.4 (from 4.6.x) so I'm not sure what's happening here.

In addition, for the particular registration in question (the real one) the payment processed through Paypal OK and we received the notification email from Paypal, but nothing from the site, and the registration shows as "Pending, incomplete transaction" Again, this worked fine before the upgrade. I saw somewhere that someone resolved this in a Wordpress installation by making the CIVICRM module's extern folder writable so I've done this (777) rather than (755) so I guess we'll see what happens with that. This is what I found in the log file in the Config and Log directory:
Mar 22 11:44:44  [info] Could not find payment processor for contribution record: 2049

Mar 22 13:45:33  [info] Deprecated: Group='Contribute Preferences'. Name='cvv_backoffice_required'. Defaults should come from metadata

Any suggestions/help would be greatly appreciated.
Thanks
Chris

"1679-2049-3V2016 - Modul..." is the contactID and contribution ID stored within civi respectively, followed by the event title, but concatenated to fit the total length allowed for the Item title.

This seems to be a change in the new version. Quite why this has changed from  just the event title, I'm not sure, but I guess its been added to help reconcile who the contribution is from and what for to make it easier to match up paypal and civi records.

The second issue is different theres a resolution coming out for this for Joomla (see https://issues.civicrm.org/jira/browse/CRM-18245) - maybe it will fix drupal as well.


Google error "This page didn't load Google Maps correctly." Got Google Geocoding working, but can't get the map to work. When I try to map a contact, a map flashes briefly but is replaced immediately by the error screen in the 1st snippet below.

The Google Cloud dashboard shows my Geocoding work, but none of my failed mapping requests are counted (2nd snippet below). The CiviCRM log (in sites/default/files/civicrm/ConfigAndLog) shows all my errors while I worked on Geocoding, but no errors since I moved on to mapping.

In case it helps anything, the relevant page source (anonymized) is listed below the snippets. Apologies I can't get the markdown any better. Any help appreciated.

Im on CiviCRM 5.21.0 and Drupal 7.69.

    function initMap() {
        var latlng = new google.maps.LatLng(27.000001,-82.000001);
        var map = new google.maps.Map(document.getElementById("google_map"));
        map.setCenter(latlng);
        map.setMapTypeId(google.maps.MapTypeId.ROADMAP);
        setMapOptions(map);
    }

function setMapOptions(map) {
    bounds = new google.maps.LatLngBounds( );

  var data = "snip
Main
snip
snip
snip
 United States

Get Directions FROM:&nbsp;<input type=hidden id=to value='snip'><input type=text id=from size=20>&nbsp;&raquo; Go";

  var address = "snip
snip
snip
snip";

      var point  = new google.maps.LatLng(27.000001,-82.000001);
var image  = null;
                            image = "/sites/all/modules/civicrm/i/contact_ind.gif";

            createMarker(map, point, data, image);
            bounds.extend(point);

            map.setCenter(bounds.getCenter());
                map.setZoom(16);

}

function createMarker(map, point, data, image) {
    var marker = new google.maps.Marker({ position: point,
                                          map: map,
                                          icon: image
                                        });
    var infowindow = new google.maps.InfoWindow();
    google.maps.event.addListener(marker, 'click', function() { infowindow.setContent(data);
                                                                infowindow.open(map,marker);
                                                               });
}

My bad. I had restricted the key based on IP address which works for server requests to Geocode, but not for JS (browser) requests to map. Changed the restriction to referrer and maps now display correctly.


How to create a report showing a subset of contacts and their tags I need help creating a custom report, please. I have approximately 15 tags (health, advice, benefits, etc), and I need to know how to create a report showing which of the contacts in my database are associated with them. I can run a report that creates the appropriate list of contacts, but it doesn't show which tags each contact has. I hope this makes sense!

Many thanks,

cdwmrcf

Follow the below step get the contacts report with tag values.

Find contact using search option. (sitename/civicrm/contact/search?reset=1)
Click on search without apply any filter if you want report for all contact.
Select the contacts and then perform the action export contacts
select this option Select fields for export and Do not merge on this page.
Now on this page you select the fields that you want in your report.

That's all.


Feature request: Make Checksum tokens easier to use Checksum tokens are arguably one of the coolest yet most overlooked features of CiviCRM.  It allows you to send targeted emails for donations, membership and event registration in a way that

increased user response/convenience because the form is pre-filled
preserves your data by reducing duplicates (when the same person enters another email and/or name)

But checksum is tricky to use, not obvious to the end user, and easily forgotten by users who know about it.  Let's make it more visible and easier.

Here are instructions I recently gave to a client who has been using CiviCRM for 9 years, and struggles to understand or use Checksum.

  Note: You can use a token to auto-fill their info on event forms! Where 'XXX' is the id# of the event, copy-paste this registration link.

  https://myorg.org/civicrm/event/register?reset=1&id=XXX&{contact.checksum}&cid={contact.contact_id}

  Highlight text such as "Register Now", click the Link icon, and paste in the above link, after replacing XXX with the real ID#.

Wow, right?  That's a lot to wrap your head around if you're a non-techie, isn't it?

Idea: when entering a link that links to your own CiviCRM (base_url) that is a registration page, contribution page, or profile, popup a "Would you like to tokenize this link?" dialogue.  It then adds the token without the copy paste.

These two extensions should assist -

https://civicrm.org/extensions/contact-checksum-ui
https://civicrm.org/extensions/fancy-tokens

The second extension provides tokens for all active contribution pages and active events with online registration enabled.


automatic word wrapping in Labels? is there a possibility to activate automatic word wrapping in Labels? If a Name to long actually it dont break the line.

Civi 4.6 Drupal

I would do this with CSS. For a text element to wrap, it needs to have a width set. Something like:

.crm-event-label {
        width: 500px;
}

(To include Custom CSS, point to a .css file via Administer > System Settings > Resource URLs)


Blank screen on install, 500 error at set_include_path() Installing CiviCRM 4.6.10 on WordPress 4.3.1, with few, if any other plugins installed.  After uploading the files and enabling the plugin, you go to the installer page, and it's a white screen.  Nothing's appearing in the logs.

Debugging in the code shows that everything executes fine until set_include_path() gets called.  Commenting out the first instance causes it to proceed until the next instance.  Finally, after commenting out several, you get an error that a class is not found, which is not surprising: you've removed the places that tell the script where to find it.

Standard cPanel-driven LAMP stack from InMotion hosting.

Why would this installation fail?

This is one of the strangest Civi911 calls we've gotten yet.  The problem definitely was set_include_path(), but it wasn't consistent with a more common problem with that--that it doesn't take effect.

We actually spent the maximum amount of time and handed it back to the client, telling him that we narrowed it down to set_include_path() but didn't know anything more, and we suggested he ask his host about it.

The host said that they have installed the cPanel/WHM Magic User Loader, which allows a user to have its own ~/php directory for PEAR modules installed via cPanel.  Enabling the Magic User Loader causes set_include_path() to fail (miserably, as we saw).  The host disabled the Magic User Loader, and the client ran the installer with no further problems.


How can I customize the default gear icon on a custom tab set? Now that there are icons on all the tab sets (awesome, btw) - I'd like to change the standard gear icon that appears on any custom contact field sets that are set to display as a tab. I didn't see anywhere in the interface that I could select a fa icon to use.

I know the hook_civicrm_tabset can be used if you've added a tab as part of an extension, you can just include the 'icon' => 'crm-i fa-yourchoicehere' line in your array. But I'm wondering how to apply that to an existing tab set.

For folks looking for a no-coding solution to this, you can use the Contact Layout Editor extension to change icons.  After installing the extension, go to Administer menu » Customize Data and Screens » Contact Summary Layouts.  You can click on the icon on a tab (see screenshot below) and it will bring up a menu of FontAwesome icons to choose from.


Help validating our proposed WordPress/CiviCRM solution! Looking for some support from those that have experience with WordPress and CiviCRM to help confirm if what I'm looking to do here is feasible!

We are a small charity and currently putting together a budget to migrate to CiviCRM as well as redesign our front-end website. We typically get around 60 - 80k views per year. We have the idea of breaking out services and giving access to volunteers that need access to specific areas (Wordpress blogging/Mailchimp for Marketing etc) but also to automate as much as possible to reduce IT maintenance overhead.

We are looking at:

WordPress as preferred chosen CMS: We find WordPress is easier to use for our volunteers than Joomla and Drupal. Plus, we are primary and information/storytelling charity so we prefer the experience for our content contributors over Joomla or Drupal.
Membership area: We need to offer a paid yearly subscription for a locked off membership area to the website. It will include downloadable assets plus specific WordPress articles only available to paying subscribers. We'd need the associated forms to collect information about new members, and also send membership renewal emails etc. I understand this needs to sync with a WordPress membership plugins.
Donations: We are looking to offer GoCardless for recurring subscription memberships as a primary method, and Stripe for one-off donations secondary.
List Sync with MailChimp: We are looking to use MailChimp to create our newsletter and marketing automation. We'd like to be able sync paid/unpaid member lists from CiviCRM to MailChimp automatically.
Giftaid: Automatically processing of giftaid application periodically.
Exporting to accounting software: We haven't decided on our new accounting software yet but it will be something SaaS-based - possibly Sage Cloud or Xero.

Questions we have about the proposed solution above:

Will this work? We plan to do a mix of the work ourselves but also work with a freelancer with build experience.
I'm all for using open source, I'm just concerned around the stability of the platform with upgrades etc. Do people have stable implementations like this?
Are they any recommendations for Membership plugins on the WordPress side that work well with CiviCRM?
How do people export their donations to their accounting software for end of year financials? Is it straightforward to do?
Looking at either self-hosting it on Google Compute Engine or a VPS - or looking at a hosted solution. Does anyone have any suggestions?
How are people supporting their solution once it's live? Any suggestions on ad-hoc use of a freelancer vs paid support options with an SLA?

We currently run Joomla with a membership management plugin that is no longer supported, and a few other plugins for mailing/backup etc that are all really challenging to use - hence the reason for looking at a new solution with some investment and hopefully, longevity!

Hopefully - this all makes sense. Really appreciate any suggestions and shedding some light on questions and design. Thanks.

In general I would say that this sounds feasible.  Your requirements sound similar to how many other charities are using CiviCRM.  However, you have asked several detailed questions and I think you could benefit from discussing this in more detail with one of the CiviCRM partners (and/or posting these as separate questions).

I would also recommend that you attend a CiviCamp to find out more about how CiviCRM works and meet others in the community.  We are a friendly bunch and you will get a lot out of meeting people face-to-face.  I see that you are based in the UK and can highly recommend attending CiviCamp Manchester on 6 October 2018 if you are able to.


WooCommerce & CiviCRM Integration Can WooCommerce products be synced into CiviCRM Custom Fields?

I tried creating checkboxes in CiviCRM under a custom field & they are not getting checked off when someone purchases something in WooCommerce....

Any feedback?

They guys at VedaConsulting developed a great extension that integrates Woocommerce with CiviCRM, no sure if is what you are looking for.

You can find it in their github repository


Enter Phone Number, Show Contact Details with API? There is a system where we answer calls from our members. We save all of these calls by creating contact information on CiviCRM and create the conversation in an activity.
People answering the calls create a contact by entering different information on the same number. I don't want that to happen. So, Can she create an API to enter a phone number and output a name?

You can, certainly - but it sounds like what you really want to do is set the Supervised Dedupe rule to dedupe on phone number.  That way, when someone enters a new contact, when they try to save it, it will recognize the person as a duplicate.


Setting the date feature is not working in events (Added Screenshots) I just installed Civi 4.7.27 on Wordpress 4.9.1 in a subdomain.   When configuring the new install, I am noticing something strange with the date settings. The first screenshot shows what I am getting in the new install. When I click in those boxes, the Calendar does NOT pop out like it is supposed to and it is displaying two extra textareas that shouldn't be there.  The second screen shot shows how it looks in my root directory as it is supposed to be.   How can I fix this?

ERROR MESSAGES

Failed to load resource: the server responded with a status of 404 (Not Found)
volunteer_events.css Failed to load resource: the server responded with a status of 404 (Not Found)

volunteer_app.css Failed to load resource: the server responded with a status of 404 (Not Found)

angular-modules.b61ce69729ca8c547f15ef2c0d2af9ae.js Failed to load resource: the server responded with a status of 404 (Not Found)
volunteer.css Failed to load resource: the server responded with a status of 404 (Not Found)

volunteer_events.css Failed to load resource: the server responded with a status of 404 (Not Found)

volunteer_app.css Failed to load resource: the server responded with a status of 404 (Not Found)

angular.js:4692 Uncaught Error: [$injector:modulerr] _http://errors.angularjs.org/1.5.11/$injector/modulerr?p0=crmApp&p1=Error%3A%20%5B%24injector%3Anomod%5D%20http%3A%2F%2Ferrors.angularjs.org%2F1.5.11%2F%24injector%2Fnomod%3Fp0%3DcrmApp%0A%20%20%20%20at%20https%3A%2F%2Fsecure.narsol.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3D54zOZ%3A6%3A426%0A%20%20%20%20at%20https%3A%2F%2Fsecure.narsol.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3D54zOZ%3A25%3A235%0A%20%20%20%20at%20b%20(https%3A%2F%2Fsecure.narsol.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3D54zOZ%3A24%3A282)%0A%20%20%20%20at%20https%3A%2F%2Fsecure.narsol.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3D54zOZ%3A25%3A20%0A%20%20%20%20at%20https%3A%2F%2Fsecure.narsol.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3D54zOZ%3A40%3A17%0A%20%20%20%20at%20q%20(https%3A%2F%2Fsecure.narsol.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3D54zOZ%3A7%3A371)%0A%20%20%20%20at%20g%20(https%3A%2F%2Fsecure.narsol.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3D54zOZ%3A39%3A382)%0A%20%20%20%20at%20fb%20(https%3A%2F%2Fsecure.narsol.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3D54zOZ%3A43%3A381)%0A%20%20%20%20at%20c%20(https%3A%2F%2Fsecure.narsol.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3D54zOZ%3A21%3A19)%0A%20%20%20%20at%20Gc%20(https%3A%2F%2Fsecure.narsol.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3D54zOZ%3A21%3A332)
    at angular.js:38
    at angular.js:4692
    at q (angular.js:325)
    at g (angular.js:4653)
    at fb (angular.js:4575)
    at c (angular.js:1809)
    at Gc (angular.js:1830)
    at se (angular.js:1715)
    at HTMLDocument. (angular.js:32616)
    at i (jquery.min.js?r=54zOZ:2)

volunteer_app.css Failed to load resource: the server responded with a status of 404 (Not Found)

volunteer.css Failed to load resource: the server responded with a status of 404 (Not Found)

volunteer_events.css Failed to load resource: the server responded with a status of 404 (Not Found)

I have just installed Wordpress 4.7.27 - I am not getting the issue. So this is not a core issue

clearing the cache and try again

else try reinstalling the wordpress again that should fix

I guess this helps !!!!


Date and hour format with seconds this date and hour format should work: %d/%m/%Y %k:%M:%S
but I'm not getting the seconds: 17/02/2021 9:15:%S
Is %S compatible in CiviCRM?

Normally, (custom) date formatting in civicrm is handled by this function:
https://github.com/civicrm/civicrm-core/blob/master/CRM/Utils/Date.php#L300
You'll see at about line 410 that there's no substitution for seconds.
Sounds like a not-very-difficult feature waiting to be added.


Webform does not allow create new contact if contact not in select list Webform - CiviCRM integration.    Form with 2 civi contacts - participant (individual) and program (organization)

I have a dropdown list in the webform which shows list of program organizations that can be selected.  The prompt for + create new + shows but does not allow any data entry of a new contact.

Any suggestions for how this can be enabled?

solved my own problem.   Looks like the +create+ new does not do in-place entry but is used in conjunction with the program field which is either  populated with the select list option or can be used to enter/create a new contact (program)


Customers Recieving Error Code on Renewal When customers try to renew their membership through our normal form, they recieve this:

"Payment Processor Error message: 1: 103 This transaction cannot be accepted."

Not sure what this means or how to fix it, but many of our customers can't renew their memberships because of this.

I wonder if this has anything to do with the technical updates that Auth.net did in mid-August?

Any help would be appreciated.

It sounds like an Auth.net password issue. Check this out from their support page on the 103 error:

  This error is generated when your Authorize.Net account is in
  Password-Required Mode and you are not sending a valid Transaction Key
  or hash fingerprint with your transaction request.

https://support.authorize.net/authkb/index%3Fpage%3Dcontent%26id%3DA852


Should Event Scheduled Reminders be sent if they were due to go out before a person registers Scenario:

There is a Scheduled Reminder due to go out 10 days and 3 days prior to an Event.

A person registers for the Event 2 days prior to it.

Does CiviCRM send the 10 day prior and the 3 day prior Reminders?

I am asking as a client on a customised (by others) CiviCRM 4.4.x is complaining that these Reminders are being sent out, but they should not.

Hoping that users with 4.6.x or 4.7.x can answer this, otherwise I will set up some tests to confirm.

NOTE: these are Scheduled Reminders that were set up via the tab on the Event config screen not via the Communications > Scheduled Reminders but assume that should make no difference

My experience is that yes, the reminders do go out in the scenario you described.  I wish there was a way to turn them off in this scenario but I have not found one.


Problems getting smarty to work I'm not sure where to look - I've tried everything that I can think of to get smarty to work in an email template, but it's just not happening.

I'm using CiviCRM 4.7.27 with WordPress 4.9.3.

I've changed the smarty setting in /public_html/wp-content/uploads/civicrm/civicrm.settings.php:

if (!defined('CIVICRM_MAIL_SMARTY')) {
  define( 'CIVICRM_MAIL_SMARTY', 1 );
}

But I can't get a smarty statement to work in a mailing.

If I use a Mosaico template, I get the source code in the email eg
{capture assign=newsletter}Yes{/capture}
{if $newsletter == Yes}
You agreed to receive our emails.
{/if}

If I use a new mailing (traditional) using the Sample CiviMail Newsletter template and try to test the mailing, I get an error message:
" Sorry an error occurred and your information was not saved"

Tokens work fine.

Any idea re what the problem is?

UPDATE:

Have gotten Traditional mail to output the Smarty code properly. It was all due to some syntax issues. It's hard to test under an administrator account which may not have the same contents as a regular account. The remaining problem is that Mosaico templates don't work. Here's a sample of what comes through:

{capture assign=contactId}18{/capture}
{crmAPI var='result' entity='Membership' action='getcount' sequential=0 contact_id=$contactId membership_type_id="Family" active_only=1}
{if $result gt 0}
Dear Test and family, {else} Dear Test, {/if}

Thank you for purchasing a 2018 membership!

{capture assign=newsletter}Yes{/capture}
{if $newsletter}Because you've indicated you'd like to receive our e-news, you’ll get our newsletter about once a month with info on cycling events and issues, volunteer opportunities, and cycling events and meetings.{/if}
{capture assign=interests}5{/capture}

{if $interests}You've also indicated that you're interested in participating in some of our activities. We'll send you information when there's one of your chosen activities planned.{/if}

{capture assign=volunteer}5{/capture}
{if $volunteer}Since you also indicated you're interested in voluneering for some of our activities, one of our activity team leaders will contact you when there's an opportunity to volunteer to help out.{/if}

If anyone has any ideas, that would be great.

I feel the statement should be something like this

{capture assign=newsletter}Yes{/capture}
{if $newsletter eq 'Yes'}
  You agreed to receive our emails.
{/if}


Smart group cache not updating with timeout of 0 We are on 4.6.18 and Drupal. The code in CRM\Contact\BAO\GroupContactCache.php has updated since 4.6.17.

We have users joining our public site to get a Drupal username and a CiviCRM membership (having paid a contribution). They then have a link to view and update their profile. When new users click to view their profile, they see "Permission Denied You do not have permission to view this contact record. Contact the site administrator if you need assistance."

From looking at the code, this message appears if the contact is not in the profile's group. The CiviCRM profile does indeed Limit listing to a specific group, which is a smart group with contacts with the relevant membership types.  Our smart group timeout is zero so it should update immediately. However this seems not now to be happening. If I "Cleanup Caches" then the contact is put in the group and it works fine.

I haven't got detailed evidence but it seemed like our smart group cache was never updating.

I could set the cache timeout and set up a scheduled task to rebuild the smart group cache. However this would not be ideal.

I haven't looked at GroupContactCache.php
Has the above behaviour changed in recently?
How can I fix this?
Or any other suggestions on how to avoid this problem?

Thanks, Chris

With a timeout setting of 0 for the smart group cache, Civi was none-the-less working with a timeout of 5 minutes. When a contact is added, clearContactCaches() is called which does call CRM_Contact_BAO_GroupContactCache::remove(). However smart groups that have not timed out will not be cleared.

To fix my issue I added to clearContactCaches() a call to clear the specific group that might be used immediately, ie:
CRM_Contact_BAO_GroupContactCache::remove(1234);

I also found a bug in GroupContactCache.php in 4.6.18, reported here:
https://issues.civicrm.org/jira/browse/CRM-19005


Why is a contribution given a financial type different from that allocated to the contribution page used? I have a contribution page, utilising Paypal standard, set up to handle a membership renewal. The page has a 'renewal' financial type set for it. However, if I initiate a contribution using this page, the resulting contribution record shows as having a different financial type ('registration').

I've come across this because I'm trying to debug a situation where users are reporting that they have made a payment via Paypal (and have sent me the Paypal receipt to prove it), but no contribution record exists for this transaction. The Paypal receipt includes information that strongly suggests that CiviCRM is sending data to Paypal, but as no contribution record exists in the Civi database to link to the receipt, I can't be certain.

Clearly something is not as it should be. I'm using Civi 4.6.10 currently and about to update to latest 4.6.x

Is this a known issue? How can I begin to debug this?

I am answering the question posed in the title, not dealing with the problem of debugging the Paypal problem.

When you define a membership type you specify a financial type.  That become the defualt financial type for that membership type. Unless you use price sets, the "default financial type for that membership type" will be recorded against the membership contribution no matter what you have chosen as the financial type for your contribution page. This is explained at the bottom of the help message that appears if you click on the ? associated with the Financial Type when you are setting up your contribution page.

  NOTE: If you are using this contribution page for membership signup and renewals, the financial type configured in the membership type settings will be used when recording the membership payment. The financial type selected here will only be used if you are also collecting additional contributions (as configured on the Membership Settings page).

If you need renewals to have a different financial type from new memberships (as we do) then you will need to use a price set for you renewal page specifying the renewal financial type at the line item level.  You will also need to extract financial data at the line item level, not just at the contribution level.


Keeping historical demographic information, while updating donor information So we have a unique use case.  The organization collects donations from employees of various departments with various roles at the organization.  Collecting employee information like title, department, etc seems pretty straight forward using custom fields and profiles.  However, lets say, 3 years down the road, a donor changes their department, the field would be updated when they renew their donation and would be accurately reflected in the system, but it would now impact historical information. Their donation records would stay the same, but their donations would be affiliated with the new department.

Am I making sense? Is custom fields the right approach?  Alternatively, we may just download historical data and use that for reports comparing campaign years.

There are several approaches to handling this.  Custom fields are one approach.  Another is to use Detailed Logging, which will keep historical records, although they may not necessarily be in the format you most desire.  They also take up a lot of disk space, since you're keeping the history of every change in CiviCRM!

If you try the detailed logging approach, also considering installing the Extended Reports extension, which has reports that pull data from the log tables.


cron setting in cPanel error I use wordpress 4.9.6 and civiCRM 5.1.2 for wordpress
in my cPanel:
string command:

https://mysite/wp-content/plugins/civicrm/civicrm/bin/cron.php?name=username&pass=password=curl '[string site-key]'

message mail:
You need to send a valid key to execute this file.
Why my key it's not valid? I took the key in cvicrm.settings.php
Thanks

The cron url seem to be wrong, it should have been

https://mysite/wp-content/plugins/civicrm/civicrm/bin/cron.php?name=<username>&pass=<password>&key=<site-key>


How can I import a list of contacts from MailChimp to the database all at once? I am looking to import a list of 185 contacts from MailChimp to our database and wanted to know how I can do this in one go. As far as I know I have to export the list from Mail Chimp and then edit the fields in an excel document, but how to I make sure the fields will match with those in CiviCRM?  Does anyone have or know where there is a template of what needs to be on the spreadsheet?
Are there any guides to how to layout the columns to refer to the fields I want to mark in Civi, also can I stop it importing duplicate contacts?
Thank you!
Grace

There is a mailchimp extension which you could install in CiviCRM and which then connects to your mailchimp and imports the contacts from mailchimp into CiviCRM.


Cron job for Multisite in WordPress I have a multisite WordPress setup with CiviCRM 4.7.23 and I am unable to create a successful cron job. I tried CLI with all parameters (including -s) and with no parameters but each time I get no output and CiviCRM says cron was not executed.

I tried the URL method

https://mysite.org/wp-content/plugins/civicrm/civicrm/bin/cron.php?name=XXX&pass=XXX&key=XXX

and same thing.

I tried, just for fun, the cli file via a browser and I got

  cli.php can only be run from command line.

which is at least correct. :)

The site in question is hosted on CiviHosting and the setup there is known to support both CLI and URL cron jobs for single-site setups.

I manage one WordPress multisite instance, so I looked how cron is configured.

We use wp-cli with the CiviCRM extension to trigger cron.

Cron jobs look like:

11,26,41,56 * * * * /full/path/to/wp-cli --user=civicrmcron --url=https://sitenumber7.org/ --require=/full/path/to/wp-cli/civicrm.php --path=/path/to/wordpress/webroot civicrm api --timezone=America/New_York job.execute auth=0 > /dev/null
12,27,42,57 * * * * /full/path/to/wp-cli --user=civicrmcron --url=https://sitenumber8.org/ --require=/full/path/to/wp-cli/civicrm.php --path=/path/to/wordpress/webroot civicrm api --timezone=America/Los_Angeles job.execute auth=0 > /dev/null

Note that if your multisite instances are in a subdirectory, rather than a different domain, you can set the URL accordingly and it still works.

Also note: Some WordPress plugins can interfere with cron!  That's not multi-site specific, but you can exclude plugins from loading with wp-cli either by specifying on the command line or creating a config file.


CiviCRM does not have permission to write temp files - halts the system My website stopped working due to a CiviCRM problem, all I see is:
"CiviCRM does not have permission to write temp files in ...wp/wp-content/uploads/civicrm/templates_c/en_US/,exiting"
My hosting service may have recently updated to php 7.4.
Seeing old solutions to this problem, I deleted all the folders in wp/wp-content/uploads/civicrm/templates_c/en_US/
but left .htaccess unchanged.
That did not solve the problem.
Should I delete everything in .../uploads/civicrm/templates_c/
Has anybody had this problem and fixed it?

Thank you. Deleting everything as suggested worked. Problem solved.


Create a Drupal View of current event participant numbers We use CiviCRM to sell event tickets and I was wondering if it's possible to pull the list of current events and confirmed participant number in to a simple Drupal View restricted to logged in users so we can keep track of ticket sales more easily?

I've looked at the built in options for creating the views but can't see a way of pulling that data across.

If there's an easier way of doing this directly in Civi then all ears for that as well but we're finding it a bit clunky to have to find each individual event each time and check the registered participant number and just want an overview.

Yes you can do this in a Drupal View but it will require some config (both to tell Drupal about your CiviCRM tables as well as the Views config itself);

The goto solution for this within CiviCRM itself is:

Install: Extended Report Extension:
Got to your Adminster -> System -> Settings -> Manage Extensions -> Add New -> ExtendedReport (nz.co.fuzion.extendedreport)

After you've installed it -> go Administer -> CiviReport -> Create New Report from Template and select e.g. Extended Report - Contributions with Price Set data


SpamAssassin marking mailings as compromised WordPress site A few of my constituents have told me that my emails are going to their Spam folder in Gmail.  I did some digging with mail-tester.com and found that SpamAssassin is dinging my mailings -1.629 points for the code URI_WP_HACKED_2.
I did some more digging and found this is likely caused by the WP REST API that was integrated into Civi in 5.25.  I'm currently running 5.27.0.  See this link for more information:
https://docs.civicrm.org/dev/en/latest/api/v3/wp-rest/
My question is:  how do I resolve this SpamAssassin false positive?  I don't understand how to set the CIVICRM_WP_REST_REPLACE_MAILING_TRACKING constant to true.  I've tried both in wp-config.php and civicrm.settings.php.  SpamAssassin is still marking the mailings as URI_WP_HACKED_2.
Any ideas as to why this is happening and how I can fix it?
Many thanks!

Can you detail out some more information.   Without the filter added there is no change at all to mailings pre and post civicrm 5.25.   The urls are the same until you add the filter.   I am unsure how to evaluate without a list of the URLs they are dinging you for and I understand you would not want to post them here.  As far as the REST API for mailing, you can try this https://develop.tadpole.cc/plugins/cv-rest-mailing  it's a small plugin that implements the filter needed.


Data Security and Location Does CiviCRM have servers located in Canada and can they assure Canadian clients that their data is stored only on those servers?

Do you mean the "spark" product offered separately by CiviCRM?

You don't have to use spark you can download and install CiviCRM yourself with any hosting company. If you are looking for someone to set it up for you then take a look at https://civicrm.org/partners-contributors