texts: CiviMail not delivering to certain mail servers eg. wp.pl

texts:
CiviMail fails to deliver some emails to specific domain servers: @wp.pl. Each time I send a mailing I receive a bounce message which reads like this:

This is the mail system at host stpuk-org.nazwa.pl.

I'm sorry to have to inform you that your message could not
be delivered to one or more recipients. It's attached below.

For further assistance, please send mail to postmaster.

If you do so, please include this problem report. You can
delete your own text from the attached returned message.

The mail system

<xxx@wp.pl>: host mx.wp.pl[212.77.101.4] said: 550 SPF Error:  Senders are
    required to provide correct SPF records. If you are
    a poczta.wp.pl user check SMTP configuration:
    http://poczta.wp.pl/autoryzacja/ (in reply to MAIL FROM command)

Final-Recipient: rfc822; xxx@wp.pl
Original-Recipient: rfc822;xxx@wp.pl
Action: failed
Status: 5.0.0
Remote-MTA: dns; mx.wp.pl
Diagnostic-Code: smtp; 550 SPF Error: Senders are required to provide
correct SPF records. If you are a poczta.wp.pl user check SMTP
configuration: http://poczta.wp.pl/autoryzacja/

The original message header is:

Return-Path: <bounces.stp+b.215.1467.3d8a9854510a5876@gmail.com>
Received: from mydomain.nazwa.pl (unknown [85.128.142.61])
    by stpuk-org.nazwa.pl (Postfix) with ESMTP id 2CE5F2411C0
    for <xxx@wp.pl>; Sun,  8 May 2016 23:28:11 +0200 (CEST)
To: <xxx@wp.pl>
Subject: =?utf-8?Q?=5BSzkic_CiviMail=5D_Og=C5=82oszenia_STP?=
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="=_7bef5881a1e24565cf35e4ad4b65e26c"
Reply-To: =?utf-8?Q?Stowarzyszenie_Technik=C3=B3w_Polskich?=
 <office@stpuk.org>
From: =?utf-8?Q?Stowarzyszenie_Technik=C3=B3w_Polskich?= <office@stpuk.org>
List-Unsubscribe: <mailto:bounces.stp+u.215.1467.3d8a9854510a5876@gmail.com>
job_id: 215
Precedence: bulk
X-CiviMail-Bounce: bounces.stp+b.215.1467.3d8a9854510a5876@gmail.com
Date: Sun, 08 May 2016 23:28:11 +0200
X-HTTP-Posting-URI: http://www.stpuk.org:80/civicrm/ajax/rest
X-HTTP-Client: 92.1.74.193
Message-Id: <20160508212811.2CE5F2411C0@stpuk-org.nazwa.pl>

I spent some time testing various approaches but without success. Few additional comments:

Civimail is successful delivered to main providers such as gmail, yahoo
For gmail I get a spf=softfail (txt below) but still delivers:

(google.com: domain of transitioning bounces.stp+b.197.1415.436c299ebc4d880a@gmail.com does not designate 85.128.169.253 as permitted sender) client-ip=85.128.169.253
My DNS configuration has spf: "v=spf1 ip4:85.128.169.253 ~all"
I use Google apps to handle my mail, hosting to handle website and CiviCRM and gmail for bounce processing

I believe I am missing something but I have no idea what.


texts: Civix: how to install and generate a skeletal extension (drupal)

texts:
I've installed civicrm on drupal site (on remote virtual hosting). And I need to create an extension for civicrm.
As far as I know, civix is required for that. I've read https://github.com/totten/civix/ but can't install civix. I've downloaded archive, extracted it and put to /sites/default/files/civicrm folder and it doesn't work.
So where I have to place civix? Something else is reqired? Some executables or any other things?

And the next question: how to generate module extension using that civix? I've read https://wiki.civicrm.org/confluence/display/CRMDOC/Create+a+Module+Extension#CreateaModuleExtension-Generateaskeletalextension - there are some things that I can't understand, for example "/var/www/extensions" - I have no such path in my civicrm.


texts: field like "Current Employer" that creates new organization and relationship

texts:
Is there a way to create in a new custom field the functionality in an Individuals "Current Employer" field?

For example, trying to create a generic "Organizational Affiliation"...

How to create the relationship between the Individual and this Organization?  And if the organization does not already exist then to create it on-the-fly?

Then this field could be added to profile for use contribution page for membership signup.

Edit: This is on Drupal.

Edit: This question turning into "How to create relationships between contacts on contribution pages?" I started out saying "in a new custom field" but new custom field isn't important and as @Coleman points out is bad idea.  But some sort of field that allows constituent to enter name of another contact they're related to and have the relationship get created upon form submission.


texts: Where should I put static files in my extension that are just used in certain few pages?

texts:
I need to use few static files(images, css) in one of my template. Currently I am using a CDN link to the same, but in practice storing the same within the extension will ensure the availability even if the links stop working.

Where should I put such files in my extension, should putting them in the template folder itself is the right practice?


texts:
I have Civicrm 4.7.20 installed on Wordpress 4.8.

When I create a new event or contribution the link that Civicrm creates does not work.
What Civicrm creates as a link:
http://[mysite]/?page=CiviCRM&q=civicrm/event/register&reset=1&id=7
This link loads my Civicrm base page, in this case my home page.  If I change the base page to a different page then that page is loaded.

This link works:
http://[mysite]/?page=CiviCRM&q=civicrm/event/info1&reset=1&id=7&page_id=1811

Note the &page_id=1811 parameter

As long as I specify the parameter &page_id=[any valid page] the link works, if I don't specify then the link loads the base page.

I tried disabling all other plugins and nothing changed so I think it has to be a Wordpress or Civicrm setting problem.


texts: How can I generate badges from an event report I created for conference registrants?


texts:
I was hoping someone could help me with this. I've been working on this for a couple of days and can't figure this out.

Basically, the payment method block is missing from Event online registration pages.  When I fill in payment information and submit, I get the the following message.

  Please correct the following errors in the form fields below:

Please select a Payment Method

The problem is there is no Payment Method block including the Pay Later in the Registration page even though the option is selected in the configuration.

There is no error in the Civicrm log. (ConfigAndLog)
And couldn't find anything applicable in /var/log/apache2/error.log.
Same for the Drupal Log.

Also, it does not appear to be a CSS issue as the block is just missing on the registration page according to firebug.

I did find this, but it didn't help much.
https://forum.civicrm.org/index.php?topic=35391.0

Any ideas?

I'm running Drupal 6.37 and CiviCRM 4.6.8. (I know. I know.  I need to upgrade to 7, but I've consistently run into upgrade issues with my custom theme and need to get them worked out)

Apparently we didn't have any paid events over the summer so the last one was in May 2015.  So it could have stopped working anywhere between then and now.


texts: Where can I edit the content of this field that contains the checkboxes of the mailing lists?

texts:
I'm a novice with civi. Please, where can I edit the content of this field that contains the checkboxes of the mailing lists? I need delete one, but I don't find where I can edit the field content.
 |||

Regards!!!


texts: Event registration's 'Continue' button disappears when Payment Processor is changed

texts:
I have an online registration with a donation-based registration fee (zero to any amount is accepted).

Everything works great until I change the Payment Processor of the event registration. When I change it, the continue button of the registration form disappears as long as there is no donation amount entered, which then does not allow the user to register without donating anything.

I've set up 2 completely identical events, besides their Payment Processor to demonstrate the issue:

The good one:
https://terranova.tamera.org/en/civicrm/event/register?reset=1&id=1945

The missing button one:
https://terranova.tamera.org/en/civicrm/event/register?reset=1&id=1946

Another thing to mention, is that the 2 Payment Processors are completely identical except for the PayPal's 'Pay' button image url, and their name.

My question is, what makes the continue button disappear in the 2nd one?


texts: The replacement token civicrm-user:one-time-login-url not working in Drupal Rules emails

texts:
With Drupal and Civi latest, is it possible to send an email with a one-time login url?

