texts: Preventing CiviMail from Resizing Images for Membership Cards

texts:
Because of Covid-19 restrictions, our men's group isn't printing and laminating membership cards for 2021. Instead I'm trying to use CiviMail to send a facsimile of the card(s) that the member can print and clip. The cards provide merchant discounts, so many members want to have them. I overprint member name and other information on a blank member card image.
My problem is that the html/css I prepare gets modified (augmented for responsiveness?) by CiviMail when it sends the mailing.
i.e. shrinktofit="true" is added to an image class that I want to not scale so that it's viewable
here's the html in the CiviMail editor window
div class="polaroid"><img alt="Member Card" shrinktofit="true" src="https://../sites/default/files/civicrm/persist/contribute/images/LMGA-Logo%20Membership%20Cards%202021.jpg" style="width:100%"
I'd like to disable this automatic scaling for this particular mailing. Is that a possibility?


texts: I was following along the 1st video of the SearchKit playlist on Youtube. And approximately 38 min in, the presenter shows how one can see the underlying API code or SQL code for a given search. It looks like he simply expanded on a tab, Query Info. However this is not available for me on my Buildkit site and I'm wondered how to enable this.


texts: How do we set up WordPress front end pages to allow our team to access CiviCRM admin tabs etc.?

texts:
After viewing the video of this webinar, I'd like to emulate the page that Erik Hommel had shown. CiviCRM 101 for Newbies https://www.youtube.com/watch?v=a5bjr0s02NQ

It looks like he had a front end page to allow users to access the CiviCRM admin area.

We are exploring CiviCRM to see if it will meet the needs of our non-profit organization. We need users to access the contact and case modules primarily. We'd like to set this up as front end pages that would not be visible to the public but perhaps set up with role permissions and possibly limit some of CiviCRM functionality. They need to enter cases and contacts for clients who call with questions, asking for publications etc.

I've read about shortcodes for creating front end contribution and events pages, but nothing about the CiviCRM admin area with the tabs across the tops to create new contacts, cases, dedup contacts etc.

Does anyone have any information or links to where this might be in the documentation or if it's even possible?

Thanks in advance for any help offered.


texts: Does anyone use CiviCRM behind a Web Application Firewall?

texts: We're looking at deployment for a client who's sensitive to being hacked, so we want to put CiviCRM behind, say, nginx running mod_security2.  Has anyone used a WAF with CiviCRM that can share recommendations?


texts: CLI Contact Import is not importing address details

texts:
I have a local test environment on a mac where the site is installed.

I'm trying to do a CLI import via the mac terminal and unfortunately, address details are not being imported.

Command Used:
php [absolute path]/sites/all/modules/civicrm/bin/csv/import.php -e Contact --file [absolute path]/csv/test.csv

Column headers:
"contact_type","email","first_name","middle_name","last_name","street_address","city","state_province","country","gender","custom_1"

Sample CSV:
"Individual","person.email@local.dev","FirstName","MiddleName","LastName","Street Address Details","City Name","State Name","Country Name","Female","custom_1 value"

As you can see above, there's even a custom value and it get's imported, but address details are not.

Please help.

Mac: El cap, Drupal: 7, CiviCRM: 4.7


texts: After upgrading to 4.6.0 I can no longer update the value of the domain.address token. I try to update the address in Administer > Organization Address and Contact, but after saving the new address it reverts to the old address.


texts:
I am working on a report and part of the requirement is to have pull the list of tags per individuals, households and organizations.
I was able to pull the groups by using civicrm_group_contact and civicrm_group tables and join by id. I see a table in civi called civicrm_tag, it contains list of tags but I don't know how to connect it with the associated records or identify the people assigned to theses tags.

Thanks in advance

Regards

Edward


texts: Create a membership list with employee name

texts:
I have a public directory list that is created based on a relationship with an organization that is set-up as a smart group.  I have a profile that lists the organizations that are included in the smart group along with their web address and email address.  I also want to include the employees or contacts for each organization.  How do you create a list or directory on a web page that includes an organization name and an individual's first and last name?

I see that this is a limitation of CiviCRM - can't combine individuals with organizations, but that doesn't seem practical.  When you create a directory of member organizations it seems appropriate to include a contact name.  How have others handled this problem?

I am using CiviCRM 4.4 and WordPress.


texts: How does the API deal with the addition of an existing contact?

texts:
If you add a contact via the API is it passed through any of the de-duplication rules? I.e. if I add a contact that matches an existing record will it create a new record or merge with the existing record?

If the contact is passed through the de-duplication rules how can you control which rule applies?

I am wondering if I need to create the necessary logic in my code to test if a new contact is a duplicate or if I can rely on the de-duplication process to take care of this.


texts: Is there an area in CiviCRM (or a way) for people involved in a case to communicate privately?

texts: When a new case is set up, we need to let the parties involved with that case communicate privately and have their messages and shared docs only accessible to them? Like a shared, but private, message board. Is this possible without using an 'outside' tool?


texts: How can i investigate what duration a specific checksum had when it was sent out

