texts: getting error message "too many connections"

texts:
Getting an error message on public website regarding too many connections.  We increased our SQL connections, but we don't have a lot of interaction going on between our website and CiviCRM.  We have web hooks between our forms and CiviCRM.  How do we troubleshoot what is causing this?  Nothing in the logs.  Any ideas for preventing this?

We are on WordPress 4.5.3 and CiviCRM 4.7.9.

Initialization Error

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => simpleHandler
        )

    [code] => -24
    [message] => DB Error: connect failed
    [mode] => 16
    [debug_info] =>  [nativecode=Too many connections]
    [type] => DB_Error
    [user_info] =>  [nativecode=Too many connections]
    [to_string] => [db_error: message="DB Error: connect failed" code=-24 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info=" [nativecode=Too many connections]"]
)
Initialization Error

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => simpleHandler
        )

    [code] => -24
    [message] => DB Error: connect failed
    [mode] => 16
    [debug_info] =>  [nativecode=Too many connections]
    [type] => DB_Error
    [user_info] =>  [nativecode=Too many connections]
    [to_string] => [db_error: message="DB Error: connect failed" code=-24 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info=" [nativecode=Too many connections]"]
)


texts:
0.1 on Wordpress 4.9.
We have a payflow manager account.  I have confirmed that our credentials are correct. However when I enter them into Civi payment Processor and attempt to subscribe to a membership through civi, I get the error message you see in the screenshot.  I also included another screenshot to show the civi payflowpro settings I am using.  Is maybe the site url incorrect?

Thank you


texts:
I've a got a local sandbox running CiviCRM 4.7.18 on Drupal.

For any datepicker field (e.g., Contacts > New Activity), the selection is displayed with munged URLs separating the date components. For example, were I to select today's date, I'd expect to see this value in the text input:

  06/30/2017

Instead, I get this

  06https:http://6pk.l181calh181st/http://6pk.l181calh181st/6pk.l181calh181sthttp://6pk.l181calh181st/30https:http://6pk.l181calh181st/http://6pk.l181calh181st/6pk.l181calh181sthttp://6pk.l181calh181st/2017

Note: the URL of this site is mpk.localhost. In addition to jamming in the site URL instead of separators, some character replacement is happening which might provide a clue as to what's going on:

"m" is replaced by "6"
"o" is replaced by 181

I've tried looking for weird stuff in the date/localization settings, and I've tried switching the Drupal theme. There are no messages in the JavaScript console.

Any ideas?


texts: Is there a way to hide the profile title.  I have added a tracking profile which is being populated by values passed in the URL to the contribute page. The fields I have added are being hidden, so the title is unnecessary.


texts: Search for contacts within Geocoded regions/borders

texts:
My organisation needs to search for contacts within the regions/borders of England, Scotland, and Wales. This is important as our communications relate to elected representatives within devolved parliaments etc.

As all contacts in the UK have country 'United Kingdom' this is not easy.

Postcodes in the UK do not correspond to the borders between England/Scotland and England/Wales, and overlap significantly in some areas.

Postcode Areas and Postcode Districts (the 'SW' and '1W' in the post code 'SW1W 0NY') also do not correspond with the country borders, so it also isn’t possible to search on these (even using ‘Range’ or ‘Regex’).

Would it be possible to geocode the entire areas of England, Scotland, or Wales around known coordinates, and create smart groups based on these?