We have a scenario in which an admin grants a membership to a new contact. We want this new contact to automatically be given a new user account, and the correct role for their membership, and then send them an email giving them details about their new membership, as well as how to access their membership materials. (Their membership materials are on Drupal pages that are only visible to that membership's role).

So far we've succeeded in all of the above, using Drupal Rules.

However, to make their life easier I'd like to send them a one-time login so they can quickly make a password and get on with their life!

I'd prefer not to use the Drupal 'New Account' email for this purpose, since that has to be the same for all possible new users of the site. Also, we looked into not creating a user for them, and just sending them to the Drupal new user registration page. But that's clunky and these users are not internet savvy; they get lost.

In Drupal rules' 'Send HTML Email' action there is a token for the one-time user login: civicrm-user:one-time-login-url. However, it's not populated. And inspecting $civicrm_user via php print_r in the email shows no sign of this variable.

I did wonder if CiviRules could do all of the above, but I can't see any way to make a user from it, nor any token for a one-time user login - quite naturally since this would be a Drupal thing.

So... any ideas about how to progress this? I'm grateful for your thoughts.


texts:
Any MySQL Civi Gurus out there that know how I can create a query to return all custom value fields with their value per contact id?

I know how to get the occasional custom value, but i need the values not the key field numbers.

My problem is the custom values pick lists are all stored in the same table and so "1" maybe 5 different values and you have to pick the qualifier of each custom custom pick list so that throws off my SQL.

Thank you very much!


texts: Related contact saving issue with webform civicrm Drupal 7

texts:
I have a webform where I have fields for 2 contacts where:

Contact A: Individual (Autocomplete)
Contact B: Employer of Contact A (Static widget)

When I load the contact from url ?cid1=<cid> the contacts load fine and save as well but the issue is when I try to change the value in Contact A to another contact.
In above case the related contact (Contact B) loads fine but when submitting the webform, the saved value in submission is still the same contact that was loaded in the form as part of the initial form load (When you first visit the webform.
How it works

Go to the webform and see what values are loaded in contact A and contact B fields
Change value in contact A field and see the related value is changed in contact B field as well
Submit the webform and see submission, the values selected for contact B is not the one that was loaded in step 2 but instead the step 1 values is saved.

Technical Details
I noticed that $form_state['input'] has got correct values but $form_state['values'] only have the default values that were loaded with the webform instead of the ones that we changed.
Note This doesn't happen when the widget is autocomplete. But when you change the field widget to static for contact B, the above issue happens
Please can someone give me some pointers for the above?
Thanks!


texts:
I have been trying to connect CiviCRM and QuickBooks Online using the extension from Agilware. I have followed the instructions (I think) but can't get past the authorization. I have entered the production keys on the settings page, but when I click AUTHORIZE, I get the error message (from QuickBooks) "We're sorry! We're experiencing some problems. Please try again later."

Has anyone else encountered this issue? I found other people getting this message (while connecting other apps) and I wonder if my issue is the redirect URI, but it doesn't say anything about this in the instructions from Agilware. Any help is greatly appreciated.

Steve


texts: how to "petition" show using do_shortcode in template file in wordpress?

texts:
I want to show petition in page but using template file. Is it possible?

I have used below shortcode in template file but it not worked.

<?php echo do_shortcode('[civicrm component="petition" id="1" hijack="0"]');?>

Also I want to show another petition in popup but also there shortcode not working

See I want to default petition show in sidebar so i get default petition Id using custom query but i can't get petition with profile form using shortcode. Any other method to get petition using id. See below query for get default petition id.

$petition = civicrm_api3( 'Survey', 'getsingle', array(
            'sequential' => 1,
            'is_active' => 1,
            'is_public' => 1,
            'is_template' => 0,
            'options' => array(
                'limit' => 1,
                'sort' => 'id ASC',
                'offset' => CRM_Utils_Array::value( 'offset', $instance, 0 ),
            ),
            'is_default' => array( '1'),
        ) );

$petition_id= $petition['id']

Thanks In advance


texts: Membership status rule - restart at 'New'

texts:
I would like the membership status to revert back to 'New' if someone renews/rejoins once their existing membership is 'Expired' (rather than 'Current').

We're looking at CiviRules for this (likely with a custom action?) but thought I'd ask if anyone has a suggestion on a configuration option that may be more end user friendly that I just can't think of?

Thanks in advance,
Rebecca


texts: Can you prevent invoices from being sent via Pay Later?

texts:
I'm setting up a Contribution Page to act as a sales desk at a silent auction. An operator will use the page to enter people's details and the payment that they made for any items, along with a textarea for recording item details.

In order to keep everything in the system, I have renamed "Pay Later" as "Cash Sale". Then afterwards we'll go through and mark all those items as Completed, which will e-mail through the receipts. (while it would be nice to avoid this step it's only a small inconvenience)

The only problem with this solution is that as soon as we use the Pay Later mechanism, an invoice is e-mailed through to the buyer. This is unnecessary and will be confusing.

Is there any way to prevent invoices from being sent when we use the Pay Now for a particular Contribution page? Any settings that I have missed, or even hooks?

Note that I'm not keen on doing the data entry in the back end (CiviCRM console) as the operator would have to create new Contact records for each person before the sale, and overall that would be far more work.

Thanks,
Stephen


texts: Is it possible to access contribution tokens in hook_civicrm_tokenValues?

texts:
I’m trying to make a custom token to present grouped donations in a thank you letter in a friendlier format. If I use the ‘Group contribution by contact’ option the {contribution.total_amount} and {contribution.receive_date} tokens generate something like this:

Donation Amount $ 5.00, 10.00

Date of Donation September 14th, 2019, September 12th, 2019

I’ve setup hook functions to define a new token meant to display each donation and date on the same line, and to provide a total at the end of the list.  If I could access the donation tokens in my function for hook_civicrm_tokenValues I could easily re-arrange the data as desired.  But even though the $tokens parameter indicates that my template uses {contribution.total_amount} and {contribution.receive_date}, the $values parameter does not include the relevant contribution tokens, just contact tokens:

$values (as displayed by a temp debug token)
Array
(
[2] => Array
(
[contact_id] => 2
[display_name] => Don Alexander
[postal_greeting_id] => 1
[postal_greeting_display] => Dear Don
[postal_greeting_custom] =>
[address_id] => 1891
[street_address] => 1069 Steele Hollow Rd
[supplemental_address_1] =>
[city] => Spencer
[postal_code_suffix] => 8133
[postal_code] => 25276
[state_province_id] => 1047
[civicrm_value_spouse_tokens_7_id] => 1
[custom_16] => Mary
[custom_17] => Don Alexander, Mary Wildfire
[postal_greeting] => Dear Don
[state_province_name] => West Virginia
)
)

Is there any way to access/modify contribution tokens from within hook_civicrm_tokenValues?


texts: Can't see Note type custom field in reports

texts:
After setting up a custom data set "Member Details", I later added a new text area field called "Notes" to the set. My problem is that I find no way to get any membership report to show the Notes field. It isn't in the checkbox list of columns. I know the Notes field could potentially be a lot of text, but I don't care too much what it does to the report table. We have very short notes.

To see the Notes fields I must generate a report, click a contact, then click the Memberships tab, then click the View link on the right. So it's sort of cumbersome. I would like to be able to view a lot of notes at once in a report table format.


texts: What should be best practice when creating custom fields?

texts:
When creating custom fields, and custom field groups, I have fallen into two pit falls.

First, the name of a custom field should not exceed a certain length, causing malfunction in the SQL structure.

Second, values should be unique. Of course, you would say, but look at this example: values: 1,2,3,4,5,6,7,8,9,10,11,12.
When showing the values in a report, the 2 will show for both 2 and 12, and value 1 will show for 1,10,11 and 12.

The question is, what things should be considered when creating custom fields?


texts: How to email a link to a confidential document in Civi

texts: A client runs several night shelters for the homeless & uses Civi.  They want to email a 'daily activity' report to staff & volunteers - the content of which is confidential. All staff & volunteers have access to Civi. The report consists of information about who is duty manager, a list of guests with notes and some information about other local homeless accommodation - so much of it is fairly dynamic and could be in a message template, a Word document or spreadsheet. Because it's confidential we don't want to send the actual report in the email, because the receiver of the email would of course retain the email with the report in their account. To avoid this we want to just send an email with a link to the report that's somewhere in Civi. We tried Google Docs but ran into access problems.    Suggestions are very welcome on how this might be achieved in Civi, please!  We're using Drupal, Civi is at 5.19.3, open to using webforms & Views.


texts:
I'm a bit stumped on permissions.  I'm trying to create a user role that can

See and edit any user
See and edit custom fields for the user
NOT see or edit activities for any user
NOT see any financial information for any user

I tried this combination of settings:

CiviCRM: view all contacts : CHECKED
CiviCRM: view all activities : NOT CHECKED
CiviCRM: Delete activities : NOT CHECKED
CiviCRM: access CiviCRM backend and API : CHECKED
CiviCRM: access Contact Dashboard : CHECKED

This arrangement seems to allow the user to see all contacts but also all activities on all contacts.

If I remove "CiviCRM: view all contacts" then the user can see no contacts at all, and no activities.

I don't really understand why "view all contacts" gives access to see activities when the activity permissions are turned off.  That seems counterintuitive.

And I can't find a combination of permissions that allows a user to see/edit all users, but not see/edit any activities.

Suggestions?

(CiviCRM 5.8.2 on Drupal 7.  I'm aware a security update is needed to CiviCRM.)


texts: Menu does not appear unless in debugging mode in wordpress

texts:
I just freshly installed Wordpress and CiviCRM on my GoDaddy hosting. Installation appears to have worked fine.

When I go into CiviCRM however, the CiviCRM menu bar does not appear at the top but does appear at the bottom of the page half-obscured as text links in sort of a drop down fashion.

When I enable debugging mode, everything works fine...

Any ideas? Any help would be GREATLY appreciated.


texts:
I am creating a number of different contribution pages for membership levels and I find it confusing without being able to preview a contribution page to see if I have it configured correctly.
I am using CiviCRM in Joomla 3.6


texts: How to use civicrm to achieve campaign requirements

texts:
I'm looking at using CiviCRM as part of a solution for a campaign. what we need is a solution that aids volunteers to go into the field, speak to and collect data from voters ( we do not have adequate voter records here, so we have to build ours). We'll be collecting names, phone numbers, gender and asking a couple of questions. Volunteers are split into areas to collect the data.

Our phone bank solution will use the data collected to reach and talk to potential voters. Is there a way to also manage call centre volunteers using civicrm?

Can civicrm be used to manage the data collected? Can we manage volunteers (those collecting data and manning the phones) with it and track volunteer efficiency as we are paying them? What are the best ways to achieve this? We'll be using the wordpress framework


texts: Two events with configured PRICE - Price option is only showing on one

texts:
I have 2 similar Civi events setup on a drupal site.

Price tab is not using existing Price sets (for both) but customly added price options. Screenshots (in dutch, sorry) attached.

FIRST EVENT

SECOND EVENT

So for one event, the price options are printed on the registration form.
For the other, the price isn't printed.

I checked into /sites/all/modules/civicrm/templates/CRM/Price/Form/PriceSet.tpl

And for the second event, $priceSet is empty. This is why the price isn't printed.

I'm still clueless though as to why this could be.

Any suggestions are welcome :-)


texts:
I am on Siteground hosting services.  Everything is great except for civiMail.  The issue is their outbound service drops the majority of my bulk emails because I'm feeding their servers too fast.
Their restrictions are:

A single email should not have more than 80 recipients under the GoGeek plan.
You can send up to 800 emails per hour.
A single connection to the mail service should not trigger no more than 9 messages to be sent, trying to sent 10 or more will hit the limit.

I tried the throttling of email with a setting of 120000 msec, which I found somewhere but the wording is "single connection".  So this means I need to disconnect and reconnect to the mail server, send 9 more, disconnect... etc...  Is this even configurable in CiviMail?


texts:
Has anyone successfully used CiviCRM to manage sales opportunities?

I appreciate that this is more of a business feature.  However, charities and non-profits in the UK (and perhaps elsewhere?) increasingly find themselves working in a more businesslike manner.  For this reason some organisations need to be able to record and manage sales opportunities.  Has anyone successfully implemented this for an organisation using CiviCRM?  If so, how would you suggest doing this?

The type of functionality required is as follows:

record a potential piece of work as a sales opportunity
link this to an organisation (and/or individual contact)
attach a financial value to this opportunity (and ideally a probability of success)
have a set of predefined stages for an opportunity - i.e. the sales pipeline (initial contact, qualification, meeting, proposal, close)

It should also generate the following reports:

list of open sales opportunities to follow up
potential income (value of open leads x probability)
overview of sales won and lost (monthly/quarterly/annually)
etc.


texts: How To Restrict Payment Gateways/Options based on User Account or Membership Type?

texts:
Sometimes, certain individuals choose 'Pay Later' on our registration forms, and do not pay. We would like to 'flag' these individuals so the pay later option is automatically removed from the form.

Also, in general, it would be nice to show/hide payment gateways based on user ID, membership type, etc. like Drupal Commerce allows.

Is there any way to handle this in CiviCRM 4.7?


texts: CiviCRM seems to block PUT requests to Gravity Forms API

texts:
I am attempting to write a simple script that updates entries in Gravity Forms via their REST API.  GET requests to the API work successfully, but POSTs and PUTs (I have not tried DELETE) do not appear to be routed correctly.

Instead, I am getting what appears to be a CiviCRM error template, but not wrapped by the rest of the site HTML. (See below)

Disabling CiviCRM in wordpress gets my script working as designed.

I am running CiviCRM version 4.7 and Gravity Forms version 2.1.0.1

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

We can't load the requested web page. This page requires cookies to be enabled in your browser settings. Please check this setting and enable cookies (if they are not enabled). Then try again. If this error persists, contact the site administrator for assistance.&lt;br /&gt;&lt;br /&gt;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.&lt;br /&gt;&lt;br /&gt;Error type: Could not find a valid session key.

            Return to home page.

Is there a configuration change that I need to make?  Or is there some kind of known workaround?


texts: Missing participant is_test field in drupal views

texts:
We would like to use the participant is_test field in drupal views but cannot seem to do so.
1. Would anyone be able to tell us how we can do so?
or
2. Can anyone show us with an example that will help us create a pr to add this field.

Thanks, Richard


texts: If I have entered a contribution in duplicate, how can I delete one of them?  I do not know what to try before asking my question.


texts: How can I find an expert CiviCRM WordPress developer?

texts:
I want to hire a CiviCRM WordPress to perform various tasks in our Civi site. We have a list of needs, but the most pressing is the following. We have registration pages for our events. When you look at the registration pages on desktop, the form looks acceptable. But when you look at it on mobile, the form looks horrible and I can't image anyone filling out this form on mobile.

We need you to immediately step in and make whatever CSS or form tweaks are necessary to make the mobile view look good.

This is only one of several tasks that we need done. We are ultimately looking for continuous and long-term support.

Thank you,
Steven


texts: How to find CiviCRM version in SQL from a database backup

texts: I have a backup of a CiviCRM database from some time ago that I'd like to inspect inside a test site. When setting up the test site, I want to use the correct release version to match the version at the time the backup was made. How can I execute an SQL query on this orphan database to determine which version of the CiviCRM codebase its schema is compatible with?


texts:
In preview for my petition, the drop down state list is showing options, but when I go to the actual petition the state list says "non found"
I think a bug?
CiviCRM 5.3.0


texts: Add source to all contacts when importing a CSV File

texts:
Question in German

  Wir möchten eine CSV Datei mit Kontakten einer Gruppe hinzufügen. Dies ging auch mühelos.Das einzige das nicht funktioniert hat war diese neue Adressen die Bezugsquelle hinzu zu fügen.
  Wie geht das.

Translated

  We want to import a CSV file with contacts in a group. Well, we accompished this easily. The only thing we miss is that we add to this new addresses the source of the visitors. How can this be done?


texts: Is there a way to include OpenID as a drop down option in the contribution lis? or Is there a way to convert OpenID to external identifier?

texts:
When I imported contacts, I listed their identification number as OpenID. Now, I am trying up import the contacts' contributions. Along with their name, amount, date of donation, I am including their OpenID.....yet, the drop down options in the import contributions does not include OpenID...therefore, the import will not function.

a) Is there a way to include OpenID as a drop down option in the contribution list?
if not...
b) Is there a way to convert OpenID to external identifier?

