texts: Wordpress Civi install keeps puking with "canary" and simplexml_load_file() error

texts:
WP: 4.8.1
CIVI: 4.7.23
PHP 7.0.22ubuntu0.16.04.1
Ubuntu 16.04.3 LTS

Installation proceeds and then the CiviCrm page 500s.

[Sun Sep 03 17:24:57.841003 2017] [:error] [pid 2943] [client 24.1.98.245:49332] PHP Fatal error:  Uncaught Error: Call to undefined function simplexml_load_file() in /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Menu.php:116

Stack trace:
#0 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Menu.php(95): CRM_Core_Menu::read('/var/www/html/w...', Array)
#1 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Menu.php(175): CRM_Core_Menu::xmlItems(true)
#2 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Menu.php(283): CRM_Core_Menu::items(true)
#3 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(372): CRM_Core_Menu::store()
#4 /var/www/html/wp-content/plugins/civicrm/civicrm/api/v3/System.php(49): CRM_Core_Invoke::rebuildMenuAndCaches(1, 1)
#5 /var/www/html/wp-content/plugins/civicrm/civicrm/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_system_flush(Array)
#6 /var/www/html/wp-content/plugins/civicrm/civicrm/Civi/API/Kernel.php(169): Civi\\API\\Provider\\MagicFunctionProvider->invoke(Array)
#7 /var/www/html/wp-content/plugins/civicrm/civicrm/ in /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Menu.php on line 116, referer: http://mackenzie.southsidescout.com/wp-admin/admin.php?page=civicrm-install

[Sun Sep 03 17:25:10.472533 2017] [:error] [pid 2944] [client 24.1.98.245:49338] PHP Fatal error:  Uncaught CRM_Core_Exception: [0: Found installation canary. This suggests that something went wrong with tracking installation process. Please post to forum or JIRA.

thrown in /var/www/html/wp-content/plugins/civicrm/civicrm/Civi/Core/InstallationCanary.php on line 53

[Sun Sep 03 17:25:21.322206 2017] [:error] [pid 13881] [client 24.1.98.245:49342] PHP Fatal error:  Uncaught CRM_Core_Exception: [0: Found installation canary. This suggests that something went wrong with tracking installation process. Please post to forum or JIRA.

thrown in /var/www/html/wp-content/plugins/civicrm/civicrm/Civi/Core/InstallationCanary.php on line 53, referer: http://mackenzie.southsidescout.com/wp-admin/

Any thoughts?  Permissions appear clean


texts: CiviRules - where is the data stored in the database? - backdating

texts:
I've got a CiviRule that triggers when a membership is added and is delayed by 3 months, but i want to back date it for existing memberships, ie any membership less than 90 days old (if it was 88 days old, my rule would act in 2 days time)

Assuming there's not a clever way of doing this up front, i'm happy to manipulate things directly in the database, but haven't found anything but the civirule_rule_log which actually changes on triggered conditions - where is the part that acts?

thanks!


texts: Why are contacts getting multiple membership scheduled reminders?

texts:
We saw this with a WordPress 4.4.2 CiviCRM 4.6.14 instance.

A reminder was sent every time cron was run.

This is not related to Why is Scheduled Reminders sending multiple emails but not creating an activity? an activity is created every time a reminder is sent.


texts:
Rookie here. Installed CiviCRM WordPress plug-in, and it works great. We've given permissions to several people for entering contact data, events, etc., however, I would prefer they not go in through the WP dashboard, to keep them from accidentally messing up the website from poking around.
Is there a way to create a WP log-in page for them so they can get into CiviCRM without going through the WP dashboard? If it's in the setup, I'm afraid I didn't find it.


texts: Some donor wants a receipt of their contribution printed. I could not find any option other than printer icon on the top right. But that gives a very barebone format. What is the best way to go about it, please? Thanks


texts: Tutorial for: "CiviCRM Event OG Config (sample)" Module

texts:
How does this integration work? What is required to set it up? Documentation is very sparse.

If we want every CiviEvent to have a corresponding OG with the participants synced - is this the solution? Or, is CiviRules/CiviEntity a better route?


texts: Thank-you letter incorrect contribution currency

texts:
My setup: CiviCRM 5.20.0 on Drupal 7.

I entered contributions in different currencies.
In Find Contributions, check some entries. At Actions select Thank-you letter print or email.

I put tokens Contributions:

{contribution.currency} {contribution.total_amount} {contribution.fee_amount} {contribution.net_amount}

and it gives me lines like these:

CNY HK$ 1,299.90 HK$ 0.00 HK$ 1,299.90

GBP HK$ 500.00 HK$ 0.00 HK$ 500.00

where CNY and GBP are the currencies of those contributions and HK$ is the symbol of the default currency.

It seems the amounts variables just took the system default.

Would you suggest some work-around? e.g. how to strip the wrong currency symbol.

Thank you.


texts: How to include an opt-out link (with token) in a reminder?

texts:
I'm new to working with Scheduled Reminders, and am trying to figure out how to include our org's standard forward, opt out and sent-from info in each reminder, as we do with bulk Civi emails.

Our email template includes this:

====

To forward this to a friend {action.forward} To never receive any email from the RFC {action.optOutUrl} This email is sent from: {domain.address}

But those tokens don't seem to work when I copy and paste into reminders. I don't understand why, or how to properly set up forward, opt out and sent from address in reminders.


texts:
We use price sets for our events, as we need to have a registration price that is the regular price, one that is the early bird price, and then a third item that is the textbook that you can choose not to purchase (like if you have it already). Price sets have been working fine until this evening. I just went to add one, which was number 380. Adding it worked fine - it's there on the list. But when I go to the event, it is not on the list of price fields that I can add. I tried adding new ones multiple times, but this happened every time. I also noticed that several of our old ones no longer show the event they are linked to on the page where you can edit the configuration for the price set. If you go to the event's tuition tab, sure enough it doesn't list one there.

Any idea what could be causing this? As a temp fix so I could add new events, I'm re-using an old price set.

The screenshots: We replace the word "Event" with "Training, so that is why it says that. The list on the drop-down on the event setup page (screenshot 2) always shows in the order in which they were added as a price set. Nothing shows up after the one for Mesa (was number 379). I've created like 10 more - both cloning current ones and creating new - and they never show on the drop down list.

We're on Drupal and version 4.7.22. Planning a major upgrade soon, but we had to finish another large task first that is about 85% done before I can switch gears to the Civi upgrade.


texts: User account fields missing from create user account profile

texts:
I've built two profiles to create user accounts
1) Volunteers
Adds contacts to volunteers group to sync with volunteer role
2) Volunteer Managerss
Adds contacts to volunteer managers group to sync with volunteer managers role

Both worked fine last week

Went to review the Vol manager profile today and none of the user acct fields (choose username, enterpassword etc) were visible on the profile. But the fields still showed in the volunteer profile.

Have been tinkering with profile settings, saving and unsaving. Can't make them reappear.

Both profiles have same settings:
profiles set as standalone form.
acct creation required checked.
Site visitors can create own accounts set in drupal config.
anon users can use profiles in create mode in drupal permissions.

Went to look at the volunteer profile a few minutes ago, and although it was showing user fields earlier, now the fields are missing from both profiles.

Gah!

Any help/ suggestion will be much appreciated!

drupal 7.59
civi 5.3.1


texts:
Using CiviCRM 4.7.1
Some of the field names in our registration form are so long that, on the form the attendees use, they are truncated. Also on the confirmation messages. Either truncated or overtyping the data. Can the field names be wrapped?
The field names shown are "SS Dance Class - 1st choice" and "... 2nd choice", etc.


texts:
I have a word doc (ODT) that uses Tokens and works fine when I am in and choose the file from my device to Print/Merge - it creates a beautiful merged document.
When I go to message template and create a new template using the same .ODT file - When I go to use it on a contact - the resulting message is blank.
Is there something I am missing here?
Thanks.
Civi 5.29.1 on Joomla 3.9.23 but I am not sure that is the issue here


texts: Confusion about theming and version - Shoreditch?

texts:
I need some advice on the theming of my instance of CiviCRM.  I have done some research and have seen this theme and I'm not sure of the following

Is it version based?
Is it CMS based - depending on the CMS you are using?
Or is it a setting inside CiviCRM - I am currently using 5.25.0

I'm looking to move from the before to after.
Thanks in advance for the advice,
E
:


texts: Mailing stopped working after CiviCRM, PHP and Drupal upgrade

texts:
Recently I upgraded:

Drupal core to 7.57

PHP from 5.6 to 7.0.28-1

CiviCRM from 4.7.27 to 4.7.31

Since I've done so I can't send mailings.
Basically I get the same thing like in the post described here

When I select a group to send the mailing to, it says no recipients. And when I click send the mailing is listed as completed with 0 deliveries.

This is what I get in my php error log

  [Tue Mar 27 10:02:14.592307 2018] [:error] [pid 10110] [client
  ip:45513] PHP Fatal error:  Uncaught Error: Call to undefined function module_invoke_all() in
  /var/www/mysite/sites/all/modules/civicrm/CRM/Utils/System/Drupal.php:857\nStack
  trace:\n#0
  /var/www/mysite/sites/all/modules/civicrm/CRM/Utils/System.php(1413):
  CRM_Utils_System_Drupal->onCiviExit()\n#1
  /var/www/mysite/sites/all/modules/civicrm/extern/url.php(62):
  CRM_Utils_System::civiExit()\n#2 {main}\n  thrown in
  /var/www/mysite/sites/all/modules/civicrm/CRM/Utils/System/Drupal.php
  on line 857, referer:
  https://mysite.org/civicrm/mailing/view?reset=1&id=709

I tried cleaning cache (drupal and civicrm) but it doesn't fix it. Rebuilding the smart groups didn't help either.

EDIT

This problem seems to be groups related and not mailing related. CiviCRM log is clean, and single mails work just fine.

EDIT2

However when I'm selecting mail recipients if I select recipients from previous mailings it counts them as it should but it doens't for groups (smart or regular).

EDIT 3

This seems to be an issue with multilingual installations.

The issue can be replicated by adding another language and then turning on Multiple Languages Support. After this the problem appears and disappears again when Multiple Languages Support is switched off.

4.7.27 was working, not sure whether the problem first appeared with 4.7.28, 4.7.29, 4.7.30 or 4.7.31

I updated this issue on Jira


texts: Drupal Webform Autocomplete Existing Contact Limit

texts: Is there a limit to the amount of contacts that can be searched for on Existing Contact using autocomplete on a Drupal Webform?  I have 1+million contacts.  If I restrict the webform to a group with a limited number of contacts the autocomplete works well.  However, if I do not restrict to a small group the autocomplete fails and wants to create a new contact.


