What does the 'Validate Email Address from Mailings' scheduled job do? Under Settings > Scheduled Jobs there is a job called 'Validate Email Address from Mailings'.  I'm not clear what this does exactly.

The documentation says:

  Updates the reset_date on an email address to indicate that there was a valid delivery to this email address.

I'm not clear what this means and what affect it has on the email address.

Could somebody explain how this works?

Also could you explain what the parameters do:

  minDays, maxDays=Consider mailings that have completed between minDays and maxDays

I'm using CiviCRM 4.6.8.

Many thanks for your help.

The scheduled job examines previously sent emails (in the range of dates if given) for any confirmation that the email was rec'd, typically opens or clicks, and if found the reset_date is updated.

only qualified and verified information is to be included on an actively working database. added entries change over time and info needs to be updated continually if proper verification methods are maintained. entries should be re-verified at a minimum of X amounts of days (so as not to bombard the recipient) and at a maximum of Y days so fresh new data is continually maintained.  validation can be a reply or an auto-reply showing evidence of a valid email address.


in CiviMail, when using "view in browser" link, how can forward to a friend be disabled? When a person clicks on the view in browser link in an email, the email is generated on a webpage. This webpage also includes any tokens like Forward to a friend, which on this webpage does not work. How can the html for the web-page version of the email be edited to get rid of such token (or the unsubscribe token?)

Try wrapping those items in <span class="hiddenElement"> </span>. Civi's css will hide it on your website, but email clients will not.

Thank you for the suggestion, Coleman, but we can't get the "hiddenElement" class to affect the display. We are particularly keen to hide the 'Unsubscribe' link at the bottom of our emails when 'viewed in browser'.

Are there any plans to allow the 'View in Browser' page link within the mailing to be include a Contact ID (and a key token to prevent forgery?) so that 'Unsubscribe' can work as expected, even when the mailing is being 'viewed in browser'?


Civicrm search results page URL How can I save the Civicrm search results page URL to link to it directly later from any account. At present the link we get is based on the qkey that does not work once we logout and login later.

We want a URL that takes us directly to search result page & we should be able to pass filters also in the URL like date range etc.

I don't think it helps with passing the filters in the URL, but you can save the search as a Smart Group and then use the link to the contact list for that group. I think you can strip of the qfkey portion of the URL in this case. Something like this (although this smart group on the demo site will be deleted shortly, the URL structure is what I want to show):

http://d46.demo.civicrm.org/civicrm/contact/search/advanced?force=1&reset=1&ssID=1&context=advanced

I have the same problem (and no answer) in a different (?) context : I want to follow event participants to regularize those who pay by check.

To do this I make a search based on event and participant role, then I go to partcicpant "modify" to register their payment and update their status.

My organisation can have a lot of different events, each with different managers : I want to pre-customize the search for each event, to ease the manager work and avoid errors.

I don't really know Views, but I don't think it could help, because I need the ability to "modify" each individual participant.


WYSIWYG Custom field Post Help text Is there a way to have custom field Post Help text HTML formatted? Not even new lines are recognised and it makes the help text very difficult to read.

I'm afraid the answer is "no you can't configure that to allow HTML tags". If you need lots of Help text put most of that into the 'Body' on the Event Info and/or Event Register and/or Contribution pages - keeping the help text nice and short.

If you're talking about a field on a public-facing profile, you can add a profile "field" of type "Formatting", which can be HTML-formatted.  See screenshot.

If you ARE committed to hacking this, I'd do so by inserting a jQuery script into an .extra.tpl file.


How to connect to Attentive.ly (Social Media Service)? I have a Wordpress CiviCRM site and want to try using the Attentive.ly Social Media Service.  There is an Extension to connect to this service.  I have installed the Civi Extension and all seems good.  I created an account on the Attentive.ly site.  I am in the process of connecting Civi to the Attentive.ly account and it asks for 3 items of information:

1) URL you use for your CiviCRM access - I have no problem
2) Site Key you use for your CiviCRM access - I have no problem
3) API Key you use for your CiviCRM access - I do not know how to find this?

How do I find or create the API Key?

If anyone has experience with Attentive.ly and can give some feedback that would be great.

CiviCRM has multiple layers of security, all of which need to be handled properly to update its data remotely. You need to create a user which will be provided the permissions needed to update data in CiviCRM from Attentive.ly. This is part of the CiviCRM permissions model for using an external programmatic interface to interact with CiviCRM (see https://wiki.civicrm.org/confluence/display/CRMDOC/API+Security#APISecurity-PermissionswithinAPI for more details - that page is dated but I think generally accurate still). This approach to permissioning allows different external services to interact with different permissions, leverages the existing user/contact based permissioning system, and allows tracking of changes made by services to follow the paradigm set up for tracking which user makes changes to a contact.

@Andrei's suggestions are good ones. The official documentation for creating API user keys is at https://wiki.civicrm.org/confluence/display/CRMDOC/REST+interface#RESTinterface-CreatingAPIkeysforusers . I've added updated instructions that do not require interacting directly with the database at How do I set up an API key for a user?

Ron, the API key you need is from Attentive.ly.

See https://github.com/JMAConsulting/biz.jmaconsulting.attentively - "Once you have been redirected to the Attentive.ly Sign Up page, either create a new account or login to your existing Attentive.ly account."

You can request an Attentive.ly demo here - https://attentive.ly/product/


Force membership sign-ups to register as user As the title already says, I am trying to create a WordPress user for each person paying a membership fee.

Therefore I already checked the Anyone can register box in the WordPress settings.

What it should look like:

a person navigates to my site where the signup form (contribution page) is displayed (this works so far)
when he signs up he has to register as a user (so insert a password and username) - this part doesnt work so far there is only the email field and the billing fields.

Can somebody help me to achieve that?

When you create a Profile, in the Advanced Settings (at least for Drupal) there is an option to 'require user account creation'. So if you have this selected in the Profile, and then set that Profile to show on your Membership page then I would expect anyone completing the form to create a user account.

you probably need to build a CiviCRM extension / WordPress plugin for this.

In the buildForm hook add a new field for username and password.
In the post hook take these details and create a user.

Reply here if you need further help,


After creating my extension, what is the root for my new tab? 1- I create a plugin with my hook :

function wordpress_civicrm_tabs( &$tabs, $contactID ) {
    // unset the contribition tab, i.e. remove it from the page
    //unset( $tabs[1] );

// let's add a new "contribution" tab with a different name and put it last
// this is just a demo, in the real world, you would create a url which would
// return an html snippet etc.

$url = CRM_Utils_System::url('civicrm/order',"reset=1&snippet=json&force=1&cid=$contactID" );
$tabs[] = array( 'id'    => 'orderTab',
                 'url'   => $url,
                 'title' => 'Orders',
                 'weight' => 1 );

}

With this function I added a new tab.

2- I enter in Administer/System Settings/Directory the location of my extension ..wp-content\plugins\ccbc_order_tab\ccbc.order\

3- I use civix to create my extension ccbc.order and in my folder I create a page:order

4.- My order.xml created in xml/Menu/order.xml it shows:

    civicrm/order
    CRM_Order_Page_Order
    Order
    access CiviCRM

5- at the moment my page redirects to CRM/Contact/Dashboard.tpl.

Please can you help, what settings I missed?

Thank You

Nilda

It appears you are confused about the difference between a CiviCRM Extension and a WordPress Plugin.

I would recommend you to write a native CiviCRM extension and enable it from the civicrm/administer page (you might need to set up the extension directory path first).

If you generate an extension with civix, it will take care of reading the xml to handle the url of the page you created and all the stuff you'd need to support your custom tab

Have you done a clearcache (/civicrm/clearcache)?


Error while installing CiviVolunteer on civicrm 4.6.5 When trying to install CiviVolunteer with CiviCRM 4.6.5

Wordpress 4.2.3 and CiviVolunteer4.5-1.4.0

I get the error:

"'Multi-select' is not a valid option for field html_type"

Based on this screenshot, two possibilities occur to me, neither of which I like very much:

Something is different about 4.6.5, and it no longer accepts 'Multi-select' as an HTML type. In the code for the extension, this appears on line 433 of CRM/Volunteer/Upgrader.php. In some other usages of this HTML type, I see it referred to as 'Multi-Select' (note the different capitalization) -- it could be that capitalizing the S solves the problem for you. If so, please let me know, and we'll make sure that goes into the next release.
I see you're not running CiviCRM in English. Is your site running in French only, or is it a multilingual site? I'm not sure yet why this would matter, but I've seen strange things occur with the schema changes, etc. that come with a multilingual site -- there are some circumstances CiviVolunteer doesn't account for. It seems like a long shot that the problem is related, but I thought I'd ask anyway.

The failure occurs during a step of the installation that creates custom fields for the volunteer contact subtype. Since the API call that performs this task has worked with previous versions of CiviCRM, I suspect something has changed with the parameter validation, either in the API itself or further down the stack. Either this change was intentional and CiviVolunteer should be updated, or it was unintentional and we should consider filing a regression bug.

Note: I haven't yet tried to reproduce this on a test copy. I'd say this is a necessary step before speculating much further.

I did the same installation on civicrm version 4.6.5 with drupal it went alright without any error - so, Please try to install the same again or please install civicrm again


Does CiviRules extension work on 4.6.x Title says it all really. Just trying to verify if there are known breakages, or if we just need to update the Extension info page

We're using it on 4.6.x sites too and are in the process of adding extra things such as the ability to allocate campaigns. If theres anything in particular you'd like to do but cant maybe drop into a wiki or on the issues list in github.

Doesn't seem to work with any of the event triggers (create,change,delete) across versions 4.6.x and 4.7.x

This error message comes up.

Sorry but we are not able to provide this at the moment. One of parameters (value: ) is not of the type Integer

Have you had any issues with the event triggers petednz?


Contact created from relationship tab is automatically tagged When I create a new user from another contact's profile, in the relationship tab, the new contact automatically gets one of my tags...
I have no idea where to look to solve this one.
Any clues?

Using civicrm 4.6.25

If you haven't found the cause by looking around, you can write an extension that uses hook_civicrm_pre on the Tag entity to call CRM_Core_Error::backtrace().  That should show you what's calling the tag creation code.

Go the Contact (the one you want to edit) > Tags. The Tag tab is toward the right side of the Contact categories.


Contact SubType check fail in Smarty TPL file Have  strange issue checking contact type in \templates\CRM\Contact\Form\Contact.tpl

This code prints  Organization / Society

{$contactType} / {$contactSubType}

This code prints Organization / Society

{if $contactType eq 'Organization'}
   {$contactType} / {$contactSubType}
{/if}

But this one prints nothing

{if $contactSubType eq 'Society'}
       {$contactType} / {$contactSubType}
{/if}

And this one prints nothing

{if $contactType eq 'Organization' && $contactSubType eq 'Society'}
       {$contactType} / {$contactSubType}
{/if}

Shouldn't it "just" work? Or it's another bit of CiciCRM magic?

(adding as an answer - see comment thread above)

In the DB, contact_sub_type uses a special character to split multiple contact types. If this is being carried through to smarty then 'eq' might not produce a match (but the non-HTML character wouldn't be printed to screen). Can smarty check whether the $contactSubType just contains 'Society'?

If you want to hide Contact Details, the best way is explained in this post:
How do I edit activity forms?

In my opinion the best way is to create a little extension and add a template with some jQuery code to hide the Contact Details. But you could give the css way a go too?


White screen in 4.7.12 I note with the 4.7.12 version of the difficulties of implementation, particularly with queries that only lead to blank pages.
Track errors in apache located abnormalities in smarty.
I returned to version 4.6.22 LTS that does not pose this problem.

Installation on a dedicated server ubuntu 14.04, apche 2.2 mysql 5.5.52 php5 wordpress 4.6

cordially

You don't mention your php5 version, that would be the most likely cause (i.e if it's less than 5.4).

But if the problem is seen in an apache error file and it's in the smarty file, then just give us the error and it should be clearer.

If you only updated the code files and didn't clear caches afterwards and run db updates, then you'll definitely want to do that, as per the documentation.

It sounds like this may be due to your PHP version.  CiviCRM doesn't fully support PHP 7 yet.

See: CiviCRM PHP Requirements


Why can't I upload images to mailings? I'm using civiCRM 4.6 Wordpress 4.1.5 hosted on Bluehost.

Can you upload images to mailings via image properties>upload>send to server?

This seems to navigate to page that doesn't exist and the image does not get uploaded.

If you go to image properties > browse server it just navigates to this page: http://lmysite/wp-content/plugins/civicrm/civicrm/packages/kcfinder/browse.php?cms=civicrm&type=images&CKEditor=crmUiId_1&CKEditorFuncNum=3&langCode=en and says page not found (with my header and footer).

I think my directories are correct.
image upload url: http://mysite/wp-content/plugins/files/civicrm/persist/contribute/

resource URL: http://mysite/wp-content/plugins/civicrm/civicrm/

And my civicrm.settings:
$civicrm_root = '/serverpath/public_html/wp-content/plugins/civicrm/civicrm/';
if (!defined('CIVICRM_TEMPLATE_COMPILEDIR')) {
define( 'CIVICRM_TEMPLATE_COMPILEDIR', '/serverpath/public_html/wp-content/plugins/files/civicrm/templates_c/' );
}

I don't know if this is also related to another unresolved problem I have to do with mailings: Why do 'track click through' links not redirect to correct address?

This seems to be related but is for Joomla: https://civicrm.org/blogs/kurund/enable-image-uploads-and-server-browsing-for-ckeditor

This is a similar problem but the conclusion is unclear: http://forum.civicrm.org/index.php?topic=30066.0

This may have been a bug in 4.6.0. Can you try upgrading to the latest version and see if that fixes it?

I am having the exact same problem.  I upgraded 9 civi sites today and this is the only one that is causing me problems.  Checked resources directorys, civi settings file and everything appears to be correct.  This was not an issue prior to the upgrade on 4.6.8.  Scratching my head.


Multiple Contacts and Memberships Later Merged to One Membership I have a problem that I'm not entirely certain how to work around. I have two contacts, who have been two separate members for a long period of time. But recently they married and are now sharing one membership (example: Two at same address). How would I record them sharing a single active membership while keeping their past data (as singles we'll say) available for them to review?

