Has this member data been encrypted? Update 11-11-2019 See my answer below.

When dumping a Drupal CiviCRM database to move and convert to a new WordPress install, I've found that the membership data appears to have been encrypted; these random character strings appear in WordPress in Memberships>Dashboard, i.e. bs00fgcb for name, hgaibbsf@example.org for email, etc. But the two letter state abbreviation isn't a random string.

The garbage data appears in the database dump when viewed with a text editor, before I import into the new database.

No other database data seems to be affected, and CiviCRM appears to run fine in WordPress, other than the data display above.

Does this appear to be encryption? There are no encryption modules in Drupal (no Drupal Encrypt) that I can see., nor CiviCRM extensions Where would I find the functions that do the encryption and decrypting? In Drupal [cms.root]/sites/default/files/civicrm/custom/? Or could encryption be done at the MySQL level?

CiviCRM is the same version between Drupal and WordPress; same MySQL database and encoding (both sites are on the same server). Database collations are exactly the same between the two: latin1_swedish_ci. No other data is corrupted. I've tried importing multiple times.

There is no encryption in CiviCRM. This sound something that your database dump got corrupted. Or that you imported in a database with another collation (character set) than the source database.


CiviCRM for animal rescue charity CiviCRM newbie here. I am interested in whether CiviCRM and Wordpress could be used to manage an Animal rescue and rehousing charity.
In addition to tracking all the usual stuff like donations, events, volunteers, etc., they would need to manage:

Details of each rescued Animal and all relevant details such as location (foster home or adopted home, kennels, etc.), medical info, statistics, etc.
Lists of available foster homes
Adoption applications

Ideally, a solution that could list available animals on Public Wordpress Website, from the backend.

Is CiviCRM something that could handle this scenario, without too much additional development?

Thank you.

Look into CiviCase for planning and tracking each animal's adoption appointments, vet visits, groomings, etc.

CiviEvent has integrated location/venue components that might be useful in organizing your fostering and other volunteer activities.

CiviContribute would be my first choice in setting up adoption applications, complete with payment tracking and reporting.

Short answer, yes: it can be done with CiviCRM on a WordPress site. Might even find the BuddyPress plugin useful in tandem with Civi to energize social communication and networking among volunteers and related animal advocates.

Good luck Mark!


Migrating to WPEngine I'm working on migrating our Wordpress site to WPEngine, and I don't know how to get the civi database onto WPEngine. WPEngine doesn't allow the creation of a new database for civi. Has anyone done this before? I have found other topics regarding WPEingine here, but for now I just want to get the database onto WPEngine.

I have only used CiviCRM at WPE on test sites.

You will have to share the same DB as WP.

You need to prepare teh backup for restore offline.   That said, I mean that if backed up from another server, the DEFINER (used in Triggers and Routines) have to be stripped out, and the database should be compressed.   You'll need to restore via phpmyadmin from my.wpengine.com

A word of warning, WP Engine reserves the right to change the database user.   When they do this they will update wp-config.php, but not civicrm.settings.php.   This has not happened to me on CiviCRM (keep in mind I only use WPE for testing on CiviCRM) , but it has happened on WP sites I have supported at WPE.


Directory Paths: Make them portable I got this warning status message. How can I fix this error? TIA]1

I understand messages like this can be worrisome but the msg actually tells you exactly what you need to fix the problem, eg it is suggesting you replace what you currently have set as the paths with the tokens shown. Try clicking on the 'Directories' link and then reading the help message that you will find there. If you need more help then paste a screenshot or the string in the 'paths' that you currently have, and someone will help coach you through which bits to replace with eg [cms.root]


I would like to categorize the Contribution pages I would like to categorize the Contribution pages.
How can I use Tags or Groups for that?

Welcome!  Tags and Groups are concepts that apply to Contacts, not Contribution Pages.  It depends what you want to do with the categorization, but Campaigns may be useful.

If you don't see Campaigns in the top menu, you may need to enable the CiviCampaigns component at Administer > System Settings > Components


Request for help getting Stripe Payment Processor working in CiviCRM/Wordpress I'm testing Stripe for payment processing in CiviCRM.

I have the latest Stripe Payment Processor extension (4.7.3)

And I'm running Wordpress 4.9.4/CiviCRM 4.7.27

I have a user side payment page that when I put in all the test data, and press the "Confirm Contribution" button, nothing happens, except the button changes to "Submitted".

I can't see any errors in the CiviCRM depug log in wp-content/uploads/civicrm/ConfigAndLog

As far as I know, I'm using the correct API settings for test mode in Stripe.

My Stripe API version is 2018-02-06. And because this is a new Stripe account, I can't select an older API to see if that works.

This same non-activity happens whether i'm on the user side, or on the CiviCRM Admin side.

I don't know where to look to find errors, because all the usual places I would look don't seem to be showing errors...

Thanks for any help,
Norman

Soooo....

I found the problem. My API key had managed to get spaces in it, presumably when I copied it from the Stripe interface. I didn't see the spaces because the text is obfuscated like a password.

The fact it had spaces was causing a Javascript error. Which didn't come up ANYWHERE in the interface, until I had the Chrome developer tools open. And I suddenly noticed the error on the console.

Ultimately, it would be really helpful if such errors were reported to the user. Possibly only when CiviCRM debug mode is on.

