texts: Can't get Pretty Workflow Messages to work

texts:
I'm trying to use Pretty Workflow Messages to prettify system messages, in particular the subscription messages.
I'm running CiviCRM 5.36.1 with PWM 1.2. I've created a special message template and selected this in the PWM settings but the subscription system message is still as plain as could be.
I've tried with just selecting other templates too, but no difference.
Using Joomla and Swedish, if that might make any difference...


texts: CiviCase case closed and remove remaining activities

texts:
On CiviCase, if you setup the standard timeline to be:

Open Case
Phone Call to Confirm Interest (offset, 2 days)
Setup Meeting (offset 7 days after phone call)
Case Closed

This example here will schedule the phone call and setup meeting on the case. If at the phone call activity, and person is not interested and case is closed, wouldn't the expected behavior be to remove the scheduled meeting out of the timeline? And/or, only show the "setup meeting" activity if the phone call is completed?


texts: we have about 1400 people in our database. All have email addresses and some have physical addresses. How can I sort/search so I can produce a list of those who have physical addresses? Once we have this list, is there a way to export that list to create mailing labels? Thanks in advance!


texts: What is the proper way to update to the recommended/supported version of Webform CiviCRM module for Drupal 7?

texts:
Here is what I'm trying to do. I'm trying to update to the latest version of the Webform CiviCRM, however, for right now the only way for me to update is to deactive the module and unistall it. I don't want to go that route.
What would be the best way for me to do it?
Thank you,
Kevin


texts: What tables are used for civicrm reports?

texts: I need to know what tables and fields are used for the CiviCRM reports, I've been dealing for several weeks trying to see why an updated site from CiviCRM 4.2 to 4.7.16 on Joomla is not showing any reports, I need to see if several tables changed or fields and where to look into why they are not showing up as they don't show any errors, they only show no result at all. Thank you.


texts:
Do somebody know if i can use Mandrill as mass mailing, or is there somebody who use Mandrill for mass mailings?
Are there other providers that are compatible with civicrm, for mass mailings?
Kind regards.


texts:
I'm trying to query the API on CiviCRM 4.4.6 for a Custom Field (Attachment) on a Case and an Activity.

I've tried the examples here: http://wiki.civicrm.org/confluence/display/CRMDOC/Using+Custom+Data+with+the+API
but couldn't get it to work.

I can see the custom fields available here;
SELECT * FROM civicrm_value_attachments_52

I can also see the entity_type for the case and file ID here:
SELECT * FROM civicrm_entity_file

What query do I write to extract the attachment for a case or activity?


texts: Paypal Payments Pro give 'Internal service Error' on checkout

texts:
I'm trying to hook up Paypal payments using Paypal Payments Pro.

I'm trying to use the sandbox and live payments account and I keep getting the 'Internal Service Error' on checkout. This happens when using the form and also the checkout button.

Can anybody point me in the right direction with this? Has anybody set this up themselves?

The live account is definitely active.

Would be good to know if anybody has this running correctly.  The account is a UK Website Payments Pro Account


texts: How to send one email to multiple contacts with separate individual follow-up activities

texts:
If I send an email to forty contacts, I can opt to generate a follow-up activity (eg phone call). That's great, except that it creates one single follow-up activity for all the contacts. I would like to generate separate follow-up activities, one for each contact, so that I can record the different sequences of activities which follow on the from the initial mailing. Is there any way of doing this?

Alternatively would it be difficult to duplicate the one follow-up activity (with forty contacts) into forty activities, each with one contact?

Thanks.


texts: I am running CiviCRM 4.7.18 in WordPress 4.7.4. For some time, the shortcode button has been gone. Even after re-installing CiviCRM/deactivating all other plugins I can't get it to show anymore. Has that feature been removed? Cheers!


texts: How to fix receipt/confirmation attached PDF alignment in email?

texts:
Civicrm email receipt/confirmation attach PDF files alignment issue.

We facing alignment issue in attached PDF file, Left side margin high and it is creating empty pages.

Which file needs to edit for this issue?


texts: What is the pattern used to name the fields accessible through the API?

texts:
I'm getting familiar with the API and having trouble understanding the pattern used to name fields.

A call like CRM.api3('Address', 'get') makes sense to me because the fields in the result are (1) named consistently, and (2) each named exactly as they appear in MySQL. I see things like street_address, location_type_id, and is_primary. I like this.

A call like CRM.api3('Activity', 'get') produces fields which make slightly less sense. I see subject and status_id which seem consistent. Good. But then I see activity_date_time and activity_type_id and become confused about why some fields are named with their entity as a prefix and some are not... But at the very least, all these field names are consistent with the column names in MySQL. Ok fine, I can live with that.

But then when I look at the same call for Contribution, I get even more confused. I see fields like contribution_check_number which seem to have an added prefix, not present from MySQL. Why?

And when I look at Participant, all the fields have a participant_ prefix. Huh??

Is there some sort of underlying pattern that can explain this madness to my logic-seeking brain?


texts:
Total noob here.

My client has installed CIVI on their Wordpress Site, Site 1, using the CIVICRM WP plugin which they are using to collect contributions. They have three other WP sites, different servers, where they'd like to collect contributions using the same database as Site 1.

Is this possible? If so, what is the best way to go about this? Is there a way to embed the CIVI contribute form on other sites?

Thank you for your help!


texts: Received the following error after creating contibution in backend

texts:
Please correct the following errors in the form fields below:
Select at least one option from Contribution(s).


texts: Updating Civicrm Activities with Drupal Webforms

texts:
We've been using Drupal webforms to create and update activities for contacts in Civicrm.
Ever since we updated to civicrm 4.6.18 (from 4.6.10), When the webform is submitted which is supposed to update a civicrm activity, it creates a new activity instead with a random date and a random contact as the "added by" name.
I've tested this on another site running 4.6.18 and the error only happens on my current site. I've disabled all the extensions and the error remains...

I enabled the date field in the Webform and set it to "now". When I enable "Update Existing Activity" It sets the date for may 23 2016. If I leave it disabled, the date field is set for today.

I'm at a lost where to look... any ideas?


texts:
I have about 5000 records of my org. To be a "member" of our org we measure that by "household" so therefore there could be two or more people in the household.(we provide free legal advocacy to these people).

We have a unique identifier being a member number. Each member number could have say two people under that one number, being a married couple.

I have used the import contacts feature in Civi to import "individuals" because if I import them as "households" there dosnt seem to be a name field for the household show up after import. ie it shows the address and city etc but "name" is blank and it dosnt assist our org by not having a member name to identify the household.

So i added individuals. My frustration at this program is that despite spending multitudes of time reading the documentation, i cant import the spouse name into the program that creates a relationship.

Is there any way to get assistance on this issue. Happy to share the csv of our database if it assists in comprehending our data.


texts: New Install Civi 5.4.0 getting Uncaught Symfony Rename Error and Blank Screen

texts:
I installed CiviCRM 5.4.0 locally under both Apache and IIS 6 (PHP 7.0) and did not get this error, but the every time I try to installing it using shared hosting (Everleap - IIS 8, PHP 7.0) the install fails with:

Uncaught Symfony\Component\Filesystem\Exception\IOException: Cannot rename "C:\home\site\wwwroot\wp-content\uploads\civicrm\templates_c\Cac3AA.tmp" to "C:\home\site\wwwroot/wp-content/uploads\civicrm\templates_c/CachedCiviContainer.e5d039483e5b5fef124d645e968cad32.php"

Now, I can verify that the file exists (Cac3AA.tmp) in the templates_c folder, so I know the install process created that file (has write access to the folder).  However, the rename fails.  Anyone see that before?


texts: Class 'CachedCiviContainer' not found in Civi\Core\Container loadContainer()

texts:
I am using CiviCRM 5.9 and Drupal 7.56 hosted in the pantheon server. Yesterday, suddenly my site went down. I have checked with drupal error log, it is showing

