Mandatory volunteer contribution to maintain membership status. How would you implement? Volunteer-based cooperatives often have requirements for its members to maintain an 'Active' status in order to be eligible to vote in meetings or elections.

For example, my cooperative requires:

A) at least 24 hours of volunteer service in the financial year when applying for membership.

B) at least 24 hours of volunteer service in subsequent financial years to maintain an 'Active' status.

Typically, individuals declare on a paper form their annual volunteer contribution. It would be ideal to scan/upload PDF documents into CiviCRM annually and simply tick a checkbox that the member has complied with the requirement of active membership.

I can see multiple ways to implement this but does anyone with CiviCRM experience have a suggestion on how they would implement this?

Which Module would you use or customise?

Cheers,

Troy

I would probably use the CiviRules extension for this (to be found here: https://civicrm.org/extensions/civirules with documentation here: https://docs.civicrm.org/civirules/en/latest/ ) and then:

set up an activity for uploading the document
set up a CiviRule with trigger new activity, condition on activity type and status (and possibly attachment) and action tag the contact as an active member.


How do I set the time zones in order to correct mismatched Timestamps for MySQL and PHP? I currently have a warning on Environment settings. Timestamps reported by MySQL and PHP are mismatched.

The warning is because the timezone of the server does not match with the timezone set in MySQL. We had similar warning and after setting the timezone in both Centos & MySQL, the warning is not displayed anymore.
Additional Info:
This is how we corrected/fixed the timezones, if it helps. The below instructions are for setting timezone to GMT, you need to use your timezone if you want to use the below instructions.
Setting the timezone in CentOS
Check the date and timezone
[root@my-server ~]# date
Mon Nov 24 10:27:14 CET 2014

The above is incorrect. We need to set GMT for Europe/London
Fix the timezone
[root@my-server ~]# rm /etc/localtime
[root@my-server ~]# ln -s /usr/share/zoneinfo/Europe/London /etc/localtime

Now check the date and timezone again
[root@my-server ~]# date
Mon Nov 24 09:30:14 GMT 2014

Setting the timezone in MySQL
Check the timezone in MySQL
mysql> SELECT @@global.time_zone;
+-----------------------------+
| @@global.time_zone          |
+-----------------------------+
| SYSTEM                      |
+-----------------------------+
1 row in set (0.00 sec)

Set timezone '+00:00' for GMT
mysql> SET GLOBAL time_zone = '+00:00';
Query OK, 0 rows affected (0.00 sec)

Now check the timezone again in MysSQL
mysql> SELECT @@global.time_zone;
+-----------------------------+
| @@global.time_zone          |
+-----------------------------+
| +00:00                      |
+-----------------------------+
1 row in set (0.00 sec)


Invalid Argument WebForm I'm getting two error messages:
Warning: Invalid argument supplied for foreach() in wf_crm_get_fields() (line 910 of /home3/site/public_html/sites/all/modules/webform_civicrm/includes/utils.inc).
Notice: Undefined index: caseRoles in wf_crm_get_fields() (line 910 of /home3/site/public_html/sites/all/modules/webform_civicrm/includes/utils.inc).
when I try to enter information on Drupal 7 using a webform.
What could be causing this issue? Is there a way that I can work around this issue?
Thanks!

Please see -> What is the recommended/supported version of Webform CiviCRM module for Drupal 7?
First step would be to move to the supported version for D7WFC -> 7.x-5.x
Your error message tells me you're on 7.x-4.x
https://github.com/colemanw/webform_civicrm/blob/7.x-4.x/includes/utils.inc#L910


Unable to access Registration Screen dropdown Civievnts This is probably not a Civi issue, but any feedback would be appreciated. I have set up an event. Under Registration Screen, I have the option to Include Profile Top of Page and Include Profile Bottom of the Page. When I select an option in either or both fields and save, I am not able to access either field again. They are both greyed out. After much work with a colleague yesterday, we established this occurs only in Firefox. I have logged into Microsoft Edge and I am able to access the dropdown. I like using Firefox and I don't want to have to change between browsers when using Civi. Is there a way to solve this? Thanks.

Some of the forms on Civicrm won't allow me to access dropdown menus. The menus are greyed out. I thought this was a browser issue as it happens only on Firefox and Chrome, but not on MS Edge. It is caused by the Dashlane password extension. I started Firefox in safe mode, with extensions disabled. The issue goes away. I have removed Dashlane from Firefox and Chrome. Civi is working well.


Which directories in an extension get scanned by CiviStrings CiviStrings is a cli tool that scans an extension for translatable strings and generates a .pot file. According to the readme,

  It scans PHP, Smarty, JS, and partial HTML files for references to the ts() function -- and generates a list of strings using gettext's POT file format.

I'd like to know which directories it scans in an extension. I know it will scan files in the /ang directory, but what if I place an html file somewhere else, like /foo/bar.html - will that file also get scanned?

The civistrings command doesn't have a prescribed list of directories. It takes a list of paths (files or directories) as an input. For example, here's an excerpt of running it against the api4 extension:

[nix-shell:~/bknix/build/dmaster/sites/all/modules/civicrm/ext/api4]$ civistrings $PWD
#: CRM/Api4/Upgrader/Base.php
msgid "Upgrade %1 to revision %2"
msgstr ""

#: Civi/Api4/Service/Spec/Provider/CustomValueSpecProvider.php tests/phpunit/Action/CustomValueTest.php
msgid "Custom Table Unique ID"
msgstr ""

#: Civi/Api4/Service/Spec/Provider/CustomValueSpecProvider.php tests/phpunit/Action/CustomValueTest.php
msgid "Entity ID"
msgstr ""

#: ang/api4/Explorer.html
msgid "CiviCRM API v4"
msgstr ""

At time of writing, the scanner will look for ts() expressions in any files which match the following:

File-name ending with .js (parsed as Javascript code)
File-name ending with .html (parsed as HTML with embedded Javascript)
File-name ending with .setting.php (parsed as a Civi settings file)
File-name ending with .tpl or .hlp (parsed as a Smarty file)
File-name ending with .php or file-content starting with a PHP signifier in the first line (parsed as PHP code)

This arrangement allows you to keep-it-simple in the typical case of a single extension (i.e. "just scan the entire extension and put all strings in one file"). This also allows you to deal with more complicated arrangements (e.g. civicrm-core is large and includes several components split among various subfolders). civistrings is focused on the technical mechanics of scanning for ts() -- and tries to be agnostic about the directory-structure.


How do I delete activities? How do I delete an activity that I have created and assigned to myself?
I cannot see a button that says delete, only an edit button?

There should be a link on the "Activities" tab marked "Delete" for each activity listed.  See screenshot:

If you do NOT see this button, it's most likely that you don't have the "Delete Activities" permission.  Please speak to whomever manages permissions for your CiviCRM installation.


"alter routine command denied to user" error when installing extensions? I have installed civicrm 4.7 on drupal 7. Installing of extension failed with error:

DROP FUNCTION IF EXISTS civicrm_strip_non_numeric [nativecode=1370 ** alter routine command denied to user 'civicrm'@'localhost' for routine 'civicrm.civicrm_strip_non_numeric']

I have grant all to the database, named civicrm.

The user does not have the permissions to alter and create routines (functions). This should fix it:

GRANT CREATE ROUTINE, ALTER ROUTINE ON civicrm.* TO civicrm;


WP "Call to Action" plugin causes JS errors I found that I am getting js errors when I have the Call to Action wordpress plugin enabled.
My hunch is that it is because CTA also includes Select2 but I did not test this. The error in particular I was looking at was $.fn.select2.defaults is not defined. (everything before "defaults" is defined). At least when in Common.js. In the console it appears to be defined.

I did not find CTA on the incompatible plugin list.
http://wiki.civicrm.org/confluence/display/CRMDOC/WordPress+plugins+incompatible+with+CiviCRM

Does it need to be added? is there a known work-around?
Can someone point me to a model for resolving this conflict?

civicrm 4.5.8
WP 4.2.2
CTA 2.3.6

This is a known bug in Select2 which we have worked around as of CiviCRM v4.6.0.


No matches found for contact reference field in front end profile Duplicated on Wp and Drupal Demo sites
Custom field of type contact reference used in front end profile for search and listings (public)
Search returns “no matches found” even though contact name appears in field
Logged in as admin

Entering nothing in search fields and pressing search lists all contacts in database. I don't get why a single contact from the contact reference field is "no match"

Can you please check if Adams, Lou is saved in custom field for any contact in your system? The profile search that you have created will list all the contacts having Adams, Lou saved in their respective custom field.

I guess you trying to create a profile search that will list details of a contact by selecting contact from a drop down.


Using the wordpress plugin, how do I overide the the template files, ie EventInfo.tpl? I have spend a number of hours trying to figure this out.  If I want to change one of the template files, say EventInfo.tpl, but not inside the plugin so updates would not override it.  How do I need to do that?

If you need to over ride a .tpl you can just do that by creating an extension or by using custom template folder in civicrm

which will be more easier - also, in the time of upgrade you need to compare the file and do the changes

More reading:
https://wiki.civicrm.org/confluence/display/CRMDOC/Customize+Built-in,+Profile,+Contribution+and+Event+Registration+Screens

https://wiki.civicrm.org/confluence/display/CRMDOC/Create+a+Module+Extension

https://wiki.civicrm.org/confluence/display/CRMDOC/Create+an+Extension

I guess this helps !!!


Is it possible to create multi-record custom fields on Activities? Has anyone found a way to create multi-record custom fields on Activities? We have an example where a single activity can contain multiple funding sources and need to be able to enter them into the one activity

Not currently.

In general, feature requests like this can be handled in a few ways:

If you are a developer, you can submit a pull-request with the new feature.
If you have funds to contribute, you can submit a feature-request to the paid issue queue for the core team to work on.
You can work around your problem using existing features. For example you could set up the custom field as a "Note" textarea and put the multiple funding sources each on a separate line of the same field.


It looks like Curl is installed but still getting Curl not installed error When I go to certain parts of CiviCRM, such as Administer > Extensions, or the dashboard, I get a message saying that Curl isn't installed.

I'm running Debian with Apache.

When I run curl --version I am greeted with:

curl 7.38.0 (x86_64-pc-linux-gnu) libcurl/7.38.0 OpenSSL/1.0.1t zlib/1.2.8 libidn/1.29 libssh2/1.4.3 librtmp/2.3
Protocols: dict file ftp ftps gopher http https imap imaps ldap ldaps pop3 pop3s rtmp rtsp scp sftp smtp smtps telnet tftp
Features: AsynchDNS IDN IPv6 Largefile GSS-API SPNEGO NTLM NTLM_WB SSL libz TLS-SRP

I've run service apache2 reload to reload apache and it's services, even though curl was already installed before I set the site up as well as cleared the caches drush cc civicrm.

I've looked at the phpinfo in command line and don't see any reference to curl.

This only seems to be an issue on my test site, running CiviCRM 4.7.15 on Drupal 7.

Edit:
/etc/php5/cli/conf.d/20-curl.ini shows:

; configuration for php CURL module
; priority=20
extension=curl.so

Command-line curl and php-curl are usually different packages. Assuming you're using unix you would do something like yum install php-curl or apt-get install php-curl. The exact command depends on what OS and version.

Or it might be installed, e.g. as part of the php-common package for example, but for whatever reason it's not enabled, in which case check /etc/php.d/20-curl.ini (the exact file/location depends again on which OS/version - it might even be directly in php.ini), and enable the curl module in there.


Confusion over Contacts and Profiles I am sure I am just confused about profiles and was hoping someone could clarify a few things for me. We run a non-profit that assists foster children in our community. I am attempting to set up profiles for:

Foster Parent:
First name
Last name
etc

Foster Child:
First name
Last name
etc.

These should be 2 different contacts with a relationship between the 2.

I thought I did it correctly, however, I am now setting up an event where the foster parent would register the child.  I am using both profiles on the form but the form (and added contact) use the first and last name of the foster parent and list it as the same name as the child.  It's as if both profiles are combining to make one person when they should be separate.  What am I doing incorrectly?

The design of profiles is that they will only collect information about a one contact. (Even when you use multiple profiles, everything is updated on one contact)

Your question about how to collect information about multiple contacts at once has already been answered at:  How to allow parents to register children but still record their own info


Groups and sub-groups display broken after upgrade to 4.7.10 Hi After upgrading civicrm to v4.7.10 from 4.7.8, it looks like the display of groups and sub-groups has changed and is not partially broken.

The first group and has sub-groups is displayed showing that there are sub-groups. The second group that has sub-groups and sub-sub-groups shows as a regular group but not that it has sub-groups.

This prevents from accessing the sub-sub-groups. They can only be in searching for them in the Find so it appears to be a display issue only.

I believe you're referring to CRM-19096 and/or CRM-19219, and possibly CRM-19272.

The first two are fixed with CiviCRM 4.7.11, which is officially released on September 7th, 2016.  The third one has a fix available but hasn't been scheduled into a release.

If you can't wait, and you know how to patch your CiviCRM, you can get the fixes from Github; if you don't know how, wait for CiviCRM 4.7.11, it's only a week away!


Identify Volunteers in contact summary I am testing the CiviVolunteer extension and was wondering if there is anyway to identify that a contact signed up to volunteer based on their profile? I assigned a few volunteers to an event, but I do not see that they signed up anywhere on their profile. I don't even see the event show up on their event tab. Let me know if I am missing anything or if this is a future enhancement. Thank you!

For now in the contact's profile click on the activities tab and filter out the activity type = volunteer. Status available means the contact has not been assigned to a specific need. Status scheduled means they have been assigned to a specific need.


Report Preview PDF not working in 4.7.6 We are finding that a membership report and Preview PDF often goes to a page not found error. It seems to depend on the fields selected -- the fewer fields then better chance of getting a PDF to appear. What is the advice or guideline for this feature? Can we preset the page format to landscape to allow for more columns?

I doubt the page format is the issue, it's more likely an issue about custom fields. There have been recent changes (due to security issues) with how custom fields are being handled, I'd update to the latest 4.7 before pursuing further.


How do I create set up batch update members via profile? I want to expire all members in the database and start over.

I would suggest that you start by looking at the documentation on Profiles.  If you still have questions please come back with some more details about what the problem is.


"Loading Failed" when soft crediting to a Personal Campaign Page I get a message indicating "Loading failed" when trying to credit a donation to a specific personal campaign page. I can successfully Soft Credit to the owner of the page and add "personal campaign page" as the type, but this isn't the same as crediting to a specific pcp. I was able to recreate this on the demo site - see attached.

Any ideas why in one pop up edit screen one auto fill box works but not the other? I got as far as Contribute > Form > PCP.js.tpl but was out of my depth trying to figure out what was wrong.

You're right there was a javascript conflict affecting popup forms on the contribution search page. I've submitted a fix which will show up on the demo site tomorrow and in the next release (4.6.5).

For now, you can work around the problem by right-clicking the "edit" link from the search results screen and opening it in a new tab instead of a popup.


Payment Processor Error I am logged into our website, setting up a Contribution Page, and I need to set up a Payment Processor, but I am receiving and error message: ****The 'administer payment processors' permission is required to add or edit a payment processor.****

Error seems to be self explanatory, You need to have administer payment processors  permission to Add, Update, or Disable Payment Processors.

If you're an admin, you can grant this permission by navigating to

Administer -> Users and Permission -> Permissions(Access Control)

and click on Drupal/Joomla/Wordpress Access Control w.r.t your CMS.


DB Error: connect failed (code 24) Anyone have any idea how I can fix this?
Just done install and CiviCRM did not load (all OK on wizard) then nothing.
Removed CiviCRM from the WordPress install and uploaded again (also removed database) but error below appeared.

Have I missed something?

Initialization Error

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

[code] => -24
[message] => DB Error: connect failed
[mode] => 16
[debug_info] =>  [nativecode=php_network_getaddresses: getaddrinfo failed: Name or service not known]
[type] => DB_Error
[user_info] =>  [nativecode=php_network_getaddresses: getaddrinfo failed: Name or service not known]
[to_string] => [db_error: message="DB Error: connect failed" code=-24 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info=" [nativecode=php_network_getaddresses: getaddrinfo failed: Name or service not known]"]

)

