texts: Upgrade froze at 4.7.8, Can't find valid value for qrid

texts:
My upgrade has been running for about 8 hours, but it stalled after completing 4.7.7, from 4.3.8 at. I checked top to see if Drupal or CiviCRM were running, and there was no indication of the process. I decided to refresh my browser and my cookie must have expired, because Drupal asked me to log in again. Then I pulled up the queue runner in the browser (https://dev.example.com/civicrm/upgrade/queue/runner) it spit out the error:

  Sorry but we are not able to provide this at the moment.
  Could not find valid value for qrid

The log shows that it could not find valid value for qrid. Below is the log from /sites/files/civicrm/ConfigAndLog, starting after completing upgrade to 4.7.6:

Dec 21 12:18:17  [info] Running task: Begin Upgrade to 4.7.7
Dec 21 12:18:19  [info] Running task: Upgrade DB to 4.7.7
Dec 21 12:18:21  [info] Running task: Upgrade DB to 4.7.7: SQL
Dec 21 12:18:29  [info] Running task: Finish Upgrade DB to 4.7.7
Dec 21 12:20:15  [info] Running task: Begin Upgrade to 4.7.8
Dec 21 12:20:17  [info] Running task: Upgrade DB to 4.7.8
Dec 21 12:20:23  [info] Running task: Upgrade DB to 4.7.8: SQL
Dec 21 12:20:56  [info] Running task: Upgrade mailing foreign key constraints
Dec 21 13:26:27  [info] $Fatal Error Details = Array

(
    [message] => Could not find valid value for qrid
    [code] =>
)

Dec 21 13:26:27  [info] $backTrace = #0 /var/www/html/drupal/docroot/sites/all/modules/civicrm/CRM/Core/Error.php(373): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /var/www/html/drupal/docroot/sites/all/modules/civicrm/CRM/Utils/Request.php(120): CRM_Core_Error::fatal("Could not find valid value for qrid")
#2 /var/www/html/drupal/docroot/sites/all/modules/civicrm/CRM/Queue/Page/Runner.php(52): CRM_Utils_Request::retrieve("qrid", "String", Object(CRM_Queue_Page_Runner), TRUE)
#3 /var/www/html/drupal/docroot/sites/all/modules/civicrm/CRM/Core/Invoke.php(312): CRM_Queue_Page_Runner->run((Array:4), NULL)
#4 /var/www/html/drupal/docroot/sites/all/modules/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:13))
#5 /var/www/html/drupal/docroot/sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:4))
#6 /var/www/html/drupal/docroot/sites/all/modules/civicrm/drupal/civicrm.module(448): CRM_Core_Invoke::invoke((Array:4))
#7 [internal function](): civicrm_invoke("upgrade", "queue", "runner")
#8 /var/www/html/drupal/docroot/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:3))
#9 /var/www/html/drupal/docroot/index.php(21): menu_execute_active_handler()
#10 {main}

I suspect that the qrid is the queue runner ID and that the queue was lost when Drupal asked me to log in again. The log doesn't show that there was any other issues before the qrid problem. I'm not certain if something was wrong before I was forced to log in again or if that is what did it it.

Furthermore, the file permissions for the civicrm directory in sites/all/modules was somehow changed to an owner I am not familiar with on our server (test2?):

    drwxr-xr-x 19 test2 csf      4096 Nov  2 19:32 civicrm
drwxr-sr-- 80 fclub www-data 4096 Oct 16  2015 contrib
drwxr-sr-- 15 fclub www-data 4096 Oct 16  2015 custom
-rw-r--r--  1 fclub www-data  952 Aug  5  2015 README.txt
drwxr-sr-x  2 fclub www-data 4096 Nov  3 22:40 timeago

I tried loading this URL to see if that would help:

civicrm/upgrade/queue/runner?reset=1&qrid=CRM_Upgrade

but then received the error:

  Queue runner must be configured before execution.

I should have used Drush to run the upgrade so I wouldn't have to deal with Browser issues.

Question 1: Is there anyway to salvage the progress and continue from 4.7.7, repair the database or reinstate the queue runner?

Question 2: How can I figure out what went wrong so that I can try running the upgrade again without this happening?


texts: How to automatically set PDF 'Activity Subject' from template subject?

texts: Is it possible to automatically set the 'Activity Subject' of PDF letters to the 'Message Subject' of the selected template? I swear I've seen this done with a quick bit of code, but the keywords are escaping me...


texts:
I'd like to import an inconsistent list of contact names with associated donations and match the names to contacts.  IMO there are 3 options:

Clean the csv in advance by displaying contact alternatives (ideally showing contact ID for matching)
Run an import script and use interactive matching logic.
Use forms for batch entry and interactively match contacts.

The problem is that the person who understands the matching is not the same person who can do the interactive import.

I was wondering if someone has used an excel function / drush or extension of some sort to process a list of names and retrieve  likely matches that I could present (with contact ID) in excel so the user would not have to use the autocomplete widget. Would like to avoid a developer.

The


texts: Forgot to make new database for civi... how uninstall?

texts: I installed CIVI but forgot to create a new database just for civi... how do I undo or uninstall and start over?


texts: CiviMail report not showing proper data after upgrade

texts:
I have recently upgraded CIVICRM to 4.7.27 and my wordpress version is 4.9.1. Before upgrade civimail report was showing proper data for example "Unique Opens", "Total Opens", etc. But now it's showing 0 value. I have checked all permission on files and folder and its default as

d -exec chmod 755

f -exec chmod 644

Please help me ASAP.


texts: Event registration times out with invoicing enabled

texts:
Environment: shared hosting (LAMP), CiviCRM 5.18.2, Backdrop 1.14, PHP 7.2.23
When invoicing is enabled (pay later, no payment processor), event registration times out after confirmation screen is confirmed by user. No final confirmation/thank you screen shown, or email sent with pdf invoice.
PDF extension selected in CPanel PHP Selector > Extensions though throws same error if not selected; PHP timeout extended to 120 seconds, though this does not seem to override host settings (cannot restart Apache after changing).
Error message:
"[09-Oct-2019 23:57:10 Europe/London] PHP Fatal error:  Maximum execution time of 30 seconds exceeded in ~/modules/civicrm/vendor/dompdf/dompdf/src/FrameDecorator/Block.php on line 193" Any thoughts gratefully received.
Disabling invoicing allows registration, and confirmation email sent with pdf invoice with no invoice number, just no contribution record or ability to generate copy invoice etc.


texts: When adding CSS in civimail (under source) getting an error when trying to see or send test

texts:
Trying to use my own custom html e-mail in CiviMail with custom CSS in it (specifically to optimize on mobile).
When I have the CSS stylesheet info on top I cannot send a test email or preview in HTML. when I click either of them I get Error
"Sorry an error occurred and your information was not saved"
How can I get around this?


texts:
We've got 27 emails that show as completed, have a report, etc; however, they are showing on the list of Draft/Unscheduled emails. What could be causing this to happen? I'm trying to clean up the back-end for the new volunteers who will be working with the site this year, but I don't want to delete emails that have actually been sent.

We're on Drupal 7 and CiviCRM 5.5.3


texts:
We recently installed Mosaico (and Shoreditch Theme and FlexMailer) on our CiviCRM 5.4 Wordpress installation.

None of the required Mosaico menu items are showing up under Mailings or Administer>CiviMail

I've cleared caches, etc.

Thoughts?


texts: When will Drupal 8 be officially supported?

texts:
As I understand it, the Drupal 8 version of CiviCRM is available but still in bug fixing and feature adding mode.
Is there news on when it will be officially on the civicrm.org website?


texts: What are the most popular extensions for CiviCRM?

texts: Ever wonder how many Civi sites are using a particular extension? Which are the popular extensions your site is not yet using? Me too!


texts: If I move from paypal to stripe, what steps or information I need to take into consideration in terms of recurring contribution? And how to initiate the moving existing recurring contribution profiles?


texts: How to set a permission using drupal ACL?

texts:
I am developing an extension. I want to provide permissions using drupal.

I am using following hook for creating a permission

hook_civicrm_permission(&$permissions);

But, how to do that (means can view or edit some custom data)?
Please suggest some similar extensions.


texts: Importing CiviCRM Transactions into quickbooks

texts:
I'm wondering whether to start invoicing with Quickbooks and I am wondering if when I upload civicrm transactions into quickbooks if it will automatically link the payment to the invoice?

Can CiviCRM and Quickbooks to work together to avoid double entry?


texts: How can I create a contact (quickly) with multiple contact subtypes?

texts:
The need

I need to create contacts that have more than one contact subtype assigned. For example Student + Parent.

Slow approaches

If I create the contact directly from the menu link Contacts > New Individual > New Student, then it is not possible to assign it a second subtype on the immediat form. It is necessary first save the contact and then re-edit to add the second contact subtype.
Also it's possible to create the contact from the menu link Contacts > New Individual and then assign the needed contact subtypes on the immediat form. But this option is confusing by our users as they hope to create an Student or a Parent but not a Individual.

There is a more direct approach to this need?

Maybe I expected to find the possibility to add an item to the menu of contacts that allow us to create directly a contact with multiple contact subtypes with and URL like civicrm/contact/add?ct=Individual&cst=Student+Parent&reset=1.


texts: How to have form not require billing address if zero fee in priceset is selected in Event?

texts:
Using CiviEvent, I have an event with a priceset that includes various prices, but also a zero fee option.  The billing block information should not be required if zero fee is selected, but I can't get it to work.

I am open to ideas for workarounds.  I am not able to upgrade the CiviCRM version at this point.

On the web event registration form, before clicking continue:

If a non-zero fee is selected, the billing block correctly appears
and shows as required to fill in if Paypal not selected.
If the zero fee is selected, the billing block correctly does not appear.

BUT

When the user clicks the continue button after selecting the zero-fee option, an Error message comes up about fields in the billing bock being required.  This is despite the billing block  not being shown to the user (correctly as there should not be shown when zero fee).

For the first-time click, it also includes billing firstname/lastname, which I would expect to be taken from the Individual firstname/lastname that were filled in

If I click the continue a second time, it no longer mentions billing firstname/lastname, but it still shows some billing block fields as being required.

Billing First Name is a required field.
Billing Last Name is a required field.
Street Address is a required field.
City is a required field.
State/Province is a required field.
Postal Code is a required field.
Country is a required field.

The second time:

Street Address is a required field.
City is a required field.
State/Province is a required field.
Postal Code is a required field.
Country is a required field.

I have version 4.6 so it might the bug below, but I am not sure.
Zero fee for a paid event

thanks,
Michele


texts:
I am progressing deeper and deeper into CivCRM intricacies, and work with External (https://) access of the database via API's. When performing a python
requests.get(....,entity=Contact,action=get) it works OK, and I get the data I request.
Next I tried to update the contact/membership with a payment via
requests.get(...entity=Contribution, action=create...) and the same for requests.post, both gave the same disappointing  status_code of 414. I also tried to get some more information and among the plethora of data dumped the following was "readable":
"is_error":1,"error_message":"API permission check failed for Contribution/create call; insufficient permission: require access CiviCRM and access CiviContribute and edit contributions"}, as well as a status_code of 414 (unknown to me)
I have now updated my access-capabilities (granted all "Edit Capabilities: Custom) in the role table in WP (where our CiviCRM resides), so I shall have all the rights mentioned above. Still the same problem. We run API 3 at present, but I do not think that is the problem here.
So here I am asking for some guidance, please!
Claes


texts: Can Civi be accessed via the iPhone or Android phones and what about on the iPad or other tablets?


texts:
I never check the geocode box when importing. Yet, I found that even small imports were taking a long time. I ran strace on the php process and saw lots of lookups to google. So I disabled both the mapping provider and geocoding provider globally, re-ran the import and it went through in a fraction of the time.

Next, I took a closer look at the code that is triggered based on the geo coding checkbox:

The file: Contact/Import/Parser/Contact.php contains:

 public function import($onDuplicate, &$values, $doGeocodeAddress = FALSE) {
    $config = CRM_Core_Config::singleton();
    $this->_unparsedStreetAddressContacts = array();
    if (!$doGeocodeAddress) {
      // CRM-5854, reset the geocode method to null to prevent geocoding
      $config->geocodeMethod = NULL;
    }

In other words, if geo code checkbox is unchecked, the $doGeocodeAddress is set to false. If it is set to false, then we set $config->geocodeMethod = NULL;

Hm. Could this possibly work? If you set a property on a singleton locally in a function, it seems like it would not be available outside the function.

However, this "fix" has been in place for years so I'm asking this question as a sanity check before opening a ticket.

Maybe something changed in the behavior of PHP?


texts: I have a report that I would like sorted by County but that field doesn't appear as a sortable column, although it does appear on the report. This field is in fact 'State/Province' but is renamed via word replacement to 'County' (I am in the UK).  There are other fields that appear as sortable that are surprising because their usefulness is very dubious (like Notes) but County doesn't appear.  Is there some way to make this field appear?


texts: Add an image for each address in contact form

texts:
As in a previous (unanswered) question, I'm trying to add an image with an anchor for each address in the contact form.

In my extension, through the buildForm hook I'm able to add (once) an image in the contact form, but not to add n images in each address section.

Thank's for your answer.


texts: Wordpress subscribe.url not using base page

texts:
I'm setting up a mailing list in CiviCRM 4.7.14 and the latest Wordpress.  In Administer->System Settings->CMS Database Integration, I have the base page set to /civicrm.  Yet when a mailing list subscribe confirmation is sent, the subscribe.url token uses http://mydomain.com/wp-admin/admin.php?page=CiviCRM&q=civicrm/mailing/confirm&reset=1&etc...

By default, the link goes to the standard Wordpress login screen.  If I change the URL manually in the browser to use /civicrm instead of /wp-admin/admin.php it processes the subscription.  Or if I log in, the admin.php link processes the subscription.

I understand the "base page" stuff has been evolving through recent versions.  I did upgrade this CiviCRM install from 4.6.x, so maybe there was a glitch with that.  Is there something I can do to correct things?  I tried changing the base page to something else, then back to /civicrm to reset things, but it didn't help.

I haven't tested the unsubscribeUrl token, but can do so if it would help with debugging.

Thanks for any thoughts!


texts: I have Civicrm 5.3.0 on Wordpress. -  It says need to upgrade a security patch.  Should it be 5.3.1 or 4.6.38 first?  Want to end up with 5.3.2


texts: How do I make a Simple SOAP request in CiviCRM?

texts:
As I can see there is a get_contact() function in CRM/Utils/SoapServer.php.
I would like to use this function to get the list of contact. How can I do that ? Is it similar to how we make a Rest api call like http://<site_name>/sites/all/modules/civicrm/extern/soap.php? ? If it is, what params do I need to pass to get the required result ?

Any help/hints would be appreciated. Thanks.

Update : I'm using the latest version of CiviCRM.


texts: CiviCRM cron job failing under Joomla 3.7

texts:
I updated to Joomla 3.7 and shortly thereafter, my CiviCRM cron job started failing. When I hit the URL in a browser, I get:

  Fatal error: Call to a member function get() on null in
  /home/public_html/libraries/joomla/session/handler/joomla.php on line
  71

That's PHP 5.6.30 and it's a little different on PHP 7.0.16 (with max reporting on):

  Error displaying the error page: Application Instantiation Error: Call
  to a member function get() on null

I'm using CiviCRM 4.7.18. This looks like a CiviCRM issue since my other cron job works fine.


texts:
I am running 4.7.8 on Wordpress and cannot find the Contact Dashboard.  I see Dashboard for Contributions, Events and Mailings but not under Contacts.

Thanks

Steve


texts: Paypal recurring payments failed after merging the contact. How to fix?

texts:
2 contacts were crated for the same person due to some typo of the donor while given donation online. one of the contact record had a recurring payment setup. I have merged them both using the menu. But i think i have merged the wrong way around. now paypal is not able to process the payment because there is no contact record by ID 1212 (it was deleted permanently, not available in trash).

Newer contact record ID is 1313. is there a way to change the ID of this new one to 1212 so the payment gets processed?

This is from civi log

Jul 04 14:04:05  [info] $POST = Array
(
    [payment_cycle] => Monthly
    [txn_type] => recurring_payment_skipped
    [last_name] => Entc
    [next_payment_date] => 03:00:00 Jul 09, 2015 PDT
    [residence_country] => GB
    [initial_payment_amount] => 0.00
    [rp_invoice_id] => i=e45c4d0dad9c6a9a0693799f8c99d38f&m=contribute&c=1212&r=4&b=17212&p=6
    [currency_code] => GBP
....)

    Jul 04 14:04:05  [info] Could not find contact record: 1212 in IPN request: Array
    (
        [component] => contribute
        [invoice] => e45c4d0dad9c6a9a0693799f8c99d38f
        [txnType] => recurring_payment_skipped
        [paymentStatus] =>
        [amount] =>
        [reasonCode] =>
        [first_name] => Eli
        [last_name] => Entc
......   )


texts: What is the recommended level of PHP for CiviCRM? There seems to be some inconsistencies

texts:
See the wiki which says the minimum level is 5.4+

But see this linked page from the wiki which recommends 5.6 with a bare minimum of 5.3.10.

See also the system status for release 4.7 which says the minimum recommendation is 5.5

Which is it?


texts: Incomplete (abandoned) event registrations

texts:
Is there a way to capture those who fill out the event registration form, hit continue, but then do not hit continue on the confirmation page? I thought it used to do this, but noticed today that either I was remembering wrong or it has stopped doing this.

Essentially the folks I'm working with want people to have the pay later option without ever showing them that option. Too many people pick that rather than just paying now and then they forget to pay. But some government organizations and such need to do an invoice. So they want to capture the ones only partially submitted as being incomplete so they can then update them when the payment comes in.

They have the information on the confirmation page that you should pay via Paypal, but if you can't, here's how to do it. If you click Continue, it then takes you to Paypal.


texts: Bug: adding new contact through relationship limited to subtype

texts:
I have a custom relationship type that is has contact B limited to a contact sub-type. Now when I go to a contact to create add this custom relationship and use as related contact New individual create a new relationship for this custom relationship, then it always fails with the error message:

  1 invalid relationship record 1 relationship record was not created
  due to an invalid contact type.

I think this is a bug. When you use New individual from the context of a relationship that needs a particular sub-type, then you would expect that the new individual is automatically created with that sub-type. Otherwise the convenience of on-the-fly creation has become useless.

I have been able to reproduce this error on the demo site.

Can someone confirm this?


texts: Joomla CiviCRM Upgrade 4.3.9 to 4.4.x version

texts:
I am unable to upgrade 4.3.9 version into new version ..

I am getting this error : Error: Consolidate activity contacts

Type    DB_Error
Code    -2
Message DB Error: syntax error
Mode    16
UserInfo    UPDATE civicrm_option_value SET is_reserved = 1 WHERE option_group_id = 62 AND value IN (2, , 3) [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 ' 3)' at line 3]
DebugInfo   UPDATE civicrm_option_value SET is_reserved = 1 WHERE option_group_id = 62 AND value IN (2, , 3) [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 ' 3)' at line 3]


texts:
I've created a few rules with CiviRules that trigger an email. They all work perfectly as long as I don't add a delay.
I've tested adding a 1-minute delay with different types of rules but the email never gets triggered?

The job appears in the civicrm_queue_item table but doesn't get released

The job log for CiviRules delayed actions says success

Using CiviCRM 4.7.27 and CiviRules 1.15

I did further testing on my local environment and it works as expected when I changed the site's timezone to the one I live in.

Update: The emails were sent in the end but 11 hrs later even though the release date was correctly set to 1 minute later in the civicrm_queue_item table


texts:
Running CiviCRM 5.13.4 on WordPress current version. Everything had been working then we were informed that the site had stopped sending email. I have been trying to re-establish an SMTP connection ever since with no luck.

I have verified the user name and password for the email address using a desktop client
I have verified that the ports are open and that the CiviCRM server is not blocked by our firewall.
I have cloned the site with similar results, except that the clone can connect only connect on port 587, but the production site can not connect at all.
I have been utterly unable to locate any errors from exim, modsecurity or apache on either the CiviCRM server or the mail server.

The only error I get is:

  Mail Not Sent
  Sending test email: From: fppta@mailprocessing.org To: jlyons@rboa.com
  Oops. Your SMTP settings are incorrect. No test mail has been sent. An
  error occurred when CiviCRM attempted to send an email (via SMTP). If
  you received this error after submitting on online contribution or
  event registration - the transaction was completed, but we were unable
  to send the email receipt. The mail library returned the following
  error message:

> Failed to connect to mail.mailprocessing.org:465 [SMTP: Invalid
  response code received from SMTP server while sending email. This is
  often caused by a misconfiguration in Outbound Email settings. Please
  verify the settings at Administer CiviCRM >> Global Settings >>
  Outbound Email (SMTP). (code: -1, response: )] This is probably
  related to a problem in your Outbound Email Settings (Administer
  CiviCRM » System Settings » Outbound Email), OR the FROM email address
  specifically configured for your contribution page or event. Possible
  causes are:   •   Your SMTP Username or Password are incorrect.   •   Your
  SMTP Server (machine) name is incorrect.  •   You need to use a Port
  other than the default port 25 in your environment.   •   Your SMTP
  server is just not responding right now (it is down for some reason).
    •   The FROM Email Address configured for this feature may not be a
  valid sender based on your email service provider rules. Check this
  page for more information.

Where should I look next?


texts:
Is it possible to change a communications preference for several members using profiles? I can't find how to do it. If I select "Contact" while having members filtered Civi won't find the profile. But if I select Member from profile I can't bulk-change communication preferences.

Am I doing stuff wrong?


texts: Email-to-activity processing – create Activity at future date

texts:
I would like to be able to set tasks on a Contact using the Email-to-Activity processor. This would allow me to set Scheduled activities on a Contact in CiviCRM, like:

Follow-up with Sally in two weeks about the topic of the email I'm sending right now

Is there a way to do this?

Example:

I'm emailing a Contact from gmail and in the BCC field I add my Email-to-activity address to attach the email to the Contact's record in CiviCRM.

I would also like to add another Email-to-activity processor address like 2-week-follow-up@my-org.com that would:

Add an Activity to the Contact with a Type I specify (email, phone, etc)
Sets the date to a future date I determine (ie. two weeks from today)
Sets the Activity Status to "scheduled"

This would replicate the functionality of Highrise Task Dropboxes: https://help.highrisehq.com/email/task-dropboxes/


texts: Why can't I see different financial types in contribution reports

texts:
With our contributions, one payment may contain 3 financial types ... e.g. an event fee, membership fee and donation. I have created "Price Sets" (of one Financial Type), which then contain 3 different "Price Fields" (which have separate Financial Types allocated) but when it comes to reporting on Contribution Detail, the filter / field "Financial Type" only pulls through "Event fees".

I can see that when creating an event I can choose 1 financial type
When creating a Price Set I can choose 1 financial type
But I can add multiple Price Fields to a Price Set, but these aren't being detailed / broken down when I go to the reporting on Financial Type.

Help! Are we setting up the price sets incorrectly? Do we need to create Custom Fields?

++ Added info: when running an Event Participant Report, if you select Fee Level as a column it groups all the different "Option Labels" from the various Price Fields within the Price Set. So the information is there and separated, I just can't see how the associated values for teach of those option labels listed for each participant.

Thanks so much for your help in advance.


texts: We're moving over to CiviCRM. We don't currently use - or actually really plan to use - it for our donations, many of which are just sent as regular bank transfers. I'd like to be able to record these on CiviCRM without entering them manually, but can't see a way to do this - any thoughts?


texts:
I would like to know if it is possible to customize the description of the contacts or any objects of the system?
Can we enrich dropdown lists?
Can we add fields and indicate it's a text, a date, a decimal, a booelan etc...
Can we reorganise the tabs layout and mix standard fields and customized fields as we want?

Thank you for your answer
Regards
Evelyne PLEE-LEMOYNE


texts: One Time Login URL not Received : Looking for a Spare Solution

texts:
Drupal 7.56 / CiviCRM 4.7.20

Some (only a few) of my users do not receive the "one time login url" mail when they want to reset their (forgotten) password (also checked in spam and trash).

The odd thing is that if I personnaly send them a mail from postmaster@... (using thunderbird for instance), they receive it.
They also receive it if I send it from CiviCRM (from any Organization or Individual).
I find no explanation to that.

So, I envisage to personnaly send them their [user:one-time-login-url]. Can I do that ? How ?

(I know that this is rather a Drupal specific question, and I submitted it to Drupal Stackexchange, but I also submit it here just in case someone has a solution : I thought I could include this [user:one-time-login-url] in a mail sent via CiviCRM, but this token is not available in Civi mailing feature).


texts: I have been working to finalize import of approximately 2,000 contact records from our old systems. Our old db had 2 people in one record, so have been working to separate. Imported the primary contact and was using import on the second contact and utilize the "master address belongs to" field. My 2 smaller groups of the second contact worked just fine and properly "mapped" and saved the master addressee belongs to. Yesterday I was importing my last batch of about 600 names. The import took longer than normal but eventually I just went to a screen saying there was a web server error. About 94 of the last records didn't get imported. As I was working on some cleanup I realized that when I would manually go edit someone's address and tie it to a master address nothing would save. I was able to take one contact, put in an address, save, and then edit again and tie the master address. However, I haven't been able to replicate that again. I ran the system job to clean cache and that didn't help. I was on 4.6.5 and decided to go ahead and do my upgrade yesterday to see if that might clear up whatever, and it didn't. The crash of the import seems to be the point where something changed. Has anyone experienced this or recommend anything (even at the table level in phpMyAdmin -- which I am comfortable navigating in) that I can check/try?


texts: Why are commits to 7.x-master not included in latest versions of CiviCRM?

texts:
I had two pull requests committed to 7.x-master on GitHub over the past year.

When I view the two files that were changed by my pull requests, the changes are present in the master branch.

They do not appear to be included in latest download and I end up having to manually add them.

I was under the assumption that commits to master would be included in future releases.  Is that not the case?


texts: Unable to insert membership custom field in e-mail using Smarty

texts:
I created a custom field set and a custom field used for memberships.
Now i would like to insert the data from the custom field into my e-mail template.
So i tried to find the custom field id by going to the edit custom field page:

?option=com_civicrm&task=civicrm/admin/custom/group/field&reset=1&action=browse&gid=4

So i presume that the the id is membership.custom_4 (???)
However when i add another Custom Field in the same group, I also find the same id. So it looks like the id that i find is from the Custom Field Set.

My question/problem is: what is the correct way to find out the custom field id and what is the correct syntax for this membership custom field within Smarty

When using the following code in the e-mail, the mail is not sent and the interface hangs forever. I only use plain text e-mail for testing.

{capture assign=lic}{membership.custom_4}{/capture}
{$lic}


texts: In which table is Activity assignee contact information stored in mysql?

texts: I'm looking for the table in which Activity assignee contact information is stored in mysql.


texts:
When our members are trying to register with us they are presented with a HTML suspicious activity error.

Can anyone advise why?

I've searched through sites and all I can come up with is a IDS issue but i'm unsure how to turn this off.


texts: How to install Wordpress/CiviCRM on arvixe hosting server

texts: I am running WP 4.4.2 trying to install CiviCRM 4.7.1. I get to the point where I enter the URL to run the install script then get a message that I do not have sufficient permsissions to access this page. The CiviCRM instructions say that this could be due to the fact that I deactivated CiviCRM before running the script, but I did not do that. It is activated.


texts: One of our admin users is replicating multiple times a day CiviCRM 4.6.38 Wordpress

texts:
We are using CiviCRM 4.6.38 Wordpress.

One of our admin users is replicating multiple times a day and I don't know why or how to resolve this issue.


texts: How to allow anonymous user to edit their contact details on CiviCRM?

texts:
I have created a profile with following fields
First Name
Last name
Street address
Postcode
Phone

My plan is to include the profile link to Contribution Receipt template with hash and let the donor update their personal details if any mistake is in his profile. My link looks like this.

https://example.com/civicrm/profile/edit?gid=48&id=8949&11e24e6f361dceacd63ea0120b00c871&reset=1

But when the link is clicked it says , You do not have permission to edit this contact record. Contact the site administrator if you need assistance.

This is the permission for anonymous user is set in drupal:

CiviCRM: profile create
CiviCRM: profile view
CiviCRM: profile edit
CiviCRM: access all custom data
CiviCRM: access contact reference fields

What am I doing wrong? Can anyone help please? Thanks


texts: CiviMail - Prevent images from being blocked by Outlook

texts:
How do I embed images in the email body using CKEditor such that they are loaded automatically in email clients such as Outlook and they and not blocked, with the user having to righ-click to download.
Our organization is currently using a separate email client (Sendinblue) to send mass emails, since all emails with embedded images sent from Sendinblue are not blocked by Outlook or other email clients. This is a real disadvantage as we now need to maintain an email list in Sendinblue and manually sync this with contacts and donors in CiviCRM. I have read that you need to use Content-ID to embed images into the email, but how do we achieve this with CiviMail and the CK Editor? We are desperate for a solution here! So any help resolving this, is very much welcomed.


texts:
after upgrading to CiviCRM 4.7.23 for Wordpress I can no longer configure Event Fees and get a DB Error: syntax error.

I tried upgrading to 4.7.24 and still no joy.

The log file contains this:

    Sep 28 12:41:10  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => exceptionHandler
        )

    [code] => -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => SELECT  id, entity_id
 FROM civicrm_entity_financial_account

 WHERE ( account_relationship =  AND entity_table = 'civicrm_financial_type'  )

 ORDER BY entity_id
 [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 'AND entity_table = 'civicrm_financial_type'  )

 ORDER BY entity_id' at line 4]
    [type] => DB_Error
    [user_info] => SELECT  id, entity_id
 FROM civicrm_entity_financial_account

 WHERE ( account_relationship =  AND entity_table = 'civicrm_financial_type'  )

 ORDER BY entity_id
 [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 'AND entity_table = 'civicrm_financial_type'  )

 ORDER BY entity_id' at line 4]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="SELECT  id, entity_id
 FROM civicrm_entity_financial_account

 WHERE ( account_relationship =  AND entity_table = 'civicrm_financial_type'  )

 ORDER BY entity_id
 [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 'AND entity_table = 'civicrm_financial_type'  )

 ORDER BY entity_id' at line 4]"]
)

I have since found more issues which may be related.

I can no longer edit or add Payment Processors and get an error saying: This financial account cannot have '' relationship.

I also can't add or edit Price Sets.

Further digging found this in my tracestack:

/wp-content/plugins/civicrm/civicrm/CRM/Financial/BAO/FinancialType.php(196): CRM_Core_PseudoConstant::populate(NULL, "CRM_Financial_DAO_EntityFinancialAccount", TRUE, "entity_id", NULL, "account_relationship =  AND entity_table = 'civicrm_financial_type' ")


texts: Does the email address always have to be in the donation section on a Contribution Form?

texts:
I tried to add an email address in the "Name and Address" profile, hoping it would remove the email address from up in the donation amounts area (keeping all the contact info in one section). Instead it deleted the email address field from the "Name and Address" profile.

Can I move that email address down somehow?


texts: When sending mailing incorrect amount of contacts displayed

texts:
I have a mailing list group called "All Contacts". It has about 450 contacts with valid email addresses that we would like to send email to.

When we go to "New Mailing" and select All Contacts it only sends to 270 contacts.  I am wondering Why it is not sending to all of the contacts?   Only about 7 contacts are opted-out so it should be sending to at least about 350 contacts.

*After further review, it appears as though it is contacts that have been recently imported that are not being added to the Mailing recipients list.  Event though they have been added to the mailing list group.

THanks,


texts: Can multiple websites be synchronized under the same CRM installation

texts:
I am very new to CiviCRM so I'm sorry if this sounds silly.
I want to ask if you can install the CRM on one website, but manage/gather/synchronize the activities from another one. As an idea, I will try it on Wordpress, but the question is generic.
For example, the main website is one of the main organization (which has various activities, products etc.), where Civi would be installed, then there is another one, like an online shop for example (with products mngmt., sales, marketing actions etc.) which needs to send its activities to the main website too.
Can that be achieved?
If yes, is it possible with just one Civi instance or there needs to be an instance on each wesite?
In any case, I'm really excited about this platform that I recently found out about and it seems absolutely amazing.
Thanks for any feedback.
Andy


texts: How do I report a problem in civicrm_api3 class?

texts:
I am using civicrm_api3 class with the REST api, and Options do not get handled correctly because the code does not allow for an array within the overall parameters array.

I have it fixed  (it is a very simple fix), but I don't know who I should let know.


texts:
We use CiviCRM for an educational program. Currently, parents enroll students in classes, and then have the option to pay automatically on a monthly basis through the use of a monthly membership on auto-renew. The issue is that we do not run programming in the summers, so each of these auto-renew memberships has to be manually shut off by us at the end of the school year.

Is there a way to set auto-renew to expire? Or alternately, is there a way to set up a yearly tuition/membership that is paid in monthly installments, and ends when the full amount has been paid?


texts: How do I add a column to a Contribution Summary report which will show the date and amount of the most recent payment/donation?

texts: When running a payment report using the Contribution summary,  along with the columns showing number of payments, payment aggregate and payment average, I would like to be able to see the date and amount of the last/most recent payment. This information can be separately gathered by running a Contribution detail report, but it is a lengthy process going through two separate spreadsheets when, ideally, I would want this information regularly, so having the data within the Contribution summary report who be ideal.


texts:
I'm using CiviCRM v5.x with PHP 7.2. I would like to know how long would the CiviCRM support end for v5.x or may I get some information about the support terms?

Great thanks for the kind support!


texts: How do we move our civicrm SQL database from the cloud to our network?

texts: We are running our CiviCSM system on a vendor's host with our database in the cloud.  We have a CiviCSM system built for our network that is not currently in use, but we want to move the database from the cloud to our network.  Can we Export/Import, Backup/Restore or Detach/Attach and which would work best?


texts: Drupal Webforms: Can I use the Conditions to control how the contacts are filtered?

texts:
I have a webform for staff members to record supervision with volunteers, and each staff member has approximately 10 volunteers that they are the named 'Link Worker' for. The webform has a field for the Staff member's name and a field for the Volunteer's name (both using autocomplete so that it allows users to select from contacts already in the database).

My question is, is it possible to filter the volunteer contacts by the Staff Member? (i.e. if we select "John Smith" as the Staff member, can we restrict the volunteers to those who John supervises?)

I think the answer is no, it's not possible, but just wondering if anyone has any suggestions....


texts: Membership renewal issues - Can a renewal payment date by set as membership start date?

texts:
We uncovered a potential workflow issue in our configuration with regards to membership issues.

As we migrated to CiviCRM, we had users on an offline payment processor, and once this expired we asked them to move over to an online payment processor such as Stripe or GoCardless.

As an example, a user's offline membership expired on 25th January 2019 and they renewed online via Stripe on the 18th of February 2019. This Stripe was an annual membership with a recurring contribution.

It's now 2020, and the user received our scheduled reminder 'Your membership has expired' on the 24th of January. The original offline membership date. This confused the user because a) it came earlier than her last payment date and b) expected it not to expire at all because they had the recurring contribution set up.

Investigating it further shows that the membership had indeed expired. But the recurring contribution via Stripe is still active and set up to renew on the 17th of February 2020.

Is there any way to change this so that a membership renewal that occurs some time after it's expired renews the membership from that latest payment date? Otherwise, this gap between expiry and auto-renewing payment is always going to exist. Each member is going to enter the expired email workflow, even though they have a recurring payment and in reality, aren't expiring.

We have a large number of other existing members who will migrate across to the recurring payments managed on CiviCRM and would likely encounter the same problem.

Any help would be much appreciated! Thanks.


texts: 4.6.10 upgrade from 4.2: Mailings component is broken; angular.js errors

texts:
We've upgraded 4.2 LTS to the latest CiviCRM 4.6.10
New AJAX (angular.js) driven interface fails. Cache clean-up, template_c reset, disabling JS optimizer, removing custom tmpl and custom php did NOT affect the issue. Please, advise


texts: Add 'Non-deductible amount' to Contribution Receipt template

texts:
I am trying to add the non-deductible amount to my Automatic Contribution receipt but it is not printing the value. Any tips? I am using Civicrm 4.6.19 with Drupal 7

  <tr>
    <td {$labelStyle}>
      {ts}Non-deductible Amount{/ts}
    </td>
    <td {$valueStyle}>
      {$nonDeductAmount|crmMoney:$currency}
    </td>
  </tr>


texts: View out of office responses from contacts

texts:
Following mailings is there a way to view out of office responses from contacts.  If the mailing is via Mail Chimp you get out of office responses into your inbox but on Civi you only get the number of bounce backs.  From what I can see Civi assumes the mailing has been delivered but we cannot establish if an out of office has been returned and therefore cannot keep our contact lists up to date.

Any assistance with this would be appreciated, thank you.


texts: Why is the billing name missing from the contributions email receipt?

texts:
Emails being generated from new members are now missing 'billingName'. I'm not sure when this happened, we are on 5.11.

The presentation of the output is

Billing Name and Address
<blank>
<billing address.

The form has billing_first_name and billing_last_name.

The template web/sites/all/modules/civicrm/xml/templates/message_templates/contribution_online_receipt_html.tpl

has

{elseif $amount GT 0}

     {ts}Billing Name and Address{/ts}

     {$billingName}

     {$address|nl2br}

     {$email}

  {/if}


texts: Mailchimp Extension - Webhook URL can't be verified

texts:
I'm having trouble with creating a Mailchimp webhook and I'm unfamiliar with how to troubleshoot this any further. (I've also posted this question to the Extension's Github)

The API key and callback info is correct but when attempting to create the webhook Mailchimp says,

  We couldn't verify the URL is working. Please double check and try again. HTTP Code: 500

In using web-sniffer I get the following result:

Connect to 198.27.70.84 on port 443 ... ok

GET /tbe/civicrm?page=CiviCRM&q=civicrm%2Fmailchimp%2Fwebhook&reset=1&key=kasfBgoASBcb HTTP/1.1[CRLF]
Host: yourshulbythesea.org[CRLF]
Connection: close[CRLF]
User-Agent: Web-sniffer/1.1.0 (+http://web-sniffer.net/)[CRLF]
Accept-Encoding: gzip[CRLF]
Accept-Charset: ISO-8859-1,UTF-8;q=0.7,*;q=0.7[CRLF]
Cache-Control: no-cache[CRLF]
Accept-Language: de,en;q=0.7,en-us;q=0.3[CRLF]
Referer: http://web-sniffer.net/[CRLF]

The site's webhook URL and details:

https://yourshulbythesea.org/tbe/civicrm?page=CiviCRM&q=civicrm/mailchimp/webhook&reset=1&key=kasfBgoASBcb
Wordpress 4.7.2
CiviCRM  4.7.16
CiviCRM Mailchimp Extension 2.0

Any idea how to troubleshoot this further?


texts:
I am using CiviCRM(4.6.10) with Drupal (7.38) together with the civicrm_og_sync module. Until now everything worked fine:

Everytime a drupal user was created automatically a civi contact was also created. Then I deleted a user account on drupal and the corresponding contact in civi (full deletion!).

Now when I try to create a new user in drupal I get the following error:

  Datenbank-Errorcode: Cannot add or update a child row: a foreign key constraint fails (civi_db.civicrm_log, CONSTRAINT FK_civicrm_log_modified_id FOREIGN KEY (modified_id) REFERENCES civicrm_contact (id) ON DELETE CASCADE), 1452
  Zusätzliche Details:
  Array
  (
      [callback] => Array
          (
              [0] => CRM_Core_Error
              [1] => handle
          )
      [code] => -3
      [message] => DB Error: constraint violation
      [mode] => 16
      [debug_info] => INSERT INTO civicrm_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  381 , 'civicrm_contact,381' ,  374 ,  20160111141559 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (civi_db.civicrm_log, CONSTRAINT FK_civicrm_log_modified_id FOREIGN KEY (modified_id) REFERENCES civicrm_contact (id) ON DELETE CASCADE)]
      [type] => DB_Error
      [user_info] => INSERT INTO civicrm_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  381 , 'civicrm_contact,381' ,  374 ,  20160111141559 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (civi_db.civicrm_log, CONSTRAINT FK_civicrm_log_modified_id FOREIGN KEY (modified_id) REFERENCES civicrm_contact (id) ON DELETE CASCADE)]
      [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  381 , 'civicrm_contact,381' ,  374 ,  20160111141559 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (civi_db.civicrm_log, CONSTRAINT FK_civicrm_log_modified_id FOREIGN KEY (modified_id) REFERENCES civicrm_contact (id) ON DELETE CASCADE)]"]
  )

In the end the drupal user is created but not the civi contact. I looked into the tables 'civicrm_contact' and 'civicrm_log' but couldn't find anything supicious - an id or modified_id with number 381 did not exist. On the other hand I can still create a contact with the civi user-interface...

What can I do?


texts: Can I sync CiviCRM data with Raiser's Edge?

texts:
We currently use Raiser's Edge. We're thinking about handling our e-communications via Mailchimp and wondered whether we can then use CiviCRM as the back end to our online functionality and then sync it to Raiser's Edge.

Is this possible?

Thanks


texts: How to make my custom report template appear?

texts:
This is CiviCRM 4.6.22 / Drupal 7 where I used civix to copy one of the give contact reports:

  civix --copy=CRM_Report_Form_Contact_Summary generate:report MCat null

It also appears registered in the Report manager. However I cannot find and therefore not use it when I look in Reports > Contact Reports

I tried reinstalling the module, looked for clues in the log file. Any helpful advice is appreciated!


texts: How do I search for Activity Attachments?

texts:
Drupal 7.39
CiviCRM (in this case 4.6.7)

We can't find any way to search for activities with attachments.

Am I missing something obvious?

Similar to this question: Search contacts with attachments


texts: How can I import Volunteer information from a spreadsheet

texts:
CiviCRM 4.7.24
Wordpress 4.8.x
CiviVolunteer

I have installed CiviVolunteer. I have created a project which I need in order to import some basic volunteer data from a spreadsheet.

I have imported the contacts already, and have a unique ID to match them back with the rest of the data.

Now I need to import the volunteer data. There's not really too much.

From what I can glean from the pretty sparse documentation, you have to import the volunteer information as an activity. But there's no indication of what fields in the import list correspond to.

Do some of them correspond to the project I created above? Or are they their own thing?

I haven't seen any documentation about projects joining to activities and how they all link up.

Is this something i might be able to find in the CiviCRM API Explorer?

Thanks!


texts: Mosaico 1.1 - "Unexpected error talking to server" when saving template

texts:
Just installed Mosaico 1.1 for CiviCRM 5.7.2 on Drupal 7.

Tried to make a dummy template and hit the save button but received an error saying "Unexpected error talking to server - contact us!" It then cleared the image that I had inserted there.

(I followed the steps of 1) installing shoreditch, 2) installing flexmailer, 3) installing mosaico)

