texts:
Uncaught Error: [] operator not supported for strings in
  /wp-content/plugins/civicrm/civicrm/CRM/Report/Form/Contribute/Summary.php:580

Don't know whether this started with Civi 4.7.19, WP 4.8, or something else -- but now I get this 500 error whenever I try to run a Contribution Summary (Reports / Contribution Reports).

Other Civi summary reports (e.g. Constituent Summary, Event Participants List) run as expected. Other Civi Contribution reports also run as expected. It seems Contribution Summary is our only misbehaving report.

I've disabled all plugins other than CiviCRM and activated Twenty Seventeen theme, but that doesn't stop the 500 error.

  Stack trace: [13-Jun-2017 08:57:17 America/New_York] PHP Fatal error:
  Uncaught Error: [] operator not supported for strings in
  /wp-content/plugins/civicrm/civicrm/CRM/Report/Form/Contribute/Summary.php:580
  Jun 13, 12:53:49 PHP Warning: Failed to send an email, wp_mail()
  returned FALSE in /wp-content/plugins/error-log-monitor/Elm/Plugin.php
  on line 200
  5 [REDACTED] in /wp-content/plugins/civicrm/civicrm/CRM/Report/Form/Contribute/Summary.php
  on line 580
  4 /wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Submit.php(74):
  CRM_Core_Form->mainProcess()
  3 /wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(447): CRM_Report_Form_Contribute_Summary->postProcess()
  2 /wp-content/plugins/civicrm/civicrm/CRM/Report/Form/Contribute/Summary.php(756):
  CRM_Report_Form->postProcess()
  1 /wp-content/plugins/civicrm/civicrm/CRM/Report/Form.php(3249): CRM_Report_Form->buildQuery()
  0 /wp-content/plugins/civicrm/civicrm/CRM/Report/Form.php(2626): CRM_Report_Form_Contribute_Summary->groupBy()

It is possible we've had this problem since well before the current Civi and WordPress iterations were released/installed, but hadn't noticed it before because we're still somewhat new to Civi.

I activated debugging and backtracing, but no error info displayed when running Contribution Summary.

I assume Contribution Summary is working fine for everyone else. What should I try next?


