texts:
I have been using CiviCRM for over five years.  I am trying to encourage a local charity who provides care to vulnerable people to move to CiviCRM.  I have been asked by the project manager the following "I am looking at the security of CiviCRM and wonder if there has been any security testing of the product that you are aware of e.g. hacking of the website or the database? Has there been any penetration of the site performed?"  I would like to respond to them and would be grateful for any help, or advice on this.
Regards
Graham Clarkson


texts: after upgrade, can't edit Contact Details fields (Custom Addressee and de-selected subtypes errors)

texts:
I've just updated a Joomla 2.5.28 site from an older version of CiviCRM (4.4) to the latest 4.7.29.  Now I can't edit any of the fields under the "Contact Details" pane for existing records.

There are two errors:

When editing these fields for contacts that have custom subtypes, a popup appears saying "One or more contact subtypes have been de-selected from the list for this contact. Any custom data associated with de-selected subtype will be removed as long as the contact does not have a contact subtype still selected. Click OK to proceed, or Cancel to review your changes before saving."
For all contacts (including custom subtypes from item 1 above), saving doesn't work and throws this error:  "Custom Addressee is a required field if Addressee is of type Customized."

It's also interesting that I can create NEW records of contact subtypes, but get the errors again if I try to update the Contact Details of the new record.

I found this post (Why after importing contact records were Addressee field values set to "Customized" for records where Custom Addressee had a null value?) which seems to address issue #1, but I'm a bit stumped as to issue #2.  And I didn't want to try the correction suggested in this post until I knew if the two issues could be related.

Site details:
Joomla 2.5.28
CiviCRM 4.7.29


texts:
It appears that Scheduled Jobs for sendmail is throwing memory errors. After it was observed that mail was not sending, I attempted to "Execute Now" from the admin area.

Fatal error: Out of memory (allocated 120848384) (tried to allocate 21703932 bytes) in /home/[site]/www/www/sites/all/modules/civicrm/packages/Mail/mimePart.php on line 313

My host increased my memory, "We just increased your account's memory limit from 195 MB to 295 MB. We applied the changes in your global php.ini settings as well."

Now the error reads:

Fatal error: Out of memory (allocated 203685888) (tried to allocate 29831950 bytes) in /home/[site]/www/www/sites/all/modules/civicrm/packages/Mail/mime.php on line 1030

Any suggestions?


texts: Cloudflare kills dashboard + Relationship tab error. Any ideas?

texts:
Drupal 6.36;  CiviCRM 4.5.8
I am experiencing two problems after making changes to my site. Not sure if the problems are related. I will start troubleshooting but any guidance would be very helpful.
1. Civi dashboard loading icon spins and dashlets don't load. This may be related to us installing Cloudflare (http://forum.civicrm.org/index.php/topic,27176.msg142612.html#msg142612).
2. Relationships tab generates error on click. Screen loads but the relationships list doesn't open. The following two popups appear:

DataTables warning: table id=DataTables_Table_0 - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1
DataTables warning: table id=DataTables_Table_1 - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1

Clicking the Add relationship button opens the dialogue and allows it to be completed, but on saving the above errors appear again.
Background:

Moved the site to a faster server with no apparent problems
6 hrs later...
Upgraded Drupal 6.36 security release. All seems fine.
Tried to install Civi4.6.4 but it errored out so I reverted to the
4.5.8 backup. It was late and I didn't copy the error :-(
Implemented Cloudflare. Civi is appreciably faster. Cloudflare needs www. domains so I set up a redirect in htaccess and updated the Civi paths and resource URLs. Also cleared all caches

Thanks
Davy


texts: Can't create new events from template after upgrade to 5.9

texts:
I recently upgraded to CiviCRM 5.9, WordPress 5.0.3 and PHP 7.2. Now when I try to create a new event from a template, after clicking 'continue' the template is cloned and I'm thrown into a template editing page. The new event is never created.

This happens both with pre-existing templates and with a completely new template. It does not happen with new events created without a template.

It is essentially the inverse of this bug that was patched last February - not sure if this is an unintended side-effect, or if I've set something up weird.


texts: We are a non profit volunteer group with 16000 members. Our members are household members and then have individuals with a relationship link. One issue that is bugging us is that when we look for example at our membership list, the household name is that of the last name of the household. EG Smith. However we have 92 "smiths". What is the best way to narrow down which smith we are looking at. Should we also include after their last name a comma followed by eg Tony & Michelle? Our volunteers sometimes need to quickly look at the persons name and choose their record. Or is their a better way.


texts: SMTP errors with "Thank You Letters - print or email" -- does this use CiviMail settings?

texts:
I'm on CiviCRM 5.9 on WordPress. We just did our first batch of year-end contribution summary letters, and ran into an issue when choosing the "Send emails where possible. Generate printable PDFs for contacts who cannot receive email" option. We have a total of about 550 letters/emails to send.

We're using G Suite as the SMTP server, and in looking at the logs, it looks like Google started rejecting the emails after about 100 or so had been sent. The resultant PDF of letters wound up with about 450 pages, including many contacts who do have email addresses (and therefore should have been sent an email).

Since this is my first time doing this and we don't send out any other bulk emails, I took at look at the CiviMail settings and they're all set to the defaults (0 across the board), which is I assume what caused the issue. But I wasn't sure if the specific "Thank You Letters" function actually used those settings or not.

For reference here's the error message in the logs:

Jan 31 15:29:08  [info] Ignoring exception thrown by nullHandler: 10004, Failed to set sender: EMAIL_ADDRESS_HERE [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: 421, response: 4.7.0 Try again later, closing connection. (MAIL) z7sm8172274pga.6 - gsmtp)]

I verified the settings are correct, and I can send test emails from the settings page fine, but my guess is I triggered a block on the Google side, so I wanted to make sure that if I update the settings and try again that those actually apply to this particular task.

As for the actual settings for Google, I came across these:
Questions About Mailer Settings - Suggested G Suite settings?

Are those good settings? Anyone else using G Suite as SMTP have any other advice on settings, particularly as relates to sending out Thank You letters?

Thanks!


texts: Why can't I create a payment processor in multisite?

texts: I have a multisite setup with a payment processor defined in one site. When I try to create one in the other site, it does not save and I get this error: "Expected one PaymentProcessor but found 2".


texts: Webform CiviCRM, add contact to a group programatically

texts:
I want to add a contact to a group created from a Webform CiviCRM, depending on the fields' values.

I don't find where I should place this logic:

In hook hook_civicrm_post, I don't have the origin (webform) of the contact created.
The place should be in Drupal / Webform hooks, but I don't know how to "inject" the group to be assigned to the contact, to be processed by webform_civicrm.

Any ideas?

Working with CiviCRM 4.6.30, webform 7.x-4.15, webform_civicrm 7.x-4.18


texts: How do you update the contact information of someone in CiviCRM?

texts:
According to CiviCRM API documentation, the .create() function with a specified contact ID should modify the records within CiviCRM; however, even after trying that, I still can't seem to properly push changes to CiviCRM.

In the code below, I'm trying to change Jane Doe's gender from "1" to "2", and when I change that by setting val.gender_id="2", it prints out the right result. However, when I try to "get" Jane Doe's information afterwards, it prints her gender_id as "1". So, it doesn't actually update the CiviCRM database.

Is there a way to fix this?

//TESTING FOR UPDATING CONTACT INFORMATION OF 'JANE DOE' in CIVICRM DATABASE

crmAPI.create('contact', {id:'12966'},
  function (result) {
      console.log(result);
      val=result.values[0];
      val.gender_id='2';
      console.log('UPDATED CONTACT: '+ val.display_name + " " + val.gender_id + " " + val.country_id);

crmAPI.get('contact', {id:'12966'},
  function(result) {
    console.log(result);
    for (var i in result.values) {
      val=result.values[i];
      console.log(val.display_name + " " + val.gender_id + " " + val.country_id);
    }
  }
);

});


texts: Multiple participant registration not tied to contribution for paid events?

texts:
When registering multiple participants for a paid event, only the first participant has a contribution attached to them. Each subsequent participant shows up correctly, but has no attached contribution or any payment information.

Checking the participant_payment table, no entry is created for the additional participants.

Is there a way to track payments or the contact who registered them for these additional participants?

Examples from the Civi 4.7 Demo site -

User with contribution:

User without contribution:


texts: CiviCase: Accordions not toggle ("Roles" "Activities"). Menu Options ("Add Activity" etc.) not "auto-trigger," Admin menus at top of screen not open

texts:
CiviCRM 4.6.8; Drupal 7.39

Everything seems normal when I go to the dashboard initially. I click "Manage" to open a previous case. On the case management page that follows, pretty much all menus and accordions are non-responsive.

Screenshot:

I recently created and installed a new Drupal Theme, but it all worked fine in the development and test environments, and the issue persists whether I'm in the new theme or the old theme (where it worked fine). However... I went back to my dev and test environments and it's failing now. What the hey? I tried clearing caches (CiviCRM and browser) and the issue persists.


texts: Profiles - Pre Field and Post Field Help

texts:
I'm working in with civi 4.6.4 in Wordpress, I used to be a Joomla user with a out of date civi and of course there are some changes to how profile fields render.

Previously all the content, pre field help, profile fields and post field help were in one div. Now they are broken into three separate divs, which is totally fine, I can see the advantages!! But the pre-field help and post field help have the same class and id, which is less than helpful. I can not target them separately (i.e. with css or javascript). Would it be too much to ask these be given separate ids in the future? Or has anyone come up with a way to target them separately without having to add code in with the whatever instructions you type?