But not displaying those errors meant I wasted a whole bunch of time trying to track the problem down... :-(

Cheers,
Norman


Activating CiviCRM in Wordpress returns a fatal error, this is on windows10, all works until activation Array and string offset access syntax with curly braces is no longer supported in C:\xampp\htdocs\testsite\wp-content\plugins\civicrm\civicrm\Civi\Core\Paths.php on line 203
CiviCRM Version 5.32.2 and WordPress 5.6

My assumption is that you are using PHP 7.4. Dat version does not support curly braces syntax. See this answer on stackexchange https://stackoverflow.com/questions/59158548/array-and-string-offset-access-syntax-with-curly-braces-is-deprecated . A downgrade to PHP 7.3 will help. That is also the highest supported version, see https://docs.civicrm.org/installation/en/latest/general/requirements/ .
Another option is to fix the issue and create a patch for it. A remark on the https://lab.civicrm.org/dev/core/-/issues/1496 will also help.


How to specify which Activity Types should trigger notifications to the Assignee Currently the setting at civicrm/admin/setting/preferences/display?reset=1 (pls don't ask why it is a Display Preference!) is just an On/Off switch.

Looking in to providing an extension so the Activity Types could be specified to include/exclude.

Anyone taken any steps in this direction already?

Yes!  This is one of the use cases described for CRM-20638  It provides a hook that your extension could use to select which activity types to include/exclude. There is a PR from May waiting for review if you can help with that.


What are the Drupal modules most used with CiviCRM? I can see which CiviCRM Extensions are most used at this link.

I've just installed the Masquerade Drupal module, and want to see what else I might want to be using.

Is there an equivalent listing and ranking of the Drupal modules that are most used with CiviCRM?

I am quite curious about why you are asking this question. My advice would be to install only modules when you have functional need and those modules solve them for you.

It might be even that a module which is used often is completely useless in your context. Or that it breaks other needed functionality.

Having said that the masquerade module is very handy one. Same as views and webforms.


How can I pass in the contribution amount via URL? Is there a quick way to pass in the contribution amount via URL on custom amounts?

http://example.org/civicrm/contribute/transact?reset=1&id=2&price=35

I'm not looking to use a price set, just a total amount. Ideally, I'd like to pay an existing contribution and bring up a form with the amount and contribution to pay against with a credit card.

I just tried this on CiviCRM 4.6.18 and successfully passed the amount through using the field Name or id (inspect the field to find the name or id)
In the case of my form I did this:
http://example.org/civicrm/contribute/transact?reset=1&id=2&price_5=35


Issue with CiviMail reports after upgrade to 5.19.0 I upgraded to 5.19.0 and noticed that every report for completed mailings listed on the Find Mailings screen is now showing this message in the Delivery Summary section:

Delivery has not yet begun for this mailing. If the scheduled delivery date and time is past, ask the system administrator or technical support contact for your site to verify that the automated mailer task ('cron job') is running - and how frequently.

Despite this, the reports still show the Click-through Summary and other sections.

I see this issue on both my production and development systems. I tried clearing cache. Other CiviMail reports (from the Reports tab) seem to be correct.

CiviCRM 5.19.0
Wordpress 5.2.4
PHP 7.2.21
MySQL 5.7.23

I believe this is fixed with https://github.com/civicrm/civicrm-core/pull/15780. It will be hopefully included in a point release that should come out soon for 5.19


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

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

First I go to the contact's event tab.

Then I add a new event registration and get this:

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

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

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

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

As per my knowledge CiviCRM  for version >= 4.6 never allowed to do offline credit card payment either for event registration or membership purchase or record of contribution for Paypal Standard payment processor or any other processor that is Website based gateway i.e payment information like credit or debit card not collected from CiviCRM forms. It does allow for payment processor like Paypal Express or Pro. Even i believe for Paypal standard CiviCRM doesn't show credit card section on online form. Adding paypal pro payment processor might be helpful.

Thanks

Pradeep


What is the purpose of the "default invoice payment page" field in the CiviContribute Component Settings page? All i can find on this is a fairly unclear thread on this site at Pay later online? - nothing in the documentation at all.

"Default invoice payment page" setting is used to set contribution page that can be used to pay pending or partially paid contribution using payment processor.

More about the setting and uses:

Wiki: https://wiki.civicrm.org/confluence/pages/viewpage.action?pageId=346750980

CRM Issue: https://issues.civicrm.org/jira/browse/CRM-19263

HTH
Pradeep


Contact Names showing up on Google Search even when they are not public All of our contact first name & last name are appearing visible on our site even when they have requested not to be. It is pulling their contact id and putting it into a public directory drupal view. We have an opt-in public directory that shows certain fields when the radio button is "Yes". We've been able to hide the email address, etc. but the name should not even appear unless we give it permission. Anyone else has this problem? Thanks in advance.

I took a look at this.  The pages that listed individuals' names were pulling the Display Name for the page title via civicrm_entity.  So even when though the filtering was working correctly to not display the View, the name would still come through.  It was corrected by giving a generic title and moving the name into the View.


PDF formats page margins not applied I have recently upgraded from CiviCRM 4.6 to 4.7. I have custom PDF page formats set up for PDF letters for mailing. When I apply these custom PDF formats to the PDF letter templates, the page margins I set up in the PDF formats are not applied to the letter templates and don't display in the margins fields in the expanded template section.

How can I fix this?

It could be related to this bug, fixed in 4.7.14:

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

Could you re-test in the latest version to see if it has been resolved?


Wordpress CiviCRM groups, members and permissions We are looking to use a Wordpress Multisite / CiviCRM integration and have a multisite development environment setup. We're not sure whether we should be using CiviCRM or Wordpress (or a combo) to establish permissions.

Here's a rundown of the user groups / permissions that we need to establish:

BACKEND USERS

Admin (2) - access everything, create new site

FRONTEND USERS

Committee member (10+) - add/delete documents specific to committees
State Manager (8+) - add/edit/delete members within the state. Add documents for downloading
Members (2500+) - when logged in can search for other members (all states), edit their own details and access private documents.
Public - access unrestricted content only.

Q. We want to limit access to the admin system to the Admins only and get State Managers to add/edit/delete via the frontend. Is this possible?

Q. We want committee members to be able to upload documents via the frontend that can only be viewed by other committee members. Is this possible?

Q. Can member login data (usernames & passwords) be stored in the CiviCRM or do all members need to be Wordpress users also?

Q. Would the Committee members be best setup as groups?

Q. Does anyone have a diagram of how the Members / Groups and other permissions work across a Wordpress integration?

I can answer some of these questions:

CiviCRM doesn't store usernames/passwords on its own.  It integrates with the Wordpress authentication system
You create user roles in Wordpress' User Role Editor.  You can then go into CiviCRM and grant CiviCRM permissions based on Wordpress role.
Because you say you want users to "upload via the frontend" and mention that they have logins - I assume you mean that these are users who have permissioned access to Wordpress, but not CiviCRM.

With CiviCRM, you should:

Enable a user dashboard (to allow contacts to edit their own contacts);
Create a search profile (to enable members to search for other members);
Create ACLs (to allow you to restrict access to contacts based on their committee membership);
Create several document submission profiles, to allow folks to submit/search documents that they're supposed to be able to see.  I imagine I'd create a CiviCRM contact for each committee, then create a profile submission form that allows permissioned users to add activities with attachments to that user.

I could also see a different approach where the documents are stored in Wordpress and permissioned that way, but I don't know enough about Wordpress to know if that's feasible.  I'm thinking of a feature similar to Drupal's Organic Groups.


Contacts visible in mailing list group, not on hold or otherwise dnd, but skipped by mail out I'm fairly sure I've worked out why this is happening, but want some input to confirm the problem, and hopefully pointers for fixing it.

We totally refreshed our main mailing list in line with GDPR, so we've been mailing about 2000 people with only a handful of bounces and unsubscriptions; now suddenly with our latest mail out, CiviCRM is only finding half of these people. Looking at the group, they're still there, and only a dozen of these are on hold due to bounces. Anyone who unsubscribed isn't counted towards the group total, so that's not the issue. Checking for duplication, it's not that we accidentally created 1000 duplicate contacts, so that's not the issue.

What has happened between this mail out and the previous one is that I've imported additional contact info for a lot of our contacts, and although the emails have been matched, so the contact records have been filled rather than duplicated, the newly imported emails have all been added as 'Home' - and the original email was 'Main', or 'Work', or 'Billing'...

Which is fine, if messy - lots of duplicated emails in records, but all the info is in the correct contact record. The problem - as far as I can work out - is that none of the emails have been marked as the one to be used for bulk mailings, and rather than default to the primary email for those contacts, CiviMail simply skips those contacts completely.

So, assuming I haven't missed something, it seems like the only option I have is to edit the database with something along the lines of 'if email is primary, set is bulkmail to yes' - given that my confidence in editing via sql is more or less nil, I'd be grateful for any pointers in carrying this out.

ETA: I’ve noticed that a couple of contacts which do have the bulk mail selected (both with two different emails to send the mail out to, rather than duplicate emails) also did not get sent the mail out, so it looks like setting the bulk mail email isn’t going to fix this...

(It also appears to happen with a smaller mailing list - nearly 100 contacts in the group, none on hold, but only 49 recipients indicated when you add that group to a new mail out)

ETA #2: Finally managed to pin this down to missing values in the is_deceased field - all the contacts with newly imported data seem to have lost the value for this field, even though I'd set the import mapping to skip that field entirely (as I'd already eliminated removed any deceased contacts from the import). Resetting the field to 0 fixed the problem - everyone is now back on the recipients list...

I will add the fix as an answer :)

As I've added to my question, it turns out the problem wasn't with the emails or the DND settings - the missing contacts all had a NULL value for is_deceased, and apparently CiviCRM interprets this as them being dead (rather than just missing information). When you edit the entire contact record, this is flagged, but because I was just checking the emails and DND settings in place, I hadn't noticed this.

Setting all the null values to 0 fixed the problem - I ran the following SQL query on the civicrm_contact table:

UPDATE civicrm_contact SET is_deceased = 0 WHERE is_deceased IS NULL;

(As per the answer here: https://civicrm.stackexchange.com/a/7396/610 )

Following that, all the relevant contact records reappeared in the mailing list recipient count.

(Double checking the import field mapping, it turns out I didn't tell it to skip that field - CiviCRM exports the field as empty if is_deceased = 0, so I guess importing it did overwrite the existing values)


Templates_c permissions differ when rebuilt on command line or by apache This is related to, but not a duplicate of, CiviCRM rebuilding templates_c with permissions.

I am using civicrm 5.1.2 / Drupal 7 /  Apache / Linux.

It is best practice not to let www-data own files in the Drupal tree. By the principle of least privilege, the web server should not be allowed to write to directories that it does not need to write to. And obviously someone needs to be able to write to them so that you can log on and upgrade and so on.

So I set up the permissions as suggested here . User jane has ownership of all the files and directories apart from the files directory, which is owned by www-data.

This does not work with CiviCRM and drush.

When you do a drush cc or drush cvupdb in the command line, as jane, the templates_c and ConfigAndLog directories get files added to them with owner jane and group www-data (I have set the setgid bit in order to ensure that the group remains www-data) and they get created with group write permissions. That is all well and good - the web server has write permissions via the group, and then is able to update the files when it needs to.

But when the web server creates the files itself, it creates them with www-data as both the group and the user. This is of course all it can do. However, it does not set group write permissions. That means that the next time jane logs on to do something from the command line that writes to those directories, she can't.

What do you suggest?

civibuild shows a few ways to tackle this problem.

File Permission ACL's work well if they are available on your system.

Edit: You will need to set the ACLs to cover future files created in the directory as well as existing ones. For this, use the -d flag as shown here https://serverfault.com/a/445096.

Further edit: Set the ACLs on the civicrm directory above the templates_c directory. Sometimes the whole templates_c directory gets deleted and rebuilt.


Cron job fatal error - scheduled emails won't send. AddThis 5.0.7 issue I updated AddThis for Wordpress 4.0.7 to AddThis Sharing Buttons 5.0.7 and scheduled emails stopped sending. I determined that the cron job was getting a fatal error.

Job path -  "https://www.xxxxxx.org/wordpress/wp-content/plugins/civicrm/civicrm/bin/cron.php

Fatal error:  Call to a member function getConfigs() on a non-object in /home/xxxxxx/public_html/wordpress/wp-content/plugins/addthis/addthis_addjs_new.php on line 57

Here is a snip from the file that caused the error:

    // We haven't added our JS yet. Or at least better not have.
    $this->_js_added = false;

LINE 57:       $this->_options = $addThisConfigs->getConfigs();

    // Version of AddThis code to use
    $this->atversion = $this->_options['atversion'];

The cron job was referencing a file in our AddThis plugin folder. It seems to me that file and plugin should have nothing to do with sending email from CiviCRM. I am not well versed in how cron jobs work, so any information you can provide would be appreciated. The day that this plugin was updated to the latest version 5.0.7, which included the file shown in the fatal error above, is the day scheduled jobs stopped sending and the cron job started erroring out. I deleted the updated plugin and reinstalled 4.0.7, the known good version, which did not contain that file. Scheduled emails now send.

I have seen this error before with this plugin.   The CiviCRM cron job will fail if while bootstrapping WP a fatal error is encountered.

My only workaround (besides removing the plugin as you did), is to launch the cron job via wp-cli.  See http://wiki.civicrm.org/confluence/display/CRMDOC/Managing+Scheduled+Jobs and the section on wp-cli.   In this case the flag --skip-plugins can be used to stop the addthis plugin from loading.


New contact created every time I login! I have no idea where to start looking to fix this issue. Every time I login as admin CiviCRM seems to create a new user contact for me. So there's currently a gazillion contacts for my email address (well, 10,000, which is nearly a gazillion).

I'm running CiviCRM 4.6.8 on WordPress 4.3.1.

I've just had a similar problem with a Joomla installation. It was a problem with the civicrm_uf_match table that (in Joomla) links CMS users to Civi contacts. Somehow the CMS user ID in that table was not the current user ID. Civi created a new contact because it could not match the Civi contact back to the user. I don't know how that matching happens in WordPress but it might be worth a look.

To solve in Joomla, I manually changed the CMS ID in the records in the uf_match table to the correct, current CMS ID.


Membership contribution page won't load in Chrome browser Lately our membership new/renewal form will not load in Chrome (in my case Windows ver 79.0.3945.88). But it has been working correctly in Chrome for several years. I don't know what's changed.

I have just tested that the membership form comes up okay in:

Firefox 71.0 (windows)

Windows Phone 8.1

Safari on iOS 13.

System: civicrm 5.15.1, WordPress 5.3.2

Edit with more info:

When the membership page loads okay, there are no warnings or errors in the civicrm log. But when the membership page stalls, there is the warning in the log:

Jan 06 17:25:33  [warning] CiviCRM thinks site is not SSL, redirecting to {url}
Array
(
    [url] => https://idahonativeplants.org/membership/
)

I think this is a good clue, and the problem only affects Chrome. The bug only appears when you go to the home page, then use the Membership menu item. If you first visit another contribution page on the site, then use the Membership menu the membership form comes up right away. Weird.

I solved this by making the site's home page secure https. There seems to be a glitch when Chrome goes from an http page to https, at least on our site.


CiviCRM is defaulting to uppercase path Somehow CiviCRM is wanting to use the path /CiviCRM (notice the case) instead of all lowercase civicrm.  This has been fine until I upgraded to Civi 5.27 and now the civicrm?civiwp implementation results in a 404.  I can change the case manually and it will work but the automatically generated URLs use all lowercase.
For example:
https://www.domain.org/civicrm?civiwp=CiviCRM&q=civicrm%2Fevent%2Fregister&reset=1&id=24  == 404 Not Found
https://www.domain.org/CiviCRM/?civiwp=CiviCRM&q=civicrm%2Fevent%2Finfo&reset=1&id=24 == working
This is also breaking images in my Mosaico templates.
Example of a Mosaico image:
https://www.domain.org/civicrm?civiwp=CiviCRM&q=civicrm%2Fmosaico%2Fimg&src=https%3A%2F%2Fwww.domain.org%2Fwp-content%2Fuploads%2Fcivicrm%2Fpersist%2Fcontribute%2Fimages%2Fuploads%2Fdcs_e1de5c0ee5de2a85bb86821132d2aaba.png&method=resize&params=166%2Cnull
If you change the link to /CiviCRM?civiwp=CiviCRM.... it works.
I have verified that the permalink on the page is lowercase as well as the CMS Database Integration in Civi.  Has anyone seen this behavior or have any suggestions for how I can correct it?
UPDATE:
Adding the following lines to my htaccess fixes this as a workaround.  Still not sure why it is defaulting to CiviCRM instead of civicrm.  Hopefully if this is happening to you, you can use this patch.
RewriteCond %{REQUEST_URI} !^/wp-content/
RewriteRule ^(.*)/civicrm(.*)$ /$1/CiviCRM/$2 [R,L]

Can you check the CMS Settings https://yoursite.org//wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fadmin%2Fsetting%2Fuf&reset=1 and see what you see?
I suspect it looks like:

Can you also check the WP Page 'CiviCRM'  I suspect the slug is not 'civicrm' lowercase.   These values must match in order for the urls to resove.


Automatically create scheduled reminders for recurring events? I modified an event template to include a scheduled reminder, but when I repeat the event (using the new recurring events feature), the scheduled reminder does not carry over.

Is it possible to create recurring events and all of them have the same scheduled reminder?

Rather than create a scheduled reminder based on "Event Name", create it instead on "Event Type".  If you don't want to apply scheduled reminders to all events of this type, create a second type with a very similar name to use with events you want a scheduled reminder on - then attach scheduled reminders to only that event.

I can also see in the API explorer that there's a "cascade type", which seems to suggest that perhaps you could change the default cascade type to cause scheduled reminders to be cloned as well.  I'll let someone else speak to the feasibility of that.


Unable to install v.4.6.x - Drupal7 I tried all the day to install version 4.6.x of CiviCRM on a brand new installation of Drupal 7.39, but each time I execute the installation here:

http://<your_drupal_home>/sites/all/modules/civicrm/install/index.php

I get a blank page and the following error in my logs :

PHP Fatal error: Class 'CRM_Core_Config' not found in /var/www/xxxx/sites/all/modules/civicrm/install/index.php on line 142

The method I used to install is simply downloading the compressed tarball and untaring it in the folder /var/www/xxxx/sites/all/modules/, and this after just having completed the installation of Drupal.

My confiuration is :

Debian GNU/Linux 8 (jessie) server with a private IP
Apache/2.4.10 (Debian)
PHP Version 5.6.7-1 (with all prerequisites except using the PHP's bundled version of PCRE for which I cannot guarantee it has the unicode properties support)
Content of the VirtualHost :

 <VirtualHost 192.168.1.203:80>
     ServerName xxxx
     SetEnv CODE_SITE xxxx
     DocumentRoot /var/www/xxxx
     php_admin_flag  engine on
     php_admin_value include_path "/var/www/xxxx/"
</VirtualHost>

EDIT 1

  Nom I am sure that the PCRE version bundled in my PHP instance has the unicode properties support option enabled, since I could sucessfully execute (with no warnings) : if(preg_match('/^\p{Arabic}+$/u', 'ﻎﺤﺤﺤﺤﺤﺣ')) echo 'OK'; else echo 'KOOOOOO' and it displayed OK

Does anyone have any idea ?

I finally succeeded to find the solution!

It was the VirtualHost's include_path the problem! In fact it seems that CiviCRM's install script needs to add paths in it, and if it is already set, it cannot be modified with the PHP's native function set_include_path(void).

So, I only had to comment the VirtualHost's include_path, and it worked!

My VirtualHost looks like that now:

 <VirtualHost 192.168.1.203:80>
     ServerName xxxx
     SetEnv CODE_SITE xxxx
     DocumentRoot /var/www/xxxx
     php_admin_flag  engine on
     #php_admin_value include_path "/var/www/xxxx/" => this line must be deleted
</VirtualHost>


Blank System Status screen and invalid [civicrm.files] URL variable on fresh CiviCRM v.4.7.30 and WordPress v.4.9.4 install I'm puzzled why, for a fresh CiviCRM install on WordPress, the URL variable [civicrm.files] is set incorrectly, resulting in some out-of-the-box broken behavior. Specifically:

I "successfully" installed CiviCRM v.4.7.30 on WordPress v.4.9.4. I got some pop-up warnings and jumped to the "System Status" screen, which was blank except for System Status: Error in the footer.

When I "inspected" the web page, I found "404 file not found errors" for some angular-modules... files, for example https://crm.staging.myorganization.org/home/myorganization/sites/staging/crm.myorganization.org/wp-content/uploads/civicrm/persist/contribute/dyn/angular-modules.e0e4119919ee72acc13134f3f09d77c0.js was  not found.

After some digging, the tip to go to Administer -> System Settings -> Debugging and disabling the "Asset Cache" (from https://civicrm.stackexchange.com/a/19597/5790) made the "System Status" screen work. Yay! But that's not a good production solution.

Digging further, I found that URL variables were set to the following. The [civicrm.files] value is incorrect.

  URL Variables
  [cms.root] https://crm.staging.myorganization.org/
  [civicrm.root] https://crm.staging.myorganization.org/wp-content/plugins/civicrm/civicrm/
  [civicrm.files] https://crm.staging.myorganization.org/home/myorganization/www/sites/staging/crm.myorganization.org/wp-content/uploads/civicrm/

However all of the Path variables were correct:

  Path Variables
  [cms.root] /home/myorganization/www/public_html/sites/staging/crm.myorganization.org
  [civicrm.root] /home/myorganization/www/sites/staging/crm.myorganization.org/wp-content/plugins/civicrm/civicrm
  [civicrm.files] /home/myorganization/www/sites/staging/crm.myorganization.org/wp-content/uploads/civicrm

On the Administer -> System Settings -> Resource URLs, the default values include the following:

  Image Upload URL [civicrm.files]/persist/contribute/
  Extension Resource URL  [civicrm.files]/ext/

It is the use of the invalid [civicrm.files] value here that resulted in the blank "System Status" screen. Once I changed these to the correct absolute URL, the "System Status" screen worked fine, even after I changed Administer -> System Settings -> Debugging -> Asset Cache back to the default "auto" setting.

Why is [civicrm.files] set to this odd incorrect value, when [civicrm.root] is perfectly fine? This is confusing for a CiviCRM newcomer (such as myself). Of all things, the "System Status" screen should be able to report the issues for the fresh install.

To clarify the installed folder structure:

The $_SERVER['DOCUMENT_ROOT'] is /home/myorganization/www/public_html, but I've created a folder structure under /home/myorganization/www/sites for test, staging, and production folders for various sites. The ~/www/sites folder is symlinked into /home/myorganization/www/public_html. I've created a custom __index.php__ file that gives the values of various PHP variables:

  Full URL= https://crm.staging.myorganization.org/index.php
  $_SERVER['DOCUMENT_ROOT']= /home/myorganization/www/public_html
  $_SERVER['PHP_SELF']= /sites/staging/crm.myorganization.org/index.php
  $_SERVER['SCRIPT_NAME']=   /sites/staging/crm.myorganization.org/index.php
  $_SERVER['SCRIPT_FILENAME']=   /home/myorganization/www/public_html/sites/staging/crm.myorganization.org/index.php
  realpath( $_SERVER['SCRIPT_FILENAME'])=    /home/myorganization/www/sites/staging/crm.myorganization.org/index.php
  getcwd()=  /home/myorganization/www/sites/staging/crm.myorganization.org
  __FILE__=  /home/myorganization/www/sites/staging/crm.myorganization.org/index.php

Bonus Question

After fixing the above, the "System Status" screen still complains "Incorrect Resource URL: The Resource URL is not set correctly. Please set the CiviCRM Resource URL." Why?

The issue is that the file structure you are using is not accounted for in the installer.

We've covered the standard directory structures and detect them, however there are some use cases that we have not been able to both detect and set programmatically.  In these cases, you will need to override the values.

In your case you needed to override the URLs as the [civicrm.files] URL is appending /home/myorganization/www/sites/staging/crm.myorganization.org to the URL.

I have seen this before (mostly with symlinks or if both WP is installed in it's own directory AND wp-content has been moved).   Can you let us know who your host is and confirm your configuration?


CiviMail fatal error in 4.6.4 Since upgrading to 4.6.4 I get this error whenever trying to schedule a mailing:

  A fatal error was triggered: is not of the type Int

And this error when trying to send a test mailing:

  Error in call to Mailing_send_test : Error in call to
  MailingJob_create : A fatal error was triggered: is not of the type
  Int

This is on WordPress 4.2.4

There was a bug in CiviCRM 4.6.4 that triggered the same error 'A fatal error was triggered: is not of the type Int' when trying to rebuild the smart group cache so this could be related, especially if U used smart groups for your maling.
I would suggest upgrading to 4.6.6 on a copy installation to see if that resolves the issue. Since this is not a real answer to your question I wanted to post this as a comment but I don't have sufficient reputation points to do that. I myself upgraded to 4.6.6 after experiencing too many problems with the 4.6.4 upgrade.


Menu does not appear unless in debugging mode in wordpress I just freshly installed Wordpress and CiviCRM on my GoDaddy hosting. Installation appears to have worked fine.

When I go into CiviCRM however, the CiviCRM menu bar does not appear at the top but does appear at the bottom of the page half-obscured as text links in sort of a drop down fashion.

When I enable debugging mode, everything works fine...

Any ideas? Any help would be GREATLY appreciated.

JavaScript for the menu bar is served up from two different places, depending on your debug setting. So good job tracking down that difference.

in debug mode it is served from a dynamic script which is slower, but doesn't rely on the file system.
in regular mode, the script is cached in a file. If you're CiviCRM files directory is incorrectly configured, or inaccessible due to permission problems on your server, then it will not load. FYI all Angular-based pages (e.g. CiviMail) rely on this file caching as well, so they too will be broken.

I recommend you double-check your system settings for file directories and resource URLs, and also ensure those directories are publicly readable on your server.


Remove CiviCRM and Drupal links / banner on profile form we have setup an online profile form that new members to our charity can complete. The information then pulls directly into CiviCRM.

When accessing the profile / form online there are drupal and CiviCRM headers / footers and links on there that we would prefer to remove:

Is anybody aware of a way to do this?

Many thanks

.............................................................

Thanks for your help guys it has been extremely useful and and I have now removed the links / logo's in the footer.

Unfortunately however I am still struggling to remove the logo and the "Home" link from the header, as per below:

I have tried unticking the logo option under www.yoursite.com/admin/appearance however this did not seem to make a difference (I am happy for it to be removed from public and private / internal view so any option to get rid of it is fine :)). It would also be great if we can remove the "Home" link.
We have our pulbic theme as CiviCRM Seven if that is any help at all.

Finally is there a way to change the background colour of the public profile / site - Currently it is just blank / white so it would be great to add the colour of our main website theme into there.

Thanks again for all your great help, Terry

.....................................

As per the image below the logo option has been unticked but the logo and home link are still present.

To remove the Drupal footer (This is a block called - Powered by Drupal) –

www.yoursite.com/admin/structure/block/manage/system/powered-by/configure

Under region settings, set all to - None

To remove empowered by CiviCRM –

www.yoursite.com/civicrm/admin/setting/misc?reset=1

Set Display "empowered by CiviCRM" to No

For the header, that’s the logo, which can be changed/removed from the CiviCRM public theme –

www.yoursite.com/admin/appearance


Strange behaviour with activity type in search builder One of our users reported a strange phenomenon when using search builder. I recreated this on the demo site.

When searching for activity type = Meeting I don't get results:

When searching for activity type like "Meeting" I get (correct) results:

I have similar problems with activity status. Using 'like' works in some cases, but I can't use '=' or 'in'.

Can anyone reproduce this behaviour?

I was able to reproduce the behavior; it seems like a bug, can you post a bug report here:  https://issues.civicrm.org/jira/browse/CRM/?selectedTab=com.atlassian.jira.jira-projects-plugin:summary-panel


What's the rationale behind the new Civi folder in civicrm? From a cursory glance, everything in Civi seems to be namespaced and everything in CRM is not. I'm guessing the answer has something to do with this.

According to the developer docs on namespaces, the two standards represent two eras of trend in programming standards:

  CRM (e.g.: CRM_Core_Invoke) classes use PEAR-style class-naming conventions that were common up until PHP 5.2. Class names include underscores and MUST NOT use the PHP "namespace" directive. Use CRM style when creating classes that plug into existing CRM subsystems such as payment processors (CRM_Core_Payment) and reports (CRM_Report).

  Civi (e.g.: \Civi\API\Kernel) "Civi" classes use PHP 5.3 namespaces. They MUST use the "namespace" directive. Namespaces are designated with "\".

  ...snip...

  The Civi namespace uses composer's PSR-0 autoloader. This autoloader does not support custom PHP overrides.

Obviously the developer costs of a refactor are prohibitively high and fraught with inter-operability difficulties with all the extensions, PHP versions etc. (I'm frequently shocked how many organisations still run CiviCRM on an unsupported (read: insecure) version of PHP.)

So CiviCRM started with PEAR's conventions, then jumped on the PSR-0 bandwaggon.

PSR-0 has been deprecated since 2014, so maybe we might have \CiviCrm namespace soon that follows PSR-4 and the CiviCRM brand guidelines about not shortening the name to Civi?

It's so hard staying fashionable these days and CiviCRM's rocking the retro


How to resolve issue with " Â " appears before currency sign? 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".

My workaround for this is to immediately convert the CSV file in a text editor such as Notepad++ or UltraEdit.

As soon as it's downloaded I open the CSV as UTF8, then immediately save it as ANSI. It's a bit fiddly, but fixes the £ problem, as well as any unusual characters in names/addresses.


Contribution page not displaying when member is logged into site The contribution page displays just fine when the member is NOT logged in to my site. I have Joomla 3.6.0 and CiviCRM 4.6.19. However, when the member is logged in, the contribution page does not display and instead the link throws you back to the homepage. Since the page is open to the public, I can't see where this problem is coming from.

Have you checked the permissions in CiviCRM?

If, say, profiles are set to be viewable only by Guest and are included on that page, then it would only be viewable if not logged in.


extension ACL for activity types error "[] operator not supported for strings" WP 5.3 civi 5.19.3 php 7

select contact record - error as follows:

"Fatal error: Uncaught Error: [] operator not supported for strings in /home/leepngo/public_html/wp-content/uploads/civicrm/ext/biz.jmaconsulting.activitytypeacl-master/activitytypeacl.php:278 Stack trace:
#0 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Hook.php(300): activitytypeacl_civicrm_selectWhereClause('Activity', Array)
#1 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Hook/WordPress.php(155): CRM_Utils_Hook->runHooks(Array, 'civicrm_selectW...', 2, 'Activity', Array, NULL, NULL, NULL, NULL)
#2 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/Civi/Core/CiviEventDispatcher.php(90): CRM_Utils_Hook_WordPress->invokeViaUF(2, 'Activity', Array, NULL, NULL, NULL, NULL, 'civicrm_selectW...')
#3 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/vendor/symfony/event-dispatcher/EventDispatcher.php(184): Civi\Core\CiviEventDispatcher::delegateToUF(Object(Civi\Core\Event\GenericHookEvent), 'hook_civicrm_se...', Object(Civi\Core\CiviEventDispatcher))
#4 /h in /home/leepngo/public_html/wp-content/uploads/civicrm/ext/biz.jmaconsulting.activitytypeacl-master/activitytypeacl.php on line 278

I think you are running very old version of Activity acl extension. The issue you facing must have been fixed last year. Can you update the extension by downloading from here?


Contact Types Not Updating in Main Menu When editing or adding Individual and Organization contact types the main menu doesn't update the contact type text. For example the options under Contacts > Individuals > are still New Student, New Parent, and New Staff, when they should be New Member, New Intern, and New Staff. When I click on "New Student" it brings me to add a new member page, so it's really just the menu list that is not updating and the pages themselves are fine.

Thanks for reporting this and describing it so clearly. I have reproduced this problem on the latest version of CiviCRM, though in my testing I found the problem to be limited to editing the label of existing contact types (adding new contact types work okay in my testing).

Bug

This looks like a bug to me. I would suggest you take this a step further by filing a bug report. You can use the text you wrote already and even link to this page too.

Work-around

In the mean time, if you're still in the process of configuring CiviCRM (and haven't yet created contacts with your desired sub-types), you can delete those problematic sub-types and create new sub-types for "Member", "Intern", and "Staff".


Create event participate using OOP API in CiviCRM There are 2 different sites in Drupal. In one of them there is CiviCRM is installed. Now I want to create event participate from first site which will use CiviCRM of second site. I have successfully get the list of events from second site to first site using:

$api = new civicrm_api3 (array ('server' => 'http://localhost/civicrm', 'api_key'=>'xxx', 'key'=>'xxx'));

if ($api->Event->Get()) {
    print_r($api);
} else {
    echo $api->errorMsg();
}

Now I want to create event participate using OOP API in CiviCRM. So I have create code something like that:

$params = array(
        'contact_id'    => 1,
        'event_id'      => 2,
        'status_id'     => 1,
        'role_id'       => 1,
        'register_date' => '2007-07-21',
        'source'        => 'Online Event Registration: API Testing',
        'event_level'   => 'Tenor'
);

if ($api->Participate->Create($params)) {
    print_r($api);
} else {
    echo $api->errorMsg();
}

But in response I'm getting:
API (Participate, create) does not exist (join the API team and implement it!)

So is it still in development? any other way to do that?

I think you have a typo. Please try $api->Participant->Create($params)) and let us know the result.

You can see an example here: https://github.com/civicrm/civicrm-core/blob/master/api/v3/examples/Participant/Create.php


How to add Campaign token in system contribution receipt Trying to add the campaign name to my automatic receipts.

This works: {$formValues.campaign_id}

But this doesn't: {$formValues.campaign_name} or {$formValues.campaign_title}

I need to print the campaign name and not id.

How can I add the Campaign name to my receipt

If you can get campaign id ({$formValues.campaign_id}) then you can use api to retrieve the Campaign Title. Use below snippet to get the Title

{if $formValues.campaign_id}

  {crmAPI var='campaignTitle' entity='Campaign' action='getvalue' sequential=0 return="title" id="`$formValues.campaign_id`"}
  {$campaignTitle}
{/if}

  Note: The snippet code is not tested but you can use the logic to get
  the title

HTH

Pradeep


CiviCRM eMails not being delivered How can we verify that CiviCRM emails are actually being received. The report shows that all were successfully delivered. However, recipient members are complaining that they aren't receiving the eMails.  They also checked their SPAM folders.  Not there.

This depends a bit on how you're sending emails. Are you using a mailing service, or do you run your own mail server?
Some mail processors accept mail but then don't allow it through to the user if they don't like the look of it. We had this problem with Outlook/Hotmail at one point. In the end we had to contact them directly to resolve the issue.
There are a couple of things to try if you haven't tried them already:

Check the spamminess of your emails using mail-tester.com. Aim for 10.

Set up Dmarc. This will give you direct feedback from the mail processors (sometimes including instructions/contacts for resolving problems), and it should generally help your mailing reputation.


Prettify CiviCRM pages Total newbie.  Don't know what I don't know...

I am trying Civi with WP.  Tried with Joomla.  I loved Drupal in another life.  :-)

Is there a simple way to make the output pages for Civi (like events, registration, etc.) prettier - more in line with the types of pages you see in a typical website?  I guess I'm spoiled with all these builders these days.

Like a theme of some sort?  Or an addon?

The presentation here is gorgeous:  https://www.cividesk.com/civicrm/event/register?id=611&reset=1

But (1) I think that's Drupal and (2) I think it's custom.

I just can't seem to find a way (short of modifying .tpl files) to make Civi look a bit better.

Thoughts?

Thanks,
Mark

You can create your own event registration pages using HTML and profiles. You can use the APIs if you want to create different administration pages


we are trying to set up Sparkpost in CiviCRM, but we are using G-Suite and cant use DNS? we are trying to set up Sparkpost in CiviCRM, but we are using G-Suite and can't use DNS?  So tried to use another method, but when trying to add either Postmaster or Abuse G-suite says those are reserved.  What am I doing wrong?

Your question does not say why you can't use DNS?

Google Apps will I think let you configure the abuse@ and postmaster@ addresses as aliases (Google refers to these as "groups"). Google will still process those addresses as well, but I think you can configure them so you can field the Sparkpost setup email.

Here is Sparkpost docs on that: https://www.sparkpost.com/docs/tech-resources/abuse-postmaster-google-apps/


Create new contact sub-type when extension is installed I'm building a new extension using civix and buildkit.  I need to create a new ContactType (sub-type of individual) on install (if it doesn't already exist).  I know how I would do it, but I'd prefer to do it in accordance with CiviCRM's standards.  What's the correct way to do this?

A contact subtype is an "entity" - it exists as a record in the civicrm_contact_type table. So that means you can use the "managed entity" approach described here:

https://civicrm.org/blog/totten/api-and-art-installation

and documented here:

https://docs.civicrm.org/dev/en/latest/hooks/hook_civicrm_managed/

You could instead implement the install hook (https://docs.civicrm.org/dev/en/latest/hooks/hook_civicrm_install/) and manually test for the existence of the contact type and create it if not (more details in Demerit's answer below).


For all reports, CiviReport shows a page with no content I'm getting a mostly blank screen when trying to run reports. I see the CiviCRM menu and page heading, then the page footer, with nothing in between.

I get the same thing for every report and every report template. The "Manage Templates" screen works, but if I click "Edit" on a template, I get a pop-up with no content.

I have no errors in the CiviCRM log file, no errors in my PHP log file, and no browser console errors. This is CiviCRM 4.6.26.

What steps can I take to further troubleshoot this problem?

I have just had this issue whilst upgrading from ver 5.3 to 5.4 (using Drupal 7 as the CMS).  After a couple of frustrating days going through the debugger and finding nothing, I did a fresh 5.40 install on a VM and all was fine.

Going back over the steps I took upgrading, and retraced - one of the steps was to clear down the files/civicrm/templates_c/en_US directory.  I cleared down everything I could in the en_US directory and all was fine.

See Clear Cached file in the section

  Upgrade in Drupal 7


Saving Advanced Searches for later use Can advanced searches be saved for later use and made to appear in the Search menu, so users dont need to enter the search criteria every time? Similar to how custom reports can be created once and added as a menu item under Search?

regards
Sudesh

You can save the result of an advanced Search as a Smart Group. If you want a link to that smart group in the menu, you can add a menu option for it with Administer > Customize Data and Screens > Navigation Menu.


GDPR and CiviCRM 4.7.30 On our web site, the GDPR extension does not figure on the list of installable extensions. Does it mean GDPR (the latest 2.5) is not stable for 4.7.30, or some other reason?

Does it harm to install 2.5 manually?

Drupal 7.58

It does not harm to install extensions manually. Actually that is the way I am using the most.

The auto install requires that an extension developer has submitted his/her extension through a review process and for most extensions developer (like me) that is too much of a hassle and also puts me in the maintainer and supplier role.


Disabled activity still auto-populates I've disabled certain activities that we do not want to keep track of (Record merged, for instance). Yet, when I merge a record, the activity is still automatically created. How can I prevent this from cluttering up our Activities tab in the future?

Since that activity type is sort of a system type and is marked Reserved to discourage editing it, I don't think there is currently a way. Since you must have disabled it in the database outside the UI you might be ok with a workaround involving some coding. You might be able to write a little extension to use hook_post to delete activities of those types after they get created: https://docs.civicrm.org/dev/en/latest/hooks/hook_civicrm_post/


Why is my mailing taking so long? Our problem has two parts. We tried to send an email to our members and supporters from one user's computer but could not add recipients' addresses (she was away for the upgrade). I tried to send it from my computer instead as I have been doing for the past 6 months. It won't send though - has apparently been 'running' for 2 and a half hours, not being delivered.

As Tomek suggested, try running this task, usually referred to as a Job.

Administer > System Settings > Scheduled Jobs > Send Scheduled Mailings > More > Execute Now


CiviBooking Wordpress Error on Adding Resouces Civicrm 5.25.0 and Wordpress 5.3.3

When I go to Add a Resource I get

Fatal error: Access level to CRM_Admin_Form_Resource::$_id must be public (as in class CRM_Admin_Form) in xxx/uploads/civicrm/ext/uk.co.compucorp.civicrm.booking/CRM/Admin/Form/Resource.php on line 40

Is there a way around it?

You could just remove the protected $_id = NULL; line in uploads/civicrm/ext/uk.co.compucorp.civicrm.booking/CRM/Admin/Form/Resource.php, since it's defined in the base class as public.


Is it safe / wize to empty civicrm_log table Pretty similar to this question, we've moved LOG_tables to another database; however, there is civicrm_log table among "main" tables still (not sure why, since it keeps log records and, in theory, belongs to LOG_tables group). Size of civicrm_log table in our case grows pretty fast (80M at time i'm writing this), second biggest table in the db. We may need these records in a future, but moving table out of current setup makes it inaccessible for civi searches / reports. Keeping it makes simple database backup (via phpmyadmin) somehow troublesome. So, in case deletion will be chosen, is it safe to flush it?

Nothing stopping you flushing it but you will lose transitional information and any log data unless you also have audit logging switched on. You could keep a backup of it in a separate database if you need to stop it becoming a problem.


How to copy an existing letter template? I have created a custom letter template in CiviCRM, with letterhead, footers, graphics  etc.  It is saved under an assigned name.  Now I want to use that template to create others for specific purposes, which will use the same basic format but differ slightly in detail.

How do I copy?   If I open the original and change it, it overwrites the template I'm trying to keep.

If you use that template when either sending an individual Mail or a CiviMailing you should have an option at the bottom to save as new template.


Editing custom group settings I'm trying to edit the settings for an existing custom fields group. When I make the changes and save it, I get this:
Please correct the following errors in the form fields below:
Custom group 'Training Information' already exists in Database.

Quick guess. Did you double click the save button?
Or, it's suggesting there's already a "Training Information" Dataset on your system. Maybe for a different entity type e.g activity data not contact data.


Link to User record, via View Contact -> Actions -> User Record gives Page Not Found (404). Is this a bug? We are running CiviCRM 4.7.23 + Drupal 7.56.

If we try and access one of our Drupal User Records via the CiviCRM Contact record (View Contact -> Actions -> User Record) we get a 404 "Page not found" error from Drupal.

In trying to debug this, we've noticed that the URL generated by the "User Record" link in CiviCRM is like this:

http://oursite.org/user/XXXX&cid=YYY

Where XXXX is the Drupal User ID and YYY is the CiviCRM Contact ID.  If I strip off the &cid=YYY part from the URL, the link works and takes me to the correct User Record.

So, is this a bug, or is our site misconfigured somehow?

I just tested on a site. Clicking the link as described above i get sent to

user/2&cid=39941

and that page shows.

BUT

if instead I just click on the Contact ID / User ID |
39941  / 2 that sits just under Tags on the Contact Summary screen

I get sent to

user/2 and that sounds like it might work in your set up

Does your Summary Screen not show that? (ie I wonder why you are not using that rather than going via Actions which is an extra click)

I can't explain why the link with &cid=YYY is failing for you


Southern California Civi CRM Expert Wanted We are huge fans of Civi CRM, but in order to really understand the benefits of the platform we would like to work with a veteran. Basically, we need a consultant to point us in the right direction and keep us from making critical mistakes.

Leave your contact information and we will contact your prior to the end of the week. Thanks!

Thanks for your interest in CiviCRM.  This question is likely to be closed as it doesn't really fit into the StackExchange format.

Instead, I would suggest that you look at the list of partners and contributors on the CiviCRM website and contact them directly:

Find an expert


Selecting all checkboxes for field reverts to one value On Wordpress 4.9.8 and Civi 5.4.0.

It shows multiple values as long as you do not select all of the options. If you select them all, then it reverts back to just one (petitioning in this case) for some reason. Exporting data only shows the one value as well.

I tried to reproduce on a demo but it was on 5.0 version. Is this a bug?

The issue is that the alphabetized option to sort the field labels creates the error. I was able to replicate this on wpmaster.demo.civicrm.org.

To solve, I just put the field values in order e.g. 1,2,3 etc. Now it works.

It's a bug, I'll report.


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

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

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

Any ideas on what logic will accomplish this?

Civi 4.6.2

Drupal 7.38

Views 7-3.11

Thanks!

Looks like the CiviCRM is adding a space '&nbsp;' (may be because of CKEditor) into the custom table column , even though you leave it empty when adding/editing the record.

You can see it if you do var_dump of the variable. See below screenshot

So the below logic should work in this case.

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

Give it a try.


How do I write the _spec function for my custom API? When I run...

civix generate:api foo bar

...civix generates the following code:

function _civicrm_api3_foo_Bar_spec(&$spec) {
  $spec['magicword']['api.required'] = 1;
}

From this example, I can see how to make fields required when writing APIs. Cool. But what else can I do with this $spec array? Can I set default values? Can I indicate what type of value to accept? Can I specify an array of valid values? Or a regex pattern to test for validity?

Really, I'm not looking for answers to those specific questions, I'm looking for a comprehensive list of everything I can type in place of 'api.required' above (and an explanation of how each one works).

As per https://github.com/civicrm/civicrm-core/blob/master/api/v3/Dashboard.php#L64 you can set default values, You can also specify the type and even limit to specific options see https://github.com/civicrm/civicrm-core/blob/master/api/v3/Contribution.php#L552 also https://github.com/civicrm/civicrm-core/blob/master/api/v3/Contribution.php#L723. Also as per https://github.com/civicrm/civicrm-core/blob/master/api/v3/Contribution.php#L360 you can specify aliases or alternate field names for legacy or similar handling


Profile Directory in Wordpress I am seeing unusual behavior when trying to insert a profile as a directory on the front end of WP.

https://my.url.org/state-chairs/?page=CiviCRM&q=civicrm/profile&force=1&gid=21

https://my.url.org/states/?page=CiviCRM&q=civicrm/profile&force=1&gid=19

They should be showing two different data sets but are only showing the same data? I checked that the profile has the proper group selected.

Also it says as an admin I do not have permission to access this page: https://my.url.org/states/ When I visit there it says:

  Permission Denied You do not have permission to view this contact record. Contact the site administrator if you need assistance.

I am running CiviCRM 4.7.27 on WP 4.9.1. This is a multisite.

Ah, that moment when you bump into a question you figured out but I forgot I even posted it here.

There may be other methods but you should use the native CiviCRM profile link which you can find at Administer > Profiles > more > Use- Listings Mode. This looks like: https://example.org/civicrm/?page=CiviCRM..." format or whatever you set your base page at.

The issue seems to be if you try and use a shortcode for this directory style listing and not use the CiviCRM base page. So, you can create a clean URL to redirect to the native CiviCRM profile link. Perhaps this is considered a workaround but it works :)


When exporting contacts using custom selected fields, results in "Undefined Index ...Mapping.php Line 622" When trying to export a list of Contacts selecting a previously defined set of Export Fields, system throws this error:"Notice: Undefined index: in /home/.../Core/BAO/Mapping.php on line 622"

When exporting using primary fields, the export is successful.

What is the issue with Mapping.php?

This is a bug, albeit a minor one because of the simple workaround.

In PHP (the language most of CiviCRM is written in), there are various levels of problem: notice, warning, error, etc.  A notice generally means, "This software's code has something ambiguous but not wrong about it.  We're going to infer what the code's author meant to do, but they may want to make it explicit."

Good software strives to be notice-free, and CiviCRM is mostly notice-free.  You've discovered an exception - though you haven't noted your CiviCRM version, so it's quite possible this is already fixed.

The reason this is less important than many other bugs is that notices should be suppressed on a live instance of CiviCRM - they should only really pop up if you're a developer.  So the fix for this is to change your PHP settings to hide notices.  This issue should go away after that.  There's a few ways to disable notices; this Stack Exchange answer outlines them: https://stackoverflow.com/questions/2867057/how-do-i-turn-off-php-notices


How can I lookup US county from latitude/longitude? Does there exist an easy way to look up U.S. counties from latitude/longitude?  I know about Mathieu's excellent Region Lookup extension, but since one postal code can encompass multiple counties, I'd like something more definitive.

I know that Google Maps lookups can give you county names - has anyone tried pulling that into CiviCRM on geocode lookup?

I've never done it, but I think Tyrell's SmartyStreets extension provides it.

One thing to point out, however, for anyone who does it another way: county names repeat a lot, and the ID numbers of counties in CiviCRM are totally arbitrary, unlike states.  The way to look up county is to find the state and then find the county name within the state.


Adding multiple Case Coordinators in a Drupal webform? I've got a multi-site with the following roles in Drupal:

Site admin (full access)
Local admin (can view all contacts)
Case Manager (can view all Cases)
Staff (using ACLs, can view site-specific contacts and no Cases)

We want to restrict the Case Managers so that they can only see the Cases on their own site, even if they also have 'Local admin' (view all contacts).

I've only managed to implement so far by adding all Case Managers as 'Coordinators' to every Case in their local site, so that the 'View my Cases' enables them to see the local Cases.

This is fine, however I cannot work out how Case Managers can then add more than one Case Coordinator for new Cases.

Using the Drupal webform, I can only specify a single contact for Case Coordinator (regardless of permissions)
In the normal Case Dashboard, only people with 'Site Admin' (i.e. full access) have the ability to add more Roles to a Case
In the Case Type set-up, it only allows one of each relationship type for the default set up.

Is there a way to enable staff to either see all Cases for their local instance only or to enable them to manually add more than one Case Coordinator so that the three staff can see all Cases for their local site?

Technically it's the permission "access all cases and activities" that can add roles on Manage Case but I guess that's the same as "site admin"/"full access" in your setup. The reason seems to be to avoid a loophole where access to cases could be granted that shouldn't be (see https://civicrm.stackexchange.com/a/33409/181).

Anyway what you might be able to do is tag or group the people who should all be case managers for a given local site, and then using hook_postProcess or hook_post add some code that automatically adds those roles when a new case is created for people who have the same tag/group as the case creator, i.e.

loop for each person with the same tag/group as the logged in user:
civicrm_api3('Relationship', 'create', [
  'contact_id_a' => 123, // client id
  'contact_id_b' => 194, // other person's id
  'relationship_type_id' => 9, // Case Coordinator is
  'case_id' => 12345,
]);


I need a developer for a custom extension where is the best place to ask? All is in the title. We have a client with specific need. We would like to hire a developer to build the extension the right way and share it with the community. Where's the place to do it ? Here ?

The obvious place to start is the list of experts at https://civicrm.org/partners-contributors and select custom code and extensions


Can't find 'longitude' in import wizard I have civicrm 4.7.31 on D7. From my old civicrm 4.1.1, I have exported the following fields in a csv file:

1) civicrm_contact (my external_identifier) in 4.7.31
2) geo_code_1 (latitude)
3) geo_code_2 (longitude)

