texts: Fill in custom field of type contact reference field from javascript returns TypeError

texts:
I have a custom field, which is a contact reference field.

Based on what the user fills in on the form, I would like to fill in the contact reference field with a specific contact. Leaving the user the choice of keeping that contact, or selecting another one.

The html code of the reference field is:

<div class="select2-container crm-form-contact-reference huge crm-ajax-select" id="s2id_custom_21_-1" ...

Let's say that based on some values on the form, I want to fill in the contact with ID 188 in that contact reference field.

I should be able to do this with:

CRM.$("#s2id_custom_21_-1").select2('val', '188')

However, this returns the error "TypeError: row is undefined" in Common.js on line 387.

The error can be reproduced in the CiviCRM demo environment by following these steps:

go to Administer > Customize Data and Screens > Custom Fields
click on "View and Edit Custom Fields" for the set "Food Preferences" (used for Participants, and linked to the Fall Fundraiser Dinner event)
add a custom field of type "contact reference"
then go to Events > Register Event Participant
select "Fall Fundraiser Dinner" in event
then press F12 top open the developer tools of your browser
in the console type:

CRM.$("#s2id_contact_id").select2('val', '188')
this should fill in "Wattson, Laree" in the contact field, which is good
find out the id of the custom field on that form (it should be at the bottom of the screen in the "Food preference" section). In my case it was s2id_custom_13_-1
in the console type:

CRM.$("#s2id_custom_13_-1").select2('val', '188')

==> you shoud see TypeError: row is undefined [Learn More] in the console

Looks like a bug to me. Or am I doing something wrong?


texts:
I'm trying to attach an event to a contribution that I enter by hand. I see that the "source" field is where I need to do that. I've been entering the name of the event into the source field but my totals in the revenue report are still zero for the event. Is there a way that the source can be a drop down of events to choose from or is it a matter of using the exact naming of the event in the source field?

Any help is appreciated. Thanks


texts:
Our website company cannot get CiviCRM to work on new or existing pages.
I can create a contribution page input form and it previews on our CiviCRM page (which has the 'civicrm' slug)
I can place shortcode on the CiviCRM page and, again, it will display okay and it will display forms according to the form 'id' when changed in the shortcode.
They say they've modified the Wordpress install so we build our pages based on their template, and that they've bypassed that so all CiviCRM shortcode will insert forms on any page - wherever we place it in the design. It just doesn't show up. It only displays on the page with the 'civicrm' slug.
Should I look to have it installed with another website designer?
Thanks Guys


texts: Upgraded to 4.6.2 - 'New Mailing' brings up 'Unknown Extension' error

texts:
Just upgraded CiviCRM from 4.5.3 to 4.6.2 on Wordpress. All seems to be working apart from when I select 'New Mailing' option under 'Mailings' - it takes me to a screen showing the message below:

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

Unknown extension: .

Return to home page.*

Any suggestions?


texts: civivolunteer error creating event volunteer opportunities through event tab

texts:
After creating an event and clicking on the volunteers tab to create a volunteer project, I try to add the volunteer opportunities on the same screen.  However I don't get the popup and I get these error messages in the browser console:

3SCRIPT438: SCRIPT438: Object doesn't support property or method 'volunteerPopup'
admin.php (59,7)

0: Object doesn't support property or method 'volunteerPopup'
eval code (24) (58,6)

WordPress 5.2.4
CiviCRM 4.7.31
CiviVolunteer 4.7.31-2.3.1


texts: Creating a report listing contacts grouped by an employer-group

texts:
How can I create a report that lists contacts & their employer, but groups them by a employer group?

I.e.

Sports

John - Adidas
Jane - Nike

Food

Jim - Kraft
Jack - Nestle

And so on.


texts: Random Occurrences of Blank Contribution Thank You Pages

texts:
This is strange. Some donors are donating successfully but getting a blank thank you page. They get an email confirming their donation, but nothing on screen. D7 CiviCRM 5.31, Omnipay Cybersource
I can't seem to find any issues in the log either.
The URL at the blank screen is /civicrm/payment/ipn/1
When it works correctly, the thank you screen has a url of  civicrm/contribute/transact?_qf_ThankYou_display=1&qfKey=**********************
Any ideas?


texts: Upgrade from 4.7.14 to 4.7.15 failed on Database Upgrade

texts:
I tried to upgrade from 4.7.14 to 4.7.15 today.  I followed the instructions 1 - 3 in the documentation.

Everything looked good up to that point.  I got a message that installation was successful.

Then I clicked on the link to run the Database Upgrade, but I forgot to do step 4: delete the cached files in

   [yoursite]/media/civicrm/templates_c

I got the following error:

Initialization Error

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

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT *,  config_backend, locales,         locale_custom_strings
 FROM civicrm_domain

 WHERE (  civicrm_domain.id = 1 )

 [nativecode=1054 ** Unknown column 'config_backend' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT *,  config_backend, locales, locale_custom_strings
 FROM civicrm_domain

 WHERE (  civicrm_domain.id = 1 )

 [nativecode=1054 ** Unknown column 'config_backend' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19     mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info="SELECT *,      config_backend, locales, locale_custom_strings
 FROM civicrm_domain

 WHERE (  civicrm_domain.id = 1 )

 [nativecode=1054 ** Unknown column 'config_backend' in 'field list']"]
)

At that point, I noticed that I hadn't deleted the cached files, and so I deleted them.

I tried to re-install 4.7.15, and again, I got a 'success' message.  When I went to run the Database Upgrade, I got the same error as above.

I've been running CiviCRM for 2 years, multiple upgrades, and no problem until today.  I checked the StackExchange and there are several mentions of this problem, and how it is fixed by running the Database Upgrade.  But if I can't run the Database Upgrade, I don't know how to fix this.


texts: Sending an email (from Actions) to an individual hangs

texts:
I hope I can get some light on this problem.  I am sending an email to an individual, not a mass email, just one email to an individual and when I click on send, it shows the system thinking but does not actually send the email and it just hangs in there forever.

I tried different emails and different subjects etc. and it always happens.  I recently changed servers and maybe I still have a setting that is not right, but mass emails are sent, when someone makes a contribution emails are sent, just not when it is an individual.  What could it be??

Thanks for the help.


texts: payment page - total not correct when using Tax

texts:
I have setup a webform to take registrations and payments for events. I have enabled tax to be 10% and have calculated the cost of each event to be 10% less, so Civi will add on the tax to each line item (i assume that this is the only way Civi Tax works). The total is $0.1 by out. Here is why:

$75 - 10% = $68.18 (I have set the Participant Fee to $68.18)

$68.18 * 3 events = 204.54
Add the tax: 204.54 * 0.1 = 20.454 ($20.45, rounded)

$20.45 + 204.54 = $224.99

Edit: Seems like a similar issue to https://github.com/civicrm/civicrm-core/pull/9711 & https://github.com/civicrm/civicrm-core/pull/9710

Are these patches still relevant?


texts: How can I add the "automated mailer task cron job"?

texts:
I'm sorry guys,  I have really no idea what I'm doing. I'm just trying to learn as I go.
I've been checking out forums and videos and it all leads me to this: I need to know the command so I can add the cron job from my cpanel, so that my civiCRM starts sending the emails.
I have already enabled the option "process_mailing" on scheduled jobs settings.
Sorry I'm so lost... hope any of you can help me.


texts: (??) GDPR extension ver. 2.8 issue? (from 5.18.2 to 5.22 CiviCRM ver.)

texts:
We manage CiviCRM for some NPO in SaaS mode. We noticed that probably the GDPR extension ver. 2.8 has some problems.

Indeed on:

Wordpress 5.3.2
both on PHP ver. 7.3 and ver. 7.2
both whit PHP-FPM and Fast-CGI compression
PHP open_basedir both enabled and disabled
MySQLversion: 10.3.22-MariaDB-0 + deb10u1
on all CiviCRM ver. from 5.18.2 to 5.22

a simple export to .csv of only 2000 contacts (only Name, Surname, Email) takes at least 200 seconds and causes the host down (if it is set to the canonical 100s  Time Over)

We also have the feeling that everything is going a little slower, especially to access CiviCRM at the first connection

With version 2.7 of the GDPR Extention the same operation closes correctly on 3 seconds.

Can anyone check if he has this problem?


texts: I am new to CiviCRM and I have just installed it in WordPress. Am having problems with the integration. I would like users to register to become members, once they registered, they should be redirected to their profile page where they can view their dashboard which consists of their contributions and membership status. I am not able to achieve this at all. Secondly, when deploying a form, they don't show the labels. So if someone is filling a form, they won't know if the field is asking for email or phone number. I really need help with this;  I am volunteering for a charity organisation who is looking to put their membership structure in place desperately.


texts: Sync WordPress users to Organizations instead of Individuals?

texts:
We're using the WordPress integration of CiviCRM.

When we create a new WordPress user, civiCRM creates a new Contact - Good.

However, when it does this is creates an Individual type Contact. I want civiCRM to create Organization type Contact when I create a new WordPress user.

Is this possible? If not, am I able to convert Individuals into Organizations? I've seen an extension for it on the site but didn't know if it worked well or if there were alternatives.

Thank you for any advice


texts:
I want to give others the chance to do something when certain events happen in my extension.

So to be clear: I'm not wanting to use existing hooks in my extension, I'm wanting to create a new hook that my extension will invoke and other code may choose to react to.

I couldn't find anything in the developers' guide about this. Looking at the source makes me think that maybe I should be doing something with CRM_Utils_Hook or perhaps \Civi::dispatcher()->dispatch('hook_my_new_hook', $some_event_object)?

Is there a standardised way to do this? Are there any good examples?


texts: CiviEvent registration, edit wording relating to a drop down menu

texts:
How can I edit the wording in a set field beside a drop down box when a person is registering to attend an event? They could also use the drop down box to register a co-worker.
I.e., current wording says "Register someone at your organization" and we want to tweak to say "Register yourself or someone at your organization."
Is this possible?
Thank you!


texts: want to change search algorithm in custom fields

texts: Suppose I have phone number having format as (xxx)xxx-xxxx.Is their anything in search so that I can simply search with this format which excludes brackets and characters like xxxxxxxxxx.


texts: how to import/Export data from old version to updated version of CiviCRM

texts: recently I have updated my CiviCRM Plugin in Wordpress.Now how can I import/export data of the old version to the new version?


texts:
I did create my first customized Contact form with Form Builder. However, I am unable to create a Membership form: currently le proposed field sets are limited to «Individual» «Activities» «Organization» and «household».
Am I missing something or is it merely the current state of the project ?


texts: 5.28 upgrade failed at 5.29 beta upgrade - how to fix?

texts: I started an upgrade from 5.28.3 but it crashed while updating to 5.29 alpha1, and this traceback was in the log.  I haven't seen this problem elsewhere on SE, and am not sure how to fix.  Can anyone help?  This particular system (using Drupal) has been running since 2013 and I've not had any problems upgrading until now.  Relationships are used a fair bit in the system, which is where this problem seems to have occurred.


texts: Price Sets - Won't let me use recurring contributions

texts:
I'm running civicrm 4.6.10, drupal 7.41, and I'm trying to add a field to a price set that would let users select from a couple of different price levels for membership.

Maximum Dues $33
Regular Dues $22
Minimum Dues $11
Sub-Minimum Dues $6

They are each attached to a membership type that has recurring payments listed as an option.

However, I keep getting this error.

"You can include auto-renew membership choices for only one price field in a price set. Another field in this set already contains one or more auto-renew membership options."

I get this error even when there are not other fields in the set, or when I only make one option is the field for the memberships (like just listing maximum)

Any ideas?  Is this something I'm doing wrong or possibly a bug?


texts:
50 groups were deleted by mistake. Please don't ask how.

So from a 2 weeks old backup, we're able to extract a CSV from civicrm_group and civicrm_group_contact

group_id, name, contact_id, email

We would like to reimport the groups and their assignation to contacts. The contacts are already in the system normally. We would not want duplicate users

Afraid of simply going to the civicrm_group_contact table and just filling it through phpmyadmin

Any tip? Thanks!


texts:
We are a charity interested in CRM and I wondered if you could please provide me with some information:

A brief outline of what is on offer with your CRM package
How we could use it – the benefits
How much it would cost (initial set up and on-going)
Any difficulties in implementing the system

Many thanks,

Alice


texts:
I wanted to upgrade my Mosaico extension to the latest version. There was no upgrade link on the extensions screen so I downloaded the latest release and replaced the source files. However, the version number is still corresponding to the previous files. Do I need to do anything else to notify Civi that the files have been updated? I know in Drupal you would normally run the database update, but I don't know if there is something similar in CiviCRM? I couldn't find any documentation on a manual upgrade process.

I am running CiviCRM version 4.7.28.


texts: Email Template HTML WYSIWYG does not load

texts:
I am running on the latest version of CiviCRM, 5.17, and when I go into CiviMail to create an email message the HTML wysiwyg editor does not load. I get a console error saying
CRM.wysiwyg._create is not a function

If I put a debugger right before the line I can see the the CRM.wysiwyg object does not have ._create method but it does have a .create() method.  If I change the code to use the .create() method then it seems to loop for ever and the tab stops responding.

I had this issue on the previous version of civicrm, 5.13, which is why I tried the upgrade to 5.17.

There is a message during upgrade about updating the templates but when I click the link for more info it take me to a page saying the documents have moved.

I do have the ckEditor enabled on the site.

I am running on wordpress 5.0.4.
I did reset the cache and clear the templates_c folder but neither cured it.
Any suggestions would be appreciated.


texts: How can I use custom tokens when grouping Thank You letters

texts:
Being able to group Thank You Letters by contact is a great feature for both everyday receipts (we have a company that will donate via multiple smaller donations at once) and end of the year receipts.

But I'm running into a problem, if I use an if statement around a contribution token, the token no longer loops for each contribution printed. For example:

{crmAPI var='contresult' entity='Contribution' action='get' sequential=0 id=$note_id}
 {foreach from=$contresult.values item=contribution}
  {if $contribution.non_deductible_amount gt 0}${$contribution.non_deductible_amount}{else}N/A{/if}
 {/foreach}

The function doesn't display anything when I 'group by' (If I run a thank you letter for a single contribution it does work.)

In this example:

{capture assign='note_id'}{contribution.contribution_id}{/capture}
{crmAPI var='result' entity='Note' action='get' sequential=0 entity_table="civicrm_contribution" entity_id=$note_id}
 {assign var='note_count' value=$result.count}
  {if !$note_count}None{elseif $note_count}
   {foreach from=$result.values item=note}{$note.note}{/foreach}
  {/if}

It only returns "None" once, when the contributions all have notes.

How can I make the if statement run for each of the contributions selected for the thank you letter?


texts:
I have an extension that adds a tab to Events.  The form is called up, and works using the automatic layout for the top piece.
 {foreach from=$elementNames item=elementName}

{$form.$elementName.label}

{$form.$elementName.html}

 {/foreach}

Further down I add more to this form:
/script>
{/literal}

id	Event ID	Trial Number	Trial Date	Judge	Started	Advanced	Excellent	Elite Offered	Games

{crmAPI var='result' entity='TrialComponents' action='get' event_id = $event_id}
{foreach from=$result.values item=component}
{$component.id}
{$component.event_id}
{$component.trial_number}
{$component.trial_date}
{$component.judge}
{$component.started_components}
{$component.advanced_components}
{$component.excellent_components}
{$component.elite_offered}
{$component.games_components}
 Edit  Delete

{/foreach}

  Add Component

The idea here is I have a one to multi so this second bit lists out the component section, and I have an Edit and a Delete function associated with each line.  The Delete works fine but its the href that does not.  I have a second form in this extension called EditComponent, which I want to call and put in the popup window that gets produced when you hit the edit or Add Component.  The issue is I'm getting a 404 error and it can't find that form?  What URL should I be using in there to get that other form in the popup?  My extension is called TrialAdmin and the two forms are called TrialDetails and EditComponent, both in the same directory of the extension.  I think I'm just too tired to think this one through -- help?


texts: How to redirect to a static url after member signup

texts: I am working on a wordpress website with civiCRM. Member signup with CiviCRM is working correctly. I need an admin approve the new wordpress users after signup. I used "New User Approve" wordpress plugin for this. When the user make payment and completes the signup the page will redirect to the CiviCRM dashboard by default. But because of I am using the new user approve plugin the newly created wordpress user is not active and so that user can't sign in successfully and can't access the dashboard.  That results in an error message. So I need to show a Thank you page after submitting the registration details. How can I do it?


texts: Can we disable resource-intensive logging queries triggered by inline edit?

texts:
On the contact summary page in CiviCRM 4.6.4 with advanced logging enabled, after doing an inline edit of address or phone, an AJAX query is triggered for a logging report URL:

/civicrm/report/instance/87?reset=1&force=1&section=2&altered_contact_id_op=eq&altered_contact_id_value=59625&cid=59625&qfKey=blah&crmPID=2&snippet=json

Report instance 87 is a reserved instance of Contact Logging Report (Summary) with report_id logging/contact/summary .

This is a problem on a site with a large number of log entries: in this case, 4.8 million in log_civicrm_activity_contact. The logging queries take many minutes to complete. So a simple inline edit triggers heavyweight queries that slow down the database.

I'm guessing this is done in order to update the count on the Change Log tab heading. In Civi 4.4, if advanced logging is enabled then the Change Log tab heading does not show a count. This is preferable. Was the count added as a result of a feature request? Can it be disabled?


texts:
When exporting search results or preparing a New Mailing in Civi Mail, there is an option to merge contacts from the same household/address (export) or remove duplicate emails (CiviMail).

Does a similar merging option exist for a New SMS in CiviSMS?
If not, what is best practice for preventing multiple SMS going to duplicate phone numbers?

Backstory: Our organization has a large number of families, so parents will often register their children with the parent's mobile number.  Thus the high probability of duplicate mobile numbers for mass SMS.


texts: Is Drupal Views affecting CiviCRM performance?

texts:
I have created a Drupal Views block, which aggregates some CiviCRM values. This block I have on most pages.

How (if any) is this affecting the performance of the CiviCRM site?

(How does Drupal Views aggregate its result? SQL query?)


texts: Wordpress Shortcodes for Displaying subsets of events

texts:
I understand there is a shortcode for displaying a list of upcoming events, that is

[civievent_widget]

Is there a way to display categories of events as shown below?

http://www.torontodance.com/events/categories/salsa/

Also are there ways to filter events by location and other filters?   If so, how?

Thank you!


texts: Is it possible to set up to search name of attached document or better yet, contents of attach doc?

texts:
We're still trying to figure out if CiviCRM will work for our organization. Our users would like to have the functionality to search the name of a document that has been attached to a case. Ideally (though I realize it's probably not possible), they would like to be able to search the contents of an attached document.

As an example, a client might call in and request a publication on apple orchards. Say we send them a publication called "apple orchard management 101" and document that in the case and possibly attach a pdf to the case. Going forward they might like to search to find all the cases where that publication was sent to a client. Or they would like to search for all cases where they were sent a publication (pdf) which included the text "organic apple production".

I know I'm reaching here, but would love to know if anyone has accomplished anything like this.

Thanks in advance.


texts: Two domains, one site how to manage civicontribute?

texts: Civicontribute post-transaction response page always reverts to primary domain. How can I force it to stick with the original domain?


texts: Network error unable to reach the server - wordpress

texts:
Recently I got the error "Network error unable to reach the server" in my wordpress website's dashboard while accessing CiviCRM. I have php 7.0 verson.
How can I resolve this issue.


texts: Where is IPN information stored in Civi?

texts:
We are using Civi 4.7.29 on Wordpress 4.9.4

Recently we moved our civi install of the root directory oursite.com to a subdomain subdomain.oursite.com.

While we were on the root directory, we were able to take recurring payments with out any problems.  Suddenly on the subdomain, we are not able to accept recurring transactions anymore through paypal.  It shows the recurring transactions as Pending/Incomplete in civi.

It just occurred to me that the IPN paths might still be hooking to the root directory and need to be changed to the subdomain.

Can someone tell me which folder these IPN hooks are in, so I can review them?

Thank you.


texts: Why don't date selections via the pop-up stick when adding an event?

texts:
On events, manage events, add event, on the start date, even though you select a new date from the pop up calendar, the date doesn't change from the current date. This seems to be the same issue with the End date and sometimes when you select the month, the calendar automatically changes the year to 1995 if you key in the date manually, it works.

I am using CiviCRM version 4.5.5 and i have also tested on the demo site currently running 4.5.9 on firefox 39.0 and chrome Version 44.0.2403.107 m

I can file an issue if any other person can confirm this


texts:
Every time when i try to manage the existing tags  i get into a loading loop without any end! No Tag is listed, no modification is possible)

