texts: How to keep contacts to a GROUP for a limited period?

texts:
We have kids activity event that runs for a year, for example, event name is KIDS CLUB - 2019. Registration is done by webform. We capture parent details as relationship and added to PARENT GROUP. Kids details added as contact & participant, added to KIDS GROUP. That was easy part!

For the next year we would need to create an event called KIDS CLUB - 2020. Some kids and parent may remain same and some new kids will signup. We do not want to send any related email to those parents who has not signed up for 2020.

How can we remove the parents & kids automatically that would not signup for next year? Perhaps some of you can think of an alternative approach to deal with it. Please feel free to suggest. Thanks


texts: Permission 'See CiviCRM is installed' keeps being removed on Joomla

texts:
I have a problem where the CiviCRM permissions on a Joomla site keep being altered.  The 'See CiviCRM is installed' permission is set on 'Registered' users to 'Allowed' but keeps being reset to 'Not Allowed'.  Any suggestions as to what might be causing this would be appreciated - could it be a CiviCRm security check process running something?
PHP version 7.3.24, Joomla! 3.9.19 Stable, CiviCRM 5.31.0


texts: How can I fix [civicrm.root] variable on an addon domain?

texts:
I believe [civicrm.root] is being computed incorrectly. Entering the absolute URLs in Settings > Resource URLs has been sufficient to fix most problems, but some problems persist.

For example, when i encounter an error like  crm.ckeditor.js  getting an error, the console tells me it can't find it at https://mysite.org/mysite.org/wp-content/plugins/civicrm/civicrm/js/wysiwyg/crm.ckeditor.js.

You'll notice that mysite.org is repeated.

I'm running (CiviCRM 4.7.22) on an "Addon Domain" on my host. When you manage files for your addon domains, they show up as a folder on in your file manager. So my Civi files are installed at:

/home/username/public_html/mysite.org/wp-content/plugins/civicrm/civicrm/

I assume that when Civi is computing the [civicrm.root] variable, it just assumes it can replace /home/username/public_html with the base url defined by CIVICRM_UF_BASEURL, which would explain why I'm getting this https://mysite.org/mysite.org/wp-content....

So how do I fix this permanently? Clearly using absolute URLs in Settings > Resource URLs isn't sufficient for every case. To clarify the values frrom settings.civicrm.php:

define( 'CIVICRM_UF_BASEURL'      , 'https://mysite.org/');
$civicrm_root = '/home/user/public_html/mysite.org/wp-content/plugins/civicrm/civicrm/';


texts: I want to do some spring cleanup and see who in my individual contacts aren't in any group, is there an easy way to do it?


texts: Internal Server Error Administrator Backend

texts:
I get an internal server error just about any time I click on anything in the administrator side of things.   This is a fresh install.  Here is the error I keep getting.

Dec 15 02:12:08  [info] $Fatal Error Details = Array
(
    [message] => Could not find valid value for id
    [code] =>
)

Dec 15 02:12:08  [info] $backTrace = #0 /home/rooted/public_html/2015/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(364): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/rooted/public_html/2015/administrator/components/com_civicrm/civicrm/CRM/Utils/Request.php(95): CRM_Core_Error::fatal("Could not find valid value for id")
#2 /home/rooted/public_html/2015/administrator/components/com_civicrm/civicrm/CRM/PCP/Page/PCPInfo.php(60): CRM_Utils_Request::retrieve("id", "Positive", Object(CRM_PCP_Page_PCPInfo), TRUE)
#3 /home/rooted/public_html/2015/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(312): CRM_PCP_Page_PCPInfo->run((Array:3), NULL)
#4 /home/rooted/public_html/2015/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:13))
#5 /home/rooted/public_html/2015/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))
#6 /home/rooted/public_html/2015/components/com_civicrm/civicrm.php(86): CRM_Core_Invoke::invoke((Array:3))
#7 /home/rooted/public_html/2015/components/com_civicrm/civicrm.php(11): civicrm_invoke()
#8 /home/rooted/public_html/2015/libraries/cms/component/helper.php(392): require_once("/home/rooted/public_html/2015/components/com_civicrm/civicrm.php")
#9 /home/rooted/public_html/2015/libraries/cms/component/helper.php(372): JComponentHelper::executeComponent("/home/rooted/public_html/2015/components/com_civicrm/civicrm.php")
#10 /home/rooted/public_html/2015/libraries/cms/application/site.php(191): JComponentHelper::renderComponent("com_civicrm")
#11 /home/rooted/public_html/2015/libraries/cms/application/site.php(230): JApplicationSite->dispatch()
#12 /home/rooted/public_html/2015/libraries/cms/application/cms.php(252): JApplicationSite->doExecute()
#13 /home/rooted/public_html/2015/index.php(45): JApplicationCms->execute()
#14 {main}


texts: Backbone JS error with 4.6.4 on WP messing up contribution page set up

texts:
It feels inappropriate posting this on Stack Exchange, but I don't see any other viable option since the support forum has been deprecated and no-one goes there any more, so here goes:

Just upgraded to 4.6.4 on a simple up to date Wordpress site. When setting up a contribution page the Receipting tab doesn't load correctly, the clickable fields that open up into CKEditor text areas don't work. I'm seeing a JS error in the Console: "TypeError: Backbone.Marionette is undefined" and a reference to line 11 of civicrm/js/crm.designerapp.js

Can't replicate on the demo site, but then again that is apparently not running 4.6.4, but 4.6.5.

Anyone?


texts: Now that the production version CiviCRM 4.7 released can Drupal 8.03 be used with it for production sites? When do you anticipate a stable production version with drupal 8.0?


texts: How does one download the CiviCRM 4.6 User Guide in PDF?

texts:
Civi Peeps.

Almost embarrassed to ask this ask this question, but only almost.

On its documentation site, under "About this book", Civi states:

"This book is freely available to read online and download in multiple formats."

I haven't yet found a way to download the entire guide in PDF or any other format.

The link to that page is here:

http://docs.civicrm.org/user/en/4.6/introduction/about-this-book/

Please advise.

Many thanks.


texts: How to invalidate (logout) a checksum login

texts:
We send out event registration links with checksums for our existing users.
Those 'users' are kids who visit our summercamp. Their parents receive the email and register the kids with the personalised registration link.

Now I was wondering, is there a way to 'log out'? the checksum login?
With a variant of ?cid=0 (but that only works on an existing registration page an not in general. We have several different events going on)

I'm asking because some parents go back in the form, change the name and think they register another kid, when instead they are changing the existing kid.

Any help would be welcome!


texts: CiviMail - How do I force crmMailing.$invalid to be false?

texts:
No luck getting Mailing to work with Civi 4.7.10 on Drupal despite all testing that says it should work. I think I've set every variable, token, requirement, etc there is. Even smartyDebug fails to show me an error. The Send test and Next are disabled (greyed out). Poking through the code in /var/www/drupal/sites/all/modules/civicrm/ang/crmMailing/BlockPreview.html I find

<button crm-icon="fa-paper-plane" title="{{crmMailing.$invalid || !testContact.email ? ts('Complete all required fields first') : ts('Send test message to %1', {1: testContact.email})}}" ng-disabled="crmMailing.$invalid || !testContact.email" ng-click="doSend({email: testContact.email})">{{ts('Send test')}}</button>

Although I've never used php before it seems || is a conditional whereby if crmMailing.$invalid is true 'Complete all required fields first' will be printed and if its false then the 'Send test' button is active and it will run doSend. The question is how can I force crmMailing.$invalid to always be false and trick the form into allowing me to proceed. While I could just trample over the code and not even bother with a test, I always hold out hope that somehow I'll figure out why the code won't work in my case and want to keep mods to minimum.


texts:
The slicknav mobile extension classes itself as Obsolete when we load it into our extensions. https://civicrm.org/extensions/slicknav-web-responsive-admin-menu.

Is this really true? And if so, is it known what it would take to make it current again?

Or is there some other way of having a mobile responsive menu with Civicrm?

We are also looking at the CiviMobile app, which is really really cool! In fact it may make a mobile menu quite obsolete, although there are some parts of Civi we'd like to access (such as pledges and projects) on a mobile device that CiviMobile can't.

We're with latest Drupal 7 and Civicrm 5.21


texts: Update DB Query fails sporadically when saving contact; nativecode=1205 ** Lock wait timeout exceeded

texts:
The exact query and issue is below.

UPDATE  civicrm_contact  SET contact_type = 'Individual' , contact_sub_type
= NULL , sort_name = 'XXXXXX XXXXXX' , display_name = 'XXXXXX XXXXXX'
, first_name = 'XXXXXX' , last_name = 'XXXXXX' , email_greeting_id = 6 ,
postal_greeting_id = 1 , addressee_id = 1   WHERE (  civicrm_contact.id =
27636 )   [nativecode=1205 ** Lock wait timeout exceeded; try restarting
transaction]

There are also a number of other "database deadlock" errors cropping up in the CiviCRM log.

Essentially, the person using the CRM is complaining that randomly they'll be editing a contact and it will fail to save, instead simply timing out (I haven't reproduced the behavior but I trust it).

After some research/reading, it appears CiviCRM has a contact_cache table in regards to Smart Groups it refreshes periodically via CRON. This specific CiviCRM install has thousands of contacts, and many large Smart Groups. So what I assume is happening is:

The site issues a "job" for refreshing the smart groups and data in the contact_cache table.
While the "job" is running, every single contact record affected by the smart group is "locked" in the database, and cannot be altered until the "job" finishes.
The user does not know the job is happening in the background, saves a contact, and produces an UPDATE query for the contact.
If the contact record is locked, it waits a certain specified amount of time (innodb_wait_timeout I believe) for the row to be unlocked, before failing the query altogether.

My problem is, if the above is true, I don't know how I can resolve the problem. Upping the timeout from 50 seconds to 120 seconds for example, would only increase the amount of time they wait for the request to fail, because the Smart Groups take over 120 seconds to be refreshed.

Other relevant info: Drupal 7, CiviCRM 5.9.1, PHP 7.0.33

Thanks!


texts: Event receipt has empty financial details

texts:
CiviCRM 4.7.29

"Events - Registration Confirmation and Receipt (on-line)" email has empty data for Price, Sub-total, tax and total.

But, if I re-send receipt later via contribution action 'Receipts - print or email', all values are correct.

Here is the custom template code, please help!

{assign var=pretax value=$totalAmount/1.20}
{assign var=tax value=$totalAmount-$pretax}

Description of Item	Price (excl. VAT)	Total Price (incl. VAT @ 20%)