These three groups alone would be incredibly helpful, but it would be even better were it possible to import coordinates from Google Maps / OpenStreetMap searches (e.g. https://www.google.co.uk/maps/place/Scotland/@56.367676,-4.9607288,8z/data=!4m5!3m4!1s0x4861e2c403f2a19f:0xe7c1fad809c30714!8m2!3d56.4906712!4d-4.2026458), that way other regions could also be quickly turned into Smart groups.

At present we are searching by postcode and excluding contacts using poorly defined 'radius' searches - so finding a better solution would make a huge difference to our work, and I'm sure to many organisation working in the UK.


texts: How NOT to send email to "Activity Assignee" when assigned an activity

texts:
Usually we create different type of activities and assigned to one of our volunteer. Now when "Create separate activity for each contact" is selected, assignee volunteer receive multiple emails for each contact.

Alternative option is not to check that option, but then it creates only one activity for multiple contacts, and when changed the status of activity of 1 contact, it changes status of all contacts.

I know emails can be redirected to database, I guess by doing that all offline contribution email receipt wouldn't be sent right?

So Is there a option or a way NOT to send a email notification to a assignee without compromising any other outbound email service?


texts: How do I set the print order for address labels?

texts:
I've created a site using Drupal (7.37) and CiviCRM (4.6.2) for a club that I am a member of. We send out a quarterly printed newsletter and sometimes need to insert personalised letters or other items for specific members. I can print the labels but I cannot see a way to control the order in which they come out, meaning that it is a nightmare to match up labels and inserts.

My label sheets come out in the order they were added to the database (ID field) and I'd like them in last name or even membership number (a custom field) order. Additionally the page of printed labels fills the left column, then middle column, then right column when I'd like them alphabetically filling the top row, second row, then third etc.

Is any of this possible?


texts: Why can't I record backend contributions without using a priceset?

texts:
Using Drupal 7 and CiviCRM 4.7.22, I am unable to record any contributions unless I use a priceset, i.e. if I use this form:
/civicrm/contact/view/contribution?reset=1&action=add&cid=mycid&context=contribution and put in any amount without using a priceset, then the contribution is stored as $0 without showing any errors.


texts:
I'm helping our food coop transition from a home grown membership system to CiviCRM. We have a number of unique requirements and am wondering whether any members have a model configuration to share for coop membership. Some of the uniqueness includes:

Equity for membership is paid in different amounts and over different periods of time for individual versus family memberships. During the equity period one is still an active member and must also pay a yearly fee.
There is also an option for sweat equity for those who cannot pay the equity fee. This also needs to be tracked for completion.

I'm currently struggling with the using membership types versus membership status to track the above.

The coop has varying discount levels based on the amount of hours volunteered. This can change on a monthly basis and the monthly discount rate needs to be tracked. A separate PHP/MySQL based system tracks the actual hours posted.

Realizing that this is a very broad subject and request, I am hoping there are some members here who have a similar system they've set up for their coop and could share some insights and even some configuration info.


texts:
There's a file http://latest.civicrm.org/versions.json which isn't up to date - it's missing a few betas, but most notably, it's missing CiviCRM 4.4.14.  This is the source data for CiviMonitor, which uses it to check if a version is up-to-date.

Is this file generated by hand, or with code?  If by hand, is there a git repo I can submit a PR against?


texts: Tyring to install civicrm-5.15.1 on Joomla 3.9.9 Stable - "Installation error com_civicrm/admin/configure.php on line 115"

texts:
sorry for my approximate English.

civicrm-5.15.1-joomla

Joomla! 3.9.9 Stable

Unfortunately the installation ends with the following error message.

Fatal error : require_once(): Failed opening required '/membri/testastuta/administrator/components/com_civicrm/civicrm.settings.php' (include_path='.:') in /membri/testastuta/tmp/install_5d2c80922fb4c/com_civicrm/admin/configure.php on line 115


texts: Changing Membership defaults to extending membership

texts:
Our club has different membership types, but all are on the same fixed membership period. If a member upgrades from one membership type to another, we use the "Renew" function to change the membership type and record the payment for the difference. By default, however changing the membership type also extends the membership by 1 term, so we have to manually adjust that.

Is there another way to change membership types, instead of using the renew function to avoid this default behavior?


texts: How can I create a paid membership sign-up with a price set using Caldera Forms

texts:
I'm building a membership sign-up form. The membership has a price set, and I'm using this guide from Tadpole which looks to be pretty close to my situation.

What I've found through extensive testing and several attempts to rebuild the form in case I've missed something, is that although I have three line items in my price set (one offers a range of pricing options based on user-selected preferences, and the other two are simple optional add-ons) and all three are included in my order processor, when I run test transactions I only ever get the first two recorded both in the Stripe transaction and in the contribution record.

I've tried various options including re-ordering the line items, but nothing seems to make any difference.

Noting that the current version of the cf-Stripe processor from Caldera didn't work at all, cos it uses Stripe checkout rather than the on-page JS approach, I downgraded to version 1.4.7 on the advice of Kevin Cristiano. That got the contribution to record, but I remain stuck with only being able to handle two line items.

I'm wondering whether this might also be down to version-specific requirements with the core Caldera Forms plug-in, given that the most recent release of the cf-civicrm plugin dates back to Nov 2019? Should I be using an older version of the forms plugin? I'm running 1.8.11.


texts: Changing hosts for CiviCRM -without current host cooperation

texts: We need to change our civi hosting to another company. We have already moved our website, but the civi hosting still seems to be with the original company. The tricky part is that our current hosts aren't cooperating with us because of legal issues around termination. How should we go about taking this account to another site without any aid from our hosting company?


texts: Exporting membership data including chosen price set

texts:
Our charity offers a range of memberships for organisations with the price based on their size. For each type of membership we have a price set including 3 options. So you can be a service provider (small, medium, large); a training provider (small, medium, large) or a supporter organisation (small, medium, large).

We have recently moved over to CIVI want to invoice members who have just joined and those who are due for renewal (yearly).

We want to be able to create invoices using a mailmerge from excel  including info like organisation's name, member type (service provider, trainer, support org), member start date, end date, and of course what it will cost them to renew assuming they are still the same price set ie (small, medium, large). We can search memberships to find those who are due for renewal but we can't find out what price set they chose when they joined.

We tried to export data but can't find price set as a field under member data or payments/contributions. I can't even see it when clicking into an individual member's details. The price sets are active as we've tested joining and you need to select the option - it works for PayPal but we can't process PayLater at present. I've noticed when creating profiles it says that contribution and member data cannot be included on the same profile. So wondered if that is part of the problem. Is there a work around?

We're on CIVI 4.5.8


texts: Why my sites can't show the event content from CiviCRM?

texts:
The project has been set up as multisite.

If I am trying to get the contents by https://111.com/civicrm/?page=CiviCRM&q=civicrm%2Fevent%2Finfo&reset=1&id=1. Everything works well.

But if I change it to https://222.com/civicrm/page=CiviCRM&q=civicrm%2Fevent%2Finfo&reset=1&id=1. It just shows [Do not delete this page. Page content is generated by CiviCRM.]

Can any one help me out?


texts: Creating a public Members directory with CiviCRM in Wordpress using Profiles

texts:
I'm trying to create a public Members directory with CiviCRM in Wordpress using Profiles.

First i created a "Smart Group" through Search that lists all the members filtered as i wanted - i've called this Smart group "Members Directory (Smart Group)" and set it's Visibility as "Public Pages".

Then i created a Profile called "Members Directory (profile)" and populated it with a few "Individual" fields like First & last name: each set with Visibility as "Public Pages and Listings", Searchable "YES", In Selector? "Yes". I linked this to my smart group.

Finally i put the CiviCRM shortcode [civicrm component="profile" gid="14" mode="view"] on my page.

However when i view my page it says...

(i) Permission Denied You do not have permission to view this contact record. Contact the site administrator if you need assistance.

See here...
http://phils07813188309.esy.es/membership/members-directory-from-profile/

Any ideas what is going on?
phil


texts:
Drupal 7.63
Civi 5.4

I have a Drupal webform for my contribution page and I want to allow donors that select "Is Recurring" the option to set the number of months for it to recur. So I have a Contribution custom data field "Recurring for X months" I am then using CiviRules to put that input into civicrm_contribution_recur > installments

I have a CiviRule set to trigger with Contribution is Added, I have no conditions set, and my Action is a custom action.

I have a watchdog built into my code so I can trouble shoot the code.

  protected function getApiEntity() {
    return 'ContributionRecur';
  }

  protected function getApiAction() {
    return 'Create';
  }

  protected function alterApiParameters($params,
      CRM_Civirules_TriggerData_TriggerData $triggerData) {
    $contribution = $triggerData->getEntityData("Contribution");

    watchdog('CONTRIBUTION TRIGGER DATA', var_export($contribution, true));

    $params['id'] = $contribution['contribution_recur_id'];

    if ($contribution['custom_67'] > 1) {
        $params['installments'] = $contribution['custom_67'];
    }

    watchdog('CONTRIBUTION PARAMS', var_export($params, true));

    return $params;
  }

In the Drupal logs I am seeing the arrays from the watchdog. However, custom_67 value is empty (custom_67 is listed in the array). If I run a Contribution Get in the API Explorer, the array includes values for custom_67 for the contribution I just made. I am now testing with real live contributions rather than the test Payment Processor to be sure that everything is fully functioning.

I created a new CiviRule using "contribution is changed" and used the same above action. Then I used the API Explorer >Contribution > Create and changed the Amount & Recurring for X (custom_67) to a different # for a particular contribution ID. It worked, it put the custom_67 # into contribution_recur > installments. However, it put in the old number not the new number.

This lead me to think that maybe the CiviRules was triggering before the database finished writing to the custom table, so I added a 1 minute delay to the rule. I still get nothing returned in my watchdog arrays for values in custom_67.

Any ideas why my Action Trigger Data is not getting values for custom_67?


texts: Buildkit - amp test fails - incorrect response received

texts:
The setup ran smoothly until amp test which says:

$ amp test

Expect response: "response-code-SoYwxYyBvx"
Received incorrect response: "<?php
// This is a simple script which outputs "OK" if it
// executes correctly and connects properly to a database.

if (isset($_SERVER['HTTP_CLIENT_IP'])
  || isset($_SERVER['HTTP_X_FORWARDED_FOR'])
  || !in_array(@$_SERVER['REMOTE_ADDR'], array(
    '127.0.0.1',
    '::1',
  ))
) {
  header('HTTP/1.0 403 Forbidden');
  exit('Connection must originate on localhost');
}

$config = require 'config.php';
$errors = array();

// ---------- Test HTTP inputs ----------

if (!isset($_REQUEST['exampleData']) || $_REQUEST['exampleData'] !== 'foozball') {
  $errors[]= "Error: Expected GET or POST value 'exampleData=foozball'";
}

// ---------- Test database ----------

try {
  $dbh = new \PDO($config['dsn'], $config['user'], $config['pass']);
  $dbh->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
  foreach ($dbh->query('SELECT 99 as value') as $row) {
    if ($row['value'] == 99) {
      // ok
    } else {
      $errors[] = "Error: Bad query result
";
    }
  }
  $dbh = NULL;
} catch (PDOException $e) {
  $errors[] = "Error: " . $e->getMessage() . "
";
}

// ---------- Test file permissions ----------

$dataFile = $config['dataDir'] . '/example.txt';
if (FALSE === file_put_contents($dataFile, "data")) {
  $errors[] = "Error: Failed to write $dataFile";
}
if (FALSE === unlink($dataFile)) {
  $errors[] = "Error: Failed to remove $dataFile";
}

// ---------- Wrap up ----------

if (empty($errors)) {
  echo "response-code-SoYwxYyBvx";
}
else {
  echo implode("\n", $errors);
  die();
}"
Tip: Try running "amp config" and/or restarting the webserver.

I believe I have set up amp config correctly. I even edited apache2.conf and included the line it asked to. But no matter how much I restart and test, it doesn't work.

My amp config:

mysql_dsn : mysql:civicrm:civicrm@localhost:8000
perm_type : linuxAcl
perm_user : www-data
httpd_type : apache24

And I included this line Include /root/.amp/apache.d/*.conf in apache2.conf file.


texts: Is there a way to sell numbered tickets, e.g. for a raffle?

texts:
We would like to sell numbered tickets for a raffle. According to the regulations we need to meet, we have to sell tickets that have unique numbers from a predetermined set (e.g. we have tickets numbered 1-500). How can we sell these tickets with email receipts that go to the buyer, including the ticket numbers?
Ideally, it would be possible to sell more than one ticket in a transaction and send a receipt to a buyer saying that they bought tickets x, y and z or failing that three emails listing the ticket numbers.
We've used a Drupal webform with the submission id as the ticket number in the past, but this only allows us to sell one ticket per transaction. It seems like we might be able use Civirules to send receipts with ticket numbers, but I'm not seeing a way to do that without custom code.


texts: What entity to use for committees (both a group and a collection of projects)?

texts: Having some trouble mapping CiviCRM database entities to conceptual entities in my organization. We have long lists of committees; each committee can have any number of projects; projects can have any number of volunteer opportunities. Working backwards from CiviVolunteer, that seems like I should have Projects and Campaigns to group them. But Committees more naturally map to Groups. So is it a question of using both and keeping them synced and somehow associated?


texts:
please help, I have a Joomla 3.6.5 and CiviCRM 4.7.14
I just migrated from the dev site to the live site, and now when I check the Outbound Mail settings in CiviCRM, they are empty.
Everytime I fill them out and press save, once I reaload the settings page, they are empty again.

Please, where is this info stored?

Thank you


texts:
I am looking for a best practice approach. I am working on a module extension, which involves creation, retrieval and deletion of an entity(object).

I have created the DAO files for them, I am looking to the write place to write insertion and selection queries. Currently I am confused about writing them in a BAO file or the API functions.

Is writing this code directly in API functions a bad approach, and having a BAO is a necessity. Also, if we create a BAO is there a guide I should follow about what to do and what not to do.


texts: Totals Row for Tab with Table Custom Data

texts: I have some custom data in a "tab with tables" style.  One of the fields is an integer type.  I'd like to add a summary at the bottom of the table with totals for this field.  Is that possible to do? Any pointers to what hook to use or how I can build it?


texts: CPanel Cron stopped working after upgrade to Joomla 3.8.0

texts:
I run a cron in Cpanel for Civicrm to send a newsletter once a month.  After the upgrade to Joomla 3.8.0 the cron has stopped working. This issue seems to be a big issue with this Joomla upgrade.  I tried to have my web host install a backup, but they only keep backups for 24 hours and they were unable to restore the previous Joomla version.   I have very little cron knowledge and need help figuring out how to get a cron working for this new version of Joomla so I can send out emails to my groups in Civicrm.

My current cron is the following:
wget 'http://www.divingrebels.org/administrator/components/com_civicrm/civicrm/bin/cron.php?name=login&pass=password&key=c121f216120e4362040e110a1f92db58' >/dev/null 2>&1

Thanks in advance
Danny


texts:
Why do some of the names entered show up as firstnamelastname and others as last name, first name on my reports?

Thanks!


texts: Import Multi-value Custom Data Fails for Household Contact Type

texts:
The "Import Multi-value Custom Data" fails when importing data into a multi-value custom field set that applies to only a Household contact type or Household sub-types. When the field set was change to "All Contacts" the import works. I didn't test it with multi-value custom field sets restricted to "Individual" or "Organization" contact types. It may fail with these also.

The Import Errors file show "Invalid value for field(s) : field ID; ; field ID; ; field ID; field ID" as the reason for the error when four fields are imported.

We use CiviCRM for WordPress.

To duplicate this setup a simple multi-value custom field set restricted to Households. Then try to import data into it.


texts: Email css and fonts being miscounted as 'clicks' in CiviMail Clickthrough Reports

texts:
I have noticed that in our CiviMail ''Mail clickthroughs' reports, styling links are sometimes being reported as 'clicks' when they are loaded which is skewing our click rate reporting.

E.g. The report shows one of the clickthrough URLs as:

  https://fonts.googleapis.com/css?family=PT+Sans:400,700,400italic,700italic

Which is presumably being caused by the following in the email template being automatically loaded:

  <style type="text/css"> @import
  url(https://fonts.googleapis.com/css?family=PT+Sans:400,700,400italic,700italic);
  </style>

Have I just implemented the code wrong in the email, or is this a general problem with using references to external styles/fonts in CiviMail?

Apologies if I'm just being really thick here...


texts: Free membership does not start before a second, paid for membership has been paid

texts:
There is a price set with two different membership types, which both can be selected. One membership type is free, the other has to be paid for with a pay later option.

If both membership types get selected, both are part of the same contribution record. This means both change from status pending to status new, once the payment for the contribution has been received.

I would much prefer to start the free membership immediately and only the paid membership should start, once the payment has been received. - Can this somehow be configured? So far, I have not been able to find such an option.

(Currently using CiviCRM 5.13 on WordPress 5.2)


texts: Webform field not updating CiviCRM field

texts:
I have created a webform and want to update existing fields in Civicrm. These fields are custom fields that have been created in CiviCRM (see below print screen)

So i have created the following webform again see below.

I have set the Address to Primary and Main address. see below

I have also set Matching Rule to Name and Email.

So what am i doing wrong please as I want it to update FAR fields to the existing record in CiviCRM. But it just does nothing.
Any help please?


texts: Contact Management - Best practices for couples and households

texts:
What are the best practices for storing couples and households?
Currently, every contact is an individual and a household is created for couples and families only.
This causes two undesirable outcomes.

1) When creating labels, if I select the 'merge all contacts of the same household' option, the children are also included in the label. I just want the parents.

2) When making PDF letters for all my contacts, I only want 1 letter per household but I end up with one for each spouse.

How do you avoid this situation?


texts:
I have a requirement to extend change add/edit screen of static group and add some extra fields there, like default email subject.

For saving extra fields I'm thinking about adding a new table, linked to groups table.

Then to display those fields I will need to create my own version of CRM_Group_Form_Edit.

Now I'm thinking what is better way to do all this, 2 options:

put required classes and templates in custom folder and change them. Looks like this is standard way.
instead of editing CRM_Group_Form_Edit I could create my own class then
change CRM_Group_StateMachine to point to that class which would extend
CRM_Group_Form_Edit

2nd option kind of sounds a better way thinking about feature upgrades.

are there same case scenarios when to use what? or any other suggestions for this requirement?


texts:
As I know it, to disable VERP, navigate to Administer > CiviMail > Component Settings and disable 'Track replies using VERP in Reply-To header'.
However, even after this is disabled, Civimail continues to send email with VERP like Sender addresses (FROM: b.43.123.7a7d2f84f666abb6@xxxx.org). The email server raised the 550 error for invalid sender.
Do I have to change some other setting to fully disable the change in the sender address?
Thanks ahead.


texts: How to enter an activity ID in the API Explorer?

texts:
I know the numeric IDs I want to query, but I can't enter them. e.g. on entity ActivityContact, I want to use the Contact ID params, and the Activity Id.

(I'm wanting to issue this request, which will only give me back what I already know, as a way of validating that the record exists.)

On the Contact ID I get a Contact search, but I can't figure out how to bypass this to enter the numeric ID. It's not such a problem because I can always go look up the contact's name and type that in and select it.

But I'm flummoxed by the Activity Id selector. I know the Activity Id I want, but I can't type a number in (it says not found), but I don't see what I would type in to locate it any other way?

Is there a way to override those new GUI elements (old explorer provided a workaround)? I tried using 'other' parameter and entering activity_id manually but it's too clever and noticed this and presented the GUI again!

(I can run this in code, but I'm trying to get in to the much promoted habit of using the explorer for answers first and wondered if I was missing something.)

Thanks.


texts: Fresh Installation, with all old data. Current online version CiviCRM 4.6.20. (WordPress)

texts:
I am very glad with the nice CiviCRM! This is an perfect online CRM-system!

After a lot years now, i would like to upgrade to the current version. But i am very scared if it would work.. The Current version: CiviCRM 4.6.20. is upgraded from an earlier version, and that was also with a lot of errors..

Does someone know how to do this the best way. There is very much information in the system, if there is something going wrong, it is a very big problem...

What is the best way to install a new version, and get all the data from the old.

Thanks a lot.

With Kind Regards,
Mark


texts: How to automatically create relationship between Drupal role user and a group of civi contacts?

texts:
I have webform where volunteers signup for newsletter. They land on group called "Volunteer".
Our volunteer co-ordinator users are in a drupal role called "Coordinator"
What I want is, those "Coordinator" users would ONLY be able to access the contacts from the group "Volunteer". I can easily achieve this by using related permission extension https://github.com/eileenmcnaughton/nz.co.fuzion.relatedpermissions .
But I am failing to automate the process of creating a relationship between the volunteers and Drupal users. If any new Drupal user is added to the same role, the relationship would automatically be created. I am open to alternatives. Any suggestion would be greatly appreciated. Thanks


texts: Use complete address and full county name in mailings

texts:
Working on a mailing that includes contacts full address details. And I'm encountering an issue for UK addresses where the county is abbreviated in the same way US states are. I've never seen such 3-char abbreviations used in the UK and it will cause confusion. Omitting the county is not an option either. Sadly the standard address hooks for mailings are limited.
Googling yielded the following page which has code I'm trying to use in a custom Civicrm extension. So far my attempts are failing miserably. I'm not very familiar with PHP, so please excuse and gently correct whatever atrocities I might be committing in the code below.
https://forum.civicrm.org/index.php%3Ftopic=20687.0.html
The extension is meant to provide two new tokens to mailings:

{contact.province}: prints the State / Province full name (as in {contact.state_province_name}). Not the same name in case this brings any conflict with the existing one
{contact.complete_address}: prints the full contact's address with the same format set in the label address customization

The article is quite old and uses APIv2, so I've resorted to adapt it to APIv4. In doing so my PHP errors have disappeared but I'm not seeing any results in "Preview as HTML" yet when editing a test mailing.
My hooks code below:
// Works, the new hooks show up in the list when editing mailings //
function mailhooks_civicrm_tokens( &$tokens ) {
    $tokens['contact'] = array(
        'contact.province' => 'Province',
        'contact.complete_address' => 'Complete Address',
    );
}
// Not returning anything, the tags are not interpreted at all //
function mailhooks_civicrm_tokenValues( &$values, &$contactIDs ) {
    require_once 'CRM/Utils/Address.php';
    foreach($contactIDs as $id){
        $address = \Civi\Api4\Address::get()
            ->addSelect('street_address', 'supplemental_address_1', 'supplemental_address_2', 'supplemental_address_3', 'city', 'postal_code', 'state_province_id:label', 'country_id:label')
            ->addWhere('contact_id', '=', $id)
            ->execute();
        $values[$id]['contact.complete_address'] = nl2br(CRM_Utils_Address::format($address[$id]));
        $values[$id]['contact.province'] = $address[$id]["state_province_id:label"];
    }
}

The output from the API Explorer (dummy address):
(1) [
  {
    "id": 3,
    "street_address": "3 Kings Road",
    "supplemental_address_1": null,
    "supplemental_address_2": null,
    "supplemental_address_3": null,
    "city": "Hitchin",
    "postal_code": "SG5 0AZ",
    "state_province_id:label": "Hertfordshire",
    "country_id:label": "United Kingdom"
  }
]

Partial HTML preview:
SG5 0AZ, {contact.province}
United Kingdom
{contact.complete_address}

Email template:
{contact.postal_code}, {contact.province}
{contact.country}
{contact.complete_address}


texts: Where is a list of breaking changes published for each new version?

texts:
We seem to have had several serious instances of loss of functionality when installing newer versions of CiviCRM. A lot of software projects have a list of breaking changes as each new version is released. Without an organized official list, I am afraid the developers might not actually be aware of breaking changes. The main losses (the ACL one filed as a bug) are:

ACLs no longer work with smart groups (this was working for us as of ~4.5.6).
ACLs don't even work with static groups anymore.

3. Bulk email, cron + CivicMail, no longer works. The cli.php cron method no longer works. We had bulk email working as of version ~4.5.6 using cli.php. I spent hours working with wp_cli recently on 4.7.4 and I can't get that to work either.

I would go back immediately to v4.5.6 if I could, but the schema changes to the database prevent this.

Edit: I fixed #3 -- I was missing the 'view all contacts' permission for the cron user.


texts: Declaring multiple maintainers for an extension?

texts: Can I declare more than one author/maintainer in an extension's info.xml file? Maintenance of one of our public extensions fell to me a while ago as the other dev who wrote it left, but I don't want to remove his name.


texts: How to create a contribution or event report that indicates amount of payment and balance owed

texts: We run CiviCRM 4.7.21. In events, we are able to indicate a registration payment toward the total with the balance owed within each participant's registration page. However, we have not been able to determine how to run a report that indicates partial payment and balance owed. Is there an event or contribution report that can be configured to run a report that shows both the partial payment amount and the balance owed?


texts: How do i delete unknown addresses from a group

texts: I am generating a list to send a mailing to via postal mail. I have created the group and now need to delete contacts from the group who don't have an address.


texts: Files in the data directory (Upload | Custom)should not be downloadable. (Nginx)

texts:
I am running a drupal site on nginx and I have a civicrm set-up on this site. Whenever I login and goto civicrm dashboard, I am getting this warnings. I have tried searching solution for this, not able to fix it.

Files in the data directory (/home/drupal7/sites/example.org/files/civicrm/custom/) should not be downloadable.

Read more about this warning

Files in the data directory (/home/drupal7/sites/example.org/files/civicrm/upload/) should not be downloadable.

Read more about this warning

I have tried this on my nginx configuration file.

    root /home/drupal7;

    location ~ /sites/example.org/files/civicrm/(custom|upload) {
        deny all;
        return 404;
    }


texts: Profile add-to-group feature doesn't work with petitions

texts:
In both the Contact Profile and Activity Profile, I've set the "Add new contacts to a Group" drop down to the desired group, but when contacts sign the petition they are added only to the Petition Contacts group.

Is there a way to automatically assign petition signers to a specific group?


texts: Why after importing contact records were Addressee field values set to "Customized" for records where Custom Addressee had a null value?

texts:
I imported a large group of organisations into a sub-org group "Media". Some orgs had a specific generic addressee (ie, Editor) which I imported into the Custom Addressee field.

After import I noticed that any record that had a null value in Custom Addressee field now also had an Addressee field = "Customized" rather than the default Addressee tokens. This behavior seems a little odd but may be a product of how civi handles default field values that rely on tokens - guessing here.

I also tried to create a Profile that would allow me to bulk update the incorrect records. While it looked like I could select the default token string from the drop down list and civi seemed to be running the update nothing actually changed.

There are rather a lot of records to be going into each summary and changing them individually. Rather than doing a re-import and deferring import of Customs Addressee data until a subsequent import, I thought I would ask if anyone had a simple solution and/or an explanation for this behavior. Any assistance appreciated.

CiviCRM 4.4.10

Thanks


texts: assigning task of writing thank-you letters to staff members

texts:
In our NGO, we write thank you letters by hand.
When I build a search that contains all contacts which donated in the last 2 months, all I can do is send them a Thank-you email automatically. I would prefer matching these contacts (around 200) to staff members (around 20), which will then write thank you letters by hand.

Any ideas how this could be achieved?
Do I have to create a CiviRules-action?(https://docs.civicrm.org/civirules/en/latest/create-your-own-action/)

Thank you very much for any help!


texts: I am using CiviCRM 4.7.3 on Joomla 3.4.8. I have noticed when going to the user dashboard that it is taking 30-45 secs to load that page. All other pages are loading in less than 3 secs. To explore the issue, I used Firefox with FireBug to see the Net loading. I found that nearly 50 items are listed as shown in the picture. These items only show when going to a CiviCRM related page.  Any help would be most appreciated. Thanks!


texts: Where can I set system workflow messages (if I can)?

texts:
I've translated and modified some Workflow messages like shown in the attachment especially Membership - Receipt and since then the new members don't get this message. I can set back to default but I would rather keep the translations and modifications.
I guess that if I can modify them (text and content) then this shouldn't perturbate the system but then I should be able, when it's not automatically done, to set some parameter somewhere 'when a membership' is pending then send 'Adhésion - reçu' message.

The question is where? I can't find.

Should I do this with CiviRules or set the message's name back to english?
Any help?


texts: Select and register multiple people for a pre-selected event

texts:
In a Drupal/Civicrm setup, how do I create a page which

Lists all members of a group
Allows user to select certain members and register them for an pre-selected event to record attendance

This is how I envision it:

Please submit attendance for this week's event:

[ ] Bob Smith
[x] Jeff Mason
[x] Susan Collins

[Submit]

My thoughts so far:

I know #1 can be accomplished with a View, but how do I allow group
members to be selected and registered for a pre-selected event?
I know #2 can be partially accomplished with a Webform, but only by typing in group member names – not selecting them from a list.

Is there a way to combine Views/Webform to accomplish this?

The ultimate goal is to automatically email a custom link to this page to group leader to submit attendance after event each week.

Thank you.


texts: How to add logo to Contributions - Receipt (on-line)

texts:
I am using Civi 4.7.29 on Wordpress 4.9.1

I need to make our online receipts look nicer.  I tried adding a table to the template Contributions - Receipt (on-line) and adding the HTML for the logo image, but nothing changed in the test.  How do I add the logo to the receipts and do other styling?

Thank you.

Added Screenshot


texts: Not found "Create Add new " option in the Current Employer field if the org name typing

texts: We're already apply " Access API Permission " to anonymous user for creating Add New option organization to the current employer field but still not works. Civicrm-4.7. And added public automcomplete ext. to the current employer field. I go through the documentation https://github.com/TechToThePeople/publicautocomplete and added code in the civicrm.setting.php


texts: Is it possible to install CiviCRM offline using WAMP?

texts:
My company is interested at offline CRM.

I would like to ask.
Can CiviCRM be installed on WAMP server?

Is it easy to customize fields by the needs of company without to be proficient in Programming/Development.

For example my company just wants a database to store their clients/potential clients and each client will have 50 fields of information (name,surname,address etc)

Is this doable with CiviCRM?
Thank you in advance.


texts: How can I easily identify recurring contributions that failed to be recorded or failed to occur

texts:
Anyone have a good recipe or a report for finding folk who had a recurring payment due in say the last 2 weeks but for whom no contribution was received?

I can see ways to do this with Smart Groups and Include/Exclude or via Drupal Views - but thought there might already be a better solution - looks like iATS have an email notification (nice)


texts: What is the significance of event_queue_id in civicrm_mailing_event_delivered table?

texts: I generally find that the event_queue_id and id values are same for all the tuples in the civicrm_mailing_event_delivered table. Why do we need a separate event_queue_id then? Can two tuples in this table have the same event_queue_id?


texts: How can I fix this problem with duplicate index in 4.7.21?

texts:
Upgraded from 4.7.17 to 4.7.21 and got the following message that I don't know how to fix. I don't have drush and the other answers to this problem don't include this index or don't fix this particular problem.  I tried "ALTER TABLE civicrm_financial_type DROP INDEX index_entity_id_entity_table_account_relationship" but MySQL can't do it and says 'check that column/key exists'.  Also tried 'ALTER TABLE civicrm_entity_financial_account  DROP INDEX index_entity_id_entity_table_account_relationship' with the same result

  Operation failed: Update Indices DB Error: already exists Debug information: CREATE UNIQUE INDEX
  index_entity_id_entity_table_account_relationship ON
  civicrm_entity_financial_account (entity_id, entity_table,
  account_relationship) [nativecode=1062 ** Duplicate entry
  '5-civicrm_financial_type-3' for key
  'index_entity_id_entity_table_account_relationship']


texts: Receipts in dashboard and annual receipts

texts:
I'm running CiviCRM under Wordpress.

I'd like to give donators access to their receipts at any time. Do you know if I can add them in a sort of user dashboard, so they can download them as pdf (same pdf recieved by email) ?

Is there a way to generate annual receipts, with all year contributions ?

Thank you if someone has an idea !


texts: PayPal Recurring Payments & Fixed Membership Type

texts:
I am new to CiviCRM, and still feeling my way around. This issue starts with some IPN failure notifications we're getting from PayPal. Researching these, I found they are only occurring on recurring payments.

These are going through, which led me to see how these recurring payments are being set up. We have a FIXED 1 year membership. The PayPay recurring payments, however, are being set for 1 year from the initial subscription, or the ROLLING type.

Setting the IPN error aside for the moment, I am unclear on how FIXED memberships should be working with PayPal. They are being set as ROLLING. Is there a way to uncouple CiviCRM Auto-Renew from PayPal and manage it manually? Or is there something I am missing to have PayPal manage FIXED correctly?

This is CiviCRM 5.21.0, payment processor PayPal - Website Payments Standard


texts: Unable to launch a fresh install of CiviCRM

texts:
I installed CiviCRM over Drupal. Everything looked fine but when I want to start the module, I get a white screen and the following error when I back to Drupal. I can't enter CiviCRM.

Warning : include(.../sites/default/files/civicrm/templates_c/fr_FR//%%06/069/0693F89E%%drupal.tpl.php): failed to open stream: No such file or directory dans Smarty::fetch() (ligne 1264 dans .../sites/all/modules/civicrm/packages/Smarty/Smarty.class.php).
Warning : include(): Failed opening '.../sites/default/files/civicrm/templates_c/fr_FR//%%06/069/0693F89E%%drupal.tpl.php' for inclusion (include_path='.:.../sites/all/modules/civicrm:.../sites/all/modules/civicrm/packages:.:.../sites/all/modules/civicrm:.../sites/all/modules/civicrm/packages:.../sites/all/modules/civicrm/vendor/tecnickcom:.../sites/all/modules/civicrm/vendor/phpseclib/phpseclib/phpseclib:.:/usr/share/php') dans Smarty::fetch() (ligne 1264 dans .../sites/all/modules/civicrm/packages/Smarty/Smarty.class.php).

My configuration is conformed with the basic requirements asked on the wiki :
GNU/Linux 3.2.65-1+deb7u2 x86_64
Drupal 7.43
CiviCRM for Drupal 7 4.7
PHP Version 5.4.45-0+deb7u2
MySQL 5.5.47-0+deb7u1-log
pcre 8.30 enabled
I changed the permissions to 755 for the 'sites/' folder. But the error still there.
I tried before on my local machine (Debian 8 and PHP 5.6). Everything was great. Why it doesn't work on my host ?


texts: Multi-Record Custom Data Set - Permissions (View/Edit)

texts:
I am using some multi-record custom data sets and they are working well. I have been able to import records, use them in reports, use them in searches, add/edit and delete records.  All seems to work fine for me except the authorization.

I have simple permissions - 1) Edit everything and 2) View Only.  However, the multi-record custom data sets are open for update (add/edit/delete) for the view only users.  The view only users cannot edit any other aspect of a contact yet they can do anything to a custom data set.

I have tried refining the permissions using ACLs for the custom data sets with the same result.

Is there something I can do to make the multi-record custom data sets not open for change?

We are using Drupal and CiviCRM 4.6


texts:
Have Civicrm 5.12.4 and wished to upgrade to 5.14.0
On running database upgrade part failed right at the end with:

An error has occurred. 0 Class 'CRM_Sparkpost' not found

When checking sparkpost with Civi menu:
Super User->Configure CiviCRM->System Settings->Outbound Email(SparkPost)
failed to take me to the SparkPost menu
So, disabled and then re-enabled the SparkPost exstension. Now the SparkPost menu above works.
Although the above seemed to work, CiviCRM still complained about needing an update to 5.14.0, despite it reporting that version at the status line at the bottom.
So, decided to test upgrade again from scratch, using a copy of today's live database - this time disabling SparkPost extension first.
Now the database upgrade just stops immediately with message:

[Executed: Cleanup old files
CiviCRM is now broken!

Tried again from scratch without first disabling SparkPost - same problem.
Any ideas?
ubuntu server 16.04.1
php 7.1.30
Joomla 3.9.6
CiviCRM 5.12.4


texts: Problem with setting the default for a custom value in the buildForm hook

texts:
What is the correct way to set a default value on rendering a form for custom values. The code below works for native fields, but not for custom fields (presumably because they are looked up through API calls.

This is the code I have so far:

            function webform_membership_civicrm_buildForm($formName, &$form) {
                if ($formName == 'CRM_Activity_Form_Activity') {
                    if (in_array($form->getAction(), array(CRM_Core_Action::ADD, CRM_Core_Action::UPDATE))) {
                        $defaults['custom_8_-1'] = 710;
                        $form->setDefaults($defaults);

                    }
                }


texts:
I have several hundred individual records that have bad mailing address and have tagged them in CiviCRM. How can I delete these from the system in bulk? I have tried Civi's upload process by leaving the address blank and using the overwrite duplicate setting, hoping this would blank out their address, but that has no effect.

Thank you.


texts: How can I change a cell in dataTables (custom data type tab with table) to disable the inline edit?

texts:
I need to make a change where some of the contact identifiers (extension Identity Tracker) can not be changed by the user. I can do that with the validateForm hook. But the Contact Identities are actually custom data of the type "tab with table" and you can also edit them inline.
The custom data tab with table uses the jQuery dataTables, and do not respect any hook unfortunately. In the  is a  with the class "crm-editable-enabled". If I can change that class to "crm-editable-disabled" I would be fine, but I have no idea how to do that with the dataTables API and the documentation shows stuff like this:
CRM.$(function($) {
  var myTable = $('.dataTable').DataTable();
  myTable
          .columns('.crm-editable')
          .nodes()
          .flatten()  // Reduce to a 1D array
          .to$()      // Convert to a jQuery object
          .removeClass('crm-editable-enabled')
          .addClass('crm-editable-disabled');
});

I can get the var myTable, but the rest does not seem to have any effect....any ideas?


texts:
On a Drupal 7.56 / CiviCRM 4.7.27 site, since the last update, when making a mailer we can only add 10 groups and then it doesn't allow us to add more.

Previously it worked for more than 10 groups.

I see no errors in front end nor back end.


texts: is there a quick way to export the complete data from my database?

texts:
I am new to civicrm, just got a job with an organisation where this is the pre-existing database. I think the data in there is in a mess and I would like to export all data to excel / csv if possible so I can check through it. Is there any way of doing this quickly?
Thanks


texts:
I am looking at using SES for a small 1,500 email list that is not super time critical.

Setup went fine - exiting the sandbox was easy - daily quota of 50k more than I will ever need.

14 emails per second - that sounds like it could be an issues - but hard to tell - How fast is the SMTP call in CIVI.Mailer

Can I use throttle time and add 100,000 microseconds between each email to lower my rate to 10 per second. For that matter I could do 500,000 and do 2 per second

Trying to avoid having to use a postfix installation.

Thoughts

Thanks


texts: We want to use Message Templates for tailoring our sponsorship renewal invoice reminders. We have multiple sponsorships setup as separate Membership Types with corresponding prices sets.  However data about "membership" is NOT available as tokens when using Message Templates. That data is available as Tokens when using  Schedule Reminders - but this means a separate Reminder is to be setup for each Membership Type. Question is why cannot Membership data (and for that matter Event data) be available as Tokens under Message Templates?


texts: Set CiviCRM profile standard field as hidden and autofill it with a string in Wordpress

texts:
I want to publish an online form to collect info requests, putting them in CiviCRM Contacts.
I prepared a CiviCRM profile showing these standard fields:

First and Last Name,
Email,
Phone,
Contact Source
Note.

Now I want to set Contact Source field as hidden and autofill it with "Web request info page" string, as a <input type="hidden" value="Web request info page"> in HTML. CiviCRM is installed under Wordpress.

How can I do this?
TIA -- Francesco


texts: Is it possible to have webform-civicrm allow 'user select' for the Contribution page so user can select Currency?

texts:
We have a situation where we need folk to be able to choose currency. currently this means multiple Contribution pages.

I was hoping we could redo this using Webform-civicrm and set the Contribution Page as 'user selects'.

This is not currently a valid setting.

Any obvious reasons why this would be difficult to accomplish?

Or is there another way to offer 'currency' directly?


texts: The CiviCRM debug log should not be downloadable - generated .htaccess seems ok

texts:
On the civicrm/a/#/status the security message The CiviCRM debug log should not be downloadable is displayed. And the complaint is correct, I am able to download the log file. But CiviCRM does generate the correct .htaccess file in de log directory in the following format

<Files "*">
  Order allow,deny
  Deny from all
</Files>

The used configuration is CiviCRM 5.3.1, Drupal 7.0 and Apache/2.2.15.

The .htaccess file is seen by apache. I tested this by making a syntax error in the file. That is reported by the webserver.

Does someone has a hint to get it working again.


texts:
I'm looking at the API and the options to update an Activity are struck through.

Is there a way of updating an activity with the API? COUld someone point me in the right direction? Thanks


texts: How do I send mailings to subsets via the API?

texts:
This is a big question :-)

I'd like to be able to use the API to send mailings to subsets of groups.

What is the simplest way to achieve this?

Ideally I'd like to be able to define a subgroup using an SQL subquerey:

SELECT contact_id FROM {{mycustom tables}} WHERE {{my custom logic}}.

Alternatively my custom code could execute this sql and pass in an array of integer IDs: [2344, 651234, 7212334, 123512... etc] (but I'd rather the SQL filter)

We have a legacy mailer that uses custom logic to identify subset of people for distributed grass roots field organisers (GRFOs) to send emails to 10-200 people at a time.

We need a very simple mailer interface for our GRFOs as given their large number and the churn in the organisation we haven't found that exposing them to the full complexity of the CiviCRM has worked.

Combining this custom filtering with custom tokens (which we already have) and our own integrated simple mailer front ends would enable us to really rock-out with the CiviCRM mailer.


texts: php putenv restrictions on server environment, how does this affect civicrm

texts:
I've got the email below from my hosting provider "wpengine". Is it going to affect civicrm, does civicrm rely much on putenv?

On July 20, 2016, we will be hardening the PHP function putenv based on industry best practices for all PHP applications.

You are receiving this message because we have detected the use of putenv on your WordPress install(s) and plugins listed below:

Plugin: civicrm

How this affects you

After Wednesday, July 20, 2016, you will no longer be able to set system-level environment variables using putenv. Any environment variables you set with putenv will be available in your WordPress site's code as it normally would.


texts: How to give a group by default to a new contact?

texts:
I'm a new user testing CiviCRM 4.6.2 with WordPress 4.2.2.

I have users U1, U2... belonging respectively to groups G1, G2...

I would like that when user U1 creates a new contact, this contact would automatically be added to group G1. Is there a simple way to achieve this?


texts:
Configuration: MacOS, MAMP, Wordpress, CiviCRM
Individual mail works fine.  Messages show up in log.
Minimal test config with users and groups marked as not-hold and bulk mail.
  Users in groups are the same as the ones that work for individual mail.

System cron set and working.  Mailing job being executed manually (for now).

Debugging and logging are turned on.

I use New Mailing to create a new mailing job.  Recipient group shows members (the same one used for individual mail). Sending to single recipient shows completion with no errors and no log messages.  Sending to group shows the same.  Following through to schedule the message shows success.  Manual triggering of job show success.  Job log shows:

2020-02-03 11:31:09 Send Scheduled Mailings
Entity: job Action: process_mailing
Summary
Finished execution of Send Scheduled Mailings with result: Success (a:1:{s:9:"processed";i:2;})
Details

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

Full message:
Finished execution of Send Scheduled Mailings with result: Success (a:1:{s:9:"processed";i:2;})

Nothing is in the CiviCRM..log

Any suggestions or help would be much appreciated.


texts:
Is it possible in CiviContribute to track multiple external (non-CiviCRM) sources of contributions to a single form?

I've used other systems where I could create a source code for, say, a banner ad and apply that source code to the donation form URL. I could then create another source code for donation links within an email. Sometime later, I'd be able to pull up a donation report for that form and see that there were X number of donations that came in from the banner ad, and X number from the email.


texts: Civivolunteer Declaration of CRM_Volunteer_Permission Line 221 ClassLoader.php

texts:
Drupal 7.67
Civicrm 5.15.2
Civivolunteer 4.7.31-2.3.1

I am getting the following message on a number of screens:

Warning: Declaration of CRM_Volunteer_Permission::check($permissions) should be compatible with CRM_Core_Permission::check($permissions, $contactId = NULL) in require_once() (line 221 of /home/mysite/public_html/members/drupal/sites/all/modules/civicrm/CRM/Core/ClassLoader.php).

The biggest issue is the volunteer sign up screen.

Any ideas?


texts:
I've managed to generate new fields but I can't add them into the report templates. How can I do that?

Thank you


texts:
My contribution pages (that I use to collect new members on a website) are completely crazy, just showing the page title repeatedly some 10 or more times.

But when I try to do a test-drive everything looks fine.

Based on a similar question here, I tried to create a new page from scratch, but the problem persists.
No idea where to start digging :/


texts: I'd like to be able to set up recurring monthly gift donations.  Is this possible with my CRM? Currently, we can accept one time gifts but can't seem to figure out how to take automatic monthly gifts.


texts: How to use CiviCRM REST API in external PHP code

texts:
Been trying to get this to work for hours. Help would be greatly appreciated. userkey and sitekey are replaced with actual keys.

I'm trying to run in a php file:

$result = curl -X POST "https://www.mysite.org/sites/all/modules/civicrm/extern/rest.php?entity=Membership&action=get&api_key=userkey&key=sitekey&json={"sequential":1,"return":"membership_type_id,id,end_date","contact_id":2,"active_only":1,"options":{"limit":1,"sort":"join_date DESC"}}";

I get the error:

PHP Parse error:  syntax error, unexpected 'POST' (T_STRING) in /home/spulver/civicrmapi.php on line 3

Any ideas how to fix?


texts: WSOD, time lag when creating/copying contribution, event pages

texts:
We recently upgraded to WP 5.6, CiviCRM 5.32.1
Since the upgrade, we see this behavior:

When trying to create a new contribution or event page, we receive the White Screen of Death (WSOD) and nothing more

When copying an existing contribution or event page, we receive the WSOD, but shortly after returning to CiviCRM, a notification pops up that the copy was successful.  The copied item appears on the manage contribution or event page

Thanks in advance ...


texts:
with the help of another users i was able to get my CRON jobs to run however I seem to be getting a different error now:

Fatal error: Smarty error: [in string:&lt;meta content=&quot;text/html; charset=UTF-8&quot; http-equiv=&quot;Content-Type&quot; /&gt;
&lt;meta content=&quot;width=device-width; initial-scale=1.0; maximum-scale=1.0;&quot; name=&quot;viewport&quot; /&gt;
&lt;title&gt;&lt;/title&gt;
&lt;style type=&quot;text/css&quot;&gt;div, p, a, li, td { -webkit-text-size-adjust:none; }

*{
-webkit-font-smoothing: antialiased;
-moz-osx-font-smoothing: grayscale;
}

.ReadMsgBody
{width: 100%; background-color: #ffffff;}
.ExternalClass
{width: 100%; background-color: #ffffff;}
body{width: 100%; height: 100%; background-color: #ffffff; margin:0; padding:0; -webkit-font-smoothing: antialiased;}
html{width: 100%; background-color: #ffffff;}

@font-face {
    font-family: 'proxima_novalight';src: url('http://rocketway.net/themebuilder/template/templates/titan/font/proximanova-light-webfont.eot');src: url('http://rocketway.net/themebuilder/template/templates/titan/font/proximanova-light-webfont.eot?#iefix') format('embedded-ope in /home/promedic/public_html/wp-content/plugins/civicrm/civicrm/packages/Smarty/Smarty.class.php on line 1094
<!-- deferred 0 scripts, deferred 0 styles & minified html in 1 seconds -->

My cron jobs looks like this, and seems to be running ok if i am to believe the run times in the scheduled jobs page

/usr/bin/wp --user=USERNAME --url=https://URL --path=/home/promedic/public_html --timezone="Pacific/Efate" civicrm api job.execute auth=0

I am running Civi 4.6.14 on WordPress 4.7.2

thanks in advance for any help


texts: How do I embed an image into CiviMail messages?

texts: Is possible to embedd images into civimail mailings? Would be great to have a choice between loading images from the server and sending them along with the mailing. For example Acymailing have this option. Is it possible in CiviMail?


texts: Can I easily sync/import Facebook Event attendees with a CiviCRM Event participant list?

texts:
A lot of my users like to use Facebook Events for quickly inviting their friends and contacts to an Event.

Facebook allows Event attendees and status to be exported by the Event owner or manager - the only fields allowed to be exported are the Guest (attendee) full name and Facebook Event status (Going, Maybe or Invited).

I can export that attendee list from Facebook and import the attendees into Civi using an Unsupervised dedupe rule with First Name and Last Name (once I separate them out in the .csv file) and an updated Event Status to match Civi values (Registered or Attended).

But - is anyone using the Facebook API (or other Facebook Developer tools) or CiviCRM API to automate this process, and/or able to get more fields exported out from Facebook?

And if you're wondering "why not force your users to use a Civi online event registration page instead?", that's valid, but I'd rather not discourage my users from using other tools - especially Facebook, with which they are already very familiar and like - which is often not the case with Civi :(. I'd rather figure out how to quickly sync/integrate/import Facebook data into Civi.


texts: CiviCRM Email seems not to use Outbound Email settings

texts:
I've saved outbound email settings with:

Using sendmail
Path: /usr/sbin/sendmail
Arguments: -t -i

When I press "Save and send testing email",
I can receive testing email correctly from sendmail.

But When I send email with CiviEmail, both testing and batch sendings,
Outbound email settings seems to be ignored.

It had worked correctly CiviCRM 4.6,
but suddenly broken after I upgraded CiviCRM to 5.9.1.

I noticed this issue, because I am doing relay_host settings with sendmail.
It worked on 4.6, but after I upgraded, it doesn't.

Any suggestions?

Here is my sendmail setting.
It is working, but when I use CiviEmail it seems not to be used.

relayhost = [domain.for.send]:25
smtp_use_tls = yes
smtp_sasl_auth_enable = yes
smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd
smtp_sasl_tls_security_options = noanonymous
smtp_sasl_mechanism_filter = login
smtp_sasl_type = cyrus
smtp_tls_security_level = verify
smtp_tls_CApath = /etc/pki/tls/certs/ca-bundle.crt
smtp_fallback_relay  = [localhost]


texts: How to store template_id that new event is derived from

texts:
I'm working on an event management framework where I want to have a set of event templates, and create events based off of those templates.

I'm trying to find a way to get at and store which template a newly created event was derived from but I can't quite figure out what to do.

I tried looking at both
hook_civicrm_postProcess() (which has the template_id but not the new event's id)
and hook_civicrm_post() which as the newly created event id, but doesn't tell you what template it was derived from.

Can anyone think of a way to find those two values at the same time so that I can put the data in a custom field on the new event?


texts: Can I make reports export the state/province abbreviation instead of full name?

texts: Similar to this question, I'm interested in having my reports export states/provinces with the abbreviation instead of the full name. The accepted answer in that case was to use an Advanced Search rather than a Report -- but in my case there is no advanced search to get the contacts I need and I'm using a custom report, so I need to figure out how to do this in the CiviReport side.


texts:
Site Health in WordPress is showing a few cURL error 28 errors when we have CiviCRM installed and activated. Deactivate CiviCRM, the problem disappears. Activate it, the problem is back.

I've seen the WordPress Site Health contains critical errors unless CiviCRM is disabled question, but my research has found no justification for the top response that the health checks are inaccurate. So I need to dig deeper to try to solve this.

During a long chat session with tech support for the hosting company (SiteGround), they could find no reason for the error on their end. Server memory is maxed out, phpinfo shows everything is current and up to date (and shows server memory as 768M). So far, all of the diagnostic things I've found online have been dead ends.

With Query Monitor installed, I can see that the offending call is Health_Check_Site_Status->get_test_rest_availability(), which uses the URL

https://[URL]/wp-json/wp/v2/types/post?context=edit

That health check works fine with CiviCRM disabled, but chokes with it activated, giving the cURL error 28.

What is CiviCRM doing that causes that call to fail?


texts: What broke the contribution thermometer blocks in the CiviCRM 4.7 upgrade? How to resolve the issue?

texts:
Upon upgrading from CiviCRM 4.6.x to 4.7.x, the CiviCRM contribution thermometer within a Drupal block stopped functioning. Please see the current state of the block:

I have found some posts that sound related to what we are seeing:

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

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

I posted a reply to the CRM-17965 post as to trying the suggested patch back on CiviCRM 4.7.3, which did not change what we see displayed in the block... however it did achieve the test URL displaying HTML rather than nothing, so I would have hoped for some change in behavior of the actual Drupal block.

Suggestions how to get this resolved?

I am thankful,
Michael


texts: Embed video in Profile field for directory

texts:
Working on a public directory. The listings include a link to a YouTube video. It is working fine with a custom field of the type link. We would like to embed the videos in the search results. I created a custom field for this. When I add the embed code in the back end I get.

  Network Error
  Unable to reach the server. Please refresh this page in your browser and try again.

If I use a text area field with rich text editor and paste the code using the source view the video shows and can be played when you switch out of source but it will not save.

Using WordPress 4.9 & CiviCRM 4.7.27


texts:
Via the System Adminsitrator Guide: profile listings and forms : If you plan on collecting name and address or other information from visitors, enable this permission for the "anonymous" role.

Via the permissions page the following is noted: Warning: Give to trusted roles only; this permission has privacy implications. Add/edit data in online forms and access public searchable directories.

To most - Anonymous is not a "trusted" role - wondering why the warning is given - and what is the best practice.


texts: How can I clear all contacts (as if they never existed) without touching any CiviCRM settings?

texts:
After having put a lot of time into customizing a CiviCRM installation, I want a way to replicate the configuration / customization / installed-extensions, but start from scratch on the contacts (so that newly added contacts -- after the admin contact and organization -- have contact-ids of 3,4,5,...).  Deleting all contacts via the UI doesn't seem to "reset" the next-contact ID counter.

Perhaps one way this could be possible is if there were a means by which all configuration / extensions could be backed up and restored, independent of the data in the system (e.g. contacts, memberships, contributions, etc.).  Is this possible somehow?  Or is there another way to achieve my goal of "starting over" with non-configuration data?


texts: Moving contribution from individual to organization

texts:
I have a contact in CiviCRM that is of contact-type Individual in CiviCRM. In real life, this is an organization.
I want to convert this contact from an Individual to an Organization. How do I do that?
(I could just delete the contact, and create a new contact, but I really want to keep the contribution history. So then I would need to move that from one contact to another. Using merge contacts only works within same contact-type. So this solution doesn’t seem to work either)


texts: Creating a single manage your subscriptions link for mails sent via CiviMail and Mailchimp

texts:
We have a number of mailing lists, some of which are synchronised with mailchimp lists with emails sent via mailchimp (organisational culture means that they want to keep these with mailchimp). The others are sent via CiviMail.

We've created a manage my subscriptions page that contains all mailing list subscriptions. We can provide a checksummed link to this page from CiviCRM mailings I am struggling to see how we could create this from mailchimp. One thing we can do is create links in mailchimp of the form example.org/link-to-manage-my-subscriptions?email=email@example.org. And have this URL trigger an email to the recipient that authenticates them to example.org/link-to-manage-my-subscriptions.

I'm wondering if I am missing a trick that would allow us to create a checksum link in mailchimp and authenticate to that page without the extra email step.


texts: Is there a way to schedule mails depending on whether or not a contact has opened a previous email?

texts:
We are planning to take a lead capture action where we want to take two automated actions by email:

(1) Send an email the day after the contact is created in the CRM. This is possible through the Schedule Reminders tool.

(2) Send an email one week after the contact is created in the CRM only for those contacts who have not opened the first mail.

Is there any mechanism or functionality that will allow this second action to be performed?


texts: How to extend Database Log Report from Contact

texts:
I would like to extend standard functionality of Database Log Report generated from contact.

For now there is list of standard colums, but there is no information about what changes was made in fields. Only interactions are tracked.
I would like to have report, which will show me changes on fields, eg changes in email address.

Is there any solution for that?


texts: DataTables warning with dedupe on find & merge (after upgrade to 4.7.18)

texts:
Is anyone else seeing a new DataTables warning in 4.7.18? We get the following warning on the dedupe page when finding duplicate contacts:

[Server Name] says:

  DataTables warning: table id=dupePairs - Cannot reinitialise DataTable.
    For more information about this error,
    please see http://datatables.net/tn/3**

(Joomla version 3.6.5, php 5.6.30, mysql 5.6.36)
Thanks.


texts:
Our club has a two-stage membership process when it pertains to new members. In order to join our club, a person must first join us as a guest, for which there is a fee. The guest fee is applied to their registration fee when they become a member, as long as they become a member within the same membership term (we use fixed annual memberships, and we don't pro-rate memberships).

My initial thought was to have two different membership types: Guest and Club member, however when you change their membership type from guest to member the system adds another term to the membership instead of just changing it for the current term. We can manage this manually, but doesn't work so well with self-service profiles. The fact that we deduct the guest fee from the member fee isn't a problem, we can manage that with fee structures or CiviDiscount.

My next thought was to create a membership status for guests. When someone registers as a guest, they would become a member with a "guest" status. As far as I can tell however, there isn't a mechanism to automatically set the status to guest upon registration or based on the price set. You have to do it manually. All of the state rules are related to dates.

I also thought I could have users register for an event (when they come as a guest) and use their event registration to apply a discount to the membership, but we don't have a specific event for them to register for.

I've asked a few, more specific questions related to the above options, but I hope a less specific question with more application details might lead me in a direction I hadn't considered.


texts: How to email admin to notify of a scheduled activity

texts:
Apologies if I have missed a completely obvious bit of documentation.

I want to automatically send an email to our admin users if they schedule a phone call for a later date. Eg, if an admin user named Kathy records a phone call activity for a contact, and then schedules another phone call activity for a week later, it would be great if Civi could email Kathy the day before her scheduled phone call is due. The email should be personalised to Kathy, and at least contain a link to the scheduled activity. And preferably the name of the contact she's trying to call.

I've tried Scheduled reminders, but don't know the tokens that might give the activity id and the name of the target contact.

I've tried CiviRules with the email API extension, but couldn't figure out how to get any activity tokens into the email.

So, what am I missing, or indeed, is this possible? Thanks for your thoughts!

Drupal latest, civi 5.21


texts: How to fix: webform_calculate doesn't read values in fields that have been 'set to' by conditionals

texts:
Drupal7, Civi5.12
I've used webform conditionals to 'set to' values for fields. Now I want to run calculations on those fields using webform_calculate,

But webform_calculate won't recognise the 'set to' values.
Any ideas?


texts: Number of contacts vs. hosting space required

texts:
Apologies if these questions seem pretty elementary, but I am having a hard time finding definitive answers anywhere else on the web:

1) Is there a maximum number of contacts one can include in a CiviCRM database? A lot of free CRM options out there have a 10,000-contact maximum, and I wanted to make sure CiviCRM does not.

2) If there is no contact maximum, approximately how much hosting space would a 10,000-contact database require? What about a 25,000-contact database?

Thank you so much in advance for any help with answering these questions!


texts: Fatal Error when accessing Civi in WP Install

texts:
My Civi seems to be broken, and I'm really unsure why! This is the error I receive when trying to open the base CiviCRM homepage.

Fatal error: Uncaught CRM_Core_Exception: [0: Invalid cache key: Not a string thrown in /home2/snachodo/public_html/boyscoutstech/wp-content/plugins/civicrm/civicrm/CRM/Utils/Cache.php on line 221

Can anyone point to a resource to resolve the error?

A further complication that I didn't realize until this week is that I am unable to create new blog posts or pages in WordPress. I receive the same error as above. However, WordPress works when I deactivate CiviCRM as a plugin.

Log message below:

[22-Dec-2018 00:25:12 UTC] PHP Fatal error:  Interface 'Psr\SimpleCache\CacheInterface' not found in /home2/snachodo/public_html/boyscoutstech/wp-content/plugins/civicrm/civicrm/CRM/Utils/Cache/Interface.php on line 40
[22-Dec-2018 00:47:24 UTC] PHP Fatal error:  Interface 'Psr\SimpleCache\CacheInterface' not found in /home2/snachodo/public_html/boyscoutstech/wp-content/plugins/civicrm/civicrm/CRM/Utils/Cache/Interface.php on line 40
[22-Dec-2018 22:29:32 America/Denver] PHP Warning:  Declaration of CRM_Mailchimp_Permission::check($permissions) should be compatible with CRM_Core_Permission::check($permissions, $contactId = NULL) in /home2/snachodo/public_html/boyscoutstech/wp-content/uploads/civicrm/ext/uk.co.vedaconsulting.mailchimp/CRM/Mailchimp/Permission.php on line 40
[22-Dec-2018 22:29:38 America/Denver] PHP Warning:  Declaration of CRM_Mailchimp_Permission::check($permissions) should be compatible with CRM_Core_Permission::check($permissions, $contactId = NULL) in /home2/snachodo/public_html/boyscoutstech/wp-content/uploads/civicrm/ext/uk.co.vedaconsulting.mailchimp/CRM/Mailchimp/Permission.php on line 40
[22-Dec-2018 23:15:00 America/Denver] PHP Warning:  Declaration of CRM_Mailchimp_Permission::check($permissions) should be compatible with CRM_Core_Permission::check($permissions, $contactId = NULL) in /home2/snachodo/public_html/boyscoutstech/wp-content/uploads/civicrm/ext/uk.co.vedaconsulting.mailchimp/CRM/Mailchimp/Permission.php on line 40
[03-Jan-2019 09:02:18 America/Denver] PHP Warning:  Declaration of CRM_Mailchimp_Permission::check($permissions) should be compatible with CRM_Core_Permission::check($permissions, $contactId = NULL) in /home2/snachodo/public_html/boyscoutstech/wp-content/uploads/civicrm/ext/uk.co.vedaconsulting.mailchimp/CRM/Mailchimp/Permission.php on line 40


texts:
I am running Civi on Joomla and want to set up an email auto-reply. How do I do this?

Thank you!


texts: All emails are sent from the same address

texts:
I've noticed recently that when you send an email via Actions->Send Email, it does not show as being from the address you are logged in with or the one you choose from the drop-down. Instead it always comes from the same address (presumably one that is configured globally somewhere).

The reply-to address is correct, but the from address is not.

There is nothing in the bug tracker about it. Is anyone else having this problem? I have not consciously changed any email settigs... I'm on civi 4.7.22 on Drupal.


texts:
Drupal 7 and CiviCRM 4.6

Using the Webform extension, which is amazing of course.  Is there a way to get the confirmation page to look like the page would be if somebody was using a native CiviCRM form.  For example for a new membership, it would show name, membership expiration date etc?  This does get emailed but sometimes our members don't get our emails, so it is nice to have a confirmation page they can print with these fields like you can in a CiviCRM form?

Might be obvious thing I am missing.


texts: How to move recurring contribution when changed Payment processor?

texts: We are moving from paypal to another processor. But there’s lots of recurring contributions that are already setup with paypal. What is the best practice when changing payment processors? Thanks


texts:
my organisation has a site on which payed events are offered. Visitors can pay via an IDEAL mollie payment with use of a custom build module.
We want to replace that module by making use of the civicrm mollie interpay module.

Up to now, we have been unsuccessful in  testing this module. The test payments don't work at all, while production payments do work, but not yet in a way that we can use it in our site.

I hope you can guide me in making the production payments work.

The site is a wordpress based site. We use civicrm 5.18.3. For payment we use the interpay (mollie) method.

When a payment is done with mollie, the payment is registered and visible in the event dashboard. So the most important part works. But the user who has finished the payment (and clicks the 'back to webshop' button) gets a blank screen.
The URL of that blank screen ends with wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fpayment%2Fipn%2F86%2F8

We find it not acceptable to incorporate this on our site in this form. Can you help me by advising me what to do to present the user a confirmation screen?

thanks for helping, Ruud


texts: Event white screen of death when user registers for an event

texts:
I upgraded to CiviCRM 4.6.4 on Joomla 3.4.2 after a year on older versions. I've cloned a previously working but expired event. Registration from the back-end works fine but from the front-end gives this error:

  Fatal error: Call to undefined method CRM_Core_Payment_Form::setPaymentFieldsByProcessor() in /home/***/www/www/administrator/components/com_civicrm/civicrm/CRM/Event/Form/Registration.php on line 388

If I make it an unpaid event (Configure Fees with Paid Event = No), I get a different error:

  Fatal error: Call to undefined method CRM_Core_Payment_Form::buildPaymentForm() in /home/***/www/www/administrator/components/com_civicrm/civicrm/CRM/Core/Payment/ProcessorForm.php on line 114

Advice please!


texts: 4.7.1 API query for contributions in same year returns no results

texts:
This worked correctly in 4.6.8, but not in 4.7.0 or 4.7.1.  This query returns no results:

$result = civicrm_api3('Contribution', 'get', array(
  'sequential' => 1,
  'receive_date' => array('BETWEEN' => array("2016-01-01", "2016-03-31")),
));

But this one does return contributions from 2016:

$result = civicrm_api3('Contribution', 'get', array(
  'sequential' => 1,
  'receive_date' => array('BETWEEN' => array("2015-12-31", "2016-03-31")),
));

As far as I can tell, any query for contributions in the same year returns no results.  Is this a bug?


texts: Custom field saves, for all entries, instead of wanted data a number that is not in original data

texts:
I'm having an odd problem with a custom field within a custom data set.
The field is made for personal identification number, data type is integer and it's a single line input field.
Every time I enter the data either manually or through import (careful about choosing corresponding fields) upon clicking the save button instead of saving the wanted number it saves a completely different number that's not in my data (it's always the same number).
I even tried to delete the custom field (with corresponding data), then create it again and manually add it back but nothing.
Using WP


