texts: Fatal error: Uncaught CRM_Core_Exception: Found installation canary

texts:
I am new to civicrm and I have been recommended by a friend to try it out for my website. But before I do that I would like to try it our on my laptop via xampp.

I installed wordpress and then civicrm everything seemed to have went through but now when I click on civicrm it gives me this error.

[0: Found installation canary. This suggests that something went wrong with tracking installation process. Please post to forum or JIRA. thrown in C:\xampp\apps\wordpress\htdocs\wp-content\plugins\civicrm\civicrm\Civi\Core\InstallationCanary.php on line 53

Could someone please guide me on how to solve this.

Tanmaya


texts: Contribution Tab not visible after upgrade to 5.2.1

texts:
after upgrading CiviCRM 5.2.1 in contacts I contribution tab disappeared.

And "Contribution" is checked in Display preferences.

I discovered that it depends that when I save admin/setting/preferences/display there is not saved the value 7 for CiviContribute in table civicrm_setting. I have executed this query update:

UPDATE `civicrm_setting` SET `value` = 's:27:\"123457910111314\";' WHERE `id` = 1

I do not know what it depends...

I have another strange thing: the field civicrm_option_value.label is missing (there are label_it_IT and label_en_US instead).

I updated CiviCRM from version 4.7.27 and my database has a lot of views. I notice recent CiviCRM database does not have views instead.

What do you suggest me?
Thanks


texts: "view contact" not updating when changes are made

texts:
I do all my backend entry for CiviCRM on my "View Contact" page, but nothing I do is visible for about a day and it is causing a lot of stress for my staff.

If we go to the Membership tab and add a new membership, it will save, but it won't show up on the Membership tab until the next day. I've tried cleaning my cache in Joomla, and setting a rule to bypass admin for caching, but no luck!

Has anyone encountered this probelm?


texts: I am looking for hosting providers and would like recommendations as well as any horror stories about you to avoid.


texts: Unsure if I just broke my database with a custom field

texts:
I added a custom field for authenticated users to add a bio on their profile page (and if there's an existing field I should use for this, please let me know). Not knowing how long I should make this field, and temporarily forgetting that mysql probably uses fixed-width for this, I set the field length to 32767.

It took a long time to create the field, but the page wait dialog finally completed and the field shows up in the Custom Fields list. But having seen the long wait, I decided to re-do the field at 4095 or 8191, and tried to delete the Bio field. THAT progress window has been a spinning blue circle for nearly an hour, and Bio is still showing up in the Custom Fields list in a different tab.

EDIT: perhaps worth noting that the page where I created the field also had a spinning wait cursor nearly 90 minutes after I did so, but I could see the Bio field as expected in the Custom Field list, so that process seems to have completed without letting the page know.

Did I break something, or will this get to my desired state after I wait long enough? This is running on a Linode at $20 a month, so the CPU/RAM is not particularly powerful.


texts:
I'm migrating to a new Drupal 9 install, and after a decade of using CiviCRM, I want to pare down the number of records. If I do a simple find contacts search with no criteria, I get 74144 results. I've also searched for everyone who has given us contributions as well as everyone who opted in to our email list and put them in a separate group. This group, "2021_keep" has 6046 contacts.
Next I go to Search Builder and put in the query
Group(s) Not In 2021_keep ...AND... Group Status 'Added'
Actually, just the first part is my query, the second part gets added after I click to search.
Result is 71858 contacts. I would expect the result to be 74144 - 6046 = 68098 contacts.
This is kind of important, as I want to delete all of these contacts, who are people that at some point signed a petition we hosted but didn't sign up for the email list, or later opted out of it, etc.


texts:
I don't believe that I am accomplishing a task correctly, and I'm afraid that I've opened things up too much.

I have given Subscriber level WordPress users access to CiviCRM: access CiviCRM.  This allows access to the Dashboard:
https://example.org/civicrm/?page=CiviCRM&q=civicrm/user&reset=1

Once there, then they can see and edit their donations, but only after giving access to CiviContribute: edit contributions.

The Dashboard seems to be a very useful feature, but I feel like I'm giving too much access in the ACL's.  With the above scenario, if I have access to the back end of Civi, I can now search for other people and change their contributions also, right?  How should I be doing this?  I feel like I'm missing something in the documentation, but can't seem to hit the right keywords.

Wordpress 4.2.2, CiviCRM 4.7.3


texts:
I have seen this warning on a couple of sites.

Warning: file_put_contents(.../sites/default/civicrm/ext/delete-this-DEbcrmuyt7): failed to open stream: Permission denied in CRM_Utils_File::createFakeFile() (line 306 of /.../sites/all/modules/civicrm/CRM/Utils/File.php).

On one site this warning then came up when we tried to delete a Price Set but were unable to do so.


texts: I'm a new user of CiviCRM and I would like to ask for specific training courses for beginner users. Where could I find them? Thanks a lot!


texts: "You do not have permission to access this content" error after inputting data into an HTML form

texts:
I am working with an arts organization in my town and they recently migrated their civiCRM application (which is serving as a plugin to their wordpress website) from GoDaddy to InMotion.  We are having a problem with an HTML form on one of our pages that, when submitted, is throwing the following error string:

You do not have permission to access this content

the form has the following fields:

"first name, middle name, last name, email, are you a robot?"

in the civiCRM dashboard, I can look at the HTML markup for the page when I navigate in the following manner (menu clicks):

administer > customize data and screens > profiles > "Add e-mail (this is the profile name) > HTML form snippet.  But the HTML markup only has a huge number of links to various javascript files, which I assume are the scripts that are running the AJAX, asynchronous code that submits the form?  Since I can't submit a test record, I can't see whether the page is being redirected after submittal (e.g. - possibly running a header() command in PHP at the end of the POST script.  Can someone point me in the right direction in terms of what I should be looking for to fix this error?  As far as I was told, there aren't too many pages on our site that are erroring out.  I was only shown this one.  thanks guys!

an image of the error we're seeing can be seen here: https://drive.google.com/file/d/17iuGObM7rPIJwgWQIPMMvhoVglHFM8YW/view?usp=sharing

We are running on the following platforms:

Wordpress: Ver 5.3
civiCRM: Ver 5.18.3
PHP: Ver 7.2


texts:
I'm working on a ruby on rails application and trying to pull data from a civi crm server. I'm sending the get request from Rails but ending up with

{"IP":"some IP","level":"security","referer":"","reason":"Destructive HTTP GET","is_error":1,"error_message":
"SECURITY: All requests that modify the database must be http POST, not GET."}

Can someone tell me why is that and how to get data from civicrm server?


texts: When unchecking VERP option I am getting an error "Boolean value required for track_civimail_replies"

texts:
When I go to Administer > CiviMail > CiviMail Component Settings. There is an option
"Track replies using VERP in Reply-To header"
When I uncheck this box and hit Save I am getting an error message
"Boolean value required for track_civimail_replies"
Does anyone know what this means and how I can successfully turn of VERP?
I am using CiviCRM 5.36.1
Thanks


texts: How to set contact name during Drupal's user registration?

texts:
During Drupal's normal user registration process (a user registering their own self, as opposed to an admin registering a user) a Civi contact record is created for that user.  That works fine but the only data set for the contact record is the email address.  How do I set it up so that the contact's First and Last Names are set during that process?

Currently I have fields on the user profile for first and last names.  Is there a hook I can use to save these values to the contact record?

I don't see any configuration options for this sort of thing.  I'm kind of mystified by the lack of info on this particular use case when I search the web, as it seems like a standard scenario.


texts: Fetch Node data from drupal into CiviCRM

texts:
I am interested to know if it is possible to fetch node data from Drupal into CiviCRM.

Is there anyway to do this?

My End Goal is to to populate a "select list" with node titles from drupal and depending on which title you choose, fields values will change.

Thanks,

Moe


texts: Having issues with CiviCRM menu not showing up after install - Wordpress 5.3 civiCRM 5.12.2

texts:
I'm looking for some advice with civiCRM and wordpress

The install works and the Database is there, but there is no sign of the menu apart from the plugin civiCRM admin.

I have tried to look at the settings.php file and also changed the Resources URL.

I have also tried to install classic editor as that was a suggestion to resolve the issue, but with no luck.

Any advice or suggestions would be very welcome


texts: Adding new default components to the database

texts:
I have been working on to add a default header and footer to the system workflow emails. Most of the part is done but I am stuck at setting those components in the database by default so that whenever a new user installs civicrm, get the new transactional_header and footer along with other components as well.
I have for now trying updated the .tpl files for the mysql in civicrm/templates/civicrm_msg_templates.tpl
I tried resetting the database to see the changes but its not there.
Do we have any documentation or we need to make changes somewhere else also?


texts:
I'm using Civi 5.18.3 on a demo site. I am trying to add the text of a Twitter bio as a new Note for a Contact, and it is not saving. The bio text contains these characters:

National Volunteer & Distributed Organizing Manager for
@WorkingFamilies . #WFP4theMany @ http://WFP4theMany.org & http://WFP2020.org RT ≠ endorsement. TEXT WFP TO 738674

The User Guide doc page here does not specify if Notes must be only plain text characters.


texts: Extending default search for name to consult a custom field

texts:
How would it be possible to hook into civi's searches to always lookup a custom field when searching for name?

Background:
In our setup we handle big departments as distinct contacts. Their name is the base organization name and we provide a custom field "Additional name" in which the department's name is stored.

Example:

Contact A: Base Organization named "University of Bielefeld",
Contact B: Department of A named "University of Bielefeld" with
           additional name "Faculty of Physics"
Contact C: Department of A named "University of Bielefeld" with
           additional name "FooBar Institute"

We do this for different reasons, for instance because pdf letter addressing is simpler.

Problem: If our users head over to search box, advanced search or simple search and fill the name or name/email field  with "foobar", they don't get correct results.

Any ideas?


texts:
Drupal 7

I have a hierarchical Menu (3 levels)

I extensively use Drupal Views, with numerous columns, which hardly fit inside my current Theme (Professional Theme)

What free and responsive Theme would you recommend ?


texts:
Civi 4.7.20 / WP 4.8

For the past several weeks, we've been unable to send out any emails or test mails through CiviMail. No errors are logged, and even with backtrace displayed and error debugging enabled, there's no indication of any error. Yet every time we submit a mailing, every recipient email address bounces and is switched to On Hold. The There are no messages in the bounce email inbox (it's a conventional address, same domain name as the website), so it seems those emails never went out from the mail server.

Sending test email in System Settings / Outbound Email / SMTP succeeds, so we know the outbound email settings are correct.

Someone suggested the problem may be VERP is no longer supported on the mail server, so I contacted the hosting provider. I now know for certain that VERP was deprecated, and worse yet, catch-all email accounts are not permitted for shared hosting accounts.

In my limited understanding of CiviMail mechanics, I think we're supposed to either have VERP support or a catch-all email account. But we have neither. Is there a work-around?

Any ideas?

ADDENDUM:
Though we're also experiencing buggy behavior in Reports, I did manage to coax Bounce Reasons out of our system. Syntax errors seem to be the culprit, and they all look like "Failed to add recipient: {email address redacted} [SMTP: Invalid response code received from SMTP server while sending email. This is often caused by a misconfiguration in Outbound Email settings. Please verify the settings at Administer CiviCRM >> Global Setting"

Also, per Chris' suggestion below, I looked at the "Track replies using VERP" option, and discovered it's already deselected. So while my original question was Can't send or test mail, neither VERP nor catch-all supported, I am changing it to Can't send or test bulk mail, but test mail succeeds in System Settings / Outbound email / SMTP.


texts: I have civicrm installed with Drupal. I was not able to find how to create a multiple file upload using a civicrm custom data field. By default it allows only single file to be uploaded at a time. I require some 'Add more' type of functionality in CiviCRM.


texts: I need a dashlet for a user which lists scheduled activity details filtered on the 'case type' the activity sits in.   I can find these in search but cant seem to get a report to work - closest I can get is extended report  - Activity Pivot Chart (CiviCase)


texts: Can you use civicrm for inbound marketing instead of HubSpot?

texts:
We are considering using HubSpot with our Drupal 6 website to help with lead generation. Is anyone using civicrm for his purpose? Can civicrm create workflows once someone opts in via a form?

Specifically, we want to create landing pages with opt-in forms to capture web visitors' first name, last name and emails. Once we have that lead information, we want to be able to send them auto responder emails with messages that link to or contain content like white papers, video, text attachments etc. on a specific schedule. For example, we want an automated workflow that would send a lead something right after they submit info, then send another piece of content 2 days later, then a week later, and 2 weeks later. This automated workflow, landing page, and all the data about visitor behavior with this content is what HubSpot provides.


texts:
I tried all the day to install version 4.6.x of CiviCRM on a brand new installation of Drupal 7.39, but each time I execute the installation here:

http://<your_drupal_home>/sites/all/modules/civicrm/install/index.php

I get a blank page and the following error in my logs :

PHP Fatal error: Class 'CRM_Core_Config' not found in /var/www/xxxx/sites/all/modules/civicrm/install/index.php on line 142

The method I used to install is simply downloading the compressed tarball and untaring it in the folder /var/www/xxxx/sites/all/modules/, and this after just having completed the installation of Drupal.

My confiuration is :

Debian GNU/Linux 8 (jessie) server with a private IP
Apache/2.4.10 (Debian)
PHP Version 5.6.7-1 (with all prerequisites except using the PHP's bundled version of PCRE for which I cannot guarantee it has the unicode properties support)
Content of the VirtualHost :

 <VirtualHost 192.168.1.203:80>
     ServerName xxxx
     SetEnv CODE_SITE xxxx
     DocumentRoot /var/www/xxxx
     php_admin_flag  engine on
     php_admin_value include_path "/var/www/xxxx/"
</VirtualHost>

EDIT 1

  Nom I am sure that the PCRE version bundled in my PHP instance has the unicode properties support option enabled, since I could sucessfully execute (with no warnings) : if(preg_match('/^\p{Arabic}+$/u', 'ﻎﺤﺤﺤﺤﺤﺣ')) echo 'OK'; else echo 'KOOOOOO' and it displayed OK

Does anyone have any idea ?


texts:
The log says the scheduled job ran and worked, but I checked some contacts and see nothing happened. I had it set to run daily. It geocodes just fine on import and upon saving a record.

So, I have some questions.

How long does it run each time it is triggered? (max exec time?)
Can I throttle the amount of contacts it attempts to code for each run? I want to avoid it running non-stop and killing the server by overloading it.
I don't like to have more than one street address field (disabling supplemental 1,2,3) as users do not consistently input the their data right if you give them too many options. However, is it okay to include APT numbers etc in the main street address field and it still geocode reliably? I've done a few tests on records but not with a large sample.

I don't see in the docs clear answers: https://docs.civicrm.org/user/en/latest/initial-set-up/mapping/

Perhaps we can update the docs more on this?


texts:
I've fairly recently upgraded from 4.4 to 4.6.12 in Drupal.
We have a custom date field that is Searchable and Search by Range is Yes.
This used to work but doesn't now: The error includes this:
No matches found for:
Start date In '20 May 2, 20 July 2' ...AND...
Searches for date fields not by range are OK.

I've just tried this in the 4.7 WordPress demo (UK locale) and can repeat the problem there, though the no matches error report format is better.

The specific date case is handled in convertFormValues() in 4.6.12 CRM/Contact/BAO/Query.php - but not in 4.7.2.

Any suggestions for how to fix this?

Thanks, Chris


texts: Drupal 7 unable to reach CiviCRM installer

texts:
I'm trying to install CiviCRM (4.6.10) on a fresh copy of Drupal 7 (7.41) but I can't start the CiviCRM installer.

Error messages:
When I visit http://your_domain_or_IP_address/sites/all/modules/civicrm/install/index.php I get a Server Error 500. Looking at my logs they read:

PHP Fatal error:  require_once(): Failed opening required 'WP_PLUGIN_DIR/civicrm/civicrm//CRM/Core/ClassLoader.php' (include_path='.:/usr/lib/php:/usr/local/lib/php:/usr/local/php56/lib/php') in /home/hostname/public_html/test/d7/sites/all/modules/civicrm/install/index.php on line 75
PHP Warning:  require_once(WP_PLUGIN_DIR/civicrm/civicrm//CRM/Core/ClassLoader.php): failed to open stream: No such file or directory in /home/hostname/public_html/test/d7/sites/all/modules/civicrm/install/index.php on line 75

From Drupal

Notice: Undefined index: description in drupal_check_module() (line 1232 of /home/hostname/public_html/test/d7/includes/install.inc).
(Currently using CiviCRM settings does not exist CiviCRM settings file does not exist. It should be created by CiviCRM install)

What I've tried: setting folder permissions to 755 or 777. I have uploaded the CiviCRM files via ftp and also using the URL. I have re-installed Drupal 7.

I was able to successfully install CiviCRM on Wordpress on the same server but I'm stuck on the Drupal install.

To be clear, I downloaded and uploaded different CiviCRM installation. One specific to Wordpress (for Wordpress) and one for Drupal. The modules show up in my Drupal Modules section.

Any idea what I can do to kick start the installer?


texts:
So, we recently set up a contribution page for people to buy tickets for a raffle we're hosting on our website. However, we are not receiving confirmation emails upon purchases. We get them when people donate through our "Donate Now" button but not for the raffle. Also, we have several fields on the contribution page that are not being displayed under the contributors profile. Can anyone help with this?

I hope this makes sense. I am new to United Way and CiviCRM so I'm rather in the dark with all of this. Hope someone can help!


texts:
I'm attempting to configure Cividesk sync for Google Apps. Running on latest installs of WP and CIVICRM.

The Cividesk screen shows that it is configured correctly.

But the log shows the following error:
Finished execution of Cividesk sync for Google Apps with result: Failure, Error message: Google API error - either the extension is not fully configured or there is a database mismatch.

Any suggestions on how to proceed? There is an old forum link but it simply states to re-install. Figure there might be something more current available from the stack-exchange.

Thanks.


texts:
Can I add a space for people to write notes: like dietary needs and or comments??

Is there a way to add a memo field?


texts: I have a civi profile with a custom field where contacts upload their student ID, this works fine, however I can't find a way to display the uploaded file in the profile itself ie: when something is already uploaded it should be visible in the profile form, any ideas? Thanks in advance


texts: Loading a page browser says Waiting for another URL (not mine)

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

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

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


texts: Where are the saved import mapping configs stored?

texts: I have been working on a local CiviCRM install to test importing contacts from a CSV file to the Civi contacts. I am ready to move this import process to our hosted test site but would not like to have to recreate the import mapping again. Are the saved mapping saved in a particular DB table or config file? I cannot find any documentation regarding this.


texts: If I've set up a Financial Type of In-Kind Donation, how should I properly set up the required Payment Instrument?

texts: I've looked at other questions and answers similar to this, but I am still unsure of the best way to proceed. I am aware that I can add a payment instrument and call it whatever I want (e.g. In-Kind Material Donation or In-Kind Volunteer Time), but I would also have to assign it a Financial Account. We have many Financial Accounts set up for managing different types of transactions, but the four that show up in the New Payment Instruments Option window are Accounts Receivable, Deposit Bank Account, Payment Processor Account, and Premiums Inventory. So my questions are: When I set up a new Payment Instrument for In-Kind Donations, which Financial Account should I link it to? Should I choose one of those 4, or should I choose the In-Kind Donation financial account that I created? If I should choose the In-Kind Donation financial account, how do I get it to show up as one of my choices on the New Payment Instruments Option Financial Account drop-down box?


texts: How to work with names that don't fit first, last

texts:
I'm implementing CiviCRM for a client who works with African contacts whose names do not fit CiviCRM's first, [middle,] last format.

e.g. someone's name may have 4 parts, and may be presented in any order, although they will be presented in a particular way on their passport.

In terms of name display it seems that sort_name is favoured, but this presents names like: last, first. This jumbles the order in lists and is not helpful like it is with Western names.

I cannot put the whole name in the last name field and not use the first name because this is a requirement for creating a contact.

I would like to either

get control over 'sort name', e.g. I could make it simply concatenate first name, space, last name, instead of last name, comma, first name.
allow empty first names (then I can just use the last name field).

Is there a way to achieve either of these?


texts: Javascript Contact API - how do I 'do something' with results

texts:
Through javascript, I was hoping to check what groups a user belongs to and then use that information to show / hide something. I can't use ACLs because I'd like the average internal user to be able to enter the information on intake but not be able to edit it in future.

Using the API, I can get an object that has a

    CRM.api3('Contact', 'get', {
  "return": "group",
  "id": 68525 // arbitrary number will need current user
}).done(function(result) {
  // do something
    console.log(result);

});

which returns this

Object { is_error: 0, version: 3, count: 1, id: 68525, values: Object }

The group info is in the values: Objects, how can I reference it?


texts: Civicrm Activities - Scheduling conflicts

texts:
CiviCRM  4.6.11, Joomla 3.4.8

So we're using activities to schedule meetings between our clients and our staff.

Our admin assistant selects the date and time, and the staff member that will be meeting with the client and creates the meeting activity. The creation generates an email and sends the notification to the staff. Which is all great.

The issue we have is the creation of conflicting meetings. Is there anything in Civicrm that would notify the activity creator that there is already an activity scheduled for that date /  time for that staff member? Rather than having to look up their activities before making the meeting?

Any help would be appreciated, and please let me know if additional details are needed.

Thanks!


texts: "Implode" / "Database Deadlock" errors on Civi Webform

texts:
Using Drupal 7.69 and CiviCRM 5.20.2, with Webform 7.x-4.21 and Webform CiviCRM Integration 7.x-4.28.

I have a Drupal webform node that uses custom fields from CiviCRM. This webform has been working well but recently a member of the public called and said it didn't let them submit their form. I looked into the Drupal error log and found 7 error messages. Did some searching but couldn't find any solutions.

All error messages located here: https://pastebin.com/A5vn0VWN

I made my own submission on the webform and it went through but I still saw the following message in the error log. Key difference between the error log for the public (failed) submission and my submission is that for both submissions the following error was logged -- for my successful submission, it was logged once, but for the failed submission, it was logged twice. So I feel like this might be important.

  Warning: implode(): Invalid arguments passed in
  CRM_Core_BAO_CustomGroup::postProcess() (line 1494 of
  /MYHOME/FOLDER/public_html/sites/all/modules/civicrm/CRM/Core/BAO/CustomGroup.php).

Anyone know how to fix this (or what the problem is in the first place)? Wasn't able to decode anything from the error log...


texts: Trigger a reminder if activity has not been recorded in x amount of time

texts:
Is there a way to have CiviCRM send me a scheduled reminder for any contact for whom I have not recorded an activity for in 3 weeks or more? So that if 3 weeks go by and I have not recorded an activity for Contact A, I would get an email notifying me of that.
Or is there a way to build a report showing all the people who haven't had an activity recorded for in 3+ weeks?


texts: How to set a bool (yes/no) value in a CiviCRM contact using Caldera forms?

texts:
We have calera forms where people may submit their interests on particular offerings of our organisation. We would like for each form to set a "yes/no" bool value in the contact's dataset.
Taking over data from the form with Caldera's CiviCRM Contact Processor works. But what to use for the bool field? We tried "1" in the Processor, but this did not store a "Yes" in the respective contact's dataset.
Any idea?


texts: some recurring contributions linked to memberships are not moving on the membership end date

texts:
I'm working with @wmortada debugging some recurring contribution membership renewal issues.

We have lots of memberships with recurring contributions but some of the memberships are not updating as expected when the recurring contribution is received.

The memberships that were not updating were not linked to the recurring contributions via the civicrm_membership.contribution_recur_id field. So we added recurring contribution the link manually. My assumption was that when a contribution for a recurring contribution linked to a membership in this way is received, it would be linked to the membership. But this is not happening for those where we added the field manually.

As a result (as I understand it) CRM_Contribute_BAO_Contribution::updateMembershipBasedOnCompletionOfContribution() is unable to find the related membership and update the membership end date.

We are using @artfulrobot's GoCardless extension for the recurring contribution. CRM_GoCardless_Page_Webhook::doPaymentsConfirmed() calls civicrm_api3('Contribution', 'repeattransaction', $contribution); passing in params for a contribution linked to the recurring contribution.

Can anyone point me to the code that adds a membership payment for a contribution created by Contribution.repeattransaction. Or do I have the wrong end of the stick?


texts: Unable to filter contributions by date in Drupal with views and civicrm_entity

texts:
I am trying to use Drupal Views to create a report of contributions.  I would like the user to be able to filter the contributions by financial type and by date.

To allow the user filter by date using a simple drop down I have installed the civicrm_entity module.  I have previously used this module to create views for activities and events and was able to filter these by date.  However this doesn't work with contributions for some reason.

Using the devel module I have looked at the SQL that is created by views.  It appears that for contributions the receive date is converted from unixtime which gives NULL.  As a result the query returns no results.  If you remove the FROM_UNIXTIME() and ADDTIME() functions from the query, it works as expected.

This is the SQL code for the activity view, which works fine:

SELECT civicrm_activity.activity_type_id AS civicrm_activity_activity_type_id, civicrm_value_publication_details_5.type_of_publication_8 AS civicrm_value_publication_details_5_type_of_publication_8, SUM(civicrm_value_publication_details_5.publication_price_9) AS civicrm_value_publication_details_5_publication_price_9, COUNT(civicrm_activity.id) AS id
FROM civicrm_activity civicrm_activity
LEFT JOIN civicrm_value_publication_details_5 civicrm_value_publication_details_5 ON civicrm_activity.id = civicrm_value_publication_details_5.entity_id
WHERE (( (DATE_FORMAT(civicrm_activity.activity_date_time, '%Y-%m') >= :civicrm_activity_date_filter AND DATE_FORMAT(civicrm_activity.activity_date_time, '%Y-%m') <= :civicrm_activity_date_filter1) ))
GROUP BY civicrm_activity_activity_type_id, civicrm_value_publication_details_5_type_of_publication_8 LIMIT 10 OFFSET 0

This is the SQL code for the contributions view, which doesn't:

SELECT civicrm_contribution.id AS id, civicrm_contribution.receive_date AS civicrm_contribution_receive_date, civicrm_contribution.total_amount AS civicrm_contribution_total_amount
FROM civicrm_contribution civicrm_contribution
LEFT JOIN civicrm_contact civicrm_contact ON civicrm_contribution.contact_id = civicrm_contact.id
WHERE (( (DATE_FORMAT(ADDTIME(FROM_UNIXTIME(civicrm_contribution.receipt_date), SEC_TO_TIME(3600)), '%Y-%m') = :civicrm_contact_date_filter OR DATE_FORMAT(ADDTIME(FROM_UNIXTIME(civicrm_contribution.receive_date), SEC_TO_TIME(3600)), '%Y-%m') = :civicrm_contact_date_filter1) ))
LIMIT 10 OFFSET 0

I'm not sure if this is an error with the civicrm_entity module or with CiviCRM.  Can anyone help?


texts: Exclude contacts from report based on membership they have

texts:
I want to make a report that only shows contacts that don't have any of the listed membership id.

The following SQL code filters the memberships, but still lists contacts that have other memberships, including the ones I want to avoid (e.g.: it shows Joe with a membership type 8, but Joe also have another membership of type 7, so I want to exclude Joe from the report).

When trying to make this with Search Builder I got the same situation.

I'm using Joomla! on that, so Drupal Views are not an option. I have the last CiviCrm version.

  SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_sort_name, contact_civireport.id as civicrm_contact_id, membership_civireport.membership_type_id as civicrm_membership_membership_type_id, membership_civireport.join_date as civicrm_membership_join_date, mem_status_civireport.name as civicrm_membership_status_name

  FROM  civicrm_contact contact_civireport
                 INNER JOIN civicrm_membership membership_civireport
                            ON contact_civireport.id =
                               membership_civireport.contact_id AND membership_civireport.is_test = 0

  LEFT JOIN civicrm_membership_status mem_status_civireport
                            ON mem_status_civireport.id =
                               membership_civireport.status_id

  WHERE ( mem_status_civireport.id NOT IN (1,2,3,4,5,6,7) )

  ORDER BY contact_civireport.sort_name, contact_civireport.id, membership_civireport.membership_type_id

  LIMIT 0, 50


texts:
I find that if I create a new tag via the api, and then try to attach it to a contact with the entity_tag api, it will sometimes fail with the message "'##' is not a valid option for field tag_id".

This is because the entity_tag api checks for the existence of the tag_id using a pseudoconstant lookup -- which is a cached value. How can I easily clear that pseudoconstant cache after the tag has been created to ensure it can be added to the entity?


texts: How to enable CKFinder 3.0 with CiviMail on CiviCRM 4.6.6

texts:
Problem: I cannot get CKFinder 3.0 to work on the CiviMail module. It is currently working in other CiviCRM modules, such as; events.

Installation:
Drupal 7.38
CiviCRM 4.6.6
CKFinder 3.0

I have successfully installed CKFinder and completed steps 1-3 from the CiviCRM wiki, with exception to 3.d. There is a note at the top of the page that says: " This documentation refers to an older version of CiviCRM (3.4 / 4.0). View latest version." I have been unable to find updated documentation for how to install CKFinder into CiviMail on CiviCRM 4.6.6. I have RTFM, but I cannot figure this out =(

Please help! It is greatly appreciated.


texts: User is logged into different account on CiviCRM than Drupal

texts:
This is happening inconsistently, but often enough to be a problem.

So far, we have come across two issues with it:

#1 -  A new user registers for the site.  That user is then taken to a CiviCRM form for them to choose their payment level.  Sometimes, the user is logged out between the drupal registration form and the CiviCRM form, leading to them being prompted to log in again when they reach the Civi payment form.

#2 - Background: We are currently testing some changes to our site, and so the admins all have multiple accounts, most of which have admin permissions.

An admin logs into the drupal site, and then goes to CiviCRM.  For some reason, though, they are logged into one of their other admin accounts on CiviCRM.  They go to "Find a member", and then click the link to the member's drupal profile.  When Civi takes them back to drupal, it throws an error because they are logged into a different account on Drupal than on Civi.

We are using Drupal 7 and CiviCRM 4.6.28


texts: What's the best way to fix this Drush clear cache bug?

texts:
https://issues.civicrm.org/jira/browse/CRM-20292

Hi gang,

I'd love to fix the above bug for the core. Does anyone know the best way to solve it, or where I should begin to look for anything that may cause it?

Create a Drupal View using custom data from CiviCRM contacts.
Save
Run drush cc all on the command line
Reload the admin page for the View
Observe that the custom fields have gone missing, and are not available in the field list.
Click save on the View.
Observe that the custom fields are now present in the list.

This is observed in an instance where Civi and Drupal share a DB on 4.7.17.

Update 1
The bug appears to be that after drush clear CRM_Core_BAO_Cache::getItem('contact fields', $cacheKeyString); isn't returning custom fields in exportableFields sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php. It does upon clicking "save" in the view, however.

Does anyone know where these are populated from, or have any guidance about where to go from here?

John


texts: Auto-renew option not appearing for membership

texts:
In Civi 4.6.12 I am testing recurring PayPal Pro payments for a membership.

A simple recurring contribution works OK once CRM-16698 in place.

However when testing with a new membership, no option for auto-renew appears. CRM-17197 fixed a similar issue when a price-set is used. Any suggestions for fixing this without a price-set?

Thanks, Chris


texts: Batch merge error - wrong data type money?

texts:
I'm trying to clean up some duplicates using the batch merge tool, and it keeps showing this error:

[Error: Processed 2 pair of duplicates out of 9]
value: null is not of the right field data type: Money

Any ideas?

Here's the full debug:

[Error: Processed 28 pair of duplicates out of 77]
Exception: "value: null is not of the right field data type: Money"

#0 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Core/BAO/CustomValueTable.php(595): CRM_Core_Error::createAPIError("value: null is not of the right field data type: Money")
#1 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Dedupe/Merger.php(1777): CRM_Core_BAO_CustomValueTable::setValues((Array:10))
#2 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Dedupe/Merger.php(748): CRM_Dedupe_Merger::moveAllBelongings("434", "204616", (Array:21))
#3 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Dedupe/Merger.php(624): CRM_Dedupe_Merger::merge((Array:2), (Array:3), "safe", TRUE, TRUE)
#4 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Contact/Page/DedupeMerge.php(138): CRM_Dedupe_Merger::batchMerge("26", "263", "safe", TRUE, 2, 2)
#5 [internal function](): CRM_Contact_Page_DedupeMerge::callBatchMerge(Object(CRM_Queue_TaskContext), "26", "263", "safe", TRUE, 2, 2)
#6 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Queue/Task.php(88): call_user_func_array((Array:2), (Array:7))
#7 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Queue/Runner.php(214): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
#8 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php(52): CRM_Queue_Runner->runNext(TRUE)
#9 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php(106): CRM_Queue_Page_AJAX::{closure}()
#10 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php(54): CRM_Queue_ErrorPolicy->call(Object(Closure))
#11 [internal function](): CRM_Queue_Page_AJAX::runNext()
#12 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(278): call_user_func((Array:2))
#13 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:13))
#14 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:4))
#15 /var/www/vhosts/example.com/httpdocs/sites/all/modules/civicrm/drupal/civicrm.module(454): CRM_Core_Invoke::invoke((Array:4))
#16 [internal function](): civicrm_invoke("queue", "ajax", "runNext")
#17 /var/www/vhosts/example.com/httpdocs/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:3))
#18 /var/www/vhosts/example.com/httpdocs/index.php(21): menu_execute_active_handler()
#19 {main}


texts: What is the best way to avoid cartesian product on specific SELECT attributes?

texts:
I faced similar issue in some CiviReports where some of the Select attributes applied with Group function like SUM(), got affected due to LEFT JOINs. Let me provide further clarification on basis of two resolved/current CiviCRM issues -

https://issues.civicrm.org/jira/browse/CRM-16338 where contribution sum(total_amount) got tripled if the contribution is linked with three soft-credits. Although resolved it via splitting the query onto contribution and soft-credit queries respectively, which might not be the right way to do it :/
[civicrm_contribution one-to-many civicrm_contribution_soft]
https://issues.civicrm.org/jira/browse/CRM-16719 where SUM(duration) got doubled if the activity got two target contacts.
[civicrm_activity one-to-many civicrm_activity_contact]


texts: Under what circumstances is API joining available?

texts:
If I go to the API explorer and select ContributionSoft as the entity, I see options to enable joining. But I don't see any joining options available for other entities like Contribution and Participation. Why? I would expect expect that a join automatically becomes possible any time a foreign key exists, and also becomes possible in some other special circumstances (e.g. option value).

Is it really the case that joining is only available on some entities?

If so, what is the logic behind which entities offer joining?
If not, I would like to understand, as an example, how I can execute an API call on Participation which joins Event.


texts: How do I enter multiple payments for one pledge?

texts: I've entered a pledge.  The donor has only paid part of their first payment and plans to make a payment for the balance in a month.  However, the pledge bumped the overdue amount to the following year's pledge.  And it appears that I cannot enter a payment against the first year's pledge now.


texts: Changing language other then default US-EN 'hangs' CiviCrm

texts:
We are using CiviCRM on an existing Joomla site. We first installed CiviCRM and installed afterwards the (localization) language files.

But when selecting an other language then the default US-EN, the system almost hangs. In the resource monitor we can see that the I/O read/write hits the seeling and almost runs out of resources. It happens on the CiviCRM Admin page and also on the front-end pages where we use CiviCRM.

The strange thing is that it worked fine the first time, right after installing the localization files. But some day's later the system became slower and eventually almost hanged. We also tried a clean install of CiviCRM with localization files, but it gave the same problems.

When switching back to the US-EN language it works fine again.

We tried it in both single and multi-language modus.

We use(d) and tried:

CiviCRM 4.7.25 and 4.7.27 whith the corresponding localization files.

Joomla! 3.8.1

PHP5.6 / PHP 7.0 and PHP 7.1 with memory_limit 512MB

MariaDB 10.0.29

Apache libmysql - mysqlnd 5.0.11-dev

Can this be a bug specific to our kind of installation on Joomla/environment? Of do we do something wrong here?


texts: confusing interface for staff registering contacts for events

texts:
When staff (at a client org) go to register people for paid events there is a difference in the interface and the ability to actually take/process a payment depending on what path is taken to the registration form.

If they start from the event admin page and click "Event Links" -> "Register Participant" they get a form that only allows for entering the last 4 digits of the credit card number (which of course is not enough data to actually charge the person the fee)

If they start at a contact record, click the Events tab and then Submit Credit Card Event Registration, once they select the event and the price from the price set, they get a form that allows for entering all necessary payment information which does allow them to charge the user the fee.

Why is there a difference? Is this a bug, or intentional for some reason?


texts:
For some reason, a particular report shows multiple entries for some users. These users have ACLs applied, so I wonder if that's causing the problem?

When I masquerade as a user with limited access, I don't see a problem, but I've just had this screenshot (photo!) sent to me:


texts: Billing address postal code not populated

texts:
If I select an item from a priceset on a contribution form, the billing address appears, but the postcode is not populated even though it is in the contact record.

Any ideas? Ta


texts:
Is there a good hook for on CiviCRM sign in?

[This is to display a message upon login in a cms-independent extension.]

Thanks,


texts:
Installed civicrm 4.6.22 with CiviVolunteer 4.6-2.0.2.
When I wanted to add a project, I got the message: ID 14 of profile is not found.
Upgraded to 4.6-2.1.2 but same problem.

After some searching I found out there was indeed no profile 14. When I copied the profile 'Volunteer Sign Up' with Profile ID 25 and saved is as Profile 14 the problem was solved.

Is it possible that the number of the profile is hard coded instead of taking the next free number in the list of profiles?

My problem was solved, but thought it good to let you know, in case you have the same issue.


texts: SMTP error 501 when extension Transactional Mail - Bounce and Tracking Handler is enabled

texts:
I use CiviCRM (v5.20.0 on PHP 7.3.11 in Joomla) to send scheduled reminders for membership expiration. The mails are sent via SMTP. This works okay when i send a reminder to my own account so i expect it to work for all other accounts. Though I would like to see if mails are indeed sent but I don't see any logging where i could find if, when and to whom an e-mail has been sent.

Now I found an extension called Transactional Mail - Bounce and Tracking Handler and i installed it.
When i try to send mail via the Job Send Scheduled Reminders, I see following error (only when the extension is enabled):

Failed to set sender: b.1.49.90b5f37ff0be023e@ [SMTP: Invalid response code received from SMTP server while sending email. This is often caused by a misconfiguration in Outbound Email settings. Please verify the settings at Administer CiviCRM >> Global Settings >> Outbound Email (SMTP). (code: 501, response: : domain missing or malformed)]

Any help would be appreciated.


texts: Process Inbound Emails Failed: No mail protocol

texts:
I'm unable to pull activities from an email account. I'm using civicrm 4.5.5 and Wordpress. When looking at the job log I get

0
Summary
Finished execution of Process Inbound Emails with result: Failure, Error message: Process Activities failed
Details

Parameters parsed (and passed to API method):
a:1:{s:7:"version";i:3;}

Full message:
Finished execution of Process Inbound Emails with result: Failure, Error message: Process Activities failed

Referencing Process Inbound Emails Failed  I looked at the civicrm error log and got the following error.

Oct 10 10:54:38  [info] $Fatal Error Details = Array
(
    [message] => Could not connect to MailStore for @
Error message:
Empty mail protocol

    [code] =>
)

So it seems like Civi isn't even the information I put in the CiviMail settings. Unlike the question referenced, my problem does not seem to be authentication based. I have an account set up for Email-to-Activity but it doesn't seem to be recognized. Any ideas?


texts: As I begin entering the city St. Paul, the helpful hint pops up with St. Paul, but with a street address following.  Is there a way to eliminate the street address. (Find autocomplete contact metadata?)


texts:
Is the delivery mail status 'unknown' a case of Civi not having sent the mail out at all and is still effectively in the queue to send?

Having lots of problems sending bulk mailing e.g. where only 30 out of 78 emails are successful and the rest set to unknown (as opposed to legitimate bounces)


texts: How to create a custom field for a file upload, and make it private

texts:
We would like to create a custom field in CiviCRM for a file upload, and link it to the CiviCRM Webforms Integration module while at the same time keeping it "private" and is not publicly accessible.

Is there a way to do this in CiviCRM? Or maybe this is a default behaviour and files uploaded to CiviCRM are kept private? (Not accessible from the web directly etc..).

Thanks in advance for any help,


texts: CKeditor extrange behavior: UI settings are only saved partially, and defaults load every time

texts:
I can not, for example, hide a button (spelling for example) using CKeditor settings:

/civicrm/admin/setting/preferences/display?reset=1

If I hide it, I can see how it's hiding at the moment at the "live preview toolbar", but when saving changes, I get it active again when settings page is refreshed.

My crm-ckeditor-default.js or crm-ckeditor-civimail.js file (depending on the tab I'm changing the setting) has the file modified date updated, but without changes there when I was hiding a button on UI, but, and that's for me a headache, I can see changes saved when I'm adding/supressing a plugin, for example:

config.extraPlugins = "colorbutton,justify";

About plugins settings, another unexpected behavior: when at demo civicrm site, using the same version (latest, 5.10.3) you add a plugging, for example "justify", you get, at the moment, some buttons added at live preview toolbar. But not for me: I haven't got any changes.

Ps at civicrm demo site I have not got this issue.


texts: Group Membership Discounts using Group Based pricing

texts:
I am trying to add some functionality to membership pricing where the more people we can get to sign up at a time the bigger the discount they will get. So for instance:

1 - 4 members, $110 each, No discount, $110 - $440
5 - 10 members, $93 each, 15% discount, $465 - $930
11 - 20 members, $82 each, 25% discount, $902 - $1,640
21 - 40 members, $71 each, 35% discount, $1,491 - $2,840
40+ members, $55 each, 50% discount, $2,251 & up

How would I go about adding this to the membership sign up page?  I've installed and enabled the group-based pricing extension

To be clear it would only apply to new members (new signups). And they would need the ability to say how many memberships they want.


texts:
Keep banging my head against this and can't seem to get anywhere.  I've got a dev site up on Centos 6.6 using KVM, with 4 cores and 8 GB of RAM allocated and PHP 5.3.3.  I'm testing a large import via the web interface import.  When I do, I've noticed that the box never uses more than 25% CPU and only has one thread for Apache.  That 25% CPU usage all sits on one CPU core, effectively maxing it out.  The worrisome thing is, I also can't open another instance of WordPress while this is running.  That means that one user could lock out the whole box with a large report or mass deletion!  (BTW, same thing happens on mass deletion of the 35,000 records, so it's not just the web import script.)

BTW:  The host server isn't that busy and is nowhere near maxed out.  Also, other tasks show that there is no bottle-necks in the usual places like CPU, network, or disk usage.

Things I've tried:

Upping php.ini memory_limit - No changes
Changing a thousand parameters in MySQL, mainly memory - No changes
Upping max children in php.ini - No changes
Adding FastCGI+PHP-FPM - No changes
Adding WP-Super Cache - No changes
Adding Memcached - No changes
Upping file descriptors - No changes
Adding Max Memory line to wp-config - No changes
Who knows what else I've forgotten I've tried

Anybody have any ideas here?


texts: Programatically obtaining a Profile's HTML Snippet

texts:
Using the administrative dashboard I can obtain an HTML Form Snippet for any profile which I can use to embed in any webpage or context. This is an extremely useful feature.

Is there any way to obtain it programatically, for example using the API or using Drush or some other command or URI foo, so that administrators can change the Profile and the embedded forms will always be updated?


texts: Linking Drupal page manager variants to Civicrm groups

texts:
I am trying to add a way to create variants on my homepage in Drupal based on a users Civicrm Groups (I have also been looking at tags, but will stick with the former for this point).

The purpose of this is to try and utilise the information gathered from a user's groups in more than just a analytical sense, and to actually display certain content to that user that is either going to be of potential interest to them based on their grouping, or to ensure that information that they do not require can be excluded in place of something else.

An example of this might be a slideshow at the top of a page which has a view controlling it displaying 3 different 'highlighted' promotions.

An anonymous user (The default/fallback variant in panels) might receive information relating to the fact that they could be new, so:
- A shop is also available on the website (with a call to action)
- That they can find out about the website (With a call to action)
- That they can sign up to become a member (with a call to action)

However once they have actually signed up and interacted with the website. Perhaps signed up to become a member, we would then have that information stored in Civicrm, and realistically would not need to promote the fact that they can become a member on front page.

From there, it would be ideal to be able to use the Selection Rules in Page Manager to go through a list of variants and alter what is displayed based on the users groups, and to then switch to another view created with different content/Filters.

I know that you can create variants based on whether a user is logged in / logged out and that you can also create something similar by using CiviGroup Roles Sync and then allocated the Roles to a variant. Using CiviGroup Roles Sync seems to be a little overkill for this situation though, as the actual user roles on the drupal website need only be the standard 'authorised', 'admin', 'anonymous' types, and adding extra roles to match each group would add a massive overhead to the website. All I need to do is to check whether a user has a group matching the variants created and adjust the display accordingly.

It may just be a case of adding an API call to Civi using the 'PHP code' criteria in the Selection Rules of the Page Manager variant and telling it to search through the current users Groups and if it equals X group then trigger, however unfortunately this is a bit beyond me at the moment.

Any help that could be provided on this issue would be greatly appreciated, or any suggested alternatives.

Pete


texts: "Please go back and complete the CAPTCHA" appearing when registering multiple participants for an Event

texts:
We're on CiviCRM 4.7.25 and Drupal. We have the CAPTCHA and ReCAPTCHA modules enabled, and ReCAPTCHA is enabled on a profile we use for event registration.

We're seeing a new error (which never used to happen!) when registering multiple participants.

Behaviour is:

User is not logged in to Drupal
User enters details for Participant 1, and completes Captcha
User enters details for Participant 2. No captcha appears (good!).  User tries to proceed to next step and encounters alert "Please go back and complete the CAPTCHA at the bottom of this form"
User can't progress any further with event registration

The only problem being, there is no captcha!

For now, we have disabled Captcha on this profile, having drawn a blank on other fixes.  Any suggestions gratefully received!


texts: How do I prevent membership renewal reminders originating from VERP addresses?

texts:
On CiviCRM 4.5.5, I have an email address of contactus@example.org configured under Administration > Communication > From Address.

When I send the test email the reply to address is the correct email address.

However when I sent a membership renewal reminder the address is a random set of letters and numbers viz:

Return-Path: <b.85.1343.f05de58212341234@example.org>
Reply-To: <r.85.1343.f05de5812341234@example.org>
From: "APMA" <contactus@example.org>
To: "Paul Murdoch" <prmurd@example.net>
Subject: [CiviMail Draft] Your APMA membership
Date: Sun, 14 Jun 2015 20:27:25 +1000
Message-ID: <E1Z458P-001P0k-9z@s42.example.net>
MIME-Version: 1.0

I am guessing this has to do with the automated tracking of newsletters or similar. However I would like the reply to email address to be contactus@example.org.

How do I debug, track this down and correct this?


texts:
I'm writing an extension to provide a dashboard of membership numbers specific to our organisation. I have created the extension using civix and edited the navigationMenu function to create a menu entry. I have also created the xxxx.xml file in xml/menu to map the url to the page_callback. Is there another step I need to do?

The menu entry appears ok with the correct url but, when clicked, only displays the civicrm "home page" rather than my function. Is there a way to check if the xml file is being parsed correctly and the mapping stored? I checked civicrm_api3('Navigation', 'get'.. but I can't find entries for other extension menus so maybe this is the wrong place to look.

Any help appreciated.


texts: How can I include a non-participant's details in the receipts?

texts:
I have setup an event on a webform with 2 contacts.
Parent: Contact1 -
Child: contact2

Contact1 is there only to create a relationship with CONATCT2 and not a participant of the event.
Contact2 is the actual participant.

When the receipt is triggered after successful payment, obviously Details of Contact1 does not show in the receipt because he is not a participant.

How can I include the details of Contact1 in the receipt template please?
Can anyone help please?
Thanks


texts: How to overwrite template file using php?

texts: I want to override predefined template file in my extension.How to do that using php?


texts: How to include Email address checking in event registration page to avoid multiple contacts entries?

texts:
many time it so happened that individuals made spelling mistake, specially typing email address and therefore multiple contact was created.

Just thought is there a chance to include a 2nd email address field in the registration page and notify the attendee when they make mistake spelling their email address?


texts: Case Dashboard- Cases with upcoming activities and Cases with recently performed activities lists show empty

texts:
In the case dashboard (D7, Civi 5.8.2)

The lists of cases with recently performed or upcoming activities are showing no results

Even though I know there are cases that meet the criteria.

Additionally the find cases results list is not showing any links under Most Recent or Next Scheduled

I think this is a local issue. I had a problem with the site yesterday and restored to overnight backup.

Looks like no data is lost, but these activities aren't showing

UPDATE
My colleague has found 2 SQL views upcoming and most recent activities. Which were not rebuilt during the back up process.

Waiting for confirmation from client all is as expected. Will post more details as an answer later.


texts: Create profile not creating contact properly unless logged in on wordpress with civicrm 4.6

texts:
bit lost here

We have a newsletter signup page which has a form created using profiles.
When the user submits the information it should create a contact (then a civirule will add a new activity when the user gets added to the newsletter signups group)

At first, the issue that we were seeing was, when not logged in (when logged in, it all works fine), when civirules was trying to add the user to the group it would say "source_contact_id is not a valid integer"
Disabling the civirule gets you to the success page but doesn't fix the underlying issue.

When logged in the contact is created properly
The newsletter page responds as so:
First Name
tester
Last Name
test
Email
test@example.org

And adds the contact info to the contact

When not logged in it returns:
First Name
Last Name
Email

And doesn't add any contact info to the contact
The civi url would be for example: ?page=CiviCRM&q=civicrm/profile/view&reset=1&id=123456&gid=12

So in short, if the form is filled in and the user is logged in, everything works as it should. If it is an anonymous user the contact gets created but the name & email isn't created
Permissions are set up with anonymous being able to edit/create profiles and even just giving permission to everything doesn't help...
There's no errors either...

Please help!!!


texts: Error when trying to create a public form using a profile with a Grant field

texts:
I am trying to create a publicly accessible grant application page using a CiviCRM profile with form fields for Grant record information.

To test this, I created a profile with only one Grant-record field in it.

When I then create a Wordpress post using the shortcode for the profile, it gives this error: "Profile search, view and edit are not supported for Profiles which include fields for more than one record type."

If I change the form to have just one field of some other type of field (with no Grant field), for example, Individual - Birth Date, then it works just fine.

Does anyone know how to fix this?


texts: AGPL: Should sites provide public download links for CiviCRM extensions?

texts:
I guess this question has a few parts:

Are CiviCRM extensions are considered to be modifications of CiviCRM?
Are custom file overrides considered to be modifications of CiviCRM?
If so, then under CiviCRM's AGPL license, are sites running extensions and custom file overrides required to make those modifications available for download to people who use the site?

For example, if custom code (file override or extension) modifies functionality of a public-facing event registration page, does that page need to contain links to download the modified code?


texts:
Wordpress 4.4
CiviCRM 4.6.10

I installed recently and was in initial setup stages. I had dashlets working fine and created new dashlets. Now all dashlets are giving error

401 - Unauthorized
Your authorization failed.
Please try refreshing the page and fill in the correct login details.

I was working with extensions and configuring the URLs for extension folders. I installed CiviRules and logger successfully. I've dsiabled these and removed extension URLS now.

I've searched and cannot find similar errors.No Wordpress errors showing.

Any ideas?

Thanks

Alan


texts: Embed profile in separate Web site (WordPress)

texts:
Is it possible to embed a profile (form) in a Web page on a different Web site?  My CiviCRM is on a WordPress site, so there is no "MORE" option to capture an HTML snippet when looking at the properties of my Profile.  I know I can embed the form in a Web page on the CiviCRM Web site, which inserts something like [civicrm component="profile" gid="33" mode="create" hijack="1"]
But obviously that alone won't work if I embed it on a page on another Web site.  Is there a way to do this?
[And if so, do I also need to set "Accept profile submissions from external sites" to yes?  Is this a security risk?]


texts:
I'd like to add custom code in my contribution receipts that does the following:

{if $contributionIsTaxDeductible == True}
No goods or services were exchange for this donation
Tax id 12-3456789
{/if}

Is there a way to do this?


texts:
I need to use 2 price sets on a membership page. The first is for National membership and has several options, mostly concerning the publications delivered with the membership level. This National membership is required. The second price set is for local chapter membership and members could select none, one or several. Each local chapter has its own price.

This could look something like this:

National membership
 - email newsletter as pdf - $10
 - printed newsletter by post - $25
 - printed newsletter plus glossy magazine - $75

Local chapters
 - West - $15.00
 - Central - $25.00
 - East - $10.00
 - None - $0.00

Is there a way to accomplish this?

Thanks in advance,
JWP


texts: I am trying to configure an Event to repeat on every second Sunday but upon saving the event it shows incorrect dates in the Confirmation screen where it shows the same start date for each month and upon confirming it gives an error stating "Invalid day name". I tried by giving other day  and it is working correctly but not for "Sunday". This was on CiviCRM version 5.10.3. I tried by upgrading to 5.13.2 but the issue was same in that also. I am not sure what I am missing. Kindly help me to fix the issue.


texts: I would like to update our logo in automatic email links to reflect the new brand.  I have not tried anything as I am new to the programme but would like some assistance here.


texts: I'm building my first extension with a basic Quickform. I'm trying to figure out the options I have for different field types, but I'm not seeing where the documentation is on definitions of types, especially the extended types.  For example, the Developer Docs talk about deprecated types for dates, and they mention using datepicker, but where would I find all the options I have available to me for the datepicker type? In this case, I'd like to have a datepicker without the time part, or set the minimum date. But same goes for other types as well, I'm not seeing the documentation or examples.  Where can I get more details on each extended type and/or examples of use?


texts: 4.6.2 on Joomla: Entering Contribution under single contact times out

texts:
What log information is best to post for this issue?
When I manually enter a contribution under the Contribution tab of a contact's record, the process times out with a blank white screen. When I enter it as a "New Contribution" under the Contributions menu item, it works flawlessly.

I did test this in the Demo Joomla and it does work. My database has over 30k contacts.

I am not knowledgeable of the process flow so I am probably wrong about this but could the problem be a contact_id search issue since with a "New Contribution" a search of the contact is required/retrieved first rather than the process having to go out and search for the contact under the in-record process?


texts: Find contacts with multiple relationships of same type

texts:
We try to gather total number of users of same Relationship Type but different number of Relationships (mean, user can be a Member of no / 1 / 2 3 .. etc. Organisations).

Here's a code we use:

$start = microtime(true);
$total_count = civicrm_api3('Contact', 'getcount', array(
 'return' => "id",
  'contact_type' => "Individual",
  'is_deleted' => 0,
      ));
  $result = civicrm_api3('Contact', 'get', array(
    'sequential' => 1,
    'return' => "id",
    'contact_type' => "Individual",
    'is_deleted' => 0,
    'options' => array(
       'limit' => $total_count,
       ),
      'api.Relationship.getcount' => array(
        'is_active' => 1,
        'relationship_type_id' => 4,
)));

foreach ($result['values'] as $r) {
  $relscount[] = $r['api.Relationship.getcount'];
}

echo '
';
print_r(array_count_values($relscount));
echo '
';
 $time_elapsed_secs = microtime(true) - $start;
  echo 'Time spent: ' . $time_elapsed_secs . '
';

# Records: Time #
# 1000: 4.2179801464081
# 5000: 23.655788183212
# 15000: 74.082838058472

There is one tiny issue though: we've around 100K Contacts in a DB and we haven't been able to find out how much time it takes to count 'em all..

The most obvious solution seems to be one of array traversing techniques involving for/foreach/while and "limit" + "offset". Just wondering, what is  a better/smarter move, if exists?

UPD

Code which uses "getcount" is even slower:

$start = microtime(true);
 $result = civicrm_api3('Contact', 'get', array(
  'debug' => 1,
  'sequential' => 1,
  'return' => "id",
  'contact_type' => "Individual",
  'is_deleted' => 0,
  'api.Relationship.getcount' => array(
    'contact_id_a' => "\$value.id",
    'relationship_type_id' => 4
  ),
  'options' => array('limit' => 15000),
 ));

 foreach ($result['values'] as $r) {
   $relscount[] = $r['api.Relationship.getcount'];
 }

 echo '
';
   print_r(array_count_values($relscount));
 echo '
';

$time_elapsed_secs = microtime(true) - $start;
  echo 'Time spent: ' . $time_elapsed_secs . '
';

  # Records: Time #
  # 15000: 101.00403809547


texts:
When I merge two contacts I lose relationship info on both 4.6.5 and 4.7.3 The relationships come up as inactive with the current date as the end of the relationship. I don't see any errors except relationships are 0 after the merge and the relationships are shown as inactive

I did some research which points to a possible schema issue which suggests you verify the schema.  I am somewhat concerned about doing that, especially where I need to merge 2 records, if it fails I either need to recover the database or find a new pair of records to merge.

I am looking at upgrading to 4.7.8 but not sure there are additional fixes which will resolve the issue.


texts: Somehow our summary fields got a old version of sumfields.php. What's the best way to get the current versions?

texts:
The triggers weren't enabled and I tried to get them enabled.  Couldn't seem to.  Tried uninstalling and reinstalling still didn't work.  Dug into it and found it was getting an error when trying to copy the summary fields data from the temp table into the custom fields table.  The error was violating a constraint.  Debugged it a bit and found that it was creating a row with a null contact_id.  Dug into that and found that sumfields.php was doing an outer join incorrectly.  I figured that couldn't be current code and looked at the latest and greatest and found that sumfields.php file was different from ours.  Sadly, there are no version numbers or anything on that file so it's hard to tell what version it is.

The info files says it's version 3.1.3.  I guessing the last upgrade somehow messed this up.

So the question is what's the best way to get current.  Is it to just replace all the files in the custom_ext with the current ones or is it to uninstall and delete those files or maybe change the info so it thinks it older so I'll prompt for upgrade.


texts: Help needed: Need to run reports to find information on number of members during a specific year

texts:
Good morning,

I'm a program assistant at the NH Public Health Association, and we need to determine the following data:

Number of current (as of a certain date within a year; e.g., February 26, 2019) members of NHPHA
Number of members at any time during a specific year (e.g., 2019)

We have tried to use the Reports function to determine these data, without success. Can anyone explain how to do this? Please let us know if there are specific filters we should be using. We appreciate any help anyone could give us. Thanks in advance!

Sincerely,
Jess


texts: Is there a way to disconnect CiviCRM contacts and Drupal Users via the UI?

texts:
I have a connection between a Drupal User and a CiviCRM contact that I would like to remove. I found this Q&A which describes how to do that on the database level.

I was however wondering if there is any way to do that via the UI. Any hints? (Using CiviCRM 4.6.9 and latest Drupal.)


texts: After creating my extension, what is the root for my new tab?

texts:
1- I create a plugin with my hook :

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

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

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

}

With this function I added a new tab.

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

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

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

    civicrm/order
    CRM_Order_Page_Order
    Order
    access CiviCRM

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

Please can you help, what settings I missed?

Thank You

Nilda


texts: Bug in CiviContribute - PayPal Express not working for recurring contributions

texts:
I have set up a test PayPay Express payment processor and created a contribution page that allows the user to create a recurring donation.

When I use this page, I get the "PayPal Checkout" button appears and takes me to PayPal.  Everything proceeds as expected with the PayPal screens and I get taken back to my site, where I am told I need to click the "Make Contribution" button.  I do that and get back a page that says:

Notice: Undefined index: returnURL in CRM_Core_Payment_PayPalImpl->createRecurringPayments() (line 372 of /var/www/html/SOTS/sites/all/modules/civicrm/CRM/Core/Payment/PayPalImpl.php).
Notice: Undefined index: cancelURL in CRM_Core_Payment_PayPalImpl->createRecurringPayments() (line 373 of /var/www/html/SOTS/sites/all/modules/civicrm/CRM/Core/Payment/PayPalImpl.php).
Notice: Undefined index: installments in CRM_Core_Payment_PayPalImpl->createRecurringPayments() (line 380 of /var/www/html/SOTS/sites/all/modules/civicrm/CRM/Core/Payment/PayPalImpl.php).
Notice: Undefined index: transactionid in CRM_Core_Payment_PayPalImpl->createRecurringPayments() (line 399 of /var/www/html/SOTS/sites/all/modules/civicrm/CRM/Core/Payment/PayPalImpl.php).
Notice: Undefined index: amt in CRM_Core_Payment_PayPalImpl->createRecurringPayments() (line 400 of /var/www/html/SOTS/sites/all/modules/civicrm/CRM/Core/Payment/PayPalImpl.php).
Notice: Undefined index: feeamt in CRM_Core_Payment_PayPalImpl->createRecurringPayments() (line 401 of /var/www/html/SOTS/sites/all/modules/civicrm/CRM/Core/Payment/PayPalImpl.php).
Notice: Undefined index: settleamt in CRM_Core_Payment_PayPalImpl->createRecurringPayments() (line 402 of /var/www/html/SOTS/sites/all/modules/civicrm/CRM/Core/Payment/PayPalImpl.php).
Notice: Undefined index: paymentstatus in CRM_Core_Payment_PayPalImpl->createRecurringPayments() (line 406 of /var/www/html/SOTS/sites/all/modules/civicrm/CRM/Core/Payment/PayPalImpl.php).
Notice: Undefined index: pendingreason in CRM_Core_Payment_PayPalImpl->createRecurringPayments() (line 407 of /var/www/html/SOTS/sites/all/modules/civicrm/CRM/Core/Payment/PayPalImpl.php).
Notice: Undefined index: payment_status_id in CRM_Contribute_BAO_Contribution_Utils::processConfirm() (line 198 of /var/www/html/SOTS/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution/Utils.php).

It also says that the payment was successful, but when I look at it in CiviCRM, it has a status of "Pending" and my PayPal account shows no notification was sent.

I have done some digging.  After the "Make Contribution" button is pressed, the application ends up in PayPalImpl.php, createRecurringPayments(...).  This never sets the $param['payment_status_id'].  Later on, the application gets to Confirm.php, completeTransaction(), which looks for $result['payment_status_id'] of 1.  Only if this is true does the transaction get marked as completed.

So, the question is, should createRecurringPayments() set the payment_status_id, and to what?

Note that if I try with a single donation, it works ok (i.e. the transaction is marked as complete).

Thanks


texts: eWay: Undefined variable: CRM16923 AnUnreliableMethodHasBeenUserToDeterminePaymentProcessorFromContributionPage

texts:
Undefined variable:
  CRM16923AnUnreliableMethodHasBeenUserToDeterminePaymentProcessorFromContributionPage
  in
  .../wp-content/plugins/civicrm/civicrm/CRM/Contribute/BAO/Contribution.php
  on line 2459

  Notice: Undefined offset: 9 in
  ..../wp-content/plugins/civicrm/civicrm/CRM/Financial/BAO/PaymentProcessor.php
  on line 221

I am using Eway (Recurring) Payment Processor : https://github.com/fuzionnz/com.chrischinchilla.ewayrecurring

CiviCRM version: 5.13.4
Wordpress version: 5.2.2
The problem occurs when I view a Contribution and then click on Email Invoice, it gives the above error.


texts: 500 server error for live contribution page

texts:
Latest Wordpress version with multisite setup in wordpress - not Civi.  Upgraded to civicrm 4.6.10 - also existed with civi 4.5.8 - no changes.

I can go to an existing page via the wordpress side (example.com/donate) and the civi - content shows fine.  However, if I click contribute on that page (or use the live link from civi back end) I get a 500 server error.  No obvious messages with debugging turned on (Are there log files I should review?)

Happens with stripe and paypal and even the manual option of sending by check!

It does not seem to like example.com/donate/?page=CiviCRM&q=civicrm/contribute/transact

or

http://example.org/civi?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=1

EDIT:

Turned on PHP error reporting on my host and was delivered an error message about my google calendar plugin.

Fatal error: Class 'WP_Requirements' not found in /root/www/wp-content/plugins/google-calendar-events/google-calendar-events.php on line 46

Deactivation of the Plugin allows the system to process normally.

Same issue: posted yesterday to developer - no response yet: https://wordpress.org/support/topic/plugin-not-compatible-with-civicrm-profiles


texts: Activity processor on emails - doesn't work if sent to BCC recipients?

texts:
I send an email from my Gmail account to say 200 recipients and because I don't want their addresses to be public, I BCC them

I also BCC my Activity processor account.

In Civi, the Activity processor account record appears but none of the other 200 recipients.  I'm guessing this is because they were BCC?

If I don't BCC them, they appear on the relevant Civi record.

Is this an error or by design?


texts: How do I create a Smart Group of Participants using a Custom Data Field in Events?

texts: We use the Events module to offer three main types of classes: adult art classes, youth art classes, and professional development workshops. Students register online. What I would like to be able to do is create Smart Groups of Participants based on the subject matter of the class, for example: painting, drawing, or portfolio review, so that we can mail to these groups and let them know about future classes they might be interested in. I created a Custom Data Field called "Class Department" with multiple choice options for the different subjects assigned to the Event types that we use for classes: Class (adult), Class (youth), and Workshop. My issue is that, having done that, I'm unable to use the "Class Department" data field as a search option in Advanced Search, even though I clicked the "is the event searchable?" box. Is this a version issue? We're still on 4.3.11. If this becomes available in later versions, what version does it first become available in?


texts: What's the best way to update ambiguous relationship types?

texts:
On some older sites we are now getting warnings relating to ambiguities in relationship set ups.

What is the best way to change the relationship settings without affecting existing relationships?

The relationship in the image is specified as the case manager in some case types, and I think that this is causing problems with the cases. (Clients are showing as their own case manager after the role has been assigned). But I have editted relationship settings before and broken cases.

Is there a way to update settings for a relationship type that won't break existing relationship of that type, or any related cases?

D7.69 C20.2


texts: How to show only the relevant County/State of multiple countries in a profile?

texts:
I created a profile with Countries and County/States along with name and address.

County/States actually merges all the available states regardless of selected country.

Is there a way to show only the relevant county depending on selected country?

My civi version is 4.4.14


texts: What payment processors work with WordPress Caldera and CiviCRM, and which of those work with recurring

texts: This is an open-ended question to pull together information as folk develop more options. The below answer is based on snips from https://chat.civicrm.org/civicrm/pl/4refrsqotib9tf9gyrscffk8my


texts:
Upgraded from 4.6.11 to 4.7.1 and now this this error when running /wp-content/plugins/civicrm/civicrm/bin/cron.php

  Fatal error: Uncaught exception 'Exception' with message 'Function
  "is_admin()" is missing, even though WordPress is the user framework.'
  in
  /home/xxxx/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/Base.php:261 Stack trace: #0
  /home/xxxx/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/System.php(219):
  CRM_Utils_System_Base->theme('PEAR_Error('DB Error: insuf...', -26, 16, Array, '
  [nativecode=10...') #5
  /home/xxxx/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(564):
  DB_Error->DB_Error(-26, 16, Array, ' [nativec in
  /home/xxxx/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/Base.php
  on line 261


texts: I found the API CSV IMPORT GUI that allows me to import events. The one thing I can't figure out how to map is the location details - city and state. How do I map those two items?


texts: Using Drupal Rules to create a CiviCRM Contact - does not load entity ID

texts:
I'm trying to create a new Civi Contact for a new Drupal user when added by admin.

I then want to copy over Drupal registration field values to the newly created CiviCRM contact.

I'm getting stuck at first base. I created a rule to create the CiviCRM Contact entity. That works fine.

Then I'm using the entity-created-id - the contact ID to populate the FK to Contact ID parameter required for making a linked email entity.

But it is not loading the entity-created-id no matter what recipe of rules I'm trying.


texts: What is the easiest way to set up cron for CiviCRM on a Drupal 7 installation?

texts:
I have created a test instance of CiviCRM that uses Drupal 7 as the CMS. It's running inside a Ubuntu Desktop virtual machine that has a LAMP stack installed on it (Apache2, php7.2 and mySQL).

I am very new to Linux and would like to set up a cron job to run CiviCRM's scheduled tasks. I have looked at https://docs.civicrm.org/sysadmin/en/latest/setup/jobs/, but I confess that I find it confusing. I haven't set up any cron jobs for Drupal, either. Can anyone help me, please?

Many thanks in advance,

Daniel


texts: What is the recommended/supported version of Webform CiviCRM module for Drupal 7?

texts: What are the differences between Webform CiviCRM versions 7.x-4.x and 7.x-5.x?


texts: Extended Report - Line Item report for price sets final line concatenating all records

texts:
The Extended report  Line Item report for price sets was working perfectly fine till recently.

Now the last line is concatenating all first name and last names.  See Screenshot


texts: How to perform searches with groups of OR statements joined by AND statements

texts:
Search Builder in CiviCRM allows groups of AND statements to be connected by OR statements, but not the other way around.

That is, I can perform a search like:

(X AND Y AND Z) OR (A AND B AND C)

but not:

(X OR Y OR Z) AND A AND B AND (C OR D).

If I want to do the latter, I have to rewrite the entire query for each of the elements in the OR statements.  That gets pretty tedious pretty quickly.

My questions are:

Why is it like this?
Is there some way to search (within CiviCRM with all the benefits and options for search results) as per my second example?

Thanks,
Lewis


texts: CIVI mail - URLs inserted directly into an email template do not direct the user to the correct web page

texts:
I inserted a url into a CIVI email template - On testing the email, clicking the link which has not changed it re-directs the user to our site and gives an Error 404 page not found.
https://www.digital10.io/wp-content/plugins/civicrm/civicrm/extern/url.php?u=366&qid=586
Any experience of this behaviour we are on civi 5.24.5? pending upgrade to 5.29 but having issues, reluctant to do so. We are sending via a Sparkpost plugin.


texts: I've got 100% discount, PayPal and the register button does not show for civiEvent, how do I get it to show?

texts:
CiviCRM 5.26.2
Ominpay version of PayPal payments
CiviDiscount
We apply the 100% discount code and the payment form is hidden. There is no register button.
Using the browser inspection tool, there is inline script that always hides the buttons. I can't see this in the CiviCRM source code am unsure where it comes from.
CRM.$(function($) {
  $('.crm-submit-buttons', $('#billing-payment-block').closest('form')).hide();
});

We suspect that this is a PayPal related feature as the PayPal 'off site' workflow is different.


texts: CiviBooking Wordpress Error on Adding Resouces

texts:
Civicrm 5.25.0 and Wordpress 5.3.3

When I go to Add a Resource I get

Fatal error: Access level to CRM_Admin_Form_Resource::$_id must be public (as in class CRM_Admin_Form) in xxx/uploads/civicrm/ext/uk.co.compucorp.civicrm.booking/CRM/Admin/Form/Resource.php on line 40

Is there a way around it?


texts: Can members sign-up for two memberships from same organization?

texts:
Is it possible to use price sets to require members to sign up to 2 membership (ideally both autorenewed)? One is an annual insurance fee, the other a monthly membership fee. I'm getting error messages at the moment when testing that states that signing up to 2 memberships from one organization is not doable.

is making a 2nd, separate organisation for the insurance the way to go?

Thank you very much for your help,
David


texts: Can CiviCRM be integrated with a VoIP system?

texts: Who's done it and what advice do you have?


texts: Need help with error in creating a dashboard report

texts:
Trying to track down this error:

  Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame thrown in civicrm/Civi/Core/Transaction/Manager.php on line 107

It occurs any time the "available for dashboard" option is checked for a report and then the report is saved.  This is civicrm 4.6.4 on drupal 7.38, php 5.3.29 and mysql 5.1.56.

Tried to post the backtrace here, but stackexchange gives me the lovely "this looks like spam" flag. :-/

Tracing through the code, I can see that in CRM/Core/BAO/Dashboard.php, the addDashlet() function, the call to $dashlet->save(); is failing silently on line 459.  So then there is no record in the civicrm_dashboard table for the dashlet, and when it next tries to add records to civirm_dashboard_contact it fails on the foreign key index.

So I don't get why the dashlet save function would fail at all, let alone fail without an error.

Any help appreciated.


texts:
I recently set up a new CiviCRM and everything's working fine but there's a couple of error messages that I get in the admin menu that I would love to resolve:

When I go to 'Manage Extensions', this is the warning message at the top:

Warning: Invalid argument supplied for foreach() in CRM_Extension_Browser->_discoverRemote() (line 196 of ...../sites/all/modules/civicrm/CRM/Extension/Browser.php).

And it doesn't list any extensions that are available.

I also remember seeing a similar warning about something it couldn't validate but I can't recreate it. I've enabled the Drupal logging so that I can pick it up if it happens again.

EDIT:

Also seen similar question here but no reply: https://stackoverflow.com/questions/35456655/warning-invalid-argument-supplied-for-foreach-in-crm-extension-browser-disc

And issue raised here but no response: https://issues.civicrm.org/jira/browse/CRM-18054


texts: Up to what version of CiviCRM is secure to upgrade on a Drupal 6 site?

texts:
CiviCRM no longer officially supports Drupal 6.x. as of version 4.2 but seems that more than one is running versions above 4.1 with Drupal 6 site.

Up to what CiviCRM version I can upgrade my Drupal 6 site without suffering any incompatibility?


texts: Civicrm registration form sending to Paypal but registration info not being sent back to Civicrm

texts:
Using civicrm 4.7.3. We have an event registration form through our civicrm installation on Wordpress 4.4.2. Registrants using this form are sent to PayPal Standard and the payment is received by PayPal but the registrant's information is not being sent back to the Civicrm database. Absolutely no information is sent back from PayPal. This worked using the PayPal sandbox but not the live site. My payment processor is set to PayPal with the correct merchant account email and the url set to https://www.paypal.com (Test payments now set to same since site is live). IPN is enabled in PayPal. My civicrm_system_log table shows the sandbox notices but nothing since I took the site live.

Help! Does anyone have an idea why this would be the case?
Thank you.


texts: Household is missing from Dedupe rule page

texts: A week ago I was deleting some rules in the 'find and merge contacts' page, and it appears to have deleted the entire block of household rules, so that there is no way I can add new household rules, and adding new households does not work due to no rules existing. The individual and organisation blocks are both there, but not the household one. How can I get this back?


texts:
I am having problems with CiviRules preventing a contact being added to a group.

I have a contact form where people request information, and the person is added to group "web contacts". This works nicely and the request is added as a note.

I then add a CiviRule that basically says
When a contact is added to a group and the group is "web contacts" then add an activity to a contact [Me] to mail the contact of the fact.

This totally prevents people being added to the group "web contacts" at all.

  Trigger: Contact is added to Group

  Linked Condition: Group is Webbkontakter

  Linked Action: Add activity to contact    Type: Email Status: Scheduled
  Assignee(s): Martin Skjöldebrand

"web contacts" == Webbkontakter above.

Am I having a brainfart or something? Shouldn't this work?


texts: Update script fails: database already upgraded

texts:
Trying to update from Wordpress CiviCRM 4.7.11 > 4.7.23.
Update script does not work. Keep getting the same message:

"Sorry but we are not able to provide this at the moment. Your database has already been upgraded to CiviCRM 4.7.11"

I did everything exactly as described: stayed logged in during the process, removed the complete civicrm plugin, installed the new version, removed cache files, cleared browser cache etc.

Does anybody know what the problem is? I know there must be old files somewhere. But where?


texts:
I would like to categorize the Contribution pages.
How can I use Tags or Groups for that?


texts: CiviCRM Mailings external links forbidden

texts:
Some people who received our big mailing get a forbidden message when they click on a link that goes to an external site. Most people are not getting the error.

  Forbidden You don't have permission to access
  /sites/all/modules/contrib/civicrm/extern/url.php on this server.

I've tested while not logged in to our website. I've tested on various IP addresses. I've tested while logged in as several types of roles with varying permissions. It's clearly a firewall issue, but if I post it somewhere else, I may push back about it being a CiviCRM issue. Why does my server think that this harmless CiviCRM external link tracking process is a SQL injection concern?

CiviCRM 4.7.15 Drupal 7

Apache SSL Error log reports:

[Tue Oct 10 23:45:07.760744 2017] [:error] [pid 27564:tid 140558165042944] [client 107.77.xxx.xxx] ModSecurity: Access denied with code 403 (phase 2). Pattern match "(^[\\"'`\\xc2\\xb4\\xe2\\x80\\x99\\xe2\\x80\\x98;]+|[\\"'`\\xc2\\xb4\\xe2\\x80\\x99\\xe2\\x80\\x98;]+$)" at REQUEST_COOKIES:ajs_user_id. [file "/usr/share/modsecurity-crs/activated_rules/modsecurity_crs_41_sql_injection_attacks.conf"] [line "64"] [id "981318"] [rev "2"] [msg "SQL Injection Attack: Common Injection Testing Detected"] [data "Matched Data: \\x22 found within REQUEST_COOKIES:ajs_user_id: \\x224622165\\x22"] [severity "CRITICAL"] [ver "OWASP_CRS/2.2.9"] [maturity "9"] [accuracy "8"] [tag "OWASP_CRS/WEB_ATTACK/SQL_INJECTION"] [tag "WASCTC/WASC-19"] [tag "OWASP_TOP_10/A1"] [tag "OWASP_AppSensor/CIE1"] [tag "PCI/6.5.2"] [hostname "www.fosterclub.com"] [uri "/sites/all/modules/contrib/civicrm/extern/url.php"] [unique_id "Wd1bg857a7YAAGus-PcAAADK"]

I'm stumped because I can't reproduce the error. The error log only shows a few of these but the access log shows several times the link was successfully accessed. Can't find a pattern.

Here is a screenshot that someone sent me.

Edit: the file permissions for /sites/all/modules/contrib/civicrm/extern/url.php:

-rw-rw-r-- 1 drupal-user server-group 1707 Apr 17 04:44 url.php

Link in email:

https://www.example.com/sites/all/modules/contrib/civicrm/extern/url.php?u=123099&qid=4531881

CiviMail translated that link from what we put in, which is the ultimate destination. Should be an auction site.


texts: I am looking for a way to add an action or link that will automatically print(generate pdf) an envelope for a contact from the summary tab in civicrm. This would bypass the selection of a template. Any thoughts on a module or link i can use?


texts:
I have an individual who receives from one to many honors. The honors are listed and an organization.  I created a relationship and have loaded the relationship. If I look at relationships in the contact record I am able to see them.

I want to export the relationships or at least the contact numbers so I can take them to another database and bring the records together. I am using a "Software as a Service", I don't have access to the database.

I tried this on 2 Civi systems one at 4.6.5 and the other one at 4.7.8.


texts: Does CiviCRM ship with or have an extension for a donor wall? If so, how well does it work? If not, what is a good solution for creating and managing a donor wall that will work with CiviCRM installed under WordPress?


texts: When filing an activity in CiviCase, there's the option "Send a Copy" to people listed in Case Roles. The email is sent correctly. However, when I "reply" to the email, the address of the sender is a default system email. Is there an option to have the "reply" email be the user that send the copy?


texts: Install Error DB Error: extension not found

texts:
Using "upload package file" or "install from folder" on a clean new Joomla 3.5.1 installation without any other extension I get this error :

Cannot open mysql://XXX:YYY@localhost/XXX?new_link=true: DB Error: extension not found

Tried 4.7.7 and for testing even CiviCRM 4.6.16 LTS -> same error

PHP Built On Linux dd36620 3.13.0-85-generic #129-Ubuntu SMP Thu Mar     17           20:50:15 UTC 2016 x86_64

Database Version mysqli 5.6.27-nmm1-log

Database Collation   latin1_swedish_ci

Database Connection Collation    utf8mb4_general_ci

PHP Version  7.0.4-nmm1

Web Server   Apache

WebServer to PHP Interface   fpm-fcgi

Joomla! Version  Joomla! 3.5.1 Stable [ Unicorn ] 05-April-2016 22:45
   GMT

Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ]
   24-Apr-2013 00:00 GMT

User Agent   Mozilla/5.0 (Windows NT 10.0; Win64; x64)
   AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94
   Safari/537.36

Tried as suggested in the WIKI

php_value memory_limit 128M

php_value register_globals off

php_value max_execution_time 600

Maybe someone has an idea what I could do to get it installed, thanks


texts: Quickly entering attendance with barcodes

texts:
I use CiviCRM for a non-profit organization that, among other things, organizes a yearly funweek for children. This year, we introduce event badges with a barcode. I was hoping to be able to use this to quickly register the actual attendance for each day.
The barcode value is entered into the External ID field of each child's contact record. On the event registration I have custom fields for each day of the week.
Our plan was to have one of the volunteers scan each barcode as the children enter the building, then I could easily add the event id, presence and an indicator of the day to this list as that would be the same for each line.
Unfortunately this doesn't seem to work, because it doesn't seem to be possible to update event registrations unless I know the event registration id. Knowing the External ID and Event ID is apparently not enough to make a match. I find this odd as I think it is illogical to have one person register twice for the same event.
Is there a way around it except by exporting all attendees and using the export as a lookup-table to add the event registration id to the import-file?


texts:
i doing customize CiviCRM 5.29.1 for Wordpress 5.5.1 last version.
i have create 2 contact type individual: Donor, Student
Donor donation money for student. Donation money allocate to student. student have money for study
Ex:

Donor(Tomy) donation $500 for student(David) in 2019

Donor(Tomy) donation $500 for student(David) in 2020

Donor(Tomy) donation $500 for student(David) in 2020

....

Donor(Nancy) donation $200 for student(Olive) in 2019

Donor(Nancy) donation $400 for student(Olive) in 2020
...

I want when view student then see all history donation from Donor.
and when view Donor then see all history donation for student.
How can do that?
i try create new Contribution but i only see contribution from Donor but i not see Contribution allocate to Student.
please help me, sorry my english not good. hihi
i attached new Contribution

+++++++++
Soft Credit have maximum 10 row for each contribution. but Donor donation $10,000 for 100 students.