Thanks!

Matthew

There is an option to merge contacts and seems to be what you are looking for. Search for them in Find Contacts and then select to merge the two.


Cannot read unrecognized property CRM_Core_Config::$mapGeoCoding Has anyone encountered this error on a CiviCRM Event:

Sorry but we are not able to provide this at the moment. Cannot read unrecognized property CRM_Core_Config::$mapGeoCoding

I'm using civi version 4.7.13. I changed the Mapping and Geocoding Providers Settings. Google is the Geocoding Provider and I added a Geo Provider Key. When I save the settings the error disappears but the map does not display on the page and eventually the error returns

Removing $config->mapGeoCoding from the core EventInfo.tpl and then clearing the directories out of the */templates_c/En_us directory fixed the error message. I am now able to get the map to work correctly if I enter the longitude/latitude but I think there is an issue with the key.


How to add Thai language to CiviCRM in WordPress? I'm using WordPress v4.9.5 and install CiviCRM v4.7.31
I want to activate 'Thai' language to CiviCRM, but there is no option to include this one into system.
I try to check at Administrator > Localization > Language, Currency, Locations
There is only one available which is "English (United States)"

I also try to contribute to translate project at https://www.transifex.com/civicrm/civicrm/translate/#th_TH but there is no progress yet, it's about 5%

I download l10n from https://download.civicrm.org/civicrm-4.7.31-l10n.tar.gz but don't know how to install these folders to CiviCRM (there are multiple folders of l10n, and sql folder which does not have Thai files)

Could anyone help me?

Since it's below 20% they aren't included in the download. You can use the instructions in the Administrator Guide wiki to get the files into CiviCRM. There is also more information at https://lab.civicrm.org/dev/translation/wikis/home

Would it be possible if I use some script of Google Translate or another plugins to WordPress for making translation directly on CiviCRM?

I try to use this one >> Translate WordPress with GTranslate https://wordpress.org/plugins/gtranslate/ but it works on frontend pages, but it does not work on backend system.


Does civiCRM support RequiredIf validation for Profile fields I have dropdown with option1, option2 ... Other. I want if user selects "Other" another text field appears (slideDown) underneath the dropdown AND this text field is Required. Is it possible with civiCRM?

This was proposed as a feature for CiviCRM, but it never really got any funding: 'Other' option for custom fields

As Ben says, if you are (or have access to) a developer, it's not too hard to write this extension.  Add both the dropdown and the "Other" field to your profile, then use jQuery to hide the "Other" field.  Toggle whether it's hidden based on the value of the dropdown.

Use hook_civicrm_validateForm to set "Other" as required if the dropdown value matches the "Other" option.  By default it should not be required.

Are you using Drupal? If so I think webform will support this.


Administration Console After Civi 4.6.10 upgrade I can no longer access the Administer/Administration Console without getting an error.  Here is a sample:

  @import url(/devjom3update/administrator/components/com_civicrm/civicrm/css/civicrm.css); @import url(/devjom3update/administrator/components/com_civicrm/civicrm/bower_components/jquery-ui/themes/smoothness/jquery-ui.min.css);    Sorry but we are not able to provide this at the moment. You do not have permission to access this page. Return to home page.    function toggle( element ) { var className = element.className; if ( className == 'crm-accordion-wrapper collapsed crm-fatal-error-details-block') { element.className = 'crm-accordion-wrapper crm-fatal-error-details-block'; } else { element.className = 'crm-accordion-wrapper collapsed crm-fatal-error-details-block'; } }

Check the URL before you select the Administration Console link.  Does it have a www or no www?  Is it http:// or https://?  Next, check the URL of the error page for the same things.  Is there a difference?  If so, that's your problem.  Check here for a solution.

In civicrm common folder is missing. Check common folder is there or not


Spanish custom last name solution I'm new here, but I'm sure not the only one who speaks Spanish. I would like to know what solutions you have used for the problem of the 2 surnames that are used in Spanish.

Which is the best solution for integrating both surnames into Civicrm?

PD. There should be an standard integrated solution to Civicrm, since Spanish is the most spoken language in the world after Chinese. ;)

"Lastname" is the field intended to insert both surnames for the contacts they have. The translation of the field in Spanish also indicates it: "Apellidos".

For more than 5 years we have worked with CiviCRM and to date we still have not encountered any inconvenience in saving both surnames in a single field.

We use them separtly, and as such they should be available as are the surname and all other data fields. Civicrm  is not fully internationalized until it respects other customs and cultures that are not from the english speaking world. This is just plain bad coding and should be fixed.


Contribution Page-Amount page options now showing 0
down vote
favorite

Greeting, When I add new Contribution Page then chick on "Amount" option in CiviCRM, In the "Amount" options page all checkboxes and radio buttons except PayPal Standard checkbox will disappear also Minimum Amount and Maximum Amount text boxes not showing .

I open the page in 4 different web browser and I cleared the cash and flash my Drupal website and still these options now showing. I am using Drupal 7.41 and CiviCRM 4.6.10.

Please advice how to fix this problem.

Regards,

Check it after deleting the civicrm temporary files (../files/civicrm/templates_c). If this will not fix your issue, then check your civicrm log file (../files/civicrm/ConfigAndLog). Here your will get more details about the error.


Multiple contact (sub)types for an individual I am new to CiviCRM and I am wondering what would be best practice regarding the use of contact (sub)types in our organization.

The situation is following:
Type of business: coaching and training.

We provide coaching to clients(contacts) so we assign one or more Coaches to a client at the start of a coaching period. This coach(or coaches) could be an in-house coach or he/she could be external. However, coaches could also be qualified trainers in certain areas of expertise. Trainers can offer workshops/courses/trainings to clients but also to coaches and other trainers.

Is it good practice to assign multiple contact sub-types to individuals who are qualified as a coach and trainer and possibly as supervisor as well?
Or would a different approach be a better solution?

Many thanks!

As long as I know it's a good practice to use multiple subtypes in the same contact.

