Contact Form 7 WP PLugin Shows Error when Info is submitted in form. The error is not present when Civi CRM is disabled We have been using Contact Form 7 (wordpress plugin) on our page for years to take in responses from our listeners during our live radio show. Recently I am troubleshooting an issue involving the plugin and am hoping someone can help shine light on the cause.

WordPress Version:4.8.1
CiviCRM Version:4.7.17

Description of Issue:
The form shows up correctly though it shows the error message below once you submit the info. The submitted info then makes its way to a specified email address which seems to be working correctly. There may be some emails that are not making it through as per some emails from our listeners.

Troubleshoot:
I disabled all plugins and found that our Civi CRM plugin seems to be contributing to the issue. I have checked the base url and all seems defined correctly.

Other Factors: We did recently switch to SSL though all urls seem correct.

Error Message”
“Sorry but we are not able to provide this at the moment.
We can’t load the requested web page. This page requires cookies to be enabled in your browser settings. Please check this setting and enable cookies (if they are not enabled). Then try again. If this error persists, contact the site administrator for assistance.Site Administrators: This error may indicate that users are accessing this page using a domain or URL other than the configured Base URL. Error type: Could not find a valid session key.”

Any suggestions would be appreciated. Thanks!

This is really digging back into the cobwebs for me but... I had a very similar problem that I think popped up when we set up SSL. I think that in the Form settings, under the Mail tab, I had to remove the To & From mail-tag and just use my actual email address. I may have ended up deleting the current form and creating a new one.


Upgrade database URL loops to WP login screen but works on a cloned staging site Experiencing a strange situation where the database upgrade url worked perfectly for a testing site but not for the live site.
I successfully tested the upgrade with a cloned staging site without a hitch in the upgrade process.
https://staging.islandnaturetrust.ca/
By following the CiviCRM Wordpress upgrade guide: https://docs.civicrm.org/sysadmin/en/latest/upgrade/wordpress/
However, as soon as I attempted on the main site the updgrade database url loops back to the WP login page.
https://www.islandnaturetrust.ca/
Steps:

Login as administrator for wordpress site
Paste upgrade database url into browser http://islandnaturetrust.ca/wp-admin/admin.php?page=CiviCRM&q=civicrm/upgrade&reset=1
Page redirects to WP login page with no errors.
Login once more
Paste URL
Returned back to WP login page

I've checked the CiviCRM debug log but no errors reported.
Thoughts anyone?
UPDATE: Upgrading from 5.25 to 5.34

I stumbled across a work around purely by accident but to cut a long story short:
Problem is that since the upgrade database url points to an unsecure http file, my server then wants to redirect to the secure url - resetting the session - requiring an admin login (not sure why this is since automatic SSL redirects have been disabled). Using the upgrade url, I deliberately added an additional character/integer to the url end, forcing the browser to navigate to a http page that doesn't exist. Now that I was sitting in a unsecure 404 page, I simply deleted the previously added character/integer and voila; no redirect to a secure page and consequently the upgrade screen correctly loads.


Any reason why an organisation should NOT register for an event? I have a draft webform set up to allow an organisation to register for an event (for an exhibition stand booking).
Is there any reason NOT to do this?

Civi 5.11, Drupal 7.

There is no reason why an Organisation contact can't register for Event. ATM its not supported through CiviCRM online registration form however you can use Drupal Webform to register Organisation for event.

HTH

Pradeep


Working e2e UnitTests? When I run e2e unit tests, it doesn't seem to recognise that I'm telling it to only use group e2e. This is possibly due to the default include/exclude filters in the phunit.xml file.

When I add the group e2e to the phunit.xml file, I get

CRM_BedResourceManager_BedResourceManagere2eTest
exception RuntimeException with message \Civi\Test::e2e() requires a real CMS. Found CIVICRM_UF=UnitTests.

When I hack the tools/scripts/phpunit to contain CIVICRM_UF='Drupal', not 'UnitTets' it then goes on to say

packages/DB/DataObject.php: "No database name / dsn found anywhere",

I tried popping some entries from civicrm_settings in there, but it didn't work.

a) Does anyone have a working e2e unit test config?

b) What are the settings I need to put in my tools/scripts/phpunit to make it work properly? My Civi and Drupes are in the same database.

My problem was solved by using the command phpunit4 from inside the extension directory. Use --group e2e or --group headless as needed.


Can I add a space for people to write notes: like dietary needs and or comments? Can I add a space for people to write notes: like dietary needs and or comments??

Is there a way to add a memo field?

