texts: outbound email settings failure to send test message

texts:
Failed to connect to smtp.tipping.org.au:25 [SMTP: Failed to connect
  socket: Connection timed out (code: -1, response: )].

WE have an internal mail server. Can resolve externally. Requires username and password authentication.

Tried most things we can think of to set up outbound email but get the above error message after sending test message

Have tried using mail(), appears to send test message successfully, but never received.

Grateful for advice on how we might correct outbound email settings.


texts: Preventing slow performance with smart groups

texts: After doing some research (Capacity Planning), it appears as if Civi slows down when there are a lot of smart groups or if the smart groups are children of other groups.  What should be some good practices to put in place so that the performance/speed of Civi isn't dramatically impacted by a large number of smart groups?  Thanks.


texts: Is there a way to integrate CiviCRM with Magento?

texts: We're looking to replace MailChimp in our organisation as a number of people are questioning the cost.  One area we're using heavily is integration with Magento - automatically emailing abandoned carts, sign up to mailing list as part of checkout process, that sort of thing.  Is there a way to get this functionality in CiviCRM?


texts: Admin > system settings unavailable after wordpress database import

texts: Part of my civicrm admin area and front-end forms are missing after import of wordpress database. I can see my contributions dashboard for example, but not the manage contribution pages section or any of the Administer area, so I cannot check systems setting > resource urls, or cleanup cache etc. This means also that my forms are missing on the front end. I have reset my WP database and Civicrm database from a couple of days ago and it hasn't made any difference. Any ideas how I can fix this?


texts: Mail not send if preferred_mail_format is NULL

texts:
I had some contacts who complain of not receiving mailings.
In communication preferences, email formats were 'both' for all contacts.
Quite by chance, I went to look in the log file, where there were messages:

  CiviMail will not send an empty email body, Skipping: xxxxx

After having researched this message in the php code, I analyzed CRM/Mailing/BAO/Mailing.php and saw that the body of the message is deleted if $contact['preferred_mail_format'] is neither Both, Text or HTML.

I went in the database, and for all contacts who did not receive the mailings, I've seen that the preferred_mail_format column contained NULL.

I have corrected by hand and all mails are gone.

I wonder if we should not:
 - Or, if preferred_mail_format is neither Both, Text or HTML, put a mail contains in a default format (Text, Html,?)
 - Or, when calculating the number of recipients (in the mailing of the editorial page), display a warning indicating the potential problems.

Regards.


texts: How to tag a contact when importing possible duplicates

texts:
I want to import a list of participants that attended an event and tag them and put them in a group.  Many of the names are already in the system so it doesn't import them based on the dedupe rule of names/emails. But I still want the existing names to be tagged and put in a specific group. I have the list of those not imported, how do I tag them and put them in a specific group for emailing purposes?

thanks


texts: What could $civicrm_root setting in civicrm.settings.php appears ignored?

texts:
I'm running 4.7.27 and regardless of what I set the $civicrm_root to, the hints in resource URL and file path setting pages give quite unrelated values for civicrm.root. I am also unable to set the resource URL to anything but the prefilled value (editing it and submitting does nothing).

Consequently it looks like some override is at work. However, I've checked the civicrm.settings.php many times and I'm unable to find such an override.

What could be causing this? Everything displays fine, except for loading of the CKEditor js-files. But the fact that editing civicrm.settings.php doesn't do anything scares me. I've verified that the file is indeed the correct one (removing it breaks the site), and that even removing the $civicrm_root entirely does nothing.

From the settings:

global $civicrm_root;

$civicrm_root = '/foo/www/sites/abc.foo.se/current/web/app/plugins/civicrm/civicrm/';
if (!defined('CIVICRM_TEMPLATE_COMPILEDIR')) {
   define( 'CIVICRM_TEMPLATE_COMPILEDIR', '/foo/www/sites/abc.foo.se/shared/uploads/civicrm/templates_c/');
}


texts: Installing Webform CiviCRM from an Installation Profile

texts:
The background is that I have an installation profile that installs certain Drupal modules and CiviCRM. The list of module dependencies goes in my profile's .info file. However if I include webform_civcirm the installation fails. The failure seems to be because CiviCRM has not been installed yet:

[ok]
Starting Drupal installation. This takes a while. Consider using the   --notify global option.
[warning]
WD php: Warning: include_once(sites/default/civicrm.settings.php): failed to open stream: No such file or directory in civicrm_initialize() (line 190 of /var/www/site/profiles/compuclient/modules/civicrm/drupal/civicrm.module).
[warning]
WD php: Warning: include_once(): Failed opening 'sites/default/civicrm.settings.php' for inclusion  (include_path='<my include path>') in civicrm_initialize() (line 190 of /var/www/site/profiles/compuclient/modules/civicrm/drupal/civicrm.module).
[warning]
WD php: Warning: Invalid argument supplied for foreach() in civicrm_menu_alter() (line 482 of /var/www/site/profiles/compuclient/modules/civicrm/drupal/civicrm.module).
[error]
Drush command terminated abnormally due to an unrecoverable error.

I might be trying to do something the module just isn't designed for, i.e. installing it when CiviCRM isn't yet installed on the site. The step that installs CiviCRM takes place after the site's dependencies are downloaded and enabled.


texts:
I was trying to change the message template for the membership invoice, so I went to Administer - Communication - Message templates, but got the message "Access denied - you are not authorised to access this page". Anyone who knows what I can do and why access is denied?

Thank you.


texts: Processing mailed checks where donor sends monthly

texts:
We have quite a few donors that mail a check every month (probably 80% of our checks we receive). It is for the same amount and project(s). Each donor generally sends their check around the same time each month. I am looking for ideas on how to streamline the manual data entry for these "recurring contributions".
We use Drupal for our CMS. iATS for our payment processor.

Is there already a method or extension to do this?
Would this be something I could use a View/ CiviEntity to do? I am not familiar with Entity but if you point me in the right direction, I can probably put something together.


texts:
Last April, I installed the Mosaico extension on CiviCRM / WordPress. Although the install seemed to be successful (Mosaico shows up in the list of extensions as enabled), I get a message "ImageMagick is not installed" when I go to the CiviCRM dashboard.

I'd like to now to uninstall Mosaico. I found these instructions:

In order to uninstall extension, you need to disable it first - once disabled, you will see the "Uninstall" link. Click it in order to completely remove the extension from your system, including permanent deletion all of its custom data. To preserve the data, take a backup before uninstalling. (https://docs.civicrm.org/sysadmin/en/latest/customize/extensions/)

As far as I know I have never really used Mosaico.  I do have a backup of the database and all files, but I'm just wondering before I proceed if uninstalling could cause any problems, or if there's anything else I might need to know.

Thanks!


texts:
I'm trying to integrate payments via mollie.com using the extension "Omnipay multiprocessor support" (version 1.9).

I created a contribution page to test it, and I am using a test API key from Mollie.

When I test-drive my contribution page I am redirected to the site of Mollie, where I can select a payment method. So far so good, but when I am redirected back to my civicrm site, I get a fatal error:

Omnipay\Common\Exception\InvalidRequestException: "The transactionReference parameter is required"

Is it because I am using the test API key? Or is there another (configuration) issue?

The stack trace shows:

#0 sites/default/files/civicrm/ext/nz.co.fuzion.omnipaymultiprocessor/vendor/omnipay/common/src/Omnipay/Common/Message/AbstractRequest.php(610): Omnipay\Mollie\Message\CompletePurchaseRequest->getData()
#1 sites/default/files/civicrm/ext/nz.co.fuzion.omnipaymultiprocessor/CRM/Core/Payment/OmnipayMultiProcessor.php(816): Omnipay\Common\Message\AbstractRequest->send()
#2 sites/default/files/civicrm/ext/nz.co.fuzion.omnipaymultiprocessor/CRM/Core/Payment/OmnipayMultiProcessor.php(792): CRM_Core_Payment_OmnipayMultiProcessor->processPaymentNotification((Array:2))
#3 sites/all/modules/civicrm/CRM/Core/Payment.php(1242): CRM_Core_Payment_OmnipayMultiProcessor->handlePaymentNotification()
#4 sites/all/modules/civicrm/CRM/Core/Payment.php(1147): CRM_Core_Payment::handlePaymentMethod("PaymentNotification", (Array:3))
#5 [internal function](): CRM_Core_Payment::handleIPN()
#6 sites/all/modules/civicrm/CRM/Core/Invoke.php(278): call_user_func((Array:2))
#7 sites/all/modules/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:14))
#8 sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:4))
#9 sites/all/modules/civicrm/drupal/civicrm.module(448): CRM_Core_Invoke::invoke((Array:4))
#10 [internal function](): civicrm_invoke("payment", "ipn", "2")
#11 includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:3))
#12 index.php(21): menu_execute_active_handler()
#13 {main}

Thanks!


texts: Why do Activities entered via a webform *not* marked as Completed get entered into Civi as completed?

texts:
We're on Civi 4.6.17 and Drupal 7.

I've created a webform with a 'script' for callers with multiple Activities. Activity 1 is to record the results of a phone call asking for an in-person meeting (call is Completed, Left Message, etc) with the 'target' contact. Activity 2 is to record the date, time, subject, status  of a successful request for an in-person meeting made on the phone call. Activity 3 is to create a reminder to the caller to send a reminder of the in-person meeting to the 'target' contact by postal mail, e-mail or text messsage.

When callers can (or cannot) reach the target on the phone, then Activity 1 date, time, subject, status is recorded. If the target cannot be reached, the call ends of course. However, even though a date, time, status are not recorded for Activity 2 and Activity 3, both activities are entered as completed in the caller's Activity record, and an e-mail gets sent to the caller (who is Assigned To: the activity)

I have a default subject for Activity 2 and Activity 3. I'll try removing the default subject text, leaving it blank, and see if that is the cause of Activity 2 and Activity 3 being recorded.

My desired outcome is simply for Activity 1 status to be saved and Activity 2 and Activity 3 to not be saved on form submittal if the caller does not talk with the 'target'.

I'm also getting this error message on form submittal which seems to be related:
Notice: Undefined index: act in wf_crm_webform_postprocess->processActivities() (line 1368 of /var/www/citizenactionny/my.citizenactionny.org/sites/all/modules/webform_civicrm/includes/wf_crm_webform_postprocess.inc).


texts:
Brand new to CiviCRM. First thing I am trying to setup is memberships. Our members dues are automatically deducted from paychecks. We receive 26 paychecks per year but only 24 dues payments per year. So no dues are collected from the 3rd paycheck within a calendar month (happens twice a year)  Trying to figure out the best term to use and if there is a way to just allow the payments to be automatically recorded in CiviCRM based on the schedule dates for paychecks or to just simplify it to 2 payments per month... No payments actually need to be processed, just simply recorded in CiviCRM.

Initially it seemed that it might just be easier to not track actual payments and just override the members status and just manually expire the member when they resign but trying to use CiviCRM to its fullest extent.


texts:
I have looked a great bit into some alternatives to the default civicrm theme such as shoreditch, haystack, the CiviHR theme and one that agiliway developed for their demo site.

My question is what alternatives are most people using instead of their default civicrm theme? Custom theme or one of the alternatives i discussed above.


texts: Everything In CRM is Slow - Errors With CRM_Contact_BAO_GroupContactCache

texts:
After a database was corrupted and reloaded from a backup.
Looking at the error log this appears to be where CiviCRM is hanging.

  CRM_Contact_BAO_GroupContactCache::load(Object(CRM_Core_DAO))

Here is the debug information.

  [debug_info] => CREATE TEMPORARY TABLE
  civicrm_temp_group_contact_cache1632  (SELECT 95 as group_id,
  contact_a.id as id   FROM civicrm_contact contact_a    LEFT JOIN
  civicrm_email ON (contact_a.id = civicrm_email.contact_id AND
  civicrm_email.is_primary = 1)   WHERE  (  (
  (NULLIF(civicrm_email.email, '') IS NOT NULL)  AND
  contact_a.do_not_email =  AND contact_a.is_opt_out =  AND
  contact_a.contact_type = 'Individual' )  )  AND (contact_a.is_deleted
  = 0)   AND contact_a.id NOT IN (
                                 SELECT contact_id FROM civicrm_group_contact
                                 WHERE civicrm_group_contact.status = 'Removed'
                                AND   civicrm_group_contact.group_id = 95 ) ); [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 contact_a.is_opt_out =  AND
  contact_a.contact_type = 'Individual' )  )  AND ' at line 1]

