What are the cookies used by CiviCRM? Given the need in the EU to provide information about the cookies that a given site uses, is there any information available at CiviCRM (and maybe its extensions ecosystem) about the cookies that CiviCRM uses?

I can't answer on behalf of CiviCRM LLC but I can say that the only cookie I see is the session cookie which just stores a session id. However the session object on the server that matches that id has many things in it, but in any case the purpose within the code is usually to provide functionality, such as the recent history list in the sidebar, or even just basic access control.

What a system administrator might also do with the cookie would be specific to the site.


Civirules send sms not working wordpress 4.9 civi 5.22 civirules 2.1 SMSAPI 1.5

No activity is added and no sms is sent

And this question doesn't meet quality standards so I'm adding some more text
Provider is clickatell. I can send sms through Civi without using civirules. Worked fine previously. I’m not sure whether the upgrade to Civi 5.22 or the upgrade to civirules 2.1 is the cause as upgrades were contemporaneous. There are no error messages and I don’t know which logs might help. It’s 4am my time and I have been struggling for hours with a number of post upgrade issues with some excellent help from this forum. I eat muesli for breakfast, have 2 dogs  and consider civirules to be one of the most useful extensions ever (even though it is currently giving me grief.

That was the clue - put a five minute delay on the sms action - the condition is checked again and Voila the sms is sent.
So perhaps this needs to be added to the docs. It might be only the action "send sms" that needs a delay. Sending an email or adding a tag work fine via a profile.


Using Wordpress Event Registration forms on Multisite Thought this would help someone else.

I have one CiviCRM on a multi site installation and was obtaining "You do not have permission to access this page" when displaying a form on a second multi site.

This appears the second site doesn't have the anonymous role setup per:
https://civicrm.org/blogs/haystack/working-civicrm-46-wordpress

I will post the next post as the solution.

Place this in your functions.php file

register_activation_hook( FILE, 'civicrm_activate');

// Assign minimum capabilities for all wordpress roles and create anonymous_user' role
civicrm_wp_set_capabilities();

This only needs to run once per site to create the role.


How can I search for upcoming birthdays? Is there a way to find upcoming birthdays in version 4.7?

When I try to find people by birthday in the advanced search, it still searches for people whose birthday is in the current year (birth-date).  So I can't find people who has birthdays in January neverminding the year.

Thanks.

There is an extension called "Birthdays By Month" which may prove helpful:

  BIRTHDAYS BY MONTH

  This extension lets you look up contacts that have a birthday on a
  given month. Once installed access it at ~/civicrm/birthdays-by-month.
  Author:  S. Lee Gooding


Need to enlarge the field box size I've created some custom fields for a profile and would like one of them to have a larger text box than the default size.  How do I enlarge the field box size?

I usually change the field type to be 'Note' when I need a longer length - then you specify length and number of lines - and it's expandable - if the user needs to add more they can resize the box.


How to display CiviCRM menu for non-admin role using WordPress? We would like to restrict access within the WordPress dashboard to the "subscriber" role settings but also have the ability for that user to access the CiviCRM. The only way we can get the CiviCRM link to show in the left navigation is to set the user's role to admin which we don't want. I found this thread here. How to show CiviCRM menu for non admin role using WordPress? However, we have not blocked any access to the menus so there does not seem to be an answer there for us.

We've adjusted the settings through CiviCRM > administer > Users & Permissions > Permissions (Access Control) > WordPress Access Control. So far, we haven't had any luck.

It looks like in the screenshot here that it is possible. (refer to the image in the WordPress Access Control section. https://book.civicrm.org/user/current/initial-set-up/permissions-and-access-control/ I only see the left navigation links for subscriber plus CiviCRM.

Thanks for any and all suggestions.

Out of curiosity, is this with one of the default Wordpress themes applied?  If not, it may be worth switching themes to a default theme and check the functionality.  Additionally, if you have the WooCommerce plugin active, it removes the ability for subscribers to see the side menus by default.  (You also can't see the WordPress user's Profile page.)


Why does configuration option stay red? I am very new to CiviCRM. I am setting the Configuration Checklist options. After setting one, and saving, it remains red. Have I missed something?

The "Configuration Checklist" is just a set of links - the color is just an indication of whether or not you've clicked on it.  In many cases, there's no definitive way for CiviCRM to know whether the answer you gave is "correct".  For instance, you may not have set a default state/province because you don't want one, not because you forgot to.

That said: Some configurations MUST be set.  Those will show up at Administer menu » Administration Console » System Status if they're not configured.


Is there a way to encrypt a single field in Civi database? To protect sensitive data - such as HIPAA info

You should be able to use the functions in:

CRM/Utils/Crypt.php

to do symmetric encryption/decryption of the fields. Password related fields in the CiviCRM db are encrypted. As Lesley mentions, there are two aspects to this problem. Encrypting data, and restricting access to the data to a certain class of users


Where can i find CiviCRM volunteers? I'm volunteering for a new non-profit that has very limited resources and was wondering if there is any place that we can find volunteers for helping with CiviCRM. For finding FOSS developers i know about places such as idealist, sourceforge and openhatch, but what is the best place to find volunteers that are experts on CiviCRM specifically? (Doesn't have to be programmers)

Kind Regards, Tord

You're probably best off recruiting for volunteers in general who are interested in volunteering in your sector, and offering that person the opportunity to upskill.

Good luck,

John


Search Builder Smart Group with Latitude, Street Address criteria 1292 Truncated DB Error CiviCRM 5.9.1. Issue has occurred since an upgrade from version 4.7.17. The Smart Group/Contact Group in question is built on two simple search builder criteria:

Contacts Primary Street Address is NOT EMPTY
Contacts Primary Latitude IS EMPTY

We can edit the criteria, and go to the initial list of contacts. But trying to run the search/query, view the contacts, or update the group creates a hard DB error. I have attempted to re-create the group and encountered the same exact issue.

This is the query in question (FYI the ID of the group is 58):

CREATE TEMPORARY TABLE civicrm_temp_group_contact_cache1621 (
    SELECT 58 as group_id, contact_a.id as id
    FROM civicrm_contact contact_a
    LEFT JOIN civicrm_address ON (
        contact_a.id = civicrm_address.contact_id AND civicrm_address.is_primary = 1
    )
    WHERE((
        (NULLIF(civicrm_address.geo_code_1, '') IS NULL)
        AND(NULLIF(civicrm_address.street_address, '') IS NOT NULL)
    ))
    AND (contact_a.is_deleted = 0)
    AND contact_a.id NOT IN (
        SELECT contact_id FROM civicrm_group_contact
        WHERE civicrm_group_contact.status = 'Removed'
        AND civicrm_group_contact.group_id = 58
    )
);

The resulting error is:

[nativecode=1292 ** Truncated incorrect DOUBLE value: '']

However, when I run the SELECT query alone in PhpMYAdmin without the "CREATE TEMPORARY TABLE" bit, the query works fine and displays results.

EDIT: When I try to run a Search Builder with the same criteria outside of a group, I am actually able to retrieve the results, yet the LOG is still showing a DB Error:

Ignoring exception thrown by nullHandler: -1, DB Error: unknown error

And I can't get a query in the logs because they are hidden in the traceroute.

EDIT: I put this in the answer as well, but I find it somewhat important to note now that whenever I attempted to edit this existing Smart Group's search criteria, I always had to re-select the operator.

Am I allowed to answer my own question? lol.

I was able to resolve the DB error for this specific smart group by changing the Operator criteria from "Empty" to "Null". So "IS EMPTY" became "IS NULL" and "NOT EMPTY" became "NOT NULL".

Also, I find it somewhat important to note now that whenever I attempted to edit this Smart Group's search criteria, I always had to re-select the "operator", so I wouldn't be surprised if the root of this issue has to do with the "Empty" operators.

EDIT: There is an open GitLab issue now: https://lab.civicrm.org/dev/core/issues/786


Token for custom field returns the token but not the Values. How to fix it? when I Insert a token of a custom field to print a pdf letter all built-in token seems working but not the custom ones, no value works, regardless of the number I put in the token. Do you know where the problem is please?

this is the link where I got "50" from :http://abcd.org/civicm/...update?action=update&reset=1&gid=18&id=50

what you are trying to do is to print Gift-Aid custom value in the PDF letter so you need use Token hooks - and assign an new token name for the gift-aid custom values by creating an new extension so the token will be available in the drop down list and you can print the values

do the same for all custom values


Could not create a database trigger on AWS RDS I am installing CiviCRM in Amazon AWS environment. User civicrm has full rights on civicrm database. I certainly see TRIGGER among all others in my phpMyAdmin console. Out of abundance of caution I even gave global TRIGGER permission. Still, I am getting the error.
I had a test installation with DB running on the same server as web server and didn't have any problems. Don't know if CiviCRM doesn't see TRIGGER permission because of different host, or because of RDS limitations, or yet something else.

Web Server is Amazon Linux (similar to Fedora/CentOS); Apache 2.4; MySQL is 5.6.27

UPDATE: I tried "root" account and I get the same error. I don't think (or at least I don't know how) I can spool the SQLs that get generated - so if somebody can point me to a query that tries to create a trigger and fails, that would be awesome!

Turns out, Amazon RDS by default turns on binary logging that prevents "CREATE TRIGGER" to succeed, and CiviCRM interprets this as insufficient permissions. More here. For now I turned off automatic backups and completed installation successfully.


On Import, where is county field? I've noticed upon matching mapping fields in the import process that for some fields in the file they are missing in the CiviCRM drop-downs. For instance, for a field named "Home County' the CiviCRM drop-down for 'County does not appear. But choose 'Employee of' and 'County' appears. In fact, it is one of the only other, unrelated fields that it appears.

Please advise. Thank you in advance.

The issue is almost certainly that the "County" field is not enabled by default, which suppresses it in the import dialog.

Go to Administer menu > Localization > Address Settings, and under "Address Editing", see if the "County" box is checked.  If not, check it.  Restart your import and the field should appear.

I also confirmed your report that County appears even if disabled as a field for related contacts.  That's a bug, though a very low priority one!


Upgrade 4.5.6 > 4.6.1 Running my upgrade stalls at the upgrade page. The buttons are not working and do nothing.

According to the debugger in Firefox, there is an illegal character in noconflict.js and CRM.$ is not a function in runner.

