texts: Stripe + Webform in Civicrm doesn't work

texts:
I am using Civicrm 7.x-5.12.3 on Drupal 7.66 with Webform 7.x-4.19; Webform CiviCRM Integration 7.x-4.26 and webform-stripe 7.x-1.15. The stripe-php is also installed.

I am having this issue that I don't manage to solve.
How could I make Stripe work? Any ideas?

You can test the form here : membership using webform

thank you

Guillaume

Notice : Undefined index: stripe_error_url dans CRM_Stripe_Customer::create() (ligne 94 dans /home/allingro/gestad/sites/default/files/civicrm/ext/com.drastikbydesign.stripe/CRM/Stripe/Customer.php).
Failed to create Stripe Customer: Payment Response:
Type: invalid_request_error
Code: resource_missing
Message: No such token: Stripe Token


texts: What does CiviConnect do? ("Connections" in the System menu)

texts:
I found this old blog post: https://civicrm.org/blog/totten/toward-civiconnect

The CiviConnect initiative aims to provide an alternative to the scavenger hunt while preserving Civi's core values (Free/Libre Software, data ownership, on-site deployment, etc).  How?  By providing a simple, secure mechanism for finding and connecting supplemental services.

This sounds like something I'd be interested in learning more about, but the page itself provides little guidance except for an error: "CRL distributor has an invalid certificate"

What should I be seeing on this page? I can't say I've ever looked here before.


texts: CiviContribute: show contributions without other contact details

texts:
Been using CiviCRM with the CiviContribute extension for a good portion of this year. Would like to allow users to see their contributions from their own logins without actually having access to other details, like the notes tab specifically.

Any ideas?
Thanks!


texts: Restore default "mailing footer" in civicrm WordPress 4.2.4

texts:
Is it possible to restore the default header and footer?

CiviCRM » Administer CiviCRM Headers, Footers, and Automated Messages

I edited the header and footer and now when I try to send a group email, I get this:

This message is missing a required token - {domain.address}: Domain address - displays your organization's postal address.
This message is missing a required token - {action.optOutUrl or action.unsubscribeUrl}: 'Unsubscribe via web page' - creates a link for recipients to unsubscribe from the specific mailing list used to send this message. Alternatively, you can include the 'Unsubscribe via email' token or one of the Opt-out tokens.


texts: How do CiviCRM profiles hook up with Drupal?

texts:
We have been using Drupal and CiviCRM for 5 years or so to edit profiles. Setup via the Administration -> Customise Data and Screens -> Profiles.

It is now saying 'The changes have been saved' and reloads the form with the old data rather than updating the CRM database.

I have been searching the drupal folder in civicrm for a submit hook and anything to test the connection. How does it work?

Drupal 7.41 and Civicrm 4.5.8.


texts: How to set multiple conditional rule on webform registration?

texts:
I am trying to setup an event page on webform with 4 Radio button labeled How many people would like to register - 1, 2 , 3, 4 and 4 contacts field set contact1, contact2, contact3, contact4

What I am trying to achieve, if I select

Radio 1 - Contact1 field set would show
Radio 2 - Contact1 & Contact2 would Show
Radio 3 - Contact1, 2 & 3 show
Radio 4 - all field set should show.

I am just cant get it to work and keep getting this error and cant go past enabling 2 people.

    Conditional errors on page 1:
More than one conditional hides or shows component "Contact2".
More than one conditional hides or shows component "Contact3".

Would anyone know how to achieve this? Thanks


texts: Export Activities associated with CiviCase

texts: We're currently discussing whether it's possible to use the activities recorded in a Case (including the scheduled activities in a timeline), export them into Excel and convert it into a Gantt chart, but I can't see a way to export all activities associated with a Case. When I look at the options in the Civi Reports, it will only export the most recent activity. Would Drupal Views be any use?


texts: How can I change the way price set information is presented on a contribution page?

texts:
Contribution pages showing price set information (i'm using a radio button field with various options to choose from) show the various price option with the label text first, in bold, and then the amount, not in bold, and with a space between the currency symbol and the amount.

I'd like to have the amount first, with no space between currency symbol and figure, followed by the label text.

I'm assuming all this is in a template file somewhere? If so, where should I be looking? Anything else to look our for or take into consideration?


texts:
Hello I using drupal 7 and civicrm 5.6.1

I am trying to use Postcode Lookup for Webform https://github.com/compucorp/webform_civicrm_postcode/blob/master/README.md

But I cannot see the extension after uploading it to the directory and refreshing

I have done the following.

1) Checked the directory it is installed in sites/default/files/civicrm/custom_ext/  and checked the settings upload directory path (custom_ext) and resource url (sites/default/files/civicrm/custom_ext)

2) Cleared the civicrm cache and the drupal cache and pressed refresh (many times)

3) Viewed the extension page via view source to see if it isn't rendering on the page

4) Read the read me to see if there is anything different that I have to do

5) Checked the file permisions - it is the same as the other extensions in the folder.

Any ideas what to check next?

Thanks!


texts:
I decided to remove Civivolunteer. Administer > System Settings > Extensions.  I disabled Civivolunteer and then Uninstall.
Error message: "DB Error: constraint violation"
The Civivolunteer extension cannot be enabled or uninstalled. What can I do?

Here is a paste of PART of the log where the error occurs

Aug 28 15:29:07  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

[code] => -3
[message] => DB Error: constraint violation
[mode] => 16
[debug_info] => DELETE FROM `civicrm_uf_group` WHERE `name` = 'volunteer_sign_up' [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`willycg_civicrm`.`civicrm_uf_join`, CONSTRAINT `FK_civicrm_uf_join_uf_group_id` FOREIGN KEY (`uf_group_id`) REFERENCES `civicrm_uf_group` (`id`))]
[type] => DB_Error
[user_info] => DELETE FROM `civicrm_uf_group` WHERE `name` = 'volunteer_sign_up' [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`willycg_civicrm`.`civicrm_uf_join`, CONSTRAINT `FK_civicrm_uf_join_uf_group_id` FOREIGN KEY (`uf_group_id`) REFERENCES `civicrm_uf_group` (`id`))]
[to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="DELETE FROM `civicrm_uf_group` WHERE `name` = 'volunteer_sign_up' [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`willycg_civicrm`.`civicrm_uf_join`, CONSTRAINT `FK_civicrm_uf_join_uf_group_id` FOREIGN KEY (`uf_group_id`) REFERENCES `civicrm_uf_group` (`id`))]"]

)


texts: Is there any documentation for 'safe' and 'aggressive' merge modes?

texts:
We are investigating the 'Process batch merge' scheduled job in CiviCRM, to automatically batch merge duplicate contacts. This calls api.job.processBatchMerge which seems to take the rule to use as a parameter and also a mode, 'safe' or 'aggressive'.

'Safe' mode skips the merge if there are conflicts (which is probably best for an automated process!)

But how does 'aggressive' mode decide which contact data to overwrite/keep? I couldn't find any documentation about this.


texts: Measure open rates for standard emails from Civi, not from Civimail

texts:
Is it possible to measure open rates and/or click-throughs from a particular scheduled reminder email?

Civimail has well developed functionality for open rates and clickthroughs etc, but we have a use case that calls for people to receive an email from a scheduled reminder at the time when they sign up to a group (the email will be sent as a result of an activity generated when they sign up to the group.)

The people are signing up on paper, so there's no problem with spam nor need for double opt-in. Our volunteers are then going to enter people into a webform and at that point the system will send them an email.

We'd like to measure open rates and/or click-throughs from that email.

Is there any cunning trick to make this possible?

If not we can of course adapt our procedures to send mailshots from CiviMail to people every 4 or 6 hours... but that manual process is an additional complexity.

We can also pull these people into MailChimp and do it from there, but we'd lose quite a bit of data possibilities if we did it that way.

Hence my question.

Thanks for your help.


texts:
using civi 4.6.8

needed a notification sent to a volunteer when they sign up for an event.  setup a scheduled reminder to catch the action.  everything work ok and email was added to the queue in civicrm_action_schedule.

forced the job to execute.

got back

Finished execution of Send Scheduled Reminders with result: Failure, Error message: API (ActionLog, get) does not exist (join the API team and implement it!)

it's telling the truth.  i can't find ActionLog / Get in the API Explorer.


texts: why are non admin users having fatal error when accessing CiviCRM and dashboard doesn't load?

texts:
I have started experiencing some problems with non admin users, i get Fatal error on the logs when non admin users access civicrm example.com/civicrm and dashboard doesn't load for these users.

Admin users do not have this problem and dashboard loads correctly.

  [info] $Fatal Error Details = Array
  (
      [callback] => Array
          (
              [0] => CRM_Core_Error
              [1] => handle
          )

[code] => 0
[message] =>
[mode] => 16
[debug_info] =>
[type] => PEAR_Error
[user_info] =>
[to_string] => [pear_error: message="" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info=""]

[info] $backTrace = #0 ../sites/all/modules/civicrm/CRM/Core/Error.php(235): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::handle(Object(PEAR_Error))
#2 ../sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(PEAR_Error))
#3 ../sites/all/modules/civicrm/packages/PEAR.php(566): PEAR_Error->PEAR_Error("", 0, 16, (Array:2), NULL)
#4 ../sites/all/modules/civicrm/packages/Net/Socket.php(156): PEAR->raiseError("", 0)
#5 ../sites/all/modules/civicrm/packages/HTTP/Request.php(737): Net_Socket->connect("ssl://www.excample.com", 443, NULL, NULL, NULL)
#6 ../sites/all/modules/civicrm/CRM/Utils/System.php(1393): HTTP_Request->sendRequest()
#7 ../sites/all/modules/civicrm/CRM/Core/BAO/Dashboard.php(326): CRM_Utils_System::getServerResponse("https://www.excample.com/civicrm/d$
#8 ../sites/all/modules/civicrm/CRM/Contact/Page/AJAX.php(606): CRM_Core_BAO_Dashboard::getDashletInfo(5)
#9 [internal function](): CRM_Contact_Page_AJAX::dashboard()
#10 ../sites/all/modules/civicrm/CRM/Core/Invoke.php(278): call_user_func((Array:2))
#11 ../sites/all/modules/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:12))
#12 ../sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))

)

I have taken a look at the following posts and seems to not solve my problem as this fatal error only comes from non admin users.
SSL enabled CiviCRM with forever loading dashlets?,

The dashboard does not render

CiviCRM V4.6.10, Drupal 7, PHP 5.6.14-1


texts: I am receiving a warning when I enter CiviCRM which seems to indicate that I have something called "external profile support" set.  Where do I find this option enabled?   I have looked but cannot find it.  I would appreciate an emailed answer if that is possible.


texts: Civi Event: Price Set, Additional Registrants ( Hiding the price set for the additional registrant)

