CiviDiscount db update error I'm new to civi and have had it dumped in my lap, so I know little about it. However, when I go to Adminster/System Setting/Extensions, I get a popup that says 'Your extensions require database updates. Please execute the updates' When I click 'execute the updates', the next screen says '[Error: Upgrade org.civicrm.module.cividiscount to revision 2201]
DB Error: unknown error'

How can I figure out what the problem is?

I can only speak in generalities, as I use Drupal instead of WordPress. So some of these things might be in a different spot. You'll need to go to wherever WordPress has its permissions and set them there. It's possible that they have it set up so that all the permissions go through the main site or that they are individual to each site.

Here's where I turn on error handling on my install.

Some options will tell you they are not recommended on a live site. That is because they slow down your site and may show errors to the general public. Usually if I am having issues, I will turn them on temporarily so that I can get the errors to show and then turn it off once I am done.

The extension not being found is likely due to one of two things:

The site is pointing to the wrong place for extensions.
Permissions for the files. I get this when I am logged in as root to the server, but the files need to be "owned" by the user assigned to the account.


A small problem with the Côte d'Ivoire I've noticed that on some installs of CiviCRM 4.6 that I'm working with, when using a profile that includes the Country field, for an address for example, I'm seeing that Côte d'Ivoire is listed after Czech Republic, when it should be listed just after Costa Rica.

The order in the database table is correct, so what's causing the listing order to change? I can't reproduce this on the demo site, and the sites that I am seeing it on are using a different default language (English UK as opposed to US English). Might that be a cause of the issue? Any clues as to how to fix this minor yet irritating issue very welcome.

I'm guessing it's whether the particular sort implementation in each case is configured to be UTF8-aware. If I order by name asc in MySQL, I see Côte d'Ivoire just after Costa Rica. If I look at a hex dump of the actual bytes, ô expands to EF BF BD, which will appear long after o (6F) and even z if the sort isn't UTF8-aware. Have a look at the localisation configuration of PHP on your servers.

Sort order can be affected by cultural differences as you suspected, eg Swedish vs German at https://sgehrig.wordpress.com/2008/09/24/on-how-to-sort-an-array-of-utf-8-strings/


How to edit extensions git URL in www.civicrm.org/extensions We are moving the main repository of one of our public extensions.
How do we edit the git url in an existing node in www.civicrm.org/extensions ?

Make sure you're logged in to civicrm.org, find your extension's listing in the search, then on your extension page click the Edit tab. You can also edit the name, development status and description.


What table and column contain the date a contact was added? I'm trying to determine the correct table and column to check the data a contact was added to the civicrm-contact table. What is the best method for doing this?

You can use date_created on the civicrm_contact table.


How to clone memberships, display as new tab? We need to track student levels (rank) in our martial arts organization.

Each rank is essentially a paid membership (so contributions should be recorded) that doesn't expire, but we need to display the levels in their own tab on the contact summary page, not under memberships.

Pair up the membership with custom data.  Create a a field set, and mark it to display as a tab (instead of inline).  Associate the fields with the type of membership, and then you'll collect paid contributions and generate fields in a separate tab.


Upgrade to version 5.37 - Database error I have avoided upgrading for quite a while, but went ahead finally. Here is the error received below, and am completely unsure where to go to edit the field length. Or is the solution to rollback and re-install my backup and resolve it from there.
[Error: Expand internal civicrm group title field to be 255 in length]
Error Field Error Value
Type    DB_Error
Code    -1
Message DB Error: unknown error
Mode    16
UserInfo    ALTER TABLE civicrm_group CHANGE title title varchar(255) DEFAULT NULL COMMENT 'Name of Group.' [nativecode=1071 ** Specified key was too long; max key length is 767 bytes]
DebugInfo   ALTER TABLE civicrm_group CHANGE title title varchar(255) DEFAULT NULL COMMENT 'Name of Group.' [nativecode=1071 ** Specified key was too long; max key length is 767 bytes]
Here is the screenshot:

Run below command before running the upgrade
ALTER TABLE civicrm_group ROW_FORMAT=DYNAMIC;

Include the below config in mysql config file
innodb_large_prefix=true
innodb_file_format=barracuda
innodb_file_per_table=true


Mailchimp Extension - Webhook URL can't be verified I'm having trouble with creating a Mailchimp webhook and I'm unfamiliar with how to troubleshoot this any further. (I've also posted this question to the Extension's Github)

The API key and callback info is correct but when attempting to create the webhook Mailchimp says,

  We couldn't verify the URL is working. Please double check and try again. HTTP Code: 500

In using web-sniffer I get the following result:

Connect to 198.27.70.84 on port 443 ... ok

