texts: How to access contact ID and checksum for a new contact from the Caldera form that creates the contact?

texts:
Using a Drupal webform I can create a new Civi contact, and get the contact ID and checksum for that contact from the form submission, enabling me to use it in an email triggered by the form submission. This lets me send a link to a second form, passing the contact id and checksum in the URL, to pre-populate the second form with details of the newly created contact.

I'd like to do the same thing using Caldera forms on Wordpress, but I'm struggling to see whether, and if yes, how, that might work. Can anyone cast any light?


texts: Normal to have API error while saving a Case Type?

texts: I'm on CiviCRM 4.6.18 and Drupal. When I save a case type, I keep getting an error on the top right that says "API error: DB Error: already exists." I'm not sure if this is causing another issue I'm having which is when I create a case, the loading keeps hanging.


texts: Is there a mechanism to charge users extra when they renew their membership after it has expired, e.g. extra 20% if paid after half year, extra 50% if paid later?


texts:
I'm busy translating user facing parts of CiviCRM to a local language.

I've changed some of the text on the Event page. I.e. Register, Event Fee Fields. But some of the reminders like when a user is already registered still shows up in English.

I've used PoEdit to edit translation files but none of these fields are included. Only back-end fields are included in the translation file.

Here are examples of fields I'd like to translate:

"It looks like you are already registered for this event. If you want
to change your registration, or you feel that you've gotten this
message in error, please contact the site administrator. You can also
register another participant."
Continue Button
"Please verify the information below. Click the Go Back button below
if you need to make changes. Otherwise, click the Continue button
below to complete your registration."
"Your registration will not be submitted until you click the Continue
button. Please click the button one time only. If you need to change
any details, click the Go Back button below to return to the previous
screen."
"An email with event details has been sent to ..."
When
Location
First Name
Last Name
Your Registration Info
Participant Info
Event Information


texts: Why do 'track click through' links not redirect to correct address?

texts:
When I add links to external websites (such as www.wikipedia.org) to mailings and check 'track click through' the links go to a page on  my website that says 'page doesn't exist'. The url is something like this: mysite/wp-content/plugins/civicrm/civicrm/extern/url.php?u=30&qid=44.

This is obviously a key reason for wanting to use civiCRM so it'd be great to have link tracking working.

I see people have had this problem in the past (see here and here) but I can't seem to find a solution for it.

I have looked at extern/url.php and TrackableURLOpen.php and there don't seem to be any problems. (gists: trackableURLOpen.php url.php)

I'm using wordpress and civicrm 4.6.

My civicrm files are here: http://mysite/wp-content/plugins/civicrm/civicrm/

My temp files are here: http://mysite/wp-content/plugins/files/civicrm/

My civicrm.settings.php file says:

global $civicrm_root;

$civicrm_root = __DIR__ . '/civicrm/';
if (!defined('CIVICRM_TEMPLATE_COMPILEDIR')) {
define( 'CIVICRM_TEMPLATE_COMPILEDIR', __DIR__ . '/files/civicrm/templates_c/' );
}

Should the root be DIR . '/civicrm/civicrm/'? because that doesn't work.


texts: Is it possible to get event mailing (confirmation etc.) into a Persons activities?

texts:
It seems like activities like CiviCRM sending event registration confirmations etc. does not show up in the list of activities on the "Activity" tab.

Is it possible to make them do that or would that be a "feature request"?


texts: CiviSurvey has two types of information we could collect - 'Contact Info' and 'Questions'. Is there any difference between these two from an implementation perspective? Would it make any difference if I add a profile in Contact Info vs Questions?


texts: How to handle donors that pay by wire transfer

texts:
My foundation has donors. People who become a donor, promise to pay at least €10 per year to the foundation. Because as a result, the whole family gets benefits, I have set this up a membership called 'Donateur'. Memberships are entered on the household.
We don't have a payment processor as we need to keep everything extremely low-cost (as in: there is no IT-budget except in-house computers and web hosting).
The challenges I'm facing are these:

How can I automatically renew these memberships so they are extended but waiting for payment?
How can I enter multiple payments for donors who split up their payments (as rediculous as it sounds, I have one who pays €2,17 every quarter), or for those who pay more but in multiple instances?
How can I tell which households still need to pay (part) of their fee?
How can I send an e-mail to donors when the e-mail address is on (one of the) household members and not on the household itself?

Or should I completely reconsider the usage of memberships for this type of setup entirely and do something different.
We're running CiviCRM 4.7.9 on Joomla 3.6.0.


texts:
I've seen the conversation at: https://forum.civicrm.org/index.php?topic=27981.0. But I was wondering if anyone had experienced successfully embedding a PHP library in an extension.

Specifically I want to include the PHP Simple DOM Parser. Any instructions/guidance? That contains a simple php file and a folder of files that it uses.


texts: Current state of Household Membership signup (Wordpress)

texts:
I'm currently working on a new install of CiviCRM to manage our co-operative membership. Membership is paid annually per household - each householder additionally makes an initial one-off £1 investment of share capital which confers voting rights in the coop.

I've done a LOT of reading around household membership and I'm aware that it's an underdeveloped area in Civi - sadly we're not in a position to cover the 200-400 hours of work that Lobo suggests would be required make it work as desired.

There seem to be a few people who've crafted successful work-arounds either with organisational subgroups or using Drupal webform integration to create complex sign-up pages. However, I've also seen a number of people years later bemoaning having taken the 'household route' initially.

As I'm at the beginning of the process and some of the forum discussions are a number of years old, I'm looking for a steer on the current developments and best practice. In particular:

Is there a recommended route for allowing online self management of family groups?
Our preferred CMS is wordpress, does the active development of Caldera Forms integration suggest a potential route, or will we have to adopt Drupal for complex webforms?

Many thanks for any pointers.


texts:
I'm administering a site with some mail templates. They contain pretty much logic, and it is easy to make mistakes when making sure that both the text and the html version displays exactly the same information.

I have considered disabling the text version, but I don't know how. After all, very few don't have support for html in their email client today. As a workaround I have thought of just copying everything from the html to the text.

Any ideas of how to handle this properly?


texts:
I am trying to add in some additional dropdown options on a component of a webform

I dont want to use static options and  need to alter the live options

How do do find the fields that the live options refer on CIVI so I can change them? So that they will come up as live options

Hope this makes sense!


texts: CiviMail Report - Administrator Permission Problem

texts:
I'm using CiviCRM 4.7.20, but the problem showed up at some point while I was using 4.7.11. I'm using the current version of WordPress. I'm the administrator and used this userID/password to upgrade to 4.7.20, hoping this problem would go away. WordPress Users shows that I'm the administrator. At some point, the Report links on the CiviMail Report screen, started giving me: "Sorry but we are not able to provide this at the moment. You do not have permission to access this page." I can still access the Advanced Search links on the same screen. What's going on??

I'm using the WP Members Plugin, but disabling it doesn't help. I've gone into WP Roles and made sure the Administrator is granted every permission and denied nothing. What's going on??

Here's the backTrace I get from clicking on menu item: Mailing Reports

#0 /home/mysite/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(374): CRM_Core_Error::backtrace()
#1 /home/mysite/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php(354): CRM_Core_Error::fatal("You do not have permission to access this page.")
#2 [internal function](): CRM_Utils_System_WordPress->permissionDenied()
#3 /home/mysite/wp-content/plugins/civicrm/civicrm/CRM/Utils/System.php(74): call_user_func_array((Array:2), (Array:0))
#4 /home/mysite/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(230): CRM_Utils_System::__callStatic("permissionDenied", (Array:0))
#5 /home/mysite/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(230): CRM_Utils_System::permissionDenied()
#6 /home/mysite/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:14))
#7 /home/mysite/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#8 /home/mysite/wp-content/plugins/civicrm/civicrm.php(1227): CRM_Core_Invoke::invoke((Array:3))
#9 [internal function](): CiviCRM_For_WordPress->invoke("")
#10 /home/mysite/wp-includes/class-wp-hook.php(298): call_user_func_array((Array:2), (Array:1))
#11 /home/mysite/wp-includes/class-wp-hook.php(323): WP_Hook->apply_filters("", (Array:1))
#12 /home/mysite/wp-includes/plugin.php(453): WP_Hook->do_action((Array:1))
#13 /home/mysite/wp-admin/admin.php(222): do_action("toplevel_page_CiviCRM")
#14 {main}


texts: Advice for moving from Access to CiviCRM

texts:
Our client has asked us to move them from a legacy MS Access based membership system to CiviCRM (on Drupal). Their existing system encompasses many years of memberships, accounts, academic records etc.

This will be the first time we will be importing a full system. Can anyone point us to any best practice advice or guidance?


texts: Where can I see the database upgrade script?

texts: I want to see which indices were supposed to be created in the last upgrade I ran because I get a status report message saying that some indices are missing, but when I click "Update Indices" I get an error saying "DB Error: already exists". So I'm pretty sure some of the indices are missing, but not all of them. So I want to manually create only the missing ones.


texts: REST API - how to write new options for a custom field with select type?

texts:
Using the contact - getoptions method you can read the list of options for a custom field with select type.

  /civicrm/civicrm/extern/rest.php?entity=Contact&action=getoptions&api_key=userkey&key=sitekey&json={"sequential":1,"field":"custom_5"}

But how can I create new options using the API?


texts: I'm not getting the results that I expect from the event income reports. I've used the "No-show" status for people who have paid but don't turn up to the event. However the report only seems to included the income for participants with a status that is "Counted". That's right for the attendee numbers, but not for the finance. If I set the "No-Show" status to be "Counted" then I assume the figures will come right, but it won't show the numbers actually at the event. I can't think of a way round this.


texts: Wordpress shortcodes do not display 'insert' button

texts:
In Wordpress, it is possible to insert CiviCRM shortcodes for, eg, profiles, directly in the Page/Post editor.

However, when I do this, the 'Insert CiviCRM content' screen displays, but there is no visible button available to insert the code and return to the Wordpress editor.

See screenshot of what I see.

Is this a bug, or is something else preventing the button from appearing?


texts: Why do some of my participants get sent a receipt when I update event details via a profile form

texts:
I'm using CiviCRM V4.4.13 and Drupal 7.41.