Doing that you can, for example, create different custom fields for each subtype. So your coaches who are also trainers will have the fields for being coaches and in addition the fields for being trainers.

And if in the future, one of your coaches became a traier, you can add him the subtype and automatically will appear the custom fields for it.

So I will recommend it. :)

UPDATE: What I wrote below is incorrect - I was not up to date (see comments)

Subtypes can be a great way to structure your data. There are however some limitations that you should know about:

Each contact (person or organisation) can only be one subtype
Subtypes cannot be changed later on

This means that if for example a coach is likely to become a supervisor or trainer at some point I would recommend using custom fields/field sets and groups, tags etc. to structure your information and NOT subtypes.

If you use subtypes you would need to create one contact for each subtype which is most likely not what you want.


Moving from Drupal to Wordpress I am moving my organization's website over from Drupal 7 to Wordpress, and along with that I need to connect our existing CiviCRM install with the new Wordpress install. I just have a few concerns before I start anything:

Can I just install CiviCRM for WP and hook it up to the existing database? Is there a special procedure that I will need to go through to connect our existing database with WP? Is there any risk to the data moving over this way?

Thanks!

Migrating from Drupal/Civi to Wordpress/Civi is relatively painless.  You'll need to truncate your civicrm_uf_match database table, which links Civi records to CMS users, and repopulate it - Administer menu > Users and Settings > Sync Users to Contacts works well if you want ALL your Wordpress users to be linked up.

That said, there are numerous gotchas to watch out for - I've started compiling a list here.
UPDATE: I've merged this with documentation on wiki.civicrm.org.  Please check Moving from Drupal to Wordpress.

Since StackExchange prefers direct text to links, here's what I've got so far:

PayPal IPNs needed changing. You can only change future IPNs in Paypal; you may also need to set up a 307 redirect from the old URL.
URLs linking to contribution pages etc. in mailing templates, scheduled reminders etc. need to be changed.
Images in mailing templates and scheduled reminders must get a new absolute URL (or a redirect).

I would say that generally people almost always switch to Drupal, not away to WordPress. It would be hard to imagine a reason to go the other way... Drupal offers more features and flexibility and more useful integration into CiviCRM. Make sure this is really what you want to do for the long haul before putting in all the effort to switch.


Setting up CiviCRM with Multisite Wordpress Thanks in advance for any help or insights, I have an existing WordPress multisite install and we would like to have CiviCRM installed on all three sites but sharing the same database. I have followed the civimultisite documentation and the checklist posted here, but as soon as I hit the [install] on the 2nd site, I get this error: "Found installation Canary” while installing CiviCRM". I have edited the civi settings php file adding the domains of the other 2 site per the documentation but no joy yet, any help will be deeply appreciated!

i do this with a WPMU and civiCRM and it work fine. I m french, i dont speak english but i do a tutorial in french, i can give you this doc, my mail is pikerez@laposte.net. Goodbye


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

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

I'm using CiviCRM 4.6.10 on Drupal 7.41.

Is there an error in the log file in sites/default/files/civicrm/ConfigAndLog/ ?


Spouse relationship in a Drupal view I currently have a Drupal View Displaying the current user and his/her spouse (AKA Drupal User and CiviCRM Contact B)
For some reason it will only Display the Drupal User and spouse if the spousal relationship was created from the Drupal User's CiviCRM contact profile.
If the spousal relationship was created from Contact B's CiviCRM profile, then nothing is displayed.
Is there a way to get this working regardless where the relationship was added?

You need to add the relationship from the contact ID B?

Are the relationships permissioned? Your users probably can only see their spouses if it's a permissioned relationship, and perhaps when the relationship is bring created the second way it isn't being created in such a way that it is permissioned.


Has integration been done for Textify Mobile? Has anyone seen this new SMS service called Textify Mobile that's geared directly to non-profits and churches. It even has mobile giving with it. Wondering if anyone had done an integration/extension for it?

My name is Mitch Cannon, and I'm the VP of Technology for Textify Mobile. We currently only offer a private API for specific integrations and partnerships. With that said, we are actively developing a RESTful, JSON-based API for our general user base. I would love to talk with anyone interested in an integration about their needs and what we can currently accommodate.

http://www.textifymobile.com/contact-us

There is not an extension for Twilio currently, so that won't work.  Only Clickatell.


How can I change a cell in dataTables (custom data type tab with table) to disable the inline edit? I need to make a change where some of the contact identifiers (extension Identity Tracker) can not be changed by the user. I can do that with the validateForm hook. But the Contact Identities are actually custom data of the type "tab with table" and you can also edit them inline.
The custom data tab with table uses the jQuery dataTables, and do not respect any hook unfortunately. In the  is a  with the class "crm-editable-enabled". If I can change that class to "crm-editable-disabled" I would be fine, but I have no idea how to do that with the dataTables API and the documentation shows stuff like this:
CRM.$(function($) {
  var myTable = $('.dataTable').DataTable();
  myTable
          .columns('.crm-editable')
          .nodes()
          .flatten()  // Reduce to a 1D array
          .to$()      // Convert to a jQuery object
          .removeClass('crm-editable-enabled')
          .addClass('crm-editable-disabled');
});

I can get the var myTable, but the rest does not seem to have any effect....any ideas?

how about using apiwrapper hook and throwing exception?


Can I manually add an "Email" activity in the GUI without sending it? To keep track of communications with contacts, CiviCRM has Activities e.g. documenting e-mail conversations. In the Activities tab of a contact I can create these from the New activity dropdown.

This provides the option Send an Email. However, using that I can only make CiviCRM actually send out an email to the contact. We usually send emails from a normal mail client instead.

What I am looking for is a possibility to add an Email activity to a contact without actually sending out a mail. (To document an email that has already been sent from outside CiviCRM)

Currently we use a workaround: A custom activity type documented Email. But it would avoid confusion, if all mail would be of the same activity type Email regardless of how it was send out.

Is there a way for this in Civi or an extension?

Have you checked the inbound email processor script. You can forward and/or cc a mailbox, and civi can read from the mailbox and attach it to the relevant contacts.

Details are here:

http://wiki.civicrm.org/confluence/display/CRMDOC/Autofiling+email+activities+via+EmailProcessor

You can change the System Setting (menu Administer/System Setting/Outbound Email) to 'redirect to database' you can create an Email activity but it will not be sent.


Message: "Fatal DB error, exiting, seems like your schema does not have civicrm_setting table" Running WordPress 4.4.2 and CiviCRM 4.6.11

Haven't done an upgrade recently and have been using CiviCRM all day with no problems to suddenly encounter:

  Fatal DB error, exiting, seems like your schema does not have civicrm_setting table

We did migrate servers yesterday and disabled Cloudflare but it just suddenly stopped!

Where to start looking?

I would start looking at corrupt tables.

If you have access to phpMyAdmin, you can select all tables at the bottom and then choose "repair tables".

If you do not have phpMyAdmin, but you have access to ssh then you can use mysqlrepair (or mysqlcheck -r), see more at http://linuxcommand.org/man_pages/mysqlcheck1.html

If you have neither you should ask your hoster to do a repair for all tables.


Is it possible to have many to many relationships between custom field sets? i tried to look for an answer but im pretty confused with what i found..
I'm trying to create a many to many relationship like in SQL..

for example:
lets say i want to create a custom 'Event'(a field set),
so i make some fields(name,date,location etc..) BUT now i want to make a custom 'Team'(field set) which has an 'events' field that contains the id's/names of this team events.

thanks in advance!

EDIT
okay let me try with a diffrent example: im making a managment system for a soccer team. so lets say i make a 'Court'(field set) with fields like name,address etc.. and now i want to make a 'Team'(fieldset) which contains all the diffrent Court's this 'Team' has.. is it possible to link many 'Court' records to a specific team? and each 'Court' has its related 'Team's ? i hope i made it more clear..

I think, if I'm reading your question correctly, that what you want to do does not require anything custom. I would do it this way:

Create an event in CiviEvent. This will have the fields name, date, location, etc already available for you to fill.
Make this event a certain "type." The built-in options are things such as workshop, meeting, and class, but you can add a type called "team."
All the events of type "team" are easily searchable and viewable.

Is this what you were going for? If not, please describe in more detail what it is you are trying to do.

I'm guessing that "Field-Set" is the CiviCRM terminology for table?

You need to create 3 Field-Sets.

The first field-set for Court, it will have an id and the fields that describe the Court.
The second field-set for Team, it will have an id and the fields that describe the Team.
The third field-set for the connection between them, it will have an id as all field sets have and you will add fields for the court-id and the team-id.

If you want to show in the Team screen a list of the Courts belonging to the Team, use a small table view in that screen showing the result of the query where you join the tables using the 3rd table and similarly for the other view for the Court screen.


Notify when profile form is submitted does not work (form with attached files) I have created an application form in CiviCampaign through Petitions.

Everything has been set up fine, except that even after adding one or several emails in Administer > Customize Data and Screens > Profiles and click "Settings" on the profile created for this form in the Advanced Settings section "Notify when profile form is submitted" nothing ever happens when a form is submitted.

This is particularly important because we are requesting that two files are attached before submitting and we can't get access to them through civicrm backoffice. I was expecting they would be sent in the notification email.

We are using CiviCRM in Joomla, so this was the only solution I found to create an application form, without using CiviContribute, which does not apply to what we need. When we use CiviContribute the email notification works fine.

Help would be greatly appreciated.

A partial answer. If you want an 'application form' then a standalone Profile should suffice. There is no reason i know of why you would need to add complexity of CiviCampaign and Petitions.


Is 4.7.x end-of-life? Why does my site say that 4.7 has reached the end-of-life? The CiviCRM Status Screen is reporting for any version that is 4.7.x that it is End of Life.

What does this mean?   Is there something wrong with version 4.7?  Do I need to panic?

There is a helpful explanation.  The numbering system changed, this is detailed here

5.0.0 is the next version after 4.7.31 and is not a major update.

