texts: civiCRM Cron only run one mail_report scheduled jobs?

texts:
I'm using CiviCRM 4.4.6 in drupal 7.

In my scheduled jobs list, I had 3 scheduled jobs of membership report: report A, report B, and report C. These reports will send out email with different csv attachment.

When I click "Execute now", these 3 reports send email perfectly.

I'm using Elysia Cron to control both drupal and CiviCRM cron, and use external crontab to run cron in my control panel.

CiviCRM cron runs, but it only trigger report A. Both report B and C is missing.

My question is:

Does CiviCRM cron only allow one mail_report scheduled job to be run?

If so, does it mean that I have to put in multiple report IDs (instanceId) in one mail_report scheduled job?

I tested it, and only one instanceId is allowed in one mail_report scheduled job.

Is there any way I can send out multiple email reports when running cron?


texts: FAX. Is it difficult to hook up Twilio programmable faxing to CiviCRM?

texts:
I would like to be able to use Twilio programmable faxing directly from within CiviCRM. Many of my contacts only have fax numbers (no email addresses).

I tried to put FAX in the tag section below, but, apparently my account isn't mature enough to use the "F" word.

Has anyone successfully hooked up Twilio programmable fax to CiviCRM. The Internet is silent on the subject.


texts: When editing recurring contributions or changing payment details donor see "Network Error - Unable To Reach The Server"

texts:
Drupal 7.61
CiviCRM 5.4.1

When you click Edit or Change Billing on recurring donations, donors get "Network Error - Unable to Reach the Server"
I do get a console Error and a Warning.

Warning = jquery.min.js?pjxwd7:4 [Deprecation] Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user's experience. For more help, check xhr.spec.whatwg.org.

Error = VM1127:1 GET secure.radiusinternational.org/civicrm/… 403


texts: Tracking/Reporting Invitees vs Attendees (CiviEvent)

texts: We want to find an easy way to track how many people from our invitee list actually signed up for or donated to our event. I was planning on putting all invitees into a 'group', and then tracking RSVP's in CiviEvents. We do physical mailings instead of e-mails right now, so if we can trim the list of people we know don't attend or donate it could save us on postage. Would anyone know of a way to pull a report on this somehow?


texts: Can I export custom data from a Contact, an Organization and an Activity in one export?

texts:
I am trying to set up a custom field mapping to export after I search for Activities.  I would like to export data associated with the Activity, but also include data from the Individual Contact and related Organization.  All the fields are available when I export my activity, but the data does not export for the Organization.

Thanks


texts: Can invoices be sent to and cc'd to multiple contacts?

texts:
I am trying to replicate an existing workflow within CiviCRM. I need to be able to send membership invoices to multiple recipients. An example is:

Subject: Membership invoice
To: accounts_payable@member.com, finance_director@member.com
cc: budget_holder@member.com, person_that_cares@member.com, secretariat@civicrm_user.com

Ideally this should be a single mail so that each recipient can see the others and whether they are "To" or "cc".

The current "email invoice" in contributions only seems to email the primary billing contact. Is it possible to do what I want?


texts: How to sell membership on event page and apply the membership discount? (Autodiscount)

texts:
Is it possible to have a CiviEvent page that offers a membership, and if you select that membership, receive a discount on certain price set options in the same form?

I found this: https://github.com/aghstrategies/com.aghstrategies.eventmembershipsignup

However it remains unclear if it will do the above.

Things I've considered:

Webform CiviCRM. Can't use it because it does not support complex price sets and loses the abilities of Civi to change/update registrations.
Drupal Commerce / Rules - same as above.
Having people sign up for Membership using Contribution Page, pay, then go to Event page, pay. Two payments, too many steps.

Thank you for your help.

Reasoning: we want to encourage people to join as a Member to receive a discount from our event and have it done on one form. Currently there is no easy pathway for this AFAIK.


texts: Self referential Smart Group - good idea?

texts:
An organisation has local campaign groups. Some of these campaign groups belong to a set we call the "core activist network".
I want the core activist network group to contain:

all these groups that are manually added
all individuals that are related to a local campaign group which is part of the group.

I've set this up as follows:

Search for "name contains 'a'" - anything that will return at least one result.
Save the search as a Smart Group.
Add at least one local campaign group to this group manually (Add to Group).
Edit the smart group criteria, remove the silly 'a' criteria, then go to Relationships, choose "Target Contact(s) in group" and enter the name of this smart group!
Run the search and from there click Update Smart Group.

Amazingly, this appears to have worked! But is there a reason why this is likely to end up in knots, e.g. some infinite loop? Since calculating the smart group requires...calculating the smart group.
I realise that this is likely to fall foul of SE's "answers likely to be opinion based" but I think this is a valid case. I encourage anyone to upvote any answers that point out potential problems with this situation. Of course, if someone says "I've done this and it works beautifully" then I'll accept that answer as an expression of joy :-). I'm also interested in any answers that are along the lines of "that's daft, but you can do it like this instead:..."
Thanks in advance wonderful Civi community!


texts: Issue exporting and importing Contacts / Membership data

texts:
first time posting and really hope someone can help me!

We are trying to EXPORT our data from an old installation of CiviCRM on a drupal server IMPORTED into a new installation of CiviCRM on WordPress. All of the data has been exported using CiviCRM's built in export so we have all of the fields etc.

When importing Contacts using the CiviCRM import option you of course have to match all the fields to what is in your spreadsheet and here is where we run into a problem ... we have exported the contact ID and have contact ID for all contacts but there is no field Internal Contact ID to select / match to when importing data!

When we import Members there are TWO required fields, internal contact ID AND external contact ID ... we can't import internal contact ID to internal contact ID here, because since there was no option to do that when importing Contacts, all the contacts we imported were given different auto increment contact ID's.

We were thinking that when we import contacts we will map Internal Contact ID -> External Contact ID (since there is not an Internal Contact ID option to import to) .... then when we import members we again map Internal Contact ID -> External Contact ID .... then the External Contact ID will be the same for both members AND contacts .... effectively connecting them ... so that is what we tried ...

When importing contacts we mapped Internal Contact ID -> External Contact ID. Then we made a blank column in the spreadsheet we were importing, which we named Contact ID and which was blank for every row, and when importing mapped the this blank field -> Internal Contact ID and the ACTUAL Internal Contact ID's from the old system -> External Contact ID's ... this way external id's would match for contacts and members, linking the two .... but we got error that Internal Contact ID's do not match (the blank value in the members import does not match the auto-incremented ID in the contacts table).

I did a test where I tried importing only one Membership record, where I took the new auto-incremented Contact ID and replaced the Contact ID that from the old system and this imported, properly linking the Contact and Member.

How come when you are importing though there is no option to import Internal Contact ID? Without using some complicated MySQL Query, only using the CiviCRM export / import, how am I able to do this without having to manually match every Member Record Internal Client ID with the newly created auto-incremented Internal Client ID created when I imported the clients?

I Hope this all makes sense.
Please help!

EDIT:
Thanks for your responses guys!

I know my post was a bit confusing so I'll try to explain it again more simply. We had CiviCRM on a Drupal system. We want to import the existing data into our new WordPress system (fresh install of CiviCRM).

When we import the contacts (which were exported from CiviCRM so we have all the fields) there is no option to import the internal contact id, so all the contact id's are now auto incremented and not the old ones. Then when we import members the contact id's don't match.

Because of this, on import we mapped the old contact id's to the external id field. Then when we import members though, even though we have mapped the contact id -> external id field for both (so they could sync that way) we saw that contact ID was a required field with asterix next to it .... but mapping the new auto incremented contact id's would require a TON of manual work!!!

I THINK WE GOT IT WORKING THOUGH!!!!

At first we tried making a new blank column that we would map to the "required" contact id when importing members but that gave an error that the contact id's were not valid (because they were all blank).

What we tried next, which I can't believe worked, was just setting the "required" contact id field to NOT IMPORT .... and it SEEMS to have imported all of the members records and properly synced them by their external id's!

I don't know if that made any more sense unfortunately.


texts:
I've been trying to test using checksums to access pre-filled Profiles, eg:

/civicrm/profile/edit?gid=1&cid=12&cs=12f12df65c25b4b31afb11726af4d5ca_1438265969_168

However it does not seem to be working in the current version of CiviCRM (4.6.x). The profile appears without any information filled, and there are no error messages displayed.

Using the same approach (same contact ID and checksum) to pre-fill an event form is working fine, eg:

/civicrm/event/register?id=442&reset=1&cid=12&cs=12f12df65c25b4b31afb11726af4d5ca_1438265969_168

Is anyone else experiencing the same problem? If so I'll submit a bug report.

Documentation for checksums at the bottom of this page: http://wiki.civicrm.org/confluence/display/CRMDOC/Tokens


texts: TWILIO CiviCRM SMS Conversations wordpress webhook

texts: I am trying to get SMS Conversations to work using Twilio. I have the outbound SMS working but the responses are not processed (inbound SMS to Civi). The given URL for the Webhook does not work. Is there a way I can figure out the correct webhook URL to input at Twilio?


texts: Path to image in CDN tax receipt extension

texts:
The images I use in my CDN tax receipts are stored as a full path but the container code that comes after /srv/bindings/ changes from time to time which makes it that the files are not found.

How can I store these images as relative paths?


texts: Set Billing Address to be Not Required in Contribution Page

texts: Authorize.net does not require a billing address. How can I configure my CiviCRM to also not require that on a Contribution page?


texts: CRM_Mailing_BAO_Mailing - Error 500 trying to view Draft, Unscheduled, Scheduled, and Sent Mailings

texts:
Drupal 7.52
CiviCRM 4.7.15
Apache/2.4.7 (Ubuntu)
PHP/5.5.9-1ubuntu4.20

For the past few versions of CiviCRM I am getting a 500 error when going to:

Mailings > Draft and Unscheduled Mailings (/civicrm/mailing/browse/unscheduled)
Mailings > Scheduled and Sent Mailings (/civicrm/mailing/browse/scheduled)

The browser page:

The www.EXAMPLE.org page isn’t working

www.EXAMPLE.org is currently unable to handle this request.
HTTP ERROR 500

Apache logs:

[Mon Jan 30 23:11:31.163855 2017] [:error] [pid 7942] [client xx.xx.xx.xx:36293] PHP Fatal error:  Call to undefined method CRM_Mailing_BAO_Mailing::getPublicViewUrl() in /home/USER/web/EXAMPLE.org/public_html/sites/all/modules/civicrm/CRM/Mailing/Selector/Browse.php on line 425

I can send a mailing, and it does go out, but as soon as I send it I get the error, and can never see the Scheduled and Sent messages.

