texts: Bulk update relationships to household members

texts:
We have household memberships. Ive noticed that some households are missing a relation to a residential community that they reside in. This community is common to those households. I tried to select all those contacts and use a profile to batch update but it wont let me make a profile for relationships to households?

Is there a way to do this.

Ie:

Mary Smith
Jane Doe
Trevor ward
Leon Jones

they all live at Smithtown Residential Resort (this is a relationship called residential community)

I want to select the records then tell Civi all these household contacts belong to the residential community


texts: Cron for all jobs not firing under 4.7.1

texts:
This was working through 4.6.10 flawlessly on Joomla 3.4.8 and PHP 5.4.x. Under 4.7.1 it is not. Nothing has changed. The cronjob continues to fire in the server and there are no errors in any of the general logs plus CiviCRM logs (../media/civicrm/ConfigAndLogs)
Please advise.

Here is the cronjob:

nice -n19 /usr/local/bin/php /home/test/public_html/administrator/components/com_civicrm/civicrm/bin/cli.php -j -s <domain> -u <user> -p <password> -e Job -a execute


texts: I've seen Apple Pay on CiviCRM contribution pages before, but I don't know how to go about setting it up.  Does anyone know how it's done?


texts:
I am running a fresh site CiviCRM with Drupal. I am very new to CiviCRM and Drupal too.. I am in need up building an intranet CRM application that can look like a professional CRM applications. I am very much glad with the functionalities that CiviCRM provides. However as per the look and feel, I wanted to make it more intuitive for the users. My questions are:

Can I enhance the look and feel of CiviCRM aesthetically?
If yes, what are the means and ways to do it.
Please advise the best recommended way.
Guide me to some of the videos that can teach how to achieve this.

Thank You.


texts: can't delete Event Registration - web page hangs with spinning logo

texts:
I am trying to delete several event registrations from an event, but each time I try with any of the contacts it fails. I get a pop-up warning that any corresponding payment transactions will be deleted and I click the tick/delete button but then I just get the spinning Civi logo and the webpage hangs like that.

The event registrations were created using a webform registering multiple people (parent and children) for the event at once. I turned on logging errors to the Drupal logs but there is nothing appearing there. When I refresh the webpage the participant listing is the same as before.

I can edit the participants and change their status to cancelled but cannot delete the registration. We're on Civi 4.6.5 and Drupal 7 with CiviHosting.

EDIT: I get this error message following @petednz advice:

Fatal error: Class name must be a valid object or a string in /home/../www/www/includes/common.inc on line 7963

Line 7963 is in bold below:

/**
 * Gets the entity controller for an entity type.
 *
 * @return DrupalEntityControllerInterface
 *   The entity controller object for the specified entity type.
 */
function entity_get_controller($entity_type) {
  $controllers = &drupal_static(FUNCTION, array());
  if (!isset($controllers[$entity_type])) {
    $type_info = entity_get_info($entity_type);
    $class = $type_info['controller class'];
    $controllers[$entity_type] = new $class($entity_type);
  }
  return $controllers[$entity_type];
}

This Drupal post is another recent user with error at the same line but different situation:

Viewing entity results in Fatal error: Class name must be a valid object or a string


texts: I have input around 1000 contacts from a specific country. Most of these are already in groups. I want to create a group for contacts from that country that are not yet in a group. How can I do that? I could not find a way to search for them.


texts: Cron ERROR: Invalid username and/or password (Wordpress)

texts:
Our cron has worked without issue then all of a sudden it stopped and provided the error: Civi 5.23.3 WP 5.3

When the cron runs - I get the following:
ERROR: Invalid username and/or password

My cron is as follows:
/usr/local/bin/php.cli -q /home/tarabnyc/www/www/wp-content/plugins/civicrm/civicrm/bin/cli.php -u username -p password -e Job -a execute


texts: What's the problem with this state province crash?

texts:
I migrated at the weekend from 4.6.22 to 4.7.19 and all went smoothly. But now users get the following problem when updating a contact's address. They get 'Unable to reach network' but looking in ConfigandLog I see this line prior to the fatal error:    /home/rsvpadmi/public_html/sites/all/modules/civicrm/CRM/Utils/Geocode/Google.php(87): CRM_Core_DAO::getFieldValue("CRM_Core_DAO_StateProvince", "null")

I 'fixed' the problem by switching off Google maps in 'Mapping and Geocoding'. In fact, maps were being displayed OK but users just couldn't update an address.
Anyone have any clues as to what the problem is?


texts: Webform CiviCRM: Issue with Membership Options Not Displaying

texts:
(This has been replicated both on a Civi 4.6.19/Drupal 7.50 site and a Civi 4.4.6/Drupal 7.37 site, with the following versions of Civi Webform 7.x: 4.10, 4.14, 4.15)

We have a webform connected to a contribution page with membership options - not a priceset, just selected membership options from the membership types stored in Civi.  The membership options are not showing up on the payment page, as seen below so the user cannot make a selection of membership type.  Is this standard Civi webform behavior?  If not, is there some setting or permission issue that we can modify?


texts:
I'm wrestling with where and how to best make modifications to the CiviMail new mailing form, built with Angular. There are several other questions addressing this in part, but none address my needs completely.

The customization is pretty simple: include the logged in user's email as an option in the From Address selector and set it as the default.

What I've found is that:

1) I can't simply modify the from address list using the optionValues() hook. There are some oddities with from_email_addresses passed to that hook -- not all of the values are passed for modification. And because the select2 widget in the angular form is set to filter on is_active, any values I add via the hook are ignored (the hook only let's me work with the basic option list; I have no access to other record metadata).

2) Even if I use a php override of the CRM/Mailing/Info.php file and alter the from address values passed to angular, the default value is being set in some mystery way that I've not been able to find. Altering the is_default value and weight so that my desired option is the default has no impact.

3) In general, it seems very difficult to target angular forms via a hook in order to inject js. Maybe I'm missing something obvious, but the pageRun() hook doesn't seem to give me enough to be able to condition the injection of js adequately.

Any tips would be much appreciated.


texts: Should the API return code always be 200?

texts:
The Civicrm API seems to always return 200 (aka 'Success') even when there is an error (in the parameters of the request, or otherwise). To indicate an error, it instead sets the 'is_error' flag to '1' in the response.

This is fine, but is there a reason why it wouldn't set a more appropriate error code depending on the case (i.e. a 400 'Bad Request' code for malformed requests)? For example, when using a javascript http client and making an ajax API request it would allow use of default error handlers (function to call on success, function to call on fail).


texts: Members still have "new" status, after over a year and a half

texts:
Member rules dictate that members are "new" from start date to 3 months after start date. Nearly all the members in our database (4000+) are still marked as new. In fact, everyone is considered new unless they were cancelled by us by hand.

I have changed the rule so that members are only new for one month instead of three. What could be causing this issue? Cron is running. How do I fix and update user status?

The biggest problem with this is that we are a non-profit organization, and users aren't renewing their memberships because they are marked as status "new" even if their memberships expired a long time ago.

CiviCRM 4.7.15 Drupal 7.x


texts: Check sums clicks - can they be measured

texts:
Can I know how many people clicked on their checksum link to a webform?

I understand it can't work the same as other links as in a 10000 Strong mailing there would be 10000 links. I'm trying to see how many people who click on the webform complete it.

Thanks


texts: We are configuring our CiviCRM instance to work with iATS Payments. When setting up an iATS Payments Processor, there are a number of Payment Processor Types. Our initial configuration with WordPress 4.6.1 + CiviCRM 4.7.12 works with Payment Processor Type = "iATS Payments Credit Card". For live events, where we have a tablet handy we would like to set up contribution pages using Payment Processor Type = "iATS Payments SWIPE." Has anyone else done this? Also, iATS has two types of credit card swipers - a USB encrypted card reader, which appears to be what the processor is designed for click here, and another one which plugs into apple and android phone jacks, like the more popular Square card reader. If anyone is using iATS Payments SWIPE, what is your experience at live events? What is the hardware you use: laptop, tablet, phone, ...? and USB card reader or phone-jack reader?


texts: How to assign the access civiMember permission

texts:
I would like to use civimember.
I clicked the membership tab, but nothing opened.
No add membership appeared.
Do I need to assign the access CiviMember permission? And how do I manage to assign?


texts: Cron Wordpress 4.7.14 - will not send scheduled emails

texts:
I schedule a job through mailings.  The Cron job looks like it picks it up, and the mailing is marked as running, but it never gets sent out until someone manually runs scheduled jobs (administer>system>scheduled jobs).
The process is running every 15 minutes on schedule, the jobs logs, has two entries at the time it should pick up the scheduled job.
The first just has the time/date and
Summary
Starting scheduled jobs execution
the second has the date/time the jo
Entity: Job Action: process_mailing
Summary
Starting execution of test job schedled -
Details
Parameters parsed (and passed to API method):
a:1:{s:7:"version";i:3;}
Full message:
Starting execution of test job schedled
but once it picks up a scheduled job it never completes, it will just generating the starting execution message.  Also as a result of this I get the system message that Cron is not running after a bit.   I've tried Civihosting support and they said to post it here.


texts: Civimail 4.6.2 on Drupal 7.36 creating multiple drafts while editing

texts:
We recently upgraded from CiviCRM 4.5.8 to 4.6.2 and this is our first shot with the new interface.  We're just at the compose stage but what we've run into so far:

Multiple copies of the draft appear to be created as you're editing.  In some of those copies it will say "place holder" in the Mailing Name column while others have the correct Mailing Name.
Once you've backed out of the editor (either from a freeze as we've had with IE or you just intend to come back later to finish it up), the Status column shows "Complete" and the Scheduled/Started/Completed columns now have timestamps.  Nothing has been sent and if you click on the Report link it shows all "0" even though while editing there was a number for the estimated recipients.
Even though the Status shows as Complete versus Not scheduled as it would back in 4.5.8, these draft mailings show up for both Mailing Status of Draft/Unscheduled as well as Complete.

At this point we've seen this from a client using Windows 7 and IE while I'm using Chrome on Linux.  Using the same Chrome/Linux combo I was able to get a mailing composed and sent using CiviCRM 4.6.2 on a WordPress site.

I just put in the define('CIVICRM_CIVIMAIL_UI_LEGACY',1); setting into the civicrm.settings.php file to get this mailing out but can revert back for some testing.


texts: How to force email address to be a unique identifier?

texts:
We're using Civi 4.7 in WordPress, making make use of organisations and individuals and new individuals get a WordPress login (synced).

It comes unstuck periodically when an administration uses a person's email (someone@domain.com) for an organisation contact, but then tries to use the same email address as their personal (employee) record.

The first time the record is created a WP user is created and attached, having the matching email address. When the individual record is subsequently setup there's nothing preventing (or warning) the admin NOT to use the same email, but a new WP account is not created or linked because WP will not allow two users with the same email address.

