texts: Issue in sections of civicrm that use /civicrm/.*/#/.* using LEMP

texts: So civicrm case and extensions like simple donate use a path that includes the # character.  When running on apache these work fine, but when I moved the site over to nginx, they stopped working. so I am assuming that I need a specific nginx location directive to handle this, but haven't been able to figure out what.


texts:
This is a question that came up during yesterday's training:
"Does CiviCRM offer the feature of sending email change notices?
If I go online and change my email address at my bank or broker, notice is sent both to my old and new emails. This gives not only a notice of change but also the chance for me to discover if I've entered the new email address incorrectly."

Any thoughts? If it's not possible now, would this be a good feature request?


texts: Due to an error a bankaccount (iban) was connected to a wrong contact, so several contributions must be transferred to the right contact. What is the procedure for this action?


texts: Street number doesn't change in CiviCRM after filling out Drupal Form, which is connected to CiviCRM. The correct street name is collected in the Drupal results, in the confirmation e-mail and in the activity. The problem is, it is not changed automatically in CiviCRM even though the field in the Drupal Form is directly linked to that field in CiviCRM.


texts: The announcement of release 4.6.15 (and previous updates) on the CiviCRM website blog is very 4.7 centric. There's no link to what fixes have been incorporated into the 4.6 update - and as 4.6 is an LTS release many will be wanting to stick with it.  Or have I missed it?  If someone can send me a link here that would be great.  Suggestion: improve the announcement to have a link to the fixes.


texts: Contributions not showing Thank You Screen