texts:
Does anyone happen to know how to get around having to set up a "Personal Campaign Page" - when making a "Contribution Page" (Our hope was to use a Contribution Page to collect donations via our Website.., We don't need Personal Campaign Pages, to do that.
I can't proceed without sending up a Personal Campaign Pages for some reason?


texts: Drupal Core Search to show results from CiviCRM Events data along with drupal content results

texts:
I'm looking for a solution to extend Drupal Core Search functionality to fetch results from Civicrm Events.

Did anyone tried or achieved this? Is there any module to achieve this? any configurations? or any pointers please?

Does CiviCRM Entity module helps to achieve this?

I want drupal to search CiviCRM events along with entire drupal site when someone search for event related content

TIA


texts: 403 - Forbidden Error on Dashboard Modules

texts:
We suddenly started receiving a "403 - Forbidden Error" on the dashboard modules. This is not an issue itself, however, at the same time the gridlines on the PDF reports have disappeared. Are these two issues connected? Either way any reason as to why the gridlines have disappeared?

We are running CiviCRM 4.6.10 on drupal 7.


texts: How to make webform forget a selected event?

texts: I'm using Views to display some events, the user clicks on one and that fires up a webform where they can sign up for the chosen event (so passing the event id in the url).  All working well but...if the user then selects a different event in the webform (not unreasonable) then that event becomes the default event - and won't go away.  Even when the user later selects a different event in Views, when they come to the webform the previously chosen event will be selected - not the one they selected and was passed in the url.  This feels like a bug, and should be easy to reproduce, but maybe there's an explanation or way of stopping this? (Upgraded to latest 5.3.1 still same problem). First screenshot is Views & you can see the url correctly generated for event id 19.  Second screen shows event on Aug 4 incorrectly selected which is event id 18 (I selected this at a previous time)


texts: Using Search Builder to search on a field with custom location gives DB error

texts:
On current CiviCRM demo site (4.6.10) if you

add a new location type, then populate a contact with an email address of that location type, then use Search builder to search for email address with location type, it gives error:

DB Error: syntax error


texts:
Fatal error: Cannot redeclare _PEAR_call_destructors() (previously
  declared in /usr/share/php/PEAR.php:735) in
  /www/htdocs/w010699b/de/wsk/prod/cms-crm/sites/all/modules/civicrm/packages/PEAR.php
  on line 811

Every time I do a module update I get this error message. With a second or third attempt, the system did a clean start again without this error. Today, after updating metatags, I couldn't start the webpage anymore due to this error.

So I renamed pear.php in civicrm/packages to pear.php.bak which let me access the homepage. Selecting another page resulted in errors due to the missing pear.php. So I renamed pear.php.bak back to pear.php and now it works correctly.

Obviously after a module update there is an attempt to declare pear functions a second time. But why? And how may I find what causes this error?


texts: Can I set an entire membership type to expire, or cease to auto-renew?

texts: I have a membership type which  can auto-renew, and is monthly for a fixed amount of time after which it ends on a specific date. Can I set that up so that the membership automatically ends for all members? Essentially, I want auto-renew to turn off on that date, for everyone. I can go through and do it manually if necessary, but I'd really love the solution to be scalable, and automatic would be much better.


texts: Joomla account creation fields not appearing on profile forms

texts:
I have exactly the problem listed in this forum post:

https://forum.civicrm.org/index.php?topic=11260.0

I'm not able to create any Joomla user via a CiviCRM profile form, because the Joomla user registration fields do not appear on the profile.

the "Allow User Registration" option in User Manager is set to "yes"
I've tried setting profiles to both "Give option" and "Require" Joomla account creation
I've tried custom and simple out-of-the-box profiles
Permissions all seem to be correct (anonymous users are allowed to create profiles, see all custom data fields, etc.)

I do also have Community Builder installed, but as far as I could discover that shouldn't cause any problems with the fields appearing.

Any ideas what else to check, or how to troubleshoot this further?


texts: Pay later payment method does not get overwritten when payment is made

texts:
When someone selects Pay Later, the payment method defaults to Cheque.

When they pay, we record the payment method they used, for example, Bank Transfer.

When I do a search on contributions made by Bank Transfer I get no results, because the original payment method of Cheque persists on the record.

Is this a bug?

WHat I want to happen is that the original payment method of cheque is overridden by the actual payment method used when payment was finally made.


texts: Why am I getting error messages when trying to search for cases in CiviCase?

texts:
I am using Wordpress 4.4.2 and recently upgraded to CiviCrm 4.7.3.
When I try to search for cases under the "find cases" menu, I keep getting the following error messages:

Warning: Invalid argument supplied for foreach() in /home/hillcrest/www/www/wp-content/plugins/civicrm/civicrm/CRM/Case/XMLProcessor/Process.php on line 186

Warning: Invalid argument supplied for foreach() in /home/hillcrest/www/www/wp-content/plugins/civicrm/civicrm/CRM/Case/XMLProcessor/Process.php on line 186

Warning: Invalid argument supplied for foreach() in /home/hillcrest/www/www/wp-content/plugins/civicrm/civicrm/CRM/Case/XMLProcessor/Process.php on line 186

Warning: Cannot modify header information - headers already sent by (output started at /home/hillcrest/www/www/wp-content/plugins/civicrm/civicrm/CRM/Case/XMLProcessor/Process.php:186) in /home/hillcrest/www/www/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/Base.php on line 895


texts: tags inserted in rich text fields custom fieldsets when displayed as tabs

texts:
I am looking at a site where there is an extra <br> tag being inserted between all elements in rich-text fields in custom fieldsets, including between list items! And two being inserted between paragraphs. The html is clean in the editor, but this is how it's being rendered on the front-end. This is only happening when the fieldset is set to display as a tab. As soon as you move it 'inline', the problem goes away. Site is using default CKEditor.

Any ideas about why this could be happening and how to fix it? Thank you.


texts: When adding an activity, a new contact can be created, but it only asks for name and email. How to configure (add fields)?

texts:
When a CiviCRM user adds an activity, there is an option of adding a new contact through a pop-up (instead of selecting a contact). I can't find any documentation on whether/how this form can be customized. I'm also not a programmer.

For the organization I work for, it would be extremely helpful to be able to add a bit more info at this stage (at least the phone number, ideally a few other fields). To do so, do we need to modify code (and if so, where) or is there an easier way to configure which fields appear here (ideally through profile, I suppose)?

Thanks!


texts: Registering someone who had a friend buy the tickets

texts:
I have someone who purchased three tickets and I know the names of their guests and they are in the contacts. But, the ticket prices are discounted due to the group rate and was purchased by one person. What is the best way to make sure I have record of someone attending an event if someone else paid for their ticket and the purchase already affected the total count for the event?  I thought of maybe adding them in as a comp, but that would affect the guest count. I want to be able to record in a way that I can make sure they are included on an attendee report.

I am not sure if there is a way to tag additional contact in a particular registration somehow?


texts: GDPR Extention and PETITIONs (in Wordpress)

texts:
(CiviCRM on Wordpress) We see that in Petitions it is not possible to activate the GDPR Extention for Privacy Policy Acceptance. How is it possible? Are we wrong?

The Privacy Policy Acceptance following a Petition signature does not seem prohibited by the GDPR.

Do we get the same result with a work-arround?


texts:
I am having a problem with custom general rules for deduping.  Very inconsistent results that cause me to suspect that there may be significant issues.   One strange observation is that at times a general clearing of caches makes a difference.  But even that is not consistent and problematic if a rule is being used by a webform, for example.

Are users have success with general rules? Failures? My test case is using First Name, Last Name and birth date. Is this a case where a general rewrite is needed and perhaps a Make It Happen campaign?

Any insights would be appreciated.


texts:
We want to store some global variables for token substitution in civicrm. Think of adding current members of board of managers to letters or other phrases to use in mailings or pdf letters.

Example: token

{board_members}

should be substitued by

Jane Doe

Jim Jones

Bud Foo

Frieda Bar

Any idea how to store (editable by our staff)? Or should I misuse message templates to store the content? Say I'll create a message template "Board members (don't use as template)". Or an inactive message template?


texts:
Our priority is Name Surname and Phone Number while we are creating a New Individual Entry
However when the same info is written, the system doesn't give a warning, which causes to create new accounts with the existed info beforehand.
to solve this problem i have examined this essay below but i haven't got the desired results.
https://civicrm.org/blog/spidersilk/understanding-civicrm-dedupe-rules

What i want is that the system shall not let me to create New Individual Entry if there is this phone number in somebody's profile already.

Could you please launch a "Matching Rule for Individual Contacts" to this.

Joomla! 3.6.5 - CiviCRM 4.7.17


texts:
I need to add image(no public) in a email. Initially I tried "Inline Embedding" but gmail, ... block the images, now I'm trying to add with "CID Embedded Images"

Exist some way to add the Content-ID in the attached files.

$params["attachments"][] =  array(
      'fullPath' => $output,
      'Content-ID' => 'attachementsignature' //Something like that
    );

Info "Inline Embedding", "CID Embedded Images" in
https://sendgrid.com/blog/embedding-images-emails-facts/


texts: How do i resolve unable to access 'https://github.com/civicrm/civicrm-backdrop.git/

texts:
I have cloned civicrm-buildkit-docker and started to create a dmaster demo site with docker-compose exec -u buildkit civicrm civibuild create dmaster

This will give me the below error

  fatal: unable to access
  'https://github.com/civicrm/civicrm-backdrop.git/': Could not resolve
  host: github.com

I tried

git config --global http.proxy http://proxyuser:proxypwd@proxy.server.com:8080,
git config --global --unset http.proxy and
git config --global --unset https.proxy

They didn't work. How should i resolve this ?


texts: Update particular contribute based on contribute id with civicrm_api3

texts:
I am working with civi 5.10. How can i update the conribution table row based on contribute id .  I want replace that below  code with civicrm_api3().

        db_update('civicrm_contribution') // Table name no longer needs {}
        ->fields(array(
        'contribution_status_id' => $contribution_status_id,
        ))
        ->condition('id', $contrib_data[0]->id, '=')
        ->execute();


texts: Tracking on Civimail suddenly stopped working

texts:
Morning all

Civi 4.7.14 Wordpress 4.7.5  Using Mosaico (the original one)

All's been going fine for months and months.. suddenly the tracking has stopped working. The emails are being received..just not being reported.

I tried this suggestion: CiviMail tracking opens stopped working after upgrade to 4.7.x

ie cut and paste this link
img src="https://yoursite.org/sites/all/modules/civicrm/extern/open.php?q=91954565" width='1' height='1' alt='' border='0'

but got a black screen- no error message- which I guess is what I'm supposed to get?

thanks for any suggestions


texts: How to fix "Database In Unexpected Version"

texts:
I am starting to use CiviCRM under Drupal 7 and feel myself still as a newbie.

I made a backup with the Backup and Migrate module of Drupal (site + DB). As a good practice, I tried immediately after the backup to restore the backup, just to learn how to do in case of trouble.

I better did not because I got the error message:

Your database is marked with an unexpected version number: 5.22.0.
The v5.20.2 codebase may not be compatible with your database state.
You will need to determine the correct version corresponding to your current database state.
You may want to revert to the codebase you were using until you resolve this problem.

The menus of CiviCRM are now at the bottom of the screen with an ugly layout.

