texts:
After updating CiviCRM from 4.7.14 to 4.7.21, I got a strange problem. My newsletter subscription form (a profile with a name and email field) lost its Submit button. The submit button is missing from the HTML, while in 4.7.14 it was there.

The profile is included in the page via a Wordpress shortcode: [civicrm component="profile" gid="22" mode="create" hijack="0"]

I'm using Wordpress 4.8. PHP is 5.6.30. As far as I can see, I don't have any related errors/notices in either the CiviCRM or the Wordpress logs.

I have some template overrides but nothing that seems related to that profile.

Does anyone have any idea why the Submit button would not be there? Anything I can do to debug this?

UPDATE:
After I asked this question yesterday, today I had the brilliant idea to look at the template file responsible for outputting the profile. I wonder why it took me a day to think of this. Anyways.

The template file in question is /civicrm/templates/CRM/Profile/Form/Dynamic.tpl. Inside it there is the following section responsible for the buttons:

{if ($action eq 1 and $mode eq 4 ) or ($action eq 2) or ($action eq 8192)}
      {if $action eq 2 and $multiRecordFieldListing}
      {include file="CRM/Profile/Page/MultipleRecordFieldsListing.tpl" showListing=true}
        {assign var=floatStyle value='float:right'}
      {/if}

        {include file="CRM/common/formButtons.tpl"}{if $isDuplicate}{$form._qf_Edit_upload_duplicate.html}{/if}

            {ts}Cancel{/ts}

  {/if}

So apparently I need to have the correct $action and/or $mode. From the top of the file I learn about $mode:

{* Profile forms when embedded in CMS account create (mode=1) or
    cms account edit (mode=8) or civicrm/profile (mode=4) pages *}

So for me $mode is 4. But what is $action? After half an hour of googling, I found this answer which referred me to this file.

From this I gather that in my situation $action's value should be 1 (add) or 2 (update). But putting {$debug} in the template file shows that $action is 1024 (preview). This doesn't make sense.

Does anyone have any ideas why $action isn't properly set?


texts: I have a situation where authorized users can upload a scan of their passports.  While this doesn't happen often, there are times where various users will upload "Passport.jpg" as necessary.  While the upload seems to work, it appears as if we come across an issue that when we go back to look at the picture, the wrong picture is referenced.  Only the "Passport.jpg" that came from the first user will show up.  My initial thinking is that somewhere between the Civi and picture storage collection, the query looks for the name of the file rather than some other identifying field.  Is my suspicions accurate?  If so, how do I prevent this confusion from happening again?  We are using Civi 5.31.1 and Drupal 7.  The following screenshot is taken from the civicrm_file table and only showing entries where the uri field is exactly "passport.jpg".


texts: Searching based on members that have a twitter website address

texts:
Is there a way via the advanced search query to return all contacts that have a twitter website address entered?

Currently the only search item appears to just be "Your website" but I cannot see anywhere that just gives the twitter option.

I would have thought that there would be a drop down somewhere in the search criteria. Essentially we just want it the search results to list all contacts that have a twitter social media address listed.

Thanks as always for your help.

........................

Hi, Ive gone through some search build options but it still doesn't seem to pull through any contacts as required. Please see the attached images - One of the contact showing the contact type (Community Group) and the Twitter Website field. The other images are examples of the Search Build criteria

enter image description here


texts: Wordpress Ajax & pictures not loading after upgrade to 5.0

texts:
I've updated from 4.7.29 to 5.0.0
The SQL update went well, but I've issues with JS/Pictures not loading.
This is really blocking as for example, the "Create new contact" is not loading
See screenshots below.
Could you please advise ?
Thanks

Error at "Create new user page"

CiviCRM_API3_Exception: "DB Error: no such field"
0 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/UFGroup.php(3341): civicrm_api3("uf_group", "get", (Array:3))
1 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/Edit/Address.php(226): CRM_Core_BAO_UFGroup::getCreateLinks((Array:3), "shared_address")
2 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/Location.php(107): CRM_Contact_Form_Edit_Address::buildQuickForm(Object(CRM_Contact_Form_Contact))
...


texts: How can I use CiviCRM for registration, login, forgot password pages on Wordpress?

texts:
Effectively, I’m looking to completely replace the default Wordpress forms for these functions using CiviCRM, in order to get a nice integrated feel. Additionally, this will allow me to ask additional questions from a profile on user registration.
This is for a sub site of a multi site installation, which does make things a little more complicated.


texts: Unable to view profile instructions or see profile drop down menu in Contribution page

texts:
I am using WP and just upgraded to 4.7.7, and changed theme to Alone. The profile instructions to fill out are now not visible on the public contribution pages. On back end of Civi, the drop-down menu to choose a profile is no longer visible.

I think it's same problem as here https://forum.civicrm.org/index.php?topic=35782.0 I don't have jetpack, but I did change my theme.

On the upside the bug in not being able to include all countries in localization has resolved.

Any ideas on how to fix this? I paid money for this theme and I wouldn't know how to hack it anyway.

Thank you in advance.


texts: How can I avoid my import crashing with a Fatal Error due to an existing external ID?

texts:
I've had a few separate imports crash with a fatal error in the last month:

  Sorry but we are not able to provide this at the moment.
  DB Error: already exists

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

In my case it seems to have something to do with external IDs that already exist in the database and are also in the import file. How can I avoid having imports fatally die in the middle of things?


texts: Can't send individual emails from contact record

texts:
When trying to send an email from an individuals Contact Record I am getting a pop-up with the following error listed.

I can send bulk emails to a test group and when I test the outbound email settings the system is sending me an email saying the settings are correct.  I have searched for an answer to this issue but can't find anything related to the error message.
Any assistance would be appreciated


texts: CiviCRM & Joomla Username Check Availability

texts:
I am trying to get CiviCRM (5.3.0) and Joomla (3.8.10) working with the Username Check Availability link. I have checked the code and found the following:

Check Availability

I cannot figure out if I turned something off or is there a problem with the Joomla integation? The accounts are being created in Joomla when registering by using a Profile.

Any suggestions would be appreciated.

Thanks.


texts: What does the 'profile_listings_and_forms' permission allow?

texts:
I'm currently reviewing the permissions for a CiviCRM/WordPress site and want to make sure that I understand the permissions correctly before changing them.

I've found the documentation on the profile_listings_and_forms permission to be a bit unclear so I just wanted to check. Am I right in thinking that this permission is just a shorthand for allowing all four of the other profile permissions?

i.e. profile_listings_and_forms = profile_create + profile_edit + profile_view + profile_listings


texts:
I am trying to set up the cron job through the cli.php method following the CiviCRM Docs.

Running the command from my ssh session on the server as www-data user, I am getting the error:

  could not match userID and contactID

But neither the CiviCRM logs, nor the Drupal logs, nor the apache error log gives me any further hints on what this means.

I am running CiviCRM 5.9.1 on Drupal 8.6.9.

How can I solve this?


texts: Import from CSV and dedupe using Email (match to contact) with PRIMARY email?

texts: Is there a way to use "Email (match to contact)" field mapping against the Primary email address? Or are we forced to use a location type?


texts: Foreign key violation on creating new Financial Type

texts:
I've got a 5.8.2 install on Drupal 7.61. When I try to add a new Financial Type, from /civicrm/admin/financial/financialType?reset=1, and click Add Financial Type button, after I enter the info and hit Save, what I see in the GUI is that the spinner spins forever, never returning control to the user. The debug log shows (I've put some hard newlines in for readability):