texts:
For the dinner event I need to be able to track the use of the civi discount code so I set up the additional registrant field to effectively count the number of times the discount code is being used and by whom.

Now, the problem is that when I test-drive the registration page the Price set that I have for the event shows up for each of the additional registrants. So when my attendees register and choose to 2 additional registrants and then click to the next page to enter in the additional contact information they might think that they need to enter 1 in the price set for each of their contacts. This would then have my discount code counting all wrong because instead of calculation two people it has calculated four.

This might actually be a additional registrant problem because one participant is going to be paying for their entire group and I want to be able to hide the price set for the additional registrants.


texts: CiviMail and unsubscribing from smart group

texts:
Using CiviCRM 4.5.8: It is my understanding that when an email recipient unsubscribes from a message sent (via CiviMail) to a smart group, then that person will be detached from that smart group and will receive no further messages sent to that same smart group.  For some reason this is not working for me.

Example: I have GroupA defined as the parent of Subgroup1 and Subgroup1. GroupA itself has no members (a listing of GroupA shows each member with a status of "smart"). All three are defined as mailing groups, and a mailing to GroupA goes to all members of Supgroup1 and Subgroup2, as desired.  Each outgoing message contains this HTML code:

To unsubscribe from this mailing list, click here.

When a recipient in Subgroup2 clicks on this link they send an email message to a system-generated address, which is processed (normally, apparently) by the CiviBounces cron script.  In return they get this odd message:

You have been un-subscribed from the following groups: {unsubscribe.group}.

That "{unsubscribe.group}" above is exactly what they see.  Normally I'd expect to see "GroupA" (or perhaps "Subgroup2") here, but it's just the raw token name.

The cron job doesn't pitch an error, and the recipient's database record remains unchanged.  Without manual intervention they will get subsequent messages to GroupA, which does not endear them to my organization.

What would cause this behavior (and how to set things right)?


texts: Use CiviCRM tokens in Drupal welcome e-mails?

texts:
I have a site set up using a Drupal rule to create a new user account when a new membership is created.

The new account creation triggers a Drupal welcome e-mail to the user, as defined in the Drupal Account Settings, so it's populated using Drupal variables, e.g. 'Dear [user:name]'.

I'm using e-mail addresses for Drupal usernames, but I don't especially want our welcome e-mails to be addressed using only e-mail address. Is there a way to use CiviCRM tokens in Drupal welcome e-mails, so I can address them by name from the contact record?

Even better, most of our individual users inherit their membership from an organisation. If the above is possible, is there also way to use a CiviCRM token to refer to the primary membership? So, for example, I could write something along the lines of, 'An account has been created for you because of your volunteer role with [parent organisation]'?


texts:
On CiviCRM 4.7.22 Drupal 7, I'm missing the "New Organization" button under Current Employer. I can't seem to find figure out whether this is a settings problem or not. A previous version of CiviCRM had it.

And I haven't made any changes to the contact types or relationships.

I also checked the reserved profiles. No changes on "new_organization".


texts:
Using CiviCRM 4.6.9 on Drupal.

We've never enabled automatic updating of membership status, but now it's time.

How to do this?  I remembered that there is a Scheduled Job for this, but in looking at the description it says that it's obsolete as of v 4.3.

It seems this functionality has migrated over to Scheduled Reminders, however we had not planned on doing membership reminders automatically.  Our membership director is very comfortable sticking with her own mass emailing of membership reminders on her own schedule.

Suggestions?


texts: How to setup bounced processing on CiviCRM for a Gsuite account?

texts:
I am trying to setup Gsuite as bounce processing for CiviCRM using this guide https://civicrm.org/blog/dahndy/leveraging-civicrm-email-to-activity-processing-in-gmail

But keep getting the following message when schedule job is ran.  Any idea how to fix it please?

One thing in the log, it says "webadmin@imap.gmail.com" but it should have said "webadmin@our.domain" as per my sessings below, is that right?

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

Full message:
Finished execution of Fetch Bounces with result: Failure, Error message: Could not connect to MailStore for webadmin@imap.gmail.com
Error message:

An error occured while sending or receiving mail. Failed to connect to the server: imap.gmail.com:993.


