texts: When running event reports, receive Error: '' is not a valid option for field id

texts:
I use wordpress+civicrm and all worked well since the last upgrade. Now the event report always gives the same error: '' is not a valid option for field id. On the bottom the bugs report.

Thanks

CiviCRM_API3_Exception: "'' is not a valid option for field id"

#0 /wp-content/plugins/civicrm/civicrm/CRM/Core/Form/Renderer.php(219): civicrm_api3("event", "getlist", (Array:1))
#1 /wp-content/plugins/civicrm/civicrm/CRM/Core/Form/Renderer.php(184): CRM_Core_Form_Renderer::preProcessEntityRef(Object(HTML_QuickForm_text))
#2 /wp-content/plugins/civicrm/civicrm/CRM/Core/Form/Renderer.php(103): CRM_Core_Form_Renderer::updateAttributes(Object(HTML_QuickForm_text), FALSE, NULL)
#3 /wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Renderer/Array.php(221): CRM_Core_Form_Renderer->_elementToArray(Object(HTML_QuickForm_text), FALSE, NULL)
#4 /wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/element.php(415): HTML_QuickForm_Renderer_Array->renderElement(Object(HTML_QuickForm_text), FALSE, NULL)
#5 /wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm.php(1703): HTML_QuickForm_element->accept(Object(CRM_Core_Form_Renderer), FALSE, NULL)
#6 /wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(685): HTML_QuickForm->accept(Object(CRM_Core_Form_Renderer))
#7 /wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php(116): CRM_Core_Form->toSmarty()
#8 /wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php(101): CRM_Core_QuickForm_Action_Display->renderForm(Object(CRM_Report_Form_Event_ParticipantListing))
#9 /wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Report_Form_Event_ParticipantListing), "display")
#10 /wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Report_Form_Event_ParticipantListing), "display")
#11 /wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Submit.php(83): HTML_QuickForm_Page->handle("display")
#12 /wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Submit->perform(Object(CRM_Report_Form_Event_ParticipantListing), "submit")
#13 /wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Report_Form_Event_ParticipantListing), "submit")
#14 /wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(353): HTML_QuickForm_Page->handle("submit")
#15 /wp-content/plugins/civicrm/civicrm/CRM/Utils/Wrapper.php(115): CRM_Core_Controller->run()
#16 /wp-content/plugins/civicrm/civicrm/CRM/Report/Page/Report.php(76): CRM_Utils_Wrapper->run("CRM_Report_Form_Event_ParticipantListing", NULL, NULL)
#17 /wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(312): CRM_Report_Page_Report->run((Array:4), NULL)
#18 /wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:14))
#19 /wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:4))
#20 /wp-content/plugins/civicrm/civicrm.php(1133): CRM_Core_Invoke::invoke((Array:4))
#21 [internal function](): CiviCRM_For_WordPress->invoke("")
#22 /wp-includes/plugin.php(496): call_user_func_array((Array:2), (Array:1))
#23 /wp-admin/admin.php(226): do_action("toplevel_page_CiviCRM")
#24 {main}


texts: How to create a report showing a subset of contacts and their tags

texts:
I need help creating a custom report, please. I have approximately 15 tags (health, advice, benefits, etc), and I need to know how to create a report showing which of the contacts in my database are associated with them. I can run a report that creates the appropriate list of contacts, but it doesn't show which tags each contact has. I hope this makes sense!

Many thanks,

cdwmrcf


texts: Using "Honoree Individual" profile for "Honoree Section" gives error on demo

texts:
Doing some testing on demo. On a contribution page, checked "Honoree Section Enabled" the default profile is "Honoree Individual". But testing the live page gives:

Sorry but we are not able to provide this at the moment.
API permission check failed for Contact/getoptions call; insufficient permission: require access CiviCRM

Changing the profile to New Individual does not give the same issue. What's going on?


texts: When creating a new activity, is there a way to have the default activity status as blank/empty? Currently, when creating a new activity, the status is scheduled. I noticed that sometimes, users forget to change/update the status.


texts: The CiviReport's Event Income Report (Detailed) does not show each payment. How can I show (and hopefully total) all the payments registered in the system in one report?


texts: Unable to sort event participants by participant name after search?

texts:
It seems it's not possible to sort event participants by name after the search. To reproduce:

Go to events, find participants,
Select an event under event name,
Select participant status (example registered),
Hit the search button.
The expected results are displayed,
now click on the Participant column of the search results to sort alphabetically by name
now you get 'No matches found' for our search criteria.
Hit the search button again.

Now the results are redisplayed with this warning message:

Warning: array_key_exists(): The first argument should be either a string or an integer in CRM_Utils_Array::value() (line 55 of /srv/buildkit/build/d46/sites/all/modules/civicrm/CRM/Utils/Array.php).
Notice: Array to string conversion in CRM_Contact_BAO_Query::buildQillForFieldValue() (line 5753 of /srv/buildkit/build/d46/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php).

The version of CiviCRM Version is 4.6.24.

It seems this un-expected behaviour only happens when searching for events participants and Participant status is selected.


texts: Autofiling email activities via EmailProcessor to ORGANIZATION

texts:
I'm successfully using the Autofiling email activities via EmailProcessor feature for Individuals.

However, when I try to automatically associate to an Organization with an email address the email is not attached as an activity. Instead CiviCRM creates a NEW Individual with the email contents attached as an Activity.

Is there a way to have CiviCRM's Email Processor look at Individuals AND Organizations for the Autofiling of email activities?


texts:
I'm getting the following error when I'm trying to send a test email.

  Error in call to Mailing_send_test : Error in call to
  MailingJob_create : DB Constraint Violation - possibly mailing_id
  should possibly be marked as mandatory for this API. If so, please
  raise a bug report

Civi was working yesterday. Some reports have been run since then but nothing else. I'm on 4.6.22 for Drupal.  Any thoughts on how I can fix this bug?


texts: Article selection while creating a mailing?

texts:
I'm using Civicrm into my Joomla 3.4.5 site.
Is it possible to select some articles into my joomla article's archive and insert them directly into a civicrm mail while i create a new mailing within the mailing template creation process?
Thank you!


texts: Where is the documentation for installing CiviCRM with Drupal 8 or for upgrading a Drupal 7 system with Civi to Drupal 8

texts: This question is being asked so that it becomes the go to Answer for documentation / installation / migration questions hopefully.


texts:
Currently, I'm developing a civi extension in a Wordpress environment. I want to add some debug lines to make sure I'm receiving the intended result from variable/function.

I refer this guide it says the log files are saved in ConfigAndLog directory.but that directory is not available.

I want to know how to include debug lines in the code and from where I can view the results?

Thanks in advance!


texts:
The merge API was worked on 5.0 version but after upgrade to 5.13.1 the merge is Stopped working.

Any help is very appreciate.


texts: Bcc not hidden on mail sent by SMTP - is this a bug?

texts:
If a contribution page is configured to Bcc receipts to a given address, the Bcc should not be included in emails to any recipient of that receipt.

In my CiviCRM 4.7.9 site, the Bcc header is correctly not included in any receipt emails, if mail is sent with mail(), i.e., if "mail()" is selected at /civicrm/admin/setting/smtp.

However, it IS visible in the email to the donor, if mail is sent with SMTP, i.e., if "SMTP" is selected at /civicrm/admin/setting/smtp.

FWIW, the SMTP provider in this case is sendgrid, but I'm not sure yet whether that's relevant.

Is this a bug in CiviCRM, or is it an issue with Sendgrid?

Update:
A code change as shown here causes Bcc to behave properly in SMTP (sendgrid) and mail(). Makes me think it's a bug that could be fixed in core.