texts:
We are running Drupal 7 and the Metatag module, which is working as intended on the rest of the site.

While our contribution pages are working fine, they do not contain the description and keyword meta tags that appear on the other pages on our site.

Can someone point me in the right direction to get this functioning?

Thank you!
Rachel


texts: Contacts visible in mailing list group, not on hold or otherwise dnd, but skipped by mail out

texts:
I'm fairly sure I've worked out why this is happening, but want some input to confirm the problem, and hopefully pointers for fixing it.

We totally refreshed our main mailing list in line with GDPR, so we've been mailing about 2000 people with only a handful of bounces and unsubscriptions; now suddenly with our latest mail out, CiviCRM is only finding half of these people. Looking at the group, they're still there, and only a dozen of these are on hold due to bounces. Anyone who unsubscribed isn't counted towards the group total, so that's not the issue. Checking for duplication, it's not that we accidentally created 1000 duplicate contacts, so that's not the issue.

What has happened between this mail out and the previous one is that I've imported additional contact info for a lot of our contacts, and although the emails have been matched, so the contact records have been filled rather than duplicated, the newly imported emails have all been added as 'Home' - and the original email was 'Main', or 'Work', or 'Billing'...

Which is fine, if messy - lots of duplicated emails in records, but all the info is in the correct contact record. The problem - as far as I can work out - is that none of the emails have been marked as the one to be used for bulk mailings, and rather than default to the primary email for those contacts, CiviMail simply skips those contacts completely.

