texts: How can we avoid staff users overwriting emails of utility WordPress accounts when testing CiviContribute pages?

texts:
I installed the latest CiviCRM on WordPress. WordPress is set up to refuse new accounts to the public, and there are about 12 utility admin/editor related accounts not tied to a specific person: AdminCrm, Editor, Staff1, Staff2, etc.

There is an ongoing problem if the logged-in user uses or tests a contribution page, because CiviCRM mixes up the current WordPress login with the user's contact information. The person logged into WordPress is invariably a member of the organization, and if they renew their membership while logged into one of these utility accounts, the email address for the renewal is copied from that of the current login which results in a duplicate contact created.

It would be nice if there was some way to turn off this behavior. I think CiviCRM on Wordpress was designed to assume contacts were always linked to a Wordpress login. Need suggestions on how to handle this day-to-day.


texts: Append an option to the BlockSchedule Directive in crmMailing

texts:
I'm making a first foray into customizing the mailing compose screen.

I want to add a third option to the options in BlockSchedule.html (schedule.mode = regular) which will open up a few more options to allow you to send mailings on a regular basis.

The template code I want to add is along the lines of

  <input ng-model="schedule.mode" type="radio" name="send" value="recur" id="schedule-send-recur"/>
  {{ts('Send on a regular basis')}}

Selecting this will open up a new directive with options for sending on a regular basis. It will also swap the submit mailing button for a schedule mailings button and possibly do other stuff.

But right now, I am stuck on a good way to add this option.

This answer (adapted below) makes me think that something along the lines of the following would work, but what do I do with the directive at this point?!