In The Q&A section there is an answer to this question which explains why the limitations of the update messaging system in 4.7 led to the decision to use the End of Life message in this instance:

  The in-app messaging in 4.7.x was hard-coded several years ago. For a site running the last 4.7.31, we can only display one of two messages -- either that 4.7.31 is up-to-date or that it 4.7 is end-of-life. Neither message is accurate or desireable -- the truth is that 4.7.x was renamed to 5.x.

  We've updated the notification system so that future messages can be
  more nuanced/accurate, but for sites currently 4.7 we've had to take
  an awkward approach. For April and May, we used the understated
  message; but in June, we switched to the overstated message.

There is no need to panic. That 4.7 is end of life means that no updates are released. It is usually good to have an update strategy (update with each release, update once a year, never update).


Get state/provice id with API3 I wrote an custom contact import script for our NGO. The old contact data only contains valid country / state abbreviation names. For example CH / ZH = Switzerland / Zürich.

When I now want to create a new address over the API I don't see a way to fill out the 'state_province_id' field.

I'm able to get the country id with this syntax:

$result = civicrm_api3('Country', 'getsingle', array(
        'sequential' => 1,
        'return' => "id",
        'iso_code' => $row["V"],
    ));

if(isset($result["id"])){
   $params["api.address.create"][0]["country_id"] = $result["id"];
}

But how can I do the same with the State/Province, since there is no  entity I can choose in the API?

If there is no state/Province API you would have to create one? Assuming you put your import script into an extension, this is not very hard to do. Using civix you can do generate:api StateProvince Get and the codes files (which you then have to adjust) will be generated for you. If you want to know more check out http://wiki.civicrm.org/confluence/display/CRMDOC/Create+a+Module+Extension#CreateaModuleExtension-AddanAPIfunction


CiviEvent - capturing billing information, interaction (or not) with contacts I may be missing something obvious, but what is the best way to capture billing information for an event registration, including for a registration of multiple people?

What I mean is, in addition to providing a credit card option, we allow optionally providing billing name, address, fax, and email.

Currently we are using a profile for the additional billing information (billing name, address, fax, and email), which gets attached to registrant #1. This caused a problem at first - an email address supplied for billing would overwrite the email address on registrant #1. "Solved" by replacing the email field in the billing profile with a new text field that is just for the profile (but unfortunately is not an email field, so is not validated for email).

Is there a better way, to collect this information and have it attached to the event registration itself, not to one of the contacts?

When you say registration, do you mean "of membership"?

If it's just registration of being part of your organisation, perhaps attach it to an activity of type "Registration" on the contact.

However, your message concerned me. In general CiviCRM isn't used for credit card information - there are a lot of laws surrounding how that information is stored. Tangentially, you should also read: https://en.wikipedia.org/wiki/Payment_Card_Industry_Data_Security_Standard

In general we would advocate using a dedicated payment processor extension and only storing transaction Ids in Civi.

I would suggest making the Contact 1 an organization profile and then the billing info attached to that profile with a contact name. Then additional profiles could be individuals that would collect whatever info for them.


How do I process a refund for a credit card payment via iATS? I have a member who accidentally bought two memberships and there is no clear way to just refund one of the amounts. Seems like a relatively simple task that should be more intuitive.

You will need to initiate refund at iATS gateway and then change the contribution status to refunded in CiviCRM.

HTH

Pradeep

@Dylan - Just edit the contribution which you wanted to refund and set the contribution status to Refunded, then update the contribution

Also please make a refund against your Payment processor manually

I guess this helps !!!


How to get IATS working Seems that IATS will not work using extension 1.5.3 - It logs the transaction in CiviCRM but never makes a connection with IATS. I'm not sure it is even connecting with the network.

Any clue folks?

If with EOL you mean End Of Life - you are mistaken! iATS 1.5.3 is already working for many transaction pathways in 4.7.x - but we will not release an official release until ALL 21 type of transactions, payment processor switches, chq debit img swapping, encrypted swipe is working as it currently is on 4.6.x LTS.

In general before upgrading any site you will really want to check to ensure that ALL extensions that you have enabled have releases for the CiviCRM version you're upgrading to - otherwise you're taking a risk.

A number of sites [from at least 3 CiviCRM partners that I know of and likely more] are already transacting with iATS on 4.7.x - they would have created a staging copy to check that their pathways are working.

So I'm not sure what issues you're running into. Are you using TLS 1.2? Is SOAP enabled? Any clues in the iats log tables? agent code/password correct - and configured properly?

See iATS Extension - README.md file:
9002 Error - if you get this when trying to make a contribution, then you're getting that error back from the iATS server due to an account misconfiguration. One source is due to some special characters in your passwd.

Also: Please have a look at the link http://home.iatspayments.com/Relaunch-SHA256 and check if your environment is compatible.

EDIT: to test if your server environment is indeed TLS 1.2 - go into your CiviCRM -> Payment Processor configuration and edit the URLs from www to www2 - so: e.g.:
https://www2.iatspayments.com/NetGate/ProcessLinkv2.asmx?WSDL
Run a transaction - if this works [if this does not produce a 9002 error] - then your server environment is -not- TLS 1.2

Ok!! I have found the culprit. Here is the response from my webhost:

This looks to be a limitation on your server when connecting to the remote server and we can test this directly using openssl.

Shown below is a failed connection to the remote server using TLSv1 (what your wget command specifies) to the remote server's HTTPS port (443):

CT-156611-bash-3.2# openssl s_client -tls1 -connect iatspayments.com:443
CONNECTED(00000003)
31985:error:14094410:SSL routines:SSL3_READ_BYTES:sslv3 alert handshake failure:s3_pkt.c:1092:SSL alert number 40
31985:error:1409E0E5:SSL routines:SSL3_WRITE_BYTES:ssl handshake failure:s3_pkt.c:536:

The same connection fail results from my local workstation. However, when specifying a higher version of TLS such as TLSv1.2, I am able to connect from my workstation as shown below

$ openssl s_client -quiet -tls1_2 -connect iatspayments.com:443
depth=3 C = SE, O = AddTrust AB, OU = AddTrust External TTP Network, CN = AddTrust External CA Root
verify return:1
depth=2 C = US, ST = New Jersey, L = Jersey City, O = The USERTRUST Network, CN = USERTrust RSA Certification Authority
verify return:1
depth=1 C = US, ST = VA, L = Herndon, O = Network Solutions L.L.C., CN = Network Solutions OV Server CA 2
verify return:1
depth=0 C = US, postalCode = 76131, ST = TX, L = Fort Worth, street = Suite 1800, street = 100 Throckmorton Street, O = First American Payment Systems, OU = Information Technology Group, OU = Secure Link SSL Pro, CN = www.iatspayments.com
verify return:1

Your server is running CentOS 5 which does not support TLS versions higher than TLSv1 and many servers are beginning to reject those connections, such as payment gateways. If you require this support, then it will be necessary to re-image the server to CentOS 7


How to get job.execute to run with drush I have the command in cron  cd /home/quabbinm/ && /usr/local/bin/drush -r /home/quabbinm/public_html/trainingactivebystanders.org -l https://trainingactivebystanders.org -u nan civicrm-api job.execute
which results in errors

X-Powered-By: PHP/5.6.33
Content-type: text/html; charset=UTF-8

Notice:  Undefined variable: argv in phar:///usr/local/bin/drush/drush on line 114

Warning:  array_shift() expects parameter 1 to be array, null given in phar:///usr/local/bin/drush/includes/startup.inc on line 171

Warning:  Invalid argument supplied for foreach() in phar:///usr/local/bin/drush/includes/startup.inc on line 182

Warning:  pcntl_exec() expects parameter 2 to be array, null given in phar:///usr/local/bin/drush/includes/startup.inc on line 359

Notice:  Use of undefined constant STDERR - assumed 'STDERR' in phar:///usr/local/bin/drush/includes/startup.inc on line 363

Warning:  fwrite() expects parameter 1 to be resource, string given in phar:///usr/local/bin/drush/includes/startup.inc on line 363

Notice:  Use of undefined constant STDERR - assumed 'STDERR' in phar:///usr/local/bin/drush/includes/startup.inc on line 364

Warning:  fwrite() expects parameter 1 to be resource, string given in phar:///usr/local/bin/drush/includes/startup.inc on line 364

When I run the same command at the command line it runs fine

It looks like you are using an incorrect version of php when this command runs from cron. According to this resource you are receiving these errors because you are using php-cgi rather than the php CLI binary. Most reports of this error are regarding 1 & 1 hosting.

Rather than using /usr/bin/drush use something like this:

  /usr/bin/php /usr/local/bin/drush {rest of the command}

Where /usr/bin/php is the path to the php CLI binary on your system.

Add this line to the crontab file:

PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin


What should be entered in the campaign field when importing a CSV file? I'm trying to import a CSV file with donations that need to be linked with a certain campaign. I tried putting the campaign name, then the external id, and even just "matching" but all of them are generating an error. Any advice?

I am running CiviCRM 4.6.19 on Drupal. The error message is:

  'xyz' is not a valid option for field campaign_id

I was able to successfully import the campaign on a contribution by importing the campaign's CiviCRM ID.

I agree that it seems odd that campaigns have an "External ID" field, but it can't be used for imports, though!

You can find your campaign IDs by going to Campaigns menu » Dashboard » Campaigns.  In CiviCRM 4.7+, they'll be in the first column of the list.  See screenshot 1 below.  If you're using CiviCRM 4.6 or lower, you can find the ID by hovering your mouse over the "Edit" button next to a campaign and reading the ID that appears in the URL at the bottom of your web browser.  See screenshot 2 below.

Is the campaign currently active or was it started before the dates your importing? I'm just throwing out a possible reason why it fails. I do not know if this would make or break the import.


Loading a page browser says Waiting for another URL (not mine) So when I'm waiting for CiviCRM to load in the bottom left of the browser it says Waiting for scorpioindustries.com.... (which is not my URL)

What could this be a sign of? Have tried loading in different browsers and different computers so it's not a browser or computer infection. I ran virus checkers on my site and nothing. I checked manually through the CiviCRM stack and couldn't find any reference to this URL. I ran a search in the MySQL database for "scorpio", "scorpioindustries" etc but nothing emerged from that.