texts:
I'm testing through migrating from joomla to wordpress. My developemnt site is set up in Wordpress 4.2.2 and Civi 4.6.3. I'm having an issue with contributions, when you make a contribution the thank you page is skipped and the user is dropped back to the original contribution page (it's blank, like it redirects there.) The contribution is successful and an email is sent so I'm at a loss for what is happening.

I've checked the civi log and the error log, there's nothing there. I also tried to reproduce it on the demo site, no dice. I've turned off all plugins in wordpress and removed my custom php file.

The one thought I have is that all my urls seem to be using &2f rather then the forward slash for any "/" that occur after the "?page=CiviCRM" . I was thinking it might be a related problem since the URLs works with checksums??

Any idea what else I can do to solve this!?


texts: How to handle a partial payment with a bounced check?

texts: If someone pays an invoice with two checks (1 contribution, 2 payments), and one of the checks bounces, what is the correct way to record this?  There seems to be almost no documentation on refunds - I'm not even sure you CAN refund a payment that's not connected to an event membership - or if "refund" is even the right workflow.


texts: Custom code that sets custom field value stopped working in 4.6

texts:
I have some code in a  custom module (in the civicrm_pre hook) that sets a custom field value, using the function CRM_Core_BAO_CustomValueTable::setValues

Here's a print_r of the parameters it is passed in an example case:

(
    [entityID] => 1202
    [custom_133] => foo
)

The field is not being set. Before upgrading to 4.6, it was working. There is definitely still a custom field with id 133 on the entity. Here's the documentation - is it outdated now, or should it still work?

http://wiki.civicrm.org/confluence/display/CRMDOC/Setting+and+getting+custom+field+values+from+within+hooks

Edit: The output of CRM_Core_BAO_CustomValueTable::setValues is:

(
    [is_error] => 0
    [result] => 1
)

So it thinks it has worked, but it hasn't. The new value is not written to the database table.


texts: smart groups based on membership broken after upgrade from 4.6.4 to 4.6.5

texts:
Smart groups that are based upon advanced search membership are broken after upgrade from 4.6.4 to 4.6.5.  After the upgrade, the groups have everyone in the database.  When you select contacts in group and then click on the edit smart group search criteria you get the advanced search form.  The section for membership is expanded but the group is not selected nor is membership status filled in.

I can fix the groups but it's a bit of a pain.

I looked at the criteria in the civicrm_groups after the upgrade.  It looks the same as before the upgrade and doesn't work.  Once you manually fix them then the criteria is different.  I'm not sure if the civicrm_membership_cache is messed up or if the criteria isn't getting update.


texts:
I have problem to get PayPal Standard Membership Renewal to work:

If it's the only payment option, the form doesn't have a submit button, I would expect the PayPal button to appear.
If I use it with a second option like Pay Later, the form displays error message requesting Credit card number and Expiration dates, despite the fact, that this information would be collected on PayPal's site. (see screenshots here)

Any ideas?

CiviCRM 4.6.4 + WordPress 4.2.3
updated 7/30 upgraded to 4.6.5


texts: How can I use the Omnipay processor to audit missing payments?

texts:
I was told that I could use the Omnipay processor to detect missing payments.

I've determined that I need the API action PaymentProcessor.getmissing, and I can call this with: wp cv api PaymentProcessor.getmissing payment_processor_id=7.  However, when I call that (or wp cv api PaymentProcessor.query payment_processor_id=7), I get the following error:

PHP Fatal error:  Class CRM_Core_Payment_OmnipayMultiProcessor contains 1 abstract method and must therefore be declared abstract or implement the remaining methods (CRM_Core_Payment::doDirectPayment) in /home/members/healthcarenow/sites/dev.healthcare-now.org/web/wp-content/civicrm/extensions/nz.co.fuzion.omnipaymultiprocessor/CRM/Core/Payment/OmnipayMultiProcessor.php on line 34

What am I doing wrong? How can I successfully call this API?


texts:
In the table civicrm_group, I've noticed that even my non-smart groups have the fields where_clause, where_table, and select_table filled in. These don't seem necessary and cause a fair amount of slowness.

Is their a reason they exist, and is there a down-side to making those fields null in non-smart groups?


texts:
The date field seems to break when trying to update multiple contribution dates.
Drupal 7, Civi 5.10.4 and 5.11, Shoreditch enabled or disabled.  Also happens to break the Menu, KAM, Shoreditch, or Classic.

I was not able to replicate on the demo - and there are other contributions I am able to bulk update without issue - any ideas as to why this would happen?

UPDATE: The issue seems to be tied to one contribution - I was able to update all the other contributions, once I skipped that single one.  Nothing in that contribution seems to indicate an issue - will investigate further.


texts: Can not access System Status & New Mailing

texts:
I've install clean WordPress 4.8.1 by softaculous and CiviCRM 4.7.23. But when I access to System Status (wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fa%2F#/status) & New Mailing (wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fa%2F#/mailing), it shows only blank page.

I've tried install WordPress 4.8.1 and CiviCRM Long Term Support version 4.6.31, It works normally.

It's very strange that when I turn on Debug Mode, 2 link above can access normally like picture above. Please show me how to fix this.


texts: Civicrm update failed - from 5.19.2 to 5.29.0 - Drupal7 error log - page not found

texts:
Update failed - Get initial upgrade screen with message template warnings & The database will be upgraded from 5.19.2 to 5.29.0.. ..see screenshot of following page when I click "Upgrade Now". Screen distorted (see below) and stops. Upgrade doesn't work.
Drupal error log - first of many messages - "page not found"
Example:
LOCATION    https://mysite.org/drupal//home/mysite/public_html/drupal/sites/all/modules/civicrm/bower_components/jquery-ui/themes/smoothness/jquery-ui.min.css
REFERRER    https://mysite.org/drupal/civicrm/upgrade?reset=1
MESSAGE home/mysite/public_html/drupal/sites/all/modules/civicrm/bower_components/jquery-ui/themes/smoothness/jquery-ui.min.css


texts: How do you visually update a select2 widget?

texts:
I'm trying to select the value of a select2 widget using js. I can change the value ok:

jQuery('#excludeGroups').val("846").trigger("change");

The problem I'm having is that this doesn't update the display. It does work in that when you submit the form it's the correct value - so it's working behind the scenes. But it doesn't actually change the display - the new value doesn't appear in the widget. The documentation suggests trigger("change") should do it. I'm not getting any console errors. Is there a trick?


texts:
PHP 7.2, CiviCRM 5.30.1 and cv 0.3.4. Scheduled jobs are working, no errors in any of the job logs. The cron job, however, emails me:

[Symfony\Component\Debug\Exception\FatalThrowableError]
Call to a member function run() on boolean

The cron command is:

/opt/cpanel/ea-php72/root/usr/bin/php /home3/<linux_user>/bin/cv --quiet api job.execute --user=<civi_user> --cwd=/home3/<linux_user>/<drupal_root>

To make this more interesting, removing "--quiet" has the cron job email me:

{
"is_error": 0,
"version": 3,
"count": 1,
"values": 1}

And yes, I get the same results when running the commands from the shell. Thoughts?


texts: I would like to enable members of our Board of Directors to view our CiviCRM database without giving them permission to make changes.  I.e., read-only access.  Can this be done?


texts: Unknown mailing status on few mailings recipients

texts:
Since the 4.7.8 update to 4.7.10 and 4.7.10 to 4.7.12 recently some mails are not reaching their recipients. If I look at the Mailing Detail Report the Successful Deliveries rate is between 90% and 100% and the status of the not received mails are "Unknown".

To see these mails on the report I have to filter as status "-any-" because there is no possibility to do it with the status "unknown".

Has anyone encountered the same problem? What may be due?

Edit

I investigated a little more and I see that "Unknown" status appears when there is no record on the civicrm_mailing_event_bounce table AND when there is no record on the civicrm_mailing_event_delivered. Then, it seems that for some users, there isn't registering the delivery of the mail.

I begin to suspect that the problem is related with an issue of inconsitency caches of the mailing recipients groups.

Edit 2

I found on logs messages like [info] CiviMail will not send an empty mail body, Skipping: xxxxxxxxxx@xxxxx.xxx corresponding to the contacts with mailing status marked as "Unknown".


texts: How can I display that an event is full on a Drupal View?

texts:
Currently a user needs to click through to an Event info page before they know if it is full or not.

Is there a way to take this information:

  "This event is currently full."

and display it in a Drupal View/ Pane?


texts:
I'm dealing with a system where the Quick Search box is not working.  Using the browser dev tools shows ajax requests being sent but receiving a '406 Not acceptable' error.

According to https://developer.mozilla.org/en-US/docs/Web/HTTP/Status/406 this relates to content negotiation.

The AJAX URL is:

https://example.com/administrator/?option=com_civicrm&task=civicrm/ajax/rest&entity=contact&action=getquick&json={"name":"a","field_name":"","table_name":"cc"}

and the content negotiation headers in the request are:

Accept: application/json, text/javascript, */*; q=0.01
Accept-Encoding: gzip, deflate, br
Accept-Language: en-GB,en;q=0.5

This matches what I see on another system that is working normally.

This is CiviCRM 5.5.2 on Joomla 3.8.13

Any ideas?


texts: Is it possible to process card payment for an event direct in Civi event without completing a form on the website?


texts:
Thanks for assisting .. I have just a couple of questions:

1)  I'm a little puzzled by missing navigation icons (see below)..and it would appear to be using a relative reference. I'm hosting CiviCRM on the Google cloud thru Bitnami which is by and large working pretty well. Nowhere in the configuration would appear to allow me to put in specific reference of the IP where CiviCRM is hosted.  I can see the image gifs with the specific IP and image path.  Saw a post Broken Image Link (Menu)  but didnt quite work for me.

2) In configuring the Navigation Menu, I could not remove the sub menu items of Events and other top menu items.  I was able to do so in a local install previously when I would simply click on the Events link, and all the sub menu items displayed below, and I simply deleted the sub menu items, click to refresh and it was done.  With this install on the cloud - there is no response when I click on Events menu item.  But I could right click on it do Rename, Delete and Edit the main menu item.


texts: Moved Wordpress and CivCRM to new server recently

texts:
Recently I moved my Wordpress Install with CiviCRM over to a new server. I changed the path location in civicrm.settings.php file to reflect the new location. The front end of appears as if nothing is wrong but on the admin dashboard this appears:

  Warning: require_once(/CRM/Core/ClassLoader.php): failed to open
  stream: No such file or directory in
  /home/xxx_xxx/public_html/wp-content/plugins/civicrm/civicrm.settings.php
  on line 399

  Fatal error: require_once(): Failed opening required
  '/CRM/Core/ClassLoader.php'
  (include_path='.:/home/xxx_xxx/public_html/wp-content/plugins/civicrm/civicrm/:/home/xxx_xxx/public_html/wp-content/plugins/civicrm/civicrm//packages:.:/usr/lib/php:/usr/local/lib/php')
  in
  /home/xxx_xxx/public_html/wp-content/plugins/civicrm/civicrm.settings.php
  on line 399

If I deactivate CiviCRM, everything else appears to work fine, but I need this to work for this site. Any and all help is greatly appreciated!


texts: How to Disable Calls to CiviCRM site in 4.7?

texts:
I am running CiviCRM on a standalone network (for testing purposes) and am getting regular errors about not being able to connect to the CiviCRM site.  How can I disable these calls in 4.7?

Thanks!


texts: Deleting saved searches created via Search Builder leaves data in various tables

texts: When a saved search is created via Search Builder, a row is created in the civicrm_mapping table as well as in civicrm_saved_search table. If the smart group is then deleted via the UI, the rows in both tables are not deleted. Is this a bug?


texts: Call to undefined function civicrm_initialize() in sites/all/modules/contrib/civicrm_entity/civicrm_entity.module:488

texts:
I've just updated Drupal core (to 7.75) and found my site was stuck in maintenance mode, even after it was unticked in configuration. I've had this before and always been able to get round it with a cache clear. Now though, the site won't load to let me clear the cache though the UI. I've been trying to do it through Drush and am getting the following:
Fatal error: Call to undefined function civicrm_initialize() in ~/public_html/sites/all/modules/contrib/civicrm_entity/civicrm_entity.module on line 488
Drush command terminated abnormally due to an unrecoverable     [error]
error.
Error: Call to undefined function civicrm_initialize() in
~/public_html/sites/all/modules/contrib/civicrm_entity/civicrm_entity.module,
line 488
Drush was not able to start (bootstrap) Drupal.                 [error]
Hint: This error can only occur once the database connection has
already been successfully initiated, therefore this error
generally points to a site configuration issue, and not a
problem connecting to the database.

Drush was attempting to connect to:
 Drupal version                :  7.75
 Site URI                      :  http://default
 Database driver               :  mysql
 Database hostname             :  *.*.*.*
 Database port                 :
 Database username             :  *********
 Database name                 :  *********
 Database                      :  Connected
 Default theme                 :  nexus
 Administration theme          :  seven
 PHP executable                :  /usr/local/bin/php
 PHP configuration             :  /usr/local/php56/php.ini
 PHP OS                        :  Linux
 Drush script                  :  ~/drush/drush.php
 Drush version                 :  8.4.5
 Drush temp directory          :  /tmp
 Drush configuration           :
 Drush alias files             :
 Install profile               :  standard
 Drupal root                   :  ~/public_html
 Drupal Settings File          :  sites/default/settings.php
 Site path                     :  sites/default
 File directory path           :  sites/default/files
 Private file directory path   :  sites/default/files/private
 Temporary file directory      :  tmp
 path


texts:
Is there any solution that can bulk email invoices to the members? For example a combination of the two features below:

Email invoice: https://docs.civicrm.org/user/en/latest/contributions/invoicing/

Mass mailings: https://docs.civicrm.org/user/en/latest/email/mass-mailings-using-civimail/


texts: CiviMail adding ?civiwp=CiviCRM to all links - causing links to be bad

texts:
Using Mosaico 2.3 (2.4 does not work for us) & traditional civimail.
CiviCRM 5.27.1 WordPress 5.4.2
All url's in civimail append ?civiwp=CiviCRM - causing errors when linking to wordpress pages. example.org becomes example.org/?civiwp=CiviCRM - This is fine for most URLs but causes issues with wordpress urls.


texts: How can I set up an incoming email account on GMail with OAuth?

texts:
Google has announced that traditional username/password logins to G Suite mail accounts will be disabled and logins will require OAuth authentication in the future.  The CiviCRM OAuth documentation partly explains how to configure OAuth with CiviCRM, but says, "After registering OAuth2 details with CiviCRM and Microsoft [sic], you can add an incoming email account." without explaining how.
How do I register my OAuth2 details with Google?


texts: Can't save profiles (any type) getting an error, this is CIVI Crm 5.x and drupal 7 on localhost

texts:
Whenever I try to edit or save a profile, I get this error:

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.
DB Error: no such field

Error in D7 log messages is:

Type    page not found
Date    Sunday, September 30, 2018 - 11:39
User    1
Location    http://localhost/crm4/undefinedjs/jquery/jquery.crmAjaxTable.js
Referrer    http://localhost/crm4/civicrm
Message undefinedjs/jquery/jquery.crmAjaxTable.js
Severity    warning
Hostname    ::1
Operations


texts: CiviCRM API V3 : Translate Two Digit State to State_Province_id?

texts:
I'm using civimigrate for a pretty intense migration into CiviCRM and I have hit something of a puzzler.

I have a table with addresses that I am matching to contacts, but I cannot seem to find a way to map a state abbreviation (AL,MD,FL) to an id for the api.

I was hoping to find something in the API explorer to paste into my import, but I can't seem to find out where the API calls for translating state abbreviations into ids live.

Any ideas?


texts: How to Fix Missing Organization Profile Dropdown in Contribution Form Settings

texts:
I'm working on my first install of CiviCRM. So far it's been a fairly smooth process. I'm at the point of creating a form to register members (as we are a 501c6). I created a contribution form, and I want to require that users contribute on behalf of an organization - as this is a registration for membership.

However, the dropdown menu to select which profile to use isn't there. I see where it should be, but it doesn't show up. This is my first form of this type, so it's entirely possible I just missed something simple, but I've tried everything I can think of. I've even disabled the CSS in case that was somehow hiding the dropdown.

At this point, I can't move forward with the registration is it requires me to put in an Org Profile but does not give me any way to select one.

Anybody experienced this problem before? Anything I can do to fix it? Because I'm stumped on this one.

Thanks in advance!

P.S. I just posted this on the old forums, but saw that they were deprecated, so I moved it over here.


texts: Is this a bug in civicrm/case/activity/view breadcrumb?

texts:
Disable popups in display preferences.

Find a case eg     civicrm/case/search?reset=1.

'Manage' the case to open it.

Click on    the activity Subject, goes to eg    civicrm/case/activity/view?cid=203&aid=642

The 'Case Activity'    breadcrumb links to civicrm/case/activity?reset=1 which gives an error when you try to use it:

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.
required params missing.

Can reproduce this on http://dmaster.demo.civicrm.org


texts:
We have a volunteer organisation. Most of the volunteers are in thier 70's. Is there a way that CIVI can do the following using either a profile or a specific page that does the following sequence at once after data entry

Add the Household Contact and relevant fields
Adds a new individual for each household member
Adds the relationships for primary contact then household member(s)
Then adds the Household as a membership and save it all

Ok i hear you....am I drawing a very long bow?


texts: Change Case summary report to group by Case ID

texts:
When civicase is configured to have multiple case clients, the summmary report
(report class: CRM_Report_Form_Case_Summary) shows one line for each client.

I'm trying to change this to show only one line per case.  I've created a copy of the above report and i'm trying to change the group by clause, currently it's

  public function groupBy() {
    $this->_groupBy = "";
  }

I'm looking for some pointers to how to change this to group by CaseID.

Is this the right way to go and if so what would i need the function to say.


texts: Have CiviCRM follow CMS language with Joomla

texts:
I currently have CiviCRM 5.25.0 and Joomla 3.9.19.
Joomla is bilingual Fr / En and users can switch from one language to the other no problem.
CiviCRM is set up bilingual with Fr as the default language, but all fields are defined in both languages (Fr_CA & En_US).
I have set the "Inherit CMS language” option to YES.
I set up in Joomla two URL Menus (one in Fr and one in EN) to list a contact group.
In the French site, I see the profiles fields in French, as it should. But when I switch to the English in the frontend, the menus are in English, as expected, but the profile remains in French.
If I switch the CiviCRM default language to En, then the English side is OK (the users see the profile fields in English) but  French users also see the profile in En even though the Menus are nos in Fr.
It thus seems that the profile follows the default CiviCRM language and not the CMS language.
I have tried to force the language by adding “&lcMessages=en_US” at the end of the English Menu URL - as I found in some forums - to no avail. Just in case, I have also tried en_UK.
Any idea on how to force the profile to follow the user’s language preference?
Just in case it is needed, here is the English page: https://www.voile.qc.ca/en/?option=com_civicrm&task=civicrm/profile&Itemid=609&force=1&gid=14&lcMessages=en_US
Thanks in advance for your help!


texts:
I have installed CiviCRM on Wordpress and done the setup.
I have created a basic (subscriber role) in WP, have filled the Permissions (Access Control) table for this role, synchronized the WP contacts with CiviCRM. When this user logs into WP, he do not see the CiviCRM menus nor dashboard...
What is the CiviCRM URL for this user ? I have read the documentation, but nothing about it...
Which configuration is missing ?
Thanks for your help

* Next to my question *

First of all, I have not designed other roles than the two that are predefined : Administrator and Authenticated. As I understand, I do not need other roles for the moment. My test user has the Subscriber role in Wordpress.
I also have read carefully the documentation.

Next, I have logged in as Administrator in Wordpress&CiviCRM. In the CiviCRM top menu, I go to Administer ->Users and Permissions -> Permissions (Access Control). And there, I enter in WordPress Access Control. I see then an ACL table and I have checked quite all boxes under the Subscriber column.

But nothing changed : a subscriber user does not see the CiviCRM plugin. And the CiviCRM dashboard for this user does not show even if I type "https://mysite.org/wp-content/plugins/CiviCRM (is this the correct url for CiviCRM under Wordpress ?)

Thanks a lot for your help.

I'm still stuck with my access privileges problem. Users connected with the "subscriber" role in WordPress do not see the CiviCRM menu in the left WordPress menu.
However, it seems that I have configured correctly the permissions in Administer -> Users & Permissions -> WordPress Access Control.
Any ideas? Many thanks


texts: flexmailer terminating without processing mail

texts:
I'm seeing persistent issues when running larger mailings using Mosaico/Flexmailer for one site. Small mailings will process without any issues. But larger mailings (e.g. 25k+) will terminate in the process_mailings job. The specific point of failure is in /src/FlexMailer.php - fireWalkBatches(). The $event object appears to be constructed properly, but it dies on the dispatch call.

It's been challenging to troubleshoot as there are no errors in the Civi log or apache logs. It simply dies at that point.

Anyone else see similar issues or have suggestions for troubleshooting?

Additional info --

The issue only occurs when triggering jobs via the cli (this site is running Drupal and triggering cli.php). If I trigger process_mailings via the URL/cron.php, including triggering it with wget from a cron, it processes correctly.


texts:
I want to add one text field in  the /civicrm/admin/setting/mapping.
How can i add text field in admin mapping setting page ? I have override the mapping tpl in my custom location.


texts: amount for working hours of volunteer on an event

texts:
I need to know how many hours a volunteer works for us. Is this possible to set up using events?

Here's how I have configured CiviCRM:

a volunteer is a contact and has a relationship with our company
this volunteer is an event participant with the role Project Staff.

I don't have the CiviVolunteer extension.


texts: Unable to Change Selections on Event Registration, Error: "Expected one Contribution but found 0"

texts:
We just updated to 4.7.30 and the latest Drupal 7 version. Now, when viewing participant records that include a contribution record, the following error is in the Fees section:

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.
Expected one Contribution but found 0

As far as we can tell, participants are able to register just fine since the update. In the Selections section, the appropriate selections are there, but if we click the Change Selections link, we get the error: Network Error: Unable to reach the server. Please refresh this page in your browser and try again. Refreshing does not help.

We are still able to edit the contribution records that are displayed on the participant record. We can register new participants manually and the error does not appear. The error also seems limited to events...does not appear in membership.

We have no Civi Extensions on this site.


texts: How to connect with state and country table

texts: We are using CiviCRM (4.7.9) with WordPress (4.5.3). We are pulling the data from the CiviCRM state and country tables into Gravity Forms using code in our function.php. But we are running into problems when a Country does not have a State.  The WP Gravity form will save all the data, no problem.  And the web hooks that we are using between WP and CiviCRM will send the info into Civicrm, but it will not send the Country information when there is no State, even though there is no corresponding State for these Countries in the CiviCRM tables. Is there another value we are suppose to send? A Null value?


texts:
is it possible to add custom field in :

http:/drupalsite.com/civicrm/mailing/subscribe?reset=1

I tried looking for custom field additional in the settings but not available?
is there a hook needed to process?

as its only collecting one email info for now?

thank you


texts:
I have three environments that I can work in.

Production - the live site, currently 4.7.9
Development - a development site, currently 4.7.7
Staging - a sandbox, currently 4.7.9

I create an event in Production, go to the Online Registration tab. The "Include Profile (top of page)" label is there but the field is missing. The "Include Profile (bottom of page)" field is there as a text field (not a dropdown list). I can type in either the name of the profile or the profile ID, but the profile doesn't appear on the site web page, only the three default event fields (first name, last name and e-mail). The behavior on the Development site is the same.

When I create the same event/profile on the Staging (sandbox) site, the the "Include Profile" fields generates a dropdown list of current profiles and the profile fields correctly appear on the site web page.

Any ideas on what's going on?

Thanks!

Adam


texts:
Looking for a quick answer from someone who may have done this before I spend hours of testing.

I am implementing a "Family" membership where members of family will get the inherited membership of the paying member based on a relationship that I created. This works really well. The paying member shows a membership "Family". The members of the family show a membership "Family (by relationship)".

I want to schedule a reminder for the paying member to renew their family membership, but don't want to send the reminder to the members of the family (some of them are children and while they may have email addresses entered into their record, they shouldn't get emails for membership renewals).

So... if I create a scheduled reminder based on the Family membership, will the (by relationship) members get the reminder?

I'm running CiviCRM 4.7.47 on WordPress 4.9.5


texts: Is there a way to pass additional information (e.g. Description) to the PayPal payment-processor?

texts: We are using PayPal as our payment processor and Xero for our accounting. When reconciling the PayPal items generated from CiviCRM we noticed a field called "Description" that is usually empty. Is there any way of passing information to that PayPal field from a CiviContribute form? It would be monumentally helpful when reconcilling if we could pass simple descriptions like "Dues" or "Building Fund" to PayPal that we could then see in Xero (and use reconcilliation rules with).  Thanks.


texts:
I'm doing some testing on a CiviContribute page in preparation for implementing CiviMember.

During the course of testing, it seems that renewals aren't creating activity records.

Is there some kind of date differential requirement before it logs?

My current testing involved creating a new membership, but also renewing the same day. This initial "renewal" was also an upsell. I then renewed that using the same level.

I also got the same result when testing a renewal without an upsell.

I'm running Drupal 7.37 with CiviCRM 4.6.3. No extensions are installed.

Any help would be much appreciated!


texts: civievent - add 2097 participiant to an event

texts:
I tried to add 2097 contacts as a participant to an event.
procedure:
 - search
 - advanced search for "individuals"
 - action add 2097 participants to an event
 - waited for more than one hour
 - it didn't add the participants to this event, no error message

I did the same procedure with 1597 contacts and it works. is there a limit?


texts: Contact Import Longitude missing in mapping

texts: I am trying to import contacts from one CIVI database to another however when doing the field mapping there is a map for latitude but not one for longitude. Am I missing something, if not is there any way to fix this?


texts:
Editing the work flow messages, I'm looking for the field names preceded by $formValues.
More specific I would like to include a line displaying the origin of the contribution in the work flow message "Contributions - Receipt (off-line)".
Where to find all the field names that can be used?


texts: How to download a copy of the CiviCRM User and Administrator Guide?

texts: I am a new admin user of CiviCRM and want to know how to download a copy of the latest Admin Guide rather than view online? This is referred to in the introduction and refers to the chapter 'History of this Guide' but I can't find a link to a file anywhere.


texts: endless spinner when selecting event location

texts:
When selecting a different location for an event where this event is the only one using the current location, upon save you'll see an endless spinner.

Everything seems to get deleted just fine in the d/b (the previous location gets deleted as it's no longer needed as it was only used by one event ... that's how Civi does it, anyway), but the endless spinner in the UI is annoying and our staff get worried. ('coz, you know, we saw the recent bug where creating a new location inserted this location to all events that shared the previous location ... anyway, our staff are a little gun shy as you can imagine).

In the error log, I see the following:

[code] => -3
[message] => DB Error: constraint violation
[mode] => 16
[debug_info] => UPDATE  civicrm_loc_block  SET address_id = 29774 , email_id = NULL , phone_id = NULL , im_id = NULL , address_2_id = NULL , email_2_id = NULL , phone_2_id = NULL , im_2_id = NULL   WHERE (  civicrm_loc_block.id = 61 )   [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`evergr55_test`.`civicrm_loc_block`, CONSTRAINT `FK_civicrm_loc_block_address_id` FOREIGN KEY (`address_id`) REFERENCES `civicrm_address` (`id`) ON DELETE SET NULL)]
[type] => DB_Error
[user_info] => UPDATE  civicrm_loc_block  SET address_id = 29774 , email_id = NULL , phone_id = NULL , im_id = NULL , address_2_id = NULL , email_2_id = NULL , phone_2_id = NULL , im_2_id = NULL   WHERE (  civicrm_loc_block.id = 61 )   [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`evergr55_test`.`civicrm_loc_block`, CONSTRAINT `FK_civicrm_loc_block_address_id` FOREIGN KEY (`address_id`) REFERENCES `civicrm_address` (`id`) ON DELETE SET NULL)]
[to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE  civicrm_loc_block  SET address_id = 29774 , email_id = NULL , phone_id = NULL , im_id = NULL , address_2_id = NULL , email_2_id = NULL , phone_2_id = NULL , im_2_id = NULL   WHERE (  civicrm_loc_block.id = 61 )   [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`evergr55_test`.`civicrm_loc_block`, CONSTRAINT `FK_civicrm_loc_block_address_id` FOREIGN KEY (`address_id`) REFERENCES `civicrm_address` (`id`) ON DELETE SET NULL)]"]

I was able to reproduce this on one of the demo sites (which uses Drupal; I'm seeing it on Joomla on my end).

Anyone else seen this issue? Wanted to check here before submitting an issue on Github.

Thx


texts: Paypal Standard not working in embeded civi form

texts:
Problems began after I updated from 4.6.7 to 4.6.10.
Checking out with Paypal standard doesn't work if the form is embedded in another site.

I get this message in the console:

Refused to display 'https://www.paypal.com/us/cgi-bin/webscr?cmd=_flow&SESSION=************' in a frame because it set 'X-Frame-Options' to 'SAMEORIGIN'.

Any Ideas


texts: I'm developing a custom API v3 action which is intended to handle a webhook request from Zoom (https://marketplace.zoom.us/docs/api-reference/webhook-reference). Zoom follows REST standards by putting the data inside the request's body (not like the CiviCRM api where you put the data inside a json parameter). So, is there a way to access the request's body from my custom action or custom extension?


texts: Unable to install CiviCRM 4.7 on Wordpress 4.4.1

texts:
Environment:

PHP Version 5.6.15

Apache 2.4.17

MySQL 5.6.27

Windows 10

Wordpress Plugins Active:
Exclude Pages from Navigation, Ninja Forms, Ninja Forms - Layout Master

When attempting to install CiviCRM on my local dev platform described above, I am following the instructions as detailed at https://wiki.civicrm.org/confluence/display/CRMDOC/WordPress+Installation+Guide+for+CiviCRM+4.5

Everything is fine until I click the "Check Requirements and Install CiviCRM" button - a spinner briefly appears next to it before the frame on the admin page goes blank (menu and toolbar remain) and the entire page appears to be attempting to refresh. Then after a few minutes of loading I am left with a URL ending wp-admin/?page=CiviCRM&q=civicrm&reset=1 - and a white screen.

If I navigate back to my admin console and attempt to go into the CiviCRM plugin I get the following error message:

  Fatal error: Uncaught CRM_Core_Exception: [0: Found installation
  canary. This suggests that something went wrong with tracking
  installation process. Please post to forum or JIRA. thrown in
  (MyWordpressHomeFolder)\wp-content\plugins\civicrm\civicrm\Civi\Core\InstallationCanary.php on line 53

I have tried manually deleting the civicrm_install_canary table but that does not resolve the issue...


texts:
I've been moving a CiviCRM from WordPress to Drupal but getting a strange array of errors.

It's on the same hosting so I've set up a new database for the new CiviCRM, moved all the tables except the 4 cache tables and the domain. I've cleared all the cache, rebuild menus, (attempted) to sync the users (only got about 180 out of 280 but that's a good start).

My problem is that a number of the pages in CiviCRM throw up the 'DB table does not exist' error:
When I edit/create a contact
Organisation address and contact info
The page to edit the navigation menu opens but the triangle is just spinning
Quick search doesn't work (nothing happens) but Find Contacts does work.

I've turned on the advanced logging, and getting errors like the following:

Notice: Undefined index: frontend_title in CRM_UF_Page_Group->browse() (line 329 of /home/xxx/www/data/sites/all/modules/civicrm/CRM/UF/Page/Group.php).

Any ideas?

Thanks


texts: Displaying Custom Fields in Views Calendar

texts:
Is there a way to display custom fields in a Views Calendar (Drupal 7, CiviCRM 4.7.18)? I have custom fields in a table assigned to a certain contact (with the option to add more rows). One of these fields, is a date/time field. I'm trying to display this field in Views Calendar. I tried going to "add view from template" and then choosing the option: "A calendar view of the 'custom_45' field in the 'civicrm_contact' base table." However, I'm getting the error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'civicrm_contact.custom_45' in 'field list'

Weird because I am able to list all these fields in a table fine.


texts: How do I Add Contacts to Group from an Activity Report?

texts: There is a choice in Activity Reports to Add Contacts to Group, on the  top right - so I created a new Group and chose that Group, but there is not a button to click to complete the add. It's not automatic. I'm on Civi 4.6.3.


texts: Individual Update Employer address/profile informaiton

texts: Using profiles individuals are able to update their own information. However i need an individual to be able to update their employers information. What solutions are there using wordpress for this?


texts: Unable to locate folder xml under the civicrm root directory

texts:
I am new to civicrm and trying to build extension. The extension is build and activated. The stage where I got stocked is when I trying to add entity for my civicrm extension. I am following the  Official Documentation from the civicrm website.

Point 4.c has mentioned to edit the file <civiroot>/xml/schema/Schema.xml but I am unable to file with that name and neither the path under the <civiroot>

Please Note: my civicrm root directory that I am following with Drupal7 installation is as <DruaplRoot>/sites/default/files/civicrm

Please help to get out of this problem as I am unable to add new entity.

I'm thankful to you in advance.


texts: Summary Fields triggers settings not enabled

texts:
On the extensions admin screen I see

I tried following this solution but rebuilding triggers had no effect.

How do I get the triggers to be enabled? The cron job Call SumFields.Gendata API says it is successful and runs every hour.

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

  Full message:  Finished execution of Call SumFields.Gendata API with
  result: Success (a:1:{i:0;s:89:"Original Status: scheduled:2020-05-04
  15:33:23, New Status: scheduled:2020-05-04 15:37:48";})

That is the only cron job I see.


texts: How do I setup an online contribution page linked to Mogiv?

texts: We are using Mogiv for our online giving portal.  How can I link my online giving transactions from Mogiv to my contacts in CiviCRM?


texts: How can arrange custom fields so they are side by side?

texts:
I have a high number of 'outcomes' for a client in the format of 3 fields for each outcome as below:

'outcome words',  date identified,    date met

Problem is that custom fields are formatted as one below the other as:

'outcome words'
date identified
date met

Which means that the screen will be very deep causing the user to scroll down a lot.  What would be involved in re-formatting the screen so that these fields are all side by side?


texts:
After activating the CiviCRM plugin within Wordpress and opening the 'CiviCRM Installer' I am unable to alter the CiviCRM Database settings fields to point to my CiviCRM database.

The fields are pre-populated with my Wordpress database details and whenever I alter them and press 'Re-check requirememnts' my details are removed and the Wordpress database details re-appear.

Windows Server 2012 R2
IIS 8
php 5.4.45
MySQL 5.1.73
Wordpress 4.4.1

The installer for 4.6.x works fine, after upgrading to 4.7.x, the upgrade is successful but I receive Datatables warnings on fields with Tab with table Display styles (such as Relationships) and wanted to try a fresh install.

Has anyone experienced this behaviour before, or able to help me resolve this?

Many thanks
Russell


texts:
I installed my Civicrm with the IP address of the server which turns out to be a "Bad Idea" (TM). Now when trying to enter various posts, such as membership details or new events I keep getting "logged out" (clicking save redirects to a login page for the IP-address).

I tried changing BASEURL in the civicrm.settings.php file, then clear all caches - but I still get this behaviour. Which is extremely  annoying.
How do I fix this?


texts:
I would like to customize the auto TY email that is generated to a donor once a donation is made. Can I do this? If so- can you please tell me how?
Thanks so much!


texts: api4: get(FALSE) vs get()->setCheckPermissions(FALSE): which is preferred?

texts:
In ap4, there are apparently two different ways to specify skipping permissions:
In the api4 browser at /civicrm/api4, when you un-check the "CheckPermissions" checkbox, the action method is given a single boolean-negative argument:
\Civi\Api4\Contact::get(FALSE)

But various documentation (e.g. https://docs.civicrm.org/dev/en/latest/api/v4/joins/#using-an-api-join and https://docs.civicrm.org/dev/en/latest/api/v4/differences-with-v3/) describes an explicit method:
\Civi\Api4\Email::get()
...
  ->setCheckPermissions(FALSE)
...

I assume these are equivalent. Personally I prefer the more explicit method as it's well, more explicit, but I wonder:
Is one of these preferred as a best practice, in the community at large or by core developers?


texts:
Could you tell me how I can filter a group/mailing list we have to view by certain countries? For example we have a 'Youth Collective' lsit but we'd like to filter this by addresses to see all that are from the UK.

Thanks,
Megan
megan@restlessdevelopment.org


texts: Why don't links work from CiviCase Dashboard to filter by case type?

texts:
This works correctly on the Joomla demo server with 4.6.0, but not on my Joomla with CiviCRM 4.6.8.  Not sure if this is a problem with the more recent CiviCRM versions, or something else in my configuration.

On the demo server, if you create cases in CiviCase, then go to the CiviCase dashboard, you can click on the numbers in the grid layout showing how many cases of what case type have what case status.  This works by adding parameters to the URL of &status=2 and &type=2 (for example).

On my installation, the destination page seems to pick up status correctly, but even when type=3, it comes to a page giving an error that it couldn't find any cases, and shows the wrong search criteria for type:

 No matches found for:
Case Status(s) = Processing ...AND...
Case Type(s) In 1 ...AND...
Application = All Applications

Why does it think I want case type of 1, when the URL specified type=3 ?

If, from this screen, I select the Case type I want and click Search it gives a correct report as expected.  But it's very inconvenient to have those direct links from the dashboard not work.


texts: Which accounting software is compatible?

texts: I was wondering what accounting packages, if any are compatable with CiviCRM.  I'm in Australia also if that helps.


texts:
When using CiviCampaign's CiviPetition it would be nice to be able to place a field of the number of people that have signed up facing the public (same goes for e.g. number of members, etc.). I know this is CMS dependent, having read it may be possible using Drupal. Any ideas for e.g. Wordpress (probable needs PHP somewhere!?).
Cheers


texts:
I'm considering testing the shopping cart functionality in CiviCRM's CiviEvent module (installed here with Drupal 7) and was wondering if anything has changed in the description page on the CiviCRM site that includes bug reports. I saw it was last updated in 2013 - thought I'd check.

Thanks!


texts: Apply Access Ajax API permission to allow Add new organization option to public autocomplete for current employer, still not works

texts: Civicrm-4.7. Apply Access Ajax API permission to allow Add new organization option to public autocomplete(1.4 v) for current employer field, but still not works!.


texts:
sorry for what is probably a ridiculous question.
Our wordpress site was migrated to a new server by our host, the domain is unchanged. Now several of the CIVICRM features are not working anymore. Such as payment processing for example or signing up to our newsletter. One of the issues for example is our stripe webhook failing as it now can't reach https://example.org.au/?page=CiviCRM&q=civicrm/payment/ipn/3. When I try to go to the live links for contribution pages, it just shows: "Do not delete this page. Page content is generated by CiviCRM."
I've cleared the cache and reset the paths and looked at the civicrm.settings.php files but couldn't find a place where I had to link to a new IP address. I've also looked for a guide on the CiviCRM page but was unable to find clear instructions on what to do.
If someone can point me in the right direction it would be super appreciated,
thank you for the help
cheers,
David


texts: Database name on Wordpress can't include hyphen, but our host has mandatory prefix-hyphen-name format

texts:
Is there any way we can work around this?

Our Joomla install was quite happy to use a db of format xxnn-yyyyyy.

When we create or rename db using phpMyAdmin we can only choose the yyyyyy. "xxnn-" is automatic.

The CiviCRM Installer had an error to the question
"Is the provided database name valid?   The database name provided is not valid. Please use only 0-9, a-z, A-Z and _ as characters in the name."


texts: Can I create report with filtered custom field values?

texts:
When I create reports, they list either Contacts, Contributions, Activities or similar. Is it possible to list Custom Field entries?

For example, I have a TAB with custom fields. I'd like to get a list of entries that have PARAMETER X with corresponding DATA value from multiple contacts, while not listing Y.

Alternatively, I'd like to get ALL of these Custom Field entries from multiple contacts (including contact name), not just the names of contacts that contain these Custom Fields entries.

Is that possible? If not via reports, maybe somehow else?


texts: How can I determine if an extension is compatible with a new Civi version?

texts: What is the best way to determine whether an extension is likely to be compatible with a contemporary Civi version rather than just not updated to reflect as much?


texts: How to suppress columns from Manage Group search results

texts:
I'm customizing a version of the Manage Groups page. Users don't want to see Description, Group Type, or Visibility. I thought I could just customize a version of Group/Form/Search.tpl .

It's easy to suppress the column headers by commenting out the  tags. I need help learning how to suppress the actual  tags though. I can't make sense of the js in that template.


texts: Adding And Removing Fields To CiviCRM Tables

texts:
I had earlier added a new field to the civicrm_event table called "enable_tracking".
I achieved this by adding a new field to the xml/schema/Event/Event.xml file.
After this I ran the regen.sh script. Everything worked fine.

Now I wanted to remove this field from the civicrm_event table, so I removed the field from the Event.xml file and ran regen.sh again. However I am getting an error when running this script.

+ echo 'Populating database with dataset - civicrm_generated.mysql'
Populating database with dataset - civicrm_generated.mysql
+ mysql -udrupalclea_vpj3r -XXXXXXXXXXXXX -h 127.0.0.1 -P 3306 drupalclea_vpj3r
ERROR 1054 (42S22) at line 462: Unknown column 'enable_tracking' in 'field list'

One hack would be to manually edit the civicrm_generated.mysql file. Is there any other way?


texts: How to fetch CiViCRM events externally [ Drupal 7]

texts:
I'm new to CiViCRM. I want to fetch events which are created in CiViCRM which is hosted on another server. So basically I want to fetch CiViCRM data from one individual site to my site. I don't know that which are the ways to do it and which is the best one. But I think Rest option would be good if I'm not wrong. I'm not able to find any similar example which is near to my task. All I don't understand that how should I use my rest url with code:

Option 1:

$api = new civicrm_api3(array ('server' => 'http://localhost/abc',
    'api_key'=>'123456789',
    'key'=>'123xyzABC'));

Option 2:

 $contactxml =       simplexml_load_file("http://localhost/abc/sites/all/modules/civicrm/extern /rest.php?entity=contact&action=get&key=<site    key>&api_key=$apikey&last_name=Koot");
 foreach ($contactxml->children() as $contact) {
   $display = $contact->display_name;
 }

Is there any other options. I want to go for option 1 if that is possible. And I want response in JSON if possible.


texts: How can I find the CiviCRM Admin API key from Wordpress CiviCRM plugin

texts:
We have got a wordpress website using CiviCRM plugin. The only thing which we have is the CiviCRM site key, but in order to implement the functionality on the website we need CiviCRM API Key.

Can you or anyone please advise from where can we get those details?

Urgent help would be much appreciated.

Thanks


texts:
I've checked many times on transifex in order not to forget important elements and, eg, all household occurrences are correctly translated to italian.
I'm using 4.7.19 on Joomla 3.6.5 (or 3.7.2), php 5.6.
I've also downloaded the .po files and combined to .mo with poedit.
But there are words that keep being in english, for example on the left sidebar, the dropdown menu for adding new items, still shows household, individual and organization in english. And there are other words everywhere that don't show italian translation.
Even trying to substitute words does not produce results, have a look here:
http://nimb.ws/rxIJQe
Does anyone know if there's a way to overcome this issue?


texts: Manual Contributions Showing up as 0 Against Contact

texts:
When I add in a manual contribution against a contact and specify an amount - when submitting, the amount gets registered as 0 which is not what was input initially. In the database it is seen as 0 also.

The warnings/errors that comes up are:

Warning: key() expects parameter 1 to be array, null given in CRM_Contribute_Form_Contribution->submit() (line 1461 of /home/xxx/www/www/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution.php).
Warning: key() expects parameter 1 to be array, null given in CRM_Contribute_Form_Contribution->submit() (line 1462 of /home/xxx/www/www/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution.php).
Notice: Undefined index: html_type in CRM_Price_BAO_PriceSet::processAmount() (line 718 of /home/xxxx/www/www/sites/all/modules/civicrm/CRM/Price/BAO/PriceSet.php).

and the error in the log is:

TYPE    php
DATE    Thursday, May 25, 2017 - 20:26
USER    admin
LOCATION    civicrm/contribute/add
REFERRER    civicrm/contribute/add?reset=1&action=add&context=standalone
MESSAGE Notice: Undefined index: html_type in CRM_Price_BAO_PriceSet::processAmount() (line 718 of /home/xxxx/www/www/sites/all/modules/civicrm/CRM/Price/BAO/PriceSet.php).
SEVERITY    notice
HOSTNAME    xxx.xxx
OPERATIONS

This site was upgraded from previous versions to CiviCRM version 4.7.19 and there were some problems with the old database. There was an " Invalid Price Fields " message with regards to the 'Contribution Amount' price set which we couldn't fix, so we just hid that message.

Any help would be much appreciated.

Edit 1:
Just to note, however, that adding by selecting a price set works. Its just the manual input for amount.

Edit 2: just to let you know that some price fields were disabled so I enabled them and it all worked!


texts: How to split Member Contribution page transactions to multiple financial types?

texts:
On our Member Contribution Page, we have a price set with two fields.
1. Membership Choice - financial type 'Membership'
2. Donation Amount - financial type 'Donations'

Users pay, but the result is one contribution entered on the contacts record with the 'Membership' contribution type only (it appears).

Is there a way to get the donation to be recorded separately, or at least as its own financial type.

Larger question - best way to have Member Join/Renews and Donations on the same page, yet keep the books straight. Thanks!


texts: How do I find a patch for an issue in CiviCRM's issue tracker (JIRA)?

texts:
For example, issue CRM-17493 shows that it is fixed in 4.6.11.

How do I find the patch to fix this specific issue from JIRA?


texts: Upgraded to 5.3.2 from 5.3.1, now warning Cron not running - log shows it is at 10 minute intervals - Ignore?

texts:
Running on Wordpress 4.8.7. No problem with Cron on 5.3.1, but right after upgrading we're getting warning that cron is not running.
    "Cron Not Running-
Last cron run at July 28th, 2018 3:20 PM."

Here is crontab entry, sanitized:

*/10    *   *   *   *   /usr/local/bin/php /home2/xxxxxx/newarksymphony.org/wp-content/plugins/civicrm/civicrm/bin/cli.php -s www.newarksymphony.org -u xxxxxx -p xxxxxxxxx -e Job -a execute

Scheduled jobs log shows that jobs are indeed running every 10 minutes.

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

2018-07-29 15:40:02 Civirules cron
Entity: Civirules Action: Cron

Summary
Starting execution of Civirules cron
Details
Parameters parsed (and passed to API method):
a:1:{s:7:"version";i:3;}
Full message:

Starting execution of Civirules cron

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

2018-07-29 15:30:02 Civirules cron
Entity: Civirules Action: Cron

Summary
Finished execution of Civirules cron with result: Success (a:0:{})
Details
Parameters parsed (and passed to API method):
a:1:{s:7:"version";i:3;}
Full message:

Finished execution of Civirules cron with result: Success (a:0:{})

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


texts: How to effectively manage projects and their contacts within CiviCRM?

texts:
Good morning,

in our organisation, we frequently have to deal with the following scenario, a practical solution to which with CiviCRM I have so far not been able to establish. I would greatly appreciate insights on how to do this:

Scenario: Our organisation has a large number of diverse contacts from journalists to banks to volunteers. A selection of these regularly needs to be contacted within the scope of a project running for, say, 6 months. The contacts are made individually, not through mass mailings, and contact progress needs to be recorded individually, too. The relevant co-worker needs to be able to pull up a complete list of contacts pertaining to a certain project, quickly grasp the status of each contact and act on new opportunities, challenges, or delays.

Now, I have tried to use CiviCampaign to pull individual selections of contacts out of our overall pool. However, as I cannot track individual contact progress in CiviCampaign (but only mass mailings) this does not seem practical.

I have further tried to separate contact groups by "Groups" or tags and then tried to use a report to get an overview of these. However, as reports are not meant to be interactive, I cannot jump into a contact, work on it and return to the overview in the report easily.

Can somebody advise if this is practically feasible without additional programming?

Thanks!
Bijan


texts: Not seeing engagement index option when adding activities

texts:
I'm not seeing an option to set engagement index when trying to add activities?
Do I need to enable it somewhere first?


texts: Creating a custom (select) field and update option values from php

texts:
I use Wordpress with CiviCRM. I would like to create a custom select field and populate the option values with php.
After investigating the forum and the documentation I think I should create a hook (or a plugin in wordpress) for that, but not sure.

Could somebody show me a working example or direct me where to continue?


texts: I am trying to hide the address field from the directory view displayed when clicking on one of the little icons on the map.


texts: CiviRules Trigger:Contribution is Added not working for Online Payments

texts:
I've created several rules that assign a contact subtype to contacts depending on their level of donation.

The trigger I am using is "Contribution is added".

The rules function correctly if a contribution is added via the backend, but not when people make online payments through a donation page.

Is there a setting that would affect this? Is there a way to set up rules that will trigger by online payments?


texts: Create buttons on action from ResultTasks

texts: I´m trying create buttons in ResultTasks.tpl for "show on map" and "export". This actions are in dropdown list with select named "task". I first tried duplicate the select, but it worked only last select, the first select redirect only to print page. Is possible to make separate buttons for these actions?


texts: Can I find the target contact ID in hook_civicrm_buildForm?

texts:
Summary

Is it possible to extract the target contact ID of a form during hook_civicrm_buildForm?

Details

We are trying to manipulate a wide range of fields across the site, ones that might be present in event registration forms, contact profile forms, etc.

We want to disable editing of the field if there is a value in it, and the contact has a certain value on their record.

The workflow we have in mind is...

Is 'Field A' on the form?
If yes, does 'Field A' have a value already?
If yes, is there a 'target contact' for the form (ie: a logged in user is registering for an event, or updating their profile)
If yes, fire an API call to get the value of 'Field X' from the record of the target contact.
If 'Field X' is 'Yes' then disable editing of 'Field A' on the form.

We understand that not all forms will have a target contact ID, and we would only want to go through this logic if there was one. So it wouldn't do any of this if an anonymous user was signing up to an event; but would if a logged-in user was.

The logic itself isn't the problem, but we can't seem to find the target contact ID stored anywhere at this point.

Thanks in advance!


texts:
Under How to Transfer Big Data to a Different Domain, I asked a question about transferring data to a different domain, but I couldn't find a solution. Before writing a comment, please read the information I have provided here. So I tried to implement my own solution. However, according to my mistake, my own solution steps did not work.

Namely;

I installed a joomla and CiviCRM from scratch. I didn't make any customization and updates in my installation.

Then I threw the following tables and all log tables into new SQL. I have not encountered any errors in this transfer. (I transferred by typing _bacup next to the existing table names to avoid conflicts.)

civicrm_activity
civicrm_activity
civicrm_activity_contact
civicrm_contact
civicrm_custom_field
civicrm_custom_group
civicrm_email
civicrm_log
civicrm_option_group
civicrm_option_value
civicrm_phone
civicrm_setting
civicrm_uf_match
joomla_usergroups
joomla_users
joomla_user_usergroup_map

Now when I try to log in to CiviCRM I get an error like the following. Do you know about the solution to this error?

CiviCRM_API3_Exception: "DB Error: constraint violation"


texts:
Keep getting message

  Template not found. Could not find the report template. Make sure the report template is registered and/or url is correct.

I followed a guide in setting up a custom report. I created a new custom PHP path and a custom template path. Within both of those the guide said to recreate the path of the original report. ie: /CRM/Report/Form/Contact/then the .tpl placed in there. The path for custom PHP was also the same with the report PHP placed in there.

In the guide it said copy the existing tpl file (in this case it was called Relationships) and then edit it to include the following line:

 *}
{include file="CRM/Report/Form.tpl"}