php error   : Class 'CachedCiviContainer' not found in Civi\Core\Container->loadContainer() (line 91 of /srv/bindings/242bbe6b8647492ab68ea8088fbf3044/code/sites/all/modules/civicrm/Civi/Core/Con

I thought it is related to caching, so I run clear cache and it worked.

but I couldn't get the exact reason for this issue. Please help.


texts: Multiple Memberships on one contact ID, different orgs?

texts:
A member has a life membership and now wants to add a second membership (a magazine subscription). I believe previously you needed to create a dummy organisation to house ("own") the second subscription. Is this still the case ?

Thanks.


texts:
I'm using the latest version of CIVICRM (4.7.12) on the latest version of Joomla (3.6.2). On the online subscription page (http://liberazioneanimale.org/index.php?option=com_civicrm&view=Contributions&task=civicrm/contribute/transact&id=1&reset=1&Itemid=941) I can't see the sum corrisponding to the Total Amount (Importo Totale).
I've created two Membeship Types, selected in membership tab, and added a Minimum Amount in Amount tab.
Can someone help me to understand what's wrong? thanks


texts:
I inherited an installation where a predecessor imported an email list of 70K records and populated the Contact Name AND the Email address with the email address.

How can I isolate, export, and remove them?

Warning: noob alert.


texts:
I'm writing a custom token in order to expose in the mail body the selected FROM address.
Is this possible?


texts: CiviMember Roles Sync is not working in Drupal

texts:
Drupal version 7.50

CiviCRM version 4.6.10

Hi There,

I activated CiviMember Roles Sync.

However when I clicked Configure, it does not show anything related to the module.

Has anyone experienced this kind of problem?

Thanks.

Sinarta


texts: Managing a smart mailing groups (un)subscriptions

texts:
According to
https://docs.civicrm.org/user/en/4.6/organising-your-data/smart-groups/

  Smart groups respect people's subscription preferences. If people
  unsubscribe from the newsletter, they will be removed from the smart
  group.

Are there ways to

see who unsubscribed from smart groups
manually unsubscribe members as an admin


texts: Exported related contact info for contact sub-type

texts:
We've got a site (4.6.11)

That has two organisation sub-types ("project" and "project event") there is a relationship between them (event of/ event is).

On running a search of project events, and using exported contacts to download specific project data- the related contacts option in the drop down has no relationship types listed under it.

On the 4.7 demo site, I've created a sponsor of/ supported by relationship between organisation sub types "Sponsor" and "Team", added contacts of each type and linked them with the relationship.

Again, I've tried to export team details with associated sponssor name, and under the related contact option no relationship types are listed.

I've had a quick look and can't find anyone else eon this board experiencing this problemm but woinder if this is related to this issue?https://issues.civicrm.org/jira/browse/CRM-15682 as reported here Why do the exported contacts differ from the contacts presented on the Advanced Search using Display Results as Related Contacts?.

On our live sute, I've run a relationship report and that shows the contacts I'd expect. I've not tried the same on the demo site.

Any ideas/ suggestions/ nuggets of wisdom?

Cheers

Craig

After posting all the above,  I though of a potential work round.

I had the notion that if I edited the relationship type to make it available for all organsiations, it may become available for export.

So I amended the relationship type on the live site.

I searched for contact sub type Project Event, chose export contacts and when I chose Record Type "Organisation" the eventof/ event is relationship options were available under select field> related contact info.

I selected the relationship type  event is and display name option, but on export the column was blank. I reset the export to select event of as relationship type and again the column was blank.

So basically that didn't work either.

Don't know if that, sheds light or obscures the options even further.


texts: Where and how do I 'check Drupal permissions' or 'set Drupal permissions'?

texts:
I find that I am often asked to 'check Drupal permissions' or 'set Drupal permissions' when, for example, I have added a new Component, like Civi Campaigns, Civi Cases, Civi Grants, or, have installed and enabled a new Extension.

But, if I am just getting started with Civi and Drupal, or have not changed my settings in awhile, I may not be sure what that means.

So, where and how do I check Drupal permissions or set Drupal permissions?


texts:
It seems that daily, my System Status page is giving me the following error:

Missing Log Tables
You don't have logging enabled on some tables. This may cause errors on performing insert/update operation on them.

I then create the log tables, error goes away - next day - repeat.

Two activities I did in past couple weeks might have triggered this

Upgraded PHP version from 7 to 7.1 - while I believe I selected all the proper modules/extensions - there may have been something I missed.
Updated from 5.3.1 to 5.6

Wordpress


texts: Error messages while setting up Event Calendars using Calendar and Views modules

texts:
Trying to set up some calendars on my website and running into trouble with both my theme screwing up the display and these error messages showing:

Notice: Undefined offset: 27 in calendar_plugin_row_civicrm->render() (line 135 of /home/***/public_html/sites/all/modules/civicrm/drupal/modules/views/plugins/calendar_plugin_row_civicrm.inc).

Notice: Undefined property: stdClass::$start_date in calendar_plugin_row_civicrm->render() (line 156 of /home/***/public_html/sites/all/modules/civicrm/drupal/modules/views/plugins/calendar_plugin_row_civicrm.inc).

Warning: Invalid argument supplied for foreach() in calendar_plugin_style->render() (line 305 of /home/***/public_html/sites/all/modules/calendar/includes/calendar_plugin_style.inc).

I am using the CiviCRM Events View that was installed by one of the involved modules. The events DO show on the calendar, and I CAN click on them to get to the event page. In other words, things appear to be working, but I can't get rid of these error messages showing up on the page.

Error is only showing up on current month, January. Ah - if i filter out all events prior to today's date, there are no error messages. So temporary fix, but I do want to be able to scroll back through the months and see past events.

Civicrm 4.6.11
Drupal  7.41

Would appreciate any suggestions. Thanks!


texts: How to import groups of contact and make it a new group

texts:
I am new in the CiviCRM community! As I am accustomed to closed-source CRM platforms, I have issues finding an answer to my need: I would like to import a group of contacts, and then make it automatically a new group so that I could email them.
It is possible and how?
Thanks,
Mathilde


texts: Sales Tax not added to total when memberships include donations that are separate transactions

texts:
We are having a problem with sales tax calculations when letting the user add an optional donation to a membership purchase or renewal. We need to separate the membership and donation into two transactions (selecting "Separate Membership Payment" on the membership tab of the contribution page) so that the the charitable donation receipt will be generated.  If we don't separate the payment, the sales tax is computed properly -- but then we can't generate a charitable donation receipt.
When we separate the transactions, the sales tax is not added to the membership purchase, but it does appear on the receipt but is not added or charged.
On the contribution page:

Financial type is set to Donation - that type will generate a charity receipt, but no sales tax
"Contribution Amount section enabled" is selected to let the user enter a donation with membership, with "allow other amounts" selected so that they can enter what they want
"Separate Membership Payment" is selected, as described above

For example, if we select a $90 membership that needs $11.70 sales tax with an $100 extra donation:
Receipt 1 (for membership), shows sales tax but it is not added to the total:

Receipt 2 (for donation) shows no sales tax and is correct:

I have tried the patch but that didn't make a difference.
I am using WordPress 5.5.1 and CiviCRM 5.29.1 with CiviMember and CDN Tax Receipts extension.


texts: Cannot create Drupal user, email: invalid!! (double exclamation is the error message, not my urgency)

texts:
Drupal 7.72
Civi 5.24.5
Webform Civi Integration 7.5.1
I just set it up so that Drupal users are created when a webform is submitted. Using petednz's guide.
But I get the following error message Cannot create user, email: invalid!!
What would cause Cannot create user, email: invalid!! on an civicrm integrated webform? This has the same problem. I tried both suggestions there and it did not fix it for me.
I get the following 2 messages in my Drupal logs:

rules 08/16/2020 - 20:39 Unable to get variable civicrm_user, it is not defined
civicrm_entity 08/16/2020 - 20:39 Cannot create user, email invalid.

I use CiviRules to add a tag to the contact when a new contact is added from "these" Sources. Should the tag be added in a different manner? The guide was not clear on how to add the tag to the contact. I'm wondering if the Rules is firing before CiviRules gets the tag added.


texts: How do I troubleshoot a CiviMail / Mail report?

texts:
I have a mail report that we use on our dashboard that is just taking forever to load. Using developer tools, I can't seem to figure it out.
[DOM] Found 2 elements with non-unique id #_qf_Summary_submit: (More info: https://goo.gl/9p2vKq)  /civicrm/report/instance/33?reset=1&output=criteria:1
The only thing I can find in the logs is [warning] Deprecated function CRM_Core_BAO_Cache::cleanKey, use CRM_Utils_Cache::cleanKey but I think that is unrelated.
It takes about 5 minutes to load a report of 28 emails.


texts:
I have a multisite WordPress setup with CiviCRM 4.7.23 and I am unable to create a successful cron job. I tried CLI with all parameters (including -s) and with no parameters but each time I get no output and CiviCRM says cron was not executed.

I tried the URL method

https://mysite.org/wp-content/plugins/civicrm/civicrm/bin/cron.php?name=XXX&pass=XXX&key=XXX

and same thing.

I tried, just for fun, the cli file via a browser and I got

  cli.php can only be run from command line.

which is at least correct. :)

The site in question is hosted on CiviHosting and the setup there is known to support both CLI and URL cron jobs for single-site setups.


texts: I'am a totally beginner. After signing-up to CiviCRM Spark for evualating I expected the web-Site to be in German, but it's all in english.  How Can I change the language to German?


texts: Error printing event badges after sorting by participant name

texts:
We need to print event badges in alphabetical order instead of the date registered order that you initially get from a participant search.  The PDF creation completes successfully with the default sort, but after changing to alphabetical order, you get a yellow screen DB Error: unknown error.  Is there a way around this?  Thanks!

We are on CiviCRM 5.4.0 on Drupal 7.63


texts: Adding individuals' event attendance as activity for employer?

texts:
Is it possible to set up Civi so that when an individual attends an event, it also shows up as an activity for their employer?

I'd like to be able to get an overview of how many people from an organisation attended (or spoke at) events alongside the other meetings, phonecalls, etc attached to that organisation's Activities.

Or would I have to create a custom report for this?


texts: CiviEvent - How to Template Profile Fields and Price Set Questions In Custom Groups

texts:
Is there any way to edit a CiviEvent template where I can take price set fields and put them in groupings with specific profile fields (from included profile)?

Reasoning - we are collecting data, which would go into Profile fields. We are also collecting Fees that correspond to those profile fields.

I want it to be grouped like

Profile Field 1 a
Profile Field 1 b
Price Set field 1

Profile field 2 a
Profile Field 2 b
Price Set field 2

Currently I am using jQuery .insertBefore and .prependTo to accomplish this, but it just seems ugly?

Thank you!

Sometimes questions should be right next to the Price Set option on the form - hence our need.


texts: Transfer Database to new location raised MySQL Error function already exists

texts:
I follow the instructions here https://wiki.civicrm.org/confluence/display/CRMDOC/Moving+the+database+using+phpMyAdmin

I want to import the so called Old_without_five_tables.sql with phpmyadmin in the civicrm database but I get the following error:

SQL query:

- Datenbank: `civicrm`
--

DELIMITER $$
--
-- Funktionen
--
CREATE DEFINER=`civicrm`@`localhost`
FUNCTION `civicrm_strip_non_numeric`(input VARCHAR(255) CHARACTER SET utf8) RETURNS varchar(255) CHARSET utf8
   NO SQL
   DETERMINISTIC
BEGIN
  DECLARE output   VARCHAR(255) CHARACTER SET utf8 DEFAULT '';
  DECLARE iterator INT          DEFAULT 1;
  WHILE iterator < (LENGTH(input) + 1) DO
    IF SUBSTRING(input, iterator, 1) IN ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9') THEN
      SET output = CONCAT(output, SUBSTRING(input, iterator, 1));
    END IF;
    SET iterator = iterator + 1;
  END WHILE;
  RETURN output;
END$$

MySQL said:

  #1304 - FUNCTION civicrm_strip_non_numeric already exists

I am using:
civicrm 4.7.3
drupal 7.26

thanks so far


texts:
The membership cannot be saved because the status cannot be calculated
  for start_date: 20160425 end_date 20170424 join_date 20160425 as at
  2017-09-25 13:54:10

This error message shows when a user, with recorded start and end dates of membership in expired status tries to renew their membership.

Perhaps status rules need some work or there is an issue with memberships that occurred before upgrading to 4.7.x version of the CRM. Here is a screenshot of the status settings:

Note: I know this may be a duplicate question but I wanted to provide more information than than the other posts to see if we can resolve all of them.

Using CiviCRM 4.7.15 on Drupal 7.x


texts:
I need to add to my CRM object which are neither Individual/Household/Organization.
In my case an example would be embryos which relate to their parents (yes, in fertilization process) which have many attributes but none of the individual's (they don't have names/phone/address/skype etc).

thanks


texts: CiviMail click tracker URL includes web root

texts:
When composing CiviMail messages and enabling click tracking, CiviCRM is building URLs like http://example.org/public_html/wp-content/plugins/civicrm/civicrm/extern/url.php?u=106&qid=6870. public_html is the name of the web root and should not be part of the URL. Worth noting is that other CiviCRM-generated links (i.e., unsubscribe and opt-out tokens) are built correctly.

I have checked and rechecked my directory and path settings, and they appear to be correct. I have "fixed" the issue with an Apache rewrite rule, but I can't help feeling like:

I'm missing something obvious
I've found a bug

Any thoughts?


texts: Report: Records that have been updated by owner

texts: Is there a way to go through and create a report (either in Civi or using Drupal Views) that shows what records have been updated by the owner themselves? Such as them going in and updating an employer or address?