Thank you!


texts:
I want to create a group of members that have paid their contribution last year, but not yet this year, and do not have an email address.

With an email address, the solution is simple: create two groups "paid last year" and "paid this year". Send an email via CiviMail to "last year" by excluding "this year". CiviMail only takes into account the contacts with email.

But how to do so with the ones without email? I do not see a way to "subtract" (= excluding members who paid this year) two groups outside CiviMail.

Or do I need to activate CiviMember for this purpose? Now, I enter the value of the year of payment into the field "Source of contribution" and, for the moment, we do not see the added value of another component CiviMember.


texts: "Error while sending QUERY packet. PID=975356 in wp-db.php on line 1877" for new install

texts:
I am (trying to be) a new CiviCRM user.  I've tried installing both 4.7.16 and 4.6.26 on clean installs of WordPress 4.7.2.

I end up with the following error when installing the plugin.

"Error while sending QUERY packet. PID=975356 in wp-db.php on line 1877"

I can then Activate the plugin, and then I Configure CiviCRM.

"Database version and connection settings have been verified and look correct!"
as follows:

CiviCRM Database Details

Does the server exist?  OK (localhost)
Are the access credentials correct? OK
MySQL version at least 5.1  OK (MySQL 5.6.33-log)
Is auto_increment_increment set to 1    OK
Is the provided database name valid?    OK
Does MySQL thread_stack meet minimum (192k) OK
Can I access/create the database?   OK (Database 'jointe6_wp278' exists)
Can I access/create InnoDB tables in the database?  OK
Can I create temporary tables in the database?  OK
Can I create lock tables in the database?   OK
Can I create triggers in the database?  OK

Requirements

PHP Configuration

PHP5 installed  OK (PHP version 5.5.38)
MySQL support   OK
JSON support    OK
Memory allocated (PHP config option 'memory_limit') OK (512M)
File permissions

Does the webserver know where files are stored? OK ({location}/wp-admin/)
Does the CiviCRM path contain PATH_SEPARATOR?   OK ({location}/wp-admin/)
Folder 'CRM' exists?    OK
Folder 'packages' exists?   OK
Folder 'templates' exists?  OK
Folder 'js' exists? OK
Folder 'api' exists?    OK
Folder 'i' exists?  OK
Folder 'sql' exists?    OK
Is the {location}/wp-content/uploads/civicrm folder writeable?  OK

I click Check and Install
It reports that it was successfully installed

But the page refreshes and I get the following error:

CiviCRM Home

System Status: Error
Cron Not Running
Timestamp Mismatch
Configure Default Mailbox
Complete Setup

At this point, anything I try to do only shows "System Status:Error"

Any suggestions?

TIA!


texts: Version 4.7.3: TCPDF package seems to be missing

