Ajax error when viewing relationships under IIS and Joomla (HTTP400 - invalid syntax)

After months of struggling with this, I think I have solved it:  I found this article or others like it: https://stackoverflow.com/questions/8159321/request-exceeds-the-configured-maxquerystringlength-when-using-authorize which gave the parameters to tweak in web.config:

is an example.  As it is a private server I haven't spent much time optimising those parameters.


Is it possible to write a report to send a weekly digest of people who have filled in a webform survey

Are you using the Activity Details Report? It has a filter on activity data Last Seven Days including today. See:

In order to filter on a tag, you can create a smart group that contains all the contacts with the tag. That gives you the option to use the Group filter.


Can I use autocomplete to add users in a webform (they might be existing contacts)?

Yes, it can be done with webforms.
Select a 2nd contact in the CiviCRM tab, check Existing Contact and add any other fields that you want to expose on the form (including the custom info). Click Save Settings.

Go to the Webform tab and click on the field that was created for the Existing Contact. There you can set the autocomplete option for the Form Widget (in the Display area):

Take note of the permissions setting in the Filters area as well so you don't end up exposing a lot of personal information unintentionally.


Sometimes CiviCRM sends you to an absolute URL, even though most of the time you navigate through links with relative URLs.

CiviCRM uses the base URL in your civicrm.settings.php file to build the absolute URLs, and it caches that base URL for performance.  I suspect that your situation is either:

the base URL in the settings file still points to the live site, or
the cache still has the live site URL even though you updated the settings file.

To fix this, confirm that the settings file has the right URL, and then visit Administer > System Settings > Clear caches and update paths.  Update the paths there, and you should be good to go.


CiviEvent: Public link for events of a specific type

You should be able to do this using a drupal view - You might need to enable the civicrm entity module.

You'll want to create a view that lists Civicrm Events then filter down the criteria you are using.


Best WordPress theme framework for correct display of CiviCRM?

Watch out for themes or plugins that use Backbone.JS calls. They seem to be causing some issues right now.  One such theme is Salient.