texts:
I'm writing an extension with a quickform form. It takes _GET parameters to set itself up. I've done this in buildQuickForm (not sure when I'd choose to use preProcess instead?)
I've got the quickform to display and to be processed ok, but once it's processed ok I'd just like to display a "ta very much, love" message to confirm it's all finished.
I'm using CRM_Core_Session::setStatus() to display the message.
The problem is that after processing it seems to issue an HTTP redirect to which then goes back to the build phase, which then gives errors because there's no _GET data this time.
I've tried (to no avail)

using $this->set('isCompleted', TRUE) in the postProcess() function and then checking for that using $this->get('isCompleted') in the buildQuickForm() function, but it get unset.

using CRM_Core_Session::pushUserContext('civicrm/myform?isCompleted=1') thinking that this might cause a redirect to that URL. It doesn't.

setting a property on the form in post, but it's not there when the form is re-fetched.

using CRM_Utils_System::redirect() to redirect to civicrm/myform/?isCompleted=1, which does redirect, but not until the build has re-run and generated errors on the session.


texts: Why are my simple donate pages throwing an error?

texts:
I am using latest Simple Donate on D7 with Civicrm 4.7.29. I get this error when I go to the contribution page configured for Simple Donate:

Warning: implode(): Invalid arguments passed in CRM_SimpleDonate_Page_SimpleDonationPage->browse() (line 71 of /home/lifechallengesem/public_html/data/sites/default/files/civicrm/ext/com.webaccessglobal.simpledonate-2.0/CRM/SimpleDonate/Page/SimpleDonationPage.php).

any help troublshooting would be greatly appreciated!


texts: Google Geocoding not working on fresh install of CiviCRM 5.4.0. and Drupal 7

texts:
I can't get geocoding to work on a fresh install. Manually entering the lat,long works.
I've followed the instructions and steps one by one.
I configured all settings I found referenced on the instructions:

Address Preferences,
Geocoding Settings,
Job Settings.

I confirmed that map works (using default sample data, the contacts come with geolocation info). The map icon is shown and the map is displayed when the icon is clicked on.
I create a new contact or delete geolocation data from existing contacts. When I execute the geocoding job, the result is that the contacts addresses are parsed but none is geocoded:
Full message:
Finished execution of Geocode and Parse Addresses with result: Success (Addresses
Evaluated: 2
Addresses Geocoded: 0
Street Addresses Parsed: 2
)

When I check on the Google Cloud Metrics console I can see that all my geocoding requests generated an error. However I can't find any log with details and the request is generated by CiviCRM.
Am I misssing some format for the address, field or step???
I've tried on 2 clean install sites and can't get it to work.
Help is appreciated.

See screen captures below:
Address Preferences:

Geocoding Settings:

Default Contact with Geolocation info, showing map icon:

Geocoding Job Settings

Google Cloud API report:


texts:
I see this question was asked a few years ago and just wondering if there's any answers to it now.
When entering text into various blocks in Mosaico, if we align the text to justify it appears to work on screen and in the html test preview but when it arrives in the inbox it has all changed back to left align.
Anyone else had this problem or got any ideas/workarounds?
Thanks.


texts: How to translate the "Confirm Contribution" button on Contribution pages

texts:
I have a multilingual CiviCRM install with 3 languages.
"Multiple Languages Support" is activated, and the fields with translation icon next to them have all been translated.

But I also need to translate the button "Confirm Contribution" at the bottom of the Contribution pages.
How can I achieve this?

Since this needs to be translated to 3 languages, I can not use Word Replacements (word replacements is not multilingual, so it uses the same replacement in all languages)


texts: Sharing data betweeen Multiple Databases

texts:
We have a main organisation with civi multi-site build but finding it a little complex in terms of granting permissions for various sub departments. Thee are also clashes over mailings and issues with GDPR over accessing data.

Is it possible/feasable to have a main civi build and then import data from other 'seperate' civi builds through the API...?

That way each sub department can have their own database and (Drupal) website and information for 'all' the departments will also be stored on the main database. The only issue I see is the contact ID and my thought would be that this is listed as the 'external ID' on the sub (departmnent) builds.

Any thoughts on this or any suggested alternatives.

Many thanbks Robbie


texts: Is there a way automatically get sort name and greetings to be correct for households?

texts:
If you want have individuals and households to show up in alphabetical order by last name you need to enter the hh like Smith, Jane and Joe.  Fine except now the greetings will be Dear Smith, Jane and Joe and the addressee will be Smith, Jane and Joe.  So then one has to enter custom greetings and addressee.

My users are bad at that.  Every time we send out an email or postal thing, I find I have to wade through the data and fix a bunch of them.

If you enter the HH as Jane and Joe Smith, the greetings are better; though, we'd prefer Dear Jane and Joe to Dear Jane and Joe Smith.  At least if you miss one you don't end up addressing something odd.  But then the sort is not by last name.

Maybe some fancy parsing with smarty in the greeting.


texts:
I've just found out that the Membership Dashboard - specifically the summary table at the top of that page - is not visible if you don't have the permission 'CiviCRM: view all contacts'. Is there any way around this?

We've just implemented ACLs on a site and the staff member looking after memberships would like the dashboard back...


texts: Price Set / Pledge Conflict on WordPress

texts:
I am running into an interesting issue, both on my local WordPress install and on the CiviCRM WordPress demo.

I have created a price set for contributions, and then I created a contribution page. On that page, after selecting my payment processor and price set, I am unable to get the pledge settings to save. I can check the "Pledges" box, and enter the relevant settings, (ie. selected pledge frequencies, and reminder email settings), but those settings are lost every time I click save.

I've checked to ensure that it is not an issue with my payment processor, and I have narrowed it down to the use of a price set versus the fixed contribution settings.

Has anyone else run into this issue, and does anyone have any advice? I would like to be able to use the price set, but it seems like for the immediate future, entering my donation prices directly into the form for the contribution page seems the most practical way forward. (**as a side note, I can use price sets on contribution pages without allowing pledges with no issues.) If I go with the static fixed contribution settings, what kind of flexibility am I giving up?


texts: 'DB Error: no such field' for all (free) event registrations

texts:
Using CiviCRM 5.20.2 on Drupal 7.69.

Having a new error whenever someone tries to register for an event through CiviEvent on our website. This happens for all events: private or public; those with custom fields and those with no custom fields; with confirmation screens turned on or off; with thank you emails turned on or off. The event is free/no payment processing.

The user sees this screen:

The registration does not pull through on the back-end either.

This is the error message in the error log:

$Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => handle ) [code] => -19 [message] => DB Error: no
such field [mode] => 16 [debug_info] => INSERT INTO
civicrm_contact_push_notification_messages (contact_id , data ,
message , entity_table , entity_id ) VALUES ( 6820 , 'Array' ,
'%display_name has created participant.' , 'Participant' , 2699 )
[nativecode=1054 ** Unknown column 'data' in 'field list'] [type] =>
DB_Error [user_info] => INSERT INTO
civicrm_contact_push_notification_messages (contact_id , data ,
message , entity_table , entity_id ) VALUES ( 6820 , 'Array' ,
'%display_name has created participant.' , 'Participant' , 2699 )
[nativecode=1054 ** Unknown column 'data' in 'field list'] [to_string]
=> [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO
civicrm_contact_push_notification_messages (contact_id , data ,
message , entity_table , entity_id ) VALUES ( 6820 , 'Array' ,
'%display_name has created participant.' , 'Participant' , 2699 )
[nativecode=1054 ** Unknown column 'data' in 'field list']"] )

Any clue how to fix this?


texts: How do I set the value of external_id to be the same as a custom field?

texts:
Running Civi 4.7.13 with Drupal 7.52. I want to set the value of external_id in the Contacts table to be the same value as a custom field (using the API explorer, it seems this field is called custom_32). When I try to set the value from the SQL command line, nothing happens. I'm new with SQL and have little experience. I've tried the following. What do I need to change to get it to work? Is there an example I can follow (using the SQL command line or even API explorer)

SELECT civicrm
UPDATE civicrm_contact c
SET c.external_identifier = c.custom_32
WHERE c.custom_32 is not null

It appears as though custom_32 is not part of the Contact table.


texts: System Status: Notice 5.1.0 After Upgrade

texts:
Need a bit of help just upgraded to the latest version 5.1.0 however now when I click in on the "System Status: Notice" link in the bottom footer I get an error.

Can anyone help me fix this, please?

Error calling get API for UFGroup (aka Profiles)Array ( [error_code] => no such field [sql] => SELECT a.id as id, a.is_active as is_active, a.group_type as group_type, a.title as title, a.frontend_title as frontend_title, a.description as description, a.help_pre as help_pre, a.help_post as help_post, a.limit_listings_group_id as limit_listings_group_id, a.post_URL as post_URL, a.add_to_group_id as add_to_group_id, a.add_captcha as add_captcha, a.is_map as is_map, a.is_edit_link as is_edit_link, a.is_uf_link as is_uf_link, a.is_update_dupe as is_update_dupe, a.cancel_URL as cancel_URL, a.is_cms_user as is_cms_user, a.notify as notify, a.is_reserved as is_reserved, a.name as name, a.created_id as created_id, a.created_date as created_date, a.is_proximity_search as is_proximity_search, a.cancel_button_text as cancel_button_text, a.submit_button_text as submit_button_text FROM civicrm_uf_group a WHERE (a.is_active = "1") LIMIT 100 OFFSET 0 [nativecode=1054 ** Unknown column 'a.frontend_title' in 'field list'] [tip] => add debug=1 to your API call to have more info about the error [is_error] => 1 [error_message] => DB Error: no such field [debug_information] => SELECT a.id as id, a.is_active as is_active, a.group_type as group_type, a.title as title, a.frontend_title as frontend_title, a.description as description, a.help_pre as help_pre, a.help_post as help_post, a.limit_listings_group_id as limit_listings_group_id, a.post_URL as post_URL, a.add_to_group_id as add_to_group_id, a.add_captcha as add_captcha, a.is_map as is_map, a.is_edit_link as is_edit_link, a.is_uf_link as is_uf_link, a.is_update_dupe as is_update_dupe, a.cancel_URL as cancel_URL, a.is_cms_user as is_cms_user, a.notify as notify, a.is_reserved as is_reserved, a.name as name, a.created_id as created_id, a.created_date as created_date, a.is_proximity_search as is_proximity_search, a.cancel_button_text as cancel_button_text, a.submit_button_text as submit_button_text FROM civicrm_uf_group a WHERE (a.is_active = "1") LIMIT 100 OFFSET 0 [nativecode=1054 ** Unknown column 'a.frontend_title' in 'field list'] )


texts: How to attach a .pdf certificate to an email?

texts:
I have an insurance certificate that I want to send to specific member, manually or automatically as a .pdf attachment. How can I do this? My question seems stupid but I don't find the way.

With Search contacts, I can find the contact I've identified previously and within "Action:" I can Print/Merge documents but then I download a .pdf when I want to send it instead. I can also send an email using my HTML template with the right Fuzion tokens but it generates no .pdf attachment. So is there a way to combine both?

I saw these posts: how-can-i-attach-a-pdf-certificate-for-a-membership-payment but it's from 2015 and didn't seem successful and print-pdf-and-send-to-contact. I'm wondering if there is a simple way to get it done with CiviCRM 5.13.4.

Have I missed something really obvious?


texts: Repeating Payments with Authorize.net Problem

texts:
I've set up repeating payments (CiviCRM 5.21 with Drupal 7.69) with Authorize.net for a client.

In Civi, the transaction hangs at "Pending".

At Auth.net, everything looks good, the initial payment has been processed with a date set for the next transaction.

Also note that one-off transactions from the site process perfectly with the transactions showing as "completed" in CiviCRM.

Not sure on how to troubleshoot this.

I thought that @Eileen's notification log extention might help. However, the system log table is empty.

I'm not sure what the next step is for troubleshooting.


texts:
I get this error when testing donations, the result is the same in test and live environments. "Error Payment approval failed with message :Security error Security header is not valid" I searched every forum out there and tried every solution I could find with the same result every time.

I checked the name, key, and secret 1000 times and then reset it and again tried 100 times.

I tried using the login name as suggested on a forum and that did not help.

I removed the payment option and re-added it.

I tried the test variables in the live settings via your forum and no go...

I tried this and it came back ok so I assume paypal works (Info changed 4 security) "https://api-3t.paypal.com/nvp?&user=info_api1.rockymountainmustang.org&pwd=JPJUK7LxxxxxYLR&signature=A.MRLXfmAocfnxxxxxRHc67jlS52IYYS7LRw&version=70.0&METHOD=SetExpressCheckout&RETURNURL=http://www.paypal.com/test.php&CANCELURL=http://www.paypal.com/test.php&PAYMENTACTION=Sale&AMT=50&CURRENCYCODE=USD"


texts: Webform created for case activity and multiple case types

texts:
Drupal 7.39
Webform Civi Integration version 7.x-4.11.

Just noticed that for contacts with multiple open case types, a new activity submitted via a webform does not always go to the correct case type.

In the Civi Webform settings under Activities, File on Case section I have Test Case as the Case Type, open and resolved selected under Case Status and contact 2 selected for Case Client.

Nothing selected under the Case section of the webform.  In the past, I didn't add anything here for an activity on an already open case.  Should I be using this section if the case is already open or is this section just for changing case roles, status, etc.?

One case client has two open cases, an open Test Case and an open Other Case Type.

When I click on the link to add a New Test Case Activity, the correct webform comes up with the correct client name.  Once submitted however, the activity is filed under Other Case Type and not Test Case.

If I use the same form for someone with only a Test Case, the activity is created in the correct case.

I tried with enabling the Case processing section, but still encounter the same error.

I thought I had this working before, but I could be wrong.


texts: Mandatory volunteer contribution to maintain membership status. How would you implement?

texts:
Volunteer-based cooperatives often have requirements for its members to maintain an 'Active' status in order to be eligible to vote in meetings or elections.

For example, my cooperative requires:

A) at least 24 hours of volunteer service in the financial year when applying for membership.

B) at least 24 hours of volunteer service in subsequent financial years to maintain an 'Active' status.

Typically, individuals declare on a paper form their annual volunteer contribution. It would be ideal to scan/upload PDF documents into CiviCRM annually and simply tick a checkbox that the member has complied with the requirement of active membership.

I can see multiple ways to implement this but does anyone with CiviCRM experience have a suggestion on how they would implement this?

Which Module would you use or customise?

Cheers,

Troy


texts:
As the installer gave us a warning that we maybe will have issues with http Redirect, so we did a Manual Installation of civibooking.

Now we cannot find any indicator that the process really was successfull and we cannot use it. What went wrong?

If we do it a 2nd time we get the DB-Information "already exists".

Please help!

running plesk 12.5
php 5.5.9
MySQL 5.5.53
and ignoring SSL for the Moment.

BR
Jochen


texts: Can you use Mosaico to create message templates

texts: Is this a thing that is possible? In other words to create a template in Mosaico (that is, the Mosaico CiviCRM extension) and to store it for use in User driven message templates such as emails?


texts:
WE had some sort of corruption on our CiviCRM db and somehow lost data in different fields

One of these was a custom field containing uploaded files

THese files are still listed in the civicrm_file table and the file ids are also associated with the civicrm entity in civicrm_entity_file.

BUt they do not show up in the contact profile.

I tried adding a new file to a contact and this shows up. I can't see any difference between the record for the new file and the one for the old file.

Any ideas how to restore these? there are 756 files, so it would be a lot of work to manually do it.


texts: Why can users no longer update their own billing/credit card details in CiviCRM? Using iATS Payments

texts:
Payment processor objects can implement the CiviCRM Core method updateSubscriptionBillingInfo to implement payment-processor specific code to update card-on-file type information with the payment processor service, for recurring payments.

iATS Payments Extension did/does just that and thus allowed people to update their own billing/credit card details for recurring contributions. Why is this no longer working?


texts: on logging into civi we are getting the following error message, can anyone direct me as to a solution?

texts:
Initialization Error
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => simpleHandler
)
[code] => -24
[message] => DB Error: connect failed
[mode] => 16
[debug_info] =>  [nativecode=Access denied for user 'pascrm49_drupa86'@'localhost' to database 'pascrm49_civicrm']
[type] => DB_Error
[user_info] =>  [nativecode=Access denied for user 'pascrm49_drupa86'@'localhost' to database 'pascrm49_civicrm']
[to_string] => [db_error: message="DB Error: connect failed" code=-24 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info=" [nativecode=Access denied for user 'pascrm49_drupa86'@'localhost' to database 'pascrm49_civicrm']"]

)
Initialization Error
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => simpleHandler
)
[code] => -24
[message] => DB Error: connect failed
[mode] => 16
[debug_info] =>  [nativecode=Access denied for user 'pascrm49_drupa86'@'localhost' to database 'pascrm49_civicrm']
[type] => DB_Error
[user_info] =>  [nativecode=Access denied for user 'pascrm49_drupa86'@'localhost' to database 'pascrm49_civicrm']
[to_string] => [db_error: message="DB Error: connect failed" code=-24 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info=" [nativecode=Access denied for user 'pascrm49_drupa86'@'localhost' to database 'pascrm49_civicrm']"]

)


texts:
Drupal gives me only one choice in its listing of CiviCRM permissions to assign to a Drupal role related to the editing of CiviEvents, namely "Edit all events". I'm nervous assigning this permission and would rather restrict the permission to "Edit own events."