angular.module('crmMailing').config(function($provide){
   // intercept crmMailingBlockMailing directive, note the 'Directive' suffix
   $provide.decorator('crmMailingBlockScheduleDirective', function($delegate){
        var directive = $delegate[0];


texts: In Drupal 8 Webform_Civicrm how do I clone a Contact?

texts:
Running Drupal and Webform_civicrm 8.x-5.0-beta4.
How do I clone a Contact?
If I create one Contact, then change the number of Contacts from 1 to 2 (or more) I get the message:
Tip: Consider using the clone feature to add multiple similar contacts. (more info)

The (more info) looks like a link, but does nothing when I click it.
On D7 there is a 'Clone Contact' link on the Webform tab, but I can't find the equivalent on the D8 Build tab, or elsewhere.


texts: Apply Multiple Discount Codes to a Event Registration

texts:
Is it possible for a registrant to enter in more than one discount code for an event? For example, if we have three tiers ($200, $400, and $600) and two add-on events ($50 and $150), can the registrant apply a code called tier1 ($100 off) and a code called addon1 ($25 off)?

Right now, if the registrant enters in the second code, it overrides the first and only the second discount code gets applied.

Basically, I'm looking for the functionality you might find on an e-commerce site where you can apply multiple coupons. I'm thinking the answer is that we'll have to build this out with a vendor; however, I'm surprised this hasn't been implemented in a prior version of the extension via a make it happen, considering the complexity of some non-profits' events.


texts: How do I import an activity with multiple target contacts?

texts:
Has anyone got tips for the best implementation for this that's friendly to a savvy end-user?  I can script it in an ETL tool, but that's not an option for them.

"Import Activities", as best I can tell, will only import a single contact ID.
You can import more contacts via the ActivityContact API (with API CSV GUI Import extension) but this is hard, because there's no good way to match the imported activity to the CSV you imported from.  Activities don't have an "external identifier" field.

The only real choice I see is to hijack an field I'm not using like "Engagement Level" and use that as a temporary "external identifier" - but that's pretty ugly.

Any other approaches short of building a custom import?


texts: What does the 'access_civicrm_nav_link' permission allow?

texts:
I'm currently reviewing the permissions for a CiviCRM/WordPress site. Some of the user roles have the 'access_civicrm_nav_link' permission but I'm not sure what this is used for.  I couldn't find any documentation for it except for a reference to it in one of the WordPress integration files:

/CRM/ACL/Form/WordPress/Permissions.php

Am I right in thinking that this permission dates back to an earlier version of CiviCRM and is no longer used?

Is it safe to remove this permission from the user roles?

CiviCRM 4.6 / WordPress 4.5


texts: Smart Groups - Added contacts show status of 'smart' not 'added'

texts: I have recently upgraded to 4.6.19 which has solved issues to do with the updating of smart groups. However if I add a contact to a smart group it does not show the status of 'added' but shows the status to be 'smart'.


texts: Membership Auto-Renew Changes in AuthorzeNet

texts:
We have memberships setup to auto renew on a monthly basis utilizing AuthorizeNet. All works fine. When a member needs to change their CC  information (or any other info) and the change is made within AuthorizeNet recurring payments the transaction continues to process correctly but the info is no longer sent to Civi so the monthly renewal is not recorded.

Anyone else experience this?

The site is running Civi 4.6 with WordPress.


texts: Charity wordpress template that works with CiviCRM

texts:
I want to move our website from Drupal/CiviCRM to Wordpress/CiviCRM but understand that not all wordpress template will work with CiviCRM. Does anyone have a recommendation on the best charity wordpress template to use? We are a very small NFP and don't have money to spend on development.

Thank you!


texts: Error: Refund amount must equal refund due amount

texts:
Has anyone else had this issue where its not possible to get the refund page to save even though the amount is correct?

Drupal Error Log

Notice: Undefined index: event in CRM_Core_Payment_ProcessorForm::preProcess() (line 78 of /****/public_html/sites/all/modules/civicrm/CRM/Core/Payment/ProcessorForm.php).


texts: Error after installing Civi Entity module

texts:
Blockquote
  Warning: array_combine(): Both parameters should have an equal number of elements in CRM_Contact_BAO_Relationship::buildRelationshipTypeOptions() (line 2250 of /home/i571020/membership.irishjudoassociation.ie/sites/all/modules/civicrm/CRM/Contact/BAO/Relationship.php).

I've started getting this error after enabling the module. I can see all the options in views, rules etc. but the warning is visible in the back-end. Is this something in my relationships that's not right or else?


texts: API problem regarding to Word Replacement

texts:
I want to replace a word. I was trying to insert using API3 but it is not working properly.

  Word replacement API3

$result = civicrm_api3('WordReplacement', 'create', [
  'find_word' => "Contacts",
  'replace_word' => "Data",
  'id' => 1,
]);

  Output
      {

"is_error": 0,
"version": 3,
"count": 1,
"id": 1,
"values": {
    "1": {
        "id": "1",
        "find_word": "Contacts",
        "replace_word": "Data",
        "is_active": "",
        "match_type": "",
        "domain_id": "1"
    }
}

But the values are not stored in 'civicrm_word_replacement' table.
Please give some suggestion.
When I am trying to insert a value using custom php script then it is showing me a following error.

PHP Fatal error:  Uncaught Error: Call to undefined function _drupal_flush_css_js() in C:\xampp\htdocs\copy\sites\all\modules\civicrm\CRM\Utils\System\DrupalBase.php:300


texts: case details field not available through UI

texts:
Is it true that the Case Details field can be populated, but cannot be seen through the UI in CiviCRM?
This seems odd - if it's true I'll open an issue in gitlab, but wanted to check in with the community first.
It seems like it can be pulled into a view or webform, but not viewed in Civi!


texts:
I have made a html-template in CiviCRM consisting only of this kind of html tag:
<div style="position: absolute;">

This works perfect for selecting a template for pdf printing, when printing only one page. Then I have the opportunity to place certain elements at the appropriate place on my letter.

The problem arises, when selecting a bunch of contacts, and then creating pdf-s to all of them at the same time. Then it only prints all on one single pdf-page, instead of one page pr. contact. I want the CiviCRM-template to print the <div> tag on one page pr. contact.

Is there a trick here I don't know? And if so, please explain...

(My site is using wkhtmltopdf to generate the pdf-s)


texts: Capturing Price Field selection onto Membership record

texts: We've been doing Membership pricing with a straight Membership Type list i.e. without Price Sets, but now want to add an option to receive the quarterly newsletter via snail mail, with a surcharge. I created the Price Set and managed to create the Contribution Page with a checkbox for the newsletter. I need to capture the newsletter option into the Membership, how do I do that? I set the Financial Type as "Publications", maybe that's wrong.


texts: We are a one person shop with a mailing list of 1,250 (and growing).  I'm considering setting up on spark - or hosting my own at civihost.  I'm concerned about the deliverability of bulk e-mail with spark.  Would it be a good idea to use a mailing service (ie, mailchimp or sparkpost, etc)?  I have the understanding that would not be possible with spark since it has limited support for extensions.  What would you advise?  Thanks.


texts: Error when creating new contact: "Fatal error: Uncaught CRM_Core_Exception"

texts:
When I create a new contact I am getting a "Fatal error: Uncaught CRM_Core_Exception". Maybe this will happen when doing other things too, but I haven't run into them yet. This is quite problematic and prevents me from working with this CiviCRM installation, so I would really to have some help fixing this.

It is a clean install of CiviCRM version 4.6.10 on a clean Joomla! 3.4.8 install with PHP 5.5. No errors were given until I tried to create a contact. Re-installation of everything also didn't help at all.

Full error message:

Sorry but we are not able to provide this at the moment.
DB Error: unknown error

Fatal error: Uncaught CRM_Core_Exception:
[0: Transaction integrity error: Expected to find active frame thrown in
[...]/administrator/components/com_civicrm/civicrm/Civi/Core/Transaction/Manager.php
on line 107


texts: How can I add Subscribe Message subject line token?

texts:
When users sign up to several mailing lists via our webform, they receive automatic 'Subscribe Message' confirmation emails for double opt-in. If they have attempted to sign up to two groups at the same time, these emails have the same subject line and get nested together in Gmail so that users are often only clicking one of the group confirmation links because it's not immediately obvious there are two emails for them to open/click.
I've tried to add the {subscribe.group} token to the automated messages subject line so that the email subject lines will be differentiated, but this doesn't seem to work (the token works in the body of the email itself, but not in the subject line).
Is there a way to add this token to the subject line, or to differentiate these automatic emails some other way so that Gmail etc. don't nest them together in the same thread? Thanks!


texts: Participant Search - Failed to interpret input for search

texts:
In the latest version of CiviCRM on the latest stable version of Drupal 7, if I attempt the following:

Events > Find Participants
Enter an event name AND a participant status

The search results in an error - "Failed to interpret input for search"

This doesn't happen if you enter the event name only, or the event name and participant role. It also doesn't happen where the combination of event name and participant status results in a 'no matches found' result - it only happens when the search would generate a result.

I've done a 25 second screencast of the issue in action:
https://drive.google.com/file/d/1RmpVyqxX6g99UsKLc5H9pcZtXLpCtqmG/view

Any advice gratefully received!

CiviCRM version 5.13.2, Drupal 7.67

Thank you


texts:
I am excited to be working with civicrm, but I am quite frustrated at this point and so I hope someone can help me.

I can see how valuable hooks are, and it seems like they are actually very basic to implement, but I need a small amount of pre-knowledge to use them.  I have read every link I could find about hooks to change forms and yet I find myself lost.

I did find one example that fit my needs exactly, and would be a great learning experience ... but the description leaves out a lot of necessary information for someone as new as me.

Can someone walk me though implementing this? It comes from How can I set “Assigned To” for an Activity to default

The extension mentioned in the comment above is:

function myextension_civicrm_buildForm($formName, &$form) {
  if ($formName == 'CRM_Activity_Form_Activity' && $form->action == CRM_Core_Action::ADD) {
    $form->setDefaults(array('assignee_contact_id' => $form->_currentUserId));
  }
}

How do I find the 'create activity' form this relates to?

  I got that answer myself -- CRM _ Activity _ Form _ Activity
  means the php file is in

  /var/www/drupal/sites/all/modules/civicrm/CRM/Activity/Form
  and then activity.php

Do I copy the form to my /var/www/drupal/sites/all/modules/civicrm_extensions directory?
Do I put that function inside the form I copied?
Do I create that as a file?
If a file, what do I name it?
Where do I put the extension once I create it?

You are all very helpful and I appreciate it. Thank you in advance for any help you can give me on this problem I face.

Just a note about searching for answers: About a month or two ago I found a web page that explained some of this to me but for the life of me I fail to find that page today. I did find a lot of links that looked like they could help but a whole mess of them led to (Page Not Found) on http://wiki.civicrm.org/confluence/display/CRMDOC/. Seems a lot of pages were deleted or renamed.

Thanks again.


texts: WYSIWYG editor missing from Scheduled Reminders popup window in Civi 4.6.3

texts:
I recently upgraded to CiviCRM 4.6.3 from 4.4.XX. Since then, the WYSIWYG editor is missing when creating a new scheduled reminder or editing an existing one. To reproduce the error:
1. Click Manage Events
2. Click Configure an event, and choose Schedule Reminders.
3. Edit or create a new reminder
4. See the editor missing.

However if on step 2, you instead choose Info and Settings, then click Schedule Reminders, the WYSIWYG editor does appear.

I've verified the error with IE, FF and Chrome, and I see the issue 100% of the time. Using Joomla 2.5.28.

Anybody else see this issue?


texts: Event Registration-Duplicate names, Overwrite on Contact Records

texts:
Due to using the same email, we have had tons of event contacts histories overwritten with another contact name besides duplicate name entries during registration of events.  With the upgrade to 4.6.10 I am monitoring same.  Currently I am still finding duplicate contact names in the system.  I am unsure of overwritten accounts until such a time where I discover same.  I know there is a few drop downs under duplicate emails in events/on-line registrations.  Which is the best to check off?  Right now it is on unsupervised.  Under Events-on line registration we also have checked off register multiple participants and same email address.

I have to go back 9 years to fix all records.  I would like to not have to do this anymore.

@Lesley Carter-BackOfficeI messed with the dedupe and things are now messed up, got this error:

An error has occurred.
 0   @import url(/administrator/components/com_civicrm/civicrm/css/civicrm.css); @import url(/administrator/components/com_civicrm/civicrm/bower_components/jquery-ui/themes/smoothness/jquery-ui.min.css);    Sorry but we are not able to provide this at the moment. Supervised rule for Organization does not exist Return to home page.    function toggle( element ) { var className = element.className; if ( className == 'crm-accordion-wrapper collapsed crm-fatal-error-details-block') { element.className = 'crm-accordion-wrapper crm-fatal-error-details-block'; } else { element.className = 'crm-accordion-wrapper collapsed crm-fatal-error-details-block'; } }


texts: Price Set: Update quantity based on selection?

texts:
We have a pricing structure where a standard membership is $15/year and membership for an additional member of the household is $10/year.

I'd like to automatically update the "nubmer of additional members in household" field so the price per unit is multiplied by the number of years selected in the "Standard Memberships" field.

For example, if a user selects 1 year standard and 1 household member, the household member would be $10.  2 years standard and 1 household member, that household member would be $20.


texts: How to avoid duplicates when donated using different email address or spelling mistake on names?

texts:
Its very often happening for my donors, that they donate first with an email and then next time with another. or some spelling mistake on name or email address.
Civicrm then creates duplicates of that person.
Although I can merge those 2 contacts, how can we avoid/reduce this kind of instances?


texts:
www....../civicrm/?page=CiviCRM&q=civicrm/profile/edit&gid=1&reset=1&id={contact.contact_id}&{contact.checksum}

i have finally set up my Checksum for profile update. However when link is clicked inside email i am getting this message-
"This profile is configured for contact type 'Individual'. It cannot be used to edit contacts of other types.
If I disable the Fist Name and Last Name fields for that profile it works.

Is there a way around this as i really need to have a First Name Last Name.


texts: Why do Personal Campaign Pages stay live after their Contribution Page is closed

texts:
I'm working with someone who posed the following question to me:

  Why do personal campaign pages stay live, even following the closing date for the contribution page they are attached to?  How do I make it so they automatically turn off when the contribution page does?"

Any ideas?


texts: How to disable sending an email after a recurring contribution?

texts:
The email sent isn't very clear, and offer an option to change the amount and instalment details

"You can update recurring contribution amount or change the number of installments details for this recurring contribution by visiting this web page."

And this change page has a warning message:

  Updates made using this form will change the recurring contribution
  information stored in your CiviCRM database, but will NOT be sent to
  the payment processor. You must enter the same changes using the
  payment processor web site.

Rather than confusing users that have no clue what a CiviCRM database or a payment processor are nor where its website could be, I'd rather skip sending that email. Is there a way to disable that?


texts:
I stuck with the error. When I try to repair indices I get error message:

CREATE UNIQUE INDEX index_entity_id_entity_table_account_relationship ON
civicrm_entity_financial_account (entity_id, entity_table,
account_relationship) [nativecode=1062 ** Duplicate entry '0-
civicrm_financial_type-12' for key
'index_entity_id_entity_table_account_relationship']
[type] => DB_Error

If I look into table see no problems.


texts: Is there a way for a user to verify themselves when following a checksum link?

texts:
Use case:

Email a checksum link to a user asking them to update their profile data.
When that user clicks the checksum link, request that they fill out a couple of verification fields such as postcode/date of birth/account number before being shown their data (just in case its not them).

I saw this demo'd at CiviCon London 2014 but can't remember who presented it, what it was called or if it was already part of CiviCRM or an extension. Googling for it has been unsuccessful.


texts: We are running CiviCRM version 4.7.24 on a Drupal 7 site. My client would like to add an MP4 video to an event page. I tried a simple upload of the video using the image button and I get the warning "Unknown image format/encoding" and the file is not uploaded. Is it possible to use video in CiviCRM event pages? If so, how do I do it?


texts: Custom Field Groups with File fields cannot be edited as a Tab

texts:
I have a site with several custom field sets that use the "Tab" style for displaying information about a contact. Included in one field set is a "File" field that is used to store a profile image for the contact.

After upgrading to 4.7.0, attempting to view this tab for a contact with a profile image results in an error message that says the value (the filename of the image) is not an Integer. For contacts that don't have an image, the tab is shown, but the file cannot be changed. The edit popover closes when I click "Save" but the file is not updated.

I replicated this issue using the CiviCRM demo site. The steps to reproduce are:

Go to Administer > Custom Data and Screens > Custom Fields in CiviCRM
Create a new set of Custom Fields or edit an existing one to use the style "Tab" and apply to Contacts (I used "Individual")
Place as many fields as you want in the Custom Field Set, including at least one File field
Find a Contact
Open the Tab of the Custom Field Set you created
Click the "Edit ..." button to change the values
Make changes to any (or several) field and click "Save"
You will be taken back to the Contact but your changes will not appear

Update Feb. 8 -
I applied the diff from CRM-17949 and while it does allow changing other fields in a Tab, images still cannot be changed. Also, the error message on existing images still appears. I attempted to replicate this on the demo site, which is currently running CiviCRM 4.7.2, but it appears to have file system permission issues that prevent uploading files.

Update Feb. 10 -
Here is how to reproduce this issues in 4.7.2:

Follow steps 1 through 6 in the previous numbered list
Upload an file (I used an image) into the file field and click "Save"
You will be taken back to the contact but the file will not be saved
Return to the Custom Fields, and click "more" > "Settings"
Change the Display Type to Inline
Return to the contact and scroll down to the group. Click "Edit"
Choose a file for the file field, and click "Save"
The image will be shown in the group
Return to Custom Fields again, and change the Display Type back to Tab
Return to the same contact and click on the tab for your custom group
You will be shown a popover message "One of parameters (value: filename.jpg) is not of the type Integer" and the tab body will display "Sorry but we are not able to provide this at the moment."


texts:
I have a custom group where one of its custom fields is of type varchar(64). This field is storing huge numbers only (something that I did not know during development) so I want to convert it into a int type, a bigint type due to the really lengthy numbers it's storing
My question is the following:
Assuming that the length is the same in all stored entries (around 2,5 million entries, 12 or 16 digit length), can I convert it into another type simply by ALTER TABLE or I need to inform Civi that this is an int/bigint field? Lastly, since I haven't seen the use of Bigint, is it safe to assume that it won't cause havoc in Civi's functionality if I do so?

Thanks!


texts: (How) can I add a footer fixed to the page of a message template for printing a pdf?

texts:
How can I fix a footer section at the bottom of the page of a Message Template? (no matter whether how much text the user is adding - the footer with our contact and donation account should always be at the very bottom of the page).

We would like to use Message Templates and the CiviCRM action "Print/Merge Document" to let our team write a letter to a contact within CiviCRM (getting address etc. filled through tokens), export it as a PDF and print it for postal mailing. Our previous CRM software had to option to generate a Word document prefilled with the contact information and including a footer element for this.

I found an old forum question about this but unfortunately it doesn't offer any solutions.


texts:
I'm having trouble re-installing CiviCRM 5.31. on Wordpress, hosted on Ubuntu 20.
I needed to uninstall an earlier version, and I now want to install the latest version.
When I activate the plugin I am unable to run the installer or updater.
I get a message saying 'Sorry, you are not allowed to access this page.'
I have tried running the plugin in troubleshooting mode with all other plug-ins deactivated, and the same error occurs.
The installation process is not generating a 'civicrm.settings.php' file
I've installed a WP DB Cleaner, which is reporting that two tables exist
civicrm_view_case_activity_recent
civicrm_view_case_activity_upcoming
When I have attempted to drop or delete these tables they don't seem to be removed.
Is there something I am doing, or is there a work-around for problems of this kind?
Regards
Rob


texts:
I have about 4,500 rows of participant that I would like to import.  In each row is a column for the  CiviCRM internal ID and columns for the requisite information about the event.

When I upload the CSV file about 400 rows are imported and for each of the other rows I get this error "Matching Participant record not found for Participant ID 10180. Row was skipped." Of course the ID number changes for each row.

I have cross-checked several rows and the IDs are valid.

The file is a CSV file so Excel formatting should not make a difference but I tried changing the field format and a few other things in Excel. Nothing has worked.

There are many duplicates in the list but not 4,000.  I have the duplicate setting set to update.

I appreciate any help.


texts:
CiviCRM 4.5.8(really any version, I think) and WP 4.2.4.

In a contact record the Groups tab will show a number.  This is the number of the "Regular Groups".  Is it possible to also show/combine the Smart Groups number on the Groups tab as well?


texts: Missing fields and reports in database after migrating to a new server

texts:
What's the best way to migrate CiviCRM to a new a server? I haven't been able to get it to work. I've been following this guide. Here are the steps I've been taking to for the migration.

1.) SQLDump and exclude the flowing tables in old database.

db_name.civicrm_domain

db_name.civicrm_acl_cache

db_name.civicrm_acl_contact_cache

db_name.civicrm_cache
db_name.civicrm_group_contact_cache

2.) Setup new CMS (WordPress, Joomla or Drupal) I have tried all three platforms

3.) SQLDump old database into new

2.) Clear cache and rebuild menus

I know that I must be missing steps. Here are some of the problems I'm running into:

1.) There is a problem when trying to run custom reports that repopulate after rebuilding the menu. The message I get is (error: You have tried to access a report that does not exist.) Where do you find custom reports made on the old system? Whats the best way to transfer them, copy paste?

2.) When clicking a a link on the menu or running search I get this (error: DB:no such field).