Need to recreate your civicrm.settings.php file - or at least check the DB settings in there.

It's typically created upon install and located in wp-content/plugins/civicrm/civicrm.settings.php


How to change the labels font size I don't find how to change the font size when I print labels (I have a CiviCRM Spark account). The default size is far too small and the Post office don't accept it...

Yes there is a option to change the font size. The UI setting is not user friendly but it does allow you to update the attributes.

Navigate to CiviCRM >> Administer >> System Settings >> Option Groups.
Find for Mailing Label Format.
Click on "Edit options' link besides 'Mailing Label Format'
You will see list of formats, click on 'Edit' besides one of the format type.
In 'value' text field find for 'font-size' and change the value from old to new

for eg if the old value was "font-size":8 than replace it with "font-size":16

HTH

Pradeep


"Abandoned" Ubercart orders marked as "completed" in CiviCRM I'm using Drupal (7.38), CiviCRM (4.6.5), Ubercart (7.x-3.8) and Ubercart_CiviCRM (7.x-4.x-dev). Whenever a user (registered/anonymous) purchases a product from the site, a contribution will be added into the CivCRM contact. If the user is anonymous, the system will create a user in Drupal as well as a contact in CiviCRM, linked by the email address. I notice some of the orders have a status of 'Abandoned' in Ubercart, but under CiviCRM's contribution tab for this contact, it is listed as 'Completed'.

I have gone through the uc_civicrm module and I found the following code in uc_civicrm/uc_civicrm.module

function _uc_civicrm_map_contribution_status($order_status) {
  // NOTE: There may be a more "correct" way to do this.
  $map = array(
    "completed"        => 1,
    "payment_received" => 1,
    "pending"          => 2,
    "processing"       => 5,
    "canceled"         => 3,
    "in_checkout"      => 5,
  );

  if (array_key_exists($order_status, $map)) {
    $id = $map[$order_status];
  }
  else {
    // Oh no.
    $id = 1;
    watchdog('uc_civicrm', 'There is no status that maps to %order_status, marking as "Complete"', array('%order_status' => $order_status), WATCHDOG_WARNING);
  }

  return $id;
}

I want to synchronize Ubercart's order status with the CiviCRM contribution status. How can I do that?

If you want to map 'abandoned' to the 'canceled' status in CiviCRM (there is no "abandoned" status in CiviCRM) you could revise the above like so:

$map = array(
 "completed"        => 1,
 "payment_received" => 1,
 "pending"          => 2,
 "processing"       => 5,
 "canceled"         => 3,
 "abandoned"         => 3,
 "in_checkout"      => 5,
);

Then I'd recommend making a bug report/patch on the issue you filed at the project page so it gets into the module core if the maintainers agree.


Transferring CSV contacts Civi On a PC, I've downloaded a list into excel and saved it as a MS-DOS CSV file. When I go to Civi to import it, Civi says it's not saved as a CSV file.

I've followed the same steps I have for a dozen other contact lists.

What am I missing?

I would suggest that you take a look at the documentation: Importing Data into CiviCRM

Read through this and follow the steps carefully. Try to export a small number of contacts - i.e. the first ten or so. If you are able to import these then the problem may be with some of the data in the later records.

You may need to change the export settings so that fields are separated by a semicolon (;) rather than a comma (,).

You may find the answers to this related post helpful: CSV file import problem with file from Mac MS Office

If you are still having trouble it would be helpful if you could paste an example of the CSV file to your post with dummy data replacing any real data.  Again, just the first few lines would be sufficient.


creating Sign-up form on Facebook We are looking to include a sign-up form using a CiviCRM profile or some other method on our Facebook page. Does anyone have any recommendations for tools that can do this? I assume it is a matter of including the HTML code snippet  from the CiviCRM profile in iframe on Facebook.

You can get an HTML snippet for a Profile and include as an iframe. This option should show under 'more' to the right of the profile listings.

  HTML Form Snippet - If you want more control over form layout, or want to add Profile input forms to non-CiviCRM blocks, pages and/or sites...click the HTML Form Snippet action link for a Profile below - and copy and paste the HTML form code into any web page.

NOTE: there is now a setting in Administer => System Settings => Misc to enable this.


How do I use custom Smarty functions in a Form? The "Extending Smarty" page at http://wiki.civicrm.org/confluence/display/CRMDOC/Extending+Smarty gives instructions for writing custom php functions and calling them from Smarty templates used in Pages, by using the pageRun hook to add a plugin directory to your template.  But this doesn't work for Forms.

For example, a custom function works from the main Case dashboard, but not from the search view when filtering Cases by status.

How do I have the plugin directory included in Forms, not just Pages?

Use the config hook instead of pageRun.  I originally had this hook in place, as per the example at "Extending Smarty":

function civicrm_pageRun(&$page) {
  $template = $page->getTemplate(); // retrieve Smarty template object
  array_push($template->plugins_dir, '/path/to/civi_custom/plugins');
}

