texts:
Membership in our organization currently includes a T-Shirt which is implemented as a "Premium" on the contribution page.  Members must pick up their T-Shirt in person, so I'm looking for a way to report (create a list) on the fulfillment status of all current members.

There is a field for fulfillment date on the Contribution Detail page, but I can't seem to find this as a field in any of the available reports.

Any suggestions would be appreciated.


texts: CiviCRM loads its own copy of jquery. This interferes with WP plugins

texts:
I am running Civi on WordPress.  I was getting spam registrations.  I installed WP-SpamShield which worked great until someone tried to register for an event.  This fails saying that cookies and javascript need to be enabled. I backed off to just used SI Captcha Anti-Spam.  This work ok for a month or so but then the spam registrations started again.  The SpamShield support folks figured out that the problem is that Civi loads its own version of jQuery.  They say this is know to be a bad thing to do: https://pippinsplugins.com/why-loading-your-own-jquery-is-irresponsible/

Any one know why Civi does this or how to disable it?


texts: Scheduled reminders - Email head css attributes are being stripped out

texts:
I'm hoping to use email templates in Scheduled reminders that have css in a <style> tag at the start of the email. Declaring css here for html elements and classes makes MUCH more robust templates that aren't prone to disasters from click-happy admin teams deleting in-line styles.

I can use these templates effectively in CiviMail and when sending emails directly from a contact's summary screen.

However, the Scheduled reminders engine strips out all the css attributes in the initial <style> tag. So the email looks awful and the <style> declaration contains all the tags and classes - with no actual css!

I'm guessing this is perhaps something to do with the IDS? I don't see any IDS log errors though. If it is something that we can tell the IDS to ignore, I'd be grateful to know how to do this.

Or is there some other way we can tell the Scheduled reminder system not to strip those attributes?

I'm using 4.6.24 with Drupal 7.54 and CKEditor. Note that the styles aren't being stripped by CK Editor (I've adjusted the editor's config.js to make this possible), because they work perfectly well in CiviMail and from a contact's summary screen... and they are there safely inside the Scheduled reminder email CKEditor screen.

Perhaps it may be useful to add here that I'm not using a <head> tag to contain my <style> tag. In my config I haven't been able to persuade CKEDitor to retain the <head> tags. Nevertheless even so all is well for the other email scenarios.

One final point - I'm aware of how to skip IDS using the following method. So could possibly add an extra path to skip in this:
https://github.com/teamsinger/uk.teamsinger.civicrm.mailgun#user-content-skip-ids-checks

Thanks for your help.


texts: How to create and fetch custom URL for advanced search?

texts:
I like to search for very specific parameters, the resulting URL's look like this:

http://localhost/crm4/civicrm/contact/search/advanced?_qf_Advanced_display=true&qfKey=5aa3233e9b46c807b76a536cee723745_4637

Now I would like to save that URL and create a menu link for it, but it keeps changing dynamically...

How can I do that? Save it as a custom search?


texts:
All,

How is it possible to customize the receipt following the payment of a donation?

I would like to add the logo of our association, customize the text and of course add an incremental receipt number

Tx for your support

SL


texts: Test payments not completing with Paypal website payments standard

texts:
I'm trying to troubleshoot some payment issues on a client site, and I'm noticing that although live payments are going through fine using Paypal website payments standard, test transactions are all being logged as 'Pending (incomplete transaction) despite the fact that the sandbox Paypal account is recording the transactions as successful and all the IPNs are getting a 200 response.

Any insights and/or troubleshooting tips most welcome.

Using Civi 4.7.29 and wordpress.


texts: Contacts have multiple emails and phone number that appear on the Summary tab on the View page and can be edited there.  However when I select the edit button on a contact,  I get only one email address and no phone numbers listed.  The "add" links do nothing.  The Display preference are checked for email and phone. This was a new recent install. Current version of 5.23.3 and PHP version 7.3.15-3.  Any thought on why the additional email addresses and phone numbers are not showing on the edit page and why the"add" link on the edit page doesn't work?


texts: Different Membership Status Rules for Different Memberships?

texts:
We are using CiviCRM to manage data for several levels of our organization. At the moment, rules around grace/lapse periods are not standardized across the organization. Is it possible to apply different membership status rules to different membership types?

Membership A. Current 0-12 months from start; Grace until +2 months after membership end date.
Membership B: Current 0-12 months after start; Grace until 1 month after membership end date.

Thanks in advance for any help.

Rachel


texts: I just upgraded to Civi 4.6.3 yesterday. I'm running it on Drupal 7. I tried to export some participant records today, including the participant status. Everything exported fine except the participant status. It's blank for every record. Any ideas? Bug? User error? TIA - John


texts: I have created a CiviCRM Cases View. How would I add a column for "Case Manager" role to the Views? I am unable to find the field where that can be displayed.


texts: How to add Each Contact Membership fee using webform civicrm in drupal7

texts:
I have 2 contacts(Contact1 & contact2) in webform, I Want each contact get membership fee.(like In civicrm while creating new membership with Record payment Registration, it will create membership fee.)
Trail: for this problem i created contribution page of financial type is "membership fee" in civicrm. this page is selcted in webform contribution tab, after submitting form it showing membership fee added only in contact1 not added in contact2,3,4.., so i want to add membership fee in each contact.


texts: Mailer uploads images but KCFinder unable to display (WordPress)

texts:
I'm considerably confused about what's happening with Mailer & images (initially, I thought the problem was related to Mosaico, but it's now disabled): weirdly, I can upload an image to a newsletter draft -- and see it there, in the draft . . . but I cannot see it with KCFinder. I can't see anything at all in KCFinder, and it spits error messages back when I try to navigate to subfolders.

The image directory is: [civicrm.files]/persist/contribute/

Indeed, uploaded images (from either Mailer or Mosaico) land happily in this directory, but I can't view or use them from within CiviCRM.

Been reading related issues for days, and I can rule out imagick (specifically related to Mosaico) & permissions (settings are normal, at 755 for directories and 644 for the images themselves). Any insight would be most appreciated!

CiviCRM:5.19
WordPress: 5.2.4
PHP: 7.1


texts: How can I merge two memberships in the same contact (without losing contribution info, etc)?

texts: Occasionally, we end up with a single contact that has two membership records (e.g., an old expired one and a newer current one). I would like to programmatically merge the two memberships cleanly, so that, for example, the remaining membership gets the oldest start date, the current membership type, all contributions are retained, etc. Have browsed Dedupe.php looking for a call that might do this, but to no avail. Any suggestions?


texts: Import donations from an external source using Form processor

texts:
We have a customised platform where we have been receiving donations before moving to CiviCRM. This platform will continue to be in use.

We would like to import all the donations and the contract data automatically on civicrm whenever it’s submitted. We would also like to send a receipt from civicrm whenever a donation submitted.

I have had a look at “Form Processor” extension and seems to be a viable option for our need. Is it possible to use for importing contribution? What is the risk of importing data this way? Any security concerns? Has anyone used Form processor for this kind of use case? Any tips would be much appreciated. Thanks


texts: Can I get a notification emailed to me every time a contact with a certain tag is updated?

texts: Our team would like to be notified any time a certain group of contacts are updated. Ideally this notification would contain the most current version of the contact profile, as well as the previous version of the profile so that our team can compare the old information with the updated fields. Is such an automated notification possible? Is there a way we could do this with a scheduled report?


texts: I can't install the CiviCRM onto my Joomla.  When trying to install it looks like it's working then it goes back to the install screen and nothing is installed.  I have tried the zip file and tmp folder.


texts: Payments fail with PayPal Standard and "Could not find a valid session key"

texts:
CiviCRM assumes PayPal Standard redirects back, that it will preserve the session cookies. But sometimes it doesn't and this causes CiviCRM to fail, even though PayPal has successfully processed the payment.
To reproduce ...

My environment is: Ubuntu 20.04, CiviCRM 5.28.4 plus security patches, Chrome Beta 90.0.4430.30
Use Chrome browser
Ensure you are logged out of PayPal
Makes a note of the SESS* and SSESS* cookies
Make a donation with PayPal Standard. During this process, log into PayPal and complete the payment.
When redirected back to CiviCRM, the response is "Could not find a valid session key" and the SESS* and SSESS* cookies have been regenerated

The issue is that the SESS* and SSESS* cookies are missing when PayPal redirects back to CiviCRM.
Here's how I fixed the problem ...

Implement a Fatal Error Handler for CiviCRM to catch the error
Detect that we 'Could not find a valid session key' when redirected
back from paypal.com to the ThankYou page
Find the row in the sessions table that can reproduce the qfKey for
this transaction
If found, load that session data into this session and redirect with a 307 response code to get the user's browser to replay the POST request


texts: How to add a field on Date Formats setting form?

texts:
I want to add a field under Localization > Date Formats. What is the correct procedure to do this?

This is what I tried. I added an entry in Localization.settings.php, CRM/Admin/Form/Setting.php's $_settings array property and CRM/Core/Config/MagicMerge.php and, added a corresponding record on civicrm_settings table and cleared the cache. The field is not showing up. What am I missing?


texts: I am using authorize.net as a payment processor. They have automatic receipt emails that go out after a contact makes a contribution. I have disabled them from going out on my account, but they are still going out. They said it was on the Civi side and something was over-riding that setting. Does anyone know how to fix this?


texts:
I am trying to use the MailGun extntion by teamsinger in WordPress  ( Civicrm 4.7.11 )

https://github.com/teamsinger/uk.teamsinger.civicrm.mailgun

The main issue I am facing is the webhooks back.

The documentation gives the path
https://www.example.com/civicrm/mailgun/bounce

Which may well be appropriate for Drupal but not for WordPress.

The code seems to create a page for the hook.

Accessing that page manually

https://www.example.com/?page=CiviCRM&q=civicrm%2Fmailgun%2Fdrop&reset=1

I can see that it is being reached via

https://www.example.com/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fmailgun%2Fdrop&reset=1

(as it is giving the correct validation failure generated by the code )

The issue is I need MailGun to reach that page and Mailgun is not logged in of course and

https://www.example.com/?page=CiviCRM&q=civicrm%2Fmailgun%2Fdrop&reset=1

returns with "Sorry, no content matched your criteria."  response

I have turned off all plugins except CiviCRM & turned off permalinks and given "Master control for access to the main CiviCRM backend and API"  to annoymous

All to no avail?

Any ideas?


texts: How are API calls logged consistently as a specific user?

texts:
I wrote some extensive scripts that are run through drush. I use the --user= switch in the drush command that supposedly runs the script as that user. The chosen user has a CiviCRM contact ID too named "My Script" and with super-user alike permissions.

When I study in the CiviCRM change log the user who made notes and changes then there seems to be little or no consistency at all:

Contacts are logged as created / changed by themselves
Notes are created by Administrator, which is Drupal uid 1 CiviCRM cid 2

How to cause the script and API call changes to be consistently logged as a specific user? I don't want the logs to be lying and I want it to be identifiable that it was actually "My Script" doing this.


texts: GDPR ext: Data Policy .pdf file can not be previewed or downloaded

texts:
We have a CiviCRM 5.2.1 on Wordpress 4.9.6 with GDPR ext. 2.6

When we attach a Policy/Terms .pdf file, it seems to be attached, it is uploaded in https://xxx.example.com/wp-content/uploads/civicrm/persist/contribute/example.pdf (therefore out of the folder "images") but ... the "Data Policy" link on the Communications preferences page does not work! (it does not open a .pdf preview or not do the download) and redirects to the same page.

We thought that the problem was this: we know that Wordpress does not have a native module of .pdf previw; then we have installed PDF Embedder; it works correctly on the same Wordpress where CiviCRM is installed but only for "normal posts" with .pdf saved on the "normal" Wordpress Media repository.

Please, someone can help us solve this problem? request obviously also addressed to friends of Veda Consulting. :)