What usually then happens is that the admin will remove the offending email address from the organisation record and pop it into the individual record, expecting everything to link up. Naturally it doesn't so the next step is someone then tries to fix it by deleting the WP user and/or the organisation record. Chaos ensues.

Can I prevent an admin or member from entering an email address into a contact when that email is already in use elsewhere?

If an email is moved between records as described above, is it possible to re-link the wordpress user to the new record? I couldn't find any way to do this short of hacking away at the database.

All advice welcome!


texts: Is there a Gift Aid (UK) extension compatible with 4.6+?

texts:
There are several GiftAid extensions (ones I've found linked to below) for CiviCRM but I am having difficulty finding any that claim support for version 4.6+ and posts on many of them seem to be a few years out of date.

Is anybody using a Gift Aid extension they can recommend?

The two I've found are:
http://www.compucorp.co.uk/blog/civicrm-gift-aid-instructions-v43
https://civicrm.org/blogs/rajesh/civigiftaid-extension

Thanks in advance for any suggestions anyone can provide!


texts: Following a CiviCRM checksum link doesn't populate civicrm tokens but logging in populates the tokens.

texts:
Example use case:

You want to link a user to a page and populate some information about them (e.g. display an online membership card):

[current-user:civicrm-contact:display-name]
[current-user:civicrm-contact:custom-122]

These tokens do not populate following a checksum link but do populate when the user logs in.  Is there an easy way to make the checksum link behave in the same way as logging in for the purpose of these tokens?


texts: Problems with editing recipient groups of CiviMail

texts:
Sometimes I cannot remove a group from recipient list of a Mailing. This can happen for instance when I re-use a mailing, but I want to change the group – I can add a new one, but clicking "x" on the old one just triggers "Estimating" label for a while and does not do anything.

Here I cannot remove "Replay" group:

After clicking "Next>", I see the recipient group appearing several times (see attached pictures).

How can I debug this? I wasn't able to reproduce this on demo.civicrm.org.

I'm using CiviCRM 4.6.4 with CiviMail 1.0.

edit:
I have done some more tests with CiviCRM 4.6.5, where this bug persists.

As I click through all the "new mailing" fields, there are numerous AJAX calls to https://apps.akcjademokracja.pl/crm/civicrm/ajax/rest with entity=Mailing, action=create API call, with json similar to:

"{"id":"23","domain_id":"1","header_id":"1","footer_id":"2","reply_id":"8","unsubscribe_id":"5","resubscribe_id":"6","optout_id":"7","mailing_type":"standalone","from_name":"Akcja+Demokracja","from_email":"kontakt@akcjademokracja.pl","url_tracking":"1","forward_replies":"0","auto_responder":"0","open_tracking":"1","override_verp":"1","created_id":"2","created_date":"2015-08-04+13:22:01","scheduled_date":"2015-08-04+13:22:00","approver_id":"2","approval_date":"2015-08-04+13:22:01","is_archived":"0","visibility":"Public+Pages","dedupe_email":"0","email_selection_method":"automatic","is_error":0,"jobs":{},"groups":{"include":[6],"exclude":[],"base":[]},"mailings":{"include":[],"exclude":[]},"name":"placeholder","subject":"placeholder","options":{"force_rollback":1},"api.mailing_job.create":1,"api.MailingRecipients.getcount":{"mailing_id":"$value.id"}}"

as you see, AJAX properly sets "groups":{"include":[6],"exclude":[],"base":[]} but in the database I see more and more civicrm_mailing_group entries:

mysql> select * from civicrm_mailing_group where mailing_id = 23 ;
+------+------------+------------+---------------+-----------+-----------+-------------+
| id   | mailing_id | group_type | entity_table  | entity_id | search_id | search_args |
+------+------------+------------+---------------+-----------+-----------+-------------+
| 5596 |         23 | include    | civicrm_group |         6 |      NULL | NULL        |
| 5597 |         23 | include    | civicrm_group |         6 |      NULL | NULL        |
| 5598 |         23 | include    | civicrm_group |         6 |      NULL | NULL        |
+------+------------+------------+---------------+-----------+-----------+-------------+
3 rows in set (0.00 sec)

Perhaps then, it's a civicrm schema issue – it should force Uniqueness in the table? Or is it rather a backend issue?


texts: How to change contribution pages profile labels into a placeholder?

texts: I would like to convert all the form fields labels of the contribution pages and events pages into placeholder. Is it possible to do? If yes, how please ? Thanks


texts: Integrating CiviMail tracked links with Google Analytics

texts:
I'm in the process of cleaning up our analytics tracking, and I've realised that one of the gaps we have is between the tracked links in our CiviMail mailings and Google Analytics.

The main thing we need to implement is to (remember to) use GA campaigns, but I also wanted to check whether there's anything I'm missing on the CiviCRM side.

One issue is that we have CiviCRM installed on a subdomain without any GA tracking - however, I'm not clear on why the CiviMail tracked links aren't registered by Google Analytics as referrals from the subdomain.

(It may be that there isn't anything I can about this from the CiviCRM and I just need to deal with it from the GA side - I'm happy to close the question if that's the case)


texts:
I am unable to upload images onto the server for my email newsletter. Will you please provide technical support?
Thank you.


texts: How to change the date on an exported batch

texts:
I have exported a batch but the date in the title is not correct, so I need to change the date on the name of the batch, however I cannot seem to re-open the batch. Please can you help.
Thanks in advance,
Grace


texts: Difference between 'active' and 'disabled'

texts: I have set up custom fields for an event. There are multiple choice check boxes for field trips during the event. Some of the trips have reached the max number of participants and I need to stop additional sign ups. Please clarify the difference between the 'active' check box setting and the 'disable' menu item for multiple choice items. I want to hide the option but retain all current option data.


texts: Is anyone creating tickets or printing bar codes from CiviCRM?

texts:
We would like to be able to store and print machine-readable codes (bar codes or QR codes).  We might print these on receipts for event registrations, to act as tickets, or on signin sheets or ID cards to track attendance at meetings, etc.

I saw a reference in an old question about this here on Stack Exchange, but nothing about it in the CiviCRM documentation.  Is someone offering an extension perhaps that does this?  Has anyone integrated CiviCRM with a code-generating Word-Press plugin?  Do you think it's possible?


texts: Can't seem to access Session values in module's API file

texts:
I can't seem to access session values on API definition. var_dump($_SESSION) returns an empty array event after putting session_start().

api/v3/MymoduleEntity.php

function civicrm_api3_mymodule_entity_method($params) {
  session_start();
  return var_dump($_SESSION); // Returns an empty array
  ...
}


texts: Is it possible to create tags from fields, where someone selecting a certain option tags them with that option. I.E. selecting the volunteer option tags the new contact as volunteer?


texts: Bug in Custom Searches - Date Added to CiviCRM

texts:
I'm fairly new to CiviCRM but have successfully imported over 3,100 contacts from our current PC based DB system. If an error occurs during the my imports I have found the Custom Search 'Date Added to CiviCRM' invaluable! However, when I try to exclude imported contacts that had been previously successfully grouped the search fails (returns nothing). The search is conducted on contacts that have all been imported on the same day which is also the current day.  Could it be that the group exclusion feature only works on prior day's work or is this a bug? I'm using version 4.7.10

Sincerely,
Mike Samyn - San Diego


texts:
How can I listen in JavaScript to the event of a country value change on the country select field?

both #select2-drop-mask and #select2-drop are not available until the user clicks to open the select.

and the hidden select #country-5 is not firing the change event as its values are set programatically.

This question was asked here but has a wrong answer.

Thank you


texts: How do I get CiviCRM Mailing to submit via the API

texts:
I would like to send a mailing every time a content item is published. The mailing is not being saved.

I have taken the sample code from

sites/all/modules/civicrm/api/v3/examples/Mailing/Create.php

Such as

$ht_node = $content['htnode'];
$the_subject = t('New Hot Topic Published: ' . $ht_node->title);

// Submit it now. No fussing.
$currentTime = new DateTime();
$approval_date = $currentTime->format('Y-m-d H:i:s');
$currentTime->add(new DateInterval('PT1H'));
$schedule_date = $currentTime->format('Y-m-d H:i:s');

$msg_params = array(
  'recipient' => 'Ecological Society Member',
  'htnode' => $ht_node
);
$content_templated = $this->themeEmail($content, $msg_params);

// drupal html_to_text leaves styles in place.
$text_no_style = preg_replace('|<style.*?</style>|mis', '', $content_templated);
$plain_text = drupal_html_to_text($text_no_style);

// see sites/all/modules/civicrm/api/v3/examples/Mailing/Create.php
// See query DataObject.php 1060
$params = array(
  'scheduled_date' => $schedule_date,
  'approver_id' => 21638,
  'approval_date' => $approval_date,
  'replyto_email' => self::REPLY_TO_EMAIL,
  'from_email' => self::REPLY_TO_EMAIL,
  'from_name' => self::FROM_NAME,
  'subject' => $the_subject,
  'body_html' => $content_templated,
  'body_text' => drupal_html_to_text($plain_text),
  'name' => $mailing_name,
  'created_id' => 21638, // Contact id of mailing creator
  'header_id' => '9',
  'footer_id' => '10',
  'groups' => array(
    'include' => array(
      '0' => $to_group,
    ),
  ),
  'mailings' => array(
    'include' => array(),
    'exclude' => array(),
  ),
  'options' => array(
    'force_rollback' => 1,
  ),
  'api.mailing_job.create' => 1,
  'api.MailingRecipients.get' => array(
    'mailing_id' => '$value.id',
    'api.contact.getvalue' => array(
      'return' => 'display_name',
    ),
    'api.email.getvalue' => array(
      'return' => 'email',
    ),
  ),
);

  // Throw error to the parent. Let the controller print out the error messages.
// Throws  CiviCRM_API3_Exception
civicrm_initialize();
$result = civicrm_api3('Mailing', 'create', $params);

if ($result['is_error'] === 1) {
  throw new Exception('Error in civicrm api mailing create: ' . $result['error_message']);
}

watchdog(HOTTOPICSNOTIFY_MODULE_NAME, '%mailing-name scheduled to be sent to group %groupid an e-mail. Mailing id is %mailing_id', array(
  '%mailing-name' => $mailing_name,
  '%groupid' => $to_group,
  '%mailing_id' => $result['id'],
));

I have run the debugger over it. The sql that is generated is fine - even inserts a mailing if I run it.

I can see no errors being returned, in Bao/Mailing.php it sees the scheduled_date and passes the _evil_bao_validator_ test. $transaction->commit() is run.

There is no sign of this call in the civicrm_mailing table or in the mailing screens.

How do I create and run this mailing?


texts:
I'm having a problem attaching files to activities.  I've done the basic checks (write permission to directories, Drupal permissions) .  I notice that the file gets placed in the Custom Files folder "[site root]\sites\default\files\civicrm\custom"

However, the process doesn't seem to finish, and the system hangs with the egg timer showing and ultimately i have to escape out of adding the activity, for the system to 'un-freeze'.

I'm feel it's just a small tweak somewhere but i'm getting stupped what the exact issue is, and my searches are not pulling up anything related to this.

Any help would be much appreciated.

UPDATE: when i right click new activity and attach the file i get the following error

  Sorry but we are not able to provide this at the moment. Could not
  move custom file to custom upload directory Uncaught
  CRM_Core_Exception: [0: Transaction integrity error: Expected to find
  active frame thrown in –

UPDATE 2:
 it looks like there is a 500 error;

  Failed to load resource: the server responded with a status of 500
  (Internal Server Error).

this is followed by another errror;

  Failed to clear temp storage: It was determined that certain files are
  unsafe for access within a Web application, or that too many calls are
  being made on file resources. SecurityError –

UPDATE #3
It looks like the ultimate cause of this problem is the issue with relative angular paths in windows CRM-16499.  I'm going to upgrade to 4.6.4 from 4.6.2 as this issues is fixed in the 4.6.4 version.

If it works i'll add an answer


texts: Where do I change the wording "membership fee total?"

texts: I'm already in the automated workflow templates, but I don't know which variable I need to tinker about with so that I change the wording. I have a recurring recertification, that I'm processing as a membership fee, but the client doesn't want the receipt to read "membership fee." So, what am I looking for? I'd like to simply call it Fee Total instead of Membership Fee Total.


texts: Trying to embed Address profile for Contacts to update

texts:
I created a profile that contains the logged in user's address only.  It is a simple form of only their address, nothing more.  I would like them to be able to update it on their own.  Unfortunately it is failing with an error in the php_error_log.  The error is:
[is_error] => 1
[error_message] => value: 000000 is not of the right field data type: Date
I'm not sure what date it is evaluating?  There is no date in the form.  Not sure why I can't get this to work?
Wordpress 5.6.1, CiviCRM 5.28.2
Thanks
Norm


texts: System Status Critical, blank System Status page

texts:
After upgrading to Civi 4.7.29 on WordPress 4.9.1, it says System Status Critical (see screenshot at the bottom of this post), but the status page is blank.

The developers console in Chrome has a lot of messages similar to this:

GET https://mysite.org/homepages/34/d1234578/htdocs/tcp-wp/wp-content/uploads/civicrm/ext/org.civicrm.shoreditch/css/bootstrap.css?r=sZzwI net::ERR_ABORTED

I found this suggesting changing directory permissions to 755,
which I did for /wp-content/uploads/civicrm/
but it doesn't seem to have helped.

After the upgrade, I got this warning, which may be significant. However, to me these two look like two ways of saying the same thing. However, I'm not sure what I might be looking for in the htaccess file.

There appears to be an inconsistency in the configuration of "Image Upload URL" and "Image Upload Directory".

imageUploadDir: /homepages/34/d12345678/htdocs/tcp-wp/wp-content/uploads/civicrm/persist/contribute/
imageUploadURL: http://mysite.org/homepages/34/d12345678/htdocs/tcp-wp/wp-content/uploads/civicrm/persist/contribute/
You may need to check that:

(a) the path and URL match,
(b) the httpd/htaccess policy allows requests for files inside this folder,
and (c) the web domain matches the normal web domain.
(Note: Although files should be readable, it is best if they are not listable or browseable.)

If this remains unresolved, then some important screens may fail to load.

==========================================

Tried updating resource URLs as suggested by fdarn.  Now when I click on CiviCRM on the WordPress dashboard, I get the screen shown below.  Clicking on "Configure Your Dashboard" doesn't seem to do anything.  Clicking on CiviCRM in the upper left takes me back (see red arrow below) to basically the same screen, but without that link.

Any suggestions or enlightening explanations of what's happening would be most welcome.


texts: We are trying to find out if we enter a contribution in a donor record, are you able to create a donor letter from a constituent record in CiviCRM?


texts: Paypal Pro IPN failures for non-recurring payments

texts:
We have a paypal pro setup for a contribution page and the ipn response for a normal contribution looks like -

  {"transaction_subject":"","payment_date":"16:37:45 Sep 02, 2018 PDT","txn_type":"web_accept","last_name":"xxxx","receipt_id":"2600-0803-0809-7320","residence_country":"US","item_name":"Online Contribution: Personal Membership","payment_gross":"35.00","mc_currency":"USD","business":"xxx@xxx.org","payment_type":"instant","protection_eligibility":"Ineligible","verify_sign":"xxxx","payer_status":"unverified","payer_email":"xxx@xxx.com","txn_id":"7F410221CJ172415V","quantity":"1","receiver_email":"xxx@xxxx.org","first_name":"xxxx","invoice":"89272b33abe6e127f59343e2a9b44a2c","payer_id":"9X46HRFGKLWH2","receiver_id":"R6MXHRC5VK3G8","item_number":"","payment_status":"Completed","payment_fee":"1.07","mc_fee":"1.07","mc_gross":"35.00","custom":"","charset":"windows-1252","notify_version":"3.9","ipn_track_id":"xxxxx"}

https://civicrm.stackexchange.com/a/17991/245 mentions that paypal pro ipn is only handled for recurring payments and others are simply ignored.

What seems incorrect to me is when an rp_invoice_id(not set for non-recurring payment) is missing in the response parameters, the payment processor is assumed to be of Paypal Express type and further handling is done with handlePaymentExpress function.

This function throws an exception when a payment is not of recurring type and hence sends a failed delivery status to paypal.

On the other side, civi contribution is completed and all works fine in the backend. It is just that paypal isn't getting a positive response for the ipn URL and hence the Paypal system send us a warning email re failed IPN calls about 2x/day.

Is this something missing in the code which incorrectly sets payment express for not seeing rp_invoice_id in the response? Should it also check for another param before deciding it as a paypal express transaction?

Update: CiviCRM version - 5.5.

Thanks.


texts: CiviMember price sets are depending on CiviContribute?

texts:
When only CiviMember is enabled as active component, setting new price sets (civicrm/admin/price) throws am DB syntax error.

When CiviContribute is also enabled, setting new prices works.

Since these are two distinct components, I consider this as a bug. Please advise.

I'm on the lates CiviCRM version of 5.9.1


texts: At some point within the past few upgrades (currently on 4.7.11) our quick search stopped working (i.e. you type a name, but the search doesn't yield results as you type) and we've no idea why. How would we even start to troubleshoot and/or resolve this issue?


texts: Command are running manually, but cron is not running

texts:
I'm running CiviCRM 5.32.0 on WordPress 5.6 hosted by Hostinger.
1st step I test cv.phar =
php /xzy/wp-content/plugins/civicrm/civicrm/bin/cv.phar api Job.process_mailing --user=abcd --cwd=/xyz
2nd step I test a script using that command with the same result OK =
bash civicron_2.sh
{
"is_error": 0,
"version": 3,
"count": 1,
"id": "processed",
"values": {
"processed": 0
}
}
3nd step, I created the cron rule in Hostinger panel (every 30 minutes) =
0,30 * * * *    /usr/bin/php /xyz/abcd/civicron_2.sh
But finaly CiviCRM UI says : "no cron job is running" and the only way I succed to run Job is manually on the CiviCRM UI.
I need advice to go further.
BR hervé


texts: Updating Custom Form Value via jQuery not Saving to Database

texts:
I have been charged with developing CivicCrm for my place of business.

The company I work for is a nonprofit and we help people with disabilities both mental and physical. The Department that deals with seniors needs to produce reports to certain agencies. As part of the reporting, a matrix must be filled out – This is a questionnaire.

I currently have all of the question fields created in sections/tabs under CivicCase. The matrix is grouped by questions.  For example a section entitled Income will have 4-5 questions based on Income. Depending on the yes or no answers a final field (#6) will need to be automatically populated. For example the questions are:

Does the household have income (both earned income and cash benefits)?
Is the household's income greater than or equal to 200% of Federal Poverty Guidelines?
Does the household show appropriate spending habits (Focus on meeting basic needs before purchasing luxuries, no unusually high costs, no spontaneous or inappropriate spending)
Does the household need assistance (Outside of own income) to meet basic needs?
Does the household have discretionary income and the ability to save?
Score:

So if 1 is answered yes you would continue to 2. If 2 were answered yes you would continue to 3.  If 3 was “no” then a score would need to be recorded in field #6 above and no further questions would be needed and the rest would need to be changed to no. There will be several sections that will be about employment, Housing, etc. that would need to be scored similarly.

I have currently been able to use JavaScript to change the fields but when saved the incorrect value is saved in the database. I am using 2 answer dropdown selections.

I know this is probably something simple I am missing. What value should I be changing for it to save to the database?

CivicCRM version:  4.7.4
Drupal: 7.43

I am not using anything other than a custom jQuery script that I am including in the head of the document using the Drupal template.php file.

Thank you
C Tyler


texts: use of "Dear you" extension when there is no first/last name only email and custom name field

texts: What if I don't have First name/last name but only a custom field called "full name" How to display that field or if thats missing display: "Supporter" instead?


texts: CRM.$ is not a function after upgrade 4.7.8 > 4.7.13

texts:
Running upgrade CiviCRM 4.7.8 to 4.7.13, on Drupal 7, I have a white screen with just "[]" message and "Retry" and "Skip" buttons, and js error : CRM.$ is not a function.
Tried to change the theme : no effect.
js and css files are not compressed.

Do you have any idea ?


texts: What is the status of CiviCRM working with Drupal 9?

texts: With the official release only a few days away (June 3, 2020) and the Drupal 9 porting weekend having just completed with a big effort by KarinG (https://github.com/colemanw/webform_civicrm/pull/314), what is the status of CiviCRM working with Drupal 9?


texts: Why am I getting "Invalid currency selection: USD for domain iatspayments.com" on submitting a paid event registration?

texts:
Using 1.5.3 CiviCRM 4.6.26 on D7. I get the following error: "Invalid currency selection: USD for domain iatspayments.com" when I submit an event registration.

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

My event page is configured for USD($)


texts: Case Manager not updating correctly (CiviCRM 4.7.21)

texts:
When I added some case roles and set the case manager to one of these roles it doesn't appear to update on the case summary screen.

Set up case
http://dmaster.demo.civicrm.org/civicrm/a/#/caseType
Add role
Set manager
View the case summary

No matter which case role I set the case manager to, it still shows as Case Coordinator is (Case Manager) in the first column of the table shown.

I think this is a bug, but if it is, has anyone else come across this?


texts: Bookkeeping report doesn't record check number for financial account/type

texts:
Every day we have to print off a report on the checks (their check numbers, name of payee, etc) we have received and their respective financial account credit codes.

However, the bookkeeping report built into civiCRM is not recording the check numbers.

UPDATE: It only shows the check number if the account debit is the 1100 ASSET "Deposit Bank Account" financial account that comes default with civiCRM. How do I make sure that the debit account is not accounted twice (as in checks only go into the Deposit Bank Asset and not Accounts Receivable as in the first example which is done correctly)? See new picture below:


texts: trouble with CiviCRM Installer on wordpress

texts:
I am trying to setup CiviCRM 4.7 on most recent Wordpress -- copied the folder to /var/www/html/wp-content/plugins/ and was able to see the plugins in Wordpress.

When I click on "configure CiviCRM", it takes me to a blank page -- there are no options available.

I am using Apache2, PHP, MariaDB on CentOS 7


texts: Civimember: token for membership end date not working

texts:
We are having a problem in setting up our Scheduled Reminders for Membership Renewals. The reminders are sent out as scheduled, but the relationship between Contact to Membership (which is through a foreign key in the database) seems to be broken as far as inserting tokens into the renewal email.

For example, adding lines to our Expiration Template like:

Paid thru: {membership.end_date}
Member since: {membership.join_date}

only replaces the tokens with blank in our email tests.

I found this reference from 2015 in the old CiviCRM Community Forum, but am re-posting here. I can't believe this is an unresolved issue. I use other membership software, like aMember PRO, and this is one of the most basic functions in renewal reminder emails.

If it has been resolved, please point me to a solution. My searches in this Stack Exchange haven't worked for me.

Thanks for any help!


texts:
We are working importing Volunteer Needs for various Volunteer Projects via the API csv Extension. When we load the interface, select the entity 'VolunteerNeed' and select file. When we hit continue we get the following:

  Uncaught Error: Call to undefined method
  CRM_Volunteer_DAO_Project::indices() in
  /home/<>/public_html/wp-content/plugins/civicrm/civicrm/api/v3/Generic/Getunique.php
  on line 44 civicrm_api3_generic_getunique()
  wp-content/plugins/civicrm/civicrm/Civi/API/Provider/MagicFunctionProvider.php:97
  invoke() wp-content/plugins/civicrm/civicrm/Civi/API/Kernel.php:168
  runRequest() wp-content/plugins/civicrm/civicrm/Civi/API/Kernel.php:99
  runSafe() wp-content/plugins/civicrm/civicrm/api/api.php:43
  civicrm_api3()
  wp-content/uploads/civicrm/ext/nz.co.fuzion.csvimport/CRM/Csvimport/Import/Form/MapFieldBaseClass.php:126
  preProcess() wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php:585
  buildForm()
  wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php:92
  perform()
  wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php:203
  handle()
  wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php:103
  handle()
  wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php:349 run()
  wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:311 runItem()
  wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:85
  _invoke() wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:52 invoke() wp-content/plugins/civicrm/civicrm.php:1392 invoke()
  wp-includes/class-wp-hook.php:286 apply_filters()
  wp-includes/class-wp-hook.php:310 do_action()
  wp-includes/plugin.php:465 do_action() wp-admin/admin.php:253

We have used the extension to import other entities with no issues. The site is running WP 5.2.4, CiviCRM 5.13.4, CiviVolunteer v4.7.31-2.3.1 & CSV GUI Import to api  v 1.5.


texts: CRON Error: Trying to get property of non-object in /.../libraries/joomla/session/handler/joomla.php on line 74

texts: How do I resolve this error, 'Trying to get property of non-object in /.../libraries/joomla/session/handler/joomla.php on line 74'? Here's line 74 or the joomla.php file, $cookie = $this->input->cookie;. This started after updating the site to Joomla 3.7 and PHP 7.0, but also shows up with PHP 5.6. The site is running CiviCRM 4.7.18.


texts: How do I find individuals that are participants in multiple (two) events?

texts: I want to see who is registered for both of two events. How can I do that as a search or a report?


texts: Sharing a CiviCRM database across multiple sites hosted on Aegir

texts:
I know it is possible to have multiple sites using the same Civi database which I'd really like to do, but our sites use the Aegir hosting system and so I'm not sure this will be possible?

Thanks!

Aiden


texts:
I'm volunteering for a new non-profit that has very limited resources and was wondering if there is any place that we can find volunteers for helping with CiviCRM. For finding FOSS developers i know about places such as idealist, sourceforge and openhatch, but what is the best place to find volunteers that are experts on CiviCRM specifically? (Doesn't have to be programmers)

Kind Regards, Tord


texts: Civi adds whitespace into contact images

texts:
I have a problem in CiviCRM when I try to add a contact image into a contact record.

I'm using Drupal 7, CiviCRM 5.13.4 and PHP 7.1.

From what I can make out, something is adding in whitespace to the images that I try and upload which naturally shows the image as being broken.

When I look at the image in the file system, the image is fine there but if I go into the source code of where the image is in a contact record, the image downloads and when I open it, the top line is blank (whitespace).

I have seen this on several sites but can't seem to find an answer anywhere so it would be good to know any possible reasons for this to happen so the fix can be applied to several sites.

I am wondering if it is a rogue module or something similar that is causing the problems. I thought it may be the theme which I disabled to test but the issue remained so that got ruled out.

Any advice would be greatly appreciated!


texts: Where do I found the "form action" call in TPLs to an Event?

texts:
I need to add a target attribute to the "form action" tag of an Event Registration form, because I need the Confirmation to open in a new window.

I'm trying to find the TPL file that inserts the "form action" tag, but I couldn't find it already. So, where is it?

Thanks.


texts: Why doesn't API for Contribution Get work with multiple Financial Type ID values?

texts:
I have this problem on my Joomla 4.6.2 system, and can reproduce it on the Joomla sandbox.  If I use the API Explorer to build a query like:

$result = civicrm_api3('Contribution', 'get', array(
  'sequential' => 1,
  'return' => "id",
  'contact_id' => 2,
  'financial_type_id' => "Campaign Contribution",
));

it works OK.  But if I try to specify multiple possible values for financial_type_id, such as:

$result = civicrm_api3('Contribution', 'get', array(
  'sequential' => 1,
  'return' => "id",
  'contact_id' => 2,
  'financial_type_id' => array("Campaign Contribution", "Donation"),
));

it generates a SQL error because it creates an invalid WHERE clause:

WHERE  ( civicrm_contribution.is_test = 0 AND civicrm_contribution.financial_type_id 0 )  AND (contact_a.is_deleted = 0)  LIMIT 0, 25

The "civicrm_contribution.financial_type_id 0" should instead be something like "civicrm_contribution.financial_type_id IN (1, 2)"

Is this a bug?


texts: How to export/import  Civi CRM  all database  (profile, custom field, contacts etc) with same setting in WordPress?


texts: Creating Event Participation Certificate in PDF

texts:
I've seen posts with something similar but I am a bit lost. What I am trying to do is to add some automation in creating certificates to participants of an event.  Our events are training sessions and we issue a certificate to those that attend.  Here is what I'm trying to accomplish:
User is registered to attend the event
At the conclusion of the event, we confirm registrations to those who actually attended. We update the records to those as "Attended".
Those that "Attended" would then get a certificate e-mailed to them.
Our certificates have a certain format with a border and a paragraph about the program. There is also a signature image on the certificate.   Is there a way to have this certificate template in CiviCRM and with "Display Name" as a token and have the certificates generated from the "Attended" list and then e-mail them?  It would be similar to PDF receives and PDF letters...just a preformatted certificate.


texts:
Our food co-op site uses relationships, e.g. Household Member. We have a custom relationship type: Proxy Shopper. We're interested in making Proxy Shopper conditional so that no individual can get Proxy Shopper status unless both individuals are Members of the same Household.

  Example:

  Jerry and Willow are Members of the Ortega Household. Willow
  owns a co-op membership with which she can shop at our store, and
  Jerry does not own such a membership. However, Willow has designated
  Jerry as a Proxy Shopper so he'll be able to shop on her behalf.

  Willow's mother Sabrina, however, is a member of the Sturm household
  (not Ortega), so Sabrina should not be a proxy shopper for Willow,
  even though Willow wants to send her mother to the co-op.

In short, we're looking for a way (possibly through an extension) to condition the Proxy Shopper relationship type upon membership in the same Household.

Worth noting that while belonging to the same Household should be required for setting a Proxy Shopper relationship, Household membership should not predict a Proxy Shopper relationship. In other words, no Household Member should become a Proxy Shopper unless someone sets that relationship via the admin interface.

What's the best way to do this -- beyond just telling backend users that they shouldn't make anyone a Proxy Shopper unless that individual belongs to the same Household as the second individual?


texts:
My event has a structure of all participants pairing up in study couples (2 or 3 people together).
I know I can create a relationship for each one, but I need to see the pairs very clearly in the event participant list.
How can I show the list of participants grouped by pairs, or even have each 2 (or more) coupled participants highlighted in different colors?


texts: Empty token default values -- core or extension support?

texts:
I want to provide a default value for tokens when the value is empty, on a per-use basis -- e.g., something like {contact.first_name?Friend} would print the contact's First Name if it's not empty, otherwise print "Friend".

Rationale update: This would allow non-programmers to easily specify a default value without needing to clutter up the tokens UI.

Existing workarounds for this functionality are more cumbersome than that:

Dave's blog from version 2.2 uses hooks in an extension to hard-code defaults for specific tokens in all cases.
This SE answer points out that this can be achieved by enabling Smarty processing and then inserting a few lines -- per token -- of Smarty code into the content.

To avoid double-work and/or undertaking the impossible, I ask:

Has any attempt been made to put such per-use-default-value functionality into CiviCRM core or an extension?

Technical challenges update: Tokens are limited to \w characters, so any plan to use a non-word delimiter like ? will have to involve changes in core, as far as I can see.


texts: How to Contribute on behalf of an individual instead of organisation for Member Dues?

texts:
Under Contribution Configurations,
I see  "Allow individuals to contribute and/or signup for membership on behalf of an organization?" checkbox is available by default, is there any way we can contribute on behalf of individual  for Member Dues without using family relationship type?


texts:
A new non-profit is asking which component is best for tracking incoming grants, and tracking them at a more detailed level (with activities, maybe even tying the final incoming contribution to the grant).

I saw the older blog post about CiviGrant vs CiviCase, and understand the concepts there.  But I'd like to get a feel for what most folks use these days for this type of incoming grant tracking.

It seems to me that CiviGrant is rather basic in design. It just tracks the most basic parts of a grant: its status, type, amounts, etc. It doesn't necessarily track ongoing activities at the grant level (each time there is communication or meetings about the grant, and so on). It also doesn't tie to a contribution, it seems.

CiviCase, on the other hand, is rather complex in its structure as it has workflows. It almost does more than what one might want for grant tracking. But it seems to allow for activities and maybe even contributions tied to the grant.

So it's a toss up between simplicity vs deeper tracking. What do people find most useful for incoming grant tracking?  Do you all use CiviGrant and add activity types (but not sure how it would link to the grant itself)? Or do you use CiviCase and create a more basic workflow?

Appreciate any thoughts you all might have!


texts: We are a non-profit mental health organization and require our records to be secure.


texts: I received a notification to update my security but am unsure on how to do this. I've went to my notifications and it didn't say how to proceed. I also looked in my menu options. I'm honestly lost.


texts:
Is there any way to search Personal Campaign Pages by the date that the campaign is created? On /civicrm/admin/pcp page, you can sort by starts and end dates, but these are for the donation/event pages, not the campaign page itself.

So for example, I created a campaign page in February 2016 for an event which is open since July 2014. Is there a way to find all campaign pages that are created in February 2016?


texts:
I would like to remove the "Add Relationship" button from the Relationship tab. I've been auditing some of the data and noticed that my users have been adding and removing relationships from this page. This caused a couple of data issues because the relationships are not connected to the cases. Then relationships were duplicating.

Anyway, I tried removing the "Add Relationships" button via css. The actions-link css, however, affects other pages.


texts: Error in CRM_Contact_Form_Relationship->setEmploymentRelationship() when saving an edited relationship

texts:
When editing and then saving a relationship, the AJAX overlay hangs with the spinning symbol. If the page is refreshed, the 'Relationship record has been updated." notification is shown and the change is saved in the DB

Console shows:

POST http://www.example.com/civicrm/contact/view/rel?action=update&cid=1234&id=4321&rtype=a_b&snippet=json 500 (Service unavailable (with message))

In syslog I'm getting the error:

http://www.example.com/civicrm/contact/view/rel?action=update&cid=24068&id=6749&rtype=b_a&snippet=json|http://www.example.com/civicrm/contact/view?reset=1&cid=24068|2386||Error: Call to undefined method CRM_Contact_BAO_Relationship::isCurrentEmployerNeedingToBeCleared() in CRM_Contact_Form_Relationship->setEmploymentRelationship() (line 654 of /var/www/html/sites/all/modules/civicrm/CRM/Contact/Form/Relationship.php).

This used to work correctly and seems like it may have stopped working after 5.x upgrade, though the server was also updated about the same time.

Appreciate any ideas on how to resolve this


texts: Older CiviCRM that does NOT require TRIGGER privileges?

texts:
As of title, I'm looking for a CiviCRM version that does not require trigger privileges, since the hosting service that I'm using does not support it, currently I'm on version CiviCRM 4.7.13 and getting this error when I try to create a new contact:
"Sorry but we are not able to provide this at the moment.
DB Error: insufficient permissions"

these are the privileges on my user from MySQL:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES ON db1234.* TO 'usr1234'


texts:
Joomla 3.9.3
CiviCRM 5.10.3
CiviMobile 1.3.1
App on iPhone
http://crm.mydomain.xx
admin account

App always comes up with "unknow error" - demo works.

THX4HELP
Frank


texts:
I'm testing CiviCRM for a camp, and some of the families that come to a week of Family Camp are very large (some have 10+ kids). I tried the "Register additional participants" method for a large test family, and it

Took forever,
Generated massively long email receipts, and
Didn't generate any family relationships, shared addresses, etc on the backend. This isn't surprising, but it was depressing to think how much manual cleanup this will require after every single registration.

Household registrations seem to be a good potential solution. I cannot find a mechanism for anyone to act as a household, but some of the settings, such as allowing a household to edit member's addresses, seem to indicate that this is possible.

Is there a way that an external constituent can register a household for an "event" (camp session)?


texts:
Since i installed CiviCRM on my Drupal site i can't save users anymore.

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

Civi Resource urls for Civi is correct.
It happens when i create a user with a form.
Drupal: 8.4.0
CiviCRM: 4.7.28
Edit:
Because the original website was already built in Drupal 8 and it relies on some Drupal 8 features it will not be possible to switch to Drupal 7.


texts: CiviCRM does not have permission to write temp files on new server

texts:
I just built a RedHat server on AWS to act as a Test server and cloned a Git repository that has my Drupal installation in it. After importing the Prod MySQL database for both Drupal and CiviCRM and adjusting the civicrm.setting.php file I tried accessing the website. I get the error message:

  CiviCRM does not have permission to write temp files in
  /var/www/html/natureserve/sites/default/files/civicrm/templates_c/en_US/,
  Exiting

The root directory of the website is owned by the 'apache' user and I set the permissions to '777' (both recursively). I know this is not recommended but I wanted to see if it was indeed a file permissions issue.

Any thoughts as to what else I can try?


texts: How to get more debug info about "DB Error: no such field Return to home page"

texts:
I have created an event registration form, using a profile with a custom field. When I click Continue after filling in the form, I see Processing ... and then I get the confirmation screen, which looks good. But when I hit Continue I get:

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

WordPress 4.7.4
CiviCRM 4.7.17

I'm filling in two of the input fields from URL variables.  Not sure if that might be a problem.

If you want to try:

https://connectionpractice.org/test-webinar-with-affiliate-code/?affiliatecode=irthlingz1&eventtype=Introduction

I'm thinking I need to get more debug info to figure out which field is causing the problem.  How can I do that?

P.S. My code for the URL variables

<script>
(function($) {
  // all JS code here
var l = document.location;
  var affiliatecode = l.search.match(/affiliatecode=([a-zA-Z0-9_]+)/)[1];
var eventtype = l.search.match(/eventtype=([a-zA-Z0-9_]+)/)[1];
   $( "input#custom_3").val(affiliatecode);
   $( "input#event_type").val(eventtype);
})(jQuery);
</script>


texts: Getting a Custom Field Value on a Contact with Javascript API

texts:
I have a custom field for contacts that I would like to retrieve the value for using JavaScript.

Using the API explorer I have generated the code that does this. It works PERFECTLY from the API explorer (which uses PHP).

However, when I run the Javascript code in my extension I get an error. Here is the code:

CRM.api3('Contact', 'getvalue', {
  "sequential": 1,
  "return": ["custom_102"], //custom_fieldId
   "id": 2 // contact id
 }).done(function(result) {
   // do something
 });

Here is the error:

Object {
    invalid_field: Array[1],
    is_error: 1,
    error_message: "field Array unset or not existing" }
    error_message : "field Array unset or not existing"
    invalid_field : Array[1]
         0 : "custom_102"

I am at a complete loss here... and would really appreciate some help!


texts: Smart Group Features Extension to Memberships, Events, Contributions, Activities,

texts:
I have a lot of Organisations, each having their own Administrator(s) who manage their own memberships, events, contributions, activities, ... (that I predefine for them)

I would like those Administrators to be able to make "Multiple Updates" to those (e.g. payments by checks) ; but I don't want them, for security reasons, to use the standard Search features to do that.

As far as I know (am I wrong ?), there is currently no possibility to predefine and store Searches, except for Contacts, via Smart Groups.

My idea would be : since we have the same search possibilities for members, participants, contributions, activities, ..., as for Contacts, it should not be too costly to develop the ability to extend the Smart Group features (including Multiple Update) to those.

What is the best way to have this ability developped (I am not personally a programmer) ?

Edited May 25 to give an example :

I have defined an Event with an associated Contribution Page.

People register on line (Webform) and pay either on line or by check.

When I receive the checks, I want to record them to manage the Event balance :

I Search for Contributions, based on the Contribution Page + Pending Status :
In the contacts List, I then select those who have sent their check and I select Action > Update multiple Contributions :

Then I select a Contribution Profile which contains Total Amount, Payment mode (check or cash), check #, status :

I can then record all the checks that I have received

I would use the same process to update memberships custom fields (Search for memberships + Membership Profile, instead of Contribution) or for Event or Activities.

I can make those Searches because I am the general Administrator, but I don't want my organizations Administrators to have this permission : too dangerous and uneasy : this is why I ask for this Search storage (in the form of Groups), that I could predefine for them.


texts: Organisation membership with Drupal user account

texts:
I am running Drupal 7 with Civi, both on the latest version. I would like a user to be able to register to become a member on behalf of an, which creates an account for a user in Drupal core, who can then edit the organisation details.

I've setup the process so far using CiviCRM Profiles and Webforms. Here is my current setup:

User applies for an account using profiles and Drupal core using logintoboggan to control this part.
User account is accepted, and an email is set to a webform link

webform: Number of Contacts: 2

1: Organisation

2: Individual (here I have linked the Individuals Current Employer to the Organisation and added them to a group – which is used in a rule to active the user in Drupal’s core, so the user can login after completing registration)

Users are then prompted to pay . This workflow works, mostly anyway.

A couple of questions:

1: Is using the method of adding the Individual to a group which activates the Drupal core user the best method? I feel that this is messy, especially when the organisations membership is due for renewal and if the organisation doesn’t renew how is the individual account deactivated? Is there a better way?

2: How do I allow the user to edit the organisations details?

I have many other thoughts/questions. But this enough… for now :)

Thanks for your help!

SJ


texts: CiviMail won't send mailings; start/completed date is "0th, 0 12:00 AM"

texts: CiviMail is no longer sending out mailings after a recent upgrade.  The start and completed dates, instead of being blank, are "0th, 0 12:00 AM".  How do I fix this?


texts: Attempting to install CiviCRM 4.6.38 in Wordpress 4.9.8, PHP 7.2.5, MariaDB 10.3.8, Nginx 1.14.0, Amazon Linux 2. Getting "MySQL support not included in PHP". PHPinfo shows mysqli and mysqlnd enabled.


texts:
We'd love to build custom 'Thank you' pages for our events using Drupal 7x., instead of using the WYSIWYG editor field on the CiviEvent page. Is there a way we can use Rules or CiviRules to immediately direct someone to a custom page after they sign up for an event? We can't use Webform CiviCRM because it does not offer price set support.

If you're interested - backstory: We want to have better social media integration, "share this event", contact us info, maps, etc. on this page. It seems somewhat limiting to use CiviCRM templates for creating this functionality when our page editing tools in Drupal are wonderful and easy.

Does https://github.com/eileenmcnaughton/nz.co.fuzion.frontendpageoptions work on 4.7?

Drupal 7.x, CiviCRM 4.7.x


texts: How do I get a chained restful API call to return xml?

texts:
This query string will return a contact record and related phone records for Contact ID 1234 in json format:

entity=Contact&action=get&json={"contact_id":"1234","api.Phone.get":{}}

How do I construct a query string that will return the results in xml format?  It seems as if the API Explorer only returns json.


texts: How do I make a CiviEvent accessible to the public?

texts:
After I create an event in CIVI where does it then go?  How can outsiders find out event?
I participated in a class the other day and was successful at the application but now that I have created the event I am unsure how to find it and how others can find it to register.  Thank you kindly.


texts: What can be done to ensure Stripe and CiviCRM are ready for SCA in Sept 2019

texts:
There is a comment at https://lab.civicrm.org/dev/financial/issues/41#note_14585 saying an MIH will be needed to ensure Stripe+CiviCRM is ready for this.

In Stripe Dashboard is shows

assuming via API was right option you get

and assuming i opted for right choice the next screen shows

and if i add recurring i get


texts: Using internal anchor links in Mosaico emails

texts:
Even though anchor links don't work in all mail clients, we have still been using them in emails for tables of content in a monthly newsletter. It seems like at least a few others have run into the same problem we have, which is that Mosaico breaks anchor links:

How can I set up anchors in Mosaico mailing?
Internal links in a Mosaico template?

I've found that the issue is actually because Flexmailer seems to try to apply tracking to all URLs, including anchor links, which breaks them. I've put those details here:

https://github.com/civicrm/org.civicrm.flexmailer/issues/43

Does anyone have ideas how this could be fixed simply?


texts: CiviCRM Dashboard and Menus disappear after upgrade and GoCardless extension disabling

texts:
I was running CiviCRM 5.16 on top of Drupal 7.69, atop Debian 9. I tried installing the GoCardless extension (after discussion at CiviCamp Birmingham) using the built-in extensions manager and couldn't quite get it to work. I figured it might be because my CiviCRM was a bit too old, so I tried removing it and upgrading Civi to 5.23.1, then reinstalling the extension.

Somewhere in this upgrade process, I've got to the point where the CiviCRM menu bar and dashboard no longer appear on my site. Everything seems to work if I can remember the URLs, but this is obviously very frustrating. Any idea where to look? I'm not getting any browser errors, and the last thing in ConfigAndLog/CiviCRM.*.log is the database upgrade to 5.23.1


texts:
When attempting to merge accounts, I receive this message:

CiviCRM_API3_Exception: "You have requested a non-existent service "prevnext.driver.". Did you mean one of these: "prevnext.driver.redis", "prevnext.driver.sql"?"

How might I go about fixing this issue?


texts: Disable keyboard popup on select field entry -- ios

texts: When a registrant clicks on our event fee block with field type "select", the keyboard pops up and can block the selection field (on mobile). Is there a way to keep the keyboard for activating on the drop down field -or- activate the select options at the bottom of the page (verses the keyboard)? I've used radio boxes to avoid but prefer the select field type when you have more choices in the field.


texts: SYNTAX ERROR in Pledge Report when Balance Due is selected (ver. 5.18.2)

texts:
CiviCRM ver. 5.18.2 (or 5.14.2) on Wordpress.

Hi all.

When Balance Due is selected in Pledge Report > Details we get a syntax error. Here is the error log:

 [error] $Fatal Error Details = Array
(
[callback] => Array
    (
        [0] => CRM_Core_Error
        [1] => handle
    )
[code] => -2
[message] => DB Error: syntax error
[mode] => 16
[debug_info] => SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_sort_name, pledge_civireport.id as civicrm_pledge_id, pledge_civireport.contact_id as civicrm_pledge_contact_id, pledge_civireport.amount as civicrm_pledge_amount, pledge_civireport.currency as civicrm_pledge_currency, pledge_civireport.status_id as civicrm_pledge_status_id, COALESCE(sum(pledge_payment_civireport.actual_amount), 0) as civicrm_pledge_payment_total_paid, IF(pledge_civireport.status_id IN(3, ), 0, COALESCE(pledge_civireport.amount, 0) - COALESCE(sum(pledge_payment_civireport.actual_amount),0)) as civicrm_pledge_payment_balance_due, (address_civireport.street_number % 2) as civicrm_address_address_odd_street_number
        FROM civicrm_pledge pledge_civireport
             LEFT JOIN civicrm_contact contact_civireport
                  ON (contact_civireport.id =
                      pledge_civireport.contact_id )

    LEFT JOIN civicrm_pledge_payment pledge_payment_civireport ON
      pledge_civireport.id = pledge_payment_civireport.pledge_id
      AND pledge_payment_civireport.status_id = 1

             LEFT JOIN civicrm_address address_civireport
                       ON (contact_civireport.id =
                           address_civireport.contact_id)  AND
                           address_civireport.is_primary = 1
WHERE (pledge_civireport.is_test=0 )   GROUP BY pledge_civireport.id, pledge_civireport.currency  ORDER BY contact_civireport.sort_name, contact_civireport.id  LIMIT 0, 50 [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '), 0, COALESCE(pledge_civireport.amount, 0) - COALESCE(sum(pledge_payment_civire' at line 1]
[type] => DB_Error
[user_info] => SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_sort_name, pledge_civireport.id as civicrm_pledge_id, pledge_civireport.contact_id as civicrm_pledge_contact_id, pledge_civireport.amount as civicrm_pledge_amount, pledge_civireport.currency as civicrm_pledge_currency, pledge_civireport.status_id as civicrm_pledge_status_id, COALESCE(sum(pledge_payment_civireport.actual_amount), 0) as civicrm_pledge_payment_total_paid, IF(pledge_civireport.status_id IN(3, ), 0, COALESCE(pledge_civireport.amount, 0) - COALESCE(sum(pledge_payment_civireport.actual_amount),0)) as civicrm_pledge_payment_balance_due, (address_civireport.street_number % 2) as civicrm_address_address_odd_street_number
        FROM civicrm_pledge pledge_civireport
             LEFT JOIN civicrm_contact contact_civireport
                  ON (contact_civireport.id =
                      pledge_civireport.contact_id )

    LEFT JOIN civicrm_pledge_payment pledge_payment_civireport ON
      pledge_civireport.id = pledge_payment_civireport.pledge_id
      AND pledge_payment_civireport.status_id = 1

             LEFT JOIN civicrm_address address_civireport
                       ON (contact_civireport.id =
                           address_civireport.contact_id)  AND
                           address_civireport.is_primary = 1
WHERE (pledge_civireport.is_test=0 )   GROUP BY pledge_civireport.id, pledge_civireport.currency  ORDER BY contact_civireport.sort_name, contact_civireport.id  LIMIT 0, 50 [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '), 0, COALESCE(pledge_civireport.amount, 0) - COALESCE(sum(pledge_payment_civire' at line 1]"]

Is this a bug? or is it the result of errors in setting the fields?

Thx&Bye.


texts:
My wordpress site is hosted by godaddy and I want to use CiviCRM but when I click here:  CiviCRM WordPress Member Sync   the settings link it says this: "Sorry you are not allowed to access this page".  Hence, I can't set up the member info, etc.
Wendy


texts: Getting CiviCRM Security Upgrade Needed warning after upgrade to 5.23.3

texts:
Upgraded to 5.23.3 and now get warning that CiviCRM Security Upgrade Needed

The list of upgrades only shows

CiviCRM 5.9 has reached its end of life. Security updates are not provided anymore.
Please upgrade to the latest stable release (5.23) or an extended security release (5.21).

Release history

5.10.0 was released on 2019-02-06. The latest patch revision is 5.10.4 (2019-02-22).
5.11.0 was released on 2019-03-06.
5.12.0 was released on 2019-04-04. The latest patch revision is 5.12.4 (2019-04-25).
5.13.0 was released on 2019-05-01. The latest patch revision is 5.13.8 (2019-12-04).
5.14.0 was released on 2019-06-05. The latest patch revision is 5.14.2 (2019-06-29).
5.15.0 was released on 2019-07-03. The latest patch revision is 5.15.2 (2019-07-31).
5.16.0 was released on 2019-08-07. The latest patch revision is 5.16.4 (2019-09-03).
5.17.0 was released on 2019-09-04. The latest patch revision is 5.17.5 (2019-09-26).
5.18.0 was released on 2019-10-04. The latest patch revision is 5.18.4 (2019-10-22).
5.19.0 was released on 2019-11-06. The latest patch revision is 5.19.4 (2019-12-04).
5.20.0 was released on 2019-12-04. The latest patch revision is 5.20.3 (2019-12-28).
5.21.0 was released on 2020-01-01. The latest patch revision is 5.21.2 (2020-01-23). 5.21.x is an Extended Security Release.
5.22.0 was released on 2020-02-05. The latest patch revision is 5.22.1 (2020-02-18).
5.23.0 was released on 2020-03-04. The latest patch revision is 5.23.2 (2020-03-13).

Any suggestions?


texts: How to set a Task or Communication in Compucorp new CiviCase

texts:
After creating new Activity Type either Task or Communication, I cannot see them in the Option for new Task or Communication. Even after the Caches cleared, the Task remains empty and Communication shows the 4 basic options (Email, Follow Up, Meeting and Phone Call).
Is there something to add in the database ?
Thanks for the help using this great new CiviCase ;-)


texts: Change civicrm combobox value from the code

texts:
I want to know how to change the value of those awesome civicrm comboboxes from the code (i have google address search, I need to change the country), see the screenshot.
jQuery("#country-1").val(val); document.getElementById('country-1').value = val; don't work


texts: Why does the Cron user show as logged in to the site in Joomla Admin area?

texts:
This is a new phenomenon since updating to latest CIVI.
Joomla 3.5.1
CIVI 4.7.3


texts: How to share the user profiles with other users?

texts:
The requirement is if Contact A's specific field values(custom fields) are matching with Contact B field values then Contact C(Admin) should b able to share
Contact A's profile with contact B by civimail. The profile should be of drupal view page of type Civicrm Contacts
I tried Fuzion tokens extension to attach the user id and use the link as template for civi mail-
"http://localhost/example.com/profile-page-view?uf_id={user.id}" but this will attach their own profiles(Recipients own profiles)
Admin will be finding the matching contacts using advanced search and find matches and sends email
Any help would be appreciated.


texts:
I have around 900 pairs of contacts I want to force merge. From my attempts to do this, if you click "merge all duplicates", it will simply display "900 pairs skipped" and not give you the "force batch merge" option that you do get when manually selecting contacts to merge.

I am matching on external id's that I've already rigged to ensure consistency, I am sure I want these merged.

Right now my only option is to select 100 contacts at a time and go through "batch merge", then "force batch merge" for each page.

How can I do this most easily?


texts: Can I subtract guest fees collected from a membership fee when a user registers

texts:
Our club allows people to come out as guests, for which we collects guest fee. If that person later chooses to become a member, we deduct that guest fee from their membership fee.

I know I can create different fee structures, but that assumes the person entering the information, whether that's a club executive or the member selects the correct thing. I haven't found a mechanism for membership upgrades, or a means of replacing one membership with another but applying a credit against the new one.

Is there a way with CiviCRM to automate this process?


texts: How do I override the default date range of JQuery date widget?

texts:
CiviCRM 4.7.3 Currently hard coded to show 10 years in the past, and 9 years in the future.

I would like to override this and set the year range from 1965 to the current date, as described in the docs:-

http://api.jqueryui.com/datepicker/#option-yearRange


texts: Scheduled reminders based on a custom field on an activity

texts:
I know that in CiviCRM 4.6, the ability to send scheduled reminders to people based on a custom field (e.g. marriage date) was added.  However, I'm unsure if it's possible to send a scheduled reminder based on the custom field of an ACTIVITY.  I couldn't figure out how, if so.

The use case is to have a custom activity field labeled, "Remind me on X date", which is similar to functionality present in Raiser's Edge.


texts: Totals without showing each contact in Contact related reports

texts:
Is it possible to have contact reports with listings that do not initially show each contact as a row but displays only the totals for the sorting groups?  I have thousands of contacts and want to have a report that shows how many contacts are within each postal code or totals for each gender, etc.  I know we can get the totals to be displayed using the Sort area and clicking the check box for "Section Header / Group By".  However, my results have hundreds of pages and I just want to see the totals for each category.

We are currently on CiviCRM 4.6.20.0 on Drupal.


texts: Undefined index in civicrm_member_roles_sync

texts:
I'm using drupal 7 with CiviCRM 4.4.6.

I'm using CiviMember Roles Sync with below Association Rules:

Rule ID: 3
"CiviMember Membership Type" --> "Drupal Role": Member (PG) --> member
Current Codes: New, Current
Expired Codes: Grace, Expired, Pending, Cancelled, Deceased

Rule ID: 4
"CiviMember Membership Type" --> "Drupal Role": Member (KK) --> member
Current Codes: New, Current
Expired Codes: Grace, Expired, Pending, Cancelled, Deceased

In setting "Automatic Synchronization Method", I select "Synchronize whenever a user logs in or logs out."

When user login, error appear as below:

  Notice: Undefined index: 4 in _civicrm_member_roles_sync() (line 541
  of
  /home/warrior/www/beta/sites/all/modules/civicrm/drupal/modules/civicrm_member_roles/civicrm_member_roles.module).

Here are drupal user roles available on my site:

ID 3: Web Developer
ID 4: Content & Membership
ID 5: member
ID 6: Membership Admin

I tried to change "Automatic Synchronization Method", but the error still appears.
When I change to "Synchronize when membership is updated", error appears after payment made (membership updated).
When I change to "Synchronize when Drupal cron is ran", error appears when I run cron.

Any idea how to solve this error?


texts: Building an extention in civicrm. i try fetch campaign base on contact nothing displays while i have records

texts:
function contactcampaign_civicrm_dashboard( $contactID, &$contentPlacement ) {
// REPLACE Activity Listing with custom content
$contentPlacement = 3;
//(int) CRM_Core_DAO::singleValueQuery('SELECT COUNT(*) FROM civicrm_campaign');
$query = "SELECT id, title, parent_id, status_id, goal_general, goal_revenue
              FROM civicrm_campaign
              WHERE created_id = $contactID";
$campaigns = CRM_Core_DAO::executeQuery($query);

$campaignList ='
';
$campaignList .= '
Title	Contribution Page / Event	Status	Target Amount	Amount Raised	Number of Contributors
';

while ($campaigns->fetch()) {

 foreach($campaigns as $campaign){

    $title = $campaign->title;
    $targetAmount = $campaign->goal_general;
    $raisedAmount = $campaign->goal_revenue;
     $status = $campaign->status_id->title;
     $parent = $campaign->parent_id->title;

    $campaignList .=  '
';
    $campaignList .=  ''.$title.'	';
    $campaignList .=  ''.$targetAmount.'	';
    $campaignList .=  ''.$raisedAmount.'	';
     $campaignList .= ''.$status.'	';
     $campaignList .= ''. $parent.'	';
    $campaignList .=  '
';
 }
};
$campaignList .= '
';

return array (
   'Campaign List'=> $campaignList
);

}

pls i dont know what am doin wrong.


texts:
I am trying to put a "mailing list" subscribe form into a Joomla module (having the sign-up be its own page is not very useful).

However, I am running into problems with qfKey. How can I generate a qfKey?

I can copy and paste the generated form html, but submissions can't happen without a valid qfKey in the form post.

Any other/better ways of doing this or is there a simple function I can call to generate a qfKey for mailing list sign up?

Thanks in advance,
Joel


texts: Do Stripe webhooks work for refunds issued via the Stripe website?

texts: Webhooks are working fine for Stripe payments.    Refunds issued for events that were cancelled are showing an error on the Stripe account.   Should refunds issue calls to Civi for the transaction?


texts: On CiviContribute forms within WP, the behavior of predefined amounts and an "Other Amount" input box is broken

texts:
For CiviContribute forms in WordPress that have predefined fixed amounts ($25, $50, $100, ...) and that also allow an "Other" amount, it seems that the javascript that is supposed to clear the fixed amount radio buttons when an "other" amount is filled in is broken. I'm using Civi v.5.4.0 in WordPress v.4.9.9.

The malfunctioning behavior is also reported here, but the CMS is not indicated. A couple javascript solutions are posted— but this should work out of the box with Civi, right?

Looking under the covers, I see there are javascript functions clearAmountOther() and useAmountOther() that are wired to the onclick events for the radio buttons. However, the DOM structure the code refers to is invalid. There is no document.Main.amount_other.

function clearAmountOther() {
  var priceset = 0
  if( priceset ){
    cj(priceset).val('');
    cj(priceset).blur();
  }
  if (document.Main.amount_other == null) return; // other_amt field not present; do nothing
  document.Main.amount_other.value = "";
}

As a result, if you select a fixed amount like $25 and then enter $40 into the "Other Amount" box, the contribution is the sum $65. This is likely to surprise donors!

Is this a known issue? A bug that needs to be fixed?


texts:
The error is e.g.

  Data too long for column 'custom_194' at row 1

Our values are 1 character so we set the DB Field Length to 1. However, this makes exports of this same field fail. It is exporting the label, not the value, so DB Field Length needs to accommodate the label.

Since this is unresolved https://lab.civicrm.org/dev/core/issues/181 is setting a longer DB Field Length my only alternative to letting exports work again?


texts: Search > Find Memberships: Difference between Membership Status Current AND Current Member?

texts:
Search > Find Memberships -or- Search > Advanced Search and I use the Membership criteria in my search I usually set the Membership Status to Current but I just noticed today below the Status field there is a radio button fieldset with a label Current Member?

What is the difference between the Status = Current and the fieldset for Current Member? being checked


texts: How to prevent fraud attempts on Contribution pages?

texts:
An org I work with is reporting heavy fraudulent use (at least attempts to use -- it seems many are being declined in Auth.net, although some are getting through) of the CiviContribute form, despite the "I'm not a Robot" reCAPTCHA that is in place.

What are other ways to prevent these types of fraudlent attempts besides the Captcha on a profile? (I thought the Captcha would prevent it from even showing up in Authorize.net)


texts: "No records of type '' found" error - shortcode in WordPress page to edit profile

texts:
Help - updating profile forms from the front-end has broken over the last few updates. I have the following shortcode used on a Wordpress page:

[civicrm component="profile" gid="14" mode="edit" hijack="0"]

Upon viewing the page, I get the ""No records of type '' found" error:

If the shortcode is set to "view", it displays fine.

This occurs with me logged in with admin privileges.

Ideas?


texts: Different Contacts of same child Group in multisite

texts:
I use a multi-site CiviCRM installation with the CiviCRM Multisite extension installed and tuned : having Multi Site Configuration enabled and each site set with a Domain Group.
I set all the proper user's roles in the Drupal permission page for each domain (use of domain access in Drupal 7).

But I struggle with the use of sub-groups.

Let's consider that for the site A-site, the Domain Group is A-group, and for B-site the Domain is Group B-group. Both A-group and B-group are parent group for a same child group C-group.

In one exemple that I have, a C-group that is shared group between different two sites shows a very different number of contacts : one gives 1488 Contacts and the other only 42 Contacts…

Site A > Domain Group is A-group > is parent of C-group > 1488 contacts

Site B > Domain Group is B-group > is parent of C-group > 42 contacts (The site B has no access to the missing 1446 contacts)

I cannot explain why there is a difference of contacts that belongs to C-group depending on they are on the A-site or the B-site.

The 42 contacts belongs both to B-group and C-group, the missing 1488 Contacts belong only to C-group.

The CiviCRM Multisite doesn't consider a shared sub-group between sites ?
What is the criteria for a contact to belong to a site or another ? Should I understand that to belong to a (same) sub-group is not the condition to belong to a site ?

Is there a way to include in the selection process the use of sub-groups (child groups) ?


texts:
I have recently upgraded from CiviCRM 4.6 to 4.7. I have custom PDF page formats set up for PDF letters for mailing. When I apply these custom PDF formats to the PDF letter templates, the page margins I set up in the PDF formats are not applied to the letter templates and don't display in the margins fields in the expanded template section.

How can I fix this?


texts: WP-CLI using GMT/UTC Timezone on cron jobs

texts:
Not sure what exactly broke, but upgrading to CiviCRM 4.7.1 on CentOS 6 required adding PHP 5.4 via the SCL repo.  Something in that process broke the cURL/wget/php cron job calls.  (Invalid username/password despite logs showing it correctly.  See https://issues.civicrm.org/jira/browse/CRM-17981)  So, I created a cron job with:
scl enable php54 "wp --user= --url= --path=/path/to/wp/ civicrm api job.execute auth=0"
It runs, and everything seems fine.  However, when I go to Scheduled Jobs, everything reports as using a GMT/UTC timezone.  If I click to run manually, it reports the local time.  I've check the php.ini file and it has the correct timezone declared, as does the site's Settings page.  Anybody got a clue?


texts:
We have some events which require very early registration, that the participants would like to pay later by Credit Card (easier than cheque)

Being given the contact_id and the contribution_id, the user can open the Credit Card Payment Form (e.g. via a small php program which fetches those 2 ids and then opens the form) :

/civicrm/payment/add?reset=1&id=1275&cid=5289&action=add&component=contribution&mode=live

where : id=contribution_id  and cid=contact_id :

But then the user still has to select the payment processor (sorry for being in french : Passerelle de paiement), which may be confusing and source of errors.

Why is this necessary, since the payment is attached to a Contribution Page, which is itself attached to a Payment Processor ?

Is there a way to have the payment_processor_id parameterized in the URL (e.g. ...&ppid=xx) ? ... or smth equivalent ?


texts: I was wondering if it is possible to embed the thermometer from an individual personal campaign page to another site. I am guessing it is, but don't know where the best place to look for the code is: anyone know?


texts: Page that uses CiviDiscount-- not events or memberships

texts: I understand from this thread that cividiscount is generally used for membership costs or event fees. For our events, we currently use a contribution page to collect fees so that we can use a price set and allow people to pay for more than one event at a time. Is there any kind of page I can set up to allow the use of CiviDiscounts as well as price-sets?


texts: Authorize.net and Automatic Recurring Billing (ARB)

texts: We have authorize.net running for over 2 years, Added Automated Recurring Billing. It worked for a test, when we tried to use it for a real event it failed. Civicrm shows it working correctly but Authorize.net sees the initial transaction but does not see the ARB transaction.


texts: System Status: Error "Cron Not Running" after update to 4.7.4

texts:
So going through CiviCRM, this error keeps popping up:

Cron Not Running
No cron runs have been recorded.

Unfortunately, I have contacted my hosting provider and asked what cron isn't running related to CiviCRM, and they could not help me unless they knew the name of the cron. I tried seeing what it could be but I cannot find any information on this. I never had this error prior to updating to 4.7.4 from 4.6.10. I tried running a cron in the backend, like system update check, to see if it would fix it but it did not. What can I do to solve this issue?
Thank you.


texts: Add Custom Fields to Send Email Activity

texts:
Our development staff are using activities for tracking moves management.  We've created a custom set of "moves management action types" and have added those to appropriate civicrm activities.  I can't, however, figure out if there is a way to assign custom fields to the "Send an Email" activity type.  I'd like to be able to assign the same action types to the "Send an Email" activity type for reporting purposes.

Anyone have any ideas how to do this, or an alternative approach?

Thanks!

-tim


texts: "Print PDF Letter for Contacts" missing from Contact Actions

texts: There's a lot of reference to this but the 4.7 version I'm setting up has changed this action. How do you print a pdf letter for contacts in 4.7?


texts:
We have DKIM configured with the MTA we are using with CiviCRM, and it appears to be working.  However, the DKIM signature fails consistently; using a checker it appears the mail has been altered after being signed.  Has anyone else experience of this?

I've done some more investigation.  I have an IIS based development system. Configuring SMTP leads to the test email failing DKIM. Sending a CiviMail test environment passes DKIM.  Sending a CiviMail test from Linux Apache based test environment leads to a DKIM failure.  Webmail and Thunderbird SMTP both lead to DKIM passes.  Any suggestions?


texts: Membership Receipts from Civi webform for On Behalf of Organisation

texts:
(Civi 4.4.6, Civi Webform 7.x.4-10, Drupal 7.37)

From what I read on the Civi webform wiki (https://wiki.civicrm.org/confluence/display/CRMDOC/Webform+CiviCRM+Integration), receipts should be generated from the attached contribution page just as they would from the contribution page itself.  Is this not correct?  What is happening with our client's is that none of the usual info about the organization for whom the user is joining/renewing is included in the email, so when the organization gets the copy of the receipt, there's nothing to identify who it was (other than, of course, the email address).  Is there some trick to passing all the necessary information over?

Here is the image (identifying info awkwardly scribbled out - graphic artist, I am not):


texts: How to resolve SMTP connection failing problem with code 535?

texts:
After upgrading CiviCRM from 4.6 to 4.7.14 I was not able to send (test) emails via SMTP. I got the following error:

  authentication failure [SMTP: STARTTLS failed (code: 220, response: 2.0.0 Ready to start TLS)]

After replacing some code in /packages/Net/SMTP.php like Matt suggested I'm now receiving the error:

  authentication failure [SMTP: Invalid response code received from SMTP server while sending email. This is often caused by a misconfiguration in Outbound Email settings. Please verify the settings at Administer CiviCRM >> Global Settings >> Outbound Email (SMTP). (code: 535, response: 5.7.8 Error: authentication failed: authentication failure)]

Maillog says:

  Dec 21 11:19:55 rs0815 postfix/smtpd[31606]: warning: SASL authentication failure: client response doesn't match what we generated
  Dec 21 11:19:55 rs0815 postfix/smtpd[31606]: warning: rs0815.rs.example.de[123.123.123.123]: SASL DIGEST-MD5 authentication failed: authentication failure

I doesn't make a difference if I use PHP 5.5 or 5.6.

Any idea what could cause this?


texts: Cannot edit prefix, suffix, first name or last name of new or existing Individual

texts:
After upgrading my CiviCRM to 4.6.4 (& 4.6.6 after that in trying to fix this problem) I cannot see or edit suffix, prefix and first or last name of Individuals on the Contact Screen. Even when creating a webform with the civicrm_webform module I cannot add these name fields in a new webform, they just don't show up and are missing from webforms which used to have them. Also in the administration section on the display preferences page I cannot longer choose to display these fields on the contact screen.

If I create a profile with the name fields for Individiuals I don't have any problem. I can add those fields to the profile and can use the profile to change the names of Individuals. I can also export the fields. Any help would be much appreciated.

Steps I already took: compare my 4.6.6 database tot a fresh 4.6.6 db intall and adjusted the differences I found, several cache flushes, explored the different debug options but the problem is I cannot seem to find an error within CiviCRM when I try to edit the name of an Individual. It doesn't sem to trigger an error or I am no able to find it.

I will try and add some screen shots of the pages with the problem to make it more clear.


texts: Social sharing issues: OG and title metas - WP

texts:
I work with an organization that recently implemented CiviCRM on its WP site. Since then, social share information/open graph tags on certain pages are scraped from here: http://vector-space.org/civicrm/. The same is true for the title. When I checked FB's debugger, I realize processes a redirect and scrapes OG tags from the aforementioned page. For example, debugger results for an event:

  The following will be treated
  as a redirect by the crawler:

A HTTP redirect
A <link rel="canonical" href=".." /> tag
A <meta property="og:url" content=".." /> tag

  Wordpress SEO didn't resolve the issue since browsers/crawlers are
  pointed to the CiviCRM header.

I found the parse code on the basepage template, but my coding skills are limited. Is there a way to resolve this so that we can display our own header/OG tags or Wordpress SEO OG info in social shares?

Thanks!


texts: Manually adding/removing contacts in a Smart Group

texts: If you manually add/remove contacts to a Smart Group will they remain in the group when the group updates?


texts:
I have a client evaluating Civi and they need voting district data to be in their contact records. If they have shapefiles for districts and full addresses in contact records, how much of a challenge is it to use those data points to populate a field for district?

I have looked in the docs for info about using shapefiles (no luck), and seen threads about identifying addresses within country borders, which suggest that it will be possible. But I don't have a sense of how hard/expensive it would be, which is an eval criteria we need.

Does anyone have insights they can share on this? Thank you!!


texts:
I'm trying to edit the settings for an existing custom fields group. When I make the changes and save it, I get this:
Please correct the following errors in the form fields below:
Custom group 'Training Information' already exists in Database.


texts: I have set the fiscal year under administer->Localization->Date Formats. However, when looking at Summary Fields, it continues to calculate only calendar year contributions for the Total Contributions this Fiscal Year category. How do I correct?


texts: Save before custom fields load overwrites with blank record

texts:
Is there a patch for this.
I have an activity with quite a lot of custom fields and lookup fields.   The loading of the custom section takes quite a time, but the Save button is already displayed.
If you hit the SAVE before the custom fields are loaded, then the record is saved with blank data - overwriting the existing data.
It does not validate against the custom data - otherwise that would fail - it goes direct to overwriting.


texts: How to set up accounts to issue reverse (credit) an event payment

texts:
I have Civicontribute set up to invoice conference delegates, but can't work out how to set up the accounts to issue credit notes for booking changes or cancellations.

I get an error "This financial account cannot have 'Credit/Contra Revenue Account is' relationship" no matter which account I try to assign.

My setup has the following:

Income Account is    Event Fee   Revenue (INC)
Accounts Receivable Account is    Accounts Receivable   Asset (AR)
Expense Account is    Banking Fees   Expenses (EXP)
Cost of Sales Account is Premiums    Cost of Sales (COGS)
Deferred Revenue Account is  Deferred Revenue - Event Fee Liability (OCLIAB)

My accounts setup simply reverses the credit against the Events Fee income account.  Can someone give me some guidance please?


texts: Why am I getting this error when using CiviRules

texts:
I'm on D7, Civi 4.6.10, most recent version of civiRules, twilio sms extension.

I get the below errors when I add a rule as follows:
1. create new rule.
2. name: SMS Birthday, trigger: Individual has Birthday
3. add action: Send SMS, Delay action: by number of minutes 540 (my thinking is this will delay the text message till at least 8am)
4. Click Save and get the errors below:

Notice: Undefined index: ignore_condition_with_delay in CRM_Civirules_Form_RuleAction->postProcess() (line 88 of /home/web_location/civicrm_extensions/org.civicoop.civirules/CRM/Civirules/Form/RuleAction.php).
Strict warning: Declaration of CRM_Smsapi_CivirulesAction::alterApiParameters() should be compatible with CRM_CivirulesActions_Generic_Api::alterApiParameters($parameters, CRM_Civirules_TriggerData_TriggerData $triggerData) in require_once() (line 9 of /home/web_location/civicrm_extensions/org.civicoop.smsapi/CRM/Smsapi/CivirulesAction.php).


texts: How To Migrate CiviCRM From Wordpress To Drupal?

texts: We are using CiviCRM with Wordpress and would like to switch it to Drupal. I have created a fresh Drupal/CiviCRM install and gave CiviCRM it's own database. How do I go about transferring the data from the old Wordpress site to the new Drupal site?


texts: Drupal AJAX HTTP Request terminated Abnormally after file upload

texts: I am getting the following error (as shown) when trying to upload a file to a normal content type. This started happening after migration of the Drupal site to a new server and more than one site hosting on this server seems to be having this problem. Not quite sure what the cause could be at this point.


texts: How do I fix the "Incorrect Resource URL" alert?

texts: I've just a done a clean install by the book of CiviCRM 5.24 on Drupal 7. The installation went smoothly. Now I'm seeing an alert about the Resource URL being incorrect (it isn't). I seem to recall that this was an issue a year or so ago. Is this a regression that has crept in to the latest version, or am I doing something wrong? I have other D7/Civi installs on the same server, all with earlier versions of CiviCRM, and none of them are exhibiting this behaviour.


texts: Importing contributions with soft credits fails with spurious email error

texts: I'm trying to import some contributions. Each contribution has a soft credit field which is an email address. I've set the field mapping to Soft Credit / Email / Solicited. All the rows are failing with Invalid email address(doesn't exist) <email> for Soft Credit. Row was skipped but there are contacts with those email addresses.


texts: How can I view my activity attachments inline (i.e. on the webpage)?

texts:
When I view an activity, I can see there are several attached images.  Is there a way to have the images show up on the activity "view" page?
I know how to write an extension to do this; I'm looking for answers that show extensions that are already written, or configurations I hadn't considered.
This is on WordPress, to preclude the "use Views" answers :)