texts: Non deductible value incorrect if you choose a nondeductible membership type and make a donation at the same time

texts:
If you add a donation field (financial type 'donation' which is deductible) to a membership price set that includes membership types that are nondeductible, and then use that price set for a membership contribution form, the deductible value on the contribution is saved as membership fee + donation amount instead of just the membership fee portion of the contribution. This means the nondeductible value can not be trusted.

We use the CDN Tax Receipts extension so to get around the issue we wiped out the nondeductible value from all relevant contributions and let the extension + a custom extension calculate the correct values.

This was replicated on https://dmaster.demo.civicrm.org/ running 5.26.alpha1

How to replicate:

- add a test organization and test individual
- create a nondeductible financial type and a deductible financial type
- create 2 new membership types for your test organization with a fee and set one to the deductible type, and one to the nondeductible type
- create a price set with 2 fields:
   - radio option with the 2 membership types
   - radio option with a couple of donation values to choose from, financial type 'donation'
- create a new contribution form, default financial type your custom deductible financial type, and enable your price set on the memberships tab
- now use your new form to create a membership for your test individual and make sure to select the nondeductible membership type & a donation value.
- go to the individual's profile and pull-up the contribution on the contributions tab

To me, it would make sense if the nondeductible value included the donation amount if the contribution status were anything other than 'complete' (pending check for example, because we wouldn't want to issue a tax receipt for monies not receive), but once that status is set to complete then the nondeductible value should respect the financial types of the individual line items.

If this is by design, how would we get around it?

Thanks!


texts: How to set up an event proposal workflow

texts:
I am trying to configure core CiviEvent to allow a regional director to submit a proposal for a future event, via the core New Event form, but then prevent the regional director from making the event active (and therefore live on the website). The event needs to be approved by the main events administrator first.
Can anyone think of a workaround to achieve this?


texts:
I think the issue is that Civi is (1) not enquing the versions of jQuery that come with WordPress and (2) the code is not written for noconflict mode.

?page=CiviCRM&q=civicrm/ajax/l10n-js/en_US&r=NJqDM:8 Uncaught TypeError: Cannot read property '_defaults' of undefined
at ?page=CiviCRM&q=civicrm/ajax/l10n-js/en_US&r=NJqDM:8
at ?page=CiviCRM&q=civicrm/ajax/l10n-js/en_US&r=NJqDM:103

?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2:32 Uncaught ReferenceError: cj is not defined
    at ?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2:32
?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2:192 Uncaught TypeError: CRM.$ is not a function
    at ?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2:192
?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2:208 Uncaught TypeError: CRM.$ is not a function
    at ?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2:208
?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2:259 Uncaught TypeError: CRM.$ is not a function
    at ?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2:259
?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2:400 Uncaught TypeError: CRM.$ is not a function
    at ?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2:400
?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2:403 Uncaught TypeError: CRM.$ is not a function
    at ?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2:403
?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2:563 Uncaught ReferenceError: cj is not defined
    at skipPaymentMethod (?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2:563)
    at ?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2:577
?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2:618 Uncaught TypeError: CRM.$ is not a function
    at ?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2:618
?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=2:621 Uncaught ReferenceError: cj is not defined


texts: Why am I getting this message when setting up membership payment page?

texts:
Using 4.6.8 I have a monthly membership that is not auto-renew, and I am using a payment processor that supports recurring payments (Go Cardless for UK direct debit). Now I want to set up a membership payment page.  In the 'Amounts' section I checked 'recurring contributions' but when I tried to save I get the message "You cannot enable both Recurring Contributions and Auto-renew memberships on the same online contribution page."
Which isn't helpful as the membership isn't auto-renew.  What am I doing wrong?


texts: Why is there private_html in my [cms.root] directory variable and is it trouble?

texts:
The Settings - Upload Directories screen (url civicrm/admin/setting/path?reset=1) makes it possible to examine the value of the [cms.root] variable. Just click the first help question mark.

In my case the cms.root path contains the directory private_html. That is a bit strange because I installed CiviCRM in the public_html directory and also added this path to the $civicrm_root variable.

Why is this, and does it harm?

More details: The CiviCRM version is 4.7.27 on Drupal. It runs on a VPS administered with DirectAdmin, and https is enabled.


texts:
We use Civi accounting batches to export our contributions to an external accounting program.  The office manager has asked me to create a report (in Drupal or Civi) that will show all contributions that have not yet been put into an accounting batch.  I've made some attempts, but have been unsuccessful.  Any help would be greatly appreciated. (Drupal 7; Civi 4.6)

Drupal attempt:

We use CiviCRM Entity in a few different ways, especially in Views. We love the module!  However, accounting batch data is not available in the current release, 7.x-2.0-beta3. A number of contribution and financial entities are now available in Views, but as far as I can tell, none of them make data from the Batch table available (either directly through their Fields or indirectly through Relationships).

CiviReport UI attempts:

Of the standard reports, it seems the Contribution Detail and Bookkeeping reports have access to Batch info already included.  Of those two, only the Contribution Detail report has 'Batch Name' included in the filters.  (The Extended Reports extension didn't seem to have any reports with extra/different options related to Batch data).  The filter type is CRM_Report_Form::OP_MULTISELECT so the only two options are "Is one of" and "Is not one of".  If I use "Is not one of" and select all of the Batch options, I can get the unbatched contributions, but that doesn't seem realistic, especially as the number of batches continues to grow.  Is there a way to automatically select all of the options?  Or do I need to dive into the report's code?


texts: Importing Contacts, Memberships and Contributions in 2020

texts:
I need to import from an external database 1500 contacts with their memberships and contributions.

Everything I read about it in Stackexchange was written between 2015 and 2017.

Is the following still up-to-date?

I can't import everything within a single .csv file, CiviCRM is not build this way
It takes 3 steps:

import contacts with external id connection prevents to look up for contact ID within Civicrm
import memberships with external id field
import contributions with the proper membership_type

Using CSVimporter is the proper tool

Should I do this way or do is there a quicker way?

best regards,

Guillaume


texts: Is there a bulk method to put emails on hold?

texts:
Bounce processing has not been working - but I do have a list of addresses that have been bounced. What I want to do is bulk update all those matching contacts and put their emails on hold.
I cant see a way of doing that. Is there?


texts: How to create a directory of event participants with custom fields?

texts:
I want to create something that would allow someone to enter an event id (ideally multiple event IDs), and generate a report that includes participant fields that I choose.

What I have in mind is something similar to a directory, that shows name/location/employer of all the participants of a chosen event.

Is this best done through creating a report, or by creating a standalone form?


texts: WordPress Events Manager Conflict with CiviCRM Registration Pages

texts:
I have WordPress 5 running CiviCRM.

We have CiviEvent and CiviContribute enabled and the live registration/donation links are working as expected.

We recently enabled WP Events Manager plugin as well to accommodate some more complex event registrations.

When enabled, the online registration/donation pages redirect to the default CiviCRM page (the one that says Do Not Delete) and the registration/contribution forms disappear.

There are no errors and nothing seems to be wrong other than the fact that the forms no longer display. It doesn't seem to be a URL conflict as the paths are completely different between plugins.

Has anyone experienced this problem?

Where would I even begin this debugging issue?


texts: How can I make a custom report that displays info for three contacts based on relationships?

texts:
I've used Civix to make a duplicate of the default Relationship report, and I'd like to extend it to show basic information for a third contact. So we have Contact A and can specify criteria about the relationship with Contact B, and now I'd also like to specify criteria about the relationship with Contact C, if there is such a contact.

Civix helped generate a custom report extension and when I edit the PHP file, I can figure out how to duplicate some lines to produce the interface for the new columns and filters for Contact C.

The trouble I am having is in figuring how to properly name the duplicated array keys and variables so that I don't get "Unknown column" or similar SQL errors when I try to run it.

The goal is to be able to end up with a simple list based on a primary contact, showing (for example) their spouse's name and their child's name (given a relationship of "Spouse of" and "Child of"). If they have no spouse/child relationships then those columns would be blank.

Rather than hardcode SQL I would like to use the interface to allow selections of relationships for flexibility (and in case anyone else would have a use for it) but I am having a little difficulty as it is my first solid attempt to make a custom report with Civix.

At the moment these particular lines of the extension seem to be causing ** Unknown column 'relationship_type_c_civireport.label_a_c' in 'field list'] and DB Error: no such field errors. If anyone has a pointer, I would appreciate it!


texts: Efficient methods for flagging profile submissions from a contact form

texts:
Running Wordpress 4.8 and CiviCRM 4.7.19

As per a suggestion elsewhere on the forum, I created a profile for use on our 'Contact us' page (email, first name, last name, message as a multi-record listing).  I'm trying to figure out the best way to mark/flag/indicate each new submission, so staff will be aware of needing to response and can indicate when a response has been sent for the specific issue.  Right now, my thought is to create a custom yes/no field marked as "triage" that automatically gets set to 'yes' when a form is submitted, and can be set back to 'no' by our staff once the question has been addressed.  From there, I figured we'd create a query for all triage=yes entries and have it appear on the Civi dashboard.  From what I've read, this field could be included in the profile but hidden from the end user with Jquery.

Is there a better way to handle this in Civi?  I'm only beginning to use the software and don't know if some use of tags, groups, or another tool is a more sensible path than the one I've mentioned.

Thanks all,


texts: Unsubscribe Confirmation Page Shows Too Much Information

texts:
When users click to unsubscribe from our newsletter, to confirm their unsubscribe they are taken to a page in CiviCRM that shows them all of the groups that the email was sent to.

Is there anyway to change it so that these groups are not visible to them?


texts: Webform CiviCRM 'Registration Status' for Event not Updating each subission

texts:
We're using the latest on D7 to have a nice RSVP form for an event. We made a custom status 'Not Attending' and of course have 'Registered' as the other status. The form has 4 contacts on it, cloned, all with the same stuff. No prices, just name/email/phone for 4 contacts with the RSVP field (civicrm_1_participant_1_participant_status_id)

When they first submit the form their choice is saved, works great.

But, when they return to the form, and submit again with a change in RSVP, the update is not reflected on their civicrm participant record.

Is this by design, or an error I have made? I assumed it would be cool to let people change their mind!


texts: Inbound SMS from Twilio not showing up in CiviCRM (getting 404 error on HTTP POST)

texts:
I'm really enjoying CiviCRM (recently upgraded to 4.7.13) and was excited about its SMS capabilities. So far, I have been successful in using CiviSMS with Twilio to schedule/send bulk messages.

But, I cannot yet receive inbound SMS responses in CiviCRM with Twilio. For example, if someone responds to one of our messages, it does not show up as an Activity in CiviCRM.

I followed the instructions for setting up Twilio for inbound SMS, but no inbound SMS arrived in CiviCRM.

Here's my configuration of Twilio in CiviCRM:

In my Twilio logs, you can see my configuration as well as the report on how the HTTP POST is running into a 404 error. Here is the detailed error log from Twilio

I've done a number of things to try and fix this--I disabled security plugins, played around with case of the API info entered in CiviCRM.. and now I've started to look at the htaccess files and permissions. But this kind of tinkering is out of my league, so am stopping before I do any damage.

So, I could use any advice y'all could provide.

Thanks!
Chris


texts: Security Vulnerability in Dashboard CiviCRM 4.6 for Drupal 7

texts:
I am currently testing the dashboard feature before enabling it on a production site.
There seems to be a vulnerability in the Dashboard where a contact who only has "View my contact" permission and not "Edit my contact" is able to Edit a relative's contact (for which he has Dashboard access) even though he can only View his own contact.

Can someone confirm that this isn't only on my installation? I cannot test this on the Demo site as there is no access to Drupal.

Permissions User's Dashboard User's CiviCRM ProfileThe Spouse's ProfileSpouse's Profile Edit Screen


texts: how to setup payment processors for multiple organiazations on one instance of Civi? for franchise type locations

texts:
are there any extensions or alternative instructions for setting up and connecting the payment processors of civi to multiple organizations within one instance of civi? For events and memberships we have multiple locations that need to collect their own fees - franchise type setup. It makes sense to add the same account type fields needed in custom field sets for each type of processor, however, for event and memberships are there any extensions or other instructions to select proper location for each possibility and have payment go to that location directly and not our HQ organization?  thanks much!

---additionally, we are using STRIPE and Paypal


texts: In order to see Activities fields in Views - do I need to add/install CiviCRM Entity?

texts: I want to add Activities fields or Relationships in Drupal Views. Do I need to add/install CiviCRM Entity?


texts: Applying part of a contribution to a Participant Payment

texts:
We often have participants for an event who have a portion of their fee paid by another entity. Sometimes, the other entity pays for more than one participant in the same transaction. I realize that Civi doesn't have an out-of-the-box method to handle this, so I've been toying around with an extension to make it happen.

What I don't understand is this: If J.Smith makes a $200 contribution that is to pay for Participant A ($100) and Participant B ($100), it would seem that creating a new entity_financial_trxn as follows would do the trick:

entity_table = "civicrm_contribution"
entity_id = contribution id of the participant payment
financial_trxn_id = id of the transaction for J.Smith's contribution
amount = 100

But this applies the full amount of J.Smith's contribution ($200) to the Participant Payment, rather than just $100. This is not what I expect when entity_financial_trxn.amount is the "allocated amount of transaction to this entity".

I guess my question is: Is this in fact the intended behavior? If not, what is the purpose of entity_financial_trxn.amount?

(I should also note that we do not use civi's accounting features, so maintaining audit-level financial transactions is not a concern.)

Civi 5.19.1


texts: shoreditch: no option to enable on /civicrm/admin/setting/url?reset=1

texts:
So I installed shoreditch on a drupal 7 civicrm. I can enable on the extensions page but on /civicrm/admin/setting/url?reset=1 I see no option to enable the shoreditch them.
I can add the custom-civicrm.css there but not the shoreditch option I see on another (Wordpress) installation.
This is on a civicrm 5.6.0.
Any thoughts?


texts: Contribution Page - Unlink last year's contributions?

texts:
I am new to the position of keeping our website up-to-date. The previous person told me that I could edit over previous versions of pages so we don't have multiple pages that are similiar of events we do each year. I updated one of our contribution pages (YLS Supports Income Programs), however I notice on the widget page that it is pulling the contributions from last year's event. Is there a way to unlink that so we can start fresh at $0 this year? Or is there a better way to go about this?

Thank you,
Kim


texts:
Anyone have any idea how I can fix this?
Just done install and CiviCRM did not load (all OK on wizard) then nothing.
Removed CiviCRM from the WordPress install and uploaded again (also removed database) but error below appeared.

Have I missed something?

Initialization Error

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

[code] => -24
[message] => DB Error: connect failed
[mode] => 16
[debug_info] =>  [nativecode=php_network_getaddresses: getaddrinfo failed: Name or service not known]
[type] => DB_Error
[user_info] =>  [nativecode=php_network_getaddresses: getaddrinfo failed: Name or service not known]
[to_string] => [db_error: message="DB Error: connect failed" code=-24 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info=" [nativecode=php_network_getaddresses: getaddrinfo failed: Name or service not known]"]

)


texts:
I’m hoping to use CiviCRM to manage campaign contacts for voters across many counties and need to upload BOE data to do it. It’s about 210 MB in total, but I have it broken up into CSVs under 30 MB each. Unfortunately, I keep running into a 503 error when I try to use the import wizard with my smallest file (around 3 MB).

I’m using CiviCRM 5.17.4 on Joomla 3.9.12. I’ve increased Joomla’s session timeout and added a bit of code to civicrm_settings.php, following a tip on this guide: https://wiki.civicrm.org/confluence/display/CRMDOC/Importing+Data

I know uploads of this size are a tall order; is there anything that I’m missing or anything else that can be done? There are about a million registered voters here and I don’t think uploading them 4,000 at a time is feasible.

EDIT: If this goes unanswered and someone else runs into the same problem, you can whip up a BAT file to cut up CSVs for you.

https://www.makeuseof.com/tag/how-to-split-a-huge-csv-excel-workbook-into-seperate-files/


texts: Need Legislative District Lookups for CiviCRM/WordPress

texts:
I've been using CiviCRM for WordPress for a few months now. We need to be able to populate both state and federal district fields. I found some relevant links.

https://civicrm.org/extensions/civicrm-congressional-districts-module
https://developers.google.com/civic-information/

Sounds like there are extensions out there but all for Drupal? Please tell me there's one for WordPress???

I've been a geek all my life, but never got into web-based programming or PHP.

Thanks much...Jim


texts: Errors in functions.php after installing 5.16.2 on Drupal 7

texts:
I'm running Drupal 7.67 on PHP 7.1 and am now getting the below error when I invoke Drush commands.

Another gripe is that upon install, Civi blew out my blocks settings, so I needed to reconstruct the site from a window I (thankfully) already had open.

I've not run into either of these issues before. Any suggestions greatly appreciated... thanks!

Warning: Unsupported declare 'strict_types' in /[site]/sites/all/modules/civicrm/vendor/league/csv/src/functions.php on line 12

Parse error: syntax error, unexpected ':', expecting '{' in /[site]/sites/all/modules/civicrm/vendor/league/csv/src/functions.php on line 33
Drush command terminated abnormally due to an unrecoverable error.   [error]
Error: syntax error, unexpected ':', expecting '{' in
/[site]/sites/all/modules/civicrm/vendor/league/csv/src/functions.php,
line 33


texts:
I'm running CiviCRM 4.6.9 (yes I'm late!) with Drupal 7.