Any advice on how to resolve this is appreciated.

Thanks,
Josh


texts: Drupal login destination is ignored when members log in

texts:
When members log in, they are always redirected to their Drupal user profile page, and the login destination in the URL is ignored.

For instance, when they try to access a members-only page, they are prompted to login, but after they do, instead of returning to the page they were accessing, they are send to their user profile page.  This does not happen to non-members who have a Drupal account, where they are redirected as specified in the URL.

We do have LoginToboggan and LoginDestination modules installed, but they do not seem to have anything to do with this behavior.  Any ideas why this is happening and how to fix it?  Thanks!


texts: How can I use Drupal Rules to remove a contact from a group

texts: Webform_CiviCRM integration enables me to add contacts who submit a form to a Civi group. What I'd like to do is to remove them from another group at the same time, as part of a pipeline process. Drupal Rules module offers 'Remove contact from CiviCRM group' as an action, but I can't work out how to "select data of the type Contact" which seems to be what Rules is looking for in order to enable this action. How can I create a rule that removes a contact form a group based on the matched Drupal user submitting a webform (or perhaps based on the fact that the webform adds the contact to a group)?


texts: CiviRules trigger for a change in participant from one status to another

texts:
I can not get a rule to trigger on "Event Participant is changed"

Using the condition "Field Value Comparison"

On the field "Participant Status"

If I use "Compare with original value (before the change)?".

It triggers fine if I don't try to check the value before the change but I only want it to trigger if the status changes from (for example) "Registered > Attended".

Any ideas?

Thanks


texts: Moving wordpress / CiviCRM to another folder

texts: I had mysite.com set up with CiviCRM, we built a new site and then moved mysite.com to another directory and changed the subdomain to old.mysite.com. CiviCRM no longer works and I am having a hard time getting it running. From reading this: Change URL only on WordPress+CiviCRM I changed the CIVICRM_UF_BASEURL but I am assuming I need to do more than just that as that didn't work. If anyone could give me some more information that would be awesome.


texts: How can I alter DataTable defaults / attributes without overriding core files?

texts:
Example use case:

When viewing a Contact, on the Relationships tab we'd like the DataTables to default to showing 50 records.


texts: I need help finding an error in my installation

texts:
I am mostly finished with moving our website from a Joomla installation to a Wordpress installation. I have been having problems getting the dashboard on CiviCRM to show, but I can access specific pages (such as the configuration page) by entering it directly.

In all this, I found I was getting an error in our hosting logs about accessing a directory that is no longer in use (a test directory that the new website was installed in). Upon contacting my host (Siteground) to determine what file(s) were giving that request, they recommended a plug in to Wordpress - Better Search and Replace.

I found that there were some 400 or more old links in CiviCRM tables to 'public_html/test' which was the test site. Since things are now moved to 'public_html', I changed all of those links in the database.

Now, when I click the CiviCRM link on the dashboard, I simply get "Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.".

I pulled the CiviCRM logs after this found the following:

Jan 01 08:50:58  [info] $Fatal Error Details = Array
(
    [message] =>
    [code] =>
)

Jan 01 08:50:58  [info] $backTrace = #0 /home/nefc0709/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(378): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/nefc0709/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(307): CRM_Core_Error::fatal()
#2 /home/nefc0709/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:17))
#3 /home/nefc0709/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#4 /home/nefc0709/public_html/wp-content/plugins/civicrm/civicrm.php(1216): CRM_Core_Invoke::invoke((Array:3))
#5 [internal function](): CiviCRM_For_WordPress->invoke("")
#6 /home/nefc0709/public_html/wp-includes/class-wp-hook.php(286): call_user_func_array((Array:2), (Array:1))
#7 /home/nefc0709/public_html/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters("", (Array:1))
#8 /home/nefc0709/public_html/wp-includes/plugin.php(453): WP_Hook->do_action((Array:1))
#9 /home/nefc0709/public_html/wp-admin/admin.php(224): do_action("toplevel_page_CiviCRM")
#10 {main}

If anyone has suggestions, I would appreciate it!


texts: ContactLayout extension not working with civicrm 5.10

texts:
So we are using Drupal 7 and civiCRM 5.10. We want to use this extension https://github.com/civicrm/org.civicrm.contactlayout

We have installed angular profiles (4.7.31-1.1.2) and API v4 (4.3.0) as well as the contact layout (1.3.1). We also have shoreditch.

When we navigate to Administer -> Customize Data and Screens -> Contact Summary Layouts all we get is an empty civicrm screen. When we try to view a profile with these enabled we get the error 'Api ContactLayout get version 4 does not exist.'

Any ideas about this one? I have tried having a search on here and a google of this error message, but so far I haven't seen this issue?


texts: How can I 'or' 2 conditions using the api?

texts:
If I want to find all contacts without a birth date, I can do this with the api:

$result = civicrm_api3('Contact', 'get', array(
  'sequential' => 1,
  'birth_date' => array('IS NULL' => 1),
));

If I want to find all contacts with a birth date before a given date, it works like this:

$result = civicrm_api3('Contact', 'get', array(
  'sequential' => 1,
  'birth_date' => array('<=' => "1960-01-01"),
));

Now suppose I want to both the contacts without a birth date and the contacts born before a particular date, can I do that in one API call?


texts: The charts on the civicontribute dashboard do not display

texts:
Trying to figure out why the charts on the my WordPress / CiviCRM 4.7.27 CiviContribute dashboard are not displaying. We see no errors on the front end, but no charts appear.

Anybody have any good ideas on why this may be happening?


texts: Civi is Requiring "On Behalf of Organization" fields when that's not even checked

texts:
On our contribution form, we allow people to contribute "On Behalf of an Organization" however it's not required.

The problem is even when that box is left unchecked, they get to the confirmation page without error, but when they actually click to submit the form, it says that the organization fields are all required.

It looks like this person had a similar problem.
https://forum.civicrm.org/index.php?topic=35137.0

Here's our form:
http://rivertreesingers.org/support

If you test it, just check the mail a check option to go through, but it shouldn't let you complete.

If it seems like a bug, where should that be reported? I'm on CiviCRM 4.7.3 in a WordPress environment.

Thanks!


texts: Where is the 'Require Participant Approval' checkbox on the 'Online Registration tab'?

texts:
I am trying to set up an event that requires participant approval.  I have read the guidance and have ensured that the participant statuses, 'Awaiting approval' and 'pending from approval' are enabled.

The guidance then goes on to say, 'You can then check the Require Participant Approval checkbox on the online registration tab', but I can't see this checkbox on the tab.

Am I missing something?
Thanks
Anna

Civi 4.6.5


texts: How to Transfer Big Data to a Different Domain

texts:
I received a SQL error while updating CiviCRM. He asked me to restore the old database, but I didn't have a backup at the time. Therefore I could not make a healthy update. Then I applied all the updates, but I still get "Database Partially Upgraded - Database check failed" warning for the database.

I have very serious data. I don't want anything to happen to this data.

So I thought of something like this. I'm going to build a new Joomla - CiviCRM. In my setup, I will rebuild all the fields as in the old site. Then I will import the data from the old domain.

But here's the thing. There are more than 130000 activities. It is not possible to transfer such data in bulk. It is not even possible to get 100 pieces because it gives a constant error.

Here are the data I'm trying to get.

Contact ID, Contact Type, Sort Name, Display Name, Contact Source, Contact Hash, First Name, Last Name, Email Greeting ID, Postal Greeting ID, Addressee ID, Created Date, Modified Date, Addressee, Phone, Phone Type, Activity ID , Activity Type, Activity Type ID, Subject, Activity Date, Duration, Details, Activity Status, Activity Priority, Source Contact, Source Contact ID.
I also have custom fields that I have created for Activity Types.

How can I transfer all this without problems.


texts:
Steps to reproduce:

On Manage Groups page, disable a group.
Include disabled groups in search by checking Disabled check field
When I click on Enable link, it displays alert which contains text to confirm disable and group remain disabled.

[]

It seems this issue is related to 4.7. Tried on Drupal and WordPress Demo.

Demo on Joomla which has version 4.6 doesn't have this issue i.e on click on enable link, the group does get enabled.


texts:
When I do Search->Find Contacts and get the standard list of contacts, it looks like the address displayed is not the contact's primary address, but simply the first address that was created for the contact.  I've looked in the code to try to find where this query is located, but I can't find it.  Shouldn't the search results screen display the primary address, primary email, and primary phone?

I know I can create a custom profile to change the search results screen, but I would think that the default screen should display the primary contact information by default.


texts: Having a Problem Installing CiviCRM 4.7.25 on WordPress

texts:
I'm having a problem installing the latest version of CiviCRM on WordPress 4.8.2 (Ubuntu 16.04.3 LTS, Apache 2.4.18, PHP 7.0).

Steps to Reproduce:
1) Log in to the WordPress site's administrative interface.
2) Click "Add New" under "Plugins" on the administration menu.
3) Click "Upload Plugin," then browse to and upload the plugin's Zip file.

Output:
Unpacking the package…
Could not extract file from archive. civicrm/civicrm/packages/kcfinder/themes/dark/img/files/big/..png

Expected Results:
The package should have extracted and installed with no errors.

Please advise.