{$event.event_title}

       {$event.event_start_date|date_format:"%A"} {$event.event_start_date|crmDate}{if $event.event_end_date}-{if $event.event_end_date|date_format:"%Y%m%d" == $event.event_start_date|date_format:"%Y%m%d"}{$event.event_end_date|crmDate:0:1}{else}{$event.event_end_date|date_format:"%A"} {$event.event_end_date|crmDate}{/if}{/if}

{$pretax|crmMoney}

{$totalAmount|crmMoney}

Sub Total
(excl. VAT)
{$pretax|crmMoney}

VAT @ 20%
{$tax|crmMoney}

Total
{$totalAmount|crmMoney}
 {if !$params.is_pay_later}PAID{/if}


texts: How to generate a receipt when Pay Later contribution is received

texts:
I am using a Contribution page to take payments for Memberships, and wish to use the 'Pay Later' option.  I can set this up and it records the contribution OK, and a administrator can record the Paymant when it arrives, thus actually starting the Membership.  However:

The system emails the user an Invoice when the Contribution page is completed, but I cannot get it to send a Receipt (or anything else) when the payment is confirmed.  Apart from anything else I want to (automatically) send an email at this point which will act as a membership card.

I have also tried the CiviRules extension, but can't find an appropriate combination of Trigger and Conditions to get the right result - i.e. only on Pay Later (Card payment generates a receipt immediately, fine), not if the administrator does the whole process off-line, and covering both initial Membership Payments and Renewals.

Thank you.


texts:
We currently have CiviCRM 4.4.6 installed with Drupal 7.36. Our version of CiviDiscount is 2.5.

Our issue is as stated in the title. Our discount codes stop working after about a day. It will start giving us fatal errors, the most recent being "/civi_extensions/org.civicrm.module.cividiscount/cividiscount.php on line 848".

If we delete the offending discount code and replace it either with the same code or a new one, it will work for a brief period before doing the same thing. This is becoming problematic as we have quite a few upcoming events that need discounts applied to them.

I'm not sure if this is a bug or related to the amount of discount codes we have in the system (~65).

It should be noted that we are in the process of upgrading to CiviCRM 4.7 and have a dev site up, however I haven't had a chance to see if 2.5 is a problem on that installation as well. We'll ideally be upgrading CiviDiscount to the latest version for CiviCRM 4.7, but until then, I need a solution to our current installation.


texts: How can I detect potential duplicates in a CSV I want to import?

texts:
I have a list of about 1000 contacts I'd like to import.  Unfortunately, there's no definitive way of linking the people on my spreadsheet to the contacts already in the database like an external identifier.  So I'd like to generate a list of potential duplicates so I can go over them by hand.

Does anyone have a good way to accomplish this?


texts:
The situation

I added a custom field to CiviEvents called regio (means region in English) and I want to be able to fetch CiviEvents by this field.

I'm on CiviCRM 4.6.6 and Wordpress 4.2.2

The problem

When I build the query using the API Explorer provided by CiviCRM, it always returns all CiviEvents, instead of only those to the selected region. This is the code the API Explorer generates:

$result = civicrm_api3('Event', 'get', array(
  'debug' => 1,
  'sequential' => 1,
  'custom_10' => 1,
));

This gives the following results:

{
    "is_error": 0,
    "undefined_fields": [
        "custom_10",
        "page",
        "noheader"
    ],
    "version": 3,
    "count": 25,
    "values": [{...}, {...}]
}

As you can see, it says that custom_10 apparently is an undefined field, although it is generated by the API Explorer. And by the way, there actually are CiviEvents of which the region is set to Rotterdam.

I have spend days trying to debug this, going through the full backtrace of this function, but couldn't find anything. Does anyone have any idea why this presumably standard Civi-feature isn't working?

This screenshot gives the full settings I made in the API Explorer.


texts: Can we export from membership search and include fields for groups?

texts:
I'm managing a country-wide organization's membership database with 1 membership type (you're either a member or you're not). Each region or province/state is represented by a Group.

This allows us to create an online roster (membership listing) that can be filtered by the regions across the country.

All of the updates to contact records and membership records (renewals) are handled via CSV imports.

For improving the maintenance of the CRM information, my goal is to run a search memberships report for current/new members which I can then split by region. I can then send the exec-admins governing each region their piece of the report so they will have a unified spreadsheet for managing addition and updates to the members they govern, making imports smoother to update contact records and membership renewals.

The issue I am running into is exporting a membership CSV spreadsheet that includes the all important Group or Group ID number. Any thoughts?


texts: Initialization Error after restoring a Wordpress site from backup