diff --git a/CRM/Utils/Mail.php b/CRM/Utils/Mail.php
index 57453a0..be3f052 100644
--- a/CRM/Utils/Mail.php
+++ b/CRM/Utils/Mail.php
@@ -267,6 +267,7 @@ class CRM_Utils_Mail {
       }
       if (!empty($headers['Bcc'])) {
         $to[] = CRM_Utils_Array::value('Bcc', $headers);
+        unset($headers['Bcc']);
       }
     }
     if (is_object($mailer)) {


texts: How would we implement a monthly prize draw database?

texts:
Our charitable group runs a monthly prize draw. Volunteer collectors call on the members to collect the entry fee each month, but some people may not be at home so won't be entered. Some members pay for one month. Others pay for several months at a time. So entry in to each draw depends on whether a member is paid up that month. Each collector is assigned a set of members to call on.

Has anyone implemented something like this in CiviCRM?


texts: Multiple Financial Types on one payment form?

texts:
Is there a way to specify multiple financial types on one contribution or registration form? For example, what would be the best way to set up a page that allowed a gala ticket purchase and also allowed sponsorship levels (if desired)? We can set up multiple price sets on a contribution form to allow the separate selection of a ticket and a sponsorship level, but they would all be the same financial type.

In this case, I suppose the best case would be to set up an event for the gala, allow registration including a few custom price sets, but to be able to break those extra (optional) donation/sponsorship items out as the 'Donation' (or 'Sponsorship') financial type rather than 'Event fee'.

Is anything like this possible?


texts: Subject line problem when using action "Thank-you Letters for Contributions" in Find Contributions v4.6.8

texts:
I'm trying to use an email template in the "Thank-you Letters for Contributions" action on the Find Contributions results page - civicrm v4.6.8

This action brings up the form "Create Printabe Letters (PDF)" In this form:
- I select "Send emails where possible. Generate printable PDF’s for contacts who cannot receive email." for the Print and email options.
- I choose an email template with which the civi form correctly fills in the Activity Subject and Your Letter fields.

But no matter what text I put in the Activity Subject field, every email sent has the subject line:  Thank you for your contribution/s

Any ideas for getting the template subject line to appear would be appreciated.


texts: Adding a parent to a static group from Search using Actions

texts:
When creating a smart group, I have the option to add a parent to the smart group.

However, the same parent option doesn't show up when creating a static group from Search using Actions.

Is there a way to have the same 'Add Parent' functionality show up for static groups that are created from a Search?  Yes, I can change the settings of the group after creating the group so that the correct parent is assigned but I would rather be able to set this setting while creating the group.


texts: Composer 2 and CiviCRM Installation Error

texts:
I am trying to install CiviCRM on a Drupal 8 site using Composer 2.  I am getting the error below.  Is this a Composer 2 issue?  Do I need to revert to Composer 1?  Is there a different fix?  Thx.
=======================================
composer require civicrm/civicrm-{core,packages,drupal-8}:'~5.36'
./composer.json has been updated
Running composer update civicrm/civicrm-core civicrm/civicrm-packages civicrm/civicrm-drupal-8
Loading composer repositories with package information
Updating dependencies
Your requirements could not be resolved to an installable set of packages.
Problem 1
- civicrm/civicrm-core[5.36.0, ..., 5.37.x-dev] require symfony/finder ~3.0 || ~4.4 -> found symfony/finder[v3.0.0-BETA1, ..., 3.4.x-dev, v4.4.0-BETA1, ..., 4.4.x-dev] but the package is fixed to v5.2.4 (lock file version) by a partial update and that version does not match. Make sure you list it as an argument for the update command.
- Root composer.json requires civicrm/civicrm-core ~5.36 -> satisfiable by civicrm/civicrm-core[5.36.0, 5.36.1, 5.36.x-dev, 5.37.x-dev].
Use the option --with-all-dependencies (-W) to allow upgrades, downgrades and removals for packages currently locked to specific versions.
Installation failed, reverting ./composer.json and ./composer.lock to their original content.


texts: Search for contributions made in previous 4 months

texts:
I'm trying to search for contributions made in the previous 4 months.

Example - We are in October, but I want to be able to see if people have contributed since June 1.

I can search by previous month (Sept), previous 2 months (Aug), and the previous quarter (July), but am not sure how to search from the previous 4 months.

Any ideas?

Thanks!


texts: Cant find a way to access the CiviCRM $form object in Drupal

texts:
I'm having trouble accessing the CiviCRM $form object on a Drupal site running CiviCRM.

In Drupal, I can use hook_form_alter() anywhere in code and make changes to any form object in Drupal. I'm trying to do the same thing for a CiviCRM form, but none of the functions or hooks seem to give me access to the $form object.

Also, I'm attempting to do this from a custom script with Drupal and CiviCRM  bootstrapped.  If someone could point me in the right direction, I would be most grateful.

[EDIT:] I've tried this, but can't get any data back for anything...

define('DRUPAL_ROOT', $_SERVER['DOCUMENT_ROOT']);
require_once DRUPAL_ROOT . '/includes/bootstrap.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);

eval(`cv php:boot`); // to bootstrap CiviCRM according to their documentation

function mycustomhook_civicrm_buildForm($formName, &$form) {
    dpm($form);
    dpr($form);
    kpr($form);
    var_dump($form);
    print_r($form);
}

What am I missing?


texts: Wordpress permission issue on a fresh install of CiviCRM

texts:
I have just installed CiviCRM and I have a permission issue when accessing the "Configuration checklist" page.

When clicked, this URL redirects me to front-end with message :

  "You do not have permission to access this content."

Page URL : http://domain.com/civicrm/?page=CiviCRM&q=civicrm/admin/configtask&reset=1

How come I encounter this issue ?
Can it be a server-side configuration problem ?

Thanks for your support.


texts: After I enter my extensions directory and save, this message appears: "Public directory down or too slow - please contact CiviCRM team on forums." Appears the extensions directory on civicrm.org may have moved since 3.4 was released?


texts:
CiviDiscount gives an easy way to say, "Members get a lower price on a certain event", but I have the opposite situation - "attendees of a certain event get a discount on a membership".  Can anyone tell me how to do this?

It seems like I should be able to use the "advanced API filter" to find event attendees - but I can't find any examples of how to use that option.


texts: Modifying Default Contact Forms (Individual, Household & Organization)

texts: How can I modify the default contact forms and remove the unnecessary fields and add new fields instead.


texts: constraint violation civicrm_subscription_history on Member Join

texts:
CiviCRM 4.7.14,
Joomla 3.6.5,
CiviGroupSync 2.1.0

It seems the contact_id is not being passed in causing the constraint violation.

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

[code] => -3
[message] => DB Error: constraint violation
[mode] => 16
[debug_info] => INSERT INTO civicrm_subscription_history (group_id , date , method , status ) VALUES ( 73 ,  20170202135245 , 'API' , 'Removed' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`wifs_j15`.`civicrm_subscription_history`, CONSTRAINT `FK_civicrm_subscription_history_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
[type] => DB_Error
[user_info] => INSERT INTO civicrm_subscription_history (group_id , date , method , status ) VALUES ( 73 ,  20170202135245 , 'API' , 'Removed' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`wifs_j15`.`civicrm_subscription_history`, CONSTRAINT `FK_civicrm_subscription_history_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
[to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="INSERT INTO civicrm_subscription_history (group_id , date , method , status ) VALUES ( 73 ,  20170202135245 , 'API' , 'Removed' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`wifs_j15`.`civicrm_subscription_history`, CONSTRAINT `FK_civicrm_subscription_history_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]

In the backtrace, the contact_id exists prior to this, so why is it not being passed? I believe this fatal error is causing the Contribution to remain in pending status.

This happened when a member provided a contribution while registering for a membership.


texts: Greater flexibility on visibility of names/descriptions for groups on subscribe/unsubscribe pages

texts:
I guess this is something of feature request cum support request. The naming of groups, and the descriptive text used for them has always been used primarily, in my usage at least over the last decade or so, to the benefit of the administrator/s, the people working with groups day to day for mailings, segmentation, etc.

I've always found it something of an irritation that I have to constrain my language in these fields simply because in certain circumstances, for example on subscribe/unsubscribe page for groups that are also mailing lists, this text is visible to end users. We're working around this to some extent by using CSS to hide the descriptive text on these user-facing pages, but this is something of a fudge. It would be so much easier to have admin-facing titles/descriptions that make sense for them, and at the same time present something much more suitable to end users.


texts: How can I create a public list of event attendees?

texts: I would like to create a page on my Wordpress site that lists everyone who is registered for a specific event (EID 3 in this case). I only need a list of attendees names, sort by last name. No other columns needed.


texts: Is the cache field 'expired_date' no longer used?

texts:
After inspecting some cache entries in the civicrm_cache table I've come across the field called 'expired_date' which is set to NULL in all cases.

The only reference to the field I can find anywhere in the codebase is in the schema file. So it looks like this is an old field definition that is no longer used and can be removed?


texts: Effect of address change on current employer

texts:
I need your opinion on a standard CiviCRM behavior:

When you add or change the address of an individual AND you check "Use another contact's address", AND that target contact is an organization, then the current employer is changed + the "employee of" relationship.
Regardless of the location type.

This makes sense for location type "work". But why does this happen for all location types?

Wouldn't it better to limit this functionality to location type "work"? Or add a checkbox on location types, so users can specify on which location types they expect that behavior?


texts: How to setup event registration for multiple people with some additional people not paying

texts:
On WordPress, looking for suggestions on how to setup registration in this scenario:

Event Prices: Individual $50, Couple $80, Family $100

If the registrant chooses a couple one additional person does not need to pay. If they choose family, they can somehow indicate who are family members and opt out of paying for them.

This can get messy, what if someone wants to register 3 individuals, 2 couples and 1 family?

Added note in response to comment: Would like to capture additional participants information.


texts: After upgrade to 5.6 status still shows 5.4.0

texts: I have CiviCRM for Drupal 7. Just upgraded from 5.4.0 to 5.6.0 via drush. Everything seems OK, including database. Drupal module page shows 7.x-5.6.0. However, CiviCRM status page still thinks that I have 5.4.0 and suggests that I either apply patch to 5.4.1 or upgrade to 5.6.0. I deleted template_c files... How come?


texts: Subscribe to mailing list through the API

texts:
I am trying to subscribe a user to a mailing list through the REST API.
I understand that I need to create a Contact first, then subscribe it to a given mailing list. While I can create the contact, I can't subscribe it to the list using parameters:

entity: 'MailingEventSubscribe'
action: 'create'
email: [the-contact-email-here]
group_id: [the-mailing-list-group-id-here]

This will result in
{"is_error":1,"error_message":"Subscription failed"}

The CiviVRM version here is 4.2.0
I could't find documentation for the API on this specific version, so I'm playing the guessing game here :). I've been also told that the API requests can be chained somehow in order to do just 1 instead of 2, is there a documentation for this?

Can someone point me into the right direction? Thanks.


texts: Is there an easy way to provide a link to an online event after user has registered?

texts:
To start, I am looking for a purely civicrm solution.
I simply want to include a link to the webinar, livestream, etc. When the user registers, in their confirmation email, a link to the online location of the event will be included in the body of the email, and hopefully in eventics.
Any suggestions?


texts: How do I proceed to make CiviCRM bilingual

texts:
Both English and French are enabled under Languages Options.

However, I have yet to see the green buttons several posts have mentioned.

For the email greeting, I had attempted to use the solution proposed by a German user. In French one uses Cher and Chère, but this does not work.

{capture assign=l}{contact.preferred_language}
{/capture}{capture assign=g}{contact.gender}{/capture}
{if $l="fr_CA"}
   {if $g="Female"}Chère{else}Cher{/if}
{else}Dear{/if}
{contact.first_name} {contact.last_name}

All I get is Network Error.


texts:
For some reason Civi is using UTC and not the Joomla time. The system, and php and mysql times are reporting correctly (Brisbane)
.
For Mysql I have run the following to get its time;

SELECT NOW() AS 'NOW';

For PHP I ran this

echo 'PHP date: ' . date('Y-m-d H:i:s');

Both report correct time.
I also set the time zone in a local php.ini file and php is picking this up and reporting this correctly.

The error that Civi displays shows PHP as having the wrong time.

I see a timezone table in the database which is empty. Can I hardcode it in there? What else might be going on?


texts: Email processor silently truncating anything after an emoji in inbound emails

texts:
A related question is Has anyone used Emojis in CiviMail subject/body? and the answer is to change the database to use utf8mb4 which is going to be standard in CiviCRM in upcoming versions, but using utf8 currently I'm seeing that depending on the database (e.g. mysql vs. mariadb) and version (e.g. mysql 5.5 vs 5.7) it can fail noisily or can fail silently and just truncates anything after the emoji. So this is partly a PSA in case others haven't noticed silent fails.

I was able to run this grep on the sites/default/files/civicrm/custom/CiviMail.processed folder (drupal - adjust as needed) to locate at least some candidates that have been truncated, but I doubt there's a way to then automate updating the activities in civi. If I find one will post back here.

grep -r "=F[0-7]=[0-9A-F][0-9A-F]=[0-9A-F][0-9A-F]=[0-9A-F][0-9A-F]" sites/default/files/civicrm/custom/CiviMail.processed


texts: How to record work trades as payment on balance owed

texts:
We have a handful of people in our organization who pay for events partially with money and partially with work trades.  Let's say they owe us $1000 for an event.  In month 1, they make a partial payment of $100.  We record this via the back office.  In month 2, they work for 10 hours and reduce the balance they owe us by $200.

How should we record this $200?

What I would like to do is to create a Payment Method called "Work Trade" but I'm not sure what financial account it should relate to.

What it should really do is reduce Accounts Receivable.  But I'm not sure how to record a negative amount to Accounts Receivable.
It should not go against Payment Processor Account, because no actual cash is received.
Should I set up another account type, called like "Work Trade Account" or something?

Another option is to reduce the amount they owe us directly by reducing the $1000 down to $800 in their event registration.  But I don't really want to do this because many of our events are fixed price, and so this would introduce the need to modify event prices so I can change their registration.  Also, it's not correct -- they are giving us a value of $1000 for that event.

Suggestions or best practices?

Thanks


texts: Bounce processing using oath-client with GSuite: Required parameter not passed: "refresh_token"

texts:
Using CiviCRM 5.37.2.
I'm trying to use the oath-client extension to do OAuth authentication of a Google Workspace (GSuite) account for bounce processing. The credentials are created on the Google side of things, and when I set up the Mail Account in CiviCRM and assign it to bounce processing, it works; "Save and Test" responds positively. And if I then go to the Scheduled Jobs and immediately execute the Bounces Fetcher job, it completes successfully.
However, after a little while, it fails to run, with this error:
Parameters parsed (and passed to API method):
a:1:{s:7:"version";i:3;}

Full message:
Finished execution of Bounces fetcher with result: Failure, Error message: Could not connect to MailStore for [the email address used for bounce processing]
Error message:

Required parameter not passed: "refresh_token"

Is this a problem with the oauth-client extension, or have I mis-set a setting somewhere in CiviCRM?


texts:
CiviCRM 4.7.17 on Drupal 7, using Paypal Payment Pro processor. When clicking on a membership and canceling automatic renewal/payments, it gives the error

  Error Cancelling Contribution - The Contribution Could not be Cancelled

If we keep "Notify Paypal Pro" selected on the following screen we receive the error, if we de-select it the error does not occur, and the recurring contribution is cancelled.

How could we begin to debug this? Is there special set up required to have CiviCRM able to manage our Paypal recurring payment profiles?


texts: Is there a Vanilla Twitter Bootstrap 3 Wordpress theme that works well with CiviCRM?

texts:
I'm taking an existing static website that was created with Twitter Bootstrap 3 with no modifications to the framework and trying to shoehorn it into Wordpress with CiviCRM.

Makes use of the following examples from the bootstrap-3.0.3 code base:

navbar-fixed-top (all pages)
carousel
offcanvas
jumbo-tron
grid

I found the following theme for $38 dollars, but it seems a little lacking in features.


texts:
I am moving my organization's website over from Drupal 7 to Wordpress, and along with that I need to connect our existing CiviCRM install with the new Wordpress install. I just have a few concerns before I start anything:

Can I just install CiviCRM for WP and hook it up to the existing database? Is there a special procedure that I will need to go through to connect our existing database with WP? Is there any risk to the data moving over this way?

Thanks!


texts: Webform 'previous page' button gives 500 server error

texts:
W7 Pro SP1
Firefox v.42, IE11, Chrome 46

The version of CiviCRM I’m using has a multipage Webform that I’m having problems with.

Everything works fine as long as I don’t try to use the form’s ‘previous page’ button, but if I do I get an HTTP 500 Server Error

With Firefox I initially get a ‘white screen of death’ (an empty browser – address field, bookmarks bar etc all there, but no content). If I then try the browser’s back button I get a “Document Expired” error message & if I keep clicking the browser’s back button I get back to the form’s ‘Begin’ page

I’ve tried it in Chrome & I get a “Server error 500” message & in IE I get ”HTTP 500 Internal Server Error”

My understanding is that a “500server error” is a very general error message, just saying that there’s a problem with the/a server....so, not that much help really!

My regional branch of the organisation is run by/hosted by another organisation, so to access the database I’m going via the host orgs server as well as the server at the parent organisation (Healthwatch England), which is where the database is & I don’t have admin access to either of them.

After searching for info on this I’ve tried increasing the cache size in firefox, but it hasn’t helped. I’m not sure what else to try.....has anyone come across anything like this before & resolved it?

Any help much appreciated!


texts:
User is adding a new email. Call to civicrm_pre detects a problem that requires that the update not happen. It hasn't actually happened by the time civicrm_post or post_save_civicrm_email is called. The update actually happens after post_save is called.

How do I abort the update?


texts: Is it possible to restrict event registration to members?

texts:
I've been trying to figure out how to set up events where only members can register. Is this possible?

What I'm looking for is the ability to:

specify one or more memberships that can register for an event, and
limit registration to those members.
require authentication as part
of registration for events where membership is required OR allow
membership signup during registration
not require authentication if
the event registration is not limited to members only.

I'm running CiviCRM on Drupal, and I know I could set the Drupal permission for CiviEvent: register for events so that only logged-in users with a given role could register. I would then sync CiviCRM memberships with Drupal roles. But I only want to limit some events, not all, so this approach won't work.

Also, if I had multiple roles (one per membership), those roles would all need the same Register permission, meaning any member could register for any event, even those events should be limited to people holding a specific membership.

I also know that I could publish details of member-only events to just those members. But those members could share the registration URL with non-members, who could then register.

Any suggestions?


texts: How to make a single form that works with an individual, and organisation and their Relationship in Wordpress

texts:
Most of the Memberships for my organisation reside with Organisations which are then represented by a named individual.

Is it possible using CiviCRM in Wordpress to design a website form which collects the Individual data such as first name & last name AND Organisation data such as Organisation Name and then ties the two together by setting the Relationship as Employer<-->Employee.

There seem to be some solutions available for Drupal users such as Webform Integration or CiviRelate.

Any ideas on how one might do this in wordpress?


texts: Can not add both Individual and Organisation to case

texts:
When a case is created one contact is added. But later, when I want to add another contact, sometimes that is not possible. I've figured out, I think, that if the first contact is of one type, Individual, say, and the other one is an Organization, that is not possible because the search dialouge limits to the previous type.

Furthermore, if I add one Individual and one Organization when I create the case, it seems to be no problem.

I wonder why? And I'm fairly sure that it has been possible since we have cases in our database that have this.

Or is there a way to do this anyway?


texts: How do I get wordpress and Civicrm membership synced?

texts:
I have tried multiple times to be able to get Wordpress and Civicrm to be able to sync up when members register. When I go to CiviMember Role Synchronize it redirects to the page for my blog.

What can I do to be able to get Civicrm members and Wordpress users to be able to register and login at the same time

Thank you for your help


texts:
I'm running CiviCRM v5.32.2 and the CiviCRM WP REST API v0.1 plugin in Wordpress v5.6.
In Wordpress Site Health Status i get this warning:
An active PHP session was detected

A PHP session was created by a session_start() function call. This interferes with REST API and loopback requests. The session should be closed by session_write_close() before making any HTTP requests.

Do you know if this error is related to CiviCRM, and what to do about it?


texts: Membership signup/renewal erroneously reports missing fields after upgrade to 4.7.3

texts:
Recently upraded to CiviCRM 4.7.3 on this site: http://oaem.ca/

After the upgrade, the membership signup and renewal process is broken in the following way.

The signup/renewal form at https://oaem.ca/civicrm/?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=1 now includes an additional "Organization Details" form, which is not set in any profile, and which is not wanted. It appears to conflict with the membership data that I want to collect, and which is collected using a custom contribution profile.

Filling in both forms appears to work at first, but when the user reaches the confirmation page, they see this report:

Please correct the following errors in the form fields below:
Organization Name is a required field.
Phone (Main) is a required field.
Email (Main) is a required field.
Street Address is a required field.
City is a required field.
Postal Code is a required field.
Country is a required field.
State/Province is a required field.

So the additional data on the 1st screen does not get passed to the final screen.

This persists even if I switch off the the custom profile form in an attempt to use the 'default' form which is being added.

This is what the screen used to look like (compare with current page)

Any suggestions as to what is wrong and how to fix it very gratefully received.


texts: How to assign a Contribution to a different contact or otherwise have the receipt go to a different contact

texts:
A contribution is made by Contact A, but they require the receipt to go to Contact B. What other option is there other than deleting the Contribution record and creating a new one for Contact B.

I have re-read about Soft Credit but see nothing that offers this functionality.

With access to the DB we can update the record (and associated Activities) directly but not ideal.

Is there any 'transfer Contribution' type feature or extension anyone has come across? There was an "I am making one" comment here


texts:
I am looking at how we implemented Family Memberships in our 3 year old instance of CiviCRM.  It's never worked very well for us, but I am not sure if it's not configured right, we should use another approach or what.  Our use case is a professional membership society where sometimes both spouses are members of the profession.  They don't think of one or the other of them as the "primary" member.  They are equals.  So each needs the ability to renew their Family Membership, and when that happens the other spouse's membership should be marked as renewed as well.

Currently we have it set up where membership is granted via related contacts.  One is marked as Primary in the database. We have troubles when the non-Primary member wants to do the renewal.  It rarely "just works", some editing is necessary.

It seems the alternative is to use Household memberships, and mark each of them as permissioned to manage the Household membership.  Will this solve our problem?

Advantages and disadvantages of each approach?

Thanks


texts: How to use Amazon Simple Email Service for only verified email sender addresses

texts:
I have a site running SES for outgoing mail. It works just fine to send out mass email from the domain, but it fails every time I try to share a PCP from a non verified email.

For example if I create a PCP from the main account on civicrm, and I use the SES verified email address, the PCP sharing works just fine.

On the other hand if I create a PCP from my personal email address and try to share the PCP, then the send fails (Amazon SES does not accept unverified email senders).

Is there a way to use mail() instead of AWS SES for this? or a way to allow for the domain to be validated?


texts: How Do I Display a Contact's Profile in a Joomla Module Position and also a standard page display?

texts:
I am looking to find out how to display a single contact profile with their name, address and other fields in Joomla please. I have Googled, looked at the Civi CRM docs, looked at search criterias, i've been into the profile display administration and I just can't find a way of grabbing the contact by name and then setting this to a Joomla menu link.
I may also need to display it in a Gantry module position too so info on how to do it this way would be extremely helpful too.
Thanks incredibly!


texts: How to make a membership renewal form pre-filled with last year's values?

texts:
I'm looking for some implementation advice (using Joomla 3.4 and CiviCRM 4.6.9).

A client has a price set in place for membership that includes several standard membership levels, plus a few extra optional add-on services members can select. That works well for signups. But for renewals we'd like to be able to remind them what they paid the previous year, which they could then update or accept as given.

My first thoughts on how to do this:

Have a membership renewal page that pre-fills and pre-selects values based on the selections they made the previous year? I don't see a way to set up a membership contribution page in such a way that would do this (can't call up contribution info in a profile for the contribution page?). Could I do this with a hook (which one?)? Or would I need to use the API?
I know 4.6.9 has new invoicing capabilities, could that be used in some way to pre-set the contribution form selection? Or could I set up a process flow whereby we manually create the invoice based on values from last year, and send them an invoice that has a link to a contribution page where they can pay the amount due shown on the invoice?

Any advice would be appreciated -- anyone implemented anything like this before?


texts: Active Event Type not appearing in CiviRules

texts:
Drupal 7.67, Civi 5.13.5

I'm currently adding some CiviRules to automatically tag users based on what event they sign up to / attend. However one of the event types isn't showing up in the CiviRule dropdown box on the "Conditions" screen. This event is marked as active. I haven't yet added any other Conditions for this CiviRule.

Any clue how to fix this?

Screenshots below -

My list of Event Types. I want to have a CiviRule that adds a tag when people attend a "Youth Event".

"Youth" doesn't appear in the drop-down:

Or when I search for it:

I haven't added any other Conditions for this CiviRule.

Thanks in advance for your help!


texts: Can't create a 2nd membership type within the same membership organisation

texts:
When we started with Civi 4.2, Membership Types within the same organisation were set to "upsell", ie if you had Membership Type X (OrgY) and opted for Membership Type Z (OrgY) then your single row of membership would change from type X to type Z.

This was most confusing in our use-case and we were delighted to discover that this default behaviour was no longer present when we upgraded to 4.5 (or 4.6, can't be exact here, sorry.)

I am virtually certain that we have observed non-upsell behaviour, ie, purchasing membership Type Z (Org Y) resulted in two lines of membership, type X and type Z.

However, at some indeterminate point in the last 12 months, this became no longer the case.

Now, it is simply not possible for a Contact to purchase a 2nd membership type within the same membership organisation.

In our case, it appears that if a Contact has a membership type X and then goes to create a new membership type Z within the same membership organisation Y, then Civi and Auth.net (our payment provider) will process everything correctly (online confirmation screens, payments correctly setup)... but NOT in the Membership area. A new membership Z will not be created, nor will the existing membership X be updated.

Am I missing something fundamental here? Or has a recent update in 4.6 confounded things?

We're on Drupal 7.43, Civi 4.6.14.

Thanks for your assistance!


texts: Unable to add membership types dropdown field to registration form

texts: I have created a Registration form using "Profiles", however when I add the membership types I get this message on the frontend: "Profile search, view and edit are not supported for Profiles which include fields for more than one record type.". The field is type "Membership", the other fields are type "Contact" (as seen on the screenshoot) What am I missing, what is the approach for adding a membership type dropdown?


texts: CiviCRM + Wordpress + Contact 7, how to get it to work

texts:
I am trying to make sense of this WP plugin:
https://wordpress.org/plugins/contact-form-7-civicrm-integration/

I have installed it, set the API details, and am now setting it up. The emails get sent, but there is no addition to civicrm.
Right now the civicrm options of contact 7 via this plugin are:

Entity: Contact
Action: create
(all good here, I guess)

Additional parameters (the standard ones given): contact_type=Individual&source=Wordpress
What if I wanted to add this user to a specific group too? I'm not sure about what to write.

In any case, by filling the form an email gets sent, but no addition to CiviCRM is made...! This would be quite important to me, so if anyone had any idea or has any experience with contact 7, any help would be really, really appreciated.

On a secondary note: how do I know the standard names of all "fields"? In the plugin page they give "first_name" and "last_name" as samples, but what if I want to add a phone number and/or email? What standard CiviCRM names should I use? I have not found a list yet, and I've searched for a while...

If anyone had any idea, it would be awesome :) thank you in advance, and sorry for being a bit noobish.


texts: Installing CiviCRM 4.6.11 on a Joomla 3.4.8

texts:
I am trying to install CiviCRM 4.6.11 on a Joomla 3.4.8 website which I downloaded from the Joomla Extensions Directory. When I install it nothing happens.  I dont see any error message or a success message.  Joomla normally displays an error message when an installation is not successful. The website is on localhost.

I would appreciate your guidance.


texts: Services from core contrib modules missing!!!! "The service xxxx has a dependency on a non-existent service xxx. " (with solution)

texts:
In this case it was webform. Webform services wouldn't load, I couldn't clear cache, clearing db caches manually wouldn't work. All I got was:

[Thu May 07 14:37:33.174757 2020] [php7:notice] [pid 2795] [client x.x.x.x:25119] Symfony\\Component\\DependencyInjection\\Exception\\ServiceNotFoundException: The service "webform_scheduled_email.manager" has a dependency on a non-existent service "webform.token_manager". in /var/www/html/www.actionfund.org/vendor/symfony/dependency-injection/Compiler/CheckExceptionOnInvalidReferenceBehaviorPass.php on line 31 #0 /var/www/html/www.actionfund.org/vendor/symfony/dependency-injection/Compiler/AbstractRecursivePass.php(60): Symfony\\Component\\DependencyInjection\\Compiler\\CheckExceptionOnInvalidReferenceBehaviorPass->processValue(Object(Symfony\\Component\\DependencyInjection\\Reference), false)\n#1 /var/www/html/www.actionfund.org/vendor/symfony/dependency-injection/Compiler/CheckExceptionOnInvalidReferenceBehaviorPass.php(28): Symfony\\Component\\DependencyInjection\\Compiler\\AbstractRecursivePass->processValue(Array, false)\n#2 /var/www/html/www.actionfund.org/vendor/symfony/dependency-injection/Compiler/AbstractRecursivePass.php(67): Symfony\\Component\\DependencyInjection\\Compiler\\CheckExceptionOnInvalidReferenceBehaviorPass->processValue(Array)\n#3 /var/www/html/www.actionfund.org/vendor/symfony/dependency-injection/Compiler/CheckExceptionOnInvalidReferenceBehaviorPass.php(28): Symfony\\Component\\DependencyInjection\\Compiler\\AbstractRecursivePass->processValue(Object(Symfony\\Component\\DependencyInjection\\Definition), true)\n#4 /var/www/html/www.actionfund.org/vendor/symfony/dependency-injection/Compiler/AbstractRecursivePass.php(60): Symfony\\Component\\DependencyInjection\\Compiler\\CheckExceptionOnInvalidReferenceBehaviorPass->processValue(Object(Symfony\\Component\\DependencyInjection\\Definition), true)\n#5 /var/www/html/www.actionfund.org/vendor/symfony/dependency-injection/Compiler/CheckExceptionOnInvalidReferenceBehaviorPass.php(28): Symfony\\Component\\DependencyInjection\\Compiler\\AbstractRecursivePass->processValue(Array, true)\n#6 /var/www/html/www.actionfund.org/vendor/symfony/dependency-injection/Compiler/AbstractRecursivePass.php(39): Symfony\\Component\\DependencyInjection\\Compiler\\CheckExceptionOnInvalidReferenceBehaviorPass->processValue(Array, true)\n#7 /var/www/html/www.actionfund.org/vendor/symfony/dependency-injection/Compiler/Compiler.php(140): Symfony\\Component\\DependencyInjection\\Compiler\\AbstractRecursivePass->process(Object(Drupal\\Core\\DependencyInjection\\ContainerBuilder))\n#8 /var/www/html/www.actionfund.org/vendor/symfony/dependency-injection/ContainerBuilder.php(789): Symfony\\Component\\DependencyInjection\\Compiler\\Compiler->compile(Object(Drupal\\Core\\DependencyInjection\\ContainerBuilder))\n#9 /var/www/html/www.actionfund.org/web/core/lib/Drupal/Core/DrupalKernel.php(1321): Symfony\\Component\\DependencyInjection\\ContainerBuilder->compile()\n#10 /var/www/html/www.actionfund.org/web/core/lib/Drupal/Core/DrupalKernel.php(902): Drupal\\Core\\DrupalKernel->compileContainer()\n#11 /var/www/html/www.actionfund.org/web/core/lib/Drupal/Core/DrupalKernel.php(477): Drupal\\Core\\DrupalKernel->initializeContainer()\n#12 /var/www/html/www.actionfund.org/web/core/lib/Drupal/Core/DrupalKernel.php(693): Drupal\\Core\\DrupalKernel->boot()\n#13 /var/www/html/www.actionfund.org/web/index.php(19): Drupal\\Core\\DrupalKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request))\n#14 {main}

Reinstall drupal wouldn't fix it (once custom modules were in).
Deleting vendor and composer install wouldn't fix it.
Reloading DB had no effect.
None of the usual tricks worked.
I was pulling my hair out.


texts: 403 when I run most reports as super admin

texts:
I have a problem with my civiCRM installation where I am now unable to run most reports. As super admin I can browse to the report config page where I can select what I display and set filters etc. I then hit the "refresh report: button and get a 403.

I do still have a couple of reports working on my dashboard, but others that don't work there (I get a message on the dashboard that I have tried to access a report that does not exist).

I'm perplexed my this.I can't find any sort of file permissions on the server that could be the problem or any permissions in drupal or civicrm that could be the issue. Maybe I'm not looking in the right spot though...

I don't think there are any other users that can run these reports either.


texts: Commas displayed instead of selected responses from a multi-select field on Confirmation page for CiviEvent registration

texts:
When viewing the confirmation page of a CiviEvent registration form, the options selected in two different multiselect fields do not appear. Instead, for each field a series of commas equivalent to the number of options available in the field appear. This happens if I select any fewer than the full number of options available for the field.

The responses to other fields on the same form are fine, including those related to a couple of radio-button select fields.

In the attached image, Job Title and Dietary Restriction fields are examples of the issue.

Personal pronoun and several other fields displayed in the image are from fields using radio-button selections.

What could be causing this?

I've seen this Q&A but I think my concern is different and I'm on a later version of CiviCRM (5.13).
https://issues.civicrm.org/jira/browse/CRM-17129


texts: Difficulties generating an entity's DAO and SQL for a new extension

texts:
I have been trying to generate DAO and SQL files for an entity I created with civix generate:entity ... according to the documentation ("Add a new entity" - 4.d.).

Using the latest civicrm-core clone (latest commit e637260) I:

ran composer install on the root (civiroot);
verified that the vendor folder has the same packages that come along with, for example, CiviCRM 4.7.20 for Drupal 7.x (sites/all/modules/civicrm/vendor);
copied the new entity's schema to the xml/schema folder;
altered the Schema.xml itself to include this entity.

However, after running bash bin/setup.sh -g or php xml/GenCode.php this comes up:

  Fatal error: require_once(): Failed opening required 'Log.php'

I.e. <root>/CRM/Core/Config.php is expecting:

require_once 'Log.php';
require_once 'Mail.php';

I searched for a while and I could not find these files, so I just thought of trying it out without these lines from Config.php, but once I rerun I got:

  Notice: Use of undefined constant PEAR_ERROR_CALLBACK - assumed 'PEAR_ERROR_CALLBACK' in <root>/CRM/Core/TemporaryErrorScope.php on line 49

  Notice:  Undefined index: _PEAR_default_error_mode
  in <root>/CRM/Core/TemporaryErrorScope.php on line 74

  Notice:  Undefined index: _PEAR_default_error_options
  in <root>/CRM/Core/TemporaryErrorScope.php on line 75

  Warning:  require_once(PEAR/ErrorStack.php): failed to open
  stream: No such file or directory in <root>/CRM/Core/Error.php on line 36

  Fatal error:  require_once(): Failed opening required
  'PEAR/ErrorStack.php' (include_path='.:<root>:<root>/packages:<root>/vendor/tecnickcom:<root>/vendor/phpseclib/phpseclib/phpseclib:<root>/vendor/pear/pear_exception:<root>/vendor/pear/auth_sasl:<root>/vendor/pear/validate_finance_creditcard:.:../packages:..')
  in /CRM/Core/Error.php on line 36

I did find a PEAR folder but it is in <root>/vendor/pear/pear_exception/PEAR, without any ErrorStack.php file.

I also found a couple of related questions in here:

How to automatically generate DAO classes for my DB tables
How do I add a new table to my extension?

In the last one, I understand that people seem to run the code generator without such problems.

I apologize the long question, TLDR;

what am I missing? What does GenCode.php need in order to run properly?
is there another way to generate DAO and SQL files for new entities?


texts: I am importing 350 contacts into Civi. This post says that you should always include an import identifier. I don't have admin access so I cannot create a custom field set. I was going to identify the contacts by tagging them all. Alternatively, Civi includes a contact source field. Could I include a value for contact source in the CSV file? I will also tag the imports.


texts:
When I go through the Create new A/B test workflow, it presents me with a traditional mailing interface, even though I have Mosaico installed.

I'm pretty sure that means A/B testing is not possible with Mosaico but wanted to check for confirmation.


texts: Changing the name of a payment processor on the front end

texts: Would it be possible to change the name of a payment processor in the event registration screen? When a new attendee is registering for event under Payment Options > Payment Method they see the radio buttons for the available payment processors such as Paypal or Stripe. I want to change the text for the Stripe option to be Credit Card. Our user base doesn't know what Stripe is and it would helpful if it was more general than the actual name of the credit card processor. Any help would be appreciated.


texts: After upgrade, I can't generate pdf letters for printing. How can I enable wkhtmlpdf to handle pdf conversion?

texts:
Just upgraded CiviCRM. Running 4.7.29 on D7.56. Have installed wkhtmltopdf at /usr/local/bin/wkhtmltopdf
I have placed exactly that file path into the settings in the admin for the "alternate" pdf generator. Doesn't seem to work. Get fatal error when I try to generate pdfs for printing. Here is the alert message:

Fatal error: Call to undefined method CRM_Core_SelectValues::documentFormat() in /home/[site]/public_html/sites/all/modules/civicrm/CRM/Contact/Form/Task/PDFLetterCommon.php on line 186

Don't think wkhtmlpdf is executing. Is there a test to see if wkhtmlpdf is handling the conversion, as opposed to dompdf? Any suggestions?


texts: CiviCRM Spark fees, database migration/export and cancellation

texts:
I need to cancel my monhtly fee as we have transfered to our server.
Can you tell me how to do this please.
I have tried to log in but says I have worng info to log in.
Also would like to know f the 18.48 monthly fee includes HST or not


texts: How do I automatically add a user to a Backdrop (or Drupal) role?

texts: I figured out how to automatically add a newly-created user to a group when they fill out a contribution or event page, but I want to add them to a Backdrop role as well.  How can I do that?


texts: Mosaico template editing not loading consistently

texts: I am using CiviCRM 4.6.28 and Joomla 3.7.2 with Mosaico 1.0 enabled. I have created a new template and edited it but am finding that the editing page only loads about 50% or less of the time. When it does not load I get a red screen (the Mosaico background colour) and the template blocks do not load. There seems to be not predictable reason for this. The site is hosted by Siteground and they have checked the server for problems. has anyone else had loading problems?


texts:
I have a strange Views problem. I'm on Drupal 7 and CiviCRM 5.4.0. I produced a View of case activities by showing several custom fields, one custom field called "placement". The placement field has options: None, A, B, C.

On the most recent case activities called Update, the placement field is B. However, when I look at Views, the placement field is C. The Views has current revision set to TRUE, deleted case FALSE, deleted activities FALSE, and deleted contacts FALSE.

If I go to cases and change the custom placement field to A, then Views show B. Basically, the case and Views are not matching. In fact, the Views page shows the option after what is selected in cases. Is this a recent bug?


texts:
I'm running CiviCRM 4.5.5, Having recently upgraded to WordPress 4.9.5 and PHP 5.6 (mailing was flawless just prior to this). Latest scheduled mailing failed to initiate, and a URL method test of cron.php generated the following error:

Parse error: syntax error, unexpected 'clone' (T_CLONE), expecting '(' in /.../wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(207) : eval()'d code on line 1

Is there any simple way to fix this? (After the time it took to set CiviCRM up several years ago, I'm reluctant to upgrade--I'm a volunteer, not a tech.)


texts: Event Calendar does not show up on civi 4.7.7

texts:
I'm trying to use the extension Event Calendar (developer branch as advised here: Problem with Event Calendar extension after upgrade to 4.7.3) however the Calendar does not show up, the "Event Calendar Settings" is fine.
The master branch works fine on 4.6.11. Has anyone been using it on 4.7.x?
The CMS is Wordpress.


texts:
I've installed the plugin successfully, but when I go visit the CiviCRM page in the backend, I get the following error:

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

Fatal error: require_once(): Failed opening required 'CRM/Core/ClassLoader.php' (include_path='.:/home/capitalevents/public_html/wp-content/plugins/civicrm/civicrm/:/home/capitalevents/public_html/wp-content/plugins/civicrm/civicrm//packages:.:/usr/local/php56/pear') in /home/capitaleventscom/public_html/wp-content/uploads/civicrm/civicrm.settings.php on line 462

I've tried but couldn't figure out anything. Any help will greatly be appreciated.


texts: Set drupal taxonomy terms in the civicrm custom option fields

texts:
I have created a civicrm custom dropdown field in Drupal 7.  I have a excel spreadsheet contains some data in three columns. To which i need to import into civicrm and then the first column should be display in the custom dropdown field.

So, i have two opinions at this stage

1) I can create a custom table for Civicrm and then import the values from spreadsheet. OR

