texts: Contribution form errors after latest security release

texts:
We have three different clients reporting erratic errors on public-facing and administrative credit card donation forms.

The error is that CiviCRM reports that a credit card + expiry is invalid, and the error shows up before talking to the payment processor, i.e. it's form error, not a payment processor error. We've confirmed that the cc credentials are in fact valid.

These started happening after the latest (Nov 20 2019) security update (some on the 5.13.7, some on 5.19.2, not all using the same payment processor).

See attached picture for a clue: note the title of the cc images.


texts:
I have CiviCRM running on wordpress with about 800 members. The members are mostly not computer savvy so giving them each a login is not an option.

I would like to create a form which we can direct members to so they can enter Just their name, address and membership number (We use the External ID field for this) and submit a payment via card. Would be great if it could be recorded as a contribution or even better, automatically renew their expired membership. But if that isn't possible, just a basic page to collect the info which we can then manually process the renewals in the back end.

I have tried using the same form we use for new membership signups but this gives an error that the membership number already exists in the database.

What would be the best way to achieve what we require?

Any assistance is appreciated.


texts:
I have to set CiviCRM to collect subscriptions for next year.

The membership fee is 190,00(childs) and € 225.00(adults).
if a child has a brother, the brother has a discount of 5%
Who pays can divide the payment: 90.00 € by 01/07/2015 and the remaining by 12/01/2015
Who pays for it all at once has a discount of 5%.

I can set these payments CiviCRM? How?
Thank you.


texts: Should deleted Participant contributions appear in the report Event Income Report?

texts:
At Event Income Report (both Detail and Summary), in the results, contacts deleted with contributions are counted.

I tested it in dmaster and have the same behavior.

Obviously, it's because in the SQL sentence it doesn't appear the contact.is_deleted = 0 in the where clause.

The reason for that behavior is that CiviCRM considers still valid deleted contacts contributions and refuses to delete them.

So, what do you think? It's a bug that needs to be fixed? Create a custom Report? An extension?

Thanks for answering!


texts: Members cannot renew, looks like they are not logged in when in fact they are

texts:
We have a Joomla installation that's been operating for several years. We have a straightforward Contribution page for membership renewals, with a straightforward price set. The price set was recently updated for a price increase, and a clone of the previous contribution page incorporates the updated price set. PayPal is our payment gateway.
Recently, most if not all members have had trouble renewing their membership. They log in, go to the renewal page, fill out the price set information and click on the Next button to get to the PayPal page. Instead, they end up on an Error page that says "Please log in first." They are already logged in.
Not sure what we did to make this happen, but it is now pretty consistent.


texts: Include organization name in employee's postal address

texts:
It's a pretty common scenario -- we'd like to print mailing labels addressed to individuals at their workplaces. For example,

Angela Davis
UC Santa Cruz
1156 High Street
Santa Cruz, CA 95064

What is the best practice for doing this in Civi? We could just put the organization name in "Street Address", and move the "real" address lines down into "Supplemental Address" fields. In fact, this is what we do -- but it doesn't seem quite right for a couple reasons:

In Civi's database schema, the "street_address" column is described as Concatenation of all routable street address components (prefix, street number, street name, suffix, unit number OR P.O. Box). The organization name doesn't seem to belong there, really.
This is a relational database, so why are we storing the organization name twice (once in the org's own record and once in the employee's address?) There should be a more elegant way to handle this.

Other CRMs include a special "Company" address field, distinct from the "Street Address" field, but again this would be duplicative.


texts:
I am writing an extension which uses a CRM.api3 call in javascript on the contribution page.  However, the link that is generated is lacking the "administrator" part.  For example,

The API call to StateProvince generates this:
http://localhost:81/example.org/index.php?option=com_civicrm&task=civicrm/ajax/rest&entity=StateProvince&action=get&json=%7B%22sequential%22%3A1%2C%22id%22%3A%221042%22%7D

That gives a Internal Server Error 500 message.

However if I add "administrator" to the link:
http://localhost:81/example.org/administrator/index.php?option=com_civicrm&task=civicrm/ajax/rest&entity=StateProvince&action=get&json=%7B%22sequential%22%3A1%2C%22id%22%3A%221042%22%7D

it asks the user to log-in and then works fine.  How can I allow my extension's javascript to call the StateProvince api Get method without making the user log in?

Below is my code:

var myStateInfo = '';
CRM.api3('StateProvince', 'get', { "sequential": 1, "id": myStateId }).done(function(result) {
    myStateInfo = result;
});


texts: Unable to change contribution status using API

texts: I am attempting to update a contribution's status but I am getting the error "Cannot change contribution status from Pending to In Progress." I am doing this through the API. I understand there may be some specification bug where In Progress is intended for pledges, not contribution's -- but I can't think of any better way to represent the data I am getting using the available contribution statuses :-S In Britain, a contribution or payment of any kind can have multiple states and frequently goes through multiple state changes. I understand this is different to, say, the US system which I have limited experience of. I am using the contribution status 'Pending' to mean "The direct debit mandate has been created (but not submitted by the payment gateway to the banks)". I am trying to use the contribution status 'In Progress' to mean "The direct debit mandate has been submitted to the banks (but not yet paid)" I believe this is in keeping with expected behaviour for these terms in this context.


texts: How can I modify the from email address used in petition confirmation email?

texts: My default from email address is office@my-organisation.org. When a supporter signs a petition, they get a confirmation with that sender address. However, I want the confirmation email to have petitions@my-organisation.org as sender address. How can I achieve this?


texts:
I have CiviCRM 5.28.0. I have parsed my addresses to separate in door number, street name and apt.
My problem is that when I enter data in the fields, it does not save it as it should. More precisely, if I enter the following information:
Door number: 123
Street Address: ABC
Apt: 4
And save. When I reopen the contact page, the address is saved as:
Door number: 123
Street Address: ABC 4
Apt:
That is the Apt is saved in the Street Field.
Is this a bug or something I overlooked?
Although I do not think it has an influence on the problem, I am using CiviCRM with Joomla.
Thank you for your input on this matter.
Judith


texts: Is it possible send a gif image correctly without breaking it?

texts:
I'm trying to create a email mosaico template with image .gif but jquery resize my image and send gif broken. Is there any option to send a .gif correctly?

Thank you.


texts: We are an organization that has donors ("constituents") and potential donors (also referred to as "constituents").  We would like to run a query that identifies potential donors--i.e. "constituents" who have never made a donation.  How would we do this?


texts:
I am trying to set up a membership option where people can pay what they can with a minimum amount set.  For example $60 rather than the standard $180 for a membership. I would have thought this was possible/easy because you can do that with contributions but I do not see a way to assign a membership to the contribution.
All I need is a text field for people to type in the number just like on contribution price sets.
Is there an extension that does this? Is there an easy way with code? CiviRules (I looked but I do not see a good way to tell what PriceSet field it came from)?
Thanks!


texts: Drupal 8 CiviCRM Entity and Views activities

texts:
We have been working on Views, with Civi Entity, on Drupal 8.
We are having an issue a list of Activities and filters.
We only want to load Activities where the source contact is a particular Contextual filter (contact ID). But adding a Contextual Filter of 'CiviCRM Activity (CiviCRM Entity): Activity Source Contact' leads to an error.
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'civicrm_activity.source_contact_id' in 'where clause': SELECT civicrm_activity.id AS id FROM {civicrm_activity} civicrm_activity LEFT JOIN {civicrm_value_volunteering__9} civicrm_value_volunteering__9 ON civicrm_activity.id = civicrm_value_volunteering__9.entity_id WHERE (((civicrm_activity.activity_type_id = :civicrm_activity_activity_type_id)) AND ((civicrm_activity.source_contact_id = :civicrm_activity_source_contact_id))) AND ((civicrm_activity.is_deleted = :db_condition_placeholder_0) AND (civicrm_value_volunteering__9.validated__200 = :db_condition_placeholder_1)) LIMIT 11 OFFSET 0; Array ( [:civicrm_activity_activity_type_id] => 66 [:civicrm_activity_source_contact_id] => 20 [:db_condition_placeholder_0] => 0 [:db_condition_placeholder_1] => 1 )
Is that the right method for adding a contextual filter to that type of View.
Or is there another way?
Olly


texts: Do manually added contacts stay in a smart group forever?

texts: If a contact is manually added to a smart group (so has the status of 'Added') do they stay there for ever (until manually removed)? I am about 99.9% certain that this is the case. I've had some questions about contacts that shouldn't have been in a group (and so got an email in error) - and the reason is that they were manually added to the smart group.  If true this makes manually adding contacts to a smart group a very bad idea - which I hadn't quite appreciated before.  It makes the case for this feature to be optional so it could be turned off.


texts:
For some reason, cron doesn't work. On CMS joomla
The system thinks that it works, and shows in the status that everything is fine, but mailings are not sent at the same time.
Cron settings on the screen.
Tell me what could be the matter?
Cron doesn't work joomla


texts:
According to this answer Can I offer different pricing for an event based on user group? it is possible to restrict a price option that is set up as a check box, radio button or selection to a group.
However, I don't see the option to limit the option to a specific group?


texts: Can I use multiple values in an api Get call?

texts: For example, can I use a single api call to get all the contributions from contact a and contact b. My actual need is to get contributions from the contact and any related contacts, but I assume I need to do that as a previous step, which is done.


texts: Sending SMS Error : Invalid or missing integration API Key

texts:
I just upgraded to 4.7.28 on wordpress 4.9.1 I am trying to setup my Clickatell SMS provider but I am getting a strange error;

However I have dobble checked the details and have tested it using the URl method:

http://api.clickatell.com/http/sendmsg?user=USERNAME&password=PASSWORD&api_id=3591165&to=6785470505&text=Message

and that work fine, I am just trying to send indervidual SMS's at the moment.

here are the setting I am using:

Any help or insight into where things are going wrong would be appriciated


texts: Any way to allow non validated (public visitors) to search the PCP pages available for an event?

texts:
Still evaluating CIVICRM for use by my organisation and I love most of the functionality.

One thing I need, and I'm surprised it's not core functionality - or perhaps it is and I haven't found it yet.....

Having created an event (a sponsored cycle ride in my case) and having participants register and create PCP pages, is there any way to allow a member of the public (i.e. not a logged in registered user) to search the PCP pages available for the event in order to find a particular participant they want to sponsor?

I've extended this somewhat by adding the PCP for Teams extension from uk.co.vedaconsulting.pcpteams so would need to integrate with that and search for individuals or teams.....


