# Question
Title: Error whilst sending email via Mandrill extension on Wordpress / Civi 4.7alpha5
When attempting to send an email to event participants (via participant listing \> action \> send email), I receive the following error:

> Cannot read unrecognized property CRM\_Core\_Config::$civiVersion.

Upon trying to send to them as a group via CiviMail, I also get the same error in my process\_mailing log

Any advice on how to resolve this would be appreciated!

Running CiviCRM 4.7alpha5 on Wordpress 4.3.1 with Mandrill and Clickatell extensions installed

# Answer
JMA will be releasing a version of the extension that works with 4.7 in the first week of February. Sorry for the inconvenience.
> 3 votes

# Answer
You are using an unreleased version where you can expect a few bugs. So I guess you ran into one.

You would help the developers if you add this bug to the issue tracking system of CiviCRM at https://issues.civicrm.org
> 1 votes

---
Tags: civimail, mandrill
---


# Question
Title: Missing payment fields on membership renewal
Hi, for some reason the fields for payment of the renewal of membership are missing. Is it something with configuration? Version is 4.7, but the issue was there even before the upgrade br, M

# Answer
In the screenshot the "membership organisation and type" field is empty. Did you blank it out or have you disabled the relevant membership type? Without a membership type with an associated fee there won't be any payment fields.
> 1 votes

---
Tags: civicontribute, civimember, joomla
---


# Question
Title: Delivery has not yet begun for this mailing
when i send mail (**Mailing-\> New Mailing**) the mail won't send and i get this message when i view the mail report

> Delivery has not yet begun for this mailing. If the scheduled delivery date and time is past, ask the system administrator or technical support contact for your site to verify that the automated mailer task ('cron job') is running - and how frequently.

The Send **Scheduled Mailings** from **Administer-\> System Setting-\> Scheduled Jobs** is enabled and when i **Execute now** manually it works fine. The **Send test** functionality also work fine.

# Answer
> 2 votes
Did you set up cron? All Scheduled Jobs are executed by cron.

http://wiki.civicrm.org/confluence/display/CRMDOC/Managing+Scheduled+Jobs

---
Tags: civimail, cron-job
---


# Question
Title: What to do about "File 'Array' presents a security risk and should be deleted." on 4.7?
After some brief difficulty upgrading from Civi 4.6.x to 4.7.0, we managed to get it done, with one small hiccup. Post-installation, we got a notification saying:

```
File 'Array' presents a security risk and should be deleted.

```

I looked in our CiviCRM directory, and found 2 files called "Array.php" I tried temporarily relocating both of those files, but no luck; the error still displayed. Any leads as to how to resolve this issue would help--it makes me uncomfortable to have the system status as "Critical."

Thanks!

# Answer
CiviCRM is *not* warning you about a file named `Array.php`, the confusing error message is because it's rendering a PHP array to a text string.

I've opened an issue in JIRA about this and submitted a suggested quick fix:

CRM-17909: File 'Array' presents a security risk and should be deleted.

It looks like the fix is as simple as adding `[0]` as shown in this Github commit.

If you can test the fix from that issue on your site, and confirm that the error message shows a more helpful result when you've done so, that will help us get the fix into the next 4.7.x release.
> 6 votes

---
Tags: upgrade, 4.7
---


# Question
Title: From email addresses with 4 character domain names or non-normal domains
I am attempting to add a From email address with a .club domain. Civi is stating, "Please follow the proper format for From Email Address" when I try to save the email address. I looked for the error in all of my civicrm plug files and found one line in CRM\Admin\Form\Options.php that has text below. I thought perhaps the "3" was the length of the domain name having to be 3. I changed to 4 and still the same error. Has any one had experience in Civi with "non-normal" domains other than the usual suspects (e.g., .org, .com, etc.)?

```
  $formName = explode('"', $fields['label']);
  if (empty($formName[1]) || count($formName) != 3) {
    $errors['label'] = ts('Please follow the proper format for From Email Address');
  }
}

```

# Answer
The most likely cause of this error is that the email was entered in the format `myname@example.org` rather than a name and email in the format `My Name <myname@example.org>`.

While the field label at `civicrm/admin/options/from_email_address?reset=1` says **From Email Address**, the field actually requires you to enter a **sender name** *and* **email address**.

The field help says,