The JetPack plugin also seems to be suffering from the same problems. (Search the StackExchange for backbone and you'll see a few different threads.)

The Virtue theme has styling issues.

Twenty Fourteen provides good displays.


Webform error for event registration - Invalid argument supplied for foreach()

It turned out to be a problem with Custom Data (civicrm/admin/custom/group). A Set of Custom Fields had been created for participants without any fields added. I removed the group and problem is fixed.


How do you give in honor/memory of someone but acknowledge someone else?

It depends a bit on the purpose of gathering soft credits and acknowledging the donation. For acknowledgement purposes it may be sufficient to gather email and name (and perhaps address) on a front or backend form and with a hook send off an acknowledgement email. I think this can be very nice for those related to the honoured person, allowing them to send a thank you card if they want. Personally I won't bother creating additional soft credits for the mother and uncle beyond those for the person in honour/memory of.


How do I send an email to all event participants immediately?

Can you create a activity reminder of type event registration and send the reminder after 0 hour of activity date time?


the first thing you need to test is that if the "+" notation works. Assuming your email is andreas@example.com, try sending to andreas+testing@example.com (from another email)

if you do receive the emails, you're golden and your mailserver isn't braindead (aka "not exchange or 360")

you then simply need to set up your localpart to "crmbounce+" (not sure if it's what you have already)

if you do not receive the email (and/or if the sender receive a bounce email saying that andreas+testing@example.com isn't a valid email), you might find a workaround with a catchall email, but I'd recommend you to take it as a hint that your mail server isn't made for mass mailing and set up a mail provider that is able to send mass emails and that has a working interface with civicrm (amazon ses, mailjet...)

X+


To use your CiviCRM on small screens a responsive theme is all that's needed.

This is an extension that will make the admin menu responsive: https://civicrm.org/extensions/slicknav-web-responsive-admin-menu


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);


The "cmsBaseUrl" is not set according to the information in civicrm.settings.php

Did you run check-req with the --cms-base-url argument? It needs to be specified there too.


MultiRecord OptionGroup on campaign page

The short answer is that it hasn't been built out.  It could/would be "achieved through coding", but I don't think it would be done "easily".  The issue is that there are a number of places where the assumption is made that there's only one value per field per campaign (or any non-contact entity).  You'd need to take care of all of those situations.

If you were to do so, you'd end up hacking core CiviCRM considerably, so you'd have to maintain it from upgrade to upgrade.

For those reasons, it would be best done as an improvement that gets incorporated into a future version of CiviCRM.  It would probably require some time and/or money to get it done.  You might contact someone on the CiviCRM core team to discuss some options.  There are ways you can hire them to build a feature for you, or if you have more time than money, you can write the code and they can help you do it well.


You can find paid CiviCRM consultants on this list here.

With that said - much of what you'd like to do should be something you can do yourself, you may just need training.  I would recommend finding a consultant who will train you to set these things up together.


CiviEvent: possible to trigger an email to event organizer when participant count reaches a certain number?

It can be easily done using hooks. Max participant is stored in civicrm_event table, so you need to fetch the value and then compare it with the count of participants registered in this event. All this check should be done after a participant is created. So, you could use post hook for the same. Sample(not tested) code is shown below -

function example_civicrm_post($op, $objectName, $objectId, &$objectRef) {
  if ($op == 'create' && $objectName == 'Participant') {
    //check the count of participant in the event
    $participantCount = civicrm_api3('Participant', 'getcount', [
      'event_id' => $objectRef->event_id,
    ]);

    //Compare it with the max participant value
    $max = civicrm_api3('Event', 'getvalue', [
      'return' => "max_participants",
      'id' => 1,
    ]);

    //If max equals the count, send an email
    if ($max == $participantCount) {
      //send email to xyz@example.com
    }
  }
}


I would recommend changing the certification field into a multi-select. That way the search field will be a drop down and much easier for the end user. I had to do this recently. Here are the steps I took:

Create a new multi select custom field.
Make sure the values match the entries from the previous field to avoid errors in the next step.
Export the records with the current custom field. Make sure to include the contact ID
Now do a import updating the new custom field with the data from the old one.

These are the steps I took recently. Looks like you only have about 100 records in this group so it should work fine.


What is effect of marking contact as deceased?

Deceased should have the following outcomes (iirc):

Contact Record shows (deceased) in red after their name
CONTACT IS DECEASED shows in demographic fields
contact is excluded from mailings and PDF prints
contact is excluded from exports unless overwritten
the status of memberships will be changed to "deceased"


Clearing/disabling out-of-date event locations

Unfortunately, no, there is no UI for managing event location addresses and it's not possible to disable them even in the database without dropping the link between an event and the address (table civicrm_loc_block).

It could be a good feature to add to CiviCRM though.


Are we able to see why a payment failed?

There are a few places you can check.

Foremost, I would check your payment processor's logs.  Most likely the cards were sent there and declined.  Make sure you don't have any configuration mismatches - e.g. not allowing credit cards from outside your country, or requiring a CVV on the payment processor but not on CiviCRM (though I believe it's mandatory in CiviCRM on the front end these days).
Check your CiviCRM logs.  Their location varies by CMS.  If you're not sure how to interpret them, you may want to open a new question.


I need help finding an error in my installation

Couple of things I usually do after migration

Check path and save Administer >> System Settings >> Directories.
Check path and save Administer >> System Settings >> Resource URL.
Delete template_c.
Rebuild menu and Trigger http://domain.com/wp-admin/admin.php?page=CiviCRM&q=civicrm/menu/rebuild&reset=1&triggerRebuild=1
Run Cleanup and Cache.

(Also check if php CURL is installed on server)


How can I add the "automated mailer task cron job"?

There is some general information about scheduling jobs and running cron here User and Administrator Guide.

You will find links to more details in both the guide and the link (Job parameters and command line syntax documentation…) on the Administer=>System Settings=>Scheduled Jobs.  Here is that link Managing Scheduled Jobs.

There a number of different ways to run the jobs from cron and a number of examples in the second link, which should take you to the command line syntax part of the page.

This command line should work in most situations; though, there can be better options for security, etc. depending on your environment.

*/15 * * * * /path/to/php /path/to/civcrm/module/bin/cli.php -s site -u user -p password -e Job -a execute

The -s parameter is the site name, and defaults to 'localhost'. It should be set the FQDN (fully qualified domain name) of your site (eg, 'example.com') Some jobs rely on this being set (in certain cases, the CiviMail mailing scheduler uses this FQDN to generate absolute URLs when relative URLs are in the email).

For the crontab challenged folks (most of us at some point), the */15 says to run it every 15 mins.


How can i override Civicrm /CRM/Utils Files?

First of all, you should really customize CiviCRM by developing extensions. There is a developer guide that will explain you how this is done: https://docs.civicrm.org/dev/en/latest/

If you do want to override anyway, you should first of all navigate to Administer>System Settings>Directories to provide the path to the PHP files, have you done this? If you have it should work but I would still recommend to take the extensions route as this is by far the most used and supported route.


Steve, I'm not sure exactly how this is happening, but it sounds like something about your process is getting confused between HTML and plain text.

If I typed &id=X in a Wysiwyg editor, the HTML source for that would be
&id=X (actually, what I wrote over there to the left was "& amp;id=X" but without the space. It was interpreted as HTML and the "& amp;" was rendered as "&" - talk about illustrating the confusion - apparently I needed to use "preformatted" in this wysiwyg editor!)

Is it possible that some of the parameters for your site were cut and pasted from html and it snuck in this way?

Can you elaborate on when this occurs? E.G. is this manifesting in browsers, or in emails sent by CiviMail, or in some other way?

Rick


Struggling: Search report for donations by creation date not receive date

Yes, there is no such field in contribution table that holds when a contribution record was actually created. However an activity is created when a contribution is recorded with status completed. If contribution is created with pending status and updated later after day or 2 then it is very difficult to track via Activity.

I have an extension that uses activity to get created date and display on a Civi Contribution Detail report.

The alternate way of doing this would be create a date custom field for contribution, auto populate the field with now() using buildform or post hook.

HTH

Pradeep


What versions of PHP are used in CiviCRM's internal QA?

At time of writing, all PRs tests and scheduled tests run under Ubuntu 12.04 (PHP 5.3.10). There is an effort underway to introduce a test node for Ubuntu 16.04 (PHP 7.0) (although details are still a bit in flux).
When you inspect the results of a test run, you can get some details (such as the node name and console output). The node names follow a convention -- test-ubu1204-5 is running Ubuntu 12.04 (precise); test-ubu1604-1 is running Ubuntu 16.04 (xenial).

This tells you the general platform and hints at the PHP version. I'd like to keep these generally aligned with upstream versions.
As a somewhat stronger statement, I want to keep the test nodes aligned with civi-download-tools --full, which autoinstalls system requirements on some common builds of Ubuntu/Debian. If you know the target platform, you can lookup a more specific list of packages.


Prevent automatic login after registration

CiviCRM relies on CMS(i.e WP) settings when creating users. By default WP doesn't provide any such settings so you may need to install some plugin which needs admin approval for newly created user. Probably something like User Approve plugin.


Importing Contacts, Memberships and Contributions in 2020

The "normal" import tools tend to focus on a single entity (contact, contribution membership, participants...) indeed, so as you identified, it needs several separate imports and trying to find some common keys so civi knows how to link them

If you have complex/composite structures to import, it might be easier to write a simple php script that calls all the needed apis to create the entities. If you are familiar with php and the civicrm apis, it might be simplier (and it makes it way easier to "replay" the import)

good luck!


Why does A/B testing cause 'dedupe by email' to fail when sending CiviMail to contacts with same email address

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

You could confirm this by doing:

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

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


I would first check that contacts haven't been manually added to or removed from the smart group. To do this you'll probably need access to the database in order to interrogate the tables. Even though they are smart groups you can still manually add and remove contacts from them and that might be why your seeing unexpected results.

The second test would be to create a new smart group based on the criteria you want and see if you get the result


Recurring donations are receiving recurring email receipts after update

We do not use Stripe so this might not help. But this is how it works for iATS.

Go to Administer > CiviContribute > iATS Payments Settings (the very bottom option)
One of the check boxes is "Enable email receipting for each recurring contribution" If this is checked you will be sending a receipt with each donation.


Preventing access to those files should be taken care of by .htaccess files.

You should have .htaccess files under files/civicrm/ConfigAndLog, files/civicrm/upload, files/civicrm/custom with content:

<Files "*">
  Order allow,deny
  Deny from all
</Files>

What webserver are you using?  Is this on a hosted environment or your own server?  The server needs to be configured to use .htaccess files

For Apache, see https://httpd.apache.org/docs/current/mod/core.html#allowoverride

For nginx, see other posts on this site - eg:

Files in the data directory (Upload | Custom)should not be downloadable. (Nginx)
Is CiviCRM compatible with Nginx?
Security Warning on Dashboard (pantheon / nginx)


Event contribution summarized by price set

There’s a custom search available in CiviCRM called Price Set Details for Event Participants which may be of use for your enquiry.

Search > Custom Searches > Price Set Details for Event Participants

/civicrm/contact/search/custom?csid=9&reset=1

This search allows you to filter on an event and also gives you an option to export your results.


The CiviCRM debug log should not be downloadable - generated .htaccess seems ok

It's possible that the config for the virtual host/Directory does not allow .htaccess override for the Limit directive type, and so is ignoring the Order commands.

See https://httpd.apache.org/docs/2.2/mod/core.html#allowoverride


Social sharing issues: OG and title metas - WP

It looks like the same behavior occurs on the official CiviCRM/WP demo site. The browser title for this demo page:
http://wpmaster.demo.civicrm.org/civicrm/?page=CiviCRM&q=civicrm/event/info&reset=1&id=3

Does not match the generic title being scraped by FB:
https://developers.facebook.com/tools/debug/og/object/

Meanwhile, the CiviCRM/Drupal demo site is scraped as one would hope:
http://dmaster.demo.civicrm.org/civicrm/event/info?reset=1&id=3

Is this just a WordPress issue that is yet to be resolved?


I have 2 button (Register Now) for CiviEvent

Two "Register Now" buttons is by design.

When you add more info to the event such as a formatted description, a picture,  a location map etc then the page can get quite large so the idea is that your users can easily get to a 'Register' button at the top and bottom of the page with minimal scrolling.

If you really don't want both buttons you can customise the event display.  See various answers here on SE such as this


Civicm change UFID to ContactID relationship programatically

Well as usual it turns out to be simple.  I just need to manually make the link in civicrm_uf_match via my program then simply change the session variables via:

require_once 'administrator/components/com_civicrm/civicrm.settings.php';
   require_once 'administrator/components/com_civicrm/civicrm/CRM/Core/Config.php';
   require_once 'administrator/components/com_civicrm/civicrm/api/v3/UFMatch.php';
   require_once 'administrator/components/com_civicrm/civicrm.settings.php';
   require_once('CRM/Core/DAO.php');

$session = CRM_Core_Session::singleton();

$session->set('ufID' , $ufid);     //joomla ID
$session->set('userID' , $userid); //civi contact id


Webform CiviCRM Event Confirmation Email Not Sending

You must also enable Thank you and Receipting in the CiviCRM Configuration for the Contribution Page associated with the webform;


private notes: how to restrict visibility to a certain group?

You might want to try this extension: https://github.com/AlainBenbassat/eu.businessandcode.notepermissions

It creates a permission in your CMS for each note type you create in CiviCRM.
You can then selectively assign these permissions to users who have to see the corresponding notes.

The extension has not been extensively tested, so I'm looking forward to user feedback.


Add Civilcrm member detail in third party tcexam

You can do this, but you need to be a programmer, or hire one.

CiviCRM is well suited to this, TCExam is not because it has no API.  If they both live on the same server, that's not too bad though.

Write an extension for CiviCRM that uses hook_civicrm_post.  When a completed contribution is added, make a connection to TCExam's SQL database and insert a new user record.

Instructions for writing an extension are available here and here.


There is a French translation of CiviCRM available here:
https://civicrm.org/download-translations

There is also a guide to 'Using CiviCRM in your own language' available.

It doesn't look like the WP demo site lets you change the language to test, but you can do it on the Drupal test site: http://dmaster.demo.civicrm.org/:  Administer > Localization > Languages


How to delete "Not you or want to join..for a different person"?

I think what you see when you have "other members personal details" that emerge is either because they are stored by your browser (so civicrm isn't involved, it's a browser feature) or because you are logged in as a user that has the right to see other members.

Try doing it without being logged in (eg. using the anonymous mode of your browser), you will see that civicrm doesn't show private information to anonymous visitors


Try just using the regular installation process--it should be simple enough.  You won't find or want to work with a different theme for the backend of CiviCRM, and on the front, you should find that CiviCRM works well in most cases.

Now in 4.6, CiviCRM will set up a base page for you, so it's one step easier, too.


Set defaults values and attributes to membership form fields with PHP

you should be able to do this with the buildForm hook that is described here: https://docs.civicrm.org/dev/en/latest/hooks/hook_civicrm_buildForm/.
Keep in mind that the custom fields are actually posted on a different form, so I usually first dump the form names to the log with Civi::log()->debug so I can check what the name I need is.


Add multiple target contacts in advanced search

I'm assuming your using Adcanced search to build this

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

Into just a standard static group.

Then Advanced search
group="new group"

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

Does that get you closer?


Running 2 civicrm instances on 1 database

Yes, you can have multiple Civi/CMS instances on the same server. Depending on your preference, when looking at your server, you will see something along the lines of one of the the following structure:

Per comment - editing my response to include database - unless you are setting up a multi-site instance of Civi, you would need a separate database for each CMS instance.


CKEditor - add left, right, centre, justify buttons

It turns out this has a simple fix: add the 'Justify' plugin to Civicrm.

Go to the CKEditor config screen: Administer > Customise data and screens > Display preferences > CKEditor config

Then add the Justify plugin.

A new toolbar group will appear in the 'paragraph' section, which you can then move around as you'd like.

Then save your settings...

In my installation, for some reason something is hampering the UI from working properly. If that's the case, you can still call the plugin by directly editing the config file: (in our drupal 7.56 installation)
sites/default/files/civicrm/persist/crm-ckeditor-default.js

and ensure you add the justify plugin to lines like:

{ name: 'paragraph', groups: [ 'list', 'indent', 'blocks', 'align', 'bidi', 'paragraph', 'justify' ] },

and

config.extraPlugins = "justify,showblocks";

If you're editing this file directly you have to be very aware that it will be over-written if anyone saves the CKEditor settings using the UI as above.

Hope this is helpful to others out there mystified by the lack of these buttons!


So I think I was jumping the gun with my excitement about this.

I found the issue on Jira, which has been updated to say the custom filter creation has been bumped to 4.8.  The work-in-progress code that Jon was working on is at https://github.com/civicrm/civicrm-core/pull/6307


Webform and multiple memberships with same Member Organisation

Currently you cannot use Webform-CiviCRM to sign members up for two membership types of the same organization concurrently, and this is true for the current release (4.10) and is unchanged in the upcoming v4.11.

What you described in your testing is working as designed. If a user signs up for type MEM1 and pays the fee, then comes back a year later and signs up for MEM2, it will change their membership type to MEM2, charge them the price for MEM2, and extend their expiration by a year. The only thing in your testing that made it look weird is that you did both of those things on the same day. Just wait a year between signups and it will make sense :)

If you do want to use a webform to sign members up for 2 different membership types, simply set them up in CiviCRM as belonging to different member organizations, and then the webform will understand it as a separate signup and not a renewal.


How do I create a custom field that selects a CiviCRM group

As you may already know, there is a field that will expose all groups that are mailing lists to the user and let them select, which one they want to subscribe to. You could add this field to the profile that you use for events. It is descirben on this page (see "Using a profile"). However, users would be presented with all public mailing groups available.

As an alternative, you could also create a custom field (I would recommend a contact field but you could also use an event field) and give the users the opportunity to tick that field/option. You could then create a smart (mailing) group (which is also described on the page linked above) that includes all people who selected the option.

Both options do not require any coding at all and can be done via the UI.


Using CiviGrant as the applicant/recipient

That's totally possible - I have one medium size org that uses Grants exclusively for this purpose. We're using some simple Word Replacements -> in civicrm/admin/options/wordreplacements?reset=1 to help Staff use native CiviCRM Grants to track income:


Where do I adjust the auto logout duration for administrators?

User access is done by CMS so it isn't really a Civi question. If you are on WP, you can use this https://wordpress.org/plugins/inactive-logout/. If other CMS, post on their forum.


CiviContribute Dashboard Chart Layout does not display

Problem is Flash being blocked.     Although it is globally enabled, for some reason it is being blocked.   Solved problem with this process to specifically trust site for Flash.

https://support.google.com/chrome/answer/6258784?co=GENIE.Platform%3DDesktop&hl=en


How do I add options to Communication Preferences

I do not think you can simply add a Communication Preference like you can add an option group as there is also quite some processing involved rather than 'just' a way to inform you about something. So if you would want that you would also have to influence the code. You can add a preferred communication method, but that is different because there is no processing related.


How to create a view to display all the files in an extension?

Take a look at the documentation for civix. To create a page like the mailing templates you could use civix generate:form, as described at https://docs.civicrm.org/dev/en/latest/extensions/civix/#generate-form
If you prefer to create an angular page, you can also use civix to generate the basic code: https://docs.civicrm.org/dev/en/latest/framework/angular/quickstart/#create-an-angular-module


How do I use the joins feature of the new API

The JIRA Issue for this feature https://issues.civicrm.org/jira/browse/CRM-17795 reads

  This adds support for joins in api.get operations to fetch information
  from more than one table.

  It also adds ACL enforcement to the Contact and related (email,
  address, phone, etc) apis for get, create & delete actions.

The JIRA issue links to a couple of pull requests; pull request 7565 includes a comment that has screen shots and descriptions (and one join example).


This may or may not meet your requirements, but it's worth noting that there are 2 built-in "print case activities" options currently in CiviCase. You can click the "Print Report" button from the manage case screen, which will print all activities in the main timeline, or you can get finer control from the "Activity Audit" menu which lets you select a timeline and gives you further redaction options before printing.


Upgrade to version 4.7.31 seems to have broken DAO.PHP

It sounds like you perhaps aren't using a supported version of PHP.  I would check your version; my guess is that you're on PHP 5.4, since 5.5 is the minimum supported version in Civi 4.7.31.

I would restore your site from a backup if you're not in a position to upgrade PHP immediately - but my advice is to try to upgrade PHP.  PHP 5.4 is known to be insecure and hasn't received security updates in almost 3 years.


The easiest way would be to create groups in Civi based on which state they are in then send the email out of Civi mail. Use the advanced search to find the contacts, select the ones you want included in the group, then select Group - Add contacts. Select Create new group, name it and select mailing list from the group type and save.

In the mailings drop down, select new mailing, format however you want and select which group you want it to go to. That way you can track opens and which links have been opened by each person. You can also include attachments to this email.


Yes thats true, if you update certain parameters of existing pledge than it deletes all pledge payment and recreates it. Below are the parameters when changed deletes all pledge payments.

amount
frequency_unit
frequency_interval
installments
start_date


Stop Webforms loading memberships in the messages section for 'existing contacts'?

You could add a simple css hack to your webform which sets system messages on the front page of the form to display: none. That's not a perfect solution because it will hide all of them, but it's something.


Database error when using CiviCRM admin UI: "Row size too large"

Also see https://civicrm.stackexchange.com/a/31644/225 where the suggested fix is:

 ALTER TABLE civicrm_menu ROW_FORMAT=DYNAMIC

Then rebuild the menus


How to allow logged in user to view their own civicrm contact dashboard in wordpress?

Giving permission to user 'edit own contact' will be able to update his own details.  You can check permission by navigating to CiviCRM >> Administer >> Users and Permissions >> Permissions (Access Control) and then click on Wordpress access control


How to restore the colour button in Ckeditor

If you go to civicrm/admin/ckeditor?reset=1 you should be able to activate the plugin "Colorbutton".


Is it safe to delete multiple membership records after ensuring the Contact record has been merged?

It is okay to delete a duplicate membership, but if there is a payment associated with that membership record, that payment will also be deleted. If that is an issue, you may want to consider creating a new membership status to reflect these duplicate memberships, you'll be able to easily filter them from reports that way.


This would be implemented as a payment processor extension. There is not a current extension written for Taxamo, but the documentation for implementing one can be found here.

They also say (at the bottom of this page) that you can contact them to see about getting plugins developed for additional shopping carts, the "cart" being a Civi payment page in our case here.


Is it possible in CiviCRM to change extension of cached php files from .php to something else (e.g. .php_ or .txt)?

I ran into this as well. The issue is caused by the CachedCiviContainer cache -- which will write a .php file.

A workaround for this is to set the following constant in the civicrm.settings.php file:

define('CIVICRM_CONTAINER_CACHE', 'never');

Not ideal, as it disables the container cache altogether. But it avoids these issues.


Get the ID for the default organization through API

The default organization contact id is stored in civicrm_domain table. You can use domain api to retrieve the contact id i.e

  $result = civicrm_api3('Domain', 'getvalue', array(
      'sequential' => 1,
      'return' => "contact_id",
      'id' => 1,
    ));

HTH

Pradeep


Unsubscribe link shows all groups in Civicrm

I would suggest using the GDPR extension to manage group subscriptions. The extension will provide finer grained control of which groups are displayed and how they are shown to subscribers etc.


Like William says, the error is due to the geocoding, which may even be happening after the contribution completes. Your system is trying to geocode with the domain http://query.yahooapis.com/ which no longer has a dns entry.

Chances are you are running a very old version of CiviCRM and need to upgrade it, but in any case, you can just remove geocoding in Administer -> System Settings -> Mapping and Geocoding, i.e. this path:

/civicrm/admin/setting/mapping?reset=1

You could install the new geocoding extension at some point, but I'd think your priority would be to get rid of the errors.


Can a CiviRule trigger off a Contribution Custom Field entry?

Right now there is no trigger on custom data for a contribution. You could try though with the "contribution is changed" trigger and see if you can pinpoint your custom field/data with the "field value comparison" conditions?
Obviously you are quite welcome to either add the trigger yourself, or fund CiviCooP (or any other partner that is familiar with CiviRules) adding the trigger :-)


After 5.18.4 Upgrade, Cases are Missing from the List

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

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


"My Registered Events" listing (with cancellation option) for user dashboard page

The feature you're referring to is called the "Contact Dashboard", and it's accessible from https://yoursite.org/civicrm/user in Drupal and Backdrop, not sure about WordPress.
You can add/remove sections from it at Administer menu » Customize Data and Screens » Display Preferences.
It doesn't allow self-service cancellations, but I wrote the extension "Event Self Service from User Dashboard "to deal with this specific scenario.


you are correct, the page is civicrm/csvimporter/import

(as defined here: https://github.com/eileenmcnaughton/nz.co.fuzion.csvimport/blob/master/xml/Menu/csvimport.xml)

Your error is something else, like not having a compatible civicrm version. Can you give more details on your configuration? what version of civicrm and what CMS do you use (drupal, wordpress or joomla)?


How can I import Memberships without membership start date?

Let's assume that you can't edit the CiviCRM files or database  -  or only will do so as a last resort :)

These are existing memberships, so you should be able to export the memberships info with the actual start date, add the start_date to your CSV file and import with the start date.

I'm surprised membership start date is required....I'll ask that question on stack exchange :)