texts: Buildkit -- Warning: file_get_contents(http://localhost:7979/index.php): failed

texts:
The setup for buildkit runs smoothly, until  the 'amp test' command where it fails no matter what I do. I have tried over and over again for 6 hours. I'm new to this so maybe I'm making a basic mistake. Following are the exact steps and configurations I used, along with the output. Please help if you can.

Linux Mint 17.1 fully updated, fresh install, on
Virtual Box (running also in Linux Mint 17.1)
Apache/2.4.7 (Ubuntu)
PHP Version 5.5.9-1ubuntu4.9

As far as I can tell all the prerequisites are fulfilled. Following are the commands, reports and configuration I used:

apt-get install curl

comment: Note the new setup script name for Node.js v0.12
curl -sL https://deb.nodesource.com/setup_0.12 | sudo bash -

comment: Then install with:
sudo apt-get install -y nodejs

Use software manager to install:
Ruby and
Rake

git clone "https://github.com/civicrm/civicrm-buildkit.git" "/opt/buildkit"
export PATH="/opt/buildkit/bin:$PATH"

civi-download-tools

sudo service apache2 restart

amp config

Enter mysql_dsn> mysql://root:my_password@localhost:3306

Enter perm_type  [1] "linuxAcl": Set tight, inheritable permissions with Linux ACLs [setfacl] (recommended)

Enter perm_user>  www-data
Enter httpd_type apache24

Note: Please add this line to the httpd.conf or apache2.conf:

  Include /root/.amp/apache.d/*.conf

service apache2 restart

amp test

Connect to test application
Expect response: "response-code-vh4D13nHwi"
PHP Warning:  file_get_contents(http://localhost:7979/index.php): failed to open stream: HTTP request failed! HTTP/1.1 403 Forbidden
 in /opt/buildkit/vendor/totten/amp/src/Amp/Command/TestCommand.php on line 153

Warning: file_get_contents(http://localhost:7979/index.php): failed to open stream: HTTP request failed! HTTP/1.1 403 Forbidden
 in /opt/buildkit/vendor/totten/amp/src/Amp/Command/TestCommand.php on line 153
Received incorrect response: ""
Tip: Try running "amp config" and/or restarting the webserver.
Mint17a buildkit #

Even if I set the following permissions I still get errors:

group and full permissions for /opt/buildkit = www-data
group and full permissions for /var/www = www-data

Thanks in advance!


texts:
When I try to send a mailing, even if I chose to send it directly, it doesn't send and its status stays on "planned". I have to go in the schedule job menu to force the task. What can I do to just send mailings immediately?

Thank you.

s.


texts: Is it possible to use CiviCRM Spark as a ticket issuer for Facebook Events?

texts: I am running many Zoom events on Facebook and would like people to be able to book online via a ticketing system. 'Old' facebook had the facility to reserve a space but this doesn't exist on the new system.


texts:
I formerly used CiviCRM with a Drupal website and recently moved over to the same Civi install on a Wordpress website. The CiviDB is the same, but the CMS has changed.

Previously, when using CiviEvent, there was a dropdown calendar for selecting the time. Also, when choosing the event location, I could select a formerly used event and it would auto-populate the fields with the event data from that previous event.

Now, on Wordpress, those functions do not work. I have to manually enter the time and date, and while I can select a previously used event, it does not auto-populate the fields (I have to manually re-enter the info, and it will erase any fields that are left blank in the other events that share the location).

My question is whether this is a limitation of the Wordpress version of CiviCRM, or if something was messed up when moving from Drupal to Wordpress. Do other Civi/WP users have this problem?


texts: Log Entry View and other settings pages don't load (5.18.4, Drupal 7.67)

texts:
recently I am unable to load Log Entry Views and other settings pages in my Drupal CiviCRM. On the page it shows the following errors:

Warning: include(/var/www/html/sites/default/files/civicrm/templates_c/de_DE//%%48/488/4880C3C4%%LogViewEntry.tpl.php): failed to open stream: No such file or directory in include() (Zeile 1911 von /var/www/html/sites/all/modules/civicrm/packages/Smarty/Smarty.class.php).

Warning: include(): Failed opening '/var/www/html/sites/default/files/civicrm/templates_c/de_DE//%%48/488/4880C3C4%%LogViewEntry.tpl.php' for inclusion (include_path='/var/www/html/sites/default/files/civicrm/ext/uk.artfulrobot.civicrm.importhelper/:/var/www/html/sites/default/files/civicrm/ext/ca.bidon.civiexportexcel/:/var/www/html/sites/default/files/civicrm/ext/ca.civicrm.logviewer/:/var/www/html/sites/default/files/civicrm/ext/com.agiliway.civimobileapi/:.:/var/www/html/sites/all/modules/civicrm:/var/www/html/sites/all/modules/civicrm/packages:.:/var/www/html/sites/all/modules/civicrm:/var/www/html/sites/all/modules/civicrm/packages:/var/www/html/sites/all/modules/civicrm/vendor/tecnickcom:/var/www/html/sites/all/modules/civicrm/vendor/phpseclib/phpseclib/phpseclib:/var/www/html/sites/all/modules/civicrm/vendor/pear/pear_exception:/var/www/html/sites/all/modules/civicrm/vendor/pear/auth_sasl:/var/www/html/sites/all/modules/civicrm/vendor/pear/log:/var/www/html/sites/all/modules/civicrm/vendor/pear/console_getopt:/var/www/html/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src:/var/www/html/sites/all/modules/civicrm/vendor/pear/mail:/var/www/html/sites/all/modules/civicrm/vendor/pear/net_socket:/var/www/html/sites/all/modules/civicrm/vendor/pear/net_smtp:/var/www/html/sites/all/modules/civicrm/vendor/pear/validate_finance_creditcard:.:/usr/share/php') in include() (Zeile 1911 von /var/www/html/sites/all/modules/civicrm/packages/Smarty/Smarty.class.php).

The last major change to my CRM was adding the civicrm.importhelper extension.


texts:
I'm new to CiviCRM, but done a lot of playing around for a new activist network I'm a part of. It's a brilliant tool! We are building our site in wordpress.

Becoming a member of our network is free, and we've created a contribution page to collect a few details from individuals. We'd like to edit the "thank you" page that users are sent to once they have completed the contribution page, so that it's cleaner and easier to read, and (most importantly) doesn't have the information about a membership fee - we're worried this will confuse people, even though it will of course say £0.00, because they are not paying anything.

Any tips on how to edit this page? And apologies if it's glaringly obvious ;)


texts: How can I generate a report for the financial transaction entered by USERS of certain "drupal Role"?

texts: Finance department wants a weekly report of contributions taken by our shop. I have set up a drupal user role called "Shop" and permissions accordingly, and added staff to that role. But cant figure out how can I generate the report for the contribution specifically created  by those staffs of “SHOP”. Any help would be appreciated. Thanks


texts: Managing multiple CiviCRM relationships in a Drupal View: A case study for A->C plus B->C relationships

texts:
Here is the fruit of my journey so far with multiple CiviCRM relationships in Drupal Views.

My original question that sparked this question is here:
How to create a drupal 'contact me' link where the user is a contact reference field of Contact B in a civi relationship

I wanted to create a landing page for each organisation where my gang has members, so I needed a single Drupal View that would do three things:

Display fields from an organisation (name, logo, motto, website, etc.)
Display a list of members of the organisation (photo, name, etc.)
Link a 'Campus contact' person for the organisation to its Drupal user, so that I could create a 'Contact me' link using the built in Drupal Contact module

With Point 3, the real issue is how to expose the fields of that 'Campus contact' person to the view, so that I could rewrite their name as a link like 'user/[drupal_id]/contact' in order to open a contact form.  That is, I needed the Drupal user ID of the Campus contact person.

The basic problem is how to expose the data from three different, but related, CiviCRM contacts in one view.

In my case, the arrangement of the relationships is A->C and B->C.  I have two different contacts related to the same organisation each by a different relationship.

For a quick and dirty tutorial for handling a chain  of relationships, like A->B->C, e.g. Parent->Child->School, see petednz's answer here:
How to create a Drupal View with multiple CiviCRM relationships?

If you struggle to connect all those dots because of certain gaps in your understanding of how CiviCRM relationships work, either in Civi itself or in Views, then I recommend you come back to my answer here, as I intend to make the background and logic explicit, before following those instructions.  Hopefully, with the information below, you will be able to customise your own views to suit your own specific needs.

Okay.  Have to run.  I will get around to the answer about 5 hours from now.  Hold tight!


texts: Why does a user get 'email field required' after submitting a form such as a Contribution page

texts:
If a Contribution page has a profile that creates a Drupal User, then the user gets a message after submitting the form that 'email is required' and no Drupal user is created.

Not sure if this is only affecting Drupal.


texts:
I have a bunch of certificates which are scanned as images that needs to be uploaded into the correct record to be attached in the Certificate file field.  Can this be 'imported' like how you can import data into CIVICRM contacts ?  Thanks.

Clement


texts: Why is a contribution given a financial type different from that allocated to the contribution page used?

texts:
I have a contribution page, utilising Paypal standard, set up to handle a membership renewal. The page has a 'renewal' financial type set for it. However, if I initiate a contribution using this page, the resulting contribution record shows as having a different financial type ('registration').

I've come across this because I'm trying to debug a situation where users are reporting that they have made a payment via Paypal (and have sent me the Paypal receipt to prove it), but no contribution record exists for this transaction. The Paypal receipt includes information that strongly suggests that CiviCRM is sending data to Paypal, but as no contribution record exists in the Civi database to link to the receipt, I can't be certain.

Clearly something is not as it should be. I'm using Civi 4.6.10 currently and about to update to latest 4.6.x

Is this a known issue? How can I begin to debug this?


texts: DataTables Warning: Cannot view Activities after upgrade to 4.7.28

texts:
I cannot view Activities on a Contact's Activities Tab, or my activities on my CiviCRM Dashboard. In both cases I receive the following error:

DataTables warning: table id=DataTables_Table_0 - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1

I am using CiviCRM 4.7.28 in Wordpress 4.9.1. I have the following Extensions active in CiviCRM:

iATS Payments 1.6.1
Summary Fields v. 3.1.1
Extended Report v. 3.0
Displays relationships in the contact summary v. 1.2
Mailchimp v. 2.0.1


texts: Detailed Contribution Info Not Displayed

texts:
CiviCRM Version: 4.6.15
CMS: Drupal 7.43

I'm running into a weird bug and I'm not sure how to track it down. All of our old contributions (Pre 2014) don't show when you click on the the [contact] > [contributions] tab. It shows that they have made a contribution but doesn't list the detailed information.

I can confirm the data is in the civicrm_contribution table in our database. Is there anywhere else I can check?

Thanks


texts: How to pass custom variables to BillingBlock.tpl?

texts:
I found that the BillingBlock.tpl is included in Main.tpl file and all the variables are assigned to this templates using Main.php file. I can hardcode the variable there but I am worried about if there is another core update. So I am trying to override the Main.php file from my custom extension but it's not happening.

My question is how do I override the Main.php file in civicrm from custom extension ( custom payment processor ) or if there is other method built in civicrm with which I can pass variable to Main.tpl or BillingBlock.tpl.

P.S. I followed the same directory structure as of core.

customextension
├── CRM
   └── Contribute
       └── Form
           └── Contribution
               └── Main.php


texts: Webform Integration - Permission level for viewing the civicrm contact name column

texts:
Just curious if anyone using Drupal and the Webform integration has come across this:

When viewing results as an admin, I can see clickable links to the Civi individual who filled out the form - it's great! But I noticed that not all my users can see data in that column (they see the column it's just empty.)

If you click the view button for a submission, they can see (and click) the Civi Individual - but that same info does not show up on the list of completed submissions.

After some testing, I found that you have to give user the permission set "Edit All Webform Submissions" which is a little awkward. I just want this user set to VIEW the name of the person who completed the form and be able to click right over to civi (without having to open each survey).

Drupal 7.41 Webforms Civi 7.x.4.11

Any advice on how to accomplish this? Does it perhaps not behave this way in a future version?


texts:
in general, I am not using the print icon from CiviCRM because (1) it doesn't print nicely and (2) when printing a contact page with a custom field tab, the icon prints the summary page.

Therefore, I've decided to hide the print icon and use the regular "File - Print" path. I noticed that when printing datatables with multiple custom fields set which allows multiple records for a contact, the tables extend beyond the container. When I look into the code, I see:

...

I can't seem to find the file where I can change "width: 1399px" to "width: 100%."


texts: Mail not working url for third party app

texts:
I’m doing a basic automation with scheduled reminders: I want to send a survey to every one where a certain activity is completed.
For the survey I use a nice third party app: surveypal.com. As I want to personalise the survey, I need personal data from civi to surveypal to identify the response.

Surveypal has nice documentation on how to do this. The url send to a potential respondent should look like:

https://my.surveypal.com/app/form/ext?_d=0&_sid=261570634&_k=2kpdVu0Y20GKuXoMnpsCYQ6c43g82T4PWT29J4Kj5TFRIBltoKRMpAng0p
iVLOtX&externalId=[ID]&meta=[{"key":"Gender","value":"Male"},{"key":"Age","value":"15"}]

where sid and k are the id’s of the survey in surveypal, externalID could be the contact_id from civi and the data in meta data could be other civi fields.

Building a message template in civimail, including some tokens for the personal data, this url so becomes:

https://my.surveypal.com/app/form/ext?_d=0&_sid=xxx&_k=xxxxx&externalid=[{contact.contact_id}]&meta=[{"key":"email","value":"{contact.email}"},{"key":"SRdonorcontactid","value":"{contact.contact_id}"},{"key":"firstname","value":"{contact.first_name}"},{"key":"lastname","value":"{contact.last_name}"},{"key":"Aanspreking","value":"{contact.addressee}"}]

When sending manually this message template using an individual email (activity -> send an email). This works perfect. Civi does send an email to the particular contact, and the person gets a nice link, participates the survey in surveypal and I have all the response data I need.

But, when I use this same message template to set a scheduled reminder link to an activity, then the email is send automatically correctly, but the url is changed towards something like &meta:[,,,,,,] So no personal data is transferred. The potential respondent gets an error message when clicking the url that the url does not exist.

Any idea’s: what happened, what is wrong?
I’m afraid it has something to do with the {} used for tokens in civimail, while used to group data in the surveypal-url.


texts:
The CiviCRM (4.7.14) membership sign-up page for our website will not always connect to Paypal (standard), our payment processor.  Sometimes it works, mostly not.  In Firefox, the error message is: "The page isn’t redirecting properly Firefox has detected that the server is redirecting the request for this address in a way that will never complete. This problem can sometimes be caused by disabling or refusing to accept cookies."  I have checked settings in CiviCRM and with Paypal, and everything looks OK as far as I can tell. Looking for help to get this issue fixed.

Our site is on Joomla 2.5.20 and appears to be up to date. To the best of my knowledge, the connect to Paypal worked fine until about 6 months ago. Since then, CiviCRM was updated to 4.7.14. The problem is not unique to Firefox; complaints also come from people using Edge, Chrome, Safari in different countries all around the world. Doesn't seem to be a difference for a logged-in user or non-logged-in visitor.


texts:
i (Austrian based company) am looking for a CIVI-CRM-Expert in Europe (preferred) for helping with various implementations on a basic level  (customizing invoices, create profiles for a kind of portfolio of members...)

Please send your references and rates to gerald.koellersberger@k-con.net

I am looking to hear from you!

Gerald


texts: How to insert a CiviCRM query link into Drupal main menu with Clean URLs enabled?

texts:
How do you add a CiviCRM query link such as:

index.php?q=civicrm/member/search&force=1&qfKey=0&reset=1

Into a Drupal main menu with Clean URLs enabled?

With Clean URLs enabled, Drupal will strip out the ?q=, breaking the link.

Desired outcome:
Drupal main menu.
Menu item "Members".
URL to "civicrm/member/search&force=1&qfKey=0&reset=1"


texts: I'm on Drupal 7 and Civi 5.9.0. I went and got a copy of the extension straight from GitHub. There is says they recommend using version 5.0+, even though the page on the Civi site says it's compatible with 4.7 only. I uploaded everything, but it's still not available to enable. Is it really only working on 4.7? This is listed as how Spark is setup and we'd like to be able to use that new look for our site as well.


texts: Anonymous user cannot see contributionpage fields in Wordpress

texts:
We have a new wordpress site and have added a basic (to paypal) donation page- worls fine when logged in. but the contribution amount fields aren't showing for anonymous users.
Anonymous user view

Same page but logged in

Anonymous users have permissions to:

make online contribution
create in profile
view profile listings and
forms access all custom data

Anything we've missed?


texts:
I'm on Drupal 7 and CiviCRM 5.10 (yes, I'll update to 5.12 this weekend). I have a case with multiple case status: Active, Maintenance, Closed. When case activities are entered in the system, it doesn't seem to save the case status at the time the case activity is entered. For example:

4/26/19 Case Opened
4/26/19 Client meeting
4/28/19 Case status changed from active to maintainence
4/30/19 Housing visit
4/31/19 Housing visit

If I were to create a Views report of the case activities, I see that the case status for 4/26/19 is labeled "Maintenance" but it should "Active" (which is the case status at the time it was entered).

Does anyone know how I could create a report and pull the case status AT the time of the activities entry?


texts:
CiviCRM 4.6.4 With Joomla.
I mass mail are successfully sent. But I do not receive neither bounces nor notification of bounces. Some wrong or non existent mail addresses are used as a test.
Here following my settings:

The mail server of my provider is able to manage bounces.
Could you help me to configure both the mail server and /or CiviCRM?
Thank you.


texts: How to add validation to the 'Add Case Role' option in Case Summary View?

texts:
I have a customer where it is vital that there is only one Case Role on a case. In the CaseView form it is possible to add a case role, and I want to add some validation to this.
in core actual processing is done in a jQuery function, with the callback function at CRM_Contact_Page_AJAX::relation.

I can do nothing with a validateForm hook here, so what I am planning to do is:

create a 'dummy' page with my own version of CRM_Contact_Page_AJAX::relation with the desired validation included
replace the template for CaseView with a local version, linking to the new function with the alterTemplate hook

Unfortunately this solution is not viable for a true generic extension. Any better ideas? If not, I will add the instruction to the README and still publish the extension as it might be useful for others too but I wonder if there is a better way.


texts: CiviCRM and GDPR Subject Access Requests

texts: Most ongoing GDPR matters are handled by the GDPR extension kindly provided by Veda Consulting, but there seems to be nothing available to deal with a GDPR Subject Access Request (SAR--effectively a dump of all data held on an individual). Perhaps I am missing something, but I don't see any way of doing this easily. Has anyone had to deal with a SAR in CiviCRM and have some suggestions? (We are not facing this immediately, but one wants to be prepared.) Thanks.


texts: Embed webforms into site that is custom php

texts:
Our site is all custom php/html.  It is not built using tools like Joomla or Drupal.

Is it possible to embed webforms directly into our site?


texts:
Is there a way in which I can easily see how the smart groups are related (as in include / exclude search)?

When I try to build a group which selects the contacts I need, I often combine multiple smart groups to arrive to necessary results. It would be very convenient to see how they are related. Is there an easy way to tell, if a particular group is used in some other group (so that it could be modified or deleted without worry)? Or should I check all other groups to make sure that none of them actually uses the group I am about to delete/modify?


texts: What do I do to fix Civi Bounce Reasons that appear in strange (chinese?) character set?

texts:
Here are bounce reasons - any ideas on where these might be coming from?  it happens consistently.

Contact ID  Bounce Reason   Bounce Type
21  潙牵洠獥慳敧琠桴潦汬睯湩敲楣楰湥獴挠湡潮⁴敢搠汥癩牥摥਺ †樠桯慮湲汯楤獮慀汯挮浯ਊ敒潭整猠牥敶⁲敲畴湲摥琠敨映汯潬楷杮攠牲牯਺ †㔠〵䴠楡扬硯甠慮慶汩扡敬桔    Syntax  j
58  潙牵洠獥慳敧琠桴潦汬睯湩敲楣楰湥獴挠湡潮⁴敢搠汥癩牥摥਺ †搠祯楫楩祀桡潯挮浯ਊ敒潭整猠牥敶⁲敲畴湲摥琠敨映汯潬楷杮攠牲牯਺ †㐠ㄲ匠牥楶散渠瑯愠慶汩扡敬汣獯湩    Syntax
294 潙牵洠獥慳敧琠桴潦汬睯湩敲楣楰湥獴挠湡潮⁴敢搠汥癩牥摥਺ †樠㑷楬歮䁳慹潨⹯潣੭刊浥瑯敳癲牥爠瑥牵敮桴潦汬睯湩牥潲㩲ਊ††㈴‱敓癲捩潮⁴癡楡慬汢ⱥ挠潬楳    Syntax
448 潙牵洠獥慳敧琠桴潦汬睯湩敲楣楰湥獴挠湡潮⁴敢搠汥癩牥摥਺ †猠慰獴晪祀桡潯挮浯ਊ敒潭整猠牥敶⁲敲畴湲摥琠敨映汯潬楷杮攠牲牯਺ †㐠ㄲ匠牥楶散渠瑯愠慶汩扡敬汣獯湩    Syntax


texts: Thinking of Creating MobileAPP for CiviCRM

texts:
I am thinking of creating a MobileAPP for CiviCRM using IONIC Framework

Before I start just need to ask. Do we have any MobileAPP that works for CiviCRM? (I know we can view on mobile phone using themes)

Also Need some help for my first Phase- (everything will only be read only)

I am thinking of displaying - Contact, membership and contribution details

What are the details we can display?

I am thinking of releasing the Mobile APP to community

Any suggestion / comment will be much appreciated

Thanks


texts: Problem with imported case activities not appearing in the case record

texts: Identical issue to: https://forum.civicrm.org/index.php?topic=32904.msg140249#msg140249 which was never solved. Manually inserted a case with all of the tables mentioned in the post, yet it doesn't appear under job search in CiviCRM. They show in the database, but the GUI is blank.


texts: Webform mails are uncomplete and go to spam

texts:
I use a lot of webforms which send mails when completed
I have just upgraded to 5.24.4, and since then :

the mail goes to spam
subject is empty
tokens are empty : I get :

Submitted on

Submitted by user:

Submitted values are:

The results of this submission may be viewed at:

Any help is welcome


texts: My Summary Overlays are bad after upgrading to 4.7

texts:
On two separate sites that were upgraded to 4.7, the "Summary Overlay" function seems to have been uglified.

Specifically - in the past, when hovering over the person icon on the left of many contact listings, you would get a nice little black-background pop-up with additional information about the contact.

Now, those popups are filled with what appears to be a collection of many profiles.

There is a reserved Summary Overlay profile, that I would assume is the only one that should display here.

On a new 4.7 install, I am not seeing this issue.

Am I missing some undocumented configuration, or is this a bug?


texts: What are these symbols on the batch entry screen?

texts:
I am updating the contributions chapter of the user guide so I am examining in detail funcionality that I don't necessarily use every day.

To the left of the contact field in the batch entry there are some symbols. Should they be there and if so what are they for?  They are not really obvious unless you magnify the image, but there was enough there when unmagnified for me to investigate further.


texts: How to find members who have more than X years of total membership

texts:
What's the best way to calculate the total number of years/days that a contact has been a member?

For example, say I want to find people who have been a member for more than 10 years, taking gaps into consideration.

I was thinking of a combination of the "civicrm_log_membership" table with a custom field, or maybe the summary-fields extension. By having it in a custom field, it would be easy to expose to the search/reports, and it could be regularly updated using a Scheduled Job.


texts: Mixing Contact sub-type with Individual data in Profile?

texts:
I have a profile containing first name, last name, employer, and contact sub-type.
When I load the profile in the front-end and click on search, I'm able to see everyone.
On the first screen, I'm able to search and filter by first name, last name, and employer but not with Contact Sub-Type. It returns "No matches found for:"

Once I'm on the page with the error, I can't do any search. I have to go back to the first page.

This issue is similar to what is described here. But while they were able ti duplicate the error in WP, The same setup is working fine in Joomla Demo site.

I'm not sure what I'm doing wrong.

Update:
I noticed that the value for "contact_sub_type" in the URL contains a "%01" before and after:
&contact_sub_type=%01Delegate%01
The other fields don't have anything:
&current_employer=schoolname


texts:
We had this issue activating CiviCRM

Warning: require_once(CRM/Core/ClassLoader.php): failed to open stream: No such file or directory in /home/capitaleventscom/public_html/wp-content/uploads/civicrm/civicrm.settings.php on line 462

Fatal error: require_once(): Failed opening required 'CRM/Core/ClassLoader.php' (include_path='.:/home/capitalevents/public_html/wp-content/plugins/civicrm/civicrm/:/home/capitalevents/public_html/wp-content/plugins/civicrm/civicrm//packages:.:/usr/local/php56/pear') in /home/capitaleventscom/public_html/wp-content/uploads/civicrm/civicrm.settings.php on line 462

then followed by this when using a fresh download:

Could not extract file from archive. civicrm/civicrm/packages/kcfinder/themes/dark/img/files/big/..png

Any ideas?


texts: API: Update a specific multi value field set record

texts:
I created a custom field set with three fields, the field set does allow multiple records. The aim of this field set is to collect data about candidacies and mandates of politicians, such as the parliament name, the party/ fraction and the election result. One politician can have more than one of these.

I now want to update a specific record when it exists. I find out by calling the API:

   $result = civicrm_api3('Contact', 'get', [
      'sequential' => 1,
      'return' => ["custom_102", "custom_101", "custom_103"],
      CiviCRMFields::CANDIDACY_MANDATE_ID  => $id
    ]);

This only returns the contact when the contact has a candidacy/ mandate record with id $id. When I then set the fields "custom_102", "custom_101" or "custom_103" with the new data, a new record is created:

 $result = civicrm_api3('Contact', 'create', $this->contactValues);

where $this->contactValues includes all the values returned by the preceding API call. As these values include the id of the record in the field set table I thought it would be clear that this record needs an update but CiviCRM keeps creating additional new records.

How can I update this specific record???

Best,
Tobias


texts: How can I see the quota (number of participants which can still register) under the manage events section?

texts:
How can I fetch the number of participants(quota) who can register for an event and
the max number of participants in an event  if the event has not started on the manage events


texts: CiviCRM 4.7 - DB Constraint Violation - possibly dashboard_id should possibly be marked as mandatory for this API

texts:
We have moved our hosting to  new hosting provided (CiviHosting). CiviHosting installed a fresh installation of CiviCRM 4.7. We then imported our previous sql dump from our old site which also had been upgraded to 4.7. The import was done via c-panel. After the import, we get this error when running CiviCRM:

CiviCRM_API3_Exception: "DB Constraint Violation - possibly dashboard_id should possibly be marked as mandatory for this API. If so, please raise a bug report."

#0 /home/iskcon/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/Dashboard.php(125): civicrm_api3("DashboardContact", "get", (Array:5))
#1 /home/iskcon/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/Dashboard.php(158): CRM_Core_BAO_Dashboard::getContactDashlets()
#2 /home/iskcon/www/www/wp-content/plugins/civicrm/civicrm/CRM/Contact/Page/DashBoard.php(47): CRM_Core_BAO_Dashboard::getContactDashletsForJS()
#3 /home/iskcon/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(312): CRM_Contact_Page_DashBoard->run((Array:2), NULL)
#4 /home/iskcon/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:13))
#5 /home/iskcon/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:2))
#6 /home/iskcon/www/www/wp-content/plugins/civicrm/civicrm.php(1227): CRM_Core_Invoke::invoke((Array:2))
#7 [internal function](): CiviCRM_For_WordPress->invoke("")
#8 /home/iskcon/www/www/wp-includes/plugin.php(524): call_user_func_array((Array:2), (Array:1))
#9 /home/iskcon/www/www/wp-admin/admin.php(222): do_action("toplevel_page_CiviCRM")
#10 {main}

How do we go about importing our previous database to the new installation? I would appreciate a simplified explanation of the steps to resolve this.


texts: Connecting Civi to a previous install's database

texts: During my update from Civi 4.2 to 4.7 I let it fill in database information that was not correct it connected to the cms database and not the Civi database from the previous install. Is there a file I can edit to have it connect to the old database?


texts:
I am trying to create an event (that includes a fee) but for some reason every  time I click on "Info and Settings," it shows me the following:

"Sorry but we are not able to provide this at the moment.
You do not have permission to access this page
Return to home page."

I tried numerous times to create the event, and everything looked fine until it didn't show up in my wordpress form dropdown, and I couldn't insert it onto my website. When I went back, that's what it showed me. Please help!!! I am not experienced with Civi and feel like its a glitch in their system because the system just goes crazy on me every time I click something. Thanks!


texts:
I tried upgrading to 5.24 and it hung half way through the upgrade - while upgrading to 5.24alpha1.  Here's all that was in the log - it then died. I've gone back to 5.23.4 (Drupal).  Ideas?

Apr 02 09:21:30  [info] Running task: Cleanup old files

Apr 02 09:21:31  [info] Running task: Checking extensions

Apr 02 09:21:31  [info] Running task: Begin Upgrade to 5.24.alpha1

Apr 02 09:21:32  [info] Running task: Upgrade DB to 5.24.alpha1

Apr 02 09:21:33  [info] Running task: Upgrade DB to 5.24.alpha1: SQL

Apr 02 09:21:34  [info] Running task: Install sequential creditnote extension


texts:
Just want to throw this question here so the answers can be easily found by people who met similar problems.

Problem came up when we were trying to test some new mailing services with CiviCRM 4.7, we kept getting "connection refused" errors and other similar messages with different protocols and ports entered in outbound mail settings.

The environment we have: Ubuntu 14.04, php 5.6, Drupal 7.3.x, CiviCRM 4.7.x.


texts:
I am looking for users of CiviGrant who use CiviGrant to administer grants once they have been awarded. We are a new(ish) grant-giving body who already use Civi for managing events and grant applications, and are considering extending our Civi use beyond the application and decision-making stages.

I am looking for organisations who would be willing to talk to us about how they use the CiviGrant system, and what advice they would give. All info would be in confidence.


texts: Wordpress install - problems in getting to Administrative Panels

texts:
I have been struggling to get my initial install to work. All seemingly went well with the instal. I am sure it must be a very basic setting I have wrong.

When trying the Wordpress dashboard link to CiviCRM panel, I got a base_dir problem where I applied the recommended "fix" of adding a line to CiviCRM setting to force directory to my base wordpress instal. This progressed me a little further.

After that, now receiving ...
Fatal error: Uncaught CiviCRM_API3_Exception: [unknown error: DB Error: unknown error thrown in /home/…/wp-content/plugins/civicrm/civicrm/api/api.php on line 45

Thinking of abandoning CiviCRM as a Wordpress option for my needs. The install seems to be problematic.

However, if anyone is willing and has the time to work with me to resolve the issues, I am really keen to use the product and willing to give it a good crack :)

Cheers,
Garry


texts: Opt out by email -- return address doesnt exist

texts:
I am testing our ability to include opt-out as well as unsubscribe by email options to a bulk email newsletter.

When I try to opt-out/unsubscribe from a test message (as recipient) using the provided email address (e.g., u.2679.86732.92da29cb61fe154d@my_organization), I receive another email indicating the opt out address does not exist.

Can anyone help me understand why this error occurs and how I can correct it?

Thanks in Advance!


texts: Accessing Event details not possible anymore (Frontend)

texts:
Joomla 3.8.2 and CiviCRM 4.7.27

I got recently some user reply's that the event details con not be accessed anymore, thus no event regi, stration is possible.The event list is visible in the frontend, but clicking the "Event Name" or "read more" results in:

CiviCRM-001
Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
API permission check failed for Event/get call; insufficient permission: require access CiviCRM and access CiviEvent and view event info

This error may be related to an update, however I can not determine which one as the feedback was not immediate. I checked the access rights for civiEvent listing and registration, they are still set to public, nothing changed there.

May be a bug... Anybody who has a suggestion where to start?

Currently I cant find the error report ... sorry

Thanks for your input

Joomla shows in debug mode:
Call stack

Function    Location

1   ()  JROOT/libraries/legacy/error/error.php:200
2   JError::raise()     JROOT/libraries/legacy/error/error.php:277
3   JError::raiseError()    JROOT/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php:468
4   CRM_Core_Error::handleUnhandledException()  JROOT/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:55
5   CRM_Core_Invoke::invoke()   JROOT/components/com_civicrm/civicrm.php:96
6   civicrm_invoke()    JROOT/components/com_civicrm/civicrm.php:11
7   require_once()  JROOT/libraries/src/Component/ComponentHelper.php:381
8   Joomla\CMS\Component\ComponentHelper::executeComponent()    JROOT/libraries/src/Component/ComponentHelper.php:356
9   Joomla\CMS\Component\ComponentHelper::renderComponent()     JROOT/libraries/src/Application/SiteApplication.php:194
10  Joomla\CMS\Application\SiteApplication->dispatch()  JROOT/libraries/src/Application/SiteApplication.php:233
11  Joomla\CMS\Application\SiteApplication->doExecute()     JROOT/libraries/src/Application/CMSApplication.php:267
12  Joomla\CMS\Application\CMSApplication->execute()    JROOT/index.php:49


texts: Is there any way to audit which admin merged duplicate contacts? I'd like to know who performed the merge, if possible.  Thanks.


texts: No Google Groups showing up after setting up Googlegroups Sync extension

texts:
I think I have the connection with Google established. At least, Mailings/Googlegroup Settings confirms that I am connected. When I go to Manage Groups and select a group so I can set the Google Group to sync with, the Google Group box is blank. No groups to select.

Would appreciate it if anyone had any ideas for solving this.

Thanks!

Drupal 7.4
CiviCRM 4.6.11


texts:
Is it possible to import a list of contacts (name and email address only) from a google spreadsheet to the database and start a new email group containing only those addresses?

Thanks


texts: How to add a class to a form element in buildQuickForm?

texts:
From a user perspective, the 'How many people are you registering?' input, on the event registration form for multiple participants, is a required field. Therefore, it should have the red asterisk for continuity.

However, we can't just add the 'required' formRule to the element, because behind the scenes a '1' is a value of nothing (ie: no additional participants).

So what's the easiest way of adding the 'required' class to the element, without adding the form rule itself? It would be great to push this back to core, rather than us just overriding it in our CSS, even though it is a super-trivial improvement.


texts: How can you edit the end date for an auto-renew membership?

texts:
I am working on a website that has the option for members to pay for membership by direct debit (via GoCardless). This is working fine but occasionally we have an issue where a member pays by direct debit and also by card. We refund the card payment to the member but the membership end date is incorrect and we are unable to edit it.

The membership is annual so if a member signs up by both direct debit and card the two payments will add two years to the end date (e.g. it will be 2021 rather than 2020). So, after we refund the card payment we want to also edit the end date to change it to 2020. Unfortunately, we are unable to do this.

Normally, you can edit the end date, as shown below:

It appears that if the membership is set as auto-renew and linked to a recurring payment then CiviCRM doesn't allow you to edit the end date. I presume this is a deliberate 'feature' but in our case it is preventing us from correcting the end date.

How can we edit the end date in these circumstances?

CiviCRM 5.7.6 on WordPress


texts: How do I set access control so I can get Batch entry? It's not showing up

texts: Batch Entry is not showing up for us.  I've been told it might be something with access control however, I need help figuring out who I look at access control to turn this feature on.  I do have a version of Civi that has the feature (CiviCRM 4.2.7.) so I know it's available.  Can anyone help me figure this out so I can use the feature for recording donations?  Thank you.


texts: Cannot get the import of employer-employee relationship to work

texts:
I have successfully imported all my organisations and I'm now trying to import my contacts which are employees of these organisations. I've read the relevant sections in the CiviCRM cookbook and the CiviCRM online manual, but I can't get it to work.

I can import all contacts without a problem (around 3000 but have been playing and testing with just 10) but the relationship to the employer is never okay. Though i always checked "employee of" " organisation name match to contact".

*I get this error too when importing: *"Warning: explode() expects parameter 2 to be string, array given in CRM_Contact_Import_Parser_Contact->import() (line 854 of /home/kasomk/www/www/sites/all/modules/civicrm/CRM/Contact/Import/Parser/Contact.php)."**

I've tried everything, been at it all (sun)day. So please help me! Who has a comprehensive step by step guido on how to import relations? Which fields need to be imported on which import, which duplicate checking should I do and how can i successfully import the relationships?

Kind regards
Stefan


texts:
trying to implement the following workflow - New Organisation Membership approval in CiviMember creates OG in Drupal called after Org, with Org drupal account as OG admin.
 I'm looking at maybe using Rules, but I'm a bit new to the module, any tips appreciated.

CiviCRM 5.3.0 Drupal 7.59


texts: Can I offer different pricing for an event based on user group?

texts:
I have an event in CiviEvent that should be a paid event for some of our user base but should be a free event for other users.

Presently the users are grouped using smart groups, but I could also create a membership if that would be more helpful.

The main question is how do I structure my price sets so that one price set is offered to one type of user, but a different price set (or no price set) is offered to a different type of user?

I thought it would be possible to create different price sets and only make them available to different user types, but I haven't figured out how to do that.

I also thought about using a cividiscount code, but the challenge is that I don't want people to share the discount code.  (Is there a way to make a discount code limited to a certain user group?)

Thanks for any thoughts.


texts: How do I add CiviCRM Activity attachment to View

texts:
Trying to set up an activity view that displays attachments uploaded to activities.

I can't seem to find the field to add.

Any ideas?


texts: How hard is it to obtain PCI compliance?

texts:
I want to preface this by saying that I am aware that no one here can tell me authoritatively whether I am PCI compliant, since only licensed people can do that.

Instead, I'm asking what your experience was in seeking out compliance. My site is run on Drupal 7, CiviCRM 4.6, and we use Authorize.net for our payment processor. We have SSL. Do you have any helpful intel on how hard or easy this will be for us?

edited to add: We are hosted by CiviHosting


texts:
I am in need of Use-Case diagram, UML diagrams for CiviCRM. Not because I am very much need of them to use CiviCRM. just to show something in my presentation to my management :) !! . Any pointers would help .

(ER diagram different from UML/Use case diagrams)


texts:
after update to 4.7.5, the "manage Groups" page just says "No groups have been created for this site".

Although the groups are functioning otherwise.

This also happens on the sandbox/demo site.


texts:
Drupal 7.32, Attempted install of CiviCRM 4.6.9.
I do not yet have direct access to the server or database, that power rests in another's hands.
Installation goes off without a hitch, all requirements clear and the 'Modules' overlay confirms CiviCRM is installed.
Any attempt to enable CiviCRM produces the error:

  (Currently using CiviCRM settings does not exist CiviCRM settings
  file does not exist. It should be created by CiviCRM install)

It refuses activation.


texts: How can I display message after form submission

texts:
I have created CiviCrm profiles. How can I display a message when user submits the profile?
First It should display a message (pop or alert) and then redirect to another page.


texts:
I am getting the following error on a Stripe page that is set up to handle recurring membership contributions.

I'm wondering if people have seen this before and if anyone has pointers on what the solution might be.

Error Oops! Looks like there was an error. Payment Response:
Type: invalid_request_error
Code: resource_already_exists
Message: Plan already exists.

I saw that there is a plan_id column in civicrm_stripe_plans but am not familiar enough with Stripe to know what to do with it (and Googling didn't turn up very much).


texts:
I have set up report to list the number of active cases, however the report doesn't show anything when I refresh results, even though there is a number of opened cases which show in the Case dashboard.

Any idea why this might be not working?

I am running version 5.13.1 on Wordpress

I added the code for the report (Developer Tab)

Class used: CRM_Report_Form_Case_Summary

SQL Modes: NO_AUTO_CREATE_USER NO_ENGINE_SUBSTITUTION

SELECT SQL_CALC_FOUND_ROWS c2_civireport.sort_name as civicrm_c2_client_name, c2_civireport.id as civicrm_c2_id, case_civireport.id as civicrm_case_id, case_civireport.subject as civicrm_case_subject, case_civireport.status_id as civicrm_case_status_id, case_civireport.start_date as civicrm_case_start_date, case_civireport.end_date as civicrm_case_end_date, IF(case_civireport.end_date Is Null, '', DATEDIFF(case_civireport.end_date, case_civireport.start_date)) as civicrm_case_duration

FROM civicrm_contact contact_civireport
inner join civicrm_relationship relationship_civireport on contact_civireport.id = relationship_civireport.contact_id_b
inner join civicrm_case case_civireport on case_civireport.id = relationship_civireport.case_id
inner join civicrm_relationship_type relationship_type_civireport on relationship_type_civireport.id=relationship_civireport.relationship_type_id
inner join civicrm_case_contact case_contact_civireport on case_contact_civireport.case_id = case_civireport.id
inner join civicrm_contact c2_civireport on c2_civireport.id=case_contact_civireport.contact_id

WHERE case_civireport.case_type_id  REGEXP '[[:cntrl:]]*3[[:cntrl:]]*' AND ( case_civireport.status_id IN (1, 3) ) AND ( case_civireport.is_deleted = 0 )

ORDER BY case_civireport.start_date ASC

LIMIT 0, 50


texts: There is some inconsistent/confusing workflow managing contacts from smart groups?

texts:
CiviCRM allows add and remove contacts from smart groups. This is an useful functionality that allows us to cover some cases managing groups.

However this functionality often leads to confusion among users that found a group with a mixed contacts that have been added and removed manually and others that meet the search criteria of the smart group. It might be useful if the system somehow warned when you are adding or removing contacts on a smart group?

Despite this, since the time you can add or remove a contact to a group there should have the possibility to manage this membership from the contact summary group tab in the same way that can be made with regular groups. I seem to recall that this possibility had existed in the past, but maybe I'm wrong.

I'm right or I'm missing something?

Because of this non covered functionality I've gone crazy more than once looking why a contact appeared on a group if in their sumary contact group tab there is no information about if it has been added manually or by a smart search criteria.


texts: Why is date_created field is ignored for Contact creation via API?

texts:
when I attempt to import historical data to seed the CRM, created_date is ignored and today's date/time is used instead. Using the API explorer, it looks like the date should be saved, but, when I do a subsequent get, it has today's date:

https://somewhere.com/sites/all/modules/civicrm/extern/rest.php?entity=Contact&action=create&api_key=userkey&key=sitekey&json={"contact_type":"Individual","created_date":"2018-01-01","first_name":"Peteww"}

returns:
{

"is_error": 0,
"version": 3,
"count": 1,
"id": 288,
"values": {
    "288": {
        "id": "288",
        "contact_type": "Individual",
        "contact_sub_type": "",
        "do_not_email": "",
        "do_not_phone": "",
        "do_not_mail": "",
        "do_not_sms": "",
        "do_not_trade": "",
        "is_opt_out": "",
        "legal_identifier": "",
        "external_identifier": "",
        "sort_name": "Peteww",
        "display_name": "Peteww",
        "nick_name": "",
        "legal_name": "",
        "image_URL": "",
        "preferred_communication_method": "",
        "preferred_language": "en_CA",
        "preferred_mail_format": "",
        "hash": "74c74a58f64681a6e3a4f8d9ccd32bfd",
        "api_key": "",
        "first_name": "Peteww",
        "middle_name": "",
        "last_name": "",
        "prefix_id": "",
        "suffix_id": "",
        "formal_title": "",
        "communication_style_id": "1",
        "email_greeting_id": "1",
        "email_greeting_custom": "",
        "email_greeting_display": "",
        "postal_greeting_id": "1",
        "postal_greeting_custom": "",
        "postal_greeting_display": "",
        "addressee_id": "1",
        "addressee_custom": "",
        "addressee_display": "",
        "job_title": "",
        "gender_id": "",
        "birth_date": "",
        "is_deceased": "",
        "deceased_date": "",
        "household_name": "",
        "primary_contact_id": "",
        "organization_name": "",
        "sic_code": "",
        "user_unique_id": "",
        "created_date": "20180101000000",
        "modified_date": ""
    }
}

}

but when I do:

https://somewhere.com/sites/all/modules/civicrm/extern/rest.php?entity=Contact&action=get&api_key=userkey&key=sitekey&json={"sequential":1,"return":"created_date","id":288}

I get:
{

"is_error": 0,
"version": 3,
"count": 1,
"id": 288,
"values": [
    {
        "contact_id": "288",
        "created_date": "2019-04-15 18:00:01",
        "id": "288"
    }
]

}


texts:
I have a very simple use case for Smart Groups. I have only two small Smart Groups that are both used exclusively for bulk mailings, once or twice per month:

All Individual Contacts: approximately 800 contacts
All Current Members: approximately 80 contacts

From what I've read, I'm thinking I probably don't need caching. Is it safe to disable the Rebuild Smart Group Cache scheduled job and set the Smart group cache timeout to 0?


texts: CiviCRM Membership form Renewal text not displaying

texts:
I have a question about the functionality of membership forms for renewals.

We've got our CiviCRM membership form set up with both new membership and renewal text/copy:

As I understand it, it's the same page that changes title/text based on the member status.

I can't for the life of me get this renewal title/copy to appear on our membership page. Does anyone know how this title/text change is triggered?
Does it appear because of a membership status eg 'grace'/'expired'?
Would it appear with a membership status as 'current' but nearing the end date of the membership?

Thanks for any suggestions!


texts: dedupe rule using birth date is not working using drupal

texts: A dedupe rule using birth date is not working with drupal CMS. I receive the message "unknown error, please contact your administrator". The rule is working well in WordPress


texts:
During testing of sparkpost we are getting into the inbox with gmail, yahoo and aol, but not with microsoft. We are getting an 8 on microsoft's bulk complaint level which AFAIK is associated with the IP used.

We are evaluating either switching to a dedicated IP or switching to another service provider on a shared IP.

One thing that puts us off a dedicated IP is the extra admin that would be involved in keeping the IP off blacklists. Some blogs also mention that you need a certain amount of traffic to maintain sender reputation (though they are vague on how much that might be - I guess because there are no hard and fast rules). Since a lot of the stuff on the web is not impartial and is based on different use cases and potentially out of date, I would appreciate some thoughts based on experience from people in a similar boat.

If you are on a dedicated IP, how many emails per month are you sending? Has monitoring your dedicated IP for blacklisting been an issue?

If you are on a shared IP (either on sparkpost or other servers) have you had trouble getting into microsoft inboxes or with the BCL? Thanks in advance for all your thoughts.


texts: allow anonymous users to view profiles in WordPress?

texts:
It has been suggested that I may need to allow anonymous users to view profiles. I am running CiviCRM on a WordPress site.

From what I'm reading here ...

https://wiki.civicrm.org/confluence/display/CRMDOC/Linking+Profiles

... I'm gathering that this may only be possible on Drupal, not WordPress.  Is that correct?

If so, is it the case that non-logged-in users on WordPress are automatically allowed to view profiles?

I'm using the profile to create a public directory:
1) Create a number of custom fields
2) Create a profile ("Trainers and Coaches", gid=17) that includes those custom fields, as well as some standard fields like First Name, Last Name, etc.
3) Create a front-end profile view.

This works when I'm logged in to WordPress. (Though I had some questions about inconsistent results when clicking on fields in the profile view.)

When not logged in to WordPress, I get errors.

Using a shortcode:  [civicrm component="profile" gid="17" mode="search" hijack="0"]

I get:

Sorry but we are not able to provide this at the moment.
The requested Profile (gid=17) is disabled OR it is not configured to be used for 'Profile' listings in its Settings OR there is no Profile with that ID OR you do not have permission to access this profile. Please contact the site administrator if you need assistance.

(The profile is not disabled and is configured for use with Standalone Form or Directory and Search Views, so I guess permissions are the remaining option.)

If I use this:     http://mysite.org/trainers-coaches/?page=CiviCRM&q=civicrm/profile&reset=1&force=1&gid=17

I get:

 Sorry but we are not able to provide this at the moment.
We can't load the requested web page. This page requires cookies to be enabled in your browser settings. Please check this setting and enable cookies (if they are not enabled). Then try again. If this error persists, contact the site administrator for assistance.

Site Administrators: This error may indicate that users are accessing this page using a domain or URL other than the configured Base URL. EXAMPLE: Base URL is http://example.org, but some users are accessing the page via http://www.example.org or a domain alias like http://myotherexample.org.

Error type: Could not find a valid session key.

(Cookies are enabled, I've tried Chrome and Safari in OSX, and Chrome and IE in Windows, with the same results. And the URL defined in WordPress is http://mysite.org.)

Any help will be greatly appreciated!

Wordpress 4.7.5 CiviCRM 4.7.17


texts:
I'd like to remove some statues (ie. Left message), and add some more (to support our workflow.

I could add another "status" custom field, but I'd much prefer customise the existing one rather than create a new one.


texts:
I'm trying to add colour/color buttons to Ckeditor on a new site. I've done it on a previous site using configuration option for the editor in Administer >> Display preferences, but either I have forgotten something or something has changed with an upgrade.

As described in How to restore the colour button in Ckeditor I add the Colorbutton plugin, but no buttons appear. The color group was already there but it remains empty. I can't see any options for adding or moving individual buttons (just hiding buttons or adding separators).

I've tried clearing caches, but as it doesn't show in the config screen I don't think that is relevant.

CiviCRM 5.15.1 and WordPress 5.3.1


texts: Is there an easy way to export data from Drupal 7 to wordpress, non critical data, loosing data is fine

texts:
Is there a way to do a simple export/import as a CSV file from Drupal 7 to Wordpress?

Data is not critical, if I get the bulk of it it's ok, I don't care.

Drupal site has one single database shared by CIVI and core.

And wordpress is also sharing same database.


texts: Create an external form to launch a search

texts:
I wanted to include a custom form on our intranet that would initiate a contact search when submitted, like the quick search does if you enter text and press Enter.
I copied the form but when it came through to the search page a message popped up saying "Because your session timed out, we have reset the search page."


texts: CIVI Dashboard display settings broken in Wordpress install

texts:
New to CIVI. Working with an install of CIVI in Wordpress. When logged as Admin AND visit the Civi Dashboard, it loads, but displays broken, with settings and displays all over the place. Attached is a screenshot of the 'Manage Events Tab' as an example of what the settings currently look like.

I have checked civicrm.settings.php for BASE URL issues etc, and all is pointing to the correct WP install in the directory.

Has anyone experienced this issue and can shine some much need light on.

Many thanks


texts:
I am new to CiviCRM. I just want to know how the back end process works in CiviCRM when a URL hits in browser.

Ex. http://localhost/test/drupal/civicrm/member?reset=1

When I am running this URL in browser what are the .tpl and php,js,css files are running

Also I don't have previous knowledge in CMS Coding and Extentions, Is there a step by step guide to understand CiviCRM


texts:
The book tells about the advantages of Detailed Logging at length, but I don't see how to turn it on.

Thanks!


texts: Converting My Data to CiviCRM data formats

texts: When importing data into CiviCRM, do I need to reformat my data in any way so that it is in conformance with CiviCRM data formats?


texts: Send Test and Next not clickable (greyed) due to missing value in reply_id field (i think)

texts: Similar to this question and this one but different issues. All required fields and tokens are filled in. But db is showing Null for reply_id field, whereas all earlier mailings have an '8' in that field. I can't see if this is settable via the UI and am unsure why this would either now be required, or the default is NULL. This site recently upgraded from 4.4.19 to 4.6.8 with no warnings related to this afaik.


texts:
I’m looking for an elegant way of implementing a joining fee for new members. The joining fee is different for each membership type and is payable in addition to the normal annual membership fee. After the first year the member should be able to renew at the normal rate, preferably without an administrator needing to change anything. The CMS is Joomla.

Some of the suggestions that I’ve seen (https://forum.civicrm.org/index.php?topic=29226.msg125372#msg125372 and https://forum.civicrm.org/index.php?topic=27362.msg121121#msg121121) involve the use of different sign-up and renewal contribution pages, with each using a different price set. I’ve tried that but the “(Not Xyz User, or want to do this for a different person?)” link can turn a renewal page into a new member signup page. (The organisation has valid use for renewing for someone else, e.g. other household members, so disabling this for everyone wouldn’t be a good idea, if that’s even possible.)

Other info that may be relevant:

At present the organisation’s rules require new member applications to be in writing  & signed, so at least for now I will probably need to prevent online signups altogether
The membership period is fixed (1 January to 31 December); a 50% discount applies to the membership fee—but not the joining fee—from 1 July to 31 December.
If a member does not pay the membership for a whole year and wants to re-join then the joining fee is payable again.


texts: Show translated string in a template field (using smarty?)

texts:
I'm using a custom profile template. I need display different text strings depending on browser language of user... One string for Spanish users and other string for all other users.

It seems this doesn't run:

{if $la eq 'es'}
    Spanish string
{else}
    Catalan string
{/if}

Mybe using {ts} tag? But I don't know where I should translate {ts strings}


texts: Is there a way of recording/exposing when an activity is added to CiviCRM?

texts:
When adding a custom activity the current time is automatically shown and can be updated. Where people are adding past/ future activities, is the actual time the activtiy is submitted also recorded somewhere in CiviCRM?

Is there a way of extracting this information?

Or should I add an extra date field in the custom data- default set to know to record the submission date?


texts: How can I create a Drupal page with an automated feed for all the events?

texts:
I would like to create an automated feed for all the event we create in CiviEvent, and want to show that on a themed drupal page. I want to feed all info, image that we create during event craetion and a button to register.

Is that something easily achievable?

Thanks in advance.


texts: Volunteers entering paper based memberships

texts:
Looking for an answer for a question I asked a year and a half ago but not resolved.

Using Wordpress and CiviCRM 4.7.27

We have a number of volunteers who are not very computer literate and we do not want to give these volunteers access to the back end. We collect paper-based memberships at events and activities. The members pay us on site. We want our volunteers to enter those memberships right after the events and have the membership contribution shown as complete because we've received the money.

The initial direction I took was to create a membership contribution page with a profile with the additional info we usually ask people to enter when they do an online sign up themselves. Then directed the volunteers to use that web page to enter the information shown on the paper membership. I had no choice but to tell the volunteers to use the pay later option when recording the membership as there's no way I'm aware of through a payment processor to indicate that the payment was provided upon time of purchase. Our other payment method is PayPal.

Everything gets recorded properly except that the contribution status is pending. So now the volunteers send me an email saying they've entered the memberships and I go into the back end to show them as complete.

Is there another way to do this with the results I want? I've played with the batch membership profile as per Use contribution page to record memberships at event but I think that's meant to be used on the back end?

Anyone else attempting to do this who's found a solution?


texts: Submit Credit Card Contribution error with valid payment processor

texts:
After updating to 4.7.30 there is a new "Submit Credit Card Contribution" button under the Contribution tab on a contact, which would be a very welcomed feature but I receive the following error message.

  Error

  You will need to configure the live settings for your Payment Processor before >you can submit a credit card transactions.

I'm using a valid Sagepay Payment Processor (with test and live credentials) that works elsewhere. I created a dummy test payment processor and that brought up the contribution form just fine. I debugged the code a bit and it seems that it's only returning BackOffice processors as the processor mode is not set in AbstractEditPayment.php.

Any ideas?

Thanks in advance.


texts: Email-to-activity processing - don't include attachments

texts:
I LOVE me that email-to-activity processor.
But I'm using up all my disk space because it's also including the attachments from the emails I'm forwarding into CiviCRM.

I don't need the attachments in CiviCRM.

Is there an option or flag I can change to prevent the Email-to-Activity processor from including attachments?


texts: How can I enable a user to renew a membership that has been cancelled?

texts:
Here's what has happened so far: Membership fees increased at the beginning of the year. A user was able to renew prior to the increase being implemented in CiviCRM. The situation has been explained to the user, the payment refunded and the membership status set to cancelled.

When the user goes to the membership renewal page they see a message saying that as the membership has been cancelled it can't be renewed. I don't want to delete the membership because that would also delete the contribution record, so I'd lose the record of the fact that a payment was made and refunded.

What is the best practice approach in this situation?


texts:
I have a drupal 7 site and I updated to civicrm 4.7.22 yesterday and today, I cannot add more than six fields to any profile.  I've tried everything...adding fields to profiles already in use, adding fields to new profiles ... Nothing works.  Error message is "Field not added.  The selected field already exists in this profile."

But it doesn't.

It always starts with that error after six fields are entered.

Additionally, during preview, all the fields are scrambled out of order and at least one is always missing.

Anyone else having this issue?

Missy

Edit to add: I just got the same behavior on the demo site at civicrm ... I feel better, but it's not helping me get my work done.  HELP


texts: What is the Membership type 'domain' in the api?

texts:
The API explorer shows something promising:

Apparently, each membership type can be connected to a 'domain' which is a contact ?

What exactly is it, and how could I assign these domains to a membership type ? The backend interface does not seem to mention it.

[EDIT] anything to do with https://docs.civicrm.org/sysadmin/en/latest/install/multi-site/ ?


texts: How to load custom css into admin popup boxes?

texts:
Many admin functions in Civi send the user to Ajax popup boxes. Eg on the Contact screen, Membership > Add membership, Events > Add Event... and many many more through the system.

What is the best way to load custom css into these?

We are using a custom css file for the rest of Civicrm - but it's not being loaded in these ajax popups. From a load-time point of view, that's possibly a good thing! Some of our admin users are in poor internet areas, and those popups can be very very temperamental when the net is slow. So it would be great if we could just add some minor css tweaks to these popups rather than load the whole of our custom css into them.

Thanks for your ideas.  Drupal 7.54, Civicrm 4.6.25.


texts: Is there an online store where I can buy CiviCRM stickers, t-shirts, books, etc? Should there be?

texts:
I'd like to buy CiviCRM stickers, CiviCon t-shirts, books about CiviCRM and other CiviCRM stuff.

Is there an online store where I can buy such things? If not, should CiviCRM.org create one?

Thanks for your thoughts!


texts: What impact may deploying a changed Drupal DB have on CiviCRM?

texts:
We would like to push our Drupal development environment to production. We have CiviCRM integrated. Obviously our production Civi data has changed since we created Dev (Drupal+Civi).

Is there any documentation explaining best practices for pushing out Drupal updates from a development environment to production without affecting CiviCRM's current db?

Thanks


texts: Scheduled Reminder is sending 2nd reminder AFTER they have already renewed a membership

texts:
Powered by CiviCRM 4.6.3

I have 3 reminder emails being sent out to a particular membership type after their memberships expire.

The first is sent 0 hour before Membership End Date on August 1, 2015. The people who have filled out the renewal have had their accounts updated, and their memberships now don't end until Membership End Date July 31, 2016.

Here is what is selected for this email: entity: membership, selected the type, no auto renew options are available. When: 0 hours before membership end date. Record activity for automated email is checked. Repeat is not selected.From Name, From Email, Limit or Add Recipients, and Manual Recipients are all blank. Send email is checked.

The second is sent 1 week after membership end date and the third is set for 1 month after membership end date. However, some members who have already renewed from the first email have gotten the 1 week email even though their account shows an end date of membership as July 31, 2016.

Here is what is selected for this email: entity: membership, selected the type, no auto renew options are available. When: 1 weeks after membership end date. Record activity for automated email is checked. Repeat is not selected.From Name, From Email, Limit or Add Recipients, and Manual Recipients are all blank. Send email is checked.

It seems like with a new membership end date in 2016, they should not have received an email for 1 week after membership end date. I have checked to make sure that they don't have multiple account that they could be emailed to, and they do not. Another membership we have has the exact same selections, and no problems I am aware of have arisen. A third membership type we have has auto renew options. They are Renewal Reminder (non-auto-renew memberships only), Auto-renew Memberships Only, and Reminder for both. These options to not show up for the membership type I am working with.


texts: How to know if Smarty is really activated on WordPress?

texts:
On WP 5.6 / CiviCRM 5.32 we can't succeed to send HTML e-mails using css in <style> and {literal} (see this post) knowing that we succeed in sending html templates with in-line css.
Smarty is set on '1' in civicrm.settings.php but my question is if smarty is "really" activated and if there's a way to check this parameter.
* Enable this constant, if you want to send your email through the smarty
 * templating engine(allows you to do conditional and more complex logic)
 *
 */
if (!defined('CIVICRM_MAIL_SMARTY')) {
  define( 'CIVICRM_MAIL_SMARTY', 1 );
}

Any idea?


texts: Remove CiviCRM and Drupal links / banner on profile form

texts:
we have setup an online profile form that new members to our charity can complete. The information then pulls directly into CiviCRM.

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

Is anybody aware of a way to do this?

Many thanks

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

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

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

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

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

Thanks again for all your great help, Terry

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

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


texts: Personalised link using checksum tokens leads to empty page

texts:
When testing the functionality of checksum tokens for a mailing, the link is properly created according to this wiki entry for profile pages (.../?page=CiviCRM&q=civicrm/profile/edit&reset=1&gid=N&{contact.checksum}&id={contact.contact_id}). However, clicking the link leads to an empty page that shows the profile title twice, but no other content.

Interesting: When clicking on Wordpress' customize button, the profile including the respective data is shown above the page – although home page instead of the CiviCRM page.

We're on CiviCRM 4.7.8 for Wordpress (Graphy theme) and are trying to set this up for the first time.

What I tried:

Using a different browser (Firefox and Chrome) and different devices (Windows PC and Android Phone) didn't show any differences.
I wasn't sure whether a reCAPTCHA would cause problems so I turned it off for this profile, but that didn't help.
Clearing cache and resetting paths didn't change anything either.
Not sure if this is relevant, but the sidebar is also shown despite having changed the WP template to "no sidebar".

Any other ideas what could cause this?


texts: Newsletter Signup CiviCRM Thinks Anonymous is Admin

texts:
I'm using CiviCRM 4.4.20 with Drupal 7.43.

I created a profile to use for newsletter sign-up. Instead of a person signing up being set to "pending" and getting an email, the person is directly signed up and no email confirmation is being sent.

One clue to the problem is that it says "Added by Admin." I would have expected it to say "Pending (by email). Note that I am logged out when running this test.

How can I get CiviCRM to set the sign-up to "pending" and receive an email with a link to confirm?

Ideas?


texts: Getting more detail about transactions/ invoices/ donatons

texts: I'd like to get more detail on what exactly each transaction contains. The report I have lists the donor, transaction number, date, amount and note. It's possible to get the shipping cost by drilling into individual transactions - how can I create a column in the primary report for that? The note field lists what items we shipped (eg tshirt, or stickers) how can I get a quantity (Eg, how many shirts)? Thank you.


texts: How does civicrm handle automatically generated 'Unsubscribe' messages from google

texts:
Asking because in looking at some other bounce issues I notice a bunch of emails such as

  Unsubscribe - This message was automatically generated by Gmail

in INBOX/CiviMail/ignored

and just wondering if this is the expected behaviour


texts:
I'm considering using Drupal's simplenews module for sending (most of) my email newsletters, rather than civiMail. Are there any disadvantages to doing this?

The background is:

Drupal 8 and civi 4.7 (when I go live later this year)
Mandrill to power the actual email sending
All newsletters will contain a single news item, not a collection of
multiple items
I want email to be sent when the news is available, not weekly or monthly
I want my news creators to be able to have the simplicity of just
creating an article and giving it a tag, without having to worry
about enews complexities.
I want my news items to appear prominently on the website
I want various other bits of content to automatically appear in the
email  (coming events etc).

Given this, it seems to me that what I'm doing is basically automating the emailing of a Drupal content item (rather than creating a bespoke newsletter), and so it's better to use simplenews for this.

The only disadvantages I can see are:

if I want to show, edit or automate the subscriptions in Civi,
I'll have to create groups and use Drupal Rules to sync the civi
groups to the simplenews subscription preferences.
If I want civi and simplenews to update each other with knowledge about changed email addresses etc., I may have to use Rules for that also.
I
probably won't be able to personalise emails with tokens based on
civi information about the contact. (which I don't mind)

Are there any other disadvantages to using a simplenews & Mandrill setup in this way? Any reasons to prefer civiMail? Do I seem to be thinking about this right?

thanks for your thoughts,

Jonathan


texts: Non-admin role can see CiviCRM links in profile, no privileges selected

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

What I know:

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

Screenshots


texts: HOWTO create full list of Contacts in ON HOLD status

texts: I may be missing something, but I'm trying to exclude (from a contact export list) all contacts that have a "ON HOLD" status for their primary email, particularly if it's an Opt-Out, but Bounce would be useful as well. Using Advanced Find, I could find those contacts who set an Opt-Out on their own by checking Opt-Out in one of our mailings. Also, I can find some of these under Contacts > Contact Reports > Constituent Detail by filtering that report on "Do not bulk email" or "Do not email". However, it does not seem to pick up folks who have requested me personally to opt them out, which I've done manually. Any help for the COMPLETE list of contacts with "On Hold Opt Out" status, whether set by email response or by a CiviCRM admin, would be appreciated.


texts: Cannot send email from CiviCRM after upgrade to 4.7.21 (Joomla 3.7.3)

texts:
After upgrading CiviCRM to 4.7.21 (on Joomla 3.7.3), no emails get sent from CiviCRM (transactional or from CiviMailing). In System Settings >> Outbound Email (SMTP/Sendmail) when I click on "Save and Send Test Email" the page keeps reloading for about a minute, and then results in 500 error ("This page isn't working").

This worked perfectly before the upgrade.

Also, I no longer see file packages/Net/SMTP.php (I re-ran the CiviCRM install just in case) which used to send email via SMTP ... is this now handled by another file in another directory?
Thank you so much for any pointers.


texts: CiviCRM 4.6 - Duplicate memberships/memberships inheriting themselves. Screenshot included

texts:
We have permissioned relationships where an Organization will own a primary membership and members will inherit this membership.

We've run into an issue where the Organizational membership will inherit its own membership and the only way to fix is to delete and re-create it. See the screenshot. Anyone experience this before?

There was a similar issue described for CiviCRM 4.3/4.4 posted on the CiviCRM forum here: https://forum.civicrm.org/index.php?topic=29822.0 -- but this does not seem to relate to our issue.


texts: Email Block On User Summary Does Not Expand

texts:
The email block on the contact summary does not expand to be edited. I have tested and this is a problem with my install (not repeatable on DMASTER) but I would love some ideas of how to try and solve it.
I can have an email in the block an it looks right.

If I click edit I get this:

There are no JS issues shown in the console. I have cleared the cache in the UI and with CV. All the other blocks work as expected.
I have CiviCRM 5.31.1 in Drupal 8.9.10.
Thanks,
Josh


texts:
I'm in the process of switching from Events Manager to CiviEvents so my client can integrate event registrations and payments into Civi.

However, as far as I can see there's no facility for the CiviEvents widget to show event thumbnails, which is a shame. Attached is a screenshot of the current set-up, where the Events Manager widget formatting matches the recent posts widget.

I can show an image by including it in the CiviEvent widget description field, but that's far from ideal.


texts: Civicrm profile field values using same record type goes missing/overwritten

texts:
I have created a CiviContribute profile with multiple postal code fields of record type contact. All these profile fields have different labels and sub-type. But when a user makes a contribution, only postal code value of last field is being stored in the database and the postal code values of first 2 fields goes missing/overwritten. Any help would be much appreciated.

Screenshot:


texts:
Needing to have a single golfer price of $100
OR
Foursome at $80 each and collect data on each person.
I can turn on Addtl Participants
BUT
How do a "make" them enter four people and not more or less when choosing Foursome.
I'm guessing this would have to be a custom built page?
THANKS for any input.


texts: How do I move registration to another event

texts: I have a member signed up to the wrong event. I can't find a way to switch to the right event through the back end. I see Transfer - but it transfers to another person; not another event. Is it possible?


texts: How to Change Price Set Field Type without deleting and re-adding

texts:
I have some price set fields created as Radio currently, but they need to be Checkbox type. Is there any way to safely change (even in backend) without having to recreate the entire field (there are a lot of choices)

CiviCRM 4.6.x Drupal 7.x

Thanks!


texts: DB Error: constraint violation when a member renews online

texts:
In the following from the ConfigandLog, log, the value of group_id is given as 13 when it should be 9. In civicrm_groups there is NO 13 but in civicrm_custom_group there is.

Aug 29 20:25:14  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => exceptionHandler
        )

[code] => -3
[message] => DB Error: constraint violation
[mode] => 16
[debug_info] => INSERT INTO civicrm_subscription_history (contact_id , group_id , date , method , status ) VALUES ( 4405 ,  13 ,  20160829202514 , 'API' , 'Removed' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`gsv10274_04`.`civicrm_subscription_history`, CONSTRAINT `FK_civicrm_subscription_history_group_id` FOREIGN KEY (`group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE CASCADE)]
[type] => DB_Error
[user_info] => INSERT INTO civicrm_subscription_history (contact_id , group_id , date , method , status ) VALUES ( 4405 ,  13 ,  20160829202514 , 'API' , 'Removed' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`gsv10274_04`.`civicrm_subscription_history`, CONSTRAINT `FK_civicrm_subscription_history_group_id` FOREIGN KEY (`group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE CASCADE)]
[to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="INSERT INTO civicrm_subscription_history (contact_id , group_id , date , method , status ) VALUES ( 4405 ,  13 ,  20160829202514 , 'API' , 'Removed' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`gsv10274_04`.`civicrm_subscription_history`, CONSTRAINT `FK_civicrm_subscription_history_group_id` FOREIGN KEY (`group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE CASCADE)]"]

)