texts:
I am testing with CIVICRM in Spain and I don`t know the location of the information of Cities and Municipaly for test importing Contacts. Can you help me. I test with Wordpress.
Thanks

Andreu


texts:
This is a minor issue, but the count of organizations using CivCRM that is displayed on my civi home page seems to bounce around quite a bit.  For a time it showed numbers over 10,000.  Just now it says, "Used by over 6,273 organizations ..."  Last week I am pretty sure it was even lower but I did not record the number.
The 2015 blog post on this topic said, "There are close to 9,000 nonprofit or governmental organizations worldwide relying on CiviCRM ..."
The updated widget on the same page reports 11,061 organizations as of June 5, 2017.
Just wondering if actual usage varies that much or if the measurement technique needs work.


texts: Unable to give provider name by using SMS Api Extension

texts:
I downloaded SMS Api Extension (v1.3) in civicrm version 4.5.0.
After that i am unable to give Provider name.(As there is no option to give provider name)
Then i went to https://github.com/CiviCooP/org.civicoop.smsapi .... There in commits "fixed provider name fixed section". It showing two changing files which was missing in last released SMS Api version 1.3.
4.So i created CRM/Smsapi/CivirulesAction.mgd.php and CRM/Smsapi/CivirulesAction.php inside org.civicoop.smsapi (which is the extension diretory name)

When i opened --> Settings - SMS Provider --> Still creating of provider name option is not coming.

Please suggest.


texts: Cannot Tags and Groups fields in Webform CiviCRM Integration - Drupal 8

texts:
I try to create a contact in CiviCRM 5.9.1 with a Webform and Webform CiviCRM Integration (all in Drupal 8.6.7),

But when I choose the needed fields in CiviCRM and I use the ENABLE TAGS AND GROUPS FIELDS : no field appears.

If I still save then I get in Drupal an Error: Class 'Drupal\webform_civicrm\CRM_Core_BAO_Tag' not found in Drupal\webform_civicrm\FieldOptions->get()

To recover the use, I need to delete the Webform.
All of the other fields appears and can be selected in the Webform : Phone, Email, etc.

Is this, reveals a bug in Webform CiviCRM Integration or could it be something wrong in the Tags and Groups ?

Also if I select Yes for Tags and Groups fields, then impossible to get fields for Phone, Email, etc.

With Tags and Groups fields on No

With Tags and Groups fields on Yes, no other fields can be selected


texts: CiviCRM Data not showing in Views - Drupal 9, Shared DB

texts:
After running into problems setting up Views integration with CiviCRM installed on a separate database, I gave up and started my project over with CiviCRM installed on the same database as Drupal 9.  This has solved the privileges problem I was having.
Here's my old question about the Privileges problem (which I'd still love an answer to if anyone has one!)
However, I'm now running into an issue where CiviCRM fields aren't showing up as an option in Views. The documentation seems to suggest that if CiviCRM is installed on the same db as Drupal, this data should show up with no further configuration needed.

If your CiviCRM and Drupal are located within the same database the 12
steps below are not required.

Help!  What am I doing wrong?
EDIT:  At @KarinG's suggestion I installed and enabled the CiviCRM Entity module, which has fixed the problem where CiviCRM entities weren't showing up as options in Views.  However, I now have a problem where those entities are not showing up in the results. I've flushed Drupal's caches many times at this point.
EDIT:

No results are returned.
Thank you in advance for all your help! It really feels like there's just some silly box I've left unchecked somewhere.


texts: Using CiviCRM for Coworking Check in tracking

texts:
One part of our nonprofit is running several co-working locations. We have members that can buy a part time membership that lets them use the facility 10 times a month.

We would need a way to have a member login page at the front of our locations where the member "checks-in." We'd want to display how many times that month they have checked in and how many more visits they have for the month.

While I'm asking, room reservations extensions/

Thanks,

Brad


texts: Changing template for event/contribution forms

texts: The wordpress site is setup with a 2 column template as the default. But this doesn't work for event/contribution forms. If I forget to set the template to full width I get a sidebar. If I set the template to full width, I get the sidebar inserted at the bottom of the forms pages. I think there is a way to set the default template for a form but can't find it.


texts: How to add a values (html select) to custom field?

texts: I am creating an extension. I created a custom group and custom field. The data and input field type is alphanumeric and select. I want to add multiple choice option into that custom field using an extension.


texts: I have centered text in a mailing that I'm setting up. The line length is too long for easy readability. How do I set up a maximum text width? Here's how it looks now:


texts: Large Text Fields Not Writing in Database

texts:
We've discovered what seems to be a bug creating large text fields from CiviCRM Custom Fields. I hope I'm able to explain this well enough.

Relevant environment information:
- Drupal 7.59
- CiviCRM 5.1.0 and then 5.1.2
- PHP 5.5.9 (not recommended but supported)
- Webform and Webform CiviCRM modules for Drupal enabled

And the steps we took:
1. Create custom fields of type text associated with a contact. Give it a very large database size, something like 6000. I haven't confirmed exactly at what point is too large, but 6000 definitely was.

Create a webform on the Drupal side with CiviCRM processing enabled. Make contact 1 for CiviCRM processing able to show the large field and also accepting existing contacts. Edit the webform field for the existing contact so it is a dropdown select (just for easier testing).
Fill out the form once to create a contact, filling in that field.
Go back to the form and select the existing contact to be the one you created. The field does not auto-populate.
Alternate way to test this is to go to the form with the parameter ?cid=[id] added to the URL, which will show errors on the screen about the field not existing.

====
After investigation, we discovered that the root of the problem seemed to be that the field was not being created in the database table for the custom value. For example, if the custom field group was called constituent and it was the 3rd custom group, the table I believe would be civicrm_value_constituent_3. Each custom field of that field group normally gets a column in this table, but if the large text size is too big, it doesn't create the column and it doesn't give any warnings either. Manually creating the columns into the table fixed the problem, reinforcing that conclusion.

It does still add to the civicrm_custom_field table, so no problem there. It's just the values table.


texts: Scheduled jobs cron not working properly

texts:
We use CPanel to run crons on our sites. The cron had been working fine and then stopped some months back. I've tried every example I can find, but it still is not running properly.

I've attached a screenshot of what the cron looks like in CPanel as well as the cron in text (redacted to remove personal info). The username, password, and key are all letters/numbers - no special characters.

wget -O - -q -t 1 'https://www.DOMAIN.org/sites/all/modules/civicrm/bin/cron.php?name=USERNAME&pass=PASSWORD&key=KEY'


texts: How can I search for or report on contacts based on date, method and/or status of group subscription?

texts: With GDPR coming down the track I'm keen to dig in to my contact lists in more detail. I'm looking the ability, ideally through the UI, of reporting on, and searching for, contacts based on the date they subscribed to a given group, the method by which they were added to the group, and the status of their group membership.


texts: PayPal Pro - how to remove link to paypal

texts: I have civicrm 4.6.10 installed under drupal 7.41 and we paid extra for PayPal Pro to avoid linking to paypal (i.e. leave the site). How do I remove the button that lets you link to PayPal? The rest works fine.


texts: ContributionDashboard correct amount not equal CiviReport

texts:
Stripe.com shows we received a donation of $15.
It correctly shows on the Civi Contribution Dashboard.
When we run Civi Report, the amount shows up as $30.
We have many cases when the report and the dashboard give the correct results. This is the first time when the amounts do not agree.  Anybody know what is wrong?


texts:
I have created a form and I am trying to get an image to upload. I have the following set:

$this->add(
      'file', // field type
      'image_file', // field name
      'Upload Image', // field label
      TRUE // is required
    );

However, when I submit the file it does not upload anywhere. Any ideas on what I am doing wrong?

Thanks!


texts: how do I create a new template on civicrm / mosaico

texts:
Is not a question, i just want to share with you how you can create a new template on civicrm / mosaico!

for wordpress:

Template directory:

/www/yoursite/wp-content/uploads/civicrm/ext/uk.co.vedaconsulting.mosaico/packages/mosaico/templates/

here you find 3 templates directory that already exists

choose one of the folders (important)
and duplicate and rename folder and the.html inside (respecte the nomenclature)

next step
view your template in the selection area in wordpress

go to

/www/yoursite/wp-content/uploads/civicrm/ext/uk.co.vedaconsulting.mosaico/js

edit index.js

and add your template here:

var viewModel = {
        showSaved: ko.observable (false),
        edits: ko.observableArray (initialEdits),
        templates: [{
          name: 'versafix-1', desc: 'The versatile template'
        }, {
          name: 'tedc15', desc: 'The TEDC15 template'
        }, {
          name: 'tutorial', desc: 'The Tutorial'
        }, {
          name: 'newtemplate', desc: 'newtemplatetitle'
        }]
      };

Final step is create / modify your own template
put your new template with correct name in your Template directory

sorry for my poor english ... I'm french: p


texts: Can you include CiviCRM ID in exported fields?

texts:
Our administrator needs to export email addresses for households and individuals complete with CiviCRM ID so that an audit of imported data can be undertaken. However, CiviCRM ID isn't available in the select fields stage of contact export.
Is there any way to work around this?


texts: I want a user Registration page on wordpress with civicrm

texts:
I want a form with user registration and component of civicrm that i have created in civicrm. If we submit that for user data should be saved and redirected to civicrm contruibution page.
If user has paid for the membership the only he can view the members page.
Please help,
Thankyou In Advance
You can drop and answer in email or telegram me.


texts:
There is the Preferred language field in Communication Preferences which allows to choose the contact's preferred language.

However when I try to create custom fields for a contact's second, third language, I don't find Language as a choice among the other Data and Input Field Types What would be the recommended way to make the language select like in Preferred language available for re-use in custom fields?

With all the languages in a select field defined and available somewhere, what I try to avoid here is that I need to re-enter all these languages by hand for my custom fields.


texts: Warning: getimagesize() error profile picture

texts:
Happy new years all!

I'm having problems showing images uploaded to a profile.

While editing a profile I can upload an image, but upon loading the profile page I get the following error across the top of the page (directory redacted here)

Warning: getimagesize(…photo=Mateusz_Pozar_da0ef7da9ecd68e909817e2c733e0d79.jpg):failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in …wp-content/plugins/civicrm/civicrm/CRM/Contact/Page/View.php on line 164

The line in the php file is:

list($imageWidth, $imageHeight) = getimagesize(CRM_Utils_String::unstupifyUrl($image_URL));

Trying to open the image directly via "show image" on the profile page I get a 404

The requested URL /civicrm was not found on this server.

The specified directory for uploaded images is plugins/files/civicrm/custom/ and I can see the four images I've tried uploading and they look fine when opened directly.

Could this be caused by a too big or heavy image?

I'm running WP 4.4 and CiviCRM 4.6.6

Cheers / M


texts: Issues using 'Related Permissions Module' with v4.6 of CiviCRM. Will there be an upgrade soon?

texts: We are using CiviCRM Webforms to allow parents to sign-up their events for there children. I am restricting access to related contacts using groups but would like to enforce permissions using 'Related Permissions Module', however this does not seem compatible with v4.6. Will there be an upgrade soon


texts:
I am currently trying to import contributions to CiviCRM, and it will not let me. Ill get all the way to the import option, it will tell me that all rows are valid, then once I import, all rows are invalid. It is saying that my contact id is not valid, but it is! I have exhausted everything in my ability, and as wondering if you could help me out.

Thanks,

Chandler


texts:
I can't seem to create any custom fields.  I'm on the /civicrm/admin/custom/group page and I choose the "Add Set of Custom Fields" button.  After filling out the form (setting "Used For" = Contribution) and hitting the Save button, I'm taken back to the /civicrm/admin/custom/group page, but my new Custom Data group isn't visible.

There are no error messages in the browser, nor in Watchdog.  What could be going wrong here?  I'm logged in as user_id=1.

I'm using CiviCRM 4.6.10 on Drupal 7.41.


texts: Is smart group cache set to 0 OK for this situation?

texts: Using ACLs I have setup a group of users to have edit access to a smart group of contacts. The smart group is based upon the contact type. The problem is when one of these users creates a contact of this type, the contact is created OK but then an error message pops up to say they don't have access to the contact. They do have contact after a minute or so - the smart group cache is set to 1.  When I set the smart group cache to 0 then they have immediate access.  This client only has 12 smart groups. Smart group cache set to 0 solves the problem, but I'm not sure this is a good idea.  Are there any other solutions for this situation? - which can't be that uncommon.


texts: MultiRecord OptionGroup on campaign page

texts:
Out of the box, while CiviCRM offers multirecord optiongroups/values on a contact page, it doesn't allow you to, on a campaign entity.

Why is that? Are there some limitation that I'm missing ?
Is this something that can be easily achieved through coding?

Thanks, in advance!


texts: PayPal IPN Notification Inconsistently Received

texts:
Random completed PayPal transactions are not being updated in CiviCRM and the contribution records are incorrectly left as "Pending." I have worked with PayPal to confirm that all IPN notifications are being successfully sent from their end. CiviCRM's logs do not show any errors; they simply do not show that they received any notification from PayPal.
To make matters more confusing, when I resend IPN notifications through PayPal, they are then correctly received by CiviCRM the second time around and the contribution record is updated.
Any ideas on how to rectify this situation? I cannot find any pattern as to which notifications go unreceived and which contributions are successfully updated. I am on WordPress 5.5.3 and CiviCRM 5.30.1.


texts: Is it possible to do an Event registration 'on behalf of organization' - similar to how that can be done on Contribution pages?

texts: Scenario: John Smith registers for Event - buys 10 tickets -> $5000 total; These monies end up on John's Contribution record (and risk being TaxReceipted at the $5000 - advantage[food, cost] level). These monies really belong on John's company record -> Solar Panels Inc. Is there a way to configure a CiviCRM Event page such that John has an option while registering for the Event to let us know that the monies should go onto Solar Panels Inc.?


texts: Can we expose the membership description field within a Drupal View

texts: I have built a Members Search page using a CiviCRM Contact View in Drupal 7 and I would like to render the Description field of the membership type for the contacts that are returned. This data doesn't appear to be available out of the box so I looked at the CiviCRM Entity module, however that doesn't seem to expose the description. What sort of approach should I take?


texts: Why are edits not saved on custom field profile?

texts:
Drupal 7.41
Civi 4.6.9

I've inherited this site recently and see an issue with custom field profiles that I haven't seen before.

Custom field set is tied to contacts with corresponding profile.

When editing the custom field set from the contact page, edits are saved correctly.

However, when I edit them from the profile, nothing is saved.

There are no errors that I can see in any logs.

I've cleared the templates_c folder to no avail.

All users have access all custom data permission.

After more research, if I add a built-in Civi field (like last name) to the profile and edit it, the last name edit is saved but no custom field data is saved.

Any ideas?


texts: Undefined index: maxlength after update to 5.2.0

texts:
I am relatively new to CiviCRM. After we updated to 5.2.0 I started getting this message when I enter the Create New Individual screen:

Notice: Undefined index: maxlength in CRM_Core_Form->addField() (line 1478 of /home/makernexuswiki/www/crm/sites/all/modules/civicrm/CRM/Core/Form.php).

Searching Google and StackExchange I could not find any relevant info.

Did the upgrade fail to add a required index? Is this a big issue? Should I just set the system to ignore Notices?

We are on Drupal 7.5.9

Any help is appreciated.
Jim


texts:
I am trying to install buildkit and re-educate myself with some of the more up to date CiviCRM development practises :-) However, I get an error when I run civicrm_download_tools. I am running Ubuntu 14.04. Here is what my npm-debug.log says:

 14868 error 404 'types' is not in the npm registry.
14868 error 404 You should bug the author to publish it
14868 error 404
14868 error 404 Note that you can also install from a
14868 error 404 tarball, folder, or http url, or git url.
14869 error System Linux 4.4.0-57-generic
14870 error command "/usr/bin/nodejs" "/usr/bin/npm" "install"
14871 error cwd /home/erik/buildkit
14872 error node -v v0.10.25
14873 error npm -v 1.3.10
14874 error code E404

Any ideas what I could or should do?


texts:
I have a custom field "File" which for some reason is not displaying the file. However, it is being uploaded correctly. The functionality is working fine just the display looks corrupted and if i try to download it it comes up as its not supported.

I have done the following steps:

Checked the Safe File Extensions, that is configured correctly.
Replaced the /CRM & /templates folder.
Checked the path where the files are stored (files/civicrm/custom/),
i can view the images here and it doesn't come up as corrupted.
Checked the database and it is all put correctly.

The Code for the file is being displayed like this:

When i click on it, the file is being downloaded as a corrupted image file.

Image of the how it appears in the UI:


texts: Price set is required but “-none-” option remains

texts:
As the title says, we have a price set - its required, but the none option remains. This is being used for a membership sign up contribution page. Sorry I did not clarify earlier.

Civi 5.1, wordpress 4.9

Update: we ended up creating a new price set, making the options required, and a new contribution page and it all worked out.


texts:
We're trying to create online receipts for Memberships, Contributions and Events and we would like to include the contribution source, and payment instrument for in the receipts. The question is, is this possible? Since, the tokens that we're seeing in the message templates editor are only for contact, address, additional information, and some information from profiles that we made.

We're using CiviCRM 4.7.22.


texts: CiviCRM_API3_Exception: "API error: DB Error: already exists"

texts:
CiviCRM_API3_Exception: "DB Error: constraint violation" I have fixed these problem by updating one by one from 5.14.1 to 5.19.1 but now I have got new problem :) In the new version I cant install/uninstall and update any extention. I got the following error on screen:

But I realised when I click back than is the update or install/uninstall is done. But everytime when I try I get the same error. Anybody who knows the reason of the error showing ?


texts: HTTP Error 500 during search request - CiviCRM 5.1.1

texts:
I have a new installed CiviCRM 5.1.1 property on my server.

My current system configuration is:

Wordpress 4.9.6

The problem:
I importet a few contacts but I realized that besides using the search function in the upper left corner and using custom reports I receive an error 500 and no results.

For example, when I use contacts > find contacts I receive an Error 500 for the following URL:
http://mydomain.de/wp-admin/admin.php?page=CiviCRM&q=civicrm/contact/search
in Wordpress Debug Mode:

Fatal error: Uncaught Error: Call to undefined method CRM_Core_DAO::disableFullGroupByMode() in /var/www/vhosts/xxx.mydomain.de/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/Query.php:4848 Stack trace: #0 /var/www/vhosts/xxx.mydomain.de/wp-content/plugins/civicrm/civicrm/CRM/Contact/Selector.php(1181): CRM_Contact_BAO_Query->searchQuery(NULL, NULL, NULL, false, false, true) #1 /var/www/vhosts/xxx.mydomain.de/wp-content/plugins/civicrm/civicrm/CRM/Utils/PagerAToZ.php(108): CRM_Contact_Selector->alphabetQuery() #2 /var/www/vhosts/xxx.mydomain.de/wp-content/plugins/civicrm/civicrm/CRM/Utils/PagerAToZ.php(136): CRM_Utils_PagerAToZ::getDynamicCharacters(Object(CRM_Contact_Selector), false) #3 /var/www/vhosts/xxx.mydomain.de/wp-content/plugins/civicrm/civicrm/CRM/Utils/PagerAToZ.php(52): CRM_Utils_PagerAToZ::createLinks(Object(CRM_Contact_Selector), NULL, false) #4 /var/www/vhosts/xxx.mydomain.de in /var/www/vhosts/xxx.mydomain.de/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/Query.php on line 4848

Could anybody please help with this issue?
I was trying to fix it for some time now and searched the whole forum with no result or hint.
Thanks a lot in advance.


texts:
PHP Error: require_once(): Failed opening required 'CRM/Core/ClassLoader.php' (include_path='.:/buildkit/build/dmaster/web/sites/all/modules/civicrm/:/buildkit/build/dmaster/web/sites/all/modules/civicrm//packages:.:')
at line 552 in /Users/apple/Work/Gsoc/Opensrc/civicrm-buildkit-docker/build/dmaster/web/sites/default/civicrm.settings.php

This is the complete error i am getting.
For this i changes the path in civicrm.setting.php '''$civicrm_root ='/Users/apple/Work/Gsoc/civicrm/civicrm-buildkit-docker/build/dmaster/web/sites/all/modules/civicrm';''' even then i am getting the same error.
Please help me out.


texts: Issues while geocoding Brazilan addresses with Google API on version 4.7

texts:
Geocoding is not working for my addresses, I tried everything I could find on the web.

We are using the CiviCRM version 4.7 with Wordpress 4.9.4. We are adding contacts mainly using the REST API.

I have Google geocoding setup with an valid and tested API Key.

My current address format is the default one, but my parsing is disabled.

{contact.address_name}
{contact.street_address}
{contact.supplemental_address_1}
{contact.supplemental_address_2}
{contact.supplemental_address_3}
{contact.city}{, }{contact.state_province}{ }{contact.postal_code}
{contact.country}

When I run the scheduled job, it just says that it processed hundreds of contacts, but none of them was geocoded, displaying no errors at all.

Job params:

geocoding=1
parse=0
start=0
end=500
throttle=0

I have also tried with throttling.

Job Log:

Summary
Finished execution of Geocode and Parse Addresses with result: Sucesso (Endereços Avaliados: 483 Endereços Geodificados: 0 )
Details
Parameters raw (from db settings):
geocoding=1
parse=0
start=0
end=500
throttle=0

Parameters parsed (and passed to API method):
a:6:{s:7:"version";i:3;s:9:"geocoding";s:1:"1";s:5:"parse";s:1:"0";s:5:"start";s:1:"0";s:3:"end";s:3:"500";s:8:"throttle";s:1:"0";}

Full message:
Finished execution of Geocode and Parse Addresses with result: Sucesso
(Endereços Avaliados: 483
Endereços Geodificados: 0)

Also, when I add a new contact.. even if it has a valid address, it also doesn't work.

Can someone help me? I am really confused.

OBS: I have tried the OSM extension, but only 7 of 500 addresses were geocoded.


texts: Authorize.net Recurring Transactions (ARB) - Silent Post URL Not Working

texts:
We are on CiviCRM 4.7.21. and Drupal. We have entered the proper Silent Post URL in Authorize.net for CiviCRM 4.7 which is "Drupal: https://yoursite.org/civicrm/payment/ipn/2".  I have the correct payment processor ID.  However, CiviCRM is not getting updated and the transaction status is Pending.  The Recurring transaction gets setup properly in Authorize.net and works fine.

We initially tested this in CiviCRM version 4.6 and it all worked fine.  The Silent Post URL as a different syntax.  We have tried both the old and new version for the Silent Post URL and it does not work.

Is there something else I am missing?

Below are log messages related to the contribution transaction;

"Notice: Undefined index: payment_processor_type_id in CRM_Financial_BAO_PaymentProcessor::getPayment() (line 248 of /srv/www/resolute/nc.resoluteroots.com/sites/all/modules/civicrm/CRM/Financial/BAO/PaymentProcessor.php)."

"Notice: Undefined offset: 21 in CRM_Financial_BAO_PaymentProcessor::getPayment() (line 249 of /srv/www/resolute/nc.resoluteroots.com/sites/all/modules/civicrm/CRM/Financial/BAO/PaymentProcessor.php)."


texts:
I am attempting to use CV to call job.execute to run my scheduled tasks as described in the CiviCRM Documentation. I am using Drupal 7. I have several independent sites running on the server.

It works fine when I call it manually (for each site):

sudo cv api job.execute --user=admin --cwd=/var/www/html/siteroot

The tasks also work when I call them manually from the UI (for all sites)

Crontab is set up with the following:

*/5 * * * * cv api job.execute --user=admin --cwd=/var/www/html/siteroot

the syslog shows no problems and that the cron fires (example output):

Nov  1 10:15:01 live CRON[8991]: (root) CMD (cv api job.execute --user=admin --cwd=/var/www/html/siteroot)

However,

the scheduled tasks appear to not be running. I have configured several to run "whenever cron is run" but they still do not run unless I fire them manually.

Is there something I am missing? Is there a log in Civi where I can see if the command is being received?

I am using Drupal 7, php7.0, CiviCRM 5.3 on Ubuntu 16.04


texts: Dashlets and SSL in multiple secure virtualhost environment

texts:
I've identified what may be bug or feature request, or at least a case of another item to add to the list of things which can make dashlets fail.

I have an Apache 2.4 server which has multiple virtual hosts using different SSL certificates.

Apache used not to support multiple SSL certs from different domains at all, but now it does it in effect because browsers specify which domain they want the SSL cert for. If a server has two certs installed "domainone.com" and "domaintwo.com" the user's browser needs to specify it wants to use the cert for "domaintwo.com", otherwise the server will provide whichever one comes earliest in the server config. This is apparently called Server Name Indication (SNI)(https://en.wikipedia.org/wiki/Server_Name_Indication)

If using wget or cURL, SNI does not happen by default.

Therefore, in my situation where I am using CiviCRM over an https connection, the dashlets will not load because they are loaded via cURL (I believe), and cURL will receive an error because it is using the wrong SSL certificate to connect.

In theory this could be because of an old version of cURL installed on the server, but I have checked and that isn't the case.

I believe it's more likely to be that the code needs to use something like SSL context options SNI_enabled boolean and SNI_server_name (http://php.net/manual/en/context.ssl.php), although I'm not sure how that integrates with using PHP's curl functions.

As you can see, I haven't delved into the code to work out if this is all right.

Could someone give me their thoughts on whether they agree this is the problem, and whether a code change would be beneficial?

On a completely separate note - given that dashlets seem to be a persistent issue that can conflict with server configuration or minor user config file errors - wouldn't it be better to just rewrite them to use AJAX?


texts: Group criteria updates through advanced search when no rights granted. Is this a bug?

texts:
Environment:

Drupal 7.53
CiviCRM 4.6.24 LTS

For MailUsers in Drupal Permissions, I have it set to:

CiviCRM: edit groups (No Rights for MailUsers)(only Admin has this)
CiviCRM: administer reserved groups (No Rights for MailUsers)(only Admin has this)

It does show correctly on the Manage Groups pages for a user with Authenticated and MailUser only rights, but if I click contacts for a group (reserved group or not) in this page, it then presents me with a page with contact results and a button "Edit Group Criteria (Smart Group or not)".  I can then edit the group criteria and then select all results and in the Actions dropdown on that page I can tell it to update the smart group, and then update the settings of the smart group.  I can also create a smart group through Advanced Search > Actions dropdown > New Smart Group.

This seems to be contrary to the rights set for MailUsers.

Is this a bug?


texts: Adding a Financial Account to a Contribution

texts: I've imported a bunch of Financial Accounts using the CSV importer. There are no associated Financial Types created (should there be?) so I am not sure how to link a new Contribution to the relevant Financial Account. Can anyone give me a pointer?


texts: Drupal broken after upgrade to CiviCRM 4.6.16

texts:
Site was happily working under 4.6.15 - ** Running Drupal 6 ** - Drupal 6 broken after upgrade.

Every time (Tried 3 times now) I try to upgrade in my development environment I get this message:

Fatal error: Cannot redeclare phptemplate_preprocess_page() (previously declared in /srv/bindings/619ae4403404445daf26537c92800797/code/sites/all/themes/*****custom_theme_name_changed_to_protect_id_of_website****/drupal6_theme_methods.php:8) in /srv/bindings/619ae4403404445daf26537c92800797/code/themes/garland/template.php on line 42

I've renamed the path above to my custom template to protect the id of the website concerned.

Any ideas anyone? 4.6.16 has security patch(es) so I'm under pressure to upgrade. Thanks!


texts:
I'm not asking for the actual solution, but more a pointer to references examples for the structure so I can move forward.

CiviCRM 4.7 or WordPress - I need to create a report that I think will be achieved by custom coding only.

My original request was here
Custom Report By Relationship

Essentially I have a a 'street rep (individual)' that has a relationship with a 'household ( a physical address)' that makes 'contributions'  and a 'household' has a relationship with an 'individual' as head of household.

So want to build a street collection report structured

Street Rep (page break)
    ---  Street Name  (sub section )
          --- door number, head of household name, last years contribution (line)

Although the requirement is relatively simple it has a level of complexity that my unfamiliarity with Civi structures is making it tough for me.

I really appreciate any pointers or help.


texts: Error uploading an image in email wysiwyg

texts:
I get this error when I try to upload an image in the email wysiwyg...

Could not load the settings file at: /srv/bindings/34923847/code/profiles/civicrm_starterkit/modules/civicrm/../..//default/civicrm.settings.php

I have no problem uploading images for contacts.
All my directories and resource urls seem to be good.
I'm running civicrm 4.6.5 on D7.
I started having this problem once I upgraded from civicrm 4.4.7 to 4.6


texts:
When I try to enable CiviCase I get a white screen of death and the following msg:

"A fatal error was triggered: Could not create the MySQL views for CiviCase. Your mysql user needs to have the 'CREATE VIEW' permission"

I cannot find any way to add this permission in PhpAdmin. What should I do?


texts: How do I hide a div tag for a specific event or contribution page?

texts: I would like to hide a specific div tag for a specific event or contribution page ID. I am not good with JS. So prefer CSS display:none; method. Any help would be appreciated. Thanks


texts: CiviCRM Database Upgrade from 4.7.16 to 4.7.28 is hanging

texts: I am trying to upgrade my Joomla civiCRM database from 4.7.16 to 4.7.28. The component upgraded fine but when I try to upgrade the database after following all of the preparation steps, it hangs and makes not progress. I've looked at all of the similar problems, but nothing helps me with my error. I have two questions, how do I know what's going on? And my second question is what is going on and how to I get it to complete the upgrade?


texts: Advanced Search: Proximity search fails; returns "We could not geocode the destination address."

texts:
Side Note: This worked before upgrading from 4.7.8 to 4.7.10.

When we go to Advanced Search (ourdomain/civicrm/contact/search/advanced): Address Fields, enter a Postal Code and a range (ex: Find contacts within 25 miles), and click "Search," CiviCRM returns an error like:

No matches found for:
Proximity search to a distance of 20 miles from 78660, UNITED STATES: We could not geocode the destination address.

I went to the sandbox (http://dmaster.demo.civicrm.org/civicrm/contact/search/advanced ) to check/test this, but the sandbox does not offer the option to search by proximity to a Postal Code. The sandbox is running 4.7.11

Thoughts? Thanks!


texts: What versions of PHP are used in CiviCRM's internal QA?

texts:
The wiki currently states that CiviCRM has bare minimum (5.3.10) and recommended (>= 5.4) PHP requirements.

Knowing what CiviCRM has been tested with can help identify what should be expected to work reliably.

As of today, what versions of PHP do CiviCRM's test infrastructure test with?
This question will become out of date over time; for future reference, is there a better place to check this information?
For orgs who aren't able to match the PHP versions that CiviCRM is tested with internally, what other options are available?


texts: Mandrill - webhooks for two different sites?

texts:
We have a client who has two webhooks defined in Mandrillapp - both of them reacting to the same events (click, open, etc). These webhooks have a post url of two different sites(dev and live). Eg.

  Post url of dev = http://devsite.com/civicrm/ajax/mte/callback?mandrillSecret=devkey

  Post URL of live - http://livesite.com/civicrm/ajax/mte/callback?mandrillSecret=livekey

My guess is that - when an email is sent from the live site, these both urls are triggered(on open or click event) and dev site also gets the response which creates a mandrill activity on dev site.

This is what is happening for us - when a bulk email is sent from the live site, dev also creates a mandrill activity.

Can we conclude that we need to use two different mandrill accounts for two different sites OR there is a way to avoid this (rules, etc)?

UPDATE after Chris Answer -

The posted answer seems to be something which is already present in Mandrill extension?

Readme file asks user to save the secret key as a value of an option group which we've done for dev and live sites.

Problem arises when DEV webhook is triggered by an event(open/click) of LIVE mails(note both above URLs react on the same event). As dev secret key is same(url param and option grp value) matches the option value stored on the dev site, this checking of key match doesn't help us.

In short, a dev Post URL need to be avoided to be triggered after an event has occurred for emails sent from live site. Maybe this could to be done on the MandrillApp side?


texts:
I'm working with the CiviCRM API and it's been great--I've been able to make a very useful tool for our team.  However, I've encountered a problem.

I would like to do a search on contacts based on a tag.  However, whenever I make a call to the database asking for a particular tag, I get an error.  The following is an example I used on the demo site:

CRM.api3('Contact', 'get', {
  "sequential": 1,
  "tag": "Company"
}).done(function(result) {
  // do something
});

I receive the following error in the response:

{
  "error_code": "no such field",
  "tip": "add debug=1 to your API call to have more info about the error",
  "is_error": 1,
  "error_message": "DB Error: no such field"
}

Now, I receive a different error in test use on my own site, but is it possible in some way to do a search in the API for a contact based on tag?


texts: Database Error Code: Access denied for user 'civi'@'localhost' (using password: YES), 1045

texts:
I encounter a really weird issue. I'm moving my CiviCRM install from an Ubuntu 14.04 server to an Ubuntu 16.04 server. Mysql is now 5.7.21.

CiviCRM version is the latest 4.7.30

The default SQL mode only_full_group_by is disabled.

If I connect using the terminal from the same localhost using the same username/password (I triple triple triple checked), it runs like a charm.

The CiviCRM page always shows a DB Error: unknown error (duh!). Enabling the backtrace gives me more info:

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

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] =>
SELECT  v.name as name ,v.value as value, v.grouping as grouping
FROM   civicrm_option_value_en_US v,
       civicrm_option_group_en_US g
WHERE  v.option_group_id = g.id
  AND  g.name            = 'wysiwyg_presets'
  AND  g.is_active       = 1  AND  v.is_active = 1  AND ( v.component_id IS NULL  OR v.component_id IN (SELECT id FROM civicrm_component WHERE name IN ("CiviEvent","CiviMember","CiviMail","CiviReport")) )  ORDER BY v.weight [nativecode=1045 ** Access denied for user 'civietui'@'localhost' (using password: YES)]

Any help much appreciated

Update

If I deliberately use a wrong username or password, I have a different error:

Initialization Error

It shows that somehow, Civi connects to the DB up to a certain point

update 2

mysql> show grants for username@localhost;

| Grants for username@localhost                                                        |

| GRANT USAGE ON . TO 'username'@'localhost'                                         |
| GRANT ALL PRIVILEGES ON civicrm_DB.* TO 'username'@'localhost' WITH GRANT OPTION |


texts: How to set permissions on an angular page

texts:
I have developed a basic angular page and forms which stores data in the database. However the data stored are settings and should only be accesible when a user has a permission for Administer CiviCRM.

How do I that? I don't have a Menu.xml where I would usually do that but I do have routing options in the angular controller.


texts: I need to echo "hello world" in civicrm how to do this in any page in civicrm? i'm trying to do this using hooks_civicrm_post but there is no result.


texts: Since Drupal 7.4x I am unable to upload/browse images in civicrm

texts:
kcfinder is not allowing me to browse or upload images. I get this error:

Sorry but we are not able to provide this at the moment.
You must be logged in with proper permissions to edit, add, or delete uploaded images.

I am logged in as User 1. It seems that kcfinder does not know that I am logged in.


texts:
I have to following use case:

I need to send SMSes to the guardians / parents of the event participants when the participants did not attend/no-show 15 minutes after the event starts.

I am incline to write a scheduled job to scan the civicrm status and then send out the SMS via the CiviCRM REST APIs.

Would this be the correct approach or there is already building blocks that are out-of-the-box that I can leverage on to implement the use case.

thanks.


texts:
I would like to install the Mosaico extension in a Windows server.
It's possible?
If yes there is a windows equivalent to setup.sh batch?
Thanks


texts: Where can I get the code that creates the progress bar for Personal Campaign Pages?

texts: When creating a Contribution Page, you can enable a widget and copy the code to create a progress bar wherever you want. I'd like to do that with some personal campaign pages, so that they are all on the same front-facing webpage to show who is winning a fundraising competition. I'm not finding an obvious way to do that, but I expect it is possible.


texts: Advanced Search AND Operator doesn't operate for Multiple Tags Search (at least)

texts: Have discovered recently while searching for multiple tags. Even if Search operator radio button AND selected, search for two tags returns results with OR logic. Mean, there is a contact, which has several tags assigned; search by selecting, say, two tags contact has, returns contacts tagged by one of tags, not both of them. Double- and triple-checked. Sounds like a bug, but not entirely sure, since no similar complains found. Will anyone with similar setup (mean, contacts with multiple tags), confirm it works / doesn't work, please.


texts: How to resolve issue with " Â " appears before currency sign?

texts: Whenever I export a csv from any report, if it contains a £ sign, there is always Â appears before. How to resolve it please? I am using civicrm 4.6.11, my mysql database characterset is set to "UTF8".


texts: "nativecode=1060 ** Duplicate column name 'created_id'" when upgrading from 4.4.14 to 4.6.2

texts:
Keep getting this error when Upgrading from 4.4.14 to 4.6.2 directly. I am upgrading based on the civicrm documentation.
Seems like civicm_mailing_abtest has some error. But I have checked I did not have this table in 4.4 version and it was created during the upgrade process.
How to deal with it?

DB Error: unknown error in unknown on line unknown
nativecode=1060 ** Duplicate column name 'created_id'
ALTER TABLE civicrm_mailing_abtest ADD COLUMN created_id int unsigned


texts: How to send subscriptions to a non-primary address

texts:
We would like to manage the sending of our magazine via CiviMember as « The Monthly » made it.

We have an additional problem: certain contacts wish to receive their subscription to an address different from the primary address, the primary address remaining the address for the others sendings.

Is there a (simple ?) way to associate a particular address with a membership ?


texts: How to disable or fix the wysiwyg editor on civimail

texts:
Oh joy of wysiwyg editors, that are going to alter the html you have so carefully typed to be compatible with all the mail clients in their glorious diversities...

For some mailings at least, I'd like to be able to tell the editor to stay home and let me type my html directly, as the W3C gods intended. Unfortunately, the setting to change the editor (CKEDITOR, tinyeditor or textarea) doesn't seem to be taken into account in civimail (or ab testing)

Is this a cache that I couldn't clear after the change (it worked fine for "normal" mail sendings, just civimail that ignored the new setting)?

Is there a bit of code to hack to make it work?


texts: Can ExtendedReports report on CiviDiscount usage?

texts: Can I get a list of Contacts that have used a specific CiviDiscount code? How do I extend - Extended Reports extension?


texts:
I have created a CiviRule that Triggers on "Email address is added" with a linked condition of "Field Value Comparison Email.is_primary = 1"
It is triggering and the action is happening. However, it is happening 2Xs. Which shows an error message to our users.
In API4, if I select Email > get -> Where Contact id = xxx; it shows 2 results.
If I select Email > get -> Where Contact id = xxx & ->Where email is primary - yes; it shows 1 result.
The activity that is happening when this triggers is a contribution from a first-time donor. Any ideas why the Link Condition above does not limit my trigger to 1X?
Thanks
Here are the screenshots of the Rule setup per request of jitendra

EDIT: I added more information being sent to the logs. I can now see the Email ID # along with the condition value (per suggestion of ErikH). It is not getting the correct condition on "Email is Primary=1". That is showing 1 for both times but the email table has one with 1 and one with 0.
I added to the condition "& Location Type=Home" Now it just processes the rule 1x.


texts:
I am getting this error message in Paypal (Live transaction) My sandbox (testing) working alright

  This transaction cannot be processed. The merchant's account is not able to process transactions.

Any help is much appreciated

Also we do have previous question similar to this issue but was 2 years old.
PayPal Website Payments Pro: This transaction cannot be processed. The merchant's account is not able to process transactions

Thanks in Advance `


