How can I create a group of everyone who gave in honor of a specific person? I can see a list of everyone who gave in honor of a specific person by looking at that contact's Contributions tab (under Soft Credits).  However, I can't figure out how to put these folks into a group, or even generate a report on them to see their contact info.  How do I do this?

I wrote an extension Soft Credit Custom Fields which, amongst other things, adds a "Soft Creditee's Name" field to the Advanced Search.


Simple Donate Form Extension - what is path for front end - joomla This is with CiviCRM 4.6.8 on Joomla 3.4.3.

I successfully installed the Simple Donate Form Extension and it works from within CiviCRM Dashboard, ie, Admin menu settings, CiviContribute menu Test/Live. But, I am not able to make it live on the frontend of the website. I've created a new menu item with the Menu Item Type selected as CiviCRM => Contribution Page => Simple Donate Test to no avail. The default CiviCRM form continues to appear. There is little documentation on this other than just set it and forget it.

Please advise.

I believe you have to add: ?page=CiviCRM&q=civicrm/simple/#/donation to the end of your URL. That was how I got it to work for me, although I am using Wordpress.


how to "petition" show using do_shortcode in template file in wordpress? I want to show petition in page but using template file. Is it possible?

I have used below shortcode in template file but it not worked.

<?php echo do_shortcode('[civicrm component="petition" id="1" hijack="0"]');?>

Also I want to show another petition in popup but also there shortcode not working

See I want to default petition show in sidebar so i get default petition Id using custom query but i can't get petition with profile form using shortcode. Any other method to get petition using id. See below query for get default petition id.

$petition = civicrm_api3( 'Survey', 'getsingle', array(
            'sequential' => 1,
            'is_active' => 1,
            'is_public' => 1,
            'is_template' => 0,
            'options' => array(
                'limit' => 1,
                'sort' => 'id ASC',
                'offset' => CRM_Utils_Array::value( 'offset', $instance, 0 ),
            ),
            'is_default' => array( '1'),
        ) );

$petition_id= $petition['id']

Thanks In advance

As mentioned in chat.civicrm.org the do_shortcode does work in a single template (single.php for example) but not in a sidebar.

Two examples to get this going are https://github.com/aghstrategies/civicontribute-widget and https://github.com/agh1/civievent-widget


postsave stop database update User is adding a new email. Call to civicrm_pre detects a problem that requires that the update not happen. It hasn't actually happened by the time civicrm_post or post_save_civicrm_email is called. The update actually happens after post_save is called.

How do I abort the update?

While I suppose you could empty the $params array, it would be a bit clumsy.  Meanwhile you'll need a way to notify the user in context, so something form-specific would be helpful.

Instead of using hook_civicrm_pre, you might consider using hook_civicrm_validateForm().  You'd be able to run the same checks, but in case the value is no good, you could send the user back to fix it.


How can I change the label name of a field and it's data also? I'm attaching the file as it's easier to explain. I want to change the label of a field, and also the resulting data. Kind of like changing both the fields and it's display in Drupal.

Can I do this with a find and replace in PhpMy admin?

You can use Word Replacement to change eg Household Name via /civicrm/admin/options/wordreplacements?reset=1 but what you are needing to do may be better accomplished via another mechanism (see comment above)


Free memberships are not created after upgrading to 4.6 We just upgraded to 4.6, and are having an issue with our membership sign up contribution page. It is for a free membership, and the page says that it is working, but on the back-end, no membership is being created: just the contact record and Drupal account. Has anyone had a similar issue after upgrading, or have any idea what could be wrong?

I tried to replicate it on the demo site, and could not.

I had a similar problem with civicrm and wordpress but it is now solved by upgrading to 4.6.3


Expected one Contribution but found 25 I am importing contributions from my donors from a .csv file. I have tested the process using a simple .csv file with one row of data for a payment from a donor I have already added to contacts. The import was successful, matching the contribution to the donor. When I try to repeat this process using a spreadsheet with approximately 40 rows of data (including multiple contributions from some donors) all rows of the spreadsheet fail to import and have the error message 'Expected one Contribution but found 2'. I am using the email address to match to contact.

Any ideas what I am doing wrong?

Since Imran is on CiviCRM Spark, I had a quick look at the issue. I think it was caused by the field mapping, where the import was trying to import the "Contribution Status", but there wasn't a status for "paid out", causing the import to fail.

So I changed the import mapping to ignore the import status (since the file only completed contributions), and it seems to have resolved the issue.

ADD-ON: this also happens when you try import Contributions with status=completed (as opposed to Completed)!


How to create a Drupal rules condition that checks CiviCRM contact's Group or Tag or Subtype Using Drupal Workflow Rules with CiviCRM Entity to create a Drupal User after a new Civi contact is created.

Rule works fine if the only condition is that a new Drupal user can be created for the Civi contact.

I need to add an additional condition to limit the creation of the new Drupal user according to other criteria.  Examples might be group membership or a Civi tag or certain Civi contact subtypes.

here is the rule that is not working:

{ "rules_testnewcontact" : {
    "LABEL" : "TestNewContact",
    "PLUGIN" : "reaction rule",
    "OWNER" : "rules",
    "REQUIRES" : [ "civicrm", "rules" ],
    "ON" : { "civicrm_contact_create" : [] },
    "IF" : [
      { "civicrm_entity_user_exists_or_creatable" : { "civicrm_contact" : [ "civicrm_contact" ] } },
      { "NOT text_matches" : { "text" : [ "civicrm-contact:contact-sub-type" ], "match" : "Client" } }
    ],
    "DO" : [
      { "civicrm_entity_action_load_create_user" : {
          "USING" : {
            "civicrm_contact" : [ "civicrm_contact" ],
            "is_active" : "1",
            "notify" : "1"
          },
          "PROVIDE" : { "civicrm_user" : { "civicrm_user" : "Created or Loaded Drupal User" } }
        }
      }
    ]
  }
}

Well to answer this question, basically I had to write a couple of new Rules conditions.  They have been added to the CiviCRM Entity project, right now they are in the -dev version.

I added two new Conditions. CiviCRM Contact is of subtype, and CiviCRM Contact is in Group.

They both require a civicrm_contact object is loaded in the rule, which you get automatically if you are reacting to "CiviCRM Contact is created", or "CiviCRM Contact is updated" Rules events.

The "CiviCRM Contact is of subtype" rule allows you to select which contact subtype to check for.

The "CiviCRM Contact is in Group" rule allows you to select which group to check if the contact is in.

This functionality will be in the next stable version of CiviCRM Entity.

These conditions are used as any other Rules conditions are....

Here's a sample of a Rule that shows a message on the site if a contact with sub-type Student is updated:

{ "rules_show_message_if_contact_is_subtype_student" : {
    "LABEL" : "Show Message if contact is subtype student",
    "PLUGIN" : "reaction rule",
    "OWNER" : "rules",
    "REQUIRES" : [ "civicrm_entity", "rules", "civicrm" ],
    "ON" : { "civicrm_contact_edit" : [] },
    "IF" : [
      { "civicrm_entity_contact_is_subtype" : {
          "civicrm_contact" : [ "civicrm_contact" ],
          "contact_subtype" : "Student"
        }
      }
    ],
    "DO" : [
      { "drupal_message" : { "message" : "Contact of subtype student saved!" } }
    ]
  }
}


how to make charts and graphs in CiviCRM I was wondering if it is possible through in CiviCRM, WordPress to do charts or graphs. If so, how should I do it?

Thank you!

One approach would be to extend what CiviVisualise extension provides


What fields need to be on Gift Aid declaration form to avoid uncaught exception? We're running Wordpress 4.9.7, CiviCRM 5.2.2, and UK GiftAid extension 3.0.1 from compucorp.co.uk. The previous extension version had a single field ('UK Tax Payer?') to add to the donation form and worked OK. As of version 3 the donation form is throwing an uncaught exception indicating that additional fields need to be on the form. Including all 8 new gift aid fields does work, but ends up duplicating address fields and making the form rather unwieldy.

Is anyone else using the new Gift Aid extension successfully? How can the process be made as simple as possible when integrated with an existing donation form?

If you miss out required fields it should show you an user-freindly error, not throw an exception. It should also indicate what fields are required. So whether or not the required fields have been entered, this is a bug in the gift aid module.

You can raise it with the developers of the gift aid module. They have an active issues queue here https://github.com/compucorp/uk.co.compucorp.civicrm.giftaid/issues

Regarding scheduled jobs - did you get it working? If so, I recommend updating their documentation and issuing a pull request.


Creating Smart Groups based on multiple relationship types Our company is made up of 'societies' which we have added as organisations (we have around 370 societies). Each society has anything from 90-800 'members' which we have added as individuals and given the relationship type 'member' to the specific society they belong to.

Each society also has a committee of around 10-15 individuals, these committee members have the relationship type 'member' as well as a committee relationship type of 'society chairman' or 'society treasurer' or 'society events secretary' etc etc. There are around 30 of these committee relationship types.

What we are trying to create are 'committee smart groups'

I can create smart groups based on one relationship type, so:

Individual
with Relationship - 'Society Chairman'
with Target Contact - 'Example Society 1'

But this gives me one individual, what I want to search is:

Individual
with Relationship - 'Society Chairman' OR 'Society Treasurer' OR 'Society Events Secretary etc.
with Target Contact - 'Example Society 1'

I cannot however, seem to be able to select more than one relationship type at a time, meaning my smart group is only based on one relationship type. I can select multiple contact types or activity types, so wonder why relationship types do not have the same functionality. Does anyone have a solution to this?

Probably the easiest way is to create a smart group for each relationship type using advanced search as you've highlighted and then create a 'master' smart group which is anyone who belongs to either child smart group.

The other option would have been to use search builder but at present (v4.6.9) relationships aren't supported yet.


Why am I getting "Invalid currency selection: USD for domain iatspayments.com" on submitting a paid event registration? Using 1.5.3 CiviCRM 4.6.26 on D7. I get the following error: "Invalid currency selection: USD for domain iatspayments.com" when I submit an event registration.

I believe I have the correct server url in NA for credit card payments: https://iatspayments.com/NetGate/ProcessLinkv2.asmx?WSDL

My event page is configured for USD($)

Okay. Fixed. I guess this is pretty simple. Needs the domain prefix "www" in the URL for the "Site URL" (in the Payment Processor Settings) or it won't resolve. Not sure why it throws the odd error description. But, hey, it's working now.