So backing up and restoring with the module Backup and Migrate seems to be a perfect instrument of (hopefully partial) self-destruction of Drupal or CiviCRM.

I have no idea on how to "revert to the codebase you were using until you resolve this problem". Any help will be appreciated.


texts: Can I set permissions to see one type of contribution, but not another?

texts:
We have a number of staff who should have access to see event payment information, but who should not see donation information.  Is there a way to set permissions via ACL or otherwise based on Financial Type of the contribution?

Civi 4.6.6 -- soon to be 4.7; Drupal 7.41


texts: Can't extract latest civicrm-4.7.22-drupal.tar.gz to install

texts:
Trying to upgrade civicrm for drupal to 4.7.22 on a linux machine.  I've tried downloading the file from both the civicrm.org site and sourcefourge.  Get the following error when extracting:

tar -xzf civicrm-4.7.22-drupal.tar.gz

  tar: civicrm/vendor/pear/net_smtp/README.rst: Cannot create symlink to
  `docs/guide.txt': No such file or directory tar: Exiting with failure
  status due to previous errors

I then extracted using 7-zip on a windows 10 machine, hoping to ftp the folder up directly, but not all the folders are there.

The sourceforge extracted civicrm folder is different from the one I downloaded from the civicrm site (using beyond compare).  I'm not confident installing either one.


texts:
We are looking for a way for multiple branches of our organization to maintain separate CiviCRM installs while syncing a particular group of contacts with each other. WE thought of using Mailchimp to hold the master list and have each install sync with that. BUt the current extension only seems to handle fname,lname and email fields.

Long ago some posted this:
https://forum.civicrm.org/index.php%3Ftopic=3070.0.html
which describes a similar need.

Is there any code already developed for this?


texts: I have a list of contacts exported in an Excel. Now I want to adding the same activity to all of them

texts:
I've exported a list of approx 200 contacts from Civic, including contactname.
I'd like to add in one go the same acticity (i.e. delivery of a brochure) to all of them, avoiding to add that activity manually one by one.
Is there a way to massively add the same activity to several contacts?
Thanks in advance for your support


texts: Add confirmation notification after submit in civicrm form in Wordpress

texts:
this is a simple implementation of a CiviCRM form in Wordpress which I want to show success notification after submit.

<form  action="https://crm.mfc.org.pl/civicrm/profile/create?gid=25&amp;reset=1" method="post" name="form" id="form33">
<input type="text" id="name" placeholder="First Name" required="required" /></div>
<input type="email" id="email" placeholder="Email" required="required" title="Please Provide A Valid Email Address !" />
<input value="SUBSCRIBE" type="submit"/>
</form>

  For example after submit popup to says "Thank you for subscribing". Or the form to disappear and this text to stay on the form place.
  Now after submit nothing happens, just the page reload. Do you know how can I do it?

Thank you in advance!


texts: Cannot get replies to show up in activities

texts:
CiviCRM 5.14.0

I have bounce processing working fine but I am trying to track replies. Replies are sent using a VERP address and are being received in the correct mailbox as defined in the CiviMail Administer/CiviMail/Mail Accounts settings.

I run the Process Bounces job and I expect to see an entry in the activities for anyone who replies to the email but I only see the outgoing mail under the type BULK EMAIL. The replies are correctly being moved from the Inbox to the Processed folder that CiviCRM created.

Replies are being counted correctly in the report for the mailing but are not being added to the contacts' activities.

There is a setting under System Administration/CiviMail/CiviCRM Component Settings that seems to be in error. If it is checked, it disables VERP replies. Leaving it unchecked causes replies to use VERP. This seems to be a bug.

A Workaround

As I have access to the Postfix server, I was able to move the processed emails from the "Bouncer" mailbox to the Inbox of the "Activities" mailbox then run the fetch-activities job. This successfully processed the replies and inserted them in the activities table.


texts: We are looking to include a sign-up form using a CiviCRM profile or some other method on our Facebook page. Does anyone have any recommendations for tools that can do this? I assume it is a matter of including the HTML code snippet  from the CiviCRM profile in iframe on Facebook.


texts: Is there a way for Memberships to be non-time dependant? educational course progress type?

texts:
I am new to CiviCRM, but really impressed so far!  However, am currently building out an educational franchise site that along with time based or session based (the rolling & fixed) memberships they also require a more open-ended and non-time based membership type.
For instance a membership that is active for as long as the student is moving through the educational course, and once they pass the final of that course and advance to the next level (or the next stage: group of course levels) they would then need to renew their membership for that next section of material (renew for the next course or set of courses).  Because the classes are ongoing and students move at their own pace, and also allow open enrollment, this is a critical piece for them.  They also have online courses, which also require membership to access that content.

We are using Drupal, and was planning on using drupal commerce module for these purchases prior to getting into Civi, however, we REALLY like the additional features of the Membership components of Civi, and also want to track/manage the users and their memberships through civi.

I have looked around a little, but unable to find reference on this kind of use case.
Any help on or direction would be MUCH APPRECIATED!!!
Thanks!


texts:
I have a contribution page set up that I'm sending users to using a link from a webform, which includes the cid and checksum so that the contribution page is prefilled with the user's data.

when the user submits the page, having selected the relevant payment options, the page is simply re-presented to them rather than taking them off to the payment processor, Paypal standard in this instance.

If I use the page as a logged in user, it works without a problem.

Running D7 and Civi 4.6.10 currently, although about to update to current 4.6.x. Is this a known issue?

Looking at Firebug, I can see that in the case where the user is not logged in, I'm seeing a 404 on a JS file (/sites/default/files/js/jquery.min.map;) which I don't get when logged in.

I'm thinking this may be theme-related?

Any ideas on how to debug or workaround?


texts: What's the best way to handle a matching donation?

texts: We often receive annual appeal donations that include a matching gift from the donor's employer.  Is there a better way to handle these other than creating a record for the employer, and soft-crediting the match to the donor?


texts: Resend a mailing to recipients who did not open

texts:
Our communications staff wants to be able to resend a mailing (or send a new mailing) to recipients who did not open a previous mailing. Of course, this is possible by creating a group from the "unique opens" of the first mailing, and then excluding that group in the new mailing.

Unfortunately, there are a number of steps with this, and it seems like a sufficiently useful workflow that I'd be interested in it as a new core feature. Other mass mailing services like Constant Contact have a "resend to non-openers" feature.

Before I open an feature request issue in lab.civicrm.org, I wanted to test it here to see if others feel it might be a worthwhile feature, or if there is some other way to streamline the workflow.


texts: exporting data with custom field nantionality exports country id instead of country name

texts:
I have a custom field nationality and after upgrading to Civi 4.6.9, i noticed that when i export contacts with custom field nationality, first entry has the name but the rest are the country ids, see screen shot.

I have also tested this on the demo site http://d46.demo.civicrm.org/ and it is the same problem


texts:
Using WordPress 5.4 and CiviCRM Version 5.18.4.  Hosting with InmotionDirect, managing via Cpanel.

Trying to follow the instructions to set up our cron job.  I got the command line to work, finally, as:
php public_html/wp-content/plugins/civicrm/civicrm/bin/cli.php -s [site] -u [user] -p [password] -e Job -a execute

It worked, and I thought I was done.  Plugged it into the Crom job list in Cpanel and sat back.

Error via email: "cli.php can only be run from command line."

Well, nobody mentioned that in the instructions.  Is that a universal rule, or is just my hosting service being fussy?

Based on an answer here (Setting up cron jobs on cPanel) I tried putting the command line in a file and having the cron job command be just sh thatfile.  Same error.

Is there a workaround?  Or do I have to manually install yet another program like wp-cli just to run my jobs?


texts: Activity changes individuals busy/available status

texts:
I'm looking to use CiviCRM to - in part - manage our team of around 50 volunteer translators. Once a volunteer has agreed to take on a translation, staff will set an activity, so that we can keep a record of how many translations people have done. I've set that up, with a number of custom fields for the volunteer contact, and for the activity (a URL of the original text, the date we should receive the translation, etc).

What I would like to be able to do but can't work out out the functionality of, is - once an activity has been assigned - for something in the volunteers contact sheet to display that they are currently translating (I can do this manually, but busy people probably won't necessarily always do two steps, so we could end up with activities being assigned but the translator still appearing "available"). This way when a staff person comes to search for a translator (by language to/from, and their availability) they only get shown volunteers who aren't currently completing activities.

Thanks!


texts: migrating civi database from current hosting to civihosting.com

texts:
We recently signed up for shared hosting at civihosting.com and want to move our current site there. Both sites are running CiviCRM 4.7.29 and WordPress 4.9.1.

I cannot get into the CiviCRM dashboard on the current site (the biggest reason we're moving to civihosting !), but do have access to the MySQL database.

For the WordPress migration, we have been using the export/import tool in WordPress successfully, so that doesn't seem to be a problem.

Can I simply export the CiviCRM database from the current hosting provider and import it into civihosting? I understand I should drop the current database at civihosting first? As far as I know, I won't be losing anything important (I haven't done much yet in CiviCRM at civihosting).

Also, does anyone know of step-by-step instructions somewhere for doing this?

I'm comfortable with phpMyAdmin, if that comes into the picture.

Thank you!


texts: Why does a profile 'redirect' url not work when 'html snippet' is used?

texts:
Question says it all. The profile has a url redirect set in Advanced Settings. The outcome of submitting the profile from another site is that the user ends up on the profile url of the original site, and hence the URL redirect seems to be ignored - and no evidence of it having been including in the code of the html snippet.

Is it not included because it would be 'impossible' or just wasn't thought of?


texts: Issues with Migration - Cannot add foreign key constraint

texts:
I'm having multiple issues with a CiviCRM 4.7.17 on WordPress 4.9.5 which has encouraged me to make different attempts to migrate the site following the official SysAdmin Guide. The closest I've gotten so far is:

Clean WordPress install
a migration of Wordpress.
Removed all CiviCRM plugin files, settings, and the civi sql tables.
Installed CiviCRM (same ver. as the original site) but I made a separate SQL database - could this cause issues when migrating?

Attempted to import the original civi database via phpmyadmin but receive the following:

  CREATE TABLE `civicrm_acl` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Unique table ID',
  `name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'ACL Name.',
  `deny` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Is this ACL entry Allow  (0) or Deny (1) ?',
  `entity_table` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Table of the object possessing this ACL entry (Contact, Group, or ACL Group)',
  `entity_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'ID of the object possessing this ACL',
  `operation` varchar(8) COLLATE utf8_unicode_ci NOT NULL COMMENT 'What operation does this ACL entry control?',
  `object_table` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'The table of the object controlled by this ACL entry',
  `object_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'The ID of the object controlled by this ACL entry',
  `acl_table` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'If this is a grant/revoke entry, what table are we granting?',
  `acl_id` i[...]