Solved via Facepunch. This time, my own.

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


Bounce Mail Retention Policy in Civi I have the problem, that a bounce mailbox I am using ran full, and it's kind of hard to monitor , since the joblog of CiviCRM needs to be watched (Bounce Mail Cronjob).

Since Civi is managing the mailbox anyways, and moves mails to CiviMail/processed and CiviMail/ignored, shouldn't CiviCRM clean up afterwards and delete old mails? Or shouldn't there be at least an option for that?

Maybe there is an extension implementing that, but I haven't found anything yet.

We integrated that into an extension, found here at github. Retention can be configured in days for each folder.

Extension is still alpha, handle with care.


Custom File Field Filename Error I have created some custom file fields so I can add some files (pdf, doc, zip etc) to each user profile.

When I upload the files, everything works great.
I the backend the file names are displayed correclty,
BUT in the frontent the filenames are changed:
a string like "_8b9c34bb85a1219b9e1f60e02d82907c" is atteched.

How can I fix this?
I use civicrm 4.6.11 and wordpress 3.8

UPDATE 5/4/2016:
I have tested version 4.6.14 and 4.7.4 on wordpress 4.4.2 (latest version)
on different Plesk (TopHost) and Cpanel (SiteGround) shared servers.

The problem remain the same.

The files are stored correctly but at the frontend an HTML text on the link is added.

See Screenshots:

user profile custom fields backend

user profile custom fields frontend

backend civicrm 4.6.14

wordpress 4.4.2 frontend profile page civicrm 4.6.14

server settings

Please make sure you have selected the correct datatype while creating the custom field value  - it should look like below


"Do not email" privacy setting and CiviMail I sent out a mass e-mail using CiviMail and a recipient who has the "Do not email" privacy setting received it.  The help text associated with the "do not email" privacy setting makes it clear that they would receive registration confirmations and contribution receipts, but NOT receive CiviMail emails.

The only thing I can think of is that it might be because I added their "Do not email" setting AFTER I created the mass mailing but before the mailing was sent out.  However, I thought that CiviMail adjusted the mail recipients list according to whoever was included in the recipient groups at the time the mail should go out.

Questions:

Does anyone know when CiviMail creates the sending list of recipients for a mass mailing?  Is it at the time the mail is created, or at the time the mail is sent out?  i.e. if I generate a mail that should be sent to group X, then I remove a user from group X, then the mail goes out...will that user get the mail?
Can anyone confirm that the "Do not email" privacy setting means that this person SHOULD NOT receive any further mass emails?

I have tested by adding this user to a group and then creating a test mass email.  They were not in the list of recipients.  But I am paranoid because I do not understand why they received the one that they did.

Thank you

EDIT:
I have sent out several more mailings, and the people marked as "Do not email" are now not getting emailed.  CiviCRM is specifically flagging that they will not be emailed.  So, in conclusion, CiviMail must create the recipient list at the time that the e-mail is scheduled, not at the time it is sent.

Your analysis is correct, the list of recipients is build when the email is scheduled, not when it's sent

In practice, it shouldn't differ too much, but they are some edge case, like possibly your "Do not email" contacts that might have changed between the time you scheduled the email and it was sent

Depending on what logging configuration you have, you might have more info and find out the timeline: check on the "log" tab to see when the contacts have been modified and by whom (they are some changes that aren't properly logged, but you might find the information you need to understand these cases)


Events Calendar to display on front end I have a joomla built website I have installed civicrm into.  I would like to display an events calendar (not just the events list) on the front end.  I have tried installing the available extensions that civicrm list, but those only appear to be for the back end of the civicrm component.  Is there something that can be integrated with the events portion of civicrm and display in calendar format on the front end?
(Ed) I have tried these that can be found in the available extensions list: com.agiliway.civicalendar com.osseed.eventcalendar Both are only for the back end.

com.osseed.eventcalendar can be used to display a calendar in the frontend of your Joomla-site by following the instructions in the readme.txt of the extension.

Copy the folder "yourextensiondirectory/com.osseed.eventcalendar/joomla/EventCalendar" to "joomlarootdirectory/components/com_civicrm/views/" which will add the menu item type for Event Calendar.

For frontend display you need to add a menu item of the type "Event calendar" and provide the calendar id (if you have multiple calendars). If you pass an empty ID it will display the global calendar for frontend.


How can I export contacts and tags, but only for a particular tag? Is it possible to export contacts and related Tag information, but only for one particular Tag Set? Thanks.

Yes, you can export tags for contacts with a particular tag. It doesn't seem you can export just one particular tag, but you could easily do this as a post-process once you've exported to CSV.

Checked on http://dmaster.demo.civicrm.org/ -

Search => Advanced Search
"Basic Criteria" group => Tags => Volunteer
Submit "Search"
Click "All 61 Records"
Select "Export records" action
Export PRIMARY fields
Exported CSV contains tag information ...


CiviCRM logging enabled. I am now getting an error on mysqldump. Unknown storage engine 'ARCHIVE' I getting the following error when I try to dump my civicrm drupal database

  Couldn't read status information for table log_civicrm_install_canary
  () mysqldump: Couldn't execute 'show create table
  log_civicrm_install_canary': Unknown storage engine 'ARCHIVE' (1286)

This table is related to the civicrm logging feature as described in the article https://civicrm.org/blog/eileen/who-did-what-when. Logging was enabled a while ago and everything seemed to work fine. Since then the site has been migrated to a new host and has had both civi and the drupal core updated a number of times. Currently, The site is hosted on omega8 running barracuda which is an aeger based host so these updates are more like site migrations. The instructions in the blog required turning on INNODB with a civicrmapi call. This was run for the original site but not on any of the migrated sites. I don't know if this is relevant? I am now getting the error when dumping the database via mysqldump.

Does anyone have any idea what this table is for or what might be causing the error?

Thanks for any help.

Short answer: Change the storage engine of the table with the following command in mysql:

ALTER TABLE log_civicrm_install_canary ENGINE=InnoDB

The civicrm_install_canary is a table used for installation purposes. The purpose is explained in the answer on What is the installation canary?


CIVI Dashboard display settings broken in Wordpress install New to CIVI. Working with an install of CIVI in Wordpress. When logged as Admin AND visit the Civi Dashboard, it loads, but displays broken, with settings and displays all over the place. Attached is a screenshot of the 'Manage Events Tab' as an example of what the settings currently look like.

I have checked civicrm.settings.php for BASE URL issues etc, and all is pointing to the correct WP install in the directory.

Has anyone experienced this issue and can shine some much need light on.

Many thanks

I would double check the define( 'CIVICRM_UF_BASEURL'      , 'http://example.com/' ); line and make sure that the url exactly matches the Site Address (URL) in http://yoursite.com//wp-admin/options-general.php

I've had issues where one is http://www.example.com  and the other is http://example.com

Next check the CiviCRM resource URL:  http://example.com/wp-admin/admin.php?page=CiviCRM&q=civicrm/admin/setting/url&reset=1 The CiviCRM Resource URL parameter should point to http://example.com/wp-content/plugins/civicrm/civicrm/

Lastly, I'd fire up Firebug or chrome inspector and see if there are any console errors.  I'd want to know which css file is loading for civicrm.  For me it is /wp-content/plugins/civicrm/civicrm/css/civicrm.css


Has integration been done for Textify Mobile? Has anyone seen this new SMS service called Textify Mobile that's geared directly to non-profits and churches. It even has mobile giving with it. Wondering if anyone had done an integration/extension for it?

My name is Mitch Cannon, and I'm the VP of Technology for Textify Mobile. We currently only offer a private API for specific integrations and partnerships. With that said, we are actively developing a RESTful, JSON-based API for our general user base. I would love to talk with anyone interested in an integration about their needs and what we can currently accommodate.

http://www.textifymobile.com/contact-us


Is there a checklist for setting up a new organization's website + CRM? I'm meeting with an organization later this week to begin the process of seeing them up on civiCRM and a Drupal website.  Curious any of the people who does this regularly if you have a document that helps you cover all the information you need to obtain in order to get things started? Would you mind sharing it with me so that i can make sure this goes as smoothly as possible?

Palante Tech has been building an internal document for this, but we haven't devoted much time to fleshing it out - it's more a "list of questions we wished we'd remembered to ask" and doesn't get into the important questions, like "What is this for?  Who will be using it?"  Nevertheless, here is our work-in-progress:

All projects

How much traffic does your site currently get, per Google Analytics/Piwik/etc.?
Where is your site hosted?  Are you open/eager to moving your hosting?
Who currently manages your website?
Will there need to be multiple levels of permissions?  How granular/how many?

CiviCRM projects

How many contacts do you anticipate having on day 1?  How many contacts do you intend to add per month/year?
What features of CiviCRM do you intend to use?  Donation management, mass e-mails, membership management, etc.?  Is a particular use driving the project?
[If CiviMail] What sort of mail volume are you doing in your legacy system?
What are your legacy data sources?  How many Excel/Google Docs/etc.?


How to reset CiviCRM? When writing a re-initialisation script / extension or drupal module, how would you reset CiviCRM back to clean installation state? Is it possible to install "minimal" without components and their data? Or is component data always pre-installed, enabled or not?

With component data I mean the database data that is needed for some of the build in civicrm components as listed in /civicrm/admin/setting/component. As far as I can remember, at installation I never choose components, they came pre-activated by default. When I deactivate the unnecessary components, a lot of their data is not removed from database and remains. I was wondering if there is a way to force a minimal installation without components and then programmatically activate / install the ones I need.

I was wondering if there is a way to use part of the installer code to restore the initial database, without having to reinvent the wheel.

I'm not certain what's meant by "component data" here - but in all likelihood the easiest approach is to restore a copy of the civicrm.mysql and civicrm_generated.mysql files in the "sql" directory.  Don't forget to drop your database first, restoring a SQL file won't drop existing tables created, e.g. by generating custom fields.


Can I have a price set option add a registrant to the waitlist if the event isn't full? I have what may be a tricky situation regarding registration and waitlists.

We have an event where we have two potential types of registrants: residents of a jurisdiction and people who live outside of the jurisdiction. People pick if there's a resident or non-resident in price options when they go through event registration.

Those who pick the Resident price option should go through registration and fee payment normally and end up with a "registered" status when they're done.

We want people who pick the Non-Resident price option to not pay anything and be set to a waitlist status once they're done with registration. We would then manually move them to "registered" if there's enough room after a certain date.

Question 1: Is this a normal part of CiviEvent functionality that I'm just not able to find?

Question 2: We had a developer set up a price set like this that does work. We copied it, changed label names, and tried to use the new price set for another event, and the non-registrants are ending up "registered" instead of "waitlist." Any advice on how to successfully replicate that original price set? I just recently got access to cPanel for our site and I'm not sure what to look for here.

I appreciate any advice you may have. Thanks in advance.

One approach would be to ask the resident/non-resident question first and direct them to two separate events: a residents one for immediate registration and a non-residents one with a max participants of 0.

When you want to allow non-residents to book you have two basic options:

open up non-resident bookings by changing the max participants on the non-resident event
find a way to transfer waitlist registrations from the non-resident event to the resident event.

For 1), you end up with registrations spread across two events which is not ideal but may or may not matter to you.  To manage further registrations you probably want to close the residents event at the same time and direct any new registrations to the non-res one so that you can still manage total numbers.