Why is Civi using the wrong group ID?
Is this causing the fatal error?


texts: Events disappearing when adding additional dates

texts:
For one of my sites, a number of events from May and June that were set up as recurring events and had people registered on the event have gone. It's not individual events, it's usually 3 or 4 or more of a set of recurring events that all disappear.

I've just had this from one of the staff
"The dates and information was showing on Tuesday. When I went to create an additional date (using repeat) it wiped all the dates I had previously input."

Is it not possible to go back to a recurring event and add further dates?


texts: How do I find more information about the ACL regression introduced in 4.6.7?

texts:
Email was received stating

  If you are currently using 4.6.7 and your site uses ACLs to segment access to contacts you are strongly encouraged to upgrade. The 4.6.7 release included a regression in the ACL system which caused certain contact access permissions to behave improperly. The 4.4 LTS branch was unaffected.

There is no additional information provided at https://civicrm.org/advisory, and I don't see any issues in the Jira queue marked with a 4.6.8 fix version that would give more context for site administrators to judge whether an immediate upgrade is necessary or if it could be delayed.


texts: Api4 does not delete values table when deleting a Custom Group

texts:
I'm using Api4 to remove a Custom Group upon uninstalling an extension. The api call looks like

\Civi\Api4\CustomGroup::delete()
  ->addWhere('id', '=', $idOfCustomGroup)
  ->execute();