2) I can create taxonomies terms having 3 fields in Drupal.

After, that it should show it's values in the civicrm's custom dropdown field.

But i couldn't able to find out the correct way to implement any of the approaches. Please suggest me the steps to implement either of those approaches or any new approach which will be quite easy to implement.


texts: Joomla! log in error on http vs http://www

texts:
I've got a client with a bizarre Joomla/CiviCRM issue.

When the client is logged in at http://www.site.com, when they perform certain CiviCRM actions, they are redirected to http://site.com, which they are not logged in at. However, when they log in a second time at http://site.com they are able to function normally. However, if they log out at http://site.com, they are still logged in at http://www.site.com

Confused? The kicker is that I updated the CiviCRM baseurl to be http://www.site.com. But even clearing caches hasn't helped that bleed through.

What is happening here?

Is the http://www vs http:// login distinction a Joomla! only one?
Is there anything else I need to do to clear CiviCRM's caches regarding stored http://site.com addresses?
I deleted civicrm_cache session entries, but they seemingly aren't being regenerated. Any ideas why?


texts: New EU-DSGVO 2018 - Is a new agreement necessary?

texts:
Dear CiviCRM beta team,

we as the NGO "Wissenschaftsladen hannover e.V" would like to know whether we need a new agreement concerning the new DSGVO (Datenschutzgrundverordnung).
According to the new privacy policy, which will come into effect at may 25th 2018, a lot of laws will change and therefore our question revolves around future changes in terms of our general agreement and different new things we should consider.
An answer in german would be fine too / Eine Antwort auf deutsch wäre auch ok.

