texts:
When manually adding a contribution - I get the following error:

Warning: A non-numeric value encountered in CRM_Contribute_BAO_Contribution::calculateMissingAmountParams() (line 383 of /home/sitename/www/www/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php).

Line 383 is:
$params['net_amount'] = $params['total_amount'] - $params['fee_amount'];

The contribution is processed without issue - but that error persists. When I add fee amount as 0 - the error does not display. Do we always have to provide a fee amount for manual contribution entries?


texts: We have a school that is a contact organization and it has now closed how can I mark it as inactive/closed?


texts: Why am I receiving "This page isn't working HTTP ERROR 500" after installing CiviRules?

texts: I am interested in using CiviRules to automate some processes within CiviCRM.  I am using CiviCRM 4.6.6 and installed CiviRules 2.4.  When I went to add a rule clicking Next from the first CiviRules Add Rule page I am directed to a page displaying "This page isn't working  mysite is currently unable to handle this request.  HTTP ERROR 500".  I receive the same error page when I attempt to "cleanup the cache" and any other process I have tested.  Everything returns to normal after I uninstall CiviRules.  Anyone know how I can fix this?  All help is appreciated.


texts: Mailchimp Integration pushing but not pulling

texts:
I have the "Mailchimp & CiviCRM" integration (v2.0) installed, and have created a Smart Group containing current mailable members which I've linked with a test MailChimp group.  I've activated the Push job, but not the Pull job, as from what I understand I want CiviCRM to be the source of truth and push to MailChimp.  The push seems to work, but the description of the module here: https://vedaconsulting.co.uk/civicrm-mailchimp seems to indicate that it will also pull back to CiviCRM when a user or admin unsubscribes.

This has not been the case in my testing -- when I unsubscribe my own user through the admin screen on MC, the Smart Group never gets updated.  On the next scheduled push, the user shows up in MC as Subscribed again.  I've double checked the Webhook settings, and they are set as shown in the above link.  What am I doing wrong -- am I misunderstanding the push/pull, and I need to activate both jobs?  Will this work correctly, so that individual unsubscribes are pulled from MC immediately, but everything else comes from Civi?


texts: Notification for failed payment transaction

texts:
is there a way to get a notification of some kind for when a recurring payment hasn't gone through? Maybe with membership rules?
We've had it a couple of times now that payments haven't gone through for insufficient funds for example and we only find out about it by chance a few days later.

Thanks again for the help


texts: Including discount codes in membership imports

texts:
We offer a discounted membership to graduates of affiliated training programmes - to minimise the processing work, the course administrator fills out a template spreadsheet and sends it to us, and deposits the fees in bulk.
We tidy the file, save it as csv then run a contacts import followed by a member import.

Although we initially used a separate membership type with a lower fee, the problem of having to manually change membership type after one year led us to switch to applying standard individual memberships and creating a discount code.

However, I can't find discount code anywhere in the field matching for either membership or contributions imports.
How can I apply the discount so that contribution records do not show the full price?


texts: Advanced Search not affected by Date Preferences

texts:
Using 5.24.4 I have changed the date ranges at civicrm/admin/setting/preferences/date?action=reset=1 to 20 or 30 but Advanced Search is still showing Activities, Memberships and Events, etc. as 10 years prior and 10 years future.  I have clearned cache civicrm/menu/rebuild?reset=1 to no effect.

Any ideas where these settings are changed now?


texts: Membership Renewal Reminders not Sending for Upgraded Memberships

texts:
So we have a situation where someone had Membership A in 2016, and Bought Membership B in 2018 so the Membership type upgraded.

Member Since: March 9th, 2016
Start Date: February 26th, 2018
End Date: February 25th, 2022 (they bought 4 terms)

We then have a scheduled reminder that is supposed to send 1 day after the Membership Join Date.

What we are observing, is anyone who had a prior membership or an older "Member Since" date is not receiving the email the next day, whereas the completely new Members who are starting their first membership are.

How do we resolve this? Perhaps I midjudged what "Membership Join Date" meant in scheduled reminders?

CiviCRM 4.7.30 / Drupal 7


texts: CiviDiscount - applying sales tax on discounted price rather than original price

texts:
I found this in the CiviCRM issue tracker - https://issues.civicrm.org/jira/browse/CRM-16861

This is a pretty major bug for us - Has anyone resolved this issue on their own?

Essentially, when a discount code is applied, tax is applied to the original amount rather than the discounted amount.


texts: Template customization don't appear on validation errors, query string?

texts: I am looking some code for a customization of a specific contribution page on CiviCRM 4.4 system. An extension is implemented that runs hook_buildForm() which operates on the form based on the ID. The overall layout has several templates customized to the contribution id.  The problem I am seeing is that if there are validation errors on the page, the form redirects to /civicrm/contribute/transact   with no ID in the query string. In this templates don't get rendered, though hook_buildForm() does receive the ID correctly and run it's customization.  I am new this platform and not informed on the request handling and routing. I would like to know if there is something easy to change that would cause the ID to be sent with the query string when there are validation errors or otherwise cause custom templates to be run.


texts: How to remove transfer or cancel message from event confirmation emails.

texts:
We are using Civi 4.7.22 on Wordpress 4.8.22

I just realized that the below message goes out in all event confirmation emails whether or not the box in the event configurations is checked.   I would really like to remove this message.  Can someone tell me where to do that?

You may transfer your registration to another participant or cancel your registration up to 96 hours before the event. Cancellations are not refundable.
Click here to transfer or cancel your registration.

Thank you.


texts: I have found that the best way to deal with pull requests that have failed validation due to coding standard error is to close the PR, delete the remote branch in Git and create a new one with the corrected code pushed to it.  This is, of course, a bit fiddly and one would rather get the standards right first time. Is this the correct approach?  Simply pushing a new commit causes grief in that the local and remote branches are out of sync.


texts:
What PHP version would you recommend for running CiviCRM version 4.6.8?

I was using an old version of PHP (4.3.3), but that is no longer sufficient to run CiviCRM and 5.4+ is recommended in the documentation. Would it be wise to upgrade to the latest version 5.6.13 or might I be safer with something like 5.5.29?


texts: API CSV Import -> for ActivityContact -> invalid value for record_type_id

texts: Using API CSV import to try add entries to the civicrm_activity_contact table -> running out of ideas as to what I need to use for record_type_id (see screenshot) - any other ideas are welcome! Trying to get a GUI solution for a client.


texts: Why settings.default.json file is neglected during install?

texts:
Since CiviCRM 5.23, one can set a custom L10n/I18n resource directory. Using this feature with Aegir and Drupal 7 profiles, this setting almost works: CiviCRM sites install with selected language, using the Drupal and CiviCRM language files (.po/.mo) located now at profiles/myprofile/translations/.

Missing piece is that the settings.default.json file of CiviCRM l10n settings is not picked up during install, so its settings are neglected. The file is at civicrm/l10n/hu_HU, next to the .po files.

Is it a bug or am I missing something in my Aegir settings?


texts: Strange 'Permission Denied' message when browsing to CiviCRM home page

texts:
On a site I've been working on for several years, when I log in to the site, I find that when I browse to the CiviCRM home page /civicrm?reset=1 I get a weird message: "Permission Denied: You do not have permission to view this contact record. Contact the site administrator if you need assistance."

If I simply ignore it and carry on then all seems fine. In the error log I see the following lines:

[Tue Jan 26 10:46:17 2016] [error] [client 81.95.52.80] client denied by server configuration: /home/mysite/sites/default/sites/default/files/civicrm/ConfigAndLog/CiviCRM.b94a921de7121c494a80645638b20a34.log
[Tue Jan 26 10:46:17 2016] [error] [client 81.95.52.80] client denied by server configuration: /home/mysite/sites/default/sites/default/files/civicrm/upload/delete-this-VJYWu2ovE4
[Tue Jan 26 10:46:17 2016] [error] [client 81.95.52.80] client denied by server configuration: /home/mysite/sites/default/sites/default/files/civicrm/custom/delete-this-uYgWNHRSxL
[Tue Jan 26 10:46:17 2016] [error] [client 81.95.52.80] Attempt to serve directory: /home/mysite/sites/default/sites/default/files/civicrm/persist/contribute/

The files mentioned in the second and third lines above don't exist.

If anyone has any advice about how to tackle this I'd be grateful.

EDIT: CRM-18300: "Permission denied" message re contact on CiviCRM dashboard


texts: Mass hosting best practices for source code management of CiviCRM platforms?

texts:
I manage CiviCRM installations on various servers (typically 1 client = 1 VPS). This usually includes roughly the same Drupal core and contrib modules, CiviCRM core and extensions, and translation files. While each client has their own specifics, I try to standardize as much as possible.

I was wondering what tools are recommended to 'build' the platform for production environments? Is buildkit recommended? If yes, any examples on how to use it with custom platforms? (my set of drupal modules + civicrm extensions)

I have been using "drush make" until now, but I find myself fighting with it more often that I should. For example, it cannot download "civicrm.mo" files (because it does not recognize the mime type). It also does not run composer automatically on projects, and I find it useful to use composer in extensions, to avoid bundling third-party libraries in my git repo. Custom build scripts become clunky shell scripts that re-invent the wheel.

Ideally, I would also like to manage the source code of CiviCRM itself in git, which means running composer/npm install on the code base. This makes it easier to backport patches when necessary, track local changes, and have the same tool chain in dev and prod.

Would composer be a good option for that? For example, I stumbled upon Using Composer to build your Drupal 7 projects, which uses PHP packagist.


texts: MySQL Error 1064 when trying to upgrade from 4.7.8. to 4.7.9

