texts: Can't Get CiviCRM BuildKit files From Repository

texts:
Unable to get CiviCRM buildkit files.

I am running:

OS:           Linux   -  Ubuntu 18.04 bionic
WebServer:    Apache/2.4.29 (Ubuntu)   built:   2018-04-25T11:38:24
Database      MYSQL  Ver 14.14 Distrib 5.7.22
Language:     PHP   -  Version 7.2.5-0ubuntu0.18.04.1
Language:     Node.js  - v10.5.0
VCS:          git version 2.17.1

Executed command below as advised at https://docs.civicrm.org/dev/en/latest/tools/buildkit/

curl -Ls https://civicrm.org/get-buildkit.sh | bash -s -- --full --dir ~/buildkit

Got the results below.

root@joe-Meerkat:/home/joe# curl -Ls https://civicrm.org/get-buildkit.sh | bash -s -- --full --dir ~/buildkit
Detected Ubuntu 18.04 LTS.

Task: acl git wget unzip zip mysql-server mysql-client php7.2-cli php7.2-imap php7.2-ldap php7.2-curl php7.2-mysql php7.2-intl php7.2-gd php7.2-dev php7.2-bcmath php7.2-mbstring php7.2-soap php7.2-zip php7.2-xml apache2 libapache2-mod-php7.2 nodejs npm php-pear libmcrypt-dev libreadline-dev

Warning: This system will not support php-mysql extension

Run automated installation? [Y/n] y
Hit:1 http://us.archive.ubuntu.com/ubuntu bionic InRelease
-
-
-

Hit:9 http://ppa.launchpad.net/system76-dev/stable/ubuntu bionic InRelease

Err:10 http://ppa.launchpad.net/midori/ppa/ubuntu bionic Release
404  Not Found [IP: 91.189.95.83 80]

Reading package lists... Done
E: The repository 'http://ppa.launchpad.net/midori/ppa/ubuntu bionic
Release' does not have a Release file.
N: Updating from such a repository can't be done securely, and is
therefore disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration details.
root@joe-Meerkat:/home/joe#

Does anyone know the cause of this and what can be done?

joseph.c.mansigian@gmail.com


texts: I'm starting to learn extensions with http://wiki.civicrm.org/confluence/display/CRMDOC/Create+a+Module+Extension . I already need trouble-shooting advice. I can't figure out how to get civicrm/greeter to load. If I try to browse to it, I get the main civicrm page instead. Can anyone help me find the step I've missed.


texts:
I have a site that is using PayPal Standard as their Payment Processor and WordPress as the CMS.   After the upgrade from 4.4.x to 4.5.8 Recurring Payments are no longer working.

Could this be related to issues where the PayPal IPN callback fails?  I suspect that the issue is that PayPal is not communicating properly with the site.  Where can we find the code that would handle this?


texts: Can a contribution page that has a membership section be forced to create a new membership?

texts:
For our use-case, individuals never directly hold memberships, only organizations do, so we force the On Behalf Of Organization part of the contribution page. There's a different contribution page for New Membership than for Membership Renewal, but they both behave identically more or less for users that already have memberships.

We need the New Membership profile to ALWAYS create a new Organization and a new membership for the created org; currently when a logged-in user with existing current or expired memberships goes to the New Membership page, the membership section shows the renewal options instead of the New Membership options. When a user selects "Create A New Organization" and fills in the details, the membership part of the page just picks the existing membership that is uppermost in the Organization Name dropdown and renews it for another year instead of creating a new membership.

Is this the expected behaviour, and can it be suppressed? Is there a URL parameter I can pass in that will force a new membership?

Edit:

I should say, this is with version 4.4.10 for Drupal.

It looks like it makes the decision in civicrm/CRM/Member/Form/Membership.php, line 205:

if ($this->_contactID) {
        //check whether contact has a current membership so we can alert user that they may want to do a renewal instead

Any thoughts about how to programmatically suppress this without hacking core? My unhealthy temptation would be to do something along these lines:

if ($this->_contactID AND !($_REQUEST["forceNew"]=1)) {
        //check whether contact has a current membership so we can alert user that they may want to do a renewal instead, check for "forceNew" flag in request params

which of course would be a maintenance nightmare. Is there a hook I can use instead that will allow me to change the form's behaviour? Unsetting $this->_contactID with a hook sounds unwise, but that's how it makes the call.

Thanks!


texts: CiviCRM theme not loading after URL change

texts:
I've changed the URL of our site from beta.example.net to example.net and now CiviCRM is loading with the Drupal frontend theme instead of it's own.

I've enforced the change by updating the line in .htaccess that's enforcing https. It now reads as

RewriteCond %{HTTPS} off
RewriteRule ^(.*)$ https://example.net/$1 [R=301,L]

I've also updated the base URL in Drupal's settings.php to

 $base_url = 'https://example.net';

and the site URL in civicrm.settings.php with

if (!defined('CIVICRM_UF_BASEURL')) {
  define( 'CIVICRM_UF_BASEURL'      , 'https://example.net/');
}

I've also tried setting the CMS root in civicrm.settings.php with both

define('CIVICRM_CMSDIR', 'https://example.net/');

and

define('CIVICRM_CMSDIR', '/var/sites/c/example/public_html/');

but neither seems to make any difference.

My best guess was that I'd broken something with Shoreditch, trying at some point in the past to define a relative URL so that CiviCRM wouldn't constantly display an error. But I've gone to https://example.net/civicrm/admin/extensions (I can't navigate to it through the current theme) and disabled Shoreditch and the error is still occurring.

With Shoreditch enabled, this is how the resource URLs screen currently looks:

Screenshot of the current state of the extensions page:

And, just to confirm I cleared the cache:

Drupal's own backend loads as expected (though somewhat slowly). Drupal 7.67. CiviCRM 5.18.2. Shoreditch 0.1-alpha34.


texts: CiviEvent link Parents with Child participants during registration

texts:
I am trying to create a registration form for events for children where the parent fills in there contact details (mail/phone) and the name & birthday of the children they want to register for the event.
I have created a Child & Parent Individual in civiCrm with custom fields, I also created a parent of/child of relationship and registering works fine both the parent & the childs are created. But I can not find out how I can automaticaly link the Parent & Childs when the parent registers for the event.

I am using Civicrm 4.6.34 on Drupal.

I also found someone who used a WebForm to solve this, but I don't know how to link this WebForm with an existing CiviEvent : https://civicrm.org/blog/sarahgladstone/recipe-for-handling-youth-registration-with-civicrm


texts: If i set Views filter for Country, should the exposed State filter be limited to just the states of the chosen country/ies?

texts:
On a D7 civi 4.6.x site on a CiviContact View I set up Country filter set to US (not exposed) and set State to Exposed.
Result was the exposed State filter only shows 'any' and did not give any options of actual States.

I retested by exposing the Country filter too, set to only US, but again same outcome.

Should this be working as I hope given this jira issue is resolved, ie if a Country filter is set to a specific country (whether exposed or not) and if the State filter is set to exposed, then I should only see the States pertaining to the selected country?

I also checked the options if i edit the State filter, just to confirm the filtering to US only states wasn't happening there and that I then needed to select them all to show)

Here is the query

SELECT civicrm_contact.id AS id, civicrm_contact.display_name AS civicrm_contact_display_name, civicrm_address2.state_province_id AS civicrm_address2_state_province_id
FROM
{civicrm_contact} civicrm_contact
LEFT JOIN {civicrm_address} civicrm_address ON civicrm_contact.id = civicrm_address.contact_id
LEFT JOIN {civicrm_address} civicrm_address2 ON civicrm_contact.id = civicrm_address2.contact_id AND civicrm_address2.is_primary = '1'
WHERE (( (civicrm_contact.display_name LIKE '%]%' ESCAPE '\\') AND (civicrm_contact.display_name LIKE '%Affiliate%' ESCAPE '\\') AND (civicrm_address.country_id  = 1228) ))


texts: How do I configure the duration of the checksum links?

texts:
Is there a way to configure the duration of the checksum links used when sending a mail - either globally or using a specific parameter in the token ?

I can't find any documentation on this but i'm pretty sure it's doable.


texts: Membership sign-up fatal error: Duplicate entry, already exists

texts:
A user has tried to sign-up for a new membership. They have tried and failed multiple times. The log shows:

  $Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => handle ) [code] => -5 [message] => DB Error: already exists [mode] => 16 [debug_info] => INSERT INTO civicrm_line_item (entity_table , entity_id , contribution_id , price_field_id , label , qty , unit_price , line_total , participant_count , price_field_value_id , financial_type_id ) VALUES ('civicrm_membership' , ***** , ***** , 6 , '*****' , 1 , * , * , 0 , 7 , 2 ) [nativecode=1062 ** Duplicate entry 'civicrm_membership-*****-*****-7-6' for key 'UI_line_item_value'] [type] => DB_Error [user_info] => INSERT INTO civicrm_line_item (entity_table , entity_id , contribution_id , price_field_id , label , qty , unit_price , line_total , participant_count , price_field_value_id , financial_type_id ) VALUES ('civicrm_membership' , ***** , ***** , 6 , '*****' , 1 , * , * , 0 , 7 , 2 ) [nativecode=1062 ** Duplicate entry 'civicrm_membership-*****-*****-7-6' for key 'UI_line_item_value'] [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_line_item (entity_table , entity_id , contribution_id , price_field_id , label , qty , unit_price , line_total , participant_count , price_field_value_id , financial_type_id ) VALUES ('civicrm_membership' , ***** , ***** , 6 , '*****' , 1 , * , * , 0 , 7 , 2 ) [nativecode=1062 ** Duplicate entry 'civicrm_membership-*****-*****-7-6' for key 'UI_line_item_value']"] )

I have seen a similar bug report but that was for membership renewals and was fixed for 4.5. https://issues.civicrm.org/jira/browse/CRM-14894

We are running 4.6.7 on Drupal 7.39

Any help appreciated.


texts:
I'm trying to figure out how to get the browser version of an email to match an email using tokens in terms of personalization. The email shows the person's first and last name, the opt out and unsubscribe links, and the link to the browser version.

for example, the url for the opt out link in the browser version loses the id # as shown below. Same problem with the unsubscribe link. The first and last name also disappears.

Email version (with dummy IDs): https://mydomain.ca/civicrm/mailing/optout?reset=1&jid=5555&qid=55555&h=a5aa5a5aa555aa5a

Browser version: https://mydomain.ca/civicrm/mailing/optout?reset=1&jid=&qid=&h=

Any suggestions on keeping the personalization in the browser version?

Thanks!


texts: Trying to Create Rule to Fire When Someone is Added CiviCRM Group

texts:
Using Drupal Rules, I'm trying to create a rule that will fire when someone has been added to a CiviCRM group.

Here is a blog post from petednz which describes how to do this when a tag gets added to a CiviCRM contact.

I'm looking for the same thing but with CiviCRM groups, the choice in the Rules' "React on Event" dropdown would look like "CiviCRM Entity Group has been created" but it's not there.

Is this possible? And if so, how?

And to provide a bit more context, I'm creating a Drupal account for the Contact (If they don't have one) and adding the person to a Drupal Organic Groups group.