I have done this with custom field set for individuals with two fields, one a multiple choice (All, Vegetarian, Vegan, Special) and the second a text field to show anything else. I also included disability (yes/no field and a text field for detailed requirements in the same field set as both sets of info are needed in relation to courses booked. There are lots of ways to do it and the user documentation tells you all about custom fields.

Having the structured and unstructured fields allows you to search, but also include additional information.


I am having a devil of a time with CiviCRM email I've validated that my email settings work using SMTP.

Validated using the Contact / Send Email as well as from the Joomla Global Configuration as well as the joomla K2 article print button.

Its just down to testing a sample newsletter mailing. At the bottom is a single email address to send to. I send to an email address for my site (internal to the hosting service) and it works. I try to any other external email address and it fails.

Error msg: Error in call to Mailing_send_test : mail() returned a failure. If I changed the email setting to SMTP, I get a long error, a 'failure to connect to  , Invalid SMTP response code received.

Need Help :-(

Possibly smtp settings, i.e. authentication?
Outside of civi, are you able to send an email to confirm your global configuration/server/mail settings are correct?

Then go to CiviCRM, Administer CiviCRM, Outbound Mail.
Ensure your settings match the cms. Then test to an outside email address.

If all goes well, go back to civi and try your email.

If still not working, then check what version of php you have, if 5.6, then smtp settings maybe messing you up because of peer verification.


Extend templates through the hook file I have configured the "Custom" folders for templates and PHP
following https://docs.civicrm.org/dev/en/latest/framework/templates/extending-smarty/

I created this hook file (and I'm sure it's executed)

function joomla_civicrm_config(&$config) {
  $smarty = CRM_Core_Smarty::singleton();
  array_push($smarty->plugins_dir, __DIR__ . '/plugin/');
}

in the "plugin" subfolder (relative to the hook file), I created the function.attachment.php with the code

function smarty_function_attachments(array $params, Smarty_Internal_Template $template) {
  $template->smarty->loadPlugin('...');
}

but this last function is not performed.
Where am I wrong?

Thank you

I see the name of the function is attachments and the file name is attachment. Maybe, you just need to remove an extra "s" from the function name?

function smarty_function_attachment(array $params, Smarty_Internal_Template $template) {
  .
  .
}


Is the container cache not cleared as part of `drush cc all`? I like being able to use the DI container in my extensions via the container hook, however I've run into the same problem a few times when switching branches that I get this error:

  You have requested a non-existent service "myserviceid"

After trying drush cc all I'd expect the container cache to be clearer, but it doesn't seem to be. My go-to option is to remove all files in the sites/default/files/civicrm/templates_c/ directory, but this seems like it should be handled by the cache clear command.

I'm aware there's an option to not use a container cache, but my question is whether the failure to clear the container cache is expected, or should it be fixed?

You can clear the caches by running drush cc civicrm, by removing everything inside the templates_c directory, and by running clear caches in CiviCRM > Administer > System Settings > Cleanup Caches and File Paths.

In my experience, it's beneficial to run drush cc civicrm separately from drush cc all, which seems to clear only Drush and Drupal caches.

There is a bug reported about drush cc all not clearing CiviCRM caches:
https://issues.civicrm.org/jira/browse/CRM-19206


CiviCRM installation on Ubuntu via package manager CiviCRM for Drupal 7 is packaged for Ubuntu in the Universe repository.

However, the CiviCRM installation documentation does not list installation via  the operating system's package manager (e.g. apt-get) as a recommended installation route.

Is that just because this installation route hasn't been documented yet, or is it because this installation route causes problems that are avoided by following the recommended route? If the latter, which problems are caused by using the OS's package manager?

I do not currently have an Ubuntu system available on which to evaluate the stability/bugginess of those packages myself, hence my asking here.

This is very new work - CiviCRM was recently packaged for Debian by a Debian developer.  It's in Debian sid now, and Ubuntu seems to be pulling it in from there.

In short - it's not documented yet because it's new, and it's hard to say if there are issues with this approach because not many folks are using it yet.


I am trying to set up easycron I am trying to set up easy cron and everythingI am seeing says:

name=username&pass=password&key=site-key

Am I suppose to substitute my wordpress username and password for this?  What is the site-key?

The username and password are for a WordPress user.  I would recommend setting up a user specifically for this purpose and don't use it for anything else.

You will need to give the user the correct permissions:

View all contacts
Access CiviCRM
Access CiviMail

Please see the documentation for more details: Scheduled jobs

You will need to set the site key in the civicrm.settings.php file - see: Site key


Why is it important to define new Entities for new types of data? The Developer Guide includes detailed instructions on declaring a new entity which begins with this:

  If you want your extension to store data in the database, then you will need to create a new entity.

The steps include:

create XML schema
create DAO
create BAO
create SQL to create/drop your table
create Api

I must confess that I have stowed new data in a more lightweight way on several extensions - e.g. I've created an API Entity that handles the SQL itself, skipping the creation of XML, DAO and BAO.

I am sure there are good reasons for the detailed set of steps but it's not clear to me what benefits they bring?

In black-box thinking, an extension that needs to use a new table needs to be able to create the table, provide an Api for using it, delete the table on uninstall. Are there cases, e.g. a table for a very extension-specific use case, when it is sensible to avoid the overhead of all the extra boilerplate code (schema, DAO, BAO)?

The benefit of going through the pain of DAO and co is not obvious for me neither, and I have to confess skipping them and doing it the same way as you did.

One key reason would be to benefit from all the security that the DAO handles by default: are you sure your extension is done properly and you properly escape all the SQL?

On other reason might be documentation: it might be easier to find which fields exist/are mandatory based on the schema/BAO. Eg. on the API explorer, are all the fields for your extension properly shown and do they have their description?

I know that some work was done to use a more modern SQL abstraction than the one we have, but I don't think it is something that we could use in extensions. Would be super useful IMO.


Constraint violation when viewing Mailing Detail Report (group_id the cause) CiviCRM version: 5.19.4

CMS: Drupal 7.69

PHP version: 7.1

When trying to view the Mailing Details Report page, I get the following error:

DB Error: Constraint violation

Looking in the error logs, it is due to the group_id column as you can see here:

[nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`prefix`.`civicrm_group_contact`, CONSTRAINT `FK_civicrm_group_contact_group_id` FOREIGN KEY (`group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE CASCADE)]"])

The important bit being:

CONSTRAINT `FK_civicrm_group_contact_group_id` FOREIGN KEY (`group_id`) REFERENCES `civicrm_group` (`id`)

I sort of understand why this error has come about, it's due to a group_id in the civicrm_group_contact table not being found in under the group_id column of the civicrm_group table (I think).

I have tried running the following to try and find which row(s) is causing this problem:

SELECT * FROM `civicrm_group_contact` WHERE group_id NOT IN (SELECT id from civicrm_group)

However, this returned no results.

I have also truncated the cache tables which is the solution to a few of the other problems I have found whilst researching and cleared normal CiviCRM cache.

It's not just me getting this error, it's anyone else trying to access the same page getting the error as well.

I've found a lot of similar questions regarding this but most of them have not have any solutions and the ones that do, I have either tried them or do not apply to me.

Any help would be greatly appreciated.

EDIT: Added the backtrace from the ConfigAndLog file in the hope it helps solve my problem.

#6 /home/.../public_html/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-3, NULL, NULL, "\nREPLACE INTO civicrm_group_contact ( group_id, contact_id, status )\nVALUES...", "1452 ** Cannot add or update a child row: a foreign key constraint fails (`cr...")

Turned out to be a filter value in the report that was referencing a mailing group that no longer exists. It's 'id' was therefore missing from the civicrm_group table.


Event Scheduled Reminders set for *Before* start dates won't send to participants registering *After* the start date I'm hoping to confirm that I understand the following correctly, based on this description:

I have an event with a scheduled reminder set to go at a certain time before the event. A contact who registers after that time, and before the event starts, will get the scheduled reminder. A contact who registers at any time after the event will not get the scheduled reminder. Is this correct?
After that, if I set up a scheduled reminder to go at a certain time after the event, then all event participants will get that email once that time has passed. Is that also correct?
Further, point 2 is true even if I set up the scheduled reminder after that time has passed. Is this also correct?

Thanks for your help! (Civi 5.24.4, Drupal 7.70)

PS - apologies if I've missed something in the documentation that answers this level of detail. I looked here without success.

1) Yes.  If you have a reminder 2 weeks before saying "Just 2 weeks before our fabulous event ..." then you don't want that being sent to your last-minute registrants.

2) Yes.  Your before and after reminders are independent.

3) Not sure, but I doubt it.  If you set it before the sending time then it would be sent.  ie if it is now one week after the event and you configure something to go out 2 weeks after the event it should work.

Small updates to the docs are easy so if you can add useful information there, please do.


Can not enable Contact Distance Search under CiviCRM modules I have installed CiviCRM 4.7 and CMS is Drupal 7.56
CiviCRM Contact Distance Search is showing disabled in the modules list.
Why is it disabled? how to enable it?

CiviCRM Contact Distance Search requires views module and since your system is missing required modules you won't be able to enable it. Once you install Views module you will need to configure it with civicrm so that drupal can access data from civicrm.

Thanks

Pradeep


will a scheduled reminder be sent after the specified date, if it hasn't been sent before? Suppose, on a running installation, I add a reminder to be sent 1 day after membership end date.

Will this reminder suddenly be sent to all members that expired eg. in the last year, because they didn't receive it earlier ? Or is it sent only to exactly those members that have a membership end date between 24 and 48 hours ago ?

From memory scheduled reminders will only look into things within a 24hr window. So if you said 1 day after then the max it will go back is 2 days (1day + 24hrs). This was a while ago though, although I don't think things have changed.


Profiles automatically adding to Groups I am using CiviCRM 4.7.22 on Wordpress.

In the profile creation advanced settings, we have the option of automatically adding the person to a specific group when they fill out the profile form.

I have two groups, Donors and Members.  Members get access to restricted areas, while donors do not.

My dilemma is, if someone who already has a membership account decides to submit a separate donation, is he then going to be removed from the Membership group and placed in the Donors group?

Thank you.

They should be just added to the Donor group. This should not effect the existing group memberships.


Why is CiviCRM mistranslating my string? My site is translating Yes to Si for French (fr_FR). I've confirmed that:

I don't have any word replacments for Yes.
Most everything else is translated correctly.
I've got an up-to-date civicrm.po file for fr_FR and it contains the correct translation of "Oui".

I've even installed the brilliant de.systopia.l10nmo and org.civicrm.l10nx extensions and uploaded an override .mo file.
WTF?

In the file /CRM/Core/BAO/WordReplacement.php you've got this delightful stanza:
// So. Weird. Some bizarre/probably-broken multi-lingual thing where
// data isn't really stored in civicrm_word_replacements. Probably
// shouldn't exist.
$stringOverride = self::_getLocaleCustomStrings($id);
$stringOverride[$config->lcMessages] = $overrides;

And digging in, you'll see it does this:
$domain = CRM_Core_DAO::executeQuery('SELECT locale_custom_strings FROM civicrm_domain WHERE id = %1', [
  1 => [$domainId, 'Integer'],
]);

In other words, it's pulling word replacement information from a field in the civicrm_domain file which is no longer accessible or used in the UI.
I looked in there and sure enough, I had an old collection of translations. By setting the field to empty, it solved the problem.


Symbunt Report: I need Advanced time period option I want to track who has donated to our non-profit through a time period (2010-2013) but want to exclude donors who have given since 2014-present.

First create 2 groups, one for donors for time period 2010-2013 and the second for period 2014-present.

Then go to Search - Custom Searches - Include / Exclude Search

Then choose group 1 as "include group" and group 2 as "exclude group" and click Search.

The result will contain exactly the people you want.
It would make sense to add them to a third group, so you can send them a Mailing or whatever you want with them.


Civicrm local db error My Specs

I migrated a production Drupal 7/Civicrm 7.x-4.7.9 site to my local machine.
For my stack, I  am running MAMP and PHP 5.6.32, the production server is on PHP 5.6.33

I downloaded all files, and databases (there are two, one for Civicrm and one for Drupal 7).

Took a while, but got it set up and running and changed all urls in the DB. no issues so far.

but now when I got to ...site\civicrm (yes for some reason the local is running on two back slashes in stead of one -- if this is an issue, otherwise it's secondary to the below unless related...)

And here is what I need help with:

I get this error:

Sorry but we are not able to provide this at the moment.
'civicrm/showevents':
Could not find access_callback in path tree,
Could not find page_arguments in path tree,
Could not find is_ssl in path tree

Things I've done so far: Cleared all cache

Any thoughts?

Thanks in Advance!!!

The path civicrm/showevents does not seem to be a part of core. I think you have an extension enabled on your site which is creating a problem.

Disable or uninstall Event Calendar(com.osseed.eventcalendar) from Extension page civicrm/admin/extensions?reset=1.
If you can't access the extension page, try disabling this using cv command OR directly modifying civicrm_extension table in your database. Set is_active value to 0.

$ cv ext:disable com.osseed.eventcalendar

Clear cache OR rebuild the menu using civicrm/menu/rebuild?reset=1.


Mailings - DB Error: syntax error I'm testing out Civicrm. Started with Wordpress then copied the database into Drupal 7

When trying to send a mailing to a group, the send test email issues

Error in call to Mailing_send_test : DB Error: syntax error

And trying to submit the mailing gives
DB Error: syntax error

From the logs I can see

 [code] => -2
[message] => DB Error: syntax error
[mode] => 16
[debug_info] => INSERT IGNORE INTO civicrm_tmp_e_gccache_e014dbed46046aa1c0657ac431a08f53 (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_e014dbed46046aa1c0657ac431a08f53 (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_e014dbed46046aa1c0657ac431a08f53 (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]"]

Edit - looks like this is the same issue as Smart Group DB error

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

Tested the fix from https://github.com/civicrm/civicrm-core/pull/17622 & can confirm it's now working as expected.


CiviEvent automatically send survey after event How can we automatically send a survey form to participants after an event?

You can use the CiviRules extension to do that? There is a CiviRules Guide which should help you to understand what it does and how to use it.


How can I include Profiles on Drupal user registration? I have a current Drupal and CiviCRM installation running LoginToboggan, Panopoly and Multiple Register.

I can toggle the original Name & Address Profile included with the installation, but when I set the checkbox for Drupal User Registration to true on the custom Profile Settings page, the form doesn't appear on the Drupal User registration form.

user/register

Additional registration forms built with Multiple Registration

register/supporter
register/volunteer

Clearing cache and running has no effect.

What's the best way to debug this problem?

My guess is the problem is with Multiple Register since many folks have integrated LoginToboggin and CiviCRM. Turn off all of the three Drupal modules you mention, then reenable them one at a time to isolate which is causing the problem.

You can probably benefit by examining the source of the page with and without the troublesome module enabled in your browser using Firebug or something similar. You may end up needing to provide a patch to Multiple Register or making a custom extension in CiviCRM to help CiviCRM and Multiple Register play nicely with each other.


How do I override the default CKEditor configuration? The question

Where/how can I override the default CKEditor configuration files in CiviCRM?

Original issue / follow-up question

We have a custom email template that uses <html>, <head>, <body>. When using CKEditor, if you paste the template in 'Source' and then flip back out of the source view the tags mentioned above are stripped out. This is because the CKEditor default setting is to strip these tags.

I've opened a  follow-up question here: How can I use <html>, <head>, <body> tags in a mailing?

To answer your question about how to modify CKEditor's config.js:

In 4.6

You need to "hack" the config.js file within CiviCRM itself (packages/ckeditor/config.js). Editing this file will modify all instances of CKEditor in CiviCRM (angular and quickform add a few additional settings related to file uploads but they do both respect that file). If you don't see your changes right away, clear your browser's cache. Note that this file will be overwritten with every upgrade.

In 4.7

4.7 adds a GUI in Display Preferences to modify plugins and button groups, and this will generate at least one config file named crm-ckeditor-default.js in your files/civicrm/persist directory (more files will be created if you click other tabs e.g. for CiviMail or CiviEvent). This file won't be overwritten during upgrades, but will be overwritten if you make changes from the GUI. There is also a new hook_civicrm_coreResourceList which you can use to specify a different config file depending on whatever logic you want like current page, current user, etc.


For activities of type Email, how do I get the id for the activity just created during hook_civicrm_postProcess? Normally during hook_civicrm_postProcess, you can get the id of the just created activity from $form->_activityId. For activities of type Email, I can't see how to get the activity id. Am I just missing something simple?
I don't think I can use hook_civicrm_post instead because I want to use information in the form that isn't in the activity object, but the form info isn't available in hook_civicrm_post.

As of 5.36 this wouldn't be possible in a way consistent with other activity types anyway, because if there's multiple recipients the system will now create multiple activities, so in 5.36+ the form doesn't correspond to a single activity like with other activity types.


How to restrict the Donors to have limited functions of CiviCRM? Here is what I have in mind...

The donor needs to have access to submit credit card donation/events and View only his historic contributions.
He needs to access his basic contact info and edit if necessary.
All the link needs to be at one place for easy navigation. Links like PROFILE, HISTORIC CONTRIBUTION, Historic events, CONTRIBUTION PAGES, UPCOMING EVENTS
No access to CiviCRM Menubar and any other pages by direct links
No access to drupal Menubar

I was thinking to create a Drupal template page where I could place all the links, not sure if that makes any sense or even realistic?!

I was wondering did anyone have this kind of situation and if yes, how did you handle it? Or do you have any suggestions on how this can be achieved? Many thanks!

It sounds like most of what you want you can do via your CMS permissions to give them access to their Dashboard but not to CiviCRM itself


WordPress Events Manager Conflict with CiviCRM Registration Pages I have WordPress 5 running CiviCRM.

We have CiviEvent and CiviContribute enabled and the live registration/donation links are working as expected.

We recently enabled WP Events Manager plugin as well to accommodate some more complex event registrations.

When enabled, the online registration/donation pages redirect to the default CiviCRM page (the one that says Do Not Delete) and the registration/contribution forms disappear.

There are no errors and nothing seems to be wrong other than the fact that the forms no longer display. It doesn't seem to be a URL conflict as the paths are completely different between plugins.

Has anyone experienced this problem?

Where would I even begin this debugging issue?

Figured it out.

The problem is with Events Manager, which overrides permalinks.

I resolved by setting the permalinks to add a leading '/'.

For example:

'events/'
'/events/'


Is there a Donate Now type button that I can just plug into my drupal site? I am interested in creating a donate button that can be used on drupal8 as well as if someone wanted to add it to their own site.
I saw https://wiki.creativecommons.org/wiki/Single_click_donations_with_CiviCRM
And I see https://civicrm.org/extensions/simple-donate
But they both appear quite old.
Is there some recommended button configs, especially as it relates to a credit card or other payment processor?

If you are wanting to embed a form on another site then you should look at

remoteform https://github.com/progressivetech/net.ourpowerbase.remoteform
drupal 8 webform https://youtu.be/oMgOprfJTWA


How do I use the javascript field in the price_sets table of the database I have noticed that there is a field called 'javascript' in the 'price_sets' table in the CiviCRM database.
The comments associated with this field are:
'Optional Javascript script function(s) included on the form with this price_set. Can be used for conditional'.
However I cannot find any documentation on how I should do this in the correct way, and have never seen it mentioned when using price sets through the UI.
I would really like to use this functionality, to limit what people can enter into a form, e.g. for event registration.
I know that this is not a fail safe method, but could limit confusion or mistakes from users.
Does anyone have experience of using this database field to add javascript functions to? An example would be great!

I don't see any evidence that that field was ever used for anything. If you want to insert javascript into the page see https://docs.civicrm.org/dev/en/latest/framework/resources/#javascript which you can use as part of an extension: https://docs.civicrm.org/dev/en/latest/extensions/


how do I count results in API v4 experimenting with refactoring some old code and figured I would experiment with apiv4.
the first hurdle was figuring out how to use the ArrayObject that is returned.

in apiv3, for example I would look at the count value in the array.
in apiv4 there is no such value.

my api v3 call looks like this

  $result = civicrm_api3('Contact', 'get', array(
  'return' => array("custom_90", "custom_91", "custom_85", "custom_88", "custom_143"),
    'id' => $alum_cid,
    'custom_143' => $sal['id'],
     ));
  if ($result['count'] != 0) {
    do things
  }

my apiv4 call looks like this

$results = \Civi\Api4\Contact::get()
  ->setSelect([
    'Employment_History.Salary_Yearly_',
    'Employment_History.Currency',
    'Employment_History.Employer',
    'Employment_History.End_Date',
    'Employment_History.relationshipID'
  ])
  ->addWhere('id', '=', $alum_cid)
  ->addWhere('Employment_History.relationshipID', '=', $sal['id'])
  ->setLimit(25)
  ->execute();

how do I get the count of the results?

the way the api works now, the thing returned is an ArrayObject which you can call functions on, one of those is count()

so just count the results; and then loop over them as you would if it was a normal array

  if (count($results) != 0) {
    foreach ($results as $result) {
      do things
    }

  }


How to add a custom field in Civicase that can be retrieved later? My question sounds simple, but... to explain. We are using Civicase to manage mentoring.  I want to add from 1 to 6 mentoring goals for each case - these would be text fields individual to each case.  When the mentoring is completed (months later) the goals are then 'picked' as ones which best matched to our funder's 4 targets. My problem is that I can't see a custom field to hold these goals that would do this or just lack the imagination on how to manipulate Civi to achieve this! I'm using 4.7 with Drupal, have about 5 years Civi experience but prefer not to code. Would a webform be the answer? Maybe I just create 6 text fields, each one with an associated drop down select with the funder's targets - but that seems a bit clumsy.  It seems that what I need to do is to allow the user to enter data into a select box, but that doesn't seem possible with custom fields.

One answer is to create a set of fields, set to use for 'cases', then add your six text fields to that set, then set up a webform that is set to Create or Edit a Case, and display those fields.

That said, I can't quite picture your use-case.

You say "Maybe I just create 6 text fields, each one with an associated drop down select with the funder's targets".

It may help if you can provide a specific example in your question.


via api created only first particpant gets a line: "Contribution Amount: 1" I register participants and payments via the API.
Step 1: create a contribution for the buyer
Step 2: create participants
Step 3 create participant_payments linking the above.

The weird thing is that civi adds a line to the fee_level of the first participant stating "Contribution Amount: 1".

Why? Am I doing something wrong?

Following the suggestion of Jon G I have been able to pin this down to something related to price sets. Participants of events that do not use price sets do not get this "contribution amount: 1"-line.

Kind regards,

Janec

The api calls:

1) create participant:

public function createParticipant($civiEventId, $contactId, $customFields = [], $amount, $currency, $fee_level) {
$entity = 'Participant';
// Create filter.
$params = [
  'event_id' => $civiEventId,
  'contact_id' => $contactId,
  'status_id' => "Registered",
  'participant_role_id' => "deelnemer",
  'participant_fee_level' => $fee_level,
  'participant_fee_amount' => $amount,
  'participant_fee_currency' => $currency
];
if (count($customFields) > 0 && is_array($customFields)) {
  foreach ($customFields as $customFieldKey => $customFieldValue) {
    if(is_integer($customFieldKey)){
      $customId = "custom_".$customFieldKey;
    } else {
      $customId = $customFieldKey;
    }
    $params[$customId] = $customFieldValue;
  }
}
$action = "create";

return $this->query($entity, $params, $action);

}

2) create contribution

public function createContribution($financial_type, $total_amount, $civi_id, $mollie_id, $date) {
$entity = 'Contribution';
$action = 'create';
// Create filter.
$params = [
  'financial_type_id' => $financial_type,
  'total_amount' => $total_amount,
  'contact_id' => $civi_id,
  'custom_100' => $mollie_id,
  'receive_date' => $date,
  'currency' => "EUR",
  'source' => "Chiro.be via mollie",
];
return $this->query($entity, $params, $action);

}

3) create participantPayment

public function createParticipantPayment($participant_id, $contribution_id) {
$entity = 'ParticipantPayment';
$action = 'create';
// Create filter.
$params = [
  'participant_id' => $participant_id,
  'contribution_id' => $contribution_id,
];
return $this->query($entity, $params, $action);

}

using version 4.7.27.

This is not a right way of adding participant with contribution associated with it. When there is payment associated with Participants than we need to specify line items in create Participant and/or Contribution api. I would suggest to use Order api to achieve your needs as it is straight forward and handles in convenient way for adding payments in CiviCRM.


CiviDiscount does not auto-apply when filtering on contact type I can't get auto-discount to work.  I first tried on my local Civi, and then the demo civi.  As a test, I have a coupon configured on the demo site to auto-discount all events for all contacts of type Individual.  Ultimately I need to apply a discount to a member type, but that's not working either so I simplified it to discount by contact type.  Below is a screen-shot of my coupon settings and the price section of the event.

Link to coupon:
http://d46.demo.civicrm.org/civicrm/event/register?reset=1&id=3
Link to event where coupon should be applying:
http://d46.demo.civicrm.org/civicrm/cividiscount/discount/edit?&id=1&reset=1

The event is not auto-discounted.

The ideal answer would point out what's wrong with my configs, and fix it on the demo site to prove that your answer works.  Thanks!

This may not a long-term fix, but I found a fix in the CiviDiscount github issue tracker.

The underlying problem:  CiviDiscount source will not apply discounts to events with no coupon entered.

The fix:  Add exceptions so that CiviDiscount will apply auto-discounts even if no coupon is entered.

Here is a link to the fix, hopefully this fix or a comparable fix will make it into the next version release.

https://github.com/dlobo/org.civicrm.module.cividiscount/pull/98


How can I detect whether a form is being filled in via the admin pages, rather than via the front-end? Is it possible to detect whether a user is filling in a form in the front-end or the back-end? I want to display a status message for the latter, but I don't want it appearing for regular users using the front-end.

I could check the URL manually, but I figure there must be a better way.

Context is: whenever an address is updated we have various lookups to external services going on. It's useful to display an error to our staff if these lookups fail. But I don't want these being shown to regular users when they update their addresses.

I'd recommend you ignore the form name/class entirely and display the message based on whether the user has an admin-type role. Then you don't care how the lookup gets invoked, you just show it to administrators, and it's tied to the service lookup rather than the way it got triggered.


Delete contacts from group I'm tried to delete contacts group (basically entire contacts from the particular group), getting Gateway timed out error and only few contacts are getting deleted.

So I'm planning to delete contacts from the database. It quite complicated, customer details are stored in different tables.

If I go through the database approach what all the tables I need to join to get all contacts deleted from a group?

It's strongly recommended NOT to delete data directly via SQL.  I don't think it's possible to say which tables you need to delete from - there are hundreds of tables, not including those added by extensions, and it's impossible for us to know which are in use for you.

Instead, consider the suggestions by Jitendra and Aidan above - the issue is that the server is misconfigured.  Alternatively, consider using the API.  Especially if done from the command line where there should be no max_execution_time set, this should resolve your issue much more cleanly without causing orphan database records.


What information does log_civicrm_group keep? How is it useful? Do you use the log_civicrm_group logs? Our log file is now about 300MB - quite crazy. Are records of removal and adding contacts to groups stored here? Thats information we would like to keep. How do you use log_civicrm_group?

Latest Wordpress / Civi.

There had been an issue recently where way more 'changes' where logged than intended: https://lab.civicrm.org/dev/core/issues/449.

Can you verify that it is still growing way too fast since running on a patched version?

The information you are looking for is stored in the table civicrm_subscription_history aswell as civicrm_group_contact for current status.

With log_civicrm_group you could track how the title, description or hierarchy of a group change over time.


How could I use CiviCRM for sponsorship We have a node called sponsorship that is a person, place, or thing.  Person is likely a child, but it could be a teacher, nurse, etc.  A person generally has one donor that pays a monthly amount.  A place could be a building that would have one or more donors, and a thing is an resource; such as a projector.

Using a View we would allow the site visitor to review the opportunities for sponsorship.  When the user clicks on "donate" (or "sponsor") in the view, we want to associate the donation with the item they are sponsoring.  If the item is fully covered by a donation the item status would change and it would no longer we displayed to a site visitor.

We are looking for suggestions on how we should proceed.

I'm not sure how the "things" would fit into this model, but I might begin to tackle the child/person sponsorship this (Drupal-specific) way:

Create a custom field for individuals (and/or potentially use a separate sub-type based on Individual) to indicate that they are available for sponsorship
Create a relationship such as "Sponsor of/Sponsored by"
Create a View that lists all contacts that are available for sponsorship and do not have an active "Sponsor of/Sponsored by" relationship
Create a Membership type with the settings for your sponsorship(s) (e.g. monthly/annual/etc.) Potentially use Word Replacement (Administer > Customize Data and Screen > Word Replacement)  to change "Membership" to "Sponsorship".
Create a custom Webform-CiviCRM form that has two contacts: first contact is the sponsor (filling the form), second contact is the person to be sponsored (this could be filled via the URL with contact ID so links from the View could prefill this value, and/or an autocomplete field for searching). This form could also be set up to take a required contribution towards a membership/sponsorship of the type you created. The form could also be set up to create a relationship between the two contacts (which should then remove the second contact from the list of people available for sponsorship).

Obviously thorough testing would be needed, and I don't recall off-hand whether Webform-CiviCRM allows you to set up recurring payments or if you'd have to rely on membership reminders to have them come back to make subsequent payments.

I suppose the places could be set up in a similar way using a subtype of Organizations, potentially with different rules in Views (for example, you may want to allow any number of people to sponsor a place, I don't know).

Some of your more complex functionality may be more difficult to fit in (such as partial payments or a combined sponsorship among multiple people), and I'm not sure about how I'd handle the things (like projectors) in this model.

EDIT: It would be a different workflow then described above for the 'things' but you might be able to set up a contribution page with these items as the 'premiums' offered. (e.g. "Make a donation of at least $150 and you can select a projector for a school...")


Are virtual community tools (groups, mailinglists, profiles, "friends", ...) playing nice with CiviCRM? We are looking into integrating online community tools (like buddypress, peepso):

members can open closed and public groups
groups have mailinglist functionality, ideally posts to the group can be created by email and send out by email (such that the users don't have to learn a new platform, if they do not want to)
members can set up events
members can see / are informed over events in their proximity
members can set up profiles, have virtual friends and exchange messages

Ideally, the system would play together with CiviCRM. Has anyone thought about such a thing? I found only some non-integrated approaches to sync CiviCRM groups to mailman.

This isn't strictly a CiviCRM question in my opinion, but here goes anyway...

  members can open closed and public groups

This is built in to BuddyPress - check the box labelled "Enable group creation for all users" in BuddyPress settings.

  groups have mailinglist functionality, ideally posts to the group can be created by email and send out by email (such that the users don't have to learn a new platform, if they do not want to)

I'm not sure about creating posts by email, but this plugin will do replies by email:

https://github.com/r-a-y/bp-reply-by-email

It is pretty technical but there's good documentation.

BP Groups CiviCRM Sync will keep BuddyPress group members synced with CiviCRM groups such that there are CiviCRM Mailing Groups per BuddyPress group - see the plugin page for details.

FWIW, I also use a combination of CiviCRM WordPress Profile Sync and BP xProfile WordPress User Sync to keep users' BuddyPress, WordPress and CiviCRM profiles in sync.

  members can set up events

The CUNY fork of my BuddyPress Event Organiser plugin (which has been developed way beyond where I left it) enables BuddyPress group events and group calendars. You could also install CiviCRM Event Organiser to sync those events to CiviCRM.

  members can see / are informed over events in their proximity

I don't know of anything that does this out-of-the-box, so it sounds to me like a custom plugin which uses (say) Event Organiser (which has a premium proximity add-on) and BuddyPress Group Email Subscription or CiviCRM to notify users.

  members can set up profiles, have virtual friends and exchange messages

Again, this is all default BuddyPress functionality.


Add multiple target contacts in advanced search I'm looking to send a mailing out to a subset of our contacts - those that have a relationship 'member of' and then Target Contact ' Group 1, Group 8, Group 12 etc' I'm creating a Smart Group to do this but had hoped that I could add more than one value in the 'Target Contact' field before running the Search but apparently not. They appear to need to be done one at a time which is a very time-consuming process if there are say forty groups that need to go into the smart group. I tired comma separation but it didn't work. Any ideas?

I'm assuming your using Adcanced search to build this

You could try adding your targets
' Group 1, Group 8, Group 12 etc'

Into just a standard static group.

Then Advanced search
group="new group"

Display results as- switch to related contacts "relationship type=member of"

Does that get you closer?


Contact Summary Layout Extension - Screen display problem I have tried to install the Contact Layout extension and get the following issue shown in the attached screen shot. I am using

Drupal 7.72
CiviCRM 5.24.3
Contact Summary Layout 1.7.1
Angular Profiles 4.6-1.0.2

I wonder if someone might point me in the right direction to get this resolved.

I was setting this up in a staging environment which is not up to date with the latest versions of CiviCRM. If you go are running a version of CiviCRM earlier than 5.24 then you need to apply this patch which solves the problem. The issue is not seen in versions of CiviCRM 5.25 and later.
(https://patch-diff.githubusercontent.com/raw/civicrm/org.civicrm.contactlayout/pull/79.diff)


Error on updating contact after upgrade to CiviCRM 5.10.3 After upgrade to CiviCRM 5.10.3 (Drupal 7, php 5.64) I can do AJAX edits like view and edit address, but if I edit a contact and save them normally, I get
Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame thrown in .../sites/all/modules/civicrm/Civi/Core/Transaction/Manager.php on line 107

CiviCRM 5.10.3 is not compatibile with so old PHP 5.64. Maybe here is a problem, look at requirements:

https://docs.civicrm.org/sysadmin/en/latest/requirements/#php


Issue with l10n update On Civicrm 5.13.4 on Drupal 7.67 I have this error when accessing to the Localization page:

Notice : Undefined index: addLanguage dans l10nupdate_civicrm_buildForm() (ligne 53 dans /sites/default/files/civicrm/ext/com.cividesk.l10n.update-master/l10nupdate.php).
Notice : Undefined index: lcMessages dans l10nupdate_civicrm_buildForm() (ligne 53 dans /sites/default/files/civicrm/ext/com.cividesk.l10n.update-master/l10nupdate.php).

How should I fix this? (.php is not my best)

Looks like the error is originating from the com.cividesk.l10n.update extension enabled on your site.

update that extension to latest and check if it fixes the problem for you.
disable if it is no longer useful.
Open an issue under https://github.com/cividesk/com.cividesk.l10n.update/issues providing the steps to reproduce the problem.


How do I create default custom data when changing contact subtypes via the API? If I use the API to give someone a new contact subtype it doesn't create a row in any relevant custom data tables and populate the default values. Does anyone have a good way to handle this? I have smart groups that hang off the default custom data, but new contacts aren't going into them.

I'm trying to dig through for a handy createRelevantCustomDataFromSubtype function but can't see anything yet.

Cheers,

Andrew

I think this is how it typically works, but in your same api call just populate one of the fields in each relevant custom data group with a blank '' and that should fill in the rest.


Using CRM to manage walking groups We are looking for a program to manage walking groups.  These groups may be part of health education, work-place based, or location based (such as a park).  At the very least we want a way for participants to register for a group and receive notification on the event, such as rain cancelations etc. Down the road, we may also want to create profile accounts for participants to track their walking and use it promote competitions. Below is a summary of what we are looking for in a CRM.

Integrated into existing wordpress website
Event registration (free and pay capabilities)
Ability to send out text and email notifications (walking group leader would most likely do this so phone and email information would need to be private)
Security and privacy of participants (similar to the Remind app)
Ability to set up social network and log walks into site
Promote competition with badges/rewards

Would like to know what this application would be able to support from our wishlist above.

With some customization/development, all your wishes can be met by CiviCRM

> Integrated into existing wordpress website
> Event registration (free and pay capabilities)

Out of the box functionality. Your WP site server needs to good enough to run CiviCRM though. And events are easy to use (free and paid).

> Ability to send out text and email notifications (walking group leader would most likely do this so phone and email information would need to be private)
> Security and privacy of participants (similar to the Remind app)

Some customization will be needed.

> Ability to set up social network and log walks into site

Please elaborate on what you mean by set up social networks. Walks can be events or activities, you will need to figure out what works for you

> Promote competition with badges/rewards

There are probably a few different ways to do this, may require some development depending on what you need. For example voting on answers like on StackExchange is not available in CiviCRM and will require a reasonable amount of effort.

You should consider working with a CiviCRM Partner/Contributor.


How do I format a webform to register for events so I can fill it out multiple times without cancelling previous registrations? We are using a Webform to allow people to sign multiple people up for multiple events.

If someone has registered themselves for event A & B then later decided they want to go to event C & D as well, how would you set up a webform to allow a second submission that doesn't cancel the first registrations?

Currently if I revisit the form all the events are on offer, there is no indication of which events I am already registered for. If I fill in the form to register for C & D (having previously registered for A & B) and do not select A & B also then when I submit the form it cancels my registration for A & B.

If I am registering multiple people for events. eg person A registers person A and person B to go to lunch. Then person C registers person C and person B to go to dinner. Where lunch and dinner are both events that can be registered for on the same form then currently when person C completes the form person be will have their registration for lunch cancelled.

I am using Drupal 7.56, CiviCRM 4.7.27, Webform-CiviCRM 7.x-4.19

Found the solution, it is a setting that was there all along.

On the CiviCRM configuration page under the Event Registration tab there is a section called Registration options. In here there is a checkbox to "Disable unregistering participants from unselected events" if you check that then as it says contacts will not get unregistered from events.

Doesn't show them what they are currently registered for but we are ok with that as they are not going to lose the registration.


Setting up Cron Jobs to run Initially(Cron Not Running) I've recently setup civicrm as a plugin on my wordpress site, and I can't seem to shake the 'Cron Not Running' Warning.

Does the job.execute cron job need to be running in order to run all other scheduled jobs?

I'm on a digital ocean ubuntu server, and each time i run

sudo -u www-data -- /usr/local/bin/wp --user=cronuser --
url=https://mysite.org --path=/var/www/html civicrm api job.execute
auth=0

it will run the scheduled tasks, and the system warning will go away(for an hour or so) but this is kind of a 1-off behavior, and it doesn't continue to run any tasks that have already been set up. Eventually, the warning comes back.

Do I need to do something like
crontab -e and then:

* * * * * sudo -u www-data -- /usr/local/bin/wp --user=cronuser --
url=https://mysite.org --path=/var/www/html civicrm api job.execute
auth=0

I'm new to linux administration and I don't want to mess anything up by "guessing" what will work.

I'm assuming you've seen this Wiki page: https://wiki.civicrm.org/confluence/display/CRMDOC/Managing+Scheduled+Jobs

If I'm reading your question correctly, I think you need to set up the cron job so it runs every so often, e.g. every 15 minutes:

*/15 * * * * <your cron job command here>


CiviCRM 5.28.2 triggering "critical issue" in WordPress 5.5 Site Health This is related to WordPress Site Health contains critical errors unless CiviCRM is disabled but I'm raising it because

WordPress 5.5 adds the "active PHP session was detected" issue
There was no response to RiverRunner's request for the basis for saying the test are inaccurate

I'm currently running WordPress 5.5 and CiviCRM 5.28.2.
The Site Health function in WordPress 5.5 reports 3 three "critical issues" related to the WP REST API.

An active PHP session was detected - A PHP session was created by a session_start() function call. This interferes with REST API and loopback requests. The session should be closed by session_write_close() before making any HTTP requests.
The REST API encountered an error - The REST API is one way WordPress, and other applications, communicate with the server. One example is the block editor screen, which relies on this to display, and save, your posts and pages.
The REST API request failed due to an error.
Error: cURL error 28: Operation timed out after 10005 milliseconds with 0 bytes received (http_request_failed)
Your site could not complete a loopback request - Loopback requests are used to run scheduled events, and are also used by the built-in editors for themes and plugins to verify code stability.
The loopback request to your site failed, this means features relying on them are not currently working as expected.
Error: cURL error 28: Operation timed out after 10004 milliseconds with 0 bytes received (http_request_failed)

This discussion suggests that the problem is with plugins and themes that need to be updated. By elimination, I found that CiviCRM 5.28.2 was triggering the error.
Can these "critical issues" safely be ignored and, if so, why or under what conditions?

SiteHealth does not account for sessions and CiviCRM depnds on them. See the discussion at https://lab.civicrm.org/dev/wordpress/-/issues/32
Possible fix:
https://civicrm.stackexchange.com/a/35234/155


Why isn't there a CiviRules action to change membership status? As per the title: why isn't there an action in CiviRules to be able to change membership status i.e. from active to cancelled? This seems like something a lot of people would use. Is anyone working on something?

it is not there because apparently no one needed it :-) The actions in CiviRules get added whenever a CiviCRM user funds the development of one or develops one and shares it as a general action. So this has not happened up to now. If you really need it you are very welcome to develop and share it, or fund the development by a partner who will most certainly share it.
I totally understand if you can not develop nor have the funds available. That then means you have to wait until someone else invests energy or funds. The answer to the why question is then again no one so far has :-)


Why are donations left as "pending" in CiviCRM when they went through in Paypal? Sometimes when we get an online donation, the record remains in the "pending" state in CiviCRM even though the payment went through successfully in Paypal. This happens for maybe 1/3 - 1/2 of donations. Is there a solution for this, a way to make sure they are always marked "Completed"?

The way it works with paypal standard is that paypal informs civicrm that the payment has been done in the background via IPN (instant payment notification)

It means that paypal is sending information to a specific page on civicrm with the proper data (eg this payment has been successful) then your server sends these information back to a specific page on  paypal to check it's a genuine confirmation and paypal returns a page that confirms it's one

Something in the chain isn't working sometimes. It might be a firewall, your site too loaded, connection issue...

Did you check the log? are you using drupal?


How to add profile shortcode to WordPress sidebar (i.e., in widget) I can add a newsletter signup Profile shortcode to a page or post in Wordpress, but I'd like to have it show up on the sidebar.  I put the shortcode into a text widget (the code is for our MailMunch signup is in a text widget) but the Civi shortcode doesn't work there.

See http://sandbox.bio4climate.org/

Suggestions?

Thanks!

Adam

P.S. - This is a test site (but the payment processor is live!).

Have you tried just adding the HTML form snippet to the text widget? It's not as neat as adding a shortcode, but it should work okay.

Go to Administer CiviCRM > Profiles, then HTML Form Snippet under 'more' for your chosen snippet. Copy all the code there and paste it into your text widget.


Can't view transactions We just launched a new Drupal website and implemented our old CiviCRM database. Everything seems to be going fine and transactions are going through, but when we try to view one, as admin or any other user, we get a network error.

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

Admin user has all permissions and is still having the issue.

CiviCRM 4.7.15, Drupal 7.x

Edit: apparently I can't go back and edit payment processors either.

Edit2: apparently it works with the old, pre-launch URL. I ran 'drush cc civicrm' to no avail. I also updated file paths and cleared caches in CRM.

It's possibly related to an issue where some transactions are coming in incomplete.

Drupal error log is showing this possibly related message:

Sep 19 16:27:28 prod drupal: https://prod.fosterclub.com|1505838448||access denied||68.116.xx.xx|https://prod.fosterclub.com/civicrm/contact/view/contribution?reset=1&id=5816&cid=121483&action=view&context=dashboard&selectedChild=contribute&snippet=json|https://www.fosterclub.com/civicrm/contribute?reset=1|0||civicrm/contact/view/contribution

Furthermore, when I hover over the link to view the transactions, it is showing prod.example.com instead of www.example.com, which was the correct URL before the DNS change and launch.

If it's showing the wrong URL, you should:

Confirm your $BASE_URL is correct in civicrm.settings.php;
Check your URLs in Administer menu » System Settings » Resource URLs;
Clear your cache;
Delete templates_c.


Is anyone creating tickets or printing bar codes from CiviCRM? We would like to be able to store and print machine-readable codes (bar codes or QR codes).  We might print these on receipts for event registrations, to act as tickets, or on signin sheets or ID cards to track attendance at meetings, etc.

I saw a reference in an old question about this here on Stack Exchange, but nothing about it in the CiviCRM documentation.  Is someone offering an extension perhaps that does this?  Has anyone integrated CiviCRM with a code-generating Word-Press plugin?  Do you think it's possible?

Years ago we used 'QR Code Checkin' extension for one of our clients. Using the extension you can email the QR code to participant and same extension can also be used to confirm the registration.


Anonymous users can't View details of a Contact in a public directory Listing Currently on CiviCRM 5.1.2 / WordPress 4.9.6 in my dev site and on my Live site on CiviCRM 5.0.2 / WordPress 4.9.6.  The reason for the CiviCRM difference was it was my last attempt to see the cause of a behavior I'm seeing:

Problem:  Anonymous users are not able to View the details of a contact that is in our public directory listing.
Scenarios:

When an anonymous user clicks 'View' they are redirected to the home page.
For ANY logged in user it will show the details of the contact selected.

Expectation:  We are wanting even anonymous users to be able to see the details of the directory.

Things that have been checked:

I have looked for any errors during the timeframe in the Log files located in:

  wp-content/uploads/civicrm/ConfigAndLog

and

  ../wp-content/error.log

Checked the permission of the Profile that is being used for the directory Listing and detail View.

Used For option has    Standalone Form or Directory  and Search Views checked
The group, Hub Directory of Organizations, is selected as the Limit listing group.
No account creation option,  Issue warning and do not save selected, No Proximity search and Enable mapping for
this profile is selected
All fields are set to either Expose Publicly or Expose Publicly and for Listings
As one test I had all fields set to View Only to no avail

Changed the permission on the limit listing group, Hub Directory of Organizations, and its parent group from User and User Admin Only to Expose Publicly to see if it made a difference.  No avail.
Checked WordPress / CiviCRM permission access to make sure the following were checked:  Access_all_custom_data, access_contact_reference_fields, access_uploaded_files, profile_listings, profile_listings_and_forms and profile_view.  At one point I tried view_all_contacts, but to no avail.
Disabled any new extensions and the one that wrote for special formatting of my directory to see if it was affecting the permissions or access.  Did not fix.

What else should I check for?  A combination of things to be checked together?

It is not possible to expose contacts to anonymous users.

The only place where this is possible is with registered participants for an event because you could create a public participant listing.

The other way to expose data to anonymous users to use a module from your CMS. In Drupal you could use the views module, and in Wordpress you can show a profile list on a wordpress page.


Where do Custom Fields for Contributions appear? I have created a Set of Custom Fields called "Tracking" to be used for any Contributions.  The Custom Fields created in this set are called "Category" and "Job".

However, I can't see these fields anywhere I have looked?  Where should they appear?

They should appear at the bottom of your contribution form, like so:


Can not access CiviCRM I cannot access CiviCRNM on Drupal. I get

Sorry but we are not able to provide this at the moment.
Could not find user name for payment processor

Return to home page.

I am using drupal 7 and civiCRM 4.6.3. I had made some changes to the set event as payable when creating an earlier event and used dummy credentials for paypal pro. I now do not know how to undo the changes or gain access to CiviCRM. Thanx in advance.

You can't access civicrm backoffice?

Try http://yoursite.org/civicrm/admin and disable the payment processor from there.


Can you save an advanced activity search? After using Advanced Search to create a pretty detailed search on activities, I need to save it.  If my search results were contacts, I could create a smart group based on the search which would essentially make the search permanently available as suggested here: Saving Advanced Searches for later use

However, my search is on activities and displays activities.  I need to perform this search frequently and there is no corresponding tool like smart groups for activities.

I also need to be able to use the Batch Update Activities by Profile action on the search results which precludes me from simply creating a report and saving that.

The key functionality to do this was added in CiviCRM 4.7.25, with CRM-20630.

My understanding is that it's almost but not quite what you need.  This allows you to pass variables through in the Activity Search URL, but it won't generate the URL for you - you'll have to figure the URL out for your search.  A extension to auto-generate the URL seems like a worthy project though.

The feature doesn't seem to be documented yet, but you can see examples on Github.


Is there a way to connect the civisepa backend to the profiling in wordpress? I'm trying to connect the payment attributes of my wordpress/civi profiles with civisepa, so that mandates will automatically be updated if a user changes his IBAN, etc. Is there any way to achieve this?

Thanks in advance!

Welcome to CiviCRM Stack Exchange alicedd!

Afaik, CiviSEPA mandate information cannot easily be made available in Profiles. CiviSEPA can be made available as a payment processor on CiviCRM Contribution pages though. CiviSEPA would then create a mandate when someone uses the page

If you want to allow constituents updating a mandate you will need to create a custom form / function.


Suitable for online social group? Im a board member of an online social group. We are looking at updating our website and backend IT systems to include online registration, subscription management, member database, self managing profiles, event booking and payment and member interaction. Plus marketing options and email distributions.

Is this what CiviCRM can help with ?

Thanks for responses - am going through book.civicrm now.
I guess we are particularly interested to know if logging in to the wordpress or joomla based website via CiviCRM will authenticate access to other components like a forum, messaging and restricted / controlled page views etc. In other words can CiviCRM validate the whole site ?

Yes, CiviCRM can do all of these things.  It is also a very flexible system with a number of extensions that provide additional functionality that you may need in future.

To get a better idea of what CiviCRM can do I would suggest that you read the user guide and try the one of the demo sites.


Adding Spouses to Civi Contacts I have about 5000 records of my org. To be a "member" of our org we measure that by "household" so therefore there could be two or more people in the household.(we provide free legal advocacy to these people).

We have a unique identifier being a member number. Each member number could have say two people under that one number, being a married couple.

I have used the import contacts feature in Civi to import "individuals" because if I import them as "households" there dosnt seem to be a name field for the household show up after import. ie it shows the address and city etc but "name" is blank and it dosnt assist our org by not having a member name to identify the household.

So i added individuals. My frustration at this program is that despite spending multitudes of time reading the documentation, i cant import the spouse name into the program that creates a relationship.

Is there any way to get assistance on this issue. Happy to share the csv of our database if it assists in comprehending our data.

There are a couple of ways to do this, but here is the one that I prefer.

Decide how you'll name households. CiviCRM household names are arbitrary, so you can so something like "Jane and John Smith" or "Smith Household". Use a spreadsheet function to populate that field in your spreadsheet.
Import the households as households. Include your membership number as External Identifier. Include your new Household Name field.
Create a unique identifier for your individuals as a new field. Use a spreadsheet function to append "A" to the member number on the first spouse and "B" to the member number on the second.  The result would be that you have member number 1234 and individual number 1234A on the one spouse and member 1234 and individual 1234B on the other. On the second spouse, add another field with the individual number of the first spouse.
Import your individuals with numbers ending in A. Include the member number, and import the field as "Household of - External Identifier". Include the new -A number you created as External Identifier.
Import the "B" spouses as individuals. Include the member number to create the household relationship and the -B number as the External Identifier. Finally, include the corresponding -A number as "Spouse of - External Identifier".

The result should be households that have relationships with the individuals and individuals with relationships to each other.


Webform - autofilled fields using "Existing User" I often use the "existing user" field in a Webform so that authenticated users don't have to re-enter info that we already have in CiviCRM.

This works well but I realized that collection fields that exist after a page break, meaning not in the same page as the "existing user" field, aren't populated and remain blank.

Am I missing something? Is there a way around this?

I've run into something very similar previously - and here's how I solved it:

How can I (on page 2) show First Name of an Existing Contact - static (on page 1) without dragging it to page 2?


Net amount not calculating for event registration Civicrm 5.7.0/Wordpress 4.9.8:

When I manually enter an event registration that needs a payment processor fee, prior to civicrm upgrade to 5.7.0 from 4.7.19, there was an area at the bottom of the form called "Additional Details". In that section I could enter the processor fee amount and the net amount would be automatically calculated. In 5.7.0 that section is now gone. After I complete the registration I can go to the contact's profile and edit the corresponding Contribution where the Additional Details still exist although the net amount field beneath the fee is missing (Perhaps because of the changes listed at  https://civicrm.org/blog/dev-team/civicrm-56-release). When I enter the processor fee amount the net amount is not calculated in reports. Event registration reports will show registration fee, processor fee amount, and net amount but the net is not gross (reg fee) minus processor fee. It replicates the gross amount.

This does not happen when entering a contribution only, just when registering for an event. I have on rare occasions seen this happen on previous version when someone has used our online registration page but maybe only three or four times out of 100 registrants. I would then have to delete the transaction and rebuild it manually in order to get the processor fee to show up and calculate the net. Under the circumstances listed above that will no longer be possible.

Has anyone else experienced this and have a fix?
I have tried turning off custom fields and activated past events all with the same results. Also, NO event reports show the correct calculation as described above.

Welcome!  Thanks for reporting that.  As you noted, in 5.6 the net amount is not displayed on those forms now since it was being automatically calculated anyway.  I have recreated your issue and it seems to be related to contributions generally rather than specifically related to events.  The net amount is being calculated correctly when the contribution is first created but edits to the fee amount are not causing re-calculation of the net amount.  I have created an issue here: https://lab.civicrm.org/dev/core/issues/552


is there a possibility to add custom fields to "notes" We want to structure the content in our "notes" by adding custom fields. We want to do this in notes because it is the only place where you can shield datafields form other users.

Its possible to add custom fields for Notes through UI, by simply adding an option for Objects a custom group extends to option group.
However the fields wont appear on Add/Edit note form unless you write an extension to build the builds or modify core file to support custom fields(should be couple of hrs of work). Good news is the custom field data can be stored/viewed against the note by api.


How to resolve "Call to undefined function" after upgrade to 4.7.27 CRM_Core_SelectValues::datePluginToPHPFormats() We have just upgraded WP to 4.8.3 and Civi to 4.7.27, now getting the following error from one of our extensions:-

  Call to undefined method CRM_Core_SelectValues::datePluginToPHPFormats()

The offending code snippet is below:-

protected function getFormattedFieldValue($value, $field) {
if ($field['data_type'] == 'Date' && !empty($value)) {

$actualPHPFormats = CRM_Core_SelectValues::datePluginToPHPFormats();

  $dateFormat = (array) CRM_Utils_Array::value($field['date_format'], $actualPHPFormats);
  $value = CRM_Utils_Date::processDate($value, NULL, FALSE, implode(" ", $dateFormat));
} elseif (!empty($field['option_group_id']) && $value) {
  try {
    $value = civicrm_api3('OptionValue', 'getvalue', array(
      'return' => 'label',
      'option_group_id' => $field['option_group_id'],
      'value' => $value,
    ));
  } catch (Exception $e) {
    throw $e;
  }
}
return $value;

}

Any ideas how I can correct this code? I can't find the function in the docs: https://doc.symbiotic.coop/dev/civicrm/v47/phpdoc/CRM_Core_SelectValues.html

Thank you!

After searching on Jira for the funciton, nothing came up, so searched the codebase from our backup and found the function was in the file: civicrm/civicrm/CRM/Utils/Date.php:1788

It's now gone, along with a lot of other ones!

So I've added the array of date formats to the code to workaround the issue.

//$actualPHPFormats = CRM_Core_SelectValues::datePluginToPHPFormats();
  $actualPHPFormats = array(
    "mm/dd/yy" => 'm/d/Y',
    "dd/mm/yy" => 'd/m/Y',
    "yy-mm-dd" => 'Y-m-d',
    "dd-mm-yy" => 'd-m-Y',
    "dd.mm.yy" => 'd.m.Y',
    "M d" => 'M j',
    "M d, yy" => 'M j, Y',
    "d M yy" => 'j M Y',
    "MM d, yy" => 'F j, Y',
    "d MM yy" => 'j F Y',
    "DD, d MM yy" => 'l, j F Y',
    "mm/dd" => 'm/d',
    "dd-mm" => 'd-m',
    "yy-mm" => 'Y-m',
    "M yy" => 'M Y',
    "M Y" => 'M Y',
    "yy" => 'Y',
  );


Edit address using webform and views Searched diligently before posting this but couldn't find an answer.

I'm working on a webform/view combo to edit contact's addresses.

I'm having trouble figuring out how to pass the location id in the url to the webform.

If I use node/(webform node number)?cid2=[id] it opens the webform with the primary address which works fine if contacts only have one address in the system.

Is it possible to pass the location id in the url for the webform?

The short answer is "no". Location types are handled in a very simple/dumb way by webform integration. When it looks up a contact it simply pulls all addresses (primary first, otherwise in no particular order) and populates address fields with them in order, and with no respect to location type settings for those fields (so the suggestion of pulling a default from $_GET wouldn't help you I'm afraid).

There is an open issue for improving this if you'd like to contribute.


Trying to kill civicrm/civicrm-cxm-rpc to fix a conflict, and it won't die Ubuntu 18.0.4 LTS, Drupal 8.7.

New to composer and Drupal 8, trying to resolve a conflict between required libraries for CiviCRM and Open Social. Open Social requires phpseclib/phpseclib 0.3 or 2^, CiviCRM requires 1.0.*. But the thing is, the bit of CiviCRM requiring that seems to be functionality I don't care about: civicrm/civicrm-cxm-rpc.

Have tried editing various JSON files, composer removes, and rm'ing the offending folder, but every time I try a new command I see it popping back up again and appearing in installed.json and lock files. How the hell do I forcibly remove it and manually install or require the 2.0?

Problem appears to have been a newbie-to-Composer issue. Every time I ran various composer commands, I'm told it overwrites the .json files I've been furiously editing for four hours, putting back all the code I'm trying to kill? Charming. Had no idea.

Was also told that the way to do this is to fork the project and point my top-level composer.json at it instead, then edit in the repo. That, however, requires learning eight skills I don't have yet—so I put in a quick-and-dirty hack: deleting the repositories lines from the top-level composer.json. That disconnected my local structure from the repo, and when I killed civicrm/civicrm-cxm-rpc again and required the google/apiclient that needed a newer phpseclib, it installed without a quibble.

Would still like to hear if axing civicrm-cxm-rpc has wider effects than I'm inferring from the docs.

EDIT TO ADD: Installing Open Social over the composer package of Drupal 8/CiviCRM died screaming in ways I didn't understand, so I'm now trying the reverse: using the distro of Drupal 8 and Open Social and patching it with CiviCRM, since dsnopek has a composer script that does only that.

This is running into several conflicts, and this time I am forking in github, because the above hack didn't work the second time through.


Change Receipt Email Title: Template, Localisation File or Somewhere Else? We have a different title for the (pay later) offline receipt contribution email (civiContribute). The first email with the data necessary to make the payment  has a title saying something and the payment confirmation email (sent afterwards) title says something else. I do remember this having been changed by us. However I cannot remember or find where. We would like to change the first email title again, in order to say something else.

I've checked the system workflow message templates and the localisation files at transifex and the change does not seem to have been done there. Is there a translation file for tokens? And if so, where can it be found?

Thank you.

Normally this would be done in the System Workflow message templates - you can change both the message subject and text there, as well as adding more extensive customization using Smarty tags. So it's odd that it's not showing there...

One other option I can think of is that you can change certain pieces of text globally using the Word Replacements feature (Administer > Customize Data & Screens > Word Replacements. So perhaps if there was a word or phrase that you changed not only for the receipt titles but anywhere it was used on the site, you might find it there?


Add custom data field column to relationship tab Is there a way to add additional field(s) in the relationship tab on a contacts record?

as " hook_civicrm_searchColumns is not getting triggered for relationship.
( though this hook is helpful for contribution tab and other search results.)

can any one please advice what would be best way forward to achieve this?

Some of the pages that you would expect to support hook_civicrm_searchColumns don't - they're mostly older screens that don't use the appropriate shared code.

Ideally, we would rewrite these pages to use CRM_Core_Selector_Query so the hook fires.  Since that's not often feasible within a budget, I've resorted to using template overrides, with API calls within the override to pull in additional data.

If you want to avoid overrides, you could probably use JavaScript includes.

None of these are perfect, but short of rewriting the screens (a noble goal!) this is what we have to work with!


Checking Inconsistencies between Users and Contacts Emails (via civicrm_uf_match table ?) I am in Drupal 7.51 / CiviCRM 4.7.12

I want to check Users emails against their corresponding Contacts emails (which happen to be different in the DB though they should not).

I have developped a small program to identify those cases (querying civicrm_email and drupal_users tables, linked via civicrm_uf_match).

I thought that the civicrm_uf_match table managed the link between the Drupal User id and the corresponding Civicrm Contact id ; but it actually does not : it contains only 31 lines though I have 446 Users and 667 Contacts with a primary email.

For instance, the civicrm_uf_match table does not contain my own ids pair ; moreover, it contains lots of errors (e.g. old emails which were deleted).

Question : how and where is managed this link between the Drupal User and the CiviCRM Contact (which appears when you consult/modify the Contact) ?

The civicrm_uf_match table is the correct place to look.  I can't explain why you're seeing what you're seeing!


Authorize.net auto email receipts I am using authorize.net as a payment processor. They have automatic receipt emails that go out after a contact makes a contribution. I have disabled them from going out on my account, but they are still going out. They said it was on the Civi side and something was over-riding that setting. Does anyone know how to fix this?

I've never had a problem with Authorize.Net receipts going out when I've disabled the appropriate setting in Authorize.Net.  I don't have a valid Authorize.Net login to find the exact setting now, but I can confirm that I've seen the behavior you expect on multiple sites.


Error after Installing CiviCRM 4.6.4 on Drupal 6, drupal attempts to reinstall at localhost/drupal I have recently installed Drupal 6 on WAMP, then I downloaded CiviCRM 4.6.4 for Drupal 6. I followed the installation offered on wiki.civicrm.org and everything went very smoothly. When I attempted to follow the final step of "Return to Drupal and enable the CiviCRM module http:///admin/build/modules. Check the box next to CiviCRM, then scroll to the bottom of the page and click the "Save configuration" button.". I punch in localhost/drupal into my browser and Drupal attempts to install itself again. I pressed "Install Drupal in English" and it timed out and showed me this "Fatal error: Maximum execution time of 120 seconds exceeded in C:\wamp\www\drupal\includes\file.inc on line 1078". Help please!!

Unless there is a good reason why you have chosen to use Drupal 6, I would suggest that you use Drupal 7 instead.  As Laryn points out Drupal will reach end of life soon.  Things are more likely to go smoothly if you are using Drupal 7 and you also find it easier to get help.

I would also recommend that you use the latest version of CiviCRM - currently 4.6.12 (or 4.7.1).


DB Error: constraint violation Help! I just upgraded Civi from 4.7.3 to 4.7.7, but my host timed out during the DB upgrade and it was unable to complete. So I restored a backup of the database and was going to try again, but now every time I do anything with Civi, it gives me a DB Error: constraint violation.

I can't access any of Civi's backend now; it all gives me the same error. And when I try to run the upgrade script, it gives me the error after I click upgrade.

Is there anything I can do? Is my entire Database and my backup worthless now??

Strange, we had an issue on 4.6.24 just now.

The CiviCRM log file stated: -

DB Error: constraint violation

The debug information should give you the MySQL table name. For some reason, a custom table (civicrm_value_tablename_id) was linked by foreign key (entity_id) to the wrong table. In my case, it was the civicrm_event table, whereas it should have been to the civicrm_participant table.

My solution was to truncate (empty) the civicrm_value_tablename_id table, remove the incorrect foreign key, then add the correct foreign key.

Strange though that I had to do this manually as the CiviCRM custom data set screen showed that the Custom Data set in question is 'Used for' (or extends Participants).


Exhausted memory error I am getting reports from users of blank screens when going to register for an event. This does not happen for most users.
The PHP error log says:

PHP Fatal error:  Allowed memory size of 536870912 bytes exhausted (tried to allocate 400572416 bytes) in /home/sclgulf/public_html/sclgulf/vendor/civicrm/civicrm-core/CRM/Core/Error.php on line 520

There is no error in the CiviCRM log in the ConfigAndLog directory.
I have tried allocating 1GB instead of 512MB and it makes no difference.
Can anyone help me debug this please?

As per @Demerit's comment, and somewhat counter-intuitively, make sure you've got your debugging settings to "off" - it's running out of memory when reporting the error. If you turn the various debugging settings off, it'll still report quite a lot of detail of the error.


Connect Gmail to CiviMail? Is there a way to to do this without multiple layers of installation on multiple computers (this would be intended for 4-5 staff members regularly using Civi for donor outreach).

I'm not clear exactly what you are trying to achieve here, but there are a number of extensions that link CiviCRM to Gmail.  Have you looked at the following any of the following?

CiviGmail Integration With Gmail
Leveraging CiviCRM Email-to-Activity Processing in Gmail
Google Apps Sync


How do I add/change columns in CiviReports? How can I add more fields in columns Tab in Constituent Summary or how can I change the Fields names in columns Tab in Constituent Summary? Also every time that I export my report as a CSV file I get the columns in specific order how can I change the order to the one that I want? Thanks

The short answer is "You can't unless you're a programmer".  This is a feature that was never added to CiviReport.  However, you have many alternatives.

You can use profiles to create a Search View and use Advanced Search instead of CiviReport.
You can see if the Extended Reports extension has a report that matches your needs.
If the field(s) you want to add are custom fields, you may just need to set them as searchable.
You can hook up a third-party reporting tool.
Drupal and Backdrop users can use CiviCRM Views Integration to get the exact columns/order they want.
If you ARE a programmer, there are several questions on Stack Exchange to help you with that, along with the CiviCRM Report Reference in the Developer Guide.


Can Gravity Forms be integrated with CiviCRM? We have a site that has 5 different Gravity Forms currently. They work great and we love them. We're planning on setting up CiviCRM for this organization in WordPress and want to know if its possible to map all the data from our current forms directly into CiviCRM. Is this possible?

CiviVIP has a paid solution for Gravity Forms CiviCRM integration. - though depending on what you are doing - it may not integrate with everything you are doing in Civi. (I think it only does activities and contacts)

The CiviCRM WordPress community has galvanized around Caldera Forms and CiviCRM integration. Which is quite robust.

You may also be able to get away with using profiles - depending on what you are doing with your forms.


CiviCRM will not recognize valid email address I am trying to add a new email address for an existing contact. The address is valid. However, the new address will not save and I received this message:
Please enter a valid email address

The address is: valerie.king@lottery.nh.gov

How can I get the change accepted and saved?

The client-side validation in CiviCRM will flag any invisible or space characters which get pasted in along with an email address or URL. The non-printing characters are the trickiest to find, including things like carriage returns and line feeds that seem to get swept up in some copy-paste operations. I encounter this problem relatively frequently, but it is hard to pinpoint the exact combination of platform, browser, and source.

Therefore, if I have an e-mail address or URL which doesn't seem to take even though it appears to be well-formed, I "clear" the characters by pasting someplace else first, like the To: field in an e-mail or the URL bar in the browser. This strips out the non-ASCII characters, and I can then re-select the desired text and paste it into CiviCRM as usual.


How to change mailing form and set the default value for url_tracking to false? Is it possible to alter the mailing form? I want to set the default value for url_tracking to false. Usually I would write a hook_civicrm_buildForm and set a custom default value but this hook is not being called when loading the mailing form.

Disclaimer: I'm not an angularjs expert

Again this is a bit of a hack, we are intercepting a built-in CiviCRM angular directive and extending to add behaviour.

Create a custom extensions or use an existing one and implement hook_civicrm_angularModules:

function myextension_civicrm_angularModules(&$angularModules){
        $angularModules['myModule'] = array(
                'ext' => 'myextension',
                'js' => array('js/myModule.js'),
        );
}

In your js file:

// js/myModule.js

(function(angular, $, _){
  // Your module
  angular.module('myModule', []);

  // the hack
  angular.module('crmMailing').config(function($provide){

    // crmMailingBlockTracking directive
    $provide.decorator('crmMailingBlockTrackingDirective', function($delegate){
        var directive = $delegate[0];

        // Original link function
        var link = directive.link;

        // compile function, returns new link function
        directive.compile = function(){
            return function(scope, element, attrs){
                // get old link functionality
                link.apply(this, arguments);

                // new functionality here
                scope.$parent.$watch(attrs.crmMailing, function(){
                    var createdDate = new Date(scope.mailing.created_date).getTime()/1000;
                    var nowDate = new Date().getTime()/1000;

                    if((nowDate - createdDate) < 60){
                        scope.mailing.url_tracking = '0';
                        CRM.alert('Tracking Disabled');
                    }

                });
            };
        };

        return $delegate;
    });
  });
})(angular, CRM.$, CRM._);

The angular Mailing app uses a kind of boilerplate service, crmMailingSimpleDirective for constructing directives see here more info

The above snippet will do the same as my other answer without relying on setTimeout().

Hope that helps.


Installed on Subdomain Civimail is blank I just installed civi 4.7.27 on Wordpress 4.9.1 into a subdomain example.mysite.com
The civimail New Mailing page is blank and the System Status page is blank. Other pages are probably blank too.

I want to let everyone know that I have resolved this issue.  Apparently when installing Civi into a subdomain, you need to configure the resource urls to absolute paths instead of relying on the short codes.  See screenshot below.  If you ever have this issue, try making your resource urls look like that.


CiviCRM loads its own copy of jquery. This interferes with WP plugins I am running Civi on WordPress.  I was getting spam registrations.  I installed WP-SpamShield which worked great until someone tried to register for an event.  This fails saying that cookies and javascript need to be enabled. I backed off to just used SI Captcha Anti-Spam.  This work ok for a month or so but then the spam registrations started again.  The SpamShield support folks figured out that the problem is that Civi loads its own version of jQuery.  They say this is know to be a bad thing to do: https://pippinsplugins.com/why-loading-your-own-jquery-is-irresponsible/

Any one know why Civi does this or how to disable it?

To be clear, the article that you linked to says why it's irresponsible to remove the default jQuery in WordPress. Are you sure that CiviCRM is doing that? My understanding (possibly incorrect) was that Civi just uses its own.

Do you have the console errors that SpamShield was throwing that proves that this is what the error is? This may be a namespacing issue.


Membership not inherited if child added via webform Civi 4.6.4 / Drupal 7.38

Goal: Allow a constituent to add family members to their membership.

Issue: When a constituent adds family members, via a civi web form, the relationship is created properly, however the child does not inherit the membership.  However, if as the admin, I go in and edit the relationship, make no changes, and save, the membership is now inherited properly.

In the webform, I am adding the relationship, but not adding any membership...I'm assuming this is not necessary. The parent has an established, active membership at the time of form submission.

Has anybody experienced this or is using another process to achieve this goal?

Thanks,

--Ken

There is a bug that requires the acting user to have "access CiviMember" permission or the inherited memberships fail to be processed. I've submitted a fix for this which hopefully will be part of the next (4.6.5) release.


CiviEvent: missing are Total Fees, Payment Method First screen capture is from test drive. Second screen capture is from live.
Total Fees missing, Payment method missing.
Civi 4.7.8 on Joomla 3.5.1.

Ann - the symptoms you describe here all point to an issue with JavaScript not being loaded properly.

General recipe for trouble shooting this is to check your Browser's console for Error messages: in Firefox - you could do this by installing Firebug plug-in on Chrome you can launch the Developer Tools.

Here's an excellent write-up on troubleshooting JavaScript errors by one of the core team member's: https://forum.civicrm.org/index.php?topic=35850.0


How to add custom fields to membership report display columns? We have a set of custom data for memberships. One field is 'radio' type for newsletter delivery preference: online, paper, both, none. We can filter on this custom field in membership reports no problem, but cannot add it as a column in the report. I suspect this is an area related to custom report programming, and I'm not at all sure how to go about this. When I search on "custom field report column" I get a few hits in the forum that are a bit cryptic to me.

Update: To fix this all I had to do was upgrade to 4.6.2.

After reading your comments, I have a new answer.  Please check the custom field in question and ensure that the "Searchable?" checkbox is checked.


Activity - Send a Copy Email When filing an activity in CiviCase, there's the option "Send a Copy" to people listed in Case Roles. The email is sent correctly. However, when I "reply" to the email, the address of the sender is a default system email. Is there an option to have the "reply" email be the user that send the copy?

It used to be the logged in user but I guess some people didn't want that and it was changed in https://issues.civicrm.org/jira/browse/CRM-20308

So it now uses the order listed there:

The Reported by Contact's email address
System Default From Address
Default Organization Contact email address
Logged in user

Personally I think logged in user makes more sense, and you could have privacy and also antispam problems with the Reported By address if it's not the org's domain.

It looks like there was a setting added to allow the old behavior, but it's not clear how it's supposed to work. It looks like to prevent using the Reported By contact you would uncheck the setting "Allow Mail to be sent from logged in contact's email address" found at Administer->system settings->Outbound Email, except then it would always return the system/org-wide email address.
https://github.com/civicrm/civicrm-core/commit/4c981f371a6602cdfcda525895e0d0c40e9294d9#diff-be8afcc653a18926aabd2b40be8469f9

If you want a quick hack, try changing line 1407 in CRM/Case/BAO/Case.php from:

$receiptFrom = self::getReceiptFrom($activityId);

to

list($receiptUserName, $receiptUserEmail) = CRM_Contact_BAO_Contact_Location::getEmailDetails($userID);
$receiptFrom = "$receiptUserName <$receiptUserEmail>";


Mailings - Disabled Next/Test Buttons New mailings with all required fields and the default responsive template do not enable the Next or Test mailing buttons. As a workaround I can reuse an old mailing and update the fields. The last successful mailing was sent using 4.6.2, the current installed version of CiviCRM is 4.6.3.

Drupal 7.38

Unfortunately, my last post affirming that the problem is real and still present in the current version was deleted because the moderator thought it would be better as a 'comment' without realizing that commenting is disabled for most users. I'm not yet certain of the cause but there are a few fields in the civicrm_mailing table. In particular, the reply_id field (and a few other suspects) look like they may not be getting updated properly.
Nicholai, I'd have been happy to post this as a comment if you would be kind enough to enable commenting for individual's with a reputation of less than 50.


Wrong tax calculation on donation pages When you have two items with tax, the total tax amount is calculated for the last item only. Has anyone faced this issue? Is there any configuration I am missing?

This is core a bug and could replicate on https://dmaster.demo.civicrm.org/
Have submitted a fix for this, can you try the patch and post your comment on the PR to speedup the merge process?