texts:
I need to check on some checksums to confirm if the duration matched the setting (which we had set at 90 days but mysteriously was showing as '7' again when i went to check the Misc. settings. Can anyone tell me which table the data is in?

Should this find it for me - if so I guess the field has an unrelated name

SELECT DISTINCT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%checksum%'
    AND TABLE_SCHEMA='<my-database>';


texts: Why is there a "session_set_save_handler" warning whenever Civi cron runs?

texts:
I am using CiviCRM 5.23.4 with Drupal 7.69, though this issue is not new to this version of Civi.

Every time Civi cron runs, I get a warning in the Drupal Recent log messages:

Warning: session_set_save_handler(): Cannot change save handler when session is active in drupal_session_initialize() (line 242 of /home/XXXX/www/www/includes/session.inc).

Any suggestions for how to address this would be appreciated. Thanks.


texts: Can you change Pending (Incomplete Transaction) to Pending (Pay Later)?

texts:
Is it possible to change pending transactions from incomplete to pay later?
Without editing db?


texts: 404 Not Found Error when running reports

texts:
We moved our WordPress site from one cPanel account to another whilst changing domains. Everything in CiviCRM seemed to be working OK. But we've just hit a problem.

I can go to Reports -> Contact Reports -> Contact List - and get the screen with columns, filters, sorting OK.

But when I try to Refresh Results, or Print etc I get a 404 Not Found error.

Any help or hints of where to look would be much appreciated.


texts:
Is there a way to overwrite a Contact's email address with a null value?

I tried uploading contact info (via: Import Contacts) with a blank email field, but this doesn't override an existing email address.

Thanks!


texts: Problem with permissions to edit message templates

texts:
I have recently upgraded from CiviCRM 5.24 to 5.27.2 (on Drupal 7.72), and a user reports a new problem with editing message templates, specifically the User Message Templates.  She can open the template, select edit, make the changes, but when she tries to save it gets an Authorisation Failure message.
She has the permissions Edit Message Templates, and Edit User-Driven Message Templates, which worked OK before.
Is there some change I need to make to the configuration, or is this a regression bug?
Thanks, Tony
The Error message is:
"Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
Authorization failed"
on a white screen.
The template text is the following, but get the same error with a single line of text without any formatting at all.:
{capture assign=doctype}{activity.scheduled_reminder}{/capture}
{capture assign=renewal}Renewal Reminder{/capture}
{capture assign=lapsed}Membership Lapsed{/capture}

{if $doctype == $renewal} LALG Renewal Reminder{/if}

{if $doctype == $lapsed} LALG Membership Lapsed{/if}

     {contact.first_name} {contact.last_name}
     {contact.street_address}
     {contact.supplemental_address_1}
     {contact.city}   {contact.postal_code}

{contact.email_greeting}

{if $doctype == $renewal}

Your membership will expire on  {latestcurrentmembership.end_date}

Membership Type:  {latestcurrentmembership.type}

You can find all the details as to how to renew your membership  by visiting  the LALG Website

Membership can be renewed online or by downloading a form from the website and taking this with your payment to David's bookshop.

Yours sincerely,

Elaine Fox

Chair

{/if}

{if $doctype == $lapsed}

Your LALG membership has recently expired, and you will no longer receive the monthly newsletter or other membership benefits.

Membership can be renewed online or by downloading a form from the website and taking this with your payment to David's bookshop.  You can find all the details as to how to renew your membership  by visiting  the LALG Website.

Membership Type:  {latestcurrentmembership.type}

Expiry Date:            {latestcurrentmembership.end_date}

Yours sincerely,

Elaine Fox

Chair

{/if}


texts: Can't Uninstall CiviCRM from Joomla after failed civiCRM upgrade

texts:
I am on Joomla version 3.8.2 with Php 7. I tried to upgrade to CiviCRM 4.7.28 but it failed because it was partially installed and missing important files. Now, I can't get into the Joomla administration back end to reinstall it or delete it because when I log on to the admin, I'm getting a black white screen that when I turn-on debugging, shows the error message. Subsequently, I can't do anything with the site.

My question is how do I delete civiCRM or reinstall it without doing it through Joomla?


texts: Overcome API KEY request at Relationship edit / delete for users of certain Drupal Role

texts:
Is it possible to skip api key check at Relationships delete? We'd like to create one-click link for altering Contact, where users of certain Drupal Role should be able to click "Resign" link and all magic happens behind the scenes. Since there are a lot (really) users of acting role, playing with individual user api key(s), described here http://wiki.civicrm.org/confluence/display/CRMDOC/REST+interface#RESTinterface-CreatingAPIkeysforusers ,  doesn't sound like a good idea. So, are there something like "skip_key_check" for such a cases? Here's a piece of code currently being used:

CRM.api3('Contact', 'create', {
  "contact_type": "Individual",
  "id": key,
  "is_deceased": 1,
  "deceased_date":yestrDate,
      "custom_197": 0,
    // Relationships part - this is here  api key is being asked
    'api.Relationship.create': {
       "id": value.rel_ID ,
       "contact_id_a" : value.cont_A,
       "contact_id_b" : value.cont_B,
       "relationship_type_id" : value.relationship_type_ID,
       "end_date": yestrDate,
        "is_active": 0
        // Would be nice to have "skip_permissions_check": 1, here
     },


texts:
We all know GDPR is coming. I currently use drupal webforms with civicrm processing enabled. I use the privacy option to allow people to tick a box to opt out of receiving email update eg the person fills out a survey but doesn't want to be contacted, they can tick the box and it fills out the user opted out box on their record.

With GDPR this will be the wrong way round. I have to ask the user to tick a box to stay in. Obviously I can do this by creating a custom field and then unsubscibing those that don't, however I'm keen to do this automatically. I am aware there is a new extension being developed by Veda Consulting ( :) ) however it doesn't look like this deals with this? For clarity I am looking for general opt in rather than group opt in.

How are other people planning to deal with this? Am I missing something obvious in drupal webform?

Thank you!

Caroline


texts:
I am using profiles for data entry in my CiviCRM instance. They seem to be working (the contacts that should be created are saving), but I get the following (big ugly) notices at the top of the page on a save:

Notice: Undefined index: contact_sub_type in CRM_Contact_BAO_Contact::formatProfileContactParams() (line 2010 of /var/www/html/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php).
Warning: in_array() expects parameter 2 to be array, null given in CRM_Contact_BAO_Contact::formatProfileContactParams() (line 2011 of /var/www/html/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php).
Notice: Undefined index: contact_sub_type in CRM_Contact_BAO_Contact::formatProfileContactParams() (line 2012 of /var/www/html/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php).

The contact_sub_type_hidden is being submitted when the form is submitted with an appropriate value, so I'm at a bit of a loss as to why these errors are being thrown and what impact they have on what I'm doing. Any pointers appreciated.


texts: Wordpress with Divi: How to integrate CiviCRM contribution pages?

texts:
I am trying to set up a contribution page within a Divi layout. At a short glimpse, that looks well, but: this won't work! Instead, I get a lots of CSS problems and JS errors.

I could imagine to get a quick solution using some customizing within the Divi templates.

Or, I return to the original CiviCRM contribution pages, and do the CSS stuff (that is provided by Divi) somewhat manually, in order to create a contribution page looking similar to the Worpdpress Website.

Anybody out there with experience on that?


texts: Custom field not displaying in edit mode

texts:
CiviCRM 5.12.4-5.13.4
PHP 7.1 - 7.2
Joomla 3.9.6
MySQL 5.6

Hi,
After updating Civi to 5.12.4, I cannot edit custom fields in contacts, also creating and editing fields in Administer 'Edit Field' brings the pop-up with the title and blank page.

Changed PHP version from 7.2 to 7.1/7.0, still the same issue. Can't see any errors in the console or error log files.

Any help will be much appreciated.

Thanks, V.


texts: How to change the default Activity dashlet to include activities other than "scheduled"?

texts:
CiviCRM 4.6.9.  Drupal 7.30

How can I change the default Activity dashlet to include activities other than scheduled activities? By default, it only shows scheduled activities


texts: A problem I have with getting a box on my home page for visitors to sign up for a mailing list?

texts:
I am running CiviCRM under WordPress on a local host

I have set up a Group named "Mailing List" with "Join Our Mailing List" as the description.

Under Group Type "Mailing List" is checked - and I've tested with "Access Control" both checked and unchecked.  Visibility is set to "Public Pages".  Reserved Group? is unchecked.  Is Active? is checked.

I can enter contacts in the back end on Word Press and they appear as contact in CiviCRM, but there is no box on the front end --something that will appear to a user who is not logged in -- in which a user can enter himself as a contact.  What must I do to get a box in "Public Pages" where a visitor can enter his name and email address and have this information become part of the CiviCRM mailing list group?


texts:
I'm working on a version of CiviCRM installed in Joomla, I'm using a registration form with custom fields of Civi for the registration.
The problem is that CiviCRM does not apply the same checks on passwords as Joomla does.
I have not found solutions in the system, so I'm trying to insert custom controls using hooks.
As indicated I created a file and specified the path and customize the code find on CiviCRM guide for my purpose, but does not detect any changes on the form I'm using.

function joomla_civicrm_validateForm( $formName, &$fields, &$files, &$form, &$errors ) {
  if ($formName == 'Edit') {
    foreach ($fields['cms_pass'] as $key => $password) {
      if(strlen(trim($password)) > 8) {
        $errors['cms_pass[' . $key . ']'] = ts('Password must be 8 characters');
      }
    }
  }
  return;
}


texts:
We installed Civimobile as a test, and aren't yet using it. It does look great!

We have noticed a file on our server of gigantic proportions:
civicrm/civicrm_contact_push_notification_messages.ibd: 18GB

Is this just generated by the Civimobile API? And if so, have we done something wrong in our setup that it has become so large? I think the extension was enabled for about 4 weeks, and has been disabled for about 6 weeks. And we haven't been using the CiviMobile app at all when the extension was enabled.

How can we reduce the size of this file, or remove it? We don't want to use up that much space on our server if we don't have to.

Thanks for your help.

Civicrm 5.24, Drupal 7.69


texts: Issue on Event registration with Wordpress-CiviCRM, message "You do not have permission to access this page."

texts:
We had to reinstall wordpress after a Malware infection.
We have now the version WordPress 5.5.3.
We are now facing an issue with the registration for an event. In CiviCRM, It is working well if we register one person to an event.
But when we try to do it in Wordpress, we have the following message : "You do not have permission to access this page."
On the WordPress Access Control, the anonymous user is able to "register for events". But in wordpress, using the form, impossible to register.
Do you have any idea ???


texts: I'm trying to get some extensions enabled on a Joomla 3.6.2 CiviCRM 4.7.11 installation. For some reason the "Manage Extensions" option is missing from the Admin menu. I was able to get to the necessary page by logging into the demo and grabbing the URL for the extensions area, but how do I get it added to the Admin menu? The demo is running Civi 4.6.18, but I wouldn't think this option has been removed in 4.7. Screenshot below:


texts: How to exclude a lapsed membership from mailings

texts:
Currently using Civicrm 4.7.8 with Drupal.

We have a large membership base. We imported our lapsed members as well in case we will get them to renew membership. Currently about to do a mailings newsletter to our current membership. We wish to exclude the lapsed members from the member only newsletter.

Issue that presents us is that the lapsed members are in different branches, not in a specific group. If we use the "do not email" in privacy settings and they rejoin, our concern is a volunteer that renews that membership may not untick the do not email option, there fore the renewed member would not get their newsletters.

Any suggestions how we might "police" this or is their a way that by marking the do not email option can be automatically undone if someone  renews membership after lapsing?


texts: Where in the DB are CiviCase timelines and sequences stored?

texts: Please can someone tell me, where in the DB are CiviCase timelines and sequences stored?


texts: Contact Layout Editor not working CiviCRM 5.19.2

texts:
I have installed the contact layout editor extension on Drupal 7 and could not see editor when selecting contact summary layouts.  I upgraded CiviCRM to version 5.19.2, enabled Shoreditch still nothing. All extensions are shown up to date.  All I see when selecting the editor is this error messsage

Notice: Undefined index: target_contact_name in getContactActivitySelector() (line 2608 of /home/webdevelopmentsc/public_html/sites/all/modules/civicrm/CRM/Activity/BAO/Activity.php). =>

Any help or assistance would be appreciated.

Regards

Graham


texts: Session Key issues after upgrading from 4.4 to 4.6

texts:
I've upgraded from 4.4 to 4.6.10 on Drupal 7.41. I'm getting the following issue when attempting to make a contribution:

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

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

I have cookies enabled.

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

Drupal caching is currently disabled.

I have a user 0 in my Drupal database.

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

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

Updates

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


texts: How do I run a report on an event that includes things such as participant name, email and organisation they are from?


texts: How to show a CSS class of a contribution form based on Stripe iFrame element via jquery?

texts:
I would like to add a jquery in my extension,  as I enter the card details on the stripe, the submit button should show, otherwise hide. Since the new stripe element is served on an iFrame, I am struggling to figure it out, although I have targeted the parent class, still no avail... Can anyone help please? Here's my code..

CRM_Core_Resources::singleton()->addScript("
  CRM.$(function($) {
    showSubmit();
    $('div#billing-payment-block div#card-element .__PrivateStripeElement input.__PrivateStripeElement-input').bind('change keyup click blur', showSubmit);
    function showSubmit() {
        let cardValue = $('div#billing-payment-block div#card-element .__PrivateStripeElement input.__PrivateStripeElement-input').val();
    if (cardValue.length> 0) {
        $('span.crm-button.crm-button-type-upload.crm-button_qf_Main_upload.crm-i-button').show('slow');
      }
      else {
        $('span.crm-button.crm-button-type-upload.crm-button_qf_Main_upload.crm-i-button').slideUp('slow');
      }
    }
  });
");


texts: Hello is there a way I can have people redirected to a specific url after they register for an event.  It seems in the civi event registration I can only specify text and email.  It seems this would be an important feature to track registrations through Google analytics.  Any help would be great.  Thanks!


texts: Is is possible to restrict visibility of custom data sets?

texts:
Current install - WP5.0 / Civi 5.7.2

I'm just thinking through our Safeguarding / Child Protection process. We don't have any issues, but we're legally obliged to have a process. And I'd rather set this up now when there's no pressure than when, heaven forbid, there's an actual issue.

What I'd like to do is have a set of custom data fields against a contact (essentially notes, but I can't have them exposed like 'normal' notes) that our designated Child Protection Officer (me) has access to, so that any concerns / issues can be logged against a contact record.

Obviously, access to those fields needs to be tightly controlled. No one else in the organisation even needs to know they exist.

I know I can use ACL's to manage access to functions within CiviCRM, and I can hide fields from profiles. But if I have other people legitimately using CiviCRM, I can't have them seeing these additional fields (or even see if a contact has those fields present on their record, even if the content is hidden).


texts: Troubleshoot Paypal Standard emails - Yes, tried patches (Urgent)

texts:
Have event in in foreign currency and need PayPal Standard.

Running into a problem where emails are not being sent for event registration.
Running 4.6.7 without enabling Invoices.

Paypal / Event email receipts work when using paypal pro or paypal express.

Using Paypal standard, IPN does seem to work properly as registrations are marked properly.

Reviewed many known issues like:

Why aren't donation receipts being emailed to customer?
Applied patch from https://issues.civicrm.org/jira/browse/CRM-17343 (added comment -
Reviewed all jira entries for paypal + email in 4.x.x

NOTE: Logfile shows 2 IPN entries for each call:
[info] Contribution record updated successfully
[info] returning since contribution has already been handled

Any other suggestions?


texts:
How do I know if I can use CiviMail? What are the benefits? What does it do? How is it better or worse than just the regular email part on civicrm?

I cannot quickly find any links to more info on this? Can someone provide me with some more informatioN?


texts:
we are a small charity who would like to see all the latest incoming enquiries from our website in one place when we log on to civicrm in wordpress.
We have created a general enquiry form (Caldera Forms) which does send an email direct to the specified charity email address, and does create an individual record at the backend of civicrm, but none of them show up in the activities screen when we log in.
It would be very useful to be able to see in one place the messages that we need to deal with as they come in.
Grateful in advance for any help on this please.


texts: User Sync error when new user registers on behalf of a business

texts:
I am using wordpress 4.9.5, CiviCRM 5.0.2 and CiviCRM WordPress Member Sync 0.3.5.
When a new user signs up, and selects register on behalf of an organization. The user role does not sync, stays at the base level.  If the user does not select this option, the sync works as configured.

I have double checked mappings, and they are all correct.


texts: How to create the best front-desk contribution flow using CiviCRM?

texts:
The scenario is a "front-desk" form for new member signups. Organisation takes cash / card for payment on the day, so CiviCRM is not processing payments, and payments should be recorded as completed. Desk staff will use a form to record the new member's contact details, take payment, and initialise the membership.

The form should:

Require first & last name & email
Record amount taken for membership (may be weekly or annual fee)
Save the new Contact
Save the new Membership with 12 month expiry
Save the initial Contribution and flag as completed
If weekly option selected, perhaps create a pledge?
If possible, option to select completed or pending status (latter for those setting up AP payment)
Require minimal steps for entry (eg skip confirmation screen, don't require billing address etc)

The org will be offering self-service signups to the public via their website at the same time, but the ideal UX for staff vs new members is different so these are different requirements.

It's possible to use CiviCRM's regular Contribute form to achieve most of this, and there's a special cid=0 parameter (civicrm/contribute/transact?cid=0&id=X) to use a Contribute form to sign up a user who is not the logged in user - but that means getting staff to use a public-accessible Contribute form, and lacks the ability for staff to record the payment as completed.

Can CiviCRM Profiles record a new contact, contribution and membership in one form submission? How else can this best be implemented?

Thanks!


texts: PayPal standard recurring payments fail with "Access Denied"

texts:
CiviCRM version 5.30.0, Wordpress 5.5.1, PHP 7.2.34
Single payments passed to PayPal proceed fine, but recurring payments are blocked by PayPal, reporting "Access Denied.
You don't have permission to access "/subscriptions?business=info [...]
PayPal technical support claims "Since your query parameter strings was passed with the special characters like "/wordpress/civicrm/?Dcivicrm%252F" which causing the access denied issues. "
We are using the standard CiviContribute resources with no special templates or other items.
Has anyone else hit this brick wall?  How did you manage to resolve it?
Incidentally, we were able to create new recurring contributions until about 2 weeks ago with no system changes around the time of the failure.


texts: User to view/change own membership as well as address details etc

texts:
I want users to be able to login and see/change their address etc as well as at least see their membership type (one of four available) and preferably change the membership. I got the login sorted, I got the profile I want but when one meets the other this message: "Profile search, view and edit are not supported for Profiles which include fields for more than one record type."

How do I get around this? Or is it not possible for members to see/edit their membership type on CiviCRM?

On Wordpress btw.

Thanks


texts:
I would use civix for coding a scheduled task that updates a customed field. I could generate an extension skeletton with the "civix generate:module" command, but fail to use "civix generate:api" for generating an api to be scheduled.

My CiviCRM is embedded in Drupal and hosted by Google cloud. I have a local copy of the civicrm part of my site, but without the mysql database. When executing the civix generate:api command, I get an error that seems coming from mysql : Initialization Error - DB error : extension not found.

Is mysql mandatory for having "civix generate:api" working ?
How can I avoid my civicrm copy to launch mysql ?
Thanks for help.


texts: What is the recommended upgrade increments to CiviCRM 5.7 from CiviCRM 5.0?

texts:
I've done lots of CiviCRM upgrades over the years in Drupal but I've had CiviCRM complain in the past if I skip too many versions so I'm being a little overcautious maybe.

I have a Drupal 7 / CiviCRM 5.0 site that I'd like to upgrade tomorrow to 5.7 and I wonder if I need to upgrade in increments or whether I can just jump ahead and let the upgrade script upgrade the db all in one go.

What's the best practice for this?

Thanks,
Andrew


texts: How can I easily import data from external sources like Stripe while dealing with subtle differences in field values?

texts:
Here's a specific example. When I export data from Stripe, there is a Status column with the value Paid. This obviously corresponds to CiviCRM's Contribution Status field. However, CiviCRM doesn't use the term Paid, it uses Completed.

If I try to just directly import data from Stripe, CiviCRM complains about invalid status (and other fields with similar issues).

I could easily write a little script to munge CSV files from Stripe into something that makes CiviCRM happy, but I really want to create a process that our staff without deep technical skills can use. Running a command line Perl script is out of the question. I could make a web app to munge the CSV files but now we're getting into very silly amounts of work for something absolutely trivial!

Ideally, CiviCRM would have some sort of notion of munging/mapping for the values in the data being imported, as opposed to just mapping the field names.

I didn't see any extensions along these lines but maybe I missed something.

I'd love to learn how others have solved this problem.


texts:
Drupal 7 CiviCRM 4.6.28 Hosted on: Pantheon

I have a client that needs to import 15,000-20,000 contacts on CiviCRM. The problem we are running into is that importing any amount over 500 is causing a page timeout error to be thrown; our host, Pantheon, puts a strict 60-second limit on how long a page can take to load. We have been working on getting the resource usage down, which has improved the import, but the error is still being thrown.

The import does continue, and finish the job, after the error is thrown. We need the error to stop being thrown, though, so that the client can be confident that the import has completed.

The current idea we have to fix this is to skip over the import progress bar popup, keep them on the Summary page, and use Ajax to track the import and communicate when it is finished.

I'm fairly new to CiviCRM, so am wondering, does that solution sound doable?  Or, does anyone have an idea for another solution to this problem?


texts: 'Unknown path' error when trying to access New Mailing with version 4.6.2

texts:
It tries to go to "http://mycivicrmsite/civicrm/a" but it giving an "Unknown path" error.  It doesn't seem to redirect to "http://mycivicrmsite/civicrm/a#/mailing/new" which seems to work.

We don't have any extensions installed.


texts: How to create latitude and longitude automatically for civirm contact

texts:
I want to generate latitude and longitude automatically for CiviCRM contact when the address is present.

How to achieve this?


texts: Create a Personal Campaign Page links to a page that does not exist

texts:
When I enable the "Create a Personal Campaign" within the contribution page manager, the link to share to create a personal campaign page is provided at the bottom of the contribution page manager as shown here:

The link provided leads to a Page Not Found error:

This is the link https://lofcenter.org/civicrm?page=CiviCRM&q=civicrm/contribute/campaign&action=add&reset=1&pageId=1&component=contribute

This is the resulting error:

Any suggestions on how to proceed trouble shooting this error?


texts: Contact URL image display in civiCRM 5.12.4

texts:
I'm using civicrm v5.12.4

a while back I made this post. - Upgrade from 5.10 to 5.12 contact images no longer appearing

As I was having issues with contact images displaying. It seemed the issue I was having then was that I was developing locally, with a locally created SSL certificate.

The Contact Images are really important to this project and so I got some hosting with a ssl certificate and set up wordpress and civicrm

I installed it originally on a hosting platform without enforcing Https.
Then I enforced https and found I needed to edit the civicrm.settings.php file and replce all instances of http:// in the file, to make the site work.

Now, everything seems to be working smoothly, with the exception of contact images. I'm not getting any error messages, the images are just displaying as broken image icons.

This happens whether I try to attach an image via the edit contact civicrm pages or a profile page.

Does any one have tips for how I could trouble shoot this?


texts: How to migrate Civi DB from a Drupal 7 to a Drupal 8 site

texts:
I'm tasked with migrating a CiviCRM database from a Drupal 7 site to a Drupal 8 site. So far there's 2 approaches I've thought of. Copy the whole DB as standard and import it into the new D8 site. I've tried this and it didn't appear to break anything (apart from missing extensions etc), albeit a bit unstable, but nothing that could be fixed (CSS, path resets etc).
The other approach I haven't yet tried is a regular CiviCRM install on the D8 site and using the user interface to import CSV exports from the D7 site.
Edit: I've seen these Where is the documentation for installing CiviCRM with Drupal 8 or for upgrading a Drupal 7 system with Civi to Drupal 8 and Can I upgrade a drupal 7 + civi site to drupal 8? but I feel they're not applicable as such in my case.
My question is, does anybody have any tips for this? Anybody that's done this before that has any suggestions? I've looked around but didn't find anything that was precisely migrating from D7 to D8.


texts:
I have a view created that has Organisation Name and a contacts Display name shown.

Now I want to be able to use auto-complete/ajax to enable the end user to filter by Organisation Name.  This helps the end users not having to remember the exact name of an Organisation.  In the future we will have 50+ organisations in the system.

At the moment my only other choice it to initially manually add all the organisations to the filter and use a drop-down.  But as more organisations come on board, this will soon end up unmanageable.

To add more clarity to my VIEW setup

RELATIONSHIPS

  CiviCRM Contacts: CiviCRM Relationship (starting from contact A)
  (CiviCRM Relationship (starting from contact A)) CiviCRM Relationships: Contact ID B

FIELDS

  CiviCRM Contacts: Organization Name (Organization Name)
  (CiviCRM Contact B) CiviCRM Contacts: Display Name (Display Name)

FILTER CRITERIA

  CiviCRM Contacts: Display Name (exposed)

This gives results (shown in a table) with Orgnisation Name in left column and Contacts Name in right column.

But no matter how I change the filter properties (apart from changing it from Single to Grouped and typing in the Organisation names to produce a drop-down) it has the issues described above.


texts: Award Drupal User points after contribution

texts:
I would like to create a Drupal Rule to award Drupal userpoints upon a civicrm contribution being added to a member record through membership sign up.

Ideally the points awarded are dependent on which price field (price set) is selected, ie bronze member = 10 userpoints, silver member = 20 userpoints etc

I have been playing around with rules but can't seem get this one...any pointers would be most appreciated.

(pasted from answer/comment)

I thought it would be a simple rule. When a contribution is saved, of a specific type userpoints are added to the record. But no...

So far...I created a price set with the required price options for both membership and contribution.

Then went to Drupal Rules and made various attempts at setting up a rule to award userpoints on either signing up to a membership or making a payment. A combination of the following;

In terms of the event I have tried; after saving a new civicrm contribution, after saving a civicrm price field, price field value etc

Condition: I have tried Data comparison, entity is of type, list contains item etc based on price field id, price field value id

Action; Award user points.

Non of the above (or combinations) have given me a result when adding a contribution or membership to the user record.

So I'm pretty much lost. Help...!!!


texts: What is the Process to have an Extension Enhanced?

texts:
I use some Extensions (e.g. Twilio : org.civicrm.sms.twilio).

I would like some enhancements (e.g. : have a specific associated permission or connexion to an existing permission)

What is the best process to get that ?

(I am not a developer, nor familiar with development environment)


texts: CiviCRM appears to block edit of WordPress site

texts:
I am newly trying to fix a website that is built using WordPress and hosted by a third provider. The site has not been maintained as best I can tell for about 5 years. My main action so far has been to upgrade to WP 5.0.3.

But when I try to edit any page in the site (having gone in through WP's back end), I get this message on an otherwise blank page: “Please select a CiviCRM front-end page type.”

What does this mean and how do I fix it?


texts: Cannot Select Recipients in CiviMail in 4.6.2

texts:
I'm experiencing the same issues as shown in this thread: http://forum.civicrm.org/index.php/topic,36343.0.html

Fields appear duplicated, I can't select any recipients, etc. In fact, when I select a group (autocomplete search does not work), the field label goes red as if I've missed selecting any recipients.

I've got an urgent mail to get out for this client, but can't do it through CiviMail. I've tried all versions of the layout (standard, unified, unified2 and wizard).

Joomla 2.5.28
CiviCRM 4.6.2
Browsers used: Safari 7, Chrome 42.x, Firefox Developer's Edition


texts:
I just tried to export all my contact info from MailChimp. Basically, it worked and I am now the happy owner of a pretty CSV file... but all the data is saved in only one column, one row per contact.

For example, my data is stored as

axel.grunt@zukunft-statt-autobahn.at,Axel,Grunt,"Lieber Herr Grunt",,J,J,J,,,"Zukunft statt Autobahn",,,,"Deciders only, Deciders auch","progressive GroÃŸspenderInnen",Newslettertest,,,html,5,,,"2012-09-13 19:32:42",184.173.181.254,48.2092000,16.3728000,1,2,Europe/Budapest,AT,9,"2013-10-28 08:14:49",26171677,963968a07a,

When I want to import the data on CiviCRM, it can't read the data but thinks it would be a terrifying misspelled email address.

Any solution?


texts:
I'm working on a hook to display a users PCPs on a custom contact tab. We use PCPs extensively and it would be great to see any pages the contact owns inside their contact card. (Rather than having to pull up the full list of PCPs in a separate window. I also know that there's a link to PCPs in the soft credit section of the contribution tab - but that's only if there is a contribution to the page.)

I'm able to make a custom tab (using the tabset hook) but am struggling how to actually get content on to the tab.

// let's add a new "contribution" tab with a different name and put it last
// this is just a demo, in the real world, you would create a url which would
// return an html snippet etc.
$url = CRM_Utils_System::url( 'civicrm/contact/view/contribution',
                              "reset=1&snippet=1&force=1&cid=$contactID" );
// $url should return in 4.4 and prior an HTML snippet e.g. '<div><p>....';
// in 4.5 and higher this needs to be encoded in json. E.g. json_encode(array('content' => <html form snippet as previously provided>));
// or CRM_Core_Page_AJAX::returnJsonResponse($content) where $content is the html code
// in the first cases you need to echo the return and then exit, if you use CRM_Core_Page method you do not need to worry about this.
$tabs[] = array( 'id'    => 'mySupercoolTab',
                 'url'   => $url,
                 'title' => 'Contribution Tab Renamed',
                 'weight' => 300 );

But I don't know what to set my own url to AND get content on it. I'm in Wordpress 4.3.1 and Civi 4.6.4. Suggestions?


texts: Can I move a report from Contact Reports to My Reports?

texts: I have 5 reports in Contact Reports which I meant to have in My Reports. Is there a way to move these to My Reports?


texts: How to create a Drupal View of CiviCRM Activities with an edit link to the corresponding Webform?

texts:
Goal is to have a filterable and sortable Drupal View of CiviCRM Activities (not a view of Webform Submissions) created with a Webfom with a link to edit the webform submission.

I can painstakingly do it through the Views UI if I create the View as a view of Webform Submissions, but the inability to filter/sort on fields is a deal breaker.

If I create a View of CiviCRM Activities, I get all of the filter and sort options but no nice link to edit the webform.


texts: Upgrade Now Button does not show when upgrading to 4.6.9

texts: I usually run the upgrade process for CiviCRM and it usually works well. On 4.6.9 I noticed that the upgrade now button for step 11 in the upgrade documentation does not show. It says Upgrade CiviCRM to version 4.6.9 but no upgrade button shows. I did manage to upgrade on a non-ssl site but with the sites that have SSL there seems to be problem.


texts: Events Registration - Custom field widths shown too wide on actual web page

texts:
CiviCRM 5.21.0 with Drupal 7

I set up an event registration and added some custom fields and set the width to be smaller than default (usually 20 or 30 wide).

In the preview from the Registration tab of the event the fields look correct, but when displayed on the actual page the fields extend the whole width of the page - even though you can still only enter the set maximum number of characters in that huge field.

The "canned" fields from the Individual profile do not do this - they display the expected length.  It's just the custom fields I created that run the full width of the page.


texts: Can a profile submission redirect to a PDF?

texts: On CiviCRM 4.5/Wordpress 4.1, I'd like to create a profile that, when filled out, automatically downloads a PDF.  Is such a thing possible?  It didn't work when I put a URL to the PDF in the "Redirect URL" profile setting.  Is there another solution that's end-user friendly?  Could the Redirect Editor plugin be of assistance here?


texts: CiviContribute Component Settings not saving settings beyond Enable Tax and Invoicing option

texts:
I am setting up a fresh install (CiviCRM 5.24.5 / WordPress 5.4.1) but found that once I 'Enable Tax and Invoicing' within CiviContribute Component Settings no changes are saved on that page (I am trying to save changes to the due date, notes, tax term, and tax display settings) other than the 'Enable Tax and Invoicing' option (and I get the settings saved notification).

I am very new to this and have been working my way through using the docs (https://docs.civicrm.org/user/en/latest/contributions/sales-tax-and-vat/) and have set up Financial Account for Sales Tax/VAT just in case but to no effect.  Everything appears to be working normally.

While I want the invoicing, as a small charity we are below the VAT threshold and the VAT rate is set to zero, though setting to 20 makes no difference in the VAT/Sales Tax Financial Account.


texts:
What is the status of the Drupal 8 integration?

Does anyone know of anyone using, or gearing up to using, a Drupal 8 & Civi production install?
Does anyone know how much (if any) core team time is being focused on Drupal 8 integration?
Is there a dedicated anywhere (forum, mailing list, twitter hashtag?!) for Drupal 8 integration updates?

John

PS: I am aware of the Jira issues queue https://issues.civicrm.org/jira/browse/CRM-18222?filter=23012


texts:
I need to adjust the line height on PDF when creating letters. I tried to modify

.cke_editable
{
    font-size: 13px;
    line-height: 1.6em; <- I tried 1em
}

...in

/sites/all/modules/civicrm/packages/ckeditor/contents.css

My modification is visible in CKEditor but doesn't change anything on the generated PDF.

What is the best approach to do this ? I'm using Drupal 7, CiviCRM 4.5.8 and CKEditor 4.

Thanks

EDIT

From @Flying comment, I noticed that CKEditor creates

...

...around all newly created paragraph (so each time I hit backspace). I can get rid of these span's by using "Remove Format" ("Tx" button).

So I guess my question becomes "Why does CKE add span's around p's with inline css style ?"

I found some useful resources, still need to check :

http://ckeditor.com/forums/CKEditor/ckeditor-4.01-inserting-span-elements-everywhere-with-a-line-height-of-1.6em

https://dev.ckeditor.com/ticket/9998


texts: Prevent automatic login after registration

texts:
When people register on my wordpress website using a civicrm profile, they get logged in automatically. As I first need an Administrator to approve the user, I would like users not to be logged in after registration is complete.

Is there a parameter I have missed or would I need to use a filter or whatever ?


texts: I want to import a bulk pledges to my CiviCRM installation and also I need to updating the pledges in every month. If I do it in manual it is very time consuming process. is there any easy way like import to update the pledges ?


texts: File does not exist error on webform civicrm payment attempt

texts:
On a civicrm_webform contribution page, attempting to make a payment gives this error in my Drupal db log:

The CiviCRM "contribution transact" API returned the error: "The file "/tmp/phpZcLm4t" does not exist" when called by function "validate" on line 96 of wf_crm_webform_postprocess.inc with parameters:

Kind of weird? I'm assuming it's something from the payment processor that's being handed down in try/catch blocks, but why payment processing is creating (and failing to find) temporary files is somewhat baffling.

The payment on the form is optional, and I don't get the error when I don't include a payment. I think the validate function bit is a useful clue ...


texts:
I have the following error when I attempt to execute the geocode operation in civiCRM 4.7.31 on D7:

  Entity: Job Action: geocode Summary Finished execution of Geocode and
  Parse Addresses with result: Failure, Error message: Aborting batch
  geocoding. Hit the over query limit on geocoder. Details

  Parameters raw (from db settings):  geocoding=1 parse=0 start=1
  end=100 throttle=1

  Parameters parsed (and passed to API method):
  a:6:{s:7:"version";i:3;s:9:"geocoding";s:1:"1";s:5:"parse";s:1:"0";s:5:"start";s:1:"1";s:3:"end";s:3:"100";s:8:"throttle";s:1:"1";}

  Full message:  Finished execution of Geocode and Parse Addresses with
  result: Failure, Error message: Aborting batch geocoding. Hit the over
  query limit on geocoder.

I've entered my Google API map provider key in Settings - Mapping and Geocoding Providers. I've selected Google on the pull-down menus for Mapping and Geocoding Provider. I didn't think 100 records were too many to geocode.

In the Name (Frequency)/Description column, I have the following:
Geocode and Parse Addresses (Daily)
Retrieves geocodes (lat and long) and / or parses street addresses (populates street number, street name, etc.)
API Entity: Job
API Action: geocode

Any suggestions of changes in my settings?


texts: Is anyone using Google Group Integration for CiviCRM?

texts: We have tried implementing Google Group Integration for CiviCRM - we got 90% there but ran into issues.  We have some funds to get a fix - but we have not heard from the developer.  Is anyone using this extension successfully?


texts:
When enabling mapping for a profile that e.g. includes the field ZIPCODE only - and then allowing mapping for all contacts (i.e. ?page=CiviCRM&q=civicrm/profile/map&reset=1&gid=xyz), contacts pop up on the map as intended.
If I click on the individual icon, it then, however, gives me full details including NAME and exact ADDRESS; that's not what I want to share...

Is there a way of controlling which fields get shown on the map - not including them in the profile somehow does not do the job.

This is all in WP.

Cheers


texts: Problem with PayPal IPNs not going through

texts:
End of year and we are getting membership renewals. We've used PayPal for years no problem, but since Dec 1, the IPNs (instant purchase notifications) are not working correctly. The transactions are left in the 'Pending' state. I've gone into PayPal's IPN history page and manually resent a few IPNs and they they go through and are then marked as 'Completed' in CiviCRM. But due to bugs in the PayPal history page I can only resend for payments for the last few days. Why are they not going through the first time? This just started happening this month.
I found the patch line:

$paypalParams['notify_url'] = rawurldecode($paypalParams['notify_url']);

and added it to the CRM/Core/Payment/PayPalImpl.php file (I have a different file version from the github entry but found the spot anyway.) Then I made a contribution and the IPN worked, transaction marked as Completed in CiviCRM. Unfortunately there was an error someplace when returning to our site from PayPal's 'return to merchant' link.
Error:

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

This is as far as I have gotten with this.
CiviCRM: 5.29.1
Wordpress: 5.5.3


texts: Updating to civi 4.6 after this can't create new emails no text editor

texts:
After upgrading I can't create new emails. Also the menu bar is not showing right. Please look at my screen shots. step 1 and step2. Maybe a problem with javasript?

Help is urgently needed since we can't use the email function. *Moderator: Please don't put me on hold again.

Thanks


texts: Unsupervised dedupe rules in the background?

texts:
It is my understanding that unsupervised dedupe rules take effect when one attempts to create a new contact, and they can also be run manually like any other rule. Can unsupervised deduplication be made to happen to existing contacts in the background (eg from cron)?

Edit: Or indeed, in the foreground but still basically automatic in terms of 'start it and wait for it to finish'?


texts: Blank page on mailings page, cron error and no debug info | Windows Server

texts:
I am helping one of my non-profits with getting CIVI up and running. We are experiencing some random issues including the mailings page and the system error page are completely blank, not a white screen of death but just no data in the page.

We also have had a cron job error which I am not sure if it is important.

I have turned on debugging but again no notice of errors.

We are running in Wordpress. php 7.1. On Windows Server 2016
Thanks!

Update 12/10/2018: I have installed the system on a traditional linux server and the mailing tab initializes correctly. So I need to know what this system needs to be active for it to function. Maybe I have a missing PHP extension.


texts: How do I add a Membership Expiry view-only field to a user profile page in Wordpress?

texts: I want to let members see their membership expiry date. I am running Civi 4.6 with Wordpress 4.4.1. I have tried creating a Membership Details profile with one field "Membership Expiration Date" in it, but whenever I try and view the field, I get "Profile search, view and edit are not supported for Profiles which include fields for more than one record type."


texts: How to cure empty config screens in civi?

texts:
We are getting two Civi config screens which show a header, but no content. The screen loads but is empty - no options, no fields, no instructions.

One is when wanting to delete a custom field -
here's a video of what happens

One is on the Results tab when wanting to set up a Survey -

Any ideas how to cure this?

CiviCRM 5.1.2 Drupal 7.67


texts:
I am developing an extension for civicrm 4.7. This extension includes several tokens. One of the tokens I want to include is a token for the activity assignee to be used in scheduled reminders.

In Civi 4.7 the hook system is expanded with Symfony Event Dispatchers and it looks like the token evaluate event will give me the oppurtunity to do exactly what is needed.

However I am confused in how to register an event listener. I have implemented the hook_civicrm_container but my events are never called.

use Symfony\Component\Config\Resource\FileResource;
use Symfony\Component\DependencyInjection\ContainerBuilder;
use Symfony\Component\DependencyInjection\Definition;

function tokens_civicrm_container(containerBuilder $container) {
   $container->addResource(new FileResource(__FILE__));
   $container->findDefinition('dispatcher')->addMethodCall('addListener',
     array(\Civi\Token\Events::TOKEN_EVALUATE, 'tokens_evaluate_tokens')
   );
}

function tokens_evaluate_tokens(\Civi\Token\Event\TokenValueEvent $e) {
  foreach ($e->getRows() as $row) {
    /** @var TokenRow $row */
    $row->format('text/html');
    $row->tokens('profile', 'viewUrl', 'http://example.com/profile/' . $row->context['contact_id']);
    $row->tokens('profile', 'viewLink', ts("Open Profile", array(
      1 => $row->tokens['profile']['viewUrl'],
    )));
  }
}

What is wrong with my code?


texts: How do I fix class not found in custom extension after upgrade?

texts:
I have just upgraded civicrm to 4.6.11 and am getting a Class Not Found error.

Fatal error: Class 'CJT_Page_EmrJournaltracking_JournalControls' not found in ... CRM/Core/Invoke.php

The class is in the system

 web/sites/all/modules/custom/civicrm/extensions/net.interlated.emrjournaltracking/CJT/Page/EmrJournaltracking/JournalControls.php

and defined as follows

require_once 'CRM/Core/Page/Basic.php';

class CJT_Page_EmrJournaltracking_JournalControls extends CRM_Core_Page_Basic {

The source for this extension is available at https://github.com/jrobens/civicrm-extension-emrjournaltracking


texts:
on a drupal 7 install with civiCRM 4.7.0 we have a problem displaying diacritics in PDF files. diacritics are shown as ?

thank you in advance


texts: Custom Search Problem - Unknown column contact_a.id in field list when tagging returned contacts

texts:
I'm running into almost the same problem that was detailed a couple years ago on the forums at https://forum.civicrm.org/index.php?topic=28829.0.  When I run a custom search using the built in Contributions made in Year X and not Year Y search, and then pick Select All Results and select Tag Contacts from the drop down, I get a DB Error: no such field.  The full logged error is:

Jan 06 16:27:59  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] =>
SELECT     contact_a.id as contact_id
FROM       civicrm_contact AS contact
LEFT JOIN  civicrm_contribution contrib_1 ON contrib_1.contact_id = contact.id

WHERE      contrib_1.contact_id = contact.id
AND        contrib_1.is_test = 0
            AND contrib_1.receive_date >= 20150101000000 AND contrib_1.receive_date <= 20151231000000
GROUP BY   contact.id

ORDER BY   donation_amount desc
 [nativecode=1054 ** Unknown column 'contact_a.id' in 'field list']
    [type] => DB_Error
    [user_info] =>
SELECT     contact_a.id as contact_id
FROM       civicrm_contact AS contact
LEFT JOIN  civicrm_contribution contrib_1 ON contrib_1.contact_id = contact.id

WHERE      contrib_1.contact_id = contact.id
AND        contrib_1.is_test = 0
            AND contrib_1.receive_date >= 20150101000000 AND contrib_1.receive_date <= 20151231000000
GROUP BY   contact.id

ORDER BY   donation_amount desc
 [nativecode=1054 ** Unknown column 'contact_a.id' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT     contact_a.id as contact_id
FROM       civicrm_contact AS contact
LEFT JOIN  civicrm_contribution contrib_1 ON contrib_1.contact_id = contact.id

WHERE      contrib_1.contact_id = contact.id
AND        contrib_1.is_test = 0
            AND contrib_1.receive_date >= 20150101000000 AND contrib_1.receive_date <= 20151231000000
GROUP BY   contact.id

ORDER BY   donation_amount desc
 [nativecode=1054 ** Unknown column 'contact_a.id' in 'field list']"]
)

This appears to occur no matter what size the result set is (I had one test set of 1 result, and 1 with 1767), on current versions (I noticed it first on 4.4.19 but I retested on 4.6.10 with the same result), and does occur not just for adding a tag but also for putting them in a group like the original poster describes.

Has anyone found a solution for this or at least a workaround?


texts: What to do with "mcrypt" message after upgrading to PHP 7.2

texts:
What should I do about the following message in my CiviCRM status page, after upgrading to CiviCRM 5.3.0, PHP 7.2 from 5.6, and also upgrading my OS from Debian 8 to Debian 9:

  PHP Missing Extension "mcrypt". Your PHP does not include the
  recommended encryption functions. Some passwords will not be stored
  encrypted, and if you have recently upgraded from a PHP that does
  include these functions, your encrypted passwords will not be
  decrypted correctly. If you are using PHP 7.0 or earlier, you probably
  want to include the "mcrypt" extension.

Rather than downgrade to PHP 7.0, how do I know if I need this extension, if I was using it before, and what I can do to make sure I'm taken care of with regard to encryption? If I am on PHP 7.2, can I just ignore this message? Can I use something else since it was deprecated in 7.1 and removed in 7.2?

Upon trying to install it with the PECL library, I get:

  php-mcrypt : Depends: php7.2-mcrypt but it is not installable
  E: Unable to correct problems, you have held broken packages.

What is throwing me off is that part that says,

  "If you are using PHP 7.0 or earlier"

And if I'm not on PHP 7.0 or earlier, what should I do, install it anyway? Thanks!


texts: CiviVolunteer Fatal error clicking on Volunteer Now - Resolved

texts:
I received the follow fatal error when trying to volunteer for an event.  The roles have been configured.  I did not select the public option.  It was resolved by ticking public.

#**backTrace**

#0 `/Applications/MAMP/htdocs/RCSQ/drupal/sites/all/modules/civicrm/CRM/Core/Error.php(360): CRM_Core_Error::backtrace()`
#1 `/Applications/MAMP/htdocs/RCSQ/drupal/sites/default/custom_ext/org.civicrm.volunteer/CRM/Volunteer/Form/VolunteerSignUp.php(117): CRM_Core_Error::fatal("Project has no public volunteer needs enabled")`
#2 `/Applications/MAMP/htdocs/RCSQ/drupal/sites/all/modules/civicrm/CRM/Core/Form.php(455): CRM_Volunteer_Form_VolunteerSignUp->preProcess()`
#3 `/Applications/MAMP/htdocs/RCSQ/drupal/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(94): CRM_Core_Form->buildForm()`
#4 `/Applications/MAMP/htdocs/RCSQ/drupal/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Volunteer_Form_VolunteerSignUp), "display")`
#5 `/Applications/MAMP/htdocs/RCSQ/drupal/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Volunteer_Form_VolunteerSignUp), "display")`
#6 `/Applications/MAMP/htdocs/RCSQ/drupal/sites/all/modules/civicrm/CRM/Core/Controller.php(353): HTML_QuickForm_Page->handle("display")`
#7 `/Applications/MAMP/htdocs/RCSQ/drupal/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(115): CRM_Core_Controller->run()`
#8 `/Applications/MAMP/htdocs/RCSQ/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(286): CRM_Utils_Wrapper->run("CRM_Volunteer_Form_VolunteerSignUp", "Volunteer Signup", NULL)`
#9 `/Applications/MAMP/htdocs/RCSQ/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:14))`
#10 `/Applications/MAMP/htdocs/RCSQ/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))`
#11 `/Applications/MAMP/htdocs/RCSQ/drupal/sites/all/modules/civicrm/drupal/civicrm.module(489): CRM_Core_Invoke::invoke((Array:3))`
#12 `[internal function](): civicrm_invoke("volunteer", "signup")`
#13 `/Applications/MAMP/htdocs/RCSQ/drupal/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:2))`
#14 `/Applications/MAMP/htdocs/RCSQ/drupal/index.php(21): menu_execute_active_handler()`
#15 `{main}`


texts: Why can I no longer Merge Contact records in 5.7.3?

texts:
After upgrading from 4.6.x to 5.7.3 staff is finding that many records can no longer be merged -> error:

#1 /var/www/platform/oursite/sites/all/modules/civicrm/CRM/Utils/Type.php(554): CRM_Core_Error::fatal("One of parameters  (value: Email) is not of the type Integer")
#2 /var/www/platform/oursite/sites/all/modules/civicrm/CRM/Core/DAO.php(1517): CRM_Utils_Type::validate("Email", "Integer")
#3 /var/www/platform/oursite/sites/all/modules/civicrm/CRM/Core/DAO.php(1481): CRM_Core_DAO::composeQuery("\n                        SELECT v.label\n


texts: Civi dashboard and menus won't display after install

texts:
I'm attempting to get an instance of Civi up and running on a WordPress site. The install says it goes fine, but when I try to enter the dashboard, I get this:

I did a test install of WP and civi on a different site using the same host and got no problems. I checked the PHP settings against each other and they are the same.

The System Status: Error link takes me no where, nor does the Configure Your Dashboard link. By which I mean the URLs they give are just

http://mydomain.website/civitest2/wp-admin/admin.php?page=CiviCRM#
http://mydomain.website/civitest2/wp-admin/admin.php?page=CiviCRM&q=civicrm/a/#/status

When I click on them, the page just loads for a while and I'm taken to this screen:

Update:

I've tried visiting civi features by inputing the URLs directly, for example ?page=CiviCRM&q=civicrm%2Fadmin%2Fconfigtask&reset=1 to reach the configuration checklist. I suppose the problem then is that the CiviCRM Dashboard and Toolbar do not show up when I try to access Civi. Another interesting thing is that Civi's CSS does not render when I'm in the backend. The image below is my contact group manager:

Update 2: As requested I checked he JS Console and hoo boy are there a lot of errors! 64 in all. Mainly 404 errors. For instance, jquery.min.js fails to load because the server responded with 404. It's the same story for most of them. Nearly all of the errors are 404s, but there are a few that read Uncaught TypeError which I'll reproduce here:

Uncaught TypeError: Cannot read property '_defaults' of undefined
    at admin.php:8
    at admin.php:102
Uncaught TypeError: $ is not a function
    at admin.php:7
    at admin.php:146
Uncaught TypeError: CRM.$ is not a function
    at admin.php:517

For all the 404 errors can navigate to that in my file in FTP and look at it, but cannot access them through my browser, which is something I can do on installs that work. For example /wp-content/plugins/civicrm/civicrm/bower_components/font-awesome/css/font-awesome.min.css is present in my files, but I can't navigate to it in browser.

Looking at the permissions to get to that file, every directory is 755 and the resource itself is 644.

Update

I checked settings.civicrm.config and found the global variable $civicrm_root was set correctly to /home/USER/public_html/civitest2/wp-content/plugins/civicrm/civicrm/. I went to the Resource URLs settings page and replaced the CiviCRM Resource URL which was defaulted to [civicrm.root]/ with http://mydomain.website/civitest2/wp-content/plugins/civicrm/civicrm/. On refresh, the menu and dashboard were there.

This could have been discovered faster had I bothered to read the URLs more intently and see that it was duplicating my domain root.


texts:
Is there a simple way to add btcpay as a payment processor? They have the same api structure as bitpay, and there is a plugin for that. But Is hardcoded to bitpay, and would need to be changed to work with btcpay.
I tried making this an issue on github, https://github.com/nickcalyx/Bitpay-for-Civicrm/issues but they just wanted me to pay them. understandable, but I dont have a budget for this project yet, thats why i'm trying to setup crowdfunding.


texts:
How do I add in a new Activity Type for CiviCampaign?

I can see how to do this via  CiviCRM » Administer CiviCRM » Option Groups  » Activity Type Options for Contacts only.

Any help would be great!


texts: Can't access contribution page without a login

texts:
I have recently updated CiviCRM in Joomla 3.x to the latest 5.5.2 build. I'm finding on my main contribution page (used for subscriptions), that I can't access it unless I'm logged in. When logged in, it loads fine. As a public user, I get just HTML on the page, which is an error saying I can't access it. The main part of this HTML is:

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

You do not have permission to access this page.

My Joomla menu item that is used in the URL for the page is set to public access. The settings for the contribution page itself haven't changed. What could I be missing here?


texts:
Could anyone tell me how to set up a report based on the country of the member (Northern Ireland, Republic of Ireland, England, Wales, Scotland).

Thanks in advance
Debs


texts: Contribution page receipt (date and time)

texts:
My contribution page receipt is showing the wrong date and time.

I submitted the page at 11.30 on 1st August 2016, but the receipt to my email states '8th, 2016 1:01AM'

Update: Further submissions show that '8th, 2016 1:01AM' is always shown. I am using a webform to submit the details.

Everything else is correct, just this. Any ideas please?

CIVICRM 4.5.8
Drupal

Thanks,
Andy


texts: uploading new contacts with relationships

texts: We are using civi to help us fundraise for our school. Each year we upload the new parents to the database from a csv from schoolbase. We need to add a relationship for each parent to their child(ren). This is important, because the communications we send vary based on the children's D.O.B (this enables us to tell which school year they are in without updating it every year). Is there a way to import these relationships at the same time as importing the contacts? Is this just a question of using correct field mapping? If they have more than one child would you need to have all the children in the same field? I'm assuming you'd need to import the children separately first, is that right?


texts:
We have an html email message that won't save and it seems related to size. if we remove a table or a few characters, we can save. But once we hit this unknown limit, we can't save a blank space. We can't make any more changes.

Anyone else run into this and know where the settings are to change this?


texts: Postfix creates email bounces with permissions set to 600, but CiviMAIL doesn't like that!

texts:
My new installation of CiviCRM 4.6.6 is virtually perfect but for one thing I cannot solve.

Incoming bounced messages are handled by the Postfix server and placed in a  directory where they are given permission 0600 in other words read and write by the owner only - "civicrm".

When I run the emailprocessor.php it happily deletes those messages but apparently can't read them! If I manually change their permissions before running the script then all is well and the bounces are correctly processed and the users marked "on hold".

Can you suggest a solution please?


texts:
I know there are some issues with how Wordpress sets page title. That being said, how can I change my current site title. All the pages I view have the title

CiviCRM ‹ civiCRM_test — Wordpress

I've been trying to figure out where this is set. It seems simple but grepping the file directory and searching the database  for 'civiCRM_test' revealed nothing. I'm assuming the problem is that the title concats various strings all of which are too generic to find with a search. This is simple if you know where to look but I'm not sure where that is. Thanks


texts: outbound mail smtp password gets corrupted on wordpress

texts:
I have a CiviCRM on WordPress site and every now and again - maybe once every few months - without me doing anything obvious, the SMTP password gets corrupted in Settings - Outbound Mail.

I'm not sure what is causing this to happen. This is the only site I have that it is happening on. Any ideas?


texts:
I've been keeping one eye on the Backdrop CMS since the fork from Drupal was announced, especially because part of the core audience is "small to medium sized ... non-profits" and the philosophy suggests that there is a goal of making future updates less of a major overhaul, which is appealing to some of the lower budget groups we work with.

I was curious if there is an official statement about CiviCRM/Backdrop and future support (or lack thereof)? How hard would it be to modify CiviCRM's Drupal 7 support to include a Backdrop option? I know that CiviCRM isn't "most modules", but the site claims:

  "Upgrading most modules to Backdrop can be done in days or even hours. With a familiar architecture, it's easy to upgrade."


texts: Mailchimp extension compatibility with CiviCRM 4.7

texts:
Can I install the latest Mailchimp extension on Civi 4.7.10 (Wordpress)?
Are there any comparability issues?


texts: How to get subsidiary membership to work?

texts:
For our purposes, memberships are organization-based, with individuals receiving membership benefits by being designated as an employee. This works great.

However, I have the use case where there is a subsidiary company that is part of the larger member company, but has a different name. This matters because if a person registers for an event under the subsidiary company name, they are not recognized as a member and fall out of the member smart group, which we use for mailing list, access, and other purposes.

I created a new membership type called Subsidiary Members and set the relationship as "Partner of," then applied relationship that to a subsidiary of a member company. My hope was that this organization would gain membership via their parent organization, which would then pass down to employees. However, the subsidiary company is still showing as a non-member.

Is there another way I can make this work?

Running CiviCRM 4.7.29 on Joomla 3.8.3


texts: Got error on installing CiviCRM on Drupal 8

texts:
I tried to install civiCRM with Drupal 8 following this https://www.mydropwizard.com/blog/better-way-install-civicrm-drupal-8 but I am unable to do so. I am getting the following error:

Fatal error: require_once(): Failed opening required 'D:\Myprograms\php\civicrm\vendor\civicrm\civicrm-core/packages/DB.php' (include_path='.;D:\Myprograms\php\civicrm\vendor\civicrm\civicrm-core;D:\Myprograms\php\civicrm\vendor\civicrm\civicrm-core\packages;D:\Myprograms\php\civicrm\vendor/civicrm/civicrm-core/vendor/tecnickcom;D:\Myprograms\php\civicrm\vendor/pear/archive_tar;D:\Myprograms\php\civicrm\vendor/pear/auth_sasl;D:\Myprograms\php\civicrm\vendor/pear/console_getopt;D:\Myprograms\php\civicrm\vendor/pear/log;D:\Myprograms\php\civicrm\vendor/pear/mail;D:\Myprograms\php\civicrm\vendor/pear/net_smtp;D:\Myprograms\php\civicrm\vendor/pear/net_socket;D:\Myprograms\php\civicrm\vendor/pear/pear-core-minimal/src;D:\Myprograms\php\civicrm\vendor/pear/pear_exception;D:\Myprograms\php\civicrm\vendor/pear/validate_finance_creditcard;D:\Myprograms\php\civicrm\vendor/phpseclib/phpseclib/phpseclib;.;C:\php\pear') in D:\Myprograms\php\civicrm\vendor\civicrm\civicrm-core\install\civicrm.php on line 151

I am getting the above error when installing CiviCRM module. Please help


texts: Is is possible to save blocks from one mailing to reuse in another mailing using CiviCRM Mosaico?

texts:
I have two different newsletters – a monthly one to our full mailing list and a weekly one every other week to a smaller group. They use different templates so I cannot simply reuse a weekly issue as a monthly issue or vice versa, but I often need to repeat selected blocks (Mosaico) of content in both. At the moment, I am laboriously copying each element (title, text, button text, button link, image) from one mailing to the next, but this is really time-consuming.
Is there a way to copy a block from one mailing into another mailing, eg by copy and paste or saving to a library?


texts:
in my extension I have the need to manage a new contact information (I added a field in civicrm_contact, instead of using a custom field).
Using the buildForm hook, I can show the input element in the contact form, but I don't know how to write the field value in the database.
Is there a specific hook for this operation?

Thanks
Marcello


texts: Can multi-record custom field sets be sequenced so most recent ones appear first in the UI?

texts: We use a multi-record custom set, with a large number of fields.  Some contacts have 4 or more of these records so the display gets cumbersome, with the most recently created always shown last.  So there's lots of scrolling to make sure the correct, most recent record is retrieved from the bottom of the list.  Is there a way of reversing this sequence so the most recently created is first in the list?  Perhaps adding an additional MySql index to these records?


texts: I know that CiviCRM can send e-mail using SMTP and SSL by prefixing ssl:// to the SMTP server name, but my organization uses Office365, which only supports SMTP with TLS. Is there a way to get CiviCRM to work with the Office365 SMTP server (ideally without resorting to Postfix and sendmail)?


texts: How set Tags And Groups field set to NOT "collapsed on display"

texts:
Using Drupal 7 and CIVI CRM 5.x on windows 10 and Xampp

I can set this up in custom fields sets, but how do I set the native "tags and groups" field to expanded on initial display?


texts: I have 700 email addresses in an Excel doc. How can I import them en masse to a single smart folder for a one-off mailing?


texts: Lots of temp tables: civicrm_tmp_d_dflt_*

texts: On 5.6.0 (and prior), Civi seems to constantly be creating these civicrm_tmp_d_dflt_* temp tables and does not drop them. I'm seeing these keep growing in our database and have to keep dropping them manually.  What causes these tables to show up and why isn't it cleaning up after itself?


texts:
We have version 4.6.2 and 4.6.3 installed in different sites, and just noticed that the new Reports tab interface UI is broken.  You can click on the tabs but the main body of the report settings - columns, grouping, sorting, filtering, etc - is always visible just as it was in older versions.

I've checked the official demo site, running 4.6.4, and it looks OK there.  I also have a dev site on my local machine running 4.6.1 and it's OK there too.  Seems unlikely to me that this was broken for 2 whole "dot" releases.  I've cleared caches on Civi and Drupal.

Suggestions?


texts: Bring up contact by Amatuer Radio callsign rather than name

texts:
We have a database of Amateur Radio operators. One field is their callsign.
What I would like to do to make editing events faster, is instead of polling by their name, to add callsign to advanced search.
Is this possible?
Thanks,
Steve


texts: Event doesn't display location on info page

texts: After creating an event with an address the info page will not display the location nor the map.


texts: Import/export database from old CRM version(5.4.0) to New CRM version(5.15.2) in wordrpess

texts:
Currently I am using Civi CRM (5.4.0) and want to upgrade it. I downloaded new version and installed it in my wordpress website.

I had a separate database for CiviCRM. When I installed & activated new version CRM plugin, it created tables in existing wordpress database.

Now my concern is, how can I import contacts, custom fields, Profiles etc. in new CiviCRM. Old plugin had civicrm.settings.php for database connectivity but same not found in new one.


texts: why are my expired memberships showing as current?

texts:
can't give any other details than looking at my memberships, I see every single membership is showing as current despite we are LONG past the date when the memberships expired.

All memberships were imported from a csv.


texts: Why can't Smart Groups be assigned the Access Control group type?

texts: I'm using CiviCRM 4.5.8 and WordPress. I want people to only access the data for their state. I was going to use ACL to do that. I set up a smart group for Wisconsin, but there's no check box for Access Control. I can only check Mailing List. What's up with that? Thanks in advance!


texts: How can I generate a search results page from a list of contact IDs, programatically?

texts:
I have an extension that lets people filter contacts in various ways. I'd like them to be able to click to show these contacts in a standard Civi results page - with the action box at the top etc. So that they can manipulate them in the normal ways, by adding to groups and such.

Is there a recommended way to do this, programatically?


texts: Why does the donation process not produce a receipt either on screen or dispatched by email to donor?

texts:
We have joomla 3.6.2, CiviCrm 4.7.10 and PayPal Express (PP)
Donor receives an email from PP stating you sent a payment to ....
Donor should also receive an emailed receipt from CiviCrm but does not
Donor should also be returned from PP to an online receipt but is not, instead sees a red error page.

Where do I start looking for the answer!??

error message is
CiviCRM-001 -   @import url(/components/com_civicrm/civicrm/css/civicrm.css); @import url(/components/com_civicrm/civicrm/bower_components/font-awesome/css/font-awesome.min.css);    Sorry but we are not able to provide this at the moment. Failed to update contribution in database Return to home page.    function toggle( element ) { var parent = element.parentNode; var className = parent.className; if ( className == 'crm-accordion-wrapper collapsed crm-fatal-error-details-block') { parent.className = 'crm-accordion-wrapper crm-fatal-error-details-block'; } else { parent.className = 'crm-accordion-wrapper collapsed crm-fatal-error-details-block'; } }


texts: I've inherited old CiviCRM data from a Drupal install - how do I get upgraded and running in Wordpress?

texts:
I am running Wordpress 4.2.1, with CiviCRM 4.5.6. Everything works for my fresh install of CiviCRM.

Now, I am chair of a political organization, and I got the old data for my county from an ex-member who ran CiviCRM under Drupal, but I don't know what version of CiviCRM he used a few years back (I think it was around 2011).  I have imported the data into mysql as dbname "civicrm_original" and the current running config is "civicrm".

I tried to swap out the data connection string to use the "civicrm_original" database then ran the command:
http://<your_wordpress_home>wp-admin/admin.php?page=CiviCRM&q=civicrm/upgrade&reset=1

but then CiviCRM wouldn't run and it had errors like crazy, like fields not in tables and other tables not existing. So now i switched back the dataconnection to "civicrm" and we are running again, just not with all the old data.

1) how can I find out what version that database was?
2) how can I update the imported database to work with my current config?

I would be willing to update to the latest version of CiviCRM if need be.  or, would it be easier to copy the data over to the new database? I know the contacts table has new fields that aren't in my "original" db.


texts: "Groupings" of Option Values: are they actively used?

texts:
When editing an Option Group directly (from Administer / System Settings / Option Groups) (but not when editing the options for a custom field), I can fill in a "Grouping". There is a corresponding column "grouping" in civicrm_option_value.

The grouping isn't displayed when looking at a list of option values in the option group, or when editing a custom field on a contact.

Is there anything that makes use of the grouping within core? I'm encountering a situation in my work where it may be useful, depending on what it actually does (long list of school subjects, grouping by qualification system).


texts: Paypal payments - Pending (Incomplete Transaction)

texts:
We're on civicrm 4.7.5 on Drupal 7.

All contributions paid through the paypal standard payment processor are failing to successfully complete.

The user sees a successful transaction, but the contribution status is "    Pending (Incomplete Transaction)"

There is nothing in the CiviCRM log to suggest an error. The IPN is sent to the correct URL, the status recorded in paypal is HTTP 200 OK.

But when I copy the path into a browser:

https://[ourwebsiteurlredacted.com]/sites/all/modules/civicrm/extern/ipn.php?reset=1&contactID=9994&contributionID=5669&module=contribute&membershipID=9587

this prints the following message to screen:

Sorry, can not load CMS user account.

Any help debugging would be greatfully received!


texts: Trying to get New Member, Member Renewal Contribution working

texts:
CiviCRM 5.33.2, Drupal 7.78.  Using example tokens found in the CiviCRM docs at "Tokens and mail merge/Checksum for Contribution Pages for Membership Renewals" to create an email to go out, I am struggling to claim a victory.  The example I am using looks something like this in my email template...
https://oursite.org/civicrm/contribute/transact?reset=1&id=5&{contact.checksum}&cid={contact.contact_id}&mid={membership.id}
...but the membership.id does not get picked up when the mail goes out.  The contact.contact_id seems to grab the correct information, but the url ends with "&mid=" with no value filled in.
Help please!


texts:
I want to add a custom field use for activities (meeting)?
I did that using administrator -> customize data and screen -> custom fields

How can I achieve it by API 3.


texts: Permission to see Campaigns in Activity search criteria

texts: When I (admin) go to Search > Find Activities, the criteria includes a selector for Campaigns. Authenticated users, however, do not get that option. See the snippet below from such a user, in my criteria the Campaigns selector is right below the Location box. Likely means they're missing a permission (Drupal 7.69, Civi 5.21.0), but don't know which. There are a number of permissions associated w. CiviCampaign and I'd rather not open all of them because our use case is very narrow. Any guidance on which permission to grant, if that's what the issue is, appreciated.


texts:
Is it possible to build a url to be included in an email sent from CiviCRM such that when the user clicks the link, they will automatically be tagged with a term in the system? Or maybe add an activity to their record? Basically I'm looking for a way to do a 1-click and done action to track some things in the system.

Forgot to mention I am using Drupal.


texts: CRM/Core/Config.php line 41 throwing 500 error with new require_once api/api.php

texts:
Just updated our WP install from 4.7.22 to 4.7.23 -- but can't run the db update script, because whenever I rename the 4.7.23 folder to civicrm, I subsequently get 500 internal server errors while trying to load any civicrm pages. Error log indicates a problem at line 41 in CRM/Core/Config.php, which is require_once 'api/api.php'; ... so I searched the previous working iteration (it runs fine when I switch back to 4.7.22) and there is no mention of api/api.php anywhere. So I assume this line is new in 4.7.23, and I have to wonder why it's making civicrm completely unusable for our site.

Ideas?

More detail from the error message:

PHP Fatal error: require_once(): Failed opening required 'api/api.php' (include_path='.:/wp-content/plugins/civicrm/civicrm:/wp-content/plugins/civicrm/civicrm/packages:/wp-content/plugins/civicrm/civicrm/vendor/tecnickcom:/wp-content/plugins/civicrm/civicrm/vendor/phpseclib/phpseclib/phpseclib:/wp-content/plugins/civicrm/civicrm/vendor/pear/pear_exception:/wp-content/plugins/civicrm/civicrm/vendor/pear/auth_sasl:/wp-content/plugins/civicrm/civicrm/vendor/pear/net_socket:/wp-content/plugins/civicrm/civicrm/vendor/pear/net_smtp:/wp-content/plugins/civicrm/civicrm/vendor/pear/validate_finance_creditcard:.:/wp-content/plugins/civicrm/civicrm/:/wp-content/plugins/civicrm/civicrm//packages:.:/usr/lib/php:/usr/local/lib/php') in /wp-content/plugins/civicrm/civicrm/CRM/Core/Config.php on line 41


texts:
Some months ago we started getting a bunch of robot spam users registering on the website. Both a CMS (Joomla 3.9.24) and Civi (5.33.2) user/contact are created with only firstname, lastname, and email. Here's what I've investigated:

I checked to make sure the reCaptchas were functioning and increased those settings.
I've looked at the Civi logs and tried logging page activity in the CMS (with extensions), but I'm not finding any clues as to what page these robots are registering on. It's clearly a Civi-related page, because a Civi contact is created.
I disabled the public mailing list sign-up profile temporarily and still got robot registrations.
I've changed the settings on public "stand alone" profiles to send me a notification email when someone uses them. Still getting registrations without any Civi notification.

What are some next steps to help me figure out where these are coming from and how to stop them? I know there is a Civi extension to up the game with reCaptcha, but if I'm not sure what page/profile to deploy it on, I'm not sure how that would help.


texts: Exporting membership type and contribution total amount

texts:
An organization sells a variety of membership types.   The goal is to generate an exported CSV that will contain name, address, membership type, and amount paid for that membership.

Two types of memberships are the same price, and CiviDiscount is in use regardless.  Thus total amount of the membership contribution is not a reliable way to determine which membership type someone has purchased.

Unless I use price sets and the 'extended reports' extension from Eileen, I cannot find a way to export "membership type (membership)" as well as "total amount (contribution)" data in the same CSV export.

But this extended report doesn't contain address.  So time to expand that report I guess?

Am I missing an easier solution here?


texts:
How do you delete a duplicate contact on CRM please?  I have looked at the various fields but can't find any deletion button.

Kind regards
Amanda


texts: Using CIVICRM API can I get both mobile and phone number?

texts:
I am trying to work out how to call both a phone number and a mobile number using the API. I am in civicrm/api and can get one or the other but not both. Can anyone suggest a solution!?

Thanks
Caroline


texts: Installed on Subdomain Civimail is blank

texts:
I just installed civi 4.7.27 on Wordpress 4.9.1 into a subdomain example.mysite.com
The civimail New Mailing page is blank and the System Status page is blank. Other pages are probably blank too.


texts: How do i access the list of email addresses that bounced

texts: I am using SparkPost for mail delivery of CiviCRM mass mailing.  I can see the types of bounces that we had but i haven't found a list of email addresses that bounced.  How do i find the email addresses that bounced?


texts: List all Profiles in a group when using "Profile Search Form" as a Joomla menu item

texts:
I have a Job Postings profile that gets recorded on a contribution form. The user is then added to a "Job Postings" group. I'd like to have a Profile Search Form on a Joomla page (menu item) that automatically loads every profile record in that group into a list.
Currently, I have it set up to where the user would have to hit search without any filters to populate the list. Like in these images below:
What you see on page load:

What you see after the user hits "Search" with no filters. (all records are returned):

I'd like the query in that second image ("Displaying Results where: Groups(s) in Job Posting...AND...Group Status 'Added') to be the default search on page load, so that the user gets the whole list of job postings automatically, and then can filter with the search criteria if he or she likes.
Right now I am looking into the Listing.tpl file located at: /administrator/components/com_civicrm/civicrm/templates/CRM/Profile/Page  and have noticed a variable named $qill that seems to hold the search criteria, and some other variables like $row and $search that also control how information is shown on these types of pages. Maybe there is something that can be done with these variables somehow (if I can find where they get defined)? Is there a simple answer to this I am missing?


texts: CiviMail - CiviCRM (Drupal 7): Problem with attached documents

texts:
We are having a problem when sending emails with attached documents from CiviCRM and happens in both ways simple and bulk emails. Three months ago, we hadn’t this problem, we sent a bulk email last July with a PDF document attached with a size of 2 MB (approximately) and the mails arrived with the PDF without any problems.

Recently we tried to reproduce that same bulk email with also the same PDF but with a different group (a testing one) as recipients this time. The emails arrive to the recipients but without the corresponding attached document.

Right now, when we send emails with attached documents whose size is below 900 KB (approx.) the emails arrive correctly. But when the size of the attached document is below that, the email keeps arriving without the document.

And isnt appearing any error messages.

We would be grateful if anyone could give us some clue about this.

Thank you

CiviCRM version: 4.2.7
Drupal 7 version: 7.59


texts: Managing Large Conference Sub-Programs in CiviCRM

texts: I work for an organization that has a long history of putting on large conferences and we want the workshops and panels of these conferences to stored in CiviCRM connected to those who spoke and attended. Where would be the best place to do this? Should I create a Custom Field for Programs or should they each be activities so I can have more than one contact record connected to it?


texts: How to increase limits on activity attachments?

texts:
Current (4.6.7) limits say that an activity can have up to 3 attachments, each being less than 2MB.

I need more, and a bigger file size limit.

What are the obstacles to achieving this?

I can't see anything in the db schema that implies a limit per activity, so is it just the UI that imposes the number of file limits?
The files are stored (I assume) in the civicrm_file.document field which is a MEDIUM_BLOB and can therefore store a file just under 4GB. (my requirements are only ~20MB.) Is that 2MB limit set in a PHP ini file?

Thanks.


texts:
I'm in Wordpress 5.2 and the Civi menus disappeared. I brought up my inspector and isolated the problem to Keyboard Accessible Menus (KAM). The fallout there is that CiviTutorial and Recent Items Menu have dependencies on KAM. There were a handful of minor security related updates that followed WP 5.2. I'm not sure what else might have interacted with KAM, but it's managed to kill about 1/3 of my day.

Other than, am I alone with this problem, am I looking at bigger issue when KAM integrates into core?


texts: Can you edit webform submission values without invoking payment?

texts:
We have a webform that is used for a complex event registration, with all of the registration details stored in the webform and nothing in CiviCRM except the contribution record.

We'd like to be able to edit some of the registration details that users have submitted to the webform, but using the edit submission link leads to the payment part of the submission - requiring that payment details be entered again.

Is there any way to simply edit some of the webform submission values, which aren't connected to the payment, without resubmitting the payment?


texts: Migration to new server - "The requested page "/" could not be found."

texts:
In following the procedure outlined in the Wiki I find that in Step 10 ("log into drupal") I'm seeing the message Page not found The requested page "/" could not be found.  The drupal menu is not there.   The login form is there, and once I log in I get  the 404 message The requested URL /civicrm was not found on this server.

error_log:  File does not exist: /var/www/html/civicrm,

When I try drush:

drush up --debug  --uri htp://mycivi.site.org
Starting Drush preflight. [0.03 sec, 4.12 MB]                                                                                [preflight]
Cache HIT cid: 7.0.0-commandfiles-0-81cc86c1995ab7206f383ec28ad43baf [0.05 sec, 4.21 MB]                                                                                [debug]
Bootstrap to phase 0. [0.2 sec, 10.22 MB]                                                                                [bootstrap]
Bootstrap to phase 6. [0.2 sec, 10.22 MB]                                                                                [bootstrap]
Command pm-update needs a higher bootstrap level to run - you will need to invoke drush from a more functional Drupal environment to run this command. [0.2 sec, 10.22 MB]                                                                              [error]
The drush command 'up htp://mycivi.site.org' could not be executed. [0.2 sec, 10.23 MB]                                                                                [error]

I'm guessing the drupal restore from the source server did something to the drupal database on the target server that changed a path.

Source server drupal path = /var/www/vhosts/contacts/httpdocs

Target server drupal path = /var/www/html

Do these paths have to be identical for a migration to work? Or is there something else I'm doing wrong?


texts: How do I configure printing to format properly?

texts:
We have a WordPress install that has never had the report printing formatted properly.  A report list does not have columns and rows with lines around cells.  Attached is an example from my system and one from the CiviCRM demo WordPress site.

What do we need to do to get properly formatted reports.


texts: Can i print or save a pdf of all activities

texts:
I need to print or save as a pdf all activities for any of our contacts on civi.  This would be used to report to meetings etc on work we have done with individuals who use our support services.  at the moment, i am printing each individual activity, which is laborious and time consuming!  is there any way i can generate a report that lists all activities?

thank you


texts: CiviCRM 5.29.0 installation with CiviBooking 1.5.3 causes fatal Wordpress error with no admin email sent when using civiBooking

texts:
New CiviCRM user here having a fair amount of trouble getting started with CiviCRM 5.29.0 and CiviBooking 1.5.3. Short story is that CiviCRM installs fine and we can interact with all native CiviCRM features without issues. We can add CiviBooking without issue. When we try to open any of the following pages, it throws a critical Wordpress error but never sends an email to the admin email address detailing the issue:

Add Resource (from New Booking, when no Resources have been configured)
Add Resource Configuration Unit
Add Resource (from Manage Resources)
Add Additional Charge Item (from Additional Charges Item)

All other pages can be interacted with fine in CiviBooking. I tried two different installations (one to the Wordpress backup we got and another to a new Wordpress installation), both had the same problem. I tried installing an older version of CiviCRM that is explicitly called out as supported in the CiviBooking documentation (CiviCRM 4.7.31.x) but that completely crashed Wordpress.
Has anyone else experienced this and know what the issue is?
Thanks :)


texts: I'd like to offer Contacts the ability to purchase a package of six event registrations that can be used over the course of a year. Can anyone suggest how that could be accomplished?