Relative date filter possible in api? I was wondering if it is possible to use (custom) relative date filters with the api?

For instance to find all participants of events in the current or last fiscal year.

Would save me a lot of trouble :-) Thanks fort thinking along!

Not sure what you mean by "custom" relative date filter, but if you're looking for filtering the results just like we have on the "Find Participant" form, then yes, looks like it is possible.

Eg - To find all participants registered in this fiscal year can be retrieved via -

i.e, select Other in the Parameter dropdown and enter participant_register_date_relative in the textbox as shown above.

The API that will be formed is -

$result = civicrm_api3('Participant', 'get', [
  'sequential' => 1,
  'participant_register_date_relative' => "this.fiscal_year",
]);

Similarly, for Previous Fiscal Year, enter previous.fiscal_year in the value field.


How do I flag an extension which no longer works? just to save anyone else some time.. I tried one  and couldn't get it to work.  I contacted the author and he confirmed it doesn't work and wont be updated.

so to save the next person going down the same route.. can I flag it?

Is this an extension that is published in the CiviCRM extension directory? At the moment I do not think you can flag an extension as not working, but it would be nice if the author removed it from the extension directory if he/she agrees it no longer works.

If it is a case of it does not work with version 4.7 but it does work with version 4.6 that will show on the extension page where the supported versions are mentioned. But IMO that is not a 'it does not work', more a 'it does not work with my version'.

I think you should add a little more information about your statement?


Why am I getting mangled menus and why can't CiviCRM find its own /ext directory? My composer build D8/CiviCRM instance looks great on my local server where I built it - but then when I add it all to git and push it to a production server -> it looks like this: menus are messed up and CiviCRM is not able to find its own extension directory that it ships with.

When you install D8/CiviCRM with Composer you end up with CiviCRM's .gitignore file in the vendor/civicrm/civicrm-core directory. Renaming that .gitignore outoftheway solves the problem. No civicrm.settings.php file edits required! Of course you can be more selective but think of not ignoring bower_components as well as the /ext -> that's what solved this issue instantly.


CiviRules is not tagging users or adding them to groups Civi 5.13.5, Drupal 7.67.

Hey everyone,

I've set up a number of CiviRules to help automate the process and add people to groups / tag them based on the types of events they attend, so they get added to our different mailing lists.

We're having issues with two of our CiviRules.

Volunteers

As above: we have events that are marked as "Volunteer Inductions". People who are marked as having attended these events are meant to get added to the Volunteers group/mailing list, removed from the EOI group, and have a tag added.

None of these actions happen, despite all the conditions being fulfilled. The actions are all set to have 'no delay'.

Event Attendees

As above: when people are marked as having "Attended" a certain event, they are meant to be added to a corresponding group/mailing list.

However, again, despite meeting these conditions, this does not happen. The actions are set to have 'no delay'.

**

Does anyone know why this is happening or how we can fix it?

Thanks in advance :)

The first thing that strikes me is the trigger is "participant is added". That means it is only done for new participants, not for existing ones. Should it not also do this for changes to participants?
Personally I have not done anything yet with the event participant trigger, so I would focus on testing that one first.

I do regularly use tagging of contacts and adding to group actions, so I know that these actually do work, the problem lies elsewhere. Next week we have planned a small CiviRules sprint, I will have a go with these examples.

Okay, here are my test results.

Test 1:
This is the rule I have entered (and apologies for the Dutch in some places):

If I now register a contact for the event and immediately give them the status "attended" this works like a charm:

Obviously this will NOT work when I register a participant with the status "registered" and then later this is changed to status "attended" as the participant already exists, so the "participant is added" is not triggered. To deal with this I have a second rule on "participant is changed":

Again, this changed rule works like a charm.


howto install l10n autofetch The l10n autofetch extension sounds great but I can't find any hint how to install it. Everybody seems to assume that this is self evident. Where should I put the downloaded folder? It contains only 4 files and I red the readme but it is still a mystery to me.

https://github.com/cividesk/com.cividesk.l10n.update/

Can anyone shed some light on this for me?

The l10n update extension has not been compatible with CiviCRM since version 4.7 of CiviCRM was released in 2016 there does not appear to be any concerted effort underway to bring this extension up-to-date for CiviCRM 4.7+

Source: https://github.com/cividesk/com.cividesk.l10n.update/issues/3

You can still install language packs into CiviCRM as before: https://wiki.civicrm.org/confluence/display/CRMDOC/i18n+Administrator%27s+Guide%3A+Using+CiviCRM+in+your+own+language however the l10n files will need to be updated manually when CiviCRM itself is updated.


How to automatically add contacts to a group that matches the ACL? I've got ACLs set up. Certain users can only have access to contacts in a particular group.

The problem is that when this user creates a contact they have to remember to add the contact to that group, otherwise they cease having permission to view/edit that contact the moment it's created.

Obviously this is clearly their fault, but realistically it's going to be a real paper cut in the system, leading to frustration and also lots of duplicate contacts as they just try again with a new contact.

I'm thinking of writing some code that either automatically adds contacts created into an appropriate group based on the user's access groups, or some hacky javascript thing that pops up a "Oh, you've not added them to a group - did you forget?" confirmation message.

But I suspect this problem's been found before and possibly dealt with a different/better way?

As I didn't hear from anyone, I figured I'd just write the extension.
Artful Robot's AutoGroup Extension is here for your delight and delectation.
From the README:

This extension allows you to choose a set of groups which will be added to new contacts if the logged in contact is also in that group.
e.g. If Staff member Wilma is in the group 'Region: Birmingham' and Wilma adds a new contact, it can automatically add the new contact into 'Region: Birmingham'
group.


Purchase package of event registrations I'd like to offer Contacts the ability to purchase a package of six event registrations that can be used over the course of a year. Can anyone suggest how that could be accomplished?

I've never seen anything like that done. The only thing I can think of off the top of my head:

Create the ability to purchase the package. You could do the page through a contribution page.