MySQL said: Documentation

#1215 - Cannot add foreign key constraint

After looking at various posts with similar errors, I can't make the import work. What gives?

I believe the database itself is screwed up beyond my limited understanding which makes me think a "start from scratch" would be useful but losing all the data isn't acceptable. (One issue I've been having lead me realize other things were wrong: Contacts not merged When creating Account on Event Page - DB Error: already exists)

Is it at all possible to export all the data that's been user-created with Civi to import on a clean Civi install besides the way listed in the SysAdmin guide?

ie. Move contacts (I know this can be exported via Civi), their history, custom profiles, custom fields, events, etc. to the testing site.


texts: Webform CiviCRM Payment on Page 1 of Webform?

texts:
Is it possible on any version of Webform CiviCRM, D7, Webform Civicrm?

The profile, amounts, payment - all on one page.

Ironically, we want to go back to 1 page form after users complain of "too many clicks".

Note:
civicrm_1_membership_1_membership_fee_amount is a number field with https://www.drupal.org/project/sliderfield as the widget, which could be the culprit

Edit: I deleted the page break, and it does not show the updated "line item" amounts when the user makes choices. Any way around that?

Edit, just to think out loud, if we could get a native form-builder version of our membership pages with some custom widgets available, that would also be a way to solve this perhaps?


texts: have different events for different user groups

texts:
I have users in different groups.depending on the group they are in when they see the events listing, I'd like them to only see events that are relevant to them based on the group(s) they are in.
For example, let's say I have users in 3 groups: Board member, Manager, employee. The board member gets to see events for all groups. The manager only gets to see manager events. The employee gets to see events for employee and manager.and also I'd like every group have their own calendar.
(CiviCRM 4.7.25 on Wordpress 4.8?)


texts: CiviMail was sending mails, now it isn't

texts:
I could really use some guidance on how to troubleshoot this. This morning, we sent an email out to about 100 addresses using CiviMail and it worked fine.

Now, we can't. We didn't make any changes in the meantime. I can't send a test email, and when we schedule a job and the cron runs, CiviCRM shows it as successful, but no one is receiving emails.

When I log the mail to a file, we can see it going there, it's just not getting sent out. Other mail from contacts or the test mail() function still works.

I've checked the logs and can't see anything. Our hosting provider is not being helpful right now, and I could use some other guidance on information I can provide them to help troubleshoot. I could also use some suggestions on where to look in Civic.

I know everyone says "it used to work". Honestly, it really did.

We are using 4.7.15 with wordpress.


texts: Does archiving mailings do anything in particular?

texts:
CiviMail has an option to archive mailings (when browsing mailings).

Does changing the status to archived have any concrete impact on mailings, such as cleaning up information in the database? If not, what's the main use case for it?


texts: Can't select Mailing Template in CiviMail after upgrading CiviCRM to 4.7.30

texts:
After upgrading Civi to 4.7.30 the Template dropdown on the New Mailing screen has disappeared - the only option is to save to a new one:

We upgraded from Civi 4.7.29 to 4.7.30 on Joomla 3.8.5, but the same happens in a pristine 4.7.30 on Wordpress 4.9.4 environment.

Opening the Javascript Console in Firefox gave me this:

It appears a ~/crmMailing/Templates.html is missing, called from Templates.js in the same folder /civicrm/ang/crmMailing/.

Anyone able to reproduce this?

Thanks for your help,


texts: How can I add Recaptcha Version 2 for civicrm 4.3

texts:
"You are receiving this email because you are registered as a website
  administrator using reCAPTCHA, and your website is still using
  reCAPTCHA v1, which will be turned off on March 31, 2018. We announced
  the reCAPTCHA v1 deprecation in May 2016. Starting in November 2017, a
  small percentage of reCAPTCHA v1 traffic will begin to show a notice
  informing users that the old API will soon be retired. Any calls to
  the v1 API will not work after March 31, 2018. To ensure continued
  functionality, you’ll need to update your website to a current version
  of reCAPTCHA. You can learn more about reCAPTCHA v2, Invisible
  reCAPTCHA and reCAPTCHA Android API in our Developer’s Guide. The new
  APIs are simple to implement and will streamline the captcha
  experience for your users. If you need help, you can engage in the
  reCAPTCHA Google Developer Group or post to Stack Overflow with the
  ‘recaptcha’ tag."

How can I update the recaptcha in civicrm to v2 , where should I make the changes in the code and in frontend to make the recaptcha functionality to work in tandem with v2 ?


texts: Joomla! Undefined! Method! Error! Goes! Away! On! Refresh!

texts:
Fatal error: Call to undefined method CRM_Core_BAO_SchemaHandler::getMissingIndices() in /home/reports/public_html/administrator/components/com_civicrm/civicrm/CRM/Utils/Check/Component/Schema.php on line 40

This error appears after logging in and navigating to CiviCRM. Upon refreshing, this error disappears, and Civi works as normal. Clearing the Civi cache makes it appear again, before refreshing the screen again fixes it.

What could be causing this, and how can we solve it?

I thought file perms, but those all look ok.

JohnFF


texts: After upgrade to 4.7.23., icons do not show (Civicrm on WordPress) (SOLVED)

texts:
As you can see in the picture below, icons do not show. They are missing on all pages, also on buttons. This does not change after emptying cache and rebuilding the menu. I've also checked the resource URL, and it seems to be correct. Do you have any idea, what might be the problem?
Thanks a lot in advance and best regards!!


texts:
We are a member organizations made up of other organizations.  We extend user logins to the members only section of our Joomla website to all staff members of our member organizations to access exclusive content.  Right now Organizations get an "Organization login" when they join, but to get staff their own logins to register for events and see content, they have to email or call.   We used to just use "Organization Logins" but that caused too many issues with data improperly being overwritten when registering for events (despite warnings on the forms).

I'd like to create a User ID Registration form that is only accessible behind the member paywall so that organizations can create logins for their staff. I created a profile with a user id creating required. What I've come up with so far isn't working because by requiring the Organization to login, when they get to the User ID creation form it wont create a new user ID because the organization obviously already has one. Any suggestions for getting around this?

Thanks.


texts:
Currently running CiviCRM 4.6.8 and Drupal 7.

I want my Civi theme to be different than the one I'm using for the Drupal front end. I'm all but certain I used to be able to do this through Drupal's "Appearance" tab. In fact, I've read a couple of things after Googling it that suggest that there's an option to change Civi's theme in admin/appearance, but I don't see that option.

I also saw some articles mentioning an extension or a module that will do exactly what I'm looking for. I'll use it if I have to, but I'd rather use whatever features are included if I can.

Thanks for any advice!


texts: Is there a way to preserve existing data when importing into multiselect and checkbox fields?

texts:
My use case involves lots of importing, and extensive use of multiselect fields (to track things like skills, interests, etc). Sometimes we get new information about, for instance, an existing contact's skills. We want to include this new info in our import. But of course importing with "fill" overwrites the old information. We want to keep the old information and add the new information to it.

Unfortunately this is not something we thought about when we designed our fields and processes!

I am looking for advice on a (non-manual) process that a non-technical user could do to achieve the intended outcome (appending additional values to multiselect fields).

If anyone has any experience with this I would much appreciate your insight.


texts: CiviDiscount compatibility with CiviCRM 5.9

texts:
Is CiviDiscount compatible with CiviCRM 5.9?
We can't make it work with a 5.9 install on Joomla 3.9.1.
Thank you

Edit:
The issue is when trying to access the CiviDiscount GUI (e.g. Administer >> CiviDiscount), the user is taken to CiviCRM dashboard/home instead of the CiviDiscount UI.

I'm using a user in the Super Admin user group so it's not permissions related.

Discounts in the front end (both autodiscounts and entering a discount code), e.g. in event registration, work fine, but we can't administer the discounts.

Our work-around is to do this in the d/b.


texts:
Following links in Civicase dashboard (4.6.38) normally takes you through to a set of search results in the Find Cases search.

Initially cases are displayed by client name, alphabetically.

There are options to order by most recent activity date, or next scheduled activity date. When used neither of these display as expected. Results list neother in activity type order, or date order.

On closer inspection using the sort arrows by either options sorts the results in case id order.

Just checked and this behaviour is the same in sandbox.

1) Is this a known bug? If not which project should I post it in in the new tracker pages?

2) Anyone got any workarounds?fixes for this?

Cheers

Craig


texts: How to match Activities to Contacts during import?

texts:
We recently distributed supplies to many of our members and used a GoogleForm to create a .csv spreadsheet to track the number of supplies given to each member.  We imported the names of any new members into CiviCRM.

We would like to import the activities, but we are having trouble assigning the activities to the appropriate contact.

We have separate columns for first name, last name, address, but don't have emails for all contacts, and the .csv does not have a Contact ID for each contact.  How do we import the activities? We could also just create one activity and batch update the details, but in every case we can't seem to figure out how to get all the contacts assigned to the activity.  It's about 300 contacts, so we'd rather not enter it manually!


texts: settings_location.php - is there an example

texts:
I'm trying to browse images in wysiwyg editor (via the kcfinder) (for example Event description) but I get an error due to misconf.
I hits the file civicrm/civicrm/civicrm.config.php which loads civicrm/settings_location.php (which you have to create) but I'm missing something inside this file, Is there an example of it?


texts: CiviCRM 5.x is storing lot of empty records while sign petition

texts:
I am using Drupal 7 with CiviCRM 5.x version and I am not sure why but civicrm is storing lots of empty records(means no email, name etc) it just creates user record.

All these empty details records are created from petition page.

Is anyone faced same king of issue? any help is appreciate.


texts:
I'm getting this error pretty regularly lately, specifically after upgrading from 5.4.0 to 5.4.1:
The CiviCRM public extensions directory at https://civicrm.org/extdir/ver=5.4.1|cms=WordPress could not be contacted - please check your webserver can make external HTTP requests or contact CiviCRM team on CiviCRM forum.

My dashboard is also pretty frequently showing "Sorry but we are unable to provide this at the moment"

Weird thing is I have another test instance on 5.4.1 and it's working fine. (Both instances in question are running on Amazon Lightsail.)