Block locations for events and check conflicting location bookings

Ren, welcome to SE! I think you may need to be clearer about your use case. In particular you say user twice, when I suspect the first may be an admin and the other a general user.

There isn't a mechanism to stop a venue being bookable, but you can make individual events not active in Manage Events >> edit specific event >> location tab. Does that do what you want. You can also allow booking only for a specific time in the online booking tab which may also do what you need. Making some assumptions here of course without more detail.

UPDATE based on comments below. There is currently no facility in CiviCRM to manage allocation of locations. It just holds location as a simple list and does not hold any time information against locations so cannot manage availability. You could write and extension, but it would be quite substantial as you would be doing a room booking system. If you have an external room booking system you might be able to do an integration as an extension but again quite a bit of work. I would suggest something external to CiviCRM as being the easiest option. Maybe a shared calendar.


CiviMail - 'No recipients': nothing added to table civicrm_mailing_recipients

I tried clearing all kinds of caches and rerunning the Smart Group caching several times but to no avail.

I ended up redoing the entire migration and upgrade, and the problem no longer occurs now.

So it's fixed for me, but I have no idea what setting, add-on or cache was responsible.

EDIT: an issue has been opened for this:
https://issues.civicrm.org/jira/browse/CRM-21856


Automated emails generated from activities from address