Yours faithfully, Wissenschaftsladen Hannover e.V
Denis Matthies


texts: Mailchimp extension terminology: audiences and lists

texts:
I'm slightly confused by the mailchimp extension. It feels like maybe the extension, the documentation and mailchimp have become out of sync.
Looking at the group settings (civicrm/group?reset=1&action=update&id=N) page, I see four options in the Mailchimp settings box:

Mailchimp list
Mailchimp grouping
Mailchimp group
Are subscriber able to update this grouping from mailchimp?

Looking at mailchimp_civicrm_buildForm(), these form elements should be replaced by terms that sound like the documentation below...

Choose the integration option, called "Membership Sync: Contacts in this group should be subscribed to a Mailchimp List" then choose your list name.
Ensure the tickbox is ticked that says "Ensure lists's webhook settings are correct".

But that is not happening for existing groups. It is happening for a new groups.
Is there a way through?!


texts: Civimail is not sending scheduled mailings, could it be Cronjob syntax or Bluehost?

texts:
Relevant set-up information:

Hosting: Bluehost Shared Hosting
CMS: WordPress
CiviCRM version: 5.25.0

Here's what works:

Sending email from via "Contacts > New Mail"
Sending a test mail from "Settings - Outbound Mail"
Sending a test mail from a mailing in CiviMail under "Define Mailing" from the Preview pane