Is CiviCRM a 'master database' / 'master system'? The membership organisation I work for currently has serious issues with it's membership databases. That information is currently split between a wordpress user database with an extension s2pro which extends that, mailchimp, paypal, and an accounts package KashFlow.

Those all have various relations with each other but somehow seem to conflict and don't work properly - resulting in the system unsubscribing people from mailchimp, and various other problems with data not matching up.

My manager thinks that what we need to sort this out is a new 'master database' for the membership information which would communicate directly with all the other software packages and be an authoritative place for the data, rather than them all talking to each other and conflicting.

I'm wondering, would CiviCRM be able to serve as that master system?
Thanks.

Yes, CiviCRM would be a great match for what you're describing. CiviCRM is a central 'master' information hub that has quite a bit of reach out of the box:

membership data (What Is CiviMember? and the following sections are a good start)
mass emails (which can be integrated with MailChimp via an
extension)
Paypal integration for membership payments, donations and
event sign ups (using Paypal Standard or Pro)
integration into your Wordpress CMS with tiered permissions determining who can see/do what

Using KashFlow for accounting, there may be a little bit of custom work involved for you (or a developer) to customize the CiviCRM CSV export for accounting information (looks like Kashflow has a good bit of CSV instructions on what is needed for their system; without diving into the particulars, hard to say if custom work would be needed).  The default CSV accounting batch export from CiviCRM has a large number of fields: it would be a matter of making sure your Kashflow-needed fields are in that export and potentially removing the unneeded ones.

Personal testimony: prior to using CiviCRM, our organization had a separate contact management system for each department, and none of the systems talked with each other (and manual comparisons between them often resulted in conflicting information).  We have benefited 100x fold from the time and energy put into learning and customizing CiviCRM.  We have one central place, integrated with our website, that keeps all our information current and accessible for staff. I'm so glad we made the choice to introduce CiviCRM into our administrative process.


How do I create and access a database for civiCRM I am trying to install CiviCRM in WordPress to see if the small NGO I work with might be able to use it. I got a domain name and installed WordPress through BlueHost.com and turned on the CiviCRM plugin. It says the following problems exist, and they all appear to have to do with a database. I don't have any experience with software/programming/IT.
It appears I need to give access to CiviCRM to do stuff, but I have no idea how to do that.

I would really appreciate your help!! Thank-you very much!!

Sharone

CiviCRM Database Details