texts: How does CiviCRM make the link between uploaded pdfs and the database table?

texts: I want to import many pdfs into Civi and so need to make the link between the uploaded pdf and the database table.  I used the UI to upload a sample pdf (calke_walk.pdf) and looking at the db table, the field in question contains an int(10) unsigned   with a value of 8.  The uploaded pdf has a file name of Calke_walk_a0e8f5791bb72c5b53c253f4fa66fd2f.pdf    In Civi's UI the file has a url that ends with &id=8&eid=28308  The clue there is the &id=8 I guess, but is there more to this that I need to know?


texts: How to retrieve custom field image files?

texts:
How can I retrieve images uploaded in custom field sets for contacts? Could you get a URL for them the same way you can for the contact "image_url" in the API?

When I look up the custom field for the file in the API, it just returns a number. I looked at the code docs for the Attachment entity in the API, but this seems to be more suited for non-image files, unless I'm mistaken. I am looking to call the API and display these images on a web page.

I'd appreciate any help I can get, thanks.


texts: ezcMailParser not able to retrieve bcc from a mail

texts:
Trying to process inbound mails that are bcc'd to abc@domain.com (Office 365).

Pasting the code we have at https://github.com/civicrm/civicrm-core/blob/master/CRM/Mailing/MailStore.php#L128-L138

$parser = new ezcMailParser();
//set property text attachment as file CRM-5408
$parser->options->parseTextAttachmentsAsFiles = TRUE;
foreach ($set->getMessageNumbers() as $nr) {
  if ($this->_debug) {
    print "retrieving message $nr\n";
  }
  $single = $parser->parseMail($this->_transport->fetchByMessageNr($nr));
  $mails[$nr] = $single[0];
}

When a mail is bcc'd from a Gmail account to abc@domain.com and Process Inbound Email job is executed, $mails correctly contain the email address in the bcc header.

But, when it is sent from an outlook account or Apple Mail, there is no bcc or any header that contains an information that our mail was bcc'd to abc@domain.com.

Does our email parser strips bcc information if the input is from a server other than Gmail?

Update -

If mail is sent from Gmail, headers look like - https://gist.github.com/jitendrapurohit/fa6a115c18b8bcfbb8346f58cd1265c0

From Outlook - https://gist.github.com/jitendrapurohit/176eee759cfc9b3688682ea99b6c3460


texts: "Cannot change contribution status from Overdue to Completed" (4.4.20)

texts:
We have a number of membership-related contributions that are in Overdue status, as they were promised but not paid on time. Now they have been paid, so in reality they are completed and no longer overdue.

When we attempt to edit the contribution we get the error message in the title. I understand that status transitions are restricted to preserve the integrity of financial transactions- but finally receiving an overdue payment sounds like a sensible transition (and we aren't using Civi for our actual accounts anyway, our finance officer uses a separate accounts package). Is there a correct way of doing this for end users, ie without manually changing it in the database? (We're using 4.4.20)


texts:
How can I sort groups by the date the individual was added to the group?

I can't figure out how to do it in either manage groups, search, or reports.


texts: Drupal Commerce checkout for CiviEvent registration?

texts:
Has anyone used Drupal Commerce's checkout process to process CiviEvent payments instead of the core CiviCRM payment processor?

I have seen a number of discussions about integrating CiviCRM with Drupal Commerce, but no concrete evidence that someone has successfully created a CiviEvent registration page that processes payments through the Drupal Commerce checkout engine.

I did a thought experiment and it seems possible to create a Drupal Webform that could tie together webform CiviEvent integration and webform Commerce integration. These modules exist, so it should be possible:

CiviCRM Webform Integration

Commerce CiviCRM Rules (on eileenmcnaughton GitHub https://github.com/eileenmcnaughton/commerce_civicrm_rules)

Additionally there is Webform Commerce integration, if needed.

Has anyone ever used this type of Frankenstein event registration setup?


texts: Performance Bug in Trigger Causing ~1000x Slowdown

texts:
While looking for the root cause of a performance issue for a client, I tracked it down to a couple of triggers performing an inefficient UPDATE statement:
civicrm_activity_before_update
civicrm_activity_before_delete
Original SQL (~4 seconds):
UPDATE civicrm_case SET modified_date = CURRENT_TIMESTAMP WHERE id IN (SELECT ca.case_id FROM civicrm_case_activity ca WHERE ca.activity_id = OLD.id);

~1000x faster SQL to do the same thing:
UPDATE civicrm_case, civicrm_case_activity SET civicrm_case.modified_date = CURRENT_TIMESTAMP WHERE civicrm_case.id = civicrm_case_activity.case_id AND civicrm_case_activity.activity_id = OLD.id;

I tracked this down to the following PHP file:
sites/all/modules/civicrm/Civi/Core/Container.php
The patch to fix the SQL payload in the file:
--- Container.php.orig  2021-04-12 11:30:35.039270421 +0100
+++ Container.php   2021-04-12 11:32:00.485650901 +0100
@@ -286,7 +286,7 @@
             'table' => 'civicrm_activity',
             'when' => 'BEFORE',
             'event' => ['UPDATE', 'DELETE'],
-            'sql' => "\nUPDATE civicrm_case SET modified_date = CURRENT_TIMESTAMP WHERE id IN (SELECT ca.case_id FROM civicrm_case_activity ca WHERE ca.activity_id = OLD.id);\n",
+            'sql' => "\nUPDATE civicrm_case, civicrm_case_activity SET civicrm_case.modified_date = CURRENT_TIMESTAMP WHERE civicrm_case.id = civicrm_case_activity.case_id AND civicrm_case_activity.activity_id = OLD.id;\n",
           ],
         ],
       ]

The bug doesn't manifest if you rewrite the UPDATE as a SELECT, but in the UPDATE form it takes an absurdly long time when a sub-select is used. Tested on MariaDB 10.4 and 10.5.
Any thoughts on this? Functionally the two queries are identical. What does it take to get this merged upstream?


texts:
Goal: Provide member discount pricing for some events and member exclusivity for other events.

I realize cividiscount can provide membership discounts - is it required or can it be achieved via price-sets too?

Can event registration be restricted by membership status (free or for fee)  Can't see how to do that with cividiscount.

I can do it with a specific civicrm-webform but wanted to see if I'm missing something in native civicrm.

I would guess that member-only events would be a common use case.


texts: What's the correct way to log debug info to log?

texts:
The "current" wiki says to use CRM_Core_Error::debug and says, "Most runtime errors are logged here, as well as data that you explicitly write to log using the CRM_Core_Error::debug log=true parameter."  However, if you set $log = true, that just does an echo.

An older version of the docs says to use debug_var - and this works correctly, but seems duplicative, and isn't mentioned in the current docs.

Should the documentation be changed?  Or should the code be refactored?


texts: how to resend a mailing to corrected bounce addresses?

texts:
so i did a mailing, a handful of bounces on a vip group, so we took the time to find why the email addresses were invalid and fixed them.

How can we resent this email to the corrected emails? I did try to clone the mailing and exclude the ones that received the previous one, but civi is removing all the contacts, even those that didn't receive it.


texts: Activity report showing activities twice

texts:
All of my activity reports have recently changed to return two entries for the same activity. I have looked under sorting and columns and filters, but cannot seem to disable the double entries. Please see a screen shot of a report which shows details from phone call activities.
This is happening for ALL activity type reports, so changing the particular activity makes no difference. On civi 5.4.0

I have added some more screen shots - hopefully this answers questions? many thanks. Also, I am using sort criteria as date and it makes no difference if I change filter for Limit to current User as Yes or No.


texts: Can Domain Access ensure that a civi 'admin' on domain-B can not login via domain-C and see contacts they should not see?

texts:
My recollection maybe wrong on this. Scenario is

main site A
subsite B
subsite C

Subsites B and C are created via Domain Access module and are correctly wired in to civicrm so that a contact created on siteB is added to GroupB and hence the subsite-admin on site B can log in to Civi but only see contacts in Group B.

Excellent.

What I am missing is how to ensure via Roles and Permissions (or something extra) that subsite-admin B cannot login in via subsite C (which they currently can and hence can see contacts in Group C)

I have looked at domain_roles and domain_login but neither give me what I expect.

Look forward to having the obvious missing link pointed out to me.


texts: Membership contribution page won't load in Chrome browser

texts:
Lately our membership new/renewal form will not load in Chrome (in my case Windows ver 79.0.3945.88). But it has been working correctly in Chrome for several years. I don't know what's changed.

I have just tested that the membership form comes up okay in:

Firefox 71.0 (windows)

Windows Phone 8.1

Safari on iOS 13.

System: civicrm 5.15.1, WordPress 5.3.2

Edit with more info:

When the membership page loads okay, there are no warnings or errors in the civicrm log. But when the membership page stalls, there is the warning in the log:

Jan 06 17:25:33  [warning] CiviCRM thinks site is not SSL, redirecting to {url}
Array
(
    [url] => https://idahonativeplants.org/membership/
)

I think this is a good clue, and the problem only affects Chrome. The bug only appears when you go to the home page, then use the Membership menu item. If you first visit another contribution page on the site, then use the Membership menu the membership form comes up right away. Weird.


texts: Views Proximity Search on Latitude / Longitude

texts: Has anyone used a proximity filter or sort in Drupal Views based upon a contact's geocoded address?  I think it would be doable with the GeoPHP module and a special handler, but I don't know if it has been done.


texts: Unable to upgrade in WordPress from 4.6.12 to 4.7

texts: I have a Civicrm installation that's been running for quite some time. I've never had an issue upgrading until now. I've been able to upgrade to 4.6.12, but then I try 4.7.0 or 4.7.1, all I get is "[]" on the progress screen. There's no error log generated. I'm running WordPress 4.4.2 with PHP 5.6.


texts: How can I preserve smarty date formating in message templates?

texts:
I have a message template that we use to print letters for those joining our association. We want to include the end date for their memberships in the letter (This used to be printed on membership cards, but we have ditched them.)

If I search for the new members and display the results as memberships, I can include the token {membership.end_date} in the letter but it displays as, say, 2016-12-27 which is not commonly seen in Australia.

Our site settings include define( 'CIVICRM_MAIL_SMARTY', 1 ); so the following code gives the formating I actually want:

Your membership expires on:{capture assign=mem_end_date}{membership.end_date}{/capture} {$mem_end_date|date_format:"%d %B %Y"}

Unfortunately this is somewhat temperamental.  If I save the template when it is displaying the code and the next time I open it I select 'Source'  before opening the template, then the formatting is correct.

However, if I save the template when it is displaying the code and then open the template before I select 'Source' the next time I use it, the " is changed to " (see below) and I don't get any end date printed at all.