I have two groups of contacts (regular, not smart groups) A and B. I need to allow a group of user to view and edit contacts in these 2 groups.

So I created a Drupal role, with "Access CiviCRM" and "Use ajax API" permissions (in Drupal), created my Drupal users, gave them my new Drupal role, then I created an ACL group and a role in CiviCRM, assigned this role to the Drupal role and finally added my privileged CiviCRM contacts in this group. Then I created 4 ACL to the role :

edit contacts in group A
view contacts in group A
edit contacts in group B
view contacts in group B

With only the first two ACLs its working fine, my new users can see and edit contacts in the A group.

When I add the 2 last ACLs, it seems that they "override" the first (group A), and when I try to list all contacts in A group (logged as my new user) I can only see contacts that belong to both group (A and B). I can view and edit all contacts in B group. So when I navigate to "Groups management", I have the correct number of contact for group A, but when I click on "Contacts" on group A line I get fewer contacts (only those who are in both groups).

I tried to create 2 Drupal roles / 2 CiviCRM ACL roles, one for each group (trying to separate ACL across 2 ACL groups), I had the same result.

Is there something I missed here ?

Thanks

EDIT

I think my problem is related to this issue :

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

Apparently it is still pending with no recent patch :(.


texts: How to specify which Activity Types should trigger notifications to the Assignee

texts:
Currently the setting at civicrm/admin/setting/preferences/display?reset=1 (pls don't ask why it is a Display Preference!) is just an On/Off switch.

Looking in to providing an extension so the Activity Types could be specified to include/exclude.

Anyone taken any steps in this direction already?


texts: iATS ACH/EFT payment verification scheduled job not finishing

texts:
We're newer to online contributions and are getting ready for go-live soon.  Credit cards with iATS have processed through with no hiccups.  We recently also enabled ACH/EFT via iATS as a payment instrument for our site.  Our first ACH/EFT transaction (from me) went through fine. The transaction was initiated on 7/21/16; both iATS and my personal bank recognize the transaction is now completed as of yesterday, 7/26/16.

However, CiviCRM still showed the transaction's status as Pending (Incomplete Transaction). The scheduled job for iATS Payments Verification (API Entity: Job; API Action: iatsacheftverify) is enabled and is being processed Hourly (by default; I've changed nothing about the job).  However, when I view the Job Log, I only see the job starting, never finishing:

  Entity: Job Action: iatsacheftverify

  Summary

  Starting execution of iATS Payments Verification

  Details

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

  Full message:  Starting execution of iATS Payments Verification

When I upgraded the iATS extension to 1.5.3 (from 1.5.2) this afternoon and manually executed the job, the job finished and the transaction updated.  Now that a few hours have passed and more hourly jobs ran, it has resumed not working.  I manually executed it again, and the job finished.

So, the issue appears to be that the job finishes when manually executed, but not automatically on its own.  Any ideas on how to proceed? Do I have to configure a cron job specific to/for that scheduled job?

The iATS requirements (#5) specify: "To handle ACH/EFT Contributions (verification of them) and to handle Recurring Contributions (of any type) you must configure cron for your CiviCRM install. Information about how to do this can be found in: http://wiki.civicrm.org/confluence/display/CRMDOC/Managing+Scheduled+Jobs," but I do have cron running.  The iATS Payments Recurring Contributions scheduled job (Entity: Job Action: iatsrecurringcontributions) is running daily (again, by default; I've changed nothing) and has both Starting and Finishing in the Job Log.  For example:

  Entity: Job Action: iatsrecurringcontributions

  Summary

  Finished execution of iATS Payments Recurring Contributions with result:
  Success (No contribution records were processed.)

  Details

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

  Full message:  Finished execution of iATS Payments Recurring
  Contributions with result: Success (No contribution records were
  processed.)

ADDITION:  If I run job.iatsacheftverify from the API Explorer, I get a success. So I tried adding this scheduled job to my server (from Plesk, CentOS 7, no brackets): drush -r {root folder} -l {website URL} civicrm-api -u {user} job.iatsacheftverify --quiet.  When I ran that job I received this error:

PHP Fatal error: Class 'SoapClient' not found in {ROOT}/sites/default/files/civicrm/extensions/com.iatspayments.civicrm/CRM/iATS/iATSService.php on line 164
Drush command terminated abnormally due to an unrecoverable error. [error]
Error: Class 'SoapClient' not found in
{ROOT}/sites/default/files/civicrm/extensions/com.iatspayments.civicrm/CRM/iATS/iATSService.php,
line 164

Line 163-164 of that file:

/* until iATS fixes it's box verify, we need to have trace on to make the hack below work */
$soapClient = new SoapClient($this->_wsdl_url, array('trace' => 1,'soap_version' => SOAP_1_2));

I have no idea what that does. :-)

Civi 4.6.14 (will be updating to 4.6.19 before go-live); Drupal 7.44; iATS Payments extension 1.5.3


texts: Wordpress CiviCRM Profile URL only showing dashboard

texts:
I am using are using Wordpress 5.2.2 and CiviCRM 5.13.4

Is there a way to use the url profile links (or shortcode) like "http://localhost/wp_test/profile/?reset=1&id=4&gid=16&force=1&search=0" to show a Profile view of a specific user (not just the logged in user)?  Or should I just use API calls to grab data and build my own contact view page?  Maybe I just misunderstand the way that Profiles are intended to be used (they totally make sense for data entry forms and changing the way a logged in user views their data).

So far, by manipulating the id variable in the url, it will show the Profile Dashboard for that user id, but no matter the gid I set, only the Dashboard is displayed.  In the CiviCRM documentation here, it explicitly states that this url directory link is not implemented in Wordpress, but I can't tell how old that line is, because it kinda works?


texts: Is it okay to use both Absolute Date and Repeats in Scheduled Reminders

texts:
Asking because the issue we are seeing is that if Absolute date is set for the reminder, and 'repeat' is enabled, then we get an sql condition like this:  ("20181212123815" <= DATE_ADD(, INTERVAL 1 month) which causes problems.

Should this combination be allowed, and hence the code/query needs to be improved to cope with this, or should the combination not be allowed and hence the UI needs to prevent users setting this up


texts: Membership reminders sending each time scheduled job runs after 4.6.2 upgrade

texts:
We upgraded to 4.6.2 in our test environment and since then our membership renewal reminders are sending emails each time the cron job runs. The reminder is scheduled to send 2 days before membership expiration with no repeats. Our cron job runs every 30 minutes, so the reminder is sent every 30 minutes for the entire 24 hour period. Is there something I need to reset? This only happens with reminders that were set up prior to our 4.6.2 upgrade. All new reminders work properly.

This does seem really similar to issues.civicrm.org/jira/browse/CRM-16514. Could use some help looking into it. I can duplicate the issue.


texts: Is there a way to customize Activity Type screens?

texts:
Trying to customize individual Activity Type displays but couldn't find any info on the proper procedure.

I'd like to hide certain fields from certain activity types. For instance, for our food bank activity, I'd like to have the end user enter only the date and names of all households that came. I can't use a profile or a webform because we may have 100 families that use the pantry that day so we are trying to set it up for one activity per day with multiple households. This activity has no need for follow-up, assignees, etc.

I have custom templates up and running and can successfully alter the basic Activity display but would like to get control of each individual type.

Thanks


texts:
When I am changing a query or logic in my hook, I have to reinstall the entire module so then only the updated logic / code works in civicrm.

Is there a settings to clear the cache or something

I tried the below options none works

1. Admin > System Settings > Cleanup Caches

2. http://localhost/drupal/civicrm/menu/rebuild&reset=1


texts: Contribution Status Updates, no more 'overdue'

texts:
I've been trying to follow the contribution status updates and found this link very helpful: http://wiki.civicrm.org/confluence/display/CRM/CiviAccounts+Data+Flow#CiviAccountsDataFlow-Otherchangestocontributionstatus

I have a follow up question/thought. The 'overdue' status is no longer an option for contributions. We had been using this in the case that a donor who had previously indicated they would mail in a check, or the like, never did. We give is a 90 day grace period but then change the status to overdue. (Although we like the language 'expired' better when talking to donors.) We like that this is a separate status than 'cancelled'. In our workflow they represent two different concepts. This is especially helpful when it comes to talking to the owners of PCPs - we can easily see if we cancelled a donation (something we removed due to an error or request) vs a pending donation that simply never came in.

How hard (or crazy) would it be for me to add a custom contribution status?


texts: Can't change payment method in CiviProfile

texts:
We have Civi 5.8.1 on WordPress 5.1

A new contribution was added by an Admin.  Check was accidentally selected and saved for the Payment Method.  When we tried to edit that and change it to the correct Payment Method it just spins after clicking update and nothing happens.  Is this a bug that will be fixed in an update?  Does anyone else have this problem?


texts:
my organization would like to let users (anon and auth) be able to submit a request for a workshop via a drupal webform which would then be approved or denied based on various criteria by management.

Would it be better to have the webform submission trigger civi to record a new event, or activity (i.e. email response) from an admin?


texts: Is it possible to copy the "structure" from one CiviCRM install to another without copying data?

texts: We are testing in a locally hosted config (easy to rollback if something goes wrong, thank you VirtualBOX!) and I am wondering if it is possible to copy the config from the local install to our hosted Wordpress install once we have it all sorted out?  It wouldn't be the worst thing if not possible but it certainly would be a time saver if it is possible.  Any comments/advice/warnings would be appreciated!


texts: Error after upgrading from v5.22.0 to v5.29.1 in WordPress

texts:
I have a WordPress website that is using v5.22.0 of CiviCRM, it was a fresh install and this is my first time trying to upgrade it.
To upgrade to v5.29.1 I followed all steps to the letter:
https://docs.civicrm.org/sysadmin/en/latest/upgrade/wordpress/
When I attempt the final step to upgrade the database which is to point your browser to the URL http://example.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/upgrade&reset=1 (obviously replacing example.org with our domain) I get the error message and there is no Upgrade Now button:

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. Your database has already been upgraded to CiviCRM 5.22.0

Am I done? Is there no database upgrade to be done between v5.22.0 and v5.29.1? Everything appears to be working on the front / backend.... did I do it properly?


texts: Logged in user registers for an event on behalf of a colleage, unintentionally overwrites their contact record details

texts:
We have recently required users to be logged in to access member-only discounts when booking events.

We are finding that some people are logging in and then booking on behalf of a colleague.  They don't book for / attend the event themselves.  They're currently missing the "Not X, or want to register a different person?" link at the top of the booking form.

So they are overwriting their own pre-filled details in the profile.

When they submit the form, eg at:
https://culturalenterprises.org.uk/?page=CiviCRM&q=civicrm%2Fevent%2Fregister&id=288&reset=1

it then updates some details. Most commonly it will update the title, and email, but leave the contact first name and last name unchanged.

Is there any way I can stop CiviCRM from doing this on event registrations?  When I look at the profile settings it is set to update the matching contact when it detects a duplicate, and I'm wondering if that's what is at issue here. (Though obviously I don't want to turn that off!)

I am guessing that this is intended behaviour as CiviCRM assumes the logged in use is providing updated information for themselves?

Thank you

CiviCRM 5.13.4 on Wordpress.


texts: API vs GUI language code inconsistency or how to best use ISO 639-3?

texts:
I am comparing the values that appear in GUI Administration > Localization > Preferred Language options with the ones returned with the API. There you can see that Chinese Taiwan and Chinese China have the same value zh so that they cannot be distinguished.

Then when you use the API:

$result = civicrm_api3('OptionValue', 'get', array(
  'sequential' => 1,
  'option_group_id' => "languages",
  'options' => array('limit' => 0),
  'id' => array('IN' => array(557, 558)),
));

Then it will return beside this GUI 'value' also 'name':

{
    "is_error": 0,
    "version": 3,
    "count": 2,
    "values": [
        {
            "id": "557",
            "option_group_id": "78",
            "label": "Chinese (China)",
            "value": "zh",
            "name": "zh_CN",
            "is_default": "0",
            "weight": "137",
            "is_optgroup": "0",
            "is_reserved": "0",
            "is_active": "1"
        },
        {
            "id": "558",
            "option_group_id": "78",
            "label": "Chinese (Taiwan)",
            "value": "zh",
            "name": "zh_TW",
            "is_default": "0",
            "weight": "138",
            "is_optgroup": "0",
            "is_reserved": "0",
            "is_active": "1"
        }
    ]
}

The Administration GUI keeps this 'name' hidden and I cannot change it nor add it in new Languages, but it is this what is stored as preferred language for a contact, which again can be seen using the API and 'value' is not used anywhere.

May be I am missing something obvious here, but am I right that the GUI does not provide any facility to change code to for instance ISO-639-3? What would be the preferred way to get rid of Civi's default language 'name' options and use an ISO-639-3 equivalent in stead? Setting the 'value' is useless.  Is there anyone that has been doing this successfully? Should I pursue using the API or direct MySQL manipuation to import my own Language options?


texts: How to start with CiviCRM and creating an extension to add Contact Tab in PCP

texts:
I'm new to CiviCRM. I tried to create an extension for CiviCRM to add a tab in PCP and access CiviCRM from the videos on youtube and the document. But I failed to start.
I'm trying to create a Contact Tab in CiviCRM which displays a list of the personal campaign pages that a contact has created.

The tab should show the personal campaign page title (with a link to the page), status, contribution page or event that it is funding for, no of contributions, amount raised, target amount and a link to the edit page form.

Which approach should I follow to get acquainted with CiviCRM and thus able to create an extension. I'm using CiviCRM on Drupal.


texts: Gravity Forms integration with CiviCRM - AutoFill contact field

texts: I have CiviCRM and Gravity form both installed on my Wordpress website. I also bought the CiviCRM + Gravity Form plugin that integrate them together. I want to see how will I be able to use CiviCRM database to autofill the contact information after he logs into the website. For example I have a user who wants to fill out this application, and he already has a WP username and password. So when he logs in, I want this form to autofill his contact information (prefix, FirstName, LastName, Email, phone number, and the full address). Obviously, it should be getting this information from his CiviCRM database.


texts: Handling null values in tokens in civimail (and elsewhere)

texts:
Has anyone developed an extension to handle null values in tokens?

For example:

Sending an email to a contact with no first name:

Dear {first.name}, will end up as  -> Dear ,

It appears that previously in 3.3 it was possible to use {first.name | default text}

Additionally a long while ago there was some discussion about reviving this behaviour.

Following this there was this post about how to change the behaviour site wide, however to enable more personalised emails (both in terms of the sender and recipient) would be great to allow for this to be done on a per email basis as well.

Following that I can only spot this SE question referencing the issue last year.


texts: How to make the contact autocomplete in Webform Civicrm to search for contacts that contain a search term, not start with

texts: When you add an existing contact field to Webform Civicrm the autocomplete searches for contacts that start with the search term. How do you change the autocomplete function to search for contacts that contain the search term in any part of the name, not just the beginning?


texts:
The CiviCRM download page shows that it is available for Drupal, WP & Joomla
I came across CiviCRM via the Joomla Extensions directory, but it seems not everything is equal among the CiviCRM installs; in particular no sample data for Joomla.  I also had problems with the 4.7.6 build and not until I tried the 4.7.7 did I get anything up and running under Joomla - but the dashboard doesnt load (I'm using WAMP for a dev environment).

What is the most supported CMS from the 3x available as far as CiviCRM is concerned.


texts: What Drupal modules do I need in order to

texts:
I'm working on an electoral project.  I'd like to try a little experiment with direct democracy.  All involved would be Contacts within CiviCRM.

What Drupal/CiviCRM modules/extensions would I need to accomplish the following:

Each candidate would have content (Blog/Forum/Polls) created by them that is viewed only by Contacts within their electoral district.  The electoral district relationships are in pre-loaded CiviCRM multi-value custom fields.
Each contact (voter) would be able to see and edit (comment/poll vote) the content from #1 for each candidate in a district that the voter resides in.  Content from other candidates would be invisible.
A contact can be both a candidate and a voter.
I've already got ACLs set up which associate a candidate user ID with the voter Contacts in the electoral district.  I can, if necessary, create an ACL which associates a voter user ID with all the candidate Contacts in the voter's districts, although that seems very cumbersome.

I'm assuming that all of the candidate/voter interaction will occur within Drupal content.

CiviCRM 5.3.2
Drupal 7.60


texts:
When doing an import for existing contact that I want to update, after selecting Fill (For Duplicate Contacts), I get a Warning, a Notice but no import :

    Warning: array_pop() expects parameter 1 to be array, null given in CRM_Contact_Import_Parser_Contact->import() (line 706 of /var/data/sites/sitename/public_html/sites/all/modules/civicrm/CRM/Contact/Import/Parser/Contact.php).
    Notice: Undefined offset: 1 in CRM_Contact_Import_ImportJob->_addImportedContactsToNewGroup() (line 393 of /var/data/sites/sitename/public_html/sites/all/modules/civicrm/CRM/Contact/Import/ImportJob.php).

There is a Warning and a Notice for each contact submitted.

The Dedupe Rule is selected to Email
The version of CiviCRM is 4.7.22

I have a feeling that something is corrupted in the database.

Thanks for your help.

Regards.

Ichi


texts: Is there a report that will group by source of contact?

texts:
We have stared to use the contact source field to designate how our contacts get into CiviCRM. (event, membership, donation, helpline call etc.

I would like to be able to have a report that lets me filter by contact source and show the numbers from that source by month.  (A pivot tabe  would be OK but isn't ideal as contact source is a free text field.) I haven't be able to find a core report or reprot in an extension that will do either.

It seems like something other organisations might also be interested so someone might have already created an appropriate report.

Does anyone know of a report that will provides that summary information?


texts: Unable to drop mydashlets on my Dashboard

texts:
Can't drop my dashlet in the civicrm dashoard.
I can drag it out but it wont drop anywhere.

Here is an image of me dragging it but the dashboard isn't opening up to drop it.


texts: Styling the webform contact autocomplete box

texts:
I've been working on a site using bootstrap which has a dark background and white text. This seems to be causing some problems for the webform contact autocomplete box where the default background is white, but is presumably picking up the white body text also.

Could anyone point to the CSS file which styles the autocomplete box?

Many thanks!


texts: When the smart group cache is regenerated, are disabled smart groups regenerated?

texts: I work with a CiviCRM install with about 400 smart groups - but only about 30 of them are enabled.  I'm seeing slow performance - I'm wondering if anyone knows definitively whether my disabled smart groups are affecting performance?


texts: Hi I am thinking about using CiviCRM and we are implementing a recurring giving program. How would I set up CiviCRM to track recurring monthly, bi-monthly, quarterly or annual donor contributions and send them reminders that their credit card is going to be charged?


texts: Wrong calcuation of event.balance value in reminder email

texts:
A client is reporting that the value for the {event.balance} token sent via a reminder is incorrect. It's showing a negative balance. The two documented cases (via forwarded emails from the event registrants) were both case where one partial payment had been made.

The replacement for {event.balance} should be:

Total registration fees minus partial payment(s)

Instead the token was replaced with the following value:

Event balance minus partial payment

Any ideas about what might be causing this or how to troubleshoot it?

Site running CiviCRM 4.5.8 and Drupal 7.36. PHP is 5.4.30. MySQL is 5.5.42


texts: Can commercial organisations use CiviCRM

texts: Your website states that you are a CRM system for non-profits. As an open source setup, can commercial entities and freelancers use your platform?


texts: What permissions are needed for someone to complete a Contribution page that includes a profile

texts:
I've created a contribution page that users must use to become members. Before they can access the form, they must be logged-in to the WordPress site. By default, they are given the role of Subscriber.
When I first tried running the form, I kept getting the following error, indicating that the user didn't have permission to view the profile:

Sorry but we are not able to provide this at the moment.
The requested Profile (gid=14) is disabled OR it is not configured to be used for 'Profile' listings in its Settings OR there is no Profile with that ID OR you do not have permission to access this profile. Please contact the site administrator if you need assistance.

I went into User Permissions and added a few profile related permissions, and now they can access the form, but are resented the option of registerin gas a different person, which is not an option I want to present. I can't seem to find the correct combination of permissions.
What's even stranger, to me, is that an anonymous user, that isn't logged in at all, can access the contribution page, complete with profile.
Can someone clarify what permissions a user must have in order to use a contribution page that includes a profile allowing them to edit/add their personal details, but not allow them to perform the operation for someone else?
Running CiviCRM 4.7.6 on WordPress 4.4.2.


texts: Is it safe to remove INDEX keys for multi language installation?

texts:
We enabled multi language support in Civi 5.21.1 then tried to create a new custom field group with Select or Radio options. The error from the DB is below (***edit: This doesn't happen when adding fields to an existing Group):-

[db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_custom_field (custom_group_id , name , label , data_type , html_type , default_value , is_required , is_searchable , is_search_range , weight , help_pre , help_post , is_active , is_view , options_per_line , text_length , start_date_years , end_date_years , date_format , time_format , note_columns , note_rows , column_name , option_group_id , filter , in_selector ) VALUES ( 77 , 'Test_2' , 'Test 2' , 'String' , 'Radio' ,  NULL ,  NULL ,  NULL ,  0 ,  2 ,  NULL ,  NULL ,  1 ,  NULL ,  NULL ,  255 ,  NULL ,  NULL ,  NULL ,  NULL ,  60 ,  4 , 'test_2' ,  204 ,  NULL ,  0 )  [nativecode=1062 ** Duplicate entry '77' for key 'UI_label_custom_group_id_en_GB']"]

After doing some digging, it seems that two tables now have additional keys:-

custom_data_group has the key 'UI_title_extends_en_GB'
custom_data_field has the key 'UI_label_custom_group_id_en_GB'

After disabling multi language support, the keys remain and we are still unable to add options.

Removing the keys from MySQL using the commands below resolves the error:-

alter table civicrm_custom_field drop index UI_label_custom_group_id_en_GB;

and for the group:-

alter table civicrm_custom_group drop index UI_title_extends_en_GB

Is it safe to enable multi language support without these keys?


texts: Can Gravity Forms be integrated with CiviCRM?

texts: We have a site that has 5 different Gravity Forms currently. They work great and we love them. We're planning on setting up CiviCRM for this organization in WordPress and want to know if its possible to map all the data from our current forms directly into CiviCRM. Is this possible?


texts: cms.root.path error after upgrade to 4.7 (Joomla)

texts:
I upgraded two installations of CiviCRM 4.6.11 to 4.7 on the same server. Both upgraded fine, but now have the following errors:

1) Systems Settings --> CMS Database integration shows nothing (no paths or fields displayed). Normally I would expect at least a field to enter the Joomla Users Table name.

2) Systems Settings --> Directories shows this error:

Sorry but we are not able to provide this at the moment.

Cannot resolve path using "cms.root.path"

Return to home page.

Anyone else seen anything like this? There are no php errors logged (but some warnings), and the CiviCRM log shows this:

$backTrace = #0 ...civicrm/CRM/Core/Error.php(444): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 ...civicrm/CRM/Core/Invoke.php(57): CRM_Core_Error::handleUnhandledException(Object(RuntimeException))
#2 ...civicrm.php(116): CRM_Core_Invoke::invoke((Array:4))
#3 ...civicrm.php(40): civicrm_invoke()
#4 ...CMS_root_directory.../libraries/cms/component/helper.php(392): require_once("...civicrm...")
#5 ...CMS_root_directory.../libraries/cms/component/helper.php(372): JComponentHelper::executeComponent("...CMS_root_directory.../administrator/components/com_civicrm/civicrm...")
#6 ...CMS_root_directory.../libraries/cms/application/administrator.php(98): JComponentHelper::renderComponent("com_civicrm")
#7 ...CMS_root_directory.../libraries/cms/application/administrator.php(152): JApplicationAdministrator->dispatch()
#8 ...CMS_root_directory.../libraries/cms/application/cms.php(252): JApplicationAdministrator->doExecute()
#9 ...CMS_root_directory.../administrator/index.php(47): JApplicationCms->execute()
#10 {main}


texts: How to trigger USPS address standardization on API address create?

texts: It looks like addresses created by an API call do not go through the USPS address standardization routine.  Is there a way to trigger the standardization through the API?  Or what is the BAO function call to trigger it directly?


texts: When did IIF amount formats change and how can I get it back to old format?

texts:
How does the IIF export from Accounting Batches get its information to determine the format of the amounts?  Batches created before 5.34 export simple value amounts:
12.00
-12.00

Batches after the upgrade to 5.34 adds a dollar sign to the amount:
$12.00
-$12.00

I can't get these files imported without loading them into Excel and changing the formatting.  How can I get the amounts to return to the earlier format?  What changed in Civi to cause this?


texts: Wordpress user registration only through CiviCRM

texts:
We have our site set up so that folk join our group through a Civi profile which then sets up a Wordpress user account. This is as it should be. However we occasionally get registrations directly through the /wp-login.php form which bypass the additional data we want in civi. These are invariably spam registrations that need manually deleting.

We've experimented with plugins Theme My Login and WPS Hide Login but things get complicated without actually resolving the issue of preventing 'back door' registrations.

Is there a simple way to ensure registrations are via CiviCRM?


texts: how can I filter the list for address > "country" field in "new individual"

texts: I want to filter the option list of the "country" field on the address tab.. I found out that the country field is getting the list of country field in "civicrm_country" table and I want to add a new column "is_active" on the table for the filtering but I can't find the function that generates the list.. does someone know where I can find the function generating the option list so I can add the filter? thanks a lot


texts:
I have a (new) installation with civiCRM 4.7.2 (Joomla 3.4.8) regarding the display size of the "Notes". For my template I know where to find the style information, however I have difficulties to locate the layout for the back-end and front-end notes of civiCRM.

As you can see the back-end detailed view of notes has some layout problems. The text gets extremely unreadable using the default settings. It would be far better for usability to have a wider text field. See below:

Somehow interrelated could be the narrow default field size if notes is displayed in the front end. "Your Request" is actually the notes field. Yes there is the pull handle (red) to re-size the imput field, but most users are missing it! So is there a way to re-size the default (orange) width for this as well -- and might it be the same value?

Thank you very much for your suggestions.

B ert


texts:
I'd like to have a widget track all contributions on the site but it appears that is not possible as each widget is tied to a contribution page. Is there any custom code anyone has developed to do this?

Alternatively, I've just done a work around solution that is not that optimal. I could manually switch the "Online Contrubution Page" it is under by going to Edit Contributions>Additional details. The one concern I have is would this have any adverse effect on paypal monthly recurring donations? Would PayPal and CiviCRM still communicate properly?

Thanks all, this is my first post to the forum though I've been using CiviCRM for a few years.


texts:
I upgraded CiviCRM from 5.6.1 to 5.9.0 and later tried 5.10.4.  Both time the credit card icons on our contribution and registration pages were missing after the upgrade (see image).  I had to revert back to 5.6.1 (edit: icons are the same as the security code icon).

I was able to successfully upgrade our test site.  I also copied the production database to the test site (CiviCRM 5.10.4) and ran the database upgrade.  The credit card icons were present.  This tells me that the production database is OK.  What could be wrong?  What should I try next?

We use Wordpress and PayPal Standard.

Added 3/6/2019

I duplicated the problem on a new test site that is a near copy of our production site (copied all the website files and the CiviCRM database).  I noticed that the HTML code for the credit card icons on the malfunctioning contribution page doesn't match that of a good page (see code below).

Bad HTML Code

[object Object]

Good HTML Code

Visa


texts: How to alter Event Dropdown values from Register Participant or New Event Registration Page?

texts:
On Register Particpant Page, I see list of all Events under Event dropdown
As per the requirement, I am using Recurring Entity to have repeat events,so I need to hide repeat events and display only parent events
How can we alter the results in the Event dropdown

The Event dropdown has this form structure (from hook_buildForm)
When I add a condition and try to print variables inside it on New Participant Registration it does not show up.(probably since its entering )

 $apiRequest['entity'] == 'event'

/**
 * Implements hook_civicrm_apiWrappers
 */
function custom_changes_civicrm_apiWrappers(&$wrappers, $apiRequest) {

  if ($apiRequest['entity'] == 'event' ) {
    print_r('<pre>');
    print_r($apiRequest);
    print_r($wrappers);
    die('ed');
 }
}

On adding the code answered below

if ('CRM_Event_Form_Participant' == $formName) {
    $elementIndex = $form->_elementIndex['event_id'];
    $element = & $form->_elements[$elementIndex];
    $dataApiParams = json_decode($element->_attributes['data-api-params'], TRUE);
    $dataApiParams['params'] = ['parent_event_id' => ['IS NULL' => 1]];
    $element->_attributes['data-api-params'] = json_encode($dataApiParams);   }

I get an error (when I comment I don't get the error).

  Error: Call to undefined method stdClass::getName() in
  HTML_QuickForm->accept() (line 1686 of
  csites\all\modules\civicrm\packages\HTML\QuickForm.php).

To fix that I actually went to QuickForm.php and added an if condition as seen below

if(method_exists($element,'getName')

Is that a correct method and if not , how can I debug that further based on the error log.

 function accept(&$renderer)
    {
        $renderer->startForm($this);
        foreach (array_keys($this->_elements) as $key) {
            $element =& $this->_elements[$key];
            if (method_exists($element,'getName')){
            $elementName = $element->getName();
            $required    = ($this->isElementRequired($elementName) && !$element->isFrozen());
            $error       = $this->getElementError($elementName);
            $element->accept($renderer, $required, $error);
            }
        }
        $renderer->finishForm($this);
    } // end func accept


texts:
I have a custom data field that is a profile that I'm sharing via the frontend of my web site (to Registered users).

I'm using Joomla 3.8.x and civiCRM 5.10.0 -- I've set the custom field as "Note Rich Text Editor" but when include the field in a profile to allow registered users to complete the field, the editor doesn't appear -- just a text box.

Any ideas why this would be?


texts: Adding Facebook tracking pixel to contribution confirmation pages

texts:
We're on Drupal 7.69 and CiviCRM 5.13.x.

One of our clients want to add facebook tracking pixel codes to the membership confirmation page after payment.

We are using the Facebook Tracking Pixel Drupal module (https://www.drupal.org/project/facebook_tracking_pixel) to add the base tracking for the website and for webform confirmation pages. Would someone be able to help inform me on using the same module for CiviCRM confirmation pages?

Thanks


texts: Does changing a price set for an event retroactively change reports?

texts:
If a price set is changed in terms of prices etc will that affect reports for past events that used that same price set?

If it did do that we would have a huge list of price sets just to maintain reporting!

Cheers!


texts: We're importing participant data from all our old events. However, I've run into the issue that it only allows me to pick dates back to 1999 when creating the old events. I need to go back as far as 1970. Where do I go to change that setting? I found it for activities and such, but nothing that has affected the listing for events.


texts: Add new contact (other than logged in user) using Caldera Forms linked to CiviCRM under Wordpress

texts:
Civi 5.10.4. under Wordpress 5.1.1 multisite network using the plugins Caldera Forms and Caldera Forms CiviCRM. I'm seeking to create a new contact creation form for our incarcerated persons visitation & advocacy program. For example, one of our program coordinators gets a call or letter from a detained person that coordinator needs to create a new detained person contact record. The longer term goal is to create a system to track activities like visits, letters, transfers, and complaints. I'm starting by trying to make an interface to create new detained person contacts. I created the detained person contact type, created some of the fields we'll use, and made a profile to contain some of those. Then I created a Caldera Form and mapped the form field names to the detained person contact type.

When I use the form to create a new contact, it updates my own contact record rather than creating a new record. I've tried setting the form processor to link to either Contact 1 or Contact 2, but seem to get the same result. I think there's something I'm not understanding about how to set up the processor.

Can I use Caldera to create a new contact (other than the person logged in)? If so, how? Additionally, it would be ideal to track who was the logged in user who created the new detained person contact. Do I need to create an activity processor for that?

Thanks in advance for any help and guidance the community can provide on this.


texts: Got an error while installing new UI theme shoreditch for civicrm?

texts:
I was trying to install new UI theme i.e.shoreditch for civicrm.
While installing it gives an error.

I also tried to change the hostname i.e. localhost to 127.0.0.1 but couldn't work.


texts:
Prior to updating to CiviCRM 4.7 our customers received receipts that included:

Membership fees with each item listed separately with a description
and price.
Transaction number
Billing Name and Address
Credit Card Information (only last four of credit card)

Also, the subject line used to reflect wether this was a receipt or an invoice.

After we installed 4.7 this information stopped displaying on the receipt. Issue here
https://issues.civicrm.org/jira/browse/CRM-18027
CiviCRM 4.7.10, drupal 7.50

$contributeMode is being set to "notify" for credit card payments, which is why credit card information isn't being printed.

I'm trying to update the receipt template to work around this issue.
Can someone explain if it's correct behaviour that $contributeMode is being set to "notify" for credit card payments, or is that a bug ? What does it mean ?

Is there a(nother) way to check, in the receipt template, if a payment is not only of $contributeMode 'notify' but specifically a credit card payment ? I read 'paymentMethod' is supposed to be set - who should be setting that ?

As far as I can see, the default receipt templates in 4.7.10 don't mention 'paymentMethod' anywhere. Should they, or do I have outdated templates ?


texts:
Trying to add an extension, I get the following error:

Database Error Code: Column 'entity_id' cannot be null, 1048
Additional Details:
Array
(
    [callback] => Array
    (
        [0] => CRM_Core_Error
        [1] => handle
    )

[code] => -3
[message] => DB Error: constraint violation
[mode] => 16
[debug_info] => INSERT INTO civicrm_managed (module, name, entity_type, entity_id) VALUES ('ca.civicrm.moneris','Moneris','PaymentProcessorType',(SELECT id FROM civicrm_payment_processor_type where name = 'Moneris')) [nativecode=1048 ** Column 'entity_id' cannot be null]
[type] => DB_Error
[user_info] => INSERT INTO civicrm_managed (module, name, entity_type, entity_id) VALUES ('ca.civicrm.moneris','Moneris','PaymentProcessorType',(SELECT id FROM civicrm_payment_processor_type where name = 'Moneris')) [nativecode=1048 ** Column 'entity_id' cannot be null]
[to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_managed (module, name, entity_type, entity_id) VALUES ('ca.civicrm.moneris','Moneris','PaymentProcessorType',(SELECT id FROM civicrm_payment_processor_type where name = 'Moneris')) [nativecode=1048 ** Column 'entity_id' cannot be null]"]
)

Is my extension out of date, or is this fixable?

~ross


texts: How to send specific webinar links to event registrant based on events selected, with scheduled reminders?

texts:
We have a weekend event with eight webinar sessions with registration costs. People can register for individual sessions, for all sessions with a discount or for whichever set of sessions they would like. I'd like to be able to send them a set of links for the particular sessions they have registered for. How can I make this happen?
I'm guessing webform is part of the solution and that's fine. I could see some kind of system with key/value pairs for each selection and an option that selects all the sessions if you choose the discounted weekend pass. That would get me the registration confirmation email, but I'm not sure how to get a scheduled reminder with this same information in it. All I can think of is to change the email and use re-send emails for each registrant, but that would be a real pain to click through to each to re-send emails one by one. Also, I'd like to allow people to register additional participants, so each participant would need to get an email instead of just the person who registered them.
Is there a solution that allows customizable scheduled reminder content based on registration details? This would be great for many events, not just webinars.


texts: Activity Duration in Hours extension NOT working for CiviCase

texts:
Currently using CiviCRM Version 5.31 (Wordpress Version 5.5.3)
Installed the extension to change Activities Duration from Minutes to Hours
https://lab.civicrm.org/extensions/activityhours
The extension works for Contact Activities but not Case Activities.

Does anyone know what needs to be done to make the changes in Case Activities ?
===========================================================================
Hi Demerit, thank you for the prompt response.
I changed the lines in both activityhours.php and activityhours.js but the duration for case activities are still in 'minutes'.
Please advise


texts: CiviEvent registration with pay later prevented with "missing fields" error

texts:
We're running 4.6.8 on WordPress 4.2.4. I'm not finding guidance on this searching the web. Here's the CiviEvent registration page link:

http://civicrm.jrpc.org/?page=CiviCRM&q=civicrm/event/register&page_id=111

We have an event that when registering by PayPal - it all works. But if "pay later" is chosen - it's complaining about missing fields that have already been filled out (address), or for the first and last name- it complains about the Country and Billing Name & Address that are not in our requested profile. Full error below:

Please correct the following errors in the form fields below:

Billing First Name is a required field.
Billing Last Name is a required field.
Street Address is a required field.
City is a required field.
State/Province is a required field.
Postal Code is a required field.
Country is a required field.

Any ideas? Our last event (before a few civievent upgrades), this feature worked fine.


texts: I only want people to confirm their membership type (or choose another one) via a webform, but no membership to be renewed or created

texts:
Is that possible via webform-civicrm?

I can think of just making it a webform only field, so no connection to CiviCRM, but then the user does not see his current setting.

I can also think of creating a custom module that gets the current value via API and placing it in the webform only field, but am curious if I overlooked something and whether this is possible without custom coding.


texts: Assigning only a part of a contribution to a Contribution Page

texts:
Our organization just had its annual fundraising dinner/auction. People paid in one transaction for a number of things: auction items, raffle, sales tax, etc., as well as donations designated for a number of things. Most of this am recording in Civi using a Price Set with Text/Numeric Quantity for the various fields.

However, undesignated donations are going to a specific campaign that is a challenge match. I have also set up a Contribution page for this Matching Challenge. I want to be able to record the amount from only one of the price fields against this Matching Challenge Contribution Page - so the widget on our website is accurate among other reasons.

For instance, I might record this as a transaction:

Name: Joe
Total Amount: $175
Payment Instrument: Credit Card
Price Field: Auction = $100
Price Field: Raffle = $25
Price Field: Match donation = $50

So, only the $50 should be counted to the Matching Challenge contribution page.

Is there any way to do this other than making it two transactions, which could lead to confusion?


texts: CiviDiscount Navigation URL broken on Joomla

texts:
After upgrading to Joomla 3.6.5 (from, I forget which - should have made a note) the CiviDiscount navigation URL is broken (sends me to the CiviCRM dashboard). I also did a more minor update of CiviCRM to 4.7.14 (from 4.7.10ish) immediately after.

This question deals with a similar problem in Drupal. This is the URL that I am sent to from the menu:
http://[site]/administrator/?option=com_civicrm&task=civicrm/cividiscount

What should it be instead?


texts:
New mailings with all required fields and the default responsive template do not enable the Next or Test mailing buttons. As a workaround I can reuse an old mailing and update the fields. The last successful mailing was sent using 4.6.2, the current installed version of CiviCRM is 4.6.3.

Drupal 7.38


texts: After upgrade to 4.7.29, 500 error on payment

texts:
WI upgraded to 4.7.29 and get this error when on a contribute page. As far as I can see, the file CRM/Core/.php does not exist. What would/should create it?

Got error 'PHP message: PHP Fatal error:  require_once(): Failed opening required 'CRM/Core/.php' (include_path='/var/www/slnmembers_drupal/sites/default/files/civicrm/extensions/uk.co.vedaconsulting.mailchimp/:/var/www/slnmembers_drupal/sites/default/files/civicrm/extensions/com.drastikbydesign.stripe/packages/:/var/www/slnmembers_drupal/sites/default/files/civicrm/extensions/com.drastikbydesign.stripe/:.:/var/www/slnmembers_drupal/sites/all/modules/civicrm:/var/www/slnmembers_drupal/sites/all/modules/civicrm/packages:.:/var/www/slnmembers_drupal/sites/all/modules/civicrm:/var/www/slnmembers_drupal/sites/all/modules/civicrm/packages:/var/www/slnmembers_drupal/sites/all/modules/civicrm/vendor/tecnickcom:/var/www/slnmembers_drupal/sites/all/modules/civicrm/vendor/phpseclib/phpseclib/phpseclib:/var/www/slnmembers_drupal/sites/all/modules/civicrm/vendor/pear/pear_exception:/var/www/slnmembers_drupal/sites/all/modules/civicrm/vendor/pear/auth_sasl:/var/www/slnmembers_drupal/sites/all/modules/civicrm/vendor/pear/net_sock...\n'


texts: "Cron not running" (but it is), trying to use wp-cli in crontab, with WordPress

texts:
Running CiviCRM 4.7 on WordPress 4.7.3, hosted on a shared Linux server at 1and1.com.

CiviCRM System Status screen says "Cron not running" even though it is.

Trying to use wp-cli in crontab

wp help at the command line brings up the list of wp-cli commands.

Ran wp --info and got

PHP binary: /usr/bin/php5.5-cli
PHP version:    5.5.38
php.ini used:   /usr/lib/php5.5/php.ini
WP-CLI root dir:    /usr/share/php/wp-cli
WP-CLI packages dir:
WP-CLI global config:
WP-CLI project config:
WP-CLI version: 1.0.0

So tried this in crontab (sensitive values changed):

*/2 * * * * /usr/share/php/wp-cli --user=cronuser --url=http://mydomain.org --path=/myserver/homepages/34/d1111111/htdocs/mysite/ civicrm api job.execute auth=0

Didn't seem to work, so I tried this from the command line:

/usr/share/php/wp-cli --user=cronuser --url=http://mydomain.org --path=/myserver/homepages/34/d1111111/htdocs/ysite/ civicrm api job.execute auth=0

And got:

/usr/share/php/wp-cli: Is a directory

There is a wp-content/plugins/civicrm/wp-cli directory. I tried using the full path to that instead of /usr/share/php/wp-cli but the same results.

Any suggestions would be welcome!


texts: allow public access to entityRef field contact lookup

texts:
I need to add an entityRef lookup field to a public facing profile form so that users can search and select organization contacts. I patterned it after the current employer lookup in the contact record with slight changes (you can't create a new contact):

$props = array(
  'api' => array('params' => array(
    'contact_type' => 'Organization',
    'check_permissions' => 0,
  )),
);
$form->addEntityRef('employer_id', ts('Organization'), $props);

If I access the form anonymously, the lookup fails with a permission error. If I grant the public user "access AJAX API" it does not fail, but does not return any records (because the public user isn't permissioned to view all contacts). You'll see that I attempted to modify the API with check_permissions, but it has no impact.

With "access AJAX API" enabled for the public user, the alterAPIPermissions hook is hit -- so I could modify the perms and avoid granting the public user "view all contacts" permission.

My question is:
What are the consequences of giving the public user access AJAX API permission? Is there some way to avoid having to do that? Is the above the right way to implement this -- to grant that permission and them modify the actual permissions with the hook?

EDIT:
Actually, I don't seem to be able to grant sufficient permissions with alterAPIPermissions. I've tried:

$params['check_permissions'] = 0;
$permissions['contact']['get'] = array('profile create');
$permissions['contact']['getquick'] = array('profile create');

(the anonymous user has profile create permission) and the entityRef still returns no records.


texts:
Problem in upgrade gives this warning.  PHP Notice:  Undefined index: CRM_Upgrade in /home/depot/public_html/drupal/sites/all/modules/civicrm/CRM/Queue/Service.php on line 131

Then trying to post events causes a json error.  Ideas?


texts: Recurring contributions not sending emails (Stripe)

texts:
I'm setting up a contribution page using the Stripe payment processor. In testing mode, one-off donations work fine in that they show up as expected in the test pane in the Stripe account, donations show up in CiviCRM, and also send the Thank you email specified in the Contribution page settings.

When I check the box to recur monthly, however, although everything else works as above, neither the initial email nor followup recurring payment emails are sent.

There is an issue related to this in the Github queue but it's kind of stagnant and was hoping someone here could give me a pointer on where to look to try to solve this.

(CiviCRM version 4.6.3 with latest dev version of the CiviCRM-Stripe extension)


texts: Menu Problem with CiviCRM 5.26.0 in Drupal

texts:
My CiviCRM menu bar doesn't appear at the right place on the page and its stylesheet is not loading.

I have the same symptoms as in question Menu Problem with CiviCRM 5.13.2 but the solutions they offer there do not solve my issue.

Since the picture of the heading at http://***.be/sites/default/files/ocsr.png doesn't show up, I discovered that the files under the directory <drupal_root>/sites/default/files are not served anymore by apache when requested by the browser.

There is a .htaccess file in that directory containing:

# Deny all requests from Apache 2.4+.
<IfModule mod_authz_core.c>
  Require all denied
</IfModule>

# Deny all requests from Apache 2.0-2.2.
<IfModule !mod_authz_core.c>
  Deny from all
</IfModule>

# Turn off all options we don't need.
Options None
Options +FollowSymLinks

# Set the catch-all handler to prevent scripts from being executed.
SetHandler Drupal_Security_Do_Not_Remove_See_SA_2006_006
<Files *>
  # Override the handler again if we're run later in the evaluation list.
  SetHandler Drupal_Security_Do_Not_Remove_See_SA_2013_003
</Files>

# If we know how to do it safely, disable the PHP engine entirely.
<IfModule mod_php5.c>
  php_flag engine off
</IfModule>
<IfModule mod_php7.c>
  php_flag engine off
</IfModule>

My knowledge of apache is too poor to understand if this file is the guilty, but in the logs of apache, I see entries as:

[Tue Jun 09 14:18:54.299253 2020] [authz_core:error] [pid 30658] [client 127.0.0.1:42982] AH01630: client denied by server configuration: /usr/share/drupal/sites/default/files/civicrm/persist/contribute/dyn/crm-menubar.4153687684a8323812edc1dc3cdbefbd.css
[Tue Jun 09 14:38:46.732818 2020] [authz_core:error] [pid 22455] [client 127.0.0.1:43090] AH01630: client denied by server configuration: /usr/share/drupal/sites/default/files/ocsr.png

that seem to be connected directly with my issue.

Since I am a newbie with CiviCRM, I don't have any clue about how to solve this.

Perhaps another useful information: I didn't have time to upgrade to the last version of Drupal 7 up to now. I don't know if the problem is coming from that delay and I don't know what is better: first solve the issue and then upgrade, or the contrary.


texts:
I'm using CiviCRM + Drupal 8.
I'd like to be able to add fields to contacts that can record audio &/or video, so that we can collect interviews with our contacts.
Is it possible to add "recording" fields that will allow you to record from within CiviCRM?
If not, what's the best way to set up contact fields to allow you to upload an audio/video file to a contact's record?


texts: How can I pass in the contribution amount via URL?

texts:
Is there a quick way to pass in the contribution amount via URL on custom amounts?

http://example.org/civicrm/contribute/transact?reset=1&id=2&price=35

I'm not looking to use a price set, just a total amount. Ideally, I'd like to pay an existing contribution and bring up a form with the amount and contribution to pay against with a credit card.


texts: Check custom data field value change to trigger activity status change

texts:
How would you recommend to check data change (with pre and post values) on a custom field (attached to a case) and then to mark an activity in that case as completed?

I have looked at hooks like hook_civicrm_custom and the _pre/_post hooks, but having difficulty getting this to work.

Thank you!


texts: How can many email, address and phone records suddenly disappear?

texts: Title says it pretty much and came to us from a client. The initial concern was that this had occurred due to an upgrade. There was plenty of evidence in the log tables however to show that the data had been deleted by a particular user in bulk.


texts: Disable Outbound email or change SMTP server with an SQL Query?

texts:
How can I activate the "Disable Outbound email" option or change the SMTP server address with only an SQL Query?

(My use case is when I copy live data to a test environment, I obviously want to make sure no real emails are sent from the test environment!)

Thanks,


texts: Custom membership status is not being updated

texts:
We always used a customized 'Membership Status', named 'geldig lid' (means: valid member). I don't know why this was done in the past, cause it actually corresponds to the built in status 'Current', but since we have quite some mailing lists connected to 'geldig lid', I'd like to continue using that one.
Now, for some reason, the customized status 'geldig' lid, doesn't work as it should. And  In order to investigate what goes wrong, I changed the order of the assigned statuses to 'Current' first and 'geldig lid' second. But the settings for both statuses are exactly the same. See attachment:

When I look for the members with status 'geldig lid', I find 19527 contacts, which is not correct cause in a lot of cases 'membership end date' is already in the past. Doing the same with 'current', I find 5824 contacts (which is correct). See attachment:

Can somebody explain what is happening here?


texts:
We're still on an ancient version of CiviCRM (4.7.x) and CiviDiscount (3.2) and Drupal 7.x

A small number of our event registrations are coming in with no price set options actually selected. It's dumping all of the options into the "Event Level" field. Pictured below.

When I select "Change Selections" all of the price set options are blank/not selected. We received payment for the correct choices, however. Does anyone know what's causing this for sure? I want to upgrade our site, but not recklessly.


texts: Field Source doesn't appear in Import Contributions

texts:
I'm trying to import contributions. I found all the fields except the "Source" field.

Is there any reason for not appearing? Is there a way to show it?

Thanks in advance. :)


texts: Civisualize can't find JS and CSS resources

texts:
I've got Civisualize running very nicely on an installation of CiviCRM 4.5 and Drupal 7 with some custom templates and queries. I then moved a copy of the whole site across to a different server under a different URL. After a bit of fiddling around, everything is now working under the new server/URL, except for Civisualize. I can access the dataviz template pages but no graphs/data are displayed.

The problem stems from the Civisualize extension looking for the d3 javascript and css resources in a place that they're not but I've no idea how to force/trick/coerce Civisualize to look for them elsewhere. Directories and Custom Ext path have been set up correctly and disabling/uninstalling/re-installing the extension hasn't helped.

Any suggestions as to what to try next?


texts: Unable to load AngularJS pages, e.g., CiviVolunteer and CiviCRM status page

texts:
The following links in the CiviCRM admin menu don't work for me:

Volunteers > New Volunteer Project
Volunteers > Manage Volunteer Projects
Volunteers > Search for Volunteer Opportunities

When I navigate to these links the page never loads; the CiviCRM icon just keeps spinning indefinitely as though it's still processing my request.

I reset the paths and cleared the caches but that didn't help. I also don't see any errors in Reports > Recent log messages (Drupal admin UI).

Background info:

CiviCRM 5.7.2
Drupal 7.61
Bilingual English & Spanish site
Previous issue with CiviVolunteer led me to apply patch provided here: Permission role to access Cases when using Volunteer?
I only recently installed CiviVolunteer using the CiviCRM admin UI

These are my settings:

Extensions Directory: [civicrm.files]/ext/

Extension Resource URL: [civicrm.files]/ext/

URL Variables:

[cms.root]  https://example.org/

[civicrm.root]  https://example.org/sites/all/modules/civicrm/

[civicrm.files] https://example.org/sites/default/files/civicrm/

Path Variables:

[cms.root]  /home/example/www/www

[civicrm.root]  /home/example/www/www/sites/all/modules/civicrm

[civicrm.files] /home/example/www/www/sites/default/files/civicrm

Location of CiviVolunteer extension:
/home/example/www/www/sites/default/files/civicrm/ext/org.civicrm.volunteer

Update:
This issue occurs in parallel with another: my CiviCRM system status page is blank. (I realized they were related when both issues disappeared simultaneously, unfortunately temporarily.)

When navigating to any of the above links (CiviVolunteer and system status) my browser console shows the following errors:


texts: Need help with export.php (CiviCRM 4.6 & Drupal 7)

texts:
I'm using an older version of CiviCRM (4.6) with Drupal 7 on Linux and until now I've not really used the command line stuff for CiviCRM, only for Drupal.

But I now need to do exports & imports of contacts etc to & from CiviCRM and so I've installed Drush & got it working. I've tried doing an export with the export.php script with Drush and can manipulate the search results to some degree. But for some reason if only exports the first 26 rows ... is the a parameter that I should be using to get the full rowcount?

Also, where is the best place to get a more detailed list of examples, list of possible parameters, usage notes etc?

Any pointers appreciated, thanks!

Neil


texts: MyISAM engine error but the DB is all InnoDB

texts:
On my install CiviCRM runs in a separate database that is entirely InnoDB, but Civi throws up the MyISAM engine error anyway.  The rest of wordpress lives in a DB that is InnoDB by default, although the tables are a mix of the two types, but I don't see why that matters. So why am I getting the MyISAM Engine error in Civi?

Versions: CiviCRM 4.7.11, wordpress 4.6.1, PHP 5.6.24, MySQL 5.0.11


texts:
I have a template with Smarty strings.

If I send the email from inside CiviCRM, Smarty works fine (it shows "Cher Guillaume"):

If I send the same template using a CiviRule, it doesn't work:

although it attaches a .pdf file with Smarty Strings inside that also work fine.

Is there a reason related to CiviRule?

Any idea?

best Regards

Guillaume


texts: Targetting CiviCRM input field labels with css

texts: I can see how to hide an input field using custom css, but I cannot figure out how to hide the specific label for that field. All the labels on the contact form seem to have the same selector. I am missing something?


texts: I am creating an activity and assigning it, but would like that to be emailed to the assignee. Is there a way automatically email the person that is assigned on an activity?


texts: Mailing job never finishes, but restarts at next cron cycle

texts:
After upgrading to 5.17.4 under Joomla, the next large CiviMail job did as follows:

It never completed and had to be cancelled
It reported zero successful deliveries, though it did report opens
At the next cron cycle it resent the same emails.
Some recipients never received emails.

An examination of the ConfigAndLog file showed 'No database selected' errors.

After upgrading to CiviCRM 5.18.2, the 'No database selected' errors went away, but the above issues remained.

CiviCRM reports that the cron job has not run, and the scheduled jobs log shows it not finishing.  The cron command is:

wget -q -t 1 'https:///administrator/components/com_civicrm/civicrm/bin/cron.php?name=&pass=&key='

We used to run php cli.php, but that stopped working after the 5.17.4 upgrade.

Has anyone any suggestions as to what might be causing the issue?  It is difficult to troubleshoot as it means potentially flooding our contacts with emails.


texts: Access CiviCRM fields from Drupal entity

texts:
I use CiviCRM 4.6.14 with Drupal 7.43.  I have defined a Drupal content type with a field that contains a CiviCRM contact using the civicrm_entity module.

When I render this content type, I want to access a few fields from the contact - namely, its name, website, and a Google map link (derived from its address or geocode or whatever's best).  In PHP, how can I access these fields from the $content object?  If I var_dump($content) I can see the name & geocode, but not a full address (should I piece that together from component fields? seems error prone) and no website field at all.

If I do this by trial and error using var_dump, I'm going to end up with code like

print($content['field_venue']['#items'][0]['entity']->display_name);

which doesn't seem healthy.


texts:
Not sure if this is best place or Github, anyway, using the 1.5alpha on CiviCRM 4.7.8 & Wordpress 4.5.3

When trying to access the Bookings - Find Bookings tab I get the following error

Fatal error: Access level to CRM_Booking_Form_Search::$_defaults must be public (as in class CRM_Core_Form) in /var/sites/h/hbb.org.uk/public_html/wp-content/plugins/files/civicrm/extensions/civibooking-1.5alpha/CRM/Booking/Form/Search.php on line 10

The rest of the alpha build seems to work great for me.


texts:
When I save the Extension Resource URL it is rewritten from:

/var/www/vhosts/examplesite/httpdocs/wp-content/plugins/files/civicrm/custom_ext

to

https://www.examplesite.com//var/www/vhosts/examplesite/httpdocs/wp-content/plugins/files/civicrm/custom_ext

It looks like it is taking the https://www.examplesite/ part from the civicrm.settings.php file:

define( 'CIVICRM_UF_BASEURL'      , 'https://www.examplesite.com/' );

I'm getting a number of errors telling me that extensions are pointing to the wrong place, so I figure I've gone astray somewhere in the settings. I see the Extension Resource should be the same as the CiviCRM Extensions Directory, which currently is:

/var/www/vhosts/examplesite.com/httpdocs/wp-content/plugins/files/civicrm/custom_ext

Where have I gone wrong? Any pointers much appreciated!

Edit:

So I changed the Resource URL to https://www.examplesite.com/wp-content/plugins/files/civicrm/custom_ext, but I still seem to get an error indicating that maybe the extensions are still not pointing to the right place?

mod_fcgid: stderr: PHP Fatal error: require_once(): Failed opening required 'CRM/Core/Session.php' (include_path='/var/www/vhosts/examplesite.com/httpdocs/wp-content/plugins/files/civicrm/custom_ext/uk.co.vedaconsulting.mailchimp-1.0-beta4/:/var/www/vhosts/examplesite.com/httpdocs/wp-content/plugins/files/civicrm/custom_ext/com.drastikbydesign.stripe/packages/:/var/www/vhosts/examplesite.com/httpdocs/wp-content/plugins/files/civicrm/custom_ext/com.drastikbydesign.stripe/:.:/var/www/vhosts/examplesite.com/httpdocs/wp-content/plugins/civicrm/civicrm:/var/www/vhosts/examplesite.com/httpdocs/wp-content/plugins/civicrm/civicrm/packages:/var/www/vhosts/examplesite.com/httpdocs/wp-content/plugins/civicrm/civicrm/vendor/phpseclib/phpseclib/phpseclib:.:/var/www/vhosts/examplesite.com/httpdocs/wp-content/plugins/civicrm/civicrm/:/var/www/vhosts/examplesite.com/httpdocs/wp-content/plugins/civicrm/civicrm//packages:.:') in /var/www/vhosts/examplesite.com/httpdocs/wp-content/plugins/files/civicrm/custom_ext/uk.co.vedaconsulting.mailchimp-1.0-beta4/mailchimp.php on line 442


texts: How can we modify the default event badge barcode?

texts:
We have a 3rd party event manager who scans bar codes, so it is great that civiCRM renders barcodes on events.

Our problem is that the 3rd party cannot process a barcode that contains a hyphen. For the event badge, we see that the barcode contains the contactID-registrationID

How can we remove the hyphen from the barcode?

We running version 4.7.16 on Joomla 3.6.5


texts: Auto-filled Drupal Webform That Creates New Contact

texts:
Is it possible to make a Drupal Webform which always creates a new contact but uses Existing Contact for prefilling?

The use-case is that the data needs to be updated but supervised by another human. So what I in effect need is for my drupal webform to create a duplicate based on the existing contact. Duplicates are then to be merged by a supervised deduplication process.

How would I go about doing this? Would it be a matter of inserting some code before the form is processed or is the entire Existing Contact framework more complicated then that? Or is there an easier way to achieve this?


texts: Adding extra information to event registration

texts:
We organise a walk with a lunch afterwards. Who registers online for the event must be able to indicate how many people will participate for the walk (number of adults and number of kids up to 12 year) and for the lunch (idem).

I do not see the possibility to add those fields to the online registration form. When i define custom fields for the event, they cannot be added to the registration form. When i add a "walk and lunch profile" to be used for these events, the first to know is the existing field of the person (such as last name...).


texts: How can I reset a user password for a PCP owner?

texts: A donor/owner of a PCP has lost her password. How can I help her?


texts: Manage Emails Sent When Changing Participant Status

texts:
When you change a participants status on the back end an email is sent.  Sometimes you may not want an email to be sent to the participant.  Is there a way to suppress these emails? Is there a setting I am missing to control when these emails are sent?

Thanks,
Steve


texts:
I am experiencing a strange issue with my CiviCRM (4.7.3) installation on Joomla (3.4.8).

If I change some of the settings in one of the administration pages, they are correctly updated on the database, but if I get back to that page I don't see the setting anymore.

It seems like values for the settings pages are not retrieved correctly from the database.

Any ideas?


texts: Disable automatic activity email to assignee

texts:
Is there a way to disable the activity summary email that is automatically sent out to the activity assignee?

Thanks


texts: Recurring contributions frequency label ("every month") is unstyleable - looks bad

texts:
If you set up a contribution page to accept recurring contributions, the label for this option on the page is "I want to contribute this amount FREQUENCY" where FREQUENCY is from the contribution page settings (e.g. every month). The "I want to contribute this amount" part is inside a label tag, while the "every month" is just plain text on the page, not inside any tags, so if a theme changes the label font, this looks terrible. There is also an extra space before "every month" so it looks like this "I want to contribute this amount  every month".

Anyone know how to deal with this? The div that this text is all inside has class "content" which is used in other places, so not a great way to deal with this.


texts:
Writing as a self-answered question since it may help others...

I am adding smarty code to a mail template. Including:

{capture assign=designation}{contribution.contribution_source}{/capture}

Later in the page, I call the variable as such:

{if $designation}, for {contribution.contribution_source}{/if}

But the template breaks when I try to use it. The code looks good as far as I can tell. What's the problem?


texts: Mailing issue. Could not identify any recipients. Perhaps the group is empty?

texts:
I am experiencing a weird issue on my CiviCRM 4.7.3 on Joomla 3.5.0 (also happening on some 4.7.8 on Drupal 7)

When I try to send or schedule a mailing and I hit "Send test" I receive an error saying Could not identify any recipients. Perhaps the group is empty?. However I have selected a group with valid recipients inside (I can see the yellow text near the recipients field saying "~81 recipients").

If I ignore the test and try to send the mailing, it does not give me any errors, but no emails are sent and if I check the report it says:

Intended Recipients     1
Successful Deliveries   0 (0.00%)

The Mail module works - I can send mail through CiviCRM to a contact directly, only through CiviMail there is a problem.

Further debugging information

After a lot of debugging I can narrow the problem down to an ACL issue:

In CRM/Mailing/BAO/MailingJob.php the deliver() function is reached but the query ($eq->query, $eq->fetch) doesn't return any results.

This is due to the condition from $aclWhere, for me it is:

( ( `civicrm_group_contact_cache-ACL`.group_id IN (8) ) )

which is joined in the full query by

LEFT JOIN civicrm_group_contact_cache `civicrm_group_contact_cache-ACL` ON contact_a.id = `civicrm_group_contact_cache-ACL`.contact_id

while I do get a contact joined in the query, an entry in civicrm_group_contact_cache seems to be missing. What is that table for, anyway?


texts:
Basicly what it says in the title. How do I add custom fonts within mosaico templates, i.e. how do I make them selectable in the template design process?

There is the answer to my question on github and it goes like this:

  In the header of the template (the mso comments are there because
  Outlook is able to read webfonts declaration but then "breaks" any
  declared font):

<!--[if !mso]><!-- -->
<link href="https://fonts.googleapis.com/css?family=Your+Web+Font" rel="stylesheet" type="text/css" />
<!--<![endif]-->

  In the @supports -ko-blockdefs section of your template you add your
  font to the select box:

  face { label: Font; widget: select; options: Your Web Font, Fallback, serif=Your Web Font|Arial, Helvetica, sans-serif=Arial|Arial

  Black, Arial Black, Gadget, sans-serif=Arial Black|Comic Sans MS,
  Comic Sans MS5, cursive=Comic Sans|Courier New, Courier New,
  monospace=Courier|Georgia, serif=Georgia|Impact,
  sans-serif=Impact|Lucida Console, Monaco, monospace=Lucida
  Console|Lucida Sans Unicode, Lucida Grande, sans-serif=Lucida Sans
  Unicode|Times New Roman, Times, serif=Times New Roman|Verdana, Geneva,
  sans-serif=Verdana}

However this doesn't work for me. When I add this to versafix-1 (mosaico/templates/versafix-1/template-versafix-1.html) I still don't have the font I specified.

Here's the begining of versafix-1 template I eddited

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
  <meta name="viewport" content="initial-scale=1.0" />
  <meta name="format-detection" content="telephone=no" />
  <title style="-ko-bind-text: @titleText">TITLE</title>
  <!--[if !mso]><!-- -->
  <link href="https://fonts.googleapis.com/css?family=Open+Sans" rel="stylesheet" type="text/css" />
  <!--<![endif]-->
  <style type="text/css">
    @supports -ko-blockdefs {
      id { widget: id }
      size { label: Size; widget: select; options: 8|9|10|11|12|13|14|15|16|18|20|22|25|28|31; }
      visible { label: Visible?; widget: boolean }
      color { label: Color; widget: color }
      radius {
        label: Corner Radius;
        widget: integer;
        max: 20;
        help: Attention - this property is not supported on all email clients (i.e. Outlook)
      face { label: Font; widget: select; options: Open Sans, Arial, serif=Open Sans|Arial, Helvetica, sans-serif=Arial|Arial Black, Arial Black, Gadget, sans-serif=Ari$
      }


texts: I want to send a new event listing to all our members who have ticked a requesting information from us. At the moment when I choose the new mailing list option it's just a blank screen


texts: View contact file while entering contribution batch?

texts:
Is it possible to view/open in a new window a contact's profile while entering a contribution batch?

I know that a contact's email address will appear in the dropdown with the contact's name. However, it's tricky to choose between two contacts with identical names (e.g., Joe Smith and Joe Smith) because (a) not all our contacts have email addresses and (b) over time there has been incomplete data entry for one reason or another.


texts: Upgrade from 4.2.7 to 4.7.13 fails during DB 4.4alpha1 update Joomla

texts:
The upgrade process keeps failing, I even tried doing upgrades version after version but always when getting to 4.4 it fails when we get the 4.4 alpha1 update, the error that shows is:

[Error: Consolidate activity contacts]
Error Field Error Value
Type    DB_Error
Code    -2
Message DB Error: syntax error
Mode    16
UserInfo    UPDATE civicrm_option_value SET is_reserved = 1 WHERE option_group_id = 62 AND value IN (2, , 3) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 3)' at line 3]
DebugInfo   UPDATE civicrm_option_value SET is_reserved = 1 WHERE option_group_id = 62 AND value IN (2, , 3) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 3)' at line 3]
PEAR_Exception: DB Error: syntax error in unknown on line unknown
- DB_Error: DB Error: syntax error in unknown on line unknown

I keep looking for the error but can't find it, does anyone knows a better way to verify it? Or if you know what error is on this table? (I only left the main columns and deleted the rest)

https://dl.dropboxusercontent.com/u/92433965/civicrm_option_value.csv

Server 1
PHP:5.6.8
MySQL:5.6.24

Server 2
PHP:5.6.28-0+deb8u1
MySQL:5.5.53-0+deb8u1