Any ideas? I initially thought virus but I'm a little stumped now.... Maybe this is a Site Name sort of setting inside of CiviCRM?  Thanks :)

Use the Net tab within Firebug while loading the page.  It'll display all the page components that get loaded.  Something in your page (whether you put it there or not) is attempting to load something (an image, a script, who knows) from that domain.

Try checking your hosts file and running a anti-spyware scan. Porn websites and downloading free .mp3 music files as of my last knowledge in 2009 can cause spyware infections, such is of the signs as the following: you try to go to http://www.google.com and on typing and pressing enter you would be redirected to another website. when on one web site, your web browser skips to another site automatically.

Is your computer acting slow? Avoid using free music downloading programs such as Limewire or BearShare, and try avoid installing tool bars that might be offered upon installation of programs. First update all anti-virus, anti-spyware, anti-rootkit, anti-adware data bases and try doing scans with all of these. Install a firewall program; don't use the built-in default programs that come with Windows.

Do research and do Windows Update, but do research on the updates that you plan to install; only install manually, don't use automatic update. Download the Windows updates manually and install them manually. as Windows updates can conflict with other programs.

In safe mode, chkdsk c: / f / r /v at a command prompt, type y for yes if prompted to reboot. Upon reboot, Windows will check the disk for errors. Disk scanning for errors and scanning for malicious software one time a week is necessary. Also use the Microsoft Malicious Software Removal Tool.  Zone Alarm is a good firewall, ad blocker also, and http://www.iptools.su.

Do Google searches on every program before installing. Also look for free programs that you burn to a blank cd to scan under the operating system. Assuming you're using Windows XP platform; Win 7, Win 8 and Win 10 are all crappy and use way to much memory. Also try Glary Utilities.

Try to do a ping from a command prompt on that specific web site.


conditional tax in financial payment page for membership I am trying to setup conditional tax based on province for one membership in payment page. is there any reference I can use? is this hook needed and also custom code?

I am using drupal 7 with civi crm 4.7.1 version

some references would be great.

thank you

The easy - non-code - way to handle this is to create a Drupal node (page) with a select Province - and then based on Province selected popup a button with a link to a Contribution page that is configured with a Priceset that sells that Membership at that Province's General Sales Tax.

Edit: this is the only sustainable way to do this right now (see comment below).

One way of Doing this:
First of all you need to create priceset for the membership
and you need to create an Extension for handling this calculation and you can use hook_civicrm_buildAmount() and please put all you code in the extension

Please refer to the below link for hooks

https://wiki.civicrm.org/confluence/display/CRMDOC/Hook+Reference


Why does this custom file field uploaded on profile not download from the emailed link? I created a custom profile (to use as a form on my website) with a custom file field...When the user fills out the form, they upload a file, and the form is sent to the admin email address. When I open the email and download the attached file, I am unable to open it; the file becomes corrupt. However, if I use FTP and navigate to ".../files/civicrm/custom" and download the file from there, the file opens and is not corrupt.

The website is using wordpress.

Any help is much appreciated. Thanks in advance.

Please make sure you are closing the file properly before attaching to the email - any file which is open and been attached to email will have this issue


CiviCRM Groups Sync Plugin for Wordpress - No access to Settings I installed the CiviCRM Groups Sync Plugin after finding the CiviCRM Member Sync plugin is not currently syncing to the WP Groups.

It was all working and I set up a 'Guests' group in CiviCRM to sync to WP and it created the group 'Guests' in Wordpress. So that worked.

However, I registered as a Guest user via CiviCRM profile (which includes a create WP user account form) and was added to the Civi Guests group but not the WP Guests group.

I was just added to the default 'Registered' Group.

And now I've discovered I cannot access the CiviCRM Groups Sync plugin's Settings page. I get the dreaded 'Sorry, you are not allowed to access this page.'

This is the page being accessed https://somesite.com/wp-admin/options-general.php?page=civicrm_groups_sync_parent

I'm logged into WP as Administrator.

I'm not seeing any errors in the PHP error log, and have WP DEBUG on but not showing any errors.

Help!

Cheers,
Tracy

UPDATE:

UPDATE: Also, this plugin does not really help with removing the user when their Civi Membership lapses. So really the member sync plugin would be ideal as it works with the differing Civi Membership states.

I registered as a Guest user via CiviCRM profile (which includes a create WP user account form) and ... [snip] ... now I've discovered I cannot access the CiviCRM Groups Sync plugin's Settings page

I can't be entirely sure, but I think you may have been confused by the process of registering "as a Guest user via CiviCRM profile". When you do this and create a user account at the same time, CiviCRM will automatically log you in as that user. (FWIW that's one reason I don't use this functionality since there's no way to prevent that from happening) If you subsequently browse your WordPress site as that user, you'll find (depending on the default user role you have set) that you cannot access parts of it. You'd need to log out of WordPress and log in as your admin user to restore your capabilities.

  Also, this plugin does not really help with removing the user when their Civi Membership lapses. So really the member sync plugin would be ideal as it works with the differing Civi Membership states.

As I said in response to another question of yours on SE, this is on my to-do list. Please be patient and remember that the joy of free software is that it's free. My time, on the other hand, is limited - especially in the summer holidays. Luckily for you, funding has indeed been found and set aside to implement this - when I have the time to do so!

In case anyone else is wondering, the Settings link in the plugin (shown in the screenshot in my original question) is an unused link (at the present).

I will post a separate question on why the Groups sync plugin is only syncing when a contact gets manually added to a Civi Group.


Is is possible to import cases into Civi A client has many cases in spreadsheets, and Civicase looks very suitable.  I cannot see any facility to import cases into Civi via the UI.  Is this possible? I guess the alternative is to import directly into the database. Any suggestions?

As far as I know there is no Import Cases in the UI. So importing into the database would be the solution, but make sure you respect all the data models! You need to add data to civicrm_case, civicrm_case_contact, probably civicrm_case_activity and civicrm_activity and for the roles into civicrm_relationship.

I've been working out the queries to do this for the past week or so for a client who is migrating from an old desktop database.

Here's the full list of tables involved:

civicrm_case

civicrm_case_contact (to link each case to a contact id)

civicrm_activity (to create the necessary activities for each case)

civicrm_case_activity (links activity to case id)

civicrm_activity_contact (multiple records for each activity)

civicrm_relationship (relationships between case subject and assignees)

You can actually get away without filling in the relationships if this is purely historical data but it's only an extra query so you may as well fill it in.

I created a special case type for the data import and used the subject field to store details about the old cases during the SQL imports. I removed all required activities but one from this case type which simplified the import process.

When in doubt, just create test cases under a dummy contact and see what values are populated.

EDIT: I decided to write up the entire procedure on my website. You can find the details here -
http://www.drewslair.com/2016/06/importing-case-data-civicase/


CiviCRM Raw Data Files We use CiviCRM for our nonprofit, and we're trying to figure out how we can export our raw data in order to upload it into some custom apps. Any help would be very much appreciated!

Cheers,
Jillian

The answer rather depends on what data you have in CiviCRM and what you want to export.

One option is to export the data as a CSV file as Demerit says. This will allow you to export certain types of data - for example: contacts, event participants, activities.  You can do this via advanced search. See the manual for more details: Exporting your contacts.

Another option is to access the data directly from the database. This gives you more control to access the data that you need but would require some understanding of the database structure and SQL. If you have access to phpMyAdmin you will be able to export the SQL data using this (log in to phpMyAdmin and click on the Export tab). Alternatively your website hosting company may have a tool that allows you to export the SQL - you could contact them for help.

A third option to export the data via the API which would require some programming.

https://docs.civicrm.org/user/en/stable/common-workflows/exporting-your-contacts/

(Adding some.text because it seems stackexchange wants at least 30 chars of text. Ignore this text and just follow the link.)


Is CiviCRM right for our organization? We are a non-profit mission sending agency. We are not looking for donor management software, but we are looking for more of an HR platform where we can manage all of our employees and all of their information so that it is available in multiple ways to multiple people within the organization.

Also does an API exist within the software?

Check this out!

https://civihr.org/

It's an extension (add-on) to core

I also just wanted to point out we have no updated the information on the link that Karin provided in a while.

You might want to have a look at our
website: https://civihr.org/
twitter:twitter.com/civi_hr
and wiki: https://wiki.civicrm.org/confluence/display/HR/CiviHR


How to make backup joomla CiviCRM smaller? I made a backup of my httpdocs directory (a very small Joomla and CiviCRM extension) and discovered the backup contained more than 15000 different files? Is this normal? can I skip some of these from the backup?.

Thank you
Rob

One great way to shrink the backup is to only backup the bespoke bits (e.g. custom extensions and themes) and the database, not the actual Joomla! and CiviCRM code files that are freely downloaded from elsewhere.

This depends on you not having edited any core files, which your developers shouldn't be doing anyway.

thank you

I backup the database with phpmyadmin and the files with ftp because then I have the correct versions for joomla and civi

I have no ssh access and never changed the core files so I think of leaving out all unused themes and unused extensions
thnx again


Error when upgrading from 4.7.16 to 4.7.20 I want to upgrade my site (Drupal 7.54 to 7.55, then civicrm 4.7.16 to 4.7.20).

No problem on Drupal upgrade.

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

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

(BTW, civicrm_case table is empty on my site)

It appears that the foreign key mentioned in the error message doesn't exist for some reason. I would probably go into MySQL and check.  If it's not there, just create one with the same name on the civicrm_case table. Then try the upgrade again.

A MySQL statement to create the foreign key (from CiviCRM 4.5) is: ADD CONSTRAINT FK_civicrm_case_case_type_id FOREIGN KEY (case_type_id) REFERENCES civicrm_case_type (id) ON DELETE SET NULL;

had same issue upgrading from 4.6 to 4.7

running that SQL code in phpmyadmin fixed it.  THANKS!!!!

ALTER TABLE civicrm_case ADD CONSTRAINT FK_civicrm_case_case_type_id FOREIGN KEY (case_type_id) REFERENCES civicrm_case_type (id) ON DELETE SET NULL;


If I use php to display a count from my database am I causing a security problem? I would like to count and display on my front page how many people have signed a civi petition. This I have been able to do using php as below. What I am wondering is if I am causing any kind of insecurity in my system - if I can get the data out what  is to stop someone else inserting data in?