So, assuming I haven't missed something, it seems like the only option I have is to edit the database with something along the lines of 'if email is primary, set is bulkmail to yes' - given that my confidence in editing via sql is more or less nil, I'd be grateful for any pointers in carrying this out.

ETA: I’ve noticed that a couple of contacts which do have the bulk mail selected (both with two different emails to send the mail out to, rather than duplicate emails) also did not get sent the mail out, so it looks like setting the bulk mail email isn’t going to fix this...

(It also appears to happen with a smaller mailing list - nearly 100 contacts in the group, none on hold, but only 49 recipients indicated when you add that group to a new mail out)

ETA #2: Finally managed to pin this down to missing values in the is_deceased field - all the contacts with newly imported data seem to have lost the value for this field, even though I'd set the import mapping to skip that field entirely (as I'd already eliminated removed any deceased contacts from the import). Resetting the field to 0 fixed the problem - everyone is now back on the recipients list...

I will add the fix as an answer :)


texts: Did anyone have a problem with CKEditor after 4.6.22 upgrade?

texts: After updating my Civi installation from 4.6.x to 4.6.22, my CKEditor was broken (blank screen in edit window, all areas).


texts: Is it possible to allow people to submit their own events to CiviCRM?

texts:
I would like to create a website that collates events from several organisations.