I think civicrm uses the setting from civicrm/admin/setting/smtp?reset=1, i.e, Administer -> System Setting -> Outbound Email

If the above setting is enabled, civi uses the creator of the activity as a from address in all the email notification.

Set this to No in order to fix this problem.

Note that the above setting acts on your complete site and cannot be configured only for activities.


WP "Call to Action" plugin causes JS errors

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


Why do I get "Access denied; you need (at least one of) the SUPER privilege(s) for this operation" when importing a SQL dump to CiviCRM?

CiviCRM defines MySQL triggers for certain tasks.  When you use phpMyAdmin, mysqldump or similar to export your database to a text file, it exports your triggers as well.  The format is something like this:

/*!50003 CREATE*/ /*!50017 DEFINER=`newpress`@`localhost`*/ /*!50003 TRIGGER civicrm_address_after_insert after insert ON civicrm_address FOR EACH ROW BEGIN

The issue is the DEFINER clause.  This specifies the user whose permissions are used when the trigger runs.  When you import a database, it defines your triggers, but you can NOT define a trigger to run as someone other than yourself.  So if the MySQL username has changed, you must fix your triggers.

You can either a) change the name of the MySQL user listed as the DEFINER, or b) remove the DEFINER portion of the clause altogether.  If you don't specify a user, MySQL will default to DEFINER = CURRENT_USER, which in this case is correct.

You can fix this with a search-and-replace in your favorite text editor.  If that text editor is vim, you can press : and paste this command in to remove all the definer clauses:

%s:/\*\!50017.*localhost`\*/::

EDIT: Chris' regex below is good.  I improved it slightly here:

perl -pi -e 's#\/\*\!5001[7|3].*?`[^\*]*\*\/##g' /path/to/mysqldump.sql


Unable to install CiviCRM 5.0.1 as Drupal site admin

Below link might be useful for work around

Getting permission error when installing CiviCRM under Drupal

HTH

Pradeep


templates_c cache files not being deleted

Cache files are cleared by a scheduled job, which isn't enabled by default.

Go to Administer menu » System Settings » Scheduled Jobs.
Find the row labeled Clean-up Temporary Data and Files.
On that row, click more menu » Enable.


Why do we need new_link in the mysql DSN settings?

If you only ever connected to one database on the same database server yes. If you run e.g. drupal and civi in different databases on the same server you will have problems. Even if you don't, it's theoretically possible a 3rd party civi extension uses its own separate database (but probably rare).


Error on Member Dashboard after upgrading to PHP 7.0

Perhaps allow_url_fopen=1 should be set in PHP.ini file on your web host.


Trouble with Mattermost verification email

There were problems with the email notifications and the issue should now be resolved. If the problem persists, you can email me at: mathieu at civicrm.org.


How can I create a single discount code that will work for multiple CiviEvent?

If you are using the latest version of CiviDiscount Extension, then you should be able to see an option --any event-- on the Discount Form - civicrm/cividiscount/discount/add?reset=1.

If you select this option, you should be able to use the discount code on any event present on the site.


What permissions are needed to renew memberships in back-end?

Just as you need edit_memberships to renew in the back-end out of the box, if you have Enable Access Control by Financial Type turned on you must then grant the corresponding financial types permission(s) that are used for your membership(s). e.g. edit_contributions_of_type_member_dues.


This WordPress site was created using a Microsoft Azure webapp. I imagine that it was a compatibility issue. After creating a designated IIS server with MySql the problem resolved itself.


How do I import contacts through the command line?

When you are importing a large number of contacts, you could face timeout issues when using the user interface. Importing through CLI is an alternative.

There is a file called import.php in /civicrm/civicrm/bin/csv/import.php. We will call this file from the command line.

After you have exported your CSV file, here are the steps for the import:

Put the CSV file on your CiviCRM server, outside the webroot somewhere. (Do not place this file within the website root, or you risk exposing your contacts' data to the internet.)
In the command prompt (shell), type php path/to/import.php -e Contact --file path/to/file.csv (check this forum post for some more detail). Provide an absolute path to the CSV file.
At this point, depending on the contents of your CSV file, you will likely get an error such as ERROR line 2: Mandatory key(s) missing from params array: contact_type. It expects you to pass a contact_type parameter inside the CSV file. If you don't have one in your exported CSV file, you can very easily add a contact_type column in it using a Notepad++ macro (note: turn off autocompletion for words and quotes in Notepadd++ as it may screw up the macro). Just add the new column at the end. Here is an example of a CSV file:

"email","contact_type"
"blabla@example.com","Individual"
"asdf@example.com","Individual"
Now run the command again and you should see a success message for each imported contact. The message looks like this: line 2: created Contact id: 114

The down side is that you cannot (yet) assign a group or a tag to the imported contacts. I looked into the API but could not see an ability to add contacts to groups or tags.

Troubleshooting:

If you get an error such as "cli.php can only be run from command line.", and you wonder about it because you ARE running from the command line, then likely you are using php as cgi/fcgi. To overcome this there is a little hack (which I am not too happy with, but we actually are using the code as intended here). In /bin/cli.class.php, on line 85 the function _accessing_from_cli() checks whether the program is run from CLI. It does this by checking the contents of PHP_SAPI. But according to the first comment here, that variable is not reliable in some cases. So we can modify the function like this:

public function _accessing_from_cli() {
    if (PHP_SAPI === 'cli') {
      return TRUE;
    }
    else {
        /* Temporary hack since the PHP_SAPI check does not work correctly for cgi/fcgi. See first comment here: http://php.net/manual/en/function.php-sapi-name.php */
        return TRUE;
        //trigger_error("cli.php can only be run from command line.", E_USER_ERROR);
    }
  }

After you import your contacts, do not forget to return the file back to its original version.

I really suggest you either configure php to show up errors or make sure you have access to the php error log. This way, if the import suddenly stops after some time, you'll be able to see the reason and take appropriate measures (increase memory_limit, max_execution_time, etc.).


I expect this is due to changes made to accommodate WP URL changes.   If the URL has civiwp in it (and it should) Then I would:

make sure that the base page is set - go to https://example.org/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fadmin%2Fsetting%2Fuf&reset=1

Review the Base Page setting and value, it cannot be blank

Make sure there is a published page that matches the one in that page

If there is no value there, add one, civicrm is the default and then create a WP page with that slug

Make sure the page is public and visiuble to all

Once you've done that (or confirmed the base page exists) Visit this page https://example.org/wp-admin/options-permalink.php

Confirm that your permalinkls are set to anything EXCEPT Plain

If it is set to Plain change to one of the other options and save

If it is not set to plain, you can exit the page

Then retry the form.


WordPress Events Manager Conflict with CiviCRM Registration Pages

Figured it out.

The problem is with Events Manager, which overrides permalinks.

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

For example:

'events/'
'/events/'


How can I record a partial refund for a membership?

Yes you can create refund of overpayment transaction using edit line item extension


What settings are required to display detailed change logging?

I had the same problem - we run four different civi instances.
Two had detailed change logs, two did not.

Across all instances users had same privileges and all four instances had logging enabled.  The difference other than civi versions was that two had change log report. So the change log tab runs off reports.  Steps to fix:

1) check logging enabled in Misc (Undelete, PDFs, Limits, Logging, Captcha, etc)

2) in Admin > CiviReport > Manage Templates.. check the summary and detailed contact logging templates are enabled (as default they were disabled on ours)

3) The MISSING bit... create an actual Contact Logging Report (Summary) from the template.

and that did the trick.

Note: when creating the report clicking 'refresh results' the report failed to load the results - i guess its too large. But save the report anyway and the detailed changes are displayed on the contact record.

Also it does not seem to need the detailed contact change report created only the summary.

Here the documentation that pointed us in the direction of reports to fix the problem  https://docs.civicrm.org/sysadmin/en/latest/setup/logging/

The above worked against: v4.6.22  v4.6.4  v4.6.8  v4.7.20


Recurring payments URL for Vanco payment processor

Mike,  that URL is not needed. Just complete the top 4 lines (userID, password, site URL, API URL)

You do need to send Vanco the URL of the VancoHistory.php file so that they can send recurring notifications on that URL.

Hope this helps


How to disconnect civi contact record from Drupal user

The answer is in the civicrm_uf_match table in your Civicrm database.  Each Drupal user is connected to its corresponding Civi contact record there.

The uf_id column is the Drupal user ID.
The uf_name column is the email address associated with the Drupal user and Civi contact record.
The contact_id column is the Civi contact record ID.

I don't know the ramifications of deleting the row which contains Drupal user 1, but you could certainly create a new Civi contact record (not yourself), and put that new contact ID in the row with uf_id 1 (replacing whatever value is in the contact_id column currently).  Once that is done, you could delete your test contact record safely.

Our Drupal user 1 is associated with a contact record named [myorg] Tech and the email address is tech@[myorg].org.  Thus our default address for mailings come from that address with no problems.

Hope that helps!


If you're using CiviCRM 4.7 or higher, you can find this location by going to Administer menu » System Settings » Directories.  Click the blue circle with the question mark, and note the value for [civicrm.root].  See screenshot:


No I haven't done so. But in Drupal this is possible with the views module. CiviCRM has a great integration with the views module and you could create a view which shows all news within the region of the logged in civicrm contact.

What I would do is to create a custom set with all the regions. This could be custom contacts in civi with a relationship, or a custom select list on the contact card and probably with some coding you could set this field automaticly or let the user select in which region he lives. And this select list you also use at your news artivles to link them to regions.


Why are custom field's multiple choice options all unchecked on contribution page?

