texts: parse error in civicrm_handler_relationship_relationship.inc since upgrade to 4.6.11

texts:
Since upgrade the site is broken with the following message:

Parse error: syntax error, unexpected ';', expecting ')' in /home/ablaze/public_html/sites/all/modules/civicrm/drupal/modules/views/civicrm/civicrm_handler_relationship_relationship.inc on line 58

Line 58 looks as though it is properly closed and removing the semi-colon just introduces another error.

As an emergency repair I've dropped in the file from the last version and it is working again.

Differences in files:

Line 25

old:

$options = array(0 => 'Any');

new:

$options = array();

Line 53

new line inserted:

 '#multiple' => TRUE,

Murphey's law being what it is I've broken my develoipment environment so can't work out anything else for a while.


texts:
We have a client who wants to bill an Australian Member with Ireland HQ, therefore they need to provide an invoice without GST as head office is paying. Is there any way we can tick or untick GST when creating a payment? Thanks.

Drupal 7.59 CiviCRM 4.7.38.


texts:
We've had social media sharing for our events ("Allow sharing through social media?") enabled "forever".

Now it only shows the twitter birdie. Inspecting the page reveals that there is some code there for each of G+, Facebook and LinkedIN, but nothing shows.

We are running CiviCRM 5.13.4 on Joomla 3.9.6.

I can't find any indication that it should be configurable somewhere either.

How do I get my Social Media Sharing Icons/Links back?


texts: Move all accounts with certain Drupal role into CIviCRM group

texts:
We are trying to delete all spam accounts out of both Drupal and CiviCRM.  We have a module set up to find all spam account in Drupal and set them to the role of "spam account".  There are now about 40,000 accounts with that role.

Now, we are trying to deal with those accounts on the Civi side.  I am trying to use CiviCRM Group ROles Sync to sync all of the Drupal accounts with the role of spam to the CiviCRM group of Spam, but keep getting a "503 First byte timeout" error.  I was told that the error is caused by it taking longer than 60 seconds to respond, which would make sense considering there are 40,000 accounts.  But, I tried it with 20 accounts, and still got that error.

Is there another way to go about syncing the Drupal and Civi roles/groups, or another way to deal with spam accounts in CiviCRM?

I am using Drupal 7 and CiviCRM 4.6.28.


texts: What is the correct REST URL in Drupal 8?

texts: I know there's been a lot of work to deprecate the extern endpoints in CiviCRM, and the extern endpoints don't work in Drupal 8 without a lot of finagling.  The documentation isn't updated to reflect a new way of using D8 REST endpoints, nor is API Explorer.  Does anyone know what the "correct" endpoint is?


texts: Case Activity does't respect 'Do not notify assignees for'?

texts: When submitting activity from case, assignee contact still gets email even though the activity type is included in 'Do not notify assignees for' setting under Display Preference. However it obeys the setting when sent from Activity form. Is this intentional?


texts: Civimail produces saving error when sending test

texts:
CiviCRM 4.6.8

I was editing an email when the "Send test" button triggered the message...

Error: Sorry an error occurred and your information was not saved

Unable to replicate in demo site since there's no outgoing email (saving the email doesn't actually produce the error, despite the error's wording).


texts: How do I modify the new 4.6 CiviMail form?

texts:
I am the author of a CiviCRM extension that needs to disable, depending on configuration, the URL tracking and open tracking checkboxes of the mailing form. In version 4.4 this was accomplished using hook_civicrm_buildForm (CRM_Mailing_Form_Settings) and calling the freeze method on those elements.

This form hook is not getting called in version 4.6, so how would I go about doing this now?

Thanks for looking.


texts: Managing & reporting Loans or Microloans to org from individuals?

texts:
Our organization accepts loans of $1000 or more from individuals and repays them incrementally with interest. What would it take to integrate the management, tracking and repayment of these loans with our existing WordPress-deployed CiviCRM system and data?

A few things to keep in mind:

Each loan should be tied to either an Individual or to an Organization
After our org (manually) accepts a loan offer, lender should be able to transfer funds to our merchant account via credit card or bank card
Payments (by check) to lender would be entered manually by user
Basic columns should include user_unique_id, Loan ID, Interest rate, Term, Creation date, Principle and Current balance
Each Loan ID should be tied to a record of payments that includes date, check number and any other transaction-specific data for each payment

Is anyone else using Civi to manage incoming loans, and if so, how're you doing this? Or, is anyone interested in developing a new extension (i.e. Loans Component)? What might that cost?


texts: Inheriting memberships through Households

texts:
I have some individual contacts that are related both directly, and through Households.

When one of these contacts has a membership, I want all the household members to also get that membership.

However, it seems that only the household inherits that membership, other individual contacts don't get it.

Should this work out of the box, or do I need to do something specific?


texts: Duplicates in Search Results, no duplicate contacts

texts:
I've set up a search form created from a profile.
Executing the search gives a results list with 3 entries for each contact.
I have confirmed that there are not any duplicate contacts.
Is there any way to fix this?
Drupal 8 + CiviCRM


texts: System status blank - error message changing resource url

texts:
I'm trying to set up two civicrm installs.  both on same host but  with different domains.

First install seems to be fine so far.

Second install has blank system status page.

