texts: Multiple branch/chapter management with various access level of information

texts:
I am newbie to CiviCRM.

I an searching for a solution to manage a multiple branches of an organisation with CiviCRM. Multiple branches will be spread across the glob. All the branches should have different types of users.(i.e. Branch Admin,operator etc..).

These branches required to manage their contacts info, membership details, donation details , subscription details.

All the branches data should be visible to admin of head office and all the branch admin/operator should have permission to access their corresponding branch data only.

I have try to implement a this type of structure in CiviCRM with word press. I found a various post to implement this with CiviCRM ACL but it didn't work for me.

If anyone have idea that how should we implement it. Please share with me.
It will be a great if you mention about a steps to achieve it.
Thanks in advance.


texts:
I am using Civi 4.7.27 on Wordpress 4.9.  Today while trying to compose a new civimail message, I noticed that the recipients field is not automatically finding recipients like it used to.  We recently upgraded to the latest version of both civi and wordpress.  Is anyone else having this problem?  See screen shot for details. I hope someone can tell me what I need to do to resolve it.

Thank you


texts: Network error: Unable to reach the server WordPress/CiviCRM

texts:
Running CiviCRM 5.11 plugin on WordPress. This is a fresh install on DigitalOcean.

In the WordPress Settings>General, there is a place to specify a URL, which I did using the URL for the website as registered in DNS.

When I first installed this, the setting used the IP address of the server, for example http://nnn.nn.nnn.nnn

With this setting, no problems.

After I was sure my DNS was pointing to this IP address and that it had propagated, I changed the setting to use the correct URL.

I can log in to WordPress okay but, when I click on the link to CiviCRM, I get a pop-up that says "Network Error: Unable to reach the server. Please refresh the page in your browser and try again. I do that and have to log in again.

All of the WordPress links are working fine. It only is a problem when I click on CiviCRM.

I changed it back to the IP address and CiviCRM works fine


texts: Print PDF Letter. Image not readable or empty

texts:
When using the "Print PDF letter for Contacts" action, I tried to add an image and when I downloaded the PDF file, in place of the image, said "Image not readable or empty"

I've tried all the solutions listed here: https://stackoverflow.com/questions/25558449/dompdf-image-not-readable-or-empty and nothing.

Thks


texts: CiviCRM events pay later error - Undefined index: event

texts:
I'm getting an error on submitting events where "pay later" is selected as payment method. The page times out - if I select a different payment method the next page loads OK.

This is the error I'm getting

  Notice: Undefined index: event in
  CRM_Core_Payment_ProcessorForm::preProcess() (line 78 of
  xxxxxxxx/sites/all/modules/civicrm/CRM/Core/Payment/ProcessorForm.php).

Has anybody else experienced this?


texts: Generating extension menu when extension is installed

texts: When my extension is installed i want the menu to be generated and added to the CiviCRM main menu as a new tab ie a main menu with subs under it so the user do not have to manualy do that, what is the best way of doing that? can that be done in my extension before given to be installed and tested? If possible, I need some pointers to that solution.


texts: Who's getting the contribution between different levels of relation?

texts:
I (still & again) have a complex webform with individual related to sub-types of organization (more information here) and even though the memberships goes to organization, the individual is getting the contribution but not the concerned organization.

How can I set it so that the organization ("the real member") is also getting both membership and contribution?

Regards,

Guillaume

[EDIT 1]: "Soft Credit To" assigns the contribution to the sub-type contacts but it's a kind of trick and not exactly what I want.


texts:
I have a question regarding membership fees for the following scenario:

Let's say I have a member who joined in January 2018. He payed for 6 months until June 2018. As we are in October now, he is overdue for 4 months. When i try to extend the membership, i click on "renew" button on his overdue membership. I record a new payment and I assumed to extend the membership from the end of the previous membership. Unfortunatly the membership is extended based on "today" and not fromend of June.

Here the screen from the renew form:

Thanks for your help!

Best regards,
Said


texts: How to customize Contact Map popup on clicking on icons?

texts:
I'm trying to remove the street address right now from the Google Map that's created from Search Contact -> Map Contacts when you click on the people icons placed on the map. This is for privacy purposes, but I'm interested in adding some custom contact info there later.

I researched and found the Mapping Providers are at templates/CRM/Contact/Form/Task/Map. When I copied Google.tpl, renamed to GoogleCityOnly.tpl, and edited - it shows up as a selection in the Mapping and Geocoding system menu for Mapping Providers. But when I choose it and search contacts, the "Map Contact" no longer shows up.

What am I missing to have "Map Contact" show up again? Where's the guidance for making an alternate Mapping Provider?


texts: Profile - Organisation Details but add employee/voluntter

texts:
I am creating a profile for Organisations to complete on our website and it seems straighforward. Until it gets to finding how to add employees/volunteers as part of the profile.

How do I get an organisation to enter these details?

Thanks


texts: Should I disable extensions prior to upgrading CiviCRM?

texts:
I couldn't spot anything on this in the upgrade instructions, and as it's something that could affect lots of people, I thought I'd ask the question here.

When upgrading CiviCRM, what is considered best practice regarding extensions? Should they be disabled prior to the upgrade?

If, as a result of upgrading Civi, one or more of my installed extensions is no longer compatible, what's the best procedure to follow? Should I attempt to update/upgrade extensions to a compatible version before or after upgrading CiviCRM?


texts:
Help wanted –
Suddenly, our donation and membership pages are stop working (the credit card fields are gone). Anonymous role cannot make contribution or sign up for membership. When an anonymous user filled out all the required screens, clicked on “review your contribution” and was given this error: Payment Method is a required field.
I am using WordPress 5.5.1, IATS and CiviCRM 5.29.1. I checked the Access Control (Permissions) in WordPress; it shows anonymous role can” Make payments or donations through your (our) website”.
Please help. Thank you.


texts: CiviCase css problem (Joomla version) after upgrade to 4.7.14

texts: There is a problem with css class "label" in CiviCase. This affects the CiviCase dashboard and custom fields in the Case view panel. I think this only affects the Joomla version of CiviCRM 4.7.14.


texts: Why does Stripe 5.2 extension hang on payment?

texts:
After completing the payment screen and clicking 'Confirm Contribution' the screen hangs. The button is greyed out but nothing happens.  But...if I just hit enter on the screen without first completing anything at all I get an error message about incomplete fields, and then I can complete the screen & proceed normally.  But if I first complete all the details and then hit the 'Confirm Contribution' it hangs.  I've tried this on Chrome, Firefox and on my Android 8.1 phone - all the same. I am using 5.2 of the Stripe extension, CiviCRM 5.7.3 running under Drupal.  Using the second technique described above I've made a couple of payments so there's nothing wrong with the setup, it seems.
Update: I have found some errors in the Stripe dashboard, here are screenshots and this


texts: Do I need to sanitize quickform inputs in a extension?

texts: Hopefully this is a quick one. I'm creating a form in an extension. Regular QuickForm - nothing special. Do I need to sanitize the inputs before processing them? Or does Civi/QuickForm handle that?


texts:
Drupal - latest version
CiviCRM - 4.7.13

We have a client that uses PayPal standard with recurring payments that having an issue that I can't figure out.  The recurring payments seem to have quit working since the first of the year.  By quit I mean they are logged but after that nothing seems to happen.  No errors and no record of the payment.  I have used a test setup where I use curl to resend messages to my local environment while in debug mode but it doesn't work (it does work for authorize.net payments).  In this case it seems like the data isn't there when the message is to be processed.

Another interesting thing is that some of the IPNs look like they are resent several times within a few mins.  They have the same transaction ID, etc.

Any help or ideas are very much appreciated.


texts: How to sort civimobile event participant check-in list?

texts:
I will like the have the names of event participants listed alphabetically on the event check-in screen, how can i modify the civimobile extension (civimobile.participant_checkin.html) to list names alphabetically?

I have this code but it doesn't work,

