texts: How To View Documents Uploaded Through Custom Profile

texts:
I created a custom profile field which has an upload field to allow users uploaded scanned documents as part of their contact records so that when viewing the user's Civicrm Contact record i can view the uploaded document.
However I find that when viewing the contact record i cannot see the uploaded documents. Only the upload field is visible.

Does anyone know how this can be implemented in CiviCRM or am doing something wrong? I am using CiviCRM 4.6.15 with wordpress.

Thanks in advance for your comments.


texts:
I've noticed upon matching mapping fields in the import process that for some fields in the file they are missing in the CiviCRM drop-downs. For instance, for a field named "Home County' the CiviCRM drop-down for 'County does not appear. But choose 'Employee of' and 'County' appears. In fact, it is one of the only other, unrelated fields that it appears.

Please advise. Thank you in advance.


texts: Chamber of Commerce with multiple levels and sublevels of membership

texts:
I am in the process of evaluating CiviCRM for a Chamber of Commerce site that I am working on.

This specific Chamber has 4 levels of membership, each with 4 levels within it,  So:
Classic with 1 to 5 employees = $175
Classic with 6 to 10 employees = $225
Classic with 11 to 20 employees = $275
Classic with 21+ employees = $325

And then Bronze, Silver and Gold with the same divisions.

Can this be accomplished with CiviCRM?


texts:
I've heard a few developers refer to LExIM. What on earth is it?

(Other than "Reading" in Albanian or an on-line learning company?)


texts: To prevent cron emails do I need to redirect output to /dev/null?

texts:
My cron job

usr/local/bin/wp --user=cronuser --url=https://mysite.org --path=/srv/www/mysite.org/public_html civicrm api job.execute auth=0

outputs:

Array
(
    [is_error] => 0
    [version] => 3
    [count] => 1
    [values] => 1
)

Is there a way to prevent this output without redirecting to /dev/null ? I'd like to get an email if there is a problem.

clarification: I'm really asking how to stop the output (if there are no errors) from the wp-cli command for scheduling civicrm jobs.


texts: When filtering with data in civicrm/contact/view/case&reset=1 I get an error and no filtering

texts:
I have a problem in civicrm/contact/view/case&reset=1 when I use the date filter.

I have an Italian localization with date format set to dd/mm/yyyy.

I choose a date in the calendar and then I get the folowing error on screen:

  DataTables warning: table id=case_id_2566 - Invalid JSON response. For
  more information about this error, please see
  http://datatables.net/tn/1

And if I look into DevTools I have this return from the site:

  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. One of parameters (value: 09/04/2018) is not of the type
  Date

Which is not the dateformat set in localization (dd/mm/yyyy) but probably the default (mm/dd/yyyy)


texts: Petition Email Error When Creating New Petition

texts:
I just installed the "Petition Email" extension (2.0) for CiviCRM (4.7.10) under Drupal (7.50). When going to Campaign > New Petition, I get the error

Sorry but we are not able to provide this at the moment. 'civicrm_survey' is not a valid option for field entity_table


texts: Allowing a contact to update their related contacts via Webform-CiviCRM

