texts: Update contact via REST and JSON request body

texts:
We are trying to update a contact via REST API. But instead of submitting the changed values as seperate post parameters (e.g. "nick_name")

http://d46.demo.civicrm.org/sites/all/modules/civicrm/extern/rest.php?api_key=myscretapikey&key=sitekey&json=1&version=3&contact_id=2&entity=Contact&action=create&nick_name=Kathy

we want to submit the whole contact JSON object with its changed values as part of the request body:

POST http://d46.demo.civicrm.org/sites/all/modules/civicrm/extern/rest.php?api_key=myscretapikey&key=sitekey&json=1&version=3&contact_id=2&entity=Contact&action=create
Content-Type: application/json
{ "id":"2", "contact_type":"Individual", "contact_sub_type":"", "do_not_email":"0", "do_not_phone":"0", "do_not_mail":"0", "do_not_sms":"0", "do_not_trade":"0", "is_opt_out":"0", "legal_identifier":"", "external_identifier":"", "sort_name":"Adams, Kathleen", "display_name":"Kathleen Adams", "nick_name":"Kathy", "legal_name":"", "image_URL":"", "preferred_communication_method":["3"], "preferred_language":"", "preferred_mail_format":"Both", "hash":"163700750", "api_key":"", "first_name":"Kathleen", "middle_name":"", "last_name":"Adams", "prefix_id":"", "suffix_id":"", "formal_title":"", "communication_style_id":"", "email_greeting_id":"1", "email_greeting_custom":"", "email_greeting_display":"Dear Kathleen", "postal_greeting_id":"1", "postal_greeting_custom":"", "postal_greeting_display":"Dear Kathleen", "addressee_id":"1", "addressee_custom":"", "addressee_display":"Kathleen Adams", "job_title":"", "gender_id":"1", "birth_date":"1979-03-17", "is_deceased":"0", "deceased_date":"", "household_name":"", "primary_contact_id":"", "organization_name":"", "sic_code":"", "user_unique_id":"", "created_date":"", "modified_date":"2015-05-14 06:03:56"}

Mostly this seems to work but we have some issues. Is this an official way to update a contact? And if not, which would be a better one?


texts: Is there a recommended way to customise the quicksearch?

texts:
I'm trying to customise the top-left quicksearch box so that it recognises some of our internal codes without selecting a specific option in the dropdown.

I used to adapt xavier's great Quick Contact Autocomplete extension, but this uses the crmAutocomplete action which I think went away in 4.5.

Is there a particular recommended way of doing this in 4.5+?


texts: Invoices are sent from the host domain instead of the proper From Address