Other CiviCRM functions show the normal sequence of permissions which include ones like "Edit own manual batches." Is it safe to assign "Edit all events" to non-admin users?


texts: Installing extensions with civicrm-buildkit

texts:
When using civicrm-buildkit, it automatically configures an extension directory with something like:

/home/jon/local/civicrm-buildkit/build/d46/sites/default/ext

However, there are no extensions in that directory, though there are clearly extensions installed in the built site.  Moreover, extensions added to the extensions directory don't appear.  What's the preferred method to get extensions installed on a site built with civicrm-buildkit?


texts:
I am new to CiviCRM environment.

My company asked me if I could modify the website to not have so much blank space (white space) on the sides.  They want more content on the screen.

Please excuse my terminology.  I am still learning the CRM terminology via Market Research.

Where could I find the CSS to modify this portion?

Is there a standard directory set up for CiviCRM?

Is it best practice to set a new CiviCRM for each project?

Thank you in advance.

Laurie


texts: Searching for users by Total Contributions (CiviContribute, Drupal7)

texts:
I process donations on a third party site and would like to import these records to CiviContribute.

I've imported each donation as a separate contribution, e.g. Peter has made a donation on 14/01/19 for $500.00 and on 15/07/18 for $800.00. This is so I can track how many donations are made on average, whether donation sizes are increasing for donors who make multiple donations, etc.

I'd like to add all donors who have donated over $1000.00 in total, to a smart group so they can receive tailored email content. However when I do searches, it only shows users based on whether they have donated $1000.00 in one individual donation, not by their lifetime donations.

Does anyone know how I can do this?


texts: Views List Needs to be re-displayed to have a Full Listing

texts:
I have built a list of Participants, using Views, and defined some "exposed" filters (some of them based upon custom fields).

When I display this View, only a fiew participants are displayed, though all filters are set to "all".

I need to re-display (click the Display button) to get the full list (without changing anything).

Is this a bug, or did I miss something ? Is there a way to get around that ?


texts: Multiple Contact Registration for events

texts:
I'm sure I'm off in my configuration but not sure what.  I've set up an event where a registrant can register multiple participants under the same address. For this event, a parent would sign up and then each of  their children coming to the event would have to be registered

In the set-up, I have the following profiles for On-line Registration:

"Include Profile Top of Page"   Parents Profile
"Profile for Additional Participants"  Youth Profile

I do have the option for "Same e-mail address" selected

Here is the problem...when a user sign's up and uses the same e-mail address, only the first contact is used so I'm seeing that first user registering each time.

Here is the actual scenario.  Parent 1 and Parent 2 have to separate e-mails. Parent 1 registers three children under his e-mail.

Parent 1: parent1@email
Parent 2: parent2@email
Child 1: parent1@email
Child 2: parent1@email
Child 3: parent1@email

When registered in this manner, Parent 1, Parent 2, and Child 1 get confirmation e-mails. Child 2 and 3 get a confirmation e-mail addressed to Child 1.

When I view the participants for the event, I see:

Parent1
Parent2
Child1
Child1
Child1

How can I correct this issue as it's important to have the name of each participant that is joining us.


texts: webform-civicrm error when creating CiviCRM custom data group

texts:
When creating (or saving) a custom data group or (field)set the following error pops up:

Notice: Undefined offset: 0 in webform_civicrm_civicrm_postSave_civicrm_custom_group() (line 436 of /home/unidosnow/www/www/sites/all/modules/webform_civicrm/webform_civicrm.module)

The code throwing this:

/**
 * Implements hook_civicrm_postSave_tableName().
 *
 * Handles adding/editing a custom group.
 *
 * @param CRM_Core_DAO_CustomGroup $dao
 */
function webform_civicrm_civicrm_postSave_civicrm_custom_group($dao) {
  module_load_include('inc', 'webform', 'includes/webform.components');

  // get all fieldsets with custom group ID
  $customGroupId = $dao->id;
  $dbResource = db_query("SELECT * FROM {webform_component} WHERE type ='fieldset' "
          . "AND form_key LIKE '%cg{$customGroupId}_fieldset'");
  $fieldsets = $dbResource->fetchAll(PDO::FETCH_ASSOC);

  // check if dao fields have been fetched
  if (!$dao->title) {
    $dao->find(TRUE);
  }

  // run only if the title of the custom group has changed in civicrm
  -->>  if ($fieldsets[0]['name'] != $dao->title) {  <<-- Exception here
    foreach ($fieldsets as $field_info) {
      $component = array();
      $component['name'] = $dao->title;
      $component['type'] = $field_info['type'];
      $component['form_key'] = $field_info['form_key'];
      $component['weight'] = $field_info['weight'];
      $component['nid'] = $field_info['nid'];
      $component['cid'] = $field_info['cid'];
      $component['pid'] = $field_info['pid'];
      webform_component_update($component);
    }
  }
}

The custom set creates successfully, haven't yet tried to use it in a webform.  Before the 4/25 update I had created custom data sets without this error.  Don't have record of the versions I was using at the time, the current versions that show the problem are CiviCRM 4.7.29, Drupal Core 7.59, webform-civicrm 4.20, and webform 4.17.


texts: Is there a customized realtor sales and contact management system in civi

texts: Is there a customized realtor sales and property management and contact prospecting system available for CiviCRM, eg through an extension or set of modules integrating with Drupal?


texts: After moving my Joomla-based CiviCRM site to a new server that included an upgrade to Joomla 3.8.2 on PHP 7.0 and CiviCRM 4.7.29, CiviVolunteer stopped working.  I eventually uninstalled CiviVolunteer and have attempted multiple times to install the latest version (4.7.21-2.2.3). I have tried every relevant suggestion found on the web and here on StackExchange including that from Nicolas at Cividesk involving SQL scripts to clean up left-over garbage in the database.  Additionally, I have sifted through the database to remove anything that remotely looked like a potential conflict. The installation failure mode is a blank screen. When I navigate to the previous page, I see many messages like those shown in the Nicolas post.  Back Trace information doesn't seem to show anything useful.  Any help would be appreciated at this point.


texts: Civi 5.9 - DB Error: no such table / cannot disable logging

texts:
Drupal 6 / Civi 5.9 / Aegir

I deleted my log_civicrm_... tables and now am getting a "DB Error: no such table" across a range of CiviCRM actions including adding contacts, running cron etc.

Logging is switched on and I cannot disable it via Administer > System Settings >Misc (...) > Logging).

Is there another way? Is there a table or a file I can edit  or a command I can run to to disable logging?


texts: Change quick search ACL from "Access CiviCRM" to "Edit all Contacts"

texts:
CiviCRM 4.6 - client requirements - how to go about changing which ACL the Menu (including Quick Search) is tied to?

The Menu appears to be tied to Access CiviCRM - but we'd like to change this to "Edit all Contacts".

Ideally, we'd just like to hide the Quick Search - "Access CiviCRM" appears to grant all access to contacts, even if "view" and "edit" all contacts is not expressly assigned.


texts: how to trigger a Drupal rule on CiviMember Roles Sync?

texts:
We want to trigger a Drupal rule to display a message "Your membership has expired" when a user logs on.

We have CiviMember Roles Sync set to "Synchronize whenever a user logs in or logs out. This action is performed only on the user logging in or out."

It happily removes the role "Current Member" when the user logs in, but the user is not informed of this...... We have D7, CiviCRM 4.6.26, Drupal Rules module, civicrm_rules. I've messed about with many Rules settings, but can't get the rule to trigger on User login.

Do you know what I'm missing? Thanks


texts: Record a new contribution to several contacts selected, for example, using search contacts by group

texts:
is possible to record a new contribution to several contacts selected, for example, using search contacts by group?
I don't think so, but I'm surprised by it. The closer approach is import CSV data or use batch process, but the first is not the easiest way for non-tech staff and the second is not suitable for big groups of contacts.


texts: Check number and date fields do not appear when manually entering contributions

texts:
Since upgrading to version 4.7.27 the boxes for entering check number and date do not appear when you enter a contribution in the back end with a payment type of check.  It used to be that once you selected payment type check, the options to enter this information would appear.  They don't anymore.

Thanks for any help anyone can provide!

Leslie


texts: Why Are My Event Reminders Not Being Sent?

texts:
I should have received an event reminder I had scheduled to go out today, but didn't.

I have confirmed that the email was saved under the "schedule reminders" tab of the event.

I did notice that it didn't appear on the scheduled mailings here - /civicrm/mailing/browse/scheduled (but I'm still new to civi so not sure if they're supposed to show there or not).

I don't think I have configured everything for bulk mailing properly yet, but some emails do go out (like registration or membership confirmations).

Drupal 7.38
civiCRM 4.4.15


texts: first CiviCRM request of each session takes 4 minutes, afterwards works fine

texts:
I have an issue where the first CiviCRM request of any session takes 4 minutes to load.  This can be a request for the dashboard, or an administrative screen, it doesn't matter.  There are no errors on screen and no errors appearing in the CiviCRM runtime logs. The first pageload simply takes four minutes, then everything works fine -- until the user logs out, and logs in again. Then the first request takes another 4 minutes.

I've been trying to research this and have come across several other questions that are relevant but don't exactly match my situation (Slow to open at first daily use, https://civicrm.stackexchange.com/questions/12886/civicrm-dashboard-hangs-for-5-minutes?rq=1,https://civicrm.stackexchange.com/questions/14343/civicrm-dashboard-hangs-for-5-minutes-part-2?noredirect=1&lq=1)

Based on info in the many answers, I've discovered the following:

removing all dashlets/reports from the dashboard doesn't improve speed.  Dashboard still takes 4 minutes to load -- but so do the other requests (except, strangely, for searches, which load right up)
hosting provider has confirmed we don't have a NAT Fire setup and that internal requests should be working normally
database doesn't seem to be the issue because 1) it's not maxed out, and 2) 2 concurrent sessions making the same requests one after the other exhibit the same behavior

I'm pretty sure this is an environment problem, because I have two CiviCRM installs on the same server which are exhibiting the same behavior (two different versions: 4.7.24 and 4.7.29). Clones of these environments do not have this problem on my local test servers.

It smells like a timeout, but I just can't for the life of me figure out where to start looking for what is timing out, and why only on the FIRST request of a session!

Seen in two installs of CiviCRM on the same server:

1st: Joomla 3.6.5, CiviCRM 4.7.24, PHP 5.6
2nd: Joomla 2.5.28, CiviCRM 4.7.29, PHP 5.6


texts: CiviCrm will not install on Joomla 3.5.0

texts:
Installation fails with the following error using Joomla 3.5.0:

0 Call to undefined function dl()

Installation succeeds when using Joomla 3.4.8

Any help would be appreciated.