texts: Event Template - can I increase the maximum number of participants value?

texts:
We run training sessions on behalf of 3rd party organisations who source the attendees.  I'd like to be able to allow them to login and enter the participant details for all of the attendees - up to a max of 25 - is this possible?

I found an old thread about code-hooks, but I have no idea how to do this.  I was hoping that this would have been a configurable value hidden in a config file or DB somewhere...? Thanks, Joe.


texts:
I am having two issues w/ the REST api via curl.

1) API is ignoring json attribute.   If I do not urlencode, I get a "Unable to decode supplied JSON" return msg.   When I do encode, as shown below, I get past issue, but it seems to ignore any of the conditions set in json attrib.  It just return all contacts,  w/out restricting by external_identifier or applying return filters set in json object.

$curl_post_data = [
    'debug' => 1,
    'version' => 3,
    'entity' => 'Contact',
    'action' => 'get',
    'json' => urlencode (json_encode ( ["sequential"=>1,"return"=>"id,do_not_mail","external_identifier"=>777] )),
    'api_key' => '1234',
    'key' => '1234',
];

If I take out conditions & filters out of json attrib, it works fine :

$curl_post_data = [
    'debug' => 1,
    'version' => 3,
    'entity' => 'Contact',
    'action' => 'get',
    'json' => 1,
    'api_key' => '1234',
    'key' => '1234',
    'external_identifier' => 777,
    'return'=> 'id,do_not_mail'
];

However, everyone else seems to be using this json attrib. I would like to get that working.

2) Second issue is chaining.

$curl_post_data = [
    'debug' => 1,
    'version' => 3,
    'entity' => 'Contact',
    'action' => 'get',
    'json' => 1,
    'api_key' => '1234',
    'key' => '1234',
    'external_identifier' => 777,
    'return'=> 'id,do_not_mail',
    'api.Contact.create' => urlencode (json_encode(['do_not_mail'=>0]))
];

Using api.Contact.create / replace, etc will trigger an undefined field error : undefined_fields":["api_Contact_create"].

I am json_encoding the field value in this example, but get the same issue by just passing an array.   It just doesn't seem to recognize the chaining directive at all.

Any help much appreciated.


texts: I have installed CiviCRM successfully for WordPress. However, the Civi dashboard shows many 404 errors. My install directory is content/plugins/civicrm and the dashboard is searching for wp-content/plugins/civicrm. I am not able to find a setting that tells Civi where to look for the content directory. Is this something that I can modify?


texts:
Unable to download from site http://www.civicrmfr.org/

"The requested URL /civicrm-{{stable}}-joomla.tar.gz was not found on this server."

But OK on Sourceforge.
Cheers.


texts: If statement not working if the smarty variable is not set

texts:
I've been trying to figure this out for myself but I am super frustrated at this point! I've got smarty variables and conditional statements working in thank you letters. Well kind of working. Basically I'd like to include the contribution note if the note field is filled in, if it's not show the text "None". I can get the note to display but no matter what set up I've used I can't get it to show "None". I have two donations one with a note, one without. Here is what I've tried so far:

{if $note.note}I'm a note{/if} // works as expected
{if !$note.note}None{/if} // does NOT show the text none as expected

{if $note.note neq""}I'm a note{/if} // works as expected
{if $note.note eq""}None{/if} // does NOT show the text none as expected

{if $note.note}I'm a note{else}None{/if} // outputs "I'm a note" on contribution receipt with a note but still nothing on the contribution that has no note.

{if !$note.note}None{else}I'm a note{/if} // outputs "I'm a note" on contribution receipt with a note but still nothing on the contribution that has no note.

I've also tried capturing a smarty variable and then using it in the if statement.

{capture assign='note_text'}None{/capture}
{if !$note.note}{$note_text}{else}I'm a note{/if} // "None" is still not displayed as it should be.

Can anyone shed some light? (I'm sure a suggestion will be is to write some hook or custom token with this logic already worked in. But I'd really like to know why the if statement isn't working as straightforward as I'd imagined it would. I'd like to use more if statements for mailing labels etc and if I can't get an "else" to work that's a problem.)

(Wordpress 4.4.1 and Civi 4.6.4)


texts: In Wordpress, I want to convert my installation from an external database to use the default database

texts:
I am using CiviCRM on WordPress and I am moving my hosting to WP Engine - where I have all of my other sites hosted.  Unfortunately, I set this instance of CiviCRM to use a separate database, however, WP Engine only supports one database per install.  I am trying to convert my existing CiviCRM install to use the default WordPress database before I migrate the site to WP Engine.  Is this possible?

If I can't convert the install, can I create a new install (using the WordPress database) and IMPORT the data from the old site?


texts: Upgrade to CiviCRM 4.3 failing on DROP FOREIGN KEY

texts:
I have successfully upgraded many other CiviCRM installations over the years, but I've been unable to work my  way through this issue so far.

Ubuntu 14.04
MySQL 5.7.23
Apache/2.4.7
PHP Version 5.6.37
Drupal 7.59
CiviCRM 4.2.20

I am trying to upgrade CiviCRM 4.2.20 to 4.3.11. Ultimately the goal is to get to 4.6 LTS. I have tried repairing the CiviCRM schema (this database has only 2 custom fields), and I've also tried the SET foreign_key_checks = 0; work around on importing the db, but I've still been unsuccessful at upgrading. I always hit this error at the stage of:

  [Error: Upgrade DB to 4.3.alpha1]

  ALTER TABLE civicrm_membership_type DROP FOREIGN KEY
  FK_civicrm_membership_autorenewal_msg_id [nativecode=1091 ** Can't
  DROP 'FK_civicrm_membership_autorenewal_msg_id'; check that column/key
  exists]

I found a helpful thread somewhere that suggesting that MySQL 5.5 may have been the culprit, so I upgraded to MySQL 5.7, and still get the exact same error regardless of MySQL version. I have a fresh export and backups, so every time I try something it is with a fresh working version of the database on 4.2.20. Any help is greatly appreciated!

Thank you,
--Tony

Update
Based on Jon G's suggestion I tried commenting out the offending lines in CRM/Upgrade/Incremental/php/FourThree.php, reloaded a fresh database for upgrading, but still continued to receive the exact same error.  The only difference this time being, after I hit refresh to try and force the upgrade to continue, then another message occurred:

  ALTER TABLE civicrm_premiums ADD COLUMN
  premiums_nothankyou_position int(10) unsigned DEFAULT '1'
  [nativecode=1060 ** Duplicate column name
  'premiums_nothankyou_position']

I couldn't grep any more lines to comment out of the FourThree.php upgrade file, and wasn't sure how this would affect database integrity. The suggested threads (CRM-12458, CRM-11260)  seem to relate, but I was ultimately unable to use the information to solve this issue, admittedly due to the lack in my technical understanding.


texts: Since upgrade to 5.34, Drupal accounts are not being created when a member signs up

texts:
This morning, I updated my dev sites from CiviCRM 5.25 to 5.34 and since then, I have found that Drupal accounts are not being created when a member signs up in CiviCRM.
We have a page for signing up for a membership, here - https://civi.artspan.org/civicrm/contribute/transact?reset=1&id=3
On the live site, if someone fills out this form, a Drupal account is created for them and they are automatically logged in.  On the dev site, only a CiviCRM account is being created.
Nothing has changed between these two sites except for the CiviCRM update.
Under the profile settings for that form, "Drupal user account registration option? is marked as "account creation required".


texts:
I am the new coordinator for Huntingdonshire Green Party (previously I was the deputy coordinator), My wife is the membership secretary. Until tonight, both of us were able to access Civi and send emails to the membership & supports of our local party (Huntingdonshire Green Party). Tonight, we cannot.

The only difference is that we have both drifted into "grace" membership (by accident and both of us has resolved this by re-subscribing) but I as we have the Civi roles, I would not expect that to affect our civi access level.

Is this the issue? Or is their a wider issue?

Regards,
James Goodman


texts: How to prevent a double enrollment in an event of the same participant.

texts:
We are using our CiviCRM to enroll participants from the office (not online), nonetheless the platform allows to enroll the same contact twice in the same event.  We are using CiviCRM on Druppal. I test the problem in the demo: http://d46.demo.civicrm.org/civicrm/, and it also occurs in the demo.

Is there any mechanism to prevent double enrollment in an event?

Thanks in advance.

Please be aware, that this question is similar to other question, but the other was related to online enrollment, and my question is related to enrollment through the platform itself.


texts: List organization on individual profile signup

texts:
I am creating a join form for visitors on our site, and I'd like to give them the option of adding what school they go to.

I've imported schools as organizations, and I think I know how to link individual contacts to "Student of.." the school when I import our list, but going forward how do individuals link themselves to particular schools when they sign up?

I'd like for them to be able to type in the name of the school and be presented with suggestions (to try and avoid creating duplicates with spelling differences).

Any idea how to do it?  Thanks!

I've got CiviCRM 4.7.25 and am using Wordpress.


texts: How can webform load billing block information for a specified user?

texts:
The context is a staff member taking a phone call from a member and then filling in a webform including a payment for them.

The webform is added to the actions menu so the webform is passed '?cid=XXX' to load the contact.  The problem is that when it comes to payment (by Stripe), the billing block is loading the details of the person filling in the form, not those of the person on the phone.

How can webform be configured to use the details of the contact on the form?  Answers involving code writing are fine:-)


texts: What are the best arguments to start using CiviCRM

texts: From time to time I get the question about recommending CiviCRM to others. When recommending CiviCRM to others, what would be on the top of the list as the best "advantage"?


texts: How is it possible to delete a contact with the edit permission for a group?

texts:
I have a user and want to give her limited access to contacts. She is supposed to view all contacts but create/edit/delete of only one specific group.

I gave her Edit permission via ACLs fot that group. She can edit the contacts in the group but the Delete operation does not appear for those contacts.

I cannot give Delete access via Magage ACLs because only View & Edit permissions are selectable for a group of contacts.

What can I do? Is it a bug or am I missing something?

[For creating a new contact, I disabled adding a contact in general and created a specific profile with a new contact form for her, that adds the new contact to that group - this works fine. She, however, cannot delete what she has created.]

CiviCRM version 4.7.11 on WordPress 4.7.2.


texts:
I would like to edit my list of existing locations for events. We have several locations with the same name that we don't longer use so it gets confusing. Is there a way I can remove these from the list of existing locations?

Thanks.


texts: Set custom field during Membership signup through a Contribution Page

texts:
I need to save some additional information related to the membership during sign-up. This will be stored in custom fields of the membership. Sign-up (Membership creation) is happening through a Contribution Page which includes a Profile with those custom fields.

The Profile does not transfer the values from the custom field into the custom field of the newly created Membership.

Previously I used (Drupal Module) custom code and the civicrm_api to update the membership. However, nowadays I don't seem to be able to get the contributionID and membershipID values from the $form->_params array anymore.