texts:
A constituent pointed out that she received an emailed invoice from "[4-digit-number]@[host-domain]" rather than from our normal organization email address. (We use CiviHosting's shared server.)

I haven't made any changes to the Civi settings, and upon checking, the default From Email Address is set to "office@[our-domain]" as expected and the mailer is set to "mail()".

Other emails are sent as expected:

individual emails
bulk email
automatic receipts for online contributions
automatic registration confirmations for events

I have discovered that when a back-end user triggers "Send Invoice" for a contribution, if one of that user's email addresses is chosen as From Address to use, it is ignored and the host-server address is used. If, however, one of the CiviMail-configured From Addresses is used, it is sent properly.

I just became aware of this last week, and I have a copy of an invoice sent a few weeks before that with the correct From address, so something happened within that window of time to cause a change.

civi 5.9.0, joomla 3.9.5


texts: What is the Drupal 8 Webform url for autofill CiviMail linkage

texts:
In D7 Webform Civicrm integration, under Additional Options for Civi configuration there is this link
To have this form auto-filled for anonymous users, enable the "Existing Contact" field for Contact 1 and send the following link from CiviMail:
https://site.nubay.net/sample-webform?cid1={contact.contact_id}&{contact.checksum}
I do not see the equivalent link for D8 Webforms.   Would it be the same link?   Should it be in the additional options section?


texts: How to delete an address, phone, email, or website in a profile?

texts:
I've created a CiviCRM profile with address fields, and with email, phone, and website fields, and configured this profile for use in the Drupal Account Edit screen.  Some users may want to delete these fields from their profile, but this doesn't seem to be possible. When the user deletes the values of all the address fields, and/or deletes the phone, email, or website form values, and saves the form, the existing field values remain untouched.

As a very poor workaround, the user can enter a bogus value like '-' for the phone number, or for address fields, but email and website require valid formats, so even this poor workaround fails for those fields.

Is there a way to allow deleting on these entities in a profile?


texts: Runtime Exception Booted CiviCRM, but failed to find 'api/class.api.php'

texts:
I created an extension module with civix then cd'd to the module directory and tried to create a custom report based on a copy of an existing report. I used the following command:

$ civix generate:report --copy CRM_Report_Form_Case_Summary DemandCaseReport CiviCase

This generates an error message that I haven't yet been able to fix.

Initialize report CRM_Case_Form_Report_DemandCaseReport

[RuntimeException]
Booted CiviCRM, but failed to find 'api/class.api.php'

generate:report [--webPath [WEBPATH]] [--copy [COPY]] [--] <<ClassName>> <<CiviComponent>>

I'm using civix version v16.03.2-3-geeff5c0. It's a WordPress installation.

I can see that a file with that name resides in /wp-content/plugins/civicrm/civicrm/api/class.api.php

Is there an environment variable that I should be setting or something else that I'm overlooking?

Grateful for any tips, thanks.


texts: Why is inbound email activity uneditable in case activity list?

texts:
If I send an email to the configured inbound email address it correctly creates an activity. I can see the activity in the activities list on my own contact and on the contact connected with the inbound email address. I can open the activity using "view" and then I can click "edit" and make changes.

However if I then used "file on case" to add the activity to a case, and I open up the case and access the activity from there, there is no edit button.

I am an administrator will all permissions ticked.

Is this expected behaviour, a bug or a misconfiguration?

Edits: Added screenshots

Activities tab of contact
Activity open with edit button
After clicking edit button


texts: CiviCRM BuildKit install fails on Ubuntu 18.04.1 LTS

texts: Running the BuildKit installer script on Ubuntu 18.04.1 LTS doesn't work - it fails trying to resolve the conflict between the openssl libraries used by Ubuntu's NodeJS/NPM packages and the libssl-dev package.


texts: How can I show a list of events with summaries and either a register link or message saying they are full?

texts:
We are collecting registrations for a conference and have a number of optional workshops on one of the afternoons. I want to create a summary page of available workshops for participants with a link to register or a message if the workshop is full.

Using Drupal 7 as CMS.


texts: How to search active relationships (e.g) during past year?

texts:
We record volunteer relationships for our Volunteer contacts.

A contact is an active Volunteer of our organization if exists a relationship "volunteer for" and this relationship has no an "end date".

In the same way, a contact is an inactive Volunteer of our organization if  exists a relationship "volunteer for" and this relationship has a past "start date" and a past "end date".

The difficulty is when you want to get a list of all the volunteers that were active during for example the past year.

How can I obtain a list of these contacts? There is no current built in search to achieve it? We must develop a customized search?


texts: How can I specify which location type address to use for a proximity search

texts:
I collect both home and work address data for contacts. I assume - although I've not yet tested it - that the default location type is used when a proximity search is carried out.

I have work address set as my default, but want to do a proximity search based on home address.

Anyone know if this can be done, and if so how?


texts: Is CiviCRM a 'master database' / 'master system'?

texts:
The membership organisation I work for currently has serious issues with it's membership databases. That information is currently split between a wordpress user database with an extension s2pro which extends that, mailchimp, paypal, and an accounts package KashFlow.

Those all have various relations with each other but somehow seem to conflict and don't work properly - resulting in the system unsubscribing people from mailchimp, and various other problems with data not matching up.

My manager thinks that what we need to sort this out is a new 'master database' for the membership information which would communicate directly with all the other software packages and be an authoritative place for the data, rather than them all talking to each other and conflicting.

I'm wondering, would CiviCRM be able to serve as that master system?
Thanks.


texts: Scheduled Job not executing with wp-cli under cron, but works manually

texts:
This wp-cli command executes fine from the command line, but not when run as a cron job.

/var/sites/d/mydomain/wp-cli --user=admin --url=https://mydomain/wordpress --path=/var/sites/d/mydomain/public_html/wordpress/ civicrm api job.execute auth=0

Any idea where I could start to diagnose this? I have checked the Civi logs in ConfigAndLog, nothing there. I have set php.ini as below

log_errors = On
log_errors_max_len = 1024
error_log = /var/sites/d/mydomain/logs/php_error.log

But nothing in that log either.


texts: alter/remove specific popup notifications

texts:
What's the best way to alter or remove specific popup notification messages? I have a situation where the duplicate membership warning when creating a membership from the backend is not relevant for a client, and would like to suppress the warning so as not to confuse users or clutter the interface.

I've played with CRM_Core_Session::getStatus() but it doesn't appear to be aware of this notification (likely because it's triggered via the tpl file rather than PHP).


texts: How can I tell if the logged in user has a certain permission?

texts:
How can I tell if the currently logged-in user has a certain permission in CiviCRM?

Should I use CMS-dependent functions, like user_access('permission') in Drupal, or can I use one CiviCRM function to check the permission for the current user?

For example, how could I display a message if the currently logged-in user has the 'edit all contacts' permission?


texts: API v3 Include Some Tags and Exclude Others

texts:
I can do a custom search on Contacts to include those with a list of tags, and exclude those that also have an additional tag. And I get the results I expect.

I can't for the life of me figure out how to do this with the API, though. The API Explorer won't allow me to add 'tags' as a parameter twice, so I can't figure out how to do the construction.

For example, I want to match all contacts that have tag ID 12, but exclude those that also have tag ID 7.

Something like
'tag' => ['IN' => $tags_included, 'NOT IN' => $tags_excluded]


texts: Clear data from supplemental address on update

texts: When I import cleaned postal data and the supplemental address information has moved to the first line of the address, the supplemental address data does not clear, even if I put a space in the field. This results in addresses with errors that don't CASS the next time. How can I do an import and set that field to NULL?


texts: Which payment processor offers line item capability?

texts:
We have a membership sign up that has membership fee and a contribution amount. We have enabled the contribution section.

  Contribution Amounts section enabled

Using PayPal standard, only one amount is returned for the transaction. Which processor will offer multiple line items returned? We need the membership fee and donation returned to civicrm as separate amounts. The treasurer needs to send the money to different recipients. Is there another way to handle this?


texts: Problems adding Contribution form to a WP page

texts: I just created a new contribution page in Civi and made sure it was active. When I go to create a new wordpress page and try to insert it I have no options to choose from when I click on the CiviCRM button. The only thing it shows is the dashboard options. How do I get my Civi Contribution form into a wordpress page? Is there some sort of a setting I am missing to get active contribution pages to show up as an option to choose from?


texts: CiviCRM 4.7 with WordPress 4.8 : DB Constraint Violation - contact_id should possibly be marked as mandatory for DashboardContact,create API

texts: This is on a completely fresh install of CiviCRM. I tried running the upgrade, but the message said I was already upgraded to the latest. Any idea how to fix this?


texts: How remove fields from default price set

texts: I have a membership signup/renewal page that also allows for additional contributions using the standard fee table (no price sets).  Since upgrading to 4.7.23 the online membership page is showing previously deleted options from the additional contribution fee table.  How can I remove these (my understanding is they are stored in a default price set)?


texts: Use the API to loop through contacts and copy field value

texts:
Been playing with the API and see how to query for a result set but not the appropriate way to get a result set and update it batch style(over 4000 contacts in this case).

My goal is to gather all contacts with an empty custom field value and copy the text value for 'current employer' into that field.

This is in php using the 'class.api.php'. If there is a more appropriate way to achieve this I am open to suggestions.


texts:
I work with CiviCRM 4.6 and Drupal 4.7
When I create an activity in CiviCRM, a iCal file is also created and sent. But in this iCal file, Start time = End time. So when I import the file in my calendar the activity doesn't have the right duration. Any idea ? Maybe I can modify a template, but how ?
Regards,
Hashkey


texts: Running 2 civicrm instances on 1 database

texts: I have one mySQL database and one Apache webserver. Can I still run 2 separate wordpress/Civicrm environments (like staging and production)?


texts: Not receiving email from Scheduled Reminder for Activity

texts:
I am attempting to set up a Scheduled Reminder for Scheduled Activities (CiviCRM 5.20.2/Drupal 7).
I have a Scheduled Reminder set up as follows:

This is setup to send to the Activity Assignees, 0 hours before a Scheduled Phone Call activity. It is enabled, and has a simple email message.

Under Scheduled Jobs, I can see that "Send Scheduled Reminders" (Job.send_reminder) is enabled, is running always, and the logs say it is successful.

If I then create an Activity of type Phone Call, set its status to Scheduled, set the time to 30min in the future, and assign it to myself, I will immediately get a system generated Activity Summary email. In 30min time I will not get a reminder from the Scheduled Reminder, with the template I defined.

Can anyone tell me why, or tell me where to look for more information? Are there logs which will show me if the reminder is actually being triggered, or if an attempt is made to send the email?


texts:
This one may have an obvious answer, but I just cant seem to find a simple solution.
Running Wordpress 4.2.2 CiviCRM 4.6.3

In a nutshell We want to use CiviCase to coordinate Event management. The Events will be using CiviEvent to deal with venue and participant sign ups etc.

So the Case will be auto assigned to an Event Manager (case coordinator), and also their boss (case supervisor), the Event Manager will go through the steps of the case, such as getting quotes for venue, then tick off from supervisor, then A/V system etc, then any talent issues, then setting up promo etc etc.

So What i want to do is work out a simple way to connect the Case to the particular CiviEvent that will already have been created - so you can easily say click through to the Event from the case..

An obvious way would be to Make the CiviEvent the equivalent of the client, meaning the Case coordinator, and supervisor end up with a role / relationship with the target which is a CiviEvent instead of an individual client - but the case set up does not quite work like that, and it seems case relationships cant be with Events only contact types.

At the most basic it could just be a link in custom field I guess?

But this leaves the problem - who or what should be the client when setting up a new case? Perhaps a dummy Contact could fill this role..

As I said maybe I am just missing a simple solution here, any help appreciated..


texts:
When using Mosaico to build an email, I'm never seeing images in the editor - they display when sending tests or real emails, and when previewing the email, but in the editor they appear as a small blue square with a question mark. Has anyone encountered similar, and found a solution?
We're running CiviCRM 5.27.2 in Wordpress.
Update: some more info was requested in the comments. We're running Mosaico 2.4.1592820024 and this is all a recent install. When I check the "network" tab in developers there are indeed two 403 errors which come up when I launch the Mosaico editor, one I think for the image I'm trying to include, and one to wss://public-api.wordpress.com - I can't obviously identify any problems with the Resource URL settings, but guessing that's where the problem/solution lies! Any help is much appreciated :)
Thanks.


texts:
I am struggling to find the answer to why my default mailing header / footer are not being attached to user-driven driven message, specifically member renewal notifications. I get the email body just fine and the tokens are working, just not either the header or footer.

CiviCRM 5.20.2 on Wordpress 5.3


texts: ACL role assignments not showing on screen, but still working

texts:
When I go to civicrm/acl/entityrole it shows no role assignments and says "There are no Role Assignments. You can add one now."

But they exist, have not been deleted and are still working. I can see them in the database table (select * from civicrm_acl_entity_role;)

Anyone else have this problem? It looks like a bug


texts: When sending SMS messages - contacts must have mobile phone set as primary

texts:
Is there a reason for this restriction or is this a bug or a new feature request to have it changed?

I expect SMS messages to be sent to a contact if at least one of their phone numbers is marked as a mobile phone number, even if it is not their primary phone. I suppose it might be confusing if they had more than one mobile number, but picking the first of several mobile numbers would seem preferable to simply not sending a message if no mobile number is picked.

Also - this restriction seems limited to sending SMS as an activity. I can still send a Mass SMS to contacts even if their primary number is not a mobile number.


texts: Views : SQLSTATE[42S02]: Base table or view not found (concerning a Custom Value Table)

texts:
I want to create a View based upon civi_participants, including Participant Custom Fields.

I can Add the custom fields, but I get the following message :

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bapaparoisse_drup_275.dr_civicrm_value_infos_parents_participants_11' doesn't exist

... and the displayed view is empty.

(Running Civi 4.7.16 / Drupal 7.54 / Views 3.16)


texts: How do I get the External ID to appear in my contacts through Webform?

texts: On the CiviCRM Webform Integration, I setup the External ID to appear as a textfield. Once the form is submitted, the External ID is captured in Webform, but not in the CiviCRM contacts. Is this a bug or is my settings incorrect?


texts: How do you change the default status message that shows when one submits a profile form?

texts:
At the moment it says 'Thank you. Your information has been saved' after one submits a form. I can't work out where to change this.

Any ideas?


texts:
is it possible to search for two relationships at once?

Until now I search for relations like
- search
- advanced search
- relationships
- choose the desired relationships

thx.


texts: civiCase missing relationships to reports and new system category

texts:
I am getting errors about a missing case relationship to reports:
[error] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => exceptionHandler
)
[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => SELECT a.id as `id`, a.name_a_b as `name_a_b`, a.label_a_b as `label_a_b`, a.name_b_a as `name_b_a`, a.label_b_a as `label_b_a`, a.description as `description`, a.contact_type_a as `contact_type_a`, a.contact_type_b as `contact_type_b`, a.contact_sub_type_a as `contact_sub_type_a`, a.contact_sub_type_b as `contact_sub_type_b`, a.is_reserved as `is_reserved`, a.is_active as `is_active`, a_to_civicrm_value_relationship__37.display_block_on_contact_summary as `custom_157`

FROM civicrm_relationship_type a
LEFT JOIN civicrm_value_relationship__37 a_to_civicrm_value_relationship__37 ON a_to_civicrm_value_relationship__37.entity_id = a.id
[nativecode=1054 ** Unknown column 'a_to_civicrm_value_relationship__37.display_block_on_contact_summary' in 'field list']
[type] => DB_Error
[user_info] => SELECT a.id as id, a.name_a_b as name_a_b, a.label_a_b as label_a_b, a.name_b_a as name_b_a, a.label_b_a as label_b_a, a.description as description, a.contact_type_a as contact_type_a, a.contact_type_b as contact_type_b, a.contact_sub_type_a as contact_sub_type_a, a.contact_sub_type_b as contact_sub_type_b, a.is_reserved as is_reserved, a.is_active as is_active, a_to_civicrm_value_relationship__37.display_block_on_contact_summary as custom_157
FROM civicrm_relationship_type a
LEFT JOIN civicrm_value_relationship__37 a_to_civicrm_value_relationship__37 ON a_to_civicrm_value_relationship__37.entity_id = a.id
[nativecode=1054 ** Unknown column 'a_to_civicrm_value_relationship__37.display_block_on_contact_summary' in 'field list']
[to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="SELECT a.id as id, a.name_a_b as name_a_b, a.label_a_b as label_a_b, a.name_b_a as name_b_a, a.label_b_a as label_b_a, a.description as description, a.contact_type_a as contact_type_a, a.contact_type_b as contact_type_b, a.contact_sub_type_a as contact_sub_type_a, a.contact_sub_type_b as contact_sub_type_b, a.is_reserved as is_reserved, a.is_active as is_active, a_to_civicrm_value_relationship__37.display_block_on_contact_summary as custom_157
FROM civicrm_relationship_type a
LEFT JOIN civicrm_value_relationship__37 a_to_civicrm_value_relationship__37 ON a_to_civicrm_value_relationship__37.entity_id = a.id
[nativecode=1054 ** Unknown column 'a_to_civicrm_value_relationship__37.display_block_on_contact_summary' in 'field list']"]
)


texts: Entity Relationship Between Grant and Case

texts:
I'm exploring Civicrm for a client that processes emergency grants for individuals with medical, and other issues.  There is a process to fill out forms which often requires follow-up in the workflow.

For the architecture, I plan to use grants (and the grant application extension) to collect and approve grant applications (since this is designed with financial accounting in mind) but also create a case and activities to manage the application process (followup, approval, etc.).

There is a close entity relationship between the grant application and the Case.  Since civicrm does not (yet) have entity relationship or lookup custom fields, does anyone have a suggestion of how to approach this relatively simple requirement?  Basically, Grants and Cases would each have a reciprocal field to connect each other.

I'm sure the "answer" will require creating an extension (would prefer to avoid maintaining it).  I could also do this in Drupal with entities / views / rules but wondering if there are any other clever approaches.


texts: CiviRules - Configuring a rule to grant a point for each month that a contact has an active membership

texts:
We are running CiviCRM 4.7.12 on Wordpress. We have a number of donors who have an active membership. They contribute monthly towards the membership. We have CiviPoints and CiviRules installed. We want to use CiviRules for the following:

Grant 1 point to a contact for each month that the contact remains an active member (the membership status must be either new or current).
Deduct 2 points for each month that the contact remains inactive (due to cancellation or lapse in payment)

How can we setup CiviRules to perform 1 and 2 above?


texts: Change Member Listing Layout in Worpress

texts:
I was wondering what the best approach would be to change the layout of a member listing.
I'm using wordpress, and have inherited the maintenance of this association website - and believe civiCRM could really help with their internal processes, but a key to this is a public searchable list of members.
I've mocked up in wix (don't judge me :)  the sort of layout/styling and functionality I was hoping for.

https://sirbrad.wixsite.com/iakpproposal/IAKPPractitioner/find

I'm still getting my head around wordpress, and civicrm, and am not sure of the best practice/approach for creating something like this?
Would this be an 'extension' that I would need to create? Or should I work out how to create a wordpress page that uses ajax to call the civicrm methods to retrieve the data and display it using javascript or something?

Any tips, or suggestions as to further reading would be much appreciated.

Warmly

Brad


texts: Issue field DEDUPE "0 Argument 1 passed to"

texts:
After upgrading to civicrm version 5.21 we detected a problem in one of the fields of the form linked to a custom profile.

For some reason, every time you try to insert that data from the form in the frontend it returns the error message:

0 Argument 1 passed to civicrm_api3() must be of the type string, null given, called in /public_html/administrator/components/com_civicrm/civicrm/CRM/Dedupe/BAO/Rule.php on line 62

It is an alphanumeric text field, the same as others that populate the form.
Has anyone else come across this problem? What can it be caused by?

EDIT - the field in question is used for DEDUPE RULE (for control of duplicate entries), looks like there is something broke with that


texts: Has anyone in the CiviCRM community considered integrating CiviCRM with SendinBlue (https://www.sendinblue.com/)?


texts:
On our web site, the GDPR extension does not figure on the list of installable extensions. Does it mean GDPR (the latest 2.5) is not stable for 4.7.30, or some other reason?

Does it harm to install 2.5 manually?

Drupal 7.58


texts: name "suffix" is missing from import mapping list

texts: name "suffix" does not appear in the field names to be mapped.  I have that data in my contacts.csv file but can't see how to map it.


texts: Cannot bootstrap Civi from standalone script in WP

texts:
We have an old script in the bin folder that bootstraps Civi like so:

require_once '[whatever]/wp-content/plugins/civicrm/civicrm/civicrm.config.php';
require_once 'CRM/Core/Config.php';

But as of 4.7 this no longer works. We get:

PHP Fatal error:  Uncaught exception 'Exception' with message 'Failed to locate civicrm.settings.php. Please boot with settingsFile, search, or CIVICRM_SETTINGS; or normalize your directory structure.' in /var/www/vhosts/humanism.org.uk/wp-content/plugins/civicrm/civicrm/civicrm.config.php:125

I've tried hardcoding the link as recommended here. This gets me a step further, but it then can't find the CMS root folder. And I'm not sure where to set that. I've also tried creating a settings_location.php file to no avail.

I've tried to modernise it by using cv as per the wiki, but I get the same problem:

Failed to locate civicrm.settings.php. By default, this tool searches the parent directories for a standard CMS (Drupal, WordPress, etal) and standard civicrm.settings.php. Symlinks and multisite configurations may interfere. To customize, set variable CIVICRM_SETTINGS to point to the preferred civicrm.settings.php

Civi runs fine otherwise - it's just external scripts that aren't happy.

Any ideas? We're on WordPress, with a standard folder structure: Civi sits in /wp-content/plugins/civicrm.


texts: Cannot edit CiviCase Activity Status from list view

texts: From the List view of CiviCase Activities of a case, I cannot edit the "Status" of an activity; the drop down flashes and then goes back to current status. To edit, I have to click "edit" and go into every single Activity one by one. Is this a bug or a set-up problem?


texts:
I am using a fresh install of civivolunteer on wordpress 4.7.5.
Everything seems to work, except online registration's don't show in assign volunteers!
The activities are logged in the database, because I can see the registrations in a volunteer report. But the screen 'assign volunteers' is blanc.
Is this a bug, or am I doing something wrong?


texts: How do I use the joins feature of the new API

texts: 4.7 lists the ability to use joins for API queries, but I can't find anything in the docs or in the API Explorer.  Can someone point me to documentation or examples?


texts: Upgrade to 5.35.1. - Events no longer working

texts:
I have just upgraded civi to 5.35.1. on my Drupal 7 build but now when I go to 'configure event' I get a whole load of code before the tabs...and then the info/settings page is blank.
Please see attached screenshot.
I use 'civirules', 'cividiscount' and 'NCN Civirules Actions for Zoom' extensions ties in to events but even if I disable these I am faced with the same issue.
I am completely stumped and wondered if anyone has had a similar issue?
Regards
Robbie


texts: How to add field for length of a specific membership type to Contact Summary page

texts:
I'd like to add a custom field to the Contact Summary page that calculates and displays the time that the person being viewed has held a full membership.

In this case we have student, candidate and full memberships and a full member will have records for each in their membership tab, showing the transition dates from where their student membership ended and candidate membership started, where the candidate membership ended and their full membership started.

For the "Years as Full Member" custom field, we want to be able to glance at the summary page and see that a member has held a full membership for 9 years, 12 years, 25 years, etc... The calculation is simple enough but I don't know how to integrate it within CiviCRM/Drupal.


texts: Address field order on Contact's "edit" page

texts:
How can I change the order of the address' fields on the page where I can edit the conatct's details?

Now I see the fields city, than postal code, than country, but I'd like to have postal code first, than city, and than country.

In the Address.tpl file is only so much:

{foreach item=addressElement from=$addressSequence}
     {include file=CRM/Contact/Form/Edit/Address/$addressElement.tpl}

How can I edit $addressSequence?

Thanks.


texts:
We are using a working API Google Key that is used to display maps on a site.

On the pages where we configure the map to display, such as in views, this works fine and the map appears as it should.

However, on the Civi events info page, the map is not appearing at all and there are no errors in the Google console.

I'm wondering if this has something to do with the geocoding, I realised that the scheduled job for Geocoding had failed every time in the past so I had a play around and got it to run successfully but it didn't geocode every address (about 1/3 were left).
Whether or not this is related is another matter but I thought I best include it.

Feel free to ask for more information if needed.


texts: Moving all contacts from CiviCRM to Kepla

texts: my organisation is currently switching from CiviCRM to Kepla. I'm wondering about the best way to export all contacts information out of Civi and import it into Kepla. I have been able to export individual lists of people into an excel document, clean it up, and import them individually, however there are so many contacts left and I'm worried about people falling through the cracks. If there's a way to export all contacts from the database at once, including the notes attached to them, that would be ideal. Thanks!


texts:
I'm creating a wordpress site for a gym. The gym memberships are tiered. Platinum members can access as many classes as they like as part of their membership. They are easy to handle with CiviDisount - I just give those members 100% discount on event (class) bookings.
Other membership tiers are harder for me to figure out. The gold membership includes 12 classes a month. How do I limit the number of events a member can access based on their membership? Can I even do this is Civi?


texts: Multiple automatic discounts for memberships

texts:
So we have three membership levels - a 1 year, 2 year, and 3 year. The discount level for 1 year and 2 year are the same, but it is higher for the 3 year. I have the discounts for them set up the same way, except one applies to 1 and 2 year and the other applies to 3 year. However, only one is showing on our membership page. Is it a problem of there only being one allowed?

The point of the discount is that it automatically applies if the person still has a current membership. If it has expired, they are charged the full price.

The user that I am logged in as when looking at this membership page has the 3 year membership type.

Here's what I get on the membership renewal page, the setup for the 1 & 2 year discount, and the setup for the 3 year discount:


texts: Administrator does not have sufficient permissions when running upgrade script

texts:
I've run into an issue with Civi CRM and I'm hoping after an upgrade it may resolve itself. It's been a couple years since we starte using it on the site. I'm following the steps that are located here and have no problem up until I get to step 4, when I need to "Run the Upgrade Script". I've replaced your_wordpress_home with my home link but all I get is a "You do not have sufficient permissions to access this page" error. My folder permissions are correct, I downloaded and unzipped the correct wordpress zip file and I'm logged in as the Administrator so I can't see why I'm running into this error.

I've searched around and there may be something to do with a database permission for the administror account? Or is there something else I should be doing in this case?

I had run into this question/answer however I've checked my download at it is indeed correct civicrm-4.7.13-wordpress.zip.

Any help or guidance with this is greatly appreciated as I've been trying to re-upgrade and delete and go through the whole process again and agian but I run int othe same issues.


texts:
We are using CiviCRM 4.7.10 on Joomla 3.6.2.   The contribution receipt isn't showing any field data, except amount and date, though it does show the intro text put into he Contribution form.   This is a contribution form that has an optional donation, but mostly collecting profile data.

My understanding that all fields from this form should display on the receipt - How can we get all the form data to email in the receipt?


texts: Contact ID 1 is an organization and causing errors

texts:
I did a fresh install of Civi4.6.4 on Drupal 7.38 and ran into something I haven't seen before. An organization was set up as ContactID 1. Now when I logout and then login I receive the following:

Session opened for "Drupal User 1"  (Drupal uid: 1 is now CiviCRM
contactID: 2) - then the errors:
Role Publish Events (11) should be held by user  (1) because they are part of group 5 (contactID: 2)
Role Publish Jobs (13) should be held by user
(1) because they are part of group 7 (contactID: 2)
Initial roles: @roles, roles to add: Array ( ) , roles to remove:
Array ( ) , final roles: Array ( [2] => authenticated user [3] =>
administrator user [11] => Publish Events [13] => Publish Jobs [15]
=> View Maint [23] => Publish News [24] => View Connects )

Is there a way to change the organization to an individual (though that doesn't seem be a solution based on other questions)? ...is there another way to fix the problem? ...and how did the "organization (default organization)" create the groups?


texts: Has anyone successfully setup Mandrill with CiviMail for bulk?

texts:
In the past (v. 4.5.x) I tested CiviMail for bulk mailings and had lots of trouble process bounces via the return channel.  I know there is a wonderful plugin for transactional emails, but for bulk mailing, Mandrill is very reasonable and provides some great complimentary reports.  I expect it should work with Mandrill's SMTP functionality directly.

So before I dive in, I'm simply asking if anyone has gotten this to work and if so, could you please share your config.


texts: "Error: CRM.url called before initialization" on contribution page

texts:
I am getting this - "Error: CRM.url called before initialization"
when I select the country from 'country field' included in the profile.

Steps to replicate:

  Created a profile including address fields street, pincode, country, states, city
  created a contribution page.
  added profile for that contribution page.
  Opened "contribution link" for live mode.
  Try to change the country name state/province field keep spinning.

What will be the issue?

reference file:civicrm/js/crm.ajax.js


texts: Cannot Backup my CiviCRM DataBase due to an Unexpected Error

texts:
I use the Backup & Migrate Drupal Module

I realize that I have never had my CiviCRM DB saved, though it is mentionned in the Sources Backup configuration list.

I have only one Settings Profile, which only contains "Default Settings" / "Default DataBase" (which I understand to be the Drupal DB).

If I want to "override" the existing Setting or "Create a New Profile", I get the following message :

"The Web site has encountered an unexpected error ; please try later".

Is there any expectable reason ?

(Currently in Drupal 7.54)

--------------------------- Edited 04/19/2017

I have submitted the problem to CiviHosting : this is their answer :

"I enabled logging for your site and the error is this:
PDOException: SQLSTATE[HY000] [1045] Access denied for user 'XXXXX'@'' (using
password: YES) in backup_migrate_source_db->_get_db_connection() (line 213 of
/home/XXXXX/www/www/sites/all/modules/backup_migrate/includes/sources.db.inc).
which I do not understand as the XXXXX has access to both the CiviCRM and the
Drupal database."


texts: CiviEvent in Multisite Acting Strange after Upgrade to 4.7

texts:
Our organizes uses Wordpress and CiviCRM, and we have multisite enabled to use one civi database across two websites (set up in WP multisite).

I upgraded to CiviCRM 4.7 this morning and it went smoothly on the main site. However, on the second site, the CiviEvent pages look strange on the website front end. It looks to me like the CSS is not loading correctly. Can anyone give me some idea as to what is happening here?

Here is an example.
Working, primary site:
http://japanphilly.org/wordpress/civicrm/?page=CiviCRM&q=civicrm/event/info&reset=1&id=225
Strange-looking, secondary site (same event):
http://subarucherryblossom.org/events/?page=CiviCRM&q=civicrm/event/info&id=225

In addition, while logged in as an admin, the drop-down admin links which usually appear near the top of the page (Info and Settings, Location, Fees, etc.) appear not as a drop down but as a list of links... which is why I am guessing the CSS is somehow not loading right.


texts: contribution pages and mailings have incorrect URLs

texts:
I don't know when it began, but these pages all used to work on some version of these site.
I currently look after 3 different CiviCRM installations for different non-profits.
On one of them (running WP 5.4 and Civi 25.0) links to Contribution pages work:
https://sitename.tld/?page=CiviCRM&q=civicrm%2Fcontribute%2Ftransact&reset=1&id=1&action=preview

On another (running WP 5.5, Civi 5.24.6), a contribution link menu now produces:
https://site2.tld/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcontribute%2Ftransact&reset=1&id=8

This works if I'm logged in, but is not publically available. It used to offer up this link instead:
https://site2.tld/?page=CiviCRM&q=civicrm%2Fcontribute%2Ftransact&reset=1&id=8

If I edit the link to remove the wp-admin/admin.php section, then I get an empty page. If I use the ID in the civicontribute shortcode on another page, it works ok (though has another problem I will not muddle the is question with).
A third site (running WP 5.5, Civi 5.23) has a similar problem. The URLs are created correctly on that one, but the resulting page is empty whether a contribution page or a "public view" of a mailing.
Lastly a site using WP 5.5 and Civi 5.28 has the new civiwp URL structure but still won't respond to the page request. I have to use the shortcode in a WP page.
https://onothersite.tld/?civiwp=CiviCRM&q=civicrm%2Fcontribute%2Ftransact&reset=1&id=1

I mention these together because I don't think it is a version issue so much as I have somehow allowed some common problem to creep into these sites. I am especially mystified that I cannot seem to even manually construct a URL that is being correctly answered.
Thoughts I have had, but have not found info on:

possible missing rewrite info in .htaccess,
Theme interference, though one of the non-working ones is running the same theme as the working one.

UPDATE: I have tried enabling the wordpress "Clean URL" system on one site. It seemed to work in that it pointed at the default civicrm page, but I still get no content:
https://sitename.tld/civicrm/?id=6df8f11af7cc1a8a&reset=1.

I would really appreciate any thoughts people might have as to where to look. This is becoming a serious problem.


texts:
I have been runnning civiCRM for more than 2 years until now ; but I meet some problems (phone number cannot be saved).

So I try to install a new CiviCRM (4.7.11) on Drupal 7.50, the simplest way : install Drupal via Cpanel, upload civicrm tar.gz, and then install via sites/all/modules/civicrm/install/index.php (fetching Data Base credentials inside settings.php).

I have made several trials (http or https, same or separate database(s)) : all of them end with a

  "Sorry but we are not able to provide this at the moment. DB Error: unknown error".

However, all the civicrm tables are created, and the CiviCRM Menu can be displayed, but whatever I want to do (e.g. create a new contact), I get this DB Error again, and the info is not saved.

My hosting is based upon PHP 5.5, MariaDB 10.0.27 (supposed to be fully compatible with MySQL) (and a friend of mine, who uses the same hoster, has no such installation problem)

The significant error information is:

  DB_Error->DB_Error(-1, 16, (array:2), "SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_numer...")

and

  DB_common->raiseError(-1, NULL, NULL, NULL, "1728 ** Cannot load from mysql.proc. The table is probably corrupted")

A backtrace from when I try to create a new contact is shown below.

Any help would be highly appreciated.


texts:
We have an email newsletter with about 40,000 subscribers. It is organised simply by a group. So everybody, who is member of this group gets the mailing (unless email is not on hold etc etc).

For the second time we have the issue, that nearly every recipient got the mailing twice. In one case 57 recipients got only one mail, in the other case 39. All the others got the same email two times.

People get upset by this, so I am quite interested in solving this issue.

What I can see, is that there are in both cases two jobs for the mailing, that are no tests. One is obiously a parent job and the other a child job. And all the mailing_event_queue entries belong to the child job.

All of this seems to be quite normal, because the other mailings look the same. The only strange thing is, that in these two cases the child job has nearly twice as much mailing_event_queue entries than recipients.

I only have access to log data of the second mailing, that has doubled sent mails. And in this case I found the anomaly, that the scheduled job, that sent this mailing reported "DB Error: constraint violation". And looking closer into this, it seems, that in between the time of selecting the recipients and sending the mail one recipient was deleted by an API call. Because of this the insert into the table mailing_event_queue failed because the foreign key for the email id, that was not longer found in the database.

Does any body have an idea, if there can be a connection between this error and sending the mailing to most of the recipients two times?

What should happen, if a email (or a contact and its email) get physically deleted between selection of recipients and sending of emails?

Is there an API version of deleting a contact, that takes care of this?

Or is it the process of sending the emails, that should take care of this?


texts:
Civicrm 4.7.18, 4.7.20 - selecting Admin/System Settings/Misc/Attach pdf copy to receipts results in error msg “The row #24 could not be found, please file an issue in the tracker with the HTML code”

In Sandbox Master (WP), register for event Fall Fundraiser w/PDF receipt selected. Thank You page ('master.demo.civicrm.org/?page=CiviCRM&q=civicrm/event/register&page_id=5') results in WSOD.  Select 'no' for PDF receipt, Thank You page finishes successfully.


texts: Unknown column civicrm_relationship.is_active while child smart group edit (create temporary table fails)

texts:
There are a parent Smart Group which contains several "child" Smart Groups. All was working a while, until at some time point it starts throw an error, something like

 [debug_info] => CREATE TEMPORARY TABLE civicrm_temp_group_contact_cache1208
 (SELECT 258 as group_id,  contact_a.id as id
FROM civicrm_contact contact_a
LEFT JOIN civicrm_group_contact
`civicrm_group_contact-  262,278,261,263,264,265,266,267,268,269,270,271,272,273,274,275`
 ON
... long query skipped ...
 WHERE civicrm_group_contact.status = 'Removed'
 AND   civicrm_group_contact.group_id = 258 ) );
[nativecode=1054 ** Unknown column 'civicrm_relationship.is_active'
in 'where clause']

Is this a bug?  CiviCRM 4.6.15;


texts: Competing CiviDiscount Automatic Discounts

texts:
We have a standard 10% discount on all of our events for members. On this specific event - we want to have a $5 flat discount for members.  The automatic 10% discount is still the only discount working.

Wordpress/Civi - Latest.


texts: Can I pass parameters in the url to a custom search?

texts:
I got a custom search which takes one parameter, group.  This search gives us back the people in the group plus a custom status.  I'd like to be able to add a number of menu items that would run the search for various specific groups.

I'd also like to have an automatic email go out, say every month, to certain people with the results.

I thought maybe saving the query results as a smart group might work but alas trying to create a smart group bombs.

So is it possible to just pass the parameter through the url or are there other solutions?


texts: Can you search for only manually added members of a smart group?

texts:
Is there any way to search or sort the manually added members of a smart group (versus the smart members)? It seems like there should be, but I don't see any option anywhere. It isn't possible to sort by status when viewing a groups contacts either.

The only workaround I can see is to create a new smart group with the group's criteria, then use an include/exclude search to find the manually added members, but there must be a better way.


texts: Required box not appearing, Event Registration

texts: When I try to register event participants I receive a notification saying that I have not filled out three required fields. However, I cannot see or edit these required fields. Anyone know how to fix this? I am using version 4.7.3.


texts: How to prevent Smarty secure_mode activation?

texts:
I hope my silly question will get answers from some of you...

I'm just trying to send an email using smarty basics functions such as using {php} tags and playing php in smarty tags {if strstr($email, '@')}.

But each time I try to send the template Smarty activate secure_mode and everything's ruined...

I found where Smarty put the secure_mode but I can't understand why... (in CRM/Core/Smarty.php line 202).

If someone ever run into this and solved it pleeeease help me  :'(

PS : I defined this in my settings file => define( 'CIVICRM_MAIL_SMARTY', 1 );

Still working on it !

I hope i'll find the solution  ;D


texts: How to creat a report of recurring donors

texts: How do I get a report of all the donors who are set up for automatically give the same amount each month


texts:
We are using CiviCRM with Drupal 7.54 and we just upgraded to CiviCRM 4.7.19.  After the upgrade, when I go to an event (Event->Manage Events->[some event]->location) with a user who has 'access CiviEvent' permissions and try to go to the location tab I receive this error:

CiviCRM_API3_Exception: "Authorization failed to join onto StateProvince api in parameter loc_block_id.address_id.state_province_id.name"

#0 sites/all/modules/civicrm/CRM/Event/BAO/Event.php(1889): civicrm_api3("Event", "get", (Array:5))
#1 sites/all/modules/civicrm/CRM/Event/Form/ManageEvent/Location.php(172): CRM_Event_BAO_Event::getLocationEvents()
#2 sites/all/modules/civicrm/CRM/Core/Form.php(564): CRM_Event_Form_ManageEvent_Location->buildQuickForm()
#3 sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(92): CRM_Core_Form->buildForm()
#4 sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Event_Form_ManageEvent_Location), "display")
#5 sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Event_Form_ManageEvent_Location), "display")
#6 sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("display")
#7 sites/all/modules/civicrm/CRM/Utils/Wrapper.php(113): CRM_Core_Controller->run()
#8 sites/all/modules/civicrm/CRM/Core/Invoke.php(283): CRM_Utils_Wrapper->run("CRM_Event_Form_ManageEvent_Location", "Event Location", (Array:0))
#9 sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:14))
#10 sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#11 sites/all/modules/civicrm/drupal/civicrm.module(448): CRM_Core_Invoke::invoke((Array:4))
#12 includes/menu.inc(527): civicrm_invoke("event", "manage", "location")
#13 index.php(20): menu_execute_active_handler()
#14 {main}

We upgraded from 4.7.15 so one of the upgrades implemented a permission check for

CRM_Event_BAO_Event::getLocationEvents()

Located in CRM/Event/BAO/Event.php

 $events = array();
    $ret = array(
      'loc_block_id',
      'loc_block_id.address_id.name',
      'loc_block_id.address_id.street_address',
      'loc_block_id.address_id.supplemental_address_1',
      'loc_block_id.address_id.supplemental_address_2',
      'loc_block_id.address_id.supplemental_address_3',
      'loc_block_id.address_id.city',
      'loc_block_id.address_id.state_province_id.name',
    );

    $result = civicrm_api3('Event', 'get', array(
      'check_permissions' => TRUE,
      'return' => $ret,
      'loc_block_id.address_id' => array('IS NOT NULL' => 1),
      'options' => array(
        'limit' => 0,
      ),
    ));

Now I am able to access the tab with the permission 'administer CiviCRM' but not with just 'access CiviEvent'.  This is problematic because many of my CiviEvent users can't complete their event postings.

When I comment out the this field

'loc_block_id.address_id.state_province_id.name'

in the return array ($ret) it passes permissions.  I'm wondering if something is wrong with the join in the API, or if there's a permission I need to set somewhere.

Also when I go to the API explorer and reproduce the API call above, I receive the same error.

I'm wondering if this is a bug in core or maybe something on my end.  Any help to find a way around this permission failure would awesome.

Thanks!


texts: wordpress edit multi-record profile fine when logged in but not retaining checksum for anonymous user

texts:
civicrm 4.7.24 wordpress 4.9.5
When logged in I can access, edit and add to a multirecord profile
eg

When not logged in, using identical link (domain.org/civicrm/?page=CiviCRM&q=civicrm/profile/edit&gid=20&reset=1&id=NNNN&cs=c1ae6c62c8b56de0b98cc786cb7e96dc_1523257945_720)
the profile is displayed for the correct user (so the checksum is respected at this point) however the [view][edit][delete] buttons appear as 2 4 8
and (add new record) gives permission error
eg

The only way I can get it to work is by enabling "edit all contacts" for anonymous users. No thanks!
Please note that it works fine when logged in as admin so please no suggestions relating to the format of the link or multrecord profiles
I am unable to test on demo site as mail is disabled so I can't generate checksum


texts: Which value to use for tag_id to create EntityTag

texts:
I am struggling with adding tags trough the CiviCRM API to a newly created contact in an extension (trough API Chaining). The installation is running on Wordpress 4.4.1 with CiviCRM 4.7. The following PHP snippet creates the contact with Tag "Non-Profit" which is not the expected behavior.

$contactParams['api.EntityTag.create'] = array(
        'entity_table' => 'Contacts', 'tag_id' => array("Interessent",     "Contributor")
);

$api->Contact->Create($contactParams)


texts: Validation radio custom fields on civicrm_validateForm hook does not work

texts:
I have a custom field on contact in radio type format, not required field. I'd like to set up custom error on this field by using hook_civicrm_validateForm when the field is null.

// hook in extension
function hook_civicrm_validateForm($formName, &$fields, &$files, &$form, &$errors) {}

$fields array doesn't contain a key for this custom field. After setting $error['custom_xx'] the form is reloaded without displaying the error.

What I found:

$form->_elementIndex contains all needed keys, including this for radio. So I suppose this is not a problem.

I think that problem is caused by using _submitValues[] as a list of fields because _submitValues doesn't contain null radio custom fields:

// CRM_Core_Form->validate():
CRM_Utils_Hook::validateForm(
  get_class($this),
  $this->_submitValues,
  $this->_submitFiles,
  $this,
  $hookErrors
);

// my hook
function example_civicrm_validateForm($formName, &$fields, &$files, &$form, &$errors) {
  if ($formName == 'CRM_Contact_Form_Contact') {
    if (in_array('AA', $fields['contact_sub_type'])) {
      $fieldIndex = 'custom_70-1';
      if (!in_array($fieldIndex, array_keys($fields)) || !$fields[$fieldIndex]) {
        $errors[$fieldIndex] = 'For AA contact type this field is required';
      }
    }
  }
}

Edit:

Here is my workaround - add missing keys to _submitValues[] array
https://github.com/caltha-eu/civicrm-core/commit/b4ee607334f3f091bffc2c32a87d862e4a3d7493

foreach ($this->_elementIndex as $elementIndex => $index) {
  if (!in_array($elementIndex, array_keys($this->_submitValues))) {
    $this->_submitValues[$elementIndex] = NULL;
  }
}


texts: How to control which activity types options appear in dropdown when creating new activity in WP version

texts: Vers. 4.7.16.  When I go to create a new activity in the WP user interface, the choices in the Activity Type dropdown are limited to 4 options.  I want to create more activity types and when I go to Activity Types under Administer, I see lots of existing Types.  How do I indicate which of these types (or a new type I create) appear in that New Activity form's activity type dropdown?


texts: Auto-Renew Membership option not displayed v4.7.2

texts:
CiviCRM 4.7.2, Joomla 3.4.8, MySql 5.5.45, PHP 5.5.30

I'm seeing a similar issue as seen in this thread: Auto-renew option not appearing for membership

The auto-renew function was working fine, as far as I can tell, up to v4.6.8, but after the upgrade to 4.7.1/4.7.2/4.7.3/4.7.4 it is not appearing on either the initial membership page, nor the membership renewal page.   All appropriate auto-renew options on the membership type, and elsewhere are correctly set.

UPDATE 2016-03-26 - turns out that if you have your membership prices set to auto-renew, and the Pay Later option configured, the Auto Renew options does NOT appear on the membership signup/renewal page.

This is NOT using a price set for the membership prices.

I've created an issue on this:
https://issues.civicrm.org/jira/browse/CRM-18299


texts: Automated contact filtering for event attendees?

texts:
Is there a way to perform automated actions when people sign up to events based on their profile info?

For example:
- if someone has already attended an event in the last month, put them on the waiting list
- if someone belongs to a particular organisation, automatically mark them as registered

I'm using Civi 4.2.27 on Wordpress.


texts:
Is there a way to use the CiviVolunteer job opportunities in Drupal views?
If not would this need work on the CiviVolunteer extension or the CiviCRM entities module?

We are looking for a way to expose the vacancies in a nice and flexible way in our drupal views.


texts:
I want to activate CiviCase in admin/setting/component?reset=1 and this results in an "DB error".

This is the error-log:

   CiviCRM_API3_Exception: "DB Error: already exists"

[...]

Entschuldigung, eine Bereitstellung ist uns gerade nicht möglich.
DB Error: already exists


texts: Staging Site: staging.site.com/civicrm 404 WordPress

texts:
All paths seem to be set up correctly, I've gone through Pointing to /civicrm breaks Wordpress site, 404 HTTP response and the forum link posted on there but with no success

So for example staging.site.com/civicrm?page=CiviCRM&q=civicrm/contribute/transact will return a 404 error (anything /civicrm returns a 404 error inc "staging.site.com/civicrm") There is a single error in the error log relating

staging.site.com [Fri Mar 10 17:21:10 2017] [error] [pid 2446] mod_negotiation.c(1291): [client 123.123.123.123:52418] AH00687: Negotiation: discovered file(s) matching request: /home/profile/www/staging/civicrm (None could be negotiated).

The CiviCRM page in WordPress exists and every other page works okay, the main production site works okay

I've checked all the resource URLs etc and everything looks good, matches the production version apart from pointing to the staging directory, permalinks are setup, as is the .htaccess file

I've looked up the error in the error.log file and nothing comes up at all related to civi so at a bit of a loss now, hopefully there's something simple to fix!

I'm fairly new to civi, so things that are probably easy fixes I'm not aware of yet! The staging site is a clone of the production site but with everything in the settings file & database changed to the staging directory

Thanks in advance!


texts: dupe_check parameter only works for contacts?

texts: I would like to disable the dupe check on relationships. Is it true that the API parameter parameter 'dupe_check' works only for contacts or can it be also used in relationship api calls? Here under 4.6.33 'dupe_check'=> 0 does not seem to work?


texts: Need to redirect when permission issue happened on CiviCRM Page

texts:
I have enabled and configured access for Contribution financial type. When an anonymous user open the a contribute page, it returns the error.

I need to redirect to login page in this case. I don't want to show error page to the user.

Please Help!


texts: Adding a column for Document Links to the Activity table in CaseView

texts:
In the CiviCRM Case View, I want to add another column to the Activities table. Right now, the last column contains some links ("View", "Edit", "Delete") and one link to an attached document if existent.
I want to split this last column in two, so the link to attachments and the other links are in two different columns.
Therefore, I doubled the last column inside the sites/all/modules/civicrm/templates/CRM/Case/Form/ActivityTab.tpl template:
&nbsp;
&nbsp;

Then, I adapted the first column like this:
&nbsp;Dokumente
&nbsp;

Now, I am stuck at the content part. Does anyone know from which location "links" is called or created? I read that the html "data" attribute can be used by a JavaScript script. As I need only the links to any attached documents, but not the others, I would need to alter that script.
Edit: Alternatively, it would be helpful to know where the Activity table is created (
).
Edit: Reading Demerit's answer, I have checked the addCaseActivityLinks() function. To adapt it for my documents column, I thought about copying the function, renaming it, adapting it, and make the ActivityTab.tpl call it inside my document  tag.
Another solution would be to use an existing param of the addCaseActivityLinks() function in order to determine with which value of data-data the function has been called (data-data="links" or data-data="documents"). These existing params are: $caseID, $contactID, $userID, $context, $dao, $allowView = TRUE
I think I am still missing understanding of how/where the addCaseActivityLinks() function is called, so I would be able to implement one of the abovementioned solutions. I searched the whole project for a fucntion call, but couldn't find one. Any hint anyone?


texts: How do I download duplicates of imported contacts in the past month?

texts:
I import contacts almost every day, and I automatically press "skip" on the "For Duplicate Contacts" import option.

When the import is complete, I recognize that I have the ability to download the duplicate emails.

However, I have NOT been doing that.

So now, I want to download all of the duplicates emails in the month of June.

So is there any way to retrieve all of the duplicate contacts from June?

I'm using CiviCRM 4.7.16.


texts: DreamHost is dropping support for Catch-All mailboxes

texts:
I use CiviMail in conjunction with a catch-all mailbox.  The bounce processing updates the database when there’s bad email addresses and reports bounces on the mail report.  It also handles user opt-outs. We use DreamHost, and they’re dropping support for catch-all mailboxes as of 10/1/18.  Ugh.  DreamHost doesn’t support VERP either.  I found this documentation: https://docs.civicrm.org/sysadmin/en/latest/setup/civimail/inbound/
which has this section:

  Variable Envelope Return Path (VERP)
  CiviCRM Bounce handling depends
  on using Variable Envelope Return Path (VERP). If your email server
  doesn't support VERP you will only be able to properly support bounce
  requests if you can set up a catch all email. If you cannot setup a
  catch all email and your server does not support VERP you will need to
  edit packages/Mail/smtp.php as follows near line 275:
  //if (!empty($headers['Return-Path'])) {
         // $from = $headers['Return-Path'];
         //}

So, I set up a new mailbox bounce@domain.org and marked it in Administer | CiviMail | Mail Accounts as the account for bounce processing.  I commented out the three lines of code shown above.  I did a test mailing with a bad email address, but the delivery failure went back to the sending email address (wisconsin@domain.org) instead of bounce@domain.org.  What am I doing wrong??? Thanks for your help!

UPDATE: I don't want my email blasts to come from bounce@domain.org.  CiviMail lets you specify the bounce email address in Administer | CiviMail | Mail Accounts.  It just doesn't work!  One clue I found was in my own question posted in 2015 (Problem using CiviMail with Bluehost), where Xavier points out that the lines of code I commented out are the one's needed to be able to identify who was the recipient, so if it bounces, Civi can identify it properly.  So, I reinstated those lines of code. But the bounce went to the old Catch-All account, instead of the new bounce account. Then I disabled the Catch-All account. Now I can't find the delivery failure email anywhere?!? Please help!!! I'm using CiviCRM 4.7.20 and the current version of WordPress.


texts: Activity search by subject - advanced search vs activity search

texts:
I've noticed the upgrade to the activity search now lets you search either the Subject or details of an activity (I'm in Civi 5.5.3, Drupal 7.59) which is great but on the Advanced search screen it seems to use the strict "=" qualifier.

I've verified the following behavior of the demo site (5.8) as well:

Run an Advanced search for an activity that contains "Tell a Friend" in the subject line - no results.
Run an activity search for an activity that contains "Tell a Friend" in the subject line - returns all the activities that subject line contains the search term, including "Subject for Tell a Friend".
Same problem when you search details or both.

I can see in feedback for the the blank search results:

No matches found for:
Activity targeted to ...AND...
Activity Text (Subject Only) = 'Tell a Friend' ...AND...
Activity Status In Completed

Versus the summary that shows on the full set of results:

Activity targeted to ...AND...
Activity Text (Subject Only) Like '%Tell a Friend%' ...AND...
Activity Status In Completed

I'd like to use advanced search so that I can return contact results and add them to a group. Any idea where I take a look to change the Advanced Search from "=" to "LIKE"?

Also, any idea if this was intentional behavior - it doesn't seem like it would be very useful but maybe that's me? Is this worthy of a bug report?


texts:
I have a

Synology DiskStation NAS: DS918+, running DSM 6.2
Running the Synology MariaDB-10 package
Running Synology Package Drupal on it (vs 7.58 as of today). Developed by the Drupal-investigator Dries Buytaert and provided by Synology)
Only one Drupal user: the administrator (I checked the privileges in the drupal UI and in the database as well)
Tried to install Civicrm 4.7.31 on it, using:
http://192.168.1.110/drupal/sites/all/modules/civicrm/install/index.php
all drupal/civicrm directories/files have same ownership (http:http)

