texts: Activities to be shown in a full calendar

texts:
CiviCRM 4.62 on Drupal 7.37 in a Linux Virtual Box using only the CiviCASE module.

I need a full calendar view for civiCRM activities. I need a page with month, week and day views for the current user. I also need the calendar to have the ability to easily select a different user's calendar. I have other requirements that would be nice features but I need at least those two (full calendar and change users).

In practice -- The case manager wants to see at a glance what their day, week or month looks like, particularly to find a free day and time for an appointment. They also want to see the availability of other staff in a quick and efficient manner because they may be scheduling an appointment for that other staff person.

As proof of concept (but for Events, not Activities) there is the 'CiviCRM Event Calendar' extension by osseed (Link to Git page) built 2 years ago and updated six months ago. I haven't tested it but I assume it works. It is based on the open source jquery plugin called Full Calendar (link to description page) .

I have seen mentions of other attempts to provide this full calendar feature but they fizzled out somewhere along the line. The one I tried fell short of actually showing a calendar -- Contact Calendar (Link to description page). In that case it showed a new tab on the contacts page but no calendar appeared.

I would prefer this feature to be an extension to CiviCRM so it would be useful to a larger audience than just Drupal users.

How many hours should this take for a consultant to develop?

Any other thoughts or suggestions would be appreciated.

Thanks in advance for any help you can offer. John in Oregon.


texts: How to change membership type parameters to effect a revised end date

texts:
I'm working with an organisation which is changing their membership cycle. Originally the membership type was fixed and annual and we had a start date of April 1. Consequently the vast bulk of the members have a membership end date of March 31.

The organisation now wants to move to a calendar year cycle, still fixed, but with a start date of Jan 1.

I made the change to the membership type, and it appears to be working as expected for new membership sign-ups. Renewing members on the other hand still seem to be getting renewed through to March 31 of the following year, indicating that the renewal process is looking only at the duration and not the start date.

This is creating confusion, as although we are telling members of the change in the membership cycle, they are still getting receipts that show their new end date as March 31 as opposed to December 31.

I can't see how I could alter the membership type so that renewing members get renewed through to December 31.

What's the correct approach in this scenario?


texts:
As referenced here and other places in the forum:

https://forum.civicrm.org/index.php?topic=29753.15

IPN's from paypal are apparently not passing muster with CiviCRM. The errors in the log are somewhere along the lines of "Could not find an entry for contactID in GET". This log is generated by testing using curl, like so:

curl -k -X POST -d "[paste in IPN params from Paypal IPN log]" https://oursite.org/sites/all/modules/civicrm/extern/ipn.php?reset=1&contactID=[contact_id]&contributionID=[contribution_id]&module=contribute

The words in brackets are my substitutions; clearly there is an integer contactID in the GET request; what's going on here?

UPDATE: More perplexing is that the civicrm_system_log table varies depnding on how the IPN is sent. From Paypal, it shows all the info from the IPN as it's logged in Paypal - with the GET parameters first, followed by the POST parameters, all within the same JSON-looking structure, in the log table's 'context' field. If I simulate a re-send of the same IPN using curl as described above, the parameters from the GET part of the request are missing from the context field. I'm not sure if they're supposed to show up in the log or not, as it seems the POST variables are what show up in the log, so it's a little tricky to know how to debug this.

In any event, the actual IPN's that came through from Paypal, and which Paypal says were met with 500 errors, are logged in the database, and there are no corresponding entries in Civicrm.[hash].log from those times indicating any errors, so presumably the IPN should have processed correctly. This is rather complicated and confusing.. could someone please help?

Update: Including the GET data in the curl request with -X GET -d "reset=1&contactID=[contact_id]&contributionID=[contribution_id]&module=contribute" results in a "302 found" response, but no more information than that, and I cannot find any evidence in the database log of the request, and there is no mention at all in Civicrm.[..].log.

Addendum: The PayPal IPN simulator reports that it cannot successfully handshake with either the dev or live sites. That is strange considering that IPN logs are appearing in the live site's civicrm_system_log table..

UPDATE: Apparently here's what was happening. I have a Civi extension where I call a function defined in a Drupal module, and the 500 error was about calling an undefined function. I fixed that in the extension code, but the function in question called the Drupal watchdog(..) function, which is also undefined in the context of being called from ipn.php. So here's a better question: What's the solution to this problem? Do I edit ipn.php and bootstrap Drupal before doing anything else? It seems odd that, just for IPN's, something would break because it is not running under the same assumptions that the rest of Civi runs under.. of course, I could also switch from Drupal watchdog in my extension to whatever the Civi equivalent is.. any suggestions?


texts:
What is the best software to use with CiviCRM?
I've been using Quickbooks premier 2015 which has no option to import transactions.
Are there Quickbooks versions that allow for transaction import?


texts:
On a brand new Drupal 7 / CiviCRM 5.6.0 install I created a custom field group for Grants and added one Contact Reference field and then created 2 grants. When I search for grants and export and try to export that Contact Reference field, the name of the Contact is limited to 16 characters.

Further testing indicates that the name of a Contact Reference field on a Contact record also is limited to 16 characters when exported.


texts: 'DB Error - No Such Table' -- CiviCase in Drupal 7

texts:
I have a Drupal 7 + CiviCRM database with CiviCase.
This is a fairly new install. I would say CiviCRM was installed fresh about 3-4 months ago. As of now, CiviCRM has been upgraded to the latest current version, 5.25.0.

I noticed the following problem on 5.24, but as this is still a new install in development, its possible the problem has been there since the beginning.

When I go to Cases -> Dashboard, I see:

  DB Error: no such table

Additionally, when I go to view a Contact, and then click the "Cases" tab, I see the follow message in the upper right of the screen:

  Unable to reach the server. Please refresh this page in your browser
  and try again.

How should I go about fixing this?
It seems like the entire table structure is missing?

There is no production data in the CiviCase extension yet, so if it is possible to just do a complete fresh install of just that portion of CiviCRM, I can do that. I just don't know how I would do that safely without affecting the work I've done to other portions of the Drupal and CiviCRM database.

Here is the backtrace for when I see the DB error:

#9 /home/lapavnhy/example.com/sites/all/modules/civicrm/packages/DB/DataObject.php(2696): DB_common->query(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")#10 /home/lapavnhy/example.com/sites/all/modules/civicrm/packages/DB/DataObject.php(1829): DB_DataObject->_query(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")
#11 /home/lapavnhy/example.com/sites/all/modules/civicrm/CRM/Core/DAO.php(421): DB_DataObject->query(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")
#12 /home/lapavnhy/example.com/sites/all/modules/civicrm/CRM/Core/DAO.php(1540): CRM_Core_DAO->query(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...", TRUE)#13 /home/lapavnhy/example.com/sites/all/modules/civicrm/CRM/Case/BAO/Case.php(537): CRM_Core_DAO::singleValueQuery(" SELECT COUNT(*) FROM (SELECT civicrm_case.id as case_id, civicrm_case.subjec...")
#14 /home/lapavnhy/example.com/sites/all/modules/civicrm/CRM/Case/Page/DashBoard.php(71): CRM_Case_BAO_Case::getCases(NULL, (Array:0), "dashboard", TRUE)
#15 /home/lapavnhy/example.com/sites/all/modules/civicrm/CRM/Case/Page/DashBoard.php(100): CRM_Case_Page_DashBoard->preProcess()
#16 /home/lapavnhy/example.com/sites/all/modules/civicrm/CRM/Core/Invoke.php(311): CRM_Case_Page_DashBoard->run((Array:2), NULL)
#17 /home/lapavnhy/example.com/sites/all/modules/civicrm/CRM/Core/Invoke.php(68): CRM_Core_Invoke::runItem((Array:15))
#18 /home/lapavnhy/example.com/sites/all/modules/civicrm/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke((Array:2))
#19 /home/lapavnhy/example.com/sites/all/modules/civicrm/drupal/civicrm.module(454): CRM_Core_Invoke::invoke((Array:2))
#20 /home/lapavnhy/example.com/includes/menu.inc(527): civicrm_invoke("case")
#21 /home/lapavnhy/example.com/index.php(21): menu_execute_active_handler()
#22 {main}


texts:
How do I change this text
“This contribution is being made thanks to the effort of [contact name], who supports our campaign.You can support it as well - once you complete the donation, you will be able to create your own Personal Campaign Page!”

I’ve searched high and low - every tpl file in contribute/pcp etc
Is it hardwired somewhere?

Thanks all.


texts:
I'm following these instructions:
In CiviCRM, visit Administer » CiviContribute » GoCardless Webhooks. This page will show you the URLs that you need.
The GoCardless Webhooks isn't available at this location, so I can't get the URL I need ?


texts:
Is there a way to customize the Contact Dashboard?

Thank you for your help.


texts: How to go to Batch Update via Profile in one click?

texts:
I have a weekly procedure where I need to batch update Pending Contributions. It requires several manual steps to finally get to Batch Update via profile form:

Go to Find Contributions
Check Pending / Click Search
Check all Contributions radio, in the resultset page
Select action "Batch Update..." from dropdown
Select profile to use

I know it's not that bad, but I was trying to find a way to add a Menu item, where clicking it opens Batch Update via Profile form, with the profile I want, for all Pending Contributions.

Still think a good/easy way to implement this, any ideas?


texts:
Currently if I want to collate a report on events facilitated by a particular individual (or, say, run by a partner organisation, or any contact with a custom role), I have to go to each event from their contact record, or add each event title to the event 'is one of' filter - it's not possible to filter the event participant list report by a facilitator without limiting the data to that facilitator, and the other event reports (e.g. event summary) can't be filtered by an individual.

Is it possible to build a report to filter in this way? i.e. for a list of events filtered by one contact record, provide data on all event participants.