The site should allow each organisation to submit their own events.  However the submitter should not have full access to CiviCRM.  In particular they shouldn't be able to see or modify events submitted by other organisations. (They don't necessarily need to be able to access or modify their own events, though it would be helpful if they could.)

The events need to go through a moderation process so that an administrator must approve each event before it goes live.  Once the event is live it would be displayed publicly with events from other organisations.  Visitors to the website would be able to view events from all organisations and book a place on any that they wish.

Is it possible to do this using CiviCRM?  If so, how would you suggest that I go about this?  Could webform be used for this?

Thanks for your help.


texts: How can I resolve Civi Dashboard Javascript error: widget.name is null?

texts:
I've just upgraded a Civi 4.6.18 install to 4.7.15. All has gone fairly smoothly, apart from the fact that the CiviCRM front page/dashboard is broken.

My Firebug console reports: "TypeError: widget.name is null" and refers to http://siteroot.com/sites/all/modules/civicrm/js/jquery/jquery.dashboard.js line 467 col 13

I know that some of the dashlets that display in my dashboard have been created by setting up some reports to suit, and simply making those available as dashlets.

Looking in the database, I checked the civicrm_dashboard table, and noticed that three of these 'custom' dashlets had NULL in the name column. Interestingly, other similarly created dashlets had an entry in the name column of the form 'report/xx'.