It keeps giving me the "You don't have permission to access this page" message.

Question: anybody familiar with installing civicrm in this Synology environment? or with similar permission problems in another environment?

As work-around I have in mind to create a VM (ubuntu 16.04, LAMP) and do a complete "manual"install of Drupal 7.58 and civicrm 4.7.31 but that's a lot of extra work and overhead. So I hope to avoid that.

Thanks in advance,

Kind regards, Hans Troost


texts:
(CiviCRM 4.6.20, Drupal 7.50)

I have had zero luck trying to get this functionality to work.  Here is the setup:

Created a regular (not smart, didn't want to add that level of potential caching complication yet) group of contacts (let's call it Test Group) to which a specific user should have access.
Created a group for access control, and added that user to the group.
Created an ACL role and linked it to the group for access control.
Created an ACL for editing the Test Group of contacts for the ACL role created in the previous step.
Logged in as the specific user and can only see the user's own contact record, not any others.
I have the View All Contacts and Edit All Contacts Drupal permissions turned off for this user's Drupal role, and I even tried turning off the view/edit own contacts Drupal permissions, all to no avail.

There must be a step I'm missing but I've reviewed a lot of documentation and I just don't see where I'm going astray.  If anyone has used this successfully, can you please point me in the right direction?

Thanks in advance,
Lesley