(I had considered just adding the facilitator as a custom contact reference field, but unfortunately that only allows me to add one contact per field, and there's sometimes more than one facilitator per event.)


texts: How do I send a scheduled mailing via CiviMail?

texts: I've created and scheduled for immediate delivery an email via CiviCRM. It's in the queue but nothing is happening. Who can I contact or what do I need to do?


texts:
I scheduled an email to send at 9.40am and it actually sent at 9.49am which I assume is to do with how often the send mail cron job runs.
Is there a way of actually getting an email to send at the time you specify?
EDIT my cron job for the above said that it triggered at 11.48am. Why is that? Is there a setting in civi which I need to change?
Thanks!


texts: Limit the list of contacts to search when assigning a case role

texts:
When I assign a case role to someone it seems like CiviCRM allows/requires me to search through the whole contact database. As there might be many matches for a search string it takes extra time to ensure that the one I assign is really the one I intended.

In my organization only a few persons are actually possible targets for such an assignment, as I assume is the case in most constituents, thus only a few in the contact database should be possible to select on e.g. assignment of case responsible.

Am I missing some configuration to make this happen? I know about permissions (which I so far have had no need for, "normal" contacts don't access our CiviCRM), are they related to this?

On essence, I want the contacts to be searched when assigning a case role to be limited, e.g by a group, so a match can be found quicker and more unambiguous. How do I do that?


texts: Any procedure to upgrade Joomla 2.5.28 to Joomla 3.5 with CiviCRM 4.4.4?

texts: I am in the throes of making the upgrade captioned above. If there was a documented procedure or a list of potential issues to help I would be grateful. Maybe I should upgrade CiviCRM to a leter version first??


texts: Why do custom fields on Membership not pre-load when a member is renewing

texts:
There was a discussion on the forum here - which suggested that the reason this happened was because Contributions should alway be loading fresh data.

The jury seemed to be out on whether that should be default behaviour for Member fields.

Our scenario is members join up, and use Contact Reference field to assign themselves to a club (and then we build a Relationship from that).

When the member renews we absolutely want this data loading.

My feeling is this should be core behaviour but would be good to canvass opinions on this.


texts: Bulk assign contribution page based on contribution type?

texts:
Issue: We migrated about 5000 contacts from one CRM to CiviCRM.

The organization required historical data to be moved over, but also changed their membership pricing scheme which has been resolved with price sets + custom contribution page.

Members migrated over need to be assigned to this new contribution page so they can renew online.

All their contributions involving membership was tagged as "Member Dues". Unfortunately, we cannot seem to bulk assign this to the new contribution page.

Any ideas?


texts: How to set read only field in Drupal CiviCRM

texts:
I would like to set a read only field in Drupal CiviCRM:

mymodule_civicrm_buildForm($formName, &$form) {
  ...

  // Set default value
  $defaults['readonly_field'] = xxx;
  $form->setDefaults($defaults);

  // Set read only
  $element = $form->getElement('event_type_id');
  $element->updateAttributes(array('disabled'=>true));
}

The field is disabled for input; however, the default value cannot be passed through the form submission.

The form warns that this required field does not input.

Could you advise how to set the read only field correctly?

Thanks a lot!!


texts:
Do anyone else have Donation Reports that only show 50 records on the webpage but when you export it shows all of them? There is no pagination and looking at the demos, it looks like there should be.

CiviCRM: 5.18.2 Drupal: 7.67 MySQL: 5.7.27 PHP: 7.2.22


texts: How can I customize the page coming after an event registration?

texts:
we're having an event coming up and I've succeeded in setting up the event registration page in civicrm running on wordpress. I've already customized the registration confirmation e-mail, however, when it comes to the page that one is led to after finalizing the registration process, I have no idea how to customize it. Unfortunately, it contains multiple aspects I'd like to change.

Any ideas?

Thanks a lot in advance and best regards!


texts:
What is the current  SCA/PSD2 compliant  payment processor available, other than stripe?
Having lot of issues with stripe recently and not being so reliable and looking for an alternative.

Note: SCA compliance is a requirement of the EU Revised Directive on Payment Services (PSD2) on payment service providers within the European Economic Area, described here https://en.wikipedia.org/wiki/Strong_customer_authentication


texts: Smart Group that returns those recently added

texts:
I'm attempting to create a smart group that returns a list of people added on the current date without having to edit the criteria each day.

I've been starting with the "Date Added to CiviCRM" custom search, entering a date, then editing the civicrm_saved_search entry with no luck. Alternately, I'd settle for something that returns the last few people added using the maximum contact id number.


texts:
brand new user here looking for design options.  My user would like to have a drop-down menu on a generic contribution page so donations can be designated to 6 or so different possible choices by the donor.

I believe a more straight forward approach might be to have each designation be a separate campaign with it's on contribution page - but I need to look the drop-down menu option as well.  Is it possible to put a drop-down menu on a contribution page?  Is it possible to tie a selection made with the drop-down menu to the donation in a report somewhere?

Thanks in advance for all comments

Michael


texts: Can I change the text "[CíviMail Draft]" in a language that local users underdtands?

texts: My fellow boardmembers of our marineclub are less familiair with bulk-mailings  and concepts. They reply on the draft mail, as if it was the right mail. I think if I change the text  "[CíviMail Draft]" into some text in local language, I will have a better response. Where and how can I change this text?


texts: Upgrading from 4.7.18 to 4.7.19 breaks soap

texts:
I recently upgraded from 4.7.18 to 4.7.19 (under Drupal 7.54) and now CiviSMTP (as well as my browser) gets Drupal's "Page not found" page when trying to get to my soap.php file.

Page not found
The requested page "/sites/all/modules/civicrm/extern/soap.php" could not be found.

I've confirmed the file is in place, I'm using the default Drupal .htaccess file, file permissions seem to be at their defaults (AFAIK), and I'm out of ideas. My cron jobs are also not running, but I figure there's a common cause.


texts:
My client took great pains to record check numbers and payment amounts and wants to produce an event payment report which includes the check numbers associated with each registration. I can get everything in the report except the check numbers. I have confirmed that the check numbers are entered, they just aren't appearing the report.  I've done this with standard reports and extended reports and the output is roughly the same. They need this report for their board. Any ideas of how we get there from here?

I did look at Bookkeeping report doesn't record check number for financial account/type but I'm not sure that it's the same issue and that item was never resolved that I see.


texts: Gravity Forms/CiviCRM add on - adding record to groups

texts:
I am using the Gravity forms to CiviCRM plugin. http://shop.civivip.com/civi-plugins/gravity-forms-integration/

It is passing the data but not seeing where it actually will specify what group you want data to send to. Just has Groups but can't select which one.

Have others successfully sent gravity form data into CiviCRM groups?


texts: How can I create a group of everyone who gave in honor of a specific person?

texts: I can see a list of everyone who gave in honor of a specific person by looking at that contact's Contributions tab (under Soft Credits).  However, I can't figure out how to put these folks into a group, or even generate a report on them to see their contact info.  How do I do this?


texts: Why is Activity statuses Scheduled and Completed added?

texts:
Is it a bug that in Advanced Search section Activities the Activity Statuses get filled automatically with Completed and Scheduled.

It happens when:

I open Activities section when doing Advanced Search;
I try edit Activities section of previously configured Smart group.

In (2) scenario, the previously set Activity Statuses are lost and replaced by these Completed and Scheduled, thus annoyingly disrupting the group settings which need to be manually redone.

The bug is present in CiviCRM Drupal sandbox v4.7.15.

Is there a bug report filled for this already?

Screenshot:


texts: How to enter a discounted fee after the discount date for an event

texts:
Using CiviCRM v4.5.8 with WP v4.2.2 and no Price Set, using Regular Fees and Discounted Fees

We have a 5K Run Event with a discount fee of $20 before June 1 and after that date the fee is $30.  Some of the participants sent in payment via mail.  When we are manually entering them we can not enter the discount amount.  It is defaulting to the amount after June 1.   We are selecting "Advanced Discount" in the Discount set area but it does not change the amount that we can select.   Is this a bug or am I missing something?   THANKS.


texts: How to set up 'renewal reminders' 5 days after renewal, and filter by a group

texts:
I want to send a note to users that renewed their membership. I want to limit that note to only a certain group of members. I thought I would use 'renewal reminders'.

In a renewal reminder, if I choose 'membership' as the entity, there is no trigger for 'renewal date', only for 'start date' and 'end date'.

But if I choose 'activity: membership renewal: completed', I can not limit the recipients (presumably the targets of the activity) to a certain group. There's just no such option.

Any suggestions on how I could do this ?

To clarify: We have several groups of members, and I want to send each renewing member a thank you note specific to his/her group


texts:
WordPress Version: 5.3.2

CiviCRM - Version 5.21.1

Shared Hosting - Dreamhost

I have tested this string in ssh:

/usr/bin/wp --user=username --url=https://mysite.org --path=/home/username/mysite.org/ civicrm api job.execute auth=0

It yielded this result:

Array
(
  [is_error] => 0
  [version] => 3
  [count] => 1
  [values] => 1
)

I assume this is correct, because when it runs in ssh, the web interface tells me cron has run in the status page. So I went to the next step, adding it to cron.

I tried using crontab -e, but it didn't seem to work there, so I tried it with the dreamhost cron interface:

1 */2 * * * /usr/bin/wp --user=username --url=https://mysite.org --path=/home/username/mysite.org/ civicrm api job.execute auth=0

This worked because I kept getting emails every two hours one minute after the hour with the array message above. So I appended > /dev/null 2>&1 to the string, hoping that I could run it without receiving any emails unless there's an error.

Well I'm not receiving errors and the cron isn't running. I'm missing something. I'd be grateful for any suggestions to fix it. Thanks!


texts:
I'm using CiviCRM as a WordPress plugin. I've created a report with a URL like:

https://example.com/wp-admin/admin.php?page=CiviCRM&q=civicrm/report/instance/123

I can visit that page and click the "Export CSV" button. Now, I want to write a script with the Google Sheets API that loads this CSV and updates a Google Sheet. Therefore, I need a direct link to the CSV-formatted report, so my script can issue an HTTP GET and receive the CSV data.

Is there a URL parameter I can pass, or some other way to directly link to the CSV?


texts: Printing reports without showing filters

texts:
Is it possible to print reports without the list of filters used displayed at the top?
Thank you


texts:
For upgrading CiviCRM, I've been told that it is safer to upgrade with drush than manually, but my version of drush, according to another post, has to be upgraded from 8.0.0 to 8.4.5. (See Command "drush vset maintenance_mode 1" gives me an error)
After looking a bit around how to do it when your current version has been installed with composer, I discovered I had to issue the command:
composer require drush/drush:8.4.5

I did it, but I got next output, and I don't know how to deal with that:
./composer.json has been updated
Loading composer repositories with package information
Updating dependencies (including require-dev)
Your requirements could not be resolved to an installable set of packages.

  Problem 1
    - drush/drush 8.4.5 conflicts with chi-teck/drupal-code-generator[1.33.0].
    - drush/drush 8.4.5 conflicts with chi-teck/drupal-code-generator[1.33.0].
    - drush/drush 8.4.5 conflicts with chi-teck/drupal-code-generator[1.33.0].
    - Installation request for drush/drush 8.4.5 -> satisfiable by drush/drush[8.4.5].
    - Installation request for chi-teck/drupal-code-generator (locked at 1.33.0) -> satisfiable by chi-teck/drupal-code-generator[1.33.0].

Installation failed, reverting ./composer.json to its original content.

Any help would be appreciated because I have no clue on what drupal-code-generator has to do or to be. Probably, I have to update drupal for being able to update drush, but I need drush to update drupal: so I am trapped into a deadly embrace.
Current version of CiviCRM: 5.26.0 (could be updated to 5.30.0)
Current version of Drupal: 7.69 (needs to be updated to 7.73)
Current version of PHP: 7.4.3 (OK)


texts: How to identify which message template is being used?

texts:
In my experience of working with CiviCRM, which goes back further than I care to remember, it has often been tricky to identify which message template is being when invoices/receipts/confirmation messages get sent out. Template names are sometimes different from those used in the current documentation (especially where an older site has been upgraded many times), and there is nothing  - at least nothing obvious I can spot - in the resulting emails/messages that help to identify the template.
Judging by some of the questions asked here I'm not alone in this confusion. As a proposed solution, what about including suitable comments in the source template, such that they appear in the source of the resulting communication but not in rendered messages, which identify the template being used?
On the face of it this sounds like  pretty straightforward thing to implement, if it would work.


texts: Control content access in larger Wordpress site using Civicrm credentials

texts:
We would like to make a portion of our site accessible to members only. Is it possible to tie certain parts of the larger Wordpress site to Civicrm membership?

In otherwords, if a user sets up an account in the Civicrm portion of the site, can that membership be used to access other pages in the site (that are not necessarily within Civicrm?


texts: CiviReport - how do I return NULL values for Participant Report with Membership Details

texts:
I have created several custom reports for CiviReport. To create the SQL for these reports I have used 'Toad for MySQL' to visualise the proposed end-result.

In my latest report I am trying to return a report of Participants that include their current Membership information; in the format:

Sort Name, Job Title, Employer, Email, Participant Status, Role, Membership Type, Membership Status, Membership End Date

This report should include participants that do not have a membership. The SQL is as follows:

SELECT civicrm_email.is_primary,
   civicrm_contact.sort_name,
   civicrm_contact.job_title,
   civicrm_contact.employer_id,
   civicrm_email.email,
   civicrm_participant.status_id,
   civicrm_participant.role_id,
   civicrm_membership_type.name,
   civicrm_membership_status.label,
   civicrm_membership.end_date
FROM ((((ceed_civicrm_db.civicrm_participant civicrm_participant
         INNER JOIN ceed_civicrm_db.civicrm_contact civicrm_contact
            ON (civicrm_participant.contact_id = civicrm_contact.id))
        LEFT OUTER JOIN ceed_civicrm_db.civicrm_membership civicrm_membership
           ON (civicrm_membership.contact_id = civicrm_participant.contact_id))
       LEFT OUTER JOIN
       ceed_civicrm_db.civicrm_membership_type civicrm_membership_type
          ON (civicrm_membership.membership_type_id =
              civicrm_membership_type.id))
      LEFT OUTER JOIN
      ceed_civicrm_db.civicrm_membership_status civicrm_membership_status
         ON (civicrm_membership.status_id = civicrm_membership_status.id))
     INNER JOIN ceed_civicrm_db.civicrm_email civicrm_email
        ON (civicrm_email.contact_id = civicrm_contact.id)
WHERE (civicrm_participant.event_id = 887) AND (civicrm_email.is_primary = 1)

When constructed in CiviReport, the resulting report excludes rows where the Membership is NULL, in effect changing the SQL to:

SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_sort_name, contact_civireport.employer_id as civicrm_contact_employer_id, email_civireport.email as civicrm_email_email, participant_civireport.role_id as civicrm_participant_role_id, membership_status_civireport.label as civicrm_membership_status_label, membership_type_civireport.name as civicrm_membership_type_name, membership_civireport.end_date as civicrm_membership_end_date

        FROM civicrm_participant participant_civireport

        INNER JOIN civicrm_contact contact_civireport
        ON participant_civireport.contact_id  = contact_civireport.id

        LEFT OUTER JOIN civicrm_membership membership_civireport
        ON membership_civireport.contact_id = participant_civireport.contact_id

        LEFT OUTER JOIN civicrm_membership_type membership_type_civireport
        ON membership_civireport.membership_type_id = membership_type_civireport.id

        LEFT OUTER JOIN civicrm_membership_status membership_status_civireport
        ON membership_civireport.status_id = membership_status_civireport.id

        INNER JOIN civicrm_email email_civireport
        ON participant_civireport.contact_id = email_civireport.contact_id

                WHERE participant_civireport.is_test = 0
                AND email_civireport.is_primary = 1

                AND membership_civireport.is_test = 0
                AND

        ( participant_civireport.event_id = 887 ) AND contact_civireport.is_deleted = 0    ORDER BY contact_civireport.sort_name   LIMIT 0, 50

The queries 'should' return identical data, but don't. Putting the latter SQL into 'Toad' removes the NULL values, but changes the SQL for visualisation to show the joins exactly as CiviReport but not the original query.

I'm probably missing something...

Any help appreciated. I'll post all the code after fix.


texts:
Drupal 7.59
Civi 4.7.27

In Blocks there is a default CiviCRM Contact Dashboard. #block-civicrm-3 I have assigned it to Content. It displays for Admin but not for any other roles. I want it to display for role Donor. In the block config I have Roles checked to display Admin & Donor.

Under Civi > Administer > Users > Permissions > Drupal Access Control I checked for Donor: CiviCRM: view my contact & CiviCRM: access Contact Dashboard

But the Donor role still cannot see the link to access their dashboard. When signed in as a donor I can go to /civicrm/user and see the dashboard. It is just not displaying this default block that has the link.

Any ideas what is keeping this from displaying?


texts: Same custom field name at Contact Form seems to be different for each logged in user

texts:
We've tried to alter some custom fields display (namely, make some fields display data only, not editable text field). It seems that all custom fields logic is inside templates\CRM\Custom\Form\CustomField.tpl file
So, we've tried to do something like this

{if $element.data_type neq 'Date' AND $element.element_name eq "custom_358_437"}
{$element.element_value}

where custom_358_437 is a field name picked via form html code inspector.
All seems fine till another logged in user looks at the same form; it turns that the field gets "random" another name  (say, custom_15_415 for other user and custom_47_412 for yet another user), which seems to be pretty odd.

Not sure if it's "by design" (yet not sure why same field name should be changed for each user); if it is so, is there any logic in field name generation (may be current user ID is being used, although it doesn't look like this)? In a broader sense, how do we target custom field for making changes, if not by field name?


texts:
I am trying to send a scheduled mailer and need to know what time CIVI believes it is in ?
Right now CIVI appears to be 2 hrs. ahead of my time zone but there is not indication of time zone anywhere. Thanks.


texts: Custom date: How to translate pre/post form help field texts (field groups)

texts:
I have a pre-form help text that I would like to translate.

I can translate field group title, but not that text (see screenshot).

Can anyone help me with this?


texts: Paypal express payments not completing for contributions

texts:
We are running Drupal 7.50 and CiviCRM 4.7.8.

Contributions and memberships are being processed by Paypal express, users are getting confirmation and receipt numbers but Civi is showing them as Pending (Incomplete Transaction).

Weird thing is that event fees using the same setup is working fine.

How could I debug this?

Thanks


texts: Dynamically send scheduled email to a group?

texts:
I'd like to schedule an email to be sent next month to a group.

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

Civicrm 4.6.4 and Drupal 7.38


texts: Duplication of CiviMail subject when delivered to an inbox

texts: Can anyone tell me why 'February 2021' is repeating and is there a way to stop it?  It only appears once in the Mosaico template I use as 'PreHeader Text' yet I can't seem to stop the duplication when I send a mail out.  image here: https://i.stack.imgur.com/2Gc3i.png


texts: Database in unexpected version (and we have no backup DB)

texts:
Applied the 5.3.2 patch to our WP site yesterday, and in so doing upgraded the database to 5.6.alpha1. After doing this, multiple components (Contributions, Events, Mailing) became unusable. Trying to access these caused 500 (server) errors. Meanwhile, Civi 5.4.1 dropped, so I replaced the 5.3.2 patched code with 5.4.1 -- but couldn't update the database, because it was still 5.6.alpha1.

"No problem," I thought -- I can restore the WP database from a backup. But the only backup I had was from after the 5.3.2 patch, i.e. in the 5.6.alpha1 state. And as luck would have it, the hosting provider's backup on the server was corrupt and couldn't be restored.

So here's my dilemma. System Status tells me I need to "determine the correct version corresponding to your current database state." Should I try to manually alter the working database so it aligns with the 5.4.1 codebase (and if so, how do I even begin to do that)? Or do I try to reapply the 5.3.2 patch and hope to somehow fix the server errors? Or do I apply a different codebase entirely?

The error message also suggests fixing the file civicrm-version.php -- so I set the 'version' value to '5.4.1' but no luck. I still get this:

Your database is marked with an unexpected version number: 5.6.alpha1. The v5.4.1 codebase may not be compatible with your database state. You will need to determine the correct version corresponding to your current database state. You may want to revert to the codebase you were using until you resolve this problem. OR if this is a manual install from git, you might want to fix civicrm-version.php file.

How best do I fix this? And since Civi appears to be running okay right now despite having different codebase and database versions, is it possible the database version is somehow misidentified -- that the DB version is really 5.4.1, but identifies itself as 5.6.alpha1? Images (bottom) showthe current DB structure.

As an aside, I've just learned a valuable lesson. Always store a DB backup locally before starting an upgrade, even when two automatic backup systems are running. If I had backed up manually, right now I'd be moving other projects forward instead of trying to remedy this version mismatch on an active production site.


texts:
I'm having an issue where people signing up for a membership are getting an extra year added on (our fixed rollover date is July 1st).

All membership types are set to renew on Jul 1st (Membership Type Plan = Fixed, Membership Type Duration Unit = 1 year).
I've set the Fixed Period Rollover Day to Jun 30th.

When a member signs up for a membership today, they are being automatically set to expire on June 30, 2019 -- instead of 2018. Doesn't seem to matter what I set the Fixed Period Rollover Day to.

Am I setting something up incorrectly?


texts: iATS recurring payments: "mismatched contact id for the customer code"

texts:
During some auditing of membership payments earlier today, we found an interesting error message on one of our members:

  iATS Payments Recurring Contribution (id=nnn) Errors: Recur id nnn
  is has a mismatched contact id for the customer code.

There's one of these messages per day for the last week or so. The original payment did go through, we can see that on both sides (Civi and iATS). The errored attempts aren't getting sent through to iATS (which is probably a good thing).

How do I go about finding the details of the recurring payment so I can compare both sides? I've found what is likely the customer record on the iATS side, but that's only showing me the customer code.
Alternately, what exactly is being compared and found wanting here, and how possibly did it get messed up?

Thanks in advance for any assistance!


texts: How can i check current user is administer in civicrm hook?

texts: I am using the hook_civicrm_tabset for rename the tab name. Tab rename code is working properly. But i want to add condition if user is admin then rename the tab name. How can i check user is admin in hook_civicrm_tabset hook.


texts: After adding a Custom Field on Activity -> I get this message on the status report. How does one install a new custom field?


texts: Multiple insances of a custum field for one entity

texts:
How do I implement a custom field where I can input multiple instances of that thing.

For example I want to add Hobby custom field to Contacts. But a person can have more than one hobby. Is there  a way I click add another hobby, and then another etc.

Is there a way to add an arbitrary number instances of the same filed?


texts: **Network Error - Unable to reach the server

texts:
I am the manager of our organizations Drupal/CiviCRM site. Since we are an all-volunteer organization, I have other managing certain aspects of the system.

One of our board members is responsible for ensuring that membership records are up-to-date. For those who elect to pay by check, this means that he has to enter the site and manually enter the fact that the member has paid.

The process he uses for doing this is:

Go to CiviCRM
Type in the name of a contact in the search box, i.e. Smith
Select John Smith from the drop down box
Go to John's Membership Tab where his Pending membership is shown
Click on more, Renew

When he does this, he gets Network Error - Unable to reach the server.

I tried to duplicate this situation by giving my personal account (not the admin account) the same level of privilege as his account (note that I have the CiviGroup Roles Sync module installed, so this simply entails giving my account the same Role as his), logging into the system using a different browser (after deleting history, cookies, etc.), and following the same sequence outlined above. When I did this, the error did not occur.

Details:

Drupal 7.37
CiviCRM 4.6.3
Permissions enabled: access administration menu; CivCRM: add contacts, view all contacts, edit all contacts, view my contact, edit my contact, delete contacts, access deleted contacts, import contacts, skip IDS check, profile listings and forms, profile listings, profile create profile edit, access CiviCRM, access contact dashboard, administer reserved groups, merge duplicate contacts, view all notes, access contact reference fields, access CiviContribute, edit contributions, access CiviMember, edit memberships, delete in CiviMember, access CiviMail, access CiviReport, access Report Criteria; use the administration pages and help; administer users; view user profiles

Can you please suggest why my colleague is getting this error and I am not? If not this, can you suggest some tests that can be run on his computer to try to get to the root cause of the problem?


texts: Send scheduled reminders to relationship contact

texts:
I have setup a webform with an organisation and individual. The form collects an email address for both the organisation and individual. The membership is only for the organisation, but the individual will login and manage the account. This part works.

I would like to send scheduled reminders for organisations membership to be sent to the individual. Is this possible? Cheers.


texts:
I would like to create a group of contacts added by a particular admin.  How can I search for contacts added by x contact?

Thanks!


texts: Issue upgrading from 4.34 - Fatal Error (value: is not of the type integer

texts:
Have the following error trying to upgrade the DB, any help would be appreciated:

$ drush civicrm-upgrade-db
Exception: "A fatal error was triggered: One of parameters  (value: ) is not of the type Integer"
#0 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Utils\Type.php(362): CRM_Core_Error::fatal("One of parameters
(value: ) is not of the type Integer")
#1 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Core\DAO.php(1247): CRM_Utils_Type::validate(NULL, "Integer")
#2 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Core\DAO.php(1166): CRM_Core_DAO::composeQuery("UPDATE civicrm_
option_value\n        SET value = '{\"paper-size\":\"a4\",\"or...", (Array:1), TRUE)
#3 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Upgrade\Incremental\php\FourFour.php(176): CRM_Core_DAO::execut
eQuery("UPDATE civicrm_option_value\n        SET value = '{\"paper-size\":\"a4\",\"or...", (Array:1))
#4 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Upgrade\Form.php(683): CRM_Upgrade_Incremental_php_FourFour->up
grade_4_4_1("4.4.1", "4.3.4", "4.6.5")
#5 [internal function](): CRM_Upgrade_Form::doIncrementalUpgradeStep(Object(CRM_Queue_TaskContext), "4.4.1", "4.3.4", "4
.6.5", "C:\Users\Miles\AppData\Local\Temp\civA92E.tmp")
#6 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Queue\Task.php(88): call_user_func_array((Array:2), (Array:5))
#7 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Queue\Runner.php(213): CRM_Queue_Task->run(Object(CRM_Queue_Tas
kContext))
#8 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Queue\Runner.php(168): CRM_Queue_Runner->runNext()
#9 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Upgrade\Headless.php(67): CRM_Queue_Runner->runAll()
#10 C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\drupal\drush\civicrm.drush.inc(689): CRM_Upgrade_Headless->run()
#11 [internal function](): drush_civicrm_upgrade_db()
#12 C:\ProgramData\Drush\includes\command.inc(362): call_user_func_array("drush_civicrm_upgrade_db", (Array:0))
#13 C:\ProgramData\Drush\includes\command.inc(214): _drush_invoke_hooks((Array:29), (Array:0))
#14 [internal function](): drush_command()
#15 C:\ProgramData\Drush\includes\command.inc(182): call_user_func_array("drush_command", (Array:0))
#16 C:\ProgramData\Drush\drush.php(92): drush_dispatch((Array:29))
#17 C:\ProgramData\Drush\drush.php(61): _drush_bootstrap_and_dispatch()
#18 C:\ProgramData\Drush\drush.php(16): drush_main()
#19 {main}
WD php: Exception: A fatal error was triggered: One of parameters  (value: ) is not of the type Integer in       [error]

CRM_Core_Error::fatal() (line 328 of C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Core\Error.php).
Exception: A fatal error was triggered: One of parameters  (value: ) is not of the type Integer in CRM_Core_Error::fatal
() (line 328 of C:\xampp\htdocs\ma\html\sites\all\modules\civicrm\CRM\Core\Error.php).
Drush command terminated abnormally due to an unrecoverable error.                                               [error]


texts: Is there a way to search/export potential duplicates?

texts:
I'm about to run dedupe (Contacts > Find and Merge Duplicate Contacts) and I was wondering if there is a way to put all potential duplicates from a certain rule into a group so I could export them as a backup before I start merging.

For example, I was hoping the Advanced Search page would have a field to search by dedupe rule but I don't see that type of option. Am I missing it, or is there another way?


texts: How to customise the activities tab listing

texts:
I used to hack the Activities BAO to change the search results to make the subject line something more useful; i.e. extract other data from particular activity types and auto-create a summary in place of the actual subject.

I'm doing an upgrade and realised what a royal maintainance PITA this has become :-)

I thought I could implement hook_civicrm_searchColumns but I've tried from a Drupal module and also from an extension created for the job but it does not appear to be being called for the tab selector? Is there another way? I've tried this on 4.6 and 4.7.

I might not be explaining which bit I need to customise very clearly, so here's a diagram:


texts: Looking for the best way to re-create the contribution page form using the REST API

texts:
I'm pretty new with CiviCRM but not with integrating API's in general.
I'm looking to re-create a contribution form using only the REST API.

Is this even possible?

I had started looking around the API explorer and got the call below.  Not sure if I'm on the right track.

http://dmaster.demo.civicrm.org/sites/all/modules/civicrm/extern/rest.php?entity=ContributionPage&action=get&api_key=userkey&key=sitekey&json={"sequential":1,"id":2,"api.MembershipBlock.get":{},"api.MembershipType.get":{}}

Any help would be appreciated.
Thanks.


texts:
We've had a CiviCRM site running for a while. Just recently our payment area is missing on all our events, contribution pages, and membership pages. As such, people cannot select to do Paypal, credit card (Authorize.net), or pay later.

Here's an event: https://www.zendust.org/civicrm/event/register?id=158&reset=1

Here's the donate page: https://www.zendust.org/civicrm/contribute/transact?reset=1&id=3

I completely cleared out any custom template pages we had in our CiviCRM files directory. This is a fresh install of Civi - I had to do the whole database dump and then into a new database and then run the updates, as updates were failing. I don't know if this has been an issue ever since we redid the database or not, as folks just noticed it.


texts: Race condition death spiral when changing a site's domain?

texts:
Drupal 7, CiviCRM 4.6, I've just switched a site from being a directory of one domain to it's own new domain. After clearing all caches and resetting the backend configuration, it's able to load the dashboard, but other pages result in what I believe is a race condition - specifically, loading the page seems to trigger the server into calling itself for the same page (i.e. generating an outgoing request to the url being requested). So it ends up in quite the death spiral of resource use.

I know that 4.6 uses outgoing requests to itself to populate the dashboard, but that's not exactly the issue here. I also have noticed that 4.6 uses http requests to itself to identify it's own version, which is also a kind of crazy thing, and I wonder if that's what's creating the death spiral in this case.

Any clues or similar experiences?


texts: Display Contact fields in WordPress Page

texts:
I use Wordpress 5.4.2 and CiviCrm 5.16.3.  I need a WP page, only authenticated user can see where I can display the Name, Last Name and one extra custom field.  I only want to display the Information and nothing else.  For example the page starts with Hello "Name", "Last Name" & "CustomfieldX"
This information could come from the CMS however the Custom Field is comming from CiviCrm, I tried using tha Profile in view Mode, but It is placing the tiltle of the filds and palces other information such as the profile Title, which i do not want to display.   I have looked extensively through this forum and other documentation and cannot seem to find a way to do this.  Does anyone have any tips, Please.
Thank you,


texts:
Running this:

civibuild create marc --type drupal-demo --url http://marc.localhost

Gives me this:

...
#33 /home/civicrm/buildkit/vendor/drush/drush/drush.php(16): drush_main()
#34 {main}
    [is_error] => 1
    [error_message] => DB Error: unknown error
)

