texts: Simple Donation's donation amounts display incorrectly

texts:
I just installed the extension Simple Donate to try it out.  When I view the donation page generated it looks like this, with lots of decimal points on the donation amounts (my normal donation page has no decimal points).  I can't see where I would control this - anyone know?

This is what I see when I inspect:


texts: What creates future-dated civicrm_financial_trxn records, seen in Bookkeeping Transactions report?

texts:
When viewing the output of the Bookkeeping Transactions report, I'm seeing many contributions listed with repeating future-dated transactions, even though these transactions do not appear when looking at the contributions in  the UI (i.e., viewing a contribution in the "Contributions" tab or Find Contributions search).

A common pattern is that there are several transactions, on the same day of successive months, for the same amount, leading up to several months in the future.

Update: as asked in comments, yes, this site has Deferred Revenue enabled.

Question: What normal process are there in CiviCRM that create future-dated civicrm_financial_trxn records?


texts: Currently it is not possible to select the greetings (mail or postal) in profiles. The greeting row is empty, also in preview view. Is this a bug?


texts:
It appears that Google Captcha does not seem to work with the GDPR extension.

I have a fully working setup using profiles as normal on site - which can be seen here

https://peoples-press.com/index.php?option=com_civicrm&task=civicrm/profile/create&gid=57

However, on this form,

https://peoples-press.com/index.php?option=com_civicrm&task=civicrm/gdpr/comms-prefs/update

I have captcha activated but it does not show on form. If I click Save then it alerts me to complete Captcha despite it not being possible. Form works fine if I deactivate Captcha.

Joomla 3.8.7 and Civicrm 5.1


texts:
I'm considering using CiviDesk's Google Apps Sync extension with CiviCRM 4.7 to update my domain's Directory. Since the information page (https://civicrm.org/extensions/google-apps-sync) is a bit old and light on details, I'd like to ask this community a few questions:

It was compatible as of civicrm 4.3. Is anyone using it with later versions?
On initial use, does it empty and replace your existing Google Apps Directory, add to it, or synchronize both databases.

I've also asked CiviDesk these questions and will update this post if I hear from them.


texts: Civicrm - Use profile create mode only works 50% of the time

texts:
I'm using CiviCRM 4.6.10 with Joomla 3.4.8

I have a profile form setup for public view for volunteers to register.

50% of the time the form works great, submits the new contact to the database, sends an email, and forwards the submitter to the thank you page.

The other 50% of the time, once submitted, it does not send an email, does not submit the contact to the database and does not forward to the thank you page. It actually just redirects to the main page of the website.

Does anyone have any idea why this might be happening? It seems pretty random. Any help would be appreciated. And of course let me know if I left out any essential details.

Thank you in advance for your help!


texts: Discrepancy between # of contacts in smart group vs # of contacts in smart group mailing

texts:
Using Drupal 7.67 and CiviCRM 5.13.5.

We run volunteer inductions, and send an email to all people who have attended volunteer inductions (as per CiviEvent) after the induction. We only run inductions once a month, though there is sometimes a delay of a few days until our volunteer coordinator can send this email to induction attendees.

This is done through sending an email through CiviMail to a Smart Group. (We do it through CiviMail rather than through CiviEvent > Email all participants, because we want to see who opens the email and clicks on particular links).

The smart group has the following criteria:

 - Group(s) = Attended volunteer induction - last 7 days ...AND...
 - Group Status 'Added' ...AND...
 - Event Type = Volunteer Induction ...AND...
 - Start Date - greater than or equal to "4th July 2019 12.00 AM" ...AND...
 - End Date - less than or equal to "10th July 2019 11.59 PM" ...AND...
 - Participant Status (ID) In Attended ...AND...
 - Participant is not a Test

We use the start date and end date to only select people who have attended a volunteer induction in the last 7 days (the actual group criteria we've configured is "event date: last 7 days including today").

We haven't had a volunteer induction in the last 7 days, apart from a test one I've just made in which there is only one attendee (me).

However I'm seeing huge discrepancies between the number of contacts that should be in the smart group (1 - just me, since the only Volunteer Induction event in the last 7 days is a test one I just made) and the number of contacts that a mailing would be sent to, in CiviMail.

Contacts > Manage Groups

This page shows 32 contacts are in the group (wrong).

From that page: "Contacts"

Clicking the "Contacts" link on the aforementioned page/the above screenshot, again shows that there are 32 contacts in the group (wrong).

"Edit Smart Group Criteria"

Clicking the "Edit Smart Group Criteria" page takes me to a new search page that shows there is only one contact in the smart group (the correct number of contacts!). I didn't actually edit any of the criteria, I only clicked the button and it shows me the correct number.

CiviMail recipients

However when I go to CiviMail and select the smart group as the recipient, it shows that it will be sent to 31 recipients (??) rather than 1. Looking into the recipients list, the 1 contact that should actually be in the smart group based on the criteria IS in the group, plus another 30 that may have previously met the criteria but don't anymore (based on attendance date).

--

This is pretty perplexing, does anyone know what's happening here? As I mentioned, the extra contacts who are showing up in the group are contacts who previously met the smart group criteria but don't anymore (they attended a volunteer induction a couple months ago, not in the last week).

I do wonder if it's because the smart group is referencing itself... in the criteria I pasted in at the top of this post, the first line seems to imply that contacts who are in the smart group, are ...in the smart group. But in screenshot 3 (under "edit smart group criteria"), that first criteria isn't there any more.


texts: How do I format a webform to register for events so I can fill it out multiple times without cancelling previous registrations?

texts:
We are using a Webform to allow people to sign multiple people up for multiple events.

If someone has registered themselves for event A & B then later decided they want to go to event C & D as well, how would you set up a webform to allow a second submission that doesn't cancel the first registrations?

Currently if I revisit the form all the events are on offer, there is no indication of which events I am already registered for. If I fill in the form to register for C & D (having previously registered for A & B) and do not select A & B also then when I submit the form it cancels my registration for A & B.

If I am registering multiple people for events. eg person A registers person A and person B to go to lunch. Then person C registers person C and person B to go to dinner. Where lunch and dinner are both events that can be registered for on the same form then currently when person C completes the form person be will have their registration for lunch cancelled.

I am using Drupal 7.56, CiviCRM 4.7.27, Webform-CiviCRM 7.x-4.19


texts: Unable to run CRON for scheduled jobs in Drupal 7.43 and Civicrm 4.7.7

texts:
I have tried running a cron job in drupal 7.43 and civicrm 4.7.7 with no success. I have a scheduled job:
Home » CiviCRM » Administer CiviCRM » Scheduled Jobs (Send Scheduled Mailings) with setting Run frequency   "Every time cron job is run" (BTW the job runs if I use Execute now)(I have also set at 1 hour intervals)
In Drupal;
Home » Administration » Configuration » System > CRON it is set to run every hour and does so. I also can run it from the external URL.
When I run the Drupal CRON it has no effect on the Civicrm scheduled job and Civicrm complains each time I log in to Civicrm;
"Cron Not Running - Last cron run at May 16th, 2016 4:48 PM." which is the last time I executed it manually (Execute now).
I am doing this as administrator with all permissions.


texts:
Great timing as our rugby club is days away from the new season! After upgrading PHP and Civi the 'renew member' funcion seems to stall. It opens the details required but wont use the template confirmation we created. Just spins the triangle and one has to log out to cancel the operation.
Any one else had the same experience?
Cheers
Ian


texts:
I think I may have deleted a bunch of activities by accident. Here's what seems to have happened:

I had "Activity X" scheduled to occur every Saturday from 6/10/17 to 12/30/17
As 2017 rolled along, each Activity was customized as a stand-alone "just this one" edit week by week. This gave me lots of individual past activities as desired.
Because I needed to keep doing this through 3/31/18, I went to the entry for 12/30/17 and extended its "stop repeating" date to 3/31/18 and noted to apply only to this instance forward.
This preserved the 12/30/17 instance (correct), created the weekly activities through 3/31/18 (correct), but seems to have made all activities in the set prior to 12/30/17 disappear (ARRRGH)!

Any idea what may have gone wrong and how to recover? What I described above is actually the situation for about 300 activities all together (I just gave one example).

We use WordPress and latest Civi edition.
Thanks.

P.S. We may have a backup, but if this is a bug or something unclear, I want to be sure others know.


texts: How do I sort by Case Type Title instead of id in a Drupal View?

texts:
We frequently need to sort Drupal Views by Case Type.

It works, but sorts by id not the title field.

I believe it has to do with the pseudoconstant references in civicrm.case.inc and civicrm.core.inc.

I think that approach is fine except when it's time to sort and/or filter.

In Drupal Views, all exposed filters are sorted by id.  So when a user tries to filter by Case Type they get an unordered list of Case Types that to their eyes are in a very random order and is more difficult to use.

Same thing if I sort the overall view by case type.  Cases appear in non-alphabetical order and require a bit more concentration to digest them.

Is there a way to sort these fields in alphabetical order?


texts: Offline event registration Pay later option

texts:
I want to be able to offline register user, that will pay later.
If in 'Payment information' I set an amount of 0 and a 'Payment status' to 'pending', 'Participant Status' is always set to 'Partially paid' and not the status that I have set, when an confirmation and receipt is send by email.
If 'Send Confirmation and Receipt' is unchecked, 'Participant Status' is not changed, and only contribution status is set to Pending (Pay Later)

It should be nice to have a 'Pay later' checkbox so it's not mandatory to record an empty payment.

Is it possible?

Thank you for your help,

Olivier.


texts: Why do bcc: recipients show up in the headers?

texts:
I just noticed that anytime there is a bcc: recipient from a CiviCRM-generated email, the bcc: line shows up in the headers as though it was a regular cc: -- why is this?

Edit: It looks like this was a known issue at one point so maybe just never fully fixed, or a regression?

https://forum.civicrm.org/?topic=16686
https://issues.civicrm.org/jira/browse/CRM-7355


texts: "Total Fees" is blank on Event Registration Page

texts: Why is "Total Fees" blank on my event registration page? I checked for errors using firebug but there are no errors. The total does show on the confirmation page. I'm using Joomla version 3.6.5. and civicrm version 4.7.14


texts: How can I change a CiviEvent status using Webform Conditionals?

texts:
I am currently using Drupal 7.52, CiviCRM 4.6.24, and Webform 7.x-4.14

I have a CiviEvent where I want to register multiple registrations and a matrix of different combinations of payment levels and options. I am currently configuring a Webform where I have configured (at least in a draft form) for the CiviEvent participant fee to be passed to Stripe and the registration.

I also have the participant_status_id field exposed to the Webform; within CiviCRM processing I have the Event Registration > Registration Status set to * User Select * - I noted that if it was set to anything else then it would not be exposed in the Webform.

What I want to do is set the Registration Status using conditionals. So if the registration is paying using Stripe in full then set to Registered, or if paying by Cheque set to Pending from Pay Later.

The Webform Component allows me to select which CiviEvent status I want exposed to the form (I opted for Registered, Pending from Pay Later, Partial Payment), but I then can't set that using Conditionals. I also notice that when I can not set a Select Option webform component using Conditionals as well; maybe it is not possible?

I suspect my alternative would be a simple textfield, but I am looking for a better way.


texts: CRM_SMS_Page_Callback run method override

texts:
I am creating a new extension to add a new SMS provider. Since different parameters are passed during callback, I need to override run method of the CRM_SMS_Page_Callback class. Since it is a part of CRM Core, what is the best way to do it?

  sites/all/modules/civicrm/CRM/SMS/Page/Callback.php

class CRM_SMS_Page_Callback {

  public function run() {
    $provider = CRM_SMS_Provider::singleton($_REQUEST);

    if (array_key_exists('status', $_REQUEST)) {
      $provider->callback();
    }
    else {
      $provider->inbound();
    }
  }

}


texts:
Can someone explain to me step by step, please, how to create the multivalue fields illustrated in the User Guide under the title Multi-value fields in profiles? (It shows work experience list, but I wish to use it for something else. However I do not understand even how to create this work experience list!)
Thanks!
Mike Somorjay


texts: Is it possible to send an email when a person's birthday falls on a certain day of the week?

texts: I would like to configure Civi to email someone when a contact has a birthday on a certain day of the week (Sunday, in fact).  The only way I can see is to use CiviRules, but that seems to demand coding to set up the conditions and actions - which I don't want to do.  Using 4.7 but could use 4.6 if that's required. Can anyone help?


texts: Event registrant cancel/transfer error - getFieldValue failed - in SelfSvcUpdate.php

texts:
Here is backtrace:
0   CRM_Core_DAO::getFieldValue('CRM_Event_DAO_Ev…', null, 'title') /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm/CRM/Event/Form/SelfSvcUpdate.php:132
1   CRM_Event_Form_SelfSvcUpdate->preProcess()  /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php:602
2   CRM_Core_Form->buildForm()  /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php:76
3   CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Event_Form_SelfSvcUpdate), 'display') /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php:203
4   HTML_QuickForm_Controller->handle(Object(CRM_Event_Form_SelfSvcUpdate), 'display')  /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php:103
5   HTML_QuickForm_Page->handle('display')  /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php:347
6   CRM_Core_Controller->run()  /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Wrapper.php:98
7   CRM_Utils_Wrapper->run('CRM_Event_Form_S…', 'Self-service Reg…', Array) /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:285
8   CRM_Core_Invoke::runItem(Array) /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:68
9   CRM_Core_Invoke::_invoke(Array) /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:36
10  CRM_Core_Invoke::invoke(Array)  /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/civicrm.php:1644
11  CiviCRM_For_WordPress->invoke() /home/bbcadmin2016/public_html/wp-content/plugins/civicrm/includes/civicrm.basepage.php:352
12  CiviCRM_For_WordPress_Basepage->basepage_handler(Object(WP))    /home/bbcadmin2016/public_html/wp-includes/class-wp-hook.php:287
13  WP_Hook->apply_filters(null, Array) /home/bbcadmin2016/public_html/wp-includes/class-wp-hook.php:311
14  WP_Hook->do_action(Array)   /home/bbcadmin2016/public_html/wp-includes/plugin.php:544
15  do_action_ref_array('wp', Array)    /home/bbcadmin2016/public_html/wp-includes/class-wp.php:758
16  WP->main('')    /home/bbcadmin2016/public_html/wp-includes/functions.php:1285
17  wp()    /home/bbcadmin2016/public_html/wp-blog-header.php:16
18  require('/home/bbcadmin20…')    /home/bbcadmin2016/public_html/index.php:17
19  {main}