I'm guessing that when I transfer the custom templates/reports (not sure the proper nomenclature) the database error will resolve itself?

Here is the database error from the CiviCRM error log:

[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => SELECT civicrm_uf_group.id, civicrm_uf_group.title, civicrm_uf_group.created_id, civicrm_uf_group.is_active, civicrm_uf_group.is_reserved, civicrm_uf_group.group_type, civicrm_uf_group.description
                    FROM civicrm_uf_group
                    LEFT JOIN civicrm_uf_join ON (civicrm_uf_group.id = uf_group_id) AND civicrm_uf_group.is_active = 1
                          WHERE civicrm_uf_join.module = 'Search Profile' ORDER BY civicrm_uf_join.weight, civicrm_uf_group.title [nativecode=1054 ** Unknown column 'civicrm_uf_group.description' in 'field list']


texts: "Error: Please set the API URL" when buying a Free Membership

texts:
I have a contribution page that has six paid memberships and one free membership.  When the free membership is selected, it kept displaying the error that the Payment Type (Processor)was required.  After I deselected the required field requirement for Payment Processorm, the payment types disappear and they could make it to the "Continue" page, but then CiviCRM shows the "red banner" error page.

Is there a way to allow them to select a payment processor, even though the amount is zero?  Thats what it used to do before version 6.0 (I think).

I am using CiviCRM 4.6.2 on Joomla 3.4.1.  All paid memberships work great.  However when the free membership ($0.00) is selected, the Payment Types - includeds Paypal, Stripe and pay by check, all disappear, but seem to require one be selected before allowing them to sign up for the free membership.


texts: Order form for materials on donation basis (CiviCRM / WordPress)

texts:
We are new to CiviCRM and are looking for an easy way to enable the following:

Must have:

An interested person may order materials (e.g. postcards) and may promise to give donations for it
Verification email
The person and a person doing the shipping should receive an email

Nice to have:

Update of CiviCRM contact
Creating a activity for that contact
Possibility to do the donation with CiviCRM

From StackExchange research I got the impression that best way to do the "must haves" and 1./2. would be a best to use Caldera Forms + Caldera CiviCRM Plugin + Caldera Verify Form.

Is this the appropriate way to do it, or is there something easier (e.g. CiviCRM forms/profiles)?

Is it possible to include the donation from CiviCRM directly into such a thing? (It's not a shop function, where you have to pay, it should really be a donation.)


texts: Can form submissions dedupe and "fill" instead of "override"?

texts:
while deduping in a contact import, you can choose whether you want new data to "fill" or "override".
is there a way to enable this feature for a form submission?
example would be an event registration
if a woman already in civi named Cindy Weiner registers for an event with her email address that we have on file, but used "weiner family" for first and last names, or used an email address that we have as a secondary one, we want her submission to be matched to the contact we have on file with the same email address, but we don't want it to override any fields.
is there any way to accomplish this?
Follow up solution, which I think is very simple to implement:  Limit any given email address to one contact.  This would allow us to use very lenient dedupe rules for and always connect contacts.  You could add any address or phone number that doesn't match, as a secondary one.
What do you think?


texts: When importing activities can you use an external id?

texts:
Is there a standard way to import activities with an external identfier in the same way as contacts to help us identifiy what has been previously imported.

otherwise, I guess we would just have to create a custom field.


texts: Where is the documentation to upgrade CiviCRM under Drupal 8?

texts: As of now, there is official documentation for installing CiviCRM under Drupal 8, and there is official documentation for upgrading CiviCRM under various other CMSs, but I can't find any for upgrading under Drupal 8.


texts: How to Export/Import all CiviCRM data from one website to another one

texts:
I am recreating my website on another server. So my big concern is how to move all CRM data to new server/website.
To do separately exporting/importing contacts, membership, activities etc. is not so much accurate way, because there is a possibility of missing something.

Also I can't dump whole database. Is there any possible method, how can I do this??


texts: Date of birth -- months only show through September

texts:
Is anyone else having problems with date of birth only showing through September? I've found this on two different sites.

How would I go about debugging this?


texts: Error when executing Update Membership Statuses Scheduled Job

texts:
For some reason, the Scheduled Job for Update Membership Statuses has not been working on my site for some time. When I run it, I get the following error message:

Fatal error: Call to a member function delete() on a non-object in /home/neftempo/public_html/sites/all/modules/civicrm/CRM/Member/BAO/Membership.php on line 665

I just updated the site from 4.6.8 to 4.7.4 and the problem was not resolved.

Can someone please suggest how to resolve this problem - we need to update our membership statuses.

p.s. The site is hosted on a shared server, so I do not have access to the actual log files - hopefully the above provides sufficient guidance.


texts: Automatically create scheduled reminders for recurring events?

texts:
I modified an event template to include a scheduled reminder, but when I repeat the event (using the new recurring events feature), the scheduled reminder does not carry over.

Is it possible to create recurring events and all of them have the same scheduled reminder?


texts:
Survey creation is throwing "403 error - The Web server is configured to not list the contents of this directory or you do not have enough permissions to access the resource"

I am experiencing same error on multiple links of CiviCRM.
I am using CiviCRM4.7 on wordpress.


texts: Why can't I save draft in contact email?

texts:
I am not using CiviMail but trying to email directly out of a contact record. The only options available are "Send Email" or "Cancel". My agency needs to be able to save a draft to edit and send at a later date. Is this possible or am I missing something? It seems that CiviMail only uses groups. I need a function to save drafts from individual contact. Any input is greatly appreciated.

Thanks!
Erin


texts: 404 errors for loading CSS on Event pages (Wordpress)

texts:
I'm using a fresh install of Civi 4.7.15 on Wordpress 4.7.1

I can use the back-end of Civi fine, but when I try to load public pages - e.g. Event Registration Page, the page can't load the necessary CSS and JS files (hangs for a long time and then displays wrong).

I believe it's somethng to do with paths - my Wordpress install is at: http://mysite.org/mysite/wp-content

(but points to http://mysite.org/ as the default address)

When Civi tries to load the scripts, it looks for the files in http://mysite.org/mysite/mysite/

Changing the Base URL to just http://mysite.org/ fixes the public pages but breaks the back-end.

Is there somewhere I can change this behaviour?


texts:
On a 4.5 site running the most recent Drupal, I have to use the themekey module to make CiviCRM public facing pages use a different theme from the site default because of Bootstrap compatibility problems. (For admin stuff I'm using a non-bootstrap admin theme.)

The client really wants the public-facing part of the site to use the same bootstrap theme for all pages.

Is 4.6 have any better Bootstrap compatibility than 4.5?


texts: Can we enable deleting/modifying incoming emails?

texts:
the activities of type incoming emails seems to be hardcoded to not have the edit or delete button, even for admin.

Some of my users need to be able to delete it (eg. if it's a spam email) or edit it (if it's mangled somehow). Is there an option?

Would it make sense to write an extension to allow it? It isn't an issue of permission, as if you alter the url, you can still delete them

X+


texts: manual contribution entry not showing up on contacts contribution summary

texts:
I am brand new to CiviCRM :)  4.7.4
We are using WordPress for our website 4.6.1

I am trying to manually enter a contribution and/or a pledge as I am testing out the new  database with just a few contacts.
I am trying to add a contribution manually one by one to a donor that already
exists in the database.
Also did this with a pledge

Contact selected: Daffy Duck
Selected Contributions tab, then new contribution

Financial type - Campaign Contribution
Total Amount = 875.00 (US$)
Source = Board
Contribution status = Pending (since this is one of 4 payments to be made)

Soft Credit - N/A

Under Payment Details:
Received: March 24, 2016 Time: 10:00 a.m.
payment method = Check
Check no. = 9083
transaction id = blank
Receipt date = July 27, 2016 Time: 12:22 pm

Under Additional Details:
Non-deductible amount = $22.00
Fee amount = blank n/a
Net amount = 875.00
all other fields left blank

Hit the SAVE button and said contribution was saved to contact

But when I go to the Contributions or Pledge summary page for that contact it does not show any dollar amount for the contribution of $875 that I
put in.

the first column which should show the $875 only shows a blue Dollar sign ($)
with no amount.
Type "campaign contribution" and Source "Board" appear as they should

why is the amount not showing up?
Thank you for your assistance.
BB


texts: id (value: ) is not of the type Positive (WordPress)

texts:
using WP 5.4.2 - PHP 7.2 - CiviCRM 5.28
1/ I previously hab issue with CiviCRM Events's permalink: so  activate "Classic Editor" WordPress plugin to allows a link in a post to publish the Events's form
2/ I migrated the website to a new host + activate SSL + Upgrade CiviCRM to the last Release
First issue: the confirmation step of the booking event was no more display  and there was no registration= looking for the rrot cause I find that CMS integration was not correct so I added civicrm/ at the end of https://cycloclubbreuillet.fr/
So I get the Second issue : DB Error : constraint violation
I read some post hier and chech the wp-content/uploads/civicrm/civicrm.settings.php and the login information
So I created a new event and now the issue is:  id (value: ) is not of the type Positive
See below the debug information:

in line 90 of he file Request.php i FOUND THIS/
$value = CRM_Utils_Type::validate($value, $type, $abort, $name);
hope some can help, I could(not find the root cause


texts: Membership period with multiple terms not working in paypal payment page

texts:
I have a membership type A and B with following configuration:

no auto-renew option
duration: 1 month
period type: rolling
visibility: public

I set multiple price set, each price set have different price options for both membership type A and B.

For example:
Price set for location X:

1 month membership A
3 months membership A
6 months membership A
12 months membership A
3 months membership B

In each price option, the number of terms is set accordingly (1,3,6 or 12).

The problem I'm facing is:

When user filling in the CiviContribute form, select one of the price option and pay through PayPal, the membership end date does not follow the terms, and show end date as 1 month after payment date.

Example: User select "6 months membership A" and make payment, the membership end date is 1 month later, rather than 6 months.

I tried payment using test payment page and pay through paypal sandbox, the membership end date is 1 months later.

I tried make payment through "Pay Later" option, update payment status to complete through CiviContribute dashboard, and membership end date is 6 months later.

I'm not sure how to debug and what I can do to solve this. Any suggestion?

UPDATE: this issue was resolved (see Comment): "I upgraded CiviCRM to version 4.6.11 and it works. Thank you for your help!"


texts: I'm interested in creating workflow based on bulk email opens and click throughs.  Is this possible with CiviRules?  If no, is support for these events planned?


texts:
I've installed CiviVolunteer and have a public facing interest form at http://example.org/civicrm/volunteer/join

But all this seems to do is create a contact. It doesn't put the contact anywhere that we can easily find them to tell them of volunteer opportunities. Am I missing something?


texts: Is it correct that saving an address with only Country should fail to save data?

texts:
On Demo if you go to this record http://d46.demo.civicrm.org/civicrm/contact/view?reset=1&cid=202 and 'add address' or 'Edit' and save the Home Address with just Country (currently set to Default Country = Australia), nothing gets saved, no debug message either.

I tested on demo after witnessing what I thought was a problem with a Profile on a Contribution page, but the issue seems to be actually with the 'save contact' task.


texts: How to provide a default sort on a custom search?

texts:
There is a function helper

function all($offset = 0, $rowcount = 0, $sort = NULL, $includeContactIDs = FALSE, $justIDs = FALSE) {
  // delegate to $this->sql(), $this->select(), $this->from(), $this->where(), etc.
  return $this->sql($this->select(), $offset, $rowcount, $sort, $includeContactIDs, NULL);
}

But I'd like to set a sort order if not set. All the examples I found are writing directly their sql, as opposed to sql() that expect a CRM_Utils_Sort class (or that's what I understand based on the error messages)

So what I'd like to do is to add a

if (!$justIDs &&!sort)
   //how to initialise sort so it ends up like ORDER BY created_date)?


texts: What is the easiest was to prefill a field on a profile that is in create mode? I am linking from a drupal view where they click on the name of their organization and it will put the org name in the url. But i have been unable to use anything in the url to prefill the org name field on the profile.


texts:
How do I add a new menu item (i.e. after the standard item Contacts, Members, Administration etc) and page which would contain a login to our mail. (Mail will display on this page (the new menu)).

Someone can point me in the right direction?


texts: DB Error: constraint violation (WordPress)

texts:
I am trying to update an install from CiviCRM version 4.4.5 to the current version.

I was unable to because the WordPress site was using PHP 5.6.

So I installed CiviCRM 4.7.31, and then updated the server to PHP 7.0.

Now when I click the CiviCRM menu link in the dashboard, I get this:

DB Error: constraint violation


texts:
I've installed CiviCRM, and made sure my Drupal 8 role settings give Admins full permissions for CiviCRM.
I am able to create cases for constituents, but cannot do anything else such as add Activities, Timelines, sort/filter by status, or see whatever is behind the hamburger menu beside the status, access the settings on the Activities tab, etc.
On the Summary tab there is a "Tasks" section but from the documentatio, I don't know what that's for and I don't see any option to add a task.


texts: how to display civi's navigation menu on custom page (eg Drupal view path)

texts:
If I create a page (like a view in Drupal) I can add a link to it in Civi's Navigation Menu.  But then you go to that page and the Navigation Menu disappears.  The path for that page is /civicrm/something-custom but apparently starting with civicrm/* doesn't automagically display the menu.  How can I make the menu appear on custom pages?

A method via code (hook_something would be better than hack_something) would be sufficient, as I don't see any options in the UI at civicrm/admin/menu.

The docs list a hook_civicrm_navigationMenu but it sounds like it only alters the menu itself, as opposed to allowing me to display it when it's not otherwise displayed.

I did a grep through the codebase for civicrm-menu and sites/all/modules/civicrm/templates/CRM/common/navigation.js.tpl looked the most promosing but wasn't enlightening itself, then I saw that sites/all/modules/civicrm/CRM/Admin/Page/AJAX.php prints that file inside of a public static function getNavigationMenu() and there's a comment for that function @see smarty_function_crmNavigationMenu.  But searching the web doesn't yield any results on invoking these functions in custom code.

Surely this has been done before... right?  Is there a proper method for doing so?


texts:
I'm trying to get civi to run on Ubuntu xenial and drupal7. I installed the php5 repositories as per: https://askubuntu.com/questions/761713/how-can-i-downgrade-from-php-7-to-php-5-6-on-ubuntu-16-04

I successfully upgraded my database to 4.7.7 but then I get stuck on a screen that shows the following:

localhost
Error
The website encountered an unexpected error. Please try again later.
Error message
CiviCRM_API3_Exception: DB Error: no such field in civicrm_api3() (line 45 of /usr/share/drupal7/modules/civicrm/api/api.php).

Not sure if it has something to do with the access_compat errors I was getting while installing, things like this in my apache 2 error.log
[Tue May 17 14:22:54.236734 2016] [access_compat:error] [pid 32145] [client 127.0.0.1:35040] AH01797: client denied by server configuration: /usr/share/drupal7/sites/default/files/civicrm/ConfigAndLog/CiviCRM.63a720ea8e0f63f2f91fb59f72af16dc.log

Any leads appreciated!


texts: Default value for a (non-custom) profile field

texts:
Is there a way to set a default value for a (non-custom) profile field - that would get pre-populated when the page with the profile opens?
Cheers


texts:
How to define "informal" or "formal" communication style?

That is, how to link the informal (1) email and (2) postal greetings, and (3) address layout to the informal style, idem for the formal style.

Or is another method to be used? Now, i can only customize the three items, rank them for priority, but cannot define them as "formal" or "informal"


texts:
The parameters in the API are confusing, especially the depth + the json paramter.

I have seen these three combinations and my question is, which variant is wrong and which is not.

I can't figure out from the results what exactly is going on as most of my queries don't yet return what I'm expecting, so I want to get this clear first. I think Civi has some kind of fallback magic as in some requests I get undefined_fields but it returns correct results.

Entity related stuff goes into the root level, as seen in different (inofficial) files:

{
  'api_key': '...',
  'activity.id': 123,
  'json': {
    'options': {
      'limit': 1
    }
  }
}

The API Explorer suggest entity/attribute related stuff goes inside the json parameter:

{
  'api_key': '...',
  'json': {
    'activity.id': 123,
    'options': {
      'limit': 1
    }
  }
}

Variant without nesting and json beeing integer as seen on https://docs.civicrm.org/dev/en/latest/api/usage/ :

{
  'api_key': '...',
  'activity.id': 123,
  'limit': 1
  'json': 1
}

P.S I'm accessing the REST API via HTTP calls to /sites/all/modules/civicrm/extern/rest.php.


texts:
I have no problem printing my contact group mailing labels, however is it possible

to only print a full sheet of mailing labels for a single contact?

Any assistance appreciated.


texts: Mail Merge Codes per Price Set Option (Name Badges)

texts:
We would like to print name badges for our events using CiviCRM.

However, we use complex price sets, and we use "Codes" printed on our name badges for access to certain events.

Is there a way to use CiviCRM to merge price set options onto name tags?

We ended up using Excel and a lot of complicated formulas.

However, if every price set option could have a "Name Badge Code" field, and we could print those on the CiviCRM Name Badge, or even just export them in a price set report, that would substantially reduce our efforts.

Anyone ever face this issue?


texts: Add dupe check parameter to an API call - Contact Form 7 plugin

texts:
I've installed the Contact Form 7 CiviCRM integration plugin, and it works fine.

I'm just wondering how to add a dupe_check parameter.

If I try something like:

contact_type=Individual&source=SitoWeb

it works.

But if I add:

contact_type=Individual&source=SitoWeb&dupe_check=1

it doesen't.

Here's the section where I have to add those parameters:

Without dupe_check the same contact could be added X times for X times he/she submits the form.

Thank you.


texts: Updating Repeated CiviEvents in 4.7 and 5.0

texts:
Having an issue updating details of recurring events.

This is happening on a clients site (was happening in 4.7 versions and still occuring after upgrade to 5.0)

Have just recreated issue on sand box

1) Create event with 12 weekly repeats
2) Add event custom data
3) I can update the custom fields in one event instance, and get the dialog box to update all/ future events. If I select to update all events I get a confirmation notice that the event has been updated. But when I look at future events the changes haven't been saved there only on the event instance editted.