Here's what doesn't work:

Sending a scheduled mail via CiviMail's "Review and Schedule", neither in "Send Immediately" nor "Send at:";
Going to Schedule Jobs and hitting Execute Now for Sending Mail;

Now I'm told by the system that Cron jobs are not set up, though I have put one in CPANEL.
Here is my CRON command that is running every 5 minutes:
wget -O - -q -t 1 'https://<domain>/wp-content/plugins/civicrm/civicrm/bin/cron.php?name=<username>&pass=<password>&key=<sitekey>&job=execute'

The "username" is an Administrator.
Tech support says my Cron jobs are running.
"Scheduled Jobs Log> Send Scheduled Mailings" states that jobs are getting kicked off
Entity: job Action: process_mailing
Summary
Finished execution of "Send Scheduled Mailings" with result: Success (a:1:{s:9:"processed";i:0;})
Details

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

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

Despite all this, no mails are showing up in the test groups inboxes.
Is it my Cron job settings?  If so, has anyone been able to set up cron jobs effectively in CPANEL for CiviCRM?


texts: Is there a way to save different reports? ie. the fields wanted to export? so you don't have to enter those in every single time you do an export?


texts:
After finding my bounce messages were seemingly disappearing into the ether when sending mail with mail(), I'm trying to configure CiviCRM to send using G Suite's SMTP relay.