Are there maybe some directory permissions or something along those lines I need to check? I did some basic checking between the test instance that's working and the one that isn't and didn't see anything obvious.

Thanks for any ideas anyone has.


texts: How can I send "Birthday wish" email to contact?

texts:
I have tried to create a smart group for the contact who's birthday is today and send an email via civirules, but search builder doesn't have option to set the date as "Today".

Is there any alternative way to achieve this?

Just wondering if anyone has worked on a similar flow and give a hint please?


texts: Adding dynamic data in CiviMail angular template

texts:
I have developed an extension which adds the possibility to add attachments to a message template. When a user select the template in CiviMail the linked attachments are also sent. This is working well.

But now I want to show which attachments are linked to a template when a user selects a template in the CiviMail UI.

In the old way I would add jQuery and an event listener to the drop down with templates and then fetch with Ajax the linked attachments and inject them somewhere in the screen. However CiviMail is now working with Angular and my understanding is that this should be much and much easier in Angular. However I have played around and can't get it working.

My question is how do I use angular to listen for a template change and then inject some data into the angular template?


texts: Recurring contributions cancelled in Civi NOT cancelled in Authorize.net

texts: Anyone having issues with recurring contributions being cancelled in Civi not being communicated to authorize.net in 4.7.9?


texts: Where are the 'Contributions - Receipt (on-line) templates stored?

texts: I want to customise on line receipts, but am struggling to make a start. I can see the on line receipt in the Message Templates - 'Contributions - Receipt (on-line)' but can't find where the other files associated with this template are located. The documentation doesn't seem to explain this at all.  I want to make the receipt look very different from the default.  Also if any one has some customised receipt templates they can share, that would be great too.  Thanks!


texts:
Can CiviCRM limit the number of event registrations for each member?

We have an event where they receive an automatic discount (because they are a member). However, we don't want them to buy the tickets for others at that price.

So we only want them to be able to register for each event, once. Is this possible?

Jon-man


texts: Responsive Email Layouts - Why move away from Smarty?

texts:
I'm looking at this GSoC project that I'm willing to take on.

https://wiki.civicrm.org/confluence/display/CRM/Google+Summer+of+Code+-+2016#GoogleSummerofCode-2016-responsivelayoutforemails

Which has "move away from smarty" on it's project description. Smarty, in the context of email messages, is used to replace the contact greeting names in email templates. So, I don't understand why we want to move away from smarty. Is it because we can accomplish the same task by using a simple PHP variable without having to use an extra library? What type of better solution are we looking for?


texts: Is it possible to set a Membership Status Override for a Membership Type?

texts:
I'm doing some testing and investigation into using CiviCRM for convention memberships.

These need to be able to be upgraded.

There is no membership type upgrade in CivCRM.

You can only memberships.

But it occurred to me that perhaps I could use Membership Status to hold what the current ACTUAL membership Status is.

The problem is, that I want membership Status to be be based on the Membership type, not the date that the membership /s are valid for. And there's no way to have any other criteria than dates.

Then I saw that when adding memberships manually, you can set a Status Override. This is probably exactly what I want. Except I can't see any way of setting a Status Override in a normal membership.  ie. IF someone buys a membership online, I can't have that membership THEY bought have a status override. Is there a way anyone can think to do this?


texts: Issue getting Email for Bounce Processing

texts:
I'm getting the following error when running the "Fetch Bounces" scheduled job:

Details

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

Full message:
Finished execution of Fetch Bounces with result: Failure, Error message: A fatal error was triggered: Could not connect to MailStore for ebounce@domain.com@imap.gmail.com
Error message:

An error occured while sending or receiving mail. Failed to connect to the server: imap.gmail.com:993.

The mailbox is a G Suite account, IMAP is configured, and I can connect to the mailbox via IMAP from an Outlook email client. The error appears in the job log immediately after running the job (there's no 30 second or longer delay that I would expect if it were timing out trying to connect to the mailbox).

Where can I look (or how can I get) some more detailed information on why this job might be failing so quickly?

As per the recommendation, we're running Wordpress 4.8 and CiviCRM 4.7.19

Thanks!


texts: Issue Setting CiviCRM up with Wordpress Multi-Site

texts:
I have a Wordpress multi-site installation in place that works fine and I have been trying to add CiviCRM to the multi-site but I am having problems when going through the documentation.

Now, I have installed CiviCRM on the main domain of the multisite and I have then followed the steps setup out in this documentation: https://wiki.civicrm.org/confluence/display/CRMDOC/Multi+Site+Installation

Everything goes fine until I get to point 5.C and edit the civicrm.settings.php file. Once I edit this file and insert the subdomains for the sub sites, the CiviCRM tab on the main site returns a server 500 error. It is only when I revert back to the original settings file that CiviCRM is able to load again.

Now as I have followed the documentation exactly I am stuck for why this is happening, or have I missed something?

Regards


texts: We're considering Civicrm for our membership database, but my client would like to see an example of what the look/feel would be for a new member signup. Is there an example/demo that someone can point me to?


texts:
With our CRM the unsubscribe button adds a user opt out for the bulk emails.

The CRM still sends bulk emails to people who use the unsubscribe button or has the do not email and opt out of bulk email options.

Any help would be great.


texts: Does webform civicrm update contribution_recur_id when creating recurring contribution and membership?

texts:
I am looking more closely at the data structure and it appears that when the form is submitted we get an unlinked recurring contribution series and membership. Is this by design or user error in configuration?

the details - the civicrm_membership table field 'contribution_recur_id' does not seem to have the recurring ID updated from the recurring profile the webform created

Is this how people are gaining the functionality? https://github.com/adixon/ca.civicrm.contributionrecur

Drupal 7 / up to date webform_civicrm and civi


texts: Display a Block on a specific Civi contribution page using a url alias (How to)

texts:
Drupal 7.6
Civi 5.4.1
I would like to display a Block on a Civi contribution page but I would also like to have the page have a pretty url rather than the Civi civicrm/contribute/transact?reset=1&id=8
Here I found help to add the block as long as I have the native Civi url. Any ideas on how I can display the block with a url alias in place?


texts: Where do I adjust the auto logout duration for administrators?

texts: This is my first time asking a question about CiviCRM and am not sure if I am even in the right place.


texts: "You do not have permission to access this page" on a CiviContribute confirmation page

texts:
I have a totally standard CiviContribute page on a system running CiviCRM 5.27.2 on top of WordPress. "Allow other amounts" is true. Minimum amount: $5. The default amount is also $5. Here's the behaviour I've noticed:

if I enter an extra amount of $5 and enter my credit card info then I get a permission denied page with the following backtrace:

or::backtrace("backTrace", TRUE)
#1 /home/ontar026/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(39): CRM_Core_Error::handleUnhandledException(Object(CR
M_Core_Exception))
#2 /home/ontar026/public_html/wp-content/plugins/civicrm/civicrm.php(1535): CRM_Core_Invoke::invoke((Array:3))
#3 /home/ontar026/public_html/wp-includes/class-wp-hook.php(287): CiviCRM_For_WordPress->invoke(Object(WP))
#4 /home/ontar026/public_html/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters(NULL, (Array:1))
#5 /home/ontar026/public_html/wp-includes/plugin.php(551): WP_Hook->do_action((Array:1))
#6 /home/ontar026/public_html/wp-includes/class-wp.php(758): do_action_ref_array("wp", (Array:1))
#7 /home/ontar026/public_html/wp-includes/functions.php(1291): WP->main("")
#8 /home/ontar026/public_html/wp-blog-header.php(16): wp()
#9 /home/ontar026/public_html/index.php(17): require("/home/ontar026/public_html/wp-blog-header.php")
#10 {main}

if I enable a confirmation page then it works fine for extra amount of $5
if I have no extra amount then it works fine

Of course all of this doesn't happen in test mode.
The permission that's failing is "access CiviCRM".
Any ideas on why this is happening?


texts: One of my clients' webhosts posted the SITE_KEY of their site on a publicly accessible webpage.  How do I generate a new SITE_KEY with the same random process that generated the original?


texts: Is there a way to remove text formatting when copy and pasting text into Activity details section?

texts: Some information that I add into Civi to record activities may be copied and pasted form a word document, an email etc. This looks fine on the activity when reading it on Civi, however when pulling reports as a cvc file the text is littered with jargon (something like: $n&*) where ever a bit of punctuation was. I know that it reads easier (without the jargon) if for each entry the user removes the formatting, however I wondered if there was a way to make this the default.


texts: Did my setting for checksum duration get overridden?

texts:
A site had a Checksum duration set to be 90 days (about a year ago). Client just asked us to look at some duplicates and we wanted to check the duration was still 90 days.

When I checked on the Misc page it 'showed' the checksum duration as 7 days.

So i reset at 62 days and took a look in the log_civicrm_settings.

I don't see any values between Feb 2015 and May 31 - so am unclear if the checksums only had a 7 day duration or not.

id  group_name  name    value   domain_id   contact_id  is_domain   component_id    created_date    created_id  log_date    log_conn_id log_user_id log_action
60  CiviCRM Preferences checksum_timeout    s:2:"90";   1   NULL    1   NULL    2015-02-27 12:47:18 3   2015-02-27 12:47:18 223174  3   Update
'60 CiviCRM Preferences checksum_timeout    s:2:"62";   1   NULL    1   NULL    2016-05-31 10:28:52 3   2016-05-31 10:28:52 3676071 3   Update

I had hoped i could look at past checksums but understand these don't exist in the db so no clues from that end. is there some other way i can look in to this?


texts: CiviCRM 5.17.5 and WordPress 5.2.3 just won't work

texts:
We have been stuck at CiviCRM 5.12.4 for months now. I have had issues with my Contribution page (details not needed here) as I tried to upgrade through Civi 5.14.2. So, I held off until today to try one more time on the latest stable release (also to avoid the critical warning that 5.12.4 is OBE that scares our staff).

We are running WordPress 5.2.3 and use iATS Payments 1.6.2.

This is the behavior. If I am logged into Wordpress, when I click on a contribution page, both the contact info and the billing name and address are correctly filled in. However, hardly any of our visitors create and use a WordPress login. If I am not logged in, the page does NOT have the "My billing address is the same as above" checked by default as it did before. Worse yet, if I check to use the same address for billing as for contact, it does not propagate. Someone would have to fill in every field all over again. I think this "almost" works, but am wondering what could possibly be wrong. It seems like an issue with the handler for contribution pages, as the behavior seems to change every time I try a new version.