+++ drush scr /home/civicrm/buildkit/src/drush/perm.php
Could not find the permission: register to volunteer                                                                                [error]
Could not find the permission: register to volunteer                                                                                [error]
civicrm@civicrm-dev-vb:~/buildkit/build


texts: How do you sync developments to a live site?

texts:
Live site, customer has 100,000's of records of data.  Has been doing their own thing like editing message templates, users configuring dashboards, editing and adding reports and probably a whole bunch of things I don't know about.

In the meantime, I've been developing some new enhancements which include additional custom data, both in existing tables and add-on tables.  Some more message templates, a new dashlet and editing/adding reports.  Plus about 80 other items, some in code some in the database.

I happen to know where the dashboard table is, I know where the message template table is - but I don't know which version of each template to keep.

So the code part is easy, but how the hell are you supposed to synchronise the two databases?
There is no timestamps or other identifies in the records.
There is no way of identifying what changes have been made on the live site
There is no way of identifying what changes have been made on the development site.

Seriously - how are you guys doing this in the real world?

Have I missed something?


texts: How to remove contacts without affecting events attendance data

texts: Is there a safe way to remove/delete/deactivate CiviCRM contacts who have attended events, without affecting the events attendance data?


texts:
Civi 4.6.10 Joomla 3.4.5