I've configured the SMTP settings in Administer > System Settings > Outbound E-mail and the test button on that screen sends an e-mail that is successfully delivered, seemingly correctly through G Suite as indicated by this line in the e-mail headers:

Received: from example.net ([192.0.2.1]) by smtp-relay.gmail.com with ESMTP id g185sm57996wmg.25.2020.05.20.09.26.24 for <somnolentsurfer@example.net>; Wed, 20 May 2020 09:26:24 -0700 (PDT)

When I try and send an actual mailing using CiviMail, though, I get a 100% bounce rate, all with a bounce of type 'syntax'. In the bounces report I can see bounce reasons given in the format:

Failed to set sender: bounces+b.42.989.322af0d715439c1d@example.net [SMTP: Invalid response code received from SMTP server while sending email. This is often caused by a misconfiguration in Outbound Email settings. Please verify the settings at

That message is obviously truncated. If I log in to the bounce handling account there don't seem to be any messages there that might show me the full error, either in the inbox, or in INBOX/CiviMail/ignored or INBOX/CiviMail/processed. Is there any way to see the rest of the message so I can diagnose what's going on?


texts: Long List of CiviDiscount Codes Needs Management

texts:
How do you manage a long list (100+) of CiviDiscount codes?

We hold an annual conference and make about 70 codes per conference - so the list adds up.

Can I remove old discount codes without affecting contribution records? seems to be possible, although deleting them seems to be not the best practice?

Ideas:

How difficult would it be to implement a quick filter at the top that toggles the view to show active and inactive (or both) codes?

Or, what about a quick filter for 'Event' the codes are attached to? (or something like that?)

Alternatively - could a Drupal view handle this? Thanks!


texts: Which tokens are available for activity?

texts:
I want to send a reminder to the assignee of an activity and I want to add in the message the phone number (preventing the assignee to log into CRM and spare clicks).
I found these tokens from here:
{activity.activity_id}
{activity.subject}
{activity.details}
{activity.activity_date_time}

and they work properly with CiviRules but they are not enough. It would be great to have extra tokens with e-mail, phone number and a few others.
Are they available right now or could they be available? If needed we could write an extension.


texts: Initialization Error After Backing Up Wordpress

texts:
Earlier today I did a backup and restore on a Wordpress website. After the restore was successful, I noticed I could no longer access or edit my posts/pages in the Wordpress Dashboard. And I noticed CiviCRM throwing this error:

Initialization Error

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

[code] => -24
[message] => DB Error: connect failed
[mode] => 16
[debug_info] => [nativecode=Access denied for user 'user'@'localhost' (using password: YES)]
[type] => DB_Error
[user_info] => [nativecode=Access denied for user 'user'@'localhost' (using password: YES)]
[to_string] => [db_error: message="DB Error: connect failed" code=-24 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info=" [nativecode=Access denied for user 'user'@'localhost' (using password: YES)]"]
)

I've since tried reverting to the website instance that existed prior to the restore, when Civi was still working perfectly, and the same error still exists. I've disabled Civi and have regained the ability to edit posts/pages, but Civi remains broken.


texts:
I created a new CiviVolunteer project and have several successful sign-ups, but one volunteer reported getting this error:

"API permission check failed for VolunteerUtil/getbeneficiaries call; insufficient permission: require edit own volunteer projects"

The successful sign-ups are a mix of named users and anonymous users. The failed sign-up is an anonymous user. This person has successfully signed up for previous projects. I have not changed permission settings recently and have not experienced this error on earlier projects.

I didn't have any issues creating or editing it as admin, but I noticed I get this same error as admin on both the Wordpress and Drupal sandboxes by simply selecting "Manage Volunteer Projects":

https://wpmaster.demo.civicrm.org/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fvol%2F#/volunteer/manage

https://dmaster.demo.civicrm.org/civicrm/vol/#/volunteer/manage

My system:
Wordpress 5.2.3
CiviCRM 5.18.1
CiviVolunteer 4.7.31-2.3.1
PHP 7.2.21
MySQL 5.7.23


texts: CiviEvent - if registration date is is in the past, shouldn't be Online registration enabled?

texts: These two doesn't seem to play well together. Mean, both options are mutually exclusive: we don't want Online Registration enabled if Registration End Date is in the past, do we? Even if (not sure) by "Registration End Date" we mean an offline registration end date.


texts: I am to install CiviCRM on Windows 10 with WAMP

texts:
I have been trying to setup CiviCRM on Windows 10,  But I am not able to install "bin/civi-download-tools" on it. Even I have installed and enabled Linux subsystem tools on windows.

Please guide me as I am to complete my test.


texts: Mail editor defaulting to Ckeditor and text wrap issue

texts:
I have a Drupal multisite build and after upgrading to civi 4.6.10 noticed the default text editor for bulk mailings defaults to CKEditor...despite my settings in administor/customise data and screens/display preferences being set to TinyMCE.

If I send individual emails out the editor is TinnyMCE but for bulk mailings it is CKEditor? Despite trying all options in display preferences the bulk email adeitor stays as CKEditor.

Now, even though the template looks ok in mailings, when i send a bulk email the text stretches to either the full page width or the width of the paragraph (whichever is shortest) even if the text is placed inside a table. Using the same template in invididual emails the formatting is correct.

ie. I have a table cell that is set as say 200 px wide if i add text and send as an individual email it is fine but when I send as bulk email the text forces the table cell to stretch to the width of the text or page width.

I've tried to give an example of what it looks like below;

In individual emails with TinyMCE

Lorem ipsum dolor sit amet,
consectetur adipiscing elit,
sed do eiusmod tempor
incididunt ut labore et
dolore magna aliqua. Ut enim
ad minim veniam, quis
nostrud exercitation ullamco
laboris nisi ut aliquip ex ea
commodo consequat.

The same template in bulk emails stretches to full page width looking something like this

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

I am completely baffled by this and any help/advise would be welcome.

Cheers
Robbie


texts: How to create new custom event page in the admin area

texts:
I have set the "Custom PHP Directory" as [civicrm.files]/custom_php/
Under custom_php/ I have created the folders CRM -> Event -> Page -> SessionTypes.php
I have added the menu as a hook under Events (in the admin area) which points to /wp-admin/admin.php?page=CiviCRM&q=civicrm/sessiontypes but the page does not get hit.
What am I missing? Below is the content of the SessionTypes.php

require_once 'CRM/Core/Page.php';
class CRM_Event_Page_SessionTypes extends CRM_Core_Page {
  function run() {
    die('innn');
    parent::run();
  }
}


texts: Button for Cleanup Caches only clickable in top part

texts:
This is a css question. On the Administer - System Settings - Cleanup Caches page. In a stock install on drupal 7 or 8 with bartik, or even garland like dmaster.demo.civicrm.org, you can see a lightly shaded horizontal bar behind the buttons that's only a few pixels high that's coming from the <div> but technically has height 0. Somehow though it has at least some height visually, and the button still manages to be fully clickable within its whole area.
On another theme, Tara, it's behaving as if the clickable area of the button is only the few pixels that are visible in the zero-height div.
Is this a problem with Tara or is the stock civi css for this div/button weird and just happens to work in most places? In any case the shaded div looks odd I've just never noticed it before.
I can fix it by giving the outer div.crm-block an inline-block style, which looks a little better. Also part of the problem might be there's no actual text or fields in the <form> on this page which is unusual.


texts: Filtering search results to see only the most recent contribution by each contact

texts: How do I sort contributions in our database by the most recent contribution date? When I try to search this on the database, it brings up all contributions, not just the most recent and I want to target specific members who have not donated recently. Thanks!


texts: Available Volunteer Opportunities does not filter out filled opportunities

texts:
The opportunities screen does not filter out opportunities that have been filled.

My URL:
https://mysite/drupal/civicrm/vol/#/volunteer/opportunities?project=6&dest=event&hideSearch=1

"CiviVolunteer allows volunteers to sign themselves up for opportunities that you've defined. Each time someone signs up, CiviVolunteer creates an assignment. It also makes sure to offer only the opportunites which have not yet reached the desired number of assignments (so that you don't overbook anything)."

Also despite using project number all projects appear? Should it not be limited to project 6?


texts: "Contact Show fields" does not show the street address in autocomplete (civicrm_webform)

texts: I am trying to show the street field but it doesn't appear in the selector. The field is selected but it doesn't work, Thanks.


texts: What is the best way to limit Membership Types to a custom organisation type. i.e. If the organisation is of type x, then can use membership types A, B but not C.


texts: Wrong dates and type on membership email receipts

texts:
We recently set up a new CiviCRM install (Drupal 7, CiviCRM 4.7.3, hosted on Bluehost). Most everything is fine, but the email receipts sometimes show the wrong dates and membership type. The correct membership dates and type are being stored in CiviCRM.

Some contact and membership data has been imported previously. User H C renewed via the membership page, paid via PayPal Standard. Their membership shows correct since/start/stop dates (since July 30th 2008, start February 29th 2016, stop February 28th 2017).

The receipt emailed to the member shows incorrect dates though: membership start date October 1st 2011, membership end date October 1st 2012. It also says the membership type is Registered when it should actually say Senior.

The contact's membership page shows no other memberships. What might do this? How can I resolve it?

The issue seems to affect memberships inconsistently about half the time.

The issue only affects renewing members.


texts: How to add a drop down with option groups and option values?

texts:
I planning to add a drop down button with option groups and option values.

This is my code

$form->add('select', 'a', ts('a'),
            array(
              '1' => ts('value 1'),
              '2' => ts('value 2')
              )
            );

Is there any efficient method to do it? Also i want to capture the option value and save it to a variable in order to save it in the database. I have tried $form->getvalue('a'), but didn't work. Much appreciate if someone could help me to solve this.


texts: ISSUE upgrading CiviCRM 4.6 to 4.7 (or 5.1) in Wordpress (comes from a Drupal multisite)

texts:
we are trying to upgrade a CiviCRM 4.6.15 on Wordpress that comes from a multisite Drupal installation. This on WordPress is on a different server, but with the same DNS and Admin name. It works correctly but...

...if we try to upgrade to CiviCRM 4.7 (or 5.1) the procedure starts but does not go beyond a "dead screen" with a Retry & Skip button that do not work.

We fear that there were problems with exporting the DB from Drupal multisite. Please, where should we look for the error?

Attached the log file: https://pastebin.com/65fnAgMG

Thanks in advance for those who can help us.

    UPDATE:

1) as our SysAdmin (user3225453) replied, we've tried to follow Jaap's procedure
below, but it's not working.