GET /tbe/civicrm?page=CiviCRM&q=civicrm%2Fmailchimp%2Fwebhook&reset=1&key=kasfBgoASBcb HTTP/1.1[CRLF]
Host: yourshulbythesea.org[CRLF]
Connection: close[CRLF]
User-Agent: Web-sniffer/1.1.0 (+http://web-sniffer.net/)[CRLF]
Accept-Encoding: gzip[CRLF]
Accept-Charset: ISO-8859-1,UTF-8;q=0.7,*;q=0.7[CRLF]
Cache-Control: no-cache[CRLF]
Accept-Language: de,en;q=0.7,en-us;q=0.3[CRLF]
Referer: http://web-sniffer.net/[CRLF]

The site's webhook URL and details:

https://yourshulbythesea.org/tbe/civicrm?page=CiviCRM&q=civicrm/mailchimp/webhook&reset=1&key=kasfBgoASBcb
Wordpress 4.7.2
CiviCRM  4.7.16
CiviCRM Mailchimp Extension 2.0

Any idea how to troubleshoot this further?

Check whether 'allow webhook posts' permission is granted to anonymous role (go to CiviCRM's Administer menu » Users and Permissions » Permissions (Access Control), then click on WordPress Access Control).


Drupal Views and Case Relationships I'm setting up a vew of cases of type "x" and using views relationships to pull in cases relationships such as "Case Worker for" Client- as well as client details.
If, I have a client who has had more than one case with the organisation. With a number of "Case Workers". how can I filter the view to only show the case relationship for the listed case?
Currently will now show duplicate lines or each case, 1 per case worker.
If I use views aggregator plus module, I can compress  the view down to one line per case- but it is normally the first added case worker shows not the one for the specific case.
See screenshot for example- 1 client, 1 case, but 5 caseworker relationships to the client

Ok, once again I should have looked more carefully at the suggested answers
If contact has multiple cases, how do I filter a view to show only case roles associated to that case type
Start with a relationship view
Then pull in the case id from the views relationships and filter on the case type, relationship type and is the relationship active
And then bring in the related contacts
Thanks @pmoz and @ehommel


Guidance Needed on using CiviCRM API + PayPal to Complete Membership Contribution Payment I'm at a total loss on how to make this work.

I am using the CiviCRM API to create a contact, create a membership for that contact, and even create a contribution if that person selects check, marking it to be paid later.

However, I cannot figure out how to pass a credit card through the API, using the PayPal integration to process the card payment and create the resulting contribution marking the membership as paid and active. None of the API resources have a parameter for card details that I could find, and I couldn't find anything on using the API to actually process payments.

Any tips? Thanks!

Although I have no experience with PayPal I would expect that the payment processor makes sure the payment details get passed on, AFAIK there is no API for credit card details nor is it required! Perhaps this might give you some clues: https://docs.civicrm.org/dev/en/latest/extensions/payment-processors/


how to have seperate contribution pages for each membership type.? i have 3 membership types.  below is the screen shot

so if a users wants to pick one of the memberships  same contribution page opens up with a list of 3 membership types.

i don't want this list to be displayed at all.how can i do this so that picking up any one leads to the contribution page and no list ,may be selected membership type in hidden .
is there hook available for attaching membership type before final contribution.??

i am not getting 'Receipt ' on successful contibution. as i have configured receipt message properly .

You can create 3 contribution pages, each having single membership type(selected under Memberships tab of contribution page) and set it to default and change the link(boxes from the screenshot) to use respective contribution page.

To hide the option you can use JS or CSS.

For emails not getting send make sure you have configured everything correctly like
1. Postfix package
2. From address in CiviCRM (CiviCRM >> Administer >> CiviMail >> From Email Address)
3. Updated the default mail accounts (CiviCRM >> Administer >> CiviMail >> Mail Accounts)
4. Updated Organization Address and Contact Info (CiviCRM >> Administer >> Comminications >> Organization Address and Contact Info

Probably looking  in Civi or CMS or apache logs for any suspicious errors might help to find the problem.

HTH

Pradeep


CiviRules Menu Not Displaying After installing CiviRules on CiviCRM 5.11, the Rules menu does not display.  We are running Drupal 7.67.  Have flushed cache, etc.

Are you also using a newer CiviRules. It used to have its own top level menu, but its now under Administer.


How can I monitor the progress of a slow upgrade? CiviCRM upgrades can take a long time.

What is the best way of seeing where they are up to?

The upgrader builds a queue of version-specific upgrade tasks -- then executes them. You can measure progress based on the size of the queue.

If you use the web-based upgrader, it displays a progress-bar based on the queue.

If you use the CLI to upgrade the DB, then it doesn't display a progress-bar. However, it would be patch-welcome to add something. (If I were doing this, I'd write a cv upgrade command which borrows heavily from http://symfony.com/doc/current/components/console/helpers/progressbar.html and https://github.com/civicrm/civicrm-core/blob/master/CRM/Upgrade/Headless.php).

If you're looking for ways to poke under the hood, then you can look at SQL tables civicrm_domain and civicrm_queue_item. I wouldn't recommend building external processes on these, but they could be good for a quick peek. These (untested) queries should be interesting:

select count(*) from civicrm_queue_item where queue_name  = 'CRM_Upgrade' (the queue gets smaller as tasks progress)
select version from civicrm_domain (updates to reflect the most recent incremental update)


Custom Data and Screens I have created a Custom Data field of the field type
Alphanumeric Select
with 3 selectable options - I want to be able to edit the options that can be selected, but when I try I get an error

"This option group is reserved for system use. You cannot add or delete options in this list."

What can I do to allow edits to the list

WordPress 5.5.8 and CiviCRM 5.5.1

The only way to designate an option group as reserved is to do so directly through the database - there is no option to do this through the UI either when it is created via a multiple-choice custom data field or when added directly via Administer > System Settings > Option Groups - there might be a reason that this option group was flagged as reserved, so you might wish to ask whoever is responsible for administering CiviCRM to shed light on the reason and/or ask them to remove the reserved flag altogether so that you can make changes when needed.

Hope this helps,
Tamar


Has anyone figured out how to deal with "dovecot" email handling on Siteground? I noticed a post in 2018 about my same issue. I am using siteground with "Localdir" (the other posting used SMTP) because our email blasts are small volumes. The emails go out ok, but the civicrm email reports can't find bounces, and clickthroughs ? A siteground support person spent 2 hours "chatting" online trying to help me, but no success. Siteground uses "dovecot" email and all civicrm emails create folder-level addresses like ".bounces.ignored" and "bounces.processed" with three folders under each - "cur, new, tmp". Not sure how to fix/patch this to work ?
I am using drupal 7.69 with civicrm 5.22.

I presume that you are talking about bulk mailings. I have got this working for small volumes hosted on Siteground. I had a lot of problems originally with subfolders though can't remember the details. My solution was as follows.

Outbound use mail() and in Administer>>CiviMail>>Mail Setting, set Mailer Batch Limit to 100 and Mailer Cron Job Limit to 1. With the Send Scheduled Mailings cron job running every half hour this throttles the outbound mail within SiteGround's limits.

Inbound i set up an account on GMail to handle the bounces so bounce processing account (Adminster>>CiviMail>>Mail Accounts) was set up using IMAP to GMail and address examplereturn@gmail.com and localpart return+ and email domain of return.example.org. I then forwarded @return.example.org to examplereturn@gmail.com. The GMail account needs some special settings as described in https://docs.civicrm.org/sysadmin/en/latest/setup/civimail/inbound/#return-channel-google-apps. All rather complicated but nothing else I tried worked.

Hope that helps.


What are `*.mgd.php` files for? Browsing through a civix generated file I see it globbing for *.mgd.php files?

What are these files all about then??

So a little research takes me to Totten's blog where he lays out the rational for splitting out entity definitions into seperate PHP files.

The full definition of the array format is laid out in the hook_civicrm_managed guide and an example .mgd.php file is here


Buildkit - amp test fails - incorrect response received The setup ran smoothly until amp test which says:

$ amp test

Expect response: "response-code-SoYwxYyBvx"
Received incorrect response: "<?php
// This is a simple script which outputs "OK" if it
// executes correctly and connects properly to a database.

if (isset($_SERVER['HTTP_CLIENT_IP'])
  || isset($_SERVER['HTTP_X_FORWARDED_FOR'])
  || !in_array(@$_SERVER['REMOTE_ADDR'], array(
    '127.0.0.1',
    '::1',
  ))
) {
  header('HTTP/1.0 403 Forbidden');
  exit('Connection must originate on localhost');
}

$config = require 'config.php';
$errors = array();

// ---------- Test HTTP inputs ----------

if (!isset($_REQUEST['exampleData']) || $_REQUEST['exampleData'] !== 'foozball') {
  $errors[]= "Error: Expected GET or POST value 'exampleData=foozball'";
}

// ---------- Test database ----------

try {
  $dbh = new \PDO($config['dsn'], $config['user'], $config['pass']);
  $dbh->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
  foreach ($dbh->query('SELECT 99 as value') as $row) {
    if ($row['value'] == 99) {
      // ok
    } else {
      $errors[] = "Error: Bad query result
";
    }
  }
  $dbh = NULL;
} catch (PDOException $e) {
  $errors[] = "Error: " . $e->getMessage() . "
";
}

// ---------- Test file permissions ----------

$dataFile = $config['dataDir'] . '/example.txt';
if (FALSE === file_put_contents($dataFile, "data")) {
  $errors[] = "Error: Failed to write $dataFile";
}
if (FALSE === unlink($dataFile)) {
  $errors[] = "Error: Failed to remove $dataFile";
}

// ---------- Wrap up ----------

if (empty($errors)) {
  echo "response-code-SoYwxYyBvx";
}
else {
  echo implode("\n", $errors);
  die();
}"
Tip: Try running "amp config" and/or restarting the webserver.

I believe I have set up amp config correctly. I even edited apache2.conf and included the line it asked to. But no matter how much I restart and test, it doesn't work.

My amp config:

mysql_dsn : mysql:civicrm:civicrm@localhost:8000
perm_type : linuxAcl
perm_user : www-data
httpd_type : apache24

And I included this line Include /root/.amp/apache.d/*.conf in apache2.conf file.

The problem was PHP files weren't being processed. I reinstalled PHP module using the following commands and it worked.

sudo /etc/init.d/apache2 stop
sudo apt-get remove --purge apache2 php5
sudo apt-get remove --purge libapache2-mod-php5
sudo apt-get install php5 apache2 libapache2-mod-php5
sudo /etc/init.d/apache2 start
sudo a2enmod php5
sudo /etc/init.d/apache2 force-reload


Why is the event registration "Thank You" page generating an error? After our organization updated to the latest version of CiviCRM, our users started receiving the following error after registering for events on our website:

  Sorry but we are not able to provide this at the moment.

  Could not find valid value for id

  Return to home page.

The user is properly registered on our system and receives a confirmation email.  It seems to be a problem with the thank you screen.  The configuration of the thank you screen is the same as before.

Ideas?

This seems to be similar to: CiviEvent - Error when registering: Could not find valid value for id

If you are using WordPress, then setting the base url might help. Copying my response to that issue below:

I was having a similar problem. I noticed the base url for WordPress was not set.

If you haven't set that, try setting that in Administer > CMS Database Integration and let us know if that fixed your issue.

Make sure the event is not the home page, that seems to cause problems with the base url.


Permissions: profile listings and forms Via the System Adminsitrator Guide: profile listings and forms : If you plan on collecting name and address or other information from visitors, enable this permission for the "anonymous" role.

Via the permissions page the following is noted: Warning: Give to trusted roles only; this permission has privacy implications. Add/edit data in online forms and access public searchable directories.

To most - Anonymous is not a "trusted" role - wondering why the warning is given - and what is the best practice.

Yes - it sounds a bit contradictory, but the true reference is to prevent anonymous users access to things like membership directories. Even so, unless you want to force everyone to login to provide this information (be it through an online contribution page, an event registration or a standalone profile), you'll need to grant this permission to the Anonymous User role. If you offer online directories to which you wish to limit access, you can limit access to that directory by using CMS permissions (e.g. require login to view the page/block/element through which this directory can be accessed on your website).


how to add fieldset to profile I added a multi-record field set to individual contacts:

  Field set name = Organizational Affiliations

  Field 1 = Organization Name
  Field 2 = Position or Title

...and see I can now add multiple affiliates to an individual via site/civicrm/contact/add?reset=1&ct=Individual.

How do add that field set to a profile?  It seems I can only add individual fields, not a set of fields, to a profile?

I intended to put this field set in a profile because the profile can be embedded in the contribution page for membership signup forms.  If there's another way new members can enter this data without using a profile that would be fine too.

I don't believe there is a way you can add a data (field) set en masse.... you need to add each field in the data set individually.


CiviCRM theme not loading after URL change I've changed the URL of our site from beta.example.net to example.net and now CiviCRM is loading with the Drupal frontend theme instead of it's own.

I've enforced the change by updating the line in .htaccess that's enforcing https. It now reads as

RewriteCond %{HTTPS} off
RewriteRule ^(.*)$ https://example.net/$1 [R=301,L]

I've also updated the base URL in Drupal's settings.php to

 $base_url = 'https://example.net';

and the site URL in civicrm.settings.php with

if (!defined('CIVICRM_UF_BASEURL')) {
  define( 'CIVICRM_UF_BASEURL'      , 'https://example.net/');
}

I've also tried setting the CMS root in civicrm.settings.php with both

define('CIVICRM_CMSDIR', 'https://example.net/');

and

define('CIVICRM_CMSDIR', '/var/sites/c/example/public_html/');

but neither seems to make any difference.

My best guess was that I'd broken something with Shoreditch, trying at some point in the past to define a relative URL so that CiviCRM wouldn't constantly display an error. But I've gone to https://example.net/civicrm/admin/extensions (I can't navigate to it through the current theme) and disabled Shoreditch and the error is still occurring.

With Shoreditch enabled, this is how the resource URLs screen currently looks:

Screenshot of the current state of the extensions page:

And, just to confirm I cleared the cache:

Drupal's own backend loads as expected (though somewhat slowly). Drupal 7.67. CiviCRM 5.18.2. Shoreditch 0.1-alpha34.

I updated CiviCRM, and all seems fine now!


How can I create a public list of event attendees? I would like to create a page on my Wordpress site that lists everyone who is registered for a specific event (EID 3 in this case). I only need a list of attendees names, sort by last name. No other columns needed.

You can do this using profiles

Create a smart group of all attendees of the event
Create manage acl to grant view permission for authenticated and anonymous user to view contacts from smart group.
Create a profile for search and include fields that you want to show.
Create manage acl to use the above  created profile for search for anonymous user
Create a post/page on wordpress and include profile search short code.

Also you can use content views wordpress instead profile to show contact belonging to smart group


Why does "from" email show a different list on single email versus bulk? I checked the option that shows all my contact email address in the from list, and if I pull up a single contact and click Action -> Send Email, it will show the full list. But when I go to Mailings -> New Mailing, it only shows the list from the From Emails list screen. Can I send a bulk email using a from address from the logged in user's contact? That list is going to be a mile long if I have to add everyone that might send bulk email to the list. I toggled the yes/no a couple times and it definitely doesn't affect the new bulk mail screen. Is there some reason the new mailing screen is required to be limited this way? Could/should the one yes/no toggle control both, or could/should a second toggle be added to allow it?

On a side note, I noticed the Mailings -> New Mailing screen doesn't sort the dropdown in the same order indicated on the config screen. Actions -> New Email does sort the from list correctly, but New Mailing doesn't.

Sending an email using CiviMail is different from sending a one-off email to an individual contact, both technically and conceptually. Sending CiviMail is a much more fraught activity in terms of ip reputation, bounce handling, etc. since it is used to send thousand of emails or more. So it makes sense to have different rules, and one of those is to limit the different From: email addresses that allowed.

It sounds like you want everyone in your database to be able to send civimails from themselves? That doesn't sound like what CiviMail is intended for.

Perhaps you're looking for more of a mailing list functionality as provided by list serve type software (mailman, etc.)?


Unable to install extensions: HTTP redirection error I'm unable to install CiviCRM extensions from CiviCRM » Administer CiviCRM. On the CiviCRM extensions page I get the following error:

  WARNING: The downloader may be unable to download files which require
  HTTP redirection. This may be a configuration issue with PHP's
  open_basedir or safe_mode.

When I try to install an extension I get the following errors:

I've checked and:

The PHP setting open_basedir is not defined.
The PHP setting safe_mode is set to off

What's going on?

I've got CiviCRM 4.5.5 installed with Wordpress 4.1.1

Try again now. I think Tim has resolved an issue that arose with the need for a new intermediate certificate for the SSL certificate replaced on C.o earlier this week: https://issues.civicrm.org/jira/browse/CRM-16191. Please comment on the issue if your error has been resolved.


How do I test a CiviCRM upgrade script? I have a PR that adds a file CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl.  How should I go about testing this code?

If you have installed civicrm-buildkit and configured civibuild, then you can use the tutorial steps at Daily Coding: Upgrade Tests.

If you don't use civibuild, then you can piece-together a similar workflow using civicrm-upgrade-test.

For more discussion about writing upgrade logic, see Upgrade Reference on the wiki.

For a general, high-level overview of automated tests (including upgrade tests), see Testing on the wiki.


URL Query String - Phone Number How can I add a phone number in a URL query string in CiviCRM?

Goal:  To bring up all records associated with that number

Thank you,

Laurie

It depends what you mean by "all records", but the custom search called full-text search (under Search - Custom Searches) can be made to run via url like so:

https://dmaster.demo.civicrm.org/civicrm/contact/search/custom?csid=15&text=894-1515&table=Contact&force=1&reset=1

That will bring up the contact with phone 894-1515.

If you want to include activities and such, then leave out the "table=Contact" part.


The contribution payment verification page has lost the site theme styling In general, what would cause a contribution verification page to lose the current theme styling? This is the page that appears after our initial membership contribution page when the user presses Submit after selecting PayPal or Pay by Check. The verification page has completely lost the header, footer, everything related to the current wordpress theme. The page still functions, but looks really strange compared to the first page.

Edit: In fact the confirm.tpl template based page is being rendered without head or body tags, it's just an html fragment. This is obviously why there is no theme on the page. As a test I switched to another theme and the page renders correctly -- so it has something to do with the theme.

I was able to get some generous support from the theme vendor. So far there is no fix for this. Confirm.tpl doesn't load the page header, and the vendor needs to know where this usually occurs. Quote:

  Ok do you have any support with this plugin [CiviCRM]? Because the template you
  spoke of doesn't add the header. I assume they are using some kind of
  wrapper but looking at the files in the plugin they are doing this in
  a non-traditional way. What I would need to know is how they are
  forcing in the template and on what hook? For example if they are
  using a template redirect to force their template in - where is the
  template that calls in the normal wordpress functions like getting the
  header.

Do you see &snippet=1 in your contribute page URL?

That parameter can be used to deactivate the theme on a CiviCRM page.

Eg -

CiviCRM demo donate page as per normal & then without theme
CiviCRM profile page as normal & same without theme

If that parameter is present in the link to your contribution page, remove it and see if this restores the proper theme.

Does your contribute page still work without the theme?


Does CiviCRM have camp or conference housing capabilities? I am evaluating CiviCRM for a camp and conference center with extensive on-site housing (former college campus). It seems very well-suited except that it seems to be lacking a housing piece. The only information I could find on this was an old forum post that went nowhere: Does CiviEvent have housing management capabilities?

Is there anything like this in existence? I found information on using Drupal, Webform Integration, and Ubercart for web-based camp registrations, but a housing component is very important for a large facility like ours.

Thanks for any input!

A housing component is not available in CiviCRM itself. You could possibly try to use CiviBooking (https://civicrm.org/extensions/civibooking), which deals with resource bookings. Depending on your exact functional requirement that might be sufficient. If you are just concerned about booking rooms it might well do for you.

If not, it will probably be a CiviCRM extension that you either have to develop yourself or find a CiviCRM specialist to develop it for you. This is very possible, we have done some specific stuff for a Dutch Housing Corporation in the past.


Error Linking Drupal user to edit their Civi CRM profile I'm attempting to provide a link for members to edit their CiviCRM profile page. I'm using the following code: civicrm/profile/edit?reset=1&gid=N.

When member clicks on the link they received the following error message:

Sorry but we are not able to provide this at the moment.
is not of the type Positive

The following is what is found in the log:

#0 /Users/executivedirector/Desktop/BAH/sites/all/modules/civicrm/CRM/Core/Error.php(374): CRM_Core_Error::backtrace()
#1 /Users/executivedirector/Desktop/BAH/sites/all/modules/civicrm/CRM/Utils/Type.php(358): CRM_Core_Error::fatal(" is not of the type Positive")
#2 /Users/executivedirector/Desktop/BAH/sites/all/modules/civicrm/CRM/Core/BAO/UFGroup.php(298): CRM_Utils_Type::escape(NULL, "Positive")
#3 /Users/executivedirector/Desktop/BAH/sites/all/modules/civicrm/CRM/Profile/Form.php(309): CRM_Core_BAO_UFGroup::getFields(NULL, FALSE, NULL, NULL, NULL, FALSE, NULL, FALSE, NULL, 1)
#4 /Users/executivedirector/Desktop/BAH/sites/all/modules/civicrm/CRM/Profile/Form/Edit.php(122): CRM_Profile_Form->preProcess()
#5 /Users/executivedirector/Desktop/BAH/sites/all/modules/civicrm/CRM/Core/Form.php(543): CRM_Profile_Form_Edit->preProcess()
#6 /Users/executivedirector/Desktop/BAH/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(92): CRM_Core_Form->buildForm()
#7 /Users/executivedirector/Desktop/BAH/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Profile_Form_Edit), "display")
#8 /Users/executivedirector/Desktop/BAH/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Profile_Form_Edit), "display")
#9 /Users/executivedirector/Desktop/BAH/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("display")
#10 /Users/executivedirector/Desktop/BAH/sites/all/modules/civicrm/CRM/Profile/Page/Router.php(108): CRM_Core_Controller->run()
#11 /Users/executivedirector/Desktop/BAH/sites/all/modules/civicrm/CRM/Core/Invoke.php(310): CRM_Profile_Page_Router->run((Array:3), NULL)
#12 /Users/executivedirector/Desktop/BAH/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:13))
#13 /Users/executivedirector/Desktop/BAH/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#14 /Users/executivedirector/Desktop/BAH/sites/all/modules/civicrm/drupal/civicrm.module(448): CRM_Core_Invoke::invoke((Array:3))
#15 [internal function](): civicrm_invoke("profile", "edit")
#16 /Users/executivedirector/Desktop/BAH/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:2))
#17 /Users/executivedirector/Desktop/BAH/index.php(21): menu_execute_active_handler()
#18 {main}

Any ideas?

To expose a profile to Drupal Users/Members for updating in Drupal - you have a number of options - including out of the box - the Profile Name and Address on /user - when your Members have a Drupal account and are logged in:

hit Hello 'Name' to get to /user
Name and Address is a CiviCRM Profile -> hit Edit to update it

Name and Address profile appears here because in it's Profile setting is has View/Edit Drupal User Account checked.


Manually adding/removing contacts in a Smart Group If you manually add/remove contacts to a Smart Group will they remain in the group when the group updates?

If you manually add a contact to a Smart Group, the system will maintain that information, similarly if you remove a contact the system will not add the contact back in automatically.


Cannot Require Once When Loading CiviCRM After Drupal Upgrade I am trying to upgrade to the newest security release of Drupal 8 (8.9.14).  After completing the update (Drupal is bootstrapping because the login page works) but CiviCRM stops being able to require specific files.  The full error is:
PHP Fatal error:  require_once(): Failed opening required 'DB/DataObject.php' (include_path='.:/var/www/site_name/vendor/civicrm/civicrm-core:/var/www/site_name/vendor/civicrm/civicrm-core/packages:.:/var/www/site_name/vendor/civicrm/civicrm-core/:/var/www/site_name/vendor/civicrm/civicrm-core//packages:/var/www/site_name/vendor/civicrm/civicrm-core/vendor/tecnickcom:/var/www/site_name/vendor/pear/archive_tar:/var/www/site_name/vendor/pear/auth_sasl:/var/www/site_name/vendor/pear/console_getopt:/var/www/site_name/vendor/pear/db:/var/www/site_name/vendor/pear/log:/var/www/site_name/vendor/pear/mail:/var/www/site_name/vendor/pear/mail_mime:/var/www/site_name/vendor/pear/net_smtp:/var/www/site_name/vendor/pear/net_socket:/var/www/site_name/vendor/pear/pear-core-minimal/src:/var/www/site_name/vendor/pear/pear_exception:/var/www/site_name/vendor/pear/validate_finance_creditcard:.:/usr/share/pear:/usr/share/php') in /var/www/site_name/vendor/civicrm/civicrm-core/CRM/Core/DAO.php on line 26, referer: https://site.org/user/login

I tried adding the full relative path to the file (../../../civicrm-packages/DB/DataObject.php) and this does not stop the problem.
My CiviCRM root is,
$civicrm_paths['civicrm.root']['path'] = '/var/www/site_folder/vendor/civicrm/';

The variable is
$civicrm_root = '/var/www/site_folder/vendor/civicrm/civicrm-core/';

I tried changing the path for the array in ['civicrm.root']['path'] but this did not do anything.
I tried upgrading CiviCRM too. That did not work either.
I have figured out that the issue is not related to the Drupal upgrade itself but rather to the packages being upgraded with Drupal.

symfony/debug (v4.4.20 => v4.4.22):
symfony/var-dumper (v4.4.21 => v4.4.22):
guzzlehttp/psr7 (1.8.1 => 1.8.2)
doctrine/cache (1.10.2 => 1.11.0)
doctrine/inflector (1.4.3 => 1.4.4)
laminas/laminas-feed (2.14.0 => 2.14.1)

I have not narrowed down which library is the issue.
I appreciate any help figuring this out.
Thanks,
Josh

The $civicrm_paths['civicrm.root']['path'] should match with $civicrm_root,
can you try by updating your $civicrm_paths['civicrm.root']['path'] to
$civicrm_paths['civicrm.root']['path'] = '/var/www/networkpaao/vendor/civicrm/civicrm-core/';


Can webform-civicrm pre-select an event using Drupal Views? The answer is (I hope) 'yes' but I can't get it to work - see How to select a default event in webform where event is repeating
 I'm pretty sure the Views side is working as it generated a url that when clicked gave me the webform with the correct event selected (this is on a Views screen).  But when I run the webform I get '- None -' displayed in the event list box. Yes, I have checked "Allow events to be autoloaded from URL checked."  Code is at the latest level - I went back to Webform 7.4.9 and Webform 7.4.11 to see if there had been a regression but no change.
So now I'm wondering if this is a bug in Webform-CiviCRM?

I believe this has been implemented now so that there is a setting on the Event section of the webform's civicrm tab so that you can 'allow events to be autoloaded from URL'


What does the 'Validate Email Address from Mailings' scheduled job do? Under Settings > Scheduled Jobs there is a job called 'Validate Email Address from Mailings'.  I'm not clear what this does exactly.

The documentation says:

  Updates the reset_date on an email address to indicate that there was a valid delivery to this email address.

I'm not clear what this means and what affect it has on the email address.

Could somebody explain how this works?

Also could you explain what the parameters do:

  minDays, maxDays=Consider mailings that have completed between minDays and maxDays

I'm using CiviCRM 4.6.8.

Many thanks for your help.

The scheduled job examines previously sent emails (in the range of dates if given) for any confirmation that the email was rec'd, typically opens or clicks, and if found the reset_date is updated.


Unable to donate due to DOB format anomaly I have just created a donate form via Civi. Tried to donate (after logging in as account holder) and completed first from ok. DOB in correct format of

27-09-64 (selected from the pop calendar)

On clicking Confirm Payment the page asking

Please verify the information below carefully

showns - However that is where it has altered the format to

DOB
09/27/1964

and on clicking Continue I get

Please correct the following errors in the form fields below:
Please select Date of Birth

Can someone tell me how to solve please?

Joomla 3.6.5 - Civicrm 4.7.14

Have you formatted the date in Administer/Localization/Date Formats? For the UK  'Complete Date' is set to '%B %E, %Y', and 'Complete Date and Time' is set to '%E%f  %B, %Y %l:%M %P'.  Also 'Date Input Fields' is set to 'dd/mm/yyyy' which is probably the critical one in this case.


Can I see (smart) group relations? Is there a way in which I can easily see how the smart groups are related (as in include / exclude search)?

When I try to build a group which selects the contacts I need, I often combine multiple smart groups to arrive to necessary results. It would be very convenient to see how they are related. Is there an easy way to tell, if a particular group is used in some other group (so that it could be modified or deleted without worry)? Or should I check all other groups to make sure that none of them actually uses the group I am about to delete/modify?

Smartgroup criteria are stored using the SavedSearch api.  Use the API explorer (/civicrm/api#explorer) and select entity: SavedSearch action: get

In each of the values returned, there is a form_values key with a  list of components that define the search. The list varies depending on how the search was created.

If you look at one created from an include/exclude search, then it contains components like:

        [
            "excludeGroups",
            "IN",
            [
                "4"
            ],
            "0",
            "0"
        ],

Without checking the details of each of those parameters, it's very likely that group_id 4 is involved in this query.

Likewise for an example created from Advanced Search:

           [
            "group",
            "=",
            {
                "IN": [
                    "5"
                ]
            },
            "0",
            "0"
        ],

So group_id 5 is involved in this.

A smart group is linked to a SavedSearch by the saved_search_id attribute - in API Explorer, set entity to Group, action to get and look for saved_search_id

If you just want to understand which groups depend on others, then visual inspection of the SavedSearch.get output might be enough.

Expanding this into an extension to show those dependencies would be nice, but tricky since the components of the form_values list depends on how the search was created.  You would need to experiment with the various ways of creating smart groups to identify all the syntaxes that relate to groups but even then, custom searches define their own definitions (as include/exclude does), so it would be easy to miss some giving incomplete results.  In other words, it would be easier to say "This group does depend on this other group" rather then "This group does not depend on this other group".


Discrepancy between # of contacts in smart group vs # of contacts in smart group mailing Using Drupal 7.67 and CiviCRM 5.13.5.

We run volunteer inductions, and send an email to all people who have attended volunteer inductions (as per CiviEvent) after the induction. We only run inductions once a month, though there is sometimes a delay of a few days until our volunteer coordinator can send this email to induction attendees.

This is done through sending an email through CiviMail to a Smart Group. (We do it through CiviMail rather than through CiviEvent > Email all participants, because we want to see who opens the email and clicks on particular links).

The smart group has the following criteria:

 - Group(s) = Attended volunteer induction - last 7 days ...AND...
 - Group Status 'Added' ...AND...
 - Event Type = Volunteer Induction ...AND...
 - Start Date - greater than or equal to "4th July 2019 12.00 AM" ...AND...
 - End Date - less than or equal to "10th July 2019 11.59 PM" ...AND...
 - Participant Status (ID) In Attended ...AND...
 - Participant is not a Test

We use the start date and end date to only select people who have attended a volunteer induction in the last 7 days (the actual group criteria we've configured is "event date: last 7 days including today").

We haven't had a volunteer induction in the last 7 days, apart from a test one I've just made in which there is only one attendee (me).

However I'm seeing huge discrepancies between the number of contacts that should be in the smart group (1 - just me, since the only Volunteer Induction event in the last 7 days is a test one I just made) and the number of contacts that a mailing would be sent to, in CiviMail.

Contacts > Manage Groups

This page shows 32 contacts are in the group (wrong).

From that page: "Contacts"

Clicking the "Contacts" link on the aforementioned page/the above screenshot, again shows that there are 32 contacts in the group (wrong).

"Edit Smart Group Criteria"

Clicking the "Edit Smart Group Criteria" page takes me to a new search page that shows there is only one contact in the smart group (the correct number of contacts!). I didn't actually edit any of the criteria, I only clicked the button and it shows me the correct number.

CiviMail recipients

However when I go to CiviMail and select the smart group as the recipient, it shows that it will be sent to 31 recipients (??) rather than 1. Looking into the recipients list, the 1 contact that should actually be in the smart group based on the criteria IS in the group, plus another 30 that may have previously met the criteria but don't anymore (based on attendance date).

--

This is pretty perplexing, does anyone know what's happening here? As I mentioned, the extra contacts who are showing up in the group are contacts who previously met the smart group criteria but don't anymore (they attended a volunteer induction a couple months ago, not in the last week).

I do wonder if it's because the smart group is referencing itself... in the criteria I pasted in at the top of this post, the first line seems to imply that contacts who are in the smart group, are ...in the smart group. But in screenshot 3 (under "edit smart group criteria"), that first criteria isn't there any more.

I think we've worked it out! A while ago some contacts had been manually added to the Smart Group (their status on the contact list for screenshot 2 showed them as 'Added' rather than 'Smart'). Smart groups don't automatically remove these people, so I've manually removed them which should solve the problem.

Going to avoid manually adding people to Smart Groups now and let them do their thing!


Prospect Management & Tracking Are there any extensions which allow for Prospect Management & Tracking? I came across a planned extension called "INTEGRATION WITH DONORSEARCH" but it doesn't look like it has been completed yet, though target date was February 15, 2017.

You may want to check out CiviProspect.  From the README:

CiviProspect provides the core structure for creating/ managing/ converting the fundraising opportunities of an organisation. It can also be used to manage any monetary opportunities such as sales opportunities and event sponsorships.


Filter Mailing List report for unsent mails I have a mailing list with 788 recipients. When run, the hosting server choked at 520 records because of server limitations. When I run the sent/scheduled mailings report I can generate the delivery summary and can get a .csv of both the intended recipients and the successful deliveries. The list of "intended recipient" contacts has one of two entries in the Delivery Status field: Successful and Unknown.

What I need to do is  filter the original recipients list for delivery status=Unknown, but that I can't find a method to accomplish that.

I've solved the host resource limitations issue by using Mailchimp and the Joomla Mailchimp extension. Now I want to resend the email only to the 228 people the server never got to.  Is there any way? I have tried custom searches, filters, various reports, but no luck.

Any help would be appreciated.
Thanks.

Since this is a one time issue (now that you've resolved with MailChimp), I would use that CSV to 're-import' those intended recipients with an Unknown status. The CSV should have email address as a field, so you can use that to match up your contacts.  See Importing Data and Importing Data - CiviCRM Wiki for reference.

When you import the contacts, use the Update or Fill option for "For Duplicate Contacts" option (and they should all match if your dedupe rule uses email address). In one of the last steps of the import, you can add them to a new group. Use that group as the recipients for your re-sent mailing.


Does changing a price set for an event retroactively change reports? If a price set is changed in terms of prices etc will that affect reports for past events that used that same price set?

If it did do that we would have a huge list of price sets just to maintain reporting!

Cheers!

Almost certainly no, but it might depend on the report you're looking at. Specifically, financial transaction data is stored with the full amounts, not just a reference to the price set, so you can't change a contribution by changing the priceset it came from.

In other words, it's safe to update a priceset from one year to the next for an annual event, for example.


Membership Report Issues I have a discrepancy of 15 contacts between reports and need help figuring out where the error is. The Membership Summary is showing 1,108 members and yet the Membership Detail Report is showing only 1,093 records. Can someone please tell me why there is a discrepancy and how to fix it. Thank you!

Agree with Jon. I would also guess that there are contacts in your database who have more than one membership. Membership reports are based on the object membership, so they count these rather than only the contacts attached to them. But screenshots would be helpful.


Drupal Views - Show "Contribution" + Drupal User fields A client requires one of their reports include information from both CiviContribute, but also Drupal user fields (such as login name).

We're trying to build this as a View.

However, when creating the view, and the "Show" dropdown, we select "CiviCRM Contribution", but cannot get access to the "Users" fields.

Anyone have a solution for this?

Nevermind, figured it out - had to create a Relationship to CiviCRM Contacts: Drupal ID. Issue resolved.


{domain...} tokens not parsed in regular mail? Is it me, or are the {domain...} tokens not parsed in a private (non-civimail) mail ? Like, when sending a mail from a contacts page ?

If it isn't me, then the documentation here is wrong ?
https://docs.civicrm.org/user/en/latest/common-workflows/tokens-and-mail-merge/#domainaddress

Drupal 7.56, CiviCRM 4.7.27

Domain tokens are not replaced when trying to send email activity for a contact. This seems like a bug in civicrm or wrong documentation. This can be fixed by applying below patch.

diff --git a/CRM/Activity/BAO/Activity.php b/CRM/Activity/BAO/Activity.php
index 787a1c955d..35133010e1 100644
--- a/CRM/Activity/BAO/Activity.php
+++ b/CRM/Activity/BAO/Activity.php
@@ -1587,6 +1587,12 @@ LEFT JOIN civicrm_activity_contact src ON (src.activity_id = ac.activity_id AND
         $values = array_merge($values, $details["{$contactId}"]);
       }

+      $domainTokens = array_merge($subjectToken, $messageToken);
+      $domain = CRM_Core_BAO_Domain::getDomain();
+      foreach (['subject', 'text', 'html'] as $bodyType) {
+        $$bodyType = CRM_Utils_Token::replaceDomainTokens($$bodyType, $domain, TRUE, $domainTokens, TRUE);
+      }
+
       $tokenSubject = CRM_Utils_Token::replaceContactTokens($subject, $values, FALSE, $subjectToken, FALSE, $escapeSmarty);
       $tokenSubject = CRM_Utils_Token::replaceHookTokens($tokenSubject, $values, $categories, FALSE, $escapeSmarty);


Restrict Activity Types by Contact Type(s) Is there a way to disable certain activity types based on the contact type?

As far as I know this has not been delivered by anyone as yet but there was some substantive discussion about ACL and Activity Types here


Saving CiviRules Rules https://lab.civicrm.org/extensions/civirules/-/blob/master/README.md has a reference to "SAVE YOUR EXISTING RULES FIRST." I realize that regarded upgrading from 1.x but I'm interested because I ran into a problem upgrading from 2.19 straight to 2.22 and, if possible, would like to back up just the rules before probing further. Is there a way to save / back-up and later restore just the rules?

There is no import/export function as far as I know but.....
your rules will be saved in a few tables:

civirule_rule will contain your rules
civirule_rule_action will contain the combination of actions in your rules
civirule_rule_condition will contain the combination of conditions in your rules
civirule_rule_log will contain the logs of your executed rules
civirule_rule_tag will contain the tags of your rules

You can save these tables before you upgrade and then later restore BUT you would have to make sure that you check the ID's of actions and conditions! So to be on the safe side I would save the tables civirule_action and civirule_condition too so you can compare after the upgrade.
Also, be aware that if you have any delayed rules you have to check the civicrm_queue_item table and execute the cron job for delayed rules until there are no more items left BEFORE you upgrade.
Alternatively you can either develop an import/export function yourself or fund a CiviCRM expert to create that function in the CiviRules extension?


How to create a report for members with no email address I would like to create a report of members that don't have emails.  How would I go about creating such a list in CIVICRM

Use Search Builder:

Go to Search menu » Search Builder.
Set your Search terms to "Contacts" "Email" "Primary" "Is Empty" (see screenshot).
Press Search.


Site not working after using CiviCRM its shows error in wordpress site Error :

Error: Could not create directory: /home/abcdraw/public_html/wp-content.

If you have moved an existing CiviCRM installation from one location or server to another there are several steps you will need to follow. They are detailed on this CiviCRM wiki page - http://wiki.civicrm.org/confluence/display/CRMDOC/Moving+an+Existing+Installation+to+a+New+Server+or+Location. A fix for the specific problem that caused this error message to be displayed is to set the value of the config_backend column in the civicrm_domain table to NULL. However we strongly recommend that you review and follow all the steps in that document.

Even Admin panel shows same error.
when i rename civicrm then site will blank.

Looking at the error messages, this looks like an issue with WordPress rather than CiviCRM specifically.  There are several error messages for other WordPress plugins in addition to CiviCRM.

As a first step, I would suggest that you disable all of the plugins (including CiviCRM) and see if WordPress itself is working correctly.  If that works, you can then try enabling the plugins one by one to see which is causing the issue.

I notice that most of the errors refer to the path /home/jumpcbu/... but the CiviCRM error refers to /home/abcdraw/....  This leads me to believe that you may have recently moved server.  In which case, this may be the cause of your problems.  I would suggest that you look at the documentation about moving to a new server that is mentioned in the error message you posted.


When importing memberships, I get "Error: Invalid value for field(s) : Start Date; End date" I hope someone can answer this!
I've tried 30 various date formats, rearranged columns, and every time I do a membership import it fAils. No errors are presented, I'm just returned to "Upload Data (step 1 of 4)" from step 3... I never see step 4 (summary).
In "plugins/files/civicrm/upload" folder I see a file "sqlImport.errors" which shows an error not recognizing the date formate for the membership start and end

But I've tried every format and none work. :(.

Each time one membership record (1 row) imports, and then if fails! Every time.

The first 2,5 lines of sqlImport.errors says:

Line Number","Reason","External Identifier (match to contact)","Membership Type Id","Email (match to contact)","Membership Start Date","Membership Expiration Date"
"2","Invalid value for field(s) : Start Date; End date","33","Adult","wfsdfoks@telus.net","06/01/2013","06/01/2014"
"3","Invalid value for field(s) : Start Date; End date","34","Youth","helsdfng@rebalasdftouch.com","06/01/2013","06/01/2015"

I've tried different formats of dates (yyyy-mm-dd, mm/dd/yy, mm/dd/yyyy, dd/mm/yyyy) and selected the appropriate format from Step 1 in the import page.

Every time it's the same:
- I get to Step 3, and click "Submit"
- 1 (one, only) row get imported (correctly) and then
- I'm taken back to Step 1 - No error, complaint, nothing.

In my server's error log I see:

...client denied by server configuration: /home/civicthe/public_html/wp-content/plugins/files/civicrm/custom/delete-this-OcxGgONTcR
... client denied by server configuration: /home/civicthe/public_html/wp-content/plugins/files/civicrm/upload/delete-this-Zj1bvAyuTv
...client denied by server configuration: /home/civicthe/public_html/wp-content/plugins/files/civicrm/ConfigAndLog/CiviCRM.fee2178658acc8deae2211eadc328c3b.log

FYI, after each fail (1 row imports) I delete the top row from the .csv file and try again, and again 1 row imports, so it can't be the .csv file.

Can anyone help? This is driving me bonkers.  Why does it fail if the next time I run the

Are you using WPSec or some other security related wordpress plugins? Check:

https://wordpress.org/support/topic/plugin-better-wp-security-client-denied-by-server-configuration

Seems like:

a. CiviCRM is trying to write something to the log file

b. The security plugin traps that and redirects you back to step 1

try disabling the plugins and see if that helps


What data fields are available to me at receipt template My CiviCRM 5.16.
When I try to add fields to receipt template, I discovered that I could add {$line.contribution_id} which shows the record ID of the contribution.
But adding {$line.creditnote_id} (which is also a field in table civicrm_contribution) shows nothing.

How can I know (or change) the data fields that are available for me to show on the receipts?

Thank you.

In the message template, put this in the  section of the html format section and then send yourself a contribution receipt.

{assign_debug_info}

    {section name=vars loop=$_debug_keys}

            {ldelim}${$_debug_keys[vars]|escape:'html'}{rdelim}
            {$_debug_vals[vars]|@debug_print_var}

    {/section}

This does basically the same thing as using {debug} in regular smarty templates to see the variables in the UI.


Return after login going through contribution flow doens't bring up contribution page Going through contribution flow reach point where user needs to log in

  If you would like to create an account on this site, check the box
  below and enter a Username and a password. If you already have an
  account please login before completing this form.

  Please login is a link that takes one to login and then return to
  contribution page.

Problem is after logging in  the url is

https://www.isfpta.org/index.php?option=com_civicrm&amp;task=civicrm/contribute/transact&amp;Itemid=1726&amp;reset=1&amp;id=13

If you pull the amp: out after the & it works.
Current versions of Joomla 3.36 and civicrm 4.6.3

This may well be a bug. It would be helpful if you could recreate it on demo.civicrm.org. See https://civicrm.org/bug-reporting


Import contributions without name Previously I could import contributions without name (contact ID was enough).

I no longer have this option. It now demands first and last names.

Is there a workaround? My raw data often has variations of the name and I want to keep my original.

Lal

By default, CiviCRM requires at least one of email, first name, or last name. You can change this at Contacts > Find and Merge Duplicate Contacts, creating a new rule and setting it for usage when unsupervised, or, more appropriately, by selecting it as the Dedupe Rule when importing at Contacts > Import Contacts. Beware of setting the rule to identify duplicates too loosely, as you will end up with lots of duplicates in your database. This is a complicated, tricky area...good luck.


Is there a payment processor extension for Worldpay or do we need to create one? Do we have a extension already in the community which allows us to use Worldpay as a payment processor? I have not found one. Do we need to create new payment processor extension for Worldpay?

It looks like there is experimental code available on Github for a Worldpay processor, which might need further development.

You may also want to explore the Omnipay extension. It doesn't list Worldpay on the extension page yet, but there is a driver for Worldpay with Omnipay that may just need some testing and/or minor tweaks to get running with CiviCRM using the Omnipay extension.


How do I search for all unsubscribed e-mails across any/all groups Newbie question: How do I search for all unsubscribed e-mails across any/all groups?

I would also like to mark e-mail addresses if they're unsubscribed from an imported list. How do I do this?

Thanks!

Adam

Not sure what version of Civi you are on (I'm on 4.7.9), but take a looking under Reports > Mailing Reports > Mailing Detail Report - I think this will give you a good solid list to work with (see attached screen shot for available columns) - on the filters tab you also have the option to filter by group.

Hope this helps!
Tamar


Case Type field not available to add to a profile I would like to make a profile that I can use to change case types and update statuses. The Case Status field is available to add to a profile but Case Type is not. This is true in my instance (Spark) and in the demo at https://dmaster.demo.civicrm.org/.

Is this just something I have to live with or is there a way to make Case Type available for profiles?

Case Type isn't really a field it's a whole set of configuration items. I don't think you can do batch case type updates in core. There might be an extension (e.g. https://civicrm.org/extensions/webform-civicrm-integration) but I don't remember seeing if it had something for this.


How to disable link tracking in emails? We are having a problem with the click through links in the email templates.  I need to see if it works if link tracking is disabled.  Where can I turn that off?

Thank you

It's hard to answer this without knowing your CiviCRM version - but in 4.6+, there should be a "Tracking" tab when you go to Mailings » New Mailing.  See screenshot below.  You can uncheck Track Click-Throughs.  Note that this is a per-mailing setting!


How can I avoid my import crashing with a Fatal Error due to an existing external ID? I've had a few separate imports crash with a fatal error in the last month:

  Sorry but we are not able to provide this at the moment.
  DB Error: already exists

  Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame thrown in /home/user/public_html/sites/all/modules/civicrm/Civi/Core/Transaction/Manager.php on line 107

In my case it seems to have something to do with external IDs that already exist in the database and are also in the import file. How can I avoid having imports fatally die in the middle of things?

Thanks to Jamie McClelland, there is a patch available to make this more user-friendly. At some point hopefully it will be merged into core.

JIRA: https://issues.civicrm.org/jira/browse/CRM-19664
PR: https://github.com/civicrm/civicrm-core/pull/9410

With this patch applied, instead of a fatal error, the import will continue and the problem rows will be pulled out in an error file at the end.


Is there a way to make all Mosaico blocks the same width? When adding Mosaico blocks each has its own width.  That creates problems if you want a different color for the external background but not have it change its width  depending on the width of each Mosaico block.

Mosaico template 1.19 solves the problem with transparent background for the Logo block at the top.  Thanks


Upgrade to 4.6.6 : how to configure mysql server? I upgraded Civicrm to 4.6.6 (next 4.6.7) and had a lot of problems since then. My sql server has started consuming much more memory while everything was allright before the upgrade with 512M of RAM.
After the upgrade, the server crashed because it was overconsuming memory. It never happened before. I lowered the values (of cache and tmp tables). I had then a issue with max connections reached. I restarted the server several times and try to find the good configuration but no success for now.
What is a fair configuration of mysql server with drupal 7 and civicrm 4.6.7?
Does anyone has an idea why the upgrade made this problem occur ?
Thanks a lot
Laure

A lot depends on how much data you maintain in terms of contacts, participants, members, etc.

I have seldom seen any recent install of CiviCRM (on Drupal 7) running well on anything less than 1 gig, and I always recommend at least 1.5 gig; usually 2 gig.

Sorry, but I suspect no amount of MySQL tuning is going to give you what you need with only 512M.


CiviCRM_API3_Exception: "DB Error: no such table" Hello I am getting the below error when going to certain pages in my civicrm install notably after transfering from one server to a new server....the source server does not have this error.....

CiviCRM_API3_Exception: "DB Error: no such table"

#0 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/CRM/Mailing/Info.php(124): civicrm_api3("Mailing", "gettokens", (Array:3))
#1 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/Civi/Angular/Manager.php(100): CRM_Mailing_Info->getAngularModules()
#2 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/Civi/Angular/Manager.php(178): Civi\Angular\Manager->getModules()
#3 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/Civi/Angular/AngularLoader.php(216): Civi\Angular\Manager->resolveDefaultModules("civicrm/a")
#4 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/Civi/Angular/AngularLoader.php(108): Civi\Angular\AngularLoader->findActiveModules()
#5 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/Civi/Angular/Page/Main.php(83): Civi\Angular\AngularLoader->load()
#6 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/Civi/Angular/Page/Main.php(69): Civi\Angular\Page\Main->registerResources()
#7 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(311): Civi\Angular\Page\Main->run((Array:2), NULL)
#8 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(85): CRM_Core_Invoke::runItem((Array:12))
#9 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:2))
#10 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/drupal/civicrm.module(444): CRM_Core_Invoke::invoke((Array:2))
#11 /data/www/vhosts/jta.org.jm/httpdocs/includes/menu.inc(527): civicrm_invoke("a")
#12 /data/www/vhosts/jta.org.jm/httpdocs/index.php(21): menu_execute_active_handler()
#13 {main}

@trevorforrest I would check that your database has all the same tables as the old server, the error suggests you may have missed a table or something when transferring from the old server to the new server


Trigger event scheduled reminders on registration date or change of participant status Is it possible to set up event scheduled reminders so they are triggered on event registration date rather than event start/end dates? This would be very handy for sending event details like venue etc etc to people once they register.

Is it also possible to create an event schedule reminder so they are triggered when the event participant status changes - eg, we have an application process for some events, and when the application is approved we change their status to 'application accepted'. We'd like to send them an email with their event details at that moment.

I'm aware that quite a bit of this could be done through scheduled reminders based on Activities.

However, we want our event scheduled reminders to be portable from one event to another - and currently event scheduled reminders on events or event templates will be copied to new events based on them.

Civicrm 4.7.22, Drupal 7.56

Well, it turns out that half of this has a very simple answer - so simple that probably every one else is already doing it!

To send an email when someone registers can be simply achieved by creating a scheduled reminder set to go sufficiently early enough before the event's start date that this time is in the past. This way everyone who registers will do so after the date the email is set to go, and so they will receive the email.

You need to be careful with this method - if you make such an email after people have started registering for the event, then everyone who has registered prior to the date the email is set to go will get the email.

To only send the email to some of the currently registered participants, now or in the future, you could put those participants into a group, and choose to 'limit' the scheduled reminder that group.

Regarding sending emails based on a change of participant status - Jitendra tells me that this would require significant additions to how scheduled reminders currently work.

So instead, we have written a rather skimpy extension to cobble through the job - feel free to connect if you'd like a copy.


Live links are not working for Events I am using Joomla 3.8.8 stable and CiviCRM 4.7.25 New or copied live event and payment links are being redirected to the homepage. Existing events work and go to forms.

When I click your links I can see that the "bad" link returns a 302 redirect - but the "good" link does not.  I would review your CiviCRM log (in ConfigAndLog for an error that appears when someone hits the bad link.


Within an extension how can load a custom `Civi` name-spaced class? Within my extension I can load classes from CiviCRM's core codebase like this:

$foo = new \Civi\Core\AssetBuilder();

And I can also load custom classes that I've written in my extension like this:

$foo = new CRM_MyExtension_MyClass();

Cool.

But if I've defined a custom class within my extension using the Civi namespace, the following does not work:

$foo = new \Civi\MyExtension\MyClass();

It fails with this error message:

  Error: Class 'Civi\MyExtension\MyClass' not found in ...

How can I load this custom class from within my extension?

Add the following elements to your extension's info.xml file to enable PSR-4 autoloading:

<classloader>
  <psr4 prefix="Civi\" path="Civi"/>
</classloader>

Also see docs on the <classloader> element


Household Membership Identifiers We are a non profit volunteer group with 16000 members. Our members are household members and then have individuals with a relationship link. One issue that is bugging us is that when we look for example at our membership list, the household name is that of the last name of the household. EG Smith. However we have 92 "smiths". What is the best way to narrow down which smith we are looking at. Should we also include after their last name a comma followed by eg Tony & Michelle? Our volunteers sometimes need to quickly look at the persons name and choose their record. Or is their a better way.

You can certainly do what you suggest and change the household name to Smith, Tony & Michelle or you could change it to Tony & Michelle Smith.

There are pros and cons for each.

Try it out on your test site, or on one of the demo sites for two different households and pay attention to the form of the Addressee and mail and postal greetings in each case.

Also try searching for the households using both quick and advanced search.

You will have to decide which format for the household name suits your particular system best.


Can't use backup migrate module, CIVI crm error is: "The website encountered an unexpected error. Please try again later." Been using Xampp and doing backups for years, it's Xampp portable, so solved my timeout issues a long time ago...

All other sites on this Xampp local work fine, using windows 10, 64, and Drupal7/CIVI CRM.

This worked fine, but just stopped suddendly.

I looked a the error log , and Drupal doesn't even have an "admin/config/system/backup_migrate" directory, am I missing something here?

Now getting these errors:

The website encountered an unexpected error. Please try again later.

Log shows this:

Type    php
Date    Friday, September 28, 2018 - 16:50
User    1
Location    http://localhost/crm4/admin/config/system/backup_migrate
Referrer    http://localhost/crm4/admin/config/system/backup_migrate
Message PDOException: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'crm4.civicrm_value_files_8' doesn't exist in engine: SHOW CREATE VIEW `civicrm_value_files_8`; Array ( ) in backup_migrate_source_db_mysql->query() (line 435 of C:\Core\XAMPP_2018\htdocs\crm4\sites\all\modules\backup_migrate\includes\sources.db.mysql.inc).

**

To clear up the smaller issue - Drupal, like most modern web apps, will not have a directory corresponding to most of its URLs.  It will use redirects (defined in the webroot .htaccess file) to map URLs to a dynamically-generated page which doesn't exist on disk.

To speak to your primary issue - it sounds like you've got a MySQL view in your database.  CiviCRM doesn't typically create MySQL views, though there are some exceptions (I believe CiviCase might use them).  There are also sometimes reasons to create them manually - for instance, I created one for a client so CiviCRM could integrate with software that produces membership cards.

You have a view that references data that no longer exists.  It seems someone recently deleted a custom field group called "Files" with a custom group id of 8.  You have a MySQL view built in part from the table that holds that data.  The table is gone, so the view is broken.

Most likely, if the custom group is deleted, you no longer need the view, and it's safe to simply delete the view using PhpMyAdmin or similar.  However, it may be worth exploring whether that custom field group was deleted intentionally.


Why can I no longer Merge Contact records in 5.7.3? After upgrading from 4.6.x to 5.7.3 staff is finding that many records can no longer be merged -> error:

#1 /var/www/platform/oursite/sites/all/modules/civicrm/CRM/Utils/Type.php(554): CRM_Core_Error::fatal("One of parameters  (value: Email) is not of the type Integer")
#2 /var/www/platform/oursite/sites/all/modules/civicrm/CRM/Core/DAO.php(1517): CRM_Utils_Type::validate("Email", "Integer")
#3 /var/www/platform/oursite/sites/all/modules/civicrm/CRM/Core/DAO.php(1481): CRM_Core_DAO::composeQuery("\n                        SELECT v.label\n

So I looked at the civicrm email records of the two contacts that produce such an error and they look fine.

Alan figured out that this is a bug: during the merge process when data is being gathered about both contacts, code is verifying that the value is valid, but it does so after converting it to an option value (i.e. email is "2").

A quick workaround for those struggling with the same issue - remove Preferred Method Email from Contacts. For this client this field is no longer used so we could just:

update civicrm_contact set preferred_communication_method=NULL where preferred_communication_method=2;

Merges are working again - phew!


DreamHost is dropping support for Catch-All mailboxes I use CiviMail in conjunction with a catch-all mailbox.  The bounce processing updates the database when there’s bad email addresses and reports bounces on the mail report.  It also handles user opt-outs. We use DreamHost, and they’re dropping support for catch-all mailboxes as of 10/1/18.  Ugh.  DreamHost doesn’t support VERP either.  I found this documentation: https://docs.civicrm.org/sysadmin/en/latest/setup/civimail/inbound/
which has this section:

  Variable Envelope Return Path (VERP)
  CiviCRM Bounce handling depends
  on using Variable Envelope Return Path (VERP). If your email server
  doesn't support VERP you will only be able to properly support bounce
  requests if you can set up a catch all email. If you cannot setup a
  catch all email and your server does not support VERP you will need to
  edit packages/Mail/smtp.php as follows near line 275:
  //if (!empty($headers['Return-Path'])) {
         // $from = $headers['Return-Path'];
         //}

So, I set up a new mailbox bounce@domain.org and marked it in Administer | CiviMail | Mail Accounts as the account for bounce processing.  I commented out the three lines of code shown above.  I did a test mailing with a bad email address, but the delivery failure went back to the sending email address (wisconsin@domain.org) instead of bounce@domain.org.  What am I doing wrong??? Thanks for your help!

UPDATE: I don't want my email blasts to come from bounce@domain.org.  CiviMail lets you specify the bounce email address in Administer | CiviMail | Mail Accounts.  It just doesn't work!  One clue I found was in my own question posted in 2015 (Problem using CiviMail with Bluehost), where Xavier points out that the lines of code I commented out are the one's needed to be able to identify who was the recipient, so if it bounces, Civi can identify it properly.  So, I reinstated those lines of code. But the bounce went to the old Catch-All account, instead of the new bounce account. Then I disabled the Catch-All account. Now I can't find the delivery failure email anywhere?!? Please help!!! I'm using CiviCRM 4.7.20 and the current version of WordPress.

Demerit's comments probably constitute the best answer available. It's a loss in flexibility and functionality compared to being able to use a catch-all mailbox, but it's probably as good as it gets, given the situation. I may experiment with SendGrid, but I'm not impressed with them so far. It's a public company that makes it difficult to ask a question. I could only ask a question after I signed up with them.  It was answered by someone who just googled SendGrid CiviCRM and came up with a few fairly worthless links.


For some reason, cron doesn't work. On CMS joomla For some reason, cron doesn't work. On CMS joomla
The system thinks that it works, and shows in the status that everything is fine, but mailings are not sent at the same time.
Cron settings on the screen.
Tell me what could be the matter?
Cron doesn't work joomla

This may be the Joomla-specific bug documented in dev/joomla#6, where cron runs successfully but the mailing scheduler fails due to a permission failure.


Is 1Gb memory enough for small server? We have AmazonAWS t2.micro server (free tier). T2. micro has 1 Gb of ram and 1 vCPU. Only CiviCRM (4.7.14) is hosted there along with its Drupal.

Currently the database is very small (less than 5000 contacts). Once a day we request Cron to email 6-8 reports (e.g., all contacts, contributions in last 3 years, etc.). The summary daily traffic seems to be below 10Mb. Other than that there are some Smart groups (100-200).

With this setup MySQL is sometimes running out of memory. Could it be wrong settings or 1Gb is just not enough?

I would say it's your smart groups causing the problem. They get recalculated a lot and this can use a lot of RAM.

Are you sure MySQL is running out of memory, rather than getting deadlocks? Deadlocks are also a problem that can occur when you are using a lot of smart groups.

I would recommend upgrading the RAM anyway, because it is bound to make everything smoother. 1GB is very small. You may find it fixes your problem instantly, and then the money is well spent. But if that doesn't help, or you get other MySQL-related problems, I would suggest trying to cut down on smart groups if you can.


How should I copy a site from production to staging? I think the procedures on migrating a site at https://wiki.civicrm.org/confluence/display/CRMDOC/Moving+an+Existing+Installation+to+a+New+Server+or+Location are out of date. They certainly don't reflect how we at JMA migrate sites from production to staging in 2016. For example, we don't create a fresh install of CiviCRM, and instead pull the source code from git and copy the dbs. We also use various techniques to prevent staging, dev and local test sites from sending out emails, which are not included the recipe.

So: what is a good recipe for migrating a production site to a staging instance?

Many of the steps documented on the "Migrating a site" wiki page are handled automatically now.  Here's my recipe, which is far from perfect, but is much closer.

Copy the entire filesystem to the staging server.  Git works well for this, but when it's not an option, we'll use SFTP or create a tarball.
Dump the database using mysqldump, either directly or using drush civicrm-sql-dump or wp-cli cv sql-dump.  Copy the db dump to the staging server.  We don't use git for this because of the database size; we either use drush sql-sync or copy it manually.
Assuming a manual database dump copy, we need to remove the trigger definers - unless the MySQL username is identical on both production and staging.  I use sed -i -e 's:/\*\!50017.*\*/::g'.
Load the database into MySQL on the staging server.

Assuming this is not the first time we set up the server, we're done!  On first time setup, there are a few other things we need to do:

Replace all the usernames, passwords, paths, etc. in settings.php, civicrm.settings.php, and/or wp-config.php with the values appropriate to the staging server.  If using git, these files are ignored in git, only local copies exist.
There are a number of values we override in civicrm.settings.php on the staging server to use the appropriate paths.  Here's what I put in mine, directly below the <?php marker:

.

global $civicrm_setting;
$civicrm_setting['CiviCRM Preferences']['allowPermDeleteFinancial'] = 1;
$civicrm_setting['Directory Preferences']['customTemplateDir'] = '/home/jon/local/example/wp-content/civicrm/templates';
$civicrm_setting['Directory Preferences']['customPHPPathDir'] = '/home/jon/local/example/wp-content/civicrm';
$civicrm_setting['Directory Preferences']['extensionsDir'] = '/home/jon/local/example/wp-content/civicrm/extensions';
$civicrm_setting['URL Preferences']['extensionsURL'] = 'http://example.local/civicrm/extensions/';
$civicrm_setting['URL Preferences']['imageUploadURL'] = 'http://example.local/wp-content/plugins/files/civicrm/persist/contribute/';
$civicrm_setting['URL Preferences']['userFrameworkResourceURL'] = 'http://example.local/wp-content/plugins/civicrm/civicrm';

In Wordpress, we also need to add a few overrides to wp-config.php.  Some of these may be overkill but:

define('WP_HOME','http://example.local');
define('WP_SITEURL','http://example.local');
define('RELOCATE',true);

Finally, if this is a multi-site Wordpress, we need to do a search and replace of the database for the URL.  We do this with wp-cli search-replace https://oldsite.com https://newsite.com but this tool also does the trick.


Contact individual Summary Print page Image not showing When in the contact individual summary page i have an image that i upload and it shows.  When i go to the action button and use print summary. On the print page the image does not show up.

I tried adding this to /sites/all/modules/civicrm/templates/CRM/Contact/Form/Taskprint.tpl

{if !empty($imageURL)}

{/if}

it does not load the image. does anyone know how to make the image load in the print summary page ?

I am using drupal and civicrm  4.6.16

EDIT

I still have not gotten this to work. I have try to add this to the Taskprint.tpl

Edit 2

Thank you so much. Print.tpl was the correct file and i was able to figure out my problem with the image now i was looking in the right place. I had to add this code to the summary.tpl for it to load.

              {crmRegion name="contact-basic-info-right"}
              {if !empty($imageURL)}

                  {include file="CRM/Contact/Page/ContactImage.tpl"}

              {/if}

              {/crmRegion}

Thanks

I don't think you're looking at the right template.  When I press Print Summary, that's not the template that loads.

You can check which template is in use by pressing "Ctrl-U" to View HTML Source, then searching for ".tpl".  When I do that, I see templates/CRM/Contact/Page/View/Print.tpl instead.

Above the {literal} tag, I added the {debug} tag and reloaded the page in my browser.  This brought up a Smarty debug window; I confirmed that $imageURL is indeed available to this template (otherwise we'd need to add it in the corresponding PHP file).

So hopefully this is enough info to get you where you need!  Update your question if not.


Upgrading from 4.6 to 5.5.3 - [Error: Remove Moneris] CiviCRM_API3_Exception: "Could not delete payment processor type" This is a Drupal 7+CiviCRM deployment. Trying to upgrade to 5.5.3 - we're getting this error that stops the upgrade script. Is there a database value I can edit to skip over this to proceed with the upgrade?

[Error: Remove Moneris]
CiviCRM_API3_Exception: "Could not delete payment processor type"

#0 X:\test\temp\sites\all\modules\civicrm\CRM\Upgrade\Incremental\Base.php(129): civicrm_api3("PaymentProcessorType", "delete", (Array:1))
#1 [internal function](): CRM_Upgrade_Incremental_Base::removePaymentProcessorType(Object(CRM_Queue_TaskContext), "Moneris")
#2 X:\test\temp\sites\all\modules\civicrm\CRM\Queue\Task.php(88): call_user_func_array((Array:2), (Array:2))
#3 X:\test\temp\sites\all\modules\civicrm\CRM\Queue\Runner.php(214): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
#4 X:\test\temp\sites\all\modules\civicrm\CRM\Queue\Page\AJAX.php(52): CRM_Queue_Runner->runNext(TRUE)
#5 X:\test\temp\sites\all\modules\civicrm\CRM\Queue\ErrorPolicy.php(106): CRM_Queue_Page_AJAX::{closure}()
#6 X:\test\temp\sites\all\modules\civicrm\CRM\Queue\Page\AJAX.php(54): CRM_Queue_ErrorPolicy->call(Object(Closure))
#7 [internal function](): CRM_Queue_Page_AJAX::runNext()
#8 X:\test\temp\sites\all\modules\civicrm\CRM\Core\Invoke.php(275): call_user_func((Array:2))
#9 X:\test\temp\sites\all\modules\civicrm\CRM\Core\Invoke.php(84): CRM_Core_Invoke::runItem((Array:13))
#10 X:\test\temp\sites\all\modules\civicrm\CRM\Core\Invoke.php(52): CRM_Core_Invoke::_invoke((Array:5))
#11 X:\test\temp\sites\all\modules\civicrm\drupal\civicrm.module(445): CRM_Core_Invoke::invoke((Array:5))
#12 [internal function](): civicrm_invoke("upgrade", "queue", "ajax", "runNext")
#13 X:\test\temp\includes\menu.inc(527): call_user_func_array("civicrm_invoke", (Array:4))
#14 X:\test\temp\index.php(21): menu_execute_active_handler()
#15 {main}

----- UPDATE -------

So we restarted the entire upgrade - manually deleted Moneris, and commented out line 193 as suggested by Jon G, but the script seems to stubbornly want to do its own thing. This is the error now:

[Error: Remove Moneris]
CiviCRM_API3_Exception: "Unexpected result from getcountArray ( [error_field] => payment_processor_type_id [error_code] => 2001 [entity] => PaymentProcessor [action] => get [is_error] => 1 [error_message] => 'Moneris' is not a valid option for field payment_processor_type_id ) "

0 X:\test\temp\sites\all\modules\civicrm\CRM\Upgrade\Incremental\Base.php(122): civicrm_api3("PaymentProcessor", "getcount", (Array:1))
1 [internal function](): CRM_Upgrade_Incremental_Base::removePaymentProcessorType(Object(CRM_Queue_TaskContext), "Moneris")
2 X:\test\temp\sites\all\modules\civicrm\CRM\Queue\Task.php(88): call_user_func_array((Array:2), (Array:2))
3 X:\test\temp\sites\all\modules\civicrm\CRM\Queue\Runner.php(214): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
4 X:\test\temp\sites\all\modules\civicrm\CRM\Queue\Page\AJAX.php(52): CRM_Queue_Runner->runNext(TRUE)
5 X:\test\temp\sites\all\modules\civicrm\CRM\Queue\ErrorPolicy.php(106): CRM_Queue_Page_AJAX::{closure}()
6 X:\test\temp\sites\all\modules\civicrm\CRM\Queue\Page\AJAX.php(54): CRM_Queue_ErrorPolicy->call(Object(Closure))
7 [internal function](): CRM_Queue_Page_AJAX::runNext()
8 X:\test\temp\sites\all\modules\civicrm\CRM\Core\Invoke.php(275): call_user_func((Array:2))
9 X:\test\temp\sites\all\modules\civicrm\CRM\Core\Invoke.php(84): CRM_Core_Invoke::runItem((Array:13))
10 X:\test\temp\sites\all\modules\civicrm\CRM\Core\Invoke.php(52): CRM_Core_Invoke::_invoke((Array:5))
11 X:\test\temp\sites\all\modules\civicrm\drupal\civicrm.module(445): CRM_Core_Invoke::invoke((Array:5))
12 [internal function](): civicrm_invoke("upgrade", "queue", "ajax", "runNext")
13 X:\test\temp\includes\menu.inc(527): call_user_func_array("civicrm_invoke", (Array:4))
14 X:\test\temp\index.php(21): menu_execute_active_handler()
15 {main}

This error relates to the fact that there used to be payment processor code in CiviCRM core to support the Moneris payment processor.  If you don't interact with Moneris, this is fairly safe to ignore.  However, I suspect the error may mean you use Moneris, in which case I would NOT follow the instructions below.

In your CiviCRM folder, find the file located at CRM/Upgrade/Incremental/php/FourSeven.php.
Delete line 193.  Confirm it matches the line 193 linked here.
Run the upgrade again.

Note that it's common to experience upgrade errors because you have a partially upgraded database - so be sure to restore the pre-upgrade database backup to minimize your upgrade pain.


Adding contribution_id or transaction_id to Receipt I've searched and can't find anything that works.

How do I add the Contribution ID and/or transaction_id to a receipt (Online and Offline)?

What I'm looking for is a way to easily find a contribution if a donor calls inquiring. I can ask them the contribution id and then search. Then I noticed that there's not a way to search by contribution id but there is by transaction id. However, transaction id isn't automatically created unless it's an online credit card donation. If I process a check or cash then it doesn't create a transaction id. Any suggestions on some options?

What do other's use on their receipts as the id?


Problems making resource URLs portable on CiviCRM I'm getting a warning for my Wordpress install of CiviCRM, under the title Resource URLs: Make them portable:

  Resource URLs may use absolute paths, relative paths, or variables.
  Absolute paths are more difficult to maintain. To maximize
  portability, consider using a variable in each URL (eg "[cms.root]" or
  "[civicrm.files]").

On the Resource URLs page it brings me to, I have the CiviCRM Resource URL as

http:// <path to Wordpress install> /wp-content/plugins/civicrm/civicrm

The others on this page which are populated are Image Uplaod URL

[civicrm.files]persist/contribute

and Extension Resource URL

[civicrm.files]/ext/

But when I try to change CiviCRM Resource URL to

[civicrm.root]/

which is the recommended portable value from the help button near the top, and then save it, the value is not saved, and reverts to the absolute URL above, and the warning persists.

I have installed CiviCRM 4.7.27 on Wordpress 4.9.1.

Starting in 4.7.26 in order to handle the multiple ways that WordPress can be installed on various hosts, we are determining the correct path and setting both the path to the site (front end) and the path to the backend (wp-admin) in civicrm.settings.php.

The resource url status warning will need to be updated to handle this.


unable to upload image file when creating a message This question was asked before, and marked answered at:
Unable to upload or view files through the CKEditor

but the adjustment recommended did not solve the problem for me.

After upgrading to CiviCRM 5.22.1, I am no longer able to upload image files when working on defining a mailing.
With previous versions of CiviCRM I could Upload an image using the dialog box Upload Tab that appears when clicking the image icon.

On the 1. Define Mailing tab on
,,, /wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fa%2F#/mailing/151
clicking the image icon opens a dialog box titled: Image Properties
It has 4 tabs: | Image Info |  Link | Upload | Advanced

Selecting the Upload Tab shows Choose File:

I can enter an image file to import.
But when I click the button "Send it to the Server"

I get a JavaScript popup alert that says: "incorrect server response"

Any suggestions?

This isn't fixing the root issue, but I tend to think the best practice here is to load media within the Wordpress Media Gallery and link to it in CiviMail. Content is best put in the CMS. That way, you can use the media for say a blog post and for CiviMail. It's more efficient.

I think some day being able for Civi to query the WP media gallery would be most desirable.


What is the best option to merge duplicated membership? We have some members using similar names to register a membership at different years.  What is the best way to merge their membership? Thank you.

I would suggest you start by reading the section in the User Guide on Deduping and merging contacts if you haven't done so already.
As to identifying the contacts that need to be merged, this really depends on what information you have on record. Finding contacts with duplicate email addresses is often a good place to start. Or look for duplicate postal addresses if you have that. If you only have names it will be a bit more tricky. You can use the 'length' in the dedupe rule to specify how many letters need to match. This may require trial and error to get this right for your data. Setting the 'length' too high may miss duplicates but setting it too low may generate too many duplicates.


Infusionsoft to CiviCRM data migration I am a digital marketing consultant and I have a non-profit client who is looking to migrate from Infusionsoft to Civi.  I am working with a certified implementation partner however she doesn't like doing data migration.  Her exact words were "it drives me to drink". This is also the first time I would be using CiviCRM myself.

I haven't found any reference to this online, except for one Ukranian company that says they do it: https://www.data2crm.com   - I assume no one has heard of these guys?

Can anyone offer suggestions or tips about the best way to implement the migration?

Just some numbers I pulled from Infusionosft:
18,878 Contacts
No Leads, Opportunities, Tasks, Notes, Attachments, Calls or Meetings because no one trained them how to use Infusionsoft properly in the first place
56,000 emails sent in the past 30 days with a 25% open rate.
They have 357 Action sets, 25 Tag Categories and 578 Tags.  What kind of fields would this kind of data migrate to in CiviCRM.

Thanks in advance.

if you want to find some support I am sure there are other CiviCRM partners that would be happy to assist with migration? I know we would if we have the time and if it makes sense :-)
As you might know the biggest pitfall in migration is to make the switch in thought patterns. When looking at source data you are in the thought pattern of the 'old' system and when you start looking for where the data should go in CiviCRM you remain in the 'old' thought pattern. Really you should know some of the basic processes in CiviCRM before you even start thinking about what fields the data should go to. My recommendation would be to start there, and not with 'what field should this go to'. That drives me to drink :-)


typo in packages/Net/SMTP.php I think there is a typo on line 692 of
wp-content/plugins/civicrm/civicrm/packages/Net/SMTP.php

mMethod should be method in the last line below, yes?

if (is_array($callback)) {
            if (!is_object($callback[0]) || !is_string($callback[1]))
                return PEAR::raiseError('Bad mMethod callback array');
        }

Should I fork the civicrm-packages repository, make the change there and submit a pull request?

Or is CiviCRM getting this code from elsewhere, and it would be more useful to make the change in the original source repo?

Yes you should fork the repo and create a pull request against the Master branch which i assume is the branch with the issue. Please see this documentation on contributing to CiviCRM https://wiki.civicrm.org/confluence/display/CRMDOC/Contributing+to+CiviCRM+using+GitHub


New Mailing Cannot "Review and Schedule" CiviCRM 4.7.23, Drupal 7.39
I can fill the first page of a new mailing ("Define Mailing") but the "Next" button and the "Review and Schedule" tab are unresponsive. The mailing is listed under Draft and Unscheduled Mailings.

I've had the trouble before and was able to change a setting the civicrm_mailing table, but have forgotten what I did and cannot make the edits necessary to trigger the "Next" button.

I have searched similar questions, but could not find the same issue. I apologize if this is a duplicate request for help.

After trial and error got it to work by modifying record in table: civicrm_mailing
1) Set Is_Completed to 1 and
2) Approval_Status_ID to 1


