texts: Can tokenValue hooks be used in scheduled reminder emails?

texts:
I have the same problem as at http://forum.civicrm.org/index.php/topic,32608

I have created a tokenValues hook to fetch the value of a field from a multi-record custom field set.  I have the token hook embedded within a message template.  The hook works fine and correctly populates the value if I trigger it from Actions->Send an email.  But when triggered by a Scheduled Reminder based on x days before end of membership, the value is not filled in within the email that goes out.

I have logging within the token hook which shows that the hook is being called and is populating the returned array with the correct value.  I tried to debug further, but I can't figure out from where the tokenValues function is being called.  So I can't figure out why the behavior is different for Action->Send an email vs Scheduled Reminders.

If necessary, I can work around this by running a script to push the value I want into a non multi-record field, as regular custom fields work fine.  But obviously that's a bit of a cludge, and this seems like a bug in CiviCRM.

This is a different issue than that described at  Token not evaluating in CiviMail - that's discussing custom field permissions, which aren't a problem here.


texts: entityRef widget seems to not respecting params

texts:
Whatever has been tried, this code doesn't restrict entityRef widget output according to desired parameters:

$selection = array(132, 168, 169);
$sa_custom_props = array(
  'api' => array('params' => array(
   'contact_type' => 'Individual',
    'id' => array('IN' => $selection)
  )));
$form->addEntityRef(
   'related_contact_id',
    ts('Contact'),
     $sa_custom_props
 );
}

It happens at an attempt to override current contacts select widget at "Add Relationship" (CRM\Contact\Form\Relationship.tpl&.php pair) form, if it matters.  Any piece of advice is highly  appreciated, thanks!


texts:
when deduping contacts holding a custom file field, we're a facing the following error:

One of parameters  (value: 5667c1677bca0_3f2cb71777b83d7a5ed1cca5e7dff69f.jpg) is not of the type Integer

From a first glance at the code I think there may be a bug. As you can see in the stacktrace below, CRM_Core_BAO_File::paperIconAttachment() is feeded with the field's value while it requires the field's id as param.

Could that be?

StackTrace:

Apr 12 10:49:36  [info] $backTrace = #0 CRM/Core/Error.php(366): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 CRM/Utils/Type.php(369): CRM_Core_Error::fatal("One of parameters  (value: 5667c1677bca0_3f2cb71777b83d7a5ed1cca5e7dff69f.jpg...")
#2 CRM/Core/DAO.php(1335): CRM_Utils_Type::validate("5667c1677bca0_3f2cb71777b83d7a5ed1cca5e7dff69f.jpg", "Integer")
#3 CRM/Core/DAO.php(1254): CRM_Core_DAO::composeQuery("\nSELECT    CF.id as cfID,\n           CF.uri as uri,\n           CF.mime_typ...", (Array:2), TRUE)
#4 CRM/Core/BAO/File.php(309): CRM_Core_DAO::executeQuery("\nSELECT    CF.id as cfID,\n           CF.uri as uri,\n           CF.mime_typ...", (Array:2))
#5 CRM/Core/BAO/File.php(691): CRM_Core_BAO_File::getEntityFile("*", "5667c1677bca0_3f2cb71777b83d7a5ed1cca5e7dff69f.jpg")
#6 CRM/Core/BAO/CustomField.php(1233): CRM_Core_BAO_File::paperIconAttachment("*", "5667c1677bca0_3f2cb71777b83d7a5ed1cca5e7dff69f.jpg")
#7 CRM/Core/BAO/CustomField.php(1139): CRM_Core_BAO_CustomField::formatDisplayValue("5667c1677bca0_3f2cb71777b83d7a5ed1cca5e7dff69f.jpg", (Array:44), NULL)
#8 CRM/Dedupe/Merger.php(1411): CRM_Core_BAO_CustomField::displayValue("5667c1677bca0_3f2cb71777b83d7a5ed1cca5e7dff69f.jpg", 88)
#9 CRM/Contact/Form/Merge.php(186): CRM_Dedupe_Merger::getRowsElementsAndInfo("266847", "252170")
#10 CRM/Core/Form.php(519): CRM_Contact_Form_Merge->preProcess()
#11 CRM/Core/QuickForm/Action/Display.php(92): CRM_Core_Form->buildForm()
#12 packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Contact_Form_Merge), "display")
#13 packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Merge), "display")
#14 CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("display")
#15 CRM/Utils/Wrapper.php(113): CRM_Core_Controller->run()
#16 CRM/Core/Invoke.php(286): CRM_Utils_Wrapper->run("CRM_Contact_Form_Merge", "Kontakt zusammenführen", NULL)
#17 CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:13))
#18 CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))
#19 drupal/civicrm.module(454): CRM_Core_Invoke::invoke((Array:3))
#20 [internal function](): civicrm_invoke("contact", "merge")
#21 /d/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:2))
#22 /d/index.php(21): menu_execute_active_handler()
#23 {main}


texts:
I am working on an issue regarding Date Formats (Localization > Date Formats) and it took me a while to realize it is caching due to which changes in Localization.settings.php file were not being reflected. Even after the realization, after every small change I have to clear the cache manually. I used drush ($ drush cc civicrm) to do it which takes about a minute everytime and it is hectic.

So, how can I disable caching?


texts: "Create User Record" - possible to ignore required Drupal User custom fields?

texts:
From the back office admin, creating a user is impossible if there are Drupal fields attached that are required. The workaround has been to temporarily unmark the fields as required, but this is tedious. Is there some modification we can make for it to ignore required Drupal fields when we use this function?

Editing for clarity:

Users register on the Drupal front end - there's a CiviCRM Membership Profile form that asks for additional information.
On top of the Profile (which updates the CiviCRM record), we have a Drupal User field (image below) that allows the User to join an Organic Group at registration (required field).

Because this field is required, we cannot use the "Create User Record" function on the CiviCRM Contact record because of the validation error on the required field.


texts: I have contact form 7 with CiviCRM integration. How can I get API settings? https://prnt.sc/kdqylc


texts: Open CiviCase via Webform with manager role assigned

texts:
We are trying to set up a webform to open a case and assign a case role (manager).
I configured two contacts - coordinator and client - and assigned them to the case in the webform. The client as client and creator and the coordinator to the managing role of the case. For the coordinator contatc I set a static field with a default contact value.
The open case part works fine, but assigning the coordinator as manager does not work. Instead, the first contact (client) is also assigned as manager.
I also tried opening a case without a manager being set. But in this case, the manager role is also assigned to the client contact.
Does anyone have an idea what the problem could be?
System
CiviCRM v5.28.2
Drupal v7.78
Webform CiviCRM Integration v7.x-5.4


texts: Inconsistency with date fields in the API

texts:
I've been working on an extension for civicrm and am using the API to retrieve fields to be used in forms presented to the end user.

I am using the 'html.type' returned to determine which type of html form input to display (text, textarea, select, etc.).

The first issue is that the returned values don't match up with html input types, for example:

CRM.api3('Contact', 'getfield', {
  "sequential": 1,
  "name": "birth_date",
  "action": "get"
})

returns

"values": {
    "name": "birth_date",
    ...
    "html": {
        "type": "Select Date"
    }
}

but Select Date is not an html input type. This isn't too much of a problem as long as Civi is consistent with what it calls a date field. But in the above example, the field birth_date expects a date without a time.

But calling

