texts: How to fix Undefined index notice in contribution_date_relative?

texts:
When I try to Update Smart Group Counts in Manage Groups, the CiviCRM provides me with numerous notices.

What is wrong and where do I fix that?

Notice: Undefined index: contribution_date_relative in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 204 of /crm/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggregate.php).
Notice: Undefined index: contribution_date_low in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 205 of /crm/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggregate.php).
Notice: Undefined index: contribution_date_high in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 206 of /crm/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggregate.php).
Notice: Undefined index: contribution_date_relative in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 204 of /crm/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggregate.php).
Notice: Undefined index: contribution_date_low in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 205 of /crm/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggregate.php).
Notice: Undefined index: contribution_date_high in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 206 of /crm/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggregate.php).
Notice: Undefined index: contribution_date_relative in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 204 of /crm/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggregate.php).
Notice: Undefined index: contribution_date_low in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 205 of /crm/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggregate.php).
Notice: Undefined index: contribution_date_high in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 206 of /crm/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggregate.php).
Notice: Undefined index: contribution_date_relative in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 204 of /crm/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggregate.php).
Notice: Undefined index: contribution_date_low in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 205 of /crm/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggregate.php).
Notice: Undefined index: contribution_date_high in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 206 of /crm/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggregate.php).


texts:
I wanted to include the tags field in a search profile, so they can be shown in the list of search results. But it is not possible because the option "column in search results" is not available with tags.
When our volunteers work with telephon lists it would be useful to see the tags...


texts:
who can I contact and how can I do to introduce CiviCRM in Italy?
Translating Documentation in Italian?
Thank you.
Marco


texts:
We've been having this issue over at least one major upgrade where certain types of soft-credits just will not save, without leaving any type record in the error logs. Crediting an individual from another individual or organization works, but crediting an org or a household from an individual prevents the contribution from saving at all... if the soft-credit is removed the record will save fine. I took a video of what I mean and put it on YouTube here >> Video of soft-credit not saving

I have recently installed the Automatic Soft-credit extension Auto Soft-Credit Extension and it seems to bypass the issue, but there are many cases where I need to edit a contribution and cannot without deleting the soft-credit. Since we can't track payments toward an org or total household giving without soft-credits this leaves us with a serious issue.

Any ideas would be a great help. I am not a coder, but willing to use phpMyAdmin to look at the database or look into php code issues.

Thanks. We are on CiviCRM 4.6.22 and the latest Drupal 7 on a Debian 8 server with Apache.


texts: For an Authorize.net configuration, will a comma delimited transaction response work?

texts:
We need to change our Authorize.net Direct Response settings to integrate with another system and I wanted to know if I set my Delimited Response to YES and make the Default Field Separator ,(comma) will Civi still be able to read the transaction response?

Thanks!


texts: Manage Groups broken in 4.7.10 (and possible workaround)

texts:
We upgraded civifrom 4.6.2 to 4.7.10 (on WP) everything worked fine except for accessing the manage groups page. When trying to add a contact to an existing group we got the msg “Error one of the parameters is not of type integer”.

Accessing the 'manage groups' page gave the following error

The workaround I found through the frontend was to create a new group and also run a search and create a new smartgroup.  It now seems to work fine (fingers crossed)

EDIT:  it worked for all of 5 minutes, displayed the manage groups page first few clicks opening it and then reverted to the same error message. I have tried clearing my cache - no change. Back to the drawing board.

I have also replicated the error on our test system. (upgraded from 4.6.12 to 4.7.10) works fro 5 minutes and then same error.

In addition when in a contact record and opening the smart group section I get a network error. I move to anywhere else in the record and the network error disappears


texts: What are all these missing CiviCRM CSS and jQuery files?

texts:
I am not sure how to ask this question or what I did to cause it, but I'll give it a shot. There seem to be several CSS files and jquery plugins that are trying to load on my Drupal 7.50 site that are broken links. I can't figure out what they are and why they are trying to load. I have recently upgraded from CiviCRM 4.3.8 to 4.7.15 and wonder if they are left-over remnants of the old version or what. All I know is that they do not exist.

Can I get rid of the safely and if so, how? Thanks!

https://www.example.com/sites/all/modules/civicrm/css/deprecate.css
https://www.example.com/sites/all/modules/civicrm/css/extras.css
https://www.example.com/sites/all/modules/civicrm/css/extras.css?r=nMgDb
https://www.example.com/sites/all/modules/civicrm/js/jquery/jquery.crmasmselect.js?r=nMgDb
https://www.example.com/sites/all/modules/civicrm/js/rest.js?r=nMgDb
https://www.example.com/sites/all/modules/civicrm/packages/jquery/css/jquery.autocomplete.css?r=nMgDb
https://www.example.com/sites/all/modules/civicrm/packages/jquery/css/menu.css?r=nMgDb
https://www.example.com/sites/all/modules/civicrm/packages/jquery/css/token-input-facebook.css?r=nMgDb
https://www.example.com/sites/all/modules/civicrm/packages/jquery/jquery-1.8.3.min.js?r=nMgDb
https://www.example.com/sites/all/modules/civicrm/packages/jquery/jquery-ui-1.9.0/css/smoothness/jquery-ui-1.9.0.custom.min.css?r=nMgDb
https://www.example.com/sites/all/modules/civicrm/packages/jquery/jquery-ui-1.9.0/js/jquery-ui-1.9.0.custom.min.js?r=nMgDb
https://www.example.com/sites/all/modules/civicrm/packages/jquery/plugins/DataTables/media/css/demo_table_jui.css?r=nMgDb
https://www.example.com/sites/all/modules/civicrm/packages/jquery/plugins/jquery.FormNavigate.js?r=nMgDb
https://www.example.com/sites/all/modules/civicrm/packages/jquery/plugins/jquery.autocomplete.js?r=nMgDb
https://www.example.com/sites/all/modules/civicrm/packages/jquery/plugins/jquery.chainedSelects.js?r=nMgDb
https://www.example.com/sites/all/modules/civicrm/packages/jquery/plugins/jquery.jeditable.mini.js?r=nMgDb
https://www.example.com/sites/all/modules/civicrm/packages/jquery/plugins/jquery.menu.pack.js?r=nMgDb
https://www.example.com/sites/all/modules/civicrm/packages/jquery/plugins/jquery.mousewheel.pack.js?r=nMgDb
https://www.example.com/sites/all/modules/civicrm/packages/jquery/plugins/jquery.textarearesizer.js?r=nMgDb
https://www.example.com/sites/all/modules/civicrm/packages/jquery/plugins/jquery.timeentry.pack.js?r=nMgDb
https://www.example.com/sites/all/modules/civicrm/packages/jquery/plugins/jquery.ui.datepicker.validation.pack.js?r=nMgDb
https://www.example.com/sites/all/modules/civicrm/packages/jquery/plugins/jquery.validate.min.js?r=nMgDb

Here's what happens if I visit one of the jquery plugin links directly:

Edit: I compared the css and jquery files from this list with the ones in the master code and they are not part of CiviCRM 4.7.15.


texts: Webform submission redirect to view it come from

texts:
I have a view of player's grading record using custom fields set in civi. It's a table with current grade, previous grade, dates, etc.

I've created a form that allows adding extra rows into that view.

I'm trying to create a redirection URL on the webform that after submission will go back to that view with contact id in it's argument.