Has anyone seen anything like this before? Know of a quick fix

Not sure if it's related to issues raised here or not
Backbone javascript conflict causing Configure Event / Repeat to fail

Conversely, when they set the event each session had a £20 session fee. They want one session to have a £25 session fee.

When they update the specific session fee tab and select update only this event, on saving fees for all events are updated.

I've  been able to recreate that in sandbox also. Add a fee for the first event instance, and create recurring events.

Updating a fee in a later event instance, and saving this event only updates fees for all instances.

The client was using repeat events in their 4.6 install, and apparently these features worked fine. I've not used repeat events myself that much so have no experience prior to this.


texts: Thousands of new contact records created from CiviMail (Postfix/Gmail?) mis-configuration

texts:
I have read documentation, but still am having a hard time understanding how I should change my configuration to fix this issue, esp. without causing other problems. Basically all seems to be working OK including CiviCRM tagging contact email addresses as non-deliverable (on hold). The issue I am having is CiviCRM is creating thousands of contacts each week with an email like civimail+b.4172.482888.045236909fb52f54@watershedmg.org. Each one is connected to a contact called (Mail Delivery System) through an activity. The activity type is "Inbound Email" and the subject is "Undelivered Mail Returned to Sender".

We are using Sendmail() to send bulk emails to our members and supporters, usually these number in the 1000s per week. We have a catchall@ email address that is seemingly working correctly to handle bounces. Here is our Mail Accounts setup.