Now, when I want to fill fields in the import contact wizard in 4.7.31, I find the latitude field, but there is no longitude field.
I have tried unsuccessfully to update the geocodes using the mapping function and Google in the Mapping and Geocoding section of the system settings.

Make sure it is enabled under address settings. Go to Administer > Localization > Address Settings.


event income reports I'm not getting the results that I expect from the event income reports. I've used the "No-show" status for people who have paid but don't turn up to the event. However the report only seems to included the income for participants with a status that is "Counted". That's right for the attendee numbers, but not for the finance. If I set the "No-Show" status to be "Counted" then I assume the figures will come right, but it won't show the numbers actually at the event. I can't think of a way round this.

I think that this is simply not covered. You can read more related threads on SE question How to create a contribution or event report that indicates amount of payment and balance owed and at the old forum on Event Income Report Misleading - need to look at actual contributions, not fees.

How can we get reports with real event payment status and no expected incomes? This is a very common request from our users that we have yet to respond.


Updating information in Custom fields within a tab not saving since update to 4.7.0 Civicrm 4.7.0
Joomla 3.4.8

When editing or adding information contained within a custom field within a tab, after hitting save, the information does not remain.

Also receive the following error when trying to view information contained wihtin a tab within a table:

Datatables warning: table id=records -Ajax error
For more information please see http://datatables.net/tn/7

