texts: CiviCRM Recommended Application Architecture

texts:
We are currently building a site that runs CiviCrm in a Wordpress container with a Kleo theme.

We are evaluating moving from Kleo to the Avada theme due to slow performance and maintenance issues keeping the site and its various components up to date.
Is this jumping from the frying pan into the fire, as the same will apply to any theme?

Do we decouple the theme and go for a bespoke set of site pages without a Framework / theme?
The site has public pages and private pages for Members.


texts: Smart Group dropping search criteria on save

texts:
I've searched the archives and see there are a number of posts pertaining to smart groups not saving criteria, but it seems those were bugs addressed in updates, and we are running the latest version of CiviCRM (5.9.1).
I have smart group made up of organizations whose membership is current (our memberships are company-based). However, I can't get the smart group to save the "Is a current member" search string. Instead, every time I update and save, it drops that setting and goes back to just "Contact Type In Organization" as the only criteria. This happens regardless of how I try to create or edit the smart group - it drops all selections from the Memberships tab. Is there a known bug or some other issue that could be causing this?
Edited to add - the smart group count is also not updating when clicked - all of the smart groups still say "unknown." Could this be a caching issue?
Edited 6/17/2020 - still observing the same issue on CiviCRM 5.25.0. Interested to know if anyone else is having this problem.


texts:
What is the status of the CiviCRM rules extension? I have read a few blog entries but not sure when it will be ready.

From what I have read, it is supposed to work much like the Drupal rules module but works from within CiviCRM


texts: How can I make it easier for users to generate the reports they need?

texts:
I am working with an organisation that uses CiviCRM to record information about their clients.  They need to generate reports on a quarterly basis that summarise their work with clients.  The reports need to segment the data by factors such as age range, gender, ethnicity, postcode etc.

None of the standard reports generate the information that they need so they use advanced search to obtain the figures for the reports.  This gives them the information they need however it can be quite tricky to set up the appropriate searches. They also need to run the search several times for each age/gender/ethnicity etc.

Some examples of the types of reports they need (all figures are for the last quarter):

number of clients referred - split by ward
number of clients supported - split by ethnicity and gender
number of clients supported - split by age range (e.g. 16-17, 18-19, 20-25, etc.)
number of hours of support provided
number of sessions delivered per ward

How could reporting be made easier for them?


texts: is there any insights on installing civicrm on mariadb with data encryption turned on? Is it workable? Thanks.


texts: How to add the Recent Items stack (block)

texts:
I just watched a youtube tutorial on how the basics of CiviCRM. The video showed a recent items list on the left of the page. My CiviCRM does not have that. Is there any way I can add it? It would be extremely helpful.

Thanks,
Becky


texts:
We are in the process of setting up some renewal reminders for lapsed members. The reminder is set to be sent 7 days after the membership end date.
What I wanted to check is whether this reminder will be sent to members whose end date is exactly 7 days before or if it will be sent to members whose end date is 7 days or more? i.e. will it be sent to members that expired 8 days ago, 14 days ago, 2 years ago etc?
I presume that it is an exact match. Could someone confirm this (and ideally point to where this is in the code)?
What I don't want to do is send the reminder to every former member including those that expired years ago.


texts:
I am getting the following error in CiviCRM:

M_Volunteer_Permission::check($permissions) should be compatible with CRM_Core_Permission::check($permissions, $contactId = NULL) in /home/xxxxx/public_html/wp-content/uploads/civicrm/ext/org.civicrm.volunteer/CRM/Volunteer/Permission.php on line 151

No idea why.

CiviCRM Version:  5.13.4
WP Version:  5.2.1
PHP Version:  7.2


texts: Importing Notes with external identifier

texts:
I'm trying to import notes into CiviCRM with only an external identifier. Inside the current database, the contacts are already assigned these external identifiers correctly within CiviCRM.

I was recently given a .csv file with three columns: Name, External Id and Note. I need to ignore the name completely because the name in this .csv file is a combination of Prefix, First ,Last and Suffix as one field. The names don't match up with my current records, because each part of a contacts name within CiviCRM is its own field. Also, I believe there are too many string variances in the combined name structures to effectively parse them out into 4 fields with code.

So with that information, I am trying to ignore the name completely and using the External ID and Note only in the import.

The setting I am using are:
Contact Type: Individual
For Duplicate Contacts: No Duplicate Checking
Dedupe Rule: Left blank

Field Mapping:
Name: do not import
Id : External Identifier*
Note: Note

Result:
9668 errors / 9668 rows
"Missing required fields: First Name and Last Name OR Email Address"

What is the point of an external identifier if CiviCRM still requires another identifier?

My real question is; How do I do an import with External ID only in the UI for individual notes? I am thinking about writing a PHP script to try and force the notes into the MySQL database, but setting up a custom script seems like overkill for something I thought would be trivial.

Note: I can't use email because many of the contacts don't have one


texts: Changes to Contributions that would break GiftMemberships Extension?

texts:
We have tried deploying the com.aghstrategies.giftmemberships extension to a 5.x CiviCRM.

The form PostProcess hook where all the magic happens is not working because the _contributionID is empty (but it is present) in the $form argument passed to the hook implementation.

Has anyone successfully deployed this extension on 5.x?

Can someone familiar with the changes to Contributions since 4.6 explain what is wrong with the approach the extension is using and what would be necessary to fix it?

Hook Implementation:
https://github.com/relldoesphp/com.aghstrategies.giftmemberships/blob/master/giftmemberships.php#L88

retrieval of contribution ID that is always null:
https://github.com/relldoesphp/com.aghstrategies.giftmemberships/blob/master/giftmemberships.php#L136


texts:
I have civicrm 4.6.5 running on Drupal 7.38 with the Mandrill 2 extension for bulk email.
I set up a webhook in mandrill to speak to civi and I sent a test bulk email (including fake email addresses) with mandrill to make sure it all works.
It all works fine except that Mandrill has been sending me 6 bounce notifications per ever since that email which included 1 fake email address.

mandrill posts this error under the webhook :
Error: POST to https://www.msite.org/civicrm/ajax/mte/callback?mandrillSecret=*********989c failed with 500:

Drupal posts :Notice: Undefined index: event in CRM_Mte_BAO_Mandrill::processMandrillCalls() (line 84 of /srv/bindings/.../code/sites/all/extensions/biz.jmaconsulting.mte-2.0/CRM/Mte/BAO/Mandrill.php).


texts: I'm sure this is a very obvious question but what type of database does CiviCRM use?  SQL Server, MYSQL, etc.


texts: CiviCRM Individual Contact Inherits fields from Organisation

texts:
I am wondering is it possible to Copy fields  from a Organisation Contact  depending on relationship?

For e.g. If there is a relationship between Contact A and Contact B can Contact B inherit fields from Contact A.

Contact A - Organisation
Contact B - Individual

E.g. If there is a relationship, Contact B Field "Address" will be inherited from Contact A.

Thanks


texts: Does the core Moneris payment processor work?

texts:
I have a US-based org that is exploring using Moneris with a CiviCRM contribution page. The core Moneris payment processor seems a little rough -- is anyone using it/does it work? The Wiki page for Moneris configuration mentions changes to the mpgClasses.php file but the link to the patch is non-existent. Are the required changes documented anywhere else?

I also notice there is a newer "replacement version" of the core files in process (by Alan Dixon), but apparently recurring is still "fragile" and it is not working for the US (yet). Will this version end up in core?


texts: What's the best way to import memberships and their associated contributions?

texts:
I have a load of Memberships to import. Each has a linked Contribution.

While I can import Memberships and Contributions separately, I cannot find a way to import the two together - in other words there does not seem to be an import routine in any version of CiviCRM which can create an entry in the member_payment table.

In the past I have done this through SQL, which is a bit fragile as a solution. I have been thinking of an API-based approach. But it seems strange if this has not come up before. I haven't even seen any code for this. Is there something out there which I am missing?


texts: Regression starting at 4.7.20 causes redirect to Drupal home page with Drupal error status displayed: "E-mail address field is required."

texts:
Not good, not good at all. This weekend discovered the source of new member join fails. Defect similar sounding to CRM-4998 "Setup a Personal Campaign Page - Account Information step is not working in Drupal OR Joomla with default Supporter profile" has bitten our site.

Drupal 6.x latest

CiviCRM 4.7.x latest

Our new member join process is rather complicated. CiviContribution + CiviMembership + CiviProfile + creating a Drupal CMS account. When I try to confirm a new member join, it lands me back at the site homepage with the same error message as CRM-4998 stated: "E-mail address field is required." There is one email address field on our new member join form, and I have it correctly populated.

Nothing shows up for the failing transaction in the CiviCRM.log file. Tail of the log is:

Jul 09 07:46:46  [info] Running task: Cleanup old files
Jul 09 07:46:46  [info] Running task: Begin Upgrade to 4.7.21
Jul 09 07:46:47  [info] Running task: Upgrade DB to 4.7.21
Jul 09 07:46:47  [info] Running task: Finish Upgrade DB to 4.7.21

Suggestions please where to begin searching.

I am thankful,

Michael Lueck


texts:
A customer of mine has a contribution page setup with a price set (different payroll options) and they have specific labels for each amount in the price set.

When I go in to pull a custom report, I don't see an option to pull the field label; is this possible to do?

Is it possible to include these labels in the custom report that we export?

Thank you!!


texts: Mailing labels - print: "TCPDF ERROR: Some data has already been output, can't send PDF file"

texts:
This one has consumed my entire weekend, and still we can't make mailing labels. Running Civi 4.7.15 on WordPress 4.7.2 ... successfully installed and tested wkhtmltopdf only to discover Civi doesn't use this app for mailing labels. Paths in TCPDF config appear to be good, and I haven't modified the code except for the config file (which I did after discovering the malfunction). Debugging shows no errors, yet every attempt to make mailing labels displays "TCPDF ERROR: Some data has already been output, can't send PDF file."

What might cause this?


texts: Donations Made with False Name and Address using Paypal WPP

texts:
A Membership payment was made successfully using our Contribute form with a new contact created such as:

name: fffff fffff

address:
asdadad 4
davie, FL 33328
United States

email:

jdchjffdjhf@gmail.com

Contribution says paid by Credit Card, and there is also a transaction/invoice ID.

Why is CiviCRM Paypal WPP processor allowing this contribution which obviously appears to be fraudulent? Is this due to our set up

Thank you.

Drupal 7 / CiviCRM 4.6.x


texts: Civicrm and wordpress user registration after admin approval

texts:
so the scenario is that i am using civi profiles for civicrm contact and wordpress user creation by enabling "WordPress user account registration option?" in profile's advance setting.