I obviously am not going live on our main website with this behavior. If anyone would like to observe for themselves, please visit https://test.sdcbcdream.org/join/ . To see it work correctly (5.12.4), you may visit https://sdbikecoalition.org/join/.

Thanks for any help. This one has me stumped as we have always had no issues moving forward with stable versions.


texts:
Is there a way I can delay when a automated E-Mail is sent.
For Example - I would like the receipt email when one submits a contribution to be delayed by a few hours.
Thank you


texts: Events registration via webform + strict accommodation options

texts:
I have created 1 event and using a webform to register people. The user can register multiple people using conditions shows/hides contact fields. I would like to include camping options with conditions.

•   A large tent which has to house 4 people
•   Single tents

Camping space is limited. If the user selects 7 people to register, I want them to be able to choose either:

1x large tent
3x single tents
Or
7x single tents

If a user registers 3 people then a large tent is not an option, and so on.

Not sure if this is actually possible.


texts: How do I set up custom permissive relationships?

texts:
I am currently using D7.35 and Civi4.4.14

We have custom relationships on our Civi installation. What I would like them to do is give the individual permission to view and edit the organisation which for some reason worked in development and not in the real world.... I think because the first tick box is unticked.... right?:

So there are probably two questions:

Am I Right?
How can I get Civi to allocate this automatically?

There is a bit of further information.

Our developer custom coded the module designed for our member management system. So a Station Administrator (as per the picture) and promote or demote within his station without our intervention using a custom page where a number of relationships are managed.


texts: State dropdown empty on form with Drupal webform integration

texts:
We are running Civi 4.7.29. with Drupal.  We have a webform using Drupal webform integration which populates civicrm fields.

we noticed that the state drop down was empty when previously it was working correctly.

Has anyone come accross this issue?

I checked the state province table in civicrm and it is not empty.

Thanks

Yes there is an error on the page.  Please see below.  How do I fix this please?


texts: How to download a pdf instead of sending it per email?

texts:
I'm sending a membership certificate attached to an email template with Drupal 7 / CiviCRM using CiviRules and PdfApi but often the emails don't reach the recipients because of deliverability issues, even though I use a professional SMTP gateway.
I'm wondering about sending a link to the pdf instead of sending the pdf attached. Is this possible knowing that members don't have access to CiviCRM, they have no User account?
Any experience with this topic?


texts: Is there a way to generate a click-through report from a Mass SMS?