The Custom Group and all of its fields were deleted, as expected. The civicrm_value_... table, which stores the values of the fields, were not deleted.

I replaced the api4 call with an api3 call as follows, and it deletes the Custom Group, all fields, and the values table:

civicrm_api3('CustomGroup', 'delete', [
  'id' => $id,
]);

Is this a bug in api4? I think the behavior should be consistent, and that the preferred behavior should be to delete the values table when deleting a Custom Group, because if I wanted to keep the values I would disable the Group instead of deleting it. As well, not deleting the values table interferes with reinstalling the extension when it is installed from an xml file (as described in the developer manual: https://docs.civicrm.org/dev/en/latest/extensions/civix/#add-custom-fields)


texts:
I use civimail on a drupal 7/CiviCRM 4.7.8 and have done so for many years.

Recently civimail has started sending out an email multiple times to the same email address even though

1) the email address only exists once in the system.

2) In the sql database under civicrm_mailing_recipients it only says the email contact receives it once and this is borne out in the activities tab.

This is not just happening with one email address - it's happening with hundreds of email addresses.

Any ideas on where to start troubleshooting?

Thanks
Caroline


texts:
New to CiviCRM.
WordPress Version: 4.4.2
PHP Version: 5.5.32
MySQL Version: 5.1.73-log