Any ideas on what to do?

Have tried asking on the Mosaico github and contacting the developers but no luck.

Cheers,
Josh


texts: database upgrade script failing: Call to undefined method CRM_Upgrade_Incremental_php_FourOne::getMajorMinor()

texts:
I'm trying to upgrade CiviCRM in a Joomla 3.9.26 environment from 5.25.0 to 5.37.0.
I ran the file installation, cleared the media/template_c folder, then tried to run the database upgrade script.  I get this error:
An error has occurred.
0 Call to undefined method CRM_Upgrade_Incremental_php_FourOne::getMajorMinor()

The ConfigLog file and the PHP error logs don't show this error, and the ConfigLog files don't seem to show anything related to any database upgrade script.  Also, the civicrm_domain table still shows 5.25.0 in the version column, so I don't think the update script has run at all.
I have no idea why this upgrade would be calling a 4.1 incremental upgrade script?  And I'm not sure what steps to take next to recover -- or if I just roll back to my backup. However, I will eventually need to get this upgraded!
Suggestions appreciated!
UPDATE: call stack as requested...
0 Call to undefined method CRM_Upgrade_Incremental_php_FourOne::getMajorMinor()  JROOT/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php:125
1   ()  JROOT/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php:125
2   CRM_Upgrade_Form::incrementalPhpObjectVersions()    JROOT/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php:324
3   CRM_Upgrade_Form->getRevisionSequence()     JROOT/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php:845
4   CRM_Upgrade_Form->setPreUpgradeMessage()    JROOT/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Page/Upgrade.php:108
5   CRM_Upgrade_Page_Upgrade->runIntro()    JROOT/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Page/Upgrade.php:57
6   CRM_Upgrade_Page_Upgrade->run()     JROOT/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:313
7   CRM_Core_Invoke::runItem()  JROOT/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:69
8   CRM_Core_Invoke::_invoke()  JROOT/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:36
9   CRM_Core_Invoke::invoke()   JROOT/administrator/components/com_civicrm/civicrm.php:121
10  civicrm_invoke()    JROOT/administrator/components/com_civicrm/civicrm.php:40
11  require_once()  JROOT/libraries/src/Component/ComponentHelper.php:402
12  Joomla\CMS\Component\ComponentHelper::executeComponent()    JROOT/libraries/src/Component/ComponentHelper.php:377
13  Joomla\CMS\Component\ComponentHelper::renderComponent()     JROOT/libraries/src/Application/AdministratorApplication.php:101
14  Joomla\CMS\Application\AdministratorApplication->dispatch()     JROOT/libraries/src/Application/AdministratorApplication.php:159
15  Joomla\CMS\Application\AdministratorApplication->doExecute()    JROOT/libraries/src/Application/CMSApplication.php:203
16  Joomla\CMS\Application\CMSApplication->execute()    JROOT/administrator/index.php:51