texts: In CiviEvents, on the Events Dashboard, can you change the column widths without doing custom code?

texts: Is there a way (without coding) to change the column widths on the Events Calendar view from the Events Dashboard? I am attaching an image of the page I am talking about. Also, I am using the most current version of Wordpress and CiviCRM.


texts: Submit credit card contribution error - configure live settings for payment processor

texts: Just upgraded to civicrm 4.7.24.  Tried to use the submit credit card contribution and get an error message telling me to configure live settings for payment processor.  I have been using credit cards for events pages and contribution pages for years.  They still work. I am using paypal standard.


texts: Invalid value for field(s) : field ID after moving the installation

texts:
I copied my CiviCRM installation into another machine. I imported all my old data successfully. I am able to see the old data in matching fields including data in custom fields.

I tried importing new set of data into the new machine. I am facing the error "Invalid value for field(s): field ID;"

Then I tried the same sheet on my old machine, where it works fine. My guess is it is something to do with custom fields.

Civicrm version :4.7.22
CMS : Wordpress 4.8.4 (old) 4.9.1 (new)
OS :  Windows 7 (old) Windows 10 (new)


texts: Migrating to Pantheon: How to make CiviMail editor insert images with non-relative refs?

texts:
When our site migrated to Pantheon, all the images in a mailing became broken when the mailing was received.