Does the server exist?
OK (localhost)
Are the access credentials correct?
That username/password doesn't work:
Can I access/create the database?
I can't create new databases and the database 'civicrm' doesn't exist. (user 'civicrm' doesn't have CREATE DATABASE permissions.)
Can I access/create InnoDB tables in the database?
Unable to create InnoDB tables. MySQL InnoDB support is required for CiviCRM but is either not available or not enabled in this MySQL database server. Could not determine if MySQL has InnoDB support. Assuming no.
Can I create temporary tables in the database?
Could not login to the database.
Can I create lock tables in the database?
Could not connect to the database server.
Can I create triggers in the database?
Could not login to the database.

For testing purpose, it could have been nice to install it locally using a virtual box for example following this documentation: http://wiki.civicrm.org/confluence/display/CRMDOC/WordPress+Installation+Guide+for+CiviCRM+4.5.

But since you have stated that you have no experience in software/programming/IT, your best bet will be CiviCRM hosting providers: https://civicrm.org/providers/hosting


Contact Us form based on smart group list I am getting started with Webforms on Drupal and am looking to create a Contact Us form.
I would like a single form that would allow the user to select the Send To field based on a Smart Group. The group has a list of committee members based on a range of Membership IDs.
A drop down or single selection list is what I would like the user to select from as one of the elements of the form.
Any help or suggestions would be appreciated.

You could try enabling 'Groups' on the Civi processing tab set to user select and then limit the options of groups on the Webform tab in the configuratation for the group component. Once that's done you can set the email to 'Value of "Group(s)'.


CiviMail Images always appear broken on screen after uploading correctly I have been working with CiviMail to upload images directly to the mailing templates from the KC finder image upload. I am successfully able to upload an image via KC finder which looks good when I upload it. However, once I click away to add the image to the template it shows a big red x instead of the actual image. I understand that it might be a permissions issues but I have tried different options for the issue and it does not work. This CiviCRM is on a Windows 2012 server with IIS 8.5 and PHP 5.6.20. I have tried a number of options from not naming the images with dashes to permissions of the server.

If your images are being stored in a directory that prohibits direct access, it will give you that symptom. There's a .htaccess file that performs this function for apache, I'm not sure how that works with MS servers.

Your best bet is to try loading the image directly (e.g. right click on the broken image and load the image in a new tab) and see what the path/url is, and look in your server logs, it should tell you why that image is not being loaded, i.e. either whether it is a permission or just a not-found issue.


Database Schema check/fix I am getting random errors when I first log into Civicrm on Wordpress.  It seems to be related to the check of existing indexes versus required indexes.

Warning: Invalid argument supplied for foreach() in /home/sporti62/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/SchemaHandler.php on line 750

Is there a tool where I can have the indexes checked and possibly rebuilt?

Norm

If there are indices problem, you can get false indices displayed on Administer -> Administration Console -> System Status page.

It will list the wrong indices in your table with the Update Indices button to rebuild them.

The above button tries to delete the listed false indices and recreate them in the correct order. If for some reason the Update Indices is unable to clear the message, you can manually delete the indices from the Table Name shown in the above screen and then create them using the same button.

Note that you can only see this message and button if your civi version is <= 4.7.29. From 4.7.30, this message is hidden via CRM-21298.

So, on version >= 4.7.30, as this UI is not present, you can try rebuilding them using the api via API explorer from Support -> Developer -> API Explorer with

Entity = System and Action = updateindexes (present on all versions).


Is it possible to limit membership renewals to next membership term? While testing payment integration with membership renewals, I observed that the membership end date may extend to any point in the future by just purchasing more and more renewals. Any limit set to activityDate (under the config menu "Date Preferences") does not have an effect, since no selection of the specific end date happens during renewal. In my case, just 12 months are added on top of any pre-existing end date.

Is it possible to limit a membership renewal to just the membership period beyond the current one or at least to a maximum new end date?

edit: using CiviCRM 7.11.0 and Wordpress 5.1

I think this would require an extension that would add a field to membership types and membership for 'max terms' and then the code/logic would prevent folk purchasing beyond the current cycle


Filing activities on closed cases In Civi 4.6, when you filed/moved and activity to a case, you could choose a closed case from the list. In fact, there was a conditional to show closed cases with a strikethrough. In 4.7, when everything was moving to EntityRef that little piece was removed and all references to "file on case" assumes the case is open.

While I've been able to track down some lines I could comment out (in the parameters of the addEntityRef) to allow closed cases to populate the list again - that means a custom PHP file. I guess I was wondering if it is predominant that people only file on open cases? The behavior feels strange that you wouldn't want to be able to include (or have an option to on the form itself) closed cases.

Does anyone else file on closed cases and have a different workaround?

UPDATE: Can do this with an extension using hook_civicrm_alterEntityRefParams. It also magically adds a Case Status filter in the "refine search" dropdown that appears when you start typing a name. See https://lab.civicrm.org/dev/core/-/issues/2209#note_51075 and https://github.com/AsylumSeekersCentre/civicrm-moveActivityToAnyCase

While I'd vote to bring the ability to file on a closed case back, or maybe make it a configuration option to allow or not, one workaround is to use the email processor and put the case id in square brackets in the subject (https://issues.civicrm.org/jira/browse/CRM-21446). It will happily file it on a closed case. Information about setting up the email processor is here https://docs.civicrm.org/sysadmin/en/latest/setup/civimail/inbound/#autofiling-email-activities-via-emailprocessor
And if you edit an activity and add the case id in square brackets to the subject and then save, it will file on case, e.g. "this is the subject [case #1234]"
According to the issue you linked, https://issues.civicrm.org/jira/browse/CRM-17645 you should be able to use a hook_civicrm_entityGet in an extension to alter the query, but I'm not sure from those notes that it actually got implemented.


Dashlets not available to be added to Dashboard 2 roles in Drupal, 2 groups in CiviCRM, 2 roles in CiviCRM

administrators
members of the board

permissions in Drupal

administrators: all permissions
members of the board: all, except some (see list at the end)

Administrator created some contact reports - in fact status reports on new contacts and open activities (tasks to do) - and defined them as dashlets. They can be added on the dashboard of administrator, but do not appear to be added an the dashboard of the members of the board.

Also, the members do not see the entry "Contact Reports" in the drop down menu "CiviReport", although they can see them when selecting "show all reports".

Which ACL do I need to add in CiviCRM "Manage ACL's", so that the board members can see and add the dashlets?

=== === ===

Members of the board do not have a Drupal permission for:

import contacts
remove contacts
import SQL datasource
manage CiviCRM
IDS control bypass
translate CiviCRM
manage dedupe rules
join double contacts
force joining doble contacts
show debug output
use Ajax-API
create manual batch
edit own manual batch
show own manual batch
show all manual batches
manage payment methods
edit own API-keys

CiviEvent

remove event
manage event profiles

CiviContribute

CiviMember

remove in CiviMember

CiviMail

remove mailing

CiviReport

show report SQL

If I recall correctly, this is down to some peculiarity of the dashlet permissions.  If you go to the Access tab of the report in question, you'll see two ways to set the permissions (see screenshot below).  However, I believe only the "permission" setting will control access to the dashlet.  Try setting both the Role ("Board Member") and the permission (to any permission the board members have) and you should be good to go.


Duplicate users being created by... something! I have been trying to unpick a mystery now for a week without success! I wonder if anyone can help.
We have two contacts (out of a database of c 7,500) where we're seeing some odd behaviour.
As an example - let's call him John Doe.
John Doe has a contact record, linked to a Wordpress user account. He has registered for an event recently (may or may not be relevant). His record has a linked current employer, job title, and address.
Every day at 12:13pm or 12:14pm, a duplicate John Doe account appears in CiviCRM, according to the change log created by John Doe,  with matching:

Name
Email

But without

Linked Wordpress account
Job Title
Current Employer

I am at a loss to explain why.  Things I have tried:

Disabling the Capitalisation Correction Extension
Disabling CiviRules
Examining the scheduled jobs log

Cron runs every five minutes. The Scheduled Jobs log shows that between 12:10 and 12:15pm each day, there are no scheduled jobs running:

2020-02-20 12:10:02 Finishing scheduled jobs execution.
2020-02-20 12:15:05 Starting scheduled jobs execution

There are no scheduled jobs which uniquely run at 12:10pm.
For each contact, there is only one item in the change log:

I'd be extremely grateful for any advice on investigating this further as I am now drawing a blank (and I have 36 John Does in the database!)
We are currently on 5.13.4 (security upgrade imminent)

This was resolved by removing the user's current employer, saving the record, and then re-adding the current employer.  Seems potentially to have been some problem around the cascading membership?


How can I assign an External Identifier to each set in a multi-record import? I'm importing education history for each Individual Contact, which can have from 0 to 5+ sets of multi-records.  Each set of multi-records comprises [institution], [degree level], [degree name], and [grad year].

The level, name, and year are custom fields that show up in the multi-import wizard.  The institutions are already imported as Organization Contacts with their own external IDs, and I have a relationship set up between individuals and educational orgs (much in the same way as employees would be related to employers).

However I don't see a way in the multi-record import wizard to relate a set of education multi records with the corresponding institution's External ID. Is there a way to do this in the wizard?

If not, is there a way to do it directly in MySQL?  (Though I hesitate to muck with the guts, since last time I changed some seemingly innocuous data, the site got corrupted.)

With hundreds of records to import and limited manpower, a manual process is likely not feasible.

We are upgrading from CiviCRM 4.6 to 4.7.17.  The Eternal ID is now available for matching to contact records for importing multi-record custom data sets.  I just completed a test and the import worked fine and matched using the External ID.


Is There A Way to Aggregate PDF Letters the Way Labels are Aggregated When you create labels you can aggregate them by address.  I want to be able to do this for PDF letters as well so that they match the labels.  I have looked all over and do not see another way to do this.

Thanks,
Steve

We came to the conclusion that this is not possible and that is because of the tokens that would be needed for the letters once they were aggregated.


No templates available for new event and new event template After installation (Joomla 3.4.8, and civiCRM 4.6.11) , "New event" and "New event template" do not allow entering data as well as they seem not to be able to find the right template.

It looks like stylesheets aren't loading, so perhaps other resources (like Javascript) aren't either. Double check that the URLs set up in the CiviCRM Resource URLs page match (Administer > System Settings > Resource URLs).


Contribution receipt not being sent after paying with Paypal Using Joomla and CiviCRM 4.6.10, a receipt is not being sent when using the Paypal option on our Contribution page but is being sent when using the Pay later option. The Paypal payment is being accepted and processed and the contribution is being recorded but a receipt is not being sent. I have enabled the Instant Payment Notification and Auto Return in Paypal. I am assuming this problem is related to the IPN but I do not know enough to figure out where the problem is.

Check the logs at /media/civicrm/ConfigAndLog shortly after a payment has been made but no confirmation sent.

You should see the payment Mar 15 19:13:18 [info] Contribution record updated successfully

Then you should see the contribution receipt. There may be an issue here e.g.

Mar 15 19:13:18 [info] $Fatal Error Details = Array ( [message] => The requested Profile (gid=XXXXX) is disabled OR it is not configured to be used for 'Profile' listings in its Settings OR there is no Profile with that ID OR you do not have permission to access this profile. Please contact the site administrator if you need assistance. [code] => )

If you see something like the above, the issue is that Civi cannot access the information that was entered in the profile.


Custom data fields not showing on event registration page I setup a custom field to be used for Participant (Event Name) and it only shows when I choose to manually register someone, it DOES NOT show on the event registration page, is there a setting I'm missing somewhere?

You will need to add it to whatever profile your using for the event registration page. You can check what profiles your using by going to the online registration tab of event configuration. Once you know which one then go to administration -> custom data and screens -> profiles and edit the fields for the particular profile.

The other thing you will need to make sure is that if your wanting anonymous users to submit the form they have access to the custom data. This can be done via 1. CiviCRM's permissions granting them access to all custom data or by adding in a rule into Civicrm's acl permissions that everyone can edit that custom data.

Seamus


Advanced Search returns no results for a valid contact id I tried to use Advanced Search and specified a contact id which I know is in the database. There are no other filters  yet I get no results.

No matches found for:
Contact ID = 54862

Suggestions:
check your spelling
try a different spelling or use fewer letters
if you are searching within a Group or for Tagged contacts, try 'any group' or 'any tag'
add a New Individual, Organization or Household
make sure you have enough privileges in the access control system

It turns out the contact had been deleted and was in the trash.


New to CiviCRM: Hosting (VPS) requirements and migration from NationBuilder this is my first question to the forum, hope you can help me. My org wants to migrate from NationBuilder to CiviCRM. We currently have a shared hosting solution with GreenGeeks, so:

Question 1: with about 6,000 members, contributors... and sending about 50,000 mails a month, do you think a hosting solution like the 1GB option here would be good for a CiviCRM + Wordpress installation? https://www.greengeeks.com/vps-hosting/

Question 2: we'd like to migrate from NationBuilder to CiviCRM. Do you know of any guide/tutorial for this specific case?

Thanks!

Q2 JMA Consulting and Fuzion recently migrated a large db from NB to CiviCRM + Drupal. JMA built the migration mapping. Fuzion worked on a Drupal-side interface that replicated some of the common NB screens (so not relevant for WP sites). You may want to get in touch with JMA via the Partners list concerning the migration side of things.

NOTE: If this is seen as too 'advertorial' then pls down vote it and I will happily remove it.


How do I configure printing to format properly? We have a WordPress install that has never had the report printing formatted properly.  A report list does not have columns and rows with lines around cells.  Attached is an example from my system and one from the CiviCRM demo WordPress site.

What do we need to do to get properly formatted reports.

This is a known bug that is fixed in 4.6.11--I discovered it on a client's site.  Basically, if your report doesn't have the header explicitly saved in the report settings, the header is blank rather than the default.  The default header contains the CSS to make your report look like it should.

The simplest solution is to upgrade, or you can apply the diff.

Finally, a rough option is to edit the header and footer manually.  Your header should be:

    <title>CiviCRM Report</title>
    <meta http-equiv='Content-Type' content='text/html; charset=utf-8' />

and the footer should be

You'll need to paste this in for each report, so it's more efficient to just upgrade, but if you're in a pinch trying to get the report out right away, this will help.


Is there any way to import files into a custom field for uploaded files? Is there any way through SQL commands, to import files into a custom field? E.g. photos of contacts?

You asked about SQL, but it is generally recommended to use the API rather than direct SQL. See the Attachment API - examples in the Code Docs section of API Explorer.


Why can users no longer update their own billing/credit card details in CiviCRM? Using iATS Payments Payment processor objects can implement the CiviCRM Core method updateSubscriptionBillingInfo to implement payment-processor specific code to update card-on-file type information with the payment processor service, for recurring payments.

iATS Payments Extension did/does just that and thus allowed people to update their own billing/credit card details for recurring contributions. Why is this no longer working?

If you have been using this feature you may have noticed this is no longer working in higher 5.x versions of CiviCRM. This regression can be fixed with this solution (PR) which was posted here: https://github.com/civicrm/civicrm-core/pull/12668 - unfortunately it was closed. If this feature is important to you - all you need is to add one-line of code (highlighted in green) to this file: CRM/Contribute/Form/UpdateBilling.php

UPDATE: As a work around, there's now a patch to the iATS extension which will ship with the next release. It's not a great solution, but easier for most people than patching core


Install error when generating a new extension module I'm trying to generate a new extension module following instructions from the docs: https://docs.civicrm.org/dev/en/latest/extensions/civix/#generate-module
However, when I run the proposed command to generate the skeletal extension

$ civix generate:module "com.example.myextension" --license=AGPL-3.0

I get the following:

Initalize module com.example.myextension
Write com.example.myextension/info.xml
Write com.example.myextension/myextension.php
Write com.example.myextension/myextension.civix.php
Write com.example.myextension/LICENSE.txt
Write com.example.myextension/README.md
Write com.example.myextension/images/screenshot.png

Refresh extension list for "http://localhost/compucorp/"
Enable extension (com.example.myextension) in "http://localhost/compucorp/"? [Y/n] Y
Enable extension (com.example.myextension) in "http://localhost/compucorp/"
Install error: Unknown extension: com.example.myextension

The extensions directory is created on the root of the CMS (Drupal), and the new extension directory com.example.myextension is created successfully and seems to have right permissions.
What can be the problem?

I tried refreshing extensions list from the user interface of CiviCRM and the newly created extension does not appear on the list.

Thanks!

Check the Extensions Directory specified at Administer > System Settings > Directories.  Your extension needs to be in that directory.  If not, either move your code or change the setting.


Where can I see what's fixed in 4.6.15? The announcement of release 4.6.15 (and previous updates) on the CiviCRM website blog is very 4.7 centric. There's no link to what fixes have been incorporated into the 4.6 update - and as 4.6 is an LTS release many will be wanting to stick with it.  Or have I missed it?  If someone can send me a link here that would be great.  Suggestion: improve the announcement to have a link to the fixes.

Agreed on your suggestion -- the notification post usually does have a link to the fixes.  Here are the issues with a fixed version of 4.6.15:

CiviCRM issues fixed and closed for 4.6.15


after i use api to update the database results not immediately showing I'm running into an issue with the api. I use the following call to write to the relationships datatable

$result = civicrm_api3('Relationship', 'create', array(
    'sequential' => 1,
    'contact_id_a' => $contact_a_id,
    'contact_id_b' => $contact_b_id,
    'relationship_type_id' => 11,//your specific relationship id
));

from my solution in https://civicrm.stackexchange.com/a/4619/765

However, when I then go to the relationship tab the new entry is not immediately visible. I usually have to force a refresh by changing the relationships per page from 10 to 25 and then the new entry appears. How can I bypass/avoid this problem?

Thanks,
V

Sounds like you have to 'force' the summary page to rebuild. You can do this by re-building your userContext (which will be the summary page):

$session = CRM_Core_Session::singleton;
CRM_Utils_System::redirect($session->readUserContext());


How to add logo to Contributions - Receipt (on-line) I am using Civi 4.7.29 on Wordpress 4.9.1

I need to make our online receipts look nicer.  I tried adding a table to the template Contributions - Receipt (on-line) and adding the HTML for the logo image, but nothing changed in the test.  How do I add the logo to the receipts and do other styling?

Thank you.

Added Screenshot

This issue has been resolved.  I am almost too embarrassed to tell you what the problem was.

All this time, I was working on the Contributions Receipts, but doing my tests on a Membership page.  As soon as I noticed there was also a Membership receipt it all came clear. So, if anyone else ever runs into this issue, remember if it's a contribution but not a membership, it uses the Contribution Receipt.  If it's a membership it uses the membership receipt.

Thank you everyone for trying to help me figure this one out.  You did open my eyes to a lot of possibilities.


Can I chain API calls through drush? API chaining works well in Javascript and PHP. For example, I can retrieve a contact's email addresses using this code generated by the API Explorer:

Php

$result = civicrm_api3('Contact', 'getsingle', array(
  'sequential' => 1,
  'return' => "display_name",
  'id' => 41194,
  'api.Email.get' => array('return' => "email"),
));

Javascript

CRM.api3('Contact', 'getsingle', {
  "sequential": 1,
  "return": "display_name",
  "id": 41194,
  "api.Email.get": {"return":"email"}
}).done(function(result) {
  // do something
});

However, the drush command generated by the API explorer doesn't work:

drush cvapi Contact.getsingle sequential=1 return="display_name" id=41194 api.Email.get={"return":"email"}
# Gives me the contact just fine, but no email

Is there any way to coax drush cvapi into processing chained api calls? If it's not currently possible, is anybody working on it?

In the meantime, how can I help to correct the API Explorer so it doesn't produce non-working drush commands?

Drush can read parameters from standard input in JSON format if you supply the argument --in=json. This is what we need for API chaining, because chaining uses nested parameters, and in contrast to a flat list of command line arguments (the default way to pass parameters to drush cvapi, JSON can handle nesting. So to retrieve the email addresses for contact ID 41194 along with that contact's display name, use:

echo '{
  "sequential": 1,
  "return": "display_name",
  "id": 41194,
  "api.Email.get": {"return":"email"}
}' | drush cvapi Contact.getsingle --in=json


CiviEvent: how to collect different custom data for different event participant roles? My requirement: collect different custom data for different participant roles registering for the same event.

I know this would be simple with Drupal/Webforms but I'm on Joomla -- and this seems to be very difficult without the Webform integration!

This extension (Event Registration Based on Participant Roles) works great to provide the participant role I want to use to my registration form.  However, I can't figure out how to switch to a different custom profile in the registration form based on the participant role.

I've tried using the buildForm hook to add in the specific custom fields I need based on the current participant role, but it seems that buildForm hook does not allow me to REMOVE custom fields that I DON'T want to appear on the form for specific roles. I can only add fields to the array of fields that are already included from the profile selected on the "Online Registration" configuration.

I thought about just using Jquery to hide the fields I don't need from whichever role is currently selected, but that causes validation problems -- and I don't want to have to rewrite validation rules for every participant role context!

I just can't believe this is this difficult, and think I must be missing something obvious.  Or do I really need to hand-code a new, completely standalone registration form for each participant role?

Thanks in advance for your suggestions :-)