texts: Missing column headers on a custom search

texts:
CiviCRM 5.6.1
Drupal: 7.59

I have a problem with my custom search outside of core, but i was able to replicate issue on "Proximity Search" which comes in core.

Steps to reproduce:

Go to Proximity search http://example.com/civicrm/contact/search/custom?reset=1&csid=6
Modify its file "civicrm/CRM/Contact/Form/Search/Custom/Proximity.php"
Edit buildform function to add "$form->set('component_mode', 16); //Events mode", in the very end of function right after $form->assign
Run search
You will notice column headers should be missing, after adding component mode, search disregards columns headers which were set using $this->_columns


texts:
For some reason after updating to CiviCRM 5.29.1 the "Pay Later" option (which is selected) is no longer working on DarrylWPerry.com/donate
EDIT: if I turn off HTTPS/SSL protections it appears.


texts:
D6, Civi 4.6.7

I've ceated a directory profile of organisations. I can see the directory list, but when trying to 'view' the details of an organisation I get the following error:

Fatal error: Class 'CRM_Profile_Page_View' not found in /home/xxxx/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php on line 297

How I can fix this?


texts: How does one call civicrm_api3_system_check API

texts:
What are the valid parameters to pass to civicrm_api3_system_check($params)?

Passing $params = false or $params = array() causes an infinite loop despite my try catch.

