How long is start date? 00h00mm00ss or a 24hour period? I have simple membership statuses that say:
Status 1: from membership date to start date
Status 2: from start date to end date.

On start date, the membership has changed from not member to member but the status stayed on Status 1. (I have set the cron every hour so it would be updated the way it should).

When is the time limit: 00h00mm00ss or a 24hour period?

How does it work in CiviCRM?

After testing, here is how it works.

If we use again my example with twice the same event date 3rd of April:

Status 1: from membership date to start date
Status 2: from start date to end date.

Status 1 will change by the end of the 3rd of April which means start date from the previous status is "Master" and start date lasts 24 hours. Status 2 will appear on the 4th of April. And this is not related to cron Job.

So if you want to start Status 2 on the 3rd of April at 00h00'00", for example if an Insurance is running from this date or if the member has to be of legal age, then set the end event of Status 1 on start date and -1 Day.


CiviMail problem; possible Cron Error: EntityMalformedException: Missing bundle property on entity of type node. in entity_extract_ids() After making core updates in Drupal commons, from 7.37 to 7.50, scheduled Civi mails are not being sent. Cron jobs are still set up. Before this update, we've been using it for years with no known issues. Using CiviCRM 4.8.7. Currently trying to upgrade now but there are other roadblocks also.

Watchdog shows the following error for the time of the scheduled mailing:

error    cron     EntityMalformedException: Missing bundle property on entity of type node. in entity_extract_ids() (line 7953 of /var/www/html/example/docroot/includes/common.inc).

Turns out that this cron error is unrelated to CiviMail going out. I resolved the problem by changing the group owner and permissions of the /sites/default/files/civicrm/templates_c folder, which was effecting /mail.log. The group permissions was changed to root, which won't work for the mail.

I am still getting this cron error, but know now that it probably has to do with Drupal alone.


Non-admin role can see CiviCRM links in profile, no privileges selected I am building a new website but migrated the entire CiviCRM database, files and settings from the old site. Authenticated users and other roles are able to see fields from the CiviCRM that pertain to them as well as a link to edit them. There are no CiviCRM privileges selected so I feel like there may be some custom programming at work here.

What I know:

No privileges are selected for role in Drupal
Links go to tabs they can edit from their Drupal profile (see screenshots)
At least some of these fields are custom in the CiviCRM

Screenshots

You can add visibility to specific roles on Drupal profile so they can contribute information when editing their profile.

The custom fields in Administer > Custom Data and Screens > Profiles has a setting: view/edit Drupal User Account. Select or deselect as desired.


Two civicrm contacts have become "mixed" somehow I have a very odd situation.
I am user 1 in drupal and contact 25,000 in my civicrm. My contact record has a little /1 which links to my drupal record. My name is correct.
I am currently logged in.
However whenever I make changes to another contact record, if records the change as having been made by another contact in the civicrm database, let's say 25,001. This contact does not have a /x and there is no drupal record for this person. However when I try to delete this record it says I am logged in as that person so I can't delete them.
I am wondering if there is a table in the mysql of civicrm which matches the civi and drupal contacts up. Or indeed if there is some other thing I could look at to start trouble shooting.
Thought very welcome!

There is a table civicrm_uf_match but also during certain situations it will match on email. So check both those things.


api csv import - cannot find start page I have installed the api csv importer

https://civicrm.org/extensions/api-csv-import-gui

I cannot find where the start page is.

I have looked in read me which says civicrm/csvimporter/import

However I get an error message CRM_Core_Config::$maxImportFileSize.

I had this problem once before and managed via google to find the answer. Frustratingly I did not write it down and now cannot work out how to get round this. Has anyone got any tips?
Thanks
Caroline

you are correct, the page is civicrm/csvimporter/import

(as defined here: https://github.com/eileenmcnaughton/nz.co.fuzion.csvimport/blob/master/xml/Menu/csvimport.xml)

Your error is something else, like not having a compatible civicrm version. Can you give more details on your configuration? what version of civicrm and what CMS do you use (drupal, wordpress or joomla)?


Receiving error message blocked 444 When attempting to give a user administrative permission I received this message :blocked 444. I can no longer access the site. I tried re-booting my computer - that did not work. How can I fix this?

Many thanks.

It is very likely not linked with civicrm, but an issue with the CMS that is around it (drupal, wordpress or Joomla). You should check on the support of your CMS.


Sync smart group to WordPress role, group, or capability I have a WordPress site which is already using the CiviCRM WordPress Member Sync plugin to sync memberships to roles.

On this same site, I also want to show/hide certain content based on the user's having a membership of any type, age, or status -- basically, if they've ever had a membership, WP should use that fact to show/hide some content.

This show/hide should be possible with roles, capabilities, or groups, but I can't yet find a way to sync this "ever been a member" status to one of those. It seems like it requires a smart group in CiviCRM, and then I don't see any existing plugins that support syncing smart groups to roles, capabilities or groups.

Also, we need to continue using CiviCRM WordPress Member Sync for its current usage, and it doesn't seem to support additional sync rules beyond "one rule per membership type" and "only sync to roles, groups OR capabilities, but not to any combination of those."

Is there a plugin or combination of plugins that will allow this to be done? Or does this need a custom-built plugin?

I would move to using groups and not roles for permissioning because it gives you more flexibility. People can be in multiple groups then.

There is the CiviCRM Groups Sync which syncs a regular CiviCRM group to a WP group. So that may be an option by auto-adding members to the CiviCRM group and creating their WP user at the form-level.

The other option is to improve the plugin by having it sync smart groups.


Can you import data from Excel or WORD directly into CiviCRM? We have donor lists in Excel--can that data be imported to CIVICRM?

Yes! CiviCRM can import CSV files (Excel can save/export into that format).

For more information, see Importing Data into CiviCRM.

Please note this encouragement on that page:

  For more details on how to think about your data before importing into
  CiviCRM, please read the section on "Organizing your data", especially
  "Mapping your data into CiviCRM".


Event registration using External Id to match contact. Is is possible using a webform or profile to register for events using only the external id number. Matching the contact via email address (when a user is not logged in) always ends up being messy.

Mike,  without a customization you can not do this with events/profile.  I am not sure if it can be done using a webform (the webform bypasses the event submission rules)

You can test this, not on your production site, by setting your unsupervised rule to only consider external_ID and see if it works.  I'm curious.   If that works, then you should be able to use force that webform to use a different rule, but I believe that would also be custom.


What is the API for class CRM_Civirules_TriggerData_TriggerData? I only manage to get the value of contactID from my processAction using the variable of class CRM_Civirules_TriggerData_TriggerData using getContactId().

I would like to know if I am able to get ParticipantId or EventId since the rule is triggered when participant status is changed ?

thanks,
j.

What you could do is use the getEntityData? That should give you all data that is avaiable for the entity in the triggerData. The contactId is special as we tend to want to do things with contacts :-)
Does that help?
So an example:

$contributionRecur = $triggerData->getEntityData('ContributionRecur');

which in your case is likely to become

$eventData = $triggerData->getEntityData('Event');


Directories not writable After installing civicrm in wordpress i have this error, see screen cap,
All my directories ../plugins/civicrm and ../uploads/civicrm have all permissions.
And when i click on details, i have no response.

I have forgotten a directory ?

Thank you

Ok, I found the problem, disk space exceeded on server. That is the reason it could not write.


How to create the best front-desk contribution flow using CiviCRM? The scenario is a "front-desk" form for new member signups. Organisation takes cash / card for payment on the day, so CiviCRM is not processing payments, and payments should be recorded as completed. Desk staff will use a form to record the new member's contact details, take payment, and initialise the membership.

The form should:

Require first & last name & email
Record amount taken for membership (may be weekly or annual fee)
Save the new Contact
Save the new Membership with 12 month expiry
Save the initial Contribution and flag as completed
If weekly option selected, perhaps create a pledge?
If possible, option to select completed or pending status (latter for those setting up AP payment)
Require minimal steps for entry (eg skip confirmation screen, don't require billing address etc)

The org will be offering self-service signups to the public via their website at the same time, but the ideal UX for staff vs new members is different so these are different requirements.

It's possible to use CiviCRM's regular Contribute form to achieve most of this, and there's a special cid=0 parameter (civicrm/contribute/transact?cid=0&id=X) to use a Contribute form to sign up a user who is not the logged in user - but that means getting staff to use a public-accessible Contribute form, and lacks the ability for staff to record the payment as completed.

Can CiviCRM Profiles record a new contact, contribution and membership in one form submission? How else can this best be implemented?

Thanks!

Would something like this page work for you:

Or this one:


Restrict location types available to specific contact subtype We have a contact subtype that needs to have location types of 'Postal' and 'Geographical'.

I can edit the location types list to create those entries, but is it possible to restrict the available location types for only that contact subtype so none of the default locations (which we still want for individual contacts) are shown to users?

It'd also be handy to restrict which location types appear in which fields as, obviously, a postal location for a phone doesn't make a lot of sense!

You can not restrict location types to specific contact types in core CiviCRM.
Obviously you can develop and extension that does this.


how can I create an hook when external id change I would to ask you , on how can create an event (programatically) when I change the external ID in contact form, how can I t make some kind of process like validation in another module or service I know I can create something like a hook but I dont know how to start working with hooks in civiccrm, is there any document, book ,link, video, note where I
can learn about it? I would really appreciate this, thank you in advance.

Create an extension

The first step to create a hook is to create an extension.
I'd recommend installing civix which can generate an empty extension by simply typing the command :

civix generate:module myextension

Go check https://docs.civicrm.org/dev/en/latest/extensions/ for more details about extensions.

All you need to know for now is that civix will create a file called myextension.php where you can put your hooks. There are a few hooks commented as examples in the generated files.

Create the hook

A hook is simply a function that start with the name of your extension and finish with the name of the hook. For example hook_civicrm_post will be named myextension_civicrm_post in the extension we've just created.

In your case, I believe hook_civicrm_post is the one you want to use but you can see the documentation about the hooks in :

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


Impossible to disable logging I am on Civi 4.7.6 / Drupal 7.5

I have not been able to record any new phone numbers for some days (via Webform Integration).

I realize that I have lost a number of log_civicrm_... tables (those alphabetically beyond ..._payment_processor_type), and this can be the reason why.

Thus, I would like to disable logging (via Administer > System Settings >Misc (...) > Logging), but I get this error : "Save failed : DB Error : unknown error".

I assume that this error is due to those missing tables.

How can I get out of that ? (I am not a programmer)

...

As a matter of fact, I have an other Test Civicrm, where logging is disabled, and when I want to enable it, I get the same error, and there is no enabling.

Anything in relationship with Drupal ?

BTW, I have all privileges on thoses DBs

Fortunately, in CiviCRM 4.7 (and Civi 4.6.17+), installing ANY extension will recreate your missing logging tables.  Not that enabling an extension isn't sufficient - you must install an extension.  See CRM-15078

The reason this works:  If advanced logging is enabled, extensions without a corresponding logging table will generate errors.  Because an extension can add a table, there's a function that runs whenever an extension is installed called "fixSchemaDifferences".  It checks for any tables without a corresponding logging table and generates it - whether or not that table was added by the extension or not.


How can I automatically redirect anonymous users to a login page? I'm using WordPress. I'm setting up various directory pages for registered users at URLs like mysite.org/directory. If a user is not logged in and navigates to that address they'll get:

This message is not useful to users. I would like instead for something like an automatic redirect of anonymous visitors to wp-login.php. Or failing that, simply change the link "Return to home page" with a link to the user login page.

More Info: Using a plugin to restrict access to profiles to logged-in users does not work as the Civi error overrides any page permissions. This is true regardless of the hijack content option.

Also checked out the page redirect extention but it doesn't appear to be for WP.

A solution is to restrict access to the WordPress page that you are inserting the directory short code into. A plugin such as 'Members' allows you to restrict access to pages & posts by user role, customize the message visitors see when they do not have permission and provide a login widget.


WP-CLI using GMT/UTC Timezone on cron jobs Not sure what exactly broke, but upgrading to CiviCRM 4.7.1 on CentOS 6 required adding PHP 5.4 via the SCL repo.  Something in that process broke the cURL/wget/php cron job calls.  (Invalid username/password despite logs showing it correctly.  See https://issues.civicrm.org/jira/browse/CRM-17981)  So, I created a cron job with:
scl enable php54 "wp --user= --url= --path=/path/to/wp/ civicrm api job.execute auth=0"
It runs, and everything seems fine.  However, when I go to Scheduled Jobs, everything reports as using a GMT/UTC timezone.  If I click to run manually, it reports the local time.  I've check the php.ini file and it has the correct timezone declared, as does the site's Settings page.  Anybody got a clue?

wp-cli doesn't bootstrap the settings, so doesn't load the timezone.

Because of this exact issue, I wrote a patched version of the CiviCRM extension for wp-cli to add timezone support.  It's available here.  As far as I can tell, the original author has abandoned the project, because they haven't merged any pull requests (including this patch) in over a year.

You can also use wget-based cron - but then you're subject to your webserver's PHP timeouts, as opposed to the CLI PHP timeout, which is usually higher (or non-existent).


Solved: Is this a bug - [civicrm.files] variable Drupal-7.54 , CiviCRM-4.7.16
Multi-site / Aegir platform.

On a clean Drupal+CiviCRM instal the autogenerated path for the [civicrm.files] variable in 'Settings - upload directories' differs from the URL path generated in 'Settings - Resource URL'.

In Settings- Upload Directories the civicrm.files variable is: var/aegir/platforms/platform_name/sites/siteURL/files/civicrm

In Settings- Resource URL the civicrm.files variable is: h t t p://siteURL/sites/default/files/civicrm/

The problem does not arise in a non-multi-site environment, where both paths point to 'sites/default/files/civicrm (as confirmed on the sandbox demo).

This also seems to affect the path to the files/civicrm/persist directory.

One effect of this seems to be on CKEditor: when the CKEditor configurator is used it creates files (e.g. crm-ckeditor-civimail.js) in the persist directory. But these files are ignored when CKEditor is used in Civimail (see Solved: How do I allow all tags in CKeditor, and 4.7.15 breaks civimail styles and templates (fullPage doesn't help) and maybe CiviMail template format in HTML not saving

UPDATE:
A fix for multisites and Aegir setups will come out in CiviCRM 4.7.21.
See https://issues.civicrm.org/jira/browse/CRM-193

The fix for our problem ended up being somewhat multidimensional.

The patch in https://issues.civicrm.org/jira/browse/CRM-19303 solved the issue of the autogenerated path for the [civicrm.files] variable in 'Settings - upload directories' differing from the URL path generated in 'Settings - Resource URL'.

Though the issue doesn't seem completely solved, the patch has very recently been merged https://github.com/civicrm/civicrm-core/pull/9409

(There is a bit of a rabbit hole that leads to https://github.com/civicrm/civicrm-core/pull/9053).

But this did not totally fix the problem for CKEditor as the CKEditor config file is being placed in the persist directory (instead of persist/contribute) and the persist directory kept returning  a 403 error. Until CRM-19303 is fixed we circumvented it by allowing the vhost to read the persist directory instead of persist/contribute. We temporarily patched hosting_civicrm to do this.

Aegir was also throwing some file permission errors when creating new sites, and appears to be a different issue, see https://www.drupal.org/node/2791953. We applied the patch which will likely get committed.

We had to enable the Aegir fix_permissions and fix_ownership modules for this, which are experimental, but somewhat necessary here.

For now you still need to manually run a Verify on the site after creating it.

Thanks to Kainuk (https://civicrm.stackexchange.com/users/110/kainuk) for his pointer and to Guillaume Boudrias from praxis.coop (https://www.drupal.org/u/gboudrias) for going down the rabbit holes to fix the problem.


Is there a way to prevent two 'home' addresses for a contact? I'd like to prevent a single contact from having two addresses with the type 'Home' (or 'Work', etc.).  Is there a CiviCRM configuration, or an extension, that provides this functionality?

The form validation in the user interface will prevent this. So there's no need to have a setting that would prevent it.

But the API does not prevent it: you can,  for example, create a second Home address for a contact through the API.  There is no API configuration or option to prevent this.

Thanks @Coleman for pointing this out.


Does CiviGroup Roles Sync work with bulk changes to groups? Using CiviCRM 4.7.17 with Drupal 7.54

CiviGroup Roles sync adds and removes Drupal users from Drupal roles when changes to CiviGroup groups are done one Contact at a time from the groups tab for the Contact. So the sync is set up correctly.

But when I add or remove Contacts to/from CiviGroup groups in bulk from a list of Contacts, the changes are not synced to the Drupal roles.

These are NOT Smart groups by the way.

Am I missing something? How can I do bulk add/remove Contacts in Civi and have the Drupal roles synced accordingly?

Thanks for any suggestions.

From what I understand CiviMember Role sync and CiviGroup Role sync auto-mapping - are evaluated at the time the User logs in.

Login -> is user in a specific Group -> ah yes -> so assign role x

So there really is no need to hit the sync button - I don't think; all is well on login.


Calculate Contact age in a Drupal view I'm exposing civi contact data in a drupal view. I can expose date of birth, but not the contact age field.

Anyone know of a module/ combination of modules that will allow me to calculate age in years within the view?

In your view, pull in the CiviCRM birth date field.
Under date format, select Time ago.
This will present the D.O.B. field as 40 years 7 months

To remove years and months from the output you can ‘Rewrite results’ in the view and ‘Trim this field to a maximum length’ and set ‘Maximum length’ to 2 characters


Creating ACL for Smart Groups Is it possible to create an ACL associated with a Smart Group?

I'm attempting to create a members directory that is only accessible to members. I can't seem to get it working. Here's what I've done so far:

I created a Smart Group called "Active Members" that includes any member of the club (status new, current or grace).
I made the Group “Members” as the parent group of the Smart Group "Active Members" created above. This had the effect of making the Smart Group disappear, and when you click on the list of members of “Members” it lists everyone that matched the search criteria for the Smart Group.
I created an ACL Role “Member”.
I assigned the Group “Members” to the Role “Member”
I created an ACL allowing anyone with the Role “Member” to access the Profile “Directory” to perform the operation “Search”

After doing all that, I figured I had it. This was going to work, and all would be right with the world. I was wrong.

The next thing I did was to create a new ACL allowing anyone with the role “Authenticated” to access the Profile “Directory” to perform the “Search” operation. Then it worked. However, if I understand this correctly, this means anyone that logs in, regardless of their membership status, will have access to the directory.

What troubles me is that the Member Role, which is associated with the “Members” group, which appears to contain all of the active members (by way of a child Smart Group) should have allowed it to work without having to widen the scope to “Authenticated”. I’m guessing that the child group doesn’t inherit the permissions of the parent group.

I don't want to manually add my members to the group members, I want that to be automatically governed by the status of their membership, hence the use of the Smart Group.

Smart Groups could be a pain in the ass in CiviCRM. They are a powerful feature but when it does not work it is hard to get it working again.

There are some alternatives to smart groups. The SQL Tasks Extension or CiviRules can add contacts to a regular group based on a Query (with SQL Tasks) or on a Trigger (with CiviRules). You can then setup this regular group as an ACL Group.


Stripe- Cancel recurring contribution In testing CiviCRM/Stripe, we setup a recurring contribution and let it run for two months and then attempted to cancel it via the link in the email sent to the donor.

This resulted in the recurring payment being cancelled in CiviCRM but not in Stripe, so that the user will continue to be billed until someone logs into our Stripe account and manually ends the recurring payments (and no notification was giving to us on the admin side that someone attempted to cancel their 'subscription').

Our previous solution, using a Drupal module to handle recurring payments, allowed for seamless cancellations of recurring payments with Stripe. (We are running D7 and have installed the latest CiviCRM and Stripe extension)

Is this functionality working in Stripe?  I am assuming it is and that we missed something in the setup as it does not seem that Stripe would be a viable option if donors are unable to cancel their recurring contributions.

Thank you for any insight.

Rachel

The way to cancel recurring contributions when using the stipe extension is to cancel to recurring contribution in stripe. Stripe then sends that event to CiviCRM and the record is updated.

However it might be worth looking at this pull request to the stripe extension which claims to allow the behavior you are looking for.
https://github.com/drastik/com.drastikbydesign.stripe/pull/241


Anonymous users cannot register for a civievent CiviCRM 4.7.6 and Drupal 7.43.
I created a CiviEvent and enabled online registration. I can access the registration page when logged in as the administrator but anonymous users get this error message:

The requested Profile (gid=12) is disabled OR it is not configured to be used for 'Profile' listings in its Settings.

Drupal permissions for anonymous include CiviCRM: profile listings and forms, CiviCRM: profile view, CiviCRM: access all custom data, CiviCRM: view all activities, CiviEvent: register for events, CiviEvent: view event info.

When you create an Event you specify what Profiles should show eg at http://d46.demo.civicrm.org/civicrm/event/manage/registration?reset=1&action=update&id=3 you can see it has Include Profile = Your Registration Info.

In this case it sounds like you have some other Profiles in use (instead or as well)

And either those Profiles are "not configured to be used for 'Profile' listings in its Settings" - which is what your error says - or the Profile might have incompatible fields included in it.


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

d -exec chmod 755

f -exec chmod 644

Please help me ASAP.

Arvind,

Are you facing problem in reports or when you view mailings?


Pay Now on Dashboard - too many redirects Not sure what the issue is - but if someone tries to pay an unpaid registration for an event or membership - or incomplete contribution - we get the issue of too many redirects. I have posted about this before - the issue was the contribution page was disabled or no longer there - but this time - the contribution page is active.

Here is an example of how a link is being parsed: (### are numbers)

https://org.org/membership/member-dashboard/?page=CiviCRM&q=civicrm%2Fcontribute%2Ftransact&page=CiviCRM&reset=1&id=&ccid=###&cs=&cid=###

Looks like the page ID is missing - but I could be reading this wrong.

Can you update the setting to set the contribution page to use for 'Pay now' pending contribution?

Navigate to CiviCRM >> Administer >> CiviContribute >> CiviContribute Component Settings. Select contribution page for 'Default invoice payment page' field and save the form.

Cheers

Pradeep


Does the core Moneris payment processor work? I have a US-based org that is exploring using Moneris with a CiviCRM contribution page. The core Moneris payment processor seems a little rough -- is anyone using it/does it work? The Wiki page for Moneris configuration mentions changes to the mpgClasses.php file but the link to the patch is non-existent. Are the required changes documented anywhere else?

I also notice there is a newer "replacement version" of the core files in process (by Alan Dixon), but apparently recurring is still "fragile" and it is not working for the US (yet). Will this version end up in core?

Our general strategy with payment processors is to get most of them out of core and into extensions, where they can be better maintained, so no, this is not going back into core. In fact, it's because Moneris didn't ever respond to the license questions about their mpgClasses.php file that it started falling out of core ...

I'd be happy to work with you to get the US code working. Contact me via the form:

http://blackflysolutions.ca/contact

with details about your needs and I can update my extension to support US$.

Alternatively - if your organization is a non-profit, I'd also recommend you compare iATS Payments services, they tend to be better (less expensive, more features, better service).


how to add contacts to smart groups I have entered about 5000 contacts and i want to add some of these contacts to a smart group. This smart group is a list of our paying members. How to add individuals from the list of contacts to a smart group? i ihave done Contacts>Manage Groups. Then i select the particular Group (which is called BI Members). This gives me a list of contact who are already members (with the help of a co-worker who left the organization). Then i select "add contacts to BI Members". i enter a name of a contact and it appears in the list. i select and hit add. but the contact is not added to this smart group.

If you want to use a smart group (because it automatically keeps itself updated based on certain criteria) you start by doing a search. In your case, find all people with a membership (Search > Advanced Search). Then you save your search as a smart group by selecting all the results and in Actions > Create Smart Group. Then give it a name and it will keep itself updated for you. As others mentioned, if you want to add people manually, then you would create a regular group, not a smart group to keep it clean and simple.


CiviCRM Search not working Here is what is going on.
I'm trying to do a search within my CiviCRM, however, I'm getting the error message:
One of parameters (value: sort_name) is not of the type MysqlColumnNameOrAlias.
So I'm looking at the following log and one of the messages in the log:
Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in require_once() (line 218 of /home3/isrcus/public_html/sites/all/modules/civicrm/CRM/Core/ClassLoader.php).
I'm using Drupal 7. Not sure what version of CiviCRM I'm using..

Lots of folks are responding in the comments, but I'll try to give a non-technical answer.
Short Answer: You need to upgrade CiviCRM.
Longer Answer: CiviCRM is written in a programming language called PHP.  Over time, new versions of PHP come out.  CiviCRM must be updated in response.
It sounds like your webhost upgraded your PHP version to one that didn't exist when your version of CiviCRM was released.  So any issues introduced by the newer PHP are affecting your experience.  Newer versions of CiviCRM support newer versions of PHP, so you must upgrade CiviCRM.  If you can control your PHP version yourself (some webhosts allow this, others don't) you can try downgrading PHP as a temporary measure, but that's not particularly secure or sustainable.


CiviCRM on WordPress wont Install Issue I'm brand new to CiviCRM and have been asked in stall in a test site and review how it works.
I have the latest WP 5.5 installed.
I've uploaded CiviCRM via ftp to the plug ins folder.
I went to the installer and I got the error in the screen shot below.
Had a look at docs and I updated PHP to 7.2 and same thing happened.
Can anyone tell me if this is common and what fix may be required or is there a doc you could direct me to?
Many thanks,
J
THE ERROR:
In CiviCRM Database Details
IN RED:
Can I create temporary tables in the database? = Could not create a temp table.
Can I create lock tables in the database?      = Could not create a table in the database.
Can I create triggers in the database?         = Could not create a database trigger.
IN YELLOW
Is the utf8mb4 charac=hter set supported =  It is recommended, though not yet required, to configure your MySQL server for utf8mb4 support. You will need the following MySQL server configuration: innodb_large_prefix=true innodb_file_format=barracuda innodb_file_per_table=true

Seems like your Civi MySQL database user does not have sufficient privileges attached to it to allow it to install Civi.
This link here should provide you with the information that you need. It is quite old but should get the job done - https://forum.civicrm.org/index.php%3Ftopic=23489.0.html


Randomly Generated user Passwords, Local Cron Logs and Cron for CiviCRM Wordpress  4.4.2 | CiviCRM 4.7.1

One thing I noticed about CiviCRM cron and one question...

Observation:
Cron won't run if there are some escape characters randomly generated by Wordpress.

I was getting this in my cron daemon emails:

/bin/sh: W_!1IUHzMR: command not found
ERROR: Invalid username and/or password

I changed my password to something less random and it now works. This might frustrate some users who are using Wordpress's own random generator. I didn't see anything about it in the CiviCRM cron installation documentation, so it frustrated me for a while.

My question:
I'd like to do log my cron task like this:

*/15 * * * * /usr/local/bin/php /home/me/public_html/wp-content/plugins/civicrm/civicrm/bin/cli.php -s mydomain.org -u me -p myrandompassword -e Job -a execute >> /home/me/cronlog/mydomain.log 2>&1

to log my errors instead of emailing them, but cron refuses to install:

/usr/bin/crontab: installing new crontab
"/tmp/crontab.XXXXax8Prq":3: bad minute
errors in crontab file, can't install.
Do you want to retry the same edit? n
/usr/bin/crontab: edits left in /tmp/crontab.XXXXax8Prq

Is there a way around this?

The Wordpress random password generator seems to create passwords that contain characters that have a special meaning in linux/unix. If you use that in a cron command it will be interpreted by linux based on that meaning in stead of seeing it as a password.

I think your solution is the most clean, make sure the password does not contain the special characters. If for some reason that is not possible you should try "escaping" the special characters. More information at https://serverfault.com/questions/413582/how-to-escape-in-password/413583

Hmm, there seems not that much wrong with your cron command. (except the password should start immediately after the -p, without a space).

The following I could find about your error message: https://www.dougv.com/2006/12/fixing-a-bad-minute-error-message-when-trying-to-use-crontab-with-certain-unix-text-editors/

  This problem most often occurs because you’re using a text editor,
  such as pico, that fakes word wrapping by adding a newline when it
  reaches a certain column position.

  Crontab delimits jobs with line breaks (newlines). Each job occupies
  one line. Therefore, if crontab sees anything other than an integer in
  the first column of a line, it throws the “bad minute” error, since
  the minute argument is the first one crontab encounters.

Could that be the cause?


How to stop CiviCRM deleting a scheduled follow up activity when the original activity is deleted Apologies if this has been asked before. It's been a long day and I can't see anything similar in search results.

When using schedule follow up activity to create an activity, the  follow up activity is deleted when the original is deleted. (Currently happening in 4.6)

I've not seen this happening on other installs (then again, I've never looked).

Is there a way to stop this happening, a magic button I'm overlooking?

This is coming from the db schema. There's a delete cascade constraint on parent_id. You could remove that constraint but it might be used elsewhere for different types of activity-pairing (not followup related)  to enforce data consistency. Would have to review all the activity-related code that uses parent_id. It's also possible that parent_id for this pair of activities is never used again anywhere,  so another possibility is remove that linking for followups (via some code, either override or extension), but again would need to review.


CiviCRM Email seems not to use Outbound Email settings I've saved outbound email settings with:

Using sendmail
Path: /usr/sbin/sendmail
Arguments: -t -i

When I press "Save and send testing email",
I can receive testing email correctly from sendmail.

But When I send email with CiviEmail, both testing and batch sendings,
Outbound email settings seems to be ignored.

It had worked correctly CiviCRM 4.6,
but suddenly broken after I upgraded CiviCRM to 5.9.1.

I noticed this issue, because I am doing relay_host settings with sendmail.
It worked on 4.6, but after I upgraded, it doesn't.

Any suggestions?

Here is my sendmail setting.
It is working, but when I use CiviEmail it seems not to be used.

relayhost = [domain.for.send]:25
smtp_use_tls = yes
smtp_sasl_auth_enable = yes
smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd
smtp_sasl_tls_security_options = noanonymous
smtp_sasl_mechanism_filter = login
smtp_sasl_type = cyrus
smtp_tls_security_level = verify
smtp_tls_CApath = /etc/pki/tls/certs/ca-bundle.crt
smtp_fallback_relay  = [localhost]

I solved this issue.
This is caused by Civimail script automatically append -f[Return-Path] params when it sends any email.

I fixed CiviCRM core code

packages/Mail/mail.php
and
packages/Mail/sendmail.php

to prevent that.


Wordpress Cron Issues Ok I did search and I do recall fussing with this a bunch when setting up cron jobs, but here is the situation.

I accidentally deleted my civicrm-settings.php file the other day. Really it was no big deal, restored within 5 minutes from a backup only a few hours old. HOWEVER, since then cron has not been running.

Trying to pull it via:
wget -O - -q -t 1 'http://www.SITE.com/wp-content/plugins/civicrm/civicrm/bin/cron.php?name=cronjobs&pass=#####&key=####'

I have been getting:

ERROR: Invalid key value sent. More info at:http://wiki.civicrm.org/confluence/display/CRMDOC/Managing+Scheduled+Jobs

Absolutely nothing has changed
Verified Site Key
Verified administrator un/pw

Tried running it with cli.php and it is still not running (despite setting permissions on that file)

Any incite?

Looks like your user name for this is 'cronjobs'. try creating a new user without the word 'cron' in it. I had a similar issue with a new site recently and removing 'cron' from the user name did the trick.

Hope this helps.


Notes about participants We need to fill some information about people that registered to specific event, for example room number where they will stay. Is it possible to store additional information about participants so that they won't see it? Personally I found the note field on the event registration screen for some participant. We could use it but it doesn't appear in the event reports. So I can't see the full list of participants with that field.

Thanks in advance!

You're on the right direction, participant notes are intended for this. But as you say, seems there is no way to show this field info on an event report.

Exists an improvement registered on CRM-20236
Include "Note" field of Registration record in event participant reports that would do what you want. If this is important for you and you don't have skills or resources to develop it, maybe Paid issue queue  could be a good way to achieve this.


What payment processors work with WordPress Caldera and CiviCRM, and which of those work with recurring This is an open-ended question to pull together information as folk develop more options. The below answer is based on snips from https://chat.civicrm.org/civicrm/pl/4refrsqotib9tf9gyrscffk8my

In response to a question about WP, Caldera and iATS play nicely and do recurring
danaskallman said:

no, it's either of these two add-ons  as of now stripe and authorize. iATS isn't an option for payment processors so it would need to be developed likely.

Andrei said:

the official CF payment add-ons support PayPal Express and Pro, Authorize.net, Dwolla, Stripe, Braintree, and PayFast gateways.
As @danaskallman mentioned CFC integrates with Stripe and Authorize, with integrates I mean that it calculates/updates the payment fees and transaction ids, etc.
And recurring contributions are not currently integrated/supported.

agileware_justin said:

we developed a Caldera payment processor for eWAY Rapid API (eWAY payment gateway) - this hasn't been published OSS yet.
Can confirm, Caldera CiviCRM is missing recurring contribution feature.


Making member-only websites We are a small charity using CiviCRM with WordPress.

I had a look at existing question Member only page-login using civicrm database , but the answer does not address our scenario, i.e. how to integrate members-only login for contacts from CiviCRM and users from WP.

We want to provide some pages for members only.

I use this plugin on one of me other sites but it should work on a site with Civi too.
https://wordpress.org/plugins/buddypress-members-only/

In the plugin settings, you can set the login page and you can whitelist urls on your site that are open to the public.


(Solved) Undefined function in webform_civicrm Drupal 7, Civi 7.x-5.11.0

I've installed the latest webform module and the most recent webform_civicrm from Github.

I'm getting the following error when submitting or trying to access webform submissions:

Error: Call to undefined function wf_crm_apivalues() in webform_civicrm_webform_submission_load() (line 316 of /sites/all/modules/webform_civicrm/webform_civicrm.module).

Any ideas where I can look or advice to fix?

Thanks, Davy

Thanks for letting us know about the problem. I've just pushed a fix into the 7.x-4.x branch to ensure the function gets loaded. You can update your local copy of the module (cd /path/to/modules/webform_civicrm && git pull) and try again.


Link CiviCase with CiviAccounts I was wondering how would you configure CiviCase to link with CiviAccounts.

So for instance: you set up a new case to process a member's expense for train tickets. Can you link that from the case management to the accounts? So that you can keep a log of their interactions and processes, including finances.

In this case you'd normally add various activity types to that case. I.e. create an activity type Expenses Claim and add that.


Sort report by event role and/or status In the sorting tab for event participation reports, I can't sort by role or status. Even those these are built-in fields that it seems obvious people would want sort by, are not in the list of columns- I'm a newbie user, so I suspect it's something easy and I just don't see it??? I'd like the report to be sorted first by status, then by role, but I'd take at least one of two. Please advise, thanks!

The default reporting does not cater for sorting status and role. One way to achieve this is by writing code as Pradeep suggested. Another way is to export the report data to Excel (csv) and do the sorting in Excel.


Invoicing button missing I'm are trying to get the "Tax and Invoicing"(civicontribute) te work. I used these.

It works fine when I select one or more contributions and use the action pull down. But opening the details of an specific contribution doesn't show the Print Invoice of E-mail invoice button, as shown in CiviCRM Userguide:

I use Civicrm 4.6.22 and 4.7.11 and php 5.6.

Any ideas?

Try clearing your caches: administer -> system settings -> Cleanup Caches and Update Paths;


Help adding an Action in CiviRules I trying to add an Action in CiviRules. I am trying to follow the API add instructions.

Here is what I did
1. Copied the file org.civicoop.civirules/CRM/CivirulesActions/Activity/UpdateStatus.php (this looked like an easy edit to do what I wanted--update a field) and created a new file in org.civicoop.civirules/CRM/CivirulesActions/Contributions/UpdateInstallments.php

I edited the copied file (edits in bold)

`
 * @license http://www.gnu.org/licenses/agpl-3.0.html
 */

class CRM_CivirulesActions_Contribution_UpdateInstallments extends CRM_CivirulesActions_Generic_Api {

/**
   * Method to get the api entity to process in this CiviRule action
   *
   * @access protected
   * @abstract
   */
  protected function getApiEntity() {
    return 'Contribution';
  }`

But it does not show up in the Rules option list. I tried a cache clear. What am I doing wrong?

There is documentation on how to add your own action here: https://docs.civicrm.org/civirules/en/latest/create-your-own-action/.

I would recommend reading the documentation, it will give you a better understanding of what is required. And then copy and adapt as much as you like :-)

If you do not see it in the list of actions it is because you have copied the class, but not added a record to the civirule_action table (from what you describe).


City / Town Selection Problem I am using the City / Town option. However, county information is not available when I choose any province. When using information from provincial cities in Turkey availiable. No county. Is it a problem? How to add zone information.

Can you please check if there is any data in the civicrm_county table? It might be that you just have to add some records in there because it is not prepopulated.


CiviDiscount - applying sales tax on discounted price rather than original price I found this in the CiviCRM issue tracker - https://issues.civicrm.org/jira/browse/CRM-16861

This is a pretty major bug for us - Has anyone resolved this issue on their own?

Essentially, when a discount code is applied, tax is applied to the original amount rather than the discounted amount.

We've patched Cividiscount extension which now ensures that the discount also gets applied to VAT/Sales Tax when it's applied to price options.
Here is the PR link: https://github.com/dlobo/org.civicrm.module.cividiscount/pull/131

Have also updated the ticket: https://issues.civicrm.org/jira/browse/CRM-16861

Thanks


Requiring "Assigned" and "Target" contacts when recording Activity When creating a new Activity record, I need to require the "With contact" and "Assigned to" fields have a contact selected.

In the activity/form/activity.php file I can add 'required'=>TRUE to the various arrays, but that setting only works for the fields without a selector (e.g. subject, location, duration).

This can certainly be done with javascript in an extra.tpl file (and might be preferable, as it can be conditional to the activity type), but is there a way to modify either the template or php files to require a selected contact?

The best way to handle this is with an extension that calls hook_civicrm_validateForm.  Documentation is available here: http://wiki.civicrm.org/confluence/display/CRMDOC/hook_civicrm_validateForm


The "cmsBaseUrl" is not set according to the information in civicrm.settings.php Error:
When I check the installation requirements (cv core:check-req) I get an error message that says:

The "cmsBaseUrl" (http://localhost/usr/local/bin/usr/local/bin/) is
unavailable or malformed. Consider setting it explicitly.

Despite this message, there have never been any errors related to the base url when operating the site. I only noticed it when I ran the above check.
Setup:
I installed CiviCRM on Drupal8 with the following cv command:
cv core:install --cms-base-url="https://example.org" --lang="de_DE" -m loadGenerated=1 -v

And looking in civicrm.settings.php I can see that the base url is set with:
if (!defined('CIVICRM_UF_BASEURL')) {
  define( 'CIVICRM_UF_BASEURL'      , 'https://example.org');
}

Troubleshooting attempts:
In civicrm.settings.php it says:

IMPORTANT: Trailing slashes should be used on all URL settings.

Accordingly, I changed https://example.org to https://example.org/ in that file.
I then cleaned up the Drupal and CiviCRM cashes via the admin interface. The error message remains.

Did you run check-req with the --cms-base-url argument? It needs to be specified there too.


How can I track donor movement on CiviCRM? Our organization is using CiviCRM on Drupal and I'm looking for a way to create, track, and report on solicitation plans -- essentially, having a report that forecasts income from a variety of channels (individuals, events, etc) It would track details such as channel (ie individual), ask amount, likelihood, etc. Ideally, this report could be integrated with a contribution report to compare forecast and actual income.

I think a modified CiviCase might be able to handle the solicitation plans, with customized reports, but I'm hoping someone might have more concrete solutions or know of an existing module that can handle both forecasting and contribution reporting.

It is not entirely an answer to your question but you would probably be interested in the extension CiviRules that is being developed. Check:
https://civicrm.org/blogs/erikhommel/civirules-sprint-january-and-march-2015
and/or
http://redmine.civicoop.org/projects/civirules/wiki


Mass change of primary email address I've recently imported about 10,000 records into our database, many of them adding an additional work email address to our existing contacts whose home email address we used to contact.

When the new work addresses were imported, it seems that many/most contacts now have their new work email as their primary.

Is there any way to change the users' primary email to their home one, en masse?

Yes, making use of the api you can change more or less any data. Test it by accessing the api explorer under <your_installation>/civicrm/api.

First check getting emails in question.
Then try out setting parameters like you want.
Combine the calls to either a php script or use api chaining in the api explorer.

Keep in mind that get operations are limited to 25 results by default and that update operations may harm your data – even in the api explorer.

If you have questions consider Using the API or ask here.


Create Drupal user from donation pages? We have one donation page that is just for donations. No Drupal account is created.  Individual members can create free accounts on the D7 site and can also donate through CiviCRM - this part is working as intended.

We want to build a second donation page where a Drupal user account is created.  I was assuming there would be a simple way to enable the username and password inputs, and set a Drupal role to enable, on a particular donation page so the D7 account could be created when the form is submitted, but I don't see how to do this.

Is there a way to either require an account be created, or allow it to be an option from a donation page?

The goal here is to automate the process of setting up corporate sponsors.  Sponsors need to contribute and have a Drupal 7 account created with a specific role so they can access content that is restricted to that role.  They should be able to select a specific package or enter an amount they wish to contribute.

Thanks,
Rachel

Seems you need to add a profile to the contribution page with Account creation required enabled.

To do this -

Check for the profile added to your contribution page on Profiles tab from Manage Contritbuion Pages or by visiting civicrm/admin/contribute/custom?action=update&reset=1&id=<page_id>
Navigate to Administer -> Customize Data and Screens -> Profiles.
Click on Settings link for the profile added to your contribution page (Create if no profile is added).
Open Advanced Settings tab and look for the Drupal user account registration option? input field.
Enable Account creation required and navigate to the contribution page to see the populated drupal username field.


Issue using shortcode to insert Contribution Page into a WordPress Page When I insert a shortcode for my contribution page into a page on WordPress, the text on the page gets duplicated and I can't figure out why.

I'm not sure if this is a CiviCRM issue or a WP issue for my theme, but if I remove the shortcode it doesn't do that, so I figured this is a good place to start.

You can see it here: http://www.gardensedge.org/support/

Try disabling the Jetpack Open Graph component and see if the problem persists.


System workflow message not saving I'm trying to edit the system workflow message "Events - Registration Confirmation and Receipt (on-line)". When I edit it and hit save, it just reloads to a blank (new) message template. No changes are saved. The message is currently set to the default version.

I'm on Drupal 7, CiviCRM 4.7.22. It's a copy of our live site, where I can indeed make edits. Is there some kind of file permission I could have missed when I duplicated the site? I have all the error and logging turned on for this site, but I don't see an error on the page or the Drupal log.

Any ideas?

Mod_security. If you run into this issue, contact your host and have them look at their logs. For some reason, our live site wasn't throwing a mod_security error, but the dev site is. They're whitelisting the issue so that we shouldn't continue to have the problem.


Setting up cron jobs on cPanel Need your help....I'm trying to setup cron jobs using the cli.php command given in the documentation....I'm able to run it directly through the terminal...but when I schedule it via cPanel its gives me an error 'cli.php can only be run from command line.'

if your user has cron access, you can always create a file, call it cron for simplicity sake, in the file add the command you wish to run, for example mine is a bit interesting cause I have to export my civicrm settings at the same time:

export CIVICRM_SETTINGS="/home/domain/public_html/administrator/components/com_civicrm/civicrm.settings.php"
cv api --user=cron job.execute

mind you, thats using the CV command, however, this can still be implemented via the cli.php.
Example:

 /path/to/php /path/to/civcrm/bin/cli.php \
  -s example.org \
  -u myusername \
  -p mypassword \
  -e Job \
  -a execute

save that in the file you created earlier (with your changes of course), then with cpanels cron, just  set the command/job to execute:

sh cron > /dev/null

or

sh cron > /home/domain/logs/cron.log

just make sure the file is outside of the web folder and is executable.


Dropdowns Not Accessible Dropdowns are not accessible when clicked. Only when you close the window does the dropdown become accessible. After the window closes data does not save. Also getting duplicate action buttons on popup windows. I believe it is all related. Running Wordpress 4.7.3 and Civi 4.7.16. Same results on different computers and browsers.

That's it @Carl Miller. I went through each plugin individually.

The Slider Revolution Plugin was doing it.


in-house civicrm install - but remote email install? I've got a decent sized database (170,000 contacts) and I've been thinking lately of ways I could speed it up. Right now I'm on a VPS host with 4GB of ram and it runs... pretty good actually. But there are a handful of things that do take a while. So, I'm looking at upgrading the server to 8GB, but that increases our monthly costs of course.

So, I started thinking about running civicrm locally in my office. I have a spare computer laying around the office the office that would run a LAMP stack REALLY well and would run this civicrm install really well. I could probably put 16GB of ram in it for pretty cheap. This would work really well for us as we only use it as a private constituent management. We don't use contributions or events so people from the outside world don't really need to touch it. We do import contributions and events when needed and that works really well.

The one thing people do from the outside world is click on our emails. We send out approx 250,000 emails a month from this server and that click/read/unsubscribe data is super valuable to us.

So my question is: how could I go about running my local database but still use my cloud host to track and I guess sync back to my local database for click events and email opens events? Is this even possible? Even if I switch to using a 3rd party smtp, the click events are still based on the CMS civicrm install, right?

Thanks for your help!

you could have a look at an extension called CiviProxy we developed a while ago. The major focus is on security as it enbables you to run CiviCRM without having to make your environment publically available.

However, most interesting for you is probably the fact that it enables pass-through of tracking data on opening and click-through rates as well as Sign-on and off of your newsletter (Webpage templates).

Please find more information on the github page and in this recorded video presentation.


Sticking quick search target tyoe While cleaning our contacts database, our users claimed that it would be beneficous to have the quick search bar remember the type of field to search in. In many cases it's helpfull to repeatedly search for zip codes or email addresses or stuff like that.

I had no luck finding information about accessing civi's session with js and therefore I wondered how to implement and decided to walk the extension way by feeding drupal with a cookie in my module's js file. What do you think?

CRM.$(document).ready(function () {
    /**
     * Save quick search type on select
     */
    CRM.$('.crm-quickSearchField').click(function() {
        var label = CRM.$(this).text();
        var value = CRM.$('input', this).val();
        jQuery.cookie('quickSearchLabel', label);
        jQuery.cookie('quickSearchType', value);
    });

    /**
     * Set quick search type on load
     */
    var quickSearchType = jQuery.cookie('quickSearchType');
    if (quickSearchType) {
        var quickSearchLabel = jQuery.cookie('quickSearchLabel');
        var label = quickSearchLabel ? quickSearchLabel : "Suche";
        var value = quickSearchType;
        // These fields are not supported by advanced search
        if (value === 'first_name' || value === 'last_name') {
            value = 'sort_name';
        }
        KompiModsLib.radioSelect("input[name=quickSearchField]", value);
        CRM.$('#sort_name_navigation').attr({name: value, placeholder: label}).focus();
    }
});

And: would it be valuable to add it to the core?

That's a good idea. Here is a refinement of your patch that works it into core using localStorage, which is not CMS dependent.

https://github.com/civicrm/civicrm-core/pull/8485


Upgrade from 4.2.7 to 4.7.13 fails during DB 4.4alpha1 update Joomla The upgrade process keeps failing, I even tried doing upgrades version after version but always when getting to 4.4 it fails when we get the 4.4 alpha1 update, the error that shows is:

[Error: Consolidate activity contacts]
Error Field Error Value
Type    DB_Error
Code    -2
Message DB Error: syntax error
Mode    16
UserInfo    UPDATE civicrm_option_value SET is_reserved = 1 WHERE option_group_id = 62 AND value IN (2, , 3) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 3)' at line 3]
DebugInfo   UPDATE civicrm_option_value SET is_reserved = 1 WHERE option_group_id = 62 AND value IN (2, , 3) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 3)' at line 3]
PEAR_Exception: DB Error: syntax error in unknown on line unknown
- DB_Error: DB Error: syntax error in unknown on line unknown

I keep looking for the error but can't find it, does anyone knows a better way to verify it? Or if you know what error is on this table? (I only left the main columns and deleted the rest)

https://dl.dropboxusercontent.com/u/92433965/civicrm_option_value.csv

Server 1
PHP:5.6.8
MySQL:5.6.24

Server 2
PHP:5.6.28-0+deb8u1
MySQL:5.5.53-0+deb8u1

I see where the problem is happening and I have a solution, but from the CSV you're sharing, I can't see why the problem is happening.

Next time, before upgrading, go to your CiviCRM root and then open CRM/Upgrade/Incremental/php/FourFour.php.  Around line 543 will be a function called activityContacts().  CiviCRM changes how activity contacts are stored in version 4.4+, and this function is meant to facilitate that.

The first several lines are meant to look up the option value records labeled "Activity Source", "Activity Assignees" and "Activity Targets" and set them to be "reserved", so they can't be changed.  Based on the SQL in your error, it's not finding "Activity Assignees" - but I don't understand why, your CSV looks fine.

Regardless - you can fix this by ignoring the lookups and manually change the SQL query to use the values that I can see in your CSV file.

Change these lines:

    $query = "
UPDATE civicrm_option_value
SET    is_reserved = 1
WHERE  option_group_id = {$optionGroupID} AND value IN ($ovValues)";

to this:

    $query = "
UPDATE civicrm_option_value
SET    is_reserved = 1
WHERE  option_group_id = {$optionGroupID} AND value IN (1, 2, 3)";

Re-run the upgrade and you should get past that error.


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

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

On the demo site I took the following route and saw no issues

change the Contrib page to accept Pay Later
completed a Pay Later membership for the demo user
confirmed that by then clicking on Edit for membership at backend, clicking on the Contribution block with 'more' and 'record payment' the membership was set to Current and there was no 'renewal' Activity on their record.

Hope that helps

Data will be on https://dmaster.demo.civicrm.org/civicrm/contact/view?reset=1&cid=203 for less than 12 hours till it is flushed.


Why is there a page in a CiviCRM WordPress install that says "Do not delete this page." A CiviCRM page is created on the site:
my-site-wordpress/CiviCRM
where it says: "Do not delete this page." Page content is generated by CiviCRM "
what is it for? how should it work?
What should appear on this page?
I use WordPress 4.9.6 version - CiviCRM is in a subdirectory
Thanks

CiviCRM has some public-facing pages that it generates. e.g. event registrations, unsubscribe confirmations etc.

On Wordpress the page you're seeing is the one that's used by CiviCRM for these purposes. So it's not a page you use or link to directly yourself, but it has to exist as far as Wordpress is concerned so that CiviCRM can provide dynamic content.

EDIT

Here's an example of when CiviCRM will use this page. You have an event, you want to give people a link to sign up for it.

From the Manage Events page you click (1) event links, then you see (2) test and live event registration links. You right-click the one you want and choose "Copy Link Location" (or whatever similar description your browser offers), and send people the link.

When people click that link CiviCRM will use the base page to decorate its sign up form.


Is it possible to make groups mutually exclusive? If yes, how do you add those constraints?

The docs for Groups and Tags suggests that it is possible by saying that it isn't for tags.

  Tags allow multiple selections - so they may not be appropriate for mutually exclusive characteristics (e.g. "Democrat", "Republican", "Green Party")

I don't think there is any way you can do this using Tags or Groups. The alternative would be a custom field of type radio, and then build Smart Groups off those options.


Is it possible to allow the person submitting a webform with CiviCRM to decide whether an activity is created or now? Is it possible to expose a field on the webform to the person submitting the form to allow them to decide if the activity is created?

There are some situations where we would want the person submitting the form to decide if they would like to create a follow up activity,

Thanks

The following steps should do it (requires version 4.10+ of the webform-civicrm integration module):

Make the "Activity Type" field "User Select"
Customize that field to remove all options except for "None" and the activity type you want.
Optionally rename the field on the webform "Create Activity"
Optionally rename the option labels to "Yes" and "No"


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

This a deal-breaker, true?

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

Yes, you can run CiviCRM on a host which lacks cron functionality. CiviCRM's scheduled tasks can be triggered by HTTP requests made to CiviCRM from anywhere, so you have lots of options.

To do this, you configure cron according to the documentation based on the instructions for using cron via the "URL method".

CiviCRM cron setup documentation (wiki), URL method
CiviCRM scheduled jobs documentation

Do research your options for your existing host fully - you're best off with "proper" cron support if it's available to you, since a simpler setup is going to be more robust. But, if your hosting provider really lacks support for cron, you have other options like:

Any always-on machine which has cron (including an office mac, or a raspberry pi, or your office NAS or home PVR). UNIX is all around you!
Hosted cron services like easycron.com
A Windows scheduled task will do it (adjust Drupal instructions to suit), provided that machine will stay on.
I heard once of someone setting their cron URL as an RSS feed in their browser, so the browser would trigger it with each update ...

Not recommending that last approach  — just mentioning because it shows how you can work around this with a little ingenuity ...

If you do use an external server, beware of forgetting about that cron task - for example if you one day stop using the laptop that's telling CiviCRM to send your emails!

All that said, my recommendation is to select a hosting provider which supports your software well, rather than select your software to suit constraints of any given hosting environment. If your host doesn't support core CiviCRM functionality without some outside help, what results could you expect for successful campaigns and advanced functionality in future?


No address marked as Primary I need to pull a list of members who has no primary address ticked. Has anyone any idea on how I can do this?

When our data came over from our old membership system it took over the addresses but some are not marked as primary and I am trying to find those ones by pulling a list. Thanks

Thanks,

Eileen

Thanks for the additional explanation!  One approach you could try is to use Search Builder (Search > Search Builder) and search for contacts whose primary street address is null but whose street address of your default location type (e.g., Main or Home) is not null.  If that doesn't yield the results you want, then you could search for your other location types as well (e.g., where primary street address is null and (Location Type A street address is not null or Location Type B street address is not null or Location Type C street address is not null)).


Can Honoree type and name be inserted into the Contribution email receipt? I feel like this might exist but I can't find it:

What's the best way to insert honoree information in a thank-you letter to a donor? Especially for batch thank you letters.

I haven't tried this for honoree info but I have been able to successfully add tokens to the email receipt by pasting the token in the message template in administer - communications -  message templates


Is CiviCRM compatible with the CMS system Umbraco? Our organisation is interested in creating our new website using Umbraco, but we are unsure if our CiviCRM system would be compatible. Does anyone use CiviCRM with Umbraco or know if they work together?

Umbraco won't work directly with civicrm (they are written in different programming languages, ASP vs. PHP)

What you can do easily is to host your civicrm with one of the supported CMS (drupal, wordpress or joomla) into a subdomain (eg. members.example.org) and switch the main site to umbraco (www.example.org)

the civi site will not use any CMS feature beside handing the login/password, but might want to customise a bit the layout so it looks more or less like your main website (eg set the colors, put your logo), so you can use some civi pages (like donation, membership registration, event registration...) into that sub site without confusing too much your visitors, and add a link to the civi subsite when needed in your main site.

It's not as transparent and nice as having everything on the same site, but plenty of organisations do have different sites for the CRM and the main site, and it seems to work for them


CiviReport widgets show access denied on CiviCRM Dashboard I've recently migrated a site to another host and pretty much everything is working except that when I go to /civicrm, the dashlets on the dashboard all show Access Denied and a login form.  They are being provided by CiviReport according to their respective breadcrumbs.

In addition, I noticed that I could not disable CiviReport or any of the other CiviCRM Components.  When I click Save on that page, it just bumps me back to /civicrm/admin with no error message.  Going back into civicrm/admin/setting/component just shows the modules still enabled.

I'm still a CiviCRM noob, so it could be something simple.

Check your civicrm.settings.php, and make sure that the CIVICRM_BASE_URL matches your site url.

My site was redirecting http://domain.com to http://www.domain.com, but civicrm.settings.php had the version without the www, which was screwing things up.


Bulk delete of events - is such a thing possible? We've had a bit of a mix up and imported the same set of events twice.  Most if not all of the duplicates have no participants (but I'm not 100% certain of that)

Is there a way to bulk delete these duplicates?  I can't code but I can use sql a bit

I've seen this suggested: "DELETE from civicrm_event WHERE id=1".  is that ok to use on multiple events?  Is it ok to use if an event has participants?

thanks

General advice is don't use SQL directly - use the API.  You don't have to write code if you use cv or API explorer.


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

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

Example screenshot:

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

This was caused by an issue with my local disk cache.  Clearing the cache from my browser allowed the icons to be displayed again.


Will there be a LTS release of CiviCRM 4.6.x that supports PHP 7+ If an organization is currently heavily invested into customizations built for CiviCRM 4.6 LTS, is it possible for them to continue using the LTS version of CiviCRM when PHP 5.6 EOL? (31 Dec 2018) and an upgrade to PHP 7+ is necessary?

This kind of question is hard to answer for an open source project like CiviCRM :-) There is no 'owner' of the product that can tell you this. Nor is there a group of paid developers that will be able to continue supporting this. Considering that I think it is an impossible question to answer, and the wrong one to ask at this point in time. It would have to be one of the considerations when starting with heavy customization.

Having said that, I have worked in closed source situations where this kind of thing was promised by sales manager but never materialised :-). "No we will continue to support this version as long as you want to use it" and then a year later "we really urge you to upgrade as we will no longer support this version".

