texts: Error during registration for multiple participants

texts:
I'm running into an issue for event registrations where multiple participants can be registered.  The first registrant goes through fine, however, when submitting registration #2, the following error occurs:

Call to protected method CRM_Event_Form_Registration_Register::getRegistrationContactID() from context 'CRM_Event_Form_Registration_AdditionalParticipant'

I am running Joomla 3.7.2 and Civicrm 4.7.19

Thoughts on where to go?


texts: How can I fix broken clickthrough URLs in Mosaico emails?

texts:
I've just started in on an issue with a D8 site, currently running Civi 5.25 and Mosaico 2.5.
Emails sent using Mosaico with clickthrough tracking contain a mix of correct and incorrect URLs. If I add a URL to an image that has been placed in Mosaico, then that URLs get correctly converted to something like https://example.org/libraries/civicrm/extern/url.php?u=xxx&qid=yyy
Embedding a URL into text in the body of the email, and/or using a button with a URL, they get converted to an incorrect link, of the form https://example.org/vendor/civicrm/civicrm-core/extern/url.php?u=xxx&qid=yyy - and clearly these links lead only to 404s.
If I construct a comparable email using the 'traditional' mailer then the resulting trackable URLs are all of the correct form.
So it looks like Mosaico is doing something weird in terms of constructing the paths for some, but not all trackable URLs.
I've looked at my settings for Directories and Resource URLs, and also looked at civicrm.settings.php and nothing is jumping out at me as being wrong.
I'm not too familiar with D8/Civi, and neither do I know much of the history of the site, other than that I've just updated Mosaico from 2.3x to 2.5 in an unsuccessful effort to resolve this issue.
Where is Mosaico getting the path data from? Why is it constructing some URLs that are fine, but others that are broken? Any clues gratefully received.


texts: How do I find users who have resubscribed via {action.resubscribeUrl}?

texts:
As a matter of ensuring consent is up to date, and because our bounce handling is broken, I have asked my newsletter subscribers to either resubscribe, unsubscribe or opt out.

The unsubscribe and opt out appear to work properly.

So now my list contains two sets:

people who recently resubscribed (via the {action.resubscribeUrl
token}
people who did not recently resubscribe (inactive addresses,
broken addresses, people who opened but didn't respond, people who
didn't open this particular email).

I would like to search for the first bunch (in part so I can infer who is in the second bunch).

The mailing reports do not appear to track users' resubscribe actions and I can't find it in the Advanced Search. I also can't find any reference to the resubscribe action in the record of a particular user I know resubscribed.

Can anyone explain how to do this?

Thanks!


texts:
Using CiviCRM 4.7.22 on Wordpress 4.8.22
We are having a problem with our contribution form submissions.  We have a Custom field.  When the member submits the form, the information from the custom field is added to the profile in the dashboard, but it shows up as blank in the email receipts to both the member and to the Admins. We need this data to show in the email receipts also.
Please see screenshots below for more details.

*******ADDITIONAL INFORMATION BELOW******

I noticed that when I add the custom field to the profile it says it is a "Primary" field, but when I go to edit it after adding it, it is no longer a primary field.  Why does it change?  Could that be what is preventing it from being included in the emails?

This is a "Contact" field, because we need it to appear below the Address area in the member's profile page on civi. It is just a simple membership, not multiple records.  I noticed that if I use an "Individual" field instead, it will work properly with the email, but the problem is it puts that field way on the bottom of the member's profile page in civi.  This really needs to be close to the address area.  So I guess the question is, why does an "Individual" custom field show the data in email receipts, but a "Contact" custom field won't, and how to do we fix that?

*****NEW IMAGE*****


texts: Related membership gets deleted upon updating owner membership via API

texts:
I would like to make several people a member, linked to 1 payment

person A: membership (+ contribution)
person B: membership (related to membership person A)

$contact_a = 2;
$contact_b = 3;

$contribution = civicrm_api3('Contribution', 'create', [
  'financial_type_id' => 2,
  'contact_id' => (int) $contact_a,
  'contribution_status_id' => 2,
  'total_amount' => 50,
  'is_pay_later' => 1,
]);

$main_membership = civicrm_api3('Membership', 'create', [
  'contact_id' => (int) $contact_a,
  'membership_type_id' => 1,
  'status_id' => 5,
  'skipStatusCal' => 1,
]);

$part_membership = civicrm_api3('Membership', 'create', [
  'contact_id' => (int) $contact_b,
  'owner_membership_id' => $main_membership['id'],
  'membership_type_id' => 1,
  'status_id' => 5,
  'skipStatusCal' => 1,
]);

$memb_payment = civicrm_api3('MembershipPayment', 'create', [
  'membership_id' => (int) $main_membership['id'],
  'contribution_id' => (int) $contribution['id'],
]);

This seems correct, person A gets a membership & contribution, person B gets a membership related to the membership of person A.

As soon as I process the membership payment via the API the contribution is complete and the membership for person A becomes active, BUT the membership for person B is deleted !?

$complete = civicrm_api3('Contribution', 'completetransaction', [
    'id' => 9,
    'is_email_receipt' => 0
]);

I have simplified the operation to only the membership registrations:

$contact_a = 2;
$contact_b = 3;

$main_membership = civicrm_api3('Membership', 'create', [
  'contact_id' => (int) $contact_a,
  'membership_type_id' => 1,
  'status_id' => 5,
  'skipStatusCal' => 1,
]);

$part_membership = civicrm_api3('Membership', 'create', [
  'contact_id' => (int) $contact_b,
  'owner_membership_id' => $main_membership['id'],
  'membership_type_id' => 1,
  'status_id' => 5,
  'skipStatusCal' => 1,
]);

And if I then set the membership of person A to "New" the membership of person B is deleted !?

$new = civicrm_api3('Membership', 'create', [
  'id' => 39,
  'status_id' => "New",
]);

The problem therefore lies somewhere with the update of the membership of person A.

Does anyone have an idea?


texts: Can i know the price for this CRM? I'm planning to get a CRM application for our organization and this look like a perfect match. Appreciate if you can let me know the cost for the full implementation


texts: Is it possible to have many to many relationships between custom field sets?

texts:
i tried to look for an answer but im pretty confused with what i found..
I'm trying to create a many to many relationship like in SQL..

for example:
lets say i want to create a custom 'Event'(a field set),
so i make some fields(name,date,location etc..) BUT now i want to make a custom 'Team'(field set) which has an 'events' field that contains the id's/names of this team events.

thanks in advance!

EDIT
okay let me try with a diffrent example: im making a managment system for a soccer team. so lets say i make a 'Court'(field set) with fields like name,address etc.. and now i want to make a 'Team'(fieldset) which contains all the diffrent Court's this 'Team' has.. is it possible to link many 'Court' records to a specific team? and each 'Court' has its related 'Team's ? i hope i made it more clear..


texts:
Recently we migrated our site from Drupal to Wordpress, everything seems to be working fine however we can't edit mosaico templates we had created while we were on Drupal. Have bunch of JS errors on browser console, seems its trying to load template from oldsite.
Checked the Resource URL, Directories settings everything seems to be correct. Also cleared CiviCRM cache and delete template_c with no success.
Any pointers would be appricated
Thank you


texts: CiviCrm Custom Fields - Random Number Generation

texts: Is there anyway to generate a random number using Custom Fields in Civi. any Ideas would be greatly appreciated


texts: Drupal custom module civicase is creating but it is returning null value?

texts:
In my drupal custom module I am creating a case object via

$result = civicrm_api3('case', 'create', $params);

This function on debugging api.php file is returning the case id but in my module it is returning the null value

I want it to return the case id. How would i do so?
Here code Snippet

function form_test_form_submit($form, &$form_state)
$params = array(
    'subject' => 'Test case',
    'contact_id' => 64771,
    'case_type' => 'test',
);

$case = testcase_create($params);

function testcase_create($params){
    civicrm_initialize();
    require_once 'api/api.php';

    try{
        $result = civicrm_api3('case', 'create', $params);
    }
    catch (CiviCRM_API3_Exception $e) {
        $errorMessage = $e->getMessage();
        $errorCode = $e->getErrorCode();
        $errorData = $e->getExtraParams();
        return array('error' => $errorMessage, 'error_code' => $errorCode, 'error_data' => $errorData);
    }
    return $result; // the value of $result is NULL, where as in api.php it was not NULL as seen in debugging
 }


texts: Shoreditch theme is not working when resource URL is "localhost"

texts: I installed CiviCRM V5.7 with shoreditch theme on localhost computer and looks good. I am accessing a site from another computer but not looking good (UI).As per the shoreditch extension, I put 'seven' as default theme.


texts: What is causing default membership type error?

texts:
On contribution page, I set "Membership One" as default membership, but then "Membership Two" is what shows up as default membership choice for public. I tried changing the default to other membership type, and it never "sets" as the correct membership I want defaulted but rather chooses another membership. It's like the membership type that is visible to public, is actually programmed as something else in Civicrm. Using WP.

How do I fix this?

Thank you!


texts: How to prevent selecting the wrong file format?

texts:
When you close an accounting batch, you are asked if you want the exported file in IIF or CSV.  We export to CSV every time since we don't use Quickbooks. Just now, however, our office manager accidentally chose IIF. "No worries," I thought, "we'll just re-download it and choose CSV."  No dice.

When you go to Exported Batches and click Download, you are not given the choice of format, it just begins downloading another IIF.  To fix it, I went to the civicrm_batch table in the database, found the batch in question and changed its status ID to 2 (Closed).  This allowed our office manager to export it again, but in the correct format.  (There must be an association somewhere in the database between file format and export batches; I wonder where that is... I digress).

My actual question: What is the best way to prevent choosing the wrong export file format on the batch export screen?  Disable the IIF option with CSS and/or JS? Can I prevent the IIF option from even systematically appearing since we don't use it? Where would I adjust that?


texts: Upgrading from 4.6 to 5.5.3 - [Error: Remove Moneris] CiviCRM_API3_Exception: "Could not delete payment processor type"

texts:
This is a Drupal 7+CiviCRM deployment. Trying to upgrade to 5.5.3 - we're getting this error that stops the upgrade script. Is there a database value I can edit to skip over this to proceed with the upgrade?

[Error: Remove Moneris]
CiviCRM_API3_Exception: "Could not delete payment processor type"

#0 X:\test\temp\sites\all\modules\civicrm\CRM\Upgrade\Incremental\Base.php(129): civicrm_api3("PaymentProcessorType", "delete", (Array:1))
#1 [internal function](): CRM_Upgrade_Incremental_Base::removePaymentProcessorType(Object(CRM_Queue_TaskContext), "Moneris")
#2 X:\test\temp\sites\all\modules\civicrm\CRM\Queue\Task.php(88): call_user_func_array((Array:2), (Array:2))
#3 X:\test\temp\sites\all\modules\civicrm\CRM\Queue\Runner.php(214): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
#4 X:\test\temp\sites\all\modules\civicrm\CRM\Queue\Page\AJAX.php(52): CRM_Queue_Runner->runNext(TRUE)
#5 X:\test\temp\sites\all\modules\civicrm\CRM\Queue\ErrorPolicy.php(106): CRM_Queue_Page_AJAX::{closure}()
#6 X:\test\temp\sites\all\modules\civicrm\CRM\Queue\Page\AJAX.php(54): CRM_Queue_ErrorPolicy->call(Object(Closure))
#7 [internal function](): CRM_Queue_Page_AJAX::runNext()
#8 X:\test\temp\sites\all\modules\civicrm\CRM\Core\Invoke.php(275): call_user_func((Array:2))
#9 X:\test\temp\sites\all\modules\civicrm\CRM\Core\Invoke.php(84): CRM_Core_Invoke::runItem((Array:13))
#10 X:\test\temp\sites\all\modules\civicrm\CRM\Core\Invoke.php(52): CRM_Core_Invoke::_invoke((Array:5))
#11 X:\test\temp\sites\all\modules\civicrm\drupal\civicrm.module(445): CRM_Core_Invoke::invoke((Array:5))
#12 [internal function](): civicrm_invoke("upgrade", "queue", "ajax", "runNext")
#13 X:\test\temp\includes\menu.inc(527): call_user_func_array("civicrm_invoke", (Array:4))
#14 X:\test\temp\index.php(21): menu_execute_active_handler()
#15 {main}

----- UPDATE -------

So we restarted the entire upgrade - manually deleted Moneris, and commented out line 193 as suggested by Jon G, but the script seems to stubbornly want to do its own thing. This is the error now:

[Error: Remove Moneris]
CiviCRM_API3_Exception: "Unexpected result from getcountArray ( [error_field] => payment_processor_type_id [error_code] => 2001 [entity] => PaymentProcessor [action] => get [is_error] => 1 [error_message] => 'Moneris' is not a valid option for field payment_processor_type_id ) "

0 X:\test\temp\sites\all\modules\civicrm\CRM\Upgrade\Incremental\Base.php(122): civicrm_api3("PaymentProcessor", "getcount", (Array:1))
1 [internal function](): CRM_Upgrade_Incremental_Base::removePaymentProcessorType(Object(CRM_Queue_TaskContext), "Moneris")
2 X:\test\temp\sites\all\modules\civicrm\CRM\Queue\Task.php(88): call_user_func_array((Array:2), (Array:2))
3 X:\test\temp\sites\all\modules\civicrm\CRM\Queue\Runner.php(214): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
4 X:\test\temp\sites\all\modules\civicrm\CRM\Queue\Page\AJAX.php(52): CRM_Queue_Runner->runNext(TRUE)
5 X:\test\temp\sites\all\modules\civicrm\CRM\Queue\ErrorPolicy.php(106): CRM_Queue_Page_AJAX::{closure}()
6 X:\test\temp\sites\all\modules\civicrm\CRM\Queue\Page\AJAX.php(54): CRM_Queue_ErrorPolicy->call(Object(Closure))
7 [internal function](): CRM_Queue_Page_AJAX::runNext()
8 X:\test\temp\sites\all\modules\civicrm\CRM\Core\Invoke.php(275): call_user_func((Array:2))
9 X:\test\temp\sites\all\modules\civicrm\CRM\Core\Invoke.php(84): CRM_Core_Invoke::runItem((Array:13))
10 X:\test\temp\sites\all\modules\civicrm\CRM\Core\Invoke.php(52): CRM_Core_Invoke::_invoke((Array:5))
11 X:\test\temp\sites\all\modules\civicrm\drupal\civicrm.module(445): CRM_Core_Invoke::invoke((Array:5))
12 [internal function](): civicrm_invoke("upgrade", "queue", "ajax", "runNext")
13 X:\test\temp\includes\menu.inc(527): call_user_func_array("civicrm_invoke", (Array:4))
14 X:\test\temp\index.php(21): menu_execute_active_handler()
15 {main}


texts: Why when upgrading civi via drush I always get You are already upgraded to CiviCRM version-I'm-upgrading-from?

texts:
I saw a bug out there on this but it's old and claims to be fixed.  I keep thinking the next time I do an upgrade, it'll be fixed.

So for example:  upgrading from 5.9.1 to 5.10.0

drush civicrm-upgrade --tarfile=~/civicrm-5.10.0-drupal.tar.gz

Which outputs a bunch of normal messages and then

You are already upgraded to CiviCRM 5.9.1

Which is true, but I'm trying to upgrade to 5.10.  When I run the exact same command again, it works.


texts: Is it a bad idea to change a Participant's registered event after a payment has been made?

texts:
I've been doing some thinking on this but haven't tested it yet. Essentially, we've a user who would like to always have the ability of changing Participants' events.

It seems as though the default CiviCRM functionality here is to allow changing events up until a payment has been made. That aside, it's still feasible to change the registered Event via API or otherwise.

I'm wondering is if there is a repercussion of changing the registered event after a Contribution has been made. Is this functionality disabled for the convenience of not having to worry about mismatched price sets or is there a deeper issue of breaking some kind of reporting functionality?


texts: How to manually trigger update hook for an extension?

texts:
Question:
When upgrading an extension from the UI on Site A it will update the files and run the update hook. How do I manually execute the update hook for the extension on the other Site B, C, etc?

The extension directory on our server is shared between all the sites. This means that when I "upgrade" an extension on Site A the files will be updated for all the sites. However, the "update" hook is only executed on Site A. The result is that the extension files are up-to-date for ALL sites and CiviCRM perceives that Site B, C, etc no longer need to update the extension. This means that I cannot execute any update functions. Is there a way to manually trigger the update function?

Configuration Information:

CiviCRM 5.8
Drupal 7
Each of our sites has a separate database (they are not shared).
Each site is configured in drupal_root/sites/subdomain.domain.org
Extensions are installed in a directory shared by all sites (drupal_root/CustomExtensions).


texts:
I wish to integrate the US "Do Not Call" (DNC) list as either a service or as an imported list to verify my contacts are not on the list.

Somehow, in the course of research, I believe I encountered an extension that did this via the issued (DNC) SANS number.   And, same functionality offer call list creation, assignment of caller, etc... essentially, call enter functionality.

If anyone is aware, appreciated.


texts: Year End Contribution Summary for Donors

texts:
I'd like to send out to all my donors a summary of all their contributions in the past year.

CiviCRM seems to have a feature that should do that by grouping the contributions per contact when printing out thank you letters but that feature is broken as illustrated here : Table not rendering data properly using new contribution grouping feature

Any work arounds that I am not thinking of?
Thanks


texts: Mosaico default template - unsubscribe setting

texts:
The default Mosaico template has unsubscribe option in header.   However the token or destination url is for group unsubscribe rather than the more general opt-out token.     I cannot see a way to insert/change the token that is used for the default or to change for an individual template.

Default:

Preferred:

(1) Is there a way to change an individual mailing to opt-out for unsubscribe (the more common requirement than removing from a Group)

(2) Is there a way to change the default?

Thanks


texts: How can a pull a report with notes includes

texts: We are trying to export a list with notes included. We are creating a prospect list for Employment Engagement team. We will add names to the database, this list is obtained from events that we host. We will then take the names and information add to Civi and use notes to personal our contact engagement. We will then want to pull and export a specific list that would include notes from previous interactions, so we can keep track of conversations


texts: How to embed or attach a list of contacts in an email?

texts: My users want to send an email from Civi that will have a particular group of contacts embedded in it or as an attachment. The group is featured in a report, so emailing the report seems like the solution, but they want to preface the report with some words.  How to embed or attach the contact list or report into an email sent from Civi?  This is using Drupal so perhaps Views is an option?


texts: How should I go about proposing (and then possibly creating) a new CiviCRM feature?

texts:
I have an idea for a small new feature. I think this feature would be useful to a significant portion of the Civi user community. I'm willing to build it. Is there a standard process for proposing my feature, getting approval (from the community? from the Civi core team?), and then developing it?

(To give an example, I'd like to expose "Payment Processor" as a search criterion on the Find Contributions form. No change to the database schema, not a huge change to the UI, and probably not a lot of new code. This feature would probably be useful to a larger portion of the Civi community than just the client who requested it.)

Is the process any different if I won't be building the feature myself?

How is the process different for features of different sizes? (And how is it determined whether a feature is "big" or "small" -- or what constitutes a "new feature" versus an "improvement on an existing feature"?)


texts: How to change the landing page layout and content after somebody unsubscribes from a mailing

texts:
is there a possibility to change the layout, font size, etc of the landing page after somebody clicks the unsubscribe token {action.unsubscribeUrl} ?
I've been looking for it but can't find.
Either via the back office or perhaps where the HTML is generated from the PHP?
We are using Drupal CMS
Thanks in advance.
Regards,
Davey


texts: Minimum Membership fee is ignored during renewal in Backoffice

texts:
I have a simple question about membership fees. I have configured a membership type with 15€ monthly.
When I try to renew the membership in Civi Backend I get the amount prefilled, but I can change it to e.g. 10€ and book the membership extension.

I expected to get an error message or at least a warning that I try to extend the membership with less than the minimum fee.

Is there a way to visualize these information?

Thanks for your help!
Said


texts: New error when editing membership: Argument 1 passed to CRM_Financial_BAO_Order::setOverrideTotalAmount() must be of the type float, string given

texts:
This error seems to be connected with the update to version 5.36 as it just appeared after that.
When editing an existing membership or adding a new membership the following error appears in the logs:
TypeError: Argument 1 passed to CRM_Financial_BAO_Order::setOverrideTotalAmount() must be of the type float, string given, called in C:\wamp64\www\civicrmd8\httpdocs\sites\all\modules\civicrm\CRM\Member\Form.php on line 486 in CRM_Financial_BAO_Order->setOverrideTotalAmount() (line 152 of C:\wamp64\www\civicrmd8\httpdocs\sites\all\modules\civicrm\CRM\Financial\BAO\Order.php).
I feel it could be connected to https://github.com/civicrm/civicrm-core/pull/19476/files
A quick fix I found was to change line 486 of civicrm/CRM/Member/Form.php from
$this->order->setOverrideTotalAmount($formValues['total_amount']);
to
$this->order->setOverrideTotalAmount((int) $formValues['total_amount']);
But I am not quite sure if this really solves the issue or what sideeffects I do not see. Maybe this type casting should be done earlier in the process? or maybe the problem lies somewhere else? In my case the value of $formValues['total_amount'] is an empty string but I do not know where this value comes from.


texts: Nametags skip first row and spill over [solved]

texts:
I have created a profile for nametags that seems fairly normal: organization logo, blank line (10 pt), First name (24 pt bold), Last Name (24 pt bold), Organization Name (14 pt).

What results is a blank row of two nametags with the graphic but no names.  And at the bottom is an extra row of names that spills off the page.

What might be causing this and how can I fix it?  The mis-match between graphic and names is throwing me.


texts: CiviCRM Wordpress Cron not running - DB Error connect failed

texts:
I've installed CiviCRM in one of my Wordpress site, It installed fine but it is showing me popup window that "No Cron is running", i've tried to setup Cron from my Cpanel with PHP-CLi method, I use this command:

/usr/local/bin/php /home/thetia/public_html/wp-content/plugins/civicrm/civicrm/bin/cli.php  -s thetia.com.au -u database_user -p database_user_password -e Job -a execute

When cron executes it send me Email with following error:

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

DB Error: connect failed

I'm providing right username and password but even then it is showing me this error, i don't know what am i doing wrong, any help will be very appreciable.


texts: Viewing a Personal Campaign Page before approval

texts:
We've recently started using the PCP feature, and all of our supporters' PCPs must be approved. However, I haven't found a way to view/edit the PCP they have created before approval, which seems important. When Managing PCPs, unapproved pages are greyed out, and clicking on Edit takes me to the public contribution page with the error that the PCP isn't available.

Is there something I'm missing? Shouldn't admins be able to view before approval?

Joomla 3.7.5, Civi 4.7.21


texts:
I tried to get the CiviCRM LDAP integration working.

I used the LDAPcivi 'extension' (GitHub). And got it running quite quickly. But when I tried to connect with Thunderbird I ran into trouble. This is what the server showed me.

bind dc=[domain name of civicrm site], dc=[tld]:[password]
searching 100
[ 'title',
  'sn',
  'surname',
  'mozillahomelocalityname',
  'cn',
  'commonname',
  'givenname',
  'mozillahomestate',
  'mail',
  'mozillaworkurl',
  'workurl',
  'labeleduri',
  'o',
  'company',
  'mozillahomestreet2',
  'mozillanickname',
  'xmozillanickname',
  'mobile',
  'cellphone',
  'carphone',
  'modifytimestamp',
  'nsaimid',
  'nscpaimscreenname',
  'telephonenumber',
  'birthyear',
  'c',
  'countryname',
  'mozillahomestreet',
  'postalcode',
  'zip',
  'mozillacustom1',
  'custom1',
  'mozillahomecountryname',
  'st',
  'region',
  'mozillacustom2',
  'custom2',
  'mozillahomeurl',
  'homeurl',
  'mozillaworkstreet2',
  'mozillasecondemail',
  'xmozillasecondemail',
  'facsimiletelephonenumber',
  'fax',
  'description',
  'notes',
  'mozillacustom3',
  'custom3',
  'homephone',
  'mozillausehtmlmail',
  'xmozillausehtmlmail',
  'birthday',
  'street',
  'streetaddress',
  'postofficebox',
  'mozillacustom4',
  'custom4',
  'l',
  'locality',
  'pager',
  'pagerphone',
  'ou',
  'department',
  'departmentnumber',
  'orgunit',
  'birthmonth',
  'mozillahomepostalcode',
  'objectclass' ]
query DN = dc=[domain name of civicrm site], dc=[tld] sub / And
(&(|(cn=*ldap*)(givenname=*ldap*)(sn=*ldap*)(mozillanickname=*ldap*)(mail=*ldap*)(mozillasecondemail=*ldap*)(&(description=*ldap*))(o=*ldap*)(ou=*ldap*)(title=*ldap*)(mozillaworkurl=*ldap*)(mozillahomeurl=*ldap*)))-> searching And for ldap
searching ldap
civicrm_contact_search failed: couldn't parse {"is_error":0,"undefined_fields":["contact_is_deleted","cms","contact_type","sort_name"],"version":3,"count":1,"id":5,"values":[{"contact_id":"5","sort_name":"API, LDAP","display_name":"LDAP API","contact_type":"Individual","first_name":"LDAP","last_name":"API","job_title":"","organization_name":"","contact_is_deleted":"0","current_employer":"","address_id":"","street_address":"","supplemental_address_1":"","city":"","postal_code":"","state_province_id":"","country_id":"","phone_id":"","phone_type_id":"","phone":"","email_id":"","email":"","state_province_name":"","state_province":"","country":"","id":"5"}]}
civicrm_contact_search failed: unknown error

So. It actually manages to get a good search result. But somehow it isn't able to send it to Thunderbird. Maybe I'm missing out something obvious!

Hope someone else already got this LDAP thing running, and is able to help me out.

I also opened an issue on GitHub concerning this problem.

Maybe LDAPcivi is too old. I saw it was mentioned a bit more recently on this forum, so I hope that is still usable!

All the best,


texts: Changing our contact email address in Event Templates

texts:
When I create a new event template, which has an email address other than that used in other events we have, changing the email automatically also changes the email address in the other existing events.

We run several events but the contact people can be different. How can I create a new event template without this changing the email address in existing events?

Can anyone help? Thanks in advance.

Best wishes,
Minna
Baffled in Liverpool


texts: WordPress WSOD When Activating CiviCRM 5.37.2

texts:
I am attempting to activate the CiviCRM 5.37.2 plugin on WordPress 5.7.2 after editing the MySQL connection string. After saving the connection string, I briefly get the CiviCRM "Success" page before I get the infamous WordPress "Whtie screen of death" saying "Sorry, you are not allowed to access this page." (see attached)
To rule out my web host as the source of the issue, I spun up an Amazon Lightsail WP instance and got the exact same behavior. Any help is appreciated.


texts:
Update 11-11-2019 See my answer below.

When dumping a Drupal CiviCRM database to move and convert to a new WordPress install, I've found that the membership data appears to have been encrypted; these random character strings appear in WordPress in Memberships>Dashboard, i.e. bs00fgcb for name, hgaibbsf@example.org for email, etc. But the two letter state abbreviation isn't a random string.

The garbage data appears in the database dump when viewed with a text editor, before I import into the new database.

No other database data seems to be affected, and CiviCRM appears to run fine in WordPress, other than the data display above.

Does this appear to be encryption? There are no encryption modules in Drupal (no Drupal Encrypt) that I can see., nor CiviCRM extensions Where would I find the functions that do the encryption and decrypting? In Drupal [cms.root]/sites/default/files/civicrm/custom/? Or could encryption be done at the MySQL level?

CiviCRM is the same version between Drupal and WordPress; same MySQL database and encoding (both sites are on the same server). Database collations are exactly the same between the two: latin1_swedish_ci. No other data is corrupted. I've tried importing multiple times.


texts:
We have a unique organization (large homeschool coop) that has various oddball requirements for membership types, durations, payments, etc.

I think I'm going to be using Pledges to solve some of our woes, and am wondering if it is possible to do a batch entry of NEW pledges. I see that you can do a batch entry of pledge payments, but can I do something like this?

Search for memberships with a certain status.

Take search results and create a new pledge for those people and set the details like Campaign associated with it, total pledge amount, pledge status?, and monthly payment plan.

Thanks!

Drupal 7.41
CiviCRM 4.6.10


texts:
I am using CiviCRM 4.6 with Stripe extension 4.7.3. I am able to do payment by Credit Card, but unable to find option to enable ACH payment.

Has anyone know how to enable ACH payment option in CiviCRM Stripe.


texts: How can I customise site search settings to use a wildcard for a specific entityRef field?

texts:
Is it possible to override the site search settings with respect to the wildcard search, for a specific entityRef field?

We have the site search setting configured with wildcard search disabled. On a particular custom form I'm injecting an entityRef field using the API to filter by Individual and group. I'd like to override that site setting and allow this to use a wildcard search.


texts: Stripe/GoCardless Payment Processor payouts - Accounts reconciliation

texts:
I understand this isn't strictly CiviCRM, but it's more a question to the community in how they work with the payouts of the popular payment processors Stripe & GoCardless.

As I understand it, both payment processors group income and payout at a certain frequency as a single payment to a bank account.

As part of our annual accounts submission, we have to show income separation between membership & donations. At the moment, that requires us to go back into Stripe or GoCardless admin UI once we receive our monthly bank statement and try and piece together how much of that payout was membership vs donations that month. Once that's done, we then can correctly input and tag it in our bookkeeping software (Sage in this case).

Is there an easier or more streamlined way to handle this?

Apologies if this is too far removed from CiviCRM subject matter and thus needs to be removed.

Any input would be greatly appreciated.


texts: Changing Participant Status - generates wrong email

texts: At this point in our application process, 'Awaiting approval' is our desired, and standard participant status. However, if a record needs altered and the status is changed away from that for the alteration, and then back to 'awaiting approval' the auto generated acknowledgement mail defaults with 'You have been added to the WAIT LIST for this event.' which isn't the case and causes concern. Is there a way to avoid this?


texts: How to get php $_SESSION variable inside a template

texts:
I am setting $_SESSION variable inside a payment response file and need this to display on Thank you page. Somehow nothing seems to work so far.

Tried following things:

$_SESSION['test'] = 'Hello World'; // Inside payment response file

Need this in confirm.tpl file. Tried

{$session->get('test') // does not work
{$smarty.session.test} // does not work

Tried so many other things but nothing seems to work. Also, it's not working for any other variable like $_SERVER, $_POST etc.

Any ideas?


texts: CiviCRM API with Custom Data mixed with Standard Entities

texts:
I'm using CiviCRM 4.6 with the new API editor.

I'm attempting to chain a bunch of queries together, which provide cases for a client within a period, along with the linked contact, along with custom data from the case entity, and the contact entity.

I'm wondering the best way to chain this query together?
The new case Entity allows retrieval of cases, by case type. If I chain the Contact entity to it via {"cid":"cid"} I obtain a list of client details... However both return just standard fields.

If I enter return fields and select the custom fields, these do not appear in the final result.

So what is the best way to query certain custom field values, which are specific to the case and client? i.e. A custom field ID#370 in Custom Field Group ID#55 for the client, which is a custom field attached to the case.


texts:
I haven't quite worked out under which circumstances, but our WordPress (4.0.1) and Civi (4.5.2) seems to create duplicate contacts for the same WordPress user. I think it happens when they log in, but I can't be sure. It doesn't happen to most people, just some--including me!

I now have 5 contacts with my name. The first one has all the details associated with it including membership and activities, the others have minimal information but unfortunately they have some activities and contributions (this has been caused by other administrators picking the "wrong" contact when assigning contributions). I've logged in many more than 5 times, so not sure how this happened. Any tips on diagnosing the problem?

Related to this, if I try and merge duplicate contacts, it now loses the activities and contributions. I'm sure that in previous versions of Civi, this worked OK, but at the moment I'm having to manually move the activities and contributions using SQL. Is there a better way?

Thanks!


texts:
It appears that the Contact GetCount API is not working properly in 4.4 to retrieve group counts.  I can code around it by switching to Get which works fine, but wanted to see if there was something I was missing. (I'm upgrading from a 4.2.6 site which works fine.)  My specific example is a smart group, but I've tried non-smart groups as well with the same result.

Using the api/explorer ....

On my 4.4.19 test site

The GetCount is wrong

/civicrm/ajax/rest?json=1&sequential=1&debug=1&&entity=Contact&action=getcount&group=82  returns { "is_error":0, "result":1 }

But the get is right
/civicrm/ajax/rest?/civicrm/ajax/rest?entity=Contact&action=get&debug=1&sequential=1&json=17&group=82  returns ... "count":9,  ....

But on my 4.2.6 live site

The GetCount and Get are both correct

/civicrm/ajax/rest?json=1&sequential=1&debug=1&&entity=Contact&action=getcount&group=82  returns { "is_error":0, "result":8 }

/civicrm/ajax/rest?/civicrm/ajax/rest?entity=Contact&action=get&debug=1&sequential=1&json=17&group=82  returns .... "count":8,


texts: PayPal PSD2 - new European Union directive from 14th September 2019

texts:
A couple of clients using PayPal have received an email regarding a new European Union directive.

Some info from the email –

  As a business accepting card payments, your online checkout will need
  upgrading to comply with a new European Union directive requiring
  Strong Customer Authentication (SCA). The directive applies from 14
  September 2019, but card issuers are working towards SCA by April so
  that their systems are fully operational by the deadline.

  Want to know more?

  Find out more about PSD2 and check out our guide to integration -
  https://www.paypal.com/uk/webapps/mpp/psd2

As I understand it, no changes are required if users are redirected from your website to PayPal (hosted payment integration) but changes are required if you accept card payment on the actual website (Direct or in-line payment processors)

PayPal is one of the core payment processors in CiviCRM and the in-line option is now also compatible with webforms so I’m guessing this will affect many.

How do we move forward to be ready by the deadline as transactions will be declined if no action is taken?

I’m guessing this will also affect other in-line payment processors?


texts:
I am troubleshooting a development site and the contribution pages working under Civicrm 4.6.30 and Joomla 3.6.5 are not working under joomla 3.8 and Civi 4.7.23.
Formatting of form is screwed up (alignment, form field lengths, etc.) are incorrect and most importantly, the total amount for selected options are not totaling.
I have tried reinstalling Civi 4.7.23 and experimenting with changes to civicrm.css, but nothing works. I saw a post suggesting clearing civi caches and logs, which I have done, but still no go. URL is  form url.
Any ideas would help. Thanks, K.


texts: Struggling: Search report for donations by creation date not receive date

texts: I want to send thank you letters and gift aid forms to everyone who 'created' a contribution donation (not membership contribution) within a period of a few months, a one off or recurring donation with us. I can only seem to get results with received date, which might be fine for the one-off donations, but not for recurring ones, as we receive them every month. It seems that neither the Search builder nor Find Contributions can create a report with the 'created date'. Any thoughts? Am I missing something, or is this not available?


texts: Why Could My Payment Page Not Be Accepting Payment?

texts:
We have a webform set up to enable an individual to update an organisations details and then pay for the organisations annual membership. We are having an issue however where a user is reporting the following error.

  I've tried to make payment for the [organisation] membership, but it tells me after putting my payment details in that it needs an email address to complete the transaction. There's no-where on this page to put that in!! There was on the previous page, and that part was completed.

The webform is set out as a two pages; updating details and membership payment, so I have truncated the screenshots to remove the non-relevant organisation updates:

This is the top of the webform linking the user to the organisation, in this case the Station Administrator user does have a permissioned relationship over the Station organisation

This is the bottom of the webform with the payment page

I have the organisation contribute webform set up identically as an individual membership we also run, so I can not see that there are any issues there(?) and I have used the individual payment page (directly through the contribute link though, not a webform) so that side of it worked for me.

Set-up wise, we are using D7.36 Civi4.4.14 and Stripe as our payment processor.

I would appreciate any thoughts you have, because I have tried everything to get this working and it does not want to be co-operative.

Edited 12 May 2015

I have been persevering with this taking @Coleman 's thoughts forwards. We have since had another report of payment failing (my previous member chose to pay using another method) and this is what I can glean from the CiviCRM:

When I masquerade as the user and go to the webform I can see the notice that their organisations membership has expired, so the relationships are being seen. I have also checked that the user is permissioned
When I go to the CiviContribute page directly while in masquerade there is nothing obvious that the Contribute page is recognising the link between the user and the organisation
When I go into our Stripe dashboard there is no record of any decline or failure; indeed the last successful transaction was my own which was around a month ago

I have also taken out the on behalf of organisation option that was in place as it was just loading a Reserved Profile that did not appear to be connecting to any existing information.

This is all getting very confusing now...


texts: Why my log_civicrm_setting is keep growing with random entries?

texts:
I have noticed this since upgraded to 5.36.x that my log_civicrm_setting is kept growing in size with some random navigation enties. No idea what it is. Cannot find these in the civicrm_setting either.
Has anyone experienced this? How did you fix it.


texts: How to expose the civicase hashed value that gets sent in Subject when sending an email from case

texts:
Happy to be told we are going about this wrong.

SCENARIO: Case Manager gets sent an email from an external source to their private/organisational email address.

They want to forward/resend to it gets stored on the Case.

Manager goes in to Civi (or Views in our case) searches the contact, finds the relevant case, then, as i understand things, they need to include a value in the email such as

  [case #44fec3a]

where that value is the first 7 letters of a hashed value of the civicrm site-key plus the case id

And indeed this works, if I send an email to the 'inbound email processing email address' and have  [case #44fec3a] it gets added to the Case. Wonderful.

But the Case Managers have no way of knowing what the hashed value should be - and we need to be able to show it on both the CiviCase page and in Views.

So do we need to find a way to 'present' this 7-character string on both the Case page, and pull it together in our Views?

Or does anyone have a simpler/better suggestion/solution?


texts:
I need to update the recipient list of a scheduled mailing.

How do I do this?


texts: is there a possibility to add custom fields to "notes"

texts: We want to structure the content in our "notes" by adding custom fields. We want to do this in notes because it is the only place where you can shield datafields form other users.


texts: CiviCRM Scheduled Mailing Timezone issue

texts:
We are facing an issue with timezone after upgrading CiviCRM to 4.6.14 from 4.5.8. Our CMS is Drupal 7.43.

It seems if an admin sets a scheduled mail to be sent immediately, then the scheduled date time is set according to the admin user's set timezone in Drupal. We have CiviCRM cron setup via crontab. It seems when this cron runs, it checks the scheduled date time of the mailing job according to the Drupal Default Site Timezone.

So for example, an admin's timezone is set to Halifax and according to that current time is 7AM and site's default timezone is set to New York and current time is 6AM. When this admin creates a scheduled mail then the schedule time is set to 7AM. User intends to send this mail immediately, but when the CiviCRM cron is run, it seems that current time is 6AM and this mail is scheduled for 7AM. So it actually sends the mail after 1 hour.

This is actually an issue if user schedules the mail time. In the above example, if user sets the scheduled time to be 9AM, 2 hours from now, then user expects the mail to be fired after 2 hours. But in reality the mail will be sent after 3 hours when the site's timezone shows current time is 9AM.

In all previous CiviCRM versions, we never faced this issue. Is there something changed regarding the date/time handling in the cron job or the mail schedule setup? How do we resolve this issue?


texts: Civievent custom data field duplicate fields in Edit

texts:
I encountered a strange situation.  I have added a custom data group in a participation record called "Emergency Contact"  with 2 fields and while this appeared ok in View of the participant records, there would be 2 such group displayed when i click Edit.  Entering only 1 of these 2 group will retain the values, the other group wouldn't.  Any idea how this happened and how it can be resolved?

WordPress: 5.0.4 CIVICRM: 5.10.4 Ubuntu


texts:
If someone signs up using a discount code and select auto-renewal; will they get the same discount when the membership is renewed?

Best Wishes
PD


texts: It's these two items at the bottom. It came from when I was trying to set up profiles. Can someone tell me how to get rid of them? "who do you vote for" and "individual"


texts: Event scheduled reminders not sending with fixed date

texts:
I've been doing a bunch of testing on this on my site running Civicrm 5.13.5 and Drupal 7 after my event scheduled reminders were not working.

From what i can work out, if the original reminder has a fixed date (eg, 19th Sept 2019) the first email goes out but no subsequent repeats go out. No errors in the cron log.

But if the original reminder has a date like "1 hour after event start date", the repeats work.

The steps I used to reproduce were:

Make sure cron is working and schedule reminders set to hourly
create a test event
make a scheduled reminder with fixed date and repeat every hour till a year after event start.
only the first reminder is delivered
set a reminder with relative date (1 hour after start date) repeat every hour until a year after start date.
works as expected.

Is this a known bug? Fixed in a later version maybe. I'm happy to do more testing, file an issue in gitlab. Whatever is most useful.

Just wanted to post here in case it helps anyone else.

Can be a pretty annoying bug when you have a reminder set to trigger each week like we did. And you have to wait a week to check if it worked or not.


texts: CiviCRM not creating Wordpress user accounts on member registration

texts:
We are seeing intermittent behavior with CiviCRM and Wordpress. Sometimes the membership registration page will create a new Wordpress account as expected. Sometimes it doesn't. What would cause this behavior?

The CiviCRM membership registration page has the Wordpress account creation required checked in the profile and primary e-mail is present on the form. Here is the form for reference: https://aslta.org/membership/selection/

WordPress 4.3.1 CiviCRM 4.6.6


texts: How Do I Fix Mail Send Stopping at 500 Sends?

texts:
When using Civi Mail, we have a recurring issue wherein the system stops sending emails at 500 sends. The job shows as incomplete.

It is not a php timeout, as the hosting company (https://www.rochen.com/) has increased all our limits during testing, with no change.

We can re-initiate the mail send, and it will send out the next set of 500 emails, then stop again. We have to continue manually triggering the send to get the full job completed.

Any thoughts on the culprit?

System info:
CiviCRM 4.2.6
Joomla 2.5.28
php 5.3.29
MySQL 5.5.42-cli


texts: cannot access /wp-admin/options-general.php?page=civicrm-install after installing 5.28.3

texts:
I have found it impossible to upgrade from CiviCRM 5.25 to 5.28 to get around the breakage caused by the WP upgrade from 5.4 to 5.5
My attempted solution has been to make a staging site, completely remove civiCRM and reinstall using the 5.28.3 zip file.
All seems to go well including adding the UK i10n files until I go to
/wp-admin/options-general.php?page=civicrm-install
Where I get the message Sorry, you are not allowed to access this page.
As the only admin on the site, I find this strange.   Any hints?


texts: Drupal views: Civicrm drupal_id entity missing after update?

texts:
Inside Drupal views, I use some contextual filters and relationships which, I think, are provided by CiviCRM Entities.

Before Civi 5.15, some seemed to be provided by CiviCRM itself (?). Under 'relationships, for example, there was 'CiviCRM Contacts: Drupal ID' which did not say 'provided by CiviCRM Entities'.

After an update to 5.15, that relationship, and a whole bunch of others, are gone. Under relationships, the only one left is 'CiviCRM Contact: Entity translation: translations Translation information.'

Also under 'contextual filters', a lot of civicrm filters, but not all, are gone.

What am I missing ? Have they moved somewhere else ?


texts: How do I provide a custom redirect after cancel clicked on Unsubscribe page?

texts: Is there a way I can direct where the user goes when they click Cancel on the Unsubscribe button on the Unsubscribe Confirmation page?


texts: Is there a process to tidy the tables created by logging?

texts: I've successfully improved the performance of the 'Change Log' by taking Eileen's advice here, converting 5 tables to InnoDB and adding indexes. In so doing, I almost blew the space limit on the host site as one table log_civicrm_group had almost 4 million rows. (The site has only 3.500 contacts but 1.3 million activities) I solved the problem by emptying this table, with what appears to be no ill effect (!). The upside of better performance having the advantage over not being able to look at the change log at all.  So the question arises - as Civi is used year on year these logging tables must grow and grow - so is there a process to keep them tidied, and stop them blowing a space limit? A parameter or setting somewhere? Or is there a need to write some code to remove rows over a certain age?  I guess the same question applies to activities but I'm interested in logging for now.


texts: Why am I unable to set organization name?

texts:
CiviCRM 4.4

I am trying to set the organization name and address details but the form is not displaying correctly. There are no input fields, only a white screen.

I added some debug stuff to wp-config.php. I then got: Fatal error: Smarty error: [in CRM/common/formButtons.tpl line 38]: [plugin] unknown tag - 'crmGetAttribute' (core.load_plugins.php, line 118) in /home/vietfeir/public_html/wp-content/plugins/civicrm/civicrm/packages/Smarty/Smarty.class.php on line 1094 Where do I go from here? I searched for this error in forums.civicrm.org but could not find any reference to this error.


texts: Prevent users from changing membership type when they renew?

texts:
Does anyone know an easy way to prevent users from changing membership type when they renew via the renewal page?

Thanks in advance!


texts: WordPress - Problems trying to go back to CiviCRM 4.7.17 from 4.7.19

texts:
I've been having problems trying to get CiviCRM 4.7.19 working. So I thought I'd try going back to CiviCRM 4.7.17, which I had managed to get working pretty well on another site. I deactivated and deleted CiviCRM 4.7.19, deleted and recreated the MySQL database, and uploaded, extracted and activated CiviCRM 4.7.17.

When I go to Settings on the WordPress dashboard, I don't see "CiviCRM Installer".

When I try http://<my_wordpress_home>/wp-admin/options-general.php?page=civicrm-install

I get "Sorry, you are not allowed to access this page."  (Even though I am logged in as a WordPress administrator in another tab.)

I'm pretty new to CiviCRM and not sure where to go from here. Thanks for any tips you can provide.

WordPress 4.7.4 running on Linux.

http://connectionpracticecoach.com


texts: Custom date field formatting with smarty

texts:
I'm trying to format a custom date field using smarty to send emails. What I want is to have the day of the week included, as "Wednesday, April 18, 2018". It seems that this should work:

{contact.custom_105|date_format:"%A, %B %e, %Y"}

But the mail send hangs. Also hangs if I just use

{contact.custom_105|date_format}

I can use {contact.custom_105} to send the preformatted date "03/01/2018 3:15AM", so I know I'm working with the correct field.

How can I get this formatted as I want?


texts:
Right now I have a custom data set set up that has 3 custom fields inside of it. Inside each custom field is a list of options that can be checked. (checkbox is the option)

In my spreadsheet that I import I have the correct columns and appropriate values in for the options I need to be checked for each contact.

So lets say here are my 3 custom fields with 3 different options (example):
Custom field A contains blue, red, and white in that exact order on the spreadsheet. Custom field B contains purple, orange, yellow in that order on the spreadsheet. Custom field C contains cow, cat, dog in that order on the spreadsheet.

If Example Contact 1 has blue marked, purple marked, and cow marked it will check those off appropriately.

If Example contact 2 has blue marked, yellow marked, and cat marked only blue will import.

I did multiple tests and have come to the conclusion that only the first value of each custom field will import if it is marked. Anything else marked will not be imported.

Is there something I can do to fix this?


texts: Upgrading from 4.1.5 database to 4.6.2 failing with constraint violation

texts: Trying to upgrade a 4.1.5 database to 4.2.6. I am getting a constraint violation. See the screenshot.


texts: The cron job "Activity processor (Hourly)" fails

texts:
The cron job "Activity processor (Hourly)" has started failing for no apparent reason with the message "Failure, Error message: Process Activities failed" in the job log, although the message coming from cron is "Failed Processing: . Reason: DB Error: syntax error". Neither message is much help.

We are running CiviCRM 4.5.8 under WordPress 4.2.2.

Has anyone experienced this? Where do I start to find and fix the problem?

Thanks,
Jim


texts: Is a contribution always a donation or could it be a receipt from other(s) to one Member or contact?

texts: Is a contribution always a donation or an amount from any Membership or could it be a receipt from other(s) to one Member(ship) or contact?


texts: Discounts for multiple price field selections (e.g. select all five options and get $X off)

texts:
Is it possible to set up a price set such that selecting multiple options would lower the total price?

Our use case is a summer camp. You can register for a day ($50) or for a week ($190). We need to be able to set a maximum number of participants for each day. So, if we could make a form where you simply select all days in the week to register for an entire week and a $60 discount was applied in that case, this would satisfy our requirements.

Putting in the week as a separate option would make it impossible to have registration limits for each day. The camp has multiple weeks over the summer, so we can't use a registration limit for the whole event to do this.

This is currently set up as a webform, but that comes with other issues, so it would be preferable to find an option that works with price sets and CiviEvent.


texts: Civirules intent to select contact with address of one type with the exclusion of another type

texts:
I have created a type of address labeled "Old" for keeping a record of addresses that are no longer valid for a given contact.
I want to create a Civirules rule for tracking the contacts where the "Old" address is set and no other address is available.
I was hoping the condition "Address is unique" was meaning that there was only one type of address available for a given cntact, but I discovered that this condition is always valid when there is no other contact in the database with the same address.
I would like to know how I can solve my problem: creating a group with all the contacts having an "Old" address and no other address (like "Home", "Work", "Other", etc...).


texts: CiviCRM 4.7.4 (Joomla version) contains Drupal version of civicrm.config.php

texts:
I just downloaded and extracted https://download.civicrm.org/civicrm-4.7.4-joomla.zip. Within /admin I found civicrm.zip. When I extract that and go into the civicrm folder, it contains civicrm.config.php. This file's code looks like Drupaly code, not Joomla-specific code. For example, line 36 is "function civicrm_conf_init() {". That's a Drupal function call ... the Joomla version of this file should look very different.

So my question is: is it correct that this file contains what look like Drupal functions? This appears to be preventing my CiviCRM cron jobs from running. The cron job errors out with:

"Could not load the settings file at: /var/www/public_html/administrator/components/com_civicrm/civicrm/../..//default/civicrm.settings.php"

I am pretty sure it is due to this civicrm.config.php being a Drupal version rather than a Joomla version. Seems the zip file needs to get updated to include the correct Joomla file.

EDIT: Just wanted to clarify that I was attempting to upgrade CiviCRM from 4.6.8 to 4.7.4, after which I encountered the above issues.


texts: Restricting discount code for 1 per registration

texts:
I don't want to limit the total amount of discounts available, I only want to limit how many can be used per registration.

For example, we have an event that costs $75. Only 1 ticket can be discounted to $0. I have created a discount code for $75 that can only be applied to the ticket. However, if someone buys 2 tickets, instead of discounting $75 of the $150 originally owed, it's coming up as $0 owed.

Has anyone else experienced this?


texts:
CiviCRM 5.15.1, WordPress 5.2.2

My org has been successfully sending bulk SMS via Civi/Twilio for a couple weeks, however we are having problems setting up inbound capability.

The Long Number we lease from Twilio is configured as shown below, with a callback URL as follows:
https://www.mydomain.org/?page=CiviCRM&q=civicrm%2Fsms%2Fcallback&provider=org.civicrm.sms.twilio

The problem is when an SMS recipient replies to a text sent from Civi, Twilio reports error 12200 - Schema validation warning ("provided XML does not conform to the Twilio Markup XML schema"). I understand it's not a fatal error, but I can't find the reply when I look under the senders' Activities. (Anywhere else in Civi I should look?)

Per @balleyne (WordPress Twilio Inbound SMS Callback URL failing when request method is POST), I changed POST to GET and re-tested but got a fatal error instead of balleyne's partial success.

Like balleyne and @CDS-Delano (in a comment to this post: Inbound SMS from Twilio not showing up in CiviCRM (getting 404 error on HTTP POST)), Twilio's debugger console shows that what it gets back from the inbound attempt is html instead of the expected xml (or TwiML?).

Following Chris Burgess's advice in that post, I checked the server and PHP error logs with our hosting provider but saw no red flags around the time the reply SMS was sent.

How have others fixed or at least troubleshot this issue, especially any non-coders (like me) out there?


texts:
I was wondering if it is possible to use (custom) relative date filters with the api?

For instance to find all participants of events in the current or last fiscal year.

Would save me a lot of trouble :-) Thanks fort thinking along!


texts: Error: Sorry an error occurred Supervised rule for Individual does not exist

texts:
I am trying to add a new member. Each time I enter the name and email I get the error message: Sorry an error occurred
Supervised rule for Individual does not exist

Does anyone know what this means and how I can get around it.

Many thanks!


texts: How do we implement meta description, Open Graph, and Twitter Cards for CiviCRM in Joomla?

texts:
Although I am soliciting ways to accomplish these things now, this is more of a feature request, as I'm fairly certain from other posts that high quality metadata for CiviCRM output has not been a development priority yet.

To enhance CiviCRM's usefulness and adoption (and perhaps therefore the number of developers) the following features would be ideal:

Render proper meta descriptions specific to each page
Render proper Open Graph meta tags for each page
Render proper Twitter Card meta tags for each page
Create a field to identify a primary image to be used by the above tags, which will be necessary for:

Each event info page and registration page
The event listing page
Each contribution page
Any other public-facing landing pages

Properly implement SEO URL routing in Joomla (and Drupal and WordPress)
Render proper canonical URL link tag for each page

Some of the functionality for #2 and #3 could be hacked in using the CRM_Utils_System::addHTMLHead method, however the meta descriptions (#1) can't be updated this way because they've already been sent by the CMS. We'd need something like the CRM_Utils_System::setTitle method to override it.

I've hacked a solution for #5 and #6 by altering /CRM/Utils/System/Joomla.php to write pretty URLs and setting up .htaccess to untangle it back into the messy Joomla/CiviCRM hybrid URL, which itself seems to be a hack because it doesn't conform to the CMS's MVC method, which creates other problems (bugs) where Joomla doesn't properly understand which menu Itemid is supposed to be active.

To the dev team: Thank you for all your fantastic work on CiviCRM 4.7! It keeps getting better every time. I hope these enhancements will make CiviCRM even more viable for more organizations.

Thanks!


texts: Why does the civicrm upgrade stop after each step of the upgrade eg at 4.7.19 then again at 4.7.20

texts: Not used to seeing this but one site just stopped at each step of the journey.


texts: SQL upgrade fails on 5.14.2 to 5.15.0 on Joomla

texts:
In upgrading from civi 5.14.2 to 5.15.0, the SQL update fails. In civi log, I get:

Jul 08 09:48:13  [info] Running task: Cleanup old files
Jul 08 09:48:13  [info] Running task: Checking extensions
Jul 08 09:48:14  [info] Running task: Begin Upgrade to 5.15.alpha1
Jul 08 09:48:15  [info] Running task: Upgrade DB to 5.15.alpha1
Jul 08 09:48:15  [info] Running task: Upgrade DB to 5.15.alpha1: SQL
Jul 08 09:48:16  [info] Running task: Fix errant deferred revenue settings

And then sql update dies and nothing else in log.

Relevant environment settings:

Database Version    5.5.5-10.0.38-MariaDB
Database Connection Collation   utf8mb4_general_ci
PHP Version 7.2.19

Any suggestions?

Here's the error log from civiCRM:

https://drive.google.com/file/d/1y4NWik-4fVWjflifgOIGsSXiU3NN0S2O/view?usp=sharing

And this is the on-screen error:

And here's a video walkthrough of the upgrade process, including which steps fail during the DB update:

https://drive.google.com/file/d/15MonHfW2TW_RbfhvbY2FIdB2Uao7poSH/view?usp=drivesdk


texts: Can you explain the relationship between groups, i.e a parent group

texts:
Can you explain the relationship between groups, i.e. a parent group

I have set up a new group which includes members who are also part of a larger group.  What does it mean if I set it so the larger group, i.e. volunteers, is the parent of the smaller group, i.e. Monday weeders?

Thanks


texts: Issue w/ partial payments, price set changes, pending refund status

texts:
Civi 4.6.20 and Civi 4.6.31 (tested in both, same behavior), Drupal 7

Here is the scenario:

User is registered on back end for event with multiple price set fields (call them Room Choice, Tuition, and Fee) with a $0.00 payment entered, which leaves them with the full balance owed.
User makes an initial payment toward the balance.
User then changes their mind about their room choice, so the admin changes the selections on Room Choice and Fee.  This decreases the balance BUT - important - the user still owes significantly more than they have paid.

The contribution's status - even though the contact still owes more than they have paid - gets changed during step 3 above from Partially Paid to Pending Refund.  So when the user's payment for the remaining balance comes in, the admin cannot enter it because Civi won't allow a payment of that amount (since it's pending refund).

Except for the user owing more than would be refunded, this scenario resembles this discussion: https://forum.civicrm.org/index.php?topic=36408.0  I'm really unclear where to go with this, however, and how to advise my client.  This does not seem like logical behavior on Civi's part; I totally understand the Pending Refund status if the changes to the registration result in a negative balance paid, but in this case no refund should be processed - the contact simply owes less money than they did.

Any ideas on how I or my client can proceed with this in terms of workflow?

Thanks in advance.


texts:
I would like to create an extension with civicrm. But I have a problem, although I could install civicrm and civix, I can not have where is the source code of the civicrm platform.
I go to the directory/var/www/ and I see no repertory civic, for when I run localhost:8080/ in my browser it displays the platform. For both the documentation we ask to put the directory of the extension to the root of the civic project for this to be taken into account.
I create an extension with civix with the following command: civix generate: module com.example.myextension --license = AGPL-3.0. I did a hello world but I do not know how to see the hello appears on the platform.
in fact I am going in: administration> system setting> extension but I do not see how to import my extension into the platform


texts: Is it possible to change custom group/custom field Entity Scope from just individuals to individuals and households (or ANY)?

texts:
I have an existing field for the donor name to show in printed materials. It was set up just for Individuals. The Custom Group has only this one field in it. Several reports/profiles/templates already use this field. I also want this same field available for households. If household data (or organization data) is pulled, I'd like to be able to have this field available, and I'd like to be able to update it. Table: civicrm_custom_group shows the help text for the column in question as:
extends
Type of object this group extends (can add other options later e.g. contact_address, etc.).   Individual is the value currently. Can it hold more than one type? Can it be changed? Is there a way to have the same custom field for more than one type of entity?


texts: Generate new entity in CiviCRM extension

texts:
I have same problem mentioned here: How to add a new entity in CiviCRM extension

I followed the documentation to generate skeletal files and completed steps 1 - 3. However I get stucked when following the point 4.
In point 4 I've been able to complete sub steps a,b,c but I'm getting the following error when trying to run the command from sub step d:

$ ./setup.sh -g

+ '[' -n '' ']'
+ '[' -n 1 -a -d /var/www/html/civi-demo/sites/all/modules/civicrm/bin/./../xml ']'
+ pushd /var/www/html/civi-demo/sites/all/modules/civicrm/bin/./../xml
/var/www/html/civi-demo/sites/all/modules/civicrm/xml /var/www/html/civi-demo/sites/all/modules/civicrm/bin
+ '[' -z 3306 ']'
+ PHP_MYSQL_HOSTPORT=localhost:3306
+ php -d mysql.default_host=localhost:3306 -d mysql.default_user=user -d mysql.default_password=pass GenCode.php schema/Schema.xml '' drupal

civicrm_domain.version := 4.7.29

Parsing schema description schema/Schema.xml
Extracting database information
Extracting table information
PHP Fatal error:  Class 'Civi\Core\Container' not found in /var/www/html/civi-demo/sites/all/modules/civicrm/CRM/Core/Config.php on line 113

The line throwing the error is the following:

\Civi\Core\Container::boot($loadFromDB);

Seems it tries to access the class Container in the global namespace but cannot find it.
I searched for the class and it exists in the following path:

/var/www/html/civi-demo/sites/all/modules/civicrm/Civi/Core/Container.php

What can be the problem?
Should I modify class CRM/Core/Config.php and add aditional code to try to access the Container class in a different way?

Thanks in advance!


texts: Search ajax script "not a valid JavaScript MIME type"

texts:
When a WordPress page editor plugin is activated (WP Bakery) I get the console errors on a page using the shortcode [civicrm component="profile" gid="14" mode="create" hijack="0"].

  The script from
  “https://example.org/civicrm/?page=CiviCRM&q=civicrm/ajax/l10n-js/en_US&cid=13243&r=nPFxX”
  was loaded even though its MIME type (“text/html”) is not a valid
  JavaScript MIME type.

  SyntaxError: expected expression, got '<' on line one of the dcocument

The page uses the Classic editor, not WPBakery. I've tried various plugins to disable the WP Bakery plugin on that one page, with no luck.

Disabling WP Bakery for the whole site allows the shortcodes to work; but it can't be deactivated due to client usage. I'm also trying to work with WP Bakery support.

As a result of the errors, no CiviCRM search results are returned.

Any ideas?

No errors in any WP or CiviCRM error logs.

Going directly to the URL of the Javascipt doesn't load the script, but loads the entire page.

Is it possible to enqueue the CiviCRM script in the footer or change its load order to help troubleshoot?


texts: My boss wants to start using CiviCRM.  We are a nonprofit organization for veterans.  I am not familiar with Drupal and I am toying with a demo of CiviCRM and I am wondering how do I customize it to our needs. I am computer savy but do not like coding too much.  Just wondering if any one can help once we download it and implement any changes we deem fit.  Any advice or help will be greatly appreciated.


texts: Change Email Address and Name Fields from required to not required during uploading of records

texts:
Newbie here :)

It appears that the following fields are required when you upload records:

First Name
Last Name
Email Address

I have records to upload that some of the records do not have a First Name, Last Name and/or Email Address.

Is there a way to change these fields from required to not required in the uploading portion?

If I am incorrect about this, please let me know. :)

Thank you,

LAE


texts:
Civicase Tokens Extension does not have documentation.   I am trying to use the tokens to do a print/merge of case information.  The print page is blank.

Any suggestions?   Have case tokens been used in this way?


texts: CiviCRM + Webform + Paid Events - no price displayed in table

texts:
I'm using Webforms for events because I have a parent/carer booking up to three children onto a holiday club.

I am struggling with the price. I have a contribution page set up (I've tried with and without a price set), and I have the Participant fee exposed with the values defined (user select: 1 day, 2 days or 3 days).

When I click 'Next' to display the contribution page/table, it always says 0.00 with no row in the table to display the price of the event registration. I can't see anything similar online and I'm not sure what I'm missing?

Possibly a separate issue: I'm using PayPal Standard as the payment processor but when I 'Submit', it' doesn't go to PayPal's website to take the payment. Is it compatible yet?

If I add a 'Contribution Amount' field, it adds that to the table - in the meantime, I'm using conditionals to populate this field. I wasn't expecting to need that field.


texts: How does one stop people who haven't paid (pending from pay later) from filling an event?

texts:
We are running CiviCRM 4.5.3 on Joomla! 3.3.3.

As the question says, we want to know how to stop people who haven't paid (pending from pay later or incomplete transaction) from filling an event.

If, for example, an event is set for 16 registrants and 15 have booked and paid and 1 is still pending from pay later, then bookings close. No one can book online; it says the event is full.

We don't want that to happen. We want anyone who is pending from pay later or an incomplete transaction to NOT count towards the total registrants for the course.

In this way, what we want to do is enable someone to come along, book online and pay immediately, and take the place of anyone who hasn't paid yet.

This used to be how it worked in our old version of CiviCRM, so we know it's possible!


texts: Keep getting "invalid email" message on any Civicrm/Joomla operation, such as register new individual or org address, or anything requiring email

texts:
Our email address is definitely valid, and everything else seems to set up fine in Civicrm in Joomla, but our org's email address always comes back as invalid.

The only clue we have is that when we became a Civicrm member, we used a different (personal) email address. Is that the problem? Or something else?

We get "Confirm from email error and configure event - civicrm/civicrm/packages/HTML/QuickForm/Rule/Email.php on line 58"

Thanks for any advice!


texts:
We want to implement a SMS gateway for a client and we are wondering about which one to choose.
I found and read this post from 2016 and I'd like to know if there are new solutions or positive feedbacks with one of the four providers mentioned.
SMS would be sent / received in France.


texts: Test drive keeps asking to select membership option

texts: I have an option selected but its staying I need to select one.


texts: Create contact report with last added contacts

texts:
I'm trying to achieve something that sounds trivial. In order to take a look and quantify how many new newsletter subscriber we have, I want to create a contact report listing all contacts belonging to a group (corresponding to a form), filtered by "added_date". Although this date information exists when I consult a contact, I can not find how to filter my contact report!
Thanks for your help!


texts:
Currently using CiviCRM 4.1.11 and Joomla 4.6.8.

We're looking to set up a newsletter and that will require an unsubscribe page. I gather that you use a token to set up an unsubscribe link but does that actually set up the unsubscribe page or do I need another way?


texts:
This is I'm sure specific to WordPress as I get the impression from reading that ACLs in Wordpress are as well developed as in Drupal or Joomla.

Currently, to give someone access to the "Personal Campaign Pages" option under the Contributions menu you have to turn on the "Administer CiviCRM" access level. Which is kind of a problem as it turns on a whole bunch of other features as well.

Any advice on how I can set up an ACL for just managing PCPs?


texts: Bulk emails failing - showing as 'Running'. How to debug?

texts: Bulk scheduled emails are failing - they are shown as 'Running' but never finish - one mailing has taken a day and a half to send 30 out of 47 emails, and subsequent mailings are doing nothing.  The hosting company can't see a problem, so my guess now is that Civi is choking on a database problem.  I can start a mailing job manually in the UI and it starts but never finishes.  There is a plethora of civicrm_mailing_* tables to look at.  The civicrm_mailing_spool table is empty, and civicrm_mailing_queue has over 41k rows.  Mailer batch limit is set to 120, everything else defaults, we're using the same server to send the emails (no Mailjet or similar). Civi level is 4.6.10 with Drupal. Can someone give me a guide or hint where to look? Which tables..?


texts:
Has anyone encountered this error on a CiviCRM Event:

Sorry but we are not able to provide this at the moment. Cannot read unrecognized property CRM_Core_Config::$mapGeoCoding

I'm using civi version 4.7.13. I changed the Mapping and Geocoding Providers Settings. Google is the Geocoding Provider and I added a Geo Provider Key. When I save the settings the error disappears but the map does not display on the page and eventually the error returns


texts: CKeditor security issue--does it impact CiviCRM and what to do?

texts:
Drupal security reported
Project:
Drupal core
Date:
2021-May-26
Security risk:
Moderately critical 14∕25 AC:Basic/A:User/CI:Some/II:Some/E:Proof/TD:Default
Vulnerability:
Cross Site Scripting
Description:
Drupal core uses the third-party CKEditor library. This library has an error in parsing HTML that could lead to an XSS attack. CKEditor 4.16.1 and later include the fix.
What should CiviCRM uses do regarding CKeditor within CiviCRM? Is the library installed or is it served via CDN and updated to the latest version?


texts: Can I import a drupal block into a mosaico mailing template?

texts: I'd like to be able to pull in drupal blocks. e.g. index of latest news. Is that possible?


texts: Why does CiviCRM ignore PayPal IPN parameters and just copies first transaction?

texts:
Civi sends to every recurring donor an email which includes a way of changing their recurring donation, including amount. This information is sent to PayPal to be used on the next transaction.  And when the IPN is received by CiviCRM, PayPal sends the new amount information, which Civi ignores and just retrieves the information of the first contribution of the recurrence and uses that information instead.  I'm having to fix dozens of transactions on a monthly basis due to this strangeness.  Conveniently, I've got a SQL script that updates all the tables, including financials.

But I shouldn't have to do this.  Civi should use the parameters sent by PayPal, but it isn't.

Version is most recent at the time of the message: 4.7.29


texts: CiviCRM API page not displaying in Drupal

texts: I am developing for Gsoc this year and i got up one day to use the API explorer but the page somewhat fails to load. below is a screen-shot of the display


texts: I have been advised several times for security reasons to create an htaccess for the admin folder in Joomla. However I have yet to figure out how to do this without breaking civicrm. I have included all exceptions that I currently have in the htaccess in the root folder but dashlets do not work, nor can event pages be viewed. I do not know a lot about htaccess, can anyone give me the correct exceptions? Thanks very much


texts: Is there a payment processor extension for Worldpay or do we need to create one?

texts: Do we have a extension already in the community which allows us to use Worldpay as a payment processor? I have not found one. Do we need to create new payment processor extension for Worldpay?


texts: Using CiviCRM with Security Pro iThems plugin - page not found for contribution pages after SSL certificate loaded

texts:
I'm running the security pro plugin, created by iThemes, as I do with many of my wordpress sites. One of my many security steps I run through is "Hide Login Area" however once changing the standard wp-admin directory it seems my CiviCRM plugin has difficulties processing secure SSL forms due to that plugin wanting to access the now non-existent "wp-admin" connection.

It comes to a not_found page and only started happening after the ssl certificate loaded and civicrm told to redirect contributions pages to ssl.

Is there a way to work around this in CiviCRM?


texts: database error when finishing update to 5.32

texts:
I'm running CiviCRM in Wordpress 5.6
I tried upgrading from CiviCRM 5.21 to 5.32 following this process: https://docs.civicrm.org/sysadmin/en/latest/upgrade/wordpress/
Now, the last step is visiting the update page, but there I get this error message:
Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
DB Error: unknown error
 Fehlerbeschreibung
Datenbank-Errorcode: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable), 1419
Zusätzliche Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EACH ROW BEGIN END [nativecode=1419 ** You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)]
    [type] => DB_Error
    [user_info] => CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EACH ROW BEGIN END [nativecode=1419 ** You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EACH ROW BEGIN END [nativecode=1419 ** You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)]"]
)

What could I do next? System Status says
Database Upgrade Required
New codebase version detected. You must visit upgrade screen to upgrade the database.

thanks, geb


texts: can you import dummy data into civicrm spark

texts: is there a way to import dummy data into civi crm grants feature?


texts: Why is my Unsupervised Individual Deduplication rule failing to stop duplicate creation?

texts:
I've seen a number of questions on this site suggesting that there may be problems with the deduplication rules, e.g.:
Why am I getting duplicate contacts for contributions?

My individual unsupervised rule checks against first name, last name and email address. No length is set for any field, all have a weight of 10, and I've set the threshold at 25. When I run this rule as an administrator it successfully finds the duplicate records, although the results list present the 'Threshold' as '30' when I display that column, which seems rather odd (maybe it is reporting the score rather than the threshold?).

But when users are registering for events through the standard registration form, duplicate contacts are consistently being created.

How can I ensure that my unsupervised dedupe rule works as I expect it to?

Running CiviCRM 5.13.5 on Drupal 7


texts:
I am using a Civi install that was originally part of a Drupal installation. A month ago I switched over to using Wordpress and migrared the Civi install to Wordpress.

Since then, something weird has been happening with event registrations in CiviCRM.

Previously, under Drupal, if two people registered using the same email, it would create separate contacts for each person. Or, if someone registered using an email that was already in the database, it would do the dedupe search and either count it as the person if the first name, last name, and email matched, or else it would make a new contact if they didn't match perfectly.

Now, however, it automatically overwrites any previous entries when someone registers using an email that is already in the database. This is fine when it's clearly the same person, but for some reason, it is now overwriting even when a single part of the name is the same. So, for example, Bob Smith smith@company.com registers. Then Mike Smith mike@college.edu registers. Looking at the registrations, I now have 2 registrations for Mike Smith, and there is no registration for Bob Smith. Even just the same last name has caused the first name and email to be overwritten.

I am using the same default dedupe rule, but for some reason it is acting differently now. Does anyone understand what is going on, or how I can fix this so it behaves the way it used to?


texts: The "Recent Items" list covers some of the buttons in CiviCRM.  How can I empty the list of "Recent Items"?


texts:
On civi 4.7.27 and wordpress 4.9

After recently upgrading both civi and wordpress I have noticed an issue that I have not been able to resolve.
On the contribution pages, if I have Membership section enabled AND Contribution Amounts section enabled, everything works fine. If I have just Membership section enabled, everything work fine.  However, if I have just the Contribution Amounts section enabled, after submitting the contribution, users will land on an error 500 page. The contribution will be completed and the record will be stored in civi,but the confirmation email will not be sent.  After hours of trouble shooting I have narrowed it down to: this only happens when the Contribution Amounts section is enabled by itself. Everything was wirking fine, until the recent upgrades. The error logs I can find are not giving me any useful information.
Does anyone have any ideas?

Thank you.


texts:
Error message when I run
http://example.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/upgrade&reset=1

Does anyone have any ideas?

Initialization Error

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

[code] => -18
[message] => DB Error: no such table
[mode] => 16
[debug_info] => SHOW COLUMNS FROM civicrm_domain LIKE 'config_backend' [nativecode=1146 ** Table 'edifideo_wp398.civicrm_domain' doesn't exist]
[type] => DB_Error
[user_info] => SHOW COLUMNS FROM civicrm_domain LIKE 'config_backend' [nativecode=1146 ** Table 'edifideo_wp398.civicrm_domain' doesn't exist]
[to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info="SHOW COLUMNS FROM civicrm_domain LIKE 'config_backend' [nativecode=1146 ** Table 'edifideo_wp398.civicrm_domain' doesn't exist]"]

)


texts: Outlook For CiviCRM - How to bypass activity confirmation dialog?

texts:
Background: When Outlook For CiviCRM is properly installed, configured and enabled, a confirmation dialog titled Confirm Activity appers for every email that is going to be sent. We would like very much to use this extension, but in our daily business can't afford this extra step and the delay caused by it.

Question: Is there a way to setup a default confirmation for this Confirm Activity dialog?


texts: How to access the APIv3 from wordpress plugin files

texts:
I'm developing a little wordpress plugin which creates a custom post type with a custom field where I would like to store an ID of one of the active contribution page of CiviCRM in order to associate this content with the contribution page information.

This very same code works in theme files but fails when is used in plugin files, breaking the site.

   function get_contribution_info($f_type){
   $params = array(
       'version'    =>  3,
        'financial_type_id' => $f_type,
        'is_active' => '1'
    );
    try{
       $result = civicrm_api3('contribution_page', 'get', $params);
    } catch (CiviCRM_API3_Exception $e) {
        // handle error here
        $errorMessage = $e->getMessage();
        $errorCode = $e->getErrorCode();
        $errorData = $e->getExtraParams();
        return array('error' => $errorMessage, 'error_code' => $errorCode, 'error_data' => $errorData);
    }
    return $result[values];
    }

    $get_contrib = get_contribution_data( '1' );
    $contributions = array();
    $i = 0;
    foreach($get_contrib as $c) {
        $contributions[$i]['label'] = $c['title'];
        $contributions[$i]['value'] = $c['id'];
        $i++;
    }

I've tried to add a require_once the class.api.php without positive results.

Thanks in advance for your help!


texts: Show full county name rather than the abbreviated form

texts:
Appreciate it's a US-bias, but can't find a way to stop the abbreviation of County, eg Essex becomes ESS.

What have I missed?


texts: Can a recurring email be setup to send to a group?

texts: Can an email to a group be setup to send every week?  We have a weekly event that we want to send the same email to attendees reminding them to come.


texts: Setting note privacy to groups instead of just author

texts:
[On Civicrm 5.19.1, Drupal 7]
Is it possible within Civicrm to make a new privacy setting that limits viewing notes to an entire group, and not only the author?

We would like all tarification people to be able to see each other's notes on a contact, but not our clients.

I've seen here and here that it was not implemented yet by 2011, but has it become possible since?

I have added the screen with the heading "edit Privacy level for notes Option" (Notes tab>Add note>wrench). I anticipated being able to add group privacy here, but I don't see how to specify anything.

I've seen this PHP hook, is the only solution using this in additional PHP code?


texts:
I have a profile setup as a directory in WordPress (5.1.1 w/CiviCRM 5.11.0). I set the profile to show the edit link to those who have permission to edit. I have an ACL setup for editors to edit specific contacts. A couple things are happening.

The edit link shows on all contacts, even those who the logged in
user does not have permission to edit according to the ACL.
If you click an edit link that the user does not have permission to
edit they get redirected to the site home page.
Edits work fine for contacts the user has permission to edit.

Seeing the Edit link is not a big deal for this application. The redirection when they do not have permission is going to cause confusion.

I have tried this on two separate sites with the same results.


texts:
When are civiVolunteer database tables created? When I run a search on volunteer opportunities and when a donation is made to our organization, we get database errors saying that tables civicrm_value_civivolunteer_5 and civicrm_value_civivolunteer_7 are missing. An inspection of the database reveals that we have a table called civicrm_value_civivolunteer_3, but that's it.

I cannot disable civiVolunteer without an error, which is another clue that something is wrong with the civiVolunteer installation.  I recently took over this website, so I do not know any of the specifics of the installation. I just need to fix the problems.

So, does anyone know what I need to do to get the missing tables in place? Will reinstalling civiVolunteer be enough?


texts: Installing Civi as a standalone site vs part of your existing site

texts:
I was just looking for some opinions regarding installing Civi in a current wordpress webpage (the non-profit's front facing regular ole website) versus creating a separate Wordpress installation to specifically house Civi.

Are there any major pitfalls to a separate directory?


texts: Where do I find the saved filed mapping I saved in Step 3 of 3 when saving export of participants list?

texts:
In Find Participants I have selected the fields I would like to export
At Step 3 of £ to give the options to Save the Mapping with a Name and Description which I have done and suggests
"If you want to use the same export setup in the future, check 'Save this field mapping' at the bottom of the page before continuing. You will then be able to reload this setup with a single click"
But where do I now find this saved mapping to run this again?
Sorry very new to CIVICRM and not a techie


texts: Can not add Relationship to contact post CiviCRM 4.7.30 upgrade

texts:
Although, I had orignally thought the issue was on the "Webform CiviCRM Integration" module end, further testing shows it is likely an issue on the CiviCRM end since when I manually try to create the relationship I end up with a "spinning wheel" and a page refresh gives the following error:

"unknown relationship create error API (EntitySetting, get) does not exist (join the API team and implement it!)"

Any insight?


texts: Is there a way to set a cap (maximum participant) number within the price set field?

texts: I was hoping to find out if there was a way to set a cap on the price set field rather than the event. For our summer camp, we have a morning and afternoon session that you register for under the same event, but can pay which session you want. We were wanting to set a cap on both the morning and afternoon session. Since they aren't their own event, I didn't know if this was possible.


texts: Why are Civi Events and Activities in Drupal Views Calendar showing incorrect times

texts: Titles says it all. There are issues with how CiviCRM handles timezones which means they get displayed on calendars incorrectly.


texts: How to export members addresses into spreadsheet for a mailout?

texts: How do I extract members' addresses in our system onto a spreadsheet for a mailout?  Thank you so much!


texts: How To Apply Membership Type Update To Existing Records

texts:
i have a set of membership records set to expire every two years. So i have a lot of members whose expiry date is set to 2 years.

Now i have updated membership type to 1 year expiration. I find that only new members inherit the new expiry date but not the old records. How can i update the old records membership to reflect the changes.


texts: CIVICRM mailing links not working properly in schedule job

texts:
When a TEST mailing is sent with tracking link clicks enabled, then the URL DOES NOT include "public_html/"; however, when the mailing is scheduled and sent with tracking link clicks, then "public_html/" is INSERTED into URL.

Wordpress Version --> 4.9.2
CIVICRM Version --> 4.7.27


texts: Settings Definition (How to Use On_Change?)

texts:
Settings definitions allows for a field "on_change". Can anyone explain how to use this? I would like to have it execute a function that I have defined in my extension when my quickform is saved.

THanks!

Documentation Referenced: https://docs.civicrm.org/dev/en/latest/framework/setting/#settings-definition


texts: What to do when online event registration doesn't process?

texts:
We have an event that requires online registration with a fee. It was working well up until today. We have some folks registering, after inputting all their information and hitting submit, the "submit" button goes gray and says "processing" but never processes it.

I've looked through our payment processor, price set, all should be set up correctly. Any other ideas?


texts:
A user handed me a printed sheet from a previous database and asked me to recreate it. It contains contact information, a list of contributions, the most recent memo, and several blanks to be filled in during a renewal call (call response, pledged donation, written notes, some checkboxes, etc.). And it must be printed as a hard copy.

So I think what I'm looking for is a way to combine report data and fill-in-the-blank fields in one sheet. The "Constituent Detail" report works well for the former, but I'm stumped on getting the latter included on the same page. Anyone have a clever suggestion?


texts: Reminder for Incomplete Registration (and continue...)

texts:
Is it possible to track incomplete registrations in CiviEvent and send someone a reminder email, that would allow them to finish their registration?

I recently saw this on another Event Registration Platform. It was multistep, so Step 1 was entering an email address to continue. This would facilitate the system.

If you don't complete the form/pay, you are sent a follow up email with link that lets you complete your registration.

In a Drupal/CiviCRM environment, would this be possible somehow if CiviCRM could not cover the use case?


texts: How do I create a token that automatically gets urls convert to trackable links?

texts:
This is kind of the opposite of Integrating CiviMail tracked links with Google Analytics

In other words, I'm generating html for civimail using tokens, and the html includes links, but those links are not getting converted into trackable links. I think there's probably some code I could include in my hook_civicrm_tokenValues function to convert my embedded urls into trackable links, just like the Civi core code does. Or maybe I have to tell Civi that it's okay to do this using some settings?


texts:
Updated to version 2 of the extension.  Messages not being delivered.  Manually executed.  Will clickatell extension work on 4.6.2?
Success is reported but message never sent.  Here is error from the log:

May 19 04:24:40  [info] $Fatal Error Details = Array
(
    [message] => Unknown extension: org.civicoop.smsapi
    [code] =>
    [exception] => CRM_Extension_Exception_MissingException Object
        (
            [errorData:CRM_Core_Exception:private] => Array
                (
                    [error_code] => 0
                )

        [cause:protected] =>
        [_trace:PEAR_Exception:private] =>
        [message:protected] => Unknown extension: org.civicoop.smsapi
        [string:Exception:private] =>
        [code:protected] => 0
        [file:protected] => /home/depot/public_html/drupal/sites/all/modules/civicrm/CRM/Extension/Container/Collection.php
        [line:protected] => 143
        [trace:Exception:private] => Array
            (


texts:
Is there a way to increase the size of the Relationship Notes field?

In 4.6, it appears to be stored in the varchar(255) "description" column of the civicrm_relationship table. Nevertheless, Webform-CiviCRM integration let us use a textarea as a widget for this field, and now that the client has become accustomed to the idea of using this field for longer content.

I tried simply increasing the column size in the database and flushing caches, but it does not seem to make any difference by itself; submitting the webform to create the relationship results in the same error:

  The CiviCRM "relationship create" API returned the error: "Value for description is 884 characters - This field has a maxlength of 255 characters." when called by function "preSave" on line 187 of wf_crm_webform_postprocess.inc with parameters: "Array ( [relationship_type_id] => 17 [is_active] => 1 [start_date] => now [description] => 884-character description went here [contact_id_a] => 26305 [contact_id_b] => 13475 [is_permission_b_a] => 1 [is_permission_a_b] => 0 [check_permissions] => [version] => 3 ) "

The site is a Drupal 7.44 / CiviCRM 4.6.19 site, with Webform 7.x-4.x-dev and Webform-CiviCRM Integration 7.x-4.15. The ability to add case relationships was added back in 7.x-3.x.


texts: Some people have asked to be removed from our email list.  How do I do that? I've tried just deleting the name but I can't make it permanent


texts: Search Builder One of parameters is not of the type MysqlColumnName

texts:
Drupal 7.43 / CIVICRM 4.7.7

I am trying to find contacts with no emails (any type eg/ Home, Other) using Search Builder. Using either IS EMPTY or IS NULL, I end up with no result but get a DB error.
Viz:  Sorry but we are not able to provide this at the moment.
One of parameters (value: Home-email) is not of the type MysqlColumnName

It doesn't seem to matter what operator I use, the result is the same.
Please help. Ian