texts: Cannot configure Civicrm after installation of the plugin

texts:
I installed civicrm plugin on a Wordpress site.
When I click on the link to configure it
( CiviCRM is almost ready. You must configure CiviCRM for it to work),
I got a blank page.
All the versions of component (php, MySql, Wordpress) meet the requirements.
Thank you for your help !


texts: Is CiviCRM right for managing volunteers on clinical trials

texts:
We need to keeping volunteers happy and engaged in trials. We would need segment our volunteers based on preferences for type of trials they want to participate in, whether they agreed to participate in a trial, rejected it or dropped out of a trial, whether they have completed all/some regular online tests.

That is the basics of the project.


texts: What to put in wordpress content views with civicrm dataprocessor join

texts:
I am stumped :)
I have set up everything to search civicrm from front end of wordpress. I see on content views the civicrm section but have no idea what to put in to see the dataprocesses selection. Am I supposed to be seeing something else? Thanks


texts: Bug in settings for CiviContribute Component?

texts:
I have been wondering for a while, why two settings for CiviContribute did never have any effect on the created financial transactions:

Always post to Accounts Receivable?
Enable Deferred Revenue?

Since I am beginning to become more familiar with Civi, I tried to dig a bit deeper into the internals of the system, and I might have found the cause.

In general, all settings for all components are stored in the table civicrm_setting, one row per setting.

BUT: There is one exception. All settings for CiviContribute get stored combined within one single row. Looking into the source code, all relevant settings are then pulled out of this single row. And this is also true for the read access to the two settings I mentioned above.

HOWEVER: It seems that when the settings of these two entries get stored, they are indeed written in distinct rows within the settings table. This would be ok for all other settings, except those for CiviContribute. While the system tries to  read the (non existing) values out of the combined row, it always assumes, those values have never been set.