Any help would be appreciated. Please let me know if you require more info.

Thanks

Hi I did manage to test the same against 4.7.0 and we do have an issue. so, please raise an issue for the same

Also I did manage to test the same against Civicrm Version 4.6.11 and everything works perfectly. so at this time I would recommend you to install civicrm Version 4.6.11 for time being and wait for the next version and see if that gets fixed


CiviCRM 4.7.29 Update Indices fails I've messed around unsuccessfully to update indices by following various posts in StackExchange for similar errors. I have the impression that the Update Indices button simply does not work correctly.

If I push it at the moment, I get:

DB Error: already exists
Debug information:
CREATE UNIQUE INDEX index_entity_id_entity_table_account_relationship ON civicrm_entity_financial_account (entity_id, entity_table, account_relationship) [nativecode=1062 ** Duplicate entry '0-civicrm_financial_type-12' for key 'index_entity_id_entity_table_account_relationship']

Does anyone have a good way of removing all indices and recreating them?

I just upgraded from 4.7.25 to 4.7.29 (and am on the latest Wordpress version) if that is relevant.

Tried CiviCRM Update 4.7.27 Operation failed: Update Indices Errno: 150 but it didn't work either (complained about ALTER table civicrm_option_value DROP INDEX index_option_group_id_name with #1091 - Can't DROP 'index_option_group_id_name'; check that column/key exists)