I am a capable server administrator, and I've been hosting CiviCRM sites for seven years, but I have no idea how to even begin to debug or fix this error. I keep hoping the error will go away with each CiviCRM update, but it remains. Any help is greatly appreciated.

Thank you,
Tony


texts: Are case activity revisions no longer working?

texts:
Not sure when this changed. I'm using the master branch. There's a couple related things:

The default for "logging" on the Misc admin screen is off, but so is the default for "Enable Embedded Activity Revisions" on the CiviCase settings admin screen. So by default nothing is logged anymore.
Even if I turn on the setting on the civicase settings screen, it seems that there's then two sub-issues:

(a) a quick look at the code used by the activity form suggests it doesn't use this setting, and

(b) it looks like it should be making revisions anyway, but doesn't.

I can reproduce on dmaster.demo.

Anybody know when this changed and/or is it an intended change?

EDIT: This line 453 in postProcess is part of the problem, because it overwrites part of the passed in $params, but there's more going on somewhere too. Removing the line or reversing the arguments causes different problems.

$params = array_merge($oldActivity, $params);


texts: Child #2 Participant Status not updating after Payment by Check (a Bug ?)

texts:
I have one Parent + his 2 Children registered to a paid event (via a Webform) :

The Parent is the Webform Contact1 and Contribution holder, but has
no event-fee to pay
Each of the 2 children (Contact2 and 3) has an event-fee (65€ and 45€)
A Solidarity Contribution can also be paid ("Contribution Amount" of the Contribution page) (e.g. 11€)
I choose "pay later".

When I register, and before payment, the situation is as follows :

Contribution total amount : 121 € (65 + 45 + 11)
contribution_status_id = 2 (pending)
participant_status_id : Parent : 1 (registered) ; Children : 5 (pending)

When I record the payment (by check), the situation becomes :

contribution_status_id = 1 (completed)
participant_status_id : Parent : 1 (registered) ;
Children : Child 1 : 1 (registered) ; Child 2 : 5 (still pending).

From my point of view, Child 2 participant status should also become 1.