texts:
I am using MySQL Workbench on MacOSX and there are four SQL statements in the 4.7.9 upgrade script which give a 1064 error. The first of the statements in error is shown below. MySQL Workbench has the error underline on the first { character.

UPDATE civicrm_option_value SET
  {localize field="label"}label = '{ts escape="sql"}Print/Merge Document{/ts}'{/localize},
  {localize field="description"}description = '{ts escape="sql"}Export letters and other printable documents.{/ts}'{/localize}
  WHERE name = 'Print PDF Letter' AND option_group_id = @option_group_id_act;


texts: Is there a mistake in the Upgrading CivCRM for WordPress instructions?

texts:
I was following the instructions to upgrade to 4.7.14 here:
https://wiki.civicrm.org/confluence/display/CRMDOC/Upgrading+CiviCRM+for+Wordpress
It clearly says to extract the zip file in  /wp-content/plugins/. It then says to clear caches and point to the upgrade url.
This leads to:
Your database has already been upgraded to CiviCRM 4.7.13.
The extract left things in a directory called: civicrm-4.7.14-wordpress. This implied to me that the upgrade will move things from there to the civicrm directory, but reading things here and elsewhere I suspect that files need to be extracted (or moved) to the civicrm directory.  There are no instructions to do that. Should I remove the civicrm/ tree and move civicrm-4.7.14-wordpress/civicrm to plugins/?


texts: Installer says cannot create triggers but I can with phpMyAdmin

texts:
Any suggestions how to get the civicrm installer to recognize that I have permission to create triggers. The installer says I don't, but my host says I do.
I can create triggers with phpMyAdmin.
I am using MySQL - it is a new site, but I don't know the version number.
I have asked. Will enter it when I know.

Here I am substituting the word username for my real username.
I logged into WordPress with user: username, and
logged into phpMyAdmin with user: username
I ran the query you suggested and got:
Your SQL query has been executed successfully.
SHOW GRANTS FOR 'username'@'localhost' GRANT USAGE ON . TO 'username'@'localhost' IDENTIFIED...
GRANT ALL PRIVILEGES ON username_site.* TO 'username'@'loc...
GRANT ALL PRIVILEGES ON username_civi.* TO 'username'@'loc...


texts: 404 on link to edit contact with contact hash

texts:
I'm testing the ability to send emails out with a link for each contact to edit their own information anonymously, using the contact hash token as described in Linking Profiles.

I am able to access the profile anonymously, but when I click on the link provided in the email:
as with tokens: http://[site]/civicrm/profile/edit?reset=1&gid=36&id={contact.contact_id}&{contact.checksum}
in sent email: http://[site]/civicrm/profile/edit?reset=1&gid=36&id=[CID#]&cs=[checksum#]
I get a 404 error.

I've confirmed the URL based on the wiki documentation.
I've tried updating Joomla permissions (Public users are allowed access to profile listing and forms, profile create, profile edit, and profile view).
I've confirmed that my profile does not use any non-contact fields.

What should I check next?

Joomla 3.6, Civi 4.7.12


texts: Are contents of ConfigAndLog directory safe to delete?

texts:
I am looking at our CiviCRM install on disk and I notice that  files/civicrm/ConfigAndLog is taking up nearly 9GB with all files from 2014-2015.

Looking at them they are just plain text files which sort of look like query results.  Most are in the format CiviCRM.<32character_string>.log.YYYYMMDDhhmm  some are just CiviCRM.<32character_string>.log

Is it safe to rm these files or do they serve a purpose?


texts:
I would like to know if CiviCRM is the right choice to manage contacts and entrances of a climbing Gym.
At present we manage subscrition manually with forms, and sell single entrance tickets and multiple prepaid entrance cards.
I would like to store the contacts subscribed with expiry date, track every entrance and manage the balance of the 12 entrance pre paid card.
Is this possible using native CiviCRM or extensions ?

Thank you very much !


texts: Want to auto populate city and state from an entered U.S. zip code, WordPress

texts:
I am a complete newbie to CiviCRM and hoping to use this platform with WordPress to replace an antiquated CRM (even has comments for displaying properly on netscape). One of the desired features is to auto populate the city and state when a user enters a U.S. zip code.

I see something similar here. https://civicrm.org/extensions/civicrm-region-lookup. However, it doesn't look like it is being maintained for recent versions of CiviCRM. Is this a red flag? Also noted that this is for Drupal and I would need a WordPress version.

I did manage to find Administer > System Settings > Extensions but I don't see anything there similar to what I need.

I also see that USPS has Web Tools API with this functionality but wouldn't know how to implement that for CiviCRM within Wordpress. https://www.usps.com/business/web-tools-apis/address-information-api.htm#_Toc410982991

All ideas, suggestions and help would be very welcome.

Thanks so much in advance!

D


texts: Joomla loadmodule or loadposition inside CiviCRM

texts:
please how can I use {loadmodule xxx} or {loadposition xxx} inside:
- an event description
- a profile intro field

Thank you


texts: Search for Transaction ID of CiviEvent Sub-Contribution

texts:
Sometimes we'll have someone pay X amount via credit card (Paypal Pro) and register online for an event. Then, they'll call us, and we'll add additional options to the event (via Change Selections), and then run a credit card transaction against the main balance. This works fine.

However, we are having issue searching for the second transactions ID via standard civi searches. Any suggestions? Our accountant uses this for reconciliation.

Similar: Finding payments in contributions

Bug (no updates in awhile): https://issues.civicrm.org/jira/browse/CRM-17808

CiviCRM 5.5 Drupal 7.x

Possible Solution:

https://civicrm.org/extensions/extended-reports

The Extended BookKeeping Report allows for searching by Transaction # civicrm/report/contribution/bookkeeping_extended


texts: Is it possible to apply an existing contribution to an event registration?

texts:
My client runs camps which require a minimum $50 deposit. Campers send one or more additional payments until their registration is paid in full. Since CiviEvent doesn't support self-service for partial payments, we're considering not charging on the event registration page (set Pay Later and hide it), then redirecting the registrant to a contribution page after confirmation. A back office user will then apply that contribution to the pending registration.

I've tried editing registrations and contributions, but can't find a way to link them up after the fact from either direction.


texts: Upgrading from 4.6.4 to 4.6.6 returns following error, how to go pass it?

texts: Although I have followed all the steps listed in the upgrade tutorial, this is the message comes up in the beginning of the upgrading process. I have tried on my demo & production site, both have same error. how to fix this please?


texts:
I updated from 4.6.10 to 4.7.12 and it failed at updating 4.7 beta 3 DB, now I cannot load the admin screen at all.  This is the wordpress version. All I get now is:  Sorry but we are not able to provide this at the moment.
DB Constraint Violation - possibly dashboard_id should possibly be marked as mandatory for this API. If so, please raise a bug report.
Return to home page.

Any ideas on how to resolve this?


texts: All My activities show for other person name

texts: I registered someone in CiviCRM and now after doing some activities I saw all my activities for her name and I think both of us link together how can I unlink without losing any information?


texts: create civi case using standalone script

texts:
creating using standalone php script,

http://prntscr.com/n281zd

get bellow error

http://prntscr.com/n28279

Using cv cli, have same error too

  cv api Case.create case_type_id="housing_support" subject="new housing
  object" contact_id=3

but when I pass in the CMS user I have no error and I can create the case with out any problem

  cv api Case.create case_type_id="housing_support" subject="new housing
  object" contact_id=3 --user=admin

So the question is how to do the equivalent of --user=admin when using a php standalone script for joomla (https://docs.civicrm.org/dev/en/latest/framework/bootstrap/#joomla).

Any body ever have this issues  and solve ?


texts: How to fix 'New mailing' that only has 'Initializing' and edit boxes that wait forever

texts:
One of my Civi installs has a problem where clicking 'New mailing' has 'Initializing' but nothing more, and edit boxes on the summary screen have a continuously circling triangle if an item is edited. I've been through this forum help and looking at the browser console I can see 'HTTP/1.1 500 Internal Server Error 54ms'.
I have removed extensions, and upgraded to the latest 4.6.27 CiviCRM release but no change. I really don't know what to do next, so very grateful for any help. CMS is Drupal 7.52 and PHP 5.6
(Added) The full message in the above browser console is:
'https://www.myapp.com/civicrm/ajax/angular-modules  HTTP/1.1 500 Internal Server Error 34ms'


texts:
I only have 12 items per volunteer project so I was hoping to hide the Search as it's pointless. I looks like there's code to control that but I can't find a way to turn it on or it's not functioning properly.

Kind regards,


texts: creating summary token for same donor but different categories

texts:
I'd like to send out to our donors a summary of all their contributions in the past year.

I am using a token that summarizes the total donation amount for the past year. The issue is we have different Types of donations and don't want them all summed up together. So the question is
1. is there a way to get the sum only for specific transactions which i choose from the find contributions list
and if not
2. is there a way to save the tokens for different transaction types as different tokens and if so how?
Thanks alot!


texts:
Civi 5.9.1. WordPress 5.0.3

I built a profile for my organization's staff to use when adding an Individual with a specific subtype ("Farmer"). I created a New Farmer menu item under Contacts>New Individual in the nav bar, and linked it to the Farmer profile's URL. I used the Contact Summary Layout extension to show only the fields from that profile when viewing details for an Individual of subtype Farmer. But when a user clicks the Edit button from there, the default Individual contact template appears, instead of my custom Farmer profile.

Is there any way to change this, so that editing an existing Individual of a certain subtype launches the profile created for that subtype? (I framed the question generally because we'll eventually have a few more subtypes with their own profiles that also will differ substantially from the default and from each other. But for now I'm setting aside the question of whether and how an Individual's subtype can change over time.)

While I have no coding experience outside of SQL (at which I'm fairly expert), I'm open to suggestions that go beyond the CiviCRM UI.

Many thanks!

EDIT: I'd also be keen to learn if there's a way to hide or disable the Edit button on the Contact Summary page, even if it can't be done based on subtype. Users would still have recourse to the pencil icons on that page, which should work fine given that it matches the custom profile.


texts:
Use case: we’d like anonymous (or, if necessary, authenticated) users to be able to create provisional bookings, but not to edit anyone else’s.
In the Drupal access control, “create and update” is a single permission, and it appears to be for all bookings, not just those created by a user.  Correct?
ACL would seem to be able to address this, but it’s not clear how/whether ACL has control over CiviBooking data. Anyone have insight?
Any suggestions, either for how to configure things or (if need be) how to explore modifying the code?
We’re using Drupal 6, CiviCRM 1.4.6, and CiviBooking 1.5
Thanks!


texts:
I recently discovered that our payment processor does in fact accept a credit cared type that wasn't enabled before. I went to Administer > CiviContribute > Accepted Credit Cards and enabled the card (Discover). Then I cleared caches and CiviCRM caches but the credit card button isn't showing up. We are using Authorize.net.

In the screenshot below, you can see that it still only lists Visa, MasterCard, and American Express.

CiviCRM 5.0.0

Update: Strangely, on my test site, it works just fine on 5.1.2 so when I upgrade production tonight, the issue might just go away.


texts: Can numeric version naming conventions for CiviCRM extensions use the Drupal module naming conventions?

texts:
I like the numeric naming conventions for Drupal modules - Drupal version number then module version number. For Drupal version 6 modules, it follows something like  6.x-2.1, for example. For Drupal version 7, something like 7.x-1.1, for example.

For CiviCRM, naming conventions for extensions could be 4.4-1.0 and 4.7-1.0, for example.

I think this would be really helpful for clarifying which extensions (should) work with which Civi versions.

The current system is a little vague, and it's sometimes unclear which extensions should work with which Civi version.

Also, extension version update info does not always get updated on the Civi website extensions page, but is sometimes buried in a GitHub repo issue discussion, or in a blog post elsewhere on the CiviCRM website, or issues.civicrm.org, or another website entirely.

Thoughts?


texts: End-user fillout form dropdown instead of checkbox for Group(s)

texts:
Using Civicrm version 4.6.11, WordPress 4.4.2
I've created a fill out form that allows our site visitors to sign up for an email newsletter. One of the required fields is the Group (core) field (using the predefined Goup(s) from backend Profile set up. The selection option defaults to check boxes allowing users to choose more than one group. We need them to be able to select one and only one group membership. The group field is one of the core fields rather than a custom field. Is there a way to either change the check boxes to select or radio or is there a way to use a custom field that will populate the core field of Group(s)? We need the user selection to apply to the primary group(s) that we have set up in the civicrm backend that we then use for specific email lists.
Thanks!


texts: Solved - Wrong base URL for Civi include files (Wordpress)

texts:
Civi version: civicrm-4.7.14-wordpress |
Wordpress version: 4.7

Hi,

I have run into a problem with a Civi/WordPress install. The content of the dashboard is not loading and the Civi menu not showing. The site is installed in a directory and the urls for 34 Civi include files have that directory duplicated. This is a new install. The only concern during the install was that the server is running PHP 5.4, otherwise it went fine.

  Example URL:
  domainName/dir/dir/wp-content/plugins/civicrm/civicrm/css/crm-i.css?r=YR5cm

I am still relatively new to Civi and I am having trouble sorting out where to correct the duplication. Any recommendations would be very appreciated.

Thanks!

ADD. 1: If it's of any help, I've confirmed there are no Javascript errors (probably because none of the Civi includes are loading), Wordpress itself is running fine, there are no other plugins installed, and the theme is Twenty Seventeen.

ADD. 2:  I confirmed with the host that everything is okay on their end.

I removed the directory from civicrm.settings.php, line 211

  define( 'CIVICRM_UF_BASEURL'      , 'domainURL/dummy');

Now the dashboard at least tries to load, but generates the error "Network Error, Unable to reach the server". The 404 errors are gone now. There is still no Civi Admin menu but I am at least able to access the Administer CiviCRM page and its links now. Unfortunately, it also means I have to manually add the directory back into URLs that didn't have the duplication to start with, like the "System Status" link at the bottom of the dashboard.

ADD. 3: I tried installing CiviCRM Utilities plugin as suggested on "Word Press Install Missing civicrm.settings.php; dashboard unavailable; no menus" (I don't have enough points to post more than one link)

It didn't resolve the problem but I now have the following appearing on Civi dashboard. That's progress of a sort... I guess.

Now I'm looking at resolving these issues. Sigh.
I'm willing to entertain even the smallest shot in the dark for the original problem at this point.


texts: Rest API contribution get doesn't return display_name

texts:
in my Civicrm 5.31 on Wordpress 5.5 I'm trying to retrieve contribution data via Rest API, using the apiExplorer I get the code:
wp-content/plugins/civicrm/civicrm/extern/rest.php?entity=Contribution&action=get&api_key=userkey&key=sitekey&json={"sequential":1,"return":"contact_id,contribution_source,total_amount,fee_amount,trxn_id,invoice_number","receive_date":{">":"01/01/2021"}}

but if I try to add the display_name it doesn't work. I try: contact_id.display_name and display_name


texts: How do I set the display size for custom fields?

texts:
I have a profile that combines built-in fields with custom fields, both alphanumeric. The custom field displays shorter than the built-in fields which, when I examine the page source, are size="30".

How can I set the display size of the custom field to match that of the built-in fields? I can't find a setting for it in the custom field edit area.

Thanks.


texts: How to setup more complex membership prices

texts:
I am implementing CiviCRM in Joomla for a sporting organization. The way they work is they charge an annual membership for each of their affiliated clubs (e.g. 100$). The clubs also need to pay a certain amount for each of their members (e.g. 5$ per member). So the final membership cost of a club that has 10 members would be 150$ (100$ + (10 x 5$)). I have set up the contacts so that each club member individual is related to the club organization as a "is a member of" relationship. I have created a "club" membership at 100$ and a "club member" membership at 5$.

My question is: Is there a way of programming the membership renewal price set to automatically fetch the number of related contacts and incorporate it into the club's bill?

Thanks for any insight into this matter.

P.S.
I started with defining the club members with a "club member" membership but this created the problem that the individuals were indicated as owing 5$ in their profile and I still could not figure out how to have the number of related members in the club's bill.


texts: Upgrade Wordpress CiviCRM Version from 4.5.2 to 4.6.5

texts:
I have a good installation of CiviCRM on Wordpress, but now i want to upgrade to version 4.6.5 and when ik upgrade, the upgrade stops at 4.6.alpha7

I am trying for 4 hours to get an solution So i have tried to export the structure and data end make a new database  with the original structure imports. But nothing will work..

EDIT:
I have checked all the tables with a compare program,
Left= Current version 4.5.2 / working civicrm (Backup / before Upgrade)
Right= Original civicrm.mysql version 4.5.2

RESULT:
Only tables civicrm_value_**** are not in the right (original) version.

EDIT 2:
I can upgrade to version 4.5.8 without problems. If i want to upgrade then to 4.6.6 It will also stop at 4.6.alpha7 (error below)

I have also checked if there is a table civicrm_mailing_abtest but this table does not exist.

I hope someone can help me to solve this problem.

Thanks a lot. It is a fantastic plugin!! ( CiviCRM )

With kind regards,

Mark

This is the error:

[Error: Upgrade DB to 4.6.alpha7]
Fout Veld   fout waarde
Type    DB_Error
Code    -1
Message DB Error: unknown error
Mode    16
UserInfo    ALTER TABLE civicrm_mailing_abtest ADD COLUMN `created_id` int unsigned COMMENT 'FK to Contact ID', ADD COLUMN `created_date` datetime COMMENT 'When was this item created', ADD COLUMN `testing_criteria` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, ADD COLUMN `winner_criteria` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, ADD CONSTRAINT FK_civicrm_mailing_abtest_created_id FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact`(`id`) ON DELETE SET NULL [nativecode=1215 ** Cannot add foreign key constraint]
DebugInfo   ALTER TABLE civicrm_mailing_abtest ADD COLUMN `created_id` int unsigned COMMENT 'FK to Contact ID', ADD COLUMN `created_date` datetime COMMENT 'When was this item created', ADD COLUMN `testing_criteria` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, ADD COLUMN `winner_criteria` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, ADD CONSTRAINT FK_civicrm_mailing_abtest_created_id FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact`(`id`) ON DELETE SET NULL [nativecode=1215 ** Cannot add foreign key constraint]
PEAR_Exception: DB Error: unknown error in unknown on line unknown
- DB_Error: DB Error: unknown error in unknown on line unknown
Exception trace


texts: Priceset fields do not appear on CiviEvent form (field notes do) | Backdrop

texts:
Apologies if I am missing something fundamental here - I'm pretty sure I am, but just can't work it out:
I have an event registration form for public. As admin user logged in, form appears fine. As public (no user login/private window) profile fields appear OK. However, priceset fields only show the field notes; field label, input field and price field do not appear.

Details of event form:
- Additional delegate registration in addition to self enabled;
- Simple profile with personal contact information and employer field from Organization
- Relatively detailed Priceset with field notes - all fields enabled for public
- usual Drupal/Backdrop civi permissions enabled for public event forms (profile create, custom data, register for events, view event info, view event participants)
- No payment processor (pay later only - invoices enabled).

CiviCRM 5.17.4
Backdrop 1.14
tested in Firefox and Chrome - same issue.
environment: shared hosting (WebhostUK - Linux Business Cloud Webhosting)

Edit: adding screenshot


texts: How do I filter out memberships (by relationship)?

texts:
I have a report that generates a list of members who need to be called to renew, however I want to remove from the report all those with a Membership Type: Annual Member (by relationship). Any suggestions? Thanks!

Civi 5.3.1 on Drupal


texts: We often have batches of six to eight related cases which have much of the same content (relationships, custom fields, activities). I would like to generate new cases by cloning an existing case multiple times. Before I embark on writing a new extension, has anyone already done something like this?


texts: Error when accessing Activities for contact (after upgrade to 4.7.2)

texts:
When a management user tries to open Activities tab for a contact he gets error message

Error that I see when I try to trace it:

API permission check failed for Case/getcount call; insufficient permission: require Array

That affects users with particular role (works fine for administrator) and appeared after upgrade to 4.7.2


texts:
When I try to upgrade CIVICRM 4.4.19 to 4.4.2 I get the following error message:
"Your database is marked with an unexpected version number: 4.4.19. The v4.4.2 codebase may not be compatible with your database state."

The site is operating fine in 4.4.19, but I am running into an error I've seen mentioned here with waitlists not working properly on paid events - it's not, and I understand an upgrade is the solution. Any suggestions would be appreciated. This is, BTW, the Drupal version.

Thanks!


texts: Email was sending fine and now has stopped

texts:
Using CiviCRM 4.7.14 on WordPress 4.7.3. The configuration uses the default CiviCRM mail() mailer with a WordPress Gmail SMTP plugin.

Everything worked fine until about a week ago, but no configurations were changed. The Gmail SMTP Plugin sends mail successfully, but Civi does not.
Any help on where to look would be greatly appreciated.

The error is:

Oops. Your MAIL settings are incorrect. No test mail has been sent.
An error occurred when CiviCRM attempted to send an email (via SMTP). If you received this error after submitting on online contribution or event registration - the transaction was completed, but we were unable to send the email receipt.
The mail library returned the following error message:
mail() returned failure
This is probably related to a problem in your Outbound Email Settings (Administer CiviCRM » System Settings » Outbound Email), OR the FROM email address specifically configured for your contribution page or event. Possible causes are:
Your Sendmail path is incorrect.
Your Sendmail argument is incorrect.
The FROM Email Address configured for this feature may not be a valid sender based on your email service provider rules.


texts: report mailing date and time have expired

texts:
I can not send the mailing, in the report this message:  "Delivery has not yet begun for this mailing. If the scheduled delivery date and time is past, ask the system administrator or technical support contact for your site to verify that the automated mailer task ('cron job') is running - and how frequently." what am I doing wrong? What should I correct? Thank you
And if the problem is geolocation? And if the problem was the google API?
I also had difficulty understanding OpenStreetMaps, maybe I was wrong with them?
Is anyone practical with OpenStreetmap? Thanks
In setting mapping I put this indicated in the screenshot:


texts: How do I setup a webform so that an existing activity in a case is updated?

texts:
Here's the scenario:

A user submits a webform that creates a case.

An administrator assigns a role in that case to a second user, and edits a specific activity (activity ID = xxx) in that case to assign that activity to the same user named for the role.

A Drupal View is used to present to that second user a link to a different webform. The link is of the form http://example.org/path/to/form?aid=xxx
My understanding is that because I have appended the activity ID to the url the form submission will update the activity with that ID.

However, when I submit the form a new activity gets created and the activity with ID = xxx is not updated or affected in any way.
It doesn't seem to matter which options I set for the activity within the webform.
Where am I going wrong?

As a supplementary, I've noticed that for the activity that does get created (with ID = yyy), if I file that activity on the case where it should be, then the filed activity has a different ID (yyy+1), which is concerning. Surely an activity should retain the same ID number regardless of its status?


texts:
Is it possible in CiviCRM to change extension of cached php files from .php to something else (e.g. .php_ or .txt)? Our host (WPEngine) does not allow guest users to write to php files on production environment.

We run cron by calling the cron URL from another server using curl, but scheduled reminder emails fail because CiviCRM can't write .php files as guest user (more info: Scheduled Reminder Email is Empty).


texts: is it worth switching from Joomla to Drupal for better CiviCRM integration?

texts: Our site is currently using Joomla 2.5.27 and Civi 4.4.11. We need to either upgrade Joomla & CiviCRM to the latest or migrate our site to a drupal platform. Both sound like a lot of work. But we have some  kinks in optimally using Civi that appear to be the result of incompatibility w/ Joomla. I am not a developer but am a knowledgeable user; I have some tech volunteers who are prepared to help me once I make a decision. Any thoughts?


texts:
I have 2 domains example.com and example.org and both point to the same site on Wordpress.
Generally we use only .org but i would like that if someone goes to example.com/donate (where I have my civicontribute page embedded) I would like them to be able to submit donations from there too.
Is there a simple way to do this? Maybe add a second domain under define domain url  in sicicrm.settings.php?
Any help would be appreciated.


texts:
I am editing this question to provide more information.  I am running CiviCRM 4.7.8 with WordPress 4.5.3. We are using php 5.6.23.

When selecting "New Mailing" from the "Mailings" menu, the screen is blank. Using inspector and console I can see that there are more than 70 errors.  The first error is on line 270 of the angular.js file.  It seems that there is a comment in the file that is not commented out. All other errors are related to angular, mostly angular is not defined.

So we are unable to do a new mailing. We used this feature early last week and it worked fine. We did not upgrade or install anything new. I tried to turn off extensions, but that had no impact. The extensions were installed prior so no reason to expect that is causing the problem.

Any ideas what would cause this and how to troubleshoot.

Update: We did a fresh install of civicrm, but that did not solve this problem. Also, we have a staging version, which is the same as production without data (a different database) and staging works, just as production worked a few days ago.

When I go into Unscheduled reports, all of my attempts to start a new mailing are listed, but when I click the option to "Continue" I get the same error message.


texts: How to fix a broken invoice message template?

texts:
On a site that I've been looking after for over 10 years (and which therefore has gone through a lot of Civi upgrades, currently on 5.24.x) I've just turned on the invoicing feature.
The problem is that I have no message template entitled 'Contributions - Invoice" that I can edit. Checking the database there is no entry for this message template.

I can get the system to generate and send an invoice so there must be some template code somewhere that is doing this.

I copied the relevant database row from another installation and added this to my database, so it's now showing up in the UI, but any edits I make to this template are ignored by Civi.

So my question is how can I fix this issue? I'm assuming that the code that generates the invoice is not recognising my bodged message template and is therefore falling back on some internal base template. Maybe it expects the editable/edited message template to have a certain id that my attempt to fix has overlooked.

Any pointers as to how I might be able to resolve this and so be able to use an edited invoice template are most welcome.

I'm thinking the only other option may be some sort of major database rebuild using a current schema, which I'm keen to avoid getting into.


texts: Has Contact ID been removed from the Contact Import "Matching"?

texts:
I have a v strong memory, and screenshot evidence that we used to be able to 'match' by including the Contact ID in the import.

This was discussed in https://chat.civicrm.org/civicrm/pl/sjht4rjsxifwtk6iofe3a19ftw and here is the screenshot I have which I used to explain to a client how to do this back in Nov 2018 (haven't dug out the version but would have been as least the Security Release that was current at the time.

No such field shows on dmaster, and nor does eg 'internal id' or any other variation I could think of.


texts: Is membership by relationship charged for?

texts: I've created an organisation membership and set a cost. I've also made a relationship so employees inherit that relationship. I can't find out anywhere if someone inherits that membership are they also charged?


texts: PayPal Security notice, do I need to take action / upgrade Civi?

texts:
Do I need to upgrade CiviCRM? Should I be concerned? I'm running  CiviCRM 4.4.4.
See below:

This is a reminder email. If you have already taken action, please ignore this notification.
We’re contacting our merchants with some important information in response to an industry-wide security upgrade which is not unique to PayPal. This change involves upgrading Secure Sockets Layer (SSL) certificates over the course of 2015 and 2016. Our upgrade efforts for API endpoints are scheduled to start in June 2015.
Because these changes are technical in nature, we advise that you consult with your partner, website vendor, or individuals responsible for your PayPal integration. They will be able to identify what, if any, changes are needed. Please forward the information below to your technical contact for evaluation. We are here to help your technical contact work through this to ensure you continue to process payments through your current integration with us.
Full technical details can be found in our Merchant Security System Upgrade Guide. In addition, our 2015-2016 SSL Certificate Change microsite contains a schedule of our service upgrade plan.
Questions can be directed to our Merchant Technical Services team on our Technical Support website. Click here for more information.


texts: Can I report data from a disabled custom field or option?

texts:
I'd like to disable some custom field fields, because we no longer want users to enter that data. But then I can no longer see the field in report filters. Is there another way I can get that data out without re-enabling the field?

I would also like to disable some field options. Is the data preserved? Assuming so (maybe I shouldn't) how can I report or export it after it's disabled?

Thanks everyone

Thanks for the suggestions - however, I'm new to CiviCRM, what is CSS?  I think being able to change the visibility in the field when inputting would help, but you'd still have to have it visible for reporting.  (Other systems I have used just have a 'selectable' option tick box for each entry in the pick list - but this only controls new choices in a pick list, as all options are available for reporting.)


texts: CiviCRM (on WordPress) runs too slow to be useful

texts: Just installed WordPress and then CiviCRM on my Hostmonster.com hosted website.  CiviCRM runs too slow to be useful.  Is there w way to make it run without 1-2 minutes for each option selected, with timeout errors (504).  Is there a fix?


texts: facilitators viewing registration responses

texts:
We have co-facilitators for our instructional events who are not staff. We want them to be able to view the complete registration profile responses (i.e. 'registration info') prior to their event in order to know how many and who are registered, plan the event content based on registration responses, etc. There may be several events concurrently registering, with different facilitators.

We have created the custom fields and registration profiles and a report that shows responses, and that is working well. Just not sure how to have others view it. Event registration includes some questions common to all events (contact-level), and some custom fields that are event-specific (i.e. participant, not contact, level- such as previous experience with the topic, contexts in which they use the topic, familiarity with the content, etc.)

What's the best way to do this? I am a non-developer user and we don't have IT staff.

Ideas for how to do this include:
a) creating a 'facilitator' role (Drupal 7), which would include permissions to view only the report that contains that event's registration info. Not sure how to do this, might require ACL's?

b) customizing the participant listing to include event-specific registration responses, and sending the link to that. Not sure how to do this, but can look into it if this is the way to go.

c) ?is there a way to get a checksum or profile link that would say ‘here’s our registration’ with an expiration date

Thanks!


texts: Security Warning on Dashboard (pantheon / nginx)

texts:
Getting Security warning everytime I log into civicrm that my log directory is downloadable.
I checked and it is completely viewable on my browser.
I realize that there is a solution for nginx enviroments however I am running my site on pantheon and do not have access to any nginx configs.
Is there something I can do civi-side to fix this?


texts: Use Drupal Views to select Organisation and display contacts with a particular relationship to Organisation

texts:
I have been trying to work out how to create a Drupal View to allow end users to select an Organisation and then it displays Contacts given a specific relationship type.
eg Select Employer Name (Organisation) - display Employees of Employer
Relationship is the built-in Employer of / Employee Of

So far I have created a view with CiviCRM:Contact type and added a few fields, but the only 'relationship' details i can retrieve that is close for the 'employees' side of things is "CiviCRM Relationships: Contact ID B (Contact ID B)".  I dont see to have or can find a method to display Contact B's Display Name

Example - Selected organisation is Contact 'A' ID 203 'K&N Brass' and has a relationship to Contact 'B' who's ID=202

Contact ID  Display Name    Relationship Type A-to-B    Contact ID B
203         K&N Brass       Band includes member        202

Drupal 7.43
CiviCrm 4.7.7
Views: 7.x-3.13


texts: Mosaico returns 403 error due to data-bind attribute in template html

texts:
We get a 403 error by Wordfence Security on a wordpress site while creating a Mailing using Mosaico.
On little investigation - I see the error is due to the addition of data-bind attribute in the HTML. For eg. if the template html is -

  Don't want to receive any more email from us?

  Simply

    unsubscribe
   from our list.

The error in the console pops up not letting the template to be saved.

403 Forbidden
A potentially unsafe operation has been detected in your request to this site, and has been blocked by Wordfence.

If I remove the data-bind attribute from the anchor tag - the mailing is saved without any errors.
Also, if the Wordfence plugin is disabled - the 403 error is not shown - but this might not be the solution.
Any thoughts on why this error might be arising and ways to fix it?


texts: Sending speed 30% slower after upgrade to 4.7.30

texts:
We finished the migration on a fairly big database from 4.7.24 to 4.7.30, and now the sending speed is capped at 200kmails/h, where we were previously above 300k/h

any idea of what changed and cause that regression?

FYI: the trigger on modification date on activity is killing the update (we replicate the database), but I don't think it's related


texts: Install Civicrm 4.6.9 on Bitnami Drupal 7.41 - XAMPP

texts:
I have installed Drupal on XAMPP on my local host (WIN10). When I tried to install Civicrm i had a file size too big message so I changed the file size for uploads in PHP.INI and then tried the install with the civicrm-4.6.9-drupal.tar.gz file.
The screen went to a blank screen with a banner saying - "Installing civicrm". That was an hour ago and it looks as though it will stay that way until I close the browser window.
I am able to login to Drupal in another window.
I also see that in C:\XAMPP\tmp\ has some files and folders, one of which has a folder update-extraction-8a10ac65\civicrm\ with 7,728 files in it.
What should I do? Seems to me I am very close to an install.


texts: Civi won't take valid credit card number and verification number since upgrade to 4.7.24 - using PayPal Pro

texts:
Ever since upgrading to 4.7.24, transactions with PayPal Pro (in WP) generate the following error:

Please correct the following errors in the form fields below:

Please enter a valid Card Number
Please enter a valid Card Verification Number

The cc is valid and entered correctly on the Civi form.
Nothing is showing up in the Civi logs to clue me into what is happening.

When using a PayPal account directly rather than entering cc info on the civi page, transactions are processed correctly.
Recurring transactions are still processing and showing as completed in Civi.

Edit: The occurs on both online contribution pages and registrations pages.
A donation is processed correctly when entered through the backend.
A correct CVV code has been entered.  Earlier I noticed no cc were selected (when it was working), so I selected all anyway, and it still doesn't work on the front end.


texts: Random 9002 Errors from iATS when making donations

texts:
WordPress 4.6.26
Civi 4.7.3
iATS for Payment Processing

Beginning in Jan we started hearing from donors that when they set up donations they would get a 9002 Error when they clicked Confirm. So far it appears to be ACH transactions that are having trouble.

The iATS Request Log for these donations looks the same as all others. However, the iATS Response Log does not have anything in the auth_result field.

The first time this happened, I attempted entering the donor's account info for them and got the same results. 20 minutes later it went through with no error.

The other cases have processed the first attempt for me but I can see in the Response Log that they tried several times with no auth_results data. I have another one right now that the donor tried 2 days in a row and got the 9002 Error. I have not tried to do it yet because I was hoping to do some trouble shooting first.

At least two of the donors were using Google Chrome for their browser. I have not seen any problems with any browsers except IE.

How to get IATS working  It is about someone else getting the 9002 Error (but theirs was constant). I changed to Karin's https://www2.iatspayments.com/NetGate/ProcessLinkv2.asmx?WSDL and donations are still processing.
Just for clarification, does any one know:
1. What are the special characters to avoid?
2. Is this in our password with iATS/Civi or is this in the donor's password?
3. Is there a list of potential "misconfiguration" issues out there somewhere that I can go over?

Does anyone have any other ideas for troubleshooting the sporadic loss in communications? Are there other logs that would show if Civi actually sent the request or that show if iATS received the request?


texts: Permission error while accessing uploaded files

texts:
I have created custom field section in contribution page and I have one file upload field. Uploaded file is not able to access in View contribution (logged in as super admin), getting below error.

The only way to access this file is using edit contribution, the file is getting downloaded if I click the link.


texts: How to send confirmation when importing contributions

texts: When importing contributions, on the 2nd page where CSV columns are linked to database fields, there is no field "send a confirmation". Is there a way to add this field (and generate a confirmation after import)? Or do we have the use another method?


texts: ical html feed has raw code visible at the top of grid

texts:
The html page for my CiviCRM ical events feed has a mess of code visible at the top of the events grid.  The only similar problem I can find with a Google search is a bug report: "the Order Rows widget is broken again" but I can't find a solution.  My site is running on an AWS instance with Amazon Linux and the Joomla 3.6.2 framework and CiviCRM 4.7.11

Here is a link to the broken page:  https://greatconjunction.org/index.php?option=com_civicrm&task=civicrm/event/ical&reset=1&list=0&html=1

Thank you for your help!


texts: Network Error Related to CiviCase After Recent Upgrade to 5.8.2

texts:
I am new here and not an IT person so hopefully I ask this question correctly and with enough detail.

We upgraded over the weekend from CiviCRM 4.7 to 5.8.2 (drupal) and each time I login to the system I get a Network Error message that says "Unable to reach server. Please refresh this page in your browser and try again."  The hosting service suspects its a bug with CiviCase and provided me with a link to the detailed error information (no site specific details): https://pastebin.com/B75LJeh0

When I look at the cases, everything looks ok with the exception that in the "Case Coordinator" column, it lists "array" instead of the user's name.

Does anyone have any ideas or info they can provide me with? Thanks!


texts:
The process to upgrade my civiCRM database from 4.7.11 to 4.7.13 terminated with the following error:

[Error: Upgrade DB to 4.7.13: SQL]
Error Field Error Value
Type    DB_Error
Code    -19
Message DB Error: no such field
Mode    16
UserInfo    ALTER TABLE `civicrm_price_field_value` CHANGE `deductible_amount` `non_deductible_amount` DECIMAL( 20, 2 ) NOT NULL DEFAULT '0.00' COMMENT 'Portion of total amount which is NOT tax deductible.' [nativecode=1054 ** Unknown column 'deductible_amount' in 'civicrm_price_field_value']
DebugInfo   ALTER TABLE `civicrm_price_field_value` CHANGE `deductible_amount` `non_deductible_amount` DECIMAL( 20, 2 ) NOT NULL DEFAULT '0.00' COMMENT 'Portion of total amount which is NOT tax deductible.' [nativecode=1054 ** Unknown column 'deductible_amount' in 'civicrm_price_field_value']
PEAR_Exception: DB Error: no such field in unknown on line unknown
- DB_Error: DB Error: no such field in unknown on line unknown

How can I fix this?
EDIT
As per question, the table structure is:

    +-----------------------+------------------+------+-----+---------+----------------+
| id                    | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| price_field_id        | int(10) unsigned | NO   | MUL | NULL    |              |
| name                  | varchar(255)     | YES  |     | NULL    |              |
| label                 | varchar(255)     | YES  |     | NULL    |              |
| description           | text             | YES  |     | NULL    |              |
| amount                | varchar(512)     | NO   |     | NULL    |              |
| count                 | int(10) unsigned | YES  |     | NULL    |              |
| max_value             | int(10) unsigned | YES  |     | NULL    |              |
| weight                | int(11)          | YES  |     | 1       |              |
| membership_type_id    | int(10) unsigned | YES  | MUL | NULL    |              |
| membership_num_terms  | int(10) unsigned | YES  |     | NULL    |              |
| is_default            | tinyint(4)       | YES  |     | 0       |              |
| is_active             | tinyint(4)       | YES  |     | 1       |              |
| financial_type_id     | int(10) unsigned | YES  | MUL | NULL    |              |
| non_deductible_amount | decimal(20,2)    | NO   |     | 0.00    |              |
| help_pre              | text             | YES  |     | NULL    |              |
| help_post             | text             | YES  |     | NULL    |              |
+-----------------------+------------------+------+-----+---------+----------------+


texts: Custom field data - maintaining uniformity

texts: I want to add Educational information of individuals as custom field set. However I want the data to be entered to be uniform. In our organization, different people will enter data into civiCRM. Some may enter as "B.Tech" or "BTech" or "Btech" etc. How do I ensure same format is used in the database for all degrees?


texts: CiviEvent Confirmation Email Displaying Profiles Not Used In Event

texts:
We have created some custom fields/profiles to use with certain CiviEvent registrations. These profiles only display in the event registration when they are selected in the event setup - as expected. However, these profiles appear in the confirmation email despite not being selected for use in the registration. See image below - the highlighted area shows the proflies/custom fields that should NOT appear because they were not used in the event creation. How do I stop them being sent with the confirmation when they are not used?

Thanks,
Eric
CiviCRM 5.4.1
WP 4.9.8


texts: Is there a way to see the actual change performed by the entry in the change log?

texts:
The change log as it stands seems pretty pointless if you only can see that someone has changed something (anything) for a contact.

Is there any way to see what was changed?


texts: How to recording financial classes in addition to financial types in a contribution?

texts:
We have been using CiviCRM's 'Campaign' functionality as a way of assigning additional information to contributions. It's how we have made CiviCRM more compatible with our Quickbooks, which makes extensive use of 'Classes'. So we match up 'Financial Types' from Civi with 'Accounts' in Quickbooks, and match 'Campaigns' in Civi with 'Classes' in Quickbooks. This has worked well as long as all financial types on a given Contribution page in CiviCRM were associated with a single 'Campaign'.

However we now have a need for contribution pages that not only record different financial types (through price sets), but also record different campaigns. The intention is to allow people to contribute towards multiple things with a single payment- for example: if I were to donate towards the 'Event Scholarship Fund', make a payment for my Membership, and make a donation towards the 'San Francisco Center', those would each have separate accounts and separate classes when they are entered into Quickbooks.

I would like to give donors the option to contribute towards many different areas and only have to enter their payment info once. As it currently is set up, I can only associate a single campaign with a contribution page. So the donor would have to visit multiple contribution pages and enter their payment info each time as it is currently set up.

Does anyone know of another way to accomplish this? To record both financial types and classes in CiviCRM?

I have considered adding a new financial type for each class and appending the class name to the end, but this would result in an unwieldy number of financial types. I thought about using custom fields in place of Campaigns, but couldn't figure out a clean way to use them to accomplish this same purpose. Campaigns work really well for us because of the way they are integrated throughout CiviCRM, but I can't figure out how to move forward with this and accept multiple donations on a single contribution page in a way that integrates with our accounting.


texts: CiviMail adds call to onbeforeunload function then throws "Illegal Characters" error over and over again

texts:
I recently upgraded to 4.6.2...All's well until I try to create a new mailing. Every time I start to compose a message from scratch, or use a template a javascript call to the 'onbeforeunload' function is inserted into the bottom of the message which causes an error box to pop-up reading

"Error Illegal characters in input (potential scripting attack)"

What is going on? I've tried using different wysiwyg and no wysiwyg with the same results. It doesn't happen in any other HTML field I can find in CiviCRM or Drupal, only when creating a new mail message but I can't save or send a message because every attempt causes the script to be added and the error to be triggered.

HELP!! This wasn't happening before the upgrade. But I'm stumped for a cause.


texts: I'm looking for a way to add sorting and/or grouping by county to reports. Specifically, Membership Details and constituent Details. I've tried a bit of monkeying with the PHP but I don't seem to have a good enough grasp of it. I'm running v4.7.6. Thank you.


texts: Is there a way to display a CMS username in a profile?

texts:
We are using Drupal 7.

We have a makeshift membership directory using profiles.  That works great.  But our members often forget their usernames, and we have some systems where members can uniquely identify other members by their usernames.  So it would be nice to display their user name in the membership directory.  Is there a way to do this?


texts:
I am thinking of creating an extension to integrate QR code for Event Participant

Do we any extension for QR code integrated already?

Thanks


texts: How can I fix this error on CiviCRM. Thanks.


texts: Use of tokens in Events - Online Registration Intro Text and Confirmation email

texts: We have events over multiple days. The Intro Text on the confirmation screen and the confirmation email only show start date and time and end date and time. Registrants don't see the specific dates and times of multiple day events. In the reminder email we can insert tokens {event.summary} and {event.location} and it works great to give all the details.


texts:
I let the user select which payment processor to use. Since I made this change, PayPal standard has stopped communicating correctly with CIVICRM.

When someone puts a payment through a webform w/civicrm intergration, they go to PayPal standard and payment is taken, but when the form attempts to return the user back to the website it comes up with error shown in the screenshot. The payment stays as pending in CIVI.

The link for the error page is
https://www.vegansociety.com/civicrm/contribute/transact?_qf_ThankYou_display=1&qfKey=

CIVICRM 4.6.33 - Drupal 7.

Any ideas? Thanks,
Andy


texts: How to setup cron for updating membership statuses in cPanel

texts:
How do I setup cron (via cPanel) to execute, specifically membership statuses? I.e. I know how to get to cPanel's cron management, but not sure how I tell that cron management tool to execute the membership status cron as setup inside of drupal.  An example for doing that (and to run all of them) would be nice. :-)

I've read the CiviCRM manual for membership status AND watched the cPanel video, but really need an example for doing specifically the above, and with that information I think I can construct all the others I need.

Using CiviCRM 4.7.13, Drupal 7.51

Thanks,

Carl


texts: CiviCRM Initalization Error: DB Error: extension not found

texts:
I've got CiviCRM installed within a WordPress context, and both are updated. The problem is that, with the last update that occurred, I can no longer get to CiviCRM. Instead, I get the following displayed on a blank page without any styling:

Initialization Error

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

    [code] => -25
    [message] => DB Error: extension not found
    [mode] => 16
    [debug_info] =>  [DB Error: extension not found]
    [type] => DB_Error
    [user_info] =>  [DB Error: extension not found]
    [to_string] => [db_error: message="DB Error: extension not found" code=-25 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info=" [DB Error: extension not found]"]
)

Does anyone have any idea how I can fix this? It says an extension is not found, but there is no mention of what the extension is or why it's missing as the result of an update.


texts:
If someone with access to the Civi dashboard makes a change to any contact information, is there a way to send an email alert to the site Administrators?

Civi 5.2
WordPress 4.9

***ADDITIONAL INFO ADDED 11/30 ****

I am experimenting with CiviRules.  It looks promising, but I still haven't found a solution.  I am going to spell out more what I am trying to do and hopefully someone can clarify if Civirules can achieve that.

We have about 60 volunteers sorted in a group.  Occasionally a member of the staff will make a change to a volunteers contact information.  The Coordinator who oversees this group of volunteers wants to receive an email alert anytime a change is made to any contact within that group.

It looks like we might be able to do that with CiviRules, but I am not yet seeing how to apply a rule to a specific group and how to get it to email a specific person when a change is made to that group.
I have the Linked Trigger set to "contact of any type is changed"
I am not seeing anything that sounds like it fits in Linked Conditions or Linked Action, such as email this coordinator when a change is made.
I guess I am still not understanding how it works.


texts: copy Address of Primary Registrant to Additional Registrants

texts:
I am once again working on an event registration for an annual convention. I'd like to kno, and searching has thus far yielded nothing, is it possible to copy the first registrant's address to subsequent registrants? We often have families registering their additional household members and duplication of data entry is often cited as an annoyance. Thanks in advance.

Rachel


texts: Advice on structuring tuition payment plans. Membership? Contribution?

texts:
I have an annual tuition total that some parents pay in one installment, some in two, and some in 10 monthly payments. This past year, we set it up as a pledge that parents worked towards with contributions on a contribution page, but as I set up for next year I think it might be more effectively tracked through CiviMember, perhaps with price-sets? I would also like to be able to use the CiviDiscount extension in the tuition payments, and have some way of allowing parents to contribute to a scholarship fund on the same page.

Does CiviMember allow payments on an installment plan?
Does CiviDiscount work with the above answer?
What setup would you recommend for this use case?


texts: Upgrading CiviCRM that is set up outside of the Drupal docroot with symlinks

texts:
I am finally upgrading the CiviCRM on a website I didn't develop. It is running on Drupal 7.50, (upgraded from 7.37), and is currently version 4.3.8. Planning to upgrade to 4.7.13.
Here's the thing: it was set up outside of the Drupal docroot, using symlinks and some other setting changes. It works, but it's more complex than the usual setup. Due to the already heavy nature of our Drupal site, it is my understanding that this setup would help with performance issues. I want to both upgrade it and move it into the Drupal sites/all/modules directory.
Aside from the usual steps to perform the upgrade up so many versions, I wanted to see if anyone could anticipate any upgrade problems I might have and evaluate my plan outlined below to complete the upgrade, due to this unique situation? Let me know if this is out of the scope of this forum, and I'll remove it, though it might be helpful if someone else finds themselves in the same boat. I am going to try these steps out on a dev copy before attempting it on production.
The Setup:
CiviCRM root is in /var/www/html along with our Drupal Docroot, and all components are as such:

CiviCRM Home: /var/www/html/civicrm/v.4.3.8-d7

Drupal Home: /var/www/html/drupal/docroot

CiviCRM Settings: <drupal home>/sites/default/civicrm.settings.php

CiviCRM Files: <drupal home>/sites/default/files/civicrm

Symlink to Codebase: <drupal home>/sites/all/modules/civicrm -> <civicrm root>/v.4.3.8-d7

Settings_Location.php:  <civicrm home>/v.4.3.8-d7/settings_location.php
   define( 'CIVICRM_CONFDIR', '/var/www/html/drupal/docroot/sites' );

The Plan:

Back up the Drupal and CiviCRM codebase and database into '/var/www/html/backups'

Login to Drupal site and put website into maintenance mode; stay
logged in

Disable Drupal CiviCRM integration modules

*Delete symlink in <drupal home>/sites/all/modules

Make the <drupal home>/sites/default directory writeable to the
server

Download and unpack v4.7.13 to <drupal home>/sites/all/modules

Backup and move civicrm.settings.php file

Clear browser cache and all files in <drupal home>/sites/default/files/civicrm/templates_c/

Run the install: http://<drupal home>/civicrm/upgrade?reset=1 (for
clean URLS)

Update the CiviCRM Resource URL

Re-enable Drupal CiviCRM integration modules

Check Drupal role settings

Pull the site out of maintenance mode

*extra or modified steps I added to the usual ones listed in the upgrade guide:
Resources
https://wiki.civicrm.org/confluence/display/CRMDOC/Upgrading+CiviCRM+for+Drupal+7


texts: How can I prevent CiviMail Bounce Processing from moving mail to "ignored" folder?

texts:
Since we have activated CiviMail Bounce Processing, our team members don't see regular incoming mail (which has nothing to do with CiviCRM) in the inbox of our main org account anymore.
The problem is that CiviCRM moves all email from the inbox to a subfolder CiviMail/ignored, thereby removing the mail from the inbox where our team usually would look.

Is there a way to prevent CiviCRM from moving "ignored" messages and just leave them in the inbox?
Or what is the intended workflow here? Do we have to set up a separate e-mail account that will just be used for sending out mass mailing from CiviCRM with a reply-to to our "normal" contact email?


texts:
Overarching question - Is there a way to see the actions that a specific user has performed?  For example, is there a way to see what records a user has exported?

Details - We recently had an employee succumb to a phishing attack.  The employee provided a username and password that could be used to access Civi.  While we think that we were able to catch the problem before anything suspicious happened, we would still like to see what this user (or someone pretending to be the user) did while in Civi.  We are specifically concerned about any downloaded information.  We are running Civi 5.24.5 and our website is using Drupal 7.


texts: How do I access civicrm.setting.php file?

texts:
How do I access PHP files? I'm having the problem where when people try to click on a contribution page, this error comes up:

  Sorry but we are not able to provide this at the moment. We can't load
  the requested web page. This page requires cookies to be enabled in
  your browser settings. Please check this setting and enable cookies
  (if they are not enabled). Then try again. If this error persists,
  contact the site adminstrator for assistance.Site
  Administrators: This error may indicate that users are accessing this
  page using a domain or URL other than the configured Base URL.
  EXAMPLE: Base URL is http:// example. org, but some users are
  accessing the page via http://www. example. org or a domain alias like
  http://myotherexample. org.Error type: Could not find a
  valid session key.

I've found a few examples of the same thing happening and people keep suggesting that I make sure my base URL is the same as in the civicrm.setting. php file. I found the base URL (it looks fine, and we haven't changed the domain name or anything) but how do I access the file to compare it to? We're on Wordpress v 4.6.1.