Your membership expires on:{capture assign=mem_end_date}{membership.end_date}{/capture} {$mem_end_date|date_format:&quot;%d %B %Y&quot;}

Is there some other way I can write things so that it will retain the formatting I want without the person who will be running the letters having to remember to select source before opening the template?

This is a Drupal7/CiviCRMv4.4.16 site.


texts: I would like to be able to search for a specific Case Type as well as a Case End Date within this case type.  To give an example, say I have a record that contains both Case A (which ended January 2018) and Case B (which ended December 2018).  Right now, the advanced search is returning this record if I search for "Case Type A" AND "Case End Date December 2018."  However, I would like the search to NOT return this record, as the end date (December 2018) is not affiliated with Case Type A.  Is there a way for me to conduct such a search?  I'm using CiviCRM 5.13.4.


texts: I am getting a 502 when I try to access CiviCRM from my site. Is the server down? What does this mean and how can it be corrected?


texts: Using the answer in custom field (select) to auto fill other field

texts:
how would I get a custom field to automatically select from a list based on the answer given in a custom field where the answer has to be selected.

Basically the user selects the Scottish local authority field from a select list (Say, Edinburgh City Council). I want a field of MSP Regions - in this case Lothian Region - to auto fill based on the local authority.

Thanks.


texts: Help: Fatal error doing an export (Civi 4.7.4)

texts:
I have just upgraded my Drupal 6 site to the latest CiviCRM 4.7.4
All seemed to go well except that when I try to export contact records (using primary fields). I get the following fatal error:

Fatal error: Can't use function return value in write context in ../public_html/sites/all/modules/civicrm/CRM/Export/BAO/Export.php on line 435

Steps I followed:
1. Search for contacts
2. Select Export option
3. Select Export Primary fields
4. Press continue

Some help would be hugely appreciated!

Thanks
Davy


texts: How can I find out what the problem is with my failing CiviCRM installation in WordPress?

texts:
I am attempting to install CiviCRM 5.33.1 on a fresh WordPress 5.6 install. Installation and activation go fine, and I get to the installer page at /wp-admin/options-general.php?page=civicrm-install.
The reason for this new install is that we need to partition CiviCRM to a subdomain on the same shared server as our main site. So I edited the CiviCRM Database setting to use the same DSN as is in our current civicrm.settings.php file, which looks like this:
mysql://[DB user]:[password]]@[server]:[port]/[DB name]

(The CiviCRM database is separate from the main WordPress database on our main site.)
Then I click Apply. The page redirects to /wp-admin/admin.php?page-CiviCRM&q-cificrm&reset=1, which has the title CiviCRM Installed, but then immediately displays the message Sorry, you are not allowed to access this page. That sounds like a permissions problem, but CiviCRM, nor the civicrm folder in wp-content/uploads, isn't installed, contrary to the title of the page.
I can't imagine that it's a problem with the Civi DB DSN, since I copied it directly from the current installation. Or could it be? But how can I figure out what the problem is?
Thanks!