Installation: wp 5.x multisite but civicrm is active only on first site right now

what i tried:
 - reinstall complete remove and migrate to external database -> no success
 - reinstall -> no success
 - upgrade to version 5.12.beta1 -> no success ..
used IE Edge, IE11, Firefox (current) for testing already

Anyone have any idea ? without tagging this makes no sence for me ..

Harald


texts:
After the update 5.6.1, for a user role with non-admin permission, I noticed a warning concerning Multisite that indicate an Undefined variable :

Notice: Undefined variable: type in multisite_civicrm_selectWhereClause() (line 229 of /var/data/sites/reveal/public_html/sites/default/files/civicrm/ext/org.civicrm.multisite/multisite.php).

This might be linked : any request for let's say the list of contact in a group gives a 500 Internal Server Error. The Recent log messages always indicate the Undefined variable Notice.

As a non admin and to fully benefit of the Multisite setting, the permission for this role doesn't include view and edit all contacts.
How can I dig in this ?


texts: KC Finder - Uploading/browsing the images not working in CiviCRM 5.9.1

texts:
I am using CiviCRM 5.9.1 and Drupal 7.6

I am creating a new event. adding the image to it by using CKEditor. when I tried to browse images/ upload the image. The error is coming.  Please refer to the screenshot for the error.

I followed the previous question regarding this KCFinder. I applied the available patch that is for civi 4.6. That one also didn't work.

I checked file permission and drupal uploading file permission. It is fine.

Please give suggestion how to solve this issue.


texts: Access permission for Print Merge Documents

texts: I have CiviCRM installed on Wordpress. I am trying to limit the Print/Merge Document function shown in the below image, to only certain Wordpress roles. Is there such a setting in CiviCRM for this? If not, how else can we achieve this?


texts: Quick explanation of 'hidden smart groups' and why they're included in my mailing uninvited?

texts:
I haven't been able to find information on these hidden smart groups anywhere using google or this forum. Perhaps because they are hidden on purpose?

I'm wondering what these groups are, and why, when I schedule a mass mailing using civiMail targeting search results rather than a group with an unsubscribe group, the last step says something like:

"Include: Search Results (####)

Include: Hidden Smart Group (84)

Exclude: A group I need to exclude (###)"

Are those 84 people in my initial search? I'm hoping that we are not emailing folks that have not subscribed to this mailing list.

84 does not match the number of people in the unsubscribe group we are using.

Thanks for any explanation available!


texts:
I want to customize the "Edit Contact" form depending on roles.
What's the best way to do it?

create different templates. It's possible to distinguish inside a .tpl the user role?
create a Drupal view
....

Thank's a lot


texts: Show the CiviCRM simple donate form on Drupal static page or node.

texts:
I am using Simple Donate version
 1.2
I am trying to integrate 'simple donate' extension for drupal page and/or block.

I have tried it by initializing civicrm in custom block. CiviCRM is getting initialized properly.

I have jut tried to load /partials/simpledonate.html file using code in following file:
com.webaccessglobal.simpledonate-1.2/js/simpledonate.js

$routeProvider.when('/donation', {
        templateUrl: resourceUrl + '/partials/simpledonate.html',
        controller: 'SimpleDonationCtrl'
      });

if the URL is '/donation' then it will load /partials/simpledonate.html
But it is not working.

Can anyone put the idea i.e. how to load CiviCRM extension in drupal block or page?

Any idea is appreciable..


texts: How to set super-user privileges in CiviCRM for MySQL? CiviCRM requesting for multilanguage support

texts:
I have properly installed CiviCRM 10.0, PHP version 7.2, in Joomla 3.6.5 on Linux shared hosting. Works perfectly!

Now that we have configure the Spanish language in Joomla and in CiviCRM set to "Yes" the inherit CMS language option, at the bottom of the page comes this note:

"In order to use this functionality, the installation's database user must have privileges to create triggers and views (in MySQL 5.0 – and in MySQL 5.1 if binary logging is enabled – this means the SUPER privilege). This install either does not seem to have the required privilege enabled. (Multilingual support currently cannot be enabled on installations with enabled logging.)"

Anyone knows where to check and how to set super-user privileges in CiviCRM for this particular issue?


texts: Unable to run a batch update of contribution soft credits

texts:
I created a profile with only two fields:
Soft Credit
Soft Credit Type
I intend to use it to go back into my contributions and assign soft credits to contributions.
First I go to Contributions -> Find Contributions and execute my search.  I select 'Update Multiple Contributions', and I select my Soft Credit profile.
The relevant contributions are displayed.  But the Soft Credit and Soft Credit Type fields are blocked/blank.  I know some of my contributions already have soft credits assigned but that information doesn't show.  And I am not able to assign new soft credits to any contributions.
I thought this functionality was added in 2013: https://wiki.civicrm.org/confluence/display/CRM/Soft+Credit+Enhancements+-+4.4
I have no trouble updating contributions' Thank You dates with another profile.  What am I missing?  Thanks!


texts: I am unable to search Campaigns in my sent SMS's. It appears that the field for searching archive SMS's via campaign has disappeared


texts: Can a contact be registered for an event through another event

texts:
After some wrangling with ideas on how to make registration easier for participants I've come up against a problem and wonder if CiviCRM can even be used to fix the issue without a tremendous amount of custom coding. I'm looking for ideas on how to overcome the issue.

Brief site description
Our site runs 10 events a year for two groups: Students and Instructors. Members from both groups log in and sign up for events they will attend. Instructors don't pay but Students do. In fact, Students receive a discount if they sign up for more than one event. If they sign up for a single event early, they get a discount but early and 'bulk' discounts are not combined.

Easy Registration
Rather than create 20 events (10 for students, 10 for instructors) I create 2 'super registration' events (one for students, one for instructors) that allows registration to any or all of the events. In the event I have a checkbox list with 5 choices, of which any number of choice can be selected.

Event 1: Apr 29-30 Event 2: June 1-2, Event 3: July 10-11 etc . . .

Pricing is listed as:

ONE Event: $100
TWO Events: $180
THREE Events: $270
 . . . .

Problem 1: I cannot find a method to force the number of event choices to the correct corresponding price. For example, Student picks Event 1 and 3, but then only picks ONE Event for pricing 'accidentally' paying for one, rather than two events. This requires 'administrative intervention' in the form of an email (Dear user so sorry to see you can't count. Pay for the correct number of events or we're only signing you up for the number you paid for). Be great if I could somehow count the number of selected events and force that price.

Is there a way to do this?

Problem 2: While using CiviReports and Excel is fine to manage the two super events I was wonder if I could use CiviCRM to manage all events. I was thinking, create my user accessible 'super event' but also create admin-access only events to track which users are actually going to which event. For example:

Event List
Student Registration event - allow users to sign up for any number of events
Student Event 1 (for admins only) - Track whose coming to event 1
Student Event 2 (for admins only) - Track whose coming to event 2
Student Event 3 (for admins only) - Track whose coming to event 3

dito for instructors

Is there a way to do this?

I've considered the shopping cart but it still forces users to pick each event, put it in a cart, pay and the bulk pricing becomes tricky as the percentage of discount changes depending on number of events picked. The shopping cart is still a bit creaky too. The 'super event' is pretty popular with users so I'd like to keep it.


texts:
I have a complex Event registration process, for which I create a complex Webform (I use Webform Integration).

This event recurs several times a year, and the webform is painful to re-create each time.

Is there any way to either clone an existing webform (then adapt), or create a Event Webform template from which I could then derive individual Event Webform occurrences ?


texts: How do I suppress the "are you sure you want to leave this page" popup from contribution page

texts:
Where could I suppress the "are you sure you want to leave this page" popup when leaving a contribution page (e.g. donation) without actually proceeding with the contribution.
I realize it may be there to prevent leaving the page accidentally mid-way through filling out the form but I actually think it's more annoying than helpful in the fraction of accidental cases.
Also, I have a Facebook login on the page, which, when utilized, forces the page to reload and thus invokes the 'leave this page' popup. This is confusing to the user who wouldn't know they need to hit the "leave this page" button in order to get logged in (not to mention they'll actually stay on the page, hence the confusion).

This is on Joomla (3.4.4 w/ CiviCRM 4.6.9)

I'm assuming there's an onbeforeunload function - one appears in /administrator/components/com_civicrm/civicrm/js/Common.js

The warning appears even when the user has not made any entries on the form. Shouldn't the warning only pop up when they do?

Thank you for any pointers.


texts: Upgrade from 4.6.3 to 4.6.4 not completed

texts:
I tried to upgrade version 4.6.3 (Drupal 7.37, dutch) to version 4.6.4.
After upgrading the database, [Executed: Upgrade DB to 4.6.4]
 the process seemed to stop on 2/3 of the bar.
After 10 minutes I tried to use CiviCRM and it worked showing version 4.6.4.

There are no errors in the logfile server or on screen, in civicrm.log the normal logging [Executed: Upgrade DB to 4.6.4] and [upgrade:4.6.4.upgrade->4.6.4]

Maybe the problem was that I first tried the upgrade without being signed in on Drupal. After the error I started the upgrade again and it did not completed, but CiviCRM works.

Will this cause problems going forward or am I okay?


texts: How to put 'Other Amount' field in price set radio choices?

texts:
We want our Civicontribute page to do this, but don't want to use the Simple Donate extension. Is there any way to natively support this in CiviCRM? FYI - the 'Other' field is hidden until you select the option.

Is this another case where Webform CiviCRM comes to the rescue? :)

Even better than what is pictured below would be an 'Other' field that when selected, let you type the amount directly in that box.

Drupal 7 / CiviCRM 4.7


texts: How can I provide mailing receipients an "Unsubscribe All" option?

texts: When recipients click "Unsubscribe" in my mailings, it takes them to a page where they can unsubscribe from every group the mailing was sent to. Is there a way to let them opt-out of one and not the other, and also is there a way to let them opt-out of all future mailings? Sorry if this is listed somewhere. I've searched and looked in the docs but haven't come across this.


texts: What is the correct way to import fields with line breaks?

texts: I've noticed that CSV files containing "\n" will import these characters literally. That makes sense for single-line text, but what is the correct way to handle for note fields?


texts: I created an event for my organization that occurred on July 21st. When I go to "Manage Events", it is not shown in the event list. However, when I search for the event by time period, it once again appears. Why can't I see the event all of the time?


texts: Get a 403 error when adding an image to the online registration page in event management