Not sure how to do that :-(((

Any help appreciated.


texts: Unsupervised de-duping - potential matches not ordered by weight score descending?

texts:
I've got contacts that share Last Name and Email, and I'm using an unsupervised de-duping rule for online contribution forms and event registrations with the following fields and weights -

Email 10
Last Name 10
First Name 5
Threshold - 20

From testing, it looks like the matching logic is to go for the first qualify match, rather than ordering all qualify matches by 'score' based on matching fields. Am I wrong, or should there be a simple fix to order the weight of each match before deciding which contact to update that would greatly unsupervised matching?

You could then add additional fields with weight values that wouldn't contribute to threshold, but would improve the score of the best matching contact.


texts:
So I'm super close to getting a smarty variable working to place the contribution note in a thank you letter.

I used the API explorer and got this far:

{crmAPI var='result' entity='Note' action='get' sequential=0 entity_table="civicrm_contribution" entity_id=$contribution.contribution_id}
{foreach from=$result.values item=note}
  {$note.note}
{/foreach}

But this prints a list of all contribution notes in the database, it doesn't filter out by the contribution ID. I know that the variable contribution.contribution_id works in the thank you letter as a standalone variable. I also can use the above code and substitute entity_id=1and that does print the note attached to contribution 1.

How can I put a smarty variable inside the smarty variable api call??

(Wordpress 4.3.2 and Civi 4.6.4)


texts: Exporting spouses only exports one side of relationship

texts:
When I export a list of contacts and I include data about their spouse, the spouse data is included for only one of the contacts. Like so:

Name           Spouse Name     City
Sam Smith       Linda Smith     Tulsa
Linda Smith                     Tulsa

I can't find anywhere that indicates this is proper behavior. Is it by design? Bug?


texts: How do I get more than 25 records from the API?

texts:
I'm making a normal api call such as:

$params = array(
  'version' => 3,
  'sequential' => 1,
  'membership_type' => 1
);
$result = civicrm_api('Membership', 'get', $params);

But I only get 25 results back.

How do I get more than that, and how do I ensure I can retrieve all results, if say there was 5,000?


texts:
I was pretty excited to read about CiviCRM until I saw the requirement for one of the big 3 CMS systems. Is is possible to use/build CiviCRM without a CMS? All three of those CMS systems are massive overkill for my current needs (a very small organization with a generated/static website).

If not, can anyone recommend an alternative open source CRM system?

thanks!


texts: How can I get custom file fields in an activity to display correctly?

texts:
I have a Civi implementation that uses a custom activity type in which I have - amongst others - four custom fields of the field type "File".

These custom fields work fine in all but one situation. If I view an activity record of this type the pop-up does not display the fields or the links to the files. If I force the activity view to display in a new browser window/tab then the following warnings get thrown up:

Warning: strtolower() expects parameter 1 to be string, array given in CRM_Core_DAO::getFieldValue() (line 1004 of /data/www/html/sites/all/modules/civicrm/CRM/Core/DAO.php).
Warning: strtolower() expects parameter 1 to be string, array given in CRM_Core_DAO::getFieldValue() (line 1004 of /data/www/html/sites/all/modules/civicrm/CRM/Core/DAO.php).
Warning: strtolower() expects parameter 1 to be string, array given in CRM_Core_DAO::getFieldValue() (line 1004 of /data/www/html/sites/all/modules/civicrm/CRM/Core/DAO.php).
Warning: strtolower() expects parameter 1 to be string, array given in CRM_Core_DAO::getFieldValue() (line 1004 of /data/www/html/sites/all/modules/civicrm/CRM/Core/DAO.php).

My guess being that the four repeated PHP warnings relate to the four custom file fields, and give a clue as to why they aren't getting displayed in the activity view pop-up. The current workaround is to edit the activity record, where the four fields and the links to files are displayed.

It would be really good to fix this. Any pointers most welcome.
Currently using CiviCRM version 4.6.18 on Drupal 7.


texts: How to store emergency contact phones related to a contact without creating new contacts?

texts:
We need to store contact phones for a contact, to have a list of people to phone in case of emergency. For example, we have children contacts and we want to store the phones of their parents and grandparents without having to create a CiviCRM contact for each of these phones.

We expect to do this on phone section but seems it's not possible to do so without pervert the expected functionality of these fields.

There is a way to do this? If not, what would be the best way to make it possible? Through an extension? Adding it to core? I imagine a "Note" field on a phone row next to "Phone, ext. Phone location, Phone type" to allow attaching a comment like "mother's phone".


texts: Is it possible to view map of contacts from front end of the website in Joomla?

texts: I want to display all my contacts/specific group map in front end of Joomla website. is this possible ?


texts:
I want to create an event in CiviCRM: The event takes place on 8.10., 9.10. and 16.10. So this is an event with three sessions (not an repeating single event). The participants can not book a session individually, therefore they should only register once and they pay a single fee for all three sessions. In CiviCRM I can only create an event that starts on 8.10. and lasts until 16.10. (although there will be no session from 10.10. to 15.10.).
I would like the three listed dates to appear separately in the calendar and on the overview page.
For Drupal I found the plugin ”CiviCRM Multiday Event“ which allows you to do that (https://www.drupal.org/project/civicrm_multiday_event). But I’m running CiviCRM 5.25.0 on WordPress 5.4.2.
Does anyone have an idea how I can get there?
Thanks a lot for your help!
Michael


texts: Payment gateway for WordPress and Drupal

texts:
We have to build a payment gateway for CiviCRM in South Africa would like to know what all the modules are that are capable of taking payments?

We CiviContribute and CiviEvents makes use of payment gateways but are there any other modules we need to consider when specking this project out?

For both Drupal and WordPress please.


texts: Updating Custom Data Fieldset Settings via php my admin

texts:
I've got a site where custom data has been created for Particpant records.

And the fieldsets have been made available for all event types.

The site in question relies heavily on segmenting events by type, and some of the participant fieldsets are not applicable/suitable for some event types

However the empty fieldsets are appearing in the confirmation emails for the events they are not appropriate for and causing confusion to end users.

So...My question is...
am I safe updating the values in the civicrm custom group tables for the fields
EXTENDS ENTITY COLIUMN ID
and
EXTENDS ENTITY vALUE
for the relevant data sets

I guess this is the reverse of the question asked here
Can I change settings for a custom field set for participants without losing any data?

Can anyone advise me of any potential pitfalls?


texts:
We use several different payment processors, and I'd like to try to import into Civi not only the completed transactions but also the failed transactions, along with the failure reason. This will help us follow up with these members and track their giving over time.

I was able to import the contributions such that they show "Cancelled" in the Contribution Status field, however the Cancelled/Refunded Date and the Cancellation / Refund Reason fields do not appear on the contribution record. On the contribution tab, the Cancelled contributions I uploaded appear in a black font, rather than the greyed out font for iATS cancellations.

Any thoughts on this? One thing I haven't tried is to import a Cancellation Date along with the Reason - perhaps the two go hand in hand.

Thank you!

Civi 5.7.6 on Drupal 7


texts: civiReport with financial type and line item financial types

texts:
Is there a report that displays both the overarching financial type and the individual line item financial types for contributions?

civiCRM Contribution and paid event pages require a financial type to be set. We often use complex pricing options with price sets with multiple financial types.

I am looking for a report or search that shows both the overarching financial type (from the page) and the individual line items (from the price set). Find Contributions and Contribution Detail report only display the overarching financial type. Bookkeeping transaction report displays only the line item.

Does a report/search exist that displays both?


texts:
When creating an individual record, how do I make the phone number field a mandatory field. I mean, I don't want a record before the phone number is written.

administrator/?option=com_civicrm&task=civicrm/contact/add&ct=Individual&reset=1


texts: Bulk email sent to group of contacts after new contact added to CiviCRM

texts:
We have a couple of sites that offer volunteering directories. External organisations post opportunities and members of the public can view and apply for those opportunities (a massive tangle of webforms and drupal views essentially).

We've been asked for a functionality that if an organisation offers a new opportunity with a given field of activity (eg. buddying/ befriending), and a volunteer has registered with the site expressing an interest in opportunities of that same field of activity then the volunteer(s) get an email notifying them of the new opportunity details.

I was essentially thinking create "field of activity" as a tag list for the opportunity, and a custom data checkbox field for the volunteers. Then create smart groups for volunteers based on the custom data
All contacts, of type volunteer with type of interest "Befriending/Buddying" are added to a Befriending Buddying smart group. When a new opportunity is tagged as Befriending/ Buddying an email goes to the BB smart group.

Had a quick look at configuring a CiviRule, but CiviRules basic settings don't seem to result in Bulk Email Actions

Has anyone configured anything like this in CiviCRM before, or got suggestions of where to start?

Drup 7.69 Civi 5.19.4


texts: Can you use a theme with side bar items with shoreditch?

texts:
I'm experimenting with the latest version of Shoreditch on Drupal and it looks great with a theme like Seven (that has no sidebars).

It seems to work with Bootstrap - which does have side bars. But, the sidebars in bootstrap seem to push everything to far to the right.

Is this a bug? Or is shoreditch designed to take up the whole width of the screen and I should try to use it and have sidebars?


texts:
Drupal: 7.59 CiviCRM 5.3.2
After Upgrading to 5.3.2 my mail temaplates are no longer showing the images (logo signature) I checked the path in the template and they are correct but the generated PDF shows 'image not found'
Also I do not get a editor for the template just the raw HTML

Any suggestions?

Thanks


texts:
Have managed to add custom fields to contacts, and have tried to do the same for cases. The option seems to be there, but they do not show up on the page for creating a new case.

I can add custom fields to activities within cases, but I would like them for the overall case itself.

Is there any extension to achieve this/ is there some setting I am missing?
Thanks.


texts: Custom form input field missing from &$values when hooking into tokenValues

texts:
I am hooking into _buildForm for CRM_Contact_Form_Task_Email to add a hidden input called "order_id" that I will need for some token logic. This part is working great. But when I click Send Email, my _tokenValues hook fires and the &$values array is missing order_id.

Does Civi remove things from the $_POST array before building $values? Is this a bug or by design? I'm currently working around it by setting and getting my own session variables, but that means I have to create a session object in buildForm and again in tokenValues ($this->set() doesn't seem to work within an extension).

This code creates my extra input. I have verified that the input is written in the form when I view source in the browser. But doesn't make it to tokenValues:

function invoicetoken_civicrm_buildForm($formName, &$form) {
  if($formName == 'CRM_Contact_Form_Task_Email') {
        if (CRM_Utils_Request::retrieve('order_id', 'String')) {
           $order_id = CRM_Utils_Request::retrieve('order_id', 'String');
           $form->addElement('hidden','order_id', $order_id);
        }
  }
}

Edit: Based on Lobo's answer, I tried using $form->get(), but something still isn't working:

function invoicetoken_civicrm_buildForm($formName, &$form) {
  //add order_id to our form
  if($formName == 'CRM_Contact_Form_Task_Email') {
    //buildForm runs on get and post. this line re-adds the input during post
    if ($form->get('order_id')) {
        $order_id = $form->get('order_id');
        $form->addElement('hidden','order_id', $order_id);
    }
    //this line adds the input on initial load of the form
    elseif (CRM_Utils_Request::retrieve('order_id', 'String')) {
      $order_id = CRM_Utils_Request::retrieve('order_id', 'String');
        $form->addElement('hidden','order_id', $order_id);
    }
  }
}

No matter what I do, the input doesn't make it over to tokenValues; when I log the $form object, 'order_id' field appears in ['_submitValues']. I have tried $form->set(), $form->setVar, and any other combination I could think of. In the end, the only thing that works is to use a session var.


texts: Webform with Payment and Preview has the sequence wrong

texts:
I am using CiviCRM 5.13.4 on Drupal 7.67.

I have built a Webform that captures Contact Details, a Membership of our organisation, and Payment (using a Contribution) for that Membership.  I have also enabled the 'Preview Page' function of the Webform.
This ends up taking the user through the page that captures personal details, the page that takes the payment, and finally the page that previews and submits the details.  The problem is that if one returns from the preview to change a detail one is asked for a second payment, and if one abandons the transaction on the preview page the payment has still been taken, with no membership recorded.

Surely the preview and confirmation of details should come before the payment?  Is there a way of configuring this, or is it a bug?

With thanks.


texts: REST error message saying request modifies the database, but it doesn't

texts:
We're having our custom dashboard that our members log into rewritten by an outsourced agency. It is being done with Angular and will use REST to call the API.

We have a particular custom API call that is giving them the error "SECURITY: All requests that modify the database must be http POST, not GET." This call does not modify the database. It composes and runs a SELECT query using CRM_Core_DAO::executeQuery.

How does the REST security mechanism determine whether a call modifies the database? If it contains handwritten queries will they just have to use a POST request?


texts: How to get {mailing.viewUrl} & {contact.checksum} to work together?

texts:
So, both tokens work fine when sending mailings..  however, whenever I view the mailing in the browser by using the {mailing.viewUrl} token.. any url I have in the mailing that uses the {contact.checksum} token breaks.

  Instead of a checksum, I get this in the urls.. cs=invalidChecksum

Is there a way to get those tokens to work together.. or is there a way to create another url to view mailings in the browser without loosing the checksums?


texts: User Dashboard and Edit Profile for Organization

texts:
We have set up a User dashboard for individuals, and a profile so individuals can update their address, phone, email, etc. It looks like this:

We would like to set up something similar for an Organization, so permissioned users can see the organization's membership expiration date, and update the contact info for the organization.
I understand that the way to do this is to set a permissioned relationship, so the individual can view and edit the Organization. However, if I click the Organization, it doesn't take me to a user dashboard for the Organization, but a contact view as if an administrator were logged in. Membership information is not visible. The edit function is not a profile with limited fields, but all the fields an administrator could edit (see below photos):

Am I missing something? Is there a way to see a user dashboard for an organization, like there is for an individual? Can I limit the organizational fields that can be edited?
I am using CiviCRM 5.31.0 with WordPress.
Access control:  Subscriber (the user) can:  view my contact, edit my contact, access contact dashboard
Relationship permission:  set to view and update
EDIT pd added image showing what dmaster shows for comparison


texts: Why is my cron run failing following a database move?

texts:
I've got a Civi/Wordpress install. Originally all of the codebase was in a directory called dev. When it was ready to go live I moved everything to a directory called default, and I went through all of the config files and databases to ensure that path references were all updated.
Everything seems to be working fine, apart from the fact that my main cron job is failing. Looking at the error log, this is because when cron.php gets called, something in turn is calling wp-load.php from the dev directory:

`require_once(/home/example/sites/dev/wp-load.php)`

when of course it should be calling /home/example/sites/default/wp-load.php

Clearly I've missed a setting somewhere, but I'm really struggling to identify where this is. Any pointers most welcome.

In terms of a broader learning point, I won't be changing directory names again in a hurry on new projects.


texts: My Subscribe to mailing list only works with logged in users

texts:
I've made a Profile that allows me to add someone to a mailing list from a html snippet.

But only users that are logged into civicrm can finish the form, when you attempt to submit i get this error: "Sorry but we are not able to provide this at the moment.
The requested Profile (gid=13) is disabled OR it is not configured to be used for 'Profile' listings in its Settings OR there is no Profile with that ID OR you do not have permission to access this profile. Please contact the site administrator if you need assistance."

The form asks for;
First name
Last name
Email
Mailing list to be added to.

I have set everything  i think i need to to public page.


texts: CiviCRM Wordpress Migration: Stumped by the Database

texts:
I am attempting to migrate an existing Wordpress CiviCRM installation to a new server, but am having some difficulty with the database part.

The existing installation is Wordpress 3.8.1 and CiviCRM is 4.4.3. The installation on the target server is Wordpress 4.9.1 and CiviCRM 4.7.27.

I used mysqldump to copy the existing database and then transferred to the new server. I used the mysql root login to execute these commands on both servers.

Once I got the database copied to the target installation, it appeared that no database was there when I ran a report in CiviCRM. So I went back to the original wp-config file and noticed there was a different username and password for the original database (not the root one I used to transfer). I then changed the target server's wp-config file to reflect the other password (shown on the old server), but began getting WP login errors, saying the password was incorrect.

I retrieved the old installation's WP password and was able to login (after changing the wp-config file back to root DB credentials. I had to do that before I could bypass a screen that said 'database connection failure'. But anytime I change the new wp-config file to use the same DB username and password as on the old wp-config file, it throws the database connection error.

I figured since it allowed me to transfer the database using the root password, then I could use that in the wp-config file, but I'm not sure if that's right.

Any ideas what might be going on? I feel like I've missed a step or done something incorrectly. Hopefully my situation makes sense. Many thanks to anyone who could point me in the right direction.


texts:
Procedural question... I have a record set of individuals related to various organizations.   The employee/individual info set is handled well, EXCEPT FOR organization name... i can get work phone, work address, work city, work state, work zipcode.  And, in organization, there rightly are no individual information fields.

So, what comes first, chicken or the egg?

Assume it best practice to import organization info first, then the individual info???  As this makes sense.  But, I cannot find answer on how to get the "organization name/Employer" field into the individual recordset so I can then toggle the individual/organization relationship.

Hopefully, I'm missing something simple.

PS  I've imported 100k records for individuals so far, thou no employer/employee relationship.  Now the "vender" database set is coming on, thus another riddle.

thx


texts: Contribution pages look strange on mobile

texts:
We are having problems when viewing our contribution pages on mobile platforms, because of the width of the screen some of the text is shown on top of other text, making it hard to read:

We have the same problem in many other places on our contribution pages

Tested on iOS+Safari and on Android+Chrome

What is the easiest and most future-safe way to fix this problem?

Grateful for help and with kind regards,
Tord


texts: TokenProcessor container is created but functions aren't called on event dispatch

texts:
I'm following the example in the docs. But having figuring out why the registered functions aren't getting called.
Here's my code (well part of it anyway):
function example_civicrm_container($container) {
   $container->addResource(new \Symfony\Component\Config\Resource\FileResource(__FILE__));
   $container->findDefinition('dispatcher')->addMethodCall('addListener',
        ['civi.token.eval', 'evaluate_tokens']
   )
}

function speakcivi_register_tokens(\Civi\Token\Event\TokenRegisterEvent $e) {
   // never get here.
}

Has the dispatcher interface changed? or is there a way to debug the event dispatch?


texts: How can I send a cc: of an Activity assignment e-mail to another user, as an FYI?

texts: When adding new assigned and scheduled (or completed) Activities, I want to be able to send a cc: of the Activity assignment e-mail to another user, to whom the Activity is not assigned, as well as sending the default  e-mail  to the assigned user. Is there a way to do this?


texts:
When running a CRM advanced search. If we try Adv Search>Display results as'Realted contacts' and choose and Rel type. The hit search we get the DB error.

CiviCRM: 5.13.4


texts: Best way to search through multiple postcode regions

texts:
I'm in the UK where the postcode regions are - well not exactly designed for the digital age shall we say? I need to group everyone in our database into 7 regions that fit our organisation's needs but the list of postcodes per region is very diverse.

See below for an example of the postcodes from one of our regions.

I'm about to create smart groups via search builder for postcode regions like below, but I know it's going to have 20+ lines in the search builder.

So, I wondered before I start whether there is a better way of doing this? I don't want complicated smart group criteria slowing down our server, since we already have quite a few. Or would these queries not really be an issue?

I'm on Drupal 7.56 and Civi 4.6.24, and about to upgrade to 4.7. I could use Drupal Rules, Views or possibly Search Sorts if they're likely to yield better results.

Each of our regions have a list of postcodes like follows:

Postcodes beginning with:
S 25, S 35,  S 36,   S 60 – 66, S 70 -75,
LN 7,
DL,
YO,
LS,
DH,
SR,
TS,
HG,
HU,
DN,
WF,
HX,
HD,
BD,
NE 1-13, NE 15 – 47, NE 61 – 64, NE 99
(There’s no NE 14)

Thanks for any thoughts!


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

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

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

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

Thanks,
Rachel


texts:
On 5.6.0

After create a pledge.
If is created a new contribution that change the status of the pledge from "Pending" to "Completed" is not incoming in any hook_civicrm_post or hook_civicrm_pre with objectName equal to "Pledge" or "PledgePayment"

Which is the correct way to update the pledge programmatically?


texts: Syncing Drupal Roles from CiviCRM Smart Groups

texts:
(Drupal 7.52 CiviCRM 4.6.24)

I am trying to make sense of a work-around for keeping Drupal roles in sync with a smart group.

The Smart Group takes into account:

Contact Type in Organisation
Contact SubType
Membership Type of SubType is "Full Member"
Membership Type is New, Current, Grace
Contact with a (custom) Relationship Type of "Associate of:"

When the smart group is created it will only permit Mailing List rather than Access Control (by design, I understand)

So; I want this Smart Group to have permissions for Drupal under a role "Associate"

How do I do this? I understand that CiviGroup Roles Sync does not work with Smart Groups.

The reason I set it up like this is that when organisation memberships lapse or are revoked; I want the Associates to lose access with automation.


texts: Is there a way to set up PCPs without the user having a login?

texts:
As the question suggests we are aiming to use PCPs for an event of ours but would rather not have user logins enabled as we don't need them for anything else. Unfortunately all the text on the PCP set up pages tells users they can change things after and login etc, is there an easy way to change these so the users know when they finish its fixed and they will have to contact us for a change as this seems easier than setting up user account sign up just for this one use?

Alternatively if somebody can give me some quick pointers to set it up so the users can sign up for accounts while creating PCPs I'd be happy with that?

I've already spent a few hours searching on this subject so hope I haven't missed something obvious and I'm not wasting everybody's time, really hope somebody can help and thank you in advance!

Sam


texts:
Does anyone have experience of using CiviCRM with JAWS or other screen reader software for visually impaired users?

An experienced JAWS user tried but could not get to the quick search box or the main menu items.

The topic has been raised a few times over the years, but does not seem to have a good answer yet.  For example:

https://forum.civicrm.org/index.php?topic=18054.0
https://civicrm.org/blog/skessler/moving-towards-accessibility
https://london2014.civicrm.org/sessions/accessibility

(CiviCRM 4.7.14, Drupal 7)


texts: Was there a ContributionType.php file in a earlier version

texts:
Attempting to get the Vanco Payment Processor working with Drupal 7.37 & CiviCRM 4.4.15.

Currently it reports a Fatal error: require_once()
[function.require]: Failed opening required 'CRM/Contribute/DAO/ContributionType.php'(include_path='/home/honduras/www/www/sites/default/files/civicrm/custom/php/:.:/home/honduras/www/www/sites/all/modules/civicrm:/home/honduras/www/www/sites/all/modules/civicrm/packages:.:/usr/local/php53/lib/php') in /home/honduras/www/www/sites/default/files/civicrm/custom/php/CRM/Contribute/BAO/Contribution/Utils.php on line 66

As a new user/developer working with CiviCRM I am unaware of the changes that occurred between version CiviCRM 4.1.x and CiviCRM 4.4.15.

Can someone shed light on the file ContributionType.php?


texts:
CiviCRM: 4.6.5
Wordpress: 4.2.2

I have followed the instructions here: https://forum.civicrm.org/index.php/topic,35850.0.html

All CiviCRM and Wordpress extensions are disabled.

Details:

When going into Contributions/Manage Contributions and trying to view the details of a contribution, I get the civiCRM error:

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

On my google chrome console, I get error:

  Failed to load resource: the server responded with a status of 500 (Internal Server Error)
  GET http://www.lafabriquecoop.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/con…id=405&action=view&context=dashboard&selectedChild=contribute&snippet=json 500 (Internal Server Error)


texts: Warning when importing contacts/activities

texts:
warning pop up note when importing contacts or activities, same warning on the drupal demo site, go to contacts -> import contacts/activities: 'Upload max filesize ('upload_max_filesize') should not exceed Post max size ('post_max_size') as defined in PHP.ini, please check with your system administrator'.

Is this something to worry about or this warning has always been there?


texts: Can't accesss cv from CiviUnitTestCase::createExternalAPI in buildkit environment

texts:
I'm QAing https://github.com/civicrm/civicrm-core/pull/9255 and trying to run a couple of relevant test locally:

~/src/civicrm-buildkit/build/qa/sites/all/modules/civicrm$ tools/scripts/phpunit api_v3_JobProcessMailingTest --filter testConcurrency

I'm getting the following error output from each time the test uses CiviUnitTestCase::createExternalAPI to call the API:

[is_error] => 1
[error_message] => External API returned malformed response.
[trace] => Array
    (
        [code] => 127
        [stdout] =>
        [stderr] => sh: 1: cv: not found

    )

cv api Contact.get works as expected from the same directory.

Any ideas on what to do next to debug? I get why the test wants to do things concurrently, but my eyes start glazing over (only a little!) when I start looking at civicrm/Civi/API/ExternalBatch.php and I'm hoping I might have overlooked something 'obvious'.


texts: Issues with Personal Contribution Pages / Events / Joomla

texts:
I have PCP turned on - the person is able to set one up -
When someone goes to donate they get the error below - I also get the error even when I am logged in as an admin - so I don't think this is a permission issue with the ACL -

Joomla 3.8.5 Civi 4.7.27

Example page http://bit.ly/lzzebra

CiviCRM-001 -   @import url(/administrator/components/com_civicrm/civicrm/css/civicrm.css); @import url(/administrator/components/com_civicrm/civicrm/css/crm-i.css); @import url(/administrator/components/com_civicrm/civicrm/bower_components/font-awesome/css/font-awesome.min.css);    Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred. The page you requested is currently unavailable. Return to home page.    function toggle( element ) { var parent = element.parentNode; var className = parent.className; if ( className == 'crm-accordion-wrapper collapsed crm-fatal-error-details-block') { parent.className = 'crm-accordion-wrapper crm-fatal-error-details-block'; } else { parent.className = 'crm-accordion-wrapper collapsed crm-fatal-error-details-block'; } }


texts:
We have a client who will be recording people who attend theatre productions. These attendances will be recorded as CRM activities (imported in bulk). The client would then like to search for people who have attended x activities (maybe over a set time period). Then group them and contact them.

CiviCRM would be very good at telling us who attended one or more theatre attendance activities. But not mutiple. Considered smart groups, custom searches, search builder, extended reports etc.

We think a custom extension may be needed for this. Any ideas would be appreciated.

Olly


texts: Replace flash-based charts with something that doesn't use flash

texts:
Several core reports (as well as some reports provided via extensions) use the OpenFlashChart library to create nice looking charts via flash.

Unfortunately (or fortunately depending on how you look at it), flash is on the way out. Many browsers disable it by default.

Has anyone worked on a drop-in replacement for Reports that use html5 or javascript or anything but flash? I know about Xavier's CiviVisualize which looks very promising, but it's not clear how to use it in a report to replace the chart functionality provided by OpenFlashCharts.


texts: How do I create multiple records fieldsets for contacts?

texts:
I think this is a simple question, only i can't work out the answer!
How do I create multiple record fieldsets? Your help is much appreciated,

Cheers,

Kate


texts:
Have attempted many times to install 5.35.1 or later 5.36.0 on live Joomla site. Find little info anywhere. Must not be many Joomla installations. Followed instructions explicitly and kept getting php error on file not found which was civicrm.settings.php. Not writing that file to the folders. Removed all files and extracted locally, then FTPed into tmp folder.  Install failed, this time the above mentioned file was written, however got a unknown database error failing to create table:
Cannot execute CREATE TABLE `civicrm_extension` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Local Extension ID', `type` varchar(8) NOT NULL , `full_name` varchar(255) NOT NULL COMMENT 'Fully qualified extension name', `name` varchar(255) COMMENT 'Short name', `label` varchar(255) COMMENT 'Short, printable name', `file` varchar(255) COMMENT 'Primary PHP file', `schema_version` varchar(63) COMMENT 'Revision code of the database schema; the format is module-defined', `is_active` tinyint DEFAULT 1 COMMENT 'Is this extension active?' , PRIMARY KEY (`id`) , UNIQUE INDEX `UI_extension_full_name`( full_name ) , INDEX `UI_extension_name`( name ) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC: DB Error: unknown error

Just about given up this.  Anyone suggest what to do?
Well, I loaded WordPress in a subdirectory and then tried to install Civicrm per the instructions. Everything looked like it was working until it gave a fatal error and stopped with failure to create tables AGAIN. What I get is:
An error of type E_ERROR was caused in line 204 of the file /home1/flscv/public_html/wp/wp-content/plugins/civicrm/civicrm/setup/src/Setup/DbUtil.php. ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC: Specified key was too long; max key length is 767 bytes in /home1/flscv/public_html/wp/wp-content/plugins/civicrm/civicrm
I use HostGator with Mysql 5.6 for this site and think now it is a host issue (what else is new?)  I can create a new db and actually created the subject table with no issue.  The Joomla db was created several years ago and has not presented any problems. The wp db was just created, yet both dbs have the same problem.  My Wamp server is running 5.7.  I am going to contact hostgator support and hopefully learn if I can get this resolved.  May end up going to another host like I have done with other sites due to HostGator issues.
Considered the input in the answer and comments, I have reached the conclusion that at least part of the problem does indeed lie with the MySql configuration settings in HostGator. The version is 5.6 and one of the Innodb settings is set to off and should be on. Talked with HostGator support and they will not make any change to the configuration nor are they considering upgrading the shared server MySql version to 5.7.  Bottom line, I cannot use CiviCRM on this server.  I use another host and checked that one as well and determined that the MySQL version has the same configuration as HostGator.  I have reached out to them to see if they will either make the change and upgrade the version. I am willing to move to another host if I can find one that can meet the CivCRM requirements while keeping costs reasonable. This is for a small non profit organization that has limited funding so working under other constraints as well.


texts: Contact Form 7 WP PLugin Shows Error when Info is submitted in form. The error is not present when Civi CRM is disabled

texts:
We have been using Contact Form 7 (wordpress plugin) on our page for years to take in responses from our listeners during our live radio show. Recently I am troubleshooting an issue involving the plugin and am hoping someone can help shine light on the cause.

WordPress Version:4.8.1
CiviCRM Version:4.7.17

Description of Issue:
The form shows up correctly though it shows the error message below once you submit the info. The submitted info then makes its way to a specified email address which seems to be working correctly. There may be some emails that are not making it through as per some emails from our listeners.

Troubleshoot:
I disabled all plugins and found that our Civi CRM plugin seems to be contributing to the issue. I have checked the base url and all seems defined correctly.

Other Factors: We did recently switch to SSL though all urls seem correct.

Error Message”
“Sorry but we are not able to provide this at the moment.
We can’t load the requested web page. This page requires cookies to be enabled in your browser settings. Please check this setting and enable cookies (if they are not enabled). Then try again. If this error persists, contact the site administrator for assistance.Site Administrators: This error may indicate that users are accessing this page using a domain or URL other than the configured Base URL. Error type: Could not find a valid session key.”

Any suggestions would be appreciated. Thanks!


texts: Export list of all successful civimails?

texts:
I feel I should know this and the answer is going to be obvious. Is there a way to export a list of successful civimails? I need the mailing name and date, and it would help to have the mailing list sizes but this isn't crucial. I don't need the participants' details.
I'm using D6 and the latest Civi.


texts: How to disable "From email address" for unauthorized users?

texts: If we define "From email address" then any user can use any of these addresses to send an email through the CiviCRM. Is there any way to disable the selection of these addresses for specific roles?


texts:
Since the last two updates I am having severe issues with the views integration with Drupal. The views module hasn't changed, but it doesn't seem to work after the 4.74 and 4.76 updates.

When upgrading to 4.74 I lost all the custom fields in the integration and now with the 4.76 I lost even more fields like event names, dates and contact fields.

Does anyone else have this issue and knows how to fix it?


texts: Contribution pages fail after WP upgrade to 5.5

texts:
Our previously smooth running membership sign-up process failed leaving me scratching my head after a WP upgrade to 5.5.
I had made some changes to the form at the same time and was blaming myself for a silly misconfiguration  rather than blaming the upgrade. Reverting to a back up that still had wp at 5.4 has solved the issue for now.
Anybody seen similar, got a solution?
Got this on the WP site health dashboard

An active PHP session was detected.
A PHP session was created by a session_start() function call. This
interferes with REST API and loopback requests. The session should be
closed by session_write_close() before making any HTTP requests.


texts:
I have followed the great instructions on the question  Can I upgrade a drupal 7 + civi site to drupal 8? but I am running into a road block. The first time I loaded Civi it loaded without my database but I fixed the config file and now I can tell from cv that it is loading my database but in the browser I get a 500 error.

I am seeing these two errors in the logs and I have verified there is more than enough memory allocated.

[Tue Jun 09 22:58:19.026852 2020] [php7:error] [pid 20039:tid 140003429107456] [client 73.95.227.117:53058] PHP Fatal error:  Allowed memory size of 1317011456 bytes exhausted (tried to allocate 803225600 bytes) in /var/www/vendor/civicrm/civicrm-core/CRM/Core/Error.php on line 520

[Tue Jun 09 22:58:19.027004 2020] [php7:error] [pid 20039:tid 140003429107456] [client 73.95.227.117:53058] PHP Fatal error:  Allowed memory size of 1317011456 bytes exhausted (tried to allocate 803209216 bytes) in Unknown on line 0

Any help is greatly appreciated.


texts:
We are a small charity using CiviCRM with WordPress.

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

We want to provide some pages for members only.


texts: how to control membership status by using caldera forms

texts:
i am using caldera form processor to handle data from wp to civicrm.
The problem is that I offer the customer to pay by transfer. So I want to put the status of this contact on hold using the Cladera processor.
My question is how can I control the membership status using caldera processor ?


texts:
We have our production site on 4.6, the current LTS.  I'd like to know what the thoughts are on the next version of LTS.  Will it eventually be 4.7?  Approximately when might that switch happen?

If there is a page already sharing this information, apologies, I couldn't find it.


texts: Error in event when there is no charge option

texts:
I have an event setup with two pricing options one for members and the other for non-members. The members price is $0he non-member is charged $35. When someone selects the Member option at no charge the following error comes up:

Payment Error Response:

Error: Could not find payment information

If they select the non-member option the payment block loads and the registration processes fine.

This is CiviCRM 4.7.23 with WordPress 4.8 and Stripe payment processor (ver 4.7.1)


texts: DB Error on contribution form unless signed in

texts:
On one of our contribution forms for users to sign up and pay for a membership, we are getting a DB Error. Here is a screenshot of the contribution form so you can see where they are urged to create an account.

Here is the error log message, where test@example.com is my test user, who submitted a transaction and created an account on the form. I used a fresh email address, just replaced it here:

[info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_uf_match (domain_id , uf_id , uf_name , contact_id ) VALUES ( 1 ,  209115 , 'test@example.com' ,  140637 )  [nativecode=1062 ** Duplicate entry 'test@example.com-1' for key 'UI_uf_name_domain_id']
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_uf_match (domain_id , uf_id , uf_name , contact_id ) VALUES ( 1 ,  209115 , 'test@example.com' ,  140637 )  [nativecode=1062 ** Duplicate entry 'test@example.com-1' for key 'UI_uf_name_domain_id']
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_uf_match (domain_id , uf_id , uf_name , contact_id ) VALUES ( 1 ,  209115 , 'test@example.com' ,  140637 )  [nativecode=1062 ** Duplicate entry 'test@example.com-1' for key 'UI_uf_name_domain_id']"]
)

The transaction came into the CRM as Pending (Incomplete Transaction). I also processed a test donation, a contribution form that doesn't require the user to create an account, and I did not get an error, however, the transaction still came in as Pending (Incomplete Transaction).

I have recently upgraded to CiviCRM 5.9.0 and Drupal 7.63.


texts: Is there a recipe for converting fields to select2?

texts:
Examples ...

Create event - add location - it's hard to find locations with the existing dropdown
Search builder - Contact Tag(s) IN - dropdown gets hard to use with many tags

I'd be happy to supply patches for these but I'm not happy I understand the scope of such a change.

Is there a PR that shows how this should be done? A good example of a field being changed to select2?


texts: Should smart groups be highlighted so users are aware they are smart and so avoid corrupting them?

texts:
One of my users has corrupted most of their smart groups by manually adding & deleting contacts.  Talking to the user, she was not aware of what was a smart group and what was a regular group.  in fact, in normal use there is no visual difference (unless I'm missing something). However, in 'contacts/manage groups' menu option it is clearly displayed but not otherwise.
Clearly indicating that a group is smart would avoid this problem - use a different colour? I have noticed other questions about smart groups that indicate corruption caused by users manually adding contacts.  Do other users think this would be worthwhile?


texts:
Everything was working fine for weeks (civicrm on drupal) then this error on the civicontribute form web page:

  Fatal error: Call to undefined method
  CRM_Core_Payment_Manual::setBackOffice() in
  /var/www/html/missional/donations/sites/all/modules/civicrm/CRM/Core/Payment/Form.php
  on line 67

And these errors on the log in page:

  Notice: Undefined index: user_name in
  CRM_Core_Payment_AuthorizeNet->__construct() (line 56 of
  /var/www/html/missional/donations/sites/all/modules/civicrm/CRM/Core/Payment/AuthorizeNet.php).

  Notice: Undefined index: password in
  CRM_Core_Payment_AuthorizeNet->__construct() (line 57 of
  /var/www/html/missional/donations/sites/all/modules/civicrm/CRM/Core/Payment/AuthorizeNet.php).

Any ideas on how to resolve this?


texts: SOLVED - CiviCRM Cron Configuration on Drupal 7 throws unable to find key error with duplicate root folder in error message

texts:
I tried to find the answer here, in the old forum, and many searches on the Googoracle to avail. Here is my problem

The requested page "/cm_starterkit_moderate-7.x-2.0-beta7/cm_starterkit_moderate-7.x-2.0-beta7/civicrm-cron/passthrough?key=*******(masked)" could not be found.

Obviously, it's not duplicated.  And I wanted to change the directory structure, but ran into problems with that. :/

Any ideas on how to fix this? This seems to only be a problem with the CiviCRM Cron config screen.

I am on Drupal 7.4.3 and CiviCRM 4.7.6.

Thanks Chris!


texts: Why aren't donation receipts being emailed to customer?

texts:
I'm having issues with emails being sent for new donations (membership signups actually).

I've tested each mail server type and I can send bulk emails, and test emails.
I'm using PayPal as my processor and that seems to be working fine.

My contributions are being marked complete, and new contact/memberships are being created. It seems the only problem is the member isn't getting sent a receipt email.

I noticed this q: Online receipt not being send to donors
which sounds similar but I think I've tested that it isn't a paypal problem.

When I tell the system to store the emails in the db, no email is being created, telling me the issue is within CiviCRM.

Any ideas?  Much appreciated.


texts:
We are using Civi 4.7.27 on Wordpress 4.9
When doing exports the state is shown as the full name. We really need to be able to export with the 2 letter state abbreviation.  How can we set it to do this?

Thank you.

*****Added Screenshot***


texts:
I administer a website for a small local charity which has Civicrm 4.7.6 / Joomla 3.6.4 with php 5.6. I am wanting to upgrade all 3 to latest versions. In order to do this i need to create a test copy of my live site. When i do this using akeeba backup, civicrm is trying to access my production site. have seen civicrm documentation on this but it is undated and looks really old (references only Joomla 1.6 & 1.7). Is there a simple up to date step guide to get a working copy of my production site?

thanks
Dave


texts: Is it possible to change Custom Field types?

texts:
I have a custom data set with a number of custom fields set as alphanumeric text fields - it's become clear that some of these would be better as note/text areas.

Because I'm increasing the size of the fields, rather than decreasing them and potentially cutting off existing data, I'm hoping it's possible to change them in the database.

From what I can see, the only tables affected are civicrm_custom_field (where I'd be changing data_type and html_type) and the civicrm_value_custom_data_set (where I'd be changing the relevant field's Type from varchar to text and removing the 255 character limit).

There's only a small amount of data entered using the custom data set, but I'd rather not have to re-enter everything (particularly as it means deleting and recreating the custom fields as well as the data).

Is this possible? Is there anywhere else I need to change the settings? Or is this just generally a horrible idea?


texts:
As per the requirement I'm trying to get the token values of the custom fields like name, date of birth,country, profile pic etc in the civimail .But when the email is sent.The profile picture is not displayed. Since I'm working on matrimonial site. It's mandatory to get the image in the email.Please help me on this. - Yes I want profile picture to be displayed in the email like all other values. I am getting surname,date of birth and Firstname but not profile pic.I am using tokens for custom fields.

Civicrm version- 7.x-4.7.9
I'm using Drupal 7.

The email output is as follows:
Singh
1969-04-04
Puneeth,
<>profile pic is not displayed.

Html Source of email( I am using Mailtrap)

Singh

1969-04-04

Puneeth


texts:
When trying to load an image to a PCP (front-end or back-end), it gives the error:

Could not move custom file to custom upload directory

I see that the image is loaded into /wp-content/uploads/civicrm/custom directory. However, it is not saved to the PCP. Any pointers on what to look at?
/custom is owned by www:data:www:data


texts: Can webform-civicrm cause an Activity of type Email to actually send the email from CiviCRM

texts:
Scenario is users who are not accessing civi but are doing it all via Views and Webforms.

I created a webform

contact 1 is logged in user
contact 2 is 'target'
Activity is of type Email

Outcome I want is that civi actually sends the email.

My testing shows this does not happen. If i 'assign' the ticket to someone else (or eg the Sender) then a 'you have been assigned' does get sent.

Is this meant to not be possible? Or is it a missing feature?

Note: seems like the reverse of this where coleman explains that 'not' sending the email is possible.


texts: How to handle event payments that include contributions

texts:
Sometimes we have situations where someone will pay for an event with a check and add a donation to the amount.
How can I record a contribution and event payment in civi that was made with the same check?

Thanks


texts: Separate membership payment on contribution form with donation

texts:
When creating a contribution page with a membership, which is not a price set, the option to:
"Separate Membership Payment" is shown. This creates a transaction transaction for any donations and memberships on the same sign up form.

A separate membership payment will: "Check this box if you are including both Membership Signup/Renewal AND a Contribution Amount section, AND you want the membership fee to be charged separately from any additional contribution amount."

Unfortunately when using a price set, the donation options do not appear on the forms, and the option to separate payments is removed. It doesn't appear possible to separate a contribution with donations into two separate transactions.

How can I keep using a membership price set, but also enable donations on the same form through separate transactions?


texts: Why are all menu links being transposed to underscore?

texts:
All menu items look like this
http://10.0.1.6/newjoomlasand3x/public_html/administrator/?option=com_civicrm&task=civicrm/admin/menu_reset_1

Instead of this
http://10.0.1.6/newjoomlasand3x/public_html/administrator/?option=com_civicrm&task=civicrm/admin/menu&reset=1

Opening up the Edit for each existing menu item is entered correctly.
Please advise


texts: How do I simplify multiple contributions?

texts:
Our client is association which only has organizational members. There are no individual memberships. However, member organizations have related contacts who require annual recertification. I want a contribution page, which works like an event registration, allowing one individual to register multiple contacts at the same time, but for an annual recertification fee. It's not an event and each contact should receive their annual reminder that certification will expire in a year.

I don't see this option for recurring contributions or memberships. Did I miss something or does someone have a clever solution for our unusual situation?


texts:
Hi we suddenly started getting a </body>\r\n</html>","help_post":"\r\n\r\n\t error in the event info page and payment contribution page during editing.

not sure why this started happening.

Has this happened to anyone else, seems like a js error as i can see a few reds in the console.

Civicrm 5.8.0 and drupal 7.60


texts: Migration error: “The user specified as a definer does not exist”

texts:
I recently moved the site to a new server and changed from a remote to a local MySQL server with different credentials. Most things seem to be working fine, but even though I've flushed caches, editing phone numbers leads to an AJAX "Network Error" message and the following in my logs:

$Fatal Error Details = Array (
  [callback] => Array (
    [0] => CRM_Core_Error
    [1] => handle )
  [code] => -1
  [message] => DB Error: unknown error
  [mode] => 16
  [debug_info] => INSERT INTO civicrm_phone (contact_id , location_type_id , is_primary , is_billing , phone , phone_ext , phone_type_id )
    VALUES ( 200025 , 2 , 1 , 0 , '6464646464' , NULL , 1 )
    [nativecode=1449 ** The user specified as a definer ('OLDUSER'@'%') does not exist]
  [type] => DB_Error
  [user_info] => INSERT INTO civicrm_phone (contact_id , location_type_id , is_primary , is_billing , phone , phone_ext , phone_type_id )
    VALUES ( 200025 , 2 , 1 , 0 , '6464646464' , NULL , 1 )
    [nativecode=1449 ** The user specified as a definer ('OLDUSER'@'%') does not exist]
  [to_string] => [db_error: message="DB Error: unknown error"
    code=-1
    mode=callback
    callback=CRM_Core_Error::handle prefix=""
    info="INSERT INTO civicrm_phone (contact_id , location_type_id , is_primary , is_billing , phone , phone_ext , phone_type_id ) VALUES ( 200025 , 2 , 1 , 0 , '6464646464' , NULL , 1 ) [nativecode=1449 ** The user specified as a definer ('OLDUSER'@'%') does not exist]"]
)

OLDUSER is nowhere in my configs and I have run both drush cc all and drush cvapi system.flush. Any ideas?


texts: Authorize.net - Customer ID (working with CIM)

texts:
We are changing to authorize.net as payment processor.  Everything is working fine. We have the Customer Information Manager (CIM) in  Authorize.net turned on.  When we do a recurring billing Civi creates a  customer record in authorize.net and adds the CiviCRM Internal Contact ID as the authorize.net Customer ID.  However, on standard transactions Civi does not seem to interact with the authorize.net CIM.

Can Civi work with the authorize.net CIM for standard transactions and pass the customer ID?

We are on Civi 4.6 but will upgrade to 4.7 within 2 months. On Drupal 7.


texts: What order are CiviMail emails sent from CiviCRM?

texts:
Is there a clear pattern to the order in which emails are sent from CiviMail queues? For example, emails are sent from the queue

in no specific order
sorted alphabetically, A-Z
sorted by contact ID ascending
...

Wondering after seeing this question.


texts: Where is the "Allow Other Amounts?" option?

texts:
If you see the screen shot, from CiviCRM 4.7.22 on Wordpress, isn't there supposed to be an "Allow Other Amounts?" option to check under the "Recurring Donations" option?   According to these instructions, there is supposed to be.

https://wiki.civicrm.org/confluence/display/CRMDOC/Contribution+Amounts

  Check the Allow Other Amounts? box to allow donors to enter custom amounts for their donation. This will add a field to your contribution page labeled Other Amount. Selecting this option will allow you to set a minimum and maximum amount that can be donated, if desired.


texts:
I am trying to import 200 activities to contacts and the import shows that all records are imported but if I go to the contact and look at their activities it is not shown.

Any help is appreciated.

Thanks,
Steve


texts: How do I display the Contact ID on User Dashboard?

texts:
MAYYYBE I am over complicating this, but I have searched and searched and only found this answered for Drupal.

We are on Wordpress and would like for members to provide me with a searchable unique id. Obviously, that means the Contact ID would be best. I am just struggling with an easy way to integrate this SINGLE piece of info into the user dashboard.

I really just want it to say something like: Your Contact ID is: ### at the top of the dashboard so people aren't freaked out by looking for it.


texts: Reason for no Views Relationship from CiviCRM Contact to Event Participant

texts:
I am trying to write a Drupal View (with VBO) to show CiviCRM Contacts with the Event Participant records which they are related to.  But there is no suitable Relationship in the standard list.  I have enabled both Contact and Participant (and Event) entities in Civicrm_Entity, and would presume that this is where the Relationship would be generated as well.
I can use the hook_views_data_alter() to create the Relationship, so there is no fundamental reason why it should not work.
Is there a reason why Civicrm_Entity does not provide this, or is it a bug?


texts:
We recently had a donor give a one time gift that they intended to be a recurring gift. Hard to say if they neglected to click the box or if they did and something went awry. Regardless, what we are trying to correct now is that they would like the gift to occur monthly. Can I do something in the UI or in the database to turn this one time gift into a recurring gift, or is it best just to have the donor try again next month?  Thanks!

Drupal 7, Civi 4.6 LTS, iATS payment processing


texts: Hook postProcess doesn't work with message templates form

texts:
I'm trying to add a couple of fields to the message templates ("CRM_Admin_Form_MessageTemplates") in a custom extension. I use the "buildForm", "validateForm" and the "postProcess" hooks. The "buildForm" and the "validateForm" hooks works perfectly but the "postProcess" hook does nothing.
I'm using civicrm 5.27.4 and drupal 7.72.
I tried it also on a other installation but same results. I also tried it with a other clean custom extension but that also doesn't work. And the same hook works on other forms.
Can someone help me?


texts: Adding Custom Data Set - get multiple Data Sets on Summary Display page

texts:
I just added a new custom data set (Monitoring Change) inline so it appears on the summary page of our database for each of our customer's details. However, I also moved some old fields from another data set into this new set. Now the summary page is diplaying a whole Monitoring Change data set for each completed field (the old data fields moved to it), in the summary page.

I can't figure out how to change this so there is only one Monitoring Change data set per customer details on the summary page, with both old and new fields together?

Please help!

Thank you.


texts: Why is my membership contribution page not generating a contribution or transaction?

texts: Using CiviCRM 4.6.31 with Drupal 7, I have a contribution page that uses membership price sets, and for one of the options, no contribution or membership is created, no credit card transaction occurs, and yet a receipt is generated and no error appears for the visitor who fills out the form with their credit card.


texts: Enabling 'New Organisation' button for Current Employer field in View Contact

texts:
We recently upgraded to CiviCRM 4.7.19 on Drupal 7.52 and for some reason the New Organization button isn't appearing when searching for an unknown organization for a contact's current employer. I can add an organization via CiviCRM > Contacts > New Organisation but our backoffice staff liked being able to add from the person contact page. I've checked the console and there are no errors flagged and isn't a CSS thing as the element holding the button exists but just doesn't have the button markup e.g. instead of:

  New Organization

the page only has:

I've checked permissions and as far as I can tell everything is set ok. Is there a setting I'm missing?

Update

Looking at our l10n-js file I can see that the contactCreate object is not being populated:

CRM.config.entityRef = $.extend({}, {"contactCreate":[]...

Digging into the code I can see this is supposed to be created in Core/Resources.php (line 685):

'contactCreate' => CRM_Core_BAO_UFGroup::getCreateLinks()

Looking at CRM/Core/BAO/UFGroup.php I can see the getCreateLinks() function calls

public static function getCreateLinks($profiles = '', $appendProfiles = array()) {
    // Default to contact profiles
    if (!$profiles) {
      $profiles = array('new_individual', 'new_organization', 'new_household');
    }
    $profiles = (array) $profiles;
    $toGet = array_merge($profiles, (array) $appendProfiles);
    $retrieved = civicrm_api3('uf_group', 'get', array(
      'name' => array('IN' => $toGet),
      'is_active' => 1,
    ));

Running a similar API call on our install:

$result = civicrm_api3('UFGroup', 'get', array(
  'sequential' => 1,
  'name' => array('IN' => array("new_individual", "new_organization")),
));

I get no results, the reason is because the name is actually new_organization_5 not new_organization Still don't know how to fix


texts: Trying to install CiviCRM 4.7.6 under Wordpress get you do not have sufficient permissions to access this site

texts:
This is a re-install. I was unable to upgrade a previous version but it had not been used so I deleted all the CiviCRM tables.

I then deleted the civicrm directory under plugins and in the wp root so theoretically, there should be no remnants of civicrm.

I then unzip the .zip file into the plugins directory.

After that, I activate CiviCRM in Wordpress. The first clue that something is wrong is that I get an Initialization Error with messages that say that the table civicrm_settings does not exist. Of course, it shouldn't exist because this is a new installation.

I then tried to run http:///wp-admin/options-general.php?page=civicrm-install with my site and got the error You do not have sufficient permissions to access this site.

The CiviCRM plugin is activated, as I said above.

Is there something else I must clean up before I can install it?


texts: How does CiviCRM handle multiple users editing the same record simultaneously?

texts: I'm assuming that the record is locked so that only one user - presumably the first - can edit, whilst others are locked out until the record has been saved. But I don't know, and a client has just raised the issue, so I'd like to provide a definitive answer.


texts:
I'm just getting started with CiviCRM and trying to install on our WordPress site.

I completed the initial install once, but accidentally used the existing WordPress database - I would prefer to install on separate database.

So I have deleted the plugin, via WPadmin.  Removed CiviCRM tables from the database using the drop sql file.  Uploaded the CiviCRM files to server again and tried to activate the plugin.

The plugin is activated, but clicking the CiviCRM button in the lhs menu gives me error message below.  Seems like CiviCRM is looking to the old install in the WordPress database?

How to correct this please and reinstall in separate db?

Initialization Error

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

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id
FROM civicrm_setting
WHERE (domain_id = 1) AND (is_domain = 1)
 [nativecode=1146 ** Table 'huWP_db.civicrm_setting' doesn't exist]


texts:
I'm on a shared hosting solution that I just moved over to. After the move, I did an upgrade to the newest CiviCRM version but left WordPress intact (no upgrade). Scheduled cron jobs were working fine on the previous host server, but not anymore.

Current configuration:
PHP: 7.2.13
CiviCRM: 5.8.2
WordPress 4.9.9

I updated the wget command I was using to capture the results in logs. In CPanel, the job looks like this:
wget -O /home/xxx/public_html/cron_output.log -t 1 -a /home/xxx/public_html/cron.log 'https://xxx/wp-content/plugins/civicrm/civicrm/bin/cron.php?name=xxx&pass=xxx&key=xxx'

I know the syntax of the command is right because I can run the https: command from a web browser and everything works.

The cron.log shows that it's run with the 200 OK response. The cron_output.log is empty (should it be?).

--2019-01-02 12:50:01--  https://xxx/wp-content/plugins/civicrm/civicrm/bin/cron.php?name=xxx&pass=xxx&key=xxx
Resolving xxx (xxx)... x.x.x.x
Connecting to xxx (xxx)|x.x.x.x|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 0 [text/html]
Saving to: ‘/home/xxx/public_html/cron_output.log’

The server logs that my hosting provider sent me show that the jobs run.

I've also scheduled the same job in easycron and it shows that's it's run successfully.

So I know that cron is running and the syntax is right. But the scheduled jobs in Civicrm don't run. There's nothing in any error_log anywhere that indicates there's a php problem. I've looked at the questions here, and checked that PHP and the MySQL database are on the same timezone, and they are.

I cannot figure out why Civicrm is not running the scheduled jobs. I've tested with a scheduled mailing that sits there and never gets delivered (until you run the https:// command line manually, then it completes). Also the Administer -> System Settings -> Scheduled Jobs show that they are not being completed unless the cron job is manually triggered. And Civicrm has the orange System Status: Warning: Cron Not Running

I'm stumped, and my provider says the issue is not with the server, and I tend to agree.

Any thoughts as to next steps?


texts: How do I allow custom date field over 10 years ago?

texts:
Civi 4.7.3 and Wordpress 4.4.2

Since upgrade from 4.7 to 4.7.3 I cannot seem to add a custom date field and allow the user to select a date older than 10 years ago. Recreated on Demo site:
 Click here to view demo field.

I set the options to allow 90 years before previous date,  but still I only get last 10 years in the list from the calendar.

Shall I raise this on Jira?


texts: Error: Sorry but we are not able to provide this at the moment

texts:
We are using CiviCRM 4.6.9, and Drupal (where do I find version #??)

Suddenly a few days ago the following message began appearing:

The screenshot is from my dashboard; the message also appears when attempting to view or edit most contact records.  Most but not all, and I haven't found any pattern.

As far as I know, we have not recently updated Drupal or Civi.

Why are we suddenly getting this message?  What can I do?

More information: the problem has gone away all by itself, so I still don't know what really happened.  And that's OK by me for now.

Thanks for the helpful answers - I found the file with backtrace, and also found where to turn debugging & backtrace on and off for next time.  So a helpful learning experience.


texts: Is CiviCRM a good choice for a website front end AND membership management?

texts:
We are looking for a CMS (or similar) for our Big Band.  We need

A page for the public to see our next gigs
Membership management to keep a list of band members, deputies;
An events calendar diary for rehearsals and gigs;
A file store so that PDFs of our set lists,  music charts etc can be stored and available for all band members;

It's clear to me that CiviCRM would be fine for 2 & 3, but not so clear that it will also cover items 1 & 4.

Any thoughts/help appreciated.
Pete


texts: Civivolunteer - Can't upgrade or install

texts:
I'm running CiviCRM 5.5.3 on Drupal 7.59. I installed CiviVolunteer a long time ago, but had disabled it, because no one wanted to use it at the time. Now, there is interest in using it. So, I attempted to upgrade it to 4.7.31-2.3.1 and re-enable it and this failed. I Searched for solutions and found information here: CiviVolunteer install fails. I followed the suggestions there and still had no luck getting it to install.

One error I got was:
"Field: name must be unique. An conflicting entity already exists - id: 93"

I removed the duplicate entry for skill_level in civicrm_option_group in the DB, followed instructions found at the link above once more and tried to install again and got new errors.

After hours and hours of frustration, I finally decided to install CiviVolunteer into a bare bones drupal/CiviCRM setup on my computer and to go through each DB table to see what tables were created or had data added to them for CiviVolunteer. From doing this, I was finally able to clear out all the old CiviVolunteer data in the production DB and get CiviVoluteer to install.

I decided to provide a list of what tables are affected/added by this extension, so that other sufferers can clean up old DB data/tables and get CiviVolunteer to install or update or can check if their install was complete.

Tables added:

 *civicrm_value_civivolunteer_1* (or some number besides 1),
*civicrm_value_volunteer_com_3* (or some number besides 3),     *civicrm_value_volunteer_inf_2* (or some number besides 2),     *civicrm_volunteer_need,*
*civicrm_volunteer_project,*      *civicrm_volunteer_project_contact*

Note: All these tables should have no data in them in a fresh install.

Tables altered:

civicrm_custom_field
adds 6 entries (names = Volunteer_Need_Id, Volunteer_Role_Id, Time_Scheduled_Minutes, Time_Completed_Minutes, camera_skill_level, volunteer_project_id)

civicrm_custom_group
adds 3 entries (names = CiviVolunteer, Volunteer_Information, volunteer_commendation)

civicrm_msg_template
adds 1 entry (msg_title = Volunteer - Registration (on-line))

civicrm_navigation
adds 1 entry (label = New Volunteer)

civicrm_option_group
adds 4 entries (name = msg_tpl_workflow_volunteer, volunteer_project_relationship, skill_level, volunteer_role) Note: "skill_level" is the entry that caused the "field must be unique" error. It is apparently not removed if you uninstall CiviVolunteer.

civicrm_extension
adds 1 entry for the CiviVolunteer extension.

civicrm_uf_field
adds 8 entries (field_name has 2 entries each for = phone, email, last_name, first_name) Note: uf_group_id of the field_name should match the two id's of the group entries in civicrm_uf_group (below)

civicrm_uf_group
adds 2 entries (group_type = Volunteer,Contact; tittle = Notify Me of Volunteer Opportunities | group_type = Individual,Contact; title = Volunteer Sign Up)

civicrm_uf_join
adds 2 entries (module = CiviVolunteer, Profile) Note: "Profile" should have an id that follows that of "CiviVolunteer". So if CiviVolunteer has an id of 7, then "Profile" will have an id of 8. There are multiple "Profile" entries in this table that don't belong to CiviVolunteer.

Hopefully, I listed everything and that this helps somebody.

Tish


texts: VERP is visible in CiviMail sender address

texts:
When sending out CiviMail mailings, the unique VERP address is listed as the sender address.  As I understand, VERP should be invisible and should instead show the FROM address set in both Administer>CiviMail>From Email Addresses and in Administer>System Settings>Outbound Email.

We have bluehost, and I know that it doesn't support VERP, so instead we have a catch-all bounce email address (via google app using our domain name), and the bounces seem to work just fine, except that the VERP sender address is visible.


texts: How can we change the editor for a contact's notes to an HTML editor instead of a standard textbox?


texts:
If I edit the dashboard widgets and save, it only lasts for the current session. Next time I log in it's the same set up as the default when I upgraded to CIVI 4.7 - i.e. Getting Started, CIVI CRM News, etc.
(Joomla 3.5.1)


texts: How to print variable/debug data from your extension.php?

texts:
I am trying to add a menu entry in the navigation, but this is causing the navigation menu to disappear, I am trying to debug the code but could not find any particular file.

I have checked the following:

Browser's Javascript Console
CiviCRM logs from ConfigAndLog folder
Apache2 log

Is there anything else I should check? Is there any way I can print the data in the extension_civicrm_navigationMenu(&$params) function?


texts: can't access to joomla administrator panel

texts: after reinstalling civicrm on joomla, I can't access the administrator panel because "Fatal DB error, exiting, seems like your schema does not have civicrm_setting table" - any idea? solutions? thank you...


texts: Webform Select List using Existing Contact

texts:
I have used "Existing Contact" Field in the Webform.
I want to list few contacts using select box instead of AutoComplete using Filter.
Edit Field show different Widget to show the contacts, one of theme is 'Select List'.
Once you save the 'Select List' Display format, front end form does not display/generate select element and its options.

I am using Laster Webform CiviCRM module under Drupal 8.
Anybody have idea of this, I tried same thing D7, its not working there too.


texts: Why does CRM.url give different results in WordPress and Drupal?

texts:
I'm trying to understand why the JavaScript function CRM.url gives different results depending on CMS. Can anyone explain?
For example this code:
CRM.url('civicrm/payment/ipn/test', null, 'front')

In WordPress it returns the complete URL with the domain:
http://wpmaster.localhost:7979/civicrm/civicrm/payment/ipn/test/
Whereas in Drupal in returns the URL without the domain:
/civicrm/payment/ipn/test
This inconsistency feels wrong. Is it a bug in CiviCRM?
For context I'm looking at this issue: https://github.com/artfulrobot/uk.artfulrobot.civicrm.gocardless/issues/97


texts:
Does anyone have image editing enabled in Mosaico through TinyMCE?
I assume it is possible through Mosaico Toolbar Configurator.
Additionally, what would be truly wonderful is if there was a way to crop images within Mosaico to a specific aspect ratio. One big problem we have is users who are unable or unwilling to crop images on their computer, especially to a specified aspect ratio. If there were some way to make this possible in Mosaico, that would save a lot of headache.
As far as I can tell, this isn't possible in TinyMCE image editor. In MoxieManager for TinyMCE, it is in theory possible to specify the width of an image and then crop to a specific height, but that relies on either carefully selecting exactly the height you want or entering it (which doesn't allow you to select the image area to crop to).


texts:
(This post is following a previous question I asked and is related to ErikH's answer: https://civicrm.stackexchange.com/a/31142/6991)

Context: I want to send per email an attached amended certificate (document ID #73). I tried the API explorer v3 and for one test user (id #54) it worked fine. Why an attached .pdf? Because it's an insurance certificate and it's important for each one of the 4000 members to have it personalized, that they can't modify it because of a legal issue and that they can print it easily. Once the membership is manually approved (it will always stay this way, again for legal issues), I want the team of volunteers to have the simple option to send it.

I have 2 questions that are related to each other. I read the documentation but as far as I am not so familiar to code, I don't know exactly what to do.

Question #1: is it possible to include some code in an existing template with general purpose within Civicrm? and which code? (and of course how?...)

PHP?

    $result = civicrm_api3('Pdf', 'create', [
  'contact_id' => 54,
  'template_id' => 73,
]);

or JavaScript

    CRM.api3('Pdf', 'create', {
  "contact_id": 54,
  "template_id": 73
}).then(function(result) {
  // do something with result
}, function(error) {
  // oops
});

Question #2: for this action, the API needs a contact ID and it's obvious it makes no sense to set it this way. Is there awy to use some fuzion fields instead like the civitoken {user.id}? I tried this way and the API explorer returns an error message. Is it possible or not?
Thanks for any help.


texts:
Can you help me please!
How to remove the e-mail to which the registration notification comes? When someone is sign upped, im getting an email, that "A new user with the username "randomname" has registered...
Thanks!


texts: What are my options for importing recurring contributions?

texts:
Our organization is currently transitioning into CiviCRM. We have some existing recurring contributions (with Paypal Standard) that are ongoing and we would like to import them into Civi. Why do we want to import them? Well, here is my current understanding of the situation:

When the monthly contribution amount is charged from the donor's card by Paypal, an IPN with the payment data is sent to our server. Civi processes the IPN and tries to relate it to an existing recurring contribution. If it finds the related recurring contribution, it creates a new single contribution record for the payment made. If it doesn't find a related recurring contribution, it gives an error.

So this is why we need to import (or somehow recreate) the recurring contributions. What are our options for that? I saw this wiki page, however in the Contributions tab inside a contact I can't find a "Submit Credit Card Contribution" button.


texts: Membership Expiry Date not advancing after membership payments

texts:
I have a page where the membership payment and different contribution amounts are displayed through a price set to collect member dues for one month.

I was using civicrm 4.0.5 previously and now I am using civicrm 4.7.17

Everything worked perfectly fine on civicrm 4.0.5.

However, in civicrm 4.7.17, after the payments are made the Membership expiry dates do not advance.

So I wrote my own code to advance the membership expiry date to the last day of the next month. Here is the code:

//get the membership dates for the cid
  $membership_get_params = array(
    'version' => 3,
    //specify the membership type id
    'membership_type_id' => $membership_type_id,
    'contact_id' => $objectRef->contact_id,
    'filters' => array(
      'is_current' => 1,
    ),
  );
  require_once 'api/api.php';
  $membership_get_result = civicrm_api( 'membership','get',$membership_get_params);
  $membership_get_result = $membership_get_result['values'][$membership_get_result['id']];

  // Find date of next month
  $end_date = $membership_get_result['end_date'];
  $end_date_array = explode('-', $end_date);
  $year = $end_date_array[0];
  $month = $end_date_array[1];
  $day = $end_date_array[2];
  if (in_array($objectRef->contribution_page_id, $one_month_contribution_page_ids)) {
    $next_month = $month + 1;
  }

  if ($next_month > 12) {
    $year = $year + 1;
    $next_month = $next_month - 12;// Get next month if payment for member dues goes beyond the current year
  }
  $date = $year . '-' . $next_month . '-1';
  $next_month_end_date = new DateTime($date);
  $next_month_end_date = $next_month_end_date->format( 'Y-m-t' );

  $excludeIsAdmin = false;

  $calcStatus = CRM_Member_BAO_MembershipStatus::getMembershipStatusByDate( $membership_get_result['start_date'], $membership_get_result['end_date'], $membership_get_resul\

t['join_date'], 'today', $excludeIsAdmin );

  // Save expiry date for membership for contact
  $membership_create_params = array(
    'id' => $membership_get_result['id'],
    'contact_id' => $objectRef->contact_id,
    'membership_type_id' => $membership_type_id,
    'start_date' => $membership_get_result['start_date'],
    'join_date' => $membership_get_result['join_date'],
    'end_date' => $next_month_end_date,
    'status_id' => $calcStatus['id'],
    'version' => 3,
  );

  Logger::debug_var("membership_create_params", $membership_create_params);

  require_once 'api/api.php';
  $result = civicrm_api( 'membership', 'create', $membership_create_params );

Is this the optimal solution??

If not, please suggest.

Thanks in advance.


texts: Any elegant way to 'override' a No Bulk Mail setting for a single mailing?

texts: One of our client organizations is sending newsletters to their 4000 members on a regular basis; about 400 of them are not interested in bulk mail and have the No Bulk Mail switch set to On. Once a year though there is a statutory meeting that requires that an invitation is sent to all members, overriding the NoBulkMail setting. So far I've only found awkward ways to arrange for this (moving the members involved into a dedicated group, removing the switch, sending the mail, moving switch back on). Any ideas on how to solve this more elegantly?


texts: This question will hopefully help people find their way to the big picture stuff.


texts:
I'm using Joomla 3.4.1 and CiviCRM 4.6.2.

When I click on Mailings > New Mailing, it's as if the component only partially loads. I have a menu bar with Search, Contacts, and Contributions; no other menu options. Below, I simply have the print icon and the version footer.

Is there a way to reinstall just the CiviMail component? I'm not an advanced user, so I don't even know where to start in trying to find out what's going on.


texts: CiviVolunteer fail: extension resource url is not configured correctly

texts:
I am working on Joomla 3.6.5
CiviCRM 4.7.14

I just did a fresh install of CiviVolunteer 4.6-2.2.1

The install seems to have worked (no errors reported). But when I try to use this feature by going to

Events>Manage Events>Configure>Volunteer

I get this error:

"Your extension resource url is not configured correctly. CiviVolunteer cannot work without this setting.
Correct the problem at Settings - Resource URLs."

So I go to Settings - Resource URLs, and this is my setting for custom extensions > Extension Resource URL:

/public_html/media/civicrm/custom_ext/

It matches what I have under Settings - Upload Directories > Extensions Directory:

/public_html/media/civicrm/custom_ext/

I have other extensions installed and working properly from the same directory, such as SparkPost, Public Autocomplete, etc.

So I suspect this is an .htaccess issue.  I checked with my host, and they say the file

/public_html/media/civicrm/.htaccess

is blocking access:  The .htaccess file reads:

<Files "*">
  Order allow,deny
  Deny from all
</Files>

My host says this file is being generated by CiviCRM, not by them.  My other CiviCRM extensions are working fine.  So what am I missing?  Do I modify the .htaccess file?  Or would that create a security nightmare?  Or is this an issue that doesn't involve .htaccess at all?


texts: I'm having new trouble with CiviCRM in multisites in Wordpress

texts:
tldr; I'm after a Wordpress multisite setup that uses the same CiviCRM data for all the subsites. Each subsite can then show the relevant data, and users for each subsite can be given the appropriate permissions.

I've had this working previously, but now, using CiviCRM 5.2.2 it's refusing to work.

Previously (around Civi 4.6 ish) I did a multisite install of Civi.

All I did (IIRC) was install to the root site, then set it up.

When I went to the sub-sites, it showed me the CiviCRM information in the same way that it had it on the root site.

Everything was installed and working. I could see people and information about them.

I've just been trying to set up the same thing again, but this time I'm using CiviCRM 5.2.2

Now I successfully install CiviCRM in the main site.

But when I go to the sub sites, it has CiviCRM showing as needing installing. And when I try clicking the button it gives an error of:

Oops! CiviCRM is already installed
CiviCRM has already been installed.
To start over, you must delete or rename the existing CiviCRM settings file - civicrm.settings.php - from /wp-content/plugins/civicrm.

But civicrm.settings.php does not exist there.

It exists in /wp-content/uploads/civicrm

So the error message appears to be wrong as a first problem.

In the previous install that did work, it created a set of directories in:

/wp-content/uploads/sites/3/civicrm

And the civicrm.settings.php file was in there.

It has not done that in this case.

I'm very confused about what's going on.

Is this a major change between 4.x and 5.x that hasn't been documented?

Or something?

Things I've done
I've deleted the civicrm installation canary table from the the database.

I've added the lines to the civicrm settings file as per:
https://docs.civicrm.org/sysadmin/en/latest/install/multi-site/

But it still refuses to let me get into CiviCRM on the subsites.

Thanks for any insight.

Norman


texts: How do you restrict a CiviContribute page using roles

texts:
I have a CiviContribute page which was intended to only be accessed by people renewing a specific type of membership.

We have found though, that it appears on a Google search and indeed a completely random person has signed up for the membership.

I have a Drupal Role for this membership type and also have a Group which we use as a mailing list; so would it be better to build it into a webform controlled by Access Control?


texts: How to tell which .extra.tpl files CiviCRM is trying (and failing) to load?

texts: I was writing an extension which injects a template snippet, and was working fine.  While working on the PHP, without any change to the snippet, it's no longer loading (the rest of the extension IS working).  The template is at <extensionname>/templates/Contact/Form/Contact.extra.tpl (NOT in a "custom templates" folder - though if I move it there, it works).  I realize I have absolutely no idea how to check which file locations CiviCRM is checking for its template files, is there a way to see?


texts: Error message "Profile search, view and edit are not supported for Profiles..."

texts:
I am using civicrm 4.7 on Joomla and I'm trying to expose a profile through the joomla menu system but I am getting this error message:

"Profile search, view and edit are not supported for Profiles which include fields for more than one record type."

I am trying to provide my staff with the option to see participant detail by selecting the profile from the Joomla menu. I've attached screen shots of my settings. As far as I know all the data attached to the participant record type. Is this correct?


texts: Using CiviMember to automatically create a Drupal user

texts:
I am relatively new to Drupal (I using version 7) and CiviCRM.  I have set up a website in which members will be entered manually, rather than using an online signup form.

I am envisaging the workflow to be:

Admin user logs on to Drupal website and goes to CiviCRM
They create a Membership for a Household
For each member of that Household, they create a related Contact

At this point, I want a new Drupal user to be created for each Contact, so that they can log in to certain restricted parts of the website.

All the documentation I have seen so far shows it working the other way around - creating a Drupal user causes the creation of a CiviCRM contact.

So, is what I am asking to do possible and does it make sense in the Drupal/CiviCRM context.

Thanks,

Carl


texts: Mailing - "Send Test" button not a button

texts:
When trying to send a test mailing, the preview and test email box appears to be improperly drawn and the "Send Test" button doesn't appear to work.
I tried upgrading CiviCRM (from 4.6.2 to 4.6.4) but the problem persists.

CiviCRM 4.6.4, Wordpress 4.2.1, Apache 2.4, PHP 5.6.9-1, Mariadb 10.0, Debian Wheezy/Sid hybrid

I notice this was an issue in the beta forums previously
http://forum.civicrm.org/index.php/topic,33598.msg142461.html#msg142461

Any ideas how to fix it?