texts: How can I find a contributor to help my organization with an urgent/difficult upgrade?

texts:
We are a global NGO based in Costa Rica and I haven't been able to find an expert to help us upgrading our CiviCRM System.
We are now using CiviCRM 4.7.23. and have a new site on Wordpress. We haven't updated it because we haven't found someone to safely transfer our old data to a newer version.
We need help!


texts: Drupal Rules are not working properly when check CiviCRM Contact's Subtype

texts:
I’m using Drupal 7.56 and CiviCRM 4.6.31.

I’ve been using Rules in Drupal, as I need to copy the Household Name to the Last Name of a Particular Individual contact subtype (Child) whenever the relationship between the Household and this type of Individual (Child) has been established, but the Drupal Rule is not working.

Rule "Copy Family Name to Individual Last Name”

I've set up the following conditions reacting on the Event “CiviCRM Relationship has been created”:

Conditions

ELEMENTS

Data comparison

Parameter: Data to compare: [civicrm-relationship:relationship-type-id, Data value: 8]

(Type ID of Relationship between the Household and the Individual of type 'Child')

AND

Text comparison

Parameter: Text: [civicrm-relationship:contact-id-a-contact:contact-sub-type,
Matching text: Child]

Action: Set a data Value

Selected Data:

 civicrm-relationship:contact-id-a-contact:last-name

Value

 civicrm-relationship:contact-id-b-contact:household-name

This is the output to debug the values of the fields for 2 contacts:

civicrm-relationship:contact-id-a-contact:contact-sub-type:

   0 (String, 6 characters ) Parent

civicrm-relationship:relationship-type-id:

   8

civicrm-relationship:contact-id-a-contact:contact-sub-type:

   0 (String, 5 characters ) Child

civicrm-relationship:relationship-type-id:

   8

These is the Devel log:

•   Reacting on event CiviCRM Relationship has been created.

•   Evaluating conditions of rule "Copy Family Name to Individual Last Name".

•   The condition data_is evaluated to TRUE

•   The condition text_matches evaluated to TRUE

•   AND evaluated to TRUE.

•   AND evaluated to TRUE.

•   Rule "Copy Family Name to Individual Last Name" fires.

Rule Copy Family Name to Individual Last Name fires.
Evaluating the action data_set.
Evaluating the action devel_debug.
Evaluating the action devel_debug.
Rule Copy Family Name to Individual Last Name has fired.

•   Saved civicrm_relationship:contact_id_a_contact of typecivicrm_contact.

•   Finished reacting on event CiviCRM Relationship has been created.

But, despite the subtype of contact the action, the action is executed; even for the “Parent” contact subtype, when in the conditions is set up just for “Child”.

Why the condition civicrm-relationship:contact-id-a-contact:contact-sub-type contains ‘Child’ is evaluated TRUE, for all the subtypes of contacts, even for the ‘Parent’ contact subtype?

If I change the type of conditions to “Data comparison”:

Conditions

ELEMENTS

Data comparison

Parameter:

Data to compare: [civicrm-relationship:relationship -type-id, Data value: 8]

AND

Data comparison

Parameter:

Data to compare:
[civicrm-relationship:contact-id-a-contact:contact-sub-type,

               Operator: is one of, Data value: Child, ☺Child☺]

These is the Devel log:

•   Reacting on event CiviCRM Relationship has been created.

•   Evaluating conditions of rule "Copy Family Name to Individual Last Name".

•   The condition data_is evaluated to TRUE

•   The condition data_is evaluated to FALSE

•   AND evaluated to FALSE.

•   AND evaluated to FALSE.

•   Finished reacting on event CiviCRM Relationship has been created.

The conditions are never met.

Why the condition civicrm-relationship:contact-id-a-contact:contact-sub-type is one of ‘Child’ or ‘☺Child☺’ is evaluated FALSE for the contact subtype “Child”?

Could someone have any tip about what is happening?

Thank you so much for your help.


texts: Creating a summary of contents on civil mailings

texts: Wondering if there is a feature in a civi mailing to create a summary of the various stories that are being included in a mailing whereby each story title in the summary is clickable and takes you further down in the email to the corresponding story.


texts: Any way to limit geocoding to city or zip?

texts:
For privacy purposes in making a public member map - I'd like to set up the geocoding not by the full address, but by the city or zipcode. Is there a way to do this without creating a custom geocoder?

Thanks!
Harold


texts: Can't login to dashboard or create a member account

texts:
I get the following error when trying to create a member account login or creating a directory.

0 -   @import url(/administrator/components/com_civicrm/civicrm/css/civicrm.css); @import url(/administrator/components/com_civicrm/civicrm/bower_components/font-awesome/css/font-awesome.min.css);    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 must be logged in to view this page. 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:
when i send mail (Mailing-> New Mailing) the mail won't send and i get this message when i view the mail report

  Delivery has not yet begun for this mailing. If the scheduled delivery
  date and time is past, ask the system administrator or technical
  support contact for your site to verify that the automated mailer task
  ('cron job') is running - and how frequently.

The Send Scheduled Mailings  from Administer-> System Setting-> Scheduled Jobs is enabled and when i Execute now manually it works fine. The Send test functionality also work fine.


texts: Edit smart group criteria resets Group(s) to Administrators

texts:
I just found this issue on the latest 4.6.21 release but was able to reproduce on 4.6.18 as well.

When I create a new smart group:

Search -> Advanced Search -> Choose any group but Administrators -> Create smart group

then in the next step I want to edit it:

Contacts -> Manage Groups -> Choose the one you just created -> Settings -> Edit smart group criteria -> On the top of the page Edit xyz smart group criteria

and I see Administrators Group there not the one I chose originally.

This seems to be a bug to me?
Can anyone confirm or test on previous releases?

Thanks


texts: How to restrict contacts that can be assigned to an activity?

texts: Two of my clients would like to be able to restrict the contacts that can be assigned to an activity.  This is because they handle highly sensitive information and it would be potentially disastrous for them to accidentally select the wrong contact (e.g. a client rather than a case worker).  This was asked before here and the question was rated a 5 - the answer from Coleman was to make a code change. I think there's a good case to build some kind of configurable restriction into core. So I'm asking this question again to see how much support there is for a core update, or alternatively to see if anyone has a better idea.


texts: Delete multiple contacts from a list input

texts:
Civi is a great platform and I started to use with the first action to organize some old contacts. I could import them fine and I see them in the system.
The problem is that we are doing some cross-checking for the accounts' current validity and at some point we need to delete some of them but based on a list of items, let's say emails that should be inputted somehow.
So the question is: is there an option like that? An input area like the "import contacts" where we can upload a file (maybe csv or text) with the emails to delete, then the script would just remove the contacts found.
Thank you very much!
Andy


texts: Can a CiviCRM member upload post content to a cutstom post type in Wordpress?

texts:
In short, can a person register on CiviCRM, and then be given permission to post content for review (such as an upcoming event or job opportunity), which can then be moderated and approved by an admin?

We are considering CiviCRM for our organisation and think this is possible, but want to make sure.


texts: How can I log hours that I have contributed to the project?

texts:
CiviCRM is contributed to by hundreds of people: users who report issues/bugs/suggestions; implementers; developers; people who take time to offer advice on this site or on chat.civicrm.org.

It's useful for the project to have a measure of this, so we can appreciate everyone's input. As well as helping build a picture of the work that goes into improving CiviCRM over time, people who contribute enough hours can be listed on the find an expert page.

How can this be measured and how can I record my time?