texts: Change Receipt Email Title: Template, Localisation File or Somewhere Else?

texts:
We have a different title for the (pay later) offline receipt contribution email (civiContribute). The first email with the data necessary to make the payment  has a title saying something and the payment confirmation email (sent afterwards) title says something else. I do remember this having been changed by us. However I cannot remember or find where. We would like to change the first email title again, in order to say something else.

I've checked the system workflow message templates and the localisation files at transifex and the change does not seem to have been done there. Is there a translation file for tokens? And if so, where can it be found?

Thank you.


texts: How to disconnect civi contact record from Drupal user

texts:
I created a contact record for some testing using the site admin email address which is associated to the corresponding Drupal user account (user 1).

However it's now causing some problems with certain emails that go out, so I want to delete the contact record but I get an error message that I can't delete myself.

Can I / how do I break the connection between the two so I can safely delete the contact record?


texts: After CiviCRM 4.7 upgrade, CRM.$ Not A Function Errors

texts: After upgrading to CiviCRM 4.7, several CiviCRM related pages/functions on my site are not working and reporting errors related to CRM.$ not being defined as a function, but I can't find where it should be originally defined. Jquery appears to be loading and working okay. Also, when I access the 'CiviCRM » Administer CiviCRM » System Settings » Directories' page, only the core menu is displayed without any css formatting. None of the directories options are displayed so I can't verify/change them. Three, ReferenceError: CRM is not defined errors are reported for the page.


texts: What is your CiviMail throughput/sending speed with sparkpost?

texts:
We've just started using sparkpost to deliver our email, the sparkpost control panel provides some really nice stats and insight into mailing performance as well as how your emails are being treated by various ISP's.
I'm keen to find out what others are seeing in terms of sending speed with Sparkpost.  We're currently getting roughly 20,000 emails/hour but looking to increase this to 100,000, which is one of the main reasons we switch to sparkpost.

I'm also keen to find out what your civimail settings look like here: civicrm/admin/mail?reset=1

Thanks!
Peter


texts: Is it possible to integrate Mandrill with CiviCRM via their SMTP, or do I need to set up API via extension?


texts: How do I configure Webform and CiviCRM for event registration including optional donation

texts: When setting up an Event Registration plus optional donation using Drupal's webform/Civi integration module, is it better to set the Contribution Page to Donation or Event Fee?


texts: Events - Registration Confirmation and Receipt (on-line) is not sending to anonymous users

texts: I have set up an event with webform/civievent and the registration confirmation & receipt is not sending to anonymous sign-ups. While logged in and signing up it will email me (if I am the sign-up), but for anonymous users it won't. I have the send receipt box ticked off in both the contribution page and the event itself. The payment is going through and the participant is being registered correctly, the receipt will just not auto-send. I am using Drupal 7, CiviCRM 5.3.1, and webform version 7.x-4.17.


texts: How should I add sign up forms into 3rd party sites?

texts:
Our install is on Joomla, but Civi newsletter signup forms are needed also on other sites. They use everything from manual HTML (etc.) to other CMS platforms. How can I add group sign up forms to them?

The Civi book suggests using profiles and they do have a HTML generator. However the code it produces both doesn't work and the generator itself is not maintained (according to the core team), so it appears there is no out-of-the-box solution for integration into other hosts since 4.5.

What have you used, done in such situations? Please be explicit.


texts:
I'm trying to test CiviCRM to see if it'll be right for our organization, but try as I might, I just can't get contact searches (either through the quicksearch or profile -> frontend) to return any results. In fact, they just hang, and after a great while (20+ minutes?) will finally timeout.

I've removed all options from search settings, tried appending "force=1" to URLs, turned off SEF entirely, played with Joomla menu link types, all to no avail. The profile search page will load fine, but entering any (or no) data will cause a total hang and never returns. Similarly, hitting "Back to listings" from a contact view, actually clicking on any data in contact view, or running a quick contact search in administration backend all result in a load forever loop.

My error logs make mention of some client denied access errors, so I made my htaccess file allow all, but that didn't seem to have any effect (other than stopping the errors).

Does anyone happen to have any other ideas?


texts: newly installed civi - 'Organization address and contact info', page frozen cannot edit

texts:
I just installed CiviCRM 4.6.31 then also tested 4.7 as well on drupal 7 with inmotionhosting.
PROBLEM: On my main site admin pages 'civicrm home' 'config checklist'->Organization Address and Contact Info page does nothing, frozen.  This happens on my dev machine and my server for my main site.  On both, I install civicrm.  I get the green light saying everything is ready to install.  I install and immediately find I cannot edit the Org address and contact info.  I get no errors even if I turn on debug etc... I am not really sure where to look for errors.  To test further I then installed fresh drupal 7 and added no content then added civicrm on my dev system and my server. These work correctly... So it is not the systems.  I do not really want to have to rebuild my website...  The testing really should pre tell me if something will conflict.  I spent a lot of time on this and now consider this a bug.  I am willing to go to super levels of cooperation with civi developers should they be interested in why this will not install correctly on a seemingly functional website.

I thought this might have been because it was setup as a multisite but testing proved that incorrect..  I am willing to assist with understanding this.


texts: (Event reminder) Exclude Participant who registered after the event!

texts:
In some occasions we had some event participants who just turned up on the events without registering. A schedule reminder is already in place for registered participant, day before the event.

Now for those who registered after the event they also receives an email after. Is there a way to excluded those participants?


texts: Has anyone figured out how to deal with "dovecot" email handling on Siteground?

texts:
I noticed a post in 2018 about my same issue. I am using siteground with "Localdir" (the other posting used SMTP) because our email blasts are small volumes. The emails go out ok, but the civicrm email reports can't find bounces, and clickthroughs ? A siteground support person spent 2 hours "chatting" online trying to help me, but no success. Siteground uses "dovecot" email and all civicrm emails create folder-level addresses like ".bounces.ignored" and "bounces.processed" with three folders under each - "cur, new, tmp". Not sure how to fix/patch this to work ?
I am using drupal 7.69 with civicrm 5.22.


texts: Backend Registrations face group-based pricing (extension) selections

texts:
https://github.com/zengenuity/civicrm_groupprice/issues/7

Does anyone have a creative work-around or fix for this? Basically, when we make a back-end registration, we want to see all price set fields/options, regardless of the group-based pricing. The staff member doing the registrations, as it currently stands, only sees price sets based on the groups they may or may not be a part of.

CiviCRM 4.7.x (sigh:I know)

It should be working, but isn't. The user has 'Administer CiviCRM' permission assigned to their role.

 // If the user is an admin, just put a message next to the "hidden" options.
  // Otherwise, really hide them.
  if ($hide) {
    if ($isAdmin) {
      $amount[$amount_id]['options'][$priceOption['id']]['label'] .= ' (visible by admin access)';
    }
    else {
      $removed = $amount[$amount_id]['options'][$priceOption['id']];
      unset($amount[$amount_id]['options'][$priceOption['id']]);
      if ($removed['is_default'] && !empty($amount[$amount_id]['options'])) {
        $amount[$amount_id]['options'][reset(array_keys($amount[$amount_id]['options']))]['is_default'] = 1;
      }
    }
  }


texts:
We are using Civi 4.7.22 on Wordpress 4.8.22

We have an upcoming three day event with several price options.  Our full-price is $189.00 and we want to give members of our organization a $60.00 discount when they purchase the full-price ticket to the event. We do not want to give a discount to the lower priced tickets, whether the person is a member or not.

So far when using cividiscount, the discount price is applied to the entire price list and not just the full price.  I don't yet see an option for controlling this.  Does anyone know what I can do?

Thank you