texts: New Install "MYSql Server Has Gone Away"

texts:
Good evening, I'm new here and trying to get CiviCRM installed for the first time (volunteer sysadmin for a non-profit).
I think I have gone through all of the steps to troubleshoot but I suspect I am missing something.
Relevant Versions:

CiviCRM - 5.27.3
WordPress - 5.4.2 (Multi-Site enabled but only primary site exists)
Azure MySQL instance - 5.7.29-log
Linux (Separate from MySQL) - "Ubuntu 18.04.4 LTS"
PHP - PHP 7.2.24-0ubuntu0.18.04.6 (cli) (built: May 26 2020 13:09:11) ( NTS )
NGINX - nginx/1.14.0 (Ubuntu)

Attempted adjustments:

Initially ran into SSL issues (Had MySQL set to SSL Enforce) Found some requests to adjust CiviCRM to accommodate this but in the meantime turned off enforcement to try and get the install to work. (This got me to the error below, all other changes listed have had no impact)
Ran as admin user
Updated MySQL config options (Timeouts, Innodb, max sizes, etc.)
Updated php.ini settings (timeouts, reconnect, etc.)
Repaired/Optimized Wordpress DB
Manually ran in civicrm.mysql to create tables
Followed XKCD Flowchart (https://xkcd.com/627/) regarding "MySQL Server has gone away"
Searched for install logs to try and find what was causing the error (failed to locate)
Ended up here, the results from the check seem to contradict (connection works well for all things EXCEPT knowing if the server is there)

Thanks for any ideas/direction.


texts: Do compiled templates (in templates_c) contain URL data, or get corrupted?

texts:
I use price-sets with events, where users enter the number of seats/tickets wanted. Lately, and randomly, users get tickets added that they didn't order (e.g., they enter '1' at price_1 and after confirmation, they have '10' at price_2 in addition to '1' at price_1. Since it is random (and I haven't been able to reproduce it myself) I thought it was a browser/memory sort of problem. And, I understand that if BASEURL is not set correctly throught the session (Controller) can error out.
I don't know if this is due to session timeouts. I have cleared cache, checked configuration of paths, directories and all that. If a template were 'corrupted' could that cause it? And can I safely clear/refresh all the compiled templates under templates_c?
Civicrm 4.5 (will be updating soon ISA)