I replaced that with:

function civicrm_config( &$config ) {
  $template =& CRM_Core_Smarty::singleton( );
  array_push($template->plugins_dir, '/path/to/civi_custom/plugins');
}

and now I can use my custom Smarty functions from both Pages and Forms.


CiviCRM Log shows error invoking Payment Form Periodically I seem to have the following error on my CiviCRM site. I have never actually seen the error and have had a hard time tracking it down. I would be interested if anyone could point me to steps I need to take to reproduce the error (get the civicrm_invoke(payment, form) method to fire so that I might see what is happening. It seems odd that line #2 shows a null value for the name. I only have one processor_id installed (Stripe). Any pointers for tracking down further what is happening here would be appreciated.

May 12 08:19:43  [info] $backTrace = #0 /var/www/isi/sites/all/modules/civicrm/CRM/Core/Error.php(378): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /var/www/isi/sites/all/modules/civicrm/CRM/Utils/Type.php(476): CRM_Core_Error::fatal("processor_id (value: ) is not of the type Integer")
#2 /var/www/isi/sites/all/modules/civicrm/CRM/Utils/Request.php(110): CRM_Utils_Type::validate("", "Integer", TRUE, "processor_id")
#3 /var/www/isi/sites/all/modules/civicrm/CRM/Financial/Form/Payment.php(55): CRM_Utils_Request::retrieve("processor_id", "Integer", NULL, TRUE)
#4 /var/www/isi/sites/all/modules/civicrm/CRM/Core/Form.php(549): CRM_Financial_Form_Payment->preProcess()
#5 /var/www/isi/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(92): CRM_Core_Form->buildForm()
#6 /var/www/isi/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Financial_Form_Payment), "display")
#7 /var/www/isi/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Financial_Form_Payment), "display")
#8 /var/www/isi/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("display")
#9 /var/www/isi/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(113): CRM_Core_Controller->run()
#10 /var/www/isi/sites/all/modules/civicrm/CRM/Core/Invoke.php(284): CRM_Utils_Wrapper->run("CRM_Financial_Form_Payment", NULL, NULL)
#11 /var/www/isi/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:14))
#12 /var/www/isi/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#13 /var/www/isi/sites/all/modules/civicrm/drupal/civicrm.module(448): CRM_Core_Invoke::invoke((Array:3))
#14 [internal function](): civicrm_invoke("payment", "form")
#15 /var/www/isi/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:2))
#16 /var/www/isi/index.php(21): menu_execute_active_handler()
#17 {main}

It looks like it's getting an error when loading the payment-processor specific part of a contribution form, via AJAX. It should be getting the payment processor id as part of the ajax call, but it's not. That suggests it might be on an old contribution page that had a payment processor configured as an option that is no longer available.

If you can look at your web server access logs and find the corresponding contribution page you might identify the problem. It's even possible that you wouldn't actually see an error on your form, it would only show up in your console.


Installing CiviCRM 4.6.11 on a Joomla 3.4.8 I am trying to install CiviCRM 4.6.11 on a Joomla 3.4.8 website which I downloaded from the Joomla Extensions Directory. When I install it nothing happens.  I dont see any error message or a success message.  Joomla normally displays an error message when an installation is not successful. The website is on localhost.

I would appreciate your guidance.

CiviCRM is likely much heavier then the average Joomla Extension. And because it runs behind more CMS-systems the preferred installation could be different then the usual Joomla Extension.

Please have a look at the "Installing CiviCRM for Joomla" page on the CiviCRM site and follow the instructions there for the best way to install CiviCRM for Joomla:

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


Error when updating Stripe: Trait 'CRM_Core_Payment_MJWTrait' not found I have just updated Stripe to version 6

It requires a Data Base update

But when I run this update, I get :
[Error: Upgrade com.drastikbydesign.stripe to revision 5023]
Error 1: Trait 'CRM_Core_Payment_MJWTrait' not found in /home/bapaparoisse/www/www/sites/default/files/civicrm/ext/com.drastikbydesign.stripe/CRM/Core/Payment/Stripe.php, line 13

There's a new requirement listed in the Stripe CiviCRM documentation for version 6.0.  You also need the MJWShared extension.


In CivilMail for 4.6.2 how do I prevent duplicate emails? Since 4.6.2 CiviMail is sending every email twice. I'm enclosing an attachment to show. The report also shows the successful delivery at 200% on some emails and 300% on others.

http://forum.civicrm.org/index.php/topic,36345.0.html

This was a bug related to smart groups and premature mailings, which is now fixed in version 4.6.3.

See https://issues.civicrm.org/jira/browse/CRM-16251


Is there a simple way to import recurring SEPA mandates that have been processed outside CiviCRM previously and should now be managed using CiviSEPA? In the CiviSEPA Setup Instructions there is a section regarding importing SEPA mandates, but instead of an answer there is a question... (similar to the one I am asking.)

I have been checking the database tables and Contribute options and unless I have missed something, there is no way to import the contributions along with the mandates. That is, using the Import contributions option will populate the civicrm_contribution table, but not the civicrm_contribution_recur table which stores the details of the recurring transactions.

There is also the question of populating the civicrm_sdd_* tables which are specific to the CiviSEPA extension.

I don't intend to have all the history of the mandates I want to import, but at least a working mandate list that may be used to generate future mandates.

I suppose that I could create a script to inject the data in the proper tables or through the API, but would like to know if someone has tried something easier or has something to start with.

UPDATE

I have found this question that also mentions SepaMandate and createfull: Need to create a SepaMandate for street walkers?

Indeed there is not a standard importer for SEPA mandates. I have migrated SEPA mandates a few times and I use the SepaMandate createfull API. That will create the mandate and the recurring contribution.

If you then want to import actual payments you should fill the column contribution_recur_id to ensure they are linked to the mandate.


Smart Group DB error Viewing some Smart groups (not all) causes DB error.

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

[code] => -2
[message] => DB Error: syntax error
[mode] => 16
[debug_info] => INSERT IGNORE INTO civicrm_tmp_e_gccache_554616ac5a2e5773984de236f4af031e (group_id, contact_id)  [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 '' at line 1]
[type] => DB_Error
[user_info] => INSERT IGNORE INTO civicrm_tmp_e_gccache_554616ac5a2e5773984de236f4af031e (group_id, contact_id)  [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 '' at line 1]
[to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="INSERT IGNORE INTO civicrm_tmp_e_gccache_554616ac5a2e5773984de236f4af031e (group_id, contact_id)  [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 '' at line 1]"]
)

I think, this error is since the last, 5.26.1 update.

Has someone this problem, too?

It has been reported here https://github.com/civicrm/civicrm-core/pull/17622 and it should be fixed by the CiviCRM 5.26.2.


Is there a way to disable the wysiwyg editor when editing mail templates? I'm trying to add the "shortlink" html schema so my users on gmail can have the direct link to RSVP to the event or confirm their signature for the petition

Unfortunately, the editor on civicrm fubar the html to the point gmail can't recognise it anymore

Is this possible to disable the editor only when editing the mail template? So my users still have the wysiwyg editor when composing their mail, just the admins being able to write nice html templates without having the html editor messing up

Editor can be disabled completely by the following

Administer > Customize Data and Screens > Display Preferences.
CKEditor  can be changed to TextArea

http://book.civicrm.org/user/current/initial-set-up/customizing-the-user-interface/

For specify Action

Editor can be disabled before editing the template using SQL

civicrm_setting table holds the CKEditor setting

Id: -         11

Group name: - CiviCRM Preferences

Name: -        editor_id

Value: - s:1:"2";

If the value is made null then it changes to Text Area and later it can be changed back to CKEditor

But, any member accessing the Editor at the every moment like in contact summary screen for creating PDF at the same time cannot view Editor till this is been changed -


Can I easily sync/import Facebook Event attendees with a CiviCRM Event participant list? A lot of my users like to use Facebook Events for quickly inviting their friends and contacts to an Event.

Facebook allows Event attendees and status to be exported by the Event owner or manager - the only fields allowed to be exported are the Guest (attendee) full name and Facebook Event status (Going, Maybe or Invited).

I can export that attendee list from Facebook and import the attendees into Civi using an Unsupervised dedupe rule with First Name and Last Name (once I separate them out in the .csv file) and an updated Event Status to match Civi values (Registered or Attended).

But - is anyone using the Facebook API (or other Facebook Developer tools) or CiviCRM API to automate this process, and/or able to get more fields exported out from Facebook?

And if you're wondering "why not force your users to use a Civi online event registration page instead?", that's valid, but I'd rather not discourage my users from using other tools - especially Facebook, with which they are already very familiar and like - which is often not the case with Civi :(. I'd rather figure out how to quickly sync/integrate/import Facebook data into Civi.

I was using drupal to create a facebook event when a civicrm event was created and add the participants.  There was a change in the facebook API that no longer supported post types for event objects.  I'm not sure if that allows event registration though.  The idea was using The Drupal Facebook Post module.  and civicrm entity which created a rule on event creation or update and did a post to facebook.  It worked pretty well and if the API supports adding people to an event you might take that approach (shouldn't require any code.)  Please update us if you explore this approach.


Error sending mail with Civimail I've switched hosts and the new host's smtp server seems to be rejecting the email I'm trying to send to a group.  It can me 2 or 2000 people with the same response.  Apparently it does not like the auto generated sender email address?  Anyone have that issue and go I d a solution?  CiviCRM on WordPress. Both very recent versions.

2017-09-22 16:30:04 [4342] H=(www.sportingdetectiondogs.ca) [184.154.247.100]:33676 I=[184.154.247.116]:25 X=TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128 CV=no SNI="sportingdetectiondogs.ca" F= A=dovecot_login:civicrm@sportingdetectiondogs.ca rejected RCPT : SITEGROUND: b.304.14831.47c90fe51b65dc14@sportingdetectiondogs.ca is not a valid address: Sender verify failed: Sender verify failed
2017-09-22 16:40:04 [48178] H=(www.sportingdetectiondogs.ca) [184.154.247.100]:42556 I=[184.154.247.116]:25 Warning: SITEGROUND: Message from 184.154.247.100. Normal SMTP auth with civicrm@sportingdetectiondogs.ca system user: sporti62
2017-09-22 16:40:04 [48178] H=(www.sportingdetectiondogs.ca) [184.154.247.100]:42556 I=[184.154.247.116]:25 X=TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128 CV=no SNI="sportingdetectiondogs.ca" F= A=dovecot_login:civicrm@sportingdetectiondogs.ca rejected RCPT : SITEGROUND: b.304.14832.46cd2e439db32d78@sportingdetectiondogs.ca is not a valid address: Sender verify failed: Sender verify failed
2017-09-22 18:45:24 [26529] H=(www.sportingdetectiondogs.ca) [77.104.151.189]:51718 I=[77.104.151.189]:465 Warning: SITEGROUND: Message from 77.104.151.189. Normal SMTP auth with civicrm@sportingdetectiondogs.ca system user: sporti62
2017-09-22 18:45:24 [26529] 1dvXdM-0006tt-Ja <= info@sportingdetectiondogs.ca H=(www.sportingdetectiondogs.ca) [77.104.151.189]:51718 I=[77.104.151.189]:465 P=esmtpsa X=TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128 CV=no SNI="usm31.siteground.biz" A=dovecot_login:civicrm@sportingdetectiondogs.ca S=565 M8S=0 T="Test for SMTP settings" from  for support@siteground.com
support@support.com [~]#