CRM.api3('Event', 'getfield', {
  "sequential": 1,
  "name": "event_start_date",
  "action": "get"
}

returns the same 'html.type' value:

"values": {
    "name": "start_date",
    ...
    "html": {
        "type": "Select Date"
    },
    ...
}

and yet this field expects a datetime, not just a date.

So if you're trying (as I am) to have an extension operate on a list of fields which can be selected by the user and so aren't known in advance, I can't see any way to differentiate between the two cases.

I may be missing something obvious, but I can't work out what.


texts: How can I automate printing address labels?

texts:
Is there an API call available which could automatically create address labels?

This could be very handy with CiviRules, to have an automatic API-action to create address labels overnight.


texts: Event dup checking applied even though Event configured to allow dup emails

texts:
Civi 5.4 on CentOS server, PHP 7.4 - some patrons and staff report getting message 'participant is already registered' (from Register for Event) or 'looks like you are already registered..' for events where the 'allow_same_participant_emails'  flag is ON (set to 1). When I test it I do not get the message. Is this a browser caching issue with participant? I also thought of using the patch mentioned in CRM-7604 using build_form hook but cannot access patch from archive (https://issues.civicrm.org/jira/browse/CRM-7604).
 The events are all configured correctly to allow dup email registrants.


texts: What's the difference between a pledge and a recurring donation?

texts:
What's the difference if I set up a recurring payment for $100/month versus a pledge for $100/month?

Why should I use one method versus the other?


texts: Setting up Webform CiviCRM with an optional contribution/payment

texts:
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?


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

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

Thanks!

Adam


texts: Wordpress Clean URLs show "Page Not Found"

texts:
Edited my civicrm.settings.php file to enable clean URL's (as described in https://docs.civicrm.org/sysadmin/en/latest/install/wordpress/)
It does not work and any time I try to go to a clean URL page I get the standard wordpress "nothing found page"


texts: Is it possible to move data from a contact type to a component/extension?

texts:
I'm still figuring out how to organize our organization's data before importing it into CiviCRM. One question that came up is whether it would be possible (through the UI or through SQL) to move some custom field set data from a contact type to some CiviCRM component or extension, if such a need arises later on.

To be more specific, I'm thinking of creating a custom field set for the Individual contact type. The field set would store data about an individual's qualifications. This is all well and good, but what if later on it starts making more sense to have the data about individuals' qualifications in some CiviCRM component or extension (e.g. CiviHR)? Then I imagine this data would have to be moved from the custom field set to that component/extension.

I know that in CiviCRM all data across components and extensions is integrated. But who knows, it may turn out that it is much more convenient to have the data about people's qualifications in CiviHR (or other) rather than have it as a custom field set. I don't know how things might develop in the future. And that's the point. I would much rather have the ability to juggle around the data and organize it the way I want to. This kind of flexibility seems important to me, especially since I don't think I'd get the data organizing right the first time.

Or if there are some fundamental flaws in my thinking and my question doesn't make sense, please let me know. Thanks in advance!


texts:
Every now and then I get this error where I am unable to upload images into the CKeditor.
Sometimes switching browsers will help.
I have no issue importing images in mosaico templates for example...
Why is this happening and how can I troubleshoot it?


texts: Smarty URL for Event confirm Registration

texts:
I'm using the Require participant approval feature. CiviCRM 4.6.12 WordPress 4.4.2

I'm trying to send reminders to the people who hasn't already confirmed their place. Having a look at Civi's default confirmation template I can see:

{capture assign=confirmUrl}
   {crmURL p='civicrm/event/confirm' q="reset=1&participantId=`$participant.id`&cs=`$checksumValue`" a=true h=0 fe=1}
{/capture}

Which generates:

https://site.com/civicrm?page=CiviCRM&q=civicrm/event/confirm&reset=1&participantId=123&cs=25e329e8ccb2ac583e2c7f67dbf3faf8_1455187643_504.72666666667

In my custom template I have an API call to get the Participant ID for that event and pass it as a parameter to generate the same URL described above along with the contact's checksum but I don't get the same result:

https://site.com/civicrm?page=CiviCRM&q=civicrm/event/confirm&reset=1&participantId=123&cs=c9d0a39ed785a0aa42fe752ce694a70f_1454935309_168

The later URL generated from my custom template is missing the final parameter at the end of the checksum which I guess is appended by a=true h=0 fe=1 in smarty, what do this parameters do and how to replicate the same behavior?

I know there's Pending participant expiration but is not an option for this specific event.

Any help is much appreciated.

Edit per Xavier's request:

Sorry I agree, I should have been more explicit with what the actual problem is.

My problems is that the generated URL doesn't redirect to the event's Confirmation Page (ie. Confirm Registration/Cancel Registration page) so the participant can confirm their place and submit payment if applies.

This is my smarty snippet in the template:

{crmAPI var='participants' entity='Participant' action='get' sequential=1 event_id=$event_id contact_id=$contact_id}
{capture assign=cksum}{contact.checksum}{/capture}
{foreach from=$participants.values item=participant}
  <a href="{crmURL p='civicrm/event/confirm' q="reset=1&participantId=`$participant.id`&`$cksum`" a=true h=0 fe=1}">Confirm Place
{/foreach}

The output URL is the same as the default template except for the bit after the dot at the end of the checksum

https://site.com/civicrm?page=CiviCRM&q=civicrm/event/confirm&reset=1&participantId=123&cs=25e329e8ccb2ac583e2c7f67dbf3faf8_1455187643_504.72666666667 // default Civi template
https://site.com/civicrm?page=CiviCRM&q=civicrm/event/confirm&reset=1&participantId=123&cs=c9d0a39ed785a0aa42fe752ce694a70f_1454935309_168 // my custom template

There's no errors, but the URL generated from my custom template redirects to the event registration profile instead of the confirmation page.
Hope that makes sense.


texts: CiviVolunteer enabled but not showing in navigation

texts:
I'm attempting to get CiviVolunteer up & going on our wordpress installation of CiviCRM 4.5.8

It's enabled but not showing in the navigation.

Thanks for any help.


texts: End-of-life for Web Spell Checker (WSC) dialog plugin for CKEditor 4

texts:
A client of ours recently brought to our attention that the spell checker functionality that’s partnered with CKEditor 4 is coming to its end of life for the free version by the end of June 2021.
https://webspellchecker.com/blog/2020/12/02/end-of-life-for-spell-checker-dialog-plugin-for-ckeditor-4/

It’s a functionality they wish to continue to use, what alternatives/options are available?


texts: In CiviDiscount 3.1 why is there both a Membership section and Membership in Automatic Discounts?

texts: In CiviDiscount 3.1 it seems you can set up discounts based on Membership ('Discounts for memberships') as well as in Automatic Discounts (discount for members of type, membership statuses).  Why isn't membership + status just in the 'Membership' section? (and why no selection for Contact subtype in Automatic Discounts?)


texts: Is there a reason to use two separate databases for CiviCRM and Drupal, or can I use the same for both? What would be affected if I used the same for both?


texts:
Suddenly an error appeared out of nowhere when managing groups.

  "Count data for smart groups is not currently calculated. You may click Update >Smart Groups to generate it. Be aware this can cause significant server load." (screenshot 1)

When I try to Update Smart Group Count or click on Contacts of any group, there is the error:

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

  DB Error: unknown error

  Return to home page.

  (screenshot 2)

Meanwhile, the database is NOT down. I can access contacts through search.

What could have happened? Where do I start looking for solutions?

CiviCRM 4.7.14. on Drupal 7.52


texts: Custom Event Field does not show for existing events

texts:
I added a custom field (file upload) to the Event object.

It shows up nicely when creating a new event, but is not shown when editing an existing event.

How could I also display the custom field on existing events?


texts:
I am on civicrm spark running 5.32.beta1 and I cannot get images to work on templates with PDF document merge.
Since it's spark I have little control over the backend installation. As far as I can tell I can't use local image hosting located at "https://mysite.civicrm.org/sites/mysite.civicrm.org/files/civicrm/persist/contribute"  so I have tried hosting the images on our main organization webhost and using the url in an image tag. This appears to work fine for emails but will not generate in the pdf output.
I found this help relevant:
https://forum.civicrm.org/index.php%3Ftopic=22663.0.html
but since I'm on spark I don't believe I have any control over the civicrm version or the "allow_url_fopen" field. Can I only use any images already hosted on civicrm.org then? Is there something I'm missing?


texts: How to get data via relationships with APIv4?

texts:
Wilma has  relationship: is campaigner at organisation System Change Not Charity.

How can I get a list of individuals like Wilma and the organisations that they are campaigners for?

I've read the documentation but I can't figure out how I would join on relationship?

I tried this which I thought would at least give me the names of people with that campaigner relationship type, but it gives nothing.

Entity: Contact
Action: get

{
    "select": ["display_name"],
    "where": [
      ["relationships.relationship_type_id", "=", 15]
    ],
    "limit": 25,
    "checkPermissions": false
}


texts: How can I align an image to the top of a cell in civimail?

texts:
Currently it is displaying in the middle...

Name AM


texts: Error when submitting Membership renewal

texts:
I have it turned on to have recaptcha on the anonymous registration pages, and it doesn't show on the renewal page once logged in, like it is supposed to. When I actually try to submit a renewal, it get a console error of
recaptcha__en.js:247 Uncaught Error: No reCAPTCHA clients exist.
    at Array.<anonymous> (recaptcha__en.js:247)
    at Array.<anonymous> (recaptcha__en.js:13)
    at submit (civicrmStripe.b4942341a5b9c992b168cbcd8ee4b5fd.js:485)
    at HTMLInputElement.submitButtonClick (civicrmStripe.b4942341a5b9c992b168cbcd8ee4b5fd.js:403)

I tried to disable recaptcha on the site, even removing the API keys to even prevent the lookup, and I still get this same error. This started after the last 5.26 update, and continues on with the 5.27.0 update using Wordpress.
Edit: I discovered this only happens when I am using Stripe, it works fine when using PayPal. I would prefer to keep using Stripe, but I still haven't been able to isolate the issue.


texts: Membership form not displaying via shortcode

texts:
Wordpress: I'm trying to create a membership form from a contribution form with the following:
[civicrm component="contribution" id="5"]
The shortcode works: if I change the id to "4" a contribution form is present and correct but when I try id "5" it just reverts to the site's home page?
Thanks Guys,
Paul


texts: How to use symfony and doctrine 2 framework for building an extension?

texts: I created an extension using core php and CiviCRM tool(civix). I want to use a symfony(framework) and doctrine(ORM). Beacuse ORM provide some methods to store and retrieve methods are there. Symfony includes a collection and other useful operation.


texts: Groups and sub-groups display broken after upgrade to 4.7.10

texts:
Hi After upgrading civicrm to v4.7.10 from 4.7.8, it looks like the display of groups and sub-groups has changed and is not partially broken.

The first group and has sub-groups is displayed showing that there are sub-groups. The second group that has sub-groups and sub-sub-groups shows as a regular group but not that it has sub-groups.

This prevents from accessing the sub-sub-groups. They can only be in searching for them in the Find so it appears to be a display issue only.


texts: How to spoof users to unit test ACL logic

texts:
Starting to think about unit testing access control permission logic in API calls.

Is there an established pattern for this?

Within CiviUnitTestCase and ACLPermissionTest there are these snips:

Setup: $config->userPermissionClass->permissions = array();
$this->createLoggedInUser(); (creates and masquerade as a user, returning the new users contactID)
$this->setPermissions($permissions)
$session = CRM_Core_Session::singleton(); $session->set('userID', $contactID);
$this->setupACL();
tearDown: $config = CRM_Core_Config::singleton(); unset($config->userPermissionClass->permissions);

(assuming $config = CRM_Core_Config::singleton())

I'm still staring at the bowl...


texts: How can I modify the existing report template?

texts:
we use the [source] and [external ID] heavily. They are standard civi fields however they do not appear on the report template (detail or summary versions).

Pointers on where to go to update the standard template much appreciated!


texts: jquery datepicker missing (wordpress) after updating to 5.26 from 4.6.33?

texts:
A site I inherited a while back finally needed to be updated to a much more modern level including PHP version, MariaDB version and Wordpress version along with CiviCRM.
Seen first in the LYBNTY report - the date range fields are simply dropdowns with entries like 'Yesterday', 'Last week', etc. but no ability to actually pick a date range.
I have checked Access Control which all looks good (but I am administrator so should have all those already).
Checked the header links for jquery and seems I have access to them.
Is there a setting somewhere to turn jquery entities off/on?  Or could I be missing a path even though the update was in place and not moved?
Everything else seems to be working just fine.
I might add that the Summary Fields extension is still quite old and is marked as needed an update.  Could this have anything to do with this as in not being compatible with the 5.26 version of CiviCRM?
I'm stumped here so any suggestions would be fantastic!
TIA!


texts: zero s after the decimal in simple donate

texts:
Hi  I am using CiviCrm 5 on wordpress,

donation amounts displayed with zeros floating points after the decimal for example 25.00000000 instead of 25

Is there any solution?


texts: Can I create a Smart Group programatically?

texts:
I'm setting up our system to match up contacts with the geographical regions covered by our different chapters.  I've gotten to the point of using the  built in geocoding, along with polygon coordinates stored in a custom field for each chapter, to be able to create a relationship showing a contact "in the territory of" a chapter.  I'll use hooks to create or remove the relationship if a contact address or chapter region changes.

I envisioned having multiple smart groups for each chapter - contacts who are "in the territory of" and members, or volunteers, or on the national mailing list, etc.

Is there a way to create smart groups via the API or DAO calls?  It'd be ideal to create desired smart groups via a hook if a new chapter is added, rather than having to manually search on the desired parameters and create each group.

If not, maybe I'll create static groups from hooks, then have a cron job that syncs contacts to those groups.  Basically implementing my own smart groups.  Thoughts?


texts: Testing a module which uses CiviCRM php api

texts:
I have written a drupal module that uses the CiviCRM api. I want to build tests for my module. Drupal 7 includes the simpletest module in core, so I'm using that. I have created the following test:

class ExampleCiviCRMTestCase extends DrupalWebTestCase {

public static function getInfo(){
    return array(
        'name' => 'Example CiviCRM Test',
        'description' => 'Check that CiviCRM API can be used in tests',
        'group' => "CiviCRM",
    );
}

public function setUp() {
    parent::setUp(array('civicrm'));
}

public function testCivicrmWorks(){
    civicrm_initialize();
    try {
        $result = civicrm_api3('Contact', 'get', array(
            'sequential' => 1,
        ));
    } catch (CiviCRM_API3_Exception $e) {
        $error = $e->getMessage();
        $this->fail($error);
    }
    $this->assertFalse(empty($result['count']));
}
}

This test fails. The error page states that the civicrm module was successfully enabled, but then this error occured:
Access to undeclared static property: Database::$ignoreTargets. The error occured in database.inc on line 1473. Does anyone have any experience using simpletest with civicrm?


texts:
Downloaded and installed Shoreditch Extension 0.1-- alpha12.zip on CiviCRM 4.7.27, WordPress 4.8.3, yet I cannot see any change in the theme.

Haven't found any evidence of installation errors so far. Tried uninstalling and reinstalling, no change.

There is now an option under Resource URLs - Custom CSS for Shoreditch, but when I select that option I lose all CiviCRM menus.

Does anyone know what else I have to do to make this extension go?

Ultimate goal is to get Mosaico extension installed.


texts:
We've updated our CiviCRM to version 5.2.2 and Mosaico to version 2.0 beta 4 and since then we are not able to send any mailing from CiviCRM.

To be clear we can mail to a person individually. Because we are hosting our website on a VPS I was able to check the email log. I noticed that emails (to one person) are going out correctly, but when I try to send a mailing I get something like this "The sender address  is not a valid 553 5.1.2 RFC-5321 address.". Sometimes the from address is empty.

I'm hosting on a Plesk server 17.5.2 with PHP 7.1.

Is there someone who has idea's for a solution?

EDIT:
Jul  6 11:24:11 srv1 postfix/pickup[15216]: B363D8F4B73: uid=10006 from=
Jul  6 11:24:11 srv1 postfix/cleanup[19523]: B363D8F4B73: message-id=<20180706092411.B363D8F4B73@shost.tld>
Jul  6 11:24:11 srv1 postfix/qmgr[15217]: B363D8F4B73: from=, size=89808, nrcpt=1 (queue active)
Jul  6 11:24:11 srv1 postfix/smtp[19542]: B363D8F4B73: to="", relay=aspmx.l.google.com[2a00:1450:4013:c04::1b]:25, delay=0.09, delays=0.01/0/0.07/0.01, dsn=5.1.2, status=bounced (host aspmx.l.google.com[2a00:1450:4013:c04::1b] said: 553-5.1.2 The sender address  is not a valid 553 5.1.2 RFC-5321 address. u42-v6si5509030edm.404 - gsmtp (in reply to MAIL FROM command))


texts: How to use full unicode on custom fields

texts:
There's an API call System.utf8conversion which will change all your tables to MySQL/MariaDB's utf8mb4 format, i.e. full unicode with emoji support, rather than the incomplete utf8 implementation of old.
I ran this and it worked fine but then found that when I add a custom fieldset, that table is set to the old UTF8 charset.


texts: CiviEvent automatically send survey after event

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


texts:
Using 5.17.5 on Wordpress, I've got the dreaded error on a member search form: "The requested Profile (gid=10) is disabled OR it is not configured to be used for 'Profile' listings in its Settings OR there is no Profile with that ID OR you do not have permission to access this profile"

The search form works for admins, but not other users or members.

I'm using [civicrm component="profile" gid="10" mode="search" hijack="0"] on the search page.

In Admin>Customize Data/Screens>Profiles, the profile exists:

The profile is active:

These are the fields:

Is this a problem with an ACL? Search settings? How do I fix this?


texts: Multi-client capability und data storage

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

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

Regrads, Jörg


texts: Adding expired/grace membership numbers to the Membership Dashboard

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

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

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

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

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


texts:
Has anyone integrated Civi with some sort of NCOA (National Change Of Address) service in the United States?  TrueNCOA API Informatoin

A related question can be found here.


texts: Wordpress - CiviCRM upgrade 4.6.8 to 4.7.10 causes HTTP ERROR 500

texts:
After a successful upgrade from CiviCRM 4.6.8 to 4.7.10, our Wordpress site and CiviCRM does not load anymore from the Wordpress Admin page. We get "HTTP ERROR 500".
Any ideas why and how to recover and get CiviCRM to launch?


texts:
I want to disable the CiviCRM breadcrumbs inside the program code for security reasons.
I tried modifying sites/all/modules/civicrm/CRM/Core/DAO/Menu.php by adding $skipBreadcrumb['type'] = TRUE; in the public static function &fields() function (where $skipBreadcrumb is set).
I also tried commenting out the public function addBreadCrumb() and its call in public function preProcess() inside the sites/all/modules/civicrm/CRM/Report/Form.php.
I know the path sounds incorrect for what I want to do, but it was the only search result for 'breadcrumb' in a function that I could find.
Can anyone give me a hint?
Edit: Probably it was exaggerated to talk of security reasons here. It is more about not making any pages visible as default that users don't need, that is, keeping the (visible) system slim.


texts: CiviCRM issue when subscribing on behalf of an organisation with 4.7.3 and 4.7.4 releases

texts:
A few weeks ago, my team started using CiviCRM (4.7.1) with Drupal (7.42). We created different Web pages to test different membership types (individual and on behalf of organization). Everything seemed to be good back then. When someone subscribed on behalf of an organization, both types of contacts were created and a relationship (Employer/Employee) was set. We upgraded to CiviCRM  4.7.3 and now when someone subscribes on behalf of an organization, only the contact is created, not the organization anymore. Same issue with the 4.7.4 release.

Once the membership is submitted:

with 4.7.1:

Notice : Array to string conversion dans   CRM_Contribute_Form_ContributionBase->buildCustom() (ligne 650 dans ******/sites/all/modules/civicrm/CRM/Contribute/Form/ContributionBase.php).
Notice : Array to string conversion dans    CRM_Contribute_Form_ContributionBase->buildCustom() (ligne 650 dans ******/sites/all/modules/civicrm/CRM/Contribute/Form/ContributionBase.php).
Notice : Undefined index: html_type dans CRM_Contribute_Form_Contribution_Confirm->buildQuickForm() (ligne 520 dans ******/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Confirm.php).
Notice : Array to string conversion dans CRM_Contribute_Form_ContributionBase->buildCustom() (ligne 650 dans ******/sites/all/modules/civicrm/CRM/Contribute/Form/ContributionBase.php).
Notice : Array to string conversion dans CRM_Contribute_Form_ContributionBase->buildCustom() (ligne 650 dans ******/sites/all/modules/civicrm/CRM/Contribute/Form/ContributionBase.php).

with 4.7.3 or 4.7.4:

Notice : Array to string conversion dans CRM_Contribute_Form_ContributionBase->buildCustom() (ligne 650 dans ******/sites/all/modules/civicrm/CRM/Contribute/Form/ContributionBase.php).
Notice : Array to string conversion dans CRM_Contribute_Form_ContributionBase->buildCustom() (ligne 650 dans ******/sites/all/modules/civicrm/CRM/Contribute/Form/ContributionBase.php).
Notice : Undefined index: html_type dans CRM_Contribute_Form_Contribution_Confirm->buildQuickForm() (ligne 521 dans ******/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Confirm.php).
Notice : Undefined offset: 0 dans CRM_Financial_BAO_FinancialAccount::getFinancialAccountForFinancialTypeByRelationship() (ligne 235 dans ******/sites/all/modules/civicrm/CRM/Financial/BAO/FinancialAccount.php).
Notice : Array to string conversion dans CRM_Contribute_Form_ContributionBase->buildCustom() (ligne 650 dans ******/sites/all/modules/civicrm/CRM/Contribute/Form/ContributionBase.php).
Notice : Array to string conversion dans CRM_Contribute_Form_ContributionBase->buildCustom() (ligne 650 dans ******/sites/all/modules/civicrm/CRM/Contribute/Form/ContributionBase.php).

The only difference is a new bug from 4.7.3:

Notice : Undefined offset: 0 dans CRM_Financial_BAO_FinancialAccount::getFinancialAccountForFinancialTypeByRelationship() (ligne 235 dans ******/sites/all/modules/civicrm/CRM/Financial/BAO/FinancialAccount.php).

We tried this on the demo site and we have the same behavior. See http://dmaster.demo.civicrm.org/civicrm/contribute/transact?reset=1&id=4

Any hint would be welcome!


texts: I am trying to install a new payment processor.  Right now, visitors to my site only have an option to give their credit card, but I also want them to have the option to do a "Bank Account Transfer."  How would I do this?


texts: Need help understanding contacts hierarchy

texts:
I am new to Civi (I started working for a company that is using it). I actually started this question in Civi community and was guided here.

Our company currently uses civi to track our corporate membership. We want to import our clients who are schools and districts, as well. Except we have a concern about how to organize schools and districts (Schools come to us as projects from the district level and it is our end goal to use civicase to monitor our projects).

One of our plans is to import schools as individuals and create a Contact Type properly identifying them as schools and import Districts as companies.

Another suggestion made was importing both as companies and properly identifying the Contact Type in this way (ie, schools, districts, corporate)

A third idea was to import schools as companies and districts as a household. But I am not sure how the relationships will work between these.

As someone new to civi, it is difficult to see the advantages and drawbacks of each option. On top of which, occasionally our projects names are different to the school name and we keep record of both.

Any input or advice would be greatly appreciated!


texts: How can I change the user access permission (read write mode for different user) using drupal and civicrm?

texts: I want to set a different values for different users(Read/write permission) by using php not by a customizing (Drupal menu - > People -> permission).


texts: Has anyone added discounting functionality to the 'cart' component of CiviEvent?

texts: I am testing/trying to use CiviEvent 'shopping cart' (needs to be enabled using CiviEvent Component Settings under Administer/CiviEvent) mode of registering for events and while I am on an older version of Civi I looked at 4.6 code and it looks about the same re: Cart functionality. I have modified Cart code to allow for using CiviDiscount, if an event is configured to allow discounts - is anyone else interested in this? I will submit a patch if so. (there are other features that seem lacking in Cart, I will include a README to document)


texts: I would like users to see their own CiviCRM Contact View straight away at log-in. I could create a Drupal module to do this, but what if I want the solution to be CRM independent. Can it be done in CiviCRM itself?


texts: Can you please tell me if CiviCRM is accessible by the blind using a screen reader ie; Jaws, Window Eyes or NVDA? If so were customizations required?


texts:
We are planning to restructure our membership types slightly later this year. We will eliminate two or three categories and change the amounts (up) and possibly the names.

Right now, the renewal default on the membership type radio button appears to be the current membership type. We would like to manage what the default is when the existing membership type is obsolete. I can only find how to manage the default on new memberships, not renewals. The documentation doesn’t seem to help.

We are Joomla.


texts: How can I increase the rate at which the 'fetch bounce' job works

texts: The scenario is that bounces weren't being fetched and there is now a major backlog, and that running 50 every cron is too slow to make real progress.


texts: Civicrm Angular Module system generated files keeps growing exponentially

texts: Does anyone know why the angular-modules system  generated files in the contribute/dyn keeps growing at en exponential rate. Also clearing the cache doesn't seem to delete these files. We have more than 10k of those files at the moment. Any Ideas?


texts: CiviVolunteer on 4.6.5: Error while enabling volunteer management on event

texts:
When I enable volunteer management with the form "volunteer signup", I get the error shown in the image.

I tried reinstalling CiviVolunteer but now get this error:

Might be related with this issue:

Error while installing CiviVolunteer on civicrm 4.6.5


texts: Drupal account creation adds users into a CiviCRM group or tags them

texts:
We are trying to create a report that shows our new website members (those who have created an account) who are designated by mandatory CiviCRM profile fields that define a member type which the user selects at registration. These fields are displayed on the Drupal registration and account editing screens.

When users create an account on Drupal, a contact is either created for them in the CiviCRM, or a matching and existing CiviCRM contact record is found and updated. The custom fields already exist and are displayed on the website. What I would like to do is have the contact record be either added into a group or given a tag, which would ultimately make it easier for me to generate accurate reports about our different "members". The tag or group would be the same for all users. Something like "Users who registered for an account". Some of our contact records are created for other reasons so that's why I want to distinguish between the two.

Drupal 7, CiviCRM 4.7.27


texts:
What is the best way of getting fields from grants available as tokens for mail/PDF-merge?
No native tokens?
Not available in form processor extension?


texts:
I've set up a webform to create two memberships at a reduced rate vs two individual memberships.  I select two contacts, each has a membership.  The payment is associated with the first member.  There are options for 1, 2, or 3 years.  As an example, individual membership for 1 year is $15, and I want to register two people at the same postal address as members for $20.  Setting up the form everything looks fine, with some exceptions.  I can even use the feature to copy the postal address of the first member to the second member, cool.  One problem is that both members are given the option of membership type (1,2, or 3 yr).  In fact, what I want is the chosen term applied to both.  Only member one pays, and both get memberships.

Anyway, I fill out the form for both members and submit to PayPal standard.  I don't complete the payment.  I see a pending household membership for member 2 which presumably would show as completed if I actually paid.  But there is no payment for member 2, pending or otherwise.  Member 1 has no payment or membership record at all.

So, I thought I could probably work this all out if I was able to hook into the PayPal Instant payment notification (IPN).  I thought there would be some civiCRM hooks for this, but I don't see any.  So, I really need to know when the payment is completed and assign membership to both.


texts: How to search for contacts not in a group through the Search Builder

texts:
I'm trying to search for contacts who do NOT belong to a given group. I'm using the Search Builder.

For Record Type, I select Contacts. Then for Field, I select Group(s). Then I select the ≠ operator. And finally I select the group name.

The problem is that it adds a search criteria that I didn't specify. After making the search, it displays my search criteria as:

Group(s) ≠ MyGroupName ...AND...
Group Status "Added"

I did not specify any group status and in this context it doesn't make sense for the Search Builder to automatically add it. So, am I doing something wrong or does this seem like a bug?


texts: Fixing Paypal error - Payment Processor Error message 10002: Security error Security header is not valid

texts:
I found the solution to my problem before coming here, but wanted to share it so I'm posting my question first and then going to post the answer I discovered.

I setup Paypal pro for payments using my Paypal sandbox account, but was getting the following error:

Payment Processor Error message 10002: Security error Security header is not valid

See my answer for solution


texts: Upgrading a server that's hosting CiviCRM to get to PHP 7

texts:
I did the deed and upgraded from Debian 8 to 9 and from PHP 5.6 to PHP 7.0. I wanted 7.1 but the host recommended I stick with the native packages since the 7.1 broke the SOAP function. I've been having all kinds of issues since the upgrade, such as users getting a DB error when trying to subscribe or use the contribution form, and numerous issues or errors in the log. Without going into that detail, I am wondering if there was any provisioning I need to do? I tested it all on a different PHP 7.1 server without issue.

How can I check the database integrity, etc. of the CiviCRM and is there a checklist to make sure the upgrade didn't break something
Is there a pre and post-upgrade CRM and server provisioning checklist?
What is the recommended MySQL version?

It seems like some simple setting got overwritten somewhere on the server.

Drupal 7, CiviCRM 5.7.2

An example of the problems we've run into since upgrading the server, no settings in CiviCRM or Drupal were changed and to my knowledge, no file permissions were changed:

Postfix status is excited
CiviSMTP keeps sending a notification that our password and username is wrong but testing the settings in CiviCRM and CiviSMTP reports that they are correct
The soap user also had an issue and our first mailing had a 100% failure rate. My host downgraded to PHP7.0 to stick with native Debian 9 packages. Mailings seem to work now
CiviMail drafts take forever to save or give an error that they can't be saved because content is out of date (posted separately)
CiviCRM sometimes runs very slowly
Users get an unknown db_error when trying to submit a contribution form (a lot of the time but not every time, posting separately)
Unknown DB Error for query UPDATE  civicrm_mailing. Error includes the full HTML of the email. (Submitting separately).
Several/constant MySQL deadlocks
Several in log: "We can't load the requested web page. This requires cookies to be enabled...". (Submitting separately).

I want to post in server fault also but when they see "CiviCRM" they might assume it goes here.


texts:
Using the "Bookkeeping with extra fields" template, I noticed I was occasionally missing some transactions whenever I filtered on Transaction Date. I believe the issue is caused by the filter using only the date and not the time.

For example, if today is February 10 and I filter Transaction Date on "Yesterday", the WHERE clause looks like:

  ( financial_trxn.trxn_date >= '20190209') AND ( financial_trxn.trxn_date <= '20190209' )

Any transaction that isn't exactly at midnight is lost. Comparing to the Date Received filter, it uses date and time:

  ( contribution.receive_date >= '20190209000000') AND ( contribution.receive_date <= '20190209235959' )

Perhaps I'm misinterpreting the use of the filters. I can run the same query directly, but with the time included for Transaction Date, and it seems to return the correct results.

CiviCRM 5.10.0
PHP 7.2.13
MySQL 5.7.23
Wordpress 5.0.3

EDIT - originally this Q referenced ExtendedReports 3.5 but turns out it was a core report


texts: Linking to CiviCRM forms from external sources - not working

texts: Whenever a CiviCRM URL is used in external content such as a Mailchimp email, a bit.ly link, even social media, the page loads fine but submitting it either kicks the user back to the homepage, or results in a "too many redirects" error. We have sh404SEF enabled but no matter what setting it is on, this problem persists.


texts:
I am using CiviCRM with Wordpress but I am having some trouble with getting pages in Civi to work in Wordpress.

For example, any time I try to view a contribution page, it takes me to a Wordpress page called CiviCRM that says "Do not delete this page. Page content is generated by CiviCRM."

No Civi content is actually there, just that text.

How can I get the actual contribute pages?


texts: Is there a way to enable or install the full version of CKEditor in CiviCRM 4.6.x?

texts:
So is there a way to enable or install the full version of the free and open source CKEditor in CiviCRM 4.6.x ?

Looks like the CKEditor Standard editor (see http://ckeditor.com/demo#standard ) is installed with Civi (see http://d46.demo.civicrm.org/civicrm/a/#/mailing/37 ), but the "full featured" version ( see http://ckeditor.com/demo#full ) has more useful stuff, particularly aligning and centering text.

I've used the full version on the CKEditor demo site just to center text for a CiviMail mailing. That works, but having the full featured version right in CiviMail would be handy.


texts:
I am using civicrm 4.7.7 on Drupal 7. How can I create a report of all mailings sent with CiviMail reporting the data of contacts that opened/clicked/replied the mailing?
Thanks in advance


texts: Registering 0.5 of a participant! Should this be possible?

texts:
I was surprised to find, while testing the 'Minimum Amount' setting for a Price Set, that you could put eg 0.1, or 3.14159, in to the Text/Numeric Quantity field.

This seemed wrong but I assume that overcoming this correctly would mean that Price Set should have another Field option of Integer.

Any thoughts?


texts:
I choosed as default organisation an individual instead an organisation.
Can I change this or is there a solution?

Thousand thanks for your help.

Regard, Oliver


texts:
We've been looking for simple, mobile-first, CiviCRM friendly theme, to dovetail with a modernized version of our non-Drupal front end. The CiviCRM  site looks swell, y'all! I'm sure there were some custom moves made, but would you mind telling what you started with if anyone is around who knows?

Gratefully,

Clay Kilgore
San Francisco


texts:
When sending an email and if I insert a link or insert an image, I can't close the dialog when using IE11.

This works perfectly with IE9, Firefox and chrome browsers.

Has anyone experienced this?


texts: Errors on install WP 5.02 (fresh install) , Civicrm 5.82, PHP 7.2.13 (xampp)

texts:
I installed civicrm 5.82 on a fresh install of Wordpress 5.02 with PHP 7.2.13 (xampp). Went through civicrm setup, then saw a few PHP warnings on the CiviCRM Home page. This is running on my local dev computer (Win 10) and I have HTTPS enabled.

The errors are:

Warning: get_headers(): SSL operation failed with code 1. OpenSSL Error messages: error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed in F:....\wp-content\plugins\civicrm\civicrm\CRM\Utils\Check\Component\Env.php on line 917
Warning: get_headers(): Failed to enable crypto in F:....\wp-content\plugins\civicrm\civicrm\CRM\Utils\Check\Component\Env.php on line 917
Warning: get_headers(https://civicrm.test/wp-content/plugins/civicrm/civicrm/packages/jquery/css/images/arrow.png): failed to open stream: operation failed in F:....\wp-content\plugins\civicrm\civicrm\CRM\Utils\Check\Component\Env.php on line 917

It seemed to install fine. I'm going through the settings and entering values with no problem so far.

Is there anything I should check or watch out for due to these errors?

Thanks.


texts: Is it possible to integrate a custom Drupal donate form with CiviCRM?

texts:
I'd like to build a custom Drupal form (not using webform) to use as a contribution form and want to know if it is possible to integrate it with CiviCRM. I am not very familiar with Civi's Api capability, so want to ask to make sure it is doable before I jump in...
Do you know of an existing example of such a form?


texts: Sync smart group to WordPress role, group, or capability

texts:
I have a WordPress site which is already using the CiviCRM WordPress Member Sync plugin to sync memberships to roles.

On this same site, I also want to show/hide certain content based on the user's having a membership of any type, age, or status -- basically, if they've ever had a membership, WP should use that fact to show/hide some content.

This show/hide should be possible with roles, capabilities, or groups, but I can't yet find a way to sync this "ever been a member" status to one of those. It seems like it requires a smart group in CiviCRM, and then I don't see any existing plugins that support syncing smart groups to roles, capabilities or groups.

Also, we need to continue using CiviCRM WordPress Member Sync for its current usage, and it doesn't seem to support additional sync rules beyond "one rule per membership type" and "only sync to roles, groups OR capabilities, but not to any combination of those."

Is there a plugin or combination of plugins that will allow this to be done? Or does this need a custom-built plugin?


texts:
I have 3 events that I would like to offer a 15% discount to any user that purchases all three. I've found how to do this with Woocomerce by doing some googling but I have yet to find a method for CiviDisocount to do anything similar. It would be greatly appreciated for any sort of assistance. Thank you
Roy


texts:
Contributions have been processed correctly so far, but when clicking on continue in both Paypal and Redsys (credit card) the following error appears (both Live and Test)

php_network_getaddresses: getaddrinfo failed: Name or service not known

Array

(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
       )

    [code] => 0
    [message] => php_network_getaddresses: getaddrinfo failed: Name or service not known
    [mode] => 16
    [debug_info] =>
    [type] => PEAR_Error
    [user_info] =>
    [to_string] => [pear_error: message="php_network_getaddresses: getaddrinfo failed: Name or service not known" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info=""]
)

backTrace

#0 / ...  /modules/civicrm/CRM/Core/Error.php(182): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(PEAR_Error))
#2 / ...  /modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(PEAR_Error))
#3 / ...  /modules/civicrm/packages/PEAR.php(566): PEAR_Error->PEAR_Error("php_network_getaddresses: getaddrinfo failed: Name or service not known", 0, 16, (Array:2), NULL)
#4 / ...  /modules/civicrm/packages/Net/Socket.php(156): PEAR->raiseError("php_network_getaddresses: getaddrinfo failed: Name or service not known", 0)
#5 / ...  /modules/civicrm/packages/HTTP/Request.php(737): Net_Socket->connect("query.yahooapis.com", 80, NULL, NULL, NULL)
#6 / ...  /modules/civicrm/CRM/Utils/Geocode/Yahoo.php(127): HTTP_Request->sendRequest()
#7 / ...  /modules/civicrm/CRM/Core/BAO/Address.php(387): CRM_Utils_Geocode_Yahoo::format((Array:13))
#8 / ...  /modules/civicrm/CRM/Core/BAO/Address.php(144): CRM_Core_BAO_Address::fixAddress((Array:13))
#9 / ...  /modules/civicrm/CRM/Core/BAO/Address.php(120): CRM_Core_BAO_Address::add((Array:13), TRUE)
#10 / ...  /modules/civicrm/CRM/Core/BAO/Location.php(69): CRM_Core_BAO_Address::create((Array:34), TRUE, NULL)
#11 / ...  /modules/civicrm/CRM/Contact/BAO/Contact.php(348): CRM_Core_BAO_Location::create((Array:34), TRUE)
#12 / ...  /modules/civicrm/CRM/Contact/BAO/Contact.php(1897): CRM_Contact_BAO_Contact::create((Array:34))
#13 / ...  /modules/civicrm/CRM/Contribute/Form/Contribution/Confirm.php(2066): CRM_Contact_BAO_Contact::createProfileContact((Array:35), (Array:14), "7327", (Array:0), NULL, "Individual", TRUE)
#14 / ...  /modules/civicrm/CRM/Contribute/Form/Contribution/Confirm.php(594): CRM_Contribute_Form_Contribution_Confirm->processFormSubmission("7327")
#15 / ...  /modules/civicrm/CRM/Core/Form.php(423): CRM_Contribute_Form_Contribution_Confirm->postProcess()
#16 / ...  /modules/civicrm/CRM/Core/StateMachine.php(160): CRM_Core_Form->mainProcess()
#17 / ...  /modules/civicrm/CRM/Core/QuickForm/Action/Next.php(61): CRM_Core_StateMachine->perform(Object(CRM_Contribute_Form_Contribution_Confirm), "next", "Next")
#18 / ...  /modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Contribute_Form_Contribution_Confirm), "next")
#19 / ...  /modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contribute_Form_Contribution_Confirm), "next")
#20 / ...  /modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("next")
#21 / ...  /modules/civicrm/CRM/Core/Invoke.php(312): CRM_Core_Controller->run((Array:3), NULL)
#22 / ...  /modules/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:15))
#23 / ...  /modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))
#24 / ...  /modules/civicrm/drupal/civicrm.module(454): CRM_Core_Invoke::invoke((Array:3))
#25 [internal function](): civicrm_invoke("contribute", "transact")
#26 / ... /web/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:2))
#27 /... /web/index.php(480): menu_execute_active_handler()
#28 {main}

I need help. Anyone got any ideas?

Thks


texts: Could not create a database trigger on AWS RDS

texts:
I am installing CiviCRM in Amazon AWS environment. User civicrm has full rights on civicrm database. I certainly see TRIGGER among all others in my phpMyAdmin console. Out of abundance of caution I even gave global TRIGGER permission. Still, I am getting the error.
I had a test installation with DB running on the same server as web server and didn't have any problems. Don't know if CiviCRM doesn't see TRIGGER permission because of different host, or because of RDS limitations, or yet something else.

Web Server is Amazon Linux (similar to Fedora/CentOS); Apache 2.4; MySQL is 5.6.27

UPDATE: I tried "root" account and I get the same error. I don't think (or at least I don't know how) I can spool the SQLs that get generated - so if somebody can point me to a query that tries to create a trigger and fails, that would be awesome!


texts: DB Error: no such field afer civicrm_domain truncate

texts:
In an attempt to solve an issue of

  'Please make sure the folder is writable' in
  .../sites/all/modules/civicrm/packages/IDS/Monitor.php

I started looking for solutions in the forums. I followed an advise which became fatal for me. The advise can be read here: https://forum.civicrm.org/index.php?topic=5390.msg41785#msg41785 , namely to truncate civicrm_domain, which someone confirmed to be effective. It was effective for me in that it broke civi completely. Now after log-in I get everywhere the error:

  Sorry but we are not able to provide this at the moment. DB Error: no
  such field

How to repair civicrm_domain?


texts: Contribution Amount via Webform Conditionals (Error)

texts:
I use CiviCRM Webform Integration for Event Registration and Payment ; and I use Conditionals to calculate the Contribution Amount :

If ... Then Conditional Amount is set to 45,00  (french format)

When I submit the registration, I get the following error :

Warning : preg_match(): Compilation failed: nothing to repeat at offset 464 dans webform_number_format_match() (ligne 831 dans /home/paroisse/public_html/test/drupal/sites/all/modules/webform/components/number.inc).
Contribution Amount field value must format numbers as "12 345,68".

(But, if I set this Conditional Amount = 45,00 manually, the submission is OK.)

Is there any explanation for this error ?


texts: Make phone type value "mobile" for every individual

texts:
We need to switch every individual contact's phone type to mobile. I have an SQL query that I could run manually, but for the civicrm_phone_before_update trigger using a function that doesn't get defined when running manual queries.

FUNCTION [db].civicrm_strip_non_numeric does not exist is the error that pops up when I try to run the query.

And I had no luck trying to edit the trigger so it would temporarily associate with a different table. I'd DROP the trigger, but it seems important for day-to-day function, and I'm not confident I'd be able to manually restore it once I've finished transforming over 1,000 records from landline to mobile values. What's the right way to do this?

Addendum ...

The SQL statement triggering the error:

UPDATEcivicrm_phone
SETlocation_type_id="3"
WHEREphoneIS NOT NULL;


texts:
I received the following message at the top of my Manage ACLs page:

Notice: Undefined index: 5 in CRM_ACL_Page_ACL->browse() (line 222 of /home/ourbase/www/www/sites/all/modules/civicrm/CRM/ACL/Page/ACL.php)


texts:
Created and where is the Last Change data held?

Can I get information about the table location in SQL.

System:

Joomla! 3.9.10
CiviCRM 5.18.2


texts: There are code snips and what not at the top of our donation pages....and people cannot donate.  Help!


texts: Avoiding automatic creation of civi contact upon drupal account creation

texts:
How can I avoid contact creation when a drupal account is created?

My problem is:

Sometimes the contact already exists as an organization. If I add a drupal account, that contact gets duplicated as an individual.


texts: Is it posisble to stop contributions of zero?

texts:
Back office staff occasionally and accidentally enter an amount of zero for a donation, which Civi accepts as valid. Is it possible to reject this as an error? Price sets can do this but don't actually prevent the user from not selecting the price set & then entering zero.
Using Civi 5.19.4 & Drupal 7.69


texts: What sort of fix is needed to make Drupal Search work correctly on a civicrm page such as an Event or Contribution page

texts:
Just spotted that if you have a Drupal search block on eg a Contribution page, and try to use it, it will either take you back in to CiviCRM with a qf key (back to the last thing i modified i think), and for logged out (non permissioned) users they get a long message ending with "Error type: Could not find a valid session key".
How does a Drupal search trigger this outcome?


texts:
we are moving from an access database to civcrm shortly.  I have decided to load it on a subdomain.  our public website is joomla based, so it probably makes most sense to stick with that. so loading joomla and having civicrm installed as the only component on the subdomain installation.
That being said,  should the sub domain files be loaded in the public_html folder or just in the home folder?
We want to keep the civcrm info private and i will be likely using the api to get data to the public site or performing some scheduled export from civicrm import into data table for extentions procedure we already have in place for showing events etc.
Does it matter?  I dont think it should but first timer here!  lol


texts: Passing CiviCRM invoice number to Moneris hosted payment page

texts:
We use this extension to hook CiviCRM up to Moneris' hosted payment page to process payments: https://github.com/webaccess/com.webaccessglobal.moneriseselect

Could someone help point me in the right direction as to how to pass along the Invoice # to Moneris so that reconciliation between Moneris transactions and CiviCRM contributions can be more straight forward?

Or share some tips on best practices for this kind of reconciliation?


texts: white screen when trying to install civicrm on drupal, which is installed on a subdirectory

texts:
I have a Drupal site installed in a subdirectory, and would like to install the Civi module in it. I have uploaded all the civi files, alas, when I try to install
Civi here:  www.mysite/drupal/civi/sites/all/modules/civicrm/install/index.php I get a white screen. No error. Have done a lot of search on it to no avail. Thank you!


texts: Copy old WAMP directory to new installation of WAMP

texts:
Can anyone assist with the following scenario please...

-I had a local install of Wordpress and CiviCRM using WAMP.

-PC died but I was able to retrieve the Hard Drive and install in another PC as a secondary drive, and all of the files are still there.

-I have reinstalled WAMP on the new PC (C:) and now want to know if I can point the new WAMP installation to the old directory (F:) that contains my wordpress and civicrm data, or somehow copy the data into the new installation - in fact this is the preferred option.

Is this possible to do?

Thanks, Joe.


texts: CiviCRM Events (WP) - error message "this contact has already been assigned to this event"

texts:
Getting the error message "civicrm error message Please correct the following errors in the form fields below: This contact has already been assigned to this event."

Oddly, this record is my own. I'm wondering if it's BECAUSE I created the event that I can't add myself. I am the Civi admin.

My name doesn't come up in any registered attendee report and when searching my own record, I am not recorded as being registered to the event. But I can't add myself, either. See below.

Here's what it looks like when I try to add:

So, I'm stumped! It's not life or death, but insights are appreciated in the event it crops up with other contacts as this event progresses. If it crops up with another contact, that could affect the event headcount.

Thanks,

L.


texts: Membership form that also allows for just a donation to be made

texts:
The membership form https://www.colongwilderness.org.au/join-donate-membership has the option to select a membership or 'none' and make a donation.

If just a donation is chosen then the form submits and says that the payment was successful but no payment is recorded either with the gateway or with CiviCRM.

This is what the form looks like

If you choose

Membership - none -
Additional Donation $5

The submitted form says that the payment has been submitted to eway, but there is no record with eway or record of the contribution.

The Contribution p9age does not have 'membership required'.

The price set doesn't have anything as required. If the value to be submitted is $0 then the credit card form is not displayed correctly.

This is what the price set looks like

CiviCRM 4.7.22.


texts: apiv4 no longer sees custom fields that allow for multiple entry

texts:
I just noticed an error on a site I maintain.
Some custom code uses apiv4 to return a value from a set of custom fields (on individual contacts) and that function now throws an error:
API_Exception: Invalid field 'Employment_History.relationshipID' in Civi\Api4\Query\Api4SelectQuery->getField() (line 474 of /var/www/html/sitename/sites/all/modules/contrib/civicrm/Civi/Api4/Query/Api4SelectQuery.php).

Doing some tests, it seems that sometime between 5.15.1 and 5.27.4 (issue still exists in current version, 5.28.2) apiv4 stopped being able to return custom fields that can have multiple values.
I tested this by creating two sets of fields that are identical other than one being set to allow multiple entries. Only one shows up in the apiv4 explorer.
I'm going to update the working site to isolate the version where the problem started.
apiv4 explorer 5.15.1
apiv4 explorer 5.27.42


texts: How to change the Email that get notified when a new case is opened

texts: I am new to Civi CRM, been reading the docs and can't for the life of me find where to set what email gets notified when we open up a new case.


texts: "Could not find valid value for id" when processing contribution batch

texts:
When pushing the button "Validate & process batch" after entering contributions, the screen seems to refresh... but nothing is processed: no contribution is added, no confirmation email is sent.

Drupal watchlog shows this backtrace:

$backTrace =
#0 .../sites/all/modules/civicrm/CRM/Core/Error.php(378): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 .../sites/all/modules/civicrm/CRM/Utils/Request.php(120): CRM_Core_Error::fatal("Could not find valid value for id")
#2 .../sites/all/modules/civicrm/CRM/Batch/Form/Entry.php(89): CRM_Utils_Request::retrieve("id", "Positive", Object(CRM_Batch_Form_Entry), TRUE)
#3 .../sites/all/modules/civicrm/CRM/Core/Form.php(543): CRM_Batch_Form_Entry->preProcess()
#4 .../sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(92): CRM_Core_Form->buildForm()
#5 .../sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Batch_Form_Entry), "display")
#6 .../sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Batch_Form_Entry), "display")
#7 .../sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("display")
#8 .../sites/all/modules/civicrm/CRM/Utils/Wrapper.php(113): CRM_Core_Controller->run()
#9 .../sites/all/modules/civicrm/CRM/Core/Invoke.php(282): CRM_Utils_Wrapper->run("CRM_Batch_Form_Entry", NULL, (Array:0))
#10 .../sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:12))
#11 .../sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#12 .../sites/all/modules/civicrm/drupal/civicrm.module(448): CRM_Core_Invoke::invoke((Array:3))
#13 .../includes/menu.inc(527): civicrm_invoke("batch", "entry")
#14 .../index.php(21): menu_execute_active_handler()
#15 {main}

Where to find (or add) this id value? Or is it another issue?

CiviCRM 4.7.29 Drupal 7.56


texts: Why does the Contribution page amounts appear as a quanity?

texts: The way Contribution Information Page displays The Giving amounts when a contributor can donate any amount is confusing.  Please see the attachments for clarity.


texts:
I have a query in which I need to chain api.Contact.getsingle twice, given that the entity I'm querying is linked to two different contacts for which I need to fetch the data.

The problem is that, given that both chained calls have the same name, it seems that the last one overrides the first.

Basically I need to do this:

$result = civicrm_api3('MyEntity', 'get', array(
  'sequential' => 1,
  'api.Contact.getsingle' => array('id' => "\$value.contact_id"),
  'api.Contact.getsingle' => array('id' => "\$value.manager_id"),
));

but with the ability to "alias" each chained call so that they don't get overridden

Is it possible to do it? If not, what a different approach would look like?

Thanks!


texts: How can I fix an incorrect SQL field in Recurring Contribution View?

texts:
I'm trying to create a view that will tell our logged-in Drupal users when their next scheduled contribution is slated to happen.  Everything is working well until I add the field "CiviCRM Recurring Contributions: Next Contribution Date".  When that happens, my preview gives the error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column
'civicrm_contribution_recur.next_sched_contribution' in 'field list'

The Views SQL query shows this field being called:
civicrm_contribution_recur.next_sched_contribution AS civicrm_contribution_recur_next_sched_contribution

That is the correct table, but the field name is incorrect.  It should be next_sched_contribution_date.  I've tried searching in the CiviCRM Entity Github repo, but I can't find where the (incorrect) field name is being generated.  Where would I look to find the error?  Or am I looking in the wrong place entirely and it's not a CiviCRM Entity issue at all?  I want to help, I just don't know where to correct it.
We're using Drupal 7, CiviCRM 4.6.21, CiviCRM Entity module 7.x-2.0-beta3.  The type of view is "CiviCRM Recurring Contribution profile."


texts: Update core from 5.33.2 to 5.35.1 generates errors when re-enable modules

texts:
Re-enabling non-core modules after update spawned hundreds of this error:
WD civicrm: hook_civicrm_alter_drupal_entity_labels should be updated to  [warning]
pass an array of parameter names to CRM_Utils_Hook::invoke().
Array
(
[civi.tag] => deprecated
)
For these modules:
civicrm_contact_match was enabled successfully.                           [ok]
civicrm_contact_match defines the following permissions: modify uf match
civicrm_cron was enabled successfully.                                    [ok]
esoCiviMail was enabled successfully.                                     [ok]
webform_civicrm was enabled successfully.                                 [ok]
civicrmtheme was enabled successfully.                                    [ok]
civicrm_contact_ref was enabled successfully.                             [ok]
civicrm_entity was enabled successfully.                                  [ok]
civicrm_entity defines the following permissions: civicrm_entity.rules.administer, administer CiviCRM Entity


texts:
When configuring a Mail Report to be sent via Scheduled Jobs, using 'mail_report' API call, I need to pass the 'instanceId' and 'format' parameters.

For the 'format' parameter I have the options 'csv' (to output the report as a CSV file), 'print' (to output the report as printer-friendly HTML) or if I ignore the parameter, I have a PDF report.

Also, I can input a sendmail=0, that tells the job NOT to email the report, so I can use this in combination with print or csv format to only write report to stdout.

If I use the 'format=print', the job always write to stdout. My problem is that stdout, in this case, is the server's cron, what makes cron send an email to the administrator with the report, what I don't want to happen. Is is possible to tell the job NOT to write the report to stdout?


texts: Reports will no longer generate pdfs:Shows HTTP 500 error

texts:
Recently we have been getting an error when attempting to generate pdfs. The only change of note has been that our server just upgraded to FreeBSD 10. When the process is run I get a HTTP 500 error. I have looked at the error logs and am unsure that it is showing the error. Listed below is the error that is repeated in the log. This is a Civi (4.7.29) install via wordpress (4.9.4). Any help is appreciated.

#1 /wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(833): CRM_Core_Error::fatal("We can't load the requested web page. This page requires cookies to be enable...")
#2 /wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(828): CRM_Core_Controller->invalidKeyCommon()
#3 /wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(312): CRM_Core_Controller->invalidKey()
#4 /wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(204): CRM_Core_Controller->key("CRM_Report_Form_Contact_Summary", TRUE, FALSE)
#5 /wp-content/plugins/civicrm/civicrm/CRM/Core/Controller/Simple.php(66): CRM_Core_Controller->__construct(NULL, TRUE, NULL, "CRM_Report_Form_Contact_Summary", FALSE, FALSE)
#6 /wp-content/plugins/civicrm/civicrm/CRM/Utils/Wrapper.php(84): CRM_Core_Controller_Simple->__construct("CRM_Report_Form_Contact_Summary", NULL, NULL, FALSE, FALSE, FALSE, FALSE)
#7 /wp-content/plugins/civicrm/civicrm/CRM/Report/Page/Instance.php(89): CRM_Utils_Wrapper->run("CRM_Report_Form_Contact_Summary", NULL, NULL)
#8 /wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(309): CRM_Report_Page_Instance->run((Array:4), NULL)
#9 /wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:14))
#10 /wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#11 /wp-content/plugins/civicrm/civicrm.php(1216): CRM_Core_Invoke::invoke((Array:4))
#12 [internal function](): CiviCRM_For_WordPress->invoke("")
#13 /wp-includes/class-wp-hook.php(286): call_user_func_array((Array:2), (Array:1))
#14 /wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters("", (Array:1))
#15 /wp-includes/plugin.php(453): WP_Hook->do_action((Array:1))
#16 /wp-admin/admin.php(224): do_action("toplevel_page_CiviCRM")
#17 {main}

[message] => We can't load the requested web page. This page requires cookies to be enabled in your browser settings. Please check this setting and enable cookies (if they are not enabled). Then try again. If this error persists, contact the site administrator for assistance.&lt;br /&gt;&lt;br /&gt;Site Administrators: This error may indicate that users are accessing this page using a domain or URL other than the configured Base URL. EXAMPLE: Base URL is http://example.org, but some users are accessing the page via http://www.example.org or a domain alias like http://myotherexample.org.&lt;br /&gt;&lt;br /&gt;Error type: Could not find a valid session key.
[code] =>


texts:
I'm trying to move from 4.4.19 -> 4.6 (Old LTS to new LTS).  Having trouble and not sure where to look next.  Any suggestions would be appreciated.

When I go to the update page /civicrm/upgrade?reset=1 the page loads fine, but then when I hit the button to upgrade, I get a javascript error: Javascript error "Uncaught SyntaxError: Unexpected token runner:1" .

I experimented with trying to make smaller upgrades, and I can successfully upgrade from 4.4.19 -> 4.4.20, but 4.4.20 -> 4.5.0 gives that same javascript error. (I also tried 4.5.1 with same result.)

There is nothing in the drupal log.

There are no new entries in /civicrm/ConfigAndLog

Things I've tried based on what I've read here and elsewhere:
-Upgraded to most recent version of chrome
-Deleted contents of civicrm_extensions directory
-Disabled all civicrm drupal modules (except CiviCRM Contact Reference Field which wont allow me to disable it because it's in use for a field)
-Deleted contents of custom php and custom templates directories
-Turned on debugging


texts:
I'm trying to work out how this is done,  it seems the standard templates have this coded in

{$l}if $sections.{$column}.type & 4{$r}
                    {$l}assign var=printValue value=$row.{$column}|crmDate{$r}
                {$l}elseif $sections.{$column}.type eq 1024{$r}
                    {$l}assign var=printValue value=$row.{$column}|crmMoney{$r}
                {$l}else{$r}
                    {$l}assign var=printValue value=$row.{$column}{$r}
                {$l}/if{$r}
                {$l}if $rowid neq 0{$r}
                  {if $section.pageBreak}
                    {$l}if $pageBroke >= {$h} or $pageBroke == 0{$r}

And I know the extended reports extension implements this.

I have been looking at the code, but it is very generic, in that it allows selecting sort fields & selecting section / page breaks.   But I can't yet fathom out what I need for my simple use case ( I don't need user selectable option - just want to break on a sort field )

I'm hoping it is something straight forward  $this->_sections but I am floundering around a bit.

$this->assign('sections', $this->_sections);

Any help or pointers to example much appreciated.

--- edit  ---  this is where I have got to

function orderBy() {  $this->_orderBy = "ORDER BY mycolumn";

                  $sections = array ( 'my_section' => array (
                  'title' => 'My Name',
                  'type' => 2,
                  'tplField' => 'mytable_mycolumn',
                  'section' => 1,
                  'pageBreak' => 1,
                  ));

                  $this->assign('sections', $sections);

                 }

Whilst it is promising, in that it puts out the at least the text of the first section and it doesn't fail or shout warnings, it just doesn't present any values?

I have tried combinations of mytable_myfield / myfield in tplField and columns.

I have compared smarty debug variables between working versions and mine, and I haven't got it yet.


texts: VBO (Views Bulk Operations) with civicrm based Views for d8 and d9

texts: Just wondering if anyone has any evidence of this working with d8/d9


texts:
In the information transmitted to Paypal for payments, Civi adds a prefix to the "Item Title".
E.g. Donations through the "Donations" contribution page have a Paypal Item Title such as this: 603-607-Donations.
Is there any way to stop the prefix from being included? It's interfering with our use of the PayPal reports and sorting donations according to the source (contribution page).


texts: Contributions for Membership completed, but Membership remains as Pending

texts:
A client has found that a number of memberships are still set to Pending even though the Payment is complete. Payments were made online. Membership is not in Override.

Client does have a multisite but this has been in place for a long time, and these issues are sporadic.

Here are some entries from db

https://gist.github.com/petednz/7151675e9b1d7715a163


texts: Chain API call cascade, pass second value as third call argument, "id is not a valid integer"

texts:
While making a cascade API call, a roadblock has been hit, here's a code:

$result = civicrm_api3('Contact', 'get', array(
  'sequential' => 1,
  'return' => "id",
  'id' => array('IN' => array(168, 169)),

 // Second call

    'api.Relationship.get' => array(
      'return' => "contact_id_a",
      'contact_id_b' => "\$value.id",
      'relationship_type_id' => 4,
      'is_permission_b_a' => "1"),

          // Third call

        'api.Contact.get' => array('id' => array(
           'IN' => array("\$value.api.relationship.get"))), // <-- here
));

It returns

{
    "error_field": "id",
    "type": "integer",
    "error_code": 2001,
    "entity": "Contact",
    "action": "get",
    "is_error": 1,
    "error_message": "Error in call to Contact_get : id is not a valid integer"
}

What exactly returns third call and how these results should be properly "plugged in" to get correct output? Thanks anyone for any bit of advice!


texts: Wordpress Media Library not refreshing with new upload

texts:
when we upload a file to the Media Library at
https://OurSite.org/wp-admin/upload.php the file doesn't show up onscreen immediately. It looks like nothing has happened. But when we refresh the browser, the file appears.

We thought perhaps this was a SiteGround caching issue, so added wp-admin/ to the exclusion list and used the Supercacher testing tool to confirm that
https://OurSite.org/wp-admin/upload.php was now excluded.

We also purged the SiteGround cache, but still the Media Library does not dynamically refresh when uploading a file. Wordpress version is 4.7.2 and CiviCRM version is 4.7.13

We have the same Wordpress version installed on a different host and it is working properly. We confirmed that it is caused by CiviCRM when we disabled the CiviCRM wordpress plugin. We looked for possible collisions of libraries, but it is not evident why CiviCRM is affecting any of the output on that page.  We're looking for insights from someone with additional Wordpress expertise.


texts: Unsubscribe link in publicly viewed newsletter error

texts:
I was thinking (first problem) to use the "view in browser" url to build a link page for viewing past newsletters. If a user clicks on the unsubscribe link, the url "mysite.com/civicrm/mailing/unsubscribe?reset=1&jid=&qid=&h=fakehash" creates an error page:

Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
Missing Parameters

Looking for a cleaner redirect...


texts: Drupal Views needs settings file update for 5.24

texts: I upgraded a client to 5.24 and it broke Drupal Views - my various views all had broken items.  Views message was "This view has been automatically updated to fix missing relationships". However, while saving one view worked, another didn't. Not sure if the right place to alert people to this, but here goes.  Previously the client was on 5.19.4 so your situation may vary.  My answer is below


texts: How to use Event Calendar Extension with CiviEvents?

texts:
Does anyone use the Event Calendar extension? I am using Civi 4.7.29 on Wordpress 4.9.4

Today i installed the Event Calendar extension and WP FullCalendar for the first time.  It shows that the install was successful and enabled.  However the instructions for this extension say "A "Show Events Calendar" link appears under Events. The settings link is the same as the Show Events Calendar link but with "eventcalendarsettings" instead of "showevents"."

I am looking and I do not see these links anywhere in my menus or manage Events page.  Does anyone know where it is?  I am not seeing how to get my events to display on Fullcalendar.


texts: Failed to import contacts into groups (with csv import)

texts:
I have contacts belonging to different groups.

I made a first csv import successfully : I have all data of contacts and they are all in the same big group.

But then I tried to import them group by group with just their email address and the update option. The import seems to be successful. It mentions "    Stratégie internet: One contact added to this existing group."

But when I go to group panel, the group has no new contact.

I tried many thing (import more than email for this 2nd import, change group visibility, use a new group, etc.) but it is still the same.


texts: How to use civivolunteer description text

texts: On the civivolunteer role options page you can edit the roles and fill out a description field.  That is great but how do I use the description field on event pages where civivolunteer is enabled?  I just get a drop down box listing the label.  And obviously we can add description text to the event page, but that seems wrong.  Where is the role description displayed?


texts: Can I see/export the total field mapping in use?

texts: I inherited responsibility for this small non-profit's database. I would like to be able to view and print a list of ALL the fields in use.


texts:
I'm developing my first extension (through civix) which contains a custom form and a specific menu item linking to the form.
All was working until today, but suddenly, the page URL is no more reachable, the URL is sometime redirected to the home page, sometime a path warning error is displayed.
I tried to uninstall and reinstall the extension, but unsuccessfully.
What can i do?

Thanks
Marcello


texts: Beta 29-beta1 - Anyone see a problem where creating an event, after the first page settings it hangs on trying to get to any other tab?

texts: Subject says it all.  Has anyone ever seen this on the Beta (or any other version)?


texts: System Status: Error after upgrade to 5.10.0

texts: I upgraded from 4.4 to 5.10.0 (WordPress). Upgrade seemed to go fine. Now when I go to the home page for CiviCRM, I get a blank page with System Status: Error in the footer (in pink). There are no other error messages and I have no idea what the error is. Any ideas on how to troubleshoot?


texts: Calculate a better price for Webform CiviCRM Payment Installments (Annual)

texts:
If I set up Webform CiviCRM to sell an annual membership

4 installments
1 payment a year
Four years

It seems to work just fine as far as charging them for the first installment and then tracking the rest on the CiviCRM end.

However, the user sees this on the payment page of the webform:

Is there any way to either remove this completely and use Webform to just list their current charge, or a way to parse this into something that will let them know what they are actually paying right now? I don't think putting the number of installments next to the membership name is going to cut it.

CiviCRM 4.7

Is using something like https://www.drupal.org/project/webform_calculation_components viable for this?


texts: CiviContribute Pages have differing wrong titles in

texts:
We are having a strange issue where different titles for our CiviContribute pages show up in the <head> <title> section, so the title shows up wrong in the tab, bookmark, etc. Sometimes it will be the name of one of our CiviContribute pages, and sometimes another. Today, they all say "Donate" for example, which is what one of our CiviContribute pages should be called. But other users will report that the title is "Subscribe" on all the pages, which is the example name of another of our CiviContribute pages.

We are using a really old version and are currently working on updating it now but I wanted to make sure there wasn't a simple explanation before putting it on hold for the upgrade.

Any ideas?

Drupal 7.50, CiviCRM 4.3.8.


texts: WordPress: Creating new WP Users from Civi Contacts

texts:
I've seen some example posts here for other CMS', but I haven't seen it explained for a WordPress environment. My situation is I have an Individual DB of 2,500 Contacts in Civi, and I want to turn them all into WP Users. I know I can convert Users into Contacts, but I want to do it the other way around.

Only thing I can think of is I would have to export the Contacts database as a CSV and then import them as Users either with a plugin or PHPmyAdmin. Isn't there some other way?


texts:
I have been searching if anyone has described how to achieve something similar to what we would like to do: We currently use a manual sign in sheet for our members (use of this sheet is sadly not consistent).
We are hoping to find a way to have our members scan a QR code themselves as they come through the door and to do the same on the way out while creating a record.

Ideally, it would also run a test to see if a specific membership is currently up to date and send a payment request to them if not(however this is not vital). Does anyone know of a group that has done something similar or can point us in the right direction?

thank you for your help,
best regards,
JD


texts: How and when should I create custom data fields?

texts: I need at least 50 different "categories" or "custom fields". Everything from Contact Info like Name, Address, etc. to specific information that I would have to uniquely name. I am getting extremely confused on how to do any of it. Is there a tutorial on here, or something? I am really new at this.


texts: How to add the employer organisation including custom field to the event enrollment form

texts:
Currently I do a project for an organisation that organizes events for employees in a certain industry. When a person enrolls in an event they want to record a number of his employer like:

the address.
a category of the organisation.
a VAT number
etc..

I know how to this with Drupal forms, but unfortunately they do not use it. So I tried it with profiles in combination with the native event page. I can add fields of the participant, and the contact. What I cannot do is add organisation fields.

Does someone know (or created) and extension, that makes it possible to add an organisation profile to an event form. When the form is filled in the organisation is created and subsequently to the participant with employer relationship.


texts: CiviEvent - Past event participants -> bulk register to new event

texts:
Hi guys and thanks in advance.

I would like to find a way to do the following:

a. Advance Search
b. Find old event
c. Select participants
d. Action
e. "Add relationship - register to event"

In essence, I need to be able to use people that have registered (and may have come) to one of our previous events and register them to a new one.

Any way I can add that option under "Actions"? Or is there another way of going about doing this?

Thank you


texts: Rotate SMS providers to get around 200 messages per day limit?

texts:
According to this twilio page (https://twilio.radicalskills.com/projects/messaging-in-production/1.html#long-or-short-code) - if you send more than 200 SMS messages per day while using a "long code" you can have your account suspended or filtered.

Has anyone worked on an extension to rotate between multiple accounts to avoid hitting this 200 contact limit?


texts: Does CiviCRM work with Drupal 8 and how can I help?

texts: What is the status of CiviCRM working with Drupal 8? And how can I help in terms of testing or funding this development?


texts: CiviReport: Cannot remove Contact ID filter

texts:
Suddenly a filter on Contact ID is unexpectedly appeared on my "Constituent Detail" report.
Since Contact ID is not one of the fields enabled for filtering, I cannot remove it. So, every time I want to use the report, the filter is automatically set and I cannot use the report.

Any suggestion?

Thanks

Note: This issue has been reported at: https://issues.civicrm.org/jira/browse/CRM-17872


texts: How to programatically add an email to a newsletter?

texts:
I am migrating from MailChimp to CiviCRM with Sparkhost (seemingly a great option for installations on Bluehost or other hosts which don't support VERP.)

I have a few places where the MailChimp API is used to add contacts to our email list.  I am having trouble figuring out how to replace these with similar calls to CiviCRM, to trigger a double opt-in confirmation email.

I created a simple profile to collect email and a newsletter group signup field.  This works for situations where I can embed this form into a page.    But I can't duplicate this behavior for situations where I need to trigger the subscription programatically.

If I use the CiviCRM API to call 'Profile' 'submit', it seems to ignore the profile setting to "Update the matching contact" and just creates duplicate contacts with the same email address.  It also sets the status to 'Added (by API)' rather than sending an email confirmation.

If I use the API to call 'GroupContact' 'create', I can't get it to send a confirmation email.  With no status set, it just adds the contact.  With status of 'pending' set, it marks the contact as 'Pending (API)' without sending the confirmation email.

It looks like I could do something like:

Look up whether the email exists yet, with 'Email' 'get'.

If any results, check the contact associated with each result to make sure it's not deleted.

If more than 1 valid result, take a best guess at which contact to use.

If 0 valid results, create the contact and create the associated email record.

Call 'MailingEventSubscribe' 'create' to trigger the double opt-in process.

This is doable, but the initial steps seem to be reinventing the wheel.  Am I missing something to make this simpler?  Thanks!


texts: Change 'Used for' contact type of custom fields

texts: I have custom field group set as used for 'individual' but I want to change it to limit it to a contact subtype.  What is the best way to achieve this - I could create a new field group and copy data over - but there are several hundred contacts to do this for


texts:
I recently changed from Drupal to Wordpress, and am having some trouble connecting WP to my existing CiviCRM database.

I installed the CiviCRM for Wordpress plugin (and set up a new, empty database for CiviCRM). Then I edited the civicrm.settings.php file to connect to my old CiviCRM database (that I had been using with Drupal). I know the settings are correct, and yet something is wrong. The CiviCRM menu does not appear; the Dashboard appears ugly as if there is no CSS; I cannot access some admin pages (like "Resource URLS") but I can access others (like the Admin Console, by manually typing in the URL, yet as with the Dashboard there is no CSS being applied).

Can someone shed some light on what is happening, and how I can fix it?


texts:
I am upgrading from CiviCRM ver 4.7.3 on WordPress 4.4.2. I am very new to CiviCRM. What are the exact instructions to upgrade with these versions? Have looked at this: https://wiki.civicrm.org/confluence/display/CRMDOC/Installing+CiviCRM+for+WordPress but it seems to be extremely complicated for a minor version upgrade?

I am hoping that the newer version will make my site faster and more responsive. It's crawling right now after having installed 4.7.3.


texts: Revoke permission to add contacts to groups

texts:
My client has a strange and complex group of relationships that I'm trying to properly permission. We are granting permission to a group of 3rd party managers to admin protected groups of contacts. All of that is working correctly.

However, I see that these 3rd party managers have the ability to add users existing groups. They do not have permission to do anything else with groups. I want to find a way to lock them out of the this ability. I don't want anyone being accidentally added to a mailing or permissions group, for example.

I do want these managers to have permission to edit their client's profiles. We want leverage the manager's ability to provide us with correct contact information on profiles, and to do event registrations.


texts:
I've encountered a problem (only recently) with buildkit, where when it comes time for me to run:

~/buildkit/bin/civibuild install "civi46" --url "http://civi46" --admin-pass "password" --web-root "/var/www/civi46"

I get

++ CMS_DB_HOSTPORT=127.0.0.1:3306
++ pushd /var/www/civi46
++ '[' -f sites/default/settings.php ']'
++ rm -f sites/default/settings.php
rm: cannot remove `sites/default/settings.php': Permission denied

But when I run

sudo ~/buildkit/bin/civibuild install "civi46" --url "http://civi46" --admin-pass "password" --web-root "/var/www/civi46"

I get

+ bower install -f
bower ESUDO         Cannot be run with sudo
Additional error details:
Since bower is a user command, there is no need to execute it with superuser permissions.
If you're having permission errors when using bower without sudo, please spend a few minutes learning more about how your system should work and make any necessary repairs.
http://www.joyent.com/blog/installing-node-and-npm
https://gist.github.com/isaacs/579814
You can however run a command with sudo using --allow-root option

This takes place even if I (shudder) set settings.php to have 777.

Even if I try to install civi manually after that, it is missing the files lang.php and civicrm-version.php.

With these copied from elsewhere, and the correct install details, clicking install results in "cannot lock table civicrm_acl - doesn't exist". Of course it doesn't exist. I need you to create it, silly install.php!


texts: How can I find contacts with only 1 contribution during last 12 months?

texts:
How can I build a search for contacts that match two criteria?

1) The contact has contributed in the last 30 days;

AND

2) The contact has not contributed another donation within the last 12 months.

In other words, I'd like to select people who have donated for the first time during last 12 months.


texts: Problems with first test site using Civicrm buildkit

texts:
hope there is someone who can help? It's taken me a couple of days, but I've finally got the buildkit successfully installed, however when I try to create my first instance I'm getting permissions errors, is this because I've installed it in the wrong place? I've checked the Apache version and the restart command.

This is a fresh install on gc ubuntu16.04 with up to date dependencies

Errors:

seankenny@instance-2:~$ ./buildkit/bin/amp test
Create test application
Create data directory: /home/seankenny/.amp/canary/data/F2Dn7Skcr6zJM61SvzEB72IjOuoUMHwi
AMP_URL='http://localhost:7979'
AMP_ROOT='/home/seankenny/.amp/canary'
AMP_DB_DSN='mysql://canary_wfa83:n29ZlTuwvd9UxLuI@127.0.0.1:3306/canary_wfa83?new_link=true'
AMP_DB_USER='canary_wfa83'
AMP_DB_PASS='n29ZlTuwvd9UxLuI'
AMP_DB_HOST='127.0.0.1'
AMP_DB_PORT='3306'
AMP_DB_NAME='canary_wfa83'
AMP_DB_ARGS='--defaults-file='\''/home/seankenny/.amp/my.cnf.d/my.cnf-e7cb970bf21e2d4b82d944711b5fc15b'\'' canary_wfa83'
Connect to test application
Expect response: "response-code-wgnXWegrsL"
PHP Warning:  file_get_contents(http://localhost:7979/index.php): failed to open stream: Connection refused in phar:///home/seankenny/buildkit/bin/amp/src/Amp/Command/TestCommand.php on line 163
Warning: file_get_contents(http://localhost:7979/index.php): failed to open stream: Connection refused in phar:///home/seankenny/buildkit/bin/amp/src/Amp/Command/TestCommand.php on line 163
Received incorrect response: ""
Tips for common issues:
 - (Re)run "amp config"
 - Double-check the httpd_type (apache24) along with any displayed instructions.
 - Double-check the httpd_restart_command.
 - (Re)run "amp test"


texts: How can I get webforms to show household and household members?

texts:
I tried to follow the instructions here http://wiki.civicrm.org/confluence/display/CRMDOC/Webform+CiviCRM+Integration but I must be doing something wrong.

I created a webform that has household as contact 1 and individual as contact 2.  In contact 2, I enabled relationship fields and selected is part of.

In the webform, if I select an existing household, it pulls up the info on the hh but does not populate the individual info.

If I create a new household and a new individual, it creates the household and the individual and a relationship but the relationship doesn't have a type, which isn't possible through the standard interface.

This is on civicrm 4.6.7