Nota : to record the payment, I use a Contribution Profile (check# + status), next to a Contribution "update multiple participant", but I don't think that the problem is due to this specific process.


texts:
I'm trying to find a best way to setup relationships to the Club that would only "allow" one person to be ex. "Secretary", "Coach" etc. Can this be done via Rules (either CiviRules or Drupal) or database trigger or, hopefully not, a custom module?
So basically, when a person gets assign a role, whoever had that role previously has the relationship removed or ended or de-activated.


texts: Disable Debit Card Payment Method option

texts:
It looks like I can not disable the Debit Card option in CiviCRM.

It is safe to disable this option in the database? Is there another option?


texts: Wordpress / Civi - How to Hide All Menus

texts:
Install is latest WP w/Civi plugin. We would like to hide top menus from end users based on roles and use links in the Dashboard instead for limited functions. I've read postings regarding making changes in Drupal permissions but hosting in Wordpress. I've also seen suggestions of modifying the Civi navigation.tpl file.

Any suggestions for a Wordpress install? Thanks!


texts: What are all the possible variable fields available in greetings (Email and Postal)?

texts:
When defining new email and postal greeting formats in Administer > Communications > Email Greeting Formats, I see several available variables like {contact.first_name}, {contact.last_name}, and so on.
I would be happy to see the list of all available variables.
More precisely, when I refer to {contact.individual_prefix}, I have access to the field Label of the corresponding table, but I want to access the field Description of the same table. I would like to know if this is possible, and if I have to install some extension in order to achieve that.


texts: How can I track donations made as a result of a particular email?

texts:
I know that I can see who clicked through on the "donate" link on an email - but I don't see a way to check if the donation was made as part of that interaction.

Is there a way to determine this?


texts: PCP confirmation email doen't contain user-login details. [ Drupal ]

texts:
After creating a PCP page this email (message template) is sent to user who has contributed and created a PCP page.

  Dear supporter,

  Thanks for creating a personal campaign page in support of [Contribution page name]. Promoting Your Page

  You can begin your fundraising efforts using our "Tell a Friend" form:

Login to your account
Click this link and follow the prompts

  Managing Your Page

  Whenever you want to preview, update or promote your page:

Login to your account
Go to your page

  When you view your campaign page WHILE LOGGED IN, the page includes
  links to edit your page, tell friends, and update your contact info.

  Questions? Send email to: info@example.org

My question here is,

How user can login to site since I see that there is no new user created on the site. I am not sure how this works for other but without any user creation they won't be able to login to site or edit their PCP page.

Please correct me if I am missing something here, I think user should be created and one-time-login url should be sent to user on the same email (message template).


texts: What Permission should I grant to allow some Contacts to sens SMS's

texts:
I have just installed Twilio Extension (to send SMS's)

What permission must I grant to enable some Contacts to send SMS's (currently, SMS - schedule/send action is only available to me (administrator))


texts:
I want to send out an email to all customers currently sitting in our ‘newsletter ‘  group asking them to opt in / subscribe to being in new 'Event & training group / Updates & information group...etc. We are getting ready for GDPR / 25th May.

What would be the easiest way to do this? Has anyone got any examples of how they have done this were customers have just clicked on a links and they have then automatically ended up in a group?

Thanks
Anna


texts: Event receipts for paid events contains extraneous information

texts:
Currently using CiviCRM 5.3.2 and drupal 7.60

Receipts for events paid via PayPal have extra information related to contribution.

To reproduce issue:

Add custom fields of your choice for Contributions
Create a paid event and assign PayPal Standard payment processor.
Enable online registration for the event and set Send Confirmation Email to Yes.
Register a participant for the event.
Check the receipt received and see if you get Contribution related custom fields in the email.

Anyone is facing this issue? May be with other payment processor?


texts: Replacing the Contact Dashboard with Views

texts:
Has anyone started a project of creating views to replace the contact Dashboard that would show:

Recurring Contributions
Memberships
Donations
Event Attendance
etc.

I am considering starting this project and wanted to make sure I did not duplicate any work.


texts: Need to make a group of members who have been members for 5 consecutive years

texts:
People who have paid member dues for 5 consecutive years get a discount. We do not have rolling membership.  jan 1 to dec 31 with a grace period of 6 months. I think that due to how the info was imported from our last CRM we cannot run it on dues payment.  We have dues payments that are really donations. It would be good enough to be able to find out who has been a member for the last 5 years and then we can add them to our old list.

I tried doing this in reports with a start date of 1/1/2011 end of 12/31/15 but I get people who joined all during that time.

Help


texts: Disable check that a web browser has already signed a petition?

texts:
Many of our subscribers have informed us of the problem that they sign our petition, and then when other household members go to sign the same petition (e.g. particularly grandparents who don't have their own computer) they are unable to.  I understand that clearing the cookie cache of the browser and thereby killing the sessionid or else opening a private window would be a work-a-round, but I'd like to just not have the problem.
Can anyone point me to which file in the source code performs this check?  And, as an aside, what do DAO and BAO mean?  How civicrm works is really a mystery to me...


texts: Upgraded to PHP 7.2; no errors but Sparkpost doesn't receive and send CiviMail

texts: I upgraded to PHP 7.2 and received the system warning stating "your SMTP password will not be stored encrypted, and if you have recently upgraded from a PHP that stored it with encryption, it will not be decrypted correctly." I updated our Sparkpost API key and everything on CiviMail's side seems to be working--all test messages go through and no errors pop up when sending email. However, when we tried to send a mass mailing, we got 100% successful deliveries but zero openings; upon further investigation, Sparkpost did not receive send any of the emails. Has anyone else encountered this or know a fix?


texts: How do I generate sql/civicrm_generated.mysql using bin/regen.sh file?

texts:
I am working on CRM-11369 bug. However, I was facing problems in generating sql/civicrm_generated.mysql using bin/regen.sh file. The fifth line of bin/regen.sh file is 'source dirname $0/setup.conf'. But there is no setup.conf file in this folder. So I made a copy of bin/setup.conf.txt as bin/setup.conf and filled in the values for CIVISOURCEDIR, DBNAME, DBUSER and DBPASS. I'm still runnning into errors.

I get the following error:

bower angular-jquery-dialog-service#civicrm resolve https://github.com/totten/angular-jquery-dialog-service.git#civicrm

bower retry Request to https://bower.herokuapp.com/packages/angular failed with ECONNRESET, retrying in 1.0s

It would be great if someone could help me with this.


texts: What could be causing slow mailing from CiviCRM (via SMTP)

texts:
We're currently investigating why our mailings are sending slowly from CiviCRM. We use an external SMTP server.

Our mailing settings:

Mailer batch limit: 30000
Mailer throttle time: 2100
Mailer job size: 0
Cron job limit: 1

However, when we look at the delivery table, the times individual emails were delivered are a bit strange:

10 emails delivered all on the same second
A delay of 2-3 seconds
Another 10 emails delivered on the same second
A delay of 2-3 seconds
Rinse, repeat

Has anyone run into a similar issue?

Update: After some testing, this only happens for SMTP (ie, not mail()), and it is happening with two separate SMTP providers. Investigations continue...

Update: Emails also send slowly from a standalone script which uses the PHPMailer library on the same server. That actually sends slower, at 2/3 emails per second but without a delay inbetween. The next step would be for us to try concurrent sending jobs (once this is fixed in 4.6.10).


texts: How do I stop the new "Security Notifications" that civi pops up for upgrades

texts:
As we keep an eye on these upgrade for clients, the last thing we need is for them to worry about it while we check out their customisations for compatability etc.

How to get rid of them?


texts:
Using the 'Update multiple contacts' action and a profile we get failures on large batches. The profile has 13 fields with 6 of them required by the profile.
If the update is run on one batch of 100 contacts, it fails complaining about multiple fields "... is a required field" despite a value being present. All the failing records are at the end of the batch.
If the same update is run as 2 batches of 50 contacts, it works as expected.


texts: Cannot edit links (or source code directly) in Scheduled Reminders

texts:
Configuration: Wordpress 5.1.1, CiviCRM 5.10.3

We needed to edit a link in our Scheduled Reminders and discovered we can no longer do so. This is the behavior:

We can edit these reminders just fine, but when we select linked text to edit (or to add a new link), I cannot put the cursor in the edit box to make the edit (see 1st screenshot below). That seemed strange so I clicked on the "Source code" edit button and, once again, I could not place the cursor in the window to make the edit (see 2nd screenshot below). I then checked the ability to edit in CiviMail and also in CiviEvents. I had no problem editing/inserting links there.

I thought this must have something to do with TinyMCE editor or possibly some weird conflict with our Wordpress theme, or even conflict with a block editor that we use (Elementor). I changed to a pure vanilla WP theme (2019) and deactivated Elementor. No dice. Thinking that it was TinyMCE, I upgraded Civi to 5.12.3. All these things did not fix this strange behavior.

Wordpress 5.x was a major upgrade regarding editing where they are pushing their Gutenberg block editor, so maybe this started when we upgraded to 5.x, but there's no turning back at this point, but I suspect there is some weird TinyMCE mess up somewhere and have no clue why it would only show up in editing Scheduled Reminders, whereas all edit functionality in CiviMail and CiviEvents seems to be working.

Any clues would be helpful. We NEED to edit our reminders as our special renewal contact links display weirdly under a recent WP theme change we made and we have it fixed by just pointing the contact link to a different page.


texts: CiviEvents Confirmation email not being sent

texts:
Using CiviCRM 5.7.2, using Drupal 7.61.

We use CiviEvents and have registrations turned on and confirmation emails enabled. Over the last month a few users have reported not receiving confirmation emails and I was able to replicate this myself today.

Essentially, the user fills in their details and then get a 500 error and no confirmation screen or confirmation email. However their registration pulls through on the back-end (I can see they registered for the event on their user on CiviCRM and I see them as a registrant on CiviEvent). But even though this is pulling through, it's not triggering the confirmation email to be sent to the registrant.

It looks like this happens at random - has happened to about 4% of our recent registrants in the last month. It causes a lot of frustration on their end and a poor user experience so would love to work out why it happens and if there's anything I can do to fix this.

Let me know if you need any more information or if this isn't clear.

Cheers,

EDIT: It just happened again. User gets redirected to [DOMAIN].com/civicrm/event/register. This happens after the "Confirm your registration details" screen.

EDIT 2: These are the two errors I see in Drupal's Error Log

Warning: Unknown: Cannot call session save handler in a recursive manner in main() (line of ).

and

Warning: Unknown: Failed to write session data using user defined save handler. (session.save_path: /opt/alt/php71/var/lib/php/session) in main() (line of ).

I have no idea what this means, can anyone assist?


texts: Removing "List-Unsubscribe" from civimail headers (for when getting seemingly random unsubscribes)

texts:
There is a "header" entry automatically put into mailnigs from civimail (also when using flexmailer / mosaico) which some email clients use to enable unsubscribing (or opting out) from mailing lists.

If, for example, an unsubscribe link is in your email, and the site is reporting opt-out's (or vice-versa) then this may be the reason why. So - how to fix it?


texts: How to search contacts with certain prefix say, "Dr"?

texts: I want to search contacts with prefix "Dr." and if possible make it as a smart group. How to achieve these?


texts: Themekey Rule to Present Theme on CiviEvent Page

texts:
This is not working for loading my theme on my CiviEvent page of civicrm/event/register?reset=1&id=29

What are the right ThemeKey rules to use?


texts:
Members,
as a relative newbie to Civi, i would like move some entry forms for a new contact (in germany, zip comes before city...) basically it is relevant to adresses now, but there could be more fields. I know i could create a custom profile for that, but could you give me a hint where to look for the code? i cannot find the tpl-file....

System: wordpress 4.9.8, civi 5.6.0

i hope my question is understandable ;-).

Thanks very much in advance,

Walter


texts: Is it planned to use SPIP as a basis CMS for CIVICRM?

texts:
SPIP is a multilingual open-source CMS created in 2001, and a lot of non-profit use it as their website tool in France and other countries. Is it planned, or do you heard about some people willing to use civicrm together with SPIP ?
Many thanks in advance,
Cyril


texts: PxPay Recur Payment gets stuck in pending mode

texts:
CiviCRM 5.3.1 with Omnipay extension 2.5

Added a PaymentExpress PxPay processor. After setting up a recur contribution for a contact the first payment is done successfully without any errors.

The second payment run by the scheduled job ProcessRecurring only records a pending payment for the contact. The job log at civicrm/admin/joblog?jid=18&reset=1 shows only the starting of the execution message. There is no Finished indication of the job so it seems it errored in between and aborted the execution.

There is a success message in the ConfigAndLog file at the same time when the above job was started at 00:41:45-

Aug 10 00:41:46  [info] Contribution record updated successfully

Aug 10 00:41:46  [info] Success: Database updated

But, when I check the log tables, the contribution was never set to completed.

If I execute the job manually the recur payment is completed successfully.
If I manually run the completetransation API from the API explorer, it correctly completes the payment.

So there seems to be no way I can replicate this behaviour from my side. It is just that the automatic cron job fails to give the proper result. Shrug.

No error reporting in the system log table -

  295    payment_notification processor_id=11    {"q":"civicrm/payment/ipn/761/11","result":"00001100039341640bfef9f4cb5d3c06","userid":"****","IDS_request_uri":"/civicrm/payment/ipn/761/11?result=00001100039341640bfef9f4cb5d3c06&userid=****","IDS_user_agent":"***"}

Can anyone point out what is wrong happening here?

UPDATE: There is no system log entry for the recur payment. It seems the return URL is not triggered when the job is executed.


texts: Bootstrap Process not Working with Directory Variables?

texts:
I have an external PHP script that tries to bootstrap Civi. When I use variables for Directories (like [cms.root]), the boostrap process gives me the following error. I have tried this with both "civi_boostrap()" and with the three-line method:
require_once $civi_path . '/civicrm.config.php';
require_once 'CRM/Core/Config.php';
$config = CRM_Core_Config::singleton();

I cannot use the cv method, as I'm also bootstrapping WordPress, and the cv Drupal bootstrap conflicts with the WP functions (timer_start conflicts).
What's the best way to resolve this?
Here is the error:
PHP Fatal error:  Uncaught RuntimeException: Cannot resolve path using "cms.root.path" in /var/www/example.org/sites/all/modules/civicrm/Civi/Core/Paths.php:140
Stack trace:
#0 /var/www/example.org/sites/all/modules/civicrm/Civi/Core/Paths.php(213): Civi\Core\Paths->getVariable('cms.root', 'path')
#1 /var/www/example.org/sites/all/modules/civicrm/CRM/Core/Config/Runtime.php(122): Civi\Core\Paths->getPath('sites/all/civi_...')
#2 /var/www/example.org/sites/all/modules/civicrm/Civi/Core/Container.php(561): CRM_Core_Config_Runtime->includeCustomPath()
#3 /var/www/example.org/sites/all/modules/civicrm/CRM/Core/Config.php(93): Civi\Core\Container::boot(true)


texts: How to set input mask for a custom field

texts:
I want to record an identification number (only integer number) and it should only have 14 digits. I am thinking of something like this:
'--- --- --- -----'

Is it possible and how?
regards,
Guillaume


texts:
In another CRM program I was able to upload several donations at once into the system (from a spreadsheet). Can I do this in CiviCRM? the program would look for matches of names and update those contacts, then would create new records for ones where it could not match a name.

I have over 100 donations in a spreadsheet that I want to upload rather than going to each donor record and uploading all the information.


texts: I cannot find a tab or any import button to import my data I have on excel. I'm not admin, but I have the ability to add cases, organisations and individuals. Do I have to be the admin in order to do this?


texts: Random space characters were added in mailing

texts:
I have sent a newsletter yesterday using a Mosaico template. The final mail had arbitrary space characters, where one of them landed in one of the urls and render that url garbage. The spaces are not in the database, I'm not sure where to check to see when and which component added them...
Base: Drupal 8, Civicrm 5.29.1
I'm pasting the html from a gmail client, as showwed original. It seems the space character is among a newline as well, as this part is actually is a single line. And new line shows how link is dead.

Patlamanın ardından hafızalaştırmaya yönelik ilk çaba, P24’ün “Barış Portreleri” projesiydi. 2019’da ise TMMOB, DİSK, KESK, TTB ve 10 Ekim Derneği tarafından “Emek, Barış ve Demokrasi Anıt Meydanı Anma Yeri Uluslararası Fikir ve Tasarım Projesi Yarışması” düzenlendi. Hafıza Merkezi’nden Banu Tuna, yarışmayı “Zamansız Kabuk/Bitmemiş Hikâyeler” projesiyle kazanan Caps Mimarlık’tan Pınar Kesim Aktaş ile konuştu: “O duygu yoğunluğunu her gün yaşamak istemeyen kişi kendini ister istemez duyarsızlaştırır. Bu durumda tasarladığınız mekân bir boşluğa dönüşür. Ya da duygu yoğunluğuna dayanamayıp oradan geçmekten kaçınır. O zaman da kapalı bir kutu tasarlamış olursunuz. Acının başka bir tarifini bulursak, insanlar rahatsızlık duymadan hafızayı yaşamaya ve yaşatmaya devam edebilir.”


texts: As an admin is there a way to see what other people have been doing on their accounts on the same civicrm database?


texts: Checksum and Shifting Expiration Windows

texts:
Where/when does CiviCRM calculate the expiration date of a checksum?  Is the expiration date encoded in the checksum upon generation, or is the date of checksum creation encoded and then the creation date is compared to the default expiration setting?
This is relevant to the following scenarios:
1)a checksum is created with an expiration default of 30 days.     Contacts are sent a checksum.
2a)The expiration default is altered   from 30 days to 14.  Will the previously created checksum still work between days 15-30?
2b)The expiration default is altered from 30     days to 60.  Will the previously created checksum work between days  31-60?


texts:
I'm trying to hook up Paypal payments using Paypal Pro.

I'm trying to use the sandbox ( although we have a valid Pro account for live payments ) and I keep getting the 'Internal Service Error' this happens when using the form and also the checkout button.

I've validated the endpoints are correct ( if not it returns another error ) but it seems as if it's a problem with the account itself?

Can anybody point me in the right direction with this? Has anybody set this up themselves?


texts: Joomla 3.9.6 - Civicrm 5.12.2 to 5.13.4 failed

texts:
I have just attempted to update to 5.13.4 and at an early stage of process it stalled and now whilst I can still access Joomla backend but the Civicrm has failed. On clicking civi now get this warning -

  CiviCRM-001   @import url(/administrator/components/com_civicrm/civicrm/css/civicrm.css); @import url(/administrator/components/com_civicrm/civicrm/css/crm-i.css); @import url(/administrator/components/com_civicrm/civicrm/bower_components/font-awesome/css/font-awesome.min.css);    Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred. DB Error: no such field Return to home page.    function toggle( element ) { var parent = element.parentNode; var className = parent.className; if ( className == 'crm-accordion-wrapper collapsed crm-fatal-error-details-block') { parent.className = 'crm-accordion-wrapper crm-fatal-error-details-block'; } else { parent.className = 'crm-accordion-wrapper collapsed crm-fatal-error-details-block'; } }