I manually fiddled with this ominous CiviContribute data row and placed a value for deferred_revenue_enabled==true:

  a:10:{s:24:"deferred_revenue_enabled";s:1:"1";...

and voila, now the expected financial transactions all get generated.

I would like to ask some of the more experienced CiviCRM guys to have a look at this phenomenon, since I am not quite sure yet about the correct way for a bug report.

(My current version of Civi is 5.13.2 in combination with Wordpress 5.2, but this bug exists already for some time, at least since 5.11.)


texts: Registration confirmation email uses wrong From email address

texts:
I use Civi 4.7.27 on Drupal.

When using the back-end form to register a contact to an event, and checking the 'Send Confirmation' checkbox, then the 'Receipt From' email address shown is not the one I want.

I tried to change the general Civi's default 'From Address' to the one that I want, but this did not affect this address.

Where is this email address defined to be the default one for sending registration confirmation emails from?

Clarification - when a user registers by himself using the online registration form, he does receive the confirmation email from the correct address, as it is defined in the 'Online Registration' tab of the event configuration page. The problem only happens for manual back-end registrations.


texts: Personal Campaign Pages only visible on front end when logged into back end

texts:
Using WP 4.6.1 and Civi 4.7.13. I am trying to create a set of PCP's for staff members for our year end fundraising campaign. I can successfully create a PCP from the link provided by the Contribution Page using a browser in which I am not logged into WP/Civi. In another browser, I am logged into WP/Civi and approve the PCP and am able to see that PCP by clicking the link in the Civi PCP list. However, if I log out or try to use that link in another browser in which I am not logged into WP/Civi I get an error stating that the PCP is not available but I can donate using the donation page form. What am I missing?

Thanks,
e.


texts: Extra p tags in profile form inserted via WP shortcode

texts:
Even though I have disabled autop for shortcodes, I end up with a lot of
extra
 tags in the generated form. Here's a snippet:

     Email
      *

    <input maxlength="254" size="30" name="email-Primary" type="text" id="email-Primary" class="big crm-form-text required" />

Note the stray

 in the middle. But while a bit wrong, this is ok. What's really a problem is that the generated JS code for the datepicker also gets a bunch of random
 tags:


texts: Reproduce CiviCRM configuration: best practice

texts: I have customized CiviCRM (translation, custom fields, module, view, report, menus, etc.) and I want to reproduce the configuration. What is the best way to go?


texts: Related Permissions Extension: Existing Contact widget on Webform not showing related contacts

texts:
We are using Webform and the Related Permissions extension to allow parents to register their children for summer camp events. An Existing Contact select widget is included so that parents can select children they have previously registered (which established a permissioned relationship between them).

With "Enforce Permissions" selected on the webform component, the drop down list does not work - no contacts are included in the list, even though the user is logged and has related and permissioned contacts.

When "Enforce Permissions" is de-selected, the drop down list shows the first 500 contacts as expected.

The logs show the following error:

The CiviCRM "contact get" API returned the error: "DB Error: unknown error" when called by function "_webform_render_civicrm_contact" on line 387 of contact_component.inc with parameters: "Array ( [is_deleted] => 0 [contact_type] => Individual [check_permissions] => 1 [rowCount] => 500 [sort] => sort_name [version] => 3 ) "

Drupal 7.50
Civi 4.7.11
Webform 7.x-4.14
Related Permissions Extension 1.2 (with latest codebase installed a couple of weeks ago)

Any ideas appreciated!


texts:
I'm modifying /templates/CRM/Profile/Page/Listings.tpl to a specific customer need. The profile I need to show using that includes a Multiple Value custom field.

When I tried the Listing with a record (Contact ID) with more than one value in that custom field, is shown multiple times that Contact ID, each one with one value from the Multiple Value custom field.

I turned debug on and the $rows array really shows multiple entries, each one with one value from the Multivalue field.

No matter if I turn is_multi_summary => "1" on or off, it doesn't change anything.

The code from Listing.tpl I'm working on looks like that:

  {foreach from=$rows item=row name=listings}

{$row.2}

{$row.1}

{$row.5}

{$row.7}

  {/foreach}

Also, makes no difference if I use the original loop to show the values, like that:

  {foreach from=$row key=index item=value}
    {if $columnHeaders.$index.field_name}

{$value}

    {else}
      {* $value *}
    {/if}
  {/foreach}

Things still got duplicated.

Is it possible to says Smarty to show the Multivalue Field only once, with all the values inside? Like a localized "foreach"?


texts: Issues with refunds for credit card payments

texts:
This has been a long standing issue for us.

We accept event registrations and accept payments with credit cards through Authorize.net. Many of our events have multiple options using price sets.

If someone registers for the event, and later needs to change the options lowering the fee, they need a refund. We can issue the refund manually without issue, but when we change their registration in CiviCRM the contribution fee changes to the new value and the status changes to pending refund, and we can't ever change it from that.

All our refunds happen manually out of the system, and we really need the pending refund contributions to be changeable back to complete when the refund is processed.

This really messes up our reporting for the event, and throws things off in a messy way.

Is there a way to resolve this so that we can track things as they should be?

What is the logic in restricting the change in that field? Since CiviCRM can't process the refund, and we need to do it offline, we should be able to change the status once we issue the refund.

Any help, thoughts, or ideas would be wonderful.


texts: Format Contribution Form Using Pricesets

texts:
We are creating a contribution page using a price set which is new to us. The format is a little weird. Is there a way to align the email address with the entries above it? Or can we eliminate the email address above the 'Donor Info' like and include it into the profile below? See image below.
Thanks in advance.
Using Civicrm 4.7.8 and Joomla 3.5.1

(source: corvair.org)


texts: Restrict users to viewing only data in their state?

texts:
We are using Civi 5.14 on WordPress 5.1
My client has giving me this request.  Can this even be done with Civi?  She wants to restrict our volunteers to viewing only contacts within their own state, or reports based on contacts in their own state.  Her request is below.

"create log-ins for almost everyone on the affiliates list (Contact/Advocate/Affiliate leader anyway.) Then, arrange so that their access gives them the ability to view ONLY contacts from their state, and have a simple way to download contact info (perhaps several pre-created reports like email/phone only, full mailing info, and "full info" which would hit a few other things like Y/N donor, member, event participation."


texts: How do I solve a string extractor issue?

texts:
I'm still having some English mixed with French even though these strings are translated since years in transifex.
Like in this example:

  Veuillez vérifier attentivement les informations ci-dessous. Cliquez sur Retour si vous avez besoin d'y apporter des changements. To complete your contribution, click the Continue button below.

And forcing to translate in word replacement doesn't work either. Of course I cleared all caches.

The concerned file is /sites/all/modules/civicrm/CRM/Core/Payment/Manual.php line 255

Any idea?

POST : I'm getting confused. The text

  To complete your contribution, click the %1 button below.

is supposed to be translated since 8 years but should appear in

  templates/CRM/Contribute/Form/Contribution/Confirm.tpl

when it's not and is to be find in

  /sites/all/modules/civicrm/CRM/Core/Payment/Manual.php line 255


texts: I need to find out the sitekey for our developers. Not sure where to find this. Any advice appreciated!


texts: Bulk Delete of Spam Contacts and related Drupal Users

texts:
I've a list of 8K+ CiviCRM contacts that have been deemed spam/unwanted. I am looking to clear them from CiviCRM, along with their related Drupal users.

I've found and tested this module: https://www.drupal.org/project/userdelete which will allow me to plug in a list of email addresses, arrived at from joining my list of contacts to the civicrm_uf_match table.

My question is, what is the path of least resistance to handle a clean removal of the CiviCRM contacts?

The API explorer seems to indicate that the contact delete method will only take a single contact id at a time, which would force me to write a module or a rest client to iterate through my list.

Would simply updating the CiviCRM DB directly with is_deleted = 1 do the trick?

I imagine this isn't a new situation...

Thanks in advance for your feedback.


texts: Send alert if smart group contains any contacts

texts:
The problem:

I'm trying to monitor daily for contacts meeting certain criteria, and would thus like to have a way to receive a scheduled email if a smart group contains contacts.

Possible solution: Using CiviReport?

CiviReport supports scheduled delivery of reports, configurable under a report's "Email Delivery" tab.

Is there a way to avoid sending the report if it contains no rows?

Alternately, I could do something in cron with drush sql-query or some such, but ideally I'd like to do this within CiviCRM.

Other options:

Are there other to achieve this goal within CiviCRM that would not require custom code?


texts: Summing up donations on the household level

texts:
We have the following problem: If we record a donation on the individual level of a person: Let’s say there is the imaginary Byron Terry-Lee and the spouse is Megan Terry-Lee. Both are members of the household Terry-Lee. Byron Terry-Lee donates 10 $, Megan 20 $ and on the occasion of an anniversary both donate together (as a household) 30 $. I’d like to see on the household level the summed up donation for the household (respectively 60 $). Has anyone an idea how to reach that?

Thank you for looking into it.

Best regards

Esther


texts: how to test the version-or if a feature is implemented?

texts:
when writing extensions, i often try to keep the code compatible with several versions of civi instead of having to maintain different branches.

however, i sometimes would like to use a new feature if it's available, for instance, civi 4.6 introduced an option to force rollback that i would like to use, but if i'm using this option and run the code with civi 4.5, it will silently ignore it and won't rollback.

is there a way from the api to test the version that is running, or -my preference- if a specific feature is implemented?


texts:
Most transactions are fine, but some cards are starting to come up with some kind of deadlock between Stripe and Civi. They leave an unresolved $1 charge in Stripe and fail on the Civi side entirely, with the following error:

I'm running Civi 5.22.0, with Wordpress 5.3.2–en_CA and Stripe extension 6.3.2
I am not, to my knowledge running any other processing related extensions, but here is a screenshot of my extension page for the curious.


texts: How can I load javascript dependencies in a tab?

texts:
I have a page that works correctly when loaded directly, but fails when loaded as a tab.

The page includes:

CRM_Core_Resources::singleton()
  ->addScriptUrl('https://d3js.org/d3.v5.min.js', 10)
  ->addScriptFile('myext', 'js/chart.js', 20)
  ->addVars('myext', ['data' => $data]);

It loads d3 and the extension's chart.js and draws a chart.  That all works.

But when I try to add it as a tab on contact summary it fails.  Using the browser's Developer Tools, shows both the calls to load d3 and chart.js both succeeding with status 200 but the console produces 'd3 is not defined'. It looks like chart.js is trying to run before d3 has loaded. I've tried changing the weights and regions in the addScriptUrl() and addScriptFile() but without success.

How can I get this to work correctly when loaded as a tab?


texts:
Not really a Civi specific question but someone here might have suggestions on the best place to discuss.
Got the basics working.  Now I need to figure out how to best add in or update modules and themes


texts: Should new Scheduled Reminders (based on Activity Type = Email) send out to Emails created in the past?

texts:
Steps:

Created a Scheduled Reminder (SR) for
Entity = Activity
Type = Email
Status = Completed
When = 1 hour after Activity Date Time
Recipients = Activity Assignees

When this was saved I created an email activity for myself. And then ran the scheduled job of ‘Send Scheduled Reminders’.

In addition to an SR going out for the new email activity, my Contact record had two completed email activities from the day before the creation of the scheduled reminder (and hence well beyond the "1 hour").

The result of running the scheduled job was an scheduled reminder sent for each of the two email activities from the day before. As well as one for the new email activity one hour after the activity date time.

Is the sending of scheduled reminders for historical activities expected behaviour? if not, are there steps via UI we should be taking to avoid this happening (other than devious ones of creating new Activity Types etc) or is this a bug that needs fixing.

My recollection is we have hit other nasty surprises of SRs going out to things that were way past, such as old Events.


texts:
All volunteer detained migrant visitation and advocacy organization running Civi 5.10.4. under Wordpress 5.1.1. ICE uses an A# to identify people and we'd like to use this number to track folks as well. I set up a detained persons individual contact subtype and placed the A# field under this contact type.

We're trying to use caldera forms for our volunteers to enter data about letters, phone calls, visits for detained persons. When entering data based on name and A# I'm getting duplicate records from identical information. I tried to create a dedupe rule, but don't find fields associated with detained persons individual contact subtype. Is there a way I can dedupe based on A# which is a detained person specific field?


texts: CiviCRM 5.12.0 - Case API returning an Analyzer object containing XML and JSON. Only want JSON

texts: I had a working script set up to create cases in CiviCRM using REST.https://domain.com/administrator/components/com_civicrm/civicrm/extern/rest.php?entity=Case&action=create&json=1&version=3&key=xxxxxxxx&api_key=yyyyyyy(obviously with the correct payload etc). This worked fine. It returned the specified return:id etc in a nice small JSON. Now, the same script is failing because it can't parse the returned JSON. It seems that the API is now returning a Civi\CCase\Analyzer Object which contains the full case data as XML and as JSON. Is this change intentional? Is it documented anywhere? I'm wondering how to extract the JSON from the returned Analyzer object. Thanks.


texts:
How do I make my extension recognise that there is an update available locally?

I have updated the info file, added a function (upgrade 2020) and cleared cache, logged in and out, clicked the refresh button on the extensions page etc.

I've established that even on uninstall and reinstall there is no entry in the civicrm setting table for this extension along the lines of:
| 89 | Extension  | org.civicoop.civirules:version            | s:4:"1005"; |         1 |       NULL |         1 |         NULL | 2016-03-19 04:28:15 |        203 |

Update:
When I go onto the extensions page I encounter:
When I go onto the extensions page now I encounter:

Recoverable fatal error: Argument 1 passed to CRM_Admin_Page_Extensions::createExtendedInfo() must be an instance of CRM_Extension_Info, null given, called in /var/www/html/civi46/drupal-7.39/sites/all/modules/civicrm/CRM/Admin/Form/Extensions.php on line 75 and defined in CRM_Admin_Page_Extensions::createExtendedInfo() (line 297 of /var/www/html/civi46/drupal-7.39/sites/all/modules/civicrm/CRM/Admin/Page/Extensions.php).

The key variable that it creates the extended info parameter from is null as well. Any ideas?

All suggestions welcome!

Thanks,

JohnFF


texts: Social Settings on the bottom of contribute pages

texts: On  the bottom of the create page there is a button to turn on social media. Where do I add the links to configure twitter, google, facebook and linkdin?


texts: Export Contacts after Include/Exclude Search: Selection of Fields not possible

texts:
After doing an Include/Exclude Search I want to export the contacts found, so I select "Export Contacts" from the "Actions"-drop down menu.

However there is no possibility to select the contact-fields I want to export, there is just the CiviCRM_Contact_Search.csv file generated containig the following fieldes: "Contact ID","Contact Type","Name","Group Name".

Is this on purpose, a missing feature or a bug?


texts: Update addressee values for all contacts after modifying Addressee Type Options

texts:
I have updated the tokens in my Addressee Type Options (at Administer > Communications > Addressee Formats), and now CiviCRM is now generating my desired addressee values each time I save contacts.

This is great, going forward.

But how can I update the addressee values for all the contacts in my database, without having to go edit/save them all one-by-one?


texts: Why won't CRM.loadForm render url containing civicrm/a/#?

texts:
This call:

CRM.loadForm(CRM.url('civicrm/a/#/tournament'));

works very well for any url that does NOT contain 'civicrm/a/#'. As soon as I try to open anything from an extension, the popup stays 'white.' No errors. Just ... white.

Is there a way to make that work for such url?


texts: Event Participant profile warning:The selected profile is using a custom field which is not assigned to the "Event" being configured

texts:
Profile has individual, contact and participant fields only.  All are accessible for user and admin.
Warning is issued when editing the event.  Nothing in error log.  form seems to work, but dedupe rules are not triggering.  This is for anonymous users on Drupal.

Possibly related:

https://issues.civicrm.org/jira/browse/CRM-17141 *** yes "CiviCRM: access all custom data" is enabled.

https://issues.civicrm.org/jira/browse/CRM-15427

https://issues.civicrm.org/jira/browse/CRM-16979

https://issues.civicrm.org/jira/browse/CRM-15595


texts: There is no Views relationship to civicrm_country nor civicrm_worldregions. How to create a view counting number of contacts from a region?


texts: Problem with Event Calendar extension after upgrade to 4.7.3

texts:
I just upgraded civicrm from 4.6 to 4.7.2. The event calendar extension, which is supposed to be compatible up to Civicrm 4.4, actually worked fine in 4.6. BUT, in 4.7.3 it seems to work in most respects but it does not display color coding for event types. All events show up in blue. When I try to go to the Event Calendar Settings page (in the Administer/Civievents section), I get the following message:

“Sorry but we are not able to provide this at the moment.
Cannot set unrecognized property CRM_Core_Config::$civicrm_events_event_types”

Please let me know how to fix this.


texts: How to create a report of all contact organizations?

texts: Creating a report of constituent individuals appears to be easy, but I can't see how to create a report of all organizations.


texts: Is there an automated way to check if a list of extensions is compatible with a version of Civi?

texts:
I'm going to go through a list of installed extensions manually at civicrm.org/extensions and check, one by one, if each is compatible with CiviCRM 4.7.x , per the Q and A here .

However, is there any way to automate that tedious process, from within the Civi UI and/or on the civicrm.org website? Extensions listed here all show CiviCRM Compatibility version info.

Can a filter be added to the webpage to search by CiviCRM version compatibility, for say, just CiviCRM 4.7? A compact view created with the Extension names and a checkbox to select a subset of results?

Thanks!


texts: How can I search by relationship in Contact.get?

texts:
Is there a way to search by relationship in the Contact.get API call?

Eg: give me all the contacts that are individuals, in group 9 and have a relationship type 8 (optionally specifying direction and/or the other contact) ?

I'm modifying existing code that builds a variety of filters into a Contact.get call and I want to add relationships to that.

The new join feature in 4.7 looks hopeful except that it is not advertised for Contacts in the API explorer.


texts:
I want to create a profile but I don't see that in the action dropdown. Have attached an image

Please help.


texts: Tracking CiviContribute Contributions with a Google Goal Funnel

texts: Has anyone figured out how to configure a Google Goal funnel (in Google Analytics) which will track CiviContribute contributions to the final thank  you page? It doesn't appear to be a topic with a solution. Thanks in advance for any help.


texts: How do you move SSL to non-SSL? [ Wordpress 4.6.1 + CiviCRM 4.7.14]

texts:
I responded to a question re: using Let's Encrypt SSL certs at this comment. I now need to go in the other direction because I made a mirror of our live site on my laptop in an xampp environment (win 10). There I don't have, nor do I want to use, an SSL certificate.

First, I removed the https redirect in .htaccess. Then, I was able to "simply" deactivate the Really Simple SSL plugin by following https://really-simple-ssl.com/knowledge-base/uninstall-websitebackend-not-accessible. This made our local Wordpress site work and I could also get into the back-end. However, CiviCRM does not work from either the back-end or front-facing pages. From the back-end, it generates an error trying to bring up the CiviCRM dashboard. Both give the same error:
"Parse error: syntax error, unexpected end of file in C:\vhost\sdbikecoalition\wp-content\uploads\civicrm\civicrm.settings.php on line 450"

[edit] And, of course, I checked the civicrm.settings.php file and found nothing suspicious [/edit]

I suspect it is because, on our live SSL site, I went to Administer > System Settings > Resource URLs and checked Yes on "Force Secure URLs (SSL)". Is there somewhere I can change this by just directly editing a record in the CiviCRM MySQL database?

I suspect that will solve my issue as that was the only thing I did within CiviCRM that was specific to SSL.


texts: information on how to translate the component for joomla

texts:
where can I find the italian translations of the civicrm component for joomla?
or how can I do the translation in Italian?

List item


texts: Payment options do not display when https used only when http used

texts:
I'm using CiviCRM on Joomla.
Under http Membership and Event Registration pages are displayed completely including Payment Options (pay later is enable and Standard Paypal).

Under https the Payment Options section does not display.

Any hints?


texts:
We are using Paypal pro to take payments for memberships. We use webforms in Drupal to capture the data into CIVICRM 4.5.8. There are some issues I have outlines in order of importance.

We cannot take international payments because the county field does not change when you select a different country. For example West Midlands, Saudi Arabia. Is it possible to get rid of the county field as a required field and hide it? Is the billing address required at all?
The page refreshes when something is wrong with the payment information but it does not tell you what is wrong.
There is no option to use the users address (shipping address) as the billing address. They have to type it again.

Does anyone know how to fix any of the above. it would be much appreciated.

Thanks,


texts:
A significant minority of users are getting uncaught exceptions when they try to unsubscribe, "Missing Parameters".
I suspect it's to do with cookies and sessions.
We use a 3rd party SMTP gateway service (Mandrill) which munges email we send by intercepting all link URLs and changing them to its own tracking URLs.
This means CiviCRM's unsubscribe URLs get changed from https://example.org/civicrm/mailing/unsubscribe?xxxx to https://3rdpartytracker.com/yyy.
Fetching the 3rd party URL results in a 301 redirect to the original URL. This is how all link trackers work, so no surprises there.
However, I've noticed, thanks to the report error extension sending me the POSTed data, that somehow CiviCRM has managed to set the hidden entryURL field to the original 3rd party redirect URL, when I think it should be its own.
entryURL is only set in one or two places in the codebase, so I put some checks in that would log something if it was being set to something other than the $_SERVER[HTTP_HOST], i.e. it should trigger if it was setting the entryURL to the third party. This code never triggered though.
I think it's always on mobile, but then it's a mix of Chrome 80 on Android 10, iPhone Safari 13.1 on iOS 13.5, iPhone Safari 12.1 on iOS 12.4.
Could it be some weird reverse proxy thing (where the 301 is handled up the chain instead of the client device)? Could it be some weird pre-fetch of links optimisation? I'm a bit stumped.
I'm on CiviCRM 5.24.5, Drupal 7.


texts: Target emails based on contacts near a postal code

texts: I am moving over to CiviCRM from The Action Network and am wondering if email blasts can be targeted by inputting a location (postal code or city) and choosing a set number of kilometers surrounding it to include. Thank you.


texts:
A recent security update from our host has resulted in cron throwing out the following errors:

  PHP Warning:  ini_set() has been disabled for security reasons in /.../public_html/wp-content/plugins/civicrm/civicrm/vendor/symfony/config/ResourceCheckerConfigCache.php on line 84
  PHP Warning:  ini_set() has been disabled for security reasons in /.../public_html/wp-content/plugins/civicrm/civicrm/vendor/symfony/config/ResourceCheckerConfigCache.php on line 99
  PHP Fatal error:  Allowed memory size of 33554432 bytes exhausted (tried to allocate 2359296 bytes) in /.../wp-content/plugins/classic-editor/classic-editor.php on line 631

We have been asked to find a workaround rather than reducing security on the server. I've searched around and not found any posts with similar issues so I'm not sure where to start. Any direction would be appreciated.


texts: Google mapping: initMap is not a function error in 5.29.1

texts:
Using Drupal 7. Maps do not display in CiviEvent, although they display fine on the Drupal site.
Console displays the below. Any ideas? Thanks in advance...

message: "initMap is not a function"  name: "InvalidValueError"
stack:
"ne@https://maps.googleapis.com/maps/api/js?&sensor=false&callback=initMap:70:72\n_.oe@https://maps.googleapis.com/maps/api/js?&sensor=false&callback=initMap:70:182\nTj@https://maps.googleapis.com/maps/api/js?&sensor=false&callback=initMap:143:238\nUj/<@https://maps.googleapis.com/maps/api/js?&sensor=false&callback=initMap:143:125\npromise
callback*Uj@https://maps.googleapis.com/maps/api/js?&sensor=false&callback=initMap:143:107\ngoogle.maps.Load@https://maps.googleapis.com/maps/api/js?&sensor=false&callback=initMap:14:12\n@https://maps.googleapis.com/maps/api/js?&sensor=false&callback=initMap:257:436\n@https://maps.googleapis.com/maps/api/js?&sensor=false&callback=initMap:257:448\n"


texts: LoadForm Popup - Uncaught TypeError: Cannot read property 'split' of undefined

texts:
In all of my custom extensions, when I use the loadForm function to load a form (generated with Civix) as a popup, I get the following error:

Uncaught TypeError: Cannot read property 'split' of undefined
at $.(anonymous function).(anonymous function).isOriginalUrl (http://dev.civicrmdev/sites/all/modules/civicrm/js/crm.ajax.js?pd7a7l:167:34)
at $.(anonymous function).(anonymous function).isOriginalUrl (http://dev.civicrmdev/sites/all/modules/civicrm/bower_components/jquery-ui/jquery-ui.js?pd7a7l:144:25)
at HTMLDivElement.<anonymous> (http://dev.civicrmdev/sites/all/modules/civicrm/bower_components/jquery-ui/jquery-ui.js?pd7a7l:256:40)
at Function.each (http://dev.civicrmdev/sites/all/modules/civicrm/bower_components/jquery/dist/jquery.js?pd7a7l:370:19)
at jQuery.fn.init.each (http://dev.civicrmdev/sites/all/modules/civicrm/bower_components/jquery/dist/jquery.js?pd7a7l:137:17)
at jQuery.fn.init.$.fn.(anonymous function) [as crmSnippet] (http://dev.civicrmdev/sites/all/modules/civicrm/bower_components/jquery-ui/jquery-ui.js?pd7a7l:236:10)
at HTMLDivElement.<anonymous> (http://dev.civicrmdev/sites/all/modules/civicrm/js/crm.ajax.js?pd7a7l:441:34)
at HTMLDivElement.dispatch (http://dev.civicrmdev/sites/all/modules/civicrm/bower_components/jquery/dist/jquery.js?pd7a7l:5226:27)
at HTMLDivElement.elemData.handle (http://dev.civicrmdev/sites/all/modules/civicrm/bower_components/jquery/dist/jquery.js?pd7a7l:4878:28)
at Object.trigger (http://dev.civicrmdev/sites/all/modules/civicrm/bower_components/jquery/dist/jquery.js?pd7a7l:5130:12)

Apparently Civi replaces the default buttons with some other buttons. This error breaks that process. I noticed this when trying to use the Shoreditch theme (my buttons disappeared).

I'm unsure how to approach debugging this. Any ideas on what would cause this with my forms loaded in popups? The standalone page loads just fine with the buttons.


texts: How does last authorize.net changes refer to CiviCRM

texts:
Lately I have received email stating that a few things are changing in Authorize.net payment. Among a few items (changing urls, longer ids, tls 1.1 force etc) one is:

  RC4 Cipher Disablement
  In an effort to ensure that all of your server-to-server communications with the Authorize.Net platform (both
  transactional and otherwise) maintain the highest levels of security,
  we will be disabling the RC4 cipher suite during the first half of
  2016. A follow-up notification will be sent out once specific dates for the disablement are ready for the sandbox and production
  environments.

  For now, if you have a solution that relies on RC4 to communicate with
  our servers, please update it to a current, high-security cipher as
  soon as possible. Please review our API best practices blog post for
  more information.

I haven't been able to find anything mentioning rc4 in civicrm authorize.net payment processor. Does anyone know if this relates to CiviCRM?


texts:
On Drupal 7 / CiviCRM 5.25 I have 2 webforms with .
Let's say
https://domain.net/subscribe?cid1=753&cs=98dfe492769469013e9bef06dbc2fb7b_1601628311_168
&
https://domain.net/update?cid1=753&cs=98dfe492769469013e9bef06dbc2fb7b_1601628311_168
If I send the links through CiviMail to a profile that is a normal (test) member, update is already pre-populated and subscribe isn't. Of course, I'm trying in an other web browser where I'm anonymous.
I can't understand why there is this difference. It's the same profile, both webforms have checksums.
Any hint about a parameter I could check, knowing that subscribe used to work until recently and the datas were auto filled?


texts: Scripts not running in contribution pages

texts:
Contribution page loads slowly and is missing the field for "total amount" . Viewing in console indicates that all scripts fail to load because the path references source path of https://xxxURL.xxx/components/com_civicrm/civicrm/bower_components/jquery/dist/jquery.min.js?r=GcFU5”.
All scripts for the page fail. The problem is obviously that the path should be: administrator/components/com_civicrm/civicrm/etc.

I've looked everywhere I can think of but don't see where that path variable is set. Civicrm.settings.php file is set correctly.

Any thoughts?


texts:
Upon opening contribution page, we get the following PhP errors showing ABOVE the contribution pages.
See JGSNY Contribution Page
Notice: Undefined index: auto_renew in /home/jgsny/public_html/administrator/components/com_civicrm/civicrm/CRM/Contribute/Form/ContributionBase.php on line 1244
ALSO:
Notice: Undefined index: auto_renew in /home/jgsny/public_html/administrator/components/com_civicrm/civicrm/CRM/Price/BAO/PriceSet.php on line 847
Auto-renewal options are off for all contribution pages; database tables have indexes on all relevant pages. Civicrm status shows OK.
Quick answers appreciated - this is membership renewal time and must have membership renewal form working.
Thanks,
Kate


texts: Can't submit credit card payment after update to 5.2.1/5.2.2 (Joomla)

texts:
I upgraded to CiviCRM 5.2.1 (on Joomla 3.8.8) and can now no longer add credit card purchases for our customers. I used to be able to log in the Joomla admin, search for the user in CiviCRM, and add an event registration to fill out the details and credit card info. But now the credit card info section is not appearing.

Upon investigating the help docs, I see there should be a "Submit Credit Card Event Registration" button there, which isn't (and I don't recall there ever being one). Searching through SE, I found an old post from a few years ago that the Payment Processor might be the issue so I created a dummy one, made it active and now that button appears. But it only works for the dummy processor and not the one we've been using for a few years now (PayPal) and it also doesn't show the credit card section. All of this works fine on the frontend of the website. We just can't register customers for them on the backend because the credit card processing section of the page is now gone.

First I go to the contact's event tab.

Then I add a new event registration and get this:

There's obviously a big open space there where the credit card block is missing. On the first screenshot you can see what it looks like when I just register a participant to an event without payment (the first row where Fee Level and Amount are empty). The second row show a previous purchase that worked fine. If I try to view/edit registrations that were successful before the update, the credit card info is there:

This shows this was working correctly until recently. So how can I get this feature back?

I should add that in 5.2.2 it seems I can get a step further, but I can't edit the full credit card number, only the last 4 digits.

Why wouldn't I be able to add the full credit card number, expiration date, etc.?


texts: Pay later instructions don't show on membership contribution

texts:
This one has me baffled. I've got a membership contribution page that works just fine with paypal standard payments (membership is processed and everything ends up correct, no problems.) It also has a pay later option. This works in so far as a pending transaction and membership is created. It does not, however, show the pay later instructions at any point to the user. It does not send any email from the contribution page, I think it should. When you manually enter payment then it will send a receipt.

I'm stuck for things to look for. I can't find any errors in any drupal logs or the civiCRM log file that look remotely relevant. There is no custom code being used anywhere, everything is straight up configuration of civiCRM. There is no customization of email templates.
 The only thing I've done that is unusual is this used to be a civiCRM installation on Joomla that has now been moved to Drupal. I thought the pay later instructions were being displayed correctly when I fist did the transfer to Drupal, but maybe I saw things that were not there, not sure. I've added more extensive instructions since then and they don't show. The same instructions for pay later do show on event bookings (I've used the same text copy and paste.) Pay later works as expected on the events and sends emails and everything.

The civiCRM version currently running is 4.7.2 after just upgrading from 4.7.1 - there was no change with this upgrade.

Any ideas on where to look next? Do I need to turn on debugging and stat looking for things that way? Is there an obvious answer I've overlooked? I welcome all ideas.


texts: Return-Path vs. unsubscribe and X-CiviMail-Bounce

texts:
Is there any reason that Civi would set unsubscribe and X-CiviMail-Bounce properly, but set return-path to reply-to instead? See the (modified) headers below.

We changed mail servers not too long ago, and since then our bounces are suddenly going to our reply-to address rather than our bounce address. Host says this is being done by the client (ie civi), rather than the mailserver, but the timing is odd since it worked fine prior to change in mail server.

I don't think we made other configuration changes that would account for this.

Any help in debugging this would be much appreciated.

Civi 4.2.6 Drupal 7.16 (yes we are planning to upgrade)

Headers

Delivered-To: [someaddress@somewhere.com]
Received: by [mailserverip] with SMTP id xxxx;
        Thu, 18 Jun 2015 06:29:50 -0700 (PDT)
X-Received: by [receiving server] with SMTP id yyyyy;
        Thu, 18 Jun 2015 06:29:50 -0700 (PDT)
**Return-Path: <info@ourorganization.org>**
Received: from [ourmailserver] ([our mail server ip])
        by [receivingmailserver] with ESMTPS id [receiving mail servicer id]
        for[someaddress@somewhere.com]
        (version=TLSv1.2 cipher=xxxxx bits=128/128);
        Thu, 18 Jun 2015 06:29:50 -0700 (PDT)
Received-SPF: pass (xxxxx) client-ip=xx.xx.xx.xxx;
Authentication-Results: xxx;
       spf=pass (xxxxxxxxxxxx) smtp.mail=xxx
Received: from [xx.xxx.xx.xxx] (helo=[ourwebserver])
    by [ourmailserver] with esmtpa (Exim 4.72)
    (envelope-from <info@ourorganization.org>)
    id 1Z5Zt7-0003cp-JQ
    for info@ourorganization.org; Thu, 18 Jun 2015 13:29:49 +0000
Message-Id: <E1Z5Zt7-0003cp-JQ@mailserver>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="=_abd6aac4c1ae6db13534624f06413403"
Reply-To: "US" <info@ourorganization.org>
From: "NY-BEST" <info@ourorganization.org>
Subject: Next Week! Conference
**List-Unsubscribe: <mailto:ourbounce+u.2505.397854.8d11b042631c3439@ourserver.com>**
To: Admin User <info@ny-best.org>
Precedence: bulk
**X-CiviMail-Bounce: ourbounce+u.2505.397854.8d11b042631c3439@ourserver.com**
Date: Thu, 18 Jun 2015 09:30:08 -0400


texts: Transactions with fee amount don't show up properly in batches

texts:
I ran into an issue the other day on a client site with how transactions with fees show up in batches. I wanted to be sure it wasn't unique to their instance so I deployed a fresh CiviCRM 4.7.20 instance to test it out. It appears related to this ticket. What happens is that when you enter a transaction with a fee it shows in the batch as two separate transactions. One for the full (not net) amount of the transaction and one for the fee amount. Meaning that the batch total is more than the actual cash received. I've created a short video demonstrating it here.
Am I doing something wrong here or is this just a bug?


texts:
I saw this thread: Is Vanco a supported payment processor?

However the phrase is "will work through 4.4". Does this mean this is a stable, PCI compliant version of Vanco's processor for 4.4? Or should I revert back to 4.1 of civiCRM in order to be stable and PCI Compliant? I was a little worried since the 4.4 version was not publicly available.

Thanks for the feedback.


texts: Using custom fields to store secondary addresses

texts:
As of now only primary address of a contact is searchable in advanced search. Search is not possible for other addresses of the same contact. So I want the other addresses of contact also searchable. Can I use custom fields for other addresses apart from primary?

What are the problems that can come up because of this approach ?


texts: Contribution Summary can't be filtered by payment method

texts:
I wonder why Contribution Summaries can be filtered on pretty much everything but not on the payment method, even though payment method (check, bank, cash...) is a mandatory input...
Do I miss something and there is a way to do it?


texts: Wordpress main search widget - Search events

texts:
Does the search widget in wordpress integrate with CiviCRM.  I need for people in mi site to be able to search for events in a particular city. For example if I have an event in Miami and someone searches in main site for Miami all events in that city to show up.

Is that possible???


texts: How would we retroactively add a personal Campaign Page?

texts: When our organization set up our event, we forgot to enable the option for participants to create personal campaign pages. Now, we have several participants who have already registered, but who don't have their personal campaign pages (which they need). How do we add/set up PCPs for them when they've already registered?


texts: Missing more menu options three dots/vertical ellipsis (⋮) within administration interfaces

texts:
I've created some custom data and fields that I now need to delete, but I don't see any options for deletion- only the option to add. Also, I'm unable to edit a custom data group once it's created.
I've also noticed additional administration options are also missing in other CiviCRM administration interfaces e.g. membership renewal, delete, auto-renewal and billing detail options.


texts: CiviMail: How to make url tracking not default?

texts: We're using CiviCRM 4.7.15 and want to uncheck the url tracking checkboxes in CiviMail per default. Disabling them by pure JS/jQuery is a bit hacky due to the fact that CiviMail uses angular. What's the best way to achieve this?


texts:
I received a notice from authorize.net telling of changes to the interface. I did not see any comments so I thought I would ask the question. Does the connections to civicrm require any updates because of:

Akamai SureRoute
Transaction and Batch ID
RC4 Cipher Disablement


texts: Is it possible to apply multiple discount codes to an event registration?

texts: We have an event that has an early-bird discount and a separate discount for returning participants. I created 2 discount codes. Both work individually, but if I enter one and then the other, only the 2nd one is used. Is there a way to use both discounts?


texts: Console error with Google Plus and "Help spread the word"

texts:
I was testing a contribution form today and noticed an error in the console on the thank you page. I'm guessing it is related to the Google Plus portion of the "Help spread the word" section, but am not certain. The site does also have a Google Plus URL set as rel="Publisher" using the Metatag module (Drupal).

If I leave the page open and the console open, this error just keeps recurring again and again:

Refused to display...in a frame because it set 'X-Frame-Options' to 'SAMEORIGIN'

What would cause this?


texts: CiviCRM User Summit Sept 2016 - Any last minute ideas on how to convince another 20 people to register

texts:
CiviCRM User Summit - Any last minute ideas on how to convince another 20 people to register?

The Summit is September 24 & 25  See: https://civicrmusersummit.org/

What would make you want to come?


texts:
I just upgraded CiviCRM to the latest version with Drupal 7 on a duplicate test installation and now when I select a time slot in the "Select Resources (Step 1 or 3)" screen and the pop-up appears, I find no options available in the "Configuration" selection drop-down. I cannot complete a booking.

I have options set up that have been used a long time, but interestingly, if I edit an option and then save it, it becomes immediately disabled and the "enable" checkbox is grayed out, not allowing me to enable it.

I have gone to the database and forced it to be enabled in the booking_config_set table, but every time I edit it in CiviCRM, it becomes disabled again.

I created a brand new config set, but it behaves the same way and still nothing displays as a configuration drop-down option when I try to make a booking. I'd just like some idea what the problem might be and where I might start to resolve this?


texts: Word Press Install Missing civicrm.settings.php; dashboard unavailable; no menus

texts:
I have a problem that appears to be similar to this post:
https://forum.civicrm.org/index.php?topic=34290.msg145436#msg145436

I'm in the middle of setting up an evaluation instance of CiviCRM within my staging WordPress environment.  I used FTP to upload all files and folders into a newly created civicrm folder within the wp-conten/plugins folder.  It appeared as a plugin and i clicked "activate", which seemed to go well.  I followed the link to configure, validated ddatabase information, clicked "Verify and Install" (or whatever it was) and it seems to have run without issue, except that I can't proceed with step 6 of the install instructions.  All prerequisites were met.

I have no civicrm.settings.php file to backup (or even view).

When I click on the "CiviCRM" link in the main navigation, I get a page that looks like this:

Note there's an error, but when I click on the error link it doesn't tell me anything.  Figuring perhaps I'll just proceed without backing up the file, step 7 talks about performing functions I don't have available to me in this state.

I'm stuck.  I've tried this twice, and both times the results are the same (thinking perhaps I missed a step earlier, which is still quite possible, but I don't think so after doing it twice).

Any help would be appreciated.

WordPress Version: 4.4.2
PHP Version: 5.5.9-1ubuntu4.14

Clicking on "Refresh Dashboard Data" first couple of times didn't do anything, but the 3rd time it gave me the following in a red box:
System Status: Error
Cron Not Running
Configure Default Mailbox
Complete Setup

The link to "View details and manage alerts" didn't render anything.


texts:
Civi 4.4 still w/WP 4.7 (which is using https/secure URLs w/a plugin 'https') - I tried setting base url to 'www.mysite.org' as opposed to 'mysite.org' and saving but my change isn't saved.
FYI I am using https: in effect for all civi pages, but I can't seem to set this in Admin settings.  My .htaccess file allows for www or not


texts: save contact with non numeric phone number gives access denied civicm_strip_non_numeric

texts:
I recently update civicrm till 4.6.2 till 4.6.4 on drupal 7.38, mariadb 5.5.41.
When saving a contact with a non numeric phone number (+32 123456798) I got the error:

Database foutcode: execute command denied to user 'civicrm-db-user'@'localhost' for routine 'civicrm-db.civicrm_strip_non_numeric', 1370

Array
(
[callback] => Array
    (
        [0] => CRM_Core_Error
        [1] => handle
    )

[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => INSERT INTO civicrm_phone (contact_id , location_type_id , is_primary , is_billing , phone , phone_ext , phone_type_id ) VALUES ( 26 ,  1 ,  1 ,  0 , '+32' ,  NULL ,  1 )  [nativecode=1370 ** execute command denied to user 'civicrm-db-user'@'localhost' for routine 'civicrm-db.civicrm_strip_non_numeric']
[type] => DB_Error
[user_info] => INSERT INTO civicrm_phone (contact_id , location_type_id , is_primary , is_billing , phone , phone_ext , phone_type_id ) VALUES ( 26 ,  1 ,  1 ,  0 , '+32' ,  NULL ,  1 )  [nativecode=1370 ** execute command denied to user 'civicrm-db-user'@'localhost' for routine 'civicrm-db.civicrm_strip_non_numeric']
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_phone (contact_id , location_type_id , is_primary , is_billing , phone , phone_ext , phone_type_id ) VALUES ( 26 ,  1 ,  1 ,  0 , '+32' ,  NULL ,  1 )  [nativecode=1370 ** execute command denied to user 'civicrm-db-user'@'localhost' for routine 'civicrm-db.civicrm_strip_non_numeric']"]

)

I found the solution in adding the "execute" privilege to my civicrm-db user in mariadb using phpmyadmin.

I have a second civicrm db (non related to my first) still on the old version 4.6.2 which has no issues at all. I has no "execute" privilege and does not need it.

Civicrm doc (http://forum.civicrm.org/index.php?topic=23489.0) does not mention execute privilege.

list of grants to my civicrm user:
Grants for civicrm-db-user@localhost

GRANT USAGE ON *.* TO 'civicrm-db-user'@'localhost' IDENTIFIED BY PASSWORD 'pwdhere'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE ROUTINE, ALTER ROUTINE, TRIGGER ON `civicrm`.* TO 'civicrm-db-user'@'localhost'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES ON `civi`.* TO 'civicrm-db-user'@'localhost'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE ROUTINE, ALTER ROUTINE, TRIGGER ON `civicrm-db`.* TO 'civicrm-db-user'@'localhost'

trigger rebuild did not fix the issue. (/civicrm/menu/rebuild?reset=1&triggerRebuild=1)

automatic_sp_priveleges variable = on in mariadb

Question: did I miss something in the update, does the latest version need different rights? I think I found a workaround, but not the actual error. Has someone the same issue?

Kind regards

Johan.


texts: How to use API chaining to create a contact and a relationship

texts:
I've read all the docs I could find, the code examples, the 4.6 explorer, but I'm not grasping one piece. Below is code to create a new adult contact (via profile submit, to get some extra validation for free), and multiple student contacts, each with a relationship to the adult. When chaining the relationship piece, what goes into contact_id_a and contact_id_b?

Here is the error result, calling code is at the bottom of this post:

Array
(
    [error] => Error in call to Profile_submit : Error in call to Relationship_create : contact_id_b is not a valid integer
    [error_code] => 2001
    [error_data] => Array
        (
            [error_field] => contact_id_b
            [type] => integer
            [error_code] => 2001
            [entity] => Profile
            [action] => submit
            [is_error] => 1
            [error_message] => Error in call to Profile_submit : Error in call to Relationship_create : contact_id_b is not a valid integer
        )

)

Edit: updated the code to better reflect what I'm trying to do, please see the comments on the innermost calls to create relationships:

  //build array of student details
  $student_profiles = array();
  foreach ($_POST['student_details'] AS $student_record){

    $student_profiles[] = array(
          'sequential'  => 1,
          'profile_id'  => 14,
          'first_name'  => $student_record['student_first_name'],
          'last_name'   => $student_record['student_last_name'],
          'gender_id'   =>  $student_record['gender_id'],
          'birth_date'  => $student_record['birth_date'],
          'allergies'   => $student_record['allergies'],
          'api.Relationship.create' => array (
                  'sequential' => 1,
                  'contact_id_a' => '$value.id',  //is this the valid contact ID of the student profile we just submitted?
                  'contact_id_b' => '$value.api.Profile.submit',  //how do i fix this to get the Profile.submit id from the parent's record?
                  'relationship_type_id' => 1,
                  'is_permission_a_b' => 0,
                  'is_permission_b_a' => 1,
                ),
         );
  }

    //build parent details and attach student detail array
    $parent_profile = array(
      'sequential' => 1,
      'profile_id' => 14,
      'first_name' => $'first_name',
      'last_name' => $'last_name',
      'api.Profile.submit' => $student_profiles,
    );

    //submit the main profile with all chained items
    try {
        $parent_result = civicrm_api3('Profile', 'submit', $parent_profile);
    }
    catch (CiviCRM_API3_Exception $e) {
      // handle error here
      $errorMessage = $e->getMessage();
      $errorCode = $e->getErrorCode();
      $errorData = $e->getExtraParams();
      return array('error' => $errorMessage, 'error_code' => $errorCode, 'error_data' => $errorData);
    }


texts: Civi 4.4.6 forms not working with WordPress 4.3.1

texts:
After upgrading WordPress from 4.2.5 to 4.3.1, Civi Contribution forms return a blank page after submitting (clicking Confirm Contribution).

I would rather not downgrade WP but will if I have to. I don't have the resources to upgrade Civi at this time.

I've seen some similar issues reported here but don't have a solid lead yet. I will keep looking. Any help would be greatly appreciated.


texts: Is it a bug that Relative Dates are broken in Search and Smart Groups?

texts:
According to CiviCRM user guide article's Searching section The Date Range Filter:

Relative date ranges are especially useful for searches that you would
like to then save as Smart Groups (automatically populated groups that are configured to include contacts that share a certain set of characteristics or activities).

However, it seems that it is actually impossible to use them this way, because during search relative dates (e.g. Today) are transformed into fixed dates (e.g. August 18th).
See: How to use Smart Groups with relative dates? and
smart group change log criteria
Is it a recent bug or has it been like this forever? Will there be a fix for that?


texts:
We have updated our CiviCRM to the 5.10.3 but now we have trouble with bulk email.

The checkbox buttons behave like a radio button.
So we can not have more the one bulk email address (not really useful)

For old contact the data are correct but we can not change it.

No one has this trouble?
No one has an idea to resolve it?

Thanks

Nicolas


texts: Paypal Payment Processor not connecting with CiviCRM

texts:
We used the Paypal Pro Payment Processor with Civi. It has worked well in the past (including last month). After the last update they are no longer working properly. However, the payment processor is taking the actual payment.

For example I went through our donation page and donated $1.11. On hitting submit I received this error

On the CiviCRM End I received this error failing to update database.

However, on the Paypal end the payment went through. I received a notification from Paypal indicating I received a donation of $1.11.

So, something is happening on the Civi end of things but I don't know how to fix this error.

Here are the errors:

CRM_Core_Exception: Failed to update contribution in database in /var/www/html/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Confirm.php on line 2336
Exception trace
#
Function
Location

0
CRM_Contribute_Form_Contribution_Confirm->completeTransaction(Array, 99)
/var/www/html/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Confirm.php:2336
1
CRM_Contribute_Form_Contribution_Confirm->processFormSubmission('6')
/var/www/html/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Confirm.php:716
2
CRM_Contribute_Form_Contribution_Confirm->postProcess()
/var/www/html/sites/all/modules/civicrm/CRM/Core/Form.php:447
3
CRM_Core_Form->mainProcess()
/var/www/html/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Main.php:1314
4
CRM_Contribute_Form_Contribution_Main->skipToThankYouPage()
/var/www/html/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Main.php:1048
5
CRM_Contribute_Form_Contribution_Main->postProcess()
/var/www/html/sites/all/modules/civicrm/CRM/Core/Form.php:447
6
CRM_Core_Form->mainProcess()
/var/www/html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php:169
7
CRM_Core_QuickForm_Action_Upload->realPerform(Object(CRM_Contribute_Form_Contribution_Main), 'upload')
/var/www/html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php:136
8
CRM_Core_QuickForm_Action_Upload->perform(Object(CRM_Contribute_Form_Contribution_Main), 'upload')
/var/www/html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php:203
9
HTML_QuickForm_Controller->handle(Object(CRM_Contribute_Form_Contribution_Main), 'upload')
/var/www/html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php:103
10
HTML_QuickForm_Page->handle('upload')
/var/www/html/sites/all/modules/civicrm/CRM/Core/Controller.php:351
11
CRM_Core_Controller->run(Array, null)
/var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php:310
12
CRM_Core_Invoke::runItem(Array)
/var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php:84
13
CRM_Core_Invoke::_invoke(Array)
/var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php:52
14
CRM_Core_Invoke::invoke(Array)
/var/www/html/sites/all/modules/civicrm/drupal/civicrm.module:448
15
civicrm_invoke('contribute', 'transact')
unknown:unknown
16
call_user_func_array('civicrm_invoke', Array)
/var/www/html/includes/menu.inc:527
17
menu_execute_active_handler()
/var/www/html/index.php:21
18
{main}

 Sorry but we are not able to provide this at the moment.Failed to update contribution in database
Return to home page.


texts: Font-Awesome icons not showing -- missing class=fa?

texts:
The Font-Awesome icons are not showing properly.  I believe this is because the required class "fa" is missing everywhere where one of the icons is supposed to display.  I have tested this by modifying templates/CRM/common/fatal.tpl, adding "fa" in the appropriate place in line 49.  Without the fa class the browser shows a blob character; with the fa class the correct icon shows as desired.  Quite a number of templates are affected (assuming I am correct).

I'm running CiviCRM 4.7.23 (with no local customization) on Drupal 7.56.


texts: How can I produce a summary report for one or more projects in CiviVolunteer?

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

The positives:

Projects are linked via Activities in sympathy with the overall CiviCRM design philosophy.

Once two bug fixes were applied, it now works as specified - all good.

The negatives:

The Volunteer subclass of Individual has popped up but is not used by CiviVolunteer for the actual volunteers. This is a bit confusing and instructions in our User Guide (thank you Echo Plugins for Knowledge Base for Documents and FAQs) are the way that we have dealt with this.

The Volunteer reports don't expose the two relationships (Owner or Manager).

The overall reporting system of CiviCRM doesn't appear to support (out of the box) summarisation of rows (e.g. a count of rows, a sum of values from a row, etc.).

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

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

The question is, how can I produce a report with fields: Project Name, Manager Name, Owner Name, and Number of Volunteers?

Regards,

Rob.


texts: How can I disable the JQuery date widget and all just text input?

texts:
CiviCRM 4.7.3 Worpdress 4.4.2

Due to issues with the JQuery date widget (e.g. Month and year, or year only formats are not saved and date list only goes back 10 years), I would like to simply disable it to avoid any confusion.

Is there an easy way to do this?


texts: All search modes redirect me to search page over and over.

texts:
The problem: Every time I try to use any of the search functions (Find contacts, Advanced Search, full-text searh, etc), I fill out the fields, and when I hit "search", it takes me back to the blank search form.

Background:
We recently changed service providers and hosting for our entire site. At first, it seemed like CiviCRM did not get moved over, I was getting error messages like this:

Eventually, the IT service we work through (who arent specific to CiviCRM), got it to this:

Finally, he decided to instead uninstall and re-install CiviCRM. This worked, except he was then having trouble importing the existing Civi database. At this point the search was working, because I could use "Find Contacts", leave it blank and get two entries (the user doing the installation, and the organization I work for).

I know he has finally been able to import the database, because if I use the corner quicksearch, i can look for  each individual contact, no problem, but trying to get a list of contacts has become impossible.

I've looked through the old forum and previous stack exchange questions but havent found anything. Any help, or pointing in the right direction would be greatly apprecieated!!!


texts: Saving a contribution adds a line with negative the tax amount, when using an event price set

texts:
I replicated this issue in the demo wordpress account. If one creates a paid event with a financial type that includes taxes, enters a price (without using price sets) and books a person, then opening the contribution and clicking the 'save' button behaves correctly.

The problem appears when the event price is a price set. Each time one opens the corresponding contribution and clicks 'save', a new accounting line is created with negative the amount of taxes.

Example after opening and saving several times:
(the total amount should be 400 SEK, but now it say 14 SEK)

This happens when the price set is used with an event, but also (at times) when directly creating a contribution with the same price set as above, but without registering to an event.


texts:
I just have activated front end editing at our test site (civicrm 5.10.2 and joomla 3.9.3)because some volunteers need a clean and simplified view to the sytem to edit contacts.

Performing a search in the fronted works fine, but selecting a user to be edited, the newsletter profile for the current user (log in user) shows between the user menu and the selected user data set. I digged around but could not find any setting to avoid this behavior, not in profiles nor other items so far.

This behavior is very disturbing and can not be accepted for a productive system. Do you have any hint about hiding this in editing view?

Thank you very much!

Bert Zimpel


texts: How to trigger a confirmation email when registering participants via API

texts: We have a custom module that we use to do event registrations (non - paid), however i was wondering is there anyway through the API of being able to trigger CiviCRM sending a confirmation registration email when we submit the registration via API?


texts:
I am facing deadlock on civicrm_acl_cache.
I am sending email to 400,000 users.
Many times, deadlock occur and due to system lock website goes down.

Need help from team


texts:
It seems that hook_civicrm_alterCalculatedMembershipStatus is the right place for adding various actions based on Membership change. It looks like there is some issue with $membership array from the calling function.
I v'e started the hook exploration with the code below:
mail('my@email', 'title', print_r($membership, true));

and get two emails with different arrays (with 6043 part is being changed instantly):
[custom_2_6043] =>
[custom_4_6043] =>
[custom_5_6043] =>
[custom_7_6043] =>
[custom_10_6043] =>
[custom_11_6043] =>
[custom_12_6043] =>
[custom_94_6043] => 0
[custom_19_329] =>

and
[custom] => Array
        (
            [2] => Array
                (
                    [6043] => Array
                        (
                            [id] => 6043
                            [value] =>
                            ...
                        )

                )

            [3] => Array
                (
                    [6043] => Array
                        (
                            [id] => 6043
                            [value] => 0
                            ...
                        )

                )
            ...
            [94] => Array
                (
                    [6043] => Array
                        (
                            [id] => 6043
                            [value] => 0
                            ...
                        )

                )

Since we aim to perform an additional action based on a custom field value, it seems a bit tricky to catch custom field by its key without searching by field key in array or as a part of a [custom_KEY_6043] string. Besides, if there are  two emails, it might mean the hook is being executed twice.
Am I taking right direction here? What would be the simpliest way of getting
if field value is X [then do Y]

Please advise.


texts: Contact type is read only in contact summary

texts: Why is the contact type read only in the summary tab for a contact? The 'contact_type' field is easily edited directly in the database, but I can't find a built in civicrm form to do this.


texts: iAmAnIntentionalENoticeThatWarnsOfAProblemYouShouldReport and other event registration warnings in 4.7.1

texts:
On the Find Participants page for an event:

Warning: array_keys() expects parameter 1 to be array, null given in CRM_Utils_Array::formatArrayKeys()

In the Drupal log, lots of these:

Notice: Undefined variable: iAmAnIntentionalENoticeThatWarnsOfAProblemYouShouldReport in CRM_Contact_BAO_Query::buildClause() (line 5382 of /home/[site]/public_html/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php).

And these:

Cache rebuild lock hit: event_init

And when viewing a contact, these:

Warning: array_keys() expects parameter 1 to be array, null given in CRM_Utils_Array::formatArrayKeys() (line 1037 of /home/[site]/public_html/sites/all/modules/civicrm/CRM/Utils/Array.php).

And these:

Notice: Undefined variable: onlySubType in CRM_Custom_Form_CustomData::setGroupTree() (line 163 of /home/[site]/public_html/sites/all/modules/civicrm/CRM/Custom/Form/CustomData.php).

And these:

Warning: Missing argument 4 for CRM_Custom_Form_CustomData::setGroupTree(), called in /home/[site]/public_html/sites/all/modules/civicrm/CRM/Custom/Form/CustomDataByType.php on line 56 and defined in CRM_Custom_Form_CustomData::setGroupTree() (line 153 of /home/[site]/public_html/sites/all/modules/civicrm/CRM/Custom/Form/CustomData.php).

It looks like these are related to paid event registration - the client is complaining that the transactions (using Authorize.net) are taking a long time to process and are even timing out.

It looks like going to 4.7 was a big mistake, but now I'm stuck - any ideas? And help greatly appreciated...


texts: Error in CiviCRM for Drupal7 after Migrate from "Backup and Migrate" module on New Contact Form

texts:
After I did a Backup and Migrate to a new system, I am getting two errors on any New Contact form. They are as follows:

Notice: Undefined property: CRM_Core_BAO_Tag::$tree in CRM_Core_BAO_Tag->getTree() (line 75 of /sites/all/modules/civicrm/CRM/Core/BAO/Tag.php).

Warning: Invalid argument supplied for foreach() in CRM_Contact_Form_Edit_TagsAndGroups::climbtree() (line 203 of /sites/all/modules/civicrm/CRM/Contact/Form/Edit/TagsAndGroups.php).

I also noticed that the tag box at the bottom of the page under "Tags and Groups" has gone missing. Is there any way to fix this problem without starting from scratch?


texts: Drupal Views in CiviCRM Dashlets -- Network Error

texts:
I've created a Drupal View as a CiviCRM Dashlet. I can access it if I go directly to the path.  I can select it and pull it onto my dashboard, but I can't access data on my dashboard. I get Network Error -- Unable to reach the server. Please refresh this page in your browser and try again.

CiviCRM version 4.7.16
Same dashlet works with Version 4.7.6


texts: Add custom data field column to contribution tab

texts: Is there a way to add additional fields in the contribution tab on a contacts record?


texts: If Tag(s) field is in a Profile that is used for Batch Update it shows no results - and removes all existing Tags when updated

texts:
I can add Tags field to a Profile

I can then use that Profile for bulk updates

The Tags field shows as empty on the screen (and hence is easily ignored/overlooked)

Upon save ALL tags are removed from all those Contacts.

Sadness ensues and it rains a lot and your favourite team is kicked out of the FIFA World Cup.

If the Tags field is not safe to be used on Profiles used via Batch Updates then

should we prevent Profiles that have the Tag field from being available via Batch Update or
should the field show the actual Tags, so it just 'saves' them
something else?

Whatever the solution, the current situation destroys data and needs a fix


texts:
Is it possible to make the size of the field run_frequency in the table job greater?
It is now 8, but if would be 10 then the translation for 'daily' will not be truncated (not for me in this case).


texts: Donation summary report (Repeat) gives error Incorrect integer value: 'text string' for column 'source' at row 1

texts:
Drupal 7, CiviCRM 4.7.27, using the standard report "Donation summary report (Repeat)", I'm getting an unexpected SQL error

Incorrect integer value: 'my custom source string' for column 'source' at row 1

This is a bit weird, since the source field is from the contributions table (it's doing some kind of subquery).

Anyone else seeing this? I thinking it's some kind of sql escaping problem.


texts: Civicrm is not reading my custom css file (WordPress)

texts:
I put a custom css file in [custom.files]/custom/ (wp-content/uploads/civicrm/custom/)  and it is not being read. I tested the same test entry in the civicrm/civicrm.css and it works there.
The entry for Resource URLs Custom CSS URL is [civicrm.files]/custom/
I cleared the cache for civicrm and Wordpress and it doesn't help.
I'm using WordPress 5.6 and civicrm 5.32.2.


texts: I have set up a profile for an event we are running but one of the fields is not appearing and I am not sure why. When I view the preview it is there but not showing on the booking page for the event. It is the Participant - Access Requirements field.  Any advice appreciated!


texts: unexpected extensions listed in system status

texts:
Anyone any idea why I have the following extensions listed in System Status as being up-to-date in addition to the ones I expect?
Contribution cancel actions: Version 1.0
Event Cart: Version 1.0
Financial ACLs: Version 1.0
Theme: Greenwich: Version 1.0
Sequential credit notes: Version 1.0

I haven't knowingly installed them. They aren't listed under System Settings > Extensions and there is nothing for them in the uploads/civicrm/ext directory. I have cloned the site, updated from 5.26.2 to 5.33.1, updated UK Gift Aid extension and installed (and now uninstalled to check) Civirules extension. Before I re-run the process (to find out if I have done anything stupid by mistake, I wonder if anyone else has seen anything like this. Not event sure what some of them are.
I'm on WordPress.


texts: Create Event API - Scheduled Reminder ignored?

texts:
when i create an event from a template some tabs are ok (prices, online registration) but Scheduled Reminder tab is always not copied and empty. Its' a Bug or a Feature ? My call is like this :
$results = \Civi\Api4\Event::create()
  ->addValue('template_id', 92) <---- this is my template with SR set
  ->addValue('title', 'new event')
  ->addValue('start_date', '2020-11-20 00:40:00')
  ->execute();
foreach ($results as $result) {
  // do something
}


texts: Billing Address - Can i turn off saving billing addresses?

texts: When someone pays by credit card it stores their billing address to the contact record. We are using auth.net for credit card payments. Is there a way to turn this off? I do not want to store billing addresses on each contact record.


texts: How to update changes in a custom base Mosaico template?

texts:
We've developed our own Mosaico base template for use in CiviCRM. We've made some changes to the base template and updated the template file on our site, however, when trying to use the modified base both new and existing templates aren't updated with our new style tweaks.

Is there a way to flush Mosaico so it re-reads and uses the updated base template?


texts: New twist on "Could not find valid value for id" event registration error

texts:
I'm aware that this has been asked (and sort of answered)
Front end event registration works fine but after confirmation screen the error message below appears
But this time I can fix it by disabling a plugin called geodirectory

Ideas anyone?
Running 4.7.10 on Wordpress and yes basepage is set.

backTrace:

#0 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(367): CRM_Core_Error::backtrace()
#1 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Request.php(120): CRM_Core_Error::fatal("Could not find valid value for id")
#2 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Event/StateMachine/Registration.php(52): CRM_Utils_Request::retrieve("id", "Positive", Object(CRM_Event_Controller_Registration), TRUE)
#3 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Event/Controller/Registration.php(47): CRM_Event_StateMachine_Registration->__construct(Object(CRM_Event_Controller_Registration), TRUE)
#4 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(307): CRM_Event_Controller_Registration->__construct("Event Registration", TRUE, "null", NULL, "false")
#5 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:15))
#6 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))
#7 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm.php(1227): CRM_Core_Invoke::invoke((Array:3))
#8 /home/leepngo/public_html/wp-content/plugins/civicrm/includes/civicrm.basepage.php(132): CiviCRM_For_WordPress->invoke()
#9 [internal function](): CiviCRM_For_WordPress_Basepage->basepage_handler(Object(WP))
#10 /home/leepngo/public_html/wp-includes/class-wp-hook.php(298): call_user_func_array((Array:2), (Array:1))backTrace

#0 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(367): CRM_Core_Error::backtrace()
#1 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Request.php(120): CRM_Core_Error::fatal("Could not find valid value for id")
#2 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Event/StateMachine/Registration.php(52): CRM_Utils_Request::retrieve("id", "Positive", Object(CRM_Event_Controller_Registration), TRUE)
#3 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Event/Controller/Registration.php(47): CRM_Event_StateMachine_Registration->__construct(Object(CRM_Event_Controller_Registration), TRUE)
#4 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(307): CRM_Event_Controller_Registration->__construct("Event Registration", TRUE, "null", NULL, "false")
#5 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:15))
#6 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))
#7 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm.php(1227): CRM_Core_Invoke::invoke((Array:3))
#8 /home/leepngo/public_html/wp-content/plugins/civicrm/includes/civicrm.basepage.php(132): CiviCRM_For_WordPress->invoke()
#9 [internal function](): CiviCRM_For_WordPress_Basepage->basepage_handler(Object(WP))
#10 /home/leepngo/public_html/wp-includes/class-wp-hook.php(298): call_user_func_array((Array:2), (Array:1))
#11 /home/leepngo/public_html/wp-includes/class-wp-hook.php(323): WP_Hook->apply_filters("", (Array:1))
#12 /home/leepngo/public_html/wp-includes/plugin.php(515): WP_Hook->do_action((Array:1))
#13 /home/leepngo/public_html/wp-includes/class-wp.php(746): do_action_ref_array("wp", (Array:1))
#14 /home/leepngo/public_html/wp-includes/functions.php(955): WP->main("")
#15 /home/leepngo/public_html/wp-blog-header.php(16): wp()
#16 /home/leepngo/public_html/index.php(17): require("/home/leepngo/public_html/wp-blog-header.php")
#17 {main}
Sorry but we are not able to provide this at the moment.
Could not find valid value for id
Return to home page.


texts: Importing membership custom field keeps failing

texts:
I'm having problems importing memberships with a custom field. I'm able to import a alphanumeric text field without an error, but a second custom field, set up as a checkbox, keeps being rejected.

The import CSV file originally had the option label in that field, but after changing this to the option value, the import is still rejected as invalid. What might I be missing here?

The original import error reads 'Invalid value for field(s) : Income; Income'

When I change the relevant fields to the correct value 'LowIncome' (having double checked that it's the value stored in the database), the import error reads:

'1' is not a valid option for field custom_33

Which is technically correct, but none of the fields in the imported file contain '1', so I don't know where it's getting this from!

Because there's only the one option, I'm pretty sure I can swap this out for a Yes/No field and try it again, but I'd rather pin down why this is happening - I also have some activities to import with multi-option checkboxes, and I'd rather know they'll work...

ETA: I've tried adding in another field, where the option label, value and name are all the same ('Test'), and importing it - It gets flagged in the same way - '1' is not a valid option for field custom_34

I also tried adding a yes/no field, and that imports okay, so I'm probably going to switch this particular field to a yes/no, but as I say, I'm concerned that it's going to reject other multichoice fields, and I'd still like to pin down the problem. I will try importing some of the activities, and update this when I know how it's behaving.

ETA2: This seems to be happening for any checkbox field, regardless of what the custom data set is used for, and isn't limited to fields with single checkboxes. I'm able to reproduce the problem in the master demo site, and importing from my new installation to the older version of CiviCRM also comes up with this error.

I've found a issue on the old bug tracker site that seems very similar in 4.7/4.7 - https://issues.civicrm.org/jira/browse/CRM-17493 - and although it's marked as fixed, it looks a little as though the fix was never implemented in 4.7 - the last git pull request is marked as closed with the note 'Unclear if a fix is required or not': https://issues.civicrm.org/jira/browse/CRM-17493 (but it's also not entirely equivalent to the problem I've been having)

Failing any further ideas as to what I might be doing wrong, I'll raise it as a bug.


texts: Custom emails automatically generated based on participants filling in drupal forms

texts:
Hi to all and thanks in advance.

I'm on Drupal 7 and Civi 5.20.2. I have the CiviRules and EmailAPI (CiviCoOp) extensions as well as Mosaico.
We have participants to our events that apply for funding (either travel, accomodation or both) through a Drupal (Civi Powered) form.
I need to be able to send automated user tailored emails when they submit the form.

Like

Dear {user},
Thank you for aply for funding for {event title}. We are considering your {type_of_funding} application and we will get back to you sortly.
Kind regards...

I can get the event to triger through CiviRules and EmailAPI, but I cannot (or more correctly do not know) how to create an email template that can feed of the {xxx info xxx} when the specific rule runs, so the email is user specific and friendly.

Kind regards
Aris


texts: CiviCRM Webform - enforce ACL permissions

texts:
I'm building a webform to create activities against existing contacts. I want to make it so that the user completing this webform about an existing contact can only use it on contacts that are legitimately accessible to them via the ACL. Otherwise you get a message saying no and you can't fill in the form.

Obvs I could do this in a hook, but I bet it's functionality that other people would love.

So rather than fumble and hack around, I'm asking the community, where in webform_civicrm would be the best place for this to go? Any other tips/advice/general suggestions?

Thanks,


texts:
Just hit a few cases where it would be great to have a contact with exact same status eg event, member, relationship, contribution, and of course custom fields on contact and those other entities etc so we can 'test' a fix on.

Might not need to clone 'everything' eg Activities, since I can see complexity bursting forth.

Anyone else looked at doing this? Any thoughts about (im)possibility of doing this?


texts: How do I add a new table to my extension?

texts:
I have added tables to my database by writing SQL commands in a sql folder as specified in the given link.
Add a database upgrader / Installer / uninstaller.

What I am exactly looking for is a method to access these tables, do I need to write direct SQL for adding records to the table or I should create corresponding DAO and BAO to access the table.

How to create DAO and BAO for a given table in an extension?


texts: Civi does not email to some contacts (Not CiviMail, just mail)

texts:
We've got some contacts in a search result. Selecting all or checking "All x contacts" and choosing "Email - send now (to 50 or less)" leads to the email screen stating that three of the contacts won't receive the mail. But all of the possible reasons (is_deceased, do_not_email, ...) aren't true. The db says:

select do_not_email, is_deceased, is_opt_out from civicrm_contact where id = x;
+--------------+-------------+------------+
| do_not_email | is_deceased | is_opt_out |
+--------------+-------------+------------+
|            0 |           0 |          0 |
+--------------+-------------+------------+

select email, is_primary, on_hold from civicrm_email where contact_id = x;
+--------------------------------+------------+---------+
| email                          | is_primary | on_hold |
+--------------------------------+------------+---------+
| m.muster@domain.tld            |          1 |       0 |
+--------------------------------+------------+---------+

The contacts in question are able to receive emails if triggered by »send email«-action in contact's summary and even when selected in the result's list. The problem occurs only when sending to bunch of contacts.

Their email addresses seem valid and do not contain crazy chars.

I just can't find any reason why civi sorts such contacts out. I've read

Why are contacts not receiving emails when do not email not checked? and
Which contacts in a mailing group are NOT recipients of a mass mailing?

But nothing helped. Any ideas?


texts: is there a way I could add the "Send an Email" activity to the CiviCase timeline? I was hoping to file an activity in the timeline so that x number of days from the Open Date, the user can "Send an Email" via an email template.


texts: "MySQL support not included in PHP error" in CiviCRM-4.7.10-wordpress

texts:
I'm getting the error "MySQL support not included in PHP" in the CiviCRM installer wordpress page.

My setup is:

Ubuntu 16.04
Wordpress 4.6.1
CiviCRM 4.7.10
php 7.0 with mysqli php extension installed

I checked that mysqli is indeed loaded by running

php -r 'echo extension_loaded("mysqli") ? "loaded\n" : "missing\n";'

Any ideas about what could be wrong? What else can I check?


texts: How to fetch activity including custom fields using API

texts:
I hope this is a useful question + answer. I feel it's necessary to document some, um, quirks, of the API v3 around Activities and custom data, because as a developer this took me ages to figure out.

I want to fetch all the details of a single activity, including custom fields.

Currently (4.6.7):

The normal activity get methods omit the custom fields.
You can get the custom fields using some voodo, but then you don't get all the standard fields.


texts: How to show the City (Location) of Events in Event Lists using Drupal Views

texts:
We need to show a list of upcoming events on our website. For this I have installed and integrated the Drupal Views module. The Events List in Views works like a charm except for one thing.
We would also like to display the city of the Location where each Events is being held in the list. Unfortunately I can not find this field when clicking the Add field button in the Views create Display page.
How to go about? Am I missing something?

Many thanks for your kind attention.


texts: Activity assignee email not being sent from webform

texts:
Emails are not being sent out from a CiviCRM webform to the activity assignee. Not sure why but there is a notice in Drupal: -

Notice: Undefined index: act in wf_crm_webform_postprocess->processActivities() (line 1250 of /home/xxxxx/public_html/sites/all/modules/webform_civicrm/includes/wf_crm_webform_postprocess.inc).

Can anyone help?


texts: Has anyone created a mobile responsive email newsletter template to work with Civimail? If so, can you please share the link to an example of the email newsletter which uses the template? If you have suggestions for how to create it easily, please share some tips. Thank you!


texts: Image / file upload issue on civivolunteer public form

texts:
I am just wondering if file uploading (image) is supported in CiviVolunteer as I am having an issue where attaching an image to a volunteer signup form is not being captured / displayed on the view contact details page.

Is this possibly a bug or just not supported by CiviVolunteer?

For clarity on what I have done so far and the results I am experiencing.

We want to add a file upload option on volunteer sign up page that allows the volunteer to add a picture of themself.

So I created a new custom field (file upload) and assigned it to a volunteer application form profile with expected results.
i.e: Field is displayed on public form and also available on the contact record.

However, once the form has been submitted and the new contact created the image is not available on the contact details page.

I assumed the image would be rendered next to the label or possibly a link to view elsewhere.

When editing the contact details from within Civi I am able to upload an image and then upon saving it is rendered on screen.
So it seems that the file upload is working but just not via the public form.

Tested with CiviCRM 5.13.5 and Master branch of Volunteer.

I have attached screenshots to detail what is going on.

Thanks.


texts: Attempting to add a new Contact, why do I get this error message - 'Warning: htmlspecialchars() expects parameter 1 to be string'?

texts:
I'm getting this error message when attempting to add a new contact in Civi 4.6:

Warning: htmlspecialchars() expects parameter 1 to be string, object given in krumo::_array() (line 1071 of /var/www/[myCivisite.org]/sites/all/modules/devel/krumo/class.krumo.php)


texts: Is there an easy way to find out who created an event like how we are able to see who created an email?


texts: Is there an autorespond email function for profile form sign ups (wordpress)?

texts:
I have a sign up form that adds users to a group- essentially a mailing list which also saves other information about the subscriber. It's a civiCRM 'profile' form.

This all works OK. A user adds their information to the form and their information is saved in a group called members. Now my client would like to automatically email them when a new user signs up. There doesn't seem to be any way to do this 'out of the box'. Someone has raised this issue with regards to Joomla before HERE. But, being reasonably new to web development and civiCRM and don't know how to do this with my WORDPRESS installation.

I think you have to do something with hooks and create a wordpress plugin? http://wiki.civicrm.org/confluence/display/CRMDOC/Hook+Reference

I guess I'm wondering whether someone has already done this? OR they can point me to instructions that a newbie may be able to understand?

I'm using wordpress 4.1.5 and civiCRM 4.6.2


texts: Wordpress role permissions to access (administer) their cases?

texts:
I have a "volunteer" role that could be assigned as a case role. At the same time I've configured that role with: access_my_cases_and_activities, basic_case_information and other general permissions.
But as is, "volunteer" CMS users can see their assigned cases in dashboard (only if their have activities programed), and when click "administer" or "manage case" it shows that they don't have permissions to access to case.
When I grant permission view_all_contacts, they now can access to the case, but if they search contacts they could see the entire contacts database.
Anyone can help me to solve this issue?
Thanks in advance,


texts: Mailing using SmartGroup sends to recipients not in the Smart Group

texts:
I had a scheduled mailing set to run today at at 8am. When I look at the list of people who received the email, more were sent the email than were in the SmartGroup mailing list.

The SmartGroup had a 136 contacts, but the mailing was sent to 170 contacts.

This is in civiCRM  5.14.1. under Joomla 3.9.8.
I have my Rebuild Smart Group Cache scheduled job set to run every time cron runs
and Update Membership Statuses scheduled job set to run Daily

Here's a video explaining this in more detail:

https://drive.google.com/file/d/1hCmN9N9FHr9k0V1X1FYGPFbxzZKzOnUY/view?usp=drivesdk

Note I didn't verbally mention it in the video, but at 1:05:12 you can see that the Recipients included only the single SmartGroup.

Can any shed some light on how this could happen?

I created the smart group using the Search Builder, and here are the filters:


texts: Send an email to activity targets when activity is created via the API

texts:
This feels like a simple one but I am not sure if there is a way to do this.

Does anyone know if you can automate an email to a activity assignee when the activity is created and include activity tokens like {activity.subject}, {activity.activity_date_time} etc.

I want to send emails along the lines of:

  Your meeting is scheduled with Michael McAndrew at 'Wednesday 4th March, 2pm'. The subject is 'How can I get more involved with your organisation'.

I haven't tried the CiviRules route yet (not sure if it supports tokens for activity emails) I'm going to try it now.


texts: Creating Membership Directory using Views in Drupal 7

texts:
I was trying to create a membership directory view in Drupal 7 but came across this error:

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

I created the view and selected Show CiviCRM Memberships for the Content, and then after clicked continue and edit, it gave me the above error.

Double checking, I don't see that table in my MySQL database and am curious if there something I have to activate first prior to creating a view such as this one...

I'd appreciate any help - Matt


texts: Multiple record "Copy" doesn't work for a subtype

texts:
The functionality "Copy" a multiple record work properly if a "Custom Field Set" is defined for a Type (Contact, Organization, Individual). I mean, that after "Copy" a record the new record will be created and includes the original record data.
But if a "Custom Field Set" is defined for a Sub-Type, e.g. Individual/Student, then the "Copy" creates the new record, BUT WITHOUT copying the original record data. I need to use multiple records to update previous record just in one field and I don't want to retype all data I have already input before, and I need to track the history of records.
Thank to anybody who can help me.


texts: What's the quickest way to set up a developer environment on windows?

texts: Wondering how to set up a dev environment with buildkit on Windows with the least amount of pain. Is there a shortcut like a prepackaged virtual machine image?


texts: CiviMail click through links and Browse Site button not working.

texts:
We are running Civi 4.7.22 on WordPress 4.8.1.
We are having a problem with CiviMail.  I have included a link to a MP4 demo video to highlight what is happening.  Please watch for what happens when I click the "Browse Server" button and when I run the Preview and click the link in the preview.
We have contacted our host and they assured us that nothing in the server is blocking or restricting those php functions.  I suspect it is a path issue, but I don't know where to look or how to resolve it.
Please see link to video below.
Thank you

http://meatcuttersclub.org/demomp4.mp4


texts:
I'm running civicrm on a joomla 2.5 site and recently tried to update my localisation settings which at first appear to save but the new settings are not saved, it reverts to the default settings each time. I then clicked on enable multiple languages and since then I can no longer access CiviCRM at all in my admin panel - I just get the message: "Sorry but we are unable to provide for this at the moment. DB error: no such field. Return to home page"

Help!


texts:
Most everything we do is based around an organization and not an individual. I've searched around and couldn't find an option for an event registration to be tied to the organization record and not the individual record.

Then I thought I could perhaps transfer the registration after someone registers to the organization but the options displayed are only to transfer to a person.

But I can manually enter a registration for an organization.

Is there a solution for this that others are using?


texts: Custom field in event - for the message templates

texts:
In the Event Information I have new field. There, the organizer can be selected from the CRM. For the message templates I would like to use this information. If the field is filled, the First name / Email / Phone field of the address should appear in the message.
- Where can I find necessary examples and information? Thanks Felix
Wordpress 5.3 / CiviCRM 5.19


texts: Contact Form 7 CiviCRM integration not connecting to remote CiviCRM website

texts:
I'm trying to connect my a form to a remote CiviCRM website. To do that I'm following this tutorial using FormProcessor Contact Form 7 and Contact Form 7 CiviCRM integration https://docs.civicrm.org/formprocessor/en/latest/sign-up-newsletter-wordpress/
My CiviCRM Contact Form 7 Settings is filled correctly (with the path for wordpress, the api_key and site_key are correct). My contact form field are similar to the FormProcessor input and should be ok, I tested everything on RESTer chrome extension and it work the contact is added on my remote CiviCRM but when using the extension with the form it doesn't.
In Contact Form 7 "CiviCRM" tab my entity is set to FormProcessor and my Action has the correct name. I didn't filled the "params" field.
Wordfence is disabled


texts:
I am getting ready to move our organization to CiviCRM.  We have many values that are "codes" that show in our current system via lookup tables.

For instance, the value in the database for a chapter might be "SC" whereas what is displayed is "Some Chapter"

We anticipate that this would be the "Some Chapter" group in CiviCMS but that it would also be used as grouping in reports.

So, as I move our info, is it better to retain the "SC" code, or should I convert them to "Some Chapter" as I do the export?


texts: Not sure what to do with these errors on User Dashboard

texts:
I have wordpress redirect users that login to their User Dashboard. When I login as an administrator I always get the following error:

Warning: file_get_contents(): https:// wrapper is disabled in the server configuration by allow_url_fopen=0 in /home/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/VersionCheck.php on line 429

Warning: file_get_contents(https://latest.civicrm.org/stable.php?format=json): failed to open stream: no suitable wrapper could be found in /home/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/VersionCheck.php on line 429

Any idea what this is about?


texts: Keep getting this error on Composer require

texts:
I'm using the current instructions to get the current version of CiviCRM for Drupal 8
[play@ceres web]$ composer require civicrm/civicrm-{core,packages,drupal-8}:'~5.35'

It keeps giving me this error
- The requested package civicrm/civicrm-core ~5.35 is satisfiable by civicrm/civicrm-core[5.35.x-dev] but these conflict with your requirements or minimum-stability.

I'm then trying
composer require civicrm/civicrm-{core,packages,drupal-8}:'~5.34.0’

and it just hangs.
Any ideas?