texts:
We are using CiviCRM to manage different kinds of contacts. Therefore we have some tags that are irrelevant to the "regular", non-admin users (e.g. "check membership fees" for a user who doesn't even have permission to view member contacts)

The tag list starts to become long and cluttered. Can I hide some tags (and their child tags) for some users?

Maybe something similar to hiding/showing a "set of custom data fields" using ACLs?


texts: How do you handle searching and reports on contributions with line items from Webform CiviCRM

texts:
Webform CiviCRM for Drupal 7 allows one to set multiple line items with different financial types for one contribution. In this case, a charitable donation and a non-charitable event ticket.
If I set the charitable donation as the primary contribution and the event ticket as the additional line item, this works fine to set the tax receipt correctly for only the amount of the charitable donation (if the non-charitable event ticket is primary, you can't send a tax receipt).
What I don't understand is how to handle contribution searches or reports in this case. If I want to know how much we received in donations last year, I would normally use a search or a report. However, I believe these would both now be incorrect as they would show a $X+Y donation, when I actually have a $X donation and a $Y event ticket. Does this mean I can only use line item reports and can't use regular contribution reports or contribution searches if I have contributions generated in this way?
Is there a way to create two separate contributions instead?


texts:
CiviCRM for WordPress 4.7.15

Problem: Fix the Email Greeting, so it takes advantage of the preferred language and gender fields. I took a look at:

https://wiki.civicrm.org/confluence/display/CRMDOC/Recipe+for+German+Name+and+Greetings+Handling

The page to edit the Email Greeting is hidden under Administration/System Settings/Option Groups - Email Type Greeting Options

I came up with the following which works nicely when used in a Smarty Message Template.

{capture assign=l}{contact.preferred_language}{/capture}
{capture assign=g}{contact.gender}{/capture}
{if $l="en_CA"}Dear{else}{if $g="Male"}Cher{else}Chère{/if}{/if} {contact.first_name} {contact.last_name}

To test it, one selects the new Email Greeting from the drop down on the Contacts Summary page in the Communication Preferences section. Then clicks Save. At this point, the CiviCRM says.

Any suggestions? I'm considering adding 3 Greetings and updating all 2697 records via SQL.


texts: Can Drupal Webform Integration update matching contacts

texts:
On the CiviCRM profiles you have the ability to set it update matching contact. I don't see this functionality with the Drupal webform CiviCRM Integration module. Is it there and I'm simply missing it? When I log in and fill out the form it simply creates a duplicate contact if that contact already exists. I would like to update the existing contact instead. Is this possible?

I still seem to be having an issue with duplicates being created. The unsupervised rule is set as such:

First name: 6
Last name: 3
Email: 4
Street address (First four characters): 1
The total for a match is 10

I had a contact in CiviCRM 'Janice Anderson' who did not have an associated Drupal account. Janice created a Drupal account and then went to the form and filled out the information on the webfrom and when she submitted the form it created a duplicate CiviCRM contact instead of merging what she was filling out and the existing contact.

I then ran the dedup rule and it found the two (the old one and the newly created one) CiviCRM contacts and stated that the total was 13. So CiviCRM knew they were possible duplicates based on the rule but it still did not merge them at from submission.

This seems to only be happening if the user is currently in CiviCRM and there is not an associated Drupal account for that user. I just tested by creating a CiviCRM user (Jon Doe, jon.doe@mydomain.com). I then created a Drupal account using that same email address and went to the webform and added the same first name, last name, and email address. CiviCRM created a duplicate contact. If I create the Drupal account first then use the webform it creates a CiviCRM contact. If I then go back to the webform while logged in and update information it updates the contact correctly without creating a duplicate.

Is this action to be expected or am I missing a setting somewhere?


texts: Settings - Date Preferences - mailing - start offset, end offset (what do they mean?)

texts: Please can someone explain what the start offset and end offset fields mean in Settings - Date Preferences - mailing. The default values are 0 and 1 respectively. I feel it should understand this, but I don't. Am I an idiot? Thanks.


texts: Email a user when they are assigned as case manager?

texts:
Can anyone advise on the best way of sending an email to a newly assigned case manager/advisor? (ie to a specific case relationship when it is first made)

I've looked at the civirules extension but could only get it to send to both parties (client as well) and without any case specific tokens to tell them what it was regarding..

thanks!


texts:
I have a client who is very keen to use the AB testing facility in CiviMail. they are currently running on CiviCRM 4.7.27 and shortly to update. When they set up an AB mailing, they are specifying that 10% of the group should be sent version 'A', 10% should be sent version 'B', and then the remainder get sent the final choice, which that should be. In practice they are seeing that the entire group is sent version 'A', no-one gets sent version 'B' (and so there is no point in sending the final mail).
I've checked through their workflow and it looks to me that they are doing everything by the book. I can't find any logged issues about this (maybe no-one is using it?). Are we doing something wrong, or is this functionality just broken?

Any pointers most welcome.


texts: Tax Label not updating in Price Set using _buildAmount Hook

texts:
I have an extension in progress at https://github.com/jboeke/com.avietech.multitax

What I'm hoping to do is combine multiple tax rates into one. The extension properly rejiggers the tax values and actual amount as expected but NOT the visible price or description of the tax (i.e. - price-field-amount) to the right of the quantity input.

As you can see, my tax rate of 6.25% has been applied as expected and the Total Fee(s) reflects (20 * 1.0625). So why do I still see "$ 20 (includes Tax of $ 0)" when the expected value is "$ 21.25 (includes Tax of $ 1.25)"?

function multitax_civicrm_buildAmount sets, what I believe, are the relevant values:

$option['tax_rate'] = $totaltaxrate / 100;
$option['tax_amount'] = $option['amount'] * $option['tax_rate'];

Are there other values I need to set to change the description to accurately reflect the adjusted taxes?


texts: How do I examine the symfony event handlers that are active?

texts:
The API kernel uses a symfony event system at it's heart.

How on earth do I find out where all those events are going?


texts: Unsupervised De-Dupe Rule failing in 5.9.0

texts:
Since upgrading to 5.9.0 (Drupal 7.6), we have noticed that all self-service / online event registrations are creating duplicate contacts - of both the individual end the organization (employer) record.

Having looked at the Unsupervised rule, it should absolutely be triggering - eg there are multiple contacts that have been created where the first name, last name, and email all exactly match an existing contact.

Our individual unsupervised rule is:

Has anyone else seen this behaviour on their installation?


texts: 4.7 Install, Database Settings Correct. Still no Contacts

texts: I have upgraded from CiviCrm 4.2 to 4.7 now that I finally have it working it will not bring up contacts from the old Civi database. I looked at the setting php file and all the information is correct. What is the best way to troubleshoot this issue. I have checked the database that is was set to use and the information is present. Is there any sort of mapping that the new install needs to do? Please advise and thank you!


texts:
Trying to set up online registration. All events get the following error message: "Error Online registration is not currently available for this event (contact the site administrator for assistance)."
CiviCRM 5.33.2 on Drupal 7


texts:
I'm runnning the bitnami image on Google cloud (5.0.1), trying to get sms reminders working.

Provider Account is set up and tested, extension installed and configured, but when I send a test sms it is reported as delivered by Civi, but it's not, and nothing appears in the providers reporting either, so I assume there has been no actual communication with the gateway.

How can I troubleshoot this? Does the extension work with 5.1?


texts: Membership not inherited if child added via webform

texts:
Civi 4.6.4 / Drupal 7.38

Goal: Allow a constituent to add family members to their membership.

Issue: When a constituent adds family members, via a civi web form, the relationship is created properly, however the child does not inherit the membership.  However, if as the admin, I go in and edit the relationship, make no changes, and save, the membership is now inherited properly.

In the webform, I am adding the relationship, but not adding any membership...I'm assuming this is not necessary. The parent has an established, active membership at the time of form submission.

Has anybody experienced this or is using another process to achieve this goal?

Thanks,

--Ken


texts: What is the purpose of the active / disabled buttons for campaigns?

texts:
I feel like this answer will be super obvious, but I'm unable to find an answer in Civi's documents.  I feel like the campaign status sums up the state of the campaign so I'm just wondering what info the active / disabled fields capture.

Thanks all!


texts: Why can't I see links to custom file uploads when viewing an activity record?

texts:
Running version 4.7.6 (but this has been the case for us for some time now):

We are using activities in cases to upload a range of documentation for a given case that we are working on. The uploads work fine.

But if I view an activity to which files have been uploaded I can't see (or click) on the links to the files. However, if I edit the activity record I can see and use the links.

I can't replicate this issue on the demo site (which looks to be running 4.7.7 as I write this).

Is anyone seeing the same issue, or is it something to do with my specific install? Any ideas as to how I might address this?


texts: method for versioning configuration of civicrm?

texts: Is there a way to version the configuration so we can just roll it back if its a bit broken? Or is the only option full filesystem and db backups?


texts: We are a non-profit transition movement in Norway. If we as ha "head office" sign up for a user license, will all our grasrootgroups (=neigbourhood) around in Norway be able to use the same license?


texts: Can a CiviDiscount coupon be configured to limit it to a single use?


texts:
In the CiviHR installation, data is not displaying in self service portal. In menu like My Leave under self portal showing angular js error in console.

But in HR menu I'm able to see all my contacts. there are no errors at all.

This installation is hosted in DigitalOcean 2GB RAM and 2CPU.

Is CiviHR required more RAM?


texts: If I create a Scheduled Reminder based on an Activity with a specific status and set it to trigger 0 hours after Activity Date Time will it fire immediately when the activity is created or when the next Scheduled Reminder cron job runs?


texts: Where to modify billing information form ≥ 4.6?

texts:
One of the first things we're asked to change in any installation is the billing block:

Nothing too fancy, just some changes to layout and labels, usually yielding something along the lines of

This was for a long time a simple matter of copying BillingBlock.tpl to create a custom template (customtemplates/CRM/Core/BillingBlock.tpl), as indicated in the wiki. But the hard-coded billing fields were removed in 4.6, and instead we they are printed out from the $billingDetailsFields array.

While I can't fault this from a technical perspective, I do wonder what would be the best practice as far as manipulating the layout and order for this form goes now. In the override template, would we remove the for block and output the old fields one by one? Is there a place where these values can be changed in the db or even through the admin UI?


texts: MySQL v8.0 released. Will CiviCRM work with it?

texts:
MySQL 8.0 has been released.  Will CiviCRM work with it?  I tried migrating a test database to it, and CiviCRM under Joomla failed.

Oct 31 12:36:35  [info] $Fatal Error Details = Array (
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] =>  SELECT  v.label as label ,v.name as value, v.grouping as grouping FROM   civicrm_option_value_en_GB v,
       civicrm_option_group_en_GB g WHERE  v.option_group_id = g.id   AND  g.name            = 'languages'   AND  g.is_active       = 1  AND v.is_active = 1  AND ( v.component_id IS NULL  OR v.component_id IN (SELECT id FROM civicrm_component WHERE name IN ("CiviEvent","CiviContribute","CiviMember","CiviMail","CiviReport","CiviPledge")) )  ORDER BY v.weight [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'grouping FROM   civicrm_option_value_en_GB v,
       civicrm_option_group_en_G' at line 1]
    [type] => DB_Error
    [user_info] =>  SELECT  v.label as label ,v.name as value, v.grouping as grouping FROM   civicrm_option_value_en_GB v,
       civicrm_option_group_en_GB g WHERE  v.option_group_id = g.id   AND  g.name            = 'languages'   AND  g.is_active       = 1  AND v.is_active = 1  AND ( v.component_id IS NULL  OR v.component_id IN (SELECT id FROM civicrm_component WHERE name IN ("CiviEvent","CiviContribute","CiviMember","CiviMail","CiviReport","CiviPledge")) )  ORDER BY v.weight [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'grouping FROM   civicrm_option_value_en_GB v,
       civicrm_option_group_en_G' at line 1]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info=" SELECT  v.label as label ,v.name as value, v.grouping as grouping FROM   civicrm_option_value_en_GB v,
       civicrm_option_group_en_GB g WHERE  v.option_group_id = g.id   AND  g.name            = 'languages'   AND  g.is_active       = 1  AND v.is_active = 1  AND ( v.component_id IS NULL  OR v.component_id IN (SELECT id FROM civicrm_component WHERE name IN ("CiviEvent","CiviContribute","CiviMember","CiviMail","CiviReport","CiviPledge")) )  ORDER BY v.weight [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'grouping FROM   civicrm_option_value_en_GB v,
       civicrm_option_group_en_G' at line 1]"] )

The SQL below runs happily against MySQL 5.7 whilst it fails against MySQL 8.0 with

  "SELECT" is not valid at this position for this server version,
  expecting '(', WITH

SQL:

  SELECT  v.label as label ,v.name as value, v.grouping as grouping FROM
  civicrm_option_value_en_GB v,
         civicrm_option_group_en_GB g WHERE  v.option_group_id = g.id   AND  g.name            = 'languages'   AND  g.is_active       = 1  AND
  v.is_active = 1  AND ( v.component_id IS NULL  OR v.component_id IN
  (SELECT id FROM civicrm_component WHERE name IN
  ("CiviEvent","CiviContribute","CiviMember","CiviMail","CiviReport","CiviPledge"))
  )  ORDER BY v.weight

Replacing the first line with:

  SELECT  v.label as label ,v.name as value, v.grouping as `grouping`

solves the problem.

Clearly some work is needed before CiviCRM will work with MySQL 8.0


texts:
Given the current world situation, everyone is moving towards online events.  We used to host events in different countries and charge in local currency.

Now that we are offering online events, we might get people from different countries.  How can I have a multi currency event?  One way I thought I could do this was to create different events with different currencies based on the targeted countries, but only show the event on the list based on the geolocation of the user.  Is this anyway possible,  Can anyone think of a workaround for this??

Most countries would be charged in US dolars, but only one or two would be in local currency, so it is really an exception rather than the rule.

I am open to any ideas out there.


texts:
Maybe I'm just not looking on the correct pages for this issue.  Once I download and set up a CiviCRM database, is the actual data saved to a cloud?  Or, can I save it all to me local drive or network?

Thanks, G


texts: GDPR Extension on CiviCRM-WordPress: acceptance checkbox not showing up on registration forms

texts:
I have installed GDPR Extension on a CiviCRM running on WordPress in order to include the acceptance checkbox in a event register form.

I have followed all recommended steps to configure it (GPDR Dashboard) and checked to activate it in my event. But when I try online register, it shows up nothing. Privacy Police and acceptance checkbox are still missing.

Is there anything I'm doing wrong?

Any help would be wellcome.

Sandra


texts: Impossible to login with new civicrm user

texts:
I have created a Drupal 7 website with civicrm . My problem is when I create an account with Drupal and I would like to reset password I don't have problem's. The account is automatically created in civiCRM .
But when I create a contact in civiCRM, an user is created in Drupal 7 . When I would like to reinitialize this user password, the process don't have problem's.

But when I would like to log out and login with new password, I can't.

I have checked in drupal's table "user" .

They don't have difference between drupal user created and civicrm user created. The permissions are same and the generated passwords are ok and the cache cleaned.

Any person have any idea ? I use Drupal 7.43 and 4.7.3


texts: How to insert Javascript into an inline form edit via an extension?

texts:
Normally, if I want to inject a Javascript snippet into a form, I use a hook like in an extension like this:

function alternateduplicatecheck_civicrm_buildForm($formName, &$form) {
  if($formName == 'CRM_Contact_Form_Inline_CustomData'){
    CRM_Core_Resources::singleton()->addScriptFile( 'org.cpehn.alternateduplicatecheck', 'alternate_duplicate_button.js');
    }
  }

This works on most forms; however, this doesn't appear to work for forms used for inline editing loaded via AJAX.  The hook is called, but the Javascript doesn't run.  Maybe I need to modify my Javascript, insert an onLoad in there?  It looks like:

cj(function ($) {
  'use strict';
  console.log('hi');
  cj('.crm-button-type-upload').hide();
});

Here's the AJAX request (it's a custom field set on the summary tab): http://<sitename>/civicrm/ajax/inline?cid=5652&class_name=CRM_Contact_Form_Inline_CustomData&groupID=10&customRecId=339&cgcount=1&snippet=6&reset=1


texts: Setting the date feature is not working in events (Added Screenshots)

texts:
I just installed Civi 4.7.27 on Wordpress 4.9.1 in a subdomain.   When configuring the new install, I am noticing something strange with the date settings. The first screenshot shows what I am getting in the new install. When I click in those boxes, the Calendar does NOT pop out like it is supposed to and it is displaying two extra textareas that shouldn't be there.  The second screen shot shows how it looks in my root directory as it is supposed to be.   How can I fix this?

ERROR MESSAGES

Failed to load resource: the server responded with a status of 404 (Not Found)
volunteer_events.css Failed to load resource: the server responded with a status of 404 (Not Found)

volunteer_app.css Failed to load resource: the server responded with a status of 404 (Not Found)

angular-modules.b61ce69729ca8c547f15ef2c0d2af9ae.js Failed to load resource: the server responded with a status of 404 (Not Found)
volunteer.css Failed to load resource: the server responded with a status of 404 (Not Found)

volunteer_events.css Failed to load resource: the server responded with a status of 404 (Not Found)

volunteer_app.css Failed to load resource: the server responded with a status of 404 (Not Found)

angular.js:4692 Uncaught Error: [$injector:modulerr] _http://errors.angularjs.org/1.5.11/$injector/modulerr?p0=crmApp&p1=Error%3A%20%5B%24injector%3Anomod%5D%20http%3A%2F%2Ferrors.angularjs.org%2F1.5.11%2F%24injector%2Fnomod%3Fp0%3DcrmApp%0A%20%20%20%20at%20https%3A%2F%2Fsecure.narsol.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3D54zOZ%3A6%3A426%0A%20%20%20%20at%20https%3A%2F%2Fsecure.narsol.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3D54zOZ%3A25%3A235%0A%20%20%20%20at%20b%20(https%3A%2F%2Fsecure.narsol.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3D54zOZ%3A24%3A282)%0A%20%20%20%20at%20https%3A%2F%2Fsecure.narsol.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3D54zOZ%3A25%3A20%0A%20%20%20%20at%20https%3A%2F%2Fsecure.narsol.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3D54zOZ%3A40%3A17%0A%20%20%20%20at%20q%20(https%3A%2F%2Fsecure.narsol.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3D54zOZ%3A7%3A371)%0A%20%20%20%20at%20g%20(https%3A%2F%2Fsecure.narsol.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3D54zOZ%3A39%3A382)%0A%20%20%20%20at%20fb%20(https%3A%2F%2Fsecure.narsol.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3D54zOZ%3A43%3A381)%0A%20%20%20%20at%20c%20(https%3A%2F%2Fsecure.narsol.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3D54zOZ%3A21%3A19)%0A%20%20%20%20at%20Gc%20(https%3A%2F%2Fsecure.narsol.org%2Fwp-content%2Fplugins%2Fcivicrm%2Fcivicrm%2Fbower_components%2Fangular%2Fangular.min.js%3Fr%3D54zOZ%3A21%3A332)
    at angular.js:38
    at angular.js:4692
    at q (angular.js:325)
    at g (angular.js:4653)
    at fb (angular.js:4575)
    at c (angular.js:1809)
    at Gc (angular.js:1830)
    at se (angular.js:1715)
    at HTMLDocument. (angular.js:32616)
    at i (jquery.min.js?r=54zOZ:2)

volunteer_app.css Failed to load resource: the server responded with a status of 404 (Not Found)

volunteer.css Failed to load resource: the server responded with a status of 404 (Not Found)

volunteer_events.css Failed to load resource: the server responded with a status of 404 (Not Found)


texts: Unable to make backend contributions with non-default payment processor (sometimes) "no class provided" error

texts:
As per the title, here's how it happens:

Create a payment processor instance (i.e. add payment processor here
/civicrm/admin/paymentProcessor?reset=1)
Create a second one of the same type, different credentials. Leave the first one as default.

When trying to use the second payment processor on a 'backend/admin' contribution form (ie. /civicrm/contact/view/contribution?action=add&cid=etc.), we get an error at
/CRM/Contribute/Form/Contribution.php, line 1165
(this is using civicrm 5.6.1, we had the same issue on 5.3.1).
As far as we know this behaviour was introduced sometime shortly before 5.3.1 (that was the security update in the summer), i.e. this is new behaviour on several upgraded, existing installs.

I can see that the payment_processor_id value is getting to the server (I can see it in the submit values in the stacktrace).

To make matters a bit more confusing, we can't reproduce it reliably (but do have it reproduced on three separate sites, but not a fourth, new install), so there is some additional aspect going on here.

These tests are all using the iATS payment processor (of course ...), but I don't think that actually comes into play, since the code breaks before it can identify which payment processor is responsible for the payment.


texts:
Please could anybody direct me on how to setup civiCRM on my windows OS and also code with it. I am totally new to this type of platform and with no clue on how to go about anything, however, I have a strong knowledge of PHP and php based frameworks like laravel and lumen. I believe if directed on what to do I should be able to standard on my own. I have tried google but nothing significant.

Thanks.


texts: ACHEFT-Debit possible with webform_civicrm?

texts: Webform CiviCRM module can do credit card payments - but what about ACHEFT-Debit?


texts: My client's site recorded this item as complete with the recorded credit card. However, Authorize.net claims to have no record of this transaction and the event registree says that she has no record of the transaction from card provider. The site is  running Civi 5.13 on Wordpress 5.2. I'll take any suggestions on how to track this down and prevent if from happening again. For the record, this is not multisite. There are no other accounts or processors available for this site.


texts: Mosaico extension 2.4 beta installation?

texts:
We have installed the latest of the mosaico extension (2.4.1592820024).
Either entering the Mailings >> Mosaico templates area or Administer >> System status results in an error message
Unrecognized Angular module

Or via civiCRM log files
[name] => crmMailing
[civi.tag] => deprecated

Unrecognized Angular module

The readme for beta-3 mentions both a validation step and the various template versions and an upgrade to verify them?
I've looked in /civicrm/admin/mosaico?reset=1 and don't see a verification or upgrade system? How do I install this extension and check that it is valid?


texts: Mailing appears to have sent, but still "Running" after several hours

texts:
I have a mailing that's went out at 10:00am to about 1300 people.

My CiviCRM Mailer Settings say to batch every 100, and the cron job is set to run every 5 minutes. Under these conditions, I'd expect it to take no more than a couple hours to send all the emails.

When I look at the Report for the mailing, I can see a high percentage of successful deliveries, and a number of bounces that take us very close to 100%.

So I think the mailing has sent, but has not been marked Completed yet.


texts:
We have a lot of contacts in our system that share the same email address.  In one instance, there are 37 contacts with the same email address.  For mass mailings (via CiviMail), we have turned on email de-duping checkbox here:

Administer > CiviMail > CiviMail Component Settings by ticking or unticking "CiviMail dedupes e-mail addresses by default"

Still, that one email address with 37 contacts is receiving 37 emails.  It seems like it is doing so once for each contact record associated with that email.  We have checked civicrm_mailing_recipients, civicrm_mailing_event_queue, and civicrm_mailing_delivered tables and confirmed that they only show one record for this email address for the mailing job in question.

We recently upgraded to Civi 4.7.25 on Joomla 3.8.1.

Any ideas on why duplicate emails are still being sent?  Possibly a redux of this issue?  https://issues.civicrm.org/jira/browse/CRM-19353


texts: How to create a relationship if a contact marked with multiple subtype?

texts:
I have 3 contact subtypes.

Contributing member
Volunteers
Patron

some of members have multiple subtypes associated to their record. When I try to create a relationship of a "Patron" with a contact marked "Contributing member & Volunteer" it does not work, if relationship A-B are set to the contact subtypes. It only works if selected relationship A-B are both Individuals and not the subtypes. Anyway to fix it, so that I can use the contacts that uses multiple contacts subtypes?


texts:
I'm using Civicrm 5.13.4 on Drupal 7.67.
I want to change the order of the address fields and bring "postal_code" upper in the list when using the "pay later option".
I was able to find for online payment but not for this option.
It's also already set in localization/address. Is there a way to modify this?

Thanks
Guillaume


texts:
We have just transferred a Wordpress installation of CiviCRM 5.21.0 to a new server, but all of the search functions are failing. In advanced search, when I attempt to open for example, "Address", the following error appears and repeats itself on some kind of loop:

"Because your session timed out, we have reset the search page."

The Address option then just opens up another "Search Criteria" section underneath.

The parameters in the looping message are:
page    "CiviCRM"
q   "civicrm/contact/search/advanced"
reset   "1"
snippet "json"

I've checked the database connection and that seems fine, it is returning the correct numbers of results in saved search smart group lists, but when I click "contacts" on the lists it shows no results, just the same error.


texts: Back end credit card not sending info to PayPal

texts:
We're running Civi 4.7.4 on Wordpress 4.4.2. We recently switched to PayPal Pro (from Standard) in order to use back end credit cards and keep everything on one site. So far, PayPal Pro has been handling transactions properly from the front end. When I tried to submit something via the back end yesterday (member renewing over the phone) the renew-credit card screen appeared, I filled out the data, and submitted it. The screen refreshed and a new renew-credit card screen appeared and no transaction went through.

Today I decided to do some testing in the back end. None went through. It appears Civi overwrote the test api credentials. I then tried to save the test api credentials again. The credentials were saved, but the "sandbox" portion of the URL was removed. As a result I can't test - everything comes back "internal error internal error." This is occurring when I use an anonymous window as well. What does "internal error internal error" mean? Does Civi show the paypal error code somewhere? Edit: I think I solved this part - it needed a valid mailing address.

I am using credit card = 4111111111111111, CVV 123, expiry Apr 2017, which seems to be what paypal suggests.

Finally, how do I test a contribution page without overwriting my contact profile? When I click to test as a different person from the logged-in account it appears to send me to a regular version of the contribution page. Edit: using anonymous window here. This part is solved.

I'm at a total loss - I want to be able to test that my payments are going to work when our members try to join or renew, and I would really like to be able to call members as part of our fundraising drive.

Any pointers that can help me get to the bottom of this are appreciated.


texts: Using the wordpress plugin, how do I overide the the template files, ie EventInfo.tpl?

texts: I have spend a number of hours trying to figure this out.  If I want to change one of the template files, say EventInfo.tpl, but not inside the plugin so updates would not override it.  How do I need to do that?


texts: How to see who the individual is who registers multiple people for a paid event

texts:
Where in Civi can I see who paid for/registered themselves and multiple other people for a paid event?  In other words, if Joe registers and also registers his two friends Gary and Bill for the same event how do I see that Joe paid for/registered Gary and Bill?

CiviCRM v4.5.8 with WP 4.2.2


texts:
When making recurring contributions, everything works fine when entering credit card info directly, but if one uses a PayPal account, the method (m=contribute) is missing in the IPN generated

(i.e., i=0c1df32e5c4f32d4f8ef1c2fe8e&m=&c=11058&r=95&b=465&p=14)

It should read i=xxxx&m=contribute&c=... like it does for IPNs generated using credit cards directly.

The recurring profile shows the status as Pending and the contributions show as Pending (Incomplete Transaction) in Civi through they are completing properly in PayPal.

Is this a bug or something on my side!?!?
Running Civi 4.7.15 in WP.
Any help is appreciated - thanks!
Karen


texts: Send welcome message at signup date, not membership 'start date'

texts:
I want to do something pretty simple, but it seems surprisingly hard to do.

When a member joins, they should receive a) A receipt and b) A welcome email.

A) Works Fine. B) Is a problem.