Thanks, David

Here is the possible solution for this. Try running the sql queries through shell or phpmyadmin and than re-run the update indices.

Looking at the db error i can see civirm_entity_financial_account have duplicate rows. Please get rid of one row or all with entity_id = 0 as it doesn't make sense and then re-run update indices.

Delete civicrm_entity_financial_account where entity_id = 0 and entity_table = 'civicrm_financial_type';


Scheduled Job Membership renewal reminder not running Schedule Job for mailings is not working correctly. Other scheduled jobs are working - membership status updates, smart group updates,etc. There should be 250+ renewal emails sent to members with expire date of 12/31/2019, but nothing is sent out. Server will restrict to 50 emails at a time, but should send in tranches of 50. I tried manual execution of scheduled jobs and get same response. We're running Civicrm 5.1.14 with Joomla 3.9.15 on PhP 7.2. Any thoughts? I didn't find any recent examples of this error on stackexchange.

Based on work done by a third party Civicrm partner firm, we have two cron jobs:

 /usr/local/bin/php /home/jgsny/public_html/administrator/components/com_civicrm/civicrm/bin/cli.php -s jgsny.org -u civicrm -p xxxxxx -e Job -a execute

AND

/usr/bin/wget -O - -v -t 2 'https://jgsny.org/administrator/components/com_civicrm/civicrm/bin/cron.php?name=civicrm&pass=xxxxxxx&key=xxxxxxx'