What is the largest number of customer records that civicrm supports? I am evaluating civiCRM to use as the CRM in the captive BPO setup of my non-profit.

Need to know how many customer records civiCRM can handle, in the database of my beneficiaries. Can it support a beneficiary base of 5 to 10 million? This would include case management for these members.

Regards,
Jayesh

See this question: Number of contacts vs. hosting space required

Here is a thorough answer to that question: https://civicrm.stackexchange.com/a/3289/105.

The short version: there is no formal limit to how many contacts CiviCRM can store.  It really comes down to the amount and type of hardware you have supporting the software.  For a record count of 5-10 million, you would definitely need powerful hardware.


How do I edit the contribution confirmation page How do I edit the contribution confirmation page? I need to change the text so that the instructions are consistent with the buttons

I think you could probably manage it with Adminster >> Customise Data and Screens >> Word Replacements if you chose a sufficiently long phrase to ensure it doesn't affect anything elsewhere.


List unassigned Inbound SMS activities I'm facing the same issue as spidersilk in this old question - Is there a way to add a custom field to the Inbound SMS activity type?. Trying to keep the one CiviCRM instance I support as "out of the box" as possible, so hoping for an answer that doesn't require custom status-es or CiviRules.

Is there an "out of the box" way to search for activities with a blank "Assigned To?" With that, I could just list activities of type "Inbound SMS" that have yet to be assigned. I realize assignment isn't the end, but it'll suffice. I had high hopes for the Search Builder but, to my surprise, Assigned To is not one of the fields exposed for Activity.