texts: How do I clear all the personal / sensitive data from CiviCRM DB via SQL?

texts:
We have cloned a live DB and run the following SQL to anonymise the contact data:-

delete from civicrm_email;
delete from civicrm_address;
update civicrm_contact set birth_date = NULL;
update civicrm_contact set first_name = 'Staging';
update civicrm_contact set middle_name = '';
update civicrm_contact set last_name = concat('Test',id);
update civicrm_contact set legal_name = '';
update civicrm_contact set display_name = concat('Staging Test',id);
update civicrm_contact set addressee_display = '';

However, when we search for contacts (Search/Find Contacts) it still displays the original contact name under the "Name" column.

How can we improve this SQL script to remove all traces of contact names?


texts: Quality assurance considerations for membership signups

texts:
I'm pretty new to the CiviCRM world and am just finishing my first project using it. We are now in the process of making sure that our membership signup procedure (with contributions) works well. As I see it there are a couple of ways to increase the chance that we will have a high quality in this part of our system:

We can communicate with users who have used the live system
We can carefully monitor the stats for new users
We can run tests ourselves

For the tests I see several possible ways, for example we can use the payment processor that we are using for the live payments but instead run it in test mode ("preview" in the url params). KarinG suggested in her answer to this question that we create a new payment processor and run it in live mode but with test credentials. Also there is the "dummy payment processor" which seems to be recommended in the CiviCRM user guide ("For the purposed of testing, you can configure dummy payment processors.")