../civicrm/civicrm/api/v3/System.php gives no hints

../civicrm/civicrm/api/v3/examples/System/Flush.php only shows how to use System flush


texts: iFrame CiviContribute page into another site

texts:
We have a non profit where Civi is installed and then we have a cycling event where we are asking for donations. Managed to get everything working really nicely until I tested the form, only to get an error related to the two different domains.
"Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
We can't load the requested web page. This page requires cookies to be enabled in your browser settings. Please check this setting and enable cookies (if they are not enabled). Then try again. If this error persists, contact the site administrator for assistance.Site Administrators: This error may indicate that users are accessing this page using a domain or URL other than the configured Base URL. EXAMPLE: Base URL is http://example.org, but some users are accessing the page via http://www.example.org or a domain alias like http://myotherexample.org.Error type: Could not find a valid session key."
Is there a way to allow the cycling domain to process the transaction?
Many thanks


texts: process_mailing processing addresses when called in UI but not CRON

texts:
CiviMail scheduled e-mails are not being triggered automatically through CRON.  Using the same user with the same permissions, I get the following in the log when triggered through the Scheduled Jobs user interface:

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

Full message:
Finished execution of Send Scheduled Mailings with result: Success (a:1:
{s:9:"processed";i:1;})

But when the same is triggered on CRON using CURL

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