texts:
This morning, a plugin update broke the website, so we did a restore from a backup from the previous day. CiviCRM was working properly at the time, but now when we try to access it, we get the following error:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => simpleHandler
        )

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT *,  config_backend, locales, locale_custom_strings
 FROM civicrm_domain

 WHERE (  civicrm_domain.id = 1 )

 [nativecode=1146 ** Table 'frenchf_crm.civicrm_domain' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT *,  config_backend, locales, locale_custom_strings
 FROM civicrm_domain

 WHERE (  civicrm_domain.id = 1 )

 [nativecode=1146 ** Table 'frenchf_crm.civicrm_domain' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info="SELECT *,  config_backend, locales, locale_custom_strings
 FROM civicrm_domain

 WHERE (  civicrm_domain.id = 1 )

 [nativecode=1146 ** Table 'frenchf_crm.civicrm_domain' doesn't exist]"]
)

Any idea on what this means and how we can go about fixing it?
Thanks.


texts: Contributions made via Charitable gift funds

texts: My organization sometimes receives gifts from Donor Advised Gift Funds. We need to thank the individuals who are in the contacts table but also need to mention the source of the gift as being the Donor Advised fund. What is the best way to enter a contribution received in this way?


texts: better display of incoming email messages in database

texts:
Incoming email (e.g. mail imported into the database via the fetch_activities scheduled job) is stored in the database as plain text (which is great).

However, when you view an inbound email activity, it is displayed without any line breaks, which makes it very difficult to read, especially if there is a long reply thread.

Does anyone know of a way to tell CiviCRM to add line breaks (nl2br or something) for just this one activity type? Or any other suggestions on improving the readability of incoming email messages?


texts: Civicase not appearing in Spark despite being enabled

texts:
I have purchased CiviCRM Spark and have walked through the set up list. I have activated civicase and it isn't appearing on the menu at all. I've logged in and out three times and waited at least two hours.

Thanks.


texts:
Civi 5.15.1, Wordpress 5.2.3

I'm trying to get a list of all contacts who are not in any group (Smart or otherwise). I've done this two ways, with the same result: the first is by filtering the Constituent Summary report, and the second is using the Search Builder.

In either case, when I set the Group(s) filter to 'Is Empty', I get this message: "Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred."

And when I set the Group(s) filter to 'Is Null' (available via Search Builder only, not the report), the resulting list includes contacts who are in Smart Groups, whom I want to exclude.

I'd prefer not to use the Import Contacts workaround provided by Nicholai here:
How to find contacts with no group?

And @Xavier's extension based on it does not seem to be available anymore
(https://civicrm.org/extensions/lonesome-find-contacts-without-group).

Does anyone have any other ideas? Thanks!


texts: Configure cybersource payment processor using omnipay extension

texts:
Has anyone configured Cybersource in civi using the omnipay extension?

The setup from https://www.ryanplugins.com/how-to-setup-cybersource-secure-acceptance-profile/ seems to add a new profile but looks like the button is missing from our test/live account

Live URL - https://ebc.cybersource.com/ebc2/.

Test URL - https://ebctest.cybersource.com/ebc2/

On Payment Configuration -> Secure Acceptance Settings, I don't see any option to create a new profile. Is this even required?

On civi side, If cybersource pp is chosen from the list at civicrm/admin/paymentProcessor?reset=1&action=add, we get 3 fields to be entered for completing the setup - Profile ID, Access Key and Secret Key


texts: Civi 5.6.0 - wrong css z-index on Activities page when creating/viewing activity

texts:
CiviCRM 5.6.0
Joomla 3.8.12
php 7.0.32

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

Not a big deal, but needs fixing.

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


texts: Mailings are started but not sent - What is the difference between a scheduled job and "Run it now"?

texts:
Our scheduled mailings have stopped working. We upgraded to 4.7, but I'm not sure this has got anything to do with it. So I'll paint the picture, and the reason why I'm asking about jobs.

Mailings that we create are started by they job scheduler as the should. I.e mailing status is changed from Pending to In Progress. But no mailings are sent out.

However the following does sent a batch of mailings:

manually running the "Mailings scheduler" job from "Administer->Scheduled jobs"
calling the mailer function from a web call ("index.php&option=com_civicrm&task=civicrm/mailing/queue&reset=1")

Test mailings from mailing composer also works. So mail sending as such definitely works.

The "Mailings scheduler" job reports no errors. And the status change of the mailing is done by the "Mailings scheduler" as it should.

So I've been trying to figure out what is different between the two ways of running the "Mailings Scheduler" job. Why does dispatching from the job scheduler not work but running manually does, even though the scheduler says there are no problems?

In summary, if I create and schedule a mailing, with a cronjob that runs every 5 minutes:

the mailing is started correctly by the mailing job
no mails are actually sent
the mailing job reports OK on every invocation
a manual run of the "Mailings Scheduler" job from "Scheduled Jobs" sends one batch of mails correctly

It seems similar to this question, which has no accepted answer so far.


texts: CiviMail draft takes a really long time to save

texts:
We recently upgraded to Debian 9 so I think there are some server configs and tuning yet to be done. Originally draft mailings wouldn't save at all and I recreated the smart group that fed the recipients. I turned off the smart group caching job and created a smart group cache flushing job and changed the caching from opportunistic to deterministic, according to this article: https://civicrm.org/blog/eileen/478-group-contact-cache-deadlocks-improvement

It's the autosave function which I believe is also loading the 62,000+ recipients. Once they load, clicking "save" goes much faster. However, opening the draft and making an edit takes a long time to save again.

I checked the MySQL process that is running and there are two at play:

| 140355 | db_user | localhost | civicrm | Query   |  540 | Sending data | INSERT INTO civicrm_mailing_recipients (mailing_id, contact_id, email_id)
SELECT 953, i.contact_id,  |    0.000 |
| 140388 | db_user | localhost | civicrm | Query   |  540 | updating     | DELETE FROM civicrm_mailing_recipients WHERE  mailing_id = 946

I have cleared the templates_c and flushed caches. Let me know if I can provide any more clues or information. I'm worried about a database corruption. Nothing is being reported in the CiviCRM log for this transaction.

At the time of writing, the draft has been "saving" for about 20 minutes now.

Edit: After the save was complete, there was an error and backtrace in the CiviCRM ConfigAndLog log, which I am unsure if is related, so I'm editing the draft to see if the same error comes up which seems to be related to a specific user. The backtrace suggests it's related to a diffent issue I'm having when users get an unknown DB_Error after using a contribution form. I'm putting it here in case it's somehow related.

[debug_info] => INSERT INTO civicrm_email (contact_id , location_type_id , email , is_primary , is_billing , on_hold ) VALUES ( 139092 ,  1 , 'user@example.org' ,  1 ,  0 ,  0 )  [nativecode=1205 ** Lock wait timeout exceeded; try restarting transaction]

CiviCRM 5.7.2 on Drupal 7.62.


texts: Merge CiviCRM data from D6 to existing D7 database

texts:
I need to merge CiviCRM data from a Drupal 6 site into a Drupal 7 site that has an existing CiviCRM installation.
The sites are running under Aegir. In both cases the Drupal and CiviCRM tables are in the same databases. The D6 site is on Civi 5.24.3 with about 45k contacts with lots of organisation memberships + events records. The D7 site is on Civi 5.25.

I understand that I can do the laborious export/import process but am hoping someone has a recipe for a more efficient way.


texts: Drupal Domain Access vs Multi-Site in Civi

texts:
What is the best way to implement CiviCRM for multiple sites?
I'm a little familiar with Domain Access and less with Multi-Site in Civi.

I'd like to have two front-end sites share one CiviCRM database, with a user from site A having access to the complete database and a user from site B having only access to site B contacts and contributions.


texts: Listing events that only belong to a group

texts: I have CiviCRM 5.12 on drupal 7. I want to create a drupal view containing the next events that are printed if only the contact belongs to an authorized group. That is, when I create an event, I link it to a group with a custom field and in the view, I want to filter the events and keep those reserved for the group containing the contact corresponding to the user drupal.  Please can you help me ?


texts:
CiviMail likes to use VERP for bounce processing, but it looks optional because there's a checkbox for it on CiviMail Component Settings (where is the documentation for this screen??). Bluehost doesn't support VERP, but I found this thread, which explained how to comment out two lines in smtp.php. I did that and email blasts work now, but I did a test with a bad email address and it didn't bounce.

Can anyone explain the ramifications of commenting out those two lines? Will this ever work on a host that doesn't support VERP? Where is the documentation for CiviMail Component Settings? Thanks much in advance...


texts: Contributions "on behalf of an organization" automatically grant permissions -- can that be turned off?

texts:
I was asked whether it is possible to turn off the automatic permissions that are granted when someone fills out a contribution form "on behalf of an organization":

I assumed I could edit the Employer/Employee relationship and uncheck some permissions boxes there, but I don't see anything like that out of the box.


texts: How to create a recent new contacts report?

texts:
I'm trying to create a report of recent new contacts, ideally to make it available to our team as a dashboard widget.
I've managed to get a report with the results I want using the Contact Logging Report (Summary) template, but the columns in that (Action, Log Type, Altered By) will be fairly meaningless to the team, so I want the same results displayed with useful information each contact: things like Job Title, City, e-mail, phone, etc.
I've found an old answer that suggests the ability to add columns to templates doesn't exist in CiviReport. Is this still true? And if so, are there any work arounds or extensions that can achieve the same result? I've checked the Extended Reports extension, and even in there I can't find any templates that include both the contact fields and the logging information needed to get a list of recently added contacts.
I'm flexible as to how recent a list I get, as long as it can be sorted with most recent first. And I'm flexible as to exactly which columns I end up with, as long as they're ones that are meaningful to my users.


texts: Current members in expired membership search results

texts:
In our database, if expired members 'renew' (or rejoin) after their grace period, on their contact page, on the memberships tab, it shows both an expired membership and a current one. That is correct, I suppose.

If we then do a search for expired members, the rejoined member shows up. That is also correct. We would have to remember to always search for 'expired members - current members' to find those members that have expired and never rejoined.

People are going to forget this. What is the best way to help my client to not forget this ?


texts: I want to find a specfic group and get their email addresses

texts: I need to know how to request a specific group (Fundraisers) using their email address.


texts: Approach to dynamically filled custom field using member since date

texts:
I've been thinking about how to best approach this and I'm stumped as to how to best go about it.

I want to add a custom field to a profile that is rendered on the Contact Summary page. I would like to fill it dynamically with the value of the individual's earliest Member Since value.

NOTE: I say the earliest Member Since value because a bug in Civi has changed all Member Since values of currently active membership records to the date of the start of that membership record when they are renewed which ignores the concept that the individual may have had an earlier membership of a different type. The solution is to loop through all memberships and grab the oldest value to populate the custom field with it.

I'm well versed in building custom extensions and working in custom code. This is for a Drupal 7 / CiviCRM site. Any ideas or direction?


texts: How to set ckeditor text with javascript

texts:
Is it possible to set ckeditor text with javascript for a custom field?
I want to do something similar to the mail templates selection.
I try $('#custom_162_126').val('blub') but this only change the original field.


texts:
I'm getting the error: 'The sum of fee amount and net amount must be equal to total amount' when I'm trying to manually add a contribution. The calculation is correct.

Any help in resoling it appreciated.

Thanks,
Peta


texts: Unable to map fields when exporting to CSV

texts:
We are unable to map fields when exporting to CSV. Using Primary Field export gets us the standard csv, but when option to select fields for mapping is checked, seems to go into a loop (see attached screenshot). Cannot use a previously saved field mapping either.
We are running Civicrm 5.32.2 with Joomla 3.9.23 on PhP 7.4 server. Wasn't a problem before last Joomla/Civi updates.
thanks,
Kate
`


texts:
CiviCRM 5.3 (at the moment), Drupal 7.63 Mosaico Ext- 2.0-beta4.1528762072

View Mailing as browser link from emails working fine for logged in users, not for anon

Given view public mailing content prmission to all users. Flushed Civi and drupal caches

Still no access for anon users (yup, it's set as public pages)

Only new factor for me here is the mosaico extension. Anyone else had similar issues? know where else I can look?


texts: Include dates in a membership sign up form

texts: I have a contribution page set up to allow people to sign up for a new membership or renew a membership. The membership is a fixed period type. The user must either create an account or log in. I would like the Membership price option to show the dates (or year) that they are signing up for. Thus if they are a new member, it would should the current period (e.g. "2019 Membership") and if they log in as a current renewing member, it would show that future Membership dates they are choosing (e.g. "2020 Membership"). This is on a Wordpress site.


texts:
I have a customer who is an old-aged volunteer and is not so familiar to spreadsheets but still needs to use them until the whole database is imported and I want to make the export from CiviCRM easier to use for her.

I know this is a weird question because the first answer is: "don't use spreadsheet or at least learn how to use them" but I was wondering if there is a way / extension to help doing this:

export to excel with the possibility of choosing and arranging columns

Any Idea?

regards,

Guilllaume


texts: How can I remove the Billing Name and Address section from the donation form?

texts:
I would like to remove the Billing Name and Address section (which includes the fields First Name, Last Name, Street, City, Country, State, ZIP) from the donation page. What would be a good way to go about that?

The section shows when I am using a credit card payment processor (Stripe in my case).

I have tried commenting out the section from the smarty template /civicrm/templates/CRM/Core/BillingBlock.tpl. However, CiviCRM naturally still checks those fields upon form submission and gives an error that they are empty.

For background information, the reason for removing the section is that I noticed that the workflow of completing this section on a mobile device is extremely poor. It was difficult even for me to complete these fields on a mobile device - actually I quit trying after some effort. Additionally, our organization does not use this user data, so removing the section seems like a very good streamlining of the user experience without any disadvantage to the organization.


texts: Handling Customer Card Updates with Stripe Payment Processor

texts:
Does the Stripe Payment Processor handle customer credit card updates for recurring contributions? And does it depend on whether I'm using Civicrm 4.6 or 4.7?

I see this page from Stripe:
https://stripe.com/docs/recipes/updating-customer-cards

Not sure if it is implemented in the Stripe extension.


texts: How to allow a user 'edit' on activities?

texts: Users have ACL 'edit' access to a group, and can access the contacts in the group OK.  They can create an activity, but then cannot edit it - for each activity they just get 'View' and 'File on Case' possibilities and not 'Edit'.  There are no  permissions to edit activities - only view and delete.  How can I allow them to edit activities?  Using 5.6 and Drupal


texts: Will Installing Updates in Civi and Drupal mess up my website?

texts:
I know I need to update Civi (5.17.5) and Drupal (8.7.8) - My question is, is there anything I need to be aware of -- changes with the site or with Civi in the background -- that will alter how we use these sites? Or will largely nothing change what I have going on?

Thank you!


texts: Retrieve all phone info through PHP object-oriented API

texts:
How can I retrieve all the phone numbers for a contact using the PHP object-oriented API?  I'm only seeing the primary phone available in the API explorer.  I want to be able to create a directory of everyone in a certain group, including all their phone numbers, with labels like "home", "work", "mobile".

My query currently looks like this:

$api->Contact->Get(array(
             'group' => 6,
             'sequential' => 1,
             'rowCount' => 100,
             'return' => 'custom_4,display_name,email,phone,'.
                   'street_address,city,state_province,postal_code',
             'sort'=>'custom_4,last_name,first_name'));

Thanks.


texts: Civi contribution details correct but why does Paypal log show wrong name?

texts:
So, person 1 pays membership fee using credit card via Paypal standard.  Transaction goes through fine. Membership record is updated correctly

On the Paypal log however the payment show as for person 2; but when you drill down it then shows it correctly for person 1.  In Civi, Person 1 and Person 2 have a relationship

Out of a few hundred recent payments I can see 2 that this has occurred for: its not a show stopper but Im curious about why?


texts: How to add a secondary Case Role that has access to Activities they are not 'on', eg ones that existed before they were added

texts:
We want to add a secondary case role that is similar to Case Manager with slightly less permissions (eg cannot change/add case roles, can't delete case etc).
We have a relationship that can be added as a case role in the case settings.
People that have this new case role also have a drupal role. Their permissions are currently "access my cases and activities" , "view all activities.
However when they look at a case they are the new Case Role for they can see all the activities listed for the case, but don't have the option to go and 'view' the activity's details (unless they are a contact listed on the activity).
We want them to be able to view the activity details for the case.

When we find the relevant url that would give a Case Manager access to the activity, and test that url as this other user then we get "do not have permission to access this page" - eg url of type /civicrm/case/activity/view?cid=XXXX&aid=YYY

Thoughts?


texts: API csv Import GUI with Formprocessor fails with smarty errors

texts:
I created a rather complicated form processor which works (through api), but when I tried to clone it (rename it to create so csv api picks it up) and tried to do the csv import.
I get the following error for each row (in the download errors)
Error with entity "create"! (Action Donor info failed. Caused by PHP Error 256 at /var/www/mysite/sites/all/modules/civicrm/packages/Smarty/Smarty.class.php:1100: Smarty error: [in evaluated template line 1]: syntax error: unrecognized tag 'n' (Smarty_Compiler.class.php, line 585))

When I tried it with the same data using just formprocessor API it works, but through CSV API Import GUI it doesn't.
How would I go around debugging this. Or should I even bother? I mean it might be easier script API calls.
I always thought CSV API and Form processor would be a powerful combo.


texts: How do I add custom fields to Personal Campaign Pages

texts:
I bet that's a question that some people have asked before!

The answer is you can't currently.

But how would someone add this capability?


texts: CiviCRM does not have full functionality support for refunds and partial payments so what is the current way to tackle this type of situation?

texts:
I have applied as a GSoC student to work on a project that would provide Refunds and / or Partial Payments functionality for CiviCRM. I am seeking current solution to do this when needed so I can suggest and develop better solution. What is the manual way to use negative contributions for refunds as according to me this situation could have occurred several times.

Similarly, how are partial payments handled now with work-arounds?


texts: CiviCRM 5.2.2 System Status gives Incorrect Resource URL (Drupal 7.5)

texts:
CiviCRM 5.2.2 (drupal 7.59, ubuntu 16.04.01, mysql 5.7.22, php 7.0.30)
  CiviCRM System Status gives:
Incorrect Resource URL
The Resource URL is not set correctly. Please set the CiviCRM Resource URL.
Cause: In sites/all/modules/civicrm/CRM/Utils/Check/Component/Env.php
$arrowUrl = CRM_Core_Config::singleton()->userFrameworkResourceURL . 'packages/jquery/css/images/arrow.png';
$headers = get_headers($arrowUrl);
is returning an empty array.
sites/all/modules/civicrm/packages/jquery/css/images/arrow.png exists
Site seems to be working Ok otherwise.
Thanks for your help.


texts: Using checksums to access the civicrm/user dashboard

texts:
I was under the impression that adding

https://civicrm.org/civicrm/user?reset=1&cid={contact.contact_id}&{contact.checksum}

to in a CiviMail would log someone in to the dashboard but it does not seem to be working for me.

This answer also suggests it so maybe I am doing something wrong.

PS I also tried id in place of cid (see below) but it did not work either.

https://civicrm.org/civicrm/user?reset=1&id={contact.contact_id}&{contact.checksum}

PS https://github.com/civicrm/civicrm-core/blob/master/CRM/Contact/Page/View/UserDashBoard.php does not mention checksums so i am guessing it is not possible...


texts: Where can I download the latest version of CiviCRM?

texts:
I'm trying to install Civi 4.6 with Drupal 7, using the instructions in the wiki page referenced in the title.  In step 2, it says:

  As administrator in Drupal, go to Modules, click on Install New
  Module, and it will ask you to fill in the URL of the module. It will
  then fetch it and install it for you. You will need to enable the
  Update Manager module in the drupal modules page to see the Install
  New Module link.

  The current link is
  http://sourceforge.net/projects/civicrm/files/civicrm-testing/4.6.alphax/.
  You will need to replace 4.6.alphax with the current minor version
  number.

  Hit the Install Button.

Apparently the current minor version is alpha1, so I enter http://sourceforge.net/projects/civicrm/files/civicrm-testing/4.6.alpha1/, and hit Install.  I get:

  Cannot extract temporary://update-cache-b2aa7d22/4.6.alpha1, not a
  valid archive.

Maybe I should add that I'm trying to install this on my account at the web host webfaction.com.  Not sure if this makes any difference.

Advice?


texts:
I'm using CiviCRM 4.7.31 on WordPress with the Members plugin. I created a new profile, then embedded that form in edit mode within a WordPress page:

[civicrm component="profile" gid="35" mode="edit" hijack="0"]

As expected, the WordPress page generates an error if a user is not logged in:

  "No user/contact ID was specified, so the Profile cannot be used in
  edit mode."

This error persists even when I set the page's Content Permissions to limit access to users in selected roles.

The error disappears when I wrap the civicrm shortcode within the members_logged_in shortcode:

[members_logged_in]
[civicrm component="profile" gid="35" mode="edit" hijack="0"]
[/members_logged_in]

But then the profile form loses its formatting; it seems like some Javascript/CSS is not loaded on the page when the shortcode is nested.

Is there a way to make this work correctly? Do I need to switch to Caldera Forms with the Caldera Forms CiviCRM plugin?

Thanks for your help.


texts:
I have the latest version 5.1.1 of civicrm.
A problem that kind of slipped past our organization in the past is that the page for opting out has been always in English.  Mostly people opted out still without a problem, because I guess most Slovaks know enough English to handle that sort of thing, but there would be occasional emails from people asking to unsubscribe that my boss/wife would get complaining about the opt-out process.
I though I had fixed it through setting CiviCRM to follow the Drupal language, which defaulted to Slovak unless I was logged in. Now I realize that just fixed everything but the text of the opt-out page.  So I've just changed default language of civicrm to be only Slovak and never change, and for good measure, set Drupal to just be in Slovak. (I can handle it after 8 years of living in Slovakia and learning the language!).
But still, my testing shows me the page for opt out is always in English:

The link for optout sent was:
https://info.cbreurope.sk/sk/civicrm/mailing/optout?reset=1&jid=somenumber&qid=somenumber&h=somenumber
What am I missing?  BTW, we are using the Mosaico plug in for sending emails. Could that be a problem?  Drush is running the cron jobs.


texts:
I enabled "Billing address required" on my event. Registering now shows fields to fill in.

But where do I look to retrieve it? It's not in the registration nor in the payment info, as far as I can see.


texts: Insert file into greeting field with Smarty

texts:
When the content of the Email Greeting or the Postal Greeting field is getting too long, CiviCRM is no longer able to edit it through the GUI, what happened since I have activated Smarty and inserted large expressions.
I want to have a standard greeting that works for every gender, language and style.
This was working:
{capture assign=language}{contact.preferred_language}{/capture}{capture assign=prefix}{contact.individual_prefix}{/capture}{capture assign=style}{contact.communication_style}{/capture}
{if $style == 'Formal'} {if $language == 'fr_FR'}Cher{elseif $language == 'nl_NL'}Geachte{else}Dear{/if}  {$prefix|replace:'De heer':'heer'|replace:'De heren':'heren'|lower} {contact.last_name}{else}{if $language == 'fr_FR'}Bonjour{elseif $language == 'nl_NL'}Dag{else}Dear{/if} {contact.first_name}{/if}

but the expression is getting too long when I try to add a test about the gender. As a work around, I decided to put this expression inside a file to be included by Smarty with this expression:
{include file='/usr/share/drupal/sites/default/files/my-greeting.tpl'}

but this doesn't work: nothing is included. The file /usr/share/drupal/sites/default/files/my-greeting.tpl has the correct ownership and permissions.
I would like to understand what I am doing wrong, and if it is possible to use this approach without opening a hole in the security of the system.


texts: Civicontribute registration module with wordpress

texts: i created a contribution page, but when an user fills out the fields and pays we receive the paypal advice only without the user data registration. How to solve it?


texts: New membership page as default Drupal register page

texts:
Our non profit organisation has members who should have full access tot the web site.

We created in civicrm a contribution page with

no "contribution", only "membership" information
a choice between three types of membership
a civicrm profile with extra fields (address, phone number, birth day...)

Now, my question: how to get this page when the visitor goes to the Drupal register page? For the moment, only the civicrm profile is displayed, not the choice of the membership type.


texts: how do I make the FROM box on a bulk email show the same list as a single email?

texts: I toggled the yes/no box "Allow mail from logged in contact" to yes, but it doesn't affect the "new mailing" screen which is really the most important one for me. Can I change this somehow? Is there another yes/no somewhere? If not can I put in a feature request for it?


texts: Database error when using CiviCRM admin UI: "Row size too large"

texts:
I'm helping on a site that is on a different server than usual and see this error regularly in the back end when trying to complete various tasks (e.g. clear caches, run database updates, etc.)

[debug_info] => TRUNCATE TABLE civicrm_menu [nativecode=1118 ** Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.]

The site is mostly working, but as mentioned many tasks error out and the above shows in the debug log. What could cause this?


texts: access denied on member signup with civicrm for anonymous

texts:
My question has to do with Civicrm member signup page. I am getting an error for anonymous users that they are not allowed access to the page.
I am using Drupal 7 and CiviCRM 5.3. I am relatively new to Drupal. The site is located on a domain that is being used simply for testing purposes.
I have researched this already and have not received much in the way of finding anyone with a similar issue. Other then seeing posts about user 0. I checked and user 0 is there and seems fine.
As part of trying to resolve the issue I also setup a mock event. Same thing happens on that also. An anonymous user can see the event but as soon as the registration page is clicked it gives the access denied message.
I have also checked the permissions and roles and anonymous is allowed to access the pages. In other words sign up for events and make contributions is checked.
Here is the page for the membersignup. https://hebrewburialofnewhaven.org/civicrm/contribute/transact?reset=1&id=1
Event info page https://hebrewburialofnewhaven.org/civicrm/event/info?reset=1&id=1
Event registration page https://hebrewburialofnewhaven.org/civicrm/participant/add?reset=1&action=add&context=standalone&eid=1
This is the actual site https://hebrewburialofnewhaven.org/#
Please keep in mind this is only a development site and not a production site. We are testing using Drupal with Civi. Because wordpress has really become very resource intensive and seems to have a lot of issues running civi cleanly.

I thank everyone for any help or guidance on this. It is probably something stupid I am missing or didn’t configure.


texts: Network Error when pushing CiviCRM button

texts:
I’m having the same issue as what appears to be listed here:

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

I get the same "Network Error" message every time I press the CiviCRM button on the WordPress 'new page' screen when using Chome, FF, and Safari. Perhaps it is an admin or setup error on my part, and not a CiviCRM issue.

I took a screen shot that includes the browser console log if it might be helpful.


texts:
I have a site I am working on and sometimes the URLs are being changed &amp;id=X rather than &id=X.  For example, https://secure.domain.org/civicrm/event/register?reset=1&amp;id=15 .

I am not sure how this happening. Any help on how to get CiviCRM to recognize either is appreciated.

I am running CiviCRM - 4.6.24 and Drupal - 7.52.

Thanks,
Steve


texts: Member URL slug pulling a website and breaking the link?

texts:
I have a member signed up to the website and their profile won't display. Upon checking the URL slug it looks like it's pulling her website instead of her user name but after whipping around on the backend I cant find anywhere apparent to change that. Hoping y'all might be able to help.
The URL in reference is :  http://musicnovascotia.ca/member-profile/https://www.shirleyjackson.ca
Most other users would display "member-profile/username
Example:
http://musicnovascotia.ca/member-profile/hillsburn
Any ideas as to why this is happening? Thanks in advance!


texts:
USAGE:  I've created a Profile that includes the global Tagset.  I'm using it to designate a Region Tag for all Contacts as we roll out a directory.  The Tags have values such as "Northeast", "Northwest", etc.

PROBLEM:  When a user saves their information using the Profile, the Tags selected are not saved in CiviCRM and thus the Tags selected are not shown also in their confirmation.

BACKGROUND

I have tested that I can save Tags to a Contact within CiviCRM
through the backend.  All other fields are being saved correctly.
Using CiviCRM 4.7.30, WordPress 4.9.4
I have reviewed my WordPress permissions regarding 'tags', but willing to recheck or check others.


texts:
I disabled, and re-enabled CiviGrant and now I can no longer access it.  I tried to rebuild the menus and actually reproduced this on the demo site: Its not just the Grant and Grant Admin menus.  if i try to use a link I get access denied.  The grant component is working at the API level.
Any suggestions on how to recover the component?


texts: Google Checkout disabled but causes Network Error loading Membership tab

texts:
Payment processor Google Checkout is disabled, but Civi is still trying to load its file which doesn't exit:
PHP Warning:  require_once(CRM/Core/Payment/Google.php): failed to open stream: No such file or directory in /wp-content/plugins/civicrm/civicrm/Civi/Payment/System.php on line 59

Can I safely delete that payment processor without affecting any contributions that used it (there doesn't appear to be any FKs tying them together)?
Wouldn't it be better to not check for disabled (not supported anymore) processors?


texts: Webform: Enabling a contact to register for multiple participants

texts:
I'm trying to create a webform that has one contact and allows the selection of multiple "tickets" to an event that we don't need contacts for. The spaces are free if that makes any difference.

This in civi would then count multiple participants per contact as it currently does when registering for events directly through civi.

Thanks,
Stuart


texts:
My site goes to maintenance mode spontaneously almost every day. I am advised by users.

Everything works fine when I put it out of maintenance mode.

Any explanation is welcome

(Drupal 7.59 / Civicrm 5.4.0)


texts: No displayName after editing or creating

texts:
Since the last CiviCRm version 4.7.21 to 4.7.23, I have the display_name empty. There is also the trouble for the sort_name.

I found the report of  SarahG (FountainTribe) here https://forum.civicrm.org/index.php?topic=33928.msg143820#msg143820
It states that :

  The return value from "CRM_Utils_Address::format" is returning an
  empty string for the display name and the sort name. Those empty
  strings cause the calling function to use email address instead.

I applied her solution :

In the file /CRM/Contact/BAO/Individual.php (around 210 -215)
I replaced the line:
Code:
$displayName = CRM_Utils_Address::format($formatted, $format,  FALSE, FALSE, TRUE, $tokenFields );

New line:
Code:
$displayName = $firstName." ".$lastName;

Did similar replacement for the $sortName variable.

This solved the trouble. But as she stated, it is only a temporary solution.

Does anyone still encountered this issue with CiviCRm version 4.7.23 ?


texts:
How could I search for X activity type custom field and only return the last activity created if the record has more than 1 X activity type?

I envision creating a smart group out of this data.

My use case is tracking user preferences and if they do a 180 degree on their preference, I would only want to consider their last preference change. I could use a static custom field but that will not track longitudinally. The worst case is I could store data in both and send data to both custom fields...


texts:
I know this should be straight forward, but somehow I seem to struggle.
Importing a child-parent relationship.
I have 10 children records (External ID, Child Name, Child Surname) and 5 parent records (Parent Name, Parent Surname, Parent Mobile Number, Subtype).
I used https://dmaster.demo.civicrm.org to import the 10 children records first. I then did another import for the 5 parent record:
I got an error message: External ID already exist in the database
So, 0 records were imported.
So, I tried again. This time I selected Update for For Duplicate Contacts
According to the message, 20 records were created or updated. Thus, I ended up with 20 records.
I thought that there should be 15 records. For example, if parent A has two children (Child 1 & 6), then there should only be one record for Parent A and when we click on Parent A, it should show that Parent A is the parent of Child 1 and Child 6.
At the moment there are two records of Parent A. When you click the one record it shows that Parent A is the parent of Child 1 and when you click on the other record of Parent A, it shows that Parent A is the parent of Child 6. The following are the records for the Parents:
When I selected Fill for For Duplicated Contacts, 20 records were created or updated.
Any guidance will be provided or should it be 20 records.


texts: Can't administer cividiscount afer upgrade to 4.7.7

texts:
I've recently upgraded to 4.7.7 and it seems this has caused me to be unable to administer cividiscount. Current discounts are working, the extension is listed properly, there are/were no errors at any point. It's just when you go to the cividiscount URL you get the main civiCRM dashboard!

Previous version was 4.7.4, cividiscount version in 3.2 running on Drupal 7.43

I have noted a similar question here same sounding problem on a different version, no solutions.

How do I even start finding out what this is? do I need to turn on some sort of debugging and look at lots of logs?


texts: Can a contact be matched with a campaign

texts:
Is it possible to match individuals with campaigns?

Example: I create an event, can assign contacts to this event with a role.
So I have the overview which contacts have participated.

Is it also possible to assign contacts to a campaign? So that I can see who participated and what role he had?


texts: Smart Group criteria disappearing or changing

texts:
We've been using a number of smart groups created via the search builder and from time to time, the smart group criteria disappear or are changed. For instance, we had five similar smart groups based on membership in five different groups with a certain contact type. At some point, the criteria changed for all five smart groups to membership in group 0.

We've had occasional similar issues for years, with no obvious trigger for the change. Does anyone have any idea what might be happening? Has anyone else had the same issue?


texts: Can Honoree type and name be inserted into the Contribution email receipt?

texts:
I feel like this might exist but I can't find it:

What's the best way to insert honoree information in a thank-you letter to a donor? Especially for batch thank you letters.


texts: Installation error for CiviCRM in Wordpress

texts:
I have searched for answers and none apply to this particular instance. I get one particular error preventing me from installing CiviCRM in WordPress. I have the latest version of CiviCRM and WordPress. I get the following error under file permissions no matter what I do:

Is the /home/tackletheagenda/public_html/Civicrm/wp-content/plugins/files folder writeable?

The user account used by your web-server - tackletheagenda - needs to be granted write access to the following directory in order to configure the CiviCRM settings file:
//home/tackletheagenda/public_html/Civicrm/wp-content/plugins/files

I have already verified that the folders were writable. A bug? Other people had this problem on other platforms, but no answers for this problem in WordPress.


texts: Save/submit button when profile is set to "view"

texts:
One gets "Save" and "Cancel" buttons when adding a profile in "edit" mode.
I'd like to see the same when presenting a profile in "view". Why? The client checks the entry and can then submit it - if changes have to be made, they go back to an editable profile page, just looks nicer in "view".
I've played around a bit with scripting - but no luck given little programming intelligence.
Any idea - this is all on a Wordpress platform.
Cheers


texts: Finding contacts without relationships (API)

texts:
How can I find contacts using the APIv4 that don't have any relationships of a specific type?
I want the first n contacts ordered by a date field meeting various conditions excluding those with a relationship of type X.
There are various ways it could be done with multiple calls or php looping but it would be nice to be able to do it in a single call.
In SQL one option using a subquery is:
SELECT * FROM Contacts
WHERE <various things>
AND contact_id NOT IN (SELECT contact_id_a FROM Relationships WHERE <conditions>)
ORDER BY <something>
LIMIT <n>

Can APIv4 produce something like that?


texts: How can I track down a script or form that's generating empty contact records?

texts: Every 10-15 minutes a new, (almost) blank contact record is being generated in civi. The only clue I have is that the blank record is subscribed to our mailing list. Any ideas?


texts: SQL Error in Contribution Details Report

texts:
Can someone help me resolve this error? I have recently started using CiviCRM but the website has been up for years. Thanks for helping. Arthur

Running CiviCRM 4.7.27 with Wordpress 4.8.4

On the Contribution Reports/Contribution Details see the following error in the log when trying to view results.

[type] => DB_Error
[user_info] => CREATE TEMPORARY TABLE civireport_contribution_detail_temp2  DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci AS SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_sort_name, contact_civireport.id as civicrm_contact_id, email_civireport.email as civicrm_email_email, phone_civireport.phone as civicrm_phone_phone, contribution_civireport.id as civicrm_contribution_contribution_id, contribution_civireport.financial_type_id as civicrm_contribution_financial_type_id, contribution_civireport.currency as civicrm_contribution_currency, contribution_civireport.receive_date as civicrm_contribution_receive_date, contribution_soft_civireport.amount as civicrm_contribution_total_amount_sum, 'Soft Credit' as civicrm_contribution_contribution_or_soft, address_civireport.country_id as civicrm_address_country_id
  FROM  civireport_contribution_detail_temp1 temp1_civireport
  INNER JOIN civicrm_contribution contribution_civireport
    ON temp1_civireport.civicrm_contribution_contribution_id = contribution_civireport.id
  INNER JOIN civicrm_contribution_soft contribution_soft_civireport
    ON contribution_soft_civireport.contribution_id = contribution_civireport.id
  INNER JOIN civicrm_contact      contact_civireport
    ON contact_civireport.id = contribution_soft_civireport.contact_id

  LEFT JOIN civicrm_phone phone_civireport
  ON (contact_civireport.id =
  phone_civireport.contact_id) AND
  phone_civireport.is_primary = 1

             LEFT JOIN civicrm_address address_civireport
                       ON (contact_civireport.id =
                           address_civireport.contact_id) AND
                           address_civireport.is_primary = 1

        LEFT JOIN civicrm_email email_civireport
               ON contact_civireport.id = email_civireport.contact_id AND
                  email_civireport.is_primary = 1

WHERE (1) AND ( contribution_civireport.contribution_status_id IN (1) )  GROUP BY contact_civireport.id, contribution_civireport.id, email_civireport.email, phone_civireport.phone, 'Contribution', address_civireport.country_id [nativecode=1055 ** Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'civicrm.contribution_soft_civireport.amount' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]


texts:
I'm using a new installed CiviCRM 4.7.8. with Drupal 7.5  ( Database system version 5.7.12-0ubuntu1 - PHP   5.6.22-4+deb.sury.org~xenial+1  )

The installation was done without errors but now I get:

Notice: Undefined index: values in _civicrm_api3_api_resolve_alias() (line 2310 of /var/www/html/sites/all/modules/civicrm/api/v3/utils.php).
Warning: Invalid argument supplied for foreach() in _civicrm_api3_api_resolve_alias() (line 2317 of /var/www/html/sites/all/modules/civicrm/api/v3/utils.php).
Notice: Undefined index: values in _civicrm_api3_api_resolve_alias() (line 2310 of /var/www/html/sites/all/modules/civicrm/api/v3/utils.php).
Warning: Invalid argument supplied for foreach() in _civicrm_api3_api_resolve_alias() (line 2317 of /var/www/html/sites/all/modules/civicrm/api/v3/utils.php).

on clicking "New Mailing".

Any idea what's wrong or how to solve this error?

Thank you


texts: How to retrieve all contacts belonging to a smart group

texts: Given the ID of a smart group, what API/BAO/whatever do I need to use to retrieve all contacts belonging to that group? I've been looking through the source code all morning and can't seem to find what I need. Thanks.


texts: Are there public repos including WordPress WooCommerce and CiviCRM integration code?

texts:
On a WordPress / CiviCRM installation, we need to do a bunch of customization on its payment pages. We want to do it in WordPress since there are WordPress plugins that can help do things like validate addresses and calculate sales taxes that are not yet available in CiviCRM, and the budget is constrained. The main integration we want is to write to CiviCRM 1) contact info, 2) invoice data for memberships, participants, and 'contribution' items like book purchases, and 3) payments received.

We're going to start by upgrading the CiviCRM API to allow multiple line items including Sales Taxes to be added properly.

Is there a good starting repo for the WordPress plugin anywhere? I've contacted Josh at http://www.joshcanhelp.com/wordpress-ecommerce-site-integrated-civicrm-migrated-drupal-6/#comment-30644. Alternatively, custom non-generalized implementations would also be fine.


texts: Solved: CiviRules 2.1 and CiviVolunteer 4.7.31-2.3.1 not working with CiviCRM 5.4.0

texts:
I'm using WordPress 4.9.8 and I've upgraded our CiviCRM to 5.4.0. After that CiviRules 2.1 and CiviVolunteer 4.7.31-2.3.1 seem not working.

1. CiviRules 2.1, when click New rule, it backs to CiviCRM homepage

CiviRules> Find Rules> could find Rules but can not edit existed Rules. It only shows empty windows like this:

CiviRules> CiviRle Tags work ok

2. CiviVolunteer 4.7.31-2.3.1

Volunteers> New Volunteer Project: Go back to CiviCRM homepage

Volunteers> Manage Volunteer Project: Go back to CiviCRM homepage

Volunteers> Configure Roles> work ok

Volunteers> Configure Project Relationship work ok

Volunteers> Configure Volunteer Settings: Go back to CiviCRM homepage

Volunteers> Volunteer Interest Form: Go back to CiviCRM homepage

Volunteers> Search for... Go back to CiviCRM homepage

Please check and help to fix

Solution: I've follow Aidan's comment: Clearing the caches by go to Administer > System Settings > Cleanup Caches and Update Paths > Cleanup Caches
And all works ok now


texts: Relationships not visible after migrating from Wordpress to Drupal

texts:
I have migrated a CIVICRm installation from Wordpress to Drupal. Everything is working except the relationship tab under contacts.
The tab heading has the number of relationships but no relationships are visible.

Also I can see the relationship in the relationship report.

How do I fix this as there no error being logged

Thanks


texts: how to change the size of groups for ab testing?

texts:
I've started a test with a sample too small to be statistically significant. I would like to re-run the test but with a bigger one.

however, I would want to exclude those that already participated to the initial a or b test. when I clone, I can exclude from previous mailings, but only from the final, not from the a or b tests. is there a way to do that?


texts: Event registration form - How to make one field appear only if another checkbox field was ticked?

texts:
In an event registration form, I have some fields which are only relevant in case the user have ticked a specific checkbox (another field).
How can I make these fields appear only when he ticks this checkbox, and disappear if he unticks it?


texts: Recurring contribution every 4 weeks? Or 'First Friday of Month'?

texts:
I use civicrm for a union, and a lot of our members like paying their membership dues the day they get paid.

Is there a way to set up a recurring contribution to be something like 'once every 4 weeks, starting on x date, but not exceeding more than 1 a month?'  Or 'First Friday of the month' or '3rd weds of the month'?

Thanks for any ideas!


texts: CiviCRM does not have permission to write temp files - halts the system

texts:
My website stopped working due to a CiviCRM problem, all I see is:
"CiviCRM does not have permission to write temp files in ...wp/wp-content/uploads/civicrm/templates_c/en_US/,exiting"
My hosting service may have recently updated to php 7.4.
Seeing old solutions to this problem, I deleted all the folders in wp/wp-content/uploads/civicrm/templates_c/en_US/
but left .htaccess unchanged.
That did not solve the problem.
Should I delete everything in .../uploads/civicrm/templates_c/
Has anybody had this problem and fixed it?


texts:
I am having trouble sending email to addresses in our own GSuite domain.  They bounce with a "syntax" error, and the addressee gets flagged as ON HOLD.

Using CiviCRM with Wordpress, current versions.

Any ideas, friends?


texts: How can I most easily import Activities and Contacts together?

texts:
I'm working on some scripts to export data from our current CMS (a custom in-house tool) to CiviCRM. This is a first import, and CiviCRM is a blank slate.

When importing activities it seems like the "Source Contact" column must be a civicrm ID.

I think this means I have to first import all the contacts, then pull a mapping from their CiviCRM ID to their external ID, and then import activities with the source contact column updated to match the CiviCRM ID.

Of course, this is entirely feasible, but if there's a simpler way to do this I'd love to know about it.


texts: Limit is ignored in civicrm_api3('Membership', 'get')

texts:
Can anyone explain why limit here has no effect?  Still get 25 results every time.  Also tried 'api.Contact.get' => array(array('limit' => 1000))

Using offset to recurse through the set works but is a nuisance.

 require_once $_SERVER['DOCUMENT_ROOT'] . '/wp-content/plugins/civicrm/civicrm.settings.php';
 require_once $_SERVER['DOCUMENT_ROOT'] . '/wp-content/plugins/civicrm/civicrm/CRM/Core/Config.php';
 $config = CRM_Core_Config::singleton( );
 require_once $_SERVER['DOCUMENT_ROOT'] . '/wp-content/plugins/civicrm/civicrm/api/api.php';
 $result = civicrm_api3('Membership', 'get', array(
    'membership_type_id' => "$level",
    'limit' => 1000,
    'api.Contact.get' => array(),
 ));


texts: Failure to install CiviCRM on a clean new Wordpress site, running on Debian Jessie. Installation activation went to a blank page

texts:
Using Let's Encrypt for ssl, no problems with WordPress.  Installation and plugin activation for CiviCRM  led to a blank page. Apache2 log looks like this:

[Wed Jul 05 13:58:40.895212 2017] [ssl: warn] [pid 30451] AH01909: p:443:0 server certificate does NOT include an ID which matches the server name
[Wed Jul 05 13:58:40.922645 2017] [ssl: warn] [pid 30452] AH01909: p:443:0 server certificate does NOT include an ID which matches the server name
[Wed Jul 05 13:58:40.924775 2017] [mpm_prefork: notice] [pid 30452] AH00163: Apache/2.4.25 (Debian) OpenSSL/1.0.2l configured -- resuming normal operations
[Wed Jul 05 13:58:40.924794 2017] [core: notice] [pid 30452] AH00094: Command line: '/usr/sbin/apache2'
[Wed Jul 05 14:04:22.208994 2017] [:error] [pid 30478] [client 176.126.252.12:40655] PHP Fatal error:  Uncaught CRM_Core_Exception: [0: Found installation canary. This suggests that something went wrong with tracking installation process.
[Wed Jul 05 14:06:40.022932 2017] [:error] [pid 30464] [client 176.126.252.12:60919] PHP Fatal error:  Uncaught CRM_Core_Exception: [0: Found installation canary. This suggests that something went wrong with tracking installation process. Please post to forum or JIRA.\n\n  thrown in /var/www/wp-content/plugins/civicrm/civicrm/Civi/Core/InstallationCanary.php on line 53, referer

Checked ownership and permissions on plugin files.  Nothing unusual there.


texts: How can we Make separate option for standing Orders

texts:
Is there any way to make a separate option for the orders which are not delivered yet or standing orders in civi.

Thanks in Advance


texts:
Is it possible to run a cli.php without user and password if cron owner has sufficient privileges? Having added it my Joomla dashboard is over run with entries for the cron user logging in. The user I created I didn't give any special acl but it seems to work. I'm assuming due to my cron rights. Suggestions?
Thanks
Wallace


texts:
I'm new to CiviCRM and I'm trying to help a non-profit clean up what looks to be a very large number of duplicate contact entries.  I have searched this site and a few other resources and I have a grasp on the process, as I understand it.  While I'm new to CiviCRM, I have worked with many other database and CRM solutions.  Here are the two questions I have:

1) What are dedupe exceptions?  While most things related to CiviCRM and dupe are well documented, I've not located an explanation for this.  I assume it is some sort of white list of possible dupe contacts?  What happens when I remove the exception?  Do they become "eligible" for the dedupe rules engine?

2)  None of the General rules that have been setup will work.  The Supervised/Unsupervised rules work just fine when I use them manually.  What I'm experiencing is basically a very long period where I'm waiting on the database followed by an unable to perform at this time message.  Any thoughts on using General Rules.  I have tried various approaches but basically trying to match on 3-4 fields.  I understand the weight/threshold approach but it doesn't seem to be linked to that as much as to General rules. None of the rules I have setup nor the ones that existed before me seem to work as General rules.

Thanks in advance and please take it easy on a noob.   :)

Dave


texts: I run a small but growing non-profit and I was looking into CIVICRM as our much needed CRM system. Now I know no coding at all, can I still custumie and use CIVI or do I nedd to know coding?TY!!


texts:
If the Civi user isn’t logged into their account then they get the following error when clicking token inside their email footer:

Sorry, due to an error, we are unable to fulfill your request at the moment. >
You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
A fatal error was triggered: is not of type Text
Return to home page.

The link being generated in the mailing is:
https://example.org/civicrm/mailing/optout?reset=1&jid=15266&qid=6919138&h=e77ea82acfec8278
Is this expected behavior?


texts: Need help upgrading 4.4.5 to 4.7.18 0n Ubuntu 16.04 server with PHP 7 on Drupal 7

texts:
The VPS host running Drupal/CiviCRM was upgraded from Ubuntu 14 LTS to 16 LTS.  That ran without error. However, that upgrade came with PHP7.  immediately after the upgrade all three CiviCRM sites experienced The following Drupal Log error:

"ParseError: syntax error, unexpected 'clone' (T_CLONE), expecting '(' in require_once() (line 1 of /var/www//sites/all/modules/civicrm/packages/DB/DataObject.php(207) : eval()'d code)."

After disabling CiviCRM on all three sites the error cleared.

Per CRM-17789 PHP 7 compatibility comes with CiviCRM 7.12.  Upgrade of 4.4.5 site tto 4.7.18 was attempted. However,  now "http://www..com/civicrm/upgrade?reset=1" produces the following: "ERROR: The website encountered an unexpected error. Please try again later."

Apparently, the installation with the CiviCRM module enabled was not a fix.  This was tried several times after clearing the browser cache ... and in more than one browser with an open admin session set-up before the upgrade.

Is there a way around short of a new install of CiviCRM?

The other two sites are currently running 4.1.2 and 4.2.8.  No CiviCRM upgrade has been attempted on these

Thanks,

TJH43


texts: OR operator in reports - How to draw a Participants report where A OR B?

texts:
How can I use the OR operator in a Participants report?
I need a simple A OR B report, and I can only find how to do A AND B.


texts: Why are custom field's multiple choice options all unchecked on contribution page?

texts:
Today I installed 5.25.0 (running with Drupal 7.69). I have a profile that includes a couple of custom fields that are multiple-choice (e.g. professional interests - check all the apply). The choices that are checked appear on the member's profile page and when they edit the profile with those fields directly. So that all looks fine.

Not so much on the contribution page that includes that profile and fields. Every option is unchecked on the contribution page. They used to appear checked on the contribution page, but no more.

Even curiouser...one of the fields is required and the contribution page cannot be submitted unless EVERY option is checked. Normally with this field required, only one option needs to be checked.

So I am wondering if this is a new bug? Anyone else seen this? Suggestions?

Thanks, as always to the community :-)


texts: Returning from all contributions of a contact to all contributions at all? a bug?

texts: If I have a look at a contribution of a contact with more than 50 contributions (and let me show all of its contributions!) civiCRM does NOT return to the contact but to ALL contributions at all. Because we have more than 500 000, this takes ages!  Is this a bug?  CiviCRM 4.4.19  Drupal 7.39  Rolf  - ROBIN WOOD e. V.


texts: how do I install an extension in wordpress

texts: I downloaded master .zip from the civi website, and it is in my download box. How do I get it to a folder in my website to put the zip into my program


texts: How to create public and front end form through extension?

texts: I need to create a public and front-end form through an extension which is native extension that need to compatible with all CMSs like civicrm.com/civicrm/form civicrm.com/form.


texts: Does Email Signature extension work on CiviCRM 4.7?

texts:
Is anyone successfully using Email Signature extension on CiviCRM 4.7?

https://civicrm.org/extensions/email-signature


texts: Associate state and country fields when not tied to a particular address type

texts: I am building a profile to collect a list of states for various countries a person holds a license in.  The states/countries I'm looking for are not associated with any particular address type so I'm not seeing just the states for the selected country like you do normally. It becomes very cumbersome to sort through ALL the states for ALL the countries! Is there a way to tie the state and country fields together?


texts: Authentication error when running the "Fetch Bounces" scheduled job:

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

Full message:
Finished execution of Fetch Bounces with result: Failure, Error message: A fatal error was triggered: Could not connect to MailStore for bounce@domain.com@imap.gmail.com
Error message:

An error occured while sending or receiving mail. The IMAP server did not accept the username and/or password: 12345 BAD Failed to parse your command 1234567test.

I am using G Suite account and as well as i have configured IMAP.

Please note that the same username and password works correctly for sending mail through SMTP but fails in case of "Fetch Bounces" scheduled job.

But it is not working.

I am working on wordpress Version 4.9.6 and CiviCRM 5.0.1.


texts: How do I add a new administrator to CiviCRM?

texts: How do I give a person admin rights to civi?


texts: How can I setup ACL for user to modify only custom fields?

texts:
I would like to limit access of some CiviCRM users, so they can only access contacts in certain smart groups. Meanwhile, I would like them to be able to edit Custom Fields.

I created a separate drupal role for these users.

Now, if I keep the Permission CiviCRM: edit all contacts, the user can access all contacts and edit all fields.

If I remove Permission: CiviCRM: edit all contacts and allow access to specific groups in ACL, the user can access contacts in these groups, but can't edit any fields including custom fields. (It is not possible to edit any fields even if I enable ACL for all, authenticated or specific role users to be able to edit custom groups.)

CiviCRM 4.7.14 on Drupal.


texts: "System Status: Error" I updated to CiviCRM 5.12.0 hosted on WordPress internally on a QNAP TS-251+ Server. Where do I go from here?

texts:
System Status: Error
Cron Not Running (CiviCRM Homepage says "Loading...)
Configure Default Mailbox (CiviCRM Homepage says "Loading...)
Complete Setup (CiviCRM Homepage says "Loading...)
MySQL utf8mb4 Support (Server charset: UTF-8 Unicode (utf8))
PHP Out-of-Date (Unavoidable)
Remote Profiles Enabled (CiviCRM Homepage says "Loading...)
View details and manage alerts

I know why the PHP is out of date. QNAP refuses to update their firmware.
We use PHPMyadmin.

I see suggestions aiming at editing this or that, but don't know what to use to edit.
We are hosting internally and I setup everything, but I do not know how to restore the settings and database. I am adept at searching through folders and putting preconfigured pieces in place, but this is like thinking 4 moves ahead in chess for me. I struggle at 3.

Any assistance is greatly appreciated.


texts: How to alter the InvoiceID/ContributionID count

texts:
I'm wondering if is possible to alter the current Contribution_ID start count.

The invoice prefix is set to "INV" so when viewing a contribution I can see the invoice ID like INV76, I guess the ID comes from the contribution_id which matches with invoice_id in any single contribution. I would like to alter the current count so the next contribution_id starts with for example 4076.

Resuming, my target is to change the count of the invoice_id so it matches with our current invoices count (right now is about 4356) as we would like to use this fantastic CiviCRM feature.

Any help is appreciated.

CiviCRM 4.6.X Wordpress 4.3


texts: API chaining like behaviour with import.php

texts:
Looking to use import.php function to do a big import.

I'm yet to find some documentation that clearly explains it all. Seen this:

https://civicrm.org/blogs/xavier/api_batch_tools

and this http://wiki.civicrm.org/confluence/display/CRMDOC/Imports

But I'm wondering - the way it works, in terms of using a csv that maps to an entity - is it possible in any way to chain entities in the same way the API works? i.e. create contacts with address and email etc in one CSV?

Thanks

J


texts: Hello! Is it possible to make content in CiviCRM and publish it directly to Facebook?

texts: Is it possible to make content in CiviCRM and publish it directly to Facebook?  For example, uploading the video and posting a link that's leading to an article, or official website?


texts:
Hi,
 How do I  add a Pledge to contact so that he may view & pay pledges thru the  self-service payments page?


texts: How to fix a login issue on the new CiviCRM gitlab server?

texts:
Here's the thing. I've had a user account at civicrm.org for years. Now that the old issues.civicrm.org is shutting down I wanted to check out the new gitlab server at https://lab.civicrm.org

That site tells me that I should login using my credentials from civicrm.org, only that doesn't work.

I'm keen to avoid creating a second user account on civicrm.org unless absolutely necessary as that will most likely just confuse things further. I'm assuming something is broken somewhere.

Can anyone offer a solution?


texts: How do I find the contact ID on a checksum link, after a form is submitted?

texts:
I'm trying to make an extension that does the following:

User clicks link in email
Form loads, extracts the contact ID from the querystring (along with a checksum for security), and customises the form appropriately
User submits form
Changes are saved
Form reloads, showing updated data

My problem comes at step 5, as the form no longer knows what the contact ID is. How can I pass the contact ID to this page? It's no longer in the querystring, and I can't find it anywhere...

Sorry if this is basic stuff - I've tried to figure it out from the existing profile code.


texts: Custom contact reference field with "New Organization"

texts: I would like to create a custom contact reference field (for CiviGrants) that also has the ability to add a new contact on the fly. It should be like the default Contact field used in (for example) Contributions or Grants. Any help would be appreciated... Thanks.


texts: How to set the CMS language as the preferred language of the contact?

texts:
There is a way to force the language of a contact created via webform:
How to set a constant value for a field in webform (eg the prefered language)?

but I'd like to do it automatically, eg if I see the form as /fr/form it will set the preferred Civi language to fr, if the visitor is on /de/form it will be in german

Is this possible with webform civicrm?


texts: Can you include html in word replacements?

texts:
We have a contribution page, it says the following when credit cards are declined:

Your payment was not successful. Please try again

we want it to say:

Your payment was not successful. Please try again. If you continue to have issues, please email us.

When I use email us the word replacement gets garbles the input.

Is there another option?


texts: I've created some custom fields for a profile and would like one of them to have a larger text box than the default size.  How do I enlarge the field box size?


texts: Where should I place PayPal auto-return parameters?

texts:
Is there a suggested place or method by which to insert PayPal auto-return parameters, so as to guide PayPay to return users to a thank-you page following a transaction?

I have created a pretty standard CiviCRM contribution page to handle membership signups for a small non-profit. The sign-up process works great, but once users are done clicking the "Agree and Pay" button on PayPal, they now have to click a "Return to ..." button (still on PayPal) before being redirected back to the CiviCRM thank-you page.

As I understand it, one can use a return parameter to tell PayPal where to send users once their transaction is done, but I'm not quite sure how to implement it. Any advice?

For context, if it matters, this PayPal Business account is used both for CiviCRM and a separate web store.

A couple references that have guided me so far (but not far enough :-) are...

Paypal IPN eCommerce Payment Transaction Integration Notes
Multiple Auto Return Urls


texts: Free memberships are not created after upgrading to 4.6

texts:
We just upgraded to 4.6, and are having an issue with our membership sign up contribution page. It is for a free membership, and the page says that it is working, but on the back-end, no membership is being created: just the contact record and Drupal account. Has anyone had a similar issue after upgrading, or have any idea what could be wrong?

I tried to replicate it on the demo site, and could not.


texts: Email me every time someone makes a contribution

texts:
I've made a contributions page with CiviCRM on my site. How can I configure CiviCRM to send me an email anytime anyone makes a donation, please?

(I know I can have Civi send me a report of recent contributions periodically, but that doesn't solve this case. I want to configure Civi to send me an email with info about a single donation immediately, when the donation is made.)


texts: Moneris Payment Processor - use CIviCRM Invoice ID as Order ID in Moneris

texts:
For simple reconciliation, our client is requesting that the CiviCRM Invoice # be passed to Moneris as the Order ID for more straight-forward reconciliation.

We are referring to the default INV_xxxxx Invoice ID that CiviCRM generates.

Right now, Moneris passes back a random hash (ie, 0xf99c700c82a2e0011d750b925fd2db).

We currently use the modified Moneris plugin as provided by adixon @ Blackfly - https://github.com/adixon/ca.civicrm.moneris


texts:
After upgrading from CiviCRM 4.6.24 to CiviCRM 4.7.18 on Drupal (7.52) we are getting the error "Expected one Contribution but found 25"  whenever registering for an event with an event page.

I have tested logged in, not logged in,  with and without price sets.

The transactions receiving this error are being created in CiviCRM and not using an API call like with Webform.

I am running Apache 2.4.25 with PHP 5.6.30.

The error details that I have in Drupal Watchdog is too long to post.


texts:
Installation Details

WordPress 4.7.3
CiviCRM 4.7.17
CiviVolunteer 4.6-2.2.1
Angular Profiles 4.6-1.0.2
SparkPost 1.1 (verified working)

Problem Description
I have a CiviEvent set up with a schedule reminder. The variables in the email template are:

{event.title}
{contact.display_name}
{event.title}
{event.start_date}
{event.summary}
{event.description}
{event.info_url}

When the cron job runs, the email is not sent and I get this error in the scheduled jobs log and no emails are sent:

Parameters parsed (and passed to API method):
a:1:{s:7:"version";i:3;}
Full message:
Finished execution of Send Scheduled Reminders with result: Failure, >Error message: Cannot build query. Variable "@selectedValues" is unknown.

Any idea what is wrong and how to debug and fix it?


texts:
How can I get back a dump of the full param array when a chained api call fails, so that I can see what values are coming back from the previous call and going into the chained call (and thus better troubleshoot cause of failure)?

I know that I can add the "debug" param into the array, but I can't seem to read the trace in a way that tells me what $value was returned from the previous call and inserted to the chained call.


texts: How to exclude a specific link from a Mailing's statistics

texts:
I send a newsletter via CiviMail and in it there is a style link to load a Google font.
This link gets many hits in the Mailing report, but has no relevance for me.
Is there a way to exclude this specific link from the Mailing statistics report?


texts: What is the mechanism for tailoring an Angular form?

texts:
I want to modify the behaviour of an Angular form.

The answer to question 4700 tells me 'how' to do it (add some JavaScript), but I'm interested in 'where' to do it.

If it was a PHP form I could use a hook. Should I use an extension?


texts: Blank CiviCRM Dashboard and Admin Pages On Drupal 7

texts: From a Fresh install of CiviCRM on drupal 7 I logged out of the system and logged In again into drupal, on Accessing the CiviCRM module on drupal it leads me to a blank page http://localhost/drupal/?q=civicrm/dashboard and also  http://localhost/drupal/?q=civicrm/admin.


texts:
We are a non-profit mission sending agency. We are not looking for donor management software, but we are looking for more of an HR platform where we can manage all of our employees and all of their information so that it is available in multiple ways to multiple people within the organization.

Also does an API exist within the software?


texts:
registration is currently disable on CIVI forum
https://forum.civicrm.org/index.php?action=register
Does anyone knows if it's temporary ?

Thank's


texts:
I have three types of organisations: a. institution, b. supplier, c. corporate member.
I am creating different menus for manipulating each one of these (requirement of our users). I would like to offer a menu item that it called "Search for an institution" that when you press it, it has filtered the big list of organisations and displays only institutions. (the same for the other two categories).

How would I go about achieving something like this?

Thanks in advance

Aris


texts: How to alter a query in hook_civicrm_pageRun based on a custom filter provided?

texts:
I want to alter the query run in the hook_pageRun(&$page)  under Manage Events Page to alter the (event list) results shown here. I can alter the rows from hook_civicrm_pageRun , but I want to make changes in that row based on the values entered in the custom filter (e.g. default filter available is Event Type)
Suppose I change the Event Status(custom filter) , I want to change the results of $row based on that filter.


texts: Why does CiviMail 'track click through' redirect to incorrect URLs?

texts:
I seem to be having a problem that a number of people are running into that I'm hoping we can solve. When I sent out emails using the "track click through" enabled, I end up with URLs that direct to white screens.

What should direct to http://www.mysite.com/contribute/

instead directs to this url, which gives a white screen.

http://www.mysite.com/wp-content/plugins/civicrm/civicrm/extern/url.php?u=191&qid=5085

We're running
Wordpress 4.3.1
CiviCRM 4.6.6

thoughts? suggestions? Would it help to post the actual site urls? Needless to say as this is a fundraising email, I've got a development director in the other room melting down over this, so any help would be greatly appreciated. Thanks!


texts: JPG files uploaded as notes can't be viewed

texts:
I've attached some JPG files to notes in contact records, but them I can't open them and if I save them locally then most applications can't open teh saved version and say they aren't in a supported file format, though surprising, Adobe Acrobat will open them (which is not a solution for most users).

I'm using WordPress 5.3, CiviCRM 5.15.1

Any ideas what could be going on?


texts: Ignore Word Replacement on certain pages?

texts:
Is there any way to ignore word replacement for a particular page or event a particular label?

The replacement we're using applies to 99% of places so we'd like to keep using it.


texts: Randomize display of results from a Proxmity Search

texts:
We are using civiCRM 4.7.25 with Joomla 3.8.1

We have a proximity search to allow people to find nearby members of an national association.

The proximity search returns matching members alphabetically....

But we want the members to have "equal" opportunity to appear towards the top of the results list -- so we'd like to have the results of the proximity search return results randomly, instead of alphabetically.

Is there a way to do this?


texts:
I am looking to track the following information for each call made:

Attempt Number
Status of Call (No Answer, Busy, etc)
Date and Time of call
Who made the call
If possible, the length of the call

Has any developer created a way to track calls and the result of that call in CiviCRM?  If yes, how did you do it?

Or is this something that CiviCRM can do?  If yes, where can I find this information?

Thank you,

LAE


texts: Create a report or graph of the number of campaigns active in any particular month

texts:
In Civi + Drupal latest, we have a number of campaigns that last for a year or more. We know their start and end dates, but don't particularly want to manually change their status to show whether they are 'In progress' or not. Start and end dates are sufficient for that for us.

We'd like to create a chart or at least a View (or maybe a Report?) that shows the number of campaigns currently active in any particular month.

I tried CiviVisualise but in 5.21 get a database error that says its installation failed.

So... any ideas of how to create a View that aggregates the active campaigns in any particular month? I am thinking I might be missing something very obvious here, so grateful for any thinking that can put me right. From such a View we can then create a Chart using Drupal Charts.


texts: Howto extend a civi db field's size (maxlength, varchar)

texts:
We are facing a problem with CiviCRM's default field length for organization names.

Background:
In our setup we handle big departments or organizational units as distinct contacts. Since the sole department's name isn't sufficient for naming the contact and due to some limitations of CiviCRM (as discussed here) we've decided to compose the the name from the base organization name and the department's name.

Example:

Contact A: Base Organization named "University of Bielefeld",
Contact B: Department of A named "University of Bielefeld || Faculty of Physics"
Contact C: Department of A named "University of Bielefeld || FooBar Institute"

This leads in come cases to names exceeding the maxlength of contact name fields which is 128.

Setting those in the database is easy but adjusting CRM/Contact/DAO/Contact.php's column definitions makes core updates harder :/

How would you handle this? @Civi developers: Any chance to make field size configurable or increase size to 255 in general?


texts: How do I set a case open date and/or close date with a webform?

texts:
We've successfully got Webforms that open or close a case and assign a case role.

However, I can't seem to figure out how to specify a date to close or open the case.  All submissions record the status change as today.

Is there a way to specify a case start and/or end date through the webform other than today?

I've tried adding activities to the form and using those dates, but that creates separate activities on those dates and does not apply the date to the change in case status.


texts:
Drupal 7, CiviCRM 4.6.25/4.7.15

When I try to send an email to an individual contact using the 'send mail' action, the triangle spins and nothing happens. Affects our production and test site.

mail() configuration check out fine, and mailings 'send test' works. Haven't extensively checked this as we haven't gone live with the site.

The log/backtrace points to /civicrm/CRM/Utils/Token.php, line 1190:

     if (empty($contactIDs)) {
      // putting a fatal here so we can track if/when this happens
      CRM_Core_Error::fatal();

I've blown out our test database and re-initialized it with sample data -- no fix.

I've also upgraded our test site to 4.7.15 and am getting the same problem, stemming from the token.php function

Stranger still, if we use the 'send now (to less than 50 people)' selection from the contact search page, email works, just not from the contact record directly.

Works:

civicrm/contact/search?_qf_Email_display=true&qfKey=2b01f498b92b4b919c45446ae38d6c5d_3790

Doesn't:

civicrm/activity/email/add?action=add&reset=1&cid=202&selectedChild=activity&atype=3


texts: 500 server error when creating entity reference field where entity is CiviCRM Contact

texts:
I'm creating a new content type and want the fields to largely be CiviCRM Contact fields.

As I was adding a new Entity Reference field, I saved the field, selected the Target Type as CiviCRM Contact, and then clicked on 'Save field settings', but after about 1 minute of waiting, the server returned a 500 server error.

I can skip that step by clicking over to the widget tab and saving there, but when I go back to edit that field from the list of fields, I get the same error.

Other integration with Civi seems to be working okay.

Thoughts?

Thanks,
Lewis


texts:
I've installed CiviCRM on my non-profit organization (Wordpress 4.2.2, CiviCRM 4.6.3, MySql 5.1 and PHP 5.3), a trashware association which get computers from companies, other association and families and donate them to people who cannot purchase a computer.

Do you know if there are modules / extension which can allow us to track the outgoing donations too?

I can see that with CiviContribute it's possible to track donations, but it's not applicable to our needs, is that correct? If I well looked at it, it shouldn't be possible to track the donation of computers to us, only moneys...right?

Thanks in advance!


texts: Is there any developing activity to integrate Elementor and CiviCRM?

texts:
Probably many of you know Elementor, a powerful and high diffused page builder for the WordPress world.

Elementor works having widgets, which realize tasks in shaping, db connections and dynamic fields managing in wordpress pages. There is a platform for developers to build addons and extensions, and many of them are going out in the market, free and not.

Is there anybody who is working to integrate CiviCRM  and Elementor for some tasks?