texts:
I recently upgraded to vesion 4.7.3 (I'm running under Wordpress), and for some reason the TCPDF package was missing!

This led to the error: "Warning: opendir(/nhldata/631/106631/data/web/predigerforum/htdocs/wordpress/wp-content/plugins/civicrm/civicrm//packages/tcpdf/fonts/): failed to open dir: No such file or directory in /nhldata/631/106631/data/web/predigerforum/htdocs/wordpress/wp-content/plugins/civicrm/civicrm/vendor/tecnickcom/tcpdf/tcpdf.php on line 4148
TCPDF ERROR: Could not include font definition file: helvetica"

...when trying to create labels. I copied the directory "tcpdf" from the previous version into the packages directory and it seems to be OK now.

Perhaps there is a slip up in V 4.7.3, because I did nothing more than the normal upgrade process.


texts:
I scheduled a CiviMail but it hasn't gone out yet even though the scheduled time has past.  When I ask for a report it says:

Delivery has not yet begun for this mailing. If the scheduled delivery date and time is past, ask the system administrator or technical support contact for your site to verify that the automated mailer task ('cron job') is running - and how frequently.

How can I get the mailing to go out?


texts: Configuring cron using wp-cli on local server with Mamp Pro

texts:
I'm testing CiviCRM 4.7 in a WordPress 4.4.2 installation. I'm running this on a local server with Mac OSX 10.11.2 using MAMP Pro.

I'm trying to configure cron using the wp-cli method. I've installed, renamed and moved wp-cli and running wp --info in /Applications/MAMP/bin gives

PHP binary: /usr/bin/php
PHP version:    5.5.30
php.ini used:
WP-CLI root dir:    phar://wp-cli.phar
WP-CLI global config:
WP-CLI project config:
WP-CLI version: 0.22.0
Phils-MacBook-Air:bin phillip$

wp help shows the WordPress commands

I'm now trying to implement

/path/to/wp --user=<cron> --url=<http://example.com> --path=</path/to/wp> civicrm api job.execute auth=0

In my case I'm trying

/users/phillip/Sites/thetestsite.dev --user=<philnicholl> --url=<http://thetestsite.dev:8888> --path=</users/phillip/Sites/thetestsite.dev> civicrm api job.execute auth=0

but I get

-bash: philnicholl: No such file or directory

(philnicholl is my WordPress administrator username)

I know I'm missing something obvious.

I'm have experience with WordPress and Mamp Pro but am new to both CLI and CIVICRM. Any help would be much appreciated.

Thank you.


texts: Missing Activities tab when viewing contacts

texts:
When viewing a contact, there is no "Activities" tab in the list of tabs. Is this a configurable setting somewhere?

In other words, is there a way to add this tab to the Contact page?

Running CiviCRM 4.6.17


texts: Why would bounce processing put all emails into CiviCRM.ignore mailbox?

texts:
I did a first mailing and then got the bounce processing job working.  It just moved all the bounce responses (about 100) to the ignore mailbox and did not mark any of my contacts.  How do I tell what went wrong? There is no info in the log other than saying that it rand the job successfully.

Also I got emails of the form:
To: u.68.3087.7ed8aa555f763f19@californiacalvary.org
iOS Mail sent this email to unsubscribe from the message “One Week To Go!”.

Should these get processed?


texts: What options does CiviCRM provide for equipment management?

texts:
I am just starting to configure a CiviCRM implementation for my organization. As well as managing membership, we would also like to use it to manage equipment (boats being the top priority).

Option 1

It seems like there are a number of ways to go about this task. The first would be to create a contact type and add custom fields with boat information (manufacturer, age, size, etc.). Then, I could use the relationships functionality to assign ownership of the boat to a specific group. Then perhaps use the events or meetings to allocate to specific user(s) for some time?

Option 2

Another option could be the CiviBooking extension? Here I would create a resource like a meeting room. This seemed like the perfect solution until I started setting it up. It doesn't look like I can add custom fields to resources or ownership of a resource. It also has extra functionality like quantity and price that we don't care about.

The way we would like the handle resource management, whether it is boats, meeting rooms or anything else, would be to have a certain subset of contacts (administrators, board members, whatever), would be able schedule these resources and accept any payment if needed. Any old contact wouldn't have this permission.

Am I on the right track with either of my options or is there a better way entirely to do this?


texts: Test email does not match CiviMail WYSIWYG editor

texts: We are building complex emails with a multi-column template. The geometry of the mailing looks good in the WYSIWYG editor, but when you send a test email, it looks different. Does anybody hear the same concern from users?


texts:
I'am setting CiviCRM for a new customer and I'm wondering about how to reach my goal:
1 individual owns 1 or more companies that have/own 1 or more sub-entity (shop) knowing that the membership contribution will vary depending on the number of Companies owned and the number of Shops. There is not pre-defined pattern. You just can't have a Shop without having a Company. Only a company can get a membership.

I have set 3 profils with the necessary customs fields:
Owner (based on Contact)
Company (based on Organization)
Entity (based on Organization)

I have created the relationships between Owner (owns) and Company (is owned) and between Company (owns) an Entity (is owned).

I have created the 6 different prices set (which I am not sure to be the right way).

I have allowed in the contribution the owner to get membership on behalf of a company.

I don't find the way in a webform to create new company depending on the number of Companies.

I have read these posts: post 1,post 2 and post 3 and also the documentation:

I am a bit confused now and wonder if I am in the right direction?
Any thoughts?


texts:
How to link price set to already imported members ? So that when a member login, they can see their membership fee overdue

Jaisal


texts:
On a PC, I've downloaded a list into excel and saved it as a MS-DOS CSV file. When I go to Civi to import it, Civi says it's not saved as a CSV file.

I've followed the same steps I have for a dozen other contact lists.

What am I missing?


texts: When users are contributing a duplicate record is created in wordpress

texts: A member when contributing again is not linking to the member but creating a new profile even if name is different? can we have only unique email for member contribution?


texts: When Sending a Mailing the Reply-to email is different than the From Address

texts:
I sent out a mass mailing via CiviMail and the reply-to email is default+r{seemingingly_random_string}@gmail.com
I am using Sparkpost to send these mailings.
CiviCRM 5.29.1
Any idea why the reply-to email is this odd-looking email and not the same as the From address?


texts: Thousands Separator not Showing in Amounts on Contribution Page

texts:
The thousands separator is not showing in the amounts section on the contribution pages. These are the currency settings:

CiviCRM 5.29.1
Any idea how to make the thousands separator show up on the contribution page?


texts: WordPress w/ CiviCRM - Using Gutenberg in CiviMail

texts:
Small bit of background, I volunteered with a charity and helped implement a Drupal 7 / Civi install a few years ago. So I know enough to get around Civi before looking at any more recent changes.
I am a member of a non-profit organisation where a members website is needed. The user-base is such that I am thinking a WordPress / Civi build is more appropriate to make better use of Gutenberg. My question is, can you use Gutenberg as an editor for CiviMail?
I am just thinking about ease of use, compared to the users who would need to use it.


texts: Development on a plugin - How to transfer values

texts:
I have created a new plugin structure using civix.  It has created the elements I wanted in the database.

I have used dogregistry_civicrm_tabset to add a tab to my contacts pages.
I used civix to create a page with a php file and a tpl file.

The question I have is how do I transfer a value to the page php file?  I would like to send it contact ID so I can query the database for the entries for that contact but I'm not sure how to do that or whether it is stored already in a variable I can tap into?

Thanks for your help.
Norm


texts: How to create a better report template that includes CiviDiscount codes?

texts:
We are working in civiCRM 4.6.4 with Drupal 7.50.

Our goal is to have a report template where one can pull up a list of event participants (possibly for multiple events) who used a specific discount code and/or all participants who used a discount code for a specific event(s).

Some of our discount codes (automatic member discount etc) are used over the course of multiple events so the users list available from the civiDiscount admin page doesn't really accomplish this well for us.

A quick google search did not turn up an example report form for me to follow - nor do I see this in the 'extended reports' extension.

I see that the participant table seems to have discount_id and discount_amount columns, but when I inspect those columns in mysql I see all null and when I try a participant get with the API I get weird results when using those as parameters so maybe that won't work?

My next thought was to look at fee_level because participants seem to have the discount codes inserted into the fee level text. I thought I might add an additional participant_fee_level filter and title it 'discount code' with a 'like' operator to allow searching on discount code.

While this functionally works, I am wondering if there is a better solution as this one seems a bit rough. An example would be if someone wants to pull up all discount codes used for an event they need to know to fill the field with the value 'Discount' or '(', which pull up the same list. Also the 'starts with', 'ends with', '=', '!=', 'null', 'not null' options for the 'like' operator would not function as the user would expect.

Any thoughts on whether this is the best solution for now or there is a better (attainable) way to proceed are much appreciated!


texts:
I have a list of members that I'm importing from our old system. Since they have unique numeric member numbers, I'd like to preserve the original member number and not muddy the waters by making that an 'External ID'.

Using import memberships, the insert option doesn't allow me to assign member IDs. the update option fails because the member IDs don't exist.

Thoughts on how to preserve the original membership IDs? Or am I out of luck?

Keith


texts: Spark Hosting Integration with Existing Wordpress Site

texts: I have an existing Wordpress Site. I would like to know how do I integrate my Spark hoested site with my Wordpress site. The documen


texts: Invalid Date with Contribution API and Custom Date Field

texts:
Using the API, I try to create a contribution record.  One of my custom fields is a date field.  If I set the date to more than 20 years or so past the current date, I get the following error:

  [error_message] => custom_154 is not a valid date: 2038-01-19 08:00

If I lower this date by one month, even by one day, using the same format, it works fine.  One day past the 19th, it fails.

What's odd is that any date I put in, even 100 years out, works great on my dev box.  This is only happening on our production site.  And my dev box was a copy of production's DB and files (same Civi version, etc).  So I'm not sure what might be causing this.

I have modified the custom field and set the "Dates may be up to" to 100 years, but that doesn't help (tried other numbers as well, no use).

Is there some environmental or PHP setting that is causing this?


texts:
Is there a way to automatically create membership numbers for members?

There is the CiviCRM ID but this applies to all contacts, not just members.  I'm looking for a way to create a number that only applies to members.

This question was asked a few years ago on the forums (Membership number/code) but I wonder if there have been any developments since then.


texts: Safe to run cron jobs using wget and user with full admin rights?

texts:
I recently set up cron jobs with CiviCRM using wget url method through Cpanel.  I set up an administrator account and used that accounts username and password. My concern is if there is any security risk with this method and if its best practice to limit that user's account to just the bare civicrm permissions - "view all contacts", "access CiviCRM", "access CiviMail".

Your feedback is appreciated.

Using latest wordpress and civicrm releases.


texts:
I have setup Amazon SES to send email from CiviMail. All the stats except bounces are coming back into the system. For bounces I followed this helpful post here https://www.compucorp.co.uk/node/1740 but could not get it to work. Has anyone setup bounce processing with SES and what would the credentials be here. I am using a google apps email so I tried to enter the google account information but that did not work.

Name: Bounce Handling
Server: The IMAP server address of your email provider
Username: Bounce processing email address. e.g. bounce@example.com
Password: Password of the bounce processing email account
Localpart: Local-part of the bounce processing email address with a plus symbol. e.g. bounce+
Return-Path: Leave blank
Protocol: IMAP
Source: Leave blank if the email address is only used for bounce handling. If this email is also used for other purposes and have a filter for bounce notifications, fill in the label (folder) used for keep all bounce notifications. e.g. INBOX/CiviMail/Bounce
Use SSL: Normally Yes unless the email server does not require SSL.
Used For?: Bounce Processing


texts:
I try to change the role of a case.
 - Case coordinator (case manager) is manuel berger.
 - I click on reassign case coordinator
 - Enter a new name and click save

then the following error massage appears:
"The relationship type definition for the case role is not valid for the client and / or staff contact types. You can review and edit relationship types at Administer >> Option Lists >> Relationship Types.

Is there a solution to change?

Thanks.


texts: Does Drupal's read-only mode module work for Civicrm too?

texts:
Drupal 7 has a module, Read Only Mode, which allows your site to be viewed while in maintenance mode. No changes can take place to the database, but viewers can still see your site. This allows you to make your maintenance mode changes while not inconveniencing users who simply want to view your site.

Does this work with Civicrm as well? ie, does it prevent civicrm from changing its database while in maintenance mode?

We'd be very happy to be able to use Read Only Mode during Civicrm upgrades, which can take a while. Thanks for any thoughts!


texts: Organization details missing from membership online receipts for on behalf of function

texts:
Civi 4.7.26 and Civi 4.7.27, Drupal 7.56

We've run into an issue where the information from the on behalf of profile for organizations is not appearing in the online membership receipt sent to the constituent.  We've tested this both with a more complex profile (with some custom fields included) and with the basic on behalf of profile - same result for both.  There are no contact subtypes involved (there is a JIRA issue related to the on behalf of profile and fields for specific contact subtypes).  Has anyone else run across this issue?

Thanks in advance.


texts: Participant to my events cannot download the calendar on their Outlook

texts:
This is my trouble:

Participants to my event have completed the registration form, created with CiviCRM 4.4.7.

When they receive the confirmation email, they can also download clicking on Download iCalendar File. And it does not work. I tested it myself, trying to download it on Outlook and the link (this one http://events.esn-eu.org/civicrm/event/ical?reset=1&id=61) takes me to a page telling me the following message:

Access denied
 You are not authorized to access this page.

What can I do to solve the issue?
Thank you


texts: My custom reports work fine, but mail_report fails

texts:
All of my custom report mail_report jobs give this error, both through cron and when triggered manually:

  "Did not find valid instance to execute"

The report is defined as

class com_foo_bar extends CRM_Report_Form {

It is stored as an extension in

[civicrm.files]/ext/custom

For example, report 70 works fine in a webbrowser .. it is at

https://mydomain.com/bla/civicrm/report/instance/70

But the mail_report job log says

  Entity: Job Action: mail_report Summary Finished execution of yyy with result: Failure, Error message: Report Mail
  Triggered... Did not find valid instance to execute Details

  Parameters raw (from db settings):  instanceId=70 format=csv

  Parameters parsed (and passed to API method):
  a:3:{s:7:"version";i:3;s:10:"instanceId";s:2:"70";s:6:"format";s:3:"csv";}

  Full message:  Finished execution of yyy with
  result: Failure, Error message: Report Mail Triggered... Did not find
  valid instance to execute

The same happens when called from the command line. If job.mail_report is called on a regular report, it returns results. But if it is called on my custom reports, it returns

$ drush -u cron civicrm-api job.mail_report instanceId=70 format=csv sendmail=0
Report Mail Triggered...                                                                                [error]
Did not find valid instance to execute
Array
(
    [is_error] => 1
    [error_message] => Report Mail Triggered...
Did not find valid instance to execute
)

or

$ php bin/cli.php -s mydomain.com -u cron -p XXXXXX -e Job -a mail_report --instanceId=70 --format=csv --sendmail=0
Report Mail Triggered...
Did not find valid instance to execute
Died during callApi

Any ideas ?


texts:
It's possible to specify on a dedupe rule that 'Contact Subtype' must match. Is there any way of attaching specific values to that, for example, 'and they must both be Student'?

Some of this could be done by having, say, a group of students and a group of teachers, and choosing the students group when I run the rule. I only have this option when running it manually (Find and Merge)- what about for rules I want to be Supervised and Unsupervised?

In this case I want to deduplicate students against students (subject to the other conditions in the rule), but not students against teachers, or teachers against teachers. We are looking to run a survey of a large number of contacts and they tend to object if they receive it several times!


texts: Missing wordpress civivolunteer commendation table

texts:
We have wordpress 4.9.4 and civi volunteer 4.7.21-2.2.3

When someone makes a contribution or joins as a member, we get a missing table database error (from the error log):
Table 'vahcrm.civicrm_value_volunteer_commendation_7' doesn't exist

This error occurs after the transaction goes through and civi tries to update the database and the user gets the error:
Failed to update contribution in database

When we try to renew a membership, we get (from the error log):
Table 'vahcrm.civicrm_value_civivolunteer_5' doesn't exist

A little background....I'm a volunteer for a non-profit. The previous web/civi admin person moved everything to a new site, broke the site into a multi-site configuration without fully setting everything up, and then quit. I came to the civi problems having only heard the word civi before. I would appreciate ANY help I can get to figure this out.

How do I go about finding and fixing this problem?


texts: How to exclude multiple contact displays in Drupal view with contact-user relationship in CiviCRM multisite setting?

texts:
I need to create a Drupal view (CiviCRM contacts) displaying the staff of an organisation. The view has the relationship CiviCRM contact <-> Drupal user enabled. This seems to be required to be able to display the Drupal user images.

Now comes the tricky part: The Drupal site where the view is created is an offspring of a CiviCRM multi-site setup. This means staff members usually have a Drupal account for domain 1 (the central CiviCRM) and domain 2 (the multi-site offspring where the Drupal view lives). In the DB this means they have 2 records in civicrm_uf_match. Now if the relationship is enabled AND the user image field is included, the view displays those contacts twice. Removing the relationship results in losing the user images.

Any clues to a solution would be very welcome.


texts: Is it possible to return to the same contact summary page (ajax) once we have edited a contribution?

texts:
For example, when edit a one contribution in page 10 and save, return to page 10 and not to first page of contributions.

Thanks.


texts: Been searching high and low... best approach for dispaying member information in WordPress?

texts:
I'm working on a website that needs to display customized sets of membership information.

The kind of thing I’m going for:

CiviCRM custom fields indicate that member  serves in a particular
committee, and their role. Say, the Board of Directors.
On the WordPress site, the Board of Directors page lists a grid of    members, and their roles.
The site also shows those activities on a member’s profile page.

An example of the intended outcome: https://caims.ca/committee/executive/

I’ve been going through documentation to find a plausible approach, but I don’t see a clear path for the task as a whole. For each sub-task, there seem to be lots of possibilities, but no glowingly correct approach.

I’ve come across these possible steps, and possible tools:

Gathering “sets” of users (e.g., members who who are currently on the organization’s board
)

smart groups
saved searches
tags
member directories
Drupal-esque views

Packaging those sets up for transfer to WordPress

exports
saved searches
custom-coded WordPress plugin

Displaying those sets in WordPress

shortcodes
Pods custom fields
Toolset custom fields

I’m thinking about finding a developer to do some custom code to link things up.

At this point, I imagine I would have come across a recognizable method if there was one. But it seems prudent to make sure I’m not missing a direct solution. Thanks in advance for your help!


texts: Can CiviCRM provide a warning/error if a user submits a certain organization name as their current employer?

texts: We've had a long standing issue with our users entering in Catholic Charities as their organization name when registering for events, making donations, etc. It's caused havoc in our system as we will have many people associated with the Catholic Charities record, instead of their appropriate organization (e.g. Catholic Charities of New York). We've used the auto complete extension to show users a set list of organizations they can choose from, however we still get people simply typing in Catholic Charities, despite our best efforts (we still allow people to put other organization names, because people outside our network sometimes register for certain trainings, make donations, etc). Is there a way for the system to throw back a warning/error to the user and/or force them to change their organization name if it detects Catholic Charities was input as the value?


texts:
I am having an issue whenever I run the upgrade for 4.0.1 to 4.1.0.  The issue is below:

Cannot execute CREATE TABLE `civicrm_setting` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`group_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'group name for setting element, useful in caching setting elements',
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Unique name for setting',
`value` text COLLATE utf8_unicode_ci COMMENT 'data associated with this group / name combo',
`domain_id` int(10) unsigned NOT NULL COMMENT 'Which Domain is this menu item for',
`contact_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to Contact ID if the setting is localized to a contact',
`is_domain` tinyint(4) DEFAULT NULL COMMENT 'Is this setting a contact specific or site wide setting?',
`component_id` int(10) unsigned DEFAULT NULL COMMENT 'Component that this menu item belongs to',
`created_date` datetime DEFAULT NULL COMMENT 'When was the setting created',
`created_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to civicrm_contact, who created this setting',
PRIMARY KEY (`id`),
KEY `index_group_name` (`group_name`,`name`),
KEY `FK_civicrm_setting_domain_id` (`domain_id`),
KEY `FK_civicrm_setting_contact_id` (`contact_id`),
KEY `FK_civicrm_setting_component_id` (`component_id`),
KEY `FK_civicrm_setting_created_id` (`created_id`),
CONSTRAINT `FK_civicrm_setting_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_civicrm_setting_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_civicrm_setting_component_id` FOREIGN KEY (`component_id`) REFERENCES `civicrm_component` (`id`),
CONSTRAINT `FK_civicrm_setting_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL )
ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1:
DB Error: already exists


texts: Who supports civiCRM in Raleigh NC using Wordpress?

texts: Our organization uses civiCRM currently.   We wish to migrate to WordPress for our new website design.   We want three bids for this work.   Who in Raleigh, NC are currently offering such services that are familiar with civiCRM and Wordpress?


texts: Change Log Tab Excrutiatingly Slow - Poorly Performing Query and Fix (from 8 minutes down to 4 seconds)

texts:
The page takes about 8 minutes to return which is absurdly slow for anything expected to be remotely interactive. It is so slow that my client is referring to it as the "Triangle of Doom".
I tracked it down to this query:
INSERT IGNORE INTO civicrm_tmp_e_logsummary_ffa3ac146126d178ade367f2a5d17bf5
SELECT activity_id,  IF (entity_log_civireport.log_action = 'Insert' AND extra_table.activity_type_id = 51 , GROUP_CONCAT(entity_log_civireport.contact_id), 1) , entity_log_civireport.log_action as log_civicrm_entity_log_action, 'log_civicrm_activity_contact' as log_civicrm_entity_log_type, entity_log_civireport.log_user_id as log_civicrm_entity_log_user_id, entity_log_civireport.log_date as log_civicrm_entity_log_date, modified_contact_civireport.display_name as log_civicrm_entity_altered_contact, modified_contact_civireport.id as log_civicrm_entity_altered_contact_id, entity_log_civireport.log_conn_id as log_civicrm_entity_log_conn_id, modified_contact_civireport.is_deleted as log_civicrm_entity_is_deleted, altered_by_contact_civireport.display_name as altered_by_contact_display_name

FROM            staging_civicrm.log_civicrm_activity_contact entity_log_civireport
JOIN            civicrm_contact modified_contact_civireport ON (entity_log_civireport.contact_id = modified_contact_civireport.id )
JOIN            staging_civicrm.log_civicrm_activity extra_table ON extra_table.id = entity_log_civireport.activity_id
LEFT JOIN       civicrm_contact altered_by_contact_civireport ON (entity_log_civireport.log_user_id = altered_by_contact_civireport.id)
WHERE           modified_contact_civireport.id = 338520 AND
                entity_log_civireport.log_action != 'Initialization'
GROUP BY        entity_log_civireport.log_conn_id,
                entity_log_civireport.log_user_id,
                EXTRACT(DAY_MICROSECOND FROM entity_log_civireport.log_date),
                entity_log_civireport.id
ORDER BY        entity_log_civireport.log_date DESC;

EXPLAIN shows:
+------+-------------+-------------------------------+--------+---------------+---------+---------+---------------------------------------------------+---------+-------------------------------------------------+
| id   | select_type | table                         | type   | possible_keys | key     | key_len | ref                                               | rows    | Extra                                           |
+------+-------------+-------------------------------+--------+---------------+---------+---------+---------------------------------------------------+---------+-------------------------------------------------+
|    1 | SIMPLE      | modified_contact_civireport   | const  | PRIMARY       | PRIMARY | 4       | const                                             | 1       | Using temporary; Using filesort                 |
|    1 | SIMPLE      | extra_table                   | ALL    | NULL          | NULL    | NULL    | NULL                                              | 3014020 |                                                 |
|    1 | SIMPLE      | entity_log_civireport         | ALL    | NULL          | NULL    | NULL    | NULL                                              | 5518537 | Using where; Using join buffer (flat, BNL join) |
|    1 | SIMPLE      | altered_by_contact_civireport | eq_ref | PRIMARY       | PRIMARY | 4       | staging_civicrm.entity_log_civireport.log_user_id | 1       | Using where                                     |
+------+-------------+-------------------------------+--------+---------------+---------+---------+---------------------------------------------------+---------+-------------------------------------------------+


texts: Is it possible to add new target type in drupal content type?


texts: Civicase add timeline but activities not shown

texts:
Version:civicrm-5.33.1-wordpress
I tried to create a timeline hoping then when i add it, it will be shown in the activities tab. But apparently this is not working. Is there any setting i missed out?


texts:
I am copying a previous event but the registration page shows the old date and address. I have updated the event in Event Location, but it will not change. How can i change this?
Thanks


texts: Change Reply-To for System Workflow Messages?

texts: Is it possible to change the reply-to for system workflow messages?


texts:
As a workflow message for a contribution confirmation, i use the following template. All values are displayed, except $financial_type_id and $source. Both stay empty in the output table. How come only those two are not displayed, while the others are? When I use total_amount (a database field) instead of amount (not a database field), the output is also empty.

{capture assign=headerStyle}colspan="2" style="text-align: left; padding: 4px; border-bottom: 1px solid #999; background-color: #eee;"{/capture}
{capture assign=labelStyle }style="padding: 4px; border-bottom: 1px solid #999; background-color: #f7f7f7;"{/capture}
{capture assign=valueStyle }style="padding: 4px; border-bottom: 1px solid #999;"{/capture}

        Detail Contribution

        {ts}Financial type{/ts}
        {$financial_type_id}

        {ts}Total Amount{/ts}
        {$amount|crmMoney:$currency}

        Year
        {$source}

        {ts}Receive Date{/ts}
        {$receive_date|truncate:10:''|crmDate}

        {ts}Receipt Date{/ts}
        {$receipt_date|truncate:10:''|crmDate}

        {ts}Transaction #{/ts}
        {$trxn_id}


texts:
I'm seeing quite a lot of strange looking URL requests on the civicrm/mailing/url path, which is supposed to take 2 params (as I understand): u=<integer> and qid=<integer>, but these requests are coming with other, seemingly random query params, like d=34273&thf=42882749 or j=73737&hjb=67859229. The requests are coming from a range of IPs and (apparent) User Agents, but they do come in flurries e.g. 12 within one minute.
These are all just generating server errors, since it can't process without valid u value, but should I be concerned?


texts:
In civiCRM 5.14.1. and Joomla 3.9.10, the contact image is quickly displayed on the contact summary page, and then disappears again.

In this video  you can see it appears at the 15 second mark and then quickly disappears. I've cleared all my civi cache files, so that isn't the problem.

Any idea what's up?


texts: CiviMail pull-downs not displaying correctly

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

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

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

Any ideas? Thanks.

Screenshot:

HTML:

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

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

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

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

[removed list of options]

   </select>


texts: CiviEvent: Could not find valid value for id (Drupal 7.6.1)

texts:
Using CiviCRM 5.7.2, using Drupal 7.61.

I thought I had fixed this error but it looks like my fix has created another problem... or at least another error has decided to appear.

This is an intermittent error, have not been able to replicate yet but had it reported by a member of our staff.

Upon registering for an event with event registration turned on, and confirmation screen / emails turned on, and payment turned off, the user receives this error message.

Could not find valid value for id

This error seems different to other similar reported errors in that the registration does not go through. The user does not see the confirmation screen, they do not receive the confirmation email, and their registration does not feed into CiviCRM.

Went into the drupal error logs and saw the following errors:

$Fatal Error Details = Array ( [message] => Could not find valid value for id [code] => )

and

$backTrace = #0 /home2/ppe/public_html/sites/all/modules/civicrm/CRM/Core/Error.php(381): CRM_Core_Error::backtrace("backTrace", TRUE) #1 /home2/ppe/public_html/sites/all/modules/civicrm/CRM/Utils/Request.php(121): CRM_Core_Error::fatal("Could not find valid value for id") #2 /home2/ppe/public_html/sites/all/modules/civicrm/CRM/Event/StateMachine/Registration.php(52): CRM_Utils_Request::retrieve("id", "Positive", Object(CRM_Event_Controller_Registration), TRUE) #3 /home2/ppe/public_html/sites/all/modules/civicrm/CRM/Event/Controller/Registration.php(47): CRM_Event_StateMachine_Registration->__construct(Object(CRM_Event_Controller_Registration), TRUE) #4 /home2/ppe/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(304): CRM_Event_Controller_Registration->__construct("Event Registration", TRUE, "null", NULL, "false") #5 /home2/ppe/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:15)) #6 /home2/ppe/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3)) #7 /home2/ppe/public_html/sites/all/modules/civicrm/drupal/civicrm.module(445): CRM_Core_Invoke::invoke((Array:3)) #8 /home2/ppe/public_html/includes/menu.inc(527): civicrm_invoke("event", "register") #9 /home2/ppe/public_html/index.php(21): menu_execute_active_handler() #10 {main}

(sorry, not sure how to put that code as a block rather than a massive horizontal scrolling box)

Another user has also reported receiving a 500 error, I'm not sure if it's related. This is what Drupal error log says about their 500 error:

Warning: in_array() expects parameter 2 to be array, null given in CRM_Contact_BAO_Contact::formatProfileContactParams() (line 2128 of /home2/ppe/public_html/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php).

Anyone encountered anything similar? For now I've just disabled confirmation emails altogether until I work this out.

Cheers,


texts: What's the optimal way to install and track CiviCRM with Drupal and git?

texts:
First, I know compatibility with Drupal 8 is not full yet. There are still open bugs, a bunch of open PRs and an apparent lack of code review.

But let's ignore that for a moment and consider civi d8-ready. I want to do a test install for a migration from Joomla, but also maintain some level of tracking, so it's easier to work with custom changes and any (knock on wood) malicious ones are easier to detect and revert. Looking at various docs, I've found at least these options:

classical install: drupal, civi
drush: nicely handles downloads, upgrades and backups (no idea if it has VCS support by itself)
composer: seems to be unofficially preferred for drupal8; not that much info available; more dependency heavy
civi-buildkit: seems like a complete overkill, as I don't need a full development environment

All of them can be preceded by initing a blank git repo and manually tracking from there. The buildkit is already fully based on git. Can any of the others track upstream automatically, to avoid the need for manual commits-on-update and working with tarballs? Did I forget an even better option, some combination?


texts: Need help in getting quote for security upgrades

texts: We are a small non-profit using CiviCRM. We are currently being charged a lot for security upgrades and monitoring. We are trying to understand pricing and what we actually need. We want to change companies. Will we have to spend a lot on 'migration'? What elements do we need to get in a quote to compare apples to apples?


texts: Calling images from a database with custom tokens in mass mailings

texts:
I was just wondering whether CiviCRM offers the ability to insert custom images into a mass mailing? So that each person receives a different image pulled from a server?

The best described example I can find is here.

In the same vein, can tokens/mail merge be used in CiviCRM to send a different attachment to each subscriber?

If the answer to these questions is yes, can you tell me where the images/attachments are pulled from? I would assume our own server?

Kind regards,
G


texts: Is there a way to update a partial refund for an event registration and associated contribution?

texts:
On 4.7.15

Tried to update a contribution record from Pending Refund to Completed (not integrated with accounting software)

Got "Cannot change contribution status from Pending refund to Completed" message

Customer registered on-line (we use Drupal) but made a selection error that requires a small refund.  I was able to change selections from within Civi, and prices updated correctly. Now that the refund has been processed through Authorize.net, I want to update the Contribution record.


texts: Word replacement not working in some areas

texts:
I'm in Canada, and instead of County, we use "Province". I've set up a Word Replacement for "County" to change it to "Province", but when I edit a Contact, the label on the form still reads "County".

I'm running civiCRM 4.6.9 under Joomla 3.4.5

A short video walkthrough: http://www.youtube.com/watch?v=ok02KLEpYKM

Can anyone explain why this Word Replacement isn't working?


texts: Countries of US addresses showing up as Foreign in some names

texts:
I have a mailing list of about 1,500 names.  I have imported them into CiviCRM using a CSV spreadsheet file.  The country field for all these names in my spreadsheet are all labeled United States.  A good portion of my addresses after the import into CiviCrm are now listed as another country.  Some show South Africa, etc.  I've tried the import several times to no avail, but my original list is correct.

Any suggestions how to fix this?  Thanks

Mark


texts: configure URLs in system workflow messages

texts:
I've discovered that the URL that is created in the Pledge Acknowledgement and Reminder system workflow messages points to our admin site rather than the public site on our Joomla site. In other words, the url starts with "domain.org/administrator/" rather than "domain.org/index.org" This may be a configuration problem somewhere, or perhaps a bug in how Core handles Joomla urls. Any help on how I can fix this?
One fix that I've tried is to just remove the crmURL call in the smarty template, and replace it with text and simple smarty tokens, but I'm not sure how to access the pledge_id in this case.
Joomla 3.9.24, Civi 5.33.2


texts: How can I create a new type of block in Mosaico?

texts:
The Mosaico CiviCRM Integration extension includes a base template that provides several different types of blocks to use in composing emails.

I need a type of block that's not included in that base template. My block type would contain a name (editable text) on the left, a signature (uploadable image) below the name, and a logo (uploadable image) to the right.

How can I create this custom block type, and make it available in my templates?


texts: Version 5.11.0, Event custom fields not carried over to repeat events

texts: We use version 5.11.0 and we're still having this issue. Is it possible to see if a solution has been introduced?


texts:
Excuse me I am new to Civicrm and got stuck, I installed Civicrm-drupal from github, I wanted to check if the configurations are correct so I ran the command "civix civicrm:ping", but I got this exception:

[Exception]
  Failed to locate civicrm.settings.php. By default, this tool searches the p
  arent directories for a standard CMS (Drupal, WordPress, etal) and standard
   civicrm.settings.php. Symlinks and multisite configurations may interfere.
   To customize, set variable CIVICRM_SETTINGS to point to the preferred civi
  crm.settings.php.
civicrm:ping

I searched for this exception and found out that I need to change the directory where the civicrm.settings.php is, and usually it is in this path: sites/default/civicrm.settings.php.

Now the problem is that I can not find Civicrm.settings.php anywhere, not in the above path nor anywhere.

Please advise me.

Regards


texts:
Bonjour,

i want to add a custom participant listing option (there is a topic 3 years ago but i don't understand the comment).

I create a specific option in Administer CiviCRM / Lists of choice / List of participants.

But how and where i can specified the field i want : Name + default role for example.

Thanks for your help


texts:
I got something quite strange and do not how to solve it.
In my Wordpress 5.6.1 /CiviCRM 5.34 integration (my first WP integration but have am also working with D7/Civi for 8+ years)
I get a double registration screen. It shows in the main area AND in the footer.
I am using the native url and not the shortcode.
https://www.mydomain.nl/civicrm/event/register/?reset=1&id=12
UPDATE: it is only when I use a selected page as a footer in my enfold theme


texts: Why doesn't CiviCase API filter by case status when the client is specified?

texts:
This seems like a bug.  I encountered it on Joomla with 4.6.8 and reproduced on the demo server.

If I create a case and change the status to "Urgent", then use the API (including API explorer), it seems to filter properly on status_id and is_deleted UNTIL I also add contact_id (Case Client).  Then it returns the case regardless of its status.  (I didn't test whether it works correctly with is_deleted).


texts: How to create a custom filter in CiviCRM manage event page?

texts:
How can I add a custom field (stored as a field in Drupal db) under Manage Events page ,which will be displayed as dropdown.
Event Status with values Pending or Approved.

How can I alter the filters added as seen in the image?


texts: CiviCase Will Not Save Settings for Activities

texts:
I am using CiviCRM 4.5.5 on Drupal 7.

When I go to the settings page for my Case configuration (Administer -> CiviCase ->Case Types) I can add activities to the list of activities and appears to save.  No error message is being raised.  However if you edit the Case type again you will that none of your changes are there.

I  will note that this instance of CiviCRM and CiviCase have been upgraded since somewhere in Civi 3.x.

Thanks in advance for the help.

Thanks,
Steve


texts:
I installed the i10n extension on 4.7.24 and it totally FUBARed parts of the admin interface, I only get a blank screen.
How can I manually remove the extension (Extension menu is FUBARed too).


texts: How do I change the styles dropdown in message templates

texts: How do I change the style dropdown to have my own personal styles in the dropdown in the message templates?


texts:
I want to register offline payments of an event.
The total cost of event is € 100. Contacts can pay twice. € 50 at the end of October and 50€ at the end of December.
I want to send the email notification to remind payments.
When i put a partecipiant registration to the event, I can select the payment status.
If you register a second payment instead I can not select the payment status. Why ?

Thanks.
Marco


texts: What are your typical mail size batches and delviery times?

texts:
What are your typical mail sizes and time to complete mail job? Looking for comparisons...
We are having lots of mail delivery problems on a new highly customised install of Civi v5.27.1  (MariaDB v10.5.8). We have 196,000 contact records and are sending bulk mailings of max 1000, which are taking 4 hours to process. Sometimes the mail jobs get stuck in status 'running'.
We have seen a single bounce email, repeatedly trying to send, and keep the mail job runnning.
We have also seen the same email repeatedly delivering more than 20 times (until the mail job paused)
Mailer batch limit = 0
Mailer throttle time = 10
Mailer job size = 0
Mailer cron limit = 0
Our mail provider is 1&1.
Comparative performance on other civi instances much appreciated.
We are also looking for anyone specifically with civi mail expertise, system performance at server and database level.
Thanks


texts: Database update failing for CiviCRM upgrade in Joomla 2.5

texts:
I have installed Civi 4.2.19 in Joomla 2.5, to upgrade the 4.1.1 version. I cleared all cache and then tried to run the database update. I got this fatal error:

Fatal error: require_once(): Failed opening required 'CRM/Upgrade/Incremental/php/FourFix.php' (include_path='/home/xxxxx/public_html/j25/media/civicrm/custom/code:.:/home/xxxxx/public_html/j25/administrator/components/com_civicrm/civicrm:/home/xxxxx/public_html/j25/administrator/components/com_civicrm/civicrm/packages:.:/opt/alt/php55/usr/share/pear:/opt/alt/php55/usr/share/php') in /home/xxxxx/public_html/j25/administrator/components/com_civicrm/civicrm/CRM/Core/ClassLoader.php on line 126

It's referencing file "FourFix.php" which does not exist. I'm stuck and can't continue. I tried updating to 4.4.21, then the database update. Same result.
Anyone able to help??


texts: What would cause civicrm_invoke to submit a large number of server requests?

texts:
Earlier today, the civicrm_invoke process submitted a large number of requests to our server – so many requests that it took our site down. An agent at our host (Pantheon) had to restart our application instance to get our site back on-line.

My goal is to prevent this from happening again. To do that, I need to better understand why this happened, so I'm turning to y'all for some guidance:

What is civicrm_invoke?
What causes it to instantiate?
If there are obvious possible causes for a (seemingly) spontaneous "burst" of civicrm_invoke requests, what are they?

We're on a virtual server on Pantheon, running CiviCRM 4.7.8, Drupal 7.44, PHP 5.5.24. Our database is: 5.5.5-10.0.23-MariaDB-log. No extensions are installed. Cron has not run since April 18th (Yes, that's a problem. No, I don't know how I managed to get it to run in April. If anyone can point me at a way to manually force Civi's Cron to run, that'd be keen.).

Thanks!


texts:
Sage Pay was throwing 5006 error upon submission of card details. When we set Location type as "Home" in CiviCRM, we were able to complete transaction without any issues. But when we set Location type as "Work", we'll either get 5006 error or transaction will be cancelled by the system. Do you have any idea why and how "Location type" is affecting in transaction through Sage Pay.

If you could guide us in resolving above mentioned issues, it would be really helpful for us to find the root cause for the challenges encountered.

Thanks in advance for your great support.

We are using following versions:

CiviCRM - 4.6.8
Joomla - 3.4.8
Sage Pay - 3.1.0


texts: How do I get mailing behavioural data through the CiviCRM data through the API? Like number of bounce per mailing job or number of opens.


texts:
I have access to Drupal and CiviCRM admin but for half the DRUPAL pages I get a white page. (apparently CiviCRM works fine).
Something is crashing the website and I don't understand what.
I still can access to Drupal Logs and they don't show anything special.
I have no idea where to start from.

What is unclear is that I have a drupal multisite functioning with sub folders /site1 /site2 and only 2 from 3 don't work anymore. So this issue is really related to some special parameters I can't find.

Any help?


texts: Contact summary email link open mailto: instead?

texts:
Noticing a change after update to 4.6.  Within the contact summary, clicking an email link opens up a CiviCRM popup email dialogue.  Is there an easy way to override this behavior and provide a simple mailto: link instead like it used to be in 4.4?

A setting? if not, an extension?


texts: How to allow logged in user to view their own civicrm contact dashboard in wordpress?

texts:
I want to allow logged in user to edit own contact details(own) from contact dashboard and edit custom fields(own)

WordPress Version 4.9.8
CiviCRM Version 5.5.1


texts: Searching by 'Contribution Source' gives no results CiviCRM 5.21.1

texts:
I currently cannot search using the 'Contribution Source' field within advanced search. I can however use the field successfully within the 'Find contributions' search.

Is this a bug?


texts:
What is the recommended way to upload teenage volunteer and their parents data from csv file
This is the info looking to upload
First   Last    Email   Cell    Address City    State   Zip Home Phone  Email 2 Birthday    School  Gender
Moms Prefix Moms First Name Moms Last Name  Moms Cell   Moms Email  Moms Gender Moms Birthday
Father Prefix   Fathers Name    Fathers Last Name   Fathers Email   Fathers Gender  Fathers Birthday
Also...how do i group only the volunteer as group Volunteer & not the parents? Would you recommend to have the parents as a smart group such as parents of teenage volunteers for mailing purposes for example or to make a group called parents of teenage volunteers? How would i load that as part of this upload.
Thank you!


texts: Civicrm SagePay takes the primary address as billing address

texts:
I just came across this error in Civicrm. We have sage pay payment intergration with our site.

The issue is that even when someone enters the billing address civicrm passes primary address to sagepay . This is a general issue and is happening with all the module ie - civiEven, Contribution,

My assumption is an error in the payment processor that passes the values to sage pay

Any thoughts are highly appreciated.

ex :


texts: Multiple Choice Custom Field Not saved on creation of new contribution

texts:
I am running CiviCRM 4.4.4 on WP 3.6.1

This is a problem with entering new contributions.

I have a custom field tied to a multiple choice menu.
The same menu is used for 4 different custom fields,
one of which is required.

If you do not fill in the required field an error is generated upon submit.

If you select one of the options, and submit a valid contribution,
then immediately view the contribution, the fields tied to this
menu are empty.  (including the required one)

The final piece to the puzzle.  If I go back in and edit the contribution
and re-enter the data, the second time it sticks.

What could be causing something like this?


texts: How do I automatically make roles inactive when case is resolved

texts:
CiviCRM Version 4.5.6

Looking at some case types (it seems to work for other case types) where after case status has been changed to "resolved," case roles remain active.

Is there a way to automatically end date these relationships?


texts:
I'm putting together a terms agreement using custom data, as a part of a new member signup profile.  I have a single required checkbox to agree, but I'd like to put the content of the terms in the from pre-help area.  Is it possible to put HTML here?  It's a huge mess as plaintext.

Thanks


texts: Exporting data (users) into another location?

texts:
is there a way to automatically export a file (with contacts information) outside of the CiviCRM installation to another location?
I'm using CiviCRM on Drupal and before looking at Drupal's side, I'm wondering if this is possible with CiviCRM.
I want to connect to a Wordpress site to create users.
Any experience?


texts: Unable to install extensions: HTTP redirection error

texts:
I'm unable to install CiviCRM extensions from CiviCRM » Administer CiviCRM. On the CiviCRM extensions page I get the following error:

  WARNING: The downloader may be unable to download files which require
  HTTP redirection. This may be a configuration issue with PHP's
  open_basedir or safe_mode.

When I try to install an extension I get the following errors:

I've checked and:

The PHP setting open_basedir is not defined.
The PHP setting safe_mode is set to off

What's going on?

I've got CiviCRM 4.5.5 installed with Wordpress 4.1.1


texts: Warning after installation: Invalid argument supplied for foreach() in CRM_Utils_Check_Component_Env

texts:
anyone an idea what this warning is about? I get this warning straight after fresh installation.

Warning: Invalid argument supplied for foreach() in CRM_Utils_Check_Component_Env->checkVersion() (Zeile 522 von /www/myorg/sites/all/modules/civicrm/CRM/Utils/Check/Component/Env.php).

My Environment:

OS: OpenSUSE Leap 42.3
PHP Version: 5.5.14
CiviCRM Version: 5.7.0

Would be great if someone can support!

Regards,
Said


texts:
I'm experiencing that the persons on the waitlist gets offered a place in the wrong order. What I see is that the last person to register gets offered first. Which is of course backwards how I want it ;-)
Is this configurable so I have missed to set it correctly? Or is this something about date comparisons? (I'm running a Swedish site). Or some other bug?


texts: CiviCRM DB Error: syntax error during upgrade in Wordpress

texts:
I have tried upgrading to several different versions (5.14.1 up to 5.28) and every time I run the database upgrade, I get a DB Error: syntax error message and can't figure out why.
Here is an extract from my log file.
Any help would be most appreciated.
Aug 08 09:06:01  [error] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -2
[message] => DB Error: syntax error
[mode] => 16
[debug_info] => DROP TRIGGER IF EXISTS civicrm_group_contact_05Feb20-2049_before_insert [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-2049_before_insert' at line 1]
[type] => DB_Error
[user_info] => DROP TRIGGER IF EXISTS civicrm_group_contact_05Feb20-2049_before_insert [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-2049_before_insert' at line 1]
[to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="DROP TRIGGER IF EXISTS civicrm_group_contact_05Feb20-2049_before_insert [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-2049_before_insert' at line 1]"]

)


texts: Anonymours_User Creating Articles and Publishing Pages on Drupal 8

texts:
It seems like our site's security has been compromised. We have some annoymous_users creating pages and publishing articles. They are all showing as unpublished, but it seems like there's dozens of pages created. We are running CiviCRM on Drupal 8. If someone can advise on the corrective actions required here that would be great.
Thanks


texts: Discount Code - error saying select at least one full fee option to progress reg

texts: I have set up discount codes in Civi for the next event. The discount code, when applied, is working and it deducting 100%. However, when I go to 'review registration' an error is coming up saying I need to select an event fee of at least £99.00.  I found a similar question and it said to set the £99.00 as a default but that didn't work either.  We have three fee options.


texts: $participant_status_id shows previous value in email template

texts: Using version 4.6.9 on Drupal 7.  I'm working on a revision to our email template for event registrants, and in our environment, it's important to distinguish between individuals who are awaiting administrative approval (status 8), those with completed registration (status 1), and those assigned to the waitlist(status 7). I thought the variable $participant_status_id would meet my needs, but emails generated after an update to participant status show the previous value for $participant_status_id, not the updated value. Is this how it's supposed to work? What smarty variable do I use to check the updated status?


texts: Wordpress Contribution Form - how to suppress Leave Page Warning

texts:
I found a note about suppressing the leave page alert using  Joomla. Does it applies to sites using WordPress?

On our WordPress contribution page we give a PayPal Option.
The user fills in the donation amount then selects the Pay with PayPal radio button.
When the user hits Confirm Contribution - a javascript alert pops up warning

Leave Page?

Changes you made may not be saved.

Leave    Cancel

Is there a way to not have the javascript alert, and just go to PayPal?

The other answer mentions modifying the Profile. As best I know we are not using a Profile.


texts: Find contacts that have been moved out of a group

texts:
Working with Advanced Search and Search Builder but I can't figure out how to find contacts that were moved out of a group.

Civi version 4.7.1 on Drupal. Thanks!


texts: If I create a Scheduled Reminder for Event feedback, eg 16 hours after, should I expect it to go out to all past events?

texts:
We set up a Scheduled Reminder with a link to a webform for event feedback. It is set to go out 16 hours after the event.

We did not expect it to go out to all past events (hundreds of events with thousands of participants over many years)

A/ is this a bug that can/should be fixed

B/ should there be a warning when setting up Scheduled Reminders that these may go out to a much wider audience than expected

C/ is there some way we could have worked around this if we had known it was likely?


texts:
We would like to extend the quick searchbox to include the fields  standard civi field 'source' as well as potentially add some of our custom fields.

Any pointers to where in the base code and examples would be hugely appreciated!


texts: How to add a custom field to the civicontribute dashboard?

texts:
I've researched a bit on how to create a custom field and believe I understand the process (from this post), but I would now like to add the content of this field to the CiviContribute dashboard.

To explain, we need a title field on contribution pages that doesn't get exposed publicly. This would allow us to use the same title on multiple contribution pages which we could use in different campaigns, but be able to tell the difference between them with an "internal" title. At present, the Source columnbn on the dashboard uses the publicly exposed title, but we'd like to swap it out for the custom "internal" title or add that column to the dashboard alongside the Source column.

I was not able to find how to do this without coding, but continue to hope that the option exists under Administer somewhere.


texts:
I have contacts with multiple email addresses. I want to assign non-Primary to specific Groups, ie, Billing different than Main (Primary).

Also, when using simple or Advanced Search, it doesn't find any other email address other than Primary for that contact.

Finally, using Full-Text or Search Builder, the former finds the Contact record but offers no additional functions while the latter finds the correct email address but will not allow it to be added to the group and defaults to the Primary tagged email address.


texts: Scheduled job execution time is creeping

texts:
I have a scheduled job that runs at 10am each day. It just sends a report.
I'm noticing over time that the job is executing later and later. Now it is executing at 10.15am. Anyone else noticed this and it there a way of fixing it without having to go back into the scheduled job and reset the time?


texts:
I am trying to set up Views on my CiviCRM 4.7.10 (Drupal 7.42). My Drupal database is on one SQL server. And my CiviCRM database is on another SQL server.
Whenever I try to create a new view, I encounter the following message:
SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'xxxxx'@'xxxxxx' for table 'civicrm_contact'
After looking intensively through the documentation, I cannot manage to find the right changes so that Views can connect to the correct SQL server.
I have tried changing the file settings.php, but with no success.
Could someone kindly tell me what to do so that Views connects correctly to the SQL server where the CiviCRM is?
Thanks a lot.


texts: Cases - Send Copy of an Activity, Add Individual Phone and Email

texts:
When a person is assigned any activity, the information goes as a form. However, I would also like to include the phone number and email address of the person from whom the event was created. How can I do that.

  administrator/?option=com_civicrm&task=civicrm/admin/messageTemplates/add&action=update&id=1&reset=1

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
 <title></title>

{capture assign=headerStyle}colspan="2" style="text-align: left; padding: 4px; border-bottom: 1px solid #999; background-color: #eee;"{/capture}
{capture assign=labelStyle }style="padding: 4px; border-bottom: 1px solid #999; background-color: #f7f7f7;"{/capture}
{capture assign=valueStyle }style="padding: 4px; border-bottom: 1px solid #999;"{/capture}

       {ts}Activity Summary{/ts} - {$activityTypeName}

     {if $isCaseActivity}

        {ts}Your Case Role(s){/ts}

        {$contact.role}

      {if $manageCaseURL}

     {ts}Manage Case{/ts}

      {/if}
     {/if}
     {if $editActURL}

   {ts}Edit activity{/ts}

     {/if}
     {if $viewActURL}

   {ts}View activity{/ts}

     {/if}
     {foreach from=$activity.fields item=field}

        {$field.label}{if $field.category}({$field.category}){/if}

        {if $field.type eq 'Date'}
         {$field.value|crmDate:$config->dateformatDatetime}
        {else}
         {$field.value}
        {/if}

     {/foreach}

     {foreach from=$activity.customGroups key=customGroupName item=customGroup}

        {$customGroupName}

      {foreach from=$customGroup item=field}

         {$field.label}

         {if $field.type eq 'Date'}
          {$field.value|crmDate:$config->dateformatDatetime}
         {else}
          {$field.value}
         {/if}

      {/foreach}
     {/foreach}


texts: Where would I go to change a column name in a report? I need an event summary report. There are 2 columns that list out the Registered/Attended/Pending etc. Those column names are very long and I would like to use this report on our dashboard. It would be nice if I could just say Participant Count.


texts: Non-admin user can't reserve survey respondents without getting error "Missing Interviewer contact."

texts:
WordPress 4.9.10
CiviCRM 4.7.29

When I'm logged into CiviCRM as an admin, the process of reserving respondents for a survey works fine.  However, if I'm logged in with a WP "Contributor" role (which is the role all my civicrm users have) I get an error message when I try to reserve them, "Missing Interviewer contact.", as seen below.

Looking at the search criteria I see that there is no field to assign the interviewer as there is when I'm logged in as an admin:

I checked my survey-related permissions and I think I have it setup correctly so a person with the "contributor" role should be able to do this:

Is there something else permissions-related that I need to be setting, or is this maybe a bug?

Thanks for any help,

Ruth


texts: What is the contact ID of my own user record?

texts: Often, when giving support, it's helpful to direct people to their own record.  Is there a good way to find this?  As a dev, I can use the techniques listed here, but I don't see a non-technical way to do this.  It doesn't seem to be listed on the User Dashboard, for instance.  Any thoughts?


texts:
I would like allow a WordPress user only to have access to CiviCRM. I realise that it has to go through the WordPress interface, but we want the CiviCRM users to only be able to administer CiviCRM, and not the WordPress site. Some will need full rights to CiviCRM.

I have found some info regarding this, and this questions helped me a lot: How to display CiviCRM menu for non-admin role using WordPress?

Anyone can register is not selected in WP admin, and I have changed that a subscriber can access basically everything in in WordPress Access Control.

I am just concerned about security, and was wondering if perhaps there is a better way of doing this?

Thank you


texts: Date Format and CiviContribute/Data Form Confirmation Page

texts:
We are using CiviCRM with the european portuguese language pack and during setup we set the date format to be dd.mm.yyyy at localisation/date format (administration tab).

We have created a civicontribute form/page where we request dates twice. Everything is fine in the way a user inserts the date and it shows the date in the preset date format we chose (e.g. 10.04.2015). However when you press "contribute" and advance to the confirmation page the dates don't show like that anymore but in the US format (04/10/2015). I am afraid this will generate a lot of confusion because people will think they have filled in the date incorrectly.

I've tried changing all possible date settings at civiCRM administration and nothing works. We simply can't use the form until this is fixed.

Help would be appreciated. Thank you.