texts:
We have a webform that allows a contact to sign up for a membership and specify two related contacts (let's say "Spouse" and "Child" for the example).

When they come back to renew, we can prefill the contact's info via a checksum token in a link from CiviMail (or automatically if they are logged in) -- but is there a way to prefill the other related contacts as well, so they don't add duplicates when they renew?


texts:
I'm testing the API in order to update some addressee informations (eg. the street_number) using the API Explore page.
In any test:

CRM.api3('Address', 'replace', {
  "id": 204,
  "street_number": 556
}).done(function(result) {
  // do something
});

or

CRM.api3('Address', 'replace', {
  "contact_id": 202,
  "location_type_id": "Casa",
  "street_number_suffix": 556
}).done(function(result) {
  // do something
});

I obtain the following result:

{

    "is_error": 1,
    "error_message": "Mandatory key(s) missing from params array: values"
}

How can I set the key?


texts: Can you restrict Shoreditch from injecting CSS on Public pages with CiviCRM content?

texts:
As the title says - can you restrict Shoreditch from injecting CSS on Public pages with CiviCRM content?

For example - do a fresh install of Drupal, CiviCRM and Shoreditch - choose any public theme - create any public facing CiviCRM page (event, contribution, etc) - go to that public page - shoreditch will inject much of its CSS on the page. Fonts, body backgrounds, etc.

Whats the easiest way to restrict shoreditch from injecting itself on public pages?


texts: How do I set up a "Mailing List Only" option in CiviCRM 5.29.1?

texts:
In addition to setting up paid Membership Sign-up, I am trying to create a free "Mailing List Only" option. I created a contribution page entitled "Mailing List Only", created a "Mailing List Only" Price Set and even a "Mailing List Only" Financial Type so that I could set the price to $0.00.  But when I try to test-drive the page, I get the following message:
"The requested online contribution page is missing a required Contribution Amount section or Membership section or Price Set. Please check with the site administrator for assistance."
I am using CiviCRM 5.29.1 and WordPress 5.5.3 running Blocksy theme.
I hope someone can help me!


texts:
When my Drupal CiviCRM Webform is filled out and submitted, the CiviCRM database appears to be updated correctly. That is, a new contact is created with all the proper information included from the form. The Webform confirmation page announces: "Thank you, your submission has been received." However, a red error box also appears that says:

"Warning: implode(): Invalid arguments passed in CRM_Core_BAO_CustomGroup::postProcess() (line 1551 of /home/mywebsite/www/crm/sites/all/modules/civicrm/CRM/Core/BAO/CustomGroup.php)."

Any idea what this means and how to get rid of the error message?

Drupal 7, CiviCRM 5.14.1


texts:
The new 2015 VAT regulations of the EU are tough and Taxamo seems to offer a solution. The way it works is that Taxamo sits in the middle of the chain - between your site and the payment gateway. Taxamo integrates with payment gateways such as Paypal and Stripe.

The trouble is, then, to get CiviCRM talk to Taxamo. I don't know of any payment processor extension for CiviCRM that can do that. So I was wondering if anyone has an idea how to get a CiviCRM payment form work with Taxamo.

Thanks in advance!

P.S. The real need is to be VAT/MOSS compliant. I just don't know anything other than Taxamo that can automate that. If you know, please share.


texts: Can you share an example of a complex .CSV file for import?

texts: I'm looking for structure information on complex .CSV files that have custom fields, relationships, groups. I'd like to get a better sense of best practices for organizing data ahead of time. If you can share a sample file that would be great. You can delete the names but the titles for the .CSV would be informative.


texts: Validate Drupal accounts after becoming a member?

texts:
In Drupal, our website is set up so that people must validate their accounts when they sign up for one. Normally, they are not able to access the "subscribe" page (for specific training content that they pay for) until they have a validated account, but some people seem to be paying for a membership without validating their account first, which gives them all kinds of problems do to how content access is set up.

Is there a way to validate an account in Drupal at the same time that the member role is assigned to them?

Drupal 7.50 CiviCRM 4.7.15


texts: File attachment lost during merging of records

texts:
i encountered a situation that when I merge 2 similar records, i would get an error with the duplicate record has a file attachment.  The records will remain but the duplicate record would have lost its file attachment.  This would not happen if I flip the 2 records and have the record that has the file attachment be the main record instead.  If I merge it this time, the file attachment stays without any error as expected.

Would this be a bug ?  Also, in the case where the file attachment is lost in the error, would the file attachment be still inside the database and how can that be located ?

I am on CIVICRM 5.10.4 Wordpress 5.0.3

thanks.


texts: Why do I need so extensive permissions for getting event participant via API?

texts:
I'm trying to get participant info via CiviCRM API like this:

civicrm_api('Participant', 'get',
   array(
      'version' => 3,
      'sequential' => 1,
      'contact_id' => $contact_id,
      'event_id' => $event_id
   )
);

but get the following error:

  API permission check failed for Event/get call; insufficient permission: require access CiviCRM and access CiviEvent and view event info

I need to allow unauthorized users to access CiviCRM ("Master control for access to the main CiviCRM backend and API") and CiviEvent ("Create events, view all events, and view participant records (for visible contacts)") to solve this. Aren't those permissions to extensive, just to get some info about a participant? Or am I doing something wrong?

I'm using CiviCRM 4.7.23. I did not get this error in 4.7.14.

EDIT: I do not have to set these permissons to create a participant via API (which is OK). So I think there is definitely something wrong here.


texts: Flush system cache does not work during installation of Drupal Profile

texts:
I am creating a distribution Drupal profile which is bundling CiviCRM and CiviCRM extensions.

Background

Currently, I am having an issue with extensions that CiviCRM settings, for example, Mosaico Extension is using CiviCRM settings for configuration templates, graphic engine etc so after Mosaico extension is completely installed, the Mosaico settings have not been set and you need to flush the system cache.

According to CiviCRM| document https://docs.civicrm.org/dev/en/latest/framework/setting/

  Your setting will not be active until you run flush all caches (e.g cv
  flush or drush cvapi System.flush)

The current version of CiviCRM, Drupal and the extension that are being used.

CiviCRM version 5.19.4
Drupal version 7.69
Mosaico version 2.3

Issue

When I am trying to flush the system cache via CiviCRM API, flush Cache directly via CRM_Extension_System class or calling cleanupCaches on the CRM_Core_config class. None of these is working.

civicrm_api3('System', 'flush');

\CRM_Extension_System::singleton()->getCache()->flush();

$config = \CRM_Core_Config::singleton();
$config->clearModuleList();
$config->cleanupCaches();

Is there a way to flush a system cache and load the configuration during Profile installation?

I have also tried to create settings after the extension is installed and got the error so I understand that the settings are not activated yet.


texts: How can I get Civi CRM to display the currency in reports and so on

texts:
We have an organisation that can accept money from all around the world. It's usually cash or cheque when that happens. We can record the currency type in the contribution form when entering values. And also on import.

But it's almost impossible to then see what currency a value actually is.

It doesn't show in any of the reports. In fact, when I try to create a custom report, it's not even available as a field to select.

The only way I've found to see it is to drill down to the full details of the contribution, which is really slow and in-efficient.

Can I add it back somewhere?


texts:
I was looking at the apache2/ssl_error.log and found an error relating to a secondary .htaccess file inside the <drupal_root>/sites/default/files/civicrm/uploads directory. Below is my stackoverflow post about the error, however, my question for here is this: is it normal to have a secondary .htaccess file within the civicrm files uploads directory or should I remove it? It only contains the following lines:

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

https://stackoverflow.com/questions/42287602/apache2-ssl-error-invalid-command-order

Even though I posted in stackover-flow, if anyone has any idea why I'm getting the this error, feedback would be greatly appreciated here or there, thanks!


texts:
We use Office 365 Exchange Online for our emails.  Whilst you can configure CiviCRM outbound mail to use it, you can't actually send mail using it.  I have done some investigation, and the reason is that packages/Mail/smtp.php replaces the From address with the Return-Path.  CiviCRM adds a VERP component, so Exchange Online rejects the email because the From address is invalid.  Exchange overwrites the Return-Path with the From address anyway, so VERP doesn't work.

Any comments or thoughts?  I assume someone will say that we should use another Mail Transport Agent.


texts: How can I fix the error message "Could not find contribution record" from PayPal?

texts:
We have a new recurring contribution that isn't being entered into Civi.  In the ConfigAndLog log I see "Could not find contribution record 20874".  In the nginx logs I see that that number is being passed from PayPal as contributionID.

POST /sites/all/modules/civicrm/extern/ipn.php?reset=1&contactID=10132&contributionID=20874&module=contribute&contributionRecurID=25&contributionPageID=2 HTTP/1.1

Of course, that id is not in the contribution table.  After looking at ones that worked it looks like the contributionID sent from PayPal is that of the first contribution of the recurring contributions.

Unfortunately, this error wasn't noticed right away so I can't see if there were any other errors when it was first created.

So can I just manually create a record in contributions with that id and have it work?  What is it looking for in that record?  (Well, I'd enter a payment for that person and change the id and anything else it is looking for.)

We don't want to have the person cancel the recurring and do it again.  It's bad form to ask a donor to redo their payments.  They might just cancel and not redo it.


texts: Is the text-link field broken in D7 views integration?

texts:
When creating a view in Drupal 7 to display CiviCRM activities (v 4.6) there is a text-link field available.

On selecting this field it can be configured to perform contact actions or activity actions (view, edit, delete) and set the link text as well as label.

I'd expect this to provide one of the text links we are all familiar with from the CiviCRM interface - however, when configured for activities, the result is that no data is displayed at all. There is no error message, the content is no longer displayed.

This happens regardless of the display settings (table, grid, calendar etc) for the view.

Is this field known to be broken, or should I persevere?

I have come across a similar problem before although this is marked as fixed in 4.6:

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


texts:
I have created profile forms, using custom fields, which open up perfectly in create mode but when I test the forms I get this error once I hit save:

  Sorry but we are not able to provide this at the moment. DB Error: no
  such field Return to home page.

Any ideas of how to solve this?

Here is a link to one of the forms in question: http://skillsguru.web.za/civicrm/?page=CiviCRM&q=civicrm/profile/create&gid=21&reset=1

The detailed debugging report is here.


texts: CiviReport - development recognition report

texts: We need a donor recognition report that - for lifetime or a period of time (last FY for example) - will count totals per donor and include soft credits in the totals. Is this something that can be done "out of the box" or do I need a custom report?


texts: Wordpress custom contribution and newsletter signup forms

texts:
How customizable are the contribution forms? I have created a standard contribution page from the CiviCRM plugin, but I would like to hammer it into a very stylized design.

Alternatively, is it possible to create a 100% custom form and communicate with the CiviCRM contribution backend via some API?


texts:
I used to have Logging functionnality activated on one of my civicrm instance but when i look at log_civicrm_address, nothing seems to be logged since quite a while.

When i look at the config screen Administer -> System settings -> Misc (Undelete, PDFs, Limits, Logging, Captcha, etc.), the logging functionnality is disabled and neither set to Yes or No.

How can i re-enable this (and any idea why it's like that) ?

EDIT

CiviCRM is in version 4.6.5 and logging was activated in 4.2 (or maybe before).


texts: Installing Civi onto WordPress under Local does not work due to XML path errors

texts:
Civi used to work under Local (née Local by Flywheel) on Windows, but I can't get it to install under the latest version. The Civi installer can't parse the schema xml files due to a path error. What happens is:

CRM_Core_CodeGen_Util_Xml::parse() tries to process the main schema file in civicrm/civicrm/xml/schema/Schema.xml
It loads this file fine, but then runs xinclude() to pull in all the .xml files linked to in schema.xml
It can't find them. It's not looking in the correct place: I can see in Process Monitor that it's looking in the root folder, rather than wp-content/plugins/civicrm/civicrm/xml/schema. xinclude then throws a "failed to load external entity" error.

I've tried:

checking that the DomDocument URI is correct - it seems to be fine
setting the PHP working directory manually. This helps xinclude() find the files, but it then throws a "trying to build relative URI" error.

I assume it's something different in the Local environment. I've tried 2 different machines. Any ideas what could affect this? It doesn't help that Local has an ungoogleable name.
Latest version of Civi, latest version of WordPress. Local version 5.9.8+5191. libxml 2.9.9.
Andrew


texts: How do you get contact_id in a custom form?

texts:
$contactId = CRM_Utils_Request::retrieve('cid', 'Positive');
$contactId = (int) $_GET['cid'];
$contactId = $form->getVar('_contactID');

Are all possible solutions at different places, but none seem to work when in a Form_CustomData.

In this case the cust data is in an Activity for a civiCase

For the avoidance of doubt, this is to get the ID for the contact (not the user)

Edit: additional info.


texts:
CiviCRM 5.19.2
WP 5.3

Testing my bounce settings, and I'm not sure whether I actually have a problem or not. I've set up both 'bounce' and 'activity processing' accounts, and their respective scheduled jobs run without error (and CiviCRM has created the corresponding folders in both accounts).

Using the default 'from' address (info@mydomain), I've been sending a newsletter out to a small dummy group containing faulty addresses (one, for example, is an old work address of mine that's disabled). While I get an immediate message from the google mailer-daemon ("550 5.2.1 The email account that you tried to reach is disabled"), sent to info@mydomain. Shouldn't that go to bounce@mydomain, the account I've set up for bounce processing? Or am I misunderstanding something basic?

I can also confirm that I can send email to bounce+ (and receive it there), but the when I'm sending with CiviMail I only receive the bounce message in the reply-to (which is the sending) address. See the image below.


texts: Upgrade Paystation processor to 4.7 compatible

texts:
After fixing some notices/warnings, I was quite able to configure and enable this processor on the contribution page.

When using this on a live page, I see an error after like

PHP Fatal error:  CRM_Contribute_Form_Contribution_Confirm::preProcess():
The script tried to execute a method or access a property of an incomplete object.
Please ensure that the class definition &quot;nz_co_fuzion_paystation&quot;
of the object you are trying to operate on was loaded _before_ unserialize()
gets called or provide a __autoload() function to load the class definition
in /Users/jitendra/src/civicrm/CRM/Contribute/Form/Contribution/Confirm.php
on line 323

I think as it doesn't actually follows the hierarchy CRM/Core/Payment/... this error is thrown.

Any thoughts?

Note:   $this->paymentProcessor['object'] has a class named __PHP_Incomplete_Class though it contains the paystation object.

I cloned it from https://github.com/eileenmcnaughton/nz.co.fuzion.paystation


texts: What is the best option to merge duplicated membership?

texts: We have some members using similar names to register a membership at different years.  What is the best way to merge their membership? Thank you.


texts: Cannot Record Payment to a Contribution in Pending Pay Later Status (WordPress 5.0.10, CIVICRM 5.21.2)

texts:
I was testing the Record Payment function in the following manner:

Click Contribution under Contact A
Click "Record Contrirbution"
Create Contribution, set Status to "Pending (Pay Later)"
Click "more" for the Contribution record, Select "Record Payment"
Select Payment Method (I chose Cash)
Click Record Payment

This will result in spinning of the logo and nothing happens.  This requires a refresh of the page to get out.  No payment was recorded to the contribution.
I have checked that this didn't happen to earlier versions (5.12).  Any insights?  Thanks.


texts:
When I edit a group, it will not allow me to save unless I select a Parent group. Is Parent Group required? If a Parent Group was accidentally assigned, how do you remove it without assigning a new Parent?

CiviCRM 4.7.9 and WP

This image shows an example of a Group that does not have a Parent Group. When I edit the Group the settings, the Parent pull-down list is automatically populated with a group called "Not Used (Smart Group)". It is not possible to deselect or select "none". Also, there is an asterisk next to the parent group indicating that it is required.

The second image shows a Group that has a Parent, and I would like to remove this relationship. But it is not possible. When I try to remove the Parent and save I receive an error message that Parent Group is required.


texts: How can i combine new person and a new contribution on the same page?

texts: I want to have one page with the possibility to register a new contact that have made a contribution instead of needing to do this on 2 separate pages.


texts: Paid event but Pricing Options can not be required but they must chose a fee

texts:
Civi 4.6.4 and WP 4.2.2
I have an Event(3 day Conference) with 6 pricing options.  The first is for the Full conference with different prices for a Member, Certified Member, and Non-Member.  AND there are 5 other price options for daily activities with pricing options again for Member, Certified Member, and Non-Member.  I can't make any of the pricing fields required since they can choose any of the options.  My problem is, though, that they must pick one, but don't know how to make this happen.


texts: CiviCRM 4.7.15 reports keep giving DB Error: syntax error

texts:
The site was moved to a different server and updated from a 4.2.7 version to 4.7.15 and everything seemed to be working but every report we try to open just keeps giving this error: https://www.screencast.com/t/Lf589LhvhP and if I add a dashlet on the backend this shows up: https://www.screencast.com/t/aWMsujgz I've been looking everywhere if there is any other setting that might be causing this to happen but no luck, and this is the only log I get when I try to open the reports:

administrator/?option=com_civicrm&task=civicrm/report/instance/41&reset=1" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36"

If anyone knows what might be happening let me know.

Thank you.


texts: Best practices for bilingual CiviEvents pages with price sets?

texts:
still on Drupal and Civi 5.x.
What is the best practice for offering a Civi Event in English and Spanish? We would want the price set to be translated, the event description, the email, confirmation pages, etc.
Is cloning the best option? Would we need to duplicate the custom fields and profiles in use, or use string translation?


texts: Set defaults values and attributes to membership form fields with PHP

texts:
Its possible to set default values of a membership custom fields through a civiCRM hook?
I have seen that the values are generated by ajax when membership type is changed but i dont see any hook for this.

thanks!


texts: Preparing for move to utfbmb4 should I limit character length?

texts:
I'm looking into moving our database to utf8mb4 - as indicated will be required in the future. I've been trying to find information about the possible impact in doing so and I found this post: https://mathiasbynens.be/notes/mysql-utf8mb4
That article indicates the following (it has a nice, thorough explanation if anyone else is interested, this is just the summary of one section):

The InnoDB storage engine has a maximum index length of 767 bytes, so for utf8 or utf8mb4 columns, you can index a maximum of 255 or 191 characters, respectively. If you currently have utf8 columns with indexes longer than 191 characters, you will need to index a smaller number of characters when using utf8mb4. (Because of this, I had to change some indexed VARCHAR(255) columns to VARCHAR(191).)

So does it make sense that if I need to create any custom text fields in the near future (before making the swap) I should go ahead and limit the database field length to 191 (or less)? I'm looking for someone to verify I have not jumped to the wrong conclusion.
Does this also imply that I should look through my existing data for any fields with data that might be longer than 191 characters - and then adjust? I assume I could not adjust the data but it may be truncated upon conversion to utf8mb4 if it is longer than 191 characters.


texts: SendGrid requires credentials for every login using WP

texts:
Just move our site to a new hosting environment. Did not have this problem before.  Using CiviCRM with WordPress.  Every time we go into CiviCRM we must enter the SendGrid credentials.  Any idea what would cause this and how to stop it?

Update: This problem came back. It is an authentication login and it is required. It is part of the Sendgrid plugin for CiviCRM. Wrote to the developer who tells me that this plugin is incorrectly listed as CRM independent - it only works 'properly' with drupal.

The authentication is required for any access to civicrm, including public listing or event registration, etc. Hence Sendgrid Plugin is not viable for WordPress.


texts: Export of custom multiple choice options to CSV files limited to 32 characters

texts:
A user is trying to export data from an advanced query on custom fields to a CSV file using the "Export contacts" action. This fails with a backtrace which is attached below. The error message is:
#6 /var/www/libertarian/vendor/pear/db/DB/mysqli.php(936): DB_common->raiseError(-1, NULL, NULL, "\nINSERT INTO civicrm_tmp_d_export_1d387c75256673080ad64346b3c095c7 (`id`, `l...", "1406 ** Data too long for column 'custom_49' at row 13")

The custom_49 field referred to in the error is a select list with a set of multiple choice options, some of which are up to 55 characters long.
The bug is that the temporary table that is being constructed to service the export to CSV is constructing the column as VARCHAR(32) while the text value of the multiple choice options in civicrm_option_value is a VARCHAR(512)
Details
If I select the schema of the table civicrm_tmp_d_export_1d387c75256673080ad64346b3c095c7 it reports the table structure as:
CREATE TABLE `civicrm_tmp_d_export_c3a74c8fb66b720f55e2661dab58716b` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `last_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `first_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nick_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `street_address` varchar(96) COLLATE utf8_unicode_ci DEFAULT NULL,
  `city` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sort_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_61` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_50` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_51` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_68` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_58` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_49` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_street_address` (`street_address`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Indeed it is trying to insert the text value of an option into a temporary table and several of those text options are over 32 characters in length.
SELECT label,CHAR_LENGTH(label) as length FROM civicrm.civicrm_option_value WHERE (option_group_id=103) AND (CHAR_LENGTH(label) > 32)

returns
| label                                                   | length |
|---------------------------------------------------------|--------|
| 003 - Aurora–Oak Ridges–Richmond Hill                   | 37     |
| 005 - Barrie–Springwater–Oro-Medonte                    | 36     |
| 035 - Haliburton–Kawartha Lakes–Brock                   | 37     |
| 039 - Hamilton West–Ancaster–Dundas                     | 35     |
| 040 - Hastings–Lennox and Addington                     | 35     |
| 052 - Leeds–Grenville–Thousand Islands and Rideau Lakes | 55     |
| 061 - Mississauga East–Cooksville                       | 33     |
| 073 - Northumberland–Peterborough South                 | 39     |
| 102 - Stormont–Dundas–South Glengarry                   | 37     |


texts: Email-to-activity processing: how to ignore cc

texts: Autofiling inbound emails as activities via EmailProcessor is a really nice feature. However for some CivCRM users it would be nice to have (always and system-wide) only filed activities for the FROM and TO contacts. Is there a way have CC addresses ignored?


texts: migrating data from CiviCRM to a different CRM platform

texts: I need to migrate my database from CiviCRM to a different CRM platform and need to capture as much data from Civi as possible.  What is the best way to do this to make sure I get everything?


texts: Moodle Integration Sample Sites or the way to do it

texts: Where can I find a successful Moodle Integration example or see a sample site? If not how to go about doing the integration? Thanks


texts:
Since the days of CiviCRM as a standalone project are long passed, is there any reason, in 2016, to have a separate database for Drupal and one for CiviCRM? If so, what is the compelling reason? For the record, I only see downsides, not the least of which is backup and restore should disaster strike. I've just taken over the care and feeding of an existing site where separate databases were used in the setup. The customer used the backup_migrate module to do regular database backups and, you guessed it, only the Drupal DB was actually getting backed up.

Thanks for your insight.

-- Marcel


texts: External Email from Newsletter Mailing Fails

texts:
I have set the Outbound mailer to mail(), SMTP seems to really be problematic.

I am successful in the following:
Contacts | New eMail
Administer | Settings - Outbound Mail | Save & Send Test email

All go into the inbox of the intended external email address.

From Joomla, all the email functionality is working as well.

I am unsuccessful in being able to send a newsletter from the Mailings | Draft Unscheduled Mailings area,

I get a generic message, Error in call to Mailing_send_test : sendmail returned error code 1

This only happens if I send it to an outbound email (email addresses within the hosting provider work)

Any ideas would be greatly appreciated.


texts: Has anyone run into scheduled jobs drifting on Centos7?

texts:
We're only seeing this for projects on one specific server (running Centos7; using chrony; PHP 5.6.21). We are NOT seeing this for projects on our other server (running Centos6; using ntpd); Working theory is that we should go to ntpd on Centos7. Has anyone else run into this?

The problem: a Scheduled Job configured to run daily - runs exactly every 25h:

2016-05-21 15:04:51
2016-05-20 14:04:17
2016-05-19 13:04:41

EDIT: system crons (Drupal and CiviCRM) run hourly - on 03 and 04, respectively - and I've confirmed those jobs that are scheduled to run 'always' indeed execute every hour.


texts:
Could someone give an update on the status of creating more usable form/profiles without using Drupal's Webform?  (Especially iin regards Wordpress but preferable CMS agnostic)

I'm certain I'm not the only WP user struggling with form creation that is annoyed with the 'use Webform' response to nearly every form/profile question. It seems obvious to me that this is a major usability issue with CiviCRM that has been avoided for years due to the crutch of Webform.

And yes, I have heard also of a mysterious gravity forms plugin (with a big annual fee to use it), but this just perpetuates one of the main flaws in your otherwise amazing system.

/rant.


texts: CiviContributions > New Contribution Page with an ANONYMOUS USER and no Login Display in Drupal (CiviCRM 5.25.0 / Drupal 7.70)

texts:
This is a multipart question:
1. I have added the following permissions for the anon user:
-CiviCRM: profile listings and forms
and
-CiviCRM: access all custom data
My desire is to block any other access to CiviCRM - I just want individuals to access the page and make a donation. Am I missing any security implication?

2. I have set up a profile to collect First / Last and Email address, but Drupal is still adding a login - this would be confusing to my users and I would like that not to appear, but not sure how to turn off that from displaying:


texts:
This is a new installation of CiviCRM 5.14.0 on WordPress 5.2.1

I've created a test CiviMail using one of the default templates. When I attempt to send a test mail, I get a pop-up that says "Sorry an error has occurred and your information was not saved."

Not much information here. I had a similar problem with a Joomla site five years ago but can't find my solution


texts: Deduplicating - unexpected over-ride behaviour

texts:
We're using Civi 4.5.4 and Drupal 7, and finding that the deduping rule is confusing us - or we have a bug.

Unexpected duplication of addresses.
Contact A (the duplicate) has a home phone, email or postal address
Contact B has the same of any of these.
We choose not to include these in the duplication merge - we don't check its merge checkbox.

We expect that Contact A's home detail will not be moved over to Contact B.
Instead, after the merge we find that Contact B now has an additional home address containing the same email, phone and/or postal address as Contact A. In other words, the merge process is duplicating the home address.

If we do check the merge checkbox, then the merge process over-writes or adds as expected.

Any ideas?

(We did explore using the demo site, but it was in Russian, and we weren't sure if it was wise or kind to set it to English for our purposes, nor how to do this.)


texts:
When I'm logged in as Admin, I can't access anymore to CiviCRM menu from Drupal 7

I still access through navigation to https://domain.net/civicrm/admin/ but no main menu anymore. Our users that have another profile can see it.

I've tried with different administration themes but the issue remains the same.

I'm using Drupal extension "Administration menu" but until now it worked fine.

Any idea to help me work again :-( ?


texts: Error with CiviVolunteer after upgrading to PHP 7.1

texts:
Via permissions page and system status page.

Warning: Declaration of CRM_Volunteer_Permission::check($permissions) should be compatible with CRM_Core_Permission::check($permissions, $contactId = NULL) in /home/site/public_html/wp-content/uploads/civicrm/ext/org.civicrm.volunteer/CRM/Volunteer/Permission.php on line 0

Civi 5.6 Wordpress 4.9.8


texts:
Hi does anyone have access to any training videos or material for civicrm? For example, Admin and database reporting, user training, etc.

Thanks in advance

Edward


texts: Could not load settings file at: 4.7.0 wordpress

texts:
I tried to load my contact to civicrm using the command line however was i tried to execute the import.php i received an error"could not load the settings file at:

i tried to further investigate i noticed that my civicrm.config.php is identical to the other server i used before that works perfectly fine as i tried the command line this error always comes up.

please do help a newbie.


texts: Can Civirules differentiate between 'pending' and 'added' group status?

texts: I'm using Civirules to assign tags to members who add themselves to a group via public webform using the Linked Trigger 'Contact is added to group,' but the group requires double opt-in. Civirules doesn't seem to differentiate between group status types, so the tag is immediately applied to all 'pending' members even before the member has confirmed via the link in their email. Is there a way for Civirules to recognize the difference between 'pending' and 'added,' and only apply an action when one's group status is 'added'?


texts:
Ok I did search and I do recall fussing with this a bunch when setting up cron jobs, but here is the situation.

I accidentally deleted my civicrm-settings.php file the other day. Really it was no big deal, restored within 5 minutes from a backup only a few hours old. HOWEVER, since then cron has not been running.

Trying to pull it via:
wget -O - -q -t 1 'http://www.SITE.com/wp-content/plugins/civicrm/civicrm/bin/cron.php?name=cronjobs&pass=#####&key=####'

I have been getting:

ERROR: Invalid key value sent. More info at:http://wiki.civicrm.org/confluence/display/CRMDOC/Managing+Scheduled+Jobs

Absolutely nothing has changed
Verified Site Key
Verified administrator un/pw

Tried running it with cli.php and it is still not running (despite setting permissions on that file)

Any incite?


texts: Allow Duplicate External IDs for later merge?

texts:
I have a large number of contacts across different contact sub-types, imported via CiviMigrate.

The particulars:

I am pulling multiple contact types from the same, flat master table. This means that for example:

Pass 1 : Grabs all students
Pass 2: Grabs all teachers
Pass 3: Grabs all volunteers

There are naturally some students which became teachers, and were volunteers at some point, so there can be any combination of contact sub-types.

In the "worst" case, I'd end up with 3 contacts, one of each sub-type, that would need to be flattened into a single contact.

I have been matching on first and last name with some success, but there are multiple cases in which this causes the need for manual merge work (people with the same name).

Is there any way to temporarily allow dupe external ID's for the purpose of a later merge?

Now, this all stems from the fact that I can't find any documentation on how to pass multiple contact sub-types at once via CiviMigrate, perhaps there's an angle there?

Thanks!
-d


texts: How can I display more than 100 relationships

texts:
We have a company that have 200 relationships. When we try to look up the people civi allows you to select 50 or 100. in our case we have 200 and so when we select 100 from the drop down we are unable to page to the remaining records.
We know they records are in civi but the civi interface is unable to retrieve it.

Thanks In advance

Edward


texts: How to access the 4.7 Administrator Status Page?

texts: I see a prominant feature of 4.7 is the "Administrator Status Page" and the Issue is https://issues.civicrm.org/jira/browse/CRM-13823 but I do not see a menu item for the status reports.  How do you access the status reports?


texts: Importing Household Address if Already Exists

texts:
I've seen several requests for this, but some seems outdated.
Goal: Import contacts and households and update existing records.  I'm using http://forum.civicrm.org/index.php?topic=29506.0 as a reference.  Should it work for contact updates?

Using 4.6.3 and import GUI.
Import household contact with primary home address (complete)
Associate relationship for contacts as Member of household (complete)
Associate relationship for contacts of Spouse (TBD but suggestions welcome)
Associate contacts as having Master Address belonging to household

This seems like a very common use case and I'm almost there...now attempting steps 4 and 5.

Status:

Created csv with household info and imported successfully.
Used mysql to collect master address record id.

When importing individuals:

Selected Update method
I selected "Master Address Belongs To..." and included the Address ID from mysql
- Import successful but Address is not updated for existing contact addresses and does not belong to household

Could this be related to: CRM-16588?

So now I have some related addresses (although I have to manually save to show them properly in view screen) but others belonging to individuals.  I suppose I could delete all the individual addresses and reimport but don't like that idea ....

BTW perhaps this could drive a rather large feature request/refactor:
Rather than import master address belongs to ... use the same relationship method but enable an option like "Let Household fields override Household Member"  Perhaps this could work like relationship permissions.  This could mean any updates to a contact address would update the linked field (consistent with how event pricesets/address work...)


texts: Scheduled reminders for rolling renewals not sending after first renewal

texts:
One set of our memberships is a 1-year, rolling product that can be purchased at any time.

We've set up tests for scheduled renewal reminders but it seems to have stopped working:

Entity: membership > individual membership
When: [1] [week] [before] [membership end date]
Enable repetition: yes
Repetition: every [1] [day] until [1] [day] [after] [membership end date]
'From name/email' etc. added
Limited to Smart Group made up of test contacts

We initially set one of the test contacts up with a membership set to expire in 8 days. At 7 days before we got the first email, and each day after that until we changed the renewal end date to be a further 8 days in the future from that point (to test what would happen for the 2nd year renewal period).

After that, we no longer received any emails. Checked cron jobs etc. and send scheduled reminders is set to run daily.

Is there a problem with 'clearing out' contacts tat have been triggered to (e.g. once they have renewed once they'll never get sent the scheduled reminder again, even once they get to 1 week before membership end date once again)?

(we're using v4.6.9 in case that is relevant.)


texts: Total Amount not displaying in contribution price set in Joomla 3

texts:
I have seen this issue in a couple other posts, but none that had an answer that applied to me.

I have CiviCRM 5.5.2, Joomla 3.8 and the RocketTheme Notio template. I have upgraded from a much older setup. In this updated build, the total amount doesn't display in my online form. In the backend preview, it displays and works just fine. On the website, not so much. I get the "Total Amount" label, but nothing for content.

Ideas of what I could be missing?


texts:
I am fairly new to Civicrm, I created a new API for an Entity which I would like to make a pull request for but however it seems preparing a test environment in Civicrm is quite difficult.
I have followed this tutorial but seems it's not for Civicrm 4.7 since some of the paths mentioned are not in Civicrm version 4.7
Tutorial URL:
https://wiki.civicrm.org/confluence/display/CRM/Setting+up+your+personal+testing+sandbox+HOWTO
I can't seem to be able to find these paths , mentioned below

Configure the PHP constant CIVICRM_DSN.   Database connection using PHP
constant To define PHP constants for unit-testing, copy the file
"/tests/phpunit/CiviTest/civicrm.settings.local.php.txt" to
"/tests/phpunit/CiviTest/civicrm.settings.local.php".
Edit the file to include to include a line like this:
define('CIVICRM_DSN',
'mysql://db_username:db_password@localhost/civicrm_tests_dev');
Configure the environment variable CIVICRM_TEST_DSN. (The format is
the same as the CIVICRM_DSN above.)
Don't use this approach unless you
already have a strong understanding of environment variables. Pass the
MySQL details as command-line parameters each time you run the
unit-tests. (This approach doesn't require updating any other files,
but it's cumbersome to use when you regularly run unit-tests.)

https://wiki.civicrm.org/confluence/display/CRM/Setting+up+your+personal+testing+sandbox+HOWTO
When I go to the root of my API extension and type :
civix test CRM_MyEntity_EntityAction

I get error below which suggests I should read the tutorial above


texts: How to import values for Custom Fields configured as "Field Set allow multiple records?"

texts:
I think no through regular Contact Import; I can't see how through API CSV Import; if anyone has any other thoughts that would be great.
Seamus told me to try -> /civicrm/import/custom?reset=1 and that looked promising! -> but trying to import dates I run into an error message that makes no sense -> I got a "value: 2020-01-01 is not of the right field data type: Date" That custom field is configured as a Date field and 2020-01-01 is a date
Do I need to sql my way through this?


texts:
running CiviCRM 4.7.8 WordPress

The following is appearing in the error_log whenever cron.php runs:

[Fri Jun 24 16:01:06 2016] [error] [client ...] PHP Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /.../wp-content/plugins/civicrm/civicrm/CRM/Mailing/Event/BAO/Opened.php on line 58

Is anyone aware which class is supposed to be responsible for setting the timezone in this case?


texts: I am trying to export a list from CiviCRM and I seem to be missing the actions drop-down. I have used this field before, but it has dissappeared. I have attached an image of what my screen currently looks like  when I am doing an advanced search. From memory, the Actions drop-down usually sat underneath the 'edit search criteria' section and above the "A,B,C.." search function. I am using a Macbook and have tried both Firefox and Safari in case the browser is not supported properly, but neither seem to work.


texts: I want to create a custom label for avery 8660 matte clear labels

texts:
Ive measured the labels and entered the measurments into the custom label form.

Each time I run the mailing label generation function I get blank pages.

I stepped down to font size from 8pt to 6 pt and the result is the same.  Blank pages.

I stepped down the indentation to the top and left side of the label to .2mm.  Again, blank pages.

Not sure what to do to fix this.


texts: Can a registration fee credit towards a future event be recorded in Civi?

texts:
Civi Version 5.19.4, Drupal.
We run two (in person) conference/trade show events each year.  Participants register (mostly) online. We are converting our most recent, already rescheduled once, event from in-person to on-line (guess why).  Because of the different experience for participants, and the change in expense for us to run an on-line conference, we are considering offering a partial credit to all registrants to use for a future event, while keeping their original registration intact.  We typically do not offer full refunds, but give people the option to transfer their registration to another person, or convert their registration to a donation to our organization. Is there a way in Civi to record this credit?  Is there a way to construct it so that it automatically applies toward the registration fee for the next event they register for?


texts: Scheduled Reminder Ignoring the Year of Membership End Dates

texts:
Our site is configured to send a scheduled reminder 1 day after the membership expiration date. Memberships are renewed through a contribution page. The reminder is only sent to non-auto renew members. When a member renews their membership it updates the expiration date to the following year but the reminders are still being sent.

For example, A member's membership end date was October 14th, 2019. She renewed her membership on September 24th, 2019 which changed her membership end date to October 14th, 2020 but she still received a scheduled reminder on October 15, 2019.

Has anyone else experienced this issue? From my understanding, the scheduled reminder and contribution page is configured correctly.


texts: Connecting Civicrm to Quickbooks classes / subclasses

texts: I have three organizations that use Quickbooks and some other process to track contributions.  I would like to encourage all of them to move to Civicrm.  (They are currently using out-of-date MS Access or Excel for tracking donations.)  Each have set up Quickbooks to use classes and sub-classes in their accounting. Are you actually using Civicrm and Quickbooks, AND using classes and sub-classes in Quickbooks, AND have set up Civicrm to then transfer that data into Quickbooks effectively?  I have read all over the Internet and the Civi site.  What I am seeking is someone who is using both programs.  Practically speaking, what did you do in the setup and execution to get classes and sub-classes to translate from Civicrm to Quickbooks?  I have read a little of some people using custom fields and then others who adapt Campaigns or Financial Types to make this happen, but no practical setup or practical process is communicated in their postings.  Help?


texts: We depend on Civibooking and CiviCRM developers with be ending support for PHP 5X soon. What is the status of Civibooking and PHP 7? I did try to run on PHP 7 a while back and had issues in Civibooking.


texts:
Good morning,

I need to look through our donors and see who is a recurring donor and who is not. What is the protocol to create these kinds of reports?

Thank you!


texts: Civicrm webform to edit membership custom fields

texts:
I am trying to create a webform using the Webform Civicrm Integration module.  The form would allow users to edit custom fields associated with existing memberships.  Our members are required to attend an orientation sometime after signing up for their initial membership.  I would like to create a form that would allow users to enter the date of a Member's orientation session, which is a custom field associated with Memberships.  I can't figure out how to do this for an existing, already previously created membership.  Is this possible with Civicrm Webform?

If not, would it be possible using a membership directory profile instead (haven't been able to figure out a way to include the Orientation date custom field for a profile either, since it would involve combining Contact and Membership fields).

Any suggestions?

I am using Civicrm 4.7.29 in Drupal 7, with Webform CiviCRM Integration 4.21.


texts: If my website in in WP, can i install CiviCRM in drupal?

texts:
Our NP site is made with WP, i did install Civicrm but wasnt a fan of how it looked, i learned there is a theme but its only for the drupal version.
I installed drupal as a subdomain and was planning to install Civicrm. Is there any reason to have CRM on the same CMS?


texts: Message is localized but message template is not

texts:
I received an summary of an activity that looked like this (in Swedish):

Åtgärdssammanställning - Telefonsamtal

Med kontakt(er)
name_10564

Typ av åtgärd
Telefonsamtal

Ämne
Introduktion

Obviously this is translated, which is kind of good, but the name_10564 should definitely be a real name.
Problem is that I can't find this template in the System Workflow template list. The only one I find is "Cases - Send Copy of an Activity" and that is using the default template.
How can this be and where should I look for the template for "Activity Summary"?
We're running on Joomla if that (file locations?) are relevant.
(It seems that some of these strings exist in the translation on Transifex, to which I'm partly responsible ;-)


texts: How do I display a list of civicrm events on a separate wordpress site?

texts: Our CiviCRM site is using Drupal but i have another site on a separate server that uses Wordpress that i want to display the event information with links to the other site for registration. I explored using a view to display RSS feeds and using a feeds plugin on the Wordpress site to propagate the info but that didn't seem like a very easy solution.


texts: How can I customize the User Dashboard (Frontend)

texts:
I am working on 4.7 on Wordpress 4.6 and I trying to customize the User Dashboard in the Frontend shown for the request myURL.com/civicrm/?page=CiviCRM&q=civicrm%2Fuser&reset=1.

First I looked at the hook civicrm_dashboard and civicrm_summary, but those are used for different pages. It seems I can hook into that page with the hook civicrm_pageRun filtering for the page "CRM_Contact_Page_View_UserDashBoard".

How can I add content or modify content on the page object?
Where can I find documentation of the page object?
How would I change the HTML Table on the UserDasboard to DIVs to have separate tabs for Contributions, Events, Memberships, etc. ?


texts: Can cv handle custom Wordpress installs?

texts:
A wordpress install I'm adding CiviCRM to is setup in a non-standard way, specifically:

docroot
\- civicrm.settings.php
\- wp-config.php
\- content/
|  \- plugins
|  | \- civicrm
|  \- uploads
|     \- civicrm
\- wp (wp codebase in here)

I've got CiviCRM working fine, but I can't get my tests to run that rely on booting CiviCRM from cv php:boot. Trying to run CIVICRM_SETTINGS=civicrm.settings.php cv -vvv ... from the docroot just silently dies. I'm using cv version b3db22c.


texts: Custom field - Drop down. How to create?

texts:
Hi guys and thank you in advance.

I am extending the options available under "events". I need to create a new custome field (called 'collaboration type') that presents the user with a dropdown list (a. supported, b. hosting, c.joint, d. sponsored)... but I am not sure how to do so.

Kind regards
A.


texts:
I am trying to use Civi Rules to send me an email anytime someone donates over a certain dollar amount. Is thre a way to do this? I tried to add the activity type of send mail, but I keep getting this error message.

Fatal error:  Out of memory (allocated 116391936) (tried to allocate 16384 bytes) in /home/lifelight/www/www/sites/default/files/civicrm/templates_c/en_US/%%40/40D/40D353E1%%fatal.tpl.php on line 5


texts:
I want to bulk delete an activity (activity ID 65) across all contacts within one group.

I want anyone outside this group to keep the activity.

Is this possible? The search criteria in find activities is limited.

CIVICRM 4.6.27 - Drupal 7

Thanks,
Andy


texts: Manually 'Grant' last event places by 'Pending from waitlist' and override 'max participants'

texts:
When an event fills as an event organizer you want some flexibility on who you would grant the last places from your waitlist to. For our summercamps we take into account if people already have brothers and sisters in our other camps and if the family also booked in the last years.

This means we would like to manually 'grant' the last places to some of the people on our waitlist. Therefore we change the participant status to 'Pending from waitlist' in order for the registrant to finish the registration.

Unfortunately this cannot proceed, because of the 'maximum participants' setting. I would advocate for a setting to be able to override the max.participant setting when people finish their registration.

I do not know which files would be related to this 'maximum check' and what good ways would be to be able to override it.


texts: Undefined Index in an Event+Contribution Registration Webform

texts:
Running Civi 4.7.27 / Drupal 7.59 + Webform Integration

I have Webforms to register Parent + Children and pay for an Event (the webforms are a bit complex, with lots of custom fields, but they used to work correctly).

Now, when I open the Webform second page (Contribution Page), I get the following message :

Notice : Undefined index: fee_amount in wf_crm_webform_postprocess->validateParticipants() (line 410 in /home/bapaparoisse/www/www/sites/all/modules/webform_civicrm/includes/wf_crm_webform_postprocess.inc).

However, everything seems to work correctly : the payment can be performed.
Other such but simpler Webforms seem to work wiyhout this Notice.

I don't know when this began, since those events are passed now. I just know that I made some Extensions cleaning recently.

I will be glad if someone can bring me some light about this (where does it come from ?)


texts: Security alert - how to manage the download

texts: I am new to the CiviCRM interface, and am trying to build a conference registration form within www.jesuitschoolsnetwork.org.  I have repeatedly been notified that there is a needed update due to a security issue. Our site runs on Drupal 7x, and I have downloaded civicrm-4.6.8-drupal.gz, but am not sure what to do with the download.


texts: Misleading behavior when importing activities

texts: This is on CiviCRM 5.24.1, just installed. The behavior of the Import Activities page is odd. On the Preview page, Step 3 of 4, the buttons Previous, Import Now, or Cancel are displayed. However, no matter which button is selected, a popup box says: "Backing up your database before importing is recommended, as there is no Undo for this. Are you sure you want to import now?" Then the import appears to start and a progress bar appears, even if Previous or Cancel were selected. If Import Now was selected, the import proceeds normally. If Previous or Cancel was selected, nothing is imported, and it returns the user to Step 1 of 4. No harm is done, but the appearance that we are unable to stop the import regardless of the option selected is alarming to the user.


texts: Avoid an activity entry for each recipient contact of a mass mailing

texts:
We are facing a huge database growth as we send newsletters to a growing recipients list. The newsletter is sent with CiviCRM Mail to a contacts group. I realized that the biggest table in our project is the civicrm_activity_contact table - and I am quite sure that most of the entries are those entries generated when a contact received the newsletter.
As there is a tab "Mailings" for each contact where all these newsletter mailings are listed I wonder why there are activities created additionally? Is there a need for these activities? Can I turn off activity creation for mass mailings somewhere?


texts: advanced search - mailing fields not present

texts:
I am having a "moment". On one of my civicrms when I use the advanced search I can search mailings. On one of my other civicrm installations the mailings are not available to be searched - the accordian is short of the "mailings" tab. I'm assuming it is somewhere in the configuration but I cannot find it, nor can I find it in the user guide.

Can someone point me in the right direction.

Thank you!


texts: Why is there a page in a CiviCRM WordPress install that says "Do not delete this page."

texts:
A CiviCRM page is created on the site:
my-site-wordpress/CiviCRM
where it says: "Do not delete this page." Page content is generated by CiviCRM "
what is it for? how should it work?
What should appear on this page?
I use WordPress 4.9.6 version - CiviCRM is in a subdirectory
Thanks


texts:
Users reported that CiviMail is not pushing their messages. The scheduled mailings have Started, but not Completed. When I go to scheduled jobs and manually execute the Send Scheduled Mailings, it refreshes the page but doesn't send the mail. When I go to my host control panel and initiate the Cron manually, I receive the following error:

Notice:  A session had already been started - ignoring session_start() in /home/mysite/www/www/includes/session.inc on line 287

I found a few "solutions" via Google that involve editing the session start php code.

For instance I entered this into the root php.ini file:

if(!isset($_SESSION))
{
    session_start();
}

It clears the error when running the cron manually, but it doesn't actually send the pending messages in Civi.

The log says:

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

  Full message:  Finished execution of Send Scheduled Mailings with
  result: Failure, Error message: DB Error: syntax error

There was another "solution" to add "php_flag session.auto_start 0" to the .htaccess file. When I tried that, it gave me server not found errors when trying to access the site.

I also cleared my _sessions table to see if that fixed the issue. No dice.

Does anyone have a possible solution to this issue? Thank you.

Civi 4.7.12
Drupal 7.51

Edit: 10-29-16 / 2159 to add log error message.


texts: Why are membership renewal reminders going out for memberships with expiration date 1 year in future?

texts:
We are running CivCRM 4.6.14 on Drupal 7.43. (Not updating right now because we are in the middle of a major fundraising campaign and I can't afford any glitches.)

I have a member who is paid up through April 9, 2017. I have membership renewal reminders set up to go out 3 weeks before expiration date, and every 2 weeks until expiration (so they get 2 reminders, basically). This person received reminders March 19 and April 2, 2016, which would be perfect if their membership expired this year. They dutifully sent in a membership renewal payment, and were probably very confused when I called to tell them it's too early to renew (we applied the payment to the aforementioned fundraiser).

Is there some reason that CiviCRM isn't picking up on the year part of the Membership Expiration Date?


texts: Expected information for iATS recurring contributions?

texts: CiviCRM 4.7.13, iATS extension 1.5.3.  Is this the information I should expect to see in the contribution record, or should a payment be referenced?    In particular, I'm wondering about the "no payments found" line.  I am aware of the issue affecting the creation of civicrm_financial_item records (Recurring iATS contributions not creating civicrm_finanical_item records ) and I would anticipate they will need to update the extension sooner rather than later, but I'm not clear on what I should be seeing here.  Thanks in advance.


texts: I want to customise the contacts relationships tab screen to show if the listed contacts (Individuals) belong to a specific group or not. I'm not sure where to start and would appreciate any pointers. I wasn't sure whether I needed to customise a template or create an extension that uses a hook...


texts:
On CiviCRM 5.6.0

I have a Smart Group based upon custom_param1=1 (as an example).

I change some values of custom_param1, to update my Smart Group in order to send a mail to its updated members.

But the Smart Group is not updated immediately (I have to wait 5 minutes before it is)

How can I force its update to have it immediately ?

(rebuilding the smart group cache has no effect)


texts: How do I tell what security issues require upgrade?

texts:
Just upgraded a site to 4.6.11 (long story as to why).

CiviCRM is showing the "Security update required", which links to https://civicrm.org/advisory

As I click on advisory after advisory, in reverse chronological order starting from "CIVI-SA-2015-011: REFLECTED XSS IN ERROR MESSAGE", all have been fixed prior to 4.6.11.

So ... what is the vulnerability then, if I don't upgrade to 4.7.1?


texts: How can I tell which template a specific report instance is based on?

texts: If I look at a report instance, how do I know which template it comes from?


texts: I want to remove these green boxes that appear on Civi Profiles automatically. They do not appear in the source code at all. Is there an option to remove or a place in Civi where I can disable and change the appearance of these boxes?


texts: Can webform manage two types of financing and correctly calculate the Tax-Deductible in the contribution?

texts:
I created two line items with different "Tax-Deductible" option in financial type (one type with yes other with no) but its not calculated correct in contribution Non-deductible Amount field. Can webform manage it? What would be the correct way to create it?

It seems that it always assigns the value based on the type of financing assigned to the contribution page associated with the webform.


texts: Having error in contribution page after upgrade to 4.7.29

texts:
I'm a civicrm user, and I have problrm with contribution page after upgrade to 4.7.29, My civicrm installed on Joomla 3.8.3, this error show when I open the contribution form from frontsite.

the error message is :
Warning: require_once(CRM/Core/.php): failed to open stream: No such file or directory in /home/ablecomm/public_html/administrator/components/com_civicrm/civicrm/Civi/Payment/System.php on line 59

I have been trying to fix this but no have idea where is the problem.

is Anybody can help me?
thankyou


texts:
is there a possibility to activate automatic word wrapping in Labels? If a Name to long actually it dont break the line.

Civi 4.6 Drupal


texts: Tax not applied when performing backend membership renewal

texts:
We have a lot of different taxes on our implementation - doing a backend renewal does not apply the tax (however, this works when a NEW membership is created). Anyone have a fix? I tried searching the issue tracker but couldn't find anything about this.

Version: CiviCRM 4.6


texts: Upgraded php from 5.6.30 to 7.0.32, civicrm still gives PHP out of date error

texts:
I upgraded php from 5.6.30-0+deb8u1 to 7.0.32-1~dotdeb+8.1 and civicrm is still giving me a php out of date error.

When I run php -v it says 7.0, but civicrm still thinks I'm on 5.6.

Do I need to purge php 5.6 if php -v tells me I upgraded to 7.0?


texts: How to call my post_provision_install hook after CiviCRM installed?

texts:
I want to automate the removal of households from CiviCRM, right after it has been installed via Aegir on Drupal 7.

I implemented my post_provision_install hook, but it runs before the same hook of Hosting CiviCRM module, means before the install of the CiviCRM module.

How can I change the calling order of the post_provision_install hooks in this particular case?

Or how can be an post_hosting_install_task hook implemented and called?


texts: Has version 4.7 introduced an Activity Date filter problem with activity reports?

texts:
Since upgrading to 4.7 we have had the following problem:

Created a new Activity (contacts) report with
 - the Activity Date filter set to This week
 - the Navigation Menu Link To
   set to View Results

When running the report from the navigation menu the report is displayed without any filtering on Activity Date - the Activity Date filter has been reset to empty.

If I:

Set the (emptied) Activity Date filter to This week
Change the Navigation Menu Link To to Show Criteria
Click the Update Report button to save the changes
Re-run the report from the navigation menu

The report is not run, as expected, but the Activity Filter now remains set to This week. Clicking on the Preview Report button now produces the report I was expecting.

To see the problem on the demo site (while the Joomla demo site is still on 4.6):

4.6

4.7


texts: CiviCRM emails not sending with attachments

texts:
I'm sending post event emails to participants Find Participants> Event Name is> send mail to less than 50). These send fine when just mail body text is included.

When I add an attachment and press submit I get the following error message

I tried the same thing from find contacts- Find Contacts- random search criteria> send to less than 50.

Again, just text works fine, add an attachment and this time I get sent to the advanced search page with this message popping up

Currently Civi 5.19.4 Drup 7.69

Anyone seen anything similar?

Woo-hoo! Just recreated on dmaster.demo

Raised at lab.civicrm.org
https://lab.civicrm.org/dev/core/issues/1604


texts: Event registration confirmation page print doesn't work

texts:
After someone registers for an event, a confirmation page is displayed. Some users want to print the page even though a confirmation email is sent. However, the print doesn't work. The page heading is printed and nothing else, even though the correct confirmation info is displayed on the screen. Neither printing using the print icon nor the browser print work. Is there something else that needs to be configured within civi for the print to work?

We're using Wordpress 4.9.9 and Civi 5.4.1


texts: Does ModSecurity and CiviCRM play well together?

texts: I am thinking to add ModSecurity to the server (Wordpress 5.x/Apache2/Ubuntu 18) that is running CiviCRM to further augment the security.  Thought I thought I check on this forum on the experience of doing so and whether it is a good idea.  Thanks for your insights!


texts: Receipts Sent to Customer for Current Donation Include Previous Donations

texts:
Ok, I'm hoping I can explain this so it makes some sort of sense :)

In CiviCRM, we have a customer who has custom profile fields that donors can enter the amount of their contribution that they want to go to a specific cause

The issue is that the receipt is including the contribution the donor just made as well as the previous amount(s) they chose to designate the last time they made a contribution (since it's the same donor with the same email address).

Is there any way to remove the amount from the previous contribution the donor made? It's not helpful for our customer because they don't know what amount/designation applies to what year when they view the receipt that's sent and the customers are concerned that they are being charged twice.

Any help with this would be GREATLY appreciated because this is one of our my vocal customers. :)

If you need any additional information, please let me know.

Thank You,
Nicole

DRUPAL 7
CIVICRM 4.6.8


texts: How to I add new records to a batch after it has been created?

texts: How do I add new records to a batch after it has been created in batch data entry.


texts: Way to display non-public events to employees

texts:
Our organization has a variety of public events as well as private events. In many cases, I need volunteers/employees to see the private events so they can register to assist, etc.

Is it possible to have a means that when an employee logs into the website, the non-public events are listed in upcoming events?  I am somewhat familiar with ACL and have an employees ACL rule that works in other aspects. I would like a way to have the employee log-in and see all events.


texts: Canceling Recurring Contributions Without PayPal

texts:
I just noticed that our receipts for recurring contributions say "You can cancel this recurring contribution by visiting this page" with a link to PayPal's homepage and "You can update your amount by visiting this page" again, with a link to PayPal's homepage.

Almost all of our contributors are using credit cards, not PayPal.  How can I set this so our contributors can cancel a recurring contributions or increase the amount, when they are not using PayPal?

Thank you
CiviCRM 4.7.22 on WordPress 4.8.22


texts: New fields failed to get created properly, resulting in DB errors

texts:
In adding new custom fields to an existing set, things recently went wrong.  New entries were added in the civicrm_custom_field table, but the corresponding columns were not added to that field set's table.  This resulted in DB Error: no such field breaking the UI display of existing cases.  Deleting the rows from the custom_field table solved the errors so that existing cases can be viewed.

Now new cases cannot be created.  When the new case form is submitted the case gets partially added to the db (but is not visible via the UI) and a blank error screen with message DB Constraint Violation - case_type_id should possibly be marked as mandatory for Case,get API. If so, please raise a bug report. appears.  Creating a new case (or trying to) adds 83000 new lines to the log file and near the top of that entry is [nativecode=1054 ** Unknown column 'a_to_civicrm_value_special_case_fields_8._name_of_deleted_field_157' in 'field list'].  That seems confusing since "a_to_" is not actually part of the table's name, and "_name_of_deleted_field_157" isn't in the civicrm_custom_field table.  Are custom fields recorded/stored anywhere aside from civicrm_custom_field and the fieldset they're contained by?

Also, the field and case id's seem to have their incrementing messed up... the id#s appear to increment by 1 but there are several numbers skipped.  Is that a problem?  With the fields I deleted the row and column back to the last increment, 148, but when adding a new field its id was 155.  Can missing id's (149-154 in this case) be problematic?

Is there anything you can suggest or point me towards in getting this working?

edits:

131 rows in civicrm_custom_field table
CiviCRM 5.13.4


texts: How can Wordpress user edit Organisation details?

texts:
I'm sorry if this has been asked before but I can't find a solution...

I've created a custom Profile for an Individual's contact details and one for their Organisation's contact details. I've added shortcodes for both of these to separate pages in Wordpress. The user that I'm logged in with has an associated Individual contact record in CiviCRM and that Individial is an Employee of an Organization. I've also made sure the Individiual has access rights to edit the Organization contact details. This relationship was initially created via a Contribution page using profiles to both capture the users personal details and organization details using the 'on behalf of profile'. All good in that a logged in user can edit their Individual contact details, but when I try and access the page in Wordpress where the shortcode is for the Organization profile I get message:

This profile is configured for contact type 'Organization'. It cannot be used to edit contacts of other types.

What am I doing wrong? How can an individual edit his organisation's details?


texts: CiviMail not sending emails - Joomla 3.6 or 3.7 & Civi 4.7.18

texts:
I can send an email from any other area of Civi.  For example if I select a contact and send an individual email, it works...

BUT CiviMail - IS DRIVING ME CRAZY!!!

I am routing all email to spamexperts (using SMTP setting in Civi Admin) and again, it all works in other areas of the website, and even any other area of Civi itself.

I've check and confirmed the CRON job runs, I am even running it manually again just to be sure.  The CRON job for "send mailings" shows in the log that there is no errors, and everything is "sent" but it doesn't ever send any emails.

If I check the spamexperts delivery logs, I can see all my other emails going through that I send from other areas of Civi, but there is NO record of the civimail mailings even getting to spamexperts.

I am at a total loss, any ideas anyone?  I owe you big time if you can point me in the right direction!


texts: CiviRules and deprecated CRM_Core_OptionGroup::getValue

texts:
Using CiviRules 2.14.1 to process inbound SMS messages. It is driving the warning below in the log. This 2.0 blog refers to removing calls to deprecated CRM_Core_OptionGroup::getLabel, but I can't find mention of getValue. Not looking for an answer so much as making sure this is a known behavior. If it's just me, I need to worry!

  May 07 11:13:00  [warning] Deprecated function CRM_Core_OptionGroup::getValue, use CRM_Core_PseudoConstant::getKey.

  Array
  (
     [civi.tag] => deprecated
  )

  May 07 11:13:00  [info] Inbound SMS recorded for cid=1320.


texts:
On some but not all records, we see over 2K change log entries.

On this record, the change log started and ran continuously from 11-26-19 to 1-20-2020

Another instance I had imported to the preferred communication field and the import ran for ~20 minutes. The change log was continually getting written to for the entire import process.
For now, I have turned off detailed logging. We are using a separate db for it. Thoughts on what is going on here?


texts: CiviCRM menu missing Administer link after reboot

texts: I am a CiviCRM admin. I shut down my computer (personal computer, not the server where CiviCRM is installed) and when I restarted it, the menu is different. I do not have an Administer link in my main Drupal menu; I have Configuration instead. How can I restore my previous menu (the one with the Administer link)?


texts: How can I print out samples of message templates?

texts: I want to be able to compare various messages for inconsistencies in messaging.


texts: Why are my contacts' name and email empty?

texts:
I have many contacts with no first name, last name, or email. I don't know what my client has done to this site.

I viewed the records and they contain only id and sub-contact type.

Edit: I also tried the suggestion by Heather O. and looked at the Change Log.

I added one contribution where the external id there is not in my system but no new records have been created.

Do you have any idea?


texts:
When using PayPal Express as my payment option, there is no button appearing to take the user to PayPal. I've checked everything I can imagine, cleared caches, etc. and feel that I must be missing some little thing. But, for the life of me, I have no idea.

Please help!


texts: CiviCRM installation on Ubuntu via package manager

texts:
CiviCRM for Drupal 7 is packaged for Ubuntu in the Universe repository.

However, the CiviCRM installation documentation does not list installation via  the operating system's package manager (e.g. apt-get) as a recommended installation route.

Is that just because this installation route hasn't been documented yet, or is it because this installation route causes problems that are avoided by following the recommended route? If the latter, which problems are caused by using the OS's package manager?

I do not currently have an Ubuntu system available on which to evaluate the stability/bugginess of those packages myself, hence my asking here.


texts: After applying for a CiviCRM account, how long does it take to approve?

texts: We have applied for a CiviCRM account and wondering how long it would take to approve the application?


texts: Troubleshooting some Drupal and CiviCRM accounts becoming mis-linked

texts:
We are having an issue in Drupal 7.41 and civiCRM 4.6.4 (this was also happening to us with Drupal 7.34 and civiCRM 4.4) seemingly one at a time Drupal user accounts and CiviCRM accounts are becoming mis-linked to each other by one digit.

I haven't been able to determine a pattern to the users this happens to, or the timing e.g. we might get one in two weeks or two in one day. We usually get notice of this when a member cannot see their member profile field in their drupal account page.

For example, civicrm user tdavis@example.org has a link to their drupal account in their contact summary, pointing to UID 8190. When I go to the drupal user account for tdavis@example.org the UID is in fact 8189, and the link back to the civicrm contact summary simply says "profile not found".

The other symptom is that there tend to be multiple (I've seen anywhere between 1 and 15) civicrm records that are just the email address for the account that is mis-linked (for example tdavis@example.org is the only information, no names or drupal uid or anything). These records seem to be created after the mis-linking. Possibly related to number of actions the person takes in drupal?

Any ideas where to start to troubleshoot/replicate this issue or has it been seen before?

I can fix it through the uf_match table or by merging the contact into a new record without transferring the drupal link and using 'sync users to contacts', but i'd like to squelch the issue if possible...


texts: What is the scheduled job linked to Scheduled SMS Reminders?

texts:
In CiviCRM 4.5, you are now able to create Scheduled Reminders to be delivered by SMS as well as email.

We're having an issue with these reminders, however, I'm not sure which scheduled job triggers their delivery?

Send Scheduled SMS - Sends out scheduled SMS
I thought this was the one to trigger bulk SMS deliveries that have been set up, the same and the Scheduled Email job?
Send Scheduled Reminders - Sends out scheduled reminders via email
Refers specifically to the delivery of scheduled reminders, but the description refers to email only. Has the description just not been updated?

Would be really grateful if someone could point be in the right direction to investigate the other issue we're having.

Heather.


texts: A contribution batch containing transactions of more than one currencies causes fatal error

texts:
My setup: CiviCRM 5.18.3 on Drupal 7.

I created a Contribution batch.
At transactions I chose two transactions of difference currencies e.g. HKD and USD and Assign them to a batch.
Then I no longer be able to retrieve the list of batches because of fatal error:
Dialog:
DataTables warning: table id=crm-batch-selector-2 - Ajax error. For more information about this error, please see http://datatables.net/tn/7

In ConfigAndLog there are lines produced e.g. CRM_Core_Exception .... Invalid currency "HKD,USD" blah blah.....

Even I cancel the offending transaction it does not help. I had to delete the transaction in that batch to revive the batch's functioning.

Please kindly advise.

Best Regards,

2019-10-17 (too long to add to comments).
I copied this from ConfigAndLog, because no on-screen backtrace is shown even I enabled backtrace at System setting.
Oct 17 09:53:08  [debug] $backTrace = #0
/var/www/c53/web/sites/all/modules/civicrm/CRM/Core/Error.php(463):
 CRM_Core_Error::backtrace("backTrace", TRUE)

#1 /var/www/c53/web/sites/all/modules/civicrm/CRM/Core/Invoke.php(55): CRM_Core_Error::handleUnhandledException(Object(CRM_Core_Exception))

#2 /var/www/c53/web/sites/all/modules/civicrm/drupal/civicrm.module(444): CRM_Core_Invoke::invoke((Array:3))

#3 /var/www/c53/web/includes/menu.inc(527): civicrm_invoke("ajax", "batchlist")

#4 /var/www/c53/web/index.php(21): menu_execute_active_handler()

#5 {main}


texts: Self-service cancellation from a registered event seems to be broken

texts:
The following error is reproduceable on a fresh install of CiviCRM 5.35.1 on WordPress 5.7. If self-service cancellation is enabled for a simple event, the cancellation or transfer request results in the following error:
CRM_Core_Exception: getFieldValue failed in /home/bbcadmin2016/sigstage57.net/wp/wp-content/plugins/civicrm/civicrm/CRM/Event/Form/SelfSvcUpdate.php on line 132
The stack trace indicates this:
CRM_Core_DAO::getFieldValue('CRM_Event_DAO_Ev…', null, 'title') /home/bbcadmin2016/sigstage57.net/wp/wp-content/plugins/civicrm/civicrm/CRM/Event/Form/SelfSvcUpdate.php:132
I am reporting this again in the hope that it can be verified by someone else as a bug  - something that the core team requests before submitting the issue.


texts: How to make new groups immediately visible in a new mailing?

texts:
It seems that a newly created group (with mailinglist checked) isn't directly available when sending a new mass mailing, but does eventually end up being visible after a few minutes (probably between 5 and 10 min?)

This happen with the "new" angular interface, we didn't have this issue with the previous interface.

Are the list of available groups cached somewhere? Is there a way to clear that cache (or submit a PR so it does it by default after creating a mailing list group)?


texts:
I've followed all the instructions according to this documentation but when I test the incoming SMS', I do not see the SMS's coming into CiviCRM.

Below are the settings I have set up in Telerivet and then copied to Civi

This is the Webhook settings

And here I would expect to see the option to send an SMS

I also would like to see where the incoming SMS would come into. According to the video, a report can be set up to show all the incoming SMS's but I cannot seem to create the same report.


texts: Is there a way to create a Membership Status for memberships that have recently been renewed?

texts: We currently use the membership status "NEW" to identify recent membership signups.  For various reasons, we also need a membership status to identify those who have recently renewed.  As a workaround, I'm creating a smart group for the activity "Membership Renewal" but it seems that a status would be better.  Anyone know how to do this or if it is possible?


texts: I'm new to Civi and I'm trying to view books.civicrm.org, but its asking for a username and password, where do I register for that?


texts:
How do you implement more than one "Employee of" field?

We have a number of contacts that have multiple jobs.  Ideally we would like to have the Employee Of field have multiple sub fields (primary, secondary, etc) however we are open to all implementation.  How do most people implement other Employers on an individual contact's record?


texts:
I am on version 4.7.19  and whenever someone pays with PayPal the event confirmation email is not beign sent.

The payment is processed, the status is paid, but no email sent.  I have looked at other threads and they say this should be fixed by 4.7.13 but I have a newer version.

On thread mentioned an error on the ConfigAndLog,  and I am getting the FatalErrorDetails

Mar 15 19:13:18 [info] $Fatal Error Details = Array ( [message] => The requested Profile (gid=XXXXX) is disabled OR it is not configured to be used for 'Profile' listings in its Settings OR there is no Profile with that ID OR you do not have permission to access this profile. Please contact the site administrator if you need assistance. [code] => )

Not sure what would be the next step to fixing this. Help Please

I have the IPN return set


texts:
Can anyone provide guidance how to create tokens for custom participant fields, to be added into a  Contribution Invoice Receipt for event registrations? Our tax system requires that VAT registration numbers are included in all invoices, and we want to also add purchase order numbers.

(Drupal, Civi 4.7)

Many thanks
Davy


texts:
We run CiviCRM 4.6.2 with Wordpress 4.2.3. I have run a couple of large Mailings recently and they get stuck 'running'.  I know some recipients have received them although the reports say 0% have been delivered.  I don't want to execute the cron job again as previously some recipients then received the mailing twice.

Any ideas?


texts: .htaccess file in custom templates parent folder breaks styling

texts:
I'm developing new site using Wordpress 4.3.1 and CiviCRM 4.6.10 - local WAMP development environment. All working fine, however, I have civiCRM setup to correctly load some custom styles and templates from:

\plugins\files\civicrm\custom\css\

and

\plugins\files\civicrm\custom\templates\CRM\

All works fine except that when installing/upgrading civiCRM an .htaccess file keeps getting created at the

\plugins\files\civicrm\custom\

level with contents

  Order allow,deny
  Deny from all

and as soon as that file is present civicrm no longer picks up custom styling specified in those child folders. How can I prevent civi upgrades from re-creating that file? or perhaps change contents so it does not?

Thanks


texts:
On a multisite with civimember enabled on that domain, the membership tab  on the contact summary screen does not show. I have ruled out Contact Layout Editor as a cause by disabling it. I have tried disabling and re-enabling the civimember component and clearing the caches.
I have a valid membership type on that domain too (not that that should matter)
What would be the cause for it not to show?


texts: how can a participant return to sign up more additional participants?

texts:
This question shares a lot of features with a question I asked a year ago (CiviEvent: how to collect different custom data for different event participant roles?) but I'm still faced with a use case I can't solve :-(

Here's the scenario:  a user registers herself and a guest for an event (there is an Attendee profile used to gather info on the main registrant, and a guest profile used for the Additional Participants forms which collects different data that is specific to the Guest).  Later, the user realizes she'd like to register another guest. How does she do that? (Ed by Pete) She cannot use the form again without being presented with the primary participants fields, whereas we only want to collect the data for the Guest profiles

I thought I could use the "Event Registration Based on Participant Roles" extension, and create a link to a blank registration form sepcifically for signing up a participant with a Guest role.  But although the extension works fine to set the participant role for the Guest registration form, the form itself displays the Attendee profile, not the guest one!  I cannot for the life of me figure out how to specify a different profile than the default one for a registration form.

What I've tried:

-- Form hooks only allow me to manipulate the output on the form -- I can't remove the underlying Attendee profile fields or change what profile is included when the form is built.

-- I can't link directly to the AdditionalParticipant.tpl form, because it only functions within the data context of the main registration process.

-- I've even tried hacking the source code Register.php to conditionally load a different profile based on user role, but it seems the extension is also just using the buildForm hook, so at the PHP level I can't tell the difference between a regular registration and someone registering a guest directly. I can't determine when to load the guest profile instead of the attendee profile.

-- The only workaround I've come up with is to "allow multiple registrations with the same email address", and created a $0 priceset option "already registered, just updating my registration data".  So people can come back to the main registration form, select that no-cost option, and fill out more additional participant/guest forms. Of course that's not very user friendly, and gets ugly in the reports, looking like the same attendee has registered multiple times.....

This is a Joomla system so please don't suggest Webforms -- I know this would be much simpler using Webforms but I don't have Drupal available to me.

Any and all ideas welcome.


texts: Combining case timeline with case sequence(s)

texts:
Our organization would like to record all activities for coaching processes with clients. In order to accomplish this I consider using Civicase.

The case could comprise following:

Activities on the case timeline e.g.:

A. open case
B. send intake form (receive intake form / evaluate and/or process intake form)
C. initial coach/intake session
D. Coaching session(s)
E. send evaluation form (receive evaluation form / evaluate and/or process evaluation form)
F. close case

Because we wouldn't know the exact number of required coach sessions (D) at the time the case is initiated, I guess activity D (Coach sessions) could/should initiate a Sequence (of coach sessions).
Would this be a good approach or should this be done differently?

A second question:
Should we assign a coaching process case to a coach and/or should we add a case role 'coach' and assign the coach there?

Many thanks for your kind input.


texts: When avoiding duplicate relationships why does Civi check for identical custom fields?

texts:
Today I realized that our installation holds many individuals without an address. Most of them are employees and correctly related to their employer. So I decided to use the api to let all them share the address of their organization. Once done, I saw that the works-for-relationships are doubled.

A glance into the code told me that CRM_Core_BAO_Address calls it's processSharedAddressRelationship() method on address creation and this references CRM_Contact_BAO_Relationship::checkDuplicateRelationship. This is what I expected. But it did not detect our existing relationships because for whatever reason it checks if the custom fields of existing relationships are given in the params array for the new relationship:

#923 $result = self::checkDuplicateCustomFields($params, $relationship->id);

And AFAICS the approach can't work properly because CRM_Core_BAO_Address creates the params for the relationship:

$relParam = array(
  'is_active' => TRUE,
  'relationship_type_id' => $relTypeId,
  'contact_id_a' => $currentContactId,
  'contact_id_b' => $sharedContactId,
);

// If already there is a relationship record of $relParam criteria, avoid creating relationship again or else
// it will casue CRM-16588 as the Duplicate Relationship Exception will revert other contact field values on update
if (CRM_Contact_BAO_Relationship::checkDuplicateRelationship($relParam, $currentContactId, $sharedContactId)) {
  return;
}

So the $relParam could never include custom fields checked in CRM_Contact_BAO_Relationship::checkDuplicateRelationship

public static function checkDuplicateRelationship(&$params, $id, $contactId = 0, $relationshipId = 0) {
  [....]
  $result = self::checkDuplicateCustomFields($params, $relationship->id);

but there this array is compared with the existing relationship.

Why is this?

I'll fix this locally but I don't understand what's going on...


texts: How do I ensure all Check Boxes are ticked for a single Custom Field on a Profile form?

texts:
I have a single Custom Field of type "Alphanumeric" and "CheckBox" with a check list which requires all boxes to be ticked before continuing.

I have set the field to Mandatory but this allows the form to be submitted with just one option selected.

Is there a way to set a CheckBox widget to require all boxes to be ticked? I don't really want to create lots and lots of Custom Fields to achieve this.


texts: I've run into this twice this month and scratching my head. Read this image upside down: We hit post create Address hook -> my regex extension creates a Tag - all good; happy dance; then something in Core deletes my Tag :-( why?


texts: Can I save bulk update screens for future use?

texts:
I'm not sure if my title is 100% clear, but here's the situation I'm facing.

We have custom fields that once a year we have to manually update for all current members. A smart group was created to find all current (paid) members and a profile that shows the username and the two custom fields we need to update. To initiate the bulk update, we do the following:

Click on Manage Groups
Click on the Contacts link of the group in question
Select all entries
From the Actions drop down list, select Update multiple Contacts
On the next screen, select the profile for updating the appropriate fields
Click Continue

Now, we can update the necessary fields, click Update Contacts and we're done.

Is there a way to save that bulk update screen for later re-use. Ideally, I'd like to be able to save it for easy access from the menu much like a report. Not only would it be quicker to access, but also simpler when training someone else to make these updates. Basically, it should remember the Smart Group and Profile used to create it.


texts: How to change Paypal IPN URL when migrating Civicrm onto a new domain?

texts: I would like to move my civi install to a new domain. I am able to change paypal IPN to new domain. But for all previous recurring contribution via paypal, i can't change the urls. what can be done?


texts:
CiviCRM is telling me I need to set up Cron jobs and CiviMail, but I've looked at the documentation and it's all Greek to me. How can I get help with setting these up?
I'm using Wordpress with Bluehost VPS hosting.


texts:
I am using drupal 7.56 + civicrm 4.7.25
I have a Paypal account and I configured a Payment Processor for test with the REST API credentials from https://developer.paypal.com

REST API Sandbox account becomes PP User name
REST API Secret becomes PP Password
REST API Client ID becomes PP Signature

This configuration does not work with error message :
Payment approval failed with message :Security error Security header is not valid

Where can I find API credentials required by Payment Processor configuration ?
And more generally could someone tell a detailed end to end Paypal Express Checkout Civicrm integration ?


texts:
I am trying to run civicrm in my machine and access it through LAN from other machines. So I made a change in word press general settings like below:

WordPress Address (URL)  http://myipaddress/mysite
Site Address (URL)  http://myipaddress/mysite

After this, whenver I am doing a search/report/ any function in civicrm I am being prompted for password. And after that I am directed to civicrm home page and the loop repeats. Can anyone help me out?


texts: Creating An Automatic Employee of Relationship At Signup

texts: When someone signs up on behalf of an organization in Civicrm two records are created: one for the individual and one for the organization but no Employee of relationship is created.This relationship has to be added manually. How can one cnfigure Civicrm such that when an individual signs up on behalf of an organization an automatic 'Employee of' relationship is automatically created.


texts: How to include token or variable for Invoice number under the message templates for Memberships - Receipt (on-line)

texts:
I need to send Invoice number in the message templates for Membership Receipt Online, but I don't see any token or variables associated for Invoice Number which I can use to place it

is there any way we can place the invoice number in the message templates ?


texts: Contribution email receipt with custom fields shows array in template

texts:
Using default contribution receipt message template, the receipt email shows "array" rather than custom field values.  It works correctly if no custom fields are used in profile.

This seems like this issue which does not seem to be closed.
https://forum.civicrm.org/index.php?topic=27587.0

Using Civi 4.6.8


texts:
What does it mean if, on an individual contact, I select the 'bulk email?' box when editing their email address?

I want to be sure that all of our contacts can receive our newsletter.


texts:
I'm trying to add an option to disable the display of nickname in the setting preferences.
The checkbox is appearing but it doesn't work, when the option is not checked the nickname field shouldn't appear in the contact.
I added the option value with Apiv4.
btw Surnom = Nickname