Create a discount code (you'd need to install the extension for discounts) that is specifically for them. Make it a 100% discount. Give it 6 uses.

Email them the code. Be sure they understand that it's specifically for them and can only be used 6 times. If they share it, then they're losing registrations they paid for.

Then they can register for an event and use the code to have it fully paid for.

This will take some manual work on your side (creating the code, sending it to them).


Our CMS is Expression Engine. Does this mean we can't use CiviCRM? Is it possible to use CiviCRM when we have a website built with Expression Engine rather than Joomla, Drupal or WordPress?

Thanks

Karen

You would not be able to have direct interaction between Expression Engine and CiviCRM like Drupal, WordPress or Joomla allows, but you could certainly install CiviCRM on a subdomain of your current website along with one of those three and use it on the subdomain. See https://civicrm.stackexchange.com/a/9385/105 for some great thoughts regarding this.

If you had developer support (your own or hired) you could use CiviCRM's API to have certain information from CiviCRM available on your current website.


Scheduled jobs cron not working properly We use CPanel to run crons on our sites. The cron had been working fine and then stopped some months back. I've tried every example I can find, but it still is not running properly.

I've attached a screenshot of what the cron looks like in CPanel as well as the cron in text (redacted to remove personal info). The username, password, and key are all letters/numbers - no special characters.

wget -O - -q -t 1 'https://www.DOMAIN.org/sites/all/modules/civicrm/bin/cron.php?name=USERNAME&pass=PASSWORD&key=KEY'

Since you're using a wget-based cron, there should be a corresponding entry in the web server log for each cron run.  Look to see the Apache value - does it return 404 or 500 or maybe something else?  404 would indicate a wrong URL; 403 would indicate it's blocked, perhaps because of the user agent (iThemes Security for WordPress does this in its default configuration).  A 200 or 500 would mean to check the CiviCRM log in ConfigAndLog.


Mosaico: Unable to drag and drop images into Versafix template I'm running civiCRM 5.28.3 on Joomla 3.9.21 with Mosaico version 2.5.159...
When I try to drag an image into a content block, the dropzone in the content block resolves to a small square, and I cannot drop the image into the content block.
Here's a short video showing the issue:
https://www.dropbox.com/s/v0wzy3ttw6crv1m/Mosaico%20images%202020-08-27_15-24-53.MP4?dl=0
Anyone have some insights into how to resolve this (or how to debug it)?

If you are in Joomla and want to edit the mosaico template, than make sure that you are logged in front end and backend of the website.
HTH
Pradeep


Webform CiviCRM: Issue with Membership Options Not Displaying (This has been replicated both on a Civi 4.6.19/Drupal 7.50 site and a Civi 4.4.6/Drupal 7.37 site, with the following versions of Civi Webform 7.x: 4.10, 4.14, 4.15)

We have a webform connected to a contribution page with membership options - not a priceset, just selected membership options from the membership types stored in Civi.  The membership options are not showing up on the payment page, as seen below so the user cannot make a selection of membership type.  Is this standard Civi webform behavior?  If not, is there some setting or permission issue that we can modify?

Look for them on the Start page - and make sure you have configured the Membership (under the Webform tab) - as a user select. Note here you can also decide if you want live options or static - and if you go static you can decide which ones are available.

Add on:
Before all this you will want to get into the Membership section under the Webform -> CiviCRM tab.


CiviCRM 4.6.3 - [CiviContribute] - Option to automatically email a receipt for a contribution In CiviCRM 4.6.3, I do not see an option to automatically email a receipt for a contribution, when manually entering a contribution via Contributions -> New Contribution.

Why is the option missing?

Is this for one contact or for all contacts?

If for just one contact,  are you sure they have an email address in their contact record and that the communication preference "Do not email" is not set?


Price is not showing up on the registration page after Joomla to Wordpress integration So I'm moving my site from Joomla! to Wordpress, and I need to move my CiviCRM database and everything related to it. I did manage to do that by installing the same version of CiviCRM on Wordpress as the one i was using on Joomla(4.7.14) and than copying the civicrm database. All the data is there, all the pages, all good. The only thing I have issues with is the Price(Fee) field, it is not showing up on the Registration pages for some reason. I added some screenshots how it looks like on frontend and backend.

Any help you can provide would be more than welcome, thank you in advance!

I'd try upgrading Civi to a more more recent version.

If that does not fix it, I'd look for a plugin/theme conflict. Disable all plugins except Civi and try it. If it works, start enabling plugins until it fails again. If it still does not work, try a basic WP twenty-something theme and see if it works.


CiviEvent - Unable to select profiles - get 'custom field is not assigned to the event' warning even though no profile selected Possibly since the last versions of 4.6 but certainly in 4.7 we're unable to select any profiles for the online registration screen for events. Even for a new event we get the "The selected profile is using a custom field which is not assigned to the "Event" being configured" warning, and we can see only two profiles (Discount Codes and End Dates) - we get this warning even though at this stage we haven't picked any profile.

This is Joomla 3.4.8 and Civi 4.7.1. It's a default Joomla template and I've removed all Civi extensions for the moment. I'm accessing as a SuperUser so it isn't a permissions thing.

Unfortunately the demo server is running Civi 4.6 so I can't try to replicate the issue there.

Any suggestions where I should look?

I had a very similar issue and it was caused by CiviRules. I disabled CiviRules and it worked fine.


Is a contribution always a donation or could it be a receipt from other(s) to one Member or contact? Is a contribution always a donation or an amount from any Membership or could it be a receipt from other(s) to one Member(ship) or contact?

Hard to be sure I quite get the question but you can apply a Soft Credit to imply that a payment came in from one contact  but should be recorded for another.

Also, you can have one Contact purchase a membership "on behalf of" an organisation.

Best that you clarify what you are trying to do by editing your question of neither of my points are helpful.


Custom Data: Multiple Contact References What is the easiest way to add a custom field that contains multiple contact references a la Activity Target Contacts.

I.E.

Custom Data:::::Extends Organizations
Field Set Name: Investment Round

Custom Field 1 Title: Amount Raised
Custom Field 1 Type: Money

Custom Field 2 Title: Raised Date
Custom Field 2 Type: Date

Custom Field 3 Title: Investor(s)
Custom Field 3 Type: Contact References

If this doesn't exist as a quickhack I could consider working on this if there was support for the idea. It seems like it would involve creating a helper table with the following columns.

CREATE TABLE `civicrm_custom_contact`(
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Custom Field ID',
  `custom_field_id` int(10) unsigned NOT NULL COMMENT 'FK to civicrm_custom_group.',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'FK to civicrm_contact.',
  PRIMARY KEY (`id`),
  UNIQUE KEY `field_contact_id` (`custom_field_id`,`entity_id`),
  KEY `FK_civicrm_custom_contact_custom_field_id` (`custom_field_id`),
  KEY `FK_civicrm_custom_contact_contact_id` (`entity_id`),
  CONSTRAINT `FK_civicrm_custom_contact_custom_field_id` FOREIGN KEY (`custom_field_id`) REFERENCES `civicrm_custom_field` (`id`) ON DELETE CASCADE
  CONSTRAINT `FK_civicrm_custom_contact_contact_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=170 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

making a table which looks like

    id| custom_field_id | entity_id
    1 | 12              | 123
    2 | 13              | 4232

id is the primary key,
custom_field_id is the foreign key to the civicrm_custom_field table,
entity id is the foreign key to the civircm_contact table.

In this way we could link multiple contacts to a custom field similar to the way multiple contacts are added to an activity.

So, to recap, is there an existant way to do this, and if not, would anyone be interested in working on this with me?

It looks like they are activities (new type investment), with a custom field (amount) and that should get you covered without the need of coding anything.

As for the reporting, as you know sql, I would suggest you to create a custom dataviz using https://civicrm.org/extensions/civisualize-missing-data-visualization-extension (you'll need a bit of javascript to do the graphs, but that's a handful of lines)


Membership signup/renewal erroneously reports missing fields after upgrade to 4.7.3 Recently upraded to CiviCRM 4.7.3 on this site: http://oaem.ca/

After the upgrade, the membership signup and renewal process is broken in the following way.

The signup/renewal form at https://oaem.ca/civicrm/?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=1 now includes an additional "Organization Details" form, which is not set in any profile, and which is not wanted. It appears to conflict with the membership data that I want to collect, and which is collected using a custom contribution profile.

Filling in both forms appears to work at first, but when the user reaches the confirmation page, they see this report:

Please correct the following errors in the form fields below:
Organization Name is a required field.
Phone (Main) is a required field.
Email (Main) is a required field.
Street Address is a required field.
City is a required field.
Postal Code is a required field.
Country is a required field.
State/Province is a required field.

So the additional data on the 1st screen does not get passed to the final screen.

This persists even if I switch off the the custom profile form in an attempt to use the 'default' form which is being added.

This is what the screen used to look like (compare with current page)

Any suggestions as to what is wrong and how to fix it very gratefully received.

This may all be stuff you already know.

If you have a look on the Title and Settings for that page eg

civicrm/admin/contribute/settings?reset=1&action=update&id=1

you should see that you have 'allow individuals to contribute 'on behalf of' an organisation' ticked. And below that it should specify the Organisation profile in use. You can either Edit it via that page, or go direct to Profiles.

NOTE: at civicrm/admin/uf/group?reset=1 it may be on the Reserved Profiles tab, which might be why you aren't seeing it.

on the page at https://oaem.ca/civicrm/?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=1 I do not see the 'on behalf of' checkbox which I do see on your old screenshot - is that because you have now made it required?


Can't add New Events "From Template" after upgrade to 4.6 After upgrading from Civi 4.4 to 4.6.7, we no longer have the capability to add a new event from an existing event template.

To replicate:

1) Visit Events > New Event
2) On the "New Event" page, select an existing template in the "From Template" box

Expected behavior:

After OK'ing a "you're navigating away" browser dialog, the "New Event" page reloads with most fields completed based on our existing template.

Current behavior:

Nothing happens.  Nothing shows up on the browser's JS console.

I tried changing themes to make sure it's nothing in our theme's JS.

Any suggestions for further troubleshooting?

Thanks!

Other suggestions that might help add clues:

confirm if you have similar problems with creating Events from templates you created post upgrade. Ie is this problem only relating to templates that existed prior to the upgrade
if any of your clicks result in a pop up box, instead of clicking, right click, open in 'new tab' then continue, that way you should see errors/backtrace (assuming you have this turned on from Admin > System Settings)
compare behaviour between your system and the civicrm demo site.


is a certain report available? I am the Treasurer of small not-for-profit organization and we use CIVI for our donations database.  I see that CIVI has a "Repeat Contributions" report that can show a comparison of total $$ donated amount by person for two consecutive years.  This is good; however, I would like to see ONE report that lists the total donations for each person for our 5 years; that is, think ....column A has the name, and Columns B,C,D,E,F shows the annual contribution amount for that year.  Can this be done?  and if so, how?
Thank you - Mary - (Treasurer)

The Aggregated Household Contributions extension by Allen Shaw at Emphanos will get you close. It creates a report template for the Contribution Aggregate by Relationship report. The report will show up to 5 years of history by year (you can choose to show less) and a total if you want it. However by default it groups contacts into households, shows the contributions for the individuals in the household, and then shows the total for the household by each year (which is actually a really nice thing to have). If someone is not in a household, it will just show the individual giving history. If you don't know how to load extensions, you can reach out to your sys admin or post another question.


EXACT search on a custom field instead of LIKE How do I do an EXACT search on a custom field – so instead of ending up with “LIKE” %Eastern Metropolitan%, in the search results I have an EXACT match?

I tried “Eastern_Metropolitan” “Eastern-Metropolitan” but I still get this result (with the word LIKE) - i.e STATE_UPPER_HOUSE Like %Eastern_Metropolitan% - which shows “South-Eastern” and “Eastern Metropolitan” also.

Here is how do the search

Advanced Search
•   Address Fields: Australia + Victoria
•   CUSTOM Fields - ELECTORATES:  State_upper_house = “Eastern Metropolitan”
After exporting the file and reviewing it we notice 2 things:
a.  The list contains contacts with state_upper_electorate as “South-Eastern” and “Eastern Metropolitan”
b.  There is an error on the first row of the .csv which not sure what this means;

Warning:  strpos(): Empty needle in /home/righttolife/www/www/administrator/components/com_civicrm/civicrm/CRM/Export/BAO/Export.php on line 621

Hi from across the ditch.

Not clear if your custom field is text or select. Assuming Text (which raises the question of why isn't it select)

You can use Search Builder for this. Search > Search Builder.

Select contact type that your custom fields apply to. Set operator to =

Outcomes:

No matches found for:
Contact Type = 'Individual' ...AND...
electorate freehand = East

1 Contact
Contact Type = 'Individual' ...AND...
electorate freehand = Eastern Metropolitan

Does that help?

Fields are on http://d46.demo.civicrm.org/civicrm/contact/search/builder for the next x(<24) hours


Multiple entries showing on a report For some reason, a particular report shows multiple entries for some users. These users have ACLs applied, so I wonder if that's causing the problem?

When I masquerade as a user with limited access, I don't see a problem, but I've just had this screenshot (photo!) sent to me:

It could all be the same report -> but users could have selected different columns, filters and group by settings;


SQL Syntax Error - When starting civicrm with joomla Please help, i have no idea what is wrong, all is fine until i open civicrm with joomla, it displays sql syntax error, then when I try to look at my db functions with phpmyadmin there will be a whole page of error, i will be kicked out and unable to login until i restart my computer
-joomla 3.8.7
-apache 24
-php 7.2.4
-mysql 8.0.11.0
-civicrm 5.0.1
-phpmyadmin 4.8.0.1

Apr 24 03:27:15  [info] $Fatal Error Details = Array
(
[callback] => Array
    (
        [0] => CRM_Core_Error
        [1] => handle
    )

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

it seems php 7.2 is not compatible with 5.x.x
or i do not know how to do the configuration

i think downgrade the php would be the best solution
but i wonder if there is other answer, and how to do it....

updates:
-downgrade php does not help, same error appears
-downgrade mysql to 5.5 works!


DB Error: no such field in civicrm_api3() (when upgrading to 4.7.1) (Drupal) After upgrading from 4.6.12 to 4.7.1 (with Drupal 7.42), I get the following message when I go to CiviCRM :

CiviCRM_API3_Exception : DB Error: no such field dans civicrm_api3() (ligne 45 dans /home/parst/public_html/drupal/sites/all/modules/civicrm/api/api.php).

(in french)

... and cannot access to CiviCRM

I forgot to run the Upgrade Script (step 11 of the CRMDOC)
When done, everything seems OK.
Thank you John, for reminding me.


Can't find a »Back to search results« link on contact pages When visiting a contact from the results list of a civicrm search, it's possible to navigate forward and backwards through the results set.

Wouldn't it be good to add back-to-list-button which targets the search results list?

I totally agree.

Once good way to do this would be to add a breadcrumb link here:

It was fairly simple so I just created a pull-request to add this to the upcoming 4.7 release.

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


Different Membership fee for each member Our organization have different membership fee (monthly) for each member which can be decided while signup or setup manually.
How can i achieve this ?
Is it possible to create a user dashboard item to display pending membership overdue ?

Jaisal

You can use price set to create options for the membership type and include it on online membership page(Contribution Page).

The contact dashboard does display all membership and payment information for logged in user.

HTH

Pradeep


It is possible to deduplicate contacts entered in a Webform? I haven't found this issue in any other topic, sorry if it's been already asked.

I'm trying to automatically deduplicate contacts which enter to Civi from a registration Webform, but I haven't found a way. Is it possible?

Thanks in advance

They are merged, based on the "Unsupervised" deduplication rules: civicrm/contact/deduperules?reset=1

By default the unsupervised rules for individuals are based on email-only.
So if someone fills in a Webform with an email that already exists in civicrm then those data will be merged.

You can change these rules: http://book.civicrm.org/user/common-workflows/deduping-and-merging/


Wordpress Compatibility with a Civi system currently installed on Drupal We are currently working with a company using Civi on a Drupal site (CiviCRM 4.4.1) and will be developing a secondary site through wordpress to link into the same Civi Account, we were wondering would there be any compatibility issues? Would these systems all work flawlessly together?

What you're describing is difficult - but not impossible - to do.  CiviCRM has a table (civicrm_uf_match) that matches a CiviCRM contact to the corresponding CMS user id - which is pretty difficult to line up if you have multiple CMSes!  There's also settings in civicrm.settings.php that define the CMS, which is necessary for, e.g, creating a URL that's correctly formatted for the CMS in question.

You might want to see if just passing form data from Wordpress to CiviCRM meets your needs.  If you're absolutely committed to the path you're suggesting, a good place to start is here.


How to pause, cancel or delete a scheduled CiviMail mailing I suspect I'm missing something obvious here... but I've just spent 30mins googling without success.

So... if you've scheduled a mailing in Civicrm, how can you pause, delete or cancel it?

On the main search screen for mailings, https://druyoga.com/civicrm/mailing/browse/scheduled?reset=1&scheduled=true, you can search for various mailing statuses, including paused and cancelled.

But I can't see a way to change a mailing's status to cancelled or paused.

Thanks for any ideas.

We're using drupal 7.54 and Civicrm 4.6.24

If you search for mailings (Search>Find Mailings) and check 'Scheduled' when results com up on the far right there is an option to 'Cancel' under the 'more' menu.

I assume you can pause by searching for 'running' mailings and looking under the 'more' menu but I can't verify as I don't have a running mailing right now.


Customise Receipts How to? In Find contributions> actions: receipts print or email> how would I customise that wording / graphics for that choice

Try under Administer > Communications > Message Templates. From there you can look in "System Workflow Messages" for the receipt templates.

More about templates is in the docs.


Send PDF email through CiviRules I am having trouble using CiviRules to send PDFs automatically using
PDF API for CiviCR. Namely, when I create condition and I need to add action Send PDF there is to email parameter. I want this to be created dynamically like send Email action picks up email from contact automatically.

When I leave it blank the email doesn't go through.

  [info] Civirules api action exception: Mandatory key(s) missing from
  params array: to_email. API call: Pdf.create with params: to_email="",
  template_id="74", contact_id="752"

I can't insert a token into that field. So, am I missing something obvious or is this functionality intended for a totally different purpose?

I ended up hardcoding it so it uses $contact['email'] instead of $params['to_email']

I am leaving it open for some time, if anybody has a better idea (or if I missed something obvious)

UPDATE:

The developers of the extension included this feature. Using version 2.0 the PDF will be emailed to the associated contact if the to email field is left empty. So no need for hacks anymore. Big thanks to ErikH - CiviCooP


Pledge payment link does not point to a publicly accessible page The reminder email for pledge payments includes a link that points to a page on the admin side of wordpress that requires a login. How can I change this setting in CiviPledge to point to a publicly accessible page?

Here's a sample of the link

In response to comments below:

1 - I am using the default message template for Payment Reminders.

2 - The Old/New Base URL in Settings - Cleanup Caches and Paths shows "https://lofcenter.org/"

3 - The civicrm.settings.php shows the following:
if (!defined('CIVICRM_UF_BASEURL')) {
  define( 'CIVICRM_UF_BASEURL'      , 'https://lofcenter.org/' );

This answer is for how to change the template issuing the email in question.  However, I don't know that the issue you're facing is due to the template.  See other answer.

The template for Pledge Payment Reminders is found in Communications or CiviMail's settings.

From the black menu bar:

  Administer > Communications > Message Templates

OR

  Administer > CiviMail > Message Templates

On the Message Templates screen, click on the tab at the top for "System Workflow Messages."  Scroll down and you should see an edit link for "Pledges - Payment Reminder."

On that edit screen, you can make any changes you need including changing the link.  Don't forget to make your changes in both the HTML Format and Plain-Text Format.

Before making your changes, I'd recommend copying and pasting the default template to a text document just to have it saved in case you need to revert back in the near future.


How to assign a Contribution to a different contact or otherwise have the receipt go to a different contact A contribution is made by Contact A, but they require the receipt to go to Contact B. What other option is there other than deleting the Contribution record and creating a new one for Contact B.

I have re-read about Soft Credit but see nothing that offers this functionality.

With access to the DB we can update the record (and associated Activities) directly but not ideal.

Is there any 'transfer Contribution' type feature or extension anyone has come across? There was an "I am making one" comment here

A long time after the question was asked ... but see https://civicrm.org/extensions/move-contribution


Use CiviCRM tokens in Drupal welcome e-mails? I have a site set up using a Drupal rule to create a new user account when a new membership is created.

The new account creation triggers a Drupal welcome e-mail to the user, as defined in the Drupal Account Settings, so it's populated using Drupal variables, e.g. 'Dear [user:name]'.

I'm using e-mail addresses for Drupal usernames, but I don't especially want our welcome e-mails to be addressed using only e-mail address. Is there a way to use CiviCRM tokens in Drupal welcome e-mails, so I can address them by name from the contact record?

Even better, most of our individual users inherit their membership from an organisation. If the above is possible, is there also way to use a CiviCRM token to refer to the primary membership? So, for example, I could write something along the lines of, 'An account has been created for you because of your volunteer role with [parent organisation]'?

You might be able to do something with Drupal Entities and Drupal Tokens. You would replace the default welcome emails with one created by rules. CiviCRM Tokens are used exclusively within CiviCRM.

-Josh


How can I speed up CiviCRM on Wordpress Hi I've installed CiviCRM on Wordpress. The Wordpress side of things run smoothly and fast. But inside the administration area of CiviCRM adding contacts, and any other administrative functions takes around 45 seconds or longer for a page to load or update after saving changes. I am currently using the 2013 Theme for Wordpress.

Are there any tips and tricks I can use to get the Civi side of the site to move faster? Thanks.

We struggled with this initially. Things we went through:

Check the debug console in Chrome to make sure Civi isn't having trouble finding resources - look for 404s in the Source tab. This can slow down Civi tremendously as it waits for them to time out. Can be fixed in the Admin -> Resource URLs / Directories / Update Paths
If you're running PHP 5.3, get APC cache. If you're on 5.5, turn on PHP Opcache (probably with this). With 5.4 you can install ZendOpcache, but if you can upgrade to 5.5 you probably should. This can make a huge difference.
Disable all Civi extensions and see if speed is better. Then turn them on one by one to see if any in particular are being problematic.
Ditto WordPress plugins. These can be deadly - we have a couple that are very heavy-duty (Admin Menu Editor Pro is great, for example, but can slow things down). I take the hit on them, but it's a close-run thing.
Try disabling the cron job and restarting apache (or whatever), just to make sure that's not doing stuff that's slowing everything down.
If you want to get really fancy, there's a WordPress plugin you can hijack to kill all WP plugins loading on certain Civi pages - instructions here.
Also on the server, install memcache and turn on memcache support in the civi settings file. Honestly, this might just be placebo, but it seems a bit faster
Might be worth optimizing the database tables in phpmyadmin, just in case those have gone wrong somehow.
Civi 4.5+ is pretty snappy, so do update if you're still on 4.4.x. [Edit: some big sites have found upgrades to 4.6, then 4.7, then 5.0 continue to improve performance.]
Turn off as many search options as possible in Admin -> Customize Data and Screens -> Search Preferences to see if any of those help (they never did for me, tbh, but others report good results).
Turn off Smart Group caching on the above page by setting it to 0, in case it's running that every 5mins and dragging everything to a halt.
If the issue is that your server is struggling, WP-Super-Cache does a good job of caching WordPress front-end pages so the server can focus on important stuff, and is very configurable.
Make sure mysql caching is turned on.
Check the mysql slow queries log to see if it's struggling to extract data. Normally this isn't a problem, but worth checking.
If all else fails, you might just need hardware resources (memory and CPU), or a VPS, or a dedicated server. We moved onto the latter and it made a big difference.


Which folder to put Caldera forms CiviCrm plugin in? I'm not an IT person so please bear with me.
Trying to install Caldera Forms CiviCRM plugin but not sure which folder to locate it in. Have put it in
/wp-content/uploads/civicrm/ext
via FTP for now but it hasn't come up on the extensions list. But now I'm thinking maybe it should be in a WP folder instead of a Civi one as it links the Caldera form WP plugin to CiviCRM. So I put it in the WP ext folder but still no sign of it in the WP or Civi backend.
Where do I put it? Any ideas are much appreciated.
Just a small charity so trying to wing it on a zero bugdget as much as possible!

Caldera and Civi Caldera is a wprdpress plugin, you can locate them under wp-content/plugins/


Could not create database trigger (AWS, RDS) How can I fix this issue about database trigger. I attached the screenshot for the info. Thanks so much for the help]1

You will need to grant access for mysql user to create triggers. You can run below command in mysql using super privilege user(root)

GRANT TRIGGER ON <db_name>.* TO '<db_user>'@'localhost';

HTH

Pradeep


Mailings -> New mailing gives 404 Not found (NGINX) We've nginx installed as a proxy.  While attempting to start New Mailing
civicrm/mailing/send?reset=1 browser tries to reach civicrm/a/#/mailing/new url, ending with 404 Not Found nginx error. Nginx error log says "httpdocs/civicrm/a/index.html" is not found

It sounds pretty much the same as this question: 'Unknown path' error when trying to access New Mailing with version 4.6.2 , and we've no any modules installed.

However, solution mentioned in first comment  works for us. This is it:

  After changing line 56 in file civicrm/CRM/Mailing/Controller/Send.php like below, it now works.

- CRM_Utils_System::redirect(CRM_Utils_System::url('civicrm/a/', NULL, TRUE, '/mailing/new'));
+ CRM_Utils_System::redirect(CRM_Utils_System::url('civicrm/a', NULL, TRUE, '/mailing/new'));

But the question still is: do we need to perform something at NGINX configuration ( since pure Apache setup doesn't have this issue ) or it's a bug in the core, which should be reported / fixed?

Drupal 7.40 + Civicrm 4.6.9

You have an error with the configuration of your nginx that doesn't properly redirect to drupal /civicrm/a/ but does it for /civicrm/a.

What configuration did you choose for your drupal/nginx?
I started with that one and whitelisted a few more urls (in extern/ folder)
https://github.com/perusio/drupal-with-nginx and it works fine


Fatal error when exporting accounting batch to CSV in 4.7 Using Civi 4.7.2 (and then on 4.7.3; I thought I needed to upgrade to fix) with Drupal, I get the following error when I try to export an accounting batch to CSV:

  Fatal error: Call to undefined method
  CRM_Financial_BAO_ExportFormat_CSV::exportACCNT() in
  C:\xampp\htdocs\test\sites\all\modules\contrib\civicrm\CRM\Financial\BAO\ExportFormat\CSV.php
  on line 68

I then tried both the Drupal and Wordpress 4.7 demos from demo.civicrm.org.  I added three of the demo contributions to a new batch and tried to export to CSV.  Both the Drupal and Wordpress demos white-screened.

I tried the Drupal 4.6 demo at d46.demo.civicrm.org and it successfully exported the CSV.

Did something happen between 4.6 and 4.7 for this function?  Is this a bug that needs to be reported at https://issues.civicrm.org?

It was indeed a bug (filed here: issues.civicrm.org/jira/browse/CRM-18169).  This will be corrected in Civi 4.7.4 by this pull request: https://github.com/civicrm/civicrm-core/pull/7942


How can I record multiple premiums for a contribution? We offer multiple options like stickers and shirts. If someone donates at the shirt level, they can choose to also get a sticker. We don't require them to choose a sticker, but it's an option.

It seems there's no way to even enter this manually to say that person A wants a shirt and a sticker, person B wants just a shirt but no sticker…

What should we do to handle this?

Perhaps this can be achieved through the use of price sets and multiple contribution pages, e.g.:

Main contribution page can be the lowest level premium option with links to the higher levels of sponsorships, each level is its own contribution page
(e.g. main page = Sticker Level, linked page = T-Shirt Level, etc.)
The price set for the sticker level would only include the sticker option at whatever the amount it is that you are requesting as required
The price set for the t-shirt level would include the option to select to receive a sticker with a price of $0, and then the t-shirt level amount that is required

Hope this helps!


Quick and dirty decoupled CiviCRM with cron and export/import? Working with an architecture of Drupal 8 running Open Social, and Backdrop running CiviCRM. Currently both virtual hosts on the same server, with separate mysql databases. The key issue: after tearing up and throwing out several architectures, I am months behind and need to get a demonstration site up and running yesterday, with a functional 1.0 ready as soon as possible—weeks, not months. The snag: I'm new to nearly every component here, with a background in a dozen CMSes and a few CRMs, but not these.

Have been consuming a firehose of information, and nearly every step has a dozen prerequisites that could take a week each. For example: a new member joining the organization needs a user account in both Drupal and Backdrop, with Backdrop integration to CiviCRM. It seems the "standard" method is to do this with API calls, but I'm new to the API and the three techniques the docs tell me I can use. Would be fine if this were January, but not in August.

Problem 2: whatever I build now is likely to be rapidly obsolesced. When CiviCRM is official for D8, we might decide to consolidate under one roof. Or I might be convinced by the increased security of CiviProxy and segregate the full Civi db behind a VPN. (Skipping it for now, I don't have time to learn what's not available yet.)

My question: are there quick and dirty techniques I can use to bypass the more expert methods? For example: export and import I can learn quickly, so if I write a single abstracted function, I can write data to a local file and use a cron trigger to read it into the other side. Boom, I can move data back and forth without resorting to a custom API script for each function. Nearly everything one site does will need to be reflected in the other; I need the simplest way of doing this.

I'm guessing I'll still need APIs for some activities, i.e., logging into the D8 site should be a single sign-on for both sites. (No idea how to do that. Help requested.) And I'm still totally unclear what UI will live where—that is, do I build members-only content in Backdrop, or do I use D8 views to pull in CiviCRM data and present there only? Again—the fastest and simplest is best, even if ugly; there will be time to retool later.

Suggestions? Many thanks, I'm drowning here.

I think I have a partial answer—or at least, a tool that's looking good.

Answering Demerit's comment: both the Backdrop/CiviCRM and D8/Open Social sites are going to have public pages. My original assumption was that D8 would be primary site, with CiviCRM information fed into it—but the last few days of deeper dives into CiviCRM indicates that so much functionality is available there "for free" that I'm likely to make that the primary site, with a secondary community.mydomain.org domain for the social networking aspects. There's just a ton of stuff I thought I would have to custom-build which someone has already included in core.

Still the case that I need a new user/CiviCRM account to create its equivalent on D8, and that single sign-on would be nice. Both domains are subdomains of mydomain.org, so I can tackle that with cookies, but since I have to do account creation anyway, a more elegant approach that allows new domains to be used would be nice (we currently own four). This YouTube video on data integration led me to Pentaho, which looks excellent both for its abstraction capabilities handling any dataset, as well as its scripting interface. Not seeing much point in going through the trouble of learning and implementing SAML if I can do it all in one package. (And for the initial release, there are few methods I could use to avoid all of this—i.e., creating a hash on the primary site that someone has to use to create an account on the second manually, and suggesting they log into both with the "remember me" checkbox turned on.)


membership recurring payments using Drupal webform I have a webform in Drupal 7 that is using CiviCRM integration to allow users to purchase memberships. I'm having a little bit of trouble figuring out what the correct setting should be, and not finding documentation that helps. Here is what I would like to happen:

In the webform, a user selects from multiple membership options.
They may also select to buy a non-membership item.
Either on this page or the confirmation page, I'd like to collect payment information and allow users to opt-in for recurring payments.

Right now, I know how to create a membership page that includes payments, and I can see how to allow membership registration on the webform, but I haven't figured out how to get payment integrated into the user flow. Have any ideas for me, or links to documentation?

Documentation lives here: https://wiki.civicrm.org/confluence/plugins/servlet/mobile#content/view/120029195

In a nutshell - to integrate payment you need to create a civicrm contribution page - enable a payment processor. In the webform civicrm tab select this contribution page - this way webform civicrm will know that you want to process payments, what payment fields to display and which payment processor to connect with.

Re: recurring payment - to my knowledge you can't do this yet. I've started thinking about how to make that happen.


Googlebot & Could not find valid value for id Over the last few years every few days a fatal error is triggered by a Googlebot. Seems harmless and unnecessary but it is possibly affecting ranking.

The errorreport extension (ca.bidon.reporterror) reports:

HTTP_FROM: googlebot(at)googlebot.com
REDIRECT_QUERY_STRING:q=civicrm/event/register&snippet=4&type=
but also sometimes:
REDIRECT_QUERY_STRING:q=civicrm/event/register

The logfile in ConfigAndLog says:

May 17 19:16:31  [info] $backTrace = #0 /home/account/domains/ourdomain.nl/public_html/crm/sites/all/modules/civicrm/CRM/Core/Error.php(363): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/account/domains/ourdomain.nl/public_html/crm/sites/all/modules/civicrm/CRM/Utils/Request.php(95): CRM_Core_Error::fatal("Could not find valid value for id")
#2 /home/account/domains/ourdomain.nl/public_html/crm/sites/all/modules/civicrm/CRM/Event/StateMachine/Registration.php(52): CRM_Utils_Request::retrieve("id", "Positive", Object(CRM_Event_Controller_Registration), TRUE)
#3 /home/account/domains/ourdomain.nl/public_html/crm/sites/all/modules/civicrm/CRM/Event/Controller/Registration.php(47): CRM_Event_StateMachine_Registration->__construct(Object(CRM_Event_Controller_Registration), TRUE)
#4 /home/account/domains/ourdomain.nl/public_html/crm/sites/all/modules/civicrm/CRM/Core/Invoke.php(307): CRM_Event_Controller_Registration->__construct("Event Registration", TRUE, "null", NULL, "false")
#5 /home/account/domains/ourdomain.nl/public_html/crm/sites/all/modules/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:15))
#6 /home/account/domains/ourdomain.nl/public_html/crm/sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))
#7 /home/account/domains/ourdomain.nl/public_html/crm/sites/all/modules/civicrm/drupal/civicrm.module(489): CRM_Core_Invoke::invoke((Array:3))
#8 [internal function](): civicrm_invoke("event", "register")
#9 /home/account/domains/ourdomain.nl/public_html/crm/includes/menu.inc(519): call_user_func_array("civicrm_invoke", (Array:2))
#10 /home/account/domains/ourdomain.nl/public_html/crm/index.php(21): menu_execute_active_handler()
#11 {main}

I have 27 full examples of this now. Probably I'm not the only one experiencing this. What would be a cause of this? And what would be a start of a solution?

Just speculating here, but seems like google is getting the links either from the pages and/or some unknown static web pages.

A possible, but not so great solution is:

a. Create and register a new CiviCRM fatal handler

b. If you detect the user agent is googlebot and/or some other friendly search engines, redirect to main page of site, maybe with a CMS message

c. If not, keep fatal message as is (unless you want to redefine this also)


Missing indices status after upgrading to CiviCRM 4.7.21 on WordPress 4.8 I successfully upgraded to CiviCRM 4.7.21 (from 4.7.17), and everything seems to be working properly. However, I got a critical status error, "Performance warning: Missing indices". After reading How to find and/or fix missing indices? I tried bringing up the status screen to correct the error, but the status screen comes up empty. However, I continue to see "System Status Critical" highlighted in pink near the top of the screen.  (See screenshot below.)

I downloaded the latest log from /wp-content/uploads/civicrm/ConfigAndLog, but I don't see anything relating to indices in it. (Log included below.)

Any ideas where to go from here?

Jul 09 15:58:28  [info] Running task: Cleanup old files

Jul 09 15:58:29  [info] Running task: Begin Upgrade to 4.7.18

Jul 09 15:58:30  [info] Running task: Upgrade DB to 4.7.18

Jul 09 15:58:31  [info] Running task: Update Kenyan Provinces

Jul 09 15:58:31  [info] Running task: Upgrade DB to 4.7.18: SQL

Jul 09 15:58:32  [info] Running task: Finish Upgrade DB to 4.7.18

Jul 09 15:58:33  [info] Running task: Begin Upgrade to 4.7.19

Jul 09 15:58:34  [info] Running task: Upgrade DB to 4.7.19

Jul 09 15:58:34  [info] Running task: Drop Column current_period_opening_balance From civicrm_financial_account table.

Jul 09 15:58:35  [info] Running task: Drop Column opening_balance From civicrm_financial_account table.

Jul 09 15:58:36  [info] Running task: CRM-19961 - Add domain_id column to civicrm_sms_provider

Jul 09 15:58:37  [info] Running task: CRM-19961 - Populate domain id table and perhaps add foreign key

Jul 09 15:58:37  [info] Running task: Upgrade DB to 4.7.19: SQL

Jul 09 15:58:38  [info] Running task: CRM-16633 - Add "Change Case Subject" activity

Jul 09 15:58:39  [info] Running task: Add is_public column to civicrm_custom_group

Jul 09 15:58:40  [info] Running task: Finish Upgrade DB to 4.7.19

Jul 09 15:58:41  [info] Running task: Begin Upgrade to 4.7.20

Jul 09 15:58:41  [info] Running task: Upgrade DB to 4.7.20

Jul 09 15:58:42  [info] Running task: Fix Schema on civicrm_action_schedule

Jul 09 15:58:43  [info] Running task: Upgrade DB to 4.7.20: SQL

Jul 09 15:58:44  [info] Running task: Add activity_status column to civicrm_mail_settings

Jul 09 15:58:44  [info] Running task: Finish Upgrade DB to 4.7.20

Jul 09 15:58:45  [info] Running task: Begin Upgrade to 4.7.21

Jul 09 15:58:46  [info] Running task: Upgrade DB to 4.7.21

Jul 09 15:58:47  [info] Running task: Finish Upgrade DB to 4.7.21

This problem has been raised before and you can view the thread at How to find and/or fix missing indices?

There is also an entry in JIRA at the following link https://issues.civicrm.org/jira/projects/CRM/issues/CRM-20533?filter=allissues

Hope this helps.


Year End Contribution Summary for Donors I'd like to send out to all my donors a summary of all their contributions in the past year.

CiviCRM seems to have a feature that should do that by grouping the contributions per contact when printing out thank you letters but that feature is broken as illustrated here : Table not rendering data properly using new contribution grouping feature

Any work arounds that I am not thinking of?
Thanks

The extension Summary Fields, will give you a token for total contributions per year, which you can use


Adding to a specific group I am creating a wordpress based website with Civicrm. Now users can register by submitting a membership form and they will become member of a group called Free Members. FreeMembers can access a contribution form to make membership fee, after making the membership fee how can I include those members to a group named PaidMembers ?
I am using CiviCRM 4.4 on Wordpress latest version.

There are several possibilities I think. I can think of two:

Use the membership status rules. If the membership is created
initially I reckon they would get the status 'pending', which is
then changed to 'new' (or 'current' depending on your setup) once
they pay. You can use this in Smart Groups to distinguish between
the two. More background in the user guide on memberships This
is for 4.6, but the concepts have not changed dramatically from 4.4
Use the CiviRules extension to get what you want. There is a
wiki explaining what CiviRules can do.

I would prefer the first option as I think you can manage this with core CiviCRM but it would require you to study and configure your membership statusses?


Event registrant cancel/transfer error - getFieldValue failed - in SelfSvcUpdate.php Here is backtrace:
0   CRM_Core_DAO::getFieldValue('CRM_Event_DAO_Ev…', null, 'title') /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm/CRM/Event/Form/SelfSvcUpdate.php:132
1   CRM_Event_Form_SelfSvcUpdate->preProcess()  /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php:602
2   CRM_Core_Form->buildForm()  /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php:76
3   CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Event_Form_SelfSvcUpdate), 'display') /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php:203
4   HTML_QuickForm_Controller->handle(Object(CRM_Event_Form_SelfSvcUpdate), 'display')  /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php:103
5   HTML_QuickForm_Page->handle('display')  /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php:347
6   CRM_Core_Controller->run()  /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Wrapper.php:98
7   CRM_Utils_Wrapper->run('CRM_Event_Form_S…', 'Self-service Reg…', Array) /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:285
8   CRM_Core_Invoke::runItem(Array) /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:68
9   CRM_Core_Invoke::_invoke(Array) /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:36
10  CRM_Core_Invoke::invoke(Array)  /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm.php:1644
11  CiviCRM_For_WordPress->invoke() /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/includes/civicrm.basepage.php:352
12  CiviCRM_For_WordPress_Basepage->basepage_handler(Object(WP))    /home/bbcadmin2016/public_html/wp-includes/class-wp-hook.php:287
13  WP_Hook->apply_filters(null, Array) /home/bbcadmin2016/public_html/wp-includes/class-wp-hook.php:311
14  WP_Hook->do_action(Array)   /home/bbcadmin2016/public_html/wp-includes/plugin.php:544
15  do_action_ref_array('wp', Array)    /home/bbcadmin2016/public_html/wp-includes/class-wp.php:758
16  WP->main('')    /home/bbcadmin2016/public_html/wp-includes/functions.php:1285
17  wp()    /home/bbcadmin2016/public_html/wp-blog-header.php:16
18  require('/home/bbcadmin20…')    /home/bbcadmin2016/public_html/index.php:17
19  {main}

Do you have pid supplied as param in cancel/transfer url? Does the requested participant has event id attached? Does this error is consistent?


Custom Report Template Keep getting message

  Template not found. Could not find the report template. Make sure the report template is registered and/or url is correct.

I followed a guide in setting up a custom report. I created a new custom PHP path and a custom template path. Within both of those the guide said to recreate the path of the original report. ie: /CRM/Report/Form/Contact/then the .tpl placed in there. The path for custom PHP was also the same with the report PHP placed in there.

In the guide it said copy the existing tpl file (in this case it was called Relationships) and then edit it to include the following line:

 *}
{include file="CRM/Report/Form.tpl"}

It then said save it as the new file name. In this case ResidentialCommunities.tpl and refreshed

I then registered the report in Administer>Civireport> Register Report

In the settings under Url it shows /Contact/ResidentialCommunities
Under Class it shows CRM_Report_Form_Contact_ResidentialCommunities

It registers. Then when going to Contact and Contact Reports then add new report it shows under Contact Reports the clickable link to my custom report. Then I click it and it throws the error. I'm certain that there is an issue with the Url field, but can't see why.

Not sure which one you used - but this is still one of the best guides out there:

https://alastaira.wordpress.com/2011/03/17/civicrm-creating-a-custom-report/

Note: the .php goes into your custom_php and your .tpl goes into your custom_templates (and you must set these paths in the Administer -> System Settings -> Directories: Cutom PHP Path Directory and Custom Templates).

After adding these paths and putting the .tpl and .php into place:

Clear caches: Adminster -> System Settings -> Cleanup Caches and Updates Paths - and hit the Cleanup Caches button.


CiviMail does not use the editor set in 'Display Preferences' I'm on 5.17.4 on drupal8 and civimail is working, html editing and all. But I don't know why. CKeditor loads and it's clearly not the drupal one (minimal), but it also doesn't fully match the editor config under Display Preferences. There are no console, server or civi log errors. It does take part of the preferences into account though; I can break the editor by choosing a skin or plugin that's not available.

The pressing problem is that the toolbar does not contain the link buttons and there appears to be filtering involved, so even in the source view, adding anchor elements manually, eventually just filters them out, replacing them with the tag's content. So no way to add html links.

So where is this third config coming from? Would this be the default CKEditor ships with and is somehow used instead of the civi provided one? What are the expected lookup paths?

EDIT: I can even use 'CKEditorCustomConfig' => "adasdada" in Resources.php and it changes nothing. I also tried hacking away what I found of ACF code in the drupal plugin part of CKEditor, but that didn't have an effect either.

You didn't mention the path to the config.js that you're editing, which I think will help people answer your question.

However, my guess is that you are installing Civi using the Roundearth plugin, because that would account for you having two different config.js files. I'm also guessing you're editing the file at <projectroot>/vendor/civicrm/civicrm-core/bower_components/ckeditor.  There's a second config.js at <projectroot>/web/libraries/civicrm/bower_components/ckeditor.  Hopefully this is enough to help you solve your problem.


After 5.18.4 Upgrade, Cases are Missing from the List After Drupal 7.67 and CiviCRM 5.18.4 upgrades, when you click on add a case, the correct screen opens, you can enter data, then save, and the number of cases showing in the constituent summary is incremented, but no new cases show up in a list to be managed. This was previously, for several years on prior versions, working correctly, Also, even for existing cases, the activity dropdown list is not being populated, although they have worked in the past and the Activity Type Options are correctly setup.

So now, in short, the number of cases in the Contact Summary is correct, such as 2 for a certain client, but when you click on the Cases tab, only 1 case appears. CiviCRM was no upgraded to 5.19.0 and the problem persists.

Examining the Case data directly in the database shows no clear reason for this. Furthermore the options for activity_type for the CiviCase component are also in the database and match those of a fresh install.

Has anyone run into this or can you suggest other things I can do to troubleshoot?

The issue here was missing XML files. If you run an upgrade and accidentally override the CiviCase XML configuration files, then this will happen.

The solution is to put back those files and CiviCRM may pick them up and import them into the database. If not, you may need to manually copy and paste the XML definitions into the civicrm_case_type table.


is there a way to share an event post to facebook or mailchimp? I understand there is a way to share an event post directly to our fb page or mailchimp content.
is that done through civicrm?

thank you.

In CiviCRM you can create events and manage (registered) participants at an event.
CiviCRM also provides an online registration form for events.

You can use the link to the public information page and the online registration form in a mail send from mailchimp or in a message on facebook. As far as I know there is no automatic way of doing this.

If you want more information also take a look at the user guide of CiviCRM: https://docs.civicrm.org/user/en/latest/events/what-is-civievent/


No coding no CIVICRM? Or..? I run a small but growing non-profit and I was looking into CIVICRM as our much needed CRM system. Now I know no coding at all, can I still custumie and use CIVI or do I nedd to know coding?TY!!

You can customize civicrm in many ways - eg add custom data/fields; you can also add extensions - essentially packages of code that help you leverage civicrm further. Lots of ways to customize your civicrm without requiring you to know touch code.


What type of database does CiviCRM use? I'm sure this is a very obvious question but what type of database does CiviCRM use?  SQL Server, MYSQL, etc.

From CiviCRM Requirements

An installation of Drupal, Joomla or Wordpress, and the following additional requirements:

PHP 5.5+ is recommended. See the CiviCRM PHP Requirements page for details.
PHP memory_limit set to between 256 and 512 megabytes.

MySQL 5.1.x or higher with INNODB support : CiviCRM is compatible with the current generally available MySQL release. Trigger support is required for logging and multi-lingual features. SUPER privileges are required in MySQL 5.1 if binary logging is enabled.

Surprised if this (or other places which reference mysql) was hard for you to find, so please suggest where you think the documentation could be improved.


Can we print mailing lables from CiviCRM? I cannot find a function that allows us to print mailing labels.  Please advise.

Search for the contacts you want to print the labels for
Select the contacts
Go to Actions / Mailing labels - print (see attachment)


import mapping dont save for custom fields on contact subtypes As the title.
If I create custom field set against a contact subtype, then import fields from a csv (saving the mapping for later use), none of the mapped fields are saved for the custom fieldset.

i.e.: on dmaster i can:

create a new custom field set contact subtype custom fields:

for use on individual > Volunteer

add field: contact subtype field
find (or create) a volunteer, and enter something into the new custom field
export the contact (select fields Contact_id & contact subtype field (& down load the file)
import the file, mapping the fields correctly

downloaded file
update contacts
contact type = individual > subtype: Volunteer
continue

set mapping to correctly map to the custom field contact subtype field

save mapping as... 'map 1'
continue

continue with import
done
change the contact subtype field label in the csv to foobar
import the csv - loading the saved mapping 'map 1'

mapping does not load + notice is thrown up onscreen:

Notice: Undefined index: in CRM_Import_ImportProcessor->loadSavedMapping() (line 451 of /srv/buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Import/ImportProcessor.php).

anyone else suffer with this problem or have any ideas?

there's an issue logged here that has a fix, and is most likely related, but I'm not sure if this is a separate issue.

Thanks in advance :)

I have submitted a PR for this issue. Can you please try applying patch from here?

Thanks

Pradeep


Create an activity when a specific profile is submitted? I'm sending out a profile to contacts with a checksum - they are not logged in when they submit it.
Can i create an activity for that contact when the profile form is submitted?
So far i've run into permissions problems - i'm probably not using the API correctly.

Yes, you can CiviRules extension to create activity when a profile is submitted. Or you can write a extension to use post hook for 'Profile' Object and then use Activity create api to create Activity(Note: you might need to pass check_permission to FALSE in api params to bypass permission)

HTH

Pradeep


How can I export vcards for multiple contacts? When viewing a single contact, I can select "Actions" Vcard and export a vcard which can then be used in other applications (Outlook, OwnCloud, etc)

I would like to be able to select "Create Vcard" in the drop down list for actions for search results, and get a vcard file of many contacts that could be imported into other apps.

This option does not exist (as yet).I'm not aware of an extension to do this either. Your options include:

a. Write an extension that adds the above functionality

b. Use the api to export the data into a program that can generate multiple vcards and use that


Upcoming Birthdays custom search not working I have followed the instructions to install the "Upcoming Birthdays" customer search from here.

However, when I run this custom search, CiviCRM gives me blank screen. Our organization is using CiviCRM 4.6.2 on Wordpress 4.1.5. Is this customer search working on 4.6?

Is there another way I could create a search for up and coming birthdays for our members?

The easiest way to do this is via the Upcoming Birthdays Report extension.


blank emails from cron after upgrade Wordpress Since I upgraded to Civi 5.11 (from 4.7) I am seeing empty emails from the cron daemon every time it runs the scheduled jobs. Previously I have only had emails when there has been some issue with the cron or what looks like an error from one of the scheduled jobs. The scheduled jobs look to all be fine in the log.

The problem is that it would hide any genuine error messages as I'm not going to go through all these emails.

Running on Wordpress 5.1.1 hosted on Siteground.

Update: I still want to resolve this. Part of the problem is I don't know where the messages with some content are coming from - they are all

"/usr/sbin/sendmail: unexpected response 501 to RCPT TO command"

I don't know exactly what they mean, but they did relate to a genuine problem with delivering mail. So I'd like to keep them. But they are few and far between and I haven't seen one for ages (maybe because there haven't been any bulk mailings). If I divert stdout to /dev/null will I lose the good as well as the bad. Not sure how to test it.

This turned out to be something adding a blank line in the cron output (see comments above). Since it's not clear what is adding it or how to track it down, a workaround is to adjust the cron command slightly:

your-cron-command | grep "."

which will remove all blank lines from the output, so if the output is just a newline then after the grep the output will be completely empty and not send an email as normal. In some hosting control panels you might need to backslash the pipe character, or create a wrapper script and have cron call that script.


How to get data via relationships with APIv4? Wilma has  relationship: is campaigner at organisation System Change Not Charity.

How can I get a list of individuals like Wilma and the organisations that they are campaigners for?

I've read the documentation but I can't figure out how I would join on relationship?

I tried this which I thought would at least give me the names of people with that campaigner relationship type, but it gives nothing.

Entity: Contact
Action: get

{
    "select": ["display_name"],
    "where": [
      ["relationships.relationship_type_id", "=", 15]
    ],
    "limit": 25,
    "checkPermissions": false
}

Not sure if this is what you're after but works for me; the 'join on' is a bit hidden in the 'Select' box.

CRM.api4('Relationship', 'get', {
  select: ["contact_a.display_name"],
  where: [["relationship_type_id", "=", 5]],
  limit: 25
}).then(function(relationships) {
  // do something with relationships array
}, function(failure) {
  // handle failure
})


Fails to open ClassLoader.php file I've installed the plugin successfully, but when I go visit the CiviCRM page in the backend, I get the following error:

Warning: require_once(CRM/Core/ClassLoader.php): failed to open stream: No such file or directory in /home/capitaleventscom/public_html/wp-content/uploads/civicrm/civicrm.settings.php on line 462

Fatal error: require_once(): Failed opening required 'CRM/Core/ClassLoader.php' (include_path='.:/home/capitalevents/public_html/wp-content/plugins/civicrm/civicrm/:/home/capitalevents/public_html/wp-content/plugins/civicrm/civicrm//packages:.:/usr/local/php56/pear') in /home/capitaleventscom/public_html/wp-content/uploads/civicrm/civicrm.settings.php on line 462

I've tried but couldn't figure out anything. Any help will greatly be appreciated.

In the file civicrm.settings.php the variable $civicrm_root is defined. It should point to the directory where you installed the CiviCRM plugin. If it has the wrong value it causes the reported error.


Error with recording membership payment offline Is anyone aware of any issue with trying to record a membership payment offline?
WE are running CiviCRM 4.7.11

Click on and existing Membership and edit membership.

Click on the checkbox that says Record Membership Payment.
None of the fields  to record the membership payment are being displayed such as amount, financial type etc.

If you then click on the Send Confirmation and Receipt checkbox,
 and then click 'Save' it of course gives an error saying Please enter the financial Type.

Not sure what is going on as we have not come across this issue before

Update:Just checked with Civihosting and they have confirmed its a bug.
Has anyone got a fix for this?

I just confirmed the bug in http://dmaster.demo.civicrm.org. This means not fixed yet. I take a look on https://issues.civicrm.org and I have not found any related error.

You can see guideline Bug Reporting and report this issue.


error on upgrade to 5.3 upon upgrade from 4.7.31 to 5.3 the site could not load any civi pages, it would give a generic error message.

in the log I see:

Civi\Payment\Exception\PaymentProcessorException: CRM_Core_Payment_PayPalImpl: Payment processor type is not defined! in CRM_Core_Payment_PayPalImpl->__construct() (line 73 of /var/www/xxxxxx/sites/all/modules/civicrm/CRM/Core/Payment/PayPalImpl.php).

but this site does not use paypal, it uses authorizenet so I have no idea why this is causing a fatal error

my temp workaround was to just comment out line 73 of PayPalImpl.php but I'll need to verify that payments still work. Anyone else have a similar issue with 5.3?

I posted this to gitlab here https://lab.civicrm.org/dev/core/issues/250 and the issue turned out to be related to odd records in my database.

this query, from Elieen exposed the bad row

SELECT p.id, p.name, p.class_name, p.is_active, pt.id, pt.class_name, pt.name
FROM civicrm_payment_processor p
LEFT JOIN civicrm_payment_processor_type pt ON pt.id = p.payment_processor_type_id
+----+--------------------+----------------------+-----------+------+----------------------+---------+
| id | name               | class_name           | is_active | id   | class_name           | name    |
+----+--------------------+----------------------+-----------+------+----------------------+---------+
|  1 | Dummy Processor    | Payment_PayPalImpl   |         1 |   10 | Payment_Dummy        | Dummy   |
|  2 | Dummy Processor    | Payment_Dummy        |         1 |   10 | Payment_Dummy        | Dummy   |

so I updated the row in civicrm_payment_processor to change Payment_PayPalImpl to Payment_Dummy and everything works without the modification to civi code.


Is it correct that saving an address with only Country should fail to save data? On Demo if you go to this record http://d46.demo.civicrm.org/civicrm/contact/view?reset=1&cid=202 and 'add address' or 'Edit' and save the Home Address with just Country (currently set to Default Country = Australia), nothing gets saved, no debug message either.

I tested on demo after witnessing what I thought was a problem with a Profile on a Contribution page, but the issue seems to be actually with the 'save contact' task.

if you have a default country and that you save an address with only that country, it assumes it's not that the user chose this country, but just that the default was left selected.

So it's normal behaviour, but might not be what you want indeed.


Reality check: Can CiviCRM be implemented by a nondeveloper with limited time? I am the director and only employee of a nonprofit with 2500 members. The president of our Board has set up a modest website hosted on GoDaddy, and now expects me to implement a membership database in CiviCRM, including online membership registrations with multiple levels, mass emailings, events including discounts for purchasing tickets for an entire series, etc.  Our membership information is currently in a 20-year-old product called Alpha5 that is no longer supported, and the need to adopt a new database is becoming more urgent as the only computer that holds our current system is getting flaky. We have no money to hire consultants, and in fact I think the main benefit my Board president sees is that the CiviCRM product is free. I am a skilled computer user but I am not a developer. I am a half-time employee whose work day is more than filled with other tasks. My sense is that CiviCRM is more than I can manage, and that even if I got it started, it would be very difficult when I retire in a couple years to find a staff person at half-time low pay who would be able to continue using and supporting it as needs change.
I would appreciate a reality check from you people who are working with CiviCRM. Would you recommend this product for a busy administrative person who is an expert Word and Excel user, with some Access experience, who has never built a website or used Drupal or Wordpress, written SQL, or programmed anything but Visual Basic?

Good question.

In broad terms I'd agree with the answer from William, with some reservations. To answer your question: "Can CiviCRM be implemented by a nondeveloper with limited time?" I would say yes, and to do so will take some learning and a good deal of trial and error, so if time is limited, don't expect to be able to get up and running in a few hours.

I'd say that your skill set is really helpful, but you would need to plan to build on that.

You have a number of challenges there: not least getting the data you need out of your old system and into a new one.

You current hosting with GoDaddy is unlikely to be friendly to CiviCRM, so you need to plan to move to a better specified hosting platform that will give you fewer (and ideally no) issues.

And of course you'll need to get CiviCRM suitably configured and customised to meet the specific needs of your organisation.

Realistically, unless you are willing and able to put in a good chunk of time above and beyond what you have available, to learn  how to do all this and then do it for real, you are not going to get a result.

Your board president needs to get real - a project like this in any context demands substantial dedicated time and resources, and it sounds from what you've written that they have not considered this.

My advice would be to get some expertise in to do the following tasks:

Assess whether CiviCRM is the right product given your organisation's needs.
Assuming that it is, to sort out suitable hosting and get Civi installed.
Work with you to configure and customise Civi so that it works for your organisation.
Ensure that you, and ideally at least one other person within the organisation, know how to use CiviCRM, so that you can cascade that learning to others.

These are one-off tasks that it makes sense to outsource unless you've got a pile of time on your hands (which you don't). If your organisation doesn't have the resources to fund this work, then it needs to find those resources, otherwise I would say you have a recipe for disaster.

Hope this helps.


What is required to run CiviCRM on Platform.sh? Platform.sh is a managed hosting service & devops infrastructure with support for Drupal and Symfony (and apparently any arbitrary php application).

What additional considerations are there for hosting CiviCRM on Platform.sh?
Are there any specific configurations or patches required?
Is there any functionality which differs from hosting CiviCRM on a "standard" LAMP stack?

In effect Platform.sh supports any PHP application, though it does have some specific magic for Drupal, but you can run any PHP application unmodified.

All you need is to know is how to inject the correct configuration for the infrastructure dependencies (MySQL, and possibly Redis or Solr in this case).

The specific "Drupal Magic" brings support for installation profiles and "drush make files". So it shouldn't be complicated to setup CiviCRM with Drupal. There is an example Git repository on GitHub for CiviCRM with Drupal 8.

This basically allows you to only commit your own custom code to the repository and let Platform.sh build the whole thing. This is nice because it keeps your Git repository lean, and allows you to benefit "for free" from security updates. Platform.sh also "magically" injects to Drupal the database settings, so you really have nothing to do. So that best way to go is to figure out how to have your CiviCRM installation based on a project.make file.

To host a normal CiviCRM application (without Drupal), there is nothing specific to do. The main thing to understand, is that Platform.sh is Git driven. You can't just go around hacking your production server. The only way to get code to your server is to commit it to Git. Because anything else is evil and no good at all.

For other PHP applications you will need to edit their settings file.

Platform.sh will expose in its environment everything you need to configure your application.

For example, this command will give you all the relationships of your application (and specifically the database configuration).:

$relationships = json_decode(base64_decode($_ENV['PLATFORM_RELATIONSHIPS']), TRUE);

I hope this help.


What is the timeout period for links in Civimail? Can it be extended? We send out a newsletter in Civimail, with links to our main website which is a different domain. We are using 'track click throughs' so the link, when clicked, goes via Civi first.  However, the links seem to be expiring fast - I sent a test last night and the links worked fine when I received the email.  But 10 hours later clicking a link just takes me into Civi, and not to the main website.  What is the default timeout and can it be changed?  We are on 4.6.12 and this is a Drupal site.

Yes the checksum lifespan is configurable at this path civicrm/admin/setting/misc?reset=1 which you get to via Admin > System Settings > Misc

Changing the duration will only affect future checksums. It will not affect ones that have already been set out.


How can I display variables for templates other than the top/main one? The popup window enabled at civicrm/admin/setting/debug?reset=1 contains only the top level Smarty template variables. How can I see the variables for a lower level included Smarty template?

To view debug output for the main page template, add &smartyDebug=1 to the url of your page.

To view debug output in a nested template, add the tag {debug} in the template itself.

Note that only users with the permission "view debug output" will be able to see debug info.


CiviCRM and Apache Solr Search I want to set up CiviCrm so that I can use Apache Solr to do a full search. Which CiviCRM tables should I import into Apache Solr?

Is importing tables the correct approach?

I am not a developer so this will be a significant challenge to me.

I am using drupal 7.

Considering that you foresee this as a significant challenge for you, I'd like to suggest that it may not be worth the trouble. CiviCRM is unlike within content management systems, where searches are for snippets from among a handful of long text fields. Instead, there are hundreds of fields to search, but you're usually looking for the exact or nearly-exact value.

Consequently, the advanced full-text indexing that Solr would provide would be wasted in most CiviCRM searches.  You'd also need to index all the tables (including ones that don't exist yet, as custom data tables are created on the fly and they're among the most-frequently searched).  Even the most simple searches by city or email address can involve a bunch of database joins.

In sum, I'm not sure Solr search would be worth it even if you had a bunch of solid developers and an open checkbook.  (The only reasonable example I can think of offhand is if you give out a bunch of grants and need a way to search among a ton of proposals.)  If you aren't confident in your abilities, you won't want to embark on something this expansive and experimental.


Should Manage Groups display the Smart Group contact count, or just display it as Unknown When I run Manage Groups, the Smart Group contact count comes up as Unknown for each group.  Clicking the Update Smart Group Counts link appears refreshes the group list, but still returns Unknown. This is after running the Refresh Smart Group cache job manually. CRM-21583 refers to this issue, but has been resolved as Won't Do as it seemed to have been related to an addin.  We don't have that addin in our Joomla systems, but still have the issue.

My question is whether Update Smart Group Counts is supposed to update the counts displayed in Manage Groups or whether CRM-21583 should be resurrected?

The issue was solved very simply, you just need a non-zero smart group cache timeout for the problem to go away.


Send a Receipt to a user when adding a manual membership OR any payment Using WP4.3.1 and CiviCRM 4.6.9
When creating a manual (off line) membership or payment for a contact is there a way to have a receipt of that sent to another user(email address)?  And is there a way to modify what is on that receipt?

You may be able to hook something together using CiviRules, but it's unlikely - because CiviRules won't have the same context for generating the receipt.  So CiviRules is probably fine for sending an internal email stating, "Hey, this contribution came in, here are the details", but (most likely) can't generate the exact receipt.

That's probably good enough - but if it's not, you can create an extension to handle this, using hook_civicrm_alterMailParams.


Event Registration - Confirmation Page Not Shown - Returns to Blank Registration Entry page First Time in a session? Using CiviCRM 4.6.8 on Joomla 3.4.4

Implemented an Event Registration page on the front end site.

After the Event Registration page is completed and Continue button pressed the Confirmation Page does not appear and the system represents the initial blank Registration page.

If the registration details are re-entered the Confirmation Page appears as it should and the rest of the process completes.

Any ideas please?

Ray

this could be a situation where you are jumping from www to without www or http to https or reverse. confirm that the urls are consistent throughout your settings eg civicrm.settings.php


Links for the DialogFlow extension go to Drupal 404 Page I'm on Drupal 8.
Just installed DialogFlow, but when I go to DialogFlow>Settings I leave CiviCRM and get a Drupal 404 page- "Page not found".
Any ideas?

I've noticed that sometimes in drupal 8 you have to clear drupal cache to get newly added civi menu links to be found.


How do I call the Fatal Error Handler for extern/url.php? I noticed my Fatal Error Handler wasn't being called when CiviCRM had problems processing trackable URLs in a CiviMail.

My answer will tell you how to do this.

When extern/url.php is invoked, the CMS is not bootstrapped and extern/url.php require_once's all the code it needs to run. So if you specify a Fatal Error Handler (CiviCRM > Administer > System settings > Debugging and Error Handling) it won't be found.

To resolve this, edit extern/url.php to add a require_once statement which names the file containing your handler. (Be careful this file doesn't execute code that will impact on extern/url.php - mine only has function definitions.)


Why can't I see different financial types in contribution reports With our contributions, one payment may contain 3 financial types ... e.g. an event fee, membership fee and donation. I have created "Price Sets" (of one Financial Type), which then contain 3 different "Price Fields" (which have separate Financial Types allocated) but when it comes to reporting on Contribution Detail, the filter / field "Financial Type" only pulls through "Event fees".

I can see that when creating an event I can choose 1 financial type
When creating a Price Set I can choose 1 financial type
But I can add multiple Price Fields to a Price Set, but these aren't being detailed / broken down when I go to the reporting on Financial Type.

Help! Are we setting up the price sets incorrectly? Do we need to create Custom Fields?

++ Added info: when running an Event Participant Report, if you select Fee Level as a column it groups all the different "Option Labels" from the various Price Fields within the Price Set. So the information is there and separated, I just can't see how the associated values for teach of those option labels listed for each participant.

Thanks so much for your help in advance.

You're looking for some advanced reporting: install this extension: fuzion extended reports -> and then look for report template: Extended Report - Price Set Line Items.


How can I put Civi data in a data warehouse that supports OLAP cubes? Jon G wrote this as part of an Answer to a Question about point-in-time/snapshot queries for membership data - "consider putting Civi data in a data warehouse that supports OLAP cubes. Parvez Saleh at Veda has implemented this and can probably speak to best practices." What is the best way to do this?

What do you mean? If you want to just do some reporting you could use any toolset like Pentaho, ClickView, Business Objects, Tableau or Periscope that you can attach to the CiviCRM database. Data warehousing sort of assumes you want to do your reporting on a frozen copy of the database, which you can easily do by dumping the CiviCRM database regularly. If you use a toolset that works with OLAP cubes you will have to define those cubes in your toolset. Something like ClickView does not need that. It does however require that you know your way around the CiviCRM database.


2 separate sites with the same php code Is it possible with Drupal to have two sites, with 2 separate databases, sharing the same PHP code?

For the future need of porting one database to another server, I don't want to use "Multi Site Installation".

Yes, you can run several independent Drupal sites off the same codebase.  Some instructions are here:
https://www.drupal.org/documentation/install/multi-site

Basically, each has its own database and its own sites/yoursite.org folder where the settings files and site-specific files go.  All use the sites/all folder.  When you visit via http://yoursite.org, Drupal checks the sites/yoursite.org folder for a settings.php file, and if there is no sites/yoursite.org folter, it uses sites/default.  (There's a more nuanced pecking order of folders, but this is the gist.)

For CiviCRM, it works the same: you put civicrm.settings.php in sites/yoursite.org, and the module lives in sites/all/modules.  Your database is independent of the other sites; the only thing shared is the module code.

However, there is a reason why many people don't set up their sites this way: there's not much benefit to having a single copy of the modules (the files aren't that big), but you can do things on one site that inadvertently cause problems on one of the others.  As an example, if you upgrade one site's CiviCRM, you're replacing the files used by all of your sites, requiring you to run the upgrade script on all of them.


How to generate group unsubscribe link We're using Google Groups Sync to synchronize our members in CiviCRM with groups in Google Groups. However, if the user unsubscribes from the list using the Google Groups link, Google Groups Sync will automatically re-add them during the next sync cycle.

The solution, I believe, is to include the unsubscribe link CiviCRM would generate if the e-mail originated from CiviMail, but I can't work out how to generate that link.

Is it possible to generate an unsubscribe link manually, or generic enough to include in the footer of Google Groups messages?

I know I asked this question quite some time ago, but I thought I'd share the solution we landed on.

We found and tested two solutions that worked well. The first was using Tags:

Allow users to manage their tags
Create tags for the groups members can opt-in/out of
Create smart groups based on the membership status and tags
Sync the Google Group to the smart group for the associated tag

The second approach was very similar, but instead of using tags, we used a set of custom fields as checkboxes for each of the groups. We settled on this approach, because it allowed us more control over what was shown to the user and freed up tags for other uses.


Current Employer Autocomplete Field In drupal the webform integration module allows an autocomplete field where you can search to add an employer from existing contacts. On my wordpress site however i am trying to allow users to update their current employer but it is just giving a text field with no autocomplete.

Are profiles able to use an autocomplete field for current employer? If not what are my other options?

There have been many discussions in past about this on old forum eg this one which refers to this extension - which looks like it needs testing for 4.6


What's the best version combination for Drupal 7 and Civi 4.5 Tried installing drupals starter-kit with civi with errors wouldn't finish. Tried numerous version combinations none would complete. Do you have a combo suggestion?

the stable versions are 4.6.x and 4.7.x, I'm not sure they are kits that install both drupal and civi, but the recommended path is to install drupal first, then follow the instructions to enable civi.

https://civicrm.org/download


How can I find out what the problem is with my failing CiviCRM installation in WordPress? I am attempting to install CiviCRM 5.33.1 on a fresh WordPress 5.6 install. Installation and activation go fine, and I get to the installer page at /wp-admin/options-general.php?page=civicrm-install.
The reason for this new install is that we need to partition CiviCRM to a subdomain on the same shared server as our main site. So I edited the CiviCRM Database setting to use the same DSN as is in our current civicrm.settings.php file, which looks like this:
mysql://[DB user]:[password]]@[server]:[port]/[DB name]

(The CiviCRM database is separate from the main WordPress database on our main site.)
Then I click Apply. The page redirects to /wp-admin/admin.php?page-CiviCRM&q-cificrm&reset=1, which has the title CiviCRM Installed, but then immediately displays the message Sorry, you are not allowed to access this page. That sounds like a permissions problem, but CiviCRM, nor the civicrm folder in wp-content/uploads, isn't installed, contrary to the title of the page.
I can't imagine that it's a problem with the Civi DB DSN, since I copied it directly from the current installation. Or could it be? But how can I figure out what the problem is?
Thanks!

I think you need to add an extra step or two. See https://docs.civicrm.org/sysadmin/en/latest/misc/switch-servers/ for more details

Deactivate old version and backup a copy of the CiviCRM database from the old install

Do your install in the new location and then activate with a new (empty database)

Rename the old Civi database as temp, restore the old database, rename the restored database as the new Civi database (and set up user as it was before).

Rename temp back to old Civi Database and reactivate old install so that it continues to work.

If you have changed to a subdomain you may need to edit some other resource settings.

I think the reason you need to take this approach is because of the settings stored in the database. I did quite a lot of trial and error to work it out in my environment (some odd things happened with my hosted server and subdomains.


How to display smart group search results to unauthenticated users? I created a smart group and want to display its result in a public page, ie visible even to a non logged in user. I followed the steps here: Public listings but still receiving:

The requested Profile (gid=17) is disabled OR
it is not configured to be used for 'Profile' listings in its Settings
OR there is no Profile with that ID
OR you do not have permission to access this profile.
Please contact the site administrator if you need assistance.

How can I display the results of a smart group on a public page?

I am using Civicrm 4.6.2

I will assist Xavier answer, as I don't have reputation to comment.

The user permission can be found navigating to Administer>User and Permissions>Permissions>WordPress Access Control
URL: www.yoursite.com/wp-admin/admin.php?page=CiviCRM&q=civicrm/admin/access/wp-permissions&reset=1

CiviCRM: profile listings and forms has to checked for anonymous user, if you have custom data in your profile, as Xavier says you will need to enable it as well.

Also make sure the profile has both "Standalone form or directory" and "Search view" checked.

And last, make sure your Smart group has "Public pages" as visibility, in the group settings.

Groups URL:
www.yoursite.com/wp-admin/admin.php?page=CiviCRM&q=civicrm/group&reset=1

Hope that helps.


adding extra info to relations I'm setting up CiviCRM for an animal charity organisation. Beside some problems to set up animal master data derived from an individual (e.g. animals usually don't have last names, etc.), I'm stuck with certain events which are related to both an individual and an animal (e.g. adoption or handover):

I wanted to create relations for such events, but I need to add further data to such relations, e.g. for the event "handover" the contract date, date of handover, reason for handover, and other.

Is there a way of storing such data assigned to an event, and assigning this event to both an individual and an animal? Relation doesn't seem to fit such a need ...

Regards

Bernhard

I would make "handover" an action rather than an event. Actions are things like meetings and phone calls, natively include two or more contacts and a timestamp, and you can add action types of your own by going to Administer > Customize Data & Screens > Activity Types. Play around with that and see if it works for you.