I have created a profile for batch updating several custom fields and the status of participants on our events. However, some participants seem to get sent a receipt after saving the updates (around 5-10% of participants) as if we had gone into their participant record and selected send confirmation and receipt. Is this a bug or is this expected behavior because of X reason?


texts: When running cli.php it hangs and never completes

texts: Running Cli.php was working with command line as well as though cron.  However it now just hangs and uses cpu but never completed.   Schedule jobs do run and execute  if used execute now on the admin page.  Any help would be appreciated.


texts:
I have recently upgraded Civi to 5.4.0

When I want to save a content (Page, Webform, ...), I get the following error message :

Fatal error: Call to undefined function rules_action_drupal_goto() in /home/.../www/www/sites/all/modules/civicrm_entity/civicrm_entity.module on line 4021

Before upgrading Civi, I have already been using Drupal 7.59 for some months without having this problem.

Any help would be very welcome.


texts: Googlebot & Could not find valid value for id

texts:
Over the last few years every few days a fatal error is triggered by a Googlebot. Seems harmless and unnecessary but it is possibly affecting ranking.

The errorreport extension (ca.bidon.reporterror) reports:

HTTP_FROM: googlebot(at)googlebot.com
REDIRECT_QUERY_STRING:q=civicrm/event/register&snippet=4&type=
but also sometimes:
REDIRECT_QUERY_STRING:q=civicrm/event/register

The logfile in ConfigAndLog says:

May 17 19:16:31  [info] $backTrace = #0 /home/account/domains/ourdomain.nl/public_html/crm/sites/all/modules/civicrm/CRM/Core/Error.php(363): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/account/domains/ourdomain.nl/public_html/crm/sites/all/modules/civicrm/CRM/Utils/Request.php(95): CRM_Core_Error::fatal("Could not find valid value for id")
#2 /home/account/domains/ourdomain.nl/public_html/crm/sites/all/modules/civicrm/CRM/Event/StateMachine/Registration.php(52): CRM_Utils_Request::retrieve("id", "Positive", Object(CRM_Event_Controller_Registration), TRUE)
#3 /home/account/domains/ourdomain.nl/public_html/crm/sites/all/modules/civicrm/CRM/Event/Controller/Registration.php(47): CRM_Event_StateMachine_Registration->__construct(Object(CRM_Event_Controller_Registration), TRUE)
#4 /home/account/domains/ourdomain.nl/public_html/crm/sites/all/modules/civicrm/CRM/Core/Invoke.php(307): CRM_Event_Controller_Registration->__construct("Event Registration", TRUE, "null", NULL, "false")
#5 /home/account/domains/ourdomain.nl/public_html/crm/sites/all/modules/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:15))
#6 /home/account/domains/ourdomain.nl/public_html/crm/sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))
#7 /home/account/domains/ourdomain.nl/public_html/crm/sites/all/modules/civicrm/drupal/civicrm.module(489): CRM_Core_Invoke::invoke((Array:3))
#8 [internal function](): civicrm_invoke("event", "register")
#9 /home/account/domains/ourdomain.nl/public_html/crm/includes/menu.inc(519): call_user_func_array("civicrm_invoke", (Array:2))
#10 /home/account/domains/ourdomain.nl/public_html/crm/index.php(21): menu_execute_active_handler()
#11 {main}

I have 27 full examples of this now. Probably I'm not the only one experiencing this. What would be a cause of this? And what would be a start of a solution?


texts:
I cannot save Reports to Dashlets. I have taken a Membership Detail report and edited it to show me the information I want. I go to the Access tab and click on "Available for dashboard?" and Save it, but nothing happens.There is no dashlet when I go to my dashboard and configure. I have also tried to save it to My Reports and nothing is there.

This WAS working. I had a Membership dashlet and a report of my own in the dropdown report menu. The dashlet stopped working and the report instance has disappeared.

I am on the latest version of CiviCRM 4.7.30

I am logged in as the Super User, I have read the documentation and searched the forum for an answer. As a result, I have specifically created an Admin group to include Super User and given it the Administrator ACL. This account has the Super User privs of Joomla.

I have searched this forum and seen the previous query. I noticed that I do NOT get the ACL and Permissions on my Report instance and never did. Why is that?

Why is nothing happening? What could have changed in the last month?


texts: Defining Membershipstatus Rules and update issue

texts:
I've read the documentation about membershipstatus rules and something stays unclear. Even with a contribution, the Pending status stays and is not being updating (see my related post: webform and membership)

Should I set the beginning of "New" at "Member since" or "Start date"?

The journey I defined is:

Any ideas to help?

best regards,
Guillaume


texts: I want someone BCCd to an email genearted by a System Workflow Message

texts: I want to add a CC or BCC email to an email generated by System Workflow Messages. For example, when the "Memberships - Signup and Renewal Receipts" message gets emailed to a donator, I want another person BCCd on that email. Where do I go to configure how, who, and when those System Workflow Messages get sent?


texts:
Question:  How do I require the first and last names on Individuals?

I need to require some global fields in the CiviCRM backend GUI.  Specifically, I need to require the First and Last name for individuals on the standard individual create/edit backend webforms.

I thought there was an admin page to set this, but can't find it right now and I suspect other people will be interested in the answer too.


texts: image directory path seems to be ignored in CiviMail editor

texts:
G'day,

Using CiviCRM 5.7.2 with Drupal 7.61, when editing a newsletter in CiviMail, the image browser always points me to

$drupaldir/sites/all/modules/civicrm/persist/contribute/images/

no matter what I configure as the directory path for "Image Directory" at

civicrm/admin/setting/path?reset=1

I've tried relative path ([cms.root]/sites/default/files/uploads), absolute path, and absolute path via settings override in civicrm.settings.php; all to no avail.

[added to clarify in response to @Chris Burgess' comment]:
The setting does stick, as in it shows up as entered in the form after a reload; and when I tried settings override via civicrm.settings.php, that setting showed up instead and made the form field uneditable. Still, whatever shows up there does not seem to have any impact on where the image browser takes me.

I double- and triple-checked permissions and they are fine; we're also using the same directory with ckEditor and IMCE in Drupal with no problems.

Not sure if I'm missing something, but isn't that the correct setting for what I want to do?
Either way, is there a way to point the image browser to our general image path in the drupal files directory?

Many thanks in advance for any advice!

Update:
The image browser window shows the following URL:

<mywebsite>/sites/all/modules/civicrm/packages/kcfinder/browse.php?cms=civicrm&type=images&CKEditor=crmUild_1&CKEditorFuncNum=0&langCode=en-au

so I poked around a bit in the kcfinder directory. There's a config.php, but it appears that the settings in there are also ignored.

So I took more desperate measures:

cd $drupaldir/sites/all/modules/civicrm/persist/contribute
mv images images.HOLD; ln -s ../../../../../default/files/uploads images

Now it shows me the correct directory (though with the wrong name), but whatever I try to do, I get a "warning" dialog stating "unknown error".
Well, was worth a try.

Anything else I could try to get this to work?


texts: How best to use crmApi result within angularJs controller?

texts:
Referring to the snippet below, how do I get the controller function (DashboardController) to 'wait' for the return from crmApi? I've debugged enough to know crmApi returns the results I like, but DashboardController exits before I set self.user.
I'm weak on promises, but perhaps I also need to find a better place to call crmApi? Is it a better practice to call crmApi within, e.g., angular.module('tournament').config(['$routeProvider' ...
angular.module('tournament').component('dashboard', {
templateUrl: '~/tournament/dashboard/dashboard.template.html',
controller: ['$routeParams', 'crmApi',
function DashboardController($routeParams, crmApi) {
var self = this;
  // e.g., dashboard/43
  if ($routeParams.userId !== undefined) self.userId = $routeParams.userId;

  self.user = crmApi('Contact', 'getsingle', {
    "sequential": 1,
    "return": ["display_name","modified_date"],
    "id": self.userId
    }).then(
        // Success
        function(result) {
            return result; // How can I get self.user to 'wait' for this return?
        },
        // Failure
        function (error) {
            CRM.alert(ts('Could not get user record ID of %1, error = %2', {1: userId, 2: error}),ts('Not Found'),'error');
        }
    );
}

]
});


texts: Scheduled jobs running but not successfully updating

texts: I have just updated to CiviCRM 5.4.1 and system status says the cron is running OK. However, the member statuses and the scheduled reminders are not being updated. These jobs were being run successfully in the summer but stopped at some point before I updated to the new version. Suggestions?


texts: Create event participate using OOP API in CiviCRM

texts:
There are 2 different sites in Drupal. In one of them there is CiviCRM is installed. Now I want to create event participate from first site which will use CiviCRM of second site. I have successfully get the list of events from second site to first site using:

$api = new civicrm_api3 (array ('server' => 'http://localhost/civicrm', 'api_key'=>'xxx', 'key'=>'xxx'));

if ($api->Event->Get()) {
    print_r($api);
} else {
    echo $api->errorMsg();
}

Now I want to create event participate using OOP API in CiviCRM. So I have create code something like that:

$params = array(
        'contact_id'    => 1,
        'event_id'      => 2,
        'status_id'     => 1,
        'role_id'       => 1,
        'register_date' => '2007-07-21',
        'source'        => 'Online Event Registration: API Testing',
        'event_level'   => 'Tenor'
);

if ($api->Participate->Create($params)) {
    print_r($api);
} else {
    echo $api->errorMsg();
}

But in response I'm getting:
API (Participate, create) does not exist (join the API team and implement it!)

So is it still in development? any other way to do that?


texts:
we've just started using CiviCRM events.  I've followed the process to get the event set up.  I can test-drive the link and it works fine but if I go to the live online registration I get an error page that says I don't have permission to access the page.
I've tried setting the public permission to allowed for "CiviEvent: register for events" to Allowed but it doesn't save when I change the permission.
Any ideas where i need to look for the error.  I'm using CiviCRM 4.7.7 and Joomla! 3.5.1
Thanks
Emma


texts: CiviCRM membership Manual entry in joomla

texts:
I am facing very strange issue in CiviCRM. I have added the membership entry manual from the administrator but I wonder that record is  not exist in the database. I searched into all tables but no record in db. Then I tried to find out by the Contact id of CiviCRM contact, again that id is not exist in the db. I wonder where is the data is saved for manual membership user. Please help me regarding this issue.
Thanks


texts:
I'm running into an issue that I'm unsure is code-related or workflow-related, so I'm cross-posting on the CiviCRM StackExchange as well. I'm able to configure everything to talk well with MailChimp, but when I do a dry run Pull sync from MailChimp to a fresh CiviCRM group, I'm only seeing 10 Contacts syncing over from lists I know have between 13 and 700 Contacts. I've combed through the issue discussions but don't see any tracking of this particular issue.

As far as I can tell, I'm not seeing any errors Is there an API issue I'm running into? I've tried a configuration both with a mature and a fresh MailChimp account. Thanks!


texts: How do I view a "Scheduled and Sent" mailing without creating a draft?

texts: Is there a way to view "Scheduled and Sent" mailings in CiviCRM other than clicking the Re-Use button? This creates a draft of the email which our users sometimes forget to delete, and it's caused some confusion.


texts:
Every time I save in a frame I get the following error.

  Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame\n\n  thrown in /var/www/html/sites/all/modules/civicrm/Civi/Core/Transaction/Manager.php on line 107

I am using Drupal 7.43 and CiviCRM 4.6.14. An upgrade to 4.6.16 failed and I have restored to backup and am now unable to save anything that is done inside a frame.


texts: How to add "Family Member Information" Columns to Event Attendee List report?

texts: Is it possible to add Family Member Information columns to this screen? I run a youth program and it would be helpful to be able to pull emergency contact information when running the report. Very new to Civi.


texts: SOLVED CiviMobile won't login "please install CiviMobile in your CiviCRM"

texts:
When I try to use CiviMobile on my phone to login to CiviCRM I get error "Please install CiviMobile extension in your CiviCRM".

Drupal7.67 / CiviCRM 5.12.2 / php7.2 / Running on Aegir
Installed CiviMobile 4.0.1 on my Android phone from Play Store and
can successfully log in to the demo.
installed CiviMobileAPI v4.0.2 from the repository and it reflects
as installed.
Installation directory is    /data/disk/xxx/static/platforms/platform_name/sites/collaborate2019.co.za/files/civicrm/ext/com.agiliway.civimobileapi
CiviCRM/Administer/CiviMobile settings reflects that the extension is
up to date
Login username and password and website URL
https://collaborate2019.co.za are correct (when I tried
https://collaborate2019.co.za/civicrm it gave me "Server API error")

Any ideas what I can try?


texts: Module to Sync CiviCRM Organization's Related Contacts to Drupal8 Roles?

texts:
Is there an existing module or technique to sync Civi contacts and Drupal8 roles based on their relationships to a Civi Organization?  Assume the contacts have linked Drupal user accounts.

There appear to be modules for syncing Memberships to Drupal roles (civicrm_member_roles) or to static Civi Groups to Drupal Roles (civicrm_group_roles), but I can't find a corresponding "civicrm_related_contacts_roles" module.  (I'm aware that these modules were designed for Drupal7, but I've been able to fit the membership sync module to an existing Drupal8 installation, so I'm hoping the same is possible if a module exists for relationships)