Try applying patch from below PR

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

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

HTH

Pradeep


The typical troubleshooting steps here would be to check for errors in the CiviCRM log as well as to check for JavaScript errors in your web browser's console.


How can I deal with "internal server error" during installer?

Is this before displaying the first step of install or once you start the install?

If this is during the installation, it might mean that your timeout is configured in a way that it considers the page dead before it properly has the time to finish the install.

You might want to workaround that by either changing the configuration to allow longer running pages, or try installing from the commandline (using wp-cli).

If it is before displaying anything, it might be that you haven't used the proper url or didn't put the files at the right place or...

If you follow the steps on that page, it should get you a running civi:

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


How Can I Incorporate Profiles in CiviEvent Backend?

this isn't a direct answer to the Q but may be what you want. At the top of Events registration page you should be able to see eg Welcome Joe Doe. (Not Joe Doe, or want to register a different person?) (eg at demo site)

If you click on that option you should then get to a url with cid=0 such as http://d46.demo.civicrm.org/civicrm/event/register?cid=0&reset=1&id=3 and this should allow a back-end user to register someone using the same Profiles etc that anyone would use via the front end.

Is that what you need?


CiviCRM Bulk Email always shows [Civimail Draft] before the subject

You are not sending the final version, you are sending a draft. This is meant to be used to send to you and a few other testers.

The final "official" version is sent when you go to the next step and schedule to send it.

You will need to set up a cron to process the scheduled mailings and send them


Welcome to SE. As far as I know, the timezone is just inherited from the host CMS. I did not have to select any on install and I can change it in the CMS (WordPress in my case). So check what time the CMS believes it to be in.


How do I create contribution pages that record pledges and contributions to households?

I do something very similar with my church. the actual donation is credited to the individual who made it with a soft credit going to the household. This allows us to do reporting by either household or individual.


Perhaps it isn't as clearly documented as would be expected (seeing nothing on front page or /about or /get-started actually talks about CMS) but nevertheless CiviCRM has been built to work with Drupal, Joomla! and WordPress.
Hence the answer is somewhere between 'no' and 'incredibly unlikely' ;-)


I found (on the same instance) that the cause was a munged value for the Localization > Date Formats > Date Input Format.
This string is used to search and replace in the Date Picker from jQuery UI.

Not at all clear how the bad value was saved, but saving an alternate selection and then changing it back cleared up the phenomenon.


Is the Max Participants setting on Events broken in 5.0?

Just did a test with 5.0.1 and wordpress 4.9.5 and it worked like it should.

Have you tried clearing the cache?


How can members change their data on their own?

If Members are also WP users then let them log in and have access to either a CiviCRM Profile (https://docs.civicrm.org/user/en/latest/organising-your-data/profiles/) or a Caldera Form and you should be able to set up the fields you want them to have access to via the form

If Members are NOT WP users then you can send out a Mailing with a checksum link to a Profile so they can make their changes without logging in


CiviMobile: Minimal Permission for CiviMobile

This question is answered here:
https://lab.civicrm.org/extensions/civimobileapi/-/issues/41


How to install a separated Civi database with Drupal 8?

I was able to separate my Drupal 8 database from my CiviCRM database fairly easily, here are my notes I took on how to do it. Note that these steps aren't particularly specific to Drupal 8, and can be used to convert any single-database install into a two-database install.

Create a new database (e.g. "example_civi") on the same server.
Do NOT create a separate MySQL user - just use the same MySQL user
Drupal uses.
Grant permissions to the user.  Here's the permissions you need:

TABLES, CREATE TEMPORARY TABLES, TRIGGER, CREATE ROUTINE, ALTER ROUTINE,
CREATE VIEW, SHOW VIEW, REFERENCES ON ``.* TO ''@'localhost';

Load a dump that just has CiviCRM tables into the new database.  Steps to dump tables by prefix are available. Since you sound like you're potentially upgrading an existing site, you can just copy the existing database instead.
Drop the CiviCRM tables from the Drupal database.  There's a good
explanation of how to remove tables by prefix.

On the last step, note that foreign key constraints will cause some tables not to delete.  You'll either need to run those steps multiple times or disable FK constraints before dropping the tables.

UPDATE:  See also how to enable Views integration on D8 with separated databases.


CIVI-SA-2015-010: VERSION INFORMATION DISCLOSURE

Fix for 4.6 is: https://github.com/civicrm/civicrm-core/pull/7101

Fix for 4.4 is: https://github.com/civicrm/civicrm-core/pull/7102


I haven't been able to recreate this issue on our sites, or on the demo site.

The test I did was:

Add a user with an email address to a group
Include that group in a new CiviMail mailing
1 recipient is displayed (correct)

Change the user to have the 'No bulk email' setting
Create a new CiviMail mailing, including the group
0 recipients are found (correct)

I couldn't see an automated test that ensures this (I've logged this on JIRA: https://issues.civicrm.org/jira/browse/CRM-19473).

What version of CiviCRM are you using that encounters this issue? Are you sending emails straight from Civi or integrating with a third party email provider? Perhaps you could write out the exact steps to recreate the problem?


Mailings -> New mailing gives 404 Not found (NGINX)

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

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


Increasing the maximum number of participants only takes effect if you run the "Update Participant Statuses" scheduled job. If you don't run this in a cron job, you need to do it manually after increasing the size. Be aware this also updates the waitlist and moves people from pending statuses, if applicable.


Need confirmation: Membership scheduled reminders do not sent to any email on bounce lists?

Mail is designed to go out so long as email is not on hold. The point of the bounce thresholds is ensure the system keeps sending to an email address in cases where there is a reasonable prospect that the email will get through. And to not send when the likelihood drops too low.

Suggestions if small propotion of list not seeing email:
1. Have client check spam folder.
2. Set up SPF record for the emailing domain.
3. Reduce 'spamminess' of mailings, eg no attachments, no broken html, no words likely to be flagged.
4. Use a mail delivery service like the Mandrill one we put out when they provided 12k free emails per month (I think minimum spend is now $35-40/month so targetted at bigger installations), or the new SparkPost integration extension.


If I understand you correctly, parent groups work the other round to the way you are trying to use them: you don't add someone to the parent and then to a child group; but instead you add them to a child group and they are regarded as a member of the parent group.

In your case, by adding someone to the Sales Executive-North group, they are automatically part of the Sales Executive parent group.  Similarly when you remove them from the child group, they are no longer part of the parent group (unless they were also in another child group).

As an alternative to parent groups you could use smart groups.


How to link two Organizations with a pair relationship?

Finally it works back to the first approach. The tipping point was to set the organization as first contact in the CiviCRM tab of the webform and then the individual contact and also change the relationship order with Organization being A and Individual being B.
Which means that I can now link two organizations or more through the same individual contact but keep everything related to the membership/contribution at the organization level and find every single needed token with related token extension.
it's a great relief.


As Pete says, not really a Civi question ... but since it is here:

I think there is a typo in the installation instructions at https://www.drupal.org/project/views_data_export_pdf

The first step reads:

  Place WkHtmlToPdf library under ...

but should be:

  Place phpwkhtmltopdf library under ...

phpwkhtmltopdf provides the php files you listed, not WkHtmlToPdf

Note also that 'scr' in the file list should be 'src'


Recurring contribution (monthly) with 'Pay Later'

This extension solves your use case and was designed for that purpose and several other related ones:
https://github.com/adixon/ca.civicrm.contributionrecur
For example, you can track recurring offline payments (whether by bank transfer or other form of recurring payments that don't have a civi extension) by configuring it to auto-generate contributions for those offline payments. Then you just have a monthly reconciliation task to weed out the ones that didn't go through.
It supports both credit card and bank transfer offline recurring payments (using separate 'placeholder' type payment processors).


How do I stop Civicrm front end pages throwing a fatal error?

I tried many things, including restoring files from two months ago, and then updating, joomla and civicrm, and then reconnecting to the current database, and also rebuilding from vanilla copies of joomla and civicrm. But this did not solve the problem. The problem disappeared after I edited and saved the 'registered users' access rights in a minor way. The problem was still resolved after I set the access rights back to how they were. What a relief. Tony, many thanks for your reply.


I can only give my experience in Hungary.

When I started contributing to CiviCRM first I translated the strings in Transifex. I took me a half year to translate nearly all strings.

Translation needed me firstly, beacuse we can use Civi UI translated.
See the Italian pages:
https://www.transifex.com/civicrm/civicrm/language/it/

Later I translated some presentation and tried to spread words about CiviCRM on Hungarian forums, and sites where I can find interested guys.

Visit the Get Involved page: https://civicrm.org/get-involved

The whole documentation translation big chunk of work.


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

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

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

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

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


embedded link in email receipt to edit/cancel recurring contributions link only xml

That’s an old issue; please see here for details/solutions:

https://github.com/iATSPayments/com.iatspayments.civicrm/issues/192


How to show a CSS class of a contribution form based on Stripe iFrame element via jquery?

You can use the Stripe element events to trigger something - see https://stripe.com/docs/js/element/events

We do that in the Stripe extension here: https://lab.civicrm.org/extensions/stripe/-/blob/master/js/civicrm_stripe.js#L281

There are some useful CiviCRM/Stripe extension events which help with frontend integrations and we are open to adding more: https://docs.civicrm.org/stripe/en/latest/events/


With a default-ish theme, the SimpleDonate extension intends to make the form elements bigger and more clicky. In this case that has not worked out - possibly because of other styles introduced by your theme or other plugins.

However: those button styles you're seeing are coming from the SimpleDonate extension. And that's OK - you can address this by overriding with your own theme's CSS. Even just adding a style which cleared the buttons into rows of three would improve what you're seeing.

The liberal use of !important in SimpleDonate's CSS may be a sticking point when overriding the extension's builtin styles. If I had to make that CSS work, the first thing I'd do would be replace every instance of !important with an appropriate CSS selector (and submit the PR back to SimpleDonate).


Webforms vs Contribution pages - workflow

Install the redirect module and make the contribution page URL redirect to the webform.


CiviCRM MailChimp Integration - sync with MailChimp fails

Check the CiviCRM WordPress Permissions page, you need to enable Anonymous Role the permission to execute the Mailchimp Webhooks.


How to exclude contacts from a mailing who share an email with a group of contacts?

You can find all contacts who share a primary email with members of a group, and save those contacts to a Smart Group, using Civi's APIv4. This solution was developed on CiviCRM 5.32.2 and may not work on previous versions.
Navigate to the API4 explorer within your Civi. Then configure a query as in the screenshot below, or paste the following into your URL bar after the word "explorer" and hit enter:
/GroupContact/get?join=[["Email AS contact_A_email",false,null,["contact_id","%3D","contact_A_email.contact_id"],["contact_A_email.id","%3D","contact_A_email.id"]],["Email AS contact_B_email",true,null,["contact_A_email.email","%3D","contact_B_email.email"],["contact_A_email.contact_id","<>","contact_B_email.contact_id"],["contact_B_email.id","%3D","contact_B_email.id"]]]&select=["contact_B_email.contact_id"]&where=[["group_id","%3D","18"],["status","%3D","Added"],["contact_A_email.is_primary","%3D","true"],["contact_B_email.is_primary","%3D","true"]]&limit=0&groupBy=["contact_B_email.contact_id"]

Note you'll need to select your "donated recently" smart group where I have "Email List - CA" in the screenshot. Also, if you'd like to widen the search to include non-primary email addresses, just delete the "where" clauses that refer to "is_primary".
What this is doing is:

GroupContact... get... Where group_id = x and status = added: Search for members of a particular group (in this case, it'll be your "donated recently" group).
Join Email AS contact_A_email...: get those recent donors' email addresses.
Join Email as contact_B_email...: get email addresses that are the same as the ones we just found, but belong to different contacts.
Select contact_B_email.contact_id: return the contacts connected to those matching email addresses.

Once everything is set up, you can click the Save button and create your smart group. Once you have that, you should be able to exclude these contacts from mailings.
(P.S. There's a quirk about APIv4 which forces me to include the "x.id = x.id" clauses in the joins. I might even call it a bug -- so maybe it will be fixed in future versions.)


Matching to existing organisations is determined by the Unsupervised rule for Organisations - go to Contacts > Find and Merge Duplicate Contacts then click Edit Rule on the rule marked Unsupervised to see how it is currently defined.  You can change the existing rule, or create a new one and set its usage to Unsupervised.

Alternatively, you might find this extension useful: https://civicrm.org/extensions/public-autocomplete-of-organisation-names


You can control access to contacts via a number of routes. It might help narrow down the options if you clarify what you consider to be a 'member' ie are they someone who 'pays' a membership fee to cover a specific period, or something vaguer?

One way we have provided the multi-level control that you could use is by treating CiviCRM Relationships (eg between the Branch and the Member) as the control mechanism.

So an 'Officer' who has a relationship to a Branch, can see the Members who have a relationship to the same Branch, but no other contacts.

If the Branch has a relationship to a State level organisation, which then in turn has a relationship to a Federal level (for example) then the permissioning flows up (or down), ie an Officer at the Federal level sees 'all', an Officer at the State level sees all members of all the Branches in that State.

You can read more about this Extension we made for this usage here https://civicrm.org/extensions/relationship-permissions-acls

Otherwise there are built in ACLs that can work off Groups and other CiviCRM features which you can read about here -http://book.civicrm.org/user/current/initial-set-up/permissions-and-access-control/

It may take some thinking through but I would expect CiviCRM can replicate your requirements. HTH


Paypal Payments Pro give 'Internal service Error' on checkout

Not 100% on the route cause however I ditched any customisation and rebuilt from the ground up. I imagine something changed and hasn't been updated to reflect new functionality in the code base.

There was a brief question mark over the paypal checkout button, just need to make sure you are running the latest v4.26 of webform_civicrm.


Best way to make new groups mailinglists by default

I would create a custom extension as explained here or using an existing one and implementing hook_civicrm_buildForm

Updated

function myextension_civicrm_buildForm( $formName, &$form ) {
  if ("CRM_Group_Form_Edit" == $formName) {
    if ($form->getAction() == CRM_Core_Action::ADD) {
      $defaults = array ("group_type[2]" => true);
      $form->setDefaults($defaults);
    }
  }
}

That will make the Mailing list checkbox checked by default.


How should I add sign up forms into 3rd party sites?

Non-programming approach:
Use HTML Snippets for the profile. If it is not working according to documentation in book it might be that a) the documentation needs to be updated, or b) there is a bug in this functionality, or c) there is a bug in the custom page that includes the snippet. I would expect that c), b) and then a) are the likely order of solving this.