Memberships for this client are all dated from 1st of the year, so the 'start date' is always 1st January.

It is easy to set a 'reminder' to send the welcome letter on the membership start date, but if a new member signs up on 16 July, the welcome letter will never send, because the start date is 6 and a half months earlier than the sign up date.

Can somebody suggest a way to send the welcome letter at the membership sign up time, not the membership start date? Obviously I could edit the receipt to include the welcome email, but that's not the way the client wants it to work.


texts: Why do I suddenly get unkown error when try to log in through Civimobile?

texts:
I used to be able to log in into my Joomla based CiviCRM with Civimobile, but last week I logged out on Android, and can't log back in. It finds the site, I think, but when typing in credentials it says "unknown error".
It might be some permission related problem but don't know where check and change these for Civimobile.
Turned off firewall, reinstalled both the app and the extension, didn't help.
I need help here I think.


texts:
I am getting this message when I load my website. Is this a Civi Issue?

Warning: Cannot modify header information - headers already sent by (output started at /home/aflbs/www/www/wp-content/plugins/civicrm/civicrm.php:305) in /home/aflbs/www/www/wp-includes/pluggable.php on line 1216


texts: Contribution count does not reflect number of contributions

texts: I have just noticed that the contribution count does not equate to the number of contributions. I have not been able to narrow down the circumstances.