[to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::exceptionHandler prefix=""
info="INSERT INTO civicrm_financial_account (name , contact_id , financial_account_type_id , account_type_code , description ,
is_header_account , is_deductible , is_tax , is_active , is_default )
VALUES ('New Fin Type' ,  1 ,  3 , 'INC' , 'New Fin Type descript' ,  0 ,  0 ,  0 ,  1 ,  0 )
[nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`drupals_uherocrm2`.`civicrm_financial_account`,
CONSTRAINT `FK_civicrm_financial_account_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL)]"]

What this seems to show is that it is trying to create a new Financial Account (which I don't really understand because I thought I was only creating a Fin Type), but the Account needs to be linked to an existing Contact, and it's using contact_id=1 as a generic default? But I don't have a Contact with this id=1 in my system.

Any clues what's going on here? The GUI for creating a Fin Type is simple and doesn't given any clues about being linked to a Fin Account, at least not at creation time. Thanks.

Edit: Here is a pastebin of part of my error log, including two examples (which should be equivalent and redundant) of the constraint violation, along with a whole bunch of other junk besides the backtrace, whose value I wasn't sure of, so it was safer to include it. I've edited the file a little to remove my real domain name, just for a little more anonymity. Hope this helps to clarify: https://paste.pound-python.org/raw/15EPAPfiKEuG7T3in945/


texts: Membership Types vs Groups vs Organizational Types vs Relationships

texts:
Still new to CiviCRM and grateful for opinions and advice. We have several types of relationship with organizations. We do not charge anything for any type of relationship.  Relationships are managed in the backend only, hence controlled by staff members who login to backend.  Relation types include endorsers, partners, affliates, council, past council, volunteers, etc.

Some groups will be listed and published on the website, so I know to manage them as "groups" since that is the only way to have a public list on a website.

What is the best way to handle the rest? Membership doesn't seem to fit since it requires some financial relationship, although 'zero' is possible.  Perhaps this is just a multiselect custom field?


texts:
Total newbie.  Don't know what I don't know...

I am trying Civi with WP.  Tried with Joomla.  I loved Drupal in another life.  :-)

Is there a simple way to make the output pages for Civi (like events, registration, etc.) prettier - more in line with the types of pages you see in a typical website?  I guess I'm spoiled with all these builders these days.

Like a theme of some sort?  Or an addon?

The presentation here is gorgeous:  https://www.cividesk.com/civicrm/event/register?id=611&reset=1

But (1) I think that's Drupal and (2) I think it's custom.

I just can't seem to find a way (short of modifying .tpl files) to make Civi look a bit better.

Thoughts?

Thanks,
Mark


texts: If I have PHP installed on nginx, and Wordpress installed too, can I still run CiviCRM as a Wordpress Plugin?


texts: D8 - can't view Contributions after upgrade to 5.28.x

texts:
When trying to View a Contribution (any Contribution) I'm getting this error on one of my D8 test sites.
Error: Class 'Brick\Money\Money' not found in CRM_Utils_Money::subtractCurrencies() (line 142 of /var/www/drupal/vendor/civicrm/civicrm-core/CRM/Utils/Money.php)

It's still at 5.28.2


texts: How long is start date? 00h00mm00ss or a 24hour period?

texts:
I have simple membership statuses that say:
Status 1: from membership date to start date
Status 2: from start date to end date.

On start date, the membership has changed from not member to member but the status stayed on Status 1. (I have set the cron every hour so it would be updated the way it should).

When is the time limit: 00h00mm00ss or a 24hour period?

How does it work in CiviCRM?


texts: Error message when testing memberships: "Expected one PaymentProcessor but found 0"

texts:
we are now trying to test the membership signups which includes recurring payments. I've gone through all the steps on the contribution pages and have not seen any errors there (except that no thank you email was sent, but this may be a separate issue from this one)

However once I go to "Memberships" -> "Find Memberships", choosing "Yes" for "Membership is a test", and clicking on "Search" I get this error:

  Sorry but we are not able to provide this at the moment. Expected one
  PaymentProcessor but found 0

Output from /sites/default/files/civicrm/ConfigAndLog:

Mar 02 18:51:27  [info] $backTrace = #0 /home/peoplesfund/www/www/sites/all/modules/civicrm/CRM/Core/Error.php(451): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/peoplesfund/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(55): CRM_Core_Error::handleUnhandledException(Object(CiviCRM_API3_Exception))
#2 /home/peoplesfund/www/www/sites/all/modules/civicrm/drupal/civicrm.module(448): CRM_Core_Invoke::invoke((Array:3))
#3 [internal function](): civicrm_invoke("member", "search")
#4 /home/peoplesfund/www/www/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:2))
#5 /home/peoplesfund/www/www/index.php(21): menu_execute_active_handler()
#6 {main}

(Entire output is not shown because a huge code mass is printed. I can provide this if needed though in a file)

I've also tried enabling debugging but the same error screen is shown

There is no problem when searching if we have chosen "No" for "Membership is a test", this will (instead of the error message) produce a list of real members that we have

Does anyone know what we can do to solve this problem? Is it likely that this will cause problems for the live contribution pages in the future (even if that is not the case right now?)

Grateful for help and with kind regards,
Tord


texts: What is the join logic when using API chaining with action = get?

texts:
I read about API chaining and I'm using it with get actions to learn more about how it works. I'm confused by the inconsistent behavior of the following two API calls:

CRM.api3('participant', 'get',
  {"id": 12345, "api.Event.get": {} });

That gets a participant record and embeds the single associated event record within the results. Cool.

But this one works differently:

CRM.api3('participant', 'get',
  {"id": 12345, "api.ParticipantStatusType.get": {} });

It gets the same participant record, but embeds all status type records within the results. Why?

In general, I'd like to understand what logic CiviCRM is using to filter the results of chained calls.


texts: Why does CiviDiscount remove the url parameters after a discount code is applied?

texts:
A typical event URL looks like this:

https://dmaster.demo.civicrm.org/civicrm/event/register?reset=1&id=3

But when you apply a discount code, the page is refreshed and the url parameters are removed:

https://dmaster.demo.civicrm.org/civicrm/event/register

This can lead to unexpected behavior when your url contains e.g. lcMessages, to force civi in a specific language.
Does anyone know why CiviDiscount removes these query parameters?


texts:
I am getting a red "Incorrect Resource URL" notice, but I can't see that anything's set incorrectly. I read elsewhere that this should result in the little arrows missing from drop-down menus, but I'm not having that problem.

WordPress install. (New - been working on it over the last week or so. Haven't gone live yet.)

I also read that this may be due to issues with symlinking, so I've used an absolute URL, not a relative one. I can access the exact location via, e.g. FTP, using the path I've put into the "CiviCRM Resource URL" field on the "Settings - Resource URLs" page.

The path I have is: /wp-content/plugins/civicrm/civicrm

Help?


texts: Issue with submitting forms - blank page

texts: We have been having a sporadic issue with our CiviCRM forms. People will fill out a donation or event registration, hit submit, and the page will go white and not go to the confirmation page. It will happen randomly and sometimes several times in a row. Anyone else experience this and find a way to solve this issue?


texts: Joomla PayPal standard IPN configuration - Pending (Incomplete Transaction)

texts:
What should the IPN be for a Joomla site

Joomla 3.6.2
Civicrm 4.7.11

PayPal standard transactgion are sticking as pending.  The  documentation states that the IPN should just be http://www.domain.com/ however this no longer works.

CRM-18483 has been logged about this issue. However it appears to be down to the IPN settings.  What should they be????  Anyone got an example that is working?

http://domain/administrator/components/com_civicrm/civicrm/extern/ipn.php

...doesn't work.


texts: What of these CiviCRM features comes 'out of the box'?

texts: On the CiviCRM demo -- there are lots of great features / fields etc.  What comes standard?


texts: Recording activities - case or contact summary page?

texts: Is it better practice to record activities in the case rather than on the contact summary?  If so, why?


texts: REST API - setting an activity's custom fields

texts:
How do I set a custom field value for an Activity via the REST API?

I can create an activity on a contact.  I am looking to set a value for a custom field within that activity as well.

For reference my current POST request looks something like this:

<www_path>?entity=activity&action=create&activity_id=0&target_contact_id=0

Any insight is appreciated!  Thanks for the help!


texts: Is it possible to get point-in-time membership data?

texts:
My client needs to know:

How many members did we have on date x
Who were the members on date x

Using "Find memberships" it appears that, though the UI allows it, combining the membership status filter with any of the date filters will return misleading/wrong results. It seems that the query there is using whatever value is in the membership status field at the time you run the report to evaluate against the filter. (Is there a way to tell what query CiviCRM is running?)

How can I best deliver this historical information to my client.

The site in question is running CiviCRM 4.4.14 with Drupal 7.36.


texts:
Prior to updating to CiviCRM 4.7 our customers received receipts that included:

Membership fees with each item listed separately with a description
and price.
The Transaction number
The Billing Name and Address
The Credit Card Information (only last four of credit card)

After we installed 4.7 this information stopped displaying on the receipt.

I have reviewed the receipt template. I did not see anything that should change this.

Is there a new setting that I am missing to display the transaction details?


texts:
I would like to open a modal with options editor inside (please see the screenshot below). I would like to call a custom JavaScript function whenever an option has been changed via that modal. By "changed" I mean added, renamed, deleted, disabled, reordered etc.

As per https://docs.civicrm.org/dev/en/latest/framework/ajax/ there are a couple of events related to dialogue forms that you can track, including crmFormSuccess. This event will fire on the label change, or new element addition, but not on the enabling/disabling or reordering.

The code snippet:

CRM.loadForm('/civicrm/admin/options/individual_suffix?reset=1')
  .on('crmFormSuccess', () => {
    // will not trigger on reordering or enabling/disabling
    console.log('Updated...');
  });

Is there a similar event to handle these events as well?


texts:
I'd like to have a large number of smart groups but don't want to bog down the site when employees are using it. Is there a way to set up a smart group so that it will only update itself at a particular time of day, say only out of business hours sort of thing?
Thanks in advance


texts: Donor personal information exposed in Google searches

texts: We have been receiving reports of our donor's personal information (name, address, city, state, zip, phone number, CiviCrm internal contact ID#) being presented in a Google search. We are using CiviCrm 4.7.22 installed in Drupal 7.56. We must be able to assure our donor base that all personal information is not released from our database. We do use on-line contributions, event registrations, regular emails etc. to interact with our donors. There is some urgency in this request.


texts: Why does CiviCRM render a validation failure without the Wordpress theme?

texts:
I have a wordpress site http://logisticsworkersnetwork.org/

There is a 'profile' sign-up form on the front page. The sign-up form works fine but there is no CSS or theme html when someone makes a mistake on the form. It goes to this page: http://logisticsworkersnetwork.org/?page=CiviCRM&q=civicrm/profile/create&page_id=2 and just shows the error and the form in pure html. That is, it shows the PRINTER-FRIENDLY version of the page. The console error says:

Uncaught ReferenceError: CRM is not defined  (anonymous function)   @   ?page=CiviCRM&q=civicrm/profile/create&page_id=2:100

NB: I have removed the civiCRM CSS file with Jquery. I also have a few hidden fields which are shown when a validation error occurs. This problem only arose after I switched from my localhost environment to my server (bluehost). I upgraded to civiCRM 4.6.2 (from 4.5.8) when I uploaded the site too.

UPDATE (12/May/2015):
I have tried deleting the 'templates_c' folder but it doesn't work. I have tried clearing the cache.


texts:
I have now a new issue with one of my CiviCRM website.

My provider (Infomaniak) decided to move to a new server.

All my Joomla website works well but I have now a trouble with CiviCRM.

When I start it I get this :

XML data could not be loaded. Make sure you specified the correct path.
Call stack
#   Function    Location
1   JAdministrator->dispatch()  JROOT/administrator/index.php:46
2   JError::raiseError()    JROOT/administrator/includes/application.php:164
3   JError::raise() JROOT/libraries/joomla/error/error.php:251

Could someone help me ?

Thanks a lot for your answer !


texts: Why do some From addresses work and others get rejected

texts:
I'm having some strange problems with sending out emails.

I've run a number of tests using different From addresses, and some of them work fine, but others are rejected by the recipient mail server. Here are the results of 9 different From addresses:

Fail:

xxx_xxxxxxx@hotmail.co.uk

xxx_xx@hotmail.com

xxxx_xxxxx@yahoo.co.uk

xxxxxxxxxxxxx@yahoo.co.uk

Succeeds:

xxxxxxxxxxxxxxxx@gmail.com

xxx.xxxxxx.xxxxxx@me.com

xxxxx.xxxxxxxxx@talk21.com

xxxxx@xxxxxx.org.uk (same domain as site)

xxxxxxxxxxxx@xxxxxx.org.uk (same domain as site)

xxxxxxxxxxxx@djinter.net

They don't fail for all recipients - there are clear patterns about which succeed and which get rejected. Most of the main webmail services: gmail, yahoo, hotmail, etc are rejecting them. Lesser know mail servers (presumably with less stringent criteria) are accepting them.

Outbound Mail is set to mail().

Any one else had problems like this, or able to offer advice?


texts:
I have a minor problem with the configuration over the GUI of the CKEditor. In short words: It doesn't work! ;-)

I took a view into this, and it seems, it is a problem on my server with the url rewriting.

The settings GUI tries to load two files:

http:///civicrm/admin/config.js?t=FB99
http:///civicrm/admin/lang/de.js?t=FB99

I'm afraid, this are wrong urls, coming someway from url rewriting.

The maileditor works just fine, and gets the files from their "non rewritten" url:

http:///sites/all/modules/civicrm/bower_components/ckeditor/config.js?t=FACJ
http:///sites/all/modules/civicrm/bower_components/ckeditor/lang/de.js?t=FACJ

No real problem, because I may hack config.js by hand, instead using the GUI, but would be nice to have...

Bye


texts: Error when trying to print/email invoice

texts:
I have been trying to send old invoices to members. When printing to pdf, the file is essentially blank. When using the the email button I get the following error. Any help would be greatly appreciated:

Notice: Undefined variable: CRM16923AnUnreliableMethodHasBeenUserToDeterminePaymentProcessorFromContributionPage in CRM_Contribute_BAO_Contribution->loadRelatedObjects() (line 2410 of /var/www/html/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php).
Notice: Undefined variable: invoiceNumber in CRM_Contribute_Form_Task_Invoice::printPDF() (line 569 of /var/www/html/sites/all/modules/civicrm/CRM/Contribute/Form/Task/Invoice.php).
Notice: Undefined property: DOMAttr::$value in Dompdf\Css\AttributeTranslator::translate_attributes() (line 233 of /var/www/html/sites/all/modules/civicrm/vendor/dompdf/dompdf/src/Css/AttributeTranslator.php).
Notice: Undefined property: DOMAttr::$value in Dompdf\Css\AttributeTranslator::translate_attributes() (line 233 of /var/www/html/sites/all/modules/civicrm/vendor/dompdf/dompdf/src/Css/AttributeTranslator.php).
Notice: Undefined property: DOMAttr::$value in Dompdf\Css\AttributeTranslator::translate_attributes() (line 233 of /var/www/html/sites/all/modules/civicrm/vendor/dompdf/dompdf/src/Css/AttributeTranslator.php).
Notice: Undefined property: DOMAttr::$value in Dompdf\Css\AttributeTranslator::translate_attributes() (line 233 of /var/www/html/sites/all/modules/civicrm/vendor/dompdf/dompdf/src/Css/AttributeTranslator.php).
Notice: Undefined property: DOMAttr::$value in Dompdf\Css\AttributeTranslator::translate_attributes() (line 233 of /var/www/html/sites/all/modules/civicrm/vendor/dompdf/dompdf/src/Css/AttributeTranslator.php).

Error messages continue for quite awhile but are pretty similar and look to be related to the html to pdf converter.


texts: How do I limit the number of ticket to be sold in events

texts: We have a event created, where the maximum participants are set to 120. But since a single participant can buy a multiple ticket, I am not able to find a way to limit ticket to be sold to 120.


texts: How to create an v4 api using civix tool?

texts: I am using civix tool to create an extension. I created an API using civix tool.I want to create API v4. How to create API v4?


texts: Webform Event Registration skips payment processing

texts:
Following the tutorial at Civiteacher.com on "How to: Register for Multiple Events With Webform," registering for an event works, but it skips the payment procession section.

Logs report this error:

The CiviCRM "participant getoptions" API function returned the error: "The field 'fee_amount' has no associated option list." when called by line 1459 of utils.inc with the following parameters: "Array ( [field] => fee_amount [context] => create [event_id] => Array ( [259-9] => 259-9 ) [role_id] => 1 [options] => Array ( [limit] => 9999 ) [check_permissions] => [version] => 3 ) "

This occurs whether I am logged-in or not as well as with the "CiviContribute: access CiviContribute" given to everyone (just for testing purposes!).

Additional information:

I set-up the Participant Fee by checking the box by "Webform>Civicrm>Event Registration>Registration>Participant Fee"; it is using the "Select options" widget
The Webform Element is of type "Radio buttons (static)"
Running Civicrm 4.6.3, Webform 7.x-4.9 and Webform Civicrm integration 7.x-4.10

Additional information - 2:

Using PayPal Standard as the payment processor.

By "skips" I mean submitting the form results in a confirmation page – no chance to enter payment information:

Above goes directly to this:

Here's how I've set up the webform participant fee:


texts: Translation Import Membership in navigation menu

texts:
(version 5.18.4 - Joomla with multilingual Dutch)

In the navigation menu under Memberships there is the menu-item Import Membership. I think it must be Import Memberships. When i change it with: Admin Navigation Menu to add the 's', the item Import Memberships is translated.

In civicrm_data.tpl it is Import Membership, but in menu.po Import Memberships.


texts:
CiviHosting has sent a notice to all their customers that they are upgrading all their servers to MySQL 5.7, despite their acknowledgement that CiviCRM prior to version 4.7.7 "may fail". They plan on performing this upgrade in one week, August 17.

For those customers that are not able to upgrade to a compatible CiviCRM version at this time (due to various customizations),  what are the various issues that can be expected?

I know of the lock name length issue (When upgrading from 4.7.7 to 4.7.8 I get error "Specified key was too long") which appears to be an upgrade process issue.  (Does this problem extend back to prior to 4.7?)

What else is there to be concerned with, particularly with versions 4.4.x, 4.5.x, and 4.6,x?


texts: Can I create a custom System Workflow Message for a particular Contribution Page?

texts:
I need to create a custom system workflow message for

Contributions - Receipt (on-line)

that will be used instead of the default template when a particular contribution page is used.

I already know about the Receipt tab of the contribution page wizard. There I can prepend text to the receipt that is unique to that contribution page.

But I need to fuss with the template itself. I  know about the System Workflow Messages at: civicrm/admin/messageTemplates. The problem there is that the change applies to all contribution receipts. I'm looking to change the template only for a particular contribution page.

I'm using CiviCRM 4.5.8 on Drupal 7.36.

Thanks.


texts: Can we manually change recurring payment subscription statuses in the database if they're no longer linked to their original membership?

texts:
We have ended up with about 30 recurring payment subscriptions in Civicrm that are either not connected any longer to their corresponding ARB in Auth.net, or they are no longer connected to to the membership they originally belonged to. (Because someone has cancelled auto-renew on the membership without attending to the recurring payment.)

So, my question: How can we edit Recurring payment subscription statuses when they have become dysfunctional in relation to Auth.net or to their original membership?

The best way I can think of would be to go into the database and change the relevant recurring payment subscriptions' contribution_status_id to whatever is appropriate. Most of the time this will be the status id for cancelled.

Will I get away with this? Remember, the subscription is already dysfunctional. I'm aware that if I changed this on a functioning subscription havoc might occur.

One thing that may be relevant... as I mentioned above, there are situations in which we have a functioning ARB in Auth.net, a corresponding and functioning Recurring Payment subscription in Civi, but which is no longer linked to the membership that created it, cos that membership is no longer in auto-renew state. So Auth.net will be pinging this Recurring payment subscription in Civi... the money just won't be getting allocated anywhere.

Would that be a problem?

I'd like to be able to set these subscriptions' statuses to 'cancelled' even though they're active, since they no longer relate to a membership (we then report on them manually).

Or is there a better way to accomplish all this? Thanks for your help!


texts: How do I connect a Drupal content type to CiviMail? CiviRules?

texts:
I'm still getting my head around CiviCRM, and also only have admin access (but not sftp) so if I need to get into the code I'll have to ask our external support team.

I want to be able to take the HTML from a certain type of content when posted on our Drupal 7 site (Media Release) and automatically send it to a CiviCRM Mailing List group.

CiviRules out of the box only allows CiviCRM events as triggers; is there a robust way to link it to Drupal events? Is it only possible through code rather than a UI option somewhere?

Addendum: I've started playing with com.pogstone.contenttokens to get drupal content across, but am not sure how to get the full version rather than a teaser.


texts: I have uploaded Civicrm 5.12.0 on a Drupal 7.65 site via FTP. After upload was completed, I attempted the installation script, but nothing happened. Is there a step that I forgot to do or wasn't aware of?


texts: Where do I change the due date for event invoices and can I set a fixed date instead of a variable date?

texts: In our case, the invoices are being sent with each "pay later" event registration. The default appears to be 10 days. The client wants to change the date to September 3 of this year. Do I need a new invoice template? Can I do that? Can I do this somewhere in the Event setup for a set due date for all registrations?


texts: How to generate a monthly report for multiple years?

texts: I would like to generate a report that shows monthly breakdowns for last 4-5 years. Is there a shortcut to do it? thanks


texts: invoice has 1 line item, but showing full price

texts: I have setup a webform to sell tickets to events. A user can add multiple ticks for multiple users. When printing/emailing the invoice only 1 ticket appears. When viewing in the Civi dashboard the correct amount of tickets appear. I have added screen captures to show in more detail. Has anyone else experienced the same issue? Cheers.


texts: Error Message on Event Registration - Known Issues?

texts:
Using CiviCRM 4.6.28 and Drupal 7
Using Custom Profiles in CiviEvents
No Payments
Not Able to Recreate

We have an ongoing issue of error messages after applicants submit a CiviEvent registration form.

We noticed this started to happen when we added questions with the formate of Rich Text Editor.  Is this a known issue?

According to our consultants the issue is a time out issue.  Is this a known issue?  If it is a time out issue, does someone know how to make a change to the back end to not have the system time out?

We have not been able to recreate the issue.  We have changed all of our questions back over to text only fields in the hope that is the issue.

Thank you


texts:
Can WooCommerce products be synced into CiviCRM Custom Fields?

I tried creating checkboxes in CiviCRM under a custom field & they are not getting checked off when someone purchases something in WooCommerce....

Any feedback?


texts: Unable to see or modify rights in "WordPress Access Control" panel

texts:
I'am running a 4.7.27 civicrm on wp. Strangely, for some reason i still ignore, unauthenticated visitors can't suddenly access the petition form (civicampaign) what is a quite big problem because i am engaged in such important campaign.

After reading documentation, I tried to change the access rights from the page "WordPress Access Control".

For another unknowned reason, the "WordPress Access Control" form looks empty (screenshot) and can't be modified despite the fact that i am admin.

If somebody can help me...


texts:
I have stupidly unticked both the main and secondary menu in the Bootstrap settings options (too many windows open!). I have lost both the Drupal and Civi menus and basically all administrator ability to access/edit anything via the frontend.. :(

I can get back to the Bootstrap settings page via the browser back button but now just get and now get "access denied" if i try to re-enable the menus. Any pointers where to go on the backend to restore? Many thanks.


texts: Not all tags are available in a Contact Search

texts: I have created a tag set which has one tag, "Changed Address". This tag is set using a rule when a contact's address is changed. When I perform a contact search, this tag does not show in the list of available tags.


texts: Is CiviCRM available with German admin interface?

texts: Looking at using CiviCRM in an office based in Germany with German-speaking staff. Is there a localised version available, e.g. admin interface in German?


texts: CiviMail mailing has 0 intended recipients

texts:
I'm having precisely the same problem as a number of others have reported here: When I create a mailing, and add a group os users, I get a notification of no intended recipients, and when I succeed in sending the mail anyway, the report says no recipients. It is precisely the same situation as described here:

CiviMail mailing sometimes has 0 intended recipients

However, I'm using CiviCRM on a Joomla 3.6.2-site, not Drupal (CiviCRM 4.7.10 - no extensions installed). I have the same situation where I seem to be able to send test-mailings manually. So I guess this might be something to do with access rights. But where and how do I check that in a Joomla-installation? I'd very much appreciate some help on this, as it is critical for our organization to be able to send these mailings...

Magnus Larsson


texts:
I'm using CiviCRM as Joomla component
Joomla users are not connected to CiviCRM contacts
There are Organizations and Individual contacts
Each Individual contact belong to Organization (employer) and has a specific group eg "Representative", "Librarian" etc.

Updating profile info:

Organizations get an email (through mailing functionality) with personalized URL to update their profile fields.

PROBLEM:

What is the best way to enable Organizations admin to update/add/delete Individual contacts which belong to that specific organization?


texts:
I've recently imported about 10,000 records into our database, many of them adding an additional work email address to our existing contacts whose home email address we used to contact.

When the new work addresses were imported, it seems that many/most contacts now have their new work email as their primary.

Is there any way to change the users' primary email to their home one, en masse?


texts: what type of protocol and api connection is used for authorize.net

texts:
Authorize.net will disable older protocols, TLS 1.0 and TLS 1.1, which are highly vulnerable to security breaches. They will be disabled by Authorize.Net on February 28, 2018

What type of protocol and API connection does CiviCRM use?


texts: Disable opt-in e-mails for joining groups

texts:
I use a custom Drupal Webform for contacts to join groups. This happens within a restricted environment, the user is logged in and managing his/her own profile behind a password. I don't want any e-mail to be sent.

When a group is marked as 'mailing list', CiviCRM sends out a confirmation mail. If a group is marked both 'mailing list' and 'access control', no e-mail is sent.

I've unchecked 'Enable Double Opt-in for Profile Group(s) field ' in the CiviMail component. Doesn't seem to make a difference (this is not a 'profile groups checkbox' as per the description there i think - its a webform).

So I'm about to check the 'access control' for a dozen of groups, only to disable the e-mail confirmation. What am I doing wrong ? :-)


texts: french Installation of civicrm 5.27.2 on drupal 8

texts:
i want to install civicrm in french in my drupal 8.9.2 website. after following the instruction in this website https://lab.civicrm.org/dev/translation/-/wikis/Administrator-Guide. it's not work for me. please show me the best method install
cheers


texts: How can I alter next value of membership id (which would be auto incremented)?

texts:
I have an external identifier which has been imported and its max value is 10000, whereas it needs to be used as membership id, but membership id max value is 1500.Now to keep the Id of the membership consistent with external identifier, I want to start next membership id as 10001 instead of 15001.
Is there a way to incrememt the membership id from 1500 to 10000 in database?


texts: HowTo: crmApi get rows with date between

texts:
I want to get all memberships with start date between '2016-01-01' and '2016-06-01' using crmApi(). Here's my code that's not working:

  angular.module('angularmemberships').config(function($routeProvider) {
  $routeProvider.when('/memberships', {
    controller: 'AngularmembershipsMembershipsCtrl',
    templateUrl: '~/angularmemberships/MembershipsCtrl.html',

    resolve: {
      memberships: function(crmApi) {
        return crmApi('Membership', 'get', {
          sequential: true,
          rowCount: 100,
          start_date: ['2016-01-01', '2016-06-01'],
          sort: 'start_date DESC',
        });
      },
    }
  });
}
);

If I specify single date (start_date: '2016-01-01') it works (returns rows fot that date), but how do I get rows for a date range?


texts: Using smarty variables in contribution receipts sent with CiviRules

texts:
Because I want to send a receipt to our monthly donors when they signup (pre-notification) before it runs on the 1st of the month, I need to use CiviRules. The contribution is pending so Civi by default will not send until it the payment occurs. I'll use this to prevent them from getting it later https://github.com/fuzionnz/nz.co.fuzion.norecurreceipt.
Unless there are other routes?
I copied the system template Contributions - Receipt (on-line) and made a new user driven template. I added that as the template to use in my CiviRule but the contribution tokens do not work, except for the {contact.display_name} token.
I'm new to customizing message templates so I need some orientation on smarty variables vs. tokens. Do I need to turn smarty on for this? I did buthttps://civicrm.stackexchange.com/questions/33789/smarty-with-civirules#comment38676_33790


texts: Cron is not working after upgrading to latest version CiviCRM (4.7.29) and Joomla (3.8.4)

texts:
Recently upgraded to CiviCRM to latest (4.7.29) and Joomla (3.8.4.) installation to the latest version. After the upgrade cron is stopped working.

Getting below error while running cron using URL


texts: When new members sign up an email gets sent to filter.select@gmail.com

texts:
We are using CiviCRM 4.6.4 in Wordpress.
We have a membership page processed through paypal.
All emails are sending from our own SMTP server.

However, when an email is sent as acknowledgement of signup/payment
for membership, there is also an email being sent to filter.select@gmail.com

What is this email and how do I stop it from being sent?


texts:
I'm currently setting up the CIVICRM platform, now at the stage of importing data I am  unable to create new contact fields, I followed the instructions available to create custom fields however none of the created custom fields is visible when mapping the data for import.
Please assist as soon as possible.
Edit: here are some screenshots:

@fuzion, I yes the fields are set to searchable, on contact report I can also see the created custom field, but not in the import page.
@Aidan, Please expand more I do not completely understand you.


texts: Network Error due to Cross-Origin Request Blocked

texts:
All,

This post https://forum.civicrm.org/index.php?topic=34829.0 describes the problem I just experienced. I was able to work around the issue by deleting www from the address in the address bar. Obviously, this is not a solution.

What is the proper way to solve this problem?


texts: Missing input parameters error on opt-out form

texts: Our site is producing fatal "Missing input parameters" errors from the mailing opt-out form.  This happens several times every day at random times. I have looked at a few other SE posts with similar errors, but those issues seem unrelated. The log output is lengthy so I dumped it here.  If anyone could decipher it and let me know how to debug this, I'd appreciate it.  Thanks.


texts: PayPal receipts showing as Pending (Incomplete Transaction)

texts:
I have an issue with PayPal receipts.  They are appearing as "Pending (Incomplete Transaction)".

I have discovered that there was a fix to the file BaseIPN.php in CiviCRM 4.3, but looking at the modified 4.3 file and my version (4.7), they appear totally different.

The receipt is successfully received in PayPal and the user is taken to the "Thank you" screen, with no errors, however the transaction in Contribution Dashboard is showing as Pending.

Is this a similar problem as was reported in version 4.3?  If so, what would I need to change in the 4.7 version of BaseIPN?

Joomla 3.4.8 / CiviCRM 4.7.1 / PHP 5.6 (FastCGI)

PayPal IPN History reports the following:

Message ID 0T926689FX401850L
Date/time created 11/02/2016 16:14 GMT
Original/Resent Original
Latest delivery attempt date/time 11/02/2016 16:14 GMT
HTTP response code 200

These are the only errors I can see in the log with debug switched on for the same time period.  They may be related, or may not...

Feb 11 10:12:36  [info] $GET = Array
(
)

Feb 11 10:12:36  [info] $POST = Array
(
)

Feb 11 10:12:36  [info] Could not find an entry for txn_type in POST

Feb 11 10:12:36  [info] $error data = Array
(
    [error_code] => 0
)

Feb 11 10:12:36  [info] $REQUEST = Array
(
)

Thank you.


texts: Can you tell me how many people can log in at the same time with one user name?  We are setting up video training in which multiple users will need to log in.


texts: How to target a specific event type in a system workflow message

texts:
We'd like to separate the receipt for signing up for events by the event type - an email for one specific type and another one for all the other events. However, I haven't figured out how to specifically target it yet.

Right now we have something that looks like this:

{if $event.confirm_email_text AND (not $isOnWaitlist AND not $isRequireApproval)}

     some text...

{else}

     some more text

     {$event.confirm_email_text|htmlize}

{/if}

Thanks!


texts: Problem with Aggregating Households Extension after upgrade to 5.3.1

texts:
I had this problem after another upgrade and can't figure out how I solved it! (Posted as an issue at github as well.)

Extension installed, Enabled | ver 1.2 and at /home/MYSITEDIR/public_html/sites/all/civiextensions/me.twomice.civicrm.aggregatehouseholdcontributions

All existing reports error out with:

Fatal error: require_once(): Failed opening required 'CRM/Aggregatehouseholdcontributions/Report/Form/Contribute/AggregatedHouseholds.php' (include_path='/home/MYSITEDIR/public_html/sites/all/civiextensions/com.iatspayments.civicrm/:/home/MYSITEDIR/public_html/sites/all/civiextensions/de.systopia.householdmerge-1.1.beta/:/home/MYSITEDIR/public_html/sites/all/civiextensions/com.pogstone.fancytokens/:/home/MYSITEDIR/public_html/sites/all/civiextensions/nz.co.fuzion.cssinline/:.:/home/MYSITEDIR/public_html/sites/all/modules/civicrm:/home/MYSITEDIR/public_html/sites/all/modules/civicrm/packages:.:/home/MYSITEDIR/public_html/sites/all/modules/civicrm:/home/MYSITEDIR/public_html/sites/all/modules/civicrm/packages:/home/MYSITEDIR/public_html/sites/all/modules/civicrm/vendor/tecnickcom:/home/MYSITEDIR/public_html/sites/all/modules/civicrm/vendor/phpseclib/phpseclib/phpseclib:/home/MYSITEDIR/public_html/sites/all/modules/civicrm/vendor/pear/pear_exception:/home/MYSITEDIR/public_html/ in /home/MYSITEDIR/public_html/sites/all/modules/civicrm/CRM/Core/Controller.php on line 451

A file by that name is at:
/home/MYSITEDIR/public_html/sites/default/files/civicrm/custom/customphp/CRM/Report/Form/Contribute/AggregatedHouseholds.php

Copying it to:
/home/MYSITEDIR/public_html/sites/default/files/civicrm/custom/customphp/CRM/Aggregatehouseholdcontributions/Report/Form/Contribute/AggregatedHouseholds.php
does NOT fix it.

The code referenced is
require_once str_replace('', DIRECTORY_SEPARATOR, $className) . '.php';
in the snippet below

$ext = CRM_Extension_System::singleton()->getMapper();
      if ($ext->isExtensionClass($className)) {
        require_once $ext->classToPath($className);
      }
      else {
               require_once str_replace('_', DIRECTORY_SEPARATOR, $className) . '.php';
      }


texts:
Using Drupal, Civi 7.30, Mosaico 2.0 Beta 3

Whenever we center align text - its shows up as such in Mosaico, but then will left align in html preview and when actually sending email. Also shows up in source as correctly aligned in mosaico, but not when sent.

Any idea why this is?

Issue on GitHub


texts: How do I use custom fields in Drupal views?

texts:
[EDIT] Totally editing this question. Custom fields do not work in my Drupal views, at all:

The interface to add the custom field worked just fine. It's only the generated sql thats wrong. Its refering to civicrm_contact.custom_3, but the value is actually stored in a related table called civicrm_value_[PRIVATE_PARTS_HIDDEN]_1.

What could be causing this ? I need a solution pretty urgent :-|

PS. I did map the values in settings.php, and this in general seems to work. One of the entries is 'civicrm_value_[PRIVATE_PARTS_HIDDEN]_1'  => '[MY_CIVIDB_NAME_HERE].',

PPS. The checkbox used to add the field to the list, in the html source, reads

<input type="checkbox" id="edit-name-civicrm-contactcustom-3"
name="name[civicrm_contact.custom_3]"
value="civicrm_contact.custom_3"
class="form-checkbox viewsImplicitFormSubmission-processed">


texts: What's the cause of this "Unexected token" JavaScript error?

texts:
Just did a fresh install of CiviCRM 4.6.5 on Drupal 7.38 and the JQuery/Ajax isn't working. I get the following 2 errors in the Chrome Developer Console:

Uncaught SyntaxError: Unexpected token <  en_US?r=7WtZJ:1
Uncaught SyntaxError: Unexpected token <  XrTF2AAu:1

I have gone through the "Troubleshooting popups, autocompletes, or other javascript problems" document and have verified everything and cleared my Drupal cache.


texts: Enabling extensions - directory not found

texts:
I am attempting to enable extensions on civiCRM 4.6.8 via WordPress 4.3.

When I go to administer - system settings - manage extensions I am told I need to set my Extensions Directory. I do so via my file manager at public_html/iowafarmersunion/wp-content/plugins/files/civicrm/custom_ext, paste this file location into Civi, but them an told that the CiviCRM extension directory does not exist.

Am I skipping a step? I was following directly on this page: http://wiki.civicrm.org/confluence/display/CRMDOC/Extensions#Extensions-WordPress

Thank you!

edit:
I have made sure the directory's permissions are set to 777 for the time being and still no dice.


texts:
My scenario is quite simple to explain :

When a person register on an event (paid or free), we would like to give him an direct access to private content (by email or by direct redirect) (like documents to download or links ..).

how do you achieve something like that in WP ?

Actually i'm thinking of using CIVI custom field in events, then checking in the single event template for the "participant" status.. OR do you think there's another smarter way ?


texts: Enable use of do_shortcode when using CiviCRM and WordPress templates

texts:
I am trying to add a simple CiviCRM profile shortcode to a template of my theme, but the required CiviCRM files are not being loaded in the wp_head and therefore the shortcode does not render the profile form.

I have traced the issue to CiviCRM only loading these files if the shortcodes are being added to the content of the page or post.

This means that not only does the do_shortcode function not render CiviCRM shortcodes, but also any ACF (Advanced Custom Fields) fields created cannot render the shortcode either.

The php function that handles all of this, is the 'prerender' function in the CiviCRM_For_WordPress_Shortcodes class of civicrm.shortcodes.php.

The shortcode I'm trying to add is as follows...

do_shortcode('[civicrm component="profile" gid="14" mode="create" hijack="0"]')

Does anyone know if this behaviour can be modified, so that the files are enqueued on all WP pages?

Thanks for any help!

Matt


texts: Can I safely trim civicrm_job_log and civicrm_log?

texts:
civicrm_job_log is the biggest table in my database by an order of magnitude. And civicrm_log is the fifth biggest.

Can I trim these somehow, e.g. a cron job that removes old logs? It's making the backups slow.

EDIT: Here's an extension that keeps the job log from bloating

Thanks to the input here, I've created the Log Lop extension that allows users to configure a maximum age for keeping job logs. Will submit to the extensions directory after a bit more testing/few more eyes have looked at it.


texts: Getting a DB Error: unknown error when entering and saving phone number

texts:
I see that there's a few threads out there around this topic. I've just installed a brand new instance of WordPress 4.4 with CiviCRM 4.6.10. I've got three other installs of CiviCRM with Drupal on this same host, so, I can't imagine that it's a problem with the host.

Here's a portion of the log:

Dec 14 21:53:32  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_numeric' [nativecode=1548 ** Cannot load from mysql.proc. The table is probably corrupted]
[type] => DB_Error
[user_info] => SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_numeric' [nativecode=1548 ** Cannot load from mysql.proc. The table is probably corrupted]
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_numeric' [nativecode=1548 ** Cannot load from mysql.proc. The table is probably corrupted]"]

)

Database is 5.5.47-MariaDB. The user account has "ALL PRIVILEGES".

Any thoughts? Any help is greatly appreciated!


texts: How can I expose owners and managers in CiviVolunteer?

texts:
We have implemented CiviVolunteer to manage our 30 projects across 118 volunteers.

The positives:

Projects are linked via Activities in sympathy with the overall CiviCRM design philosophy.
Once two bug fixes were applied, it now works as specified - all good.

The negatives:

The Volunteer subclass of Individual has popped up but is not used by
CiviVolunteer for the actual volunteers. This is a bit confusing and
instructions in our User Guide (thank you Echo Plugins for Knowledge
Base for Documents and FAQs) are the way that we have dealt with
this.
The Volunteer reports don't expose the two relationships (Owner
or Manager).
The overall reporting system of CiviCRM doesn't appear to
support (out of the box) summarisation of rows (e.g. a count of rows,
a sum of values from a row, etc.).

Sounds like a lot of negatives, but we are using CiviVolunteer and are achieving a deal of acceptance from our users.

As requested in the guidelines, that's our story.

Now the question, how can I gain access to the two relationships (Owner and Manager) so that I can show the name of the owner and the manager on volunteer reports?

Regards,

Rob.

CiviCRM 5.4.1
PHP 7.1.24
CiviVolunteer 4.7.31-2.3.1
WordPress 4.9.8


texts: Search 'Hangs' While Trying to Assign Transactions to a Batch

texts: I created a Smart Group of members whose memberships are expiring in a particular month.  I then created a new accounting batch.  When I open the batch by clicking 'Transactions,' I get a list of all 2,000 plus members.  Then I tried to revise my search by selecting the Smart Group in the search screen.  When I click search, I get a small box in the middle of the screen that says 'Processing...'  However, nothing happens. It appears that CiviCRM is hanging. I can find no reference to anything similar happening in any of the CiviCRM sites.


texts: How to implement nested repeating fields?

texts:
Please could I have some suggestions on how to meet this requirement:

I need to be able to add a support plan to a contact. The support plan has an indeterminate number of goals. Each goal has a type, a description and also an indeterminate number of objectives, each of which has a type, a description and some dates. The whole support plan must be visible on the screen at one time, not just while viewing but also while editing.

Civicase (mapping cases to goals) was my original thought but it does not fulfil the requirement of having it all on one screen. EDIT Also, I am not sure how I would record this data in CiviCase because a goal has to have an indeterminate number of objectives and it is not possible to create a repeating set of custom fields against a case. /EDIT

Custom fields, as they stand, do not provide what we need because although you can have repeating sets of fields, you cannot have repeating sets of fields within them.

I am an experienced PHP coder and Drupal dev so taking a custom-code approach is within reach, however the project does not have a huge timescale so I would like to keep it to a minimum or avoid if at all possible.

Here's what I've thought of so far:

Submit a pull request to core, allowing for nested sets of custom fields (I think this would take a long time, both the coding and the administrative process).
Use a Drupal page, so that I can utilise field collections. The problem with this though is that we would not be able to use CiviCRM reporting tools to report on the data. There would also be questions about how to link the drupal page to the contact (logically and visually).

Any ideas? Thanks!


texts:
When using Drupal 7.x and CiviCRM 4.6 we notice that the Checkout page does not autofill profile information for a logged in CiviCRM user. They must manually enter in their details, then face this bug: CiviEvents with Shopping Cart - two email fields showing, and finally update their credit card payment information.

How can we solve this?


texts: 4.7.14 Wordpress 4.7 problem with contribution form Birth Date

texts:
CiviCRM version: 4.7.14
previous version: 4.7.12
Wordpress version: 4.7

My contribution form experience problem at the "Confirm contribution" page.
Upon pressing Confirm Contribution, user is brought back to the "Confirm Contribution" page with error "Please confirm birth date"
The error does not make sense as a birthdate is already in place.
And multiple tries of replacing birthdate with a different value did not help

A forced downgrading to CiviCRM 4.7.12 resolved the issue - a contribution can now go through.

Please advise! :)


texts: Do sites without SSL now need one for PayPal IPN?

texts:
PayPal is upgrading their certificate and require that people's certificates are also upgraded. Copying the notice below.

But IPN can currently be used without a certificate. Does anyone know if that will not be allowed in future? Or if the older certificates will not work but non-ssl connections will continue to work?

I know it's advisable to have SSL... But some sites want to avoid having SSL and that's why they use PayPal, to avoid asking for credit card information on their site.

PayPal email:

  As we have previously communicated to you, PayPal is upgrading the certificate for www.paypal.com to SHA-256. This endpoint is also used by merchants using the Instant Payment Notification (IPN) product.

  This upgrade is scheduled for 9/30/2015; however, we may need to change this date on short notice to you to align to the industry security standard.

  You’re receiving this notification because you’ve been identified as a merchant who has used IPN endpoints within the past year. If you have not made the necessary changes, we urge you to do so right away to avoid a disruption of your service!

https://www.paypal-community.com/t5/About-Business/PayPal-Endpoint-certificate-upgrade-SHA-256-encryption/m-p/997455#U997455

  Merchants using PayPal Instant Payment Notifications (IPN) may be impacted by the change if their web server is not enabled for SHA-256 compliance. If you are using a 3rd party solution for order management and for integrating PayPal on your website, you may be using IPN.  Please check with your shopping cart provider to see if you are affected.

and

  If you are a merchant who uses IPN with PayPal, your server will need to be upgraded to support SHA-256.  Please contact your web host or the checkout partner providing the integration solution to ensure SHA-256 is enabled for the server.


texts: Recurring contributions with Webform-CiviCRM?

texts: Does Webform-CiviCRM support recurring contributions for donations or memberships?


texts: Setting up rule to link CiviCRM contact with Drupal 7 account

texts:
I’m using civicrm 4.7.14 with drupal 7.53.

I have a question about these directions:
https://wiki.civicrm.org/confluence/display/CRMDOC/Creating+a+Drupal+user+for+every+CiviCRM+contact

When I create the rule, I don't see these options listed as a condition or action:

  CONDITION

  NOT Drupal User Account exists for Contact

  ACTION

  Create Linked Drupal User Account

What am I missing?

Also, what exactly happens here? I understand that new Drupal accounts will be made for the CiviCRM contacts, but will it generate usernames? Will it email everyone on the list automatically? (I don't want to send emails yet.)


texts:
After upgrading to civi 4.4.19 Civi doesn't recognize built in tokens. The upgrade was smooth with no errors reported.

Symptoms are as follows:

(1) If {domain.address} and {action.optOutUrl} are in the body of the email, civi reports that they are required when I try to move to the preview page.  If instead they are in the footer I can move on to the next step and these appear to substitute correctly.

(2) Simple tokens, for example {contact.first_name} are not evaluated in the preview, and if you move from the compose page to the preview page and back, the token is stripped from the text.

(3) Drupal error log says "User error: in Smarty->trigger_error() (line 1094 of [mysite]/sites/all/modules/civicrm/packages/Smarty/Smarty.class.php)."

Googling that suggests that it's a problem with smarty not being able to find application tokens.

Things I've tried:
I have confirmed that  /sites/all/modules/civicrm/packages/Smarty/plugins is there

I have cleared caches with (1) drupal clear all caches and (2) /index.php?q=civicrm/menu/rebuild&reset=1 and (3) rm -rf en_US in templates directory an (4) [mysite]/civicrm/admin/setting/updateConfigBackend?reset=1

What else can I do to try to debug this?


texts: How can I identify the hard contributions/contributors that lead to a soft credit?

texts:
I have just upgraded from 4.4 to 4.7.19 and can't seem to identify a certain group of contacts now that the "In honour of" functionality has been subsumed into Soft credits.

When admin processes a membership, if the box "Record Payment from a Different Contact?" is ticked you can record that the payment for the membership was made by someone other than the member and send the receipt to the "other" rather than the member.

This results in the actual contribution being recorded against the "other" contact and a soft credit being recorded for the member.

I need to create a smart group of all the "paid for someone else" contacts for a certain soft credit type.

In Advanced Search with results displayed as contacts, when defining contribution search criteria the options for the Contributions OR Soft Credits? field are:

Contributions only
Soft credits only
Soft credits with related Hard credit
Both

(With the last three options a box that lets you specify soft credit type appears.)

Based on the names of the options, my plan was to create groups of contacts from  "Soft credits only" and "Soft credits with related Hard credit** searches and use the include/exclude custom search to create the "related hard credit contacts" group.  But it doesn't work.

I would have thought Soft credits with related Hard credit should have given me a list of both the contacts getting a soft credit and the contacts who made the contributions that lead to the soft credits. However the results for Soft credits with related Hard credit are the same as the results for Soft credits only AND the results for Both are also the same.

This is true whether I am displaying results as contacts or as contributions.

So, I am not sure how the last three options differ from each other and I am no closer to being able to identify those people/organisations who paid for someone else's membership.

I did look at Search Builder also, but it does not seem to recognize any of the soft credit fields.

Does anyone have any suggestions?


texts: Smart groups break when database is restored

texts:
When we clone our production instance to staging, we restore the database with updated host information prior to restoring the database.

Querying a smart group returns all contacts in database, not just those in the smart group. Running the Rebuild Smart Group Cache scheduled job does not do anything.

Here Eileen says How do the Rebuild Smart Group Cache scheduled job and the Smart group cache timeout setting interact?

  Note I DO recommend running the job that flushes expired groups by
  scheduled job - just not the one that rebuild them all, even the ones
  you don't really need

Where is that job?


texts: How to create a Drupal menu link to a civicrm contact profile

texts: I would like to create a drupal menu link for a logged in user. I have added civicrm/contact/view, which seems to only work when the contact profile was viewed once.  Otherwise keep getting message We could not find a contact id. Can anyone have a quick solution please?


texts: Change CiviCRM Event notification emails

texts: When participants register for events/trainings, notifications are sent automatically to a pre-specified email. How can I change so the notifications come to different email addresses? Newbie using CiviCRM 4.6


texts: Discounts with Webform_CiviCRM and Event Registration

texts:
On Drupal 7.x and CiviCRM 4.6 and using latest CiviDiscount, is it possible to offer member discounts on a webform?

Specifically, we are offering 5 Webinars (all CiviEvents), which are included in our Webform as components. We notice that when we make a CiviDiscount with an automatic member discount, it does not apply to our webform submission.

Is there an alternative way to enable this functionality? I've thought about having Member pricing be another select option and using jQuery to check the users role, but that is more effort to maintain. Any thoughts?

The ultimate goal is to have 1 form where people can sign up for many events at once, and come back and sign up for other ones later, with one payment. We looked at CiviEvent Shopping Cart but it has some significant design flaws currently.


texts:
I created several custom fields & groups but I am not seeing all of them when I try to import my contacts.

Like I have a few custom sets/groups and custom fields within each. But only one set is showing when I import my contacts & try to match them up to the fields. I have checked the settings, and everything is the same. Any ideas?

Update: I found the "import multi-value custom data" part of the import contacts ... almost impossible for anyone to find without spending too much time looking through this forum.

HOWEVER when I import it does its normal "column names", "import data (row 1)", "import data (row 2)" thing.... problem is, its putting half of my row 1 in row 2 and not importing all of row one. If that makes sense? In fact not all the column names are in there either. And YES I did check the CSV before uploading & after the error. There is nothing wrong with it. When I imported that same doc for the main import contacts screen it worked fine.

Any ideas? Thanks in advanced!

Update: I decided to upload the multi-value's in smaller chunks to match the specific custom data field that I created. The custom data is broken down into one custom field with a bunch of options in the checkbox setting. When I go to upload the content pertaining to just that, I will go through everything and just set it to the base custom field (since I cannot choose the options). When I do that it processes & then throws out a "DB Error: constraint violation" .

Any ideas, anyone?


texts: constituent detail report not working (timeout)

texts:
I am using CiviCRM 4.5.8, an instance with 18,328 contacts.

No matter how long I set the max execution time of a page, I am getting a timeout when trying to view the constituent detail report (instance 2). The other reports all work fine.

Has anyone ever experienced this? Can anyone think of a reason this might be happening? The PHP error logs are showing nothing but a timeout, and the CiviCRM log is showing nothing.

Update: It seems to be related to Activities. If I create a new report based on constituent detail, and uncheck all the activity columns from being used, then the report is produced ok. If I check one column to do with activities again, then it stops working and times out.


texts:
Wordpress 4.5
CiviCRM 4.7.6

I have installed the CiviCRM 4.7.6 plugin and get a message that I need to upgrade the database. When I try the upgrade, get a white screen displayed with the single word "error" in the upper left. Then I cannot access any Wordpress functions and have to reload the datbase again.


texts:
I want to install extensions which are not listed in the "Add Neww" directory, such as :

de.systopia.osm-1.2
net.ourpowerbase.exportpermission-master

I copied those (from their Git source) to my Site Extension directory, but they don't appear in my Extensions list, so, I cant activate them.

How can I activate them ?


texts: Image not displayed in the email with outlook

texts:
I have created a new mailing with an image(logo) in the text.
Contacts which use outlook to open the email doesn't see the image.

The problem is the same if the image is in the template or added in the mailing.

To avoid this issue, if I go in the source of the mail and remove  tag,   the image is displayed in outlook.

Do you have an idea how-to definitively resolve this issue?
Regards,


texts: Is there any way to search for contacts with special characters using other characters in the CiviCRM search?

texts:
E.g. ss = ß, ae = ä, ue = ü, oe = ö
Our language is German but English-speaking colleagues should be able to search for German contacts without having to copy a character from the character table. In addition, as native speakers, we sometimes don't know whether a surname is spelled with ß or ss. We then always have to look for both variants.
Is there a solution for this?


texts: How to provide custom token for subscription related automated messages?

texts:
I'm trying to privide a token for mailing related automated messages. I followed the instructions about hook_civicrm_tokens and hook_civicrm_tokenValues but it does only work for "CiviMail" mails. In mails for group subscriptions (at least "Subscribe Message", "Resubscribe Message", "Unsubscribe Message" and "Welcome Message") the custom token will not be replaced.
function mysite_civicrm_tokens(&$tokens){
  // Define tokens for date (like today's year)
  $tokens['date'] = [
    'date.year' => ts("Today's Date: year")
  ];
}

 function mysite_civicrm_tokenValues(&$values, $cids, $job = null, $tokens = [], $context = null) {
  // Set tokens values for date
  if(isset($tokens['date'])) {
    // TODO: Check if token is required.
    foreach ($cids as $cid) {
      $values[$cid]['date.year'] = date("Y");
    }
  }
}

The custom token defined in mysite_civicrm_tokens is not availible in mysite_civicrm_tokenValues although I have placed it inside the mailing components under civicrm/admin/component.
I know that those mails are handled different from CiviMail mails so I guess there might be another way to solve this.


texts: word replacement with accent "Événement" by "Missions et PAD" not working but word replacement is OK

texts:
I try to replace the Menu Title "Événement" by "Missions et PAD". But it is not working.
I tried different word replacements and they are working well. Is it due to the accents ? to a bad coding ?
I am using CiviCRM for wordpress.


texts: CiviReport - Can Report Titles be sorted?

texts: I've created about 20 reports under Event Reports but Civi seems to sort the report titles in order of creation. Is there way to have the report titles sorted alphabetically?


texts:
I've looked at several previous posts, but it's not clear to me if they relate to the issue I'm experiencing. Just updated to CiviCRM 5.8.1 on Joomla 3.9.1. Currently the HTML editor is missing on mailings and events, it's just a box with the straight HTML. The error console is giving the error id.split is not a function from the angular.js file.

Also missing is the Configure CKEditor button. When I check the demo, I see it there, but it never shows up on our site when CKEditor is selected. I also tried installing and selecting the TinyMCE plugin as the editor, but again that makes no difference in the edit window. I'm getting this error in the Display Preferences page: Empty string passed to getElementById().

I've cleaned the caches and checked that the Resource URLs are correct. Unsure what to troubleshoot next.


texts: create an Drupal core account when using a webform

texts:
I would like to create a Drupal user account when a user becomes a member via a webform. Ideally a user would get redirected from the webform to a profile, but I do not think this is possible?

I have come across this article, which was written over 5 years ago, is it still valid? https://civicrm.org/blog/petednz/creating-drupal-users-made-easy-for-single-or-multiple-contacts-via-civi-imports-and

It seems like it would work, but for ease would this workflow be suitable?

User applies for account via a profile/Drupal core registration form (Payment pending group/role gets assigned)
Edit some template files so the site checks for current role assigned to a user and displays a message informing they have finalise the membership process and pay if they have the Payment pending role.
User is directed to a webform and pays.
User is removed from Payment pending and Added as a full member

I'm sure both solutions would work. It would be great to hear from other people who have more experience with Civi.

Cheers


texts: Problem exporting due to multiple addresses of one location type (e.g. two 'home' addresses)

texts:
I have run into a problem where someone created a Webform using Webform_CiviCRM and for some reason added two address field sets to the contact, with the street address in one of them and the city/state/zip in the other. Now the contacts in CiviCRM have two incomplete addresses, both of the type 'Home'. When I try to export them, I'm just getting one of the incomplete addresses.

This old forum thread seems to be related. It looks like the UI on the main contact page prevents creation of multiple addresses of the same type, but the API must still not enforce?

Anyone have a suggestion for how to tackle this and get the addresses merged/squashed into a single address?


texts:
We just launched a new Drupal website and implemented our old CiviCRM database. Everything seems to be going fine and transactions are going through, but when we try to view one, as admin or any other user, we get a network error.

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

Admin user has all permissions and is still having the issue.

CiviCRM 4.7.15, Drupal 7.x

Edit: apparently I can't go back and edit payment processors either.

Edit2: apparently it works with the old, pre-launch URL. I ran 'drush cc civicrm' to no avail. I also updated file paths and cleared caches in CRM.

It's possibly related to an issue where some transactions are coming in incomplete.

Drupal error log is showing this possibly related message:

Sep 19 16:27:28 prod drupal: https://prod.fosterclub.com|1505838448||access denied||68.116.xx.xx|https://prod.fosterclub.com/civicrm/contact/view/contribution?reset=1&id=5816&cid=121483&action=view&context=dashboard&selectedChild=contribute&snippet=json|https://www.fosterclub.com/civicrm/contribute?reset=1|0||civicrm/contact/view/contribution

Furthermore, when I hover over the link to view the transactions, it is showing prod.example.com instead of www.example.com, which was the correct URL before the DNS change and launch.


texts: Change the root directory D8 [docroot > web]

texts:
I encounter lot of issues with CiviCRM on a Drupal 8 production site :

When sending a mailing there is :
- No tracking of opened mail
- No indication of click through
There is another issue with the cron that doesn't run.

The issue might concern the root directory D8 that is the non standard docroot instead of the web directory.
This can be a direction for this issue as the installation roundearth of David Snopek's. It is based (or used to be) on the web directory

What is the best practice to move the root directory ?


texts:
I recently moved our site to the Pantheon platform. The domain is the same (except the 'www' is now default where previously non-www was the default).

But we have just received this email from Paypal:

  Dear so-and-so,

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

  http://www.mysite.com/sites/all/modules/civicrm/extern/ipn.php?r
  eset=1&contactID=1495&contributionID=1047&module=contribute&membershipID=627

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

  Thank you for your prompt attention to this issue.

I tried accessing the address and got there without any trouble. Why might this be happening and how could it be fixed?


texts: Subscribe to group via a webform - pass in group Id

texts:
I'm using Drupal, CiviCRM, CiviCRM Entity and Webform CiviCRM.

My hope is to link an "activity" (described on a Drupal node) to a group ("Sign up for news about this activity").

So the Group Id would be stored in a field on the Drupal node, and when I click "Sign up" I'm taken to a form where I can sign up to that group.

Is there a way of doing that with Webform CiviCRM?

I've tried setting "Enable Tags and Groups Fields" to "Yes" but I can't see how to pass in the Group Id.

Cheers!


texts: SMS breaks when upgrading to version 2 of extension & 4.6.2 of CIVICRM

texts:
SMS API version 1.2 & Clickatell version 2 extensions were added.  Clickatell was set as an SMS Provider.  Clickatell was working with version 1 of the extension and 4.5.8 of civicrm.

When sending the sms, there is no indication of a failure, it just never gets sent.

Log file output - 2015-06-16 21:30:02   Send Scheduled SMS
Entity: Job Action: process_sms
Summary
Finished execution of Send Scheduled SMS with result: Success (a:0:{})
Details

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

Full message:
Finished execution of Send Scheduled SMS with result: Success (a:0:{})

LOG FILE-
Jun 16 22:45:02  [info] $INSERT INTO civicrm_job_log (domain_id , description ) VALUES ( 1 , 'Finishing scheduled jobs execution.' )  = #0 /home/depot/public_html/drupal/sites/all/modules/civicrm/CRM/Core/Error.php(608): CRM_Core_Error::backtrace("INSERT INTO civicrm_job_log (domain_id , description ) VALUES ( 1 , 'Finishin...", TRUE)
#1 /home/depot/public_html/drupal/sites/all/modules/civicrm/packages/DB/DataObject.php(2380): CRM_Core_Error::debug_query("INSERT INTO civicrm_job_log (domain_id , description ) VALUES ( 1 , 'Finishin...")
#2 /home/depot/public_html/drupal/sites/all/modules/civicrm/packages/DB/DataObject.php(1060): DB_DataObject->_query("INSERT INTO civicrm_job_log (domain_id , description ) VALUES ( 1 , 'Finishin...")
#3 /home/depot/public_html/drupal/sites/all/modules/civicrm/CRM/Core/DAO.php(450): DB_DataObject->insert()
#4 /home/depot/public_html/drupal/sites/all/modules/civicrm/CRM/Core/JobManager.php(237): CRM_Core_DAO->save()
#5 /home/depot/public_html/drupal/sites/all/modules/civicrm/CRM/Core/JobManager.php(87): CRM_Core_JobManager->logEntry("Finishing scheduled jobs execution.")
#6 /home/depot/public_html/drupal/sites/all/modules/civicrm/api/v3/Job.php(99): CRM_Core_JobManager->execute(FALSE)
#7 /home/depot/public_html/drupal/sites/all/modules/civicrm/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_job_execute((Array:2))
#8 /home/depot/public_html/drupal/sites/all/modules/civicrm/Civi/API/Kernel.php(96): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9))
#9 /home/depot/public_html/drupal/sites/all/modules/civicrm/api/api.php(23): Civi\API\Kernel->run("job", "execute", (Array:2), NULL)
#10 /home/depot/public_html/drupal/sites/all/modules/civicrm/drupal/drush/civicrm.drush.inc(1533): civicrm_api("job", "execute", (Array:2))
#11 [internal function](): drush_civicrm_api("job.execute", "auth=0")
#12 /usr/bin/drush-4.x/includes/command.inc(131): call_user_func_array("drush_civicrm_api", (Array:2))
#13 /usr/bin/drush-4.x/includes/command.inc(836): _drush_invoke_args("civicrm-api", (Array:2), "civicrm")
#14 [internal function](): drush_command("job.execute", "auth=0")
#15 /usr/bin/drush-4.x/includes/command.inc(236): call_user_func_array("drush_command", (Array:2))
#16 /usr/bin/drush-4.x/drush.php(101): drush_dispatch((Array:22))
#17 /usr/bin/drush-4.x/drush.php(41): drush_main()
#18 {main}


texts: Merge related activities and related groups options not available in merge contacts

texts:
We've recently upgraded a site to 4.6.10

When merging duplicate contacts the options to merge activities and groups (and tags and events etc) are missing.

I've tried merging a couple of dummy contacts. Contact data merges as expected, but associated group and activity data is deleted along with the duplicate contact not transferred to the remaining contact.

The demo work displays as expected. Are there any settings that control this activity that I've overlooked?

Has anybody experienced this issue before?

Any hints/tips/pointers as to where I can look?

Thanks

Craig


texts:
Every time I try to "add new event" I keep getting message ERR_CONNECTION_RESET from my google chrome and the webpage doesnt open.. What could be to cause?
I''m using wampserver x64, civicrm-5.3.1-wordpress, wordpress-4.9.6-pl_PL.


texts: How can I let members edit their relationships?

texts:
We have organizational memberships - each organization can have up to five individuals who are listed as members.  We do this via the membership "Relationship Type" feature, and it works well.

However, competing platforms have a dashboard that allows the contact person for an organization add/remove the individual members that should be part of the record.  How can this be implemented with CiviCRM?

Civi 4.7.31, Backdrop 1.9.2 - so Views/Webform/etc. are all options.  It's acceptable for a member administrator to search contact names in the database.  Writing custom code is an option if there's a simple-ish way to do this.


texts: Are there Realease Notes when a new Release is published?

texts:
There is a new Civi release about every fortnight (or even less) (currently 5.18.1).

Updating one's configuration at every release is painful and risky (you may have regressions) ; but it can also be very useful (bug fixes, ans enhancements).

So, it would be very useful to know what changes are brought by a new release.

... which is the usual purpose of Release Notes.

I could not find such assciated release notes. Are there any ? If yes, where can we find them ?


texts:
I have several recurring contributions for a CiviCRM 4.6.10 site.  These contributions were made through CiviCRM and into Authorize.net.  They worked multiple times in 2015 but none of the transactions have been recorded in CiviCRM in 2016. We have verified our record with Authorize.net and all of these transactions have been successful.

Thanks in advance.


texts: How can I display variables for templates other than the top/main one?

texts: The popup window enabled at civicrm/admin/setting/debug?reset=1 contains only the top level Smarty template variables. How can I see the variables for a lower level included Smarty template?


texts: Are there any dangers to editing a membership type directly in the database?

texts:
We have a membership type that is shared by relationship. However, after the membership type was created, we needed to share it by a new relationship type. I edited the membership type directly in the database to add the new relationship type (since the interface does not allow you to edit that after a membership is created). I simply added the new relationship_type_id and relationship_direction in the civicrm_membership_type table for the appropriate row.

It seems to have been working fine, but I am tracking down a bug now and wonder if this edit may be related. (The bug does not seem to happen on the demo site).

Here's the issue: when a relationship is disabled from the Organization or Individual's Relationship tab (ie. using the "more > Disable" command rather than editing the relationship, disabling, and saving) the membership which is shared by relationship is not disabled. When the relationship is rather edited by clicking Edit, unchecking Enabled, and saving, the membership disappears as expected. (In fact, if I do it the first way, then Edit and Save without changing anything, the membership disappears, too.)

UPDATE: I can actually reproduce this on the demo server with a non-Employee relationship so I think it may be a bug. I have submitted a bug ticket on JIRA.


texts: Call event registration with specific language through Wordpress

texts:
I am using the latest Wordpress with Polylang and CiviCRM versions. I try to call the online event registration form in both German and English, but I don't know how to do it.

How can I force CiviCRM to switch to a specific language?  The &lcMesssages=de_DE parameter has no effect at all, neither does &lang=de.

Inherit language from CMS also does not work - I cannot even see a pattern. When I call CiviCRM from the Dashboard, it's always the current language, just from Wordpress itself, it does not work at all.

But there must be a way to force CiviCRM to use a specific language - or not? Any help is appreciated.


texts: CiviCRM API and checking if a custom field is empty rather than not null

texts:
Is there a way to check if a custom field is empty using the API?

The check for 'IS Not Null' appears to work to an extent, but only if a custom field is not part of a set of custom fields, When one of the custom fields get given a value, the others change from Nulls to blanks.

e.g.
custom_1 = Null
custom_2 = Null
custom_3 = Null

set custom_1 = "some_string"
custom_2 = (becomes empty string)
custom_3 = (becomes empty string)

API is null check fails as they are no longer null..

API check for != '' doesn't work
API check for <> '' doesn't work
etc etc

Any thoughts or is this a bug?


texts: Running scheduled jobs from wp-cli doesn't work

texts:
Running scheduled jobs using wp-cli doesn't work, whereas CiviCRM's cli.php does work.

I'm running CiviCRM 4.6.8 on Wordpress.

When I try to execude scheduled jobs using wp-cli:

sudo -u www-data /usr/local/bin/wp --user=my_wp_login --url=https://www.mysite.pl --path=/home/www/wordpress civicrm api job.execute auth=0

I get the following result, although the mailings are not sent (remain in Scheduled state).

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

The same goes for running wp civicrm process-mail-queue

However, using old cli.php I can run the jobs.

usr/bin/php5 /home/www/wordpress/wp-content/plugins/civicrm/civicrm/bin/cli.php -s www.mysite.pl -u cron -p passord -e Job -a execute

What am I doing wrong?


texts: Export participants with Membership data

texts:
If I'm right it used to be possible to export participants as csv with Membership data.

But it is not there any more in 4.4 and 4.6.

Is there a way how that could be done nowadays?

We need participant info and the membership type in one export.

It is also possible that the participant has no membership.

The only solution I do see now is to create smart groups for all membership types and also a smart group for people without membership. Then go to advanced search, select 1 of these groups, select the right event, display results as participants and export the participant fields and repeat this for all the membership types and the no-member group. Then Add all these csv's to one excel with a column for the membership type.

This is cumbersome and misses one key wish: We also would like to export the membership end-date in this csv. Any solution for it?

Oh, it is a Wordpress site, otherwise I would have tried Views


texts:
Using CiviCRM API v3 Explorer, i can create case without any problem. I can see the new case on case dash board, but using the  php script, there are an error exception happen

  Fatal error: Uncaught CiviCRM_API3_Exception: [unknown error: DB
  Constraint Violation - case_type_id should possibly be marked as
  mandatory for Case,create API. If so, please raise a bug report.
  thrown in
   /idev/joom/administrator/components/com_civicrm/civicrm/api/api.php
  on line 45

Here is the snippet code

http://prntscr.com/n17bng

this is the output

http://prntscr.com/n17c6f

Changing code to

http://prntscr.com/n17cky

get this error

http://prntscr.com/n17cqv

Using the explorer code, all is running well

http://prntscr.com/n17d48

Anyone know why this happen ?

Thank you


texts:
I try  to add an event in CiviEvent (with Superadmin role ), but I can not.  After saving the  first form, when Civi tries to go to https://staroflife.pl/civicrm/event/manage/location?action=update&reset=1&id=46 it displays the following error:

 $backTrace =
 #0 /home/sol/domains/staroflife.pl/public_html/sites/all/modules/civicrm/CRM/Core/Error.php(378): CRM_Core_Error::backtrace("backTrace", TRUE)
 #1 /home/sol/domains/staroflife.pl/public_html/sites/all/modules/civicrm/CRM/Event/Form/ManageEvent.php(128): CRM_Core_Error::fatal("Nie masz      uprawnień dostępu do tej strony.")
 #2 /home/sol/domains/staroflife.pl/     public_html/sites/all/modules/civicrm/CRM/Event/Form/ManageEvent/Location.php(74):      CRM_Event_Form_ManageEvent->preProc     ess()
 #3 /home/sol/domains/staroflife.pl/     public     _html/sites/all/modules/civicrm/CRM/Core/Form.php(543): CRM_Event_Form_Manage     Event_Location->     preProcess()
 #4 /home/sol/     domains/staroflife.pl/public_html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(92): CRM_Core_Form->buildForm()
 #5 /home/sol/     domains/staroflife.pl/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203):      CRM_Core_Quic     kForm_Action_Display->perform(Object(CRM_Event_Form_ManageEvent_Location), "display")
 #6 /home/sol/     domains/staroflife.pl/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Pa     ge.php(103): HTML_Q     uickForm_Controller->     handle(Object     (CRM_Event_Form_ManageEvent_Location), "display")
 #7 /home/sol/     domains/staroflife.pl/public_html/sites/all/module     s/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("display")
 #8 /home/sol/     domains/staroflife.pl/public_html/sites/all/module     s/civicrm/CRM/Utils/Wrapper.php(113): CRM_Core_Controller->run()
 #9 /home/sol/     domains/staroflife.pl/public_html/sites/all/module     s/civicrm/CRM/Core/Invoke.php(283): CRM_Utils_Wrapper->     run("CRM_Even     t_Form_ManageEvent_Location", "Lokalizacja wydarze     nia", (Array:0))
 #10 /home/sol     /domains/staroflife.pl/public_html/sites/all/modul     es/civicrm/CRM/Co     re/Invoke.php(84): CRM_Core_Invoke::ru     nItem((Array:14))
 #11 /home/sol     /domains/staroflife.pl/public_html/sites/all/modul     es/civicrm/CRM/Co     re/Invoke.php(52): CRM_Core_Invoke::_i     nvoke((Array:4))
 #12 /home/sol     /domains/staroflife.pl/public_html/sites/all/modul     es/civicrm/drupal     /civicrm.module(448): CRM_Core_Invoke:     :invoke((Array:4))
 #13 /home/sol     /domains/staroflife.pl/public_html/includes/menu.i     nc(527): civicrm_invoke("event", "manage", "location")
 #14 /home/sol/domains/staroflife.pl/public_html/index.php(21): menu_execute_active_handler()
 #15 {main}

I see the event in the database after this error, but I cannot see it in the dashboard. Before this problem, I add two events without any trouble.

I tried the following: clean Drupal and CiviCRM cache, log in with another login, check ACL in CiviCRM. But it did not work :(

Civicrm version:4.7.19, Drupal: 7.51
"Nie masz      uprawnień dostępu do tej strony." means
You do not have permission to access this page. :)

EDIT: The problem occurs when the ID is higher or equal to 30.
I tried: recover old civicrm version (from backup after update) and i have this problem too.


texts: How do I force CiviMail to process all mail as an email activity?

texts:
I've setup CiviMail to process inbound mail as activities and assigns those emails to contacts.

My problem is CiviMail does not process ALL emails. The component set up an "ignored" and "processed" folder. Everything in the "ignored" folder does not show up in CiviCRM as an activity. Everything in the "processed" folder does show up as an activity and is assigned to a contact.

How do I force CiviMail to process ALL mail? Thank you in advance for your time.


texts: Page - specific Datepicker config in jcalendar.tpl

texts: How does one add a default value in one of Datepicker fields while adding or editing Relationship? For example, set today's date as a start date at Enabled checkbox check and as the end date if un-checked.  Should it be a custom piece of jQuery code or it's better to alter jcalendar.tpl? If latter, how one defines "Add/Edit Relationship" modal frame has been triggered and not, say, "Add/Edit Membership?" one.


texts: Drush error: "Command ... needs the following module(s) enabled to run: civicrm"

texts:
I am trying to use Drush to run a CiviCRM command (for example, civicrm-sql-dump and although CiviCRM is enabled and running fine, I get the following type of error:

> drush civicrm-sql-dump > ~/dumpfile.sql

Command civicrm-sql-dump needs the following module(s) enabled to run: civicrm.
The drush command 'civicrm-sql-dump' could not be executed.

What is causing the problem?


texts: Mosaico - how to 'insert' templates from a previous host?

texts:
I'm moving hosts, and want to preserve a number of Mosaico templates that I've created. Mosaico had to be re-installed. It is running, but the templates are now gone. I have backups of the SQL tables. Attempts to just 'insert the rows' into civicrm_mosaico_template table have been unsuccessful. (and broke the mosaico install). So, uninstalled/reinstalled - to a clean mosaico again...

Any suggestions on how to re-import those templates?

Thanks!


texts: Pre-header text for mosaico mailings shows twice

texts:
When using the Pre-header Text option in a Mosaico mailing like this:

The preheader text shows twice in gmail like this:

Is there a way to stop this happening?


texts: WYSIWYG editor not present with WordPress

texts:
I have CiviCRM 4.7.22 and WordPress 4.8.2. I don't get the WYSIWYG CKEditor for a New Mailing or the description in a new event. Both are present on the CiviCRM sandbox site.

From the documentation I think that it should be installed with WordPress and set as default. Permissions can't be an issue as I am an admin.

While WYSIWYG editor disappeared in CiviCRM 4.7.16 looks similar, the answers seem to relate to Drupal not WordPress and nothing suggested there helps.


texts: Is it possible to duplicate/copy a batch of contributions?

texts: We have a group of donors that make monthly contributions of equal value. Is it possible to duplicate or copy a previous month's batch and change the date as appropriate and post the new copied batch? This would save a lot of work in re-entering the contributions.


texts: How do I enable or disable Ajax Deduping?

texts:
A recent bug report mentions that it affects users only when Ajax deduping is enabled. How do I find this option to review it? Both Google and code grepping are failing me.

https://github.com/civicrm/civicrm-core/pull/12550


texts: Personal Campaign Pages (pcp) related to a campaign

texts:
We're trying to create a peer-peer funding application so people can support an individual "Cause".  CiviCrm allows a PCP to associate with a contribution page (or event) but I think associating with a Campaign makes more sense.

Currently, do we need a separate contribution page for each Cause we want to fund?  All the donation pages are the same with just the title, dates, status and goal changing.  If we have 100 causes this means we have to maintain 100 pages and update them all if we want to change something.  Also, I can't see in the API how to setup/configure the PCP/Widget so that would need to be done manually or via extension.

Has anyone tried to associate the PCP with a "Campaign" so it is not necessary to create a separate contribution page for each entity we want to fund?

Campaigns seem to be a better fit for PCP - you could simply create a contribution (without a contribution page) and associate it with a Campaign.

Ideally you could pass a campaign id to a contribution page and manage a "generic" donation page that would dynamically associate with a campaign.

I understand that Webforms can do this some of this but there is a lot of great, built-in logic (tell-a-friend, create PCP, etc.) that is in the donation pipeline so it seems unfortunate to have to recreate it.


texts: How do I make tag sets searchable in Find Contacts?

texts:
I'm pretty new to civiCRM and it feels like I'm missing something obvious. The tags that are in tag sets don't show up in the Find Contacts search. They show up in Advanced Search just fine. Is this just how tag sets work or is there a way to make them show up in both search options?
I'm using Civi 4.6.10 in Wordpress.