texts: What permission allows a listing to be exported to a csv file

texts: I can't seem to locate the permission that allows a report listing to be downloaded to a csv file. The Actions are present but they don't function. They work on some roles but I haven't been able to narrow down the particular permission that allows this function.


texts: How do you give in honor/memory of someone but acknowledge someone else?

texts:
In some other donation management software, it's possible to say, e.g., "I'm giving $100 in memory of my grandfather.  I want my mother and uncle to be acknowledged."

Has anyone tried to incorporate such a workflow into CiviCRM?  How do you best do it?  Do you soft credit my grandmother? Or my mother/uncle?  How do you generate reports of who needs acknowledging?


texts: CiviCRM Event - Image upload issue on TinyMCE Editor

texts:
I am using TinyMCE editor on CiviCRM events, while I am trying to add the Images, they are refusing me to upload the images. How can I fix the error as given below:
Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
You must be logged in with proper permissions to edit, add, or delete uploaded images.
Return to home page.


texts: Bulk delete of events - is such a thing possible?

texts:
We've had a bit of a mix up and imported the same set of events twice.  Most if not all of the duplicates have no participants (but I'm not 100% certain of that)

Is there a way to bulk delete these duplicates?  I can't code but I can use sql a bit

I've seen this suggested: "DELETE from civicrm_event WHERE id=1".  is that ok to use on multiple events?  Is it ok to use if an event has participants?

thanks


texts: What's the best version combination for Drupal 7 and Civi 4.5

texts: Tried installing drupals starter-kit with civi with errors wouldn't finish. Tried numerous version combinations none would complete. Do you have a combo suggestion?


texts: Getting problem while installing of my extension

texts:
I was trying to install my created extension. First time it worked. After I was trying to install then it shows me the following error.[I am working on windows and Linux platform. But this problem occurred on Linux platform].

  Error
   Field: name must be unique. An conflicting entity already exists - id: 96

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.
Field: name must be unique. An conflicting entity already exists - id: 96


texts: Editing the Batch entry form/template fields

texts:
I am looking at the batch data entry form and wondering if it is possible to modify this:

For example, I'd like to remove some columns (e.g. Invoice ID) and add others (e.g. Campaign).

Is there a way?


texts: Anyone have success integrating Gravity Forms with CiviCRM? Alternatively is there another WP form plugin that works with WPML and CiviCRM.  A plugin would be great.  We are looking at the CiviCRM API, but hope to get advice from someone that has done this before.  Thanks.


texts:
I'm trying to setup Mass SMS and Mailing and seem to be running into some problems. I can send mail and SMS directly to an individual but the scheduled SMS and mail does not work. I know this has to do with Cron being configured incorrectly but I'm not sure where to look. I have CiviCRM 4.6.3 installed on Drupal 7.37. I also have installed the Drupal Cron module from here.

When the job is manually executed I get a success message. Where are some other places I should be checking?


texts: when I load the data from the Excel sheet, I have discovered that civiCRM makes excessive use of resources; how to set civi so that this does not happen? Thanks


texts: Event -> Find Participants displays event id, not event name in event name field

texts:
Selecting Events -> Find Participants under CiviCRM 5.1.2, Joomla 3.8.8, PHP 7.2.5 under IIS displays the event ID and not event name in the Event Name field.  This is a bug introduced after 4.7.31.  It may be relevant, but the CiviCRM menu drop downs also disappear.

4.7.31:

5.1.2:

I've tried looking at what has changed, but the obvious files aren't showing any such changes.


texts: Keeping track of sessions attended for one to one program "package"

texts:
I do one-to-one consultations with clients and have a wellness "package" where a client can buy few consults/ massage treatments as a package to save money. This is not a group situation. So what is the best way to store that information and keep track of how many sessions this person has used and what kind? consult? massage? how many? If there are many packages sold to different clients, will they be different campaigns for different persons? or events? dates are not typically fixed in advance but are set up as we go. Also if a person buys another package at a different time, how do I store this information?
Thanks in advance for your valuable input.


texts: Access denied errors by server itself on uploaded files?

texts:
I'm noticing a lot in the logs whereby the server itself is trying to request a resource that CiviCRM denies access to by .htaccess.

Specifically it seems the CiviCRM server is trying to fetch files of this pattern:

/sites/default/files/civicrm/upload/delete-this-d3542fs2sP
/sites/default/files/civicrm/custom/delete-this-D44i89qZNP

Yet both of those directories contain .htaccess files with Deny all statements.

Anyone shed any light on this? [4.4.20 LTS, Drupal 7]


texts: How to see total net amount in membership report

texts: For example, with the built in report "Contribution and Membership Details" it will total the contributions at the bottom. But this is not the net amount. How would we get the report totals at the bottom to show contribution total, fees and net? We have people still using excel to do work that I thought CivCRM would handle, and I want to get them off of excel.


texts: Group Type is set to empty while updating Group

texts: On ManageGroup page, if group description is updated or if I enable/disable group, the value of GroupType gets updated to an empty value. Ideally, GroupType value must not be updated, it should retain its original value.


texts: Auto-filing e-mails on Cases: Mail content not shown under details and attachment with extension .unknown created

texts:
I am trying to set up a workflow with CiviCase to automatically file clients' responses on their respective cases.