How do we (in general) ensure that our donation procedure is working well? And a more specific question: Which of the options above (dummy payment processor etc) is the best way to test a membership system?

Grateful for help and with kind regards,
Tord


texts: How to hardcode the unsubscribe /optout URL in a transactional email?

texts:
I would like to send a transactional email with unsubscribe/opt-out url included. It usually gets triggered by civirules when the person gets added to a group. when email is sent the unsubscribe url does not render. civirules have suggested I hardcode the link. I have tried https://example.com/civicrm/mailing/unsubscribe?reset=1&cid={contact.contact_id}&{contact.checksum}
But with this link I get "Missing Parameters" errors. What is missing here? thanks


texts: I want to offer a free event with an optional £5 donation. I can set this up easily with two different fee amounts, but it won't allow me to have the zero amount as the default which I feel is appropriate for an optional donation. I always hate it when a form has an optional donation pre-ticked and it actually discourages me from donating. How can I get round this?


texts: Civimail Not working after upgrade to 4.7.21 with Joomla 3.7.3 unless I turn on debugging

texts:
I run 3 instances of Civi with pretty much the same setup - All had been working fine on 4.7.20

4.7.21 not so much - 2 of the 3 instances get stuck at Initializing... when creating a new mailing or reusing or editing.

In the case of the new / reuse - the mailing is created just can not get to the issues