It then said save it as the new file name. In this case ResidentialCommunities.tpl and refreshed

I then registered the report in Administer>Civireport> Register Report

In the settings under Url it shows /Contact/ResidentialCommunities
Under Class it shows CRM_Report_Form_Contact_ResidentialCommunities

It registers. Then when going to Contact and Contact Reports then add new report it shows under Contact Reports the clickable link to my custom report. Then I click it and it throws the error. I'm certain that there is an issue with the Url field, but can't see why.


texts: How to interpret "context" field in civicrm_system_log

texts:
We use Authorize.net for payment processing.  Recurring donations have stopped being recorded in CiviCRM, although they are still being processed by Authorize.  The "context" field in civicrm for the failing transactions says:
{"IDS_request_uri":"/civicrm/payment/ipn/3"}

Can someone tell me what this means?

Any other hints for me to troubleshoot why ARB transactions suddenly stopped getting recorded in CiviCRM?

Thanks so much!


texts: Civisualize seems to be reporting on most things, however the Gender report shows a green circle with 99% but no breakdown of gender even though we have male and female members. Any ideas?


texts: Is there a way to bulk delete contacts? I don't see a way out of the box of civicrm to select contacts individually form a report or search result, the way that views bulk operations does in drupal (with the checkboxes in front of contacts.


