texts: Payment Page not accessible to anonymous users in Wordpress

texts:
[I have updated some information following Tamara's answer, but it is still not accessible by anonymous users]

I need people to be able to be able to sign up and pay for membership.

I set up a CiviCRM Membership and a Price Set for the membership
I created a profile (including custom fields) for the membership registration
I ticked the box that says 'Account Creation Required' under WordPress user account registration option for the profile [Update: one of the profile fields is Email (Primary)]
. I've set up a CiviCRM Payment Page for membership fees using above profile. [UPDATE: I set up some Word Replacements, hence Payment page not Contribution page.]
I've checked the permissions for Anonymous Users to create, edit, view profiles.
CiviCRM: Access all custom data fields checked for Anonymous
CiviCRM: access contact reference fields is checked for Anonymous users [Update: I'm using address details from Contacts]
CiviContribute: make online contributions  is checked for Anonymous user
[Update] CiviCRM: Profile listings and forms:  is checked for Anonymous user
I've created a Wordpress page and used the CiviCRM shortcode to add the payment page

When I access that page logged in, it displays no problem. Logged out, it's coming up with the civiCRM alert 'You do not have permission to access this page.'

When this happened before for another civiCRM profile I set up (with no payment), it was because I had not ticked 'Create' within the civiCRM shortcode options for Profiles; as soon as I did that, anonymous users could you see the page and fill in the form and create an account.

However, with a payment page, I'm not seeing an option for 'Create'.

How do a I set up a page where people can sign up for membership, create an account in Wordpress, and pay the fee all at the same time when not logged in?

Any help much appreciated.

The page in question.

Cheers,
Tracy


texts: Is there any way I can know from which page I came from?

texts:
I am working on a CiviCRM plugin that will act as a unified solution for social media login.

Once someone clicks the Login button which this plugin adds (eg to an event page), he or she is redirected to a new page for further data exchange (eg login on Twitter, Google+ etc).

Is there a way I can get to know from which the button was clicked?

One way is to store the same while clicking the button or send it to the new page as a GET or POST variable. I just wanted to check if we already storing/getting it up somewhere in CiviCRM.


texts: Create a Drupal View of current event participant numbers

texts:
We use CiviCRM to sell event tickets and I was wondering if it's possible to pull the list of current events and confirmed participant number in to a simple Drupal View restricted to logged in users so we can keep track of ticket sales more easily?

I've looked at the built in options for creating the views but can't see a way of pulling that data across.

If there's an easier way of doing this directly in Civi then all ears for that as well but we're finding it a bit clunky to have to find each individual event each time and check the registered participant number and just want an overview.


texts:
I am trying to add an Image as Custom field in Civicrm Contact, but the Image Field type is not in the Custom Field section. It has only Field type as File.

How to apply Drupal Image styles for Images uploaded on Civicrm Contact.

I have integrated Civicrm in Drupal 7.


texts: Multiple CiviHR installation in single Amazon AWS instance

texts:
I have installed multiple CiviHR on Amazon AWS.

And configured VirtualHost as given below. so I can use the same domain and demo1 and demo 2 as a subdomain of it.

Both CiviHR installation was successful but in domain.com/demo/hr-details I'm not able to see any data that I have added. It displaying blank.

If I click on edit my details button I'm able to see the data I have added.

Highlighted URLs redirecting to root folder of the server (domain.com/dashboard instead of domain.com/demo1/dashboard).

Is this issue with VirtualHost configuration or something else?


texts: How can I update CiviCRM installed with Drupal 8 using Composer?

texts:
I've got CiviCRM installed and working Wirth Drupal 8 using Composer via https://gitlab.com/roundearth/drupal-civicrm-project

What I'm not clear on is how best to update CiviCRM using Composer. Is it as straightforward as runnning something like:

composer require roundearth/civicrm-composer-plugin civicrm/civicrm-drupal-8 civicrm/civicrm-core:5.19.3

I can't find any documentation on updating.


texts: Using API to retrieve contact records by modified date

texts:
I basically have the same questions as described in these topics https://forum.civicrm.org/index.php?topic=22774.0
https://forum.civicrm.org/index.php?topic=24121.0

I would like to know which parameter to use in an api call url to get the last modified date in the list of returned fields

and

which parameter to add to an api call url so that it only returns the contacts that where created/modified since a specific date (or if this isn't possible: the parameter for all contacts created since a specific date, and the parameter to get all contacts modified since a specific date).

Thanks!


texts:
As an admin, when I want to display the CiviCRM Menu instead of the drupal menu (via .../civicrm/dashboard), I often get the following Error Message :

Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
No API key provided. (HINT: set your API key using "Stripe::setApiKey()". You can generate API keys from the Stripe web interface. See https://stripe.com/api for details, or email support@stripe.com if you have any questions.

Then, if I insist, just once, I get to the Civi dashboard page with the civicrm Menu and there is no more message, and every-thing works correctly.

Apart from this, I have no problem with payments via Stripe.

CiviCRM 5.13.2 / Drupal 7.67


texts: I have a contacts.csv file with 4330 records.  On importing, CiviCRM reports that the file has 1866 records.  Separating the file into three files yields proportionately similar results.  Why the miscount?


texts: Is there a way to bulk create (and connect) drupal users from CiviCRM Organizations?

texts:
With Drupal and CiviCRM it is rather straight forward to bulk create Drupal users from CiviCRM individuals and connect them at the same time:

Export the individuals from CiviCRM
Import them into Drupal using the module User Import

It works really nice: Drupal accounts are created and at the same time connected with the CivicRM contacts. And the Drupal module gives you a lot of nice options such as sending out an email with a one-time login or defining user names.

If you try the same approach with CiviCRM organizations, it will create Drupal User records but wont connect them with the according CiviCRM contacts.

I made sure that the matching/dedupe rules should not be a problem (email only) and disabled CiviCRM profiles (the default name and address profile contains individual only fields) - but no success.

Any ideas on how to bulk create organizations? Preferably using Drupal user import or anything that is doable via the UI and/or not too complex?


texts: Drupal View query for select fields produces different results that CiviCRM

texts:
I have a civicrm custom field for languages spoken like
English
French
German
...

You can have multiple selections.
SO a contact might select
English
French

from the listing.
If I do a search for "French" in CiviCRM it returns contacts correctly.
If I do it in Drupal via an exposed filter in a View, it returns no contacts.
If I do a Drupal search for English, it returns the contact.
It seems like it only returns a result if the item being searched is the first in the list - in this case English.
Ive tried allow multiple selection in the View filter and so on, with no result.
I want it to produce the correct results.
Any ideas? Thanks as always.


texts: Installing "Edit Line Item" extension CiviDiscount permission error

texts:
Upon installing "Edit Line Item" extension with CiviDiscount already installed I get this error:

  Some modules define permissions but the CMS cannot store them;
  cividiscount

Any advice?


texts: Possible bug? "Enable Double Opt-in for Profile Group(s) field" displays twice

texts:
Seems that Enable Double Opt-in for Profile Group(s) field option has two identical copies in CiviMail Component Settings.

Also present on test server. https://demo.circle-interactive.co.uk/


texts: Wordpress Civicrm_acl_contact_cache Table got Deleted

texts:
I am using CiviCRM wordpress version 5.12.3 - For some reason Civicrm_acl_contact_cache table got deleted

I am sure no one has Database access (apart from me). But still the table got deleted. Also, it wasn't fully deleted when I SSH the server I was able to view the table (even I couldn't dump the DB). so, I dropped it through SSH and created again.

I am not sure what triggered the table to drop in the database from front-end.

Has anyone faced the same issue before?

Thanks in advance
Ramesh Rajendran


texts: Does CiviRules add/remove a contact to a Group based on Membership starting/expiring

texts:
Haven't used CiviRules before and I see it is only listed as working on 4.4 - but I want to see if on 4.6 can it

add a contact to a Group when they purchase a new Membership,
remove them from a Group when their Membership expires
act on only specified Membership types


texts:
I'm defining a two day event. For the first day there will be a 120 max participant limit and for the second day a much lower limit.

I also want to have "Early", "Regular" and "Late" fee levels with appropriate "discounts", which are limited in time as "Early Bird" fees are usually handled.

In addition I want to give some discount if you sign up for both days.

My current configuration is based on the three fee levels as time limited price sets each having three options, first day, second day and both with appropriate fees (where the fee is manually calculated according to the strategy I want).

The problem is that with this approach I cannot limit the second day participants to the level I want.

What are my options? Is there a way to do this completely with CiviCRM:s current feature set?


texts:
Suddenly, CiviMail test emails are not working. Note that the emails themselves are going out without problems, just not the tests.

Any idea of the problem and how to troubleshoot?

CiviCRM version: 4.4.14
CMS: Drupal 7.36


texts:
I see an older thread on the forum about potential improvements to the API to allow file uploads, but I'm not sure that ever happened. Has anyone ever uploaded files in CiviCRM using the API?

I see in the API Explorer that there is a File > Create with a parameter for File Contents but I'm not sure if you feed in the MIME contents, a URL, or...?


texts: How to fix a bug in Event Registration: Data Does not change in checkout after using go back button?

texts:
I created an online registration form in CiviCRM installed in WordPress. Everything functions well, except if Im not logged in and use the go back button and change some data in most of the time the data is not changed in the checkout screen.
How can i fix that? How can i debug it? Is there a way to see which code is executed if onClick is called? Im still searching for the code who is executed if someone uses the go back button and or the continue button.

Here a link to the form, i deactivated all custom javascript code for now.
Otherwise its mainly pure CiviCrm code.

https://divinya.org/civicrm/?page=CiviCRM&q=civicrm%2Fevent%2Finfo&reset=1&id=2

Just tested it on a plain Wordpress installation, same bug is there:
https://centerforevolutionaryconsciousness.org/civi2/civicrm?page=CiviCRM&q=civicrm%2Fevent%2Fregister&id=1&reset=1

I tested it now also on Drupal with same configuration and this bug is not there, so it seems to be related to Drupal on Wordpress.


texts: Where is the image compression level set for images contained in mailings?

texts:
I've noticed that if you use the 2x or 3x image in Mosaico, which is a good idea, the image in your mailing will be quite large. Is it possible to change the jpeg compression setting to make these images smaller (in code is fine, if that's where the setting is)?
Sending a 600px image and 2x results in a 1200px 200-250KB jpeg image if you have 16:9 photo. 3x is much worse. An image heavy newsletter could end up with a few MB of images. More jpeg compression wouldn't hurt here in general. Since these images aren't shown in their native resolution anyways, I think you could compress these even more than usual.
Is this done in Mosaico or in core?


texts: Is there any way to make a normal textarea in civi editable using CKEditor?

texts:
I am referring in particular to the textarea that allows one to write a custom confirmation email in the 'Online Registration' tab of an event's configuration page.

Following the CKEditor integration documentation here (http://docs.ckeditor.com/#!/guide/dev_installation-section-adding-ckeditor-to-your-page), I have added some JavaScript to the bottom of templates/CRM/Event/Form/ManageEvent/Registration.tpl to allow the CKEditor user interface to take over the textarea (where confirm_email_text is the name and id of the textarea in question):

CKEDITOR.replace( 'confirm_email_text' );

This appears to work, as the CKEditor interface appears where the textarea did previously. However, any content entered into this CKEditor textbox does not seem to be saved to the database.

The documentation for CK Editor 4 (the version in use on our version of CiviCRM) also says the following:

  When CKEditor functions as a replacement for a  element, the integration with the parent  element is automatic

(see http://docs.ckeditor.com/#!/guide/dev_savedata)

Am I missing something here?


texts: What is the difference between Tracked Opens and Confirmed Opens

texts: Does anyone know why there would be a difference/what the difference is between the "tracked opens" that you see on an individual mailing report and the "confirmed opens" you see when you run a mailing report through the reports section of CiviCRM?


texts: CiviCRM permissions to only view basic reports

texts:
I am working with CiviCRM now for some 5 years. Currently with CiviCRM 4.7.19 integrated in Drupal 7.

I am trying to setup reports and permissions in such a way that a group of people can view and edit contacts, but not edit contributions.

I am unable to setup permissions to accomplish this. The problem is I can have this group of people access the participant reports but when they click on the contact name it wants to show the contact overview page and they would not have permission for that.
For some reason it seems I need to enable 'Access CiviContribute' (a way to broad permission!) in order to be able (in for instance the participant detail report) to click on the contact name and go to the contact detail page.

Is there another solution? Or am I doing things incorrectly? Of course I know views might be a way out, but I am trying to do this in CiviCRM.


texts: Upgrade from 4.6 to 4.72 DB error - no such field

texts:
As I was following the process to upgrade to 4.72, I received the following error when updating the DB:

[Error: Upgrade DB to 4.7.beta8]
Error Field Error Value
Type    DB_Error
Code    -19
Message DB Error: no such field
Mode    16
UserInfo    UPDATE civicrm_payment_processor_type SET is_active = 0 WHERE name = 'Google_Checkout' [nativecode=1054 ** Unknown column 'payment_instrument_id' in 'field list']
DebugInfo   UPDATE civicrm_payment_processor_type SET is_active = 0 WHERE name = 'Google_Checkout' [nativecode=1054 ** Unknown column 'payment_instrument_id' in 'field list']

I still very new to Civi and I'm not sure where to begin with this other than rollback to my backup. I've attached a full screenshot as well. Thanks for any help in advance.

Jason


texts: Changing financial contributions when renewing memberships

texts:
I have a site where users can select various contributions when they create their memberships.

Sometimes I renew members from the back-end of civi. However, when I click "add membership", I get a pop-up telling me that I can renew the membership instead of adding a new one.
That makes sense, so I click the link to go to the renewal screen.

The problem is that on the renewal screen in the back-end, I don't have the option to change a user's financial contributions.

Am I missing something? Or is this something that can be added in with a hook?

Thanks in advance,
-Joel


texts: Webform, Contribution Page & Events - Status always pending

texts:
Sorry for the long post but I want to provide as much info as possbile:

I am brand new to civicrm but very experienced in drupal. I'm running civi as a subdomain: dogs.mysite.com with drupal 7.57, civi 4.7.31, webform_civicrm 7.x-4.20, php 5.6,

I am adding online registration to a dog training school. I've added Paypal WPS as a processor and I've set it to live to eliminate any issues there. Events have been setup without fees or online registration. I have a Contribution page setup with Paypal selected. I have tested the Contrib page with Test-Drive and it worked. The webform has the Participant Fee Amount hardcoded, has the payment processor selected (Live) and has the Contribution page included.

The webform successfully creates an event participant, but the particpiant status is always "Pending (incomplete transaction)". Paypal IPN history shows a response code of 200; the ipn message looks ok, I can see the IPN post in the civicrm_system_log, the Civicrm.xx.log shows the following (contact & contrib ids are correct)

Apr 02 11:58:37  [info] $IDS Detector Details = Array
(
    [0] => Array
        (
            [name] => custom
            [value] => {"module":"contribute","contactID":"27","contributionID":24}
            [page] => /civicrm/payment/ipn/6?
            [userid] =>
            [session] => wLXUsbVoDi_v3KiTLCkT66LvULTkEk0W72oldnOzCKs
            [ip] => 70.39.249.31
            [reaction] => 0
            [impact] => 32
        )

)
Apr 02 11:58:38  [info] Contribution record updated successfully
Apr 02 11:58:38  [info] Success: Database updated

What do I need to do to have the Event Participant status set to Complete?

Thank you!

Bill


texts:
I hope someone here can help me as I´m totally stuck with this problem.
I succesfully created SEPA Mandates, generated a group, downloaded the XML file and transmitted the file to my bank with a banking software today. However, I´m not able to close the group or mark the payments as "recieved". If I click the button "close and submit" ("Schließen und Senden" in German), it allows me to download the XML file, but otherwise says: "This is a test group and therefore can´t be closed". ("Dies ist eine Testgruppe. Sie kann nicht geschlossen werden.").
I´m unable to find out why that is only a test group and how I´m able to mark those payments as "recieved".
Thanks so much for your help!
Angelika


texts: How can I prevent Contribution Pages forcing the email to be of type Billing

texts:
Only just stumbled on this after realising that a client was correct. They set the Profile to use Email (home) but the Contribution page overrides this and makes the email be Billing.

This ticket seems closest to the issue though it is initially about the idea of being able to collect additional email addresses.

If John K is correct then current approach is

If the contact is logged in this field defaults to the 'Billing' email, if set, otherwise the 'primary' email
When the contribution is confirmed the email address is saved/updated on the contact as the 'Billing' email

(ie: If the field was prefilled from the primary 'home' email, the contact would now have two email addresses the same for 'home' and 'billing')


texts: How to update a sequence email created by CiviCRM?

texts:
I'm using WordPress 4.9.8, CiviCRM to 5.4.0, CiviRules 2.1 and E-mail API 1.17.2

I've created a sequence email by CiviRules by steps:

Step 1: After user added to a group G, send email 1

Step 2: After 5' until user added to the group G, send email 2

Step 3: After 10' until user added to the group G, send email 3

If I've created this sequence from start, sequence email sended ok. But if I want to update this sequence by and step like this:

Step 4: After 200' until user added to the group G, send email 4

This sequence created about 15' until user added to the group G, but after 200', no email send to user.

I've tried tick or untick "Don't recheck condition upon processing of delayed action" but nothing happens.

What can I do to make a sequence email and this sequence can update with CiviCRM?

Update 08/08/2018
This is conditions of my CiviRule, I have 4 Rule like that picture, the difference are the number of delay minute and the template mail.

The rule of this picture is created after my user added to group "Thông tin hữu ích". The minutes my user add to this group < 200 minutes but my user can not received email send in the rule delayed 200 minutes


texts: Does CiviCRM Spark come with a Drupal or Joomla website?

texts:
I am considering purchasing CiviCRM Spark to trial it for my organization. I know CiviCRM can be loaded into Drupal, Joomla or Wordpress. I was just wondering whether "spark" is a stand-alone product or if it comes with either website (CMS) platform.

Thanks!
Chris


texts:
Freshly installed on latest Wordpress, I am simply not able to add relationships to contacts.

I have created one contact of type ORGANIZATION and one of type INDIVIDUAL and no matter what I try, I can not create relationships between them. The dropdownbox always gives "Loading failed".

I replicated the install locally in a virtual machine and everything works as expected.

Also, I notice that the local install is faster than the non-local (bluehost shared, memory limit 200M).


texts: Is the container cache not cleared as part of `drush cc all`?

texts:
I like being able to use the DI container in my extensions via the container hook, however I've run into the same problem a few times when switching branches that I get this error:

  You have requested a non-existent service "myserviceid"

After trying drush cc all I'd expect the container cache to be clearer, but it doesn't seem to be. My go-to option is to remove all files in the sites/default/files/civicrm/templates_c/ directory, but this seems like it should be handled by the cache clear command.

I'm aware there's an option to not use a container cache, but my question is whether the failure to clear the container cache is expected, or should it be fixed?


texts: Error on CiviCRM Activation. Can't Install CiviCRM

texts:
I’m trying to install a new copy of CiviCRM for Wordpress on Plesk Onyx. I get the following error when I try to activate CiviCRM after uploading the files to my server:

Warning: require_once(CRM/Core/ClassLoader.php): failed to open stream: No such file or directory in /var/www/vhosts/ruinsideca.org/infoportal.ruinsideca.org/wp-content/plugins/civicrm/civicrm.php on line 877

Fatal error: require_once(): Failed opening required 'CRM/Core/ClassLoader.php' (include_path='.:/opt/plesk/php/7.2/share/pear') in /var/www/vhosts/ruinsideca.org/infoportal.ruinsideca.org/wp-content/plugins/civicrm/civicrm.php on line 877

I don’t know why this error is happening or how to fix it. I’ve never come across something like this before. As a result, I can't even install CiviCRM on my server.

I'm running PHP 7.2.22, Wordpress 5.2.3, and CiviCRM 5.17.3.

Thanks for your help


texts: Error - search members belonging to a group

texts:
No matches found for:
Group(s) In Client Mailchimp Newsletter ...AND...
Group Status "Added"

I have created a group and was trying to look at the full list of group members but getting above error message. Not sure what is this "status". I was not searching on this


texts: Membership status rules not updating statuses

texts:
Hoping someone can see what we are doing wrong here.  We have four membership status rules:

Current - (Start Event = start date, End Event = end date)
Grace - January (Start Event = end date, End Event = end date + 1 month)
Lapsed - February & March (Start Event = end date + 1 month, End Event = end date + 3 months)
Not Renewed - April onwards (Start Event = end date + 3 months, End Event = nothing set as this is a permanent non renewal)

1, 2 and 3 working fine, but now that we are in April, status is showing as 'lapsed' still, rather than 'not renewed'.  We've run the cron job to update status, no change.


texts: Showing Financial Transaction Data with Contributions

texts:
I have created a drupal view of contributions. In this view i want it to show:

Date Contribution Created (CiviCRM Contributions: Date Received)
Financial Type (CiviCRM Contributions: Financial Type)
Fee Amount(CiviCRM Contributions: Fee Amount)
Net Amount (CiviCRMContributions: Net Amount)
Payment Date - This is the only data i can't extract as this is linked to the financial Transaction. I need the transaction date

I have added a relationship "CiviCRM Contributions: CiviCRM Line items" but it pulls in other transnational data not the txrn date.

When i create a view of "CiviCRM Financial Trxn" I am unable to add in a relationship therefore unable to pull in contributions data.

Any Ideas?

I have thought about putting a View within a View to pull that data and it works unfortunately it shows a duplication of the contribution as there is several financial transaction entries for that contribution.

Thanks


texts:
I'm looking for help troubleshooting "Extensions Download" errors. Like Error: Can't Access CiviCRM Extensions, I've recently been getting lots of "Unable to download extension from ..." lightbox errors. My host confirmed there aren't any SSL protocol errors logged on our end, and suggested the issues are probably with civicrm.org's certificate(s) and/or the encoding of the xml files.

The System Status page reads:

  Extension Download Error: The CiviCRM public extensions directory at https://civicrm.org/extdir/ver=4.7.14|cms=Drupal could not be contacted - please check your webserver can make external HTTP requests or contact CiviCRM team on CiviCRM forum.

I'm running CiviCRM 4.7.14 with Drupal 7.52, and can usually troubleshoot issues, but I'm new to CiviCRM and can't think of anything I can do about this. Any suggestions?


texts: How can I create mosaico block with 2 button?

texts: I would need a mosaico block with 2 button, is it possible to create? Thanks


texts: problems with kcfinder image browser in Chrome

texts:
There did not use to be a problem with the media browser in CiviMail when using Chrome, but it's broken now.

https://BASEURL/sites/all/modules/civicrm/packages/kcfinder/js/index.php 3.12

WORKS in Firefox: shows KCFinder: /image33 files (4 MB)

Does not work/Hangs showing "CIVICRM File Manager" as heading
Chrome Version 83.0.4103.97

Other reports of hanging while trying to upload or select images.


texts: Report on Memorial gifts made in memory of a person

texts:
I am new to CiviCRM.  How would I run a list of donors and their contact information who have made contributions in memory of someone?
Your help would be appreciated.
Thanks.
Felicia


texts: Browsing for images in the editor leads to an unexpected Error

texts:
I want to add an image in an email newsletter. However when I try to use the Browse Server button like:
and unexpected error is thrown:

The used versions are CiviCRM 5.32.2 and Drupal 7.77


texts: How do I search for contacts with "not empty" multiple records field?

texts:
today I realized that the search builder does not provide access to custom multiple-record-fields. Thus I'm wondering how it's possible to search for contacts having at least one record of such field.

Any ideas?

Thanx in advance // nielo


texts: Is there the ability to globally update relationship end dates or add them to a profile for bulk updates?

texts:
Suppose I am using relationships for specific classes where the student in a class (organization) may not have a start and end date. Is there a way for me to look up a particular class and globally update all the students/relationships by adding an end date when that class ends?

I am talking about the relationship between a company (class) and an individual (student) in the join table, not the current "employer" field on the individual record.

Ideally, i would like to globally import end dates but can't do that without the relationship key. Is there a way to create a profile listing all current relationships of an organization where I can manually set end dates for students in a editable spreadsheet/profile format? I have many students assigned to classes that have ended and want to globally end those relationships without having to go to mySQL.

In other words, I need to create a listing of all the "active" relationships of an organization so I can easily edit start and end dates without a pop-up form.


texts: Can CiviCRM do mass/bulk targeted e-mail "blasts" and "petitions" like Salsa, NationBuilder and other for-profit platforms?

texts:
Can CiviCRM and CiviMail replace what an organization is doing now with Salsa, NationBuilder  or other for-profit platforms - like send targeted e-mail "blasts" to elected officials, and host "petitions"?

So for example, if an organization's goal is to generate 50 e-mails from CiviCRM contacts in each legislative district to each member of a legislature, with the message "please vote for Bill 1 and support public financing of election campaigns", can CiviCRM do that?

Or, if an organization wants to ask CiviCRM contacts in each district to sign an open petition to each legislator, can CiviCRM do that?

I asked a similar question at How does using CiviCRM compare to using NationBuilder? but I think an update is worthwhile.


texts: I want to make it so that all new contacts must have a contact type. I have found where the contact type is in the templates, and have managed to add the wee * besides it, but I am struggling to find what tag or code I need to add to make it be an actual mandatory field. Is there some way of doing this?


texts: If "!empty" on custom note field in Drupal Views, Global PHP field

texts:
I am using a global php field in drupal views to display a list of names. If the contact record has extra info in a custom note (rich text editor) field, I want to display "name, info". If there is no extra info, I just want to display "name". This is what I am using as the output code of the global php field:

<?php
if (!empty($row->id_info_for_display_33)) {
    print $row->display_name . ", " . $row->id_info_for_display_33;
}
else {
    print $row->display_name;
}
?>

It seems that the custom field is never really empty unless it is a record that was created before the custom field was added. Even then, if I then edit that record, the custom field is no longer empty and the display ends up as "name,".

Any ideas on what logic will accomplish this?

Civi 4.6.2

Drupal 7.38

Views 7-3.11

Thanks!


texts:
I'm upgrading a site from 4.6.x to 4.7.x. I am having trouble understanding how to configure the WYSIWYG to provide the same CKEditor editor buttons as in the 4.6.x version.

I know that I can go to Administer -> Customize Data and Screens -> Display Preferences -> Configure CKEditor. However, I don't see how to add back missing editor buttons.

For instance, I would like to add back the "Align Left", "Center", "Align Right", and "Justify" buttons. I see that there is an empty toolbar group where these should go. In the "Plugins" dropdown, I see "Justify" but I don't see any of the other missing buttons. And I don't see how to get Justify out of the dropdown and into the toolbar.

Any guidance would be greatly appreciated. Thanks!


texts:
I've been running certain 5.6 for a long while and wondering if I ever should migrate to 7.0 or just leave alone. Installation instructions say 7.0 is recommended but so is 5.6

Anyone have opinions on this?

---Update:  I have upgraded my WordPress site to 7.2 without too much trouble.  However the Drupal 7 / Civi site when I tried to update, I got 503 errors and had to roll back.  I think there are some really tight controls the consulting firm put into place.  I kept reading about FastCGI and NGINX and had no idea.  I do not know about these and if they are used.  I know that FPM is used.  I want to update before year end but I am scared.  Anyone?


texts:
They are various drupal modules that allow to clone a webform, but so far, all the ones I tried didn't play nicely with webform_civicrm and introduced weird problems.

Do you have one that you use and that works when your form is connected to civicrm?


texts: Participant quantity passed to Additional Participant pages

texts:
On an event registration form I need to tailor a Price Set field (ticket type) for all participant pages, based on what is selected in the Participant count on the first page.

This is doable on the first page (buyer) in a Register.extra.tpl file because the participant count field is visible on that page so the form data is accessible in JQuery, but how do we interrogate the Participant count value for all subsequent Additional Participant pages please?


texts: Add large amounts of custom data to contacts

texts:
I have "contacts" that are websites.  I want to add large amounts of custom data to my contacts.  An example of the type of data I want to add can be seen in this "report" https://freephile.org/wikireport/?wikiUrl=http://wikia.com

How should I setup my CiviCRM with all these custom fields (profiles?, custom field sets?)

Once the database is setup, I envision populating the data through the API, but is there any particular method for populating data sets that I should be aware of?  (I've already figured out the basics of checking a record, and storing a simple relationship like contact+website)


texts: Status message "Thank you. Your information has been saved." is missing on profile submit

texts:
I'm currently testing our recent upgrade from 4.7.19 to 4.7.29 on our test server.  We have a public email list signup page on our website using a civicrm profile with a re-direct to a new (empty) email list signup page.  On our live site under the old release, when someone completes and submits this page, they get the message "Thank you. Your information has been saved." along with the fresh page.  But under the new release we don't get that status message displayed.  If I take out the re-direct I'll get that message but I don't like that generated page with the inappropriate ">>Back to Listings" link.

Is there a (non-programming) way for me to get that message displayed again as it was under the old release, or is this an inadvertant bug?  Thanks for your help.

Wordpress 4.9.1


texts: Can Civi/WordPress an Civi/Drupal (same versions) share a database?

texts: This would make it a lot easier to manage a transition between an existing Drupal site and a new WordPress site. In my case, all core programs and the existing databases are on the same server. It would sure be nice to just configure the new WP Civi to look at the old Drupal Civi database.


texts: set standard recurring unit on contribution site

texts:
is there a way to set a standard for the dropdown of the recurring units (yearly, monthly, etc.) on a civi contribution site? We would like to have "yearly" instead of "monthly".
I tried to find sth in the configuration but apparently there is no easy way to do so.
Thanks for your help in advance.


texts: Is upgrade possible for `payment` type Extension?

texts:
I see extension of type 'payment' has been deprecated and hence not listed in the active modules we get from getActiveModuleFiles() function. Due to this, any upgrade to this ext. is not possible since the upgrade link is not shown for them (as they are not active modules anymore)

Is there any way to upgrade such extentions - i.e to execute the following query in upgrade?

UPDATE civicrm_extension
SET type = "module"
WHERE full_name = "nz.co.fuzion.paystation

I haven't found anything other than the answer I posted below.


texts: get source table values in civicrm_triggerInfo

texts:
I have created below hook for trigger some values in my table.

Here how to get source table values that are being updated or inserted

function history_civicrm_triggerInfo(&$info, $tableName) {
  $sourceTable = 'civicrm_membership_log';

  $sql = "
    INSERT INTO `civicrm`.`civicrm_membershipperiod`
(`id`, `membership_id`, `start_date`, `end_date`) VALUES (NULL, '1', '2017-07-03', '2018-07-03');";

  $info[] = array(
      'table' => $sourceTable,
      'when' => 'AFTER',
      'event' => 'INSERT',
      'sql' => $sql,
  );
  $info[] = array(
      'table' => $sourceTable,
      'when' => 'AFTER',
      'event' => 'UPDATE',
      'sql' => $sql,
  );
}

Based on the source table value I have to rewrite the query $sql


texts: CiviEvent price set custom validation rules

texts: I want to create an event that uses a complex price set, and I want custom validation rules that express relationships among the fields in the price set. For example, if I have a checkbox "Entire Retreat" for participants to say they're registering for the whole event, it should be an error for them also to check the boxes for any individual part of the event. Is there a general-purpose way to configure rules about the entire price set?


texts: drush civicrm-sql-dump dumps the drupal database - how do I get it to dump the civicrm database?

texts:
I've recently made some backup scripts to automate backup of my site and databases. One of the scripts uses drush to dump the drupal and civicrm databases with these commands:

drush @myserveralias cc all && drush @myserveralias sql-dump --gzip --result-file=mydrupaldatabase-150731.sql

drush @myserveralias cc all && drush @myserveralias civicrm-sql-dump --gzip --result-file=mycivicrmdatabase-150731.sql

My problem is that both of them dumps the drupal database - I would like the second one to dump the civi-database.

Should i somehow specify the civicrm database? My aliases.drushrc.php doesn't specify anything about databases under myserveralis - should it be specified there?
My settings.php has this to say about databases:

$databases['default']['default'] = array(
'driver' => 'mysql',
'database' => 'drupal',
'username' => 'myusername',
'password' => 'mypassword',
'host' => 'localhost',
'port' => 3306,
'prefix' => 'drupal_',
'collation' => 'utf8_general_ci',
);
$databases['default']['default']['prefix']= array(
  'default' => 'drupal_',
  'civicrm_acl'                              => '`civicrm`.',
  'civicrm_acl_cache'                        => '`civicrm`.',
  'civicrm_acl_contact_cache'                => '`civicrm`.',
  'civicrm_acl_entity_role'                  => '`civicrm`.',
  ...

Thanks in advance for any help.

EDIT:
I've updated drush to version 7.0.0, and the call to civicrm-sql-dump now fails with the following error:

PHP Fatal error:  Call to undefined function drush_sql_dump_execute() in /sites/all/modules/civicrm/drupal/drush/civicrm.drush.inc on line 995

I guess there's no longer a function in Drush called drush_sql_dump_execute.

SECOND EDIT:
I've updated to civicrm 4.6.8 and now it works as it should. I didn't get the chance to explore Alan's suggestions, though i know for sure that my civi-database is in a different database than Drupal.
Thanks for your help and input. If anyone drops by here having this problem, I would recommend upgrading, as Jon says he hasn't seen this error in any of the newer versions of civi, and upgrading solved it for me. Leaving this open for now, if someone actually solves this for civi 4.4 and Drush 6, then they can provide an answer.


texts: CiviEvent URL Aliases being munged in Drupal 7

texts:
When I set up a url path alias in Drupal for a civievent (eg. pubquiz rather than civicrm/event/info&reset=1&id=33) and try to access the alias I get the message 'Access denied You are not authorized to access this page' when I try to access it. This only affects the alias, not the raw civevent path offered by Civi and used in the alias setup.

This approach has worked perfectly in the past, but hasn't been used for six months or so. Other aliases for native drupal paths work perfectly.

When I look at the list of url links in Drupal, I see that for Civievents the 'alias' link looks fine but the 'system' link is munged. It displays as 'civicrm/event/info&reset=1&id=33' but the actual link is https://XXXX.org/?q=civicrm/event/info%26reset%3D1%26id%3D33

A recent change in Drupal 7 ?

I can work a round this in Webforms, but this way was easier for simple events.

Drupal 7.7.1/Civi 5.24.3


texts: SOLVED - Cron autorun config help please

texts: I had tried the starter pack and ran into a bunch of problems with it.  It was already set up to make cron run automatically.  After scrapping the starter pack and just installing Drupal 7 and then CiviCRM, cron doesn't run automatically and I can't find any documentation that makes any sense to a non-unix admin like me for creating some type of configuration or modifying a config file to make this happen.  Can someone please point me to instructions that are fairly easy to understand?  Gracias.


texts: Contact Reference Field Import & Batch update

texts: How can someone import or do a batch update using a profile using a contact reference field? I have tried both and get errors on the import even though the format of the text is correct and those fields do not appear on the profile when doing a batch update. Thoughts?


texts: Add new case: "Case Type is a required field"

texts:
When I try (on 4.6.18) to create a new Case, I get an error saying Case Type and Case Start Date are required, but no fields exist on the form to specify these?

I have Case Types defined and enabled at civicrm/a/#/caseType and I've tried adding a case from the menu Cases » New Case and from the Cases tab.

There's no javascript errors showing, nothing in Drupal's watchdog log. Hmmm. Am I doing something daft?


texts: HTTP ERROR 500 for New Mailing after SendGrid SMTP Relay setup

texts: I've set up SendGrid in order to better understand issues we are having with our newsletters. In the Settings -Outbound Mail, I am able to Save and Send Email. However, when I go to Mailing > New Mailing, I get: This page isn’t working www.oursitename.org is currently unable to handle this request. HTTP ERROR 500


texts: Fatal error on CiviEvent dashboard in 4.7 using PHP 5.3.5

texts:
Just tried the 4.7 upgrade and found it was giving a fatal error when I tried to acces either the event dashboard ( /civicrm/event?reset=1 ) and Manage Events ( /civicrm/event/manage?reset=1 ).

Fatal error: Can't inherit abstract function Civi\ActionSchedule\MappingInterface::createQuery() (previously declared abstract in Civi\ActionSchedule\Mapping) in C:\xampp\htdocs\switch\sites\all\modules\civicrm\Civi\ActionSchedule\Mapping.php on line 64

I can access the other CiviEvent pages (e.g. add new event, add participant, etc), and none of the other components seem affected.

Using Drupal 7.41, and upgraded to 4.7 from 4.6.10. I am running PHP 5.3.5, which the upgrade warned against but only for future versions?


texts: I need to find the Host URL, Site key and API key

texts:
I need to find the following details for my CiviCRM account:

Host URL,
Site key and
API key.

Where can I find them?

Thanks so much,
Silvia


texts: Is it possible to define an activity status to be the equivalent of completed?

texts: Specifically in the UI, activities that are past their date show as red unless their status is completed. I have a few use cases where it would be preferable for the final state of the activity to be a status like 'accepted' or 'denied'. I have not found in place where it is possible to set the status level as equal to Completed, so I am assuming that you would have to either do it with some type of extension or custom code?


texts: Is it possible to find out who installed an extension update?

texts: One of my clients had the API v4 extension updated to 4.3.0 last evening, and so today the contact summary screen was broken - because the API extension isn't compatible with the contact summary extension in 5.10.4.  Is there any way of finding out who installed the extension update?  Some log somewhere?  This is a Drupal site, by the way.  One thought (maybe silly!) - the extension wouldn't update itself after a given time, would it?


texts:
Greetings CiviCRM Community,
I am in need of rebuilding our organization CiviCRM DB. We are getting some odd issues when trying to create activities in CiviCRM. When I traced the error I got the following message below. I'm think we need to rebuild our CiviDB Schema since we have done a few upgrades over the last few months. I wanted to know if there is an updated process for rebuilding the CiviCRM schema. When looking at the documentation on the wiki site it states that this documentation have been archived and the new site does not include the process. Please advise on what we should do.

Additional uncaught exception thrown while handling exception.

Original

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT expire, value FROM {semaphore} WHERE name = :name; Array ( [:name] =&gt; rules_get_cacheevent_watchdog ) in lock_may_be_available() (line 167 of /opt/bitnami/apps/civicrm/htdocs/includes/lock.inc).

Additional

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT ff.* FROM {filter_format} ff WHERE (status = :db_condition_placeholder_0) ORDER BY weight ASC; Array ( [:db_condition_placeholder_0] =&gt; 1 ) in filter_formats() (line 434 of /opt/bitnami/apps/civicrm/htdocs/modules/filter/filter.module).

Uncaught exception thrown in session handler.

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT 1 AS expression FROM {sessions} sessions WHERE ( (sid = :db_condition_placeholder_0) AND (ssid = :db_condition_placeholder_1) ); Array ( [:db_condition_placeholder_0] =&gt; YeiL-YkRM2JyCIzmbtEZQP5wCjxN2hpMFaxcVuAQj88 [:db_condition_placeholder_1] =&gt; ) in _drupal_session_write() (line 209 of /opt/bitnami/apps/civicrm/htdocs/includes/session.inc).

Uncaught exception thrown in shutdown function.

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] =&gt; 15704801665a2824bfaa38b2.28928446 ) in lock_release_all() (line 269 of /opt/bitnami/apps/civicrm/htdocs/includes/lock.inc).


texts: Webform conditional from Civicrm checksum

texts:
I use drupal 7 and latest civicrm.

I direct people to my form using the checksum. I would like to not display email field and GDPR opt in field if they arrive at the form via checksum. If they arrive at the form without checksum I would like email/opt in to be visible.

I know how to use conditionals within the form (eg if email address is present then display field X) but I can’t work out how to do it from the initial check sum - I feel it ought to be possible. Can anyone help?!

Thanks!


texts: How can I redirect users to the contact dashboard after login?

texts:
We're on civicrm 4.5.8 and drupal 7.

I'm testing accepting donations including recurring, which means the contacts will need logins.  When they login I think I'd like the landing place to be their contact dashboard or at the very least have a direct link to it in the menu.  Right now it seems that the users have to select My Account then after their name and address stuff there is a link for View Contact Dashboard.

Can I make it go their directly after they login?

Really, ideally, depending on their role I'd like them to be directed to different places, e.g. back office staff goes to the standard Civicrm home page normal users go to contact dashboard.


texts: Hook to stop a contact's email from being deleted

texts:
We have a new requirement to stop an admin from deleting a contact's email if that email is found in one of our other systems.  I am trying to do this through a validateForm hook.  I can figure out the logic of finding the email in another system.  But how can I check:
1. That the form is trying to delete or update an email (vs adding an email)?
2. Identify which email is being deleted?

I can't tell where to find the action being taken, nor which email is being deleted.  Also, if I set an error (as a test), the error shows correctly, but the deleted email is gone from the view of the form (I would like for it to stay there).

Is there another hook I should be using for this?

My other option would be to use the buildForm or similar hook to make that field readonly prior to the form showing up.  But I feel it's safer to block a delete.

Would love some pointers on either method.  Thanks!


texts: User registration checkbox in CiviEvent does not create new user and misses thank you screen

texts:
In CiviCRM I set up an event including registration but when I select the option to allow a user to register for the event and at the same time as a Drupal user, after you continue from the event confirmation page instead of going to the Thank You page it shows the entry page containing just a name/password box and a weird error saying 'Please enter your email'.

I have had my consultant take a look at it and he says "Checked the Drupal permissions - look fine, Checked some email settings - look fine, Turned on Drupal error reporting and completed the form again. Now got the message 'Notice: Undefined index: email-Primary in CRM_Utils_System_Drupal->createUser() '
http://bdva.s803.sureserver.com/admin/reports/event/11578'

We have done a few searches but not found anything on this error and for the time being we have now turned off create Drupal user in all profiles attached to event registration.

What should we do to create Drupal users and show the Thank you pages on Event signups?


texts: Update 4.7.22 : Operation failed: Update Indices DB Error: already exists

texts:
I'm just update to civicrm 4.7.22 on Drupal 7.56.

After the update, I received a system status warning "Performance warning: Missing indices".

I click to Update Indices and have these error: "Operation failed: Update Indices DB Error: already exists"

In the Drupal log, I have the message:

"$Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => exceptionHandler ) [code] => -5 [message] => DB Error: already exists [mode] => 16 [debug_info] => CREATE UNIQUE INDEX UI_case_contact_id ON civicrm_case_contact (case_id, contact_id) [nativecode=1061 ** Duplicate key name 'UI_case_contact_id'] [type] => DB_Error [user_info] => CREATE UNIQUE INDEX UI_case_contact_id ON civicrm_case_contact (case_id, contact_id) [nativecode=1061 ** Duplicate key name 'UI_case_contact_id'] [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="CREATE UNIQUE INDEX UI_case_contact_id ON civicrm_case_contact (case_id, contact_id) [nativecode=1061 ** Duplicate key name 'UI_case_contact_id']"] )"

Do I need to solve this issue? And how can I?

Thanks.


texts: Using a Java Applet in CiviCRM Extension

texts:
Does anyone have any idea how to get a Java Applet to work in a CiviCRM Extension? In particular, I'm trying to load the QZ-Print applet.

The first problem I'm having is getting the location of the jar. Currently the code to embed the applet is (where the applet is in www/qz-print/ dir on the localhost):

<applet id="qz" name="QZ Print Plugin" code="qz.PrintApplet.class" archive="/qz-print/qz-print.jar" width="100" height="100"></applet>

The code is in the main page TPL file for my extension. This seems to (sometimes) completely hang the web page/browser... On the occasion where it does load the page, I get the following: "SecurityException JAR should not contain JNLP-INF/APPLICATION.JNLP".

Anyways, I'm at a loss for what to do right now. Any help on getting an applet to work with an extension would be greatly appreciated.

UPDATE:
So I looked into this and realized that I need to load the JNLP file. So I'm doing that now. HOWEVER, I'm having trouble getting the path to the jnlp/jar file. When working with an extension paths aren't typical.

How does one go about getting the path to the JAR/JNLP within an extension?

Thanks!


texts: Is it possible to use CiviCRM if I am a federation that wants to manage his associations with his members? How do I manage organizations and households in such a case? Thanks.


texts: How to export 'employee of' relationship that has multiple staff members?

texts:
As a disclaimer, I've read up on this thread: How to export all children of a family?. However, that doesn't seem to solve my problem. Here's my dilemma.

I'm looking to export contacts from our installation that shows both the organization's employees as well as the staff member assigned to that organization (known as a field support coordinator). We have the relationships 'employee of' and 'field support coordinator is' to handle this.

If I pull up the organizational group 'current affiliates' and export those contacts, we are able to choose the aforementioned relationships. However, with the 'employee of' relationship, it only exports one staff member.

I've tried to alleviate this by using the advanced search to create a group called 'employees of current affiliates' which pulls everyone. I'm able to export this list with the 'employee of' relationship, but then I'm stuck with the inability to export the relationship 'field support coordinator is' since that's only attributed to organizational records.

I've gone to the reporting section and even tried pulling up this information there using the relationships template, but I run into the same issue where I'm not able to show the 'field support coordinator' is relationship, only the 'employee of' relationship.

Finally, I've tried creating a Drupal view which works fine, however the same issue occurs where it only shows one 'employee of' and not the multiple contact records attributed to it.

Is all of this a limitation of the system? Am I missing something or not understanding what needs to be done? Do we need to go to our developer to get this laid out in a different fashion?

Thank you in advance for your suggestions.


texts: Bug datepicker field when more than one on contribution page

texts:
I have civicrm installed on wordpress
I have a issue with datepicker field
When i put only one datepicker field it's works well
But if i insert more than one datepicker field in a form, the datepicker field are breaked.
I have try with a fresh install on new versions of civicrm and wordpress and i have the same problem.

Could you help me to solve this issue

Thanks !


texts: I get an error "One of parameters (value: sort_name) is not of the type MysqlColumnNameOrAlias" when trying to access most of my data

texts:
Okay, I'm new at this - honestly, probably not skilled enough to be doing this, but my organization has no money, so, well, I'm it.

I installed on WordPress last year, and everything generally went well. We use the system, it does what we need. Realistically, it might be overkill (we have only about 300 contacts), but I like it.

Then, this year, I noticed that I hadn't kept up with updates.

So - back up, then update. Complete failure. Did not work at all.

Fine. Restore from backup.

So, now, I can get into the system, and using the standard searchbox from "CiviCRM Home", I can find various contacts. Myself, for example - I type in "Ashle...", and there I am. Click on my name/email, and bingo - into my profile.

BUT.

From within my profile screen, click on "Contributions" and get "Sorry but we are not able to provide this at the moment.". Click on "Memberships", and it momentarily seems fine, but then there's a floating box in the right-hand top corner saying "One of the parameters (value: total_amount) is not of the type MysqlColumnNameOrAlias". Moments later, I get a true popup (have to click "OK" to clear) saying "DataTables warning: table id=DataTables_Table_0 - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1". Click "Groups", and I get a listing of my groups (four, in my case) - but click on one of them, and I get "Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
One of parameters (value: sort_name) is not of the type MysqlColumnNameOrAlias"

That last message is the one I get whenever I try nearly anything from the top-bar drop-down menus.

Can anyone suggest a way forward? As it is, I can access names, addresses and some basic data of any of my contacts where I already know their names so that I can go directly to their profile. But I can't really do anything else.

Should I try a new install? ...or do I need to try to monkey with the databases? ...or am I asking the wrong questions? I'm sorry if I'm asking a question that I should have been able to find an answer for elsewhere here on StasckExchange - I did certainly look, but I couldn't find an answer.

Thanks for any help,

Ashley


texts: Checking Inconsistencies between Users and Contacts Emails (via civicrm_uf_match table ?)

texts:
I am in Drupal 7.51 / CiviCRM 4.7.12

I want to check Users emails against their corresponding Contacts emails (which happen to be different in the DB though they should not).

I have developped a small program to identify those cases (querying civicrm_email and drupal_users tables, linked via civicrm_uf_match).

I thought that the civicrm_uf_match table managed the link between the Drupal User id and the corresponding Civicrm Contact id ; but it actually does not : it contains only 31 lines though I have 446 Users and 667 Contacts with a primary email.

For instance, the civicrm_uf_match table does not contain my own ids pair ; moreover, it contains lots of errors (e.g. old emails which were deleted).

Question : how and where is managed this link between the Drupal User and the CiviCRM Contact (which appears when you consult/modify the Contact) ?


texts:
New install (civicrm 5.35.1) and I can't find this answer.
We have 22,000 alumni that I've imported. One of the fields is cast year there are about 120 of these so I want to make an option group (it would be taxonomy in other systems I guess). There are multiple uses of this in a contact.
For example, everyone of our alumni has a primary cast. They could also have multiple "secondary" casts where they were staff or several other participants.
I'm trying to map these to a contact through a custom field.
Data sample:
1965A
1965B
1988E

etc.
Question 1: I can import the data into the database directly if needed, but I'm not sure of all the fields that are listed in the option group table.
Question 2: Assuming I get these entered as an option group, how can I create a custom field that will use this for lookup? And secondarily, how to choose which cast type it is (i.e. primary, secondary, etc.)
In answer to the 2nd part of question 2, I know I can also create an option group of cast_type, but again, I'm not finding an easy way to have this show and also allow me to import it. It would be similar to phone or address I imagine.
Thanks and please let me know if you have an questions.


texts: Error when trying to run Find and Merge Duplicate Contacts

texts:
I'm trying to run Find and Merge Duplicate Contacts.  After I choose the rule, then choose the group, I get to the main merge screen and an alert pops up that reads, "DataTables warning: table id=dupePairs - Ajax error. For more information about this error, please see http://datatables.net/tn/7"
After I close that, there are no results on the page.
I'm using CiviCRM 5.33.1 on WordPress 5.6.
Any help is appreciated.
Richard


texts: When using PayPal, we DON'T want to collect credit card info!

texts:
I've searched for the answer to this, but haven't found it. Our issue is we want to have a contribution page with PayPal and Pay Later capability but don't want credit card information entered on our server.
I've just set up a contribution page, and the PayPal section requests all the credit card information be entered ON OUR SERVER before going to PayPal to complete the transaction. We really don't want this info on our servers, even temporarily!
For event ticket sales, choosing PayPal for the fees sends us to PayPal where the PayPal account or other credit card information is then entered on their servers. This is the way we would like the contribution pages to work.
Am I doing something wrong here? I can't remember ever seeing a credit card information form on any of my sites.
We're running CiviCRM 5.32.2 on Wordpress.
Thanks,
Rick


texts: Is there a way to change the error message that users receive when they try to register for an event online for which the registration date has passed?  Currently the message is:  ! ERROR  Registration for this event ended on April 25th, 2016 12:00 PM.


texts: Error when printing PDF letter or mailing label from search results list

texts:
Ran a filtered search for all "regular" members and search returned 379 records. I then wanted to create printable letters for all 379 members. I selected our New Member Welcome Letter as the template and pressed "Make PDFs". Result:

Notice: Undefined index: metric in /home/sherida1/public_html/rabbit/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/PdfFormat.php on line 309

Notice: Undefined index: metric in /home/sherida1/public_html/rabbit/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/PdfFormat.php on line 309

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 32 bytes) in /home/sherida1/public_html/rabbit/administrator/components/com_civicrm/civicrm/vendor/dompdf/dompdf/include/frame.cls.php on line 180

After seeing the memory size error, I tried something simpler. Selected the first 10 names from the search result and tried "Make Mailing Label" Results:

Strict Standards: Non-static method CRM_Contact_Form_Task_Label::buildQuickForm() should not be called statically, assuming $this from incompatible context in /home/sherida1/public_html/rabbit/administrator/components/com_civicrm/civicrm/CRM/Member/Form/Task/Label.php on line 60

TCPDF ERROR: Some data has already been output, can't send PDF file

I will examine the lines of code mentioned, but I hope that someone can quickly identify the issues.

Thanks,
Kate


texts: Set Default View for Views For Display Contacts in Advanced Search Form

texts:
I want to change the columns that are shown in the advanced search results.

I have created a Search Views Profile and this shows up in the dropdown list of the Search Views on the Advanced Search Form. This works fine. Is it possible for me to make this Search View Profile the default Search View?

I looked in the admin screen for customising search preferences (civicrm/admin/setting/search?reset=1), and there is a dropdown for the Default Contact Search Profile, but my Search Views Profile does not show up in it.

It would be helpful if I could make my search view the default so that users do not have to select it each time they do a search.


texts: CiviCRM 5.28.2 triggering "critical issue" in WordPress 5.5 Site Health

texts:
This is related to WordPress Site Health contains critical errors unless CiviCRM is disabled but I'm raising it because

WordPress 5.5 adds the "active PHP session was detected" issue
There was no response to RiverRunner's request for the basis for saying the test are inaccurate

I'm currently running WordPress 5.5 and CiviCRM 5.28.2.
The Site Health function in WordPress 5.5 reports 3 three "critical issues" related to the WP REST API.

An active PHP session was detected - A PHP session was created by a session_start() function call. This interferes with REST API and loopback requests. The session should be closed by session_write_close() before making any HTTP requests.
The REST API encountered an error - The REST API is one way WordPress, and other applications, communicate with the server. One example is the block editor screen, which relies on this to display, and save, your posts and pages.
The REST API request failed due to an error.
Error: cURL error 28: Operation timed out after 10005 milliseconds with 0 bytes received (http_request_failed)
Your site could not complete a loopback request - Loopback requests are used to run scheduled events, and are also used by the built-in editors for themes and plugins to verify code stability.
The loopback request to your site failed, this means features relying on them are not currently working as expected.
Error: cURL error 28: Operation timed out after 10004 milliseconds with 0 bytes received (http_request_failed)

This discussion suggests that the problem is with plugins and themes that need to be updated. By elimination, I found that CiviCRM 5.28.2 was triggering the error.
Can these "critical issues" safely be ignored and, if so, why or under what conditions?


texts: Blank page when trying to edit contribution profile settings

texts:
When loading Contributions > Manage Contributions Page > Artist Membership > Configure >  Title and Settings >  Profiles > Edit under first option
a blank page is coming up.  I don't see any errors in the logs, but when I inspect it, the following errors come up:

Failed to locate field: contact_1.custom_46 undefined

This is the section of js with the error:

CRM.console = function(method, title, msg) {
    if (window.console) {
      method = $.isFunction(console[method]) ? method : 'log';
      if (msg === undefined) {
        return consolemethod;
      } else {
        return console[method](title, msg);
      }
    }
  };

I'm running the latest version of CiviCRM, on Drupal 7.


texts:
One of my users created a petition: Both he and I responded and it appended our responses to the wrong records. I wasn’t logged in and it tried to write to an {surname matching mine]. I suspect that this is the first A. Ross and it is only matching surnames. It appends my data to the existing record.

I just re-submitted my petition signature and it over wrote it again...
Re-submitted petition after changes - Logging Details

Top of Form
Change to Mrs Peter Ross made by on 2015-12-14 10:00:03:

Field
Changed From
Changed To
Sort Name (id: 1945)
Ross, Alison
Ross, Peter
Display Name (id: 1945)
Mrs Alison Ross
Mrs Peter Ross
First Name (id: 1945)
Alison
Peter
Modified Date (id: 1945)
2015-12-14 09:15:43
2015-12-14 10:00:03
Source Record (id: 1375)
7
Activity Type ID (id: 1375)
Petition Signature
Subject (id: 1375)
Petition to xxx xxx
Activity Date (id: 1375)
2015-12-14 09:58:53
Activity Status (id: 1375)
Completed
Priority (id: 1375)
Normal
Test (id: 1375)
false
Auto (id: 1375)
false
Is this activity a current revision in versioning chain? (id: 1375)
true
Activity is in the Trash (id: 1375)
false
Campaign (id: 1375)
12


texts: how do you include email as field in all the contribution reports in Civi CRM

texts: I am new to Civi and am trying to create reports for a fundraising department. How do you add email (or other columns/fields) to the standard contribution reports.


texts: Report for number of events attended by each person

texts:
I would like a report that lists the number of events attended by (or registered by) each participant.  This seems like something that a lot of organizations would find useful, yet I can't seem to find anything even close to this that I could customize into what I'm looking for.  Am I missing something, or is there no such report in existence.  If not, any suggestions.
Thanks,
Rick


texts: Search primary details only, turned off - duplicate/additional case export lines

texts:
The additional feature to choose whether or not to search primary details only (introduced somewhere in Civi 4.7) has an undesirable effect on case exports - with the preference set to 'no'.

As an example, if I run an advanced search for all ongoing cases of a certain type and try to export some of their information:

If you turn OFF search primary details only and export by case (not by contact) individual information like primary email or primary phone (provided the contact has more than one email/phone) it will export multiple rows per case. It ignores the fact that I asked it to export ONLY the primary email/phone etc and exports all the phone/emails the contact has.
Any other location chosen, 'home', 'other', etc is respected. Outputs one line, or if there is more than one home item, it exports additional lines but only for that location.
If I turn back ON the export works as you'd expect, one line per contact with the primary email/phone listed.
Exporting by contact has no issues with search primary details only turned off.

(Civi 5.5.3, Drupal 7.61, verified this behavior happens on the demo.)

While I know turning off search primary details 'fixes' the export issue. We were looking to use this feature to better search contacts with multiple phones/email. Can someone point me in a direction to what file might be controlling the case export


texts: Can I automatically replace the "civicrm" from all URLs with another string? (drupal7 + civicrm 4.7.4)

texts:
How can I replace the '/civicrm/' portion of all site URLs automatically? I want change all the URLs so I cant do it one by one with a Drupal "URL alias".

Could I somehow swap the name 'civicrm' for a different string such as 'myOrg'? (eg: if someone visited /civicrm/admin?reset=1 they would be redirected to /myOrg/admin?reset=1 )


texts: Error on merging duplicate contacts, wordpress, civi 4.4.14

texts:
Scenario 1:
1.  Select last name, email rule, all contacts
2.  List of potential dups is displayed
3.  Select first pair
        a) Displays error message at the top of the screen:

: title in /home/cooldavis/www/www/wp-content/plugins/civicrm/civicrm/CRM/Dedupe/Merger.php on line 141

Notice: Undefined variable: userRecordUrl in /home/cooldavis/www/www/wp-content/plugins/civicrm/civicrm/CRM/Dedupe/Merger.php on line 143
        b) select merge and go to next pair:

Notice: Undefined variable: title in /home/cooldavis/www/www/wp-content/plugins/civicrm/civicrm/CRM/Dedupe/Merger.php on line 141

Notice: Undefined variable: userRecordUrl in /home/cooldavis/www/www/wp-content/plugins/civicrm/civicrm/CRM/Dedupe/Merger.php on line 143

Warning: Cannot modify header information - headers already sent by (output started at /home/cooldavis/www/www/wp-content/plugins/civicrm/civicrm/CRM/Dedupe/Merger.php:141) in /home/cooldavis/www/www/wp-content/plugins/civicrm/civicrm/CRM/Utils/System.php on line 361


texts: How do I use custom Smarty functions in a Form?

texts:
The "Extending Smarty" page at http://wiki.civicrm.org/confluence/display/CRMDOC/Extending+Smarty gives instructions for writing custom php functions and calling them from Smarty templates used in Pages, by using the pageRun hook to add a plugin directory to your template.  But this doesn't work for Forms.

For example, a custom function works from the main Case dashboard, but not from the search view when filtering Cases by status.

How do I have the plugin directory included in Forms, not just Pages?


texts: Calendar of Activities for CiviCRM 4.7.3 on Wordpress 3.8.5?

texts:
Is there a way to get a calendar view of Activities for CiviCRM on Wordpress? I can easily get all of them in a sequential list using Find Activities or the dashboard widget, showing all the information I require (type, date and time, "with", and "assigned to"), but I want a week or month planner/calendar view to make it easier for users to see at-a-glance when meetings are.

The Contact Calendar extension does not work, giving an error message about being unable to connect to the site. In any case I don't think it's what I need, because I want more than just one person's calendar. There are extensions for CiviEvent and some discussion of calendars in Drupal here on StackExchange, but I've not found a way to get what I want in a CiviCRM/WP installation.


texts: Icons are not populating to be selected for Activity Type Options

texts:
Until today I have been able to change or add an icon to an Activity Type.  Now when I click on the icon, the Choose Icon box pops up with a search dialog and the option for no icon but I'm not seeing the list of selectable icons underneath.
After noticing the behavior I have:

Rebooted the server
Cleared cache locally (Wordpress and CiviCRM cache) and from Cloudflare.
Upgraded from CiviCRM 5.29.0 to 5.29.1
Disabled all extensions and reenabled them.
Disabled all extensions except for Shoreditch and CiviCase v5.

Example screenshot:

It may be important to mention that I am using Wordpress with CiviCase and the CiviCase v5 extension.
Any ideas what could be causing this?  It worked perfectly until this morning and I didn't add anything new to the environment.  Many thanks!


texts: In display preferences I have an option to set the menubar above or below content, but the styles for the menubar are not loading. It just dumps the list of links. Any ideas what the deal is?


texts:
I am not able to schedule any reminders.  This happens whens pretty much everywhere.. whether I'm trying to set this up for Events, or even generally in CiviCRM > Administrator > Communications > Schedule Reminders

Anyone have any idea what is going on?  This is the only error I get..

FYI:  Powered by CiviCRM 5.6.0

  Error: Call to undefined method
  CRM_Admin_Form_ScheduleReminders::setContext() in
  CRM_Admin_Form_ScheduleReminders->buildQuickForm() (line 69 of
  .../sites/all/modules/civicrm/CRM/Admin/Form/ScheduleReminders.php).


texts: How to include individual information within organization record

texts:
I admin a CiviCRM 4.6 site running on Joomla 2.5. It's a company-based membership organization, and we're looking for a better way to keep track of prospect activity. Here are a few considerations:

We process memberships manually, so all main members are organizations, with individuals receiving the "employee of" membership status.
We want to keep track of activities such as phone calls and emails from within the organization record, in case we get a new main point of contact for a particular company, the activity record stays in the same place.
We've created a separate category for individuals called "Main Contact" used for reports, so when we pull a list of members, we get the main contact person's information.

With this in mind, is it possible to have particular fields (such as name, title, email, phone, etc.) from the designated "Main Contact" pulled into the organization's record? I've worked with databases that did this, where you entered in the ID number for the main contact into the company record and it pulled in and linked the individual's information. Then, when running a report for members, you can set it to pull just member organizations, but have the person's name and contact info. It would also allow for easier prospect management, by being able to have a record of all activity stay with the company. So a new email from the company profile would go to the "Main Contact."

If this isn't possible, any ideas for a workaround?


texts: "Membership status cannot be calculated for " Renewal Error!

texts:
I am on Joomla 3.8.7 and civiCRM 4.7.31. Recently, Two members received the following error message when trying to renew their memberships:

  "The membership cannot be saved because the status cannot be calculated for start_date: 20170101 and end_date: 20171231 join_date: 20170306 as at 2018-05-04 22:00:50"

Over 100 members have successfully renewed their memberships this year so I'm not sure why this is happening.

Can someone help?


texts: Sanity check for adding customer (sales) data to database with donations data

texts:
I am importing a large amount of customer data for a charity's shop into CiviCRM. Of course we would like to be able to use this data alongside existing data from donors and contributors.

I have made a new Financial Type and a new Financial Account to hold this data and keep it separate from the donation data. Is the best thing to do now to make a new Price Set which includes all of the items in the store? Is there anything I should know before I do this to avoid polluting the dataset? Should I process each Sale in the same way as a Contribution? I am worried this will pollute overviews of the dataset by inflating the amount of money the charity appears to have at any one time, given that the actual assets for the sales transaction is equal to (sale value minus item cost).

I should clarify that I am a software engineer not an accountant and I have no idea if this is a reasonable concern or not.

Edit: The shop is based in BigCartel. I am building a script which imports historic sales data and will also function as a webhook (e.g. IPN) for future sales.

They have 60 products in 14 categories. Each product has different types, e.g. 'small t-shirt', 'book with £5 donation', etc. Fairly standard charity gift shop fair -- t-shirts, books, stickers, etc. My understanding is this system should accurately reflect financial data but isn't being used to keep inventory. The purpose of the integration is mainly to increase demographics and sales monitoring to tie the shop data into CiviCRM with data from other sources (e.g. newsletter subscriptions, social networking, etc.).

I'm not sure if I should then make a new price set for each category and map the data that way. One thing I would like to do when I make a new Price Set is to say that the price set is used for "Product Sales", not "Contributions", "Events", "Memberships", etc. Though the business logic is probably similar, it seems that a product sale is inherently a different kind of event to a donation. I can't seem to figure out how I'd do that without making a new module though...


texts: Where is the 'Recent Items' block in Drupal 8

texts:
I have CiviCRM 5.33.2 on Drupal 8.9.12.
On Drupal 7, CiviCRM created a number of Drupal Blocks that could be displayed according to the Theme configuration, including the very useful 'Recent Items'.
On Drupal 8 I am not seeing any of these Blocks at all.  Where are they?


texts:
I have a fresh install of Joomla with CiviCRM 5.3.5 installed. I can’t seem to get the CiviCRM ACL to take over instead of Joomla’s All or nothing permissions. Documentation doesn’t seem to explain this very well. I need to have a coordinator to edit some specific contacts on the frontend of Joomla.
Thanks.


texts:
For some reason none of the mailing settings seem to be accessible for me anymore. When I go to e.g. Administer > CiviMail > Mailer settings all I get is a blank screen, and it's the same for other mailing settings as well. We haven't been able to find why the settings aren't visible anymore so any advice would be much appreciated.
We're running on CiviCRM 4.7.15 and Drupal.

Thanks,
Saeunn


texts: Custom View in Advanced Search not showing information

texts: I'm having an odd situation where a custom view that I created for Advanced Search sometimes shows information and other times does not show information within the same search.  Has anyone had this happen before?  I can confirm that the first record in this picture does have information stored in the current citizenship field.  We are using 5.16.4.


texts: How do I sync contacts who are not members in Wordpress?

texts:
My client organization only has organizational members, but provides services and events to individuals connected to the organization. The WP Member sync, seems limited to only syncing members.

I need to create users who are associates of member organizations. Those are mostly 1 to many type relationships. I have some that are many to many type relationships. This is my last step and I hadn't realized there wasn't an obvious path here. What is the proper way to proceed to import these users?


texts: Constituent type not set when new user with role(s) synchronized as contacts in group(s)

texts: How is the Constituent Type defaulted on user to contact synchronization. I've matched up Drupal roles to contact groups but when I synchronize the user, I get an error on display caused by a missing constituent type. When I added a constituent type for the new user/contact, the problem was fixed. Does the constituent type have to be mandatory? Or is there a default method for constituent types?


texts:
We're planning to use CiviCRM for a large number of voters (~10M voters). Most of these voters will never be contacted and so we don't need all of them in CiviCRM. We'd like to store these contacts in AWS S3 and use a querying service like AWS Athena. We query the data in S3 and only upload the filtered list of contacts. We will use the Athena API and the CSV Import API to fetch data from S3 and import to CiviCRM. My questions are the following:

Any architectural suggestions on making this work?
Any alternative approach to make this work?
What happens when too may contacts are uploaded into CiviCRM? Any suggestions on splitting them into multiple databases when the size grows?


texts: Creating membership with civicrm_api3, inherited membership

texts:
I'm trying to create inherited memberships in the civicrm_post hook. I feel like there is something wrong with the api itself. The API doesn't even recognize my only membership id in the database.

Here is the one membership record in the db:

When I try to create the API create statement, I can't even select the only ID in the database, which is 4:

My actual code looks like this:

The resulting logs from that function are here:

When submitting the form, I get no error on the front end and you can see the log showing no error as well, but nothing gets submitted to the membership table. I'd also like to note that in another hook (the civicrm_postProcess hook), I am successfully taking values from a contribution form and creating relationships between an organization and the primary member submitting the form and the additional members provided in the form values.

The main question is, How can I add new, inherited memberships to the members table with code?

This question is based on part of an extension I am making to try to solve this problem:

Membership for Group of people. One payer

I'm using Joomla! 3.9.16 CiviCRM 5.23.3

Extra Information / Edits:

Here is my relationship table, showing that there are relationships to the primary members already:

Here is my relationship_type table:

Here is my membership_type:

Here is my organization contact from the contact that holds the parent membership:

Here is the individual contact from the contact table that I am trying to give an inherited membership:

Edit - Membership Type Screenshot:

Relationship Types :


texts:
Anybody know if the Intuit Quickbooks Merchant Services Payment Processor extension is still in the works?

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

or if this will work with civi 4.6x, I see it's been used on 4.X as recently as 2015.

Is the Intuit processor active/functional?

thanks.


texts: Updating an option value with drush cvapi

texts:
I'm suprised that it is so hard to update an option value in a certain group using our API.

I have been writing scripts as follows:

get option group id where option group name = X (save as OptionGroupIDX)
get option value id where option value name = Y and option group id = OptionGroupIDX =(save as OptionValueIDY)
update OptionValueIDY title to Z

I'd like to be able to write scripts that look more like:

update the option value X in option group Y to value Z

The real world shell script I'm using at the minute is as follows:

OPTION_GROUP_ID=`drush cvapi OptionGroup.getvalue return=id name=from_email_address`
OPTION_VALUE_ID=`drush cvapi OptionValue.getvalue return=id option_group_id=$OPTION_GROUP_ID`
drush cvapi OptionValue.create id=$OPTION_VALUE_ID label='"Fixed" <info@fixed.org>'

Anyone able to help me get it closer to a one liner? Would be awesome if so because patterns like this seem to come up a fair amount when I'm working with the API. Would chaining help here?


texts: civix civicrm:ping error [Exception] Failed to locate civicrm.settings.php

texts:
I just installed CiviCRM BuildKit using the instructions here

After accessing the bash shell of the container with:

docker-compose exec -u buildkit civicrm bash

I try running the command

civix civicrm:ping

in the /src folder, I get the error

  [Exception]
  Failed to locate civicrm.settings.php. By default, this tool searches the parent directories for a standard CMS (Drupal, WordPress, etal) and standard civicrm.settings.php. Symlinks and multisite configurations may interfere. To customize, set variable CIVICRM_SETTINGS to point to the preferred civicrm.settings.php.

How can I get the command(s) to work correctly?


texts:
Joomla 3.7.0
CiviCRM 4.7.19
PHP 5.5.38

I try to get a cron job running for civicrm with a joomla installation.

I looks the the wget does not allows me to get the third parameter over. see example eq1 and eq4. Quotes did not help either. See eq 2 and eq3

examples are senitize (PASSWORD USER MYKEY)
HSOMETHING stands for https . Stack exchange does not let me post otherwise

Please advice.

eq1
wget -O - -t 1 HSOMETHING://www.MYSITE.org/administrator/components/com_civicrm/civicrm/bin/cron.php?key=MYKEY&name=USER&pass=PASSWORD

Resolving www.MYSITE.org... 66.198.240.51
Connecting to www.MYSITE.org|66.198.240.51|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 76 [text/html]
Saving to: “STDOUT”

0% [ ] 0 --.-K/s ERROR: You need to send a valid user name and password to execute this file
100%[====================================================================================>] 76 --.-K/s in 0s

2017-05-21 17:34:57 (19.5 MB/s) - written to stdout [76/76]

[1]- Done wget -O - -t 1 HSOMETHING://www.MYSITE.org/administrator/components/com_civicrm/civicrm/bin/cron.php?key=MYKEY
[2]+ Done name=USER

**************************************************************************************
eq2

wget -O - -t 1 "HSOMETHING://www.MYSITE.org/administrator/components/com_civicrm/civicrm/bin/cron.php?name=USER&pass=PASSWORD@ki23&key=MYKEY"

Resolving www.MYSITE.org... 66.198.240.51
Connecting to www.MYSITE.org|66.198.240.51|:443... connected.
HTTP request sent, awaiting response... 500 Internal Server Error
2017-05-21 17:37:04 ERROR 500: Internal Server Error.

**************************************************************************************
eq3
wget -O - -t 1 'HSOMETHING://www.MYSITE.org/administrator/components/com_civicrm/civicrm/bin/cron.php?name=USER&pass=PASSWORD@ki23&key=MYKEY'

Resolving www.MYSITE.org... 66.198.240.51
Connecting to www.MYSITE.org|66.198.240.51|:443... connected.
HTTP request sent, awaiting response... 500 Internal Server Error
2017-05-21 17:38:45 ERROR 500: Internal Server Error.

**************************************************************************************
eq4
wget -O - -t 1 HSOMETHING://www.MYSITE.org/administrator/components/com_civicrm/civicrm/bin/cron.php?key=MYKEY&name=USER&pass=PASSWORD@ki23
Resolving www.MYSITE.org... 66.198.240.51
Connecting to www.MYSITE.org|66.198.240.51|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 76 [text/html]
Saving to: “STDOUT”

0% [ ] 0 --.-K/s ERROR: You need to send a valid user name and password to execute this file
100%[====================================================================================>] 76 --.-K/s in 0s

2017-05-21 17:41:04 (23.3 MB/s) - written to stdout [76/76]

[1]- Done wget -O - -t 1 HSOMETHING://www.MYSITE.org/administrator/components/com_civicrm/civicrm/bin/cron.php?key=MYKEY
[2]+ Done name=USER


texts: Which table is used for hook_civicrm_triggerInfo?

texts:
I have a rebuild trigger action that is failing.  It is trying to create a trigger on civicrm_contributiion_recur.  Clearly it has 2 i's and shouldn't.  There is or was a trigger on the table without the extra i, so I figure it got stored in the db incorrectly.  I went off in search of just where that stuff is stored but alas haven't found where.

So when you use hook_civicrm_triggerInfo to create a custom trigger where is that info stored?

Or when civi does an index rebuild how does it collect the list of tables and the bodies of the triggers?  It needs to do this so it can combine any triggers civi core has with any custom triggers an extension or customization has added.


texts:
In the section Administer -> System Settings -> Extensions, when I click on the Add New for the list of 'native' extensions there are none there. I get the message

  There are no extensions to display. Please click "Refresh" to update information about available extensions.

Even after clicking Refresh I still get a blank page. It might be sometime similar to this bug, but it is marked as fixed:

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

If it's relevant, I also have a completely blank newsfeed on my main CiviCRM login page. It says:

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

My directory settings all seem to be correct, and I am using the CiviMobile extension without any problems.

I am using CiviCRM 4.7.12 on Wordpress.

===

Update: it started working again properly. No idea why...! Case closed.


texts: Haven't seen this in a while: jQuery is not defined on CiviMail 4.6.16

texts:
Yo dudes, let's get the con started with this classic!  Haven't seen this beast in a while.

recently updated to 4.6.16
theme Seven
ran update.php after upgrade
cleared Civi and Drupal cache
Drupal cache off

Still the issue with field selects and jQuery error is happening (attached images).  Feeling kind of duncey here. Any ideas?

Stuart


texts: How to count event attendees with price sets and multiple bookings?

texts:
I am using price sets with events. In all the reports it has 'Fee Level' and it looks like this

Two Day Passes - 2,

I can count the number of people who registered, but not the number of passes sold except via, filter on 'Fee Level' and 'sed and awk'.

awk -F',' '{print $6 }' Report_20160905-720.csv | sed 's/"//g' | awk -F ' - ' '{sum+=$2} END {print sum}'

The fees section of the event is setup with price sets and field type 'number' which is the count. If I purchase 2x $30 passes the form calculates the amount. The reports however, have Two Day Passes - 2 and I can't see how to add up the actual number of passes bought, just the number of registrations.

Thanks


texts: CiviRules - What does 'Compare with original value (before the change)' do?

texts:
There is a checkbox for the field value comparison that is Compare with original value (before the change)?

What functionality does this do? I looked at the docs (https://docs.civicrm.org/civirules/en/latest/basic-example-field-value-comparison-condition/) but didn't see an explanation.
My use case is I have a custom field that is a set of checkboxes. I am adding an activity based on a a specific custom field value being selected but I don't want it to do trigger my action (in this case an activity) each time the fieldset is saved if the value is already selected. I thought that this option may be checking if the field value changed but it still added the action.
FWIW, I created a regular group that the CiviRule adds them to. My condition checks Not in Selected Group [the group] to get it to work.


texts: Is the free() method being called inadvertently on my DataObject?

texts:
This behaviour happens on a certain environment, but not on another. I am trying to work out why.

There is a while loop in CRM_Mailing_BAO_MailingJob::deliver() that cycles through emails to be delivered.

I noticed that the loop was ending prematurely. I tracked this down to some custom code I had addes that was adding a token. In this code, I was calling MailingJob.getsingle.

It turns out that many calls to the API and it seems other methods too will cause the loop to end prematurely.

The simplest proof of concept I came up with was

var_dump($eq->N);
while ($eq->fetch()) {
  civicrm_api3('Contact', 'get');
  var_dump($eq->N);
  var_dump($eq->fetch());exit;

which outputs

int(50)
int(50)
bool(false)

which is madness, I am sure you will agree.

Do you have any ideas what is going on here?


texts: In 4.7 a contact's activites are in ascending date order: should that be descending?

texts:
In previous versions of CiviCRM, a contact's activities were listed most recent first on the Activities tab of their record. This is handy for seeing what they've been up to recently.

In 4.7 they're shown oldest first. As we've been using CiviCRM since 2008 some of our data is OLD!

Is this a feature or a bug?

If it's a bug, it can be fixed by modifying line 42 of templates/CRM/Activity/Selector/Selector.tpl and changing "asc" to "desc".


texts: I have a Wordpress multisite that I have civicrm installed on.  I did an upgrade to the new version and the database shows that it is the new version.  Problem is that the civi dashboard thinks it has not been upgraded and shows an error.


texts: SMTP Socket Error or failed to set sender error....Recipient address rejected: Domain not found; CiviMail keeps trying

texts:
When a CiviMail job is running, if one of the recipients has a bad email address, the CiviMail processor throws a set of errors into the Drupal watchdog log, with this message:

SMTP Socket Error or failed to set sender error. Message: Failed to add recipient: ted@jessicommunity.org [SMTP: Invalid response code received from SMTP server while sending email.  This is often caused by a misconfiguration in Outbound Email settings. Please verify the settings at Administer CiviCRM >> Global Settings >> Outbound Email (SMTP). (code: 450, response: 4.1.2 : Recipient address rejected: Domain not found)], Code: 10005

There seem to be two problems.

First, the error message seems to be misleading by suggesting that the problem is a misconfiguration in Outbound Email settings, which doesn't offer any settings related to handling unfound domains.

The more serious problem is that CiviMail will keep trying this address every time the CiviMail processor runs, thereby it will never complete the job and fills the watchdog log with error messages. The only way to stop the loop without actually cancelling the mailing job is to delete the relevant row in civicrm_mailing_event_queue (and then put the offending email on hold to prevent it from happening in the future).

It seems like the proper behavior would be for CiviCRM to treat that error like a bounce; but certainly not to keep trying it over and over.

Is that the appropriate behavior?


texts:
I'm having an issue whereby clearing Civi cache is the only way to make some fields visible on a Drupal 7 user profile. I've tried to debug the issue and it seems to be caused by anonymous users viewing the account, where they don't have the permission to view those fields and it caches that result of seeing nothing.

My issue for now however, is that in Drupal's sites/default/civicrm.settings.php file, I've set the cache to:

  define('CIVICRM_DB_CACHE_CLASS', 'NoCache');

I've debugged it and check that CIVICRM_DB_CACHE_CLASS has not already been defined but Civi is still caching those results. How can I fix this or how else can I turn off Civi caching?

Logged in as admin, this is what the profile looks like before clearing caches:

And then after clearing caches:


texts: Does the 'timestamp mismatch' error cause any real problems?

texts:
I am getting the following error when I log in to CiviCRM:

  Timestamps reported by MySQL (eg "2015-11-06 13:44") and PHP (eg
  "2015-11-06 11:44" ) are mismatched.

I have reported this separately and haven't been able to fix this yet.  However, I wonder if it actually causes any real problems or if I can just ignore this error message.

Does anyone know what problems are caused if the timestamps for PHP and MySQL don't match?

The code that displays this error is in CRM/Utils/Check/Component/Env.php.

Elsewhere in the CiviCRM code there is a function to set the MySQL timezone: CRM/Utils/System/Base.php.  If this sets the MySQL timezone in code does it matter that the PHP and MySQL timezones don't match?


texts: Newbie question: Will "Pending" change to "Current" when Status Override reaches the selected date?

texts:
I have a member who has paid for a new membership and asked it to start when his current membership expires. At the moment, both read as "Current." If I use "Status Override" until a select date and change his status to pending, will that "pending" automatically change to "current" on that selected date?
Tony


texts: Using Civi to manage members' lists of items available for donation to other members

texts:
I'm helping an organization that connects with wealthy schools to share surplus items (from scissors to books to furniture) with under-funded schools.

I'm looking to set something up so the wealthy schools can create a membership account online, create a list of items they have available, and then those items can be assigned to various under-funded schools, which have also created their own account along with a list of what they need.

These lists are currently being done through spreadsheets, but I'd like a way to integrate the list functionality with the member management functionality. At the very least my hope is that doing that will give more power to the schools to facilitate the donations on their own, and I hope it will make it easier for past donations to be displayed online. Ideally, I'd like the software to automatically assign the items to the schools in need, but that's probably asking too much.

Anyway, my main question is: will Civi be helpful with the management of these donation item lists, or are good old Google spreadsheets the way to go?


texts: Free event with sessions with max participants

texts:
We have a free event that has several sessions with a max participant limit of 15.  I've set that up with price sets with $0.00 amounts.  It works fine, but because price sets are designed for paid events, there's a bunch of work to hide the pricing information from the user (css to hide the amounts on the registration, confirmation and thank you pages, modify the confirmation email to hide the payment sections and write a hook so Civi doesn't add the $0 contribution which is added, or tell folks to ignore those $0 contributions and delete them at some point.)

Just wanted to make sure there isn't a better way to do this.  Any suggestions would be welcome.


texts: Civi Event - Event Title & Event Name with French accents not saving in correct encoding

texts:
Database/environment is set to UTF-8. This just started happening and we can't figure out why.

In the example below, a French title and summary are given -- when saved, the Title appears to be saved properly with the correct accents, but the Event Title field value converts the accented characters.

The Event Description area saves accents fine (it has TINYMCE enabled).

Thoughts?