texts: User account picking up incorrect user name

texts:
CiviCRM 4.6.2 / Wordpress

On the civi change log we have spotted a edits of contact records entered by one user are being recorded as edits by another user.  Any ideas on how this might happen, what can be done to stop it happening?


texts: CiviMobileAPI - "The extension is too old" Error

texts:
I'm running CiviCRM (v5.21.2) and the CiviMobileAPI (v5.0.1) extension in WordPress (v5.3.2).

The CiviMobileAPI extension path is /wp-content/uploads/civicrm/ext/com.agiliway.civimobileapi/

The CiviCRM WP REST API (v0.1) WordPress extension is also installed and active.

Still, I'm getting a "The extension is too old" Error when connecting via the iOS CiviMobile app (v5.0).

What could be the reason for that?


texts: after upgrade to 4.6.26 getting PHP Fatal error when starting a new mailing

texts:
I just upgraded from 4.6.23 to 4.6.26.  I'm on wordpress. Everything else seems to work fine. When I start a new mailing I get this error:

  PHP Fatal error:  Call to undefined method CRM_Mailing_BAO_Mailing:
  :getTemplateTypes() in
  ...wp-content/plugins/civicrm/civicrm/CRM/Mailing/Info.php on line
  168, referer: ...

I see that getTemplateTypes is new for 4.6.26.  I see in civicrm/CRM/Mailing/BAO/Mailing.php that the function is defined there.

I've commented out the reference to getTemplateTypes in civicrm/CRM/Mailing/Info.php and that allows me to start a new mailing, but now I'm getting this PHP warning:

  PHP Warning:  call_user_func() expects parameter 1 to be a valid c allback, class 'CRM_Mailing_BAO_Mailing' does not have a method
  'getTemplateTypeNames' in
  .../civicrm/CRM/Core/PseudoConstant.php on line 277, ...


texts: Different credit card choices for each payment processor

texts:
I have one payment processor set up that only accepts VISA and MasterCard. I have a different payment processor set up that only accepts American Express. Both use the Authorize.net style payment processor APIs.

I have added both payment processors to my contribution page. But all credit card choices (VISA, MasterCard and American Express) are offered to the visitor no matter which payment processor is selected.

How should I configure this?

(FYI: I already checked the settings at http://mygroup.org/civicrm/admin/options/accept_creditcard?reset=1  but the settings there seem to be global, not per payment processor.)


texts: Access Control issue in CiviCRM with Groups?

texts:
Hoping the CiviCRM expertise here within stackexchange can provide some guidance on a warning I'm seeing...

When an Anonymous individual on our WordPress CiviCRM site has a Group (Mailing List) selected in a Profile they are shown the following Warning message.  Each Warning message is shown twice for each Group selected by the user.

Warning: in_array() expects parameter 2 to be array, null given in /home/coloradomaker/www/www/wp-content/plugins/civicrm/civicrm/CRM/ACL/API.php on line 218

Line 218 is the return statement for the groupPermission function.

A full image of the page after submitting my two Group (Mailing List) choices is shown below:

More background:

There are two types of pages as the first submenu item under our Get Involved that are setup for an individual to provide their information for subscription to mailing lists:  Logged in and not logged in. This warning happens if they are not logged in (Anonymous user).  Does not happen if you are an Administrator (both as a WordPress user or in the CiviCRM Administrator group) or as a logged in user (Authenticated)
Some of the Groups were originally created as both a Mailing List AND an Access Control List but I removed the designation that they were an ACL group when I saw this warning since we weren't ready to go full into our implementation of the frontend site.  Changing the Groups back to a Mailing List only still did not get rid of the Warning.
At one point I installed the BuddyPress Group sync but I Deactivated the plugin since I didn't want to use it yet.
PHP 5.6, WordPress 4.9.2, CiviCRM 4.7, BuddyPress 2.9.3, BP XProfile WordPress User Sync 0.6.4, BP Groups CiviCRM Sync 0.3.5 (Deactivated)

Thoughts on how to remove the warning or complete the ACL such that there are no warnings?


texts: Very strange thing when trying to import contacts

texts:
I am trying to import contacts into our database from a CSV file. I cannot reach the first step of the import process because I never get the input field to enter the filename of the CVS file. I just have a field telling me 2 possibilities (SQL and CSV) but this field is not editable and there is no Explorer Windows opening.
Strange because it works fine for Import Activities and there I have the Windows Explorer coming to enter the CVS filename.
I use CiviCRM 5.21.0 under WP with a laptop under Chrome, Windows 10... Same problem under Edge or under another workstation.
Any help will be much appreciated, thanks


texts: What permission allows removing dashlets from "Configure Your Dashboard"?

texts:
As an admistrator, if I hover over a draggable dashlet title in the "Configure My Dashboard" view, I get a little cross that I can click and I can remove the dashlet from everybody's dashboard.

I want to give this permission to another user but I gave him all the report-related permissions and this still does not work for him. Is there a permission that I can give him or does it just check for the "Admin" role?


texts:
Can't load system status after upgrading from 4.7.31 to 5.2.2 on latest WP. When I try, Console shows Uncaught Error: Syntax error, unrecognized expression: #/status and the page is blank. Error log shows

  PHP Fatal error: Uncaught Error: Call to undefined function
  civicrmVersion() in
  /wp-content/uploads/civicrm/ext/com.cividesk.email.sparkpost/sparkpost.php
  on line 145

Tried disabling Asset Caching (in Debugging & Error Handling) to no avail. Also installed latest Sparkpost for WP, but no change. What might cause this behavior?


texts: Sort function for Activities in CaseView

texts:
I want to sort the Activity Types that appear in the dropdown menue in CaseView, when clicking "Add Activity". It should be sorted according to a determined order (based on frequency of use).
Therefore, I built a custom sort function that I included in sites/all/modules/civicrm/CRM/Case/Form/CaseView.php:
  public function compareToSample($aTypes, $sample_array) {
    $new_array = array();
    $size_sample = count($sample_array);
    // search for first element of $samplearray in $atypes
    for ($newarrayindex = 0; $newarrayindex < $size_sample; $newarrayindex++) {
      $key = array_search($sample_array[$newarrayindex], $aTypes, FALSE);
      if($key) {
        // found an element -> save at the end of $new_array
        array_push($new_array, $aTypes[$key]);
        unset($aTypes[$key]); // delete it from $aTypes
      }
    }
    // if after the whole process $aTypes is not empty, add the rest of elements to end of $new_array
    if(!(empty($aTypes))) {
      if(empty($new_array)) {
        // no element in common
        return $aTypes;
      }
      else {
        $new_array = array_merge($new_array, $aTypes);
      }
    }
    return $new_array;
  }

public function mySort($array_to_sort) {
    $sample_array = array(...some string elements representing the activity types in the right order...);
    if(empty($array_to_sort)) {
      return null; // EXCEPTION
    }
    $result = $this->compareToSample($array_to_sort, $sample_array);
    return $result;
  }

I am calling this function with $aTypes = $this->mySort($aTypes); inside the buildQuickForm() function in CaseView.php. (I am calling it just after the place where the original code is also sorting $aTypes, that is, just after:
if (!$xmlProcessor->getNaturalActivityTypeSort()) {
      asort($aTypes);
    }

The problem is now that the function only seems to sort the labels of the Activity Types, but not the Types themselves. So when clicking on one type, it will create an activity with another type of the list. How can I get the function to sort the real elements?
Any hint is appreciated :)


texts: CKEditor in Civicrm - Is it possible to have a custom css file?

texts:
7 In Civicrm 4.7+ there's a great interface for customising CKEditor, and it allows you to add custom styles to the editor. That's great!

But we would very much like to go further and call a whole new custom css file for CKEditor. Much like you can in Drupal's CKEditor. We use in Civi we use CDEditor for event descriptions and much much more, and we'd like to make the CKEditor interface the same as for our Drupal web pages.

Is this already possible? And if not, any ideas about how to make it possible? Thanks for your help!

Civicrm 5.10.3, Drupal 7 latest.


texts: It would be convenient for us to have open-ended memberships. For example, our board members are permanent members of the organization (this is different from lifetime memberships).  I'd like to have their membership record maintain a start date but drop the end date.  Is there an easy way to make that happen?


texts: How can I add conditional profile fields (WordPress)

texts:
I would like to have conditional fields, that will be visible when certain conditions are met, for example:

New Customer, IF group is business, show business address field, IF group is individual, show home address, etc..

I am using WordPress 5.2.1 and CiviCRM 5.4.0


texts: Why did Case Type get stripped from all Smart Groups after upgrade to 4.6.9?

texts:
Drupal 7.41

After upgrade to CiviCRM 4.6.9, all Smart Groups that had a case type in the criteria were empty.

When I looked at the criteria for each group, the case type was stripped from the search.

I manually added each one back in and ran a rebuild and everything appears to be ok now.

Any idea what may have caused this?


texts: How can I get Double Opt in to work when using a Profile for to create a user/contact

texts:
Wordpress 4.9.8, CiviCRM 5.6.0

I'm in Wordpress trying to use CiviCRM profile forms to capture information from users for registration. At the same time, this will create their Wordpress user.

However, CiviCRM lets you create any user you want, with any available email, using a profile page without getting any confirmation via an email address...

Surely this puts us in violation of some of the newer GDPR laws?

The only double opt in that happens is if you use the option to add someone to a group and it sends them an opt in mail. This is pretty useless since it's just let you create a user with any email address you want.

This seems to let the system be open for abuse.

Am I missing a setting somewhere?

Thanks,
Norman


texts:
After installation I am getting this error:

    PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'civicrm_handler_field_custom_file-class' for key 'PRIMARY': INSERT INTO {registry} (name, type, filename, module, weight) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4);