texts: WP "Call to Action" plugin causes JS errors

texts:
I found that I am getting js errors when I have the Call to Action wordpress plugin enabled.
My hunch is that it is because CTA also includes Select2 but I did not test this. The error in particular I was looking at was $.fn.select2.defaults is not defined. (everything before "defaults" is defined). At least when in Common.js. In the console it appears to be defined.

I did not find CTA on the incompatible plugin list.
http://wiki.civicrm.org/confluence/display/CRMDOC/WordPress+plugins+incompatible+with+CiviCRM

Does it need to be added? is there a known work-around?
Can someone point me to a model for resolving this conflict?

civicrm 4.5.8
WP 4.2.2
CTA 2.3.6


texts: What is "Error: Could not find valid value for u"

texts:
Since I upgraded from 5.24.4 to CiviCRM 5.28.2, roughly since end of August 2020, I have been finding a lot of errors in the log when Anonymous users attempt to access mysite.com/civicrm/mailing/url.

If I go to this URL myself (as an admin) I get the CiviCRM error box with the message "Error: Could not find valid value for u".
If I go there as Anonymous I get the same error message on a blank white screen.
On 5.24.4 Anonymous gets 'Access Denied' which is sensible, and Admin gets a list of current mailings.

What should this URL do?
Presumably 5.28.2 has introduced a bug?


