Is there a way automatically get sort name and greetings to be correct for households? If you want have individuals and households to show up in alphabetical order by last name you need to enter the hh like Smith, Jane and Joe.  Fine except now the greetings will be Dear Smith, Jane and Joe and the addressee will be Smith, Jane and Joe.  So then one has to enter custom greetings and addressee.

My users are bad at that.  Every time we send out an email or postal thing, I find I have to wade through the data and fix a bunch of them.

If you enter the HH as Jane and Joe Smith, the greetings are better; though, we'd prefer Dear Jane and Joe to Dear Jane and Joe Smith.  At least if you miss one you don't end up addressing something odd.  But then the sort is not by last name.

Maybe some fancy parsing with smarty in the greeting.

Have you tried changing the sort name so the results show up in alphabetical order? (Administer/Customize Data and Screens/Display Preferences). I set it like this:

{contact.last_name}{, }{contact.first_name}{ }{contact.middle_name}

In that way my contacts are sorted on the last name and I also include the middle_name (which means something in Dutch so it becomes 'Boer, Jan de').

But perhaps you tried that and your problem is somewhere else?


Including Premiums section breaks Contribution Page when using Stripe The "Make Contribution" button fails to load confirmation page. We had recently added a captcha and a premium section to the page, so tried disabling them. We found that the premium section was the culprit, and disabling it allows the page to work as normal.

Running 5.19.4 on Drupal 7. No useful errors on Civi or Drupal logs. Is anyone else having this problem?

April 21:

The issue appears to be related to Stripe. The submit button is generating a couple of ajax calls to the stripe url as:

https://q.stripe.com/?event=elements.event.focus&event_count=12&timestamp=1587498851543& ...

https://q.stripe.com/?event=elements.event.blur&event_count=13&timestamp=1587498851574& ....

After that first click, presumably the stripe extension is going to disable the submit button to avoid multiple clicks, and then it doesn't re-enable it, presumably because it doesn't get back the answer it expects, so no further action happens on clicking submit again.

Apr 28:

For anyone else trying to debug this - the first clue is to enable javascript debugging, i.e. at /civicrm/admin/setting/stripe:

Enable Stripe Javascript debugging?

That provides me with the clue that it's getting blocked at line 335 of
civicrm_stripe.js (of the unminified version), i.e. it's using a jquery
validation plugin that thinks the form is not valid. If I remove that check, it goes ahead (and tells me my credit card is invalid).

So we've narrowed it down to some kind of conflict between the premiums section and the stripe extension's use of the jquery validation plugin.


Why does setting "CVV required for backoffice" to 'NO' also unrequire it on front facing forms I just ran in to this issue on a site - namely setting "CVV required for backoffice" to 'no' results in it CVV fields showing as 'not required' site wide, ie on all public facing contribution pages.

I found a question about this here https://forum.civicrm.org/index.php?topic=34624.0

If this was the intended and desired outcome then at least the help text and label should be updated.

Noting that on 4.6 this is at civicrm/admin/setting/url?reset=1

At 4.7 it is at civicrm/admin/setting/preferences/contribute?reset=1

What should next step be? Have it perform as described, or describe how it performs?

This is a bug and I have opened a JIRA ticket and will update when something comes of that.


Error on Event Registration Page We created and event without problem however once someone clicks the Register Now buttom on the page the following message is seen. I am running version 5.9.0

Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to member your administrator or service provider with more details about what action you were performing when this occurred.
You do not have permission to access this page.

Return to home page.

The full error trace is below please help.

**BACKTRACE**
#0 /var/www/html/sites/default/files/civicrm/ext/ca.bidon.reporterror/CRM/ReportError/Utils.php(31): reporterror_civicrm_generatereport("Jamaica Teachers Association", (Array:2), NULL, (Array:0))
#1 /var/www/html/sites/default/files/civicrm/ext/ca.bidon.reporterror/CRM/ReportError/Handler/FormsNoReferer.php(54): CRM_ReportError_Utils::sendReport((Array:2), (Array:0))
#2 /var/www/html/sites/default/files/civicrm/ext/ca.bidon.reporterror/reporterror.php(168): CRM_ReportError_Handler_FormsNoReferer::handler((Array:2), (Array:0))
#3 /var/www/html/sites/all/modules/civicrm/CRM/Core/Error.php(368): reporterror_civicrm_handler((Array:2))
#4 /var/www/html/sites/all/modules/civicrm/CRM/Event/Form/Registration.php(265): CRM_Core_Error::fatal("You do not have permission to access this page.")
#5 /var/www/html/sites/all/modules/civicrm/CRM/Event/Form/Registration/Register.php(107): CRM_Event_Form_Registration->preProcess()
#6 /var/www/html/sites/all/modules/civicrm/CRM/Core/Form.php(585): CRM_Event_Form_Registration_Register->preProcess()
#7 /var/www/html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(92): CRM_Core_Form->buildForm()
#8 /var/www/html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Event_Form_Registration_Register), “display”)
#9 /var/www/html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Event_Form_Registration_Register), “display”)
#10 /var/www/html/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("display")
#11 /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php(309): CRM_Core_Controller->run((Array:3), NULL)
#12 /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:15))
#13 /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#14 /var/www/html/sites/all/modules/civicrm/drupal/civicrm.module(445): CRM_Core_Invoke::invoke((Array:3))
#15 /var/www/html/includes/menu.inc(527): civicrm_invoke("event", “register”)
#16 /var/www/html/index.php(21): menu_execute_active_handler()
#17 {main}

From the error it looks like the user doesn't have necessary permission to access the page. You will need to give permission to user to register online.

Thanks

Pradeep


Custom Search Problem - Unknown column contact_a.id in field list when tagging returned contacts I'm running into almost the same problem that was detailed a couple years ago on the forums at https://forum.civicrm.org/index.php?topic=28829.0.  When I run a custom search using the built in Contributions made in Year X and not Year Y search, and then pick Select All Results and select Tag Contacts from the drop down, I get a DB Error: no such field.  The full logged error is:

Jan 06 16:27:59  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] =>
SELECT     contact_a.id as contact_id
FROM       civicrm_contact AS contact
LEFT JOIN  civicrm_contribution contrib_1 ON contrib_1.contact_id = contact.id

WHERE      contrib_1.contact_id = contact.id
AND        contrib_1.is_test = 0
            AND contrib_1.receive_date >= 20150101000000 AND contrib_1.receive_date <= 20151231000000
GROUP BY   contact.id

ORDER BY   donation_amount desc
 [nativecode=1054 ** Unknown column 'contact_a.id' in 'field list']
    [type] => DB_Error
    [user_info] =>
SELECT     contact_a.id as contact_id
FROM       civicrm_contact AS contact
LEFT JOIN  civicrm_contribution contrib_1 ON contrib_1.contact_id = contact.id

WHERE      contrib_1.contact_id = contact.id
AND        contrib_1.is_test = 0
            AND contrib_1.receive_date >= 20150101000000 AND contrib_1.receive_date <= 20151231000000
GROUP BY   contact.id

ORDER BY   donation_amount desc
 [nativecode=1054 ** Unknown column 'contact_a.id' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT     contact_a.id as contact_id
FROM       civicrm_contact AS contact
LEFT JOIN  civicrm_contribution contrib_1 ON contrib_1.contact_id = contact.id

WHERE      contrib_1.contact_id = contact.id
AND        contrib_1.is_test = 0
            AND contrib_1.receive_date >= 20150101000000 AND contrib_1.receive_date <= 20151231000000
GROUP BY   contact.id

ORDER BY   donation_amount desc
 [nativecode=1054 ** Unknown column 'contact_a.id' in 'field list']"]
)

This appears to occur no matter what size the result set is (I had one test set of 1 result, and 1 with 1767), on current versions (I noticed it first on 4.4.19 but I retested on 4.6.10 with the same result), and does occur not just for adding a tag but also for putting them in a group like the original poster describes.

Has anyone found a solution for this or at least a workaround?

I just tried to reproduce the issue in 4.6.11 and wasn't able to; though, it's possible I didn't pick the "correct" criteria.  I know there has been some work done on the dynamically created sql, which this is, in more recent releases that might have fixed the issue.  I suggest you try to reproduce it in one of the demo databases.

When I've run into things like this before, sometimes, though not always, I can get around the issue by running the query, creating a smart group out of it and then doing an advanced search with the only criteria being the contacts are in that smart group.  Then doing the tags or whatever with that resultant set.


Broken Search Builder just upgraded to 5.28.3.
Thing is, my search builder is looking like this now - can't select a field anywhere :/

Any Ideas?
Thx & Regards

Well, looks like i f*cked it up myself:
Some days ago we created a new contact subtype and renamed it afterwards.
Since renaming didn't work out as planned and some DB-Entries stayed behind, i changed em manually. Guess what, i had a typo somewhere.
Changed it and the search builder is back to normal.
Sorry for bothering you and Thanks for your help.


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

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

Can anyone help? Thanks in advance.

Best wishes,
Minna
Baffled in Liverpool

I assume the email address you are referring to is on the location tab.  If so, the assumption is a location has a fixed email address.  When you change the email address on a location it changes it everywhere that location is used.

So you need to create a new location.  Unfortunately, location appears to only look at the address part so if you create a new location with the same address as another but a different email or phone number, it doesn't create a new address.  It just updates the existing address.

The work around is to make the address part different.  I'd suggest using the Supplemental Address 1 to indicate who the coordinator is.   You could simply put their name there or something like Event Coordinator: Name or Attn: Name.


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

For the text separator you can use it in sql as CHAR(1), and can use CONCAT() to combine with other strings.