Should I just delete the "default" email-to-activity entry since we don't use that feature? Is it needed for something other than "email-to-activity"? I seem to recall an email tech contractor telling us it was important for something that I don't recall.

All contact records that are created have civimail+b(...) and not catchall+b(...) even though the created contacts seems to be related to bounce emails coming to catchall@ email with "MAILER-DAEMON@watershedmg.org" as the sending email.

Any help is greatly appreciated.

As a side note is it bad to use Sendmail to send 1000s of emails vs mail()? That is how it has been set up for many years and I see now it says it's only kept around for older version of CiviCRM. It seems to be working OK.

(Drupal 7, CiviCRM 5.5.1, Debian 8, PHP 5.6, Postfix)


texts: Memberships - Renewals and grace periods

texts:
I seem to remember doing this in the past, but can't recall how I did it.
We need a membership where:

it's one price to join
one price to renew during the grace
one price to renew after the grace


texts:
Is it possible to, or are there plans to, add the following to CiviBooking:

Facility to support custom fields on CiviBooking entities such as Resources?
Facility to allow partial payments for a resource, with partial payments from different contacts?

Other questions:

Does anyone have a concise explanation for what a Resource Configuration is?


texts: Form to partially pay for Event Attendance

texts:
I want to create a payment form to allow users to pay towards someone's event attendance.

Given a Contribution ID, how can I create a link to a page that will accept payments towards that Contribution?

Do I have to do this through Personal Campaign Pages, or is there a way without that overhead?

JohnFF


texts: Can you save an advanced activity search?

texts:
After using Advanced Search to create a pretty detailed search on activities, I need to save it.  If my search results were contacts, I could create a smart group based on the search which would essentially make the search permanently available as suggested here: Saving Advanced Searches for later use

However, my search is on activities and displays activities.  I need to perform this search frequently and there is no corresponding tool like smart groups for activities.

I also need to be able to use the Batch Update Activities by Profile action on the search results which precludes me from simply creating a report and saving that.


texts:
I am unable to use datepicker with popup forms enabled - calendar does not appear active on top of the form but underneath (discovered after reducing and moving the form around). It works with popup forms disabled. Help, please!

.

Using WP 4.7.3, CiviCRM 4.7.17


texts: How to suppress translation of months (or all fields) in receipts?

texts:
My platform: CiviCRM 5.16.3 on Drupal 7.6.7 PHP 7.2 CentOS 7.
Drupal language is English.
CiviCRM l10n installed and selected my own languange zh_TW Chinese(Taiwan).

At receipt print-outs CiviCRM does all the translation it could, but I want the English version of dates e.g. Sep by %b, not my local language. (Because English dates are more universally understood.) In particular, how can I suppress translation at particular Smarty tag e.g. {$receive_date}?

If translation cannot be suppressed for some fields can I suppress translation for the whole printout?

I cannot find any trace of Month names translation in Drupal or CiviCRM localization files.

Thank you for your help.

Best Regards.


texts: Post Patterns, Adding Custom Fields to Subject Area

texts:
Post Patterns, I Want To Add Custom Data To The Subject Area.
By info "Custom tokens (based on custom data) can be added for organizations as well. These tokens will not be displayed in the list of available tokens, but can be added manually. The format is {contact.custom_12} – where 12 is the ID of the custom data field. To find the custom data field ID, go Administer > Customize Data & Screens > Custom Fields and click ‘edit’ on the field you want to use. Look at the URL. The last part of the URL will be an equal sign and a number (=12). The number (12 in this example) is the id of that custom field." I reached the ID number 8 with this method and I made experiments by adding many options to this information and adding sub-options to its individual or content. The e-mail sending does not receive the information I added to the activity. Only the code I added appears in the mail. Is this a problem or I just can't.
How I Do It.
"Administer > Customize Data & Screens > Custom Fields" I'm logging into the department.
Then I get the code that is in the URL. =8

Then I log in to the "Cases - Send Copy of an Activity" section, add {contact.custom_8} at the end of the Subject field and save.

The result is as follows. I dont want this. I want the data I added to the ID to be output.


texts:
We sent out a pre-event bulk email to all event attendees on Nov 3. Today, we were informed by someone who just received their email today (Nov 30 - I can confirm in her message header that it arrived to her mailbox Nov 30, it wasn't that she just didn't see it until today). The Mailing Report lists that the mailing was successfully delivered to all 175 recipients, and that the start date was Nov 3, and the ending date was Nov 30.

Why in the world would it take nearly 4 weeks to complete a mailing to 175 individuals? How can we tell if it was just this one individual who didn't receive it until today? (The Activity includes the start date of the bulk email, but not the date that the activity was completed for her.)

Edited to add:

Now that I can find the reports, I see that the entire list didn't receive the mailing until yesterday.

Looking into the job scheduling and logging, I discovered that the job has been starting as scheduled every 15 minutes. However, the job log does not show that the job has finished executing until the time stamp that the mailing actually went out yesterday. SO... would this have been a problem with the server rather than with civi? Is there a way to get warning notices if a mailing hasn't completed within a certain amount of time so this doesn't surprise me (or less technically minded colleagues) later?

Further edit:

In an exchange with my hosting support (civihosting.com), we've decided that since it is working now, we won't pursue it to determine the reason. Kudos to anyone who can think of more information, though.


texts: After update, emails have to be written out in full html!

texts:
We updated CiviCRM and the next time I tried to email a contact, I found all the buttons to insert bold, hyperlinks etc. had disappeared and the only option seemed to type it all in manually, even including the <p> </p> at beginning and end of paragraphs! Same thing when I looked at the mass mailing function. Is this a bug, deliberate, or some weird problem that only we have?
Many thanks


texts: Upgrade from Drupal 7/ CiviCRM 4.6.38 to Drupal 9 / CiviCRM 5.37.2

texts:
Good morning ladies and gentlemen,
I would like to upgrade my old installation of CiviCRM on an old system (Drupal 7, CiviCRM 4.6.38 ) to an up to date system like Drupal 9 / CiviCRM 5.37.2. Are there any suggestions how to do that including migration of all data? CSV export?  Mysql-dump (which tables?). I am very open minded (Wordpress instead?) and experienced hacking the shit out of my system. Just looking for a best practice solution.
Thanks for your help,
Robert


texts: Scheduled Reminders generates faulty SQL

texts:
CiviCRM 4.7.27
Usually, our CiviCRM guru handles these, but I figured I would ask a wider audience.

When choosing date instead of an interval, the scheduled reminder fails with a DB syntax error. The error is in the " DATE_SUB(, INTERVAL hour))" part of the SQL.

The first argument to the function is missing and the time component for the interval is missing: (see below in bold). I would imagine this is a bug.. The SQL from the logfile:

Here's the SQL that is created by CiviCRM and fails:

SELECT e.contact_id as contact_id, e.id as entity_id, "civicrm_membership" as entity_table, 3 as action_schedule_id, MAX as latest_log_time
FROM civicrm_membership e
INNER JOIN civicrm_contact c ON c.id = e.contact_id AND c.is_deleted = 0 AND c.is_deceased = 0
INNER JOIN civicrm_action_log reminder ON reminder.contact_id = e.contact_id AND
reminder.entity_id = e.id AND
reminder.entity_table = 'civicrm_membership' AND
reminder.action_schedule_id = 3
WHERE (e.membership_type_id IN ("21")) AND (( e.is_override IS NULL OR e.is_override = 0 )) AND (e.status_id IN (5, 2, 9, 10, 4, 8))
AND ("20171108110009" <= DATE_SUB(, INTERVAL hour))
GROUP BY reminder.contact_id, reminder.entity_id, reminder.entity_table
HAVING (TIMESTAMPDIFF) >= TIMESTAMPDIFF))

NOTE: There are missing parameters in the DATE_SUB function, the SQL fails and the scheduled reminder does not go out.


texts: Drupal CiviCRM Menu not full length (shoreditch and otherwise)

texts:
I upgraded three sites today.

Site 1 - Already had Civi 5.6 - updated to Drupal 7.60 and Shoreditch (SD) Alpha26. Result: CiviCRM menu is not full length.

Site 2: Updated from SD 25 to 26 - and to Drupal 7.60 - No issues - Was civi 5.3, upgraded to 5.6 - Result: Civi menu is not full length.

Site 3: Updated to Civi 5.6 and SD 26 - Wordpress site - no issues.

I do not think this is a Shoreditch issue, rather there is a menu issue between Civi 5.6 & Drupal 7.6.

Could this be related to this Drupal 8 change?


texts: How Can I Attach a PDF Certificate for a Membership Payment?

texts:
On Drupal 7.35 / Civi 4.4.14 - is it possible for a membership payment via CiviContribute to e-mail a membership certificate as a PDF as an attachment to a receipt?

What we currently do is print membership certificates and post them, however the intention is to move to e-mailing them. I already have the template certificate stored as a mailing message template which comes out nicely when printed on A4.


texts: Compilation error when installing on Drupal8

texts:
Following install guide I get fatal error at compilation tasks in composer require civicrm/civicrm-core:'~5.35'.
The setup is on Aegir with Drupal 8.9 and drupal/recommended-project composer template, having a relocated document root.
Is this error related to the setup above, or it's CiviCRM related?
Error log:
Compiling additional files (For full details, use verbose "-v" mode.)
Compile: Generate CCL wrapper functions
> @php -r 'require_once '\''/var/aegir/platforms/d8.9.13/vendor/autoload.php'\''; Civi\CompilePlugin\TaskTransfer::import(); \CCL\Tasks::template($GLOBALS["COMPOSER_COMPILE_TASK"]);'
WARNING: Failed to read compilation-task from COMPOSER_COMPILE_TASK. Please use "composer compile".
PHP Fatal error:  Uncaught InvalidArgumentException: Invalid file reference (tpl-file=NULL) in /var/aegir/platforms/d8.9.13/vendor/civicrm/composer-compile-lib/src/Tasks/Template.php:62
Stack trace:
#0 /var/aegir/platforms/d8.9.13/vendor/civicrm/composer-compile-lib/src/Tasks/Template.php(21): CCL\Tasks\Template::assertFileField()
#1 /var/aegir/platforms/d8.9.13/vendor/civicrm/composer-compile-lib/src/Tasks.php(24): CCL\Tasks\Template::compile()
#2 Command line code(1): CCL\Tasks::template()
#3 {main}
  thrown in /var/aegir/platforms/d8.9.13/vendor/civicrm/composer-compile-lib/src/Tasks/Template.php on line 62