texts: What is the best way to record in-kind contributions?

texts:
I am working with an organisation that would like to record in-kind contributions and pro bono support.  These are gifts that they receive from other organisations in the form of services or support rather than cash.

They would like to record these contributions so that they can report on the value to the organisation - e.g. 'in the last year we have received £10,000 of in-kind support'.

What is the best way of recording this in CiviCRM?  Should they just create another financial type for this?  Will this cause any problems as it isn't actually money?


texts: Invalid currency "$" when sending confirmation and receipt

texts:
Running CiviCRM 5.22.0 with WordPress 5.3.2

Whenever a user attempts to create a membership AND record membership payment AND send confirmation and receipt, an Invalid currency "$" error is generated. The membership and contribution are recorded in the database, but no e-mail is generated. CiviMail is working in all other contexts.

If a user creates a membership AND records membership payment but does NOT check "Send Confirmation and Receipt?," the transaction completes without error. Editing the membership and selecting "Send Confirmation and Receipt?" will generate the invalid currency error.

I enabled debugging and backtrace and the error displayed with the exception trace is:

CRM_Core_Exception: Invalid currency "$" in <docroot>/wp-content/plugins/civicrm/civicrm/CRM/Core/Smarty/plugins/modifier.crmMoney.php on line 35

Any thoughts?