How can I add custom fields to a Membership from a Contribution Page?


texts: Civicrm 4..6.10-drupal is missing directory CRM/common

texts:
Upgraded from 4.1.15 to 4.6.10 with no errors, setup file system ownership & permissions, cleared template_c cache, ran drush cvapi system.flush
Working but layouts are wrong and the log file contains errors with
"User warning: Smarty error: unable to read resource                                     : &quot;CRM/common/action.tpl&quot; in trigger_error() (line 1094 of ../sites/all/modules/civicrm/packages/Smarty/Smarty.class.php).

Directory modules/civicrm/CRM does not contain a common directory.


texts: How do I move a contribution from one contact to another?

texts:
The site admin accidentally assigned an Event payment to himself - how do I move the contribution to the correct contact? I understand that insofar as it's an event, it's not as simple as changing the contribution contact ID in phpMyAdmin.

I would think this would be a common request - any suggestions? Thanks in advance!


texts:
Can someone please verify that the API for contact>duplicatecheck is actually working?

In my case the UI will return 8 dupes, but the API will not return any.

It seems to be broken as of late. From what I understand, running duplicatecheck without any parameters from the API explorer "should" return all duplicate contacts using the default unsupervised rule (for individuals). I have checked the official sandbox for drupal and it does not appear to work either.

If you can get it working, can you please supply the PHP code that worked?

Thanks!


texts: No instantiation of Case tokens in mails sent by CiviRules

texts:
I am trying to send emails (with case tokens) with CiviRules but I do not get the tokens instantiations.
The environment: I use CiviRules, Compucorp CiviCase. I have activated email Api extension, Civicase tokens.  And I have the last available versions. I am on Wordpress 5.7.1. And CiviCRM 5.36.
The rule: Trigger of the rule is "case activity added", mails are sent to target of this activity and to a role (case coordinator) of the case. In the mails templates I have case tokens (subject and custom fields).
The result: Rule is triggered, mails are actually sent to the activity target and the role. The role is therefore recognized (he gets the mail, without the tokens instantiation). Case Tokens are not resolved.
When I send the mail (same template) manually inside the case, then the result is ok.
Very puzzling!


texts: Can Quick Search be set up so External ID does not have to be exact match to work?

texts:
Tested on dmaster.

Give Contact external ID eg fz123456

then set QuickSearch for External ID and enter

fz123 - no result
fz1234 - no result
fz12345 - no result
fz123456 - yay

Ah, see this applies to Internal ID too, namely

2 - Muller
20 - ah.olsen@
202 - demo@
2% - Muller

Can you reset QuickSearch so these match with wildcards?


texts: Getting active relationships using the API is returning contacts in trash

texts:
I'm doing this call

$result = civicrm_api3('Relationship', 'getvalue', [
  'return' => "contact_id_b",
  'relationship_type_id' => 5,
  'contact_id_a' => "user_contact_id",
  'is_active' => 1,
]);

It is returning contact B from contacts that are in trash.

I want to filter for contacts that are not in trash but struggling to find a way of doing it.


texts: I created a discount for a specific membership level, but a discount field is not showing up on the membership page.  CiviDiscount is enabled and has worked in the past with event registration.  When creating the new discount, I specified the membership type (annual) in the 'Discounts for Memberships' box. Do I have to specify a price set? If so, how do I do that? Nothing I type is accepted.


texts: How can i add some custom css to a message template? I want to add it to the header. Is there a file I can edit?


texts: Adding another option to the Source drop down box

texts: Using webform civicrm, how can one add another source option to the wizard?


texts: How can I set up registration and payment for an ongoing event that happens every saturday

texts:
the event happens every Saturday of the year, rain or shine with a limited participant number.

The fee is based on household so many people can be registered under one registration.  So I'd need to sign up several people to one payment.  But also have the event close once he max participation is reached

Thank you!! :)


texts: Within a new extension, in a form's postProcess function, I am inserting into a non-Civi table (separate mysql database/table). What is the proper way to execute a MySQL insert statement and retrieve the new id from that insert using CRM_Core_DAO?  I use executeQuery for selects, and can use it to run the insert as well, but not sure that's the best way and not sure how to get the id back.


texts:
I created a public list (directory) of members based on a relationship.  I was able to set-up a smart group with a profile and can see the list. But I want to customize the list by country, without creating a profile for each country. I read that you can append the url like this:  civicrm/profile&reset=1&force=1&gid=N&city=London

But it is not working.  What is the field name for countries?  Are country names stored as an integer or a text value such as France?  How do I get a list of fields and values for CiviCRM? Thanks for your help.


texts:
I'm trying to set up the CiviMail return channel, and expect that, if I do it properly, headers like Reply-To and/or Return-Path will have values like bounces+verp-stuff@mydomain.com, but so far, that's not happening.

What I've done so far:

Created an email account bounces@mydomain.com through Google Apps, and verified it receives an email sent to bounces+123@mydomain.com
Edited the default mail account at /civicrm/admin/mailSettings?reset=1, with values (server, username, password, protocol, use ssl) that allow it to check email over IMAP on the bounces@mydomain.com and verified that some messages in that account get labeled with the inbox-civimail-ignored.
Also at /civicrm/admin/mailSettings?reset=1, set "Email Domain" = "mydomain.com" and "Used For?" = "Bounce processing".  Other fields in this form are blank.
Outbound Email (/civicrm/admin/setting/smtp?reset=1) is set to "mail()"

I then create a new scheduled mailing and send it out using the "Send Scheduled Mailings" job, and the mail arrives with these headers:

Delivered-To: me@example.com
Received: by a.a.a.a with SMTP id x3csp113516itf;
        Wed, 29 Jul 2015 10:06:44 -0700 (PDT)
X-Received: by b.b.b.b with SMTP id o40mr63319942qga.0.1438189604113;
        Wed, 29 Jul 2015 10:06:44 -0700 (PDT)
Return-Path: <b.94.15.1ff1d88a496eafde@mydomain.com>
Received: from mydomain.com (mydomain.com. [c.c.c.c])
        by mx.google.com with ESMTP id g9si32260106qgf.41.2015.07.29.10.06.43
        for <me@example.com>;
        Wed, 29 Jul 2015 10:06:44 -0700 (PDT)
Received-SPF: pass (google.com: domain of b.94.15.1ff1d88a496eafde@mydomain.com designates c.c.c.c as permitted sender) client-ip=c.c.c.c;
Authentication-Results: mx.google.com;
       spf=pass (google.com: domain of b.94.15.1ff1d88a496eafde@mydomain.com designates c.c.c.c as permitted sender) smtp.mail=b.94.15.1ff1d88a496eafde@mydomain.com
Received: by mydomain.com (Postfix, from userid 33)
    id D96011442D; Wed, 29 Jul 2015 17:06:43 +0000 (UTC)
To: Two Mice <me@example.com>
Subject: test 6fd
X-PHP-Originating-Script: 1001:mail.php
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="=_10b250b1b5a6af786cd9e0315548c9d9"
Reply-To: "My Site"
 <info@mydomain.com>
From: "My Site" <info@mydomain.com>
List-Unsubscribe: <mailto:u.94.15.1ff1d88a496eafde@mydomain.com>
job_id: 94
Precedence: bulk
X-CiviMail-Bounce: b.94.15.1ff1d88a496eafde@mydomain.com
Date: Wed, 29 Jul 2015 12:06:43 -0500
Message-Id: <20150729170643.D96011442D@mydomain.com>

--=_10b250b1b5a6af786cd9e0315548c9d9
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=utf-8

Suspecting that our postfix setup might be messing with the headers, I set Outbound Email (/civicrm/admin/setting/smtp?reset=1) to "Redirect to Database", then created a new scheduled mailing and sent it out.  The mail was stored in the civicrm_mailing_spool table with these headers:

MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="=_6f3fb5f7026a6aecc8d6a73af912a390"
Reply-To: "My Site"
 <info@mydomain.com>
Return-Path: b.100.16.af889b4c23dd0331@mydomain.com
From: "My Site" <info@mydomain.com>
Subject: test 7
List-Unsubscribe: <mailto:u.100.16.af889b4c23dd0331@mydomain.com>
job_id: 100
To: Two Mice <me@example.com>
Precedence: bulk
X-CiviMail-Bounce: b.100.16.af889b4c23dd0331@mydomain.com | --=_6f3fb5f7026a6aecc8d6a73af912a390
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=utf-8

Question: What else should I do to get bounces to be directed to my bounces@mydomain.com address?


texts: Why am I getting Javascript errors/ unable to save when creating a new mailing?

texts:
Trying to figure out why I keep getting javascript errors and not being able to save when trying to create a new civimail mailing on WordPress / CiviCRM 4.7.27. It is a fresh install. Not sure what is going on.

Anybody have any good ideas on why this may be happening?


texts: Upgrade to 5.9.0 - 'From' address for e-mail confirmations has changed

texts:
Following our upgrade to CiviCRM 5.9.0, the 'from' address for event registration confirmations has changed to "7306@civi.acenterprises.org.uk"

It should be ""Ian Foster" " - and this is what still appears in the list of 'From' addresses in CiviCRM settings.

I've looked at contact ID 7306, in case it is a contact ID, and they have no significance in our system.

Baffled!  Any thoughts? Thank you.


texts: Looking for Webform Calculator Experience

texts:
Has anybody experienced Webform Calculator Module with civicrm ?

Could it, for instance, enable conditions such as :

if field1= YES, then field3 = field2

or

if field1= YES, then field2=field2+30

Should (or can) field1, field2, field3 be civicrm field, or simple webform fieldsets ?


texts: CiviDiscount: How do I disable the automatic member discount for additional participants?

texts: I was disheartened to learn that the automatic discount I created to give members a discount off the conference registration fee applies to other participants the member registers even though they are not members. I think the same goes for if the member isn't registering themselves but someone else--if they are logged in as a member, the discount applies for whoever they are registering, even though they are not members. Does anyone know how to be more restrictive with the discount code so it only applies to the member, and not their plus ones? We are using CiviDiscount 3.3.


texts: How to remove a financial type from profile is already created and data is submitted?

texts: By mistake I have included a financial type while creating a profile which should not have selected. Now if I go to settings of profile now its disabled. How can I get it enable again? or a way to remove irrelevant financial type Please?


texts: Is it possible to show CiviMails within our Drupal CMS system?

texts:
When CiviMail gives a permanent link to a public mailing it simply creates a raw html page for the email. Eg, on a link like this: civicrm/mailing/view?id=1528, we see the mailing exactly as it was sent out, and the html code of this page is exactly what was sent out in the mailing.

Thus the public view of the email is outside of our CMS, and doesn't benefit from our website's navigation menus, branding or any of the features our CMS provides.