NB: when using HTML Snippets, you should ensure that permissions to create all the objects needed for the form (eg custom fields, contacts, etc) are available to an anonymous user.

Programming approach:
a) If you are doing this to allow one other site to callback into CiviCRM, then I would have it call CiviCRM's API via REST - http://wiki.civicrm.org/confluence/display/CRMDOC/Using+the+API#UsingtheAPI-REST.
b) If you are expecting to reuse the form in multiple other sites, then I would create an iFrame via your CMS and include the iFrame from the other sites. The iFrame itself would still need to use the external services protocol at the above link rather than AJAX since in general it will not have logged in before posting.


Just installed Webform CiviCRM and cannot see the CiviCRM tab on webforms

Clear Drupal's cache from your browser (not via Drush).


Commas displayed instead of selected responses from a multi-select field on Confirmation page for CiviEvent registration

This is now fixed in 5.16.2 version. You can either upgrade CiviCRM to 5.16.2 or apply patch from here.

Cheers

Pradeep


It might be that the column that you are trying to get in your saved search no longer exists? It is trying to find a record in the table civicrm_saved_search with and id of 71. Can you check if that record exists and what it looks like?


You must enable the ‘Enable multiple bulk email address for a contact’ option from CiviMail component settings.

Administer > CiviMail > CiviMail component settings

/civicrm/admin/setting/preferences/mailing?reset=1


Current Employer style field for a custom field

You might have already checked field like "Current Employer" that creates new organization and relationship. Post hook is the most straight-forward and correct way to proceed here.

You could give a common prefix kind of name to your custom field and write your code in such a way that it performs the action only when custom field has that prefix in the title/name. This way, you won't need to modify the extension every time a new custom field is added.


Outlook Extension / Filing previously sent emails into CiviCRM

You can also use the email processor, described at https://docs.civicrm.org/sysadmin/en/latest/setup/civimail/inbound/#autofiling-email-activities-via-emailprocessor.

You can either set it up where you make a subfolder in your outlook and then anything you drag in there gets filed into CiviCRM, or you can set up a separate shared email address and forward emails to it to have them go into CiviCRM.

The downside to the first one is you have to give civi access to your own mailbox by storing your password in civi.
The downside to the second one for emails you've already sent is that they all get filed under your own contact, but if you're sending a new email you can bcc the shared address and then it gets filed on the correct contacts.


CiviRules - When does the 'Membership Payment Added' trigger fire?

I had this issue too with event registrations, I added a five minute delay to the civirule and it seemed to clear up that issue.


Send Schedule Mailings job succeeds but scheduled mailing not completely sent

We found that applying this line's change from this PR to the mosaico extension solved our problem: https://github.com/veda-consulting/uk.co.vedaconsulting.mosaico/pull/182/files#diff-d8205fe762b98a885815f3d4bb175886R294


What is the best way to disable the jquery.crmEditable.js file in CiviCRM without modifying the core common.js file?

You can setup ACL to restrict custom group edit to certain group contacts. This will stop them to update the custom field data and only view it.


Contact Summary Layout based on relationship

How about creating a Smart group for each relationship type or so and having the layout available to group of contact. If not using Apiwrapper hook you can alter the filters of 'ContactLayout' entity.


Preventing slow performance with smart groups

Do you have a few smart groups on which many others depend? If so it's worth making sure they're as quick as possible. We have a script that generates the important ones once per hour - but by putting the contacts into regular groups, rather than smart groups. Regular groups are much faster, and that speeds things up a bit.

We've also turned off smart group caching. This very much depends on your use-case. But if you have a lot of intermittently-used smart groups it can be better to generate each one as needed rather than have a cron job regularly slow everything down by generating them all. But obviously ymmv on this.


I did not work on the site, but looking at the source code from View Source in the browser, it looks like the Bootstrap theme was the main theme, and then they created a subtheme called "civicrm_bootstrap" off of that.


PayPal PSD2 - new European Union directive from 14th September 2019

Because CiviCRM is open source there is no supplier who you could ask to do this.
Basicly it comes down that someone develops the software to work with the new standard.

In Open Source we have a saying that you have to scratch your own itch. Means that if your organisation is dependent on credit card payments and paypal, your organisation has to make sure it keeps working because its your organisation who would suffer.

If you have a developer in your organisation then he or she could do the job. But If you dont have a developer you have to fund a developer to make it working for you.

In this case, there is a likely change that other organisations are also willing to contribute (eg developer resources or funding). But you have to find them and come together.


What happended to the ability to expand parent groups in the Manage Groups page?

As you noted in the comments below, there is a JIRA discussion about this issue. The issue has been tracked down, and a patch submitted (which is now in Q&A and slated for 4.7.8).