texts: Missing parameters error in Unsubscribe link for certain emails

texts:
CRM_Core_Exception: Missing Parameters in /var/www/html/public_html/crm/sites/all/modules/civicrm/CRM/Core/Form.php on line 608
Exception trace
#   Function    Location
0   CRM_Mailing_Form_Unsubscribe->preProcess()  /var/www/html/public_html/crm/sites/all/modules/civicrm/CRM/Core/Form.php:608
1   CRM_Core_Form->buildForm()  /var/www/html/public_html/crm/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php:76
2   CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Mailing_Form_Unsubscribe), 'display') /var/www/html/public_html/crm/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php:203
3   HTML_QuickForm_Controller->handle(Object(CRM_Mailing_Form_Unsubscribe), 'display')  /var/www/html/public_html/crm/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php:103
4   HTML_QuickForm_Page->handle('display')  /var/www/html/public_html/crm/sites/all/modules/civicrm/CRM/Core/Controller.php:347
5   CRM_Core_Controller->run()  /var/www/html/public_html/crm/sites/all/modules/civicrm/CRM/Utils/Wrapper.php:98
6   CRM_Utils_Wrapper->run('CRM_Mailing_Form…', 'Unsubscribe', Array)   /var/www/html/public_html/crm/sites/all/modules/civicrm/CRM/Core/Invoke.php:285
7   CRM_Core_Invoke::runItem(Array) /var/www/html/public_html/crm/sites/all/modules/civicrm/CRM/Core/Invoke.php:68
8   CRM_Core_Invoke::_invoke(Array) /var/www/html/public_html/crm/sites/all/modules/civicrm/CRM/Core/Invoke.php:36
9   CRM_Core_Invoke::invoke(Array)  /var/www/html/public_html/crm/sites/all/modules/civicrm/drupal/civicrm.module:458
10  civicrm_invoke('mailing', 'unsubscribe')    /var/www/html/public_html/crm/includes/menu.inc:527
11  menu_execute_active_handler()   /var/www/html/public_html/crm/index.php:21
12  {main}
 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.