I have previously fixed this by changing resource urls to absolute paths so I thought to try this (although I don't know why this should be required as the other install is fine!)

but trying to change the resource urls gives this error:

Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
We can't load the requested web page. This page requires cookies to be enabled in your browser settings. Please check this setting and enable cookies (if they are not enabled). Then try again. If this error persists, contact the site administrator for assistance.Site Administrators: This error may indicate that users are accessing this page using a domain or URL other than the configured Base URL. EXAMPLE: Base URL is http://example.org, but some users are accessing the page via http://www.example.org or a domain alias like http://myotherexample.org.Error type: Could not find a valid session key.

What is wrong with this installation?


texts:
I have CiviCRM 4.4.2. When I send mailings to fictitious email addresses, CiviCRM doesn't return any error. In the report, everything looks fine (100% successful deliveries).

It is important to clean all the emails that are no valid anymore.

Any idea?

Thank you!


texts: Will unsupervised dedupe rules be used in API Contact create?

texts: I want to import an old database using API Contact create. In the de-dupe rule documentation it mentions "They are also used when you Import contacts". I see in the API documentation that there exists a parameter 'dupe_check'. When set what will it do exactly? Will it use the rules? How will it respond when dupes are found?


texts: Is it possible to have an updateable log for an event?

texts: We have a requirement where we want to have a user updateable 'log' (text area) attached to an event. A custom field is the obvious answer but the  screen to update the field (event config) would not be suitable as it exposes critical data. Webforms for events are oriented toward contact signups - not at the event level but at the contact level, so are not suitable. And profiles can't be used for events, can they? The event in question is a nightshelter, where we use a webform to sign in guests. We want the night staff to be able to use Civi to keep a log for the night (i.e. the event), but apart from adding a custom field to the event (as described above) there doesn't seem to be a usable solution for us. Any suggestions?


texts:
I've seen similar posts but have not found a solution.

I've created an event and have provided volunteer opportunities for that event. When someone goes to the page to volunteer for an event, the volunteer opportunities do not show. At the bottom, it shows:

"No results found. Please try different search criteria."

Now, what is weird when logged in as a Superuser, it works properly. Every other user group does not work and shows the above result. Upon searching, I saw a post regarding permissions:
CiviVolunteer - Joomla - permission issue with multiple volunteer opportunities

I've granted permission to the AJAX API but the opportunities still do not appear. Because super user works, it would lead me to believe it is a permissions issue but I cannot locate the proper change. Any suggestions?

Here is what I see:
http://blueribbonproject.org/index.php?option=com_civicrm&task=civicrm/vol/&Itemid=2001#/volunteer/opportunities?project=13&dest=event&hideSearch=always


texts: Conditional statements in 'manual' emails or thank you letters

texts:
Do conditional statements with tokens not work when you manually send an email or 'print' a thank you letter? I have a bunch set up inside the auto generated emails for contribution receipts or event registrations but when I add a statement to a message template - and send it out using 'actions - send email to contacts' or 'actions - thank you letters for contributions' the if statement is ignored.

(I'm in Wordpress 4.3.2 and Civi 4.6.4)


texts: Clear custom multiple records fieldset occurences

texts:
My goal is to free all contacts of a specific custom fields group. In other words I want to clear all occurrences of a multiple records custom field set. May I truncate the civicrm_value_<customfieldsetname><id> table, is there an api method or how can I safely achieve this?

Thanks in advance // nielo


texts: Restricting access to a group of contacts

texts:
I've done some searching, but can't seem to hit the right keywords.  I'll pick on the major donor group for this question, though it would apply in other ways.

Most of our users should have access to almost all of the contacts.  However, there is a small group who deal with major donors.   This group is only group who should be able to see the major donors.

Currently we are using a group for major donors, and a smart group for anybody who is not in the major donor group.  The majority of users are in a user group that allows them to edit anyone in the unrestricted contact group.  This works great, except when adding a new contact.

When the new contact is not in the major donor group, the majority of users still can't see the new user until the cron job runs to rebuild the smart group cache.  This messes with people's process and they loose where they are and what they are doing.

Is there a better way to restrict the group?  Can I set an ACL so that it's looking at anything that's NOT a part of a group, rather than a part of a group?  Anybody else doing something similar with a better way of doing this?  Can I set all new contacts to automatically be a part of the unrestricted smart group by default?


texts: “Missing parameters” error in unsubscribe confirmation

texts:
Unsubscribe is giving an error with Drupal 7.69 and CiviCRM 5.23.4. We did not have any issues or errors during the upgrade process.

Unsubscribe links from mailings load the confirmation page correctly, with the correct partially obscured test****@domain.org. But when I fill in the email address and click Unsubscribe, it displays:

Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
Missing Parameters

The unsubscribe page is loaded with this URL:

https://domain.org/civicrm/mailing/unsubscribe?reset=1&jid=3590&qid=1037445&h=c38ef80808cc0140

We included the unsubscribe link in our CiviMail mailings as follows:

Unsubscribe from this list

Log shows this message:

$Fatal Error Details = array(3) {
  ["message"]=>
  string(18) "Missing Parameters"
  ["code"]=>
  NULL
  ["exception"]=>
  object(CRM_Core_Exception)#2268 (10) {
    ["errorData":"CRM_Core_Exception":private]=>
    array(1) {
      ["error_code"]=>
      int(0)
    }
    ["cause":protected]=>
    NULL
    ["_trace":"PEAR_Exception":private]=>
    NULL
    ["message":protected]=>
    string(18) "Missing Parameters"


texts: CiviVolunteer - Where to put translations file on WordPress

texts: after some work on Transifex, we need to install civiVolunteer italian translation on WordPress. Where is the right place to put the .mo file?


texts: How to create a Drupal View that calculates activity end time by duration

texts:
I'm trying to create a Drupal View table of CiviCRM activities that calculates the end time of the activity based on start time and duration.So far I've got the unix start time of the activity, a math expression that turns duration into unix minutes and a math expression that adds the unix start time and the unix duration minutes to get the unix end time of the activity.The final step is to convert that unix end time of the activity to a human readable time like 7:32 AM. All math expressions work correctly, I've checked the computed end time (expression_1) field with unix converters.I'm not certain where I'm hitting a wall but if I test the output with the Views PHP module (I'll code it into my template once I get it ironed out) using something like this:

<?php
print date('d-M-y g:i A', $row->expression_1);
?>

I get 31-Dec-69 7:00 PM as the output for every row. Which is the day prior to unix's base time of January 1, 1970.I'd appreciate any guidance.


texts: Is it better to install civi (Wordpress) on a dev server first then migrate to production or is the reverse better?

texts:
Assuming the goal is to install clones of Civi + WP + MySQL on two servers (let's call them "production" and "dev" with those roles in mind):

These days, is it better to install first on dev then migrate to production, or is the reverse preferred?  Does it matter much?


texts: How does one get rid of the CSS errors regarding dashicons.eot

texts: Or is this a Microsoft Edge only problem?


texts: How do I turn off the "Contribution amounts section" for a membership only contribution page?

texts:
Using 4.7.18 and Wordpress 4.7.4, on my contribution page that I want to configure as a membership only sign-up page, I untick the checkbox labelled "Contribution Amounts section enabled" on the 'Amounts' tab of the contribution page set-up wizard. However, after saving the page, if i then go pack in I see that this field is once again ticked.

I've just repeated this on http://wpmaster.demo.civicrm.org and got the same result. It looks like this is a bug.

Update: now logged as an issue here: https://issues.civicrm.org/jira/browse/CRM-20495


texts: How can I keep the Mailing template (tables) from expanding once sent.  Example:  Everything looks good and formatting is fine when I send from my end but some providers (I think mostly Outlook) is delivered looking extremely wide where you need to scroll over to read.  It doesn't look professional at all!


texts: Deleting and Restoring a Contact detaches Contact from User

texts:
One of our administrators mistakenly deleted three contacts while trying to remove them from a distribution list. I restored the three contacts from trash, but didn't notice that the three restored contacts now no longer showed a Drupal User ID next their Contact ID in the CiviCRM summary screen for the contact.

The users were unable to sign up for events (you have to be have a membership to access signup), and when we realized this, I found each User, clicked the Edit button, then I clicked the "LMGA Member Info" button in the upper right of the Drupal User Edit screen. Just opening that tab showed the CiviCRM info for this member, and then I found that the CiviCRM summary screen for this user now showed Contact ID/User ID. The link seemed to have been restored by Drupal accessing the CiviCRM tables.

I think all is well now, but I'm unsure of what actually happened and why. Can some kind soul please enlighten me?

Thanks,
Rick


texts:
After upgrading to 4.7.2 from 4.6.11 I no longer can load any of my custom_php reports or searches. The custom folder location is not inserted into the include path

  Fatal error: require_once(): Failed opening required
  'CRM/Report/Form/Member/NWTAByUnit.php'
  (include_path='.:/home/mysite/public_html/test/sites/all/modules/civicrm:/home/mysite/public_html/test/sites/all/modules/civicrm/packages:.:/home/mysite/public_html/test/sites/all/modules/civicrm:/home/mysite/public_html/test/sites/all/modules/civicrm/packages:/home/mysite/public_html/test/sites/all/modules/civicrm/vendor/phpseclib/phpseclib/phpseclib:.:/usr/lib/php:/usr/local/lib/php:/usr/local/php56/lib/php')
  in
  /home/mysite/public_html/test/sites/all/modules/civicrm/CRM/Core/Controller.php
  on line 451

The location is set at /home/mysite/public_html/test/sites/all/modules/files/civicrm/custom_php

Running Drupal 7.41 and PHP 5.6. Everything else in the upgrade seemed to work fine. All custom data is available and the extensions directory is working correctly.

I've tried to set the path both via the settings files and the web interface. The web interface does accept the path as valid and sets it correctly.


texts:
I have configured a one year fixed membership type. The membership renewal period has been fixed 3 month before the end of the current year.

When a member fills up the membership signup form, his membership is automatically renewed for one year, even if is not the renewal period.

Thus, if a member filled up several times the sign up form, one year is added to his membership time.

Is it possible to force membership only for the current year, except during the renewal period which include the next year?

Thank you.


texts: Need help setting up Scheduled Reminders

texts:
I want to use the Scheduled reminders to send emails to all members who are not already members for the upcoming membership cycle. We have a fixed membership cycle that begins on September 1 each year. But we accept memberships starting on June 1 for the new cycle since we don't want people paying for only 1/4 year worth of membership. Anyone joining on June 1 or after will be listed as a member for September 1, 2016 - August 31, 2017.

On August 1 I want a scheduled reminder to go out to members who are not yet paid for 2016/17. Not sure what settings to use. I also want to send another message on September 1, October 1 and December 1 throughout the membership enroll season.

Anyone willing to help me with this? I'm not a programmer. I am just a board member who unfortunately agreed to be Treasurer and in charge of memberships. Ugh!  I have one Scheduled reminder set up but not sure at all that the settings are correct.

Thanks if you can help me with this.


texts: update pending contributions transaction date wrong

texts:
When doing a search for pending contributions and then do a batch update to completed the received date is changed to today's date. In the past version 4 this would stay as the original received date. This is causing us problems as the received date shouldn't change.

We are using CiviCRM 5.3.1 on Drupal 7

Thanks

Gareth


texts: Selecting location type or multiple email/phone fields in Reports

texts: Is it possible to select a location type for default contact reports, or is it just hard-coded to use the Primary address/email/phone? Also, would it be possible to list a report with multiple email addresses or phone numbers (e.g. a column for Home, Work, etc.)?


texts:
This was already a topic and I was able to fix it using Smarty and the help of the community but Smarty doesn't work with Mosaico and Greetings are showing pretty poorly in CiviCRM (dear e.g cher doesn't fit the feminine).
Is there a way to set the Greetings because it's not just a French situation as German also has grammatical gender. Is this a PR?


texts: How can I set up Civi so that volunteers have only see private contacts but cannot see their details or their interactions (emails, calls etc).


texts: SOLVED: 'DB Error: extension not found' after PHP upgrade to version 7.0

texts:
Civi: 4.7.11
Wordpress 4.7.2

Hi,
I was working on my database today and munged something up. No problem (I thought)... I did a back up beforehand just in case. Unfortunately, after restoring the database I now get the following when I try to access Civi from the front or back end. WordPress is running fine. (Note: The database restore was a red herring. It was a change of the PHP version at the same time that caused the problem)

Civi was working perfectly so I'm rather baffled as to what the issue would be since it's all the same data as before.

Any suggestions would be appreciated.

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

    [code] => -25
    [message] => DB Error: extension not found
    [mode] => 16
    [debug_info] =>  [DB Error: extension not found]
    [type] => DB_Error
    [user_info] =>  [DB Error: extension not found]
    [to_string] => [db_error: message="DB Error: extension not found" code=-25 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info=" [DB Error: extension not found]"]
)

ADD. 1

I've found two mentions of the same error
- CiviCRM Initalization Error: DB Error: extension not found
- https://issues.civicrm.org/jira/browse/CRM-17874

Both refer to the problem being the use of the MySQL extension. I'm a little out of my depth at this point. As far as I can tell there were no changes to the server in the short time between when I made and restored the backup DB.

ADD. 2

As mentioned in my reply to Kainuk below, it turns out the host upgraded the PHP from 5.4 to 7. I don't have shell access, or access to the folders mentioned in the links in my previous addendum, so I'll  have to get the host to look at it. Will report back with the results of that. (Turns out I didn't need to go to the host. I was mistaken about where to implement the changes)

ADD. 3

The host CPanel dashboard is still showing the old PHP version. I only discovered the PHP version was changed to 7 by running a phpinfo query.

The problem was resolved by implementing these changes
https://issues.civicrm.org/jira/browse/CRM-17874 in
/wp-content/uploads/civicrm/civicrm.settings.php


texts: Can I deactivate my CiviCRM WordPress plugin without losing all my data?

texts: We haven't used our CiviCRM plugin for quite some time, but it has acquired data I don't want to lose. I think it's slowing our site down and I'd like to disable it in anticipation of increased web traffic for an upcoming event. If I deactivate it, will I lose all my data?


texts: Contact Layout Editor- Create New Block not working

texts:
I've just installed Contact layout Editor and can't get the Add Block option to work

I'd assumed this would allow me to create a custom block with fields from different sets- but I'm clicking on the option and nothing happens.
Civi 5.29.1
CLE 1.7.2
Angular Profiles 4.7.31-1.1.2
Drpl 7.78
Quite happy to accept this is user error/ignorance. Anyone got any experience of installing/ configuring layouts?
Editting in response to Pradeep's question.
Following Console Error appears when hitting Add Block
angular.js:14199 TypeError: designerDialog.$el.dialog is not a function
at child.onRender (eval at <anonymous> (jquery.min.js?qnn83t:2), <anonymous>:67:26)
at child.triggerMethod (eval at <anonymous> (jquery.min.js?qnn83t:2), <anonymous>:565:21)
at child.render (eval at <anonymous> (jquery.min.js?qnn83t:2), <anonymous>:1462:10)
at child.render (eval at <anonymous> (jquery.min.js?qnn83t:2), <anonymous>:1920:55)
at child.r [as render] (lodash.min.js?qnn83t:25)
at newProfile (angular-modules.740a618b49edbce232bff241f218f693.js?qnn83t:381)
at angular.js:16696
at m.$eval (angular.js:17994)
at m.$digest (angular.js:17808)
at m.$apply (angular.js:18102)


texts:
Currently trying to set up PayPal Pro as a Payment Processor in Civi 4.6.7, following the instructions here:

http://wiki.civicrm.org/confluence/display/CRMDOC/PayPal+Website+Payments+Pro+and+Express+Configuration

Am I right in thinking that this requires the PayPal Classic API instead of the PayPal REST API? The instructions seem to differ quite a lot from what is presented on PayPal Dev.

Thanks


texts: Maximum Participant Count for Event not enforced in some situation (Wordpress 5.0.8, CIVICRM 5.12.0)

texts:
We saw recently that 2 event registration that were set to have a maximum number of participants.  Event A has set to a maximum number of 29 but allowed 30, and Event B has set to a maximum number of 17 but allowed 19.  Until these 2 events, the maximum number has been enforced well on the events.
When I looked at the last few  registrations (all frontend) for these 2 events, for Event A, the last  registration registered 1min after the prior 2 registrations which registered at the same time to the minute. For Event B, the last 3 registrations where all registered at the same time to the minute.  I tried to register for these events and the Event is full message is correctly shown.
Would this anomaly be due to how the registrations take place particularly when they are in close succession? Any advice and what can be done ?  I researched on the net and it seems there was a issue about max participant enforcement (CRM5039), but that was more than ten years ago, that woulnd't be the issue by know i suppose.  Any advise? Thanks.
-- Edited on 22 Sep 2020 --
Any views on this phenomena ?  Interestingly it happened again a few days ago.  I managed to get 2 participants into a event with a 1 participant limit using the following method:

Participant A typing in his details to register for event
Participant B registered later but completed his registration and pressed "Continue"
Participant A pressed "Continue"
Both participants pressed "Continue" together at the "Confirm Your Registration Information" page

This looks like a bug to me, any views ?  Thanks.


texts: How to export website field for a contact where website is specific website type?

texts: I select some contacts for export. In my field mappings, I add Website but it does not give me the option to choose a specific website type. Is there any way to do this?


texts: Civicrm views bulk operations contact delete operation not working

texts:
I added the Civicrm tables to the settings.php according to the database integration guidlines at civicrm/admin/setting/uf?reset=1
I enabled watchdog logging for civicrm
I installed civicrm entity.
I installed views bulk operations
I selected the Civicrm contact views bulk operations field in a view, and the Delete operation.

The delete operations appear to throw no errors..but the contacts are not deleted.

What could cause this?


texts:
Is it possible to configure a contribution page or amount to be different if the person is a member?

For example, members pay $20 and non-members pay $25 as a contribution (its a separate registration fee, not a member fee in that sense).

Thanks
Norm


texts: How to restrict the Donors to have limited functions of CiviCRM?

texts:
Here is what I have in mind...

The donor needs to have access to submit credit card donation/events and View only his historic contributions.
He needs to access his basic contact info and edit if necessary.
All the link needs to be at one place for easy navigation. Links like PROFILE, HISTORIC CONTRIBUTION, Historic events, CONTRIBUTION PAGES, UPCOMING EVENTS
No access to CiviCRM Menubar and any other pages by direct links
No access to drupal Menubar

I was thinking to create a Drupal template page where I could place all the links, not sure if that makes any sense or even realistic?!

I was wondering did anyone have this kind of situation and if yes, how did you handle it? Or do you have any suggestions on how this can be achieved? Many thanks!


texts: Billing name not included in message template: Receipt (on-line)

texts:
The billing name is not showing in the message template: Events - Registration Confirmation and Receipt (on-line).

The template is using $billingName to get the billing name.

The billing address is showing, using, $address|nl2br.

I don't think civi keep a record of the billing name contribution record?

Other info:

The billing name is showing on the eWay dashboard.

I am Using webform_civicrm to take payment.

Maybe related issue: https://issues.civicrm.org/jira/browse/CRM-18027

Using CiviCRM 5.3.0


texts: Update from 5.4 to 5.36.1 : problem to Update smart groups to rename filters on case_from and case_to to case_start_date and case_end_date

texts:
In Drupal 7, after this long update from 5.4 to 5.36.1 in a CiviCRM which I take administration, I had 2 blocking errors in the sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FiveTwenty.php file. I commented on the 2 lines that are problematic and the update could be done completely :
    $this->addTask('Update smart groups to rename filters on case_from and case_to to case_start_date and case_end_date', 'updateSmartGroups', [
  'renameField' => [
    ['old' => 'case_from_relative', 'new' => 'case_start_date_relative'],
    ['old' => 'case_from_start_date_high', 'new' => 'case_start_date_high'],
    ['old' => 'case_from_start_date_low', 'new' => 'case_start_date_low'],
    ['old' => 'case_to_relative', 'new' => 'case_end_date_relative'],
    ['old' => 'case_to_end_date_high', 'new' => 'case_end_date_high'],
    ['old' => 'case_to_end_date_low', 'new' => 'case_end_date_low'],
    ['old' => 'mailing_date_relative', 'new' => 'mailing_job_start_date_relative'],
    ['old' => 'mailing_date_high', 'new' => 'mailing_job_start_date_high'],
    ['old' => 'mailing_date_low', 'new' => 'mailing_job_start_date_low'],
    ['old' => 'relation_start_date_low', 'new' => 'relationship_start_date_low'],
    ['old' => 'relation_start_date_high', 'new' => 'relationship_start_date_high'],
    ['old' => 'relation_start_date_relative', 'new' => 'relationship_start_date_relative'],
    ['old' => 'relation_end_date_low', 'new' => 'relationship_end_date_low'],
    ['old' => 'relation_end_date_high', 'new' => 'relationship_end_date_high'],
    ['old' => 'relation_end_date_relative', 'new' => 'relationship_end_date_relative'],
    ['old' => 'event_start_date_low', 'new' => 'event_low'],
    ['old' => 'event_end_date_high', 'new' => 'event_high'],
  ],
]);

and 3 lines after, from 120 to 134 :
    $this->addTask('Update smart groups where jcalendar fields have been converted to datepicker', 'updateSmartGroups', [
  'datepickerConversion' => [
    'birth_date',
    'deceased_date',
    'case_start_date',
    'case_end_date',
    'mailing_job_start_date',
    'relationship_start_date',
    'relationship_end_date',
    'event',
    'relation_active_period_date',
    'created_date',
    'modified_date',
  ],
]);

Can anyone tell me if the 2 commented lines will pose a problem later and how to manually perform the operations left out?
I found this question but I didn't know what to do in my case : Upgrade fails with CiviCRM_API3_Exception: "API error: Could not delete payment processor type"


texts: Dashlets do not render on 4.6.12, php 5.5.38 (Drupal 7)

texts:
Dashlets do not render.

I know similar questions have been asked before, so I'll try to be as specific as possible in this one. Not sure what sensible next steps would be to debug this.

The backtrace is as follows:

#0 [SITE_ROOT]/sites/all/modules/civicrm/CRM/Core/Error.php(182): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(PEAR_Error))
#2 [SITE_ROOT]/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(PEAR_Error))
#3 [SITE_ROOT]/sites/all/modules/civicrm/packages/PEAR.php(566): PEAR_Error->PEAR_Error("Malformed response", 16, 16, (Array:2), NULL)
#4 [SITE_ROOT]/sites/all/modules/civicrm/packages/HTTP/Request.php(1225): PEAR->raiseError("Malformed response", 16)
#5 [SITE_ROOT]/sites/all/modules/civicrm/packages/HTTP/Request.php(753): HTTP_Response->process(TRUE, TRUE)
#6 [SITE_ROOT]/sites/all/modules/civicrm/CRM/Utils/System.php(1393): HTTP_Request->sendRequest()
#7 [SITE_ROOT]/sites/all/modules/civicrm/CRM/Core/BAO/Dashboard.php(329): CRM_Utils_System::getServerResponse("http://[SITE_DOMAIN]/civicrm/dashlet/getting-started?reset=1&snippet=5")
#8 [SITE_ROOT]/sites/all/modules/civicrm/CRM/Contact/Page/AJAX.php(606): CRM_Core_BAO_Dashboard::getDashletInfo(2)
#9 [internal function](): CRM_Contact_Page_AJAX::dashboard()
#10 [SITE_ROOT]/sites/all/modules/civicrm/CRM/Core/Invoke.php(278): call_user_func((Array:2))
#11 [SITE_ROOT]/sites/all/modules/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:12))
#12 [SITE_ROOT]/sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))
#13 [SITE_ROOT]/sites/all/modules/civicrm/drupal/civicrm.module(482): CRM_Core_Invoke::invoke((Array:3))
#14 [internal function](): civicrm_invoke("ajax", "dashboard")
#15 [SITE_ROOT]/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:2))
#16 [SITE_ROOT]/index.php(21): menu_execute_active_handler()
#17 {main}

I've checked the following:

curl http://[SITE_DOMAIN] works from the server command line
http://[SITE_DOMAIN]/civicrm/dashlet/getting-started?reset=1&snippet=5 works from the browser I'm using on this site
Dashlets load for the same site on a local development machine
Dashlets load on civicrm 4.7.12 on the same server
CIVICRM_UF_BASEURL in civicrm.settings.php = the URL I'm calling

Adding var_dump($line); after sites/all/modules/civicrm/packages/HTTP/Request.php:1223 gives string(0) ""

Any ideas on sensible next steps?


texts: Where are the "ConfigAndLog" and "templates_c" directories?

texts: Many Stack Exchange answers say to "check your CiviCRM logs" which can be found in the "ConfigAndLog" directory, or to "delete your templates_c folder".  What are the default locations for the ConfigAndLog and templates_c directories?


texts:
I try to export contacts with the option "Merge Household Members into their Households".

As export fields I choose Household → Head of Household is → displayname

But in the export file, this field is empty for all households.

When I export households without the merge-option, the field is filled correctly.

My civicrm version is 4.7.19


texts: Extension for hierarchical custom fields?

texts:
Does anyone have a generic extension for hierarchical custom fields?
For example, we have 'Country', 'State' and 'County' - the value of Country determines what States are valid, and the value of State determines the valid Counties.  But that is done with specific coding for those fields.  I'm interested in a generic extension that enables reproducing the Country/State/County behaviour without further coding.
The tags feature allows custom hierarchies and has a convenient drag-n-drop interface for creating it ... but the end result is a hierarchy in tags rather than fields.
The focus here is creating hierarchies of data attributes, not an organisational hierarchy of contacts.


texts: CiviEvent - Activity Attendance Tracking With Multiple Check-ins/outs

texts:
*Thank you to all responses in advance.

I am trying to determine whether or not there is a viable solution to the following scenario:

I am working for a non-profit center that has implemented various daily programs (could also think of them as "Stations") (will also be recurring daily) for the children to participate in. Examples: Athletics, Study Hall, Arts & Crafts, etc.

In the scenario I am envisioning, each child would be able to go up to a computer kiosk/ipad, (Ideally via a front-end CiviEvent form/registration) enter in their Name and/or ID number (just a 4 digit number associated to each child) and "clock-in" to the program of their choice. Should they want to rotate to a different program, they would "clock-out" (or at least a way to monitor how much time they spent in X program) before "clocking-in" to another program/station. Typically, each child goes to 3 stations per day.

As for reporting, really only have a question on 1 item, the rest should be possible:

How many minutes a day on average did total number of children participate in X program.


texts:
I know that there can be overlapping status' for a membership, and that the order can be set to determine which status takes precedence.

I'm curious if it's possible to have both status' display.  For example our non-profit categorizes members who are paid up on dues as in 'good standing' but we have a period of 2 months they could miss dues and still be in good standing before falling into 'bad standing.'  We would like to have a status for 'good standing', 'good standing 1 month behind on dues', and 'good standing 2 months behind on dues' so that we could better follow up with members who are behind on dues.

I know we could probably just do a status for each month behind, but we had previously set up 'good', 'bad', and 'inactive' standings,  and have various smart-groups and permissions set up around that.  So it would be easier if we could add other status' on top of the memberships' main status.

Any ideas?


texts: Access Control / Word Press -- Not able to edit, delete

texts:
I am setting up our CRM and somehow do not have permission to run reports, duplicate users, edit, delete.

I am familiar with the Word Press permissions page -- still can't access the membership/contact files I uploaded from mail chimp last nite, not able to duplicate search, not able to run reports.

Thanks for your help!


texts: In Civicrm I can copy an Event that takes place annually and simply update some details without starting from scratch. But the Volunteer component of that Event does not copy over with it. Is there a way to copy all the Volunteer setup too so we don't have start over from scratch to set up the Volunteer requirements and shifts again?


texts: How to enter relationship dates before 1997?

texts: In relationship management you also want the information to be complete and include relationships that were before CiviCRM was used. This could typically be relationships older than 20 years. CiviCRM imposes a limit and I cannot find the setting to change it to our needs.


texts: Event registration from contact's "Events" tab "Add New Registration" is broken

texts:
UPDATE 28 OCT: I just updated to Civi 5.6 and PHP 7.1 and this is still a problem. Grateful for any other suggestions.

I'm having pretty much the same issue as this person did not long ago.

I'm unable to add event registrations for contacts through the "Add New Registration" button. The drop-down menu doesn't appear, although oddly if I close the "New Event Registration for" pop-up I can see the drop-down menu 'floating' awkwardly on the page. Looks like a script error. This is affecting the 'event', 'participant role' and 'participant status' options. (Unlike the other person with this issue, my 'accordion' options on the record are appearing just fine.)

Here's trying to use the drop-down - nothing appears

And here's the weird 'floating' menu which appears if I try to type something then close the "New Event Registration for" modal:

I've checked my custom data type fields as suggested in that link, but are all as they should be.

What else can I try?

I'm using Wordpress with Civi 5.4 (Civi 5.6 as of 1 Oct).


texts: Donation recorded under the wrong contact name

texts:
Help!

When one of our donors contributed on our online contribution page with Civi, it was recorded in civi under another (unrelated) donors name. But it was recorded properly in our payment processor. Civi even sent a confirmation email to the correct email address but using the incorrect name of our donor. What went wrong?

I want to move the donation from the wrong client to the correct one, but if I try to delete the donation it says it will delete any financial record of that donation as well. Is this true? Will it delete the payment as recorded in our payment processor Authorize.net?

Thank you all.


texts:
This is actually a very common use case which in CiviCRM, it doesn't seems to be a way to deal with it yet.

Scenario:

a CiviCRM integrated site that keeps both users and their employment information
they are collecting users' employment information via event sign up form
they have quite a field organisations with same name in their database but different postcode (or some other information)
they don't want to publish the names of organisations they have in their database (dislike auto-complete)

Currently with only 'current employer' field, users are not able to accurately match their record with correct organisation.

Is there any implementation out there to deal with this scenario?

Maybe we need to add a postcode field for current employer in CiviCRM profile?


texts: Edits to Events Created via Event Template will not Save

texts:
I would like to customize the title for an event created from an event template but this occurs for any edits made to the event record.

After I make an edit and go through the Save process (click "Save" or "Save and Done" and then select "Only This Event" and then continue), nothing happens and the changes are not saved.

Any idea on what I'm doing wrong?

Thanks!


texts: CIVICRM Update to 5.13.5 triggers 'CiviCRM requires PHP 7.0.0' on PHP56

texts:
I am trying to move a CIVICRM installation up to the 'last' PHP56 supported release which I believe its 5.13.5 however it triggers the PHP7 check expected from 5.14 onwards?

So after running:  drush civicrm-upgrade-db I get:

  CiviCRM requires PHP 7.0.0+. Drush is running PHP 5.6.40.

Is this expected on 5.13.5?? Any help appreciated.

No mention of a PHP7 requirement on the patch notes: https://github.com/civicrm/civicrm-core/blob/master/release-notes/5.13.5.md#synopsis


texts: Is content accessed through a click-through link cacheable by Varnish or similar?

texts:
I have a client whose site grinds to a halt every time they send out a mailing because of incoming traffic.  We're using Varnish without SSL endpoint termination, so right now, we're not caching those pages at all.

However, even if we install SSL endpoint termination (or use HTTP links), the click-through links are unique, even though they return identical content.  Is that content cacheable by Varnish?  Or does using unique click-through links completely break caching?


texts:
I'm running CiviCRM 5.10.3 on the Bitnami WordPress stack (WP has been upgraded to 5.1), and the version of the Bitnami stakc I'm currently on uses PHP 7.0.30, so I'm getting warnings that as of the next release of CiviCRM I'll need PHP 7.1 or higher.

I did a trial run of upgrading the Bitnami stack to their latest which includes MySQL 8.0.13. WordPress works fine after the upgrade, but CiviCRM is throwing SQL syntax errors:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'grouping...

I did disable ONLY_FULL_GROUP_BY (and confirmed it's disabled), so I'm assuming this is an issue with MySQL 8 in general. Is that a reasonable assumption, and if so, is there an ETA on MySQL 8 support? Or are there perhaps other settings changes/workarounds that need to be made for MySQL 8?

I realize this situation is one of the downsides of using the Bitnami stack (i.e. that to get PHP 7.2 I get MySQL 8 along with it), but I do like the convenience of it so I thought I'd ask about MySQL 8 support before exploring other options.

Thanks for any ideas anyone has.


texts: Is it possible to enable/disable logging using cv?

texts: Can the command line cv tool be used to enable/disable logging?


texts: SQL Syntax Error - When starting civicrm with joomla

texts:
Please help, i have no idea what is wrong, all is fine until i open civicrm with joomla, it displays sql syntax error, then when I try to look at my db functions with phpmyadmin there will be a whole page of error, i will be kicked out and unable to login until i restart my computer
-joomla 3.8.7
-apache 24
-php 7.2.4
-mysql 8.0.11.0
-civicrm 5.0.1
-phpmyadmin 4.8.0.1

Apr 24 03:27:15  [info] $Fatal Error Details = Array
(
[callback] => Array
    (
        [0] => CRM_Core_Error
        [1] => handle
    )

[code] => -2
[message] => DB Error: syntax error
[mode] => 16
[debug_info] =>
SELECT  v.label as label ,v.name as value, v.grouping as grouping
FROM   civicrm_option_value v,
   civicrm_option_group g
WHERE  v.option_group_id = g.id
AND  g.name            = 'languages'
AND  g.is_active       = 1  AND  v.is_active = 1  AND ( v.component_id IS NULL  OR v.component_id IN (SELECT id FROM civicrm_component WHERE name IN ("CiviEvent","CiviContribute","CiviMember","CiviMail","CiviReport","CiviPledge")) )  ORDER BY v.weight [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'grouping
FROM   civicrm_option_value v,
   civicrm_option_group g
WHERE  v.o' at line 1]
[type] => DB_Error
[user_info] =>
SELECT  v.label as label ,v.name as value, v.grouping as grouping
FROM   civicrm_option_value v,
   civicrm_option_group g
WHERE  v.option_group_id = g.id
AND  g.name            = 'languages'
AND  g.is_active       = 1  AND  v.is_active = 1  AND ( v.component_id IS NULL  OR v.component_id IN (SELECT id FROM civicrm_component WHERE name IN ("CiviEvent","CiviContribute","CiviMember","CiviMail","CiviReport","CiviPledge")) )  ORDER BY v.weight [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'grouping
FROM   civicrm_option_value v,
   civicrm_option_group g
WHERE  v.o' at line 1]
[to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT  v.label as label ,v.name as value, v.grouping as grouping
FROM   civicrm_option_value v,
   civicrm_option_group g
WHERE  v.option_group_id = g.id
AND  g.name            = 'languages'
AND  g.is_active       = 1  AND  v.is_active = 1  AND ( v.component_id IS NULL  OR v.component_id IN (SELECT id FROM civicrm_component WHERE name IN ("CiviEvent","CiviContribute","CiviMember","CiviMail","CiviReport","CiviPledge")) )  ORDER BY v.weight [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'grouping
FROM   civicrm_option_value v,
   civicrm_option_group g
WHERE  v.o' at line 1]"]
)


texts: configuration variables: where is the documentation?

texts:
This is changing between 4.6 and 4.7.

Where is the best place to see what each setting does?


texts: CiviCRM Event auto public on WordPress after saving

texts:
Our CiviEvents are being made public on our Wordpress whenever we save them. They are all listed as private, because only our community are meant to see them.

When we edit the event in CiviCRM it automatically makes the event public in wordpress on save.

Any thoughts?

Addition information as per the comment.
We are using the following plugins -
CiviCRM Event Organiser V0.4.1 - https://github.com/christianwach/civicrm-event-organiser
AND
Event Organiser V3.6.2 - https://wp-event-organiser.com/
*This one does have an update available.


texts: How to change the value of a custom radio button field programmatically?

texts:
I have a CiviCRM profile that hosts a custom field. The custom field is of type "Radio-Button" and hosts two options:

What I'm trying to achieve is changing the values of each option programmatically when the form gets built. According to the hook reference, the buildForm hook should be used for doing such changes.

I know it's possible to change default values for simple input fields, it can be done by calling the $form->setDefaults( $defaults ) function. But how does one modify more complicated HTML form elements such as radio buttons?

I browsed the CRM_Core_Form PHP class reference and cannot find the appropriate functions.


texts: Upgrading CiviCRM under Drupal 8: How can I get around this error?

texts:
I'm guessing that the upgrade process for CiviCRM under Drupal 8 is something like this:

Use composer require to get the latest version of the package.
Navigate to the database update URL through the browser (http://example.org/civicrm/upgrade?reset=1)

But trying this now, I see what appears to be a version conflict around the pear/log package:
$ composer require --update-with-dependencies civicrm/civicrm-core:5.28.3
./composer.json has been updated
Loading composer repositories with package information
Updating dependencies (including require-dev)
Your requirements could not be resolved to an installable set of packages.

  Problem 1
    - drupal/core-recommended 8.8.8 requires pear/pear_exception v1.0.0 -> satisfiable by pear/pear_exception[v1.0.0].
    - drupal/core-recommended 8.8.8 requires pear/pear_exception v1.0.0 -> satisfiable by pear/pear_exception[v1.0.0].
    - drupal/core-recommended 8.8.8 requires pear/pear_exception v1.0.0 -> satisfiable by pear/pear_exception[v1.0.0].
    - Can only install one of: pear/pear_exception[v1.0.1, v1.0.0].
    - Can only install one of: pear/pear_exception[v1.0.1, v1.0.0].
    - Can only install one of: pear/pear_exception[v1.0.1, v1.0.0].
    - pear/log 1.13.2 requires pear/pear_exception 1.0.1 -> satisfiable by pear/pear_exception[v1.0.1].
    - civicrm/civicrm-core 5.28.3 requires pear/log 1.13.2 -> satisfiable by pear/log[1.13.2].
    - Installation request for civicrm/civicrm-core 5.28.3 -> satisfiable by civicrm/civicrm-core[5.28.3].
    - Installation request for drupal/core-recommended (locked at 8.8.8, required as ^8.8) -> satisfiable by drupal/core-recommended[8.8.8].

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

How can I get around this problem and upgrade CiviCRM under Drupal 8?


texts: CiviMail *only some* Tracked Click Throughs not Redirecting properly

texts:
We have a problem with tracked click trough links ending up in a 404 Page not Found but only when the target URL ends in a hyphen.

e.g. we link to something like and end up nowhere:
https://mysite.eu/this-will-not-work-

while this works as intended:
https://mysite.eu/this-will-work-all-right

Is anyone able to reproduce?

We are on Wordpress 4.9.x, PHP 7.0 and Civi 5.3 (and planning to upgrade real soon).


texts: Unsupervised reserved rule for individuals not working

texts:
Am running CiviCRM 5.9.0 on WordPress 4.9.9, PHP 7.1.25.

When I use a contribution page for memberships that worked before on another hosting provider and on a previous version of CiviCRM, the unsupervised reserved dedupe rule worked fine. Now, every time someone renews their membership online, I get a duplicate record. Not sure when this broke, when we moved over from our old hosting provider, when I updated CiviCRM, or if there's another reason why it doesn't work. I do know that it definitely worked late last year when we started getting some early renewals for 2019 and the system was on our old provider, running an older version of Civicrm and possibly an older version of PHP.

If I manually run the rule, it brings up the duplicates and I can merge them. The merge screen shows that the email, first name and last name are exactly the same. In fact, if I enter the exact same contact information for all contact fields, it still doesn't dedupe.

There is an error in the error_log, and not sure if this is the reason:
[14-Jan-2019 14:00:52 America/Toronto] PHP Warning:  A non-numeric value encountered in /home/xxx/public_html/wp-content/plugins/civicrm/civicrm/CRM/Contribute/Form/Contribution/Main.php on line 900. This line is contained in a "// return if this is express mode" section.

If I have to manually dedupe all of our online membership renewals, this will be a real pain, so any hints are greatly appreciated.


texts:
we use wordpress and civicrm to allow our members to register for sports events.
I would like to display in an article for all authenticated member, the list of registered people to all of the week events.
My first intention was to custom or create a public participant list that already exist but :

it is only for one event
I don't know how to add the Role (ie Animateur or Participant or Invité) and the comment of the participant (both information entered in the custom profile registration)

Need your advise
Regards,
Hervé


texts: How can I import the "communication style" field when importing contacts?

texts:
In my csv I have a field named "Communication style", which I wish to map to the respective field in "communication preferences" for each contact in CiviCRM (formal / familiar).

Yet, while importing the constituents, on the "match fields" step 2, I don't see the "communication style" option in the drop-down.

Which is the way to do this matching?


texts: Expected import behavior when setting custom field to view only

texts:
Checking this option in a custom field View Only?  Is this field set by PHP code (via a custom hook). This field will not be updated by CiviCRM.

I had read that it would not update upon import. However I just ran an import and a field did import that was marked as view only. For a previous import I recall that it did not update.

What is the expected behavior here? I thought it was not to update.


texts: How do I email to two addresses on an individual without Civi creating a new record for the second email address?

texts:
I've read everything I can. I know you can bulk mail to non-primary email addresses. I know I can split contacts up into "Ann" and "Bob" rather than "Ann and Bob", but unfortunately it is far better for the organisation I'm working for to have "Ann and Bob" for accounting, reporting, and contacting purposes.

Is there any possibility or setting or plugin I've overlooked for being able to send single emails to both Ann and Bob's email addresses? It seems the lack of ability for multiple primary emails is a massive oversight.

I'm aware this is a core issue, but surely something has been done!


texts:
Current system:
Windows Server 2012 with IIS 8
Wordpress 4.4.2
PHP 5.5
MySQL 5.1.73

I am currently running CiviCRM 4.6.14 on a live system on which our users have found a problem when ordering custom date fields.  This ordering issue does seem to be resolved in the latest version so I need to upgrade.
I can upgrade to the latest LTS (4.6.36) without a problem but this does not resolve the issue and moving away from the LTS is proving difficult.
I have tried upgrading to 5.0.1 and receive a HTTP 500 error after clicking the 'Return to homepage' link once the upgrade is complete.
I then restored my server snapshot take after the successful 4.6.36 upgrade and tried 4.7.31 as this was the stable version released at the same time as the LTS version I can update to.  Again, HTTP 500 error after the upgrade.

No errors are shown during the upgrade which is reported as successful.

Am I missing instructions somewhere for migrating out of the LTS branch or can someone help with the error please?
My CiviCRM lof file is here: https://pastebin.com/Hw8qhmNN

Any help would be appreciated.

Thanks
Russell


texts: Inline editing of website field deletes it

texts:
When inline editing a website field, it deletes the field completely.

Inline adding a website does work, and it doesn't occur when editing the complete contact. I cannot find anybody else having this issue. Everybody can reproduce this on the demo site at:

https://civicrm.demo.civihosting.com/civicrm/contact/view?reset=1&cid=205

but it also occurs on my own 5.11.0 (In Drupal 7.65) site. Does anybody have a solution for this?

Steps to reproduce:

open an existing contact with filled website field, or create one
click on 'Add or edit website' next to the url
edit the url and press Enter or click 'Save'

The website field is empty now.


texts: Changing group_type to mailinglist fails with unknown db error / deadlock

texts:
Hejdo,

Today I just wanted to make some of our groups accessible by CiviMail by checking the mailinglist group type checkbox. But this took long time (more than 10 minutes) no matter if I did this for a group with about 10 or about 2k contacts. I also tried via group api, same same.

The ui ajax call responds with error and the corresponding log entry states:

"DB Error: unknown error", -1, 16, (Array:2), "INSERT IGNORE INTO civicrm_group_contact_cache (group_id,contact_id) VALUES (...")
[...]
Deadlock found when trying to get lock; try restarting transaction

We have somewhere around 180k contacts and 2k groups. Civi is 4.6.10. CMS is current Drupal 7, DB is Mysql 5.5.46.

Any ideas on how to solve it or investigate on?


texts: Why are email replies not being forwarded properly?

texts: When I send a bulk email through civiMail i use my email address and have the options to track replies and forward replies but in the report I see that there are 2 people who replied but the emails never got forwarded to me.


texts: Is the Max Participants setting on Events broken in 5.0?

texts:
Having recently upgraded to version 5.0 I'm now seeing that although I set the Max Number of Participants at a figure lower than the number of people registered for an event, I can still register for the event through the front end, and I'm not seeing the Event Full message.
Anyone else seeing this issue?


texts: can't edit Contact Details for records with a custom subtype (Error: One or more contact subtypes have been de-selected from the list ...")

texts:
I first posted this issue under another question (after upgrade, can't edit Contact Details fields (Custom Addressee and de-selected subtypes errors)) thinking two separate issues were related. But apparently they aren't.  Since a kind soul correctly solved one of my issues, I marked his answer accepted. But one issue still isn't resolved, I decided to open a new question just for it.

I have upgraded a site from an older CiviCRM version (4.4) to 4.7.29.  And now I can't edit the Contact Detail fields for any record with a specific custom subtype.

I have a type named "Member", which is a subtype of the "Individual" contact type.  When I open one of these records in the backend, I get the following warning:

"One or more contact subtypes have been de-selected from the list for this contact. Any custom data associated with de-selected subtype will be removed as long as the contact does not have a contact subtype still selected. Click OK to proceed, or Cancel to review your changes before saving."

If I click "OK" to continue saving, the record does save -- but all of the data associated with the custom subtype "Member" is deleted.

Here's what I know so far:

-- This problem only occurs with the one custom subtype I've created.  Other custom subtypes under "Organization" don't have this problem.

-- This problem only occurs in the administrative backend contact record screens.  Profiles that are used in the website frontend update all details for this contact subtype without problems.

-- The custom subtype does appear correctly in the "Contact Type" field for the record.

-- Searching for contacts with this contact subtype works correctly and returns all the right data.

-- Creating a new record of this subtype works just fine. However, afterwards trying to save the new record has the same problem.

-- I've confirmed this error is thrown by the file /civicrm/templates/CRM/Contact/Form/Contact.tpl where the Javascript does this check at line 228:

{if $oldSubtypes}{literal}
    $('input[name=_qf_Contact_upload_view], input[name=_qf_Contact_upload_new]').click(function() {
      var submittedSubtypes = $('#contact_sub_type').val();
      var oldSubtypes = {/literal}{$oldSubtypes}{literal};

      var warning = false;
      $.each(oldSubtypes, function(index, subtype) {
        if ( $.inArray(subtype, submittedSubtypes) < 0 ) {
          warning = true;
        }
      });
      if ( warning ) {
        return confirm({/literal}'{ts escape="js"}One or more contact subtypes have been de-selected from the list for this contact. Any custom data associated with de-selected subtype will be removed as long as the contact does not have a contact subtype still selected. Click OK to proceed, or Cancel to review your changes before saving.{/ts}'{literal});
      }
      return true;
    });
    {/literal}{/if}

So.....it seems that one of my legacy custom contact types is no longer recognized by some part of CiviCRM, but it IS still recognized by some parts of CiviCRM?  Help!


texts: What's the best way to take a 'snapshot' of membership counts at a point in time?

texts: I want to create a graph of current membership counts at various intervals - weekly, biweekly, monthly, annual. What's the best way to do this?


texts: Why are all bulk mailings delayed by 5 hours?

texts:
Using CiviMail  in Civi 4.7.29, any bulk email is delayed by 5 hours. The cron commands are received every 30 minutes, and are acknowledged by Civi on the status page. Have checked that php, joomla and civi are all set to London time zone. These are small test mailings of about six users. Any ideas?
Thanks in anticipation.
John


texts:
Since 4.7.13 on Wordpress I am unable to upgrade my CiviCRM install. I enclose an image of the error message I get.

Clicking on the Retry or the Skip buttons has no effect.

I can't see what's going wrong, as I've not had any problems before. I am running WordPress 4.7.2, have no extensions, and cleared the cache and template_c folder as instructed on this page

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


texts:
Is there any way to restore a mailing after you delete it? Or even find it?

We are using CiviCRM 5.8.12 with WordPress. We use Mosaico for some mailings.


texts: How to import existing membership records

texts:
I am trying to import some old and existing membership but fail, which only the start date on 2015 can be imported.

In my xls, the other membership records on 01/01/2008, 01/06/1991...etc are all failed.

Any suggestion to import old existing membership records? or any configuration is missing?

Pleas help. Thanks.

Information as below,

Membership type : Associate /
-Duration  : 1 year /
-Period Type : rolling

Membership Status Rules : Complete /
-Start Event : Start date /
-End Event : End date


texts: Why am I getting a warning about hook_civicrm when Civi's cron runs?

texts:
On Drupal 7.73 with CiviCRM 5.29.1. Every time the CiviCRM cron runs, I get the following warnings in the Drupal watchdog log. Each is a separate entry.
hook_civicrm_alter_drupal_entities should be updated to pass an array of parameter names to CRM_Utils_Hook::invoke(). Array ( [civi.tag] => deprecated )
hook_civicrm_entity_supported_info should be updated to pass an array of parameter names to CRM_Utils_Hook::invoke(). Array ( [civi.tag] => deprecated )
Any suggestions for how to fix this would be most welcome :-)
Thanks.


texts: What is the CiviCRM LTS Version, and should I use it or the latest stable release?

texts: On the CiviCRM download page there is an LTS version underneath the current one. What's the difference, and which should I use?


texts: on behalf profile organization name not showing on pay later receipt

texts: We are using the on behalf profile, but the organization name isn't showing on the receipt when users use the "Pay Later" option.  The organization name is under "Member" and the receipt is only displaying fields marked as "Contact"


texts: How to use Laravel framework for building CiviCRM extension?

texts: I am building a CiviCRM extension using civix build tool. I want to use laravel in my extension. How to use laravel framework in my project?


texts:
I would like to bulk add countries to my organizations via profiles but when adding an organizational field type I can't see the country field, only the official name, SIC code and some custom fields I created. I can only see country at "contact" type  not at "oragnization" tpye.
But bulk editing organizations with this "contact type profile field" doesn't do anything.


texts: Why do these characters - Â Ã Â - that were not added appear on Event registration pages created using CKEditor?

texts:
We're on Civi 4.6.21 and Drupal 7.

We can't figure out why these characters - like Â Ã and Â -  appear in our Event pages. The text is not on the page we created, obviously, right in Civi.

See the screenshots below - the first is this page in the Chromium browser on my laptop running Ubuntu.

Any clues appreciated!

UPDATE: The problem appears to be with the built-in version of CKEditor, see the second screenshot below. This code - &Acirc; - keeps getting re-inserted in to the page intro text source on Save after being edited out.

UPDATE 2: So - not sure why - and not a final fix - but editing the intro text source using Firefox, rather than Chrome, seems to take the weird characters out and not re-insert them on Save, pretty much. See the third screenshot below - the page after editing the source using Firefox, not Chrome.

UPDATE 3: Here's the CKEditor bug report from four years ago about this issue, it was fixed three years ago...maybe it's time to update the CKEditor version in CiviCRM 4.6.X? Is there a newer version of CKEditor in CiviCRM 4.7.X ?


texts:
We're just a very small charity trying to put this together with limited experience.
I had set up some custom fields for the database but some changes to those fields was requested which I made and now when I run a find contact search, a list of releveant contacts will come up but if I click on a contact name I get this message:
Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
DB Error: no such field
I imagine it has something to do with changing the fields. Any ideas of how to move forward with this?  I only had uploaded some of our database as a test so happy to delete all of our contacts and start again but don't know how.
Thanks in advance!!


texts: I have deleted a contact by mistake. Please explain how I can restore the contact to the database ?


texts: Donation/Contribution Page Best Practices

texts:
Are there examples of Donation/Contribution Pages that have been created with CiviCRM or Drupal Web Form that you think work well?

Are there advantages of creating it with CiviCRM or Drupal Web Forms?

Also are there ways to get it to work, so it uses the organization's url?
name.org/donate?

Thank you.


texts: Is there a way of removing 'View' from event reports

texts: Event reports have the word 'View' to the right of the contact name - it's a link to the participant record.  It's not a selectable column in the report and the problem is that when the report is converted to a pdf the word 'View' gets merged into the contact name which can make this unreadable.  Is there any way of removing this 'View' column from event reports? Or making the pdf format better?


texts: What are the recommended disable_functions for Civicrm, if any?

texts:
I've seen various security checklists suggesting the use of disable_functions in php.ini, giving a wide variety of functions to disable.

Is this a good practice with Civicrm, and if so, what are the functions that should be disabled?

So far Google hasn't shed any light on this...
Thanks for your thoughts

Civi 4.6.17, Drupal 7.50


texts: Update Multiple Contributions with Missing Attributes via Search Builder?

texts:
We have 300 or so contributions that are missing a custom field.
We want to manually update those records.
We are running a search for contributions that have a custom field but are missing the custom field we want. We run a search builder.

Example

Contribution - Custom Field 1 - = - Attribute
Contribution - Custom Field 2 - Is Empty
Contribution - Date Received - > - ##/##/####
Contribution - Amount - > - 1

I run the search and I find the 300 or so contributions.
I can only update each record by clicking on the contact, going to their contributions, finding the contribution, edit the custom fields.
If I try to update multiple records - I can only update the contacts - not the contributions.
So I add them to a group - run a contribution search for the date range and limit to only the group.
Now I have over 700 contributions as those contacts may have given multiple times.
I can bulk update the contributions now with a profile - but I now have to sift through half the contributions that do have the correct custom field chosen and find only those that are blank.

Is there a better way to do this?

Export/Import is not a good solution.


texts: How can i add organization Legal name to search?

texts:
I am looking for a way to add Legal name to search. I can see on this page that it is possible to add Nickname to search, which i have done.

Civi webform adds great functionality to add relationship to individual contacts. I allow users to lookup their current employer when completing a webform online and with possibility to add new employer.

I'm looking for a way to reduce the amount of duplicate employers added by users because some new organizations added are already in the database but entered different or only with an acronym.

I have turned off wildcard search, and also enabled Nickname field search.

The problem here is that, i have organizations in different languages, so Organization name field is for English name, Nickname is for another language or for acronym.
I want to be able to also use the Legal name and add it to search. For example: Organization name: World Bank, Nikcname: WB, Legal name: The World bank. This way user will be able to find the same organization by keying it in 3 different ways thus reducing the number of duplicates in the system.
With only the organization name and Nickname, another user will add 'The World Bank' as new organization.


texts: Converted to 5.33.2 but got dashboard crash - can't figure

texts:
I'm not having any luck with upgrading one install to 5.33.2!  Last week it was orphans in a relationship table.  This week the conversion ran OK but was unusable with dashboard crashes for some users when they logged in - traceback here.  In trying to fix I emptied the civicrm_dashboard_contact table, then a user could login OK and get the 2 default dashboard entries (news and getting started) but when they logged out and back in they got the same crash.  This seemed to affect only users who are restricted by ACLs to see certain groups, which I don't understand - I gave them the Drupal permission to see the 'contact dashboard' (which isn't the same dashboard, is it?).  Weird, because another install upgraded to 5.33.2 worked OK, but this install does go back to 2013 so I'm thinking maybe a table/index definition - the table civicrm_dashboard_contact has an extra index (compared to the 5.33.2 system install that works) as follows - but the duplicate key in the traceback is index_dashboard_id_contact_id and not the dashboard_id.

FK_civicrm_dashboard_contact_dashboard_id

(PS. I restored the system back to 5.28.3 as it was unusable)


texts:
I have Wordpress installed in a subdirectroy on my site (mysite.com/wordpress) while the site is displayed using mod rewrite as just mysite.com

This works fine for the backend of CiviCRM, but it is causing problems on the frontend. CiviCRM writes up URLs as mysite.com/wordpress/civicrm?etc which works fine on the backend, however, upon clicking on the links on the frontend the URLs are rewritten to mysite.com/civicrm?etc, which causes the links to fail and takes the user to a WP Page that says

CiviCRM

Do not delete this page. Page content is generated by CiviCRM.

How can I fix this? Is there a way to prevent WP from rewriting those URLs? Or is there a way to properly Configure CiviCRM when WP is installed in a subdirectory?

Edit: It turns out I indirectly came across a solution to this in another question I asked. The URL is here: CiviCRM/Wordpress "Page" Integration


texts: CiviCRM Installer Errors - Can't change DB settings

texts:
I can't get past the install page (/wp-admin/admin.php?page=civicrm-install). The installer prepopulates to my WordPress DB settings and won't take the CiviCRM DB settings I put in. I input the MySQL server, username, password and DB settings and hit the Re-check Requirements button and it fails. Below it shows the Database details, not with the data I input in the fields above but rather with the original WordPress DB server and database.

Is there any way to change the "default" values that the page is coming up with or install without using the installer? I didn't find any tricks around this problem. This is a WordPress Multisite network installed on AWS (Ubuntu 14.04/WP 4.6.1/CiviCRM 4.7.11).


texts: Member's only pages in wordpress, for users with a related membership

texts:
We have a site Wordpress which offers corporate membership, and this extends by relationship to employees.

The client is having issues where users are booking onto events, after the corporate membership has elapsed.

I've had a quick look at the Wordpress Civi Member plug in, to start creating a member's only section of the site. My main question is:

Can the plug in handle users with related memberships, or does it work best with primary memberships?

And... has anyone got experience of configuring this type of set up? Are there any pitfalls I should be aware of?

Cheers

Craig


texts: Recommendations or Experiences on Archiving Mailing Data

texts:
We have an instance that has been using CiviMail extensively for years.
The civicrm_mailing and civicrm_activiy tables far exceed the number of records of any other tables.

It seems likely that these tables could have some ancient history removed from them and make some operations work more smoothly, faster, or less error prone. e.g. back-ups or operations in civicrm involving groups.

Are there any recommendations, best-practices, or gotcha's for archiving/deleting historic data in CiviCRM. Specifically for mailings and activities, but while we are at it: contact or other data as well?

Top database tables:

2.6G    ./prod_civicrm/civicrm_mailing_recipients.ibd
2.3G    ./prod_civicrm/civicrm_mailing_event_queue.ibd
1.6G    ./prod_civicrm/civicrm_activity_contact.ibd
1001M   ./prod_civicrm/civicrm_log.ibd
641M    ./prod_civicrm/civicrm_mailing_event_delivered.ibd


texts: is it possible to merge duplicate event locations?

texts:
Multiple events have taken place at the same location, but there are multiple listings of the same location. Is it possible to merge these locations without losing any of the data from the events?

On CiviCRM 5.3.1.


texts: Why is OpenStreetMaps in Civi 4.7.24 rendering a featureless grey map?

texts:
I've just upgraded a site that was running Civi 4.6.30 to 4.7.24. I use OpenStreetMaps as the Mapping provider. My maps are now appearing as featureless grey maps rather than what I'd expect.

The same seems to be true when I test it on http://dmaster.demo.civicrm.org

My old site continues to render the map in full colour.

The template concerned (CRM/Contact/Form/Task/Map/OpenStreetMaps.tpl) certainly looks very different between the two versions of Civi that I've upgraded from/to.


texts: Installing GiftAid v3.04 into CiviCRM v5.17 Drupal 7 PHP 7 - getting dbError

texts:
I'm getting this when I click Install on the Extensions page,

Sorry, due to an error, we are unable to fulfill your request at the
moment. You may want to contact your administrator or service provider
with more details about what action you were performing when this
occurred.
DB Error: already exists

From error log:
Sep 26 08:40:37  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => exceptionHandler
        )

    [code] => -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_custom_field (custom_group_id , name , label , data_type , html_type , is_required , is_searchable , is_search_range , weight , is_active , is_view , text_length , note_columns , note_rows , column_name , in_selector ) VALUES ( 2 , 'Eligible_for_Gift_Aid' , 'UK Tax Payer?' , 'Int' , 'Radio' ,  1 ,  1 ,  0 ,  1 ,  1 ,  0 ,  255 ,  60 ,  4 , 'eligible_for_gift_aid' ,  0 )  [nativecode=1062 ** Duplicate entry 'UK Tax Payer?-2' for key 'UI_label_custom_group_id']
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_custom_field (custom_group_id , name , label , data_type , html_type , is_required , is_searchable , is_search_range , weight , is_active , is_view , text_length , note_columns , note_rows , column_name , in_selector ) VALUES ( 2 , 'Eligible_for_Gift_Aid' , 'UK Tax Payer?' , 'Int' , 'Radio' ,  1 ,  1 ,  0 ,  1 ,  1 ,  0 ,  255 ,  60 ,  4 , 'eligible_for_gift_aid' ,  0 )  [nativecode=1062 ** Duplicate entry 'UK Tax Payer?-2' for key 'UI_label_custom_group_id']
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="INSERT INTO civicrm_custom_field (custom_group_id , name , label , data_type , html_type , is_required , is_searchable , is_search_range , weight , is_active , is_view , text_length , note_columns , note_rows , column_name , in_selector ) VALUES ( 2 , 'Eligible_for_Gift_Aid' , 'UK Tax Payer?' , 'Int' , 'Radio' ,  1 ,  1 ,  0 ,  1 ,  1 ,  0 ,  255 ,  60 ,  4 , 'eligible_for_gift_aid' ,  0 )  [nativecode=1062 ** Duplicate entry 'UK Tax Payer?-2' for key 'UI_label_custom_group_id']"]
)

Any help would be appreciated.


texts: CiviEvent 4.7* Wordpress - calculated fees with default values doubled w/WP Plugin

texts:
After setting up and configuring Civicrm 4.7.20 w/latest Wordpress (4.8.1 or so) I upgraded to 4.7.21 all seemed to go well.  Then I logged in and tried 'test drive' an Event, and 'live' registration. In 'live' mode, the default service fee I set up was doubled.   I created a test system locally and turned on debugging, tried Smarty debug and the relevant price set fields all looked correct. In NetBeans I checked the Register form after the setDefaults call, values were correct, but any price I set up with a 'default' was doubled by Calculate.tpl
I know this is very specific and I didn't expect to find a solution on stack exchange.


texts: Webform "Not You?" message does not appear in secondary theme area

texts:
If I set up a webform and put it in the primary theme area, I can see the "Not You?" message on top of the screen. The same webform, in a secondary theme area (a sidebar), doesn't show the "Not You?" message. Is there any way to make that message show up?
Drupal 7.


texts: How to access multiple CiviCRM website fields for a contact in Drupal Views?

texts:
I have two website fields for my contacts, a work website and a personal website.  I am creating user profile pages (NOT CiviCRM profiles) for each of our members and want to display both website links, but, when I try to add a website field to the view, there is just one option to choose from and it is labelled generically, rather than as either personal or work.

How do I access both website fields?

When I add fields to the view for email or physical address, in the 'Configure field' dialogue in Views, there is a select box to choose which 'location type' you want for your email.

However, I don't get that option with websites.

Thanks,
Lewis


texts: Can I use a custom style sheet (CSS) for user modifications?

texts:
I have noticed that the content of CiviCRM pages contain selectors such as:

Type selectors elementname,
Class selectors .classname, and
ID selectors #idname.

I know these can be used to modify the style rules to alter a specific element (or elements) of a page.

What stylesheet do you use to alter page content?


texts: How can I add my extension API into civicrm API?

texts: I create a extension with API but I want to add in API 3 (i.e.on civicrm portal in support->developer ->API explorer.)


texts: Are Deduping Rules working for Contact Subtypes?

texts:
I have created an Individual Subtype (named "Child"), for children (who don't have mail address).

Although I specified a matching rule (first name / last name) in the creation Webform (I use Webform Integration), I have some duplicates (???).

And if I want to dedupe/merge those (using this same dedupe rule), I don't find them.

Do dedupe rules only work for Contact Types and not for Subtypes ?


texts: From email address not changing per user

texts: When we send emails, the person receiving the email can reply to the sender, and it has the correct name of the sender, but the email address it says the email is from isn't the sender.  My name is Helen.  My colleague's name is Clare.  Clare sends an email from her user account.  The receiver gets an email from 'Clare < helen@....>  The 'from email address' options contains all the correct names and emails.  Any help would be massively appreciated!


texts:
I have done a CiviCRM installation for a local networking club.  They are adopting CiviCRM slowly, and at the moment we only have the member's contact records and membership records imported.

We need a report that shows the number of memberships that are of different statuses; they want to know at any given time how many current members, grace members, expired members, etc.

How to do this?


texts: Problems making resource URLs portable on CiviCRM

texts:
I'm getting a warning for my Wordpress install of CiviCRM, under the title Resource URLs: Make them portable:

  Resource URLs may use absolute paths, relative paths, or variables.
  Absolute paths are more difficult to maintain. To maximize
  portability, consider using a variable in each URL (eg "[cms.root]" or
  "[civicrm.files]").

On the Resource URLs page it brings me to, I have the CiviCRM Resource URL as

http:// <path to Wordpress install> /wp-content/plugins/civicrm/civicrm

The others on this page which are populated are Image Uplaod URL

[civicrm.files]persist/contribute

and Extension Resource URL

[civicrm.files]/ext/

But when I try to change CiviCRM Resource URL to

[civicrm.root]/

which is the recommended portable value from the help button near the top, and then save it, the value is not saved, and reverts to the absolute URL above, and the warning persists.

I have installed CiviCRM 4.7.27 on Wordpress 4.9.1.


texts: CiviCRM Security Patch Needed warning still exists from older Civicrm Version?

texts:
I've moved a CiviCRM installtation from 5.7.3 (LTS) up to 5.10.4 *latest.

However CiviCRM still gives the 'Security Patch Needed warning' which displayed when it was on 5.7.3.

Database updates, cache clear and cron have all run so bit unsure why this still displays?

Thanks in advance for any advice!


texts: Is there any information that tells the last action of membership record (edit or renewal)?

texts: I'm going to write a hook to distinguish a saved membership record, how do I know the last action of saved membership record is edit or renewal?


texts:
I was looking around but haven't been able to find an obvious answer to my question, but has anyone ever dealt with a newsletter signup block or page just for site visitors? I've been trying to find examples but it doesn't really seem as though anyone's ever required this. We'd like to move our current newsletter signup form over to CiviCRM just so everything is all handled in one place, but I'm stuck as to how to accomplish this.

I'd appreciate any help or advice - Matt


texts:
Is it possible to change the labels for the billings fields when people are signing up for an event.

In the swedish translation of the fields: "First name, middle name and last name" they are called the same. Which makes it difficult for users to know what to write.

Example (translated from Swedish)
Billing adress 1 (mandatory)
Billing adress 2
Billing adress 3 (mandatory)

I have searched a lot of forums to find out how to change this. But it seems impossible. Should the translation be updated in Transifex or should it be made in the local installation?


texts:
There are a couple of posts, listed below, already on this topic - but I'd like to follow up:

SUMMARY

I can create an ACL role and limit access to a custom field group - which is seemingly wonderful. Data that should not be visible to everyone is not.

BUUUT any user (with the ability to edit a contact) can add users to an ACL group. I feel it renders ACL roles/restrictions pointless. (We have users who need to be able to edit a contact, to adjust contact information and such but shouldn't be privy to all the custom data in the system.)

How do I prevent a user from adding contacts to ACL groups?

Permissions, ACL and Groups

QUESTION
Does anyone have feedback on the Group Protect extension? It looks very promising but the notes indicate it's a work in progress from early 2016. Or is anyone taking a different avenue to prevent users from adding themselves to ACL groups?


texts: Can I automatically add someone to a Civicrm group when the register as a WordPress subscriber?

texts: When someone registers on our WP site I would like to automatically add them to a specific CiviCRM group.  I don't think a smart group would work here (if I could figure out the right search) because we want to use the group for emails and folks need to be able to unsubscribe.


texts: Drupal module to check "auto renew" checkbox for membership getting overridden, why?

texts:
Edit Note: Since I first began looking into this, I have been reminded that the Drupal way to solve this challenge is to develop a Drupal module to customize the default CiviCRM behavior. I have now done so, however something is overriding the custom Drupal module behavior it injects into CiviCRM.

We have understood that with CiviCRM, there are three options for the auto-renew of Civi Memberships:

civicrm_membership_type
Add column - auto_renew TINYINT(4), default 0
values: 0 = No auto-renew option; 1 = Give option, but not required; 2 = Auto-renew required;

We have need of an "auto-renew by default / you may opt out" membership mode, as a handful of potential members are absolutely offended that the "Please renew my membership automatically." check box is checked and grayed out.

This particular site runs CiviCRM with Drupal 6.x, latest version of CiviCRM.


texts: How to dynamically add datafields/profiles in form?

texts: I am trying to set up a committee registration form where the registrant also adds contact information for three other people (more contacts being added as the number of people grows in that group). How can I do this with Civicrm? Until now I was adding custom datafields for the other 3 contacts, then I realized that more people will be added later, so I can't be creating a custom datafield per person. If I create a new profile, how can I embed it in the initial registration form? Is there a way to add fields dynamically to a form (so that the registrant can add more than 3 people during registration)?


texts: What is the best practice to change Email Address

texts:
I use Webform Integration to access/update contacts informations.

Is it a good practice to use a Webform to modify a contact email address ?

What matching rule should I use ? What if an other Contact already has the new mail address ?

Will the modification be updated for the pertaining Drupal User ?
What if there is no pertaining Drupal User ?


texts: How to change mailing form and set the default value for url_tracking to false?

texts: Is it possible to alter the mailing form? I want to set the default value for url_tracking to false. Usually I would write a hook_civicrm_buildForm and set a custom default value but this hook is not being called when loading the mailing form.


texts: CiviMember Role Sync not Syncing One User

texts:
Our Drupal 7.50 website is set up so that users can subscribe through CiviMemberships via a contribute page and then we use CiviMember Role Sync Module to assign them a new Drupal role. This has worked well and thousands have gone through this process. However, we have one user who went through the process of creating a Drupal account and then subscribing (becoming a member) and the sync refuses to sync his accounts. I had to give him the Drupal role manually. Names and email address are the same in his Drupal account and his CiviCRM contact record. The contact record shows his membership and contribution. Any ideas how to troubleshoot or manually sync this one user?

CiviCRM 4.7.15 Drupal 7.50 Commons

Thanks!


texts: Exporting Drupal user account ID's through Civi search

texts:
I'm trying to export the Drupal User ID's for a particular Civi group, in preparation for GDPR and as a general clear out. I am able to search for all users in Civi which are a CMS user (and therefore have a Drupal account) but when I go to export and download this information none of the available fields will provide the Drupal User ID, the columns are just blank.

Is this my Civi getting confused and refusing to provide information (which it does do sometimes) or do I need to download this information in a different way.

Hope that makes sense and thanks for any help!!


texts: Give anonymous users access to a report's contents?

texts:
I want to make a CiviReport accessible to anonymous users.  I can set the report's "Access" to allow anonymous users, but I want them to see the results of the page without giving them the permission to view any data except what's on the report.
This is how Views works, and Webform-CiviCRM and Caldera Forms allow you to explicitly override contact viewing permissions for selecting anonymous contacts.  Short of overriding a function in the report template, is there a way of making a report's contents available to anonymous viewers?


texts: Why are my CiviCRM queries rewritten to short links that do not work?

texts:
I'm running a Wordpress 5.5.1 site with a custom theme that was working fine until a few months ago. With no changes to the site other than plug-in and Wordpress updates, the CiviCRM-generated pages no longer work in Live or test modes, and my site links are briefly displayed before being rewritten to short links that result in a blank template. CiviCRM is version 5.14.0.
Here's an example from the live site:https://cantusnovus.org/support-us/
On this page is an Orange button that links to: https://cantusnovus.org/civicrm/contribute/transact/?reset=1&id=4
When that is clicked, the link is rewritten as: https://cantusnovus.org/civicrm/?reset=1&id=4
To my knowledge, nothing has changed in the hosting environment or Wordpress templates or CiviCRM configuration. Here's what I've tried:

I removed a redirection plugin I was using (no effect)
I disabled/removed all plugins not directly needed by CiviCRM just to look for interference (no effect)
I switched themes to test if something in my custom theme was interfering with the display (no effect)
I checked (and simplified) .htaccess file to just standard Wordpress setup (no effect)

While CiviCRM works from the backend and I can access/edit forms, I cannot Preview them. I also can't see (preview) previous mailings, etc. I simply can't display anything in live/preview mode.
Any ideas would be much appreciated!


texts: Is anyone else seeing multiple two contributions and two activities for a single online transaction?

texts:
We are in the process of upgrading CiviCRM from v4.4 to v4.7. (Yes, I know it is long overdue.)

We have a Drupal 7 site and use eWAY as our payment processor. Everything works as expected for a front-facing online membership payment on 4.4. However on the  upgraded 4.7.17 staging site, although the contribution and membership functionality is correct (ie, only one payment taken and recorded and membership end date consistent with that), the activities are being double recorded (sort of).

If I signup as a new member then 5 activities are created within 8 seconds. They are (in order):

two identical contribution activities (same source record id)
one membership sign up activity
one change membership status activity from pending to new
one membership renewal activity

If I renew an existing membership I get at least 4 activities (more if the membership type is changed).  They are:

two identical contribution activities (same source record id)
two identical membership renewal activities.

For both new signups and renewals only one membership receipt is sent as expected.

If I make a donation on line I get just one contribution activity as expected.

This double recording of activities happens whether I use a pre-configured membership price set or just choose one of the offered membership types when I set up the contribution page.

Has anyone else seen anything like this or have any insight to offer?


texts: Using profile for people to submit activities

texts:
How can I create a data entry profile that creates an activity?

Example: We train peer leaders, who then meet with mentees. We'd like them to submit their meeting information (e.g. duration, # of attendees, brief description) as an activity (e.g. type = 'peer leader meetings with mentees') that would be associated with the peer leader contact.

Similarly, we'd like to have activity types 'gave informational talk', 'served on a panel', 'participated in outreach event', etc.

The reason I'm asking about doing it as a profile is that we wouldn't want them to be able to view contact participation history, etc.- just to complete and submit the activity.

Or is there a different method you'd recommend to do this? Thanks!


texts: How to display the Event Registration Form for public?

texts:
I am just starting about a week to use CiviCRM & CiviEvents running on Drupal. Managed to create an event and its Online Registration Form.

However, the form appears differently for logged-in and non logged-in users.

My question: How to display the same form for logged-in and non logged-in users?

What I did so far:

I created 2 profiles for the form, "Registration Info" & "Course Type".*
On the Event's Online Registration, I included these 2 profiles.
If a logged-in user click the Register Now button at the event page the system displays the correct form:

But when public click the button, the system displays this form:

Thanks in advance!

Regards,

Voldi Sinarta


texts: How to automatically generate DAO classes for my DB tables

texts: I have about 22 DB tables for my extension and more are coming in as I work on the extension, I need to be able to  automatically generate the DAO and BAO files to access these tables from my code, I followed this thread How do I add a new table to my extension? and it seems to be worked for the author of the post but I need more light on how generate the xml schema files if they can be generated and where do I run the xml/phpGencode.php  specified in the comment to get the DAO files.


texts: Why does VAT keep being added when editing payments

texts: When we issue a membership the payment automatically feeds through the correct pricing.  If we then have to go in to edit the membership the price updates by adding VAT on again to the already inclusive total.  Has anyone else had this issue and how did you resolve it? We are using Civi 5.8.0.


texts:
CiviCRM has certain post-installation checks where you get displayed warnings on your webadmin dashboard, for instance on missing file permissions for directories. But when you click them away they are gone. I informed my Admin about them, but there was no way to tell him the exact content of the warnings.

a) Are past warnings logged somewhere?
b) How do we manually check our installations again?


texts:
There are several instances where I want to remove some buttons, inputs, tabs, etc on various screens for non-admin users. For instance, on the Event Search screen in this template

CRM/Event/Form/Search.extra.tpl I have

<script>
{literal}
//remove smart group creation
CRM.$(function remove_smart_group_creation($) {
 $('#task option[value=12]').remove();
});

//remove group add contacts
CRM.$(function remove_group_add_contacts($) {
 $('#task option[value=2]').remove();
});

//remove delete participants
CRM.$(function remove_delete_participants($) {
 $('#task option[value=4]').remove();
});
</script>
{/literal}

How could I exempt the administrator role?


texts: How do I distribute CiviSurvey by email, and then analyze the results?

texts:
Can somebody help me to answer these following questions or refer me to some source to find out the answer:

I've created a survey by creating the custom fields and custom data. How do I get this survey distributed to people on my database i.e how do I email the survey link to targeted respondents?
If the survey can be emailed to them, are their answers automatically recorded on their account/profile?
In the report feature we can see answers of individual respondents. But does civiSurvey provide analysis capabilities such as counting percentage of the people choosing a, b, c for a specific question? If yes, where do we get that information?


texts:
In drupal the webform integration module allows an autocomplete field where you can search to add an employer from existing contacts. On my wordpress site however i am trying to allow users to update their current employer but it is just giving a text field with no autocomplete.

Are profiles able to use an autocomplete field for current employer? If not what are my other options?


texts: Divide recurring contributions between financial types

texts:
I am working on the following scenario. The organization wants to offer anyone that signs up to contribute monthly gets a membership for $100. So if they sign up to donate $50/month the first $100 is the membership dues (non-deductible) and the remaining $500 for that year is considered a donation (deductible).

I have setup the contribution form with a membership type that renews monthly and auto renew is required. That takes care of the payments.

Anyone have an idea on how to record the donations after the initial $100 as a donation that is deductible? It is important to provide the donor a statement at the end of the year for tax purposes.

Any thoughts would be great!

The site is in WordPress 4.9.5 with CiviCRM 5.0.