How can webform load billing block information for a specified user? The context is a staff member taking a phone call from a member and then filling in a webform including a payment for them.

The webform is added to the actions menu so the webform is passed '?cid=XXX' to load the contact.  The problem is that when it comes to payment (by Stripe), the billing block is loading the details of the person filling in the form, not those of the person on the phone.

How can webform be configured to use the details of the contact on the form?  Answers involving code writing are fine:-)

First thing to do is to try this PR by Coleman:
https://github.com/colemanw/webform_civicrm/pull/206


Best practice: Multiple event types or custom data fields? I've only been working with Civi for a couple of weeks ...

Say we want to offer three workshops or classes:

Basketweaving 101
Basketweaving 102
Basketweaving 103

And later we want to be able to produce reports to do things like: "Show me everyone who has taken 101 and 102 but not 103."

Would it be better, when creating a new event, to have an Event Type for each of these types of workshops, or alternatively to use the "Workshop" event type and have custom data fields that would allow the registrant to select 101, 102 or 103?

I'm thinking that it may be nice to produce reports that show all workshops just by selecting one workshop type, which would argue for creating custom data fields.

On the other hand, perhaps it's easier doing reporting on standard fields than custom ones, or there may be other "gotchas" with custom fields that I'm not aware of, which would argue for creating multiple Event Types.

Or perhaps it doesn't really matter?

Thanks in advance!

For your reporting perspective, it'll be basically the same.  However, the two options would make your registration process very different.  This should guide your decision.

If you have a "one-room schoolhouse" model for your classes where one session includes advanced students taking it as Basketweaving 103 as well as new folks registered as Basketweaving 101, the participant custom field would allow for them to choose which one they're registering for.  From a logistical perspective, having a single event would make it easier to set a cap on total enrollment, see the full roster, and only have to set the location and time once.

On the other hand, if you have Basketweaving 101 on Tuesday evenings, 102 on Wednesday evenings, and 103 on Saturday mornings, perhaps with different instructors, you'll want completely separate events.  You could set up event types for each, or you could have a single event type for all basketweaving and an event custom field for course number.  If you have a dozen or more separate courses, you'll probably want to put the course number in an event custom field so you don't have an overwhelming number of event types.

You should be aware that if site visitors have the ability to view event custom fields, the custom field is displayed on the event info page.


CiviEvent Confirmation Email Displaying Profiles Not Used In Event We have created some custom fields/profiles to use with certain CiviEvent registrations. These profiles only display in the event registration when they are selected in the event setup - as expected. However, these profiles appear in the confirmation email despite not being selected for use in the registration. See image below - the highlighted area shows the proflies/custom fields that should NOT appear because they were not used in the event creation. How do I stop them being sent with the confirmation when they are not used?

Thanks,
Eric
CiviCRM 5.4.1
WP 4.9.8

Eric,
Disabling those fields should remove them from the confirmation email. If you can't disable them (maybe they are from another active event), you can edit the Event Registration Confirmation and Receipt message and target the Event using $event.id (as in {if $event.id != "40"}do such and such{/if} ).
Administer > CiviMail > Message Templates - System Workflow Messages
Good luck!


Upgrade from 5.11.0 to 5.12. failing database update - solution found I'm failing because mysql doesn't like characters in a city name:

UPDATE civicrm_state_province INNER JOIN civicrm_country ON civicrm_state_province.country_id = civicrm_country.id SET civicrm_state_province.name = 'dolnośląskie' WHERE iso_code = 'PL' AND abbreviation = 'DS'

If fails with "ncorrect string value: '\xC5\x9Bl\xC4\x85s...' for column 'name' at row 3]"

Running civicrm under Joomla 3.9.5.

Solution below.

It was my table and column collation settings. Both were latin1_swedish_ci. Evidently this collation does not support the weirdo characters those foreigners use ;^).

I rolled the database back using the backup I made (ALWAYS glad I make a backup before upgrading!!!). Then using phpMyAdmin I edited the table civicrm_state_province to have a collation of utf8_general_ci. I then re-upgraded the civicrm installation and all went well.


Quickform: Set the "Selected" value in a select element Maybe is a simple question but, in my form, I not able to set the "selected" value, in my SELECT element:
The following is my code:

CRM_Financial_BAO_FinancialType::getAvailableFinancialTypes($financialTypes, 3);
$this->add('select', 'financial_type', ts('Financial Type'), $financialTypes, 'TRUE');

This is how you do it:

CRM_Financial_BAO_FinancialType::getAvailableFinancialTypes($financialTypes, 3);
    $this->add('select', 'financial_type', ts('Financial Type'),
            $financialTypes,
            'TRUE'
            );
    $this->_elements[4]->setSelected(9);

You need to inspect $this and determine which of the elements is the select you want to modify. In my case it was the 4th one.

You then need to inspect the select (from the browser) and find out the value for the option that you want selected by default.


Settings - Outbound Mail are not saved please help, I have a Joomla 3.6.5 and CiviCRM 4.7.14
I just migrated from the dev site to the live site, and now when I check the Outbound Mail settings in CiviCRM, they are empty.
Everytime I fill them out and press save, once I reaload the settings page, they are empty again.

Please, where is this info stored?

Thank you

The typical troubleshooting steps here would be to check for errors in the CiviCRM log as well as to check for JavaScript errors in your web browser's console.


Is the Max Participants setting on Events broken in 5.0? Having recently upgraded to version 5.0 I'm now seeing that although I set the Max Number of Participants at a figure lower than the number of people registered for an event, I can still register for the event through the front end, and I'm not seeing the Event Full message.
Anyone else seeing this issue?

Just did a test with 5.0.1 and wordpress 4.9.5 and it worked like it should.

Have you tried clearing the cache?


HOWTO: provide log-in (uid and pass) to Civicrm Contact - NEW or Existing Is it possible to assign contacts created in Civicrm with Drupal UserID and Password during either CIVICRM contact creation or contact editing process with new, existing or imported contact?

I believe one can create "users" in Drupal and then export/sync the drupal user into CiviCRM contacts.  But, can it be done in reverse?

Help Appreciated

Thnks

There are several ways to go about this.

I wrote a somewhat convoluted guide a couple of years ago for creating a Drupal contact for a bunch of existing Civi contacts:
http://wiki.civicrm.org/confluence/display/CRMDOC/Creating+a+Drupal+user+for+every+CiviCRM+contact

However, I'd say the best practice today is to use the civicrm_entity Drupal module in combination with the rules module to automate this.  There's an excellent blog post about that here: https://civicrm.org/blogs/petednz/creating-drupal-users-made-easy-single-or-multiple-contacts-civi-imports-and-webforms


Contact Search Column & Data Mismatch We're running Civi 4.7.20 on Wordpress 4.8.  When searching for contacts, it appears that the column headers do not match with the data type for the fields.  However, when looking at an individual record, values appear in the proper fields.

This behavior was also observed in the demo sandbox.

This has been fixed at https://github.com/civicrm/civicrm-core/pull/10556 and is included in 4.7.21 version.

You can apply the PR on your site if you don't wish to upgrade now.


How can I enable self-serve sign in / check in to an Event? I'm using Civi 5.31 on Drupal 7.
I want to enable self-serve check-in / sign in for an Event. Attendees should be able to click a link (and/or scan a QR code) to either RSVP for the Event, and receive a Status of Attended, or, update a previous RSVP with a Status of Registered to Attended.
Only attendees physically present at the meeting, or participating via Zoom, Jitsi etc will be given the link/shown the QR code to scan.
There is an existing self-service capability for participants to Cancel or Transfer a registration, and to set time limits for a 'window' within which to cancel or transfer. Self-serve check in / sign in could work similarly.

I know there are various ways for 'staff' or a meeting organizer to do this for all attendees, but I want to avoid the manual tedium of updating multiple attendees from Registered to Attended by allowing self-serve check-in/sign-ins.
Thanks!

I had the same process in place before started using civi - zoom integration.
The process looked like this:

Create webform to update participant (an existing contact) with checksum.
Use google qr to generate the QR code with token so that by scanning the qr code takes you to https://your.org/node/2?cid1={contact.contact_id}&{contact.checksum}
They can click submit to mark themselves as attended (or you can even make this form auto submit with simple javascript).
You can set that thank you page after submission is actually a redirect to the online conference link or wherever.

It's a bit hacky, but it works.


Is it possible to find out who installed an extension update? One of my clients had the API v4 extension updated to 4.3.0 last evening, and so today the contact summary screen was broken - because the API extension isn't compatible with the contact summary extension in 5.10.4.  Is there any way of finding out who installed the extension update?  Some log somewhere?  This is a Drupal site, by the way.  One thought (maybe silly!) - the extension wouldn't update itself after a given time, would it?

The extension wouldn't update itself.

If you have Detailed Logging enabled, you should be able to figure out who updated it by checking log_user_id in log_civicrm_extension.  If you don't have that:

Check the "last action" times in the Drupal "Users" list.  Is there only one person who was active?  Great!
Check your web server logs for the URL that updates the extension - something like https://mysite.org/civicrm/admin/extensions?action=update&id=net.ourpowerbase.sumfields&key=net.ourpowerbase.sumfields

You should be able to get an IP address, which, depending on whether folks access the site from one IP or not, should be able to give you your answer.


Remove Unnecessary Fields from Contact and from Activities There are areas where an Individual record is opened or used in the Activities. I think there should be an option for their removal.

For example when creating individual records; We have not used the current Employer, Task Title, Nickname, Phone Location, Phone Type, Contact Source and External ID options for 6 years. But it's on the screen. I think they have to be hidden in some way.