CiviCRM 5.21.0 on Drupal 7.69.

This might not meet your needs but it can be done from the Support menu under api4 explorer (but not api3). Choose activity - get, and then for the where clause pick assignees.id Is Null. Then click execute. Note on a stock install the screen will look weird but it functions.


/civicrm-stable/5.17.5/civicrm-5.17.5-l10n.tar.gz does not download I am trying to download version 5.17.5 via SourceForge.

civicrm-5.17.5-drupal.tar.gz downloads, but /civicrm-stable/5.17.5/civicrm-5.17.5-l10n.tar.gz does not.

Why not get it from https://civicrm.org/download that seems to work OK


CiviCRM CSS outside of CiviCRM We've got some CiviCRM status messages displayed outside of CiviCRM (Drupal pages), but they come as a default browser JS alerts, not as a fancy CiviCRM-styled status messages. We've    $manager->addCoreResources(); included via  hook_page_build(&$page); guess it's not enough though.

There is a documentation at https://wiki.civicrm.org/confluence/display/CRMDOC/Resource+Reference    which says:

If you are working outside of CiviCRM core or extensions (such as a Wordpress plugin), you can still use the Resource Manager but will need to construct the urls yourself

with addScriptFile, addScriptUrl, addStyleFile and addStyleUrl methods available; the question is, which exactly CSS files contains fancy pop-ups formatting?