Full message:
Finished execution of Send Scheduled Mailings with result: Success (a:1:
{s:9:"processed";i:0;}

I'm not getting any errors when I call the CRON page from the browser.  On the CiviCRM status page it shows that CRON is running.  In conclusion, the scheduled task processes address only from the user interface and not from CRON.

I am using the latest CiviCRM build (5.3.1).


texts: What is a jailed shell and should I use one for my hosted site?

texts: Say I am using a hosted site on Bluehost or a2 or another hosting platform which runs cPanel. I'm being required to use a 'jailed shell'. What is a jailed shell and should I use one? I found some documentation on jailed shells here - https://docs.cpanel.net/knowledge-base/accounts/virtfs-jailed-shell/


texts: Display the payment vehicle (cash, check,...) of a contribution in a receipt

texts:
I'm supposed to change the message template used when you wanna make a PDF receipt of a contribution. I found the template and started to modify its HTML code, unfortunately I'm not able to display the payment vehicle (cash, check,...). I tested a few tokens ({$payment_instrument} for instance) found on the internet but it didn't work. And I don't really know where I'm supposed to find all of the tokens (yes, I'm a bit of a beginner...).

Thanks !


texts: Can I remove old discount codes without affecting contribution records?

texts: We've got a fairly long list of discount codes piling up. Many of them are specific to old events and are no longer used. Can I just delete them without affecting other data in the database?


texts: Working with Individual Contact Suffixes

texts:
I'm having a horrible time with individual contact suffixes,  Struggling with input, display and reports having to do with suffixes.  I'm about to create a new custom text field for suffix(2) and abandon the original suffix field.  Whether I can modify the standard displays to accommodate change field change, I don't know.  In the old days there would quickly be a discussion about something like this on this board, frequently ending up with discovering the system was just fine and I needed to look at the issue a different way.

Relevant previous thread - found others with this unresolved issue on this forum, but could not post a general reply, seems to be blocked:
https://forum.civicrm.org/index.php?topic=10948.msg47111#msg47111

My specific issue is that for activists that they may have multiple suffixes.  John Smith II may be an RN and also MSW.  So there are many many possible combinations.  In our case a text field may work better.  However, I entered all the combinations we've run across so far, afraid of the data coming in from spreadsheets, so changed the values to the same as the dropdown display.  The Suffix appears OK on the view / edit, but on reports just shows up as a 0.

Have others run into this issue - suggestions?


texts: Content Views in Wordpress: Creating Newsletter/Event Archive

texts:
I'm trying to create a custom start page with content views and data processors. This page will contain a newsletter archive and selected events besides the wordpress posts. As I understand I need the content views pro version to combine different content types into one list? Can I also filter the events by membership type/anonymous user?
Right now I'm struggling to set up the newsletter or event view. Is it possible to set fields as title and content of the "post"? I.e. so that the "Veranstaltungstitel" Lauftraining is the title and the "Beschreibung" is the content so that the events are formatted the same as a post? See the two images as a comparison. Is it then possible to direct the user to the event page on a click on the title?

If that's not possible (even in the pro version of content view) I might be able to write myself a plugin that does that, but I would like to avoid it.


texts: CiviCRM 4.7.8 error after upgrade on eWay Recurring

texts:
I have just upgraded from 4.6.18 to 4.7.8. The upgrade was successful but when I try to open CiviCRM menu items I get the following error:

  Fatal error: require_once(): Failed opening required
  'CRM/Core/Payment/Ewayrecurring.php'
  (include_path='.:/var/www/test/sites/all/modules/civicrm:/var/www/test/sites/all/modules/civicrm/packages:.:/var/www/test/sites/all/modules/civicrm:/var/www/test/sites/all/modules/civicrm/packages:/var/www/test/sites/all/modules/civicrm/vendor/tecnickcom:/var/www/test/sites/all/modules/civicrm/vendor/phpseclib/phpseclib/phpseclib:.:/usr/share/php:/usr/share/pear')
  in /var/www/test/sites/all/modules/civicrm/Civi/Payment/System.php on
  line 59

I can't find reference to this anywhere. Has anyone else seen this issue?

When I reverted to CiviCRM 4.6.18 and then attempted to disable eWayRecurring I got this error:

I have reverted to Civicrm 4.6.18 and when I attempt to disable eWayRecurring extension I get the following error:

  Fatal error: require_once(): Failed opening required
  'CRM/Core/Payment/Ewayrecurring.php'
  (include_path='/var/www/test/sites/default/files/civicrm/extensions/com.pogstone.contenttokens/:/var/www/test/sites/default/files/civicrm/extensions/com.cividesk.helptab/:/var/www/test/sites/default/files/civicrm/extensions/uk.co.vedaconsulting.mosaico-1.0-alpha4/:/var/www/test/sites/default/files/civicrm/extensions/com.pesc.sparkpost-1.1/:/var/www/test/sites/default/files/civicrm/extensions/coop.palantetech.nodrilldown-master/:/var/www/test/sites/default/files/civicrm/extensions/uk.co.vedaconsulting.mailchimp/:/var/www/test/sites/default/files/civicrm/extensions/org.civicoop.membershippayment-master/:/var/www/test/sites/default/files/civicrm/extensions/nz.co.fuzion.extendedreport/:.:/var/www/test/sites/all/modules/civicrm:/var/www/test/sites/all/modules/civicrm/packages:.:/var/www/test/sites/all/modules/civicrm:/var/www/test/sites/all/modules/civicrm/packages:/var/www/test/sites/all/modules/civicrm/vendor/tecnickcom:/var/www/test/si
  in /var/www/test/sites/all/modules/civicrm/Civi/Payment/System.php on
  line 52

Any help would be appreciated.

Regards
Martin Fuggle


texts: In the reports section, I see that I can change and adjust default reports. Is there a way for me to build a report entirely from scratch?


texts: How to add options in autocomplete contact search options?

texts:
We have contacts with the same First and Last Names. It is hard to identify person when we use Quick Search or add relationships. And default options doesn't help to identify person aswell. Is there any way how can we add additional fields (e.g. Birth Date) into autocomplete contact search options?

We are using CiviCRM 4.7.14 and wordpress.

Thanks in advance.


texts: ngChange event fired twice when using multi-select with crmUiSelect

texts:
I'm trying to use CiviCRM's crmUiSelect AngularJS directive to create a select2 element in a form. I want to call a function in my controller when the user changes this element, so I'm using the ngChange directive. But each change is firing two calls to this function.

Here's a screenshot of the element, with the console logging below, after I've made one selection.

This is my controller code:

$scope.options = [
  {"value": "foo", "label": "Foo"},
  {"value": "bar", "label": "Bar"},
  {"value": "baz", "label": "Baz"},
  {"value": "bat", "label": "Bat"}
];

$scope.log = function (value) {
  console.log(value);
};

and my template code:

<select
  crm-ui-select="{allowClear: true}"
  ng-model="myVar"
  ng-change="log(myVar)"
  multiple="multiple"
  class="big"
>
  <option ng-repeat="option in options" value="{{option.value}}">
    {{option.label}}
  </option>
</select>

How can I get the event to fire once instead of twice?

Somewhat frustratingly, the event is fired only once if I remove multiple="multiple" or if I remove the crm-ui-select directive. But I really do want a select2 mtuli-select here.


texts: Does the Stripe extension process payments for companies based in Spain?

texts: I have a client running Drupal 7.58 and CiviCRM 4.7.19 that I would like to install the Stripe extension for. Stripe assures me that they process payments for merchants based in Spain, but the Civi documentation only says USA CA and UK. Stripe suggested that I check with the extension maintainers to make sure that it will work for merchants based in Spain. Anybody that can give a definitive answer on this one?


texts:
I'm building a custom search and I would like it to have a default sort on (order by) a specific field other than the first field in the list. How can I provide a default sort field?

This stackexchange answer's method doesn't seem to be valid anymore, as it seems the $sort variable is now a non-empty object on initial load of my custom search:

How to provide a default sort on a custom search?

Any way to set a default sort column with the newer version of the code?


texts: Event Fees not loading when registering in back-end

texts:
Recently upgraded a site to 5.2.1 in WordPress 4.9.6. When the user tries to register a event participant in the back-end the fee selections price set does not load after the event is selected. All works fine on front end pages and if you edit an existing registration you are able to change the fee selections.

Checked another site with the same setup and the results are the same.

The results are the same if you try from the contact record either using the register button or the submit CC payment with registration button.

Do not see anything in the CiviCRM logs.

Not sure where to look next. Any thoughts would be appreciated.

Thanks


texts: Delayed processing of recurring monthly membership using PayPal

texts:
We use PayPal to process payments for memberships which allow our users special access to our public website.  We recently started a monthly membership with auto-renew, and there seems to be a problem:

PayPal informs me that they process new recurring payment profiles in batches, often a considerable time after the profile has been created.  This means that our new members do not get immediate access to our website, and also the Civi confirmation page that should come after payment, is not delivered to their web browser.

PayPal support has looked at the API log, and said that if I added the following variables, then the first payment would be processed immediately:

1) Specify the variable “Initial Amount”: INITAMT.

2) Specify the "profile start date" one month later: PROFILESTARTDATE

I don't think I should go in and mess with the payment processor api code myself.  Has anyone else encountered this issue, or have ideas on a workaround?

PayPal Payments Pro // CiviCRM 4.6.10 // Drupal 7.39


texts:
I am trying to change the font and the headings in theme 2016.

Do I need to edit the code?

The code says font-family sans-serif, I want it to be times-new-roman.


texts: Membership Pay later and Activity Renewal

texts:
I don't understand why, for a first membership, when a member chooses the "Pay later" option s.he gets a new activity "Renewal" recorded once the payment is manually added by the admin but not if s.he just pays live with credit card?
It's not a renewal and I don't want this activity to be added. This is mistaking the reports for those who are really renewing their membership and need to be separately identified for backoffice purpose.
I don't have a special CiviRule that would involve this behaviour so I guess it's build in CiviCRM.
I'm using CiviCRM 5.21.0 on Drupal 7.67
How could I fix this?
regards,
Guillaume
EDIT 1:
Activity Renewal is "Renouvellement d'adhésion". It comes automatically every time I use the pay later option. I don't get :-/

EDIT 2:
I've tried on a different CiviCRM/Drupal website and it ends the same. It creates an unwanted Renewal activity
EDIT 3: After a step-by-step comparison with the demo, it appears that when registering a member, CiviCRM creates an "Online or offline membership signup." activity that I don't see on the demo instead it creates a Pending membership coloured in red that is deleted after a payment. And when entering a contribution, it logically adds a "Renewal" activity. So now, it's more about why is CiviCRM creating this first membership and no more why I get a renewal activity. little step forward...


texts: CiviCRM & Quickbooks - What's the best way to achieve membership type accounting coding?

texts:
Been looking at Justin @ Agilewares fantastic QuickBooks extension and I had a question around our specific scenario and I'm not entirely sure if (or how) it can achieve what we need. Any suggestions would be greatly appreciated.
We have 5 different paid membership tiers that each has its own individual code in Quickbooks (Bronze to Diamond). Does the extension have the granular functionality to people able to code membership levels, vs just 'member dues'.
Same with donations, we have different donations types with different codes. Can these be aligned in CiviCRM -> Quickbooks?
Sorry if basic questions, new to the accounting side of things.
Thanks!


texts: Public listing of newsletters in Joomla?

texts:
On a Joomla site we would like to allow the public to see a list of newsletters sent through CiviMail. Subject of email would be the link text, body of newsletter including images would be displayed as a site page when clicked. So, similar to a Drupal view like in How can I show users the mailings they have been sent?

What's a good way to do this?


texts: When removing a group from a contact I get: Error - DB Constraint Violation - GroupContact, get API

texts:
[copied from https://issues.civicrm.org/jira/browse/CRM-20711
noted on CiviCRM version 4.7.27]

In the Contact record, when I try to remove or delete a contact from a group they've already been added to, I receive this error:

DB Constraint Violation - group_id should possibly be marked as mandatory for GroupContact,get API. If so, please raise a bug report.

I am able to remove a contact from a group when in the Group's list of contacts view, so this isn't critical. Posting in case it happens for others.


texts: Send fee type to Authorize.net along payment

texts:
I need to assign a unique code to each fee label for accounting purposes. I can do that using price sets and use the fee type to add the code. Is it possible to see the fee type information in the Authorize.net report? knowing that one transaction can have multiple fee types.
Thanks for any guidance.


texts: Webform Civicrm Custom Fields across Multiple Contacts not working in Drupal 7 and Drupal 8

texts:
I created a custom fieldset in CiviCRM, with the following field types,

File Field
Two Date Fields
Two Country Fields

With a "Tab with table" style
A webform with CiviCRM Integration and multiple contacts were created and the custom fields on contact 2, contact 3, etc were enabled.
I created a webform submission. The custom fields on contact 2,3+ aren't added to CiviCRM, only on Contact 1.  Please help, I have a very important system that I'm working on for an immigration assistance NPO, and would appreciate help on what might be causing this
Thanks


texts: What are the files and fields in CiviCRM?

texts:
An organization I volunteer for is considering this software solution. I need to see the files and fields in those files to see how they match to our current system. A brief description of the purpose of the file would be appreciated also. We have about 70,000 records. I'm a software developer, so detail would be appreciated. A large percentage of our records are imported from a voter file provided by the Secretary of State, so voter info needs to be captured. These would need to be matched to the current file and data replaced.

I'm also interested in

match/merge of duplicate records;
capabilities of selecting subsets of contact files based on things like member type, zip code, has email address (or not);
import and export capabilities;
custom fields - how easy to add and maintain?.

No doubt I'll have more questions after I learn more.


texts: simple way to import membership and contributions together

texts: What is the simplest way to import Membership information and corresponding contribution information together from .CSV files?


texts:
Drupal 7.59 / Civi 4.7.27

I use Views extensively, and would like to add https://www.drupal.org/project/views_data_export_pdf module.