> Include double-quotes (") around the name and angle-brackets (\< \>) around the email address. EXAMPLE: "Client Services"
> 1 votes

---
Tags: email
---


# Question
Title: How can I add additional clients to a case?
I want to be able to add additional clients to some cases. The ability to do this used to be configurable via the case settings XML file before the configuration got moved into the UI. What's the current approach (version 4.6.x)?

# Answer
From a comment by Coleman on June 18, 2015 regarding a question at civicrm.stackexchange.com/.../module-or-extension-to-use-for-tracking-agreements

```
> You can setup CiviCase to enable multiple clients per case, by editing
> your xml/configuration/Settings.xml file. Set
> <AllowMultipleCaseClients>1</AllowMultipleCaseClients>

```
> 1 votes

---
Tags: civicase
---


# Question
Title: Upgrading from Drupal 7.41 CiviCRM 4.3 to 4.6.9 returns Queue runner must be configured before execution
The queue looks like this; \[Error: undefined\] Exception: "Queue runner must be configured before execution."

```
#0 /home/leavenco/public_html/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php(106): CRM_Queue_Page_AJAX::{closure}()
#1 /home/leavenco/public_html/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php(54): CRM_Queue_ErrorPolicy->call(Object(Closure))
#2 [internal function](): CRM_Queue_Page_AJAX::runNext()
#3 /home/leavenco/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(278): call_user_func((Array:2))
#4 /home/leavenco/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:4))
#5 /home/leavenco/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:5))
#6 /home/leavenco/public_html/sites/all/modules/civicrm/drupal/civicrm.module(489): CRM_Core_Invoke::invoke((Array:5))
#7 [internal function](): civicrm_invoke("upgrade", "queue", "ajax", "runNext")
#8 /home/leavenco/public_html/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:4))
#9 /home/leavenco/public_html/index.php(21): menu_execute_active_handler()
#10 {main}

```

---

Clearing the cache got me through the Queue error, thanks.

Now I'm getting the following, which may somehow be related: FieldException: "Cannot change an existing field's type."

```
#0 /home/leavenco/public_html/sites/all/modules/features/includes/features.field.inc(175): field_update_field((Array:11))
#1 [internal function](): field_features_rebuild("events_calendar_feature", "field")
#2 /home/leavenco/public_html/sites/all/modules/features/features.module(516): call_user_func_array("field_features_rebuild", (Array:2))
#3 /home/leavenco/public_html/sites/all/modules/features/features.module(871): features_invoke("field", "features_rebuild", "events_calendar_feature")
#4 /home/leavenco/public_html/sites/all/modules/features/features.module(893): _features_restore("rebuild", (Array:0))
#5 /home/leavenco/public_html/sites/all/modules/features/features.module(229): features_rebuild()
#6 [internal function](): features_flush_caches()
#7 /home/leavenco/public_html/includes/module.inc(934): call_user_func_array("features_flush_caches", (Array:0))
#8 /home/leavenco/public_html/includes/common.inc(7625): module_invoke_all("flush_caches")
#9 /home/leavenco/public_html/sites/all/modules/civicrm/CRM/Utils/System/DrupalBase.php(294): drupal_flush_all_caches()
#10 /home/leavenco/public_html/sites/all/modules/civicrm/CRM/Upgrade/Form.php(728): CRM_Utils_System_DrupalBase->flush()
#11 [internal function](): CRM_Upgrade_Form::doIncrementalUpgradeFinish(Object(CRM_Queue_TaskContext), "4.4.5", "4.4.4", "4.6.9", "/tmp/civicrm-post-upgradex9Pctt")
#12 /home/leavenco/public_html/sites/all/modules/civicrm/CRM/Queue/Task.php(88): call_user_func_array((Array:2), (Array:5))
#13 /home/leavenco/public_html/sites/all/modules/civicrm/CRM/Queue/Runner.php(214): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
#14 /home/leavenco/public_html/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php(52): CRM_Queue_Runner->runNext(TRUE)
#15 /home/leavenco/public_html/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php(106): CRM_Queue_Page_AJAX::{closure}()
#16 /home/leavenco/public_html/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php(54): CRM_Queue_ErrorPolicy->call(Object(Closure))
#17 [internal function](): CRM_Queue_Page_AJAX::runNext()
#18 /home/leavenco/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(278): call_user_func((Array:2))
#19 /home/leavenco/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:13))
#20 /home/leavenco/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:5))
#21 /home/leavenco/public_html/sites/all/modules/civicrm/drupal/civicrm.module(489): CRM_Core_Invoke::invoke((Array:5))
#22 [internal function](): civicrm_invoke("upgrade", "queue", "ajax", "runNext")
#23 /home/leavenco/public_html/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:4))
#24 /home/leavenco/public_html/index.php(21): menu_execute_active_handler()
#25 {main}

```

# Answer
I was able to fix it by clearing the CiviCRM cache, and then re-starting the update.

I had been using the CiviCRM Clear All Caches Drupal module, but I'm not sure if it had cleared everything, as I had an error related to that module. As a result, I emptied the civicrm\_cache table directly in the database, using phpMyAdmin.

I just got the same error today, myself, when doing an upgrade from CiviCRM 4.6.3 to 4.6.9. This thread was one of the things that suggested this solution to me: https://www.drupal.org/node/2155689.

If this (or another) solutions works for you, you may want to update your other post about this as well: http://letmeask.co/foxfeedspro/details/item\_115876/upgrading-from-drupal-7-41-civicrm-4-3-to-4-6-9-returns-queue-runner-must-b/. Hope it works for you!
> 3 votes

# Answer
I also had this problem (\[Error: undefined\] Exception: "Queue runner must be configured before execution.") when trying to upgrade from 4.4.7 to 4.6.10 - I ended up using Drush to complete the upgrade (drush @site.env civicrm-upgrade-db) but found that I had a fatal error about not being able to create the files/civicrm directory (which already existed of course). The error message prompted me to clear the 'config\_backend' field in the civicrm\_domain table which I duly did.

```
Error: Could not create directory: /srv/bindings/aacaad9724834919b5c78d62579e7186/files/civicrm.<p>If you have moved an existing CiviCRM installation from one location or server to another there are several steps you will need to follow. They are detailed on this CiviCRM wiki page - <a href="http://wiki.civicrm.org/confluence/display/CRMDOC/Moving+an+Existing+Installation+to+a+New+Server+or+Location"  target="_blank" class="crm-doc-link no-popup" title="Opens documentation in a new window.">(learn more...)</a>. A fix for the specific problem that caused this error message to be displayed is to set the value of the config_backend column in the civicrm_domain table to NULL. However we strongly recommend that you review and follow all the steps in that document.</p>Drush command terminated abnormally due to an unrecoverable error.       [error]

```

After running a quick "update civicrm\_domain set config\_backend = '';" and rerunning the drush civicrm-upgrade-db the upgrade completed successfully.
> 0 votes

---
Tags: upgrade
---


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

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

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

Seamus
> 4 votes

---
Tags: civievent, custom-fields, error
---


# Question
Title: Setting up Webform CiviCRM with an optional contribution/payment
I have a Webform-CiviCRM form that has CiviCRM functionality enabled. It has a contribution field tied to a CiviCRM contribution page using the Stripe payment extension, and which has no minimum value required. I've set it up as a radio button with a choice of a monetary contribution of a set amount, or zero.

Whenever I try to use the form and select the zero dollar option, the credit card fields disappear as expected, but then on form submit I get this message:

> **Payment Error Response:** Error: The card number is not a valid credit card number.

Is this a Stripe extension issue or a Webform-CiviCRM issue?

# Answer
It was a Stripe Payment Extension issue. I thought I was on the latest version but must have been a few commits back. Updating the files to the latest `4.6-dev` version and then visiting the **Manage Extensions** page to run database updates was all I needed.
> 2 votes

---
Tags: civicontribute, webform-civicrm, stripe
---


# Question
Title: How to set a constant value for a field in webform (eg the prefered language)?
I'm creating several webforms in different languages to let people register to receive more information. I would like to set their preferred language to the language used in the form rather than the default (en\_US).

I have similar needs for some custom fields.

How can I do that?

# Answer
> 3 votes
What I found is:

* add the field needed (eg. preferred field)
* go on form components and edit that field to enable only the option wanted (eg. spanish) and set it as the default
* set the widget as "hidden"

It's not bullet proof, as in theory, the visitor can still use tools like firebug and alter that field

---
Tags: webform-civicrm
---


# Question
Title: Getting civicrm in Israel and in Hebrew and English
Is this program available in Israel, also with Hebrew and English? I would want to have it customized to our needs. Thanks, Debbie Perla Hannaton Educational Center

# Answer
The program is Open Source, so it is available everywhere.

When you download CiviCRM at https://civicrm.org/download/list you can also download the Localization files.

The Hebrew language is available in there, although not all texts are translated yet.

But I am pretty sure you can adjust it to your needs and make sure you can at least translate anything that is shown to your visitors.

On one of my CiviCRM's I have set the language to Hebrew, so you can have an insight how much is generally translated.

If you choose CiviCRM for your organization and you would do some extra translation for your site we'd love to help you give it back to the community. We would all benefit from it.

(More info: https://www.transifex.com/civicrm/civicrm/)
> 4 votes

# Answer
While CiviCRM is available in Israel, you would probably need to help out with the translation effort to Hebrew. Currently only 12% of the strings are translated.

https://www.transifex.com/civicrm/civicrm/language/he/

This is very easy, you just need to create a transifex account. More details on translation for CiviCRM can be found here : https://wiki.civicrm.org/confluence/display/CRMDOC/Resources+for+Translators
> 2 votes

# Answer
CiviCRM is available in Israel as well as any other country. I don't know of a Hebrew version available for download. You can definitely have it translated as part of your customization.
> 0 votes

---
Tags: installation, evaluating-civicrm, i18n
---


# Question
Title: Warning and Fatal error updating from 4.6 to 4.7 com_civicrm/admin/configure.php on line 115
(Site information/versions at the bottom) I have only used CiviCRM for event registration and entering other events in the calendar. More recently in anticipation of implementing membership capabilities, I had updated to the most recent version 4.6.11 and everything appeared fine. I received a message about running the update on the database and I did that. Everything was fine. But then when I logged on yesterday, I saw that 4.7 was out, so I went ahead and attempted to update to that version. I first just got the white screen. I went ahead and tried to reinstall the 4.6.11 version and got the following message:

> Warning: require\_once(/home/hobbits8/public\_html/administrator/components/com\_civicrm/civicrm.settings.php): failed to open stream: No such file or directory in /home/hobbits8/public\_html/tmp/com\_civicrm/admin/configure.php on line 115
>
> Fatal error: require\_once(): Failed opening required '/home/hobbits8/public\_html/administrator/components/com\_civicrm/civicrm.settings.php' (include\_path='.:/opt/alt/php54/usr/share/pear:/opt/alt/php54/usr/share/php') in /home/hobbits8/public\_html/tmp/com\_civicrm/admin/configure.php on line 115

I tried uninstalling the component and reinstalling again, but once I uninstalled the component, I no longer had the menu entry for CiviCRM. I also followed the instructions for modifying the php (global settings off--already off, max upload--already at recommended level, time --I modified from 30 to 600). I've tried installing both the old (4.6.11) and the new (4.7) from a file upload and also from the tmp folder on the server and get the same result. I saw something about needing to compare settings with the old backup, and of course (dummy that I am), I do not have a backup.

I see someone asked a similar question, but the response to him did not fit either his or my scenario (not upgrading from an old version of Joomla or even an old version of CiviCRM).

* Joomla 3.4.8
* PHP 5.3.29
* mySQL 5.5.45 (innoDB enabled)

Thank you. Patti

# Answer
It sounds like the `civicrm.settings.php` file may have been removed when the upgrade/downgrade was applied to your site? See Upgrading CiviCRM for Joomla in the section "Back up your CiviCRM database and settings file". Hopefully you have a copy of the file in your backup, and can restore it to the appropriate location.

CiviCRM recommends PHP 5.4 or greater, which might have caused the white screens when you tried 4.7. PHP 5.6 is the oldest supported PHP version at time of writing; as versions 5.3, 5.4 and 5.5 are no longer supported versions of PHP, I'd recommend updating your PHP if at all possible.
> 1 votes

---
Tags: joomla, upgrade, 4.7
---


title: Importing Contributions

text:
# Question
Title: Importing Contributions
I am currently trying to import contributions to CiviCRM, and it will not let me. Ill get all the way to the import option, it will tell me that all rows are valid, then once I import, all rows are invalid. It is saying that my contact id is not valid, but it is! I have exhausted everything in my ability, and as wondering if you could help me out.

Thanks,

Chandler

# Answer
> 4 votes
I recommend you check the detailed error message (you can download a csv file which contains those).

Maybe CiviCRM thinks that some columns are the contribution\_id and it automatically selects this column to be matched with contribution\_id. Then when doing this, it cannot find this ID.

I have expirienced exactly this problem, ignoring that column during import helped.

---
Tags: civicontribute, import
---


# Question
Title: Which value to use for tag_id to create EntityTag
I am struggling with adding tags trough the CiviCRM API to a newly created contact in an extension (trough API Chaining). The installation is running on Wordpress 4.4.1 with CiviCRM 4.7. The following PHP snippet creates the contact with Tag "Non-Profit" which is not the expected behavior.

```
$contactParams['api.EntityTag.create'] = array(
        'entity_table' => 'Contacts', 'tag_id' => array("Interessent",     "Contributor")
);

$api->Contact->Create($contactParams)

```

# Answer
A few advices :

* when you chain, you shouldn't have to define the entity\_table. If you want to define it anyway, the entity\_table should be the database table - i.e. `civicrm_contact` in your case.
* Label and id of the tag can be used in tag\_id but i really encourage you to use the id. The label can change or be language dependent while the `id` could not change.

But to answer your question, in your case, the real problem is the array part. The EntityTag api is to create one tag assignation. I don't think there is a syntax to assign multiple tag.

It could be nice to be able to add several `api.EntityTag.create` but because the key is the api call definition, it's impossible right now (or i don't know how).

So while this will work fine :

```
$result = civicrm_api3('Contact', 'create', array(
  'contact_type' => "Individual",
  'first_name' => "xxx",
  'last_name' => "yyy",
  'api.EntityTag.create' => array('tag_id' => 5),
));

```

If you have multiple tags, i suggest you do :

```
$result = civicrm_api3('Contact', 'create', array(
  'contact_type' => "Individual",
  'first_name' => "xxx",
  'last_name' => "yyy",
));
$contact_id = $result['id'];
foreach ($tags as $tag_id) {
  civicrm_api3('EntityTag', 'create', array(
    'entity_table' => 'civicrm_contact',
    'entity_id' => $contact_id,
    'tag_id' => $tag_id,
  );
}

```

**EDIT**

For multiple tags, you could try (not tested but work for website for example - https://github.com/civicrm/civicrm-core/blob/master/api/v3/examples/Contact/ChainTwoWebsites.php)

```
$result = civicrm_api3('Contact', 'create', array(
  'contact_type' => "Individual",
  'first_name' => "xxx",
  'last_name' => "yyy",
  'api.EntityTag.create' => array('tag_id' => 5),
  'api.EntityTag.create.2' => array('tag_id' => 8),
));

```
> 3 votes

---
Tags: api
---


# Question
Title: Fatal error when trying to access the Manage Groups page
We're unable to access to the Manage groups page - it brings up a fatal error with the message:

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

I'm not sure if this is since we upgraded to 4.6.9, or if it was triggered by the creation of a group from a custom search (Contacts by date added).

We seem to be able to access individual groups by going through the groups tab in contact records, and we're able to add new groups.

The error log has the following:

```
Nov 05 16:00:29  [info] $Fatal Error Details = Array
(
    [message] => United Kingdom is not of the type Positive
    [code] =>
)

Nov 05 16:00:29  [info] $backTrace = #0 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Core\Error.php(364):    CRM_Core_Error::backtrace("backTrace", TRUE)
#1 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Utils\Type.php(259): CRM_Core_Error::fatal("United Kingdom is not of the type Positive")
#2 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Contact\BAO\Query.php(5171): CRM_Utils_Type::escape("United Kingdom", "Positive")
#3 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Contact\BAO\Query.php(3575): CRM_Contact_BAO_Query::buildClause("civicrm_address.country_id", "=", "United Kingdom", "Positive")
#4 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Contact\BAO\Query.php(1741): CRM_Contact_BAO_Query->country((Array:5), FALSE)
#5 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Contact\BAO\Query.php(1873): CRM_Contact_BAO_Query->whereClauseSingle((Array:5))
#6 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Contact\BAO\Query.php(499): CRM_Contact_BAO_Query->whereClause()
#7 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Contact\BAO\Query.php(461): CRM_Contact_BAO_Query->initialize()
#8 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Contact\BAO\GroupContactCache.php(501): CRM_Contact_BAO_Query->__construct((Array:6), (Array:4), NULL, FALSE, FALSE, 1, TRUE, TRUE, FALSE, NULL, (Array:3))
#9 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Contact\BAO\Query.php(2924): CRM_Contact_BAO_GroupContactCache::load(Object(CRM_Core_DAO))
#10 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Contact\BAO\Query.php(2834): CRM_Contact_BAO_Query->addGroupContactCache((Array:1), NULL, "contact_a", "IN")
#11 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Contact\BAO\Query.php(1657): CRM_Contact_BAO_Query->group((Array:5))
#12 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Contact\BAO\Query.php(1873): CRM_Contact_BAO_Query->whereClauseSingle((Array:5))
#13 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Contact\BAO\Query.php(499): CRM_Contact_BAO_Query->whereClause()
#14 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Contact\BAO\Query.php(461): CRM_Contact_BAO_Query->initialize()
#15 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Contact\BAO\Query.php(4314): CRM_Contact_BAO_Query->__construct((Array:1), (Array:1), NULL, TRUE, FALSE, 1, TRUE, TRUE, FALSE)
#16 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Contact\BAO\GroupContactCache.php(220): CRM_Contact_BAO_Query::apiQuery((Array:1), (Array:1), NULL, NULL, 0, 0, FALSE)
#17 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Contact\BAO\GroupContactCache.php(192): CRM_Contact_BAO_GroupContactCache::add((Array:36))
#18 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Contact\BAO\GroupContactCache.php(202): CRM_Contact_BAO_GroupContactCache::loadAll()
#19 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Group\Page\Group.php(147): CRM_Contact_BAO_GroupContactCache::fillIfEmpty()
#20 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Core\Page\Basic.php(178): CRM_Group_Page_Group->browse(NULL, NULL)
#21 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Core\Invoke.php(312): CRM_Core_Page_Basic->run((Array:2), NULL)
#22 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Core\Invoke.php(86): CRM_Core_Invoke::runItem((Array:13))
#23 C:\xampp\htdocs\switch\sites\all\modules\civicrm\CRM\Core\Invoke.php(54): CRM_Core_Invoke::_invoke((Array:2))
#24 C:\xampp\htdocs\switch\sites\all\modules\civicrm\drupal\civicrm.module(489): CRM_Core_Invoke::invoke((Array:2))
#25 [internal function](): civicrm_invoke("group")
#26 C:\xampp\htdocs\switch\includes\menu.inc(527): call_user_func_array("civicrm_invoke", (Array:1))
#27 C:\xampp\htdocs\switch\index.php(21): menu_execute_active_handler()
#28 {main}

```

Any ideas as to what might be causing this? It doesn't happen in the demo version.

# Answer
> 0 votes
This problem recurred for us in 4.7, and the workaround suggested in the comments by jitendrapurohit didn't work when I tried to re-edit CRM/Contact/BAO/Query.php. As it seemed likely the problem was actually related to the database, I had a dig around in the db, and found that there was an old smart group linked to a saved search that was looking for contacts in the UK - that seemed to be referencing the country in a way that didn't match the current country references in CRM/Contact/BAO/Query.php, so I deleted the smart group from the db and ran the 'Rebuild Smart Group Cache' job. The fatal error is no longer being triggered, so I'm fairly sure that's what was causing the problem.

# Answer
> 0 votes
I've seen something similar. After the failure, have you tried to go back to the manage groups page. In our case you can. The first time it goes and gets all the counts of how many contacts are in each group. The next time it doesn't. If it errors in the group count, it gives that message. You can manually trigger a count by clicking on the Update Smart Group counts link (under and to the right of the Find Groups box).

Assuming you can get to the groups the second time, try disabling the group and trigger the count. If that works, then try creating a new smart group that does the same thing the old one did. In our case that worked.

The logic that creates the sql to do the smart group is always being tweaked (it can be quite complicated). Sometimes what was created in one version doesn't work quite right in a later version.

# Answer
> 0 votes
There were some known issues regarding Smart Groups in 4.6.9

I would suggest you upgrade since the 4.6.10 is a security release and try rebuilding them.

# Answer
> 0 votes
Similar issue has been recently resolved in master(https://issues.civicrm.org/jira/browse/CRM-17361).

Can you patch up your site with https://github.com/civicrm/civicrm-core/pull/6985 and see if it works for you ?

---
Tags: groups, error
---


# Question
Title: Drupal's Aggregate Javascript breaks CKEditor Config
With Aggregate Javascript turned on under Administration » Configuration » Development » Performance, Civi's Configure CKEditor page doesn't display the editor's container or configurator.

Drupal 7.41/Civi 4.7

# Answer
> 3 votes
You're right, that was a bug. I poked around and found a spot for the js that doesn't break under aggregation:

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

---
Tags: drupal, ckeditor, javascript
---


# Question
Title: How to create a report showing a subset of contacts and their tags
I need help creating a custom report, please. I have approximately 15 tags (health, advice, benefits, etc), and I need to know how to create a report showing which of the contacts in my database are associated with them. I can run a report that creates the appropriate list of contacts, but it doesn't show which tags each contact has. I hope this makes sense!

Many thanks,

cdwmrcf

# Answer
> 3 votes
Follow the below step get the contacts report with tag values.

1. Find contact using search option. (sitename/civicrm/contact/search?reset=1)
2. Click on search without apply any filter if you want report for all contact.
3. Select the contacts and then perform the action **export contacts**
4. select this option **Select fields for export and Do not merge** on this page.
5. Now on this page you select the fields that you want in your report.

That's all.

# Answer
> 2 votes
If you want to see the Tags on the screen, go to Search Builder, and enter something like: Contacts \> Tags \> Not empty.

This should give you a table with Name and Tags, and you can then export too if you want.

NOTE: any suggestion offered may not be available on an old system like 4.1.x. Also note that if your system is publicly accessible it is unlikely to be 'secure' since many security releases have come out since that version.

---
Tags: custom-reports
---


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

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

---
Tags: civievent, joomla
---


# Question
Title: Tokens in civicrm webform - not showing contact
Webform has a browser for 'available tokens'. civicrm-contact appears in it, but none of the tokens seem to work. Is there anything I have to do to enable them ?

If I put this in the confirmation message of a testform

```
current-user:civicrm-contact:display-name
[current-user:civicrm-contact:display-name]
current-user:name
[current-user:name]
submission:user:civicrm-contact:display-name
[submission:user:civicrm-contact:display-name]
submission:user:name
[submission:user:name]
current-user:civicrm-contact:id
[current-user:civicrm-contact:id]

```

The result, when filled out by a valid civi contact, is

```
current-user:civicrm-contact:display-name
current-user:name
pike
submission:user:civicrm-contact:display-name
submission:user:name
pike
current-user:civicrm-contact:id

```

# Answer
I suspect those tokens are coming from another module (possibly CiviCRM itself). I never added any token support to webform\_civicrm. That said, the best way to achieve your goal is probably to use the token from the contact\_1:existing\_contact field. This has the upshot of working correctly even when the user is anonymous. It's something like

```
[submission:values:civicrm_1_contact_1_contact_existing]

```

(but would need to be adjusted if it is inside a fieldset)
> 3 votes

---
Tags: drupal, webform-civicrm, tokens
---


# Question
Title: Why does profile&gid= get converted to profile_gid_ to in the navigation menu?
I need to use the navigation menu hook to add a URL with arguments. I can't figure out why

```
'url' => 'civicrm/profile&gid=20'

```

gets converted to

```
 civicrm/profile_gid_20

```

by the time the menu renders. I've tried using

```
 'url' => 'civicrm/profile&gid=20'

```

instead, but that doesn't help.

# Answer
Try using a question mark instead of an ampersand:

```
'url' => 'civicrm/profile?gid=20'

```
> 1 votes

---
Tags: menu, urls
---


# Question
Title: Error messages while setting up Event Calendars using Calendar and Views modules
Trying to set up some calendars on my website and running into trouble with both my theme screwing up the display and these error messages showing:

Notice: Undefined offset: 27 in calendar\_plugin\_row\_civicrm-\>render() (line 135 of /home/\***/public\_html/sites/all/modules/civicrm/drupal/modules/views/plugins/calendar\_plugin\_row\_civicrm.inc).

Notice: Undefined property: stdClass::$start\_date in calendar\_plugin\_row\_civicrm-\>render() (line 156 of /home/\***/public\_html/sites/all/modules/civicrm/drupal/modules/views/plugins/calendar\_plugin\_row\_civicrm.inc).

Warning: Invalid argument supplied for foreach() in calendar\_plugin\_style-\>render() (line 305 of /home/\***/public\_html/sites/all/modules/calendar/includes/calendar\_plugin\_style.inc).

I am using the CiviCRM Events View that was installed by one of the involved modules. The events DO show on the calendar, and I CAN click on them to get to the event page. In other words, things appear to be working, but I can't get rid of these error messages showing up on the page.

Error is only showing up on current month, January. Ah - if i filter out all events prior to today's date, there are no error messages. So temporary fix, but I do want to be able to scroll back through the months and see past events.

Civicrm 4.6.11 Drupal 7.41

Would appreciate any suggestions. Thanks!

# Answer
> 2 votes
Just update the calendar module to latest version, it will fix the issue.

# Answer
> 2 votes
If you don't get a solution via the module you can try the CiviCRM Entities module (2.x version) and the Calendar module then in Views you should find that you can use "Add from template" and there is a template for Civi Event.

# Answer
> 0 votes
This may not have anything to do with CiviCRM. I am seeing a similar problem with a site that doesn't use CiviCRM. Here are some of the errors I see:

Notice: Undefined property: calendar\_plugin\_row::$date\_argument in calendar\_plugin\_row-\>render() (line 365 of /srv/bindings/.../code/sites/all/modules/calendar/includes/calendar\_plugin\_row.inc). Notice: Trying to get property of non-object in calendar\_plugin\_row-\>render() (line 365 of /srv/bindings/.../code/sites/all/modules/calendar/includes/calendar\_plugin\_row.inc). Notice: Trying to get property of non-object in calendar\_plugin\_row-\>render() (line 365 of /srv/bindings/.../code/sites/all/modules/calendar/includes/calendar\_plugin\_row.inc). Notice: Undefined property: calendar\_plugin\_row::$date\_fields in calendar\_plugin\_row-\>render() (line 375 of /srv/bindings/.../code/sites/all/modules/calendar/includes/calendar\_plugin\_row.inc).

# Answer
> 0 votes
These are notices, not errors, and are generally harmless. You should configure Drupal to hide them in yoursite.org/admin/config/development/logging.

---
Tags: civievent, drupal, drupal-views, calendar
---


title: Where is customPHPPathDir set in 4.7.0?

text:
# Question
Title: Where is customPHPPathDir set in 4.7.0?
This appears to be missing. I can't get CiviCRM to execute custom PHP code.

/CRM/Core/Config/Runtime.php at line 139 references $this-\>customPHPPathDir but there is no such member variable of this object. Because of this customPHPPathDir is not added to the include path.

The comment on the previous line is FIXME.

Is this a bug?

# Answer
I would suggest you to not use that folder anymore (Allen is detailing where you can set it), but to write extensions.

What is usually done is to copy paste an existing php file from the core and alter it to fit your need. However, as the original file is likely to be modified in the core between versions, you will either end up with your modify version that has diverged from the core, or you'll need to apply your changes at every upgrade.

Most of what you need to be changed can usually be done more safely and robust from an extension, using hooks
> 3 votes

# Answer
From the menu: *Administer \> System Settings \> Directories*

The custom PHP directory is the second option from the bottom. The help text reads:

> Path where site specific PHP code files are stored if any. This directory is searched first if set.

Note the use of `[civicrm.files]` at the start of the other directories on that screen if your custom PHP path is going to live within the file structure of your Civi install.
> 2 votes

---
Tags: configuration
---


# Question
Title: civievent - add 2097 participiant to an event
I tried to add 2097 contacts as a participant to an event. procedure: \- search \- advanced search for "individuals" \- action add 2097 participants to an event \- waited for more than one hour \- it didn't add the participants to this event, no error message

I did the same procedure with 1597 contacts and it works. is there a limit?

# Answer
It's likely a configuration limit on your server that doesn't handle "big" operations

There is an upper limit on how much "stuff" you can do, and your webserver has a limit on how long a page can work (usually 30 sec) and how much memory it can use.

It might be that you hit one of these limits. If you have access to the log on the server, check if there is an error written when you try to do that operation... hard to be more detailed, it depends on your server and how it's configured.
> 4 votes

---
Tags: civievent, contacts, search
---


# Question
Title: Search 'Hangs' While Trying to Assign Transactions to a Batch
I created a Smart Group of members whose memberships are expiring in a particular month. I then created a new accounting batch. When I open the batch by clicking 'Transactions,' I get a list of all 2,000 plus members. Then I tried to revise my search by selecting the Smart Group in the search screen. When I click search, I get a small box in the middle of the screen that says 'Processing...' However, nothing happens. It appears that CiviCRM is hanging. I can find no reference to anything similar happening in any of the CiviCRM sites.

# Answer
This can happen for many reason

* check for any error message in Civicrm Log file
* check for any error message in PHP error log file

If you haven't got any error message then

* your MySQL DB is old version and you need to upgrade to latest Because some SQL which has been written in MySQL 5.6 is not been supported in Mysql 5.1 - which will not return any value and will timeout
* also check for your Php Version too
> 1 votes

---
Tags: civicontribute
---


title: import contribution

text:
# Question
Title: import contribution
I try to import contribution. Procedure \- Contribution \- import contribution \- import the .csv list

Error "is not a valid option for field campaign\_id"

Where do I find the campaign\_id?

thanks

# Answer
If you contributions belong to a campaign, you can find out the id by visiting the campaign dashboard (/civicrm/campaign?reset=1) and hover over the edit link on the right side. You will see a link like the one below - the last number is your campaign ID.

/civicrm/campaign/add?reset=1&action=update&id=1

However, if your contributions do not belong to campaigns, I guess you would probably not have to set them when importing?
> 1 votes

---
Tags: import, contributions
---


# Question
Title: Webform-CiviCRM with membership payment has broken on 4.7
I've noticed something strange on 4.7 -- webforms that integrate Webform-CiviCRM and include a payment portion are now pulling in the entire contribution page that is associated in the CiviCRM tab. Previously it would only use fields defined in the webform itself. Now I notice everything from the info/description to the Contribution page's included profiles in the payment portion of the webform.

Is this an intentional change? If so, is there a way to get the previous functionality?

UPDATE: (Further info)

* If I disable all profiles on the linked contribution page, no payment fields show up at all.
* If I enable a profile, it pulls the entire contribution page in rather than simply the payment fields as it used to do.
* If I disable the Membership Section on the contribution page, I get this error: `"This page does not have any price fields configured or you may not have permission for them. Please contact the site administrator for more details."` (Under "Memberships", the webform has *"Membership type" \> User Select* with *"Number of Terms"* set to 1. It links to a contribution page in the "Contribution" section.)

# Answer
> 1 votes
The Webform-CiviCRM module is not yet compatible with CiviCRM 4.7. You can help! See https://www.drupal.org/node/2661232

---
Tags: drupal, webform-civicrm
---


# Question
Title: Session Key issues after upgrading from 4.4 to 4.6
I've upgraded from 4.4 to 4.6.10 on Drupal 7.41. I'm getting the following issue when attempting to make a contribution:

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

I didn't have this problem before updating to 4.6.10.

I have cookies enabled.

I have confirmed that the Civi and Drupal base URLs are the same and match what is in the address bar of my browser.

Drupal caching is currently disabled.

I have a user 0 in my Drupal database.

Finally and this is the weird thing, when I get the error if I click the back button and resubmit the form it works fine.

Does anyone have a solution or work around for this problem?

### Updates

Turns out while the message references sessions it has to do with the contribution page losing the ID but it's an issue with the payment plugin.

# Answer
> 1 votes
Turns out while the error message is about the session key the issue is with the stripe payment processor plug-in. I'll raise the issue on the plug-in's issue queue.

# Answer
> 1 votes
I had the same issue, with a slightly different solution. After days of searching I found that my Drupal/`civicrm settings.php` file had several values altering the default settings for PHP and the way cookies were handled.

After commenting out these cookies settings, civicrm was able to handle the cookies properly. Voilà, system started working properly.

```
ini_set('arg_separator.output',     '&');
ini_set('magic_quotes_runtime',     0);
ini_set('magic_quotes_sybase',      0);
ini_set('session.cache_expire',     200000);
ini_set('session.cache_limiter',    'none');
ini_set('session.cookie_lifetime',  2000000);
ini_set('session.gc_maxlifetime',   200000);
ini_set('session.save_handler',     'user');
ini_set('session.use_cookies',      1);
ini_set('session.use_only_cookies', 1);
ini_set('session.use_trans_sid',    0);
ini_set('url_rewriter.tags',        '');

```

Hope this helps someone :)

# Answer
> 0 votes
I cannot comment (rep), but I will edit this post later:

Can you provide more info:

* Is it a Contribution page or Event regi?
* 1-time contribution or recurring?
* Memberships, or other features enabled?
* Any other extensions enabled?
* Any errors in the browser JS console?
* Any browser extensions that might get in the way (Ghostery / ABP)?
* What version of Stripe API (in your stripe.com dashboard)?

---
Tags: civicontribute, drupal, session
---


# Question
Title: Why can't I save draft in contact email?
I am not using CiviMail but trying to email directly out of a contact record. The only options available are "Send Email" or "Cancel". My agency needs to be able to save a draft to edit and send at a later date. Is this possible or am I missing something? It seems that CiviMail only uses groups. I need a function to save drafts from individual contact. Any input is greatly appreciated.

Thanks! Erin

# Answer
I think you are correct that this functionality is missing. Workarounds that might serve you well include:

* writing and saving the draft as a meeting note for the contact, then copy-pasting into an actual email when ready.
* creating a new activity type that is called "email draft" and doing the same.
* using an actual email client, such as gmail, to write and save a draft, and when ready, send, bccing civiemails so that the email is logged in the contact's activity. (this will require setup of email-to-activity if it hasn't already been configured)

I hope one of these helps!
> 2 votes

---
Tags: civimail, contacts, email
---


# Question
Title: Relationship Permissions as ACLs don't work
I am working with CiviCRM 4.6.11 integrated in Drupal 7.4.1 I installed "Relationship Permissions as ACLs" 1.2 (compatible 4.6): https://civicrm.org/extensions/relationship-permissions-acls It is also necessary: "CiviCRM Entity Settings": https://civicrm.org/extensions/civicrm-entity-settings but this extensions is compatible ultil CiviCrm version 4.5 . Can you help ? Thank'you

# Answer
I have both of those extensions working on 4.6 without any issues.
> 1 votes

# Answer
When the above extensions are enabled, on any Relationship Type you should now see a new field saying Always Permission A to B (and vv). And at civicrm/admin/setting/misc?reset=1 you should see an option for 'Allow second-degree relationship permissions'.

I have added above to the extension page and will ask it be added to the readme if that helps.
> 2 votes

---
Tags: drupal, extension, relationships, civicrm-entity, 4.6.11
---


# Question
Title: CiviEvent in Multisite Acting Strange after Upgrade to 4.7
Our organizes uses Wordpress and CiviCRM, and we have multisite enabled to use one civi database across two websites (set up in WP multisite).

I upgraded to CiviCRM 4.7 this morning and it went smoothly on the main site. However, on the second site, the CiviEvent pages look strange on the website front end. It looks to me like the CSS is not loading correctly. Can anyone give me some idea as to what is happening here?

Here is an example.
Working, primary site: http://japanphilly.org/wordpress/civicrm/?page=CiviCRM&q=civicrm/event/info&reset=1&id=225
Strange-looking, secondary site (same event): http://subarucherryblossom.org/events/?page=CiviCRM&q=civicrm/event/info&id=225

In addition, while logged in as an admin, the drop-down admin links which usually appear near the top of the page (Info and Settings, Location, Fees, etc.) appear not as a drop down but as a list of links... which is why I am guessing the CSS is somehow not loading right.

# Answer
If you look at the two urls you posted you can see that one is /civicrm and the other is /events.

That suggests that when you upgraded perhaps something got messed up in the WP equivalent of settings.php.

if i change out the url and go to

http://subarucherryblossom.org/wordpress/civicrm/?page=CiviCRM&q=civicrm/event/info&id=225

it all looks fine to me. hope that helps.
> 1 votes

---
Tags: civievent, wordpress, multisite, 4.7
---


title: Editing contributions in closed batches

text:
# Question
Title: Editing contributions in closed batches
I had a situation come up in which a contribution in a closed and exported batch had to be changed. I ended up deleting that batch and assigning the contributions to a new batch. Is there another way I should have handled this? Is there a way to issue a credit memo (essentially reverse) for an existing contribution?

# Answer
> 2 votes
From a clarity/clean audit trail perspective, I think I would go with adding a negative contribution to reverse/adjust the previously batched contribution, including a note in the adjustment contribution record. Some of our clients create batches just for adjustments to track them separately. Especially if it's been exported to another system, I would think changing that exported record might introduce errors or at least confusion into the situation.

---
Tags: civicontribute, batches
---


# Question
Title: Custom Template for WP Base Page not working as expected
I'm on version 4.6.11 of the CiviCRM plugin for WordPress, WP version 4.4.1.

I expect this has something to do with shortcodes, hijacking, and maybe some other things related that I'm having trouble understanding. Here's what's happening:

I have created a WP page template called page-civiform.php. It is intended to be used by site admins to create event registration pages and donate pages, and it has some custom fields and specific styling/branding. Admins use the main content WYSIWYG editor to paste a shortcode from CiviCRM that creates their event registration form or donate form. All is well, and these pages look good.

Then, once a user registers or donates, the URL of the very page is appended with a query string, and it appears to be retrieving the default page.php sidebar (which is called in page.php). BUT, the body classes are not those of page.php. Instead, the body classes are exactly the same as those of the previous page where the shortcode was pasted - that page which is using page-civiform.php template. That's a problem, because it ends up creating an unprofessional appearance with a wonky layout.

I created a page with slug 'civicrm' and in WordPress Base Page setting, it is set to use that page, which does indeed use page.php as its template. On top of that, per the answer here, I put a filter into functions.php file to specify using page.php. None of this appears to have any effect. Removing that filter and changing the WordPress Base Page (to anything else) also appears to have no effect.

Seems the wires are crossed here. I did see this issue, discussion of which sounds unpromising.

I need the Civi-generated pages to be style-able *differently* from the pages where shortcodes are pasted; I can't do that when the selectors are identical.

Could this issue be related? Is there a setting somewhere that I am unaware of?

# Answer
Im answering my own question and I'll probably go overboard in explaining everything exhaustively, but I sunk too much time into this to just let my understanding disappear into my own forget.

In this particular site, site admins use the custom page template 'page-civiform.php' whenever they want to create a page which will contain a CiviCRM form, inserted via shortcode, and this page template allows them to also insert additional content via a custom field which will display in a column alongside the form. Looks nice.

End users submit the form, and then CiviCRM automatically generates each subsequent page (thank you page, event registration confirmation page, etc).

These pages will have the same **body classes** as the page where the shortcode was inserted.

BUT these Civi-generated pages do NOT use the same **content** as the page with the shortcode. And by content, I *think* this means everything in between `get_header()` and `get_footer()`. Instead, they use the content from another page, and there are three ways to specify which page they will use:

1. If there is no other method utilized to specify which page to use, CiviCRM will use the home page. Again, **content**, not body classes (that was the source of my confusion).
2. In CiviCRM \> Administer \> System Settings \> CMS Database Integration, the WordPress Base Page can be set to a specific URL. Then that page's content will be used.
3. It is also possible to specify the page via a filter which would go into functions.php or a plugin. And here's code for that:

add\_filter( 'civicrm\_basepage\_template', 'my\_basepage\_template' );

function my\_basepage\_template( $template ) {

return 'page.php'; //whichever template you want

}

The path of least resistance here is to have ALL of these pages (pages with shortcode inserted as well as any resultant civi-generated pages) have the same template, because then this whole situation wouldn't matter. But on this site, we want some content in a column next to the shortcode-generated form, so that's why we have a separate page template with a custom field ('page-civiform.php').

Here is 'page-civiform.php' so you can see how the custom field is conditionally included or not. The presence of that conditional statement would actually allow me to set this page as the WordPress Base Page, and it would yield the same result, which in this casse is two columns on page with shortcode, one column (just Civi's content) on auto-generated pages.

Basically, this all comes down to having different design/layout for pages with shortcodes vs civi-generated pages.
> 1 votes

---
Tags: wordpress
---


title: WordPress Base Page not working?

text:
# Question
Title: WordPress Base Page not working?
I would like to use a custom display for some civicrm page as error contribution form pages.

So i have created a template wordpress page named civicrm, fill "civicrm" in WordPress Base Page field in admin.

I have inserted the shortcode to insert a contribution form But when i validate the form on frond end i am not redirected to the good url (the one with base page i have specified)

Could you help me ?

Thanks

# Answer
I would suggest to try telling CiviCRM what is your base template.php pasting this in your functions.php

```
add_filter( 'civicrm_basepage_template', 'my_basepage_template' );

function my_basepage_template( $template ) {
return 'page.php';
}

```

Replace page.php with the page template in use by your theme.

If that doesn't work, try changing to the default WordPress theme (Twenty Fifteen) and try submitting the form in the Contribution page you have created and report back.
> 1 votes

# Answer
It won't actually redirect you to the URL of the WordPress Base Page. What it will do is append a query string to the URL of the page that had the shortcode, and then it will use the *content* of the WordPress Base Page.

See my answer to my own question here for more details.
> 1 votes

---
Tags: wordpress
---


# Question
Title: Custom fields not displaying properly after 4.7.0 upgrade
Since upgrading to 4.7.0 I've noticed a problem with my custom fields (multiple-record, tab with table, and I have 4 multiple-record custom field sets per).

When I click on the custom field tabs for a contact, sometimes the data table does not display correctly. Some of the columns display as "\[object Object\]" for the entire column (except the heading row) instead of displaying proper data. I have a "Date" column that usually displays correctly, but in one of the custom field sets its data appears in the wrong column.

I also noticed that if I click in the data table's heading row to sort on a column I get an error in Firefox: "DataTables warning: table id=records - Invalid JSON response..."

I run CiviCRM on Joomla 3.4.8 and this issue did not occur for me on 4.6.11 (or earlier versions).

Is anybody else experiencing this issue after upgrading to 4.7.0, or have any ideas?

Edit: this is somewhat intermittent, but happens at least half of the time. Refreshing the page in the browser often fixes it, until next time.

(I tried to reproduce it on the online demo site (Drupal, since the Joomla demo is an older version) but I could not get "tab with table" custom field records to display at all there: after creating a custom field set and some test records, "No records of type '' found." is always displayed.)

# Answer
> 1 votes
PR submitted here resolves the issue encountered https://github.com/civicrm/civicrm-core/pull/7720

---
Tags: custom-fields, upgrade
---


# Question
Title: Are there public repos including WordPress WooCommerce and CiviCRM integration code?
On a WordPress / CiviCRM installation, we need to do a bunch of customization on its payment pages. We want to do it in WordPress since there are WordPress plugins that can help do things like validate addresses and calculate sales taxes that are not yet available in CiviCRM, and the budget is constrained. The main integration we want is to write to CiviCRM 1) contact info, 2) invoice data for memberships, participants, and 'contribution' items like book purchases, and 3) payments received.