Sorry this may be a 101 question but I haven't been able to find this out by searching.
Thanks! Caroline

open php
$sql=("SELECT COUNT(*) FROM civicrm_activity WHERE activity_type_id=32");
$rs = mysql_query($sql);
$result = mysql_fetch_array($rs);
echo "
 SIGNATURES SO FAR:     $result[0]
 ";
close php

I would highly recommend you use the CiviCRM API to access this information.

A php version would look something like this:

$result = civicrm_api3('Activity', 'get', array(
  'sequential' => 1,
  'activity_type_id' => "Petition",
  'options' => array('limit' => 1000),
));

(Setting limit to be something larger than you would expect to get.)

Which would return the count (in addition to the activities which you can ignore).

{
"is_error":0,
"version":3,
"count":1,
"id":1,
"values":[{
    "id":"1",
    "activity_type_id":"9",
.....

If you are using version 4.6, in place of the get action, use getcount, which will only return the count... without detail and not requiring the limit.

You can play with the call by going to /civicrm/api/explorer.

Not sure about the security risks, not my expertise. But I would expect it to be a liability.


Search Builder Issue I have  a problem with Search Builder on my CiviCRM.
I just wanted to check how many contacts i have in my db outside of Italy.
It should be a simple search:

Record Type = Contacts
Field type = Country
Operator = ≠
Value = Italy

I get this error: "Sorry but we are not able to provide this at the moment.
DB Error: no such field". If i try with another field type, e.g. city, it works.

I've tried the same search in CiviCRM Beta website, it works.

Is there someone who can help me figuring out what could be the problem here?

Thank you very much
Alessandro

I believe you would need to find the country_id for Italy in civicrm_country, and then use that? The country name will not be stored in any other table.


"Invalid Contact ID" displayed after merge? Drupal 7, Civicrm 4.7.4

I'm getting this error message after every contact merge. Any ideas?

debug message

CiviCRM_API3_Exception: "Invalid Contact Id"

 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Dedupe/Merger.php(1945): civicrm_api3("activity", "create", (Array:5))
 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Dedupe/Merger.php(1834): CRM_Dedupe_Merger::createMergeActivities("55836", "197792")
 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Contact/Form/Merge.php(318): CRM_Dedupe_Merger::moveAllBelongings("55836", "197792", (Array:35))
 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Core/Form.php(423): CRM_Contact_Form_Merge->postProcess()
 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Core/StateMachine.php(160): CRM_Core_Form->mainProcess()
 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php(61): CRM_Core_StateMachine->perform(Object(CRM_Contact_Form_Merge), "next", "Next")
 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Contact_Form_Merge), "next")
 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Merge), "next")
 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("next")
 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(113): CRM_Core_Controller->run()
 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(286): CRM_Utils_Wrapper->run("CRM_Contact_Form_Merge", "Merge Contact", NULL)
 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:13))
 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))
 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/drupal/civicrm.module(454): CRM_Core_Invoke::invoke((Array:3))
 [internal function](): civicrm_invoke("contact", "merge")
 /var/www/vhosts/example.com/httpdocs/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:2))
 /var/www/vhosts/example.com/httpdocs/index.php(21): menu_execute_active_handler()
 {main}
 Sorry but we are not able to provide this at the moment.
Invalid Contact Id

Ah - if the contact id doesn't exist perhaps delete to trash is off?


Civi CRM Sparkpost - pesc.sparkpost - Error Sending Group Subscription Welcome Emails So, I'm using the com.pesc.sparkpost CiviCRM/Sparkpost integration extension.  It is working really well so far for just about everything except for the welcome email for mailing list group subscriptions.  I've tried through a drupal webform and through a Civi profile (using checkmark boxes for public subscriber groups).  In both cases, the double-opt-in email gets sent properly, and the link in the double-opt-in email works properly.  Upon clicking the link I am sent to a confirmation page with an error message (bellow), but the welcome email is never sent, and the transactional email is shown as pending on the user's profile in Civi.

So, Transactional emails and Mass mail are definitely being sent fine through Sparkpost, and the subscription mechanism is working as intended.  So I'm pretty sure that my sparkpost smtp settings are working as intended, contrary to the error message.  So far it seems to be just these welcome emails that aren't sending properly.

  An error occurred when CiviCRM attempted to send an email (via SMTP). If you received this error after submitting on online contribution or event registration - the transaction was completed, but we were unable to send the email receipt.

  The mail library returned the following error message:
  Failed to send data [SMTP: Invalid response code received from SMTP server while sending email. This is often caused by a misconfiguration in Outbound Email settings. Please verify the settings at Administer CiviCRM >> Global Settings >> Outbound Email (SMTP). (code: 550, response: 5.7.1 Unconfigured Sending Domain )]

  This is probably related to a problem in your Outbound Email Settings (Administer CiviCRM » System Settings » Outbound Email), OR the FROM email address specifically configured for your contribution page or event. Possible causes are:

  Your SMTP Username or Password are incorrect.
  Your SMTP Server (machine) name is incorrect.
  You need to use a Port other than the default port 25 in your environment.
  Your SMTP server is just not responding right now (it is down for some reason).
  The FROM Email Address configured for this feature may not be a valid sender based on your email service provider rules.

  (i) Name (email@example.com) has been successfully subscribed to the mailing list.

Put

define('CIVICRM_MAIL_LOG', '/whereever/you/want/the/log');

in civicrm.settings.php and this will log what it's trying to send. If the from address appears incorrect then whatever it is appearing as might lead you to the problem.


https://docs.civicrm.org/dev/en/latest/framework/ajax/ I would like to open a modal with options editor inside (please see the screenshot below). I would like to call a custom JavaScript function whenever an option has been changed via that modal. By "changed" I mean added, renamed, deleted, disabled, reordered etc.

As per https://docs.civicrm.org/dev/en/latest/framework/ajax/ there are a couple of events related to dialogue forms that you can track, including crmFormSuccess. This event will fire on the label change, or new element addition, but not on the enabling/disabling or reordering.

The code snippet:

CRM.loadForm('/civicrm/admin/options/individual_suffix?reset=1')
  .on('crmFormSuccess', () => {
    // will not trigger on reordering or enabling/disabling
    console.log('Updated...');
  });

Is there a similar event to handle these events as well?

crmLoad is triggered on every action. Try:

CRM.$(document).on('crmLoad', function(e, data) {
    console.log(data);
})

Ok, Just so I am clear on what you want. Your new question is:

You want to:

1). "Filter" using JavaScipt "ALL" the events on the CiviCRM  Personal Contributions Page and

2) Set "handlers" to respond to "Onchange" events only when the users toggle the "Enable" and "Disable" elements on the PCC page?

Is that correct?


Upgraded to 4.6 Civicrm javascript errors Error can't send email or press some buttons Error: b.indexOf is not a function b@https://www.websiteremoved.com/administrator/components/com_civicrm/civicrm/bower_components/select2/select2.min.js

I can't add receipients or get past step one of generating a draft, firebug reveals a constant error of:

: b.indexOf is not a function b@https://www.websiteremoved.com/administrator/components/com_civicrm/civicrm/bower_components/select2/select2.min.js

It is literally this article from the old forums but I cannot seeem to find any solutions at all Please help! Its Christmas!!!

forum.civicrm.org/index.php?topic=36343.0

issues.civicrm.org is down right now - but I see this issue: CRM-12570 "Javascript error when mootools is loaded in Joomla backend".  I'll also note that everyone reporting this problem is using Joomla.  So my guess is that there's a Joomla plugin that's causing a jQuery conflict or similar.

To troubleshoot this, I would:

Disable all your other Joomla plugins.  I hope you're doing your upgrade on a dev server before doing it on a live server!  If disabling all of them solves the problem, start turning them back on until you can identify which one has the conflict.
Check your Net tab in your browser's developer tools when loading a page on your site vs. on the demo Joomla site.  Are there any errors, or unusual JavaScript files on your live site compared to the demo?  If so, identify their source.

I'm having this issue as well, but I'm on a Drupal site.  I don't have anything extra installed, just the core of drupal and a very basic Civicrm.  No extenstions, no plugins.  In drupal, there's only one other mod an that's webforms.  Everything is updated.

I can't seem to fix this!


EntityTag table not available to drupal view Creating a view in drupal, when I try to add a field I see all the normal civiCRM fields for contacts, email, etc, but what I want is the entity_tag table for the contact id which does not appear in the list of available fields.

The table is listed in sites/default/settings.php, but it is not available in the view

I created a view based on civicontact and it seems to work.

Thanks


Can I automatically replace the "civicrm" from all URLs with another string? (drupal7 + civicrm 4.7.4) How can I replace the '/civicrm/' portion of all site URLs automatically? I want change all the URLs so I cant do it one by one with a Drupal "URL alias".

Could I somehow swap the name 'civicrm' for a different string such as 'myOrg'? (eg: if someone visited /civicrm/admin?reset=1 they would be redirected to /myOrg/admin?reset=1 )

There is no easy way to do this.

You might be able to create a drupal module that is able to get the myOrg urls and then renders the CiviCRM version of it.