As per the Module documentation, a prerequisite is the installation of wkhtmltopdf Library (https://wkhtmltopdf.org/), which should result in the following structure :

sites/all/libraries/phpwkhtmltopdf
sites/all/libraries/phpwkhtmltopdf/scr
sites/all/libraries/phpwkhtmltopdf/scr/Pdf.php

But I don't find those files in the wkhtmltox-0.12.4_linux-generic-amd64.tar.xz dowload, especially no Pdf.php

I am not a programmer, and thus not familiar with Libraries installation : any help would be welcome


texts: Recurring Paypal Contributions are showing (Pending Incomplete)

texts:
We are on Civi 4.7.29 and Wordpress 4.9.4

Today I noticed about 20 transactions with the status Pending Incomplete.  They are all intended to be recurring.   I found out that we are getting notifications from Paypal on everyone of these transactions and some of these people confirmed the payment was a success on their end.  But it is not updating their memberships in Civi and it is not sending them a receipt from civi or recording it as a completed contribution.

Does anyone know where I should start with resolving this?  I did find several other posts related to this issue, but I did not see an answer with any of them.

We confirmed that payments go through properly with no issues, if it's a single/non-recurring payment.

thank you

***Edit****

I just noticed that when trying to make a recurring payment with my credit card instead of paypal I get this error message

DPRP is disabled. DPRP is disabled for this merchant.


texts:
I'm looking at starting up with CiviCRM Spark. I'm wondering whether Spark include Calendar and Case Management?

Thanks


texts: Is it safe to delete job log files? I currently have 504,742 lines in my civicrm_job_log table, which comes to 223MB.


texts:
We are attempting a CiviCRM Member import for a client on CiviCRM 4.6.12.
The import starts to run but then fails saying no memberships were created.

Nothing is logged to the CiviCRM log file.
The .csv file detailing the import errors says for ecah line 'DB Constraint Violation - possibly membership_type_id should possibly be marked as mandatory for this API. If so, please raise a bug report'

The client says there have been no reported upgrade errors and each member record in the Db has a valid membership type ID.

Has anyone had a similar issue?

Oliver


texts: "Membership can not be used as a Result Column for profile searches" - why not?

texts: What can be done to make Membership - Membership Status in particular - a Result Column for profile searches? I want to be able to show Status in a Search View.


texts: templates_c cache files not being deleted

texts:
This is a problem I've had for three or four years, but never solved. I send a monthly mailing to about 50k contacts using CiviMail. Each mailing is scheduled using the standard CiviCRM job scheduling. All works fine except that during the sending, the templates_c/en_GB folder grows to about 30GB or more, and has to be emptied manually (either from the command line or using the the CiviCRM Clean Up Caches page) to stop the server from running out of disk space. The files and directories which are being created under templates_c/en_GB/ all seem to have plausible permissions (read and write for the Apache user, read only for everyone else), so I don't understand why they're not being cleared.

Can anyone suggest anywhere to start looking for a solution? Thanks.

This happens with the following set-up, but I have had the problem for a long time, with all previous versions as well.

CiviCRM 4.7.19
Joomla 3.7.2
php 7.0.19
MySQL 5.6.36


texts:
I've cloned a website to make it a sandbox and I changed the site key in civicrm.settings.php following this post.
My question is: do I also need to change this value in some table in the database?


texts: how to manage documentation of past events (add files, links, summary, etc)

texts:
so we are using civicrm for events, webinars etc. we want to move the documentation of the events also to civicrm (photos, presentations, attendees, summary, links etc.)
for contacts its easy with the activities tabs. is there a way to link activities to (past) events. or do you know a way how to do documentation for events in civicrm?
thanks a lot in advance


texts: My cronjob fails to run my Civimail queue. What am I missing here?

texts:
This invocation now returns a result code of 0.
And still I see no evidence that it ran my civimail,
in the browser UI, at /civicrm/mailing/browse/unscheduled,
nor in the logs at /civicrm/admin/joblog, nor in my inbox.

I've been struggling with this issue for a moment now.
Sorting through these issues, to get to this point is documented here:
CiviMail cron job unable to find: civicrm.config.php, built with: roundearth/drupal-civicrm-project

/usr/bin/nice -n19 /usr/bin/php \
    -d require /opt/local/my_client/drupal/vendor/autoload.php \
    /opt/local/my_client/drupal/vendor/civicrm/cv/bin/cv api job.execute \
    --cwd=/opt/local/my_client/drupal --user=mailprocess

My script now reads:

#!/bin/bash
set -x

CMD=$1
CWD='/opt/local/my_client/drupal'
CV="${CWD}/vendor/civicrm/cv/bin/cv"
CIVIMAIL_USER='mailprocess'
requirements="-d require ${CWD}/vendor/autoload.php"
PHP="/usr/bin/nice -n19 /usr/bin/php"
ARGS="--cwd=${CWD} --user=${CIVIMAIL_USER}"

cd ${CWD}; ${PHP} ${requirements} ${CV} api job.execute ${ARGS}
exit "$?"


texts: How do i list upcoming events publicly using CiviCRM in Wordpress

texts:
I've created a couple of events and a public info pages for them in Wordpress

How do i create a page / public report that lists all these upcoming events?

Cheers
phil


texts: CiviCRM installer reports Warning: CRM_Core_ClassLoader message

texts:
I'm trying to set up a new CiviCRM install (4.7.24 plus Drupal 7.56) on a subdomain but I keep getting an error message.

I tried to install using the Drupal 'add a module' but after about a minute it just brings up a blank screen, and when I check the files online, nothing has been uploaded.

Then I tried to (slowly) ftp the files, but then when I run .../sites/all/modules/civicrm/install/index.php I get an error message along the lines of:

Warning: CRM_Core_ClassLoader::require_once(./vendor/autoload.php) [crm-core-classloader.require-once]: failed to open stream: No such file or directory in /var/sites/t//public_html/sites/all/modules/civicrm/CRM/Core/ClassLoader.php on line 107

Fatal error: CRM_Core_ClassLoader::require_once() [function.require]: Failed opening required './vendor/autoload.php' (include_path='.:/usr/local/lib/php') in /var/sites/t//public_html/sites/all/modules/civicrm/CRM/Core/ClassLoader.php on line 107

I'm not sure what I'm missing - is it because I'm installing on a subdomain? Can I get around this?


texts: The public facing "Payment Options" are hidden when using shortcode on page

texts:
We are using a contribution form and are embedding it with a shortcode in a Wordpress page.
The issue we are facing is, that the "Payment Options" section is hidden, when the form is accessed via the page URL.
The "Payment Options" show when the form is accessed via the CiviCRM link and it also shows, when I am logged in and access the form via the page URL.
Has anyone experienced this as well or know why this happens?

We are using WordPress 5.4.2 and CiviCRM 5.26.2
Here is the shortcode we use:
[civicrm component="contribution" id="22" action="register" mode="live" hijack="0"]
And here are two links 1) page URL 2) civicrm link

https://www.gstcouncil.org/sttp-exam/register-sttp-exam/ (doesn't show "Payment Options")
https://www.gstcouncil.org/civicrm?civiwp=CiviCRM&q=civicrm%2Fcontribute%2Ftransact&reset=1&id=22 (shows "Payment Options")


texts: Error when upgrading from 4.7.16 to 4.7.20

texts:
I want to upgrade my site (Drupal 7.54 to 7.55, then civicrm 4.7.16 to 4.7.20).

No problem on Drupal upgrade.

But for CiviCRM, when I run mysite/drupal/?q=civicrm/upgrade&reset=1 (after having replaced sites/all/civicrm directory content) :

upgrade to 4.7.17 runs OK
upgrade to 4.7.18 fails with the following error :

(BTW, civicrm_case table is empty on my site)


texts: Wordpress profile will allow view but not edit when logged in

texts:
Won't work on my system (4.7.10) and replicated on Wordpress sandbox.

I've created a very simple profile: last name & first name.
All fields are expose publicly, searchable, results column etc
Profile ticked "include profile edit links in search results?

Using link from profile "use - listings mode" while logged in as admin.
Ie "http://wpmaster.demo.civicrm.org/civicrm/?page=CiviCRM&q=civicrm/profile&gid=14&reset=1"

Search works fine but listing only has view option - no edit

Same when using [civicrm component="profile" gid="68" mode="search" hijack="0"]

Am I missing something?
Same setup works fine on Drupal site


texts: Why is CiviPetition showing me the contents of a random activity

texts:
I've set up CiviPetition. Just to test, I've added Subject and Details to an activity profile as well as a field from a custom fieldset for this petition.
When I visit the Sign page (as a logged in user) I see that the subject and details are pre-populated with values from some random activity (not even an activity of the petition type, but at least it is one that belongs to my contact record). Why is that? Why is the form not blank?


texts:
I was hoping to find an extension that would correct the capitalization of first last names - for example, if someone entered a name in all lowercase or all uppercase, it would change the first letter of the name to uppercase.

It looks like the Capitalisation Corrector does just this. https://civicrm.org/extensions/capitalisation-corrector. But I can't find it as a scheduled job, or in the extension directory. I tried using the Normalise the Data extension but that does not work for my purposes.

I am currently using CiviCRM 5.18.2 with WordPress. Does the Capitalisation Corrector work with WordPress? Is there another way I can install it?


texts: How do I get my iCal feed to show past events?

texts:
How do I get the iCal feed that displays as html at
/civicrm/?page=CiviCRM&q=civicrm/event/ical&reset=1&list=1&html=1
or as a feed at /civicrm?page=CiviCRM&q=civicrm/event/ical&reset=1&list=1 to show past events?

Using Wordpress


texts:
Since yesterday I'am getting the following error when I save contact:

Notice: Undefined variable: ret in CRM_Utils_Geocode_Yahoo::format() (regel 155 van /sites/all/modules/civicrm/CRM/Utils/Geocode/Yahoo.php).
Notice: Undefined variable: ret in CRM_Utils_Geocode_Yahoo::format() (regel 156 van /sites/all/modules/civicrm/CRM/Utils/Geocode/Yahoo.php).


texts: PROBLEM>> The Profile Redirect URL is Limited to One Setting for Multilingual Site

texts:
I have not found a solution to this as of yet and I scoured through here first with no answers.  Anyways, I have a multilingual Wordpress website (www.gcmf.ca) using the WPML plugin to manage between English (default) and French.  I am using CiviCRM profile forms to "walk" the logged in members through a renewal process. When they fill out the first page and click the Save button, it redirects them to the next page to fill out.  This works beautifully for English!

The problem happens when French is selected and they save the form. Since there can only be one URL entered in that Advanced field, it takes them to the next page, but it's in English.  They have to manually select French again. The path for English looks something like… “https://gcmf.ca/some-web-page/” and for French… “https://gcmf.ca/fr/some-web-page/”.  So you can see my dilemma.

Does anyone have ANY suggestions?  I'm going to  ask the users over at WPML to see if a language can be set by other means rather than using a language specifier in the URL.  That could solve the problem.  Also, from the CiviCRM side, I am wondering if there is a work around even if it involves a little code behind.  I am not a PHP programmer though and my skills in that area are very limited.

Ideally for the future, a nice feature would be to allow multiple values for the two redirect fields based on the language just like you can for the individual profile field labels and help text.

Any help would be GREATLY appreciated!

Kindly,
Rick Monyer


texts: Best Practice for CiviEvent using Webform Integration?

texts:
I have a complex registration process to have Parent + Children (1, 2, or 3) registered by an "Administrator", including Contribution Amount calculation (and on line payment (if possible)).