Per @jitendrapurohit on the Jira thread above:

  Submitted a PR - https://github.com/civicrm/civicrm-core/pull/8323

  1) First issue mentioned above was the regression of CRM-18184. Seems
  the patch attached on that was different from the PR submitted. This
  was later fixed in this PR
  https://github.com/civicrm/civicrm-core/pull/8020

  2) Second point was a regression of this commit. The updated params
  loses the key('parentsOnly') sent from $_GET.


How to match Activities to Contacts during import?

Export the contacts with their contact ID, first name and last name.  (Hopefully you have a way of searching for just the new contacts, but if not, exporting a larger group of contacts will be OK)

Open each CSV in something like Excel or Calc and create a combined "First Last name column in both.  You can then use vlookup (in Excel) or the equivalent in Calc to add the contact id to the list of activites you want to import.


Contact Us form based on smart group list

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)'.


Strange error when updating 5.23.0 Joomla

I have updated the lines 824 en 825 in CRM/CORE/Resources.php with a dirty solution:

$map = ['bower_components' => str_replace('Joomla/Joomla','Joomla',rtrim(Civi::paths()->getUrl('[civicrm.bower]/.', 'absolute'), '/')),
      'packages' => str_replace('Joomla/Joomla','Joomla',rtrim(Civi::paths()->getUrl('[civicrm.packages]/.', 'absolute'), '/')),
    ];

It can not be the real solution but the site is now working and i have just completed succesful the database-upgrade. Maybe only a problem with sites on Windows.


How to use civivolunteer description text

The role description is currently used in two primary places.

On your volunteer opportunities page, you'll notice a small quote bubble next to each role that has a description defined.  Clicking the bubble will bring up a popup listing the description.

The other place the description is used is in the confirmation email sent to the volunteer after signup.


Up to what version of CiviCRM is secure to upgrade on a Drupal 6 site?

Pete is right that even recent versions of CiviCRM (certainly in the 4.6.x series) work with Drupal 6 sites.  The "no longer officially supports" issue is that the core team won't go out of their way to make D6-specific fixes.

That said, I have encountered problems with new installations on Drupal 6, but this has been for testing--why else would someone build a new site on Drupal 6?


Can you use a theme with side bar items with shoreditch?

I just tested Adminimal on a site with shoreditch, and while not pretty, i did get a sidebar


How do CiviCRM profiles hook up with Drupal?

The question was 'how do I debug this from first principles' so that I don't have to work from my sometimes flawed knowledge of the application.

The solution was to turn off a panel that was overriding the CiviCRM forms. This is readily discovered by looking at HTML source code as panels prints out the panels classes and they didn't look right.

Trying to debug the source code was no use in this case and cost a couple of days effort. If you want to check that civicrm is running or follow the form creation process start at civicrm_form_alter() in a drupal system.


Did you change browser?

I experience that Firefox fails to show graphs in CiviCRM, even though it displays without problems in Chrome or Safari


Installing CIVICRM ver. 5.32.2 on Joomla

Joomla version 3.9.23 introduced an issue: unzipping an install file with several zips inside itself won't work. This causes the behavior you describe.
In the next version this issue will be solved. You solve the issue now by manually installing a patch made by Yootheme, which can be found here:
https://yootheme.com/support/question/142357


I have also seen this problem, and fixed it. It's nothing to do with CiviCRM at all - it's a recent change made by Google regarding their API and your authorisation to use it.  Existing users seem to be OK, but new users (ie. one of my clients) or maybe even new maps seem to be affected.  You should review your  authorisation to use the Google API for your domain.  It's a slightly confusing situation because it appears that you don't need to enter your API key on Civi anymore, but you do need to be authorised by Google.


Legacy SQL Activity and Contacts Dump Transfer

For contacts and activities you could use the built in import functions If you want to migrate/import entities for which there is usually no gui (such as events), you could try this extension: https://civicrm.org/extensions/api-csv-import-gui

I am not sure if it works for profiles though. You could of course use the Rest API as well and for example code a script to import everything but the first time this would probably take a while to get your head around.


How can I include a non-participant's details in the receipts?

It's a slightly different question but you should be able to use the same technique as described here, i.e. use the api in your message template to look up the info:
https://civicrm.stackexchange.com/a/29232/181


You have all the control of your custom table but always it is not advised to change custom field type in the database

Better way of doing this would be

In DB - Create a temp table of the same and move all the records to the temp table first

In the front end - delete the column with varchar and create a new one with int with the same name

In DB - move all the value from temp table to the custom field

I guess this helps !!!


HOWTO: provide log-in (uid and pass) to Civicrm Contact - NEW or Existing

There are several ways to go about this.

I wrote a somewhat convoluted guide a couple of years ago for creating a Drupal contact for a bunch of existing Civi contacts:
http://wiki.civicrm.org/confluence/display/CRMDOC/Creating+a+Drupal+user+for+every+CiviCRM+contact

However, I'd say the best practice today is to use the civicrm_entity Drupal module in combination with the rules module to automate this.  There's an excellent blog post about that here: https://civicrm.org/blogs/petednz/creating-drupal-users-made-easy-single-or-multiple-contacts-civi-imports-and-webforms


CiviCRM Webform - enforce ACL permissions

Have you seen this extension:

https://civicrm.org/extensions/relationship-permissions-acls

It makes the permission flag on a relationship work like a true ACL.

But then perhaps you don't have relationships to work with?

So:
- create a relationship between your Primary Contact and the Contacts he/she has access to [e.g. Counselor and the kids in the Youth Program]
- via webform_civicrm and the additional extension above you can pull in all a Counselor's Contacts on a webform -> with enforce permissions true
- don't allow the Counselor to create new contacts - and lock a Contact's fields; that way the activity can only be created if the Counselor has the necessary permissions to view that contact.

To make the form not accessible to certain users who don't have the necessary permissions in CiviCRM (ACL) -> put your ACL allow users into a CiviCRM Group -> then use GroupRole Sync module to assign these users automatically to a Role when they login -> then configure your form such that only users with that role are allowed to Submit the form.


How do I expose CiviCRM forms in WordPress?

To publish CiviCRM forms in WordPress you need to put a CiviCRM shortcode in some content exposed to site visitors, such as a Post or Page:

Click to select a CiviCRM front-end form or page:

Then select one of the CiviCRM front-end content types. Depending on which one you choose, different options become available:

Note that only active CiviCRM content can be published, so if you don't see a contribution page or event or profile you just created in the dropdown list, go back to CiviCRM and make sure it is active.

For Contribution Pages, navigate to Contributions > Manage Contributions, beside relevant page click Configure > Title and Settings, then at bottom of page click to enable Is this Online Contribution Page Active?

For Events, navigate to Events > Manage Events, beside relevant event click Configure > Title and Settings, then at bottom of the page click to enable Is this Event Active?

For Profiles, navigate to Administer > Customize Data and Screens > Profiles, beside the relevant profile click more > Enable.


'View in browser' link on mailing gives 'Access denied' error

You need to change the permissions to allow the public to view the mailing.

This permission is called: 'CiviMail: view public CiviMail content'.  This should be assigned to the anonymous role (or all user roles).

You also need to ensure that the mailing visibility is set to 'Public pages' for each mailing that you want to be available to view.  This setting is found under 'Publication'.


Marilyn - I didn't see your CiviCRM version but from what I see (CiviCRM 4.4) status of members w/end date in the past is not changed from the initial status ('New') and the job logs 'success' every time after examining x 'memberships', updated 0 records. I suspect the job is only logging status- I'll try debugging, and send a patch. BTW, I tried this on the 'Demo' system (WP) and it seems to work.

So - have you checked the 'Membership Status Rules' (Administer>CiviMember>Membership Status Rules)?  You have to set those rules up to make your memberships transition from one status to the next, there are optional grace periods etc.  Also, what is the weight of your pending status rule? The 'weight' governs the order your memberships transition, another post had an issue w/that: https://forum.civicrm.org/index.php?topic=13921.0

Finally, there is this:
http://wiki.civicrm.org:8090/confluence/display/CRMDOC22/Update+Pending+Memberships (mind you this doc is from 2009)
HTH


Problem processing inbound emails to activities