For 2), I don't think there is an easy way to transfer registrations between events without some coding.

You mention cPanel - that's not relevant here.  Event configuration is under the Event menu:


How to Insert html in custom field (type TextArea) via API I have a custom field with data type 'Note' and field type 'TextArea'. When I insert a value using the CiviCRM interface, I can insert text via an editor, and bold text gets displayed as bold, italic etc.

Now I want to put html in this same field using the API, but the problem is that any html characters are converted to html entities when inserted.

  $params = array(
  'contact_id' => $contact_id,
  'entity_id' => $contact_id,
  'custom_' . $content_field_id => '
' . implode('

', $data['note_content']) . '
',
);
$create_note_result = $spcivi->api('CustomValue', 'create', $params);

html send via api:

Vette tekst is toegestaan!

Shuine ook!

result content in field:

&lt;div class="note_content"&gt;&lt;strong&gt;Vette&lt;/strong&gt; tekst is toegestaan!&lt;/div&gt;&lt;div class="note_content"&gt;&lt;em&gt;Shuine&lt;/em&gt; ook!&lt;/div&gt;

Is there a way to insert html without the html characters being converted to html entities? Using the field type TextArea becomes quite useless when not html can be inserted.

Have you tried any of the following before submitting the TextArea?

Highlight the code portion and Ctrl + K or Command K
Indent the code lines 4 spaces
Use backtics ' your html '
Use code tag your html


How to set API ContactType parent_id NULL or how to rename label? Attempting to write prototype initialisation code I want to rename a ContactType using the API action "create". I tried to set:

array ('parent_id' => 0)
array ('parent_id' => '')

But both error out with "Mandatory key(s) missing from params array: parent_id".
I cannot set array('parent_id' => NULL), because it would be like unsetting 'parent_id' which according to the error message cannot be missing. So the question is how do you set it NULL or how do you rename the label of a ContactType using the API?

Edited: Then I discovered that apparently you need the ID of the ContactType when you want to update with 'create', following the instruction that the API explorer gives me when I choose 'update':

  The "update" action is deprecated. Use "create" with an id instead.

So I added id as parameter and kept trying ways to set 'parent_id' correctly to NULL. I discovered that array('parent_id' => '0') is the likely way to do that, because it returned a different error message: "already exists". Well yes, I knew that. My intention was to update the label with 'create" according apparently a wrong instruction. Or is this a bug?

Rename ContactType label

$result = civicrm_api3('ContactType', 'create', array(
  'sequential' => 1,
  'id' => 1,
  'label' => "test",
));

This example will rename ContactType Label

I guess this helps !!!!


What Drupal modules do I need in order to I'm working on an electoral project.  I'd like to try a little experiment with direct democracy.  All involved would be Contacts within CiviCRM.

What Drupal/CiviCRM modules/extensions would I need to accomplish the following:

Each candidate would have content (Blog/Forum/Polls) created by them that is viewed only by Contacts within their electoral district.  The electoral district relationships are in pre-loaded CiviCRM multi-value custom fields.
Each contact (voter) would be able to see and edit (comment/poll vote) the content from #1 for each candidate in a district that the voter resides in.  Content from other candidates would be invisible.
A contact can be both a candidate and a voter.
I've already got ACLs set up which associate a candidate user ID with the voter Contacts in the electoral district.  I can, if necessary, create an ACL which associates a voter user ID with all the candidate Contacts in the voter's districts, although that seems very cumbersome.

I'm assuming that all of the candidate/voter interaction will occur within Drupal content.

CiviCRM 5.3.2
Drupal 7.60

What Drupal/CiviCRM modules/extensions would I need to accomplish the following:
Each candidate would have content (Blog/Forum/Polls) created by them that is viewed only by Contacts within their electoral district. The electoral district relationships are in pre-loaded CiviCRM multi-value custom fields.

I would use OG and get some custom synch stuff done so that OGs are populated based on Relationships (we have done this for other clients)

Each contact (voter) would be able to see and edit (comment/poll vote) the content from #1 for each candidate in a district that the voter resides in. Content from other candidates would be invisible.

Well if we are going down the OG route for #1 then I would stick with that for this too.

A contact can be both a candidate and a voter.

Not sure what the point/question is here, but would assume Drupal Roles so that within the OG the 'voter' has more options than the 'candidate'. But if you mean they might be a Voter in one district and a candidate in another then again the OG approach would fit.

I've already got ACLs set up which associate a candidate user ID with the voter Contacts in the electoral district. I can, if necessary, create an ACL which associates a voter user ID with all the candidate Contacts in the voter's districts, although that seems very cumbersome.

It isn't clear how you are doing this since your terminology is jumping between 'user id' and presumably civi relationships, but i would use Fuzion's Permissioned Relationships extension to take care of this, and that knits well with the OG approach

I'm assuming that all of the candidate/voter interaction will occur within Drupal content.

Right, so am I - using OG in case that hasn't been clear yet ;-)


Can I update the id of an existing OptionValue? I'm trying to update the ID of an existing OptionValue using API v4. I get "Cannot update the id of an existing OptionValue" error. Is there another way to do that?

As said by Jitendra, you cannot update the id via CiviCRM api. The id in civicrm tables are autoincremented and are referenced at many places. If you still want to take risk than you can run a sql query in mysql to update the id of required row in civicrm_option_value table.


Smart Groups - Added contacts show status of 'smart' not 'added' I have recently upgraded to 4.6.19 which has solved issues to do with the updating of smart groups. However if I add a contact to a smart group it does not show the status of 'added' but shows the status to be 'smart'.

I just tested this in 4.5.5 and 4.7.9 (sorry, don't have a 4.6 test environment) and the status of a contact added to a smart group is indeed "added", so unless it is a bug with your specific version, perhaps the contact you believe to have added actually fit the criteria of the smart group to begin with? In any case, upgrading will resolve the issue.

Kind regards,
Tamar


is there any way to restrict data export? Is there any way to restrict data export while still allowing users to see all data? I still want to give this permission 'View ANY CONTACT in the CiviCRM database, export contact info and perform activities such as Send Email, Phone Call, etc.' but don't want them to be able to export the contacts. civi 4.6.11, drupal 7

Yes, it is now possible. I didn't hear from Kboy so I wrote an extension myself:

https://github.com/progressivetech/net.ourpowerbase.exportpermission


Civicrm 4..6.10-drupal is missing directory CRM/common Upgraded from 4.1.15 to 4.6.10 with no errors, setup file system ownership & permissions, cleared template_c cache, ran drush cvapi system.flush
Working but layouts are wrong and the log file contains errors with
"User warning: Smarty error: unable to read resource                                     : &quot;CRM/common/action.tpl&quot; in trigger_error() (line 1094 of ../sites/all/modules/civicrm/packages/Smarty/Smarty.class.php).

Directory modules/civicrm/CRM does not contain a common directory.

Ive resolved my issue by drilling into the fine Civicrm template documentation. The log file leaves out the initial part of the directory so whats being referenced is actually sites/all/modules/civicrm/templates/CRM/common which does exist in 4.6.10. Whats missing is the file action.tpl, it was present in Ver 4.1.

Root cause though was having an old custom tpl file in sites/all/civicrm_templates/CRM/common which called action.tpl.

Fixed by deleting the old custom tpl files, then working through the version control checking the issue documentation to see if custom tpl files are still needed.


Bounces not reaching bounce account CiviCRM 5.19.2
WP 5.3

Testing my bounce settings, and I'm not sure whether I actually have a problem or not. I've set up both 'bounce' and 'activity processing' accounts, and their respective scheduled jobs run without error (and CiviCRM has created the corresponding folders in both accounts).

Using the default 'from' address (info@mydomain), I've been sending a newsletter out to a small dummy group containing faulty addresses (one, for example, is an old work address of mine that's disabled). While I get an immediate message from the google mailer-daemon ("550 5.2.1 The email account that you tried to reach is disabled"), sent to info@mydomain. Shouldn't that go to bounce@mydomain, the account I've set up for bounce processing? Or am I misunderstanding something basic?

I can also confirm that I can send email to bounce+ (and receive it there), but the when I'm sending with CiviMail I only receive the bounce message in the reply-to (which is the sending) address. See the image below.

The key to getting bounces sent to the right account is the Email Domain of the Mail Account that you've configured for Bounce Processing. The emails that are sent out use that domain for the "envelope" from address (which is not the one you see as sender or recipient, but the one that's hidden in the smtp conversation between machines).

As more detailed explanation is here: https://docs.civicrm.org/sysadmin/en/latest/setup/civimail/inbound/

In summary:

The "envelope" From address for a civi message is built uniquely per message and recipient as "uniqueid-per-recipient-per-message@bouncedomain.org". When it bounces, the bounce processing will process it based on that from address to determine what to do with it.

So your bounce domain is usually NOT your from address domain, it's a special domain that can handle bounces. You normally would not want to do this yourself, though it's been done and there are instructions to do it using specially setup gmail addresses using some more involved addressing magic.


Drupal View filtered with a custom individual data field I have a Drupal View that I'm using to display in a directory a list of individuals that are employed by a group of organizations. I saw no way to filter a View based on employer names so I created a select list whereas I simply added as select options the organizations whose employees I wanted to display.