CRM.api('Participant','get', {"sequential": 1,"options":  {"sort":"display_name"},
          'version' :'3', 'sort_name': q, 'event_id': eventId,   'participant_status_id': {1:1,2:2,5:5},
          'return' : 'display_name,participant_status_id', 'rowCount' : 500 },

    {
      success:function (data){
        if (data.count == 0) {
          cmd = null;
        }
        else {


texts: Base table not found for civicrm_contribution_page #201

texts:
On latest version of 8.x-3.x branch i get following error when try to add a view for contribution page

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'civicrmdb.civicrm_contribution_page' doesn't exist: SELECT civicrm_contribution_page.id AS id FROM {civicrm_contribution_page} civicrm_contribution_page LIMIT 11 OFFSET 0; Array ( )

views for Contact, Contribution, Event works fine but not incase of Contribution page, Payment processor, campaign etc.

Can we create list of contribution pages/campaigns/payment processors using  civicrm_entity + civicrm views d8?


texts:
Using CiviCRM 5.0 I can see an overview of my event participants using the Events Dashboard https://your.domain/civicrm/event?reset=1

Some of the numbers displayed here are however incorrect, in particular the counted/not counted numbers. In my installation all participant roles are configured to be counted. However the Events Dashboard generally reports a significant number of participants as "Not Counted Due to Role". If all my roles are set to be counted, then this number should always be zero.

Am I missing something, or is this a bug (and if memory serves a fairly long running one)?

UPDATE: It seems that the participant count setting in price set fields has a bearing here, based on the comments below (thanks @Aidan for flagging this point). I've never paid attention to the count option in a price set field, a) because I've never really understood what it does (the documentation on this is to say the least, thin) and b) because I've been aware that it has any effect, probably because I've never personally made use of the Events Dashboard page.

So it seems to be the case that when using a price set, if you want the Events Dashboard to count your participants accurately, you should take care to set up your price set so that the count options are correctly configured for your price set. As far as I'm aware, if your price set is not correctly configured, it can mess up not only the numbers on your Events Dashboard, but also the count used to determine whether your event is fully booked or not. As far as I can see the docs and the dashboard only refer to participant status and participant role as determinants as to whether a given participant is counted or not, but it looks like the price set config overrides both status and role.


texts: sorting states in state/province dropdown

texts:
Civi 5.11, WordPress 5.1.1

I work with an organization whose Contacts (of all types) are limited to 4 states in the US. (Available States/Provinces in the localization settings includes only the US.) In order to speed up data entry for my organization's users, I'd like those 4 states to appear at the top of the States dropdown when new Contacts are added. However I don't see this capability in the Option Groups settings, and I don't see an Order field in the civicrm_state_province table.

Are my only ways forward to create a custom State field, or develop a custom hook?


texts: Can members pay their dues early? Basically before the system has them as expired.


texts: Error after Installing CiviCRM 4.6.4 on Drupal 6, drupal attempts to reinstall at localhost/drupal

texts: I have recently installed Drupal 6 on WAMP, then I downloaded CiviCRM 4.6.4 for Drupal 6. I followed the installation offered on wiki.civicrm.org and everything went very smoothly. When I attempted to follow the final step of "Return to Drupal and enable the CiviCRM module http:///admin/build/modules. Check the box next to CiviCRM, then scroll to the bottom of the page and click the "Save configuration" button.". I punch in localhost/drupal into my browser and Drupal attempts to install itself again. I pressed "Install Drupal in English" and it timed out and showed me this "Fatal error: Maximum execution time of 120 seconds exceeded in C:\wamp\www\drupal\includes\file.inc on line 1078". Help please!!


texts: Does CiviCRM integrate with 3rd party email account

texts:
I cannot specifically find this information, so therefore the question.
We would like to know if civicrm integrates with say external email accounts so that emails received from constituents into our normal email accounts are automatically recognised and mapped to the constituent record so that emails sent and received can be viewed within the civicrm as part of the constituent activity.
Wayne


texts: Constituent (summary) report: link to contact instead of link to constituent detail?

texts:
When opening the Constituent (summary) report and clicking on a name in the results list, the page which refers to the specific Constituent detail doesn't open.
Reason for that seems to be the number of activities we have in our database.

Wouldn't it make more sense to change the report, so that, when clicking the name of the contact, it links to the specific contact page instead of linking to the Constituent detail report of that person?

We are using CMS Drupal and CiviCRM 4.6.33.


texts:
Has anyone experienced problems with running scheduled reminders under civicrm 4.7.16?  After upgrading to that version on 8th Feb and running scheduled reminders for the next issue on 11th February, I got the following error message in the scheduled jobs log:

"Finished execution of Send Scheduled Reminders with result: Failure, Error message: Error: Cannot use action tokens unless context defines mailingJobId and mailingActionTarget"

Scheduled reminders had been running fine until then so I have to assume that there was no problem until v 4.7.16 was installed.
The action tokens used in the relevant reminder were {contact.first_name}, {membership.type}, {membership.end_date}, a personalised checksum, {domain.address} and {action.optOutUrl}.

I'm not running any civi extensions.

I'm using an up to date version of Wordpress 4.7.2

Any help would be greatly appreciated.


texts: IMAP authentication error with Smartermail

texts:
So, I've spent the last few days running this issue down, and I actually have a solution (or a workaround?), but I just wanted to ask if it's really the best way to handle the situation.

I'm running CiviCRM 5.21.0 on Joomla 3.9.15 and was looking at bounce processing and the Fuzion Transactional Email extension. I was setting up an IMAP account to handle the bounces, but every time I ran the fetch_bounces scheduled job, it would come back with "The IMAP server did not accept the username and/or password". Well, I know the username and password are correct.

Long story short(er), my mail server (I host in-house), Smartermail 14.7, does the same thing that GMail does - instead of an immediate "OK LOGIN completed" response, it gives the "* CAPABILITY" line first.

I couldn't find anywhere in the code where it might dynamically figure out that the server is a gmail server, so I just changed the $serverType on line 331 of /administrator/components/com_civicrm/vendor/zetacomponents/mail/src/transports/imap/imap_transport.php from null to self::SERVER_GIMAP, and now the authentication error is gone.

Is this the best way to do this, or is there a better way? I'm guessing that any time I update CiviCRM, I'm going to have to re-do this change.


texts: There is no option to "Add Contacts To Event" once multiple contacts are selected from a specific event. How do I make this option available?


texts: iATS Charge to Card on File attributed to merged/deleted record

texts:
What happened:
1: Went to recurring series. Clicked "Process" on Card on File
2: Put in the amount, left defaults
3: Charge went to iATS and posted successfully.
4. The charge linked to a formerly merged/deleted record of the same name as the record it was supposed to be processed on, unlinked to the recurring contribution.

What could have caused this?


texts: can't "enable" a disabled event -- the "More" dropdown seems to be hidden behind other events and isn't clickable?

texts:
I'm trying to "enable" a disabled event in CiviEvent but the user interface doesn't let me click the "Enable" item in the "More" dropdown menu. It's like it's grayed out and hidden behind the other elements.

I've tried both Firefox and Chrome and had the same problem in both.


texts: Can you pull the emails collected through a "form" and dump them into a Civi CRM group?

texts: If I create a form that will collect email addresses, can those email addresses be exported or added to a Civi CRM group for later mailings?  I am trying to find a way to collect emails on the front end of our website then add them tour interest group mailing list on the back end without having to manually create a new contact that will then be able to be added to the group.


texts: URLs in CiviMail give a 404 not found error

texts:
CiviCRM 5.14.0.

This is a new installation with WordPress. I sent a test mail. I checked out the unsubscribe link, which resolves to this

That turns out to not be a valid link. I have a feeling there must be a setting somewhere for that.


texts: Deleting a site on WP multisite deletes civicrm uploads folder's contents

texts:
Similar to the behavior of this Upgrading WP to 5.0.1 deletes civicrm uploads folder, I had deactivated then decided to delete a site on our WP multisite. Once I clicked delete I got a fatal error (sorry I did not copy) that referenced line 916 of civicrm.php file. Deactivating CiviCRM plugin got the multisite backup.

require_once 'CRM/Core/ClassLoader.php';
      CRM_Core_ClassLoader::singleton()->register();

Then I saw that the uploads/civicrm folder was empty. It had the /ext /uploads and /template_c folder but they were all empty. The rest were gone.

We restored the directory from backup and now it works. Anyways, this is a word of caution.

Question is, why did this happen?


texts: Invoice generation wkhtmltopdf font missing

texts:
I have a problem generating invoices on CiviCRM-4.6.16 with wkhtmltopdf-0.11.0_rc1 on Drupal (7.43).

In the template I define a font-family

@font-face {
font-family:LiberationSans-Regular;
src:
url(/ABSOLUTE/PATH/TO/fonts/LiberationSans-Regular.ttf);}

In the Body I define a table I want to use the font like this:

      <table style = "padding-right:19px;font-family:LiberationSans-Regular;" width = "500" height = "100" border = "0" cellpadding = "2" cellspacing = "1">

The font is always ignored, except when I use a system/default font (e.g. Courier).

I tried numerous locations on where to put the fonts, since I suspected a permission problem or something like that, but apparently nothing helps and I can't get other fonts in the pdf export.

I verified that wkhtmltopdf is used (via meta data of the pdf).

Help would be appreciated!


texts:
In CiviMail 4.6.10 on Joomla 3.4.5, clicking on Browse Server button opens Kcfinder popup window. Kcfinder is contained in CKeditor insert image toolbar function. No images populate and internal links result in error:

  Firefox doesn't know how to open this address, because one of the
  following protocols (kcact) isn't associated with any program or is
  not allowed in this context.

All major browsers same result. Cleared all browsers and CiviCRM cache to no avail. (The CiviCRM demo is still at 4.6.0 which doesn't have this feature.) See image below:


texts: Stock CiviCRM on Ubuntu package of Wordpress leads to /var/lib/wordpress/var/lib/wordpress/ paths

texts:
I am using CiviCRM on Wordpress on Ubuntu where the Wordpress comes from a deb package, not from the original source. The only real difference that I know of is that Debian/Ubuntu split the Wordpress code into /usr/share/wordpress for the static PHP files, and /var/lib/wordpress for the content files and uploads.

Anyway, probably because of some weird interaction between the Ubuntu package and CiviCRM, I end up with a whole bunch of resources trying to load from a path that starts with https://mydomain.com/var/lib/wordpress and which creates a 404 error in the webserver log when it tries to access /var/lib/wordpress/var/lib/wordpress on my disk. What has obviously happened is that part of the filesystem path has accidentally been embedded into the URL for the resource.

Problem is, I'm not sure where that setting comes from or how to change it. Can anyone verify this, or is it really just me? Should I report this as a bug against the Ubuntu package maybe? Among the resources that have the wrong path are:

/uploads/civicrm/persist/contribute/files/delete-this-WjYpCHVDVl
/uploads/civicrm/persist/contribute/index.php
/plugins/civicrm/civicrm/js/wysiwyg/crm.ckeditor.js


texts: CiviDiscount's entry field is not appearing

texts: I had a discount code set up for our event to facilitate complimentary registrations.  The box that used to appear at the top is no longer there.  Not sure what happened to it.


texts: Has anyone compared the two Sparkpost extension?

texts:
Two Sparkpost extensions for Civimail have been released/updated in the last couple of days.

https://github.com/cividesk/com.cividesk.email.sparkpost

https://github.com/proexchange/com.pesc.sparkpost
Has anyone compared them to see which works best?


texts: Add a membership to a person with an other than default company

texts:
i have a sporting company which does multiple sport departments each whith its own results  there are all part of the mothercompny called flevostar

so example you have Flevostar Basketball and FlevostarDart
i created 3 organisations in my contact list  Flevostar/Dart/Basketball

a new member is also created
on the add membership page i would like to add a membership linking that new person to for instance Dart. Even though it appears that there is a drop down  i can only select default company  in this case Flevostar and a membership type.

ending up with that i have to absue the membership tpe to distinquish them so had to create MemberTypes  ACTMEM DART and AVTMEM Basketball
where as i would have liked to have new member x is member of department(organisation)Dart  whith type Member

is this any how to be achieved?

best regards

leon

ok  maybe i am not clear in my problem description. i use the backend for creating initial relation ships between the member and the department.  example: i have John as contact Basketball as organisation and flevostar as default.  now i go to johns personal sumary and click on memberships (initial they ar counted as 0) and i want to ad a membership.  Memberships tupes are  LID basketball  connected to Basketbal organisation and Lid Flevostar connected to flevostar organisation.  so in the memberships sumary i want to add johns membership to the basketball organisation with type Lid basketball.  However i can not select the organisatiobn Basketball in the drop down hence i can not link Lid basketball type to John  i hope this makes sense now


texts:
When i add a new contribution to a contact, i would like to avoid an empty "Source" field.
I need it to be *required.
Have anyone already done this ?
thanks


texts: "Save contact and add contribution" button in the contact form

texts:
In the contact form, I need to add a new button "Save and add Contribution" that, when pressed:

save the current contact data
redirect to the "New contribution" page, possibly with the contact already selected

How can obtain this?
Thanks


texts: Getting contact address with membership on paypal standard

texts:
How do you get the contact created by the membership contribution screen to return the name and address (like the shipping address...) of the Paypal standard payment...

The transaction goes through properly in the sandbox (ipn ok) but contact created for the new membership has no name or address, just the email...

Thanks..


texts: How to put your CiviCRM Contacts on a Leafleft Map in 5min?

texts:
To summarize: someone asked me to post this here - so that he can give it a try!

put a PIN based on latitude/longitude of the CiviCRM Contact
put CiviCRM Contact data in the bubble pop-up
color the PIN based on value of a CiviCRM Custom field


texts: Settings - Resource URLs - Not finding specified extension folder

texts:
As of civi 5.29.1, Civi is not finding the extensions in the specified directory.   (Directory has not changed and worked up to 5.28.  Just ran into problem for the first time installing 5.33.2 and worked backwards to find version it first occurs.)
Is this a known problem?    Solution required moving extensions to different directory - specifically the default directory.


texts:
Due to problem on our end we have about 13 000 contacts with "01.01.1970" as their birthday. I'd like to remove that from all those contacts, and tried doing that by using "Batch Update via Profile". I made a simple profile with only birth date, but it doesn't seem to work.

Firstly I have to manually type in the birth date (calender drop down doesn't work), and using the copy button doesn't work. Changes are not saved either.

Does anyone know of another way to mass edit birth dates, or does anyone know how to fix this bug? I'm quite new at CiviCRM so I might have done something wrong.


texts: How do I delete registrations and automatically recalculate the invoice total?

texts: An end user registered too many people for an event. The client removed participants but the invoice total is not automatically recalculated to reflect fewer participants. Is there a proper way to do this or how do I make the correction to the invoice?


texts: Registration - Thank you page Error - Call to undefined method -Joomla

texts:
Joomla 3.9.14 and Civi 5.20 / 21  registration has been running fine for years with various different combos of Civi and joomla
The full error is: Call to undefined method CRM_Core_BAO_UFGroup::getFrontEndTitle()

User is registered to the event - just an error page where a thank you page should be - any thoughts were to look.

Thanks


texts: What to do when a CiviCRM demo site is not working?

texts:
I am trying to do some testing on the wordpress demo site but it seems to be down.

http://wpmaster.demo.civicrm.org/membership-page/

I seem to be getting an error when running deduping with the wrong wordpress account being link to the remaining record. I want to be able to test this in the demo before submitting another ticket

Cheers - Phil


texts: Identifying contact voting district from KML data or from state website

texts:
we use civicrm for a political org, and I'm trying to find out how to add voter district information to contacts in database.

The state doesn't have a public API from what I can tell. They have this website: http://whosmy.virginiageneralassembly.gov/, but getting the info out of this site would require some python scripting, and I don't know how to automate the export and reimport of the contact records.

There are KML files available from the census (https://www.census.gov/geo/maps-data/data/kml/kml_sld.html) that provide the boundaries for the districts. I'm wondering if anyone has advice on modules or approaches to take a contact's geocode address and determine which district boundary it falls in.

Thanks,


texts: CiviMail and Smart Groups: when does CiviCRM identify the actual list of email recipients?

texts: If I set up a mailing to a smart group, and schedule it to go out one month from today, will CiviMail send to the contacts in the smart group as they are defined at the point when I create the mailing, or at the point when the mailing is sent out?


texts: Preventing duplicate entries from online profile form

texts:
We currently have an online profile form in place where new charity members complete their details - This then creates a new charity group on Civi.

We are having instances where new members are entering their details multiple times, which then creates multiple instances of the same group on Civi.

Is there a away to stop multiple groups being created, such as making Civi / The form check for duplicate entries that are already present on the system.
Such as check if the email address is already in use for example?

Many thanks for your help


texts:
Contribution page with membership signup enabled get HTML_QuickForm_Controller: Unhandled action "_qf_Main_reload" in page "Main" error once the form is submitted from main page
CiviCRM : 5.35.1
CMS: Drupal


texts:
Still getting used to CiviCRM in general and version 5.26.2 specifically. WordPress 5.4.2.
Entering a 'Choose By Date' range seems to always default to 12:00AM in a search.  So if I search for all contributions between, say, July 1 and July 8, I get 1 July, 12:00AM and 8 July, 12:00AM.  Which, obviously, doesn't then show anything for July 8.
Same if I look just for yesterday - would show no results because the parameters are then 8 July, 12:00AM through 8 July, 12:00AM no matter what I put in the time field.  I know I can just choose 'Yesterday' from the drop down, but it was another test of results not found from input.
No errors, just no (or incorrect) results.
I'm pretty convinced that it is some setting I am missing somewhere, but I can't seem to find it.
Any ideas?
Thanks!


texts: I am handling membership (about 600 dues-paying members) for a small "shoestring" non-profit using spreadsheets and it is a pain. We have a GoDaddy hosted website (cheapest economy plan) using WordPress. It looks like CiviCRM may be a good choice for us. Will it work if added to our existing GoDaddy environment or will we need a larger, more powerful server? Sorry, I don't have or understand all the technical specifications. :-(


texts: What is the purpose of the "default invoice payment page" field in the CiviContribute Component Settings page?

texts: All i can find on this is a fairly unclear thread on this site at Pay later online? - nothing in the documentation at all.


texts: Using CiviCRM to manage a Community Center?

texts:
We're preparing for a new community center which will hopefully break ground this year and open in early 2018. In the meantime, we've gots lots of planning to do and I've been tasked to recommend a CRM.

Initially, we'll need a crowd funding solution for our capital campaign. Then we'll need to manage, members, donors, volunteers, have a color coded event calendar, registration and attendance tracking for events, programs and classes, space reservations, online social community for constituents, management of partnerships with collaborating orgs, and sales of t-shirts and caps, etc.

Which CMS would be best?
Cost for creating such a system?

Any other feedback?


texts: What is the status of CiviBooking for CiviCRM 4.6.x

texts: Currently CiviBooking works for the LTS of 4.4.x. We are taking a look at this for 4.6.x so putting it up as a question to track progress


texts:
I recently moved our CiviCRM database to a new host and I'm getting a "DB Error: unknown error" on when testing the payment processing. Have a missed a configuration step?

Many thanks.


texts: Upgrade from 4.6.20 to 4.6.21 fails with fatal error (sqlfile not found)

texts:
We're using D7 / Civi 4.6.20, attempted to upgrade to 4.6.21 following the Civi upgrade documentation.  The upgrade errors out with this error:

Exception: "A fatal error was triggered: sqlfile - 4.6.21.mysql not found."

I tried reloading my pre-upgrade database and repeating, but got the same error.

Backtrace:

#0 SITEROOT/sites/all/modules/civicrm/CRM/Upgrade/Form.php(432): CRM_Core_Error::fatal("sqlfile - 4.6.21.mysql not found.")
#1 SITEROOT/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourSix.php(86): CRM_Upgrade_Form->processSQL("4.6.21")
#2 [internal function](): CRM_Upgrade_Incremental_php_FourSix::task_4_6_x_runSql(Object(CRM_Queue_TaskContext), "4.6.21")
#3 SITEROOT/sites/all/modules/civicrm/CRM/Queue/Task.php(88): call_user_func_array((Array:2), (Array:2))
#4 SITEROOT/sites/all/modules/civicrm/CRM/Queue/Runner.php(214): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
#5 SITEROOT/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php(52): CRM_Queue_Runner->runNext(TRUE)
#6 SITEROOT/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php(106): {closure}()
#7 SITEROOT/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php(54): CRM_Queue_ErrorPolicy->call(Object(Closure))
#8 [internal function](): CRM_Queue_Page_AJAX::runNext()
#9 SITEROOT/sites/all/modules/civicrm/CRM/Core/Invoke.php(278): call_user_func((Array:2))
#10 SITEROOT/sites/all/modules/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:13))
#11 SITEROOT/sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:5))
#12 SITEROOT/sites/all/modules/civicrm/drupal/civicrm.module(482): CRM_Core_Invoke::invoke((Array:5))
#13 [internal function](): civicrm_invoke("upgrade", "queue", "ajax", "runNext")
#14 SITEROOT/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:4))
#15 SITEROOT/index.php(21): menu_execute_active_handler()
#16 {main}

I searched and couldn't find a file called 4.6.21.mysql but I did find /sites/all/modules/civicrm/CRM/Upgrade/Incremental/sql/4.6.21.mysql.tpl.

Any advice?  Thanks in advance!


texts: How to get the new record ID, when adding a record to a multi-value custom field using the API?

texts:
The API calls I know of that add a record to a multi-value custom field, don't return the ID of the added record (which you can then use to access the value for the specific record in the form custom_XXX_YY). Is there another way of finding it?

Observed:

$ drush cvapi CustomValue.create entity_id=154621 custom_368=Test
Array
(
    [is_error] => 0
    [version] => 3
    [count] => 1
    [values] => 1
)

$ drush cvapi Contact.setvalue id=154621 field=custom_368 value=test
Array
(
    [is_error] => 0
    [version] => 3
    [count] => 2
    [values] => Array
        (
            [id] => 154621
            [custom_368] => test
        )

)

$ drush cvapi Contact.create custom_368= id=154621
Array
(
    [is_error] => 0
    [version] => 3
    [count] => 1
    [id] => 154621
    [values] => Array
        (
            [154621] => Array
                (
                    [id] => 154621
                    [contact_type] => Individual
                    ... snipped ...
                    [modified_date] => 2015-05-14 11:20:56
                )

        )

)

Background:

In our custom frontend I want to have an 'Add new qualification' link, which creates a record in the appropriate custom field group and then adds the set of fields to the form. The screen size occupied by a set of fields for one qualification is such that I don't want to always have a blank set of fields on the screen for adding a new record, before I've clicked the link. The record's row ID is necessary to add the form fields so they know which record they apply to. Each field is 'inline editable' / sends an update call immediately.


texts:
Since I took over this project, we have had an active subscription to CiviSMTP for all of our outgoing email in CiviCRM. We already have our email for our organization going through Gmail, but all mail through the CiviCRM is going through CiviSMTP, a service that we have to pay for. From what I understand, it's to help with anti-spam regulations and bounce rate tracking, etc.

Can anyone offer some clarity into if this kind of service is necessary for sending out bulk emails and tracking bounce backs, etc? Is anyone else here even using it?
Can anyone recommend an SMTP service that does work with PHP 5.6 and CiviCRM 4.7.17 and allows TLS? Here is a related post to the issues I'm having with CiviSMTP: Outgoing Mail Settings, CiviSMTP & PHP 5.6.x Problem

http://www.civismtp.com/drupal/

Drupal 7.50 CiviCRM 4.7.15 PHP 5.6


texts: Editing a label in "new individual" form

texts: I want to edit a field called "source" in the new Individual form. I want to change the name of the field. where can I change it?


texts: Which payment processors support refunding payments from within CiviCRM?

texts:
My client is certain that they have, in the past, initiated credit card refunds from within CiviCRM, such that it triggers an actual refund of the credit card payment to the cardholder.

In contrast, in their current setup, using Stripe, they must initiate the refund within their Stripe console at stripe.com and then ensure the refund is properly recorded in CiviCRM.

For which payment processors (Authorize.net, iATS, etc.), if any, would a staff user be able to initiate the refund process from within CiviCRM, without needing to separately initiate the refund in their payment processor terminal/console?


texts: Links for the DialogFlow extension go to Drupal 404 Page

texts:
I'm on Drupal 8.
Just installed DialogFlow, but when I go to DialogFlow>Settings I leave CiviCRM and get a Drupal 404 page- "Page not found".
Any ideas?


texts: will ssl certificate on main domain work on subdomain

texts:
docs say that CiviCRM does not support shared SSL and "SSL must be installed on your domain not one at a higher level"

What about subdomains?

I have WP installed at site.com and WP with CiviCRM installed at civi.site.com

Do I need to be able to install SSL on civi.site.com or will it work from site.com?


texts: Forward CiviEvent Registration Confirmation and Receipt

texts: Apologies for such a basic question but I can't figure out how to do this. I want to forward the CiviEvent Registration Confirmation and receipt to a different email address than the email of the person who registered. I tried editing the event registration and going through the activities of that person and I'm not seeing where I could do this.


texts:
(2020 12 02; 13:27 US/PST:  I've edited this question to more accurately reflect the data available for import.)
Can anyone point me at an example of two of importing a set of relationship data (e.g., is head or member of household) between an individual contact record and a (somehow) related household contact record?  I have read through the available documentation several times, and have tried the import process in several ways, all to no useful results.
I am working with a small number of records (~27) of individuals to relate to (~17) households.   Each individual and household record as a unique (but related) external identifier, and all related records have a record # in common among them, as well as a unique record number assigned by CiviCRM at the time of import.  This number is not available prior to the import process and is not part of the import data.
I am working with WordPress 5.5.3 / CIviCRM 5.29.0.
Here are three example records (most fields omitted):
ID  ID1     UniqueID          Type  Relationship    Name
15  101015  1010150           h                     Hh Name
15  101015  1010151           i     HoH             HoH name
15  101015  1010152           i     MoH             MoH name

Household records have UniqueID ending in '0', Head of household individual records have UniqueID ending in '1', Member of household records have UniqueID ending in 2.  This field is imported as CiviCRM's ExternalID.  ID and ID1 look related in this example, they are not necessarily related.  The UniqueID is created from ID1, which is an increasing series.
My approach has been to import individual records first, and then household records, with attempted links to individuals.  This creates new individual records rather than updating existing individual records.  I've read on SE that it may work better to create Hh records first and then import individuals.  I will try that and update this question with results.
Once this small subset is functioning as expected, I then have about 2,000 records to import and establish relationships among individuals, households, and organizations.  TIA, DVH


texts:
Version 4.7.10 on Wordpress 4.6

Error when selecting Contacts->Manage Groups:
DataTables warning: table id=DataTables_Table_0 - Ajax error. For more information about this error, please see http://datatables.net/tn/7

This is a fresh install. The error makes contact group unusable which makes the whole thing unusable.

Comment from my system admin:
I've updated the nginx config without any success and also tried updating the PHP query string size limit, again without any success. I would say the next step would be to contact the civicrm maintainers and say that the query string is causing problems. Usually GET query parameters shouldn't exceed more than 255 characters, while the one above is closer to 1300. They should probably be using a POST request instead of GET.

UPDATE

Following the instructions from the datatables link above, I compared the demo site to my site.

-The suspect request URL is identical.

-Data transferred / size: demo site 0.05 kb. my site 0.19 kb. This is puzzling since the URL is identical!

-On the demo site request type is json. On my site, it says html.

-Both are GET requests. I also looked at Civi 4.6.21 on WP 4.5.3 and this same request is a POST request. So I guess they changed it to GET.

-Demo site runs Wordpress 4.5.3 and Civi 4.7.11. my site is Wordpress 4.6 and Civi 4.7.10


texts: How can we rank contacts in league tables based on 'points' for completing Activities, attending Events, having a Membership, etc - "gameify" CiviCRM?

texts:
I want to create "league tables" (rankings based on "points") - similar to the user rankings that Stack Exchange uses - for contacts who have participated in Events, completed various Activities, have Membership(s), made other Contributions, etc.

Completing different actions would have different, weighted points - for example, an organization might value attending a political action, or signing an online petition, or voting, more highly than merely having a Membership or just contributing money otherwise.

It seems relatively simple - assigning the points to the Activities, Event participation, etc in back-end tables and adding custom fields, then creating Reports using current capabilities with some slight tweaking.

Rankings based on weighted points could be more objective than merely assigning a leadership/engagement value (like 1,2,3,4,5 with 1 being better/most, 5 the least) to a contact, which can be somewhat subjective.

Has anyone done something like this using Civi? Would be great to know.

Thanks!


texts: "Failed to load resource" error when trying to view fees under manage events

texts:
I am trying to add fees to a new event in a fairly new installation of CiviCRM on a Drupal CMS. When I click on the fees tab I get the following error displayed in the browser:

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

and this in the console window:

jquery.js?pxiki7:10255 GET https://[DOMAIN NAME]/civicrm/event/manage/fee?reset=1&action=update&id=2&component=event&snippet=json 500 (Internal Server Error)

I was also getting a "Failed to load resource" error in the console window too although that seems to have stopped.

also, if I hover over the fees tab is says fees (disabled).

I am fairly new to civiCRM and Drupal so any help would be much appreciated.


texts: Could html be allowed in Price Option labels

texts:
I have a set of radio buttons for a Membership price set.

It would look better if we could break up the longish list, and the easy solution would be adding in an "hr" at end of a label.

That is clearly not possible currently. What would be required to do so and are there some/many/lots of good reasons not to consider this as an 'improvement' to core?


texts: CiviBooking menu doesn't function correctly

texts:
I was going to do some testing with the CiviBooking extension but have found that after installation the new menu item is non-functional.

I had a copy of the extension from some time earlier but I hadn't found time to test yet. In case I had an outdated copy, I uninstalled, took the latest Zip from the GitHub repo, reinstalled, cleared caches. I still have a menu item that displays funny and doesn't have any hover functionality:

Has anyone else experienced the same, and if so, how did you correct it?


texts:
In our system, based on imported data, we have the role of Pastor (whose parent is individual), and pastors are the only contacts with Drupal accounts.

When a pastor logs in, they are shown the dashboard for their Household, but this is, of course, empty, as all cases and activities have been assigned to them as an individual.

How can we correct this?


texts: Error message after online registration of event

texts:
We have been using the same online registration system with CiviEvent and same payment processor for some time.
Suddenly, registrants are getting an error message after submitting a payment through our online registration. The person is registered in CiviCrm and the payment goes through, but they still get the following error message:

Sorry but we are unable to provide this at the moment.
Could not find valid value for id.
Return to homepage.

So what happens is that after they pay, they don't know if it went through and then they try to register again so we are getting people who double register.


texts: Creating reports with custom fields relating accounts and contacts - how does it work?

texts:
I am looking for a CRM to install that can do the following:

Create custom field in account where I can select/link one or more contacts that are the founder of the account (firm)
Create a custom field in the account with the founding date of the firm
Create a school field in the contacts

And here comes the trick:

  I would like to create reports that show for example:
  all account/firm names that are founded within a specific date range with contacts linked in the custom founder field that have visited a specific school.

So in summary what I would like to accomplish is to generate a list of accounts that have been founded within a specific date range by founders from a specific school. I think I need custom fields since one founder can be the founder/employee of more than one account.

Does this work with CiviCRM and if so, how do I do it?

Thank you so much for your help!

Dennis


texts: Is it possible to create a Report (or Search) for a general view of "total openings" in CiviMail?

texts:
We all know that in CiviMAIL the "total openings" metric can be misleading with respect to "unique openings" due to the pixel/images tracking.

However, in an engagement activity, it would be very interesting to understand if the same e-mail is open several times a day after hours or after a few days: this can be a sign of strong interest from those who receive the NewsLetter

I therefore ask you if it is possible to have an overall view (report or search) not only of the total openings of a single NewsLetter, but of all the total openings - for example - relating to a campaign or a range of dates (and / or other parameters )

Thx&Bye.


texts: Can't see Soft Credit fields on a Contribution Detail Report?

texts: When I add Soft Credit columns to a Contribution Detail Report, the data doesn't show - they're just empty cells:


texts: We are having an issue with Civi location settings. We begin by making a copy of the same type of event and updating it with the new event information (correct time and date, description.) Then we save and publish the new event. For some reason, when we do this with our volunteer events, the location will often disappear from other events using the same location or it will change to another location that we have used for a different event.


texts: Workflow for new constituents. How to add a doc verification step?

texts:
Relative Noob here.
With my relatively out of the box installation I have new users joining the org via a membership contribution page.
I can use the profile-advanced settings to automatically add the people to an "active member" group once the dues are paid (either by cc or by cash/check).
That works well.
But,  I now want to add a new step where a club administrator needs to verify a document for all new members.
The workflow would be something like
Non-Member
↓
[uses a registration/contribution page to join]
↓
If cash/check   --yes-->   They get queued in pending payment
↓                          ↙
↓   cc                  ↙   admin registers pmt
↓                     ↙
User enters a new state pending verification of document, maybe via profile-advanced-grp
↓
[Admin verifies, just like an admin can confirm payment]
↓
user is now a full active member

Can someone recommend some good reading material that might be helpful here?
I see member rules that might be a good start

Is there an easy strategy to get an admin action working to have an admin kick a user from State-A to State-B once they verify the document?
Thanks


texts: Is there an update safe way to disable smarty security in templates for CiviMail?

texts:
I'm using CiviCRM 4.6.14 and I want to write a Template for CiviMail using the smarty templating engine.
I need to add some PHP code to that template, but obvious the security setting is set to true for CiviMail so I get errors.
My temporary solution is to change the settings in the file "Smarty.class.php", but that file will be overwritten at the next update.
So is there a way, to disable the security setting in the template or any other update safe way, to disable that setting?

Thanx in advance


texts:
CiviCRM 4.6.10 Joomla 3.4.0 getting this error when going to events dashboard or trying to create event.

Sorry but we are not able to provide this at the moment.
DB Error: no such table
Return to home page.

Is there an sql database dump that will recreate all the civicrm databases including some expired sample data?


texts:
I know this has been asked a few times, but I'm working with a group of folks in a new non-profit who tell me they want to move away from CiviCRM (recently installed) because it's not "beautiful" nor "intuitive", they claim people aren't using it. I think they really mean they want a bolder, more-updated style/theme than the standard Garland or Bartik I usually start with (because I care more about function than form). I think they are looking for something more in line with the Shoreditch extension effort (not sure if that is still in development), something bootstrap-feeling.

What would you all recommend to make Civi more pleasing to the eye, more readable? Is Shoreditch the way to go? If so, which base these should it be put on?

Or is there even a theme that doesn't use Shoreditch that I should be looking into?  I don't want to lose folks from the great functionality and customization ability of Civi just because of the theme (I happen to be a huge fan, using it for 9 years now, I think). I'm even open to moving to WordPress if that provides better themes for Civi.

Side note: unfortunately, I haven't been able to discuss more details to find out what exactly they mean by "intuitive design" and things like that, to understand what they feel is missing. But I'm thinking I can provide a couple of theming options early on and see if that alone will give them comfort while we talk specifics later on. Thanks for any suggestions!


texts: Profile error on existing Contribution Page

texts:
We have an existing contribution page that had two profiles included (one for top of page, one for bottom). I'm not sure when this broke, but currently (v 5.10.3), the bottom profile now appears to NOT be selected, and when you first click on the "profiles" tab, you briefly see the following warning:

  The selected profile is using a custom field which is not assigned to
  the "Membership" being configured.

The profile doesn't appear in the dropdown at all. I can see the fields if I preview or edit from this screen. If I choose another profile and save, the error does not show again, but the profile I need does not appear in the list, so I have no way of selecting it.

I'm not sure what this error means. How do you assign a custom field to a membership?

I have seen some posts here with similar-sounding errors, but they all seem to be related to issues that have long since been fixed.

Thanks for any guidance!


texts: Unserialize error when viewing a contact

texts:
I think this has something to do with a bad database table although I'm not sure how I would go about finding out where or how it happened so any advice would be greatly appreciated!

I have seen questions about a similar error on reports but this is whenever I view a contact so I'm not sure how related they are.

This error gets flagged up several times when I go to view any contact:

Notice: unserialize(): Error at offset 247 of 426 bytes in Civi\Core\SettingsBag->loadValues() (line 153 of /home/vabarnsley/public_html/sites/all/modules/civicrm/Civi/Core/SettingsBag.php).

I'm using CiviCRM version 5.13.5 and Drupal 7 on PHP 7.1.

I apologise for being a little vague but I'm hoping it makes more sense to someone that has seen it better or knows how to help.


texts: Some members are not getting scheduled reminders

texts:
We have 2 scheduled reminders set up to send emails to members: 7 days before membership end date, and 0 days after membership end date.

These had been working properly before (in version 4.6.8), but after upgrading to 4.7.15, some members are not getting the emails.

We use Mandrill to send the emails, and looking at the email logs, I saw that only about 1-4 emails were being sent each day, whereas there should have been 50-60.

So I tried changing the "Send Scheduled Reminders" to run hourly instead of daily. That helped, but didn't completely solve the issue. Now it seems that the first time the job is run each day, it still only processes about 1-4 emails. The next time it is run, it processes most of the rest of the emails, but there are still some emails each day that are never sent.

As an example, today there were 62 members whose membership expired, but only 58 were sent the reminder emails. I looked at the 4 members who didn't receive them, but couldn't find any pattern or reason why they wouldn't have been sent the emails. None of the members were set to "Do not email" in their communications preferences. Mandrill records all emails sent out, so it's not an issue of the emails being sent to spam. Also, Civi records the email activity, and none of those 4 members had the email activity recorded.

Over the past week, 408 of 466 members were sent the 7-day reminder email, so that means about 12% of the emails weren't sent.

I've checked the logs for Civi and PHP, and I don't see any messages at the times when the scheduled jobs are run. I also checked the log for the "Send Scheduled Reminders" job, and every time it shows the message:
Finished execution of Send Scheduled Reminders with result: Success (1)

I'm at a loss as to why some of these emails aren't being sent.


texts: DB Error on upgrade to 4.7: Duplicate entry activity_tab_filter for key 'index_domain_contact_name'

texts:
I receive the error below during the upgrade process. I restored to previous backup and tried again and received the same. Any ideas what exactly is it indicating is duplicate? Thanks so much!

  [Error: Migrate Settings to 4.7.alpha1] Error Field   Error Value
  Type  DB_Error Code   -5 Message  DB Error: already exists Mode   16
  UserInfo  ALTER TABLE civicrm_setting ADD UNIQUE INDEX
  index_domain_contact_name (domain_id, contact_id, name)
  [nativecode=1062 ** Duplicate entry '1-571-activity_tab_filter' for
  key 'index_domain_contact_name'] DebugInfo    ALTER TABLE civicrm_setting
  ADD UNIQUE INDEX index_domain_contact_name (domain_id, contact_id,
  name) [nativecode=1062 ** Duplicate entry '1-571-activity_tab_filter'
  for key 'index_domain_contact_name']


texts: Event Contribution page missing trxn_id in template Contribution.tpl

texts:
Not sure when this started-the Cancellation or Refund Information block is supposed to contain cancel/refund date, a note and transaction id:  the Smarty template has the code:

              {$form.refund_trxn_id.label}
              {$form.refund_trxn_id.html}

but it isn't shown - this is also the case in the latest Wordpress Sandbox, if you change a contribution status to cancelled or refunded, the trxn_id box should be shown.
I tried simply clearing templates to force recompile but that doesn't help.


texts: Event fees not showing on info page or registration page

texts:
Have set up an event with fees and pay later option (no payment processor installed yet)

The fee list does not show on the event info page,

And when following the register now link no fee option is given there either...

But if you complete the registration and billing contact details, you get an error message...

Please correct the following errors in the form fields below:
Select at least one option from Event Fee(s).

Running D7, and Civi 5.13.4

Checked on dmaster- can't replicate

Checked on another site running 5.13.4 and got the same error

Anyone else seen this?

Are there permissions I've not checked?


texts: Webform civicrm integration not respecting permissions

texts:
On my webform, I enabled 2 contacts. Contact 1 has 'Existing user' enabled and set to 'static' and default value is 'current user'. Contact 2 has 'Existing user' enabled and set to 'drop down' and default value is 'relationship to contact 1' relationship = 'child of'.

My goal is that contact 1 can go to that form and select one of his children and fill out the form.
The form doesn't respect the filter and displays all civicrm contacts in the drop down menu.

I also tried setting default values to use filters and set the filter to contact type to= campers, I also enabled the 'Enforce Permissions'.
The drop down still displays all civicrm contacts for contact 1 even though he only has permissions to edit his/her child.


texts:
I'm getting an error on the webform
Here is the error:
Notice: Undefined index: value in _webform_conditional_get_all_components() (line 662 of /home3/site/public_html/sites/all/modules/webform_conditional/webform_conditional.module).
I'm using Drupal 7 and the latest version of Webform.
I also have the error notification off.


texts: Can't seem to find the correct CSS selectors for public buttons - contributions pages (Save, Cancel and Review Your Contribution)

texts:
Does anyone have the correct CSS Selectors for these 3 buttons? I want to remove the icons (they don't display on all browsers) and change the overall style of the buttons to match buttons on the rest of the site.
https://wordpress-435088-1363156.cloudwaysapps.com/join/
https://wordpress-435088-1363156.cloudwaysapps.com/volunteer-scpa/


texts: My organization sent out a mailing to over 422 people. It only sent to 100 of the 422. Instead of it saying complete it says it is "running" which makes me think it will send more, but it's been over 24 hours and it has still only sent 100 of them on the dot. Not sure what to do here? Last time we sent a mailing it sent to 376 people and we had 100% success rate on all the deliveries.


texts: After upgrading to 4.6 CiviMail HTML version is uneditable

texts:
I'm doing some testing on 4.6 and after upgrading a site, I don't have the option to click into the HTML section when creating a mailing. The Plain Text section seems fine.

I have cleared caches and even tried changing the WYSIWYG editor to "Text Area" to see if it was something related to the editor, but it's the same:

Does anyone have an idea on how to get the CKEditor to show?


texts: CiviMail: Using DMARC for multiple from domains

texts:
Assumptions

CiviCRM is running on crm.example.org
Bounce processing is configured to use bounce.example.org
Mails are send from example.org, mail.example.org and example.com

Issue
If we were to enable DMARC for example.com it would fail the SPF Alignment since the domain example.com can't be aligned with bounce.example.org. We would additionally need a bounce processing for "bounce.example.org" and thus using this return path. However CiviCRM currently only supports one bounce processor. At least that is my understanding of it.
Here is a usefull illustration for this issue:
https://help.zoho.com/portal/en/kb/campaigns/deliverability-guide/domain-authentication/articles/when-spf-or-dkim-alignment-fails#SPF_alignment
DKIM Alignment
Adding a DKIM signature per "From Domain" works just fine and it will pass. Either by using a relaxed or strict alignment.
works for: example.org, mail.example.org and example.com
SPF Alignment
The Return-Path Domain needs to align with the "
works for: example.org and mail.example.org
fails for: example.com
DMARC Check
Since the DKIM Alignment will work most of the time, the DMARC check would pass. But sometimes mailservers also mess with the mail content and thus make the DKIM alignment fail, resulting in a failed DMARC check and your mail not beeing delivered / ending in spam.
works for: example.org and mail.example.org
may fail for: example.com
Brainstorming Ideas

Extend CiviCRM to use multiple mail accounts for bounce processing and let it chose the matching mail account according to the from domain.
I have only found https://github.com/JMAConsulting/biz.jmaconsulting.ode that is slightly touching this issue, but does so by preventing from sending with different domains.
Customize the outgoing mailserver to rewrite the return path domain to match the from domain and customize the incoming mailserver to rewrite the modified return path domain back to the original bounce processing domain.
Can probably be done, but will be quite technical and brittle and we currently don't have control over the mailserver for incoming mails.
Use the CiviCRM multisite feature: It should enable the use of multiple bounce processing accounts: Is it possible to configure CiviMail to send from two different domains?
The overhead and technical challenges does not seem to be reasonable to me. We only need one instance of CiviCRM.

Is there something that I'm missing or that I have misunderstood?
Any extension heading in the right direction?


texts: Why is my MySql DB Connect failing on New Joomla install

texts: When trying to install Civicrm 4.6.5 onto Joomla 3.4.3 I am getting the following error once the install is started from the install for directory option "Cannot open mysql://root:'rootpassword'@localhost/joomla_db?new_link=true: DB Error: connect failed.". This error is display on a white page with nothing else on it. It is using the correct password for root. Any assistance is welcomed.


texts: How can I enable the change log collapsible field on adding new contacts?

texts:
I have seen this field before, but suddenly it disappeared and there is nowhere I can find to enable it, it's a collapsible field that allows you to select with a radio button the date created and date modified.

Even if I have it selected in display preferences, it's still not displaying. Tried to add a custom field for it to no avail...


texts: What would cause contributions and contacts to go missing?

texts:
Recently we noticed a several contacts and their contributions were missing from our database. These contacts and contributions were not manually deleted. The contacts are not in trash (I believe civi does not allow contacts with contributions to be permanently deleted. The contributions would need to be deleted first).

I suspect that the data was overwritten. Can anyone advise:

(1) What change to the server or database could allow data to be overwritten? I am the site admin, not the sys admin (we are on shared server). Would an upgrade be a likely cause? Or would I need to ask the sysadmin about an actual move from one server to another?

(2) Is there a best practices for recovering data? I think the best approach would be to pinpoint the date the data was lost, export contacts and contributions that are in the backup but not the current version, and import to current version. But I am open to suggestions.

(3) Does anyone have suggestions on how to catch this kind of issue?


texts: How can I download CiviCRM tar file with Drush?

texts:
Is there a way I can automatize this download in order to use drush civicrm-install

I'm trying to automatize deployment of CiviCRM in Drupal 7


texts: Dedupe Rules to import contacts without email addresses *UPDATE*

texts:
UPDATED 1/16/2018
See screenshot.  This is an example of what I am trying to import.  This is the same person. The only difference is the notes.  How can I import this without creating 4 duplicates?

****End Update****

I am still unable to resolve this issue. Is there anyone else who has imported contacts who do not have email addresses?

We are using Civi 4.7.29 on WordPress 4.9.1

We have a whole spread sheet of contacts who do not have email addresses and I am trying to import them into Civi.  The names, addresses and postal codes for individual contacts match, but the Notes are different and that is is why I need to import them, so the notes are added to their Civi profiles

I created a new general Dedupe rules with First Name Weight = 10, Last Name weight = 10, Postal Code Weight = 10.   The idea is if the First Name, Last Name and Postal Code don't match, create a new profile.  If they do match, just update the current profile.  However every time I try this, it just continues duplicating every single person for each note they have.  For example if they have 3 notes on their profile, there will be 3 duplicates for that person.

I tried adding the street address and other fields to the dedupe rule, and still got the same exact results.  It appears  that unless they have an email address it will deplicate the record, and will ignore all other dedupe rules. I was able to perform this same task with no problems with our contacts who do have email addresses.

Can anyone suggest a dedupe rule setting I should try for this task of importing people and their notes, when the contact does not have an email address?

Thank you.

UPDATE
I visited the demo site at https://demo.circle-interactive.co.uk/ and ran some tests and got the same results as I described above.   The screenshot shows my dedupe settings.


texts: I successfully used civicrm to create a contact but I want to send a custom field value through api to be saved on the created contact but can't find a way to do can you advise, when I search in support -> developer -> api explorer only found "CustomField" but can't use it to set custom field value on a specific contact.


texts:
Facing this warning Timestamps reported by MySQL (eg "2017-07-20 13:48") and PHP (eg "2017-07-20 08:18" ) are mismatched.

While MySql time matches with my local time. PHP is running 5:30 hrs less. My timezone is UTC+5:30 hrs.

Tried below options,

changing the setting in UI ( WAMP -> PHP settings) and also in PHP.ini.
Wordpress settings

Didnt seem to work. What else I need to try?


texts: Family Membership not inherited by related contacts

texts:
We have two sites recently updated to 4.6.8 and are experiencing issues with family memberships, where the related party is not getting a new membership when the other renews.

Are there any changes lately that would account for this?  It had been working previously, in 4.6.3 and earlier.

One of the sites has a number of extensions involved, but the other is pretty vanilla and they both have the same issue.


texts: Expired memberships being erased by new memberships using Webform

texts:
we have a problem with expired members renewing.

When they renew using our webform, the old membership is replaced completely with the new membership. This means we lose the key 'member since' data.

They also show as a new member and not a current member which presents problems for us.

This does not happen when someone is in the grace period.
This does not happen if we manually renew the expired membership.

We use webform civicrm intergration with paypal standard. Drupal 7. Latest version of webforms and civicrm intergration. CIVICRM 4.5.8.

Any help resolving this issue would be much appreciated.

Thanks,
Andy


texts: How to integrate with Drupal migrate to create a periodic import into CiviCRM?

texts:
We have a requirement to periodically update a set of contacts in the CRM from an external source. Our preferred base technology is Drupal migrate. This is so that we can automate some transforms and the user can trigger the imports as well as review the results. It's also so that we don't run into the performance limits that we typically do with the CiviCRM import procedure.

Which module is the best option for creating the CiviCRM integration?

civicrm_migrate
civimigrate
civicrm_entity


texts:
I am getting the following errors when doing various tasks in and around CiviCRM only

Warning: Cannot modify header information - headers already sent by (output started at .../public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/System.php:1) in .../public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/Base.php on line 912

When hitting save on things like clearing cache and updating paths. If I just hit refresh the page loads right up, but won't on the original button press.

and

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at .../public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/System.php:1) in .../public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Session.php on line 127

When running cron jobs. I know these are probably related, but would really love to get them fixed as the last one is blocking cron from running via url.

Wordpress Version: 4.7.4
CiviCRM Version: 4.7.19


texts: I'm unhappy at the prospect of passing sensitive data like contact details as URI parameters for a POST (where they will show in logs, etc.). Is it possible to pass the details in the content body instead? This is standard practice for RESTful APIs and I'm surprised that it is not the standard for civi.


texts:
I'm trying to set up a mailing in Civi using a smart group.  I have the Mailing Name, Recipients, Subject, Content, and the two unsubscribe tokens.  The test and next buttons are still disabled.  I'm using Civi 4.6.4 in WordPress.
The autoresponder is currently disabled.

Thank you


texts: Is there a way to add a Null option to webform radio buttons?

texts: When using a Drupal Webform with CiviCRM it is possible to add a Null or 'Empty' option to a Select input box, if using a dropdown list.  Is there a way to do the same thing if using radio buttons?


texts: Mailmerge contact of same address & print directly from Civi

texts:
There was an extension from vedaconsulting for wordmailmerge extension. But seems its broken in 5.x. Just wondering if anyone can give me a alternative suggestion of how I can achieve the same result please?

I want to make PDF/DOCX or any printable format with contacts Name address etc. When generating docs, I would like to merge the name of the same address and option to eliminate "do not Mail" contacts.

Any ideas please? Thanks


texts:
I'm using civicrm 4.7.17 on drupal 7.54.  Logged in with administrator rights.

When I try to add a new field, (admin -> customize data and screen -> custom fields) everything works fine.  I create a new set, no problem, but then when I add a new field to the set, and click on save, it just hangs, loading forever.

This seems to be a new thing as I've created lots of custom fields before.

Any ideas?


texts: Design flaw in current employer and job title

texts:
Apparently there is a design flaw in the current employer and job title fields in Civi.

"If you enter or amend these fields through the edit of a contact, a corresponding employment relationship will be established. Unfortunately, if you create an employment relationship directly then the two fields do not get updated. Likewise, if an employment relationship becomes non current or is deleted, then the two fields do not get updated."

Does anyone know about this and how can I  get around it? I am entering job titles for contacts. Civi says it saves them. When I open the contacts the next day, the updates have not occurred.


texts: How do I change the Form Processor "Edit Action" Form?

texts:
I want to change a small thing in the graphical user interface which allows to change a form processor (/civicrm/admin/automation/formprocessor/...).
Specifically, I want to change the form that appears when I create or edit an Action.
I want to add a field where users are able to write a default string. This string should be written inside a CiviCRM custom field, if there is no other value. So, this field should work similarly to the Default Subject field in the Configuration section.
The reason for this: I have an Input field of type Option Group that hands an array of products to the Actions. For each available product, I want to create an Action testing if the input array contains this product. If yes, a new Activity should be created, with the custom field product type filled with a default string (name of product).
Right now, this custom field is already part of the Create Action form, but it has a dropdown menue allowing me to auto-fill the field. But I don't want to choose anything from the dropdown menue (like Input fields, for example). Instead I want to be able to write some default string there.
I didn't find any similar question/thread, and poking around in the code at /public/sites/default/files/civicrm/ext/form-processor/ doesn't seem to bring me further.
Also, I cannot use the Retrieval of defaults tab, because I do not want any Input field filled by default. The default value will only come into the game if the Condition of one Activity (that is, Array contains...) is fulfilled.
Where is this form created? Where can I change the field type of specific (custom) fields?
Any hint is appreciated :)
Edit: It would also solve the problem to have an array-type input field, and an Explode List Action that actually takes an array, and properly and accessibly outputs all of its values (e.g. via indices). I don't really understand why Formprocessor Extension has all different types of option groups, but no simple array, and none that actually works with Explode List.


texts: How can I send a copy of a receipt to member who has already recieved it during signup?

texts:
I've got a situation where by the template for the receipts (for contributions) which are sent out during signup had the previous year on it, and consequently, need to re-send the receipt to the members who have signed up in this year with an updated year.

I was wondering if there is any easy way to do this?, i can easily create a mailinglist, but i've no way of replicating the receipt (or just re-sending the currently sent ones, but with the new date) that I am aware of?


texts:
Can CiviCRM do a batch credit card transactions where the transactions get send to the payment gateway in a batch?

I tried going to Contributions > Batch Data Entry / Accounting Batches, and when I create a new batch, I can select 'Credit Card' as a payment method against a contribution but there is no option to enter the credit card details.

Thanks for your help.


texts: Can we automatically make a users Drupal account inactive when their membership expires?

texts:
We are running on Drupal 7.67 and Civi 5.13.4.

Our client wants to be able to block users whose memberships have expired and request them to contact the client to reinstate their membership.

We have been trying to build a custom module to be able to do this and are finding it challenging.

Is there any way that we would be able to use the CiviMember Role Sync or the CiviGroup Role Sync modules to help us achieve this is a simpler manner? If not, how should we proceed.

Thank you


texts: Why can't I have CiviEvents without dates?

texts:
Incremental and iterative planning and development is the modern way. In CiviEvent I can't create events that have no date. To me that would be a first step in a planning process, creating the event with a brief description, then later add a date and more information.

I could even see uses of having public events without dates. That creates visibility into what might be coming.


texts: How do I process a refund for a credit card payment via iATS?

texts: I have a member who accidentally bought two memberships and there is no clear way to just refund one of the amounts. Seems like a relatively simple task that should be more intuitive.


texts: How can I provide fixed time slots to my resouces in civiBooking?

texts: For Example I have a Room, which I want People to book through civiBooking, but while booking they are given fixed time slots, either booking it for 30 minutes or 1 hour. How can I give fixed time slots to my resources?


texts: I am attempting to correct an issue that has plagued me since setting up CiviCRM. The issue remains for me, even after upgrades. The issue is that on some pages within CiviCRM, the menu doesn't fully load, and ultimately renders a page useless. It occurs when I am going to the Civimail component and some other features. It isn't consistent. Here are two screenshots. The first shows the normal menu that appears on most pages. The second image is the image with the broken menu:


texts: When making an in memory of donation -> why does the deceased contact not get marked deceased?

texts:
I noticed this with one of my clients who processes a lot of in memory of donations. I've reproduced this on https://dmaster.demo.civicrm.org :

1. enabled in Memory of profile on
https://dmaster.demo.civicrm.org/civicrm/admin/contribute/settings?action=update&reset=1&id=1

2. made a fake VISA Contribution on that Contribution page - selecting In Memory of radio button and filling in First and Last Name
https://dmaster.demo.civicrm.org/civicrm/contribute/transact?reset=1&id=1

3. Result: Contact is created but is -not- marked deceased. If we had also filled out the email for the deceased (standard field for the in memory of profile) then this could easily lead to some awkward moments allowing CiviCRM to email deceased people.

4. I can understand that one may want confirmation that someone is deceased - rather than letting an anonymous donor update that field in the database - but to treat 'in memory of' contacts as alive people is risky.

5. Anyone have any suggestions on how to handle processing 'in memory of' profile submission better?


texts: Adding settings with form to my extension - what am I missing?

texts:
I would like to add a settings form to a new extension to hold some extension-specific settings.

I've put together the extension and form using civix, and am testing in civiCRM 4.7.17 on local MAMP.

After reading the docs here and here, i've tried to copy the setup for settings in this repo (metadata form example from docs), and also looking at this repo.

I've looked at this question, but the issue i'm having is getting the settings array returned from settings/'myextension'.settings.php to actually populate anywhere in the first place.

For example when installing/enabling the extension, hook_alterSettingsFolders fires with the same code as in the above repos, but if I try to find my settings with the apiv3 call like this form (the one I used as well) does, the settings group has not been added, and so my form only populates with submit buttons and a var_dump of $_settings is empty.

I'm not seeing anything obvious in the civicrm or php logs.

Is there some key step i'm missing to get civicrm to recognize these settings?

Thanks!


texts: How to link to a stored invoice pdf with civicrm api

texts: I can see that the invoices I have created are in the civicrm/custom map as invoiceID.pdf, but how can I link to them using Civicrm api?


texts: Event custom fields not carried over to repeat events

texts:
When we set up a recurring event, data in custom event fields isn't carried over to the repeated events. Similarly, if a recurring event is edited and we tell it to overwrite all the occurrences, only the edited event will retain the custom data.

(This is in v4.6.4, but I'm able to duplicate this in the online demo)


texts: wordpress woocommerce + civicrm integration points

texts:
I'm looking at wordpress + woocommerce + civicrm for a client.  I'm quite familiar with all three, however not sure how they could best be integrated.

Client is considering woocommerce for selling subscriptions, which creates a wordpress user profile + order record(s).  One issue is extending the checkout process to include additional wordpress profile fields (like birthday) which is simple enough.  Civicrm can "sync" with wordpress users, but does anyone have a best practice for managing extended profiles?  Woocommerce is expecting certain customer fields so we can't simply replace the profile with a civicrm profile.

As a side note, we will likely need to extract subscriber / order info as it will contain things like donations.  subscriber status can be opined by keeping the roles->civicrm groups in sync.

I'm wondering if there is a way to extend the civicrm+WP sync process to include more wordpress profile fields and thereby keeping info in sync.  Perhaps duplicating the collection of info during checkout is another approach.

I've not done a civi+wp implementation before (but am very familiar with each) so I may be making some silly assumptions.  Also, trying to approach this as a system builder without requiring too much custom code.

Any approaches/references welcome.  I expect there will be increasing interest in integrating info from WP+Woo+Civicrm as it is the leading WP ecomm solution.


texts: Understanding unique vs multiple membership(s) (using Webform)

texts:
I am extensively testing CiviMember because I have several Organizations which have different membership types with different duration types.

Memberships will be managed from the Organizations (not from Individuals)

I intend to create memberships via Webforms (Contact1 = Organization ; Contact2 = Individual ; One membership for Contact2)

When I use the same Webform again for the same Organization, Individual pair, in certain cases it creates a new (duplicate) membership, in others, it modifies the existing one.

I'd like to understand why and when each case happens (I may be interrested by each, but need to control when)

Thanks in advance


texts: Why I am not able to select more than 500 records (CiviCRM 4.6.10)?

texts:
After a search, if I increase the no of records to more than 500, although I can select them, but when performing an action, it only applies to 500 records.

Could it be an issue with my PHP value or a known issue with CiviCRM?

UPDATE: as you can see here, although I have increased the value at the bottom of page to 1500, and it shows 1500 records, but as I select them using the check box, it only shows 500 selected Records only.


texts: Problems inserting action tokens with default wysiwyg HTML editor

texts:
CiviCRM 5.14.0

This is a new site and I am testing inserting action tokens in emails. If I use the link symbol in the wysiwyg, it inserts double-quotes around the link but the {aciont.reply} already puts double-quotes so it gets garbled. If find if I edit the source and change it to single-quotes, it will work. However, if I toggle back to HTML and then source again, I see my single-quotes have been replaced by double-quotes.

For example:

Hey {contact.first_name},

Thank you for volunteering.&nbsp;

This works: Please reply to this email by sending mail to The System Administrator

This doesn&#39;t work:&nbsp;Please reply to this email by sending email to The System Administrator

Now, the line that says "This works" actually does work. If the recipient clicks on the link, their mail client pops up with reply filled in with the System Administrator's address.

The line that says "This doesn't work" looks exactly the same to me as the working line but it gets garbled somewhere along the way.

The email as received looks like this:

Sample Header for HTML formatted content.

Hey Clem,

Thank you for volunteering.

This works: Please reply to this email by sending mail to The System Administrator

This doesn't work: Please reply to this email by sending email to ">The System Administrator
Sample Footer for HTML formatted content
Unsubscribe
PO Box 540
San Miguel, CA 93451-0540
United States

Notice the right caret >. This is what I mean about getting garbled. I have no idea where that is coming from. In the source both lines look the same to me.

If I can't figure this out, how could an end user possibly figure it out?


texts:
So I would like to use the CiviCRM events in wordpress, in a page listing multiple events, using the shortcodes. If I create a page in wordpress with the following:

[civicrm component="event" id="584" action="info" mode="live"]

It is fine, it will display the single event. However, if i was to add another event into the page, it doesn't display. Ideally I would like to use this shortcode inside of Advanced Custom Fields. The reason for doing this is we need to display only certain events for a page which members are logged in to view.

<?php

if( have_rows('events') ): ?>

        <?php while( have_rows('events') ): the_row(); ?>

<?php var_dump(get_sub_field('event')); ?>

        <?php endwhile; ?>

<?php endif; ?>

The vardump above literally returns null. Any ideas how I can do this. I am aware of the civievent wiget but that lists all events that are upcoming.

Just to clarify this is for civicrm 4.5.4. Cheers.


texts: I have the civicrm events calendar extention installed on three drupal sites. All use drupal 7.69, Civi 7.x-5.22.0, and the event calendar extension 3.2. But on the last site I set up, the calendar does not display. Are there other requirements that I'm missing?


texts: How do I find duplicate contacts by nickname?

texts:
Here's an example of a very common situation I have:

Database has a contact like this

first name: Robert
nick name: Bob
last name: Smith
email: bobsmith@example.com
...

Event registration form receives a submission like this

first name: Bob
last name: Smith
email: bobsmith@example.com
...

A duplicate contact is created because the first name values do not match.

When finding duplicate contacts, is there some way of getting Civi to notice that the first name of one contact is identical to the nick name of another contact?

As a workaround, I've tried adding the nick name field to public forms, but trust me you don't want to do this. It's funny seeing what people write when prompted for a nick name, but not so funny when you notice postal solicitations addressed to people like "The Dude Smith".


texts: Dedupe error when merging records with custom values

texts:
I have a set of records where participants have registered for some events, with additional booking info, using different email addresses so have created duplicate records.  When merging these I receive a database error:
'''
[code] => -5
[message] => DB Error: already exists
[mode] => 16
[debug_info] => UPDATE civicrm_value_booking_information_10 SET entity_id = 6349 WHERE entity_id = 6640 [nativecode=1062 ** Duplicate entry '6349' for key 'unique_entity_id']
[type] => DB_Error
[user_info] => UPDATE civicrm_value_booking_information_10 SET entity_id = 6349 WHERE entity_id = 6640 [nativecode=1062 ** Duplicate entry '6349' for key 'unique_entity_id']
[to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE civicrm_value_booking_information_10 SET entity_id = 6349 WHERE entity_id = 6640 [nativecode=1062 ** Duplicate entry '6349' for key 'unique_entity_id']"]
'''
In the database there is already a custom value record for each of the contacts so this update is never going to work - I have tried flipping the records and setting the extra booking info on each to empty values or the same values - always the same error...
Looks like a bug to me.  Any ideas?
PHP version 7.3.24, Joomla! 3.9.19 Stable, CiviCRM 5.31.0


texts: How to add a column in a membership report for a secondary email?

texts: I need to run a report which has a column for a secondary email.


texts: Membership cancelled, but active until end date

texts:
Our memberships period is a calendar year. If a member decides to cancel, he will still be a member until the end of the year. During the remainder of the year, the member can still profit from his membership. But he must not be reminded of renewing his membership.

So, the end date discriminates active memberships, not the membership status itself. At the end of the year, the status should still be cancelled, not expired.

Is this something that can be done?


texts: Contact images not showing after update to 4.7.7

texts: I just upgraded my civicrm install from 4.6.10 to 4.7.7 and moved the main page in wordpress to another subdomain. It was at www.site.com/civicrm and now it is at www.site.com/somethingelse/civicrm. Since I executed these actions contact images are not showing anymore. I updated the civicrm-settings.php file to add the new subdomain as the standard page and noticed that civicrm started working with dynamically generated paths [civicrm.root] and [civicrm.files]. I also tried to fill out the absolute paths to the file locations and civicrm confirmed that the locations were found. Still no pictures. Removing an image and re-upload it also does not solve the problem. Anybody else having the same experience, is it a bug or am I missing some settings? thanks.Running WP 4.5.1


texts: how to drop all civicrm tables using drush?

texts:
Civi is using it's own (not shared with Drupal) database.  During a script to rebuild a dev/test site from production data I want to drop all the tables in the civi dev db.  How do I do that?

After painstakingly trying civitables=$(drush civicrm-sql-query "show tables" | tr '\n' ',' | sed 's/,$//') && drush civicrm-sql-query "drop table $civitables" I realized I could more simply do drush civicrm-sql-query "drop table like 'civi%'" but both of these are giving me "Query failed" error.  Why would these queries fail or what could I inspect to see why the failed?  How can all the tables be dropped using drush?

*edits...

The drop table like... is apparently invalid sql sytax.  Doh.

And the civitables=$(drush civicrm-sql-query "show tables" | tr '\n' ',' | sed 's/,$//') && drush civicrm-sql-query "drop table $civitables" appears to fail due to Cannot delete or update a parent row: a foreign key constraint fails which apparently needs SET FOREIGN_KEY_CHECKS=0; in order to work but when I do that the query passes (doesn't produce error) but fails to delete any tables.


texts: Case status change to a closed status does not update the end date and relationships of the case

texts:
When I change the case status with the API to a case stated which is Closed. Then the end date of the case and the end date of the case roles is not set.

When I change the case status from the user interface the end date is set and the end of the case roles is set.

Is this behaviour correctly or should I file an issue and solve the bug in the API?


texts: Settings values not showing up. Cache issue?

texts:
I am experiencing a strange issue with my CiviCRM (4.7.3) installation on Joomla (3.4.8) with MySQLi 5.6.28-76.1-log and PHP 5.6.18.

If I change some of the settings in one of the administration pages, they are correctly updated on the database, but if I get back to that page I don't see the setting anymore. It seems like values for the settings pages are not retrieved correctly from the database.

It's seems like a cache problem, but I've tried to clean the followings to not avail:
- browser cache (tried different browsers as well)
- joomla cache
- siteground supercacher

Problem still there. Any ideas?

First screenshot is from a working CiviCRM installation (http://sandbox.joomla.civicrm.org/). If you check any of the settings pages (ie. Administer > Localization > Languages, Currency, Locations) you can see that the options have values according to what is in the database. Radio buttons are correctly valorised. If you change the option, save and get back to the page you can see the option you choose. This is the normal behaviour.

Second screenshot is from our CiviCRM installation (http://omphalospg.org/). If you check any of the settings pages (ie. Administer > Localization > Languages, Currency, Locations) you can see that some of the options don’t have values according to what is in the database. Radio buttons in particular are not correctly valorised. If you change the option, save and get back to the page you cannot see the option you choose, even though the option is correctly saved in the database. This is not a correct behaviour.


texts: Price set contribution field won't accept negative amounts?

texts:
Price sets give you the tremendously useful ability to add a price field in which a user can enter an arbitrary amount. This is done by choosing an Text/Numeric field type, setting its value to '1' and NOT ticking 'Display amount'.

However, we want to use this to create an arbitrary-sized discount for admin users, and Civi doesn't seem to allow negative numbers in this field.

As you can see from the attached screen shot, the negative entry in our 'arbitrary amount' field has been ignored.

It's perfectly possible to make discounts of fixed amounts in a price set - the screen shot shows that our fixed discount has been included in the price calculation.

What would need to happen so that this 'arbitary amount' field can accept negative amounts?

Thanks for your help!

Drupal 7.43, Civi 4.6.17


texts: Change Joomla User Group After Registration

texts:
I created custom profiles and have registration forms for these profiles. What I want to do is to assign people after registration to a specific Joomla user group.

For example:

If a visitor register on A profile, I want to assign him/her to Joomla's A user group.
If a visitor register on B profile I want to assign him/her to Joomla's B user group.

Is this possible?
Thanks.


texts: CiviVolunteer - Functions Not Working after Security Update to Civi 4.7.21 on Drupal

texts:
We started using the CiviVolunteer extension with success.  However, after we upgraded to the security release 4.7.21 some of the CiviVolunteer functions do not work.  Or they cannot be accessed from the navigation menu.

We cannot access the following functions;
- New Volunteer Project
- Manage Volunteer Projects
- Search for Volunteer Opportunities

In addition, the CiviVolunteer menu items cannot be seen on the Navigation Menu editor (Administration > Custom Data and Screens > Navigation Menu)


texts: Anonymous users cannot register for a civievent

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

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

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


texts:
I was wondering if anyone had suggests on great themes that I could purchase or are free for the public facing CiviCRM contribution pages? We would like to to be very responsive (Mobile friendly) and maybe incorporate Bootstrap.

Any ideas or suggestions are helpful. Thanks


texts: Suppress default CRM.alert in hook_postProcess

texts:
Trying to figure out an answer to this question, have tried to just disable a default CRM.alert using CRM_Core_Session::setStatus(null, false);  in hook_postProcess (defined in a drupal module), but alert still pops up (not a problem generally, it pops up in a default style, would like to use  CRM.status  instead, which works perfectly even outside of CiviCRM, while CRM.alert doesn't).
Any advice, please!


texts: What do you do with Pending (Incomplete Transaction)?

texts:
We currently use Paypal until we can figure out why Stripe is not working. If a user does not complete the paypal payment, CiviCRM correctly lists the transaction as Pending (Incomplete Transaction).  Since most users eventually create a new transaction, we are left with a number of Pending (Incomplete Transaction) activities.

I have begun to list those activities as Expired but I then thought Cancelled may be a better fit.  Then I wondered if I should just leave it alone.  What do you all recommend?  What do you do?


texts: How to fix this JSON Error with Joomla 3.7, CiviCRM 4.7.19, PHP 7.1?

texts:
To evaluate CiviCRM, I've installed CiviCRM 4.6.26/Joomla 3.6.5, subsequently upgraded to CiviCRM 4.7.19/Joomla 3.7 site that is running PHP 7.1.

The backend 4.7.19/3.7 install appears to work fine, but when I define a CiviCRM Dashboard or anything else as a front-end menu option, I get

RuntimeException: Error decoding JSON data:
Syntax error in /home/hillcresttm/public_html/libraries/vendor/joomla/registry/src/Format/Json.php:72 Stack trace:
#0 /home/hillcresttm/public_html/libraries/vendor/joomla/registry/src/Registry.php(366):
  Joomla\Registry\Format\Json->stringToObject('{"menu_image":"...', Array)
#1 /home/hillcresttm/public_html/libraries/vendor/joomla/registry/src/Registry.php(72):
  Joomla\Registry\Registry->loadString('{"menu_image":"...')
#.............

Various Joomla support forums indicate that message is likely a problem with JSON data that is not valid. In Joomla versions prior to 3.6.3 (October, 2016) this failed silently, but since 3.6.3, it generates an error.

I've cleared/disabled my Joomla caching with no change in the error. I found a CiviCRM item on cache, but the directory structure did not match my installation.

Any suggestions for how to proceed?

Bruce