In the same way activity records; I don't use fields like Location, Transaction Status, Priority. These sometimes cause incorrect entries and there are no menus to hide.

Is there any development or solution proposal?

https://lab.civicrm.org/dev/core/uploads/0157eea8b229b838a40d705febf77683/-001277.png

https://lab.civicrm.org/dev/core/uploads/778c239a93ab572ac2ed1455af8738c6/-001276.png

Work is underway on a Form Builder that will allow folks to hide fields as needed.

For now, you can hide fields with jQuery, ideally loaded through an extension.  However, some of the fields you mark are required and so their values would need to be set even if hidden.


Contact Import explode issue with matching contacts I am getting the following warnings when trying to import contacts:

Warning: explode() expects parameter 2 to be string, array given in //wp-content/plugins/civicrm/civicrm/CRM/Contact/Import/Parser/Contact.php on line 704

Warning: array_pop() expects parameter 1 to be array, null given in //wp-content/plugins/civicrm/civicrm/CRM/Contact/Import/Parser/Contact.php on line 706

Warning: Cannot modify header information - headers already sent by (output started at //wp-content/plugins/civicrm/civicrm/CRM/Contact/Import/Parser/Contact.php:704) in //wp-content/plugins/civicrm/civicrm/CRM/Utils/System/Base.php on line 912

At first I thought there were unseen characters in the csv file but determined it only complains on contacts that already exist.  It appears to update the matching contact but does not add the contact to the specified group on import and it creates a strange log in the matching contact's record with references to other contacts in the import!

The comment above this section of code in lines 704-706 refers to "CRM-10433 - might return comma separate list of all dupes".  The Jira title of this issue is: import fails when updating on duplicate, adding to group, and multiple duplicates exist (related!?!?)

I am deduping on Name and Email using the Update option although the error also occurs on Fill. I am running 4.7.19 in WP and I upgraded recently from 4.6.20 where the client did not have this problem.

Is this fix from 4.2 no longer compatible with 4.7.x!?!?

Per comment above the fix was part of CiviCRM 4.7.23 and hence the solution is to upgrade to the latest version where it is fixed.

( I keep seeing issues bumped, presumably by a bot where it is a long-fixed bug & no longer relevant)


How can I hide specific tabs in member view regardless of viewer permissions? We have two different user permission groups: Finance team who can see the Contributions tab, and Personnel, who can't.  We wanted to hide some custom field tabs for both groups, and mimicked the documentation on the civicrm_tabs hook, simply using

unset ($tabs[12]);

However, the index 12 corresponds to different tabs for the two types of users, because the count changes depending on whether or not the Contributions tab is visible.

How do we hide tabs in a manner independent of the user group and the other tabs they see?

The $tabs variable passed into the tabs hook is an array of arrays, with unique identifying values in the "id" column of each entry.  I found a function to scan all elements of the array to check the "id" column for a given value.  This returns the correct $tabs index to use with the unset() function.

function searchForId($id, $array) {
  foreach ($array as $key => $val) {
    if ($val['id'] === $id) {
      return $key;
    }
  }
  return null;
}

Example usage:

$duestab = searchForId('custom_15', $tabs); //tab holding dues
unset( $tabs[$duestab] );

If my server used PHP 5.5 or greater, I could have skipped the searchForId function and used a one-liner:

$duestab = array_search('custom_15', array_column($tabs, 'id'));
unset( $tabs[$duestab] );


Cannot save Mosaico Templates We are on the latest version of civicrm 5.3.1 and the lastest version of Masaico and now i am getting this error message when I try to edit and save a template:

  API permission check failed for MosaicoTemplate/create call;
  insufficient permission: require edit message templates and edit
  user-driven message templates and edit system workflow message
  templates

Thanks Karin!

There are some new permisssions to review/set: navigate to your where set permissions in your CMS. In Drupal: People -> Permissions - and look for these:


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

Many thanks,
-Ian

The select2 is indeed complicated but you don't need to go there. The underlying select element is still there (just hidden) and still fires regular "change" events and you can still get it's value using the ordinary $(element).val() jQuery.


Minute as a time unit for scheduled reminders Right now the smallest unit is the hour, so I can schedule a reminder 1 hour before or after something.
What do I do if I wanted to send a reminder 30 minutes before something? Is this possible right now?
If not, how difficult would it be to make an extension that would introduce minute as a time unit for reminders? Would this be difficult to achieve? Are there any clever workarounds?

It's a legitimate question although even if you could do it per minute, you'd then have to have cron run every minute, which is technically possible but might be a bit excessive.
If you're talking about reminders for activity assignees, an alternative might be to turn on the setting at Administer - Customize - Display Prefs - Include ICal Invite to Activity Assignees. Then they can put it in their calendar and they can set it to remind them as desired.


CiviMail > New Mailing > No recipients Error We've recently installed CiviCRM 4.6.6 and we're on WordPress 4.3. I'm experiencing the same issues as shown in this thread: CiviMail Mailing - Unable to select group, getting error of No recipients
When I go into New Mailing, No Recipients shows up on the right. I can't enter email addresses, I can't select a group, I'm stuck. If I use Search and select a group, and pick the Action to Send a Mass Mailing, the Mail screen has Recipients = Search Results, but still says No Recipients. I'm stuck. Since Mail won't work Debug and Backtrace can't either. I don't know what Ajax is, I'm not that techie. We're on DreamHost, no cpanel, but I can use FTP. Send Mail works and there's no one opted out or anything in my test group. This looks like a bug that's been around for a few months? How can I fix this??? Thanks, in advance...jim

This > check the Mailing list checkbox for Group Type

Solved this issue for me.


How do I create an email template? I currently send a 'thank you for renewing' email out on an individual basis. I know there is a function for designing a template so I don't need to copy and paste text from Word, but I can't find the option. I would be grateful if someone could point me in the right direction.

Many thanks!

You can find them by going to Mailings > Message Templates OR Administer > Communications > Message Templates in the menu.

Here is the documentation: https://docs.civicrm.org/user/en/latest/email/message-templates/


Send Email to Assigned In an Activity I am creating an activity and assigning it, but would like that to be emailed to the assignee. Is there a way automatically email the person that is assigned on an activity?

There is a setting at Administer/Customize Data and Screens/Display Preferences, a tick box with the description Notify Activity Assignees. Ticking that will send a mail to the assignee.


Repeat currency symbol in a contributions list I would like to send a classic mailing to our donors which lists the contributions of the previous fiscal year following this guide.

But the list I obtain, only have the currency symbol near the first contribution.

And even in the above-mentioned guide, the currency symbol appears only near the first contribution:

Is there a way to fix this and have currency symbol near each of the contributions listed?

Thank you.

The short answer is: "yes".

And the longer answer is: dig into the code and submit a PR, or hire someone to do that.


Report UI is broken in 4.6.2 and 4.6.3 We have version 4.6.2 and 4.6.3 installed in different sites, and just noticed that the new Reports tab interface UI is broken.  You can click on the tabs but the main body of the report settings - columns, grouping, sorting, filtering, etc - is always visible just as it was in older versions.

I've checked the official demo site, running 4.6.4, and it looks OK there.  I also have a dev site on my local machine running 4.6.1 and it's OK there too.  Seems unlikely to me that this was broken for 2 whole "dot" releases.  I've cleared caches on Civi and Drupal.

Suggestions?

This might be the same issue as reported here: http://forum.civicrm.org/index.php/topic,35596.0.html

Could you check if you have the 'Extended reports' extension enabled? That isn't yet compatible with the new interface, so disabling it should fix the problem.


CiviRules - Configuring a rule to grant a point for each month that a contact has an active membership We are running CiviCRM 4.7.12 on Wordpress. We have a number of donors who have an active membership. They contribute monthly towards the membership. We have CiviPoints and CiviRules installed. We want to use CiviRules for the following:

Grant 1 point to a contact for each month that the contact remains an active member (the membership status must be either new or current).
Deduct 2 points for each month that the contact remains inactive (due to cancellation or lapse in payment)

How can we setup CiviRules to perform 1 and 2 above?

Out of the box that is not possible with CiviRules. You need to write your own trigger which fires every month.

The good news is that the SQLTasks extension might do this: https://civicrm.org/extensions/sql-tasks-extension-configurable-recurring-tasks


How do I add a search box to our website? When I read the help section, it tells me where to go, but it says I don't have access.  I just want a search box on our site.

Discuss this with OneEach Technologies (your hosting partner/provider). You likely don't have permissions needed to make the changes you want without their support.


Civi 5.6.0 - wrong css z-index on Activities page when creating/viewing activity CiviCRM 5.6.0
Joomla 3.8.12
php 7.0.32

On the activities tab of a contact, when you create or view an activity, the panel which pops up is displayed behind the black CiviCRM menu bar, and also behind the main Joomla menu bar. The same happens with when you view an activity in the Find Activities results page.

Not a big deal, but needs fixing.

Update: it's not only the activities page/tab. It seems to be every page. Wherever there's a pop-up window or a pull-down menu, the black CiviCRM menu is in front of it.

Jern,

This is because of Joomla theme css might be conflicting with CiviCRM css. Try switching the theme to default one if you can replicate the same issue. I tried on my local machine on 5.6.0 and couldn't replicate the issue. Also try to perform CiviCRM cleanup cache if it helps.

Try after reverting the commit in your core file.


Deleting vs. Disabling an Activity Type I am wondering what the difference between deleting and disabling an activity is? I would like to clean up the activity field options drop down menu to only reflect the ones we would like to continue using without deleting or affecting any of the historical activities associated with the ones we are planning to delete.

Thanks for your help.

Disabling the activity is what you want. That removes an activity as a live option moving forward, but maintains the historical data.

Deleting the activity removes it as an option and erases the historical data.


Two domains, one site how to manage civicontribute? Civicontribute post-transaction response page always reverts to primary domain. How can I force it to stick with the original domain?

This page: https://wiki.civicrm.org/confluence/display/CRMDOC/Multi+Site+Installation

Plus Domain Access Module (Drupal) got me 90% of the way there - however no matter what I try, contribution pages and event pages auto-generate their page links with the primary domain.


Autoassign relationship when creating contact I'm looking for a way to auto-assign relationships between the current drupal user and created contact. I know there is extension CiviRelate, but it only works when using "profiles". I'm looking for a way to auto-assign selected relationships when the user creates contact from the CiviCRM backend (from the dashboard).

You could achieve this with the CiviRules extension. The extension can be found here: https://civicrm.org/extensions/civirules and the documentation here: https://docs.civicrm.org/civirules/en/latest/

You should add a rule with trigger "Contact of any type is added" and then some conditions (perhaps on contact type or contact is in group if required). You can then use the action "add relationship".


Why does Assigned To: for an Activity to any admin, and only one other user not work since 4.6.7? We're on 4.6.9 and Drupal 7.

Ever since the changes to, then the rollback of, Access Control Levels (ACLs) /user permissions in 4.6.6/4.6.7/4.6.8 (see here), I can Assign To: an Activity to all users except our two Admin users, and one other user, who has the same permissions as other users who can have an Assign To: for an activity.

I'll check these three user records (one of which is mine) for any corruption or other weirdness.

Has anyone else experienced this?

I'm not sure how I could duplicate on demo/sandbox without doing the same version updates/rollbacks we did from 4.6.6 to 4.6.8.

In the any thoughts category: If you can't find it in 4.6.8 demo and you mention a rollback. A common problem with rollbacks is that when a table is created during an upgrade and you use a db dump to roll back to previous version, the created table stays in the database. If you then redo the upgrade, it does not expect that table to be there. So it could leave you with a system that is in disbalance.

So, my question is, when you did the rollback, did you remove and recreate the DB or did you just apply the db dump (with the risk of leaving a created table behind)?

If you did the latter: Do you still have your 4.6.6 DB? If so, could you immediately upgrade it to 4.6.8 and see if the problem still exists? If it doesn't, you could compare the table structures of your current live DB and this upgraded DB.


civiMail doesn't work I'm getting this error message trying to send a bulk mail from civimail:

Finished execution of Send Scheduled Mailings with result: Failure, Error message: API permission check failed for Group/get call; insufficient permission: require access CiviCRM

Who is is that needs permission?  The logged in drupal user?  Civicrm contact? SMTP user?  Someone else?

The mail accounts from which the mail is sent ask for a username and password.  Same question, what sort of user is needed here?

Thanks,

Jack Donohue

Its the CMS user that you have used to set CiviCRM cron needs some administrator permission to process your Schedule jobs. Please check the cron user role and assign necessary permission.

Cheers

Pradeep


Dynamically send scheduled email to a group? I'd like to schedule an email to be sent next month to a group.

Is there a way for me to schedule the email today, but to still have individuals that are added next week to the group receive that email?

Civicrm 4.6.4 and Drupal 7.38

Not sure how I missed this, but this post confirms that email recipients are defined at time of scheduling the mailing for smart groups.

(Since this is true for smart groups, I'm assuming this is also true for normal groups – indeed as my brief testing (above) demonstrates.)


Changing information displayed for Pay Later feature on contribution pages Does anyone know where to go in Civicrm to change the I will send payment by check option on contribution pages?

I want to replace it with something like I will pay by cash or Bank Transfer

It is on the Contribution Amounts tab for any Contribution Page eg http://d46.demo.civicrm.org/civicrm/admin/contribute/amount?reset=1&action=update&id=1.

Enable Pay Later and you will see

Pay Later label
Pay Later instructions


Steps to move from paypal to Stripe? If I move from paypal to stripe, what steps or information I need to take into consideration in terms of recurring contribution? And how to initiate the moving existing recurring contribution profiles?

You would need to reach out to Paypal and Stripe directly to ask them about how to initiate the process of transferring your recurring giving.  I would suggest inventorying your existing recurring records in Paypal first, to see how complex the data is; in a recent transition to Stripe, we encountered some challenges with constituents who had multiple payment profiles.  The more clarification you can get from Stripe about what will be required, I think the more smoothly this will go for you.  (Typically the processors would need to transfer the payment details directly.)

Hope this helps,
Lesley


Send an email function not always delivering We're having a curious case where emails from CiviCRM as not always delivering.

CiviMail works fine. No issues there.

When sending a simple email from the actions on a contact record, Hotmail and Gmail accounts aren't receiving the email, despite CiviCRM displaying the message that is was successfully sent.

However, when emails are sent to my work MS Exchange account, where the IP address is whitelisted, they do arrive.

We've reviewed the mail settings, and when we do a spam test, we score 10/10 on mail-tester.com and are also not on any blacklists.

Has anyone else experienced this type of issue?

Where can I check to ensure CiviCRM is sending out the emails?

What is the mail server you are using to push them out?

If it's a local mailserver (eg. postfix) you can check the log and see if it's actually really sent.

If you are using an external provider, they usually have some kind of log as well.

In any case, have you set up SPF and DKIM for your domain? if not, you are increasing the risks of having some providers that will drop your emails without any notice


Use custom field in front end of website We are testing your application CiviCRM and we tried to create a custom field as contact reference for all kind of contacts.

However though in the preview on the back end this field works fine, when you try to use on the front ebd (chrome, IE, Mozilla) the active search does not work (it doesn't allow to search for the contacts in database).

Example:

Front end (Custom Profile Field “Visita à Loja” - It is a Contact Reference Field - It was suppose that when you select the field, active search was functional. But it’s not!)

When you see the back-office profile and you select “Preview all fields” of this profile, everything works properly:

“Data da Prospecção” - It has a Calendar Icon that when you select, a popup calendar appears so you can select date (in front office the icon doesn’t appear)
“Visita à Loja” - Active search is functional, allowing you to search for contacts in database. However in front office this doesn’t work (as you may see above)

Can you help
best regards
JSousa

There are instructions on the screen where you create contact reference custom fields:

Do your front-end users have the required permissions?


Quote for set up and on-going We are a charity interested in CRM and I wondered if you could please provide me with some information:

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

Many thanks,

Alice

CiviCRM is indeed a good CRM for most charities in my experience :-)

There is actually no such thing as your CRM package. CiviCRM is community based and open source, and getting started works in a different way.
There is no sales organization in CiviCRM itself, the software is community developed and based. Most people answering posts here are CiviCRM users and/or experts answering questions as community members in their own time, like me.

As there is no license cost involved, there is also nothing (and everything) on offer.

Your best first step to get your questions answered would be to contact a CiviCRM partner that is close to you. You can find a list here. One of the partners will be able to help you with some of your questions.

A brief outline of what is on offer can be found in the User Guide. That might help you to get an idea. I would strongly recommend you to outline what you would want to achieve though, rather than focus on what is on offer.

As far as the costs go, please check this similar post.

Good luck setting the first steps!


Unable to create membership Our system has 26 different membership type, for 3 different member organization. Since 5.35 Civi upgrade sometimes we are unable to create/update membership from New/Edit backend membership form. We encountered following errors(without priceset)

Please select a membership type (even though membership type is selected).
Unable to add membership for the contact.
Membership field is not updated(like source, join date, custom fields etc) but status message says saved successfully.
Upon submitting new membership says saved successfully but no membership is created.

There are so many scenarios where it fails to create and update membership. However it does work i.e save/update sometimes for some membership types but not for all.
Couldn't replicate the error on dmaster.demo.civicrm.org, may be because we are on older version of Civi? Is this already fixed in latest version of Civi, if so how difficult is it to port the changes to 5.35.2(we don't want to update Civi unless we do thorough testing)?
Any pointers or help really appreciated.
Thanks in advance
Abhi

Did you recently merge Organization contact which was related to membership type? If yes than its a known error in CiviCRM. I always prefer to retain the contact linked to membership type or settings. Or another option to avoid this in future we have installed an extension on most of our client site.
Solution to fix the problem? Run below query to fix the price set data.
SELECT cpf.id, cpf.name, cmt.member_of_contact_id,  cpfv.membership_type_id
FROM civicrm_price_field cpf
  INNER JOIN civicrm_price_field_value cpfv
    ON cpfv.price_field_id = cpf.id
  INNER JOIN civicrm_price_set cps
    ON cps.id = cpf.price_set_id AND cps.name = 'default_membership_type_amount'
  INNER JOIN civicrm_membership_type cmt
    ON cmt.id = cpfv.membership_type_id;

-- Incase above query returned results with cpf.name <> cmt.member_of_contact_id than run below query.
UPDATE civicrm_price_field cpf
  INNER JOIN civicrm_price_field_value cpfv
    ON cpfv.price_field_id = cpf.id
  INNER JOIN civicrm_price_set cps
    ON cps.id = cpf.price_set_id AND cps.name = 'default_membership_type_amount'
  INNER JOIN civicrm_membership_type cmt
    ON cmt.id = cpfv.membership_type_id
SET cpf.name = cmt.member_of_contact_id;

HTH
Pradeep


WP sidebar replicated in dashboard window Any ideas on why one user may be seeing the WP sidebar replicated over the dashboard. This happens on all browsers (IE, Firefox, Chrome) it only happens for the one user. Her WP role is the same as other users.

Functionality of the rest of the application is fine except for this annoying 'extra' sidebar

Found the problem.

Firstly the screen in the image above is not fully loaded.

Once it had loaded the error message "custom field expected (0) found" which pointed to the report it was attempting to load in the dashboard being obsolete.

Deleting the report resolved the problem. :)