Thanks.


texts: Contribution Export Places Campaign IDs in Campaign Title Column, Nothing in Campaign ID Column

texts:
When we search for contributions and export, the export places Campaign IDs in Campaign Title column and nothing in Campaign ID Column. Any ideas?

CiviCRM 4.6.3 (happened in older versions also)

WP 4.2.2

Thanks,

e.


texts: Finding the status of a recurring contribution

texts:
I am setting up a website using CiviContribute whereby recurring donations can be set up.  Everything seems to be working - I can see the contributions when I go to Contributions -> Find Contribution:

and in the report:

However, when I cancel the subscription in PayPal that information isn't reflected when viewing the Contribution.  The only way I can see this information is by going to Contributions -> Contribution Reports -> Recurring Contributions.

but the contribution screen doesn't change

This doesn't seem to be very intuative, so I was wondering if I had missed something?

Thanks


texts: Is there a way to capture the event price "label" with Webform CiviCRM?

texts:
With a default CiviCRM event registration, the fee level has a label that is captured and displayed in participant listings:

When we use Webform CiviCRM as an event registration interface, the amount is captured and displays in the amount column, but the "Fee level" column is simply blank. If we set up the payment field as a dropdown, is there a way to capture the label that is used and display that in participant listings and exports in a similar way for additional context, so we don't have to remember what the dollar figure means (which could be different for different events)?


texts: Reverse sync CiviCRM groups to Drupal organic groups

texts:
We have a client who would like to sync their CiviCRM groups to Drupal organic groups.

This is opposite to the CiviCRM Organic Groups module which syncs organic groups TO CiviCRM groups.

Their are some oldish posts on the CiviCRM forum but I can't see anything recent (e.g. http://forum.civicrm.org/index.php/topic,14212.0.html). Any help would be appreciated.

Oliver


texts: Contribution page not displaying when member is logged into site

texts: The contribution page displays just fine when the member is NOT logged in to my site. I have Joomla 3.6.0 and CiviCRM 4.6.19. However, when the member is logged in, the contribution page does not display and instead the link throws you back to the homepage. Since the page is open to the public, I can't see where this problem is coming from.


texts:
Can I stop our CiviCRM database from putting emails on hold when they bounce?

While it's useful from one point of view, it takes ages to keep removing the blocks.


texts: Set the length and/or format of the checksum

texts:
Many of our constituents' online access is limited to a phone, and we get much better response to SMS text messages than to emails. For some contacts, however, clicking on the link in the text message truncates the URL. Likely a phone model issue, but which models is unclear. The issue only shows up in links with checksum, so it may be related to URL length or format (underscores?).

Is there a way to manage the length/format of the checksum? Failing that, where in the code would I look for opportunities to patch the creation and evaluation of checksums?

In case the distinction is important, we use checksums with webform-civicrm in Drupal. We don't use Profiles. Thanks.


texts: Validation fails on contribution with profile included

texts:
Using 4.7.24 with php 5.6.

I have a contribution form set up with Confirmation page turned on, and a profile is included to collect extra address information (besides a billing address).  Several of the fields on the profile are marked as required.

When I try to test the form, validation fails when I try to complete the transaction on the confirmation page.  This seems strange to me since validation should have taken place on the Contribution page already (only?).  I have confirmed that if I remove the profile or turn off the confirmation page, everything works great.

I have run this through a debugger and at the validate function, it looks for data to validate in ->submitValues.  But submitted values aren't there, except for qfKey, entryURL and _qf_default.  This seems to be OK since it's the same situation when profiles aren't included, and the form processes successfully.

So if ->submitValues doesn't contain data by this stage, why is validation looking there? Should validation even happen on the Confirmation page? And if so, why is it failing for my form when all the required fields are actually filled out?


texts:
I need to config a 2 layers group structure

GROUP 1
-- GROUP 1.1
-- GROUP 1.2
GROUP 2
-- GROUP 2.1
-- GROUP 2.2

Enabling a user to manage GROUP 1 contacts, this user will be able also to manage the subgroups contacts (GROUP 1.1 and GROUP 1.2)?

Thank's


texts: How to enable email sending in CiviRules

texts:
I've installed the Email API for CiviRules, but nothing about emails is showing up under actions in CiviRules. Have tried uninstalling and reinstalling, but no change. Is there another step that I need to be taking to enable email sending?

CiviCRM 4.6.33 on Drupal 7.56, CiviRules 1.15, Email API 1.10.


texts:
I am using Hostgator shared hosting for CIVI CRM and Drupal.From few days, I am getting an error that Error writing file '/var/mysqltmp/MYCckA2E' (Errcode: 28)".

I tried to change the queries and removed the order by clause.The query is working in phpmyadmin but there is an error in civi website.

Please help me with this issue.your suggestions are most welcome.

function query($string)
    {

if (strpos(trim($string), 'SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_sort_name, contact_civireport.id as civicrm_contact_id FROM civicrm_contact contact_civireport WHERE ( contact_civireport.is_deceased LIKE 0 ) ORDER BY contact_civireport.sort_name ASC LIMIT 0, 10') == false)
{
$string=str_replace("ORDER BY contact_civireport.sort_name ASC","","SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_sort_name, contact_civireport.id as civicrm_contact_id FROM civicrm_contact contact_civireport WHERE ( contact_civireport.is_deceased LIKE 0 ) ORDER BY contact_civireport.sort_name ASC LIMIT 0, 10");
echo $string;
        return $this->_query($string);
        }
        else
        return $this->_query($string);
    }


texts:
I have

*CiviCRM 4.6.6 on
*Drupal 7.41 running through
*Apache2 on
*Linux Mint 17 in a VirtualBox on Linux Mint 17

If I am on the LAN I can access CiviCRM and everything works:

10.141.229.171/?q=civicrm/dashboard everything works

I also have a VPN that can connect to the drupal server and when I connect I get to log into CiviCRM but then CiviCRM stalls while it tries to connect to the LAN address so the system fails to work.

If, at that point, I stop the browser from continuing to load I can use the CiviCRM dropdown menus and go to almost any other page, including the Drupal menu. As far as I can tell only the dashboard fails to load.

_http://10.12.0.23/?q=civicrm/dashboard -- stalls with the message: "Connecting to _http://10.141.229.171..."

Note: I inserted an underscore just to prevent creating a real link in this message.

I know that the CiviCRM addresses are set to the 10.141.229.171 address but I would like my VPN clients to access the site as well.

The best I can come up with is that I need to set my VPN computer so that:  Any link for 10.141.229.171/page_name gets rewritten to be sent as
10.12.0.23/page_name   -- I tried a few FireFox addons to accomplish this but they failed to work, perhaps because of Java Script?

Again, it seems to fail only with the dashboard.

Unfortunately I am struggling to find out how to fix that. Is it even the right way? Can it be done in any way?

Thank you in advance for any help you can provide. John in Oregon, US


texts: I am currently having issues with PayPal communicating with our website and CiviCRM. Half of the recurring contributions have not shown up over the past couple months and every one-time donation has listed as "Pending/Incomplete Transaction over the past week. Our current version of Civi is 4.4.3. We have checked the URLs and our web host has white-listed all IPN's even though they don't think anything was being blocked. We have also applied a few patches of code from newer versions and we are still having issues. Is anyone else having this problem. This is a bit out of the scope of my knowledge. Thanks.


texts:
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.


texts: Log out after user creation, session key gone. D8.6.2 with CiviCRM 5.6.1

texts:
we successfully managed to get D8.6.2 with CiviCRM up and running.

But when creating a new user by D8-Admin, the user is logged out with error page access denied. The user is created correctly but the session is killed.

Deactivating of Profiles in CiviCRM causes the known error:

    Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider
    with more details about what action you were performing when this
    occurred. 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 administrator 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.

When checking the cookies during the user creation process, i see that the session cookies are gone after submitting of the creation form.

We tried to modify this part in civicrm.module:

  Attach any relevant profile form fields to user registration form.
  */ function civicrm_form_user_register_form_alter(&$form, &$form_state, $form_id) {   $civicrm = \Drupal::service('civicrm');
  $civicrm->initialize();   $html =
  \CRM_Core_BAO_UFGroup::getEditHTML(NULL, '', NULL, TRUE, TRUE, NULL,
  FALSE, $civicrm->getCtype());

  // Need to disable the page cache.
  \Drupal::service('page_cache_kill_switch')->trigger();

  // We need the CiviCRM core Javascript.
  CRM_Core_Resources::singleton()->addCoreResources();

  $form['civicrm_profile_register'] = [
  '#markup' => Markup::create($html),    '#cache' => [
   'max-age' => 0,
  ],   ];   $form['#validate'][] = '_civicrm_user_register_form_validate'; }

to:

/* \Drupal::service('page_cache_kill_switch')->trigger();*/ to stop the cache from beeing killed, but that had no impact.

Does anyone has an idea, who we can keep the session alive or give us a hint, where the problem might be?

THX
Lars


texts: What is the easiest way to see the MySQL queries run by a CiviCRM page?

texts: When debugging CiviCRM pages, is there a native way to emit the SQL statements being run, eg on a Search page? I'm looking for something easier than finding the code for the page and putting in a debug_var kind of statement. I'd prefer to not have to rely on a Drupal module like cTools, since we work with other CMSes frequently these days.


texts: I've been asked to take a look at a civicrm installation on wordpress. They are having trouble getting an event page to work correctly. I found that there are lots of javascript errors being thrown. When I look at the page source of the registration page I see lots of p and /p tags in with the javascript which is causing script errors. e.g.


texts:
I only now noticed that trxn_id was NULL for a number of rows on a particular date, for payment transactions in civicrm_financial_trxn. The schema/table def. shows that trxn_id cannot be null in civicrm_financial_trxn, and as expected, is set to auto-increment - what could account for those null IDs?
 I don't have root access so cannot see mysql log from that date. Total_amount is > 0, status_id = 1, datetime stamps are there, the rows were written, but trxn_id is NULL btwn ~ 14:00 and 21:00 on that date.