texts:
Using CiviCRM 4.6.6. on Drupal 7.56

Just moved this site to a new server following normal procedures.

When managing an event, I can add an image to the info and settings page, but when I try to add one to the Online Registration page, the registration page is returned incorrectly and I get a 403 error. The event ID is completely lost. This is intermittent. Sometimes the page saves the image.

Trying again on 4.7.22. Endless spinning triangle of death.

Any ideas? Thanks


texts: Logging enabled and multilingual functionality?

texts:
After Missing view when logging set in a non-US English instance.
, I wonder if anyone has investigated the effects of turning a site from multilingual to monolingual or vice-versa whilst logging was enabled?  I have been working on a patch to solve the issue, and found some 'interesting' effects.


texts: What is 'advanced report configuration' and when will it work?

texts: I was updating a report when I noticed a link to 'advanced report configuration' (this was on release 5.13.5).  Following that link I got a screen similar to the contact layout editor - but I couldn't make anything work.  After an upgrade to 5.17.4 this link has disappeared.  It looked very useful & interesting, allowing columns to have the title changed plus other stuff.  I guess I stumbled on something that's not ready yet - or is this an extension I've missed?  If not - any ideas when this will be implemented?


texts: Should I use CiviCRM 4.x or 5.x is this like D7 and D8?

texts:
I want to use the most stable version with the most extensions as possible, with Drupal, 7 is still better than 8 for most projects.

Is it the same with civi?

I already installed and configured 5.x can I downgrade to 4.x ?


texts: How to display sort name with prefix/suffix in webform select list

texts: When we create a webform for users to select contacts from a list whether we select to display display name or sort name it does not include suffixes. All of our contacts are families, many of which have suffixes (Sr, Jr, etc.) which makes it very hard to discern which contact is the right contact.We have set the webform up to display the contact's full name including prefix/suffix once they select them from the list and it works ok, but it is not the slickest solution.Is there a method to either alter what Civi includes as the sort name or display name or to alter the webform select list to include the prefix or suffix?


texts: Login Failed with eWAY Recurring Payment Processor

texts:
I have installed the eWay Recurring Payment Processor (version 1.2) in my site and it processes one-off payments fine. However when I processes a recurring payment I get the following error: "9010: Failed to create managed customer - result (faultcode, faultstring) is (soap:Client, Login failed. )".

