yurg
  • Member for 6 years, 7 months
  • Last seen this week
Find Contacts with no Relationships
Accepted answer
4 votes

Thing which works is "include/exclude custom search" : "Search -> Custom searches -> Include / Exclude Search" or /civicrm/contact/search/custom?csid=4&reset=1 Thanks @Coleman!

View answer
Custom Mailing Labels and "Merge labels for contacts with the same address"
Accepted answer
3 votes

The answer is already here. According to a tiny mention at the bottom of http://wiki.civicrm.org/confluence/display/CRMDOC/Directories page, it is possible (and, more important, it works!) to copy ...

View answer
CiviCRM 5.37 > CiviCRM 5.43 upgrade, drush cvupdb, ALTER TABLE civicrm_note CHANGE COLUMN note_date Invalid use of NULL value
2 votes

Issue caused by empty timestamps in 'civicrm_note' according to this The fix: run MySQL query before upgrade or if/when upgrade stuck. In my case, this page http://example.org/civicrm/upgrade?reset=1 ...

View answer
Mass SMS recipients count
2 votes

Kudos to Demerit and petednz-fuzion for helpful pointers, see below: Demerit: Dummy SMS extension petednz-fuzion: check your log_civicrm_option_value table for option_group_id = 35 to see who changed ...

View answer
Drupal Views Exposed Filter (operators) and CiviCRM Multiple Tags
Accepted answer
2 votes

Indeed, civicrm_handler_filter_pseudo_constant.inc should be altered and class civicrm_handler_filter_pseudo_constant extends views_handler_filter_in_operator should be replaced by class ...

View answer
How to retrieve all contacts belonging to a smart group
2 votes