texts: Does Google Hangouts SMS integrate with CiviCRM?

texts: SMS seems to be hit and miss at the moment, with Twillo and Clickatell as the only choices. Since Google Hangouts can be used for SMS, is there a way to use that service, assuming the other two don't measure up? Is there anyone working on this, with an extension in anything resembling usable shape? What would it take, if nothing exists, to create something that uses Hangouts?


texts: Activity Separation field- set an option as default

texts:
When you record an activity with multiple target contacts, the Activity Separation option appears. When it first shows it is not immediately obvious that this is a required field.

One of our clients regularly records activities with multiple targets, and by and large only want to record one activity for all.

Would it be possible to set one activity for all- as the default option for this field? And if so, where would I do that?

Also. What are the potential drawbacks of doing this?


texts: How to add a custom field in Civicase that can be retrieved later?

texts: My question sounds simple, but... to explain. We are using Civicase to manage mentoring.  I want to add from 1 to 6 mentoring goals for each case - these would be text fields individual to each case.  When the mentoring is completed (months later) the goals are then 'picked' as ones which best matched to our funder's 4 targets. My problem is that I can't see a custom field to hold these goals that would do this or just lack the imagination on how to manipulate Civi to achieve this! I'm using 4.7 with Drupal, have about 5 years Civi experience but prefer not to code. Would a webform be the answer? Maybe I just create 6 text fields, each one with an associated drop down select with the funder's targets - but that seems a bit clumsy.  It seems that what I need to do is to allow the user to enter data into a select box, but that doesn't seem possible with custom fields.