Change Recurring Contribution Details from Views/Drupal I am attempting to create a Drupal view/block to embed in a panel, so a user can see their current membership details when they log in (beginning date/end date/type) etc. I have this overriding the default user page. That's working.

What is not working great - is creating an "Actions" field in the view that contains links to cancel, update the card, or change the amount of the recurring series.

I ripped the URL's from the receipt template:

i.e. civicrm/contribute/unsubscribe?reset=1&coid=XXXXX

And then used a view to find the recurring contribution for the membership, and then used a 'views field view' (a child-view) to get the contribution ID, which actually creates these links.

So, I have arrived at a working link such as the above:
civicrm/contribute/unsubscribe?reset=1&coid=XXXXX  when I click it for myself (admin user) it works, but when I log in as a test user it will say "You do not have permission to cancel this recurring contribution".

I've gone through the checklist of permissions - enabled self-service via the iATS admin tool, as well as given the user permission to make online contributions. I've also updated the code suggested here: Only logged in users can change billing and recurring amount

Over on this exchange (Donor access to edit recurring donations) it seems like a contact checksum must also be embedded. Does this mean that my project is out of luck, that we can only generate these links from the context of civi? In views we can generate the contact hash, but that seems dangerous/not the same thing.

I am assuming the civi dashboard for users is kind of ugly and has some permissions limitations, so I was really trying to use views/drupal to generate this functionality.