I saw this (https://stackoverflow.com/questions/27569280/civicrm-civimail-images-are-relative-urls) but the question is only partially answered.

I can't see any settings in the menu for the editor. How do I make the WYSIWYG editor for mailings provide absolute URL refs? Otherwise the images look fine in the preview but are all broken when the mailing is sent.

To clarify, the refs are coming out as "/sites/default/files/civicrm/image.jpg" instead of "http://mysite.com/sites/default/files/civicrm/image.jpg" and that is why they are broken.

Any help would be appreciated. Thanks!


texts: CiviCRM 5.31.0 Wordpress unable to change default language

texts:
I currently have CiviCRM 5.31.0 for Wordpress installed. I want to change the default language from EN_US to Dutch (NL). After a quick google i found a tutorial and did the following steps:

Downloaded to 5.31.0 language zip file
Uploaded all l10 and sql files to the correct folder
logged into wordpress and navigated to the 'administer' == 'localization' ==> 'Language & currency' page
I changed to default language to Dutch, turn 'Inherit CMS Language' on (Wordpress is also in Dutch) and hit save.
It loads, throws me back to the dashboard screen of CiviCRM and nothing translated...

I also tried translating the plugin using Loco Translate yet the translation file found by loco translate only contains 20 strings and not all text.
What am i doing wrong? Did i miss something?
Can someone maybe explain why it just ignores my save and keeps everything en-us? Is there a way to force CiviCRM to take a specific language or something?
Please let me know.
Kind regards,
Max


texts: How refund is possible for event participants in civicrm?

texts: I am using civicrm 4.6 in wordpress where users register for the events. We also want to allow users cancel their registrations and admin can refund them. We are using Stripe payment processor and participants make payment through credit card. Is their any in built feature to refund event participants? or how to integrate that?


texts: Tags, relationships, or custom fields to record custom data?

texts:
Apologies if this isn't the best place to ask, I'm completely new to CiviCRM and could do with some advice on the best way to store custom data.

I'm building a database of churches. For each church I want to record the denomination. Depending on the denomination, there are other details I also want to record. For example, for anglican churches I want to record the diocese, and for some dioceses I want to record further administrative subdivisions that churches belong to. But other denominations don't have those structures, and might have completely different ones. And some churches belong to more than one denomination, so might need the full structure details for two or even three of them.

As far as I can see there are three different ways I could organise that data:

Using custom fields. I could create a multiple record fieldset allowing me to record more than one denomination for each church. But then how would I store the different structures for the different denominations?
Using tags. I could create tags for every different level of every denomination in the database, so for example a church could be tagged with 'Anglican, Leeds Diocese, Bradford Episcopal Area'. But then the tags would exist for any contact in the database, not just churches, which could lead to a lot of clutter and confusion among users, particularly as the database grows.
Using relationships. I could create organisational contacts for denominations and dioceses, and then use a relationship to associate, e.g. X church is a member of Methodism, or Y church is a member of Southwalk Diocese which is a member of Anglicanism. But I think that will also be confusing for users, particularly when adding a church from a new diocese/denomination, and could lead to lots of shadow contacts that only exist for the purpose of categorisation rather than as actual contacts.

I'm leaning towards custom fields, but the only way I can see of getting the result I want would be to have a different contact type for each denomination, and then a fieldset for the relevant structural information on each contact type. Which would mean the denomination would have to be filled in by users in a box headed 'Contact Type' instead of a box headed 'Denomination', and that it would be mixed in with other non-church contact types.

What would be the best practice method?


texts: Make the Contact create API behave like UI in the way in checks for duplicates

texts:
I am creating a contact using CiviCRM API, what I have noticed that the duplicate checking looks inaccurate compared to the check done when entering new contacts via the User Interface.

Under the CiviCRM API, it's only a match if the given parameters are exactly the same like "John Smith of john@here.com" does not match "Johnathan Smith of john@here.com", for example, but in the UI, simply entering a matching e-mail address throws a warning.

Is there a way to make the CiviCRM API dupe check behave more like the UI  ?

I am passing the parameter dupe_check = true. The complete call is:

$result = civicrm_api3('Contact', 'create',
          array( 'sequential' => 1,
                 'contact_type' => "Individual",
                 'first_name' => "raj",
                 'last_name' => "l",
                 'dupe_check' => 1,
                 'api.Email.create' => array('email' => "raj@abc.com"), )
           );


texts: Why does Sourceforge not have the 4.6.5 files?

texts: Sourceforge shows the latest release 4.6.5 for Drupal 7 but the files are 'not found' if you try to download them.  Also Sourceforge shows the headline latest release to be 4.6.4.  What's going on?


texts: Has anyone had any success integrating CiviCRM into Craft CMS?

texts:
We have a potential client whose site is currently using CiviCRM and Drupal. They are interested in using Craft CMS. I've researched other CRM plugins for Craft similar to CiviCRM but they do not exist. We would like to stay with CiviCRM but has anyone had any success integrating the two?
Thanks
S.


texts: After upgrade to 4.7, Activity dashlet and Activity list in Contact not showing any activites

texts:
I'm still having this issue and I've upgraded to 4.7.2. I've searched everywhere and can't find a cause. I'm not getting any error the activities just don't show in the list.

I upgraded to 4.7 without any issues. The Activity dashlet doesn't show any activities nor do activities show under the contact tab. I did a search a found there was some error causing this and it was marked as fixed. It was related to running php 5.3 but I'm running php 5.5.29 on civihosting.

What's causing this?

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

I do not get a datatables error. I get no error at all. If you look at the screen grab, notice it says, Showing 1 to 11 of 11 entries but no activities are showing.

Also see the screen grab for the Activities tab in the Contact.


texts: Incorrect Month To Date in member dashboard

texts:
Member Dashboard shows following headings

October – (Last Month)  March (MTD) 2018 (YTD)

Obviously the month to date heading should be "November" rather than "March".

Where is civicrm getting its current month from?


texts: Custom data fields not showing on event registration page

texts: I setup a custom field to be used for Participant (Event Name) and it only shows when I choose to manually register someone, it DOES NOT show on the event registration page, is there a setting I'm missing somewhere?


texts: CiviCRM >> Administer CiviCRM >> Profiles is blank

texts:
When I go to CiviCRM >> Administer CiviCRM >> Profiles it is blank.  How do I correct this?

I am running CivCRM 4.7.22 on Joomla 3.6.4.  I have cleared caches and rebuilt the menu.  There are no javascript errors in console.  I can add profiles when I edit contribution pages.  I can edit and create profiles when setting up contribution pages.  I need to go to CiviCRM >> Administer CiviCRM >> Profiles because according to my research that is where the settings are to add reCaptcha to profiles.

UPDATE:  There are not any errors (404 or otherwise) in the Network tab of the browser dev tools.  Below is an image of what I mean by blank.


texts: no modification for data fied in civiEvent

texts:
We have just activated our CiviEvent module.
We propose for registred users
to use their own information or register other participant
But we don't want they can change their name (caps are important for exemple), mail or other fields.
How is it possible?

Best

Nicolas


texts:
Civicrm 4.7.22 on Wordpress.

Hello,
I copied and pasted the below link into the HTML format area of the scheduled reminders for renewing memberships.  I changed the "myorganization" part to my own domain.  When I click it in the email it will not load a page and even said "Too many redirects".  Am I using this link wrong?  What is the right way to link to the renewal page?

http://www.myorganization.org/?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=N&{contact.checksum}&cid={contact.contact_id}

Thank you.

***UPDATE****
The link issue has been resolved. It now works. However, it links to the home page where the header widget and sidebar are visible. I would rather have it linked to a different page where none of that distracting information is visible.  How do I do that?  I don't see an option for overriding the page with the renewal form when I create a new page in wordpress.

****UPDATE***
I resolved the problem. Simply change
myorganization.org/?page=CiviCRM&q=civicrm/contribute/…;{contact.checksum}&cid={contact.contact_id}

to

myorganization.org/civicrm/?page=CiviCRM&q=civicrm/…;{contact.checksum}&cid={contact.contact_id} or whatever url you want the renewal form to appear in.


texts: CiviCRM reports Cron not running, but my web host is adamant that it is

texts:
I'm using the cli.php method to run cron as described in the System Administrator Guide.

I am able to run this command from ssh, and it seems to execute fine:

php /var/sites/c/<mydomain>/public_html/sites/all/modules/civicrm/bin/cli.php -s <mydomain> -u <mydrupalusername> -p <mydrupalpassword> -e Job -a execute

Immediately after running that CiviCRM's System Status page will be updated with the time it ran.

However, when I use my host's control panel to run that every 15 minutes, nothing seems to happen, and the CiviCRM status page eventually returns to saying 'Cron not running'.

The advanced view of my host's control panel, which supposedly lets me edit the raw crontab, shows the following line:

*/15 * * * * php /var/sites/c/<mydomain>/public_html/sites/all/modules/civicrm/bin/cli.php -s <mydomain> -u <mydrupalusername> -p <mydrupalpassword> -e Job -a execute

But nothing is happening at the 15 minute intervals. CiviCRM's status page doesn't update. I have the CiviCRM Update Check set to always run as well, and that doesn't update on the scheduled jobs settings page either.

I've spoken to my host's support, and they insist that it is running the command every 15 minutes, and that it should be doing it with the same rights and in the same location as it does when I run it manually via ssh.

The host's logs that I can see via the control panel update every 15 minutes with this line:

Jul 17 12:45:24 cron2-lxc crond[107640]: (<myhostingusername>) CMD (php /var/sites/c/<mydomain>/public_html/sites/all/modules/civicrm/bin/cli.php -s <mydomain> -u <mydrupalusername> -p <mydrupalpassword> -e Job -a execute)

What's going wrong?


texts:
I am trying to set custom fields in a Custom Group. Here is my code:

function dfi_civicrm_buildForm($formName, &$form) {
  if ($formName == 'CustomData') {
    if ($form->getAction() == CRM_Core_Action::ADD) {
      echo 'Hello World';
      $defaults['custom_160_-5'] = mt_rand();
      $defaults['custom_70_-5'] = '23/10/2019';
      $form->setDefaults($defaults);
    }
  }
}

I have added it as an extension. It is not working even the Hello World isn't showing.

Thanks


texts: Issue creating Premium - requiring subscription

texts:
When trying to add a new Premium (first one), I get the error "Please enter a Period Type" - even though the premium is a regular "product" and not a subscription.
Civi 5.31 / Drupal 7.73 / PHP 7.3


texts: What are the optimal settings to enable a Drupal webform to create a case and populate an activity within the case?

texts:
I have a case configuration that includes a specific activity type (lets call it activity type A) in the standard timeline. This is useful for users who want to create and manage a case directly within CiviCRM, as it ensures that important activities are set up in the case for them.

I have a Drupal webform for users who don't have Civi access to enable them to create a case and populate an instance of activity type A within the case.

The webform is set up such that case processing is turned on and a new case of the required type is created. Activity processing is turned on, and activity type A is set up within the webform such that an existing activity of scheduled status gets updated, and that activity is filed on the case that is created by the webform.

My assumption with this configuration is that as the form submission gets processed, the case (complete with its default scheduled instance of activity type A) is created, and the submission data is used to populate that activity record.

However, what appears to be happening is that the case is being created, and a new activity (type A) is also being created and populated, and filed on the case, such that the resulting case has two instances of activity type A (one populated with my data, and a second, empty one - presumably the default instance created when the case was created.

So, given that I don't want to remove the instance of activity type A defined in the standard timeline of the case configuration, how can I alter the settings within the webform such that the webform identifies and populates this activity rather than making a new one?


texts:
We are creating a directory of programs and we thought that using CiviMember would be the best way to approach it. Mainly because many of the programs are housed at other organizations/departments and we would want them to submit to the directory. We decided that the programs would register their programs as organizational members.

One website that uses Civi and is an example of what we are trying to accomplish (partly) is https://www.escr-net.org/members - Instead of Region and Workgroup, we would have something like Category and Age Group, or something along those lines, using custom fields. Similar to the ESCR directory, as a visitor to our site, you would be able to search and click to learn more about the different members.

We also thought membership would be a good approach as we can set expiration dates and have programs update their information when they renew their membership.

Is membership the right approach for what we want to do or is their a better option.  Maybe CiviVolunteer?

Using Drupal 7 and Civi 5

Clarification on Programs
This is a University Office that is seeking to list all the public programs that other university offices and departments offer.

We also want each department to submit a public program profile, that we will request to be updated yearly. Some of that info will be public, the rest will be private.

Side note:
We know we are going to have to work with a consultant to get this working the way we want it, but we wanted to see what the possibilities were, esp since we have seen other CiviCRM orgs do similar.


texts: Automatically transferring info from Casenote to indivudial client form

texts:
How do I automatically populate the individual contact form with information from the case note (civicase)? I'm using Wordpress.

I'm using civicases for our intake sheets and I've chosen that because I want a single computer form to take the information down. I know I can use profiles new individual to populate the client information but I need some information in both the case note and the client form.
I'm looking for a way to automatically include the information,which is collected through custom fields into the newly created individual and to do the reverse if the client calls back (i.e that info collected automatically populates into the case note).

any advice?


texts:
I have a custom field of an individual that stores the ID of a group (as int). I would like to change the display of the field to show the actual name of the group instead of the ID (same as contact reference functionality).

At the very least I would like to have this done on the contact summary page.

I have tried hook_civicrm_alterContent, but I am unsure how to change the actual displayed field value.

NOTE: I am able to get it to work by adding some javascript to the hook using jQuery to alter the value. This seems very hacked and getting the proper field is difficult because Civi does not sent distinct ids or classes for the fields being displayed. Something as simple as changing the display order of the fields would break it.


texts: How does using CiviCRM compare to using NationBuilder?

texts: Have you used or tried out NationBuilder.com, a US-based commercial not-free CRM used for political and community advocacy? What does CiviCRM do better, or worse? I prefer Civi but looking for more evidence for comparisons and info about experiences of those who've used both Civi and NationBuilder. Thanks!


texts:
I am trying to be a more conforming civicrm coder.

Smarty used by civicrm for pages (and forms?)

I have never used Smarty.. Is it going to be part of civicrm going forward? And are there any tips for writing good future proof smarty?


texts: Installation Issue - Database Triggers not allowed by hosting provider

texts:
After spending 3 months configuring and testing CiviCRM on a locally hosted/internal server (and being suitably impressed), I attempted to install onto our website which is hosted with GoDaddy.

I kept running into an error that prevented CiviCRM from installing being that I am unable to install triggers on the DB due to permissions in a shared server environment.

I appear to have 2 options:
1 - fork out more $$$ to get a dedicated server or VPS.  Not possible.

2 - Move from GoDaddy to HostGator who claim to allow triggers. "We can enable trigger privileges for your database, simply contact us via phone or Live Chat with the database, database user, and the tables that you require the permissions on."

Can anyone provide a list of tables that require the trigger permissions added please?

Or provide an alternate hosting solution/suggestion, noting that the organisation is a Not For Profit based in Nepal and not able to spend much money on a solution.

Thanks, Joe.


texts:
[Tue Jul 12 21:36:24.720900 2016] [access_compat:error] [pid 5387] [client 192.158.31.162:44948] AH01797: client denied by server configuration: /var/www/XXX/sites/def
ault/files/civicrm/custom/delete-this-yeIAcdkLVh

Hi

I'm getting this in my apache logs when trying to delete some custom data fields left over from a bad extension installation. On screen it spins forever when trying to delete.

Anyone know where to start troubleshooting?

Thanks


texts: Extension install failed, now cant get the functions to work or reinstall successfully. How to fix please?

texts:
I am on CiviCRM 4.7, Php 5.6, drupal 7. When installing GDPR extension, it failed. After that whenever I try to uninstall and reinstall, CiviCRM shows error "Found Name, activity_type, civicrm_option_group". Nothing happens after that. GDPR settings menu or manually not accessible. A custom data group is created for contacts but when clicked it shows error message "Unable to reach server, Please refresh this page on your browser and try again".

I have tried manually removing the custom data using sql that was in the extension. but no luck. How can i resolve this please?


texts: Which civicrm hook for Event Registration form field content change in Drupal module?

texts:
Preamble:

Event Registration Settings form ( civicrm/event/manage/settings?reset=1&action=update&id=EVENT-ID ) has separated text areas for Event Summary/Description ( "Info and Settings" tab) and Introductory Text ( Online Registration tab ).

We'd like to use both  at Online Registration Form (civicrm/event/register?id=EVENT-ID&reset=1) or only Event Summary/Description  in order to eliminate same text copy&paste twice for both "description" fields.

Assuming one of civicrm hooks in a custom Drupal module  can be used, just more convenient than custom template creation

Code

Something like this

if($formName == 'CRM_Event_Form_Registration_Register') {
  $form->_values['event']['intro_text'] =  $form->_values['event']['description'];
}

Problem

There are hooks which, according to descriptions, must execute the below code but somehow it doesn't work:

hook_civicrm_preProcess
hook__civicrm_buildForm

There are also hook_civicrm_alterContent (which can do str_replace inside given text) and hook_civicrm_alterTemplateFile (which can help in TPL file substitution somehow), yet both aren't suitable for the situation.

Question

Any chance hook_civicrm_preProcess/hook__civicrm_buildForm can be used or custom copy of civicrm\templates\CRM\Event\Form\Registration\Register.tpl alter is the only option here?

Thanks!

P.S. There are some related discussions regarding these hooks here;
unfortunately solutions proposed do not work somehow.


texts: How to configure authorize.net payment processor to use another currency

texts:
Authorize.net itself boosts it supports multiple currencies:
https://community.developer.authorize.net/t5/The-Authorize-Net-Developer-Blog/Authorize-Net-Expansion-into-Canada-the-United-Kingdom-and/ba-p/33690

The list of payment processors shows a 'blank' when it comes to regional support for the Authorize.net payment processor:
https://wiki.civicrm.org/confluence/display/CRMDOC/Payment+Processors

Elsewhere on stackexchange, someone explains how to support other currencies
https://stackoverflow.com/questions/16014643/does-authorize-net-support-different-currency-types/16031041#16031041

Could that apply to CiviCRM too ? Is it just not implemented yet ?

Somehow, we always use US$. The message above says

  If you’re not sending the currency code, or if you’re using any of our
  other Authorize.Net APIs, no changes are required at this time. The
  currency code for those APIs will automatically default to the
  currency associated with the merchant’s processor.

What does that mean - could we change the option to euro at the merchant interface ?


texts: Baffled by Views database error on new install

texts:
Hours-old install of CiviCRM 5.25 under Backdrop 1.9. I've gotten as far as putting in the Board of Directors with dummy bio information, which I was trying to use to generate a View with a page display of names and bios. I get this, with various permutations of what table doesn't exist depending on what I'm doing:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'B1.civicrm_uf_match' doesn't exist

Both Backdrop and CiviCRM are using the same mysql user "B1", who has GRANT ALL permissions on the B1 and C5 tables. Obviously, the data is still there when I go back to review it in the Civi interface. What to check next?


texts: CiviCRM and WordPress User Groups and Permissions

texts:
We are trying to set-up user accounts for use on both our WordPress club website and CiviCRM but just can't figure out how to get the permissions piece to work.

The "CiviCRM WordPress Member Sync" plugin has allowed us to create the user accounts and sync between the two systems for about 80-90% of our members, so that is now working. What we can't figure out is how to set the WordPress permissions to be based off of CiviCRM groups (WordPress uses Roles/Responsibilities).

We acquired a few plugins called "Press Permit Core" and "Capability Manager Enhanced" thinking they would help, but it hasn't. It shouldn't be this difficult to manage user groups and security from CiviCRM to WordPress. Any guidance that you can provide is deeply appreciated.


texts: Recurring payments being set to pending - Stripe

texts:
I've inherited a CiviCRM 5.21.0 install on Wordpress, using Stripe to process membership payments. When a member chooses the "recurring payment" option on signup (Please renew my membership automatically), CiviCRM doesn't accept that as paid and doesn't add them as members. Instead they are listed as

Pending (Incomplete Transaction)

Non-recurring memberships are entered without a problem.

Any help appreciated.


texts:
I have created a webform with a single contact and am using it to renew a membership. The process appears to complete successfully however when I look at the contribution in the contact's record I can edit the contribution but if I try to 'view' the contribution I get an error:
Unable to reach the server. Please refresh this page in your browser and try again.

If I try to view the contribution in the webform results I get this error:

CiviCRM_API3_Exception: "Expected one PriceSet but found 25"

#0 /var/www/html/sites/all/modules/civicrm/CRM/Contribute/Form/ContributionView.php(158): civicrm_api3("PriceSet", "getsingle", (Array:2))
#1 /var/www/html/sites/all/modules/civicrm/CRM/Core/Form.php(531): CRM_Contribute_Form_ContributionView->preProcess()
#2 /var/www/html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(92): CRM_Core_Form->buildForm()
#3 /var/www/html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Contribute_Form_ContributionView), "display")
#4 /var/www/html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contribute_Form_ContributionView), "display")
#5 /var/www/html/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("display")
#6 /var/www/html/sites/all/modules/civicrm/CRM/Contribute/Page/Tab.php(214): CRM_Core_Controller->run()
#7 /var/www/html/sites/all/modules/civicrm/CRM/Contribute/Page/Tab.php(286): CRM_Contribute_Page_Tab->view()
#8 /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php(310): CRM_Contribute_Page_Tab->run((Array:4), NULL)
#9 /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:13))
#10 /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#11 /var/www/html/sites/all/modules/civicrm/drupal/civicrm.module(448): CRM_Core_Invoke::invoke((Array:4))
#12 [internal function](): civicrm_invoke("contact", "view", "contribution")
#13 /var/www/html/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:3))
#14 /var/www/html/index.php(20): menu_execute_active_handler()
#15 {main}

Updated with backtrace
$backTrace = #0

0 /var/www/html/sites/all/modules/civicrm/CRM/Core/Error.php(451): CRM_Core_Error::backtrace("backTrace", TRUE)
1 /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php(55): CRM_Core_Error::handleUnhandledException(Object(CiviCRM_API3_Exception))
2 /var/www/html/sites/all/modules/civicrm/drupal/civicrm.module(448): CRM_Core_Invoke::invoke((Array:4))
3 internal function: civicrm_invoke("contact", "view", "contribution")
4 /var/www/html/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:3))
5 /var/www/html/index.php(20): menu_execute_active_handler()
6 {main}