The cron job sends a single message:

--2019-12-02 12:55:01--  https://jgsny.org/administrator/components/com_civicrm/civicrm/bin/cron.php?name=civicrm&pass=xxxxxx&key=xxxxxxx
Resolving jgsny.org (jgsny.org)... 209.124.74.61
Connecting to jgsny.org (jgsny.org)|209.124.74.61|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 0 [text/html]
Saving to: 'STDOUT'

     0K                                                        0.00 =0s

2019-12-02 12:55:02 (0.00 B/s) - written to stdout [0/0]

The cron job Job.execute is running all active cron task defined in menu Administer -> System settings -> Scheduled Jobs

If your cron is running as it seems to be, you might first want to check :

if the task Send Scheduled Reminders is enabled in  Administer -> System settings -> Scheduled Jobs
if the frequency is correct - it should be daily or hourly maybe
when you click View Job Log - do you have any error


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

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

After months of struggling with this, I think I have solved it:  I found this article or others like it: https://stackoverflow.com/questions/8159321/request-exceeds-the-configured-maxquerystringlength-when-using-authorize which gave the parameters to tweak in web.config:

is an example.  As it is a private server I haven't spent much time optimising those parameters.


CiviVolunteer error after upgrade to Civi 5.11.0 on joomla Running civicrm 5.11.0 with CiviVolunteer on joomla 3.9.5 PHP 7.1 (as well a second site with the same problem on PHP 7.0)
I am running API v4 version 4.3.0
CiviVolunteer 4.7.31-2.3.1