We're going to start by upgrading the CiviCRM API to allow multiple line items including Sales Taxes to be added properly.

Is there a good starting repo for the WordPress plugin anywhere? I've contacted Josh at http://www.joshcanhelp.com/wordpress-ecommerce-site-integrated-civicrm-migrated-drupal-6/#comment-30644. Alternatively, custom non-generalized implementations would also be fine.

# Answer
Doesn't seem like there is a public repo that has code integrating wooCommerce and CiviCRM yet.
> 5 votes

# Answer
For those interested there is a great start...blog with code here: github
> 3 votes

# Answer
I currently have a project in which we will be integrating CiviCRM with WooCommerce. I have also contacted Josh to see if we could perhaps put our heads together to come up with some sort of common solution that others may be able to use. Will keep you posted.
> 2 votes

# Answer
Unsure what you mean by "a starting point for the Wordpress plugin", but I'd start by triggering the appropriate CiviCRM API calls when various WooCommerce hooks are fired. Hello Dolly is a good reference point to start a Wordpress plugin from.
> 1 votes

---
Tags: api, wordpress, civicontribute, woocommerce
---


# Question
Title: Why do i have to reenter the 'new organization' name when I have already entered it in the 'current employer' field
At some point the way 'new organisation' was created from the 'current employer' field on New Individual was changed/improved/updated.