texts:
I have 100 surveys filled out by people already on my database. I want to enable a volunteer to be able to enter these by making available to them only the fields they need to do the data entry. I have created a profile which has a listings view and which is searchable; I have limited the profile to the group in which the 100 contacts are found. So I can find the contact and I get the option to view just the fields I am interested in, but there is no edit option and no inline editing available. Is it possible to do what I want? If yes how would I go about it?
Thanks


texts: Can Wordpress handle multi-site CiviCRM the same way Drupal 7 with domain access does?

texts:
My organization is currently running a multi-site CiviCRM deployment on Drupal 7 using the domain access module.

We set permissions on the contacts by using the state field so that the leadership in a state can only see that state's contacts.

Some states also have home pages with custom content and menus, but use the bulk of the national web site as "background" content.

The above configuration has served us well for several years now, but we keep getting push back from states that Drupal is too hard to use and people aren't posting content for that reason.

Can we replicate this same functionality on the WordPress platform? If not, how close can we get?


texts:
wordpress 4.9

And recently upgraded to civicrm 5.22 CiviRules 2.1

Was working fine with older civirules and E-mail API 1.10

this is the error

CiviCRM_API3_Exception: "Could not find the SQL file."

#0 /home/domain/public_html/wp-content/plugins/civicrm/civicrm/CRM/Admin/Form/Extensions.php(190): civicrm_api3("Extension", "install", (Array:1))
#1 /home/domain/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(453): CRM_Admin_Form_Extensions->postProcess()
#2 /home/domain/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/StateMachine.php(160): CRM_Core_Form->mainProcess()
#3 /home/domain/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php(61): CRM_Core_StateMachine->perform(Object(CRM_Admin_Form_Extensions), "next", "Next")
#4 /home/domain/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Admin_Form_Extensions), "next")
#5 /home/domain/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Admin_Form_Extensions), "next")
#6 /home/domain/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("next")
#7 /home/domain/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Page/Basic.php(398): CRM_Core_Controller->run()
#8 /home/domain/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Page/Basic.php(156): CRM_Core_Page_Basic->edit(1, NULL)
#9 /home/domain/public_html/wp-content/plugins/civicrm/civicrm/CRM/Admin/Page/Extensions.php(121): CRM_Core_Page_Basic->run()
#10 /home/domain/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(309): CRM_Admin_Page_Extensions->run((Array:3), NULL)
#11 /home/domain/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:16))
#12 /home/domain/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#13 /home/domain/public_html/wp-content/plugins/civicrm/civicrm.php(1246): CRM_Core_Invoke::invoke((Array:3))
#14 [internal function](): CiviCRM_For_WordPress->invoke("")
#15 /home/domain/public_html/wp-includes/class-wp-hook.php(286): call_user_func_array((Array:2), (Array:1))
#16 /home/domain/public_html/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters("", (Array:1))
#17 /home/domain/public_html/wp-includes/plugin.php(453): WP_Hook->do_action((Array:1))
#18 /home/domain/public_html/wp-admin/admin.php(224): do_action("toplevel_page_CiviCRM")
#19 {main}

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