texts: Can anyone please explain why a membership state Deceased exists (along with the contact's state)? Is there a use case where the membership is Deceased, but the contact is not?


texts: Why do we need new_link in the mysql DSN settings?

texts:
I see that in all civicrm settings.php examples the DSN is something like

  mysql://crm_db_username:crm_db_password@db_server/crm_database?new_link=true

but why the new_link setting? Isn't it much more efficient to re-use an existing mysql connection than to open a new one each time?


texts: How do I rebuild the training demo sites?

texts:
After ssh'ing in:
$ ssh joemurray@www-training.civicrm.osuosl.org
I was going to restore the first 3 of 25 training sites using:

civibuild restore PARM_SITES="01 02 03"

as per the documentation for buildkit at  https://github.com/civicrm/civicrm-buildkit/blob/master/doc/civibuild.md#rebuilds and a tip from Tim about the parameter.

However, the civibuild command wasn't available in my path and I couldn't find the file either. I was expecting it to be available on this server. Has it been renamed?


texts: Pledge payment link does not point to a publicly accessible page

texts:
The reminder email for pledge payments includes a link that points to a page on the admin side of wordpress that requires a login. How can I change this setting in CiviPledge to point to a publicly accessible page?

Here's a sample of the link

In response to comments below:

1 - I am using the default message template for Payment Reminders.

2 - The Old/New Base URL in Settings - Cleanup Caches and Paths shows "https://lofcenter.org/"

3 - The civicrm.settings.php shows the following:
if (!defined('CIVICRM_UF_BASEURL')) {
  define( 'CIVICRM_UF_BASEURL'      , 'https://lofcenter.org/' );


texts:
I want to use in a Mosaico template a token for the contribution and I found in a system template this string: {$totalAmount|crmMoney}.

I tried to use it in my new template but it doesn't show in the email. I have the civitoken extension but {latestcurrentmembership.allfee} doesn't show because it's a "pay later" option and I guess this token works only when the membership is already paid.

Any idea?


texts: New D8 / Civi install. First d8 then added Civi. Civi Menus not showig up

texts:
I installed D8 first then Civi and it seems like it is working if I manually put the url comonents after the http://focal-civi.domain.org/civicrm/{manually-add} but the menu is not showing up.
Anyone have any hints?


texts:
Which approach would you recommend for integrating CiviCRM into an existing ecosystem of 3 Wordpress installations, each residing on its own server with its own domain, where at the moment users, event-registrations and newsletters are being managed separately?

Ideally changes in one of the clients would update the central CiviCRM database (via REST et al.) and vice versa.


texts: Does Contact Editor Extension work with Version 5.2.1?

texts:
I just upgraded to version 5.2.1 from 4.7.27.  I tried using the contact editor extension to change a contact type but I get a "Page Not Found" error.  As part of the upgrade, I switched to PHP version 7.1.  I use CiviCRM with WordPress.

Does the Contact Editor extension work with 5.2.1?


texts: How is CiviCRM in a Drupal Commons Install?

texts: My organization has been using WordPress, and wants to move to Drupal for views and webform, but we need some sort of social community for our members. We're currently using PeepSo (from the makers of Jomsocial for Joomla! (peepso.com)) which we like better than BuddyPress. However, what can we use to give us similar functionality in Drupal? The only thing we've found is Drupal Commons.  Are there any conflicts between CiviCRM and Drupal Commons? If there are conflicts, is there another way to have a social community on Drupal that won't conflict with CiviCRM?


texts:
I'm trying various options for bounce processing, because mail seems to be flagged as Spam too often. My hosting provider (Siteground) is saying that SMTP is better than the PHP mail() route, but with SMTP the VERP return path isn't in the mail, so I don't get any bounce messages.

CiviMail works fine with the mail() option but no good with SMTP. The envelope return path is just the same as the From field. Nothing changed between the tests except for SMTP/mail(). Mail sent to individual users without CiviMail work fine in both option (but of course don't have a return path).

I'm aware of Siteground Email - How to configure?, which is likely to affect me if I solve this one!

I am also exploring other mail providers (SparkPost in particular), but I'd prefer everything in the same place and SparkPost is giving problems with too much being marked as Spam, but that is for a different post.

CiviCRM 4.7.27, WordPress 4.9.5 hosted at Siteground.


texts: How do I create a Webform that will open a case and assign case role

texts:
I'm trying to set up a webform to open a case and assign a case role.

3 contacts:
Source,
Client,
Case Coordinator

The open case part works great, but if I add the Case Coordinator relationship, it creates the relationship outside of the case.

If I add another activity (the first one is open case) and use assign case role, I don't get the option to choose which contact to use.

Any guidance?


texts: How do you run a membership/event report?

texts: To be considered a 'voting' member in our organization, you have to be an active member, and also have attended a certain number of events in the past year. I see how to run a membership report, and I see how to run an event report, but how can I search for 'active member' AND 'attended 3 events in the last 12 months'?


texts: How do I put saved searches or smart groups as menu options in WordPress?

texts:
Is it possible to make custom searches (smart groups) available from the custom menu. For instance, I am tracking elections (organizations) with custom fields for special elections, open races, candidates by district etc. Would like to make it easy to search from the menu for all open races, all members of the U.S. Senate etc. Is the only way to put custom searches on the menu to learn .php and create a custom search page on the backend?

!]1


texts: What is needed to make Payflow Pro Recurring Donations work?

texts: CiviCRM supports comes with PayFlow Pro but it doesn't support recurring payments.  I looked at the code and there's code for recurring.  What is needed to finish this part of the payment processor?  An IPN segment?  I already know that it will take time, money and developers.  I'm looking for what these items would be used for.


texts: One Contribution page with multiple webforms

texts:
Has anyone had any issues with using one contribution page from CIVI together with multiple webforms.

For example - One webform processing annual memberships, another processing life memberships but using the same contribution page.

Many thanks,


texts: Problem with the ical feed of the calendar

texts:
I would really like to use CiviCRM's function to create an ical feed for the calendar. But I'm having some hard times to get it working.

The event has a title, a date, a custom category and a 'long description'. When you visit the url to the ical feed: https://example.tld/civicrm?page=CiviCRM&q=civicrm%2Fevent%2Fical&reset=1

you get the following .ics file

civicrm_ical.ics

BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//CiviCRM//NONSGML CiviEvent iCal//EN
X-WR-TIMEZONE:Europe/Amsterdam
METHOD:PUBLISH
BEGIN:VEVENT
UID:CiviCRM_EventID_4_215ca88ba6fc880ae683205e6cd7bc8d@example.tld
SUMMARY:Test-event
DESCRIPTION:Some description
CATEGORIES:ALV
CALSCALE:GREGORIAN
DTSTAMP;VALUE=DATE-TIME:20190401T200000
DTSTART;VALUE=DATE-TIME:20190401T200000
DTEND;VALUE=DATE-TIME:20190402T030000
URL:https://example.tld/civicrm/?page=CiviCRM&q=civicrm%2Fevent%2Finfo&reset=1&id=4
END:VEVENT
END:VCALENDAR

But when I use the url of the feed in fastmail or google calendar for instance, an error appears, or the calendar items do not appear. What could be the problem?

I use CiviCRM 5.10.3 on Wordpress.

Kind regards,

Sam

--- edit ---

I got the following error message from Fastmail, my mailprovider.

  Syncing to your [redacted] calendar has been disabled: [ad2278bd-7237-4dee-884f-4eff6f3666bc] The calendar data was invalid: Error parsing VCalendar data: error Closed a different card name than opened at line 7 char 0:

---> ï»¿BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//CiviCRM//NONSGML CiviEvent iCal//EN
X-WR-TIMEZONE:Europe/Amsterdam
METHOD:PUBLISH
END:VCALENDAR
 <--- at /usr/lib/x86_64-linux-gnu/perl5/5.20/Text/VCardFast.pm line 55.

BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//CiviCRM//NONSGML CiviEvent iCal//EN
X-WR-TIMEZONE:Europe/Amsterdam
METHOD:PUBLISH
END:VCALENDAR
 at /home/mod_perl/hm/ME/CalDAVTalk.pm line 1427.
    ME::CalDAVTalk::_getEventsFromVCalendar(ME::CalDAV=HASH(0x8601578), "\x{feff}BEGIN:VCALENDAR\x{a}VERSION:2.0\x{a}PRODID:-//CiviCRM//NONSGML CiviE"...) called at /home/mod_perl/hm/ME/CalDAVTalk.pm line 2554
    ME::CalDAVTalk::vcalendarToEvents(ME::CalDAV=HASH(0x8601578), "\x{feff}BEGIN:VCALENDAR\x{a}VERSION:2.0\x{a}PRODID:-//CiviCRM//NONSGML CiviE"...) called at /home/mod_perl/hm/ME/CalDAV.pm line 1434
    eval {...} called at /home/mod_perl/hm/ME/CalDAV.pm line 1433
    ME::CalDAV::syncFromIcal(ME::CalDAV=HASH(0x8601578), "b8285308-2a18-4c47-9d22-fae8d8798d21", "\x{feff}BEGIN:VCALENDAR\x{a}VERSION:2.0\x{a}PRODID:-//CiviCRM//NONSGML CiviE"..., HASH(0x89e5670), "Force", 0, "ReadUidPrefix", "913888i-") called at /home/mod_perl/hm/ME/CalDAV.pm line 1904
    eval {...} called at /home/mod_perl/hm/ME/CalDAV.pm line 1867
    ME::CalDAV::syncCalendar(ME::CalDAV=HASH(0x8601578), 913888, "Force", 0) called at /home/mod_perl/hm/scripts/caldav_sync.pl line 271
    main::SyncCalendar(ME::User=HASH(0x89bea78)) called at /home/mod_perl/hm/scripts/caldav_sync.pl line 98

I have no idea what to make of this. There are currently no events in the calendar.


texts: Can I customize the columns that are displayed on the Manage Events page?

texts: IS there anyway that I can modify the table that is displayed on the Manage Events page.  Ideally I'd like to be able to change the columns that are displayed.  I couldn't see where this can be done in the admin/config menu but can this be done by editing the relevant page template?  If so can someone provide me with details as to which file needs to be edited? thanks!


texts: How to remove "Report URL" from emailed PDF reports header?

texts: I would like to remove the link from a report email header. Is it easy to achieve? thanks


texts: What causes periodic database errors while using logging, and what should I do about it?

texts:
Running a Drupal site with CiviCRM Logging enabled.  It seems like once a month we get a crash. On investigation one of the log tables is corrupted. Since the tables are type Archive MYSQL provides very limited tools.

The normal fix is to remove the data from the sick table or completely deleting the sick table and rebuilding. Any suggestions for preventing the issue or recovering from the problem


texts: What are the minimum and recommended changes to CiviCRM to support PHP 7?

texts:
To pragmatically help CiviCRM step-by-step to support PHP7 I would like to know what the minimum and recommended changes to CiviCRM to support PHP 7?

This will help developers to identify areas of interest in order for issue https://issues.civicrm.org/jira/browse/CRM-17789 (PHP7 support) to be available.

PHP7 is significantly faster and PHP 5.6 will lose support august 2016 so it is wise to slowly work towards getting CivCRM ready for PHP7 :-)


texts: Add supplemental address field 1 to BillingBlock.tpl

texts: I'm using CiviCRM 4.6 with Drupal 7 and have added the Supplemental Address Field 1 in CiviCRM but I can figure out how to get it to show in my custom BillingBlock.tpl


texts: Randomly Generated user Passwords, Local Cron Logs and Cron for CiviCRM

texts:
Wordpress  4.4.2 | CiviCRM 4.7.1

One thing I noticed about CiviCRM cron and one question...

Observation:
Cron won't run if there are some escape characters randomly generated by Wordpress.

I was getting this in my cron daemon emails:

/bin/sh: W_!1IUHzMR: command not found
ERROR: Invalid username and/or password

I changed my password to something less random and it now works. This might frustrate some users who are using Wordpress's own random generator. I didn't see anything about it in the CiviCRM cron installation documentation, so it frustrated me for a while.

My question:
I'd like to do log my cron task like this:

*/15 * * * * /usr/local/bin/php /home/me/public_html/wp-content/plugins/civicrm/civicrm/bin/cli.php -s mydomain.org -u me -p myrandompassword -e Job -a execute >> /home/me/cronlog/mydomain.log 2>&1

to log my errors instead of emailing them, but cron refuses to install:

/usr/bin/crontab: installing new crontab
"/tmp/crontab.XXXXax8Prq":3: bad minute
errors in crontab file, can't install.
Do you want to retry the same edit? n
/usr/bin/crontab: edits left in /tmp/crontab.XXXXax8Prq

Is there a way around this?


texts: Email greeting token not working with mosaico

texts:
Building a mailing with mosaico

Contact email greeting not showing in final mail

(shows in html preview) mail sent as test and as mailing. No greeting in either.

d 7.66 c 5.10.3

other contact tokens (first name etc) are showing

Any ideas?


texts:
I have a custom field for Individual contacts which can carry multiple values, i.e. 'Languages' can be 'English, German, Spanish, Greek'.

An individual may speak 'English, German', another 'Spanish, Greek, English' and so on.

How can I populate this field with multiple values when importing contacts?


texts: 404 Error with all links on Administer Page

texts:
I just installed fresh CiviCRM 4.6.10 on Wordpress 4.4

Everything seems to be working fine and it looks like this crm is perfect for our needs but I am running into one problem-

If I go to Administer > Administration Console on the dropdown menu, every single link on that page brings me to a 404 not found error. EX: clicking on Organization and Contact info this is the URL I am getting a 404 not found http://(site)/civicrm/admin/domain?action=update&reset=1

But, if I go on the dropdown menu to Administer > Administration Console > Configuration Checklist and edit settings from links in there.. everything seems to be fine. URL for Organization Address and Contact Info is http://(site)/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fadmin%2Fdomain&action=update&reset=1&civicrmDestination=%2Fwp-admin%2Fadmin.php%3Fpage%3DCiviCRM%26q%3Dcivicrm%2Fadmin%2Fconfigtask%26reset%3D1

Seems like something is wrong and the full URL isn't linked in the Administration Console?

Any help is appreciated. Thanks


texts: What's stripping the characters from my menu links? (ie. '?' '=' and '&')

texts:
Just updated to 4.7.10 on wordpress and any menu link with non alphanumeric characters is stripped and replaced by an underscore.

Example:
/civicrm/contact/add?reset=1&ct=Individual

Becomes:
civicrm/contact/add_reset_1_ct_Individual

I've tried clearing caches, rebuilding menus etc. Debugger shows nothing - any ideas?


texts: How can I send a different Scheduled Reminder to recurring memberships?

texts: We want to set up a scheduled reminder for memberships that are about to expire, but we don't want to send it to people who have selected the automatic renewal option. How do we do it?


texts: contribute page for membership admin use only

texts:
I am using Civicrm 4.6 with Joomla! 2.5
I am looking to port our existing manual membership to civicrm. I have set up the membership categories and creating new memberships through the civicrm backend seems to work fine.

The charity will have two or three people who will administer memberships. I have created a Joomla user group and ACL for membership admin and added these users to the group. I have created a menu item which this ACL can access which is linked to a civicrm contribute page for individual membership renewal.

The issue that i have is that when one of the membership admin users logs into Joomla!, follows the link to the contribute page they appear to only be able to add a membership to their own contact record and not to be able to select the contact for which they will administer the membership add.

Any ideas on which i should look at to enable these administrators to process membership on any contact (or to add a new contact to process a membership).

I don't want the membership administrators to have access to the full civicrm, just to give them what they need to carry out their role.

Many thanks
Dave


texts: Contribution - Invoice Address layout is wrong. How to fix?

texts:
I am on Civi 5.0.1 and Wordpress 4.9
Please see screenshots.
I need to print and mail some Contribution invoices. I noticed that the address layout for the invoices is incorrect.  I went to Administrator > Communications > Messages Templates > System Workflow Messages.  Then I clicked to Edit Contributions - Invoice.

I tried rearranging some of the tables and short codes to make it show up the way I need it to, but that just messed it up even more.

Can someone tell me the proper table and shortcode arrangement in Contributions - Invoice to get the address layout I need?

Thank you.


texts: It looks like there are two options for indicating that an email address in on hold.  Is there a way to add another option?  If so, how would I go about doing that?


texts: Civi webform - contacts prefilled based on relationship are duplicated

texts:
Civi 4.4.6, Drupal 7.37, Civi Webform 7.x-4.10

I have a webform that should be prepopulating several contacts with the same relationship type (e.g., Employee 1, Employee 2).  However, Employee 1 is prefilled in each of the contact sections, and if different information is entered in the Employee 2 box, it overwrites Employee 1's contact record.  I've done this successfully on other sites so I'm not sure if I've missed a setting (duplicate is definitely UNchecked) or if this is a bug in this version of the webform integration module?

Thanks in advance for any assistance you can offer.


texts: I'm trying to use new feature Custom Reply-to introduced in CiviCRM 4.6 (4.6.8 now installed).  I go into Admin/CiviMail/Mailer Setting and click the Yes radio button, then save.  A Reply-to field now appears on the message preparation form, and the feature appears to work fine.  However, when I go back to Admin/CiviMail/Mailer Settings the Custom Reply-to radio buttons are both blank (unselected), with neither Yes or No selected.  This same issue exists in both my test and production systems.  The sandbox does not have this issue so there is probably something amiss in my database(s).  Which table is supposed to store this setting, and can I best repair the problem?


texts: Mosaico: Where can I find the source code of my mailing?

texts:
we are using CiviCRM 5.4.0 and just got the Mosaico extension started to send our newsletter.
Now I have run into the following problem:
In the past I would take the source code of the mailing, create a .html file out of it and upload this to our homepage to back up a link people could click on - so for example it would say "January 2019 Newsletter", you could click on it and would be provided with an online version of the newsletter we had also send as an email.

Now, I am using Mosaico and don't know how to go about this situation anymore...I can not find the source code of the mailing to create the .html to then incorporate into our homepage...

So my questions would be - how can I obtain either the source code or a clickable link I can include into our homepage?

Thank you for any answers!


texts: Error after upgrade to 4.7.1 "Call to undefined method CRM_Utils_System::isUserLoggedIn" (WordPress)

texts:
I've just upgraded from 4.5.2 to 4.7.1 and everything seemed to be working OK. I was able to use the system fine for an hour or so.

Then I was trying to re-assign some transactions from one user to another using PHPMyAdmin (by changing the contact id--I've done this before without problems) and suddenly I get a 500 Server error and nothing works.

Looking in the logs I find:

  Fatal error: Call to undefined method
  CRM_Utils_System::isUserLoggedIn() in
  /var/www/vhosts//httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/UFMatch.php on line 98

I also can see some references to:

  Call to undefined method CRM_Utils_System::getUFLocale()

I can't see how a change in data can have caused this??

I re-imported the db (back to the 4.5.2 version) but I still can't access anything--I can't even run the upgrade script.

I put a clean install of the 4.7.1 plugin code and that's not fixed it either.

I'm stuck, it works fine on the test system but is totally broken on my live system now.

Thanks

Update 9th Feb:

I'm running:
PHP Version 5.3.25
MySQL Version: 5.5.32
Unfortunately because it's a shared hosted system, I'm not sure I can get the version of PHP updated.


texts: Remove Employer/Job Title Fields and Reorder Fields

texts:
How do I remove the "employer" "job title" "nickname" fields in the Individual contact summary? Is there a way to reorganize the information on this screen (e.g., demographics should go first)?

I'm currently running the most recent version of CiviCRM 4.6.3.


texts: If a contact is in Trash (because they were merged) but the person with matching details fills in Membership what is a good outcome

texts:
Scenario was Contact A had email mydomain.co.nz

Contact A then filled out a Join/Renew (not using checksum) and used mydomain.nz

Result was Contact B was created.

Those contacts were later identified and merged while keeping Contact A with their original .co.nz email. Contact B was hence in Trash with the .nz email.

Contact then again renewed by using the .nz email - and hence the dedupe rules matched with the contact in Trash and added the membership to that record ie Contact B.

Seems like this is a fuzzy area, if a Contact is in Trash, but meets the required 'matching rules' what should happen to eg Contributions and Memberships or any other data.


texts: No cron runs have been recorded (CiviCRM 4.7.25 on Wordpress 4.8?)

texts:
I don't know how could I solve this problem. I have this problem from the beginning of installing. I read the other answers at this forum but they could;n solve my problem.
would you please tell me how can I solve this error step by step?


texts: Send an email function not always delivering

texts:
We're having a curious case where emails from CiviCRM as not always delivering.

CiviMail works fine. No issues there.

When sending a simple email from the actions on a contact record, Hotmail and Gmail accounts aren't receiving the email, despite CiviCRM displaying the message that is was successfully sent.

However, when emails are sent to my work MS Exchange account, where the IP address is whitelisted, they do arrive.

We've reviewed the mail settings, and when we do a spam test, we score 10/10 on mail-tester.com and are also not on any blacklists.

Has anyone else experienced this type of issue?

Where can I check to ensure CiviCRM is sending out the emails?


texts: How to ensure end-of-period donations are recorded in the correct fiscal year?

texts:
Suppose an organization's fiscal year ends December 31st, 2018. Organizations which operate on an accrual rather than a cash basis (most, in my experience) would recognize a check dated December 30th, 2018, that was not received until January 4th, 2019, as a 2018 donation.

On CiviCRM contribution entry screens, there are two date fields. "Receipt Date," the date that a receipt was sent to the contributor, is irrelevant to this discussion. The other is labeled "Date Received" and described as "The date this contribution was received." If data entry staff were to take this language at face value, they would enter January 4th for the donation in question, which would result in reporting (or accounting sync) inconsistent with the organization's accounting basis.

An obvious workaround is for staff to be instructed to enter December 31st as the "Date Received" for such checks. Is anyone doing something better than this?


texts: Combination of auto-renew and PayPal Pro (when paying w/ PayPal account) on membership pages results in "11502 invalid token" error message

texts:
Update
Per the Jira issue below, a fix has been submitted for the upcoming (October) 4.7 release, but not for the current 4.6.6. version.

Issue is regarding Recurring Contributions with Paypal Pro on Joomla. Same issue at the one summarized in the now deprecated forum: http://forum.civicrm.org/index.php/topic,35304.msg150570.html#msg150570

On CiviCRM 4.6.2 on Joomla 3.4.1

If this is identified as a feature request, what level of donation would enable the fix?

I submitted a bug here: https://issues.civicrm.org/jira/browse/CRM-16850

Issue seems to be related to this: https://issues.civicrm.org/jira/browse/CRM-13362

I latest release log shows a few fixes related to the recurring payments but they do not address this issue: https://issues.civicrm.org/jira/browse/CRM-16504?jql=fixVersion%20%3D%204.6.3%20AND%20project%20%3D%20CRM


texts: I find that in many case some of the default fields on activities are not relevant. what's the best approach to editing the templates so that I can control what fields appear on activity forms?


texts: Can I update/requery a custom field that got changed via another field on the same page?

texts:
I created some database triggers that update a read only custom field that is displayed on the main contacts page.  You change the value in another field and the db triggers update the custom field.

So how do I get that read only field to be refreshed with the new value or, at the very least, just refresh the entire page?

The civicrm ajax wiki page suggests CRM.refreshParent so I tried to put that in a post processing hook

function ccas_hooks_civicrm_postProcess($formName, &$form){
    if ( $formName == 'CRM_Contact_Form_Contact' or  $formName ==
             'CRM_Contact_Form_Inline_CustomData') {
        CRM.refreshParent;}
}

Of course, that didn't work.  I ended up with following two error messages

Notice: Use of undefined constant CRM - assumed 'CRM' in ccas_hooks_civicrm_postProcess() (line 300 of ...

Notice: Use of undefined constant refreshParent - assumed 'refreshParent' in ccas_hooks_civicrm_postProcess() (line 300...


texts: API v3 Create Contact. In api.Order.create, the $value is empty

texts:
I am importing contacts from a CSV by reading it with PHP and creating an array of data, then using API v3 to create the Contact.
I have been able to create the Contact, add emails, add website, add phone numbers... Now I am trying to assign a Membership.
From the docs, I believe best practice is the Order API. I am chaining together the api.Order.create and the api.Payment.create and this works as expected, until I pass in my membership with the following code:
'params' => [
  'contact_id' => "$value.id", // This should be an ID like 215, but is empty.
  'membership_type_id' => 4,
  'skipStatusCal' => 1,
  'status_id' => "Pending"
],

If I set contact_id to be the next ID that will be generated by CiviCRM, it works as expected but I don't always know what the next ID in Civi will be.
Based on chaining, I would expect to pass in $value.id which would be the ID but it is empty.
To test this, I have tried chaining api.Note.create and passing it $value.id where the correct ID is output.
Here is a sample of my code:
// Contact data is already set before this point.

$user_data['api.Order.create'] = [
  'financial_type_id' => 2,
  'total_amount' => 0,
  'contribution_status_id' => "Pending",
  'line_items' => [
    [
      'params' => [
        'contact_id' => "$value.id", // This should be an ID like 215, but is empty.
        'membership_type_id' => 4,
        'skipStatusCal' => 1,
        'status_id' => "Pending"
      ],
      'line_item' => [
        [
          'entity_table' => "civicrm_membership",
          'qty' => 1,
          'unit_price' => 0,
          'line_total' => 0,
          'price_field_id' => 1
        ]
      ]
    ]
  ],
  // Activate Membership.
  'api.Payment.create' => [
    'total_amount' => 0,
  ],
];
$contact = civicrm_api3( 'Contact', 'create', $user_data );

How can I pass the contact_id to the params in the line_items?


texts:
I don't know too much about the internals of CiviDiscount but we have a scenario where we would like to offer a discount when you have multiple events in your cart (4 for the price of 3, 20% off when you book three or more events, etc.)
I was wondering whether CiviDiscount would be a good basis for this. I was (naively?) thinking that there might be a hook in the CiviDiscount extension that you could use for this kind of use case.
Does it make sense to think about adding such a hook to the cividiscount framework?
Or maybe a more sensible approach is to use hook_civicrm_buildAmount.
Any thoughts people have on the best way to go about this appreciated.


texts:
I'm attempting to move code from an angular extension into core. I've created an ang/crmModuleName and moved the ctrl and partials into it, and crmModuleName.css into the ang/ and crmModuleName.js into the ang/. I've modified Civi/Angular/Manage.php to include js, css, partials, settings. Cleared cache on local server, but it is not working.

Is there another step I've missed?


texts: CiviContribute: transaction rate limiting

texts:
Recently we've had some bots testing (stolen?) CC numbers against our CiviContribute form.  Our payment processor declines them all, but it sometimes results in our account getting suspended for 30 minutes.

Has anyone implemented per-IP-address transaction rate limiting?  As a module, or some other way?


texts: Getting "set_time_limit() has been disabled for security reasons" when importing a CSV file into contacts

texts:
I'm getting "set_time_limit() has been disabled for security reasons"  when importing a CSV file into my contacts.

The exact warning is "set_time_limit() has been disabled for security reasons in /home/clients/9f584f50407ada97b7c17ed3b0bbc0f0/crm/wp-content/plugins/civicrm/civicrm/CRM/Contact/Import/Controller.php on line 31"

I use CiviCRM v5.21.0 under WP last version

Any idea will be much appreciated. Thanks


texts: Child groups with all parents disabled shows in group list

texts:
I'am currently using Civicrm version 5.3.1 with drupal 7.59.
Steps to replicate:

Create one group, parent A.
Create a one group, child A and assign parent A group created above as
parent.
Disable parent A group.
Go to contacts->manage groups. You are unable to see both parent and child groups.
Click on any search criteria. Unclick it. You can see the child A group with title as Child A Child of:. With null value for parent

How it works currently: If a child group has multiple parent groups and one of them is disabled, the child group should to show up on group selector lists. This has been fixed here https://issues.civicrm.org/jira/browse/CRM-20934.

If all parent group(s) are disabled the child group still shows up in search mode.

Is this the expected behaviour?

Shouldn't the child group be removed from the selector lists if all parent group(s) are disabled?


texts: Multiple values for custom fields in Activities?

texts:
Anyone has seen any custom implementation/extension of custom group multiple values for Activities?

Since we are using Activities for many different scenarios, many times the requirement of having multiple values' custom groups for Activities pops out (which now a day is only available for Contacts)

Any lead/tip will be appreciated


texts: Switched "logging" on - now get 'Unable to reach server'?

texts: I just switched logging on for a 4.7.27 install which was working just fine.  Now, when clicking on 'Change Log' tab I get the 'Network Error' popup with the message about being unable to reach the server.  And there's no response at all. The rest of the system works OK still. I checked all the log_xxx tables were created, cleared Civi & Drupal caches. I've also looked at the several questions about this error but none seem to apply - this was a site that was working OK and it's only the change log that's affected. This is a Civihosting hosted account, by the way.  Ideas?


texts: "Page www. ... .com does not work" when Submlitting Event Registration Webform for immediate On-line Payment

texts:
I use Webform Civicrm Integration to register multiple attendants to an event, and calculate the total fee. (This works fine).

I have included a Contribution Page, which provides the choice : Now on-line / Later.

"Later" works fine, but if I choose "Now on line", I get a page "Page www. ... .com does not work ; impossible to manage this request for the moment ; Error 500".

FYI :

The Contribution Page refers to a CM-CIC Payment Processor (extension), but the "test" processor behaves the same.

The Contribution page alone (via "https://.../index.php?q=civicrm/contribute/transact&reset=1&id=1"), works fine.

It seems that sth is missing between Webform and Payment page


texts: Can one show participantID on event reminder?

texts:
We're intending to use an event's participant ID as a pseudo-registration code, i.e. a quick way for us to correlate who shows up to events. Because of that, we are asking our event participants to know their participant ID when they arrive.
So far, we've adapted the ThankYou.tpl event registration confirmation page to show the user their participant ID by adding the following:

{ts 1=$participantIDs.0}Your registration number is: %1{/ts}

and we've adjusted the template for the event registration email to show $participantID as well (inside Mailings -> Message Templates -> System Workflow Messages -> Events - Registration Confirmation and Receipt (on-line)).
Now, we'd like to add that value on to a reminder message. We've set up the reminder template under Mailings -> Message Templates -> User driven messages and are able to get the reminders to send correctly, but it's not clear how to get the participant ID to show up. It's certainly not listed within the available tokens.
Is there a way to add a participant id to a template there? Can I link participant_id to the available tokens in some way?


texts: Assigning multiple participant roles in civi event, through imports

texts:
I would like to assign multiple roles to event participants through imports.
I can upload a csv to assign a user role, but if I import a second data source with a different role, it is set aside as a duplicate and not imported. I would like the second role to be added to the existing record. (not overwrite)

For instance I have a list of auction event particapants who are attendees, donors and/or buyers. My lists have overlapping contacts.  I would like to keep these all associated with the event, rather than creating groups or tags. Handling the overlaps manually is not practical.


texts: Drupal Email address ends up in Billing not Home

texts:
I am running CiviCRM 5.13.4, and have the following scenario.

•   Administrator creates an Individual Contact offline, without any email address.
•   The User then registers for an online account through Drupal, which includes entering an email address.
•   The User can then log on as usual.

The system successfully deduplicates with the original contact, using the name and postcode (collected on the registration Profile).
BUT the email entered by the User ends up as the Billing Email Address, not the Home address, and the Billing Email becomes the Primary email, which is not what is wanted.

It looks as if the linkage with Drupal is just picking up the first entry on the list of location types, and not taking note of the Default type which is set to Home.

This is a quite possible scenario when we migrate our existing membership database, and some of them start to use the online capability for the first time.

Is there any fix or workaround?

With thanks, Tony


texts: Impossible to get the source field with the Contribution API

texts:
On CiviCRM 4.6.11.
I need to get the source field of a contribution, but the api seems to fail.
Testing the API on http://xxx//civicrm/api#explorer with entries giving the following PHP code :

$result = civicrm_api3('Contribution', 'get', array(
  'sequential' => 1,
  'return' => "source",
  'contact_id' => 4889,
));

gives as results :

{
    "is_error": 0,
    "version": 3,
    "count": 1,
    "id": 4676,
    "values": [
        {
            "contact_id": "4889",
            "contribution_id": "4676",
            "id": "4676"
        }
    ]
}

Although the contribution DO HAVE a source value, no source entry in the result.
Is-it a knonw bug, or what wrong in the trequest ?

Thanks for help.

Jean-Pierre


texts: How to bootstrap CiviCRM with admin permissions in a Wordpress environment?

texts:
I'm using eval cv php:boot in a script. I need to be able to delete a contact in the script, including the skip_undelete flag, but this action is denied - get a "could not delete contact" error.

I learnt that in Drupal this happens when you're bootstrapped but not as the admin user, but I'm unfamiliar with what Wordpress's equivalent would be, and whether it's possible to do this using cv?

Thanks.

PS. I'm writing a phpunit test (not a unit test) for a wordpress integration plugin (not a CiviCRM extension) that makes various API calls. I am running this against a real world database, not a buildkit one, so it's not appropriate to use the extension-style phpunit tests which start by tearing out your data :-)


texts: Can't add addresses when geocoding is enabled

texts:
Steps to reproduce

On the CiviCRM 4.7 / Drupal 7 demo site (demo.civihosting.com):

Go to "Administer -> System Settings -> Mapping and Geocoding"
Set "Mapping Provider" and "Geocoding Provider" to "Google"
Go to "Create New -> Individual"
Set "First Name" and "Last Name" to "Test"
Open "Address"
Set "Country" to "Italy"
Click "Save"

Expected behavior

A new contact should be created, and I should see the summary page for it.

Actual behavior

I see an error page, reading:

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

Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame thrown in /home/galleryr/www/demo/sites/all/modules/civicrm/Civi/Core/Transaction/Manager.php on line 107

Analysis

After reading the logs in ConfigAndLog, I found the problem had to do with the empty state/province field. I tracked it down to lines 1060 to 1068 ofCRM/Core/DAO.php:

1060     if (
1061       empty($searchValue) ||
1062       trim(strtolower($searchValue)) == 'null'
1063     ) {
1064       // adding this year since developers forget to check for an id
1065       // or for the 'null' (which is a bad DAO kludge)
1066       // and hence we get the first value in the db
1067       CRM_Core_Error::fatal();
1068     }

Simply deleting these lines seems to resolve the issue. From the comment about "we get the first value in the db", I expected the newly created contact to have an address with state/province id 1, but actually it worked as it should: I gave no state/province, and no state/province is what came out.

Hope that helps. Cheers!


texts:
I am using version 5.2.2 of Wordpress and CiviCRM 5.13.5. Since I did a backup last week, I am getting this message when I go into Civi.

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.
You have requested a non-existent service "mosaico_graphics".

Then I click CiviCRM again, and all is well.

However, today I tried to create a new mailing, and I get the same message. Unfortunately, I can't just click New Mailings and move on.

In either case, I am not trying to use mosaico.

(By the way, mosaico has not been working for some time, but I've been able to do a workaround.)

Thanks.