If no match is found now (4.6/4.7) you can use a 'new organisation' link to create one. But having typed the name in to the 'current employer' field, the pop up then appears with the Organization Name field empty and it has to be retyped.

Seems like a functional regression since in the past you would type in the name only once.

# Answer
> 1 votes
I recall tons of duplicate organisations created on \< 4.6, because people wouldn't wait until the list of organisations was properly loaded and so on.

So in general, having a bit more control before creating a new organisation, and give it the chance to be more than an empty one makes sense IMO.

As your specific point, it would be better indeed that the field is pre-populated. PR welcome and all that ;)

---
Tags: contacts
---


# Question
Title: Updating information in Custom fields within a tab not saving since update to 4.7.0
Civicrm 4.7.0 Joomla 3.4.8

When editing or adding information contained within a custom field within a tab, after hitting save, the information does not remain.

Also receive the following error when trying to view information contained wihtin a tab within a table:

Datatables warning: table id=records -Ajax error For more information please see http://datatables.net/tn/7

Any help would be appreciated. Please let me know if you require more info.

Thanks

# Answer
Hi I did manage to test the same against 4.7.0 and we do have an issue. so, please raise an issue for the same

Also I did manage to test the same against Civicrm Version 4.6.11 and everything works perfectly. so at this time I would recommend you to install civicrm Version 4.6.11 for time being and wait for the next version and see if that gets fixed
> 1 votes