Since upgrading from civi 5.10.0 to 5.11.0 I receive the following error when running the Volunteer Report.

Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
DB Error: unknown error
Return to home page.

From the error_log file:
[28-Apr-2019 22:08:34 America/New_York] PHP Warning:  Declaration of CRM_Volunteer_Permission::check($permissions) should be compatible with CRM_Core_Permission::check($permissions, $contactId = NULL) in /home/[my account]/public_html/media/civicrm/ext/org.civicrm.volunteer/CRM/Volunteer/Permission.php on line 151

The warning you describe is fixed in the version of CiviVolunteer on github but they haven't tagged a release. The error sounds slightly different & turning on debugging might get more info.

However I logged an issue asking them to tag a release since there are unreleased civivolunteer fixes https://github.com/civicrm/org.civicrm.volunteer/issues/508

You can get the latest civivolunteer code from github in the meantime - https://github.com/civicrm/org.civicrm.volunteer/archive/master.zip and see if that helps


Is this a bug, or a feature? Redirect on contribution landing page triggering while editing My organization uses a redirect on the landing page after someone makes a contribution so they can fill our a survey for us. This redirect is triggering when we are trying to edit the "Thank you and receipting" information on the back-end of the donation page after upgrading to 4.6 (it didn't previously). This is also happening on the demo site (see the "Member Signup and Renewal" page).

This seems like a bug to me, but I wasn't sure, so I thought I would ask about it here before reporting it. The pages can still be edited if you push the stop button on your browser at the exact right moment before the redirect takes hold, it is just annoying to work around.

Thanks!

Looking at the demo site, you are inserting JavaScript directly into the thank-you message:

Thanks for supporting our organization with your membership. You can learn more about membership benefits from our members only page.

CKEditor renders the whole thing when the tab is loaded or the field edited. This causes the JS to run, which fires the redirect. It's technically a feature that CKEditor allows us to enter JavaScript and executes it for us, but I'd never recommend doing this. It will become a huge pain to troubleshoot later, when someone other than you goes to edit the thank-you email receipt and it keeps kicking them to a survey page. I recommend moving your redirect into a template override or an extension, so that it only loads when the user gets to the actual thank-you page.


Workaround Duplicate Label I noticed that all labels in the "Activity Type Options" and "Custom Fields" cannot be the same. For example, if I wanted to add a "Medical Assessment" activity type, I cannot use the same label again. This matters, because when I assign this activity type to a specific case, I have custom fields attached to this medical assessment activity.

The problem is, when I create another case type and use "medical assessment" again, I want different custom fields to be attached.

You could rename the activities - for example: "Medical Assessment - Type 1", "Medical Assessment - Type 2" or something more descriptive and link the appropriate custom fields to each one.


Drupal Rules are not working properly when check CiviCRM Contact's Subtype I’m using Drupal 7.56 and CiviCRM 4.6.31.

I’ve been using Rules in Drupal, as I need to copy the Household Name to the Last Name of a Particular Individual contact subtype (Child) whenever the relationship between the Household and this type of Individual (Child) has been established, but the Drupal Rule is not working.

Rule "Copy Family Name to Individual Last Name”

I've set up the following conditions reacting on the Event “CiviCRM Relationship has been created”:

Conditions

ELEMENTS

Data comparison

Parameter: Data to compare: [civicrm-relationship:relationship-type-id, Data value: 8]

(Type ID of Relationship between the Household and the Individual of type 'Child')

AND

Text comparison

Parameter: Text: [civicrm-relationship:contact-id-a-contact:contact-sub-type,
Matching text: Child]

Action: Set a data Value

Selected Data:

 civicrm-relationship:contact-id-a-contact:last-name

Value

 civicrm-relationship:contact-id-b-contact:household-name

This is the output to debug the values of the fields for 2 contacts:

civicrm-relationship:contact-id-a-contact:contact-sub-type:

   0 (String, 6 characters ) Parent

civicrm-relationship:relationship-type-id:

   8

civicrm-relationship:contact-id-a-contact:contact-sub-type:

   0 (String, 5 characters ) Child

civicrm-relationship:relationship-type-id:

   8

These is the Devel log:

•   Reacting on event CiviCRM Relationship has been created.

•   Evaluating conditions of rule "Copy Family Name to Individual Last Name".

•   The condition data_is evaluated to TRUE

•   The condition text_matches evaluated to TRUE

•   AND evaluated to TRUE.

•   AND evaluated to TRUE.

•   Rule "Copy Family Name to Individual Last Name" fires.

Rule Copy Family Name to Individual Last Name fires.
Evaluating the action data_set.
Evaluating the action devel_debug.
Evaluating the action devel_debug.
Rule Copy Family Name to Individual Last Name has fired.

•   Saved civicrm_relationship:contact_id_a_contact of typecivicrm_contact.

•   Finished reacting on event CiviCRM Relationship has been created.

But, despite the subtype of contact the action, the action is executed; even for the “Parent” contact subtype, when in the conditions is set up just for “Child”.

Why the condition civicrm-relationship:contact-id-a-contact:contact-sub-type contains ‘Child’ is evaluated TRUE, for all the subtypes of contacts, even for the ‘Parent’ contact subtype?

If I change the type of conditions to “Data comparison”:

Conditions

ELEMENTS

Data comparison

Parameter:

Data to compare: [civicrm-relationship:relationship -type-id, Data value: 8]

AND

Data comparison

Parameter:

Data to compare:
[civicrm-relationship:contact-id-a-contact:contact-sub-type,

               Operator: is one of, Data value: Child, ☺Child☺]

These is the Devel log:

•   Reacting on event CiviCRM Relationship has been created.

•   Evaluating conditions of rule "Copy Family Name to Individual Last Name".

•   The condition data_is evaluated to TRUE

•   The condition data_is evaluated to FALSE

•   AND evaluated to FALSE.

•   AND evaluated to FALSE.

•   Finished reacting on event CiviCRM Relationship has been created.

The conditions are never met.

Why the condition civicrm-relationship:contact-id-a-contact:contact-sub-type is one of ‘Child’ or ‘☺Child☺’ is evaluated FALSE for the contact subtype “Child”?

Could someone have any tip about what is happening?

Thank you so much for your help.

I remember this issue from some time in the past, probably been on stackexchange here before. In the end, we developed a new Rules condition, provided by the CiviCRM Entity module, "CiviCRM Contact is of subtype".

It is in the "CiviCRM" section of the options list when you choose your condition.

Give that a try, I believe it will solve your problem. It is expecting one parameter, a Contact object. It then allows you to choose which subtype to look for.

It is possible you will have to load the contact first, and put your conditional down in the actions section of your rule.

To load the contact, use the "Fetch entity by ID" action, and pass it

civicrm-relationship:contact-id-a-contact:id


Network Error and DB Error on contact subtype with custom fields I'm helping a group set up an install (Civi 4.7.12, which has been upgraded from earlier 4.7.x versions a few times) on a dev site and I've added a set of custom fields for a contact sub-type. I added a checkbox field and tested and it worked fine. Now they've added some more custom fields in that set and we are getting some strange errors. I don't see anything which immediately raises a red flag related to the fields they added (more checkbox fields and some text fields).

When editing an existing org and trying to select the sub-type, it throws an error: "Network Error: Unable to reach the server. Please refresh this page in your browser and try again." The custom fields are never shown.

If I try to create a new contact of this sub-type, the fields show up, but when I try to save the contact, it throws an error. "DB Error: no such field" with further info below:

Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame thrown in /home/public_html/sites/all/modules/civicrm/Civi/Core/Transaction/Manager.php on line 107

Anybody have some pointers for me on where to look? I'm kind of stumped.

Not a definitive answer yet but it seems to be related to the way they tried to implement comment fields. I disabled all their "Alphanumeric > text" fields and the errors go away. Still having to dig deeper as to what they did (all through the UI) and why it broke things so badly.


Importing Notes with external identifier I'm trying to import notes into CiviCRM with only an external identifier. Inside the current database, the contacts are already assigned these external identifiers correctly within CiviCRM.

I was recently given a .csv file with three columns: Name, External Id and Note. I need to ignore the name completely because the name in this .csv file is a combination of Prefix, First ,Last and Suffix as one field. The names don't match up with my current records, because each part of a contacts name within CiviCRM is its own field. Also, I believe there are too many string variances in the combined name structures to effectively parse them out into 4 fields with code.

So with that information, I am trying to ignore the name completely and using the External ID and Note only in the import.

The setting I am using are:
Contact Type: Individual
For Duplicate Contacts: No Duplicate Checking
Dedupe Rule: Left blank

Field Mapping:
Name: do not import
Id : External Identifier*
Note: Note

Result:
9668 errors / 9668 rows
"Missing required fields: First Name and Last Name OR Email Address"

What is the point of an external identifier if CiviCRM still requires another identifier?

My real question is; How do I do an import with External ID only in the UI for individual notes? I am thinking about writing a PHP script to try and force the notes into the MySQL database, but setting up a custom script seems like overkill for something I thought would be trivial.

Note: I can't use email because many of the contacts don't have one

You need to choose 'Update' for 'For Duplicate Contacts' option on the import screen if you want to update the contact using import.

Cheers

Pradeep


How to fix "Database In Unexpected Version" I am starting to use CiviCRM under Drupal 7 and feel myself still as a newbie.

I made a backup with the Backup and Migrate module of Drupal (site + DB). As a good practice, I tried immediately after the backup to restore the backup, just to learn how to do in case of trouble.

I better did not because I got the error message:

Your database is marked with an unexpected version number: 5.22.0.
The v5.20.2 codebase may not be compatible with your database state.
You will need to determine the correct version corresponding to your current database state.
You may want to revert to the codebase you were using until you resolve this problem.

The menus of CiviCRM are now at the bottom of the screen with an ugly layout.

So backing up and restoring with the module Backup and Migrate seems to be a perfect instrument of (hopefully partial) self-destruction of Drupal or CiviCRM.

I have no idea on how to "revert to the codebase you were using until you resolve this problem". Any help will be appreciated.

Your database is running on CiviCRM 5.22.0. scheme
Your plugin in /sites/all/modules/civicrm is CiviCRM v5.20.2
You need to download and follow upgrading docs from Civicrm to upgrade your plugin folder to CiviCRM 5.22.0 or above, then do the database upgrade to make Civicrm plugin and the running database scheme run on the same version.


How to use waitlists with price sets that have registration limits? I have built an event registration that uses price sets to set limits on the number of people who can register from certain audiences. Once these limits are reached it is currently responding "event is full."

The desired behavior is that either using the price-sets or using participant types, the event would always waitlist when the limits are exceeded, and that the waitlist based on the group, rather than the event as a whole.

Example:
Group A has a limit of 50 seats
Group B has a limit of 20 seats
Group C has a limit of 100 seats

If Group A gets full, they go on the waitlist. Other groups can continue normal registration until they are full, and then they are waitlisted. Spots that open up for waitlisted registrants must come from the group they selected initially.

The only way I see to accomplish this without writing custom code is to create 3 Civi events. You'd then:

Create a page on your website describing the event, with 3 different registration links.
Give your 3 events the same date, event type, etc, but different limits and pricing structures.
All three can be set to roll over to waitlist after the limit is reached.
Give your events clear names like "Our Gathering (Group A)", "Our Gathering (Group B)" etc.
Set up an event participant report that lists the participants from all 3.


Where to place triggerInfo php file Joomla/CiviCRM.

Neophyte Warning!

I've written a triggerinfo hook as per this article.

What I don't understand is where on the file system is one supposed to place the PHP file so that when one requests a trigger rebuild, the file will be found, and so that when an upgrade occurs the file will not be overwritten.

Can someone help me please?

Regards
Simon

You should create an extension. See the instructions for civix. One thing that civix can do is generate a skeletal extension. After running civix generate:module you would add your code to the main php file in your new extension. See also Extension Structure.


Unable to run a batch update of contribution soft credits I created a profile with only two fields:
Soft Credit
Soft Credit Type
I intend to use it to go back into my contributions and assign soft credits to contributions.
First I go to Contributions -> Find Contributions and execute my search.  I select 'Update Multiple Contributions', and I select my Soft Credit profile.
The relevant contributions are displayed.  But the Soft Credit and Soft Credit Type fields are blocked/blank.  I know some of my contributions already have soft credits assigned but that information doesn't show.  And I am not able to assign new soft credits to any contributions.
I thought this functionality was added in 2013: https://wiki.civicrm.org/confluence/display/CRM/Soft+Credit+Enhancements+-+4.4
I have no trouble updating contributions' Thank You dates with another profile.  What am I missing?  Thanks!

Currently updating contribution to add/update soft credits are not supported. I feel Updating soft credit was missed during initial implementation. We will need to submit a core fix to have it working for Contribution Batch update.


How to install wkhtmltopdf Libraries? Drupal 7.59 / Civi 4.7.27

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

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

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

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

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

As Pete says, not really a Civi question ... but since it is here:

I think there is a typo in the installation instructions at https://www.drupal.org/project/views_data_export_pdf

The first step reads:

  Place WkHtmlToPdf library under ...

but should be:

  Place phpwkhtmltopdf library under ...

phpwkhtmltopdf provides the php files you listed, not WkHtmlToPdf

Note also that 'scr' in the file list should be 'src'


editing auto invoice How do I edit the organization's contact information on an invoice automatically generated when a person signs up for a CiviEvent and chooses to Pay Later (also for event registration confirmation)?  The invoice was created by a developer the organization no longer uses, and the organization's address and phone have changed.  We currently have Joomla 3.3.1 and CiviCRM 4.4.5

If the organization's information in its Civi contact record is correct, then the next place I would look would be in the message templates (Administer > Communications > Message Templates, the templates for receipts are under System Workflow Messages).  You should be able to locate the information in those with a find - if you are not familiar with Smarty, however, be careful not to modify the code around the information as you might inadvertently break the template.  (It's probably a good idea to save the version currently in use before you start modifying, just in case you need to step back.)