texts: Unlike How do I prevent CiviSMS from converting my URLs to longer clickthrough-aware URLs?, I'd like to take advantage of clickthrough tracking in mass SMS's. The links in the SMS message are replaced with what looks to me like a clicktrhoough tracker (e.g. https://***/sites/all/modules/civicrm/extern/url.php?u=47&qid=3010) but I can't find any mass SMS in the Mail Clickthroughs report. I can't even find the destination URL in MySql's civicrm_mailing_trackable_url.


texts: How to debug variables inside function invoked via ajax call?

texts:
I want to debug a function on this file
https://github.com/Project60/org.project60.banking/blob/9dc6bdcc486753f70948edfd4ea36df0eb9d2f86/extension/api/v3/BankingTransaction.php

/**
 * Analyses the given bank transactions
 *  used as AJAX call
 *
 * @param  list    list of bank_tx ids to process
 * @param  s_list  list of bank_tx_batch ids to process
 *
 * @return  array api result array
 * @access public
 */
function civicrm_api3_banking_transaction_analyselist($params) {
CRM_Core_Error::debug_var ('params', $params);

}

The above function is invoked by button which has onclick event
https://github.com/Project60/org.project60.banking/blob/9dc6bdcc486753f70948edfd4ea36df0eb9d2f86/extension/templates/CRM/Banking/Page/Review.tpl

The code is as follows

{ts}Analyse (again){/ts}

But  I dont see anything on the log files, how can I get the variables
I have checked it under sites/defaut/files/civicrm/ConfigandLog/
I dont see any civicrm.log files or any other files ending with .log dont have value of debug which I have entered
Also debug settings has been set to Yes


texts: “Network Error Unable to reach the server” recording Contact activities

texts:
We have a CiviCRM 5.15.0 installation under WordPress 4.9.10 and 2 MySQL db: one for Wordpress data and one for CiviCRM data.   We manage more than 6500 contacts.

Going inside a contact we have this error message with a blank popup adding a meeting or phone call in the contact summary:

  Network Error
  Unable to reach the server. Please refresh this page in your browser and try again.

There are NO ERRORS adding contributions, registering for events, adding pledges, sending emails.

Analyzing logs we have no errors on Apache, but we found a

CRM_Core_Error::backtrace("backTrace", TRUE)

on

wp-content/uploads/civicrm/ConfigAndLog/

last file

You can see how the errors come out on this video https://youtu.be/lrMq6A2t9Uk


texts: When importing memberships, I get "Error: Invalid value for field(s) : Start Date; End date"

texts:
I hope someone can answer this!
I've tried 30 various date formats, rearranged columns, and every time I do a membership import it fAils. No errors are presented, I'm just returned to "Upload Data (step 1 of 4)" from step 3... I never see step 4 (summary).
In "plugins/files/civicrm/upload" folder I see a file "sqlImport.errors" which shows an error not recognizing the date formate for the membership start and end

But I've tried every format and none work. :(.

Each time one membership record (1 row) imports, and then if fails! Every time.

The first 2,5 lines of sqlImport.errors says:

Line Number","Reason","External Identifier (match to contact)","Membership Type Id","Email (match to contact)","Membership Start Date","Membership Expiration Date"
"2","Invalid value for field(s) : Start Date; End date","33","Adult","wfsdfoks@telus.net","06/01/2013","06/01/2014"
"3","Invalid value for field(s) : Start Date; End date","34","Youth","helsdfng@rebalasdftouch.com","06/01/2013","06/01/2015"

I've tried different formats of dates (yyyy-mm-dd, mm/dd/yy, mm/dd/yyyy, dd/mm/yyyy) and selected the appropriate format from Step 1 in the import page.

Every time it's the same:
- I get to Step 3, and click "Submit"
- 1 (one, only) row get imported (correctly) and then
- I'm taken back to Step 1 - No error, complaint, nothing.

In my server's error log I see:

...client denied by server configuration: /home/civicthe/public_html/wp-content/plugins/files/civicrm/custom/delete-this-OcxGgONTcR
... client denied by server configuration: /home/civicthe/public_html/wp-content/plugins/files/civicrm/upload/delete-this-Zj1bvAyuTv
...client denied by server configuration: /home/civicthe/public_html/wp-content/plugins/files/civicrm/ConfigAndLog/CiviCRM.fee2178658acc8deae2211eadc328c3b.log

FYI, after each fail (1 row imports) I delete the top row from the .csv file and try again, and again 1 row imports, so it can't be the .csv file.

Can anyone help? This is driving me bonkers.  Why does it fail if the next time I run the


texts:
When trying to upload an image to the Mosaico editor I get an internal server error and the image doesn't appear in the template nor in the gallery.

However, when I check the upload folder the image has actually been uploaded.
Also, when I compose a traditional mail I can see the images in the KC Finder.
Imagick is present on my server.

Any idea how to fix this?


texts: How can I have a view only custom field of type "Link" be clickable in a profile?

texts:
I have a custom field of type "Link" presented as View Only in a public profile (I have several of these field types in the same profile).

Frustration is that the Link isn't clickable, so the user has to copy and paste the URL instead of being able to click on it.

I'm using Joomla 3.8 and civiCRM 5.10.1

Any suggestions how I can make these clickable?


texts:
Thank you for looking at my question.

I am a Drupal and Civi newbie.

When I installed CiviCRM the CiviCRM menu appears in the menu bar however, there are no dropdowns. When I click on it the page appears blank and the "configure your dashboard button does nothing". The pages are there when I type in the url but the links dont show up in the menu.

I have:

Uninstalled and reinstalled,
Cleared caches,
Confirmed the site/default folder is writable,
Confirmed CIVICRM_UF_BASEURL,
Moved menu to Management--Admin,
Disabled and re-enabled,
Installed the Admin Menu module.

How do I get the menu to appear properly?

Thank you for your help.

P.S. received this error also which may be related to menus: Fatal error: Unsupported operand types in /home/xxx/public_html/xxx/modules/system/system.module on line 2134

UPDATE

Heres the debugging console text: imgur.com/a/nEcTD

civicrm?reset=1:46 Mixed Content: The page at 'https://beta.myblackmarket.uk/civicrm?reset=1' was loaded over HTTPS, but requested an insecure stylesheet 'http://fonts.googleapis.com/css?family=Lato:300,400,700,900,400italic'. This request has been blocked; the content must be served over HTTPS.
civicrm?reset=1:50 Mixed Content: The page at 'https://beta.myblackmarket.uk/civicrm?reset=1' was loaded over HTTPS, but requested an insecure stylesheet 'http://fonts.googleapis.com/css?family=Playfair+Display:900'. This request has been blocked; the content must be served over HTTPS.
yM1bINZq:7 Uncaught TypeError: $ is not a function
civicrm:447 Uncaught TypeError: CRM.$ is not a function
civicrm:699 Uncaught TypeError: CRM.$ is not a function
webform_civicrm_forms.js:403 Uncaught ReferenceError: jQuery is not defined
civicrm?reset=1:1 Mixed Content: The page at 'https://beta.myblackmarket.uk/civicrm?reset=1' was loaded over HTTPS, but requested an insecure script 'http://maps.google.com/maps/api/js?sensor=true'. This request has been blocked; the content must be served over HTTPS.


texts: browser session expired = unable to complete event form

texts:
I am using WP 5.4.2 - PHP 7.2 - CiviCRM 5.27.3 - the Plugin lite-speed 3.2.4 is activated.
UAT has raised this issue : "the browser session has expired you are unable to complete the event form subscription"
I see those post :
All Contribution pages result in "Your browser session has expired" "Could not find a valid session key"
Intermittent "Your browser session has expired and we are unable to complete your form submission" errors
And I understand the root cause is  "cache management". Yes: if I delete cache on the host-admin  the form is now available to the end.
Someone said the solution is :

Based on further investigation and discussion this seems to have been related to the WP Super Cache "Don’t cache pages with GET parameters. (?x=y at the end of a url)" setting being disabled.

But I don't understand if the fix is to be done :

on WordPress = modify WP Super Cache
on Lite-speed plugin = desactivate it
on the Host = ?

BR Hervé


texts: Current Employer style field for a custom field

texts:
I have been asked to add some custom fields to the default CiviCRM Interface that bahave like the current employer field.

That is to say, my users want to create certain relationships and have them turn up in the relationships tab.

I had originally implemented this as a contact reference with a filter to look up the specific sub-set of contacts needed but I have been asked to make them relationships.

I realise I can implement this using webforms integration (we are using Drupal 7) but I have been specifically asked to implement this on the default UI.

I have also read it can be achieved using hook_civicrm_post however, I was hoping there was a more straightforward way that I was overlooking so that if in the future one of my users needs to add a new relationship custom field they don't need to update code in an extension


texts:
I'm exposing civi contact data in a drupal view. I can expose date of birth, but not the contact age field.

Anyone know of a module/ combination of modules that will allow me to calculate age in years within the view?


texts:
I am new to CiviCRM. Is it possible for me to use CiviCRM like MS Access?

I really don't need all the fields CiviCRM is offering.

All I need is the fields shown as below:

First Name
Last Name
State
License Number
Expiration Date

How can I ditch all other info and just come up with those 5 fields for Contacts? I also don't want the interface to display anything other than those 5 fields I am going to be entering.


texts: Why does the link from Membership Dashboard give a search with the wrong results

texts:
On Membership dashboard you can click on numbers in right column to 'see details' but the number of results is different to that on the dashboard.

This may also affect other Dashboard click-throughs such as on Events.


texts: Failed Upgrade 4.6.4 to 4.6.5 Joomla 2.5 & 3.4

texts:
My attempts to upgrade 4.6.4->4.6.5 fails in Joomla 2.5 with an 'already exists' error on CREATE TABLE `civicrm_cxn

Any clues? The full error message is:

  [Error: Upgrade DB to 4.6.5] Error Field  Error Value Type    DB_Error
  Code  -5 Message  DB Error: already exists Mode   16 UserInfo CREATE TABLE
  civicrm_cxn ( id int unsigned NOT NULL AUTO_INCREMENT COMMENT
  'Connection ID', app_guid varchar(128) COMMENT 'Application GUID',
  app_meta text COMMENT 'Application Metadata (JSON)', cxn_guid
  varchar(128) COMMENT 'Connection GUID', secret text COMMENT 'Shared
  secret', perm text COMMENT 'Permissions approved for the service
  (JSON)', options text COMMENT 'Options for the service (JSON)',
  is_active tinyint DEFAULT 1 COMMENT 'Is connection currently
  enabled?', created_date timestamp NULL DEFAULT NULL COMMENT 'When
  was the connection was created.', modified_date timestamp NULL
  DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'When
  the connection was created or modified.', fetched_date timestamp
  NULL DEFAULT NULL COMMENT 'The last time the application metadata was
  fetched.' , PRIMARY KEY ( id ) , UNIQUE INDEX UI_appid( app_guid )
  , UNIQUE INDEX UI_keypair_cxnid( cxn_guid ) ) ENGINE=InnoDB DEFAULT
  CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1050 ** Table
  'civicrm_cxn' already exists] DebugInfo   CREATE TABLE civicrm_cxn (
  id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Connection ID',
  app_guid varchar(128) COMMENT 'Application GUID', app_meta text
  COMMENT 'Application Metadata (JSON)', cxn_guid varchar(128) COMMENT
  'Connection GUID', secret text COMMENT 'Shared secret', perm text
  COMMENT 'Permissions approved for the service (JSON)', options text
  COMMENT 'Options for the service (JSON)', is_active tinyint DEFAULT
  1 COMMENT 'Is connection currently enabled?', created_date timestamp
  NULL DEFAULT NULL COMMENT 'When was the connection was created.',
  modified_date timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
  CURRENT_TIMESTAMP COMMENT 'When the connection was created or
  modified.', fetched_date timestamp NULL DEFAULT NULL COMMENT 'The
  last time the application metadata was fetched.' , PRIMARY KEY ( id
  ) , UNIQUE INDEX UI_appid( app_guid ) , UNIQUE INDEX
  UI_keypair_cxnid( cxn_guid ) ) ENGINE=InnoDB DEFAULT CHARACTER SET
  utf8 COLLATE utf8_unicode_ci [nativecode=1050 ** Table 'civicrm_cxn'
  already exists] PEAR_Exception: DB Error: already exists in unknown on
  line unknown
  - DB_Error: DB Error: already exists in unknown on line unknown Exception trace


texts:
Having a horrible time trying to get api.Contact.get into the URL.  The api explorer always puts into a &json{} array.  api.Contact.get is an empty array and that defeats most other ways of getting it into the REST call.  No example provided by Civicrm uses an empty array in code demonstration.  The simplexml example accepts and passes on the json, but I don't get anything back.  I've also tried a CURL call that I wrote and I tried mimicing the cURL call used by the civicrm_api3 class (which also does not work with the json array).

I'd like to know if anyone can tell me how to get a functional equivalent of

/sites/all/modules/civicrm/extern/rest.php?entity=Membership&action=get&api_key=userkey&key=sitekey&json={"sequential":1,"return":"contact_id,join_date","status_id":["New","Current"],"options":{"limit":10},"api.Contact.get":{}}

I have a case where going after the linked contacts would be miserably slow and inefficient.

Is there working php code ANYWHERE that can use the json array in the examples?  If so, can you tell me where to find it?


texts: In mailing all recipients are not showing

texts:
I have a problem related to 'mailings'. When I create a new mailing and select a group (for example, 'current members') in 'Recipients' then it is not showing all recipients. For example, I have 5681 total contacts, 67 of which are in 'Current Members' group, but after selecting this group in mailing it is showing only 4 recipients. I have checked there are not any blocked contacts and there are also not "Do Not Call" for any contact.

I am using following versions

CiviCRM Version 4.7.17
Wordpress Version 4.7.3


texts:
CiviCRM 5.27.5, Drupal 7.72
I've been attempting to use the print/merge function with no success.  I've tried both .docx and .odt, which the help text says are valid file formats.  However, when I attempt the print/merge, I get the error that my file format is invalid.
Steps to replicate:

Search for contacts, select a few
Select Print/Merge Document from the actions menu
Upload file, click to merge

Is there a particular trick to making this work that I'm missing?


texts: Securiy certificate expired for installation documentation

texts: I can't get to the installation documentation (e.g. https://wiki.civicrm.org/confluence/display/CRMDOC/Installation+and+Upgrades) at the moment because it says the security certificate expired in the early hours of this morning. Hopefully someone can fix this soon!


texts:
I am trying to access REST API of our civicrm. I have set the APIKey, Site Key. The path is correct. HAve enabled permission for the user account of the API Key. But getting 403 Forbidden. Can you please clarify what are the settings/permissions to be enabled to access REST API? Thanks in advance for the help.
Thanks,
Priya


texts:
I would like to create a report which simply has the total number of people in a particular group. The reason for a report rather than just going to manage groups and looking is that I want to email this number to the client weekly preferably automatically. Under reports I couldn't see that I could select groups. Can I do this using reports? Or is there another way (I did look at automatign an sql query but the group is a smart group and I can't see how to count that)

I'm open to any solutions!

Thanks


texts: What is the purpose of the Disable Expired Relationships scheduled job?

texts:
This forum link where it was born seems to suggest that it's needed as a replacement for hooks or to be able to filter them in drupal views. But it seems you can make a view that filters based on end dates in the past, and there are hooks for relationships (maybe there weren't at the time of the original post).
An alternate way of asking this question is "what does is_active mean for relationships"? Is it just a stand-in instead of using effective-dating queries such as are common in PeopleSoft or HR systems (which have broader use, e.g. list all the people who were active employees in 2019)? Is it just a redundant data field that means "end date in the past"?
Besides trying to understand whether it's redundant and maybe a bit fragile, one reason I'm asking is that anyone who's using this scheduled job would be dependent on the fact that civi ends relationships when it does, and so a change to that would affect this. So another way of asking this question is "Is anybody using this scheduled job and can describe your use case a little bit?"


texts: Administrator role not recognized if user logs in from another language

texts: We have a bi-lingual site in Mexico running civicrm on drupal and the default language is English. Some users with administrator roles get "access denied" messages when they log in from a Spanish language computer. Is there a way around this??


texts: Hide profile icon when using Profile in listing mode

texts:
We're using a Profile to create a members directory that is only accessible when members are logged in. The profile search is working fine, and we've restricted access so users only see what we want them to see.

However, in the search results listing, the leftmost column contains a little person icon, and when you hover over it, it shows that person's contact details.

If I'm logged in as an Administrator, I see everything, but if I'm logged in as a user I see nothing except when hovering over my own entry.

I should specify that we're not using a shortcode in a WordPress page, we're linking to the "Listing Mode" of the profile directly.

Is there a way to disable this icon so that it doesn't appear in the listing results?

We're running CiviCRM 4.7.6 on WordPress 4.4.2.


texts:
I noticed that some hooks are not firing… I have the following three hooks

<?php

add_filter('civicrm_permission', 'civicrm_permission', 10, 1);
function civicrm_permission(&$permissions) {
  PC::debug( $permissions, '$permissions' );
}

add_filter('civicrm_aclGroup', 'civicrm_aclGroup', 10, 5);
function civicrm_aclGroup( $type, $contactID, $tableName, &$allGroups, &$currentGroups ) {
  PC::debug( $type, '$type' );
  PC::debug( $contactID, '$contactID' );
  PC::debug( $tableName, '$tableName' );
  PC::debug( $allGroups, '&$allGroups' );
  PC::debug( $currentGroups, '$currentGroups' );
}

add_filter('civicrm_alterAPIPermissions', 'civicrm_alterAPIPermissions', 10, 1);
function civicrm_alterAPIPermissions(&$permissions) {
  PC::debug( $permissions, '$currentGroups' );
}

?>

the middle one (civicrm_aclGroup) fires, the other two do not. PC::debug is just a logging class. as far as I understood the docs this would be the correct way to target the hooks.


texts: Autoloader problem after upgrade to version 4.6.8

texts:
I'm not quite sure if this is a drush or a civicrm problem, sorry if this is the wrong forum.

I did an upgrade yesterday evening from version 4.6.4 to version 4.6.8. Drush version is 5.9. Today I tried to clear the cache using drush cc all, but I get an "unrecoverable error" message saying that:

PHP Fatal error:  Call to undefined method Composer\Autoload\ClassLoader::setPsr4() in /<myciviinstall>/civicrm/civicrm-4.6.8/civicrm/vendor/composer/autoload_real.php on line 37
Drush command terminated abnormally due to an unrecoverable error. [error]
Error: Call to undefined method Composer\Autoload\ClassLoader::setPsr4() in /<myciviinstall>/civicrm/civicrm-4.6.8/civicrm/vendor/composer/autoload_real.php, line 37

This also happens for the drush cc civicrm command, and for the civicrm cron job:

30 * * * * /<hiddenpath>/bin/drush/drush -u 1 -r /<mysite>/public_html -l mysite.com civicrm-api job.execute auth=0 -y > /<hiddenpath>/cron/cronlogs/civi_error_drush_`date +\%F_\%T`.log /dev/null`

I should point out that the reason for the somewhat strange path in the PHP Fatal error message, is that I'm running civicrm (on Drupal 7) via softlinks to keep old versions present but "out of the way" so to speak. This to be able to (more) quickly swap back to older versions. This approach has worked well for me in the past, and I didn't have this drush problem yesterday evening before the upgrade.

Googling, I find clues that this may indicate that the version of the composer autoloader is out of date, but I'm not sufficiently familiar with composer to be able to tell for sure (is composer a drush thing only?).

Anyone got an idea?


texts: Price Set fields with Quantity per Option

texts:
We want to have our price set have options such as

A
B
C
D

but we want to have a quantity field for each option

X  A
X  B
X  C
X  D

and have it calculated at the end of the form.

Is this possible or achievable with native CiviCRM functionality, or is there a way to adjust the code to suit our needs that has been done before?


texts: Authorize.net Accept.js payment processor

texts:
Authorize.net recently released their Accept.js payment processing method -- very similar to Stripe.  The big advantage is that CC data goes directly from the user's browser to Authorize.net's servers.  Never touches your server, greatly reducing PCI scope and compliance challenges.

http://developer.authorize.net/api/reference/features/acceptjs.html

Wondering if there are other Authorize.net users who'd be interested in co-sponsoring an Accept.js payment processor for CiviCRM?

For those who might say "just use Stripe" -- with our transaction volume, their fee structure would cost us an extra $20000 / year vs. what we have with our own CC merchant account + Authorize.net.


texts: Recording/ tracking time spent on Events

texts:
One of the activities of our organization is providing workshops etc. to the public. In order to facilitate all processes involved I have setup a coupe of events in CiviCRM. Each event represents a certain course, training or workshop. Next I have added participants (contacts) to those events with the role of Attendee. The event/workshop also requires one or more trainers so I added trainers (contacts) with the role of Trainer to the event/workshop. A requirement is that we have an overview/summary of each event showing who is involved in a certain event/workshop (e.g. who is/are the trainer(s), people taking care of logistics, participants, etc).

We would like to track the training time spent for each trainer and also to be able to generate a report listing e.g. the training name, date, training time spent and also the total training time for each trainer per (selectable) period (e.g. from/to date).
What would be the best way to record the training times for each trainer? Could or should this be done in the event itself (e.g. custom fields) or should we add activities to each assigned trainer and aggregate activity durations? Any other solutions to accomplish this?

Many thanks in advance for your kind attention.


texts: Query to get a list of contacts not tagged with a tag, but the user has multiple other tags

texts:
I'm building a View that lists contacts.  The View needs to list all contacts that are not tagged with a certain tag.  The problem is if a contact is tagged with another tag, it will still show in the list, because of the LEFT JOIN to the tag table...In this example I'm filtering the list to one contact for simplicity's sake.
The contact in question has two tags.  One of them is the one I want to filter out.  Yet the contact still shows in the list because it has another tag....

I also want to include contacts in the list that have no tags at all, thus the

part of the query ( (civicrm_tag.id IS NULL ) OR (civicrm_tag.id NOT IN  ('35')) )

SELECT civicrm_contact.id AS id, civicrm_contact.display_name AS civicrm_contact_display_name
FROM
{civicrm_contact} civicrm_contact
LEFT JOIN {civicrm_entity_tag} civicrm_entity_tag ON civicrm_contact.id = civicrm_entity_tag.entity_id AND civicrm_entity_tag.entity_table = 'civicrm_contact'
LEFT JOIN {civicrm_tag} civicrm_tag ON civicrm_entity_tag.tag_id = civicrm_tag.id
WHERE (( (civicrm_contact.id = '21033') )AND( (civicrm_tag.id IS NULL ) OR (civicrm_tag.id NOT IN  ('35')) ))
LIMIT 10 OFFSET 0


texts: How can I allow multiple payment attempts through civicrm webform to prevent having to start from scratch if payment fails?

texts:
We have a webform using the CiviCRM Webform integration which is allowing people to sign up for paid events. The webform is connected to a payment processor. When someones payment fails/gets declined then we would like them to get to attempt another payment for the same contribution.

Ideally they would get three attempts to cover for them putting in their details incorrectly or realising they need to top up their account.

Currently if the payment fails they must start again from scratch and reenter all the information again. This is what we are trying to avoid as it is annoying for the user if they have to put in all their details again.

Using Drupal 7 and CiviCRM 4.7

Payment Processor is DPS (Payment Express) via the OmniPay extension


texts: Advanced Search returns no results for a valid contact id

texts:
I tried to use Advanced Search and specified a contact id which I know is in the database. There are no other filters  yet I get no results.

No matches found for:
Contact ID = 54862

Suggestions:
check your spelling
try a different spelling or use fewer letters
if you are searching within a Group or for Tagged contacts, try 'any group' or 'any tag'
add a New Individual, Organization or Household
make sure you have enough privileges in the access control system


texts: CiviCRM menu bar corrupted after installing Shoreditch

texts:
I'm trying out the Shoreditch theme (originally for Mosaico, but it's so much more useable I'd prefer to keep it on by default if possible). I see weird white blocks at each end of the CiviCRM menu bar.

Is this a bug in the current version of Shoreditch, or have I done something wrong?


texts: For all reports, CiviReport shows a page with no content

texts:
I'm getting a mostly blank screen when trying to run reports. I see the CiviCRM menu and page heading, then the page footer, with nothing in between.

I get the same thing for every report and every report template. The "Manage Templates" screen works, but if I click "Edit" on a template, I get a pop-up with no content.

I have no errors in the CiviCRM log file, no errors in my PHP log file, and no browser console errors. This is CiviCRM 4.6.26.

What steps can I take to further troubleshoot this problem?


texts: Payment Processor. MD5 Hash Removal/Disablement from Authorize.Net

texts:
Today Morning I got an Email from the authorize.net regarding MD5 Hash Removal/Disablement. Here what exactly they stated.

Authorize.Net is phasing out the MD5 based transHash element in favor
of the SHA-256 based transHashSHA2. The setting in the Merchant
Interface which controls the MD5 Hash option will be removed by the
end of January 2019, and the transHash element will stop returning
values at a later date to be determined.

Merchants utilizing this feature will need to work with their web
developer or solutions provider to verify if they are still utilizing
MD5 based hash and if still needed to move to SHA-256 hash via
Signature Key.

Currently I am using CiviCRM 4.7.29 version. Integrated with Drupal 7.

In payment Processors settings. I am using Authorize.Net as Payment Processor Type. And Using MD5 hashing also.

Now my question is. Does the latest version 5.9 supports this feature? Or Please let me know is their any other alternate solution.


texts: ValueComparison null error when adding 'Last contribution is more than n days ago or is n days ago' as condition

texts:
I'm trying to set up a rule in CiviRules that will send an e-mail n days after a contribution was made.

When I try to save the condition parameters I get an error message.

Can anyone confirm that this is a bug, or am I messing up something?

Error log:

2020/02/06 13:20:26 [error] 8317#8317: *280630 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught TypeError: Argument 1 passed to civicrm_api3() must be of the type string, null given, called in .../shared/uploads/sites/5/civicrm/ext/org.civicoop.civirules/CRM/CivirulesConditions/Generic/ValueComparison.php on line 125 and defined in .../releases/20200204155448/web/app/plugins/civicrm/civicrm/api/api.php:84

Stack trace:

#0 .../shared/uploads/sites/5/civicrm/ext/org.civicoop.civirules/CRM/CivirulesConditions/Generic/ValueComparison.php(125): civicrm_api3(NULL, 'getfields', Array)
#1 .../shared/uploads/sites/5/civicrm/ext/org.civicoop.civirules/CRM/CivirulesConditions/Generic/ValueComparison.php(73): CRM_CivirulesConditions_Generic_ValueComparison->isDateField(NULL, NULL)
#2 .../shared/uploads/sites/5/civicrm/ext/org.civicoop.civirules/CRM/CivirulesConditions/Contribution/LastContribution.php(64): CRM_CivirulesConditions_Generic_ValueComparison->ge" while reading response header from upstream, client: [...], server: [...], request: "GET /wp/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcivirule%2Fform%2Frule&reset=1&action=update&id=2 HTTP/2.0", upstream: "fastcgi://unix:/var/run/php-fpm-wordpress.sock:", host: [...], referrer: [...]/wp/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcivirules%2Fform%2Frulesview&reset=1"

I reproduced the bug on the demo site:


texts: Problem with upgrade to 4.7.0 (Wordpress 4.4.2)

texts:
I recently upgraded our site to 4.7.0. The upgrade seemed to go well, but now there is a problem when starting it up fresh.

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

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

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


texts:
Just noticed the last import an employee did - confused Job Title with Formal Title - we fixed it - but then the question arose - what is the field Formal Title used for - and I have no clue.

Its not in the user guide - not visible on contact dashboard - and not much discussion about it on SE - can someone shed some light on how formal title is used?


texts:
Using Civi 4.74 combined with Joomla 3.5

WE're looking to include tags in our contact reports but there's no obvious way to do so. What are we missing?


texts: How to request OK to communicate by email (only)? Without coding

texts: In the 'Manage Contribution Payment' screen we want to simply ask the donor if they are happy to be contacted by email - a simple Yes/No option in a profile. It doesn't seem possible to do this using the standard fields - 'Communication Preferences' brings up all the communications options. Is there any way to just expose the email field as a preference? I can do this with a custom field, but it would be better to set the actual email preference field.  I've a feeling this must be possible, and have a strong preference to avoid any coding!


texts: How do I find the web root in civicrm.settings.php?

texts:
I'd like to set

$civicrm_setting['Directory Preferences']['extensionsDir'] =

to a files directory relative to the web root. How do I do that?