There is also a "less-code" variation of this: $result = civicrm_api3('Contact', 'get', array( 'group' => array('IN' => array(1,2,3)), // <-- Group IDs array ));

View answer
Any happy IE8 users with civicrm image display issues?
Accepted answer
2 votes

Not exactly a fix, but rather a workaround: https://www.drupal.org/project/imagecache_external module has been used for an additional image pre-processing. Images processed by drupal imagecache module ...

View answer
How to migrate database without logs
2 votes

You may want to move log tables from main database to specially created database via settings in civicrm.settings.php. Of course, new empty database has to be created first. After that please find ...

View answer
$cancelSubscriptionUrl in a Contribution Receipt email links to http://%22%22/
Accepted answer
1 votes

In this case it was "Enable self-service cancellation of a recurring contribution" checkbox on iATS payment settings page.

View answer
Pre-header text for mosaico mailings shows twice
1 votes

Basically,  from what I can see in the code ( see Mosaico github issue for details here  https://github.com/voidlabs/mosaico/issues/582 )  preheader is being conditionally shown depending on "...

View answer
How can I add Recaptcha Version 2 for civicrm 4.3
1 votes

Unfortunately /civicrm/packages/recaptcha/recaptchalib.php is quite dated and does not work with reCaptcha v2 for old CiviCRM setups ( have not tested with the most recent 5xx CiviCRM). I have not ...

View answer
Drupal Rules: Send email then Contact Custom Field Value was updated
Accepted answer
1 votes

It turned out Jaap Jansma - CiviCooP was right, CiviRules ( and Email Api for sending emails - a missing piece from my previous attempts ) can do the job nicely. CiviRules can handle any Contact ...

View answer
Can we add Register buttons to the public-facing Events Listing page?
1 votes

Perhaps this file is worth checking: civicrm/templates/CRM/Event/Page/DashBoard.tpl; you may want to have a customized version of the template and put something like a piece of code below into an ...

View answer
Error on Member Dashboard after upgrading to PHP 7.0
Accepted answer
1 votes

Perhaps allow_url_fopen=1 should be set in PHP.ini file on your web host.

View answer
How to remove 'Volunteers' menu option where it's not appropriate?
1 votes

Not entirely sure, yet if menu comes from CiviVolunteer 2.2.2 extension, perhaps an extra permission check should be added here: https://github.com/civicrm/org.civicrm.volunteer/blob/...

View answer
Not sure what to do with these errors on User Dashboard
Accepted answer
1 votes

This line: https:// wrapper is disabled in the server configuration by allow_url_fopen=0 suggests to change allow_url_fopen = 1 in php.ini file on your hosting server.

View answer
Modify the Tags (Categories) Administration page
Accepted answer
1 votes

When we have come to a necessity of Tags Administration page changes, only way we've been able to find, was custom CRM/Admin/Page/Tag.tpl template creation. With more than 2000 tags, it was almost ...

View answer
Refresh page after closing modal opened by .crm-popup outside of CiviCRM
1 votes

Here is a code for copy&paste, in case anyone wants it: $('#main-content') .on('click', 'a.LINK_CLASS_or_ID', CRM.popup) .on('crmPopupFormSuccess', 'a.LINK_CLASS_or_ID', function() { ...

View answer
CiviCRM CSS outside of CiviCRM
Accepted answer
1 votes

Wrong question was asked; fancy CiviCRM stuff works almost, if properly called via CiviCRM own jQuery methods; pretty strange CRM.alert in Chrome pops up a default JS alert() message though, so it ...

View answer
Add/Update form actions(context?) detection from hook_buildForm
Accepted answer
1 votes

This should be it: $mode = $form->getVar('_mode'); // civicrm mumbo jumbo below targets EDIT form mode if (in_array($mode, array(CRM_Profile_Form::MODE_EDIT))) {} But it doesn't ...

View answer
All dashlets display "Object Moved" after host name change
Accepted answer
1 votes

In "own question - own answer" mode .. again. Well, it turned that server name resolves as www.hostname.tld while all paths we used were in just hostname.tld format.

View answer
How do I modify a core CiviCRM file (to change a search order)?
Accepted answer
1 votes

The answer is already here. According to tiny mention at the bottom of http://wiki.civicrm.org/confluence/display/CRMDOC/Directories page, it is possible (and, more important, it works!) to copy ...

View answer
How do I set up custom permissive relationships?
1 votes

Relationship Permissions as ACLs doesn't fully work in CiviCRM 4.6.x (please refer to issue here https://issues.civicrm.org/jira/browse/CRM-17349) There is a good news for "permissioned ...

View answer
Relationship created by API does not add Membership until edited/updated
1 votes

We've been in a same situation after mass users import and ended up re-saving all Contacts via API call, using "Create" Contact and passing an existing IDs, as it has been recently introduced as "...

View answer
LIKE search in API for membership_type_id
0 votes

It seems it is working now in 2018 (have tried to find Relationships Type). Just put a search term (a word or part of something) in"LIKE" text area as %YourSearchTerm%

View answer
Relationship Type "name" as Drupal [Rules] Token in Civicrm Entity module
Accepted answer
0 votes

It seems that Fetch CiviCRM entity by property action loads anything else but ID, so, in order to get a full Relationship Type, one may want to use another action with almost the same name has been ...

View answer
Blank page in mailings with notice
Accepted answer
0 votes

While I'm not sure what exactly cause an "Undefined offset" PHP notice (need to go deeper), yet temporary fast emergency fix for "New Mailing" screen to appear would be PHP Notices disable via Joomla ...

View answer
Profile for Drupal User Registration not functioning
0 votes

Have found something for you in Google to start from, not sure if it helps, yet, you may want to to have a look: https://docs.civicrm.org/sysadmin/en/latest/setup/users-contacts/ https://forum....

View answer
Log table: nativecode=1118 ** Row size too large. You have to change some columns to TEXT or BLOBs
Accepted answer
0 votes

It turned it is an issue related to custom fields length settings and how CiviCRM works with MySQL at log tables creation. Simple put, CiviCRM takes custom field length and passes it to MySQL. ...

View answer
Same custom field name at Contact Form seems to be different for each logged in user
Accepted answer
0 votes

Not the exact answer, just a workaround one may find useful: field label stays unchanged even if field name changes, which makes possible element catch by label, e.g.: AND ($element.label eq "...

View answer