2) However this activity and the next Jaap' comment helped us to read better the LOGs:

the problem (if does not concern "not imported custom fields" as
suspected by Jaap) could also be related to "PROFILE" (aka: "UF_Group", which are also found in the LOG)

Do you have any idea? what about if we delete all profiles from the previous installation and try a new update?

Thx.


texts: Webform submission value token not working

texts:
From a webform submission I would like to send an automated email, for example with first name. As per webform token I have included Dear  [submission:values:civicrm_1_contact_1_contact_first_name:nolabel] within the body of the email.

But unfortunately result returns empty. Anyone experienced issues like this? any tips please?


texts: Legacy SQL Activity and Contacts Dump Transfer

texts:
Because of the excessive problem that happened to me on SQL, I had to create a new CiviCRM installation.

How can I transfer the existing Individual profiles and Activities in the old CiviCRM database to this new one?

I want to transfer legacy CiviCRM contacts and events to my new system.

Joomla! 3.6.5 - CiviCRM 4.7.17


texts:
At some point ckeditor broke for us.  Developer tools show me it is not loading because :

Common.js?ol145e:249 GET https://home/NAMEREMOVED/www/www/sites/all/modules/civicrm/js/wysiwyg/crm.ckeditor.js net::ERR_NAME_NOT_RESOLVED

I can't seem to find the appropriate place to fix this.  As I usually don't poke around the guts.

Everything else seems to be loading appropriately from the domain instead, i.e. https://domain.name/sites/all/modules/etc.....

Any thoughts?  We haven't migrated the server just updated it.

CiviCRM version 4.7.16 is up-to-date.  We are on Drupal 7.54?  I have shell access and can edit files.


texts: DBError and Network Error when saving phone numbers to contacts

texts:
In our organization's new civi database, we are unable to add phone numbers to contacts. I've tried keying in the number and importing a contact with a number. (It took me hours to figure out that it was the phone numbers that were breaking the import!)

There are two error messages we get, depending on the context:

In the View Contact view of the data, when I try to save a phone number, we get this error message:

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

In the Edit Contact view, or when trying to import a record with a phone number, we get this error message:

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

Log is below, and seems to suggest it has something to do with stripping non-integer characters from the field. However, adding a phone number without any dashes 5554443333 also produces the error. Any ideas?

  Jul 02 12:28:40  [info] $Fatal Error Details = Array
  (
      [callback] => Array
          (
              [0] => CRM_Core_Error
              [1] => handle
          )

[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] =>
CREATE FUNCTION civicrm_strip_non_numeric(input VARCHAR(255) CHARACTER SET utf8)
  RETURNS VARCHAR(255) CHARACTER SET utf8
  DETERMINISTIC
  NO SQL
BEGIN
  DECLARE output   VARCHAR(255) CHARACTER SET utf8 DEFAULT '';
  DECLARE iterator INT          DEFAULT 1;
  WHILE iterator < (LENGTH(input) + 1) DO
    IF SUBSTRING(input, iterator, 1) IN ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9') THEN
      SET output = CONCAT(output, SUBSTRING(input, iterator, 1));
    END IF;
    SET iterator = iterator + 1;
  END WHILE;
  RETURN output;
END [nativecode=1419 ** You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)]
[type] => DB_Error
[user_info] =>
CREATE FUNCTION civicrm_strip_non_numeric(input VARCHAR(255) CHARACTER SET utf8)
  RETURNS VARCHAR(255) CHARACTER SET utf8
  DETERMINISTIC
  NO SQL
BEGIN
  DECLARE output   VARCHAR(255) CHARACTER SET utf8 DEFAULT '';
  DECLARE iterator INT          DEFAULT 1;
  WHILE iterator < (LENGTH(input) + 1) DO
    IF SUBSTRING(input, iterator, 1) IN ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9') THEN
      SET output = CONCAT(output, SUBSTRING(input, iterator, 1));
    END IF;
    SET iterator = iterator + 1;
  END WHILE;
  RETURN output;
END [nativecode=1419 ** You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)]
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="
CREATE FUNCTION civicrm_strip_non_numeric(input VARCHAR(255) CHARACTER SET utf8)
  RETURNS VARCHAR(255) CHARACTER SET utf8
  DETERMINISTIC
  NO SQL
BEGIN
  DECLARE output   VARCHAR(255) CHARACTER SET utf8 DEFAULT '';
  DECLARE iterator INT          DEFAULT 1;
  WHILE iterator < (LENGTH(input) + 1) DO
    IF SUBSTRING(input, iterator, 1) IN ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9') THEN
      SET output = CONCAT(output, SUBSTRING(input, iterator, 1));
    END IF;
    SET iterator = iterator + 1;
  END WHILE;
  RETURN output;
END [nativecode=1419 ** You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)]"]

  )


texts:
I wanted to quickly pull all the data (contacts, custom types, etc) from one Drupal CiviCRM install to another.

I got a little too clever for myself and used Drush sql-sync to do it. It failed. As I was in a hurry and it seemed to be a permissions issue I re-ran the import as the DB root. This worked, and the site appears to work fine. However, Drush sql-sync now always fails when I try to pull from live to staging or to dev servers.

After much digging I realised the original sql query included a number of triggers related to the user of the copied website, eg:

 1156 DELIMITER ;;
 1157 /*!50003 CREATE*/ /*!50017 DEFINER=`source_user`@`localhost`*/ /*!50003 TRIGGER civicrm_activity_before_insert before insert ON civicrm_activity FOR EACH ROW BEGIN
 1158 SET NEW.created_date = CURRENT_TIMESTAMP;
 1159  END */;;

I assume I want to change these entries, is there a "safe" way to go about that?

Is the presence of these bad for the site?

The source_user has no grants on the new site.

There are at least 60 or so references to the database user in civiCRM related triggers and definitions.

As an aside, Why does civi need to do this when there is a settings file?


texts: Possible error in Contributions and Membership Details report

texts:
When we run the Contributions and Membership details report for our organization, it reports 41 entries in the month:

Row(s) Listed   41
Total Amount    $ 1,320.00(44)
Average     $ 30.00

However, when the 41 rows are exported as a CSV, the amounts total to $45 less.

What is the meaning of the "(44)" beside the total amount?  I suspect it represents that the total is based on 44 rows instead of 41 which would account for why the total is erroneously high.

Is this a "feature" or a "bug"?   If a feature, how can I figure out the three extra rows since they do not show up anywhere in the report

Incidentally, if I do the same as a "Find contributions" search, it returns 41 rows and the correct total dollar amount for those 41.

This is version 4.5.8, and the organization has not been using soft credits in its operations.


texts: Cron "Running" But "Not Running"!! How to fix this?

texts:
I had everything running fine until this morning all of a sudden CiviCRM decided to show up a message that cron is not running. But if I go to scheduled Job its all running fine. Please see the screenshot. I have not installed anything nor have changed settings on host. Cant find anything in the log either! What could go wrong? I am puzzled, Can anyone help please? Thanks

I am on CiviCRM 5.17.5, drupal 7
Here is my cpanel cron setting:

*/5 *   *   *   *   /usr/local/bin/ea-php72 /home/webadmin/public_html/sites/all/modules/civicrm/bin/cli.php -u soap -p Bd88khdksjfh -e Job -a execute


texts: When importing contributions I would like receipts to go to the contacts that made the payment. What is the best approach to make this happen?


texts: Best practice for sending a notice about an upcoming recurring contribution

texts:
We have a contribution page that creates automated recurring contributions on a yearly basis.
Because 12 months is a long time to remember that you have a recurring contribution set up, we want to send out a courtesy email 2 weeks before to let people know that we are going to take a payment and give them the opportunity to cancel it if they want to.
Is anyone else doing this? How do you do it? A scheduled reminder based on civicrm_contribution_recur.next_sched_contribution_date would be nice but I know that isn't possible at the mo. Are there any other ways people are doing this?
PS. I know that we could use membership end date if they were members but we don't want to go down that route - we want to tie it to the recurring contribution.


texts: How can I allow multiple memberships for a single contact under one organisation?

texts:
There are two scenarios
First
a. I create contribution page with membership types A, B, C, D and then user goes to the contribution page and purchases membership type A
b. I again go to the contribution page and this time purchase membership type B
Result -->  Membership Type - B
i.e. At first my membership type was A but after purchased membership type B, I have Membership Type B
Second
a. I go to contact dashboard , open membership tab and click on + Add Membership --> select membership type A
b. I again to contact dashboard open membership tab and click on + Add membership --> select membership type B
Result --> ** Membership Type A and Membership Type B both
i.e. I have two memberships A and B
I know since all membership type belongs to one organisation , we maybe getting the above issue, is there any chance we can implement scenario second with  contribution pages ?
is there any better solution than as provided in the old post here : https://forum.civicrm.org/index.php%3Ftopic=31251.0.html


texts: (version 5.13/5.14) Search Builder syntax error when "Groups" "is empty"

texts:
in the latest versions of CiviCRM (5.13.4 and 5.14) we can no longer search for contacts that are not included in any group through the search builder!

First (at least until version 5.12) with this search:

we obtained "all contacts that did not belong to any group", while now we give a a SINTAX ERROR.

How to solve?


texts:
Where/how do I get the tarball for CiviCRM 5.13.7 ESR Drupal 7 edition.

I have two different $20/month membership subscriptions to CiviCRM. Logged in to my civicrm.org  account I have twice filled out a form asking for my email address and User name.

I see nothing in my email and no messages on my account page.

How do I get it?


texts: How can I offer event registration cancellation but not registration transfer?

texts: I want to allow participants to cancel a registration but not to transfer it to someone else. It seems that CiviEvent offers either both or neither. Is there a way of just enabling one?


texts: In what circumstances is it safe to automatically de-duplicate contacts?

texts:
When is it safe (and when might it not be safe) to automatically de-duplicate contacts submitted from a public facing form?

How might a malicious user leverage automatic contact merges to their advantage?


texts: Workflow approach for anonymous users, or limited roles to create events

texts:
Problem: Currently, we need a trained content editor to create events. The event content, often comes via email from others inside (or outside) the organization.  This typically involves copy/paste of event info.  I could setup a form but this would still require manual effort.

Objective: I'm looking for a clever workflow adjustment to allow people (authenticated or even anonymous) to stage the event content for approval so that many people can initiate the event workflow and an event coordinator can finalize/approve.  Civi already has the public/active flags for events. I know many folks are developers and jump to a dev solution, but wondered if some creative folks had an approach to this for a system builder without much new coding - Anyone up to the challenge?

Scope: Clearly this can be done via development of an extension/api or custom tpl, but wondered if someone has a lower cost/maintenance approach to preparing/staging content in CiviCRM (like drafts/workflow in a CMS.) I'm using Drupal.