As an individual and member of the CiviCRM community I would not be interested in keeping a 4.6 version alive in combination with PHP 7. It would probably mean changing the 4.6 to a new PHP 7 compliant subversion, and then keeping it alive. That would leave me hardly any space for making a living. But that is solely as an individual with none of the organizations I work with facing this problem. It is only my personal opinion, it does not mean it is not possible or will never happen.

If there is a large group interested in doing this however you might be able to fund it. Or find partners that are willing to take this on. So I would really urge others to answer your question too!


How can I update the CiviMobile 2.0 extension to the CiviMobileAPI 3.0 extension? I had v2 of the CiviMobile extension installed on a WP/Civi site for testing to see how the mobile app would perform. I see that a new version of the app and the extension has been released, so tried to update the extension and just keep getting a fatal error. Looking at the log, it appears to be caused by an incorrect default value that the extension is trying to set in the 'civicrm_contact_push_notification_messages' table:

   string(986) "CREATE TABLE IF NOT EXISTS  `civicrm_contact_push_notification_messages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `contact_id` int(10) unsigned NOT NULL,
  `message` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entity_table` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entity_id` int(11) DEFAULT NULL,
  `send_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `is_read` tinyint(4) DEFAULT '0',

How can I address this and get the extension installed?

I think this might be the issue.
As posted here: https://dba.stackexchange.com/questions/132951/cant-default-date-to-current-timestamp-in-mysql-5-5
Versions of MySQL from 5.6.x will support this, but I'm currently running 5.5.62 which does not support CURRENT_TIMESTAMP as a default option for a DATETIME. It suggests setting the column type as a TIMESTAMP. I wonder if that will break the extension, though?
Interesting, as I though CiviCRM was now using TIMESTAMP by default across the board.


Membership with recurring fee (monthly or yearly) I really need your advise on how I can solve my problem.
Let me explain first our situation: We have members who pay monthly or yearly his fee. Most of those are paying in cash or bank transfer. What I would like to achieve is that the membership fees are somehow created but pending as long as I did not book the payment. I would like to see an overview of mymembers and if the fee is due or pending. In the Perfect case i would like to put the member to status inactive if he didn‘t pay after 3 months.

I hope it is clear what I need. Otherwise please let me know and i will rephrase it.

Best regards,
Said

If you mark the payment as pending (see screenshot 1 below) then the resulting membership will be pending.  When you update the payment, the membership will be automatically updated.

To set the member status to Inactive after payment hasn't been received for three months, go to Administer menu » CiviMember » Membership Status Rules.  Click Edit next to the Grace status, and set the end event to "Membership End Date" and "End Event Adjustment" to "3 months".  This creates a three month grace period from the membership end date, and will change to "Expired" after that (assuming you haven't changed other membership status rules).


CiviEvent : display future and past events I have two issues on a Joomla website, I want to display future and past events from the CiviEvent component on the front-end but it doesn't work.

Future events: the website only displays the next event and I can't find an option to have more than 1 on the page. Where would I change this ?

Past events : I didn't find anything to display past events on the front-end, there's no menu item available to do this. How can I display them ?

Thank you for your help.

The CiviCRM HTML listing URL may help.

By default this displays all current and upcoming events that are active and have been set to public –

/civicrm/event/ical?reset=1&list=1&html=1

You can add parameters to this URL to filter by dates and event types –

This example will display events that start from 1st Jan 2019 -

/civicrm/event/ical?reset=1&list=1&html=1&start=20190101

This example will display events of type conference (type=1 is the ID of event type Conference)-

/civicrm/event/ical?reset=1&list=1&html=1type=1

This example will display events of type conference AND with a start date >= 1st Jan 2019 –

/civicrm/event/ical?reset=1&list=1&html=1&start=20190101&type=1

You can use the end date parameter to display past events, for example, this link will display all events that were held in 2018 -

/civicrm/event/ical?reset=1&list=1&html=1&start=20180101&end=20181231

Downsides without any development –

The title of all the pages will display as Current and Upcoming events even if you are displaying past events.

You can’t remove/add/reorder the columns.


Civicrm on mariadb with data encryption is there any insights on installing civicrm on mariadb with data encryption turned on? Is it workable? Thanks.

Logging tables until recently wouldn't be supported. If your install is older and you have logging turned on you might need to update the engine for the logging tables to InnoDB.

Otherwise I think it would just be regular system administration stuff not specific to CiviCRM.

But for me the issue with at-rest encryption has always been that storing the keys on the same server defeats the purpose, unless you're willing to password protect them and also not store the password on the server, i.e. manually start mysql any time the server needs rebooting and manually provide the password, and that may not even be doable depending on the hosting setup.

I see there is an eperi gateway plugin for mariadb which I was unaware of. That seems interesting.


What would cause Cannot create user, email: invalid!! on an civicrm integrated webform? When submitting a webform (links below) on our site, an error message is generated: Cannot create user, email: invalid!!

This error message displays for all webforms and for all email addresses, whether it is a valid email address or not.

In only one of the forms listed below should a drupal user be created. The other two forms are only intended to add people to mailing lists.

What should I be looking at to help understand this?

Webform for Mailing list only:

https://www.jewishideas.org/resources-educators

https://www.jewishideas.org/newsletters-0

Webform should be adding a free membership, so a user record is desired:

https://www.jewishideas.org/university-membership

I had the Rules module updated and removed all unused rules(of which we had many), and now the forms are submitting without error


Preferred given name for contact I have used other contact systems in the past and as well as first_name and middle_name there has been a preferred name field. We have several people who have long first names but they go by a shortened name, additionally we have people who are known by a middle name rather than their first name.
What I would like is to display the preferred name as the display name.

You can change the display name for a contact in 2 ways

By using CiviCRM alter display name hook you can change the Display name to a preferred name.

Update the format for Sort name and/or Display name by navigating to Administer >> Customize Data and Screens >> Display Preference (civicrm/admin/setting/preferences/display?reset=1) and then update the 'Individual Sort Name Format ' and 'Individual Display Name Format' fields as per your choice.
(Note: This change will be reflected to contact only if New Individual is added or updated)

HTH
Pradeep


Parent group isn't counting contact in child groups In the WordPress demo site I just create a group called parent_01 and a child group inside this one called child_01.
I create a contact called test1 and added to child_01 gruop, but in the Manage Groups screen the parent group has 0 in the count field
Is this a correct behaviour?

This is a limitation of current implementation, "Parent Group" contact count does not include "Child Group" contact count. So I would call this a missing feature :)


CiviCRM upgrade from 5.12 to 5.29 - failure Tried to upgrade CiviCRM on Drupal 7 website. Drupal core 7.73. Using PHP 7.1. Upgrade process started well but received this message: You must reload the database with the backup and try the upgrade process again. I do have a good backup of database. What should I do? How do you reload the database?

Welcome to SE!  There's lots of useful advice from Luke in his answer but I'd start by looking at the CiviCRM log file.
That error message is a bit misleading.  It's not random luck as to whether an upgrade succeeds so restoring to the previous state and just trying the same upgrade code is very unlikely to produce a better result.  The upgrade probably failed because of a mismatch between what the code was expecting to find in your system, and what it actually found.  Until you track down and correct that problem reloading and repeating won't help.
You can often fix the problem and continue the upgrade without reloading a backup.
If you look at the log file you should see the various upgrade steps logged there.  What was the last successful upgrade step?  What messages do you get after that?
Update
The log file shows:
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
Updated table to row_format=dynamic and then reran the upgrade.


Civivolunteer won't show link unless logged in as admin We are using Civi 4.7.22 on Wordpress 4.8.22.  We recently installed the updated version of civivolunteer 4.7.21-2.2.2

After setting up civivolunteer and adding it to an event, the volunteer link does not show up for anyone who is signing up for the event unless they are logged onto Wordpress as an Administrator role.  Even being logged in as a Subscriber will not show the Volunteer opportunities link, even when I copy and paste the actual link.

Am I missing something or is this a known issue?

Thank you.

Solved,
Be sure to set permissions in Administer > Users and Permissions.
Check all roles you want to access volunteer opportunities at CiviVolunteer: register to volunteer and CiviCRM: access AJAX API


Is there a way to email a link inviting people to sign up for an event that will be connect to their contact ID? I have a list of people who I want to encourage to sign up for an event. I can send a link that allows them to update their contact information, using the contact hash. What I would like to do is send them a similar link that would create a new event registration for their contact ID. This would solve a couple problems:

Avoid duplicate contact entries from being created.
Auto-populate contact fields make the user experience more pleasant.

Am I missing a way to do this, or is there a way to implement it short of a new core feature?

The contact checksum works equally well for a CiviEvent registration as it does for updating their contact info via a profile.  The tokens page of the wiki has a section at the bottom that shows how to format the URL based on your CMS:

Checksum for Event Registration Pages: To send people to an event registration page use this path where N is the ID of your event:

Drupal: http://www.myorganization.org/civicrm/event/register?reset=1&id=N&{contact.checksum}&cid={contact.contact_id}
Joomla!: http://www.myorganization.org/index.php?option=com_civicrm&task=civicrm/event/register&reset=1&id=N&{contact.checksum}&cid={contact.contact_id}
WordPress: http://www.myorganization.org/?page=CiviCRM&q=civicrm/event/register&reset=1&id=N&{contact.checksum}&cid={contact.contact_id}

Alternate approach: Using checksums  is a little complicated for some folks, especially end users!  To make your life simpler, consider installing the Fancy Tokens extension.  This gives you drop-in tokens for your next several events that include the checksum automatically.


Can I use CiviCRM to track web use demographics on a joomla website? My website is www.MyNDTALK.org - it uses a joomla platform.  I need to track who (age, gender, race, education, employment status) is accessing the website, from where, what programs are being accessed.  Can I use CiViCRM for this? I access the website via a mac computer and will be using GoDaddy hosting -

Not really, maybe partially.

If you're looking to collect information from your users via a form, CiviCRM can help with that - but is probably overkill for your purposes.  If you want to know which pages your users are visiting, you're looking for an analytics tracking program, like Piwik or Google Analytics (or something fancier still).  People have occasionally linked CiviCRM with analytics tools, but that's a big-budget project.

Google Analytics will provide you with demographics and interest analysis in aggregate.  I'd start there and see how far that gets you before considering a tool like CiviCRM.


Error after upgrading from v5.22.0 to v5.29.1 in WordPress I have a WordPress website that is using v5.22.0 of CiviCRM, it was a fresh install and this is my first time trying to upgrade it.
To upgrade to v5.29.1 I followed all steps to the letter:
https://docs.civicrm.org/sysadmin/en/latest/upgrade/wordpress/
When I attempt the final step to upgrade the database which is to point your browser to the URL http://example.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/upgrade&reset=1 (obviously replacing example.org with our domain) I get the error message and there is no Upgrade Now button:

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. Your database has already been upgraded to CiviCRM 5.22.0

Am I done? Is there no database upgrade to be done between v5.22.0 and v5.29.1? Everything appears to be working on the front / backend.... did I do it properly?

Just adding an answer - which is actually from the comments - since I think stackexchange doesn't like answers in the comments - anyway - the issue was an extra copy of the codebase


How to use civivolunteer description text On the civivolunteer role options page you can edit the roles and fill out a description field.  That is great but how do I use the description field on event pages where civivolunteer is enabled?  I just get a drop down box listing the label.  And obviously we can add description text to the event page, but that seems wrong.  Where is the role description displayed?

The role description is currently used in two primary places.

On your volunteer opportunities page, you'll notice a small quote bubble next to each role that has a description defined.  Clicking the bubble will bring up a popup listing the description.

The other place the description is used is in the confirmation email sent to the volunteer after signup.


How to use webform to register a new user on Drupal 8/9 and link to contact in CiviCRM I have a need to use Webform (using the Webform CiviCRM module) in Drupal 8 to register a new user and their organisation in Civi and at the same time create the user account in Drupal and link it to the Civi contact. I can't use the standard Drupal register form as I want to include their organisation and other custom fields. How can I do this?

Using Webform and Webform CiviCRM modules create a webform with the fields required for the user and their organisation to create the contact and organisation in CiviCRM.
Then create a WebformHandler to programmatically create the user using the postSave() function. The WebformHandler is a single php file that needs to be saved in a custom module folder as:
my_module/src/Plugin/WebformHandler/CreateUserHandler.php
I have created a basic guideline WebformHandler that creates the user and connects to the CiviContact at https://gist.github.com/bmango/0347f6c22b3fb38e34be57bb50f8e99e
Note that the namespace declaration at the top of the script is not the same as the path to the file but will be:
namespace Drupal\my_module\Plugin\WebformHandler;
omitting the 'src'.
Once you have created the WebformHandler it should appear on the Webform "Email/Handlers" tab where you can then add it to the form.
This answer extends the answer given by mAtZ to Create a new user on Webform submission, by adding the code to connect the Drupal user account to the Civi contact.


Help needed in setting up rest api in CIVI CRM I tried below steps but I am getting an error in calling rest API via the browser.

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

Please have a look at error that I am getting.

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

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

With Regards,

Mohit Thareja

In your pictured error messages, I see sites/all/modules/cv/civicrm which looks a little strange. CiviCRM is typically installed at sites/all/modules/civicrm. I'm not positive this will help, but I would suggest trying the following:

Move the civicrm folder up into the modules folder.
Make sure CiviCRM still works via the regular front-end interface (and troubleshoot, as necessary)
Try your REST call again


how can I embed a civicontribute page in wordpress with gutenberg? I cant see how to embedd a civicontribute page using gutenberg, any thoughts?

Ok eventually worked this out, with help from the civi sysadmin guide here. You can create a shortcode block, and just add your CiviContribute shortcodes in there, [civicrm component="contribution" id="x"], and it will  embed that form in the page. I will see about updating the civicrm documentation to make this more obvious for people like me :)


Upgrade from 4.1.5 to 4.2 (or any new version) fails I'm upgrading a very old CIVICRM version. I manage to get CIVI from 3.2 drupal 6 to 4.1.5 drupal 7.
However when I'm trying to upgrade from 4.1.5 to 4.2 or newer I'm getting several errors. Since this is old version is there anyone that got the same problem? What steps can solve the upgrade procedure?

Best regards
Eduardo

Enable debug and backtrace, it should make civicrm more verbose about why it fails.

It's a long time ago, but the internet has a good memory, if you can see the exact error message, searching for it should point you to someone else having had the same issue, and hopefully that did find a way to fix it ;)


Is there a way to include OpenID as a drop down option in the contribution lis? or Is there a way to convert OpenID to external identifier? When I imported contacts, I listed their identification number as OpenID. Now, I am trying up import the contacts' contributions. Along with their name, amount, date of donation, I am including their OpenID.....yet, the drop down options in the import contributions does not include OpenID...therefore, the import will not function.

a) Is there a way to include OpenID as a drop down option in the contribution list?
if not...
b) Is there a way to convert OpenID to external identifier?

Thank you!

a) Is there a way to include OpenID as a drop down option in the contribution list?

If you created a custom data field called "OpenID", you need to make sure the field can be used for contributions and that it is marked as searchable for it to appear in the list of fields when mapping contributions for import,

BUT

if memory serves me correctly, the system will require either an internal or external contact ID when importing contributions, so...

b) Is there a way to convert OpenID to external identifier?

Since you already imported the contacts, you can export all contacts being sure to include the OpenID and internal contact ID fields, then the update can be done in one of three ways - which ever you find easiest:

Use the import contacts wizard to update all contacts mapping the OpenID to the external contact ID field using the internal ID as the link, OR
Use a vlookup in csv to match the internal contact ID to the OpenID in your contribution data import file, and then import your contributions based on the internal contact ID, OR
Use an SQL statement that will copy the OpenID to the external contact ID field by contact ID directly in the database

Hope this helps,
Tamar


Where should I put static files in my extension that are just used in certain few pages? I need to use few static files(images, css) in one of my template. Currently I am using a CDN link to the same, but in practice storing the same within the extension will ensure the availability even if the links stop working.

Where should I put such files in my extension, should putting them in the template folder itself is the right practice?

Typically your extension directory would contain subdirectories named css and js and resources of those types would go in there.

To load them on-demand, use CRM_Core_Resources.


Cannot access civicrm/report/list As an administrator i go to

 Contributions > Contribution reports

but I am getting an error: access not allowed

In the Drupal log:

cannot access civicrm/report/list

In the CiviCRM log:

Jan 06 17:00:24  [info] $Fatal Error Details = Array
(
    [message] =>  is not of type String
    [code] =>
)

Jan 06 17:00:24  [info] $backTrace = #0 <path_to_civicrm>/CRM/Core/Error.php(331): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 <path_to_civicrm>/CRM/Core/DAO.php(1399): CRM_Core_Error::fatal(" is not of type String")
#2 <path_to_civicrm>/CRM/Core/DAO.php(1284): CRM_Core_DAO::composeQuery("\nSELECT v.id, v.label, v.value, v.name, v.weight, v.description\nFROM   civi...", (Array:2), TRUE)
#3 <path_to_civicrm>/CRM/Core/OptionGroup.php(602): CRM_Core_DAO::executeQuery("\nSELECT v.id, v.label, v.value, v.name, v.weight, v.description\nFROM   civi...", (Array:2))
#4 <path_to_civicrm>/CRM/Report/Utils/Report.php(423): CRM_Core_OptionGroup::getRowValues("report_template", NULL, "value")
#5 <path_to_civicrm>/api/v3/Job.php(224): CRM_Report_Utils_Report::processReport((Array:3))
#6 <path_to_civicrm>/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_job_mail_report((Array:3))
#7 <path_to_civicrm>/Civi/API/Kernel.php(161): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9))
#8 <path_to_civicrm>/Civi/API/Kernel.php(92): Civi\API\Kernel->runRequest((Array:7))
#9 <path_to_civicrm>/api/api.php(23): Civi\API\Kernel->runSafe("job", "mail_report", (Array:3), NULL)
#10 <path_to_civicrm>/CRM/Core/JobManager.php(134): civicrm_api("job", "mail_report", (Array:3))
#11 <path_to_civicrm>/CRM/Core/JobManager.php(79): CRM_Core_JobManager->executeJob(Object(CRM_Core_ScheduledJob))
#12 <path_to_civicrm>/CRM/Utils/System.php(1691): CRM_Core_JobManager->execute(FALSE)
#13 [internal function](): CRM_Utils_System::executeScheduledJobs()
#14 <path_to_civicrm>/CRM/Core/Invoke.php(276): call_user_func((Array:2))
#15 <path_to_civicrm>/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:12))
#16 <path_to_civicrm>/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#17 <path_to_civicrm>/drupal/civicrm.module(448): CRM_Core_Invoke::invoke((Array:3))
#18 [internal function](): civicrm_invoke("admin", "runjobs")
#19 /home/<account_name>/public_html/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:2))
#20 /home/<account_name>/public_html/index.php(21): menu_execute_active_handler()
#21 {main}

As an administrator i should have full access, but i do not see the place where i can check (or change) this "full access", nor allowing myself to access report/list.

Thanks for all information and help!

Go to /admin/people/permissions and look for the CiviReport permissions.


"CiviCase: access all cases and activities" Issues I realize that this has been spoken about and that there was a solution on posted (and it did work for me on 5.4 - Now on Civi 5.6.1 any user that does not have "CiviCase: access all cases and activities" checked i get a "ERR_TOO_MANY_REDIRECTS" error when trying to access the Civicase Dashboard or Manage Cases.

I checked if the fixes were applied from the pull - And Yes they are, but I cannot have users seeing other peoples Cases -
It works for the Administrator - I can access all the Cases and don't get the redirect error.

Can you try this patch https://github.com/civicrm/org.civicrm.civicase/pull/123

Hope that helps!


Converted Drupal to WordPress: Network Error when trying to save changes The site is working except that any attempt to change content (i.e., update a contact) results in

Network Error
Unable to reach the server. Please refresh this page in your browser and try again.

I've verified that the database id/password is correct and has all privs.

I don't see anyplace where the old URLs might be.

Is there a way to debug this?

I've been through over a dozen similar question/answers without finding a solution.

Dammit!  The views code in the database saves the userid for the query, which changed when I moved things. There's a WordPress plugin that can fix it, though I exported the database and did a search/replace to change the old user to the correct one.