Array ( [:db_insert_placeholder_0] => civicrm_handler_field_custom_file [:db_insert_placeholder_1] => class [:db_insert_placeholder_2] => sites/all/modules/civicrm/drupal/modules/views/civicrm/civicrm_handler_field_custom_file.inc [:db_insert_placeholder_3] => civicrm [:db_insert_placeholder_4] => 0 ) in _registry_parse_file() (line 179 of /xxxx/drupal70/includes/registry.inc).


texts: Upgrade to Drupal 4.7.12 failed (while upgrading from 4.7.11 to 4.7.21)

texts:
Trying to upgrade from 4.7.11 to 4.7.12 but failed.

Here is debug info:

[Error: Add Data Type column to civicrm_option_group]
Error Field Error Value
Type    DB_Error
Code    -19
Message DB Error: no such field
Mode    16

UserInfo:
    UPDATE `civicrm_option_group_en_US` SET `data_type` = 'Integer' WHERE name IN ('activity_type', 'gender', 'payment_instrument', 'participant_role', 'event_type') [nativecode=1054 ** Unknown column 'data_type' in 'field list']

DebugInfo
    UPDATE `civicrm_option_group_en_US` SET `data_type` = 'Integer' WHERE name IN ('activity_type', 'gender', 'payment_instrument', 'participant_role', 'event_type') [nativecode=1054 ** Unknown column 'data_type' in 'field list']

However, field data_type DOES exist.


texts: File type custom field to only allow images

texts: I have created a file type custom field and discovered that you can upload any type of file on the field so I want to restrict the custom field to only upload image files. Is it possible?


texts: "no such field in civicrm_api3" after Upgrade from 4.6.4 to latest 4.7

texts:
I ran the database upgrade script and it showed me an error and didnt get finished..

since then I can't run the /civicrm/upgrade script and it always gives me the error:

CiviCRM_API3_Exception: DB Error: no such field in civicrm_api3() (line 45 of /usr/share/drupal7/modules/civicrm/api/api.php)

please help.. I do NOT have a backup from my old database! Is there any other way to fix this?

thxx


texts: Can no longer modifiying priceset amounts in hooks in 5.1.2

texts:
I'm looking for help on adjusting a priceset amount in a hook at the end of a membership signup.
Until now under 4.7 for reasons of multi-level priceset complexity I've been adjusting priceset amounts via the hook_civicrm_validateForm by adjusting the values in the $form object. This has been working fine, but this is now longing working in 5.1.2.
I realise that strictly speaking I shouldn't modify the $form in the validateForm hook.
"The hook is intended for validation rather than altering form values."
However I can't see anywhere else to change the amounts.
I have two questions, i) Can anyone explain the difference in behaivour between 4.7 and 5.1.2? ii) is there a better place or method to adjust the priceset amount?


texts: How can I generate a report that shows list of recurring payment of different types?

texts:
I need to generate a report that shows a list of donors who gave above £10 as recurring basis in September 2020. They may have been giving previously or just started in September.
The payment comes from online contribution page is easy to spot by their recurring mark in contribution. But We have some donation coming by bank account which does not have any marking of recurring as such.
How can I combine the 2 criteria above and generate a report? Any help would be very much appreciated.


texts: I am trying to send a newsletter with a youtube video link. How to insert youtube link in Civimail, like in mailchimp?


texts: Has integration been done for Textify Mobile?

texts: Has anyone seen this new SMS service called Textify Mobile that's geared directly to non-profits and churches. It even has mobile giving with it. Wondering if anyone had done an integration/extension for it?


texts: How can I change the label name of a field and it's data also?

texts:
I'm attaching the file as it's easier to explain. I want to change the label of a field, and also the resulting data. Kind of like changing both the fields and it's display in Drupal.

Can I do this with a find and replace in PhpMy admin?


texts: I would like to be able to select and import one or more e-mails from my external inbox, into the Activities of a Case, creating a new activity. Is this possible and if yes, how? Who is familiar with this and how is it done?


texts: Aggregation with repeating events in Drupal Views

texts:
I am trying to create a View counting contacts who attended various repeating events. Each contact needs to be counted once for each repeating event, so I want to group by the event name, not its ID.
I base my View on Participants. My View shows two fields; Event Title and Contact ID. I Group By on Event Title and Count Distinct on the Contact ID.

However, the resulting query includes the Event ID in the select list, so I end up grouping on Event ID instead of Event Title.

Is there a way to stop views including the Event ID in the Select Statement?

Would be most grateful for any solution or workarounds.


texts: Autodetecting variables for URL variables

texts:
I am having an issue in Settings - Resource URLs where the [civicrm.files] variable is detecting incorrectly. It's actually detecting as https://www.mydomain.org/usr/home/webhoster/mydomain.org/wp-content/plugins/files/civicrm/

Is there an override I can put in my civi URL variable settings file to make it right? Or do I need to get a tweak to my server?


texts: Line wrapping - breaking lines longer than 998 characters - in CiviCRM (CiviMail, Flexmailer, Mosaico)