Also, it's a bit unclear, how exactly css should be loaded? Normally, it should use addStyleFile / addStyleUrl, but an example given at documentation page states:
CRM_Core_Resources::singleton()->addScriptUrl('http://example.com/bar.css' (mean, use addScript to load CSS Style file) which is a bit confusing..

Thanks for any hint!

Wrong question was asked; fancy CiviCRM stuff works almost, if properly called via CiviCRM own jQuery methods; pretty strange  CRM.alert in Chrome pops up a default JS alert() message though, so it might be better to use  CRM.status with appropriate parameters

This page helps a lot: https://wiki.civicrm.org/confluence/display/CRMDOC/Notifications+and+Confirmations

Additional reading:

https://wiki.civicrm.org/confluence/display/CRMDOC43/Javascript+Reference
https://wiki.civicrm.org/confluence/display/CRMDOC43/Resource+Reference#ResourceReference-Javascript
https://wiki.civicrm.org/confluence/display/CRMDOC/Ajax+Pages+and+Forms#AjaxPagesandForms-CRM.refreshParent


Log all outbound email What solutions are people using to track all outbound email from CiviCRM?

BCCing would be one option - a BCC could be added to all outbound email via an extension, I suppose.

Else I'm guessing that some Third Party ESPs might also provide this functionality.

Interested to know what people are doing / if there are any solutions I haven't thought of.

In civicrm.settings.php there's some settings to log it all to a file. See https://docs.civicrm.org/dev/en/latest/tools/debugging/#changing-file-based-settings

define('CIVICRM_MAIL_LOG', '/file/path');
define('CIVICRM_MAIL_LOG_AND_SEND', 1);