texts: Buildkit Site fails to load due to PHP ugrade from 5 to 7

texts:
After Upgrading from php 5.6 to php 7, when i try to access the sites created using buildkit, I am unable to access it.
After typing

Civibuild show dmaster

I get the following

ERROR: Failed to find required PHP extension "SimpleXML".
TIP: In some systems, the PHP version used in CLI and web are different. >Extensions should be active in both.

the TIP is a bit clear about the change in the PHP version, where do I trick that to work?, and where exactly is that done?


texts: Lack of payment processor blocking renewal reminders

texts:
We do not (yet) have a Payment processor - Internet bank transfers (which count as offline payments) are more or less the norm in New Zealand.
However, we still need to set up scheduled reminders as memberships expire.
The lack of a payment processor means we can't select anything for Auto-renew options for each membership type, and this in turn is causing the form to create a membership reminder to fail, as there are no valid entries in the third part of the entity selector.
How can we work around this?

Richard

CiviCRM 4.4.4


texts: Webform Event Registration Match Contact

texts:
I have created a webform (Drupal) for people to register for an event. I am trying to avoid creating duplicate individuals if they already exist in Civi when they register, but at the moment whenever there is a registration it always creates a new contact, even if they already exist.

When setting up the webform, in the Civi settings I selected Existing Contact, but kept the Existing Contact component hidden and set to static. I have included First Name, Last Name and Email fields. For the Matching Rule under the contact fields, I have set this to a custom unsupervised rule that just does a check on first name and last name. However, even with all these settings, it is still creating a new contact every time for the event.

Am I misunderstanding the way event registrations work? I want to avoid getting existing contacts to login to Drupal before registering if possible, as I want to keep the form as simple as possible. Would it make a difference if I used a profile form instead?

If I cannot solve this then I guess I can always merge contacts afterwards, but it would be nice if duplicates weren't created in the first place.

I'm using Civi 5.9.0 with Drupal 7.61.

I'm attaching a couple of screenshots of my settings:

EDIT:

Images for the rules settings and the Name Only rule:


texts: Warning: in_array() expects parameter 2 to be array, null given in CRM_Event_BAO_Event::checkPermission() (line 2053 of BAO/Event.php)

texts:
Running into a crazy error that came to me out of the blue. I have a simple page with a few views showing CiviCRM entities.

When I view this page as an administrator, or as the user showing the warning, everything looks and works just fine.

The issue is that the non-administrative users get this blaring error and I can't seem to figure out why...

Any ideas as to what permissions issue this might be?

Cheers!

Warning: in_array() expects parameter 2 to be array, null given in CRM_Event_BAO_Event::checkPermission() (line 2053 of /public_html/sites/all/modules/contrib/civicrm/CRM/Event/BAO/Event.php).
Warning: in_array() expects parameter 2 to be array, null given in CRM_Event_BAO_Event::checkPermission() (line 2053 of /public_html/sites/all/modules/contrib/civicrm/CRM/Event/BAO/Event.php).
Warning: in_array() expects parameter 2 to be array, null given in CRM_Event_BAO_Event::checkPermission() (line 2053 of /public_html/sites/all/modules/contrib/civicrm/CRM/Event/BAO/Event.php).


texts: CiviVolunteer front-end assignment listing

texts:
Does CiviVolunteer provide the capability for front-end users to see a volunteer listing of assigned volunteer slots for an event?
Thanks!


texts: Error! - PayPal Standard return to merchant url error on Joomla (Civicrm 5.31.0 and 5.32.2)

texts:
After registering for an event and making payment PayPal tries to redirect back to the merchant at which point there is an error - this looks like it was a know error in 5.30 and fixed for Drupal and Wordpress
Joomla! 3.9.19 Stable
Civicrm 5.31.0 & 5.32.2
Error Message:
Sorry, due to an error, we are unable to fulfil your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
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 administrator 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.


texts:
It seems as though one of the members of my organization has used their access to our contact information in a way that they shouldn't have. I've been tasked with proving that they searched for, and accessed the email addresses of contacts and then copied or exported this information.

Is it possible to find a record of "who searched what" in drupal CiviCRM? I am open to either using the interface or mysql backend directly.


texts:
It seems that the ability to search on a list of last names (delimited by a space) was removed from searching.  We are using version 4.6.4.  Whether or not this was intentional, we need to be able to do this.  Searching for each name (usually 80+ names) will be a much bigger pain. Is there any other way to do this search?  We do know search builder can be used but hoping for a better, quicker way.

Thanks


texts:
Running Civicrm v4.7.14 on Wordpress v4.7 PHP v 5.6.29

For the last couple of weeks, I've been getting the following PHP warning emails, mostly hourly, from my host's server, after the CRON runs with cli.php.
All permissions are set correctly in root /httpdocs /wp-content /plugins /civicrm /civicrm /bin/cli.php.

My host has investigated the email setup but found no problems.

Everything else with CRON is working normally and all scheduled jobs are being executed as far as I can tell, with the exception of mail_report where error message is "Finished execution of Mail Reports with result: Failure, Error message: A fatal error was triggered:  is not of type String".  I'm not sure whether this has any relevance and it would appear that this message was being received prior to when the PHP warnings started.

Mail() is used (rather than SMTP).

The PHP warning messages are as follows:
PHP Warning:  scandir(INBOX/cur): failed to open dir: No such file or directory in /var/www/vhosts/mysite.org/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Mailing/MailStore/Maildir.php on line 85

PHP Warning:  scandir(): (errno 2): No such file or directory in /var/www/vhosts/mysite.org/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Mailing/MailStore/Maildir.php on line 85

PHP Warning:  Invalid argument supplied for foreach() in /var/www/vhosts/mysite.org/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Mailing/MailStore/Maildir.php on line 85

PHP Warning:  scandir(INBOX/new): failed to open dir: No such file or directory in /var/www/vhosts/mysite.org/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Mailing/MailStore/Maildir.php on line 85

PHP Warning:  scandir(): (errno 2): No such file or directory in /var/www/vhosts/mysite.org/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Mailing/MailStore/Maildir.php on line 85

PHP Warning:  Invalid argument supplied for foreach() in /var/www/vhosts/mysite.org/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Mailing/MailStore/Maildir.php on line 85

PHP Warning:  scandir(INBOX/cur): failed to open dir: No such file or directory in /var/www/vhosts/mysite.org/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Mailing/MailStore/Maildir.php on line 85

PHP Warning:  scandir(): (errno 2): No such file or directory in /var/www/vhosts/mysite.org/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Mailing/MailStore/Maildir.php on line 85

PHP Warning:  Invalid argument supplied for foreach() in /var/www/vhosts/mysite.org/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Mailing/MailStore/Maildir.php on line 85

PHP Warning:  scandir(INBOX/new): failed to open dir: No such file or directory in /var/www/vhosts/mysite.org/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Mailing/MailStore/Maildir.php on line 85

PHP Warning:  scandir(): (errno 2): No such file or directory in /var/www/vhosts/mysite.org/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Mailing/MailStore/Maildir.php on line 85

PHP Warning:  Invalid argument supplied for foreach() in /var/www/vhosts/mysite.org/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Mailing/MailStore/Maildir.php on line 85