Hope this helps,
Lesley


Order of membership types on contribution page not correct Does anyone have any ideas why the order of membership types wouldn't be correct on a contribution page? The order in the contribution page settings matches the order defined in Administration - Membership Types, but the display of the membership types is in a different order on the public facing page. I can make the order change by changing the order of membership types or unselecting some of the membership types on the contribution page, but not so that they are actually in the right order. I also note that trying to change the order in the membership types doesn't work right (sometimes membership types don't move at all, sometimes they move in unpredictable ways).
Any thoughts on why this might be? I cannot reproduce this on the demo site. 5.35 on Drupal 7, here is the contribution page. No default membership type set on the contribution page and we do have some old disabled membership types as well.

Turns out we had almost all of our membership types with order = 1. Using the up and down arrows didn't seem to fix this, but going through one by one multiple times and editing the order values for each membership type did eventually sort this out. You have to edit and save the contribution page to have the change in order show up.


Error in WordPress affecting site editing When I try to edit pages in my WordPress site, I get a message on the editing page: The site is experiencing technical difficulties. Please check your site admin email inbox for instructions.

The email I receive about the error states:

Error Details

An error of type E_PARSE was caused in line 1 of the file /home/susquehanna/ssorchestra.org/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(207) : eval()'d code. Error message: syntax error, unexpected 'clone' (T_CLONE), expecting '('

If I deactivate CiviCRM, I can edit my site like normal, if it's activated, I get the error messages. How can I fix this?

CiviCRM 4.2.4 is a very old version - it's from 2012.  It's not compatible with newer versions of PHP - I'd be surprised if it worked with PHP 5.6, let alone 7+.  You can downgrade PHP or upgrade CiviCRM - but since you're upgrading from such an old version, be sure to a) take a backup of the database before beginning, b) upgrade a few versions at a time (I'd go to the last version of 4.4, 4.5, 4.6, 4.7 before going to 5.18), c) if you DO have to restore the database, be sure to delete the existing database before restoring the backup.