if you setup your custom fields in profiles only for the roles that are needed then does it not automatically only display those fields that are relevant? p.s. we wrote and maintain the extension that your referring to!


How to make backup joomla CiviCRM smaller? I made a backup of my httpdocs directory (a very small Joomla and CiviCRM extension) and discovered the backup contained more than 15000 different files? Is this normal? can I skip some of these from the backup?.

Thank you
Rob

One great way to shrink the backup is to only backup the bespoke bits (e.g. custom extensions and themes) and the database, not the actual Joomla! and CiviCRM code files that are freely downloaded from elsewhere.

This depends on you not having edited any core files, which your developers shouldn't be doing anyway.


CiviMail shows empty recipient list CiviCRM 4.7.24 on Drupal

Since updating to 4.7.24, no groups appear in the recipient list

I'm not sure this was a real problem. I cleared all Drupal caches and then it worked.


Civimail Plain text unwanted  tags I get an unwanted pair of paragraph tags at the top and bottom of my plain text messages. Any ideas how to get rid of this?

John
Civi 4.6.10
Drupal 7.41

I figured it out. I had a "blank" header and footer selected by default. When I removed them... problem solved.


civiCase emails don't use case tokens?? Print/merge does? What am I doing wrong? I have templates that use a range of tokens from the contact and the case, including standard case tokens and custom fields.  i.e.

{contact.display_name}   {case.id}   {case.subject}   {case.custom_154}

The case tokens are not processed when sending an email (via email activity)

They are processed on print/merge document.  (via print/merge document activity)

Is this by design?

When sending email via email activity only contact tokens are supported. If you have Civicase token extension installed and enabled than you can pass caseid=34 (where 34 is case id) in activity email url

eg http://example.org/civicrm/activity/email/add?atype=3&action=add&reset=1&context=standalone&caseid=34


Using the Event Name Badge feature A client of ours wants to have badges that have 2 fields on one line and would also like to have the state be the full name vs the abbreviation.  I'm pretty certain it would require custom code but posting here to be sure I haven't overlooked anything.

We are using 4.6.4 with this client.  And Drupal latest.

As of Civi 4.4, you can configure label formats as shown here: http://book.civicrm.org/user/current/events/event-badges/

But yes, this means each field needs to be on a separate line.

In terms of having the full name for the state, Name and Mailing labels show the state/province name as the abbreviation rather than the full state/province name. This has been reported on v4.5.2, but may need patching until it is fixed in v4.8:
https://issues.civicrm.org/jira/browse/CRM-15505

If you want to patch it yourself for now, here's what I do.
In CRM/Contact/BAO/Query.php, line 5533 (or thereabouts) is as follows:

    $dao->$value['pseudoField'] = $dao->$key = CRM_Core_PseudoConstant::stateProvinceAbbreviation($val);

Change this line to:

    $dao->$value['pseudoField'] = $dao->$key = CRM_Core_PseudoConstant::stateProvince($val);


Automatic mail after user registration (voucher) not the civi-guru, but with some basic knowledge ;-).
I would like to send an automated mail when a new user registers.

I have created a profile for that, see http://www.centcom.net/civicrm/index.php,

in the advanced settings, there is  an option for sending a mail after registration, but i would need to send a email template, which i have created in Administration/CiviMail/Templates.

Any idea how to accomplish this? Via Administration/System/planned Jobs?

Thank you,

Gerald
Modify message

If you can't do this through civi native, take a look at CiviCoop's CiviRules extension.


Setting up API access for WordPress installation I'm using civicrm's API to pull country and state data from CiviCRM into a Gravity Forms address pull-down list.  The current webhooks between Gravity Forms and CiviCRM are failing because Gravity Forms uses a text box for state field, which is unstructured and does not match CiviCRM data.

I see setup for the api gives the option to either check permission or not.  Any reason to check permissions for data for public access?

Checking permissions is important if you want the API to respect the access rights you have given to users? If in your setting and requirement it is not important that you can protect the country and state data you could skip the permission check. Are you using the API on the same server or with REST?


Will all contacts be delieted with an uninstall? I have 1.3 million contacts in CiviCRM 4.6.34, but the contacts are outdated. I want to remove all the contacts completely, but cannot find an easy way to bulk delete all the contacts.
I also want to upgrade to the latest CiviCRM version because 4.6.34 does not support CiviMobile...
Which means I also have to updgrade Joomla from 2.5 to 3.x, which means I also need a new template compatible with 3.x.
Anyway, we don't need the 1.3 million contacts currently housed in CiviCRM.
We have an updated list of voters (also about 1.3 million) which we will do as a clean import into the newest CiviCRM version on the latest Joomla.
I think this makes more sense than overwriting 1.3 million contacts with 1.3 million contacts.
Also, we may very well have to pay to migrate our site from Joomla 2.5 to 3.x, and if we have to migrate 1.3 million contacts, it will probably be a rather expensive migration, moreso than if remove the contacts pre-migration.
Since we are upgrading everything and need to install a newer version of CiviCRM anyway, will all the contacts be permanently deleted when CiviCRM 4.6.34 is uninstalled?
If so, I think that would solve everything. If not, what is the best and cleanest way to eliminate all the contacts?
Very little has been done with the contacts since they were uploaded anyway, so I don't believe there are really many (or any) tables to which they are copied on. They are uploaded as part of a 'group,' but otherwise there has been hardly any extra data added in after the fact.
Thanks for the help.

welcome to CiviCRM Stack Exchange. As you probably gathered from the comments from @Demerit and @petednz, if you start from scratch with a new version and "just" uninstall and remove the previous version the contacts will disappear from CiviCRM.

It is hard to judge if they will disappear from your website without knowing your website. I do not know if for any reason users were stored in Joomla or other contact data, but you will certainly lose all the CiviCRM data.

The safest option would be to start from scratch, so get a different spot to install your new Joomla and CiviCRM. Then you could just remove your old folders and databases from your webserver once you are happy with the new situation?

Good luck!


Adding expired/grace membership numbers to the Membership Dashboard I am looking at add a column for expired/grace members to the Membership Dashboard, but I am running into a roadblock on how to do it.

I know that the DashBoard.tpl file pulls in list of new and renewed members and that DashBoard.php also needs to modified. Dashboard.php refers to CRM_Member_BAO_Membership, which comes from CRM/Member/BAO/Membership.php. There are three functions in Membership.php, getMembershipJoins, getMembershipRenewals and getMembershipStarts that pull numbers from the SQL side.