---
Tags: custom-fields, upgrade, database, error, fields
---


# Question
Title: CiviMail - Error 500 when tracking clickthroughs
We have recently upgraded to CiviCRM 4.7.0, and we have Drupal 7.41

As part of the upgrade process, I upgraded PHP to 5.6.17

Most things work brilliantly, but when we have link tracking enabled on a CiviMail email we get this error:

> Fatal error: Call to undefined function drupal\_add\_http\_header() in /home/ace/public\_html/sites/all/modules/civicrm/CRM/Utils/System/Drupal.php on line 789

An example URL is https://acenterprises.org.uk/sites/all/modules/civicrm/extern/url.php?u=1535&qid=864040

There's nothing recorded in the HTTP Error Log - can anyone give me any clues on debugging this error?

Thanks!

# Answer
This seems to be an issue with 4.7 and 4.7.1: https://issues.civicrm.org/jira/browse/CRM-17953

The issue has a workaround solution, and the full fix will be linked from that issue when it has been implemented.
> 2 votes

---
Tags: civimail, upgrade
---


title: How do I edit activity forms?

text:
# Question
Title: How do I edit activity forms?
I find that in many case some of the default fields on activities are not relevant. what's the best approach to editing the templates so that I can control what fields appear on activity forms?

# Answer
> 2 votes
Graham, there are loads of tutorials on how to use jQuery. The CiviCRM approach would be:

1. Identify the ID of the field to hide using FireBug (or the inspect element function of your browser)
2. Add a template with the jQuery required to hide the identified id's which will be something like this:

```
{literal}

    cj(document).ready(function() {
      cj('#firstTestID').hide();
      cj('#secondTestID').hide();
    });

{/literal}
```
3. Add a hook in an extension to add the template with your hides to the template with something like this statement:
```
        CRM_Core_Region::instance('page-body')->add(array('template' => 'GroupProtect.tpl'));
```
OR add the jQuerys to a .extra template (in the documentation https://wiki.civicrm.org/confluence/display/CRMDOC/Page+Templates)

Does this help?

---
Tags: activities
---


# Question
Title: Any elegant way to 'override' a No Bulk Mail setting for a single mailing?
One of our client organizations is sending newsletters to their 4000 members on a regular basis; about 400 of them are not interested in bulk mail and have the No Bulk Mail switch set to On. Once a year though there is a statutory meeting that requires that an invitation is sent to all members, overriding the NoBulkMail setting. So far I've only found awkward ways to arrange for this (moving the members involved into a dedicated group, removing the switch, sending the mail, moving switch back on). Any ideas on how to solve this more elegantly?

# Answer
> 3 votes
Ignoring the no bulk email flag isn't, and shouldn't be an easy process, so what you describe seems to be the "less cumbersome" possible way indeed.

However, it seems to point out to a related issue: these 400 people shouldn't have opted out, but rather it seems should have been unsubscribed from the "regular" newsletter group and kept into the "VIP statutory meeting announcement only" group.

In theory, you can't really reach out to people that have opted out -by definition- but given your specific situation, I would contact them to tell them that you need to be able to mail them, and explain the new "statutory meeting" vs. "newsletter" situation.

---
Tags: civimail
---


# Question
Title: How do I tell what security issues require upgrade?
Just upgraded a site to 4.6.11 (long story as to why).

CiviCRM is showing the "Security update required", which links to https://civicrm.org/advisory

As I click on advisory after advisory, in reverse chronological order starting from "CIVI-SA-2015-011: REFLECTED XSS IN ERROR MESSAGE", *all* have been fixed prior to 4.6.11.

So ... what is the vulnerability then, if I don't upgrade to 4.7.1?

# Answer
> 3 votes
I'm guessing the advisory will be posted any moment, but you should be able to go to 4.6.12 instead of jumping to 4.7. I believe the 4.6.x branch is now a LTS branch so you don't need to go to 4.7 immediately.

**Update:** The advisories have been updated (shortly after I posted) and also an email has been sent to the security list (subscribe here):

> This is a notification of a security release for CiviCRM. We recommend you immediately upgrade to a secure version of CiviCRM.
>
> The most recent releases are CiviCRM 4.7.1 or CiviCRM 4.6.12. 4.4.21 LTS has been released also.
>
> Some fixes affecting security were included in CiviCRM 4.6.10 and 4.6.11, but the email announcements which should accompany such releases was omitted. So, we're releasing 4.6.12 to time with a security release window and ensure subscribers get notified.
>
> Read the security advisories for details of the various fixes included in the latest CiviCRM builds:
>
> A number of other non-security issues have also been fixed in the latest releases. Upgrade now for the most stable CiviCRM experience.
>
> CiviCRM security announcements are available from https://civicrm.org/advisory and via the CiviCRM Security Notifications email list.
>
> CiviCRM.org, San Francisco, CA 94117 United States

---
Tags: upgrade, security, 4.6.11
---


title: Error when merging records

text:
# Question
Title: Error when merging records
I'm getting an error when trying to merge any two records. This seems to have started after I deleted a large number of records. Here's the error message the user gets:

Fatal error: Uncaught CRM\_Core\_Exception: \[0: Transaction integrity error: Expected to find active frame thrown in /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/Civi/Core/Transaction/Manager.php on line 107

I did a backtrace but I don't really know how to read it to glean any useful information. I'm hoping that someone with experience reading these things can enlighten me.

#0 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/CRM/Core/Error.php(182): CRM\_Core\_Error::backtrace()

#1 internal function: CRM\_Core\_Error::handle(Object(DB\_Error))

#2 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/packages/PEAR.php(931): call\_user\_func((Array:2), Object(DB\_Error))

#3 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/packages/DB.php(976): PEAR\_Error-\>PEAR\_Error("DB Error: unknown error", -1, 16, (Array:2), "UPDATE IGNORE civicrm\_entity\_tag SET entity\_id = 9769 WHERE entity\_id = 89495...")

#4 /home/websitename/public\_html/wcc/sites/all/modules/civicrm/packages/PEAR.php(564): DB\_Error-\>DB\_Error(-1, 16, (Array:2), "UPDATE IGNORE civicrm\_entity\_tag SET entity\_id = 9769 WHERE entity\_id = 89495...")

#5 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR-\>raiseError(NULL, -1, NULL, NULL, "UPDATE IGNORE civicrm\_entity\_tag SET entity\_id = 9769 WHERE entity\_id = 89495...", "DB\_Error", TRUE)

#6 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/packages/DB/mysql.php(895): DB\_common-\>raiseError(-1, NULL, NULL, NULL, "1034 \** Incorrect key file for table 'log\_civicrm\_entity\_tag'; try to repair it")

#7 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/packages/DB/mysql.php(328): DB\_mysql-\>mysqlRaiseError()

#8 /home/websitename/public\_html/wcc/sites/all/modules/civicrm/packages/DB/common.php(1216): DB\_mysql-\>simpleQuery("UPDATE IGNORE civicrm\_entity\_tag SET entity\_id = 9769 WHERE entity\_id = 89495")

#9 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/packages/DB/DataObject.php(2442): DB\_common-\>query("UPDATE IGNORE civicrm\_entity\_tag SET entity\_id = 9769 WHERE entity\_id = 89495")

#10 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/packages/DB/DataObject.php(1634): DB\_DataObject-\>\_query("UPDATE IGNORE civicrm\_entity\_tag SET entity\_id = 9769 WHERE entity\_id = 89495")

#11 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/CRM/Core/DAO.php(325): DB\_DataObject-\>query("UPDATE IGNORE civicrm\_entity\_tag SET entity\_id = 9769 WHERE entity\_id = 89495")

#12 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/CRM/Core/DAO.php(1192): CRM\_Core\_DAO-\>query("UPDATE IGNORE civicrm\_entity\_tag SET entity\_id = 9769 WHERE entity\_id = 89495", TRUE)

#13 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/CRM/Dedupe/Merger.php(507): CRM\_Core\_DAO::executeQuery("UPDATE IGNORE civicrm\_entity\_tag SET entity\_id = 9769 WHERE entity\_id = 89495", (Array:0), TRUE, NULL, TRUE)

#14 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/CRM/Dedupe/Merger.php(1344): CRM\_Dedupe\_Merger::moveContactBelongings("9769", "89495", (Array:3), (Array:0))

#15 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/CRM/Contact/Form/Merge.php(330): CRM\_Dedupe\_Merger::moveAllBelongings("9769", "89495", (Array:26))

#16 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/CRM/Core/Form.php(345): CRM\_Contact\_Form\_Merge-\>postProcess()

#17 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/CRM/Core/StateMachine.php(164): CRM\_Core\_Form-\>mainProcess()

#18 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php(61): CRM\_Core\_StateMachine-\>perform(Object(CRM\_Contact\_Form\_Merge), "next", "Next")

#19 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM\_Core\_QuickForm\_Action\_Next-\>perform(Object(CRM\_Contact\_Form\_Merge), "next")

#20 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML\_QuickForm\_Controller-\>handle(Object(CRM\_Contact\_Form\_Merge), "next")

#21 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/CRM/Core/Controller.php(353): HTML\_QuickForm\_Page-\>handle("next")

#22 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(115): CRM\_Core\_Controller-\>run()

#23 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/CRM/Core/Invoke.php(286): CRM\_Utils\_Wrapper-\>run("CRM\_Contact\_Form\_Merge", "Merge Contact", NULL)

#24 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/CRM/Core/Invoke.php(86): CRM\_Core\_Invoke::runItem((Array:13))

#25 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM\_Core\_Invoke::\_invoke((Array:3))

#26 /home/websitename/public\_html/subdomainname/sites/all/modules/civicrm/drupal/civicrm.module(489): CRM\_Core\_Invoke::invoke((Array:3))

#27 internal function: civicrm\_invoke("contact", "merge")

#28 /home/websitename/public\_html/subdomainname/includes/menu.inc(519): call\_user\_func\_array("civicrm\_invoke", (Array:2))

#29 /home/websitename/public\_html/subdomainname/index.php(21): menu\_execute\_active\_handler()

#30 {main}

# Answer
> 1 votes
Just having a quick glance but it looks like you might have a log record (in table log\_civicrm\_entity\_tag)for a contact that you deleted based on this:

```
#6 /home/websitename/public_html/subdomainname/sites/all/modules/civicrm/packages/DB/mysql.php(895): DB_common->raiseError(-1, NULL, NULL, NULL, "1034 ** Incorrect key file for table 'log_civicrm_entity_tag'; try to repair it")

```

I think there is a tag linked to a contact that no longer exists in your log file?

---
Tags: duplicate-contacts
---


# Question
Title: Need to be able to update a Custom Data but nothing else
Before posting I search a lot and try few combinations without success...

What I would like to put in place is the following scenario : create 2 user groups, one that is able to create new contact and edit all fields (let's say AUTHOR), one that is able to view all contacts and can update only one custom data but nothing else (let's say COMMENTATOR).

Here is how I tried to manage that:

* In Drupal role management, I have deactivated *CiviCRM: access all custom data* option for COMMENTATOR role.
* I have mapped COMMENTATOR Drupal role to COMMENTATOR CiviCRM group thanks to CiviGroup Roles Sync module.
* In CiviCRM Administer/USers and permissions/Permissions (Access Control), I have created COMMENTATOR ACL role and then have made the link with COMMENTATOR group.
* In Manage ACLs, I had a new ACL for Role COMMENTATOR, with operation Edit on a set of custom data fields linked to Custom Data COMMENT (properly created before).

When I log with an account with COMMENTATOR role, I can see my list of contact and can't update anything, even not the COMMENT Custom Data (but I see it)...

My first question is : is it possible to do in CiviCRM what I'm trying to do ? If so, obviously I missed something... What am I doing wrong ?

Thanks in advance for your help and advices !

P.S : I work with CiviCRM 4.6.10 on Drupal 6 and, unfortunately, I can only have access to the UI (no access to database or PHP files...)

# Answer
> 1 votes
You might want to consider using webform\_civicrm module. I don't recall how up to date it is with drupal 6 but it should allow you to give your commentators a form which is restricted to just that role, and which has an autocomplete to find the contact and the desired custom field to enter their comment in.

it might even be better if you use the form to add the 'comment' as an Activity if there is the possibility of many 'commentators' adding comments.

---
Tags: custom-fields, permissions, acl
---


# Question
Title: How can I change the wording of the "In Honor of" tab?
How can I say "First Name of Person Being Honored/Memoralized," "Last Name of Person Being Honored/Memoralized," etc. in the contribution page instead of "First Name," Last Name," etc.

# Answer
One option is to use the `.extra.tpl` method (original blog post, forum post or from the wiki) to add jQuery to the page. To identify a potential starting point for which tpl file to use in front of `.extra.tpl`, right-click on your contribution page and View Source. Then do a find (usually CRTL+F) for `tpl`. The forum post suggests that a good starting point might be `CRM/Contribute/Page/Tab.extra.tpl`.

You would select your particular field labels and use a jQuery function like .replaceWith().
> 2 votes

---
Tags: contribution-page
---


title: "Related Permissions Module" settings

text:
# Question
Title: "Related Permissions Module" settings
I installed the extension "Related Permissions Module", and now how do to configure the acl for single organization?

# Answer
> 1 votes
What this extension provides is the ability to deliver access control via Relationships.

Hence if you make Relationship Type xxx a permissioned relationship and then make JOHN a manager for MYCO, and if MYCO has permissioned relationships for Mary and Bob, and you set CiviCRM permissions so that people with Role of Manager to not view/edit ALL contacts then John will be able to only see Mary and Bob, and not other contacts who have no relationship to MYCO

---
Tags: drupal, permissions, relationships, configuration
---


# Question
Title: Birthday block in Drupal without deceased and deleted contacts
I found a piece of code to show a birthday block in Drupal. Had to modify it a little bit to get it to work with the current versions. But I noticed that deleted or deceased persons were still showing up in this list. I don't know the correct code for this. Could someone please fix this code for me and others that are wanting to use this code? My php / mysql skills are not enough but I think it must be something like: $sql = "SELECT * FROM `civicrm_contact` \n" . "where `is_deceased` = false";

```
    <?php
// Check if CiviCRM is installed here.
if (!module_exists('civicrm')) return false;

// Initialization call is required to use CiviCRM APIs.
civicrm_initialize(true);
require_once('CRM/Core/DAO.php');

$query = "SELECT id, display_name, birth_date, CONCAT(((RIGHT(birth_date,5)
< RIGHT(CURRENT_DATE,5)) + YEAR(CURRENT_DATE)), RIGHT(birth_date,6)) AS bday,
concat(concat(month(birth_date), '/'), day(birth_date)) as displaydate,
(TO_DAYS(CONCAT(((RIGHT(birth_date,5) < RIGHT(CURRENT_DATE,5)) + YEAR(CURRENT_DATE)),
RIGHT(birth_date,6))) - TO_DAYS(CURRENT_DATE)) AS toBday FROM civicrm_contact WHERE
(TO_DAYS(CONCAT(((RIGHT(birth_date,5) < RIGHT(CURRENT_DATE,5)) + YEAR(CURRENT_DATE)),
RIGHT(birth_date,6))) - TO_DAYS(CURRENT_DATE) < 7) ORDER BY bday, RIGHT(birth_date,5);";

$params = array( );

$dao =& CRM_Core_DAO::executeQuery( $query, $params );

echo "<div class=\"item-list\"><ul>\n";
while ( $dao->fetch( ) ) {

echo "<li><a href=\"/civicrm/contact/view?reset=1&cid=" . $dao->id . "\">" . $dao->display_name .
"</a>, " . $dao->displaydate;

echo "</li>\n";

}
echo "</div></ul>\n";

?>

```

# Answer
> 2 votes
Try this query (the only difference being the WHERE clause):

```
SELECT id, display_name, birth_date, CONCAT(((RIGHT(birth_date,5)
< RIGHT(CURRENT_DATE,5)) + YEAR(CURRENT_DATE)), RIGHT(birth_date,6)) AS bday,
concat(concat(month(birth_date), '/'), day(birth_date)) as displaydate,
(TO_DAYS(CONCAT(((RIGHT(birth_date,5) < RIGHT(CURRENT_DATE,5)) + YEAR(CURRENT_DATE)),
RIGHT(birth_date,6))) - TO_DAYS(CURRENT_DATE)) AS toBday FROM civicrm_contact WHERE
(TO_DAYS(CONCAT(((RIGHT(birth_date,5) < RIGHT(CURRENT_DATE,5)) + YEAR(CURRENT_DATE)),
RIGHT(birth_date,6))) - TO_DAYS(CURRENT_DATE) < 7) AND is_deceased = 0 AND is_deleted = 0 ORDER BY bday, RIGHT(birth_date,5);

```

---
Tags: drupal
---


# Question
Title: Edits to mail.php for Bluehost still necessary?
Per this thread, I've been editing our `/administrator/components/com_civicrm/civicrm/packages/Mail/mail.php` like so to resolve a mail not sending issue:

```
// if (!empty($headers['Return-Path'])) {
//     $from = $headers['Return-Path'];
// }

```

I've been doing this since v4.4.4, and it is a bit of a hassle. We're on Bluehost, which apparently doesn't offer VERP (whatever that is). I successfully run dozens of Joomla sites on Bluehost and have no intention of moving.

Has anyone found an alternative solution here? Does Bluehost actually offer VERP and I'm just not finding it?

Thanks much.

# Answer
So VERP means that the "technical" sender (smtp envelope) is different for each mail sent. the benefit is that if a bounce comes back to this unique address, we know what email/contact it is (something that is impossible otherwise, as the invalid email might be hidden behind a mail forward)

To make it work, you need two things from your hosting provider:

1. being able to set the technical sender to be different than the visible from email
2. being able to receive the VERP emails back (the trick is usually to have emails servers that can handle "+" notation, so you@yoursite.org receives email sent to you+something\_unique@yoursite.org, something gmail for instance offers, but not exchange servers)

The code you comment out seems to hide the problem 1., but it does **not** fix it. Does the bounce processing work on your site? I would suspect that civicrm isn't aware that some of your recipients have invalid emails and doesn't flag them automatically as bounced. Are you receiving the bounces and doing it by hand?

Anyway, as the solution, having a host that allows VERP is the best option, but another one would be to develop/sponsor a mode that doesn't rely on VERP but on additional email headers. I did implement the first part and every email sent contains extra headers (X-CiviMail-Bounce), what is missing is the second one:

* changing the bounce processor to use this extra header
* changing the mail sending job to only set the header but not the VERP sender
* add a setting to allow to switch to that "mail header only, no VERP" mode

Would you be able to contribute to that code or sponsor that development?

Unfortunately so far, those having the capacity to make it happen found faster and cheaper to switch to a more feature complete host rather than investing into adding that "header only" mode.
> 2 votes

---
Tags: civimail, joomla
---


# Question
Title: Is CiviCRM compatible with the CMS system Umbraco?
Our organisation is interested in creating our new website using Umbraco, but we are unsure if our CiviCRM system would be compatible. Does anyone use CiviCRM with Umbraco or know if they work together?

# Answer
> 5 votes
Umbraco won't work directly with civicrm (they are written in different programming languages, ASP vs. PHP)

What you can do easily is to host your civicrm with one of the supported CMS (drupal, wordpress or joomla) into a subdomain (eg. members.example.org) and switch the main site to umbraco (www.example.org)

the civi site will not use any CMS feature beside handing the login/password, but might want to customise a bit the layout so it looks more or less like your main website (eg set the colors, put your logo), so you can use some civi pages (like donation, membership registration, event registration...) into that sub site without confusing too much your visitors, and add a link to the civi subsite when needed in your main site.

It's not as transparent and nice as having everything on the same site, but plenty of organisations do have different sites for the CRM and the main site, and it seems to work for them

# Answer
> 3 votes
There is no out of the box integration between CiviCRM and Umbraco, only for drupal, joomla and Wordpress.

You can use CiviCRM Profiles to do some (simple) integration between CiviCRM and any Website, e.g. for Newsletter-Signup. You can also create a custom function or forms in Umraco that will exchange data with CiviCRM using CiviCRM's REST API but that requires coding/customisation.

---
Tags: cms-integration
---


# Question
Title: Deleted flag missing from activities returned from API when getting by contact id
I would like to fetch activities by `contact_id` and only return non-deleted activities (or, failing that, return them all but filter them afterwards by `is_deleted`). But I find that passing is `is_deleted=0` does not make any difference and the `is_deleted` flag is not present on the returned data.

I guess this is a bug in the API? Is it known? I searched Jira but couldn't see it. If not I will file it and look at submitting a patch.

I can think of one workaround which is to fetch all the activity ids for the contact and then loop through them fetching each activity (since `in` does not seem to work with activity) by `activity_id` and `is_deleted`. But that could be a lot of api calls and means dealing with more async stuff if using JS. Anyone know of a cleaner workaround?

# Answer
> 0 votes
I think the API should return the is\_deleted! Having said so, if you want to make sure you have the latest version of the activity you could also use the `is_current_revision=1`?

*Editing to add a suggestion in the comments also by @ErikH, which was the solution I went for:*

> Not sure this is of any help but there is an extension for the CaseActivity API: civicrm.org/extensions/caseactivity-api

# Answer
> 0 votes
I had a look on some of my civicrm installs, I didn't find any is\_deleted=1 on my activity tables.

Do you have an example of one of your activities with that flag set? Do you have a better result with is\_deleted=1 on your data?

and when I use the api explorer with is\_deleted=0, I get the is\_deleted attribute that is returned. What civicrm version do you have? Can you try to re-produce on the demo site?

---
Tags: api, activities
---


# Question
Title: Problem with upgrade to 4.7.0 (Wordpress 4.4.2)
I recently upgraded our site to 4.7.0. The upgrade seemed to go well, but now there is a problem when starting it up fresh.

The first time I try to start it, the initialisation seems to get lost in an infinite loop in the routine .../civicrm/civicrm/CRM/Utils/File.php on line 680. Using a debugging statement, it seems to be looking for the file pattern "info.xml".

The weird thing though is, that it starts OK if one tries for a second time without closing the browser.

What could the issue be? I have done no special customisations to my installation (as far as I know)

# Answer
I reloaded the full database yet again. Cleared the caches ultra carefully. Then I set the maximum time limit on my server up to 60 seconds, and the error did not recur.

This time it worked. Hurrah!

BUT - see the various comments. The most important is that I missed the instruction to set up the settings\_location.php file because the bootstrap cannot find the settings file in the STANDARD Wordpress set up! Can't that be corrected?
> 1 votes

# Answer
David, I've seen a few things with the 4.7 upgrades on WordPress that made me double-check the clearing CiviCRM cache's and the browser caches. It hasn't always been apparent that it's been vital in the past, and I'm sure I've been sloppy with it. Is that what you are experiencing?
> 1 votes

---
Tags: wordpress, upgrade, failure
---


# Question
Title: DB Error: no such field Fatal error: Uncaught CRM_Core_Exception: When Creating Reports
I get the following error when trying to create new reports or edit existing ones.

> DB Error: no such field

> Fatal error: Uncaught CRM\_Core\_Exception: \[0: Transaction integrity error: Expected to find active frame thrown in \***/wp-content/plugins/civicrm/civicrm/Civi/Core/Transaction/Manager.php on line 107

I have double checked that we DID run the upgrade script.

"Your database has already been upgraded to CiviCRM 4.7.1" I have run SELECT version FROM civicrm\_domain on the database to verify this is the case.

We are the most up to date Wordpress 4.4.2

I had this error previously and realized it was an extension causing the problem. Disabled the extension and all was right again. Now ALL extensions have been disabled and we are getting the error again.

ETA - Debugging Log

```
# 0 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(182): CRM_Core_Error::backtrace()
# 1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
# 2 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
# 3 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/DB.php(976): PEAR_Error->PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "INSERT INTO civicrm_report_instance (domain_id , title , report_id , descript...")
# 4 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-19, 16, (Array:2), "INSERT INTO civicrm_report_instance (domain_id , title , report_id , descript...")
# 5 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -19, NULL, NULL, "INSERT INTO civicrm_report_instance (domain_id , title , report_id , descript...", "DB_Error", TRUE)
# 6 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(895): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'created_id' in 'field list'")
# 7 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(328): DB_mysql->mysqlRaiseError()
# 8 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_report_instance (domain_id , title , report_id , descript...")
# 9 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2435): DB_common->query("INSERT INTO civicrm_report_instance (domain_id , title , report_id , descript...")
# 10 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1060): DB_DataObject->_query("INSERT INTO civicrm_report_instance (domain_id , title , report_id , descript...")
# 11 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(467): DB_DataObject->insert()
# 12 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Report/BAO/ReportInstance.php(109): CRM_Core_DAO->save()
# 13 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Report/BAO/ReportInstance.php(184): CRM_Report_BAO_ReportInstance::add((Array:93))
# 14 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Report/Form/Instance.php(361): CRM_Report_BAO_ReportInstance::create((Array:93))
# 15 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Report/Form.php(2608): CRM_Report_Form_Instance::postProcess(Object(CRM_Report_Form_Member_Detail))
# 16 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Report/Form/Member/Detail.php(339): CRM_Report_Form->beginPostProcess()
# 17 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(423): CRM_Report_Form_Member_Detail->postProcess()
# 18 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Submit.php(74): CRM_Core_Form->mainProcess()
# 19 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Submit->perform(Object(CRM_Report_Form_Member_Detail), "submit")
# 20 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Report_Form_Member_Detail), "submit")
# 21 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("submit")
# 22 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Wrapper.php(113): CRM_Core_Controller->run()
# 23 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Report/Page/Report.php(72): CRM_Utils_Wrapper->run("CRM_Report_Form_Member_Detail", NULL, NULL)
# 24 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(312): CRM_Report_Page_Report->run((Array:4), NULL)
# 25 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:14))
# 26 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:4))
# 27 /***/public_html/wp-content/plugins/civicrm/civicrm.php(1214): CRM_Core_Invoke::invoke((Array:4))
# 28 [internal function](): CiviCRM_For_WordPress->invoke("")
# 29 /***/public_html/wp-includes/plugin.php(525): call_user_func_array((Array:2), (Array:1))
# 30 /***/public_html/wp-admin/admin.php(236): do_action("toplevel_page_CiviCRM")

```

# Answer
> 1 votes
That's odd that your `civicrm_report_instance` table is missing, and it suggests that maybe the upgrade got interrupted? I'd personally rollback and re-upgrade to be safe. If that's not an option, go into your `civicrm` directory, then into the `sql` directory. The `civicrm.mysql` file contains all the SQL needed to generate a blank Civi database - you can find the `civicrm_report_instance` SQL specific to your version of Civi.

---
Tags: wordpress, civireport, error
---


title: Recurring Contributions Stopped in 2016

text:
# Question
Title: Recurring Contributions Stopped in 2016
I have several recurring contributions for a CiviCRM 4.6.10 site. These contributions were made through CiviCRM and into Authorize.net. They worked multiple times in 2015 but none of the transactions have been recorded in CiviCRM in 2016. We have verified our record with Authorize.net and all of these transactions have been successful.

Thanks in advance.

# Answer
> 2 votes
I found the problem. The permissions were not set correctly for recurring contributions on authorizeIPN.php. So when the silent post was running it was getting a 404. I did not see this in the log. For others out there make sure authorizeIPN.php is retrievable.

---
Tags: civicontribute, recurring-contributions, authorize.net
---


title: CiviCase Error.. Help!

text:
# Question
Title: CiviCase Error.. Help!
I am getting an error when I click *manage case*. Looks like it has something to do with custom fields for a custom field type (DLSE Claim).

Wordpress 4.4.2 CiviCRM 4.6.11

This happened after upgrading to 4.7.. after rolling back, it worked for a while, then started acting funky again.

Below is the debug. Thanks!

backTrace

```
#0 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(182): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/DB.php(976): PEAR_Error->PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...")
#4 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-19, 16, (Array:2), "\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...")
#5 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -19, NULL, NULL, "\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...", "DB_Error", TRUE)
#6 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(895): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'civicrm_value_dlse_claim_details_4.unpaid_wages_162' ...")
#7 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(328): DB_mysql->mysqlRaiseError()
#8 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...")
#9 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2442): DB_common->query("\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...")
#10 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1634): DB_DataObject->_query("\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...")
#11 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(325): DB_DataObject->query("\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...")
#12 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(1192): CRM_Core_DAO->query("\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...", TRUE)
#13 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/CustomGroup.php(735): CRM_Core_DAO::executeQuery("\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...")
#14 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/CustomGroup.php(692): CRM_Core_BAO_CustomGroup::buildTreeEntityDataFromQuery((Array:4), "\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...", (Array:3))
#15 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/CustomGroup.php(626): CRM_Core_BAO_CustomGroup::buildEntityTreeSingleFields((Array:4), 60, (Array:52), (Array:3))
#16 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Case/Form/CaseView.php(190): CRM_Core_BAO_CustomGroup::getTree("Case", Object(CRM_Case_Form_CaseView), "60", NULL, "3")
#17 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(455): CRM_Case_Form_CaseView->preProcess()
#18 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php(94): CRM_Core_Form->buildForm()
#19 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Case_Form_CaseView), "display")
#20 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Case_Form_CaseView), "display")
#21 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(353): HTML_QuickForm_Page->handle("display")
#22 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Case/Page/Tab.php(115): CRM_Core_Controller->run()
#23 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Case/Page/Tab.php(204): CRM_Case_Page_Tab->view()
#24 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(312): CRM_Case_Page_Tab->run((Array:4), NULL)
#25 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:13))
#26 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:4))
#27 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm.php(1189): CRM_Core_Invoke::invoke((Array:4))
#28 [internal function](): CiviCRM_For_WordPress->invoke("")
#29 /home/laaneorg/public_html/portwp/wp-includes/plugin.php(525): call_user_func_array((Array:2), (Array:1))
#30 /home/laaneorg/public_html/portwp/wp-admin/admin.php(236): do_action("toplevel_page_CiviCRM")
#31 {main}

```

# Answer
> 1 votes
duh! I just had to Disable the custom field. Works fine now.

value\_dlse\_claim\_details\_4.unpaid\_wages\_162

---
Tags: custom-fields, civicase, error, php
---


title: Other Relationships

text:
# Question
Title: Other Relationships
I have tried starting over with CiviCase with the new interface as we had not used the XML based configuration. With the new case type I have a section called *Other Relationships*. The information in this area is wrong and I have no idea where it comes from. I want to make sure that these relationships are not shown or not assigned. Please help.

# Answer
On the client's contact summary page, there is a Relationships tab. They come from there. It's intended for relationships that exist outside the scope of the case, like "parent". Whereas a role is a relationship that is just for the lifetime of the case, like case manager.
> 3 votes

---
Tags: civicase, relationships
---