Script @php -r 'require_once '\''/var/aegir/platforms/d8.9.13/vendor/autoload.php'\''; Civi\CompilePlugin\TaskTransfer::import(); \CCL\Tasks::template($GLOBALS["COMPOSER_COMPILE_TASK"]);' handling the shell-runner event returned with error code 255
Subcommand @composer compile  returned with error code 255

Installation failed, reverting ./composer.json to its original content.

In ComposerPassthru.php line 72:

  Subcommand @composer compile  returned with error code 255


texts:
We're running 5.10.4 on Drupal. We have an event where some folks will be requesting a scholarship and therefore need to be able to choose a $0 option. We also have an optional field where people can put in the amount they want to donate towards the scholarships. However, people cannot submit the page unless they have at least $1 in event fees.

https://www.zendust.org/civicrm/event/register?reset=1&id=283


texts: Drupal views, show 'add to cart' button instead of ''Register now'

texts: I would like show 'add to cart' button instead of ''Register now' for a drupal views I have created for upcoming events, is it possible?


texts: Allow WordPress Users To Edit Own CiviCRM Record

texts:
I think I am missing something simple. I would like for a user to be able to edit their own CiviCRM record after logging into WordPress.  I have used a Short Code for the dashboard but there is not an edit link on the dashboard.  I appreciate the help in making this work.

Thanks,
Steve


texts:
On Civicrm 5.13.4 on Drupal 7.67 I have this error when accessing to the Localization page:

Notice : Undefined index: addLanguage dans l10nupdate_civicrm_buildForm() (ligne 53 dans /sites/default/files/civicrm/ext/com.cividesk.l10n.update-master/l10nupdate.php).
Notice : Undefined index: lcMessages dans l10nupdate_civicrm_buildForm() (ligne 53 dans /sites/default/files/civicrm/ext/com.cividesk.l10n.update-master/l10nupdate.php).

How should I fix this? (.php is not my best)


texts: Adding repeating event registration shortcode in wordpress

texts:
I added my repeating weekly event registration to my wordpress post using [civicrm component="event" id="XX" action="info" mode="live"].
I would like people to register every week for the event.
Is there a way to make the post update automatically to the next week's event (as each event has a new event ID) or do I need to update the event ID each week?


texts: I have custom fields underneath a relationship type that I want to restrict to view only or entirely remove if they are not a specific user. I can make the permissions work so the issue is load order I think. My jQuery code in Relationship.extra.tpl loads before the custom fields appear. I suppose my answer lies somewhere here https://docs.civicrm.org/dev/en/latest/framework/ajax/ but any pointers to get me in the right direction?