texts: Is there a way to update CiviCRM through the Drupal Admin/Modules panel?

texts:
This is getting so frustrating!  It is a real PITA to update CiviCRM every single time there is an update.

We use several extensions.  According to the documentation, I have to disable each extension (which you can't do in bulk, you have to disable them one at a time), back up the database, make a copy of the site, delete all CiviCRM files, download the update, unpack it twice (.gz and then .tar), upload it to the hosting provider, run the update script, figure out why the system still thinks it it's in update mode (causing many things to not work!), re-enable each extension individually, then try to find out why this stupid unserialize error at line 153 keeps popping up (I have yet to figure out what table is causing this, but I have determined it does have something to do with the database, I even downloaded an extension that is supposed to tell me, but I can't seem to get it to work).

We are on a shared hosting plan (non-profit so cheap cheap cheap), so sometimes the admin side is painfully slow and it is not unusual for it take 4 hours or more to do a simple update that should be able to happen like updating any other module through the Drupal panel and take about 15-20 minutes.

Is it every going to happen this way, or will I always have to do this manually?

Thanks.


texts: Extensions not discoverable in Civi 4.7.7

texts:
I am recreating a Joomla site (3.5.1) with Civi 4.6.10 and upgrading to civi 4.7.7. I have been unable to install extensions on the new site that were working under 4.6.10.  I made sure I had the latest versions from github for each, checked that no issues had been reported and tried a manual install, which had worked for me in the 4.6.10 site. No luck. Any ideas on alternative installation methods or progress on extension review would be helpful. Here's more detail of my workflow:

I did a completely new install and imported the Joomla data into the new site db without issues. I installed Civi 4.7.7 without a hitch, then tried to add the extensions that were installed on the 4.6 site. Two appear on the automatic install list: CiviDiscounts and Extended Reports. The remainder (Mailchimp, Fuzion Tokens, Event Calendar, Create Membership Relationships and Automatic Soft Credits) are not available in the "add new" list. I made sure I had the latest versions from github for each and tried a manual install, which had worked for me in the 4.6.10 site. No go -- the extensions don't appear in the extension list to be installed. In the documentation for these extensions, all of them indicate compatibility with version 4.6, but not 4.7. I've delayed the site upgrade as long as I can and cannot launch without several of these extensions.


texts: What is the status of the make it happen for permissions on activities and cases?

texts:
The make it happen listed here is something we're interested in having. What does it mean to be a "confirmed" make it happen? Is this particular capability coming soon?

(I emailed the make it happen lead and one other address associated with make it happen and haven't heard anything yet) Thanks!


texts: Quicksearch "name/email not found. Did you mean to search by name/email instead ?"

texts:
After a Civi update from 4.x to 5.8.1, quicksearch stopped searching on email addresses when using the name/email option (the first and default option in the dropdown). It returns no results, and comes with the message "name/email not found. Did you mean to search by name/email instead ?"

If we use the 'email' option from the dropdown list, it works as expected.

The search preferences look like before. The first quicksearch option, "Name/email" can not be unchecked there.

Under the hood, the option is called "sort_name", both in the preferences screen and in the quicksearch widget itself (however, as soon as you start to type, you are typing in another widget, without a name, but that could be voodoo)

After clicking enter, which takes you to the advanced search, it shows the results as expected, including matching emails (Results for "Name or Email LIKE - 'pike-foo'")

Is the sort_name perhaps cached somewhere in 5.x , and do I need to build/rebuild it ?


texts:
Running Drupal 7.59, CiviCRM 5.8.1 and PHP 7.1.26. After selecting two known duplicate records from a list and selecting the action "Merge Contacts", I receive the following error message.

Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
DB Error: no such field

We migrated from one hosting site to another approximately three weeks ago and have been unable to merge any records since then. I don't know if this could be the reason but it should be considered.
I have tried to merge different Types of Contacts (Individuals, Organizations) but the result is always the same - "DB Error: no such field".
Any suggestions would be greatly appreciated.


texts:
So, utilizing Authorize.net, the verification seal code has a JS call in it.  However, when trying to save the online event registration page, CiviCRM complains that there may be a JS attack in progress.  Pulling the script bits out removes the error and the link still says it's verified.  The code is typical JS light, but seems very benign in the same way.  Anyone else experiencing such an issue?

Here's the JS call, with the potentially confidential bits mixed up:
<script type="text/javascript" language="javascript">var ANS_customer_id="redacted";</script><script type="text/javascript" language="javascript" src="//verify.authorize.net/anetseal/seal.js" ></script>

Wordpress:  4.5.2
CiviCRM:  4.7.8


texts: Combining Event, Membership & Contacts into single report

texts:
So I can easily create a Search Builder for what I want, my challenge is creating a report that I can print an take to an event

Criteria:
Either registered for event
OR
A member of a specific group

From Contacts
Name, Email

From Membership
Status, End Date (if any)

From Event
Registration (if any)

The problem is that all the report templates are missing one or several of these items, or assume you only want event participants or current members.

Am I missing something or this is a known limitation?


texts: Webform to start or cancel a relationship

texts:
I'm having trouble setting up a form that would pickup an organisation that a contact is a member of.
I've set my form with 2 contacts, second being the organisation. The field "Existing Contact" is set to static, but when I type in the name of the person, the field doesn't change to list the name of the organisation, it just stay on not found.

I'm attaching a screenshot of my setting.

Any help appreciated


texts: I am doing a fresh install of CiviCRM. Civi is using the WP database. When I use the Installer, I get the error "CiviCRM data from previous installation exists in 'db_WPyadayada'. Is there a way to delete all the Civi tables from 'db_WPyadayada' and connect Civi to another database?  I have another database 'db_wtf1' that has up to date contact info etc. from a previous installation.  If I try to connect to that database with the Installer I get the same error "CiviCRM data from previous installation exists in 'db_wtf1'.  Is there a way to work around this?


texts: Dedupe rule ignores the location type for Email/Phone but does not ignore for Addresses. Should we make this consistent

texts:
per the title, what do others think is the better behaviour

a/ ignore Location Type for Email, Phone, but use Location Type for Address (status quo)

b/ change so Location Type is never taken in to consideration (ie Address would be treated same as Email, Phone)

c/ change so Email/Phone also have Location Type taken in to consideration when applying matching rules.

Reason for asking is we got caught out using a rule with postcode. We expected the postcode to be location agnostic. Seems it isn't.


texts: Translate Personal Campaign Pages / User interface

texts:
I have a multilingual setup (2 languages), and I would like to create Personal Campaign Pages.

But some the user interface texts are not translatable:
 - The thermometer texts are not translatable: "x% towards our goal", "€ xxx raised", "Goal: xxx"
 - The texts about the Honor Roll at the bottom of the contribution page are not translated: "Show my contribution in the honor roll", "include my name and message", "list my contribution anonymously"
 - "Create your own fundraising page" link at the bottom is not translatable
- Text at the bottom of the contribution page "This contribution is being made thanks to the effort of xxxx, who supports our campaign..."

How can I get these texts translated?


texts: Why am I receiving an ' Unable to retrieve card details from iATS. Error: Invalid Username or Password' Error?

texts:
I'm using the following steps to produce this error:

Under the 'Contributions' tab of a contact on CiviCRM, click 'Recurring Contributions'

Click 'View' under the individual's recurring contribution

Clicking any of the following links (View, Edit, or Process)...

...results in the following error: 'Warning: Unable to retrieve card details from iATS. Error: Invalid Username or Password' (please see screenshot below)

Donations seem to be processing fine on CiviCRM and iATS, and CiviCRM and iATS seem to be communicating fine with each other (other than this error).


texts:
I started with a fresh install of Drupal 8 and did a migration of about 5K users.  I am trying to force a recreation of the UF Matches. I cannot find a way to get CiviCRM to do this so I wrote the following code but this is not working either. Currently it delete the UFMatch from the table but it does not finish the final API call that creates the new match.
\Drupal::service('civicrm')->initialize();
$q = \Drupal::entityQuery('user');
$q->accessCheck(FALSE); //This is ran under cron
$q->sort('created', 'DESC');
$q->range(0,1);//Testing
$users = $q->execute();
foreach ($users as $uid) {
    $drupal_user = \Drupal\user\Entity\User::load($uid);
    $user_email = $drupal_user->getEmail();
    $result = civicrm_api3('UFMatch', 'get', [
        'sequential' => 1,
        'return' => ["contact_id", "uf_id"],
        'uf_name' => $user_email,
    ]);
    print $user_email;
    if ($result['is_error'] == 0) {
        foreach ($result['values'] as $value) {
            $uf_id = $value['uf_id'];
            $contact_id = $value['contact_id'];
            $uf_match_table_id_result_array = civicrm_api3('UFMatch', 'get', [
                'sequential' => 1,
                'return' => ["id"],
                'contact_id' => $contact_id,
            ]);
            $uf_match_table_id = $uf_match_table_id_result['id'];
            if ($uf_match_table_id_result_array['is_error'] == 0) {
                foreach ($uf_match_table_id_result_array['values'] as $uf_match_table_id_result) {
                    $delete = civicrm_api3('UFMatch', 'delete', [
                        'id' => $uf_match_table_id,
                    ]);

                    if ($result['is_error'] == 0) {
                        $create_match = civicrm_api3('UFMatch', 'create', [
                            'uf_id' => $uf_id,
                            'uf_name' => $user_email,
                            'contact_id' => $contact_id,
                        ]);
                    }
                }
            }
        }
    }
}

I think the issue might be the $uf_id variable that I am getting from the contact and using in the UFMatch create API call.
Any ideas how to do this better or help with the code is greatly appreciated.
Thanks,
Steve


texts: After 5.18.4 Upgrade, Cases are Missing from the List

texts:
After Drupal 7.67 and CiviCRM 5.18.4 upgrades, when you click on add a case, the correct screen opens, you can enter data, then save, and the number of cases showing in the constituent summary is incremented, but no new cases show up in a list to be managed. This was previously, for several years on prior versions, working correctly, Also, even for existing cases, the activity dropdown list is not being populated, although they have worked in the past and the Activity Type Options are correctly setup.

So now, in short, the number of cases in the Contact Summary is correct, such as 2 for a certain client, but when you click on the Cases tab, only 1 case appears. CiviCRM was no upgraded to 5.19.0 and the problem persists.

Examining the Case data directly in the database shows no clear reason for this. Furthermore the options for activity_type for the CiviCase component are also in the database and match those of a fresh install.

Has anyone run into this or can you suggest other things I can do to troubleshoot?


texts: List all Group linked in ACL for specific User

texts:
How do I list group linked for a specific user in CiviCRM

Example: I have three user group in Civi - Admin, user and staff

I have linked only one group (staff contact) for staff user with ACL

Now If I login has staff user he can only see (staff contact) group

I need SQL or a civiCRM function which can return me the group based on Contact_ID

Thanks in Advance


texts: Outbound mail fails after upgrading to 4.7.1

texts:
I recently upgraded my site to 4.7.1.  Outbound SMTP does not work.  Even though I use the correct credentials, I get errors and email does not send.  I restored my site back to 4.6, and all is good.

Tried testing on your sandbox, but 4.7 is not available yet.


texts: I have a big issue with my contacts. My database contains all of the correct information. I have checked it all in phpMyAdmin. Out of no where, when I search for contacts in Civi, it comes up with 0 contacts. It's like they all got deleted automatically. Please help!!


texts: Why CiviCRM is not in wordpress.org/plugins/?

texts: Why CiviCRM is not in Plugins.wordpress.org? See https://wordpress.org/plugins/search.php?q=civicrm . There are 9 plugins, but not civicrm.


texts: CiviMobile: Minimal Permission for CiviMobile

texts:
i am testing out CiviMobile deployment with my CIVICRM (Wordpress 5.0 CIVICRM 5.13) and wanted to see how the app works with a log-in account that has restricted access to selected records in the CIVICRM server.

I have set this account to the CONTRIBUTOR account in WP to differentiate it from the ADMIN account.  And to CONTRIBUTOR role i added the following CIVICRM permissions on top of the default:

CiviCRM: view my contact
CiviCRM: access CiviCRM backend and API

TESTUSER is the test account used and added to the CONTRIBUTOR role.

I did the access control by only adding TESTUSER to a access control GROUP that is allowed to access a group of records.  TESTUSER was able to access only the intended GROUP of records when loggin into the Wordpress site with just the PERMISSION 2 listed above.

I tried with by logging into CIVIMOBILE, it complained of not sufficent permission so I added PERMISSION 1 and was able to login.

When logged in, i was able to view profile and calendar of the logged in account OK but not able to do so for the accessible records. Their names will appear under CONTACTS but when clicked will complain "PERMISSION REQUIRED"

However, with the same permission set, the SUMMARY page of details for the record is accessible when using the TESTUSER account to log into Wordpress to view the record.

It seems that there might be further permission required to be given to the ACCOUNT that is using CiviMobile to access a restricted set of records.  What would those permissions be?  Thanks.


texts:
The docs on synchronizing users to contacts say:

You can then search your contact records to view or edit the new
contact records. Go to Advanced Search , >>Change Log section and
enter dates that include the date when the synchronization was
performed.

But on my Advanced Search page, there is no Change Log section. Has this changed? How do you search the change log?


texts: How to update preferred language depending on a custom field in imported contacts?

texts:
I have imported hundreds of contacts having a custom field called "Langue" in set "ocsr" and having two possible values, 'F' and 'N'. I want to transfer this information into the field preferred language, with values 'fr_FR' and 'nl_NL'.

I suppose it is possible to do it in one Mysql operation, but I don't find where the custom field value is stored:

update civicrm_contact set preferred_language = 'fr_FR' where ... ocsr::Langue ... = 'F'

Any hint would be appreciated.


texts:
when I try to chain commands in the content body of a POST, the contact is created fine, but the chained address is not created. I am not OK with passing sensitive donor information as parameters in the URI (which is against the HTTP protocol specifications for a valid reason), so I need to figure out what the expected syntax is for body contents:

contact_type=Individual&first_name=joe&last_name=blow&api.Address.create={"location_type_id":"Home","street_address":"123 somewhere st"}

passed in the URI, the above works fine...

in the header I'm specifying Content-Type: application/x-www-form-urlencoded
and json=1 in the URI


texts: How are people dealing with ampersand replacement in CKEditor?

texts:
In WordPress and Civi 4.7.13, CKEditor replaces & with

&amp;

This inherently breaks using smarty in mail/PDF templates. How are other people getting around this one?

I've tried setting forceSimpleAmpersand in files/civicrm/persist/crm-ckeditor-config.js as per the CKEditor docs, but I can't get it to have any effect. Other settings in the same config file do work, so I know that file is ok.

This setting did work in the older version of CKEditor in 4.6.x, annoyingly.


texts: Emails get stuck on send. How do I debug it?

texts: I can send emails individually, but bulk emails never seem to work right. I've had no luck troubleshooting it, so I created a test group and added my own contact user to it and verified that it has my email set to home and primary. I created a new mailing to the group and sent it, and it says it started sending, but it hasn't sent anything, and the completed column is still blank. I clicked report on it, and it shows one recipient, but when I click on intended recipients, it says "There are currently no Intended Recipients". So I created another contact with a different email address, added it to the group, and sent another bulk mail. When creating the mail and selecting recipients, it shows the two expected contacts. Then I used "send test to group" to the same group, and both contacts received the test email immediately. So I submitted it, but it still didn't send to either user. The report shows 2 recipients, but when I click to see them, it says there are none. I checked a previously successful email, and it does list the recipients correctly. I turned on debugging, but I guess I don't know how to use it, because it didn't show anything. The scheduled job log shows the same generic success messages down the page, no errors or anything useful. Anybody know what's going on or how I can get some visibility into it? Is there a log file besides the cron log, or is there a way to get more messages into it?


texts: Civi posting additional records for recurring PayPal transactions

texts:
I'm having problems with recurring transactions with Paypal Pro.  It's posting additional financial_trxn and financial_item records.

I have exported an example including the following tables:

civicrm_contribution
civicrm_contribution_recur
civicrm_entity_financial_trxn
civicrm_financial_item
civicrm_financial_trxn
civicrm_line_item

Looking at the entity_financial_trxn table, instead of one entry for the contribution and one for the fee, two are generated for each. (Contributions: 283111, 283114; fees: 283112, 283116) Also, the second contribution record (283114) does not have an associated financial_item record created.

In the financial_trxn table, the contribution transaction is entered twice (ids: 141185, 141187).  The first entry does not have a valid payment processor code.  The second does not have the net value calculated or a valid status code.  ALso, the fees are also entered twice (ids: 141186, 141188).  The first entry is missing the payment processor code.

Since there are two entries for fees in the financial_trxn table, there are also two entries in the financial_item table (ids: 142094, 142096).

So the contribution information is not fully correct in either financial_trxn record.  The second fee record in the financial_trxn table is correct.  All of these additional records are making the bookkeeping reports inaccurate.


texts: Different profile based on membership selection

texts:
When our members join or renew online, I want to use a different profile to capture different information depending on the membership type. For example, if someone selects an "Educator" membership, I'd like to use custom fields to capture the programs they offer and the audiences they reach - but those fields aren't relevant to the other membership types, so I don't want to use the same profile for all types.

Is there a way to select a certain profile based on the membership type selected, or do I need to create separate contribution pages for the different membership types?

I am using CiviCRM 5.18.2 with WordPress.


texts: Send civicrm email receipt immediately for recurring contributions - Authorize.net

texts:
I am using drupal, civicrm version 4.7.27.  I would like email receipts from CiviCRM to be sent immediately for recurring contribution, rather than waiting for Authorize.net to process the credit card overnight.  In previous versions, there was code in the file CRM\Contribute\BAO\Contribution\Utils.php that I could comment out, to override the default behavior for receipt.  This was the code I commented out:
//Do not send an email if Recurring contribution is done via Direct Mode
//We will send email once the IPN is received.
//if (!empty($paymentParams['is_recur']) && $form->_contributeMode == 'direct'){
//  return TRUE;
//}

This code no longer exists.  Can anyone tell me if there is a way in version 4.7.27 to force CiviCRM to send a receipt immediately for a recurring contribution, even if it has not yet been processed by Authorize.net?

Thanks!


texts:
CiviCRM 5.14.0
I am using the Sparkpost extension
This is a new site in testing phase

I have set my from email address to be: "Site Administrator"  This domain has been verified by Sparkpost and is a working mailbox.

If I set up a mailing and click on Track Replies in the response tab, I get this message:

The "Track Replies" option conflicts with the "Reply-To" option. The "Reply-To" option has been disabled.

I assume that this is just a warning that the system will not use the "From" email address for the reply.

When the recipient clicks reply in the email client, the reply address looks like this:

r.105.160.ac5032573de28c3c@vietfeir.com

This address obviously does not exist on in my Postfix virtual_users table. I also believe it should be r.105.160.ac5032573de28c3c@ccrmmail.vietfeir.com and use the domain of the From address.

I changed the reply address to r.105.160.ac5032573de28c3c@ccrmmail.vietfeir.com and got this error.

An error occurred while sending mail. The mail server responded:
5.1.1 <r.105.160.ac5032573de28c3c@ccrmmail.vietfeir.com>: Recipient address rejected: User unknown in virtual mailbox table.
 Please check the message recipient "r.105.160.ac5032573de28c3c@ccrmmail.vietfeir.com" and try again.

Now, ccrmmail.vietfeir.com is a CNAME that points to sparkpostmail.com but it is still being rejected by my Postfix server.

I'm not sure what to do to fix this.


texts: CiviCRM 5.9.1 Cannot Read Database Information

texts:
CiviCRM 5.9.1 WordPress 5.0.3 PHP 7.2

Upgraded after migration between servers from 4.7.29 w/o issue. When I went inside the CiviCRM it asked me to redo everything like a new install. I went to the MySQL tables and all of my data is there; however, it is not "read" by the CiviCRM. I even added the :3306 to localhost in the civicrm.settings.php and am simply stumped. I have verified that the database info in the DSN section is identical to the database itself. I am running on Business Cloud so I have access to cPanel, phpMyadmin, and terminal. There are NO entries in the error log file. Server runs LightSpeed; however, I have added comments addressing it for WordFence.

The two images show that there are Contacts in the DB (along with everything else) and that the CiviCRM instance does not find anything other than what I filled out. I have also taken a screenshot of the civicrm.settings.php to show that it is set to access my database and one of the database settings itself.

ANY help is GREATLY appreciated as I have tried for over a week to set up an account with Mattermost and it still will not send me an email link.