Approaches: Since I'm using Drupal, one path I considered is civicrm_entity which now
supports domain.com/civicrm-event/add or domain.com/civicrm-event/edit.  This exposes the laundry list of event fields so I would need display suite or some other module to hide most of the irrelevant fields and set the event to inactive.  The problem here is that price / location / etc. are actually different entities so I believe i'd need code to join them.  The nice thing here is that the user can see the template content and then just edit it or leave it.

Another thought was creating to webform or entityform to ask the user to fill-in things like event title, description, etc. and then using drupal rules, create an event based on a template and copy those fields to a new, unpublished event.


texts: How to include price field data in a Contribution Thank You letter

texts:
We have a need to display price field information in a contribution Thank You letter.  As the token system can't handle the price set data, I've pulled the relevant Smarty code from the receipt template, which very nicely presents all of the price fields that were selected for the contribution.

Of course when I make PDFs, its not working : )

I have Smarty enabled for email in the settings.php, and I can use Smarty logic to display content in the Thank You - so Smarty is actually working. But the beginning loop "{foreach from=$lineItem item=value key=priceset}" seems to return nothing and thus no price fields are added to the letter.

Is this possible to do?  What is needed to activate processing of price fields in a letter?


texts: Fatal Error after upgrading to 4.7.13 from 4.7.11

texts:
Just upgraded Civi from 4.7.11 to 4.7.13

The upgraded installed successfully, but rendered Civi functionally unusuable. Attempting to click on any tab within Civi (such as navigating to Contributions, Mailing, Memberships, etc.) results in the following fatal error in the web browser.

Any assistance is appreciated! Thank you!

Fatal error: require_once(): Failed opening required 'CRM/Core/Payment/EPayUCM.php'
(include_path='/home/WEBSITE/public_html/drupal/sites/all/modules/civicrm/drupal/modules/civicrm_engage/:
/home/WEBSITE/public_html/drupal/sites/default/files/civicrm/extensions/uk.co.vedaconsulting.gotowebinar/:
/home/WEBSITE/public_html/drupal/sites/default/files/civicrm/extensions/org.civicrm.module.cividiscount-2.5/:
/home/WEBSITE/public_html/drupal/sites/default/files/civicrm/extensions/civicrm_stripe-4.5-dev/packages/:
/home/WEBSITE/public_html/drupal/sites/default/files/civicrm/extensions/civicrm_stripe-4.5-dev/:
.:
/home/WEBSITE/public_html/drupal/sites/all/modules/civicrm:
/home/WEBSITE/public_html/drupal/sites/all/modules/civicrm/packages:
.:
/home/WEBSITE/public_html/drupal/sites/all/modules/civicrm:
/home/WEBSITE/public_html/drupal/sites/all/modules/civicrm/packages:
/home/WEBSITE/public_html/drupal/sites/all/modules/civicrm/vendor/tecnickcom:
/home/WEBSITE/public_html/drupal/sites/all/modules/civicrm/vendor/phpseclib/phpseclib/
 in /home/WEBSITE/public_html/drupal/sites/all/modules/civicrm/Civi/Payment/System.php on line 59


texts: Membership end date not updated for autorenew monthly

texts:
Ever since upgrading Civi in May to 4.7.19 (currently running 4.7.22), membership end dates are not getting updated for monthly autorenewing memberships.  The completed contribution record is no longer being attached to the membership (thus no update to the end date).  Earlier contribution records which worked have the membership type in the amount_level field in the civicrm_contribution table. New ones are NULL :/

Using iATS and drupal.


texts:
Using click a tell extension (4.1) with CiviCRM (5.8.2)

When in a contact record can send a SMS with no problem- is delivered straight away.

When using 'Mass SMS' and clicking 'Send immediately' it doesn't send- at all, states on CiviCRM is complete and looking at the contact record it is complete.

Looking at click a tell account it hasn't reduced in monies nor is the SMS in the pending or sent list.

After further testing if I select 'Schedule send' and select one minute past the current time (if the Cron is running every minute) it will send the SMS at the scheduled time.

Is this an extension bug or CiviCRM bug?


texts: Should Event Scheduled Reminders be sent if they were due to go out before a person registers

texts:
Scenario:

There is a Scheduled Reminder due to go out 10 days and 3 days prior to an Event.

A person registers for the Event 2 days prior to it.

Does CiviCRM send the 10 day prior and the 3 day prior Reminders?

I am asking as a client on a customised (by others) CiviCRM 4.4.x is complaining that these Reminders are being sent out, but they should not.

Hoping that users with 4.6.x or 4.7.x can answer this, otherwise I will set up some tests to confirm.

NOTE: these are Scheduled Reminders that were set up via the tab on the Event config screen not via the Communications > Scheduled Reminders but assume that should make no difference


texts: Fix For "Incorrect Resource URL" Not Working

texts:
I am getting the error "Incorrect Resource URL" and seeing 404 for URLs that go to "undefinedjs/jquery/jquery.crmAjaxTable.js" and many instances of the error "Unable to reach the server. Please refresh this page in your browser and try again."

I have tried resetting the URL (/admin/setting/updateConfigBackend?reset=1), adding a static path (civicrm/admin/setting/url?reset=1) and doing an override (https://docs.civicrm.org/sysadmin/en/latest/customize/settings/).

I am seeing the error in the UI and viewing the 404 using the browser console.  I am also using the CV command from the command line and see that the generated path from  (/admin/setting/updateConfigBackend?reset=1) does not match what I would expect.

[root@domain default]# cv path -c userFrameworkResourceURL
https://crm.domian.org//home/user/public_html/sites/all/modules/civicrm

I think the URL should be https://crm.domian.org/sites/all/modules/civicrm.

This started when upgrading a Drupal 7 site to 4.7.28.

Help with this is greatly appreciated. I am out of ideas.

Thanks!


texts: SSL introduces warnings related to contact image

texts:
I recently introduced SSL across my entire Drupal-Civicrm site. Now when I visit the contact summary page, I'm confronted with warning errors (below) that are clearly related to SSL interfering with accessing the contact's image dimensions.

Note that the image is visible in the summary page but its aspect ratio is wrong (the image is squeezed), confirming that getting the image's dimensions failed (without SSL, the image aspect was correct).

I am using a self-signed certificate as I'm still in the development stage. I tried to disable certificate verification in php.ini (setting the parameters verify_peer=false, allow_self_signed=true, verify_peer_name=false) but it did not solve the issue.

  Warning: getimagesize(): SSL operation failed with code 1. OpenSSL
  Error messages: error:14090086:SSL
  routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed
  in CRM_Contact_Page_View->preProcess() (line 164 of /var/www/prod/sites/all/modules/civicrm/CRM/Contact/Page/View.php).

  Warning: getimagesize(): Failed to enable crypto
  in CRM_Contact_Page_View->preProcess() (line 164 of /var/www/prod/sites/all/modules/civicrm/CRM/Contact/Page/View.php).

  Warning:
  getimagesize(http://abdong.duckdns.org/index.php?q=civicrm/contact/imagefile&photo=500x500bb_3_a5ece8ea35cdb1947316bd7c98d5daf9.jpg):
  failed to open stream: operation failed
  in CRM_Contact_Page_View->preProcess() (line 164 of /var/www/prod/sites/all/modules/civicrm/CRM/Contact/Page/View.php).


texts:
I'm trying to show the preview page in a CiviCRM Webform and it's not working. I have activated the option in Webform > Form settings > Preview Page but when I press the Send button it goes directly to the thanks page.

I'm using CiviCRM 4.6.10 and Webform CiviCRM Integration 7.x-4.15

Any ideas?

Thanks in advance.


texts: Implement CiviCrm SAML with Google Suite as IDP provider

texts:
I'm helping a small charity in volunteer capacity, most of their work was done on the spreadsheets earlier, they have now started using civicrm for their events and contributions as well as membership, and emails.

They have an intranet built using google suite, and now want to integrate Civicrm with intranet site using SAML authentication for civicrm.

there config is CiviCRM 5.8.2 on drupal 7 - I’ve looked around and tried for extensions for implementing SAML on Civicrm (service provider) using Google as IDP provider, but have not got end to end instructions. Can someone please point me in right direction? I'ld be very thankful and happy to document the step by step instructions and share with all once done.


texts: How can I set up anchors in Mosaico mailing?

texts:
I am trying to set up anchors in my MOSAICO mailing so that at the top of the mailing I can have links to headers further down.
Any advice welcome?
(P.s. not a programmer, so please keep it lay!)


texts:
The easiest common installation pattern is to have CiviCRM and the frontend website on the same server using the CMS as the website but it is often said there are benefits to keeping them separate.  Multiple approaches and extensions have been developed to facilitate this - but our documentation does not (yet!) provide any guidance on these.

The purpose of this question is to gather information about the various tools that exist, what problems they solve and how they fit together as the basis for a new section in the documentation.

What extensions exist to connect a frontend website with a backend CiviCRM?

For example, CiviMRF, CiviProxy, RemoteForm,

What can they be used for?  Eg - mailing list signup, event signup, personal profile updates, contributions etc
What front-end extensions/modules/plugins work with them?

For example, do webform-civicrm, Caldera forms, Contact Form 7 work with those remote connectors?

What back-end extensions work with them?

For example, do form-processor dataprocessor work with remote connectors?

Notes:

I know the normal advice is not to ask multiple questions in one SE question. But think of those as sub-parts of the overall question "How can I connect my website to CiviCRM on a remote server?"
There are some previous related questions but the aim here is to get a comprehensive list of current recommended methods.
Eg:
creating contacts from remote websites
Webform CiviCRM integration with REST
Using iframes to present contribution page on remote site
CiviCRM and WordPress on different hosts?
If we get one great all-encompassing answer, that can become the basis for the documentation update.  More likely, we'll get a selection of answers on particular tools that will need to be consolidated.


texts:
As administrator I get the following error message:

Strict warning: Non-static method  CRM_Core_BAO_UFGroup::profileDisplay() should not be called statically in CRM_Core_BAO_UFGroup::profileDisplay() (line 2790 of <host>/sites/all/modules/civicrm/CRM/Core/BAO/UFGroup.php).

I know I can suppress such error / warning messages via Drupal and/or amending civicrm setting somewhere. But it is annoying that these messages are there at each transaction. Is there a fix?

Thank you.

David


texts: Error while installing CiviVolunteer on civicrm 4.6.5

texts:
When trying to install CiviVolunteer with CiviCRM 4.6.5

Wordpress 4.2.3 and CiviVolunteer4.5-1.4.0

I get the error:

"'Multi-select' is not a valid option for field html_type"