Lines 85 to 89 in the Maildir.php file shows:
foreach (scandir($dir) as $file) {
        if ($file == '.' or $file == '..') {
          continue;
        }
        $path = $dir . DIRECTORY_SEPARATOR . $file;

I'm not sure whether I have any missing core files and any help to find out the cause of these warning messages would be greatly appreciated.


texts: When using search builder to find contacts that are in multiple specific groups (AND, not OR), 0 results returned

texts:
Let's say you have Group A & Group B, and two contacts, Contact A and Contact B. We want our search to find those contacts who are in both Group A AND Group B.

For example, if Contact A is in Group A only, but Contact B is in both groups, then the result of this search should be 'Contact B'.

Search builder looks like:
Contacts, Group(s) = Group A
Contacts, Group(s) = Group B

Result: no results.

No errors are logged.

We had several groups built on searches of this type, but after updating from 5.6.1 to 5.10.3 these all broke and began returning no results.

I have tested this on the Demo site but could not reproduce - however the demo site is running 5.13.alpha1, so it's not a fair test.

The release notes for 5.11.0 indicate some search fixes, but not anything that would make me assume this would also be resolved. I wasn't able to find anything in  Gitlab about this either. I'd rather not wait for 5.13 to be released so if someone could possibly point me to a specific patch that I could test in the meantime, that would be fantastic.


texts: Extension: UK Phone Number Validator - permissions

texts:
Cool little extension. I am about to trial it on a site. I'm new to extensions so am trying to work out how this is permissioned. On the wiki I see "At this time, permissions for extensions are not influenced by CiviCRM's ACL system so we need to rely on the underlying permissions of the CMS to allow or deny access to an extensions pages." I can't find any info on the specific extension page/post but from the wiki it seems like extensions are usable by anyone with the 'administer CiviCRM' permission and/or 'access Contact Dashboard'. BUT, I'm masquerading as a user with neither of these permissions, and I can still access the admin screen for this extension at mysite.org/civicrm/phonevalidator.

Help appreciated.


texts: Can I add an automated "other" field using custom fields?

texts: I have a "Select" field options for one of the custom data set. One of the "select" option is "Other". But I would like user to manually enter data related to "Other" field into another text field. Is it something possible to do?


texts: Force membership sign-ups to register as user

texts:
As the title already says, I am trying to create a WordPress user for each person paying a membership fee.

Therefore I already checked the Anyone can register box in the WordPress settings.

What it should look like:

a person navigates to my site where the signup form (contribution page) is displayed (this works so far)
when he signs up he has to register as a user (so insert a password and username) - this part doesnt work so far there is only the email field and the billing fields.

Can somebody help me to achieve that?


texts: Webform form submit, and notify auto email in html format!

texts: I have a newsletter signup form built over webform. For people who signed up, I want to send an automatic notifications email once the form is submitted. It's working like a plain text. But I would like to customise the email and send in html format. Is it possible to do?


texts: CiviReport - Add days to Transaction Date for Estimated Deposit Date

texts:
Our Treasurer has asked for a report that will help him reconcile the monthly bank statement more efficiently. As with most financial services vendors, our vendor (iATS) has a delay between the transaction date (or receive date in Civi) and the day the money is actually deposited into our organization's bank account.  This creates an extra step for our treasurer as he has to line up the transaction dates in Civi to the deposit dates on the bank statement.

iATS has the added wrinkle that credit/debit card transactions are deposited on a different schedule than ACH/EFT transactions.  How can I create a column in the CiviContribute Bookkeeping Transactions report that will give an estimated deposit date for each donation based on what type of payment instrument was used and what day of the week the transaction took place?

For reference, iATS deposits transactions on this schedule:

Credit/Debit cards - 1-2 business days, rolling; to be safe, the default on the report will be 2 business days unless the transaction happens on a Friday-Sunday; then it will be the following Monday.
ACH/EFT - each Sunday through Saturday is deposited on the following Wednesday.

Civi 4.6.20, Drupal 7


texts: How to allow an active membership with payment pending?

texts:
We want to start recording membership payments, but we also want memberships to become current when the start date hits even if the payment is still pending. Our members are schools paying by invoice, and membership grants the member access to a custom portal.

I have been told status override isn't good enough because it would add steps to the process to set it after entering a membership and to remove it once the membership is paid so that it will eventually expire normally.

I have investigated hook_civicrm_alterCalculatedMembershipStatus but this sees what the status would be if it wasn't pending payment- ie already what I want it to be- so I can't change it from pending there.

I'm on 4.4.13 if it makes any difference.


texts:
Joomla 3.8.5
CiviCRM 4.7.29
PHP 7.0.7
I have four contribution pages for different membership levels, Bronze, Silver, Gold and Platinum. Everything seemed to be working and I had members signed up through all four pages. At some point, not sure when, three of them stopped working - Bronze, Silver and Platinum. I only found out because potential members emailed me to tell me they couldn't access the pages. I checked from the front end by selecting the appropriate menu items and found that only the Gold went to a contribution page, the other three only produced a blank whit page. I can't find anything in the log that helps.


texts: Multiple Roles in WordPress and CiviCRM access rights

texts:
By Default WordPress only lets users/admins set a single role per user.  This is done by a dropdown on the user's profile (in WP).

However, additional roles can be added, either by using a plugin or with custom code.  This works fine on the WP side granting the user the capabilities of all roles that they are added to.

The question is how does CiviCRM handle this?   Does it read all roles and give the user the rights of all roles?  I am testing this now, but would like any insights from others that have done this.

What have others done in this case?  I don't want to create a ton of WP roles and even though CiviCRM ACLs are available, the end user won't be able to manage that.


texts: How to modify Relationships column display?

texts:
This is a new launch for an old question, see here and here.
We want to modify the columns that are shown in the relationships result display and especially replace city and state/county rows by job title.
Is this something we can now set in admin or do we need to create custom templates? We identified /CRM/Contact/Page/View/RelationshipSelector.tpl for example and are still looking for the body template.
Should we follow on this way?


texts: What is the proper CiviCRM response when an Authorize.net CC transaction is declined?

texts:
using WP4.3.1 and Civi 4.6.9.  We got the below message from a member:
  "I renewed online with a credit card but did not get a confirmation of my
  payment. After completing and clicking on ‘make payment’ it took me back
  to the renewal page. If I am confirmed, could you please send me a
  receipt?"

When we checked on our end, it said Transaction Status: Declined (Card
 declined by issuer - Contact card issuer to determine reason.)

We are concerned that the system isn’t letting people know if there
was an issue processing their payment. I was pretty sure that it would
give them some sort of message, but wanted to check.


texts: CiviReport widgets show access denied on CiviCRM Dashboard

texts:
I've recently migrated a site to another host and pretty much everything is working except that when I go to /civicrm, the dashlets on the dashboard all show Access Denied and a login form.  They are being provided by CiviReport according to their respective breadcrumbs.

In addition, I noticed that I could not disable CiviReport or any of the other CiviCRM Components.  When I click Save on that page, it just bumps me back to /civicrm/admin with no error message.  Going back into civicrm/admin/setting/component just shows the modules still enabled.

I'm still a CiviCRM noob, so it could be something simple.


texts: Custom Tokens TOKEN_REGISTER not getting invoked

texts:
CiviCRM 5.9.1
Drupal 7.61

Trying to create custom tokens using "hook_civicrm_container", TOKEN_REGISTER is getting set as well as TOKEN_EVALUATE function in $container variable but TOKEN_REGISTER function is never getting invoked. Testing through opening up 'Send en Email' action on contact record.

Below is the code in place in a custom module.

function test_module_civicrm_container($container) {

  $container->addResource(new FileResource(FILE));
  $container->findDefinition('dispatcher')->addMethodCall('addListener',
    array(\Civi\Token\Events::TOKEN_REGISTER, '_register_tokens')
  );
  $container->findDefinition('dispatcher')->addMethodCall('addListener',
    array(\Civi\Token\Events::TOKEN_EVALUATE, '_evaluate_tokens')
  );
  //CRM_Core_Error::debug('container', $container);exit;
}

function _register_tokens(\Civi\Token\Event\TokenRegisterEvent $e) {
echo 'came here';exit;
  $e->entity('profile')
    ->register('viewUrl', ts('Profile View URL'))
    ->register('viewLink', ts('Profile View Link'));
}

function _evaluate_tokens(\Civi\Token\Event\TokenValueEvent $e) {
  foreach ($e->getRows() as $row) {
    // @var TokenRow $row
    $row->format('text/html');
    $row->tokens('profile', 'viewUrl', 'http://example.com/profile/' . $row->context['contactId']);
    $row->tokens('profile', 'viewLink', ts("Open Profile", array(
      1 => $row->tokens['profile']['viewUrl'],
    )));
  }
}

Trying to follow doc here


texts: Sending an invoice per email goes to primary address, not to billing

texts:
I am  not sure if I overlooked a setting or if it could be considered to be a bug.

When we do a search on contributions and with the results we select "Print or Email Contribution Invoices" and we select Email, the invoices are sent to the Primary email address for the contact, but we need them to go to their "Billing" email addresses (Which I think is logical for an invoice).

Is this a setting I overlooked, a feature (I don't understand) or a bug?


texts: How do I make profile submissions more reliable, or at least not silently fail?

texts:
When a profile is submitted without a valid cookie, the submission is lost (no data saved in the database) and the site redirects to the front page of the website.  This occurs on Joomla when:

An HTML snippet is used (I'm working around this by embedding an iframe loading a standalone profile page, with CSS display:none to hide it)
You load a profile, then delete the cookies for the site
You load a profile, then wait a few hours before submitting it

We just had the 3rd condition trip up someone trying to fill out a form on our website.  She loaded the page, let it sit overnight, and tried to submit the form 8 hours later.  I don't know how to prevent this besides adding a note by the Save button to the effect of "If it has been more than an hour since you loaded this page, please reload it before saving the form".  This seems really clunky, and will potentially lose the long answers users have entered into the form, if their browsers don't handle the reload well.

Is there a way to remove the dependence of the form submission on a cookie?

If not, is there a way to control what I assume is a cookie timeout, to reduce the incidence of the 3rd condition?

If not, is there a way to redirect the failed profile submission to an error page instructing the user to go back and try again?  As it is, with no error given and the site redirecting to the front page of the website, the user has no idea anything went wrong and that their submission has been totally lost.  This seems like a serious problem.


texts: CiviCRM on Wordpress - Suppressing 'Administer' Menu items

texts:
Top Menu  --> "Administer"
I'd like to suppress ALL the menu items like "Administration Console" through "System Settings" but allow all the other menu items like :

Civi Campaign
Civi Case
Civi Report
Civi Discount

Thanks.


texts: Issues with the Default Email address for bounces - authentication

texts:
CiviCRM 4.7.19 / Drupal 7.54

I am stuggeling with the setup of the default mail account in CiviCRM
(... /civicrm/admin/mailSettings?reset=1)

I have setup a IMAP mail account for processing bounced email. Receiving email in this mail account works using my mail client using information below.

Mail account info:

Email address:   bounces@mydomain.org

Username:        bounces@mydomain.org (ISP requires that the full email
address be used for the username)

Password:        mypass

Server:          mail.mydomain.org

Protocol:        IMAP

SSL:         is activated

.

CiviCRM (CiviMAIL) settings:

Name:        Bounce processing

Server:      mail.mydomain.org

Username:    bounces     <<<<--- should be full email addres:
bounces@mydomain.org

Password:    mypass

Local part:

Email domain:    mydomain.org

Return address:

Protocol:    IMAP

Source:

Use SSL: checked

Used for:    processing bounces

.

Results Cron Job -

Entiteit: job Actie: fetch_bounces
Summary
Finished execution of Fetch Bounces with result: Mislukt, Error message: A fatal error was triggered: Kan geen verbinding maken met Mailstore voor bounces@mail.mydomain.org
Foutmelding:

An error occured while sending or re (...)
Details

Parameters parsed (and passed to API method):
a:1:{s:7:"version";i:3;}

Full message:
Finished execution of Fetch Bounces with result: Mislukt, Error message: A fatal error was triggered: Kan geen verbinding maken met Mailstore voor bounces@mail.mydomain.org
Foutmelding:

An error occured while sending or receiving mail. Failed to connect to the server: mail.mbrainingcentrum.com:993.

.

When I use the full email adress as username I get errors referring to: bounces@mydomain.org@mail.mydomain.org

Looks to me that CiviCRM(CiviMAIL) has a bug regarding concatenatig proper parts.

Any solution?

Many thanks in advance !

Best regards,
Ton


texts: How to print reports with non-English characters like accents?

texts:
We have instances of CiviCRM in Spanish and Catalan. When we try to print some reports the Spanish and Catalan specific characters (accents,
umlauts, etc.) are printed with a wrong charset. E.g. It prints RelaciÃ³ instead of Relació

It is a bug or we're missing something?


texts: Webform with existing contact results in undefine index

texts:
Running into this problem in a form to create an activity with two existing contacts.  The form creates the activity successfully, but the UX is marred by angry red error messages.  I replicated the problem in a test form with nothing but one existing contact.  This test form is accessible at http://cc.unidosnow.org/node/7?cid1=200.    Submitting the test form results in similar error messages as seen with the full fledged form:

Notice: Undefined index: address in wf_crm_webform_postprocess->saveContactLocation() (line 751 of /home/unidosnow/www/www/sites/all/modules/webform_civicrm/includes/wf_crm_webform_postprocess.inc).
Notice: Undefined index: email in wf_crm_webform_postprocess->saveContactLocation() (line 752 of /home/unidosnow/www/www/sites/all/modules/webform_civicrm/includes/wf_crm_webform_postprocess.inc).

Seems to be wanting address and email (to enable contact creation?), but the only thing checked in the webform's CiviCRM tab is Existing Contact and that's all I need from the contacts in the full fledged form.

I am running CiviCRM 7.x-4.7.29, Drupal 7.58, Webform 7.x-4.16, Webform CiviCRM Integration 7.x-4.20, PHP 5.6.

Thoughts?


texts:
CiviCRM is prorating memberships and I do not think I have setup any feature for prorating the cost of the membership. It appears to show up when I apply a discount code. For example this outrageous example.  See:

I checked and there are no CiviCRM errors, Apache error, and JS logs. Any ideas are appreciated.
Thanks,
Josh


texts:
I have individual members that can have different criteria for example:
Are you an English teacher : checkbox yes / no
(if yes :: appears in contribution form): what is your degree?: check boxes: bachelor/master/PhD
(if no :: appears in contribution form): what is your level at TOEFL? : free text.

How do I set conditions in forms using WordPress? Our membership for individual (member) is very complex and I don't want the form to be 1000 lines long.

I couldn't find this in the documentation.
Any help?
regards
Guillaume


texts: How do I automatically create a case on inbound email?

texts:
I feel like this is an incredibly basic question, but I have read through the user guide, the admin guide, and searched stackexchange and google, and I have not found the answer.

I have set up an e-mail account to receive inbound emails, and I have successfully configured CiviCRM to check that account, pull in email, and turn those emails into Activities on the contact record.  So far, so good.

But what I want is for any inbound e-mail to become a case in CiviCase.

I have read in the docs that inbound email will be tagged to an existing case if it contains a subject line field.  And I have also read here:

  In the CiviMail chapter the Email Processor was described as a way to
  get inbound and outbound emails into CiviCRM as non-case activities.
  When you enable CiviCase, a new action will be available that allows
  you to file any non-case activity onto a case.

Where is that new action?  I edited the Scheduled Job for Process Inbound Email, and it doesn't have an option to put new emails into a case.

Thanks for your help.

CiviCRM 4.7.20 on Drupal if that matters


texts:
We are trying to come up with some reports that show retention rates over the years.  I had thought that I would be able to do a include/exclude search where I include members from 2015 and exclude members from 2016 to show who had dropped out, but the 2015 members are problematic.  For example, we have a member who joined in 2012, and did not renew until 2016.  With a start date of 1/1/2012 and an end date of 12/31/2016, there is no data point which shows whether they were an actual member in 2015.  In addition, many of our memberships are free, so there is no transaction to query.

Any idea how to do this?


texts: Advance search result does not match with the member report

texts:
There is a problem with the Civi Reports. The report feature is not pulling all of the members
in each of the categories, when we generate one member report and also generate the same report  with the same criteria on advance search but there  is difference in the both result. Please check the screenshot.

member report screenshot (http://www.dowce.com/~Fjk)
advance search
screenshot (http://www.dowce.com/~Fjt)

Ultimately there is a bug somewhere in the reporting feature that is preventing all of the
records from showing up when they are queried.

Please let me know is anyone faced such type of issue, if yes then please suggest solution.
Looking forward for response on same.Advance thanks to all.


texts: How do I enter new contact from "New Case" form using a contact subtype?

texts:
When I click in the Client field, I can start typing the name of an existing contact or I can click on "New Individual," "New Organization," or "New Household."

However, it doesn't list our "Hotline Caller" Individual sub-type, which is the only option I would like to have listed.


texts: How to use G Suite / GMail as your CiviMail Provider

texts: After receiving some clarity on CiviMail settings and using a ton of guides - we were able to setup GSuite / GMail as our email provider. The answer to how we implemented it is below. If others have feedback - please chime in.


texts: CiviCRM Extended Security Release details

texts:
We are all-in for the CiviCRM Extended Security Release (ESR) version 5.21.3. We've been big CiviCRM fans for a while. It sounds like a great deal. We just have a few questions, which I will post on this forum.
Does anyone know the proper contact person?
What is the maximum number of monthly or yearly support phone calls or emails?
Are there any support provider partners that can match the published ESR pricing below for small- to mid-tier?
Thank you!

Jamie

Pricing
https://civicrm.org/civicrm/contribute/transact?reset=1&id=64

https://www.civicrm.org/esr


texts: Contributions appearing twice in Civi, once in Authorize - why?

texts:
We're on Civi 4.6.3. We use Authorize for recurring debit/credit card contributions (though we are switching over to iATS for bank drafts, and if that works well, switching over to iATS for credit/debit card as well).

Recently we've seen two contribution records appear for the same transaction that only processes once in Authorize. These are all online contributions. The time lag is typically a day or so between the two Civi contribution records.

Anyone else see this happening and have an idea as to why?


texts: Drupal CiviCRM Contact View -- Show all groups for a contact

texts:
Ok, this should be very straight forward but it doesn't appear to be.

I have a CiviCRM Contact View in Drupal 7. It is a contact search of sorts. When a contact is rendered a number of things are displayed. The contacts can be a member of one or more CiviCRM Groups and I would like to display a comma delimited list of the groups that each contact belongs to. At present Drupal Views only displays the first group.

Any ideas of how to render more?


texts: Upgrade from 4.6.10 to 4.6.16 states DB already upgraded to 4.6.10

texts:
Using WP 4.5.2 - We followed the steps to upgrade and when we ran step "4. Run the Upgrade script" we get the following error - Can not do this Database is already upgraded to 4.6.10.
Everything seems to work ok... but it still shows the version at 4.6.10.  Does this mean I have the 4.6.16 code but the DB is still at 4.6.10?   How do I get this completed?  I feel like I'm stuck in the middle somewhere?


texts: Show default country and state for public proximity search

texts:
I'm trying to figure out how I can set public-facing proximity searches in 4.7.25 to default to civiCRM's default country?

Currently, the user is required to select a country and state, but 99% of our searches happen within the same country.

is there a way to set this?


texts: How do I make a new Custom Field Set visible in the Tab Display Style?

texts:
I have created a new Custom Field Set.  When I set Display Style = Inline, the tab shows as expected.

However, when I set Display Style = Tab, it disappears.  There is no Custom Fields tab either?

How can I make the new Custom Field Set visible?

Damihyph


texts: Upgrade Does Not Pass [Executed: Begin Upgrade to 4.7.19]

texts:
I am trying to upgrade from 4.7.18 to 4.7.29.  I am doing this on a development server and I have created a sub-domain for it and made sure that the site is running before I attempt to do the upgrade.

I have tried the upgrade several times (having restored the database and reset paths) and I still get stuck at the begging saying - [Executed: Begin Upgrade to 4.7.19].

The url I am at is https://[subdomain].[domain.org]//civicrm/upgrade/queue/runner?reset=1&qrid=CRM_Upgrade

I have PHP 7.0.22 on my test server and MySQL 5.7.21.  Basically, what comes out the box with an Amazon Ubuntu AMI.

Thanks,
Josh


texts: Error on Civi upgrade to 4.6.10 on Wordpress

texts: TypeError: CRM.$ is not a functionhttp://mygriefandloss.org/wp/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fupgrade%2Fqueue%2Frunner&reset=1&qrid=CRM_Upgrade line 284


texts: REST API: Unable to decode supplied JSON

texts:
REST API works, but I cannot pass json parameter to it, getting "Unable to decode supplied JSON".

I am running CiviCRM 4.6.8 on Wordpress.

I have properly identified SITE KEY and API KEY, and I can run REST query with an empty json dictionary as parameter:

https://foo.com/wp-content/plugins/civicrm/civicrm/extern/rest.php?entity=Contact&action=get&api_key=secret1&key=secret2&json={}

which gives me 25 contact records in a json data structure.

But when I try to add a json parameter (copied from API Explorer):

https://foo.com/wp-content/plugins/civicrm/civicrm/extern/rest.php?entity=Contact&action=get&api_key=secret1&key=secret2&json={%22sequential%22:1,%22email%22:%22marcin@akcjademokracja.pl%22}

..I get the following error:

{"is_error":1,"0":"error_message","1":"Unable to decode supplied JSON."}

What am I doing wrong?


texts: Can an optout link be included in a scheduled reminder?

texts:
We have started collecting "prospective members" from callers to our 24/7 helpline.  Email addresses are collected via a webform and at the same time a civicrm activity is created.  We have set up one scheduled reminder to go out 24 hours after that activity is created and a second to go out 29 days after the activity created date.

We want to give these prospective members the ability to optout from all communications with us from either email.

It appears that {action.optOutUrl} does not work for scheduled reminders.  Is that correct and if so, can anyone suggest a way to let these prospective members opt out?

We are using CiviCRM 4.4.19 on Drupal 7.


texts: Changing Display Path to /civicrm on frontend

texts:
I have just done a new install of CiviCRM 5.15.1 on Wordpress 5.2.2, and before going any further, is it possible to change the mydomain.com/civicrm path to civi pages to something else? Say, mydomain.com/members.

Or will this muck everything up for future updates?

Thanks for your advice.

Cheers,
Tracy


texts: Edit Line Item error: Tax for amounts above 999.00 = NaN.N

texts:
I'm using the Edit Line Item Extension ver2.1 (biz.jmaconsulting.lineitemedit) on Civi 5.13.4 and the latest Drupal 7. I have a paid event where bookings are made via webform-civicrm.

If I edit a lineitem where the cost (unit price multiplied by quantity) exceeds 999.00, the tax amount calculates to NaN.N. I can submit the change but the tax amount is zero.
If I add a new line item where the amount exceeds 999.00 the tax amount again reflects as NaN.N, and I cannot save the change.
Any ideas?
Many thanks, Davy


texts: If statement involving "is not empty" in smarty template?

texts:
How do I do this in a Smarty template:

If {contact.supplemental_address_1} is not empty
then {contact.supplemental_address_1}


texts: Default values for Preferred language, email format, email greeting, postal greeting and addressee

texts:
we are in the process of setting up CiviCRM and we are importing a lot of records from a previous CRM. when we do the import, the preferred language defaults to english.  how do we get this to be a null value unless we import a value?

Same question for email format, email greeting, postal greeting and addressee.  All are showing a default value. Null would be more accurate.


texts:
Sorry in advance for my lack of familiarity with civi, I'm not the most experienced member of the team.

We seem to be running into a problem with the Rebuild Smart Group Cache job where the cpu will completely max out every time it is run. I looked deeper into the issue in the log and have gotten the following output:

[info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => exceptionHandler
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] =>
    DELETE  g
      FROM  civicrm_group_contact_cache g
      WHERE  g.group_id = 120  [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]
    [type] => DB_Error
    [user_info] =>
    DELETE  g
      FROM  civicrm_group_contact_cache g
      WHERE  g.group_id = 120  [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="
    DELETE  g
      FROM  civicrm_group_contact_cache g
      WHERE  g.group_id = 120  [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]"]
)

It has also happened on the query

       [user_info] => INSERT IGNORE INTO civicrm_group_contact_cache (contact_id, group_id)
        SELECT DISTINCT id, group_id FROM civicrm_temp_group_contact_cache910
       [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]

Is this at all related to https://civicrm.org/blog/eileen/478-group-contact-cache-deadlocks-improvement ? And would it be alleviated by changing the caching setting mentioned in the blog post?


texts: How can I configure my contribution page so that recurring is not pre-selected by default?

texts: Obviously, I want to provide the option for recurring but I do not want it to load the page with default recurring selected. I think this is the way most administrators would want it to work. Should be simple, right?


texts: Fetch data over the web: curl, file_get_contents or something else?

texts:
I've written quite a few extensions that need a way to fetch data from the web. Sometimes I've used file_get_contents sometimes cURL, other times I've sucked in (geddit!) Guzzle. Each of those has it's own requirements.

Just want to check that CiviCRM does not offer a service/wrapper for this that knows what is available? What's recommended?


texts:
We recently upgraded to CiviCRM 5.3.2 and have run into a couple of problems since then.

The main issue is that member sign up is not working on iPhone X when members try to pay with a credit cart (checks appear to be working fine).  I have tested a couple of phones, and iPhone X appears to be the only one having this issue.

What happens is that they fill out the registration form, hit "confirm", and then the confirmation page is missing their first and last name.

Has anyone run into this issue?

We are using Drupal 7.61.


texts: Has anyone had success in embedding videos into CKEditor in CiviCRM

texts:
Following on from my question here, we are wondering if anyone has successfully embedded videos into CKEditor in Civi. We want to put videos into our event descriptions.

We can embed a vimeo or YouTube video into CKEditor easily enough, by copying the embed code into Source.

We can then make the public view look great - floating the video and making it responsive etc etc.

However, inside the wysiwyg view it is very limited. It's just a 300x150px preview of the video that we can't seem to get any control over. We can't click it... and therefore can't apply styles from our custom styles.js file to it.

Also, it's fixed - we can't drag it about - and it's inline (ie no text wrap) and merely a small thumbnail. So not at all wysiwyg - and our admin teams are used to sites that are beautifully easy to use these days... and so get a bit exasperated when they have to use trial and error to see how the video will look after they've saved the page.

Any ideas?


texts: How to add a profile with a fieldset that accepts one or more entries for event registrations

texts:
I'm not sure that this is possible but here goes:
I have a requirement to collect data from Event Registrants of University Programs that they have undertaken and the years of study they have undertaken. This is not limited to a single entry for the program and each program entry can have 1 or more years of study.
So an Entry could look as follows:
Program of Study: Basket Weaving
Years of Study:

1972
1973
1974

Ideally I would want to have multiple fieldsets of the Program of Study and Years so the registrant could list one or more programs they undertook and the years they undertook for it.
In that case it would look like:
Program of Study: Basket Weaving
Years of Study:

1972
1973
1974

Program of Study: Advance Basket Weaving
Years of Study:

1982
1983
1984


texts: How to setup cron trigger in CiviRules extension

texts:
How can i set the trigger event to be a daily cron on memberships?

Goal is to check all memberships that has status pending for more than 40 days, if yes then change status to expired. I understand it would be a custom condition and action.


texts:
We run CiviCRM 5.20.2 on Joomla 3.9.15

We use Reports - Donation Reports - Sybunt
We need to be able to select in the Columns area:
•   Nickname
•   Do not mail / contact
•   Deceased
•   Postal Greeting

Is a custom report necessary? If so how do I use the SYBUNT report as a template to copy?

Thank you!


texts: cronjob not working - "could not open input file"

texts:
With CiviCRM 4.6.10 and Joomla 3.3.3, I have been unable to get a simple cronjob to process. I just want to run the enabled scheduled jobs every day. In Siteground cPanel, I have setup the following cronjob -
/usr/local/php53/bin/php-cli /home/ashguild/public_html/home/administrator/components/com_civicrm/civicrm/bin/cron.php?name=username\&pass=password\&key=key

I am getting "Could not open input file: /home/ashguild/public_html/home/administrator/components/com_civicrm/civicrm/bin/cron.php?name=username&pass=password&key=key

I don't know what to try next. Any assistance would be appreciated. Thank you.


texts:
I'm relatively new to CiviCRM so this might sound like a question with an obvious answer.

I have set up my cron for my drupal CiviCRM site with easycron.com and have found that it always reports back the same error:

Could not load the settings file at: /home/content/06/10588406/html/sites/all/modules/civicrm/../../../default/civicrm.settings.php

Now, I have gone through and verified that I have followed the instructions (I even created a new site with absolutely no purpose other than to test this issue with civicrm) and it come up with this error too. All of the requirements are met, permissions checked, everything...

So what can I do to change this? Is there anything I can hardcode into the civicrm config file? Or does anyone know where I might find the directory that it's currently looking in to paste a copy of the civicrm settings file (currently located in /sites/default) into it?

Thank you!

Matt


texts: Notify when profile form is submitted does not work (form with attached files)

texts:
I have created an application form in CiviCampaign through Petitions.

Everything has been set up fine, except that even after adding one or several emails in Administer > Customize Data and Screens > Profiles and click "Settings" on the profile created for this form in the Advanced Settings section "Notify when profile form is submitted" nothing ever happens when a form is submitted.

This is particularly important because we are requesting that two files are attached before submitting and we can't get access to them through civicrm backoffice. I was expecting they would be sent in the notification email.

We are using CiviCRM in Joomla, so this was the only solution I found to create an application form, without using CiviContribute, which does not apply to what we need. When we use CiviContribute the email notification works fine.

Help would be greatly appreciated.


texts: Not sure what happened. The image below shows a blank page when I open Address Settings from the Localization menu.


texts: Where is the developer documentation for making core CiviCRM database changes, to the schema and to the initial data?

texts:
I'm working on a (newer) PR for CRM-19751, which requires some database schema changes and addition of an option group with its options. Obviously I knew something about this when I created the original PR last year, but now can't seem to find documentation for such things as

How to get these code changes to actually perform the schema changes in my dev environment;
How to test (even manually, or else by some better method) that the upgrade script will work correctly;
The various directories/files in which I should be sure to make the changes (e.g., the appropriate DAO, xml/templates/civicrm_data.tpl, what else?)

So this question is not really to get an answer to the above points (though that would be helpful); rather it's to find out where this stuff is documented, or else where's the best place to ask someone about it?


texts: WordPress installation with MySql connection problem

texts:
I've been trying to install the lastest version, 5.9.1, on a new WordPress 5.0.3 site. Requirement checks all passed but when I clicked "Check Requirements and Install CiviCRM" button I got this error:

Cannot open mysql://username:password@localhost:3306/database_name?new_link=true: DB Error: connect failed

Server is using PHP 7.0.27.

Can anyone point me to the right path?

Thanks so much!


texts: Send different event confirmation emails

texts: I have setup 2 different events. I would like to send different confirmation emails for the events with the relevant information. This hasn't been an issue before because I have only ever ran 1 event at a time and have edited the Events - Registration Confirmation message template with the relevant information.


texts: Newsletter signup - add straight to group

texts:
Hello and excuse me I am having a moment. I usually use HTML snippets (profiles) for newsletter sign up forms but have used webform on this occasion as I read you can't add recaptcha to a snippet.

However now I realise having set up the form and themed it that it doesn't automatically add to a civi group.

Can I add contacts directly to a civi group from a webform sign up form?

Thanks it's probably obvious but I can't see it.


texts:
I'm in need of inserting a control query into a hook post to retrieve if there is duplicate data.

I am using a php query but the only reaction I have is that it continues to compute forever, is it possible that there are strings of CIVI seasoning more suitable for this task?

$check = mysql_query("SELECT * FROM table WHERE code = '$invoicenum'");
    $checkrows = mysql_num_rows($check);

   if ($checkrows > 0) {
WARNING
   }
   else {
OK CONTINUE CHANGE
}

Regards


texts:
What is the default data encoded in the Bar Code / QR Code?

Is it possible to modify this data to use for event check in? i.e. on quick scan event participant status changes from registered to attended.


texts: Fatal error: Class 'DB_DataObject' not found in /sites/all/modules/civicrm/CRM/Core/DAO.php on line 49

texts:
After upgrading to 5.13.4 all of Civi has disappeared to be replaced with the error

  Fatal error: Class 'DB_DataObject' not found in /var/sites/c/[site]/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php on line 49

I first noticed it trying to visit /civicrm/upgrade?reset=1 after uploading all the updated files, but it appears trying to load any part of CiviCRM. Drupal (7.67) still loads fine, though it's still in maintenance mode at the moment.

And ideas what's gone wrong?


texts:
I have an org that has split into two. They already were working with two payment processors -> we're all sorted out - contacts and contributions have been migrated over into the spin-off CiviCRM database.

What we can't do is permanently delete the Contacts that have been moved into the spin-off CiviCRM database, because "This contact(s) can not be permanently deleted because the contact record is linked to one or more live financial transactions. Deleting this contact would result in the loss of financial data".

And that's ok with us as we've got all that into their spin-off CiviCRM database now. In fact right now we have double the monies. Is there any way around this - via the GUI?


texts: "The directory sites/default/files exists but is not writable and could not be made writable." How can I fix this?

texts:
I'm on Drupal 7 and attempting to upgrade to Civi 5.25.

I followed the steps here to upgrade and now I'm getting this error when attempting to log in as a user on the front end:

"The website encountered an unexpected error. Please try again later."

which I think is caused by this:

"The directory sites/default/files exists but is not writable and could not be made writable."

which I can see in Drupal, which I can get to. I can get to the command line via SSH to modify my settings.

I had to sudo at the command line to do these commands:

"Ensure that your Drupal files directory is writeable by the webserver.

$ cd /sites/default/files

$ chown -R www-data: .

$ find . -type d -exec chmod 0755 {} \;

$ find . -type f -exec chmod 0644 {} \;

$ chmod -R u+rw ."

So I hope and think the fix is a simple one, at the command line. Any help appreciated!


texts: mailchimp extension error, php 7.1, civi 5.10.4, drupal 7.x

texts:
with civi 5.10.4, Drupal 7.x and php 7.1 there is a warning that in some cases turns into a fatal error that will prevent the webhooks from working

Declaration of CRM_Mailchimp_Permission::check($permissions) should be compatible with CRM_Core_Permission::check($permissions, $contactId = NULL) in /path/to/uk.co.vedaconsulting.mailchimp-2.0.1/CRM/Mailchimp/Permission.php

CiviVolunteer had a similar issue, following the example in that fix I was able to get mailchimp extension working. https://github.com/civicrm/org.civicrm.volunteer/pull/477/files

I'll submit a pull request soon but in the meantime if anyone is having the same issue the fix is

remove:    class CRM_Mailchimp_Permission extends CRM_Core_Permission {

add:    class CRM_Mailchimp_Permission {

and

remove:    return parent::check($permissions);

add:    return CRM_Core_Permission::check($permissions,NULL);

if interested, issue in the extension's github is https://github.com/veda-consulting/uk.co.vedaconsulting.mailchimp/issues/319


texts: new to Civi CRM and really need help with setting up / customising. Anyone here that does that as volunteer for charity or paid ? looked on peopleperhour and cannot find


texts:
I have set up a webform to take event registrations. A user can click through to the payment form without selecting an event and can click submit. This doesn't register them for the event, but I would like to stop this. Due to the way I have setup the form I cannot use required fields on event selection. The webform is pretty complex.

Ideally, I would remove the submit button on the payment page unless the amount is greater than $0. Is this possible?


texts: Send mail when my grant status has been changed

texts:
I am try to send mail when grant status has been changed. For this I am using CiviRules . I create a rule Trigger(Grant is changed). Then I try to add my status condtion but not find it. Can anyone suggest me what I am doing wrong.

Thanks


texts: Custom filed that will auto calculate a position number based on date

texts: We manage a wait list for membership so I would like to know if there is a way to calculate a number for a custom filed that would be based on if a member is a subtype and then the date in another custom filed.   So that we would have a position number every time we entered a contact to the subtype waitlist.  and would recalculate all the numbers after a contact was removed from the waitlist subtype


texts: How to create custom opt-in email for webforms

texts:
I've seen the option to double opt-in (send a confirmation email) when choosing a public group in webform, but I'd like to be able to:

customise the confirmation email sent
have a double opt-in for private emails

Is there a way to do that in webform civi?
I tried to find a checksum token to be used in a custom email, does it exist?

Alternatively, is there a webform specific confirmation page that I could use? eg. https://www.drupal.org/project/webform_confirm_email


texts: Editing a submission on Drupal Webform - not updating CiviCRM

texts:
I've got a webform that creates a Case and two Contact Records (one of whom is logged in as authenticated user). I want to allow the user the ability to edit the webform.

I've tried two options:

Encouraging them to use this page: mysite.org/node/1/submissions

However, any changes they make are only saved in the webform, and CiviCRM Case info is not updated.

Providing a link < a href="https://mysite.org/amend-individual-grant-application/?cid=[contact_id_b_]&caseid=[id]">View submission

This is slightly odd - it prefills the information, but conditions don't appear to work (e.g. fields are hidden when they should be shown) and I have the same problem as option 1.

I wondered if it's a permissions issue - I gave permission to edit all contacts (since there is more than one contact involved) but there's no equivalent for Cases (only 'access my cases/all cases', which is not quite the same thing).

Any ideas why the information is not saving in CiviCRM?


texts:
I've got a civicrm database of 1.4 Go (information available in PhpMyAdmin)
1Go is used by civicrm_activity table
I would like to know if have to clean, purge the database to reduce its size, cache or others maintenance actions.

I find some actions on documentation for cache files but nothing about database

Thanks for advices


texts: Nationalities extension with dual citizenship

texts:
I installed the Nationalities extension and it works fine. However, there are some contacts that have dual citizenship. I was wondering if somebody has already implemented this or have ideas how to do it?

thanks!


texts: How can I create a checkbox for filtering contacts in report?

texts:
I'd like to filter out specific contacts from a (contribution) report, based on a manually enabled or disabled custom field. By default everyone should be included in the report, but if the checkbox is enabled (e.g.), the contact should be skipped from being listed in the report. I already have thousands of contacts for whom I need to have the default inclusion.
I experience a problem that CiviCRM is behaving differently in cases when
(a) there IS NOT a specific value in the custom field;
(b) there is no value (null) in the custom field.
FILTERING
If I create a new custom field with a CheckBox.

And filter contribution report by contacts where checkbox is enabled, the report returns 63 results (instead of hundreds).

If I filter by contacts where checkbox is disabled, the report returns 0 results.
The majority of results are not returned in either scenario - whether I filter by checkbox ON or OFF.
I'd guess it must be some third value - null or not enabled.

Interestingly, these 63 results are still returned although I have just created a fresh custom field. Why are not the others?
Anyhow, how can I include everyone in the report, except for manually selected few?


texts: How to edit php so civicrm can find the extensions

texts:
neither  - for the directories

/home/mysite/public_html/wp-content/plugins/files/civicrm/custom_ext

nor - for the resources

/http://www.mysite.org/wp-content/plugins/files/civicrm/custom_ext

works as an entry to find the extensions - everything is 775 permissions

Is anything in the path incorrect?

oddly, if I only use /home/mysite/public_html/ and /http://www.mysite.org/ civicrm picks up a zip file for another web app and displays this ridiculously long path to get to the file - in case you are interested it's

- Local Path = /home/mysite/public_html/qdpm/core/lib/vendor/symfony/test/unit/plugin/fixtures/http/pear.example.com/REST/p/sffooplugin

How it can find and interpret this as and extension and not the recommended path I don't know.  Does anyone?

I have searched the forum and not found anything that worked.  Not sure why this is so difficult to setup.  I have many web apps that just create the directories you need and you are done.

Anyway, do I need to edit directories.php etc. to make this Extensions show up as they should.  This is a deal breaker since there is no ad hoc reporting and I am hoping a report extension will give us what we need.  Otherwise Civicrm is useless for us.

Thx


texts: Is it possible to include HTML in a petition introduction?

texts:
When I include HTML formatting in a petition "Introduction" field, it passes through to the front end petition view as displayed text, rather than being interpreted as formatting instructions.  This happens in:

4.6.8 with textarea editing
4.7.1 with ckeditor or textarea

Am I missing something?  Or is this just not a supported feature?


texts: How do I configure the new recurring contribution feature in Webform CiviCRM module?

texts:
The current -dev version of webform_civicrm module includes a first pass at adding recurring contribution functionality. This seems like a good place to post some examples of how it can be used.

Following existing logic in webform_civicrm creation of the recurring series uses the CiviCRM APIs. There is no additional code specific to Contributions, Events, or Membership.

Below please find:
Example 1: Give user option to pay for Event Registration either right now - or in monthly installments


texts: What is the server IP in database trigger definitions?

texts:
We just did a MySQL server migration. I completely cleared out all the triggers and executed

  https://test.sdcbcdream.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/menu/rebuild&reset=1&triggerRebuild=1

This rebuilt the triggers. When I examine them, though, they all have for the definer field

  sdcbc@173.236.128.0/255.255.128.0

The IP for the new MySQL server is 208.97.161.77. Where is the rebuild trigger function getting the other IP? I believe that was the old IP, but am unsure as that server has been decommission by our host service.

We are running CiviCRM 5.10.3 on WordPress 5.1

Thanks for any help


texts:
With case activities, the Activity Create API seems to create a new revision of the activity. Is there a way of using the API to update a case activity without adding a new revision?

My code currently looks like this:

   foreach ($acts as $act) {
     $result = civicrm_api3('Activity', 'create', [
      'return' => ["contact_id", "subject"],
      'id' => $act['id'],
          'custom_114' => $var1,
          'custom_115' => $var2,
     ]);
   }

I just want to overwrite the contents of custom_114 and custom_115 in each existing activity record, but it seems to create a new revision of each activity, containing the updated values.

API v3
CiviCRM v. 5.10.4
Joomla


texts: How can I automatically advance to the next member of a filtered group upon webform submission?

texts:
I've created a webform for a phone caller to use when calling members of a Civi Group who have already signed a card, to sign the Group members up for follow up activities.

Once the phone caller completes the call, and submits the form, I want a new form to populate with the name of the next Group member to be called.

The "target" contact is an Existing Contact, I have the Form Widget set to Static, under Default Value I have Set default contact from Auto - From Filters, and under Filters I've chosen only the relevant Group.

But the first name in the Group reappears upon Submit.


texts:
In my installation I firstly recognized database errors like described in CiviCRM issue CRM-19109: Draft mailings are not saved. In a fresh local installation (Ubuntu 16.04LTS, php 5.6, mysql 5.7.13, Drupal 7.50) even more database errors came up.

Digging into the MySQL database showed error messages like:

SELECT  id, component_type
FROM    civicrm_mailing_component
WHERE   is_active = 1
AND     is_default = 1
GROUP BY component_type LIMIT 0, 25

MySQL said:

  #1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'database_civicrm7.civicrm_mailing_component.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

I found that since MySQL 5.7.5 the default value for "sql_mode" is "ONLY_FULL_GROUP_BY" and this causes the problems with CiviCRM database and CiviCRM SQL queries.

In my local installation I added in /etc/mysql/mysql.conf.d/mysqld.cnf/mysqld.cnf

[mysqld]
sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"

… no more problems so far.

The issue is addressed here:

CRM-18439: support MySQL 5.7 sql_mode=only_full_group_by


texts: Email Redirect to Database setting for civicrm-settings.php?

texts:
ola, i just stumbled upon the https://github.com/ixiam/com.ixiam.modules.mailreader extension and would love to use it on our dev/stage environment.

It enables a ui to read email that were redirected to the database. now my question is: is it possible to enable DB email redirect with a line of code in civicrm.settings.php?

When copying production databases to dev & stage it would be great to be able to override the mail setting to redirect to the database.

So far I only found
define('CIVICRM_MAIL_LOG', 1); and
define('CIVICRM_MAIL_LOG', '/dev/null');
as available settings in https://docs.civicrm.org/dev/en/latest/tools/debugging/


texts: Add Membership Token to PDF Template Joomla

texts:
I have been banging my head on this for a few days.  I created a PDF Template for our members so I can run a search of members in Expired or Grace, then PDF a letter reminding them to pay their membership.  I see the tokens for contacts, however cannot figure out how to add a token for Membership Type.  Any suggestions

Joomla 3.4.1 CiviCrm 4.6.0


texts: My organisation uses a few fairly standard fonts that aren't available in Civi, for mailing labels and letters and auto-response emails etc. - how can they be added?


texts:
I'd like to collect some feedback from people when they unsubscribe from our mailing lists, but it seems that civiCRM doesn't have a way for me to access the unsubscribe page to add additional custom fields.
Ideally, I'd just like to ask a question like: "Can you tell us more about why you are unsubscribing?" And then display a custom field with either a text box or a radio list of reasons.
Is there a way to do this?
I'm running civi 5.31.0 and Joomla 3.9.23


texts: Feature request: Make Checksum tokens easier to use

texts:
Checksum tokens are arguably one of the coolest yet most overlooked features of CiviCRM.  It allows you to send targeted emails for donations, membership and event registration in a way that

increased user response/convenience because the form is pre-filled
preserves your data by reducing duplicates (when the same person enters another email and/or name)

But checksum is tricky to use, not obvious to the end user, and easily forgotten by users who know about it.  Let's make it more visible and easier.

Here are instructions I recently gave to a client who has been using CiviCRM for 9 years, and struggles to understand or use Checksum.

  Note: You can use a token to auto-fill their info on event forms! Where 'XXX' is the id# of the event, copy-paste this registration link.

  https://myorg.org/civicrm/event/register?reset=1&id=XXX&{contact.checksum}&cid={contact.contact_id}

  Highlight text such as "Register Now", click the Link icon, and paste in the above link, after replacing XXX with the real ID#.

Wow, right?  That's a lot to wrap your head around if you're a non-techie, isn't it?

Idea: when entering a link that links to your own CiviCRM (base_url) that is a registration page, contribution page, or profile, popup a "Would you like to tokenize this link?" dialogue.  It then adds the token without the copy paste.


texts: How to alter and manipulate the behavior and action of button through extension?

texts:
I want to alter and manipulate the behavior and action of continue button on new contribution page through extension, I want to do some additional tasks with that button through my extension like sending email etc.

What is the best way to accomplish this task?


texts: Is there a limit to the number of fields that can be included in a profile?

texts:
The organisation I work with is successfully using CiviCRM (with Joomla) for online event registration. However it seems as if there is a limit of 20 fields in the regaistration profile we use.

Twenty fields are easily used with name, address sex, dietary needs and other questions. Has anyone else hit a field limit and how did you overcome it?

thank you.


texts: Best practices for translating message templates

texts:
As the message templates are quite complex, especially the system-flow templates, with their Smarty templating structures, and they sometimes are updated, you would rather not edit them.
But if you have users using other languages than English it is almost essential to translate them.
Is there any best practice to manage this? Jon G suggested using a Smarty-enabled editor which is at least one step towards not messing them up. But it doesn't resolve the issue with diffing against the system version when all the text in them has changed to another language...


texts: Permanently Deleted Contact Records Keep Reappearing

texts: We are using CiviCRM with wordpress and we're trying to do a data cleanse to remove any out of date and spam contacts. None of the records we're trying to delete have financial data attached. We deleted over 500 records in batches using the permanently delete function and with each deletion the message appeared saying these records have been permanently deleted. At the time of deletion the total number of records reflected that these records had been deleted but the next day these records all reappear. Can anyone tell me how to resolve this please?


texts: Why does PHP Contribution API not filter on contact_id in 4.6.2?

texts:
We recentely upgrade from 4.5.x to 4.6.2 and after that the following API call from PHP does not filter on contact_id and return all contributions for all contacts.

$params = array(
    'contact_id' => $contact_id,
);
$api->Contribution->Get($params);

In the backend explorer, the follow error occurs:

{
    "is_error": 1,
    "error_message": "A fatal error was triggered: CiviCRM is not of the type Int"
}

Good ideas very welcome :)


texts:
I'm using headless phpunit tests. I noticed that the first time I do this it pauses and says about installing schema for xxxx - a test database.

If you break stuff enough, you can end up with a corrupted/no-good test CRM database. How do you get a fresh one back?

I tried dropping the test database, but that just caused errors.

Thanks.


texts:
I am having the below PHP class file. How do I create a TestCase or TestClass for this

<?php

class CRM_History_Page_HistoryPage extends CRM_Core_Page {

  public function run() {
    // Get User name from the contact id
    $query="select display_name from civicrm_contact where id={$_GET['cid']}";
    $dao = CRM_Core_DAO::executeQuery($query);
    $dao->fetch();
    $username=$dao->display_name;
    CRM_Utils_System::setTitle(ts("$username - Membership Periods"));

    $this->assign('periods',$this->getMembershipPeriod($_GET['membership_id']));
    parent::run();
  }
  public function getMembershipPeriod($membership_id) {

    $query="SELECT pr.start_date,pr.end_date, p.contribution_id,p.membership_id
        FROM civicrm_membershipperiod pr
        INNER JOIN civicrm_membership_payment p ON pr.membership_id= p.membership_id
        where p.membership_id=$membership_id";

 $query="SELECT pr.start_date,pr.end_date
        FROM civicrm_membershipperiod pr
        where pr.membership_id=$membership_id";

    $dao = CRM_Core_DAO::executeQuery($query);
    $i=0;$cid=$_GET['cid'];
    $validation_array=array();
    while ($dao->fetch()) {
      $data=[];
      $data['sno']=++$i;
      $data['start_date']=$dao->start_date;
      $data['end_date']=$dao->end_date;

//      $link="Deatails";

      $membership[]=$data;
  }

    return $membership;
  }
}

I have wrote a test class as below

<?php

use Civi\Test\HeadlessInterface;
use Civi\Test\HookInterface;
use Civi\Test\TransactionalInterface;

#use PHPUnit\Framework\TestCase;

/**
 * @covers Email
 */
class CRM_History_Page_HistoryPageTest extends \PHPUnit_Framework_TestCase
{
    public function testCanBeCreatedFromRun()
    {
        $this->assertInstanceOf(
            CRM_History_Page_HistoryPage::class,
            CRM_History_Page_HistoryPage::run(111)
        );
    }
}

But it gives the below error

root@mani-Lenovo-G560:/opt/lampp/htdocs/drupal/sites/all/modules/civicrm/membership.history# phpunit4 --bootstrap CRM/History/Page/HistoryPage.php tests/phpunit/CRM/History/TestClass.php

Fatal error: Class 'CRM_Core_Page' not found in /opt/lampp/htdocs/drupal/sites/all/modules/civicrm/membership.history/CRM/History/Page/HistoryPage.php on line 3
root@mani-Lenovo-G560:/opt/lampp/htdocs/drupal/sites/all/modules/civicrm/membership.history#

Is there any dependency files missing


texts: Setting Up CiviEvent to Manage Two Side by Side Events with the Option of Registering for Both

texts:
What might be the best way to set up CiviEvent that can register attendees for two events, with one that is directly before the other event, as well as having the option where people can register for both at a discount?

I haven't used CiviEvent before, and from reading the documentation wasn't sure of the best approach. I thought there may be three ways of doing it:

Set up three distinct events in CiviEvent. One for each individual event and one for both.
Set up two individual events where each has an option in the pricing to include the other event.
Set up one "parent" event that includes pricing options to go to either both or one of the "child events"

In option 1, having three events may be problamatic as there would be two attendance lists for each event.

It seems that the second option might be easier but then I don't know how it would handle registration for the second event, as the person registering for one event would only appear on that individual event registration list.

For the third option, I'm not sure how the registrations would work for working out who was going to which child event. Would this be using Smart Groups? And I could forsee difficulties setting up automated responses depending on which child event had been selected.

Any guidance much appreciated! (I am using Drupal 7.60 with CiviCRM)


texts: Edit link in directory results not displaying

texts:
I am working on a front end directory. I have created the profile and checked the box to "Include profile edit links in search results? " in the profile settings.

When I go to the directory page (as logged in user) and find my contact the "edit" link is not there in the search results. The account I am logged in as in an Admin account so it is my understanding the "edit" link should be there for all contacts.

I feel like I am missing something simple.

We are running Civi 4.6.25 with WordPress 4.7.2


texts: Establishing Group Based Permissions to Limit Display of Content to Logged In User

texts:
I have a Drupal / Civi application running which uses ACL to restrict contact data to the Drupal user whom is a member of the Group (the Group Admin).

Currently I have 5 Groups. However, each Group Admin is able to see administrative content of all other Groups.

I'm struggling to understand permissions and restricting the administrative contents of one group from another group.

Group contacts are properly restricted. However, even in Search > Find Contacts all Group Admins are able to see all other Groups in the Group Drop Down Selector. Search results produce no contacts, however Group Admin 1 should not be able to view Group 2 in the selector.

For another Example Mailings > Message Templates shows the templates for all groups to all users. The requirement is to limit the display of templates to those CREATED by the Group Admin whom is also a Drupal Logged In User.

What is needed is a permission Like View / Edit / Delete Own Templates

Similarly, Campaigns > Dashboard > Campaigns will show all campaigns to all users. The requirement is to limit the display of campaigns to those CREATED by the Group Admin whom is also the Drupal Logged In User.

View / Edit / Delete own Campaigns

There are other locations where permissions need to be managed but they are in the same context.

Is it recommended to do this with menu based permissions? What other approach should be considered? Any extensions that will help?


texts: Getting Drupal error messages with Silent User Registration extension

texts:
Drupal 7.72
Civi 5.28.2
Silent User 1.0
I just installed the extension and setup the CiviRule per the pics on GitHub. My CiviRule trigger is a new contact created with condition of "these" sources (sources are webform civi integration forms that we use for contributions).
When I make a contribution as a new user, I get 2 Drupal error messages
The contribution does process in Civi and it does include a Name and Email. But a user is not created in Drupal.
I added a 3 minute delay in the CiviRule and tested it with and without rechecking the condition. Now it does not show the Drupal errors as above but it still does not create a Drupal user.
In the Civilogs I see this (I assume it is related) [warning] Report Error Extension could not send since no email address was set.
In the Drupal Logs, I had the following
Notice: Undefined index: template_id in CRM_Emailapi_CivirulesAction_Send->userFriendlyConditionParams() (line 122 of /sites/default/files/civicrm/extensions/org.civicoop.emailapi/CRM/Emailapi/CivirulesAction/Send.php).
But I no longer get the log errors since I added the delay.