I am also using 2 other plugins to control access of wordpress users which are "Ultimate Member" and "User Role Editor". ultimate member plugin has a option by which when a user register it needs admin approval. i have selected that option but its not doing what it has to do. when ever a user register i automatically approves it.


texts:
I'm on version 4.6.11 of the CiviCRM plugin for WordPress, WP version 4.4.1.

I expect this has something to do with shortcodes, hijacking, and maybe some other things related that I'm having trouble understanding.  Here's what's happening:

I have created a WP page template called page-civiform.php.  It is intended to be used by site admins to create event registration pages and donate pages, and it has some custom fields and specific styling/branding.  Admins use the main content WYSIWYG editor to paste a shortcode from CiviCRM that creates their event registration form or donate form.  All is well, and these pages look good.

Then, once a user registers or donates, the URL of the very page is appended with a query string, and it appears to be retrieving the default page.php sidebar (which is called in page.php).  BUT, the body classes are not those of page.php.  Instead, the body classes are exactly the same as those of the previous page where the shortcode was pasted - that page which is using page-civiform.php template. That's a problem, because it ends up creating an unprofessional appearance with a wonky layout.

I created a page with slug 'civicrm' and in WordPress Base Page setting, it is set to use that page, which does indeed use page.php as its template. On top of that, per the answer here, I put a filter into functions.php file to specify using page.php. None of this appears to have any effect.  Removing that filter and changing the WordPress Base Page (to anything else) also appears to have no effect.

Seems the wires are crossed here.  I did see this issue, discussion of which sounds unpromising.

I need the Civi-generated pages to be style-able differently from the pages where shortcodes are pasted; I can't do that when the selectors are identical.

Could this issue be related? Is there a setting somewhere that I am unaware of?


texts:
I'm writing an extension to customize the create new activity page. I need to add the 'With Contact' address and phone number to the page. When editing the /civicrm/CRM/Activity/Form/Activity.php how do you get the address to propagate when the contact is selected? Here is what I'm trying to edit:

    ),
   'target_contact_id' => array(
   'type' => 'entityRef',
   'label' => ts('With Contact'),
   'attributes' => array('multiple' => TRUE, 'create' => TRUE),
    ),
   'target_contact_adress' => array(
   'type' => 'entityRef', //I'm guessing I need to change this line to call the address?
   'label' => ts('With Contact Address'),
   'attributes' => array('multiple' => TRUE, 'create' => TRUE),
    ),

Edit: To better explain what I'm trying to do. I'm creating a custom extension for an organization that uses the Activity assignment notification to email their volunteers that don't have access to the CiviCRM database contact information (Phone Numbers and Addresses) about their members. In order to do this I need to add two fields that pull this information when a contact is selected.


texts: Cannot access Group admin - missing API key

texts:
CMS: Drupal 7.56 (shared hosting at Siteground; cpanel/phpmyadmin access)
Civicrm version: 4.6.34 (followng problem follows recent update)

I (admin 1 - all civicrm persmissions) cannot access Contacts > Manage Groups. Receive the following screen message:

On selecting 'Return to home page' link, the following errors show:

Warning: Illegal string offset 'group_name' in CRM_Core_BAO_Setting::getItems() (line 332 of [path edited].../sites/all/modules/civicrm/CRM/Core/BAO/Setting.php).
Notice: Uninitialized string offset: 0 in CRM_Core_BAO_Setting::getItems() (line 332 of [path edited]/sites/all/modules/civicrm/CRM/Core/BAO/Setting.php).
Warning: Illegal string offset 'group_name' in CRM_Core_BAO_Setting::getItems() (line 332 of [path edited]/sites/all/modules/civicrm/CRM/Core/BAO/Setting.php).
Notice: Uninitialized string offset: 0 in CRM_Core_BAO_Setting::getItems() (line 332 of [path edited]/sites/all/modules/civicrm/CRM/Core/BAO/Setting.php).

Group contacts can be searched (through Contact > Find Contacts > enter group name in search box). Result provides url like:
base_url/civicrm/contact/search?_qf_Basic_display=true&qfKey=9f41ad4096614eb353cac129b335e58a_757 which indicates a valid key existing.

[Edit]: having logged out of CiviCRM and returned, receive following message (civi alert message in top right): "Count data for smart groups is not currently calculated. You may click Update Smart Groups to generate it. Be aware this can cause significant server load".

[Edit 2]: Drupal error logs show:

$backTrace = #0 /sites/all/modules/civicrm/CRM/Core/Error.php(446): CRM_Core_Error::backtrace("backTrace", TRUE) #1 /sites/all/modules/civicrm/CRM/Core/Invoke.php(57): CRM_Core_Error::handleUnhandledException(Object(InvalidArgumentException)) #2 /sites/all/modules/civicrm/drupal/civicrm.module(482): CRM_Core_Invoke::invoke((Array:2)) #3 internal function: civicrm_invoke("group") #4 /includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:1)) #5 /index.php(21): menu_execute_active_handler() #6 {main}

And:

$Fatal Error Details = Array ( [message] => id (value: 1006'A=0) is not of the type Positive [code] => )

Any pointers most gratefully received.

SJ


texts: Can I disable Notify Activity Assignees for some Activities and/or user levels and leave it on for other Activities/user levels?

texts:
We're on Civi 4.6.21 and Drupal 7.

Under Administer -> Customize Data and Screens -> Display Settings there is a setting - "Notify Activity Assignees - When enabled, contacts who are assigned activities will automatically receive an email notification with a copy of the activity."  - with a checkbox to enable the setting.

I want to be able to send e-mail notifications based on Activity type, or Activity Subject, or Campaign to which that Activity is linked, or Assigned To contact user level - so, for example, staff who are Assigned an Activity called Membership Signup (of a 'target' contact, the With contact) always receive an e-mail notification; but, volunteers who are Assigned an Activity of Card Signup, with Subject of Protect Puppies as part of a Campaign called Protect Puppies 2016, do not receive an e-mail notification of that Assigned Activity.

Sending e-mail notifications of Assigned Activities is really handy - but not desired in all use cases.

So - how can I disable Notify Activity Assignees for some Activities and/or user levels and leave it on for other Activities/user levels?

Thanks!


texts: CiviReport - Error when registering new Report

texts:
I've generated a new report in my extension, but when I try to register it with CiviReport, I'm getting the following DB error:
Database Error Code: Field of view 'sporti62_wp4.civicrm_option_value_en_CA' underlying table doesn't have a default value, 1423
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => INSERT INTO civicrm_option_value_en_CA (option_group_id , label , value , name , filter , is_default , weight , description , is_optgroup , is_active , component_id ) VALUES ( 41 , 'Dog Registry with Contacts' , 'dogregistry/contacts' , 'CRM_Dogregistry_Form_Report_Dog_Contact_Summary' ,  0 ,  0 ,  90 , 'Dog Registry with Contacts' ,  0 ,  1 ,  NULL )  [nativecode=1423 ** Field of view 'sporti62_wp4.civicrm_option_value_en_CA' underlying table doesn't have a default value]
[type] => DB_Error
[user_info] => INSERT INTO civicrm_option_value_en_CA (option_group_id , label , value , name , filter , is_default , weight , description , is_optgroup , is_active , component_id ) VALUES ( 41 , 'Dog Registry with Contacts' , 'dogregistry/contacts' , 'CRM_Dogregistry_Form_Report_Dog_Contact_Summary' ,  0 ,  0 ,  90 , 'Dog Registry with Contacts' ,  0 ,  1 ,  NULL )  [nativecode=1423 ** Field of view 'sporti62_wp4.civicrm_option_value_en_CA' underlying table doesn't have a default value]
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_option_value_en_CA (option_group_id , label , value , name , filter , is_default , weight , description , is_optgroup , is_active , component_id ) VALUES ( 41 , 'Dog Registry with Contacts' , 'dogregistry/contacts' , 'CRM_Dogregistry_Form_Report_Dog_Contact_Summary' ,  0 ,  0 ,  90 , 'Dog Registry with Contacts' ,  0 ,  1 ,  NULL )  [nativecode=1423 ** Field of view 'sporti62_wp4.civicrm_option_value_en_CA' underlying table doesn't have a default value]"]

)

I know it is likely related wp_globus plugin?  I do have two languages on my site - english and french.


texts: I need to test some contribution pages before they go live. Is there standard data or a procedure I use?  Specifically I need to verify that the donor receives an email confirmation of whatever type of contribution they made.  Thank you for your help.


texts: Extended Security Release confusion. Which version?

texts:
The information available about the Extended Security Release - https://civicrm.org/esr - states that "The latest release of ESR is version 5.7". However I can see via the system status page on a few of my sites that 5.13.6 appears to be available, but only as part of the Extended Security Release.
Can both of these bits of information be true?


texts: How can I make a filter to exclude someone who has a certain tag assigned to them? (or custom data field yes/no type)

texts:
I'm trying to set up a view (kind of an admin report view) which shows a list of members based on certain filters set up in the view. This is for a large homeschool coop.

membership type (exposed - user select which type)
membership status (current, new, grace)
filtering out those with Do Not Email option checked since this leaves us mostly with those attending our coop days (primary member and kids)
contact sub type (exposed - user can select adult and/or child)

I have two issues.

The first is that instead of checking for the Do Not Email option, I would much rather be showing Primary Membership Member. But then I have trouble showing the kids as well. I haven't yet learned enough about Views to figure this one out, but I'm getting there slowly but surely. Pretty sure I can figure this out eventually. I can live with current solution for now.

My main problem is that I need one more filter. Some kids in an otherwise active family no longer attend coop (gone off to college, whatever), so I have a Custom Data field to indicate that they are inactive. I have also tried a tag called Inactive Child.

I can't filter on either of these though. I set up a filter and set it to show all records that DON'T have the tag or the custom data field option checked and I get incorrect results for tags (shows people who have any tag at all, not just the one I chose and doesn't show anyone with 0 tags), or NO results (when I use the custom data field). If I set the filter to SHOW those contacts with those option(s) checked, it works. But I can't seem to EXCLUDE them from my results.

Pretty sure I am missing something with how to set this up correctly, but after about 7 hours of trying, I haven't figured it out.

Thank you!

Drupal 7.41
CiviCRM 4.6.11


texts: How to make tables with fixed header and left column - scroll vertically and horizontally

texts: In our use case we need to batch update participants with large tables - up to 45 columns and 20-50 rows. For this to have any hope of success we had to find a way of getting the table to scroll vertically and horizontally, while fixing the header and left column. How to do it? Read on...


texts:
We are switching to Authorize.net as payment processor.  The Invoice ID in CiviCRM is 32 characters.  However, Authorize.net's Invoice Number field is only 20 characters.  The Invoice ID when passed to Authorize.net is getting truncated.  Can the Invoice ID in Civi be shortened? to 20 characters?  If so, what is the impact on existing transactions?

We are currently on Civi 4.6 but will be upgrading to 4.7 within the next 2 months. On Drupal 7.


texts: Trying to migrate data from Drupal 7 to new install on Drupal 9

texts:
Isn't it possible to just copy tables of contacts, groups, mailings and their related data into the new install? I'm trying to figure out which tables contain essential data on contacts, activities, donations, etc. vs the ones that contain information on the site setup (like the civicrm_menu table, which I definitely want to leave behind, as somewhere over the years it got corrupted during an upgrade and has double entries and lacks a few entries as well).
Would this at all be a valid approach?


texts:
I have been learning a lot about bugs and issues with CiviCRM with my recent install on Wordpress.  There are areas of the Wiki, such as WordPress plugins/themes incompatible with CiviCRM that I have some workarounds to contribute.  However, I am unable to add them to the Wiki, could someone help me figure out what I am doing wrong?

When I try to login to the Wiki, I get the following error:

"Sorry, a network error occurred trying to log you in. Please try again, and contact your administrator if the problem persists."


texts:
I created a new profile that includes the field group, but when I do an advanced search using this profile, the column group is not displayed.
Why ?
I need a list with name, group membership.

If I put the group as public, then I see it, but not out in the report. I can not have a report with name and group. I have to do a custom field?

Thanks.
Marco Mapelli


texts: How can I switch off the CiviCRM print icon on public pages?

texts:
We set up a petition page, which all works fine.

In order to simplify the user experience, we want to "switch off" the CiviCRM printer icon.

Can this be done using the admin interface?
Or do we need to do some customization? (and what?)

Thanks,
Detlev


texts:
API chaining works well in Javascript and PHP. For example, I can retrieve a contact's email addresses using this code generated by the API Explorer:

Php

$result = civicrm_api3('Contact', 'getsingle', array(
  'sequential' => 1,
  'return' => "display_name",
  'id' => 41194,
  'api.Email.get' => array('return' => "email"),
));

Javascript

CRM.api3('Contact', 'getsingle', {
  "sequential": 1,
  "return": "display_name",
  "id": 41194,
  "api.Email.get": {"return":"email"}
}).done(function(result) {
  // do something
});

However, the drush command generated by the API explorer doesn't work:

drush cvapi Contact.getsingle sequential=1 return="display_name" id=41194 api.Email.get={"return":"email"}
# Gives me the contact just fine, but no email

Is there any way to coax drush cvapi into processing chained api calls? If it's not currently possible, is anybody working on it?

In the meantime, how can I help to correct the API Explorer so it doesn't produce non-working drush commands?


texts: Where do I find Apache error logs for sites that I installed with buildkit?

texts:
I installed a site with buildkit. Now I'm doing some dev work which is producing WSOD / 500 / "Internal Server Error" errors, but I can't find any logs about these errors.

I've looked in /var/log/apache2/ and don't see any recent logs there. Is there somewhere else that the log messages are going?


texts:
I have a Civi 4.4.4 install on a Drupal 7.37 and I want to upgrade both: the Drupal to 7.59 (which I think is the latest in D7?) and Civi to the latest 5.6.0 if possible. I am totally new to both of these products, but I've upgraded Wordpress before, if that experience will help me at all :P

I just saw a very recently updated post in this forum in which some people describe the process of making long-distance upgrades, going back and forth between upgrading Civi and upgrading Drupal to intermediate versions, alternating, and it sounds like it would be pure hell.

My question here is: should I do Drupal first, or Civi first? I realized that I'd better ask because whatever my intuition is might be wrong. I'm really hoping there will only be one upgrade each, since the "distance" is not that far off. Help is much appreciated.


texts: A week after upgrade whole site is erroring

texts:
Upgrading to the latest CiviCRM on a drupal based site didn't seem to be an issue.  About a week later, perhaps a change in PHP version, I noticed that my entire site gives this message now and nothing really works:
Fatal error: Class 'CRM_Extension_System' not found in .../public_html/sites/all/modules/civicrm/CRM/Core/PseudoConstant.php on line 1837

Any ideas as to what I may have done to cause this?  Thank you for all your help!

Regards,
Yasir


texts: Error: Cannot read unrecognized property CRM_Core_Config::$mapGeoCoding

texts:
I have just upgraded from CiviCRM 4.6 to 5.4.1. We are getting an error on our events pages

  Cannot read unrecognized property CRM_Core_Config::$mapGeoCoding

I have tried to search for a fix, but have been unsuccessful. I tried removing $config->mapGeoCoding from the core EventInfo.tpl as another post suggests, but I couldn't find this line in this file under core.


texts: Which UK payment processors are most recommended to use with CiviCRM? (aside from PayPal)?


texts: Dropdown Custom Field - Is this possible

texts: We would like to have the ability to use a dropdown as one of the custom fields linked to an activity. This would enable us to search on this field without mis-spelling causing problems on the future. Is this possible as I can't see an option for a dropdown when setting up a new custom field?


texts: Upgrade fails with CiviCRM_API3_Exception: "API error: Could not delete payment processor type"

texts:
In upgrading to 5.20+ an error occured while running the database Case upgrade scripts.

Deletion Error
There is a Payment Processor associated with selected Payment Processor type, hence it can not be deleted.

CiviCRM_API3_Exception: "API error: Could not delete payment processor type"

#0 /dir/wp/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Incremental/php/FiveTwenty.php(370): civicrm_api3("CaseType", "create", (Array:9))
#1 /dir/wp/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Incremental/php/FiveTwenty.php(289): CRM_Upgrade_Incremental_php_FiveTwenty::_processCaseTypeLabelName(FALSE, "7")
#2 /dir/wp/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Incremental/php/FiveTwenty.php(265): CRM_Upgrade_Incremental_php_FiveTwenty::_changeCaseTypeLabelToName(FALSE)
#3 /dir/wp/wp-content/plugins/civicrm/civicrm/CRM/Queue/Task.php(88): CRM_Upgrade_Incremental_php_FiveTwenty::changeCaseTypeLabelToName(Object(CRM_Queue_TaskContext))
#4 /dir/wp/wp-content/plugins/civicrm/civicrm/CRM/Queue/Runner.php(217): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
#5 /dir/wp/wp-content/plugins/civicrm/civicrm/CRM/Queue/Page/AJAX.php(52): CRM_Queue_Runner->runNext(TRUE)
#6 /dir/wp/wp-content/plugins/civicrm/civicrm/CRM/Queue/ErrorPolicy.php(106): CRM_Queue_Page_AJAX::{closure}()
#7 /dir/wp/wp-content/plugins/civicrm/civicrm/CRM/Queue/Page/AJAX.php(54): CRM_Queue_ErrorPolicy->call(Object(Closure))
#8 /dir/wp/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(250): CRM_Queue_Page_AJAX::runNext()
#9 /dir/wp/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:13))
#10 /dir/wp/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:5))
#11 /dir/wp/wp-content/plugins/civicrm/civicrm.php(1465): CRM_Core_Invoke::invoke((Array:5))
#12 /dir/wp/wp-includes/class-wp-hook.php(288): CiviCRM_For_WordPress->invoke("")
#13 /dir/wp/wp-includes/class-wp-hook.php(312): WP_Hook->apply_filters("", (Array:1))
#14 /dir/wp/wp-includes/plugin.php(478): WP_Hook->do_action((Array:1))
#15 /dir/wp/wp-admin/admin.php(254): do_action("toplevel_page_CiviCRM")
#16 {main}


texts: Joomla Backend (Admin), CIVI White Page after installation

texts:
I have a fresh Installation of joomla and civicrm:
civiCRM = civicrm-4.6.2-joomla.zip

The Installation went well, however I just receive a white (blank) page calling civicrm from the admin_>Components->CiviCRM

the related link: http://mywebsite.com/administrator/index.php?option=com_civicrm

I have tried already certain suggestions from the old "CiviCRM Community Forums", but could not find a working solution. Database and PHP Version is >5.

May be someone can give me a hint where to start to investigate. Thank you!

B ert

System Information

PHP erstellt für    Linux Thot03 2.6.32.12 #5565 Mon May 11 02:12:06 CST 2015 armv5tel
Datenbankversion    5.5.42-MariaDB
Datenbankzeichensatz    utf8_general_ci
PHP-Version     5.5.25
Webserver   Apache
PHP-Interface für den Webserver     fpm-fcgi
Joomla!-Version     Joomla! 3.4.1 Stable [ Ember ] 21-March-2015 20:30 GMT
Joomla!-Plattform-Version   Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Browsererkennung    Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Firefox/38.0


texts: Adding a dynamic “cover processing fees” checkbox to CiviCRM contribution form

texts:
I've seen other systems that allow the donor to check a box to cover processing costs, similar to this:

In researching whether something like this was possible with CiviCRM, this thread is the closest I've found. The solution there is to simply put a flat rate additional amount.

I'd love some guidance on how this could be implemented more dynamically (so the amount of the fee changes based on the size of the donation) as either a default contribution page, or a Webform-CiviCRM implementation. Anyone have an idea?


texts:
How do I request that LTS include a particular bug fix?

The issue in question is https://issues.civicrm.org/jira/browse/CRM-13287.  It's an issue for my site upgrading to 4.4 now and presumably 4.6 once it's officially the LTS release, so I'd like to get it incorporated.

I can run a patch for the simple fix as described in the jira, it's just the deletion of a single space changing   $nullIndex = $nullValueIndex = ' '; to   $nullIndex = $nullValueIndex = '';

But once I have the patch, what do I do with it to get it applied to LTS?


texts: Profile field pre and field post help on search pages

texts:
I am finding that field pre and post help do not display in Edit Search Query forms.  Nor does form help, or even formatting fields.  Am I missing something?

We have a membership directory that our members (public, not logged in) can use to lookup information on other members.  It works.

However it's not obvious to them that they can use mysql wildcards to search for words within strings of text.  For example use "%biology% to search the "Interests" custom field, which contains a free form description of what interests the member.


texts: How to debug a recurring subscription that is not updating membership

texts:
I've got a recurring membership that's not updating. I'm trying to figure out where/how to debug.

I can see that PayPal sent an IPN and got a 200 response from extern/ipn.php by looking in PayPal.
When I look at the recurring contribution in civi, I see the last updated date was Sept 3. (This IPN was a monthly recurring subscription for Oct 3). So it seems to not be registering it.
"Membership status processor (Hourly)" is enabled ("Process Offline Recurring Payments (Daily)" is not - but this isn't offline, right?)

How can I start to debug this?


texts: after i use api to update the database results not immediately showing

texts:
I'm running into an issue with the api. I use the following call to write to the relationships datatable

$result = civicrm_api3('Relationship', 'create', array(
    'sequential' => 1,
    'contact_id_a' => $contact_a_id,
    'contact_id_b' => $contact_b_id,
    'relationship_type_id' => 11,//your specific relationship id
));

from my solution in https://civicrm.stackexchange.com/a/4619/765

However, when I then go to the relationship tab the new entry is not immediately visible. I usually have to force a refresh by changing the relationships per page from 10 to 25 and then the new entry appears. How can I bypass/avoid this problem?

Thanks,
V


texts: Where can I find the field string length?

texts: I need to import addresses using the API. Some addresses go over the CiviCRM limit. For instance street_address has a limit of 96 characters. I would like to know where are these limits defined in CiviCRM or where are they documented? I don't want to use the trial and error method to find out.


texts: Limit the groups exposed in Group profile field

texts:
I'd like to use the Group field in a profile so people can sign up for our mailing lists. However, the Group field exposes ALL of our public groups, and I want it to to expose only the public MAILING list groups. Is there a way to do that?

Using CiviCRM 5.3.1 with WordPress 4.9.6.


texts: Mailchimp extension not pushing new Civi group members to the Mailchimp list

texts:
I've been setting up the excellent Mailchimp extension from Vedaconsulting.

It all seems to be working correctly (thanks to this page), except for when posting on the fly from Civicrm to Mailchimp:

I've setup a smart group to correspond to a list in Mailchimp.
If I unsubscribe someone from Mailchimp then Mailchimp's webhook fires and the person is correctly removed from the smart group.

But if I add someone to the smartgroup they aren't being pushed to Mailchimp. There is immediate activity in the Civicrm log, but the name of the person isn't included. (Arrays contain info about the list and groups etc, but not the person.) And no change in Mailchimp.

Nevertheless, syncing Civi from/to Mailchimp seems to be working fine.

What could I do to troubleshoot this?

We're on Drupal 7.50, Civicrm 4.6.17, Mailchimp 1.8.7. Our server is locked down pretty tight... but if syncing is working then I would have thought the database post should be working too?

Thanks for your help!


texts: Can't get through initial install - dashboard error page

texts:
Well, I thought this would be a fairly simple, two-beer process: set up wordpress, install civicrm, and call it a day. Now I'm stuck and out of beer. I got wordpress installed fine (via the web host's one-click install process), but after activating civicrm and doing the "check requirements and install," when I am taken to the dashboard for the first time, I am met with these errors:

System Status: Error
Cron Not Running
Timestamp Mismatch
Configure Default Mailbox
Complete Setup
View details and manage alerts

[

I'm on the following:

civicrm verson 4.7.2
php 5.6
MariaDB Server 5.5.44-MariaDB-cll-lve
wordpress 4.4.2

This should be a pretty standard install - I quite literally installed wordpress and then civicrm. I've seen the cron and mailbox errors before, but the timestamp and "complete setup" are new to me. I figure if I can push through those somehow, I'll be in business.

This is a fresh install of both the domain and hosting, so civicrm has not worked previously here. I've gotten civicrm running on a personal vm to learn the install process, but this one's throwing me for a loop. If I click on "View details and manage alerts," I am simply taken back to this same screen. No top civicrm menu appears, either, so I can't click around to various parts/modules within civicrm. Clicking on configure or refresh dashboard does takes me back to this screen, as well. I cannot for the life of me get past this screen. The server is hosted in Amsterdam. I have updated the PHP timezone settings to Europe/Amsterdam and Wordpress to +1:00.

I'm not sure where to start with this one - what log files to dig into, etc. I can successfully access other pages I know exist, such as www..com/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcontact, where I can search for contacts (though my db doesn't contain any user content yet). I have the same db user configured for the wordpress db and the separate civicrm db (not sure if this follows best practices, but I'm just trying to get past this install screen first). I've given the db user all the necessary permissions and am not receiving any errors indicating db connection issues. I originally had a separate db user for civicrm and wordpress, but in troubleshooting have since blown everything away and started fresh (removed the databases, db users, wordpress install - everything).

Apologies if this is a dumb issue, but I've searched for answers and have so far been unsuccessful. Where do I start with this one? Thank you for any help.


texts: Associate a tag with a contact where drupal tables have a prefix using civicrm 5.32.2 - drupal table prefix missing

texts:
CiviCRM 5.32.2 is missing the drupal 7.77 prefix when trying to access drupal tables that should have the drupal table prefix applied. How can I fix this?  I am using Shoreditch theme, running with PHP 7.3.25, and MySQL server version 5.7.26
This is the error I get when trying to update an individual's record:
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 Error: no such table
Error Details
Database Error Code: Table 'jandbweb_jandb78.taxonomy_vocabulary' doesn't exist, 1146
Additional Details:
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -18
[message] => DB Error: no such table
[mode] => 16
[debug_info] => SELECT  t.tid as category_id, concat( v.name , '-', t.name)  as category_term_name
             FROM jandbweb_jandb78.taxonomy_term_data t
             JOIN jandbweb_jandb78.taxonomy_vocabulary v ON t.vid = v.vid
         GROUP BY t.tid [nativecode=1146 ** Table 'jandbweb_jandb78.taxonomy_vocabulary' doesn't exist]
[type] => DB_Error
[user_info] => SELECT  t.tid as category_id, concat( v.name , '-', t.name)  as category_term_name
             FROM jandbweb_jandb78.taxonomy_term_data t
             JOIN jandbweb_jandb78.taxonomy_vocabulary v ON t.vid = v.vid
         GROUP BY t.tid [nativecode=1146 ** Table 'jandbweb_jandb78.taxonomy_vocabulary' doesn't exist]
[to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT  t.tid as category_id, concat( v.name , '-', t.name)  as category_term_name
             FROM jandbweb_jandb78.taxonomy_term_data t
             JOIN jandbweb_jandb78.taxonomy_vocabulary v ON t.vid = v.vid
         GROUP BY t.tid [nativecode=1146 ** Table 'jandbweb_jandb78.taxonomy_vocabulary' doesn't exist]"]

)
Return to home page.
Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame thrown in /home/customer/www/jandbweb.jandbwebsite.com/public_html/sites/all/modules/civicrm/Civi/Core/Transaction/Manager.php on line 93
The table being accessed should be 'jandbweb_jandb78.Jbwtaxonomy_vocabulary' and not 'jandbweb_jandb78.taxonomy_vocabulary'.


texts: Stop scheduled reminders for an event after the event is finished

texts:
We occasionally have participants get registered for an event by our back-office staff while the event is in progress or even after it is finished.  Our events have scheduled reminders set for 1 day and 1 hour before the event.  These people who are registered during or after the event do get these scheduled reminders sent to them and it is both confusing to them and spammy of us to send them.
Six years ago someone asked if there was a way to turn this off.  I'm hoping that in six years maybe there has been some progress or changes.
Is it possible to get scheduled reminders that are set to "XX time before the event starts" to not fire once the event start time has passed?
Thank you


texts: What is alternative solution to paypal pro due to PSD2 compliance issue

texts: After searching a bit it appears there’s no definitive solution for PSD2 compliance for CiviCRM as of now. We do not mind moving to a different payment processor. My only concern is which other payment processor that does onsite & back office card payment and handles recurring payments? Thanks


texts:
I'm are trying to get the "Tax and Invoicing"(civicontribute) te work. I used these.

It works fine when I select one or more contributions and use the action pull down. But opening the details of an specific contribution doesn't show the Print Invoice of E-mail invoice button, as shown in CiviCRM Userguide:

I use Civicrm 4.6.22 and 4.7.11 and php 5.6.

Any ideas?


texts:
I am building a custom report that, due to its complexity, requires multiple SQL statements including the creation of temporary tables.  I have developed the queries in MySQL workbench and they work as intended.

However, when embedding these statements in the postProcess() function of a subclass of CRM_REPORT_FORM and passing the query to $this->buildRows the query fails with "DB Error: syntax error".  Can anyone point me to an example of a report that uses multiple SQL statements or advise how to properly construct such a report?

If it helps, the rough outline of the SQL I need to handle is as follows:

CREATE TEMPORARY TABLE all_grades AS (SELECT ......

CREATE TEMPORARY TABLE all_grades_copy SELECT * FROM all_grades;

CREATE TEMPORARY TABLE most_recent_sequence SELECT .....

SELECT.....FROM all_grades, INNER JOIN most_recent_sequence ON ....JOIN all_grades_copy ON .... GROUP BY .....


texts: Struggling with setting up CiviCRM Multisite (WordPress)

texts:
I'm struggling trying to set up WP Multisite with Civi Multisite. Both are at most current versions.

My TLD (top level, main domain) lpnevada.org works just fine. I am trying to set up county web sites, which are set up via subdomain, i.e. county.lpnevada.org. I started with Clark County (https://clark.lpnevada.org for the sake of this posting), and am trying to get the settings right for this one before I duplicate over the other 15.

I have done some of the steps outlined here. Specifically, I am doing the manual installation option (option 1, I guess).

Each subdomain has its own civicrm.settings.php file in its upload folder, wp-content/uploads/sites/{siteID}/civicrm, {siteID} being whatever that value is on the Network. Clark County's folder is wp-content/uploads/sites/8/civicrm.

I should also mention I have CiviCRM Admin Utilities and CiviCRM Multisite extensions installed, and Civi is Network-active.

Due to previous frustrations, I copied my active Civi extensions into the folder public_html/extensions (that I created) for easier access, and have referenced that in Clark County's individual civicrm.settings.php file. Seems to work okay.

Here are my issues:

When I go to Clark's Civi dashboard (https://clark.lpnevada.org/wp-admin/admin.php?page=CiviCRM), the Dashlets don't load. Like, ever. I will refresh after a few minutes of it sitting there; no joy.
The submenu links don't resolve. The top level ones do. For instance, if I hover over [b]Contacts[/b], the address will show https://clark.lpnevada.org/wp-admin/admin.php?page=CiviCRM#, but any of the submenu links below it still go back to the parent domain (https://www.lpnevada.org/wp-admin/admin.php?page=CiviCRM&{restOfCiviPageURL}).

Have tried to clear cache and rebuild menu already. Also tried private mode/incognito and different browsers. No joy.

I appreciate any help in advance.


texts: Manual geo code field in civicrm profile

texts: We use profiles (https://book.civicrm.org/user/current/organising-your-data/profiles/) for updating organisation information by the organisations himself. We also use geo fiels to map organisation on a map. Civicrm create automatically geo coördinates (Lng, Lat) from an address . Beacause this automatically geocode is not always the correct place or the organisation we will give the possibility to also give the geo-code (Lng, Lat) by himself. Adding Lng and Lat is no problem but how can we let change the manual_geo_code from 0 to 1 by the organisation. Is don't see this option in the profile fields (contacts).


texts: Get Admin email notifications for system status changes

texts: Is there a way that I can be notified via email anytime the system status changes? (Or changes to something other than 'ok'.)


texts: How to get a CiviRule to fill in a custom field upon a webform submission?

texts: We have a Drupal 7 website that we are having users submit a webform on. When a webform is submitted it is assigned a unique ID. This ID used to generate a PDF to view the webform results and is viewable on the Drupal side. The problem we are running into is getting this information over to the CiviCRM side automatically. We created a custom data field in CiviCRM for the ID to go in and have it left blank during the submission, and we installed the module CiviRules Webform CiviCRM Submission Trigger so we can have a rule run when the form is submitted. The part we need help with is getting a rule that takes that ID and fills in the blank field with it upon submission or some way to do the equivalent.


texts:
Is it possible for CiviMail to track embedded URLs? For eg, I've a URL which contains contact id and checksum tokens in it. I need to check how many users have clicked the URL from the email.

URL to track - https://site-name/info?cid1=<contact_id_token>&cs=<contact_checksum>

Currently, the code in CiviMail don't consider such tokenized URL from tracking and don't insert it in civicrm_mailing_trackable_url table.

There is a similar question on SE - Tracking links that have been added via tokens but it seems to provide different track links for each tokenised URL which is a pain when number of recipients is large in number. Eg 10k contacts would have 10k trackable links and will considerably increase the size of the database.

Our thought now is to cut the URL till a token is reached and consider this for tracking. For eg, if the original URL is https://site-name/info?cid1=<contact_id_token>&cs=<contact_checksum>, we need to modify the functionality to track only https://site-name/info and if such url is hit by the user, the click counter should be incremented.

To proceed with the above, we can store the partial link in civicrm_mailing_trackable_url table and replace the main html URL with the trackable link. Now, when the user hits this url in the mail, the main problem arises as we don't have any data of what should be appended to the partial URL to navigate user the original page.

Is there any another solution possible?


texts: Chaining Participants creation using REST API

texts:
I'm trying to create an event and chain the participants creation using the REST API from python. My attempt goes like this:

import requests

params = {
 "key": "key",
 "api_key": "apikey",
 "json": 1,
 "sequential": 1,
 "entity": "Event",
 "action": "create",
 "title":"Test event",
 "start_date":20181005123600,
 "event_type_id":"Conference",
 "api.Participant.create": {"event_id":"$value.id","contact_id":"8","participant_status_id":"2"},
 "api.Participant.create.2": {"event_id":"$value.id","contact_id":"6","participant_status_id":"2"}
}

url = "some_url"
response = requests.post(url, params = params)

For some reason the event is created but the participants are not. Could anyone give me a hint about what's happening?

Thanks


texts: Civicrm fails to launch - Wordpress gives "The plugin does not have a valid header."

texts:
We have been running CiviCRM 4.6.8 for a while now on our site. Last evening, while trying to access our site, Wordpress gives us this error: The plugin civicrm/civicrm.php has been deactivated due to an error: The plugin does not have a valid header.

we had plans to update to 4.7.9, so we backed up our SQL database and entire CiviCRM installation and proceeded with updating to 4.7.9 as per https://wiki.civicrm.org/confluence/display/CRMDOC/Upgrading+CiviCRM+for+WordPress. However, when point our browser to the upgrade url: http:///wp-admin/admin.php?page=CiviCRM&q=civicrm/upgrade&reset=1, we get this error: You do not have sufficient permissions to access this page.

I would have thought that upgrading would have resolved any issues with invalid headers, but now it seems we have even further issues. Any ideas on how to go about resolving these problems?


texts:
I have copied a drupal codebase, drupal database, and civicrm database and moved them to a new server. I am using version 4.7.0 of civicrm. My copied site throws this error:

  Error: Could not create directory: /home/abc. If you have moved an
  existing CiviCRM installation from one location or server to another
  there are several steps you will need to follow. They are detailed on
  this CiviCRM wiki page - (learn more...). A fix for the specific
  problem that caused this error message to be displayed is to set the
  value of the config_backend column in the civicrm_domain table to
  NULL. However we strongly recommend that you review and follow all the
  steps in that document.

This folder does not exist on my server, nor do I want it to. It is a reference to a location on the server from which I made the copy.

I have looked in civicrm_domain, config_backend does not exist
I have emptied all the cache tables in the civi database
I have emptied all the cache tables in the drupal database
I have updated settings.php ('home/abc' is not present anymore)
I have updated civicrm.settings.php ('home/abc' is not present anymore)
I have removed/removed all files from the following:

/sites/default/files/civicrm/templates_c/*
/sites/default/files/civicrm/ConfigAndLog/Config.IDS.ini
/sites/default/files/civicrm/ConfigAndLog/*

When I run grep -R "/home/abc" * from my doc root, no matches are found. When I search for the string "/home/abc", in both databases, I get no matches.

Any ideas? Thanks.


texts: Configuring CiviCRM for 1and1 email limits

texts:
1and1 hosting says: Using the 1&1 mail server, you can send a message with no more than 100 recipients at one time and no more than 200 within five minutes. Please allow 10 seconds between sending e-mail messages.

The 100 batch can be configured in CiviMail, but is there a way to configure "no more than 200 within five minutes" ?


texts:
We recently started using ACLs to fine-tune access to custom fields. Roughly speaking, our setup is:

all authenticated users can access custom field group 1
role 1 can access field groups 2, 3, 4
role 2 can access field group 5

The problem is that once in a while, a user with role 1 can't see fields in groups 2, 3 and 4 when looking at a contact's summary page.
Refreshing the page fixes the issue.

Unfortunately, if we are using memcache, refreshing no longer helps (which makes sense).

What would cause Civi to not correctly check ACL permissions once but then work on the second attempt?
Of course this appears to happen completely randomly and is impossible to recreate consistently.

Running CiviCRM 4.6.2.

UPDATE: Issues appear to start during Drupal's cron run.

/CRM/ACL/BAO/ACL.php:group() returns erratic and inconsistent arrays of custom field group IDs every time it gets called.
Seems like drupal's cron wreaks some sort of havoc on the acl cache and civi has a hard time rebuilding it.


texts:
We get an error when PayPal is trying to confirm payment. In a nice letter Paypal tells us about the problem and shows the offending link, which is .../administrator/components/com_civicrm/civicrm/CRM/Core/Payment/PayPalIPN.php. Opening that link gives the following backtrace:

CRM_Core_Exception: PayPalIPN: Could not find an entry for module in ...com_civicrm/civicrm/CRM/Core/Payment/PayPalIPN.php on line 315
Exception trace
#   Function    Location
0   CRM_Core_Payment_PayPalIPN->retrieve('module', 'String')    ...com_civicrm/civicrm/CRM/Core/Payment/PayPalIPN.php:315
1   CRM_Core_Payment_PayPalIPN->main()  ...com_civicrm/civicrm/CRM/Core/Payment/PayPalImpl.php:780
2   CRM_Core_Payment_PayPalImpl::handlePaymentNotification()    ...com_civicrm/civicrm/CRM/Core/Payment.php:1379
3   CRM_Core_Payment::handlePaymentMethod('handlePaymentNot…', Array)   ...com_civicrm/civicrm/CRM/Core/Payment.php:1281
4   CRM_Core_Payment::handleIPN()   ...com_civicrm/civicrm/CRM/Core/Invoke.php:275
5   CRM_Core_Invoke::runItem(Array) ...com_civicrm/civicrm/CRM/Core/Invoke.php:84
6   CRM_Core_Invoke::_invoke(Array) ...com_civicrm/civicrm/CRM/Core/Invoke.php:52
7   CRM_Core_Invoke::invoke(Array)  ...com_civicrm/civicrm.php:96
8   civicrm_invoke()    ...com_civicrm/civicrm.php:11
9   require_once('/var/www/events/…')   ...libraries/src/Component/ComponentHelper.php:382
10  Joomla\CMS\Component\ComponentHelper::executeComponent('/var/www/events/…') ...libraries/src/Component/ComponentHelper.php:357
11  Joomla\CMS\Component\ComponentHelper::renderComponent('com_civicrm')    ...libraries/src/Application/SiteApplication.php:194
12  Joomla\CMS\Application\SiteApplication->dispatch()  ...libraries/src/Application/SiteApplication.php:233
13  Joomla\CMS\Application\SiteApplication->doExecute() ...libraries/src/Application/CMSApplication.php:195
14  Joomla\CMS\Application\CMSApplication->execute()    ...index.php:49
15  {main}

Any ideas on what to do to debug? We're using Joomla 3.8.12 and Civi 5.4.1.

Update: I'm looking at the code there which says:

$component = $this->retrieve('module', 'String');

I'm suspecting that this means that it's trying to retrieve the module part of the calling URL (/administrator/components/com_civicrm/civicrm/CRM/Core/Payment/PayPalIPN.php). So this URL is malformed for the IPN, right?

How does the retrieve() work?

UPDATE: When entering URL .../administrator/components/com_civicrm/civicrm/extern/ipn.php I get

The transaction has failed. Please review the log for more detail

and in the civicrm_system_log database table there is an entry, but with an empty "context" field, in which I suspect the transactionID etc. is supposed to be. This is natural in this case.

So I updated the IPN URL in the Paypal account to this and tried a resend of the latest failed IPN. It failed again, and even with the update URL I get a log entry in the civicrm_system_log table.

So it seems that Paypal has no "context" info for the transaction.

I've also checked that the URL does not redirect (using Redirect Checker), since this question seem to indicate that you loose POST data on redirect (which seems odd, but WTH and JIC).


texts: How to remove CiviCRM links from Drupal user account page?

texts:
By default CiviCRM adds links for » View Contact Record and » View Contact Dashboard on the Drupal user account page for users that have permission to do these things.

These links have proven to be confusing to new users when they log in and see their user account page (we have a "dashboard" in our Drupal system and they get confused when this link leads them to their CiviCRM contact dashboard, which is not helpful to them).

I know that I can:

Use CSS to simply hide them
Use a preprocess function in template.php for my Drupal theme to unset these from the array of user account items

But both of these are theme-specific solutions.

Is there a CiviCRM way to accomplish this?


texts: Unable to save multiple choice custom field

texts:
I'm new to CiviCRM and evaluating for our charity. I'm trying to create a multiple choice custom field but am unable to save it. I can do this OK on the 4.6 / Joomla demo site but not on 4.7.14 Joomla that I'm using.
The option box does not appear to be enabled here :
Option Type ( )Create a new set of options
I can't find anything in the config or documentation that turns this on or off and have tried re-installing the component but that didn't resolve the problem.
Thank you


texts: CiviPledge "Next Payment Date" automatically set to Jan. 1, 1970

texts:
When I enable pledges on a contribution form, CiviCRM processes the first payment properly, and records the correct "pledge made date".

However, it records the "next payment date/payments start" as Jan. 1, 1970, and subsequent payments in their proper increments (weekly, monthly, etc.) on the proper day of that period.

Obviously, this error doesn't apply to pledges entered manually.

I am running Wordpress 4.6.1 with CiviCRM 4.7.12. Any ideas as to what's behind the timewarp back to the 1970s?


texts: How to connect to REST API from remote host?

texts:
I'm trying to connect to the rest api from a remote server, and the only response I ever get back is:

var jsondata = {"currencySymbol":"$","is_error":true};

I'm able to make api calls from the site's API Explorer (within the same domain).  But no matter what I do from my remote host, any calls to this site's rest.php always return that same generic response.

Is there something one must to do allow external access to the REST API?  Or does this response hint at some other request filtering taking place?


texts: Is there any way to add "Relationship Type" to a membership type that already has members?

texts:
We've decided that the way we initially setup civimemberships for our organization does not meet our needs. We need to extend membership to employees of member organizations so that employees will receive email communications sent to member organizations.

CiviCRM does not allow this setting to be changed through the UI. It is something I can change through the database?


texts: CiviMail Images always appear broken on screen after uploading correctly

texts: I have been working with CiviMail to upload images directly to the mailing templates from the KC finder image upload. I am successfully able to upload an image via KC finder which looks good when I upload it. However, once I click away to add the image to the template it shows a big red x instead of the actual image. I understand that it might be a permissions issues but I have tried different options for the issue and it does not work. This CiviCRM is on a Windows 2012 server with IIS 8.5 and PHP 5.6.20. I have tried a number of options from not naming the images with dashes to permissions of the server.


texts:
The new individual record is created, written phone number.
When registration opened again with a new phone number can be the same individual.
Telephone number of systems with the same record, I want to prevent the creation of new personal record.
I do not want this to happen Duplicate Contacts
How can I make this setting.

Joomla! 3.6.4
CiviCRM Ver: 4.7.12


texts: Send a Receipt to a user when adding a manual membership OR any payment

texts:
Using WP4.3.1 and CiviCRM 4.6.9
When creating a manual (off line) membership or payment for a contact is there a way to have a receipt of that sent to another user(email address)?  And is there a way to modify what is on that receipt?


texts: Import – match to contact by email without creating duplicate email address

texts:
Is it possible to use the import function for contacts and match by email, without creating duplicate email addresses for existing contacts?

Example:
We organize frequent webinars with participation in the hundreds per event. After the webinar is over, we import the email addresses of those who  participated back from the webinar platform into CiviCRM, so that we can set their event status accordingly in CiviCRM. We don't have the CiviCRM IDs to import, so we need to do the matching by email. However, this seems to create a duplicate email record in matched contacts. This would not be much of an issue for the occasional import, but as many contacts have participated in dozens of webinars, they consequently also have dozens of email addresses in their CiviCRM record.

Do you know if there is a way around this when importing? Both "Update" and "Fill" has the same problem. With "Skip", it says it has added the imported contacts to a group, but in fact it hasn't...

Note: As our contacts will have different location types set for their primary email address, I am matching by primary address rather than a specific location type.


texts: Include CiviCRM custom profile field in a Drupal view of event participants

texts:
Creating a Drupal view of Civi event participants.   Custom fields for contacts are available for display but cannot find a way to list fields that are in profiles associated with event registrations.
Is there a way to add profile fields to the views field set?


texts: Quick search icon spins forever after upgrading from 4.4 to 4.5

texts: The upper-left quick search box and the edit-in-place for contacts spin the loading icon forever but never do anything. Looking in the browser console, there is a JavaScript error. It worked just fine on 4.4 but stopped after the upgrade to 4.5. I'm using the latest version of Drupal 7 in a multi-site setup.


texts:
I want to send mailling with civcrm and it doesn t work

i resume :
i install wordpress, i install civcrm for wordpress extension and i install mosaico extension too
ok no problem

in wordpress -> i try to send a mail : Menu > contacts > New mail ... it's ok no problems the mail be sended
but when i try : menu : Mailings > New Mailing ... don't work

can you explain me the process please

thanks


texts: Can't find a »Back to search results« link on contact pages

texts:
When visiting a contact from the results list of a civicrm search, it's possible to navigate forward and backwards through the results set.

Wouldn't it be good to add back-to-list-button which targets the search results list?


texts:
I have a customer who wants to send a hashed link in an e-mail reply (or anything else that will do the trick) to a participant so that they can cancel their registration for an event without having to phone or send an e-mail.
We use profiles in the Events.
We use CivicRM 4.6.12


texts:
Keep seeing this error: getFieldValue failed
CRM_Core_Exception: getFieldValue failed in .../wp-content/plugins/civicrm/civicrm/CRM/Admin/Page/Options.php on line 93
Also, i cannot perform the extensions db upgrade...
I've tried uninstalling and reinstalling civicrm volunteer extension through extension interface and by hand.
I've tried upgrading civicrm to latest
any advice on how to resolve this error is appreciated.


texts: bounced emails are in the contact table but not in the bounce report

texts: I have drupal 7.69 with civicrm 5.24.3 successfully running on siteground.  I am running under windows 10 and have multiple browsers installed, all current (EDGE, Chrome, FireFox, Opera). Running under Siteground managed PHP version 7.3.  I have VERP set in civicrm and a valid bounce email (which works as far as getting bounced messages into my contact table).  I can search the contact table and find 36 bounces ("b.").  All that is fine - but NO bounces show up in my bounce reports ?


texts: Can we be notified when civi recieves an SMS?

texts:
I would like to know if there is a way users can be notified when a client replies to a text that has come from Civi. Our system is currently receiving SMS that have been sent to civi, but the only way of knowing they have been received is to look at each individuals activity list. I wondered if a notification to a user could be set up through Civi Rules? Has anyone been successful in setting this up?
Thanks in advance.


texts:
On a handover document from a fundraiser to a volunteer, this link was left to access our database. When it is clicked on it takes you to a page which says 'Access Denied'. Why is this? I'm assuming this database is not paid for and we don't owe money. We really need to access this quite urgently. We have record of the login and password. Any help would be greatly appreciated. How can you contact CIVI for help or is this the only way to get feedback? Thanks.

https://spires.civisites.com/civicrm/dashboard?reset=1


texts: Implementing Duplicate Membership With Different Membership Form Information

texts:
i have a scenario in which Organizations through their staff apply for permit to build Cell Sites. Now i treat the application as a membership because there is annual renewal fee. Now the challenge is this:

Organizations can apply for fresh permit to build another cell site leading to a scenario where you have one Organization multiple membership/Permits for cell sites. I want a situation where each application/permit can be added to the organization without causing any conflict.

What is the best way to implement this scenario of multiple membership to same organzation.

Also, because each application/permit has different information captured inn the form fields, is there a way to add automatic numbering to each membership form so that specific permit/membership form can be called up and viewed individually?

Currently using Wordpress with Latest Civicrm.


texts: Reset Personal Campaign Amounts for Individual PCP

texts:
So I run a yearly Campaign that individuals raise money for - Rather than have them redo a new PCP page - How do I reset their contributions so they can just use the same page for the new year -

I was able to use profile to move all the contribution to a different contribution page for tracking - but they still show up in the PCP that uses the original contribution page

Thoughts
Running Civi 5.8.1 on Joomla 3.9.3


texts: Disable the default tick to send email confirmation for events registration.

texts:
Do you know of a way to disable the check box for send email confirmation when registering a participant to an event manually from the back office? Even when the event settings say no automated email confirmation when you try to register a participant manually you get the tick box for send email confirmation enabled.

Please help if you know a method to disable this.


texts:
When creating a mailing, the draft looks fine, but when sending a test, , the images seem to be in all sorts of strange sizes for some people, as if redefining the size in the draft didn’t happen (the original images are quite large). It looked fine in my inbox, but for 2 people who had to click on “download pictures” those images showed up strange. I don’t know if this can effect it too, but I’m on a Mac and they’re not. All are on Outlook.

I then tried to resize the original image and upload those instead of adjusting the size in the draft by replacing the existing ones, but it didn't help. I noticed the image url leads to a mail chimp gallery, so that might be the problem.

I now want to start from scratch instead of replacing old images, but I don't have an image url to use and so I can't upload the images. When I send images to server or browse server, nothing shows up.

This feels like it should be simple but I have no idea what else to try.

Hel and thanks!


texts: ERROR: No CMS user associated with given api-key

texts:
I have just installed a fresh CiViCRM 4.6.5 with new Drupal setup. I'm trying to fetch all events from CiViCRM.

$api = new civicrm_api3 (array ('server' => 'http://localhost/civicrm', 'api_key'=>'123456789', 'key'=>'82666e3fdc5cc88c6c31ddbef2a74cxx'));

// Get all events from CiViCRM
if ($api->Event->get()) {
    print_r($api);
} else {
    echo $api->errorMsg();
}
exit;

Any idea how to solve above issue?

Any help would be appreciated. Thanks.


texts: Membership for Group of people. One payer

texts:
I have a case where I need the ability for a user to fill out and submit a membership application for himself and other people.

Specific Requirements:

Single transaction: The user pays for himself and everyone else, but everyone gets a membership
The cost is not fixed: $75 dollars per person  (ex: Group of 5 = $375, group of 2 = $150)
Renewal reminders only sent to the originator.
Everyone gets assigned to a group with a name assigned by the user

Is this possible to do with CiviCRM? I can't seem to find an online example or documentation on this specific use case.

Edit: I'm using Joomla! 3.9.16


texts: How can I edit the Subject of a CiviCase?

texts: Whilst Cases have subjects there appears to be no way to edit via the interface.


texts: Membership contribution page leads to "Not found" error

texts:
When setting up a membership contribution page the Test Drive works fine - including successful adding of test members. The link to the Live Page leads to the server responding with a "Not found" error. Not sure where to look...
Using  CiviCRM 4.6.8. on a hosted Wordpress 4.4.1.
Regards - Stefan


texts: What's the purpose of the hash added to filenames in custom folder?

texts: I have a ton of image files to add to Civi (far too many to do manually) and have figured out what tables to update & make it all work.  But I notice that files uploaded via the Civi UI have a hash string added to the filename that's stored.  So xyz.pdf becomes xyz$$$.pdf where $$$ is the hash. What's the purpose of this hash string?  Is it to make a unique URI?  Should I do this as well for my files? It all works without this.  (I don't want to use the API by the way, and we're on 4.6.8)


texts: Custom Case Fields do not work in Drupal Views

texts: I have correctly setup views to work for civicrm fields and am also using the civicrm entity module for Drupal to expose fields. In my testing it seems like the custom fields work for certain types of civicrm components. For example, if i use a custom field for All Contact Types then it works correctly and even the dropdown shows CiviCRM:Custom - Field name. However, for a custom field for Cases it does not work and has the same issue i.e. refers to SQLSTATE[42S22]: Column not found: 1054 Unknown column 'civicrm_case.custom_3' in 'field list'. Has anyone had any success in using custom civicrm case fields in Drupal views?


texts: How do I get the Name and Address on the Invoice to show up in a Window Envelope?

texts: A client recently asked me the following question: I need to be able to mail (postal mail) invoices to our Members. Our pre-printed size 10 envelopes have a window bottom-left. How can I get the Member's Name and Address on the Invoice to show up in that Window?


texts: Consider Relationships in Contact Reports

texts:
Dear CiviCRM community!

I have a question. Our NGO need a report / list of all contacts for sending post letters. We now have some contacts that are married and they only want to get the letter once to one address. Since they contribute separately, we can not define them as a household and we created a relationship between them with the relationship function inside the contacts.

What would be the best practice to get these two people now in one list row, with a specific postal greeting  and address between normal contacts who also need to be on this list?

Do I need to extend the relationship tab and write a custom report or is there an easier way with existing resources?

Thanks in advance for your suggestions!

Cheers
Goran


texts: Version check error - Permission on Bitnami/Google Cloud

texts:
According to the log, the version check is not being executed: (after a plain/basic deployment of Bitnami CIVICRM package at Google Cloud).

Output log from: ( Administer -> System Settings -> Scheduled Jobs Log)

*Parameters parsed (and passed to API method):
a:1:{s:7:"version";i:3;}
Full message:
Finished execution of CiviCRM Update Check with result: Failure,
Error message: File not writable*

permissions on /opt/bitnami/apps/civicrm/htdocs:

-rw-r-----  1 bitnami daemon    6604 Feb 21 12:28 authorize.php

-rw-r-----  1 bitnami daemon  111736 Feb 21 12:28 CHANGELOG.txt

-rw-r--r--  1 bitnami bitnami      4 Mar 12 18:55 composer.json

-rw-r-----  1 bitnami daemon    1481 Feb 21 12:28 COPYRIGHT.txt

-rw-r-----  1 bitnami daemon     720 Feb 21 12:28 cron.php

-rw-r-----  1 bitnami bitnami    720 Mar 14 20:19 cron.phpbkp

drwxr-x---  4 bitnami daemon    4096 Mar  8 02:32 includes

-rw-r-----  1 bitnami daemon     529 Feb 21 12:28 index.php

-rw-r-----  1 bitnami daemon    1717 Feb 21 12:28 INSTALL.mysql.txt

-rw-r-----  1 bitnami daemon    1874 Feb 21 12:28 INSTALL.pgsql.txt

-rw-r-----  1 bitnami daemon     703 Feb 21 12:28 install.php

-rw-r-----  1 bitnami daemon    1298 Feb 21 12:28 INSTALL.sqlite.txt

-rw-r-----  1 bitnami daemon   17995 Feb 21 12:28 INSTALL.txt

-rw-r-----  1 bitnami daemon   18092 Nov 16  2016 LICENSE.txt

-rw-r-----  1 bitnami daemon    8710 Feb 21 12:28 MAINTAINERS.txt

drwxr-x---  4 bitnami daemon    4096 Mar  8 02:32 misc

drwxrwxr-x 42 bitnami daemon    4096 Mar  8 02:32 modules

drwxr-x---  5 bitnami daemon    4096 Mar  8 02:32 profiles

-rw-r-----  1 bitnami daemon    5382 Feb 21 12:28 README.txt

-rw-r-----  1 bitnami daemon    2189 Feb 21 12:28 robots.txt

drwxr-x---  2 bitnami daemon    4096 Mar 11 20:39 scripts

drwxr-x---  4 bitnami daemon    4096 Mar  8 02:32 sites

drwxrwxr-x  7 bitnami daemon    4096 Mar  8 02:32 themes

-rw-r-----  1 bitnami daemon   19986 Feb 21 12:28 update.php

-rw-r-----  1 bitnami daemon   10123 Feb 21 12:28 UPGRADE.txt

-rw-r-----  1 bitnami daemon    2200 Feb 21 12:28 web.config

-rw-r-----  1 bitnami daemon     417 Feb 21 12:28 xmlrpc.php


texts: Problems installing CiviCRM under Drupal 7 on Windows?

texts:
I have just tried installing CiviCRM 5.30.1 using Drupal 7 under WIMP, i.e. Windows, IIS, MySQL and PHP 7.4, and was unable to do so, as I got a message telling me that \sites\default was not writable.  On investigation, it seems that the PHP function is_writable will always return false under Windows. This means that it seems you can't install CiviCRM under Windows any more, as the IsCreatable function in \sites\all\modules\civicrm\setup\src\Setup\FileUtil.php relies on the is_writable function to test if the above folder is writable during the setup process.  I got round it with the following code snippet.
public static function isCreateable($file) {
    if (file_exists($file)) {
      return is_writable($file);
    }

    $next = dirname($file);
    do {
      $current = $next;
        // Under Windows, it seems that folder are never writable      if (file_exists($current)) {
        if( is_writable($current)) {
          return true;
        } else {
          //Try to create a file
            $result = fopen("Test.tmp", "w");
            if ($result) {
            // Close the file.
            fclose($result);
            // Delete it.
            unlink("Test.tmp");
            return true;
            } else {
              return false;
            }
        }
      $next = dirname($current);
    } while ($current && $next && $current != $next);

    return FALSE;
  }

No doubt some of you CiviCRM experts will have a comment.


texts:
Quick question - How do I get the rationale field to show up under the Grants tab for a contact? Can this be done without access to the "backend code"?

Cheers - Phil


texts: Date created field displays erratically in views and webform Drupal7 integration

texts:
The native date created field for contacts shows up erratically in my views, some items it works, and some it doesn't.

The modified date field always displays however.

Additionally, there used to be a change log field on the bottom on contact creation, but now it's gone...!

Seems that some items that were created a while back show up, but some I did today don't, and I have no idea why some from a while back show and others don't!


texts: Relationship shows up on contact page but is undefined in reports, searches, and exports

texts: I have a database in which I have recorded relationships and they are not showing up on the relationship report, in searches, etc. In other cases the same type of relationship does show up. After investigating in the database directly I've found that the relationships which don't show up are not in the database either.  But they do show up on the contact page under the relationships tab.  How do I get those relationships to integrate into the database?


texts: How to display a Drupal view in a CiviCRM tab

texts:
I'm trying to display a drupal view in a CiviCRM contact tab. I've tested out my tab function with the code snippet on hook_civicrm_tabs and it will show the contribution tab correctly, and I've tested out my drupal view url on its own with a contact id appended and that displays correctly, but when I try to use my code to display the view in the tab, after I click the tab I get a civicrm error pop up message that says "Network Error
Unable to reach the server. Please refresh this page in your browser and try again."

Here is my code

function mymodule_civicrm_tabs(&$tabs, $contactID) {

$url = '/civicrm-videos/'. $contactID;
$tabs[] = array( 'id'    => 'projectTab',
                 'url'   => $url,
                 'title' => 'Projects',
                 'weight' => 300,
                 'count' => '2' );
}

What am I doing wrong?


texts:
I'm running WP 5.3.2 and Civi 5.34.0. I recently installed Wordfence free version on my site, but not sure if this has anything to do with my problem (disabled the plugin and the problem still occurs). The problem is that Cron jobs were previously working great and now, well they're not. I'm running jobs manually each day until I can figure this out.
I have a Cron job set up on my host (siteground). My job is:
http://www.mywebsite.com/wp-content/plugins/civicrm/civicrm/bin/cron.php?name=NAME\&pass=PASSWORD\&key=KEY
If I add this to my url to test I get "ERROR: Invalid username and/or password". I can login using the user details fine and the permissions between WP admin and Civi admin correlate.
Anyone have any ideas about where I'm going wrong? I'm a novice, so explaining any solutions/ideas you might have in very basic terms would be great. Thanks!
Edit: On running my jobs manually today this error appeared at the bottom of the page:
Fatal error: Uncaught Exception: : : in /home/customer/www/mywebsite.com/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/JobManager.php:286 Stack trace:
#0 /home/customer/www/mywebsite.com/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(421): CRM_Core_JobManager_scheduledJobFatalErrorHandler(Array)
#1 /home/customer/www/mywebsite.com/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(39): CRM_Core_Error::handleUnhandledException(Object(Exception))
#2 /home/customer/www/mywebsite.com/public_html/wp-content/plugins/civicrm/civicrm.php(1172): CRM_Core_Invoke::invoke(Array)
#3 /home/customer/www/mywebsite.com/public_html/wp-includes/class-wp-hook.php(288): CiviCRM_For_WordPress->invoke('')
#4 /home/customer/www/mywebsite.com/public_html/wp-includes/class-wp-hook.php(312): WP_Hook->apply_filters('', Array)
#5 /home/customer/www/mywebsite.com/public_html/wp-includes/plugin.php(478): WP_Hook->do_action(Array)
#6 /home in /home/customer/www/mywebsite.com/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/JobManager.php on line 286


texts: CiviCRM select box items can't be selected in wordpress page create

texts:
In wordpress, when adding a new page or post, a CiviCRM button is available to add content from Civi.  The "Insert CiviCRM Content" dialog box opens as expected, but the select box doesn't allow a selection.  The select box contains "User Dashboard", "Profile", "Contribution Page" and "Event Page", but these options open underneath the dialog box and can't be clicked.

Turns out that this is because the select box has a z-index of 399,999. I can't find any CSS conflict that would cause this, and there is no JS error in the console.  Any suggestions would be appreciated.


texts: Does anyone know whether it is possible to send QR codes to event participants via CiviSMS? A client wants us to send participant's QR codes to their mobiles.


texts: Can I have a different email address to confirm a group subscription?

texts: I'm using a webform to allow users to sign up to a newsletter group.  The confirmation emails use the default 'from' email address in Civi. Is there a way to select a different email address for this confirmation? Civi is at 4.7.27 and Drupal, of course.


texts: Filtering activities by Source Contact ID

texts: I want to search for people who have an activity created by a specific person. Search Builder lists the 'Source Contact ID' field but doesn't populate the information nor filter things appropriately. Advanced Search produces similar results. Is there a way to find this group of contacts based on activity and who created the activity?


texts: How to set up recurring contributions on Webform using Stripe

texts: I'm a little confused from other questions here as to whether setting up recurring contributions on a webform using Stripe works.  They work just fine using a regular contribution page. But using a webform that points to the same contribution page the payment goes through as a one-off, even though the 'Frequency of installments' is set to 'month'. If I add either of the other 2 fields 'Number of installments' and 'Interval of installments' fields to the webform I get the message 'Mandatory key(s) missing from params array: total_amount'.  So - recurring contributions can be set up through Stripe, but does/should this work in a webform? If so, any clues as to how you get this to work?


texts: Copy a Sites Customizations (Custom Fields, report instances, etc)

texts:
I would like to make a copy of our production site that includes all the custom changes that we have made (fields, event templates, tags, groups, etc). I need this copy for development purposes, but do not want any of the data relating to contacts, events or contributions.

I have tried transferring the schema and running data comparisons but I always seem to run into some sort of issue.

Does anyone have any experience dealing with this?

Currently I have a custom extension that makes various API calls to clear out content. This is quite slow, but seems to work.


texts:
I want to give my users the ability to create an "employee of" relationship between an individual employee and an individual employer; where someone works for an individual rather than an organisation.

Is there a way to create a relationship that allows selection of either organizations OR individuals or must this be implemented as two separate relationship types?


texts: Solved: Is this a bug - [civicrm.files] variable

texts:
Drupal-7.54 , CiviCRM-4.7.16
Multi-site / Aegir platform.

On a clean Drupal+CiviCRM instal the autogenerated path for the [civicrm.files] variable in 'Settings - upload directories' differs from the URL path generated in 'Settings - Resource URL'.

In Settings- Upload Directories the civicrm.files variable is: var/aegir/platforms/platform_name/sites/siteURL/files/civicrm

In Settings- Resource URL the civicrm.files variable is: h t t p://siteURL/sites/default/files/civicrm/

The problem does not arise in a non-multi-site environment, where both paths point to 'sites/default/files/civicrm (as confirmed on the sandbox demo).

This also seems to affect the path to the files/civicrm/persist directory.

One effect of this seems to be on CKEditor: when the CKEditor configurator is used it creates files (e.g. crm-ckeditor-civimail.js) in the persist directory. But these files are ignored when CKEditor is used in Civimail (see Solved: How do I allow all tags in CKeditor, and 4.7.15 breaks civimail styles and templates (fullPage doesn't help) and maybe CiviMail template format in HTML not saving


texts:
Earlier I updated several Wordpress plugins. One of those updates broke my access to Wordpress admin. So, I restored the backup I made prior to updating the plugins. After the restore I still cannot access the Civi dashboard.

When I try, I get this:

Note, I also cannot access my Wordpress Network dashboard. WHen I try I get this:

I have a subsite and from the subsite's dashboard, I can access the Civi dashboard, but I get the same error when I try to access the network dashboard.

What do I need to do to regain access to the Civi dashboard?

I'm using Wordpress 4.9.9 and CiviCRM 5.4.1.


texts: Can user choose membership start date in contribution form?

texts:
I'm using a contribution form, where user will pay by choosing price set option with different membership period. Example:

Price A (Membership X, 3 months)
Price B (Membership X, 6 months)
Price C (Membership Y, 3 months)

Currently the membership date is a rolling period, where membership start date will follow the payment date.

Is it possible to let user enter their membership start date?

For example:

Payment date: 1st Jan
Start date field entered in form: 3rd Jan
After payment: Membership period starts from 3rd Jan

Is there any way to do this?


texts: Create Wordpress User With Given Username During Import

texts:
We are trying to have a membership signup page on our WordPress site. The idea is that upon membership creation a user will be created in WordPress.

So I have a membership sign-up page using a profile that I've created. Almost everything works as I want it except for how the users in WordPress are being created. It is creating the username as a combination of title, first name, and last name.

I don't have a username field on the profile. There is seemingly no username data point in CiviCRM that I can add to the profile. How can I ask the user to provide a username or change the way it is auto generating them.

I didn't see the option on the profile to create a WordPress user.

Import Question:

When I import users as contacts from our Excel sheet it sets the username as title plus first and last name. Is there a way to provide a username on import? Is there a way to map a username column in the CSV?

I'm using the membership role sync plugin in WordPress to sync roles across to the users in WordPress. Ideally I would like to import all the contacts (which will have both current and expired members) and then import memberships as separate. Doing the membership import would create the user, correct? Again, I'd like to be able to define the username here.


texts: CiviMail - when Track Click Throughs is enabled, links result in a white screen with warnings

texts:
We are creating a mailing and trying to track click-throughs. When 'Track Click-Throughs' is enabled, clicking on any of the links results in a URL like this: https://mysite.org/sites/all/modules/contrib/civicrm/extern/url.php?u=55&qid=2261 and does not go to the link itself.  This is what shows on screen:

  Warning: date(): It is not safe to rely on the system's timezone
  settings. You are required to use the date.timezone setting or the
  date_default_timezone_set() function. In case you used any of those
  methods and you are still getting this warning, you most likely
  misspelled the timezone identifier. We selected the timezone 'UTC' for
  now, but please set date.timezone to select your timezone. in
  /mysite.org/sites/all/modules/contrib/civicrm/CRM/Mailing/Event/BAO/TrackableURLOpen.php
  on line 92

  Warning: Cannot modify header information - headers already sent by
  (output started at
  /mysite.org/sites/all/modules/contrib/civicrm/CRM/Mailing/Event/BAO/TrackableURLOpen.php:92)
  in /mysite.org/sites/all/modules/contrib/civicrm/CRM/Utils/System.php on
  line 423

If I do not enable Trackable Click Throughs, then the links work.  It appears to be two different issues, but I'm not sure how to resolve either, and if fixing one will take care of the other.

I'm on Drupal 7.38 and Civi 4.5.8.

I've doubled checked civicrm.settings.php (per CiviMail Tracked URLs) and my BaseURL is

  define( 'CIVICRM_UF_BASEURL'      , 'https://mysite.org/' );

I've looked at the links in civicrm_mailing_trackable_url in my database and at the permissions of civicrm/extern/url.php (per Why do track click through).  The links look correct and the permissions of url.php are 644.

Any help or direction on either of the warnings is greatly appreciated!


texts: Does the Gift membership extension work with 4.7?

texts:
Does anyone know if Civicrm's Gift Membership extension works with 4.7?

https://civicrm.org/extensions/gift-memberships shows stable releases up to 4.6.

Parenthetically, I'm also aware of Coleman's suggestion of using webforms to create gift memberships here: Webform CiviCRM and Gift Membership. But the Gift Extension provides individual access codes which start the membership when the gift recipient chooses, which is a great feature.

Thanks for any thoughts on this.


texts: How is CiviCRM different in Drupal, Joomla, Backdrop, and WordPress?

texts: I understand that CiviCRM is the same app regardless of which CMS it runs under. But I've been told that there are important differences in the way it integrates with the four. What are the main differences? Are there downsides to choosing WordPress, Backdrop or Joomla instead of Drupal?


texts: DB Error: no such field On Event Registration

texts:
We are getting a DB Error: no such field error when registering for a paid event. Here is the debug info which indicated a problem with an unknown column in the contributions table I think. I have looked and that field is in the table. We are using CiviCRM 4.7.30 on Joomla 3.8.7

Database Error Code: Unknown column 'invoice_number' in 'field list', 1054
Additional Details:

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

[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => INSERT INTO civicrm_contribution (contact_id , financial_type_id , payment_instrument_id , receive_date , total_amount , fee_amount , net_amount , invoice_id , currency , source , amount_level , is_test , is_pay_later , contribution_status_id , check_number , tax_amount ) VALUES ( 17049 ,  6 ,  1 ,  20180501090413 ,  50 ,  0 ,  50 , '5e4ba6329f63217b6b65a068eafabfe1' , 'USD' , 'Online Event Registration: Childrens Camp (1st - 7th Grades) 2018 Counselor and Staff Application' , 'Application Fee - 1' ,  0 ,  0 ,  2 ,  NULL ,  0 )  [nativecode=1054 ** Unknown column 'invoice_number' in 'field list']
[type] => DB_Error
[user_info] => INSERT INTO civicrm_contribution (contact_id , financial_type_id , payment_instrument_id , receive_date , total_amount , fee_amount , net_amount , invoice_id , currency , source , amount_level , is_test , is_pay_later , contribution_status_id , check_number , tax_amount ) VALUES ( 17049 ,  6 ,  1 ,  20180501090413 ,  50 ,  0 ,  50 , '5e4ba6329f63217b6b65a068eafabfe1' , 'USD' , 'Online Event Registration: Childrens Camp (1st - 7th Grades) 2018 Counselor and Staff Application' , 'Application Fee - 1' ,  0 ,  0 ,  2 ,  NULL ,  0 )  [nativecode=1054 ** Unknown column 'invoice_number' in 'field list']
[to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_contribution (contact_id , financial_type_id , payment_instrument_id , receive_date , total_amount , fee_amount , net_amount , invoice_id , currency , source , amount_level , is_test , is_pay_later , contribution_status_id , check_number , tax_amount ) VALUES ( 17049 ,  6 ,  1 ,  20180501090413 ,  50 ,  0 ,  50 , '5e4ba6329f63217b6b65a068eafabfe1' , 'USD' , 'Online Event Registration: Childrens Camp (1st - 7th Grades) 2018 Counselor and Staff Application' , 'Application Fee - 1' ,  0 ,  0 ,  2 ,  NULL ,  0 )  [nativecode=1054 ** Unknown column 'invoice_number' in 'field list']"]

)


texts: How can I commit civicrm configs to git?

texts:
I am exploring civicrm and am trying to set up a prod, staging, dev environment where by I create and test custom fields in dev and deploy them to prod. What is the best way to do this?

I cam using the Drupal 8 version which has a config export feature, I am wondering if civicrm has something similar. Thanks


texts: Problem with sorting civievent_widget custom_filter by startdate DESC and for past dates

texts:
I am trying to sort by start_date descending but it doesn't seem to be working.

What change would I make to the below to get it to work?  I am using CiviCRM 4.6

[civievent_widget title="Sorted Events" admin_type="custom" custom_filter=custom_filter='{"is_public": 1, "options": {"sort": "start_date DESC"}}']

Also I am trying to display only past events by date (ideal would be before "today") but this doesn't work either.  Do I have a format incorrect or is this not possible to do?

[civievent_widget title="Past Events" admin_type="custom" custom_filter='{"start_date": {">=": "2018-06-01"}, "is_public": 1, "options": {"sort": "start_date ASC"}}']


texts:
I am looking to merge two contacts together as they are duplicate records. I want to ensure all the tags, groups and contributions all carry over too. I just want to do this on an individual record and not merge an entire group of contacts. i have looked at the 'Find and merge duplicate contacts' tab, however that seem to be only for groups.
Does anyone know how to do this for one person who has two records please?

Thanks,

Grace