texts: Can you create a mailing list based on tags

texts: Is there a way to use tags, possibly multiple tags e.g. using the tags Students and Attended Conference X, to create a bulk mail to members who fit into just those two categories.


texts: Is There A Way to Aggregate PDF Letters the Way Labels are Aggregated

texts:
When you create labels you can aggregate them by address.  I want to be able to do this for PDF letters as well so that they match the labels.  I have looked all over and do not see another way to do this.

Thanks,
Steve


texts: Drupal 8 / CiviCRM ; Directories that need to be manually created?

texts: I've created a d8/civi site on all three of bionic/eoam/focal and now have worked out the variances between them to the state that I now have an operational


texts: Can a message template replace tokens with appropriate translations?

texts:
I see the option to set a contact's Preferred Language, and I have set up my test system with French and English.  If I make French the default for the whole system, when I edit the demographics of a contact, the radio options are in French, but the displayed text after saving is in English.

When I send an email to a contact with French as the Preferred language, and use the token contact.gender, the token replacement is still in English.

Is there a way to have token replacements respect the preferred language for each contact, and use the translated value?  Or am I stuck with English values because the system was installed in English?


texts: After installation Civi menu and dashbord do not show (SOLVED)

texts:
after a successful installation of CiviCRM 4.7.19 on WordPress 4.7.4 – the installer said everything was fine –, the menu and dashboard of CiviCRM does not show.

I know, this issue has been addressed elsewhere, but the solutions proposed there didn't work for me.

For instance, in the following case: Civi dashboard and menus won't display after install the solution seemed to be to replace the CiviCRM Resource URL which was set to default. However, the solution does not say, how to find and access this Resource URLs settings page where this default would have to be changed.

In another solution Word Press Install Missing civicrm.settings.php; dashboard unavailable; no menus it was suggested to install a certain plugin https://wordpress.org/plugins/civicrm-admin-utilities/ , which unfortunately also did not help me.

I've also looked into similar cases on Drupal, like this one: Civicrm menu is hidden
There someone suggested to rebuild the menu via adding /civicrm/menu/rebuild to my page, but it only gave me an error saying I'm not permitted to access that page.

I'd be glad to hear some of your ideas on this issue.

Thanks and best regards!
Jannis

EDIT: Posted the solution below.


texts: Batch alter Relationship Contact Permission only

texts:
While trying to alter Contact Relationships Permission ("Contact A can view and update information about Contact B") using this code:

$result = civicrm_api3('Relationship', 'create', array(
  'debug' => 1,
  'contact_id_a' => 111,
  'contact_id_b' => 111,
  'relationship_type_id' => 111,
  'id' => 111,
'is_permission_a_b' => 0, /* <- This was manually set as 1 and need to be altered */
));

we've got "duplicate relationship" error message

"error_message": "Duplicate Relationship"

Deprecated "setvalue/update" suggestion is "Use "create" with an id instead." and we do have all IDs in place.  Does 'Create' for Relationships work as it works for Contacts or we've missed something?

UPDATE 1
After some debugging it has turned that  we have exactly same situation described here How to change the direction of a relationship type with existing data , but we weren't aware that changing Relationship direction via GUI doesn't make change in a database. Sounds like another civicrm bug.

UPDATE 2
Even after Relationship directions have been altered, same error "Duplicate Relationships" appears at an attempt to ALTER one of Relationship parameter  using CREATE Action via CiviCRM Api.


texts: Unable to cancel a PayPal_Standard recurring transaction

texts: I created a contribution page using the PayPal_Standard payment processor.  When I used it to set up a recurring contribution, it seemed to be set up ok, but I was unable to cancel it, either using the link in the email or from with CiviCRM. I am using CiviCRM 4.7.30 and Drupal. Is there any other config for recurring payments in CiviCRM?


texts: How to Insert html in custom field (type TextArea) via API

texts:
I have a custom field with data type 'Note' and field type 'TextArea'. When I insert a value using the CiviCRM interface, I can insert text via an editor, and bold text gets displayed as bold, italic etc.

Now I want to put html in this same field using the API, but the problem is that any html characters are converted to html entities when inserted.

  $params = array(
  'contact_id' => $contact_id,
  'entity_id' => $contact_id,
  'custom_' . $content_field_id => '
' . implode('

', $data['note_content']) . '
',
);
$create_note_result = $spcivi->api('CustomValue', 'create', $params);

html send via api:

Vette tekst is toegestaan!

Shuine ook!

result content in field:

&lt;div class="note_content"&gt;&lt;strong&gt;Vette&lt;/strong&gt; tekst is toegestaan!&lt;/div&gt;&lt;div class="note_content"&gt;&lt;em&gt;Shuine&lt;/em&gt; ook!&lt;/div&gt;

Is there a way to insert html without the html characters being converted to html entities? Using the field type TextArea becomes quite useless when not html can be inserted.


texts:
When working in various set up stages of CiviCRM, a new member page or contributions page I often get this error message:

  The requested URL could not be retrieved
  While trying to retrieve the URL:....
  The following error was encountered:
  Zero Sized Reply.
  Squid did not receive any data for this request.

Is this only because WordPress failed to auto update? Is this something only my Cache Admin can solve?