Ideally, such a module would let me specify a Civi Contact (I guess we can ignore whether it's an Org, Ind, or Household), a Civi relationship type that an Individual might be able to have with that Contact, and a Drupal role. Then anyone who is related in that way to that Contact would automatically be assigned to the Drupal role.

Any existing modules or code examples?


texts: Upgrading Mosaico without losing templates

texts: I have a client using Mosaico beta 3 (WordPress 5.1, Civi 5.7.5). I want to upgrade them to Mosaico beta 4, but they have a number of templates already built and I don't want to lose them when I upgrade. If I uninstall Mosaico beta 3 and install Mosaico beta 4, I will lose them. Anyone know if I can save the templates during the upgrade, and if so, the best way to do so?


texts: Only !CRM.checkPerm("administer CiviCRM")) conditional works

texts:
If I put this (or any JQuery) in an .extra tpl file it works

{literal}
<script>
if (!CRM.checkPerm("administer CiviCRM")) {
CRM.$( function( $ ) {
    $( document ).ajaxComplete(function( event, request, settings ) {
   //do stuff
 })
 })
 }
{/literal}
</script>

If I switch the permission away from administer CiviCRM, it does not work and executes the code for all users. Carrying over from here: Removing elements for non-admin users.


texts: How do I import contacts through the command line?

texts: How can I import contacts in CiviCRM using the command line (CLI) rather than using the CiviCRM user interface and its importing wizard?


texts: Can activity tags be included in activity reports or exports?

texts:
tags have been added to a variety of activities by a user over the last few months.

Now they want to include the tag details in a report.

As far as I can see activity reports can filter by tag, but tey are not available as a column. And activity export does not give the option to include tags either.

Have I missed something? Anyone had any success getting this data out?

Civi 5.3.1


texts: Contribution Report Section Headers no longer list subtotal amounts

texts:
Previously, if you used a section header on a contribution detail report, the section header would show the number of contributions and the subtotal of that section in parentheses. So for example, if you were using Financial Type as the section header, it would show "Financial Type Name (# of gifts, subtotal of gifts). Now it only lists the number if gifts and the NOT the subtotal. is this expected behavior? Anyone know why the change?

Using Civi5.3.1 under WordPress.


texts:
I am planning to upgrade civicrm from version 4.2.9 to 4.7.23. For this can I directly upgrade it from 4.2.9 to 4.7.23? Or any other version I have to upgrade first and then to move to 4.7.23. Please suggest me steps for this.

Thanks in advance.


texts: How do I edit email template for Events confirmations

texts: I am trying to override the default email template for civicrm Events, which will be sent when registration is complete. I made changes on this file CRM/Event/Form/EventFees.tpl but the changes are being shown on email. I tried clearing cache but this doesn't help. Am I doing something wrong here?


texts: Where is the merge function for CiviMail located in code?

texts:
CiviMail has a great feature that finds intended recipients with the same email address prior to a mailing and prevents multiple emails getting sent to the same address.  It seems similar to the Merge Address or Merge Household features in the Export action. Where in the code base is the CiviMail merge functionality located?

I'd like to create a similar function for CiviSMS and am looking for a starting point.

Based on the merge functions I've found in Export (https://github.com/civicrm/civicrm-core/blob/master/CRM/Export/BAO/Export.php), I've tried a few different searches on GitHub for the CiviMail merge function like "mergeemail" or "merge_email" but can't find anything yet.


texts: Can one change the order of Groups shown on a profile?

texts:
I would like to change the order of the set of groups that are displayed to a user.  In my case, I'm working with Mailing List groups, and all five are set to "Public Pages" visibility.  If they are shown on a profile using the "Group(s)" field, they come up in alphabetical order.

The same ordering default is exhibited on the Mailing List Subscription page, /civicrm/mailing/subscribe.

My goal here is to create a mailing list preferences profile that users would get to through a checksum placed in emails sent to them by CiviMail.  In my case, the default alphabetized order creates an awkward presentation for how my organization wants to relate to our community.

I'm currently running CiviCRM version 4.5.4 on Drupal 7.


texts:
We currently have circa 1000 community groups across the UK and need to run a report on the amount held in each region or county.

I can obtain the numbers by running individual advanced searches for each region by setting the criteria etc, but is there a simple & effective way but building a report around this information?

Many thanks

Terry


texts: DB error on listing mailing recipients. Did anybody see that before?

texts:
When listing recipients of CiviMail either via advanced search or mailing report¹ I get a wrong row count query. See the where-clause in

SELECT count(DISTINCT contact_a.id) as rowCount  FROM civicrm_contact contact_a
LEFT JOIN civicrm_mailing_recipients ON civicrm_mailing_recipients.contact_id = contact_a.id
LEFT JOIN civicrm_mailing ON civicrm_mailing.id = civicrm_mailing_recipients.mailing_id
WHERE  (  AND civicrm_mailing.id IN (2198) )  AND (contact_a.is_deleted = 0)

This is generated by CRM\Contact\Bao\Query.php.

Before I dig down into all the query generating code: Did anybody of you civi gurus out there see this before?

Relevant stacktrace is:

#10 /civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query("SELECT count(DISTINCT contact_a.id) as rowCount  FROM civicrm_contact contact...")
#11 /civicrm/CRM/Core/DAO.php(420): DB_DataObject->query("SELECT count(DISTINCT contact_a.id) as rowCount  FROM civicrm_contact contact...")
#12 /civicrm/CRM/Core/DAO.php(1496): CRM_Core_DAO->query("SELECT count(DISTINCT contact_a.id) as rowCount  FROM civicrm_contact contact...", TRUE)
#13 /civicrm/CRM/Contact/BAO/Query.php(4977): CRM_Core_DAO::singleValueQuery("SELECT count(DISTINCT contact_a.id) as rowCount  FROM civicrm_contact contact...")
#14 /civicrm/CRM/Contact/Selector.php(525): CRM_Contact_BAO_Query->searchQuery(0, 0, NULL, TRUE)
#15 /civicrm/CRM/Core/Selector/Controller.php(218): CRM_Contact_Selector->getTotalCount(4, NULL)

¹) URI on error is /civicrm/contact/search/advanced?force=1&mailing_id=<MAILING_ID>


texts:
All of a sudden, out of blue, none of my contribution pages can be accessed by the the public. I am installed in WP and there is no "Make online contributions" permission as an option.

(From the Wiki:

Notes on Specific Permissions
Make online contributions:
If you plan to use CiviContribute and want to allow online contributions, enable this permission. Be sure to assign this permission for the "anonymous" role if you want to allow un-authenticated visitors to make contributions.)

It was all working fine and then out of the blue, it wasn't. Working with 4.7.25.


texts: Create menu for "Event registration" on Joomla site

texts:
I have created a menu item "Event registration" on the backend of my Joomla site (localhost).  In civiCRM I created a template and created a new event.  On the front end it displays the below error message.

I will appreciate help.