texts:
(I use CiviCRM with Wordpress, so I can't use the Drupal/CiviCRM contact form integration.)

I am trying to create contact forms for my website. I feel like using Profiles is the best way to do this, but I can't figure out how to have a "message" field where the user can write their message to submit. I can get the name, email fields into the profile fine, but there seems to be no way to give them a space to write an enquiry. "Notes" is the closest thing, but their old notes would be overwritten so it would not be ideal.

Is there some way to include an enquiry form with a Profile?


texts: Civimail Urls don't load and show Could not load the settings file at:

texts:
We have setup CiviCRM to run as part of an installation profile. So instead of the default sites/all/modules folder, CiviCRM is installed in profiles/ourprofile/modules/contrib/civicrm.

CiviCRM works perfectly and so we have had no issues. However, when testing an email campaign I keep getting this error message

  Could not load the settings file at: (followed) by a path to civicrm.settings.php file.

Nothing loads and the links don't work. I read a few comments on Github that there is a similar issue for multisite on CiviCRM. However, this is a single site and I am not sure what do next as there is not much information on how this can be fixed.

I know the easiest solution is to move CiviCRM to the sites/all/modules folder. However, this will make it harder for us to maintain versions for CiviCRM as part of our profile.

Any advice is appreciated. Thanks.


texts:
We created and event without problem however once someone clicks the Register Now buttom on the page the following message is seen. I am running version 5.9.0

Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to member your administrator or service provider with more details about what action you were performing when this occurred.
You do not have permission to access this page.

Return to home page.

The full error trace is below please help.

**BACKTRACE**
#0 /var/www/html/sites/default/files/civicrm/ext/ca.bidon.reporterror/CRM/ReportError/Utils.php(31): reporterror_civicrm_generatereport("Jamaica Teachers Association", (Array:2), NULL, (Array:0))
#1 /var/www/html/sites/default/files/civicrm/ext/ca.bidon.reporterror/CRM/ReportError/Handler/FormsNoReferer.php(54): CRM_ReportError_Utils::sendReport((Array:2), (Array:0))
#2 /var/www/html/sites/default/files/civicrm/ext/ca.bidon.reporterror/reporterror.php(168): CRM_ReportError_Handler_FormsNoReferer::handler((Array:2), (Array:0))
#3 /var/www/html/sites/all/modules/civicrm/CRM/Core/Error.php(368): reporterror_civicrm_handler((Array:2))
#4 /var/www/html/sites/all/modules/civicrm/CRM/Event/Form/Registration.php(265): CRM_Core_Error::fatal("You do not have permission to access this page.")
#5 /var/www/html/sites/all/modules/civicrm/CRM/Event/Form/Registration/Register.php(107): CRM_Event_Form_Registration->preProcess()
#6 /var/www/html/sites/all/modules/civicrm/CRM/Core/Form.php(585): CRM_Event_Form_Registration_Register->preProcess()
#7 /var/www/html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(92): CRM_Core_Form->buildForm()
#8 /var/www/html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Event_Form_Registration_Register), “display”)
#9 /var/www/html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Event_Form_Registration_Register), “display”)
#10 /var/www/html/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("display")
#11 /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php(309): CRM_Core_Controller->run((Array:3), NULL)
#12 /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:15))
#13 /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#14 /var/www/html/sites/all/modules/civicrm/drupal/civicrm.module(445): CRM_Core_Invoke::invoke((Array:3))
#15 /var/www/html/includes/menu.inc(527): civicrm_invoke("event", “register”)
#16 /var/www/html/index.php(21): menu_execute_active_handler()
#17 {main}


texts: Events Dashboard: Role-based count assumes only one role per participant?

texts:
After some testing I've come to the conclusion that even if all of the participant roles are set as 'counted', if you give any participant more than one role (e.g. the might be a 'host' and a 'speaker') then CiviCRM does not include them in the count, or to be precise it includes them in the 'Not Counted Due to Role' number that is displayed on the Events Dashboard.

This also then breaks the Max Participants setting in the event configuration, enabling continued online registration, giving rise to potential venue capacity issues.

Given that it is both do-able and sensible in many use cases to apply multiple roles to event participants (I certainly have at least one client that makes extensive use of the ability to apply multiple roles to event participants), I would consider this to be a bug.


texts: Displaying the full state or County name in Profile Listing

texts:
I'm sure there is a simple solution to this that I'm missing - I have a custom profile that I'm setting up as a searchable directory that has a number of address fields displayed in the results
Country, State, city. - Home
Country, State, city. - Work
Country, State, city. - Other

The State field is returning as an abbreviation, or in the case of somewhere like France - a number.
Is there a way to display- (or retrieve given the returned value ) the full state name?


texts:
I have setup a webform to process membership renewals via a checksum. When the user pays they are sent a pdf invoice which is missing information such as description, quantity and unit price (see attached screen capture).

However, the correct PDF invoice is sent when I select the following:
Home » CiviCRM » Administer CiviCRM » Manage Contribution Pages » Receipt » Tick Email Receipt to Contributor?

The issue with this is that Civi will also send the email with the missing information.

Does anyone know how I can get the correct information to display on the first email? Or to stop 2 emails being sent when: Email Receipt to Contributor - is selected?

All message templated are default. CiviCRM 5.26.1. Drupal 7.71

Edit: Second screen capture of desired outcome.


texts: Fee level missing for booked participants using price-set

texts:
For our annual conference I have created a price set for the tickets. These have been working ok but now I am looking at reports I've noticed that the tickets are all grouped to the booker's profile and the 'fee level' and amount to the other booked participants is blank and at 0. This means that I do not actually know who is booked onto which day.

For example - see below screen shot:

Anne Marie Nicholson has made a booking for her and three of her colleagues. 3 are for our one day conference and 1 for our Day 2 conference but everything is grouped to Anne Marie's profile with no info (other than the event name) as to which the other 3 colleagues are attending.

Is there a way around this in price-sets? I have looked at the editing options but can't see anything.

Thanks, Katie


texts:
I think there is a typo on line 692 of
wp-content/plugins/civicrm/civicrm/packages/Net/SMTP.php

mMethod should be method in the last line below, yes?

if (is_array($callback)) {
            if (!is_object($callback[0]) || !is_string($callback[1]))
                return PEAR::raiseError('Bad mMethod callback array');
        }

Should I fork the civicrm-packages repository, make the change there and submit a pull request?

Or is CiviCRM getting this code from elsewhere, and it would be more useful to make the change in the original source repo?


texts: Additional images in mailing using Mosaico

texts:
I have composed e-mail using Mosaico and everything looks fine.
But, when I sent the mailing, I see two missing image placeholders in head and in the footer. I cannot realize why. I did the investigation, and find out that there are some old images from the previous mailing. Have you any ideas, please?


texts:
Looking for a way to have follow up alerts after a donation is received.
e.g. If no custom activity "Sent Receipt", alert admin with email or have alerts on dashboard

Any suggestions on how best to do this.

Tks
Alan

Wordpress & CiviCRM latest versions


texts: Best strategy to restoring backup by importing csv file

texts:
Running CiviCRM latest on Joomla latest, Dutch translation, locally on Windows 8.1 and xampp, online with hosting; Joomla and CiviCRM installed and working. Now I would like to backup the complete installation.

I exported all of my 2000 contacts to a CSV file. I am trying to import the 2000 contacts from the same file, on localhost as well as online.
The first step is successful, CiviCRM adds the first row as labels, the second row with data. The second step, creating the mapping the labels fails for all.  After the mapping I get an error on all contacts, so no contact is imported at all.
If I choose to import only the obligatory * labels, names, mail, CiviCRM imports only those.  So I end up with only the contacts and have to do the rest manually (no email, no bulk, etc.)

Is the order of the importing columns in the CSV important? So, first column = name, second colum= mail etc?
Is the translation in Dutch causing problems mapping?
I tried to edit the CSV with open office and saving in utf8, the same problem; does the file change after editing in such a way that importing is a problem?
is it possible to backup by exporting the database to SQL file and if needed restoring by uploading the same SQL again with PHPMyAdmin?

Thank you


texts: Unsubscribe URLs in emails being altered by firewalls

texts:
We are experiencing a significant number of links in our emails being altered by email firewalls resulting in recipients experiencing peculiar unsubscribe form behavior that is troublesome.  For example, one firewall product replaces any email address in our unsubscribe URLs with mail=nobody@mycraftmail.com.
Has anyone explored an alternative method for unsubscribe links that works well?  We are considering using cid and checksum, but the form won't work once the token expires.  We are using CiviCRM 5.21.3 on Drupal 7.73.  Thanks for any suggestions you may have.


texts: Mailing Bounces 100% with "authentication failure" or "failed to set sender"

texts:
I have some issues with sending out mailings (used to work, now it doesn't anymore). My mailing is failing 100% with a combination of the following errors:

authentication failure [SMTP: Invalid response code received from SMTP server while sending email. This is often caused by a misconfiguration in Outbound Email settings. Please verify the settings at Administer CiviCRM >> Global Settings >> Outbound Ema
Failed to set sender: b.1139.33843.cb2d344bc94b0533@myserver.com [SMTP: Invalid response code received from SMTP server while sending email. This is often caused by a misconfiguration in Outbound Email settings. Please verify the settings at Admi

Regarding the Administer CiviCRM >> Global Settings >> Outbound Ema settings, I have checked these copious times and have verified that they work using the "Save & Send Test Email" function. This for both the mail() and SMTP settings.

I have also tested the actual mailing settings by sending a test to one of my email addresses. This works 100% - which would indicate that the mailing test function uses a different approach to the actual mailing component (this does not make sense for me as it will result in inconsistent results).

Now more to the actual errors:

No idea what's wrong, as the tests pass.
I thought this was a part of the VERP option (server changes the email address) - the SMTP does not recognise the email address and does not allow sending.

When using mail(), the mailing is successfully sent, but most of the emails fall into the very dark hole of the internet - and the ones that get delivered are mostly sent to spam. This is because the reverse DNS look up for my domain is not the same as the IP of my server.

When using SMTP the SMTP server does not recognise the email address I am sending from. And yes, I have switched off the VERP function (I think).

Any ideas what else I can do to get closer to fixing this?


texts: Paypal Pro, Does not autofill the Billing block if used postcode search. Where the problem is?a

texts:
I am using civipostcode extension with my Paypal pro Processor. https://github.com/veda-consulting/uk.co.vedaconsulting.module.civicrmpostcodelookup

When I search and select a postcode from the result on a contribution page, although I have selected "My Billing address is same as Home Address", it does not get autofilled.

But If I manually type home address fields it works perfectly fine!!

Can anyone give me a hint please, where the problem may be? in the Extension or in Core or Settings in my server? So I can submit a bug fix request accordingly. Thanks


texts: Drupal-8 / Civi 5.32 -- In D8 I see some civi blocks for me to use. Where are they defined?

texts:
I've been spending a lot of time in the Civi galaxy learning the ropes.  Now I am moving back to the drupal galaxy.  I know they reside in the same universe and there are some blocks pre-built to expose Civi to Drupal.
Users are one area with overlap.
But Views...  I see some pre-built civi views for me to place in Drupal.  Where are they defined??
There is a pre-built view for upcoming events and I would like to tweak that to only show upcoming events where event type ==x.
Any help would be appreciated!
Thanks


texts:
I'm developing my first extension and I'm looking the way to insert an image in a form.

Can anyone give me suggestions?

Thanks
Marcello


texts: How to allow contributions from non-members

texts:
This has got to be easy, but I am stumped.

I have set up several contribution pages. They work just fine as long as the donor is logged in to civi.

However, if the donor is not logged in, the system takes their credit card information on the form but when you press the contribute button, it blanks the form and does not continue on with the contribution process.

I assume that Civi allows unregistered users to contribute.

I am using Civi 4.6.9 on Drupal


texts: Edits not saving in Case Activity Tab since 4.7.4 upgrade

texts:
If I edit an activity (eg the date or the status) in the Activities tab of the Manage Case page, I get the confirmation message "[activity name] saved". But the edit is not saved.

This problem only appeared after upgrading to 4.7.4. There are no JS errors, no errors on CiviCRM log, no php errors.

Running Joomla 3.4.8. I can't test on the demo, because it's still on 4.6.

Edit: just tried the Wordpress demo, and the problem is present there as well.

Any suggestions where to look for the problem? Thanks.


texts:
Starting from a contact ID, i need to find all the groups to which the contact belongs.

I know that i can use api GroupContact but it doesn't work for smart groups (in CiviCRM 4.5)

Is there any api calls that will retrieve all groups at once ?
Otherwise, what would be the best way ?


texts:
I'm using civiCRM 4.6 Wordpress 4.1.5 hosted on Bluehost.

Can you upload images to mailings via image properties>upload>send to server?

This seems to navigate to page that doesn't exist and the image does not get uploaded.

If you go to image properties > browse server it just navigates to this page: http://lmysite/wp-content/plugins/civicrm/civicrm/packages/kcfinder/browse.php?cms=civicrm&type=images&CKEditor=crmUiId_1&CKEditorFuncNum=3&langCode=en and says page not found (with my header and footer).

I think my directories are correct.
image upload url: http://mysite/wp-content/plugins/files/civicrm/persist/contribute/

resource URL: http://mysite/wp-content/plugins/civicrm/civicrm/

And my civicrm.settings:
$civicrm_root = '/serverpath/public_html/wp-content/plugins/civicrm/civicrm/';
if (!defined('CIVICRM_TEMPLATE_COMPILEDIR')) {
define( 'CIVICRM_TEMPLATE_COMPILEDIR', '/serverpath/public_html/wp-content/plugins/files/civicrm/templates_c/' );
}

I don't know if this is also related to another unresolved problem I have to do with mailings: Why do 'track click through' links not redirect to correct address?

This seems to be related but is for Joomla: https://civicrm.org/blogs/kurund/enable-image-uploads-and-server-browsing-for-ckeditor

This is a similar problem but the conclusion is unclear: http://forum.civicrm.org/index.php?topic=30066.0


texts:
We want to use Events functionality in Civi CRM . As part of our requirement we need to provide attendance for tracking.

Is there a way to track attendance of event participants ?


texts:
Given that a contact may have a number of email addresses, what happens if one of them are on hold (bounce) when that contact is to receive a mailing?

There may be a number of scenarios here, I suppose, depending on if one of them is marked specifically for use for mass mailings.

Does another address get used? If so, even if a special mass mailing address was indicated?


texts:
Is there a list of tokens that are available anywhere? Is it stored in some db table I haven't seen?

CiviCRM 5.20.2 on Wordpress


texts: Error on Contribution Page with Google Simple Calendar Plugin

texts:
I'm about to make a contribution page live on a WordPress site that uses the Google Simple Calendar plugin, and when I go to the live contribution page link I get this error:
[Sat Nov 03 19:33:53.941951 2018] [proxy_fcgi:error] [pid 21601:tid 140699219515136] [client X.X.X.X:XXXXX] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Error: Class 'Carbon\\Carbon' not found in /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/google-calendar-events/includes/functions/shared.php:230\nStack trace:\n#0 /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/google-calendar-events/includes/functions/shared.php(155): simcal_get_calendar_names_i18n('month', 'full')\n#1 /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/google-calendar-events/includes/calendars/views/default-calendar-grid.php(143): simcal_common_scripts_variables()\n#2 /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/google-calendar-events/includes/assets.php(126): SimpleCalendar\\Calendars\\Views\\Default_Calendar_Grid->scripts('.min')\n#3 /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp-hook.php(286): SimpleCalendar\\Assets->load('')\n#4 /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters(NULL, Array)\n#5 /opt/bitnami/apps/wordpress/htdocs/wp-includes/plugin.php(453): WP_Hook->do_action(A...\n', referer: https://jeffcodemocrats.com/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fadmin%2Fcontribute&reset=1

When I disable the Simple Calendar plugin the contribution page works fine.

I'm not sure if that's just a general conflict with that plugin such that this won't work, or if there's something else going on that someone might have run into before. Thanks for any ideas anyone has.


texts: EXACT search on a custom field instead of LIKE

texts:
How do I do an EXACT search on a custom field – so instead of ending up with “LIKE” %Eastern Metropolitan%, in the search results I have an EXACT match?

I tried “Eastern_Metropolitan” “Eastern-Metropolitan” but I still get this result (with the word LIKE) - i.e STATE_UPPER_HOUSE Like %Eastern_Metropolitan% - which shows “South-Eastern” and “Eastern Metropolitan” also.

Here is how do the search

Advanced Search
•   Address Fields: Australia + Victoria
•   CUSTOM Fields - ELECTORATES:  State_upper_house = “Eastern Metropolitan”
After exporting the file and reviewing it we notice 2 things:
a.  The list contains contacts with state_upper_electorate as “South-Eastern” and “Eastern Metropolitan”
b.  There is an error on the first row of the .csv which not sure what this means;

Warning:  strpos(): Empty needle in /home/righttolife/www/www/administrator/components/com_civicrm/civicrm/CRM/Export/BAO/Export.php on line 621


texts: Change the permissions to access Volunteer tab in CiviEvent

texts:
I have found out that the Volunteer tab within CiviEvent needs 'edit_all_events'. However, I do not want people editing events they did not create.

Where in the code could I find and adjust this permission? I'm looking here https://github.com/civicrm/org.civicrm.volunteer/blob/master/volunteer.php but have not found it.

I do have permissions set so this same user role can create and manage civivolunteer projects but it would be best if they were created with the event as the associated entity.

Relevant CiviEvent Permissions:

CiviEvent: access CiviEvent
CiviEvent: edit event participants

Relevant CiviVolunteer Permissions

CiviVolunteer: edit own volunteer projects
CiviVolunteer: create volunteer projects
CiviVolunteer: edit volunteer project relationships

With these, the user get permission denied:


texts: Installs fails with Error Database does not support creation of triggers - User has TRIGGER privilege

texts:
MySQL 8.0.22-0ubuntu0.20.04.3 (Ubuntu)
WordPress 5.6
CiviCRM 5.32.2
Attempting a fresh install of WP and CiviCRM on a clean AWS site as upgrading CiviCRM  was continually failing
I get this error:
System Requirements
We are not able to install the software. Please review the errors and warnings below.
Severity    Section Name    Details
Error   Database    CiviCRM MySQL Trigger   Database does not support creation of triggers
Refresh
After updating your system, refresh to test the requirements again.
Environment
The system settings were auto-detected. CiviCRM will be installed with:
CMS Database    mysql://wpdbuser:HIDDEN@localhost/wordpress
CiviCRM Database
mysql://wpdbuser:HIDDEN@localhost/wordpress
CiviCRM Settings File   /var/www/wordpress/wp-content/uploads/civicrm/civicrm.settings.php
CiviCRM Source Code /var/www/wordpress/wp-content/plugins/civicrm/civicrm
My Wordpress database user has full privileges including TRIGGER.
mysql> SHOW GRANTS FOR 'wpdbuser'@'localhost';
+-----------------------------------------------------------------+
| Grants for wpdbuser@localhost                                   |
+-----------------------------------------------------------------+
| GRANT USAGE ON *.* TO `wpdbuser`@`localhost`                    |
| GRANT ALL PRIVILEGES ON `wordpress`.* TO `wpdbuser`@`localhost` |
+-----------------------------------------------------------------+
2 rows in set (0.01 sec)

I specifically added TRIGGER
mysql> GRANT  TRIGGER ON wordpress.* TO 'wpdbuser'@'localhost';
Query OK, 0 rows affected (0.01 sec)

How can I resolve this ?      Is this a CiviCRM problem or a MySQL issue?


texts: How do I go about changing out the text on the confirmation page for events so that it says something different? Right now it says "Continue" and we'd like it to say something like "Continue to pay via Paypal". I've been digging through the template files and can't find where I would change that.


texts: Trying to set up read only role in Drupal

texts:
I'm trying to set up a read-only role in CiviCRM on Drupal.  The environment is Drupal 8.9.12, CiviCRM 5.32.2 on Centos 8 with Apache.  This is a brand new installation I'm setting up for an organization that I volunteer for.  (I'm new to CiviCRM but have a long career with the IT industry and Linux in particular.)  Right now I'm working on a test environment that I've set up for learning my way around.
I've created a role in Drupal and enabled a number of CiviCRM "view" permissions in this role.  I've then created a used and assigned the newly created role to this user.
If I log in as this user I get "Access denied" for everything I've tried.  If I now enable "CiviCRM: access CiviCRM backend and API" for this read only role, I can now see the CiviCRM pages but I also seem to ave the ability to edit, which I'm trying to prohibit.
This is all on a virgin install.  I didn't encounter any problems installing the software, and if I log in as a user with adminitrator permissions everything works as expected, so there doesn't seem to be a problem with the install.
Any ideas?
Thanks,
Martin


texts: Geocoder extension appears to have removed State from Address

texts:
I have been using the built-in Google geocoder from CiviCRM for ages (since 4.x). After upgrading to 5.5.x, I noticed it no longer seemed to work, even after setting up a Google Maps API and getting the correct API key. So, I then installed https://github.com/eileenmcnaughton/org.wikimedia.geocoder and attempted to use it. At some point during using this extension, many of my addresses had their STATE field completely wiped out - with the zip, street address, city, country - still intact.

The extension says it is able to fill in missing details on the address from the geocoder, so I'm assuming something like this was attempted but failed, thus resulting in some state's lost. Does anyone have any other suggestions for what might have happend and how to fix it? Yes, backups are available.


texts: CiviMail cannot create ACL recipient table after upgrading to CiviCRM 4.7.31

texts:
After upgrading to CiviCRM 4.7.31 I began to get several errors while initially trying to send a test e-mail using an ACL-based user.  I noticed that these errors were not happening with the Administrator account.  Upon trying to reuse a previous e-mail I got the following error:

> CiviCRM_API3_Exception: "DB Error: no such table"
>
> #0 /public_html/www/sites/all/modules/civicrm/CRM/Mailing/Controller/Send.php(67):
> civicrm_api3("Mailing", "clone", (Array:1))
> #1 /public_html/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(304):
> CRM_Mailing_Controller_Send->__construct("New Mailing", TRUE, "null",
> NULL, "false")
> #2 /public_html/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(84):
> CRM_Core_Invoke::runItem((Array:14))
> #3 /public_html/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(52):
> CRM_Core_Invoke::_invoke((Array:3))
> #4 /public_html/www/sites/all/modules/civicrm/drupal/civicrm.module(445):
> CRM_Core_Invoke::invoke((Array:3))
> #5 [internal function](): civicrm_invoke("mailing", "send")
> #6 /public_html/www/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:2))
> #7 /public_html/www/index.php(21): menu_execute_active_handler()
> #8 {main}

I believe that Civi builds a temporary table based on the active user's ACL settings.  This is why this behavior doesn't trigger when using the Administrator account.  Any ideas on how to fix this?


texts: Exchange Online is retiring basic authentication which means, I think, that CiviMail will no longer be able to process bounced messages in Exchange Online mailboxes.  Are there any plans for CiviMail Mail Accounts to use Oauth2 for authenticating with the mail server?


texts:
I've installed for the first time civiCRM.. and he is great...
I have a wordpress website so I was wonderind what is the correct procedure to set up a newsletter subscription form.
Thank you


texts:
In the contribution form, as the user select the donor, I would like to show some contact info, including both demographic information (eg. email) and custom fields.
How can I do it?
Thanks


texts:
When I go to "manage groups", some of my smart group counts are listed as "unknown" and the notification "Count data for smart groups is not currently calculated" appears.

Does anyone know how to address this issue? I have the smart group cache timeout set to 5 minutes and I have "Rebuild Smart Group Cache" cron job set to always run when the cron runs. The cron task runs every 15 minutes.

I can manually click "Update Smart Group Counts", but the problem is that I have an automatic sync to Mailchimp. So whenever the smart groups fail to count themselves and Mailchimp tries to sync, it thinks everyone in the smart group unsubscribed when really Civicrm lost track of the smart group counts.

Any help would be appreciated.


texts: Does anyone know of a payment processor that integrates with Civi and also accepts South African Rand? We're finding out that most payment processors don't accept African currencies.


texts:
I've used Flexmailer as an extension for ages because it was required for Mosaico. It is now in core (as well as the extension, so not sure which one gets used).
But I don't understand when it's used and what the implications of it are.
The settings in Administer » CiviMail » Flexmailer say:

Traditional Mailing Handler
For greater backward-compatibility, process "traditional" mailings with the CiviMail's hard-coded BAO.
For greater forward-compatibility, process "traditional" mailings with Flexmailer's extensible pipeline.

I don't understand what traditional mailings are - perhaps it's everything except Mosaico mailings?
Specificially, if I send:

a CiviMail mailing without Mosaico
a CiviMail Mosaico mailing
a MessageTemplate with the MessageTemplate.send API
a MessageTemplate where the template comes via Mosaico message template with the MessageTemplate.send API
a MessageTemplate with the Email.send from the Email API extension used by CiviRules and FormProcessor and possibly others
a MessageTemplate where the template comes via Mosaico message Template, sent with the email api extension.
Some other internally generated message, e.g. the one you might get when an activity is assinged.
Emails created from the Send Email (without CiviMail) action, which I presume is the same as when you add a Send Email activity(?)
Scheduled Reminder emails.

Then

which system would be used when Flexmailer is set to Auto?

what would be the implications of having flexmailer forced in the settings?

any other things I ought to know ;-)


texts: CiviCRM profiles / Caldera Forms: What to use when?

texts:
I am new to CiviCRM and CiviCRM profiles and Caldera Forms + CiviCRM seem to be two realisations for the same thing: Let users enter data.

What are the advantages of the realisations? When to use what?


texts: Webform: Only Open Case if Condition is True

texts:
I am just starting to learn the Webform integration with CiviCRM. I know that I am able to open a case via the webform module. However, I only want to open a case if a condition is met.

For example, when the status field is equal to "Accepted", I like for the case information to show. Currently, I tried adding all the case information and tried leaving it blank, but it produces an error "Sorry but we are not able to provide this at the moment" as a result of missing information (I believe). Have anyone accomplished something similar to this?


texts: What is the correct method to alter the source field value in Contributions?

texts:
I want to alter the contribution source field so that I can add custom data in the pattern shown below
[Payment Type] - Online Payment - [Contribution Page title]
I am planning to use hook_civicrm_pre where $op == Contribution and alter the value based on the Contribution Object Data available ?
Is that the correct method ?


texts:
CiviCRM 5.35.0 on Joomla 3.9.25
Search (basic, advanced or search builder) when I select a Group returns:
 "Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
DB Error: no such field"

I'm not sure when this started happening. We update regularly and haven't had any issues installing updates or running the db update function.
Error log has this:
    Mar 11 05:12:10  [error] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => exceptionHandler
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`form_values` AS `form_values`, `a`.`mapping_id` AS `mapping_id`, `a`.`search_custom_id` AS `search_custom_id`, `a`.`api_entity` AS `api_entity`, `a`.`api_params` AS `api_params`
FROM civicrm_saved_search a
WHERE (`a`.`id` = "71")
 [nativecode=1054 ** Unknown column 'a.name' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`form_values` AS `form_values`, `a`.`mapping_id` AS `mapping_id`, `a`.`search_custom_id` AS `search_custom_id`, `a`.`api_entity` AS `api_entity`, `a`.`api_params` AS `api_params`
FROM civicrm_saved_search a
WHERE (`a`.`id` = "71")
 [nativecode=1054 ** Unknown column 'a.name' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`form_values` AS `form_values`, `a`.`mapping_id` AS `mapping_id`, `a`.`search_custom_id` AS `search_custom_id`, `a`.`api_entity` AS `api_entity`, `a`.`api_params` AS `api_params`
FROM civicrm_saved_search a
WHERE (`a`.`id` = "71")
 [nativecode=1054 ** Unknown column 'a.name' in 'field list']"]
)


texts: Why can't I export a Contact Detail report to CSV?

texts:
I have a problem with civireport. Since I've created and saved one report I can't export it anymore to csv. First, the export to csv was missing. I've tried this...

http://forum.civicrm.org/index.php?topic=22773.0

...but nothing happened.
Then I tried this...

http://forum.civicrm.org/index.php?topic=17001.0

...which gave me back the export to csv button, but now, when I click it , I only get a 288 bytes CSV . There's no data at all.
I've also found this ...

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

...but as you can see it was closed without fixing.

I really need to get this fixed. My organization NEEDS the export report functionality.

Iván Lago

IT Engineer at Engineers Without Borders Galicia

More info:

Server version: Apache/2.2.22 (Debian)

CMS: Drupal 7.36

CiviCRM version:4.6.0

PHP: 5.4.39-0+deb7u2

MySQL: 5.5.41-0+wheezy1