I initially installed CiviCRM 4.6.14 LTS by mistake and rather than do an upgrade, I deactivated it, deleted it, and dropped all the tables from the database (It was installed to its own DB).

I neglected to remove the plugins/files directory or its contents, though.

I then installed 4.7.3 and when I activated it, I had green lights all the way on the installation page, so I just proceeded. However, any attempts to open CiviCRM resulted in errors (something about MySQL MyISAM).

So, I deactivated, deleted and then found that the db files were put in my Wordpress database, not the CiviCRM db. I deleted all those, and reinstalled 4.7.3.

Now, when I activate, I get a SQL Error -- table not found. Obviously, CiviCRM is still trying to use the WP database. I wholly expected to get the Install page again, but that never happened.

What setting is lurking around that uninstalling doesn't delete? How can I get a clean install that runs the installation check and lets me enter the alternate DB info. I tried https://MYSITE/wp-admin/options-general.php?page=civicrm-install, but all I get is "You do not have sufficient permissions to access this page.")

Thanks!

EDIT: Here's the error message I get when I try to activate civicrm:
Initialization Error

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

[code] => -18
[message] => DB Error: no such table
[mode] => 16
[debug_info] => SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id

FROM civicrm_setting
WHERE (domain_id = 1) AND (is_domain = 1)
 [nativecode=1146 ** Table 'db561663860.civicrm_setting' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id
FROM civicrm_setting
WHERE (domain_id = 1) AND (is_domain = 1)
 [nativecode=1146 ** Table 'db561663860.civicrm_setting' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info="SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id
FROM civicrm_setting
WHERE (domain_id = 1) AND (is_domain = 1)
 [nativecode=1146 ** Table 'db561663860.civicrm_setting' doesn't exist]"]
)

Warning: Invalid argument supplied for foreach() in MYSITE/wp-content/plugins/civicrm/civicrm/Civi/Core/SettingsBag.php on line 311content/plugins/civicrm/civicrm/Civi/Core/SettingsBag.php on line 311


texts: Error on running cron job for mailing process on CivicRM 4.7.8

texts:
Running the php cli for the mailing process, got the failure

Entity: job Action: process_mailing
Summary
Finished execution of Send Scheduled Mailings with result: Failure, Error message: API permission check failed for Group/get call; insufficient permission: require access CiviCRM
Details
Parameters parsed (and passed to API method):
a:1:
Unknown macro: {s}
Full message:
Finished execution of Send Scheduled Mailings with result: Failure, Error message: API permission check failed for Group/get call; insufficient permission: require access CiviCRM

Here is my command for the cli

php ../administrator/components/com_civicrm/civicrm/bin/cli.php -u user -p password -e Job -a execute

Running manually from the schedule job, CiviCRM » Administer CiviCRM » Scheduled Jobs,
there is no failure

Similar problem/bugs has been mentioned here CRM-17968 (fixed 4.7.4)

I saw that the fix already patched in the civicrm 4.7.8. but the problem still persisted, and i did not yet found the solution.

Thank you


texts: Request for help getting Stripe Payment Processor working in CiviCRM/Wordpress

texts:
I'm testing Stripe for payment processing in CiviCRM.

I have the latest Stripe Payment Processor extension (4.7.3)

And I'm running Wordpress 4.9.4/CiviCRM 4.7.27

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

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

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

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

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

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

Thanks for any help,
Norman


texts: Running out of memory on contact creation

texts:
On a site with ~68k contacts, we find that occasionally we get a memory error on a simple contact creation (although we haven't noticed problems elsewhere). We have a fairly large PHP memory allotment to start with, and although I realize I could increase that further I am a little hesitant to go too much further there. I'm assuming the process that runs the dedupe check could be responsible for this.

Can anyone confirm that the duplicate check is most likely the culprit here? If so, is there a setting to disable that?


texts:
Has anyone successfully switched off Engagement Tracking on SparkPost?

I did this at https://app.sparkpost.com/account/smtp

But all links are getting converted to http://go.sparkpostmail.com/


texts: Event members only for 3 days then open to the public

texts:
I have a need to be able to enter a period when an event opens for registration/access to a file to members only for a period of time (normally 3 days).
So the goal, to be clear, is to open an event for registration to members only for 3 days, then open to the general public.
Ideally, if those open dates were also available to civiMail as a token - but that might be asking a bit much.  I'm prepared to write an extension to make this happen but if someone has something similar, then I can build on that too.


texts: New membership tiers - how to structure?

texts:
Our board has changed our membership tiers and I am trying to figure out the optimal way to implement this in Civi.

Our previous membership was a standard rate and then a lower price for students, youth and seniors. This along with non-profit and lifetime membership used a price set of 6 radio buttons to select from.

Now, we have 2 tiers of individual membership, each with student/youth/senior rates plus an additional for-profit organizational membership. This doubles the number of options and adds complexity.

I'm having trouble figuring out the best way to approach this. Do I just create a different membership type for each of the new options? How can I make the online membership form less overwhelming? Would that require using webform integration with conditionals (i.e. select type, then "class" rate)? We'd like to still track whether members are students, seniors, or youth.

An additional question is how to grandfather current members in at the higher tier?

Currently on 4.4.7, but I'm working on 4.7.x on a dev site to upgrade, hanging on  Drupal 7.

Thanks.


texts:
My website has member side and after adding a member to a site the site was broken and for members, Initialization Error occurs. so members couldn't access their own page on the website.
and also when I install the new plugin I get this error again. I couldn't change anything on the website because after adding new page or post I have this problem.
What is the reason of this problem?


texts: why i cannot get all number errors when importing data

texts:
i face errors data when import.
when i click download erros , i can't get all of them
for example erros = 4000, when i click download erros link i only got 500.
why are cannot i get all the number of errors?
i attahed for more detail.

thanks in advance
civicrm 4.411
drupal 7.32


texts: Include PDF welcome package attachment with email receipt

texts:
I am trying to sort out if I can include a PDF attachment for new members with their registration confirmation email. There are several different member types, each would require a different PDF. The content of the PDFs is too long to put directly into the confirmation email. The PDF contains a welcome message and information about events, benefits, and other details for new members.

I can see how to include a PDF receipt in the admin settings but no where to include any other type of PDF. I see the option to set the maximum number of files (documents, images, etc.) which can be attached to emails or activities but I can't find where to configure what files to attach.

Is this possible?

Thanks!

(Using CiviCRM 4.7.24)


texts: "Send now" emails going to wrong contact

texts:
A few times, including this morning, we have used the send now feature for 20-40 contacts who matched a search and Civi has mixed up the contact parameters. What often happens is that a contact is sent pre-filled information for the preceding contact in the list.

I think this happens when we select all, then choose action > email (send now) and then remove a contact from the list by clicking the "x" beside their name in the "to" field. But I am not certain.

Has anyone seen this happen to them? Is it a bug or are we doing something wrong?

We are running civi 4.7.14 and wordpress 4.7


texts: Repeat Contributions Report - Where Is Data Pulling From?

texts:
We are new to CiviCRM and have just started importing data and running checks. We have imported the last five years of our donor contribution information and all of the data is correct in the BOOKKEEPING TRANSACTIONS REPORT but when running a REPEAT CONTRIBUTIONS REPORT the totals don't match even though the listed transactions and totals match the BOOKKEEPING TRANSACTIONS and our imported csv file. All of the filters and dates are identical. We thought this might have to do with merged or deleted records? We did permanently delete records that included contributions was this incorrect?

Any hints are appreciated - Thank You, Kim


texts: How are API's implemented in the CiviCRM Codebase? I have a idea of basic structue user <-> api <-> BAO <-> DAO <-> mysql but I guess there is more to this than just this structure. Thanks in Advance!


texts:
I recently took over a website and I have missing tables in the civicrm database (under wordpress). I want look at the civicrm database but I don't know where the database is stored. How can I find the physical civicrm database file so I can download it and run some queries to see what's there?  When I go to phpMyAdmin on the server, it only lists the wordpress database.

Below is what I see when I look at phpMyAdmin and this is the only db. I have looked at all of the table names in this db and there are no civicrm tables.

Thanks