We're using Civi 5.13 and Drupal 7.68... and it would be great if it were possible to put the public view of the mailings inside of Drupal's page construction, rather than outside it.

I can see how this would be possible using Views... but is there a more obvious way that I'm somehow missing?

Thanks for your help.


texts:
I've just updated a multi-site with the latest Stripe extension and I get the message to update the webhooks. Did this on another site earlier I was able to just follow the links and it updated as it should.

However on this site, when I try to click on https://mysite.org/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fstripe%2Ffix-webhook it redirects to either the homepage or the admin page (depending on whether I followed the link via the system status page of the admin menu).

Is there a way I can set this manually?

Related to this, I have a membership webform taking payments and it's not recording the payment or membership when I test it - I'm assuming it's because it's the webhooks are not updated?


texts: Insert tokens in subject of print/merge document

texts:
I'd like to add {contribution.receive_date} in email subject in "Print/Merge documents" action (Thank-you Letter for Contributions (PDF)), but there is not tokens selector.
I prefer to send an email with an attached letter to my donors every week to to thank them for their donation.
Is there any way to insert tokens in the subject? Or should I use another method?
Thanks


texts: Is there a limit to how many activity types we should create?

texts:
We use Schedule Reminders to set up email series for a very wide range of interest groups. With conditional funnels using smart groups, like Mailchimp conditional campaigns.

The easiest way to initiate these Schedule Reminders is from activity types, but we've hesitated to make an activity type for every new event or campaign since we'd soon have many hundreds. Instead we make activity types that cover generic topics and then use groups to limit which people will receive schedule reminders. It's a bit of a dangerous method - if you forget to limit a schedule reminder to a group you could send out emails to many people who haven't asked for them!

So... would there actually be any impact in terms of performance if we were to have many hundreds - perhaps eventually a thousand or more - activity types?

Thanks for your thoughts!


texts: Display related organization information using a profile

texts:
What is the best (or recommended) way to display related organization information in a profile?
I use organizational membership so after registration I have an individual record (with Drupal account) and an organization record (related to the individual).

I use Civi profiles to display stored information to my users. It's easy and straightforward when showing the individual's own data. But a profile that shows the related organization's data is what I'm looking for - right now the profile shows empty fields.

I came up with one solution: if I add id=[org_contact_id] to the profile view url, everything is OK. To get Drupal to generate proper link in menu, I'm planning to use menu hook and through CiviCRM API find user's related organization contact id. It seems complicated though (for such a simple task).

Is there an easier way to do that?


texts: How can I access an activity's grouping value in CiviCases?

texts:
I've only started trying to change some features of an existing CiviCRM database in a testsystem (using CiviCases). So I am still a beginner, I excuse myself if this is a silly question, and any hint will be appreciated :)
I want to include a feature that will exclude all the activities with the grouping value "system" from the case view. Right now, the case view is spammed with activities not relevant to the users (for example, "Case type changed from ... to ...").
The activities are given this grouping value in a table called civicrm_option_value.
So I suppose I have to include some filter into the file /civicrm/CRM/Case/Form/CaseView.php, accessing each activity's grouping and testing it for "system".
Can you give me any hint how I can access the activities' grouping value?
Thanks in advance,
emma


texts:
Is there a way to schedule the same email to a group each week?  It's a reminder for a meeting we run.

Steve


texts: Event registration form loses 'id' url param and then throws an exception

texts:
I am running CiviCRM 5.10.0 on Drupal, and I see the following scenario happening, very consistently:

go to one of my event registration forms: https://www.terranova.tamera.org/de/civicrm/event/register?reset=1&id=1994
submit the form although many required fields are still missing.
Form refreshes with all validation errors. Notice that the url has changed and lost its 'id' param, for the current event.
complete the registration form correctly and try to submit again.
Receive an error saying:
Sorry, due to an error, we are unable to fulfill...
Could not find valid value for id


texts: Can Omnipay ( Paypal Checkout ) be used with membership signups / contributions using a CiviCRM Webform?

texts:
I've been able to setup and configure Omnipay using Paypal checkout without issue.

However, I seem unable to use it with Civicrm webform to take membership payments.

The only reference to it can find is a comment on the announcement post in July that there are issues with it, does anybody have anymore information on support for it?

https://civicrm.org/blog/eileen/announcing-paypal-checkout

Thanks in advance for any help or workarounds.


texts: How to programmatically open the option modal and listen to changes?

texts: I would like to open such a modal programmatically and then listen to events related to this modal (such as "option created", "option updated", "modal closed" etc). I tried to look at the CiviCRM source code but could not find API for that. Is there such a possibility?


texts: Is there a "best" forum for suggesting improvements to CiviCRM?

texts:
As a developer, when I have an idea for a feature improvement to CiviCRM, and am interested in helping to make that happen (submitting a patch and tests, for example), what's the best place to start a conversation about things like a) whether it's a good idea, b) how it might be made into a better idea, c) whether it's likely to be desirable in core or better as an extension, etc.?

Channels I can think of include these, in no particular order:

One of the lists at http://lists.civicrm.org/lists/
One of the boards at forum.civicrm.org
IRC (#civicrm on freenode)
This StackExchange site.

Edit: I guess I'm wondering if there even is a definitive "best" forum for such discussions.


texts: A client stopped using Stripe in Civi (they're not using Civi for payments now) and switched to using Stripe only through their website (bad idea). So I disabled the extension, only to receive emails from Stripe saying that the webhook endpoint was failing. Enabling the extension made that problem go away but now I see error messages in the log like this: "[message] => Error relating this subscription id (sub_CdRU43deMhfO6T) to the one in civicrm_stripe_subscriptions"  I have no idea what this means so does anyone have a guide about what to do when removing Stripe from Civi?  It seems there are things to do that I haven't done.


texts:
I have a fresh install of civicrm 5.16.3 running on drupal 7. I am having trouble with the mail processor. I've read many pages trying to diagnose the issue and still no luck.

This is what I am getting from civi log, I changed username and server information.

I have tried connecting to a server that I can sucessfully connect to using another computer with civi installed, but no luck on this configuation.

Aug 27 12:41:22  [info] $Fatal Error Details = Array
(
    [message] => Could not connect to MailStore for username@server
Error message:
An error occured while sending or receiving mail. Failed to connect to the server: server:993.

    [code] =>
)

Aug 27 12:41:22  [info] $backTrace = #0 /var/www/html/drupal-7.66/modules/civicrm/CRM/Core/Error.php(343): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /var/www/html/drupal-7.66/modules/civicrm/CRM/Utils/Mail/EmailProcessor.php(175): CRM_Core_Error::fatal("Could not connect to MailStore for username@server...")
#2 /var/www/html/drupal-7.66/modules/civicrm/CRM/Utils/Mail/EmailProcessor.php(103): CRM_Utils_Mail_EmailProcessor::_process(FALSE, Object(CRM_Core_DAO_MailSettings), TRUE)
#3 /var/www/html/drupal-7.66/modules/civicrm/api/v3/Job.php(438): CRM_Utils_Mail_EmailProcessor::processActivities()
#4 /var/www/html/drupal-7.66/modules/civicrm/Civi/API/Provider/MagicFunctionProvider.php(101): civicrm_api3_job_fetch_activities((Array:1))
#5 /var/www/html/drupal-7.66/modules/civicrm/Civi/API/Kernel.php(168): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9))
#6 /var/www/html/drupal-7.66/modules/civicrm/Civi/API/Kernel.php(99): Civi\API\Kernel->runRequest((Array:9))
#7 /var/www/html/drupal-7.66/modules/civicrm/api/api.php(23): Civi\API\Kernel->runSafe("job", "fetch_activities", (Array:1), NULL)
#8 /var/www/html/drupal-7.66/modules/civicrm/CRM/Core/JobManager.php(149): civicrm_api("job", "fetch_activities", (Array:1))
#9 /var/www/html/drupal-7.66/modules/civicrm/CRM/Core/JobManager.php(116): CRM_Core_JobManager->executeJob(Object(CRM_Core_ScheduledJob))
#10 /var/www/html/drupal-7.66/modules/civicrm/CRM/Admin/Page/Job.php(173): CRM_Core_JobManager->executeJobById("3")
#11 /var/www/html/drupal-7.66/modules/civicrm/CRM/Core/Page/Basic.php(160): CRM_Admin_Page_Job->browse(NULL, NULL)
#12 /var/www/html/drupal-7.66/modules/civicrm/CRM/Admin/Page/Job.php(156): CRM_Core_Page_Basic->run()
#13 /var/www/html/drupal-7.66/modules/civicrm/CRM/Core/Invoke.php(311): CRM_Admin_Page_Job->run((Array:3), NULL)
#14 /var/www/html/drupal-7.66/modules/civicrm/CRM/Core/Invoke.php(85): CRM_Core_Invoke::runItem((Array:16))
#15 /var/www/html/drupal-7.66/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#16 /var/www/html/drupal-7.66/modules/civicrm/drupal/civicrm.module(456): CRM_Core_Invoke::invoke((Array:3))
#17 /var/www/html/drupal-7.66/includes/menu.inc(527): civicrm_invoke("admin", "job")
#18 /var/www/html/drupal-7.66/index.php(21): menu_execute_active_handler()
#19 {main}


texts:
I noticed that all labels in the "Activity Type Options" and "Custom Fields" cannot be the same. For example, if I wanted to add a "Medical Assessment" activity type, I cannot use the same label again. This matters, because when I assign this activity type to a specific case, I have custom fields attached to this medical assessment activity.

The problem is, when I create another case type and use "medical assessment" again, I want different custom fields to be attached.


texts:
I'm running CiviCRM under Wordpress.

I want to create a donor area, where they can change their information.
But I can't find way to let them change their password.

Why is not possible to add a "password" field in profiles?


texts:
In CiviVolunteer, I have two roles (perhaps 'Event Set-up' & 'Event Staffing') needed at different times (say Friday at 7pm for Set-up and Saturday at 9am for Staffing).

In my installation ( Civi 4.5.8 on Wordpress 4.1.1 ), someone can register to 'Set-up' on Saturday or to 'Staff' on Friday - The roles are not linked to the times needed.

Where do I start troubleshooting?

(I'd test on the demo, but you can't!)

Edit: I was able to test on the 4.6.1 Dupal sandbox and it does work where you must choose a role (time is hidden), then a new box appears to choose a time for that role. On mine, both the roles and times appear at the same time and inappropriate combinations are possible. I couldn't find any way demo for testing on a WP install, so I was confirming first that this is not a bug, and second, then how to fix. You said perhaps a broken script - but this is on multiple machines (& front & back end), so I assume it's my configuration somewhere. Where should I start looking to figure out the problem?
Here's my a screenshot of the page:

Edit:  No Errors in browser console with backtrace and debugging turned on.

Edit: I confirmed that volunteersignup.js is at:

/primary/www/wp-content/plugins/files/civicrm/ custom /org.civicrm.volunteer/templates/CRM/Volunteer/Form

It is NOT at /custom_exe/

I double checked Extension Resource Dir:
/webroot/b/g/example/primary/www/wp-content/plugins/files/civicrm/custom_ext

Extension Resource URL:
`http://example.com/wp-content/plugins/files/civicrm/custom_ext'

Changing these to other values broke many other things - These setting all follow the help prompts & book instruction from what I can tell.

Changing these to custom made no change.  .I didn't find a reference to a .htaccess change - is this a file permissions change, or a file content change?

Edit:

I moved custom_exe to /wp-content/plugins/civicrm_ext.

I changed the resource dir (/webroot/b/g/example/primary/www/wp-content/plugins/civicrm_ext) & urls (http://example.org/wp-content/plugins/civicrm_ext) to the file.  File has permission read access (755).  I can browse to volunteersignup.js at the new location and view as an anonymous user.  The file name is still not found when searching 'view source' on the sign-up page.  No custom coding has been done anywhere on the site.

I cleared cache from the admin (system settings > Cleanup Cache) and from manually deleting files in template_c per wiki. (The clearcache url gave an error "You do not have sufficient permissions to access this page.")

I've also disabled all the civi extensions and wp plugins. This completes all the tasks on the troubleshooting hit list Coleman posted.

But still NO CHANGE on the form! And no errors on in the console. sigh...

Edit: I upgraded to 4.5.8 just incase there was an easy fix there.  I didn't think there would be reading through the change logs - Of course, still no change...


texts:
Is there a way to enable a different price set or enable a fee (like a tax) dependent on the payment processor?

For instance if they select "Credit/Debit" as the payment processor a certain fee will be applied (3% or whatever).

Or if they select "Credit/Debit" a specific price set with the reflective price changes would appear which would be different than a "Pay Later" price set?


texts: Can't create a standalone profile for membership card information

texts:
I'm trying to create a profile page where a user tells us where they want to pick their membership card up. We have the field on new membership applications, but we want to send cards to existing members. Due to the cost of mailing we're going to drop them off at the member's preferred retail partner for pickup.

I have a custom field for the pickup location, and I created a custom profile with that field, plus the first and last name as view-only in order to verify the profile. The intent is to email the user and include their contact hash to ensure their profile appears. I received the following error when trying to preview the profile on the website front-end:

"Profile search, view and edit are not supported for Profiles which include fields for more than one record type."

I then stripped it back to only include the membership card pickup field. I still receive the error.

Is there any way to collect this information? I'd rather not send a bulk email and have to manually update every member's profile.

We are using wordpress 4.3.1 and civi 4.6.8.


texts:
Environment: Joomla: 3.4.4,
CiviCRM: 4.6.2,
PHP: 5.4.45,
MySQL: 5.5.42-37.1
HTTP only, no HTTPS,
On Shared Hosting at HostGator

The site is a few months old, and we've had 30-50(?) online payments (member dues, events, donate) via PayPal Standard, but all of the transactions remain "Pending".

I've followed and double checked "Configure Paypal to Talk to CiviCRM" here ... http://wiki.civicrm.org/confluence/display/CRMDOC/PayPal+Website+Payments+Standard+and+Recurring+Contributions

IPN is Enabled
IPN points the sites home page, including "http://" (http://my-site.org)
... (worth noting the home page is managed by Joomla, not CiviCRM, but since the url is a "place holder' it does not make any difference I assume)
Auto Return: On
Payment Data Transfer: Off

I enabled the Joomla Redirect Component to catch any 404's, assume some how the IPN URL is wrong. But there have been no IPN related 404s in there. This makes me think the issue is either 1) the link back from the IPN is valid, but not being processed, or 2) the IPN never reaches the site.

I have enabled Logging in the CiviCRM Admin, but where should I look for IPN details? There are many log_civicrm_% tables in mysql, but none seem to log  IPN details.

I assume PayPal IPN Simulator might give me some clues, but how do I construct a test URL?


texts:
I have set of name, addresses, phone number etc in CiviCRM. These are slightly outdated. I have an excel sheet for the same people with their new addresses. I have a unique external identifier for most of them.

If the excel sheet address is new, I want CiviCRM to add it as a second address and if it is same as old address, then I don't want to update.

How can I achieve this?


texts: How can we create memberships with two or more accumulated partial payments?

texts:
We'd like to let individuals pay membership fees incrementally, e.g. four quarterly occurring payments of 0.25M (where M is the total membership fee). It looks like the devs sought to do something like this previously in the Civi core, and there may have been partial payment function deployed in 4.7 -- see this thread and this thread too. But I'm not seeing anything in our live install of 5.4.0 (running on WP 4.9.8) that supports creation of new membership once user has made two or more contributions of which the sum meets or exceeds the membership fee.

Am I missing something? And if not, is there any appetite for an extension or core enhancement that would enable both tracking of partial membership payments and creation of membership (or renewal of membership) once the membership fee is paid in full?


texts: Civimail open tracking is not working for some mailings - inserts var/www/html into path for some mailings but not others

texts:
Civimail is inserting a path for the open tracking image that includes var/www/html

example where it does not work https://(domain.org)/var/www/html/sites/all/modules/civicrm/extern/open.php?q=nnnn

for some mailings the path is correct:
https://(domain.org)/sites/all/modules/civicrm/extern/open.php?q=nnnn

The tracking works when I manually remove the var/www/html from the path for a given url and the open report shows the open

There have been no changes to the default directory or resource paths.

Anyone else see this behavior?  It seems to have started in November (2016) but is inconsistent.  Any suggestions on where to look?


texts:
I trying to add an Action in CiviRules. I am trying to follow the API add instructions.

Here is what I did
1. Copied the file org.civicoop.civirules/CRM/CivirulesActions/Activity/UpdateStatus.php (this looked like an easy edit to do what I wanted--update a field) and created a new file in org.civicoop.civirules/CRM/CivirulesActions/Contributions/UpdateInstallments.php

I edited the copied file (edits in bold)

`
 * @license http://www.gnu.org/licenses/agpl-3.0.html
 */

class CRM_CivirulesActions_Contribution_UpdateInstallments extends CRM_CivirulesActions_Generic_Api {

/**
   * Method to get the api entity to process in this CiviRule action
   *
   * @access protected
   * @abstract
   */
  protected function getApiEntity() {
    return 'Contribution';
  }`

But it does not show up in the Rules option list. I tried a cache clear. What am I doing wrong?


texts:
How would I call CRM_Core_I18n_Schema::rebuildMultilingualSchema($locales, NULL); from the command line?  Minor upgrade seems to have had an insignificant DB error and this line did not get called.

Coming from:  CRM/Upgrade/Incremental/php/FourSeven.php line 654
Wordpress, CiviCRM 4.7.10


texts: Pay Later option missing on front end CiviCRM 4.7.10

texts:
CiviCRM 4.7.10

Joomla! 3.6.2

Payment gateway: PayPal Standard

I see this issue was reported earlier on Civicrm 4.7.8, but the bug report https://issues.civicrm.org/jira/browse/CRM-18118 says fixed/closed

This site was running civicrm 4.6 and upgraded to 4.7 followin this process https://wiki.civicrm.org/confluence/display/CRMDOC/Upgrading+CiviCRM+for+Joomla. In 4.6 the pay-later option was working. After upgrading to 4.7.10 pay-layer option does not show on the front end.

Below is my test event setup and the second page from the front end registration process. When I click the Continue button I'm sent to PayPal.

So, maybe I missed something in the upgrade process?
Or maybe civicrm-4.7.10-joomla.zip is missing the patch?


texts:
I'm getting randomly the errors below when I go to an admin page.  They don't always happen.  Any idea what this is?

Warning: Invalid argument supplied for foreach() in /home/sporti62/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/SchemaHandler.php on line 750

Warning: Invalid argument supplied for foreach() in /home/sporti62/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/SchemaHandler.php on line 750

Usually get a bunch of these...

PHP version 5.6.32
CiviCRM 4.7.28
Wordpress 4.9.1


texts: Soft credit / honoree info in a token for Thank You letters?

texts:
I have hunted and not found anything so I am assuming that this does not exist -- but thought I'd ask just in case. I'd like to be able to reference the soft credit / honoree information in Thank You letters but can't find this as a token.

I guess it's tricky to do this as a token since it relates to a specific contribution and not the contact in general. What is the best way to try to do this?


texts:
I would like to keep track of emails that I have sent on Civicrm?  Is there a way to do this or do I have to print them to keep a record of sent emails?

Thanks


texts:
How would we go about achieving the following report results? (I have looked at the report page but haven’t worked with this yet)

I have pasted a snippet below.


texts: I can send emails with Drupal 7 using the SMTP Module but not CiviCRM

texts:
I host a server on Google Cloud with Protonmail Bridge running in the background. I am still new at working with CiviCRM 5.26.1 and PHP. I can successfully send emails via Drupal usinig the SMTP module but with CiviCRM I receive this error when I send a test email:

  authentication failure [SMTP: STARTTLS failed (code: 220, response: Ready to start TLS)]

In the Bridge Configuration Guide, an exception has to be set on Thunderbird.

Now, according to this solution that would seem to solve my problem : SMTP connection failing problem, I don't have the same structure when I open the /Net/SMTP.php file.

Note: This exception is needed for Protonmail Bridge.


texts: Include more than one profile at top of event page

texts:
I have a website with CMS Drupal 7.54 and CiviCRM version 4.7.16.

On the CiviCRM event configuration page under "online registration" tab, there are two fields available to include profiles (Include Profile(top of page) and Include Profile(bottom of page)).

I would like to add more than one profile using "Include Profile(top of page)", now its allowing to add only one profile at top of page. I noticed that there is an option to add another profile (bottom of page) but not on top of page.

If anyone knows solution for this, please let me know.

Thanks in advance.


texts: When editing my own profile visible under my contact dashboard, it does not enter CiviCRM "civicrm_post"API hook?

texts:
When I try to edit my profile fields from my own contact dashboard as seen in the two images attached and click save, It does not seem to invoke civicrm_post hook in WordPress instance.

add_filter( 'civicrm_post', 'alter_profiles_event', 10, 4  );

function alter_profiles_event($op, $objectName, $objectId, &$objectRef){
   if ($objectName == 'Profile'){
    print_r($op);
    print_r($objectRef);
    die('ed');
    //does not enter here.
   }
}

How can I make sure the hook is invoked?


texts: Can I change a contribution's values for Financial Type and Campaign directly in SQL without danger?

texts:
When using "Import Contributions > Update Existing Contributions" I can import a Financial Type using the full name of an existing (and active) Financial Type. However, if I try to use the full name of an existing (and active) campaign it does not seem to work consistently.

EDIT
I notice that in the database the civicrm_contribution table has fields for financial_type_id and campaign_id -- is there any danger in using some SQL directly to populate these values? (ie. can anyone verify that if I set those IDs correctly in this table, it won't conflict with anything else)


texts: A friend is using the RSForm! Pro extension with Joomla and wants to gather volunteer signup information and port the data to CiviCRM. Does anyone have any experience with doing this? What is involved. I do not find any reference to this product on StackExchange and a web search doesn't turn up much.


texts: Where to change details on payment processor?

texts:
I am using Wordpress 4.8.1 and CiviCRM 4.7.22.
Please see the screen shot of my payment processor on a contribution page.  I am using Paypal Payments Pro. You will see where it says click the "Continue" button on the bottom.  The button on the bottom says "Contribute".  That is very unprofessional.  Where can I fix that?

Thank you


texts: Can I track grants against contributions?

texts:
Is there a way with CiviGrant to match money received as Contributions with money disbursed?

E.g. if I receive a donation for $100K for a scholarship fund, and I give out 3 scholarships of $20K each, is there a report that can show me that I have $40K left in the fund?


texts: Is it possible to use Windows & Cygwin to run Selenium tests or does Selenium require a VM?

texts: I know documentation suggests using a virtual machine w/Windows, but I don't know anything (yet) about Selenium /limitations so am asking


texts: Can't Include Profiles for Contribution Page after migration

texts:
We just underwent a migration from one server to another. For some reason, I don't have the same options to include Profiles I have previously created when I "manage" a contribution page I am configuring. The ebook says "select a CiviCRM profile from the dropdown menu..."

But when I try to do that, there are no real options. The "Include Profile (top of page)" is greyed out and the "Include Profile (bottom of page)" has a blank white text box but no options to select previously created profile or make new ones on the fly.  Yes I have the profiles "activated" in the system but they still don't show up.  What do I do?


texts: eWay Payment Processor error 9001 on contribution - help please

texts:
eWay Payment Processor error 9001 on Contact's Contribution page.

Setup new eWay account works fine with Xero, however, with CiviCrm (4.7.10) when used with a Contact's Contribution page I get a "9001 error. Connection to payment gateway failed - no data found". Have tried the delivered eWay processor and also Chris Chincilla's V1.2 and I get the same behaviour.

Have checked the setup many times and it is correct. Have deleted the payment processor and then re-added it. No change.

Can anybody help me or point me in he right direction please?


texts:
I have added a new website types (Administer> Customize Data and Screens> Dropdown Options> Website Types) called 'Portfolio' and want to add it on my CiviMail Message Templates using a token. I have tried to use the {contact.custom_id} but it doesn't work. I'm not sure if i'm doing it right but I follow the instruction in Token Help w/c is to get the ID in edit link (Please see the screenshots below):

so my custom code would be {contact.custom_844} right?

PS. I'm using it on Organization. CiviCRM 4.7.14 on Wordpress 4.7.2

Thanks!


texts: How can I display only Cases without Case Managers using Drupal Views

texts:
I'm using CiviCRM 4.6.9, if it makes a difference.

I want to use Drupal Views to display only CiviCase cases that do not have case managers.

I feel as though I'm close... so close, but I'm not quite there yet. This is what I have set up.

I have a view that displays cases in a table format. I've add a subject field and a contact field to the view. I then added CiviCRM Case Contact: Case Contact's ID as a relationship, and to that I've added CiviCRM Contacts: CiviCRM Relationship (starting from contact A) which is set to use only the case manager relationship type, but is not required.

For filters, I've added (CiviCRM Relationship (starting from contact A)) CiviCRM Relationships: Case ID (empty).

This almost works as I want it to. However, if a single client has multiple cases, and any one of those cases is assigned a case manager, none of their other cases will show up. I think this happens because the relationship is fetched via the clients ID number and not via the case ID, though as far as I can see, there are no views relationships that will allow me to  fetch a case relationship via the case ID.

I can supply more information if needed.

Any help is greatly appreciated.


texts: Connecting existing contribution to pledge

texts:
This Sunday was the first day for our church to receive payments in a financial campaign we are running. Some people have made pledges, and we have used CiviPledge to record those pledges.

I was under the assumption that when we recorded the donations to the same financial type as the pledge that CiviPledge would automatically figure out that that gift should count as a pledge payment.

However, it did not. I have since discovered the "Pledge" tab on an individual contact page which allows me to record a pledge payment, but that adds a completely different workflow to our record keeping.

Therefore, I have two related questions:

Is there some way to connect a contribution to a pledge when the contribution is entered using the standard contribution entry form?
How can I connect an existing contribution to a pledge after the contribution has been entered? (I am comfortable using the CiviCRM API, but have never programmed for the pledge component before.)

Any help will be appreciated.


texts: How to develop extension that relies on libs brought in by composer

texts:
I'm wanting to (re)develop an extension and I'd like to use some 3rd party libraries, eg. guzzle, that I would normally manage via composer.

So my github repo will contain a composer.json file, but not the vendor directory. So would I need to package installable versions with the libraries included?

Also, what if I were to install libraries that are already included (eg dependencies of the libraries I want might be already in use leading to a namespace clash).

Is there a workflow for this sort of thing?


texts: Undefined index: start_time in CRM Volunteer BAO NeedSearch.php

texts:
Drupal 7.67
Civicrm 5.15.2
CiviVolunteer 4.7.31-2.3.1

I have the following error message on Volunteer Event registration "Volunteer Now" screen:

Notice: Undefined index: start_time in CRM_Volunteer_BAO_NeedSearch::usortDateAscending() (line 299 of /home/mysite/public_html/members/drupal/sites/default/files/civicrm/ext/org.civicrm.volunteer/CRM/Volunteer/BAO/NeedSearch.php).


texts: Unable to select profiles when creating online event registration

texts:
I am running CiviCRM 4.7.17 and Joomla 3.6.5 and I am unable to select a profile when I turn on online registration for an event. The "include profile" drop down field is greyed out, and when I click it only "None Found" is listed.  However, if I click on the "preview" button, it displays the default "Your Registration Info" profile.  I can also click "create" and create a new one.  It saves to the profiles, but when I come back into the event and select online registration, the new profile no longer shows up in the "include profile" field.

This is true for any of the "include profile" fields on the online registration configuration page.

I can select a profile for a contribution page but just not events.

I went back to Test site that was running CiviCRM 4.5.4, and I could select profiles.  I upgraded to CiviCRM 4.6.9, and I was no longer able to select the profiles.  Version 4.6.9 post upgrade notes indicated that there were changes for the event workflow templates.  Not sure if that is related.

I tried this on the CiviCRM Joomla demo site, currently running v4.6.18, and I could select profiles.  However, the major difference is that I have several of the CiviCRM extensions installed on my Test and Prod sites.

I see similar posts, but some answers discuss Wordpress and others indicate a fix back in v4.5.4.

Can anyone point me in the right direction?

Thank you in advance for any assistance.


texts:
WordPress 5 has recently come out. I've done an upgrade on a test Civi 5.8.0 site on PHP 7.1 and it went through OK and no problems are showing immediately. Is anyone seeing any issues?

It looks like my custom extension and WordPress plugin are working OK.

Thanks, Chris


texts: Edit profile the triangle just keeps spinning

texts:
I am using a new install of 4.6 with no additional plugins installed.  I go to contributions>manage contibution pages > member Sign up> Configure then profiles. I click the edit edit button next to any of the dropdowns and the triangle page pops up and just spins. I have to refresh and start over.

Any thoughts?


texts:
I have just upgraded our CiviCRM install to 4.7.13. When creating a new event and selecting all relevant options, the Google Map is not displayed. This IS displayed when viewing other active and older events.

We have been using a custom .tpl file, but even after disabling the tpl and clearing the cache(s) we are still facing the same issue.

Any ideas what might be going on here?

For testing we are using the same stored address. The existing, pre-upgrade event has the following values:

{$event.is_map} = 1
{$config->mapProvider} = Google
{$location.address.1.geo_code_1} = 56.0797664
{$location.address.1.city} = Dunfermline
{$location.address.1.state_province} = NULL

The map is displayed.

A new event, post-upgrade, with exactly the same settings has the following:

{$event.is_map} = 1
{$config->mapProvider} = Google
{$location.address.1.geo_code_1} = NULL
{$location.address.1.city} = Dunfermline
{$location.address.1.state_province} = NULL

The map is missing.

When we open the location information on the old event and save, the map fails to work ?!


texts:
I run a large non profit association that provides free legal advice and advocacy for older tenants. Our current database has two roles. One is a global role so that Head office can look at all members and the other is that each branch can log in and look at its members in that branch.

My question is does CiviCRM allow me to essentially have the same type of setup that we have now. That is can i have groups(branches) that i can restrict log in to only that data, and then those of us at hq can log in and veiw all the branch data. We currently have 17 branchs and can import all data by csv?


texts: Reverting CiviCRM on Drupal 7 to last backed up state?

texts: What is the best procedure for reverting the CiviCRM, powered by Drupal 7, back to a previous backed up state, in case of database corruption, failed upgrades or other undesirable changes?


texts: What can be done to improve loading of Activity searches and tabs on databases with gazillion civicrm_activity_contact rows

texts:
Digging in to why one of our larger clients is suffering more from slowness of Activity searches or loading of Activity tab for contacts.

Comparing it to other dbs what stands out for this database is the sheer number of rows in civicrm_activity_contact - and while they also have a lot of Activities, they have no where near as many as other databases. A sample of data below where A is the db that is grinding slowly

| db | Activities | Activity Contacts | average contacts per activity |

| A | 626,145 | 22,270,065 | 36 |

| B | 180,000 | 5,680,000 | 32 |

| C | 3,718,634 | 7,722,346 | 2 |

And it is DB 'A' that is seriously slow running Activity related queries.

Most of the Activity Contacts are on 'bulk mail' Activities

The activity search makes use of multiple joins of civicrm_activity, civicrm_activity_contact and civicrm_contact table. It leads to millions and millions of rows again and again which causes an indefinite loop of the query which never finishes or takes much longer time to complete. A sample query which is executed by hitting the search button on Find Activity form.

SELECT count( DISTINCT ( civicrm_activity.id ) ) as rowCount

FROM civicrm_contact contact_a
  LEFT JOIN civicrm_activity_contact ON ( civicrm_activity_contact.contact_id = contact_a.id )

  LEFT JOIN civicrm_activity ON ( civicrm_activity.id = civicrm_activity_contact.activity_id
     AND civicrm_activity.is_deleted = 0 AND civicrm_activity.is_current_revision = 1 )

  INNER JOIN civicrm_contact ON ( civicrm_activity_contact.contact_id = civicrm_contact.id and civicrm_contact.is_deleted != 1 )

  LEFT JOIN civicrm_option_group option_group_activity_type ON (option_group_activity_type.name = 'activity_type')

  LEFT JOIN civicrm_option_value activity_type ON (civicrm_activity.activity_type_id = activity_type.value
      AND option_group_activity_type.id = activity_type.option_group_id )

  LEFT JOIN civicrm_activity_contact ac ON ( ac.activity_id = civicrm_activity_contact.activity_id AND ac.record_type_id = 2)

  INNER JOIN civicrm_contact source_contact ON (ac.contact_id = source_contact.id)

WHERE  (  civicrm_activity_contact.record_type_id = 3
    AND civicrm_activity.is_test = 0
    AND civicrm_activity.status_id IN ("1", "2") )
    AND  ( 1 )
    AND  (activity_type.component_id IS NULL OR activity_type.component_id <> 5)
    AND  (activity_type.component_id IS NULL OR activity_type.component_id <> 7)


texts:
I have an issue on creating profiles.
When I create a profile with several fields such as "First Name" "Past Name" "E-Mail" and some Custom Fields and I set these fields to "searchable", everything looks fine at first. I can check the preview and the Use - Create/Edit/Listing Modes and it works.
But after a while, it suddenly doesn't work any more:

I get for the Listing Mode the error message: "No fields in this Profile have been configured as searchable. Ask the site administrator to check the Profile setup. "
Preview is empty
Preview od searchable fields tell: "Profile Field Preview This CiviCRM profile field is view only." -> BUT IT IS DEFINITELY SEARCHABLE AND NOT "VIEW ONLY"

for me this feels a bit like a bug. Would be nice to hear if this problem is known and if there is any fix


texts:
I want to give organizations administrators the ability to update events or memberships contributions payments by check, without having to do an Advanced Search based upon pending statuses to such or such event or membership.

As far as I know, I cannot store such searches to replay them.

So, I am testing an approach using Views with a VBO operation field which enables Contribution edition : enclosed screen capture

When I tick a line of the report, and then confirm the item (Edit Contribution) I get the following error :

Une erreur HTTP AJAX s'est produite.
Code de statut HTTP : 200 Informations de débogage ci-dessous. Chemin : /batch?id=6940&op=do StatusText: OK
ResponseText :
Add CiviCRM Contribution | BAPA (Paroisse de La Celle Saint Cloud)
@import url("https://xxxx.com/modules/system/system.base.css?ook5dq");
@import url("https://xxxx.com/modules/system/system.menus.css?ook5dq");
@import url("https://xxxx.com/modules/system/system.messages.css?ook5dq");
@import url("https://xxxx.com/modules/system/system.theme.css?ook5dq");
@import url("https://xxxx.com/modules/contextual/contextual.css?ook5dq");
@import url("https://xxxx.com/modules/comment/comment.css?ook5dq");
@import url("https://xxxx.com/modules/field/theme/field.css?ook5dq");
@import url("https://xxxx.com/modules/node/node.css?ook5dq");
@import url("https://xxxx.com/modules/search/search.css?ook5dq");
@import url("https://xxxx.com/modules/user/user.css?ook5dq");
@import url("https://xxxx.com/sites/all/modules/views/css/views.css?ook5dq");
@import url("https://xxxx.com/sites/all/modules/ckeditor/css/ckeditor.css?ook5dq");
@import url("https://xxxx.com/sites/all/modules/advuser/css/advuser.css?ook5dq");
@import url("https://xxxx.com/sites/all/modules/ctools/css/ctools.css?ook5dq");
@import url("https://xxxx.com/sites/all/modules/l10n_client/l10n_client.css?ook5dq");
@import url("https://xxxx.com/modules/shortcut/shortcut.css?ook5dq");
@import url("https://xxxx.com/modules/toolbar/toolbar.css?ook5dq");
@import url("https://xxxx.com/themes/bartik/css/layout.css?ook5dq");
@import url("https://xxxx.com/themes/bartik/css/style.css?ook5dq");
@import url("https://xxxx.com/sites/default/files/color/bartik-8a90baaf/colors.css?ook5dq");
@import url("https://xxxx.com/themes/bartik/css/print.css?ook5dq");
...

Depending upon context, ?ook5dq can change to ?oonnv5 (and maybe others (?))

I am not familiar with Views ; Am I missing something ?


texts:
I have inherited a Drupal + CiviCRM 4.7 site which uses CiviCase to track applicants for an award. The applicant is the case client, and each case (nomination) has up to three judges assigned, who are supposed to submit scores on the case itself.

On the existing Case Type "Nomination" I have created the Case Role "Judge [for]" to link the judge and the applicant.

Right now, these assignments are handled manually, and I would like to set up a Webform CiviCRM interface for it; I cannot, however, find a way to add these role assignments. The webform has four contacts (for the applicant and each of up to three judges), but there is no way to set up the Judge role, only Case Client and Case Creator.

I tried setting this up in Rules using relationships, but it creates general relationships, not case relationships, and so the Judges do not have permission to view and modify the case.

Did I miss a step?


texts:
I've set up a number of projects/campaigns on CiviCRM so we can record donations against them and clearly see how much has been raised against each project.  However, I need to set up a new project and the look of the system has changed since I last did it so I can't work out how to do it. I'd be so grateful for some advice!

Best wishes


texts: Is it possible to create multi-record custom fields on Activities?

texts: Has anyone found a way to create multi-record custom fields on Activities? We have an example where a single activity can contain multiple funding sources and need to be able to enter them into the one activity


texts:
I use wordpress 4.9.6 and civiCRM 5.1.2 for wordpress
in my cPanel:
string command:

https://mysite/wp-content/plugins/civicrm/civicrm/bin/cron.php?name=username&pass=password=curl '[string site-key]'

message mail:
You need to send a valid key to execute this file.
Why my key it's not valid? I took the key in cvicrm.settings.php
Thanks


texts: Select alias with dot is not returned from CRM_Core_DAO::executeQuery()

texts:
I've been playing around with the idea of using the custom group and field name as an alias when fetching data using the API. Because of this I've ended up with a situation where an alias can have a dot in it.

This causes the aliased field to be returned as empty, whereas an alias without a dot in it will be fine.

\CRM_Core_DAO::executeQuery('SELECT first_name as "Foo.Bar" FROM civicrm_contact;')->fetchAll()

Will return an array of contacts, but with Foo.Bar => "".

I've also tried using backticks around the alias, but with the same result.

I've found the cause of it, but am just posting this here for anyone else who might run into it.


texts: How to use API to bulk delete contacts quickly?

texts:
In development I would like to use the API to delete all contacted except conctact_id  1 and 2. With Contact

This:

$result=civicrm_api3('Contact', 'delete', array(
      'id' => array('NOT IN' => array(1, 2)),
      'skip_undelete' => "1",
    ));

.. won't work even though with get it does. Would seem there is no good way to do this fast, without making a complicated MySQL query. Who knows a quick work around. Mine were extremely slow and ran into error 500 timeout errors.


texts: How do I view cookie or session information on the server?

texts:
This question is because of troubleshooting I've been doing on Why won't data entered into CiviCRM profile html snippet save?  Loading a Profile makes otherwise malfunctioning embedded forms work, and I suspect something is happening on the server side to allow access/give permission to something.

So: how do I view what's happening with cookie data in CiviCRM on the server side?  I've tried rgrep to search all files in the web directory for the cookie name, and have dumped the CiviCRM database and the Joomla database and searched for the cookie name.  I can't think of anywhere else to look.  Thanks for any pointers!


texts: membershipTypeValues hook not updating membership price

texts:
On my civicrm contribution page I have a field that I want to use to calculate the membership price.
Currently Im trying to use the membershipTypeValues hook to edit the price after the contribution page has been submitted
Heres the code
add_filter('civicrm_membershipTypeValues', "updatePrice", 10, 2);

function updatePrice(&$form, &$membershipTypeValues) {
    $membershipTypeValues[14]['minimum_fee'] = "40.00";
}

Theoretically this should change the membership price to $40 but the price doesn't change on the conformation screen.
The code runs and if I print out the $membershipTypeValues array I can see the minimum fee has changed to $40
Any ideas on how to fix this would be great
Thank you


texts: Forward to Friend broken; customizing the form

texts:
I just switched a CiviCRM installation over to Amazon AWS's SES email service, which will ONLY send our from verified domain email addresses. The CiviMail forward-to-a-friend link form assumes the email can come from the sender's address. (And this is all a bit of a security concern regarding misuse of an email server, too.)
No matter what I do, the form returns the error "Mailing is not forwarded to the given email address."
The version of the form which "ships" with CiviCRM does not allow for the from email address to be changed anywhere, and does not seem to include the Display Name of a sender.

I attempted to edit ForwardMailing.php to use the server's default email address as the from address (hard coded; better if could be system variable); I think perhaps I only have it displaying that address but it still is trying to use the recipient's address

 if ($hash) {
      $emailId = CRM_Core_DAO::getfieldValue('CRM_Mailing_Event_DAO_Queue', $hash, 'email_id', 'hash');
      $this->_fromEmail = 'ouraddress@AWSverifiedexampledomain.org';
    //$fromEmail = CRM_Core_DAO::getfieldValue('CRM_Core_DAO_Email', $emailId, 'email');
      $this->assign('fromEmail', $fromEmail);

    }

I would like it to show as sent by our server "on behalf of Display Name " and then in the text say that "DisplayName is forwarding you this email."
Is there a way to have the optional comment fields expanded by default on the form? They are not very obvious to most users.

Thanks in advance.


texts: Strange consistent log notices. Where do they come from?

texts:
I haven't tried asking on stackexchange before (only the old forums), so please excuse me if I do it in the wrong fashion... I did google this, but couldn't find anything that helped me remove these. I may of course have done something stupid again..

I have some cron-triggered notification messages that keeps appearing on every cron run. They are:

  Notice: Constant CIVICRM_USE_MEMCACHE already defined in include_once() (line 314 of /wwwroot/sites/example.org/civicrm.settings.php).

  Notice: Constant CIVICRM_MEMCACHE_HOST already defined in include_once() (line 320 of /wwwroot/sites/example.org/civicrm.settings.php).

  Notice: Constant CIVICRM_MEMCACHE_PORT already defined in include_once() (line 325 of /wwwroot/sites/example.org/civicrm.settings.php).

  Notice: Constant CIVICRM_MEMCACHE_TIMEOUT already defined in include_once() (line 331 of /wwwroot/sites/example.org/civicrm.settings.php).

  Notice: Constant CIVICRM_MEMCACHE_PREFIX already defined in include_once() (line 341 of /wwwroot/sites/example.org/civicrm.settings.php).

I'm worried they are more serious than they appear, and they anyway do clog up my log files. What could be the reason for these appearing?
I recently did an upgrade to version 4.6.4 (drupal 7.38), but I'm not sure if this was what triggered this.

Appreciate any suggestions!