texts: CiviCRM Dashboard Not Working - WordPress installation

texts:
I had no errors when installing CiviCRM (with Sample Data checked); I just had to manually create the database. The only "warning" was that my hosting company is using PHP 5.4.

I can see the CiviCRM link on the dashboard menu, but nothing drops down. On the right (CiviCRM Home) I only see the welcome message and some links. When I click the "System Status: Error" link, the welcome message blurb disappears, but no error message or anything else appears. Refreshing the dashboard data on CiviCRM Home does not help.

CiviCRM 4.7.7

WordPress 4.5.2 - fresh install on a subdirectory of my main site

No other plugins activated.

wp-content/uploads/civicrm/civicrm.settings.php - settings file is here

PHP 5.4.45

wp-content/plugins/files - full permissions (777)

BASEURL - http://paintballheroes.ablewebs.com

I am trying to test CiviCRM before we make the decision to use it for our not-for-profit organization (BC Balance and Dizziness Disorders Society http://www.balanceanddizziness.org). Any help would be greatly appreciated.


texts: Escaping quotes in ckeditor breaks smarty-syntax

texts:
The ckeditor has the habit to escape characters like quotes or umlauts. This breaks the smarty-syntax when generating PDFs or mails.
Is there a good work-around or solution?


texts:
I've tried to sign up for CiviPostcode last week, and was expecting an email to verify my account after signing up. This didn't appear, so signed up again with a different address, but still no account email.

Is anyone aware if the service is still running, and if so, is there a manual account creation process involved?

Thanks!


texts: Online registration - fill-in boxes both above and below text

texts:
Is there any way on the online registration page for an event to include the fill-in boxes for name, email etc. both above and below several paragraphs of text?  Right now it is only appearing below the introductory text.

The idea is to handle two scenarios: 1) Someone comes to the page ready to register and can do so right away without having to scroll down through the introductory text, 2) Someone comes to the site, scrolls through the introductory text and can register without having to go back up to the top to register.

So, two identical sets of fill-in boxes, one set before the introductory text and one after.

WordPress 4.7.4 CiviCRM 4.7.17


texts: Can't view contacts group page DataTables warning due to an sql syntax error

texts:
On viewing my contacts group page I am getting an error.

The mysql audit log shows that the failing query is:

CREATE TEMPORARY TABLE civicrm_temp_group_contact_cache397 (SELECT
 25           AS group_id,
 contact_a.id AS id
FROM civicrm_contact contact_a LEFT JOIN
  civicrm_group_contact `civicrm_group_contact-(23` ON (
 contact_a.id = `civicrm_group_contact-(23`.contact_id
AND `civicrm_group_contact-(23`.status IN
    (\'Added\'))   LEFT JOIN civicrm_group_contact `civicrm_group_contact-19` ON (contact_a.id = `civicrm_group_contact-19`.contact_id AND `civicrm_group_contact-19`.status IN (\'Added\'))   LEFT JOIN civicrm_group_contact_cache `civicrm_group_contact_cache_23,24,25` ON contact_a.id = `civicrm_group_contact_cache_23,24,25`.contact_id    LEFT JOIN civicrm_group_contact_cache `civicrm_group_contact_cache_24)` ON contact_a.id = `civicrm_group_contact_cache_24)`.contact_id   WHERE  (  (  ( ( `civicrm_group_contact-19`.group_id = 19  ) OR  ( `civicrm_group_contact_cache_23,24,25`.group_id IN ("23", "24", "25") )  )  AND  ( ( `civicrm_group_contact-(23`.group_id NOT IN ( (23 )  ) OR  ( `civicrm_group_contact_cache_24)`.group_id

The quotes look a bit garbled? Any ideas?

I'm not sure anything changed except for the normal upgrades and the volunteers module being installed.

4.7.25 of CiviCRM.


texts: Search builder participants - relative start dates and event types

texts:
I'm trying to setup a search that finds participants for:

a specified event type,
with events that have started within a
variety of time periods relative to today: I need to be able to find
events that have started within the last 3 months, 6 months, 9
months, 12, 15 months... etc. I have a fairly wide variety of time
periods I need to search.

This will be used to grant access to course materials relevant to various stages through a 3 year course.

But in search builder, I do not see an opportunity to search event types, nor to search date fields based on relative dates.

Are these two features possible in any of the search facilities?

Thanks!


texts: How can I assign an External Identifier to each set in a multi-record import?

texts:
I'm importing education history for each Individual Contact, which can have from 0 to 5+ sets of multi-records.  Each set of multi-records comprises [institution], [degree level], [degree name], and [grad year].

The level, name, and year are custom fields that show up in the multi-import wizard.  The institutions are already imported as Organization Contacts with their own external IDs, and I have a relationship set up between individuals and educational orgs (much in the same way as employees would be related to employers).

However I don't see a way in the multi-record import wizard to relate a set of education multi records with the corresponding institution's External ID. Is there a way to do this in the wizard?

If not, is there a way to do it directly in MySQL?  (Though I hesitate to muck with the guts, since last time I changed some seemingly innocuous data, the site got corrupted.)

With hundreds of records to import and limited manpower, a manual process is likely not feasible.


texts:
I'm having issues just getting CiviCRM installed.

This is a Drupal 7.55 install. I got as far as installing CiviCRM as a module but the next step is to go to the install/index.php file and that is where I get my HTTP 500 error.

Looking at the apache error log it is a PHP parse error

PHP Parse error:  syntax error, unexpected 'clone' (T_CLONE), expecting '('

and then a link to this file

/civicrm/packages/DB/DataObject.php(207) : eval()'d code on line 1

Can someone help me out with this?


texts: Is it possible to modify group information with a webform or a profile page (not accessing CiviCRM admin pages)?

texts:
I'm trying to give access to several users to a webform/profile to easily modify a group's information (e.g Name, Description, some custom fields) without accessing the CiviCRM admin pages.

I haven't found an option to modify groups in CiviCRM Webforms or profiles.

Anyone knows if it's possible or there's any other way to do it?

Thanks!


texts: How to add profile shortcode to WordPress sidebar (i.e., in widget)

texts:
I can add a newsletter signup Profile shortcode to a page or post in Wordpress, but I'd like to have it show up on the sidebar.  I put the shortcode into a text widget (the code is for our MailMunch signup is in a text widget) but the Civi shortcode doesn't work there.

See http://sandbox.bio4climate.org/

Suggestions?

Thanks!

Adam

P.S. - This is a test site (but the payment processor is live!).


texts: Our event registration needs to have two "yes or no" questions added for the attendee to answer when registering.  Is that possible?  Thanks


texts: Can CiviCRM support a multi-tenant setup, If so what is the best configuration for it? Which CMS tends to work better for these kinds of setups: Drupal, Joomla or WordPress?


texts: Exporting Relationship "specifict job titles"

texts:
I need to export the "specific job title" field that is located in relationship.  I cannot find that field in any of the export drop-downs, nor any field with a language that even sounds like what I need. Situation is that we have "vacant" seats and will be using relationships and this title field for mailings.
Thank you...


texts: hook civicrm_post not triggering as expected (Joomla)

texts:
I have set up a hook to assign a group to new contacts when they are created. I have set it up the old-fashioned way, ie with a function called joomla_civicrm_post in a file called civicrmHooks.php in the php override directory. But the function is called every time the master cron job fires, whereas I expected/wanted it to be called when a new contact is created. Have I missed something obvious? Should this work? Or do I have to implement the hook as a Joomla plugin in order to get it to trigger correctly? Thanks.

Joomla 3.6.5, CiviCRM 4.7.16, php 5.6.30


texts: I am not new to Drupal but I am new to CiviCRM. I am building an email list, Does CiviCRM remove or scrub email lists?


texts: Inbound email formatting differs in Activities compared to CiviCase

texts:
Is it possible to include line breaks in activities created from inbound emails, given that this is implemented in CiviCase? If so are there any suggestions about how to go about implementing this?

Currently long emails, especially if replies are included result in a confusing block of text. This has previously been noted at Inbound Email - Formatting? (emails with HTLM code are ignored), However if the activity is saved to a case and then viewed the line breaks are shown.

To reproduce.
- Send an email (with line breaks/paragraphs) that will be recorded as an activity (https://civicrm.org/blog/dahndy/leveraging-civicrm-email-to-activity-processing-in-gmail details how to with gmail)
- View the associated activity on the associated contact (search for the email you send the email from)
- Note that the email has line breaks/paragraphs removed.
- Assign the email activity to a case
- View the case - scroll down to the activites tab - view
- The same content will be displayed with line breaks.

My understanding is that the contact record Activity View uses the following to display the body of the email:
{$values.details|crmStripAlternatives|nl2br}
civicrm-core/templates/CRM/Activity/Form/ActivityView.tpl:138

Where as the CiviCase Activity view is using:
{$form.details.html}
civicrm-core/templates/CRM/Case/Form/Activity.tpl
:64

In the database the detail field for inbound email the record is stored as two ALTERNATIVE ITEM's the first as plain text with line breaks, the second with the full html of the inbound email.


texts: Automatic filing of pdf letter activity within civicase

texts:
I am experimenting with "create printable letter" from within a civicase case as a mechanism for writing a letter to that particular client. However the resulting letter does not get automatically filed as a case activity, and there is no "file on case" button on the popup. It is possible to subsequently locate the activity and then file it on case but this is time consuming.

Is there a way to have the letter automatically filed within civicase in a similar manner to which e-mails are automatically filed?

Thanks in advance.

NB We are still using civicrm 4.5.5


texts: Can I avoid HTML formatting being escaped during API import?

texts:
I need to import HTML formatted content to a custom event field for a larger number of events.

During import via the API, HTML tags are being escaped and rewritten: Linktext becomes &lt;a href=“https://example.com“&gt;Linktext&lt;/a&gt;.

Is there a way to avoid this and preserve the tags as they are?


texts:
Can you point me to resources that can cover this requirements, I'm sure it would be needed often, and whilst I can dive into working it out from first principals, as a newbie, it would be nice to get thr benefit of some starting points.

Scenario is multiple households are 'managed' by an individual rep.

I would like to produce a reported, grouped / broken by rep of all their households.

Effectively a 'responsibility list' they can use to 'tick off' their annual visit to households.

So I have set up reps as type of 'individual'

and set up an A-B relationship between rep and household.

The standard 'contact relationship' goes part way there, but for instance doesn't have address.

I can see a 'developer tab' so I am assuming I can tweak the SQL -  but before I start hacking around I though I'd ask the best way to approach this.

Thanks

p.s.

I found this https://wiki.civicrm.org/confluence/display/CRMDOC/CiviReport+Reference
the implication to me is to write a custom php report?  Is that the right approach?

Seems pretty heavy weight  to get the desired results - but blogs lik ethis seem to indicate it is the way to go

https://alastaira.wordpress.com/2011/03/17/civicrm-creating-a-custom-report/


texts: When to use CiviCampaign vs Financial Types/Accounts

texts:
I'm managing CiviCRM for an organization that has the following kinds of accounts in Quickbooks:

General Fund: undesignated donations
one account per staff member, for donations towards each staff members salary
one account for each project/campaign, for donations towards a particular purpose
accounts for sales of products

Initially, I captured each of these as a different campaign using CiviCampaign. These means we can do things like have a Campaign dropdown on a CiviContribute page, e.g. to donate to the general fund or particular project or to support a particular staff member. This means it's easy to get reports or filter searches based on how each campaign is doing.

However, now that we're working to fully integrate CiviCRM with Quickbooks, I'm running into a problem. CiviCRM accounting codes are contained under financial accounts, but don't offer the same functionality as CiviCampaign. For example, is it possible to have a dropdown to pick which fund a donation goes to on a donate page if the funds are captured as Financial Accounts instead of CiviCampaigns? It seems every Financial Account requires a Financial Type?

And it doesn't seem to be easy to add Financial Accounts as staff come and go, compared to captured these accounts as campaigns. It also seems awkward: the financial type is really donation for all of these contributions, but the donations just go to various funds/accounts/campaigns. Is there a way to capture this in multiple Financial Accounts without having to have multiple Financial Types?

My options seem to be:

Use CiviCampaign, and figure out a way to modified the data before import to Quickbooks
Use Financial Accounts / Financial Types, and figure out another way to get the functionality we want in CiviCRM and potentially deal with a proliferation of Financial Types (which just doesn't feel right)

I'm leaning towards the first option, because CiviCampaign seems to be the right tool. But for extensive use of CiviCRM and accounting integration, what is the best way to capture multiple destinations for donations? When should I use CiviCampaign and when should I use Financial Accounts?


texts: How can I include CiviCRM relationships to node creations screens?

texts:
What I want to do is allow content authors to associate their news stories to their organisations.

I currently expose the organisations as an auto-complete field, however the target is for the author to not be able to select any organisation except their own.

I installed Entity Reference View as this appeared to be the way forward and created the following query for it

    SELECT civicrm_contact.id AS id, civicrm_contact.display_name AS civicrm_contact_display_name, civicrm_relationship.contact_id_b AS civicrm_relationship_contact_id_b, civicrm_relationship.relationship_type_id AS civicrm_relationship_relationship_type_id, civicrm_contact.organization_name AS civicrm_contact_organization_name
FROM
{civicrm_contact} civicrm_contact
LEFT JOIN {civicrm_relationship} civicrm_relationship ON civicrm_contact.id = civicrm_relationship.contact_id_a
INNER JOIN {field_data_field_test_member_station} field_data_field_test_member_station ON civicrm_relationship.id = field_data_field_test_member_station.field_test_member_station_target_id AND (field_data_field_test_member_station.entity_type = 'node' AND field_data_field_test_member_station.deleted = '0')
INNER JOIN {node} field_test_member_station_civicrm_relationship ON field_data_field_test_member_station.entity_id = field_test_member_station_civicrm_relationship.nid
WHERE (( (civicrm_relationship.relationship_type_id IN  ('17')) ))
LIMIT 10 OFFSET 0

As an Entity Reference AND as an Entity Reference View Widget, but neither worked (contact a is the author contact, b is the organisation, field_test_member..... is the organisation)

Am I heading into this the wrong way? Should I just build a webform and a node creation rule?


texts: How do I allow registration for one day of a multi-day event?

texts:
A use-case has come up where there is a need to hold a multi-day event where participants can register for "One day only". So if the event was Wed, Thurs & Fri, they could choose "Friday only" at registration.

I am thinking that Price Sets handles this nicely, although the rest of the event confirmations, reminders, etc. would not acknowledge that they are only attending for one of the days.

Anyone have experience with this or ideas beyond just using price sets?


texts: Outdated CiviCRM, blind SQL injection risk on parameters? (PCI compliance failure)

texts:
on CiviCRM 4.5.4 on Drupal, PCI vendor is reporting errors along the lines of:

  Using the GET HTTP method, XYZ found that : + The following resources
  may be vulnerable to blind SQL injection : + The 'snippet' parameter
  of the /civicrm/mailing/subscribe CGI : /civicrm/mailing/subscribe?
  mark_x_2=1&recaptcha_response_field=manual_ch
  allenge&recaptcha_challenge_field=&qfKey=03baf253d7e24b62a4d8b8e76939c
  36
  3_6657&mark_x_45=1&_qf_Subscribe_cancel=Cancel&_qf_Subscribe_next=Subs
  cr ibe&_qf_default=Subscribe%3anext&email=Email%20Sign-

In addition there are a number of other parameters they report, like "recaptcha_response_field", "recaptcha_challenge_field", "qfKey", "mark_x_45", and others.

I'm fairly certain this is a false positive, but need some justification.

Thank you!


texts: A required State field in a contribution page is not populating. What can I do?

texts:
I’ve just installed the UK Direct Debit extension (with the smart debit extension) for a site using civicrm 4.6.10.

I’m trying to configure a membership contribution page using the new payment processor and have a problem when using the live page.

https://crm.reach.org.uk/civicrm/contribute/transact?reset=1&id=16

In the billing address section both country and state are listed as required fields, but the state field fails to populate after the country is selected.

The site is set so that UK is the default country, I’ve tried to run the page with and without the default set, and the issue with the state field remains.

On the existing membership contribution pages for the site (using paypal as payment processor) the state drop down works fine.

On inspecting the element for JS I find this error message- “Use of getPreventDefault() is deprecated.  Use defaultPrevented instead.”

Has anybody else encountered this issue? Can you direct me to the file that controls the layout of the direcr debit billing template? Can I edit this without affecting other contribution pages on the site?

Or is there a simple way to remove the state field from the template or make it not required?


texts: Local (flywheel) wordpress install with CiviCRM

texts:
we are trying to

install latest civicrm 5.23
using latest wordpress 5.3.2
Using latest version of previous Local by Flywheel (version 3.3.0)
I want to install in french language.
I'm following the wordpress install recommandation here: https://docs.civicrm.org/sysadmin/en/latest/install/wordpress/
All requirements on https://lib.test/wp-admin/options-general.php?page=civicrm-install are fine.

If I change language to french from the install page (I installed correctly the language files) I get immediatly this error.

Fatal error: Uncaught RuntimeException: Undefined constant: CIVICRM_TEMPLATE_COMPILEDIR in /Users/f/local/lib/app/public/wp-content/plugins/civicrm/civicrm/CRM/Utils/File.php on line 583
( ! ) RuntimeException: Undefined constant: CIVICRM_TEMPLATE_COMPILEDIR in /Users/f/local/lib/app/public/wp-content/plugins/civicrm/civicrm/CRM/Utils/File.php on line 583

So this makes it impossible to install in another language than english which is annoying.
Any idea about this ?

If language is set to english, it almost works except for an error in some urls:

On a civicrm submenu, like for example administer -> administration console -> configuration checklist

if I click for example on the "Pages" wordpress menu, the url I end on is https://domaine.test/wp-admin/admin.php/edit.php?post_type=page with a blank screen.
This url should be https://domaine.test/wp-admin/edit.php?post_type=page
There is systematically this unnecessary "admin.php" in the url.
We've tried on another computer with this same local version and we got the same incorrect behaviour.
With another instance of civicrm (version 5.17) on this same particul local setup we don't have this error so we think that this is related to one of the following civicrm releases.
Any idea about this ?

We also tried on the new local by flywheel (5.2.5 with php 7.3.5 and MySQL 5.7.28)
Warning: this news version is a different application and connects differently than older Local to the database, using socket.
With that setup we have the same error as above when we change the language on the install page.
Then, if we install in english, it installs and generate the tables and the settings file in uploads/civivrm
Nonetheless I systematically gets several "network error" alerts... and civicrm is not working.
Any idea how to set civicrm with this new version of flywheel ?


texts: Enable recpatcha on all CiviCRM Contribution pages which does not include profiles

texts:
I need to include recaptcha on all donation pages in CiviCRM.

CiviCRM: 4.7.13

Drupal: 7.5.0

I know we can enable the "Include recaptcha" in profile settings. But few donation pages does not have profiles configured and I am bit worried how to add recaptcha for those donation pages.

Any help would be greatly apppreciated.

Thank you


texts: How to fix the 'send from' when using the Action pull-down to "Send Now"

texts: When doing a search and then using the "Action" pull-down to select "Send Now" the from address displays as several lines of code. See image attached. How do you fix this? How do you cause this screen to display properly. This does not happen when using CiviMail or when sending individual emails.


texts: Civimail and Sendgrid limitations and scalability?

texts:
Is anyone using Civimail with Sendgrid on a large scale? We have successfully used Civimail for newsletters and it seems to work well. However, on the Sendgrid website they say the SMTP is limited to 100 messages per connection and 1000 recipients. Does his mean Civimail needs to be setup to run a maximum of 1000 emails per cron run? More information here sendgrid docs

Thanks!


texts: CiviRules - to trigger a Mosaico templated email (with CiviMosaico extension)?

texts:
Is it possible to trigger sending an email based on a Mosaico template (using the CiviCRM - Mosaico extension?). I'm guessing not, but thought maybe someone had done it, or had a workaround.

Thanks!
..clark


texts:
CiviCRM newbie here. I am interested in whether CiviCRM and Wordpress could be used to manage an Animal rescue and rehousing charity.
In addition to tracking all the usual stuff like donations, events, volunteers, etc., they would need to manage:

Details of each rescued Animal and all relevant details such as location (foster home or adopted home, kennels, etc.), medical info, statistics, etc.
Lists of available foster homes
Adoption applications

Ideally, a solution that could list available animals on Public Wordpress Website, from the backend.

Is CiviCRM something that could handle this scenario, without too much additional development?

Thank you.


texts: What is required to run CiviCRM on Platform.sh?

texts:
Platform.sh is a managed hosting service & devops infrastructure with support for Drupal and Symfony (and apparently any arbitrary php application).

What additional considerations are there for hosting CiviCRM on Platform.sh?
Are there any specific configurations or patches required?
Is there any functionality which differs from hosting CiviCRM on a "standard" LAMP stack?


texts:
Background

I am working on a React app for event participation management using the CiviCRM ajax API. There is a little more to this that isn't relevant.

Each user has access to their own API key, but no CiviCRM or CMS account. I have used the civitest_civicrm_alterAPIPermissions hook to expose/restrict various entities. I have given each user the "access AJAX API" permission.

Issue

Before I go looking through the code, I had a question about an issue I am having:

Users with CMS accounts and the exact same permissions (i.e. no "access CiviCRM" and cannot log into CMS) can access the API fine, but those without get the error "ERROR: No CMS user associated with given api-key"

The error is pretty self explanatory, but I was curious if there was a way to work around it that is built into CiviCRM.

Setup

Joomla 3.8

CiviCRM 4.7.22


texts: Activity emails aren't sent when using sender's primary email address

texts:
I am looking for an option where a signed in volunteer can send an email to a contact using his primary email address - when I select "send an email" from the actions drop down I do see the default as the signed in user's primary email address, however, if I use that to send an email there doesn't seem to be any email sent even though an activity is registered and i get a notification of a successful email being sent

On the other hand I have added an email to the "From Email addresses" section under civimail (this coincides with the registered domain as well) - if I select this email address and send an email it successfully goes through

any help would be appreciated

Thanks


texts: Adding a field to the Create Activity Form

texts:
I'd like to change the form that opens when adding an Activity to a Case (depending on activity type). Specifically, I'd like to add a field.
I tried finding the fields I want to change in sites/all/modules/civicrm/CRM/Case/Form/Activity.php but couldn't find them. It seems like the buildQuickForm() function is only creating some of the visible fields but not all.
I also thought about writing an extension based on the hook_civicrm_buildForm function. I want to start checking if $formName == 'CRM_Case_Form_Activity' but after that I don't really know where to start. Can anyone give me a hint?
Edit: I found an extension changing the same location looking like this (How can I set "Assigned To" for an Activity to default to the logged-in user name?):
function myextension_civicrm_buildForm($formName, &$form) {
  if ($formName == 'CRM_Activity_Form_Activity' && $form->getAction() == CRM_Core_Action::ADD) {
    $form->setDefaults(array('assignee_contact_id' => $form->_currentUserId));
  }
}

Is there anything like $form->addField or something?


texts:
Here is what is going on.
I'm trying to do a search within my CiviCRM, however, I'm getting the error message:
One of parameters (value: sort_name) is not of the type MysqlColumnNameOrAlias.
So I'm looking at the following log and one of the messages in the log:
Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in require_once() (line 218 of /home3/isrcus/public_html/sites/all/modules/civicrm/CRM/Core/ClassLoader.php).
I'm using Drupal 7. Not sure what version of CiviCRM I'm using..


texts: How to find contacts that haven't confirmed their registration?

texts:
Coming through various channels (webform, newsletter subscription, api calls..) I have contacts that have never confirmed their subscription to a group.

If I go to the group tab, I can see that they belong to the group with the status "pending", and can manually confirm them

However, I didn't find on advanced search or custom a way to list all the pending ones (ideally, from longer than a few days ago), so I can send them a nudge "hey, you haven't confirmed your registration yet, please click here"

Is there an easy way to do that?


texts: How do I hook into a contribution thank you page?

texts:
Big picture: I want to display some custom data on a thank you page for a specific contribution page.   In my module I'm using hook_civicrm_preProcess.   Like so:

   function custom_thankyou_civicrm_preProcess($formName, &$form) {

if ($formName == "CRM_Contribute_Form_ContributionPage_ThankYou" && ($form->getVar('_id') == 5)) {

// do stuff, like send my custom data to a smarty template.

} }

But here's the problem, my customized message doesn't show up on the thank you page for that contribution.  It does however show up on the configuration screen for "Thank-you and Receipting" in the civi interface.

I guess it's not too surprising since the url for the config page is:

mycivicrmhost/index.php?q=civicrm/admin/contribute/thankyou&reset=1&action=update&id=5

and the url for the thank you page ends up being one like this:

mycivicrmhost/index.php?q=civicrm/contribute/transact&_qf_ThankYou_display=1&qfKey=3ee9c31da51b3af9dbe8c8efa5765520_1396

Is it possible to do this or should I set up an "external" thank you page instead?

Thank you


texts: Running CiviCRM 4.6.3 with Drupal 7.38.  In CiviEvent I am not able to get any 3 digit card verification number to pass the test payment processor in Test-drive or Live.  Using 4111 1111 1111 1111 as the test card number.  Continue to receive "Please enter a valid Card Verification Number".


texts: How do I get CiviXero to process contributions missed in the first run?

texts:
I've got the first 10 items for CiviXero transferred and it is transferring any new invoices. I set the start date to the start of the month but it does not seem to be  adding the items missed in the first run after the first 10 items.

How do I get CiviXero to add a specific contribution to it's account_invoice table for consideration?
How do I get CiviXero to process a specific contribution. I've tried invoice push job with contribution_id as the argument. Without the item being in account_invoice it doesn't consider it as needing being pushed.


texts: Automated emails generated from activities from address

texts:
Is there a setting by which all emails from civi will have the same 'from' address? Specifically I am thinking of activity emails, where an activity is added by someone, and currently all emails sent out related to that activity show as being from that person, rather than from the default site email address. Is there a way to change this?

Even when a different person makes a change to an activity, the contact the activity was added by is used for the from address in the email alert.

This is especially relevant when someone leaves an organization, but there are still activities in progress that were added by that person. Of course the data that this person is who added/initiated the activity is valuable, but having emails sent from that person that is no longer in the organization is a problem.

Is there any method that could be employed in the UI that could address this? Or will we need to develop a patch to change what from email address is used for activity updates?


texts: Recurring contributions no longer showing Custom Fields in subsequent contributions

texts:
Drupal 7.69
CiviCRM 5.20.0
iATSPayments 1.7

Around the end of Nov 2019 we updated to Civi 5.20 and at the same time we moved to a new server. Since then our recurring series are not including the custom fields from the first contribution. Would this be related to an improper cron setup after the server move or would it be related to the CiviCrm update?


texts: API Explorer 4 under Joomla and Windows/IIS gives fields like {{ ts('CiviCRM API v4') }}

texts:
I am running a development system under Joomla and IIS with CiviCRM 5.19.1 (5.19.0 had the same issue).  When using API Explorer 4 I get windows like this.

Under LAMP, the window makes sense.

 Any suggestions?


texts: Edits to mail.php for Bluehost still necessary?

texts:
Per this thread, I've been editing our /administrator/components/com_civicrm/civicrm/packages/Mail/mail.php like so to resolve a mail not sending issue:

// if (!empty($headers['Return-Path'])) {
//     $from = $headers['Return-Path'];
// }

I've been doing this since v4.4.4, and it is a bit of a hassle. We're on Bluehost, which apparently doesn't offer VERP (whatever that is). I successfully run dozens of Joomla sites on Bluehost and have no intention of moving.

Has anyone found an alternative solution here? Does Bluehost actually offer VERP and I'm just not finding it?

Thanks much.


texts: How to show CiviCRM menu for non admin role using WordPress?

texts:
Using WP4.1.1 and Civi4.5.8

How do we display a menu for a non Admin WP role?   We created a new role in WP for CiviUsers and would like to display the top Civi menu like Admins get.
THANKS.


texts:
I am helping someone who is trying to segment their contacts into smaller chunks as they go through to dedupe, so they have created a smart group to try to filter the dedupe rule on. (e.g. a subsection of contacts based on state, or a custom field).

When they prepare to dedupe, they have an option to select a group:

However, they are experiencing some strangeness in the results, including people showing up in the potential duplicates list that aren't in the smart group at all.

This brings up two questions:

Does deduping work with Smart Groups? (This post suggests it should have been fixed way back in Civi 2.1, but this documentation says it doesn't work)
Does deduping on a group compare only the people in the group to each other, or does it compare the people in the group to anyone else in the database (whether they are in the group or not)?


texts: REST API, iATS: How do I create a membership through the API without using CiviCRM's forms?

texts:
I'm building a software system that uses CiviCRM as a membership database and a billing engine for recurring dues. Our members do not have direct access to CiviCRM or the server on which it runs, and the software I'm writing can only communicate with CiviCRM through CiviCRM's REST API.

My signup flow needs to perform the following steps:

Create a contact in CiviCRM
Collect payment information and retreive an iATS token
Pass that token to CiviCRM, and associate it with the contact.
Record, somehow, whether the prospective member wants a monthly, biannual, or annual membership. Important: At this point, CiviCRM must not activate a membership or charge money.
Wait for a period of time, potentially days, for some offline stuff to happen.
Finally, process payment and activate the membership.

Again, all of this has to happen through the REST API. The software that processes signups cannot use CiviCRM's forms and cannot read or write to CiviCRM's database directly.

Is what I want to do possible without writing custom CiviCRM extensions?

From looking at the V3 endpoints for the iATS extension, I see code that lets me get information out of CiviCRM, but no way to get payment information in. What am I missing?

Edit: In retrospect, this might not be clear: I don't want to write my own CRM -- I just want to use CiviCRM as our CRM and only interact with it through its REST API. If, for instance, my custom software is decommissioned or replaced, I want CiviCRM to keep on storing and processing memberships without having to migrate data from one custom webapp to the next. I can do most of what I need to do through the V3 API, but membership signup seems to be a more complicated problem.


texts: Is there a way to find contacts who have multiple active or expired memberships?

texts:
Due to some import errors over the past few months, we have some members who are showing with multiple memberships.  Some are of the same type and some are not.  The way our memberships work, no individual should ever have more than one active membership (except in very rare circumstances).

I need a search that will help me find contacts with more than one membership.


texts:
I'm following the docs at https://docs.civicrm.org/sysadmin/en/latest/install/wordpress/

I downloaded 5.17 in a zip file from https://github.com/civicrm/civicrm-core/releases, unzipped it and renamed it civicrm (I need 5.17 and not 5.18 for various reasons).

The docs say:

  You should now have a /var/www/wordpress/wp-content/plugins/civicrm
  directory containing civicrm.php, README.txt and another civicrm
  directory (which in turn contains bin, CRM, sql, templates, etc.).

The unzipped civicrm directory does not contain civicrm.php at the top level; that file is in a folder called install. There is no directory inside civicrm called civicrm. As a result, the CiviCRM plugin does not show up in WordPress admin to be activated, even with correct _www and 755 permissions.

Do I create a directory inside civicrm? How do I get the plugin to show up in WP admin?

And, using the plugin installer in WP Admin to upload the zip file civicrm-core-5.17.zip directly results in the error The package could not be installed. No valid plugins were found.


texts: How to have different receipt messages on different donation pages

texts:
I have different donation pages and want to have completely different receipt messages sent. You can set up a custom "intro" text for the thank you message, but the bulk of the mail comes from the same template, no matter the contribution page, so limited options to change that. Moreover, the template message used if recurring donation is no using the custom thank you "intro" text.

Is there a way to change what template to use on a per page basis?


texts: How do I update CiviVolunteer, from the UI or from the command line?

texts:
I'm running Civi 5.19.alpha1 with Drupal locally. I have CiviVolunteer 4.7.31-2.3.1, which is the latest release listed on GitHub, from June 2018.

I want to update to the latest stuff in the repo, which I believe fixes a bug.

I don't see a way to do that in the Admin UI.

I've tried

git pull https://github.com/civicrm/org.civicrm.volunteer.git

from my ext directory at

~/buildkit/build/drupal-clean/web/sites/default/files/civicrm/ext

and I get

fatal: refusing to merge unrelated histories.


texts: issue with Joomla and CiviCRM Dashboard as a Menu Item

texts:
I'm following the directions found here:

http://book.civicrm.org/user/current/website-integration/integrating-with-joomla/

I'm having no problem adding some of the other CiviCRM menu item types to a menu, but when I try to add CiviCRM Dashboard to a menu item then navigate to the page using the navigation on the front end, I receive the following error message:

"0
SORRY BUT WE ARE NOT ABLE TO PROVIDE THIS AT THE MOMENT.
COULD NOT FIND VALID VALUE FOR ID
RETURN TO HOME PAGE.

OH MY GOSH! YOU FOUND IT!!!
Looks like the page you're trying to visit doesn't exist.
Please check the URL and try your luck again.
TAKE ME HOME"

I've gone through the "Advanced, Link Type, Page Display, Metadata, ..." etc options under Menu Manager and I haven't been able to uncover anything obvious.  I also have made sure that access is set at "Registered", and I am logged in as "Registered" on the front end.   Any ideas?


texts: How to create a new contact type other than "Individual", "Household", or "Organization"?

texts:
Sorry if this is not the best place to ask or if I sound vague, I am very new to CiviCRM and would be grateful for any advice I can get.

I am using CiviCRM for a local nonprofit animal shelter. Currently I have the pets stored as an "Individual" subtype, and added a custom field group for Pet Details that I basically would want to replace the "Contact Details" section, since none of that information is relevant to a pet. I'm starting to think that a better course of action would be to somehow create an entire new contact type just for pets.

My options are to either try to hide the "Contact Details" section of the pet subtype, or create a whole new Contact Type just for pets. I'm not sure how to go about doing this or if there is even a way to do this without editing the core code of Civi.

Thanks in advance, any advice is greatly appreciated.


texts: Mailings -> New mailing gives 404 Not found (NGINX)

texts:
We've nginx installed as a proxy.  While attempting to start New Mailing
civicrm/mailing/send?reset=1 browser tries to reach civicrm/a/#/mailing/new url, ending with 404 Not Found nginx error. Nginx error log says "httpdocs/civicrm/a/index.html" is not found

It sounds pretty much the same as this question: 'Unknown path' error when trying to access New Mailing with version 4.6.2 , and we've no any modules installed.

However, solution mentioned in first comment  works for us. This is it:

  After changing line 56 in file civicrm/CRM/Mailing/Controller/Send.php like below, it now works.

- CRM_Utils_System::redirect(CRM_Utils_System::url('civicrm/a/', NULL, TRUE, '/mailing/new'));
+ CRM_Utils_System::redirect(CRM_Utils_System::url('civicrm/a', NULL, TRUE, '/mailing/new'));

But the question still is: do we need to perform something at NGINX configuration ( since pure Apache setup doesn't have this issue ) or it's a bug in the core, which should be reported / fixed?

Drupal 7.40 + Civicrm 4.6.9


texts: Interested in setting up capacity for receiving recurring donations

texts: My organization is looking to set up a monthly giving program -- does CiviCRM have the capacity to process/store recurring donations?


texts: Remove Default/Standard fields from activities

texts:
is it possible to remove some of the default/standard fields for activities?

For example, when creating a new activity type it includes "location" as a standard field. However, you can't search or report by this field. I'm not sure what it's purpose is, and I would rather create a custom field that can be searched.

Thanks


texts: I've created multiple custom reports. On several of them, the results are a blank, white screen; no results and no errors. Any idea what might be causing this? I checked my site logs, but there are no errors (that I can find). Other than that, I don't know where to start.


texts:
How best to survey all participants that attended a specific event?

I have successfully created some custom data fields, added them to a profile of type survey, and within Campaigns created a survey.

I am struggling with attaching survey respondents.  What I really would like to be able to do is an advanced contacts search (all contacts that attended a particular event) and then under the Activity menu have an option to 'Conduct Survey' and then select a particular survey.

OR

When I create a survey and get to the 'Reserve Respondents' section, have an additional field called 'Events', and when I select 1 (or more?) events, have the Respondents section populated with the event attendees.

Any thoughts or suggestion much appreciated.


texts:
The drush command drush civicrm-disable-debug returns error The drush command 'civicrm-disable-debug' could not be found.  Run 'drush cache-clear drush' to clear the commandfile cache if you have installed new extensions.

When entering drushto get the list of all commands, the disable command is not displayed, but the enable command is. The enable command works, and both are declared in the same way in ~/sites/all/modules/civicrm/drupal/drush/civicrm.drush.inc:

/**
 * Implementation of drush_hook_COMMAND_validate for command 'civicrm-enable-debug'
 */
function drush_civicrm_enable_debug_validate() {
  return _civicrm_init();
}

function drush_civicrm_enable_debug() {
  $settings = array(
    'debug_enabled' => 1,
    'backtrace' => 1,
  );

  foreach ($settings as $key => $val) {
    $result = civicrm_api('Setting', 'create', array('version' => 3, $key => $val));

    if ($result['is_error']) {
      drush_log(dt('An error occurred: !message', array('!message' => $result['error_message'])), 'error');
      return;
    }
  }

  drush_log(dt('CiviCRM debug setting enabled.'), 'ok');
}

/**
 * Implementation of drush_hook_COMMAND_validate for command 'civicrm-disable-debug'
 */
function drush_civicrm_disable_debug_validate() {
  return _civicrm_init();
}

function drush_civicrm_disable_debug() {
  $settings = array(
    'debug_enabled' => 0,
    'backtrace' => 0,
  );

  foreach ($settings as $key => $val) {
    $result = civicrm_api('Setting', 'create', array('version' => 3, $key => $val));

    if ($result['is_error']) {
      drush_log(dt('An error occurred: !message', array('!message' => $result['error_message'])), 'error');
      return;
    }
  }

  drush_log(dt('CiviCRM debug setting disabled.'), 'ok');
}

What to do to "enable" the "disable" command? Meanwhile, i use phpmyadmin to change the value of the field "debug_enabled" in the table "civicrm_setting" to "i:0;" (without the ").

Config: Drupal 7.53; CiviCRM 4.7.14


texts: Copy CiviVolunteer volunteer needs when creating a repeating event

texts:
When creating an event I am able to set the volunteer needs according to the regular schedule. If I set the event to repeat then I'd like it to copy those volunteer needs for each repeating event. Basically, I want a weekly volunteer schedule. Right now, none of the volunteer needs from CiviVolunteer copy for the repeating events, although you are able to edit each event's volunteer needs separately, which I'd like to keep.
 Does anyone know if this possible? If not, any tips on how to develop it? I am a novice programmer, so perhaps I could try to develop this functionality. Thanks much!!


texts: How do you display cross-contact searches?

texts:
I am trying to create a CSV using both Individual contact and Organisation contact information and I am having difficulty trying to achieve this.

As it's most basic it is to print postal labels containing:

The Individual with a specific relationship (there is only one per Organisation)
The Organisation display name
The Organisation address

The way that I thought most logical to do this is:

Open the Smart Group with all the organisations (filtered by the organisations membership status)
"Select All" and "Export Contacts"
Include field "Individual" > "Relationship (under related info for)
Include the Organisation fields

The exported file leaves the individual field blank though.

I am using Civi 4.4.14 and Drupal 7.39


texts: What is the grey box on selecting Webform Payment Processor?

texts:
Specific Issue
I have a View that contains a Views Block Area as one of its rows. In each of these Views Block Areas I have a Webform that contains a CiviCRM Payment Processor.

I want the Payment Processor that is used to be set on content within the row.

When I set this by Javascript I get a grey box appearing on the screen and disappearing. Google Chrome's Console shows the data is: form?currency=GBP&snippet=4&processor_id=[[index of the selected payment processor]]

My Questions are:

1) What is this for? What does it do?
2) How can I get rid of it / stop it happening?
3) Is there a better way other than javascript to do this? The only other thing I could think of was using views_post_render. That feels like using a sledgehammer to crack a nut.

Purpose
I want to be able to have multiple donation options on the same screen for a crowd funding effort. These options are generated by a View. I am open to having a link instead of a payment form, and definitely open to a better way than using Views Block Areas in rows!


texts: Is there a way to get a stand-alone Tell a Friend page?

texts: We are trying to send an email to recent donors asking them to tell a friend about a current campaign. I know TAF pages exist as part of the donation page flow, but do they exist outside of that at all, or is there an easy way to make one?


texts:
I've looked about but to no avail - hopefully one of you fine people know the answer!

I have a webform with a user-select list for event registration. I would like the events to disappear from the list when they're full. Does anyone know how to make it happen?

I do have the 'show remaining space in events' popup at the top on, so that registrants can see the capacity, but it'd be more user-friendly to have full events removed from the select list.

Many thanks!


texts: How do i set up registration for multiple workshops?

texts: I am trying to set up registration for an event that has multiple workshops. i need people to pre register and i am uncertain how to set up.


texts: How can I use the API to set a field to NULL on an existing record?

texts:
Let's say I have a contact which exists and has id = 12345. I can use the API like this...

CRM.api3('Contact', 'create', {"id": 12345, "nick_name": "Bob"});

to change the contact's nick name. Cool.

But when I try this...

CRM.api3('Contact', 'create', {"id": 12345, "nick_name": null});

the call completes with success but does not set the nick_name field to NULL as I'd expect. Why? Is there some other way I can do it?


texts: Assign more than 100 contributions to a Batch

texts:
Is it possible to assign more than 100 contributions to a batch? We have a site with thousands of contributions so we want to make this job quicker. By default, you can only assign 10, 25, 50, 100 contributions to a batch.

Screenshot from
/civicrm/batchtransaction?reset=1&bid=x


texts: Webform contribution for multiple items?

texts:
In a webform, I want to offer a selection of prices and quantities (like a simple price set).

For example:

  Thing A  $10  [quantity box]
  Thing B  $20  [quantity box]

I've added a Contribution on the webform and ticked the box to add the contribution amount to the form. It seems like it should just be a matter of changing the widget type for the contribution amount to the right thing ... but I haven't found the right widget :-(

'Select options' lets me select 0/1 of each item, but not a user-entered quantity.

What widget type will do that?  Alternatively, any other suggestions for structuring the webform to achieve this?

[I want to use a webform for its other features that I don't get with a priceset and contribution page.]

(Drupal 7, CiviCRM 4.6.18)


texts: Paypal button not linking while using Paypal pro

texts:
We are running CiviCRM version 4.6.3  under Wordpress. We use Paypal Pro for payments. We created an Event registration and the registration page shows a Paypal button and the text:

"If you have a PayPal account, you can click the PayPal button to continue. "

but the Paypal button does not link to Paypal, but simply acts like the "Continue" button, giving an error that the credit card info has not been filled out.

This only happens with Event registration. With contributions, the same button goes to Paypal as it should.

Can anyone help us fix this?


texts: Please download Drush error when trying to execute CiviHR install script

texts:
I'm attempting to install CiviHR as per these instructions:

https://github.com/compucorp/civihr-installer

I'm using a GoDaddy shared linux server to install this on - but I have an issue. I've installed Drush on the server which seems to work - but the instructions ask for Drush to be globally available.

As far as I can see this means that the drush launcher needs to be able to work, however because this is a shared linux server - I don't seem to have the necessary permissions to make drush available globally.

So currently the civihr-install script falls over when checking for drush. Is there any nifty way of getting around this so the installer can use it?


texts:
Using Drupal 7.53 and civicrm 4.7.15.

Attempting to merge two contacts and get this message:

"Sorry but we are not able to provide this at the moment.
Expected one RuleGroup but found 0"
Return to home page.

Thanks.


texts: regen.sh - Call to undefined function db_query()

texts:
So I was following this doc to add a new setting which asked me to run bin/regen.sh script. But running the script failed with the following error:

PHP Fatal error:  Call to undefined function db_query() in /opt/buildkit/build/mytestbuild/sites/all/modules/civicrm/CRM/Utils/System/DrupalBase.php on line 303

Now I cannot access CiviCRM at all. I get the following message. Drupal works fine though.

The website encountered an unexpected error. Please try again later.
Error message
CRM_Core_Exception: Found installation canary. This suggests that something went wrong with tracking installation process. Please post to forum or JIRA. in Civi\Core\InstallationCanary::check() (line 53 of /opt/buildkit/build/mytestbuild/sites/all/modules/civicrm/Civi/Core/InstallationCanary.php).


texts:
Activity Search is failing every time for this install (Search/Find Activities) no matter what search parameters are used. The problem is the following SQL error:

SELECT count( DISTINCT ( civicrm_activity.id ) ) as rowCount  FROM civicrm_contact contact_a   LEFT JOIN civicrm_activity_contact
ON ( civicrm_activity_contact.contact_id = contact_a.id )  LEFT JOIN civicrm_activity
ON ( civicrm_activity.id = civicrm_activity_contact.activity_id
AND civicrm_activity.is_deleted = 0 AND civicrm_activity.is_current_revision = 1 ) INNER JOIN civicrm_contact
ON ( civicrm_activity_contact.contact_id = civicrm_contact.id and civicrm_contact.is_deleted != 1 )  LEFT JOIN civicrm_activity_contact source_activity
ON (source_activity.activity_id = civicrm_activity_contact.activity_id
AND source_activity.record_type_id = 2)
LEFT JOIN civicrm_contact source_contact ON (source_activity.contact_id = source_contact.id)  WHERE  ( civicrm_activity.activity_type_id IN ("110") AND civicrm_activity.status_id IN ("1", "2") AND civicrm_activity.is_test = 0 )  AND  (  ( civicrm_activity.activity_type_id IN (110,135,136,120,1,2,3,116,4,9,12,5,6,19,22,34,40,44,37,38,39,45,41,42,43,52,49,50,46,47,48,51,64,114,115,68,73,74,75,76,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,96,97,99,100,101,102,103,104,105,106,107,108,109,111,113,117,118,119,121,122,123,124,125,126,127,128,130,131,133,134,137,138,139,140,141,142,143) )  )  AND (contact_a.is_deleted = 0) AND (civicrm_activity.activity_type_id Array)

the error message is 'check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Array)' at line 8]'

As you can see this install has a lot of activity types - could this be the reason? The last 'AND' statement seems to be the problem.  This is on 5.28.3 and activity search is working fine on other 5.28.3 systems. Also there seems to be no limit on the number of items in the 'IN' clause in MySQL.


texts: Installer fails with Cannot execute CREATE TABLE civicrm_acl_cache

texts:
First, thanks to anyone who takes a look at an issue I can't get to the bottom of regarding a Civi 5.33.2 install.
The issue: When running the installer I get the following error:

Civi\Setup\Exception\SqlException: Cannot execute CREATE TABLE civicrm_acl_cache ( id int unsigned NOT NULL

There is more to the error but I believe I am stuck on permission issue. I seem to be missing a GRANT privilege but I can't find which one I'd need.
Installing CiviCRM 5.33.2 under Drupal 7.78. I have a separate Civi MySQL 5.7 database (running under Centos 8) from my Drupal database but I use the same user to access both databases. I've created the civicrm database as follows:
CREATE DATABASE civicrm CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, TRIGGER, CREATE ROUTINE, ALTER ROUTINE ON civicrm.* TO 'accessuser'@'localhost' IDENTIFIED BY 'somepassword';
I have the CREATE privilege so it's odd to be told I can't CREATE a table. Any ideas?
Thanks


texts: email template sent instead of actual email

texts:
This is a weird one.  I wanted to send an email to four specific Contacts, all members of one of our Groups.  I searched to display the Group list, selected the four contacts, and gave the action to "Send email (50 or less)".  I used an older template to get started, but edited it extensively, added myself as a bcc, and sent it out.  Seemed to go just great.

I later discovered that one of the four did not receive the email, but instead received (at the exact same time as the other emails) the text of the template I used to draft the email.  When I look in his Activities, it shows the email as having been sent as part of the batch with four others, and when I view that entry it shows me the email as edited.  But I am quite confident he received the template version.  And incidentally, I did NOT receive a bcc of whatever was sent to him.

I'm using WordPress and CiviCRM, current versions.  Has anyone else experienced anything like this?  Is it a bug, or might I have done something wrong somehow?  How can I prevent it happening again?

Thanks!


texts:
We got 2 demo websites that we are using publicly to show translations. When I tried to update them, they returned from drush command the following:
Drush bootstrap phase : bootstrap_drupal_database() [0.19 sec, 7.5 MB]                                                                                [bootstrap]
Successfully connected to the Drupal database. [0.19 sec, 7.93 MB]                                                                                [bootstrap]
Find command files for phase 4 (max=5) [0.19 sec, 7.93 MB]                                                                                [debug]
Drush bootstrap phase : bootstrap_drupal_full() [0.19 sec, 7.93 MB]                                                                                [bootstrap]
Cache HIT cid: 8.1.16-install_profile-66ecfeb9791a023150773849f1550c5d [0.39 sec, 24.5 MB]                                                                       [debug]
Find command files for phase 5 (max=5) [0.39 sec, 24.5 MB]                                                                                [debug]
Cache HIT cid: 8.1.16-install_profile-66ecfeb9791a023150773849f1550c5d [0.39 sec, 24.5 MB]                                                                       [debug]
Cache HIT cid: 8.1.16-commandfiles-5-98c00c316acff50d31c7b21c6455733c [0.39 sec, 24.52 MB]                                                                       [debug]
Cache HIT cid: 8.1.16-annotationfiles-5-fc9c7995bc64309247ba8dcb0f2a811a [0.4 sec, 25.24 MB]                                                                     [debug]
Bootstrap to phase 6. [0.43 sec, 26.98 MB]                                                                                [bootstrap]
Drush bootstrap phase : bootstrap_drupal_login() [0.43 sec, 26.98 MB]                                                                                [bootstrap]
Find command files for phase 6 (max=6) [0.44 sec, 25.69 MB]                                                                                [debug]
Found command: civicrm-upgrade-db (commandfile=civicrm) [0.44 sec, 25.69 MB]                                                                                [bootstrap]
Cache MISS cid: 8.1.16-alias-path--cae21634989c45f52c3c725c39d2002e [0.46 sec, 27.45 MB]                                                                         [debug]
Calling hook drush_civicrm_upgrade_db_validate [0.76 sec, 29.52 MB]                                                                                [debug]
Drush command terminated abnormally due to an unrecoverable error. [1.01 sec, 37.66 MB]                                                                      [error]

CV command returns as if its not working. Tested on few websites it is working. Latest version is installed. Output is bellow:
 cv upgrade:db

  [Symfony\Component\Debug\Exception\FatalThrowableError]
  Call to undefined method Symfony\Component\DependencyInjection\Definition::setFactoryClass()

upgrade:db [--out OUT] [--dry-run] [--retry] [--skip] [--level LEVEL] [-t|--test] [-U|--user USER]

On another website that has CRM 5.20 version, CV runs smoothly. I've been trying to install to newest one, 5.28.3 but sadly it didn't work. So I did backtracking, managed to install up to 5.26.3 version. After trying to install 5.27.0 it returned same kind of errors as for 5.28.3 , website is not responsive, cant access database or Drupal front end. Drush isn't working, CV as well.
CiviCRM log is empty, PHP showed something... and got to resolution of my issues. Mikey told me to keep it as proof for others if they encounter issues so there is that. Answer for my trick question in comments!


texts:
Some time ago I saw a post about how one organization was or was considering using Civi to track not only income but to also track expenses (e.g., to track expenses against a campaign so that revenue less expenses would give true campaign net). We are interested in this, so that our board could use Civi to see revenue and expenses and not have to worry about any access to QuickBooks and reduce me having to prepare financials for them from QuickBooks. My thought would be that an expense might be a specific financial type such that a user could exclude that financial type to get revenue only, include it along with other revenue financial types to get the total picture, or include only the expense financial type to see expenses.

All that being said, I have searched high and low and can't find that post. I can't recall if it was from the CiviCRM blogs (again - looked/searched but couldn't find) or some other blog. I also searched here on Stack and couldn't find it. I did find a post about tracking scholarships disbursed (How to manage a scholarship fund?). That helps some, but curious about the entry itself (which was mentioned in the post I can't find).

Anyone recall seeing that post? Or, anyone using Civi to track expenses as well as revenue? If so, I would love to know how you are handling (i.e., how recording in CiviContribute, etc. -- presumably to get net raised as revenue less expenses the expenses must be entered as a negative amount, and whether a "generic" contact was created for payments [i.e., used as the "vendor"]). FWIW, I'm on Civi 4.6.11 and WP, but since this is not CRM specific, this is a more global question and more of a way of thinking out-of-the box on how Civi is setup and typically used.


texts:
I have a problem with one of my emailing campaign. The volume of tracked opening is equal to zero. But I see 203 clicks for this campaign, so I know the emailing was opened.
I checked the parameters, the tracking for opening was on.

What can generate this problem ? Do we have a possibility to retrive the data ?

Thanks a lot :)
Aude


texts: User lets membership expire, and then signs up again, membership stays as expired?

texts:
I have a question about membership status. I'll attempt to explain this so it makes sense, any ideas/help much appreciated!

An existing paying member let their membership expire. They then went online and signed up again for membership but this time using GoCardless Direct Debit for the first time.

It found the existing record by the email address they used.

The Contribution made for the membership went into 'pending' state with an ETA completion of 29th November 2019 00:00. This is all expected to account for the time that GoCardless sets up the direct debit.

In the Membership tab on the contact, it's still showing as 'Expired' whilst it's waiting for the DD to set up. Is this expected behaviour?

When any user signs up for membership for the first time, the Membership goes to 'Pending' state and I think we expected a similar thing would happen when a user renews an expired membership.

We use WordPress Member Sync that looks for those in 'Pending' state and still allows them access to our member-only portal on our site. We did this because of the delay when setting up a direct debit with GoCardless, we wanted users to get access straight away, so we give access to those even in 'Pending' state.

So, this means that if a user has previously expired, and signs up again. They won't get access until the Direct Debit clears because it remains in 'Expired' state rather than changing to 'Pending' once the new contribution has been made.

Is this expected behaviour? Does anyone know why the Membership changes to 'Pending' on a new sign up, but remains on 'Expired' status when a user submits a new membership once it's expired?

I hope that all makes sense! Let me know if clarification is needed on anything. Thanks all for any help provided.


texts: Is there a copy of phpunit 4 documentation somewhere?

texts:
The phpunit no longer even lists the 4.8 documentation on its website although that seems to be the version buildkit is on.

:-(

are there docs for 4.8 somewhere?


texts:
I want to Sync CiviCRM Events with WordPress custom post type. I.e. everytime I create/edit/delete CiviCRM Event the same happens with corresponding custom post type. This will bring new abilities (i.e. you'd have Featured image).
Is there a CiviCRM extension or WordPress plugin that provides this?

CiviCRM 4.7.7, WP 4.5.2


texts: CiviCRM Programmer/Developer Job Description

texts:
Does anyone have a good job description for a CiviCRM Programmer/Developer for an open position posting?

Thanks so much!

Dina


texts: How to extend end date limit for Membership?

texts:
When creating/editing membership. End date is limited to 2026 (you cannot choose it in pop-up calendar and if you try to write the date yourself(exceeding the limit) php will not let you do it. which is not enough. The end date limit must be at least 50 years more. civicrm/admin/setting/preferences/date?reset=1 is not the page that is needed.
Where would I be looking for things like that? Can I configure it through the website itself, or do I have to go look at the source files?


texts: No Civi Confirmation Email After Using Paypal

texts:
I apologize in advance, as this question seems to have been asked many times, but the answer is still not clear after looking at different responses. I am using Civi 4.7.7 and Wordpress. I am using PayPal Pro for both credit cards and PayPal, on my own website. When a client uses credit card, there is no problem, and he also receives a Civi Contribution Confirmation Email. However, when PayPal is used, a payment receipt email is generated through PayPal, but there is no Civi confirmation sent, and on the backend of Civi it says the status of the transaction is pending (incomplete transaction).

The PayPal IPN is pointing to the the homepage of my website.
Please can you tell me how to fix this problem?

Thank you!
S


texts: Recaptcha not showing on contribution form

texts:
I have registered my recaptcha with Google as instructed in the documentation.  I have then created a profile and set the advanced setting to include recaptcha.  Added that profile to a contribution form and nothing is showing.  So as a test, I added a field in the profile and the field is showing on the form but no recaptcha.  Thought maybe something is wrong with my install so I went to the Civi Sandbox and tried it, but still it is not showing.  So I must be doing something wrong, but cannot figure out what that is.
Thx
John


texts: How to set the main email account to send emails?

texts:
I'm switching my SMTP gateway to send emails from CiviCRM but for now I still have both. And even though I thought everything was sent from the newly configured service in https://domain.net/civicrm/admin/setting/smtp?reset=1 I can see in logs that automatic reminders are still sent from the previous gateway and not from the new one.
Have I missed something? Do I need to configure an account elsewhere in CiviCRM for automatic reminder or any transactional email or is this just a normal delay?
Any ideas?
Guillaume


texts: CiviCRM WordPress shortcode embedded within a tab shortcode does not load

texts:
I have a CiviCRM profile that I am using in order to allow a logged-in user to edit his/her address information. In addition, I want to display the user dashboard.
Normally, one would e.g. create a WordPress page and include the corresponding shortcodes like the following:
[civicrm component="user-dashboard" hijack="0"]

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

What I would like to achieve is to display the shortcodes within a tabbed environment, so for example by using the tabs component from Shortcodes Ultimate. An example can be found below:
[su_tabs vertical="yes"]

[su_tab title="Dashboard" disabled="no" anchor="" url="" target="blank" class=""]

[civicrm component="user-dashboard" hijack="0"]

[/su_tab]

[su_tab title="Address Form" disabled="no" anchor="" url="" target="blank" class=""]

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

[/su_tab]

[/su_tabs]

My problem is: The first tab loads the user dashboard correctly. The second tab does not load anything. My question to the community is if anyone has had any experience with CiviCRM shortcodes embedded within any other shortcode?
Thanks!


texts: Drupal Views Exposed Filter (operators) and CiviCRM Multiple Tags

texts:
We expose CiviCRM contact tags (Tag Name) fields via Drupal Views in order to create simple contacts search by tag(s) via Drupal as front-end.
Since almost every contact has more than one tag,  "Allow multiple selections" option for exposed filter is being selected in order to narrow searches. However, search by multiple tags gives all contacts, not an "exact match" (mean, only contacts which have all of selected tags).

Example:

Bob has "black", "white", "yellow" tags;
Sarah has "red" and "yellow" tags.

Searching by "yellow" returns Bob and Sarah
Searching by "black" and "yellow" returns Bob and Sarah again, while we've expected to get Bob only.

How it would be possible to perform an exact match search?

Drupal 7.x, CiviCRM 6.21

P.S. civicrm.core.inc describes "civicrm_handler_filter_pseudo_constant" as exposed filter handler for civicrm tag field; civicrm_handler_filter_pseudo_constant extends views_handler_field_in_operator and allows only "Is one of" and "Is not one of" operators to choose from; wouldn't it be more logical to use something like "many_to_one" handler? If memory serves, it's being used for Drupal taxonomy and provides exact match for search nodes by multiple taxonomy terms.


texts: Search Builder broken with search for Member Since

texts:
Take a look at the screenshot below. I am searching for "Member since $date" and getting seriously broken results.

CiviCRM 5.20.1 on Wordpress 5.3.2


texts: Does anyone have clear instructions on how to upgrade CiviHR? The ones included on GitHub are for drupal.  I tried to do it manually by copying over the CiviHR folder with 1.6.8 but it just broke CiviCRM altogether.  I don't have access to drush or anything like that, so I can only copy it and then run the updates manually in extensions manager in CiviCRM.


texts: Can a Contact Reference field be utilised on a Webform such that the contacts pre-load on the form

texts:
Scenario. I have a field set made up of 3 Contact Reference fields, eg c1, c2, c3.

I have a webform with 4 contacts, cid1 is current user, cid2 etc are set as Static Fields and I was hoping they would show the contacts already referenced for cid1.

On cid1 i have the custom fields set to show, and for cid2 it is set to show c1, etc

The form remains blank.

My test contact did not have a c3 set. So i found a name (component was set to autocomplete) and I submitted the form with c1 and c2 showing as empty (ie existing contact reference contacts were not loading).

Outcome was a c3 was added to my record. So that last bit works fine.

Should the fields load with existing data if there is some? Have i set something up wrongly?

Happy to add screenshots etc if that helps others follow.


texts: What's the Status of CiviVolunteer 2.0's Compatibility with CiviCRM 4.7 on Wordpress

texts: I'm looking for an update on the status of CiviVolunteer 2.0 compatibility in WordPress with the latest version of CiviCRM. I'm developing a volunteer intake process and we've been stalling hoping to take advantage of the new features found in CiviVolunteer 2.0. I'm running CiviCRM 4.7.6 and an older version of CiviVolunteer (version 4.5-1.4.1) because CiviVolunteer 2.0 is not considered compatible with 4.7 and above. My understanding was that there was a blocking issue that was preventing full compatibility, but I also seem to recall hearing that you could try your luck using CiviVolunteer 2.0 and CiviCRM 4.7 together by changing the version strings before installing it.


texts: changing amount of CiviCRM recurring payments with AuthorizeNet breaks Civi's recording of the transactions after the amount change

texts:
I've got an interesting puzzle on my hands.

A client's site (CiviCRM 4.7.x; Drupal 7.x) has stopped recording some recurring transactions.

The transactions show as settled successfully in AuthorizeNet but it seems that when AuthorizeNet sends that info back to civi, it's hitting an error.

This only happens with a small subset of recurring donations, the one thing they all share in common is that the donor, after making the initial donation, decided to change how much they want to give monthly.

If I look in Authorizenet, I see that in one case the initial payment was made for $20, then it was changed to $25. All payments have the right invoice id; contact id; and everything else necessary for civi to match them up correctly.

SELECT c.id, c.receive_date, c.financial_type_id, r.amount, c.total_amount FROM civicrm_contribution c RIGHT JOIN civicrm_contribution_recur r on r.id = c.contribution_recur_id where r.amount != c.total_amount;

shows all the records having this problem.

In those cases, I believe because the Amount in the expected recurrence is not the same as the amount in the data from Authorizenet they are not getting recorded.

Does anyone have any ideas for:

1: how to edit the existing data (either in the UI, or via SQL or the civi API) so it will work moving forward?

2: where I might start digging to find where this is happening and how I might fix it?

Thanks


texts:
I am using xampp on ubuntu 15.04, with CiviCRM 4.7 and Dupal 7 installed.
I am following the tutorial here:

https://github.com/totten/civix/blob/master/README.md

I have git and composer installed. I have also installed box as indicated here:

http://box-project.github.io/box2/

When I run the command:

php -dphar.readonly=0 `which box` build

I get the error:

  Could not open input file: build

I have installed civix and need to create an extension. Is it ok if I just skip the build process?


texts: push notification for the registerd participants for an event

texts: I want to send the push notifications for the participants who have registered for the particular event.How can I approach using drupal push notification module? can anyone please help me?


texts: CiviCRM profile search not working when integrated with Wordpress

texts:
We're currently facing an issue. We are running Wordpress 4.9.8, and running CiviCRM. We're looking to publicly display a search widget on one of our wordpress pages, to search within a specific profile we have created. For background, this is how the process works:
Client fills out an application (Caldera Form), that form is processed and put in CiviCRM. We then go to each application and change each one to the contact type "Approved", which puts them into a Smart Group for only approved organizations. This approval system is so we can control which organizations are publicly displayed on the website. We then have made a profile with the specific contact information we want to display, and we have limited the profile listings to the specific "Approved" smart group.

Here's our issue: The search box appears publicly on our wordpress website, but any time someone attempts any search, the user is redirected to either a completely blank page (firefox) or a page with an HTTP 500 error (Chrome). The Url for this website follows this format, in case it's relevant: ....wordpress.org/..../?page=CiviCRM&q=civicrm/profile .

Here are some troubleshooting steps we've attempted and clarifying information to make help easier:

The Profile has "Standalone Form Or Directory", "Search Views", and "Is the CiviCRM profile active" all selected
The Profile's listings are limited to a specific Smart Group, in this case, the "Approved" Smart Group
This Smart Group has "Expose Publically" selected
Smart Group Visibility is set to "Public Pages"
Smart Group has "is active" selected
The Smart Group definitely has contacts in it, so it is not empty
The Search does not work in any situation, whether or not we put in search parameters or not
The error we get is "HTTP Error 500"

Any help you can provide would be greatly appreciated. Thanks in advance.


texts: Is there a checklist for setting up a new organization's website + CRM?

texts: I'm meeting with an organization later this week to begin the process of seeing them up on civiCRM and a Drupal website.  Curious any of the people who does this regularly if you have a document that helps you cover all the information you need to obtain in order to get things started? Would you mind sharing it with me so that i can make sure this goes as smoothly as possible?


texts: How can I set the maximum number of processes?

texts:
I thought I had a fix, but I'm still getting a 500 error on importing a batch of 16 organizations. Host tells me CiviCRM is spawning more than 30 processes, which is the host's limit.

Trying to get Civi to work on my current host. It's a shared server with a decent host with their top tier plan. Moving everything for Civi isn't an option I'll consider since I have 40+ dev and low traffic sites set up on the account that are all working well within plan limits. I installed Civi there for my education. So if I have to buy Civi-specific hosting, I'd prefer to poke around first.

Any ideas how I can limit the number of processes Civi spawns on import?


texts: PayPal Website Payments Pro: This transaction cannot be processed. The merchant's account is not able to process transactions

texts:
We are getting the following PayPal error when trying to process a direct credit card payment via the PayPal Website payments processor on our event page:

  10549 This transaction cannot be processed. The merchant's account is not able to process transactions.

  The merchant account attempting the transaction is not able to process
  Direct Payment transactions. Contact PayPal for more information.

We do have a business account, so that can't be it. Am I correct in assuming that this is because this processor no longer works with current PayPal accounts? Do we need a legacy PayPal account? Or is there something else going on?

We are on Wordpress/CiviCRM 4.7.7


texts: Where does Civi store membership and membership signup info?

texts:
We are moving to a new site, and when I tried to import our entire current Civi MySQL database to the new site, I had problems.

So I have created a fresh database on the new site and want to try importing things bit-by-bit, starting with memberships.  We have a membership signup page as well as info about past signups.

Can anyone tell me which tables from the current database I need to import to the new site? Any other advice/warnings would be welcome, too!

I am not able to get into the Civi interface (e.g. contributions, events, administer) on the current site, but can access the Civi database. So I want to do this just by exporting and importing from/to the databases.

(I can access Civi and WordPress files on both sites via FTP if that's helpful.)

Both sites are WordPress 4.9.1 and Civi 4.7.29.

Old site is at 1and1, new site at civihosting.


texts:
Trying to find details on how to remove a CiviCRM test data setup I've created.  I'm using Wordpress 5.3.2 multisite and CiviCRM 5.22.1.   I've installed CiviCRM into the plugin directory which appears to work...

.. as I installed a CiviCRM instance in one of the domains.  The installation used my default Wordpress database, and I'd prefer to do it again, but using a new database (and also in a different domain).

I'd like to have two instances, using the same code, but ideally accessing different databases for the CiviCRM data.

Anyway can't see any documentation on how to to remove the CiviCRM database and get to the position where I can reinstall in the two domains. Any suggestions on how to remove the CiviCRM database - and if this is documented anywhere?

Thanks for any assistance


texts: Can I use a membership custom field in a renewal confirmation e-mail

texts:
I use a custom field in my membership records (Reference code). This custom field {membership.custom_8} i can use in e-mail reminders of the type membership that i use to warn members about an expiring membership. This works fine.

When i renew a membership i want to send a confirmation e-mail to confirm the renewal. To accomplish this i created a reminder of the type Activity. In the e-mail template i would like to use the custom field mentioned before. The e-mail is sent okay but now the custom field is not displayed.

Any help or advice would be appreciated.


texts: Available countries list won't appear when set in Localization

texts:
We just upgraded to version 4.7.1, which reset our localization values.

Our forms need to display a list of all possible countries for our contact address fields.

However, when I go to Language and Currency Localization and remove all options from "Available countries," which leaves the field blank, our forms display a squashed box with only one option: the United States.

When I then go back to the Language and Currency Localization page in CiviCRM, I see that the United States has been added back into the Available countries field.

How can I include a list of all countries without manually adding them one by one, which looks to me right now like my only option?


texts: Registrant and Contribution status remains "Partially Paid" even though amount owed was paid off

texts:
STEPS:
1. User buys tickets for an event (e.g. 2) - this is set up as a Price Set w/ a Text / Numeric Quantity price field
2. Later wants to buy more - CiviCRM admin goes to the contact record, locates the event and using Change Selections adjusts the number of tickets (e.g. 5)
3. This creates a Balance owed on the event registration and the status of the Registration and the Contribution changes to "Partially Paid"
4. The admin then processes an additional payment for the amount equal to the balance owed using the Record Payment link/function

RESULT:
Both the Event and the Contribution statuses remain "Partially Paid"

EXPECTED:
The Event Registration status should change to "Registered" and Contribution Status to "Completed"

QUESTION:
Do I have this right/wrong?

System: Joomla 3.4.8; CiviCRM 4.6.11
Reproduced on the Joomla demo site

Thanks a lot, P


texts: Case Details Report- Active Case Role filter

texts:
Trying to run a case details report for all cases of type "x" opened between a given date range.

Noticed that not as many cases as expected show.

On further investigation found that there is a filter in the template
Active role:is equal to- options yes or no
Which effectively switches between open and closed cases

Anyone know the reason for this?

there is no option for neither, and the filter can't be removed, so I'm now left creating two reports for every case type on the system. Or creating a drupal view per case type


texts: CiviMail broken after upgrade from 4.7.20 to 4.7.27 (Drupal 7.56)

texts:
When I click Mailing > New Mailing, I get the following URL :
https://mysite.com/civicrm/a/#/mailing/new, (instead of
https://mysite.com/civicrm/mailing/new ?)
... and I am driven to a dashboard page

When I select a Group and want to send a mailing, the same happens

Any help is welcome


texts:
I am importing a new database into CiviCRM using the CSV import method in: Contacts > Import Contacts. In the downloaded CSV file with the list of errors, I get next error for a lot of entries:

Invalid value for field(s) : Individual Prefix

I suppose it is related to the list of prefixes I introduced in: Administer > Customize Data and Screens > Dropdown Options > Individual Prefixes

In the CSV file used for importing the contacts, I put the value corresponding to the dropdown option. The error above is caused by a lot of entries with "2" as value, when there is actually an option with value "2" present in the different options available.

I wonder what could be the cause this error.


texts: Is it OK to switch to PHP 7.2 now that Drupal 7.6.1 supports it?

texts: Drual 7.61 was released a few days ago and I notice now "fully supports PHP 7.2".  So, can we move to PHP 7.2 for CiviCRM where it runs with Drupal 7.61?  I've updated a couple of my Civi sites to Drupal 7.6.1. and PHP 7.2 and all seems well, but when I look at stats.civicrm.org there seems very few sites running PHP 7.2 which makes me wonder why. So it is OK to move a Civi site to PHP 7.2?


texts: How do I reclassify a contact to be a household when it has been created as an organisation?

texts: Some of our household contacts have been wrongly inputted as organisations and I would like to alter the classification of the contact to make it a household rather than an organisation and vice versa.....


texts: Class naming and namespaces: best practice as an extension author?

texts:
Noting these related questions
(1
2
3)
and these two wiki pages
(1
2)
and the psr-0 standard, I remain a bit lost about current best practice in CiviCRM extensions!

So if I have an extenstion org.goodfolk.magichtml

Would I put my classes in

org.goodfolk.magichtml/Civi/MagicHtml/

So in org.goodfolk.magichtml/Civi/MagicHtml/HtmlFlash.php I would have the following:

    <?php
    namespace org.goodfolk.magichtml/MagicHtml;
    class HtmlFlash {
      public function squirmLeft() {};
      public function squirmRight() {};
    }

Is that correct?

or can it be simplified to:

org.goodfolk.magichtml/Civi/HtmlFlash.php:

    <?php
    namespace org.goodfolk.magichtml;
    class HtmlFlash {
      public function squirmLeft() {};
      public function squirmRight() {};
    }


texts: How can we make Event custom fields available as tokens for scheduled reminders?

texts:
We've done some investigation and found two places we could intervene to make this possible:

Intervene here: CRM_Core_BAO_ActionSchedule::sendMailings(), but to make tokens available we'd have to collect all custom field info for a specific event. This would possibly be very database heavy, and further, it can't be optimised for when only a (small) specific subset of tokens are used in the scheduled reminder.
Or we could intervene here: hook_civicrm_tokenValues()
But at this point we no longer know for which event we need to get the additional custom field data from.

So, what to do? Any ideas? Thanks for your help!


texts: Network Error on Contact Search Results page change

texts:
To replicate, search all contacts, try to scroll to page 2
"Network Error
Unable to reach the server. Please refresh this page in your browser and try again."

Reported by 2 clients, able to replicate.
Workaround is to use the 'glossary' of first letter of display name.
Pagination works fine after this.
Reverting to 'All' also reverts the problem

Replicated on CiviCRM v 5.11.0 and 5.12.0
Wordpress 5.1.1 and Drupal 7
Ubuntu 16.04 PHP 7.1.24, Apache


texts: Errors not showing against custom fields using hook validateForm()

texts:
Using this code

if ($fields["custom_111_79"] == 0) $errors["custom_111_79"] = "Please enter number of physio sessions";

The evaluation is done correctly, but the error message does not appear against the custom field, but instead as a general error message top right of the screen.

This is in civi_case.

Is this supposed to work?
Is there another way of making custom fields work like normal fields?


texts: How to export civievent participant list to a csv file?

texts: How can I add the ability to export to a csv file? Right now the only export option on the actions menu is to a Microsoft Excel file.


texts: CiviCRM 'Detailed Logging' removes former 'Changelog' entries on contacts

texts:
CiviCRM 4.7.x

We used CiviCRM for many years and relied upon the normal 'changelog' then we enabled 'Detailed Logging' a few weeks ago, and the old entries from the tab disappeared. Do they still exist in the DB or a file, and are they recoverable and able to be displayed?


texts: CiviContribute form - no send through to payment (PayPal) screen when not logged in to Civi (refresh instead)

texts:
We have set up a CiviContribution form which works well when someone uses it when logged in, but unfortunately it doesn't work for someone who is not logged in to Civi. We intend to use the form specifically for people who don't have a Civi login. What happens is that when someone completes their details (contact and amount they want to contribute) and they click 'confirm contribution' the page is refreshed instead of proceeding the confirmation page.

We have contacted PayPal and the issue is not on their side.

We have checked the permissions and have these on:
- CiviCRM: profile create
- CiviCRM: profile edit
- CiviCRM: profile view
- CiviCRM: access all custom data
- CiviContribute: make online contributions

Would anyone have any idea how to fix this?

Many thanks,
Jantine


texts: list of all participations for a contact

texts:
I am trying to get a list of all Ids of participations for a certain contact_id (to use it in JS). Currently I am using the _civicrm_buildForm hook to do that, but to extract the contact_id from the passed in $form object I need to use reflection, since is is stored under _form_values which is protected and $form->getFormValues() always returns NULL.

Also CRM_Core_Resources::singleton()->addScript($script, 5, 'page-footer') doesn't seem to have any effect, probably its too late to call it. So I'm simply echoing the script.

==> all less then ideal
I assume it is possible to get the participant ids with smarty or an ajax call, but haven't found any example how to express a "Where-Clause" with those. This is the SQL-Query I'm trying to perform:

SELECT `id` FROM `civicrm_participant` WHERE `contact_id`= x

So any help to prettify the first approach or an example for the others would be much appreciated .


texts: Can Webform CIviCRM module do Line Items (PS yes it can!)

texts: How can we sell a Membership and a Calendar (that we should charge Sales tax on) and let the user make a Donation all on the same Webform Civicrm page - in a way that only the Donation amount is eligible to receive a charitable tax receipt?


texts: Civibooking WordPress admins seeing different resources

texts:
Is there a way I can have different admins seeing only their resources. For example I have two hostels, each seeing just their own bookings?

Thanks


texts: Is it possible to add contribution note when renewing membership in (one of) the next release?

texts:
I ran into this problem for a client who needs to specify, when renewing a membership, the bank name.

So I decided to store this value into contribution note, but when renewing, this field does not appears in the form.

I added this on line 409 of CRM_Member_Form_MembershipRenewal.php

   $this->add('text', 'contribution_note', ts('Note'),
    CRM_Core_DAO::getAttribute('CRM_Core_DAO_Note', 'note')
  );

And this on line 730 of CRM_Member_Form_MembershipRenewal.php

$note = new CRM_Core_DAO_Note();
$note->entity_table = 'civicrm_contribution';
$note->entity_id = $temporaryParams['contribution_id'];
$note->note = $formValues['contribution_note'];
$note->contact_id = $formValues['contact_id'];
$note->modified_date = CRM_Utils_Date::getToday();
$note->privacy = 0;
$note->save();

Here is the .tpl modification on line 176

{$form.contribution_note.label}
{$form.contribution_note.html}


texts: Can we integrate forms on wordpress using CiviCRM?

texts: I just wanted to ask what plugins or any ways to integrate forms in wordpress that can integrate using CiviCRM?


texts: Scheduled reminders on membership end date not sending

texts:
CiviCRM 4.7.28, Drupal 7

Scheduled reminders send if set for a specific date fine, but aren't triggered by membership end date - am i perhaps doing something wrong?

I have a relevant membership ending on 30/09/2019 hence the hours to test, but tried with days too.

Unless scheduled reminders are created on the membership creation, so not retroactive?

Thanks


texts: What CMS integrations are available for CiviCRM?

texts:
Many CRM platforms offer integrations with a CMS, where they can do things like the following:

Provide demographic groups to the CMS to use in personalization
Accept form posts from the CMS for lead entry
Identify CRM users on the website and track their website activities in the CRM

To what extent does CiviCRM have integrations like this for any CMS?

I've searched quite a bit, but the CMS integrations I see for CiviCRM are more of the "make CiviCRM run inside a particular CMS." Like, how to make CiviCRM run inside Drupal. (Or Joomla, or WordPress...)

If my CMS-powered website is separate from CiviCRM, what pre-built options does it have to integrate with any CMS?

I know it has an extensive API, and can all of this stuff can be custom-built, but are there are packages/modules/add-ons that bridge the gap between CMS X and CiviCRM in the ways I have described?


texts: process_membership Scheduled Job not updating membership based on Employer

texts:
While the process_membership Scheduled Job is running and reporting:
Finished execution of Update Membership Statuses with result: Success (Processed 158 membership records. Updated 0 records.)
It appears that new contacts with an Employer who has a valid membership, don't get updated to benefit from that membership.  We now have to complete that manually.
I first noticed the change with upgrading from 5.27.x to 5.28.x (I cannot tell if it was one of the smaller patches).  Upgrade to 5.29 but no change.  (WordPress 5.5.1)
Does anyone know what might be going on?


texts: Can I have more than 4 Vacancies appear on the Dashboard in CiviHR?

texts: Using CiviHR, can I set the Vacancy Dashboard to show more than 4 Open Vacancies?


texts: HTML & Event Pages: Unspecific IDs and Classes at the top

texts:
I'll be referencing the HTML created by Wordpress, CiviCRM, and possibly the Pinboard theme.

I was looking to restyle event pages (only) and began with the page with all events: /civicrm/?page=CiviCRM&q=civicrm/event/ical&reset=1&list=1&html=1

This page, including individual events, and other public-facing pages created by CiviCRM have little to nothing in ways of identifying the page by unique IDs or descriptive Classes, especially at the very top of the parent hierarchy.

It seems that every page has the same way of identifying CiviCRM's body (For me it's the class page-id-4412), is useful to select every CiviCRM page. As we continue down, we notice there is a general but clear CiviCRM class and ID beyond the initial page's header:

There is two problems I am having with this:

It has nothing specific to the type of CiviCRM page it is. ie. is it a contribution page? Event page? etc.
It is well past parent elements in the page that CiviCRM is using. ie. the header:

Has anyone found a way to select content using clearly marked IDs or Classes this early in the HTML?

For instance, to change the styling of the header between the Event list page and individual event pages appears to me to be impossible by css alone.

To select,

This does fall under the page-id-#### ID and class, but nothing specific to the type of CiviCRM page. There would need to be something more specific in the class like,

<body class="crm-individual-contribution"

If you know a workaround, I'd love to hear it.


texts: Problem local drupal 8/9 install civicrm: folder is not writable (on Windows)

texts:
I am a volunteer from a non-profit organization that has problems with the installation of civicrm. We already have civicrm in worpress on an Aruba host (and it works), but we wanted to move to drupal.
I understand that I have to install locally first and then transfer everything to my site (is that right?).
I tried to install CIVICRM locally via XAMPP and Composer on my Windows computer following the documentation (https://docs.civicrm.org/installation/en/latest/drupal8/).
When I get to the "Run the installer" step, I navigate to "Extend" and click on install the "CiviCRM Core" module.
I get the following error:
CiviCRM: System: The settings file "C: \ xampp \ htdocs \ drupal \ sites / default \ civicrm.settings.php" cannot be created. Ensure the parent folder is writable.
I tried to change the permissions and check the installation steps, but obviously something is wrong (due to my ignorance :/ )
How can I solve the problem?
Thanks.


texts: Listing only some event types with CiviEvent Widget

texts:
we are using the CiviEvent Widget, I’m struggling to figure out how to display a list of event ids, but not others using shortcode.
I would like for example to list events of id 9,10,11 exclusively.
I've tried seperating the id's by coma, semi-colon etc... but have had no success, it usually just displays the first id number i list.

Thanks for your help


texts: How can add URL to dropdown items for a profile page

texts:
I have been trying to edit the a profile page of my civicrm. I have gone the way of modifying relevant template and php file but no headway yet.

So, how can I add URL/Link (e.g. "Organisation") to the dropdown items on this profile from the UI or template?

Donation Options (the three options to unhide in the same page once clicked)


texts:
Is this an acceptable config for an automatic discount for students?

http://d46.demo.civicrm.org/civicrm/cividiscount?reset=1

(screenshots below)

When I go to view the discount, the Automatic section is empty.  On my own sites I can't get the automatic discount to apply when I view an event page that satisfies the criteria.  I've seen issues like this that are marked closed on github from May. https://github.com/dlobo/org.civicrm.module.cividiscount/pull/98.  I've tried the current git version and have the same issues.

So I think it's more likely that my configuration is wrong since the view of the discount shows the Automatic Discount field to be empty.

Can someone look this over and tell me if there's an error?

[
[]

Thank you!


texts: How can I offer recurring payments on an event registration form?

texts:
My nonprofit has an online course that we plan to treat as an event as we get set up with CiviCRM. We currently use GravityForms on WordPress to offer registrants the option of a payment plan where they choose the number of months. We'd like to do that as we switch to CiviCRM. It looks like recurring payments would be a good fit but I have yet to find a way to include fields from civicrm_contribution_recur in an event registration form.
I've explored doing this through Caldera Forms but we use Stripe and the CF plugin for Stripe sends users off the page to a Stripe page, which we'd rather not do. It would be nice to do this all within CiviCRM. The necessary fields and underlying functionality are all there but so far I haven't figured out how to access them for this use.
Any pointers about how to approach this would be greatly appreciated. I'm willing to do some programming if necessary but would like to get better oriented first.
Thanks!