Yes it sounds like it's hitting an email it doesn't know how to parse - see the code for that function formatMailPart() where it fails (https://raw.githubusercontent.com/civicrm/civicrm-core/master/CRM/Utils/Mail/Incoming.php). Can you tell which email? Anything odd about it? In particular if you view the message source there might be a "Content-Type:" line with an unsupported type.

That "fix" for 4.7 all it does is just skips the email instead of a fatal error, but you'd still have an email that doesn't get processed.


Event Registration Form - Page Automatically Refreshing

@stechsla,

Mate, that‘s a really old version of CiviCRM. There are literally hundreds of bugs on that that were fixed years ago. Definitely time you upgraded to 4.4 (there‘s a case to be made to get you all the way to 4.6!) - in my view there‘s little point in attempting to address this issue as an upgrade would likely fix this, a raft of other problems, and give you vital security upgrades, not to mention cracking new features, a faster system, and a slicker interface.

If you‘re interested in having your system upgraded then your sysadmin should be able to help you. If you would rather someone else do it, please contact myself (john@civifirst.com - proud presenter of a presentation called "upgrading your upgrade") or a CiviCRM partner agency, details of which are available on civicrm.org.


Can’t embed any forms using a block editor in Wordpress

I will take a wild guess here since we don't know the versions or Wordpress and CiviCRM and which block. Since you mentioned the block editor, which does not provide a CiviCRM block, I will guess that you are using a TinyMCE block that still displays a CiviCRM button -- perhaps the Classic block or Classic Paragraph block?
In my case (Wordpress 5.4.2 and CiviCRM 5.27.0), I no longer see a CiviCRM button. This is consistent with documentation at https://docs.civicrm.org/sysadmin/en/latest/integration/wordpress/. Instead, I use the Shortcode block or I directly enter a CiviCRM shortcode in a paragraph block, using the shortcode formats described in the doc.


Look for error message in civicrm error log

.../wp-content/plugins/files/civicrm/ConfigAndLog

where you will get more details of the error

If you don't have any error message in civicrm logs look for PHP error logs where you will find it

refer: https://wiki.civicrm.org/confluence/display/CRMDOC/Debugging+for+developers

I guess this helps!!!


So, I might not be able to answer the question regarding the smart group criteria required to set the date always to 'today' (I had a look into this and confirmed your description that the criteria gets "translated" from 'today' into the date for today, and will remain that way afterwards).

However, if you're looking to send an email to each contact created in the system then you could look into using the scheduled reminders system for this. Under Entity you can select Contact > Created date only, which might help with your scenario.

The downside to this though is that you'll need to be sending out the same message to each user (although you can use tokens to personalise this!).


payment page - total not correct when using Tax

Sales Taxes in CiviCRM are added on checkout - so if you want to get to nice rounded numbers you may need to give your participant_fee a few more decimals.

Glad that worked for you Ben!


Joomla Backend (Admin), CIVI White Page after installation

A white screen (WSoD or "white screen of death") indicates that PHP is configured not to display errors, and has hit an error which it can't recover from. The result is an empty page.

Your next step is not to fix the error but to give yourself enough information to identify the source of the error.

Viewing errors in logfiles

The webserver can be configured to display errors to screen, but it also logs errors to files on disk. These files vary depending on your hosting environment, so you might consult your webhost's documentation to locate them. You might look for errors in some of these locations depending on webserver/php config -

/var/log/nginx/*err*log       # NginX webserver error logs
/var/log/apache2/*err*log     # Apache webserver & mod_php error logs
/var/log/*php*log             # PHP-FPM & PHP-CGI error logs
/var/log/php5/*log            # PHP-FPM & PHP-CGI error logs
/path/to/site/err*log         # Some hosting environments

And a CiviCRM specific file - location varies depending on hosting environment AND CMS -

path/to/site/path/to/civicrm/files/ConfigAndLog/CiviCRM*log

(The *s above represent a wildcard, not an actual filename. Eg the last entry might be public_html/error_log on Bluehost.)

Once you've located these files, you can download them to view, or you can use tools like tail or less +F to follow the files. I prefer to follow logfiles because you can watch the error appear each time.

Displaying errors to screen

You may prefer to display errors to screen. This is probably disabled on your site because it's a security risk to some degree - an attacker can see more information when errors are visible, so the default configuration is often to restrict visibility to people with server access (via the logfiles above).

To enable errors, either configure your PHP to display errors for your site via php.ini / .htaccess (see How can I get PHP errors to display OR add this code (you can add it in civicrm.settings.php or the top of the index.php of your host CMS).

<?php
  error_reporting(E_ALL);
  ini_set('display_errors', TRUE);
  ini_set('display_startup_errors', TRUE);

Making sense of what you see

Once you've taken one of the above approaches, try reproducing the actions which lead to a white screen. If all's gone well, you should see an error (on screen or in your terminal / SSH session).

This is where you can start debugging meaningfully. There's a good chance you're exhausting server resources (timeouts, memory exhaustion) or hitting some coding error, but once you have the relevant error message at hand you'll be much better equipped to track down the source of the problem affecting your site.

Further reading

Stack Overflow: How do I get PHP errors to display?
Where should one look for logs when debugging a new problem?
Drupal.org: Blank pages or White Screen of Death
Joomla SE: What is an efficient way to troubleshoot a White Screen of Death

Notes

If this is the first time you've looked, there may be other errors visible which don't relate to the problem at hand. You may need to discern what the actual problem is still.

If you're not familiar with UNIX, this may seem like a lot of effort. It's a lot of effort to guess your way through debugging a problem though!


Is there a payment processor extension for Worldpay or do we need to create one?

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

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


How to access the APIv3 from wordpress plugin files

Try prefixing your API call with:

civicrm_initialize();

The "class.api.php" is for when you want to use the REST API from an external site.


Smarty only generating nulls from API calls

So, for posterity's sake, I wanted to share the answer I figured out.

When I looked at the Source view of the email in CiviCRM, I realized that the code had pasted as

id:&nbsp;{contact.contact_id}

smarty id: {$contact_id}

{crmAPI var=&#39;result&#39; entity=&#39;Contact&#39; action=&#39;get&#39; id=203}

{$result|@debug_print_var}

instead of

{capture assign=contact_id}{contact.contact_id}{/capture}

id: {contact.contact_id}

smarty id: {$contact_id}

{crmAPI var='result' entity='Contact' action='get' id=203}

{$result|@debug_print_var}

When I composed the code correctly in the Source view rather than the HTML view, everything worked as expected!


Event Scheduled Reminders set for *Before* start dates won't send to participants registering *After* the start date

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

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

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

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


Any reason why an organisation should NOT register for an event?

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

HTH

Pradeep


civicrm_activity is a legitimate table with legitimate data.  You can use the API to mass-delete activities - but only you (and/or your users) can determine what represents data that is reasonable to delete.

If it's that large, I suspect it's quite likely that you're sending frequent mailings to large groups of people - the mailing history might be reasonable thing to delete.


If you are working with Microsoft Excel 2000 or later, you can use the following steps.

Select the "Data" tab. You should see an option that say "Text to columns". Highlight your column and choose that. A little window should pop up to walk you though, but you'll want to choose "Delimited" (next) and that your separator is a comma. When you click finish, this will put the data between each comma into a new cell.


KCFinder browser shows empty pop-up window. How to debug?

There used to be a requirement that the URLs that Andrei referred to above could not contain symbolic links. I don't know if that is still the case, but make sure that all directories in that path are true directories and not symbolic links.


Contrbution Summary report on Average Contribution?

the summary field extension may be your friend allthough you may hav to tweek/extend it a little bit when it comes to time frames.


Send civicrm email receipt immediately for recurring contributions - Authorize.net

You could probably achieve this with the CiviRules extension? The extension can be found here: https://civicrm.org/extensions/civirules/version-113 and the documentation here: https://docs.civicrm.org/civirules/en/latest/


non technical approach to associate contributions with memberships

org.civicoop.membershippayment does this and only this.


WP - Errors after update from 4.6 LTS to 4.7

This is highly due to one of the custom extension enabled on your site. Few steps you could try to fix this -

Check if any of the extension overrides the file CRM/Core/Config.php. If you find it, move it outside the site dir and disable that extension after reloading the page.
Manually disable the extension from the database one by one and try to reload the page. To disable the ext, set is_active value to 0 in civicrm_extension table. (Remember to revert it back if the page reload is still an error).
Check if the custom php directory overrides the core file CRM/Core/Config.php. If yes, do the same as step 1.


Limit contact access to the user's group

For some scenarios it is better to provide the ACL by using Relationships to 'join the dots', rather than using Groups, and this allows you to then create multi-level ACLs.

If someone (X) has Permissioned Relationship to Org 1
and Org 1 has permission to Org 1.1,
and person Y has permission to Org 1.1
and if Org 1.1 has permissioned relationship to Z, then
X will see Y and Z
Y will see Z
Oh, and you don't need to add any ACLs at all, this is taken care of via this Fuzion Extension

May not be quite what you need but may be useful to others who read your ticket and who could switch to having Relationships at the heart of the ACL requirements.


Check the civi log for more details. It looks like you're using drupal so it's either under sites/warrington.healthwatchcrm.co.uk/files/civicrm/ConfigAndLog or sites/default/files/civicrm/ConfigAndLog.


Making the Event Registration icon larger

You need to start from a basic familiarity with how to style webpages. I suggest googling a few simple tutorials on css.


Thank you for adding the screenshot - it makes the issue much clearer.  I actually haven't used this feature before and it seems to be undocumented :(  That said, I was able to use it successfully on my local install.

While this might be a bug you're seeing, I looked at the code and am suspecting a MIME misconfiguration in the website software settings.  To help track down which it is, I recommend editing the file at <civiroot>/CRM/Admin/Form/MessageTemplates.php.

Find this line:
$errors['file_id'] = ts('Invalid document file format');

Replace it with:
$errors['file_id'] = 'MIME type: ' . $files['file_id']['type'];

The acceptable values are:

docx: application/vnd.openxmlformats-officedocument.wordprocessingml.document
odt: application/vnd.oasis.opendocument.text

If you're getting a different value, hopefully it will provide a helpful clue as to the problem.  If not, please edit the question again to show the error you're getting.


Cannot edit CiviCase Activity Status from list view

As a clue to lead to possible answer, I am seeing the same kind of issue when I try to edit an activity. Drop-down boxes (e.g., status) and search-for-match fields (e.g.,assignees) are hidden behind the activity screen and, even if the screen is minimized, do not allow editing when clicked. We are WordPress 4.97, CiviCRM 5.3.2. This is the first we've encountered this.


After upgrading to 4.6.18, cannot enter credit card details in event registration

I had a look and can you entire billing block is indeed MIA.

Two thoughts:

1) get into the Event Registration Config and try re-adding the Payment Processor - re-save

2) check for errors in your ConfigAndLog/ when you load this form

EDIT - more thoughts:

3) check the Payment Processors their config - and create a (Test) Contribution page where you run a transaction with a fake credit card

4) (in general) check the Manage Extensions screen and look if there are any upgrades for your Payment Processor (of course this only applies to those which are not baked in core)