According to the documentation, mails arriving in the e-mail-to-activity-Mailbox, containing the pattern [case #123] in their subject line, get automatically filed under the respective case (123 in this case) as an activity ('Incoming E-mail').

This is all working fine so far regarding the overall process. However, the contents of the incoming mail is not visible in the 'details' section of the activity. An attachment with the mail gets created, but with the extension '.unknown'. I can download this attachment, manually select a program to view it (e.g. a text editor) and (only) the body of the mail gets displayed as plain text, the header info seems to be stripped off. This behavior happens for html mails as well as plain text mails.

What I originally expected was something like a plain text representation of the mail under details, the same way as it is handled with outgoing mails. And the attachment should ideally contain the unaltered and entire mail, including the header information (date/time, recipients) and have a filename extension which could be recognized by a mail client after download (e.g. .eml).

My main question for now: Is this the intended behavior (then I can arrange to live with it, since I am quite happy with the overall process) or am I missing some configuration settings somewhere?

(Using CiviCRM 5.13.1 and Wordpress 5.1.1)


texts:
Following the advice I received in Allow only existing CiviCRM contacts to create own Drupal account, I'm trying to implement Drupal Rules to create an associated Drupal user whenever a CiviCRM contact is added to the 'Web Site Users' group.

I'm running Drupal Core 7.66 and CiviCRM 5.12.3. Trying to get this working I've installed Entity API 1.9, Rules 2.12, and CiviCRM Entity 2.2.

This is the rule I'm using:

Creating a new contact in CiviCRM is correctly creating a new Drupal user, but I'm also getting this error, with no other visible consequences:

  Notice: Undefined property: CRM_Contact_DAO_Contact::$contact_id in
  civicrm_entity_contact_user_get() (line 3671 of
  /var/sites/c/civicrm.jesusshapedpeople.net/public_html/sites/all/modules/civicrm_entity/civicrm_entity.module).

Should I be concerned? Am I doing something wrong? Is there a fix?


texts: I am using CiviCRM on Joomla. I wanted to know if there is a way to customize how I view the contributions on the admin side (in the back-end). I honestly have no need to see time of donation or premiums (we don't use any right now). Are there any ways to hide these fields to clean up the view?


texts: civicrm mosaico optout token goes to unsubscribe page

texts:
Using Mosaico V2

This token  - {action.optOutUrl}

resolves to this:

https://nbts1.nubay.net/civicrm/mailing/optout?reset=1&jid=112&qid=48&h=e3c048a15c39a655

which goes to this page

Seems like a bug.  Is it?


texts:
Civicrm 4.7.31 on Wordpress
I get this error when attempting to edit a Membership. Initially, I get a blank pop-up with the message "Network Error. Unable to reach the server. Please refresh this page in your browser and try again." I then right clciked on the link and opened it in a new tab and I get the error
"Fatal error: Call to undefined method CRM_Contribute_Task::taskTitles() in .../www/wp-content/plugins/civicrm/civicrm/CRM/Contribute/Task.php on line 163"

At the moment, we are unable to view or edit any memberships so that we can edit them and update details or change the status if members cancel. How do we resolve this issue?


texts: Is there a way to prevent two 'home' addresses for a contact?

texts: I'd like to prevent a single contact from having two addresses with the type 'Home' (or 'Work', etc.).  Is there a CiviCRM configuration, or an extension, that provides this functionality?


texts:
I am working on importing information from our current donor database to Civi.
Is there a table that lists the field names within each table and an explanation of what that is?
Specifically I am looking at ContributionRecur entity and I would like an explanation of the fields beyond the field name that's in one place.
Ideally each entity would have something like that.

I have looked in the User Guide but I can't find that sort of thing.
Can anyone point me as to where it would be ?


texts: Finding contacts in Group A AND Group B?

texts: It seems like there must be a way to search for (and hopefully perform group operations on)contacts that are in both Group A AND Group B but I can't find it.  Suggestions?


texts: Webform: "not you" message - I can't find it!

texts:
I use webforms quite a lot including for data entry. Normally when I enter data I enter it when I am logged out so that the data gets added to the correct record and not to the record of the logged in user.

However I would like to enter data and use the private field option of webform - to do this I need to be logged in.

I see on the webform set up there is an option:

Prompt for users who are logged in as, or following a hashed link for, someone else.

Display message to known contacts?  [yes]

I have enabled this however when I am logged in I do not see this message. When I view page source it is there "h2 class="element-invisible">Status message
 ul>
  You are viewing this form as XXXXXXX. Please click here if that's not you.
  You have already submitted this form. View your previous submissions."

So I am wondering why the message has been rendered invisible?

I have had a look at form settings and so on but I cannot find a tick box which explains how I have managed to make it invisible!

Any tips as to where to look would be gratefully received!
Thank you


texts: I modified a template file and now can't remember how

texts:
Yes I know - very foolish but hoping someone will take pity on me!

This is the my screen when entering a contribution or registering for an event while logged in.
I customised it to include the text 'PLEASE PAUSE FOR A MOMENT AND READ THIS - If you are entering a session record, please click on "WANT TO DO THIS FOR A DIFFERENT PERSON"
Now I want to revert the default but can't remember the file I edited
I've searched all the files in my custom templates directory - heaven forfend I edited core! (although then I guess an upgrade could fix my problem)
Thanks all


texts: "Unsupported action" error on attempting to install an extension

texts:
I'm trying to install the extension Extended Mailing Stats on Civi 4.6.14 running on Wordpress 4.4.2.

I added the extension's files to my Civi extension directory, went to the Civi extension manager and clicked Install. I got this error (from the log file):

Apr 07 04:34:06  [info] $Fatal Error Details = Array
(
    [message] => Unsupported action
    [code] =>
)

Apr 07 04:34:06  [info] $backTrace = #0 path/to/install/civicrm/CRM/Core/Error.php(364): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 path/to/install/civicrm/CRM/Admin/Form/Extensions.php(80): CRM_Core_Error::fatal("Unsupported action")
#2 path/to/install/civicrm/CRM/Core/Form.php(455): CRM_Admin_Form_Extensions->preProcess()
#3 path/to/install/civicrm/CRM/Core/QuickForm/Action/Display.php(94): CRM_Core_Form->buildForm()
#4 path/to/install/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Admin_Form_Extensions), "display")
#5 path/to/install/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Admin_Form_Extensions), "display")
#6 path/to/install/civicrm/CRM/Core/Controller.php(363): HTML_QuickForm_Page->handle("display")
#7 path/to/install/civicrm/CRM/Core/Page/Basic.php(395): CRM_Core_Controller->run()
#8 path/to/install/civicrm/CRM/Core/Page/Basic.php(174): CRM_Core_Page_Basic->edit(1, NULL)
#9 path/to/install/civicrm/CRM/Admin/Page/Extensions.php(125): CRM_Core_Page_Basic->run()
#10 path/to/install/civicrm/CRM/Core/Invoke.php(312): CRM_Admin_Page_Extensions->run((Array:3), NULL)
#11 path/to/install/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:13))
#12 path/to/install/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))
#13 path/to/install/civicrm.php(1199): CRM_Core_Invoke::invoke((Array:3))
#14 [internal function](): CiviCRM_For_WordPress->invoke("")
#15 path/to/install/wp-includes/plugin.php(525): call_user_func_array((Array:2), (Array:1))
#16 path/to/install/wp-admin/admin.php(236): do_action("toplevel_page_CiviCRM")
#17 {main}

It seems the action is "display". Not sure if it's supposed to be that. On the Civi backend, when I get the error, in the URL itself it says "action=add".

Any idea why this is happening?
Thanks.


texts: Email Send Now (to 50 or Less) - More than 50?

texts: Is it possible to use email send now to more than 50 people?


texts: CiviCRM logging enabled. I am now getting an error on mysqldump. Unknown storage engine 'ARCHIVE'

texts:
I getting the following error when I try to dump my civicrm drupal database

  Couldn't read status information for table log_civicrm_install_canary
  () mysqldump: Couldn't execute 'show create table
  log_civicrm_install_canary': Unknown storage engine 'ARCHIVE' (1286)

This table is related to the civicrm logging feature as described in the article https://civicrm.org/blog/eileen/who-did-what-when. Logging was enabled a while ago and everything seemed to work fine. Since then the site has been migrated to a new host and has had both civi and the drupal core updated a number of times. Currently, The site is hosted on omega8 running barracuda which is an aeger based host so these updates are more like site migrations. The instructions in the blog required turning on INNODB with a civicrmapi call. This was run for the original site but not on any of the migrated sites. I don't know if this is relevant? I am now getting the error when dumping the database via mysqldump.

Does anyone have any idea what this table is for or what might be causing the error?

Thanks for any help.


texts: Does Stripe checkout work with CiviCRM, Drupal combination? Or only Stripe.JS will work with CiviCRM?


texts: new event From Template does not copy custom fields

texts:
On the demo site - http://wpmaster.demo.civicrm.org/wp-admin/ I have created a new set of custom fields for Events - "Events custom fields" with one text field - "test1".
I have added value "tst" for this custom field in the event template "Free Meeting with Online Registration".

When using this template on a new event the custom field value is not populated with what's in the template. Do I have to use hook to copy over custom data? If so what's the hook?


texts: Changes made to individuals using Contact Editor not showing up

texts:
I'm using Wordpress and recently upgraded to CiviCRM version 4.6.3. Since I have the editor for individual contacts has ceased to save changes. When viewing an individual contact, I can edit fields using the in-line editors, but when I click the "EDIT" button and edit from the contact editor and click "SAVE", I get a message saying the contact has been updated but the new information is nowhere to be found! The editor does work for households and organizations though.

I did duplicate this on the demo site.


texts: Customer seeing error after successful Click and Pledge Payment

texts:
After a successful payment through the Click and Pledge extension, a customer saw this:

Warning: DOMDocument::createElement(): unterminated entity reference
q=civicrm/event/register&_qf_Confirm_display=true&qfKey=xxxxxxxxxxxxxxxx
in /tcp-wp/wp-content/uploads/civicrm/ext/com.clickandpledge.payment.clickandpledge/CRM/Core/Payment/ClickandPledge.php on line 498

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

(I substituted the xxx's here for a long alphanumeric string.)

Any thoughts about what I can or should do about this?


texts: Can I dump all Caldera form submission data into the "details" of a CiviCRM activity?

texts:
Caldera will email all form submission data in an email. Can I have that same form submission data added to the details field of CiviCRM activity records?
I don't see a tag to be able to do so from the CiviCRM Activity Processor, but surely this must be possible.
Thanks!


texts: Problem installing and removing CiviCRM on a Joomla 3.6.3 site

texts:
I'm trying to install CiviCRM 4.7.10 on a newly installed Joomla 3.6.2-site. I uploaded the code to a folder on the server, and did an "install from folder". However, this one failed (maybe faulty network connection). However, something was installed, and upon trying to reinstall, I get the following error message:

Warning: require_once(/home/agslo/public_html/administrator/components/com_civicrm/civicrm.settings.php): failed to open stream: No such file or directory in /home/agslo/public_html/tmp/com_civicrm/admin/configure.php on line 115
Fatal error: require_once(): Failed opening required '/home/agslo/public_html/administrator/components/com_civicrm/civicrm.settings.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/agslo/public_html/tmp/com_civicrm/admin/configure.php on line 115

According to the Module manager in Joomla, there is a CiviCRM component installed. However when I try to uninstall it, I get an error msg too, saying it cannot find Joomla XML setup file, and I am asked to manually remove it.
Anyone that can assist me in solving this so I can have CiviCRM installed? Either by first removing the component, or by doing a new install.....
Magnus


texts: Can't Install CiviCRM on Joomla! 3.9.23 mod_fcgid error

texts:
CiviCRM 5.32.2
Joomla! 3.9.23
Mysql  5.7.23
PHP 7.3.24
PHP Extensions installed

PHP BCMath
PHP Curl
PHP DOM XML
PHP Multibyte
PHP Zip
PHP INTL
PHP SOAP

PHP Configuration
 - Set memory_limit to 512mb
 - safemode PHP directives are off.
 - MAMP XCache - This is off.
I kick off the install and after about 5 to 10 min the system kicks the following error:

[error] mod_fcgid: read data timeout in 360 seconds

Any ideas on how to fix this?


texts:
D7.56 Civi4.7.22

I'm attempting to embed the bulk of a contribution page inside a block shown in a view. The view shows multiple of these blocks.

I copied them by using inspect to get the HTML underneath.

This works fine at first, however intermittently I experience the following error when clicking the button:

"Your browser session has expired and we are unable to complete your form submission. We have returned you to the initial step so you can complete and resubmit the form. If you experience continued difficulties, please contact us for assistance."

How can I circumvent this? I suppose that the HTML needs to be regenerated, not copy and pasted. How can I do this?


texts:
I'm a newbie with CiviCRM.. sorry if my questions sound stupid. As I understand, activities are central to this CRM. Yet, I can't find a quick way (e.g in the menu) to display all recent activities. I have to digs into reports (3 or 4 clicks) or have a "preview" within the CiviCRM dashboard.
What am I missing?
Thx!


texts:
We need to be able to resend individual event confirmation emails (e.g. corrections to the registration, sometimes not received etc.).
Up till last year's event in August this was no problem. There was a check box on the participant record to allow you to resend upon saving the record.
Since upgrading to our current version CiviCRM 5.22.0 this appears no longer an option. Has this been moved elsewhere?
For our event (https://www.capelcarshow.com/show-registration/) it is a critical feature. We are really in problems without it. Any suggestions or help out there?


texts: Configuring Extended Reports- Case Activity Pivot Chart

texts:
I've built a report using Extended Reports- Case Activity Pivot Chart
Rows= Contact Name
Column= Activity Type
Filters
Case Type= Expected Case Type
Activity Dates= previous Quarter
Activity Types= w,x,y and z
And it gives me what I want- a breakdown of case activities in the last quarter, and a list of clients interacted with in the quarter.
Genius. Absolute genius.
But- and I can't lie this is a big but.
Instead of just having 4 columns for the 4 activity types I'm filtering by. The finished report has a column for all activity types in the system. Which makes for a lot of columns.
I've used the option to not display columns with zero totals. And this hides 3 out of my 4 columns- even though they have totals.
Currently I'm happy enough that I can now see the query results and export to CSV and delete the unwanted columns there- just wandering if anyone else had hit a similar problem and had been able to make the resulting pivot chart a little less bulky?


texts: How do I use Table Cell Separator when creating Thank You letters?

texts:
Civi 4.6.18 using WordPress

I am working on creating a year-end statement for donors with all their donations for this year on it.  I am using the "Thank You letter" to do so.
1. I select Group by = Contact
2. I select Separator = Table Cell.

My results are Comma Separated. How do I get them into separate table cells?

Here is my source code for the letter.

Dear {contact.first_name}

&nbsp;

            Date
            Amount
            Receipt Number

            {contribution.receive_date}
            {contribution.total_amount}
            {contribution.contribution_id}

I got my original information from here. https://github.com/civicrm/civicrm-user-guide/blob/master/docs/contributions/manual-receipts-and-thank-yous.md


texts: Strip Drupal Page Template from CiviCRM Contribution Page

texts:
I want to strip all Drupal navigation etc coming from page.tpl.php for a particular contribution page and all the associated pages of the contribution process. But all just for one contribution page.

In Drupal I know how to create template suggestions for a Drupal theme that will apply only to a specific path. But I don't thing the template suggestions can handle the query part of the CiviCRM URL.

Ideas?


texts: Ignoring a hidden field on event registration form

texts: I have a custom event template on which I hide some fields based on whether someone is registering themselves or an additional participant. There are 2 different price options, one for the main registrant and one for the additional participant. The price set needs to have required fields for each situation. How can I get civi to ignore the required fields if they are hidden?


texts: How to display remaining event participants?

texts:
If you want to display the number of remaining event participants (based on their role, too) until an event is fully booked, you could implement the following in EventInfo.tpl:

Participants

{crmAPI var="ParticipantS" entity="Participant" action="get" role_id="1" sequential="1" event_id=$event.id }
    {if $event.max_participants<=$ParticipantS.count}
        0&nbsp;remaining
    {else}
    {math equation="x - y" x=$event.max_participants y=$ParticipantS.count}&nbsp;remaining
    {/if}


texts: Some contacts are shown as LAST, FIRST; some as FIRST, LAST

texts:
On Constituent Summary page in Contact name column I see contacts listed in two different formats.

1) Last, Name

2) Name Last

Also, in search boxes, CiviCRM provides suggestions in these two formats.

How can I get all contacts displayed the same way (e.g. First Last)?


texts: Importing Memberships and Contributions but can't seem to link the two together

texts:
I'm using the latest CiviCRM Wordpress version and have imported thousands of contacts and their memberships.  The problem is when I attempt to import the associated contributions they seems to be no way to linked the contributions to their memberships.  Jon G has answered a similar question (below) but I'm not sure I can use his advise as I have already imported the memberships.  Any an all advise welcome.

Bulk Import of Membership Dues  - Jon G's Answer

It sounds like your process of importing memberships via CSV and contributions via CSV works - except that your contributions and memberships aren't linked.

If that's correct, I've resolved this when doing migrations as follows:

  Create a custom field for contributions called "external serial" or
  similar. Create a custom field for memberships also called "external
  serial". Add a serial number column to your CSV (if one doesn't
  already exist) before importing it as contributions/memberships. The
  only important part is that each row have a unique identifier. After
  import, you can use the shared identifier to create a new CSV with
  just two columns - membership_id and contribution_id (as CiviCRM
  assigned them). I typically would do this via SQL. Something like
  this: SELECT cc.id AS contribution_id, cm.id AS membership_id FROM
  civicrm_contribution cc  JOIN civicrm_value_importfieldcc_1 cvi1 ON
  cc.id = cvi1.entity_id JOIN civicrm_value_importfieldcm_2 cvi2 ON
  cvi1.external_serial_1 = cvi2.external_serial_2 JOIN
  civicrm_membership cm ON cvi2.entity_id = cm.id Create membership
  payments using this new CSV to link the memberships/contributions. You
  can do that with the API CSV Import GUI extension or the command-line
  tool that ships with CiviCRM.


texts: How do I send to Multiple Email Addresses for a contact in CiviMail?

texts:
Is there a way to configure CiviCRM so that it will send emails to all email addresses on a contact record?

If not, then how do you best utilize multiple email addresses on a contact (individual, organization or household)?


texts: Installing Direct Debit UK and Smart Debit extensions for civi 4.6

texts:
Has anybody installed the Direct Debit UK and Smart Debit extensions for Civi 4.6 (specifically) 4.6.10?

I've searched but can't find a definitive answer regarding compatability.

And, do these extensions work with webforms?

I know I could fire in, install and find out; but wanted to see if I could learn from other people's experience.

Cheers!

Craig


texts: How do I create and access a database for civiCRM

texts:
I am trying to install CiviCRM in WordPress to see if the small NGO I work with might be able to use it. I got a domain name and installed WordPress through BlueHost.com and turned on the CiviCRM plugin. It says the following problems exist, and they all appear to have to do with a database. I don't have any experience with software/programming/IT.
It appears I need to give access to CiviCRM to do stuff, but I have no idea how to do that.

I would really appreciate your help!! Thank-you very much!!

Sharone

CiviCRM Database Details

Does the server exist?
OK (localhost)
Are the access credentials correct?
That username/password doesn't work:
Can I access/create the database?
I can't create new databases and the database 'civicrm' doesn't exist. (user 'civicrm' doesn't have CREATE DATABASE permissions.)
Can I access/create InnoDB tables in the database?
Unable to create InnoDB tables. MySQL InnoDB support is required for CiviCRM but is either not available or not enabled in this MySQL database server. Could not determine if MySQL has InnoDB support. Assuming no.
Can I create temporary tables in the database?
Could not login to the database.
Can I create lock tables in the database?
Could not connect to the database server.
Can I create triggers in the database?
Could not login to the database.


texts: Can CiviCRM be managed as a group of companies, where there is a parent company of the group of child companies?

texts: An example of this Group of Financial Companies, which is the Parent company, then below it, are the other daughter companies, but that each one is granted their independent clients and their personalized invoices with their logo of each one, so , that is related to the group but that they handle their data separately within the same CiviCRM structures in a single and single installation.


texts: Anything I click on under administer tab goes to our home page...then list the administer topic?  So everything clicks to our home page then shows the topic?


texts: Sending email to Participants of an inactive Event

texts:
Based on a report I got today: Let's say we have an Event which has eight people registered, but the event has been cancelled. We set the event to "Inactive" and then click on "Participants" beside the event in the Manage Events page to get a list of all the registered participants. The list comes up as expected, so we select all and choose "Email (Send now)" from the actions menu.

Then the email screen comes up, and instead of eight registered participants, we have 15 people listed in the email list, and I'm not sure where the extras are from:

Can anyone help me sort out what is going on here?

Note that if I make the event active again it works as expected, so we have that workaround for sending emails to these folks.


texts: Importing Event Participants with Contribution/ Payment

texts:
I am relatively new at civicrm and I have a question about Event imports. I've been reading the documentation here:
https://docs.civicrm.org/user/en/latest/common-workflows/importing-data-into-civicrm/
about Import Participants and Import Contributions. The documentation seems to keep them separate from each other. The documentation touches upon importing multiple csv's for relational data, but doesn't go into great detail about the actual process.

The question is: Is there a standard procedure for importing event participants with their corresponding contributions / payment?

I know that there are many tables involved such as contribution, financial_trxn, financial_entity_trxn, event, participant, line_item...that are involved in this sort of import and frankly, it seems like a complicated import.


texts:
My client would like to change the attachment name of the pdf they receive when a contribution is made.

This is now receipt.pdf (which is the case for a lot of emails).

Can this be changed?

I'm using Wordpress


texts: How to determine Payment Processor for "pending" transactions (via SQL or otherwise)?

texts:
Is there a way to determine the Payment Processor for "pending" transactions? Our site has both Authorize.Net and PayPal Standard configured as payment methods, and I'm seeing and trying to debug lots of "pending" transactions (running on WordPress v.5.4.2, Civi v.5.25.0 -- just upgraded to 5.28.0, but the pending transactions have been happening since before then).
Or: should all of the "pending" transactions always only be from PayPal, since Auth.Net should complete immediately without IPN callback? And even for Auth.Net recurring transactions? (Since in principle one can configure and use multiple PayPal Payment Processors, it would still be helpful to be able to disambiguate pending transactions for those.)
I've explored the database, and I see that once a transaction has completed, I can get the Payment Processor via the civicrm_financial_trxn table (SQL below). But for 'pending', I haven't been able to track anything down.
select y.name `Payment Processor`
    , p.title
    , c.receive_date
    , c.id `contrib_id`
    , c.contribution_recur_id
    , c.invoice_id
    , c.trxn_id
    , case when c.contribution_status_id = 1 then 'Completed'
        when c.contribution_status_id = 2 then 'Pending'
        when c.contribution_status_id = 4 then 'Failed'
        else c.contribution_status_id end `Contrib Status`
    , t.payment_processor_id
    , y.url_site `Processor URL`
    , c.contact_id
    , c.total_amount
    , c.fee_amount
    , c.net_amount
    from civicrm_contribution c
    inner join civicrm_contribution_page p on p.id = c.contribution_page_id
    left join civicrm_financial_trxn t on t.trxn_id = c.trxn_id
    left join civicrm_payment_processor y on t.payment_processor_id = y.id
    where c.receive_date >= '2020-06-01'
    and c.is_test = 0 and c.is_pay_later = 0
    and t.from_financial_account_id is null
    order by c.contribution_status_id, c.receive_date, y.name, c.id desc;

(The t.from_financial_account_id is null clause prevents multiple matches with civicrm_financial_trxn table, since has multiple records for a single transaction when there are transaction fees.)


texts: Changing sort of cases with recent activities on case dashboard?

texts:
Currently cases with recent activities are sorted oldest>newest - i'd like the newest to be at the top.

I am guessing i could do it within Case/Page/DashboardSelector.tpl but i'm floundering from there.. is it possible? thanks!


texts:
I am upgrading 4.2.9 to 4.7.23. But while database upgrade i got error as "Found installation canary. This suggests that something went wrong with tracking installation process. Please post to forum or JIRA". As I researched, I deleted the table "civicrm_install_canary" but again the table creating dynamically. I didn't get any solution.  Please help me.

Thanks in advance.


texts: I am trying to use CiviRules to give a membership to contacts automatically when a contribution is added. I have a Membership smart group to filter members and non-members but getting an error when the rule is running when a contribution is entered. See attachments. Any help would be greatly appreciated. Drupal version 7.59, CiviCRM version 5.3 and CiviRules version 2.1


texts: Handling variable tax rates based on member's province

texts:
In a country, where each province has its own tax rate, where some provinces have multiple tax rates (provincial and feral), how would one go about configuring so that:

Tax rate can be derived based on a member's province
Invoices / Receipts show both itemized taxes
Taxes are collected in appropriate financial accounts
Membership types are associated to their respective financial types.

For example:
Imagine two membership types.  Student Membership.  Regular Membership. There are financial types for each, based on a business requirement to track revenues based on membership types. Specifically, revenues for student memberships are tracked against financial account 4000, and for regular memberships against financial account 4100. So far, easy enough.  Now throw in Canadian taxes, where tax rate (and financial accounts) should be derived off on member's province, and it gets complicated pretty quickly!  Even more so if there are 10 provinces, 3 territories, and a dozen or so membership types.

It seems that the best recourse would be a "Canadian Tax" module.  A quick search doesn't reveal anything.  Surely there are lots of Canadian users with similar issues.  How is this being handled elsewhere?


texts:
CiviCRM's translations are managed on Transifex, I have been a coordinator of the German team for about two or three years. I noticed that new translators are admitted to the German language team regularly and I was wondering how that works.

I only know two other coordinators (there are six) and reached out to them but they don't do it either. I would love to be able to contact new translators before they actually translate strings in order to let them know about best practices.

So my question is: Who is the manager able to permit new translators on a Transifex team (particularly the German one)?


texts:
I am running 5.21.1 with Drupal 7.69 (latest at time of posting). It was fine until I upgraded to this version of Drupal. Now I have as issue with the menu bar. When you first log-in the bar does not appear. However, if you then refresh the browser page, the menu appears and works fine after that. I have read all the posts about "menu missing", cleared the caches etc. and checked the .htaccess files but no joy. If you close the browser and then start a new browser session the menu is fine as long as you are still logged in. Has anyone else seen this?

PHP ver is: 7.2.27-1+ubuntu18.04.1+deb.sury.org+1


texts:
I have used other contact systems in the past and as well as first_name and middle_name there has been a preferred name field. We have several people who have long first names but they go by a shortened name, additionally we have people who are known by a middle name rather than their first name.
What I would like is to display the preferred name as the display name.


texts: Adding password creation to registration form (Civi + Wordpress)

texts: I've been trying to find a way to add password creation to the member registration form, and have the password sync with the Wordpress user profile. The membership itself syncs perfectly, but the password fields I've tried don't work.  I'm using CiviCRM 4.6.19 and WP Version 4.7.1. Is there an easy way to do this?


texts:
I'm trying to filter my contacts so I can easily identify a subset of those from the same organisation in order to fill in the relationships side of the CRM. I have a custom report to view all contacts, but there's no filter option for the e-mail heading of data.

Would this need to be done as a separate report perhaps?

e.g: E-mail is equal to "@shsc.nhs.uk"


texts: Start new CiviCRM site in Drupal 7 or wait for Drupal 8?

texts: We are interested in a fresh start for our organization with a new website using CiviCRM and Drupal. However, we're not sure if we should wait for the CiviCRM integration with Drupal 8 since it's the most recent version of Drupal, or start our full build in Drupal 7.  Any feedback is welcome.


texts: Can you send an immediate thank you to a recurring donation?

texts:
I set up a recurring donation using authorize.net, have the IPN url configured, etc.  However, when someone completes a recurring contribution they do not get an email right now, or even 10-15 minutes later.

I'm assuming that the email is generated by the IPN event from authorize.net, but they don't attempt the transaction until around 6am.  (My first test had a bad URL for the callback).

Is there a way to acknowledge that the contribution commitment has been made with a somewhat immediate thank you email that can also spell out how future receipts will be delivered?


texts: If a contact changes Membership Type should contacts who inherit that membership also show the new membership type

texts:
Scenario: Orgs can pay for a 1 year or 5 year membership.

Org X pays for 1 year. Their Employee Q gains the membership 'by relationship'.

Next year Org X pays for a 5 year membership. Employee Q's membership end date updates correctly ie shows to be 5 years hence, BUT it still shows their Membership Type as a 1 year membership, which imo is incorrect and results in them showing in Smart Groups when they should not.

QuickFix #1 is to delete the relationship, recreate it, and hey presto, Q now shows as having a 5 year membership.

Anyone else had that experience? Bug? Missing 'feature'?


texts: How to add case fields to activity report?

texts:
Is it possible and what's the best way to add case fields (e.g. case type) to an activity report whilst still ensuring civi can be updated easily?

I'd imagine those aren't default options because not all activities are related to a case.


texts: Custom field aggregation with Drupal Views

texts:
I have problems with showing aggregated custom data.

Some frequently asked questions:

Yes, I have succesfully set up Drupal Views connected to the CiviCRM database, with the php.settings.file
Yes, I have checked the Access custom data permissions.
Yes, I have also set up the View with User field, and not the CiviCRM Contact field.

I am trying to achieve this:

The count of new contacts recruited this year (date of recruitment is a custom field).

What I get:

I only get the count of new contact recruited this year that is ALSO a Drupal user. But I cannot find any criteria or field that should refine the result like that.

Do anyone have a tip for what to check for?


texts: Change address location type for all contacts?

texts:
I have a bunch of Organization contacts with "Work" addresses. I would like to change all of these to "Main" addresses. What is the most straightforward way to quickly get this done?

This is quite important, because when you have contacts with emails in different location types, you can't dedupe on import, see Import from CSV and dedupe using Email (match to contact) with PRIMARY email?

If I am wrong about this, please correct me!


texts:
I added a new page in this hierarchy:
CRM/Mymodule/Page/subdir/MyPage.php
and added a template file at
templates/CRM/Mymodule/subdir/MyPage.tpl.

But when I run MyPage.php, I get a blank page. Template contents aren't displayed. Adding smartyDebug=1 to the URL doesn't trigger a popup either. Strangely though, if I var_dump a variable, I can see the page with menu bar, page title and the variable info. So MyPage.php is being invoked.

Is it that pages don't support subdirectories? I tried adding the template file using Region. That didn't work either.

UPDATE:

I created a page and a corresponding template on CRM/Mymodule/Page/MyPage.php and templates/CRM/Mymodule/MyPage.tpl respectively and manually wrote a route. It didn't work. I then used civix to generate the same page and template. It worked. So, is it compulsory that we create using civix? But I had manually created the form and it had worked.


texts: Why does civi sets employer relationship on sharing address – even if api triggered?

texts:
I wonder why civi triggers relationship and employer changes when our users let a person share an organization's address. Existing works-for-relationship is being deactivated.
This also happens when we share an address by api call. I just wrote a script which migrates addresses of related contacts that are aequivalent but not shared to shared addresses. Civi duplicates the relationship :/

Problem here is that a significant part of our contacts works for multiple organizations.

If this is not configurable shouldn't it be restricted to work location?


texts: How do I add and control settings for social media sharing buttons on CiviCRM Petition pages?

texts:
On the Edit Petition page, I have ticked the box for 'Allow sharing through social media', but on the live petition webpage, there are no social media buttons.
If I manually copy and paste the petition webpage link into a new post of Facebook, the preview card shows only the title of the website with nothing from the petition page.
I have an image in the body of the text on the Edit Petition page which shows up correctly on the petition webpage but does not appear in the Facebook post even after using the Facebook debugger to rescrape the page.
On the Thank you page after signing the petition (submitting the form), the social media buttons look like rubbish and give the results described above.
Please help:
How do I include social media share buttons on a petition webpage?
How do I change the social media settings of the petition to create a preview card that includes the petition title and custom description?
How do I get the image on my petition page to appear in social media posts?
Thanks.


texts: Webform does not allow create new contact if contact not in select list

texts:
Webform - CiviCRM integration.    Form with 2 civi contacts - participant (individual) and program (organization)

I have a dropdown list in the webform which shows list of program organizations that can be selected.  The prompt for + create new + shows but does not allow any data entry of a new contact.

Any suggestions for how this can be enabled?


texts: Custom field group weight order on contact summary page?

texts:
As far as i can tell, the weight of custom field groups is not respected in the order they are displayed on the contact summary page - is that accurate?

I can't find anything obvious that controls that order - if anyone knows otherwise i would appreciate it!

Civi v 4.7.27 and drupal 7


texts: Can't find HTML Snippet in Profiles (Joomla)

texts:
I'm trying to add a newsletter sign-up form to an external* (Joomla) website. The guidance I've found online says that I should go to Customize » CiviCRM Profile, then click 'More' on right and select 'HTML Form Snippet', but it isn't there.

Does anybody know where it is?

*The CiviCRM installation is under a different Joomla site to the public one where the form's going.


texts: "You cannot transfer or cancel as you are not currently registered for this event."

texts:
CiviCRM  5.16.3
Logged on as Administrator
Can not click 'Transfer or Cancel' on event tab or detail of event registration without receiving error: "You cannot transfer or cancel as you are not currently registered for this event"

Ideas?

edit - we installed this (https://github.com/lcdservices/biz.lcdservices.moveparticipant) in a pinch and it worked.

Also noticed that this is a pending/pay-later event registration, could that be why?


texts: Financial types in contribution is always default and not taken from contribution page

texts:
I have contribution pages for different membership classes. Each page has a different Financial Type so that the transactions can be exported and the accounts differ for each membership type. However no matter what Financial Type is set in the contribution page it seems that 'a default' gets associated with the contribution. This does not happen for Events where the Financial Type is correctly picked up from the Event.

Maybe I have something set up incorrectly but it looks like a bug to me.

Cheers
Martin Fuggle


texts: How to link two Organizations with a pair relationship?

texts:
I have this situation I'm working on since way too long involving a sub type of Organization.
I work for a professional Union and 2 sub-organisations can belong to the same person. Which means that one contact owns 2 organizations or said differently two organizations share the same organization contact.
My first approach was to create an individual contact and an organization with a relationship of type owns/is owned by. Using the same individual contact, you could register dozens of organizations with this vertical link. The thing is that for my processes, all memberships acquired by the organization level were transferred to the individual and I couldn't have receipts for each particular organization with the specific contribution and the name of the owner (even with extended tokens)
So now, I changed my mind and focus on the relationship between organization. I've created a pair relationship and I'm wondering about how to link organizations between them. I thought about a CiviRule that would compare the custom fields created for the contact within the organization and add the relationship type (but haven't succeeded yet). I also thought about prepopulating custom fields from the URL sent after the first registration.
How would you deal with that?
(I'm working on Drupal 7.72 and CiviCRM 5.25 using a webform for the registration)


texts: "Loading Failed" when soft crediting to a Personal Campaign Page

texts:
I get a message indicating "Loading failed" when trying to credit a donation to a specific personal campaign page. I can successfully Soft Credit to the owner of the page and add "personal campaign page" as the type, but this isn't the same as crediting to a specific pcp. I was able to recreate this on the demo site - see attached.

Any ideas why in one pop up edit screen one auto fill box works but not the other? I got as far as Contribute > Form > PCP.js.tpl but was out of my depth trying to figure out what was wrong.


texts: Import Contacts creating dupes despite dedupe rules

texts:
We are currently updating a member database with returning and new students/contacts. In the past we have been able to import lists updating the returning students, but now new duplicate records are being created for each of our returning students. I have tried importing using several dedupe rules (including ones that worked in prior years) and also selecting update and skip, but still get duplicates.

What am I missing? Since last year, I have udpated WordPress, CiviCRM and PHP, but I don't know if that could cause this sort of problem. Any suggestions are welcome.

CiviCRM 4.7.31
Wordpress 4.9.6
PHP 7.1


texts: Exporting group contacts to an excel file

texts:
How do I export a group to an excel file?  Pretty standard.  Wanting to export email as well as name, mailing address, city, postal code.

Thank you,
Shara

Using Wordpress


texts: Meaningless error report when importing multi-value custom fields

texts:
I'm trying to import some multi-value custom field and I am getting what is clearly a badly formed error message. I've eliminated most of my errors by careful perusal of my import data and correcting a couple of typos. But I can't find the last one.

It gives me a link to an error CSV to export (like normal contact import) but it contains what looks like code to me. This is what it gives me in 2x6 cells of the CSV. There is also a bit of html showing as text (line break and "warning" in bold, but I can't workout how to show these in SE)

Warning:  Declaration of CRM_Custom_Import_Parser::run($fileName  $separator  &$mapper    $skipColumnHeader = false

What does this mean???

Note that the documentation calls it multi-value, but the tag I have found is multi-record which describes it better.


texts: Joomla release 3.7.2 appears to have broken the menus

texts:
I applied the Joomla 3.7.2 update yesterday in my test site. Now when I navigate to CiviCRM the menu doesn't appear at all.

I am running CiviCRM 4.7.19 and Joomla Version is : Joomla! 3.7.2 Stable [ Amani ] 22-May-2017 09:46 GMT.
 The Joomla Platform Version is:    Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

Anyone else seen this behaviour and , if so, is there a fix for it?


texts: can't administer CiviDiscount (v3.3) after upgrade to civicrm 4.7.16 wordpress

texts:
I recently upgraded my civicrm wordpress installation and can no longer access the administration screen for cividiscount.  The navigation menu link (Administer > CiviDiscount) points to http://mydomain.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/cividiscount and that just lands me back on the CiviCRM dashboard. I've tried http://mydomain.org/wp-admin/admin.php?page=CiviCRM&q=cividiscount but that lands me on a white screen that just says "Thank you for creating with WordPress. Version 4.7.2"

discount code field still appears on event registration form.


texts: How can I use the AJAX API to create a Contact Us form?

texts:
I am attempting to interact with my CiviCRM backend using the AJAX API. I created a 'contact' page in WordPress, referencing a profile I created solely to load the CiviCRM javascript into my custom page. The template is part of a custom theme I have created from scratch.

To test, I can open the contact page in my browser and drop this into the console:

CRM.api3('Contact', 'create', {
  contact_type : 'Individual',
  first_name : 'Test',
  last_name : 'Aroonie',
  email : 'testaroonie@verizonsucks.net',
  note : 'Hello I am contacting you thx'
});

This gives me an OK response and creates a new contact as I expect, when I'm logged in to wp-admin. However, when I try this in an incognito window, I get an HTML response saying "You do not have permission to access this page."

I read the permissions documentation, which recommends implementing hook_civicrm_alterAPIPermissions() to override contact-create permission, which I have done in my theme's functions.php. It doesn't look like this hook is being called.

Am I on the right track here? If so, what details have I missed?


texts: How can I refresh a custom data tab in the contact summary?

texts:
I want to store an email address (or phone or address) in a custom group when they are deleted. So if for contact John Doe the email address john.doe@example.org is deleted, it is stored in the custom group Former Communication Stuff. This works nicely on the pre and post hook but the custom group (which is Tab with table) tab is not refreshed when an email is deleted. And I would want the tab for the custom group refreshed when I delete an email address.

I have seen related questions here, notably Can I update/requery a custom field that got changed via another field on the same page?. However, this solution does not work for this case. I do not see any ID I can use in jQuery on the custom data tab, and if I do try to use one I get an error (just keeps running) either when adding the email again or when deleting the email.

I have one solution, which is to do a location.reload on the inline edit form, but that seems pretty rough. Any suggestions for another solution? And this is a going to be a generic extension, so anything that uses the random ID "#ui-id-17" does not work because the number could be different in many installs?


texts: Is it possible to have multiple author for a module extension? I'm extending last year's GSoC project. So, I need to have two author names for the module.


texts: How to raise a form error in \CRM_Core_Form::postProcess()

texts:
I have a class with a signature:

class CRM_Contact_Form_Task_FooPdf extends CRM_Contact_Form_Task {

What generates a PDF. During the PDF generation, there might be an error. This task also uses the standard mail template:

public function buildQuickForm() {
  // Add message templates.
  CRM_Mailing_BAO_Mailing::commonCompose($this);
  CRM_Core_Resources::singleton()->addScriptFile('civicrm', 'templates/CRM/Contact/Form/Task/EmailCommon.js', 0, 'html-header');
  $this->addDefaultButtons(ts('Continue'), 'done', 'cancel');
}

It works totally fine. It shows up among the actions on a search form, when I select it, the template UI shows up, and i have access to the data. The only issue is that during the PDF generation, sometimes I need to raise an error, which is not a fatal error, but something that the user must correct himself.
At the PDF generation, i am in the \CRM_Core_Form::postProcess() phase. Can I set a form error and re-display the form with the submitted values?

Issuing this (and of course skip to stream the PDF) does not work, as I am redirected simply to the main admin page of CiviCRM, the form is not re-generated:

$this->setElementError('text_message', 'moo');

But I guess it's because i am already at the postprocessing.


texts: WordPress Cron Events for running scheduled jobs on CiviCRM

texts: Need your help...I'm new to CiviCRM and I'm trying to create a cron job for automatically running all the CiviCRM scheduled jobs..I was wondering if it's possible to do this through the WordPress Cron Events Tool?


texts: Member since date is being updated on import but we dont want it to!

texts:
using CiviCRM 4.4.14.
We're trying to update memberships with an import using data from a direct debit processor. In field mapping we're matching the pay out date to 'Membership start date', but some how this is also updating 'Member Since Date' too, despite not mapping this bit.

We really don't want this to happen as we loose how many years someone has been a member and the membership status then sets it's self to 'New'.

It was suggested that we use the start date of the payment plan as the 'Member Since' date, but this would loose any info about memberships that started using a different payment method (i.e. all of them!)

Any help greatly appreciated!
Nicola


texts: Unable to load the recipients group when sending mailing with Civimail

texts:
I am running CiviCRM 5.17.4 on Wordpress 5.2.3. The problem I am facing is that
 I am unable to send mailing to mailing lists (defined as groups) via CiviMail.

When I try to enter the group in the Recipients box I get Loading Failed message and none of the available groups is loaded (see image below). The problem appears for existing and new mailings.

Interestingly when I re-use the existing mailing I can still send it to a previously used group (though I cannot change the recipient lists). The groups load normally in manage group page.

Any advice on the problem or debugging suggestions would be very welcomed.


texts: Activity 'Result' field missing from API

texts:
The default field on the Activity API doesn't return 'result' field by default, or even when specified as a return value. I've never added one of these before, if someone could let me know how it's done I'll sort a PR out. Thanks!

If anyone's interested - the use case is deleting Twilio's copy of messages after a period on a scheduled job. The return value is Twilio's SMS Unique ID.


texts: CSS and JS Files aren't loaded - CiviCRM 5.18.2 & WordPress 5.2.2

texts:
Fresh install of CiviCRM on a WordPress multisite yet no interface loads on the status page - seems that all the assets throw a 404 error causing this.

Tried updating from 5.18.1 to 5.18.2 but no success.


texts: Conduct survey - can't search to reserve after interviewing

texts:
I have a problem that is reproducible on the 4.6 Drupal demo site.

It has to do with the Conduct Survey screen in CiviCampaign. I cannot search for people to reserve after interviewing people.

To reproduce ....

Start with a Campaign and a Survey
Visit Conduct Survey and click Search on the Reserve Respondents tab
Click on the Interview Respondents tab
Click on the Reserve Respondents tab
Click Search on the Reserve Respondents tab

I expect that steps 2 and 5 should give the same response - present a list of contacts to Reserve. That happens for Step 2 but not for Step 5.

Using Firebug I see the following at Step 2 ...

GET  https://example.org/civicrm/campaign/vote?search=1&snippet=4&sid=99&cid=99999&qfKey=xxxxx_9999
POST https://example.org/civicrm/ajax/rest?snippet=4&className=CRM_Campaign_Page_AJAX&fnName=voterList

.... while at Step 5 I see only ...

GET  https://example.org/civicrm/campaign/vote?search=1&snippet=4&sid=99&cid=99999&qfKey=xxxxx_9999

The only clues I have is that the qfKey has a different value for '_9999' at the end, and I get the following error on my Javascript console at step 3 ...

TypeError: invalid 'in' operand a
https://example.org/sites/default/files/js/js_mSqimfUYz_VZK2olecI6CNgGUcoseWz2Uf-IxjMP5mA.js
Line 1079


texts: In 4.7 CiviCase relationships are being inserted the wrong way round: bug or feature?

texts:
On the 4.7 Drupal demo site I created a case of type 'Housing Support' for Rebekah Adams. I added Beulah Barkley as the 'Benefits Specialist. My user (Test Test in the demo) was the 'Homeless Service Coordinator'.

The problem is that the 2 relationships get added differently.

The image shows the relationships tab from Rebekah Adams' record (the case client). Note that Test Test is her Homeless Services Coordinator (OK), while she is the Benefits Specialist for Beula Barkley (Ouch, wrong way around).

Both relationships are defined the same way (B->A notation) in the Case definition ...

This is clearly a bug as it used to work fine in 4.6.


texts: After upgrade CiviCRM 5.28 to 5.32.2. Cron is Stop When Mailing start

texts:
After Upgrade CiviCRM version 5.28 to 5.32.2. Cron stops when mass mailing start.
After mass mailing completed Cron is again start.
CiviCRM: 5.32.2
Drupal: 7
Php: 7.2.24


texts: CiviEvent book multiple event at a single checkout

texts:
EDITED: We are using Eventcalender extension to display all events on one page.

For example Yoga Classes happens every week on Monday. Now for an attendee who would like to book 1st week, then 5th, 9th, 15th, 22nd and some more weeks of the year has to keep registering for each week. It could be frustrating for attendee to come back every-time & enter same details to register. We thought of creating repeating events. but that does not allow to register to select multiple events at single checkout. Is there any option where CiviEvent would act like a checkout? A good example of my idea is sagenda.com.  If not, how can I get an alternative checkout function like this? Or am I missing something in existing CiviEvent? Please suggest. Thanks


texts: Membership renewal for organisations - how to remove: On Behalf Of Organization

texts:
I have setup a webform for an organisation to become a member, this process also makes a Drupal user. I roughly followed this.
The membership is with the organisation, the Drupal account is also created with the organisation email address. It might be worth noting that there are also 2 individual contacts created during this process.
1: Main Contact for the organisation
2: Representative for the organisation
When the organisation signs into Drupal and renews their membership the user is asked for this information: On Behalf Of Organization.
As the membership is for this organisation I don't want the user to see this. How do I remove this?


texts: Outlining the required steps in a case type

texts:
I'm looking for a way to document the steps that a person should go through when a case of a particular type is opened.

My steps are something like this:

Have the person fill out this form
Have them sign this document
Send them this email.  Capture their reply.
Send them this other email.  Capture their reply.

I tried using the CiviCase timeline feature, but it does not seem to let me capture more than, say, "email".  I really want more detail in the step description, but I don't want to turn every single one of our template emails into a separate activity.

I would be very happy to just use repeated "email" items in the case timeline if I could put a description somewhere of what email to send, for example.  I could not find a way to do that?

The other thing I tried is just putting the task list in the description field of the case type.  That failed due to field length restrictions.

Does anyone have suggestions?

Thank you


texts: Pulling a Report of Donors with More than One Donation, Not Recurring

texts:
I would like to pull a report of all donors who have more than one contribution. This is slightly different than pulling a report on actual recurring donations. This is my workflow:

When donors donate one time, they get a thank you card and a receipt
If donors contribute again in the same year, I save the acknowledgement for the end of the year, and send a PDF listing all the contributions with a total in the form of a generated letter

I want to use the CiviCRM to generate the form letter, but want to exclude everyone that has donated one time, since they will have already received sufficient documentation and acknowledgement.

Any advice on how this can occur?


texts: Since upgrade, dompdf.php is presenting a security risk?

texts:
Upgraded to 4.5 a few weeks back on Joomla 3.3.6 and everything is working fine, except for a warning that I see when I first access CiviCRM. Reads:

  Security Warning File
  /home/[directory]/public_html/administrator/components/com_civicrm/civicrm/packages/dompdf/dompdf.php
  presents a security risk and should be deleted.

Any idea what's causing this and what the proper way to address it might be (short of deleting the file)?


texts:
I have a some event roles (tutor and administrator) that are not chargeable. I want to be able to add these from the back end - Register Event Participants, but I have to accept a fee and provide charging information which is not wanted. I've set the roles to be "not counted" but that doesn't help. If I add a zero fee then that is going to show as an option for the online booking. In How do I configure a free event ticket option for internal use without it showing up on the website? there are two suggestions: I can't go down the price set for these existing events and the other option suggests that you can have a role that isn't charged.
Am I missing something?
I might be able to do it by importing participants but that's more work than it should be. as I'd have to export event and contact data and then create a spreadsheet.


texts: What should be entered in the campaign field when importing a CSV file?

texts:
I'm trying to import a CSV file with donations that need to be linked with a certain campaign. I tried putting the campaign name, then the external id, and even just "matching" but all of them are generating an error. Any advice?

I am running CiviCRM 4.6.19 on Drupal. The error message is:

  'xyz' is not a valid option for field campaign_id


texts: Invalid Currency error when using custom template

texts:
I'm creating a custom thank you following the instructions here
https://docs.civicrm.org/user/en/latest/contributions/manual-receipts-and-thank-yous/
However the {contribution.total_amount} token is causing an error saying

Invalid currency "USD****~~~~USD****~~~~USD****~~~~USD****~~~~USD"

All of my contributions are in dollars and that's what I've also set in localization.
What could be causing this?
This only happens when using the grouping option.
I'm wondering if it relates to
https://github.com/civicrm/civicrm-core/blob/3bfdcfb534a0b27a4f7f4c65bb07f2670ac31d14/CRM/Contribute/Form/Task/PDFLetterCommon.php#L74
CiviCRM 5.32.2
Joomla 3.9.23


texts: Add people who have used contribution page to a group (or tag them)

texts:
I want to add everyone who made a contribution from a particular contribution page to a group.

Is there a way to do that?


texts:
I'm trying to follow the WP set up instructions for scheduled jobs https://docs.civicrm.org/sysadmin/en/latest/setup/jobs/ using wp-cli

I can't figure out if I have things working correctly or not!

What response am I expecting when I run the wp-cli job.execute command?

I get:

Array
(
    [is_error] => 0
    [version] => 3
    [count] => 1
    [values] => 1
)

In the civicrm wp admin panel the system status shows last cron job run at approx the time when I ran the wp-cli command , so I guesss this means things are working ok?

But the logs in admin/system setting/scheduled jobs don't show any matching logs for the enabled jobs ?


texts: Creating pdf from membership results in blank page

texts:
After identifying contacts for a letter from Find Member and picking the template, and clicking on Create pdf or the other formats (same with Preview too). I get a blank page and the following error: "Failed to open http://www.site.org/administrator/?option=com_civicrm&task=civicrm/member/search" with an HTML error: "HTML1527: DOCTYPE expected. Consider adding a valid HTML5 doctype: "".

I am using tokens from both contacts and membership.  I can create a pdf from Contacts but all the membership tokens are blank.  This worked last month when I created the pdfs from membership.  Did something change in .8 .9 or .10?

Aaron
Joomla 3.6.2, CiviCRM 4.7.10, PHP 5.6.24,


texts:
In the CiviContribute module is a form that allows a recurring contribution to be updated.  This form uses the /civicrm/templates/CRM/Contribute/Form/UpdateSubscription.tpl template, which has the code  ({ts}every{/ts} {$frequency_interval} {$frequency_unit}) in it.  However, this comes out as "(every )".  It appears that the variables are not being set.

I am accessing this page via a link sent when the recurring payment was set up.

Am I missing something or doing something wrong?

Thanks


texts: What's the right crontab entry for running cv?

texts:
I'm trying to get cron to run cv.

Putting this in crontab:

*/5 * * * * /usr/local/bin/cv api job.execute --user=harrumph

produces...

Failed to locate civicrm.settings.php. By default, this tool searches the parent directories for a standard CMS (Drupal, WordPress, etal) and standard civicrm.settings.php. Symlinks and multisite configurations may interfere. To customize, set variable CIVICRM_SETTINGS to point to the preferred civicrm.settings.php.

The correct path to civicrm.settings.php is

/var/www/html/wp-content/uploads/civicrm/civicrm.settings.php

SO...

How am I supposed to use EXPORT in crontab so as to point cv to where it should be looking?


texts: Upgrade fails with Row size too large error

texts:
Upgrading CiviCRM from 4.6.26 to 4.7.16 is failing at step Upgrade DB to 4.7.beta6: SQL with the following error:

  ALTER TABLE civicrm_event ADD COLUMN max_additional_participants
  int(10) unsigned DEFAULT 0 COMMENT 'Maximum number of additional
  participants that can be registered on a single booking' AFTER
  is_multiple_registrations [nativecode=1118 ** Row size too large (>
  8126). Changing some columns to TEXT or BLOB or using
  ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row
  format, BLOB prefix of 768 bytes is stored inline.]

Everything I can find says that this is a fairly fundamental MySQL restriction but I can't find any much trace of people hitting it with CiviCRM at all.

The MySQL server version is 5.5.54 which should be supported, and I have tried increasing the InnoDB log file size from 5Mb to 48Mb as some things say that will help but it made no difference.


texts: Wrong compiled [civicrm.files] variable in Resources URL

texts:
My issue is [civicrm.files] variable in Resources URL contains full real absolute path on our server '/var/www..' etc.

It constructs as such:

https://www.website.com/var/www/wp-content/uploads/civicrm/

All variables in Upload Directories currently set as portable.

I'm using CiviCRM 5.14.3 on Wordpress 5.1


texts: CiviMail - Next/Send test disabled - Cannot send mass email

texts:
Working on this a while, hope you can help. Version: 4.7.10 + Drupal 7.50 on Debian 8 w/ Apache 2.x + Postfix

The problem (the following steps are taken in CiviCRM)

Mailings -> New Mailing
Mailing Name: Some Name Goes here
Template: Sample Responsive Design Newsletter - Single Column Template List item
From: TestingAndWorking@Mydomain
Recipients: MyTestGroup
Subject: This is a test

HTML: A-Ok unsubscribe, opt-out & domain address are there - no errors flagged

Text: A-ok unsubscribe, opt-out & domain address are there - no errors flagged

Result

Preview HTML/Plain Text: Ok.
Next and Send test (for both single email and Group) are disabled

Steps taken to resolve

Ensure all required tokens are in place. Check
Test email settings. TestingAndWorking@Mydomain: Check
Check Headers, Footers, and Automated Messages: All but Resubscribe are set as default and enabled.
Is the bounce email address setup: Yep. What about an outgoing mail account? Yep - Set as Email-to-Activity
smartyDebug=1 -- Results in Authorization Failed on (Mailing,22&smartyDebug=1)
Check table civicrm_mailing : reply_id = 8
Outbound Mailer: mail()
Was an A/B Test tried. Yes. Result: Next works right until step 3 (Compose). Send test works for both individuals and group BUT Next is still disabled. Does smartDebug show anything? No.

Is there a way I can hack some piece of code to allow Civi to move on? What did I miss?


texts: Allow recurring contributions on membership form

texts:
I have a membership signup form and a I have the Additional Contributions amount section enabled.  When I try to enabled Recurring Contributions, I get this error after saving it,
Recurring Contributions
You cannot enable both Recurring Contributions and Auto-renew memberships on the same online contribution page.

This doesn't make sense, because none of the Membership options have an auto-renew option.

I am on civi 4.7.27 and Wordpress 4.9

SCREEN SHOTS ADDED


texts:
Probably a Drupal issue, but you never know :

I am running Drupal 7.56 / Civi 4.7.20

I have been using Views extensively for some months now. I want now to create custom pdf pages from some Views.

I have installed jQuery_update, then Views PDF Display Module, then copied fpdi and tcpdf libraries into the Libraries folder (via FTP).

Now, when I want to add a PDF Page to a View, I get the following error message :
Fatal error: require_once(): Failed opening required 'sites/all/libraries/fpdi/fpdi2tcpdf_bridge.php' (include_path='/home/my_hostname/www/www/sites/paroisse/civi_extensions/nz.co.fuzion.cmcic-master/:/home/my_hostname/www/www/sites/paroisse/civi_extensions/nz.co.fuzion.extendedreport/:/home/my_hostname/www/www/sites/paroisse/civi_extensions/org.civicrm.sms.twilio/:/home/my_hostname/www/www/sites/paroisse/civi_extensions/com.drastikbydesign.stripe/packages/:/home/my_hostname/www/www/sites/paroisse/civi_extensions/com.drastikbydesign.stripe/:/home/my_hostname/www/www/sites/default/fpdf:.:/home/my_hostname/www/www/sites/all/modules/civicrm:/home/my_hostname/www/www/sites/all/modules/civicrm/packages:.:/home/my_hostname/www/www/sites/all/modules/civicrm:/home/my_hostname/www/www/sites/all/modules/civicrm/packages:/home/my_hostname/www/www/sites/all/modules/civicrm/vendor/tecnickcom:/home/my_hostname/www/www/sites/all/modules/civicrm/vendor/phpseclib/phpseclib/phpseclib:/home/my_hostname/www/www/sites/all/modules in /home/my_hostname/www/www/sites/all/modules/views_pdf/views_pdf_template.php on line 22

I suspect that this is due to a bad installation (btw, the fdpi library contains no fpdi2tcpdf_bridge.php), but find no clear and up-to-date installation tutorial.

I am not a programmer (just able to edit and ftp a file if necessary)

Any help is welcome.


texts:
Good morning,

Every time I search for a contact, which I know is on our database, I get the message 'No contact found'.

Please can you advise?

Many thanks

Kind regards

Myriam Barker


texts: Civicrm Migration Giving Foreign Key consrtant error

texts:
I am migrating civicrm from version 4.2.9 to 5.16.0. While running the upgrade url
giving this error "ALTER TABLE civicrm_membership_type DROP FOREIGN KEY FK_civicrm_membership_autorenewal_msg_id [nativecode=1091 ** Can't DROP 'FK_civicrm_membership_autorenewal_msg_id'; check that column/key exists]". But I didn't find that consrtaints for that table.
Please help me to get out of this.


texts: CiviEvent: Event info and registration form on one page?

texts:
Right now, when I create an event, there is one web page for the info about the event, with buttons to click to get to the online registration page with a form where they fill in their name and email and actually register for the event. Is it possible to have the event info and registration form on one page, so they don't have to click a button and go to a different page, but can just fill in their name and email and click "register" one time and be done? This is a free event, so payment is not a concern.

I'm running CiviCRM in WordPress 4.7.4, if that matters.


texts: why are contacts images stored as absolute URLs?

texts:
I have made a copy of my civicrm instance i.e from http://www.example.com/example to http://www.example.com/example1 and when viewing a contact, the contact's image url is still pointing to the old sub domain http://www.example.com/example/civicrm/contact/imagefile?photo=firstname_lastname_6580lk2b77fb4029f5a00000035d9.jpg

which causes long response time to view a contact and also i get a warning (Warning: getimagesize(http://www.example.com/example/civicrm/contact/imagefile?photo=firstname_lastname_6580lk2b77fb4029f5a00000035d9.jpg): failed to open stream: Connection timed out in CRM_Contact_Page_View->preProcess() (line 170 of /var/www/example1/sites/all/modules/civicrm/CRM/Contact/Page/View.php)

resource urls and directories have been updated, i'm on version 4.5.5

Note that this is not the case on http://www.example.com/example/


texts:
I'm using Drupal 7.43, and civicrm 4.7.4.  Is it possible to limit access to a contribution page through Civicrm ACL's or Drupal roles?  I want to set up a contribution page for new members to pay an initiation fee, but I don't want members to see it once they pay.

I can set up a drupal block, and have the link to the contribution page in the block, and assign the block to a role of new members who haven't paid the fee yet, and have the block disappear once they do, but they can still go to the url and access the contribution page.


texts: Network Error Unable to reach the server when trying to expand search

texts:
using Civi 5.14 on WordPress 5.2

We are getting a Network Error Unable to reach the server error when attempting to go to page 2 of a search list.  I have read the other posts and checked what they suggested. The console only shows "JQMIGRATE: Migrate is installed, version 1.4.1" It doesn't indicate that this is wrong.  Am I missing something?


texts:
I have a token for a custom field in my email template, but its not being replaced with the value when the email is sent.

What's wrong?  How can I fix it?


texts: Permission to edit activities but not contacts?

texts:
The organisation I'm setting up Civi for does not assign activities to individual people but works in teams.

For example a client might be referred to the housing team to see if they qualify for housing. This activity would be created by a caseworker and edited / completed by a (any) member of the housing team.

This is just one example, there are also other cross-team activities.

The only way I have been able to make this work is by giving all caseworkers edit access to all other caseworkers.

This has not gone down at all well with the caseworkers who do not want their contact details viewable - and editable! - by so many people.

Any advice on how I could make it possible for A to edit an unassigned activity created by B, without giving A the ability to see or edit B's contact information?


texts: Does Using CiviMail for mailing lists on AWS violate the AWS Terms of Service?

texts:
I noticed on a blog on the site (https://civicrm.org/blog/andrewhunt/alternatives-to-mandrill) a suggestion to use Amazon SES as an alternative to Mandrill for emails, and I also noticed an old CiviCRM/Drupal image on Amazon Marketplace. We've customized CiviCRM for a customer who is already using the software for their email campaigns and wanted to deploy on AWS but we're concerned about terms of service preventing the facilitation of mass unsolicited emails. Does anyone have experience with this?

Specifically the Amazon terms state:

You will not distribute, publish, send, or facilitate the sending of unsolicited mass e-mail or other messages, promotions, advertising, or solicitations (like “spam”), including commercial advertising and informational announcements. You will not alter or obscure mail headers or assume a sender’s identity without the sender’s explicit permission. You will not collect replies to messages sent from another internet service provider if those messages violate this Policy or the acceptable use policy of that provider.


texts: Event registration form does not show submit button when a 100% discount coupon is used

texts:
I run Civi 4.7.13, and trying to setup an online registration form for a CiviEvent.
When no coupon is used, the event registration submit button is the "Pay Pal Checkout" button.
But when the amount is 0 because a 100% discount coupon is used, there is no paypal button and the registration form cannot be submitted.


texts:
The Unsubscribe link (in mailings) works fine if I am logged in as administrator, but I have "Access Denied" to the opt-out form if not.

(I have defined an Unsubscribe Group, with public visibility)

How can I fix that ?


texts: I have an uncorrect css path in the front-end html code

texts:
I am using CiviCRM 5.18.3.with Joomla! 3.9.12 and I can not solved a path problem within the html page where "/components/" should be replaced by "/administrator/components/" (see below). It works OK for the back-end but not for the front-end ??
Please, your help would be well appreciated. Tks.

      ...


texts:
Is there any documentation available on how to generate the invoices with the new functionality introduced in civicrm 4.6. I assume I can generate and email an invoice but am not able to figure out how.

I have enabled TAX & invoicing in the configuration and have read the following articles:
https://civicrm.org/blogs/jamienovick/coming-soon-sales-tax-including-vat-and-invoicing-civicrm
https://civicrm.org/blogs/tonymazz/civicrm-46-will-support-sales-tax-vat-and-invoicing
http://wiki.civicrm.org/confluence/display/CRM/Sales+Taxes+and+Invoicing+-+Phase+1


texts: How best to rearrange the order of the address fields on the New individual/contact from?

texts: I'd like to play with order and layout of the address fields on the New Individual form.  I understand that in the localisation setting s this can be achieved but I am not having any luck with the for a NEW individual/contact.  Is there not a .php file that i can edit the HTML output and manually rearrange the order of the fields?  Is this the best approach? Thanks, Joe.


texts: Some tokens not work with CiviRules 2.1 and E-mail API 1.17.2?

texts:
I'm using WordPress 4.9.8, CiviCRM to 5.4.0, CiviRules 2.1 and E-mail API 1.17.2. I've created a Rule that send email to contact when added to a group. I've used some token here
https://docs.civicrm.org/user/en/latest/common-workflows/tokens-and-mail-merge/#available-tokens

But only token {domain.email} and {domain.name} can show. Other tokes is empty. Is it bug?


texts: How can I have a repeating activity in a case standard timeline?

texts:
I am currently exploring CiviCase. I like to setup an activity that tracks the progress of the client every 6 months. Is this possible with a case standard timeline? I can't predict how many times this tracking activity should be entered, until the case is closed. I'm thinking of adding the timeline:

Open Case
Tracking Activity #1 (6 months)
Tracking Activity #2 (12 months)
...

Can I have the Tracking Activity #2 appear only after the Tracking Activity #1 is completed? Is this where the Reference Onset comes into play?


texts: What is the most reliable method for merging records with memberships?

texts:
I've noticed recently on one site that I look after that a small number of records appear to have 'lost' their membership record. The site in question has organisational memberships and individuals have membership by dint pf their relationship. What I've seen is that while the individuals involved continue to show their membership, the related org record is showing no membership record. Invariably there is an org record in the trash which has the membership record associated with it. So I've got a little digging to do to understand why the org record with the membership is getting deleted, while a duplicate with no membership remains.

Odd behaviour with merging records may be part of the issue: if I recover the deleted record I then have two 'duplicate' records, one with a membership and one without. If I merge the record with the membership into the other one, and ensure that the checkbox is ticked to move the memberships, I end up with a single record with no membership. If I flip the two records and then merge, I end up with one record with a membership, which is what I want. Why, when I have explicitly ticked to move the membership record, is it not getting moved? This strikes me as highly dangerous behaviour - at the very least I would expect to see a large red alert to warn me that I was about to delete a record with a membership record that isn't being transferred to the merge result. Unless it's a bug?

I note that there is also an additional checkbox when merging, to "add a new membership". Do I need to check this as well in order for the membership to be moved, even though I'm not adding a new membership but moving an existing one?


texts: For an extension, to modify database data, is it better to use SQL or API

texts:
Simple question here,
From a computing and 'civicrm correctness' point of view, is using SQL (via CRM_Core_DAO::executeQuery or similar) or using the API ( civicrm_api3('Contact', 'create', $params)) better?
Thanks,
V


texts: How do I hide exposed filter options in Drupal View?

texts:
Using CiviCase and need to hide two case status' that we aren't using from Drupal Views exposed filters (Pending and Urgent).

Pending and Urgent are disabled in the CiviCRM Case Status UI.

Just want end users to see Ongoing and Resolved as options.