Our events after being created at some pointed are being copied by the system.  Note the following id numbers as well.  Original event was 4352.

LILA TEST RECORD  (ID: 4352)

Copy of LILA TEST RECORD  (ID: 4370)

Copy of LILA TEST RECORD  (ID: 4420)

Copy of LILA TEST RECORD  (ID: 4470)

This happened to us in the old version.  I have over 451 event copies to delete now.

here is another sample it even went back to 2012:

Copy of Advanced Air Sealing  (ID: 3871)
Smyrna  New York    Advanced Air Sealing    No  Aug 07, 2012 8:00 AM        Yes

Copy of Copy of Advanced Air Sealing  (ID: 4217)
Smyrna  New York    Advanced Air Sealing    No  Aug 07, 2012 8:00 AM        Yes

Copy of Advanced Air Sealing  (ID: 4218)
Smyrna  New York    Advanced Air Sealing    No  Aug 07, 2012 8:00 AM        Yes

Copy of Copy of Advanced Air Sealing  (ID: 4219)
Smyrna  New York    Advanced Air Sealing    No  Aug 07, 2012 8:00 AM        Yes

Copy of Advanced Air Sealing  (ID: 4022)
Smyrna  New York    Advanced Air Sealing    No  Aug 07, 2012 8:00 AM        Yes