texts: Can I batch update participant role for an event for all contacts registered for an event who have a certain tag?

texts:
The scenario is this:
I have an event -- we'll call it "Meeting." There are 200 contacts registered for "Meeting." All 100 have the participant role "attendee." 60 of the contacts who are registered for "meeting" are tagged as "meeting speaker." I would like to batch update so that all 60 contacts with the "meeting speaker" tag have their participant role switched to "speaker" instead of "attendee."

If I do a contact search, I can isolate the tagged participants, but not update their participant roles. It won't let me add them to the event as they are already registered.

On the other hand, if I do a participant search I can batch update registration status, but not search only registrants who have the tag.

Am I missing something or is this just not doable? I'd really rather not manually change all 60 statuses.


texts: Does CiviCRM VERP work with a mailbox on Microsoft Small Business Server 2011?

texts: If an organization is using Microsoft SBS 2011, can they configure it to support Variable Envelope Return Path (VERP) for the required CiviMail mailbox(es)? What implications will this have on bounce handling if not?


texts: Is unicode not supported in clickatell SMS extension?

texts:
I have CiviCRM 5.13 on Drupal7 with the clickatell v4.1 extension for SMS. Clickatell integration works, I can send test SMS via HTTPS from the browser to test phones. Database and environment is set to UTF-8.

However, if a mass SMS is compiled in https://example.com/civicrm/sms/send?reset=1, or a direct SMS is sent, the non-English characters, like é,á,... are lost or transformed in the SMS body. If the same text is sent over HTTPS/curl directly to Clickatell, there is no such issue.

Is it a CiviCRM issue, or a misconfiguration on my side? How can I track it down?


texts: What can I do about this error after attempting to install CiviCRM on a Wordpress site: Table 'myprefix_civicrm.civicrm_setting' doesn't exist