Many thanks in advance

  @import url(/civicrm/administrator/components/com_civicrm/civicrm/css/civicrm.css); @import url(/civicrm/administrator/components/com_civicrm/civicrm/bower_components/jquery-ui/themes/smoothness/jquery-ui.min.css);    Sorry but we are not able to provide this at the moment. The page you requested is currently unavailable. Return to home page.    function toggle( element ) { var className = element.className; if ( className == 'crm-accordion-wrapper collapsed crm-fatal-error-details-block') { element.className = 'crm-accordion-wrapper crm-fatal-error-details-block'; } else { element.className = 'crm-accordion-wrapper collapsed crm-fatal-error-details-block'; } }


texts: How to limit number of contacts in a group?

texts:
I have a max no of users limit for a group, so whenever someone adds a groupContact using the civicrm dashboard, I would like to present them with an error which prevents adding a new group and stating a message for the same.

I am using a civicrm_api() but could not figure out how to prevent the creation of groupcontact or provide a validation for the same?


texts: We need CiviCRM Member Form in six or more different languages.  The site will be in three languages, but we want the Member Form to be in as many languages as possible.  I can't find any information about CiviCRM multilingual support, except for a few random sentences in the documentation that indicate multilingual is supported.  Where can I find more information about the set-up, user interface and languages that are supported.  Does multilingual implementation require an extension?


texts: How to use Word upload in Print/Merge function?

texts:
Can anybody kindly help me to understand how to use the Word upload function in the Print/Merge window?

I have tried to insert the CiviCRM tokens into the Word file before uploading the file and doing the Print/merge -> does not associate all tokens to the values from the database.

I have tried create a Message Template with a Word uploaded file, then to go to the Print/Merge function -> does not associate all tokens to the values from the database either.

Therefore my questions: how should the tokens be inserted into the Word file before doing the upload? Is there any special code that needs to be used?
If anybody can provide User-feedback after using this function, I will be very grateful.

Thanks for your help.

(Drupal 7.67 & Civi 5.7.0)

(this is a more precise question, following the question and the answers from last week in Stackexchange : How do use upload function for mail merge with Word)


texts: Getting Apache 500 error when using CiviProxy

texts:
Because I haven't seen this topic here, I assume I'm handling a rather basic configuration error, but I've been stuck for three days now:

I've downloaded the latest CiviProxy release (0.6.dev1) following the instructions on https://docs.civicrm.org/civiproxy/en/latest/installation/#installing-the-proxy-scripts-your-your-civiproxy-server and adapted the values for

$proxy_base     = 'https://civiproxy.mydomain.org';
$target_civicrm = 'https://www.mycivicrm.de/civicrm';

Basically, my setup seems to work. If I access

https://civiproxy.mydomain.org/index.php

I can see the Civiproxy page. I also adapted

// API and SITE keys
$api_key_map = array('civiproxykey1' => 'civicrmkey1');
$sys_key_map = array('civiproxykey2' => 'civicrmkey2');

and kept the already existing rule

$rest_allowed_actions = array(
  'all' => array(
    'Contact' => array(
      'getsingle' => array(
        'email' => 'string',
      ),
    ),
  ),
);

The target system is running CiviCRM 5.6.0.

If I run

http://https://civiproxy.mydomain.org/rest.php?entity=Contact&action=getsingle&key=erikhtestkey&version=3&json=1&api_key=testerikhapikey&email=pipotest@example.org

(with adapted key values of course), I get an Apache 500 error. Accessing CiviCRM directly (with adapted keys) returns some data, so it looks to me like every component is doing fine but the connection is not working. My basic key usage seems to be OK. At least I get an "invalid key" error if I intentionally use a wrong key.

In order to see whether CiviProxy is trying to contact CiviCRM in the first place, I ran tcpdump on the CiviProxy server and saw no data going out to CiviCRM. curl https://www.mycivicrm.de/civicrm is doing well, so my current assumption is that for some mistake I made in the CiviProxy setup, it is not even trying to connect to CiviCRM. I also tried installing CiviProxy on the CiviCRM server, but didn't succeed either.

The de.systopia.civiproxy is installed on the CiviCRM server. I can provide the configuration on that system as well, if needed.

Kind regards,

Anna


texts: How can I get civi fields with multiple options to offer the "multiple field setting" in the way that drupal fields do?

texts:
I know the simple answer is "add this functionality to the civi views module" but it has been mentioned in other tickets but the fact that this could be possible but isn't doesn't seem to have been addressed directly.

My testing suggests CiviCRM Entity does not add this currently either. Below is a screenshot for a drupal 'content' based view that has a field that is a multiselect to show what is offered for such fields in the View.


texts: Use Create Mode Profile - Selection fields shown twice

texts:
Joomla 3.5.1
Civicrm 4.7.7

I have created a custom profile, used for volunteer registration.
When the form is loaded on the joomla front end in create mode, any fields that are either multiselect, or simply select, show the selections field twice.
First field shows default as "-none-" and the second shows "Select some options".

See here for example:

Any help will be appreciated.

Thanks


texts: Error when assigning Activity to a contact

texts:
We're on 4.6.8 and having an issue where when saving an activity which is assigned to a contact the following error is displayed:

Sorry but we are not able to provide this at the moment.
Sorry an Error Occured
MysqlColumnNameOrAlias is not a recognised (camel cased) data type.

If it is not assigned to anyone there is no error. However, if you click back and go into the record again the activity has in fact been saved. Not a massive issue as the activity is saved but it's not good from a usability perspective.
From looking online it looks like the following code is where the error is being generated from:
https://github.com/civicrm/civicrm-core/blob/master/CRM/Utils/Type.php
Any ideas what is causing this?


texts: How do you transfer an event registration from one person to another? I can't find an option that will allow me to put a new person's name in an existing registration so that the payment will follow the original registration.


texts: How to add additional action buttons in a civicrm Add Event form?

texts:
I have added a button in the EventInfo.tpl

{include file="CRM/common/formButtons.tpl" location="bottom"}

            <button>Approve</button>

           <span class="request-approval crm-button crm-button-type-upload"
            <button>Request for Approval</button>

But when I click on Add Event under Manage Events, I see a popup which does not show my button but when I click on add event and add it to new window it shows the button, how can I make sure it works on both the places
1) Popup

2) New Window(which is showing currently)


texts: How can I update the CiviMobile 2.0 extension to the CiviMobileAPI 3.0 extension?