texts: "Could not find a valid session key." Unable to save any admin forms

texts:
When I try to save any form in the CiviCRM admin area, I get this error:

Sorry but we are not able to provide this at the moment.
We can't load the requested web page. This page requires cookies to be enabled in your browser settings. Please check this setting and enable cookies (if they are not enabled). Then try again. If this error persists, contact the site adminstrator for assistance.

Site Administrators: This error may indicate that users are accessing this page using a domain or URL other than the configured Base URL. EXAMPLE: Base URL is http://example.org, but some users are accessing the page via http://www.example.org or a domain alias like http://myotherexample.org.

Error type: Could not find a valid session key.

I have rebuilt my VM multiple times, and I'm fairly sure this has nothing to do with the cookie being set on the wrong domain.

What am I doing wrong? I hope this is me doing something stupid and not an actual bug, but I made a JIRA issue anyway: CRM-16508.

I have tracked the error message to this file, if that helps.

I am aware of this related question, but I am positive I'm not swapping between HTTP and HTTPS (I use HSTS) and I can't actually change any settings in the admin area anyway.


texts: MySQL Master-Master Replication on 2 servers

texts:
For our installation in a "Third World Country" we need 2 replicated Master-Master Mysql-Servers:

one in a European data center to serve the public website and allow access from mobile devices to CiviCRM
one local server to serve the office staff (as the internet line of the office often does not work and the staff cannot depend on the server in the data center)

We run 2 "master-master-replicated" MySQL-Server

one with auto_increment_offset = 1
the other with auto_increment_offset = 2
both with auto_increment_increment = 2

in my.cnf so that one server uses odd ids and the other one even ids when inserting record. This works perfectly in other PHP/Mysql based software we are using. We do not have a problem with the replication of our running servers.

When installing CiviCRM we received the message

"An auto_increment_increment value greater than 1 is not currently supported. Please see issue CRM-7923 for further details and potential workaround."

https://issues.civicrm.org/jira/browse/CRM-7923 not really is helpful with that issue - it explains how to undergo the configuration of replicated servers which does not help in our case as we need the master-master replication with CiviCRM. This pages also shows that this topic seems to exist since several years without any change.

We googled a lot and did not find any solution for this important feature to use CiviCRM on 2 (or even more) replicated master database servers.

So I address the following questions:

why CiciCRM only supports id increments of 1 when inserting records? Which technical reason defines this limit?
are there any modules to change this handicap? if not:
where in the code, where is the point to change this behavior? We have a team of PHP developers to work on this problem if we would know where to start
is there - may be - a plan to change this problem in the near future e.g. in 4.7?
what other recommendation do you have for our organizational need of 2 servers - without setting up CiviCRM on 2 database servers with "master-master replication"?

Kind regards and thanks a lot for your answer!


texts: Bulk move contacts to new group after message sent

texts: I would like to set up a workflow that will automatically bulk move contacts out of Group A and into Group B after an email is sent to Group A. Is this possible?


texts: Merge contacts deletes left hand user in Wordpress

texts:
I'm working with a new membership site and have migrated the data.  When members renew, if the email address is different, it creates a new contact, as expected.  So I have been merging a few contacts in Civi.  At the top of the merge screen it says:
"
WARNING: There are WordPress user accounts associated with both the original and duplicate contacts. Ensure that the WordPress user you want to retain is on the right - if necessary use the 'Flip between original and duplicate contacts.' option at top to swap the positions of the two records before doing the merge."
So I keep the Wordpress user on the right, check the fields to merge and then complete the merge.  However, the wrong Wordpress user is kept linked, and not the one associated with the Civi record on the right.
Am I doing something wrong?


texts:
How do I delete an activity that I have created and assigned to myself?
I cannot see a button that says delete, only an edit button?


texts:
I am trying to create a smart group that always returns the list of contacts whose membership end date is the end of the previous year or earlier (these are lapsed members and we need to chase them for renewal). I did find that I can do this using the advanced search, but that unfortunately the date ("31st December 2015" in this case) gets hard-wired in the query.

Then I thought maybe the search builder would help, but there the date searches do not work at all. A drop-down calendar is presented, but the string used in the query seems to have a different date format ("20151231") from the field contents ("2015-12-31"). Is this a known bug?

In any case, there seems to be no way to let the date range "float" from year to year, so this means that this year's "membership has expired" query, will be wrong in a year's time.

I am using the current version of CiviCRM, V4.6.8, under the latest Wordpress version


texts: Why is Microsoft Edge autofilling disabled fields on my Webform CiviCRM?

texts:
We're struggling with a complex Webform that is auto-populating the wrong values into some text fields in Edge browser. The text fields are pulling data (phone number, email, address) from an existing Company Contact - and if those values are NULL in CiviCRM - Microsoft Edge happily populates these fields with previously seen but completely irrelevant and incorrect phone number, email and address.

We've since reproduced this on a number of sample forms.

Some illustrations - this is Chrome [Semper IT - with phone has a phone number in the CiviCRM database; Semper IT - no phone does not]. The yellow fields are the auto-fills from Chrome

And here's what Microsoft Edge does with this exact same form (apparently I live in Edmonton now). The blue fields are the auto-fills from Microsoft Edge. Thank you Laura for the screenshot!


texts:
How do I successfully import contact's check box field data?
I am using civicrm 4.6.19 and importing from csv.

I want to import the "is deceased" field
and the communication preferences...

Thanks


texts: Formatting of formatted text in print case and activiy audit

texts:
I'm sure this shoudl be fairly straight forward.  I think i'm looking in the wrong place.

When I try to print the report of a case (civicrm/case/report/print?) or undertake an activity audit of a case, any text that has been entered usinjg the WYSIWYG editor is displayed as raw text.  So any paragraphs are enclosed within  brackets etc.

Practically, this prevents these functions being used as the printed reports are nearly illegible (due to no line breaks and lots of angle brackets everywhere).

Hope this is clear and someone's got a quick solution.

I'm thinking i'll need to recreate these functions as a complete drupal view of the case, but would appreciate any other suggestions / approaches


texts: Batch update participants by profile - show more than 9 fields

texts:
I'd be grateful if anyone knows the answer to this:

I need to make a variety of batch update profiles that allow me to edit details of up to 40 custom participant fields on one screen. The batch update by profile is perfect for this.

However, while I can make these profiles exactly as I want them, when I use them for 'Batch update participants by profile' only the first 9 fields are shown on the batch update screen. I've tried this with a variety of different profiles, with different custom fields from different custom field sets and get the same result - only the first 9 fields show. This is also the case regardless of whether I am showing 4 or 22 rows. (My 2 test scenarios).

Is there a way to change this from 9 to 40 columns?

I'm on Civi 4.6.12, Drupal 7.43. We've long ago changed our php input variable limit to 4000 because we have many many blocks in our site, so it can't be this...

Thanks!


texts: Change group after a mailing is scheduled results in mailing still being send to the original members

texts:
When we schedule a mailing in civimail we use a normal group (not a smart group) as the target audience for this mailing. Prior to 4.6.2 (we think), we could change the group before the mailing was send (even though it was scheduled) and the changes to the group would be taken into account when the actual sending of the mail occurred.

We are now on version 4.6.4 and looked into the database a bit to see what happens when somebody schedules a mailing. It seems as the schedule button fills the "civicrm_mailing_recipients" table and this table is used when the mailing actually starts. So adding a contact to the group(s) you used does nothing.

Is this behavior correct/by design? And is there a workaround to get the latest group members when the mailing actually starts?


texts: Change Household contact to Organization contact

texts:
A staff member added quite a few contacts as Households but they should have been added as Organizations. I can find no form control to switch the contact type to Organization. Can you suggest a procedure to fix this or should we just redo the work?

This not exactly a duplicate of this question because we are going from Household to Organization, and there is no concept of merging a Household into an Organization (as far as I know).


texts:
I don't know why I never receive my bounced mails in my bounce mail account, that I have set up at Civimail settings.

I do see it in Cpanel mail tracker that it has bounced and the sender looks like this:

b.48.56.909e941cf2aa78a6@example.com

or

crmbounce+id.23452345@example.com

The documentation says that  "If the mail service for this mail account features VERP-handling you should use that" So how do I find out if my mail account features this? How do I enable VERP and how do I configure mailing to use VERP or not? If there is no VERP than how to handle bounce messages?

My setting looks like this
Name: bounce mail
server: mymail.example.com
username: crmbounce@example.com
password: double checked it, its ok
localpart: crmbounce+11:07 2020. 04. 03.
email domain: example.com
return-path: empty
Protocol: tried both POP3 and IMAP and maildir
Source: emtpy
Use SSL: checked
Used for: Bounce


texts:
I'm talking about the user dashboard displayed for each contact who is logged in.  In wordpress this is displayed on a page using this shortcode: [civicrm component="user-dashboard" hijack="0"]

By default it displays (for the logged in user) Groups, Contributions, Events, Memberships,Related Contacts and Organizations.