Please let me know, happy to share my work! The workflow we want is - users log in, see their memberships, can do actions upon those memberships (seems obvious, right?)

I also found this - https://github.com/MegaphoneJon/com.megaphonetech.checksums  but making the link from views is currently beyond my capacity.

update: It seems like the "Edit Contributions" permissions would allow them to do it. Also seems dangerous. I messsed around and put in different contact/contribution ids and tried to load various civi pages, it seemed to throw access denied..so hmm?

Hmm, this sounds similar to the access problems we once had for users not able to change amount or update details of the recur payment.

Not sure if it exactly matches with your use-case, can you try applying https://gist.github.com/jitendrapurohit/8e445fd869595411ee12e0a1345a6d12 on your site and confirm if it works for you?


Case Type Filter bug in Case Summary Report? Multiple case types reported Applying the case type filter in the case summary report CRM_Report_Form_Case_Summary is resulting in two case types being reported where only one is selected in the case type filter.

Looking at the developer tab of the report shows that is is looking for anything that contains a case_type_id of 9 as follows in the where clause:-

WHERE case_civireport.case_type_id  REGEXP '[[:cntrl:]]*9[[:cntrl:]]*'

We have case types in our Civi that have case_type_id's of both 9 and 19, therefore both are being selected when only case type 9 is in the filter.

This doesn't happen with the case detail report CRM_Report_Form_Case_Detail that uses a different select statement as follows:-

WHERE ( case_civireport.case_type_id IN (9) )

I'm not sure if this is just an inconsistency that needs to be fixed, or if it's there for a reason?

Help appreciated.

It looks like the * was added as part of this:
https://github.com/civicrm/civicrm-core/pull/7135

I can't immediately see from that why it was added to the case report, but seems to be related to the "not one of" filter.

I'm thinking all the * should be +, except then it would miss cases that might have somehow been created without the char(1) separators (originally case type was potentially going to be multi-valued, and char(1) is historically how civi separates values in multi-valued fields).

If you change the * to + does it work for you?

You can check your database to see how the case types are actually stored with something like

select case_type_id from civicrm_case where left(case_type_id,1) <> char(1);

If anything is listed then that means the + will miss some cases because you have some case types stored without the cntrl character separators.


Event Report Template - Adding Sorting By/Group How does one add "Organization" as a field to the sort list in the event report template?  I have found how to add custom fields but not system default fields.

Version 4.6.8 Joomla

If you mean 'how do I show the Organisation that is the Employer of the person attending the event' then you need to see if the 'Current Employer' field is available for that event.
"Organisation" is not a field per se. It is a Contact Type.


Tyring to Upgrade to civicrm 4.7.28 on Joomla but wsod error says civicrm.settings.php is missing I', having a hard time upgrading my Joomla! 3.8.3 site on Php 7 to civiCRM 4.7.28. This is the error I'm getting when I install from directory. I looks like it's not creating the civicrm.settings.php file.

Warning: require_once(/home/pastoral99/public_html/administrator/components/com_civicrm/civicrm.settings.php): failed to open stream: No such file or directory in /home/pastoral99/public_html/tmp/com_civicrm/admin/configure.php on line 115

Fatal error: require_once(): Failed opening required '/home/pastoral99/public_html/administrator/components/com_civicrm/civicrm.settings.php' (include_path='.:/opt/alt/php70/usr/share/pear') in /home/pastoral99/public_html/tmp/com_civicrm/admin/configure.php on line 115

I've researched previous topics on this and nothing has been helpful. Can anyone tell me why it's not creating the civicrm.settings.php file?

Thanks!

Since you said you're upgrading, that file should already be there. Which means it isn't creating it, but instead viewing/updating it. The four best reasons for you getting this error that I can think of:

You accidentally deleted your settings file.

You accidentally moved your settings file.

The permissions on the file are incorrect. Looking at my install, it is set to 644.

The user associated with the file is incorrect. This one usually happens if you're like me and log into your server via root so that you can work with multiple accounts on the same login. Then your file uploads as belonging to "root" instead of the actual user.


CiviCRM 5.17.5 and WordPress 5.2.3 just won't work We have been stuck at CiviCRM 5.12.4 for months now. I have had issues with my Contribution page (details not needed here) as I tried to upgrade through Civi 5.14.2. So, I held off until today to try one more time on the latest stable release (also to avoid the critical warning that 5.12.4 is OBE that scares our staff).

We are running WordPress 5.2.3 and use iATS Payments 1.6.2.

This is the behavior. If I am logged into Wordpress, when I click on a contribution page, both the contact info and the billing name and address are correctly filled in. However, hardly any of our visitors create and use a WordPress login. If I am not logged in, the page does NOT have the "My billing address is the same as above" checked by default as it did before. Worse yet, if I check to use the same address for billing as for contact, it does not propagate. Someone would have to fill in every field all over again. I think this "almost" works, but am wondering what could possibly be wrong. It seems like an issue with the handler for contribution pages, as the behavior seems to change every time I try a new version.

I obviously am not going live on our main website with this behavior. If anyone would like to observe for themselves, please visit https://test.sdcbcdream.org/join/ . To see it work correctly (5.12.4), you may visit https://sdbikecoalition.org/join/.

Thanks for any help. This one has me stumped as we have always had no issues moving forward with stable versions.

Just seeing activity here, I realized I moved this query to chat.civicrm.org, Wordpress channel and haystack provided a general fix to civicrm core which has been in place since late fall 2019. I forgot to close things out back here on StackExchange. The ultimate problem was not that one plugin, iframe, but our theme, Benevolent Pro, was evidently calling register_hooks_front_end() before it actually should be. It was decided that could happen with other themes as well, so haystack suggested a fix to handle that case. I haven't had any problems since then. We are running Civi 5.21.3 (ESR) and Wordpress 5.4.2 currently. You can see the whole thread at:
https://chat.civicrm.org/civicrm/pl/9we4awu1c38b98eihypwdrbumh


Widget broken after site switched to https I changed my wordpress site to use https
Now the widgets for donations do not load anymore. they only display the placeholder text

any ideas?

thanks
Conte

Two separate problems with the same source, which is that your widget is static HTML and Javascript that you copied and pasted in place.  It does not update by itself when you make changes.

If you just see the placeholder text, it means that the Javascript is failing to get the current totals.

Your widget may be trying to connect to your site, failing because it's not connecting through HTTPS.  Depending upon how you implemented HTTPS, these sorts of connections may fail unless you specify the https://... URL.
Your browser may be refusing to connect via an insecure protocol.  Recent versions of browsers will simply exclude Javascript and CSS that comes through HTTP when you're on an HTTPS page.

The solution to either problem is the same: fix the widget.  You can read through the widget's code and replace each instance of "http://" with "https://".  Alternatively, you can simply go manage your contribution page, go to the widget tab, copy the code, and paste it in place of the old code.


Smarty and Mosaico - compatibility? Seeing a lot of smarty errors in Drupal log file for mailings using Mosaico template - looks like an error for every message sent so thousands filling log files.

Nothing obvious in Mosaico template but thinking it must be a conflict with use of { } in each case.  Smarty logic in the template that I can see.

should smarty be turned off in civicrm.settings.php if using Mosaico?

You can't use Smarty and Mosaico together.  Tim Otten presents a long answer why if you want details!


can't access "Joomla Access Controls" after upgrade from 4.2.19 to 4.7.25 I've just gone through a long incremental upgrade process from CiviCRM 4.2.19 to 4.7.25. Thought everything was working well until I discovered non-admin users were getting permission denied errors, so I tried to check the ACL settings -- and I can't access the Joomla Access Control settings.

When I go to "Administer->Users and Permissions->Permissions (Access Control)" and click "Joomla Access Control", the popup window shows

"500 - An error has occurred. JHtml: :bootstrap not supported. File not found."

Error logs aren't helpful -- nothing in PHP or CiviCRM logs, and Apache error just reports that the request for "/administrator/index.php?option=com_config&view=component&component=com_civicrm&tmpl=component" has returned a 500.

Help appreciated!

System details:

Joomla 2.5.28 (yes I know it needs upgrading, that's happening as
part of this whole site upgrade!)
CiviCRM 4.7.25
PHP 5.6