I use Webform Integration to manage the registration phase and the Contribution Amount calculation ; and I am quite happy with this (amazingly more than expected : I strongly recommend !).

But I am not sure that I fully understand how this Webform process integrates with CiviEvent : for instance : how to integrate :
- Event location and date (and map),
- Confirmation Page,
- Confirmation email,
- ...
which are defined in the Event definition ?

Is there a process Event to Webform and back ?


texts:
Drupal 7.69, Civi 5.23.0

A colleague just had an issue with CiviMail. She was trying to send a mail to Group "Volunteers" but exclude people in Group "Garden Volunteers". Instead of saying the number of recipients, it just froze on "Estimating..."

It still says estimating even if saving the draft and exiting.

When we try to submit the mailing, it gives a DB Syntax error.

I checked the Drupal error log and saw two relevant errors.

Pastebin link 1 | Link 2

I ended up fixing this by just creating a new mailing with the same settings and it worked fine, but would love to work out why the initial issue happened so I Can fix it pre-emptively in case it happens again in the future.

Flushing cache did not solve it.

Cheers!

--

EDIT It's happened again, looks like it's just an issue with one particular smart group. We've definitely mailed to this smart group in the past though.

Someone previously asked what I see when clicking on the spanner icon:


texts: How do I change the address on system workflow messages?

texts: Hi "I need to change the address that is sent out on our invoices. These are in the system workflow messages and although I didn't write the code for them, I believe they may have been written in as domain address. How do I update that address please?


texts:
I have migrated a site from:

Unknown OS (Was through BlueHost)
cPanel 11.52.6 (build 1)
Apache (v. 2.2.31)
PHP (v. 5.2.17)
MySQL (v. 5.5.42-37.1)
WordPress (v. 4.5.3)
CiviCRM (v. 4.6.9)

To:

CentOS release 6.8
cPanel 56.0 (build 25)
Apache (v. 2.4.18)
PHP (v. 5.6.22)
MySQL (v. 5.6.30)
WordPress (v. 4.5.3)
CiviCRM (v. 4.6.19)

I have followed the documentation found at https://wiki.civicrm.org/confluence/display/CRMDOC/Moving+an+Existing+Installation+to+a+New+Server+or+Location and have managed to get CiviCRM to run but with a hiccup. The initial loading of the CiviCRM dashboard takes a very long time, sometimes 5+ minutes, but after the initial load everything is incredibly fast and flawless. Seems to happen only when it is trying to establish a new session as if I clear cache and try to get back to the CiviCRM dashboard it reproduces the issue but the issue will not reproduce as long as the session isn't reset like logging out or clearing cache. I have also noticed that if you sit and let it load that the dashlets then will not load and just shows the spinning loading image and never actually loads but I am guessing these two issues are related.

I have also followed the recommendations found here: civicrm dashboard won't load and have not been able to fix it.

Also I have tried many things like clearing the cache, deleting CiviCRM and re-installing then importing the database and then using the CiviCRM database update utility and seems like nothing is solving the issue.

Snooping around in the Apache, PHP, MySQL, & CiviCRM log files I found only one error being reported that I know is related to the dashboard hanging at public_html/wp-content/plugins/files/civicrm/ConfigAndLog/ here is the pastebin: http://pastebin.com/TRTg0sHx

I feel as if I have tried everything and am out of ideas, any help as what to do to get this resolved would be greatly appreciated.

EDIT: Ignore "UPDATE (7/12/2016)", found out that this was a separate issue, sorry for the confusion.

UPDATE (7/12/2016):
Decided to try a fresh cPanel account, fresh WordPress, and fresh CiviCRM installtion and only running the bare basics to see if the problem would still exist and it does. But on the new install these errors come up:

Warning: session_start(): open(/tmp/sess_c279ba138c878520b23fb7085f54a267, O_RDWR) failed: Permission denied (13) in /home/civicrmtest/public_html/wp-content/plugins/civicrm/civicrm.php on line 282

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/civicrmtest/public_html/wp-content/plugins/civicrm/civicrm.php:282) in /home/civicrmtest/public_html/wp-content/plugins/civicrm/civicrm.php on line 282

Warning: Cannot modify header information - headers already sent by (output started at /home/civicrmtest/public_html/wp-content/plugins/civicrm/civicrm.php:282) in /home/civicrmtest/public_html/wp-includes/option.php on line 823

Warning: Cannot modify header information - headers already sent by (output started at /home/civicrmtest/public_html/wp-content/plugins/civicrm/civicrm.php:282) in /home/civicrmtest/public_html/wp-includes/option.php on line 824

The first two errors above show and then the dashboard takes forever to load and then once the dashboard loads the last two errors display. Also the dashlets do not load properly afterwards and keep the "Loading..." message with the twirling image.


texts: How do I configure a phone number format?

texts: Where do I set a phone number format (like date or address options at Administer/Localization)? Thank you.  I'm on rev 4.6.6


texts: Need to be able to update a Custom Data but nothing else

texts:
Before posting I search a lot and try few combinations without success...

What I would like to put in place is the following scenario : create 2 user groups, one that is able to create new contact and edit all fields (let's say AUTHOR), one that is able to view all contacts and can update only one custom data but nothing else (let's say COMMENTATOR).

Here is how I tried to manage that:

In Drupal role management, I have deactivated CiviCRM: access all custom data option for COMMENTATOR role.
I have mapped COMMENTATOR Drupal role to COMMENTATOR CiviCRM group thanks to CiviGroup Roles Sync module.
In CiviCRM Administer/USers and permissions/Permissions (Access Control), I have created COMMENTATOR ACL role and then have made the link with COMMENTATOR group.
In Manage ACLs, I had a new ACL for Role COMMENTATOR, with operation Edit on a set of custom data fields linked to Custom Data COMMENT (properly created before).

When I log with an account with COMMENTATOR role, I can see my list of contact and can't update anything, even not the COMMENT Custom Data (but I see it)...

My first question is : is it possible to do in CiviCRM what I'm trying to do ?
If so, obviously I missed something... What am I doing wrong ?

Thanks in advance for your help and advices !

P.S : I work with CiviCRM 4.6.10 on Drupal 6 and, unfortunately, I can only have access to the UI (no access to database or PHP files...)


texts: Support for crypto-currencies like Bitcoin

texts:
Our organization would like to start taking donations in the form of bitcoin.  Is there any functionality out there I can use to integrate this within a CiviCRM-generated contribution page?  Thanks for any help.

Using 4.7.29 on Wordpress 4.9.2


texts:
When doing a contact search using tags from search builder Civi throws DB syntax error, this was working before until Civi upgraded to 5.35.1

Error:
SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n
               FROM civicrm_contact contact_a    LEFT JOIN civicrm_entity_tag `civicrm_entity_tag-60788273efd52` ON ( `civicrm_entity_tag-60788273efd52`.entity_id = contact_a.id  AND `civicrm_entity_tag-60788273efd52`.entity_table = &#039;civicrm_contact&#039;)  \n
              WHERE  (  ( `civicrm_entity_tag-60788273efd52`.tag_id IN (  ) )  )  AND ( 1 ) AND (contact_a.is_deleted = 0) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near &#039;) )  )  AND ( 1 ) AND (contact_a.is_deleted = 0)&#039; at line 3]
        &quot;&quot;&quot;


texts: Edit own activities created for visible contacts

texts:
We have a requirement to allow authenticated users to add activities to any contact in our system, while at the same time, not allowing them to edit the basic contact information about some of the contacts. By enabling the "View all activities (for visible contacts)" permission, and permissioning using ACLs to edit some contacts and view others, users are able to create activities. However, when viewing a submitted activity, they are unable to edit it (even though they entered it). Is there a simple way to allow users to edit the activities they created?

We're using Drupal 7 and CiviCRM 4.7.4


texts:
I am wondering if anyone knows of a social media extention that allows you to integrate the public social media profiles and activities (wheter they follow you or not) of your contacts with your databases.
Best wishes, Romina


texts: Why can't I set up a repeating scheduled reminder with an absolute date?

texts:
I had a reminder set up that simply sent an email to people on a given date who registered for a forthcoming event using the 'pay later' option, reminding them that they need to pay. All good.

I then wanted to change the reminder so that it repeated every two weeks after that given date until two weeks after the event start date. But CiviCRM won't let me set a repeating pattern for a reminder that uses an absolute data. Or rather it does let me set up the repeating pattern, but then simply doesn't save that edit.

I can't see any good reason why I might not be able to set up a reminder that sends an email on (for example) the 1st of January, and repeats every two weeks until an event start date.

Which leads me to think that this is a bug. I've tested it on my live site (WP and Civi 4.6.21) and on http://wpmaster.demo.civicrm.org

The documentation for 4.7 (https://docs.civicrm.org/user/en/stable/email/scheduled-reminders/) makes no mention, which further makes me think this is a bug:

  Choose when to send the reminder. This can be a set date or an amount of time before or after the start or end of your chosen entity.
  Check the Repeat box if you want to send this reminder more than once to the same group of people. This gives you choices about the interval of repetition and when the repetition should end.


texts: joomla front end payment process different to back end test drive process

texts:
Using CiviCRM v4.7 under Joomla v3.5

Am developing a payment extension (type notify) which is all but working when I test the contribution page on the back end: user is transferred to goCardless site for completion of payment details and then returned to a success url.

But in the front end using the same contribution page from a Joomla menu item the behaviour is different:

no choice is given for payment processor

From further research I notice the the table 'civicrm_contribution_page' shows associated payment processors ('payment_processor'). While I have checked 2 payment processors with id's 25, 26 (test), 27 and 28 (test) this field in the table 'civicrm_contribution_page' shows '2527'

Maybe this has something to do with it?


texts: How can I search contacts and run a report of contacts with no activity

texts: I'm struggling to find a list of conatcts with no activity records, could someone help me on how to achieve this?


texts: Search builder "not empty" "not null" question

texts:
I'm using CiviCRM to (in part) manage a large group of translation volunteers for our organisation. I've got everything set up quite nicely, using custom fields and groups to help our staff manage translators able to work in different languages, know whether they have already had a translation requested, etc. I've got the various smart groups set up as menu items, so other staff can quickly see which translators are available in which languages, which are occupied, etc.

We have a custom date field for "date finished last translation", so staff know if a translator has recently finished a translation. One thing I'd like that I can't work out is how to list this date field in the smart group search. At the moment that search displays their name, email, and their language. However, whenever I add the "date finished last translation" field as "is not empty" or "is not null" it returns no contacts, even though I know there are contacts who have that field completed. If we get it working, staff will be able to easily see who has most recently completed a translation, so not ask them again.