(Note: I'm listing this here with an answer because the information was very hard to find.)


texts: I'm finding the More actions link that appears at the righthand end of CiviCRM displays to be missing in Shoreditch. Presumably this is not by design? Some actions appear to only be accessible through that menu.


texts: Good resource for learning civicrm and drupal

texts:
I want to learn civiCRM and drupal.
Please tell me some good resources and tutorial with example.

Thanks in advance.


texts: Civi Reporting - where's the preview tab?

texts: I am building activity reports and the preview tab is missing from the top , likewise I am unable to access the report title tab.  is this something that can be added in , if so, how ? thanks in advance


texts: Custom Field for CiviCRM Membership not accessible from Drupal Rules module

texts:
I'm trying to access a custom field used for Membership in CiviCRM from the Drupal Rules module.
But it seems this custom field, civicrm-membership:custom-8, in not accessible from the Drupal Rules modules and it doesn't contain any value.
This is the rule I'm trying to create to add a CiviCRM Contact to a Group:
{ "rules_add_group_to_contacts" : {
"LABEL" : "Add Contacts to Groups",
"PLUGIN" : "reaction rule",
"WEIGHT" : "1",
"OWNER" : "rules",
"REQUIRES" : [ "devel", "rules_conditional", "civicrm_entity", "rules", "civicrm" ],
"ON" : { "civicrm_membership_create" : [] },
"DO" : [
{ "devel_debug" : { "value" : [ "civicrm-membership:custom-8" ] } },
{ "CONDITIONAL" : [
{
"IF" : { "text_matches" : {
"text" : [ "civicrm-membership:custom-8" ],
"match" : "Stay and Play - Coffee mornings"
}
},
"DO" : [
{ "civicrm_entity_rules_action_assign_contact_to_group" : {
"contact" : [ "civicrm-membership:contact-id-contact" ],
"group_id" : { "value" : { "18" : "18" } }
}
}
]
I'm working with Drupal 7.
Many thanks in advance for your help.


texts:
Is there any CiviCRM support for Vanco as a payment processor? I do not see them on the list of payment processors in the current release. I searched the exchange and did not find them mentioned. I saw a two year-old posting on Drupal for a module, but the instructions seem out of date.

CiviHosting told me it works with the current release of CiviCRM and Drupal 7, but when asked how to do it, they tell me they do not know.

Any help would be appreciated.


texts:
Have you found an easy way to manage a fundraising pipeline using CiviCRM?

If so, can you please share how you set it up?

Thank you.

Thanks everyone for your responses!  To clarify, this is for tracking foundations, not individual donors. We would like to be able to see where we are in the process with a particular funder. Initial Inquiry, Proposal Sent, Under Consideration, Accepted, Denied


texts: Add custom data field column to relationship tab

texts:
Is there a way to add additional field(s) in the relationship tab on a contacts record?

as " hook_civicrm_searchColumns is not getting triggered for relationship.
( though this hook is helpful for contribution tab and other search results.)

can any one please advice what would be best way forward to achieve this?


texts:
Hi I am testing updating memberships via the front-end 'import memberships'tool.
The [membership id] is required in order to do this. For the life of me I cannot find a way to get it out of Civi  (cannot go inot the db, need to stick to stick to the frontend interface for users).

It's not on screen, not available as a field on membership reports, not available to set up as a profile view...

We are on 4.6.12
Any tips appreciated.


texts:
We have memberships set up on our site, which are required to auto-renew. The page is set up to allow payments via credit card (Authorize.net), Paypal, and offline. Paypal works fine for recurring transactions. Authorize.net, however, appears to only be working for recurring contributions. Those show up in the transaction report over at Authorize.net just fine - even shows how many contributions the person signed up for, how many are remaining, etc. But not a single one of the memberships paid for via credit card show up over there as recurring.

Is there something I am missing?

Update:

Just had a transaction come through on the membership page. As I said earlier, all transactions are set to require auto-renew. The transaction details over at Authorize.net said:

Recurring Billing Transaction:  N

So obviously something isn't being sent to Authorize.net properly on the membership pages, but is working fine for contributions.


texts: How to embed Drupal Views in a CiviCRM Email Template?

texts:
Has anyone added a Drupal view to a CiviCRM template?

For example, we have build a CiviCRM email template with a Latest news list on the right hand side of the template. We would like to pull in the latest news links from a Drupal view that is referencing a New content type.In theory it is similar to adding a block to the right hand side of the template.

This way users creating the template do not need to manually add the links to the right hand side of the newsletter. Thanks.


texts: Unsubscribe link shows all groups in Civicrm

texts: When an email recipients clicks on the unsubscribe link in a Mosaico email, every group in Civi is revealed. EG Are you sure you want to be removed from the mailing list(s) shown below: 100 plus groups appear This happens whether the person is subscribed to all of the groups or not. Is there a way to ensure that they just see the group that they are subscribed to? Some of the information revealed is potentially sensitive.


texts: What does 'Enable global server wide lock for CiviMail' do?

texts: At Administer > CiviMail > CiviMail Component Settings, there is a setting called 'Enable global server wide lock for CiviMail'. What does it do? When it is a good idea for a site to have it and when it is a good idea for a site to have it on?


texts: How to Create a Smart Group before Anyone Belongs to it?

texts:
The usual way to create a Smart Group is :

Select (via Advanced Search) the contacts who meet the Search Criteria
Create the pertaining Smart Group

But is it possible to create a Smart Group before anyone meets the search criteria (so that the Group is automatically filled as soon as one contact meets the criteria) ?


texts: CiviPoints - Basics on how to configure and use this extension

texts:
I need some basic guidance on configuring CiviPoints and using it. I have installed already on our Wordpress site. But I don't see any simple guide on how to set it up and use it. Simple example with screenshots would do.

PS: I also installed CiviRules. So an example with CiviRules with CiviPoints would be great.


texts: Bug? Can not remove Group from contact while in Edit Mode

texts:
Issue occurs in CiviCRM 4.6.9 and can duplicate in 4.6.10 on CiviCRM.org demo site using WordPress.
Step1. A contact is in a group.
Step2. Edit the Contact and scroll down to the "Tags and Groups" area and click on the x to remove the "Group(s)".
Step3. Click on the Save button and the contact is still part of the Group.
Note: This process did remove the contact from the group on previous versions of Civi... I just confirm this.  It does work on a 4.5.8 version of Civi.


texts:
In some of my CiviCRM database, i have contacts who share the same email.
I don't want people to modify the wrong contact when filling a public anonymous form.

To avoid that, I'd like the unsupervised dedupe rule for individual to be Email + First Name.

When i go to the UI (/civicrm/contact/deduperules?reset=1&action=browse) i see it's not possible to change the default rule.
Is there any problem to expect if i disable the default rule in the database by setting is_active = 0 and create a new unsupervised rule ?

EDIT

I see there is no is_active field so i guess i will have to either delete, either changed it to a General type of rule.

The question is the same - is there any problem to expect ?


texts: How to customize the layout of a Contribution form created in Wordpress

texts: The title pretty much describes the question. In Wordpress it is easy to customize the layout of a post/page by using child theme. I wonder how to do so for a CiviComponent, say, contribution page.


texts: How do I increase the backtrace line length

texts: Log files include a backtrace which is very helpful for debugging but I find the lines get truncated so I cannot see all the values.  After about 200 characters I usually see an ellipsis ... and the line is truncated. can this be extended to see more info?


texts: How to troubleshoot DB Error: no database selected

texts:
I'm upgrading to Drupal 8. My database logins in civicrm.settings.php are correct but I continue to get this error. I'm just trying to load the dashboard at /civicrm.

Is there a way to produce more detailed error messages or an error log? The problem I am having is that this error message isn't providing enough useful information about the error to troubleshoot the problem. For example: which of the three databases it could not access or what the program was doing when the error occurred.

I would have to be able to do it from the command line.

There is nothing in /var/log/mysql/error.log


texts: Has anyone come up with an easy way to enter a household, the members, create the relationship, share the address, etc.?

texts:
Civicrm is extremely flexible with relationships.  The downside of that is it's a pain to enter new household and their members.  My users complain bitterly about how many steps it takes.  Yes, there are some short cuts but it's still a lot of clicks.   99% of our households are husband wife and happen to live in the same house.

Some of the pain points mentioned are for hh to sort along with individuals in any list of contacts, you have to create the household with last name first, e.g. Smith, Barb and Steve.  This means you then have to manually create the salutation manually, e.g. Dear Barb and Steve.  They also complain about the address saying things like "why can't the individuals automatically inherit the hh address or if one of the ind has an address why can't the rest inherit it"

So has anyone create a form or maybe a webform that has something like this:

Contact 1:  First Name, Last Name, email

Contact 2:  First Name, Last Name, email (If last name same leave blank or prepopulate last name from contact 1)

Shared Address info:

Household info:  Prepopulate household name from contact 1 and 2 (e.g. c1 Lastname, c1 first and c2 first or if c2 last is different C1 Last, C1 first and c2 Last, c2 first)
Prepopulate the salutations from c1 and c2 (e.g. Dear C1 First and C2 first)

Then when you save it, it creates the three contact records and the relationships, with hh having the address and the ind sharing it.


texts:
I frequently send emails to a large mailing list. In this mailing list there a roughly two categories of contacts:
1) members
2) non members

Ideally all would receive the same email, but I'd like to include a block/message ("the block") in the email for non members that encourages them to either renew their membership or sign up for membership.

I currently use mailchimp to design my emails. If I were to create "the block" in mailchimp, I'd have to create a second version of the mail that doesn't include "the block" and split my mailing list in two parts so that everyone receives what I want them to receive. To me this sounds like a sub optimal solution and one that is prone to go wrong at some point.

Would it be possible to optimise this using CiviCRM? I know that Civi currently copies my organisations address details at the end of each email. Would it be possible to create a block such as described above that Civi automatically inserts in emails to non-members, but leaves out in emails to members without having to send multiple emails?

If so, is it possible to make such a block look nice? (Currently the address details that Civi inserts look really bare). My website is a drupal website.

Thanks in advance for your help. I'm also open to any other suggestions you might have!

Elise


texts: After upgrade to 4.6, should I get "No available releases found warning" in Reports->Available updates?

texts:
In the Drupal menu item "Reports->Available updates", I get the below.  Is this normal or is there something I could / should do to fix this?

civicrm 4.6.0                                     No available releases found
Includes:
Enabled: CiviCRM, CiviCRM Contact Reference Field, CiviCRM Theme, CiviEngage, CiviGroup Roles Sync, CiviMember Roles Sync
Disabled: CiviCRM OG Sync, CiviCRM Rules Integration


texts: I need to load about 300 pledges from a spreadsheet. The best solution seems to be the API Loader but it is listed as 4.4 we are on 4.6 going to 4.7. Can we get the extension tested for 4.6 and 4.7


texts: We are using Wordpress 5.7.  Our current CiviCRM version is 4.7.31.  As of August 2020, CiviCRM event registration stopped working due to the Wordpress update.  Now, we can not seem to process memberships through CiviCRM either.  As of now, I am sending people directly to PayPal, but for membership registration should upgrade, update, or replace our current CiviCRM version as it no longer working compatibly with our Wordpress site


texts: How to let extension users choose cache system?

texts:
CiviCRM contains some useful caching infrastructure (confluence wiki and related question).

If I am creating a module and I would like to allow users to override the default Civi::cache() specifically for this extension how should I do that?

I think putting some settings (maybe a factory function?) in the civicrm.settings.php would be the best way? Is this correct? And any examples?

I'm thinking I could just put something like this in my code:

if (function_exists('myextension_cach_factory')) {
  $cache = myextension_cach_factory();
}
else {
  $cache = Civi::cache();
}

Then the settings file could contain something like

// civicrm.settings.php
function myextension_cache_factory() {
  return new CRM_Utils_Cache_SerializeCache(array());
}

or maybe even:

//civicrm.settings.php
function myextension_cache_factory() {
  return new CRM_Utils_Cache_Memcached(array(
    'host' => 'localhost',
    'port' => 11211,
    'timeout' => 3600,
    'prefix' => 'mec_',
  ));
}

Background:

$civicrm_root/CRM/Utils/Cache/Interface.php defines a minimal standard interface for caching with get(), set(), delete() and flush() methods.

$civicrm_root/CRM/Utils/Cache/ has these useful looking implementations:

APCcache.php
ArrayCache.php
Memcache.php
Memcached.php
NoCache.php
SerializeCache.php
SqlGroup.php


texts: Clearing/disabling out-of-date event locations

texts:
Is it possible to hide/disable event location addresses? Or manage them at all without digging around in the database?

I'm using Drupal Views to search by event location, but that doesn't help when adding locations - we have a long list of event locations, and because they're not sorted, and can't be searched, people keep adding superfluous duplicate locations, which makes the situation worse...


texts: Contributions - Receipt (on-line) Transaction # in Message Template missing

texts:
Since some update in the 4.x line we do not get the Transaction # from contributions in the message template anymore. This happens although the ID gets recorded in the DB correctly.

This is the part that never gets executed because $trxn_id is empty ($is_monetary = 1).

{if $is_monetary and $trxn_id}
  <tr>
    <td {$labelStyle}>
      {ts}Transaction #{/ts}
    </td>
    <td {$valueStyle}>
      {$trxn_id}
    </td>
  </tr>
{/if}

We use the PayflowPRO processor (modified).

Any ideas?


texts: How to show the State in the public participant listing?

texts: I want to include the State/Province in the public participant listing which is currently showing the Name, Status, and Registration Date. Please let me know how to add this.


texts: Can't use backup migrate module, CIVI crm error is: "The website encountered an unexpected error. Please try again later."

texts:
Been using Xampp and doing backups for years, it's Xampp portable, so solved my timeout issues a long time ago...

All other sites on this Xampp local work fine, using windows 10, 64, and Drupal7/CIVI CRM.

This worked fine, but just stopped suddendly.

I looked a the error log , and Drupal doesn't even have an "admin/config/system/backup_migrate" directory, am I missing something here?

Now getting these errors:

The website encountered an unexpected error. Please try again later.

Log shows this:

Type    php
Date    Friday, September 28, 2018 - 16:50
User    1
Location    http://localhost/crm4/admin/config/system/backup_migrate
Referrer    http://localhost/crm4/admin/config/system/backup_migrate
Message PDOException: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'crm4.civicrm_value_files_8' doesn't exist in engine: SHOW CREATE VIEW `civicrm_value_files_8`; Array ( ) in backup_migrate_source_db_mysql->query() (line 435 of C:\Core\XAMPP_2018\htdocs\crm4\sites\all\modules\backup_migrate\includes\sources.db.mysql.inc).

**


texts: Suppress 'Unsupported locale specified to parseStreetAddress: en_GB' message

texts:
If debugging is enabled,  'Unsupported locale specified to parseStreetAddress: en_GB' message appears in some situations (add/edit contact), which scares non-techy editors.

There are some ancient posts at civicrm forums, which describe clearly  why   this message appears, but I've not been able to find a recipe of how to stop this from popping up, apart from a general advice of "provide custom logic for parsing UK postal addresses".

Any hint about how to hide the message, please. Thanks!


texts:
Is it possible to generate and send several .pdf files with CiviRules "send PDF" function? I want to send an invoice and a certificate that have different templates.

I could send several emails but one email with 2 attachments sounds better. :-)

regards,
Guillaume


texts: ProPublica Congressional API CiviCRM Module

texts:
Until 2014 there was active development on the Sunlight Congress API and there was and is a CiviCRM module that uses the Sunlight Congress API to make Congress data available to CiviCRM.

ProPublica has taken over development of the Sunlight Congress API and merged it with it's own Congress API

Is anyone planning to update the CiviCRM Sunlight Congress API module to work with the ProPublica Congress API module so that CiviCRM maintains the ability to link to information about the activities of Congress?


texts: In API Explorer, Add Parameter and Add Option links do not work

texts:
I've been looking at the API explorer for a while. It's a great idea: the API is poorly documented, but this would be a perfect sort of live documentation. but I never got it to work.

I can choose an entity and an action. But add parameter, add option and chain api call dont do anything. The labels 'name','operator' and 'value' are hanging there with question marks and helptext. 'operator' says 'Choose an operator from the list', but there is no list.

I can execute, but I get a very generic call without parameters. I get no javascript errors. I have this on multiple Drupal 7 installations - looking at CiviCRM 4.5.3 now.

Everyone seems to be happily using it...


texts: I have a PR that adds a file CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl.  How should I go about testing this code?


texts:
Following upgrade to 4.7.14 we are seeing two errors in lightboxes when opening Civi:

  Unable to download extension from
  https://civicrm.org/extdir/ver=4.7.14|cms=Drupal/single. Error
  Message: SSL connect error

  The CiviCRM public extensions directory at
  https://civicrm.org/extdir/ver=4.7.14|cms=Drupal could not be
  contacted - please check your webserver can make external HTTP
  requests or contact CiviCRM team on CiviCRM forum.

I have used wget on the server to check that it can access the address, which it can, and the SSL certificate for civicrm.org seems predictably valid! Has anyone else seen this error?


texts:
Since I've updated my installation of Drupal - CiviCRM to version 4.7.27 we got some errors. If we edit or add a user we can't select the birthday for the user. Like you see on the screenshots, we get some initialization errors and the date picker only allows one date (the date of today).

Anyone who can help figure this out? Thx!


texts: "DB error: already exists" when creating a Drupal user who already exists as a Contact in CiviCRM

texts:
I'm running CiviCRM 4.7.10 and Drupal 7.50.

I have had a Civi database for a while, but am now wanting to give people front end accounts in order to use some features there.

My problem is that when a user, who is already a contact in Civi, tries to create a Drupal account, they get the rather unceremonious "DB error: already exists".

I'm confused because I keep reading that Civi is set up to automatically merge new users with existing contacts on matching emails (or whatever criteria is set in the Unsupervised deduping settings for Individuals - mine is using email only at the moment).

I would love to understand how this is supposed to work and how to fix it when it doesn't.

Thanks,
Lewis


texts:
I'm not really good in any sorts of programing, haven't used smarty before. I want to change the monetary format in our Invoice.

{$amount|crmMoney:$currency}

This code displays $1000.00, but I need $1,000.00 or $1,000 , how can I achieve this?

my civicrm version is 5.1.1, joomla 3.9.4, CRM runs in Window 7

updates:
1. thanks to Joachim I notice decimal is working fine, thousand separators is not, whatever I input in Localization Currency> Thousand Separator, nothing displays.

2. upgraded Civicrm to 5.11.0, problem persist.

3. the problem is not in {$amount|crmMoney:$currency} or MONEY.php, I think something's wrong with my settings.


texts: How to modify price set values on existing membership?

texts:
We are a sailing club. Our members need to pay annually for:
- membership
- parking spot(s) for sailboat : a member can have multiple boats. There are different spots at different prices (outdoor, indoor)
- storage area for surfboard
- locker

I would like some advice how to set this up. Initially, I was thinking about using one membership type ("MemberVVWZ") and one price set, containing the above fields.

I am able now to create a new membership which includes the contributions of the different fields. However, when existing members wants to renew his membership, But instead of two boats, he wants to store only one boat. This means that I need to modify in fact the values of the price set. Is this possible with CiviCRM?

Or, is it better to make different membership types for the different kinds of contributions (membership "Parking spot," membership "Locker")

Any advice is welcome.


texts:
My events will not appear on the website calendar
Unable to upload images to the event description page
When doing a test registration, I do not receive a confirmation email

Could you please review?

Link to registration for Leadership Givers Reception:
https://www.unitedwaydgco.org/civicrm/event/info?reset=1&id=74

Link to registration for Campaign Celebration Dinner:

https://www.unitedwaydgco.org/civicrm/event/info?reset=1&id=75

Thank you,
Colleen


texts: Contribution page "other amount" option causes weird behavior - possible bug?

texts:
Using version 4.6.10.  I can reproduce this problem on the Demo site.
This is the problem:

Create a donation page with an "other amount" option in addition to
fixed price options.
Open the live-page or test-drive page link
Under Donation Amount, choose "Other Amount" radio button
Most of the fields on the page disappear:  the name and address fields, the credit card fields, etc.
Input an amount into the "Other Amount" box, and press enter, sometimes the fields briefly reappear.
But as soon as you scroll with your mouse, the fields disappear again, and you find that there are pink error messages at the top of the page asking you to fill in the missing form fields.
However, you can't fill in the missing fields because they have disappeared from the form.

Since I can reproduce this on the demo site, I suspect it may be a bug.  But I'm reluctant to report a bug until I've had some independent confirmation.

Any help would be most appreciated!

Leslie


texts: Forms generation with CivicRM Profiles under Wordpress

texts: When trying to use a profile for form input on a page, one of my profiles is available but the others are not.  Any ideas on what I may be missing?


texts: Should Word Replacement work on button text?

texts:
I have a contribution form page that is primarily used by folks who want to sign up for membership, which in many cases does not require payment.  I would like the button on the bottom, which currently shows a checkmark and the word "CONTRIBUTE", to say "SUBMIT".  I have tried putting that as a Word Replacement, both with all lowercase and all uppercase, but without impact.

In fact, I am not sure Word replacements are working at all.  They didn't work on a word I used in the body of a form, as a test, but that's not necessary, I can edit the word itself.

Any ideas?  If Word Replacement will never work, can anyone point me to where the 'CONTRIBUTE" button text can be edited directly?  Thanks!  (Using CiviCRM with WordPress, current versions.)


texts:
How can you tell if someone joins a mailing list (selects from a checkbox option in custom fields)?

How can you tell when someone updates their contact preferences?


texts: "Failed to execute rule" - Civirules error, How to solve?

texts:
I have a set of civirules in places, when a contact is tagged it should send a welcome email. But I am keep receiving the following error message in log and welcome email is not sent. It happens for new & existing contacts. Anyone has a clue what is it? How to fix it please? Thanks.

Log in Drupal:

Civirules api action exception: Mandatory key(s) missing from params array: source_contact_id. API call: Email.send with params: from_name="Email from", from_email="abc@example.com", template_id="108", location_type_id="1", alternative_receiver_address="test@me.com", cc="", bcc="", file_on_case="", contact_id="8949", extra_data="Array"

Log in Civirules Logger:

    Array
(
    [line] => 77
    [file] => /home/webadmin/public_html/cmm/sites/default/files/civicrm/ext/org.civicoop.civirules-master/CRM/CivirulesActions/Generic/Api.php
    [exception_message] => Civirules api action exception: Error sending e-mail to Katie Lost  . API call: Email.send with params: from_name="from name", from_email="abc@example.com", template_id="108", location_type_id="", alternative_receiver_address="", cc="", bcc="", file_on_case="", contact_id="9688", extra_data="Array"
    [rule_title] => Welcome Emails Workflow
    [original_error] => Error on {file} (Line {line})

{exception_message}
    [reason] => Failed to execute rule
)


texts: What does "Reserved" indicate on Financial Types/Accounts?

texts: I see we can set a Financial Type as "Reserved" with a checkbox. What does that do, and does it set that flag automatically on the associated accounts?


texts:
We have been struggling with the membership facilities in CiviCRM because we have been unable to find a way of allowing members to pay their memberships in instalments. We are using Drupal 7.x, CiviCRM 4.6.x and the eWay payment gateway. We wish to adopt the eWayRecurring extension to CiviCRM. Ideally we would like to do the following:

Allow members to pay their membership fees in a predefined series of payments. For example if the membership fee is $300 we would like to allow members to make an initial payment of say $100 and then make 4 monthly payments of $50.00
We are comfortable that the initial payment updates their membership in accordance with the membership type. In our case for the fixed period of 1 year starting on 1st January.
Subsequent payments would have no impact on the status of their membership but it would be good if they were 'linked' to the membership, however not critical.

My thinking was to create a Membership Price Set which contains the membership component and separately a recurring contribution to pick up the additional payments. The problem is that it does not seem possible to pre populate the recurring payment with the parameters required and prevent them from being altered by the user.

Is this possible or is there a better way that others have adopted?


texts: Why are members who have renewed their membership still getting reminders?

texts:
I have a scheduled job to send out membership reminders.  The job executes fine, people get their reminders and pay up for next year

However, next time the scheduled job runs the people who have renewed still get the renewal reminder.

I know this used to work ok but the past couple of years I can't seem to get it to work the way it used to.  I've had a look at lots of similar sorts of questions but I cant really understand what I'm doing wrong

Is there a setting I've got wrong or something I'm missing?

thanks for any suggestions


texts: Site broken. How do I fix Couldn't repair table: civicrm.log_civicrm_status_pref?

texts:
On Drupal 7.52 and CiviCRM 4.7.13

Recently I discovered Civicrm couldn't connect to MySQL. This wonderful error popped up when registering someone for an event:

DB Error: no database selected

Checking the SQL log I see the following over and over

Couldn't repair table: civicrm.log_civicrm_status_pref

How do I get rid of the problem? MySQL seems unhappy at start up when it says

1:55:43 UTC - mysqld got signal 11 ;

Followed by a bunch of mundane stuff, none appearing error related then

Some pointers may be invalid and cause the dump to abort.
Query (7fc4005eff10): is an invalid pointer
Connection ID (thread ID): 9
Status: NOT_KILLED

I've heard that if I drop the table civicrm.log_civicrm_status_pref this will fix the problem. Really? Is there anything else I should know? Is it really as simple as

SELECT civicrm
DROP TABLE civicrm.log_civicrm_status_pref

Then the world returns to normal?

What if I think MySQL is pooched and I want to re-install it. Will I then find a database server with no databases? Thanks for any help the community can provide. Until now CiviCRM has been running great. This is the only serious problem I've had with it but it seems to be quite a problem. I've tried recovering from backup. No go. Same error.


texts:
I just got started with setting up a small implementation of civicrm. We aren't heavy-users but I want to be able to get the cron jobs working.

I decided to use webcron via easycron because it seemed to be the most easy solution, and the one I got working without much hassle. ( https://docs.civicrm.org/sysadmin/en/latest/setup/jobs/#webcron )

So I managed to get the ...&job=process_mailing & ...&job=version_check running. But when I replace 'process_mailing' with 'execute' I get:

HTTP code 500 Internal Server Error

What is the problem? What am I missing?

edit

i am using civicrm 5.10.3 on wordpress 5.1


texts: Is this a paypal bug, or is this just fantasy?

texts:
An odd one this!  We have taken around 50 online event bookings today with no trouble, except for one.

We happened to notice that one contribution for £300 was showing as complete, but in fact the transaction at PayPal (using Website Payments Pro) was for £0.

The contribution has been set to the 'Accounts Receivable' Account, rather than the Payment Processor Account.

A submit credit card payment link has appeared, so Civi seems to know something is up, but to all intents and purposes the transaction appears successful so it was only by chance that we noticed.  Is this a bug, or have I missed some intended behaviour?

Thank you!


texts: Display CiviCRM Survey in Drupal Content Type

texts:
I have created a CiviCRM survey (under Campaigns > New Survey in the CiviCRM menu) but would like to embed this survey into a Drupal Content type. How might I do this?
I am using

Drupal 7.37
MySQL 5.6.24
PHP 5.6.8


texts: How are CiviCase Case ID numbers generated?

texts:
I've assumed that CiviCRM simply allocates the next available Case ID number when a new case is created. Certainly it has always looked that way. However, on one site I work with where cases are used extensively, we are seeing case numbering that suggests something else is happening:

Case ID numbers started at 1 and run pretty consistently up to 86, then a jump to 164, then a second jump from 167 to 249, then straight to 332, then from 372 to 617, from 620 to 747, and from 766 to 1059. (Taken from the civicrm_case table in the DB).

On another site, with a comparable number of cases, the case IDs run from 1 up to about 255 (last time I checked) without a break.

I'm concerned that the non-sequential numbering might be indicative of a problem.

What might be happening to make CiviCase create non-sequential case ID numbers?


texts: How to make a report that show all the enterprise that have at least 2 employees?

texts: Hi how did you do a report that show all the enterprise that have at least 2 employees ?


texts: Custom Field doesn't show up in Advanced Search

texts:
I created a custom data set called Volunteer Fields with one field. The name of the field is "Volunteer?". It's a Yes/No radio button and it's marked as Searchable. The documentation says:

Is this Field Searchable?
Makes the field appear in a panel of custom fields in CiviCRM's Advanced Search page.

I can't see it in Advanced Search. I can see and edit the field on the View Contact screen. I can search on the Volunteer? field using Search Builder, but there's no panel for custom fields in Advanced Search. I can't find the field anywhere in Advanced Search. Please Help...thanks!!


texts: Hi, how do I run a report that shows me all the people that became a NEW member (not renewals) for the month of October 2019?


texts: How to use Campaign ID (as a token) in Contribution Invoice/Email Receipt Template

texts:
We use Campaign ID (renamed using Word Replacer to "Project ID") to categorize different kinds of contributions. Some come in through online contribution pages, and some are entered manually on CiviCRM after we receive cash or checks.  I am customizing the "Contribution Invoice Receipt" system workflow message, and I tried to show the Campaign ID by using:

{$contribution.campaign_ID}
{capture assign=project_id1}{contribution.campaign_id}{/capture}{$project_id1}

None of these pull up the Campaign ID. And how come there are already contribution related fields in place in the template, such as $contribution_status_id or $amount? Is there a full list of fields available somewhere?

Once I identify the campaign id, I'm hoping to run something like

{if $campaignid==15}
Thanks for donating to Project 15! Bla bla (custom text)
{elseif $campaignid=17}
Thanks for becoming a member! Bla bla! (custom text)
{else}
Thanks for your donation! Bla bal (generic text)
{/if}

So after searching further into the StackExchange I found this, which shows you can get the full list by inserting {debug} into the template, then the template outcome will show it as an email Javascript when viewing the source.
Here is the cleaned up debug results, which indicates that the token to use may be $formValues.campaign_id. I then tested it, and turns out that it works on Contributions - Receipt (offline) and online, but not in Print Invoice.

Here is the list of formats that didn't work. (It seemed that on some paratemers CiviCRM was case sensitive)

{$contribution.campaign_ID}
{$contribution.campaign_id}
{$contribution.campaign_Id}
{$contribution.project_ID}
{$contribution.project_id}
{$contribution.project_Id}
{$contribution_campaign_id}
{$contribution_campaign_ID}
{$formValues.campaign_id}
{$formvalues.campaign_id}
{$formTpl.campaign_id}
{$campaign_id}
{$contributionProjectId}
{$projectId}
{$ProjectId}
{$contribution_Project_Id}
{$contributionCammpaignId}
{$campaignId}
{$CampaignId}
{$campaignid}
{$contribution_campaign_id}
{capture assign=project_id1}{contribution.campaign_id}{/capture}
{capture assign=project_id2}{contribution.Campaign_Id}{/capture}
{capture assign=project_id3}{contribution.campaign_Id}{/capture}
{capture assign=project_id4}{formvalues.campaign_id}{/capture}
{capture assign=project_id5}{formValues.campaign_id}{/capture}
{$project_id1} {$project_id2}  {$project_id3}{$project_id4}{$project_id5}
{$contributioncampaignID}
{$value.campaign_id}
{$formValues.33}
{formValues.campaign_id}


texts: Error in Class CRM_Extension_Mapper 'Class CRM_Extension_Info not found' when installing 5.24 in Drupal 7

texts:
I have a problem enabling CiviCRM 5.24.2 after installation in Drupal 7.69 under PHP 7.2.27 under Centos7 Apache/2.4.6

CiviCRM installs correctly using both UI and CV method - ie builds database & civicrm.settings, but fails to enable (same error in both install methods).

drush en -y civicrm produces the following error (and breaks Drupal site):

WD php: Error: Class 'CRM_Extension_Info' not found in CRM_Extension_Mapper->keyToInfo()
Error: Class &#039;CRM_Extension_Info&#039; not found in CRM_Extension_Mapper->keyToInfo() (line 170 of /srv/web/climatebonds.net/web/sites/all/modules/civicrm/CRM/Extension/Mapper.php).
Drush command terminated abnormally due to an unrecoverable error.

drush dis -y civicrm returns site to working order.

No problems with installation under local environment: Apache/2.4.35 (Unix) PHP/7.2.19


texts:
This one has me perplexed since I haven't seen the missing link issue cause any other problems. In the Civimail unsubscribe links, there's a missing slash right after the domain URL. For example, assume a domain of mycivisite.dom. When the ubsubscribe link is generated in the emails, it looks like this:

http://mycivisite.domcivicrm/mailing/optout/yaddayadda/etc

As you can see, there's no slash between mycivisite.dom and civicrm. Where am I not looking?

-- Marcel


texts: Posting photos on our DONATE/ contribution page through Civi

texts:
Is there an ideal image size for posting photos on this page? The photo that I want to post keeps getting smushed. I finally found decent dimensions but it the mobile website doesn't keep the correct dimensions.

Let me know!


texts: Why does my 'Delete Case' action in the case search report not work?

texts:
When I use the 'Find Cases' report (from the Case menu), and I select [Delete Cases] it does nothing. And it looks de different. Like this:
CiviCRM version  5.34.alpha1 on Drupal:
And besides that, the search part looked funny too:
The search from and the to fields are visible.
In the JavaScript console I see the following message in red:
select2.min.js?qmiq9r:75 Uncaught query function not defined for Select2 custom_13_from


texts: Link to Directly View Default List of Contacts (Drupal)

texts:
I would like to be able to link directly to the page listing contacts (same as if searching for a wildcard (searching without entering . Even better would be able to pass in variables through the link to filter the results.

At the very minimum I would like to show the list of contacts as if you just go to the search bar and press enter. I'm looking for a way to directly link to the list of contacts.

Is this possible?

Clarification and thoughts...
Right now it appears that the only way you can repeatedly search for contacts is to manually do a search. This is tedious and very limited. Ideally there would be a way to pass in parameters through the URL to get search results. This would allow us to have direct links to a specific set of search results.


texts: what is giving the error sites/default/modules does not exist

texts:
I have a configuration problem somewhere.  My logs give a lot of this: File does not exist: /var/www/drupal-7.34/sites/default/modules.  The site has modules located in /var/www/drupal-7.34/sites/all/modules.  I'm getting the error in apache logs when I try to configure the 'Organization Address and Contact Info' page.  On saving that page I get a dump that starts:
backTrace

#0 /var/www/drupal-7.34/sites/all/modules/civicrm/CRM/Core/Error.php(182): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(PEAR_Error))
#2 /var/www/drupal-7.34/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(PEAR_Error))
#3 /var/www/drupal-7.34/sites/all/modules/civicrm/packages/PEAR.php(566): PEAR_Error->PEAR_Error("php_network_getaddresses: getaddrinfo failed: Temporary failure in name resol...", 0, 16, (Array:2), NULL)
#4 /var/www/drupal-7.34/sites/all/modules/civicrm/packages/Net/Socket.php(156): PEAR->raiseError("php_network_getaddresses: getaddrinfo failed: Temporary failure in name resol...", 0)
#5 /var/www/drupal-7.34/sites/all/modules/civicrm/packages/HTTP/Request.php(737): Net_Socket->connect("maps.googleapis.com", 80, NULL, NULL, NULL)


texts: Is there an accepted standard for storing data as a year?

texts:
To preface this, I'm using CiviCRM's integration on Drupal 7, with the Webform integration module.

I'm looking to store a number of custom fields as a year. It appears that I am able to use the Date field type to store a date in the format of "YYYY", which sounds like what I want to do. However, the widget that is presented to the user to input the data requires you to choose a specific date from a date picker rather than a year, even if it only stores the year.

On top of that, when I use the Webform module integration with CiviCRM, the widget that I am presented with has 3 dropdowns, one for month, one for day, and one for year.

Ideally both the backend widget and the Webform widget would simply be a select box that allows you to pick only the year starting about 60 years back and ends 20 years in the future. I'm sure I could just make a select box to do just that, but I don't want to manually edit the values in a select box just to get a simple date field.

Does anyone know if there is a way to handle this the way I'm describing or am I stuck using a full date field to simply store a year?


texts: Enabling Group description field for webforms

texts:
The group description field is visible when using a profile for mailing sign ups.

Does anyone know of a way of including these in a civi enabled webform?

Ta!


texts: Changed behavior in handoff between CiviContribut and PayPal

texts:
We're encountering a problematic changed behavior in the CiviContribute module when it hands an online contribution over to PayPal Standard for payment.

The purchase description used to be like this:

Online Contribution: Sponsor a Child

which made it very easy for our treasurer to assign the payment accordingly.

The purchase description now appears like this:

1092-4219-Sponsor a Chil

where the first number is the contact ID and the second is Civi's internal  contribution ID -- neither of which is very useful to the treasurer.  Meanwhile the purchase purpose is truncated making it harder to figure out where to assign the payment in the back end accounting.

We are running Civi 4.7.14 in a Wordpress CMS.  It looks like the changed behavior might have begun when we upgraded from 4.6.X to 4.7.14.

Questions:

a.  Is this a "feature" or a "bug"?

b.  Is there a setting or template that we can adjust to get back to the original behavior or otherwise control the product description that is handed to PayPal?


texts: How can I see a piechart breakdown of contributions by financial type this year?

texts:
The "Donor Report (Summary)" produces pie charts, however these seem to be only by date, even if I choose group by Financial Type. Also, it complains "Do not use filter on Date if group by Receive Date is not used" if I turn off date grouping. But I need a chart that shows the data by financial type not date, but within a given range (e.g. this year).

The "Donor Report (Detail)" allows me to summarise the data in a text format - the data I want is in the headings; I can't find a way to have only this displayed, or in a pie chart.

Would I need to write a custom report for this functionality, or is there something I'm missing?

I'm on 4.4 LTS.


texts: CiviCRM upgrade from 4.2.7 to 4.7.13 fails to show any report

texts:
CiviCRM was updated from 4.2.7 and right now is even updated to 4.7.16 but when we try to get reports and even try to click on "Refresh Results" it shows nothing, not even an error about it. The original site still has CiviCRM 4.2.7 and is able to show all reports with no trouble. I've been looking for any file, database table or anything that might be missing and needs to be updated but can't find what is causing this, any ideas what might be?

Regards,


texts: Only Administrators can use Contact Reference Fields

texts:
I have a contact reference field that works perfectly as Drupal user 1. It does not work for my non admin users. They have all the permissions for CiviCRM but the select list does not retur results to them. They can see the field and see what admin puts in the field.

This Drupal 7 and Civi 4.5.5.

Thanks!


texts: Unexpected T_CLONE, expecting T_STRING (PHP 7, Drupal 7, Ubuntu 16.04)

texts:
On an Ubuntu 16.04 VM with PHP 7.x, I am seeing the following error when enabling CiviCRM in Drupal 7:

  ParseError: syntax error, unexpected 'clone' (T_CLONE), expecting identifier (T_STRING) or '(' in require_once() (line 1 of /home/westernfriend/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php(207) : eval()'d code).

Is this due to incompatibility with PHP 7, a missing dependency, or perhaps something else?


texts: Is there a way to make some events a sub-category for another event?

texts:
I'm trying to figure out how to categorize some events under a sort of "mother" event so that you can only register for the child events if you have registered for the mother event. Is this possible?

Thanks!


texts: CiviCRM Home Dashlets - making them wider, possibly span over right and left column

texts: I have a dashlet report that has a good number of columns. Right now I can only place it in either the left or right dashboard column. That cuts of the report view and I have to expand it every time I want to see the entire thing. Is there a way to make it wider on the dashboard or perhaps have it span over the right and left column?


texts: API: Contact get/getcount by primary address country stopped working on upgrade to 4.6.9

texts:
I spoke too soon, there was one hiccup on the recent upgrade.

I have a bit of custom code on one site that pulls contacts based on 'Primary Address country' as follows (example):

$contactcount=civicrm_api("Contact","getcount", array ('version' =>'3', 'contact_type' =>'Organization', 'country' =>'United States');

When I try this on the API Explorer on the demo site, I get this error:

"error_message":"A fatal error was triggered: United States is not of the type Positive"

It seems to have stopped working with an upgrade from 4.6.7 to 4.6.9. Did something change in the API call?

Update:

I was trying to rough in some temporary code to make this functional by using the Country ID instead of the Country Name, and there seems to be a problem there, too. The country ID field in the API seems to be essentially ignored.

$contactcount=civicrm_api("Contact","getcount", array ('version' =>'3', 'contact_type' =>'Organization', 'country_id' => 1228);

I verified this on the demo site, too. I have opened a bug ticket for this.


texts:
Somehow CiviCRM is wanting to use the path /CiviCRM (notice the case) instead of all lowercase civicrm.  This has been fine until I upgraded to Civi 5.27 and now the civicrm?civiwp implementation results in a 404.  I can change the case manually and it will work but the automatically generated URLs use all lowercase.
For example:
https://www.domain.org/civicrm?civiwp=CiviCRM&q=civicrm%2Fevent%2Fregister&reset=1&id=24  == 404 Not Found
https://www.domain.org/CiviCRM/?civiwp=CiviCRM&q=civicrm%2Fevent%2Finfo&reset=1&id=24 == working
This is also breaking images in my Mosaico templates.
Example of a Mosaico image:
https://www.domain.org/civicrm?civiwp=CiviCRM&q=civicrm%2Fmosaico%2Fimg&src=https%3A%2F%2Fwww.domain.org%2Fwp-content%2Fuploads%2Fcivicrm%2Fpersist%2Fcontribute%2Fimages%2Fuploads%2Fdcs_e1de5c0ee5de2a85bb86821132d2aaba.png&method=resize&params=166%2Cnull
If you change the link to /CiviCRM?civiwp=CiviCRM.... it works.
I have verified that the permalink on the page is lowercase as well as the CMS Database Integration in Civi.  Has anyone seen this behavior or have any suggestions for how I can correct it?
UPDATE:
Adding the following lines to my htaccess fixes this as a workaround.  Still not sure why it is defaulting to CiviCRM instead of civicrm.  Hopefully if this is happening to you, you can use this patch.
RewriteCond %{REQUEST_URI} !^/wp-content/
RewriteRule ^(.*)/civicrm(.*)$ /$1/CiviCRM/$2 [R,L]


texts:
Good Morning Everyone,
We have a client running CivCRM 5.36.1 on Drupal 7.  All extensions are up to date.  Since the middle of April we have noticed some participants are receiving notices that there event registration has been canceled.  In all cases these participants were sent the link for payment by the event coordinator using the "Will Pay Online" option.  Payment completes fine. There are no errors in payment processor logs or any of the Civi logs.  The record of the cancellation shows up in the activity list and the log database.  The timing is usually (all cases but one) immediately upon completion of payment. In all cases but the last one, even though the cancellation message was sent and recorded in the database, no cancellation actually occurred.
In the last case, the participant did receive the cancellation notice when payment was received as everyone else without the registration actually being canceled.  Then, 4 days later, they received a cancellation notice but this time the event registration was actually canceled. Again, the activity log shows the cancellation with the "Added by" being the participant.
We continue to dig into this but have found nothing to indicate why it is happening.  It is not happening to all users.  It happens to a few users registered to the same event in the same way.  Any insight would be appreciated.


texts: How to include source page URL in donation page email receipt?

texts:
When my CiviContribute donation pages send out email receipts, I would like the emails to include the URL of the source page (i.e., the WordPress page that contains the shortcode of the CiviCRM donation page). Is there a Smarty variable that has that source (or "referrer") page URL? Or is there another way to accomplish this? (Seems like this would be a good variable to have.)

I'm on WordPress 5.23 and CiviCRM 5.13.

I've added the {debug} token to the HTML email template to inspect the available variables and didn't find anything quite suitable. There is a variable called $printerFriendly that seems to have the page URL but with extra query string parameters. Is there a Smarty feature to discard the query string and retain just the page URL?

(Side note in case it helps someone: if you include {debug} in both the HTML email template and the plain text email template, the contribution page will fail with a "too many redirects" error, and the contribution does not get recorded!)


texts: How to make personal data fields non editable

texts:
I received a survey titled 'civiCRM survey 2016' with my first name, last name and email fields pre-filled and not editable.
How did you achieve this? Are you using the no-overwrite extension or webforms disabled fields also work when using the civiCRM checksum?


texts:
I created a contribution page to allow new members to sign up. Then I just signed up with the email of an existing member but other info (like a different name, address). As a result: the info of the existing member gets overwritten (name, address) in civicrm.
I found out that the profile-setting for duplicate contacts is being ignored for online contribution pages (I don't really understand why ...), but even creating a new Duplicate Contact rule with type Unsupervised (specifying lastname,firstname and email) results in the same behavior.
So: is there any way of blocking new members from changing the info for already existing members via a regular contribution-membership page?


texts: Send an Email When Tag is Applied - or When Added Automatically to a Smart Group

texts:
I'm looking to set up a series of drip emails once a contact is tagged. Unfortunately, the rules around tagging are convoluted to the point where I'm afraid to use them since I have the potential to send an email out to many people who I don't wish to receive the email. There are also no instructions regarding how to trigger an action using tags.

Because of this, I created a rule indicating that when a contact is added to a smart group, which occurs when they are tagged, that they will receive an email. And an email is sent when I add a contact manually, but not when it is done automatically via the smart group rules.

Goal: to send a contact an email once they've been tagged.


texts: How do I set up recurring donations with Stripe?

texts:
Im operating in Drupal 7 with Civi 4.7.30 and the latest Stripe API.

I want to set up recurring donations but it keeps giving me errors. I have it enabled on the Contribution page.

In Stripe they said to set up "Subscriptions" Which I did in the form of recurring donations. This does not enable the recurring to happen.

Advise on how to solve this?


texts:
WP4.9.6 / CiviCRM 5.1.2

Having some issues with cron jobs using cv. I have a cron running with cli.php but that requires a password. I'm about to implement 2FA which breaks that approach.

I've got cv installed (well technically my hosting provider installed it for me), and I can call it from ssh, but it doesn't seem to trigger the scheduled jobs (even when I replace admin with a valid WP / CiviCRM superuser account name)?

bash-3.2$ cv api job.execute --user=admin --cwd=/var/sites/h/hbb.org.uk/public_html -vvv
[BootTrait] Start
[BootTrait] Attempting to set verbose error reporting
[BootTrait] Call standard cv bootstrap
[Bootstrap] Options: {
  "dynamicSettingsFile": "phar:///var/sites/h/hbb.org.uk/cv.phar/settings_location.php",
  "env": "CIVICRM_SETTINGS",
  "prefetch": true,
  "settingsFile": null,
  "search": true,
  "cmsType": null,
  "httpHost": "",
  "output": {} }

[Bootstrap] Find settings file
[Bootstrap] Load supplemental configuration for "/var/sites/h/hbb.org.uk/public_html/wp-content/uploads/civicrm/civicrm.settings.php"
[Bootstrap] Load settings file "/var/sites/h/hbb.org.uk/public_html/wp-content/uploads/civicrm/civicrm.settings.php"
[Bootstrap] Find CMS root for "/var/sites/h/hbb.org.uk/public_html"
[Bootstrap] Found "wp" in "/var/sites/h/hbb.org.uk/public_html"
[Bootstrap] Simulate web environment in CLI
[Bootstrap] Initialize class loader

[Bootstrap] Call core bootstrap
[Bootstrap] Finished

[BootTrait] Call core bootstrap
[BootTrait] Call CMS bootstrap

My site is an upgrade from before 4.6 so my civicrm.settings.php is in ../plugins/civicrm which I've copied to ../uploads/civicrm just in case, but to no effect.

Everything seems to work, but nothing happens?


texts: After turning on Send Scheduled Reminders and setting up a Membership Renewal Reminder, why am I getting all zeros in my Scheduled Reminders log?

texts:
I am using CiviCRM 4.5.8 on Drupal 7. I get the feeling my scheduled renewal reminders are not going out. These are my settings:

Are there some other parameters or settings I need?


texts: Something is seriously wrong with CiviCRM - Replicating Contacts

texts:
Wordpress 4.7.5 & CiviCRM 4.7.19

My contact is replicating in our system, to the point there were 700+ records with just my email and name.  I am not sure what is happening but I have some ideas. Every time I do something on CiviCRM it creates a new contact.  Not sure if this is true, but it does not seem to make new contacts while I am away.

Lastly, when I login with my other admin account, none of these issues exist and my user does not replicate anymore.  When I login to my user account, it replicates again.

Should I not have users that are also members, donors, etc act as administrators?


texts: Deleted contacts considered duplicate in mailing

texts:
Some weeks ago clients reported problems of mass mailings not being delivered to a part of the destinees. After doing some research it occurred that the problem lied in contacts that had been merged.
When contact A is merged in contact B, contact A gets deleted (still in the database but status 'is_deleted'). When creating a mailing both A and B seem to be added to the destinees.
When sending the mailing contact A obviously doesn't receive the mailing because 'is_deleted' but contact B also doesn't get the mailing because the mail is regarded as a duplicate mail.
After some looking around I found https://github.com/civicrm/civicrm-core/commit/48b1ff58 which solved the issue for us on multiple installs.
Now I hoped this would quickly find its way into the releases, but when I just took a look at the freshly released 5.34.0 it clearly hasn't.
The error is so obious though that I feel I must be missing something myself, so I hesitate to file a bug report...


texts: I am trying to insert custom tab into Activity tab but it is not working

texts:
I am creating new extension.
I am adding a new custom field into Activity tab but it's not working

//Creating a custom group for survey

function custom_group_create_survey(){
$survey_custom_group = array(
    "id" => "10",
    "name" => "API_survey",
    "title" => "API survey",
    "extends" => "Activity",
    "extends_entity_column_value" => [
        "1"
    ],
    "style" => "Inline",
    "collapse_display" => "1",
    "weight" => "   3",
    "is_active" => "1",
    "table_name" => "civicrm_value_API_sur__5",
    "is_multiple" => "0",
    "collapse_adv_display" => "0",
    "created_id" => "2",
    "created_date" => "",
    "is_reserved" => "0",
    "is_public" => "1"
);

try{
    $result = civicrm_api3('CustomGroup', 'create', $survey_custom_group);
}
catch (CiviCRM_API3_Exception $e) {
    // Handle error here.
    $errorMessage = $e->getMessage();
    $errorCode = $e->getErrorCode();
    $errorData = $e->getExtraParams();
    return array(
        'is_error' => 1,
        'error_message' => $errorMessage,
        'error_code' => $errorCode,
        'error_data' => $errorData,
    );
}

return $result;

}

function custom_field_create_survey() {
$params = array(
    'custom_group_id' => 10,
    'name' => 'test_textfield2',
    'label' => 'Name1',
    'html_type' => 'Text',
    'data_type' => 'String',
    'default_value' => 'abc',
    'weight' => 4,
    'is_required' => 1,
    'is_searchable' => 0,
    'is_active' => 1,
);

try{
    $result = civicrm_api3('CustomField', 'create', $params);
}
catch (CiviCRM_API3_Exception $e) {
    // Handle error here.
    $errorMessage = $e->getMessage();
    $errorCode = $e->getErrorCode();
    $errorData = $e->getExtraParams();
    return array(
        'is_error' => 1,
        'error_message' => $errorMessage,
        'error_code' => $errorCode,
        'error_data' => $errorData,
    );
}

return $result;

} ##

I am calling these functions into following hook

function surveytab_civicrm_install() {
custom_group_create_survey();
custom_field_create_survey();

_surveytab_civix_civicrm_install();
}
 ##


texts: How do you create a scheduled mailing with recipients through CiviCRM API?

texts:
I am trying to create a scheduled mailing through the CiviCRM API.

Here's my code:

$params = array(
    'sequential'         => 1,
    'created_id'         => $contact_id,
    'created_date'       => date('Y-m-d H:i:s'),
    'scheduled_id'       => $contact_id,
    'scheduled_date'     => date('Y-m-d') . ' 11:00:00',
    'approver_id'        => $contact_id,
    'approval_date'      => date('Y-m-d H:i:s'),
    'approval_status_id' => 1,
    'msg_template_id'    => 214,
    'subject'            => 'Test Subject',
    'name'               => 'Test Email Title',
    'body_html'          =>
Test Email Body
,
    'body_text'          => 'Text email body',
    'groups'             => array(
      'include' => array($group_id),
      'exclude' => array(),
    ),
    'mailings'           => array(
      'include' => array(),
      'exclude' => array(),
    ),
    'from_name'          => "Test Sender",
    'from_email'         => "test_sender@test_sender.com",
    'replyto_email'      => "test_sender@test_sender.com",
    'reply_id'           => 8,
    'unsubscribe_id'     => 5,
    'optout_id'          => 7,
    'resubscribe_id'     => 6,
    'footer_id'          => 2,
    'header_id'          => 1,
    'open_tracking'      => 1,
  );

  $result = civicrm_api3('Mailing', 'create', $params);

I've managed to create the schedule mailing without problems and I don't receive any errors when it gets sent.  But when I view the send report, the email is sent to zero recipients.

Upon some investigation I noticed non of my recipients are being added to the civicrm_mailing_recipients table and I'm guessing that's why no one is getting any emails.

I'm wondering if I'm missing something, I'm assuming the API should be adding those contacts in the group I'm including to the civicrm_mailing_recipients table, why else have this feature?

When researching I found this thread:
https://forum.civicrm.org/index.php/topic,24075.0.html

Thanks.


texts:
I am helping a few organisations who have been using PayPal Website Standard for recurring contributions, which results in completely unmanagable payments - there's no API to amend them or even cancel them. You can't even change the URL to which PayPal sends webhook IPNs!

This has made supporter development very difficult: "to upgrade, set up a new regular payment and we'll try to react fast enough to cancel your old one (by logging in manually to PayPal and searching for it) so that you don't end up paying twice."

I've advised not using PayPal, for a raft of reasons. Several of these organisations campaign for the NHS yet still insist on using PayPal to collect money from donors - which presumably has the net effect of getting their supporters to subsidise PayPal's share towards the NHS since it does its best to pay as little UK tax as possible. Baffles me, but PayPal is apparently still a must.

PayPal's offerings differ the world over, and they don't make it super clear what's available in which jurisdiction.

I'm looking for a way to use PayPal that

is available to UK customers
can be used for one off and recurring
allows administering (increase/decrease/cancel) recurring contribs by custom code and ideally by UI too.
sets up the payments such that we are able to use PayPal's REST API should we need to - as opposed to having to manage things entirely manually through PayPal's sites.
can be driven without CiviCRM's Contribution Pages. i.e. I need to be able to setup the payments from a custom donation form, so I need a clear separation of UI from processor logic since the 'head' may be on a different site to CiviCRM.

I've read that PayPal Checkout is now available via an extension that implements Omnipay, a third party library for talking to payment gateways. Although Custom form/api → Civi → Omnipay extension → Omnipay library → PayPal feels like a long chain!

I'm unclear whether PayPal Checkout or PayPal Express is the more modern/flexible - Omnipay seems to support both, and PayPal's website for each just seems to say "faster, better" on both sites!


texts: How can I include Profiles on Drupal user registration?

texts:
I have a current Drupal and CiviCRM installation running LoginToboggan, Panopoly and Multiple Register.

I can toggle the original Name & Address Profile included with the installation, but when I set the checkbox for Drupal User Registration to true on the custom Profile Settings page, the form doesn't appear on the Drupal User registration form.

user/register

Additional registration forms built with Multiple Registration

register/supporter
register/volunteer

Clearing cache and running has no effect.

What's the best way to debug this problem?


texts:
I have two payment processors that I am using for CiviCRM.  Paypal Standard works well.  Stripe was working for a while and now I get an error screen saying that Strip.js token was not passed.  I have asked the author for help but he says he does not know Joomla.  Can anyone shed light on where I should start looking.
Joomla 3.4.2
CiviCRM 4.6.4


texts: Unable to get CiviCRM running on Drupal 8/Ubuntu server 18.04 LTS/Linode

texts:
I have tried following the Roundearth instructions twice to get CiviCRM up and running on a clean install of Drupal 8, on Ubuntu server 18.0.4. First time through, the installer failed with a permissions error but CiviCRM reported as installed—if there's a way of reverting from this situation, I couldn't figure it out, and I ended up having to start over.

Second time through, it all looked good, but going to any CiviCRM page came up blank. Checking PHP errors, it was maxing out memory. So I increased it to 256, 512, and unlimited—each time, it maxed out on memory (3.2 gigs in the case of unlimited, whereas the server has 4), and I gave up and went home. Only to discover when I got there that the pages now loaded, and continued to load with sane memory restrictions. (???) However, there's no CiviCRM menu (it appears to be there, but empty), and when I go to handpasted admin URLs, things that are supposed to be there according to the docs are blank.

Both of these were with the Roundearth instructions—I found a different set here that I'm trying out, but I don't feel good about it.

I have to deploy a staged site by Friday, and if I can't get CiviCRM to work, I'll plow on without it—but I gather that it really wants to be installed before I start piling on other modules. Any help greatly appreciated.

EDIT: Occurs to me that I have not tried installing Drupal from apt-get (if it's there), because the Roundearth composer script had it included. Could try that next before moving on to the linked instructions. Or not, as apparently it's not in apt.


texts: Error when updating Stripe: Trait 'CRM_Core_Payment_MJWTrait' not found

texts:
I have just updated Stripe to version 6

It requires a Data Base update

But when I run this update, I get :
[Error: Upgrade com.drastikbydesign.stripe to revision 5023]
Error 1: Trait 'CRM_Core_Payment_MJWTrait' not found in /home/bapaparoisse/www/www/sites/default/files/civicrm/ext/com.drastikbydesign.stripe/CRM/Core/Payment/Stripe.php, line 13


texts: Activities not displaying and weird json message

texts:
civi 5.9.13 WP 5.2.2
civi In a contract screen activities tab no activities are listed
error popup says "DataTables warning: table id=DataTables_Table_0 - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1"
EEK!
I've recently deleted various mysql data related to civivolunteer - hope this didnt break anything

PS I tried the fix here: DataTables Warning: Cannot view Activities after upgrade to 4.7.28
didn't work


texts: How do I uncheck the recurring contribution check box by default?

texts:
I've searched here and on the CiviCRM forum but haven't been able to find an answer to what I was hoping would be fairly simple.

I want to give people the option of making their contribution recurring, however I don't want the checkbox checked when the form loads I only want the checkbox checked if the user selects it. This is to avoid an embarrassing situation a month down the road when we process their donation again.

Here's a page with the form in test mode

I'm not all that good with code, but did look with Developer Tools and found this:

I looked at Main.tpl (lines 147-177) but don't understand enough to remove the checked="checked" attribute from the input tag.

{if $form.is_recur}

&nbsp;

  {$form.is_recur.html} {$form.is_recur.label} {ts}every{/ts}
{if $is_recur_interval}
    {$form.frequency_interval.html}
  {/if}
  {if $one_frequency_unit}
    {$frequency_unit}
    {else}
    {$form.frequency_unit.html}
  {/if}
  {if $is_recur_installments}

    {ts}for{/ts} {$form.installments.html} {$form.installments.label}

  {/if}

    {ts}Your recurring contribution will be processed automatically.{/ts}
    {if $is_recur_installments}
      {ts}You can specify the number of installments, or you can leave the number of installments blank if you want to make an open-ended commitment. In either case, you can choose to cancel at any time.{/ts}
    {/if}
    {if $is_email_receipt}
      {ts}You will receive an email receipt for each recurring contribution.{/ts}
    {/if}

{/if}

Thanks in advance.


texts: Can I format a smarty token number to have thousands comma?

texts:
Based upon smarty documentation I should be able to do something like this

{contribution.total_amount|number_format:2:".":","}

and get something like 1,234.56, but it shows blank.  In the logs I see:

[plugin] (secure mode) modifier 'number_format' is not allowed
(core.load_plugins.php, line 118) in Smarty->trigger_error() (line 1094
of  .../sites/all/modules/civicrm/packages/Smarty/Smarty.class.php).

In searching our code tree a bit, I find a plugin modifier.crmNumberFormat.php, which looks like it should be the one. So why isn't it using it?

I do see that there are two Smarty plugin directories.  Not sure which one it's using.  There is one in sites/all/modules/civicrm/packages/Smarty and another in sites/all/modules/civicrm/CRM/Core/Smarty

We're running 4.5.8 and have 4.6.7 in a dev environment.


texts: 100s of duplicate contacts created of current user when using CiviCRM

texts:
I have recently migrated a CiviCRM instance from Joomla to Wordpress, everything went smoothly.

The installation is using CiviCRM 5.7.2 and PHP 7.2.

We're now seeing a peculiar problem where, when users are making general use of CiviCRM, literally 100s of duplicate contacts are created of whichever user is working.

The duplicates accumulate very quickly. In about 10 minutes of experimentation with CiviMail today, I managed to create 249 duplicate contacts of myself.

In testing for this question, I created 25 contacts simply by searching for 'contacts created today' in advanced search.

Just about any action appears to create these duplicates.

When deleting them, CiviCRM will warn me that 'you are currently logged in as' one of the duplicates and therefore it cannot be deleted. Obviously my user account should not be associated with a just-created contact.

My guess is that this may be caused by something like a missing database constraint, but I'm at a bit of a loss as to where to start looking.

Any ideas?


texts: How do you save generated content not tokens in emails & print/merge?

texts:
This seems to be standard that the literal token {contact.display_name} is saved not the generated result "John Doe".

To my mind this is useless - the data changes - so how can I view the actual letter emailed or printed?

And what is the point of saving the template if it only contains the tokens - you could up saving thousands of identical templates none of which contain any useful information.

Is there a way I can save the generated content inside civiCRM?


texts: Custom report Action not working on new development

texts:
I have now, after a steep learning curve built a custom report based on the  kind help I have has so far.

How to write custom report SQL

But I have an issue, that I don't know how to effectively resolve.

The report works online fine now with the desired output.

I built the report using the Example 101 - starting with 'Empty Report' and adding my SQL & columns as required.

But when I select an 'action' such as 'print' 'print to pdf' etc, there is a brief pause a refresh and nothing ..

Nothing is appearing in the php logs.

I have debug on.  Nothing is showing in the CiviCRM log output.

There are no browser console JS errors.

All other reports perform as expected.

I'm working through CiviCRM debugging, any pointers here please - I'm so close but so far!  (CiviCRM 4.7 - WordPress)


texts:
Using Drupal 7 and Civi 5.7.0

When sending batch emails using CiviMail, if I select "Administer CiviCRM » Scheduled Jobs" and select "Process now" on the "Send Scheduled Mailings" job then the mailing sends successfully. If I allow the cron to execute the same job, then I'm getting an SMTP error ("Failed to set sender" and "authentication failure") and the mailing fails. The log entries for the two jobs are identical. The SMTP settings are correct. The user specified in the cron job is the same as the one I'm using to "Process now".

Note: I recently dealt with the time zone error described in process_mailing processing addresses when called in UI but not CRON This got my cron running the process_mailing job but now I'm getting the SMTP error. The only change I made was to set the timezone on the server to the same as Drupal.


texts:
I have a number of cases where I need to run a cron job to use a custom search and a template.  It should be simple to schedule a mailing to automatically run on some basis.

I have 2 current examples, Once a month I need to send a summary to a contact listing the status of their constituents. I have a group listing all the recipients of a report. For each person a  template is called and from the use of tokens generates and sends the report.

In another case I have a search which identifies the payments from the previous day. The cron runs and based on a template sends acknowledgements.

I would think there should be an easy way of setting up a cron which calls a search and a template. Unfortunately I don't see how to easily specify the two parts, If a current module exists where I can just name the search and the template that would solve my problem. This would be like automatically launching a mailing daily from a cron.


texts: Why no Member entity in the API v4 Explorer

texts: I can't see Member or MembershipType in the API Explorer, nor can I see support for these entities in the API code. As these are pretty crucial I must be missing something - can anyone help?


texts: Why does Assigned To: for an Activity to any admin, and only one other user not work since 4.6.7?

texts:
We're on 4.6.9 and Drupal 7.

Ever since the changes to, then the rollback of, Access Control Levels (ACLs) /user permissions in 4.6.6/4.6.7/4.6.8 (see here), I can Assign To: an Activity to all users except our two Admin users, and one other user, who has the same permissions as other users who can have an Assign To: for an activity.

I'll check these three user records (one of which is mine) for any corruption or other weirdness.

Has anyone else experienced this?

I'm not sure how I could duplicate on demo/sandbox without doing the same version updates/rollbacks we did from 4.6.6 to 4.6.8.


texts: How to have the Civi Contact deleted when the Drupal User is cancelled?

texts:
When a user cancels his registration in Drupal, the pertaining Civi Contact remains.

How can I have both deleted simultaneously ?


texts: Why are public files in Joomla admin directory?

texts:
I was attempting to lock down our Joomla admin folder with an additional Apache-level password, and discovered that there are some Civi resources under the admin folder that need public access (css, js, etc.). On the face of it, it seems to me this would be a bad practice (other public joomla resources do not seem to be under admin), but there are vast oceans of information that I don't know! Could someone explain (as briefly and simply as possible!) why these files are under www/administrator/components/com_civicrm/civicrm/ rather than under www/components/com_civicrm/ or such?

I suppose I should also say that I haven't knowingly put these resources under admin, so I am assuming they were placed there as standard Civi installation. If I've improperly configured Civi, then my question becomes: What did I do/not do to cause this?


texts: How do I import contact records with phone numbers without overwriting existing phone numbers?

texts:
If I import a spread sheet with contacts and phone numbers and:

I choose to update duplicate contacts
I choose the same phone location and phone type of an existing, matching contact

Then, the existing phone number will be replaced with the one I'm importing.
That is reasonable for many workflows - but what if I want to add the number to the record and not overwrite anything? I know I can create more and more phone types but maybe there is a better way?


texts: "Created by" field of CiviMail pulls the name of the latest subscriber

texts:
I am a new user of CiviCRM. My organisation uses CiviCRM 4.6.36. and I have a small problem: for some reason, CiviMail shows the name of the latest subscriber in the "created by" field when I create an email. It is not a big issue but causes some confusion. I went through the settings but was unable to resolve the issue. My question is: what might cause the problem?
Thank you very much in advance for your help!


texts: Is there a way to upload multiple discount counts into CiviDiscount?

texts: We are getting ready to do a Groupon promotion that will discount memberships. Groupon has generated individual "voucher codes" for each person who purchases. I need to enter each of these voucher codes as a single-use discount code. I'd like to be able to enter up to 200 codes at once, all with the same usage limits and rules, but so far, I can't figure out how to do this except to enter each code manually and set all the rules each time. When I try to just copy one code to avoid having to set all the rules each time, the copy shows a randomly-generated code that can't be edited. Has anyone figured this out?


texts: Add New Organization Option to Public Autocomplete Extension

texts:
Hey everyone we've just installed the public autocomplete extension https://civicrm.org/extensions/public-autocomplete-of-organisation-names but are having some difficulty getting it to "add new" or the "new organization" button to display (as it does when logged in as admin, editing a record and selecting "Current Employer") while also still creating the Employer-Employee relationship

(this is for anon users) also we'd like to restrict the list that displays by group and contact type

in other words, create new org similar to webform-civicrm or within civicrm.

trying acls, adding code per the video athttps://civicrm.org/extensions/public-autocomplete-of-organisation-names

but nothing works yet.

We are using civicrm 4.7 so any thoughts or feedback , greatly appreciated!

H

p.s. similar maybe not identical to Enabling 'New Organisation' button for Current Employer field in View Contact


texts: add new conditions in postProcess hook - Civicrm

texts:
I am writing an extension to enhance search builder. I am using myext_civicrm_postProcess hook and I've my 2 extra fields in builder form. I wanted to add only 2 more fields into existing search builder. I found this file
/Library/WebServer/Documents/drupal/sites/all/modules/civicrm/CRM/Contact/Form/Search/Builder.php
into CRM core and I found in this function it is manipulating form data and creating an array containing conditions values. All I need to pass my conditions into that array. In this file it is having this array $this->_params which holds query's conditions. For example I merge my array into this function manually and it worked as expected but I want to pass this array from my hook function. Apart from that everywhere I could see to write own query, but I thought to not proceed with this. Any single guidance will help me a lot.


texts: Call to undefined function user_load() using Drupal 9 and api3?

texts:
Full error message:
Error: Call to undefined function user_load() in CRM_Utils_System_DrupalBase->getUserObject() (line 558 of /var/www/drupal/vendor/civicrm/civicrm-core/CRM/Utils/System/DrupalBase.php)

I get this when using an api3 call like this:
$result = civicrm_api3('User', 'get', [
  'sequential' => 1,
  'id' => 1,
]);


texts:
Civi 5.14 on WordPress 5.2.3

A large chunk of our membership scheduled renewal reminders are arriving to the member's inbox completely blank. It is apparently not all of them, as I ran a test membership and I received my reminder email with no problems, but more than 500 of our members have received blank scheduled reminder emails this year and their memberships are now expired as a result to this.
This problem makes no sense to me and I do not know where to look for a solution.
Has anyone else experienced this?  Did you find a solution?


texts: Error after upgrading to latest CiviCRM version

texts:
After upgrading, I see the following message appear:

Strict warning: Declaration of DB_common::raiseError() should be compatible with & PEAR::raiseError($message = NULL, $code = NULL, $mode = NULL, $options = NULL, $userinfo = NULL, $error_class = NULL, $skipmsg = false) in require_once() (line 29 of /s***/crm.***.com/***/***/sites/all/modules/civicrm/packages/DB/mysqli.php).

All operations seem to be working fine though. Please help.

Regards
Atif


texts:
I'm using the Autocomplete extension and it works as advertised.  However, I was hoping someone could help me customize the output of the autocomplete.

I would like to include all of the Organization contact_type entries as well as several subgroups while excluding others.

Below will filter out the contact_sub_types, but also filters out any of the parent Organizations that do not have a subtype. How do I return a display_name for Organizations with no subtype as well as subtypes

global $civicrm_setting;
$civicrm_setting['eu.tttp.publicautocomplete']['params'] = array(
  'contact_type' => 'Organization',
  'contact_sub_type' => array('NOT LIKE' => "Facility\", \"Legislation\", \"Contract"),
  'return' => 'display_name'
);

Thanks in advance for your help.


texts: How do i add a new checkbox in message template

texts: I want to display a checkbox when the user clicks upload documents in message template. How should i do it?


texts: Selecting all checkboxes for field reverts to one value

texts:
On Wordpress 4.9.8 and Civi 5.4.0.

It shows multiple values as long as you do not select all of the options. If you select them all, then it reverts back to just one (petitioning in this case) for some reason. Exporting data only shows the one value as well.

I tried to reproduce on a demo but it was on 5.0 version. Is this a bug?


texts:
Hope you are all keeping well in this strange times!
We are currently trying to import some contributions in into the system from a CSV file (updating) but can't get past an error that is coming up. The error is coming up for all the records we are trying to import - Invalid value for field(s) : field ID;
Currently we are mapping the contacts External ID number to Contribution ID when running the import so could this be causing the problem.
As these contributions are new contributions (to existing donors with the system) why does contribution ID / Invoice ID / Transaction ID need to be a required field.
Currently the csv only only contains the External ID as the URN.
Any held would really be appreciated.
Many thanks
Terry


texts: Unable to update participants using civicrm api?

texts:
Instead of updating the Participant,its creating new participant.I need to change participant status from registered to attended and vice versa.

civicrm_initialize();
  $result = civicrm_api3('Participant', 'create', [
  'id' => $entity_id,
  'contact_id' => $context['civicrm_participant']->contact_id,
  'event_id'   => $context['civicrm_participant']->event_id,
  'status_id' => "Registered",
]);

I am executing the above code in the hook_action_info() drupal 7 using views bulk operations & custom entity module

function custom_changes_action_info() {
  return array(
     'custom_changes_actions_participant_status_attended_action' => array(
         'type' => 'civicrm_participant',
         'label' => t('Change Participant Status to Attended'),
         'configurable' => FALSE,
         'behavior' => array('changes_property'),
         'triggers' => array('any'),
     ),
      'custom_changes_actions_participant_status_registered_action' => array(
         'type' => 'civicrm_participant',
         'label' => t('Change Participant Status to Registered'),
         'configurable' => FALSE,
         'behavior' => array('changes_property'),
         'triggers' => array('any'),
     ),
  );
}

function custom_changes_actions_participant_status_attended_action($entity, $context = array()) {

  $entity_id = $entity->{$info['entity keys']['id']};

  civicrm_initialize();
 $result = civicrm_api3('Participant', 'create', [
  'id' => $entity_id,
  'contact_id' => $context['civicrm_participant']->contact_id,
  'event_id'   => $context['civicrm_participant']->event_id,
  'status_id' => "Attended",
]);
  //drupal_set_message($entity_id. 'entity_id');
 // $base_url = str_replace('_', '-', $context['entity_type']); // civicrm-participant
  //civicrm_entity_drupal_goto($base_url . '/' . $entity_id . '/edit');
}


texts: DB Error: constraint violation when I try to add profiles to contribution page

texts:
I cannot seem to enable profiles on contribution pages. There are no drop-down menus for including profiles, and when I try to type in an existing profile, I get a page with "DB: error: constraint violation."  What am I missing? (I am using CiviCRM 4.6.3 on Wordpress 4.2.2.)

Update: Here is a screenshot of the page:

Update:Here is the error/backtrace:

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (rpwrhsor_civicrm.civicrm_uf_join, CONSTRAINT FK_civicrm_uf_join_uf_group_id FOREIGN KEY (uf_group_id) REFERENCES civicrm_uf_group (id)), 1452
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            1 => handle
        )

[code] => -3
[message] => DB Error: constraint violation
[mode] => 16
[debug_info] => INSERT INTO civicrm_uf_join (is_active , module , entity_table , entity_id , weight , uf_group_id ) VALUES ( 1 , 'CiviContribute' , 'civicrm_contribution_page' ,  3 ,  2 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`rpwrhsor_civicrm`.`civicrm_uf_join`, CONSTRAINT `FK_civicrm_uf_join_uf_group_id` FOREIGN KEY (`uf_group_id`) REFERENCES `civicrm_uf_group` (`id`))]
[type] => DB_Error
[user_info] => INSERT INTO civicrm_uf_join (is_active , module , entity_table , entity_id , weight , uf_group_id ) VALUES ( 1 , 'CiviContribute' , 'civicrm_contribution_page' ,  3 ,  2 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`rpwrhsor_civicrm`.`civicrm_uf_join`, CONSTRAINT `FK_civicrm_uf_join_uf_group_id` FOREIGN KEY (`uf_group_id`) REFERENCES `civicrm_uf_group` (`id`))]
[to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_uf_join (is_active , module , entity_table , entity_id , weight , uf_group_id ) VALUES ( 1 , 'CiviContribute' , 'civicrm_contribution_page' ,  3 ,  2 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`rpwrhsor_civicrm`.`civicrm_uf_join`, CONSTRAINT `FK_civicrm_uf_join_uf_group_id` FOREIGN KEY (`uf_group_id`) REFERENCES `civicrm_uf_group` (`id`))]"]

)


texts: Individual contact type select is missing in custom field group setting

texts:
When I look in CiviCRM 4.6.8 at the custom field group settings associated with organization contact, then I see a select box where I can choose the type of organization type (as defined in Customize data and screens >> Contact types).

When I compare that with the custom field group setting associated with an individual, then I don't see this select box and I can therefore not restrict the field group to a custom individual contact type.

Is this to be considered by design or is this a bug being fixed in 4.6.9? To me it seems at least inconsistent. Please note that I have both custom individual and organization contact types defined.


texts: Amazon SES bounce messages don't seem to be properly categorized as Spam, Syntax, Invalid, etc

texts:
We have Amazon SES set up as a mailer, which works great and cuts our mailing costs to negligible levels. The only issue is that the bounce messages don't seem to be getting properly categorized by CiviCRM and I'm not sure how to address this.

Messages that should be marked Spam are categorized as Syntax, messages that are just format warnings ("This message is in MIME format.") are being categorized as Spam, etc. Obviously, this causes emails to be put on hold that shouldn't be or vice versa.

Not having much idea how this works, I'm not sure how to go about addressing it. Can anyone point me in the right direction?


texts:
We use HHVM rather than PHP-FPM on Nginx because it is way faster and creates far less load per visitor. HHVM is incompatible with certain PHP that PHP-FPM (PHP 5.x) doesn't have a problem with, so apps sometimes need edits to make them work.

In our case, we use Civi inside WordPress. WordPress seems to work fine in HHVM, as does our testing with Drupal so far.

I can't find any references to CiviCRM's compatibility with HHVM.

Has anyone tried it? Gotten it working? Should we give up?


texts: How to configure Views VBO action to disable relationships?

texts:
I'm trying to create a View of people with relationships to an organisation with options to disable those relationships.  I have created the view and added a VBO field on the relationship.

In the Selected Bulk Operations section, I have selected Modify Entity Value and then in the display section selected Relationship is Active.

The view then shows a 'Modify entity values' and after clicking that button I get a text box to enter the value of Relationship is Active.  Entering '0' and submitting then has the intended effect of disabling the relationship in Civi.

But ... what I really want is the button to say "Disable relationship(s)" and when clicked to set the Relationship is Active to 0 without asking the user for a value.

How can I achieve that?  (Drupal 7, CiviCRM 4.6.18, civicrm_entity 7.x-2.0-beta1)