Missing Parameters
Return to home page.

This is what is displayed for users when they click on the unsubscribe link in certain emails. This appears to be when certain templates are used. Can anyone advise?
Civi CRM 5.35.2
Example URL for user: https://crm.elifesciences.org/crm/civicrm/mailing/unsubscribe?reset=1&jid=&qid=&h=


texts: Bounce processing - will fail for G Suite users when Google disables less secure apps in Feb 2021

texts:
Google have announced they are stopping support of less secure apps in G Suite in Feb 2021. No new LSA connections will be allowed after Jun 2020.

Google have advised me that the email accounts I'm using for Bounce Processing and Email-to-Activity Processing are affected by this.

Google's advice is "For any other LSA, contact your admin or ask the developer of the app you are using to start supporting OAuth".

Are there any plans for CiviCRM to support connecting to IMAP or POP using OAuth authentication?


texts: civicrm.org website old what/whatiscivicrm redirect to explore-civicrm

texts:
I am using my older, ancient 4.4.5 wordpress version of civicrm (I am about to upgrade it) but I think this link is hard coded. In my site when going to the menu Help...About it links to

https://civicrm.org/what/whatiscivicrm

I get "page not found". To make the user experience of all old civicrm installations one step better and not make them take the time to look for an updated link like I had to do I think it should redirect to