Copy of Copy of Advanced Air Sealing  (ID: 4562)
Smyrna  New York    Advanced Air Sealing    No  Aug 07, 2012 8:00 AM        Yes

Copy of Advanced Air Sealing  (ID: 4563)
Smyrna  New York    Advanced Air Sealing    No  Aug 07, 2012 8:00 AM        Yes

Copy of Copy of Copy of Advanced Air Sealing  (ID: 4564)
Smyrna  New York    Advanced Air Sealing    No  Aug 07, 2012 8:00 AM        Yes

Copy of Copy of Advanced Air Sealing  (ID: 4565)
Smyrna  New York    Advanced Air Sealing    No  Aug 07, 2012 8:00 AM        Yes

Copy of Copy of Copy of Advanced Air Sealing  (ID: 4566)
Smyrna  New York    Advanced Air Sealing    No  Aug 07, 2012 8:00 AM        Yes

Copy of Copy of Advanced Air Sealing  (ID: 4567)
Smyrna  New York    Advanced Air Sealing    No  Aug 07, 2012 8:00 AM        Yes

Copy of Copy of Advanced Air Sealing  (ID: 4568)
Smyrna  New York    Advanced Air Sealing    No  Aug 07, 2012 8:00 AM        Yes

Copy of Advanced Air Sealing  (ID: 4332)
Smyrna  New York    Advanced Air Sealing    No  Aug 07, 2012 8:00 AM        Yes

again note the ID numbers....


texts: Return after login going through contribution flow doens't bring up contribution page

texts:
Going through contribution flow reach point where user needs to log in

  If you would like to create an account on this site, check the box
  below and enter a Username and a password. If you already have an
  account please login before completing this form.

  Please login is a link that takes one to login and then return to
  contribution page.

Problem is after logging in  the url is

https://www.isfpta.org/index.php?option=com_civicrm&amp;task=civicrm/contribute/transact&amp;Itemid=1726&amp;reset=1&amp;id=13

If you pull the amp: out after the & it works.
Current versions of Joomla 3.36 and civicrm 4.6.3


texts:
I have a volunteer project I am doing and the organization it is for wants to be able to show donors the estimated cost of their credit card processing and then let them add it to their total.  I know we can do this an extension but I am trying to come up with another way. Any ideas are appreciated.

Thanks,
Steve


texts: Upgrading Custom Extension for PHP 7: How to I instantiate a mysqli data object

texts:
I've just upgraded a site from CiviCRM 4.6.38 LTS to CiviCRM 5.7 because we upgraded the server to PHP 7.1.x. As a result 2, custom extensions are warning me because they used mysql_real_escape_string().

PHP 7.1.x doesn't support mysql_real_escape_string() so I need to change to mysqli_real_escape_string() and pass my mysqli data object. The issue I have is that these extensions use the old PHP/MySQL connection as in:

$dao = CRM_Core_DAO::executeQuery($sql);

Is there some documentation I can use to quickly get up to speed on updating my code and acquiring a mysqli connection object?


texts: Problem with membership on behalf of orgnization

texts:
We accept registrations on behalf of organizations.  We have been requiring users to provide organization level data when purchasing a membership.  However, after filling out the membership contribution page and clicking Next to confirm the data, the organization level data does not show on the confirmation screen.  Additionally, after clicking the button to finalize the payment, we receive error messages that all organization level data is missing and must be provided even though we have filled in the data.  We have noticed that if we make the organization level information optional, rather than required, and the user chooses to register on behalf of an organization, the process works fine.

We are running 4.7.3 with WordPress 4.4.2.

Error screenshot:


texts:
tl;dr: After a failed upgrade, is updating the table structure enough?

I had a failed upgrade due to a mysql crash a few days ago (4.7.6 to 4.7.11). The database worked fine once mysql was back up, but I had a warning about a partial upgrade. Putting the backup back in place and rerunning the upgrade didn't do the trick, so I went table by table, comparing it to a successful upgrade, and updated the table structures accordingly. I then went into the domain table and updated the version number. Assuming the table structures are perfectly updated, are there factors I haven't considered?


texts:
Have tried using API, but
$result = civicrm_api3('Contact', 'get', array(
      'return' => "id",
      'contact_sub_type' => array('!=' => "Parent"),
));

gives zero results, while Search builder gives results using this query:

Contact Subtype Not Like Parent ...AND...
Contact Type = 'Individual'

API calls also give zero results count if

 'organization_name' => array('IS NOT NULL' => 1),

and

'current_employer' => array('IS NOT NULL' => 1),

being used, although we know such records exist. Moreover, theree are records, where "Current employer' field is empty, which yet have Relationships.

In theory, it might be possible to compare two arrays (all existent Relationships wjere Contact A is an Individual and all existent Individuals), but it might be tricky a bit at current number of records in both arrays (around 100K in each).  So, any reliable way to find Individual Contacts  with no Relationships, nor Employers?


texts: Is there an out of the box way to put mailto: links on the emails in the contact search results?