At first I created this list to be used for 'All Contact Types' and it worked fine. I built a Drupal webform so people could edit there own information and that's when I found that the fields did not autopopulate with the current information. I assumed this was because the fields were user for all contact types and not for only individuals. I built a new custom data set that is used only for individuals and tried that. The Drupal webform would then show current information when the user logged in.

I then realized that I could no longer filter the View with the new fields. When I used the old fields that were allowed for all contacts the filtering worked and I had individuals show in my directory, however, when I switched to the newly created fields that were limited to individuals I has no contact show in my directory.

I've also run a preview within the View itself and only get results when using the custom field built for contacts. When using the one built for individuals I get no results. Any thoughts? The query is:

  SELECT DISTINCT civicrm_contact.id AS id, civicrm_contact.contact_type
  AS civicrm_contact_contact_type, civicrm_contact.display_name AS
  civicrm_contact_display_name, civicrm_contact.organization_name AS
  civicrm_contact_organization_name, civicrm_contact.job_title AS
  civicrm_contact_job_title, civicrm_email.email AS civicrm_email_email,
  civicrm_phone.phone AS civicrm_phone_phone, civicrm_contact.sort_name
  AS civicrm_contact_sort_name FROM {civicrm_contact} civicrm_contact
  LEFT JOIN {civicrm_value_testing_for_directory_25}
  civicrm_value_testing_for_directory_25 ON civicrm_contact.id =
  civicrm_value_testing_for_directory_25.entity_id LEFT JOIN
  {civicrm_email} civicrm_email ON civicrm_contact.id =
  civicrm_email.contact_id AND (civicrm_email.location_type_id = '2' AND
  civicrm_email.is_primary = '1') LEFT JOIN {civicrm_phone}
  civicrm_phone ON civicrm_contact.id = civicrm_phone.contact_id AND
  (civicrm_phone.location_type_id = '2' AND civicrm_phone.is_primary =
  '1') WHERE (( (civicrm_value_testing_for_directory_25.nhp_org_191 LIKE
  '%a%' OR civicrm_value_testing_for_directory_25.nhp_org_191 LIKE
  '%b%' ) )) ORDER BY civicrm_contact_sort_name ASC LIMIT 20 OFFSET 0

Drupal Views need to know about table updates when they are using separate databases.  When you add a custom field, civicrm  creates a new table.  To expose the new entity, you must edit the settings.php file with the new field.  You can just copy/paste from here: https://example.org/civicrm/admin/setting/uf?reset=1 .  Ref: http://wiki.civicrm.org/confluence/display/CRMDOC/Views3+Integration


Reverse sync CiviCRM groups to Drupal organic groups We have a client who would like to sync their CiviCRM groups to Drupal organic groups.

This is opposite to the CiviCRM Organic Groups module which syncs organic groups TO CiviCRM groups.

Their are some oldish posts on the CiviCRM forum but I can't see anything recent (e.g. http://forum.civicrm.org/index.php/topic,14212.0.html). Any help would be appreciated.

Oliver

We use civicrm_entity module + rules to do things like that. This blog gives a recipe for relationship to OG.

There are a couple of general civicrm+rule blogs

http://www.jackrabbithanna.com/articles/simple-rule-example-using-civicrm-entity

http://www.fuzion.co.nz/blogs/complex-civicrm-relationship-role-synchronisation-recipe

But neither are specifically to OG - I think there is one somewhere though - or else maybe an og rules feature - if I find it I'll paste it in


Batch number missing in version number in civicrm.php By default, WordPress uses the version information provided in ../civicrm/civicrm.php. However, the batch number is missing here:

<?php
/*
Plugin Name: CiviCRM
Description: CiviCRM - Growing and Sustaining Relationships
Version: 4.7
Author: CiviCRM LLC
Author URI: http://civicrm.org/
Plugin URI: http://wiki.civicrm.org/confluence/display/CRMDOC/WordPress+Installation+Guide+for+CiviCRM+4.7
License: AGPL3
Text Domain: civicrm
Domain Path: /languages
*/

WordPress uses the following code to extract the version information from a plugin:

$data = get_plugin_data("~/civicrm/civicrm.php");
$version = $data['Version'];

I am using this functionality to automate keeping track of my fixes until CiviCRM and other plugins make the necessary corrections in the next release.

  Would it be possible to update civicrm.php to add the batch number?
  So, it will return 4.7.12 instead of 4.7.

You can get the more granular CiviCRM version data with:

$version_file = CIVICRM_PLUGIN_DIR . 'civicrm/civicrm-version.php';
if ( file_exists( $version_file ) ) {
    require_once $version_file;
    $civicrm_version = civicrmVersion();
}


How do I set up recurring donations? I'd like to be able to set up recurring monthly gift donations.  Is this possible with my CRM? Currently, we can accept one time gifts but can't seem to figure out how to take automatic monthly gifts.

In what part of the world are you located? If it is in Europe you might need the CiviSEPA extension as well :-)


Modify the Tags (Categories) Administration page I'm using CiviCRM 4.7.9 in a Drupal 7 environment. CiviCRM does an amazing amount of stuff remarkably well. Unfortunately, its Tags (Categories) Administration page (http:///civicrm/admin/tag) page is not one of them. I have a rather extensive set of tags organized into tag sets.

When I attempt to manage my tags, the Description column is so wide that it forces everything else off the page. You have to scroll way over to get to the incredibly important Parent ID, Tag set? and actions columns. When you scroll over, you loose all ability to see which tag you're actually dealing with. The whole thing is a terribly clumsy, difficult mess.

If I could just get rid of the totally unnecessary Description column in the display, it would not only make managing the tags (and tag sets) much easier, it would also make it possible. Is there any way of getting the offending Description column disappear?

When we have come to a necessity of Tags Administration page changes, only way we've been able to find, was custom CRM/Admin/Page/Tag.tpl template creation. With more than 2000 tags, it was almost impossible to load the page, so we got rid of some CiviCRM stuff and replace it by "native" Datatable script (CiviCRM uses it anyway, but wraps it into set of features we didn't need at the moment).
This is how it looks now, loads pretty fast and has only information we use (guess Tag Set and Reserved also can be stripped though):

It's CiviCRM 4.6, but guess this part has no significant differences to 4.7
So, you might want to give "custom CiviCRM template creation" a try, most likely you will get there sooner or later, if you continue to use CiviCRM for a long enough :-)


CiviEvent registration prevented with “missing fields” error for CiviDiscount free registrations for event We are running CiviCRM 4.6.8 on Drupal 6.37.

We are a theatre company and we use CiviEvent to sell tickets/register attendees for events. We've have set up a membership group for alumni actors and used CiviDiscount to set up the option for alumni actors to register for a pair of comp tickets to any performance:

But, because the registration costs $0, no billing fields appear (nor does the Civi Copy Address"Billing Address same as" checkbox), and the registrant receives an error message and is unable to complete registration:

Especially since seating is limited, we need to still be able to track attendees, even if they are comped in. This seemed like the best way to allow a particular group of people access a specific discount--non-members wouldn't receive the discount, obviously, and we'd still be able to track who attends which performances and when seats are no longer available.

This also happens if "Pay later" is selected, which I've seen listed as other questions, and appears to be fixed for version 4.6.9, which has not yet been released. Is there a solution in the meantime?

This sounds like the same problem as: https://issues.civicrm.org/jira/browse/CRM-17082

Looks like you need to apply 2 patches mentioned in the issue.


continue button missing for free event registration If I configure a free event the online registration page has a "continue" button after the registration fields.

However if I have a paid event with a free (ie $0.00) price, when the $0.00 price is selected the payment (paypal) block disappears but no "continue" button displays?

civi 4.7.10
wordpress 4.6

This is definitely an issue with how PayPal express - payment processor works in civicrm, if you have multiple options on the event and the customer chooses to pay nothing and only opts for free part of the event. the continue button disappears as well paypal express button goes away, I've been using paypal standard instead to get around the issue.


Show the CiviCRM simple donate form on Drupal static page or node. I am using Simple Donate version
 1.2
I am trying to integrate 'simple donate' extension for drupal page and/or block.

I have tried it by initializing civicrm in custom block. CiviCRM is getting initialized properly.

I have jut tried to load /partials/simpledonate.html file using code in following file:
com.webaccessglobal.simpledonate-1.2/js/simpledonate.js

$routeProvider.when('/donation', {
        templateUrl: resourceUrl + '/partials/simpledonate.html',
        controller: 'SimpleDonationCtrl'
      });

if the URL is '/donation' then it will load /partials/simpledonate.html
But it is not working.

Can anyone put the idea i.e. how to load CiviCRM extension in drupal block or page?

Any idea is appreciable..

You can make a use of Webform CiviCRM Integration module which integrates civicrm donation pages with webform and webform can be used as block anywhere in the node, for that you would need Webform blocks module.


MySQL v8.0 released. Will CiviCRM work with it? MySQL 8.0 has been released.  Will CiviCRM work with it?  I tried migrating a test database to it, and CiviCRM under Joomla failed.