texts:
I had v2 of the CiviMobile extension installed on a WP/Civi site for testing to see how the mobile app would perform. I see that a new version of the app and the extension has been released, so tried to update the extension and just keep getting a fatal error. Looking at the log, it appears to be caused by an incorrect default value that the extension is trying to set in the 'civicrm_contact_push_notification_messages' table:

   string(986) "CREATE TABLE IF NOT EXISTS  `civicrm_contact_push_notification_messages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `contact_id` int(10) unsigned NOT NULL,
  `message` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entity_table` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entity_id` int(11) DEFAULT NULL,
  `send_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `is_read` tinyint(4) DEFAULT '0',

How can I address this and get the extension installed?


texts: HELP! civiCRM Administration Area Not Showing! [Joomla 3.6.5] [civicrm 4.7.16]

texts: I'm using CiviCRM version 4.7.17 on Joomla version 3.65. I changed my civicrm resource URL hoping it would load the civicrm.css file but instead I can no longer access my administration area. Please see phone of what I am receiving when I try to access the civiCRM component. How do I get back to the system settings area so I can change it back?


texts: Transferring contacts from one CiviCRM installation to another

texts:
I have two different Civi installation on different servers. I want to move all contacts from one CRM to another one(to a new group). Total contacts are more than 15k. I have facing some error if I export more than 1000 contacts and the same thing on Import also If I tried to upload more than 1000 contacts getting 500 server error.

Please let know if there is any software available for transferring contacts.

_Ashwin


texts:
we are really new to CiviCRM and Drupal (and this forum). We're trying to setup an online member registration: we want an anonymous user to become a Drupal user filling a registration form with a membership payment. The user account will stay blocked until the payment is received.

We've read the membership documentation (also profiles and civimember sync) but we're still missing the general idea.

If anynone can shed some light on the workflow to achieve this or recommend a good reference, it would be great for us.

Thanks in advance!


texts: Where can I see previous Make It Happen campaigns?

texts:
Where can I see funded and / or implemented Make It Happen campaigns?

On the page https://civicrm.org/make-it-happen I can only see the ones that are currently being fundraised for.


texts: CiviCRM does not update status of PayPal Standard transactions after update to 5.27.2

texts:
Wordpress 5.4.2, CiviCRM 5.27.2
After updating CiviCRM to the latest version (5.27.2) CiviCRM stopped updating the status of contributions when payment is made using PayPal Standard payment procesor. The payment is processed correctly (money left contributor account and was received by the organisation), however the contribution in CiviCRM is still in Pending status and moreover the confirmation email was not sent to the contributor.
I've read the CiviCRM 5.26 and WordPress Important Notice and I understand that there are some changes in paths, but the page does not provide a clear guide on how to update the PayPal IPN settings. In the past I used just the domain name (https://example.com) for the Notification URL in and it worked without major issues. Now it appears to stooped working. I also tried to update the notification URL in line with the guidelines from Recurring Contributions and Webhooks using the updated path i.e. https://www.example.com/?civiwp=CiviCRM&q=civicrm/payment/ipn/1 but this also does not work.
Is this an issue with Civi/PayPal or am I missing something important?


texts: CiviMail doesn't save when using Checksum event links

texts:
Running CiviCRM 5.10.4 and Drupal 7.65.

Trying to send out a bulk email through CiviMail using a checksum link for an event registration.

However when I insert the checksum link, I get an error message when CiviMail tries to autosave, or when I try to manually save:

Sorry an error occurred and your information was not saved

This is the checksum link I'm trying to insert

https://DOMAIN.com/civicrm/event/register?reset=1&id=89&cid={contact.contact_id}&{contact.checksum}

I've also tried with:

https://DOMAIN.com/civicrm/event/register?reset=1&id=89&{contact.checksum}&cid={contact.contact_id}

Have tried testing to save with every move I make when making the email, and have isolated the issue to only happening when I try to use these links (whether it's an image linked to this URL, or text).

I've checked and that is the correct event ID in the URL. I've tried inserting the link in the source code and in the WYSIWYG editor but neither are allowing me to save. I've tried writing out the URL in notepad and copying over from there in case any formatting is being pulled through somehow, but again no luck.

Any idea on where we're going wrong or how to fix this?

Cheers

EDIT: On more investigation, it allows me to save the email when I use the following link. However this creates an extra "cs=" in the URL so the checksums don't work....

The URL I've used this time is:

https://DOMAIN.com/civicrm/event/register?reset=1&id=89&cid={contact.contact_id}&cs={contact.checksum}


texts:
Just wanted to share here in case anyone else can benefit from my experience.  I upgraded my civi drupal installation recently from Civi 4.2.6 to Civi LTS 4.4.19.   Somehow the setting for sharing drupal's wysiwyg editor got lost. I don't know if that's a problem with the installation, or if there was some unique problem on my system.  In any case, once I figured out what was going on, I just had to reset as per http://wiki.civicrm.org/confluence/display/CRMDOC/Configuring+CiviCRM+to+Use+the+Default+Drupal+Editor.

Also, FYI I see here that this setting is going away unless someone builds an extension.  https://civicrm.org/blogs/colemanw/big-changes-wysiwyg-editing-47


texts: How to include validation fields to find user for a contribution page to avoid duplicate?

texts:
Although we have taken many different approaches, it was always been an issue with duplicated contact records.

What I thought is, if I could include few fields like

First Name
Last Name
Email
Post Code

and once that anonymous user fills in those fields mentioned above, CiviCRM would look for matching contact and prefills the details for a contribution page.

Is it something possible to achieve? Anyone have any suggestions, please? Thanks


texts: Contacts not appearing on mailing labels

texts:
Have a strange situation where 2000 contacts have been imported with address details. The addresses look fine but when you create a mailing label neither the contacts nor the addresses chosen appear. But when you go and edit/save the contact that contact does then appear on the mailing label, V strange.

I've tried clearing caches and I also though the scheduled job 'Update Greetings and Addresses' may be connected but this made no difference. Something happens when you save the contact but I can't see what it is.

Olly


texts: How to successfully install CiviCRM w/Wordpress on WPEngine hosting

texts:
I've seen other questions indicating CiviCRM will not install properly on WPEngine, at least not without some extra work, such as: Install problem civicrm with wordpress

The installer says it was successful, but no menu appears and no links work.

I haven't been able to find out what exactly needs to be done to make it work, in case anyone knows.  It appears perhaps WPEngine changes where files are placed or permissions or something like that. They are very restrictive and will often delete plugins without asking us. (I do actually have a lot of years experience with web applications including Wordpress & Drupal, but in this case my hands are tied due to IT)

I just would like to know so that I can relay this info to my IT department which controls all access and communication with WPEngine (and picked them for all Wordpress hosting).
Thanks for any help with this.


texts: Security Configuration and Programming Guidance

texts:
I'm a security person. I have a non-profit that wants to use CiviCRM. What are the nitty-gritty details that I need to know? I will handle the hard technical stuff for them. The only information of value they  are trying to protect is user real name and email address. But, they are considered very sensitive and high value. No money is exchanged with users. Their activity history is not considered sensitive, just the fact they are associated with the site. There will be millions of users and high site visibility.

Thank You


texts: Has anyone come across a plugin/extension/hook that adds an upload image ability to events "Info and Settings" tab (or a separate tab)?


texts:
I volunteer with a small non-profit and we recently decided to create a new CRM using CiviCRM. I am a complete novice with this and am learning it all from scratch - really appreciating the community and all the help on offer.
As we are planning out the work I am struggling to come up with a rough estimate for how long it will take and was hoping someone could advise. I realise this is a bit 'how long is a piece of string' but it would be good to hear from peoples' experiences how long similar-ish projects can take, either in hours or days for different stages.
We currently have around 300 members and we are planning to start off with a fairly simple CRM focussing on membership management. The key features/aims are:

Integrated with our Wordpress website (currently using shared hosting but may move to cloud).
Securely hold very basic member data; provisionally names, email, region, membership subscription amount, and have some basic tags.
Contact groups, with some groups having access to specific pages on our website (e.g. 'members' have more access than 'supporters').
Automated updating of the database when members join, leave etc.
Connected with a payment processor.
Automated emails following certain triggers e.g. lapsed payments.
Ability to set up events, invite different contact groups, and record attendees.
Email and event templates.

If I have said anything that doesn't make sense please let me know! Here to learn.
Many thanks,
Nick Sharma


texts: private notes: how to restrict visibility to a certain group?

texts:
private notes is very  usefull , but I miss the functionality to restrict visibility to a group of users.
Is there a way to realise this in civicrm or is it necessary to make a new extension?


texts: Event Registration - Pending (Pay Later) - Cannot add payment

texts:
Example of issue:

Website user registers for event - chooses pay later option.

User makes payment via cash or other method at event.

Site administrator tries to change status to Completed and record payment.

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

Replicated in Drupal DMaster

Via log:

[info] $backTrace = #0 /home/columbiaccs/www/www/sites/all/modules/civicrm/CRM/Core/Error.php(381): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/columbiaccs/www/www/sites/all/modules/civicrm/CRM/Contribute/Form/AdditionalPayment.php(121): CRM_Core_Error::fatal("No payment information found for this record")
#2 /home/columbiaccs/www/www/sites/all/modules/civicrm/CRM/Core/Form.php(585): CRM_Contribute_Form_AdditionalPayment->preProcess()
#3 /home/columbiaccs/www/www/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(92): CRM_Core_Form->buildForm()
#4 /home/columbiaccs/www/www/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Contribute_Form_AdditionalPayment), "display")
#5 /home/columbiaccs/www/www/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contribute_Form_AdditionalPayment), "display")
#6 /home/columbiaccs/www/www/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("display")
#7 /home/columbiaccs/www/www/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(113): CRM_Core_Controller->run()
#8 /home/columbiaccs/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(282): CRM_Utils_Wrapper->run("CRM_Contribute_Form_AdditionalPayment", "New Payment", (Array:0))
#9 /home/columbiaccs/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:16))
#10 /home/columbiaccs/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:2))
#11 /home/columbiaccs/www/www/sites/all/modules/civicrm/drupal/civicrm.module(445): CRM_Core_Invoke::invoke((Array:2))
#12 /home/columbiaccs/www/www/includes/menu.inc(527): civicrm_invoke("payment")
#13 /home/columbiaccs/www/www/index.php(21): menu_execute_active_handler()
#14 {main}

and

 [info] $Fatal Error Details = Array
(
    [message] => No payment information found for this record
    [code] =>
)


texts: Problem : Adding not existing contacts to organisations

texts:
When i open the sheet of organisation in civicrm then i want to add relationship with another contact civi propose only existing contact.
is there way to add new contact in this relationship using the same screen 'add relationship' without using "add new person" in navigation bar?


texts: DB Error: Contribution Page Uknown column 'pledge_start_date' in 'field list'

texts:
I have a contribution page that is set as the self-service page for pledges. When you click on the Make a Payment from the Contact Dashboard the following error occurs.

Database Error Code: Unknown column 'pledge_start_date' in 'field list', 1054
Additional Details:

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

[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => SELECT  id ,  status_id,scheduled_date,scheduled_amount,currency,pledge_start_date

FROM civicrm_pledge_payment

WHERE (  civicrm_pledge_payment.pledge_id = 6 )

[nativecode=1054 ** Unknown column 'pledge_start_date' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT  id ,  status_id,scheduled_date,scheduled_amount,currency,pledge_start_date
 FROM civicrm_pledge_payment

WHERE (  civicrm_pledge_payment.pledge_id = 6 )

[nativecode=1054 ** Unknown column 'pledge_start_date' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT  id ,  status_id,scheduled_date,scheduled_amount,currency,pledge_start_date
 FROM civicrm_pledge_payment

WHERE (  civicrm_pledge_payment.pledge_id = 6 )

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


texts: How do I prevent blank fields on a profile from overwriting existing data when using the profile to register or donations from existing contacts?

texts:
I've setup a contribution page and made a link to it.  I include a profile that includes things like address.  The matching is set to update.  If someone who already in civi goes to the donate page and only fills in the name and email address, leaving the street address blank, it will match and then null out the address that was there.

I'd like it to only update the fields if the user enters something in the field.

I don't really want to give everyone a drupal login and make them login first.  We want to make donating as easy as possible.

We're using paypal so a lazy person who knows that and that they'll login to their paypal account and that it will pull up their address info, won't bother to enter it on the donate page.  Interesting, if they do that either paypal doesn't send back the address info or civi doesn't do anything with it.

civicrm 4.5.8 (testing 4.6.11)


texts: I was wondering if anyone would mind sharing some screen shots of your setup of CiviCase to track donor and/or grant interactions. The only samples I can seem to find are affiliated with more traditional case management. I have been reading a lot of different threads but I feel like I am missing a piece of the puzzle, and cannot seem to find a guide specific to these areas for setup. And image should help, unless you know where a guide specific to this can be found. Thanks!


texts:
Wordpress with CiviCRM 5.3.2

Good Day!

we are developing custom payment gateway for civicrm.
  in Payment Processor Settings  we need to create a login screen to get our
  gateway account details instead of "Processor Details for Live Payments" settings using different form elements is there anyway to develop .

Thanks a lot for any suggestion or help .


texts: Advanced Search gives different dataset than same search in Reports

texts:
When I use the Advanced Search or Search Builder to select a dataset the returned contacts are correct. If I do the same search using in CiviReport with the same search criteria one contact is displayed twice. If from the advanced search I create a smart group the group contains the correct number of contacts. If I then use CiviReport and search using the smart group one of the contacts is shown twice.

I have looked at the database to see if I can understand what might be causing this without success. It is possible that it has happened after merging the erroneous contact but I am not certain.


texts: Is there a way to find out why an email address is 'on hold'?

texts:
I'm currently going through our system and there is a lot of emails that have been put on hold, is there a way to find out or is there a list somewhere on the database as to why each one is specifically on hold  (i.e. email is not active or security issues)? I'm currently having to go through one by one which is necessary but time consuming.

Any help would be appreciated.


texts: How to use Smarty for change greetings for French?

texts:
I need to adapt Greetings in order to fit to French (which has a feminine and masculine for "Dear").
I read on the forum that I should use Smarty and read the short documentation (CiviCRM documentation) but I haven't understood how to use it :(

Where should the following code come (once adapted of course)? In the email source or in the greetings settings?

{capture assign=first_name}{contact.first_name}{/capture}
Dear {$first_name|default:Friend},
{if $first_name}
  Hello, {$first_name}, how are you?
{/if}

My second question is where do I set something like:

WHEN contact_gender IS female THEN contact_greeting IS Chère

Do I have to create any custom fields?

Any help will be very appreciated :)


texts: Is the new CiviCRM menu bar broken when using the Edge browser?

texts:
I was providing a bit of support to a user yesterday who was struggling with how to do something in Civi (5.13.1). When they shared their screen with it became immediately apparent why. They were using Edge as their browser, and the menu bar in Civi simply wasn't appearing for them. We could not see anything obvious in their browser console that might have caused this.
They are working round the issue using Firefox.


texts: How do I find the number of our association's members at the end of each calendar year?

texts: I'm using Reports, Membership Reports, Membership Summary.  In the filter section it seems to require "Member


texts: I want to show how many spots we have left in an event, but it takes like 20 seconds to get the number of participants using the getCount action. What else can I do to get that number?


texts: Newsletter sign up tokens on Donation Form Error

texts: We are having an issue passing a check-sum from a donation and membership sign up form along with a token to sign up to join a mailing list.  We're implementing CiviCRM on a WordPress platform. The newsletter mailing list sign up token is not recognized by the system.


texts: Relationship Type "name" as Drupal [Rules] Token in Civicrm Entity module

texts:
Is it possible to retrieve Relationship Type Name in addition to an ID as Rules Token  in Drupal 7? It would add some value to "Create/Edit Relationship" Rules action: we could use it in emails, like "Hello mr. Dow, congrats, you're Organizaton Boss of The Company now" instead of "Mr. Dow, you are [Relationship ID] of The Company". I'd like to provide a patch for civicrm_entity but not sure where to start from. Any advise, please?

Cross-posted here: https://www.drupal.org/project/civicrm_entity/issues/2986112


texts: Why does the mailer processQueue method 'shuffle' the array of possible locks?

texts:
https://github.com/civicrm/civicrm-core/blob/a2976e7c0c2515379e98ee9b5ebcf51acde4e540/CRM/Mailing/BAO/Mailing.php#L2867

  $lockArray = range(1, $mailerJobsMax);
  shuffle($lockArray);

  // check if we are using global locks
  foreach ($lockArray as $lockID) {
    $cronLock = Civi::lockManager()->acquire("worker.mailing.send.{$lockID}");
    if ($cronLock->isAcquired()) {
      $gotCronLock = TRUE;
      break;
    }
  }

Why do we randomise the order of the array using shuffle()? Is there a good reason for doing this?


texts: Extending "get" action with custom WHERE clause

texts:
Is it possible to define a new api (v3) endpoint which has a specific WHERE clause but that still leverages the flexibility of the "get" action in terms of defining parameters, options, pagination, chained api calls etc?

What I'm trying to achieve is to define an endpoint that returns all records that match a WHERE clause which looks something like this

(entity.field1 = 1 AND entity.field2 = 'a') OR
(entity.field1 = 2 AND entity.field2 = 'b') OR
(entity.field1 = 3 AND entity.field2 = 'c')"

but at the same time I still want the endpoint to be able to accept all the parameters and options that the "get" options accept, because a consumer of this endpoint would want to further filter the records or to sort them, paginate them, etc.

It doesn't seem that the built-in actions have support for OR clauses, so this endpoint would have to be a mix of api methods and a manually built SQL query (if it's even possible?)


texts: Problem with new Pay Later contributions showing as Completed

texts:
I'm a very new CiviCRm user. And pretty new to WordPress so I apologise if this is a user error. I'm doing suitability testing.

WordPress 4.8

CiviCRM 4.7.20

I have created a Contribution page to take memberships. I believe I've selected the options I need for membership types and pricing.

At the moment, I ONLY have a Pay Later option. I haven't tried yet with PayPal or similar.

So in my test I create a new user, put in the information needed. And submit it.

I then go and find that user, and look at the relevant contribution. It shows as completed, not pending.

Obviously this is incorrect.

Any thoughts on what I'm doing wrong?

Thanks,
Norman


texts:
I do not have a web development background, so you will have to bear with me. I am currently using CiviCRM 4.7.0 on Wordpress 4.9.2. I am trying to set up CiviMail and am receiving a "Mail Not Sent" error. We are currently using Webfactional to host our Wordpress site. I had previously been receiving a softfail when using mail(). This is the softfail that I would see in "Show Original" on Gmail:

Received-SPF: softfail (google.com: domain of transitioning our email does not designate 74.55.86.74 as permitted sender) client-ip=74.55.86.74;
Authentication-Results: mx.google.com;
       spf=softfail (google.com: domain of transitioning our email does not designate 74.55.86.74 as permitted sender) smtp.mailfrom=our email

I contacted them and followed instructions to set it up so that our Email would not be using their smtp but rather, go through Google Apps since Webfactional sets limitations on bulk mailings. I also set up an SFP DNS following their instructions for Google Apps. Following the instructions on Google Apps, I entered the following and received this error message when I tried a test email:

I tried removing the ssl:// and also tried to use Port 25 just for the sake of testing. I don't quite know where to head from here. What steps did I just completely miss or do wrong that I'm not seeing?

Thanks in advance!


texts:
When we look at the household member is and pull up a record, it shows the household member last name twice, eg Bartlett,Bartlett. However when you click on this it shows the proper name, eg Peter Barlett.

Any ideas


texts: Mosaico Toolbar Editor - how do we get file upload?

texts:
On the latest and greatest of Civi and Mosaico, I installed this extension: https://github.com/ginkgostreet/com.ginkgostreet.mosaicotoolbarconfig

However, what plugin and toolbar control would get us access to the file upload dialog in the classic Civimail editor? (KCFinder)

For some background, we can utilize the Mosaico gallery, but we'd like access to our actual file structures so we can utilize all the work we put into the original Civimail


texts: Is it possible to set a sophisticated price set for events, like in this example?

texts:
I am trying to facilitate a event but price sets are bit complicated, just wondering if anyone can give a clue how to sort it out please?

The "Early bird" pricing structure:

Single person -£285 pp

Couples - £240 pp

Family with kids - £220 pp (kids free under 2; £100 2-4yrs; £150 4-11yrs; over 12 £220)

We will be asking for 50% deposit upfront to secure their place and the remainder 50% within one month

Complication I am facing to give option for 50% deposit. Is it possible to do in civicrm 4.6.12?


texts:
Working on a site that does regular classes with different teachers. The teacher bios are stored as pages in WordPress (could be moved to posts). We are looking for a way drop the bios into the event descriptions so when a new event is setup the bios can be part of the description. The site is in WordPress 4.7 & CiviCRM 4.6.

I have looked at a couple plugins (Insert Pages, Display-Posts) that allow you to drop content into other pages in WordPress but they don't seem to work in the CiviEvent Description field.

Thanks in advance for any ideas.


texts:
I'm new to CiviCRM and just installed it (v. 4.7.17) on Wordpress 4.7.3

When I access the tag management page (wp-admin/admin.php?page=CiviCRM&q=civicrm%2Ftag&reset=1), I get a DB Error + a display bug.

Error is

Expression #12 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'civicrm.child.id' which is not functionnally dependent on columns in GROUP BY clause ; this is incompatible with sql_mode=only_full_group_by, 1055

And debug info is in the image attached.

Does anybody know how to sort this out?

thanks

Thomas


texts: How to make links in email direct and non-trackable

texts:
We are sending emails containing links which are redirecting through civi. We need them to go direct to the website. (Our civi is not public facing). All articles / questions i have seen are about making urls trackable, we need the opposite.
Any link added to a message template is creating a url that runs through our server. This happens regardless of how email is sent, single email, bulk email etc.
What am I doing wrong?


texts: Not all extensions appear in Add New list

texts:
I want to install an extension in Joomla 3.5.1 (CiviCRM 4.6.15, Php 5.6.19, Linux, been using CiviCRM for several years, continuous upgrading).

But, the extension isn't appearing for me ("SPARKPOST / CIVICRM INTEGRATION 1.3.1"). I've refreshed, waited a day and refreshed again, but it doesn't appear. It's been released for more than two months, although the most recent version is from beginning of April.

I don't know what else to try. I would like to avoid manually downloading and installing the extension, because I'm concerned that it wouldn't show future updates if it's not showing the actual released version.

Many extensions are listed under the Add New list of extensions, but some newer ones (as far as I can tell) are not, although they're listed as available on CiviCRM.(https://civicrm.org/extension-civicrm-compatibility/civicrm-46)

Two of the missing items, for example: "SPARKPOST EMAIL EXTENSION FOR CIVICRM 1.0" and "SPARKPOST / CIVICRM INTEGRATION 1.3.1".

Another one (with a more recent release date than the two above "OUTBOUND DOMAIN ENFORCEMENT VERSION 1.4" IS listed on my "New Extensions" tab, so it's not just a date thing.


texts:
I am evaluating Civi currently using WAMPServer with Wordpress (which our website is built on). Civi creates a webpage as a front end for things like showing event information and registration etc.

While the idea is to have Civi as a plugin on the back end of our website and be therefore attached to it, we don't necessarily want any event information being displayed on the website. Rather, the CRM would just be used to manage and track that information and we would manage the registration etc. internally (At least for now).

My question then is; does the webpage content have to be visible to the end user or can it be hidden and Civi be used purely as a backend system? Subsequently, what are (if any) the security risks of having this auto-generated page dishing out potentially confidential information.

Total noob to Wordpress and Civi so apologies in advance.


texts: RECURRING contribution and auto-renew membership

texts:
I am trying to setup an optional but recurring donation/contribution on a membership signup Contribution Page. Ideally, the new member will also have an option to choose frequency of payment, but we can do without.

I have tried price sets with a second membership for a "dummy" organisation for the donation bit, but it doesn't seem to give me an option for BOTH to be recurring.

I have also tried activating membership contribution and Contributions Amount on the campaign page, (without price sets) but as soon as I activate recurring contributions, I get the following error:

When I then enable separate payments from the membership tab, I get the error

  You cannot enable both Recurring Contributions and Auto-renew memberships on the same online contribution page.

Has anyone got a workaround? Any help and guidance towards the right direction is much appreciated.


texts: We need to remove subject from case dashboard. we don't know where to change whether in report or in drupal. can any one please help on this.


texts: How to build reports or Views based on who the Manager is

texts:
We need some summary reports of Count of open Cases by Case Manager.

Maybe overlooking something but not spotting these.

Just getting to grips with how Case Manager is identified. Seems to initially be the person who 'creates' the case, until that gets reset at which point an Activity of Type "Assign Case Role" is created and the Manager is the assignee, status Completed.

But if the Manager is changed, it just adds another one. So trying to report eg in Views, by grabbing the Activity of that type/status gives multiple results.

Wondering which way to go around this.

Keen to hear ideas for flexible approaches that might be useful to others.

Seems I had forgotten about using the Case Manager Relationship as an option!


texts:
I'm trying to import some contribution information from our payment processor and need to specify a "financial type" for the Civi Contribution (A mandatory field).

Unfortunately, this information isn't contained in the exported data. Is there any way to hard code the value that I would like to use for all imports?

I'm thinking I'll have to pre-process the exported data to add the field, but if there is a better way to do this in Civi, that would be amazing.

Thanks!
Trev


texts: first click to reach CiviCRM dashboard results in long delay and error message

texts:
I am managing a Drupal site and when I first log in and click CiviCRM menu link, there is a long delay followed by this message:

  Service Temporarily Unavailable
  The server is temporarily unable to service your request due to maintenance downtime or capacity problems.
  Please try again later.

I have increased the PHP max execution time, and it did help to eliminate this message, but the message is happening again.  I also increased the memory limit to huge.

Can someone tell me how to set some debugging or logging to show me what exactly CiviCRM is doing during this delay?

Drupal 7.5.2.  MySQL 5.5.52-MariaDB.  PHP 5.6.30 as FPM.  CiviCRM 4.7.16.

thanks!


texts: Error when trying to connect to civicrm from gmail using civigmail chrome extension by vedaconsulting: Error unsupported response type

texts:
I am having trouble getting the civicrm gmail chrome extension to work. I am using the intructions here https://vedaconsulting.co.uk/civigmail-chrome-extension. When I click on the "connect civi" button that is added to my gmail page I get an oauth login page for my site but after entering in the correct information the following error flashes across the top of my screen.

CiviCRM 4.7.17
Civicrm ext: Gmailapi 1.0-alpha1
Chrome: 57.0.2987.133
Chrome ext: CiviGmail 0.2.1

Error message

error: unsupported response type
error description: implicit grant type not supported
state: null

Any help on this would be appreciated

Regards
Steven


texts: Why are duplicate activities being created?

texts: I have a client who has noticed that some activities that they create are being duplicated. I can see solid evidence of exact duplicates - apart from the id in the activity record.  In the activity table the 2 ids are consecutive, in the activity_contact table they are almost consecutive. The contents of the activity records are exactly the same - the created_date and modified_date are the same time to the second.  The client creates a lot of activities - there are about 220K activity rows and they do have quite a few users working simultaneously updating Civi.  This seems like a bug to me - any suggestions as to what else the problem might be?  This installation is running 5.13.5 with Drupal 7.67


texts: Errors encountered after installation of CiviCRM [BackdropCMS]

texts:
This is an updated version of my question here.
CiviCRM v5.28.3; Backdrop v1.16.2; Shared hosting at TSO Host (UK shared hosting)
Fresh install of both Backdrop and CiviCRM. Does not show Civi menu, or components, though I can use the Configuration Checklist and access admin/configuration items, e.g. [mysite]/civicrm/admin/setting/path?reset=1 via [mysite]/civicrm/admin?reset=1
Browser console shows multiple 404 errors (looks similar to this issue) - cannot find css and .js files in modules/civicrm/bower_components/etc and modules/civicrm/packages/etc
PLUS:
Unchecked lastError value: DataCloneError: The object could not be cloned. iframe.js:166
sendToBackground moz-extension://dc8100d9-67e7-024b-ad27-a312c52806be/js/lib/iframe.js:166
and:
Unchecked lastError value: Error: No matching message handler network.js:66
getFrame moz-extension://dc8100d9-67e7-024b-ad27-a312c52806be/js/lib/network.js:66
I am experimenting with Resource URLs, but any other thoughs most welcome.


texts: Three self-canceling financial transactions for a single recurring contribution?

texts:
For recurring contributions, I am getting unusual results in the civicrm_financial_trxn table. Three very similar entries are created for each contribution, two of which cancel one another out.

Am I failing to grasp something about double-entry accounting, or are two of these records simply unnecessary?

Or perhaps my financial types are configured to do weird things. Perhaps there should be three entries, but at least one account code other than 1150 and 455-11 should be in play. If this is the case, how do I go about identifying the culprit financial account?

Below is a screenshot from the Bookkeeping Transactions Report:

Some notes:

It's probably not sensitive, but I've changed the transaction number out of an abundance of caution. Note that the original number was the same for all three rows.
Note that the first and second rows cancel one another out (the amount in the second row is negative).
Note that the payment method is blank for the third row.

Below is a screenshot of the civicrm_entity_financial_trxn entities that feed into the report:

Possibly of note:

There is a four-second delay between the first record and the other two.

System Details:
CiviCRM verion: 4.7.29
CMS: Drupal... ahem... 6
Payment processor: Authorize.net


texts:
I am importing 955 contacts and assigning them a tag or a group (or both).  Time estimate showing is 20 minutes.
During the import the connection times out.
After waiting a long while, I go back to CiviCRM and look at the group or tag and see that they now have 955 contacts listed whereas before the import both were 0.

A) How can I quickly see if the import was successfully finished?
B) Is adding the contacts to a group or tag one of the last steps for the import process?
C) If the contacts are now listed in the previously empty group or tag, does that indicate that the import was successful?


texts: Does the system status check and upgrade version check only list available updates for in-app extensions?

texts:
It seems like extensions which are listed in the extension directory but not available for in-app distribution are not included in update checks. They also don't appear in the sites/default/files/civicrm/upload/cache/extensions.json file which seems to be the list of available updates it retrieves. I've run the version update job and "refresh" button on the extensions page manually and can see it downloads a new one.
So for example on the status page it says all extensions are up to date but I know they are not.
Is this a local config issue or is this just how it works?


texts: Joomla 2 CiviCRM User Sync: synching Community Builder multi-value custom fields?

texts:
looking for some suggestions on best practice implementation for synching external data to CiviCRM custom data.
I'm using the Joomla 2 CiviCRM User Sync plugin to sync my Joomla 3.9.24 user registration data from Community Builder to CiviCRM 5.33.2.  That works great for basic name/username/email, but I have a couple of custom Community Builder fields I'd also like to sync to the CiviCRM records.
Community Builder includes a plugin to execute an SQL query via CB action hooks, and that works great for updating CiviCRM fields with simple data types (varchar, integer).  But I have one multi-select CB custom field stored as a text field with separators, which needs to go into a Civi multi-select custom field.  I know CiviCRM has a special "TEXT_SEPARATOR" variable that it uses storing multi-value text strings in its database, but I can't figure out 1) what that character is and 2) how I can write it into my SQL.
So:  is it even possible to write external SQL to do this? Or is there an API call or other programmatic way I should go about doing these Civi custom field updates?
Thanks!
System deets:  Joomla 3.9.24, Community Builder 2.5.0, CiviCRM 5.33.2, Joomla 2 CiviCRM User Sync 2.1.0  (https://civicrm.org/extensions/joomla-2-civicrm-user-synchronization)


texts: CiviVisualize example graphs and visuals are not showing up

texts: I have a question about CiviVisualize. So, I cloned the CiviVisualize repo from github in my C:\wamp64\www\drupal\custom_ext\CiviCRM Extensions Directory and then reran drupal. CiviVisualize comes up but the demo visuals are no where to be found. I'd love some help]1


texts:
After upgrading CiviCRM on Drupal 7 to 5.22.1 (from 5.21), the system status page says:

  The site is running 5.21.0. Additional patches are available:

  5.21.1 (2020-01-10): Fix recent regressions involving "Enable multiple bulk emails" and "Payment Summary" table.
  5.21.2 (2020-01-23): Fix recent regressions involving contact date-filters, certain receipts, certain smart-groups, and localized installation."

An attempt to run the database upgrade again returns the error: The database has already been updated to 5.22.1.

Does this mean the upgrade did not succeed? If it did, how can the system status page be updated?

Help will be greatly appreciated.


texts: Can't Remove CiviCrm Membership Type From Being Visible Publicly

texts:
I tried disabling, making visibility admin only, and then finally deleting a specific CiviCrm Membership Type, but still can't remove it from being seen publicly on Contribution Page. Anyone know what is causing this and how to fix it?

FYI I was able to edit other membership types and those changes became visible.

Using Wordpress 4.6.1
Using CiviCrm 4.7.7

Thank you!


texts: I'm interested in setting up a 3-month sustainer option — one gift each month for October, November and December. Is it possible to configure CiviCRM to do this? Or, if that's not possible, could I configure it to set donors up as monthly givers, but automatically cancel after the third gift?


texts: CiviCRM Smart Group Based on Contact's Drupal Role

texts:
I need all users of a particular Drupal role to be added to a CiviCRM Smart Group. (All Drupal users are currently also CiviCRM contacts.)

The site uses CiviCRM 4.4.21 and Drupal 7.56


texts: How to change or overwrite block reportlets created by ExtendedReports (reportlets)

texts: I can't work out how to change the block/extended report once created, that I then use in the Contact Layout Editor, as overwriting it with the same name just made another block appear with the same name.


texts:
I'm helping a nonprofit set up membership invoicing. They want to create invoices for the current members. They do not want to use automatic reminders -- they want to choose who they send the invoices to, and when. Additionally, they'll want to send individual reminders to those members who haven't paid.

We've created a Message Template and included personalization tokens for name, organization, etc... but don't see any way to include the due date, membership name and amount due. We know we can include checksum links to a contribution page, but many of their members are brick-and-mortar companies, and they need to print a page and carry it to their accounting departments...

Isn't there some way to generate a simple invoice? Something like "Dear Joe, your membership will end soon. To renew, please remit payment of $150.00 by January 31, 2016."

Thanks in advance, and apologies for noobiness.


texts:
Seems that IATS will not work using extension 1.5.3 - It logs the transaction in CiviCRM but never makes a connection with IATS. I'm not sure it is even connecting with the network.

Any clue folks?


texts: Is smart/fuzzy searching possible in CiviCRM?

texts:
I'm not sure what the feature is called, but Google seems to collapse all accented letters to their base character when indexing. So a search for "Nandor" will find a record "Nándor". But searching my Civi database for the unaccented name finds no results.
Is there a setting (either in CiviCRM or MySQL) or a plugin that would make such searches work?


texts:
Can anyone assist with the following scenario please...

Our organisation conducts training events, the fees for which are calculated at a fixed price per trainer - not by the number of students that attend. So regardless of whether or not 10 or 25 students attend, the fee is the same, which is actually not paid by the students themselves but rather a 3rd party organisation after the event is completed.

It may be worth noting that we are using CiviCRM as more of a historical database as opposed to a online registration/payment system, and generally all data (contacts and event) will be entered manually after an event takes place.

As I am typing this I am thinking that perhaps a manual (gulp!) workaround is to just divide the event fee by the actual number of students that attended the event and set this as the event amount when the data entry is taking place....?

So I'm not sure how best to configure an event to allow for $0 to be paid by the student, but I'd like to see a $ value for the overall event a summary report somehow.

Make sense? Is this possible to do?

Thanks, Joe.


texts: Unable to add Event Participants backend

texts:
I am trying to add event participants back end through Events->Register Event participants. I am getting this error,

"Profile search, view and edit are not supported for Profiles which include fields for more than one record type." Civicrm version 4.6.8.

There are two profile fields configured in the event with fields of type 'individual' and 'contact'.

Any help can be appreciated. Thanks in advance.


texts: Open tracking for long emails isn't triggered in Gmail as the tracking image is at the bottom of the message

texts:
With Mosaico templates, it isn't that difficult to reach Gmail's limit of 102kB with an email newsletter, after which your email message is clipped and not displayed in full. This is unfortunate in itself, but it also breaks open tracking as the tracking pixel is only embedded at the very end of the message and thus isn't fetched unless you open the reader clicks "View entire message".
Would it risk too much ugliness for those who don't display images to put the tracking pixel at the start of the message?


texts: Different one time contribution and recurring contribution on same contribution page

texts:
I know we can create a contribution page with a single amount and the user can choose to make it a one time payment or a recurring payment.

But... is it possible to have a one time contribution of, say, $50, and a recurring contribution of only $10 on the same contribution page?


texts: Is there a way to put CiviCRM in read-only mode or deactivate forms programmatically?

texts:
I have recently set up our website so that I can put it in read-only mode (using the Read Only Mode module) when doing maintenance, such as upgrades and code pulls, however, this is a Drupal function only and I noticed that while in read-only mode, CiviCRM front-facing forms, such as CiviContribute forms, as well as backend functions are still available.

Is there a way to either put CiviCRM into read-only mode or turn off/deactivate the CiviContribute forms? I have written a bash script that runs all my update/upgrade processes and would like to find a way to do this using drush. For staff, I'm thinking of just deactivating the link to CiviCRM in the administrative menu, but I am most concerned with making sure users can't process transactions and write to the database during down-time.

I'm on CiviCRM 5.1.0 and Drupal 7.59


texts: Error with recording membership payment offline

texts:
Is anyone aware of any issue with trying to record a membership payment offline?
WE are running CiviCRM 4.7.11

Click on and existing Membership and edit membership.

Click on the checkbox that says Record Membership Payment.
None of the fields  to record the membership payment are being displayed such as amount, financial type etc.

If you then click on the Send Confirmation and Receipt checkbox,
 and then click 'Save' it of course gives an error saying Please enter the financial Type.

Not sure what is going on as we have not come across this issue before

Update:Just checked with Civihosting and they have confirmed its a bug.
Has anyone got a fix for this?


texts: I imported certain contact records. Somehow Civicrm filled the country field with country data of its choice for certain records. Now I would like to edit those records. I have exported the records along with contact ID, edited the country field. But while importing there should be a contact ID field for matching to contact. It is not available. So how should I fix this error? how I go about?


texts: Report of activities with sums on custom fields

texts:
I am quite new to CiviCRM but I have programming skills with Drupal so I am looking for a best practice for our needs - and if programming is needed I would appreciate any links / information / hint how ro so that well in CiviCRM.
We have some custom fields on activities where we store some data like campaigns (this data is stored in three simple text fields where campaign names are saved - it has nothing to do with Civi) and for newsletter unsubscriptions we store the reasons why people unsubscribe (this is stored in Activity details field).
What we now need is a report showing us the sums of Activities gained by campaigns and unsubscription reasons. For that Civi need to sum up the Activities of the current month by the values in the fields.
In short: we need a list of the values stored in a period in a custom field of the activities with the sum of activities which have this value in the corresponding field.


texts:
I am importing CSV files, about 7000 contacts per import, about 20 fields per contact, about 800kb sile size.  DB size is about 55k, issue arose at about 20k.  Since then, it times out after 2000ish records.  The importation ultimately executes with fields and data appearing to correctly function thus far through testing.

Issue is the importation process freezes.  It seems to run about 4 to 5 minutes, then apparently times out.  Server demonstrates mysql processes, usually about 6-10, in sleep state when "time out" occurs.  Checking table in phpmyadmin, I can quickly see where to edit csv file to continue.

I am not deduping, though I am validating address data.  I suspect the address validation is causing the issue.   Does the USPS address validator have a "counter" on it that is now limiting my "per day/then/per session" usage?

I verified the processor, free memory, file size, etc are all way under utilized.

Rememdy is kill all user/application processes, repair database and continue forward.

But, if I can adjust a setting to enable better processing, without sacrificing security, pls share.

Thx


texts: Is is possible to create localised custom fields? For Swiss client I need to set up a custom field with the contact's profession. There are three official languages in Switzerland and we would like to show the professions in the preferred language of the administrator. Is this possible with CiviCRM 4.6 (LTS). Also for sign-up the exposed custom fields would need to be localised.


texts: Migrating CiviCrm to WordPress CMS from Drupal

texts:
The wiki guide doesn't work. I ran into issues concerning moving the civi contacts...ie Drupal users. This is obviously very very crucially needed. I have over 5000 thus I cannot move forward. I was told to write a new question. So here it is. If anyone has tried this and had it fail... Please help

Update: Being that this is complicated and likely several glitches will arise after trying this again... I've opted never to do this. It's too risky and I'll lose historical information back to 2012. I'm unwilling. Seems not many successfully do this or is see much more on Stack exchange


texts: I have a view that displays civiCRM contact records according to Contact Type. The displays needs to change every Fall, and the way we do this is by changing the contact type (but keeping the record).  There is a particular contact record, however, that displays on the view but is missing from our civicrm records. I have looked under his name, email, and contact id, but nothing comes up. This should not be possible: the view displays the contact record's name, bio, university, and image. So how is this person's record displaying if I cannot find him in a search?


texts: After 4.7 Upgrade Contact Pages Throwing Error

texts:
The following error's are throwing at the top of each personal contact pages. It does not show these errors on an orgs contact page. I would appreciate any feedback.

Thank you!

Erin

detects parameter 1 to be array, null given in /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php on line 1037

Warning: array_keys() expects parameter 1 to be array, null given in /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php on line 1037

Warning: array_keys() expects parameter 1 to be array, null given in /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php on line 1037

Warning: array_keys() expects parameter 1 to be array, null given in /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php on line 1037

Warning: array_keys() expects parameter 1 to be array, null given in /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php on line 1037

Warning: array_keys() expects parameter 1 to be array, null given in /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php on line 1037

Warning: array_keys() expects parameter 1 to be array, null given in /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php on line 1037

Warning: array_keys() expects parameter 1 to be array, null given in /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php on line 1037

Warning: array_keys() expects parameter 1 to be array, null given in /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php on line 1037

Warning: array_keys() expects parameter 1 to be array, null given in /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php on line 1037

Warning: Cannot modify header information - headers already sent by (output started at /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php:1037) in /home/connectionsvol/public_html/civicrm/wp-includes/option.php on line 820

Warning: Cannot modify header information - headers already sent by (output started at /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php:1037) in /home/connectionsvol/public_html/civicrm/wp-includes/option.php on line 821


texts: How do I get my contribution form fields on the same line

texts: I have bootstrap Joomla theme and it is changing the format of form fields. I understand that this is a CSS issue but my question is how can I get my live contribution page to look like the test page within civicrm?


texts: Users with Subscriber role in Wordpress cannot see & access CiviCRM

texts:
Users connected with the "subscriber" role in WordPress do not see CiviCRM nor access to it (404 error). It works well with WP admin role.
I believe I have configured correctly the permissions in Administer -> Users & Permissions -> WordPress Access Control.
Any ideas? Many thanks


texts: How do I create a Drupal View to display last activity date.

texts:
I'm trying to set up a View of Clients, Case Managers and date of last activity.  Most of the clients have many activities, but I only want the most recent one displayed.

Normally, I would use the Multiple Field Settings in Drupal Views, but it isn't an option for the CiviCRM Activity Date or Activity ID fields.

Everything else is working but can't get it to only display the last date.

Any ideas?

Asked this question before here:
http://forum.civicrm.org/index.php/topic,35580


texts: How to create activity for automatic contribution receipts sent

texts: Is it possible to have CiviCRM create an activity (preferably email) every time a contribution receipt is sent?


texts: Add legal_identifier field to contact page and form?

texts:
I tried add legal_identifier field by custom tempelate. It worked for pages, but not for forms.
Then I added this code to sites/all/modules/civicrm/CRM/Contact/Form/Edit/Organization.php:

$form->addField('legal_identifier');

Now it works good in organization contacts, but I'm not shure if this is correct. Can I edit this file? What will happen after update?
Is there some better way? Can I use some hook? How?
Thank's, I'm getting started with civiCRM.