texts:
I customized the contact search result view by using a profile (without the state, but with phone and email) and made this profile the default view.
I am looking for a way to make the emails clickable (mailto) so my coworkers can just click this and use their mailclient to do a straight forward mail. (either that or a mail button, any solution would be appreciated.
tia


texts: Civicontribute radiobuttons without "none", where the "Other" contribution field deselects radiobuttons

texts:
This is a Theming/UI question for CiviCRM.

I've done some theming to turn the radiobutton's into clickable options.

When I select an amount it updates the 'Regular Amount' field.

However, when I select other amount, the previous option stays selected and they are added together.

What jQuery/js can I use to make the 'Other Amount' field de-select/unset the contribution amount choice?

I've tried code like this but for the life of me I can not get it to deselect anything!

$( "#price_78" ).focus(function() {
$('#CIVICRM_QFID_408_2').prop('checked', false);
});

Can you help me come up with a viable solution? We do not want to use the 'None' field on the contribution amount. I tried SimpleDonate but it did not work well for our implementation. We want the focus of the 'Other Amount' field to deselect any contribution amount.


texts: Where is the privacy filters located in report templates?

texts:
By default all privacy filters i.e. do not email, do not mail, etc is loaded in the report, except for do not trade.
Where in the report (contribution details )template this filters are located? How can I find out? Thanks


texts: Personal Campaign Pages don't have a donate button

texts:
We are using version 4.6.3 on Drupal. Our Personal Campaign pages aren't displaying a donate button on them: it just has a link to have people make their own PCPs, and the honor roll and thermometer.

Does anyone know why this might be the case?

Thanks!


texts: Membership sets to Cancelled when Contribution Fails. Why?

texts:
I have a situation where the Contributions are being set to Cancelled when the user contribution fails (payment processor fails the transaction). So, the user is blocked to try a new contribution until an administrator excludes that Membership with Cancelled status.

I took a look at documentation and understood that Membership Cancelled status would only be set manually, so I can't figure out why this situation is happening. I assured that "Override status" is not checked in the Membership edit panel, so it looks like something in the system is setting the Membership to Cancelled status. I wonder why and I need to fix it. Any clues?

Ps: The Payment processor IPN could be doing this?

PS2: I'm using Joomla! and the Payment Processor is PagSeguro.


texts: Mange Event > Configure > Dithered Options

texts: I am attempting to send emails to participants that are registered for events.  When I access Manage Events and select Configure - the option for Schedule Reminders is dithered out and not sure why.  Any advice would be greatly appreciated.


texts: how do you process mdg.php files during an extension upgrade?

texts: What's the best way to trigger managed entity processing as part of an extension upgrade? I have an extension that is already installed on a site. I'm rolling out an upgrade that implements a new custom report, including the .mgd.php file. I'd like that report template to be installed as part of the extension version upgrade. But I'm not sure the best way to "refresh" the system to process that .mgd.php file (which is generally only processed during installation).


texts: Is it possible to make groups mutually exclusive?

texts:
If yes, how do you add those constraints?

The docs for Groups and Tags suggests that it is possible by saying that it isn't for tags.

  Tags allow multiple selections - so they may not be appropriate for mutually exclusive characteristics (e.g. "Democrat", "Republican", "Green Party")


texts: Change order of custom profile fields on Drupal register page

texts:
I have created a custom profile in CiviCRM (Administer > Custom Data and Screens > Profiles) designated to be displayed on the Drupal registration page (see second screenshot), for users creating a new account. Initially, the CiviCRM profile was listed after the Drupal core elements: username, password, etc. But now the custom CiviCRM profile is displayed first.

How can I rearrange the order? I looked in Drupal blocks and do not see anything regarding these and I've tried assigning an order of "50" to no avail.

CiviCRM 4.7.27, Drupal 7

In the screenshot below, you can see that the "Tell us more" and darker text section is the CiviCRM custom profile and what follows it are the Drupal core elements that I want to be at the top.


texts: CiviCRM not recognizing csv file when uploading

texts: CiviCRM is suddenly not recognizing upload file as a csv file.  It's now giving an error message that csv file not recognized. What is the problem and how can I overcome it?


texts:
My CiviCRM drop down menu is not working in my WordPress Dashboard. Hence, I can't access membership info, etc. How do I know if it is a hosting problem or a CiviCRM problem? My host says it doesn't support plug-ins.

Wendy


texts: Using an excel membership number list to compile a civi report of linked addresses

texts:
I have a list of membership numbers of approx 80 people. I need to use these numbers (saved in an excel spreadsheet) to run a report in Civi which will pull all the addresses and names linked to those numbers (with the number) into a new excel sheet which I will then use for a mail merge.

When in Civi I can see that you can import a spreadsheet but that seems to be to add new members. What I need is not to add memberships/individuals but to use the numbers to collate information linked to those numbers already in Civi.

Can anybody help with the best way to do this without adding any duplicate information to Civi, or manually typing/searching all 80 people?

Thanks in advance.


texts:
I want to remove the ability to add attachments. Particularly, it should not be used for CiviMail as it's a great way to hurt email reputation and is simply unnecessary. I would rather load into my CMS media library and then add it into CiviMail via a hyperlink or image. I suppose I could argue that this option shouldn't even exist in CiviMail.

In Misc (Undelete, PDFs, Limits, Logging, Captcha, etc.) there are two options for attachments.

Maximum Attachments

Maximum Attachments For Backend Processes

Does Maximum Attachments mean only for front end forms?

To prevent attachments from being used, I set both to 0. I also tried to set this with an override in civicrm.settings.php but it does not accept a 0, so I tried -1 and that 'save right' but still had no effect.

What are those settings effecting then if not CiviMail? How can I remove attachment functionality? My last resort is removing the option thru a tpl.extra. I would prefer not to do that and fix it at the source.


texts: What is the purpose of Contact Link in the Caldera forms activity processor?

texts:
I'm using the Activity Processor with Caldera forms.

At the bottom of the processor config page, there are three fields:

Target Contact ID
Source Contact ID
Assignee Contact ID

Which make sense to me as ways to connect the activity to the other contacts in the form (or other contacts in CiviCRM).

But what is the purpose, if any, of the Contact Link field at the top of the page?

My best guesses are that either it is redundant and hard to remove, or that it serves some subtle purpose I am not aware of.


texts: For an upcoming event, I gave a number of our members refunds using Stripe. These refunds were recorded in the personal dashboard of each member, but they still appear as paid attendees for the event, even after receiving their refund, which causes confusion


texts:
Have been receiving email from PayPal that IPN is not working. One off donations were updated but not recurring payments. I am on CiviCRM 5.16.4

How can I fix it please?

I have tried this but still not working
anyone getting "IPN warning" emails from PayPal?

EDIT: Content of the email, also added a screenshot of the paypal IPN screen

Dear Tapash Datta ,

Please check your server that handles PayPal Instant Payment Notifications (IPN). Instant Payment Notifications sent to the following URL(s) are failing:

https://example.com/sites/all/modules/civicrm/extern/ipn.php

If you do not recognize this URL, you may be using a service provider that is using IPN on your behalf. Please contact your service provider with the above information. If this problem continues, IPNs may be disabled for your account.

Thank you for your prompt attention to this issue.

Yours sincerely,

PayPal


texts: why is the percentage of successful deliveries greater than the intended recipients in civi mailing report?

texts:
I have started experiencing some problems with bulk mailing, for at least 3 mailings the mailing report shows successful deliveries greater than the intended recipients. I have checked the detail report and noticed that some contacts actually show successful deliveries 4 times, while others are double or triple - see attached

In some cases, the contact email is marked as on hold but report shows double or triple successful deliveries.

My Mailer Batch Limit is 750, cron used to run every 15 minutes (*/15 * * * * wget -O - -q -t 1 'http://mysite.org/sites/all/modules/civicrm/bin/cron.php?name=username&pass=password&key=site-key'), i have changed it to every hour but still get more deliveries. Mailer Throttle Time, Mailer Job Size and Mailer CRON job limit are set to 0. I have had this settings for long and didn't experience this problem until recently.

I have also taken a look at this post here but this doesn't seem to be my case.

What should i be looking at? Civi 4.6.10, Drupal 7


texts:
I know that sticking in a contact-related custom field to the invoice template is just "contact.custom_xx" (where xx = custom field id).

We're trying to do the same for a Contribution-related custom field, but the syntax:

contribute.custom_xx or contribution.custom_xx is not working.

Any suggestions?


texts: Custom fields of type select not displaying in Activity Report

texts:
A site I'm working on has recently been upgraded to version 4.6.32.  Since this upgrade the client is no longer able to see data from some of the custom fields in the Activity Report.

Custom fields of type 'text' display fine, but fields of type 'select' are blank even though there is data stored in this field.

The site is running CiviCRM 4.6.32 on Drupal 7.


texts: Can nomination be part of the workflow for CiviCase?

texts:
Historically, I've used CiviCRM for events and member management. I've never used CiviCase, but I think this situation probably calls for CiviCase. Any insight will be helpful.

In short, the client has asked for a form which allows a contact to nominate another individual to received funds from the organization relief fund. I want to record both the contact submitting the form and the eventual recipient and then the actions that client performs within their own workflow. I don't have that yet, because I was just handed a paper form to add to the system.

Am I in the right ballpark, to use CiviCase instead of just posting a profile form to go to the association? Will CiviCase allow me to track the submitter and the recipient more easily? Any insight is much appreciated.


texts: Organization Membership Payment page not recording memberships

texts:
As background information, all of our client's members are organizations. I see that if I select "on behalf of organization" and "membership section enabled" I get two copies of the profile on my page. So we won't do that.

However, neither option by itself records a membership in the membership dashboard when the profile is filled out in our tests. I have all the key fields; organization name, email, contact address and phone. I get no errors when saving the contribution page. I have no errors when submitting a live form. What am I missing?


texts: We would like to change the minor changes in the content page and webform design, dont know how to access the file. How to get the FTP files from my site need to add custom css file. Any help please.


texts: Extracting a report/pulling a search result to CSV but setting an exported flag to indicate this

texts:
I am looking for a way to mark data as exported in some way.

The scenario is that we are receiving and capturing data for enquirers (people making enquiries) on behalf of a third party.

The 3rd party doesn't have access to the system (and are not allowed to be given log in - apparently this is a 'politics' reason) however need to be given an extract of all the people who have made contact in the last 24 hours.

Ideally I would like to pull a report (automatically generate a CSV file perhaps) but mark the data in some way with an exported flag or date so we can show it has been exported.

Any suggestion as to how I could do this?

(Open to other suggestions such as an export that sets an activity as completed or something too, or something that can be developed by the API)


texts: Users with Case roles cannot edit activities assigned to them: is this a bug?

texts:
first post so please forgive any netiquette transgressions.  I'm following the guide https://civicrm.org/bug-reporting to get confirmation this is a bug.

Version: 4.6.12 (also present in 4.7.1)

CMS: Wordpress

* Bug description *

User 1 (admin) creates a case and assigns a role to user 2.  User 1 creates an activity on this case and assigns the activity to user 2.

User2 has the ACL role "edit my activities and cases" and logs in.  They can see their case and Manage it.  When user2 clicks the Edit link alongside the activity user1 assigned to them they get an error, "Sorry an Error Occured
You are not authorised to access this page.".

This also generates the following in the Apache error log:

PHP Warning:  array_key_exists(): The first argument should be either a string or an integer in /wp-content/plugins/civicrm/civicrm/CRM/Case/Form/Activity.php on line 121, referer: https://ourtestdomain.co.uk/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcontact%2Fview%2Fcase&reset=1&id=3&cid=16&action=view&context=dashboard&selectedChild=case

Line 121 should be passing a case ID into the array_key_exists() call and that case ID should be an int or a string.  The comment at the top of Activity.php suggests that the original author expected it to be an int.  However the variable passed holds an object that contains the case id in question.  This generates the warning in the error log and the pop-up seen by the user.  If the case id is extracted from the object and passed into array_key_exists the user can edit the activity.

User2 has permission to edit this activity and I believe its a bug that they cannot.

NB because of the need for multiple users I haven't been able to recreate this on the demo install where you only have one user.

If you could confirm this I will file a bug report per step 7 of the guide.

Many thanks.

axa


texts: Smarty only generating nulls from API calls

texts:
Using the Explorer, I built up the smarty code I need for a template to pull in address information on a contact for use in an email:

{crmAPI var='result' entity='Address' action='get' contact_id=203}
{foreach from=$result.values item=address}
  {$address.some_field}
{/foreach}

and it produces the desired output in the Explorer when executed.

In an email though, the expected output never renders, and when I add the smarty expression {result|@debug_print_var}, I get null for the value of the variable in the message.

The fact that I'm getting null suggests to me that smarty is in fact running, but I can't for the life of me figure out why it can't seem to make an API call. Thoughts?

Thanks for the help!

N.B.: I'm running CiviCRM 5.17.4 on Drupal 7.67 and Ubuntu 16.04.

Update

With the following email code:

{capture assign=contact_id}{contact.contact_id}{/capture}

id: {contact.contact_id}

smarty id: {$contact_id}

{crmAPI var='result' entity='Contact' action='get' id=203}

{$result|@debug_print_var}

This is the email that renders when sending to contact # 203:

id: 203

smarty id: 203

null


texts: Does the Civi GoCardless extension use the GoCardless API?

texts:
We're a charity running CiviCRM 4.6 on Drupal 7. Last year, we moved all of our direct debits to GoCardless, which is running nicely. However, we're wanting to feed information from GoCardless back into Civi to state whether a recurring contribution has been paid or declined or cancelled, etc. At the moment, this is a very slow manual process, downloading a statement from GoCardless and then finding the corresponding contact in Civi line by line.

There's some information about the Civi GoCardless extension here (http://www.vedaconsulting.co.uk/gocardless), but this seems to be showing how to set GoCardless up as a payment processor.

Does anyone know if the GoCardless extension (or a different extension) can be set up in Civi to receive information back about contributions made through GoCardless, and if so, how does one go about configuring and running it?

Thanks


texts: Network Error and DB Error on contact subtype with custom fields

texts:
I'm helping a group set up an install (Civi 4.7.12, which has been upgraded from earlier 4.7.x versions a few times) on a dev site and I've added a set of custom fields for a contact sub-type. I added a checkbox field and tested and it worked fine. Now they've added some more custom fields in that set and we are getting some strange errors. I don't see anything which immediately raises a red flag related to the fields they added (more checkbox fields and some text fields).

When editing an existing org and trying to select the sub-type, it throws an error: "Network Error: Unable to reach the server. Please refresh this page in your browser and try again." The custom fields are never shown.

If I try to create a new contact of this sub-type, the fields show up, but when I try to save the contact, it throws an error. "DB Error: no such field" with further info below:

Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame thrown in /home/public_html/sites/all/modules/civicrm/Civi/Core/Transaction/Manager.php on line 107

Anybody have some pointers for me on where to look? I'm kind of stumped.


texts: CiviCRM 4.7 Wordpress Wiki Documentation

texts:
The Installation Wiki page says that PHP 5.3.3+ is required for CiviCRM 4.7 on Wordpress.  However, the Upgrade Wiki page says that PHP 5.3.10+ is required.  From what I've experienced, it seems that the Upgrade Wiki page is the correct version.  Did the update on the Installation page just get missed?

Installation link:
https://wiki.civicrm.org/confluence/display/CRMDOC/Installing+CiviCRM+for+WordPress

Upgrade link:
https://wiki.civicrm.org/confluence/display/CRMDOC/Upgrading+CiviCRM+for+WordPress


texts: Contact which is both Organisation & Individual

texts:
Is there a way for me to create a new contact that is both an Organisation AND an Individual sub-type?

I have a case where I have created a new Individual contact, he is a 'Lecturer' which is a sub-contact type we have created within 'Individual'. But he also Advertises with us so I want to be able to add him as an Organisation - sub-type: 'Advertiser'.

I know I can attach multiple sub-contact types within the main contact type, for example:

[Mr. John Smith] - Individual: [Member], Individual: [Lecturer]

OR [Mr. John Smith] - Organisation: [Society], Organisation: [Advertiser]

I cannot seem to mix the two: [Mr. John Smith] - Individual: [Lecturer], Organisation: [Advertiser]. Is there an easy way to do this other than creating duplicate contacts under each contact type?


texts: Personalize workflow message "Contributions - Receipt (on-line)"

texts:
Using the action "Confirmation receipt - print or email" in a list of contributions, the message sent to the donateur seems to be "Contributions - Receipt (on-line)".

When adding manually a contribution and checking the "Automatically send a confirmation?" button, the workflow message is "Contributions - Receipt (off-line)".

We personalized the "off-line" message. How to copy this to the "on-line" message? Simply copy and paste does not give a good result. Other form/database values are used.


texts: How can I add my Wordpress Site's template to my contribution page?

texts:
I have a contribution page located here: http://pghchoralarts.org/civicrm/?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=1

I haven't gone through the entire process of testing the PayPal integration yet, but one thing I am having a bit of trouble with is figuring out how to incorporate the rest of my Wordpress theme into this page.  Right now the page is an incomplete, unstyled HTML document, and I want to be able to essentially wrap my WordPress theme around it. Is there a fairly straightforward way to do this?

EDIT: I have narrowed down my issue to the fact that wp_head() in civicrm.php does not get called when it should. I have verified that CiviCRM_For_WordPress->wp_head gets added as a hook in the main wp_head(), but my theme does not call it when the main WordPress wp_head() is called. When I switch to twentyfifteen theme, the wp_head() function in civicrm.php gets called as expected. Any ideas on what may be going wrong?


texts: Membership doesn't expire for short periods of membership

texts:
We have standard membership that lasts one year and a trial membership that lasts one week.  The standard membership works fine, but we have found that the trial membership doesn't expire after a week but remains as 'New' for three months.

Looking at the membership status rules, I think I can see why.  'New' membership is set to start on the 'Member Since' date and ends three months after the 'Member Since' date.  Because this rule is listed first the membership remains on the 'New' status for three months even if we have moved past the 'End Date'.

We are using CiviCRM 4.6 on WordPress, but I have also tested this in the demo site running CiviCRM 5.5 on WordPress so I don't think this is version specific.

Has anyone else had this issue?  How did you resolve it?

I am considering changing the order of the status rules as follows:

Grace - from End Date to End Date + 1 month
Expiry - from End Date
New - from Member Since to Member Since + 3 months
Current - from Start Date to End Date

Does that sound sensible?


texts: Receiving membership fee payment and recurring contribution in one go

texts:
I am building our new website with CiviCRM, and I would really like to for new members to be able to set up annual membership fee payments (e.g. €15 per year) and recurring contributions (e.g. €30) in one go, instead of having to go through two separate paypal payments.

Both the membership and the donation payments are going to be recurring payments.

Can you give me any advice on how to do this? I can't get it to say anything else than this:

where it says that the money is charged every month, even though I have set the €15 membership fee to not recur automatically, and to be an annual fee.

Or is it necessary to do things serially: First membership fee payment, then setting up recurring donations?


texts: Installation issues - unmet dependencies

texts:
trying to install the civicrm buildkit using the instructions found here :
https://docs.civicrm.org/dev/en/latest/tools/buildkit/

I am on ubuntu 16.04.
When I run curl -Ls https://civicrm.org/get-buildkit.sh | bash -s -- --full --dir ~/buildkit I get the error:

 The following packages have unmet dependencies.
 nodejs-legacy : Depends: nodejs (>= 0.6.19~dfsg1-3~) but it is not going to be installed
 npm : Depends: nodejs but it is not going to be installed
       Depends: node-abbrev (>= 1.0.4) but it is not going to be installed
       Depends: node-ansi (>= 0.3.0-2) but it is not going to be installed
       Depends: node-ansi-color-table but it is not going to be installed
       Depends: node-archy but it is not going to be installed
       Depends: node-block-stream but it is not going to be installed
       Depends: node-fstream (>= 0.1.22) but it is not going to be installed
       Depends: node-fstream-ignore but it is not going to be installed
       Depends: node-github-url-from-git but it is not going to be installed
       Depends: node-glob (>= 3.1.21) but it is not going to be installed
       Depends: node-graceful-fs (>= 2.0.0) but it is not going to be installed
       Depends: node-inherits but it is not going to be installed
       Depends: node-ini (>= 1.1.0) but it is not going to be installed
       Depends: node-lockfile but it is not going to be installed
       Depends: node-lru-cache (>= 2.3.0) but it is not going to be installed
       Depends: node-minimatch (>= 0.2.11) but it is not going to be installed
       Depends: node-mkdirp (>= 0.3.3) but it is not going to be installed
       Depends: node-gyp (>= 0.10.9) but it is not going to be installed
       Depends: node-nopt (>= 3.0.1) but it is not going to be installed
       Depends: node-npmlog but it is not going to be installed
       Depends: node-once but it is not going to be installed
       Depends: node-osenv but it is not going to be installed
       Depends: node-read but it is not going to be installed
       Depends: node-read-package-json (>= 1.1.0) but it is not going to be installed
       Depends: node-request (>= 2.25.0) but it is not going to be installed
       Depends: node-retry but it is not going to be installed
       Depends: node-rimraf (>= 2.2.2) but it is not going to be installed
       Depends: node-semver (>= 2.1.0) but it is not going to be installed
       Depends: node-sha but it is not going to be installed
       Depends: node-slide but it is not going to be installed
       Depends: node-tar (>= 0.1.18) but it is not going to be installed
       Depends: node-underscore but it is not going to be installed
       Depends: node-which but it is not going to be installed
E: Unable to correct problems, you have held broken packages.

My nodejs version is v11.2.0 (I tried to update to fix this issue). I have tried removing it and reinstalling it. I have done a sudo apt autoremove. I'm not sure what else to try here. Any suggestions on how to fix this?


texts: How to access Financial Items through API?

texts:
In my organization, we have local chapters who sometimes get part of the national membership dues.  The BOD doesn't want the breakdown to show up on the email receipt, and the calculation has to be done whether the dues are posted online or offline, so I do my breakdown during the posting of the line item for the membership dues.

I access the chapter share and reduce the line item by the chapter's share and create a new line item for the chapters share, since it's a different financial type.  Everything works well, except the chapter's share doesn't show up on the bookkeeping report.  That's when I noticed that the Financial Item record isn't created for the chapter's share line item record.

So I looked at the API explorer and I can't figure out which API entity and which API call creates the Financial Item records.


texts: Membership not generated by membership contribution 4.6.18

texts:
We are upgrading our database from 4.4.7 to 4.6.18.

On testing, there is an issue related to pending membership payments, generated by the Civi contribution page, not generating a membership on the membership tab when the membership contribution is marked as completed.

I've tested as a new member opting to pay later on our  database, then opened the contact record as a member of staff would on receiving funds to mark this contribution as complete. On our live CiviCRM 4.4.7. database, this results in the membership appearing as new, but on CiviCRM 4.6.18. nothing appears on the membership tab.

Is this a bug or is this how 4.6.18 works?


texts: How to create a Drupal View of Open and Resolved Cases

texts:
Goal is to recreate the CiviCRM Summary of Involvement Dashlet in Views.

Problem arises when I try to count both open and resolved Cases in one View.

Table should look like:

Columns: Case Type/Open Cases/Resolved Cases

Row 1 (Case Type 1)

Row 2 (Case Type 2)

Row 3 (Case Type 3)

with the number of open cases and resolved cases for each case type in the corresponding row.

I can accomplish it with a view and an attachment view, but not a single view.

Anyone have any ideas?


texts:
I'm just getting started with civicrm and I've noticed that campaigns are mentioned in a lot of instructional resources

However, I downloaded the latest instillation of civicrm and there's no campaign feature in the menu, and I can't find any campaign module that I've seen mentioned.

How do I activate campaigns?


texts:
I know that it is possible to create profiles for Contacts that show up as options under "Search Views" in the Advanced Search screen:

I was hoping to add "Campaign" to the search results screen when searching for donations, but when I try to create a custom profile for this and begin to add a Contribution field, it says "Error: Contribution can not be used as a Result Column for profile searches."

Is there another way to adjust which columns show up for Contribution searches?


texts: Command "drush vset maintenance_mode 1" gives me an error

texts:
Issuing the command
drush vset maintenance_mode 1

gives me an error:

Deprecated function: Array and string offset access syntax with curly[error] braces is deprecated in include_once() (line 20 of /usr/share/drupal/includes/file.phar.inc).

I am wondering if I have to upgrade drush for getting rid of that error. I tried anyway to issue:
drush dl drush

At the prompt, I gave 1 as answer. I got next output. Again errors, even if it outputs [success] at the end.
There are no stable releases for project drush.                      [warning]
Choose one of the available releases for drush:
count(): Parameter must be an array or an object that implements     [warning]
Countable Table.php:789
count(): Parameter must be an array or an object that implements     [warning]
Countable Table.php:789
 [0]  :  Cancel
 [1]  :  8.x-6.x-dev  -  2013-Sep-30  -  Development
1
Unable to extract                                                    [error]
/tmp/drush_tmp_1603203813_5f8ef2e5117e3/drush-8.x-6.x-dev.tar.gz_date=1380571116.
Unknown archive format.
Project drush (8.x-6.x-dev) downloaded to /home/pf/drush.            [success]
Project drush contains 0 modules: .

I am a little bit stuck since everything I try is going wrong. A little help would be highly appreciated.


texts:
I would like to search the Civi API for Contacts that have both of two tags. I'm at a loss as to how to do this.  Right now if you provide multiple tags, the default is to use an OR operation.  For example:

CRM.api3('Contact', 'get', {
  "sequential": 1,
  "tag": [5,7]
  "return": ["tag","first_name"]
}).done(function(result) {
  // do something
});

This currently returns all contacts that have either tag 5 OR tag 7.  I want to return all contacts that have both tag 5 AND tag 7.  Is there any way to achieve this functionality?


texts: Adding tag or assigning group when user created from profile

texts:
I'm trying to create a mailing list sign-up using a custom profile (capturing a little more information about the user than the default mailing list).

I'm running Wordpress 4.7.x and Civi 4.7.x

I've managed to get the profile up and running but can't work out a nice way of assigning a tag \ group to the newly created individual.

I've had a read of How can I assign tag when certain profiles are submitted which looks like a similar question but unfortunately CiviRules isn't an option for me (4.7 not supported) nor are Drupal Webforms.

So far the best I've managed to achieve is to add a contact source field to the profile and auto-populate \ hide the field with Javascript which doesn't feel like an ideal solution.

Any thoughts or ideas appreciated!

Thanks,


texts:
A simple search and then use the export option from the drop down generates me a csv file that isn't - i.e. it's a semi-colon separated values file, not commas. There doesn't seem to be any setting that does that, and it seems to be specific to one site.
CiviCRM 5.28.4, Drupal 7.73


texts:
I have created a set of custom fields and I want to hide some data which have specific value, I have tried using
$smarty = CRM_Core_Smarty::singleton();
$smarty->assign('records', []);

to try and hide all the data but they are still showing.. can anyone help me?
thanks a lot


texts:
I have CiviCRM (4.6.3) plus CiviHR installed on a Wordpress 4.2.2 (multisite installation). I go to Administer=>CiviMail=>Mail Accounts. Then I try to create a new account or edit the default one. I enter my data into the form and click Save.

Result:
The form just keeps on loading forever. In the browser debugger console, the following line appears after submitting the form:

POST http://mydomain.com/wp-admin/admin.php?page=CiviCRM&q=civicrm/admin/mailSettings&action=update&id=1&snippet=json 404 (Not Found)

I've tried all the troubleshooting tips from here: http://forum.civicrm.org/index.php?topic=35850.0, but with no luck.

Does anyone have any idea why this 404 is happening or how I can further debug it?

Thanks in advance!


texts: Civi CRM Sparkpost - pesc.sparkpost - Error Sending Group Subscription Welcome Emails

texts:
So, I'm using the com.pesc.sparkpost CiviCRM/Sparkpost integration extension.  It is working really well so far for just about everything except for the welcome email for mailing list group subscriptions.  I've tried through a drupal webform and through a Civi profile (using checkmark boxes for public subscriber groups).  In both cases, the double-opt-in email gets sent properly, and the link in the double-opt-in email works properly.  Upon clicking the link I am sent to a confirmation page with an error message (bellow), but the welcome email is never sent, and the transactional email is shown as pending on the user's profile in Civi.

So, Transactional emails and Mass mail are definitely being sent fine through Sparkpost, and the subscription mechanism is working as intended.  So I'm pretty sure that my sparkpost smtp settings are working as intended, contrary to the error message.  So far it seems to be just these welcome emails that aren't sending properly.

  An error occurred when CiviCRM attempted to send an email (via SMTP). If you received this error after submitting on online contribution or event registration - the transaction was completed, but we were unable to send the email receipt.

  The mail library returned the following error message:
  Failed to send data [SMTP: Invalid response code received from SMTP server while sending email. This is often caused by a misconfiguration in Outbound Email settings. Please verify the settings at Administer CiviCRM >> Global Settings >> Outbound Email (SMTP). (code: 550, response: 5.7.1 Unconfigured Sending Domain )]

  This is probably related to a problem in your Outbound Email Settings (Administer CiviCRM » System Settings » Outbound Email), OR the FROM email address specifically configured for your contribution page or event. Possible causes are:

  Your SMTP Username or Password are incorrect.
  Your SMTP Server (machine) name is incorrect.
  You need to use a Port other than the default port 25 in your environment.
  Your SMTP server is just not responding right now (it is down for some reason).
  The FROM Email Address configured for this feature may not be a valid sender based on your email service provider rules.

  (i) Name (email@example.com) has been successfully subscribed to the mailing list.


texts: PayPal Standard - users getting "Could not find a valid session key"

texts:
Occasionally users at our site are getting "Could not find a valid session key" messages when making payments through PayPal Standard. The payment succeeds but this message unsettles users.
The sequence of requests for a contribution is ...

POST /civicrm/contribute/transact (submit payment details)
GET /civicrm/contribute/transact?_qf_Confirm_display=true&qfKey=XXXXX
POST /civicrm/contribute/transact (confirm payment details)
POST /civicrm/payment/ipn/NNN (PayPal IPN callback)
POST /civicrm/contribute/transact?_qf_ThankYou_display=1&qfKey=XXXXX

On the occasions when this fails the 5th step says "Could not find a valid session key". I'm unable to reproduce this on the PayPal Sandbox.
I'm running CiviCRM 5.10.4 (with security patches) on Drupal 7.67.
See this question for an update and a solution.


texts: crmEntityRef Populated with Custom Fields from a Custom Group

texts:
I would like to use crmEntityRef to load all the fields from a custom group I have created. I would like to have the list show the label for the field, and when selected it would return the id.

The following is what I currently have, but doesn't seem to work.

 $('[name=link_field]').crmEntityRef({
      api: {
          params: {
              custom_group_id: 'Assimilations'
          }
      },
    });

Obviously I'm doing something wrong. Any ideas?

Thanks!


texts: Utterly useless and unhelpful error message on attempting upgrade to 5.33.1

texts:
I have a Wordpress dev site  that we want to bring live with lots of new exciting content. The CiviCRM is out of date so I make a staging site and attempt to upgrade that to 5.33.1 from 5.32.2 so sadly the comment below, whilst very welcome and informative, does not take me any closer to a solution.
On entering the magic URL
http://example.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/upgrade&reset=1

(with example.org corrected of course and using https:)
I get the utterly useless and unhelpful error msg
Sorry, you are not allowed to access this page.
I have full admin rights and am left wondering what went wrong and why.  Meanwhile I am under pressure to deliver the shiny new content in a secure manner.
all my links are https - what other security issues are there?
Am I better off redoing the site in Drupal as the WordPress is obviously not the focus of the CiviCRM devs? Will I get less hassle every time I need to upgrade?


texts: Module or extension to use for tracking agreements?

texts:
I'm looking for a module or extension that has been written for tracking contracts/agreements between organizations within CiviCRM (on drupal). We would like to be able to track all the activities that happen related to that agreement within CiviCRM.

I thought Cases might be a good way to do this, but they are started based on a single contact.


texts: Problem to view forms registration for anonymous user

texts:
I'm using WordPress and Civicrm.
I can see user registration when I am logged in but not when I am an anonymous visitor.

Thank you, I'm a French user.


texts: Profile search/listings not working in 4.6.3/4?

texts:
I updated to the 4.6.3 version of CiviCRM for Wordpress, and discovered that I'm not able to bring up a listing/search page via the 'Use Profile-Listings Mode' - I get taken to a page on the front-end of WordPress with a message 'No fields in this Profile have been configured as searchable. Ask the site administrator to check the Profile setup.'

The listings/search option seems to work fine in the Drupal installation I usually use, which is on 4.6.2, but the problem does seem to happen in both the Wordpress and Drupal demo versions of CiviCRM 4.6.4.

As far as I'm aware there's only two places to set searchability - on the field itself, and in the Profile fields edit list. In 4.6.2, I get the error message if I forget to set the Profile fields as searchable, but when I edit them to be searchable, the search listing works fine - as far as I can tell, I've not done anything different when trying it in 4.6.3.


texts: Home page redirecting to event page on Wordpress

texts:
I'm running Wordpress 4.4.1 and CiviCRM 4.6.11

The main page of our site http://www.mltawa.asn.au is redirecting to an old event's page (http://mltawa.asn.au/2015-agm-registration/?page=CiviCRM&q=civicrm/event/info&reset=1&id=7). When I disable the event, it goes into a loop or, if logged in as admin, I get the pop-up message in the back-end:

  The event you requested is currently unavailable (contact the site
  administrator for assistance).

Ideas of where to start looking to fix this? :)