texts:
We've have experienced in some cases on emails sent from CiviCRM the DKIM signatures were getting invalid. We use a self-managed email server for this, and usually DKIM is fine.
After some research I found out the reason why was DKIM broken (and why not always) is that if we send an email with a line containing more than 998 characters - which can happen easily by using email template editors (Mosaico in our case) - first the message is signed by OpenDKIM, then Postfix break lines longer than 998 chars (number of chars can be configured) to conform with SMTP protocol, which doesn't allow more than 1000 chars (998 chars + \r\n) in a single line. Then DKIM verification will fail as there are extra characters (line breaks) in the email body.
It would be best if the order could be changed (first line breaking then signing), but as far I as know milter applications (like OpenDKIM) can be plugged into Postfix only to the early stages of processing (smtpd or cleanup) and line breaking happens at the last stage (smtp).
Further testing showed, if I send a mail with this long lines from another email client (Roundcube) to the same server, long lines are already wrapped before signature. Also tested traditional CiviMail and Flexmailer and they gave the same results as with Mosaico.
This led me to think that wrapping long lines should be handled by clients (CiviCRM in this setup).
So we wrote a simple extension to handle this (https://github.com/reflexive-communications/civalpa) and the issue seems solved.
My questions would be:

Has anybody run into this issue? One thing that is very strange for me, I've not found too much material but one which seemed quite relevant (https://www.virtualmin.com/node/37021), and that also suggested line wapping should happen before sending to the SMTP server.
Lien wrapping should really be handled by clients or is this a configuration issue on the mail-server?

Related versions:

CiviCRM: 5.29.1
Mosaico form CiviCRM: 2.5
Postfix: 3.4.13
OpenDKIM: 2.11.0

Thanks


texts: Is there any way to import files into a custom field for uploaded files?

texts: Is there any way through SQL commands, to import files into a custom field? E.g. photos of contacts?


texts: State/Province dropdown is empty since update to 4.6.10

texts:
I just discovered that the State/Province dropdown in Address section of create New Individual form is missing the state data. When I click on the dropdown it displays "N/A" and below it "None found.". This seems to be a universal problem in my civicrm instance too - e.g when i go to to manage an Event the dropdown behaves the same.

I have never noticed this problem before in 5+ years of running civicrm. I recently upgraded to 4.6.10 from 4.6.3 - perhaps its related. This is a WordPress 4.3.1 install.

I checked the 'civicrm_state_province' table in the db and the data is there, so i'm not sure why it's not getting loaded in the dropdown.

any ideas?

screenshot of broken dropdown: http://imgur.com/3w3G8On


texts: What is the status of CiviCRM working with Drupal 8 now that it is released?

texts: Drupal8 released recently, do we know what the status of the integration effort to have civicrm run on it, yet?  I am in the process of updating our site and this would have been the perfect time to implement D8, if only civicrm works


texts: How to restrict access to only one Contribution Page

texts:
Drupal 7 / CiviCRM 4.5.8
Working on a site which has several contribution pages.  We want to leave the majority of them accessible to anonymous users, but have just one that we want to restrict to "members-only".

In Drupal the $form variable passed in hook_form_alter() will have a '#access' parameter that can be set to false.

What's the best way to accomplish this with a CiviCRM form?
Is there something that can be modified in the $form variable using hook_civicrm_buildForm()?

Some better way?


texts:
I have an installation of Wordpress.Civicrm which I have copied to another server using a different domain name

It works great, except the WordPress Base Page is still set at the old domain name and I cannot find where to edit it

I have searched the database and the files, and cannot resolve this
it is shown on
my_website_domain/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fadmin%2Fsetting%2Fuf&reset=1

I want to change it

FROM

my_OLD_domain_name/civicrm

TO

my_NEW_domain_name/civicrm

I hope you can help

thankyou in advance

Neil


texts:
Please help me to solve this issue:

CiviCRM Dashboard endless loading… + Warning: file_exists(): open_basedir restriction in effect.

Warning: file_exists(): open_basedir restriction in effect. File(/home/wp-includes/version.php) is not within the allowed path(s): (/home/user:/tmp:/var/tmp:/opt/php-5.5/pear:/usr/local/bin:/etc/pki/tls/certs) in /home/user/public_html/wp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php on line 471

Above, I changed my real user login for “user”.

I use shared hosting by hostinger.com, where I have no access outside of public_html folder. It is not possible to access Linux system folders like: usr, /opt, /etc. Is it needed to CiviCRM to access that folders?

Apache 2.4, PHP 5.5.35, memory allocated 256 MB, MYSQL 5.6

I installed Wordpress 4.5.3 fast and easy by some graphic installer at the hosting panel. Then, I installed civicrm-4.7.8-wordpress.zip downloading it by the Wordpress plugin installer. CiviCRM installed and activated, I run civiCRM installer. CiviCRM Installer sad “Youŕe ready to install! - Database version and connection settings have been verified and look correct!” All requrements were Ok. Then, I pressed the button “Check Requirements and Install CiviCRM” without sample data. CiviCRM was “successfull” installed, but there was an error: no CiviCRM menus, Dashboard (endless) loading…  … never finished.
At the top, the permanent message: “Warning: file_exists(): open_basedir restriction in effect. File(/home/wp-includes/version.php) is not within the allowed path(s): (/home/user:/tmp:/var/tmp:/opt/php-5.5/pear:/usr/local/bin:/etc/pki/tls/certs) in /home/user/public_html/wp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php on line 471”

“System Status: Error: Cron Not Running, Configure Default Mailbox, Complete Setup”.

Then, I uninstalled Wordpress, reinstalled it, and did some configurations every time I reinstalled it before install CiviCRM.

I edited the settings, media(miscellaneous), to only “wp-content/uploads” without quotes, or the respective temp folder, at any time a tried a new install, did logof, login again and a new CiviCRM install with other plugins disabled.

In wp-config.php, I edited line 62 by changing “define('WP_TEMP_DIR',dirname(FILE).'/wp-content/uploads');” for “DEFINE('WP_TEMP_DIR','../tmp')” or “define('WP_TEMP_DIR', dirname(FILE) . '/wp-content/temp/');” and simultaneously creating the respective temp or tmp folder. Hostinger accounts have no tmp folder by default.

Don’t matter what I do, CiviCRM installation always fails in Wordpress.

version.php

/**
 * Holds the WordPress DB revision, increments when changes are made to the WordPress DB schema.
 *
 * @global int $wp_db_version
 */
$wp_db_version = 36686;

/**
 * Holds the TinyMCE version
 *
 * @global string $tinymce_version
 */
$tinymce_version = '4310-20160418';

/**
 * Holds the required PHP version
 *
 * @global string $required_php_version
 */
$required_php_version = '5.2.4';

/**
 * Holds the required MySQL version
 *
 * @global string $required_mysql_version
 */
$required_mysql_version = '5.0';

$wp_local_package = 'pt_BR';


texts: Unknown extension after upgrading CiviCRM in Wordpress

texts:
Updrading from CiviCRM 4.6.4 to latest (4.7) and using wordpress 4.4.5..

The upgrade process showed no errors, in fact it showed "Done" and began to redirect to a url that never loaded. I clicked on "Civicrm" on the left sidebar of wordpress and nothing. I went to the base url of the wp install and this message appears:

Sorry but we are not able to provide this at the moment.
Unknown extension: nz.co.fuzion.payflowlink
Return to home page.

Found this in /wp-content/plugins/files/civicrm/ConfigAndLog

Dec 16 10:59:28  [info]
$Fatal Error Details = array(3) {
  ["message"]=>
  string(43) "Unknown extension: nz.co.fuzion.payflowlink"
  ["code"]=>
  NULL
  ["exception"]=>
  object(CRM_Extension_Exception_MissingException)#978 (10) {
    ["errorData":"CRM_Core_Exception":private]=>
    array(1) {
      ["error_code"]=>
      int(0)
    }
    ["cause":protected]=>
    NULL
    ["_trace":"PEAR_Exception":private]=>
    NULL
    ["message":protected]=>
    string(43) "Unknown extension: nz.co.fuzion.payflowlink"
    ["string":"Exception":private]=>
    string(0) ""
    ["code":protected]=>
    int(0)
    ["file":protected]=>
    string(104) "/Users/me/Sites/donate_new/wp-content/plugins/civicrm/civicrm/CRM/Extension/Container/Collection.php"
    ["line":protected]=>
    int(150)
    ["trace":"Exception":private]=>
    array(30) {
      [0]=>
      array(6) {
        ["file"]=>
        string(104) "/Users/me/Sites/donate_new/wp-content/plugins/civicrm/civicrm/CRM/Extension/Container/Collection.php"
        ["line"]=>
        int(111)
        ["function"]=>
        string(12) "getContainer"
        ["class"]=>
        string(34) "CRM_Extension_Container_Collection"
        ["type"]=>
        string(2) "->"
        ["args"]=>
        array(1) {
          [0]=>
          string(24) "nz.co.fuzion.payflowlink"
        }
      }


texts: We need to customise a template called 'Selector.tpl', we have identify this template with debugging on and copied it into /wp-content/uploads/civicrm/templates/ and this directory is declared in Directories. We followed the documentation and it should work fine when it doesn't. The template is not loaded. We've tried on the original file that gets modify in the desired way but we want to use the custom one. Folder has 755 rights on and File has 644 on. Is there something special to care about?


texts: Why do Credit Card fields (and Billing fields) display before the PAYMENT METHOD is selected?

texts:
This may be specific to some payment processors. i am observing it with authorize.net.

Contribution page has 'credit card' and 'pay later' available as option, therefore the two payment methods are available as radio buttons.

When the page is opened, no Credit Card / Billing fields are displayed.

But, once an amount is selected, the Credit Card / Billing fields are displayed which results in users jumping down to fill those in, then getting an error telling them that 'payment method' needs to be chosen.

IF a default value of 'amount' is set, then the Credit Card and Billing field show immediately. Which does not seem correct to me.

UPDATE - this is an issue when using Dummy processor which ships with civi.


texts: Why is CiviCRM mistranslating my string?

texts:
My site is translating Yes to Si for French (fr_FR). I've confirmed that:

I don't have any word replacments for Yes.
Most everything else is translated correctly.
I've got an up-to-date civicrm.po file for fr_FR and it contains the correct translation of "Oui".

I've even installed the brilliant de.systopia.l10nmo and org.civicrm.l10nx extensions and uploaded an override .mo file.
WTF?


texts: Is webform_civicrm 7.x-5.1 compatible with Drupal 7.67 and CiviCRM 5.19?

texts:
In the module update page in Drupal, it is shown as not compatible.
If so, what is the minimal configuration for webform_civicrm 7.x-5.1?
(I will update Drupal soon, but in the meantime, I prefer to update the module, if possible)


texts: Crons are running but system status page says otherwise

texts:
I am hosting CiviCRM on a shared server with CPanel with latest CiviCRM and Wordpress versions.  I have created cron jobs for all active crons using wget. e.g.

wget 'https://domain.org/wp-content/plugins/civicrm/civicrm/bin/cron.php?name=NAME&pass=PASS&key=KEY&job=cleanup'

Crons are running and the last run times on the scheduled job page are updated for my active jobs but the system status page lists the last time cron ran to be when I last ran all jobs manually.

Is there something else I should do?


texts: CiviMail tracked URLs give "Missing input parameters" from /extern/url.php

texts:
Any mailing that I send through CiviMail converts URLs to links in the form of:

http://mysite.org/sites/all/modules/civicrm/extern/url.php?u=193&qid=52

But when I visit this URL I get a white page with "Missing input parameters" and the address is http://mysite.org/sites/all/modules/civicrm/extern/url.php

Curiously I looked at some old CiviMail mailings and those URLs still work!

I don't think this is related to Missing Input Parameters Error

I'm running 4.6.3. Thanks for your expert insight and helpful suggestions.


texts: Drupal views: text search in country name

texts:
When viewing CiviCRM contacts in a Drupal view, you can filter on the Address:Country , but the filter widget proposes you to filter on one or more of the 300+ countries in CiviCRM.

When exposing this filter, the user sees those 300+ countries. If only ~50 countries actually have contacts, such a dropdown is not very useful. Most countries will return 0 results.

It would be good enough if I can have a text search on the name of the country, but I can't get that to work. The filter only supplies the country id (eg using a 'combine' filter on the single field requires you to enter a number as a search string - that works).

Is there any way to pull the country table into the view and, for example, rewrite the view using hooks_views_query_alter to allow you to filter on the country name ?

Or any other solution someone found, like limiting the dropdown to used countries only ?


texts:
I have multiple contacts in a webform (a family). Each contact can have a membership type with an associated fee. I want each contact to be have their membership renewed and the fee associated with their contact record and membership. What's happening at the moment is that the sum of membership fees is being charged to the primary contact (the one submitting the form). All individual memberships are being correctly renewed but without the associated membership fee attached to the membership record. I have soft credit set to none.

I have been unable to see where I am going wrong.


texts: What is recommended using Drupal web services or CiviCRM APIs

texts: What is recommended to collect data from CiviCRM to external Drupal application and why? Drupal web services or CiviCRM API


texts:
I've uploaded the file civicrm-5.8.2-wordpress.zip into the plugins folder and unzipped it. I've activated the plugin. The first time through this process the installer ran to the point of creating the database, but then this error shows up on the CiviCRM dashboard:

"Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
DB Constraint Violation - contact_id should possibly be marked as mandatory for DashboardContact,create API. If so, please raise a bug report."

I deactivated and uninstalled the plugin, unzipped it again and activated it. Same error. And the Settings menu does not show a CiviCRM Installer.

CiviCRM shows up in the left nav menu of WP, but clicking on it gives the same error above.

Any guidance would be much appreciated!


texts: Mailings: Error 500 with Click Through Tracking

texts:
I get an error with tracked urls in mailings. When the user clicks the link inside the mail, he gets a page telling him "error 500".

If error reporting is on in php, I get following error:

Fatal error: Call to undefined function drupal_add_http_header() in /home/www/<...>/sites/all/modules/civicrm/CRM/Utils/System/Drupal.php on line 790

The URL called is

http://<mydomain>/sites/all/modules/civicrm/extern/url.php?u=221&qid=1851

As workaround, I could solve the problem adding a call to loadBootStrap():

  public function setHttpHeader($name, $value) {
    self::loadBootStrap([], false);
    drupal_add_http_header($name, $value);
  }

But I belive this a very dirty thing to do! :-/

With this fix, all things works fine with the same url from above!

I'm using CiviCRM 4.7.Beta3 and Drupal core 7.41.


texts: How can I import a list of contacts from MailChimp to the database all at once?

texts:
I am looking to import a list of 185 contacts from MailChimp to our database and wanted to know how I can do this in one go. As far as I know I have to export the list from Mail Chimp and then edit the fields in an excel document, but how to I make sure the fields will match with those in CiviCRM?  Does anyone have or know where there is a template of what needs to be on the spreadsheet?
Are there any guides to how to layout the columns to refer to the fields I want to mark in Civi, also can I stop it importing duplicate contacts?
Thank you!
Grace


texts: CiviCRM still creates MyISAM tables which results in Warning

texts:
CiviCRM 4.7.10 --- WordPress 4.6

The following warning message appeared in CiviCRM System Status:

  Your database is configured to use the MyISAM database engine. CiviCRM
  requires InnoDB. You will need to convert any MyISAM tables in your
  database to InnoDB. Using MyISAM tables will result in data integrity
  issues.

This message appeared 5 days after upgrading to 4.7.10 from 4.7.8. The table with the MyISAM engine was: civicrm_task_action_temp%. I corrected it in MySQL using:

ALTER TABLE civicrm_task_action_temp% ENGINE=InnoDB;

On inspecting the code, I found the following in civicrm\civicrm\CRM\Contact\Form\Task.php on line 145

  $sql = "CREATE TABLE {$form->_componentTable} ( contact_id int primary
  key) ENGINE=MyISAM DEFAULT CHARACTER SET utf8 COLLATE
  utf8_unicode_ci";

and civicrm\civicrm\CRM\Export\BAO\Export.php on line 1494

  CREATE TABLE {$exportTempTable} ( ... ) ENGINE=MyISAM DEFAULT
  CHARACTER SET utf8 COLLATE utf8_unicode_ci;

All other MyISAM tables are defined as TEMPORARY.

Prior to performing the upgrade, I cleaned the caches using CiviCRM/System Settings/Cleanup Caches and Update Paths. Hence the reason civicrm_task_action_temp% was recreated.

Hopefully, this fix can be included in the next update.


texts: How can we give Admins more control on what is shown for non-existent pages such as contribution pages

texts:
What happens when an Event is deleted, or a contribution page is disabled, or a profile no longer exists?

Links i am thinking of include

CONTRIBUTION PAGE

http://dmaster.demo.civicrm.org/civicrm/contribute/transact?reset=1&id=14
You get a yellow page saying

  Sorry but we are not able to provide this at the moment.
  The page you requested is currently unavailable.

EVENT PAGE

http://dmaster.demo.civicrm.org/civicrm/event/register?reset=1&id=18

If you are logged out you end up at the home page

PROFILE

http://dmaster.demo.civicrm.org/civicrm/profile/create?gid=19&reset=1

You get a yellow page saying

  Sorry but we are not able to provide this at the moment.
  The requested profile (gid=19) is inactive or does not exist.


texts: Reality check: Can CiviCRM be implemented by a nondeveloper with limited time?

texts:
I am the director and only employee of a nonprofit with 2500 members. The president of our Board has set up a modest website hosted on GoDaddy, and now expects me to implement a membership database in CiviCRM, including online membership registrations with multiple levels, mass emailings, events including discounts for purchasing tickets for an entire series, etc.  Our membership information is currently in a 20-year-old product called Alpha5 that is no longer supported, and the need to adopt a new database is becoming more urgent as the only computer that holds our current system is getting flaky. We have no money to hire consultants, and in fact I think the main benefit my Board president sees is that the CiviCRM product is free. I am a skilled computer user but I am not a developer. I am a half-time employee whose work day is more than filled with other tasks. My sense is that CiviCRM is more than I can manage, and that even if I got it started, it would be very difficult when I retire in a couple years to find a staff person at half-time low pay who would be able to continue using and supporting it as needs change.
I would appreciate a reality check from you people who are working with CiviCRM. Would you recommend this product for a busy administrative person who is an expert Word and Excel user, with some Access experience, who has never built a website or used Drupal or Wordpress, written SQL, or programmed anything but Visual Basic?


texts: Civicrm upgrade problem - will clearing cache help?

texts:
Trying to run upgrade script on wordpress civicrm gives me a new login screen followed by another chance to click the upgrade button follow by another login screen. civicrm 4.6.9 from 4.6.8 wordpress 4.3.1

How do I flush cache on Wordpress?

Warning: Illegal string offset 'type' in /home/mygriefandloss/public_html/wp/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/Setting.php on line 613

Warning: Illegal string offset 'group_name' in /home/mygriefandloss/public_html/wp/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/Setting.php on line 516

These errors happen when I just try to access civicrm from menu.


texts: Multilingual Setup, but no language switcher

texts:
I've followed the instructions for setting up multilingual access (english & spanish) but no language switcher is appearing.
Drupal 8 install.
I'm able to select both languages in the language settings. Everything seems to go fine, but no switcher.
Where is the switcher supposed to appear? Only at login? I seem to recall reading that it would show up on various pages but may be mis-remembering.


texts: How do you separate wordpress and civicrm tables?

texts:
When we first installed CiviCRM - the installer was super eager to install using the existing WordPress database. We were just testing out CiviCRM at the time, so it was not a big deal - however we ended up sticking with CiviCRM and now we are migrating to a new server.  Before we migrate to the new server - we think now is a good time to separate the CiviCRM tables from the wordpress tables. Based on the stack mentioned above, I plan on doing the following:

Enter site into "maintenance mode". i.e. temporarily close to public.
Create a new civicrm database
Export the civicrm tables from the original wordpress DB.
Import the civicrm tables into the new civicrm database
Edit wp-content/uploads/civicrm/civicrm.settings.php to point to the new civicrm-only DB.
Test
Drop the civicrm tables from the original wordpress database.
Celebrate?

Is there something else I should be aware of?


texts: Set Hidden Field Value on Webform Connected to CiviCRM on Submit

texts:
I want to set a value on a field in a CiviCRM webform only when the form is submitted and not when saved as draft. The field is a CiviCRM field that appears in the webform but is not shown to the user.

The reason is I want to allow users to access and edit the information in the webform, but find a way of preventing them from accessing/editing the form once it has been "submitted".  So I had created a yes/no field in Civi which I could set to yes when they submit the form and then prevent them from accessing the form if the value for the field was yes.

I was trying to set the value of the field using hook_webform_submission_presave but kept on getting errors. Not sure if this was because the form is split up into several pages and is using the "Save Draft" functionality. I'm not sure also if this is the right approach for CiviCRM enabled webforms.

This webform could be for either creating a new CiviCase record or editing an existing one.

Am open to suggestions of any other ways of preventing users from accessing the form after they have already submitted it.

I am using CiviCRM 5.3.1 with Drupal 7.59.


texts:
Wordpress 5.6, CiviCRM 5.32.1, Shared server with ssh access
When I go to Events -> Dashboard and choose an event to review an existing or past event, I can edit it but when I choose the public link at the bottom of the page I get this:
https://nonprofit.org/wp-admin/admin.php?civiwp=CiviCRM&q=civicrm%2Fevent%2Finfo&id=56&reset=1
This gives a white screen for anyone, even an admin. When I manually change it to remove wp-admin/admin.php I get this format:
https://nonprofit.org/?civiwp=CiviCRM&q=civicrm%2Fevent%2Finfo&id=56&reset=1
Which gives me a list of old events - not the specific event.
I can edit the events. I simply can't show them publicly.
I suspect this has something to do with this post:
https://civicrm.org/blog/kcristiano/civicrm-526-and-wordpress-important-notice
However, WP was updated to 5.5 before I updated civicrm.
And of course this is different because it's adding the admin part to the URL.
If anyone has suggestions, I'd be grateful.


texts: Recommended process for credit card additions/'edits' to event registrations?

texts:
Using CiviCRM 4.6.4 and Drupal 7.41, we have a large event set up with complex pricing (3000+ registrants each year, lots of price options). Folks forget to register for things the first time through, or they change their mind.

We haven't been able to determine a good way to process these people who need to edit their fee level choices. I can edit fee level choices just fine when there isn't any money involved, but don't see a good way to make a 'credit card 'edit' to a registration'.

To make it more difficult, we would prefer to turn 'multiple registers with same email' off, because we tend to have admin assistants and the like sign up many folks under one email and it takes a lot of staff time to sort that out.

The fee level choices must be accurate and held in a single event record (no dupes for the event) to print the correct badge onsite, so if we do need to submit a second registration we would have to create a new with all fee level choices and delete the old ones. This tends to cause the financial tally to be off and is a different admin headache, but this is the route we have taken for now.

Does anyone have a recommendation for processing these credit card edits without the admin headaches?


texts: Can donors store their card details on dashboard?

texts:
I would like to give access to our donors to the contact dashboard and also let them donate from that page to different campaign or events signup,  so they would not have to enter their details over and over again.

I was also thinking, what if it would be possible to give option to store their credit card details like modern checkout does, for them to avoid entering them every time?

What are possibilities of achieving this? What can go wrong along the way? Thanks


texts: How to save email adresses having weird, rare format?

texts:
One of our contacts has a weird, rare email format:
name-@web.de

I did not know, that having a - in front of @ is even possible. It is the correct adress and the adress reaches its owner. Regardless of how clever it is, having such an adress, I do have the problem: I cannot save it in the contact field. An error message: invalid email adress appears.
Does anybody know how to force civicrm to accept the weird email format?

using:

CiviCRM 5.31.0.


texts: Joomla 3.8 & CiviCRM 4.7.x - front-end error 500 when logged in

texts:
I upgraded Joomla to 3.8 on a test site and CiviCRM (4.7.24) seemed to work fine. I've now replicated the upgrade on a live server (a different config'd machine but both PHP 5.6.31) and while it seemed ok at first, after logging in as admin, certain Profile Edit & all Contribution CiviCRM pages give an Error 500 (the default Name and Address profile doesn't work - but a custom profile does). Dashboard seems to load fine.

I've checked another Joomla 3.8/Civi 4.6.31 site and am getting the same problem. As I've got a working 3.8/Civi am going to try and figure what's different between the installs, but meantime, thought I'd post in case anyone has something similar or any ideas.


texts: Mailing Reports aren't being received, even though they are shown as complete and delivered successfully

texts:
Monthly Newsletter was prepared and submitted for mailing correctly in CiviCRM.  The mailing was scheduled, completed, and delivered successfully, per the CiviCRM mailing status report.  However, the Monthly Newsletter report has not actually been received by the targeted individuals.

What would cause this to happen?  How can we fix it?


texts:
I want to transfer ACL settings from one site to an other.

How can I export/import ACLs via SQL?

Or is there any other way to do so?


texts: Could the email address at the time of a Bounce be frozen into the Mail Bounces report?

texts:
Mailing Reports > Mail Bounces (CiviCRM 4.7.9)

If the email address of a contact is updated, earlier Mail Bounces show the updated address instead of the address when the bounce occurred. The address that caused the bounce should be frozen into the bounce record at the time it is reported.
The current behaviour is especially inappropriate for an online newsletter where the contact may not have to enter a name. In this case, the Mail Bounces report (view) itself shows the edited email address, not the original, in the first column.
Is anyone else bothered by this?


texts: How do I correct mismatched Timestamps for MySQL and PHP without access to server?

texts:
I'm using civiCRM 4.6.2 under Wordpress.

The PHP and MySQL timezone settings are reported as incompatible, MySQL as 12:38 (which is the current clock time here in Zurich) and PHP as 10:38. However, according to my ISP, PHP is also correctly set to use Zurich time. Is there any way either to suppress the warning (which comes every time I start up civiCRM), or to correct the settings – NB: I do not have any programming access to my ISP.

I haven't noticed any problems cuased by this incompatibility.


texts:
We frequently try to match facebook event attendees to contacts in our database in order to send targeted emails to the person. By matching them to our database we know a lot more about the people (e.g. geolocation to include reference to an elected representative). The process in civi to do this is cumbersome. We take the list of people from facebook (names only) and assign an external ID, then import the list to civi. We assume that names are unique (a somewhat reasonable assumption for our database). Following this process we want to free up the contact's external ID field to allow the next import to run without having to manually de-dupe anyone who has an external ID previously set.
How can we either:

Do this without external IDs
Reset the external ID to null

We are using wordpress 4.4.1 and civi 4.6.10


texts: How do I attach documents to a message template? Am I overlooking an "attach" button?


texts: How do you set the displayed text of a custom field ("view-only")?

texts:
I am using Drupal and I have an extensions that I am running this code on.

I've seen several threads attempting to help with this. I haven't found any that really make it clear. From what I understand I set a hook, then update the value.

I have a custom field that I have set to "view only". This particular field is on a contact. When the contact is viewed I want the text I have generated to display for that field.

How do you actually do this? What hook? How do I update the displayed value? What specific API call?


texts: URGENT : Stripe.js token was not passed! Report this message to the site administrator. (on civicrm 4.7.20)

texts:
I recently upgraded civicrm from 4.7.16 to 4.7.20 (on Drupal 7.56).

Now, when I use a Contribtion Page to make a payment, I get the following message : "Stripe.js token was not passed! Report this message to the site administrator." (tested on different existing Contribution Pages with same result).

I already had this same message in the past, for webform embedded payments (see Stripe.js token was not passed! (using Webform Integration)), but it was solved by a fix (https://github.com/drastik/com.drastikbydesign.stripe/pull/159/files).

But this time, the problem happens on simple Contribution Pages (which previously worked).

To be complete, since this upgrade, I have had an other problem on webform embedded payments (submitted here : Stripe extension fails with a new account (civi 4.7.20)) :

old webforms continue to work properly (I don't have this stripe.js
message and the payments succeed) (but for how long ?)
new webforms based upon new stripe Accounts send the payment to an other (existing) account.

May be both problems are linked ?

FYI, I use Stripe Extension 4.7.1 and I am not a programmer

Too late for me to go back to 4.7.16, any help is very very welcome and urgent.


texts: How can I tell if Remote Profiles are in use?

texts: Remote profiles are difficult to configure safely, so they're turned off by default on modern CiviCRM installs.  However, if I have an old CiviCRM installation, how can I tell if this feature is in use before I turn it off?


texts: Where did my price field go? It's missing!

texts: After a recent civicrm upgrade, one of my pricefields in a price set just 'disappeared'. There were no errors showing and the pricefield appeared to be correctly configured.


texts: Civi Postcode webform widget not updating

texts:
We've got the civi postcode extension and related weborm widget integration module installed on a site

Postcode look up works fine in civi, and on existing configured forms

Trying to update a postode field from text to look up using the change widget feature leeds purely to a blank screen

/node/xxx/webform/components/xx?type=civipostcode

Looking in the error log a notification occurs at the same time as trying to update widget  /autodiscover/autodiscover.xml- page not found

Anyone any ideas what could be casuing this
(civi 5.3.1, drupal 7.59)


texts: Database Syntax Error when attempting upgrade

texts:
I  have a website that is on Drupal 7 and I am attempting to upgrade the version of Civi from 5.10 to 5.13 but when I attempt to upgrade it, I'm receiving the following error:

Database Error Code: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-b_before_insert' at line 1, 1064

I have tried doing the upgrade through drush and also through the /civicrm/upgrade URL with the same error.

It's a bit of a long shot but I was hoping that someone has seen the error before and knows of a fix or how I can determine exactly what is going on.

Taking a look at the debugging information, I can see it has something to do with triggers:

DROP TRIGGER IF EXISTS civicrm_saved_search-b_before_insert [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-b_before_insert' at line 1]


texts: Search builder - Cant find find Participants in more than one event

texts:
Im trying to find people who have attended all 3 of our last 3 annual fund raising dinners.

search for participants in "dinner 2018" - get results
search for participants  in "dinner 2019" - get results

Search for participants "dinner 2018" AND "dinner 2019" - get zero  (and that's wrong cause I'm one of many who are showing as having been to both)

The same error occurs using event ID

I cant get the event start date to return sensible answers (not sure whats going on there  tbh)

I know I can get the correct answer using groups but thats adding another step in the process each year and Id rather avoid that

any suggestions please?


texts: Has any work been done to integrate Zoom and CiviCRM

texts: Outcome would be something along the lines that an attendee of Zoom meeting (eg Zoom id 234) gets added as a participant to Event X (which would have a custom field with 234 in it to help link to Zoom data)


texts: The good news,  I'm returning to the cloud provider that I used for many years. (I left because I merged my business with another firm.) Here's where I'm a little uncertain. The provider I've been using for the past few months runs their VPS farm with Virtuozzo, which has been incompatible with other tools I use for server admin (not web development). I have a handful of odd behaviors and buggy behavior that I can't quite fix. I'm wondering if this might be the servers. Has someone else seen oddball stuff while using similar VPS  environments? Might I expect these problems to go away when we move? (One user is tied to the virtuozzo system and if that's our problem, I need to get them away.) Thanks in advance.


texts: No Text Alignment option in CiviMail WYSIWYG Editor

texts:
We are using civi 4.7.29 on wordpress 4.9.1
Some of our Administrators are not going to know HTML when they are creating a new mailing.  I noticed there are not any text aligning options in CiviMail for Left Align, Center, Right Align. Shouldn't there be?  Am I forgetting to install something?


texts: Hiding Some Events From Public View but Visible to Some Users

texts:
I asked a similar question over 2 years ago and there was one possible solution that was offered, however, it did not work for me. I wanted to revisit this to seek some guidance.

Our organization has a variety of Public Events that are visible on the front end's listed of upcoming events. Our organization also has a variety of private events for our team members only that I do not want to be displayed on the public calendar.

Is there a way to have all events listed in Upcoming Events but have some of those only visible to a certain group of logged in members (our staff).

For example, the public facing page, the visitor would see:

Public Fundraiser Event

Public Training Program

Public Fundraiser Event

Public Fundraiser Event

And then when one of our team members (assigned to a group in both Joomla and CiviCRM), the page would look like:

Public Fundraiser Event

Private Team Meeting

Private Training

Public Training Program

Public Fundraiser Event

Private Meeting

Private Meeting

Public Fundraiser Event

The solution that was offered previously was using ACL's to show all events to the particular group. This doesn't work (for me) on the Front End upcoming events.


texts: Best way to cleanup CiviMail database tables?

texts:
On CiviCRM installations that use CiviMail extensively, the mailing tables can become pretty big. For example, I'm looking at a database with a civicrm_mailing_recipients table that has 4 million entries since 2011.

Assuming that the stats from old mailings are not relevant anymore, what would be the best way to archive the data?

Ex: we are in 2019, stats from before 2016 could be archived elsewhere.

I did a bit of digging and found this old forum post which sounds like a good start. There was also this PR back in 2016 that helped avoid breakage of click-through links when mailing data was deleted.

Related SE question: Does archiving mailings do anything in particular.


texts: Why are taxes calculated incorrectly when "other amounts" enabled on contribution page?

texts:
CiviCRM 4.6.5, Wordpress 4.2.3

When I create a contribution page, I choose the financial type on which there is my taxes financial account linked.

The amount that the user can pay is decided by the user. So there is only "Allow other amounts enabled".

The tax financial account have a 14.975% rate.

When I put my page online and I try to make a contribution, I get a tax amount of 0.15% instead of 14.975%.

When I make a contribution manually with the same financial type, the taxes are calculated the right way.

If I put a precise amount with "Allow other amounts" disabled, the taxes are also calculated the right way.

Thanks for helping!

Whatever amount I put, the "Total tax amount" is equal to the Tax rate.


texts: Membership Status not updating beyond Grace to Expired

texts:
The Grace status is set to end 2 years after Membership End Date. At that point the Expired status should kick in. The Grace status is activated correctly at Membership End Date, but that status is NOT ending at the "after 2 years" mark.
The Scheduled Job for updating membership status is executing OK.
Some of our memberships are now 3 years or more past their End Date - does the system recognise those old dates and update status accordingly? Or should these be manually overwritten?


texts: My Scheduled Jobs Log doesn't display a date or time

texts:
I kept checking the joblog and thought, wow, it sucks that it doesn't display the timestamp but just now I looked more closely and see that there is an actual "Date" column and all log entry values are blank for that field.

Sure enough all of the values for run_time in the job_log table are NULL.  I updated one and refreshed the job log display in Civi and it showed up.

What is keeping the run_time value from being set??

UPDATE #1 : Well lookie there.  What in the world would cause this schema?  I didn't do anything special that I can recall.

mysql>  describe civicrm_job_log;
+-------------+------------------+------+-----+---------+----------------+
| Field       | Type             | Null | Key | Default | Extra          |
+-------------+------------------+------+-----+---------+----------------+
| id          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| domain_id   | int(10) unsigned | NO   | MUL | NULL    |                |
| run_time    | timestamp        | YES  |     | NULL    |                |
| job_id      | int(10) unsigned | YES  |     | NULL    |                |
| name        | varchar(255)     | YES  |     | NULL    |                |
| command     | varchar(255)     | YES  |     | NULL    |                |
| description | varchar(255)     | YES  |     | NULL    |                |
| data        | text             | YES  |     | NULL    |                |
+-------------+------------------+------+-----+---------+----------------+

UPDATE #2 : I just performed a completely new Drupal 7.56, CiviCRM 4.7.29 install and before I did anything else I checked the schema for civicrm_job_log and it has the exact same problem - NULLable, without Default: CURRENT_TIMESTAMP, and without attribute on update CURRENT_TIMESTAMP.

Upon a more direct web search I ran across "The date is no longer kept in the scheduled job logs" in the CiviCRM Jira from Feb/March 2017.  It has been closed by Nicolas as "most probably not related to CiviCRM". Not buying that unless somebody can explain.

Closed JIRA

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

I just looked at a Civi 4.7.27 install I have and it does not have the same problem.

For now I guess I'll modify them manually but I'd like to know if anybody else running 4.7.29 (perhaps new vs upgraded) have the same problem.


texts: Can't get hook_civicrm_contact_get_displayname to work

texts:
I want to append a custom field to the display name.  To try it, I used the example.

function ccas_hooks_civicrm_contact_get_displayname(&$displayname,  $contactId, $objContact) {
$displayname = $displayname . ' - '.$contactId;}

No errors but what I see on the View Contact form doesn't change.

I added a watchdog thing after it

watchdog('hooks',"callhooks_civicrm_get_(&\$fields, &\$files, &\$form)<pre>\n\$display_name=" . var_export($displayname,1) . "\n\$contactId=" . var_export($contactId,1) . "\n\$objContact=" . var_export($objContact,1) . '</pre>');

In the log I can see it appending the contact id after the display name but still it only shows the name.  So do I need to do something additionally to actually get it to show it on the form?

Currently using 4.5.5.


texts:
I have set up a donation page linked to Paypal. (https://contacts.network211.com/civicrm/contribute/transact?reset=1&id=6)

When I attempt to use the contribution form as a non-logged in user, I enter my donation amount and email address. When I hit Confirm Contribution, the system returns to the contribution form with all fields empty. No error message or indication of what is going on.
The contribution works if I am logged into civi as an authenticated user.

Settings

I am not asking the user for any additional information, ie. not using a profile
The form is set as active/online
Under drupal permissions, I have CiviContribute: make online contributions selected
I have looked in both Drupal and Civi logs and don't see anything that seems to point to the problem.

This is very frustrating!

(I asked the same question earlier with no resolution. How to allow contributions from non-members This link also yields no answers Why can't anonymous users make contributions?)


texts: CiviMail - Syntax error, 40% emails bounced

texts:
Have read other questions on this but haven't read any solutions.

Using Drupal 7.64 with CiviCRM 5.10.4.

Sent out a bulk email (newsletter) using CiviCRM last Friday to a group of 2100 members. This is our first bulk email of this size using CiviMail (previous emails have gone to <200 users), and most emails were imported into CiviCRM from other databases (Mailchimp, internal spreadsheets, etc). So there is a likely possibility that some of the email addresses that are now in CiviCRM need to be cleaned, are no longer used, have input errors from the spreadsheets, etc.

Just checked the report today and saw a 40% bounce rate, and most of the bounce rate reasons are listed as "Syntax" with no further information, when I look at the Bounce Report from the mail in CiviMail.

The recipients have a variety of email providers - hotmail, gmail, yahoo, work servers... and 60% of the emails were delivered to a variety of email providers as well.

Did some digging into my server / cpanel and looked at the mail delivery report, and saw this as a snippet from the mail delivery report. Note that Caitlyn's email was listed as both an email to be discarded (red), and also an email that was accepted (green) (it was also listed as yellow, an email to be re-attempted later).

Does anyone know how this can be fixed? Or what the issue is? I'm also wondering if there's a way to resend the newsletter only to the email addresses that bounced.

I know our emails are "staggered" (not sure of the correct term), where a small amount of emails are sent every 5 minutes, so they're not all going out at once.

I also exported CiviCRM's ConfigAndLog file from the file manager but not sure if there's anything of worth in it since it's so lengthy and way beyond my scope. But let me know if it might be useful and I can upload it here.


texts: Assigning case role to contact in webform- not updating as expected

texts:
I've been trying to update a case webform so that form contacts are assigned to a given role.

I had expected that by creating roles under relationship types and then including the role in the case type settings in Civi, that the webform case tab would automatically update to offer the new roles for allocation.

It isn't doing this.
Options available in webform

Options allocated in case type

Currently using civi 5.3.1 with webfromcivicrm 4.2.26

Have got this working on another site using civi 5.8.2 and webformcivicrm 4.2.24


texts:
I am getting an error on my development site and i have tried everything to fix it but had no Luck.

***ERROR***
message:            unknown relationship create error Argument civicrm_relationship is missing.
code:
exception:          CRM_Core_Exception Object
(
    [errorData:CRM_Core_Exception:private] => Array
        (
            [error_code] => 0
        )

    [cause:protected] =>
    [_trace:PEAR_Exception:private] =>
    [message:protected] => unknown relationship create error Argument civicrm_relationship is missing.
    [string:Exception:private] =>
    [code:protected] => 0
    [file:protected] => /var/www/vhosts/site.co.uk/httpdocs/sites/all/modules/civicrm/CRM/Contact/BAO/Relationship.php
    [line:protected] => 139
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /var/www/vhosts/site.co.uk/httpdocs/sites/all/modules/civicrm/CRM/Contact/Form/Relationship.php
                    [line] => 565
                    [function] => createMultiple
                    [class] => CRM_Contact_BAO_Relationship
                    [type] => ::
                    [args] => Array
                        (
                            [0] => Array
                                (
                                    [hidden_custom] => 1
                                    [hidden_custom_group_count] => Array
                                        (
                                            [] => 1
                                        )

                                    [qfKey] => bf18a1feddecedf9bb2d0998921e2ecb_7909
                                    [entryURL] => https://site.co.uk/civicrm/contact/view/rel?cid=140&amp;action=add&amp;reset=1
                                    [relationship_type_id] => 27
                                    [related_contact_id] => 137
                                    [is_current_employer] => 1
                                    [start_date] =>
                                    [end_date] =>
                                    [is_active] => 1
                                    [is_permission_a_b] => 0
                                   ...

I have deleted the relationships re-added them but have had no Luck.

Thanks


texts:
This appears to be missing. I can't get CiviCRM to execute custom PHP code.

/CRM/Core/Config/Runtime.php at line 139 references $this->customPHPPathDir but there is no such member variable of this object. Because of this customPHPPathDir is not added to the include path.

The comment on the previous line is FIXME.

Is this a bug?


texts:
I have a Drupal View pulling in data for contacts from generic CiviCRM fields as well as Custom Fields. For some reason sometimes when I load the view the generic fields populate properly but the custom fields don't populate. Once I clear Caches, everything populates properly.

Users who log in see this view and cannot clear caches. Any idea how I can fix this?

See screenshot where I point out the populated fields (some are blocked for privacy) and look at the other fields that remain as a token


texts: Inputted activities can not be displayed for one specific user but can be seen by others

texts:
A Civi user with Manager's rights asked this:

The activities part of a volunteers file on Civi: although it may say 2 activities in the tabs, when I click on it, it says that there are no activities.

However when another Manager and myself (Administrator) log in, the activities are visible.

Why is this occurring?


texts: HELP CiviDiscount Auto-Apply feature not working!

texts:
I'm using cividiscount 3.3 on civicrm 4.7.16 on Joomla 3.6.5. I created a discount code for current members to be applied automatically only it does not apply automatically. I can enter it manually. I've attached the code configuration, can anybody tell me what might be wrong? By the way I reviewed similar posts and some of the older posts are describing a patch but I'm thinking it was resolved in the latest version, 3.3? If not can someone please help?

Thanks]1


texts: Membership edit screen defaulting membership dates to 12/31/1969?

texts:
I recently updated from CiviCRM 5.5(.2?) to 5.14.1, and now if I go to edit the membership record for a contact (or add a new membership record), the Member Since, Membership Start Date, and Membership End Date fields all show 12/31/1969. I can put correct dates in there and save the record just fine, but for an existing membership that I'm editing, it should (and used to) show the dates that are currently stored in the database, and which show up correctly on the contact's Membership tab.

I'm running it under Joomla 3.8.12 with PHP 7.1.1 on IIS 7.5. Honestly, I have no idea where to even start looking to figure out what the heck is going on.

Has anyone else seen this, or have any suggestions on where to start?


texts: Why is my Contribution Detail Report (native CiviCRM Core report) not accurate?

texts:
Version: CiviCRM 5.7.4/5 (patched for Contact images)

A Donor sent in a chq for $100 - Staff entered originally as a Donation. Then Edited the Contribution to make it a Memoriam Donation. CiviCRM generates the three entries - see below:

Issue: in Contribution Detail Report this Donor is listed as having donated: $300 - please see below. So somehow sums up the absolute value of the three amounts/financial account transactions that are linked to the single Contribution.

Question: why? Columns checked: Donor Name, Donor Email, Donor Phone, Financial Type, Payment Type, Check Number, Transaction ID, Date Received, Amount, Credit Card Type, Country

Update: there are no soft credits on this Contribution and the report is configured to pull Contributions only


texts:
civicrm.org is currently down (no big deal in itself) but it has highlighted the fact that my site is trying to contact it and timing out.

This is causing a huge slowdown when logging in (and at other times) but what concerns me is why it is trying to contact civicrm.org at all?

The error I'm getting is that extensions could not be downloaded, but I'm not trying to download an extension. I suspect this is the stock error message you get if the site tries to contact civicrm.org for any reason and fails.

Unable to download extension from https://civicrm.org/extdir/ver=4.7.14|cms=Drupal/single. Error Message: Failed to connect to civicrm.org port 443: Connection timed out

It seems the site is calling home for some reason. I have a vague memory of clicking something like "allow site to send stats to civicrm.org" but how would I find that setting again to disable it?


texts: Enable multiple event registration for same purchaser/participant

texts: Currently if a participant purchases a ticket online and then returns at a later date to purchase another ticket, CiviCRM won't allow the same individual to purchase the 2nd ticket under their name. The purchase could register another participant and complete the purchase, but for individuals that want to purchase more than one time under their name, it doesn't seem possible. I am not positive, but I believe this is due to the unsupervised dedupe rule used by CiviEvent. Is there a way to allow the same purchaser to purchase more than one ticket at more than one time under their name online?


texts: Walklist Splitting by Street and Odd/Even

texts:
In the configuration for CiviEngage, I have selected options to have a group break between each street and between evens and odds, and then for there to be a page break between groups.

How do I generate a walk list that follows these rules? When I go to Campaigns > Campaign Reports and then print a report from the Survey I want, it gives me a list that's organized properly - by street alphabetically and then by odds/evens - but with no page breaks. The page breaks are critical, of course, to organizing the walk list in a way that makes geographic sense.


texts: Civimember Add Membership Type drop down list not available

texts:
From Administer, Civimember got to Membership Types screen, then click on 'Add Membership Type'.
Click any field with a drop down and the drop down list does not show. Close the screen and the contents of the drop down list, from the 'Add Membership Types' screen, is visible.
It aseems that the drop down list may be appearing in a lower layer.
What do I have to do to get them upfront and available for selection?
The drop down lists are populated, were available and functioned correctly when system was installed and three types were added. Since then the lists have not been available for selection.
I am not sure but I suspect the original 'Add Memberships Types' screen was different to the current screen that is avaiable. At the top of the Memberships Types screen is the guide ' CiviCRM » Administer CiviCRM '. I am sure the first time it was used that guide had a third title such as ' CiviCRM » Administer CiviCRM >> Add'. That third title does not appear anymore when the Add screen is opened.
Using Firefox 55.0.3 on Windows 10
Many thanks in advance


texts: Do volunteers have to be associated with an event?

texts: I can see volunteers related to event management, but what about managing volunteers for organization roles like marketing, accounting, etc. ?  Perhaps there is a hack to create a dummy event, but wondering if there is a cleaner approach using the civicrm volunteer module.


texts: Navigation Menu Gone after WordPress Site Transfer

texts:
Version 5.15.1, on WordPress 5.2.2.

Transferred our site to a new host, and everything seems to be OK -- I can search contacts, navigate various system settings, etc. But the main navigation menu is gone. I've double-checked that it should be replacing the WP menu at the top, and I have run 'Cleanup Caches' and 'Reset Paths.' I've also installed the CiviCRM Admin Utilities plugin and reset the menu with this, no no avail.

'Reset Paths,' however, gives me the following feedback -- is this a clue?

  Beginning site move process... WARNING: The setting
  (userFrameworkResourceURL) is overridden and could not be reverted.
  Template cache and upload directory have been cleared. Database cache
  tables cleared. Session has been reset.

As far as I can tell, the userFrameworkResourceURL is correct anyway. Where else should I be looking?


texts: Membership tokens missing after upgrade to civi v5

texts:
I would like to use the membership.fee token in a mail. However, it isn't displayed in the list of tokens the mailer view offers and it's not working when I use it manually. I saw a suggestion to use a membership context, but I'm not sure what that means exactly. I've tried "Find members", saving the list of contacts to a dynamic group and selecting them as recipients, but this won't work either.

I'm running civicrm 5.18.0


texts:
I just recently upgraded to Civicrm 5.9.1. I had used the Mailchimp extension in the past in test mode previous to our current Civicrm upgrades, and now want to implement it. I was behaving weirdly after the upgrade, so I uninstalled it and then reinstalled it.

I have the newest 2.0.1 version installed, the permissions should be correct since I've assigned all user roles to the Mailchimp: allow webhook posts, and I've verified the webhook is running (doing a Mailings -> Mailchimp settings -> Save and Test responds that the API is returning the correct information from Mailchimp). We're still running Wordpress 4.9.9.

When I attempt a manual sync in one of the Mailchimp sync choices under Mailings, I get a description screen, but no ability to do anything. Has anyone else seen this behaviour or have insights?

There's nothing in error logs that indicate anything is happening with PHP. We're running PHP 7.1.26.


texts:
Not sure where I went wrong.

I recently installed the CiviCRM WordPress plugin.

I also installed a number of other plugins, but one of them that was installed after Civi was an SSO one.

I wouldn't think this would negatively affect anything, especially Civi, but apparently it did!

I've tried deactivating the SSO plugin, and seeing if Civi would work, and to no avail.

I even tried deactivating, deleting, and re-installing the Civi plugin 3 times. Still nothing.

As shown in the image, I get the following bit of text on the screen when I go to the CiviCRM tab in my dashboard:

Configure Your Dashboard
Refresh Dashboard Data
Welcome to your Home Dashboard
Your dashboard provides a one-screen view of the data that's most important to you. Graphical or tabular data is pulled from the reports you select, and is displayed in 'dashlets' (sections of the dashboard).

Have absolutely no idea what I'm doing wrong. I really would rather not do a fresh install of WordPress... I already have quite a bit of other things set up, custom styling on my front end, etc.


texts: Contribution form displaying in footer of WordPress site after form submission

texts:
On a Wordpress site which uses the theme "Enlightenment" I have used civicrm shortcode to embed a civi Contribution form on a wp page. All is well until I click the Confirm Contribution button.. the next page that is returned (Contribution confirmation page) has the form results replicated in the wp/enlightenment footer

a part of the footer as it appears before contribution submission: http://imgur.com/UaFsXKK

same part of the wp footer as it appears after submission..
http://imgur.com/Sujo2ht

I've studied the page source for these two cases and it appears that civi's

It seems that the problem is related to the civContribution webform submission - any ideas on why the proper style inheritance would be lost after form submission and how/where I can fix this problem?

I realize this is a case of Enlightenment probably doing something the civiContribute doesn't expect but since all is well before form submission I suspect that there could be a civi way to fix this.


texts:
What updates a smart group? Is it all based on the cron/scheduled job that runs updating the group members based on specific criteria?

Additionally are hidden smart groups updated when the cron/schedule job runs or are hidden smart groups not included when smart groups are updated?


texts:
In the case of a monthly membership which is tied to a recurring monthly CC payment, if the payment fails once, there is no way to reuse the same recurring payment for the membership.
The only solution I have is to cancel the existing recurring payment and renew the membership and reenter the CC. Is there a better way?

The other issue is that I can only enter a new membership from today so if I am doing this 10 days after the membership payment was due, I either lose 10 days of revenue or I have to issue an invoice for the missing 10 days which is not ideal.

Looking for a workaround that helps avoid these issues or an extension that solves them... Any ideas?


texts: Multilingual and multidomain: "unknown column" DB error. How to set preferred language for child domains?

texts:
I am running CiviCRM v.5.4.0 in a WordPress (v.4.9.9) multisite. The WordPress main site is CiviCRM Domain_ID 1, and each WordPress child site has a different CiviCRM Domain_ID. This has been working fine without CiviCRM multilingual support enabled.

Because different child sites need to use different languages (French, Spanish, German, etc.), I enabled "Multiple Languages Support" on the "Settings - Localization" page (menu "Administer... Localization... Languages, Currencies, Locations"). After enabling this, the main site (Domain_ID 1) continued to work fine, but when I navigated to a child site, I got an error. Digging down, I found it was a database error: Unknown column 'v.label' in 'field list' for table civicrm_option_value. Inspecting the DB schema, I saw that the table had a field named value_en_US rather than value. The SQL query was SELECT v.label as label ,v.name as value, v.grouping as grouping FROM civicrm_option_value v, civicrm_option_group g WHERE  v.option_group_id = g.id
AND  g.name = 'languages' ... (clipped). The SQL was not constructed with the right database field name suffixes (a default locale for the child site?).

Inspecting more code, I could not readily see where the field suffix for the child site was supposed to come from. For the time being, I disabled the "Multiple Languages Support" support on the main site, and now the child site works again.

For the child site, the error occurred on every WordPress page, and the WordPress admin pages would not load at all due to a cascading error. So there was no way to get into the CiviCRM admin pages to change settings for the child site once the Multiple Language Support was switched on for the main site.

At the end user/administrator level, how can I correctly and successfully enable multiple languages support for both the main site and the child sites? It seems the database schema itself is fine, but there's a locale or language setting missing for the child sites, preventing CiviCRM from successfully initializing.


texts: How can I extract email addresses from a Group?

texts: I've created a Group of individuals and I would now like to extract all of their email addresses.  Is there a way to do this? When I view the list of individuals in the Group I can partially view the email addresses but not the full addresses. I've set the Group up so we have a list of our current donors and I want to email them but not via CiviCRM.


texts: iATS Extension Working, but Throwing Errors

texts:
iATS 1.5.3 is throwing the following errors (1.5.0 was too) on Civi 4.7.10 running under Drupal 7.50 on CentOS:

Notice: Undefined index: config_backend in _iats_civicrm_domain_info() (line 202 of /home/ourbase/public_html/wcc/sites/default/files/civicrm/upload/com.iatspayments.civicrm-1.5.3/com.iatspayments.civicrm-1.5.3/iats.php).
Notice: Undefined index: config_backend in _iats_civicrm_domain_info() (line 202 of /home/ourbase/public_html/wcc/sites/default/files/civicrm/upload/com.iatspayments.civicrm-1.5.3/com.iatspayments.civicrm-1.5.3/iats.php).
Warning: simplexml_load_file(http://wcc.ourbase.us/sites/default/files/civicrm/upload/com.iatspayments.civicrm-1.5.3/com.iatspayments.civicrm-1.5.3/info.xml): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in iATS_Service_Request::iats_extension_version() (line 728 of /home/ourbase/public_html/wcc/sites/default/files/civicrm/upload/com.iatspayments.civicrm-1.5.3/com.iatspayments.civicrm-1.5.3/CRM/iATS/iATSService.php).
Notice: Trying to get property of non-object in iATS_Service_Request::iats_extension_version() (line 729 of /home/ourbase/public_html/wcc/sites/default/files/civicrm/upload/com.iatspayments.civicrm-1.5.3/com.iatspayments.civicrm-1.5.3/CRM/iATS/iATSService.php).

Transactions seem to go through, so my focus is on getting these errors to not display. Either by correcting the errors or suppressing the notifications. In regards to the latter, I have error reporting turned off everywhere I'm aware of (php settings in cPanel, civicrm itself)


texts: Any new functionality to sync smart groups to Drupal roles?

texts:
When last I checked CiviGroup Roles Sync did not work with Smart Groups. Has this changed with later versions (I'm on 5.17).

There were some workarounds discussed back in 2017.


texts: When a Case is set to Closed we would like all un-Completed Activities on the Case to have their Status changed (eg to Cancelled

texts:
anyone have a working model of this. we thought about drupal/civi rules but may just add in an extension.

seems to us that it could be quite a generic solution, after all, when a Case is Closed you don't want to keep finding Activities that may be eg Scheduled


texts: CiviCRM permissions get wiped out after each upgrade (except for Public and Super Admin user groups)

texts:
Is anyone experiencing an issue where all CiviCRM permissions in Joomla get completely reset (meaning all permissions items are set to "Inherit") after every CiviCRM upgrade? Only the Public and Super Admin user groups' CiviCRM permissions remain the same as before the upgrade.

Last time I saw this happen was just yesterday after upgrading to CiviCRM 5.10.4 on Joomla 3.9.3. Have observed this for a few months now, and decided I was tired of manually re-doing all permissions after each upgrade : (


texts: CiviCRM admin functions lost after installing Polylang

texts:
CiviCRM Version 4.5
WordPress Version 4.3.1

Everything was fine until we installed Polylang to make our site bilingual. Now, many man-hours later, we find that when accessing CiviCRM functions we get:

"You do not have permission to execute this url."

Unfortunately, the Polylang documentation states: "when
Polylang is de-activated, every URL loses the language information and thus all external links are broken".

We have found:

https://forum.civicrm.org/index.php?topic=32347.0

but do not know if it is a related problem.

Any help appreciated.