texts: why does a search in contacts using full name in lowercase not find the contact?

texts:
Example: I have a contact Leo Bakx.
The following searches find the contact successfully: leo; bakx; Leo Bakx.
However the search leo bakx (all lower case) results in no match found.
The search %leo bakx% also results in no match found.

We are running version 4.6.1.
Automatic wildcards is enabled.
Individual display name format = {contact.individual_prefix}{
Individual sort name format = {contact.last_name}{, }{contact.first_name}{

We are an organisation with a large turnover in users (mainly young people used to the convenience of throwing anything into google) so inconsistencies are confusing for them and a user-unfriendly work around would not be helpful.

I am a (non-IT) generalist so hopefully there is a simple solution :-). Thanks in advance.


texts: How to send email from CiviCRM and Wordpress

texts:
I am trying to send an email from CiviCRM and Wordpress. The test mailings work, but the scheduled mailings never go beyond being scheduled. I done some research online and I think I have to setup a cron job...I'm not exactly sure.

Can someone please show me how to configure the settings, or direct me to a link that will help me in this matter.

Thanks in advance.


texts: How can I import ADDED BY field of Activities?

texts:
I have data in spreadsheet. How can I import Activities with respective Added by values (specified in spreadsheet)?

Can't find this field in CiviCRM Activities import tool.


texts: Inserting custom field to core field group

texts:
https://civicrm.org/blogs/lobo/extending-contact-demographic-information-custom-group shows some hints how I can add custom fields to the core demographics, but that was for civicrm 3.1. I gave it a try anyhow, but got stuck with

$whatever &= CRM_Core_BAO_CustomGroup::getTree('Contact', $form, $form->getVar('id'), CIVICRM_CANVASS_DEMOGRAPHICS_ID, null, null );

Do the hints still apply to 4.6+ ? How would you do it today?

$form->getVar('id') returns nothing. What id are we talking about here? Could it be that it returns only something in edit forms? and I don't quite understand what the constant CIVICRM_CANVASS_DEMOGRAPHICS_ID is.


texts: Why are cv php:boot calls failing only when running unit tests and not through direct CLI calls?

texts:
Starting with a new machine, and a new buildkit instance! Buildkit/bin's contents added to PATH successfully.
When I run cv php:boot --level classloader on the command line, I get:
/*BEGINPHP*/
require_once  '/var/www/project/sites/all/modules/civicrm' . "/CRM/Core/ClassLoader.php";\CRM_Core_ClassLoader::singleton()->register();
/*ENDPHP*/

But when phpunit tests are through the command line (with any of phpunit5, phpunit6, or phpunit7), the cv command line fails, returning "".
In the test directory's phpunit bootstrap file, replacing $result with what's output above works until the next time cv is called in the process, whereupon it also breaks.
I have set the execute permission on ~/buildkit/bin/cv to be globally executable. But it's the same user running it that cloned the buildkit repo.
Any ideas?


texts: Change or turn off the auto renew cancellation system email

texts:
I've probably gone round the circle so many times I've missed it's obvious start! However, I can't find the origin of the system email that goes to people when they or the system cancels their auto-renew membership.

It contains the text, "Your auto renew membership sign-up has ended and your membership will not be automatically renewed."

As far as I can see, this is not the System message, 'Memberships - Auto-renew Cancellation Notification', which in our system has a very different text (when viewing the default message as well as our modified message.)

So... where should I look to find this text?

Sorry if this is a totally obvious answer that I've missed... :-)


texts: API permission check failed: CiviEvents Fails after update to 4.7.19 and 4.7.20

texts: After updating to 4.7.20, when the Event Info Page is accessed, it generates the following error, "API permission check failed for Event/get call; insufficient permission: require access CiviCRM and access CiviEvent and view event info". If I roll the system back to 4.7.18 it works. Any suggestions on a fix or work-around are much appreciated.


texts: API get of multiple contact_sub_type returns no results

texts:
I have this problem on the Joomla demo site (4.6.0) and my own sites with versions 4.6.8 and 4.7.1.

If I use the API explorer or run test php code, with a query checking for multiple contact_sub_type, I get 0 results:

$result = civicrm_api3('Contact', 'get', array(
  'sequential' => 1,
  'return' => "contact_sub_type",
  'contact_sub_type' => array('IN' => array("Student", "Parent")),
));

But if I search using the = operator for one contact_sub_type at a time, it returns the expected results:

$result = civicrm_api3('Contact', 'get', array(
  'sequential' => 1,
  'return' => "contact_sub_type",
  'contact_sub_type' => "Parent",
));

{"is_error":0,"version":3,"count":1,"id":7,"values":[{"contact_id":"7","contact_sub_type":["Parent"],"contact_is_deleted":"0","id":"7"}]}

This happens with subtypes of both Organization and Individual types.

I could work around it by performing multiple api calls and merging the results, but this seems like a bug?


texts: Why is Joomla demo site showing it is using 4.6.0?

texts: Following up on this question I checked and confirm that the joomla demo site shows it is on 4.6.0 and has 'security releases' available


texts: Contribution/membership receipt - unable to disable

texts:
I did have a look around already but thus far without much luck.
We recently turned off the 'Email Receipt to Contributor?' option on a membership join page. I did check the ContributionPage settings and they show that the 'is_email_receipt' is off:
"values": [
    {
        "id": "5",
        "title": "Join xxx",
        "is_email_receipt": "0"

However new members joining are added as
 "contact_id": "14971",
    "currency": "EUR",
    "contribution_recur_id": "4696",
    "receive_date": "2020-07-06 00:51:41",
    "contribution_source": "Join xxx"

  "id": "4696",
        "contact_id": "14971",
        "amount": "10.00",
        "currency": "EUR",
        "frequency_unit": "year",
        "frequency_interval": "1",
        "start_date": "2020-07-06 00:51:38",
        "is_email_receipt": "1",**
        "contribution_type_id": "2",

Now I appreciate that for contacts that joined before switching off the receipts I would have to update the 'civicrm_contribution_recur' table to stop those but I cannot find a reason why new contacts are still being added with the  "is_email_receipt": "1"
We use Stripe as the payment processor and the 'Allow Stripe to send a receipt for one-off payments?' for settings is disabled.
We are also using the nz.co.fuzion.transactional extension so I can see the receipt that goes out on the contact record (the Civi one).
Can anyone shed some light for me?
Civi 5.24.4/Drupal 7
Thank you!


texts: How can I allow donor to edit the amount to pay towards his Invoice

texts:
I am sending the donor a link to his dashboard where he can click Pay here to pay an outstanding invoice.
The issue is that once he clicks 'Pay Now' he is forced to pay the total amount of the invoice (Or pending contribution) and cannot edit the amount and make a smaller payment towards his balance due.
Is there a way to allow the donor to edit the amount?
Also why are the the words (includes of $0.00) after the amount?


texts: HowTo fix: client denied by server configuration?

texts:
looking in my Apache error logs I get a lot of these errors:

17:52:59    client denied by server configuration: /path/to/drupal/sites/default/files/civicrm/custom/delete-this-hLW0uQKV0o    error
17:52:59    client denied by server configuration: /path/to/drupal/sites/default/files/civicrm/upload/delete-this-2oysK1uZ8L    error
17:52:58    client denied by server configuration: /path/to/drupal/sites/default/files/civicrm/ConfigAndLog/CiviCRM.3de7c305138430bacabc11877313657f.log    error

The directory permissions for sites/default/files/civicrm and all its subdirectories are 775

drwxrwxr-x  45 web  www   140B 19 Mai 10:45 ..
drwxrwxr-x   2 web  www   369B 19 Mai 09:29 custom
drwxrwxr-x   2 web  www     4B 19 Mai 09:29 upload
drwxrwxr-x   2 web  www    10B  1 Mai 05:15 ConfigAndLog
drwxrwxr-x   3 web  www     4B  3 Dez 23:26 persist
drwxrwxr-x   4 web  www     4B  3 Dez 23:22 templates_c
drwxrwxr-x   7 web  www     7B  3 Dez 23:22 .

and are owned by the apache user

uid=1001(web) gid=1000(www) groups=1000(www)

so in principle even 755 should be enough.

I don't think it is related to any apache setting (using 2.4), since my folder with drupal inside is inside a directory which already has a Require all granted directive, and my other web projects (and drupal itself) do not throw such kind of errors.

Understanding this post right it is kind of "normal" that the "delete-this" files through an error?
Even if, why this also happens for the log file? Looking into the folder ConfigAndLog I have observed that each month a new file is created. But each month I have to chmod the newly created file in order that the apache user can write into it.

How can I fix this?


texts:
On my acceptance environment the Civicrm-log is not created. When I use Log Viewer, it cannot find it obviously. But the error message describes a specific file:

Unable to read entries from logfile at
/home/xxx/domains/xxx/private_html/sites/default/files/civicrm/ConfigAndLog/CiviCRM.3e4f19629d0809162da910db.log

I have checked file permissions and they seem to be okay. So the file can be created.
Two questions:

How can I solve the problem that the log file is not created?
How does log viewer know the (non-existent) log file?


texts: CiviCRM 4.6.8 compatible with Wordpress 4.3?

texts:
CiviCRM 4.6.8
Wordpress 4.3
MySQL Apache/2.2.22 (Debian)
Datenbank-Client Version: libmysql - 5.5.44

I've imported contacts, added new contacts, without any problem.

Then I've added a rule for individuals in "Find and merge duplicate contacts". and added following rule:
"Firstname Lastname";
"supervised";
"field=LastName"
"field=First Name". Saved and used the rule.

The message i've got was: "DB Error: syntax error"

Now I'm not able to add a new contact...

I've already tested this in the public demo and it didn't show an error-message.

Can someone help?

Here are the Error Details:

Sep 10 18:22:10  [info] $Fatal Error Details = Array (
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

[code] => -2
[message] => DB Error: syntax error
[mode] => 16
[debug_info] => INSERT INTO dedupe (id1, id2, weight) SELECT 0 id1, 0 id2, 0 weight LIMIT 0 GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight)' at line 1]
[type] => DB_Error
[user_info] => INSERT INTO dedupe (id1, id2, weight) SELECT 0 id1, 0 id2, 0 weight LIMIT 0 GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight)' at line 1]
[to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO dedupe (id1, id2, weight) SELECT 0 id1, 0 id2, 0 weight LIMIT 0 GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight)' at line 1]"]

)


texts: Disabling Stripe extension breaks database

texts:
After clicking "disable" on the Stripe extension, visiting civi gave me an error 500 and does not make an entry in the error log. But going to Drupal home kicks out the following error message:

Warning: require_once(CRM/Core/Payment/Stripe.php): failed to open stream: No such file or directory in Civi\Payment\System::getByProcessor() (line 59 of /home/ourbase/public_html/prbrc/sites/all/modules/civicrm/Civi/Payment/System.php).

The file it's looking for does exist, BTW.

I've fixed this before (see answer), but I just want to uninstall the extension -- it never for us worked anyway.


texts: 'Are you sure you want to leave this site' popup message issue on event and contribution forms

texts:
We have an issue where whenever a user tries to move to the confirmation page of an event registration (or contribution) page they are getting the browser message 'Are you sure you want to leave this site' popup.

See https://portal.communityfirstyorkshire.org.uk/civicrm/event/register?id=80&reset=1. Try to complete the form and continue.

Has anyone else seen this issue. There is no custom code on this system which would affect this functionality.


texts: Recently upgraded to CiviCRM 5.35.1. (Wordpress 5.7.1) Send Mail is no longer available in Action dropdown

texts: When I attempt to send an email to a small group of individuals using Send Mail. I can not find that option in any of the usual action drown offerings after searching contacts or members. I looked in the various admin areas to see if I had to turn that feature on but could not find a switch.


texts: Is a Scheduled Reminder possible when something doesn't happen?

texts: A client has asked that an email or SMS reminder be sent if a user fails to submit a weekly report.  The weekly report would be created as an activity - for example, by noon every Friday.  I can't quite see how this can be done, but others may have more imagination then me!  So, is this possible?  Perhaps using a combination of CiviRules and Scheduled Reminders?


texts: Enforcing the uniqueness of fields/entities (e.g. phone numbers)

texts:
I'd like to ensure that phone numbers of a certain type (let's say Mobile) are unique across our Civi instance. A given contact should be able to have no more than one Mobile number, and no two contacts should have the same Mobile number. We'd still like to take advantage of Civi's existing infrastructure around phone numbers -- in other words, we don't want to use a custom field instead of the phone number entity.
Ideally, the uniqueness rules would be enforced when data comes into Civi. But there are many ways that data comes in: backend forms, contribution pages, event registration forms, import, api, etc. If we wanted to alert users about duplicates during the various GUI-driven workflows, and also handle situations where a user isn't directly controlling the process (e.g. automatic syncs using the api), we'd need to create several different mechanisms.
Has anyone tried to do this, particularly with something like phone numbers which have a many-to-one relationship with contacts? (A question from 2015, Enforce uniqueness of custom field, is related, but I'm asking a broader question. Civi and its ecosystem of extensions have also evolved in the last 5+ years.) Are there best practices for enforcing uniqueness of a field/entity in CiviCRM, in a way that gives users a chance to correct duplicates during data input whenever possible?


texts: How to clear the caches in WP / Wordpress or Drupal via url?

texts: How does one clear the caches in Civicrm via a URL?


texts:
I am wondering what the difference between deleting and disabling an activity is? I would like to clean up the activity field options drop down menu to only reflect the ones we would like to continue using without deleting or affecting any of the historical activities associated with the ones we are planning to delete.

Thanks for your help.


texts: Anonymous user can't view CiviCRM user dashboard in WordPress

texts:
I have a wordpress page with a user-dashboard shortcode embedded in it ([civicrm component="user-dashboard" hijack="0"]). When logged in, it works fine. When using a private window (and a user id and checksum) I get told I must be logged in to view the page.

I assumed that I had forgotten to set the permission for anonymous users and the user-dashboard, but it seems I have that set correctly:

I assume I'm missing something else obvious, but web searches (including this database) have revealed nothing. I would love an answer or even a suggestion of where to look.

Based on the suggestion below, I've added some debug code to the user-dashboard:

  public function __construct() {
parent::__construct();
echo "<!-- " . CRM_Core_Permission::check('access Contact Dashboard') . " -->\n";
if (!CRM_Core_Permission::check('access Contact Dashboard')) {
  CRM_Utils_System::redirect(CRM_Utils_System::url('civicrm/dashboard', 'reset=1'));
}

$this->_contactId = CRM_Utils_Request::retrieve('id', 'Positive', $this);
$userID = CRM_Core_Session::singleton()->getLoggedInContactID();

echo "<!-- userID:" . $userID . " -->\n";
$userChecksum = $this->getUserChecksum();
echo "<!-- userChecksum:" . $userChecksum . " -->\n";

I was somewhat surprised to see that the checksum and cid aren't making it there:

<!-- 1 -->
<!-- userID: -->
<!-- userChecksum: -->
<div id="crm-container" class="crm-container" lang="en" xml:lang="en">

Now, this is a Wordpress page, not a civiCRM page, but I assumed that since there is a shortcode to add the user-dashboard, that these values would come through as well. Am I deluded in thinking this?

For completeness, here is the (slightly redacted) url: https://mywebsite.com/workshop-registration/?aca11184e16a867aeee5f317ab706f58_1570552008_1440&cid=2

I also tried this one just in case: https://mywebsite.com/workshop-registration/?cs=aca11184e16a867aeee5f317ab706f58_1570552008_1440&cid=2


texts: What does undefined extension class 'Smarty_Internal_Method_Assign_By_Ref' Mean?

texts:
The new installation of CIVI works. LAMP server, shared hosting, PHP 7.2, Joomla! 3.9, etc.
When I click to go to configuration checklist, I get the error:
undefined extension class 'Smarty_Internal_Method_Assign_By_Ref'

Same when trying to run the component.

Can't find an answer to this on Stack Exchange or general search.

Appreciate any suggestions.

John


texts: Has select always included the label on drop down lists?

texts:
Maybe I am just noticing things now but has select always included the label on drop down lists? I thought it used to say -none- when none was selected.
Example from dmaster demo


texts: How to add relationship at the time of new user creation in drupal?

texts: I want to add relationship (civicrm) at the time of creation of new user using drupal user. (individual -> Household).


texts: Help needed in setting up rest api in CIVI CRM

texts:
I tried below steps but I am getting an error in calling rest API via the browser.

I checked which user is an administrator and added api key via phpmyadmin interface.
Get the site key from CiviCRM settings.
I cross checked that user have permissions for editing and view contacts.
I want to get operation for contacts based on some condition.

Please have a look at error that I am getting.

Setting file is present in same folder
public_html/crm/sites/default

Please help me.It's the little bit urgent.
I am very thankful to you.

With Regards,

Mohit Thareja


texts: Issue with custom report that shows all users registered for event in last 2 years but not this year

texts:
I am using Drupal 7 and CiviCRM 4.6.28.

I am trying to create a report that will display all of the users who registered for an event in 2015 and 2016, but not yet in 2017.  I have the report working to the point of displaying all who registered in 2015, 16, and 17.  I am not sure how to go about removing those who have not registered in 2017.  The idea I've been trying is to create an array of contact_ids that are registered in 2017, and then use that array in the WHERE clause, to only select rows that do not contain that contact_id.  It is still displaying users who have registered in 2017, though.

I am running this query in the where() function in the report php file.

Here are the contents of the where() function:

$sql = "SELECT {$this->_aliases['civicrm_participant']}.contact_id,
{$this->_aliases['civicrm_participant']}.register_date
FROM civicrm_participant {$this->_aliases['civicrm_participant']}";

$dao = CRM_Core_DAO::executeQuery($sql);
$i = 0;
$registered = array();

while($dao->fetch()) {
    if (strpos($dao->civicrm_participant_register_date, '2017') !== false )
    {
        $registered[$i] = $dao->civicrm_participant_contact_id;
        $i++;
    }
 }

$this->_where = "WHERE ({$this->_aliases['civicrm_event']}.title = 'SF Open
Studios 2017'
OR {$this->_aliases['civicrm_event']}.title = 'SF Open Studios 2016'
OR {$this->_aliases['civicrm_event']}.title = 'SF Open Studios 2015')
AND {$this->_aliases['civicrm_participant']}.contact_id
NOT IN ( '" . implode($registered, "', '") . "' )";
}