texts:
I am getting the following error after updating to 4.7.6:

  Warning: Missing argument 1 for
  CRM_Utils_System_Joomla::getDefaultSiteSettings(), called in
  /home/mysite/public_html/administrator/components/com_civicrm/civicrm/CRM/Utils/System/Joomla.php
  on line 687 and defined in
  /home/mysite/public_html/administrator/components/com_civicrm/civicrm/CRM/Utils/System/Joomla.php
  on line 698 Error displaying the error page: Application Instantiation
  Error: Failed to start the session because headers have already been
  sent by
  "/home/mysite/public_html/administrator/components/com_civicrm/civicrm/CRM/Utils/System/Joomla.php"
  at line 698.

I did not have this error in 4.7.4, skipped 4.7.5 update.
Running Joomla 3.5.1 and Php 5.5


texts: Sync name and address with drupal user page via civicrm webform

texts:
I am trying to sync the CiviCRM first name and address fields to a Drupal user account page but I cannot figure out the configuration. I am hoping it is something simple that I am missing out.

Scenario - We have a user who submits a webform with the first name, last name, address and phone number fields from CiviCRM. This is attached to an Ubercart product and when submitted the user has successfully purchased the product which comes with access to drupal to add some content. However, when the user logs in all the Drupal User fields are blank i.e. they need to be refilled again. Is there a simple way to sync them.

I have tried to the profiles section in CiviCRM but it actually add new fields to the profile page and does not sync them. Perhaps the CiviCRM roles sync is the right way to go? Any advice will be appreciated.