My problems:
1. In Membership.php there is this function:
 public static function _getActTypes() {
which very helpfully has this as a code comment:
   * @todo document me - I seem a bit out of date....

These functions call things from the CRM_Utils_Array, which I cannot find. Which file is that in? I am not a PHP programmer, but is this a general function call that is extended by several files?

Does CRM_Utils_Array::key('Membership Grace', $activityTypes); or CRM_Utils_Array::key('Membership Expired', $activityTypes); exist?
If it doesn't, would I add such a function to Membership.php and then call it through the previously mentioned files?

In my experience, the Membership Dashboard isn't really a great tool, and I was it was deprecated.  It's extremely inflexible (as you're seeing here) and any reports you need can be placed on the main dashboard as a dashlet.  So I would recommend a different approach.

To answer some of your other questions - class names and file locations map to each other.  You should find the CRM_Utils_Array class in <civiroot>/CRM/Utils/Array.php.

Finally, it's a bad idea to change core CiviCRM files, because they'll be overwritten on upgrade.


Ordering Contact Reports Is it possible to set a specific order for all contact reports?  Can they be grouped underneath certain headings making them easier to find?  If so, how can I do this?

If you mean to order it on Contact Report section on the Report Page - Not yet from UI(need to write custom), they are actually ordered based on its id.

You can anyway move each report to the navigation menu(Access tab of each Report) and then order it according to your needs from Administer -> Customize Data and Screens -> Navigation Menu.


Query string state/province field On a profile listing page, you can query string to pre-select the field. e.g. add &state_province-Primary=NN where NN is the ID in the civicrm_state_province table.
However, on a profile create page, specifically on a contribution page, this does not work.
How can we make this work?

Since you have the jQuery tag, I assume you're open to a jQuery solution.

This StackOverflow question covers pulling a variable from a URL argument.
Then it's just a matter of identifying the CSS identifier of the field you want to fill (right-click, use "Inspect Element") and referencing it.  E.g.:

var state = GetURLParameter('state');
$('#state_province_id-2').val(state);

The Select2 documentation suggests this should work on Select2 widgets as well.


CiviCase css problem (Joomla version) after upgrade to 4.7.14 There is a problem with css class "label" in CiviCase. This affects the CiviCase dashboard and custom fields in the Case view panel. I think this only affects the Joomla version of CiviCRM 4.7.14.

This problem was fixed in version 4.7.16. More details here. If for some reason you need a quick fix for version 4.7.14, comment out the last 10 lines of css/joomla.css.


Integrating Civicrm in Laravel Package I have been learning Civicrm for something now. Now that I am familiar with the whole idea, I would like to integrate Civicrm in Laravel package.

I understand its not going to be an easy task, that's why I need your input, suggestions and a point to the right direction.

What should I really focus on? Should I simply create an API wrapper that interacts with the database with a fancy theme?

What steps should I take?

I don't know much at all about Laravel, but from this:

  one conclusion I would draw from that is that Laravel is probably best to use as a front-end framework, which does not require complex data store functionality. It is perfectly suited to be a service layer with its integration to Iron.io and other popular SaaS providers (AWS, S3, sendgrid, etc.), Laravel provides a simple way to build and consume API’s THE GREAT PHP MVC FRAMEWORK SHOWDOWN OF 2016

I would suggest starting by creating a wrapper for CiviCRM's extensive API. Version 3 is quite mature, version 4 is a new initiative that will eliminate some of the cruft that has developed in v3 but isn't yet covering as much as v3. FWIW, CiviCRM 5.0 is going to more thoroughly integrate various parts of Symfony 2, and we're aspiring to support progressive decoupling / headless sites that are implemented using a browser based MVC like Angular.


how to change civicrm settings from command line? There are some common settings to change for dev sites at mycivi.localhost/civicrm/admin/setting/debug.  How can those be changed from the command line?

A better answer for the question How should I copy a site from production to staging? would include this information I think.

I see on https://docs.civicrm.org/sysadmin/en/latest/misc/staging-production/ that $civicrm_setting['domain']['environment'] = 'Development'; can be placed in civicrm.settings.php, which I would expect would be sufficient(though it doesn't seem to affect what's displayed at /civicrm/admin/setting/debug)... but what about other settings like debugging and backtrace?

If I do drush vget I get a list of all kinds of Drupal settings that can be changed via drush vset.  Does CiviCRM have a comparable utility?  I tried cv and wondered if cv vars:show and cv vars:fill might be corresponding commands, but if they are I don't know how to use them to do anything useful.

You can use drush cv to update the settings in db.

eg drush cvapi Setting.create environment="Production"

You can find various options in API explorer to set other settings and see for command in cv and drush section.


How to connect your household address to its members in civicrm api v3? $result = civicrm_api3('Address', 'create', array(
  'sequential' => 1,
  'contact_id' => $householdContact['id'],
  'location_type_id' => "Home",
  'is_primary' => 1,
  'street_address' => $form_state['storage']['contactInfoValues']['address1'],
  'supplemental_address_1' => $form_state['storage']['contactInfoValues']['address2'],
  'city' => $form_state['storage']['contactInfoValues']['city'],
  'state_province_id' =>  $form_state['storage']['contactInfoValues']['state'],
  'country_id' => "US",
));

$master_address_id = $result['id'];

 $result = civicrm_api3('Address', 'create', array(
          'sequential' => 1,
          'contact_id' => $primaryContact['id'],
          'master_id'  => $master_address_id,
          'location_type_id' => "Home",
        ));

I need to attach the household address with primary contact address . How can i achieve I tried by implementing above ,but it did not work?

You need to provide same set of values to create address for members of the household with additional parameter master_id as Address foreign key id of household contact.

$addressParams = [
  'sequential' => 1,
  'contact_id' => $householdContact['id'],
  'location_type_id' => "Home",
  'is_primary' => 1,
  'street_address' => $form_state['storage']['contactInfoValues']['address1'],
  'supplemental_address_1' => $form_state['storage']['contactInfoValues']['address2'],
  'city' => $form_state['storage']['contactInfoValues']['city'],
  'state_province_id' =>  $form_state['storage']['contactInfoValues']['state'],
  'country_id' => "US",
];
$result = civicrm_api3('Address', 'create', $addressParams);

$addressParams['master_id'] = $result['id'];
$addressParams['contact_id'] = $primaryContact['id'];
$result = civicrm_api3('Address', 'create', $addressParams);

HTH

Pradeep


How to remove certain items of custom fields when sending a offline receipt? I have 2 set of custom fields for contributions and certain items of that are not meant for donors to see, only for admin purpose. But they are automatically included in offline receipt. How Can I remove them from the offline receipt?

If you want to stop all custom fields appearing in receipts, you can edit the Contribution - Receipt (off-line) template directly, in 'Message Templates'.

Remove the section starting with {if $customGroup} through to the next {/if}, and give that a try.

If it turns out it's using the on-line receipt (I'm always getting confused as to which is used when), it's the same but with {if $customPost}.


Restore from trash not working. No related log entries We've got a contact deleted to trash today. On restore civi notification states success but the contact remains in trash. The log is silent.

It looks like it happened in 5.25. I've added a lab ticket: https://lab.civicrm.org/dev/core/-/issues/1784

Will be fixed in 5.26.0.


Failed Upgrade 4.6.4 to 4.6.5 Joomla 2.5 & 3.4 My attempts to upgrade 4.6.4->4.6.5 fails in Joomla 2.5 with an 'already exists' error on CREATE TABLE `civicrm_cxn

Any clues? The full error message is:

  [Error: Upgrade DB to 4.6.5] Error Field  Error Value Type    DB_Error
  Code  -5 Message  DB Error: already exists Mode   16 UserInfo CREATE TABLE
  civicrm_cxn ( id int unsigned NOT NULL AUTO_INCREMENT COMMENT
  'Connection ID', app_guid varchar(128) COMMENT 'Application GUID',
  app_meta text COMMENT 'Application Metadata (JSON)', cxn_guid
  varchar(128) COMMENT 'Connection GUID', secret text COMMENT 'Shared
  secret', perm text COMMENT 'Permissions approved for the service
  (JSON)', options text COMMENT 'Options for the service (JSON)',
  is_active tinyint DEFAULT 1 COMMENT 'Is connection currently
  enabled?', created_date timestamp NULL DEFAULT NULL COMMENT 'When
  was the connection was created.', modified_date timestamp NULL
  DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'When
  the connection was created or modified.', fetched_date timestamp
  NULL DEFAULT NULL COMMENT 'The last time the application metadata was
  fetched.' , PRIMARY KEY ( id ) , UNIQUE INDEX UI_appid( app_guid )
  , UNIQUE INDEX UI_keypair_cxnid( cxn_guid ) ) ENGINE=InnoDB DEFAULT
  CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1050 ** Table
  'civicrm_cxn' already exists] DebugInfo   CREATE TABLE civicrm_cxn (
  id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Connection ID',
  app_guid varchar(128) COMMENT 'Application GUID', app_meta text
  COMMENT 'Application Metadata (JSON)', cxn_guid varchar(128) COMMENT
  'Connection GUID', secret text COMMENT 'Shared secret', perm text
  COMMENT 'Permissions approved for the service (JSON)', options text
  COMMENT 'Options for the service (JSON)', is_active tinyint DEFAULT
  1 COMMENT 'Is connection currently enabled?', created_date timestamp
  NULL DEFAULT NULL COMMENT 'When was the connection was created.',
  modified_date timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
  CURRENT_TIMESTAMP COMMENT 'When the connection was created or
  modified.', fetched_date timestamp NULL DEFAULT NULL COMMENT 'The
  last time the application metadata was fetched.' , PRIMARY KEY ( id
  ) , UNIQUE INDEX UI_appid( app_guid ) , UNIQUE INDEX
  UI_keypair_cxnid( cxn_guid ) ) ENGINE=InnoDB DEFAULT CHARACTER SET
  utf8 COLLATE utf8_unicode_ci [nativecode=1050 ** Table 'civicrm_cxn'
  already exists] PEAR_Exception: DB Error: already exists in unknown on
  line unknown
  - DB_Error: DB Error: already exists in unknown on line unknown Exception trace

Civi 4.6.5 adds a new table "civicrm_cxn".  Your upgrade is failing because it's trying to add this table, but it already exists.

Usually this happens when you attempt an upgrade which didn't complete for whatever reason, then attempt a second upgrade without doing a DROP DATABASE and CREATE DATABASE command.  Even though you may have restored a backup, newly-created tables will still be present.

The most "correct" way to handle this is to do a DROP DATABASE command for your Civi database, then CREATE DATABASE and load in your backup.  That said, I suspect you can get away with blowing away the new table and running the upgrade again; try DROP TABLE civicrm_cxn; in MySQL and see if the upgrade works.  Make a backup first, of course!


How to change the suffix of my contact to a UK style? How to change the suffix of my contact with a UK style?

Are you referring to the suffixes drop down, Jr. Sn etc? if so…

You have full control of the list of suffixes:

From the CiviCRM menu –

Administer > Customize Data and Screens > Dropdown Options > Individual Suffixes

/civicrm/admin/options/individual_suffix?reset=1

From here, you can add, update and edit any of the options.


Cron Job Diagnostics WordPress Version: 5.3.2

CiviCRM - Version 5.21.1

Shared Hosting - Dreamhost

I have tested this string in ssh:

/usr/bin/wp --user=username --url=https://mysite.org --path=/home/username/mysite.org/ civicrm api job.execute auth=0

It yielded this result:

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

I assume this is correct, because when it runs in ssh, the web interface tells me cron has run in the status page. So I went to the next step, adding it to cron.

I tried using crontab -e, but it didn't seem to work there, so I tried it with the dreamhost cron interface:

1 */2 * * * /usr/bin/wp --user=username --url=https://mysite.org --path=/home/username/mysite.org/ civicrm api job.execute auth=0

This worked because I kept getting emails every two hours one minute after the hour with the array message above. So I appended > /dev/null 2>&1 to the string, hoping that I could run it without receiving any emails unless there's an error.

Well I'm not receiving errors and the cron isn't running. I'm missing something. I'd be grateful for any suggestions to fix it. Thanks!

Hope you adding >/dev/null 2>&1 and not only /dev/null 2>&1 at the end of the cron string.


Is something wrong with the Schedule Reminder auto renewals for membership? I cannot find "Membership End Date" in list. Description of issue:
As per these instructions, am trying to setup a scheduled email reminder to all of our members 5 days before their membership expires. Our membership has a rolling intake date, so each of these emails is going to go out on a different day. I am relying on a tool to send these out according to a certain set of rules.

I am using the Schedule Reminder tool. After picking membership types (group of people to whom I want to send these email reminders; in the example below it is to the group of members in the "Individual" category), I want to set a specific amount of time prior to their "Membership End Date" for the emails to go out. Instead, when I go to pick "Membership End Date" from the dropdown menu, all I see in the drop down list is one entry called "Activity Date Time" (which to me seems like the generic one).

The documentation leads me to believe that this should be real simple and that dropdown should be pre-populated with that field - and I don't see anywhere to add something custom.

fig.1 Documentation suggests Membership End Date should be readily available and easy to find.

fig. 2 showing no options other than a generic "Activity Date Time" in dropdown menu

I am confident that there should be other options here/
Here is an example from StackOverflow i came across during some research.

fig.3 img shared by stackoverflow user in an unrelated discussion on setting up scheduled reminders that shows a type of

I am not sure what's up.. whether its just me.

Other perhaps related issues?
On the off chance that these are related (ie, the plugin is not picking up on some folder or DB full of important arrays or images), I thought I would document a couple other weird things I noticed along the way:

I noticed that the calendar function (fig.2; which I don't need in this case) is not working.

fig.4

In the dashboard,  I noticed that the menu items seem to have little images that are not populating. fig.3

fig.5 dashboard menu showing missing images

Those other 'issues' suggest you need to review your Directories and/or Resource URLs under Admin > System Settings.

IN terms of does Membership End Date get offered as an option after choosing Entity = Membership - yes - and here is screenshot from https://dmaster.demo.civicrm.org/civicrm/admin/scheduleReminders?action=add&reset=1 to show what is happening on a fully functioning site.

Hope the above hints help


Can I create a dynamic graduate student dashboard with CiviCRM? I just recently heard of CiviCRM. My organization provides graduate students with scholarships for tuition, upkeep, etc. We want to create a platform where a graduate student can create an account and request money to be released for let's say payment of tuition. The request should generate a pdf and after approval update their dashboard with the new amount available to the student. Is this something that can be done with CiviCRM on Wordpress? We're currently using Ultimate member plugin and elementor pro to design the dashboard, with custom fields displaying user data on the dashboard.

See if civigrant suits your needs: https://docs.civicrm.org/user/en/latest/grants/what-is-civigrant/


Is unicode not supported in clickatell SMS extension? I have CiviCRM 5.13 on Drupal7 with the clickatell v4.1 extension for SMS. Clickatell integration works, I can send test SMS via HTTPS from the browser to test phones. Database and environment is set to UTF-8.

However, if a mass SMS is compiled in https://example.com/civicrm/sms/send?reset=1, or a direct SMS is sent, the non-English characters, like é,á,... are lost or transformed in the SMS body. If the same text is sent over HTTPS/curl directly to Clickatell, there is no such issue.

Is it a CiviCRM issue, or a misconfiguration on my side? How can I track it down?

I suspect the unicode issue arises from the clickatell extension. It uses the utf8_decode() function to decode the message text from a UTF-8 string to ISO-8859-1 before posting to Clickatell. Hence Clickatell manages UTF-8 messages, the use of utf8_decode() is not necessary, and removing it resolves my issue above.

Replace original code:

$postDataArray['text'] = utf8_decode(substr($message, 0, 460)); // max of 460 characters, is probably not multi-lingual
$postDataArray['content'] = utf8_decode(substr($message, 0, 460)); // max of 460 characters, is probably not multi-lingual

to this one:

$postDataArray['text'] = substr($message, 0, 460); // max of 460 characters, is probably not multi-lingual
$postDataArray['content'] = substr($message, 0, 460); // max of 460 characters, is probably not multi-lingual

I'll provide a patch to Clickatell extensions, if this solution gets confirmed by the community.


Call to undefined function _civicrm_api3_basic_get when using CiviRepeat module I am using civicrm 4.7.17

When I go to the page sitename/admin/config/civicrm/civirepeat, I get the error

Call to undefined function _civicrm_api3_basic_get in Event.php on line 133

I figured out that the Event.php file is located in the civicrm/api/v3 folder and the function _civicrm_api3_basic_get is defined in the file utils.php in the same folder.

Why do I get the error even though the function has been defined.

Civirepeat seems like a pretty old module that's no longer supported.

https://forum.civicrm.org/index.php?topic=3329.msg76694#msg76694

Maybe if you explain your reasons for using the module it can be done using existing features as the above forum link suggests.


cannot see default civisualize displays in 4.6.10 don't know if i am doing something wrong but just installed civisualize into drupal 7 / civicrm 4.6.10 set up and if i try say
/civicrm/dataviz/contacts

i simply get text

Contacts Overview

contacts selected from a total of records
Type
Source of Contact
Gender
Day - Contact Created
Date - Contact Created

with no visuals

any thoughts would be welcome

thanks for the reply am attaching screen grab of the page view where i expected to see visualisation, have not seen any error reports and i did set path to extensions directory when i set previous extensions which appear to work fine

any further ideas more than welcome as this extensin would be really useful to us if we can get it working

check if you have any error message, eg about a missing d3 object

your error is most likely that the url for extensions isn't properly configured, so all the javascript needed to get civisualize working properly isn't there.

if you have firebug installed, or other developer extensions, you should see-in the net tab- that it's looking for the needed javascript at the wrong place


Multi-client capability und data storage One important question: Is your software solution able to deal with multi-clients, e.g. that data can be separated between different clients (companies) und security can be setup for this requirement? How is this requirement implemented in your software system? (Sites?)

And where is all your data being stored: in a database (e.g. Oracle)? und where is the database located? (Europe, States, .....)

Regrads, Jörg

A big difference between CiviCRM and proprietary SAAS offerings is that you decide where to host the system, hence your second question is not applicable.

In terms of the first question, this is possible via 'multi-site' or other ACL approaches, but the question back to you is 'why not just have separate civicrm instances for each client?'.

You can also achieve a nice multi-site outcome using the Related Permissions extension that Fuzion created.


WordPress Contribution Page Submission Not Working I have a web site hosted on IIS (6.2) with PHP 7.1.3 with WP 5.2.3 and Civicrm 5.17.4. My contribution forms are not submitting (it does not proceed to the confirmation page or get actually submitted). To clear off that it is not My Theme or the Other plugins that are playing up, I have installed a fresh copy of WP / Civicrm and used the WP 2019 default theme and created a sample contribution form to test.

The test form does not work either. Already tried resetting cache and paths and providing more rights to the web folder. Anyone else facing the same issue or if able to help will highly appreciate!

Have you checked your Civicrm logs? Would be the best place to start.  See what civicrm is complaining about.


Contribution page validation errors display and confirmation screen switch to default language instead of remaining in the current language When using a contribution form in French with the confirmation page enabled, the page redirects to the English confirmation page url instead of the French.

Start here: https://domain.ca/fr/civicrm/contribute/transact?reset=1&id=[cid]

End here: https://domain.ca/en/civicrm/contribute/transact?_qf_Confirm_display=true&qfKey=[key]

If I manually switch to the French url, everything looks OK, but if you hit the CiviCRM 'go back' button, it will take you back but switch to English again.

Similarly, if you attempt to go to the confirmation page but the form doesn't validate, while the URL doesn't change, the contents switch to English - all except for price set options (price set labels and help text are in English though).

This is our set-up:

Drupal 7 with language detection based on url language prefix (en, or
fr)
Multilingual site using CiviCRM 5.6.1 (latest at time of writing)
'Inherit CMS Language' is enabled
Default language is en_CA, secondary language is fr_CA

Extension enabled:

iATS Payments
Summary Fields
ExtendedReport
CiviDiscount

The bilingual demo site is currently out of date so I've been unable to confirm if this is just us or 5.6.x in general.

This was a configuration error on our part. Clean URLs was not fully functional - the language prefix was missing from the beginning of non-clean URLs so the final URLs were resolving to only the default language.

Adding $conf['clean_url'] = 1; to the settings file resolves the issue.

Thank you @bgm for helping with the demo site so that we could narrow this down to an issue with our site specifically.


Error: Warning: ini_set(): A session is active I am requesting Reports via Cron to email:
https://crm.xxx.lv/sites/all/modules/civicrm/bin/cron.php?pass=xxx&name=xxx&key=xxxx&job=mail_report&format=csv&instanceId=70

All reports work just fine, except for one which returns the following error when I run the address in browser.

Before there was an identical report (Constituent Summary) which just disappeared from system somehow. When I created identical new report, this error came up.

How can I solve it?

CiviCRM 4.7.14. on Drupal

My fault. The issue seems to be caused by wrong Permission in Access settings in Report.

Instead of using CiviCRM: View all contacts it was set to CiviReport: Access CiviReport.


Can you use CiviMail headers and footers on System Workflow Messages? CiviMail has an option to insert headers and footers at the top and bottom of a message (Mailings > Headers, Footers and Automated Messages). Is it possible to use these as a default for all "System Workflow Messages" Message Templates (Mailings > Message Templates).

The default templates are necessarily quite plain, and while I know you can edit each template individually, it would save time to be able to insert a common header/logo on all system templates. Changes to the header would apply to all templates at once, and future upgrade-related improvements to the message templates wouldn't require reverting and re-editing if all you had done was add the logo at the top.

If there is a way to do this, I am not familiar, so I realize this may be a feature request. If so, I'd appreciate tips on where this change would need to happen and could add it to my (ever-growing) rainy-day project list.

This question was asked here:

How can I include a custom template file in an email template using smarty?

It has been answered with quite a few specific places to make the needed changes


Some successful Paypal transactions are showing "Pending (incomplete transaction)" Some of my event transactions are showing "Pending (incomplete transaction)" when they have been successfully processed through Paypal. Not all of them just two since my event went live. I'm on Joomla! 3.6.5 and CiviCRM 4.7.16

We had trouble with this, it could be related to your IPN listener in paypal, (Log on to paypal, go to profile, my selling prefs, Instant payment notifications to check out what's going on - if it looks fine, send paypal a message)

Or you should certainly double check that you've got the correct paypal account details saved within the Payment Processor in Civi.

We had loads of trouble figuring out why our payments were not completing, and in the end it boiled down to which paypal email address was being referenced in the payment processor - the default email on paypal had been changed.


how to automatically creates a relationship Is there a way to automatically create a relationship if 2 or more address in the DB is exactly the same?

I want to create the relationship if two or more people are living in same house.

You would need to write a custom extension or module.
in this extension or module, implement hook_civicrm_post()...

Drupal module's are the simplest, if you are integrating with Drupal that is

so for example

function MYMODULE_civicrm_post($op, $objectName, $objectId, &$objectRef) {
  // if location type  is Home (location_type_id:1), operation is create, and object type is Address
  if ($op == 'create' && $objectName == 'Address' && $objectRef->location_type_id == 1) {
    // look for other addresses with the same street address, city, state, postal code, zip, and country
    $result = civicrm_api3('Address', 'get', array(
      'sequential' => 1,
      'street_address' => $objectRef->street_address,
      'city' => $objectRef->city,
      "state_province_id" => $objectRef->state_province_id,
      "postal_code" =>  $objectRef->postal_code,
      "country_id" =>  $objectRef->country_id,
      'contact_id' => array('!=' => $objectRef->contact_id),
    ));
    if(!empty($result['count'])) {
      foreach ($result['values'] as $value) {
        // check for existing relationship between contacts
        $result1 = civicrm_api3('Relationship', 'get', array(
          'sequential' => 1,
          'contact_id_a' => $value['contact_id'],
          'contact_id_b' => $objectRef->contact_id,
          'relationship_type_id' => 8, // change this to the id of the type of relationship you want to create
        ));
        $result2 = civicrm_api3('Relationship', 'get', array(
          'sequential' => 1,
          'contact_id_a' => $objectRef->contact_id,
          'contact_id_b' => $value['contact_id'],
          'relationship_type_id' => 8, // change this to the id of the type of relationship you want to create
        ));

        // if no existing relationship found create the relationship
        if($result1['count'] == 0 && $result2['count'] == 0) {
          $create_result = civicrm_api3('Relationship', 'create', array(
            'sequential' => 1,
            'contact_id_a' => $objectRef->contact_id,
            'contact_id_b' => $value['contact_id'],
            'relationship_type_id' => 8, // change this to the id of the type of relationship you want to create
            'is_active' => 1,
          ));
        }
      }
    }
  }
}


How can I split a group into subgroups of 5,000 contacts each? I saw an extension a while back that does this, but can't recall its name.  Can anyone tell me the name, or suggest another viable path to doing what I'm requesting?

The Split Group extension:

  This function takes a group of contacts, and splits it into several
  new smaller groups, each with some maximum number of contacts. The
  original group is left untouched.


How to include Email address checking in event registration page to avoid multiple contacts entries? many time it so happened that individuals made spelling mistake, specially typing email address and therefore multiple contact was created.

Just thought is there a chance to include a 2nd email address field in the registration page and notify the attendee when they make mistake spelling their email address?

you mean asking the user to type twice their email and check it's the same?

I can't find it right now, but recall reading that it wasn't that optimal as a UX (ie. people are not good enough to type without typo, but skilled enough to do a copy/paste of the email with typo ;)

One more elegant solution seem to compare the email against a set of existing common domain names (eg yahoo.com, gmail.com) and suggest a fix if the error is on the domain name, eg. if I type "xavier@gmal.com", suggesting "did you mean xavier@gmail.com"?

you could write an extension that add this feature by using this library https://github.com/Kicksend/mailcheck (I used it for a drupal extension long time ago, worked well, and shouldn't be too complicated to write a native civicrm one)


Show translated string in a template field (using smarty?) I'm using a custom profile template. I need display different text strings depending on browser language of user... One string for Spanish users and other string for all other users.

It seems this doesn't run:

{if $la eq 'es'}
    Spanish string
{else}
    Catalan string
{/if}

Mybe using {ts} tag? But I don't know where I should translate {ts strings}

I got it:

{if $tsLocale eq 'es_ES'}
    Spanish string
{else}
    Catalan string
{/if}

An easy way, useful to translate custom form strings used once, for example ;-)


What does "Reserved" indicate on Financial Types/Accounts? I see we can set a Financial Type as "Reserved" with a checkbox. What does that do, and does it set that flag automatically on the associated accounts?

'Reserved' on items like this in Civi indicates that it's something that you don't want to be updated or deleted, as it's an important item.  So non-admin people can't update or delete it - in this case you have to have the 'CiviContribute: access CiviContribute' permission to be able to update.  Groups and tags can be protected in a similar way.


Is it possible to set a sophisticated price set for events, like in this example? I am trying to facilitate a event but price sets are bit complicated, just wondering if anyone can give a clue how to sort it out please?

The "Early bird" pricing structure:

Single person -£285 pp

Couples - £240 pp

Family with kids - £220 pp (kids free under 2; £100 2-4yrs; £150 4-11yrs; over 12 £220)

We will be asking for 50% deposit upfront to secure their place and the remainder 50% within one month

Complication I am facing to give option for 50% deposit. Is it possible to do in civicrm 4.6.12?

I do not think this is possible with off the shelf CiviCRM. You should certainly have a play with the CiviDiscount extension: https://civicrm.org/extensions/cividiscount if you have not already installed it. But even then I think your requirements would mean a specific extension. As you know you can develop an extension yourself or get a CiviCRM partner or expert to develop one for/with you.


I have selected a Linked Trigger for a new rule created using CiviRules, so why do I see the error " Select Trigger is a required field "? We're on CiviCRM 4.6.19 and Drupal 7.50.

I've just added and installed CiviRules 1.2 from master.

I'm trying to create my first rule. I selected "Membership is changed" as the Linked Trigger. Other settings are in the screenshot.

Yet, when saving the new rule, I see the error message "Please correct the following errors in the form fields below: Select Trigger is a required field" and I can't save the new rule.

I'm going to start from scratch to see if there is another trigger setting I missed.

Any clues to fixing the error or removing the error message are appreciated. Thanks!

UPDATE: I've filed an issue on the GitHub repo and I've started a list of Triggers, Conditions and Actions that definitely work here

This issue was fixed on September 1, 2016 - see the closed issue on the CiviRules GitHub repo here


Finding payments in contributions Relating to 4.7. It is possible for a contribution to be made up of multiple payments.

A contribution can have a Transaction ID, but individual payments can also have a Transaction ID.

However, individual payments can not be found by searching for 'Transaction ID' in the Contributions > Find Contributions page.

For example: a participant registers for an event, choosing a ticket for £5 and paying online. This creates a contribution with a Transaction ID. We then upgrade the ticket in the back end, to £10. They pay the difference over the phone. We 'Add payment' on the contribution, and record the transaction ID.

Is there any way to search for payments rather than just the parent contributions? If not, perhaps the Find Contributions page should also search (or have an option to search) individual payments too?

For those visually inclined people:

You're asking for the fabled "Line Item Search" feature!

In short - this is a tragedy of the commons.  It's cheaper for folks to build a custom search for their particular use case than to fund this feature - and so while several folks have expressed interest in this feature, it's yet to be funded.

If you think you have resources (time or money) to put toward implementing this feature, please contact the CiviCRM core team!


Where is 'Payment Method' stored in the database for a Contribution "Payment Details"? Simple question! What table is this in, where do I find it? Latest Civi/Drupal

This is on a contribution detail page. I updated the payment_instrument_id in civicrm_contribute but it does not change it here.

The payment method of a contribution table is stored on the civicrm_financial_trxn table. Payments and Contributions are related through civicrm_entity_financial_trxn table.

Some discussions about similar issues have recently taken place on financial issue board. Please consider whether you can make a contribution on any of them or if you need to report a new one.


Issue with permissioned access using state address field We are using the state field in the address to control access for our State leaders. The people in Florida can only view Florida contacts, Texas can only view Texas, etc.

My guy in Texas is in the process of adding a couple dozen contacts and memberships, and every third or fourth entry he is unable to pull the contact up even though he entered the address and the state field is marked Texas. I have system wide permissions so I can pull the contact up and see that it was entered and saved properly.

I've tried a couple of different things with him checking after each change, and it appears if I delete Texas from the address field and add it back he can then view the record.

We are using smart groups for the contacts - if the contact is marked Texas in the address field it gets added to the Texas contacts smart group. He is the Edit Texas group which gives him edit access to the Texas contacts smart group.

Any ideas as to why this is happening and how to fix it? I've had similar complaints from others after the fact and we end up with duplicate entries because they end up creating a new contact that they are able to view. This is the first time where someone reached out and i was able to trouble shoot it in real time to get an idea of what is happening...

Matt Nye
Drupal 7.33/CiviCRM 4.6.4

Could it be that the contact is not added to the smart group immediatly? Also a smart group is rebuild in the background with a scheduled job.

The smart group cache timeout is configurable: see http://book.civicrm.org/user/current/organising-your-data/smart-groups under "Smart group caching".


Wordpress Multisite and CiviCRM with multiple databases I know that it's possible to have CiviCRM shared across multisite Wordpress, and for a single database to operate in a way that keeps different site's data separately.

I'd like to do something superficially simpler, but which I can't find any mention of anywhere.

I'd like two sites in a multisite install to use the same CiviCRM codebase, but completely separate databases. To my mind, I just don't want to the two website's data mixed together, even if they are kept separate from a user perspective.

Could this be as simple as a PHP switch in the config file which says (psuedocode) ...?

 If Website A:
      Use Database A
 Else:
      Use Database B

But I realise that with logs and Smarty cache files it might be more complicated than that ...

Well, the answer appears to be 'Yes, it is (almost) that simple'.

The one wrinkle is that you first need to trick CiviCRM into thinking it has not already been installed on another Wordpress network site by moving civicrm.settings.php to an out of the way location.

So, do this:

Move your old civicrm.settings.php file somewhere safe.
Create a new empty MySQL database.
Go to the Wordpress site where you intend to create the new CiviCRM instance and activate the CiviCRM plugin.
CiviCRM will go through the process of installing CiviCRM to the blank database.
A new civicrm.settings.php file will have been created probably in a path like: /path/to/wordpress/wp-content/uploads/sites/2/civicrm/civicrm.settings.php
Restore your old civicrm.settings.php to its original location (in my case this was in /path/to/wordpress/wp-content/plugins/civicrm/ because it's an older install).

The 'old' settings file was edited something like this:

<?php

$site = $_SERVER['SERVER_NAME'] == 'newsite.com' ? 'new' : 'default';

if ($site != 'default'):
    include_once('/path/to/wordpress/wp-content/uploads/sites/2/civicrm/civicrm.settings.php');
else:
    /*The contents of the old original settings file goes here.*/
endif;

?>


cms.root.path error after upgrade to 4.7 (Joomla) I upgraded two installations of CiviCRM 4.6.11 to 4.7 on the same server. Both upgraded fine, but now have the following errors:

1) Systems Settings --> CMS Database integration shows nothing (no paths or fields displayed). Normally I would expect at least a field to enter the Joomla Users Table name.

2) Systems Settings --> Directories shows this error:

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

Cannot resolve path using "cms.root.path"

Return to home page.

Anyone else seen anything like this? There are no php errors logged (but some warnings), and the CiviCRM log shows this:

$backTrace = #0 ...civicrm/CRM/Core/Error.php(444): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 ...civicrm/CRM/Core/Invoke.php(57): CRM_Core_Error::handleUnhandledException(Object(RuntimeException))
#2 ...civicrm.php(116): CRM_Core_Invoke::invoke((Array:4))
#3 ...civicrm.php(40): civicrm_invoke()
#4 ...CMS_root_directory.../libraries/cms/component/helper.php(392): require_once("...civicrm...")
#5 ...CMS_root_directory.../libraries/cms/component/helper.php(372): JComponentHelper::executeComponent("...CMS_root_directory.../administrator/components/com_civicrm/civicrm...")
#6 ...CMS_root_directory.../libraries/cms/application/administrator.php(98): JComponentHelper::renderComponent("com_civicrm")
#7 ...CMS_root_directory.../libraries/cms/application/administrator.php(152): JApplicationAdministrator->dispatch()
#8 ...CMS_root_directory.../libraries/cms/application/cms.php(252): JApplicationAdministrator->doExecute()
#9 ...CMS_root_directory.../administrator/index.php(47): JApplicationCms->execute()
#10 {main}

Thanks to eug for finding the problem (see comments). Eug's solution worked for me:  Edit the file administrator/components/com_civicrm/civicrm/templates/CRM/Admin/Form/Setting/Path.hlp to replace the first crmResPath with crmResURL

Update: problem persists in 4.7.3. Have upgraded the bug report priority to Major.

Update: problem persists in 4.7.4.

Update: problem persists in 4.7.5.

Update: fix prepared for 4.7.6. See above bug report link for PR details.

Update: problem fixed in 4.7.6.


Strength testing password used to create user account Is there a way to control the minimum strength of the password required when a user creates a "User record" from the actions menu on a contact record. In Drupal I have been able to do it via using the password_strength module and looking at using the password_policy module

Anyone got any thoughts?

Cheers

Also my system is CiviCRM 4.4.13, Drupal 7.35

Seems like CiviCRM might not be calling the right functions within Drupal (which trigger hook invocation that modules like password_strength or password_policy implement.

Would be good if we can adapt Civi's code to do the right thing. The user/password creation for drupal is isolated to the file:

CRM/Utils/System/Drupal.php

Check the functions createUser and checkUserNameEmailExists


Where are the saved import mapping configs stored? I have been working on a local CiviCRM install to test importing contacts from a CSV file to the Civi contacts. I am ready to move this import process to our hosted test site but would not like to have to recreate the import mapping again. Are the saved mapping saved in a particular DB table or config file? I cannot find any documentation regarding this.

They looked to be stored in two tables.

civicrm_mapping
civicrm_mapping_fields

The tables are pretty standard.  The first has the header info and id, e.g what you called the mapping and the second has what each field is mapped to.  The foreign key is civicrm_mapping.id = civicrm_mapping_fields.mapping_id

I'm pretty sure if you haven't saved any mappings in the target system or don't care about any you have, you can import the two tables into the target system and be good to go.  Of course, you mileage may vary and do test, but it looks like the target system is a test system.


Membership Form without Contribution Request Is there a way to make a membership signup form that does not ask for a donation?

Ben,

You can create zero membership fee membership type and include it on contribution page and turn off 'CONTRIBUTION AMOUNTS SECTION ENABLED' under Amounts tab of contribution page.


Upgrade CiviCRM 4.6.20 to 4.7.10 on Drupal - db error I'm upgrading a CiviCRM 4.6.20 install to 4.7.10. I'm on Drupal 7.50. I've tried the updgrade several times. My Drupal database updates are all executed. Before running the upgrade, the civicrm_action_schedule table has an INDEX with the name, FK_civicrm_action_schedule_mapping_id. But when I execute SQL to list all foreign key constraints, there are none. I don't know if this makes a difference, but the table is empty. I don't have any rows in civicrm_action_schedule.

What could I be missing here? Thanks!

[Error: Upgrade DB to 4.7.alpha1: SQL]
Error Field Error Value
Type    DB_Error
Code    -4
Message DB Error: not found
Mode    16
UserInfo    ALTER TABLE civicrm_action_schedule DROP FOREIGN KEY FK_civicrm_action_schedule_mapping_id [nativecode=1091 ** Can't DROP 'FK_civicrm_action_schedule_mapping_id'; check that column/key exists]
DebugInfo   ALTER TABLE civicrm_action_schedule DROP FOREIGN KEY FK_civicrm_action_schedule_mapping_id [nativecode=1091 ** Can't DROP 'FK_civicrm_action_schedule_mapping_id'; check that column/key exists]

I may have found a solution elsewhere - which is ugly and requires editing the upgrade scripts. Database Error When Upgrading 4.6 to 4.7 on Drupal 7
So it's not really a solution for me - but maybe it will be  a  solution for others, as once I got past that issue the 4.6.20 to 4.7.0alpha3 portion failed with the following. Have not found that many google matches for this error - but hopefully I can get past this next hurdle. Hopefully others won't also run into this issue.

[Error: undefined]
Exception: "A fatal error was triggered: Could not find valid value
for qrid"
0 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Utils/Request.php(92):
CRM_Core_Error::fatal("Could not find valid value for qrid")
1 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php(47):
CRM_Utils_Request::retrieve("qrid", "String", NULL, TRUE, NULL,
"POST")
2 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php(106):
CRM_Queue_Page_AJAX::{closure}()
3 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php(54):
CRM_Queue_ErrorPolicy->call(Object(Closure))
4 internal function: CRM_Queue_Page_AJAX::runNext()
5 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Core/Invoke.php(278):
call_user_func((Array:2))
6 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Core/Invoke.php(86):
CRM_Core_Invoke::runItem((Array:13))
7 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Core/Invoke.php(54):
CRM_Core_Invoke::_invoke((Array:5))
8 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/drupal/civicrm.module(454):
CRM_Core_Invoke::invoke((Array:5))
9 internal function: civicrm_invoke("upgrade", "queue", "ajax", "runNext")
10 /home/kialis/zootownarts.org/drupal7/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:4))
11 /home/kialis/zootownarts.org/drupal7/index.php(21): menu_execute_active_handler()
12 {main}


exporting data with custom field nantionality exports country id instead of country name I have a custom field nationality and after upgrading to Civi 4.6.9, i noticed that when i export contacts with custom field nationality, first entry has the name but the rest are the country ids, see screen shot.

I have also tested this on the demo site http://d46.demo.civicrm.org/ and it is the same problem

The same thing happens to us. I just create an issue and proposed a patch as a provisional workaround.

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

[Edited]

Seems that the issue is fixed for 4.6.12 version.


ContributionDashboard correct amount not equal CiviReport Stripe.com shows we received a donation of $15.
It correctly shows on the Civi Contribution Dashboard.
When we run Civi Report, the amount shows up as $30.
We have many cases when the report and the dashboard give the correct results. This is the first time when the amounts do not agree.  Anybody know what is wrong?

I found that the donor had two home phone numbers in her contact info. Removing the second home phone, resulted in the amount not being doubled.


Search Builder Issue I have  a problem with Search Builder on my CiviCRM.
I just wanted to check how many contacts i have in my db outside of Italy.
It should be a simple search:

Record Type = Contacts
Field type = Country
Operator = ≠
Value = Italy

I get this error: "Sorry but we are not able to provide this at the moment.
DB Error: no such field". If i try with another field type, e.g. city, it works.

I've tried the same search in CiviCRM Beta website, it works.

Is there someone who can help me figuring out what could be the problem here?

Thank you very much
Alessandro

I believe you would need to find the country_id for Italy in civicrm_country, and then use that? The country name will not be stored in any other table.


Finding ongoing Recurring Contributions I am trying to find contacts who have live recurring contributions, and by that, I mean recurring contributions that will continue to give, not single contributions that were given as part or a recurring contributions series, and also not recurring contributions series that were cancelled in the past. (I find the terminology here confusing.)

How can I search for all contacts with live recurring contributions that have not been cancelled?

If it's in the docs, I'm sorry, please point out where! Thank you.

Version CiviCRM 4.6.38 (upgrading very soon!)

There is a Recurring contributions report and summary report which allows you do filters and also some related fields. You can find them under Contribution reports section(/civicrm/report/template/list?reset=1&compid=2).

Also there is an extension called 'RECURRING CONTRIBUTION SEARCH' that allows you to search recurring contribution.

Cheers

Pradeep


Is Drupal Views affecting CiviCRM performance? I have created a Drupal Views block, which aggregates some CiviCRM values. This block I have on most pages.

How (if any) is this affecting the performance of the CiviCRM site?

(How does Drupal Views aggregate its result? SQL query?)

Views has an option to display the exact query it generates, so you can get a rough idea by running that query alone with a tool that allows you to time it. Ideally a single query should execute in a matter of milliseconds, not seconds.

If you have general concerns about sql performance, enable slow query logging to find out which queries on your site are taking the longest.