Oct 31 12:36:35  [info] $Fatal Error Details = Array (
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] =>  SELECT  v.label as label ,v.name as value, v.grouping as grouping FROM   civicrm_option_value_en_GB v,
       civicrm_option_group_en_GB g WHERE  v.option_group_id = g.id   AND  g.name            = 'languages'   AND  g.is_active       = 1  AND v.is_active = 1  AND ( v.component_id IS NULL  OR v.component_id IN (SELECT id FROM civicrm_component WHERE name IN ("CiviEvent","CiviContribute","CiviMember","CiviMail","CiviReport","CiviPledge")) )  ORDER BY v.weight [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'grouping FROM   civicrm_option_value_en_GB v,
       civicrm_option_group_en_G' at line 1]
    [type] => DB_Error
    [user_info] =>  SELECT  v.label as label ,v.name as value, v.grouping as grouping FROM   civicrm_option_value_en_GB v,
       civicrm_option_group_en_GB g WHERE  v.option_group_id = g.id   AND  g.name            = 'languages'   AND  g.is_active       = 1  AND v.is_active = 1  AND ( v.component_id IS NULL  OR v.component_id IN (SELECT id FROM civicrm_component WHERE name IN ("CiviEvent","CiviContribute","CiviMember","CiviMail","CiviReport","CiviPledge")) )  ORDER BY v.weight [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'grouping FROM   civicrm_option_value_en_GB v,
       civicrm_option_group_en_G' at line 1]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info=" SELECT  v.label as label ,v.name as value, v.grouping as grouping FROM   civicrm_option_value_en_GB v,
       civicrm_option_group_en_GB g WHERE  v.option_group_id = g.id   AND  g.name            = 'languages'   AND  g.is_active       = 1  AND v.is_active = 1  AND ( v.component_id IS NULL  OR v.component_id IN (SELECT id FROM civicrm_component WHERE name IN ("CiviEvent","CiviContribute","CiviMember","CiviMail","CiviReport","CiviPledge")) )  ORDER BY v.weight [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'grouping FROM   civicrm_option_value_en_GB v,
       civicrm_option_group_en_G' at line 1]"] )

The SQL below runs happily against MySQL 5.7 whilst it fails against MySQL 8.0 with

  "SELECT" is not valid at this position for this server version,
  expecting '(', WITH

SQL:

  SELECT  v.label as label ,v.name as value, v.grouping as grouping FROM
  civicrm_option_value_en_GB v,
         civicrm_option_group_en_GB g WHERE  v.option_group_id = g.id   AND  g.name            = 'languages'   AND  g.is_active       = 1  AND
  v.is_active = 1  AND ( v.component_id IS NULL  OR v.component_id IN
  (SELECT id FROM civicrm_component WHERE name IN
  ("CiviEvent","CiviContribute","CiviMember","CiviMail","CiviReport","CiviPledge"))
  )  ORDER BY v.weight

Replacing the first line with:

  SELECT  v.label as label ,v.name as value, v.grouping as `grouping`

solves the problem.

Clearly some work is needed before CiviCRM will work with MySQL 8.0

Clearly CiviCRM won't work with MySQL 8.9 yet; at least not in my environment.


How can I automatically turn off civirules after a given period? I have a rules that should perform action only until a certain date. What would be the best way to handle this situation so that after a given date the specific rule would be turned off automatically? Thanks

Depending on your Trigger in the rule, I would suggest just adding a time-based condition.
If contribution, add criteria «Field Value Comparison» for «Date Received» and set the operator to less than the desired date.
If activity, use activity date. If new membership, use membership start date, and so on...


I get an error "One of parameters (value: sort_name) is not of the type MysqlColumnNameOrAlias" when trying to access most of my data Okay, I'm new at this - honestly, probably not skilled enough to be doing this, but my organization has no money, so, well, I'm it.

I installed on WordPress last year, and everything generally went well. We use the system, it does what we need. Realistically, it might be overkill (we have only about 300 contacts), but I like it.

Then, this year, I noticed that I hadn't kept up with updates.

So - back up, then update. Complete failure. Did not work at all.

Fine. Restore from backup.

So, now, I can get into the system, and using the standard searchbox from "CiviCRM Home", I can find various contacts. Myself, for example - I type in "Ashle...", and there I am. Click on my name/email, and bingo - into my profile.

BUT.

From within my profile screen, click on "Contributions" and get "Sorry but we are not able to provide this at the moment.". Click on "Memberships", and it momentarily seems fine, but then there's a floating box in the right-hand top corner saying "One of the parameters (value: total_amount) is not of the type MysqlColumnNameOrAlias". Moments later, I get a true popup (have to click "OK" to clear) saying "DataTables warning: table id=DataTables_Table_0 - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1". Click "Groups", and I get a listing of my groups (four, in my case) - but click on one of them, and I get "Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
One of parameters (value: sort_name) is not of the type MysqlColumnNameOrAlias"

That last message is the one I get whenever I try nearly anything from the top-bar drop-down menus.

Can anyone suggest a way forward? As it is, I can access names, addresses and some basic data of any of my contacts where I already know their names so that I can go directly to their profile. But I can't really do anything else.

Should I try a new install? ...or do I need to try to monkey with the databases? ...or am I asking the wrong questions? I'm sorry if I'm asking a question that I should have been able to find an answer for elsewhere here on StasckExchange - I did certainly look, but I couldn't find an answer.

Thanks for any help,

Ashley

Hi managed to get the same issue

One of parameters  (value: total_amount) is not of the type
MysqlColumnNameOrAlias

I had Drupal 7 and CiviCRM 5.4
I did recently changed my PHP version to 7.4 - which is the reason for the above error message - I guess I need to upgrade my CiviCRM to latest that should fix the issue(will try and update the result)
For now I have just changed my PHP version back to 7.2 which worked alright
Hope this helps!!!


How to add extra date in contribution template? or best way to do it? We have 10 Financial Types and different online contribution based on those. I need to add an extra date field in contribution such as "Date of sponsorship".

I have already created 10 different custom field for that, just because we need to identify that date for different financial types separately. Then to add them into the contribution pages I need to create 10 different profile as well!!

Is there a way to make "Date of sponsorship" field as a common field like contribution note? or Receive date or What would be the best approach?

Creating 10 "duplicate" fields is often a sign that there is something sub-optimal on the data modelling. As you start to realise, having the "wrong" data model is creating tons of problems further down the line, it's often better to come back to the root problem and try to fix it directly

Could you clarify your need?


How can I record a partial refund for a membership? A user has just renewed their membership, and inadvertently opted for the default amount (60) rather than the correct amount for their particular situation (30). The contribution page offers two price options.

We've actioned the partial refund to address the overpayment, but I need to make a record in CiviCRM of this partial refund.

Right now it looks like the simplest option is to create a new manual contribution record with a negative value, assuming that's do-able, but it's far from ideal. Is there a better way that enables me to keep the membership and the record of the credit card payment already made?

Yes you can create refund of overpayment transaction using edit line item extension


Could Civi or Drupal Rules be used to aggregate ratings for services? We want to implement a feedback system for services (these would be CiviCRM Contacts). Think of it like eBay feedback with an overall rating and some sub-categories like speed of dispatch, comms, description of item, etc.

Each of these ratings would be stored as a Custom Field against each Contact.

Feedback would be gathered via Activities. Could Civi or Drupal Rules be used to calculate averages (based on multiple Activity submissions) and update the custom fields on the Contact?

You would do this with an extension. Check out the Summary Fields extension for inspiration. It's similar to your goal, just geared toward donations and event participation.


Confirmation receipt sent from strange sender address If I send a confirmation receipt (checked 'Send Confirmation and Receipt?' during renewal of a membership), the sender address is wrong if the preferred is chosen. In stead of displaying the address given, it scrambles the address to 'id of the address in civicrm_mail table'@'server host name', e.g. 2@s2.domain.tld.

When I choose another address, the sender address is fine.

It looks like you've discovered a bug!  I'm sorry this happened to you, but identifying this helps to make the software better.

I confirmed this bug, and also confirmed that it's not limited to the mail() setting.  I've opened an issue on the CiviCRM issue tracker.

UPDATE: I decided to dig into this a little bit to see if the fix was easy, and it wasn't too bad.  It's available for review now.  If you could apply the fix and let folks know on Github how it works for you, that would be great!  If you're not sure how to apply the fix, get in touch with me on https://chat.civicrm.org, my name there is @junglebird.


Annual Memberships Renewed Early We have memberships that are "fixed" from Jan 1 through Dec 31. This works fine except for that we want that if anyone creates or renews a membership in November or December, that their membership will be valid for this year and next year.

So if I create/renew my Membership in September 2019, I will be a member from then until December 2019.

But if I create/renew my Membership in November 2019, I will be a member from then until December 2020. Here I will get Nov/Dec of this year "for free" and then be a member for all of next year.

Presently, if I create/renew a Membership in November 2019, it ends December 2019.

You need to configure the rollover date in the Membership Configuration. Please see:

https://docs.civicrm.org/user/en/latest/membership/defining-memberships/


End-of-life for Web Spell Checker (WSC) dialog plugin for CKEditor 4 A client of ours recently brought to our attention that the spell checker functionality that’s partnered with CKEditor 4 is coming to its end of life for the free version by the end of June 2021.
https://webspellchecker.com/blog/2020/12/02/end-of-life-for-spell-checker-dialog-plugin-for-ckeditor-4/

It’s a functionality they wish to continue to use, what alternatives/options are available?

This is a solution that the client accepted so thought I’d share –
Enable the browser spell check functionality.
Administer > Customize Data and Screens > Display Preferences > Configure CKEditor
By default, native browser spell check functionality is disabled in the editor. Use the config.disableNativeSpellChecker configuration option to enable it:
config.disableNativeSpellChecker = false;

With this addition to the CKEditor configuration you should be able to see the spelling corrections underlined in your editor content.


Edits not saving in Case Activity Tab since 4.7.4 upgrade If I edit an activity (eg the date or the status) in the Activities tab of the Manage Case page, I get the confirmation message "[activity name] saved". But the edit is not saved.

This problem only appeared after upgrading to 4.7.4. There are no JS errors, no errors on CiviCRM log, no php errors.

Running Joomla 3.4.8. I can't test on the demo, because it's still on 4.6.

Edit: just tried the Wordpress demo, and the problem is present there as well.

Any suggestions where to look for the problem? Thanks.

Verified now that the issue is a general problem with CiviCase in Drupal, Joomla and Wordpress versions. I have raised a bug report here.


Strict warning: Non-static method CRM_Core_BAO_UFGroup This seems to be a carry-over from:  http://forum.civicrm.org/index.php/topic,26411.0.html

I'm now receiving this error:

Strict warning: Non-static method CRM_Core_BAO_UFGroup::checkFieldsEmptyValues() should not be called statically, assuming $this from incompatible context in CRM_Profile_Form->postProcess() (line 1315 of /home//public_html/sites/all/modules/civicrm/CRM/Profile/Form.php)

I just upgraded from 4.3

now using
- php 5.5
- drupal 7.38
- civiCRM 4.6.4 (a fresh install)

Has a fix been found?

EDIT

...should have mentioned the php upgrade ;-)

I was able to control the warnings in the php.ini in php5.4 - with php5.5 they reappeared and nothing I've been able to do in the php.ini or .htaccess has been able to remove them. (Drupal platform and the errors are only in the log...I'm just trying to reduce the numbers of "errors" I see)

First of all, this is not really an error that would cause you any damage, so I would not classify it as an important bug. The name is 'strict warning', which means that it is a warning (not an error!) that the programmer has sinned against the PHP rules when a strict check has been done. So it should be fixed at some stage, but these type of warnings will never disappear entirely as they do not break anything.

I assume you are now seeing those warning because you are a site admin? In most live sites 'normal' users will not see these warnings, but that needs to be configured in your CMS (Drupal, Joomla or Wordpress).


Customize a User's Signature I'm running WordPress with CIVI 4.6.2, at some point in the set-up I managed to modify my personal email template to include my signature and logo. I am not using any extensions.

Currently my contact info and logo automatically appear in email messagew when I decide to email a contact through civicrm. Here's a picture of what I mean:

Unfortunately this modification only appears when I send emails. I have not been able to duplicate this modification for other users in the system. I cannot remember how I did this in the first place.

Any pointers on how I can accomplish this without installing an extension?

Thank you,

You can only edit the email signature when you open the full edit screen for your contact, not when you do an inline edit for email addresses.

Go open the contact whose signature you want to set
Click Edit at the top of the contact's record
Then, scroll down and you'll see Signature below each email address.  You can set it there.


WordPress - Problems trying to go back to CiviCRM 4.7.17 from 4.7.19 I've been having problems trying to get CiviCRM 4.7.19 working. So I thought I'd try going back to CiviCRM 4.7.17, which I had managed to get working pretty well on another site. I deactivated and deleted CiviCRM 4.7.19, deleted and recreated the MySQL database, and uploaded, extracted and activated CiviCRM 4.7.17.

When I go to Settings on the WordPress dashboard, I don't see "CiviCRM Installer".

When I try http://<my_wordpress_home>/wp-admin/options-general.php?page=civicrm-install

I get "Sorry, you are not allowed to access this page."  (Even though I am logged in as a WordPress administrator in another tab.)

I'm pretty new to CiviCRM and not sure where to go from here. Thanks for any tips you can provide.

WordPress 4.7.4 running on Linux.

http://connectionpracticecoach.com

The civicrm directory under wp-content/uploads was not deleted when I deleted CiviCRM through the WordPress plugins interface. I deleted that manually using cPanel, and the install went normally.


Email templates stripped of style tags Style tags cannot be saved in message templates and have in fact been stripped from current templates. We use a number of templates based on the Single Column Responsive Sample Template. In the last month, all the templates that used to contain a style tag that made the templates responsive have been stripped from the templates, including the sample template. Any attempts to re-add the style tag (or any style tag at all) seem to save fine, but on viewing do not have the style tag. Other changes are saved properly. I think this is since upgrading to 4.6.22, but am not sure of this.

Style tags can still be saved in CiviMail directly, just not in the templates.

CiviCRM 4.6.22 & Drupal 7.50

Changing from TinyMCE for template editing to CKEditor solved this problem. Verified that switching back to TinyMCE causes style tags to be stripped.


lid wel beend maar niet gepresenteerd Ik heb gisteren Nick Poelenjee toegevoegd als lid Den Haag.
Ik zie hem niet terug bij de lidmaatschappen. Als ik hem opnieuw wil aanmelden dan zegt het systeem hem wel te kennen.
Hoe los je dit op

Hoe heb je Nick toegevoegd? Als je de contactkaart in CiviCRM bekijkt dan zie je daar als het goed is een tabje lidmaatschappen staan. Als je daar op klikt dan kan het zijn dat daar een inactief lidmaatschap staat.

Overigens helpt het als je vraag in het engels stelt want dan zijn er meer mensen die je vraag kunnen beantwoorden.


Importing contacts and adding to a group also adds contacts with imported relationships to the same group I'm importing a CSV of contacts with a relationship to other contacts and adding the new contacts to a group. To my surprise, the group ended up with more contacts than I had imported. I saw that all the contacts who had their contact id in the relationship column were also added to the group.

Bug that should be reported? Strange, but expected behaviour?

Specifically, in this case, the relationship was employee of and the employer contacts were of a different type.

This is strange behavior, but it's been the case for at least nine years and probably longer.  I think that until the import is overhauled (work that is slowly but surely happening) we shouldn't change behavior out from under folks.


Civimail does not save settings I'm trying to save new settings in civicrm/admin/mail form.
I click "save" and get the "Your changes have been saved" message but, when refreshing the page, the form is empty as it was before.

We're stuck at the 4.2.9 civicrm version, as our provider does not provide the php features new versions require

Please help, we need to change these settings in order to be compliant to our provider's smtp policy.

We are eventually able to change settings in db tables, if somebody could tell us where to find them (there are really a lot of tables to search from)

Thanks a lot!

the table is most likely: civicrm_mail_settings

It depends on what specific field you want to change, but most of the fields in that form are from the above table


Hosting Provider for CiviCRM I am trying to install my CiviCRM instance on my current drupal installation that is my website which is hosted by the webgo24.de. During installation  I get an error „DB Error“ and after some emails between my Hoster and me he came back with the info that the required permissions I need for the database for CiviCRM are Admin permissions and they can‘t give me those.

Do you have an idea on how to solve that in general? Is there a smaller version that does not require all the rights? How are you setting up CiviCRM? Own server, cloud server or root server with Hoster?

Thanks for your help?
Said

You can find the list of required permissions here: https://docs.civicrm.org/sysadmin/en/latest/requirements/#mysql-permissions

You might want to check out some of the options for hosting here https://civicrm.org/partners-contributors?country_1=All&services=Hosting&language=All&cms=All


Cron through cli.php I am trying to set up the cron job through the cli.php method following the CiviCRM Docs.

Running the command from my ssh session on the server as www-data user, I am getting the error:

  could not match userID and contactID

But neither the CiviCRM logs, nor the Drupal logs, nor the apache error log gives me any further hints on what this means.

I am running CiviCRM 5.9.1 on Drupal 8.6.9.

How can I solve this?

I managed to find the solution. It seems the Drupal account used for the cron has to be synchronized with CiviCRM (to create its CiviCRM Contact) first before it can run.

Use the menu to trigger manual synchronization: Administer -> Users and Permissions -> Synchronize Users to Contacts.


Child groups with all parents disabled shows in group list I'am currently using Civicrm version 5.3.1 with drupal 7.59.
Steps to replicate:

Create one group, parent A.
Create a one group, child A and assign parent A group created above as
parent.
Disable parent A group.
Go to contacts->manage groups. You are unable to see both parent and child groups.
Click on any search criteria. Unclick it. You can see the child A group with title as Child A Child of:. With null value for parent

How it works currently: If a child group has multiple parent groups and one of them is disabled, the child group should to show up on group selector lists. This has been fixed here https://issues.civicrm.org/jira/browse/CRM-20934.

If all parent group(s) are disabled the child group still shows up in search mode.

Is this the expected behaviour?

Shouldn't the child group be removed from the selector lists if all parent group(s) are disabled?

Well, you could still have contacts assigned to a (enabled) child group, so I don't find it very surprising you can use it on search.

More generally, what enabled/disabled means in the context of group hierarchy is probably not fully clear, and it's likely that different users expect different things, and it's especially true with multiple hierarchical relationships.

Wouldn't it be easier you disable the child groups when you disable the parent (assuming it's not happening too often)?


Add a membership to a person with an other than default company i have a sporting company which does multiple sport departments each whith its own results  there are all part of the mothercompny called flevostar

so example you have Flevostar Basketball and FlevostarDart
i created 3 organisations in my contact list  Flevostar/Dart/Basketball

a new member is also created
on the add membership page i would like to add a membership linking that new person to for instance Dart. Even though it appears that there is a drop down  i can only select default company  in this case Flevostar and a membership type.

ending up with that i have to absue the membership tpe to distinquish them so had to create MemberTypes  ACTMEM DART and AVTMEM Basketball
where as i would have liked to have new member x is member of department(organisation)Dart  whith type Member

is this any how to be achieved?

best regards

leon

ok  maybe i am not clear in my problem description. i use the backend for creating initial relation ships between the member and the department.  example: i have John as contact Basketball as organisation and flevostar as default.  now i go to johns personal sumary and click on memberships (initial they ar counted as 0) and i want to ad a membership.  Memberships tupes are  LID basketball  connected to Basketbal organisation and Lid Flevostar connected to flevostar organisation.  so in the memberships sumary i want to add johns membership to the basketball organisation with type Lid basketball.  However i can not select the organisatiobn Basketball in the drop down hence i can not link Lid basketball type to John  i hope this makes sense now

This was too long to be a comment.

Are these people joining up for themselves on your public web pages, or are they being signed up as members by office staff using the "back office" pages?

Also a person has to choose the correct membership type to begin with. If a person is already a member of your default organisation then they will have to join again as a member of a different organisation.

Have you read the Membership section of our User and Admin guide, in particular the chapters online membership and sign up, manual entry of memberships and membership price sets


How do I put a thermometer on a contribution page? My organization occasionally does one-off fundraising drives for specific situations where we need to raise a certain amount of money (e.g. "Send our youth employees to the US Social Forum"). Creating a new contribution page makes sense here. But we'd like to have a thermometer on the page.

Using a personal campaign page would give us a thermometer, but it's an extra hassle to set up, and doesn't quite fit the situation as well  because of the way the PCP creates soft credits.

The contribution page provides a widget with a thermometer that I can embed on other sites. I can even embed this widget within the contribution page to obtain a thermometer. But then I get a bunch of superfluous stuff in the widget, like a "Contribute" button which takes people to the page they're on. No good.

Seems like it works well for you to copy and paste the embed code onto the contribution form, there are just certain redundant bits you'd like to hide.
You could add some generalized global rules for this to your website's css. e.g.

form.CRM_Contribute_Form_Contribution_Main .crm-contribute-widget h5,
form.CRM_Contribute_Form_Contribution_Main .crm-contribute-widget .crm-comments,
form.CRM_Contribute_Form_Contribution_Main .crm-contribute-widget .crm-campaign,
form.CRM_Contribute_Form_Contribution_Main .crm-contribute-widget .crm-contribute-button-wrapper {
  display:none;
}


How to Integrate Web form with Wordpress? I want to integrate new contact form with wordpress for public display/data entry like in this drupal page

I want to have this

To be a web form for data entry, showing with the wordpress.

the Drupal page you screenshot is a Profile as you can see in the URL. To find out how to display a Profile as a public form on a WordPress site I recommend you refer to this Chapter and read the section called "Standalone forms with Profiles"


How can I change the fields displayed by dataTables? I want to customize the information provided by templates that are generated via the dataTable plugin. Specifically, I want to alter the RelationshipSelector.tpl to display a contact's title and a couple of custom fields.

The dataTable script in the RelationshipSelector table makes a call to civicrm/ajax/contactrelationships via AJAX. It returns JSON. I noticed that the dataTable plugin elsewhere makes calls to civicrm/ajax/*.

Is there a way I can alter the JSON that is returned to include my fields?

I'm running a Drupal + Civi 4.6

If you look in CRM/Core/xml/Menu/Contact.xml you'll see that the civicrm/ajax/contactrelationships maps to CRM_Contact_Page_AJAX::getContactRelationships, so you can go into CRM/Contact/Page/AJAX.php and change what the getContactRelationships function does.

If you're not familiar with the techniques here to override core files, as opposed to editing the actual core files, you also want to take a look at that.


Is there a way to interface CiviCRM with QuickBooks Online? We can probably use the existing QB interface to manually export accounting batches from CiviCRM and then import these in QBO, but I am specifically looking for a solution that would use QBO's RESTful APIs (https://developer.intuit.com/docs/api/accounting) to automate this process as much as possible.

Agileware has developed a CiviQuickbooks extension - in this case "Quickbooks" means "Quickbooks online".


CiviContribute - fee calculation error I'm getting the error: 'The sum of fee amount and net amount must be equal to total amount' when I'm trying to manually add a contribution. The calculation is correct.

Any help in resoling it appreciated.

Thanks,
Peta

There are few issues reported against this validation(CRM-21624). Can you please try after applying the patch or you will need to wait for 4.7.31 release.


What is the best way to create a conditional question in case activities? I currently have cases with different activities in CiviCRM for different programs. I then used custom fields to add additional questions to appear in each activity in the forms. Is it possible to set conditional questions to appear based on a prior question?

P.S. I'm currently using CiviCRM on Drupal. However, I like to keep using the case activities form instead of a Webform for the cases.

CiviCRM does not have a built-in way to create conditional fields in its forms. You mentioned Drupal Webforms and yes they could solve that problem for you if you were open to using a webform instead.

Otherwise the only solution is to learn to write jQuery code and customize your form by showing/hiding fields with javascript.


Can we disable resource-intensive logging queries triggered by inline edit? On the contact summary page in CiviCRM 4.6.4 with advanced logging enabled, after doing an inline edit of address or phone, an AJAX query is triggered for a logging report URL:

/civicrm/report/instance/87?reset=1&force=1&section=2&altered_contact_id_op=eq&altered_contact_id_value=59625&cid=59625&qfKey=blah&crmPID=2&snippet=json

Report instance 87 is a reserved instance of Contact Logging Report (Summary) with report_id logging/contact/summary .

This is a problem on a site with a large number of log entries: in this case, 4.8 million in log_civicrm_activity_contact. The logging queries take many minutes to complete. So a simple inline edit triggers heavyweight queries that slow down the database.

I'm guessing this is done in order to update the count on the Change Log tab heading. In Civi 4.4, if advanced logging is enabled then the Change Log tab heading does not show a count. This is preferable. Was the count added as a result of a feature request? Can it be disabled?

I think this would be a relatively simple fix. I'd suggest you file an issue for this and, ideally, provide a patch...

...actually in fiddling around with this I just wrote a patch that fixes it. Try this:

#6283 Don't force-refresh the changelog tab to avoid performance overhead


Importing signatures into Petition? I am bringing old data into CiviCRM and we have a number of old petitions in a variety of formats (paper, YAWPP) and I didn't see a way to import the old names & emails into a petition. Did I miss something?

So I figured out how to do this, for the future.

You need to import an Activity for each contact. Match as per any other import

Key import details:

source_record_id = petition id (you may have to look into the db to find this)
activity type = 32 (or the activity type id listed for Petition Signature in Administer > Customize Data and Screens > Activity Types)
subject = by default, this is the title of petition
data = date signed


How do I upgrade CiviCRM on a local site that I installed with buildkit civibuild? A while back I did

$ civibuild create demo.local --type drupal-demo --url http://demo.local

and got a working local site running CiviCRM 4.7.9. Great.

Now I'd like to upgrade this site to 4.7.17.

I tried:

$ cd ~/buildkit/build/demo.local/sites/all/modules/civicrm
$ git fetch
$ git checkout 4.7.17
$ cv flush
$ drush civicrm-upgrade-db

The last command gives You are already upgraded to CiviCRM 4.7.9.

What did I miss?

EDIT:

Also I have tried:

$ git checkout master
$ git pull

as well as browsing to http://demo.local/civicrm/upgrade?reset=1 to perform the database upgrades (Which tells me "Your database has already been upgraded to CiviCRM 4.7.9")

tldr

cd buildkit/build/dmaster/sites/all/modules/civicrm

## Ensure that all your stuff is clean/committed.
git scan status

## Update git repos. Choose ONE of:
git scan up
./bin/givi checkout X.Y.Z

## Regenerate data. Choose ONE of:
civibuild reinstall dmaster
./bin/setup.sh -Dg && drush civicrm-upgrade-db

Checking the git repos

There are multiple git repos in your build (civicrm-core.git, civicrm-packages.git, etal). Before making a major switch, I first double-check that all of these repos are in sane condition -- ie there shouldn't be any uncommitted changes, the repos should be on normal branches, etc.

git scan status

Updating the git repos

As a developer who tracks mainline branches, my day-to-day interest is "updating to the latest revision of master or 4.6". The command git scan up will perform a standard "fast-forward merge" (git pull --ff-only) across all the repos:

git scan up

(Tip: If you didn't cleanup earlier, then "fast-forward" may not be possible. It takes some judgment to decide what to do -- e.g. a "merge" versus "rebase". Rather than risk a wrong decision, git scan will skip these repos and display warnings instead.)

Your example uses a tag. Hopping among tags is a bit different than tracking a branch. For this, I use givi:

./bin/givi checkout 4.7.17

Updating the generated code, config files, databases

As a developer who does weird things on a day-to-day basis (like manually hacking SQL records to provoke weird situations), I have trouble remembering all the weird things that I've done before -- and honestly don't care about them afterward. I just want to get back to a consistent/clean state. Reinstalling is nice because it recreates/overwrites all generated-code, config-files, and database content.

civibuild reinstall dmaster

However, that does reset all the data. If you care about the content in the database, then don't do a reinstall. Instead, update the generated-code and perform a DB upgrade:

./bin/setup.sh -Dg
drush civicrm-upgrade-db

See also

For more discussion, see the blog post: https://civicrm.org/blogs/totten/developer-tip-managing-multiple-git-repositories


CiviCRM not sending mails We've updated CiviCRM to 4.6.3. Since then, CiviMail has stopped working. When we log in, the following warning pops up:

"Warning: Outbound email is disabled in system settings. Proper settings should be enabled on production servers."

We set it up correctly in Email settings both mail() and SMTP, and in both cases the test mail is sent OK according to the popup window (view attached file). But it does not get delivered so we believe it isn´t really sent.

We´ve checked if we've been blacklisted or anything but we haven't.

Afterwards, we've tried writting random letters and numbers in SMTP server and SMTP user, and the popup stills says that the mail has been sent.

We would appreciate any help to find a solution.

Thank you!!

It may be that you have set your email to go to a file. Check your civicrm.settings.php (mine's in sites/default under the Drupal root).

Look for the lines referring to CIVICRM_MAIL_LOG and make sure the define statement is commented out.

The comment on CIVICRM_MAIL_LOG says ...

  This setting logs all emails to a file. Useful for debugging any mail (or civimail) issues. Enabling this setting will not send any email, ensure this is commented out in production. The CIVICRM_MAIL_LOG is a debug option which disables MTA (mail transport agent) interaction. You must disable CIVICRM_MAIL_LOG before CiviCRM will talk to your MTA.


Send different event confirmation emails I have setup 2 different events. I would like to send different confirmation emails for the events with the relevant information. This hasn't been an issue before because I have only ever ran 1 event at a time and have edited the Events - Registration Confirmation message template with the relevant information.

Make two different Message Templates yourself and use CiviRules (also requires Email API extension) to send out the correct one based on the Event someone registers for.

If you need payment details as well then make your default CiviCRM Event Registration template just contain the default bits like profile and payment/receipt details.

The second Email via CiviRules/Email API will contain the Event specific information.


Failure in setting up replies mailbox CiviCRM 5.14.0
I am using the Sparkpost extension
This is a new site in testing phase

I have set my from email address to be: "Site Administrator"  This domain has been verified by Sparkpost and is a working mailbox.

If I set up a mailing and click on Track Replies in the response tab, I get this message:

The "Track Replies" option conflicts with the "Reply-To" option. The "Reply-To" option has been disabled.

I assume that this is just a warning that the system will not use the "From" email address for the reply.

When the recipient clicks reply in the email client, the reply address looks like this:

r.105.160.ac5032573de28c3c@vietfeir.com

This address obviously does not exist on in my Postfix virtual_users table. I also believe it should be r.105.160.ac5032573de28c3c@ccrmmail.vietfeir.com and use the domain of the From address.

I changed the reply address to r.105.160.ac5032573de28c3c@ccrmmail.vietfeir.com and got this error.

An error occurred while sending mail. The mail server responded:
5.1.1 <r.105.160.ac5032573de28c3c@ccrmmail.vietfeir.com>: Recipient address rejected: User unknown in virtual mailbox table.
 Please check the message recipient "r.105.160.ac5032573de28c3c@ccrmmail.vietfeir.com" and try again.

Now, ccrmmail.vietfeir.com is a CNAME that points to sparkpostmail.com but it is still being rejected by my Postfix server.

I'm not sure what to do to fix this.

I changed the address to include a local part so VERP. This now works


auto-renew required is not enforced I have auto-renew required set in my membership types, but users are able to uncheck this and continue to join as non-auto-renew.   I've cleared all caches server and client side.

Since it's required, I'd expect to see a red asterisk next to the checkbox, or see that the checkbox checked, and greyed out.  Neither of these happen.

Is there something else I need to set other than the setting in membership types?

Thanks

Affects versions:

Civi 4.6.23

Civi 4.7.13

Drupal 7

This is a bug affecting versions 4.6.23 and 4.7.13.

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


How to overwrite template file using php? I want to override predefined template file in my extension.How to do that using php?

Hardcoding cusomised templates into extensions is in breach of extension development standards and can break on upgrades. Prevention of errors is an important priority to most developers to take pride in their craft and care about their clients.

The answer in your extension is to include the modified file in the path form template/CRM/path/to/template.tpl.php - but please find a better way. Civi users deserve great products that they get from other services, not this.


Displaying the full state or County name in Profile Listing I'm sure there is a simple solution to this that I'm missing - I have a custom profile that I'm setting up as a searchable directory that has a number of address fields displayed in the results
Country, State, city. - Home
Country, State, city. - Work
Country, State, city. - Other

The State field is returning as an abbreviation, or in the case of somewhere like France - a number.
Is there a way to display- (or retrieve given the returned value ) the full state name?

Turns out the solution was one I'd be staring at for a while.

Administer > Localisation > Address Settings

change the Address Display for state/ province from {contact.state_province} to {contact.state_province_name}


Getting data automatically from CiviCRM to Google Spreadsheets? Is there an easy (semi-)automatic way to get data from CiviCRM to Google Spreadsheets?

Data on CiviCRM side could come from search results (smart group) or a report.

On Google Spreadsheets side I would like to import data in specific document and replace particular sheet. Other sheets would then contain formulas to retrieve and process data from the imported sheet.

I would like the whole process to run it with a single click or even time-based (cron) to save time and eliminate human error in the process of exporting and re-importing regularly.

Has anyone seen or made anything similar?

You might want to check out this recording of a CiviCon session? https://www.youtube.com/watch?v=6K3awPdA7h0. Not sure if it will answer all your questions but I am sure it will give you a good idea :-)


Creating your own tokens page content gone Has anyone else noticed the content of this post no longer shows?

https://civicrm.org/blogs/colemanw/create-your-own-tokens-fun-and-profit

I'm trying to write a token to use the contribution note as a smarty variable but would like to review the tutorial. ..

At a minimum, here is some information (and example code) pulled from the blog post.

http://wiki.civicrm.org/confluence/display/CRMDOC/Customized+%28and+Custom%29+Tokens

Update: here is a link to the cached  version of the blog post that has the content: http://webcache.googleusercontent.com/search?q=cache%3Ahttps%3A%2F%2Fcivicrm.org%2Fblogs%2Fcolemanw%2Fcreate-your-own-tokens-fun-and-profit&oq=cache%3Ahttps%3A%2F%2Fcivicrm.org%2Fblogs%2Fcolemanw%2Fcreate-your-own-tokens-fun-and-profit&aqs=chrome..69i57j69i58.7385j0j4&client=ms-android-verizon&sourceid=chrome-mobile&ie=UTF-8


Priceset fields do not appear on CiviEvent form (field notes do) | Backdrop Apologies if I am missing something fundamental here - I'm pretty sure I am, but just can't work it out:
I have an event registration form for public. As admin user logged in, form appears fine. As public (no user login/private window) profile fields appear OK. However, priceset fields only show the field notes; field label, input field and price field do not appear.

Details of event form:
- Additional delegate registration in addition to self enabled;
- Simple profile with personal contact information and employer field from Organization
- Relatively detailed Priceset with field notes - all fields enabled for public
- usual Drupal/Backdrop civi permissions enabled for public event forms (profile create, custom data, register for events, view event info, view event participants)
- No payment processor (pay later only - invoices enabled).

CiviCRM 5.17.4
Backdrop 1.14
tested in Firefox and Chrome - same issue.
environment: shared hosting (WebhostUK - Linux Business Cloud Webhosting)

Edit: adding screenshot

As had no data to speak of in db, dropped tables in Civi db and reinstalled CiviCRM. Replicated form and works as expected.


WordPress "Billing Name and Address" fields block not displaying On our contribution page, I can select the amount and confirm, but then on the final screen the Billing Name and Address fields block does not display at all.

This site was hacked prior to me working on it. I ended up restoring a backed up version of the plugin folder and the "files" folder. Now everything is working fine.


All CiviCase Functionality Gone Despite Component Being Enabled All the CiviCase functionality has gone in our CiviCRM D7 (version 5.34.0) website even though the component is enabled. All the menu items for CiviCase are not there. I have flushed all caches, reset paths and reset menus. I have disabled and re-enabled the component but this all makes no difference. If I go to /civicrm/civicase it redirects to /civicrm/admin. There don't seem to be any relevant error messages in the CiviCRM log or in the Drupal log. The CiviCase permissions are still present in Drupal.
Can anyone suggest any further troubleshooting I can do?
All other components and everything else is working fine. As far as I know there have been no significant updates to Civi either (no new extensions enabled etc)

it sounds like a permission issue - please check they are set for the roles being used.


PCP confirmation email doen't contain user-login details. [ Drupal ] After creating a PCP page this email (message template) is sent to user who has contributed and created a PCP page.

  Dear supporter,

  Thanks for creating a personal campaign page in support of [Contribution page name]. Promoting Your Page

  You can begin your fundraising efforts using our "Tell a Friend" form:

Login to your account
Click this link and follow the prompts

  Managing Your Page

  Whenever you want to preview, update or promote your page:

Login to your account
Go to your page

  When you view your campaign page WHILE LOGGED IN, the page includes
  links to edit your page, tell friends, and update your contact info.

  Questions? Send email to: info@example.org

My question here is,

How user can login to site since I see that there is no new user created on the site. I am not sure how this works for other but without any user creation they won't be able to login to site or edit their PCP page.

Please correct me if I am missing something here, I think user should be created and one-time-login url should be sent to user on the same email (message template).

Site had a configuration Who can register accounts? as administration only because of which I was not getting the screen where the user will be created before you fill PCP informations. After I changed the settings everything seems to be working fine.

Configuration page link: example.org/admin/config/people/accounts


CiviCRM Message Templates link changed, cannot find We recently upgraded to 4.6.3, and the page message templates live at seems to have changed: the link in our menu bar (https://secularstudents.org/civicrm/admin/messageTemplates?reset=1) is returning a page not found error. All of our message templates still exist. Any suggestions on where to find them so I can change the navigation link to work properly?

CiviCRM 4.6 has a new permission to edit templates separate from "Administer CiviCRM", and I'm almost certain the issue you're having is that you need to add permissions post-upgrade.

From your URL, I'm pretty sure you're running Drupal (and I think I knew that anyway!) so go to http://secularstudents.org/admin/people, select the "Permissions" tab, and locate the permission called "Edit CiviCRM message templates".  Check that off for the appropriate roles and press "Submit" at the bottom of the page, the problem should then be solved.


What are best practices for deploying changes? I'm looking to set up best practices for a development workflow (i.e. dev > staging > production)

In Drupal there is features, which allows you to export your configuration into code and then deploy it.

What are people using when doing this in CiviCRM?

In larger projects we tend to put configuration stuff (like setting up contact_sub_types, activity_type, case_types, groups, tags etc.) in a specific config extension that can then be deployed in each environment.

When doing so we tend to put the configuration into json files. But there is nothing like features as far as I know.


Crons are running but system status page says otherwise I am hosting CiviCRM on a shared server with CPanel with latest CiviCRM and Wordpress versions.  I have created cron jobs for all active crons using wget. e.g.

wget 'https://domain.org/wp-content/plugins/civicrm/civicrm/bin/cron.php?name=NAME&pass=PASS&key=KEY&job=cleanup'

Crons are running and the last run times on the scheduled job page are updated for my active jobs but the system status page lists the last time cron ran to be when I last ran all jobs manually.

Is there something else I should do?

You do not need to have a separate cronjob for each job: on the admin interface, set the frequency for each job you want to (nightly is good for most of them, but the one that process the mailing and handle the bounces are better run hourly or more frequently)

And then if you wget without the "job=cleanup" it will automatically try to process all the ones that you have enabled... and should properly log that they were processed


I need to export or copy CiviCRM structures such as membership types, contribution pages and price sets to another website (Joomla) I am rebuilding a Joomla website with a corrupt database. I would like to recreate the CiviCRM structures in the new website. That would include membership types, price sets and contribution pages.

There are a few approaches, none perfect. It would be great to be able to export config of entities and load that into another site / instance.

It's possible to write code to generate the various entities using the CiviCRM API. This can work, but probably has higher up-front time costs than option 4 below. It's what I'd most likely do if I wanted to be able to test the deployment of changes and had a medium-scale budget.
CiviCRM offers a hook (hook_civicrm_managed()) which you could use to configure your site with the various entities mentioned. This has some challenges, eg it "locks" the managed entities to the extension in question - disabling that extension in future might then remove the managed membership type, potentially affecting recorded memberships and so forth. (I'm not sure whether editing managed entities is permitted, either?)
It's possible to export the SQL entries which relate to the specific values you want, but you'd need to match up the IDs for the entities (memberships, contribution pages, price sets and options etc) on loading. Kinda ugly.
You can click your way through the config. I'd guess you're asking this because you think there should be a more reliable way to deploy configuration ... as of today, I don't think there is. This is your low budget option.

One important factor is that these entities may need to be created in a specific order to handle dependency, since the priceset / options may relate to the membership type, and that membership type may relate to an organisation contact, and ...

This is a question which has been asked before, but IMO hasn't as yet been solved well. These previous SE questions might offer some insight?

How can CiviCRM manage and deploy configuration?
What are best practices for deploying changes?
Advice on moving CiviCRM Configuration only when launching a new site


How to get contacts in children of a parent group using the API I have a child groups C and B, each with 20 different contacts in them. Both child groups are in parent group A. I need to find all contacts in all children of A since C and B might be removed later or new children added to A. But A will not change. However, Group A is not itself populated. As a result, the CiviCRM API returns 0 results. Is there handy API method which will help me out?

API Command:

 $result = civicrm_api3('GroupContact', 'get', array(
  'sequential' => 1,
  'group_id' => "Donors_74",
));

Actual results from the API explorer:

{
"is_error": 0,
"version": 3,
"count": 0,
"values": [

    ]
}

Expected result: 1676

We are using CiviCRM 4.7.25.

You can use the 'group' filter on the Contact api to get members of parent groups.

$result = civicrm_api3('Contact', 'get', array(
  'sequential' => 1,
  'group' => XX,
  'options' => array('limit' => 0),
));

where XX is the id of the parent group (A).