two possible sources of the error:

you have changed something in the configuration of your mail accounts in civi (or didn't finish the config previously), check the documentation, the "localpart" should not be empty but name of your bounce mailbox (eg if your mailbox is bounce@example.org, it should be "bounce+")
civimail relies on a trick that most servers implement: if you send and email to bla+whatever@example.org, it will automatically be understood as an alias of bla@example.org

It seems that you need to at least fix the localpart, as your new mail server is more strict and better at catching configuration problems


Python Civicrm API Keeps Giving 404 Error I'm trying to use the Python Civicrm API located here: https://github.com/tallus/python-civicrm . I can connect to the site just fine, but anytime I try to query any of the content I get a 404 Error from the /extern/rest.php.

I am using an Admin account that has an API key.

from pythoncivicrm.pythoncivicrm import CiviCRM

url = 'http://sitename.org'  # works
site_key ='642346924242934720'  # works
api_key ='dbJKbjkse903332'  # works
civicrm = CiviCRM(url, site_key, api_key) # works

search_results = civicrm.get('Contacts') # ERROR

  pythoncivicrm.pythoncivicrm.CivicrmError: request to
  https://sitename.org/extern/rest.php failed with status code 404

If I'm already admin, what other possible reason could it be that I'm still getting blocked?

Thank you!

The URL was wrong like, @user4278 suggested. It should have been:
sitename.org/sites/all/modules/civicrm/extern/rest.php


How long does the cache in the template_c folder last I use civicrm on WPEngine hosting which does not allow php files to be generated on their live environment (if you are not logged in as admin). Because of this I generate the php files in the template_c folder while logged in as admin (for the frontend civicrm pages). This means every time a php file in the template_c folder has to be re-generated a frontend civicrm page will crash.

Can someone give me a clue how long the generated php files in the template_c folder last so I can eventually re-generate them manually and avoid frontend civicrm page crashing? (or give me a better idea how to handle this).

It's actually compiling Smarty templates, not PHP pages. There is no timeout on how long they are valid, as the underlying templates don't change.


Can ExtendedReports report on CiviDiscount usage? Can I get a list of Contacts that have used a specific CiviDiscount code? How do I extend - Extended Reports extension?

Yes - you can now!
See https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport/pull/148

Adding field label from the civicrm_line_item table allows admins to search (i.e. filter) for Contacts, Contributions that have had a discount code applied to them - in the standard report environment so Actions (exports) as well as Add to Group are available out of the box.

The screenshot below uses template civicrm/report/price/contributionbased - but any ExtendedReport will now have line label as a field/option for you to specify what discount code you'd like to search for.


How to send a formatted mail for webform submission? I have created a Unpaid event and connected to the webform. Although online registration is enabled and email option is ticked, I was not able to send a formatted email.

I am able to send email using the webform email settings submissions.

Is there a workaround? Thanks

You could use CiviRules for this.

Additional info:
Consider setting a small delay (when you configure your CiviRule) to ensure all CiviCRM data are saved before you Email your message out.

PS in additional to CivRules - you will also need to add the Extension: https://civicrm.org/extensions/e-mail-api


How do i delete past events? I have some events that are over some by years, which are not showing up on my manage events.  I am trying to clean up the data but I can't even find my past events.

I also need to delete the Price sets but it won't let me do that because it's attached to the event.

I do need to keep the participants information.

Unfortunately you can't delete the event if it has participant. If you delete them the its participants will be deleted automatically. Even its not advisable to delete price set if it was ever used to record participant ticket, contribution or membership. If you delete them you will loose all financial data associated with it or the system might behave weirdly if you ever try to update the participant or contribution or membership.

If you want this price set not to be displayed on screen then you can set is_quick_config = 1(TRUE/Yes) either running sql or from api explorer.

Cheers

Pradeep


Could not establish connection I am using CiviCRM for 6 months now and suddenly, since a couple of weeks when I try to enter or change an address I get a pop up saying "Netwerkfout
Geen verbinding met de server. Ververs deze pagina in uw webbrowser en probeer het opnieuw." The web-console reports "Unchecked lastError value: Error: Could not establish connection. Receiving end does not exist. background-index.js:1 createSyncMiddleware moz-extension://51240b76-34de-491a-a81e-3e49bd7d7805/background-index.js:1:623946".
I can change other member fields, though.

I followed all instructions on https://docs.civicrm.org/dev/en/latest/tools/debugging/ , and also tried different browsers, with plug-ins switched off.

I am still running CiviCRM 4.6.38, and I notice that my provider is still running MySQL v5.0.95 (and not very willing to upgrade). Latest WordPress version.

Any hints on how I could solve this problem?

Invalid geocoding settings were the problem.


Multi language update to 4.7 does not update Custom Field Sets to be 'is public' Ran the update script and said it upgraded successfully... however, when running the Wordpress page where my subscription form was, got a No Such Field error...

It seems that the civicrm_custom_group_xx_XX views are not updated to include the is_public flag... The civicrm_custom_group table is updated, but not the views...

While the patch in https://github.com/civicrm/civicrm-core/pull/10399/files will fix the issue for future site upgrades, it won't help with site that are already experiencing this issue. Running the following will fix sites affected by this issue:

drush eval 'civicrm_initialize(); $domain = new CRM_Core_DAO_Domain(); $domain->find(TRUE); if ($domain->locales) { $locales = explode(CRM_Core_DAO::VALUE_SEPARATOR, $domain->locales); CRM_Core_I18n_Schema::rebuildMultilingualSchema($locales, NULL); }'


Issue while configuring Repeating Event I am trying to configure an Event to repeat on every second Sunday but upon saving the event it shows incorrect dates in the Confirmation screen where it shows the same start date for each month and upon confirming it gives an error stating "Invalid day name". I tried by giving other day  and it is working correctly but not for "Sunday". This was on CiviCRM version 5.10.3. I tried by upgrading to 5.13.2 but the issue was same in that also. I am not sure what I am missing. Kindly help me to fix the issue.

I'm thinking the invalid day name error is the result of the start date of June 10, 2019 which is a Monday, not a Sunday (note that in your screenshot, there is no date listed for the "Original" event). If you change the start date to June 9 (which is the second Sunday in June), then the repeat function works as expected (on 5.10.alpha1):

Hope this helps,
Tamar


Temporary table keeps showing up and throwing MYISAM error and Missing Log Tables error One installation I help with keeps throwing a MYISAM error that is related to a temporary table, as well as a "Missing Log Tables" error (which I assume is related as they always appear together). If I clear caches, the table disappears and the errors in the system status go away, but they comes back later.

Based on some grepping, it seems this is a "durable" temporary table, generated in civicrm/CRM/Utils/SQL/TempTable.php -- is there some way in this file that should be specifying INNODB? Or is there a configuration setting on my server/database that isn't set right?

Table name: civicrm_tmp_d_dflt_randomstringofnumbersandlettershere

I had a server tech look at this and it looks like this installation is on a server that has been upgraded from some time back, but retained an old setting:

  It looks like the default engine set within /etc/my.cnf was still set to MyISAM...

We are in process of updating that and will restart MySQL in the middle of the night soon. I'm assuming this will fix it (but will update here if not).


Why does A/B testing cause 'dedupe by email' to fail when sending CiviMail to contacts with same email address Client is asking why 4 emails have been delivered to 4 contacts who all have same address.

Test1: tested with 2 contacts and didn't use A/B testing.

Outcome: was told would be delivered to ~1 address and was only 1 delivered - GOOD

Test2: tested with same 2 contacts with A/B - 50% to A and 50% to B (so no FINAL mailing)

Outcome: was told would be delivered to ~1 address and was only 1 delivered (to A mailing) - GOOD

Test3: tested with 4 contacts sharing same email with A/B - 25% to A and 25% to B and 50% to FINAL

Outcome: was told would be delivered to ~1 address. Had 1 delivered (to A mailing), 1 delivered to B mailing, and 1 delivered to Final mailing - BAD

So I think A/B testing is causing 'dedupe by email' to break

From what you describe it sounds like the deduping is happening within each group rather than before the recipients are split into A, B and final groups.

You could confirm this by doing:

Test 4: 8 contacts sharing same email with A/B - 25% to A and 25% to B and 50% to FINAL

I would expect the same results as for test 3: 1 delivered to A mailing, 1 delivered to B mailing, and 1 delivered to Final mailing.


My users can't unsubscribe themselves from (or subscribe to) smart groups from Wordpress I am running 4.4.2 of Wordpress with Civi 4.6.10. I have a test site (WP 4.4.2, Civi 4.6.4) that works fine with the same set up. I have set up a profile with a groups field, and 2 public groups, one "dumb" and one smart. I am able to use the profile to unsubscribe from the regular group, but ticking (or unticking) the smart group has no effect on the membership of that group. Is this a regression that anyone is aware of? Or perhaps I have missed something in the set up?

NOTE: Having written the below as an 'answer' I am less certain it is since it seems to raise more questions but will leave as such for now.

A contacts who is 'in' a Smart Group, is not 'added' to the Smart Group in the same way as they are to a General Group.

Hence I would not expect such a contact to see the checkbox for the Group 'ticked' when they go to the Profile.

Ie when I go to http://d46.demo.civicrm.org/civicrm/profile/edit?gid=16&reset=1 I do not see the group 'name like lan' checked, so it cannot be unchecked.

Does that make sense in your situation.

if lan does tick that group, then he gets sent an email for the double opt-in.

But when i Search within that Group for members Pending, it shows me all 11 contacts which I did not expect

11 Contacts
Group(s) In name like lan ...AND...
Group Status 'Pending'

Wondering if the latter is a bug but not digging on other sites to prove outcome with older versions.


nativecode=1260 ** Row 60 was cut by GROUP_CONCAT() After an upgrade from 5.7.x to 5.13.x, a standard contribution/detail report started failing. In the CiviCRM admin log, we see this sql error:

nativecode=1260 ** Row 60 was cut by GROUP_CONCAT()

Which appears to be getting generated at line 546 of civicrm/CRM/Report/Form/Contribute/Detail.php
i.e. creating a temporary table as part of the post processing.

This is a monthly report for credit card contributions, a similar one for ACH/EFT is not failing, so it appears to be some kind of limit issue.

One solution appears to be to update a mysql setting, as noted here:
https://stackoverflow.com/questions/7208773/mysql-row-30153-was-cut-by-group-concat-error

On this server (mariadb 10.1), the setting is not specifically configured, and has the default setting:
group_concat_max_len = 1024

As an ad-hoc solution, I put

CRM_Core_DAO::executeQuery('SET SESSION group_concat_max_len=15000');

In the report code, before line 546, and that fixed it.


A way to test schedule reminders I'm looking for a way to test schedule reminders for memberships. We have memberships that expire in a year, and we have setup a renewal reminder which also reminds our back office staff a month before the expiry date. But I need a way to test that the reminder actually works. Is there a way to test this quickly test this...obviously I cannot wait until one month before a particular membership expires to confirm this.

It might help to differentiate types of testing, e.g.

(User-oriented) Click-to-test/in-app test - This is the type of test supported in the CiviMail UI (which sends an example mailing). As dlobo points out, this type of test was not originally part of the scheduled reminder system, but it would be a great addition.
(Developer-oriented) Unit testing - For developers who work on the code, there's a series of automated tests in ActionScheduleTest which simulate a dozen configurations/schedules.
(Sysadmin-oriented) Adhoc testing - At the low-end, one might simply create a fake membership record and set the expiration date to today. At the high-end, one might replicate a site in an isolated environment (eg a local virtual machine), redirect email to disk (CIVICRM_MAIL_LOG), and manipulate the clock in the virtual machine. (This may require a deep understanding of the system as well as a lot of time/patience/discipline.)


Property of non-object notice after submitting CiviCRM Webform with Contributions I’m using Webforms for CiviCRM 4.28 for a membership registration and payment form and have Pay Later set as the payment method. When the form is submitted I get the following errors shown on the confirmation screen once the form has been submitted.

Notice: Trying to get property 'tax_amount' of non-object in CRM_Contribute_BAO_Contribution::checkTaxAmount() (line 4272 of /xxxxxxxx/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php).
Notice: Trying to get property 'total_amount' of non-object in CRM_Contribute_BAO_Contribution::checkTaxAmount() (line 4278 of /xxxxxxxx/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php).
Notice: Trying to get property 'total_amount' of non-object in CRM_Contribute_BAO_Contribution::checkTaxAmount() (line 4279 of /xxxxxxxx/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php).
Notice: Trying to get property 'fee_amount' of non-object in CRM_Contribute_BAO_Contribution::checkTaxAmount() (line 4278 of /xxxxxxxx/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php).
Notice: Trying to get property 'fee_amount' of non-object in CRM_Contribute_BAO_Contribution::checkTaxAmount() (line 4279 of /xxxxxxxx/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php).

I have the Membership and Contribution tabs of the CiviCRM Webform panel set up as follows.

The payment screen looks fine and the message shows after the form has been submitted.

I’m running CiviCRM 5.16.2 against Drupal 7.67.

Any ideas what could be causing this and how to resolve?

A couple of quick thoughts:

upgrade to Webform CiviCRM 5.x (we’re no longer supporting 4.x)

Edit: we have now officially disabled support for D7 - 4.x - you will now have a ‘unsupported version’ warning in your Drupal status report.

what is your PHP version?

always switch off notices on production sites: goto admin/config/developement/logging and set to -> None

open an issue on our drupal.org webform_civicrm project page and give us exact steps to reproduce


To prevent cron emails do I need to redirect output to /dev/null? My cron job

usr/local/bin/wp --user=cronuser --url=https://mysite.org --path=/srv/www/mysite.org/public_html civicrm api job.execute auth=0

outputs:

Array
(
    [is_error] => 0
    [version] => 3
    [count] => 1
    [values] => 1
)

Is there a way to prevent this output without redirecting to /dev/null ? I'd like to get an email if there is a problem.

clarification: I'm really asking how to stop the output (if there are no errors) from the wp-cli command for scheduling civicrm jobs.

What I've done to fix this is create a bash script that executes the civicrm api command, captures the output to a variable, tests for the string [is_error] => 0, if there's no match, then it echos the output of the command.

Here's the script:

 #!/bin/bash

output=$(/usr/local/bin/wp --user=cronuser --url=https://mysite.org --path=/srv/www/mysite.org/public_html civicrm api job.execute auth=0)

### only print if error is not 0

if [[ $output != *"[is_error] => 0"* ]]
then
  echo "$output";
fi


Save/submit button when profile is set to "view" One gets "Save" and "Cancel" buttons when adding a profile in "edit" mode.
I'd like to see the same when presenting a profile in "view". Why? The client checks the entry and can then submit it - if changes have to be made, they go back to an editable profile page, just looks nicer in "view".
I've played around a bit with scripting - but no luck given little programming intelligence.
Any idea - this is all on a Wordpress platform.
Cheers

This is a very non-coder way - I've got no real programming skills, so hacked around a bit - and maybe there are other ways of doing it better...

[civicrm component="profile" gid="yourvalue" mode="view" hijack="0"]

<form id="Edit" class="CRM_Profile_Form_Edit" action="http://yoururl/?page=CiviCRM&amp;q=civicrm/profile/edit" method="post" name="Edit" data-warn-changes="true">

<input name="entryURL" type="hidden" value="http://yoururl/?page=CiviCRM&amp;amp;q=civicrm/profile/edit&amp;amp;" />
<input name="gid" type="hidden" value="yourvalue" />
<input name="_qf_default" type="hidden" value="Edit:next" />

<input id="_qf_Edit_next" accesskey="S" class="crm-form-submit default validate" name="_qf_Edit_next" type="submit" value="Save and complete registration" />

Gives you->


Does CiviCRM integrate with 3rd party email account I cannot specifically find this information, so therefore the question.
We would like to know if civicrm integrates with say external email accounts so that emails received from constituents into our normal email accounts are automatically recognised and mapped to the constituent record so that emails sent and received can be viewed within the civicrm as part of the constituent activity.
Wayne

Civi has integrations for GMail and Outlook 365, but also has a feature Pete mentions in the comments called "Inbound Mail".  This works with all mail systems, and is also more seamless than the integrations.
The official integrations are for having LESS automation - e.g. if two people have the same email address, it will pop up a box to let you choose, while the automated method picks the first matching contact it finds.  Or let you use CiviCRM as an address book.  You may still want them.
For what you want, I would set it up like this:

Create a new mailbox at your organization,  e.g. "civicrm@example.org".
Set a filter in your mail program to automatically forward (or better, redirect) a copy of each email to this new mailbox. Note you can tweak your filter to exclude certain types of mail (e.g. listservs).
Configure CiviCRM to check this mailbox (Administer menu >> CiviMail >> Mail Accounts, then Add Mail Account).  Exact directions are in the documentation linked by Pete.  Also be sure to read about permissions for users to edit inbound emails - this is new in Civi 5.31+.
Make sure the Process Inbound Mail job is turned on in Scheduled Jobs (Administer menu >> System Settings >> Scheduled Jobs).
If you need further customization, it can be done through extensions.  E.g. this extension was written for an organization that wanted two inbound email addresses, and emails sent to the second address were restricted to privileged users.


Can you use multiple payment processor on one form I want my users to be able to choose from two different payment processors. I have two payment processors set up in Civi. When I am logged in as admin and go to my donate form I see a fieldset called "Payment options" where the user has an option to choose which payment processor they want to use. (one is for credit card and one is for electronic check). Everything works as expected until I am not logged in as admin. When I am not logged in as Admin I only see the default payment processor which is the credit card. How do I get that "Payment Options"  fieldset to show for non-admin users?

I see the fieldset when I debug the page. It is called "crm-group payment-options-group" and it is set to display="None" Is there a way I can get this to display on my public forms?

I am using Wordpress, Civi 5.7.2 and I am using a Civi contribution form.

I figured out the issue. It was the Autoptimize plugin that was causing the total amount not to show. I checked the setting: "Force JavaScript in ? Load JavaScript early, this can potentially fix some JS-errors, but makes the JS render blocking."

Now that I have this checked the total box shows and I get the payment options section to show. Yay!


How do I disable civicrm.css on public pages in Drupal? I have the following in my template.php file, in my custom theme:

function shriver_css_alter(&$css) {
    unset($css[drupal_get_path('module','civicrm').'/css/civicrm.css']);
}

It doesn't work, though. I can disable other stylesheets this way, but not this one. I know I can disable this stylesheet in civicrm settings, but then it is disabled on the back end as well. I only want it to be disabled on the public pages. Since I use a different admin theme than my public one, I thought it made sense to disable it for my public theme only.

Can someone help me to get this to work? Or, if you know a different method, that would be good, too. Thank you.

This is the correct way to disable civicrm.css on the front end. Put this in the template.php file of your theme:

function shriver_css_alter(&$css) {
    unset($css['sites/all/modules/civicrm/css/civicrm.css']);
}

Manually enter the path to the css. When I used drupal_get_path('module','civicrm'), it would output sites/all/modules/civicrm/drupal/css/civicrm.css. Not sure why it added 'drupal' to the path but that was the problem.


Why does CiviCRM cause a cURL error 28? Site Health in WordPress is showing a few cURL error 28 errors when we have CiviCRM installed and activated. Deactivate CiviCRM, the problem disappears. Activate it, the problem is back.

I've seen the WordPress Site Health contains critical errors unless CiviCRM is disabled question, but my research has found no justification for the top response that the health checks are inaccurate. So I need to dig deeper to try to solve this.

During a long chat session with tech support for the hosting company (SiteGround), they could find no reason for the error on their end. Server memory is maxed out, phpinfo shows everything is current and up to date (and shows server memory as 768M). So far, all of the diagnostic things I've found online have been dead ends.

With Query Monitor installed, I can see that the offending call is Health_Check_Site_Status->get_test_rest_availability(), which uses the URL

https://[URL]/wp-json/wp/v2/types/post?context=edit

That health check works fine with CiviCRM disabled, but chokes with it activated, giving the cURL error 28.

What is CiviCRM doing that causes that call to fail?

When I looked at this I found that SiteHealth does not account for sessions and CiviCRM depnds on them.  See the discussion at https://lab.civicrm.org/dev/wordpress/-/issues/32


Log Entry View and other settings pages don't load (5.18.4, Drupal 7.67) recently I am unable to load Log Entry Views and other settings pages in my Drupal CiviCRM. On the page it shows the following errors:

Warning: include(/var/www/html/sites/default/files/civicrm/templates_c/de_DE//%%48/488/4880C3C4%%LogViewEntry.tpl.php): failed to open stream: No such file or directory in include() (Zeile 1911 von /var/www/html/sites/all/modules/civicrm/packages/Smarty/Smarty.class.php).

Warning: include(): Failed opening '/var/www/html/sites/default/files/civicrm/templates_c/de_DE//%%48/488/4880C3C4%%LogViewEntry.tpl.php' for inclusion (include_path='/var/www/html/sites/default/files/civicrm/ext/uk.artfulrobot.civicrm.importhelper/:/var/www/html/sites/default/files/civicrm/ext/ca.bidon.civiexportexcel/:/var/www/html/sites/default/files/civicrm/ext/ca.civicrm.logviewer/:/var/www/html/sites/default/files/civicrm/ext/com.agiliway.civimobileapi/:.:/var/www/html/sites/all/modules/civicrm:/var/www/html/sites/all/modules/civicrm/packages:.:/var/www/html/sites/all/modules/civicrm:/var/www/html/sites/all/modules/civicrm/packages:/var/www/html/sites/all/modules/civicrm/vendor/tecnickcom:/var/www/html/sites/all/modules/civicrm/vendor/phpseclib/phpseclib/phpseclib:/var/www/html/sites/all/modules/civicrm/vendor/pear/pear_exception:/var/www/html/sites/all/modules/civicrm/vendor/pear/auth_sasl:/var/www/html/sites/all/modules/civicrm/vendor/pear/log:/var/www/html/sites/all/modules/civicrm/vendor/pear/console_getopt:/var/www/html/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src:/var/www/html/sites/all/modules/civicrm/vendor/pear/mail:/var/www/html/sites/all/modules/civicrm/vendor/pear/net_socket:/var/www/html/sites/all/modules/civicrm/vendor/pear/net_smtp:/var/www/html/sites/all/modules/civicrm/vendor/pear/validate_finance_creditcard:.:/usr/share/php') in include() (Zeile 1911 von /var/www/html/sites/all/modules/civicrm/packages/Smarty/Smarty.class.php).

The last major change to my CRM was adding the civicrm.importhelper extension.

Welcome to Stack Exchange!  I'm tempted to mark this question as a duplicate to point you to existing answers - but I'm struggling to find the "one true answer". templates_c cache files not being deleted is close.  Essentially, it sounds like something created a file in templates_c that's not readable by the web server user.  The quick solution is to delete the templates_c folder - this is always safe and it will regenerate.  However, in the longer term you need to find what caused the problem.  Are you running cron as a user other than the web server/PHP user?  Are you running drush from the command line as a user with different permissions?  If you don't find the solution the problem will keep coming back.


Order form for materials on donation basis (CiviCRM / WordPress) We are new to CiviCRM and are looking for an easy way to enable the following:

Must have:

An interested person may order materials (e.g. postcards) and may promise to give donations for it
Verification email
The person and a person doing the shipping should receive an email

Nice to have:

Update of CiviCRM contact
Creating a activity for that contact
Possibility to do the donation with CiviCRM

From StackExchange research I got the impression that best way to do the "must haves" and 1./2. would be a best to use Caldera Forms + Caldera CiviCRM Plugin + Caldera Verify Form.

Is this the appropriate way to do it, or is there something easier (e.g. CiviCRM forms/profiles)?

Is it possible to include the donation from CiviCRM directly into such a thing? (It's not a shop function, where you have to pay, it should really be a donation.)

In theory you can set up a Contribution page with Price Set with all your 'merchandise' available as Price Fields so they could order eg 5 postcards or 3 x pack of 3 cards etc.

Then i you set the form for Pay Later that becomes a 'promise' which is recorded in civicrm as a pending transaction.

when they submit then the purchaser will get an email, and the 'person doing the shipping' can be added as a CC or BCC via the Contribution Page settings

may not fit what you need but worth understanding what is possible via that route

it does not create the Activity (other than the one that CiviCRM creates for any contribution)


How to set the main email account to send emails? I'm switching my SMTP gateway to send emails from CiviCRM but for now I still have both. And even though I thought everything was sent from the newly configured service in https://domain.net/civicrm/admin/setting/smtp?reset=1 I can see in logs that automatic reminders are still sent from the previous gateway and not from the new one.
Have I missed something? Do I need to configure an account elsewhere in CiviCRM for automatic reminder or any transactional email or is this just a normal delay?
Any ideas?
Guillaume

it seems that there's a kind of delay for scheduled reminders because now all emails are sent from the right smtp account.


How to trouble-shoot 'critical error' while merging duplicates? Using civicrm-5.21.2-wordpress.zip, (and also 5.20), I get a 'crash' ('There has been a critical error on your website. Please check your site admin email inbox for instructions.') for any attempt to merge contacts.

None of the WordPress trouble-shooting info has helped. I don't get any CiviCRM trace-back or debugging data. I don't see anything in the Apache error.log .

Any other suggestions for trouble-shooting this?

I'll dig deeper in another post, but as far as this problem was concerned, I used print and var_dump to trace the problem to

public static function getReferencesToTable
.
.
.
$links = $daoClassName::getReferenceColumns();

'crashes' because one of the classes was NULL.

While I work on WHY, I got around the crash with a simple:

if ( $daoClassName != NULL)

wrapper.


Allowing group management to users with limited permissions This may be a shortcoming or bug to-do with access control, but maybe I'm missing something.

I've setup Drupal permissions and ACLs and they are working 100% except for one thing:  users can only view the groups for which they explicitly have an ACL for.  In other words, only users with CMS permission to "View all contacts" can view groups they themselves created.

Am I correct in assuming that this is a shortcoming, or is it a bug?  Either way, what are y'alls suggestions for allowing users be able to create, edit and manage their own groups without giving them "View all contacts"?  Is there a way to do it using hook_civicrm_aclWhereClause?

Yes, this is a shortcoming in the current acl system.

One possible workaround for this might be to implement the post hook on the civicrm_group object. The post hook can take the contactID of the person creating the group and add an ACL giving this person access to the group.

You can implement the above hook in an extension. Probably worth considering including this in core need on a setting


Drupal account creation adds users into a CiviCRM group or tags them We are trying to create a report that shows our new website members (those who have created an account) who are designated by mandatory CiviCRM profile fields that define a member type which the user selects at registration. These fields are displayed on the Drupal registration and account editing screens.

When users create an account on Drupal, a contact is either created for them in the CiviCRM, or a matching and existing CiviCRM contact record is found and updated. The custom fields already exist and are displayed on the website. What I would like to do is have the contact record be either added into a group or given a tag, which would ultimately make it easier for me to generate accurate reports about our different "members". The tag or group would be the same for all users. Something like "Users who registered for an account". Some of our contact records are created for other reasons so that's why I want to distinguish between the two.

Drupal 7, CiviCRM 4.7.27

If you are using profiles for user registration than you can configure profile to add contact to a Group. This will have contacts who submits the profile added to group and then you can use filter group in in reports or search.


Font-Awesome icons not showing -- missing class=fa? The Font-Awesome icons are not showing properly.  I believe this is because the required class "fa" is missing everywhere where one of the icons is supposed to display.  I have tested this by modifying templates/CRM/common/fatal.tpl, adding "fa" in the appropriate place in line 49.  Without the fa class the browser shows a blob character; with the fa class the correct icon shows as desired.  Quite a number of templates are affected (assuming I am correct).

I'm running CiviCRM 4.7.23 (with no local customization) on Drupal 7.56.

It sounds like you've identified a bug — and found a fix. Excellent!

I can confirm this bug by observing the fatal error message displaying a funky character before "Sorry" as shown below.

Here are some next steps that I'd recommend for you here:

Report the bug in CiviCRM's issue-tracker, Jira. If you're new to reporting issues, read over these issue-reporting guidelines in our Developer Guide.
After reporting the bug, you can choose to stop there and wait for someone else to fix it. But, given that this issue has a relatively minor impact, developers will be unlikely to volunteer their time on it unless you offer funding to the Core Team or to an independent expert.
Since you've already dug into the code yourself, I'd encourage you to work on contributing a fix. Here are some tips:

Use git blame (possibly via GitHub's web-based git blame) on that line of code to see if there are recent commits which are relevant to the issue. Ah ha! In this case we can see that  someone recently made a change to "use class crm-i instead of fa".
It would be prudent to look deeper into that commit to try and understand it. I haven't gone too deep, but I did notice that the commit also changed the warning at the top of the "Option Groups" page (/civicrm/admin/options?reset=1), and that message seems to be displaying okay right now:

From the above, I'd recommend considering whether your fix should be limited only to the fatal error page (which might be behaving differently than other pages due to different CSS being included in it)
If you're stuck or want input from other developers, hop on Mattermost.

All-in-all, this answer is just intended to be a push in the right direction towards using other tools (i.e. Jira, GitHub, and Mattermost instead of StackExchange) for reporting (and hopefully fixing) this bug. In some ways you're lucky to have found a bug which will (probably) be super easy to fix! Fixing this bug would be a great stepping stone towards improving CiviCRM in bigger ways too!


Customizing the CiviContribute form through Drupal module I need to perform a simple update of default values to a few CiviContribution forms on a client site. I was reminded that developing a Drupal module to customize the behavior of CiviCRM was the way to accomplish what we are in need of accomplishing. I coded up the following module:

<?php

/**
 * buildForm hook
 */
function civicrm_cir_civicrm_buildForm( $formName, &$form )
{
  // Only operate on CiviCRM Contribution Forms
  if ( $formName == 'CRM_Contribute_Form_Contribution_Main' )
  {
    // Test for specific contribution forms by CiviCRM form ID
    if ($form->getVar( '_id' ) == 15 ||  // Yearly CC
        $form->getVar( '_id' ) == 16 ||  // Yearly PP
        $form->getVar( '_id' ) == 13 ||  // Monthly CC
        $form->getVar( '_id' ) == 14 ||  // Monthly PP
        $form->getVar( '_id' ) == 8  )   // Weekly CC
    {
      // Set the check box for recurring contribution
      $defaults['auto_renew'] = array('checked' => '1');
      $form->setDefaults( $defaults );
    }
  }
}

Initially when the CiviContribution forms are loading, the Drupal module fires in the desired form data change... The recurring contribution check box is checked.

However when the form finishes loading the check box flips back to unchecked, and the default selection price becomes bolded simultaneously.

A Drupal developer I know who is not vary familiar with the code of CiviCRM suggested perhaps if CiviCRM uses the Drupal Form API to build its forms, then I could use the "Hook Alter" type API's to rearrange the order these events fire in... allow the CiviCRM form default population to occur first, and then fire my custom module (above) to check the AutoRenew check box.

Or if this is still not the correct way to check the AutoRenew check box in current CiviCRM powered by Drupal 6.x, then please kindly advise what is the correct way to check the AutoRenew check box.

I am thankful,

Michael

From what you describe, it sounds like you are seeing some of CiviCRM's contribution page JS kick in after your customised form is rendered.

It is probable that configuring your CiviCRM Contribution page to use the defaults you desire will resolve this issue. Your approach of setting the defaults should translate to setting the form values, which should then be respected on initial load, but ... that's not happening :)

Take a look at the JS inlined on a default CiviCRM contribute form, eg the CiviCRM Demo site's Member Signup and Renew form when configured to permit optional membership auto-renew.

If you inspect the code immediately after the auto_renew element, you'll see this block coming from CiviCRM's templates.

<script type="text/javascript">
CRM.$(function($) {
    //if price set is set we use below below code to show for showing auto renew
    var autoRenewOption =  '0';
    $('#allow_auto_renew').hide();
    if ( autoRenewOption == 1 ) {
        $('#allow_auto_renew').show();
    } else if ( autoRenewOption == 2 ) {
        var autoRenew = $("#auto_renew");
        autoRenew.prop('checked',  true );
        autoRenew.attr( 'readonly', true );
        $('#allow_auto_renew').show();
    }
});
</script>

That code is fairly straightforward to read - if auto_renew is set to 2 (from the contribute form settings, which allow you to configure this behaviour per contribute form), then the JS will check that box on page load, as you're seeing.

If I'm reading all that right, and with the caveat of not having seen your actual site at all, I think you can configure this from your contribute form settings for each of the form IDs listed above. The setting is on the "Membership" tab and looks like this:

The recurring defaults are tied to the settings in the Contribute form (and depend on settings in both Membership Type and Payment Processor config).

If that's not enough, you can override the JS by customising CiviCRM's templates, and you can add your own JS also if need be. That then would be your next path forward - modify that template variable based on the switch statement in your existing code.

You can certainly do it via JS though, as demonstrated by this customised contribute form (js here).


Registration Pages for individuals and Organisations How can I create new registration pages for individuals or organisations using the default CiviCRM forms?

If you're asking can an organization register for an event using an online CiviCRM registration page, then the answer is no - or not without a customization - the CiviCRM database does allows it.

In general, the online forms for contributions, membership, and registration have built in logic that assumes the user completing the form is an individual user.


CiviCRM 5.13.1 is not showing "Added By" coumn value I upgraded site Drupal 7.66 + CiviCRM with latest version 5.13.1 and found out that if you go to any user profile and click on Activities tab then you can see there is "n/a" in "Added by" Column.

But when I click on "View" activity link then I can able to see "Added by" value.

It was working with last version 5.10.4, I think this is bug in CiviCRM latest version.
Any help is really appreciate.

Created issue civicrm lab
https://lab.civicrm.org/dev/core/issues/951

I'm marking this question as now being answered.  The problem is resolved by upgrading from civicrm version 5.13.1 to 5.13.4


Change donation to another donor We have accidentally attributed a credit card donation to the wrong person. How can we change the donation to the correct donor? Do we have to delete the donation on one record and add it to the other? Thanks!

There is an extension called Move Contribution that will allow you to move the contribution, however, it does not appear to have been updated since Aug. 2016 and last compatible version was 4.7, so there is a chance that the extension will not work with whatever version of Civi you are on.

In the absence of the above, and assuming that the correct credit card was charged but just recorded on the wrong contact, the correct way to manage this is to:

Navigate to the original contribution and click the Edit hyperlink
Change the Contribution Status to "Cancelled" (financial transactions should never be deleted, especially where electronic ones are concerned)
Since transaction IDs must be unique, make note of the transaction ID, then add a "-C" in the original contribution's transaction ID field
(OPTIONAL): If your version tracks the information, make note of the card type and last 4 digits of the card
Click the Save button
Navigate to the correct contact record's contribution tab and click Add Cash/Check... Contribution
Record the contribution details, selecting the payment method of credit card
Enter the original transaction ID you noted in item 3 above and any additional card details as desired
Click the Save button

If the incorrect credit card was charged, then you will need to issue a refund directly through the payment processor, change the original contribution status to "Refunded" in CiviCRM, and then process the correct credit card on the correct contact record accordingly.

Hope this helps!

Tamar


Percentage Price Field extension not working for Additional Participants? It seems like the Percentage Price Field extension mentioned in post Adding a dynamic “cover processing fees” checkbox to CiviCRM contribution form is ideal for my needs, except for one problem:  payment type exclusions are not followed in the Additional Participant template, and the percentage is always added to additional participant form totals regardless of the payment type chosen on the first registration page.

How to reproduce:
-- Create an event where one person can register multiple participants at once
-- Configure a percentage price field in a price set to add 3.5%, "Hide checkbox and force to "yes" is checked (to suppress the optional checkbox), and "Disable for payment methods" is selected for "Pay Later".
-- Go to the event registration page and say you are registering 2 people.
-- the first registration page works fine; the user is given a payment option choice, and the percentage is added only if they choose a payment processor, not for Pay Later
-- Click continue to load the additional participant form.  The total always adds 3.5 percent regardless of the choice made on the first form.

Is there a way for the payment method choice made on the first form to persist to the additional participant registration forms?

Appreciate help from anyone who's had experience with this extension.

I heard back from the developer directly on GitHub who said this feature might be included in the future.


Fill Address/Phone enityRef I'm writing an extension to customize the create new activity page. I need to add the 'With Contact' address and phone number to the page. When editing the /civicrm/CRM/Activity/Form/Activity.php how do you get the address to propagate when the contact is selected? Here is what I'm trying to edit:

    ),
   'target_contact_id' => array(
   'type' => 'entityRef',
   'label' => ts('With Contact'),
   'attributes' => array('multiple' => TRUE, 'create' => TRUE),
    ),
   'target_contact_adress' => array(
   'type' => 'entityRef', //I'm guessing I need to change this line to call the address?
   'label' => ts('With Contact Address'),
   'attributes' => array('multiple' => TRUE, 'create' => TRUE),
    ),

Edit: To better explain what I'm trying to do. I'm creating a custom extension for an organization that uses the Activity assignment notification to email their volunteers that don't have access to the CiviCRM database contact information (Phone Numbers and Addresses) about their members. In order to do this I need to add two fields that pull this information when a contact is selected.

I'd suggest you create 2 custom fields for this in the activity (pickup location & contact phone number). You can then use a bit of javascript to insert the contact's email & phone into those fields and it will come through in the activity email. As an added bonus, this approach gives the flexibility of allowing the user to override those defaults if the person needs to be picked up elsewhere.

To do this, your buildform hook needs to do 2 things:

Request the extra address/phone info from the target_contact_id field. You can do:

$form->_fields['target_contact_id']['attributes']['api']['extra'] = array(
  'street_address',
  'city',
  'state_province',
  'postal_code',
  'phone',
);

Add your javascript to the form using CRM_Core_Resources (hint: create a js file in your extension, and use CRM_Core_Resources::singleton()->addScriptFile('myExtension', 'js/myScript.js'))

Your javascript can then use some basic jQuery like:

CRM.$(function($) {
  $('#target_contact_id').change(function() {
    if ($(this).val()) {
      // This contains the extra fields you requested
      var data = $(this).select2('data')[0].extra;
      // For example, populate a custom field with the phone
      $('#custom_42').val(data.phone);
    }
  });
});

You can read more about javascript in CiviCRM here.


Is there any way to group cases? Is there any way to group cases, other than using tags?
We currently need this for an implementation where case management is used to fulfill wishes for children with chronic diseases. The organization has cases where they need to organize events on a high level for a whole group of children (booking hotels, travel planning etc.) and do some of the planning individually per child with a very different set of activities (communication with parents, getting authorizations etc.). I feel that tags are not sufficient in this case and I would prefer to have a parent case with child cases assigned to it - or at least a group so we would have better selection options in the system. But groups are only available for contacts (?)

There isn't anything exactly like what you're looking for. You can set a case as related to another case, so your parent case could be related to all its child cases. On Manage Case add an activity of type "Link Case", and then on both Manage Case screens that linkage will appear.


Cron Job configuration error i use wordpress 4.2.2 and civiCrm 4.6.3.
I have created a file CiviCron.php:

// create a new cURL resource
$ch = curl_init();
// set URL and other appropriate options
curl_setopt($ch, CURLOPT_URL, "http://www.auroratrezzo.it/wordpress/wp-content/plugins/civicrm/civicrm//bin/cron.php?name=user&pass=password&key=key-site");
curl_setopt($ch, CURLOPT_HEADER, 0);
// grab URL and pass it to the browser
curl_exec($ch);
curl_close($ch);

I have configurated cPanel cron job:

php /home/informac/CiviCron.php

I recived this error:

Fatal error:  Function name must be a string in /home/informac/public_html/wordpress/wp-content/plugins/section-widget/olt-checklist/loader.php on line 64

Why ??

Marco

The error seems to come from something unrelated to civi:

plugins/section-widget/olt-checklist/loader.php

Can you try to disable this plugin and see if it works?


Since upgrade, dompdf.php is presenting a security risk? Upgraded to 4.5 a few weeks back on Joomla 3.3.6 and everything is working fine, except for a warning that I see when I first access CiviCRM. Reads:

  Security Warning File
  /home/[directory]/public_html/administrator/components/com_civicrm/civicrm/packages/dompdf/dompdf.php
  presents a security risk and should be deleted.

Any idea what's causing this and what the proper way to address it might be (short of deleting the file)?

You can (and should) resolve this by removing that dompdf.php file from your system. It sounds like the previous version codebase was not removed during your most recent upgrade.

CIVI-SA-2015-001 was a security release which removed dompdf.php from the CiviCRM installation, as it permitted attackers to read arbitrary files from your webserver. This permits an attacker to retrieve the contents of files they would not normally be permitted to view - even system configuration files.

CiviCRM upgrade instructions advise to back up and then delete previous version code files before installing the new CiviCRM codebase, since leaving old code files in place may affect the behaviour of CiviCRM (and in cases like this, the removal of a file is the fix required).

A full list of recent CiviCRM security advisories is available at https://civicrm.org/advisory, and CiviCRM site administrators should sign up for security upgrade notifications


Webform CiviCRM or CiviCRM Entity? Until now whenever I've needed to enable site visitors to enter or update data in Civi on Drupal sites I've used webforms and the excellent Webform CiviCRM integration module. By and large it does the trick. However on a couple of sites I'm currently working on I need to enable suitably authorised users to create some content - I'll call it a project profile - that will contain a mixture of Civi data (org name, related individual contact name/s, website, etc.) and what would sensibly be Drupal field data (a couple of URLs, some images, a logo, maybe a link to a Youtube video, some descriptive text, etc.). I've read all the stuff I can find about the CiviCRM Entity module and it sounds like the right fit for my needs.

If the content creator would only ever create one project profile then a webform based approach seems optimal, but I can see that users may want to create multiple project profiles, and have the ability to edit them, which for me seems to indicate that CiviCRM Entity is the way to go.

So I've started to play with it, and now I'm less certain. I've created a new Drupal content type (project profile), and want to include an organisation name that will be stored in CiviCRM. Using this post as a guide to how to go about it I've got the field to work pretty much as I need it, but this seems like a lot of work to get just one field in my content type to do what I want. Repeating this for each field that I want to be included that contains data from Civi entities will take some time, and I'm unclear as to how the disparate bits of data will be linked together - if the author enters an organisation name in one field and an email address in another does the module understand that the email address belongs to the organisation record?

Which all makes me wonder that maybe I'm going about it the wrong way.

Should I instead be adding Drupal fields to the CiviCRM Contact entity and using the CiviCRM Entity Reference module to bring in data from other CiviCRM entities (phone number, email address, etc.)? Or is that approach essentially the same?

I'm concerned about investing a huge amount of time going down the CiviCRM Entity route only to find that it's not the best approach for my use case, but I'm not even clear about what the key questions are that might help me make a good decision.

This looks like a really powerful approach, but it also feels like I'm highly likely to not get the result that I want, and spend a lot of time getting there.

Any advice, links to good guides, videos etc., most welcome.

CiviCRM Entity is the way to go if you want content creators to reference create CiviCRM data on nodes or other Drupal entity types...The downside is, assembly on some not so well documented features required. We have used it to allow users to add/edit contacts with emails etc..well as you know, I wrote that article.

There is this article too which tries to explain the CiviCRM Entity Reference field: https://skvare.com/blog/using-civicrm-entity-reference-field-submodule-inline-entity-form

If you place a CiviCRM Entity Reference field on the Contact entity, and target Emails, then it will save the email and connect it to the contact as you would expect them to be. CiviCRM Entity Reference field is a "remote" reference field, in that it doesn't save data in any Drupal field tables, but accesses the Civi data directly.

You shouldn't have to setup your forms and any CiviCRM Entity Reference fields but once, and then you can use the same config with Entityreference fields on your node type over and over.

One big disadvantage to the D7 version, is that you cannot have multiple "form modes" in D7 .. that is multiple configurations of which fields appear on edit forms.....So if you want one entityreference field inline entity form for an organization contact, and another for an individual contact, you can run into problems, because you want the  organization name for the org contact, and maybe first / last name for the individual contact.

You can use hook_form_alter or css to hide fields when needed though too. You would configure your contact edit form to have all the properties/fields you may need, and then hide them as necessary for the different reference fields. That will require some development and special knowledge.

CiviCRM Entity is a very powerful tool, but does require some learning and elbow grease, and sometimes code, to make very custom setups.

As to which tool to use when, that depends on the use case IMO. I'd be happy to chat about it sometime on CiviCRM mattermost, chat.civicrm.org, civicrm entity channel, just ping jackrabbithanna. We use Webform CiviCRM alot too.


CiviCRM Fatal error: Uncaught CRM_Core_Exception: [0: Found installation canary If you can advise or solve my problem – please answer

I trying to install CiviCRM 4.7.14 for wordpress 4.7 on windows machine, all steps of installation based on official CiviCRM installation guide.
After step where i setup database connection and click install i got at left panel icon civicrm how it must be,
but after click on this button I got error about non correct path in civicrm.settings.php, after fixing double slashes to single slashes “/” in this file and update page I got next error that I can’t solve

Fatal error: Uncaught CRM_Core_Exception: [0: Found installation canary. This suggests that something went wrong with tracking installation process. Please post to forum or JIRA. thrown in C:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\Civi\Core\InstallationCanary.php on line 53

All requirements are fine and I do not got any warning or errors at step with install.

Thank you in advance

I just did an installation on my Windows Laptop, and it worked. I describe below my configuration. Maybe it leads to a working configuration on your system.

I downloaded and installed the xampp-win32-5.6.28-0-VC11-installer installer from ApacheFriends. The installation decides for the default home C:\xampp.
After the installation, the Xampp control panel starts. I start Apache and MySQL.
I open the shell to create the databases (I am more at my ease with Unix). I create the databases with the following commands:

mysql -u root

create database wp character set utf8;
create database civi character set utf8;
grant all on wp.* to wpuser@localhost identified by 'wppwd';
grant all on civi.* to civiuser@localhost identified by 'civipwd';
flush privileges;

I install WordPress by unzipping the download in the C:\xampp\htdocs directory. I remove all other files (to keep the installation clean).
I do the WordPress configuration according to the documentation. (database wp, user wpuser, password wppassword).
I unzip the CiviCRM (civicrm-4.7.14-wordpress.zip) in the directory C:\xampp\htdocs\wp-content\plugins.
Now I activate the CiviCRM in the plugins menu and complete the installation with the Almost Ready invitation. (database civi, user civiuser, password civipwd).
Installation completes without problems.

The civicrm.settings.php file is generated in the directory C:\xampp\htdocs\wp-content\uploads\civicrm. In the file is a mix of forward slashes and backslashes, but CiviCRM does not seem to bother. For example:

$civicrm_root = 'C:\\xampp\\htdocs/wp-content/plugins\\civicrm\\civicrm\\';
if (!defined('CIVICRM_TEMPLATE_COMPILEDIR')) {
 define( 'CIVICRM_TEMPLATE_COMPILEDIR', 'C:\\xampp\\htdocs/wp-content/uploads\\civicrm\\templates_c\\');
}


CiviCRM Event Shopping Cart Auto Fill When using Drupal 7.x and CiviCRM 4.6 we notice that the Checkout page does not autofill profile information for a logged in CiviCRM user. They must manually enter in their details, then face this bug: CiviEvents with Shopping Cart - two email fields showing, and finally update their credit card payment information.

How can we solve this?

I guess this will happens only for the admin user

Please try creating an user without admin right and try the same - should pre-populate the details on the screen.

I guess this helps !!!!


Captcha on Contribution forms I know that there is a Captcha function available for Profiles, but it seems that we have need for Captcha on contribution forms that do not use Profiles.  Is this possible?

Profiles on contribution pages that contain an e-mail address will have that e-mail address suppressed.  So if you create a profile with just an e-mail address and add a CAPTCHA, you should get the results you're looking for.


Cloudflare kills dashboard + Relationship tab error. Any ideas? Drupal 6.36;  CiviCRM 4.5.8
I am experiencing two problems after making changes to my site. Not sure if the problems are related. I will start troubleshooting but any guidance would be very helpful.
1. Civi dashboard loading icon spins and dashlets don't load. This may be related to us installing Cloudflare (http://forum.civicrm.org/index.php/topic,27176.msg142612.html#msg142612).
2. Relationships tab generates error on click. Screen loads but the relationships list doesn't open. The following two popups appear:

DataTables warning: table id=DataTables_Table_0 - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1
DataTables warning: table id=DataTables_Table_1 - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1

Clicking the Add relationship button opens the dialogue and allows it to be completed, but on saving the above errors appear again.
Background:

Moved the site to a faster server with no apparent problems
6 hrs later...
Upgraded Drupal 6.36 security release. All seems fine.
Tried to install Civi4.6.4 but it errored out so I reverted to the
4.5.8 backup. It was late and I didn't copy the error :-(
Implemented Cloudflare. Civi is appreciably faster. Cloudflare needs www. domains so I set up a redirect in htaccess and updated the Civi paths and resource URLs. Also cleared all caches

Thanks
Davy

Disabling Cloudflare or switching off popups as suggested didn't help. Neither did setting up a Cloudflare PageRule to bypass all Civi pages

But this worked:

I followed the instructions here  (http://wiki.civicrm.org/confluence/display/CRMDOC/Ensuring+Schema+Integrity+on+Upgrades) to clean up my database schema, and then the upgrade to 4.6.4 worked - and fixed the problems.


Advanced Search Using Custom Profile as Display View that Includes Groups Not Working after Upgrading to 5.9.0 After upgrading Civi from 5.3.1 to 5.9.0 (with drupal 7.61) any search results that use a custom display view (profile) does not work properly if that profile includes the groups or tags fields in the profile. Instead of the advanced search displaying all the records found it only displays one record at a time. At the top it may say "showing 1 to 50 of 100 records", but actually only shows one record.

I also hadn't realised that before upgrading, the groups or tags fields had not displayed at all in the advanced search - those columns would be missing even though they were included in the profile.

Is it possible to include groups or tags fields in a profile used for search results?

Disabling or deleting the groups/tags fields from the profile fixes the problem of only showing one contact at a time in the search results.

Screenshot attached

Pretty sure the "1 row" problem only shows if you search using one custom Profile then switch to using a second custom Profile

Ie

Reset Form
then use Default, (all rows show)
then switch to profile with Groups field (all rows show)
then switch to profile with Tags field - only 1 row shows.

Reset Form
then use Default, (all rows show)
then switch to profile with Tags field (all rows show)
then switch to profile with Groups field - only 1 row shows.

So the problem seems to relate to switching between one custom search Profile and a second one.

NOTE: above came to light when trying to demo to Eileen that i could replicate https://lab.civicrm.org/dev/core/issues/679

UPDATE: Fix at https://github.com/civicrm/civicrm-core/pull/13533


CiviCRM send notification to admin if payment goes failed on recurring charges I am using IATS payment processor. I want to get notified if any recurring charge goes failed.

welcome to CiviCRM Stack Exchange!
Navigate to Administer -> CiviContribute -> iATS Payments settings -> Here you can enter an email address which should be notified of failures (first option). There are some other settings here you may want to explore as well.