texts: 'Create Linked Drupal User Account' problem - bug or user error?

texts:
I am trying to set up a rule to create a Drupal User when a Contact is created.  The obvious approach is to fire on the event 'CiviCRM Contact has been created, check for the correct Contact subtype, and that a User does not already exist, and then use the action 'Create Linked Drupal User Account'.

This does not work on creating a Contact, giving an error message: Cannot create user, email: invalid!!

The Rules debug information in this case is:

0 ms Reacting on event CiviCRM Contact has been created.
2.397 ms Evaluating conditions of rule Test Rule. [edit]
2.473 ms The condition civicrm_entity_contact_is_subtype evaluated to TRUE [edit]
6.878 ms The condition civicrm_entity_user_exists evaluated to FALSE [edit]
6.88 ms AND evaluated to TRUE.
  Rule Test Rule fires [edit]
    0 ms Rule Test Rule fires.
    0.041 ms Evaluating the action civicrm_entity_action_create_user. [edit]
    232.936 ms Rule Test Rule has fired.
239.83 ms Finished reacting on event CiviCRM Contact has been created.

The only messages in the Drupal log are copies of the error message and the Rules debug log.

BUT if one then updates the same Contact, using the same webform and the same Rule with the Contact Updated event added, it works and the User is created.  (This says a timing or sequencing problem to me, or a difference I haven't spotted in the syntax required in the two cases.)

What is going on?

The Rule export is:

{ "rules_test_rule" : {
    "LABEL" : "Test Rule",
    "PLUGIN" : "reaction rule",
    "OWNER" : "rules",
    "REQUIRES" : [ "civicrm_entity", "civicrm" ],
    "ON" : { "civicrm_contact_create" : [], "civicrm_contact_edit" : [] },
    "IF" : [
      { "civicrm_entity_contact_is_subtype" : {          "civicrm_contact" : [ "civicrm_contact" ],
          "contact_subtype" : "xxxx_Member"
        }
      },
      { "NOT civicrm_entity_user_exists" : { "civicrm_contact" : [ "civicrm_contact" ] } }
    ],
    "DO" : [
      { "civicrm_entity_action_create_user" : {
          "USING" : {
            "civicrm_contact" : [ "civicrm-contact" ],
            "is_active" : "1",
            "notify" : "0",
            "signin" : "1",
            "username_format" : "firstlast"
          },
          "PROVIDE" : { "civicrm_user" : { "username" : "Created Drupal User" } }
        }
      }
    ]
  }
}

Configuration includes:
CiviCRM  5.3.2   (including CiviCRM Rules Integration);
Drupal 7.59;
CiviCRM Entity  7.x-2.1;
Rules  7.x-2.11;
and dependencies.

(I have looked at the answers to various related questions and cannot get any joy.  Those that are using the same approach don't seem be any help in getting mine working.  Some suggest setting a Tag and then firing a rule off the Tag creation event - the CiviCRM Tag entity does not show up in the event selection list on my system, so I can't use that.

I have done something similar to the Tag suggestion using the Relationship created event, which does work (as far as I have tested it so far) but it's clearly a kludge (apologies) workaround.  Should not the straightforward approach work?)

Thanks in advance,
Tony


texts: I figured out how to add form fields using the buildForm hook.  I am adding a select element to a participant profile on an event registration form.  Do the values from the added fields get saved when the user submits the form?  If so, where can I see them?  If not, how do I store them with the other profile info using code?  The custom fields feature does not work (DB Error: Already exists)  right now or else I would use that.


texts: Unable to get Contact ID to display in Custom Field

texts:
Been stuck on this for the past few days I want to set a default value for a custom field in a contribution. The Custom fields are associated by Financial Types,  I intend to show the current contact id of the person the contribution is being submitted for in a custom field. I tried doing this originally within the CustomDatabyType.php file.

class CRM_Custom_Form_CustomDataByType extends CRM_Core_Form {

  public function setDefaultValues() {
    $contact_id = CRM_Core_Form::getContactID();
    $defaults = [];
    $defaults['custom_224_-1'] = $contact_id;
    CRM_Core_BAO_CustomGroup::setDefaults($this->_groupTree, $defaults, FALSE, FALSE, $this->get('action'));
    return $defaults;
  }
}

To Clarify the reason i want the contact ID for the user i am submitting the form for is because i want to display that contacts 'Employer' in a custom field. I have tried the following:

CRM_Utils_Request::retrieve('cid', 'Positive');
$form->getContactID();
$form->_contactID;

The issue i am having is that is the above lines of code work if i associate it to a field within the contribution form but if i associate it to a custom field it will show the contactID of the user submitting the form not the user of whom the form is being submitting for.

I have also tried to do this via a custom buildForm hook:

function dfi_civicrm_buildForm($formName, &$form) {

    if ($formName == 'CRM_Contribute_Form_Contribution' || $form == CRM_Core_Action::ADD) {
        $thisContactID = $form->_contactID;
        $defaults['custom_224_-1'] = $thisContactID;
       $form->setDefaults($defaults);
    }
}

I hope i have been clear and i would really appreciate your help.

Thanks

An Idea i have had is to set the ContactID within a field in the 'Contribution section' use getVar to get the value of the field and then assign that value to the custom field.

Is this possible?


texts: Warning: htmlspecialchars() expects parameter 1 to be string, array given in .../civicrm/packages/HTML/Common.php on line 144

texts:
Has anyone else seen the above error under Joomla and CiviCRM 5.11.0 when running the Event Report: Attendee List?  I've done a bit of troubleshooting and it appears it seems when a custom form value is empty and is then in the form of an empty array rather than an empty string.  A workaround is to test for the variable type and, if it is an empty array, replace it with an empty string.  There seems no longer to be a Joomla demo site, so can't replicate it.

I plan to raise this as an issue, too.


texts: modify API request using searchmodule_civicrm_apiWrappers

texts:
I'm trying to change the CiviCRM API getquick search to support legal name, but without a core override. (To remove the need for hacks).

I have the following code:

            function searchmodule_civicrm_apiWrappers(&$wrappers, $apiRequest) {
              if ($apiRequest['entity'] == 'Contact' && $apiRequest['action'] == 'getquick') {
                $wrappers[] = new CRM_Utils_API_LegalSearchAPIWrapper();
              }
            }

And the following class:

            <?php

            require_once 'api/Wrapper.php';

            /**
             * Class CRM_Utils_API_LegalSearchAPIWrapper
             */
            class CRM_Utils_API_LegalSearchAPIWrapper implements API_Wrapper {

                /**
                 * @var CRM_Utils_API_ReloadOption
                 */
                private static $_singleton = NULL;

                /**
                 * @return CRM_Utils_API_ReloadOption
                 */
                public static function singleton() {
                    if (self::$_singleton === NULL) {
                        self::$_singleton = new CRM_Utils_API_LegalSearchAPIWrapper();
                    }
                    return self::$_singleton;
                }

                /**
                 * @inheritDoc
                 */
                public function fromApiInput($apiRequest) {
                    return $apiRequest;
                }

                /**
                 * @inheritDoc
                 */
                public function toApiOutput($apiRequest, $result) {

                    $name = json_decode($apiRequest);
                    $name = $name['params']['name'];

                    $result = civicrm_api3('Contact', 'get', array(
                        'debug' => 1,
                        'sequential' => 1,
                        'return' => "sort_name",
                        'legal_name' => array('LIKE' => "%$name%"),
                    ));

                    return $result;

                }

            }

The class executes, so no issues there, but I'm unsure how to append the query with a legal name attribute. When I write a seperate query for the API to return sort_name, it generates a DB error in the API.


texts: Cannot separate CiviCRM database tables from Wordpress tables on installation

texts:
I just installed CiviCRM for the first time on a test Wordpress installation for checking out CiviCRM. I followed the instructions at https://wiki.civicrm.org/confluence/display/CRMDOC/Installing+CiviCRM+for+WordPress and used civicrm-4.7.10-wordpress.zip. For some reason, when running: http://{wordpress install directory}/wp-admin/options-general.php?page=civicrm-install, the database part of the form is populated with the Wordpress database. I created a clean, empty MySQL database and tried to enter it. When I pressed the Check Requirements button, it replaced the database name with my Wordpress database name. Everything works, but I really wanted to have the Wordpress tables and CiviCRM tables in separate databases for future site management. Is there a way, after the fact, to point to the database I want? I can easily export the CiviCRM tables and import them into the clean database.

Thanks for any help here and sorry if this is simple - this is my first day working with CiviCRM.


texts: CiviCRM 4.7 - Showing Empty home page in wordpress editor

texts:
I installed CiviCRM 4.7.31 in WordPress for one of my testing purpose. After i activating the CiviCRM plugin, CiviCRM is proving a blank interface. Can i why the menus are not appearing and how should i resolve it ?

My currect PHP version is 7.2.24 and Wordpress version 5.4.1

These are the output of the console

Some cookies are misusing the recommended “sameSite“ attribute 4
This page uses the non standard property “zoom”. Consider using calc() in the relevant property values, or using “transform” along with “transform-origin: 0 0”. admin.php
The script from “http://localhost/wordpress/wp-admin/admin.php?page=CiviCRM&q=civicrm/ajax/l10n-js/en_US&r=iLhO1” was loaded even though its MIME type (“text/html”) is not a valid JavaScript MIME type.

SyntaxError: expected expression, got '<'


texts:
I think I have found an issue with merging contacts (and it also seems to manifest when assigning a different client to a case - which apparently performs a similar merging function).

On the demo site (Drupal 7, CiviCRM 4.7 - provided by CiviHosting), I am able to reproduce the problem:

Create a custom  field set that has one field which is type File.
Apply the custom field set to individuals.
Create two individual contacts (you will be merging them later) and fill in the file field for one but not the other.
Try to merge the two contacts - the first contact should be the one with the file, the other should be empty (then click "add" to the file field).
You will get a "Sorry, this could not be provided at this time" error.

Similarly, on a non demo site (since the "Case" component cannot be enabled on the demo site currently), assigning the case to a new client (which performs a merge function) blows away the file reference if it has a custom field  of type file. The file is still on the server, and the case knows there should be a file, but it cannot be retrieved.

Should these be recorded in the CiviCRM issue tracker?

Thanks!


texts: Certain Themes break WYSIWYG in wordpress

texts:
It appears that the wysiwyg does not work well with ThemeForest themes.  It does not load in certain pages like the title page of contribution pages.   It works just fine when I use a default theme.

Suggestions on how to get this working and override the theme ?


texts: Is there a way to create a smart group that contains contacts that have made a contribution with a specific soft credit name?  I see that I can run a Soft Credit Report and add contacts to a group but I would like to make that group dynamic.  We're using Civi 4.7.17.  Thanks.


texts: Get civi mailing with status = 'Complete' using API explorer

texts:
What should be the way to get/find mailing with the status ='complete' using API explorer?

or is it the value which stores in civicrm_mailing.is_completed for each mailing?

or there is any other way to get such mailings?


texts: Can I include a message template within a message template

texts:
I know I can use {include } smarty function, can I also use that in message templates so we can have a generic template part that belongs to all other templates?

We want to use this for PDF templates


texts: How can I use webform to "assign to another client" for civicase

texts:
I am trying to provide a webform that can be used to assign a case (and lots of relationships) to another client. I don't seem to be able to get this to replicate the outcome of doing this via the civicase UI. Currently via webform it does create a new Case for the new client, but it does not create/record Activities such as "Case 69 reassigned client from xxx to yyy. New Case ID is 111." nor copy over Activities that were on the original Case.

I have tried by putting the original case id in the url.

Is there something I am missing that would make this work?


texts: Profile | more | Use - Listing - Mode not working

texts:
I have a profile that used to work to allow members to search our contact list.
Now when we use it even from the CiviCRM profile list it brings up a wordpress page
.../civicrm/?q=civicrm%2Fprofile&gid=14&reset=1 that only says
CiviCRM
Do not delete this page. Page content is generated by CiviCRM.
I get same if I try the create mode or the edit mode options under more, but the URL has
2Fcreate or 2Fedit rather than 2Fprofile.


texts: Why are donations left as "pending" in CiviCRM when they went through in Paypal?

texts: Sometimes when we get an online donation, the record remains in the "pending" state in CiviCRM even though the payment went through successfully in Paypal. This happens for maybe 1/3 - 1/2 of donations. Is there a solution for this, a way to make sure they are always marked "Completed"?


texts: What does the option "Always post to Accounts Receivable" in CiviContribute do?

texts:
In the settings page of the CiviContribute module, there is the option "Always post to Accounts Receivable?" which can be activated or de-activated.

I have searched through the documentation and googled for it, but I cannot find a clear description of this option. I would have expected it to create additional bookkeeping entries for contributions in order to always involve the 'accounts receivable' account, even if an immediate payment is performed. But so far, I have not been able to make it work. In my tests, I get always the same set of bookkeeping transactions, irrespective of this setting.

I am not sure if this is a problem with my installation, if the feature just does not work or if I need to configure something else in addition.

(I am using Civi 5.11.0 and Wordpress 5.1).


texts: Change Log Shows Incorrect "Changed By" Name

texts:
I'm on CiviCRM 5.16.2 on WordPress, and we have a situation where we have removed one of our organization's email addresses from one user account and added it to another account, but when the new user takes actions in CiviCRM it still shows the old user's name in various areas, one example being the "Changed By" name in the change log, but it also shows up incorrectly if the user enters a contribution, etc.

To explain in a bit more concrete way:

User Alice has email address foo@myorg.org
foo@myorg.org email address is removed from Alice's record in CiviCRM
foo@myorg.org email address is added to Bob's record in CiviCRM
User Bob changes a record in CiviCRM
Go to change log for the record, "Changed By" shows up as Alice, and even links to Alice's record if you click on the name in the change log

I don't see a way to fix this in the admin interface and I've confirmed that the email in question is absolutely not still in the old user's record, and if you do a search for the email address the only hit that comes up is the new user, so I'm a bit flummoxed why it'd be behaving this way. Any ideas would be greatly appreciated. Thanks!


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

texts:
I'm using CiviCRM 4.5.8 and am setting it up to handle a three year fundraising campaign for our church.

Our church almost exclusively records donations for Households and not for individuals.

How can I create a Contribution Page that allows a person to make Pledges and Contributions that will be linked to their Household?

I am not afraid of custom coding and am currently planning to write a script that automatically shifts all individual pledges to their related household, but if I do that, I still want the contribution page to work for that person to actually make contributions.

Ideally, I'd just use a template override to inject the contact_id of the user's household if there is one or to use the individual contact_id otherwise, but I need some help on how to do that.

I already am comfortable working with template overrides, but I'm asking if anyone knows which template needs to be overridden to get the contact_id in the correct place.

EDIT: SOLUTION CODE

/**
 * Implements hook_civicrm_post
 */
function householdcontributions_civicrm_post($op, $objectName, $objectId, &$objectRef) {
    // the _post hook is called AFTER the object has been written to the database
    // because of that, we need to change the contact_id to the household_contact_id
    // and save
    if($op == 'create' && $objectName == 'Contribution') {

        $current_contact_id = $objectRef->contact_id;
        $real_id = $current_contact_id;

        // look for a household associated with this contact
        $result = civicrm_api3('Relationship', 'get', array(
          'sequential' => 1,
          'relationship_type_id' => 7,
          'contact_id_a' => $current_contact_id
        ));

        // override the contact_id with the newly discovered household id
        if ($result['count'] == 1)
        {
            $household_id = $result['values'][0]['contact_id_b'];
            // $objectRef->contact_id = $household['values'][0]['contact_id_b'];
            $result = civicrm_api3('Contribution', 'create', array(
              'sequential' => 1,
              'id' => $objectId,
              'contact_id' => $household_id,
            ));
        }
    }
}


texts: How would you anonymise (or redact) private data for developer stage?

texts:
Private information is confidential. However for developers to debug errors they need a copy of your data that's close enough to production to effectively debug. How can we redact, strip or remove confidential data from CiviCRM?

Two options come to mind. I could spend time creating anonymous test data that covers  all the possible variants of our complex hierarchical contact relationship structure. The other option would be to go through a copy of production and anonymise it by overwriting private data with random strings. But we are talking here about some 9000 contacts. Working with API calls to anonymise could take hours, not really an option for a fast workflow.

Anyone with experience or ideas could share his thoughts on this subject?


texts:
How do I export my contacts as a .csv or .txt file?
I need this for my records and can not find where I can do this. Please help. Thankyou.


texts: How to get Target Contacts from Api4 Activity.get call?

texts:
I have an Api4 call that gets a particular set of activities. I'd like the call to return the names of the "target"/"with" contacts.
I've tried:
Joining the Contact directly "using" ActivityContact
$activities = \Civi\Api4\Activity::get(FALSE)
  ->addSelect('activity_date_time', 'subject', 'details', 'contact.display_name')
  ->setJoin([
    ['Contact AS contact', TRUE, 'ActivityContact'],
  ])
  ->addWhere('activity_type_id', '=', 56)
  ->addOrderBy('activity_date_time', 'DESC')
  ->setLimit(3)
  ->execute();

This works but leaves me with no way to limit the results to just the target contacts.
Joining the ActivityContact record, then the Contact
This is how I know the SQL needs to work, but it doesn't work [as expected] in Api4:

$activities = \Civi\Api4\Activity::get(FALSE)
  ->addSelect('activity_date_time', 'subject', 'details', 'contact.display_name')
  ->setJoin([
    ['ActivityContact AS activity_contact', TRUE, NULL, ['activity_contact.record_type_id', '=', 3]],
    ['Contact AS contact', TRUE, NULL, ['id', '=', 'activity_contact.contact_id']],
  ])
  ->addWhere('activity_type_id', '=', 56)
  ->addOrderBy('activity_date_time', 'DESC')
  ->setLimit(3)
  ->execute();

This ends up joining the contact ID to the activity ID(!)
a`.`id` = `activity_contact`.`contact_id`

Perhaps a Join in Api4 always means a join onto the primary entity? Except for hard-coded "using" joins? It's not mentioned in the documentation. Perhaps it's that you cannot do it from the API explorer? Though I kinda use that to figure out what you can do.
I'm using CiviCRM 5.35.1


texts: DB Error: unknown error (Tablespace is missing for table .civicrm_setting)

texts:
i just restarted my PC which has a locally hosted dev version of CiviCRM in WordPress, and now get the following error on initialization...

Initialization Error

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

  [code] => -1
  [message] => DB Error: unknown error
  [mode] => 16
  [debug_info] => SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id FROM civicrm_setting
WHERE (domain_id = 1) AND (is_domain = 1)  [nativecode=1812 **
Tablespace is missing for table `ieditims`.`civicrm_setting`.]
  [type] => DB_Error
  [user_info] => SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id FROM civicrm_setting
WHERE (domain_id = 1) AND (is_domain = 1)  [nativecode=1812 **
Tablespace is missing for table `ieditims`.`civicrm_setting`.]
   [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::simpleHandler prefix=""
 info="SELECT id, name, value, domain_id, contact_id, is_domain,
component_id, created_date, created_id FROM civicrm_setting WHERE
(domain_id = 1) AND (is_domain = 1)  [nativecode=1812 ** Tablespace is
missing for table `ieditims`.`civicrm_setting`.]"]

Please help!!!

Joe.


texts: Illegal characters in email signature field

texts:
For some reason we sometimes get an error when trying to save contact information after editing. An error pop-up appears with Illegal characters in input (potential scripting attack) when trying to save. It turns out that this can be solved by deleting the contents of the Email signature field (even though there are no visible contents). So I assume that there must be some invisible character in this field, but how did it get there (we never use this field)? And how can I suppress the signature field, so that this problem doesn't happen again? Thanks.

Edit: Civi 4.7.3 (but also happened in earlier versions). Joomla 3.4.8. MySQL 5.5.47 PHP 5.6.18 Centos 6.6.


texts:
I currently use Drupal 7.5.3 and need to upgrade to 7.5.4. Running it with CiviCRM. I'm a novice with this site and need a little hand holding to figure this out. Basically the site admin is AWOL and the person running the organization I'm working for asked me to figure this out.

I used instructions from here: https://wiki.civicrm.org/confluence/display/CRMDOC/Upgrading+CiviCRM+for+Drupal+7#UpgradingCiviCRMforDrupal7-1.DownloadthemostrecentCiviCRMPackage

I'm stuck at steps 7 through 11, since I don't know where the code files are stored or how to access them.


texts: Contact Tabs links gone away When clicking on Pager Next/Prev/Page Change under My Custom Tab for Contact

texts:
Here is my code of .tpl file:

...

{include file="CRM/common/pager.tpl" location="top"}
{strip}

            ...

        {foreach from=$rows item=row}
            ...
        {/foreach}

{/strip}
{include file="CRM/common/pager.tpl" location="bottom"}

{include file="CRM/common/jsortable.tpl"}

and Code for setting up Pager:

/**
 * Setting up $_pager for pagination support
 * Used CRM_Utils_Pager & CRM/common/pager.tpl to handle pagination
 */
public function pager() {
    // Setting up parameters for Pager that we are gonna create
    $params['status'] = ts('Some Entity %%StatusMessage%%');
    $params['csvString'] = NULL;
    $params['buttonTop'] = 'PagerTopButton';
    $params['buttonBottom'] = 'PagerBottomButton';
    $params['rowCount'] = $this->get(CRM_Utils_Pager::PAGE_ROWCOUNT);
    if (!$params['rowCount']) {
        $params['rowCount'] = CRM_Utils_Pager::ROWCOUNT;
    }

    // Getting all Some Entity by Contact ID. if $_contactId is null then it return value for all Contact.
    $params['total'] = civicrm_api3( 'Entity', 'getcount', array( 'contact_id' => $this->_contactId ) );;

    // Setup Pager object and assign into template so it can be used by CRM/common/pager.tpl
    $this->_pager = new CRM_Utils_Pager($params);
    $this->assign_by_ref('pager', $this->_pager);
}

Thanks.


texts: Prefill webform with civicrm activity data

texts:
I want to prefill a webform with data from a specific CiviCRM activity in order to edit the activity using the webform. I want to do this by having an "Edit" link in a Drupal View of CiviCRM activities. These activities may or may not be associated with a case, so let's assume they aren't. I've turned on "Update Existing Activity" in the webform for all of the statuses.

Can someone confirm that I can do this, and if so, what is the proper form of the URL for the link in the view? I've tried a bunch of different ones and can't seem to get it.


texts: Unable to access Registration Screen dropdown Civievnts

texts: This is probably not a Civi issue, but any feedback would be appreciated. I have set up an event. Under Registration Screen, I have the option to Include Profile Top of Page and Include Profile Bottom of the Page. When I select an option in either or both fields and save, I am not able to access either field again. They are both greyed out. After much work with a colleague yesterday, we established this occurs only in Firefox. I have logged into Microsoft Edge and I am able to access the dropdown. I like using Firefox and I don't want to have to change between browsers when using Civi. Is there a way to solve this? Thanks.


texts: Event confirmation e-mail is showing empty values for the mandatory profile fields

texts:
I'm using the Events - Registration Confirmation and Receipt (on-line) under the workflow messages in the e-mail templates.

My event is using a custom Profile for the form fields.

The confirmation page in de event form flow is correctly showing ALL entered values.

The confirmation e-mail however, is showing empty values for all fields that were made mandatory in the profile. Screenshot added:

The code from the e-mail template (from: civicrm/admin/messageTemplates?reset=1 => Events - Registration Confirmation and Receipt (on-line) ) I could work with is:

{if $customPre}
{foreach from=$customPre item=customPr key=i}
    {$customPre_grouptitle.$i}
   {foreach from=$customPr item=customValue key=customName}
   {if ( $trackingFields and ! in_array( $customName, $trackingFields ) ) or ! $trackingFields}

         {$customName}
         {$customValue}

   {/if}
   {/foreach}
{/foreach}
{/if}

This isn't telling me much, though.

Any thoughts?


texts:
if ($formName == 'CRM_Contribute_Form_Contribution_Confirm' && $form->_id == 1) {

   CRM_Core_Resources::singleton()->addScriptFile(drupal_get_path('module','custom_water') .'/',
     'custom_water.js');

}

When I use the above code as mentioned in the link
https://wiki.civicrm.org/confluence/display/CRMDOC43/Resource+Reference#ResourceReference-Introduction

Add a Javascript file
PHP
CRM_Core_Resources::singleton()->addScriptFile('com.example.foo', 'bar.js');

I get an error : Fatal error: Class 'CRM_Core_Resources' not found in

I am using drupal 7 with CiviCRM


texts: Reinstall Summary Fields Not Creating Triggers

texts:
I have uninstalled and reinstalled Summary Fields a couple of times trying to get the triggers to show up on the admin screen as having been recreated.  I started looking into this because we have a transient problem when saving contributions. I think that when the database was restored I did no recreate them and now they are not recreated by reinstalling Summary Fields.

I just want to rebuild the triggers.
Thanks,
Josh


texts: CiviEvent: Scheduled Reminders going out late

texts:
Drupal 7.69 and Civi 5.23.0

We've noticed that some of our Scheduled email reminders for events set up through CiviEvent are going out late. I've looked into email logs and it looks like scheduled reminders for events are sent out once per day at 9:16am.

This causes issues for e.g. events that begin at 5pm where we want to send a scheduled reminder 2 hours before the event to remind participants -- emails like this have ended up being delivered at 9:16am the following day.

Is there any way to fix this?

Cheers


texts: insufficient permissions during upgrade 4.5.5 to 4.6.10

texts:
Following the directions on this page.
WP 4.3.1, standard LAMP install. All plugins up-to-date except CiviCRM. The plugin is obviously active. Using putty.exe, I remove the civicrm directory and untar the 4.6.10 directory in its place. When I use the wp-admin/admin.php?page=CiviCRM&q=civicrm/upgrade&reset=1 upgrade URL, I get the insufficient permissions notice. I'm logged in as the user 1 administrator. Settings file is where it should be. No files have wonky read-write or owner perms. I'm at a loss as to why I am unable to get past the upgrade URL step. I'd be grateful for suggestions.


texts: How do I sort the bookkeeping report by date?

texts:
How do I sort the bookkeeping report by date (descending)?

I have sorted by contribution ID but this isn't exactly by date and when you are looking for a transaction it is easy to assume that it hasn't been made when scanning by date, especially if it is on the next page.

Can export and sort the exported data, but this makes people think the report is not working.

It is #20 on the civicrm demo site dmaster.demo.civicrm.org/civicrm/report/instance/20


texts: Issue with contact import Street Address -- drops address if over 25 chars in length

texts: I am working on a test system as we work through the process to import data from BasicFunder into CiviCRM.  I've hit a strange issue with import of Contact address data.  A number of imported records are showing FALSE as the Street Address.  Some investigation reveals that if an address in the CSV file that is mapped to Street Address is over 25 characters in length it is not imported and the field is left as FALSE.  I thought I saw a post somewhere that indicated this field is 96 chars in length.  Anyone have any ideas?  This is just a test system so easily enough rebuilt if there is a fundamental flaw in it somewhere.


texts: How is the en-/decoding of the optOut-URL done ? (algorithm)

texts:
is someone there who knows how the en-/decoding of the optOt-URL is implemented ?
Example:
https://....../crm/civicrm/mailing/optout?reset=1&jid=7&qid=14&h=817b324557dc9cb9
I'd assume that the part "817b324557dc9cb9" is the encoded contact_id 15944 ???
Please help me ;-)
Thanks a lot and kind regards
Dieter
p.s.:
https://gchq.github.io/CyberChef/
=> Analyse hash:  817b324557dc9cb9
Hash length: 16
Byte length: 8
Bit length:  64
Based on the length, this hash could have been generated by one of the following hashing functions:
CRC-64
RIPEMD-64
SipHash


texts: Contributions- on behalf of existing organisations only?

texts:
Our members are all organisations (schools and colleges). Payment is taken outside of Civi after sending an invoice. We're not currently using Contributions. We're looking at a big project to automate/improve our reporting. I'm interested in using a contribution page internally to record payment, most likely using a price set to count how many of certain options they have purchased either with their membership or separately afterwards.

It is important that we only create memberships on existing organisations, but the help for selecting an "On Behalf Of" profile says "The profile must include Organization Name and Email Address". Is there a way of restricting the selection of organisations to existing only, and preferably within certain subtypes or a certain group?


texts: unexpected 500 errors and networks errors

texts:
We have a standalone install of CiviCRM Spark, version 5.16.beta1. This is hosted with civicrm.org.  We have imported our contacts, which total about three or four hundred. We are, however, unable to use some of the functions of the site and don't know why. Hoping someone would be able to assist?

When we go into a member record, to update their contributions, we can get as far as clicking "Contributions" in the left hand menu, but the page comes up blank, and there is an error in the top right saying "Network Error
Unable to reach the server. Please refresh this page in your browser and try again." This error comes up consistently every time. The same thing happens when we click "Memberships" or "Events" in the left hand menu, though the other menu entries seem to work as expected when clicked.

Additionally, when we click "Contributions > Dashboard" in the top-of-screen toolbar menu, we consistently get a 500 error. We also get a 500 error every time we click "Contributions > New Contribution".

Rather weirdly, we also get a 500 error the very first time we visit the CiviCRM home page, however we do not get this 500 error again, it only comes up the first time.

We have also noticed that the public facing page for site visitors to enter their details to become a member, this page is now showing a 500 error as well, meaning no-one can actually sign up at the moment.

As I said above, these problems seem to have manifested since we imported contact data into CiviCRM, which we did using the "Import Contacts" wizard within CiviCRM.

We are not particularly literate when it comes to this kind of configuration, and would appreciate any insight you might be able to provide.


texts: Drupal Webform - CiviCRM - PayPal Website Payment Standard - Email Required Issue

texts: I am using Drupal 7.53, Webforms 7.x, CiviCRM 4.7.13 with PayPal Website Payment Standard. On checkout in the Webform it is requiring email and we have email in the webform. We can't manipulate billing. Any ideas on how to force this to work?


texts: Is there a way to limit the child groups displayed on an opt out message?

texts:
If you have a mailing group with child sub groups, when you offer an "opt out from this list" option, all child groups are displayed - including ones that the recipient  isn't a member of
eg
a parent mailing group made up of 2 child groups

             Main mailing group

  Child group 1 - parent = Main mailing group

  Child group 2-  parent = Main mailing group

If contact A is a member of child group 1 and she opts out of a mailing to Main mailing group she is shown both child group 1 and child group 2

Is there a way to limit which groups are shown?


texts: CKEDITOR is undefined when form is being loaded in model frame outside of /civicrm/ path

texts:
Yet another question regarding JS resources load outside of civicrm. We load contact edit form via CRM.popup from a page outside of /civicrm/ path (from custom  dashboard page created in drupal). So far [it was] so good; recently we've mentioned that javascript goodies have stopped working on the form; only related message in a browser console is CKEDITOR is undefined. It all goes back to normal after disabling WYSIWYG at "Display Preferences" (we've got same error with TinyMCE enabled).
Is it something we could "cure" via configuration tinkering or it is something to report as an error?


texts: Should a second receipt be sent when payment method is ACH with iATS?

texts:
Using the iATS payment extension, credit cards and ACH transactions are going through just like they're supposed to.  The only hiccup is that one-time ACH transactions are generating a second 'online' receipt when the transaction is later moved from Pending to Completed via the iATS Payments Verification scheduled job.  Is that supposed to happen?  If not, any ideas on how to track down what is causing it?

Further Details

When the ACH transaction is first submitted (upon the donor hitting the Submit button on the contribution page), a receipt is issued with all relevant details and the contribution is marked as Pending in CiviCRM (as it should).  Later that day or the next business day, iATS receives the okay from the donor's bank and marks the transaction as OK:BankAccept in their system (as it should).  When the iATS Payments Verification scheduled job next runs (it runs hourly), the contribution is changed to Completed in CiviCRM (as it should) and a second receipt is generated (??).  The second receipt has the basic information (amount, date of transaction, transaction id) and our profile we include in the Online Receipt message template, but none of the financial information nor the billing address info.

The receipt time and date for the contribution is updated to the time of the second receipt and matches when the iATS Payment Verification job ran, so it would appear that is the link.  There are two activities in the contact's record, one for the actual contribution when it first occurred and then a second activity for when the contribution status got changed from Pending to Completed.

What causes the online receipt message to fire?  Could the recording of the second activity be causing the 2nd receipt?

Civi 4.6.14 (will be updating to 4.6.20 before go-live); Drupal 7.44; iATS Payments extension 1.5.3


texts:
I am using CiviCRM on wordpress 4.8.1

I am trying to set up our email templates.
When I link to something the html is correct and links to the correct page, but when I send the email the links become
https://mysite.org/wp-content/plugins/civicrm/civicrm/extern/url.php?u=60&qid=

What is going on here?  How do I fix it?
Thank you.

****UPDATE****
I just discovered that even when trying to browse the server for an image in the template, I get redirected to a 404 page.   I hope that sheds some light on what the problem might be.


texts: CiviCRM stripe Webhook is showing "invoice.payment_succeeded" 500 internal server Error`

texts:
I have upgrade the CiviCRM Stripe extension to latest 6.5.1  After upgrade extension one time donation is working properly. But Recurring payment is showing Pending (Incomplete Transaction). And also stripe webhook logs is showing event type "invoice.payment_succeeded" 500 internal server Error.
I am using
Stripe: 6.5.1
Mjwshared:  0.9.4
Php: 7.2.24


texts:
I have a CiviCRM event linked on my web site, and one person tried to purchase tickets to the event several times.  She says she was eventually able to log into her PayPal and complete the transaction.

Our receipts go into our PayPal account, and her payment is not showing up in our account.  In addition, her transactions all show as 'Pending (incomplete transaction)' in the CiviCRM event.

In reviewing previous posts, it appears that there is an issue with how PayPal processes payments, but the discussion and the patch is WAY over my head.

Can anyone give me a simplified answer to how to get her last transaction to process properly?  I'm very concerned that this will become a larger issue with others attempting to purchase tickets.

Thanks!


texts: Text from Contribution page runs into my blog previews?

texts:
Uh... It's totally possible that this question has been answered already, but I couldn't even really figure out what my search term would be to find it...

I'm working with a new Wordpress install (my first CiviCRM experience!) and have set up two contribution pages - one for any type of financial contribution, and one that is specifically a Membership sign-up. For each of them, there's the most basic text in advance (first, the automated, CiviCRM-provided "Welcome Ashley Morton. (Not Ashley Morton, or want to do this for a different person?)", then there's what I wrote. Just "Hi there! Thanks so much for your contribution!" (for the moment, at least.) That much is good, and it appears to be working properly.

Then, on the right-hand side of our page, we have a widget that previews the most recent two blog posts from the organization. Shows the title (clickable link), and then the first couple of sentences.

However, the contribution text, beginning with "Welcome Ashley..." has now replaced all of the blog-post preview text for every blog post!

It's so weird! Anyone heard of / seen this before? Any suggestions would be appreciated.


texts: What's the best way to assign a case role via the API?

texts:
When you assign a case role through the UI it creates lines in the relationships and activities tables. I can't find an equivalent through the API - I can create the relationship (which then shows correctly in the case UI), but it doesn't create any activity lines. Does that matter? Or is there a better way?

Edit: Running on Civi 4.5.8 on WordPress.

Cheers,

Andrew


texts:
Trying to semi-automate my upgrade process by using "drush civicrm-upgrade", but I'm concerned that any critical messages, e.g. that default message templates have changed, won't be displayed in the shell.

I have a vague recollection that there exists a URL which will display the site's most recent upgrade messages, but I can't find it now in the documentation. Is there such a URL?

And does drush civicrm-upgrade display such messages in the shell?


texts: Customizing the display of Recent Contributions on Contribution > Dashboard

texts:
I would like to be able to display a contributors assigned/chosen Campaign on the Recent Contributions dashboard:

Any way to customize these dashboards?

Thanks,

E


texts: Creating extension with civix: How to use CRM dir?

texts:
I want to create an extension for CiviCRM that will add an extra column for appended documents inside the activities list of a Case View. That is, when users have appended a document while creating an activity, that document will not be shown in one column together with the View, Edit and More links, but in a separate column together with their filename, for a clearer view.
The changes I need to make contain six patches inside three PHP files, and one patch inside a template file.
I used civix to create an extension skeleton.
Then, it has been easy to make the adapted template file work by copying it into sites/default/files/civicrm/ext/extensionname/templates/Case/Form/templatename.tpl. The path where the original template lies is sites/all/modules/civicrm/templates/CRM/Case/Form/.
But now, I'm struggling with including the adapted PHP files.
I know that hook functions exist and that I could try to find a suitable hook function for each of the six patches, but it seems a very complicated solution to me.
I wonder if there is a solution similar to the way templates can be included in extensions?
For example, is there a way to put all the PHP files inside a folder structure like sites/default/files/civicrm/ext/extensionname1/CRM/extensionname2/path/to/example/example.php, and they will simply be called instead of their original CiviCRM "sister file"?
In this example, extensionname1 stands for the name I gave to the extension while creating it with civix generate:module (here: de.company.activities-column-for-documents) and extensionname2 stands for the extension's 'given name' from info.xml (here: ActivitiesColumnForDocuments when info.xml contains <file>activities_column_for_documents</file>).
I came up with this idea after reading https://docs.civicrm.org/dev/en/latest/extensions/structure/ where it sounds like you'd be able to do that, if you only follow the naming conventions (CRM_Myextension_...). Though, it didn't work, even though I renamed all my PHP files, e.g. from Case.php to CRM_ActivitiesColumnForDocuments_Case.php.
The only other related thread I could find was How to Create an extension? but I didn't find it helpful here.
Can I use the CRM directory that is auto-created by civix to easily store custom versions of existing CiviCRM PHP files? How?
If not, what is the auto-created CRM directory for?
Any hints are appreciated :) If I can successfully create the extension, I will of course publish it here.


texts:
Let me start with I have read numerous posts regarding this issue and have tried the max_input_vars = 2500 and I only have 10 groups (nine standard and one added).

I am trying to add the View My Invoices for all Registered users. So selecting that option and changing the permissions to Allow for Registered shows the new setting to be correct but when you hit save/save and close it doesn't actually update. I do get the updates saved message, but again no update.

I have gone into the database and manually added this code {"2":1},"civicrm.view_my_invoices": in the Asset table. That will display the Print Invoice button in the users Dashboard, however, when you click it you get a Joomla error page that indicates that you don't have permissions to access this page.

I am hoping someone has suggestions or possibly post their Asset table civicrm Rules entry that is working on their site. Thanks for any suggestions or advice.


texts: How can I make every new Group a type Mailing List?

texts: I have a request to enable making every new Group created (using search results -> Actions -> Add Contacts to Group) a group type Mailing List by default, thereby saving a user having to check the box next to Mailing List.  Can I do that with a new extension, using one of these hooks?


texts: "Register your site" link in Configuration Checklist leads to broken page

texts:
Just installed CiviCRM in a new wordpress docker container I pulled this morning. Going through the Configuration Checklist, the 4th link from the top leads to a broken page with a "Page not found" error. I verified it does the same thing in the English Demo site.

To reproduce, just open the Demo site, click Administer > Administration Console > Configuration Checklist, and click the "Register your site" link, 4th from the top of that list.


texts: Multiple Types of Contributions using CiviContributions Drupal Integration

texts:
I am trying to use one webform to collect multiple types of contributions from one contact. Specifically, we are trying to collect a sponsorship and in-kind donation for one event from one contact type on the same webform. While I don't need to access two different contribution pages, I do want the webforms to population two different contribution records one for the monetary sponsorship, and another with the value of the in-kind donation. Does anyone know how to set this up?

Thanks,
Neena


texts: How To Manage a Webform and a Contribution page?

texts:
I currently have a webform set up so that an individual, while renewing a membership for an organisation, is required to update the organisations details at the same time as processing a payment.

From my interpretation of CiviCRM (4.4.14) there are two different methods of achieving this:

Renewing the Membership as part of the webform. The user completes the detail update and then the contribution page appears as "page 2 of 2"
Updating the form and then putting the URL of the contribution page as the confirmation page, so essentially it saves all the updated details before accepting payment.

I am trying to work out though; which it better practice? I know that essentially both payment pages are the same, but are there any advantages (ie security, etc) to directing the user directly to the contribution page?


texts: Hide CiviCRM navigation menu based on permission

texts:
Any suggestions for a not-too-hacky way to hide the whole CiviCRM top navigation menu for users who don't have a particular permission? I could load some menu-hiding css or js conditional on permissions, maybe in Civi pageRun+buildForm hooks or Drupal preprocess_page hook - but that feels hacky.

CiviCRM 4.6, Drupal 7.


texts: In CivilMail for 4.6.2 how do I prevent duplicate emails?

texts:
Since 4.6.2 CiviMail is sending every email twice. I'm enclosing an attachment to show. The report also shows the successful delivery at 200% on some emails and 300% on others.

http://forum.civicrm.org/index.php/topic,36345.0.html


texts:
We are a new iATS client and have hit a bit of a roadblock.

I followed the iATS extension instructions here for setting up the payment processor.  On my local dev environment, things went great and I was able to process a contribution using the TEST88 information without a problem.

When I tried to set up the iATS payment processor on our live production server and tried a contribution in the same manner, I received a white screen with the following error:

  Fatal error: Call to a member function __getLastResponseHeaders() on a
  non-object in
  /~oursite.org~/sites/default/files/civicrm/extensions/com.iatspayments.civicrm/CRM/iATS/iATSService.php
  on line 202

Following the debug advice from the iATS instructions (I turned on Drupal/CiviCRM logging) and tried again.  I received the same white screen and error.  I checked the Drupal logs and received the following error, notice and warnings:

  Type: civicrm_iatspayment_com SoapFault: SoapFault Object (
      [message:protected] => SOAP-ERROR: Parsing WSDL: Couldn't load from 'https://www.iatspayments.com/NetGate/ProcessLinkv2.asmx?WSDL' :
  failed to load external entity
  "https://www.iatspayments.com/NetGate/ProcessLinkv2.asmx?WSDL"
  [the error in the logs is rather long and shows sensitive information, so I've truncated it]

  Type: php --  Notice: Undefined variable: soapClient in iATS_Service_Request->request() (line 202 of
  /~oursite.org~/sites/default/files/civicrm/extensions/com.iatspayments.civicrm/CRM/iATS/iATSService.php).

  Type: php --  Warning: SoapClient::SoapClient(https://www.iatspayments.com/NetGate/ProcessLinkv2.asmx?WSDL):
  failed to open stream: operation failed in
  iATS_Service_Request->request() (line 161 of
  /~oursite.org~/sites/default/files/civicrm/extensions/com.iatspayments.civicrm/CRM/iATS/iATSService.php).

  Type: php -- Warning: SoapClient::SoapClient(): Failed to enable crypto in iATS_Service_Request->request() (line 161 of
  /~oursite.org~/sites/default/files/civicrm/extensions/com.iatspayments.civicrm/CRM/iATS/iATSService.php).

  Type: php -- Warning: SoapClient::SoapClient(): SSL operation failed with code 1. OpenSSL Error messages: error:14077410:SSL
  routines:SSL23_GET_SERVER_HELLO:sslv3 alert handshake failure in
  iATS_Service_Request->request() (line 161 of
  /~oursite.org~/sites/default/files/civicrm/extensions/com.iatspayments.civicrm/CRM/iATS/iATSService.php).

Searching Google for "SOAP-ERROR: Parsing WSDL" related to iATS and CiviCRM, I found this comment and this GitHub issue by Joe Murray indicating that the issue could be related to inadequate SSL Protocols.  This announcement from iATS also seemed to indicate that.

I've taken the last two days to upgrade our OpenSSL to 1.0.2g and adjusted our SSL Protocols to only accept TLSv1.2.  The SSL Labs SSL Server Test had initially rated us at a C, but after upgrading OpenSSL and the SSL Protocols, we now rate at an A-.

Having updated our security settings, I cleared caches in both CiviCRM and Drupal and attempted our test contribution again, using the TEST88 information.  We still receive the same white screen error in the browser and the above error, notice and warnings in the Drupal logs.  I also tried using our actual account information with iATS.  Same result.

Any ideas on what to try next?

iATS extension 1.5, CiviCRM 4.6.14, Drupal 7, Apache 2.2.24, OpenSSL 1.0.2g


texts: CiviMail not sending mails in 4.7.6 / Drupal 7 "DB Error: syntax error"

texts:
Since upgrading to 4.7.6 we have two CiviMail bulk emails with the status "Running" that have not actually been sent.  In the scheduled jobs log there is this message:

  Finished execution of Send Scheduled Mailings with result: Failure,
  Error message: DB Error: syntax error

  Parameters parsed (and passed to API method):
  a:1:{s:7:"version";i:3;}

  Full message:  Finished execution of Send Scheduled Mailings with
  result: Failure, Error message: DB Error: syntax error

In ConfigAndLog The full error is shown here, but I'm struggling to locate the actual fault / corrective action.  Any help greatfully received.


texts: How to make event registration form fields be displayed inline

texts:
At the moment, each field specified in a profile that is related to an event online registration form, has its own line, inside its own div.
I want to be able to display 2 specific fields in the same line, which are logically connected to each other.
How can I do that?


texts:
Steps to reproduce:

Search -> Find contribution
Search for a contribution
Choose "Email - send now" as action
Choose an email template with a token. In our case we just use the token "{contact.email_greeting}"
Send the email

The following error message appears several times for each email:
Warning: array_search() expects parameter 2 to be array, null given in CRM_Contribute_BAO_Contribution::getContributionTokenValues() (line 5769 of \sites\all\modules\civicrm\CRM\Contribute\BAO\Contribution.php).

We use CiviCRM with Drupal 7 and the latest CiviCRM 5.29.1.
For me it seems that the code
    if (strpos($fieldName, 'custom_') === 0 && array_search($fieldName, $messageToken['contribution']) !== FALSE) {
      $result['values'][$id][$fieldName] = CRM_Core_BAO_CustomField::displayValue($result['values'][$id][$fieldName], $fieldName);
    }

should be
    if (isset($messageToken['contribution']) && strpos($fieldName, 'custom_') === 0 && array_search($fieldName, $messageToken['contribution']) !== FALSE) {
      $result['values'][$id][$fieldName] = CRM_Core_BAO_CustomField::displayValue($result['values'][$id][$fieldName], $fieldName);
    }

because by now array_search($fieldName, $messageToken['contribution']) assumes that $messageToken['contribution'] is set which does not seem to be true in every case.


texts:
I am trying to switch from RDS to Aurora DB for test site to see if it is viable.  I am confused with the first problem I am running into and I am not sure why CiviCRM would have this issue.  Drupal 8 can connect to the database server using the same credentials as we are trying to use for CiviCRM.
I get the following error:
Initialization Error

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

[code] => -24
[message] => DB Error: connect failed
[mode] => 16
[debug_info] =>  [nativecode=php_network_getaddresses: getaddrinfo failed: Name or service not known]
[type] => DB_Error
[user_info] =>  [nativecode=php_network_getaddresses: getaddrinfo failed: Name or service not known]
[to_string] => [db_error: message="DB Error: connect failed" code=-24 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info=" [nativecode=php_network_getaddresses: getaddrinfo failed: Name or service not known]"]

)
The error comes up twice on the screen or the command prompt so I am guessing this error is for both the CiviCRM connection string to the CiviCRM database and the CiviCRM connection to the Drupal database. They are two databases in the same instance.
My database string looks correct to me and matches what I have for the existing RDS instance.
mysql://user:password@db_name-aurora-cluster.cluster-ctaoxt42sdhl.region.rds.amazonaws.com:3306/d8dev?new_link=true')

I am using Amazon Aurora with MySQL support. Drupal is able to connect (drush status) and I can login into MySQL from the command line and was able to execute an update query.
Any ideas are greatly appreciated.
Thanks!


texts: Which directories in an extension get scanned by CiviStrings

texts:
CiviStrings is a cli tool that scans an extension for translatable strings and generates a .pot file. According to the readme,

  It scans PHP, Smarty, JS, and partial HTML files for references to the ts() function -- and generates a list of strings using gettext's POT file format.

I'd like to know which directories it scans in an extension. I know it will scan files in the /ang directory, but what if I place an html file somewhere else, like /foo/bar.html - will that file also get scanned?


texts: CiviCRM - Contribution page profiles JavaScript error

texts:
before you send me to check already solved similar questions, this is not the same case.

Common problem is conflict with installed plugins -> disable/enabled them all, none, different order = nothing (I dont have jetpack, google dashboard, wp cards)

Another cause is template -> changed template, no difference but if I add Civi into blank Wordpress instalation it works.

Does anyone have same experience that it cannot be fixed with the "common" way ? And if yes did you manage to fix it ?


texts: Why do click and open reports show times in UTC rather than the site's timezone?

texts: The mailing and click tracking reports are showing times in UTC. There is no PHP MySQL timezone mismatch - and mysql -e 'select now()' and date return the right times - as per timezone.


texts: How to debug Smarty mail template codes, broken after upgrade

texts:
I have a few Mail Templates that have conditional smarty codes like:

{capture assign=pp_scan}{contact.custom_74}{/capture}{if $pp_scan}You have already provided{else}You have not yet provided{/if} a scan of your passport.

This code ran just fine until I upgraded to 4.7.27 (from 4.7.21). Don't know if it is related to the upgrade or just a coincidence. Now, this code resolves to

  {capture assign=pp_scan}{/capture}{if $pp_scan}You have already provided{else}You have not yet provided{/if} a scan of your passport.

in the text of the email.

How do I debug the smarty code in mail templates? I tried adding {debug} to the mail template, but that didn't help.


texts: Is there a way to track the date the pending payment record was created once payment has been completed?

texts:
I create a pending contribution for a membership with the received date of 1st July.
I then go in and complete the contribution on the 7th of August.
I cannot find where in Civi the original pending payment invoice date of 1st July is stored.
What I see happening is all received dates (including in the invoice) change to 7 of August.
Is there anywhere where the original date is stored once the payment is completed?


texts:
CiviMobile app on Android errors when trying to add or edit a phone number.

clicking save returns error "Please enter phone number"

App occasionally crashes when trying to add a phone number.  Other fields edit and save as expected.

CiviCRM 5.14 on Drupal 7.67
extensions:
CiviMobileAPI (com.agiliway.civimobileapi) version 3.1
CiviMobile (com.webaccessglobal.module.civimobile) version 2.0

Android App

Anyone else having this issue?  Thanks


texts:
When exporting information, is it possible to separate each contacts' various tags into separate columns?

That way I'd be able to sort the resulting spreadsheet by specific tags, instead of having to create a separate spreadsheet for each tag.


texts: Can I use tokens in Civi profile Cancel Redirect URL?

texts:
Custom profile to edit a contact's activity.

Redirect URL is formed: www.example.com/activities/{contact.id} and works correctly.

I'd like to use the same redirect for Cancel Redirect URL.  Is it possible?  Are tokens supported in the cancel url or do I have to set a static page for cancel?


texts: Controling the order on wordpress contribution pages

texts:
I have a contribution page for membership signup, dues and other member information. It is a "on behalf of an organization" style membership. Right now, the form displays the fields in this order

membership pricelist
"on behalf of organization" details
wordpress account creation
and 5 - 2 other profiles I've added using the "Profiles" capacity of contribution forms.

Is there a way to have the order instead be 4, 5, 3, 2, 1? Should this be done through CSS or is there a better way? The "order" field doesn't seem to do much in this regards.


texts: No one at our organization knows how to use Civi. The person who set it up is no longer on staff. How do we even get in touch with someone? We urgently need to get into our account on the Civi website and have no idea how to update the login credentials. Please help!


texts:
I have buildkit installed on my computer however the php command is called php56.

The civibuildkit command fails because it is looking for a command called php.

Is there an easy way I could change the settings in buildkit so it will use the php56 command?

Solution

I put a symlink in /home/jaap/php56/php to the php56 binary and then I created a wrapper script.

mkdir /home/jaap/php56
ln -s /usr/bin/php56 /home/jaap/php56/php

Then I created a script in /home/jaap/bin/civibuild.sh:

#!/bin/bash

export PATH="/home/jaap/php56:$PATH"
/home/jaap/bin/civicrm-buildkit/bin/civibuild $@


texts: Database constraint error on enabling CiviCase

texts:
I'm running civicrm 4.4.20 on the latest Joomla 3.4.5. When I try to enable CiviCase I get an database constraint error (see below).

[code] => -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] =>
      INSERT INTO `CIVICRM_OPTION_VALUE` (
        `option_group_id`, `label`, `value`, `name`,
        `grouping`, `filter`, `is_default`, `weight`,
        `description`, `is_optgroup`, `is_reserved`, `is_active`
      ) (
        SELECT
          @option_group_id_case_type, 'Housing Support', @max_val + 1, 'housing_support',
          NULL, 0, 0, @max_wt + 1,
          'Help homeless individuals obtain temporary and long-term housing', 0, 0, 1
         FROM   DUAL
         WHERE  NOT EXISTS (SELECT command.plist infoShowed
                            FROM   `CIVICRM_OPTION_VALUE`
                            WHERE  `name` = 'housing_support')
      )
    [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`xxx_joomla`.`civicrm_option_value`, CONSTRAINT `FK_civicrm_option_value_option_group_id` FOREIGN KEY (`option_group_id`) REFERENCES `civicrm_option_group` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error


texts:
We are considering to change our domain name from:

reallylongandnotuserfriendly.example.com

to:

you.example.com

We have a Drupal 7 site. What are the consequences / fixes we need to be aware of, to not harm our CiviCRM installation?


texts: What Are the Best WordPress Theme Recommendations for CiviCRM

texts:
We are about to deploy Civi CRM in our WordPress website. We are using the Avada Theme from ThemeFusion. I came across a couple of comments saying that with Avada's recent upgrades, this was causing CSS and other issues.

Can I ask this community to weigh in on which themes they recommend for a WordPress & CiviCRM website?

What's important to us?

We would love to have some of the bells & whistles that Avada supplies. For example, we can designate whether any block of content on a page will show across all devices (smartphones. tablets, desktops) or only specific devices. This is especially helpful when we don't want some content to show on mobile and when we do want specific content to show on mobile but not desktop.

Most importantly, the theme needs to work with CiviCRM to make it as mobile-friendly as possible.

Many thanks in advance for any recommendations and advice.


texts: Can I status override an auto renewing membership?

texts:
A client wants to status override a recurring membership but cannot do so.

Here are a couple of membership edit screens:

The first is for a membership that is auto renew and has an associated recurring contribution:

The second is for a membership that is not auto renew and does not have an associated recurring contribution:

It seems that for some reason, we don't allow people to status override recurring memberships.

Can anyone shed any light on why this is not possible?

Is there a business case for it being set up in this way.

I did have a look at the code but nothing obvious jumped out at me. I'm guessing someone out there knows the thinking behhind this.


texts: Custom report: how can I add a filter for a dbAlias field?

texts:
In a custom report -> I've created a field

 'civicrm_contribution' => array(
    'dao' => 'CRM_Contribute_DAO_Contribution',
    'fields' => array(

...

         'amounts_ytd' => array(
           'title' => ts('Amount - YTD 2018'),
           'required' => TRUE,
           'dbAlias' => "SUM(CASE WHEN year(contribution_civireport.receive_date)=2018 THEN contribution_civireport.total_amount ELSE 0 END)",
         ),

This works nicely - it produces the correct total in the amounts_ytd column.

How would I go about filtering on this amount - to e.g. find all contacts who have amounts_ytd > $100?

Under:

    'filters' => array(

What does this need to look like?

  'amounts_ytd' =>
     array('title' => ts('Aggregate amounts_ytd'),
       'operatorType' => CRM_Report_Form::OP_FLOAT,
       'type' => CRM_Utils_Type::T_FLOAT,
       '??'
     ),


texts: Wordpress install fails : Fatal Error: Uncaught

texts:
I'm having an issue installing civicrm against a WordPress install.  Plugin is installed.  wp-content>uploads>civicrm is present, writable, and empty.  I have specified a separate database to use.  However, I was encountering the same issue when I tried to install against the WP database.  This is the error I am receiving:

Fatal error: Uncaught Civi\Setup\Exception\SqlException: Cannot execute CREATE TABLE civicrm_extension ( id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Local Extension ID', type varchar(8) NOT NULL , full_name varchar(255) NOT NULL COMMENT 'Fully qualified extension name', name varchar(255) COMMENT 'Short name', label varchar(255) COMMENT 'Short, printable name', file varchar(255) COMMENT 'Primary PHP file', schema_version varchar(63) COMMENT 'Revision code of the database schema; the format is module-defined', is_active tinyint DEFAULT 1 COMMENT 'Is this extension active?' , PRIMARY KEY (id) , UNIQUE INDEX UI_extension_full_name( full_name ) , INDEX UI_extension_name( name ) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC: Specified key was too long; max key length is 767 bytes in /var/www/vhosts/.org/httpdocs/wp-content/plugins/ in /var/www/vhosts/.org/httpdocs/wp-content/plugins/civicrm/civicrm/setup/src/Setup/DbUtil.php on line 204
Any thoughts on where to start? Happy to provide any info needed to help troubleshoot.  Thanks in advance.


texts:
This is in planning for upgrade to J!3. I have found no workable solutions here or elsewhere on the web.

CiviCRM 4.6.4
Joomla 2.5.28
MySQL 5.5.38-1~dotdeb.0
Apache 2.2.16
PHP 5.3.29-1~dotdeb.0
Debian Squeeze 6
Linux 2.6.32-5-amd64

On all virtual hosts before I updated CiviCRM (4.4.x and 3.5.x) the Dashboard shows up but the Ajax "Loading..." widget just keeps spinning and freezes the whole GUI. If I click on another CiviCRM link and restart Apache, it will go to that page and I can navigate around but going back to the Dashboard locks it up again. I then updated both instances to 4.6.4 to the same result. I've disabled all other third party extensions to no avail.

I get no unusual errors in Firebug. Under Net, just a bunch of GET 304 reports for a lot of CiviCRM jQuery and other Javascript libraries.

Turning on Debugging with backtrace produces no output. Clean page.

Any help would be greatly appreciated. Thanks in advance.


texts: Can you add a Civi Mailing group to an outlook calendar invite?

texts: I have recently created a Mailing group with 138 email addresses. I would like to send a calendar invite in outlook to the mailing group. Is this possible?


texts: Creating a custom Form: Action (view vs update)

texts:
I'm building my first extension, and have created the sample quickform using civix generate:form. So far, so good, the form shows and works within a modal popup.

I've noticed with Core forms (like Contribution edit/view), I can send in an "action" query param, and based on the value of that, the form will either just display a view of the data for that ID, or will show the actual form to edit the data and save it.

I was wondering how I could do that in my custom extension. Do I need to create two sets of php/tpl files, one for editing and one for viewing? Or is there some method or something that will convert the form template to just a view of the fields for me?

If there is a simple example of this type of form (maybe an example extension I could look at), I would appreciate a pointer to it.


texts:
I need to add a new CIVI CRm user, how can I do that please???

I used to do that before but i forgot how to do it now.

I tried Users and Permissions but it didn't work


texts: CiviCRM sending all emails EXCEPT from CiviMail

texts:
daniel-strum
8:08 PM

Maybe someone can point me in a direction to look... I posted this last night on MatterMost and got a few replies but I'm still stuck.

I have an Drupal7 Civi 4.7.17 instance that will not send email from CiviMail. I started with the Sparkpost (com.cividesk.email.sparkpost) extension and that worked about 3 months ago when I set it up. The client then just disappeared till now. Sending test emails from the setup screen for Sparkpost works as does sending emails from a contact's record and even donation receipts work. I have also tried switching to a simple SMTP setup and even sendmail. All work in all cases except when using the CiviMail (bulk email) interface. Even "Send a Test" to an a contact or a group in CiviMail just does not work. It says it was sent and even the mail report says it was sent. No errors in Drupal's watchdog. If I uncomment the "send the email to a log" line in civicrm.settings.php, I see all emails in the log except any that are created from the CiviMail interface. It does not seem to be generating any errors that I can find in ConfigAndLog > xxx.log. Any ideas?

Thanks


texts:
Is there a way to explore the API from the command line instead of going to mycivicrmsite.localhost/civicrm/api in a web browser?

I wasn't able to learn much from the cv help.  For example, you can cv api contact.get... but what else can you cv api contact.do?

I know I can just go over to the web browser and pull up that page, but I just wanna hang out in my terminal :)


texts: Unable to take Credit Card payment via PayPal after civi update

texts:
Normally take credit card payments via civi with no problems - update to 5.10.0 and since then have been unable to take CC payment - error message staing 'Date Received is a required field.'

Process to replicate

Go to a contact (Member) -select payment tab - click Submit Credit Card Payment - Select Membership dues - enter amount - ignore Campaign - complete rest and click submit -error saying Date Received is a required field.

This happens whether send receipt is ticked or not and even though all dates are completed.

joomla 3.9.2 - Civicrm 5.10.0


texts:
Using 4.7.x.  I am trying to create a membership type where an Organization is the member.  How do I do that?  I see some references from a few years ago on the forum about selecting what contact type it's for, but I don't see that option for that in creating a membership type.

Obviously, a real person (contact) is going to do the actual signing up.  Hopefully that person and other employees of the organization will inherit membership privileges.

Is all of this doable?


texts: How to target record id for multiple record custom field set in Webfom?

texts:
Drupal 7.40
Webform-Civi Integration 7.x-4.13

Similar to Graham's question here.

Use case:
Setting up goal plans that look like this:
Long-Term Goal 1
  Short-Term Goal A
  Short-Term Goal B
  Short-Term Goal C
Long-Term Goal 2
  Short-Term Goal A
  Short-Term Goal B
  Short-Term Goal C
Long-Term Goal 3
  Short-Term Goal A
  Short-Term Goal B
  Short-Term Goal C

etc.

I've created a custom field set that allows multiple records.
Each record contains:
Long-Term Goal
Short-Term Goal A
Short-Term Goal B
Short-Term Goal C

We have a View that lists the goal plans with a link to edit the goal plan profile.  However, it is large and confusing for the end user.

I'd like to create a Webform that targets each individual record not all of them.

Custom fields have ids in their tables, but I can't see a way to implement them in Views or Webform.

I believe I could expose it to Views but even if I can, is there any way for Webform to use the record id?


texts: Problem with Advanced Search and Search Builder

texts:
We are using Civi (version 4.6.3) primarily as a case management tool.

In Advanced Search, when I try to create a query with more than one Custom Field Set used for two different Case Activities, the search falsely returns no results.

I recreated the error in demo -- I created two new custom fields to extend two different Case Activities for Housing Support Case Type :
1. Activity: Secure Temporary Housing
   Custom Field Set: case-housing1-test
   Field: Housing Status (dropdown select options:Temporary Housing, Homeless)
2. Activity: Long-term Housing Plan
   Custom Field Set: case-housing2-test
   Field: Is long term plan complete? (yes or no)
I created a new contact: Joe Jack, and then created a Housing Support Case for him. In Secure temporary housing activity, Housing Status, I selected "Homeless". In Long-term housing plan activity, I selected "yes" to the question "Is long term plan complete?" .
Now if you go to Advanced Search and do a search for Activities, housing status - Homeless, long term plan complete - yes,  the search returns no records. If you do a search for housing status - homeless, you get Joe Jack.  If you do a search for long term plan complete - yes, you get Joe Jack.  But if you do a search for both you get nothing.

I believe the reason for this is that it doesn't recognize that the two activities belong to the same case. I was able to pull the correct results in a custom report I created by creating a view  for each activity type and joining them in a SQL statement on case id.

Also,this is a separate issue, in Search Builder, when I search a custom field used for Activities where field IS NULL , it returns all records where that field IS NOT NULL but the value in the column shows the field is empty.

 If I do the same search but instead ask for records where field IS NOT NULL, it returns all the same records but this time the actual value is displayed in the column.

This is also true for is empty, is not empty.


texts: Update to WP 4.3 Broke CiviCRM Dashboard in CiviCRM 4.6.8

texts:
I just updated my Wordpress site to WP 4.3 and updated CiviCRM to 4.6.8. Now my CiviCRM Dashboard is being "polluted" with widget content destined for other parts of the main site.(see screen capture) It only happens when a "dashlet" has been dragged into place, but without dashlets, the dashboard is kind of useless. I tried clearing Civi's caches via the Admin menu, with no luck there. I'm hoping I don't have to go hunting for a new WP Theme, but I know that WP 4.3 made big changes in the theme widgets and customization user experience, so I'm worried.

Anybody else experiencing this? Any advice?


texts:
For the contact field Communication Preferences> Privacy

How difficult would it be to add a new option "Do Not Voicemail"

One of our clients is a counselling service. So this would be useful for them.

They have a stopgap solution usign other custom data fields- but this is in a separate section of the record to the communications info.

What is the process for making requests for this kind of amendment in core?

Is anyone able to pitch a rough cost?

Would this feature be useful to anyone else?

If I can get the client's approval I can look at the Make It Happen process.


texts: Webform CiviCRM contribution "other amount"

texts: I've setup a webform with CiviCRM integration that ties back to a Contribution page. This creates a "Contribution Amount" field in the form that I've populated with a number of user selectable options that have assigned dollar amounts. I'd also like for there to be an "other amounts" option that allows the donor to type in a custom amount, just like in the standard CiviCRM contribution page options. I don't see such an option in the Webform settings. Can anyone advise how this is accomplished?


texts: Custom Search with No Input Parameters just Results

texts: I'd like to create a custom search that goes directly to the results page, without asking the user for input parameters (the WHERE clause is hard-coded, no need for inputs). How can I do this?


texts: Link to User record, via View Contact -> Actions -> User Record gives Page Not Found (404). Is this a bug?

texts:
We are running CiviCRM 4.7.23 + Drupal 7.56.

If we try and access one of our Drupal User Records via the CiviCRM Contact record (View Contact -> Actions -> User Record) we get a 404 "Page not found" error from Drupal.

In trying to debug this, we've noticed that the URL generated by the "User Record" link in CiviCRM is like this:

http://oursite.org/user/XXXX&cid=YYY

Where XXXX is the Drupal User ID and YYY is the CiviCRM Contact ID.  If I strip off the &cid=YYY part from the URL, the link works and takes me to the correct User Record.

So, is this a bug, or is our site misconfigured somehow?


texts: Call to undefined function getRequiredMarker() - CiViCRM

texts:
I have setup CiViCRM with Drupal. Setup was completed successfully without any errors.

After Login into Drupal as Admin, while I'm visiting new event create page  using menu -> Events -> New Event, I got blank page nothing else.

When I checked the error log it says:

PHP Fatal error:  Call to undefined function getRequiredMarker() in /var/www/html/xx-civicrm/sites/default/files/civicrm/templates_c/en_US/%%89/896/89673E6E%%ProfileTemplates.tpl.php on line 64, referer: http://xxxxxxx.com/civicrm?reset=1

But I found that function "getRequiredMarker()" in a js file:

/sites/all/modules/civicrm/js/view/crm.designer.js

So what is the issue here? What is the solution here?

Any help would be appreciated. Thanks.


texts:
I have created a template that I am going to send to a group of people. Depending on a certain value (in this case a custom field), I want to use a different picture.

Today I create four different templates.

Is there a way to "merge" content in a template based on another field value?

And is it a generic way of doing this, if I next time want to merge different sentences, based on the same field values I used for the pictures?

(I have looked at the extension Content Tokens, but this is slightly different)


texts: Contact SubTypes and Display Preferences

texts:
I'm really trying to utilize the core CiviCRM for my custom purposes by using the tools provided.  I need to have a database of dogs with specific custom fields, that are related to an owner (Contact).
I have tried adding custom fields to the Contact, and add multiple lines for dogs for the contact (Contacts can have more than one dog) but it hasn't been working as well as I would want.
I created a subType called Dogs based on Individual.  My idea was to create the Dog record, then set up a relationship with the owner/Contact.  However, since I do not actually use any of the core fields or groups for Dogs, how can I have custom Display Properties so it only shows the related Custom Fields?
Is this done using the templates?  If so, is there an example someplace that shows this?

Thanks!
Norm


texts: Can my extension know when other extensions become enabled or disabled?

texts:
My extension makes reports based on the Civisualize extension. I'd like to make dashlets out of the reports, but I only want it to be available when Civisualize is also enabled.

It's easy to see if Civisualize is already enabled when my extension becomes enabled, but I don't see a way to find out when Civisualize becomes enabled or disabled after my extension has become active.

My extension does not depend on Civisualize, it works perfectly without, but it only gives some extra nice reports.

So I would like to use some kind of hook_extension_enabled which will be fired when other extensions become enabled so I can add my dashlets to the system when Civisualize becomes active and remove the dashlets when it gets inactive.


texts: ACL permissions still broken after 4.6.8 upgrade

texts:
I was running 4.6.6 and noticed I was unable to access some of the settings for an event. I then noticed I didn't have permission to get to other areas of CiviCRM, this in spite of having full admin access.

I saw the bulletin regarding 4.6.6 breaking ACL permissions, so I just upgraded to 4.6.8, but the permissions are still broken - I can't get into any of the administrative functions of CiviCRM at all, and I'm kind of freaking out. As usual, this couldn't have happened at a worse possible time - we have our National Convention in less than 30 days and I desperately need to make changes to my event settings and price sets.

We're running Drupal 7.3.8 and Civi 4.6.8. We have 50 states set up with content access control controlled by smart groups based on state. Any help anyone can provide is greatly appreciated!


texts: How to redirect after successful newsletter subscription

texts:
After a user signs up to receive newsletters (using the profile coming from CiviCRM/CiviMail), they receive a confirmation email. Upon clicking on the confirmation link in that email, they are taken to a Confirmation page which says that they have successfully been subscribed to the X mailing list. The content of that Confirmation page comes from the /civicrm/templates/CRM/Mailing/Page/Confirm.tpl.

What I need to do is one of the following. Either of these options would work for me:
1) Run php code in the Confirm.tpl file. This would allow me to dynamically load some additional content and present it to the user. I'm not sure about the possibility of this because I know inserting php in Smarty has been deprecated.
2) Redirect to a separate page and present to the user that page instead of the content coming from Confirm.tpl. In that separate page I would then be able to run my php and load content dynamically.

I am running Wordpress 4.4 and CiviCRM 4.6.8.


texts: What is the minimum PHP version for CiviVolunteer?

texts:
Some screens for CiviVolunteer on PHP 5.3.x - e.g.
/civicrm/volunteer/loghours?reset=1&action=add&vid=2&snippet=json
produce a 500 Error (pop up text: 'Network' error; please refresh and try again).

[13-Apr-2016 08:43:08] PHP Fatal error:  Cannot access self:: when no class scope is active in .../org.civicrm.volunteer/CRM/Volunteer/Permission.php on line 68

On PHP 5.6.x all is well. So we'll upgrade this site - just posting this question here for others running into 'Network' errors.


texts: is it possible to switch languages on a page manually?

texts: I have a Civi install that needs to support multiple languages for a few forms. The site itself is not multilingual, so I've not enabled the option to inherit the CMS language, and the language-switching should be available to anonymous users, so I can't make use of the language preference field. I'd like to be able to allow the visitor to switch the language dynamically -- presumably with a URL parameter. Is there a way to do this?


texts:
When I go to Contributions and click "View", I always got an error "Erreur réseau. Impossible de joindre le serveur" ("Network error. Cannot join the server" - in english).

I can't find any error in logs...

I run CiviCRM 4.6.6 under Wordpress 4.3.1. But got the same error with updated versions of both on another server.

Any idea ?

Thanks !


texts: We want members to sign up and either auto-renew (it's free) or be lifetime members so there is no expiration date.  Which is the best approach?


texts:
I just succesfully installed CiviCRM on our website (WordPress), I created a new DB but was not given the option to specify it during the installation process.  It seems to have installed in a DB that was already there xxxxx_demodb in which I can now see all the civicrm_xxxx tables, along with a handful of tables that look like they belong to WordPress, listed here:

wp_commentmeta, wp_comments, wp_links, wp_options, wp_postmeta, wp_posts,
wp_termmeta, wp_terms, wp_term_relationships, wp_term_taxonomy,
wp_usermeta, wp_users.

Can somenoe pls confirm if these are WP or CiviCRMtables, and/or advise on how I can move the tables into a new DB and what config/ini things will need to be updated to make this work.

Or just create a whole (or use the empty one I already created) new fresh standalone DB, I have only made minor changes to the settings that I can just redo...

Thanks, Joe.


texts: On multi-site CiviCRM, are mailings supposed to be separated per-domain?

texts: According to the CiviCRM wiki here, under "Functional Separation in Multisite", mailings are listed as separated by domain.  However, when my users access the "Scheduled and Sent Mailings", they see mailings from all domains.  I know that civicrm_mailing has a field domain_id.  Is there something I need to do to enforce this separation?  Or am I just misreading the wiki?


texts: Smart Groups - cannot get smart groups to refresh

texts:
I have read as much as I can about smart groups but I am having problems that I am not able to solve. I have a smart group which shows the same SQL as an Advanced Search but they produce different results.

If I refresh the smart group cache I get the same result.


texts: not of type Boolean error message when testing Stripe in Test Mode

texts:
I am getting the following error message when testing Stripe recurring membership dues in test mode:

  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.

  One of parameters (value: ) is not of the type Boolean

any help with how to fix this would be greatly appreciated,
best regards,
David


texts: I want full documentation of civix tool for creating civicrm extension. I already saw a document on github. I need more information about civix.


texts: How to fix transaction mistakes in CiviEvent & CiviContribute

texts:
In CiviEvent, had a user that mistook chargeback for refund then using the Line Item Edit extension made more mistakes. The result is that for one event payee shows $500 refund more than correct. Upon looking at the transaction history I can see what happened but there is no user interaction to edit this area. Reading some other threads by Joe Murray states these are listed in two tables civicrm_entity_financial_trxnand civicrm_financial_trxn but it's not clear to me how to clear these entries.

He did say that any refunds or adjustments to registration activity should be done in CiviEvent and not CiviContribute. There should me a huge neon red banner that says that on the page or some restriction control on the contribution page with a notation to make any edits in the event. (See image)


texts: How to control API4 permissions for CRUD operations?

texts: How do I control permissions for API4 calls?


texts: problem installing civicrm on drupal 7 acquia on windows or linux LAMP.

texts:
Environment is window 7, drupal 7 using acquia dev desktop. Then tried on a linux box at home... LAMP...
Error messages vary from white screen with only a waiting for domain at the bottom of the screen followed by totally white screen.
On other machine in the background I can see a faint message: Warning post content lenth of 16273143 bytes exceeds the limit of 8388608 bytes in unknown line 0 Modules.
And finally on a linux LAMP box I get no file selected after I browse then select and when I hit the install button I get no file selected.

I can install other modules on all three of these machines running drupal 7.
I tried 4.7... 4.6.... what the heck?
Previous message below
Trying to install civicrm-4.6.28-drupal.tar.gz I found on the civicrm website... said it is the long term support version.
I saved the file to hard drive.  Open my admin menus, modules and there I click install new module link.  I then choose Upload a module or theme archive to install.

I select civicrm-4.6.28-drupal.tar.gz on my hard drive and click install.
   On the bottom it says, "waiting for sitename", and does nothing else except up on the tab of the browser it has the spinning thinking icon.

eventually goes to a white screen and i can find no errors... just doesn't work

I can install other modules easily.... frustrated....


texts: Anyone experience problem with Civi pop-up forms not working well with bootstrap themes?

texts:
I created a Barrio SASS subtheme and now all of my pop-up forms within Civi don't accept mouse clicks/scrolls properly.  I have to use tab keys to move and other keystrokes to edit drop-downs.
If I switch back to Bartik then all works well.
Ideas?


texts:
I'm trying to send out a mailing via CiviMail, and we have a link to the RSVP URL of our CiviCRM event.  However, whenever we've sent out the test emails, it seems that the URL is getting messed up by the included WYSIWYG: CKEditor.  This is the problem we are experiencing.  If you take a URL, say

http://example.com/index.php?option=com_civicrm&id=172&lang=en&reset=1&task=civicrm/event/register

It gets replaced with the following URL:

http://example.com/index.php?option=com_civicrm&amp;id=172&amp;lang=en&amp;reset=1&amp;task=civicrm/event/register

Now the difference isn't all that noticeable, but the &s get replaced with &amp;s.  I was able to find a workaround by editing the source of the email and replacing all of the &amp;s and not switching back to WYSIWYG view before sending it out.  However this a less-than-ideal, band-aid solution.  Does anyone have an idea of how to fix this issue?

note: I tried installing the TinyMCE CiviCRM extension, and that did not solve the problem, the URL's were still getting jumbled.


texts:
I am creating a wordpress based website with Civicrm. Now users can register by submitting a membership form and they will become member of a group called Free Members. FreeMembers can access a contribution form to make membership fee, after making the membership fee how can I include those members to a group named PaidMembers ?
I am using CiviCRM 4.4 on Wordpress latest version.


texts: How to have one custom field open one or more other fields in a frontend form?

texts:
I need to have a checkbox or yes/no radio field that opens 'Preferred Language field when value=1 or affirmative choice. How is this done?
A more exact use-case: To choose Language Interpretation:
Custom Field: Language Interpretation (Please choose): Yes | No

If No, then nothing further appears, move to next step in process flow.
If Yes, then Preferred Language menu (system field) appears to choose language and that entry is amended to Contact record.


texts: How can I add PHP as content with HTML editor?

texts:
Using Drupal 7 with CIVI crm 5.x

I'm doing some testing with this:

 Hello World'; ?>

Paste it in source code, but then it strips it out like this:

Hello World

With Drupal I can tweak things so this can work, but how do I do it with CIVI CRM or it is even possible?


texts: How do I get my menus back after my host moved my domain to another server?

texts:
My host moved my Wordpress sites to another server without regard for my civicrm implementation, in the process they changed the directory path for the website also. I have got the site working again by updating the civicrm.settings.php with the new path settings, and the public site is working again (and seems to be able to process donations also).
But the civicrm menus are not displaying on the back end at all. I can administer the civicrm settings by following links from the admin dashboard and have cleared the caches, updated directories and checked Resource URLs.
The implementation was at 5.22.0 at migration, I have upgraded now to 5.26.2 hoping that would fix the issue but it hasn't.
How do I get my civicrm menus back?


texts: Add custom field and populated with array/data from a non-civicrm table

texts:
newby here with a quick question about custom fields.
Is it possible to set up a custom field that queries a non-civicrm table?
Hoping to create an autocomplete dropdown menu that does a SELECT on a legacy table we have.
Am I looking in the right direction when I browse this page:
https://wiki.civicrm.org/confluence/display/CRMDOC/hook_civicrm_custom
?

Thank you so much!
johnnyeng


texts:
I can only get scheduled jobs to run manually, with the "Execute now" button.   Hourly won't work let alone with an external method like php.cli method.    Is there a way to troubleshoot this?   I just started logging civi errors to drupal watchdog....so hopefully I'll have more info soon.

Thank you


texts: Contribution import fails for all records with error "No matching Contact found"

texts:
I successfully imported contributions from csv files, up to 4.6.3.  Now when I try to import using the same saved mapping, in Joomla with 4.6.6, every record fails with the error

No matching Contact found for (person@example.com )

Is anyone else having trouble under 4.6.6?  My field mappings look correct, and the contact email addresses do exist as contacts in the database.


texts: CiviCRM Error - type E_ERROR was caused in line 550

texts:
I've got a wordpress site using CiviCRM and recently got an alert email indicating a technical issue identified on the site. Error details is listed below. I've googled for similar issues but went nowhere. Wondering if anyone has come across this or similar ? Any advice will be much appreciated.

Error Details

An error of type E_ERROR was caused in line 550 of the file /public_html/wp-content/plugins/civicrm/civicrm/vendor/symfony/filesystem/Filesystem.php.
Error message: Uncaught Symfony\Component\Filesystem\Exception\IOException: A temporary file could not be created. in /public_html/wp-content/plugins/civicrm/civicrm/vendor/symfony/filesystem/Filesystem.php:550
Stack trace:
#0 /public_html/wp-content/plugins/civicrm/civicrm/vendor/symfony/filesystem/Filesystem.php(598): Symfony\Component\Filesystem\Filesystem->tempnam('/home/...', 'CachedCiviConta...')
#1 /public_html/wp-content/plugins/civicrm/civicrm/vendor/symfony/config/ResourceCheckerConfigCache.php(138): Symfony\Component\Filesystem\Filesystem->dumpFile('/home/...', '


texts: How can I find out how many individuals are inputted onto our civi system

texts: I need to know how many families and individuals we work with each year. How can civi tell me these figures?


texts: How can I find membership totals on a month by month basis eg. total members end of Jan, Feb ect so i can then analyse the increase month by month?

texts: I have found how to get Civi to show me how many new members of each type joined per month. However I need the total of all members at the end of January Feb etc so I can see if there is an increase in members and of which type.


texts:
This seems to have been an issue before.
Formatting tags shown in activity view
Has this been resolved because I am still having an issue with this. I am not on the current version.
If there has not been a fix for this - is there a work around?
CivicCRM: 4.7.2
Drupal: 7.43

Thank you
Casey


texts: Advice on moving CiviCRM Configuration only when launching a new site

texts:
Can anyone shed some light on the best way to move CiviCRM settings only when launching a new site.

Essentially we want to be able to launch our Drupal 7 CiviCRM 4.6.9 (as of today) like a one click install. We work with specific clients from similar industries who usually have a similar requirements.

For example, we create 3 profile types, turn off 3 components for CiviCRM, Add the tax rate,create a responsive email template and setup the look and feel for events using a custom template.

Is it as simple as setting this up on a test site and copying the civicrm.settings files to the new site each time? or is there a better way to do this and not having to update the Resource URLs each time and the views configuration.

Thanks.


texts:
I need to be able to add the ability to do e-checks via Authorize.net. But it appears the only extension that was available for this says it shouldn't be used because it messed with a core CiviCRM file. So how are people doing this?

Edit: The previous answer is not an option. That page is from 2016 and the information is apparently from back when there was an extension. Without an extension connecting CiviCRM and Authorize.net, the solution there won't work. It's just an Authorize.net reseller. They don't provide extensions and such. So we're still looking for a solution. Or an estimate as to the cost to get the old extension working so that we can crowd fund it?


texts: Does Webform CiviCRM event registration respect the "Registration End Date" setting?

texts:
CiviCRM events can have a "Registration End Date" (and start date, for that matter):

Is the following setting on CiviCRM Webform (under CiviCRM > Event Registration > Registration Options) meant to take this Registration Start/End Date into account, or is it only checking the Event End Date?


texts: Block locations for events and check conflicting location bookings

texts:
Is it possible in CiviEvent to prevent a location from being booked? Such as:

location isn't available
location is already booked for a different event
holidays

Would it also be possible to notify the users of this?


texts: How to disable State/Province in billing address blocks

texts:
In the UK, the list of counties provided by Civicrm (and by the ISO) is mysterious to say the least to most UK dwellers. Many people think they live in a county which changed to something else years ago!

So, afaik it's best not to use counties in addresses with drop-down options - such as billing fields.

Therefore, how can one disable state/county in a billing address block? Or at least make it not required?

We use Authorize.net for most UK transactions.

Thanks for your help!

Drupal 7.56, Civi 4.7.22

PS - I see this: https://issues.civicrm.org/jira/browse/CRM-19688
But I don't think it helps in this situation?