But then you still have the problem that the internal links that CiviCRM creates will be in the /civicrm/* form.

To solve that you could first get the CiviCRM page as a string in the drupal module, then do a search/replace and output it.

Very hackish, probably not possible to get it 100% right. I would advise not to.

Thank you @Catorghans for the answer,

I can not add a comment

I created a Drupal Module "myorg" to render CiviCRM URLs

function myorg_menu() {
    $items['myorg/admin/custom/group'] = array(
        'title' => 'Custom Data',
        'page callback' => 'CRM_Custom_Page_Group',
        'access arguments' => array('Customize Data and Screens'),
        'file' => 'CRM/Custom/Page/Group.php',
        'file path' => 'sites/all/modules/custom/civicrm',
    );
    return $items;
}

when I accede to 'myorg/admin/custom/group', i have error :

Fatal error: Class 'CRM_Core_Page' not found in /projet/organisation/sites/all/modules/custom/civicrm/CRM/Custom/Page/Group.php on line 44


How to resolve error: "Recurring contribution, but no database id"? When processing a new recurring membership, with the "Please renew my membership automatically" option enabled, we get the following error:

  Sorry but we are not able to provide this at the moment.

  Recurring contribution, but no database id

What can we do to troubleshoot/resolve this issue?

Temporary fix

As a temporary fix, we set the Membership Type Auto-renew Option value to No auto-renew option. Now, we can process memberships, but those memberships can not auto-renew.

We would like for members to have the option to auto-renew their membership.

Environment

Drupal 7.x
CiviCRM 4.7.x
MySQL

I am also experiencing this issue and have raised an issue in JIRA - https://issues.civicrm.org/jira/browse/CRM-18389.  You can fix this by upgrading to CiviCRM 4.7.9 or higher.

I was just testing my Membership Contributions pages in the PayPal Sandbox to see what does happen when a renewal goes through (I was expecting a receipt sent from CiviCRM), however I'm seeing the same error that Mr. Oxley is seeing.

This on :
Joomla 3.5.0
CiviCRM 4.7.4
MySql 5.5.45
PHP 5.5.31

Here's the relevant log entries:

Apr 04 05:42:23  [info] $Fatal Error Details = Array
(
    [message] => Recurring contribution, but no database id
    [code] =>
)

Apr 04 05:42:23  [info] $backTrace = #0 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(366): CRM_Core_Error::backtrace("backTrace", TRUE)

1 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Payment/PayPalImpl.php(904): CRM_Core_Error::fatal("Recurring contribution, but no database id")

2 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Payment.php(978): CRM_Core_Payment_PayPalImpl->doTransferCheckout((Array:59), "contribute")

3 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Payment/PayPalImpl.php(457): CRM_Core_Payment->doPayment((Array:59), "contribute")

4 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Contribute/Form/Contribution/Confirm.php(1575): CRM_Core_Payment_PayPalImpl->doPayment((Array:59), "contribute")

5 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Contribute/Form/Contribution/Confirm.php(1361): CRM_Contribute_Form_Contribution_Confirm->postProcessMembership((Array:54), "347", Object(CRM_Contribute_Form_Contribution_Confirm), (Array:50), (Array:0), (Array:0), (Array:13), (Array:1), TRUE, NULL, FALSE, "2", (Array:0), 0, TRUE)

6 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Contribute/Form/Contribution/Confirm.php(2266): CRM_Contribute_Form_Contribution_Confirm->processMembership((Array:54), "347", (Array:0), (Array:0), (Array:50), (Array:0), 0)

7 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Contribute/Form/Contribution/Confirm.php(2140): CRM_Contribute_Form_Contribution_Confirm->doMembershipProcessing("347", (Array:53), (Array:50), 0)

8 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Contribute/Form/Contribution/Confirm.php(594): CRM_Contribute_Form_Contribution_Confirm->processFormSubmission("347")

9 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php(423): CRM_Contribute_Form_Contribution_Confirm->postProcess()

10 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/StateMachine.php(160): CRM_Core_Form->mainProcess()

11 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php(61): CRM_Core_StateMachine->perform(Object(CRM_Contribute_Form_Contribution_Confirm), "next", "Next")

12 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Contribute_Form_Contribution_Confirm), "next")

13 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contribute_Form_Contribution_Confirm), "next")

14 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("next")

15 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(312): CRM_Core_Controller->run((Array:3), NULL)

16 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:15))

17 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))

18 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm.php(116): CRM_Core_Invoke::invoke((Array:3))

19 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm.php(40): civicrm_invoke()

20 /home/nwtaadmin/public_html/libraries/cms/component/helper.php(405): require_once("/home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm.php")

21 /home/nwtaadmin/public_html/libraries/cms/component/helper.php(380): JComponentHelper::executeComponent("/home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm.php")

22 /home/nwtaadmin/public_html/libraries/cms/application/administrator.php(98): JComponentHelper::renderComponent("com_civicrm")

23 /home/nwtaadmin/public_html/libraries/cms/application/administrator.php(152): JApplicationAdministrator->dispatch()

24 /home/nwtaadmin/public_html/libraries/cms/application/cms.php(257): JApplicationAdministrator->doExecute()

25 /home/nwtaadmin/public_html/administrator/index.php(51): JApplicationCms->execute()

26 {main}


Attributes of dumb groups In the table civicrm_group, I've noticed that even my non-smart groups have the fields where_clause, where_table, and select_table filled in. These don't seem necessary and cause a fair amount of slowness.

Is their a reason they exist, and is there a down-side to making those fields null in non-smart groups?

Why are you saying it's the cause of the slowness? Did you manually make them null and measured an improvement of the speed?


civicrmHooks.php no longer invoked under Joomla and CiviCRM 4.7.20 This is related to Invoking hook_custom_tokens and hook_custom_tokenValues in Joomla which used to work.  It has now appeared to have stopped working which means that the custom tokens handled by civicrmHooks.php are no longer available.  It looks as though civicrmHooks.php is no longer being invoked, as deliberately introducing an error does not result in CiviCRM crashing.

What has changed recently.  How can we solve this?

I've spot-checked the current 4.7.21-rc and as well as an older version 4.7.15 -- the problem reproduces in both. The problem arises with web-based requests in which these two operations are performed in the wrong order: (a) updating the include_path and (b) loading the civicrmHooks.php from the include_path.

(Doing a proper audit of Joomla regressions is painful, but I'd wager the problem originates in the 4.7 alpha/beta cycle.)

Searching JIRA for civicrmHooks.php turns up a nearly identical issue CRM-19914, which was fixed in WordPress -- but it was incorrectly described/triaged as a "Windows" issue. (The bug actually would have applied to Joomla+WordPress, regardless of OS.)

I'll submit a similar patch for Joomla under CRM-19914.

Tim Otten did some work on trying to unify CMS Hooks and Symphony Events see CRM-19813 I'm not sure what version you were on previously but these changes came in 4.7.19 and maybe related. I know there seems to be some issues in regards to Joomla upgrades which may also be at play. I would recommend commenting on that issue or posting in #dev-postrelease in mattermost and pinging Tim @totten about the issue


CiviEvent - if registration date is is in the past, shouldn't be Online registration enabled? These two doesn't seem to play well together. Mean, both options are mutually exclusive: we don't want Online Registration enabled if Registration End Date is in the past, do we? Even if (not sure) by "Registration End Date" we mean an offline registration end date.

The checkbox that states "online registration is enabled" acts like a switch to enable online registration and allow you to configure the online registration parameters under the tab. If you uncheck this the fields will be hidden and online registration will be disabled.

The date fields set the start and end date that the online registration forms are available to visitors. This allows you to open and close registration at specific times automatically.

This all controls the public registration. nothing on this screen effects back end registrations.

Hope this helps.


"Access denied" after IP address change (WAMP; Drupal) I wasted hours of searching Google back and forth, and found no solution:
CiviCRM is set up as an internal only CRM system for an organisation (i.e. IP address 192.168.178.36) - so far, so good. Now I took the server with me to work on CiviCRM, so I changed the IP address to 192.168.2.36 accordingly.

I've changed Apaches httpd.conf, and Apache runs without issues. Drupal seems to come up fine, but whenever I want to access CiviCRM via
http://192.168.2.36/q=civicrm/dashboard
the website answers with

a) the former IP address (192.168.178.36) in the header of the result page,

b) "Access denied - you are not authorized to access this page."

I deleted the content of all drupal cache tables, I deleted the content of the "templates_c" directory - no success :-(

Please, can someone point me into the right direction?

Regards

Bernhard

Setting up a new database isn't necessary.  For folks who encounter similar issues in the future:  after checking your BASE_URL setting in civicrm.settings.php, delete your templates_c folder (found here), clear all CiviCRM caches, and rebuild your menus.  Details on the latter two items are available here.

The answer is hidden deep in the database. I tried to install Drupal again (just the program), and the same message came up. When I then created a new database, everything works as expected.

So be warned that you will need to setup a new database if you plan to move the server to a new location!


CiviRules and CiviCRM 4.7 For those that are using CiviRules, what has your testing on CiviCRM 4.7.x shown?  Is this something that is showing major issues, minor issues, seems to fine?  Having never used CiviRules, I've got no basis from which to begin test, but may have reason to use the extension now.

(CiviCRM 4.7.2 is the current stable at the time of writing.)

I'm in the same boat! Just about to install and enable as we need to trigger email to customer when they submit a profile from WordPress...

UPDATE
From initial testing it seems to work fine with 4.7.3 however I have only used the "Add to group" trigger and "send email" function. Both seem to work fine.

UPDATE 2
CiviRules is working on a live site now and performing well. Only have 10 rules which just send emails when people are added to groups. The delayed actions also work fine.

So to get it installed on 4.7.x, simply edit the "info.xml" file for the extension, adding <ver>4.7</ver> under the /extension/compatibility element and then installing as normal.

This is by no means a comprehensive test! Please perform your own prior to a live release!

Doesn't seem to work with any of the event triggers (create,change,delete) across versions 4.6.x and 4.7.x

This error message comes up.

Sorry but we are not able to provide this at the moment. One of parameters (value: ) is not of the type Integer


Has anyone gotten CiviRebux working? Has anyone successfully gotten CiviRebux installed and working? UPDATE: If you have CiviRebux running, would you be willing to post a comment with the version of MySQL that your server is running?

The blog post and video demo look great but I have not had any luck getting it to function. I run into a fatal syntax error:

[code] => -2
[message] => DB Error: syntax error
[mode] => 16
[debug_info] => CREATE TRIGGER civicrm_civirebux_configuration_after_insert after insert ON civicrm_civirebux_configuration FOR EACH ROW BEGIN  IF ( @civicrm_disable_logging IS NULL OR @civicrm_disable_logging = 0 ) THEN INSERT INTO log_civicrm_civirebux_configuration (id, name, renderer, aggregator, vals, rows, cols, time, desc, type, log_conn_id, log_user_id, log_action) VALUES ( NEW.id, NEW.name, NEW.renderer, NEW.aggregator, NEW.vals, NEW.rows, NEW.cols, NEW.time, NEW.desc, NEW.type, CONNECTION_ID(), @civicrm_user_id, 'insert'); END IF; END [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 'desc, type, log_conn_id, log_user_id, log_action) VALUES ( NEW.id, NEW.name, NEW' at line 1]
[type] => DB_Error
[user_info] => CREATE TRIGGER civicrm_civirebux_configuration_after_insert after insert ON civicrm_civirebux_configuration FOR EACH ROW BEGIN  IF ( @civicrm_disable_logging IS NULL OR @civicrm_disable_logging = 0 ) THEN INSERT INTO log_civicrm_civirebux_configuration (id, name, renderer, aggregator, vals, rows, cols, time, desc, type, log_conn_id, log_user_id, log_action) VALUES ( NEW.id, NEW.name, NEW.renderer, NEW.aggregator, NEW.vals, NEW.rows, NEW.cols, NEW.time, NEW.desc, NEW.type, CONNECTION_ID(), @civicrm_user_id, 'insert'); END IF; END [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 'desc, type, log_conn_id, log_user_id, log_action) VALUES ( NEW.id, NEW.name, NEW' at line 1]
[to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TRIGGER civicrm_civirebux_configuration_after_insert after insert ON civicrm_civirebux_configuration FOR EACH ROW BEGIN  IF ( @civicrm_disable_logging IS NULL OR @civicrm_disable_logging = 0 ) THEN INSERT INTO log_civicrm_civirebux_configuration (id, name, renderer, aggregator, vals, rows, cols, time, desc, type, log_conn_id, log_user_id, log_action) VALUES ( NEW.id, NEW.name, NEW.renderer, NEW.aggregator, NEW.vals, NEW.rows, NEW.cols, NEW.time, NEW.desc, NEW.type, CONNECTION_ID(), @civicrm_user_id, 'insert'); END IF; END [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 'desc, type, log_conn_id, log_user_id, log_action) VALUES ( NEW.id, NEW.name, NEW' at line 1]"]
)

Versions:

PHP 5.5.38
MySQL 5.5.52-cll

As Chris says, the problem is due to CiviCRM's Data Logging feature having a problem with column names that are MySQL reserved words. As John says, in this case it's the column named desc.

I think this is a bug in Civi logging rather than in the extension: it's allowed in MySQL to have a column name that is a reserved word, provided it is properly escaped when referred to. Civi logging should deal with that.

I have filed an issue: SQL syntax error creating logging triggers if column name is reserved word and tested a fix against 4.6.27, which from a quick look at the code should apply to 4.7 too - I'm going to test that and create a pull request. If you test the fix, please leave a comment on the issue with your results.

Update 20 Jun 2017: I've now replicated the problem with the latest 4.6 & 4.7 (master) code and verified that the fix (suitably adapted) works for both versions. Created PRs for 4.6 & 4.7 . The 4.7 one has been merged and the issue marked fixed.

Based on nothing, "desc" doesn't seem like a likely column name, and it's where the error occurs.

Does this match the name of a column in your database?


Bug datepicker field when more than one on contribution page I have civicrm installed on wordpress
I have a issue with datepicker field
When i put only one datepicker field it's works well
But if i insert more than one datepicker field in a form, the datepicker field are breaked.
I have try with a fresh install on new versions of civicrm and wordpress and i have the same problem.

Could you help me to solve this issue

Thanks !

Hello you can see here the way my datepicker field are displayed when two are on the same form.

This bug is also present with a fresh install

Thanks for help


How to send email report FROM other than default email address? I have a report that is sending successfully every week. Only issue is I was not able to set FROM email address for the report. It’s always sent from default email address, but I need to send from different email. Can anyone suggest how to solve this issue please? Or whether it’s even possible at all? Thanks

parameters for API call is currently like this

instanceId=50
format=print
sendmail=1

I don't think it has this feature. One possibility is make an extension and use hook_civicrm_alterMailParams to check if the email is your report and then change the from.

If you own another email address, you can send mail as that address. For example:

Yahoo, Outlook, or other non-Gmail address
Your work, school, or business domain or alias, like @yourschool.edu or youralias@gmail.com
Another Gmail address


If my website in in WP, can i install CiviCRM in drupal? Our NP site is made with WP, i did install Civicrm but wasnt a fan of how it looked, i learned there is a theme but its only for the drupal version.
I installed drupal as a subdomain and was planning to install Civicrm. Is there any reason to have CRM on the same CMS?

Welcome! What Masswear says is not right. You can have your website in wordpress and have CiviCRM in a Drupal installation.
You can the connect your wordpress site to civicrm with a plugin called CiviMcRestFace. This plugin creates an api connection to civicrm. So you need an API key (of the civicrm user) and the site key.
When you want to send signup forms to civicrm you can then use Caldera Forms and Integration of CiviCRM Form Processor with Caldera forms. You then also need the Form Processor extension in CiviCRM.
I believe that the Contact Form 7 CiviCRM Integration plugin also works with CiviRestFace. But I am not sure about that what I do know is that it connect to an external CiviCRM
When you want to display data from your drupal CiviCRM installation you can use the wpDataTable plugin and the Data Source CiviCRM api for wpDataTable plugin to display data from a civicrm as a table on your word press pages. Eventually you can use the Data Processor extension in CiviCRM to create custom api's through the user interface.

Welcome! If your website is made with Wordpress and you would like to integrate civiCRM with this website, you have to use the Plugin for wordpress. If you want to use Drupal, you will need to create the website with Drupal as well. You might want to look into this Wordpress-Plugin that supplies a theme for CiviCRM admin screens that is more in keeping with WordPress: https://wordpress.org/plugins/civicrm-admin-utilities/


Database error when saving CiviCRM event: “Row size too large” I'm using CiviCRM in multilingual mode. I can generally create events (and other objects) fine. However, I often run into update problems at some point. The interface will "spin" and never save.

Looking at the CiviCRM error log reveals a database error:

nativecode=1118 ** Row size too large (> 8126)

I have looked at this clearly related case: Database error when using CiviCRM admin UI: "Row size too large"

I have tried (with some trepidation because I haven't worked on the Civi backend yet and don't know where the pitfalls are) to change the ROW_FORMAT of Civicrm_event_en_CA to Dynamic, but am told that it is not a base table.

I'm not really clear as I am more of a db user than a programmer, but assume that this table is somehow subsidiary to civicrm_event.

That table is set to ROW_TYPE=COMPACT. I'm game to change it, but it seems drastic enough that I am wondering:

Is it safe to do so WRT to CiviCRM operation?
Will it persist through a CiviCRM upgrade or will it revert (and potentially throw away data)?

this might be a mariadb config issue.

# enable large indexes and Barracuda
# for utf8mb4
innodb_file_per_table=1
innodb_file_format=Barracuda
innodb_large_prefix=1

might also change the tables to
ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED
see this post for much more info on this front https://stackoverflow.com/questions/15585602/change-limit-for-mysql-row-size-too-large

but do not follow the suggestion there to alter the tables to use MyISAM instead of INNODB, that's a really bad idea.

Adding this for ease of reference... In addition to the above innodb config, you will need to check the tables as @Keith Nunn alluded to. There are two tables that may need tweaking, SQL code below (row format is the key, but no harm to make sure block size and engine are set):-

ALTER TABLE civicrm_contribution_page
ENGINE=InnoDB
ROW_FORMAT=COMPRESSED
KEY_BLOCK_SIZE=8;

ALTER TABLE civicrm_event
ENGINE=InnoDB
ROW_FORMAT=COMPRESSED
KEY_BLOCK_SIZE=8;


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

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

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

CiviCRM 4.7.19
Joomla 3.7.2
php 7.0.19
MySQL 5.6.36

Cache files are cleared by a scheduled job, which isn't enabled by default.

Go to Administer menu » System Settings » Scheduled Jobs.
Find the row labeled Clean-up Temporary Data and Files.
On that row, click more menu » Enable.

Try changing the templates_c folder permissions to 777 recursively so that every sub directory would have 777 permission also.


Why does a Smart Group disappear when assigned a Parent I'm running CiviCRM 4.7.6, and in attempt to associate an ACL with a Smart Group, I assigned my Smart Group a parent which is a static group. This seems to have worked, in that when I list the members of the static group, the members of the Smart Group are in the list, however now the Smart Group has disappeared from the list of groups.

To summarize:

Created Smart Group called "Current Members" that selects contacts based on their membership status
Created static Group "Members"
Assigned "Members" as the parent group for "Current Members"

Now, Static Group "Members" includes all the contacts from Smart Group "Current Members" has disappeared from the list of Groups.

Did I break some rule mixing Smart Groups and Static Groups, or is there some list of child groups I don't see?

On the manage groups screen is there a triangle to the left of the word 'Members' that expands to show the child groups when you click on it?  There should be.

I've got exact the same problem. I upgraded to 4.7.6 from 4.6 and all the childgroups disappeared, no triangle to be seen.

Using Civicrm with Drupal. Changed layout but that didn't help.


How can I change column width on printed reports How do I change the width of columns on printed reports. Some columns are too wide and some are too narrow.

Depends whether its a one off report or something that you want to use regularly or for others to use without having to configure. The way I get reports looking how I want them is to export as CSV and then use Excel to set up the layout.

Go to Administer > Communications > Message Templates > System Workflow Messages > Pick the receipt that you need to edit.
Scroll down to the HTML Format box and edit the layout to your liking. Then click save at the bottom.


How to have credit card option appear without enabling Pay Later option We recently moved to WordPress 4.3.1 and just upgraded to Civi 4.6.10. We've been having an issue with the credit card option on our donation forms since the move to WordPress. The credit card option will not appear unless you enable the Pay Later option. Which we do not wish to show.

(FYI - we have taken the label off so as to confuse our donors less. It just says "Other" now.)

I believe you're coming up against this bug: https://issues.civicrm.org/jira/browse/CRM-17735.  I believe CiviCRM 4.6.11 comes out Wednesday with a fix!

It basically related to civicrm template. If you are using civicrm custom template then check the version of custom template and installed civicrm version. Both template must have the same version. Also make credit card payment processor as default processor.