I would like to display only the Groups and the Membership information, for example. Is there a way to customize this user dashboard?
(I'm using wordpress and civicrm 4.6.23)


texts: GDPR Communication Preferences Compulsory

texts:
I am using Civirm 5.1 on Joomla and using the GDPR extension to update Communication preferences. The org has only 1 public facing group with just 1 Mailing list - and the entire purpose of the communication is to ask people if they wish to sign up. If they do not repond they will be removed from Group and if they do respond it is ONLY for the purpose of asking to receive newsletter. Therefore, we need to make the Mailing Group compulsory to sign (as opposed to optional). We do not want form used if you do not want newsletter.

see form here

https://peoples-press.com/index.php?option=com_civicrm&task=civicrm/gdpr/comms-prefs/update

1 tick box option to MS Newsletter - any ideas how to make compulsory in settings?


texts: Managing internal Purchase Order forms/requests in CiviCRM

texts: I did a quick search, but only found the reverse about allowing registrations to accept incoming PO numbers.  We are looking to implement Purchase Order Forms internally, and wondering if anyone else has done so?  Cases seems like a pretty logical place to do this, but I'd love to hear about other potential possibilities.  Or if it's a terrible idea, give me some why's.  Shouldn't matter, but this is a WordPress install.


texts: Civicontribute: Missing payemnt options when required field missing or back button

texts:
I've hit some strange behavior on a contribution page.  I consider payment usability a big issue.

Using a price set, have radio select for different donation amounts (need price set as different financial types).  Also have an "Other" numeric field.  Payment options has 2 choices: "pay by cc" or "pay by check".

This is a common use case.  Unless you add an explicit "other" in the select list with a 0 value, the option list will show "none" as an option.

Setting a radio select field with numeric value >0 works correctly.
Setting a text / numeric input value >0 works correctly.

Setting a radio with a select numeric = 0 AND a text numeric value > 0 will not present the payment options but will increment the total.

Further problems when field does not validate on page or hitting back button - payment processor selection does not appear.

I see lot's of cc related issues but not this one please let me know if this is a known bug or a new one...


texts: Using price sets for renewing memberships on online pages?

texts:
I want to provide a signin to a membership with CiviCRM contribution pages. I configured an auto-renew membership with a Membership Type Duration Unit = 1 month..
Then i set up a price set. The price set is configured with different prices and terms, lets say

quarterly with a number of terms = 3 for 30 €
yearly with a number of terms = 12 für 100 €.

Both is now included in a contribution page, with a payment processor and enabled membership section.
When filling out the forms and submitting on the contribution page like civicrm/contribute/transact?reset=1&id=1, the membership is recorded with the right terms (eq. 12 month), but the recurring contribution is recorded as monthly payment, eq. 100 € every month, which is not right.
On the confirmation page (before submitting the form) it also shows I want to contribute this amount every month instead of every 12 month.
Papypal is used as payment processor, but i have also tried credit card.
Is this expacted behaviour and did i misunderstood the price sets?
thanks a lot, kindly regards


texts: How can I automatically turn off civirules after a given period?

texts: I have a rules that should perform action only until a certain date. What would be the best way to handle this situation so that after a given date the specific rule would be turned off automatically? Thanks


texts:
When logging on today, I got the following alert:

"Jmanage Security Update Required
New security release 4.7.11 is available. The site is currently running 4.7.9."

What steps do I need to perform to achieve this goal?


texts: How can I safely revert to earlier version of CiviCRM without reverting the database?

texts:
I am using Drupal 7.64. Everything was working fine on my site with CiviCRM 5.10.2.

I upgraded to 5.10.3 and two days later discovered that it broke an event registration page that relies on the extension Group-Based Pricing. Yes, I know that extension is not cleared for takeoff with this version of CiviCRM, but I had tested it carefully before deploying it live, and it has worked for a month. And now I absolutely need to keep using it for the next few months until the event is over.

I then upgraded to 5.10.4 thinking that might fix things. It didn't.

In the meantime, members have made other kinds of contributions, altered their profiles, etc. The database has been changed under 5.10.3 and 4.

So, while I can go back to the 5.10.2 CiviCRM code easily enough, I can't revert the database without losing the changes that were made in the past three days.

What should I do? Can I safely proceed with the upgraded and altered database as is? Is there something I can do to make it safe to use under 5.10.2?

Thanks.


texts: CiviCRM 4.7.25 - No such field - unknown column a.weight in field list on Activity

texts:
Upgraded a few days ago, everything seems fine. Just word that there are some issues registering new participants/payments, the UI "hangs" on submitting the form, but still records the participation.

Trying it myself, as administrator, I could see that an error was being generated during the transaction, breaking the ajax UI for non-admins.

    DB Error: No such field.

After looking at the logs, it becomes pretty obvious that the error is being caused by a bad query relating to civicrm_activity. It would also explain why the registrations are being recorded despite the issue.

[nativecode=1054 ** Unknown column 'a.weight' in 'field list']

    [type] => DB_Error

    [user_info] => SELECT a.id as `id`, a.source_record_id as `source_record_id`, a.activity_type_id as `activity_type_id`, a.subject as `subject`, a.activity_date_time as `activity_date_time`, a.duration as `duration`, a.location as `location`, a.phone_id as `phone_id`, a.phone_number as `phone_number`, a.details as `details`, a.status_id as `status_id`, a.priority_id as `priority_id`, a.parent_id as `parent_id`, a.is_test as `is_test`, a.medium_id as `medium_id`, a.is_auto as `is_auto`, a.relationship_id as `relationship_id`, a.is_current_revision as `is_current_revision`, a.original_id as `original_id`, a.result as `result`, a.is_deleted as `is_deleted`, a.campaign_id as `campaign_id`, a.engagement_level as `engagement_level`, a.weight as `weight`, a.is_star as `is_star`, a.created_date as `created_date`, a.modified_date as `modified_date`
FROM civicrm_activity a
WHERE (a.source_record_id = "77904") AND (a.activity_type_id = "6")
LIMIT 25
OFFSET 0

I can confirm that my civicrm_activity table DOES NOT have the weight column...

Does anyone have any experience with this kind of nuttiness?


texts:
I have an event with custom fields that I use to collect information relevant to each participant's registration (for example, number of guests accompanying, seat preference, etc.). When I view the participants under the "Manage Events" view, it will show me the fee levels and quantities they selected, but not the custom fields. I have to click on each participant to view the content of the custom fields.

How can I generate a report that will show the custom fields? When I try to generate a custom report, the custom fields don't appear as columns I can select.


texts: how to write PHP Unit test for an entity using hooks

texts: I am to write a unit test for a simple extension using hooks with postprocess and formbuild. How can I do it? Please provide some example.


texts: Running cron job CiviCRM on Drupal in the CPanel

texts:
I am trying to configure the CiviCRM file "sites/all/modules/civicrm/bin/cron.php" to be run as a cron job.  If I paste the url:

https:// domain.com/sites/all/modules/civicrm/bin/cron.php?name=username&pass=password&key=key

in to the web browser, with the username, password and key specified then the cron.php is triggered.

But if I create a cron entry via the CPanel and define the command as:

/usr/local/bin/php /home/username/domain/sites/all/modules/civicrm/bin/cron.php?name=username&pass=password&key=key

then the cron job is not triggered.

If i try:

/usr/bin/wget https://domain/sites/all/modules/civicrm/bin/cron.php?name=username&pass=password&key=key

then the cron job is equally not triggered.

Any ideas what the issue might be?  Or what else i could try to get it to run?

At the moment I do not have access to server logs so can't see what is causing the issue.


texts: Alerting admins when certain fields are changed via profile & checksum?

texts:
Drupal 7, CiviCRM 5.10

I'd like to send out an "update details" email to contacts - a profile with checksum. It will include some other custom field questions but i want to be alerted specifically if the general contact fields are updated - Address, phone number etc.

I can put those who completed the profile into a group but that won't distinguish between those changed and those whose contact details remain the same..

I don't think i can create a duplicate to dedupe later if using checksum?

The only other idea i had is to have two profiles - one for my custom field questions and another for "change contact details" and rely on contacts only submitting that form if things have been altered - Even then it would be useful to know which field specifically had changed but perhaps that's my only option?

Thanks!


texts: Is there an easy way to record the various qualification levels for members?  We have our own internal qualification and renewal system that determines some people's membership status.  It would be helpful to be able to record the date, place and trainer involved for each of our Members.  There are 6 levels of training.


texts: Recording Separate Contributions in a Membership Webform

texts:
Working on a Civi 4.5.5 site. I've configured a membership renewal contribution page to record a membership fee, and (voluntary) additional donation.

By setting the Contribution Page Financial Type to "Donation", and selecting "Separate Membership Payment" on the Membership tab. When entering a test payment, two contribution records were created with one of type "Donation" and one of type "Membership Fee". As expected.

Renewal is easy, because we are only capturing info for the Primary member.

The membership type extends by relationship to other family members. so the organisation want a membership webform to capture contact details of the related individuals (spouse//partner, and offspring) on initial sign up.

When testing the webform to collect an additional donation on sign up, only 1 contribution was recorded (equal to the value of the membership fee and the donation- but labelled as a donation).

Is it just that the create separate payments option doesn't work with the current civi/webform integration? In which case I need to discuss what is more important with the organisation.

Or am I missing something blindingly obvious? Has anyone been able to get this to work?

thought of this after pressing save
Should I collect related contact data in the webform, then re-direct to membership contribution page which will populate with Contact 1's data and allow the separate payments to work as expected?

Cheers

Craig


texts:
We are migrating our hosting and need to point to a new email server. Can we turn off/delay scheduled/automatic notifications (CiviMail) while we reconfigure/test? Perhaps this is not necessary (i.e. mail is held if the connection to the mail server is lost).

Maybe there is a better way? Any advice to best manage pointing to the new server so as not to lose automatic mail scheduled while migrating would be great.


texts: I'm looking for a way to test schedule reminders for memberships. We have memberships that expire in a year, and we have setup a renewal reminder which also reminds our back office staff a month before the expiry date. But I need a way to test that the reminder actually works. Is there a way to test this quickly test this...obviously I cannot wait until one month before a particular membership expires to confirm this.


texts: Restrict event booking to those with a code

texts:
I want to allow a particular set of people to book an event before opening it up to anyone. If these were all members, then there are various ways to do this (e.g. the member only event extension) but that won't work (the CRM is still under development, memberships not up to date and we don't want to chase at present because of coronavirus). We do have all these people in a group, but they don't have accounts and getting them to log into accounts is also going to be messy so what I've done elsewhere with ACLs is also going to be hard to manage.
What I would like to do is issue a booking code to this group and only allow booking with the code. I'd thought I might be able to do this with CiviDiscount, but its a different use case! The best I can think of is have the booking via a web page listing the events which is password protected. Probably enough security for this, but not elegant!
Any other suggestions? I'm on WordPress.


texts:
I have a site where from the Contact Summary Screen, I select Action > Phone Call (or indeed any activity)

The default status is Scheduled. WHen I save the activity I get this "You cannot record scheduled SMS activity".

Same on every activity. If I choose Completed or other status, works fine.

Have upgraded to latest CiviCRM, also latest Drupal.

Have moved servers.

Have disabled all extensions and custom fields.

Have disabled CiviCase.

Still have the problem.

Nothing in the civi error log.

Nothing in the drupal log.

Any ideas welcome.


texts: CiviMail - copied mailings incorrectly "remember" recipients

texts:
We have a smart group we want to send a mailing to. The mailing (on the first tab) indicates "~458 recipients". But the smart group itself says it currently has 244 contacts.

The smart group is the only choice selected in the recipients for this mailing.

Is this a bug?  Or are we missing something?

EDIT

This looks like a deeper and more serious problem. It looks like maybe copied mailings are "remembering" the groups that were selected as recipients, even if you edit the recipients in the UI to include only one group.

Or "remembering" some of the recipients, anyway.  In one test, I copied a previous mailing that had many groups as recipients. I deleted all of the groups from the recipients, leaving a blank recipients field, and it still estimates ~390 recipients. Which is much less than the number estimated when it had all the groups, but obviously not zero, as it should be.


texts:
Looking to give access to a technician to help with message templates configuration eg offline receipts. What is teh best way to add a user and give access to this area only
Thanks in advance


texts:
I want to collect some data from our contacts through Google forms, which I can do.

But is there a possibility to link to civicrm through mailchimp? I am new to civicrm and mailchimp. What can be done and how to do it? I just want to know what all options I have, before I opt for a simple Google form.

I am using wordpress. And my CiviCRM works on LAN not integrated with any website.


texts: How do I use import and export php classes with aegir?

texts:
How do I use export.php and import.php to work with multiple sites run with Aegir.

All of them share the same files (php classes) and when I specify the site with -s mysite.org I get nothing (literally the command executes without error it just doesn't output anything).

When I run without spcifying mysite

php export.php -e Contact

  PHP Warning:
  include_once(/var/aegir/platforms/beta/sites/all/modules/civicrm/../../../default/civicrm.settings.php):
  failed to open stream: No such file or directory in
  /var/aegir/platforms/beta/sites/all/modules/civicrm/civicrm.config.php
  on line 118 PHP Warning:  include_once(): Failed opening
  '/var/aegir/platforms/beta/sites/all/modules/civicrm/../../../default/civicrm.settings.php'
  for inclusion (include_path='.:/usr/share/php') in
  /var/aegir/platforms/beta/sites/all/modules/civicrm/civicrm.config.php
  on line 118


texts: Webform CiviCRM not showing credit card payment fields

texts:
I am using CiviCRM 4.7 in combination with Webform CiviCRM version 7.4-14. The payment fields are not showing,  but on submitting it asks for the invisible fields to be filled in.

Is there anything wrong with the config that I am missing?


texts:
I am using CiviCRM 4.7.22 on Wordpress.

In the profile creation advanced settings, we have the option of automatically adding the person to a specific group when they fill out the profile form.

I have two groups, Donors and Members.  Members get access to restricted areas, while donors do not.

My dilemma is, if someone who already has a membership account decides to submit a separate donation, is he then going to be removed from the Membership group and placed in the Donors group?

Thank you.


texts:
I am using civi on wordpress 4.8.1

I just need to check something.

If I have a membership that expires tomorrow and Update Membership Statuses is not enabled to run Daily, will that person's profile still have an "Active" status when it expires tomorrow?

On the other hand, if I do enable Update Membership Statuses, will that person's membership profile status change to "Expired" tomorrow?

I am asking because the description for this job says "WARNING: Membership renewal reminders have been migrated to the Schedule Reminders functionality, which supports multiple renewal reminders.", so I not sure I should enable it at all.

Thank you


texts: How do you change default rows per page?

texts: I want to change the default from 50 to 100. Where would I do that.


texts: Line item detail report with subtotaled dollar amounts

texts:
Our accountants are asking for a report that seems pretty reasonable but I am not finding a civicrm report that will deliver it.  Maybe there's one that does but not obvious, or an extension?

All of our transactions are complex; very few have only one item.  So, the solution needs to be able to group by line item.  We need detail on each transaction, including date received and instrument type.  And each line item needs to be subtotalled.

The closest I've gotten is "Extended Report - Contributions with Price Set data" or "Extended Report - Price Set Line Items".  Both of these will display the desired item detail but don't provide a dollar subtotal for each line item.


texts:
I created a CiviCRM database locally on my windows machine on Wordpress. I am using a linux webserver to which I would like to move the data. I think there should be no issues in moving the data using phpmyadmin. Will there be any issues due to difference in OS ?

https://wiki.civicrm.org/confluence/display/CRMDOC32/Moving+the+database+using+phpMyAdmin

What other issues can be expected due to this movement?


texts:
Two questions I'm hoping someone can help me answer:

1) How do I make sure that our system does NOT send out emails to people who have a monthly recurring membership?

2) How do I make edits to rules of how membership renewal emails are sent?