texts:
My attempt to install CiviCRM on a WordPress site (in a separate database) failed after creating only one table in the database. I didn't record the error, thinking I could just delete the database and the files from the Plugins folder, then run things again. After recreating an empty INNODB database and re-extracting the files into the plugins directory, when I go to Plugins.php and click Activate, I get the following error:
Initialization Error
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => simpleHandler
        )

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id
FROM civicrm_setting
WHERE (domain_id = 1) AND (is_domain = 1)
 [nativecode=1146 ** Table 'myprefix_civicrm.civicrm_setting' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id
FROM civicrm_setting
WHERE (domain_id = 1) AND (is_domain = 1)
     [nativecode=1146 ** Table 'myprefix_civicrm.civicrm_setting' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info="SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id
FROM civicrm_setting
WHERE (domain_id = 1) AND (is_domain = 1)
 [nativecode=1146 ** Table 'myprefix_civicrm.civicrm_setting' doesn't exist]"]
)

The only way to get rid of it is to rename the Plugins folder Plugins.Hold, then revisit the plugins page. However, as soon as I rename the folder back and click Activate again, I get the same error.
I don't have any caching plugins on the site.


texts: "participant listing options" how to add another option with more fields

texts:
The existing options are
name only
name and email
name, status and register date

How do i add an option with more fields eg role, phone etc is it a template somewhere?


texts: Strange php error after updating old view

texts:
As part of our migration to latest civi for numerous sites, we had to make an adjustment to a drupal calendar views on the existing, live older civi site (4.0.5).

(We're upgrading all sites to 5.12 - need to keep this site online until go live.)

After running latest php upgrades on the drupal dbase and modules we lost calendar event view display. We attempted to get civievents to display on the calendar, weren't successful, then decided to create events as drupal content type "Event Data" as a workaround.

We tested and re-created about 70 such civievents as content type "Event Data."

All seemed fine and working at that point. Every event data type showed on the calendar and we considered the issue solved.

A short time later we received support indicating the site was no longer letting the site admins log-in - at all.

We are now locked out of the site completely, e;.g. each time we attempt to log in -or access anything civi related on the site - we see the error. The drupal pages all display.

Error reporting shows the following :

E_ERROR Error in file ?civicrm_entity.module? at line 499: Call to undefined method CRM_Utils_Hook::singleton()

We've tried nearly everything, disabling civicrm_entity, related modules, civicrm entirely, and still cannot log in. We only saw this after adjusting the view, all else seemed okay after running the upgrades.

Any ideas on how to fix - or at least what to disable - to bring the site back or at least restore the admin log in?

We should be able to restore an older version but the same issue we thought we had solved with the calendar will likely reappear. Admittedly that's better than no access, but still the calendar issue.

Updating with common backtrace errors from the Config Logs :

Apr 19 10:58:35  [info] $backTrace =
 site.com/web/sites/all/modules/civicrm/CRM/Core/Error.php,
 backtrace, 303
 site.com/web/sites/all/modules/civicrm/CRM/Core/BAO/UFGroup.php,
 fatal, 482
 site.com/web/sites/all/modules/civicrm/CRM/Core/BAO/UFGroup.php,
 getFields, 236
 site.com/web/sites/all/modules/civicrm/CRM/Profile/Page/Listings.php,
 getListingFields, 155
 site.com/web/sites/all/modules/civicrm/CRM/Profile/Page/Listings.php,
 preProcess, 256
 site.com/web/sites/all/modules/civicrm/CRM/Core/Invoke.php,
 run, 348
 , profile,
 site.com/web/sites/all/modules/civicrm/CRM/Core/Invoke.php,
 call_user_func, 191
 site.com/web/sites/all/modules/civicrm/drupal/civicrm.module,
 invoke, 443
 , civicrm_invoke,
 /usr/local/share/drupal-7.66/includes/menu.inc, call_user_func_array, 527
 site.com/web/index.php,
 menu_execute_active_handler, 27

Running Drupal 7.66

Any assistance appreciated...
H


texts: How to send Amazon SES bounce notifcation emails to civiCRM bounce processing email address?

texts:
I'm trying to follow the helpful guide here on setting up Amazon SES

https://www.compucorp.co.uk/node/1740

All working well apart from bounce handling.  Amazon SES by default seems to send bounce notifications back to the sending email address.

How to send from members@site.com and get bounce notifcations to bounce@site.com using Amazon SES?


texts: civicrmHooks.php no longer invoked under Joomla and CiviCRM 4.7.20

texts:
This is related to Invoking hook_custom_tokens and hook_custom_tokenValues in Joomla which used to work.  It has now appeared to have stopped working which means that the custom tokens handled by civicrmHooks.php are no longer available.  It looks as though civicrmHooks.php is no longer being invoked, as deliberately introducing an error does not result in CiviCRM crashing.

What has changed recently.  How can we solve this?


texts: How to create a Drupal rules condition that checks CiviCRM contact's Group or Tag or Subtype

texts:
Using Drupal Workflow Rules with CiviCRM Entity to create a Drupal User after a new Civi contact is created.

Rule works fine if the only condition is that a new Drupal user can be created for the Civi contact.

I need to add an additional condition to limit the creation of the new Drupal user according to other criteria.  Examples might be group membership or a Civi tag or certain Civi contact subtypes.

here is the rule that is not working:

{ "rules_testnewcontact" : {
    "LABEL" : "TestNewContact",
    "PLUGIN" : "reaction rule",
    "OWNER" : "rules",
    "REQUIRES" : [ "civicrm", "rules" ],
    "ON" : { "civicrm_contact_create" : [] },
    "IF" : [
      { "civicrm_entity_user_exists_or_creatable" : { "civicrm_contact" : [ "civicrm_contact" ] } },
      { "NOT text_matches" : { "text" : [ "civicrm-contact:contact-sub-type" ], "match" : "Client" } }
    ],
    "DO" : [
      { "civicrm_entity_action_load_create_user" : {
          "USING" : {
            "civicrm_contact" : [ "civicrm_contact" ],
            "is_active" : "1",
            "notify" : "1"
          },
          "PROVIDE" : { "civicrm_user" : { "civicrm_user" : "Created or Loaded Drupal User" } }
        }
      }
    ]
  }
}


texts:
I've switched hosts and the new host's smtp server seems to be rejecting the email I'm trying to send to a group.  It can me 2 or 2000 people with the same response.  Apparently it does not like the auto generated sender email address?  Anyone have that issue and go I d a solution?  CiviCRM on WordPress. Both very recent versions.

2017-09-22 16:30:04 [4342] H=(www.sportingdetectiondogs.ca) [184.154.247.100]:33676 I=[184.154.247.116]:25 X=TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128 CV=no SNI="sportingdetectiondogs.ca" F= A=dovecot_login:civicrm@sportingdetectiondogs.ca rejected RCPT : SITEGROUND: b.304.14831.47c90fe51b65dc14@sportingdetectiondogs.ca is not a valid address: Sender verify failed: Sender verify failed
2017-09-22 16:40:04 [48178] H=(www.sportingdetectiondogs.ca) [184.154.247.100]:42556 I=[184.154.247.116]:25 Warning: SITEGROUND: Message from 184.154.247.100. Normal SMTP auth with civicrm@sportingdetectiondogs.ca system user: sporti62
2017-09-22 16:40:04 [48178] H=(www.sportingdetectiondogs.ca) [184.154.247.100]:42556 I=[184.154.247.116]:25 X=TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128 CV=no SNI="sportingdetectiondogs.ca" F= A=dovecot_login:civicrm@sportingdetectiondogs.ca rejected RCPT : SITEGROUND: b.304.14832.46cd2e439db32d78@sportingdetectiondogs.ca is not a valid address: Sender verify failed: Sender verify failed
2017-09-22 18:45:24 [26529] H=(www.sportingdetectiondogs.ca) [77.104.151.189]:51718 I=[77.104.151.189]:465 Warning: SITEGROUND: Message from 77.104.151.189. Normal SMTP auth with civicrm@sportingdetectiondogs.ca system user: sporti62
2017-09-22 18:45:24 [26529] 1dvXdM-0006tt-Ja <= info@sportingdetectiondogs.ca H=(www.sportingdetectiondogs.ca) [77.104.151.189]:51718 I=[77.104.151.189]:465 P=esmtpsa X=TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128 CV=no SNI="usm31.siteground.biz" A=dovecot_login:civicrm@sportingdetectiondogs.ca S=565 M8S=0 T="Test for SMTP settings" from  for support@siteground.com
support@support.com [~]#


texts: How to resolve error: "Recurring contribution, but no database id"?

texts:
When processing a new recurring membership, with the "Please renew my membership automatically" option enabled, we get the following error:

  Sorry but we are not able to provide this at the moment.

  Recurring contribution, but no database id

What can we do to troubleshoot/resolve this issue?

Temporary fix

As a temporary fix, we set the Membership Type Auto-renew Option value to No auto-renew option. Now, we can process memberships, but those memberships can not auto-renew.

We would like for members to have the option to auto-renew their membership.

Environment

Drupal 7.x
CiviCRM 4.7.x
MySQL


texts: Can you create a dedupe rule to include individual and organisation details

texts:
Following recent Events/bookings we have found several duplicate organisations have been created.  We used the Name and Email (reserved) Supervised dedup rule and while duplicate individuals have not been created we now have many duplicated organisations.

Any assistance with this issue would be most appreciated as we are due to launch another event which will probably have well over 100 bookings.

Thank you
Allison

Hi Allison

Does the settings for the Organisation Name field look like this?


texts: Displaying long CiviCRM multi select fields in a Drupal Webform

texts:
We have a circumstance where we have a multi select custom field with around 200 options. We then have this field loaded into a Drupal webform (for this project we need to use Webforms).

The standard Drupal Webform field options only allow either a CTRL click multi select or radio buttons, neither of which will work with that many options.

We have also tried a module called Chosen (https://www.drupal.org/project/chosen) but have failed to get this to work with the Webform. Has anyone got any experience of getting Chosen working with Webforms or an alternative approach?

Oliver


texts: How would I expose weight for a custom select field to Drupal Views for sorting?

texts:
I have a custom select option field with about 35 options.
I'd like to be able to sort the field in Drupal Views by weight instead of value or name.
I looked around for the views integration in the core files but couldn't find the section that exposes custom field option groups to views.
I would assume that it is in all/modules/civicrm/drupal/modules/views/components/civicrm.core.inc but I don't see any mention there.
Custom option groups appear to be exposed in all/modules/civicrm/drupal/modules/views/civicrm.views.inc but I don't see any mention of the option_value table to add the weight column.
Any suggestions on how to expose the weight of individual custom select options in Views?
Thank you!


texts:
After upgrading from version 5.24.1 to 5.24.4 (Joomla) i get the

  System Status: Critical File
  'C:\wamp\www\Joomla\administrator\components\com_civicrm\civicrm\bower_components/google-code-prettify/styles/demo.html'
  presents a security risk and should be deleted. Same for:
  C:\wamp\www\Joomla\administrator\components\com_civicrm\civicrm\bower_components/qunit/addons

Can I remove these files?


texts: Advanced Search Using Custom Profile as Display View that Includes Groups Not Working after Upgrading to 5.9.0

texts:
After upgrading Civi from 5.3.1 to 5.9.0 (with drupal 7.61) any search results that use a custom display view (profile) does not work properly if that profile includes the groups or tags fields in the profile. Instead of the advanced search displaying all the records found it only displays one record at a time. At the top it may say "showing 1 to 50 of 100 records", but actually only shows one record.

I also hadn't realised that before upgrading, the groups or tags fields had not displayed at all in the advanced search - those columns would be missing even though they were included in the profile.

Is it possible to include groups or tags fields in a profile used for search results?

Disabling or deleting the groups/tags fields from the profile fixes the problem of only showing one contact at a time in the search results.

Screenshot attached


texts: Our dashboard reports are inaccurate - caching issue?

texts:
We have a number of dashlets set up for various users to monitor what's going in in CiviCRM.  Sometimes data is missing though.  We run the report the dashlet is based on, and the data does show up there.  Afterwards, it shows up on the dashboard too.  Smells like a caching issue to me.

What is the best way to deal with this?  Is CiviCRM caching strictly controlled by the CMS (Drupal in our case)?  I have just set a maximum value for cache life; it was "none" before.


texts: List Parents of Children having certain values

texts: Is there a way to query the Custom Fields on a Child and then show their Parent's detials? Scenario: email all parents whose children attend a certain class.


texts:
I have a few test events I registered a single user for. I then removed the single user from all the events but when I go to delete the event I get a message the event still has participants. There are no participants when I do a search. It appears to be some sort of bug. How do I force delete the event? Is there a way to get rid of it via MySQL if the GUI won't comply?

CiviCRM 4.6.9
Drupal 7.41

Thanks


texts: CiviSEPA turns special characters of generated XML files into ASCII characters or question marks

texts:
I have noticed that when using CiviSEPA to generate an XML file to be submitted to the bank for payment collection, no special characters get through. Some characters are converted into ASCII "equivalent" characters and some others into question marks ?.

I am using UTF-8 within CiviCRM. Also, the XML file generated starts with:

<?xml version="1.0" encoding="UTF-8"?>

So the XML file encoding seems to be capable of using UTF-8 characters. Some examples:

Name       | Turns into
---------- | ----------
Mónica     | Monica
Begoña     | Begona
Mª Dolores | M? Dolores

This seems to be a "feature" as some conversions seem to be getting the "closest" ASCII equivalent. But then the Transaction Message seems to be getting a worse treatment: La fundación le agradece su aportación turns into La fundaci??n le agradece su aportaci??n.

I have tried generating XML files mostly with the pain.008.001.02 PAIN version but it seems to be the same for the other PAIN versions.

So I would like to know whether the XML files may contain any UTF-8 characters (and the average bank will accept that). If this is so, do I have something wrong in the CiviCRM configuration? Is there a way to fix this?


texts: How are CiviMail VERP tracking addresses contructed?

texts:
The CiviMail reply and bounce tracking VERP addresses seem to include multiple + signs in the address.
Eg. donotreply+r+21+21+ae1dc2b1ec827788@ , donotreply+ being the localpart
Office 365 now supports plus addressing (https://www.microsoft.com/en-US/microsoft-365/roadmap?filters=&searchterms=59441), which works with a single + character in the address, but addresses with multiple + characters are rejected (unknown address).
Is there a way to change the generated string to not include the extra + signs?
Edit - Had missed a CiviMail setting. VERP separator character can be specified at /civicrm/admin/mail?reset=1
The breakdown of VERP address is detailed in an answer to another question: https://civicrm.stackexchange.com/a/2327/2266


texts: Separate sites for CiviCRM and public site?

texts:
Is there a best practice as to whether CiviCRM should be installed on its own site, seperate from the public site or as part of the public site?

I think of our internal users doing mailings etc and it doesn’t “feel right” for them to do this on  the CMS for our public-facing site, but at the same time we want to allow self-service contributions and event registrations.

Is there any issue to link across sites (for example link public site to membership form served on CiviCRM)? Or is that just a pain.

I’m afraid to just go ahead and install CiviCRM on our production public site. We use WP fwiw.

Appreciate any advice.


texts:
When I search Contributions/Find Contributions and specify the current year date range and a specific campaign, I receive the following error "Sorry but we are not able to provide this at the moment. DB Error: syntax error  Return to home page."  How do I get campaign related contributions?
I cannot reproduce this error on the Demo site. Seems to work fine there.
When I produce a Summary Contribution Report grouped by Campaign I receive what at first to be a valid Report showing Contributions by Campaign, when I open the Detail Report for the Campaign Contribution in question, it shows many Contributions totally unrelated to the Campaign.


texts: MySQL Tuning: Is Defragmenting Tables safe?

texts:
I like using MySQLTuner to check on things from time to time. It's as easy as:

$: sudo apt-get install mysqltuner (CentOS: sudo yum install mysqltuner)
$: sudo mysqltuner

Also, besides 'top' which is the default monitor for the server's processes and hardware, install 'mytop' exclusively for monitoring MySQL. Excellent tool to watch all your databases at once.
I have never performed OPTIMIZE_TABLES to defragment for a CiviCRM installation before. Is it safe? Of course, do a robust backup first, but want to know before to expect if there is likelihood of failure. No one wants more work or downtime than necessary. Also, please advise on the other two suggestions. All noted with arrows. Thanks in advance.
Here are the results:
General recommendations:

    =>Run OPTIMIZE TABLE to defragment tables for better performance
    MySQL started within last 24 hours - recommendations may be inaccurate
    Enable the slow query log to troubleshoot bad queries
    =>Adjust your join queries to always utilize indexes
Variables to adjust:

    =>join_buffer_size (> 128.0K, or always use indexes with joins)

Full Report:
 >>  MySQLTuner 1.0.1 - Major Hayden <major@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password:

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.38-1~dotdeb.0
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 17M (Tables: 203)
[--] Data in InnoDB tables: 53M (Tables: 841)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MEMORY tables: 0B (Tables: 10)
[!!] Total fragmented tables: 861

-------- Performance Metrics -------------------------------------------------
[--] Up for: 1h 25m 6s (7K q [1.402 qps], 270 conn, TX: 11M, RX: 1M)
[--] Reads / Writes: 64% / 36%
[--] Total buffers: 192.0M global + 2.7M per thread (151 max threads)
[OK] Maximum possible memory usage: 597.8M (29% of installed RAM)
[OK] Slow queries: 0% (21/7K)
[OK] Highest usage of available connections: 5% (8/151)
[OK] Key buffer size / total MyISAM indexes: 16.0M/2.9M
[OK] Key buffer hit rate: 98.8% (10K cached / 121 reads)
[OK] Query cache efficiency: 51.1% (1K cached / 3K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 417 sorts)
[!!] Joins performed without indexes: 151
[OK] Temporary tables created on disk: 16% (127 on disk / 788 total)
[OK] Thread cache hit rate: 97% (8 created / 270 connections)
[OK] Table cache hit rate: 96% (234 open / 242 opened)
[OK] Open file limit used: 9% (102/1K)
[OK] Table locks acquired immediately: 99% (3K immediate / 3K locks)
[OK] InnoDB data size / buffer pool: 53.8M/128.0M

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    MySQL started within last 24 hours - recommendations may be inaccurate
    Enable the slow query log to troubleshoot bad queries
    Adjust your join queries to always utilize indexes
Variables to adjust:
    join_buffer_size (> 128.0K, or always use indexes with joins)


texts: Can't use function return value in write context in ... civicrm.php on line 342 (5.8.1, WordPress)

texts:
After manual installation of the plugin in Wordpress (5.0.1), PHP (7.2.12), mySQL (10.1.36-MariaDB). I can't activate it.

I receive this info:

Fatal error: Can't use function return value in write context in .../public_html/CRM/wp-content/plugins/civicrm/civicrm.php on line 342


texts: I have an event registration setup. I have a person that has tried to register from his home internet provider and mobile phone provider and it will not register him. He has tried 3 different email address. One email address worked once, I deleted it from the backend and it would not work again. If I use any of his email address to register him it works. I've also had 5 others register and it was fine. I had this same issue last year with an event. Some people were able to register and some were not. Any suggestions where I can look for the issue?


texts:
as said in the title, the mailing report seems to have a wrong time...when I send a mailing to my private email adress at 4 pm and open it right away, the mailing report says I opened it 2 hours ago.
Not much of a big problem here but it triggers me anyway!

Would be very thankful for some help!!

Ben


texts:
I want to use a civi profile for our contact form, so that all inquiries and new contacts are stored in civi. I created the custom fields and have them on a new tab and table, so multiple submissions will be stored.   I am having two problems.

When the profile form is submitted it arrives in email with our organization's email address as the From address.  Can I set this so the person who submitted it is the From address?
We would like to show the date it was submitted on in the table, but the only option I can find is for the user to select the date manually before submitting it.  Is there a way to have the current date already pre-selected in view only mode on the profile?

Civi 5.3 on wordpress 4.9


texts: Trying REST but get PHP Fatal error: Class 'JObject' not found in

texts:
I need make a query on civicrm project in joomla from REST. However, when I try:
http://localhost/joomla/administrator/components/com_civicrm/civicrm/extern/rest.php?entity=Contact&action=get&api_key=//user_key//&key=//site_key//
I just get:

PHP Fatal error:  Class 'JObject' not found in /var/www/html/joomla/libraries/joomla/event/dispatcher.php on line 23

I already change manually the api_key in mysql database, but I just can't make the access between api and database.

How I was afraid that problem envolve permission issues, I try with cv command too. Here is the command:
cv api Contact.get debug=1 sequential=1

and exact same answer was showed up.

Can Someone help me to find the way toward resolve this problem?

thanks


texts: Issue on closing popup and showing message after doing any action in CiviCRM

texts:
Having issue when doing action like adding, updating or deleting anything from CiviCRM. Its not closing the popup and shows success message.

For Example,
When I am adding the new event registration from CiviCRM admin panel, Once I clicked on Save button, the registration got saved, but the popup is not closing and not showing the success message. Page stops with disabled buttons. Every time I suppose to refresh to see the saved records.

When I checked the ajax, One ajax request was called and succeed.

/civicrm/contact/view/participant?action=add&cid=50767&context=participant&snippet=json

Response

Object ID: 39731Operation: createObject Name: ContributionObject Ref: CRM_Contribute_BAO_Contribution Object
(
    [_relatedObjects] => Array
        (
        )

    [_component] =>
    [trxn_result_code] =>
    [id] => 39731
    [contact_id] => 50767
    [financial_type_id] => 4
    [contribution_page_id] =>
    [payment_instrument_id] => 4
    [receive_date] => 20180709022000
    [non_deductible_amount] => null
    [total_amount] => 0.00
    [fee_amount] => 0
    [net_amount] => 0
    [trxn_id] => null
    [invoice_id] =>
    [invoice_number] =>
    [currency] => USD
    [cancel_date] =>
    [cancel_reason] =>
    [receipt_date] => null
    [thankyou_date] =>
    [source] => HGS General Dinner- Tentative : Offline registration (by Mr. Manigandan V)
    [amount_level] =>
    [contribution_recur_id] =>
    [is_test] =>
    [is_pay_later] => 0
    [contribution_status_id] => 1
    [address_id] =>
    [check_number] => null
    [campaign_id] =>
    [creditnote_id] =>
    [tax_amount] =>
    [revenue_recognition_date] =>
    [_options:protected] => Array
        (
        )

    [_DB_DataObject_version] => 1.8.12
    [__table] => civicrm_contribution
    [N] => 0
    [_database_dsn] =>
    [_database_dsn_md5] =>
    [_database] => pantheon
    [_query] => Array
        (
            [condition] =>
            [group_by] =>
            [order_by] =>
            [having] =>
            [limit_start] =>
            [limit_count] =>
            [data_select] => *
        )

    [_DB_resultid] =>
    [_resultFields] =>
    [_link_loaded] =>
    [_join] =>
    [_lastError] =>
    [payment_processor] =>
)
{"buttonName":"upload","action":1,"id":22766,"status":"success","userContext":"\/civicrm\/contact\/view?reset=1&force=1&cid=50767&selectedChild=participant","title":"New Event Registration for Mr. Mani V","crmMessages":[{"text":"Event registration for Mani V has been added.","title":"Saved","type":"success","options":null}]}

Please Help!
I am using Drupal 7 with CiviCRM 4.7.29.


texts:
My menus look like this:

For background: This is Drupal 8.  The menus were fine, but I'm porting the site to Pantheon.  My Browser dev tools say that all my files (inc. CSS/JS) are loading properly.  There are no JS console errors.  My non-Pantheon site doesn't have this behavior, though I've had to make changes to the site to make it work in Pantheon (mainly in Composer) but I can't think of what else could cause this.

Edit: I compared the actual CSS files - builder.css is different on my non-Pantheon site.


texts: Drupal block not appearing on CiviMail page

texts:
I want to add some inline help to the New mailing CiviMail.  e.g. show a block on this page civicrm/a/#/mailing/12345

I've created my drupal block, set it to appear in the correct theme and set it to only display on this page: civicrm/a/#/mailing/*

However for some reason it won't show.  I've backtracked and I'm able to get it to show up with this expression: civicrm/* but as soon as I add civicrm/a/* it doesn't work, just doesn't display

Any ideas about why this might be?

Thanks
Peter


texts: Groups correctly set but showing wrong - caching problem?

texts:
I'm using CiviCRM 4.6.5, Joomla 2.5.28 (yes, I know...), with 70k contacts and 25 groups (one of which is a smart group).

Since the upgrade to 4.5.6, contacts started to display the wrong groups (actually several times the same group, instead of several different groups). If you check the groups the contact should be in, the contact is there. But the group doesn't show on the contact record. Cleaning the Caches (through the backend) seems to fix the problem, and everything is fine and dandy for a while, with the groups displaying correctly in the contact records again. But the fix is only temporary - the next day, the problem is back again.

Can anyone please suggest where to start looking for the cause?

Thanks.


texts: width of email field on contribution form

texts:
Using a WordPress installation. Initially the contribution form shows an amount field and an email field. Is there a way to make the email field wider. Currently both are the same width. Inspecting the page it appears that both fields use the same style attribute. I would like the email field to be about twice the width of the contribution field.

Any suggestions would be appreciated.


texts:
we've been running CiviCRM 4.2.6 for a number of years now on Drual 6 and I've finally got round to upgrading. Has anyone here gone from 4.2 to 4.6? Any gotchas that you hit?

I've run the upgrade on our test Drupal 6 site and once MySQL permissions around triggers were sorted the upgrade ran through fine.

I'm keen to hear other peoples experiences.

Em


texts: How to link to the CiviEvent registration page from a node field using entity reference

texts:
Scenario is the Content Type has an Entity Reference field set to use Target Type = CiviCRM Event. This currently gives me a radio set for the civievents to choose from.

My concern at this point is about how the field can be displayed. i would like it to provide a link to the registration page of civicrm - i set the Field Display to 'link label to entity reference' but am just getting the event id with no link


texts: How to display custom fields 2 fields in row, instead of new line for each field

texts: I'm new to civiCRM, I tried to search but didn't find an answer, although I feel that my question is naive


texts: Confirmation email not sent upon registration BUT…

texts:
If a user registers for an event the registration confirmation email does not get sent. The registration completes, however they see this error message:

I am using mail() and when I test Outbound Mail settings, it works.

Now the BUT… part:
If I register a participant using the Register Event Participant option in the backend, the registration completes and the registration confirmation email is sent to the user.

I am stumped.

Were running CiviCRM 4.6.8 on Wordpress 4.3.1

When I 'Redirect to database' the emails get into the spool table. See Screenshot:


texts: How do I add not native extensions in Drupal, I was using WordPress where I know how to do it but recently moved over to Drupal.


texts:
I need to change the contact dashboard that I display to users so it does not show a [Renew Now] link in the Membership section.

Thanks
Miguel Peirano


texts: How do I notify our targets that a petition has been signed?

texts: I am creating a petition with multiple targets. Is it possible to have them be notified via email each time the petition is signed? Or is it possible to CC them in the email confirmation the petition signer receives?


texts: Can I use Civi platform to set up an online store?

texts:
Since we cant hold events due to Covid-19, I suggested opening an online store so we could sell tshirts, stickers, and other swag as a fundraiser.
I set up a Contribution page, and am using a price set for the items. But that seems cumbersome, and doesnt allow much flexibility. For instance, each item is its own line-
"Hammer" Blue T-Shirt, Size Small"
"Hammer" Blue T-Shirt, Size Medium"
Is there a way I could create the page to say,
"Hammer Shirt" and then a drop down for size and color info?


texts: does anyone have a recipe for a Drupal 8 Views Calendar to show civi events or civi activities

texts:
Title pretty much says it. want a View Calendar for Civi Event and also for Civi Activity using drupal 8

Was following the second recipe at https://evolvingweb.ca/blog/creating-events-calendar-drupal-8 but get to part for Contextual Filters and don't have the CiviEvent date fields available to me


texts: Which folder to put Caldera forms CiviCrm plugin in?

texts:
I'm not an IT person so please bear with me.
Trying to install Caldera Forms CiviCRM plugin but not sure which folder to locate it in. Have put it in
/wp-content/uploads/civicrm/ext
via FTP for now but it hasn't come up on the extensions list. But now I'm thinking maybe it should be in a WP folder instead of a Civi one as it links the Caldera form WP plugin to CiviCRM. So I put it in the WP ext folder but still no sign of it in the WP or Civi backend.
Where do I put it? Any ideas are much appreciated.
Just a small charity so trying to wing it on a zero bugdget as much as possible!


texts: Mass update / import bulk email preferences?

texts:
So - here is the deal - we have an excel sheet with hundreds of contacts - with which email they would like set as bulk mail. While doing an import, I see no option to indicate bulk mail preferences - any suggestions?

Civi 5.10, Drupal 7


texts:
Is it possible for logged in users without any relationships to renew memberships for other people?
I'm looking to have the ability for someone to go to my site and pay to renew any persons active membership basically.


texts:
We've written a custom token to pull a piece of custom data off of any open cases. The token works as an imploded variable. I'd like to be able to use the token as an array as well (so I can run a for each loop in an email communication.) I am having trouble accessing the array.

If I use the variable {extrainfo.namearray} the email prints "Array". I've tried a simple foreach loop

{foreach from=extrainfo.namearray item=value key=label}

    {$label}
    {$value}

{/foreach}

This prints out an "0" and "extrainfo.namearray" I can only assume that's becuase I don't have the "$" before the token name. The statement prints out nothing if I add the $ to the token name.

I know the array has content, if I use {debug} in an email, I can see that it is part of the {$contact} tokens. It prints our the array itself with the expected data:

extrainfo.namearray => Array (3)
97485 => "Name 1"
97486 => "Name 2"
97547 => "Name 3"

I also tried accessing it in this manner {$contact.extrainfo.namearray} but that prints nothing (not even "Array").

Any advice on how I can target/loop items in the {extrainfo.namearray} array?


texts: Is there a function or extension that shows one view in a case containing the content of the Summary and Details fields of all activities

texts: We are seeking to show, preferably in the management of a case not as a separate report, a list of the Summary and Details fields of all activities in a case. The goal is to promote the use of cases. Currently, our user resistance focuses on the lack of a view where all of the text written by self or others on the case is tucked away inside each activity and not visible as one cohesive narrative. Ideally, the texts could be edited from this new view. The rows in the view would probably be in chronological order.


texts: How can I stop civicrm_metatag_metatags_view_alter() altering non-CiviCRM URLs

texts:
The purpose of function civicrm_metatag_metatags_view_alter() is to ensure the metatag URLs include the query parameters. The problem is that it acts on non-CiviCRM pages.

'Metatag' is a Drupal module for adding  tags to the rendered HTML, and this function is in drupal/civicrm.module.

Proposed solution

civicrm_metatag_metatags_view_alter() should be modified to only work on CiviCRM pages. With all kudos going to @Chris-Burgess I've created an issue CRM-17594 and PR https://github.com/civicrm/civicrm-drupal/pull/328 to resolve this.

My question: How do I check that a URL is a CiviCRM URL?

As discussed below, the answer is to check if arg(0) equals 'civicrm'.

Description of problem

I get the following PHP Notice ...

  Notice: Array to string conversion in _civicrm_get_url_parameters_as_url_string() (line 295 of .../sites/all/modules/civicrm/drupal/civicrm.module).

A page where this occurs is http://citybibleforum.org/library?&title=&field_speakers_tid=&field_topics_tid=&field_bible_reference_value=&field_episode_date_value%5Bmin%5D=2011-08-12&field_episode_date_value%5Bmax%5D=2012-08-12&field_is_audio_value=All&field_is_text_value=All&field_is_video_value=All&page=46

The parameters causing the notice are ...

  field_episode_date_value[min]=2011-08-12&field_episode_date_value[max]=2012-08-12


texts: How can I create multiple price-sets within one price-set?

texts:
I need to create a contribution page with a price set like this..

TITLE 1

Price-£100
Price-£200
Other amount

TITLE 2

Price-£400
Price-£600
Other amount

We have a events coming up where different category of donation is been assigned and they are referred as "Title 1", 2 etc. within those titles there are separate donation items. Now a contributor should be able to chose a title and select a donation amount within that title. From the admin side of it, we should be able to reciprocate with them or give them gift based on the title & amount they chose.


texts: I've accidentally deleted a number of contacts.  How do I restore them so that they are still members of my organisation?


texts: Is it OK to drop database triggers in order to run a process?

texts:
I've spotted at least one process in CiviCRM that drop triggers on certain tables in order to run a process. For example:
https://github.com/civicrm/civicrm-core/blob/1e7702fee94c891c1c1b3ec4d43688991f96b6af/CRM/Contact/BAO/ContactType.php#L904

Is this a bug?

If an operation happens simultaneously that would affect the table which has had its triggers removed, wouldn't that cause data integrity issues, or gaps in logging (which uses database triggers)?


texts: Is my upgrade failing if the screen appears to hang

texts:
We're on 4.7.3 on Drupal 7, and are being affected by some bugs that affect contributions made on behalf of an organisation and paid for by paypal.

When I attempt the upgrade to 4.7.5, the upgrade script says it has updated to 4.7.4 without problems, but then hangs on Begin upgrade to 4.7.5 message

See:

I left it for 5 minutes (the php max runtime was set to 3 minutes) and then hit refresh, it emptied - no text or progress.  Re-opening the upgrade script then says it failed the integrity check. I've rolled back to a backup for now.

There is no error in the HTTP error log, nothing seems to have run out of memory.

I'd be grateful for any help in how to set about diagnosing this issue!


texts: Error in WordPress affecting site editing

texts:
When I try to edit pages in my WordPress site, I get a message on the editing page: The site is experiencing technical difficulties. Please check your site admin email inbox for instructions.

The email I receive about the error states:

Error Details

An error of type E_PARSE was caused in line 1 of the file /home/susquehanna/ssorchestra.org/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(207) : eval()'d code. Error message: syntax error, unexpected 'clone' (T_CLONE), expecting '('

If I deactivate CiviCRM, I can edit my site like normal, if it's activated, I get the error messages. How can I fix this?


texts: Ajax pop-ups are not interactable and sized improperly

texts:
Before reporting a bug, I just wanted to double check if it's anything obvious or localized.

The mailing preview pop-up and the "add activity" pop-up from the contact page are two examples of broken functionality on our site. They just don't work. The frame does, you can move it around and close it, but actual interactions with the content don't. It's like it's locked or there was a div over it blocking event dispatch.

Eg. that internal scrollbar doesn't work. If I zoom out enough in firefox for the scrollbar to disappear, that doesn't help anything. Can't click or input. I also don't see any problematic elements in the DOM nor are there any javascript errors logged.

Am I the only one with such problems? Is the port of the theme incomplete? I couldn't find any related bug reports. CiviCRM 5.24 on Drupal 8.8.


texts:
My organisation has members who speak different languages, and we send them emails written in the language they speak.

These emails have an opt-out link, generated by the token {action.optOutUrl}. Our problem is that the link always leads to the English version of the form, while we would like it to be in the same language as the email. Same thing for the optout confirmation. So for example the token should generate www.example.com/de/civicrm/mailing/optout? when sending an email in German (our CMS is Drupal).

I can see two ways for CiviCRM to do that:

Use the preferred language of the user
Use the language used by the person who creates the mailing

Actually, it seems the second option is almost there: if I create the mailing from an interface in German (/de/civicrm/a/#/mailing/xxx), the Test mail has the link generated for German, but unfortunately the real mailing doesn't.

Is this something lacking from civicrm, or am I missing something? I would rather avoid having to create one token and one optout message per language, especially for the former as it requires development.


texts: Does CiviGroup Roles Sync work with bulk changes to groups?

texts:
Using CiviCRM 4.7.17 with Drupal 7.54

CiviGroup Roles sync adds and removes Drupal users from Drupal roles when changes to CiviGroup groups are done one Contact at a time from the groups tab for the Contact. So the sync is set up correctly.

But when I add or remove Contacts to/from CiviGroup groups in bulk from a list of Contacts, the changes are not synced to the Drupal roles.

These are NOT Smart groups by the way.

Am I missing something? How can I do bulk add/remove Contacts in Civi and have the Drupal roles synced accordingly?

Thanks for any suggestions.


texts: How to manage AngularJS dependencies within an extension

texts:
I'm creating an extension and using AngularJS within it. I've found a 3rd party AngularJS library that I'd like to use in my extension (in this case ngInfiniteScroll). What is the proper way to make my extension depend on this external library (and to ensure that the library is installed when the extension is installed)?

I'm pretty new to AngularJS development and CiviCRM development, so I still don't have a clear understanding of the difference between npm, webpack, bower, yarn, grunt, gulp, and browserify. Mostly I need to be pointed in the right direction.


texts: Can I link memberships to relationships automatically?

texts:
I'm using CiviCRM to manage sponsors of children in India for an NGO. I'm configured it and set up some custom fields in order to have the children(contact) connected to the membership.

So far so good, I can generate reports to see payments due, etc.

The problem is, I can not work the other way around, that is, seeing which children don't have sponsors.

My guess to solve this was to use Relationships, as I could then report and filter on that. But I've not been able to automatically create a relationship between sponsor-child when adding the membership. (doing it manually would be really tiring for the people who manage this).

Is it possible?
Any other ideas on how I could go about this?

thanks in advance


texts: Error on activity import: "'1' is not a valid option for field custom_42". Can I find which field this is referring to through the admin interface?

texts:
I am importing custom activities (with some custom fields in them) and getting "'1' is not a valid option for field custom_42."

The problem is that I can't figure out which field it's referring to. "1" is not a value I am trying to import so that's no help. Do I have to go into my back end to find the the interface label for "custom_42" or is that exposed in the admin interface anywhere?

Running 4.6.4 on Drupal.


texts: CiviMail Sent/Scheduled Mailings does not list mailings for some users

texts:
I'm in a context using some CiviCRM ACLs to restrict access for regional staff to regional contacts. Some core staff have access across the regions.

However, the regional staff cannot view the list of sent mailings.

After some code investigation, it seems that CiviMail will only show people mailings that have been made with some sort of reference to one of the groups that defines contacts the user has access to view or edit.

This is pretty restrictive because it means mailings have to be sent to an ACL group (and therefore that ACL groups must be mailing groups).

In reality, a country-wide email newsletter is sent, but the regional staff cannot see these. Also, regional staff can't see draft mailings that they have created to other mailing groups.

I'm on CiviCRM 5.10.3 (and Drupal, if it matters)

Has anyone found a solution? I'd like them to be able to see all mailings, and certainly mailings they create themselves (which will be to contacts they have access to).


texts: How can I display the members of a group?

texts: I would like to go into a group to see who is listed in it, please advise how I can view a group. Thank you


texts: Cannot install CiviCRM 4.7.21 on WordPress/Drupal

texts:
Wanting to do a clean install of CiviCRM, I thought I should use version 4.7.21. I am using a clean install of WordPress 4.8 with no other plugins.
I get the error message below when I go to the configure screen (....<civicrm directory>/civicrm/install/index.php) and all the database checks appear red (edit: attempted installation with Drupal 7.56 with the exact same problem):

Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, null given in /home/fotgm080/public_html/temp2/wp-content/plugins/civicrm/civicrm/install/index.php on line 1282
Your database settings don't appear to be correct.

Does the server exist?  OK (localhost)

Are the access credentials correct? That username/password doesn't work:

Can I access/create the database?   I can't create new databases and the database 'fotgm080_wp685' doesn't exist. (user 'fotgm080_wp685' doesn't have CREATE DATABASE permissions.)

Can I access/create InnoDB tables in the database?  Unable to create InnoDB tables. MySQL InnoDB support is required for CiviCRM but is either not available or not enabled in this MySQL database server. Could not determine if MySQL has InnoDB support. Assuming no.

Can I create temporary tables in the database?  Could not login to the database.

Can I create lock tables in the database?   Could not connect to the database server.

Can I create triggers in the database?  Could not login to the database.

If I do a clean install of WordPress/Drupal again and try CiviCRM 4.7.20 then everything is fine.


texts: Views : Syntax error or access violation: 1142 (???)

texts:
I am trying to implement Views, but when I want to create an elementary users view, I get the following error :

SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'XYZ'@'localhost' for table 'civicrm_uf_match'

This, though I followed the Wiki : https://wiki.civicrm.org/confluence/display/CRMDOC/Views3+Integration

Here under is a partial copy of my settings.php file where I have copied the requested info :

$databases = array (
  'default' =>
  array (
    'default' =>
    array (
      'database' => 'paroisse_drup275',
      'username' => 'xyz',
      'password' => 'abc',
      'host' => 'localhost',
      'port' => '',
      'driver' => 'mysql',
      'prefix' => 'dr_',
    ),
  ),
);

$databases['default']['default']['prefix']= array(
  'default' => 'dr_',
  'civicrm_acl'                              => 'paroisse_civicrm.',
  'civicrm_acl_cache'                        => 'paroisse_civicrm.',
  'civicrm_acl_contact_cache'                => 'paroisse_civicrm.',
  'civicrm_acl_entity_role'                  => 'paroisse_civicrm.',
  'civicrm_action_log'                       => 'paroisse_civicrm.',
  'civicrm_action_mapping'                   => 'paroisse_civicrm.',
  'civicrm_action_schedule'                  => 'paroisse_civicrm.',
  'civicrm_activity'                         => 'paroisse_civicrm.',
  'civicrm_activity_contact'                 => 'paroisse_civicrm.',
... );

I am in CiviCRM 4.7.6, with Drupal 7.43


texts: Automatic discount if participant on other event

texts:
I want to give automatic discounts to participants if they already are participating in another event.

I have explored the API and have some clues on how to look up participants on "the other event". But I don't understand

How can I check if the current registering contact is in that list
How do I turn this into something that can be applied during/after the registration process
Where do I put that code, or whatever the "something" is

I could not find any documentation for the "automatic discount" part of CiviDiscount. Hints on where to find that are also helpful.

Edit:

I found CiviCRM Additional Events signup which sounded like a good fit but could not get that to work in a quick check, unfortunately.