The really odd thing - if I turn on debugging the CiviMail lets me create new mailings and edit existing ones

Thoughts / Suggestions

Thanks


texts: Why are Username and Password are no longer accepted for Outbound GMail?

texts:
We use GMail (G-Suite) for outbound mail. Three days ago, we started getting:

authentication failure [SMTP: Invalid response code received from SMTP server while sending email. This is often caused by a misconfiguration in Outbound Email settings. Please verify the settings at Administer CiviCRM >> Global Settings >> Outbound Email (SMTP). (code: 535, response: 5.7.8 Username and Password not accepted. Learn more at 5.7.8 https://support.google.com/mail/?p=BadCredentials n3sm11135782pff.102 - gsmtp)]

We've verified (ad nauseam) that the Username and Password are correct. We can use them to send and receive through GMail just fine. However, we can no longer send with Outlook, either.

How can I find out why the Username and Password are no longer accepted?


texts: Monitor ConfigAndLog .log file in real time

texts:
I am upgrading the CiviCRM and would like to monitor the current .log file that is in <drupal root>/sites/default/files/civicrm/ConfigAndLog/ as it's being updated, in real time. Currently, I know how to view it using the cat command via command line on demand only. Is there a command that prints the latest entry as they happen?

I know this probably is less of CiviCRM question and more of a linux question, but others debugging and monitoring CiviCRM processes might find it helpful.


texts: Why are all my iATS recurring payments for EFT/ACH marked as "pending incomplete transaction"?

texts:
This occured today, after upgrade from 4.6 to 4.7. The recurring credit cards appear to be updating properly in civiCRM, but not the EFT/ACH. More importantly, it also appears that the transactions in question did not transact at iatspayment.com. Is my EFT payment processor not set up properly?

I am running Civi 4.7.22 and iATS extension version 1.6.


texts: Stripe Authorises payment before form validation causing problems

texts:
CiviCRM 5.17.4  Drupal 7.67 Stripe 6.2.2

Our problem is we have a fairly complicated booking form with quite a few required fields and a stripe payment option.

When a client opts to pay by stripe, but then selects to continue before filling in all required fields, Civi of course warns that not all info has been entered and does not continue but Stripe will authorize the payment and it appears in the stripe dashboard as an uncaptured payment.

Some people simply don't notice the incomplete fields warning and abandon the booking.

They then complain that the money has been taken from their account despite not completing the booking. (From their point of view this is correct as Civi scheduled jobs only cancels uncaptured payments after one day) and they (or we) have no confirmation of the booking (which again is correct because they didn't complete the booking)

Is this behaviour right? We would far prefer it if Stripe didn't authenticate payments if required booking fields were not filled in..


texts:
Good morning from Canada.  I am trying to create an extension with angularjs forms.  I have followed the development guide and have created the angularjs page but I cannot get it to display in CiviCRM.  I have a Tabset function used with Events, it calls the php page, which in turn I have the AngularLoader configuration.  When it gets to the useApp() command I get an Unknown Path error.  The examples in the doc don't go as far as to show how to do this within an extension or as a new tab under event.  Even if you can point me to an example extension, I can analyse it to try and figure it out.  The default_route value in the useApp() command I'm assuming is the ang entry in angular?  When I do a cv ang:html:list the page I want is listed (as well as ang:module:list has the module).  Thanks for any advance or help you can give.
I ran all of the suggested civix commands from the documentation.
From the php called from the extension:
...
$loader = new \Civi\Angular\AngularLoader();
$loader->setModules(array('trialadmin'));
$loader->setPageName('TrialDetails');
//$loader->useApp(['defaultRoute' => '/trialadmin']);
$loader->load();
parent::run();

And in my module I have
if ($eventID) {
$url = CRM_Utils_System::url( 'civicrm/event/manage/TrialAdmin', "reset=1&force=1&eventid=$eventID&snippet=5&angularDebug=1" );
error_log($url);
$tab['Administration'] = array(
  'title' => "Administration",
  'link' => $url,
  'valid' => 1,
  'active' => 1,
  'current' => false,
);

output from cv ang:module:list
trialadmin        | civicrm/a                   | crmUi, crmUtil, ngRoute
output from cv ang:html:list
trialadmin/TrialDetails.html
I've tried different arrangements of the defaultroute but I'm not clear on why I'm getting the unknown path error.  If I comment out the useApp line it continues on to use the *.tpl that I originally had in place.  I wanted to do this with the newer forms format rather than the quickforms as suggested in the docs.


texts: Donor's name is overwritten with name on Paypal account

texts:
I have set up a contribution page using Paypal Express (the one in core). I have added a profile which includes the first and last names of the contact. But when the contact is created, these names are not used, and the contact gets the name from the Paypal account instead. And if the contact already exists, then their name gets overwritten with the name from the Paypal account.

It seems this has been an issue since 2017, or perhaps it is a regression. The following bug report is still open.

https://issues.civicrm.org/jira/browse/CRM-20553

Someone asked a question about it here in 2017 but now the code around it has changed and the suggested workaround (which would have meant hacking core anyway) cannot be applied.

Is there a setting to prevent Paypal Express overwriting contact details with provided Paypal billing details?

If you are using paypal, are you also experiencing this issue and if so have you found a workaround for it?


texts: "My Registered Events" listing (with cancellation option) for user dashboard page

texts: I've searched and researched and come up empty - is it possible to present a dashboard (summary) view of the events that a person has registered for, along with the ability to easily cancel from any of the listed events? It seems like a very useful thing to have but I'm coming up empty when trying to find any mention of doing so with CiviCRM.


texts: How to connect your household address to its members in civicrm api v3?

texts:
$result = civicrm_api3('Address', 'create', array(
  'sequential' => 1,
  'contact_id' => $householdContact['id'],
  'location_type_id' => "Home",
  'is_primary' => 1,
  'street_address' => $form_state['storage']['contactInfoValues']['address1'],
  'supplemental_address_1' => $form_state['storage']['contactInfoValues']['address2'],
  'city' => $form_state['storage']['contactInfoValues']['city'],
  'state_province_id' =>  $form_state['storage']['contactInfoValues']['state'],
  'country_id' => "US",
));

$master_address_id = $result['id'];

 $result = civicrm_api3('Address', 'create', array(
          'sequential' => 1,
          'contact_id' => $primaryContact['id'],
          'master_id'  => $master_address_id,
          'location_type_id' => "Home",
        ));

I need to attach the household address with primary contact address . How can i achieve I tried by implementing above ,but it did not work?


texts:
From Civicrm I tried to send sms but it didn't work, I tried meshes> new sms then I selected as Twilio supplier and select the group where my constact is located but none of them are 'is find.
Have a good day


texts: I need to rebuild some groups where all the members were removed by the link between CiviCRM and Mailchimp. I have found the ability to list all members of a group who have ever been removed from that group, but I also need to be able to filter this by the date they were removed. Is there any way to search for members of a group who were removed on a specific date?


texts: Can webform-civicrm pre-select an event using Drupal Views?

texts:
The answer is (I hope) 'yes' but I can't get it to work - see How to select a default event in webform where event is repeating
 I'm pretty sure the Views side is working as it generated a url that when clicked gave me the webform with the correct event selected (this is on a Views screen).  But when I run the webform I get '- None -' displayed in the event list box. Yes, I have checked "Allow events to be autoloaded from URL checked."  Code is at the latest level - I went back to Webform 7.4.9 and Webform 7.4.11 to see if there had been a regression but no change.
So now I'm wondering if this is a bug in Webform-CiviCRM?


texts: Is it possible to assign a "custom group" to a specific roles of users?

texts: I have a custom set of data that I wøuld like be only visible to users with specific permission.  is it possible to achieve? thanks


texts:
So I know that the Organization contact type is sort of used for two purposes. One it can be a chapter of the primary org that the CiviCRM is setup for and it can also be used for a company that a member is an employee for. What I don't know is how do you setup a contact to be part of your chapter and also set their employer? Do we need to add a custom field to the summary view so that we can create this extra relationship?
Our client, whom we are setting CiviCRM up for, has some chapters/sub-orgs under the main Non-profit org and a member could be part of that org. But when adding the member, if they want to provide the company they work for, we would need to allow for this as well.
The OTB setup only has the employer which is the org lookup field, so not really sure if the chapter use is intended to be an extra custom field or not.


texts: Manage Groups shows no groups after server move

texts:
We moved our CiviCRM install to a new server a couple of weeks ago. Everything seemed to go smoothly, but we've now noticed that the Manage Groups page is empty:

Clues that I've got so far:

This happens both with new users, and users that were moved over from the old server.
I can create a new group without errors, but obviously it doesn't show up afterwards.
Group counts show up on the contacts page tab, but no roups are shown there either.
We followed the move process outlined at https://docs.civicrm.org/sysadmin/en/latest/misc/switch-servers/.

Hopefully somebody out there's got some clues, because I'm coming up empty right now... Thanks in advance for the additional brain cells!

CiviCRM 5.11.0, Wordpress 5.2.1


texts: Problem with CiviCRM configuration (auto_increment) with wordpress (4.x) website

texts:
According to the folks at Network Solutions (our website hosts) the plugin (CiviCRM 4.7.4) was installed.
They had to do a MySQL upgrade database as part of “routine” updates also.  The MySQL upgrade
went fine in that it did not crash our website or cause us to have to make any repairs to the info on the site.
The configuration of CiviCRM is where the problem lies.  According to Network Solutions, there are requirements
that the CRM needs that are blocked on the MySQL server as potential security issues.  They said an “auto_increment_increment” needs
to be set to 1.   So there is my dilemma. Any suggestions?


texts: I've been using CiviCRM for a few days now, and it's become pretty apparent that campaigns are a big part of how the system works. However, I'm unable to figure out how to create a campaign. Can anybody help me out?


texts:
We have a site that is using the gradebook. The teacher has submitted a final grade. When you view the activity, it shows the grade in the Activity Info section. However if you go to edit that record, the grade field doesn't show up. We are running CiviCRM 5.10.3. This only started after upgrading from 5.3.1. Any help would be appreciated.

Here is the activity view, showing the grade

Here is the activity edit, not showing the grade.

I looked in the console while loading this in a new tab as well as the modal there wasn't any errors.


texts: How to turn off the prompts for additional participants in event registration

texts: I have an event with a $10/head admission fee.  I have "register multiple participants" and "same email address" boxes checked in the setup.  The profile is just first name, last name and email.  The problem is that each registrant is still taken to a profile screen for each person they are registering.  So if Suzie is buying 6 tickets, she will be prompted to enter data on all six people.  They may be optional, but they are still annoying to the user.  How do you turn that off so Suzie can just say she wants 6 tickets, enter her own data, pay the fee and be done?


texts: Memberships not being inherited by related contacts

texts:
I'm working on a new CiviCRM implementation in Wordpress. I have imported contacts with an External ID in each record, imported contributions, memberships and relationships. The related contacts are not showing a valid membership by relationship and the Primary Member's membership record states "One contact is currently eligible to inherit this relationship."

I have tried deleting all records and reimporting in a different order; updating memberships; running update membership scheduled job.

I don't know where else to turn - I don't want to enter all of these manually.

Open to more ideas to solve the issue.

Thanks in Advance

Wordpress 4.5.3
CiviCRM 4.7.9


texts: Is there a report that I can pull to show me all donors, members and never givers?

texts: Looking to pull a report that includes all contacts with what they have contributed and not contributed.


texts: outgoing sms activity link to provider when using multiple providers?

texts: I'm testing out multiple sms providers, and I'm using the api to do reads for reporting on the back end, but I can't seem to figure out how the system knows which sms provider sent a particular sms. The Activity table doesn't seem to have  provider_id reference of any kind unless I'm missing it. Is it in an attached table or something? I can't find a list of providers either. Is that in the database?


texts: How can I enable self-serve sign in / check in to an Event?

texts:
I'm using Civi 5.31 on Drupal 7.
I want to enable self-serve check-in / sign in for an Event. Attendees should be able to click a link (and/or scan a QR code) to either RSVP for the Event, and receive a Status of Attended, or, update a previous RSVP with a Status of Registered to Attended.
Only attendees physically present at the meeting, or participating via Zoom, Jitsi etc will be given the link/shown the QR code to scan.
There is an existing self-service capability for participants to Cancel or Transfer a registration, and to set time limits for a 'window' within which to cancel or transfer. Self-serve check in / sign in could work similarly.

I know there are various ways for 'staff' or a meeting organizer to do this for all attendees, but I want to avoid the manual tedium of updating multiple attendees from Registered to Attended by allowing self-serve check-in/sign-ins.
Thanks!


texts: How can I get more details about a Scheduled Jobs failure?

texts:
I have discovered that I have had the "Disable expired relationships" job producing the following error.  Triggering the job manually yields the same result.

How can I find out more information about what is tripping up the system so that I can rectify the problem?

This is a Drupal implementation.

  2015-07-12 16:20:46    Disable expired relationships
  0
  Summary
  Finished execution of Disable expired relationships with result: Failure, Error message: Relationship is not valid
  Details

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

  Full message:
  Finished execution of Disable expired relationships with result: Failure, Error message: Relationship is not valid

EDIT:
While I had hoped that jumping into error logs would yield more information, the output of the following SQL statement was helpful to jump in and fix some errant data:

SELECT
  RELATIONSHIP.id as relationship_id,
  RELATIONSHIP.contact_id_a,
  RELATIONSHIP.contact_id_b,
  RELATIONSHIP.relationship_type_id,
  CONTACT1.contact_type AS contact_type_a,
  RELTYPE.contact_type_a as expected_type_a,
  CONTACT1.contact_sub_type as contact_subtype_a,
  RELTYPE.contact_sub_type_a as expected_sub_type_a,
  CONTACT2.contact_type AS contact_type_b,
  RELTYPE.contact_type_b as expected_type_b,
  CONTACT2.contact_sub_type as contact_subtype_b,
  RELTYPE.contact_sub_type_b as expected_sub_type_b
FROM civicrm_relationship AS RELATIONSHIP
LEFT JOIN civicrm_contact AS CONTACT1
  ON RELATIONSHIP.contact_id_A = CONTACT1.id
LEFT JOIN civicrm_contact AS CONTACT2
  ON RELATIONSHIP.contact_id_B = CONTACT2.id
LEFT JOIN civicrm_relationship_type as RELTYPE
  ON RELATIONSHIP.relationship_type_id = RELTYPE.id

I took the export of this into Excel and used the AND function to compare what contact types/subtypes were expected for each contact and what was really sitting in there. When I fixed the data, the cron job ran successfully.


texts: CiviMail Unsubscribe link goes to a generic/undefined Wordpress page

texts:
When the recipients of my mailing try to click on the "Unsubscribe" link the user is taken to a generic/undefined page that reads: "CiviCRM  Do not delete this page. Page content is generated by CiviCRM."  The user is also not marked as having opted-out of all bulk mailings.
The link generated is generated via {action.optOutUrl} which yields "http://besanthill.nfshost.com/civicrm?page=CiviCRM&q=civicrm%2Fmailing%2Foptout&reset=1&jid=244&qid=7847&h=0db2c5d63683bd63", for example.
I've looked at the suggestions on this post but the CMS base page and the permissions appear to be set correctly (that is, "access CiviMail subscribe/unsubscribe pages" is enabled for anonymous.)  And ideas?
Thanks in advance,
Richard


texts: How do I change an incorrect contribution status to Completed?

texts:
An EFT/ACH contribution was made last week via a Civi Contribution page with no price sets.  Normally EFT transactions go through just fine, but this one hit a snag and was marked Pending and then Failed by our vendor, iATS.  The iATS website gave a reject code I didn't recognize (113), so I inquired with their customer service.  Turns out it was an temporary communication issue with their system and the bank, and so the Failed status wasn't actually true.  It was a successful transaction.  iATS corrected the status in their system yesterday.

Our issue now is that Civi still says Failed.  I tried to edit the transaction via the Civi UI, but my only options now for the Contribution Status are Failed, Partially Paid, or Pending Refund.

Is there a workaround in the UI to edit this transaction and make it Completed?
Or do I need to edit the transaction in the civicrm_contribution table with the contribution_status_id field?  (It is currently 4; I would change it to 1.)
Are there any potential issues with changing the contribution status directly in the database?

Drupal 7, Civi 4.6, iATS extension 1.5.3


texts: Membership Expiration Date Report Filter is Ignored

texts: In CiviCRM membership reports, the Membership Expiration Date filter is ignored, and all records are returned no matter what parameters you try.  We started experiencing this around CiviCRM 5.11.  We are currently on CiviCRM 5.21.3 on Drupal 7.7.3.  Seems odd that no one else appears to have reported this after many months.


texts:
I would like to use a newsletter template from a different chapter. I am afraid if I edit the template it will change their settings they have in place. I simply just want to copy what they have and edit the text I will need for the Atlanta newsletter.

Thank you.


texts:
We have a contact in our database that is now deceased. We would like to maintain their historical records for archival use, but want to ensure that we stop sending mailings.

How do I identify someone in CiviCRM as being deceased?


texts: Searching in book.civicrm.org shows result titles without "field options". Also don't see anything for "option groups".


texts: New Member Form, how to change default setting of Record Contributions

texts:
When adding a New Member and selecting a membership type that is 'paid' the 'Record Contribution' checkbox is auto ticked.

I can see why.  However this organisation processes contributions in batch and only want then to apply when banked, so have to untick this on each new member.

I looked, but couldn't see and admin option to change this behaviour, is there one? Or is there a simple code based override to stop the auto ticking on that box?


texts: via api created only first particpant gets a line: "Contribution Amount: 1"

texts:
I register participants and payments via the API.
Step 1: create a contribution for the buyer
Step 2: create participants
Step 3 create participant_payments linking the above.

The weird thing is that civi adds a line to the fee_level of the first participant stating "Contribution Amount: 1".

Why? Am I doing something wrong?

Following the suggestion of Jon G I have been able to pin this down to something related to price sets. Participants of events that do not use price sets do not get this "contribution amount: 1"-line.

Kind regards,

Janec

The api calls:

1) create participant:

public function createParticipant($civiEventId, $contactId, $customFields = [], $amount, $currency, $fee_level) {
$entity = 'Participant';
// Create filter.
$params = [
  'event_id' => $civiEventId,
  'contact_id' => $contactId,
  'status_id' => "Registered",
  'participant_role_id' => "deelnemer",
  'participant_fee_level' => $fee_level,
  'participant_fee_amount' => $amount,
  'participant_fee_currency' => $currency
];
if (count($customFields) > 0 && is_array($customFields)) {
  foreach ($customFields as $customFieldKey => $customFieldValue) {
    if(is_integer($customFieldKey)){
      $customId = "custom_".$customFieldKey;
    } else {
      $customId = $customFieldKey;
    }
    $params[$customId] = $customFieldValue;
  }
}
$action = "create";

return $this->query($entity, $params, $action);

}

2) create contribution

public function createContribution($financial_type, $total_amount, $civi_id, $mollie_id, $date) {
$entity = 'Contribution';
$action = 'create';
// Create filter.
$params = [
  'financial_type_id' => $financial_type,
  'total_amount' => $total_amount,
  'contact_id' => $civi_id,
  'custom_100' => $mollie_id,
  'receive_date' => $date,
  'currency' => "EUR",
  'source' => "Chiro.be via mollie",
];
return $this->query($entity, $params, $action);

}

3) create participantPayment

public function createParticipantPayment($participant_id, $contribution_id) {
$entity = 'ParticipantPayment';
$action = 'create';
// Create filter.
$params = [
  'participant_id' => $participant_id,
  'contribution_id' => $contribution_id,
];
return $this->query($entity, $params, $action);

}

using version 4.7.27.


texts: Is there a fix? CiviCRM upgrade to 5.23.0 breaks payment processor

texts: On a Joomla! 3.9.15 system, after upgrading from CiviCRM 5.22.0 to 5.23.0 payment processing for fails for both paypal (credit card) and pay later options. When either is selected,  the request for additional information (e.g. credit card selection, billing address, etc) is not display and the 'submit' for the form no longer works (it gets grayed out). The work-around is go back to version 5.22.0 (with the 5.23.0 database). The payment processing and form submission then works.


texts: How do I setup Wordpress multi site with CiviCRM mutlisite?

texts:
To what degree does CiviCrm play well with Wordpress multi site installations?

More directly - If I have a multi site install, what is the best way for each 'org' website to seemingly have it's own CiviCrm instance?


texts: Ajax Error when trying to view relationships tab

texts:
Civicrm 4.7.1
Joomla 3.4.8

I'm unable to view data in the relationships tab. I get the following errors:

"DataTables warning: table id=DataTables_Table_0 - Ajax error."

And

"DataTables warning: table id=DataTables_Table_1 - Ajax error."

This issue has been ongoing since updating to 4.7.0

Any help would be appreciated. Please let me know if you need additional information.

Thanks.


texts: How do I create CiviEvents that occur in different timezones?

texts:
Our site will be host to many different events. Some will happen in meatspace and others online. However, they will all have participants from different timezones or be based in different timezones.

For example, a regular Social Lunch in Adelaide, Australia, a regular Public Lecture in Melbourne Australia and a regular online committee meeting with participants from (at times) more than 5 different timezones.

The current situation with CiviCRM and events are that they are displayed as the raw date and time they were scheduled at and a lay person would assume it's their local time. When in actual fact, it's been scheduled at the timezone of the Drupal7 site (Australia/Adelaide).

This means though, that I cannot set an event for Melbourne Australia, set it to display the correct time the event is occurring in Melbourne and have the ical feed give the correct time. I either have to schedule it at the equivalent Adelaide time (so that the ical feed is correct) or schedule it as if it were Melbourne local time but have the ical feed giving the wrong time.

Is there already a fix for this? If not, my organisation would be willing to commit funding to this issue.


texts: What permission are required to select an existing event location in CiviEvent?

texts:
We are using CiviCRM 4.7.19 with Drupal 7.56. When creating or editing a CiviEvent our super users can use an existing location from a drop down:

We also use another role in our organisation with more limited permissions but still enables event add/edit. However in the Event Location tab while they can enter an address the 'Choose Location' block is not visible:

What permissions need to be set to allow the choose location block to be visible when editing/adding a CiviEvent? (We use Drupal Access Control to set permissions for CiviCRM)


texts: What causes Completed PayPal payments to be logged in the "Accounts Receivable" account?

texts:
When I run the "Event Participant Report" and try to show "Total Paid", I'm getting $0 for "Total Paid" (or just the PayPal fee amount, but that's a separate bug).

The cause is that when people pay by PayPal, the to_financial_account_id in civicrm_entity_financial_trxn is set to "Accounts Receivable".  I'm not sure why this would happen for a payment that is completed immediately.  Is this a misconfiguration on my part or a bug?


texts: How do I change my organisation's address in a mailing?

texts:
I want to send out a civi mailing relating to a change of office address - the trouble is, the required {domain.address} refers to the old address and I can't see how to change this?

Is there a quick way?

Thanks,
James