https://civicrm.org/explore-civicrm

I believe https://issues.civicrm.org is where this needs to get reported eventually but I wanted to ask here first.

What next step can people recommend?


texts:
I'm getting thiis error, when I try to install civicrm on Drupal 8 and 9
The following packages have new compilation tasks:

civicrm/composer-compile-lib has 1 task
civicrm/civicrm-core has 1 task

Allow these packages to compile? ([y]es, [a]lways, [n]o, [l]ist, [h]elp) y
Compiling additional files (For full details, use verbose "-v" mode.)
Compile: Generate CCL wrapper functions
Compile: Greenwich CSS (dist/bootstrap3.css)

@php -r 'require_once '''/home/bvivaccinate/public_html/vendor/autoload.php'''; Civi\CompilePlugin\TaskTransfer::import(); \CCL::copy('''../../bower_components/select2/select2-bootstrap.css''', '''extern/select2/select2-bootstrap.scss''');'
@php -r 'require_once '''/home/bvivaccinate/public_html/vendor/autoload.php'''; Civi\CompilePlugin\TaskTransfer::import(); \CCL\Tasks::scss($GLOBALS["COMPOSER_COMPILE_TASK"]);'
Script @php -r 'require_once '''/home/bvivaccinate/public_html/vendor/autoload.php'''; Civi\CompilePlugin\TaskTransfer::import(); \CCL\Tasks::scss($GLOBALS["COMPOSER_COMPILE_TASK"]);' handling the shell-runner event returned with error code 255
Subcommand @composer compile  returned with error code 255

Installation failed, reverting ./composer.json and ./composer.lock to their original content.
[RuntimeException]
Subcommand @composer compile  returned with error code 255
These are the commands I ran to install it for drupal 9
php composer.phar create-project drupal/recommended-project
php composer.phar require pear/validate_finance_creditcard:dev-master
php composer.phar config extra.enable-patching true
php composer.phar require civicrm/civicrm-asset-plugin:'~1.1'
php composer.phar require    civicrm/civicrm-{core,packages,drupal-8}:'~5.37.2'
Composer version 2.0.13
PHP 7.3.28
Can someone please assist


texts: Using the link to Set up a Personal Campaign Page gives 404 page error

texts: Sorry, I'm a newbee at CiviCRM, and frankly, I find the instructions aren't so clear. I'm trying to set up Personal Campaign pages for a fundraiser we are doing. I enabled the Personal Campaign Page settings on my contribution page, but when I click on the link it provides, it goes to a 404 page error. So I figured that maybe I needed to add short code to a new Wordpress page. The CiviCRM component isn't giving me the option for Personal Campaign page. What is the short code I should be using?


texts: "Cannot redeclare class CRM_Core_ClassLoader" in backup site

texts:
I had a civicrm 4.4.6 site in my drupal 7 subdomain, which is beta.mydomain.com.
I want to have a backup site to perform update on civicrm, but it shows:

  Fatal error: Cannot redeclare class CRM_Core_ClassLoader in
  /home/mydomain/www/backup/sites/all/modules/civicrm/CRM/Core/ClassLoader.php
  on line 36

Below is my setting scenario:

I created a subdomain, backup.mydomain.com, and copied all the files from beta site to backup site.

In beta site, these are the database: civicrm (drupal default database)  and civicrmdb (civicrm database)

I had copied the database, as backup_civicrm and backup_civicrmdb

In backup site, I made the following changes:

sites/default/settings.php : change database name to backup_civicrm
sites/default/civicrm.settings.php :

define( 'CIVICRM_UF_DSN' ) :    change to  backup_civicrm
define( 'CIVICRM_DSN' ) : change to backup_civicrm
$civicrm_root = '/home/mydomain/www/backup/sites/all/modules/civicrm';
define( 'CIVICRM_TEMPLATE_COMPILEDIR', '/home/mydomain/www/backup/sites/default/files/civicrm/templates_c/'
);
define( 'CIVICRM_UF_BASEURL' , 'http://backup.mydomain.com/' );
define( 'CIVICRM_MAIL_LOG', '/home/mydomain/www/backup/sites/default/files/civicrm/templates_c/mail.log' );

After configuration, my backup site shows error:

  Fatal error: Cannot redeclare class CRM_Core_ClassLoader in
  /home/mydomain/www/backup/sites/all/modules/civicrm/CRM/Core/ClassLoader.php
  on line 36

I had cleared all the files in sites/default/files/civicrm/templates_c , and it does not work.

I found that when I change $civicrm_root to beta, it works.

$civicrm_root = '/home/mydomain/www/beta/sites/all/modules/civicrm';

This is weird. I need to perform upgrade on civicrm, if the root is link to beta, I'm not sure how this will affect my update.

Am I missing out any configuration? Any idea on what is the problem?


texts: Providing opt-out link when sending an email directly from a contacts record

texts: does anyone know if the "{contact.is_opt_out}" token works when sending an email directly from the contact record. On testing, I can't seem to get it to work. No link appears in the message in the email inbox. Thanks!


texts: Primary Emails not Being seen as primary

texts:
I have an a bunch of organizations we imported via csv. The email addresses are checked under the contacts summary as 'primary'. However they are not receiving emails and reminders and in search results no email is showing. If I go into the record and click on the email section and then click 'save' the email is then seen as primary.

I am wondering if there is a way to fix this in bulk. It's not that many records (approximately 200-300). Any suggestions would be great.

CiviCRM 4.7.27 with WordPress 4.9.5

Thanks


texts: We have accidentally attributed a credit card donation to the wrong person. How can we change the donation to the correct donor? Do we have to delete the donation on one record and add it to the other? Thanks!


texts: How can I generate an internal URL to a CiviCRM page based on certain parameters?

texts: What functions exist within CiviCRM that make it easy for me to generate internal URLs?


texts: Google ReCapcha causes error on membership contribution page

texts:
Joomla:  3.4.4
CiviCRM: 4.6.8
PHP:     5.4.43

I have a membership application setup that used to work fine with the v1, Google ReCapcha.  However, the new version, while it displays fine, causes an error when the user clicks continue to head to PayPal.

Scenario:

User fill out membership form.  At the bottom is the new ReCapcha box.
User clicks the box, gets the checkmark.
User then clicks 'Confirm Contribution' button.
Confirmation screen is displayed for user verification of data.
User then clicks 'Continue' to head to PayPal.

Screen redisplays with error at top of page:

Error

The CAPTCHA solution was incorrect

Interesting part - user's data is entered into CiviCRM database, Contribution is listed as 'Pending (Incomplete Transaction)', but no Joomla user record is created.

Any advice would be appreciated.

Form works fine without capcha ..

8


texts: Is there a limit to the number of soft credits you can add to a contribution? If so, is there a way to change the limit?


texts:
Already mastered the system. Faced problems, but not here they helped to solve them, for which many thanks.
There was another question, the answer to which I can not find anywhere else.

1) I set up work with incoming mail, but all the letters go to the “Actions” tab, in the client's card. So it should be? Shouldn't they go to the "Newsletters" tab?

2) Where can I read about the organization of work with incoming mail? What is the best way to work with him so that it is most convenient? Are there any real examples of the organization of such work?

3) Is there some kind of Russian-language help, or forum?

Postscript I apologize if someone asked such questions somewhere. I do not know English, because it is difficult for me to understand a huge amount of information.
Give thanks!


texts: CiviEvent: prevent registered users from changing their data

texts:
I'm running a CivicCRM installation od Drupal 7. I'm launching our first Event page with online registration - everything seems clear, except one thing: I'd like to prevent registered users from changing their data in the registration form. The form profile consists of Name, Surname and e-mail from Individual/Contact type, so registered users have these fields 'connected' with their crm record. Any change goes straight to the database and I'd like only anonymous users to edit these fields.
Can it be done just by configuration (ACLs maybe?) or does it require a custom plugin?


texts:
I've tried to create a rule where an email gets sent when a contact is "added" to a smart group.  By "added" I mean the condition that smart group is based upon is met.

As far as I can tell it doesn't.  It seems like it would be hard to do.


texts: Civicrm 4.7.20 Register event participant - pay by creditcard

texts:
just updated to civicrm 4.7.20 - I wanted to register a late event participant used Register Event Participant in the past.  I can select the event and price but if I check 'record payment' the payment block with CC #, ccv and expiry doesn't come up. I did this once and seemed to get the Contact info page plus a link to enter credit card information.
What is the correct way to get the payment block (not just the priceset for the event) to come up?


texts: Autoassign relationship when creating contact

texts: I'm looking for a way to auto-assign relationships between the current drupal user and created contact. I know there is extension CiviRelate, but it only works when using "profiles". I'm looking for a way to auto-assign selected relationships when the user creates contact from the CiviCRM backend (from the dashboard).


texts: File Upload / Insert Image crashes browser

texts:
Running the latest version 4.7.29 on Wordpress 4.9.2.

Using either CKEditor or TinyMCE if I attempt to "browse" the server for an image it locks up the tab and has to be killed. I use DUO Security and if this plugin is enabled it logs the session out immediately and prompts for re-authentication instead of locking up the tab. This loops indefinitely)

I have checked the paths on the file system and urls and all are ok. I have checked permissions and all are ok. I can see no errors in my access logs and get no debug information as it locks up the tab.

I'm at a complete loss with it.

Any help / suggestions welcome.

Variables in use:

**Settings - WordPress Integration:** https://abc.org/civicrm

$civicrm_root = '/var/www/html/wp-content/plugins/civicrm/civicrm/';
  define( 'CIVICRM_UF_BASEURL'      , 'https://abc.org/' );

**CiviCRM Resource URL:** [civicrm.root]/
**Image Upload URL:** https://abc.org/wp-content/uploads/civicrm/persist/contribute/
**Extension Resource URL:** https://abc.org/wp-content/uploads/civicrm/ext/


texts: CiviCase dashboard shows cases for invisible contacts

texts:
iam using CiviCRM 5.25 and Drupal 7.71. I have a bunch of acls running to limit the access to contacts, so with using CiviCase it controls the limited access for case managers to contacts, or more specific: to clients. therefore related permissions module is also running. Normally the limited access is working fine, even on the search pages (!).

But the CiviCase dashboard civicrm/case?reset=1 is not working this way. The CiviCase dashboard show too much cases. As well the overview table as the activites results shows cases the case managers should not see, because the manager is not allowed to see many of this contacts (clients). If i hit a contact name, i get the permission issue and i can't access the contact, this is expected behaviour.

So, the permission on this page is set to "access all cases and activites", which should mean "... for visible contacts", but "for visible contacts" is not working. Is anyone who can confirm that?


texts: 404 css and js not found, wrong [civicrm.root]

texts:
a fresh install on Joomla 3.6.4 with CiviCRM 4.7.13 results in countless 404 errors

All files of those locations are not found:

css
bower_components
packages
js

It tries to find the files from those folders in the wrong location:
/home/...serverinfo.../www/...website.../components/com_civicrm/civicrm

but the correct location would be:
/home/...serverinfo.../www/...website.../administrator/components/com_civicrm/civicrm

The variable: [civicrm.root] is set correctly including the administrator folder

The civicrm.settings.php is defined like this:
$civicrm_root = '/home/...serverinfo.../www/...website.../administrator/components/com_civicrm/civicrm/';

Please, is there anywhere else where I can look for a wrong configuration of the [civicrm.root]?

Thank you


texts: Remove required field in Grant Application

texts: The Grant module requires "Amount Requested" when entering a grant.  This information may not be available when the grant is created.  Why is this a required field?  How can we make it optional?  Workaround is to make it 0.


texts: How do I update CiviCRM following a security update?

texts:
I am getting a warning to update security. It says:

  New security release 4.7.9 is available. The site is currently
  running 4.7.3.

How do I update it?

Thanks.

Melissa
Brooklyn Commons
commonsbrooklyn.org


texts: Error Backing Up Database using drush: Call to undefined function drush_sql_dump_execute()

texts:
I am running Drupal 7.37 and CiviCRM 4.3.8. I am in the process of upgrading both, but currently get an error when manually creating a backup of the CiviCRM database. All regularly occurring daily backups are fine.

I used this command:

root@web:/path/to/docroot# drush civicrm-sql-dump > ../civicrmdatabase-backup1610312230.sql

Which returned:

PHP Fatal error:  Call to undefined function drush_sql_dump_execute() in /var/www/html/civicrm/v4.3.8-d7/drupal/drush/civicrm.drush.inc on line 959
Drush command terminated abnormally due to an unrecoverable error. Error: Call to undefined function drush_sql_dump_execute() in /var/www/html/civicrm/v4.3.8-d7/drupal/drush/civicrm.drush.inc, line 959

It may be helpful to know that I am using a symlink from the Drupal modules folder to the civicrm install folder for now. Any insight into this error or an alternative to taking an immediate backup without installing anything would be appreciated, thanks!


texts:
Right now I am using the API Explorer (in 4.7.21) just to get the pieces I need for some custom code in Drupal.  I am just very confused about what the API Explorer is returning.  I am guessing this me not a bug.

If I execute the following with the Case ID of 223 then I should get back the contact assigned to that case.

$result = civicrm_api3('CaseContact', 'get', array(
  'sequential' => 1,
  'return' => array("contact_id"),
  'id' => 223,
));

When I execute this I get the contact for case 224.

If I use the API to query for the Subject of the case for ID 223 I get the expected results and the same for 224.

$result = civicrm_api3('Case', 'get', array(
  'sequential' => 1,
  'return' => array("subject"),
  'id' => 223,
));

If anyone sees my error here I would appreciate it. If this is a bug I am glad to put it only issues.civicrm.org.

Thanks!


texts: After updating civi 4.6.15 to 4.6.16 no access to contacts

texts:
After succesfull updating civicrm 4.6.15 to 4.6.16 (files are installed database is updated), I find that access to contactdata in the admin side of my joomla 3.5.1 website has gone. I get a white screen, and after going back to the previous page I get an error notive that says: "Invalid Entity Filter"

I flushed the cache but that does not change anything.
At the frontend of the website I can change my contactdata and save them and get the usual okay message after that. I cannot open the samen contactdata in the backend.
I recreated the site from a backup updated again and got the same results again.

I updated another joomla 3.5.1 site with the same civi version 4.6.15 and that went without any problems.

I set error reporting to maximum in Joomla and do not get any errormessages at all only an empty white screen.

As advised in the comment below I checked the error log inside civicrm.

I got this error-message in a sea of messages:

"$Fatal Error Details = array(3) {
  ["message"]=>
  string(21) "Invalid Entity Filter"
  ["code"]=>
  NULL
  ["exception"]=>
  object(CRM_Core_Exception)#448 (10) {
    ["errorData":"CRM_Core_Exception":private]=>
    array(1) {
      ["error_code"]=>
      int(0)
    }
    ["cause":protected]=>
    NULL
    ["_trace":"PEAR_Exception":private]=>
    NULL
    ["message":protected]=>
    string(21) "Invalid Entity Filter"
    ["string":"Exception":private]=>
    string(0) ""
    ["code":protected]=>
    int(0)
    ["file":protected]=>
    string(105) "/home/--deleted--/civi/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/CustomGroup.php"
    ["line":protected]=>
    int(658)
    ["trace":"Exception":private]=>
    array(14) {
      [0]=>
      array(6) {
        ["file"]=>
        string(105) "/home/--deleted--/civi/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/CustomGroup.php"
        ["line"]=>
        int(449)
        ["function"]=>
        string(23) "validateSubTypeByEntity"
        ["class"]=>
        string(24) "CRM_Core_BAO_CustomGroup"
        ["type"]=>
        string(2) "::"
        ["args"]=>
        array(2) {
          [0]=>
          string(10) "Individual"
          [1]=>
          string(14) "Verenigingslid"
        }"

So: the code trows an exception. However I do not know why. I am logged in in the backend of joomla as superuser, so I should getaccess to all groups in civicrm, with no private execeptions???


texts: Membership Details Report doubt about Grouping

texts:
In the Membership Detail Report there is the tab 'Grouping'. Is this tab really necessary?

Every membership has an unique id so it doesn't seems logic to group by this field.

I did some test in my civicrm and in dmaster and in both sites the results were the same whether or not the grouping field was selected.

So, it is useful? Or I'm mistaking something?


texts: What could trigger a transaction rollback on contact save?

texts:
I have a few contacts in CiviCRM 4.7.27 for which changes in the "edit contact" form are not saving. The update queries are being sent to MySQL correctly, but they're in a transaction which is being being ended by a ROLLBACK statement, which obviously undoes the changes.

For all other contacts, changes save just fine, with no ROLLBACK.

Example queries from a single "Save" form submission:

UPDATE  civicrm_contact  SET contact_type = 'Individual' , contact_sub_type = NULL , sort_name = 'jones, jennifer' , display_name = 'jennifer jones' , first_name = 'jennifer'   WHERE (  civicrm_contact.id = 3198 );
UPDATE  civicrm_uf_match  SET domain_id = 1 , uf_id = 6839 , uf_name = 'jnphillips_22@msn.com' , contact_id = 3198   WHERE (  civicrm_uf_match.id = 2754 );
UPDATE civicrm_group g SET    cache_date = NULL, refresh_date = NULL WHERE  g.cache_date <= '20180503151700';
UPDATE civicrm_setting SET value = 'LnnjD1Un' WHERE name='navigation' AND contact_id IS NOT NULL;
UPDATE civicrm_contact SET  email_greeting_custom = NULL , email_greeting_display = 'Dear jennifer', postal_greeting_custom = NULL , postal_greeting_display = 'Dear jennifer', addressee_custom = NULL , addressee_display = 'jennifer jones' WHERE id = 3198;
... (and lots of delete/insert on civicrm cache tables.)

How can I track down the source and cause of this ROLLBACK statement?


texts: Taxes on "Allow other amounts" calculated on $1

texts:
This was noted back in 2015 I see (Why are taxes calculated incorrectly when "other amounts" enabled on contribution page?). It doesn't seem like it would be hard to fix, but here we are almost 5 years later and the problem persists. It works in a price set, so there is a workaround, but it's a little uglier there when used for simple scenarios.

In this case, the tax rate is 13%. Calculated properly if fixed options are provided below, but calculated on 1 if the "allow other amounts" is checked and the box is used. I assume it is using the same logic that it does in a price set where it sets the value to $1 and then uses the box as a quantity. However, the tax calculation step is seemingly performed too soon.
Any chance it could be fixed? Happy to take a pointer to the related file(s) to have a look for myself.


texts:
we've run into an error (See screenshot) either when we fill out the event registration form and wait a while (an hour or so) and submit it then or when we click on "back" after submitting successfully.
Otherwise it works but there should be a more user-friendly message that i.e. the session is expired.
Any ideas on how to solve this?
Thanks in advance!


texts: Fatal Civi Error: "Invalid cache key: Not a string" error in Wordpress

texts:
I'm using Wordpress 4.9.9 and CiviCRM 5.4.1. Earlier today I updated several plugins, everything works fine except Civi.

** UPDATE: With civi activated, I get a blank page any time I try to edit a Wordpress page.

I also get a blank page when I try to go to the Civi dashboard in Wordpress and I cannot access any Civi pages such as event registration or membership pages.

In a Wordpress log I get:

2019-02-14T22:19:10+00:00 CRITICAL Uncaught CRM_Core_Exception: [0: Invalid
cache key: Not a string

thrown in /var/www/vhosts/<site>/httpdocs/wp-
content/plugins/civicrm/civicrm/CRM/Utils/Cache.php on line 236

That code is in the assertValidKey function.

Any ideas on where to go from here?


texts: In 4.7 the activity 'Assign Case Role' is assigned to the client: is this a bug?

texts:
I can reproduce this on the 4.7 demo.

I create a case of type 'Adult Day Care Referral' for client Rebekah Adams.

Using the civicrm/contact/view/case screen, I assign the role 'Health Services Coordinator' to Junko Adams. I use the 'pencil' icon to do this.

The role is assigned to Junko Adams, but the 'Assign Case Role' activity is assigned to Rebekah Adams (the client) and the subject is 'Health Services Coordinator is : Dr. Rebekah Adams'.

That's confusing, and if an email is sent to the client, that could be nasty.


texts: cf-civicrm State/Province field dropdown not populating after country is chosen

texts:
I've just started working with the cf-civicrm plugin so I may be missing something simple.
I can't get the CiviCRM State/Province select field to fill. I tested it using the "CiviCRM Contact and Address" form template after running into the issue on a form I was building. No luck. The field just returns N/A for every country I've tried.
My experience has some parallels to this github issue but the fix that worked for rbaugh isn't working for me.
Questions, tip and pointers about how to resolve this would be most welcome.
Thanks!