texts: How can I create a copy of my CiviCRM site?

texts:
Upgrade instructions include:

  Use your backup to create a copy of your site (directories and
  database), and ensure that this copied site works correctly.

How can I create a copy of my CiviCRM site (on Drupal)?
Is there a big difference between making a copy on the same server or another one?


texts: PCP is still active after contribution page is disabled

texts:
The current behavior of civicrm keeps the PCP as active even if the contribution page related to it is disabled.

A real problem with this is you have someone who has made a P2P contribution page who might have no clue the page has been disabled by a site admin and is out promoting the page!

Thoughts on expected behavior?

Disable PCP manually when CP is disabled.
Keep PCP as it is and change the error message on PCP load.
Disable the PCP and send an email notification to the creator.
The current error is perhaps the correct and enough response to be shown to the user


texts: Need to change default text on Credit Card area

texts:
I am using civi 4.7.29 on wordpress 4.9.1
Please see the screen shot.  I am using PayPal Payments Pro and I need to remove or change the marked lines.  Can you tell me which file to edit?
Also I would like to change the color of the Contribute button if possible. If anyone knows where I can do that, please let me know.
Thank you.


texts: It's possibile in report of contributes, check for single contact a total amount of contributes pending? Or have a difference between complete contributes and pending contributes? thank'you


texts: cannot see default civisualize displays in 4.6.10

texts:
don't know if i am doing something wrong but just installed civisualize into drupal 7 / civicrm 4.6.10 set up and if i try say
/civicrm/dataviz/contacts

i simply get text

Contacts Overview

contacts selected from a total of records
Type
Source of Contact
Gender
Day - Contact Created
Date - Contact Created

with no visuals

any thoughts would be welcome

thanks for the reply am attaching screen grab of the page view where i expected to see visualisation, have not seen any error reports and i did set path to extensions directory when i set previous extensions which appear to work fine

any further ideas more than welcome as this extensin would be really useful to us if we can get it working


texts: Drupal taxonomy and Civi option groups integration

texts:
Is there any kind of integration between Civi option groups and Drupal taxonomy vocabs?

For instance I'd like to create a Civi custom field with an option group whose options are populated from a Drupal taxonomy. Or vice versa!

Has that ever been acheived? I'd be glad to know if it has. Thanks for your thoughts.


texts:
We have an issue where CiviCRM sends mail on behalf of our client for newsletters, media releases etc.

But because we don't have their FQDN in our spf record some spam filters will reject the mail thinking civiCRM are spoofing the clients mail account

This is a problem ! does anyone know the fully qualified domain name they use so I can add it into our records to solve this issue?

Thanks


texts: Fatal error using Paypal in Version 4.7.29

texts:
Using the payment processor PayPal_Standard on a fresh install of CiviCRM Version 4.7.29 (with Wordpress 4.9.1 on Centos 7.4) breaks all contribution pages where PayPal is enabled. The result is a blank page. In the Apache error log there is:

PHP Fatal error:  require_once(): Failed opening required 'CRM/Core/.php' (include_path='.:/somedir/wp-content/plugins/civicrm/civicrm:/somedir/wp-content/plugins/civicrm/civicrm/packages:/somedir/wp-content/plugins/civicrm/civicrm/vendor/tecnickcom:/somedir/wp-content/plugins/civicrm/civicrm/vendor/phpseclib/phpseclib/phpseclib:/somedir/wp-content/plugins/civicrm/civicrm/vendor/pear/pear_exception:/somedir/wp-content/plugins/civicrm/civicrm/vendor/pear/auth_sasl:/somedir/wp-content/plugins/civicrm/civicrm/vendor/pear/net_socket:/somedir/wp-content/plugins/civicrm/civicrm/vendor/pear/net_smtp:/somedir/wp-content/plugins/civicrm/civicrm/ve in /somedir/wp-content/plugins/civicrm/civicrm/Civi/Payment/System.php on line 59, referer: https://someurl/civicrm/?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=1

When disabling PayPal (= pay later) the contribution pages work fine.

Any ideas what might be going wrong here?


texts:
I recently updated CiviCRM and am now having errors with the CiviMail reports. My setup uses:
CiviCRM 5.32.2
Drupal    7.77
PHP 7.4
Below is the step-by-step description of what happens.

Click on Mailings in CiviCRM
Select Scheduled and Sent Mailings
Click on any completed mailing Report
Click on any of the report items having more than 50 results--"successful deliveries" or "unique opens," etc.
When I do this, I get the list of contacts and 3 errors are logged in the Drupal logs. They are:

_ERROR 1

Location: http://mysite.org/civicrm/report/instance/33?mailing_id_value=390&
qfKey=54cfb81fd804cbcd6b07435da277f9354ce7ca54fd178e9_4603&force=1&crmPID=3&
snippet=json
Referrer: http://mysite.org/civicrm/report/instance/33?reset=1&mailing_id_value=390
Message: Notice: Undefined offset: 3 in HTML_QuickForm->addElement()
(line 648 of
/home/mysite/www/www/sites/all/modules/civicrm/packages/HTML/QuickForm.php).

_ERROR 2

Location: http://mysite.org/civicrm/report/instance/33?mailing_id_value=390&
qfKey=54cfb81fd804cbcd6b07435da277f9354ce7ca54fd178e9_4603&force=1&crmPID=3&
snippet=json
Referrer: http://mysite.org/civicrm/report/instance/33?reset=1&mailing_id_value=390
Message:  Warning: array_merge(): Expected parameter 2 to be an array,
null given in HTML_QuickForm->addElement() (line 648 of
/home/mysite/www/www/sites/all/modules/civicrm/packages/HTML/QuickForm.php).

_ERROR 3

Location: http://mysite.org/civicrm/report/instance/33?mailing_id_value=390&
qfKey=54cfb81fd804cbcd6b07435da277f9354ce7ca54fd178e9_4603&force=1&crmPID=3&
snippet=json
referrer: http://mysite.org/civicrm/report/instance/33?reset=1&mailing_id_value=390
Message: Notice: Undefined index: class in HTML_QuickForm->addElement() (line 649 of
/home/mysite/www/www/sites/all/modules/civicrm/packages/HTML/QuickForm.php).

Next, click the up arrow on the upper right of the list for going to the next page of contacts. Once again the same 3 errors above are added to the Drupal Log.

The page loads with the following form and SQL query (see image) and the up-arrow is gone from the paging. One time, the top toolbar drop-downs also stopped working.

My question is: Why is this quickform displaying when you go to page 2 or any page past the first one? Insights, please?


texts: Reserved payment-instruments: can they be removed?

texts: I found that there a few payment-instruments being reserved and therefor can't be removed in the UI, while setting up CiviContribute. These are 'Credit Card', 'Debet Card' and 'Check'. I'm 100% sure that in this case these will never used, so I'd like to remove them. I've already removed all cards in Accepted Credit Cards. I know how to delete the instruments in mysql, but I wonder if it would cripple something else?