OK so in reviewing the requirements in the documentation, it seems that version 4.6.x was the last version that states explicitly it is compatible with Joomla 2.5 AND 3. The latest documentation (which I'm assuming is for 4.7?) says Joomla 3 is required.

But the download site clearly says "Download 4.7.27 for Joomla 2.5x/3x".

I'll try a rollback to 4.6.32 and see if the problem persists.

UPDATE: 4.6.32 solves this issue.  So I guess 4.6.32 is the last version of CiviCRM that works with Joomla 2.5, so I have to stay with it until the Joomla site can be upgraded to 3x.

Would be very helpful if the download page were updated to reflect this.


New > Individual Mandatory Phone When creating an individual record, how do I make the phone number field a mandatory field. I mean, I don't want a record before the phone number is written.

administrator/?option=com_civicrm&task=civicrm/contact/add&ct=Individual&reset=1

I assume you are wanting to require a phone number when some contributes, becomes a member, or registers for an event.

Go to Admin > Custom Data > Profiles

Look for the Profile that you will be using in your Event/Contribution pages and to the right click Fields

You can edit the Phone field and make it Required


How do I debug "Could not find valid value for ct" error message Performed upgrade of Civi 4.4 to 4.6 alongside upgrade of Drupal from version 6 to version 7. The Drupal upgrade went fine, as did the CiviCRM upgrades (i.e. no errors were reported).

All dashboards and search functions in CiviCRM work fine, but as soon as I try and create anything (e.g. registering for an event, creating a new Individual, etc...) we get the error: "Could not find valid value for ct".

Searching forums showed this is an old error related to sessions, so checked over all the PHP.ini and Nginx settings to ensure cookies and other domain related settings were correct.

Can anyone point me in the right direction of where else to look?

** EDIT *** Additional error messages being shown after enabling debug:-

  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.

OK, turns out this was due to erroneous entries in the Drupal settings.php file. The following entries were causing cookies to be missed by Civi:-

 ini_set('session.cookie_lifetime',  2000000);
 ini_set('session.gc_maxlifetime',   200000);

Others may also cause inconsistencies, such as:-

 ini_set('session.cache_expire',     200000);
 ini_set('session.cache_limiter',    'none');
 ini_set('session.cookie_lifetime',  2000000);
 ini_set('session.gc_maxlifetime',   200000);
 ini_set('session.save_handler',     'user');
 ini_set('session.use_cookies',      1);
 ini_set('session.use_only_cookies', 1);
 ini_set('session.use_trans_sid',    0);

Removing the entries from the drupal settings.php file, then closing the browser and re-establishing a new session has resolved the issue.

Essentially these settings within Drupal are conflicting with the PHP.ini settings that CiviCRM is seeing, which can lead to these erroneous types of session errors.


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

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

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

UPDATE:

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

I'd say best to stick with where Civix (aka Tim) says it should go! (i.e. no subdirs) - and note that Civix can help you create the page:

https://wiki.civicrm.org/confluence/display/CRMDOC/Create+a+Module+Extension#CreateaModuleExtension-Addabasicwebpage

To generate a Page:

me@civisys:/home/me$ cd /var/www/extensions/com.example.myextension
me@civisys:/var/www/extensions/com.example.myextension$ civix generate:page --help
Usage:
 generate:page className webPath

Arguments:
 className  Page class name (eg "MyPage")
 webPath    The path which maps to this page (eg "civicrm/my-page")

me@civisys:/var/www/extensions/com.example.myextension$ civix generate:page Greeter civicrm/greeter
Write /var/www/extensions/com.example.myextension/xml/Menu/myextension.xml
Write /var/www/extensions/com.example.myextension/CRM/Myextension/Page/Greeter.php
Write /var/www/extensions/com.example.myextension/templates/CRM/Myextension/Page/Greeter.tpl


"Could not find a valid session key." Unable to save any admin forms 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.

As Coleman's answer suggests, the most common cause for this I've seen is a mismatch between the URLs CiviCRM is configured to use and the ones it actually uses.

Other places to check are -

your webserver configuration (eg a canonical URL redirect)
the CIVICRM_UF_BASEURL constant in civicrm.settings.php
Administer > System Settings > Resource urls as Coleman mentions

If your site DB has been migrated to your VM, you may also need to follow the steps in Moving an existing CiviCRM installation.

If these various settings don't match, CiviCRM doesn't recognise / receive its session identifiers, and the result is this confusing (and often reported) error message.


CiviMail pull-downs not displaying correctly After upgrading to 4.6.2, the pull-down menus are not displaying correctly in the Define Mailing window. Each pull-down is displaying as two separate elements.

I have attached a screen shot and the section of HTML which corresponds to the template selection window.

By the way, I implemented the PRs relating to issue CRM-16277.

Any ideas? Thanks.

Screenshot:

HTML:

         Message Template   {{crmUiField.title}}*<input class="select2-focusser select2-offscreen" type="text" aria-haspopup="true" role="button" aria-labelledby="select2-chosen-6" id="s2id_autogen6">

       {{crmUiField.title}}*       <input type="text" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false" class="select2-input" role="combobox" aria-expanded="true" aria-autocomplete="list" aria-owns="select2-results-6" id="s2id_autogen6_search">

   <select crm-ui-id="subform.msg_template_id" name="msg_template_id" crm-ui-select="{dropdownAutoWidth : true, allowClear: true, placeholder: ts('Message Template')}" ng-model="mailing.msg_template_id" ng-change="loadTemplate(mailing, mailing.msg_template_id)" class="ng-pristine ng-untouched ng-valid ng-isolate-scope" id="crmUiId_5" tabindex="-1" title="{{crmUiField.title}}*">
      <option value=""></option>

      <option ng-repeat="frm in crmMsgTemplates.getAll() | orderBy:'msg_title'" ng-value="frm.id" class="ng-binding ng-scope" value="133">

[removed list of options]

   </select>

I suggest you start by going through the steps for troubleshooting javascript in CiviCRM.


How can do a bulk delete of users in Civi? How can do a bulk delete of users in Civi?
We have too many user accounts in civi and would like to delete may of them and only keep the ones that we need.
Instead of looking up the accounts one at a time. I would like to select a group of records and delete them.

Thanks in advance
Edward

This is actually a Drupal and not a CiviCRM question.  A good answer is posted here; an alternate approach is the Bulk User Delete module, but for your use case I think that might not be as easy as some of the answers under the first link.


Display cases in contact summary tab in reverse order (ORDER BY id DESC) I'm trying to display cases in reverse order in contact summary Cases Tab. I tried using hook called civicrm_searchColumns( $objectName, &$headers,  &$values, &$selector )

and changed the values using $values = array_reverse($values);. but some contacts got more than 100 cases split into different pages. using this hook I cant get cases in ORDER BY id DESC order.

I checked relevant php file CRM_Case_Page_Tab. Its using controller in browse function like below

  public function browse() {

    $controller = new CRM_Core_Controller_Simple('CRM_Case_Form_Search', ts('Case'), CRM_Core_Action::BROWSE);
    $controller->setEmbedded(TRUE);
    $controller->reset();
    $controller->set('limit', 20);
    $controller->set('force', 1);
    $controller->set('context', 'case');
    $controller->process();
    $controller->run();

Can anyone suggest me is there any option to add sort by to this controller object for case id in descending order?

or where to add this order by case id to the actual query?

TIA

I found quick hack to add sort in CRM_Case_Selector_Search class file. Though its not good practice to touch core, I could not find better option to get around this problem

  public function &getRows($action, $offset, $rowCount, $sort, $output = NULL) {
       //adding sort here for descending
        $sort->_vars[1] = array('name'=>'case_id',
                                'direction'=>CRM_Utils_Sort::DESCENDING,
                                'title'=>ts('Case ID')
                               );


Drupal views: How to aggregate CivCRM Relationships? I was able to create Drupal Views that nicely lists Organization with their related individuals. It worked with both approaches with CiviCRM Relationships as well as CiviCRM Contacts as base view. Once you have this, it would seem simple then to switch on Aggregation and then count the contacts, but no. I tried what I could but with both approaches it returned illogically unexpected results.

Anyone successfully made a view to that can list Organizations with the number of their related Individuals? I would appreciate if you could share your experience.

In the past when I have tried doing this sort of thing I have had to use a Drupal module.

Maybe try this module:
https://www.drupal.org/project/views_aggregator


What is the membership data? I have logged in to CIvCRM for the first time to interrogate the membership data of my local Green party but I don't know how to find that data.
Can you advise me?
Jim

Jim, Welcome CiviCRM SE. You can use membership search to find membership data or reports.

Search:
CiviCRM >> Membership >> Find Memberships.

Reports:
CiviCRM >> Reports >> Membership Reports.

Doc:
https://docs.civicrm.org/user/en/latest/membership/what-is-civimember/

Cheers

Pradeep


How can I change the order of address field columns on screens and reports? In Europe, the postcode mostly precedes the town name. I could not find any options for changing the order of the columns for these fields, particularly on the constituent report.

Have you tried making adjustments under Administer > Localisation > Address Settings?


Clearing/disabling out-of-date event locations Is it possible to hide/disable event location addresses? Or manage them at all without digging around in the database?

I'm using Drupal Views to search by event location, but that doesn't help when adding locations - we have a long list of event locations, and because they're not sorted, and can't be searched, people keep adding superfluous duplicate locations, which makes the situation worse...

Unfortunately, no, there is no UI for managing event location addresses and it's not possible to disable them even in the database without dropping the link between an event and the address (table civicrm_loc_block).

It could be a good feature to add to CiviCRM though.


How do I display a custom field in an invoice? I'd like to be able to display a custom field in the generated PDF invoice for a contribution. I've added the custom field to contributions, but it will not show up in the invoice.

Is it possible to display this custom field on the invoice? If so, how?

So, I remembered that there is such a thing as Smarty calls to the CiviCRM API.

Stuck the following code into the template and bam! Got my custom field to show up in my generated invoice.

{crmAPI var='result' entity='Contribution' action='get' invoice_id="$invoice_id"}
{foreach from=$result.values item=poid}
    {$poid.custom_40}
{/foreach}


Is there a limit to the number of soft credits you can add to a contribution? Is there a limit to the number of soft credits you can add to a contribution? If so, is there a way to change the limit?

Yes, I see that we have a limit for generating soft credit blocks on the New Contribution Page to 10.

I don't think we can modify this limit from the UI level as it is hardcoded to a value of 10 here. Changing this value to 16 can generate 15 softcredit values and so on:)

Modifying here can result in loosing this feature after upgradation to the latest version.


Couldnot create an event in civicrm 4.7.20 Whenever I try creating a new event, I am facing " The page not working" error with wordpress and "The site can't be reached" error in Drupal. Not sure what is the issue.  Running CiviCRM 4.7.20
my problem seems the server is not sending any response for this request to create event

As Jitendra says, this could be a bug that has already been resolved. If not, you may need to dig in to your ConfigAndLog to see more errors.


no menu error 500 after upgrade to 5.8.x On Ubuntu 18.04, apache 2.4.29 all patches for both applied.
Did an upgrade today to 5.8.0. The header civi nav menu isn't displaying.
Installed 5.8.1 to make sure it wasn't something cooky, still no menu.

I've checked permissions for WP. I've checked that the path to the file is kosher, and it exists just fine. I've done the cache and path reset inside civi.

Error log in apache shows:

PHP Fatal error:  Uncaught Error: Call to undefined method CRM_Core_SelectValues::quicksearchOptions() in /home/folder/domains/secure.folder.org/public_html/wp-content/plugins/civicrm/civicrm/CRM/Admin/Page/AJAX.php:60
Stack trace:
#0 /home/folder/domains/secure.folder.org/public_html/wp-content/plugins/civicrm/civicrm/CRM/Admin/Page/AJAX.php(49): CRM_Admin_Page_AJAX::getSearchOptions()
#1 /home/folder/domains/secure.folder.org/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(275): CRM_Admin_Page_AJAX::getNavigationMenu()
#2 /home/folder/domains/secure.folder.org/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem(Array)
#3 /home/folder/domains/secure.folder.org/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke(Array)
#4 /home/folder/domains/secure.folder.org/public_html/wp-content/plugins/civicrm/civicrm.php(1240): CRM_Core_Invoke::invoke(Array)
#5 /home/folder/domains/secure.folder.org/public_html/wp-includes/class-w in /home/folder/domains/secure.folder.org/public_html/wp-content/plugins/civicrm/civicrm/CRM/Admin/Page/AJAX.php on line 60,
referer: https://secure.narsol.org/wp-admin/admin.php?page=CiviCRM

Andy, Welcome to CiviCRM stack exchange.

This is a weird error, since this function is already present in CiviCRM 5.8.1. But to trace the problem I would

Check if the function quicksearchOptions() exists in civicrm/CRM/Core/SelectValues.php.
Check if this file is being over-ridden by any of the extension or custom php
Check if civicrm/CRM/Core/SelectValues.php file is being invoked.

HTH

Pradeep


Preventing Concurrent Activity Creation I want to use CiviCRM in a new project right now. In this project, it is necessary to assume an activity. So before creating an event for xxx individual registration, this xxx individual transaction must undertake. No one else who has taken over the registration and who has the authority to open a record in Joomla / CiviCRM on this individual until the transaction (new activity) completes.

Here's the story. Only joomla users can access CRM. When a person is interviewed, a Phone Call activity is created for this. If there is a need for additional support, the shared e-mail address of the related team is added to the Assigned section. Since there is more than one person from the common e-mail address, more than one person can make transactions at the same time. I want to prevent anyone else from taking action on this record by doing something like (assume) after viewing the CiviCRM Record in this mail.

If this is possible, I would like to know how to do this, or if there is an add-on created before.

By "complete", I'm assuming you are talking about the status of the activity?

You will need to develop an extension to implement your specific workflow, as there isn't anything in civi preventing having multiple activities with various status and your workflow seems to be specific enough that it's unlikely someone else has done and shared something similar.

The safest point is probably as a pre hook, ie before saving an activity, check that the required other activities with the expected status are there.

However, it this would be a sub-optimal user experience, as a user might start creating the activity without realising it will not be possible to save (because of the pre-hook).

So you should probably alter the display of the contact (as it seems to be the main path to create a new activity) and add a message/change color/add a warning message "this contact is reserved because activity bla has the status..."

Please do share if you implement it, it might help others, at least as inspiration and starting point.


What low-cost third-party mailing platforms work well with CiviMail? Mandrill users are being notified that the service is being integrated into Mailchimp, and you must have a paid account by the end of April.

What alternatives are out there that work well with CiviCRM?  Some that look interesting might be Sendgrid, Mailjet or Mailgun.

Any experiences with these?

SparkPost is great, but the UI is a little lacking, but as far as sending is concerned, it works great. My company also just developed and extension for processing bounces from SparkPosts in Civi.

https://github.com/proexchange/com.pesc.sparkpost


Drupal single user, multiple civicrm memberships, editable details: What's a good logical approach to integrating them? Drupal 7 site, and each Drupal user could have more than one civicrm 'membership'. Each membership is for a business and each business with a 'type1' membership is entitled to a listing on a directory node (public) in drupal with filters.

What would be a good approach, as ideally it would be good if users (contacts) can log into Drupal and edit each membership's details (for the listing) from their one Drupal contact account?

OK, so I can create a profile to be pulled into each Drupal user. But I can't display different 'profile' types on the same user?? So how do I pull profiles for each business, of that contact, back to their Drupal account for them to edit/maintain?

I understand it involves various components re edit forms and membership forms etc. but I want to get the wireframe layout right before building a range of webforms etc.

If you set up your membership type so that it provides an 'inherited membership' via the 'employee for' relationship, then the Employee will have a permissioned relationship over the Business, and can therefore access the address details etc for the Organisation via their Contact Dashboard.
Secondly if they are logged in then the employee (or primary contact or whatever you need it to be) can have 'permission' on a webform to update more details about the Organisation if you can't give them enough access to fields via Contact Dashboard.
Does that move you towards your goal?


Email weekly reminder to group Is there a way to schedule the same email to a group each week?  It's a reminder for a meeting we run.

Steve

Could be done with scheduled reminders
Adminster -> Communications -> Scheduled Reminders

Entity -> Event Name, choose first meeting name.

Enable repetition
Repeat every 7 days until 10 years after event start date

(or something like that).


Bug in settings for CiviContribute Component? I have been wondering for a while, why two settings for CiviContribute did never have any effect on the created financial transactions:

Always post to Accounts Receivable?
Enable Deferred Revenue?

Since I am beginning to become more familiar with Civi, I tried to dig a bit deeper into the internals of the system, and I might have found the cause.

In general, all settings for all components are stored in the table civicrm_setting, one row per setting.

BUT: There is one exception. All settings for CiviContribute get stored combined within one single row. Looking into the source code, all relevant settings are then pulled out of this single row. And this is also true for the read access to the two settings I mentioned above.

HOWEVER: It seems that when the settings of these two entries get stored, they are indeed written in distinct rows within the settings table. This would be ok for all other settings, except those for CiviContribute. While the system tries to  read the (non existing) values out of the combined row, it always assumes, those values have never been set.

I manually fiddled with this ominous CiviContribute data row and placed a value for deferred_revenue_enabled==true:

  a:10:{s:24:"deferred_revenue_enabled";s:1:"1";...

and voila, now the expected financial transactions all get generated.

I would like to ask some of the more experienced CiviCRM guys to have a look at this phenomenon, since I am not quite sure yet about the correct way for a bug report.

(My current version of Civi is 5.13.2 in combination with Wordpress 5.2, but this bug exists already for some time, at least since 5.11.)

The issue got fixed in release 5.15.0 (see here). Thanks a lot to everyone who contributed!


Forward/Copy SMS to CiviCRM I have a question about SMS, which a client has asked me about.

The problem

The staff member sends an SMS to a client via mobile
The client responds by SMS (their mobile) to the staff member.
Currently, the staff member then keys this into their database.

The challenge

Can we find a way for CiviCRM to file the SMS against the client’s record ?

I have thought about forwarding messages to an inbound processor, but the message would get filed against the staff member, not the client who sent it.

Anyone had this kind of problem before?

I don't think that your standard SMS gateways are going to be able to cater to this. You could certainly set something up where CiviCRM forward SMS it receives from a gateway to specific people with contact details attached, i.e. someone texts central number. CiviCRM forwards that text to a specified mobile with the originating number prepended but that doesn't help for inbound SMS.

You might be able to acheive this with Telerivet, which allows you to 'turn any phone into an SMS provider'.

If the user was OK with downloading the telerivet app to their phone, it would allow them to forward any SMS sent and received to CiviCRM. I suspect that you can limit the numbers that have SMS forwarded to certain groups / contacts within the phone but you would want to do a bit of research on that.

Not 100% that this would work but might be worth exploring. It would certainly involve a bit of playing around and experimentation, but might deliver what they need.


How can I resolve Civi Dashboard Javascript error: widget.name is null? I've just upgraded a Civi 4.6.18 install to 4.7.15. All has gone fairly smoothly, apart from the fact that the CiviCRM front page/dashboard is broken.

My Firebug console reports: "TypeError: widget.name is null" and refers to http://siteroot.com/sites/all/modules/civicrm/js/jquery/jquery.dashboard.js line 467 col 13

I know that some of the dashlets that display in my dashboard have been created by setting up some reports to suit, and simply making those available as dashlets.

Looking in the database, I checked the civicrm_dashboard table, and noticed that three of these 'custom' dashlets had NULL in the name column. Interestingly, other similarly created dashlets had an entry in the name column of the form 'report/xx'.

I'm glad you found the cause of your problem. It does sound like something went wrong back when you originally created those dashlets, and it's not clear what that was. But it would be good to proactively repair this during the upgrade.

I've created a PR to do so: https://github.com/civicrm/civicrm-core/pull/9672


Error importing contacts Wordpress Multisite I tried to import contacts on a new WordPress Multisite installation, and received the following error:

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

In the error log, it has the following errors:

    [info] $backTrace = #0 .../public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(363): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 .../public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(859): CRM_Core_Error::fatal("We can't load the requested web page. This page requires cookies to be enable...")
#2 .../public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(854): CRM_Core_Controller->invalidKeyCommon()
#3 .../public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(314): CRM_Core_Controller->invalidKey()
#4 .../public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(206): CRM_Core_Controller->key("CRM_Contact_Import_Controller", TRUE, FALSE)
#5 .../public_html/wp-content/plugins/civicrm/civicrm/CRM/Contact/Import/Controller.php(45): CRM_Core_Controller->__construct("Import Contacts", "null")
#6 .../public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(307): CRM_Contact_Import_Controller->__construct("Import Contacts", TRUE, "null", NULL, "false")
#7 .../public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:13))
#8 .../public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))
#9 .../public_html/wp-content/plugins/civicrm/civicrm.php(1133): CRM_Core_Invoke::invoke((Array:3))
#10 [internal function](): CiviCRM_For_WordPress->invoke("")
#11 .../public_html/wp-includes/plugin.php(496): call_user_func_array((Array:2), (Array:1))
#12 .../public_html/wp-admin/admin.php(226): do_action("toplevel_page_CiviCRM")
#13 {main}

(I've removed part of the directory url for security/privacy)

Does anyone have an idea of what I can try to fix this?

WordPress version: 4.2.2

CiviCRM version: 4.6

Other activated plugins:

BackWPup
Black Studio TinyMCE Widget
Brute Protect
Coming Soon Page & Maintenance Mode by SeedProd
Disable Comments
Redirection
Seamless Sticky Custom Post Types
Simple Lightbox
Types - Complete Solution for Custom Fields and Types
User Admin Simplifier
WordFence Security
WordPress MU Domain Mapping

Import file type: CSV (it's just a list of contact information.  We went through the data to remove inconsistencies)

Thanks

It turns out it was errors in the data.  I picked apart the spreadsheet and went from the ground up and it finally gave me a report of what the errors were instead of this vague error message.

The errors were:

Country name USA instead of US
Some of the date formats were wrong

I believe there might have also been some strange formatting in the original spreadsheet that affected the upload.


Changing hosts for CiviCRM -without current host cooperation We need to change our civi hosting to another company. We have already moved our website, but the civi hosting still seems to be with the original company. The tricky part is that our current hosts aren't cooperating with us because of legal issues around termination. How should we go about taking this account to another site without any aid from our hosting company?

How can we extract the data of our CiviCRM install without support from the hosting provider?

MySQL via network / phpMyAdmin / DB backups

If your hosting company provides CPanel, remote MySQL, or a web interface like phpMyAdmin, then you may be able to take a snapshot of your database. This is the core of your CiviCRM data.

You'll need your hosting provider login credentials to access this. You may have multiple login/password combos to access various services.

This would not include customisations stored in code, nor media (eg uploaded PDFs relating to contact activities), but it would give you the core CRM dataset.

FTP / SFTP / web upload

If you can edit the codebase on your server, you can upload tools which would let you make a backup of your DB. You can also copy down a copy of your site codebase. You could upload a copy of phpMyAdmin or a CMS plugin like Drupal's Backup & Migrate. Some CMS will let you upload backup plugins within the CMS admin section.

Again, you'll need your login details (to work).

Exports

If you don't have access methods like the above, but you can still log into CiviCRM, you can search for contact data and then select the Export option. This method of export will probably not retain the full dataset, and you'll need to aspect each core type (Contacts, Memberships, Contributions, ...) separately. I'd only look this way if a full DB export isn't an option.

API

CiviCRM has an API. Building an exporter wouldn't be trivial, but it's another possible route so worth mentioning.

"Other technical approaches"

Ever locked yourself out of your car? It happens to site owners too ... There may be means to obtain access even when you're "locked out"; this requires technical chops. (Remember, to get into your locked car you call a car technician, not a car thief!)


membershipTypeValues hook not updating membership price On my civicrm contribution page I have a field that I want to use to calculate the membership price.
Currently Im trying to use the membershipTypeValues hook to edit the price after the contribution page has been submitted
Heres the code
add_filter('civicrm_membershipTypeValues', "updatePrice", 10, 2);

function updatePrice(&$form, &$membershipTypeValues) {
    $membershipTypeValues[14]['minimum_fee'] = "40.00";
}

Theoretically this should change the membership price to $40 but the price doesn't change on the conformation screen.
The code runs and if I print out the $membershipTypeValues array I can see the minimum fee has changed to $40
Any ideas on how to fix this would be great
Thank you

I think you need to use hook_civicrm_buildAmount  or hook_civicrm_buildForm hook to change the amount on front end contribution/event pages for priceset or line items.


Items not showing up on activity log It appears that, following the last upgrade, items which previously showed on an individuals activity log now don't show up.  A colleague sent out an email which was assigned to a case.  The email shows on the case but not in the colleagues activity list.  This list is used as a record that we can refer to as a quick check if something has been misassigned or that we did remember to do something.  What was the reason for this being changed and is it something we can choose to bring back?

Yes this was changed recently. I preferred it the old way too, but there was a feeling that it was duplication.
See https://github.com/civicrm/civicrm-core/pull/12620


Getting recurring contributions with Authorize.net that predate CiviCRM instance to register in CiviCRM I have a client who used authorize.net for contributions before switching to using civicrm several years ago. They have continued to use authorize.net as their payment processor with CiviCRM, however contributions made before CiviCRM was being used have needed to be manually imported. Is there a method in existence to get recurring contributions that are processing through authorize.net to register with CiviCRM? Thanks in advance!

This would be incredibly difficult to do, because you would need to create recurring contribution records with the correct IDs matching those that Authorize.net is sending.

In this situation, I usually use the Offline Recurring extension.  Please download from the link above; the original authors no longer maintain the extension, and this branch on my copy is the only version with no known bugs.

Create offline recurring contribution subscriptions to match those that exist outside of Civi.  The missing contributions will be added to CiviCRM, but it's up to an end user to manually mark failed payments.


Possible cause? CiviMail sent "400%" of queued messages, hit each recipient 4 time On a well established site that uses CiviMail and Groups for a range of mailing lists, a message was sent out this morning as usual to a list of over 1400 people.

Inexplicably, each recipient received the mail 4 times. I have checked and the message was definitely only queued once, and was sent out by a single cron job. The report for the message makes clear that something very odd happened:

Intended Recipients 1411
Successful Deliveries   5644 (400.00%)
Tracked Opens   268
Click-throughs  50
[...]
Scheduled Date  May 20th, 2015 9:48 AM
Status  Complete
Start Date  May 20th, 2015 10:00 AM
End Date    May 20th, 2015 10:11 AM

Normally a cron such as this takes about 2 minutes to run. This one took substantially longer.

The CiviCRM installation was upgraded to the latest version on May 4th, however multiple messages have been sent successfully in the interim.

I cannot see any evidence of user error which would have caused this to occur.

Greatly appreciate any thoughts on how this came about, as the site owners are naturally reluctant to use the system again until the cause has been established.

It was highly likely due to this issue which has now been fixed in 4.6.3:

https://issues.civicrm.org/jira/browse/CRM-16251


Missing Contacts from Mailing Labels in Civi 4.4 We have a Civi 4.4.14 installation. When choosing the Make mailing label action from search results 5 contacts are missing from the finished labels.

I've recreated the error on the 4.4 demo site but see that it is fixed in the 4.5 and 4.6 sites.

The site currently uses the civibooking extension which doesn't  work with 4.5 or 4.6, so an upgrade isn't (currently) an option.

Does anyone have a patch/ fix for this?

Cheers

Craig

How are you trying to reproduce the problem? Are you just running a search and comparing the number of labels to the number of results?  If so, you should expect to have fewer labels because CiviCRM will automatically exclude contacts with "do not mail".

If that's not the issue, try looking at what shared attributes the excluded contacts have. If it is a bug, an important step to replicate and fix the issue is to know what kinds of contacts go missing (or alternatively if it's a new random group dropped on each search run).


Create a Personal Campaign Page links to a page that does not exist When I enable the "Create a Personal Campaign" within the contribution page manager, the link to share to create a personal campaign page is provided at the bottom of the contribution page manager as shown here:

The link provided leads to a Page Not Found error:

This is the link https://lofcenter.org/civicrm?page=CiviCRM&q=civicrm/contribute/campaign&action=add&reset=1&pageId=1&component=contribute

This is the resulting error:

Any suggestions on how to proceed trouble shooting this error?

Please try to create a new page in wordpress and then include CiviCRM component in the wordpress page and then please try the same