texts: How best to integrate CiviCRM into our WordPress website

texts:
Our website uses WordPress but the developers are having issues integrating CiviCRM.

Should we go elsewhere? We want integration with our website but can we do this hosting CiviCRM outside of the website?


texts: Civimail tracked links seem to be broken in 4.6.8

texts:
Links within both old (prior to update to 4.6.8) and new promo emails are not working at all.
Resulting in something like this:
The requested page "/sites/all/modules/civicrm/extern/url.php?u=2698&qid=78621" could not be found.

(Also, when I view the mailing in a browser there is no qid at all, but I assume that the qid is the recipient and the u is the URI?)


texts: Thank-you letters sends email immediately

texts:
we are emailing the receipts of last year's contributions. From "find contributions" we select "Thank-you letters - print or email" and then "Send emails where possible. Generate printable PDFs for contacts who cannot receive email.".
I thought it was using the CiviMail component to send (and its configurations, like Mailer Batch Limit, Mailer Throttle Time), but emails are sent immediately, occupying a lot of memory resources. And my SMTP server rejects them as spam.
Have I forgotten a configuration? Or is it the behaviour for this process?
Or is there another way to send receipts of last year's contributions?
Or should I use SparkPost which distributes the email delivery?
Any help is appreciated.


texts: How is membership type best set up for monthly direct debit payments?

texts:
An organization has some members paying their fees annually by cash and therefore need reminders. There are three membership levels - Under 16, Over 65, and others. It's quite straightforward to set CiviCRM's membership types for this.

Other members pay by monthly direct debit, which means they continue to be members until they take action to cancel the direct debit. Bearing in mind they also are categorised by the same three levels - under 16, over 65, others - how should membership type be set up for these members?


texts:
Is it possible to integrate CiviCRM with Campaign Monitor so as to combine the advantages of both platforms and share information between them?

Thank you!


texts: Contribution page with cookies blocked just reloads on submission - is this expected behaviour?