texts: Does anyone have experience with migrating a MS Dynamics database to CiviCRM

texts: We are in touch with an organization that is planning a move to CiviCRM. They currently use Microsoft Dynamics and they will want to migrate the data into CiviCRM (I suspect 4.6). Anyone done that before, hints, pitfalls, approaches, experiences they would like to share?


texts: What is the root url needed for extension pages?

texts:
I've installed the API CSV import GUI extension extension which directs you to  "go to the url civicrm/csvimporter/import" to go to the import page, but when I go to Mysite.com/civicrm/csvimporter/import I get an empty page.

I'm having a similar error with Civivisualize which directs you to go to "yoursite.org/civicrm/dataviz". In both cases I'm getting the a blank page.

What am I missing here?

=====

I'm on CiviCRM 4.5.5 and Wordpress 4.1.1


texts: How can I change the fields displayed by dataTables?

texts:
I want to customize the information provided by templates that are generated via the dataTable plugin. Specifically, I want to alter the RelationshipSelector.tpl to display a contact's title and a couple of custom fields.

The dataTable script in the RelationshipSelector table makes a call to civicrm/ajax/contactrelationships via AJAX. It returns JSON. I noticed that the dataTable plugin elsewhere makes calls to civicrm/ajax/*.

Is there a way I can alter the JSON that is returned to include my fields?

I'm running a Drupal + Civi 4.6


texts:
I'm trying to figure out how to do automated workflows.
This is an example of one such process:

Member fills in a request to host an event using Caldera Forms (at the moment).  I currently have some custom code that creates the event in CiviCRM for me, using the API, upon submission.
Reviewers must approve the event request
Once approved, an email needs to be sent to the event host with specific event information
We then wait for the event host to send us a document with the announcement
Reviewers must approve the announcement
An announcement is then bulk emailed to all members
Opens to the general public 3 days after the given date of opening to members

I've looked at CiviCase, which would be great to manage each of these events but is there a way to trigger the activities above from a Case?  I need to be able to pull information from the event record for various parts of this (steps 3 and 6, for example).
I currently do this manually - I send the email by manually updating the email before sending.
We get so many requests that I sometimes lose track of where I am with each of these events.  If I also have to manually update CiviCase, that adds to the workload and kind of defeats the purpose of streamlining this process.
Thoughts?  Suggestions?  I can write scripts to call the API if need be, if that is the only way but seems that it would be part of the app?
Thanks
Norm


texts: CiviMail stuck on 'estimating' number of recipients

texts:
Drupal 7.69, CiviCRM 5.26.1

Hi everyone,

I had a similar issue (but seem to have identified something different) a few months ago.

Trying to send a mailing to a group, 'Donors'. This group is not a smart group, but it has child groups which are smart groups. I've sent emails to this group many times before. When I select the group, it says no recipients:

I then click save draft and re-enter the mailing, and it's stuck on 'Estimating'.

This is what I see when I click on the wrench:

This seems to happen for some groups but not others. I've emailed all these groups in the past.

Flushing the cache did not work. Any ideas on how I can fix this? I really don't want to have to rebuild all the groups all over again, this one in particular has a lot of different sub-groups within it.

Cheers


texts: Create Drupal user for contact joining as Organisation

texts:
Running Drupal 7.43 and civicrm 4.7.12.

We sell memberships to individuals and organisations.

The creation of an Individual works fine. The contact is created and the Drupal account created.

When signing up as an organisation with a name/address/email/create drupal profile, I get the error:

DB Error: already exists.

And the fatal error in Drupal logs:

$Fatal Error Details = Array ( [callback] => Array ( [0] =>
CRM_Core_Error [1] => handle ) [code] => -5 [message] => DB Error:
already exists [mode] => 16 [debug_info] =>
   INSERT INTO civicrm_uf_match (domain_id, uf_id , uf_name , contact_id)
   VALUES ( 1 , 1229 , 'user@ns9.com' , 2603 )
[nativecode=1062 ** Duplicate entry 'user@ns9.com-1' for key
'UI_uf_name_domain_id'] [type] => DB_Error [user_info] => INSERT INTO
civicrm_uf_match (domain_id , uf_id , uf_name , contact_id ) VALUES ( 1 ,
1229 , 'user@ns9.com' , 2603 ) [nativecode=1062 ** Duplicate entry
'user@ns9.com-1' for key 'UI_uf_name_domain_id'] [to_string] =>
db_error:
message="DB Error: already exists" code=-5 mode=callback
callback=CRM_Core_Error::handle prefix="" info="INSERT INTO
civicrm_uf_match (domain_id , uf_id , uf_name , contact_id ) VALUES ( 1 ,
1229 , 'user@ns9.com' , 2603 ) [nativecode=1062 ** Duplicate entry
'user@ns9.com-1' for key 'UI_uf_name_domain_id']"] )

Weird thing is that it seems to work fine.

Organisation is created and given membership.
Individual is created with relationship to organisation
Drupal account is created for Individual

But they are just given the error and not logged in.

I can get them to manually create an account after creating membership and link it to their civicrm contact, but it seems like an unneeded extra step for users.

Maybe I need to use civicrm_entity and trigger a rule?
Thanks


texts: Unable to CANCEL or DELETE a Scheduled Mailing (Mosaico is installed)

texts:
With either a Send Now or Scheduled mailing (Mosaico created) I unable to Cancel or Delete the Mailing in the Find Mailings page.

Using WordPress 4.9.4, CiviCRM 4.7.30 and the following related extensions:
Angular Profiles (org.civicrm.angularprofiles) version 4.7.31-1.1.0
FlexMailer (org.civicrm.flexmailer) version 0.2-alpha5
CiviCRM Bootstrap theme (org.civicrm.shoreditch) version 0.1-alpha16
Mosaico (uk.co.vedaconsulting.mosaico) version 2.0-beta3.1512698300

When I click Cancel for the Scheduled mailing on the Find Mailings page, I received the following dialog:

And then the following dialog:

Then it returns me to the Find Mailings page with no change to the mailing.  I've tried to refresh the screen also to see if there was a delay.

April 4/22/2018 Update:

Providing the following additional information to this problem as it might be related.  I am also unable to delete a mailing using the DELETE action on the Draft / Unscheduled Mailings listing.  I AM able to delete the mailing if I click CONTINUE from the listing page and then select DELETE DRAFT when viewing the individual mailing.  The link that the DELETE action is posting when on the listing page is:

http://myorganization.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/mailing/browse&action=delete&mid=16&reset=1&confirmed=1

and the page says that the Link has expired:


texts: CiviCRM MailChimp Integration - sync with MailChimp fails

texts:
hope you're well. New user of the MailChimp integration extension available here:
https://civicrm.org/extensions/mailchimp-civicrm-integration
We are attempting to integrate CiviCRM 5.29.0 on Wordpress and MailChimp, but we get this error when we perform the test sync (see image). As you can see (despite blurring out the info) it is able to pull MailChimp information but errors out with the 2nd error below it.

I found this page here that suggested the problem might be a lack of a Anonymous User user with webhook permissions in CiviCRM but couldn't find anything about explicitly adding webhook permissions to a role. Struggled to find in this page what exactly I need to permit in order to grant the right permissions.
How to make the callback URL from Mailchimp accessible from anonymous users in Wordpress?
Could someone point me in the right direction for a guide on how to set up CiviCRM 5.29.0 for this MailChimp integration?
Thanks everyone :)


texts:
I have been investigating running WordPress with CiviCRM on a managed cloud server at 1and1.com. It is a LAMP stack, but I have been told that they don't support cron.

This a deal-breaker, true?

CiviCRM needs cron for scheduled tasks, reminders, etc, yes?


texts: Civicontribution 'Failed to update contribution in database'

texts:
Someone makes an online contribution, the payment goes through, but an error pops up on the screen saying 'Failed to update contribution in database'. If I look at contributions, the status for the contribution is 'Pending (Incomplete transaction)'. The error occurs from a call to completeTransaction() in Confirm.php.

I turned on debugging and got a traceback, but it doesn't tell me any more than I have typed here. How can I find out why the update to the database is failing?


texts: Scheduled Reminders for membership not being sent

texts:
We've looked on various threads on this topic without success. We have a contact who's membership schedule reminders are not being sent, and we can't see why.

The membership is Active, auto-renewed monthly.
no status override, (it did have an over-ridden end date, so we renewed the membership for several periods so it has an automatically generated end date well into the future)
There are no records for this schedule reminder in civicrm_action_log

After checking the above we've also performed the Scheduled Job of Send Schedule Reminders and this didn't send the Schedule Reminder emails.

Particularly, we saw this: https://lab.civicrm.org/dev/core/issues/285. This suggests that the Membership Scheduled reminders won't go out if there is a status override or existing (annual) similar reminders. But we can't see that this is the case.

As far as we can see (from limited numbers of people on this membership), others are successfully receiving similar Schedule Reminder emails.

Any other ideas? Thanks for your help.

Civi 5.24.4, Drupal 7.69


texts:
After upgrading to CiviDiscount 3.4 and CiviCRM 5.3.1 (on Joomla 3.8.10), autodiscounts for events (based on membership status) work very arbitrarily. E.g. the $20 discount works great, the $35 discount doesn't - config for both is set up exactly the same (except which price options are selected for each, of course). See the screenshot below.

Anyone having autodiscount issues, as well? Can't pin down the root cause so haven't posted on Github yet.

This worked fine on CiviDiscount 3.3 and CiviCRM 5.1.2

Thanks for any ideas


texts: How to add an activity for the contacts generated via a report?

texts: I have a list of contacts from a contribution report, and I would like to add an activity based on the latest result from the report. My first thought was to have a "action link" to update the activity, but don't see it there.  Is there any other way to achieve that? Thanks


texts: Where is the link between a CiviCRM contact and Wordpress user stored in the database?

texts:
I am migrating my CiviCRM database to a new server with a fresh install of Wordpress and CiviCRM. I would like to know where in the database the link between CiviCRM contacts and Wordpress Users are, so if needs be I can manually correct them (there are not many contacts linked to users in my database).
Maybe Civi will correct the link between users and contacts if I were to use the 'Synchronize Users to Contacts' feature again in the new system, does anyone have experience of this?
Regardless I would be interested to know about where this link is stored to improve my familiarity with how Civi works. I looked in the civi_contact table but could not see any field there that might store the linked user id from Wordpress.


texts: Create contact by external form fails (using contact form in wordpress with plugins, civi runs on drupal)

texts:
I've followed this blog post to create a setup for my visitors to subscribe from a wordpress website to a newsletter in CiviCRM. CiviCRM setup is working (I have tested via API Explorer, it works as expected). I have installed Contact Form 7 and it's civicrm supporting plugins to a Wordpress (as described in the post).

I've set the plugin with keys (API and Site) that I've tested. I created a form, filled it and it sent a request to my site and returned a 403 error:
"POST /civicrm/sites/all/modules/civicrm/extern/rest.php?json=1&entity=FormProcessor&action=create_subscriber HTTP/1.1" 403

The keys are working but I can't check if they're sent correctly. To see what is being sent in the POST request, I've looked to my browser console, but there was no POST request to my civi installation.

I ran out of ideas to check. What can I be missing?


texts: View records by date added - not activity date/date received

texts: Adding a bunch of contribution records with a variety of dates manually - I would like to see all the records I added today - what would be an easy way to do that? Last modified would be fine too.


texts: After creating/saving an activity, re-opening it to edit won't allow links and drop-downs to be changed

texts:
We're using 5.4.1 on Wordpress 4.9.8 with php 5.6.34.

The following issue seems to have started with 5.3.x and we still cannot solve it.

When we create an activity, we include:

a hyperlink in the details
a status using the dropdown box

All works as it should when we create an activity. However, when we choose to edit it (wrong hyperlink, change the status, etc.), we are unable to do so.

The hyperlink properties box does not come up when clicked
The dropdown box will not come up when status is clicked

In both cases the anticipated pop-up windows show up behind the active window, but -- in addition to being the wrong behavior -- they still don't work.

My work-around is to edit in HTML (vs WYSIWYG) and changing statuses via searches and applying changes by profile. But this is time-consuming and not all of our team can easily do it. And it's not how Civi is supposed to work.

We're using Chrome/Windows. I thought we solved it by clearing Chrome's cache (but the result is sporadic at best). We've also tried Firefox with same issue.

Does anyone know what's going on here?

Thanks!

P.S. The correct functionality does appear to be present in 5.6.alpha1 in the demo sandbox. Can anyone verify if this is a known bug? If not, I'm concerned the issue may be our database rather than Civi.

Here are screen shots showing correct behavior with creating activities. Note that the dropdown box for assigning status and hyperlink box for providing link details pop up in foreground and can be completed and saved:

Here are screenshots of the incorrect behavior after saving this activity and attempting to edit it. Note the dropdown and hyperlink dialog occur behind the activity screen (I've move the Activity screen to reveal them). Even after revealing them, they do not function.

[


texts: Create a Group using a CSV of existing contacts with an ID

texts:
Sorry for the potentially elementary question here, bur I have seen this done by a former coworker. I can't for the life of me remember how to use a CSV or comma delimited string of CiviCRM IDs to create a new mailing group through the CiviCRM user interface. I have a list of existing contacts from our database that has been filtered inside Excel and now I need to create a new group off the remaining contact IDs.

Can anyone remind me how to take the CSV list to create the search and then generate the new group? Or do I have to run the list through the "Import Contacts" process and add them to a group that way?

Thank you in advance.


texts: How can I allow an anonymous user to generate an email to themself?

texts:
I am using CiviCRM with WordPress.  I have just learned how to use "contact.checksum" to send an email to a user to safely let them edit their own personal info.  I can do that when they sign up for membership, or other events.  It's great!

I would like to have on my web site a link or button that allows users to fill in an email address and generate an email to that address (with the checksum link).  In other words, "click here to view and edit your data".

Ideally it would then confirm that the email was sent, but mostly I just want "send the checksum email to me please".  I have the message template ready, but how to I let the user trigger it?


texts: Email-to-activity processing - Error message: Process Activities failed

texts:
Have installed CiviCRM 4.6.4 on Drupal 7.38 and have explored the various modules to identify how it can be used to help a small UK charity.

I am having issues with email-to-activity.
I set it up to hook into an IMAP account via SSL and read a specific folder. This worked perfectly for a few tester emails, so then expanded my testing.
When it got an email from a particular account the job started failing with:
Error message: Process Activities failed

When this email was removed from the specified folder, it did not fix the issue. Changing folders (and email accounts) worked until the job hits an email that it cannot process and then never works again in that folder.

All my searching has only found two potential solutions.
1 - the password is wrong. This has been dismissed as it works fine until it hits certain emails.
2 - make bounce processing and E2A from the same account - have seen this as a "solution" as well as a recommendation NOT to do this. Either way, it made no difference.
I tried looking at the email headers to see if anything jumped out, but didn't seem to be encoding.

I am new to CiviCRM and linux hosting, so while happy to look at detailed logging I may not know how to access/interpret.

Any help or guidance would be appreciated, I can supply a sample email (either sent to an email to be picked up or a .eml attachment) if useful

Many thanks

Dave

Debug & traceback:
Jul 20 18:15:02  [info] $Fatal Error Details = Array
(
    [message] => Could not connect to MailStore for XXX@YYY.com@secure.emailsrvr.com

Error message:

An error occured while sending or receiving mail. The IMAP server could not create mailbox 'CRM2.CiviMail.ignored': A0006 NO [ALREADYEXISTS] Mailbox already exists.

    [code] =>
)

Jul 20 18:15:02  [info] $backTrace = #0 sites/all/modules/civicrm/CRM/Core/Error.php(322): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 sites/all/modules/civicrm/CRM/Utils/Mail/EmailProcessor.php(184): CRM_Core_Error::fatal("Could not connect to MailStore for XXX@YYYY.com@secure.emailsrvr.com<...")
#2 sites/all/modules/civicrm/CRM/Utils/Mail/EmailProcessor.php(111): CRM_Utils_Mail_EmailProcessor::_process(FALSE, Object(CRM_Core_DAO_MailSettings))
#3 sites/all/modules/civicrm/api/v3/Job.php(379): CRM_Utils_Mail_EmailProcessor::processActivities()
#4 sites/all/modules/civicrm/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_job_fetch_activities((Array:1))
#5 sites/all/modules/civicrm/Civi/API/Kernel.php(96): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9))
#6 sites/all/modules/civicrm/api/api.php(23): Civi\API\Kernel->run("Job", "fetch_activities", (Array:1), NULL)
#7 sites/all/modules/civicrm/CRM/Core/JobManager.php(131): civicrm_api("Job", "fetch_activities", (Array:1))
#8 sites/all/modules/civicrm/CRM/Core/JobManager.php(83): CRM_Core_JobManager->executeJob(Object(CRM_Core_ScheduledJob))
#9 sites/all/modules/civicrm/bin/cron.php(42): CRM_Core_JobManager->execute()
#10 {main}


texts: Stripe processor: payment going through but registration is not! "Could not find valid value for id"

texts:
I'm on Joomla 3.19.13 with CiviCRM 5.18.2 and using the Stripe Payment Processor 6.2.2.

This seems to be a problem popping up on Wordpress sites (https://civicrm.stackexchange.com/search?q=Could+not+find+valid+value+for+id) but I'm on a Joomla system.  My problem seems most similar to this one -- but in my case the registration DOES NOT come through, but the credit card payment DOES go through the Stripe processor, without email, address, name, etc. Nightmare!

Even worse, this seems to be an intermittent problem.  We've just opened this event registration a few days ago, and so far we have 20 successful registrations with payments processed as they should be. But 1 payment has gone through successfully without any registration data or identifying data in Stripe, and 6 or 7 of these "unknown" Stripe payments appear to be stuck in the "Uncaptured" stage in the Stripe system.

I've found multiple instances in the CiviCRM logs like this:

Nov 30 23:13:41  [error] $Fatal Error Details = Array
(
    [message] => Could not find valid value for id
    [code] =>
)

Tail end of backtrace like this:

Nov 30 23:13:41  [debug] $backTrace = #0 /home/fawcoho/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(385): CRM_Core_Error::backtrace("backTrace", TRUE)
-1 /home/fawcoho/public_html/administrator/components/com_civicrm/civicrm/CRM/Utils/Request.php(121): CRM_Core_Error::fatal("Could not find valid value for id")
-2 /home/fawcoho/public_html/administrator/components/com_civicrm/civicrm/CRM/Event/StateMachine/Registration.php(52): CRM_Utils_Request::retrieve("id", "Positive", Object(CRM_Event_Controller_Registration), TRUE)

Any troubleshooting ideas welcome -- Stripe has already confirmed that for these incorrect payments they are receiving the credit card info (number, expiry, CVC) but not any other identifying information.


texts: Is there a way to see the results of Scheduled Reminders?

texts:
A report? A log? I'd like to verify what it's doing in there...

Question answered: Activities Report can be filtered to "scheduled reminders" and show the results of automatic emails.


texts: Drupal 8: How do I shift a project/site from using the roundearth installation method to the CiviCRM official composer asset plugin

texts:
From an existing site set up using the roundearth composer plugin method as detailed -> https://www.mydropwizard.com/blog/better-way-install-civicrm-drupal-8
composer create-project roundearth/drupal-civicrm-project:8.x-dev some-dir --no-interaction
How do I update this to use the newer https://lab.civicrm.org/dev/drupal/snippets/43composer require civicrm/civicrm-asset-plugin:'~1.0.0' pear/pear_exception:'1.0.1 as 1.0.0' civicrm/civicrm-{core,packages,drupal-8}:'^5.25' --prefer-source


texts:
I am using Wordpress 4.4.2 and recently upgraded Civicrm to 4.7.3

When I try to "manage" a case, that is, access the record itself, I get this message:

Sorry but we are not able to provide this at the moment.
Unable to load configuration file for the referenced case type: 'My Case Type' (learn more...).


texts: The wording of the GDPR texts is translated (into Dutch), but the title still says "Terms and Conditions". Where to find the string to translate? Or how can it be translated? Please include a translation in next releases. It's odd on an event registration in local language to speak about "Terms and Conditions"!


texts:
Sending reports by email is a really nice feature in CiviCRM. This is done by creating a specific cron job for each report.

However, this will be sent only at the intervals given. And they are "daily", "hourly" or "every time cron job is run". I would love to send some reports on a weekly basis, or even monthly basis. Suggestions on the forum is to set the cron to run only once a week, but I need to run the cron every minute.

Is there any way to send, by email, specific reports automatically on a weekly basis?


texts: How to I track down this problem when I try to CIVIMail? Sorry an error occurred and your information was not saved

texts:
While in CiviMail I keep getting this message

"Sorry an error occurred and your information was not saved."


texts: Need a list of past event participants and several years are gray, can't access them

texts:
when i search for events they all show up, but some of them are grayed out and I can't access any information:  I get this error--

An error has occurred.
0   @import url(/administrator/components/com_civicrm/civicrm/css/civicrm.css); @import url(/administrator/components/com_civicrm/civicrm/css/crm-i.css); @import url(/administrator/components/com_civicrm/civicrm/bower_components/font-awesome/css/font-awesome.min.css);    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. You do not have permission to access this page. Return to home page.    function toggle( element ) { var parent = element.parentNode; var className = parent.className; if ( className == 'crm-accordion-wrapper collapsed crm-fatal-error-details-block') { parent.className = 'crm-accordion-wrapper crm-fatal-error-details-block'; } else { parent.className = 'crm-accordion-wrapper collapsed crm-fatal-error-details-block'; } }


texts:
I was curious to know whether or not it was possible to add members-only pricing to an event. I have a few default prices for an event but I wanted to be sure if it was possible or not to be able to add specific prices for members-only.

I realize there is a question similar here: Permit member-only pricing but that was 2 years ago and I was wondering if anything ever changed, I can't seem to find anything else on the subject and I figure there has to be a way otherwise I feel more people would ask about this...

Thanks!
Matt


texts: Extension Manager fails and so do certain scheduled jobs

texts:
I am using civicrm ver. 4.6.2 on Drupal 7; PHP version is 5.3.29, safe mode is off and open_basedir is not set:

When I try to upgrade through extensions manager I get:

WARNING: The downloader may be unable to download files which require HTTP redirection. This may be a configuration issue with PHP's open_basedir or safe_mode.

Unable to extract the extension.

Extension Upgrade Failed
Download failed - ZIP file is unavailable or malformed

Also, the scheduled jobs for iatapayments fail:

Entity: Job Action: IatsRecurringContributions
Summary
Finished execution of Call Job.IatsRecurringContributions API with result: Failure, Error message: API (Job, iatsrecurringcontributions) does not exist (join the API team and implement it!)
Details

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

Full message:
Finished execution of Call Job.IatsRecurringContributions API with result: Failure, Error message: API (Job, iatsrecurringcontributions) does not exist (join the API team and implement it!)

I believe problems must be related. Anyone know how to resolve this? I believe my resource directories and urls are configured properly. Everything is in the right place.


texts: Emailing people who didn't open a campaign

texts: I'm looking for the simplest way to email a group of people who did not open a given civiMail campaign. Thanks


texts:
For several months we have been seeing the error "Cron Not Running". I have repeatedly configured crontab for the root user, and currently have the following:

0 * * * * wget -O - -q -t 1 https://<redacted>/cron.php?cron_key=<redacted>
0 * * * * drush -r /var/www/html/drupal -l https://<redacted> civicrm-api -u <redacted> job.execute

I have followed the Managing Scheduled Jobs documentation each time, but still cannot figure out what I am doing wrong.

What might I check to make sure Cron is configured correctly?


texts: A way to continue a mailing that was cancelled?

texts:
Currently when a mailing is scheduled if we see a change that is needed, we have to cancel the mailing, then reuse it, fix the mistake, and send it again. Then we have to delete the original if we want to get it out of the interface.

Is there a way to simply "Continue" the cancelled mailing to save a few steps and avoid creating a duplicate and cluttering the interface?


texts: It says 5.7 is a security release - should I upgrade?

texts: "I thought we were on the latest security release but I'm seeing references to a Security Release (when logged in)?"


texts: CiviCRM won't load at all, shows "DB error: unknown error"

texts:
CiviCRM suddenly stopped loading. I am running CiviCRM version 4.5.5 on Drupal version 7.4.4.

As far as I know, no changes were made to CiviCRM or Drupal, but obviously something happened. The dashboard won't load, and when I found an old page in my history and loaded it, it worked but trying to navigate gives me the message "Unable to reach the server. Please refresh this page in your browser and try again." I know the data is in the database because I can access it through PHPMyAdmin.


texts: No matches found for contact reference field in front end profile

texts:
Duplicated on Wp and Drupal Demo sites
Custom field of type contact reference used in front end profile for search and listings (public)
Search returns “no matches found” even though contact name appears in field
Logged in as admin

Entering nothing in search fields and pressing search lists all contacts in database. I don't get why a single contact from the contact reference field is "no match"


texts: How to restrict access to CiviMail's reports, e.g. click rates

texts:
If one sends out a mailing using CiviCRM, one can access an overview of the mailing's result from the mailings menu (see screenshot). From this summary you will also be able to access more detailed information, including the unique opens (see screenshot).

As this information can be considered quite sensitive in regard to data protection, I would like to restrict access to it to certain users/roles. I tried editing the permissions of all relevant mailing reports I could find.

However, it turns out that this information does not seem to be based on CiviCRM'S report function. Even If restrict user's access to any report functions, the detailed mailing information can still be viewed.

Hence my questions are:

Which permission is actually relevant for opening pages such as
civicrm/mailing/report/event?reset=1&event=opened&mid=XYZ&distinct=1
?
Is there any way to restrict access to this information without
denying users to use CiviMail at all?

Tested on CiviCRM 4.7.18 and Drupal 7.54.


texts: Does anyone have a recipe for Commerce / Rules / CiviCRM integration?

texts:
I'm helping a group that has a small Commerce store on the site (Drupal 7, CiviCRM 4.6.9) and I'd love to be able to push data from Commerce purchases back into CiviCRM. I have seen some general talk about CiviCRM Entity and Rules integration being able to do this, but I'm curious if anyone has a recipe that is working for them that they would be willing to post -- including the Rule's event(s), condition(s), and action(s) to do this.

I'm assuming the event should be upon successful checkout in Commerce, but I haven't determined the best way to handle conditions and actions.

Ideally I'd love to be able to do the following:

Push first name, last name, billing address into the CiviCRM contact that is already created (but just contains email address)
On a product type basis (or if necessary, a line item basis) push a contribution onto this contact record, tagged to the appropriate contribution type. (e.g. we have set up the ability to 'add a donation to your order' in the Commerce shopping cart, so we'd like to be able to split apart the physical product purchase into a 'store purchase' contribution, and push any add-on donation as a 'donation' contribution).


texts:
On CiviContact we have a number of custom fields set up as multi-record sets.
Any ideas on how these can be exported?

The import to a multi-record set is hidden on the main import page > tooltips pop up has a link at the end of the help notes which takes you to the import page.  Is the export function similarly hidden...

Any help appreciated.


texts:
I have a simple quickform --
    $this->add('text','trial_number','Trial Number',TRUE);
    $this->add('date','Trial_Date',ts('Trial Date'),CRM_Core_SelectValues::date(NULL, 'Y M d',15,1) );
    $this->addEntityRef('judge',ts('Assigned Judge'));
    $this->add('advmultiselect','started_components','Started Components',$this->getOptions("regComponents"),FALSE);
    $this->add('advmultiselect','advanced_components','Advanced Components',$this->getOptions("regComponents"),FALSE);
    $this->add('advmultiselect','excellent_components','Excellent Components',$this->getOptions("regComponents"),FALSE);
    $this->add('checkbox','elite_offered','Elite Offered',FALSE);
    $this->add('advmultiselect','games_components','Games Components',$this->getOptions("gameComponents"),FALSE);

However, the advmultiselect fields I would like to use select2 for multiple selections of the options.  I have searched, and searched, yet cannot find any examples as to the format of the select2 add.  The options are straight forward - all in a function called getOptions().  The advmultiselect works, but well, that's just ugly.
What is the format of the add('select2'.... and what attributes can I set?
Thanks
Norm


texts: Can't disable debug/backtrace on WordPress

texts:
I was encountering an error sending email so I turned on the backtrace/enabled debugging. No I can't get back to the menu to turn it off. I just have a page of error messages.

Help! Anyone got any ideas?

Thanks
Caroline


texts: How can you set webform to create a new relationship rather than update an expired relationship when the relationship type and person is the same?

texts:
Using webform to create relationships in CiviCRM. If contact 1 already has a existing relationship of the correct type to contact 2 even if it is expired it will update that relationship.

We would like to track when they had a relationship to X.
Is there a way we can enter the relationship information through a webform and have it create a new relationship with X rather than updating their previous relationship to X?

We are using Drupal 7, CiviCRM 4.7 (also happening on 4.6.25) webform_civicrm 7.x-4.16


texts: Email Outgoing Configuration - Failed to connect to the SMTP server

texts:
We are having trouble with setting up our SMTP server.

We have confirmed that the username, password, and port are correct but still get the following message:


texts:
I am working on an event registration. We need to hide certain price set line items based on various factors. Most are based on previous field response but there is one line item that needs to be hidden if user is logged in. I found this post: https://wordpress.stackexchange.com/questions/69814/check-if-user-is-logged-in-using-jquery

But can't seem to get it to work in my custom template. I probably have some syntax wrong.

Any thoughts or a alternate solution would be appreciated.

Thanks


texts: Ajax error when viewing relationships under IIS and Joomla (HTTP400 - invalid syntax)

texts:
This is similar to Ajax Error when trying to view relationships tab, but the analysis is different.  It is not solved by increasing the request limits - they are much higher than the GET parameter.  The browser debugger yields two entries like:
HTTP400: BAD REQUEST - The request could not be processed by the server due to invalid syntax.
(XHR)GET - https://jupiter/joomla/administrator/?option=com_civicrm&task=civicrm/ajax/contactrelationships&context=current&cid=733&draw=1&columns%5B0%5D%5Bdata%5D=relation&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=true&columns%5B0%5D%5Borderable%5D=true&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=sort_name&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=start_date&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=end_date&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=true&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=city&columns%5B4%5D%5Bname%5D=&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=true&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B5%5D%5Bdata%5D=state&columns%5B5%5D%5Bname%5D=&columns%5B5%5D%5Bsearchable%5D=true&columns%5B5%5D%5Borderable%5D=true&columns%5B5%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B5%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B6%5D%5Bdata%5D=email&columns%5B6%5D%5Bname%5D=&columns%5B6%5D%5Bsearchable%5D=true&columns%5B6%5D%5Borderable%5D=true&columns%5B6%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B6%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B7%5D%5Bdata%5D=phone&columns%5B7%5D%5Bname%5D=&columns%5B7%5D%5Bsearchable%5D=true&columns%5B7%5D%5Borderable%5D=true&columns%5B7%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B7%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B8%5D%5Bdata%5D=links&columns%5B8%5D%5Bname%5D=&columns%5B8%5D%5Bsearchable%5D=true&columns%5B8%5D%5Borderable%5D=false&columns%5B8%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B8%5D%5Bsearch%5D%5Bregex%5D=false&start=0&length=25&search%5Bvalue%5D=&search%5Bregex%5D=false&_=1497973438482

This string is so long that it is hard to see where the syntax error might be. Any suggestions, or even suggestions how one might go about debugging this.


texts: How to get the WordPress Username in a contacts or membership export

texts:
Is it possible to include the WordPress username in the export of contact & membership details? We would like to include it in a mailmerge for new members who joined by post.

Thanks

Steve


texts: Searchable Custom Field doesn't appear in Quicksearch options list and is not a sort option in reports

texts:
I have 2 membership custom fields that are set as searchable. One field is integer the other is alphanumeric. Neither field appears in the Quicksearch options in Search Preferences. The custom fields appear as column options in the membership reports but they are not available as sort options.
Is there anything else I need to configure to make them available for search or sortable in reports?

I have tested with a Contact custom field and this works as expected.

Thanks for any help


texts:
Innodb IS default engine, but can't install.  Error message is Unable to create InnoDB tables. MySQL InnoDB support is required for CiviCRM but is either not available or not enabled in this MySQL database server.

I've checked my.conf and made sure that InnoDB is the default engine.  The drupal database is in Innodb.  I've gone through memory allocations and settings.  I've been trying to install civicrm on drupal6 for three days!   I've used drupal6 and civicrm for another client for more than a decade!  But, now, on this new install, I can't get it to work.

I have tried MANY different versions of CivicRM and they all hang at this same error message.  What do I troubleshoot next?  Anyone else have this problem?


texts: Smart group selecting more contacts than match criteria

texts:
I've tried to test v4.7.13 smart groups with relative dates after the bug is supposedly fixed:
Is it a bug that Relative Dates are broken in Search and Smart Groups?

Now, I create an Activity today for one contact.
I do advanced search for contacts with Activity = Today.
Search gives me the one contact with Activity = Today.
I create smart group out of that search.
I go to Contacts > Manage groups and see that in my group is 1156 contacts (from which only one match criteria, namely, has Activity = Today).

UPDATE:
Bug is replicated in CiviCRM Drupal Sandbox v4.7.14.
http://dmaster.demo.civicrm.org/civicrm/group/search?force=1&context=smog&gid=7&qfKey=59a9c20b96f05a8c46befb01c385c298_1338

(Or see group Activity Today in Contacts > Manage Groups)


texts: How can I export an Event Income Detail report to CSV/Excel?

texts:
We find the Event Income Detail report to be useful. But the Actions menu won't let me export this report into a CSV file for some reason.
How can that be enabled?


texts: Implications of making Activity Fields (Subject, Duration, Location, Details) required

texts:
I've been asked to make the standard activity fields
Subject, Duration, Location, Activity Details
required. I can see how to do this from this ticket.

Requiring "Assigned" and "Target" contacts when recording Activity

My question is what would be the implications of doing this? Are any of these fields also used by events, mailings or contributions modules to record interactions, so would setting them to mandatory cause problems with these activity types?

Thought I'd ask before taking a suck it and see approach.