When I contacted eWay regarding this error they gave the response that I was sending the request to an incorrect URL (https://www.eway.com.au/gateway/managedpayment/CreateCustomer).  Is anyone else getting this error? If this extension is out of date is there a new one?


texts: Hosting CiviCRM and Wordpress on WPengine

texts:
I'm just starting a new implementation project with a client who uses WordPress and hosts currently with WPengine.com
A quick search threw up some interesting comments here from @andrew-hunt that don't bode well.

Does anyone have direct experience (good or bad) of running CiviCRM 4.6.x on WPengine's platform? Should I be advising my client that we need to find an alternative hosting provider?


texts: Problem of integration of the civicrm online grant page with my wordpress site

texts: I'm using Civicrm version 5.13.4 and wordpress version 5.2.2 and I'm having problems integrating my grant page on my wordpress website. I have already changed several themes and all of them do not recognize the civicrm shortcode for the grant page only. Please, if someone can support me it will give me a lot of pleasure. Thank you


texts: What happended to the ability to expand parent groups in the Manage Groups page?

texts:
The Manage Groups page used to show a little icon you could click in order to see the child groups of a parent group. Now, under 4.7.6 there are no icons. This means you can't see or manage the child groups. This is a major issue for us.
Any suggestions for how to fix this. Is it a bug?


texts: Adding Field to Advanced Search CIviCRM Contribution

texts:
I'm trying to add Notes field to the advanced Contribution search so that I can do wildcard search on the basis of notes but the DAO throwing error: "unknown column", as it's not able to locate civicrm_note table.

Here's my extension file

function MyExtension_civicrm_buildForm($formName, &$form) {
    if ($formName == 'CRM_Contribute_Form_Search' || $formName == 'CRM_Contact_Form_Search_Advanced') {
        $form->add('textarea',
          'contribution_note',
          ts('Note'),
          ['rows' => 4, 'cols' => 40],
          FALSE,
          array('class' => 'crm-form-textarea')
        );
    }
}

Custom template file

    {$form.contribution_note.label}

    {$form.contribution_note.html}

After debugging I found the query is not making a join to civicrm_note table. Here is the query I got on debugging.

SELECT civicrm_contribution.id, contact_a.id as contact_id, contact_a.contact_type as `contact_type`, contact_a.contact_sub_type as `contact_sub_type`, contact_a.sort_name as `sort_name`, civicrm_contribution.id as contribution_id, civicrm_contribution_recur.id as contribution_recur_id, civicrm_contribution.contribution_status_id as `contribution_status_id`, civicrm_contribution.campaign_id as `contribution_campaign_id`, civicrm_contribution.receive_date as `receive_date`, civicrm_contribution.total_amount as `total_amount`, civicrm_contribution.currency as `currency`, civicrm_contribution.thankyou_date as `thankyou_date`, civicrm_contribution.source as `contribution_source`, civicrm_contribution.is_test as `is_test`, civicrm_contribution.is_pay_later as `is_pay_later`, civicrm_product_en_CA.id as product_id, civicrm_product_en_CA.name as `product_name`, civicrm_product_en_CA.id as `contribution_product_id`, civicrm_contribution.financial_type_id as `financial_type_id` FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id LEFT JOIN civicrm_contribution_recur ON civicrm_contribution.contribution_recur_id = civicrm_contribution_recur.id LEFT JOIN civicrm_contribution_product ON civicrm_contribution_product.contribution_id = civicrm_contribution.id LEFT JOIN civicrm_product_en_CA ON civicrm_contribution_product.product_id =civicrm_product_en_CA.id WHERE ( civicrm_note.note = 'check' AND civicrm_contribution.id != 0 ) AND (contact_a.is_deleted = 0) GROUP BY civicrm_contribution.id ORDER BY `receive_date` desc, `contact_a`.`id` LIMIT 0, 50;

Do I require to use QueryObject hook to override the BAO ?

Also, if I use "note" as the field name instead of "contribution_note", it's doing the lookup for notes associated with the contact rather than contribution notes.


texts:
We've got some CiviCRM status messages displayed outside of CiviCRM (Drupal pages), but they come as a default browser JS alerts, not as a fancy CiviCRM-styled status messages. We've    $manager->addCoreResources(); included via  hook_page_build(&$page); guess it's not enough though.

There is a documentation at https://wiki.civicrm.org/confluence/display/CRMDOC/Resource+Reference    which says:

If you are working outside of CiviCRM core or extensions (such as a Wordpress plugin), you can still use the Resource Manager but will need to construct the urls yourself

with addScriptFile, addScriptUrl, addStyleFile and addStyleUrl methods available; the question is, which exactly CSS files contains fancy pop-ups formatting?

Also, it's a bit unclear, how exactly css should be loaded? Normally, it should use addStyleFile / addStyleUrl, but an example given at documentation page states:
CRM_Core_Resources::singleton()->addScriptUrl('http://example.com/bar.css' (mean, use addScript to load CSS Style file) which is a bit confusing..

Thanks for any hint!


texts: Can't find Click the Continue button to proceed with the payment in translation string

texts:
I can't find Click the Continue button to proceed with the payment. from a Contribute form in the translation strings even if I can find other strings from that Contribute form. It's untranslated in my language and I'd like to fix it. The string changer does nothing.
Any ideas?


texts: Is it possible to set a specific order for all contact reports?  Can they be grouped underneath certain headings making them easier to find?  If so, how can I do this?


texts: Is it possible to import "Assigned to" data for Activities?

texts:
In the "Import Activities" interface in CiviCRM (version 4.6.3, drupal 7), there are many options for fields to import.  One critical field that appears to be missing is the "Assigned to" field (sometimes referred to as the "assignee").  I'd like to know if it's possible to import this field when importing activities.

This matter was discussed 2 years ago, in this forum thread:

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

  Definition of "Assigned to" from the user guide: "The person (usually within your organisation) that will carry out (or has carried out) the activity."

I'm wondering if any progress has been made on this since that forum thread.


texts: Is civicrm-buildkit safe to use in production?

texts:
Background: I am recreating our CiviCRM installation on top of Drupal inside a Docker container. After a significant amount of research, I have decided to incorporate the best parts of civicrm-docker and the official Drupal Docker container. However, before I progress too far down this road, some questions came up.

Q1: Is it sensical to run a production site that has been built using civicrm-buildkit?

Q2: What is the update procedure for a civicrm-buildkit build?

Q3: Should Drush be used instead of civicrm-buildkit?

Q4: (open ended) Does anyone have experience they would like to share?

I will keep an eye on this thread, but if anyone would like to chat realtime, I can also be found in IRC.

Thanks!


texts: Mosaico 2.0, Drupal 7.64 - "Sorry an error occurred and your information was not saved"

texts:
Installed Mosaico 2.0-beta4 on Drupal 7.64 and CiviCRM 5.7.2. I followed all installation instructions and installed Shoreditch then Flexmailer then Mosaico.

I'm getting an error - when I try and edit a Mosaico template and drag a block in, it gives the error message of "Sorry an error occurred and your information was not saved".

This happens whether I upload an image into a block, or just drag an empty text box and add dummy text, or anything in between.

This also happens regardless of which base template I'm trying to edit.

If I just try and create a new mail using the base templates, I can't preview the email as HTML or send out a test email (again, regardless of how much or how little I customise the base template) and get the same error message.

I've checked error logs and haven't found anything. All modules and core up to date, any ideas on what I can do to fix this?

Thanks

EDIT: Some of the messages from Browser console. Not sure which of them are relevant:

The resource from “[default]/civicrm/css/?r=f1Bvs” was blocked due to MIME type mismatch (X-Content-Type-Options: nosniff).

.

Error while detaching the browsing context target front: Connection closed, pending request to server1.conn0.parentProcessTarget1, type detach failed

^ That one then has a "Request Stack" of around 20 lines.

Content Security Policy: The page’s settings blocked the loading of a resource at https://raw.githubusercontent.com/favicon.ico (“default-src”).

.

Loading mixed (insecure) display content “http://mosaico.io/srv/f-default/img?method=placeholder&params=166%2C160” on a secure page[Learn More] jquery.min.js:4:19318

unreachable code after return statement

EDIT:

Checked the error log in cpanel, this is an error message we're getting at the same time:

2019-02-27 12:11:55.672900 [INFO] [203.166.241.141:58741-Q:2699717862144599633-5] File not found [/(homedirectory)/public_html/403.shtml]


texts: Issue with Drupal 8 CiviCRM Views + CiviCRM event

texts:
Does anyone know how to create a Drupal view to show only future/upcoming CiviCRM events in Drupal 8?
I tried by adding the Event start date as filter but it doesn't provide the filtering options to set the date or choose an offset like it did in D7.


texts: Recurring payments URL for Vanco payment processor

texts: Could someone provide an explanation (with an example) for the recurring payments URL field found on the Add Payment Processor form when using Vanco Payment Processor? It is my understanding it is used for processing the Instant Payment Notification (IPN), a message service that notifies you of events related to your payment transactions.


texts:
Wordpress 4.5.2
CiviCRM 4.7.7
PHP 5.5.34

The installation goes smoothly and the database is created but I cannot continue with the configuration. I get this screen:

CiviCRM Home
Configure Your Dashboard Refresh Dashboard Data
Welcome to your Home Dashboard
Your dashboard provides a one-screen view of the data that's most important to you. Graphical or tabular data is pulled from the reports you select, and is displayed in 'dashlets' (sections of the dashboard).
Access Keys:
Powered by CiviCRM 4.7.7. System Status: Error CiviCRM is openly available under the GNU AGPL License.
Download CiviCRM.     View issues and report bugs.     Online documentation.
It says System Status: Error but where to look for errors?


texts: 404 Error: Not found while Importing Contacts

texts: I'm migrating from one host service to another. We've installed the newest version of CiviCRM on the new host, DreamHost. I'm exporting contacts from the old CiviCRM database and importing them into the new CiviCRM database. It worked fine for 154 records and 233 records, but I'm getting a 404 Error when importing 713 records. DreamHost tried to increase the PHP limits, but it didn't help. I could try breaking the imports into smaller chunks, but I've got 11,000 records! I found a similar problem in the StackExchange, https://forum.civicrm.org/index.php?topic=29865.msg127907#msg127907 but it went unanswered. Can someone help me? Thanks, in advance! Jim


texts:
I saw a few with similar questions, but not exactly the same on a major point. If moderators see value in merging this, go for it.

We have a problem where people sign up for an event which includes Current Employer on the profile. When that gets saved to their contact, it often maps to the wrong organization - one that starts the same. Even if we type out the full name of the organization exactly right, it will pair it with another organization instead. It seems like it is only able to store the first 10-20 characters and then matching to the first organization it finds starting with those characters. This happens a lot when you're dealing with a lot of organizations named starting with the city/region.

This is on Version 4.6.31 with Drupal but the client has said this has been an issue for about a year, so it's not a new version bug.

Any better ways around this than creating another custom field which they would need to manually copy into the auto-select Employer field from the back end?


texts: Mass Deleting Scheduled and Sent Mailings, Drafts, etc

texts: DB has grown so huge and it started to cause problems with sending mass mailings. I want to delete old mass mailings, the sent ones and the drafts, etc. Is there away to do it in one click instead of deleting each and everyone individually?


texts: membership recurring payments using Drupal webform

texts:
I have a webform in Drupal 7 that is using CiviCRM integration to allow users to purchase memberships. I'm having a little bit of trouble figuring out what the correct setting should be, and not finding documentation that helps. Here is what I would like to happen:

In the webform, a user selects from multiple membership options.
They may also select to buy a non-membership item.
Either on this page or the confirmation page, I'd like to collect payment information and allow users to opt-in for recurring payments.

Right now, I know how to create a membership page that includes payments, and I can see how to allow membership registration on the webform, but I haven't figured out how to get payment integrated into the user flow. Have any ideas for me, or links to documentation?


texts: Update Multiple Activities - Cannot Display "Details" Field

texts:
I'd like to be able to update multiple Activities easily. I've prepared a Profile and have activated these fields:

Activity Date
Time
Activity Status
Subject
Details
Duration

All works as expected, except for the Details field which contains the Copy icon at the top of the column, but does not display the fields for each row. Instead the column is blank.

Thinking this may be an issue since Details is a text field, I added a Custom text field called Scratchpad. When added to the profile, this custom field displays as expected.

Any ideas as to why the Details field won't play along correctly?

Thanks.

We're using WordPress 4.7.3 and CiviCRM 4.7.17.


texts: Could an extension add fields to the standard Find Contributions form?

texts:
A client would like to search for contributions by payment processor. The built-in search forms don't include a payment processor field, although the data exists within the Civi database.

As the answer to another question describes, I could create a custom search based on the basic Find Contributions form. I could then replace the default Find Contributions menu item with my new improved version.

But, hypothetically, could I instead use an extension to insert a field for payment processor into the basic Find Contributions form itself, along with some code to create the SQL query? Is such an approach possible and advisable?


texts: Mailchimp extension limits to most recent 25 lists

texts: We have a Civi user connected to Mailchimp who has quite a few lists - from our testing (Mailchimp v 1.6, Civi v 4.4.6) the extension appears only to access the 25 most recent lists in Mailchimp.  How can this limitation be increased?


texts: Capture country field selection with JS/jQuery

texts:
I have developed a site for a client that uses a profile to capture address and contact information for event registrations using CiviEvent. One of the fields on the registration form is a 'Country' field. There is a requirement from the client to fill in another form field with a default value based upon the Country selected. I have done similar things with jQuery in relation to other fields on the form, but the country field widget is quite complicated and I can't quite figure out how to target the user's selecting a country and get the country value with jQuery. I am sure there must be some code in CiviCRM that does this, in order to display the correct set of state/province fields based upon the country selection. But I have not been able to locate such code. Can anyone give me any pointers in terms of where I can find the CiviCRM code that does this, or sample JS/jQuery code that will detect the country field selection on a profile form? Note that this is on CiviCRM 4.6.2.

Many thanks,
-Ian


texts: DB Error: connect failed when trying to call Job.execute using cli.php?

texts:
I've set up a new CiviCRM install on a new Drupal install and I'm trying to configure Cron using the instructions at https://docs.civicrm.org/sysadmin/en/latest/setup/jobs/.

I'm a complete newbie at both CiviCRM and Drupal, and both the cv and Drush methods look like they need extra tools installed, so I've gone with the cli.php method.

I'm logged in to my host using SSH and using the command from the manual (obviously completed with the paths, domain, and credentials for my site):

$ /path/to/php /path/to/civcrm/bin/cli.php \
  -s example.org \
  -u myusername \
  -p mypassword \
  -e Job \
  -a execute

That returns a bunch of HTML, obviously designed to be shown in a browser not a terminal, in which the only recognisable error message is 'DB Error: connect failed'.

Can anyone tell me what I'm doing wrong?

Edit: OK, so I've tested getting the password wrong and that gets the same error, so I guess it's possible that I have a credentials problem of some kind. But I'm using the username and password of a Drupal administrator user that works just fine logging into the CMS via a browser.

The only other thing I can think is that I think my file installation and my database are on different servers. But I filled in all those details when installing Drupal/CiviCRM and I don't see any errors in the GUI. Do I need to manually edit a script somewhere?

Further Edit: Still without joy, I gave up on the cli.php method and tried the HTTP method documented on the same page above. Trying to open the following URL in a browser results in exactly the same error, though obviously presented properly instead of raw HTML.

http://<siteurl>/sites/all/modules/civicrm/bin/cron.php?name=<username>&pass=<password>&key=<sitekey>

Can that narrow down the source of the problem at all?

Yet Further Edit: Looking in the logs I see the following:

[code] => -24
[message] => DB Error: connect failed
[mode] => 16
[debug_info] =>  [nativecode=Access denied for user '<drupal_database_user>'@'<database_ip>' (using password: YES)]
[type] => DB_Error
[user_info] =>  [nativecode=Access denied for user '<drupal_database_user>'@'<database_ip>' (using password: YES)]
[to_string] => [db_error: message="DB Error: connect failed" code=-24 mode=callback callback=CRM_Core_Error::handle prefix="" info=" [nativecode=Access denied for user '<drupal_database_user>'@'<database_ip>' (using password: YES)]"]

I was surprised to see that it seems to be trying to connect with the user I had set up for the Drupal database, rather than the user for the CiviCRM database. That user originally only had Select access to the CiviCRM database. I've now given both users full access to both databases (which instinctively feels like a non-ideal setup?), but I'm still getting the same error.


texts: what kind of sanitization needs to be done when doing civicrm_api3('Contact', 'create') inside custom drupal modules?

texts:
How does creating contacts via civicrm_api3() fit into these areas https://docs.civicrm.org/dev/en/latest/security/#strategy
https://docs.civicrm.org/dev/en/latest/security/inputs
?

If I'm using this inside custom drupal modules, is it safe to simply:

function mycustom_webform_submission_insert($node, $submission) {
  if ($node->nid == 123) {
    civicrm_api3('Contact', 'create', array(
      'sequential' => 1,
      'contact_type' => 'Organization',
      'contact_sub_type' => 'Sub Type Name',
      'organization_name' => $submission->data[48][0],
      // I've done nothing to that $submission data, it's only been processed by whatever Drupal/Webform module do.
      // Is that a security risk?
    ));
  }
}


texts: I am testing the CiviVolunteer extension and was wondering if there is anyway to identify that a contact signed up to volunteer based on their profile? I assigned a few volunteers to an event, but I do not see that they signed up anywhere on their profile. I don't even see the event show up on their event tab. Let me know if I am missing anything or if this is a future enhancement. Thank you!


texts: 'View in browser' link on mailing gives 'Access denied' error

texts:
If I click on the 'view in browser' link on a mailing sent via CiviMail I get to a page on the website that says 'Access denied'.

Why is this not working?


texts: Which contacts in Civi are wordPress user as well?

texts: I have 500 contacts on my CiviCRM groups and also I have 250 users for my WordPress, I am wondering to know is any way to find which one of my civiContacts are in WordPress?


texts: Why can't certain Civimail Mailings be reused?

texts: About half of the mailings we send are missing the "reuse" option in the action links on the "Scheduled and Sent Mailings" screen. Is this because they are sent to a search results rather than to a mailing group?


texts: CiviEvent custom data missing on confirmation page

texts:
I am testing out some custom data on CiviEvent under wordpress; on both the civicrm demo site and a live production site.  In both cases if you add a custom field with a checkbox to the profile for online registrations, for participant, the confirmation page confuses the data coming back.  I created a check box with 3 options (good, bad, ugly).  If I choose 2 of them (bad, ugly) then on the confirmation page I see the data as ", good,good".  If I choose the checkbox as (good) then I get "good, ,".  And if I select the checkboxes as (good, bad) then I get "good, good, ".  I each case I get the wrong set.

It seems to always use the first option no matter what I choose but it does return it in the correct index. Anyone have any suggestions to make this work?  Or has anyone looked into the issue already and solved it?


texts: Unknown scheduled job creating duplicate contacts

texts:
So I have a mystery. Every day at 17:40+-2 minutes, the system creates a number of duplicate contacts.

These contacts largely have the same set of names:

Other things of note:
1. All of these contacts show as being created by themselves.
2. There are no scheduled jobs for that time that I can tell

Anybody got an idea?


texts: Invalid argument supplied for foreach in Report.php on line 264

texts:
I'm setting up some scheduled jobs to email csv reports on a regular basis. I set up the job in scheduled jobs and whether I select "execute now" or run it through a cron job, I get this error:
Warning: Invalid argument supplied for foreach() in //www/www/wp-content/plugins/civicrm/civicrm/CRM/Report/Utils/Report.php on line 264

I can go into Report.php and add a code check if the arguments sent to "foreach" are arrays (i.e. (is_array($rows)) ), and then it runs without any warning. But, I don't want to be administering a system that I have to go in and modify Report.php. I don't see anyone else with this error. Any ideas why I'd be getting it?


texts:
When logging volunteer hours for events and selecting "no-show" in the status it asks me to put the "Actual Duration". Value '0' or '-' doesnt work.
Any idea how to fix this problem?

Thanks,

Alek


texts: How do I create a fee for a team event without each team member being charged? ie one team costs $100 not $100 per person.


texts:
When I go to the Admin > Extensions > Add New, I get the following error...

"Directory Unwritable Your extensions directory is not set or is not writable. Click here to set the extensions directory."

When click on the link, it takes me to the Settings - Upload Directories page, but it is totally blank.

Any clues please?


texts:
I'm trying to make a permission, to limit view some activities types
(A user with a specific role can't view a some activities types)

I was checking the hook permissions but i don't find the way(version civicrm 4.4).

Any idea to focus this issue?


texts: CiviCRM Message Templates link changed, cannot find

texts: We recently upgraded to 4.6.3, and the page message templates live at seems to have changed: the link in our menu bar (https://secularstudents.org/civicrm/admin/messageTemplates?reset=1) is returning a page not found error. All of our message templates still exist. Any suggestions on where to find them so I can change the navigation link to work properly?


texts: Net amount not calculating for event registration

texts:
Civicrm 5.7.0/Wordpress 4.9.8:

When I manually enter an event registration that needs a payment processor fee, prior to civicrm upgrade to 5.7.0 from 4.7.19, there was an area at the bottom of the form called "Additional Details". In that section I could enter the processor fee amount and the net amount would be automatically calculated. In 5.7.0 that section is now gone. After I complete the registration I can go to the contact's profile and edit the corresponding Contribution where the Additional Details still exist although the net amount field beneath the fee is missing (Perhaps because of the changes listed at  https://civicrm.org/blog/dev-team/civicrm-56-release). When I enter the processor fee amount the net amount is not calculated in reports. Event registration reports will show registration fee, processor fee amount, and net amount but the net is not gross (reg fee) minus processor fee. It replicates the gross amount.

This does not happen when entering a contribution only, just when registering for an event. I have on rare occasions seen this happen on previous version when someone has used our online registration page but maybe only three or four times out of 100 registrants. I would then have to delete the transaction and rebuild it manually in order to get the processor fee to show up and calculate the net. Under the circumstances listed above that will no longer be possible.

Has anyone else experienced this and have a fix?
I have tried turning off custom fields and activated past events all with the same results. Also, NO event reports show the correct calculation as described above.


texts: Webform Contributions Error Since Last Update

texts:
Running Civi 5.28.0, I have recently upgraded Stripe Extension :

STRIPE PAYMENT PROCESSOR to 6.5.1
MJWSHARED to 0.9.4

Since then, payments via webforms fail in unexpected Error.
How can I retreive a working configuration ?


texts: Can I track single emails with CiviCampaign?

texts:
I understand that I can associate mass mailings with campaigns through CiviCampaign. However, it seems that I cannot associate a single contact interaction via email to a campaign. Is that correct?

Scenario: Our NGO regularly has to stay in contact with individuals, e.g. journalists, to promote our individual projects for time periods of usually 6 months. Therefore, we separate these into Campaigns. But as it looks, I cannot associate an individual contact interaction with such an individual campaign/project, right?

Thanks for your help,
Bijan


texts: After update CiviCRM Birthday reports stopped working

texts:
Before reports came every day with a list of people who have a birthday today, we updated CiviCRM to version 5.35.1 and reports stopped coming, even in CiviCRM it does not give a list with birthdays, its just empty.
Thank you!


texts: Which Backdrop themes allow viewing CiviCRM inline fields without scrolling?

texts:
By default, CiviCRM on Drupal's "Bartik" theme and Backdrop's "Basis" and "Seven" themes cause CiviCRM inline fields to display with horizontal scroll bars, which hurts usability (see screenshot 1).

In Drupal, the civi_bartik theme fixes this (see screenshot 2).  Is there an equivalent theme for Backdrop CMS?


texts: How to display only Time value in User Contact without the Current Date value

texts:
I have created a custom field selecting date type,selecting the date format and time.Actually I will need only Time field but the system doesn't alow to create
custom field of type date, without selecting a date format and later in webforms I selected Time widget. In webform it is displayed as time field only
But after  the user submits the webform, In civicrm contact current date is also displayed with the time(screenshot)and How to get only the Time value in civicrm?I need this field for time of birth of the user.

Any help?


texts: Why does the Constituent Summary & Detail reports contain deleted contacts? (or, how to remove them?)

texts: The constituent summary & constituent detail reports both contain deleted contacts - this is 4.7.21 (and 4.7.23) under Drupal.  I verified the problem on this demo site.  This doesn't seem right to me - is this a bug or WAD? Either way, any advice on how to remove them from these reports? If a bug I will report it, of course, but I wonder whether I'm missing something obvious here!


texts: MyISAM vs InnoDB - WordPress Installation

texts:
We're running CiviCRM 4.6.8 on WordPress 4.3.1.

I've been getting the following error message since the last CiviCRM upgrade:

  Warning Your database is configured to use the MyISAM database engine.
  CiviCRM requires InnoDB. You will need to convert any MyISAM tables in
  your database to InnoDB. Using MyISAM tables will result in data
  integrity issues.

The site is on a shared server, so I can't change the storage engine unless we move the website to a VPS package.

Does it matter? Should we fork out the $ for a VPS? Migrate elsewhere?


texts: Finding memberships with 'Status Override' set

texts:
I was asked recently if there was a way to find all members who have the 'Status Override' setting turned on. I didn't see an option in the advanced search or member search:

As an alternative, I made a smart group that finds all Primary Members that have a Membership Status of "Current" and a membership End Date in the past (e.g. "Prior to previous day"). This should find all memberships that are hard-coded as "Current" although they are technically expired (right?) but is not actually finding all overridden memberships.

Is there a way to search on whether the membership status is overridden, regardless of what the status is?


texts: Using API csv Import GU"I extension for Pledges

texts:
I have a number of Pledges that need to be loaded and was hoping the the extension would allow me to create a csv file and import the pledges in bulk. A separate line was created for each 'payment' of the pledge, the Contact ID was used as the key and a sequential number was allocated as the Pledge ID. The extension appeared to work as the returned message indicated that all records had been successfully imported.
However, when I view the Contact record, or search pledges, none of the records loaded are visible.
What am I doing wrong? Many thanks for any assistance!


texts: Custom Fields are no longer appearing on profiles after update to 5.25.0

texts:
I have just updated my Joomla 3.19.8 site from version 5.18.12 to version 5.25.0, and my profile views are no longer including any custom fields.

No custom fields appear:
 - on any profiles displayed on the front end site
 - in the "Preview (all fields)" display in the backend Custom Profile
 - in the "Use create mode" display in the backend Custom Profile
These profile views all load, but only default fields are displayed.

What I've Checked:

All custom fields show appropriately on their contact editing views inside Civi, and I can edit them no problem.

Under Custom Data all the field sets are visible, and all are set to "active" and "public".

Under Custom Profiles show all the custom fields are still in place for each profile, and all are set to "Expose publicly and for listings".

The ACL permission "Allow access to custom data" is set to "Allowed" for all user groups.

Any idea what update could suddenly cut off my profiles' access to the custom field sets?  Or is there something else I haven't checked?


texts: How does the /civicrm/CRM/Mailing/xml/Menu/Mailing.xml file work?

texts:
The file defines paths and callbacks, e.g.:

<item>
    <path>civicrm/mailing/optout</path>
    <title>Opt-out</title>
    <page_callback>CRM_Mailing_Form_Optout</page_callback>
    <access_arguments>access CiviMail subscribe/unsubscribe pages</access_arguments>
    <is_public>true</is_public>
    <weight>650</weight>
  </item>

However, changing values in the file doesn't seem to produce any result. I changed the page callback above to CRM_Mailing_Page_Optout but the content served was again coming from CRM_Mailing_Form_Optout.

So how can I make any changes to the callbacks?


texts: how to remove blank rows in constituent summary report?

texts:
Civi 5.15.1, Wordpress 5.2.3

When I run a Constituent Summary report having selected the default columns (none) and default filter (deceased=No), I get a page and a half of squished, blank rows at the beginning. Some filters remove them, other filters don't. Not sure what other info may be relevant. Does anyone know the cause and solution, or could advise how to troubleshoot? I'd prefer not to have to figure out a workaround using the Search functionality. Thanks!


texts:
I'm advising a small NGO and trying to figure out what is the best solution for them. Their data is essentially:

client data: phone numbers, identification numbers, gender, etc.
client-wise logs, e.g.: "January 1, 1970, 12:00 - contacted client foo and spoke with them on the phone regarding xyz. January 2, 1970, 13:00 - client foo contacted us and asked a question"
appointment data: so-and-so has an appointment with this translator in that room at such-and-such a datetime.

Though I could maintain a custom piece of software myself, I think it's better if as much control as possible is put in the hands of the non-coders (not yet!) who are running the organization. In this situation, reinventing the wheel is probably not the right choice which is why I am considering CiviCRM.

There is discussion of using Salesforce because it is established and familiar. My intuition is to avoid the bloated and expensive Salesforce software, even if they have some sort of discount license.

I'm sure that comparisons have been made to Salesforce before but it might be useful to compile some of them in a single place.


texts: CiviRules Multiple rules per trigger - What happens?

texts: When using CiviRules, what happens if two rules match a single trigger?  Rule one says "if group X is added, filter matches X location, then send e-mail X."  Rule two says "if group X is added, filter matches Y location, then send e-mail Y."  Do both rules trigger?  Does it dump after triggering the first applicable reached rule, even if the filter doesn't match?


texts:
I upgraded our test site to Civi 4.6.9 on WP 4.3.1 and all is ok.  I upgraded Civi on our live site and the upgrade was successful.  However, when I go into the Civi Menus sometimes I get "This webpage has a redirect loop   ERR_TOO_MANY_REDIRECTS".  On the Administer menu I always get this error.
What can I do to fix this problem?   (ps. deleting cookies, etc. didn't help)


texts: Soft credits created via API/hook_civicrm_post are automatically deleted in Civi 4.6

texts:
I have a custom extension "Automatic Soft Credit", which replicates a function from Raiser's Edge - if contact A has the relationship "Automatically Soft Credits" to contact B, then any contributions for contact A will automatically be soft credited to contact B.

In Civi 4.4, this function worked fine.  In Civi 4.6, the soft credit is successfully created - and then immediately deleted!  The $result below returns success, but the soft credit isn't in the database - but the auto-increment happens, so it seems to be created then deleted.

After some experimentation, I found that if I try creating a soft credit to a DIFFERENT contribution, it works.  Confusing!

What could be happening after hook_civicrm_post that would cause a soft credit attached to the contribution to be deleted?

function automaticsoftcredit_civicrm_post( $op, $objectName, $objectId, &$objectRef ) {
  if($op == 'create' && $objectName == 'Contribution'){
    $cid = $objectRef->contact_id;

    //Look up whether this person has a relationship_type_id that's automatically soft credited
    $params = array(
     'version' => 3,
      'sequential' => 1,
      'contact_id_a' => $cid,
      'relationship_type_id' => 11, //FIXME: This relationship_type_id is currently hardcoded, we should load it from settings
    );
    $result = civicrm_api('Relationship', 'get', $params);
    //if we have the auto soft credit relationship for one or more contacts, create a soft credit for each
    if($result['count'] > 0) {
      unset($params);
      foreach ($result['values'] as $relationship) {
        $params = array(
          'sequential' => 1,
          'contribution_id' => $objectId,
          'contact_id' => $relationship['contact_id_b'],
          'amount' => $objectRef->total_amount,
        );
        $result = civicrm_api3('ContributionSoft', 'create', $params);
CRM_Core_Error::debug_var('result', $result);

      }
    }

  }


texts: Is there a Civicrm hook for new contact/user insert?

texts:
I want to create new users in Drupal 7 whenever there is a new contact created from the civicrm.

Also, how can I use the civicrm primary email address as a username in the Drupal 7?

Please suggest


texts: Using HTML snippets for Forms no longer an option?

texts:
For a long time I was using a CiviCRM form for signing up people to our mailing lists, and doing it using html for the form on a non-CiviCRM page.

I have a memory that there used to be an option in the CiviCRM Profile Settings page to export a html snippet you could cut and paste in this manner. This no longer seems to be there.

The problem is that it has stopped working of late - when I upgraded from 4.7.8 to 4.7.11, though I'm only noticing now. When I submit the form using the CiviCRM page

<CiviCRM Install>/?page=CiviCRM&q=civicrm%2Fprofile%2Fcreate&gid=15&reset=1

it works fine. But when I go to the non-CiviCRM page, which worked previously, it no longer works, and I get the following error:

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

Any ideas? I've checked all the Resource URLS and they seem fine. I've checked the html code and, again, it works fine on the CiviCRM generated page but not on the static HTML page.

I'm using 4.7.12 on Wordpress 4.6.1.


texts: Is there a way to use css pagination / repeating elements with dompdf?

texts:
Is there a way to use css pagination with the current version of dompdf shipped with CiviCRM? Like:
@page :footer {content: "page " decimal(pageno);}

The issue is that I want some content that is repeated on every page. In a dompdf issue on Github it is claimed that using fixed positioning is another way to achieve this. But we have tried this solution in CiviCRM PDF templates and it does not have that effect.


texts:
I use CiviCRM 4.7.23, Drupal 7.56
I try set a payment processor: PayPal. I use my CiviCRM in Poland, where decimal delimiter is ",". After test transaction on paypal i see this in logs:

$Fatal Error Details = array(3) { ["message"]=> string(40) "fee_amount is not a valid amount: 29.80" ["code"]=> NULL ["exception"]=> object(CiviCRM_API3_Exception)#181 (8) { ["extraParams":"CiviCRM_API3_Exception":private]=> array(3) { ["is_error"]=> int(1) ["error_message"]=> string(40) "fee_amount is not a valid amount: 29.80" ["error_code"]=> string(9) "undefined" } ["message":protected]=> string(40) "fee_amount is not a valid amount: 29.80" ["string":"Exception":private]=> string(0) "" ["code":protected]=> int(0) ["file":protected]=> string(93) "/home/sol/domains/staroflife.hekko24.pl/public_html/dev/sites/all/modules/civicrm/api/api.php" ["line":protected]=> int(45) ["trace":"Exception":private]=> array(13) { [0]=> array(4) { ["file"]=> string(117) "/home/sol/domains/staroflife.hekko24.pl/public_html/dev/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php" ["line"]=> int(4693) ["function"]=> string(12) "civicrm_api3" ["args"]=> array(3) { [0]=> string(12) "Contribution" [1]=> string(6) "create" [2]=> array(11) { ["contribution_status_id"]=> int(1) ["source"]=> string(40) "Transakcja online: Pomóż nam pomagać!" ["is_test"]=> int(1) ["fee_amount"]=> string(5) "29.80" ["net_amount"]=> NULL ["trxn_id"]=> string(17) "7F503721X74500702" ["payment_processor"]=> string(1) "8" ["payment_instrument_id"]=> string(1) "1" ["receive_date"]=> string(14) "20170903013615" ["id"]=> string(2) "86" ["version"]=> int(3) } } } [1]=> array(6) { ["file"]=> string(110)
and more, more text here https://staroflife-my.sharepoint.com/personal/lewandowski_marcin_staroflife_pl/_layouts/15/guestaccess.aspx?docid=0025a0d10dbea4f9d9145381c2595ddeb&authkey=AYd_FW8zlLwY2fA5i0Lebd8

How i can change decimal delimiter only for PayPal. Ideally, something would convert a dot to a comma after receiving a return message.


texts: Browser "security shield" causing problems

texts: I have a user who attempted to use the Brave Browser to register for an event. However he was unable to get past filling out the registration information. Then he "lowered the security shield" and was able to get through to the confirmation page. This is Joomla and was civicrm 5.29 although I just updated to 5.30 since that happened.  Is this a known thing? Is there something I should to to warn people as part of the process?


texts: Recommended cron email sending rate for Mosaico mailings?

texts:
Various reports indicate that Mosaico can fail to send large mailings based on memory and cron rates for sending.

How might one calculate the maximum/most effective mailing rate considering available memory and php memory limit settings so as not to inadvertently have a failed mailing.


texts: How do i properly include civicrm.settings.php to use api calls?

texts:
Quite a long time ago I wrote an external script that does this at the top:

require_once '/path/to/joomla/install/com_civicrm/civicrm.settings.php';
require_once '/path/to/joomla/install/civicrm/CRM/Core/Config.php';
$config = CRM_Core_Config::singleton( );

...so that I can use civicrm_api() calls from an external php script.  Now after upgrading to the 5.x train of CiviCRM I realized my script was not working.  If I manually run the script I get this error:

  PHP Parse error:  syntax error, unexpected '$this' (T_VARIABLE) in .../civicrm/CRM/Core/DAO.php on line 1123

In an effort to determine if this was happening in a civicrm_api() call I made a file with just the three lines quoted above and run it with php, and it produces the error.  So I'm pretty confident the issue is the require_once trying to include these files, not the actual act of making an api call.

I've found numerous references to $this issues in DAO.php, but none of them are relevant to including these two files for the purposes of API calls and the line number of the failure is always different.

How can I fix this so I can use my existing script?


texts: How to add Contact "Notes" field in webform?

texts: I need to create a signup form via webform and would like to include a Notes section where people can make write something  during signup. I would like that to appear in the "Notes" section of contact. Cant seem to locate that option, any ideas please? Thanks


texts: When I click on CiviCRM to go to the home screen, there is a dashlet there for Activies.  It always shows none.  If I go to search activities, I see all kinds of them - why is this not updating?


texts: Is there a way to encrypt a single field in Civi database?

texts: To protect sensitive data - such as HIPAA info


texts:
I'm confused why Organization Name and Prefix are in the Lybunt report but not in the Sybunt report.  They both have

'fields' => $this->getBasicContactFields(),

which I thought included these fields.  Maybe I'm missing something.

I can quickly add Organization with this:

'organization_name' => array(
            'title' => ts('Organization'),
          ),

but I'm unclear how to add the prefix_id and convert it to the correct output (Mr., Mrs., etc)

   'prefix_id' => array(
            'title' => ts('Prefix'),

Thanks in advance for your help.

Drupal 7.51, Civicrm 4.7.11


texts: Why do some contacts share the same Drupal user?

texts:
I've got a bit of a baffling issue and I'm not sure where to begin looking for fixes.

I have begun to notice several instances where I have several contacts that share a single Drupal user account. These are contacts who are clearly not the same person and have no business sharing a single Drupal account.

Edited to add:

I'm using CiviCRM 4.6.8 and Drupal 7
None of the contacts share the same email address
Contacts are not synced via rules
We have recently opened registrations for 2 very large events. The merge rule we're using is supposed to sync contacts on name and email address
There is a profile used for site registrations. We collect name, email address, phone number, address, etc.

Any idea what might cause this to happen?


texts: How to show civicrm toolbar in drupal also?

texts:
I have created some drupal views for civicrm.
But the views pages are opening inside the drupal set up, where the civicrm toolbar is not showing.
Now, how can i show the civi toolbar in the drupal? To avoid the switching between drupal and civicrm.


texts: I forgot to tick the box to install the sample data. Is there a way to do it after installation? I tried loading civicrm_sample.mysql but that didn't seem to load everything.


texts: I want to hire a CiviCRM (Joomla) expert to fix a problem

texts: I have an immediate need (Contribution Form fails; bounces to Home Page or timeout error) and ongoing needs as well, for multiple client sites. This is urgent. Thanks!


texts: CiviDiscount - Automatic discounts for number of attendees

texts:
I have a site that's using CiviDiscount and the question has come up if advanced filters for automatic discounts can be configured based on number of attendees being registered for an event, irrespective of membership type/status or contact type, etc.

Example

Single ticket @ £75
10 tickets @ £60/ticket

So once 10 participants added, I'd like an automatic discount (let's say 20%) applied.

I want to the extra participants registered so a price set won't work. I know there's potential workarounds in terms of using a price set and using custom fields etc. but thought it's worth asking the question.

Any guidance hugely appreciated.

Many thanks


texts: When profile matches on email and the email that matches is not the primary, it overwrites the primary giving the same email repeated

texts:
We have a profile for registering people.  It is set to match on email.  If an existing contact fills out the form but say uses their billing email address and not the one set as their primary, it matches fine.  Great, but then it overwrites the primary with what they just entered.  Now we've lost their "primary" email address and have the same email address listed twice, once as billing and once as home.

Is there some nice easy way around this?  I'm I missing something?

I suppose I could create another type and set the profile for that.  Would still end up with the same address twice but wouldn't loose the other.  Or maybe a db trigger to skip the write to the email table if the email address already exists for that user.

Ah, the tangled web we create when we allow contacts to mess with their data.


texts: CiviReport Participant Sort by Event Start Date

texts:
I am trying to create a report that lists the participants for upcoming events (each day for the next 14 days), sorted by event start date as the section header. Event Start Date is not listed in the Column dropdown.

Event Start Date
-Event type
--Participant Name 1
--Participant Name 2

Next Day Start Date
-Event type
--Participant Name 1
--Participant Name 3

I saw this thread that gives me hope, but it doesn't specifically say how it was fixed. I've scoured the web trying to find a solution, but have come up with nothing else.


texts: Auto Renewal Membership Confirmation Emails not being sent - PayPal (Updated Title 2016-04-05)

texts:
CiviCRM: 4.7.3
Joomla: 3.4.8
PHP: 5.5.45

None of my Membership Contribution confirmation emails are being sent.   It doesn't matter if the person pays via PayPal, or is using Pay Later, they don't go out.

I receive the confirmation from PayPal that a membership fee payment has been made, but no other communications from CiviCRM, and I do have the email setup for CC to me.

Scheduled emails are being sent, as people are coming to the website to renew their memberships; and I've done the Outbound email check to verify that CiviCRM can send emails through the server.

This was working fine until August 2015, about the time I upgraded to 4.6.8 or so.

I kept up with the upgrades thinking that it was a fluke, but have not seen any corrections.   I am not seeing any PHP errors, and I have been testing this using dummy names and a real email address to see if I can force any error messages.

I'm basically at a loss, and with a major event coming up, I need to have confirmations sent when people pay.     I haven't tested with event confirmations yet, but that's the next step.

UPDATE:  Just tested with events, and Confirmation emails are being sent to the attendee, and the treasurer so, at least for PayLater, the confirmations are going out for events.

UPDATE - 2016-03-18  upgraded to 4.7.4, and had to revert out of it as it broke the 'pay later' display as described in CRM-18118.

Installed the patch to CRM/Contribute/Form/Contribution/Main.php as shown in 18118, and also patched CRM/Contribute/Form/Contribution/Confirm.php as showin in 18118.

The live page shows the Pay Later, and when tested sent an email to confirm the renewal, and show an invoice.   The CC email copies were sent properly.  I am not going to reinstall 4.7.4 as it appears something else in that release broke the fixes in 18118.


texts: How can I import Memberships without e-mail addresses or external IDs?

texts:
We are transitioning a small organization to CiviCRM 4.5, with about 2000 total contacts and about 150 memberships. The contacts imported without any problem, but when we went to import the memberships, we found that CiviCRM required either an e-mail address or an external ID.

About half of the members do not have an email address, and since the old membership system was a combination of Excel files and offline physical media, they have no unique membership numbers or other identifiers. All of the firstname+lastname combinations are unique, so we thought that should be sufficient, and we have the deduplication rule set to that effect elsewhere, but it seems to be inadequate for membership imports.

We don't want to be in the business of creating dummy email addresses, so it seems we must manually assign an external ID to the old contact list and the membership list, then reimport both in turn. But is there an easier workaround— some way to use Firstname+Lastname as the unique identifier? Or is there another "best practice" we could adopt here?


texts:
I've recently being doing some bulk import/export/delete using the
/civicrm/import/contact for import/export
/civicrm/contact/search/advanced for delete

I've done some timings for the bulk delete action and see the following (on a system with 2GB RAM)
Advanced Search: Show as contributions

Select contributions, bulk action delete
100 contribution delete: 28secs
200 contribution delete: 48secs
400 contribution delete: 88secs
1000 contribution delete: ~208secs 42% ram

memory usage increase by ~0.2% per second on 2GB system.

You will note that to delete 1000 contributions it will use nearly 1GB RAM (we've got php memory limits turned right up for testing).

Looking in jira I've across https://issues.civicrm.org/jira/browse/CRM-19798 which looks like it may be similar but not sure if it is related.

CiviCRM is version 4.7.14 on drupal 7.52.


texts:
Hey all Just found the Civibuildkit using Vagrant - made my day as they have a build that was useful for me to test and work on for my site.

My question is: Is there some one out there that can help me figure out how to create (load) the drupal-case (which is Drupal8 with the latest Civicrm build) without sample data.

I have tried to go through the files to figure it out, but if someone can point me in the right direction it would be great.


texts: how do I turn off access control and allow all users to see all contacts?

texts: When we started setting up civicrm many months ago we applied access controls so that users wouldn't see any contacts until we add them to their particular group. Over time we've come to the conclusion that there are too many situations where we need to see each other's contacts, so I've been requested to undo the access controls and leave it more wide open. What is the cleanest way to make this transition?


texts: Some successful Paypal transactions are showing "Pending (incomplete transaction)"

texts: Some of my event transactions are showing "Pending (incomplete transaction)" when they have been successfully processed through Paypal. Not all of them just two since my event went live. I'm on Joomla! 3.6.5 and CiviCRM 4.7.16


texts: constraint violation during event registration

texts:
Getting constraint violation error during event registration. I found that, this error happening when it's saving the custom field value after saving participant info. There is a post hook in my custom module, in that i have code(civicrm_api("Relationship", "create",$params)) to create relationship for contact, if i comment that line it's working fine.
Current version am using is CiviCRM 4.6.2. This issue was not there with my previous version 4.3.5.

Can we not use create-api in post hook?

Please suggest.


texts: How to set a contribution to another membership for the same member

texts:
Is there a way to set a contribution to another membership for the same member? He has 2 contributions and 1 active Membership without any contribution and 1 expired membership with 2 contributions including the renewed contribution?

Can I correct this?

Regards,

Guillaume


texts:
What solutions are people using to track all outbound email from CiviCRM?

BCCing would be one option - a BCC could be added to all outbound email via an extension, I suppose.

Else I'm guessing that some Third Party ESPs might also provide this functionality.

Interested to know what people are doing / if there are any solutions I haven't thought of.


texts: Where / how is the {domain} token formatted?

texts: I am required to use the {domain} token for mass mailing, but it is formatted with line breaks .. can I modify that formatting ?


texts: Fatal DB query syntax error on rules search - Civi 5.0.0 and recent Civirules

texts:
I have 7 rules set up to help automate membership management.  All are tagged with the same tag and all but one are active.  WHen I search by tag or for all rules I get the correct result, but when I search by the tag AND all rules I get a DB query syntax fatal error. This is from the log:

[db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix=""

info="SELECT COUNT(DISTINCT(crr.id)) AS total
      FROM civirule_rule crr
LEFT JOIN civirule_trigger crtrigger ON crr.trigger_id = crtrigger.id
LEFT JOIN civirule_rule_tag crtag ON crr.id = crtag.rule_id
LEFT JOIN civicrm_contact contact ON crr.created_user_id = contact.id WHERE  AND (crtag.rule_tag_id = 1)

[nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (crtag.rule_tag_id = 1)' at line 5]"]

I suppose that some condition is expected between WHERE  AND that I emphasized in bold.   This same error happens on Civirules 1.23 and 2.1.  The upgrade also updated the database, but I tested on a separate, older system that had not been upgraded.

Could this be due to some database corruption or is it a bug?


texts: IATS can retry failed donations 7 days after the failure?

texts: Is there a way that IATS can retry failed donations 7 days after the failure happened rather than the following month?


texts:
We would like to be able to resend a mailing (or send an edited version of the original mailing) to recipients who did not open the original mailing.
While there are workarounds — such as creating a new group — they take extra steps and can be especially confusing when trying to add a useful unsubscribe link.
A similar question was previously posted here in February 2019. I am wondering if any progress has been made on this feature?
Thank you!


texts: How to add a second photo to a mailing block

texts: How can I change a mailing block to add a second photo


texts: Configuring Civicrm For Organizational Membersship And Not Individual

texts:
I am trying to use Civicrm with wordpress to manage Organizations as Members NOT Individuals. But i discovered when i was testing that when I sign up for membership and i check the option I am Contributing on behalf of an organization that when i log in using the login details i created i see the dashboard of the individual and not the organization unless i login as the admin though.
How can i create a Sign up form such that the organization has its own username and password such that when i login i can see the dashboard of the organization

I am using Civicrm 4.6.8 with wordpress.


texts: CiviCRM generates broken link to contribution page

texts:
When I create a new contribution page and use the links sub-menu to go to the live location of the page, it redirects to

https://my.site.org/civicrm?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=1

This link doesn't work however. I can manually fix the url by removing the "civicrm" part, like this:

https://my.site.org/?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=1

My question is: where does this "civicrm" bit before the question mark come from? What kind of configuration error could cause this problem? I already checked the BASEURL setting, it seems correct (the value is https://my.site.org/)


texts: How to make fields on webforms mandatory

texts: I am registering for events through webforms. However if people do not leave their phone numbers we cannot contact them. Is there some options I am missing here to make this a mandatory field?