texts:
We recently had a donor call our office who was having trouble donating online (https://secure.wildsight.ca/civicrm/contribute/transact?reset=1&id=1).

It turned out they had blocked cookies in general and when trying to use the contribution page, the site just reloaded blank after submission (nothing was processed). We are not using a confirmation page.

Is this the expected behaviour? Should users be able to make a contribution without cookies? Should they receive an error message that tells them to enable cookies?

5.19.4 on Drupal 7.69


texts: Can I allow users to update their registration?

texts:
I have a non-profit that runs an event once a month where the users leave their cars at home to walk, bike, or ride public transit for their daily commute. I'm testing the online registration function of CiviCRM to allow them to record their transit method and mileage for that day, but they need to be able to update the record in case their method changes. For example, if they said they were going to ride a bike but instead took the subway because of rain.

If they attempt to register twice they'll get the message that they're already registered. If I allow multiple participants, they can record a new route but they show up as multiple entries with the same name (obviously).

I can't seem to find a configuration setting to allow registration updates. Am I missing something?


texts: CiviCRM 5.13.1 is not showing "Added By" coumn value

texts:
I upgraded site Drupal 7.66 + CiviCRM with latest version 5.13.1 and found out that if you go to any user profile and click on Activities tab then you can see there is "n/a" in "Added by" Column.

But when I click on "View" activity link then I can able to see "Added by" value.

It was working with last version 5.10.4, I think this is bug in CiviCRM latest version.
Any help is really appreciate.

Created issue civicrm lab
https://lab.civicrm.org/dev/core/issues/951


texts: I have created a custom field but only admin users can see it

texts: Have created an inline custom field. Only admin staff can see it. All users should be able to see the view.


texts: Event with multiple days - multiple choices

texts:
I can't seem to find exactly what I need. So here it goes. We are having our annual meeting, but this year there are essentially 3 events that people can choose to go to and I will need name tags for each of the events.

Event 1 Tour is at a distillery and can only have 20 people cost is $10.
Event 2 Dinner is at a Farm and can only have 40 people cost is $30.
Event 3 is the next day and can have 125 to 150 people and costs $35.

I would like the person registering for the annual meeting to be able to sign:

person A up for all the events
person B up for just the annual meeting
person C only for the distillery tour.

I've tried setting up event costs but it doesn't give me the place to add people's name for a name tag.

How can I set up Attendee 1 First Name - Last Name Event 1 Event 2 Event 3 - total cost.
Attendee 2 First Name - Last Name Event 2 total cost

FINAL COST - $x.xx to paypal..
Right now it is multiple logins with multiple payments to  paypal


texts: Can you use CiviMail headers and footers on System Workflow Messages?

texts:
CiviMail has an option to insert headers and footers at the top and bottom of a message (Mailings > Headers, Footers and Automated Messages). Is it possible to use these as a default for all "System Workflow Messages" Message Templates (Mailings > Message Templates).

The default templates are necessarily quite plain, and while I know you can edit each template individually, it would save time to be able to insert a common header/logo on all system templates. Changes to the header would apply to all templates at once, and future upgrade-related improvements to the message templates wouldn't require reverting and re-editing if all you had done was add the logo at the top.

If there is a way to do this, I am not familiar, so I realize this may be a feature request. If so, I'd appreciate tips on where this change would need to happen and could add it to my (ever-growing) rainy-day project list.


texts: Lookup field for parliamentary constituency

texts:
Hello I would like to have the ability to lookup the parliamentary constituency of a person when they put in the postcode. The data should return into a custom field. The data source would need to be an external database (probably sql) I am aware that there is regional lookup extension (does it work on 4.7?) and there is county lookup (can that be tweaked to lookup a different field). Does anyone have any views on this? Are there other extensions I'm not aware of?

Thank you!


texts: I am trying to test a mail out before sending. When I send test to my personal email address, it says sent but doesn't arrive. When I send test to a company email address it says sent but doesn't arrive. When I send to a gmail address, it says sent and DOES arrive! Any ideas what might be the problem? I'm on a deadline! Thanks


texts: Contact individual Summary Print page Image not showing

texts:
When in the contact individual summary page i have an image that i upload and it shows.  When i go to the action button and use print summary. On the print page the image does not show up.

I tried adding this to /sites/all/modules/civicrm/templates/CRM/Contact/Form/Taskprint.tpl

{if !empty($imageURL)}

{/if}

it does not load the image. does anyone know how to make the image load in the print summary page ?

I am using drupal and civicrm  4.6.16

EDIT

I still have not gotten this to work. I have try to add this to the Taskprint.tpl

Edit 2

Thank you so much. Print.tpl was the correct file and i was able to figure out my problem with the image now i was looking in the right place. I had to add this code to the summary.tpl for it to load.

              {crmRegion name="contact-basic-info-right"}
              {if !empty($imageURL)}

                  {include file="CRM/Contact/Page/ContactImage.tpl"}

              {/if}

              {/crmRegion}

Thanks


texts: I want to add a custom field that we use as an ID from a 3rd party. I need to ensure this value is unique as a way to prevent duplicates. What is the best way to do this?


texts: LIKE search in API for membership_type_id

texts:
Is it possible to do a membership get api request with a "LIKE" operator with wildcards for membership_type_id?
Trying this out, I get

  CiviCRM_API3_Exception: [2001: 'Something%' is not a valid option for
  field membership_type_id

Which is fair enough enough but it means that LIKE isn't supported even though it's in the api explorer's operator dropdown.

Thanks!


texts: Does anyone have a working example for CiviMail bulk emails on Wordpress and 4.7.x

texts: Do you have a CiviCRM installation with bulk email working on the latest wordpress and CiviCRM 4.7.x, using a cron job set up in cPanel? I have been unable to get cli.php or wp-cli.php to work recently. The cron job fires without error but no email is sent. Cli.php with cron was working up to about 6 months ago or so, but we made the rookie mistake of upgrading CiviCRM... We would appreciate a step by step recipe to get this working again.


texts:
I need to plan requirements for multiple instances of CiviCRM as a Drupal module.

My goal is to "more or less" know how many sites would I be able to put in a single application server (with dedicated database server) with 4 cores CPU and 16 GB memory.


texts: Can't use activity table in join query for update

texts:
In our set-up we have custom fields associated to activities, the value of which is computed periodically by scheduled job. The job executes a query that reads something like:

UPDATE civicrm_value_something sth
  JOIN (
    SELECT
      a.id, someexpression() as value
    FROM civicrm_activity a
    JOIN sometables
    WHERE somecondition
  ) r ON r.id = sth.entity_id
SET sth.somefield = r.value;

This was working fine until today when we migrated from 4.7.24 to 4.7.30, which introduces some new triggers on civicrm_activity table. The problem is that MySQL does not support executing triggers that update a table used (even just for read) in the statement that cause the trigger. So the query fails with this error:

  [nativecode=1442 ** Can't update table 'civicrm_activity' in stored function/trigger
  because it is already used by statement which invoked this stored function/trigger.]

The only solution I can see is to split the query and store the result of the sub-query in a temporary table. This is not desirable because it is less convenient, less performant (if the subquery fits in memory) and less atomic.

Has someone faced a similar problem and come up with a good solution?


texts: Can I turn off Drupal cron while the CiviCRM upgrade script is running?

texts:
I want to know if it is a bad idea to turn off cron while in the middle of upgrading the CiviCRM?

Below is my original post, but now I see that this information is irrelevant/unrelated.

I am upgrading our CiviCRM from 4.3.8 to 4.7.13. On my local dev environment, the update went basically fine, but I didn't have cron turned on. On my remote test site, which does have cron runs, the update seems to be stalled. Watchdog is showing cron errors for the last 3 hours with seemingly no progress. I suspect that Drupal's cron is trying to run and everything is being stalled because of this error, that could be caused from jumping so many versions. What I want to know is if I can open another terminal window and turn off cron until I'm done running the update script or is this a bad idea, especially since it's already running?

In case it's important, here is the cron error:

error  cron  EntityMalformedException: Missing bundle property on entity of type node. in entity_extract_ids() (line 7953 of /var/www/html/mydomain/docroot/includes/common.inc).


texts: Changing a recurring contribution with multiple line items

texts:
CiviCRM 4.7.22
WordPress 4.8.1
iATSPayments

I am not sure if this should be asked in this exchange or the iATS github.

We have a donor with a recurring donation that was $125 a month, with $50 for Line Item 1, $50 for Line Item 2, and $25 for Line Item 3. Several months ago they wanted to make it $50 for all three funds. So they went into their recurring contribution and edited it to be $150 instead of $125. Since then, it is processing it at $150 but it is not changing the Line Item Table to show $50 for each fund.

I thought that it used to just look at the previous contribution for the Line Item info. So I edited the line item table with $50 for each fund. But it continues to do the next recurring as $50, $50, $25.

I also changed the Invoice Id in the recurring table (see screenshot) to a contribution that I had edited. Thinking that it must look at that invoice id for future recurring details. But it still processes $50, $50, $25.

Any ideas where it refers to for a template to populate recurring Line Items? How can I make this work correctly from here forward?

Can I change the start date to the date of a correct donation? Does it use the first contribution as the template?


texts: Membership Name-Your-Own Price (above Minimum) on Contribution Page

texts:
How can we enable users to enter a custom amount above the minimum fee when they are creating or renewing their membership through a contribution page?

For reference, this is the membership structure we want:

Annual Member ($25/annual) auto-renew optional
[Other types] ($[x fixed] / annual) auto-renew optional
Sustaining Member ($[user-custom >= 10] / month) auto-renew required

We're having trouble with the last one - on contribution pages, the fee shown for "Sustaining Member" is fixed at $10 and there is no option for users to input their own price (e.g., a textfield).

From the CiviCRM Book, "Defining Memberships" section,

  …we have an option to encourage people pay more than the minimum for a membership if they want to.

I have found no way to enable this, even through membership price sets (we don't want to create discrete increments, e.g. $10/15/20/25/etc.), nor through integration with Drupal webforms.

EDIT:

Here's a mockeup of what we'd like the membership signup form to look like, if it helps:


texts: How can I find contacts who have multiple home email addresses when on hold?

texts: I would like to be able to easily check contacts with emails on hold designate other emails as primary, so the contacts continue receiving emails. I can make a profile to show primary and home, billing, other etc email addresses to quickly see which contacts have other email addresses. However, I can't figure out how to easily see if a contact has more than one home email address, as the search view only displays the first one. Is there any way to make this visible in a search view or even searchable?


texts: Online Membership receipt doesn't show address fields from Profiles

texts:
I have an online membership form which takes an alternate (custom location type) address in a profile. On the receipts, these fields are always empty whether the user has filled them out or not (although the address does seem to populate in their contact record with the correct location type):

Is there a trick to this, or is this a bug in the receipt template? I looked in the Message Template area and didn't see anything that was obviously awry, especially since the field names (customName) seem to show up just fine:

 {if $customPre}

    {$customPre_grouptitle}

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

      {$customName}

      {$customValue}

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

I've just updated to CiviCRM 5.8.2 to make sure it's not due to a bug that has been recently fixed.

PHP 7.0.33
CiviCRM 5.8.2
Drupal 7.60


texts: Trying to integrate Views with CiviCRM but cannot see the code

texts:
I am trying to integrate Views with CiviCRM but cannnot see the code in the CMS Datbase section to add to the settings.php file. I am stuck on step 5. Has anyone come across this issue?

The steps are here - http://wiki.civicrm.org/confluence/display/CRMDOC/Views3+Integration


texts: Is there a hook for writing a record to an export batch?

texts:
My organization uses QuickBooks Online Plus, and implemented the Classes system.  We also use Campaigns as Campaigns in CiviCRM, so all the previous solutions do not work for us.

So, we came up with a possible solution, but it would require a change to the export function.  We are thinking that we use the Financial Account name to hold both the Account Name and the Class Name.  For example, we have two Financial Accounts: Member Dues:National and Member Dues:Chapter.  The colon separates the account from the class.   But for this to work in the export, I need to get the journal entry transaction before it gets written.

We can't use the Campaigns feature for this because we do have fundraising campaigns as well as petitioning and membership campaigns.  The name seems to be our best solution, but we're not sure how to get it to work.  It's beginning to look like it would be a patch to core. ::shudder::


texts: Newsletters only display plain text, not HTML

texts:
I'm having a strange problem here: basically, whenever we send a newsletter, only the plain-text part appears. I have checked with the SMTP gateway and the emails it is sending out are the same as the ones CiviCRM is sending. Additionally, when I click the "Preview as HTML" button, a new window appears which is blank except for the text "(null)".

Nothing really has changed except I think a routine upgrade (to 4.7.29). We also emptied the templates_c directory a few weeks ago because it was over 8GB+ in size. In any case I've tried refreshing caches (using URL, dashboard button and drush methods), and loading, modifying and re-saving the newsletter template.

Additionally, I can no longer see contributions on a contact's dashboard (though the number of contributions is correctly displayed). I don't suppose that's related..?


texts: Can CiviRules add a contact to an event?

texts:
I've had a situation where we needed to offer a recurring payment possibility for an event. Hmmm... This is not at all native to CiviEvent as far as I can see. (I looked into using Webforms, as well as Repeating Events.)

The plan was to make a contribution page to create the recurring contribution subsription. So far so good! And then make a CiviRule to detect when a payment has been made as above. That's fine too.

And then use CiviRules to add the person to a specific event, preferably along with a statement in the Participant Fee Level fee.

However, it looks like CiviRules is not yet set up to registering people to Events. Is that true?

Thanks for your help.

Civi 5.24, Drupal 7.69.


texts: Can you propagate custom data in New Activity?

texts: Is there a way to propagate the "With Contacts" address and phone number into the activities assignee's copy email?


texts: Why do CiviCRM URLs have 'reset=1' in the query string?

texts:
Most CiviCRM URLs have reset=1 in the query string.

E.g. http://[yoursite.com]/civicrm?reset=1

What does this do and does it matter if you don't include it?

I only ask because URLs look nicer without it.


texts: CiviMail Change the Track Opens Tracking URL to a pretty URL

texts:
I'm using the Track Opens option in CiviMail.

In CiviCRM for Wordpress the regular mail tracking url looks something like this: https://mywebsite.co.uk/wp-content/plugins/civicrm/civicrm/extern/url.php?u=123&qid=1234

It is fine for a lot of recipients and tracking works perfectly.

However I have had reports that because the url links to a file within the Wordpress plugins directory, some systems suspect the links to be malware or spyware so the Urls are removed from the email.

Without hacking any civi files, is it possible to change the Url to something pretty like: https://mywebsite.co.uk/civimail/?u=123&qid=1234

I'm thinking it would involve the htaccess file?

Thanks


texts: How to set API ContactType parent_id NULL or how to rename label?

texts:
Attempting to write prototype initialisation code I want to rename a ContactType using the API action "create". I tried to set:

array ('parent_id' => 0)
array ('parent_id' => '')

But both error out with "Mandatory key(s) missing from params array: parent_id".
I cannot set array('parent_id' => NULL), because it would be like unsetting 'parent_id' which according to the error message cannot be missing. So the question is how do you set it NULL or how do you rename the label of a ContactType using the API?

Edited: Then I discovered that apparently you need the ID of the ContactType when you want to update with 'create', following the instruction that the API explorer gives me when I choose 'update':

  The "update" action is deprecated. Use "create" with an id instead.

So I added id as parameter and kept trying ways to set 'parent_id' correctly to NULL. I discovered that array('parent_id' => '0') is the likely way to do that, because it returned a different error message: "already exists". Well yes, I knew that. My intention was to update the label with 'create" according apparently a wrong instruction. Or is this a bug?


texts: Automatically filling custom fields with data

texts:
Is there a way to automatically populate a custom field with data from other parts of Civi?
My use case is simple.  We have an arts organization that uses relationships to link "partners" together.  The problem is that this information is not always easy to see and requires many clicks to identify the details.
I would like to create an individual contact custom field that shows the "partners" name for each of the individuals that are linked by a household.
Example:

Leslie and Shawn each have individual contact records so when I
access Leslie's record I would like to see that there is a
relationship with Shawn.

It would also be great to see a household donation total in both
records.

Any input would be greatly appreciated.


texts:
Sometimes I have more than 100% successful deliveries in the mailings. For a 2700 intended recipients I can have 4800 successful deliveries. I wonder why this happens!

This group contains around 2700 "individual" and 2500 "organizations".

Any help? Thanks!!!


texts:
Setting up a complex event in either CiviEvent or webform

There are three time slots and 5-6 sessions/time slot. Each of those sessions would have a max participation count that when reached, the system would no longer show it as an option to pick.

Would I have to set up three different price sets and events in order to achieve the max participation rule, or is there a way using a webform that the max participation can be enforced?


texts: Is it possible to restrict view to certain case activities?

texts:
We are currently evaluating CiviCRM 5.4.1 and CiviCase on Wordpress 4.9.8

One of the requirements is to limit access to certain activity types.

In simple words, some users are not allowed to view sensitive activity types.

So far I only found:

CiviCRM: view all activities
CiviCase: access all cases and activities
CiviCase: access my cases and activities

But we need to restrict access to activity type: Payment

Any way to accomplish that?


texts: CiviMail Mail Opened report only shows one mailing in the filter

texts:
CiviCRM 4.1.5

I'm trying to customize the Mail Opened report to show a custom field. I try to select a Mailing Name from the filter but only one mailing name is listed. There are actually thousands of Mailings in the system


texts: Send metadata to stripe payment processor

texts:
I would like to send the financial type to stripe as a metadata.

The API instructions are here:
https://stripe.com/blog/adding-context-with-metadata

I just don't know where to modify Stripe extension to add this functionnality.

Thanks.


texts: How to add new membership if renewed after old membership expired (native CiviCRM / Drupal)

texts:
Consider this:

Wilma becomes a member on 1 Jan 2016, but does not renew at the end of the year.
(so throughout 2017, 2018, Wilma is not a member)
Wilma joins again in Jan 2019.

According to the documentation, CiviMember will find the original membership and change the start date to 1 Jan 2019 and the end date to 31 Dec 2019, and set the status to live (or new etc.)

This now looks like Wilma has been a member since 1 Jan 2016, but that's not the case.

Is there a way to have CiviMember create a new membership and leave old expired ones (i.e. those with "member: No" configured for their membership status) as-was?

There's a similar question that seems to be focussed on a WordPress/Caldera forms environment, but I'm asking about CiviCRM's native forms, hence the separate question.


texts: Civicrm with Nginx and Joomla - resource URLs and configuration file

texts:
Joomla 3.9.2CiviCRM 5.11.0

If I set up nginx to not protect the custom files directory, CiviCRM gives a warning that some files are downloadable. Fair enough.

But if I set up nginx to protect the custom files directory, this apparently prevents CiviCRM from reading the custom css file in the custom files directory. I assume that this is not the intended behaviour.

How can I set up nginx so that a) the custom files directory is protected and b) CiviCRM reads the custom css?

I am using the configuration setup suggested in this post, but it doesn't appear to fix the problem for me (possibly because Joomla not Drupal). Could it be that this is a problem only for Joomla CiviCRM?


texts: Limit contact access to the user's group

texts:
I'm planning a very structured situation where each volunteer must manage only some contacts without seeing others.

My question: is it possible, for each user, to limit access (view) to only contact belonging to its group?


texts: Civicrm Development (Coding) Environment Virtual Machine

texts: Is there a VM available for quickly and painlessly getting started with CiviCRM extension development (Wordpress) on Windows? Something that has buildkit installed. I just want to be able to get into learning extension development, on an existing environment that is read-to-go.


texts: CiviMail links with to many clicks from only two people

texts: In a recent CiviMail out, I had one link with 226 clicks but only 9 unique clicks. Two people made up the majority of those clicks. It hasn't happened again, just wondering if this is a recurring problem for anyone?


texts: We're trying to set up a search that includes contacts with one tag but excludes ones with another tag. Yet the "does not equal" operator does not appear to be functioning. Any ideas what the issue could be?


texts: Deadlocks on a high load of contact inserts

texts:
We use CiviCRM 5.21.2 with Drupal 7.69 and Webform together with webform_civicrm to provide petitions. The petitions ask for address and email. So every petition signature creates a contact with email and address. Additionally every contact gets a tag and if the email is confirmed with webform_confirm_email in some cases a group.

If the load on this webform submission gets higher we face deadlocks. Some of them seem to connected to group cache and acl cache and some to email or address inserts.

I saw that the tables email and address have triggers defined for insert, update and delete that write into the table contact. For example:

UPDATE civicrm_contact SET modified_date = CURRENT_TIMESTAMP WHERE id = NEW.contact_id;

Is it possible that these triggers have something to do with at least some of the deadlocks. Or that they at least make the chance higher to run into a deadlock?

Does anybody know, why they are there? Is it necessary to update the modified_date in the table contact immediately or would it be sufficient for the system if this is done by a cron job that runs once per day?


texts: CiviRules "Fatal Error" (4.6.22, WordPress)

texts:
We'd like to use and contribute to community development of CiviRules.

However, after install, we cannot get a simple test rule working. For example:

Trigger: "When Contact of Any Type is Added"
Action: "Add contact to group called [mailing list]"
Delay: [none]

Is yielding no results.

One thing we have noticed is the following error message is delivered via CRON immediately after install of CiviRules and even before any rules are created:

Fatal error:  Can't use method return value in write context in /..../org.civicoop.civirules/CRM/Civirules/Engine.php on line 282

Code at and near Line 282 mentions CRON although we did not make a CRON-triggered rule. Despite this, we're wondering if this error might explain why the simple rule did not work.

Can anyone point us to what this error may mean?

P.S. We can stop the error by disabling the scheduled jobs that are created on installation of CiviRules, but we're wondering if this error may be a hint as to why non-CRON triggers are not working.

Thanks.


texts: Check availability does nothing when clicked

texts:
CiviCRM 4.6.4 and WP4.2.2
I have a profile with 'Account creation required' checked and the profile displays the Username field OK but the 'Check Availability' function does not work.  It gives no error message, nothing.
Thoughts?


texts: can't access "Joomla Access Controls" after upgrade from 4.2.19 to 4.7.25

texts:
I've just gone through a long incremental upgrade process from CiviCRM 4.2.19 to 4.7.25. Thought everything was working well until I discovered non-admin users were getting permission denied errors, so I tried to check the ACL settings -- and I can't access the Joomla Access Control settings.

When I go to "Administer->Users and Permissions->Permissions (Access Control)" and click "Joomla Access Control", the popup window shows

"500 - An error has occurred. JHtml: :bootstrap not supported. File not found."

Error logs aren't helpful -- nothing in PHP or CiviCRM logs, and Apache error just reports that the request for "/administrator/index.php?option=com_config&view=component&component=com_civicrm&tmpl=component" has returned a 500.

Help appreciated!

System details:

Joomla 2.5.28 (yes I know it needs upgrading, that's happening as
part of this whole site upgrade!)
CiviCRM 4.7.25
PHP 5.6


texts: CRM API shows only the first char of the result?

texts:
I'm absolutely embarrassed. I try to get value as it in this thread (and sorry for the wrong use of the topic).

I try get a custom value via CRM API. With the API Explorer I can create the expression:

{crmAPI var='result' entity='Contact' action='getvalue' sequential=0 return="custom_13" id=$contactId}
{foreach from=$result.values item=contact}
  {$contact.some_field}
{/foreach}

I can see the right result in the API Explorer. I insert it as it is into my tpl file, and I get back only the first character of the result.

What do I wrong?