texts: best practice for using core base functions (CRM_Utils_System_Base) from an extension?

texts:
CRM_Utils_System_Base defines a great set of key functions that look like they should work in any system.

What is the correct way to access this functionality within an extension?

FYI these are the classes public methods:

addHTMLHead($head)
addScript($code, $region)
addScriptUrl($url, $region)
addStyle($code, $region)
addStyleUrl($url, $region)
appendBreadCrumb($breadCrumbs)
appendCoreResources(&$list)
authenticate($name, $password, $loadCMSBootstrap = FALSE, $realPath = NULL)
checkPermissionAddUser()
clearResourceCache()
cmsRootPath()
createUser(&$params, $mail)
flush()
getBestUFID($user = NULL)
getBestUFUniqueIdentifier($user = NULL)
getDefaultBlockLocation()
getDefaultSiteSettings($dir)
getLoggedInUfID()
getLoggedInUniqueIdentifier()
getLoginDestination(&$form)
getModules()
getTimeZoneOffset()
getTimeZoneString()
getUFLocale()
getUfId($username)
getUniqueIdentifierFromUserObject($user)
getUser($contactID)
getUserIDFromUserObject($user)
getUserRecordUrl($contactID)
getVersion()
isUserLoggedIn()
languageNegotiationURL(
loadUser($user)
logger($message)
logout()
mapConfigToSSL()
outputError($content)
permissionDenied()
postURL($action)
resetBreadCrumb()
setMessage($message)
setMySQLTimeZone()
setTitle($title, $pageTitle = NULL)
setUserSession($data)
theme(&$content, $print = FALSE, $maintenance = FALSE)
updateCMSName($ufID, $email)
updateCategories()
url($path = NULL, $query = NULL, $absolute = FALSE, $fragment = NULL, $htmlize = TRUE, $frontend = FALSE, $forceBackend = FALSE)
userLoginFinalize($params = array())

(note a few of these are marked as only be called in certain contexts)


texts:
I am moving our memberships over to CiviCRM and we have a few thousand active members. I have implemented the Gift Aid extension and I would like to import Gift Aid records for all the existing customers. Can someone recommend a process for this or help me with api calls. I am happy to write php code but I can't identify which api calls are necessary.
Thanks for any help


texts: CiviCase - how to use for tracking grants we are applying for?

texts:
I've been asked to use CiviCase for tracking grants that my organisation is applying for but am unsure where to start.
I'm trying it out with sample data, so I've created a contact called "Dummy Grant Body". I have also created a 'Case type' called 'Grant application'. So, under the "Dummy Grant Body" contact, I want to add activities like "initial grant enquiry", "grant application", "grant awarded/denied" etc. I have also been asked to do this in a way that shows grant deadlines/our activities in a timeline. I really don't know where to start and wonder if I need the help of a developer or is this something people have managed to do by themselves? Thank you! Lara


texts: How do you approach "things that you would use Drupal views for" in WordPress?

texts:
Coming from a Drupal 7 background but wanting to do more work with WordPress, I am looking for ideas on how people approach "the things that you would normally use Drupal views for".

For any WordPressers that are unfamiliar with views, I'll try and explain it in once sentence:  it is a UI that allows you to run queries on your DB and format these nicely on the screen.

Tools with a GUI are nice, though not necessary - I'd be happy coding stuff. Just thinking that it would be great if there was a framework / set of libraries that I could use, to avoid too much wheel reinvention.

To give a bit of context: I'm creating the data entry part of a monitoring and evaluation system. We'll most likely use Caldera forms for the actual data entry but I want to create a customized dashboard that front end users of the site (without any other access to CiviCRM) that will give an overview to users of what they need to do and point them towards the forms that they need to fill in, etc. Happy to provide more details if that would be helpful.

Tips and tricks and examples are very welcome.


texts: How to view multiple relationships in contact editing mode?

texts: If a contact is an employee of multiple organizations at the same time, is there an option to Add New Relationship in the contact editing mode so that multiple relationships can be shown in the editing mode as well, and not only when looking at the Relationships Tab?


texts: civiCRM tab is not showing on top right corner of content?

texts:
I want a civiCRM tab on content of drupal.
 I install drupal 7 and civicrm 4.7.


texts: How can I fix "Fatal error: class Mail not found"?

texts:
I just migrated CiviCRM back to a development environment and I am getting:

  PHP Fatal error:  Class 'Mail' not found in ../web/sites/all/modules/civicrm/CRM/Core/Config.php on line 628

This is when I am running a test mailing. The rest of the site seems OK.

CiviCRM 4.6.3 and Drupal.


texts: How to report on repeating custom fields

texts: My client wants a report on a set of 10 repeating custom fields, each one of which has a date and one of a set of outcomes. e.g there is an 'Accommodation' custom field which has 2 fields - a date and a choice of various outcomes like 'homeless to hostel'. A  person can of course have more than one 'Accommodation' outcome (it's a repeating custom field). The problem is the limitation of this type of field.  Advanced search can find the data correctly (by using 'OR') but then they can't be exported as export doesn't support these fields.  So over in Reports - which can export them ('Export to CSV') - they can't be reported on because if I select all 10 sets of fields it uses 'AND' (see the SQL that's generated) which isn't correct. I can't think of a way round this using the UI. Can anyone suggest a solution, or is this simply something that can't be done at the moment?


texts: Can I send automatic, scheduled e-mails about expiring or just-expired memberships?

texts:
Using CiviCRM 4.6.11, Drupal 7. We want to create a workflow for membership renewals, part of which will include automatic, scheduled e-mails to members with expiring or just-expired memberships. I can create a Smart Group based on membership expiration date, then create a (say) daily,weekly scheduled job to send an e-mail to Smart Group members.

Is this the best or only way?

I'm also checking out the CiviRules extension compatability with 4.6.11 and 4.7 then checking out using CiviRules to create such a workflow.


texts:
Is it possible to create an ACL associated with a Smart Group?

I'm attempting to create a members directory that is only accessible to members. I can't seem to get it working. Here's what I've done so far:

I created a Smart Group called "Active Members" that includes any member of the club (status new, current or grace).
I made the Group “Members” as the parent group of the Smart Group "Active Members" created above. This had the effect of making the Smart Group disappear, and when you click on the list of members of “Members” it lists everyone that matched the search criteria for the Smart Group.
I created an ACL Role “Member”.
I assigned the Group “Members” to the Role “Member”
I created an ACL allowing anyone with the Role “Member” to access the Profile “Directory” to perform the operation “Search”

After doing all that, I figured I had it. This was going to work, and all would be right with the world. I was wrong.

The next thing I did was to create a new ACL allowing anyone with the role “Authenticated” to access the Profile “Directory” to perform the “Search” operation. Then it worked. However, if I understand this correctly, this means anyone that logs in, regardless of their membership status, will have access to the directory.

What troubles me is that the Member Role, which is associated with the “Members” group, which appears to contain all of the active members (by way of a child Smart Group) should have allowed it to work without having to widen the scope to “Authenticated”. I’m guessing that the child group doesn’t inherit the permissions of the parent group.

I don't want to manually add my members to the group members, I want that to be automatically governed by the status of their membership, hence the use of the Smart Group.


texts: Webform CiviCRM Paypal Button not Working

texts:
Using CiviCRM 4.4.4, Webform 7.x-4.11, Webform CiviCRM Integration 7.x-4.12, Paypal Website Payments Pro, Drupal 7.39

When I set up a payment through CiviCRM, credit card payment and Paypal payment work as expected. However, when I set up Payment through Webform CiviCRM integration, the credit card payment works as expected, but clicking on the Paypal button produces an error about email as shown in the attached screenshot. This happens with all my webform civicrm integrations. In other words when I use Webform CiviCRM integration, I have to give up paying with Paypal and since the Paypal button is automatically put on the screen the result is very unprofessional. The email that it shows which is supposed to be an error is my user name in Processor Details for Live Payments dialog.

Any help would be much appreciated, since I find the Webform CiviCRM integration module a great tool.

Paypal support hasn't been much help.

[Edit]
It turns out that when I am using CiviCRM Webform integration and select the Paypal button the word "express" briefly  appears in the credit card number field on the form. I think this is causing the problem because I don't see it when choosing Paypal from a standard CiviCRM payment page. I have tried different payment buttons from this page but the behavior stays the same.

Bill Dika


texts: Paypal IPN no longer updating contributions

texts:
Contributions that are made via Paypal are no longer being updated from pending to complete.
This happened suddenly on multiple sites.
Is anyone else experiencing this?
I cannot find any errors in any logs.
Any clue how to approach debugging this?

I am using CiviCRM 4.6.25 + Drupal 7.5x hosted by Pantheon


texts: It appears that, following the last upgrade, items which previously showed on an individuals activity log now don't show up.  A colleague sent out an email which was assigned to a case.  The email shows on the case but not in the colleagues activity list.  This list is used as a record that we can refer to as a quick check if something has been misassigned or that we did remember to do something.  What was the reason for this being changed and is it something we can choose to bring back?


texts: Getting ERROR: You need to send a valid key to execute this file when running Cron

texts:
When I run my cron job, wget -O - -q -t 1 domain.org/wp-content/plugins/civicrm/civicrm/bin/cron.php?name=XXX&pass=XXX&key=XXXXX

When I use this link in my browser it works just fine no issue, so the key is valid. I get the same error when running GET domain.org/wp-content/plugins/civicrm/civicrm/bin/cron.php?name=XXX&pass=XXX&key=XXXXX

I can't seem to use single quotes or it stops running altogether. A FQDN and I get a JSON error in the cron setup.


texts:
When I run the API command (via CiviCRM API Explorer) to list all the "Mailing Lists" i.e.

$result = civicrm_api3('Group', 'get', ['group_type' => "Mailing List"]);

I get the full list of mailing list groups. However if I run the with "LIKE" filtering option instead of "=", i.e:

$result = civicrm_api3('Group', 'get', ['group_type' => ['LIKE' => "Mailing List"],]);

I don't get any results and the console suggests that i hit a 403 error, which indicates this is a permission problem. I am running this as an administrator so I should have full access to  the system.

Any suggestions on how to address this issue are welcome.I am running CiviCRM 5.18.4 on Wordpress 5.2.4.


texts: preventing duplicate transactions in authorize.net using x_duplicate_window

texts:
I do not see this question on this site but if it has been answered please direct me to the answer. According to authorize.net you can help prevent duplicate transactions using x_duplicate_window.

Can anyone tell me what file I would put that in and what that would look like? i can't find anything in the civicrm documentation.

Thanks


texts: Contact Import German Date Format support?

texts:
CiviCRM 5.20.2/WP:

My system is using german locale. The contact import does not offer german date format "dd.mm.yyyy", even it is set for birth class in the date settings (dd.mm.yy).

How can I get german date format dd.mm.yyyy supported in the contact importer?

The contact import page only offers these date formats:

yyyy-mm-dd OR yyyymmdd
mm/dd/yy OR mm-dd-yy
mm/dd/yyyy OR mm-dd-yyyy
Month dd, yyyy
dd/mm/yy
dd/mm/yyyy


texts: Initialization Error when going to Civi CRM dashboard and adding pages/posts

texts:
I've had Civi CRM integrated in my website for a couple years no with no issues. However recently I've not been able to update any pages or posts or even go into the Civi CRM dashboard. All that shows is this error:

Initialization Error

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

    [code] => -26
    [message] => DB Error: insufficient permissions
    [mode] => 16
    [debug_info] =>  [nativecode=1044 ** Access denied for user 'rcboa171_civicrm'@'localhost' to database 'rcboa171_saveskahapark_civicrm']
    [type] => DB_Error
    [user_info] =>  [nativecode=1044 ** Access denied for user 'rcboa171_civicrm'@'localhost' to database 'rcboa171_saveskahapark_civicrm']
    [to_string] => [db_error: message="DB Error: insufficient permissions" code=-26 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info=" [nativecode=1044 ** Access denied for user 'rcboa171_civicrm'@'localhost' to database 'rcboa171_saveskahapark_civicrm']"]
)

Although my pages view fine from the front end and I can upload media.

Has anyone seen this before? Why would this be happening now? I haven't done any updates to my database or touched/changed anything in the last few months as it's pretty big site and I'm worried about updating the plugin or cms.

Any advice would be appreciated!


texts:
Quick question - is there anything in particular to take into consideration when upgrading Drupal, if it is used as a platform for CiviCRM?

Or can I just go ahead with Drupal update as if there was not CiviCRM installed?


texts: CiviMail error: "Sorry an error occurred and your information was not saved"

texts:
CiviCRM 5.6.1, WordPress 4.9.8, PHP 7.1.22, MySQL 5.7.23, WordFence 7.1.16

I just started getting this error when trying to create a mailing. It happens with Mosaico and traditional mailings. I previously saw this issue when first using the WordFence security plugin and found a discussion here suggesting to disable WordFence's XSS check, which I did with success until now. That was months ago. The option is still disabled and I even tried disabling WordFence entirely, but no luck. I haven't made any significant changes recently that I can think of. I had no problems with my last weekly mailing.

I also checked with my hosting provider to see if they had made any mod_security rules changes. They hadn't. I don't see anything interesting in the logs. Any ideas?


texts: Using data from CiviCRM to change filename

texts:
Here is what I need to do:

The user uploads an image, and I need to change the filename of the image to be firstname_lastname.filtype.

The first and lastname are stored within CiviCRM, but the upload is occuring in Drupal 7.

I'm thinking I need to write some PHP that pulls in the data from CiviCRM, and then sets it as the file name.

I'm still pretty new to Civi, can anyone give me some guidance on how I could go about doing this?  How can I pull in the data from CiviCRM?

Or, is there a way to use CiviCRM tokens inside of Drupal?


texts:
This error comes up when I try to edit or create a group:

  Sorry but we are not able to provide this at the moment. The field
  'custom_39' has no associated option list.

It produces a 732K long error log that I will not paste here. Any hints how I would debug this one.


texts: Updating fields in existing records from csv file

texts:
Hopefully the title is self explanitory. I have uploaded contact data but forgot to include one field. I now need to update the relevant field on all the records with with the data held on the csv. I did upload a custom unique key field for each record when originally uploaded the data.

Any help would be appreciated.

John


texts: I am successfully triggering on "Activity is added; Trigger for Activity Source" and updating the status of the activity. Now I need to assign the activity to the Source contact in the activity so they get the email notification with the activity details. Can't find an action to do that. I can send an email, but that lacks all the activity's details.


texts: "Recent Registration" view under CiviEvent - Customise columns

texts:
Hi to all (and thank you in advance),

I'm looking to add / remove a number of columns under the "Recent Registrations" view, in CiviEvent (image attached).

Any suggestions are welcome.

(running CiviCRM 5.13.4)

Kind regards
A.


texts: What is a line item? And what is a financial item and how are those two linked together?

texts:
I have created an extension to generate invoices (contributions) based on time spend on activities on a case.

For each activity a line item was created and added to the contribution.
Also the financial type had 21% percent of VAT configured.

In CiviCRM version 4.6 this extension works smoothly. However after upgrading to CiviCRM version 5.9.1 I cannnot edit contributions any more. It fails with the error Expected one FinancialItem but found 0.

After debugging I found out that the line items created with my extension does not have a related financial item (I did not even know they existed and/or where required).

So now I have changed my extension to create two financial items when one line item is added:

One financial item for the amount without VAT
And, one financial item for the VAT amount

Contributions created after this change could be edited. Hurray!

The questions

Now comes my questions:

What are financial items?
How do they differ from line items?
Where do I find documentation about line items and financial items?
What are financial transactions (trxn)? (See answer of Joe)?

Solution

To create all the underlying financial items etc.. One must use the Order API. The order API does create a contribution and line items.


texts:
I am unable to use smarty in CKeditor because it's transforming the ' into & #39;
I couldn't find anything useful when click the configure CKEditor Button in display preferences.


texts: How do I export all contacts to a .csv file?


texts: How to assign Drupal's system roles to Case Role in CiviCase

texts:
I would like to Use CiviCase to manage my cases.

I find that the Case Roles can be assigned to update the case. However, the Case Roles are not the Drupal's system user roles. (e.g. Administrator)

Does it has a solution to assign the system roles to Case Roles?

Thanks!


texts: failed to open stream after PHP upgrade to 7.3

texts:
Started getting this error on some Civi pages after upgrading PHP to 7.3 on  server running php-fpm and nginx.

Works fine after restarting php-fpm but need to restart every morning to get around with these issue. Has anyone come across this issue?

Warning: include(/var/sites/drupalsite/files/civicrm/templates_c/en_GB//%%30/307/307241E0%%Extensions.tpl.php): failed to open stream: No such file or directory in include() (line 1911 of /var/www/drupal759civi5192/sites/all/modules/civicrm/packages/Smarty/Smarty.class.php).


texts: Price Set Total Amount not displaying and JS errors

texts:
I have a Jooma 3.8.13 civicrm 5.5.1 install. I am using a price set on a membership contribution page, but the total amount is not displaying.
All works fine on test drive but on the live page no total amount is displayed at all, either initially or when any items from the price set are chosen.
Changing templates makes no difference, same issue on joomla default templates.
The price total calculation is working as when contribution is confirmed the next pages shows the correct amounts.
I know that the total amount is calculated using javascript. And I am seeing JS errors on browser console.
I did the usual - Directory path in CiviCRM/Resource URL/Cleanup CiviCRM Cache


texts: SSL enabled CiviCRM with forever loading dashlets?

texts:
We had a CiviCRM installation where the dashlets worked fine...until...we configured Apache to forward all requests over 443 (https).

It seems that now an AJAX callback is failing (going directly to the callback leads to a "Sorry but we are not able to provide this at the moment." error. The error details with debugging turned on state:

$Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => handle ) [code] => 0 [message] => [mode] => 16 [debug_info] => [type] => PEAR_Error [user_info] => [to_string] => [pear_error: message="" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info=""] )

Which is not terribly helpful for us who are not very familiar with the CiviCRM core.  Any ideas why this issue is occurring and/or what the fix might be?

Thanks!


texts: Display nth payment of a recurring series?

texts: Is there any way to display "nth Payment" of a recurring series? I am looking for a way to display with a contribution and/or line item result that this is the 3rd, 4th, 5th payment in the recurring series. I can work with either a civi report or a Drupal View.


texts: How can I select soft credit fields when exporting contributions?

texts:
We just upgraded to CiviCRM 4.6.6 (under Joomla! 3.4.4, PHP Version 5.4.44,  MySQL 5.6.23) from CiviCRM 4.5.2.

The fields Soft Credit For and Soft Credit Amount no longer appear in the drop-down list when I choose "Select fields to export" as an option for exporting contributions.  They also disappeared from my saved field mappings, and no longer appear in Search Builder.

Unless I select "Contributions Only" in my search, I see data in these fields.  The fields are exported if I use the "Export PRIMARY fields" option, but that means I have to export a lot of fields I don't want and can't export any custom fields in the same .csv file.

Is this an intentional omission or will these fields be added back to the field selection drop-down for contributions in a subsequent release?

Thanks.


texts: Can't edit source field in membership record after initial entry?

texts:
I just tried to edit the source field on a membership that was entered a few months ago, and I just get the spinning CiviCRM logo of uncertainty. I've also noticed the same thing happens when I try to edit a date field or any other info on the membership form. Is this by design?

Additional info by request:

Drupal 7.38 and CiviCRM 4.6.4
Host is LiquidWeb and we've been running multiple CiviCRM sites on a VPS for them for years.

Console shows the following errors:

  This site makes use of a SHA-1 Certificate; it's recommended you use
  certificates with signature algorithms that use hash functions
  stronger than SHA-1.[Learn More] __utm.gif
  &nbsp
  "The "fb-root" div has not
  been created, auto-creating"

I've turned on debugging and backtrace. I don't get anything for backtrace results when trying to edit the source field for the membership record - it's still spinning after ten minutes. I did get the following when I tried to merge two contacts, which is a separate question I posted here a week or so ago:

  backTrace

  0
  /home/repl00/public_html/sites/all/modules/civicrm/CRM/Core/Error.php(359):
  CRM_Core_Error::backtrace() 1
  /home/repl00/public_html/sites/all/modules/civicrm/CRM/Utils/Request.php(95):
  CRM_Core_Error::fatal("Could not find valid value for cid") 2
  /home/repl00/public_html/sites/all/modules/civicrm/CRM/Contact/Form/Merge.php(66):
  CRM_Utils_Request::retrieve("cid", "Positive",
  Object(CRM_Contact_Form_Merge), TRUE) 3
  /home/repl00/public_html/sites/all/modules/civicrm/CRM/Core/Form.php(455):
  CRM_Contact_Form_Merge->preProcess() 4
  /home/repl00/public_html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(94):
  CRM_Core_Form->buildForm() 5
  /home/repl00/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203):
  CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Contact_Form_Merge),
  "display") 6
  /home/repl00/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Merge),
  "display") 7
  /home/repl00/public_html/sites/all/modules/civicrm/CRM/Core/Controller.php(353):
  HTML_QuickForm_Page->handle("display") 8
  /home/repl00/public_html/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(115):
  CRM_Core_Controller->run() 9
  /home/repl00/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(286):
  CRM_Utils_Wrapper->run("CRM_Contact_Form_Merge", "Merge Contact",
  NULL) 10
  /home/repl00/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(86):
  CRM_Core_Invoke::runItem((Array:13)) 11
  /home/repl00/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(54):
  CRM_Core_Invoke::_invoke((Array:3)) 12
  /home/repl00/public_html/sites/all/modules/civicrm/drupal/civicrm.module(489):
  CRM_Core_Invoke::invoke((Array:3)) 13 internal function:
  civicrm_invoke("contact", "merge") 14
  /home/repl00/public_html/includes/menu.inc(519):
  call_user_func_array("civicrm_invoke", (Array:2)) 15
  /home/repl00/public_html/index.php(21):
  menu_execute_active_handler() 16 {main}


texts:
Please could someone tell me what is wrong with the following
Dear contact.nickname Thank you.
I know that brackets need to be used.


texts:
After executing a search that returns more than one page of data, I get an error when I click on "next". "Unable to reach the server. Please refresh this page in your browser and try again."

The Apache2 error log shows:

apache2/error.log shows [Mon Jul 08 12:58:29.922448 2019] [php7:warn] [pid 4022] [client 96.9.90.28:57008] PHP Warning:  fopen(/var/www/vietfeir.com/public_html/wp-content/uploads/civicrm/ConfigAndLog/CiviCRM.4a976861044aadd15e2c85b9.log): failed to open stream: Permission denied in /var/www/vietfeir.com/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/log/Log/file.php on line 216, referer: https://ccrmdemo.vietfeir.com/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcontact%2Fsearch&_qf_Basic_display=true&qfKey=082061e63d30f54afa566bb

All of my files have permissions set to 644 and the directories are 755.

All files are owned by www-data:www-data

This is intermittent. I sometimes do not get the error.


texts: Password field not displayed in contribution page

texts: I have created a contribution page in civicrm and included profile with account creation required option enabled. But only Username field is displayed but not password and confirm password field.I'm using drupal 7 with civicrm. please suggest


texts: Changing the price of a Membership in a Price Set does not transfer to a Webform

texts:
I am using CiviCRM 5.13.4 and Drupal Webform 7.x-4.20.

I am using the Webform to collect payments for Membership.  The price of the available Membership Types is set up using a Price Set, which is called up by a Contribution Page, which itself is called up by the Webform.

When I change the price in the Price Set the amount charged by the Webform does not alter.  If I open the Contribution Page directly in CiviCRM (as a test) it shows the new price, but the Webform still shows the old one.

I wish to retain the price setting in a single place, to avoid possible operational problems and inconsistencies, and the Price Set seems to logical way to do this.  It there some other action needed to make it take effect, or is this a bug?

With thanks.


texts:
I'm trying to install an old CiviCRM version on Drupal 6, the purpose is to migrate an old database data to the latest CiviCRM version, but I'm getting this error when I try to install CiviCRM in a clean Drupal install:

Unable to create InnoDB tables. MySQL InnoDB support is required for CiviCRM but is either not available or not enabled in this MySQL database server.

Everything else seems to be ok, I'm gettinig this error in a windows environment. First I tried with wamp, now I'm trying with Laragon. I tried also with vagrant and homestead which is a linux environment I think, same results.

I tried setting innoDB as the default engine and a lot stuff that is there on internet, but anything seems to work. Any idea?

This is what "SHOW ENGINES" return:


texts:
We've updated CiviCRM to 4.6.3. Since then, CiviMail has stopped working. When we log in, the following warning pops up:

"Warning: Outbound email is disabled in system settings. Proper settings should be enabled on production servers."

We set it up correctly in Email settings both mail() and SMTP, and in both cases the test mail is sent OK according to the popup window (view attached file). But it does not get delivered so we believe it isn´t really sent.

We´ve checked if we've been blacklisted or anything but we haven't.

Afterwards, we've tried writting random letters and numbers in SMTP server and SMTP user, and the popup stills says that the mail has been sent.

We would appreciate any help to find a solution.

Thank you!!


texts: Are Scheduled Reminders broken regarding event participant status?

texts:
Using Civi 4.6.18 we have a scheduled reminder set up that should be sending an email to people who have registered for a particular event, opted to pay later, but who have yet to make the payment. A fairly common scenario I'd guess.

I have the checkbox ticked to record an activity when the reminder gets sent.

Using Advanced Search I can see that at this point I have three people that meet the criteria to receive the reminder.

In this case I have manually added two additional contacts who should also receive the reminder.

Cron fires, scheduled job runs, nothing gets recorded in the CiviCRM log or the PHP error log, the manually added additional contacts have an activity record suggesting that an email was sent, but the three who met the criteria for the reminder have no activity recorded.

What it looks like from this is that the reminder is working in so far as the manually added contacts are being sent the email, but the reminder is not succeeding in finding the three criteria driven contacts.

Anyone else seeing this type of issue? I can see that are a good number of issues in relation to Scheduled Reminders not doing what they are supposed to, but I couldn't spot anything in relation particularly to event participation status.


texts: Making the Event Registration icon larger

texts: How do I make registration icon on an event page larger? Is seems to be a bit small and is it possible to move it around?


texts: Data Pull- Information appears in Preview, but not when exported as csv

texts:
I am trying to pull csv (excel) data from the Case Reports
» CNLP Data
When I look at it in preview, I see 680 records. However, when I export it to the csv, it generates a blank document (outside of the column headings)


texts: Event Email receipt doesn't have the profile information

texts:
I have an event which accepts multiple participants registration, I have used a profile and another different profile for the additional participants and I have checked the "Same Email address" checkbox.

The issue is that on registering multiple participants only the first participant's profile field's information is present in the Email receipt and other participant's information is not present. Total Amount is also empty.

This issue is happening on using "PayPal - Website Payments Standard" processor but all the participant's information is coming correctly upon using the "Pay Later" option.
How can I fix this issue?


texts: Cannot Require Once When Loading CiviCRM After Drupal Upgrade

texts:
I am trying to upgrade to the newest security release of Drupal 8 (8.9.14).  After completing the update (Drupal is bootstrapping because the login page works) but CiviCRM stops being able to require specific files.  The full error is:
PHP Fatal error:  require_once(): Failed opening required 'DB/DataObject.php' (include_path='.:/var/www/site_name/vendor/civicrm/civicrm-core:/var/www/site_name/vendor/civicrm/civicrm-core/packages:.:/var/www/site_name/vendor/civicrm/civicrm-core/:/var/www/site_name/vendor/civicrm/civicrm-core//packages:/var/www/site_name/vendor/civicrm/civicrm-core/vendor/tecnickcom:/var/www/site_name/vendor/pear/archive_tar:/var/www/site_name/vendor/pear/auth_sasl:/var/www/site_name/vendor/pear/console_getopt:/var/www/site_name/vendor/pear/db:/var/www/site_name/vendor/pear/log:/var/www/site_name/vendor/pear/mail:/var/www/site_name/vendor/pear/mail_mime:/var/www/site_name/vendor/pear/net_smtp:/var/www/site_name/vendor/pear/net_socket:/var/www/site_name/vendor/pear/pear-core-minimal/src:/var/www/site_name/vendor/pear/pear_exception:/var/www/site_name/vendor/pear/validate_finance_creditcard:.:/usr/share/pear:/usr/share/php') in /var/www/site_name/vendor/civicrm/civicrm-core/CRM/Core/DAO.php on line 26, referer: https://site.org/user/login

I tried adding the full relative path to the file (../../../civicrm-packages/DB/DataObject.php) and this does not stop the problem.
My CiviCRM root is,
$civicrm_paths['civicrm.root']['path'] = '/var/www/site_folder/vendor/civicrm/';

The variable is
$civicrm_root = '/var/www/site_folder/vendor/civicrm/civicrm-core/';

I tried changing the path for the array in ['civicrm.root']['path'] but this did not do anything.
I tried upgrading CiviCRM too. That did not work either.
I have figured out that the issue is not related to the Drupal upgrade itself but rather to the packages being upgraded with Drupal.

symfony/debug (v4.4.20 => v4.4.22):
symfony/var-dumper (v4.4.21 => v4.4.22):
guzzlehttp/psr7 (1.8.1 => 1.8.2)
doctrine/cache (1.10.2 => 1.11.0)
doctrine/inflector (1.4.3 => 1.4.4)
laminas/laminas-feed (2.14.0 => 2.14.1)

I have not narrowed down which library is the issue.
I appreciate any help figuring this out.
Thanks,
Josh


texts: Getting counts of donors grouped into categories by giving amount

texts:
Let's say I have these groups of donors:

Small donor, gave < $100 in the past year.
Medium donor, gave $100-500 in the past year.
Major donor, gave > $500 in the past year.

What's the best way to get a count of all these in one place?  My best thought is to create smart groups - then I'd need a report of "Counts by Group".  Does such a thing exist?  What if I use aggregation with a Drupal View?


texts:
I'm looking for a simple solution to allow staff to search for a case by Case Role in addition to client name.

currently the search cases screen  (civicrm/case/search?reset=1)  has only the client name / email or casetype , case status, start/end date.

Allowing to search for contact with a role on the case would have a number of uses.  e.g. find all cases supervised by a manager or referred by an external contact (where case supervisor and referrer are case roles)

Any thoughts on the best way to go about this.

thnx

civicrm 4.6.8
drupal 7.39


texts: Webform CiviCRM - Update Recurring Payment Profile

texts:
Let's say in 2018 someone uses the webform and creates a membership and a recurring payment - ongoing - for $5 at a certain membership level.

Let's say in 2019, they want to upgrade their membership level. They login and use the same form to choose the next level up and want to pay $10 ongoing. Great. They submit the form.

What happens to the first profile? Does the recurring profile get upgraded or disabled?


texts: Contribution receipt has "display in honor roll" when personal campaign pages is off

texts:
After upgrading the CiviCRM to version 4.7.15 on Drupal Commons 7.50, I noticed that CiviContribute receipts are coming in with a field "Personal Campaign Page: Display in Honor Roll", however, personal campaign pages are turned off. Is this a bug or do I need to adjust my settings somewhere? See screenshots below.

From Receipt

From CiviContribute Page settings

Thanks!


texts: Search custom fields with multiple records

texts:
I'm not really sure how to describe this but  hopefully I can describe it clear enough.

I created a custom field set that holds borrowing information for items (like tools, equipment, etc.). It has 3 fields (actually more, but here 3 is enough to describe the problem): Item name, Date borrowed, Date returned.

A contact can borrow multiple items at once.

Is there a way to search for contacts who have not borrowed any item in the last 6 months?

Thank you.


texts: How to trouble-shoot 'critical error' while merging duplicates?

texts:
Using civicrm-5.21.2-wordpress.zip, (and also 5.20), I get a 'crash' ('There has been a critical error on your website. Please check your site admin email inbox for instructions.') for any attempt to merge contacts.

None of the WordPress trouble-shooting info has helped. I don't get any CiviCRM trace-back or debugging data. I don't see anything in the Apache error.log .

Any other suggestions for trouble-shooting this?


texts: Why are my QuickForm checkboxes always ticked, in postProcess()?

texts:
I'm trying to build a form using QuickForm checkboxes. Here's what should happen:

The form displays a bunch of checkboxes. These are ticked or unticked according to a load of API calls in buildQuickForm(). If ticked, this is set using setChecked->true.
The user then ticks or unticks appropriately, and postProcess() handles the changes.

Except, the form data received by postProcess() is wrong: if a checkbox is set as ticked using setChecked->true, it always comes through as ticked, even if the user unticked it.

I assume I'm not understanding Civi's QuickForm process properly. Could setChecked->true be kicking in after the form is submitted? During validation, or something?

Any advice appreciated...

Andrew


texts: Phonenumber error Joomla 3.4.8 civicrm 4.6.11

texts:
I got an error in Joomla 3.4.8 Civicrm 4.6.11. When I try to save contacts with a phone number it says:

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

Without phone number working. When I write "what so ever" in phonenumber it be error. Trying all kind of phonenumbers us and eu number only numbers and +46 in still results in this error.

Separately, on the same instance, when creating a contact from start it I get the following error:

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

Although this error does not appear when I save it without a phonenumber.

Is there an easy fix to this?

Kind Regards

Thomas Rosenhoff


texts: Where do I create an issue on lab.civicrm?

texts:
I found a small bug in this file:

  /sites/all/modules/civicrm/templates/CRM/Contribute/Form/Contribution/Confirm.tpl

Where do I submit an issue on lab?


texts: Update user Tags direct from civiMail link

texts:
We'd like to let existing civiCRM Contacts tell us what they are interested in by following a link in a civiMail email, which takes them to a form with a few checkboxes. They check a few boxes, then press enter, which automatically updates their profile without making them login.

We are thinking we may need to use a checksum Token that links to a Petition or a Survey.

I thought I'd ask what the best practice is on this.

Thanks!


texts: Why am I getting "Column not found: 1054 Unknown column 'civicrm_activity.source_contact_id' in 'field list'" on Activity View after upgrade to 4.6.7?

texts:
For the past few upgrades I've needed to apply a fix for activity views detailed here:
https://forum.civicrm.org/index.php?topic=33513.0

Today I upgraded to 4.6.7 and got the same error, but when I make the changes in the fix mentioned above, I still get the error.

Does anyone have any insight about this?


texts:
One of the organisations I'm supporting has an issue with the email address fields...

They have a record for a child, and another for the child's parent(s). When it comes to sending emails they will 99% of the time be wanting to send emails to the parent, but aren't keen on having to click he relationship field to open parents record in order to get the email address.

Is there a way to share this, similar to that for postal address, or any other clever ideas to help with this?


texts: CIVICRM with MYSQL encrypted on ecryptfs

texts: I managed to have CIVICRM (5.15.2 on WP 5.0.7 on Ubuntu 18) running on MySQL (5.7.28) from an encrypted mount via ecryptfs.  Currently only the mysql files are in the encrypted mount and it's running a few days now and all seems good.  I would like to check whether there are experiences from similar setup and whether there would be issues to anticipate ?  Thanks.


texts: CiviEvent Scheduled Reminders and manual recipients

texts:
I've setup a very simple scheduled email reminder for an event that sends to registered participants as well as the site admin, whom I've added as a manual recipient, 2 hours before the event start date. The reminder sends to the registered participants as it should, but it sends to the site admin at the very next cron cycle, even if it's days or weeks before the event. The admin then never gets the reminder at the 2 hour before event mark.

Another thing I've noticed is that the tokens in the email work for the registered participants, but not for the manually added recipient. {event.title} always resolves as the very first event I ever created in the manual recipient email.

Has anyone else had this problem? I'm running CiviCRM 5.8.2 on Drupal.


texts: Best Practise for recording thank you letter.I don't have email addresses

texts: On contribution page, what is the best practice for recording "thank you" letters that have been sent, if they are physical letters (snail mail), right now it only shows thank you letters if they are sent via email and if the person has an email address


texts: Weekly Digest Email to Group (Mailing List)

texts: What route would one take to creating an automated weekly digest for an existing mailing list group? Can this be done with a scheduled reminder along with some code in a template file somewhere? I am running Drupal and am wondering if maybe a scheduled reminder email that has some code to grab the result from a view to plop into the email body might work?


texts: How can I make a civi event registration form that collects the individual's information as well as the organization to which they are affiliated?

texts: How can I make a Civi event registration form that collects the individual's information as well as the organization to which they are affiliated? Would I have to use a webform? We're on 4.6.8, Drupal.


texts:
I want to configure the font drop-down menu of the CKEditor and add additional fonts there.

The Fonts are locally available, and shall be usable for PDFLetters etc. Has anyone made any Progress with that? It seems possible to add fonts to CKEditor..?

I found this thread, but whenever I edit the GUI Preferences, the file crm-ckeditor-config.js hasn't been generated. Instead only /civicrm/persist/crm-ckeditor-default.js is available.


texts: Strange error when updating 5.23.0 Joomla

texts:
When i try to update my Joomla version (Windows) to 5.23.0 I get the screen to run the database upgrade utility after the question are you ready to upgrade (Yes) I get the screen with the progress-bar left at the screen but it does nothing.
When I look at the console of the screen I see warnings as:
Laden voor het  met bron ‘http://localhost/Joomla/Joomla/administrator/components/com_civicrm/civicrm/bower_components/jquery/dist/jquery.min.js’ is mislukt.
(and 14 others). The URL must be with only once "/Joomla". I didn't change or save the civicrm.settings.php. But there is no double /Joomla.
What is the reason that the URL is wrong? I have tried version 5.23.1 with the same result.


texts:
A contact has a custom file field named : Passport copy
Context : I add a picture (jpg file) in this file "passport copy" .
And I save the contact. Then when I click on the file, a pop up is opened with the passport copy This is good.
But if the jpg is a wide file, the pop up is all over the page and I can't resize it. The picture is larger than my screen...
So I would like to specify a size for this pop up like 250px/250px. But I don't know how

Is it clearer ?
Regards,
hashkey


texts: how can I set the default value for the field "priority" in the actions form?

texts: I want to force a default value for the field priority in the actions form, so that users don't have to pick the right value if the default value is OK.


texts:
We are a federated political organisation migrating to CiviCRM 4.6. I have integrated  CiviCRM with Drupal views and civicrm_entity so we can create customised search pages for local organisers.

I'm finding civicrm_entity and various fuzion extensions to be excellent help, but setting up permissions across a large grassroots organisation is still complex. We are currently managing this with a combo of permissioned relationships and auto-generated smart groups.

Question:

Currently, to view entity via civicrm_entity (at e.g. civicrm-contact/[id]), a user seems to require the 'view all contacts' Drupal permission.

Is there an easy(ish) way to make civicrm_entity respect CiviCRM ACLs? Or at least check that the logged in user has permissioned relationship with that contact?

thanks,
L


texts: Change multi select custom field to single select?

texts:
We need to convert a multi select box to single select, and the option for doing this in the Change Field Form window looks scary.

  Warning: This functionality is currently in beta stage. Consider backing up your database before using it. Click "Cancel" to return to the "edit custom field" form without making changes.

The option most suitable appears to be "Radio (not safe)". What does "not safe" mean? This field is a crucial element of our membership system and can't be at risk.


texts: Can custom Tokens for pledges be created?

texts: I need to include the amount pledged and the amount they need to pay (which are different values) within an email I'm sending from CiviMail to let our pledgers know when/how to pay and how much. This data is available under each contact, but I can't see anyway to add a new token so I can insert the necessary merge fields into my email and they aren't currently showing in the drop down list. Is this possible?


texts: Specified return fields in contact get do not get returned

texts:
If I do a api3 contact 'get' with no return fields specified, it obvs returns all the fields including address fields.
What I want to do is only retrieve certain fields for my needs, just to reduce overhead.
If  I specify to return only 'state_province_name' or 'geofield1', they are not returned.
Is there a way to do this in a single call?


texts: How can I track donor movement on CiviCRM?

texts:
Our organization is using CiviCRM on Drupal and I'm looking for a way to create, track, and report on solicitation plans -- essentially, having a report that forecasts income from a variety of channels (individuals, events, etc) It would track details such as channel (ie individual), ask amount, likelihood, etc. Ideally, this report could be integrated with a contribution report to compare forecast and actual income.

I think a modified CiviCase might be able to handle the solicitation plans, with customized reports, but I'm hoping someone might have more concrete solutions or know of an existing module that can handle both forecasting and contribution reporting.


texts: What's the correct webhook for Stripe 5.2 extension?

texts:
I can't find any documentation for the latest Stripe 5.2 extension and I've setup the webhook as 'https://www.example.com/civicrm/payment/ipn/1' - I have setup Stripe as the only payment processor hence the '1' at the end.  Is this correct?
Using Civi 5.7.3 and Drupl 7.61


texts: Is there a setting to prevent Paypal Express overwriting contact details with provided Paypal billing details?

texts:
We are using CiviCRM 4.7.22/Drupal 7.56 and are increasingly encountering a scenario where Civi contacts are sharing their log in details with admin/PA staff to make payment via PayPal with a credit card on their behalf. The problem we encounter is when the admin/PA checkout with Paypal they enter their own name, email address and billing info, not the Civi contact. When the contribution is made this then  overwrites the Civi contact. This is particularly problematic for events as we use Civi data to make badges and email joining instructions.

Is this the designed behavior or is there a setting either in Civi or Paypal I'm missing?


texts: Civicrm 4.6.5. When trying to create mailing labels, it works fine for primary address location, however when trying to use other location types or a custom location type we have created it just prints out a blank pdf page. There are several addresses that should be added (contacts have the fields populated). Any help in getting this working would be greately appreciated


texts: Joomla installation error: Please enter a package folder. Unable to find install package

texts:
When I tried installing by uploading the package file, nothing happened. Then I tried exactly as the installation guide says for Joomla and I get this error:
Please enter a package folder.
Unable to find install package

This is a new Joomla installation 3.8.5, I am trying to install CiviCRM 4.7.31. I have PHP 5.6. I'm hosted on a shared server so not sure how to check the PHP extensions and configuration or the MySQL version with my cPanel.

I have never used CiviCRM before but I have been using Joomla for years and never got that error with any installation packages.

I would love some help and am looking forward to your support.


texts: Mapping of CiviCRM's Contact card fields to Drupal user entity's

texts:
Essentially, we are having an integration problem where one component we are using is expecting to find or use default user entity fields, but these fields are not mapped into CiviCRM's user Contact card.

To be precise, we are using Drupal's LDAP module to exchange data with legacy systems and provide SSO auth. The LDAP module allows us to specify which Drupal user entity fields are mapped into the LDAP record using Drupal tokens, for example [field.field_lname], [field.field_fname], etc. However, those entity fields are not mapped into CiviCRM. As a result, we can't query their data using Civi, or expose it to users to edit using Civi's profile forms.

How can we manage mappings between CiviCRM's Contact record fields and Drupal's entity API?


texts: Call to undefined function mysql_error() when install extension CiviHR for CiviCRM

texts:
I'm using Joomla 3.7.5 and CiviCRM version 4.7.12.
I access to "CiviCRM » Administer » System settings » Extensions » Add new" to install CiviHR extension but CiviHR not in the native list. So I do it manually, I downloaded CiviHR and upload to civicrm directory. When I install it, I got the error.
The first, I click "install"

And I got the error

Do you have any suggest for me to fix this? Thanks you very much.


texts: Silent error when accessing php API has not logged in user

texts:
I'm having a strange problem using the CRM API thru PhP (i.e. not REST or AJAX). I'm trying to build a donations counter which tracks the total amount of contributions made under a specific contribution source. Everything works when I'm logged in. But when I'm not, I get a silent php error and my theme breaks. The only thing I can guess is that it might be related to user permissions. So I gave not logged in users the ability to Access CiviCRM and View Contributions. I can confirm this works using the dashboard. But I still cant get the API calls to work without breaking the site.

Things I have tried:

Adding 'check_permissions' => false to the call
Surrounding the calls in a try / catch block
Switching user context in d7 to the root user and then back again.

Maybe it's not even a permissions problem after all..?

CiviCRM version is 4.7 with Drupal 7.


texts:
I have a setup with CiviCRM and Amazon SES, everything is working fine.

A Problem arises with the bounce handling. Amazon can either do that internally via Amazon SNS, or just forward the mails to your domain for common handling (Catchall or VERP).

I wanted to use the SNS mechanism, and amazon sends the mail correctly to the specified address, but the email isn't a typical bounce mail, but instead the original headers are JSON encoded like this:

{   "notificationType": "Bounce",   "bounce": {
    "bounceType": "Permanent",
    "bounceSubType": "General",
    "bouncedRecipients": [{
      "emailAddress": "bounce@simulator.amazonses.com",
      "action": "failed",
      "status": "5.1.1",
      "diagnosticCode": "smtp; 550 5.1.1 user unknown"
    }],
    "timestamp": "2017-11-20T11:05:06.477Z",
    "feedbackId": "0102015fd91a6479-ae22395c-1f7d-4423-a9e5-e0715bffc731-000000",
    "remoteMtaIp": "1.2.3.4",
    "reportingMTA": "dsn; a4-8.smtp-out.eu-west-1.amazonses.com"   },   "mail": {
    "timestamp": "2017-11-20T11:05:04.000Z",
    "source": "bounce.crm+b.83.52.2a7c92a4101dd5fd@example.com",
    "sourceArn": "ARN_INTERNAL:identity/example.com",
    "sourceIp": "1.2.3.4",
    "sendingAccountId": "__ID__",
    "messageId": "0102015fd91a5ca3-93c245fe-e333-46ae-8fed-96160d20cfab-000000",
    "destination": ["bounce@simulator.amazonses.com"],
    "headersTruncated": false,
    "headers": [{
      "name": "Received",
      "value": "from crm.example.com (mx02.example.com [1.2.3.4]) by email-smtp.amazonaws.com with SMTP (SimpleEmailService-2638500019) id MbY8b9mKuaex7LdPcwd8 for bounce@simulator.amazonses.com; Mon, 20 Nov 2017 11:05:04 +0000 (UTC)"
    }, {
      "name": "MIME-Version",
      "value": "1.0"
    }, {
      "name": "Content-Type",
      "value": "multipart/alternative; boundary=\"=_99c8dccfc484a99b0f6101141a34c4ae\""
    }, {
      "name": "Reply-To",
      "value": "\"Example Company\" <info@example.com>"
    }, {
      "name": "Return-Path",
      "value": "bounce.crm+b.83.52.2a7c92a4101dd5fd@example.com"
    }, {
      "name": "From",
      "value": "\"Example Company\" <info@example.com>"
    }, {
      "name": "Subject",
      "value": "Bounce Test – Monday 4"
    }, {
      "name": "List-Unsubscribe",
      "value": "<mailto:bounce.crm+u.83.52.2a7c92a4101dd5fd@example.com>"
    }, {
      "name": "job_id",
      "value": "83"
    }, {
      "name": "To",
      "value": "Tom TestUser <bounce@simulator.amazonses.com>"
    }, {
      "name": "Precedence",
      "value": "bulk"
    }, {
      "name": "X-CiviMail-Bounce",
      "value": "bounce.crm+b.83.52.2a7c92a4101dd5fd@example.com"
    }, {
      "name": "Date",
      "value": "Mon, 20 Nov 2017 12:05:04 +0100"
    }],
    "commonHeaders": {
      "returnPath": "bounce.crm+b.83.52.2a7c92a4101dd5fd@example.com",
      "from": ["Example Company <info@example.com>"],
      "replyTo": ["Example Company <info@example.com>"],
      "date": "Mon, 20 Nov 2017 12:05:04 +0100",
      "to": ["Tom TestUser <bounce@simulator.amazonses.com>"],
      "subject": "Bounce Test – Monday 4"
    }   } }

Civi cannot handle this type of message (to the best of my knowledge) and it is then moved to the ignored folder.
I'm pretty sure I am not the first one to have this problem, but I couldn't find any solutions to this. Maybe someone has written a parser for those type of messages already?

Help/Suggestions are welcome!


texts: How do I add/change columns in CiviReports?

texts: How can I add more fields in columns Tab in Constituent Summary or how can I change the Fields names in columns Tab in Constituent Summary? Also every time that I export my report as a CSV file I get the columns in specific order how can I change the order to the one that I want? Thanks


texts:
I'm using Stripe Payment Processor 6.3.2, MJWShared 0.6 on Civicrm 5.23.2 with Wordpress Multisite.

I've used the Wizard to instal webhooks in Stripe.

I'm now getting a warning in CiviCRM System Status "Webhook API version is set to 2020-03-02 but CiviCRM requires 2019-12-03. To correct this please delete the webhook at Stripe and then revisit this page which will recreate it correctly. Webhook path is: https://xxx.xxxx,com/?page=CiviCRM&q=civicrm/payment/ipn/2."

If I delete the webhooks on the Stripe Dashboard, the Wizard can again be used to instal webhooks, but the same warning message comes up.

Any ideas on how I proceed?  Or indeed where this process is documented?

David Brown


texts:
On the 4.7 Drupal 7 Demo site I changed the middle letter of contact Kathleen Adams and it gets logged and becomes visible in the log tab. Then I make a change in the relationship tab, adding a Case Coordinator relationship to Megan Roberts and removing that relationship again. Both these changes to the contact are not logged.

Is there a setting that it will also log these changes? When there isn't such setting available, could this be considered a bug and reported as such?

The same questions for version 4.6.x because that is the LTS version I am using at the moment.


texts:
I am currently using a Drupal 7.35 CiviCRM 4.4.14 build for a new website. I have all of contacts set up, with their relationships and memberships, and all the rules in place so that as it changes in Civi it pushed the changes on Drupal.

What I do not understand however, is how to migrate the 1000 or so contacts in Civi to create their log-ins in Drupal.

Some webpages suggest exporting to CSV and importing from CSV; and I have not even started looking into Drush.... surely there must be an easier way?


texts: WYSIWYG editor not appearing in CiviCRM and Drupal

texts:
I am trying to edit a "Message Template" in CiviCRM 4.7.30 and Drupal 7.57, but the "HTML Format" is not showing a WYSIWYG editor, just a plain text editor.

I have gone to CiviCRM -> Administer -> Customise Data and Screens -> Display Preferences.  The "WYSIWYG Editor" setting is "CKEditor" (this is the only option).

In Drupal, I have the WYSIWYG module installed.

Any thoughts?

Thanks,

Carl


texts:
As per the documentation (https://book.civicrm.org/user/current/membership/defining-memberships/) :

"If you wish to enable online sign ups or renewals, the CiviCRM data model requires that a contact can only have one active membership with a single organisation at any given time. "

I currently have 2 CiviCRMs/Drupal : one in production, and one for tests (both in 7.44/4.7.6), and I use Webform to create the memberships.

The test Civi does not actually create duplicate memberships : each new membership replaces the previous one : which is in accordance, and correct.

But the production CiviCRM creates duplicate memberships :

How can this happen ?
Is this connected with "If you wish to enable online sign ups or renewals" ?
How can I change that ?


texts: Create forwarding email address for mailing to members of a group

texts:
Is it possible to create a custom email address which forwards to all members of the organisation, or all members of a group? Perhaps via Inbound Mail Handling? edit - perhaps Civi or Drupal Rules?

This would enable a non-tech savvy Secretary to email all members (or another group) from their own email client via the custom email address rather than via CiviMail interface, and each email only go to current members of the organisation.


texts: failed to open stream error while installing

texts:
I am trying to install CiviCRM as a wordpress plugin.  I am using the GoDaddy wordpress dashboard to do this.  I am getting this error (which is just the first error in a list of several that are appearing):

    Warning: require(/home/NAME/public_html/wordpress.SITE.com/wp-content/plugins/civicrm/civicrm/vendor/composer/../symfony/polyfill-ctype/bootstrap.php): failed to open stream:

No such file or directory in /home/NAME/public_html/wordpress.SITE.com/wp-content/plugins/civicrm/civicrm/vendor/composer/autoload_real.php on line 70

I am looking at the code in file "autoload_real.php"  and line 70 reads:

require $file;

nowhere else in this file is $file defined.  the directory "/home/NAME/public_html/wordpress.SITE.com/wp-content/plugins/civicrm/civicrm/vendor/composer/" DOES exist, but the rest of the line "../symfony/polyfill-ctype/bootstrap.php" does not.  there are also 3 other errors in eclipse that are indicated and all of those errors are "syntax error: unexpected 'Autoload()'.  The 3 different lines of code that throw this error are:

1) self::$loader = $loader = new \Composer\Autoload\ClassLoader();
2) call_user_func(\Composer\Autoload\ComposerStaticInitdb2000479593e65ef23454e56d74a73f::getInitializer($loader));
3) $includeFiles = Composer\Autoload\ComposerStaticInitdb2000479593e65ef23454e56d74a73f::$files;

I'm not really sure what the issue is, as I'm not experienced enough.  Any help from the experts here?  GoDaddy claims the problem is with the plugin file's coding.


texts: CiviCRM Membership data to external Database

texts:
I'm new to Joomla, CiviCRM and PHP, but looking to help with a small project.  I'm looking to grab the members data from CiviCRM and transfer (or update if users already exist) into a different database of an application (that is stand alone code/not in joomla) for users that are members of both. After the migration of existing users is done, then going forward this process would be done when a new user registers as a member in the CiviCRM. A couple questions:

Should I write PHP/SQL to go directly against the CiviCRM Contact table or utilize the CiviCRM API?
Where do I write the actual code to connect to the CiviCRM database, write SQL to grab data, etc.? Is it a Joomla extension, a function when the user clicks Submit in the member registration form in CiviCRM? I'm still trying to figure out the Joomla platform and how coding works in it.
Anything else I should consider?

Thanks so much!


texts: Do any token extensions provide a token for "age" rather than just DOB?

texts:
Age is displayed on a contact record but only DOB is a token available in message templates.

Are there any extensions that make age available for use? I've not been able to locate anything.


texts:
I've stumbled across the options in  Administer - System Settings - Option Groups and I read somewhere that you can create new ones.. so I tried using the syntax of existing options:

eg Previous 2 calendar years = "previous_2.year"
so I tried  Previous 3 calendar years = "previous_3.year"

but that didnt work- just returned empty results (tried lots of others and they all did the same)

any clues please?


texts: I am completely new to Civicrm and successfully created an extension that modify and existing page{Contact Page} but I am required to create a extension that shows a new CIVICRM Contact Tab that show list of Personal Campaign Pages created by a contact.I have not clue how to start creating this..Any tip on how to do this will be appreciated


texts: hook_civicrm_post - on creating event cannot update the record in `civicrm_event` table

texts: I have a custom field in civicrm_event table which I want to update on creating event. However the hook_civicrm_post on creating event cannot update the record in civicrm_event table due to database transaction lock still in place at that point. Is this possible to be achieved with another database transaction? Can someone give me an example.


texts: Cannot create Survey when Events have 'is required' custom data: is this the fix?

texts:
This is an issue with 4.7.6 and its reproducible on the Drupal 7 demo site.

Create a custom field called 'X' for Events that is required
Attempt to create a Survey via civicrm/survey/add (enter values and press 'Continue')

Step 2 fails with the error 'X is a required field'

The issue can be fixed by changing line 83 of CRM/Campaign/Form/Survey.php ...

$this->set('type', 'Event');

to

$this->set('type', 'Survey');

This change fixes the problem, but I'm unsure whether there is a deeper issue.

The form that is used by civicrm/survey/add is CRM/Campaign/Form/Survey/Main.php. The parent form is CRM/Campaign/Form/Survey.php. The possibly deeper issue is that the preProcess function of both forms (Main.php and Survey.php) deals with Custom Data.

I feel the child form (Main.php) should leave it to its parent to deal with Custom Data. But I think someone from the Core team might need to look at that.


texts:
Our event applications use profiles with a lot of fields.  Is there any way within the core of Civi to break up our application page into multiple pages so users don't see one huge form page with so many fields?  Like could we break things up by sets of fields or even by profile?

Or is this the time to start looking into Webform and it's CiviCRM integration module?


texts: Search in Manage Groups renders "contacts" link as editable under "visibility column"

texts:
CiviCRM 4.7.17. It should be noted that we upgraded from the latest LTS about 2 weeks ago. On Drupal 7.x

Is this a Civi bug, or a theme bug?

Before we search for a group.

After we search for a group

When we click 'Contacts' we see Group Visibility as editable choice


texts: Volunteer Report does not report on 'Role'

texts:
When I assign volunteers to shifts via the 'Assign Volunteers' screen, the roles are missing from the Volunteer Report.
When I assign volunteers to shifts via the api though, the Volunteer Report shows their roles.
But if i remove the same volunteers from a role via the 'Assign Volunteers' screen, to mark them as available, then again the Volunteer Report is not responding and shows the person as still having the initial role that the api was able to assign.
Am i doing something wrong? This happens on the latest Civi 4.7.19 on wordpress , but also on a new clean install of Civi 4.7.14 on wordpress .


texts:
How to create a login for individual users in civicrm using WordPress (like membership login)?
Can anyone say how to create it? For this below screenshot i want to create login for users.


texts: CiviCRM Entity, Display tags name in contact

texts:
Here's what I'm trying to do.
I installed CiviCRM with CiviCRM Entities. + few other modules.

At Structure -> CiviCRM Entity -> CiviCRM Contact -> Add custom field (CiviCRM Entity Reference)

I did add a custom field called tags. Connected to Tag Entity. It will appear in display. But tags are numbers.

Now i need to fetch tag names from Tag Entity.

I tried to add it in Contact and with Tag Entity itself.
Did try to add custom field just like Contact.

(Target: Tag, Join: Tag ID, Host Source: ID).

It won't work.
Apparently there's no way to get Tag from Tag Entity for me.

I wonder what's going wrong in here. Can anybody help?


texts: How to expose Mailing Groups in webform?

texts:
I would like to create a webform with a certin mailing group exposed to the user via the checksum link, so that they can subscribe to the mailing group.

If I select "User Select" option during webform processing the entire list of groups of civicrm gets exposed. Does anyone have an idea how to achieve this, please? thanks


texts:
we're having an issue with newsletters being sent out with broken images due to the opening and closing tags being converted to HTML entities.

e.g.
<img src="foo.jpg" /> is sent out as: &lt; img src="foo.jpg" /&gt;

We don't have control over the CiviCRM install however it's running on Drupal 7.

I'm wondering if this is a simple fix I could instruct a client on doing themselves or if it will require more work.

Any insights would be greatly appreciated, thanks!


texts: Wordpress CiviCRM groups, members and permissions

texts:
We are looking to use a Wordpress Multisite / CiviCRM integration and have a multisite development environment setup. We're not sure whether we should be using CiviCRM or Wordpress (or a combo) to establish permissions.

Here's a rundown of the user groups / permissions that we need to establish:

BACKEND USERS

Admin (2) - access everything, create new site

FRONTEND USERS

Committee member (10+) - add/delete documents specific to committees
State Manager (8+) - add/edit/delete members within the state. Add documents for downloading
Members (2500+) - when logged in can search for other members (all states), edit their own details and access private documents.
Public - access unrestricted content only.

Q. We want to limit access to the admin system to the Admins only and get State Managers to add/edit/delete via the frontend. Is this possible?

Q. We want committee members to be able to upload documents via the frontend that can only be viewed by other committee members. Is this possible?

Q. Can member login data (usernames & passwords) be stored in the CiviCRM or do all members need to be Wordpress users also?

Q. Would the Committee members be best setup as groups?

Q. Does anyone have a diagram of how the Members / Groups and other permissions work across a Wordpress integration?


texts: Payment Processor Error message 9003: MD5 Verification failed after upgrade

texts:
After the recent upgrade to 4.6.9, I am getting this error when processing secure Authorize.net payments:

Payment Processor Error message
9003: MD5 Verification failed

My payment processor settings appear to be correct, including API Login, Payment Key, MD5 Hash and Site URL. I am using the Drupal 7 CMS and both settings.php and civicrm.settings.php are correct.

No other issues exist after the upgrade.

*Edit:

I suspect the MD5 Hash value is wrong here, which has always been recorded as my store_id. Should this be a transaction key, or does the hash value come from Authorize.net? Here's a snip from my log file:

    Nov 03 09:27:04  [info] $Fatal Error Details = Array
(
    [message] => Invalid value passed to getPayment function
    [code] =>
)

Nov 03 09:27:04  [info] $backTrace = #0 /home/example.com/public_html/sites/all/modules/civicrm/CRM/Core/Error.php(364): CRM_Core_Error::backtrace("backTrace", TRUE)

1. /home/example.com/public_html/sites/all/modules/civicrm/CRM/Financial/BAO/PaymentProcessor.php(188): CRM_Core_Error::fatal("Invalid value passed to getPayment function")
2. /home/example.com/public_html/sites/all/modules/civicrm/CRM/Contribute/Form/ContributionBase.php(349): CRM_Financial_BAO_PaymentProcessor::getPayment("", "live")
3. /home/example.com/public_html/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Main.php(73): CRM_Contribute_Form_ContributionBase->preProcess()
4. /home/example.com/public_html/sites/all/modules/civicrm/CRM/Core/Form.php(455): CRM_Contribute_Form_Contribution_Main->preProcess()
5. /home/example.com/public_html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(94): CRM_Core_Form->buildForm()
6. /home/example.com/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Contribute_Form_Contribution_Main), "display")
7. /home/example.com/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contribute_Form_Contribution_Main), "display")
8. /home/example.com/public_html/sites/all/modules/civicrm/CRM/Core/Controller.php(353): HTML_QuickForm_Page->handle("display")
9. /home/example.com/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(312): CRM_Core_Controller->run((Array:3), NULL)
10. /home/example.com/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:15))
11. /home/example.com/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))
12. /home/example.com/public_html/sites/all/modules/civicrm/drupal/civicrm.module(489): CRM_Core_Invoke::invoke((Array:3))
13. [internal function](): civicrm_invoke("contribute", "transact")
14. /home/example.com/public_html/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:2))
15. /home/example.com/public_html/index.php(21): menu_execute_active_handler()
16. {main}


texts: Quickform: Set the "Selected" value in a select element

texts:
Maybe is a simple question but, in my form, I not able to set the "selected" value, in my SELECT element:
The following is my code:

CRM_Financial_BAO_FinancialType::getAvailableFinancialTypes($financialTypes, 3);
$this->add('select', 'financial_type', ts('Financial Type'), $financialTypes, 'TRUE');


texts: 'invalid key sent' while cron script is executed

texts:
in civicrm.settings.php I have
if (!defined('CIVICRM_SITE_KEY')) {
  define( 'CIVICRM_SITE_KEY', '2e554f49c9fc5c47548da5C24da64681b77dca08');

When I use the following URL to start manually all cron jobs, I see that jobs get executed, so the URL seems ok to me.
http://xxxxxx.yyy/sites/all/modules/civicrm/bin/cron.php?name=civimail&pass=xxxxxxxx&key=2e554f49c9fc5c47548da5C24da64681b77dca08

The script to start all cron jobs is defined as follows:

!/bin/sh

GET
'http://xxxxx.yyy/sites/all/modules/civicrm/bin/cron.php?name=civimail&pass=xxxxxxxx&key=2e554f49c9fc5c47548da5C24da64681b77dca08'

However, when this script is run, I got this message through mail:

ERROR: Invalid key value sent.

So to me the key seems correct, but even after changing the key to something else both in civicrm.settings.php and in the script, I continue to get this error message. I'm using the latest 4.7.2 civicrm version on drupal 7.
For now I'm using easycron, but I'd like to find out if there is an error in this configuration, or if it's a bug.

Any suggestions for further testing ?

thanks
Wim


texts: CiviMail report showing bulk emails have sent when they haven't

texts:
On two Civi 5.35.1 & Joomla sites, I've got the same issue of bulk emails not being sent, but the CiviMail report stating every email has been sent (0 bounces or replies). The 0 bounces bit of the Mail report is what alerted us to something being wrong. Other Civi emails are working fine. On checking, another Civi 5.35.1 & Joomla site using a different host and DNS provider also worked fine for bulk email.
Eventually by looking at the server's mail delivery logs I realised that the emails had never sent, with an error that looks like
587 I=[185.181.117.20]:48996 X=TLS1.2:AES128-GCM-SHA256:128 CV=yes DN="/CN=*.filteredmx.net": SMTP error from remote mail server after MAIL FROM:<b.1231.77517.036450515a4f21ca@qwerty.org> SIZE=3092: 550-Verification failed for <b.1231.77517.036450515a4f21ca@qwerty.org>\n550-Called: 185.181.117.37\n550-Sent: RCPT TO:<b.1231.77517.036450515a4f21ca@qwerty.org>\n550-Response: 550 No Such User Here"\n550 Invalid sender <b.1231.77517.036450515a4f21ca@qwerty.org> DT=2.353s

With help from here - Mosaico mailings not sending - I saw this means bounce processsing had stopped working.
I tried with a different email account from an external domain (ie another email address I have) - and it all worked again. So it seems there's two issues here:

a Civi error notice issue, because Civi appears to be telling the user mails have been sent when they haven't. It took quite a bit of digging (e.g. turning on MailLog in civicrm.settings.php - gave no insight) before I eventually checked the 'Email Deliverability' screen in Cpanel where I found these errors.

and the 'something has changed in the last few weeks' issue - that might have nothing to do with Civi 5.35.x and be more about Cloudflare or Cpanel or our webhosts. What's especially odd is both sites will let me use an external Dreamhost-hosted email for bounce processing, but each of them if I use a correctly setup email account for the same domain the site is hosted at don't work - even tho one is using Gsuite for mail processing and one is using Cpanel.

None of this is urgent any more as we've got CiviMail working again - but still not sure what the wider issue might be (perhaps nothing to do with Civi at all), and thought it useful to track this here because it happened to me on two sites so maybe happens to someone else.


texts: How to write unit tests for methods thsat echo instead of return (e.g., AJAX call handlers)

texts:
There are several methods in CiviCRM that just print their output directly to the buffer and then exit, because they're just sending an HTML snippet or other response for an AJAX call. For example, CRM_Event_Cart_Page_CheckoutAJAX::add_participant_to_cart().

What are best practices for (or existing examples of) unit tests that cover such methods?  I could, I suppose, use ob functions to capture the output, but then I'd need an external library to parse and test the HTML. Are there better ways, and are there examples already in place?


texts: Is there a way to create a new group from report results (instead of adding to an existing group)?

texts:
I see that I can "add contacts to a group" from report results, but what if I need a new empty group?

Is there a way to create a brand new group right from the report preview?


texts: how can I embed a civicontribute page in wordpress with gutenberg?

texts: I cant see how to embedd a civicontribute page using gutenberg, any thoughts?


texts: Is it possible to Pre-Fill Form Fields Using URL Parameters?

texts:
I would like to pre-fill this field in the picture and I have tried with following URL, but it doesnt seem to work! Anyone has clue if this is possible with civicrm links? Thanks

https://example.com/civicrm/mailing/browse/scheduled?reset=1&scheduled=true?mailing_name=SOMENAME


texts:
We have since 1 year a subscription to Spark, but I don't remember where I can administer the subscription... I would like to check the payments situation of our spark account, etc...
With my "admin" user account, I can work on our database, but I don't find how to manage the account/subscription. Thx a lot for your help and sorry for the trivial question...

Marc Aellen

Our database: https://focolarisuisseromande.civicrm.org/


texts: honoree profile using contact reference field gives 'loading failed' error

texts:
WP 5.2.2 civi 5.19.3
logged in as admin.
the first contact reference field works fine.


texts: Is it possible to cancel/write-off upcoming pledge payments?

texts:
We have had a few situations recently where we need to write off upcoming payments of a partially-fulfilled multi-installment pledge. The catch is that we want to preserve the record of the pledge but indicate we do not expect to receive the money. We need this for auditing purposes, to match our CiviCRM data to our accounting data.

For example, we had an grantor fund an employee for 2 years, paid quarterly. We had received the money for the first 5 installments, but now that employee is leaving, so we won't get the final three payments. I am looking for some way to mark the pledge closed, without deleting the payments or recording the forthcoming payments as completed. Is this even possible?

Thanks!


texts:
When I change some Civi settings they do not get applied. It seems to be only when deselecting some checkboxes. For example, in Custom Fields I deselect: Collapse this set on initial display. It looks like its saved but when I go back to the settings it is still ticked.

I can tick: Collapse this set in Advanced Search. hit save and it stays ticked. But when I untick the box and it remains ticked.

When I deselect: Is this Custom Data Set active? - The settings are saved.

This also happens in the Edit Scheduled Reminder settings page. I untick: Record activity for automated email and hit save. When I go back into the settings for the reminder it is still ticked.

There are no obvious logs. CiviCRM 5.25.0, Drupal 7.70 , PHP 7.3.18


texts: Changing membership category. Does that effect auto-recurring payment system?

texts:
I am wanting to change the category of a auto-renewing monthly membership and am wondering if changing the actual membership category effects this or not?

How does a payment processor communicate with CiviCRM to do this anyway?

Thanks all!

Andy Burns


texts:
I have geocoding enabled but getting the contacts geocoded seems hit and miss.

I can get them geocoded if I go into the record and resave the address field (without making any changes). The small red "map" icon then comes up and they seem to get geocoded in the saving process. I have only a 1000 records so I can go through them manually.

However when I try to do the batch geocoding I just get this - which I don't understand although it seems to be saying I have an invalid start id. Any ideas how I could start to trouble shoot this?

Parameters raw (from db settings):
geocoding=[1 or 0] required
parse=[1 or 0] required
start=[contact ID] optional-begin with this contact ID
end=[contact ID] optional-process contacts with IDs less than this
throttle=[1 or 0] optional-1 adds five second sleep

Parameters parsed (and passed to API method):
a:6:{s:7:"version";i:3;s:9:"geocoding";s:17:"[1 or 0] required";s:5:"parse";s:17:"[1 or 0] required";s:5:"start";s:48:"[contact ID] optional-begin with this contact ID";s:3:"end";s:62:"[contact ID] optional-process contacts with IDs less than this";s:8:"throttle";s:42:"[1 or 0] optional-1 adds five second sleep";}

Full message:
Finished execution of Geocode and Parse Addresses with result: Failure, Error message: start is not a valid integer

Thanks!


texts: Can you change Added By information via a profile?

texts:
5.21.1 D7

Is it possible to change who added an activity/contribution - someone was logged in as someone else and well - its been an internal problem to say the least. I am being asked to change the Added By to the correct person.

Thoughts?


texts: Recurring contribution report by LineItem financial type

texts: I am looking for a report that lists recurring contributions by Line item financial type. I have tried the Find Contribution report, the Advanced Search, the contribution report Recurring Contributions... They all only query the Contribution table Financial Type. I need to query the Line Item financial type.


texts: com_civicrm/civicrm/CRM/Core/BAO/SchemaHandler.php on line 730

texts:
Do you have any information about the solution of the error found in the image?

Joomla Version: 3.7.4
CiviCRM Version: 4.7.22


texts: Integrating Multi-Channel External Payment Gateway with CiviCRM/Wordpress

texts:
I've been working with a client in Indonesia to get up and running on CiviCRM to help raise money online, and better keep track of those donations.

We are working with an external payment gateway that offers a variety of payment channels, ie. credit card, bank transfers, direct debit, mobile-phone credit transfers and payment at convenience store kiosks. This broad range of channels is a real blessing for us, but I just realized that when I added the payment processor to our install of CiviCRM, the "payment_type" was set to a static choice (credit card, or direct debit). As a result, transactions will always be listed in available report templates as a payment_type representing that static choice, rather than the wealth of options that are available via the external payment gateway.

Is there a way to allow for the payment gateway to pass back the information on the payment_type and for to store that info in the database somewhere? And if so, where would that info be stored?

We are running CiviCRM 4.7.16 on Wordpress 4.7. The custom payment processor extension the folks at the payment gateway built for us is available at: https://github.com/rizdaprasetya/vtweb-civicrm

Any help or advice would be greatly appreciated.


texts:
Using CiviCRM 4.6.8 and Wordpress 4.3.2, all of my Event Info pages and Registration pages show as being private even though I've selected public and the Manage Events interface lists them as public. Regardless, visitors to the site are unable to access these pages.

I'm really not sure what I could be missing here. Any suggestions?


texts: back-end checkboxes not displaying after switch to Shoreditch

texts:
After switching to the shoreditch theme, the checkboxes on our back-end site are not displaying appropriately in all situations.

When listing Contacts from a search, the checkboxes that should be in the left column only show up if you click in that column within a few seconds after the page loads. If you wait a bit, they do not show up at all.

When merging contacts, the checkboxes to select what data to merge do not show up at all.

I haven't exhaustively looked at every instance, but Checkboxes display appropriately when listing a Contribution search.

I can replicate this behavior on both Chrome and Safari. CSS shows the following in /media/civicrm/custom_ext/org.civicrm.shoreditch-master/css/custom-civicrm.css?r=65LNz:

.crm-container input[type=checkbox], .crm-container input[type=radio] {
    display: none;}

This css file is so large that I'm cautious about just unsetting the display property, not knowing exactly what cascade that might cause. Anyone have a clue about this?

Further, as part of the extension, I assume any edits to this file will be overwritten on the next update.

Is there a location where I can set up my own custom css file for Civi (other than my global CSS.) while still using the Shoreditch theme? (We've been using a custom civi css file up to now, but that's not an option with Shoreditch.)


texts:
I'm crowd sourcing features for, and people interested in, a Crowd Funding extension for CiviCRM.

I've made a head start which meets most of my needs. The work so far is open sourced: https://github.com/JohnFF/com.civifirst.crowdfunding/ this is being used and has been used for some time in a Production setting.

It has the following features:

Each Contribution can have a Parent Contribution (to be renamed
"Target Contribution") which has an "accumulated funds" field.
The accumulated funds on the Parent Contribution is updated as Contributions with that Parent Contribution are added.
The status of the Parent Contribution is updated as funds are added in real time as well: from Pending, to Partially Paid, to
Completed.
Any Event Participations dependent on that Parent Contribution have their status updated as well.

I want to add the following features:

A generic screen to display statuses of things being Crowd Funded for (I've made this bespoke for my needs, it's just not in the extension yet).
The ability to email all Contributors.
A hook for "upon Contribution" to let other extensions use the system.

I am mostly seeking requirements, suggestions, and co-maintainers. I am prepared to put up time and potentially cash as well.


texts: How do you import contributions as Pending (Pay Later)?

texts:
After reviewing Pay Later status on imported contributions - I followed the answer - created a column listed as Is Pay Later - and added the value 1 to all contributions.  Did it again as Yes - both times all contributions were imported as complete instead of pending pay later.

Drupal 7 - 5.20


texts: CiviCRM Contact,get with group - change in result format

texts:
Where (which JIRA issue, if any) did this change in API behaviour come from, and was it documented/expected?

The same Contact,get API call returns different results between 4.6 and 4.7.

IMO the new style is better, but I'm not sure the change was intended/documented. (I want clarification so I can expect the new behaviour to stick!)

I've confirmed this behaviour today by testing on the 4.6 (Joomla) and 4.7 (Drupal) demo sites.

API call for Contact,get with return=group shows groups in the results.

civicrm_api3('Contact', 'get', array(
  'sequential' => 1,
  'return' => "group",
  'id' => 3,
));

In 4.6 the result has groups shown by their group "title" (not name). Since group titles may contain a comma, there is some lack of certainty in the results (leading to workarounds like this).

[
  'is_error' => 0,
  'version' => 3,
  'count' => 1,
  'id' => 3,
  'values' => [
    [
      'contact_id' => '3',
      'groups' => 'Example group,Example smart group',
      'id' => '3',
    ]
  ]
]

In 4.7 the result has groups shown by their group ID, which is a bit more predictable to work with.

[
  'is_error' => 0,
  'version' => 3,
  'count' => 1,
  'id' => 3,
  'values' => [
    [
      'contact_id' => '3',
      'groups' => '4,7',
      'id' => '3',
    ]
  ]
]

I've checked the CiviCRM API Changelog and enquired on chat.civicrm.org without any luck so far. Help me, SE!


texts: Is it possible to reassign a contribution linked to a membership?

texts:
I had a member sign up for an annual membership while their current membership was still active, but they used a slightly different address and so it created a duplicate contact with a new membership. I merged the two contacts and so now I have one contact record with two memberships. I want to keep the older membership and delete the newer one, so I manually renewed the older one. However, deleting the newer one will delete the contribute record associated with that membership.

How can I reassign that contribution, or at least remove the link between the contribution and the newer membership, so that I can delete that membership?

Thanks!


texts:
We have attempted to upgrade the CiviCRM instance multiple times, but all attempts for that failed with the following error:

  ALTER TABLE civicrm_mailing_event_queue DROP FOREIGN KEY FK_civicrm_mailing_event_queue_email_id [nativecode=1091 ** Can't DROP 'FK_civicrm_mailing_event_queue_email_id'; check that column/key exists]

I have followed multiple suggestions on the Internet of people experiencing similar (if not the same) issues, but this did not help either. For example, I have tried the following recommendation:

  Unable to upgrade to 4.7.6

but it did not resolve the issue. I have also followed the instructions here:

  https://forum.civicrm.org/index.php?topic=29889.0

as well as the official documentation of CiviCRM here:

  https://wiki.civicrm.org/confluence/display/CRMDOC/Ensuring+Schema+Integrity+on+Upgrades

Here's my site profile link. https://mycivi.org/profile/snapshot/8yejn-Wwh0X-pHIht-GVWI3

Any suggestions on how to proceed?


texts: Where is the exact path to the ConfigAndLog log *file*?

texts:
In the latest awesome pattern we can now locate our log service easily:

Civi::log()->info('Hello, log!');

And then we can tail the log which is in our ConfigAndLog directory. Chris has enumerated the other log files around and Jon has described where to find the directory in different CMS's but I need to have a one liner to point me directly at the current log file.

For me, right this second, it is:

/opt/buildkit/build/dmaster/sites/default/files/civicrm/ConfigAndLog/CiviCRM.e6449e3815b7721f267195e2.log

How do I find this next time without having to go hunting around? Ideally I'm after a cv based one-liner.


texts: Best way to write module for 'unusual' payment gateway

texts:
We are looking at writing a module for Ezidebit. Ezidebit allow the setup of Direct Debit payments online. However, the initial request to Ezidebit includes the payment frequency and Ezidebit initiates these future payments on the frequency provided.

So once setup Civi does not need to request any further payments from Ezidebit. Instead it just needs to import the payment receipts - which are available from Ezidebit via an API.

I'm wondering what the best way to go about building a module for this will be? It's not really a payment gateway as there are no real-time payments available via this aspect of Ezidebits service. It is probably more like a bank account with payments being received by Ezidebit that need to be entered in to Civi.

In Civi it is most likely going to be used for Regular Donors and if so we would need to be able to track the commitment the donor has made and also the actual payments received. This doesn't seem to quite fit Pledges (as it is ongoing) or recurring payments (as Civi does not initiate the payment).

Any suggestions on the best approach for this?


texts: I'm wanting to refine the de-duping rules, but first of all I'd like to find out exactly what the predefined rules are before I create my own. They are reserved, so you can't edit them, which is fine, but it only tells you which fields they use and not what the weights and thresholds are so the full behaviour is not clear.


texts:
Problem 1
Installing CiviCRM using Composer has started giving these errors:
    - Root composer.json requires civicrm/composer-compile-plugin ^0.14.0 -> satisfiable by civicrm/composer-compile-plugin[v0.14].
    - civicrm/composer-compile-plugin v0.14 requires totten/lurkerlite ^1.3 -> could not be found in any version, there may be a typo in the package name.

Problem 2
    - civicrm/composer-compile-plugin v0.14 requires totten/lurkerlite ^1.3 -> could not be found in any version, there may be a typo in the package name.
    - civicrm/civicrm-core 5.31.1 requires civicrm/composer-compile-lib ~0.3 || ~1.0 -> satisfiable by civicrm/composer-compile-lib[v0.3, v0.4].
    - civicrm/composer-compile-lib[v0.3, ..., v0.4] require civicrm/composer-compile-plugin ~0.9 || ~1.0 -> satisfiable by civicrm/composer-compile-plugin[v0.14].

Does anyone know what has gone wrong?


texts: Best Approach to Series of Events - Sold as a Package

texts:
We have a 5 week series of classes - we wanted one purchase to register the attendee for all 5 weeks with one purchase.  We created a repeating event, but we were unable to turn off registration for events 2-5. What we ended up doing was creating the first event as the main event then created a duplicate repeating events with registration off, linking them all to the main event in the description.

While it has been suggested to just list the dates in the description and have the event span the weeks that the event takes place. That does not meet our needs. We want to be able to track attendees per event. For now, we will just upload the registrants to the other events and mark the attendees.

Wordpress and CiviCRM Latest


texts: Invoice for membership with auto-renewal wrong - VAT added twice

texts:
After I configured a membership with the option of auto-renewal (recurring contribution) the generated invoices seem to be wrong. The amount for the membership payment line item is not stated as net, but already includes VAT. In addition, VAT is listed in the invoice and added on top of the gross amount. The processed transaction in the backend (Stripe in this case) is correct in terms of charges (regular gross amount, no double VAT).

The invoice was correct without activating the auto-renewal option.

CiviCRM is version 5.16.2 on WordPress 5.2.3 with Stripe payment extension 5.4.1

I found the following Q&A on StackExchange:
Contribution - Wrong VAT amount showing

The above question was "just" related to a wrong report. In this case, the issue seems more serious. At least according to German tax law, if the VAT amount in an issued invoice is accidentally stated too high, the issuer of the invoice owes the full stated VAT amount to the fiscal authorities.

I was trying to have a look at the open issues list, but was not able to find the (known?) issue.

My questions are:

Are other users seeing the same behavior?
Is this potential bug already known?
Is there a known workaround?

Many Thanks!


texts:
Mosaico 2.1 has just been released. When I tried to upgrade from Mosaico 2.0 to 2.1 I got several errors as follows:

Unable to remove directory
/sites/default/files/civicrm/ext/uk.co.vedaconsulting.mosaico/templates

Unable to remove directory
/sites/default/files/civicrm/ext/uk.co.vedaconsulting.mosaico

Failed to move /tmp/tmp-aBft2l//uk.co.vedaconsulting.mosaico to /sites/default/files/civicrm/ext/uk.co.vedaconsulting.mosaico

Error loading module file (/sites/default/files/civicrm/ext/uk.co.vedaconsulting.mosaico/mosaico.php). Please restore the file or disable the module.

Following the upgrade Mosaico then became unusable.

I upgraded Flexmailer at the same time and had no problems. I also checked folder permissions and these looked fine to me. I ran the upgrade process twice and had the same errors both times. has anyone had a similar error?

I thought it might be an error in the extension and posted an issue at Error Upgrading from 2.0 to 2.1, but I guess it could also be my setup, though not sure why it would upgrade Flexmailer without any problems but then have errors  upgrading Mosaico.

I am on CiviCRM 5.13.5 with Drupal 7.67


texts: Can't view "Public View" of "Scheduled and Sent Messages" as a Super User admin in CiviCRM. Incorrect URL being constructed

texts:
(Joomla 3.9.8)
(Civi 5.14.1)

When signed in as a Super User in CiviCRM, I am getting an error when trying to view the "Public View" of "Scheduled and Sent Messages" for Civi Mailings.

The error message I get is:
You do not have permission to access this page.

One thing I noticed is that my url loses 'administrator' when clicking "View Public View" and instead looks like this:
index.php?option=com_civicrm&task=civicrm/mailing/view&id=413&reset=1

If I manually remove index and replace it with administrator the url works:
administrator/?option=com_civicrm&task=civicrm/mailing/view&id=413&reset=1

I checked the Global Configuration in Joomla for CiviMail: view public CiviMail content and it is indeed allowed for a Super User, but it still does not work. The only way to get the 1st, Civi generated url to work is to set CiviMail: view public CiviMail content to enabled for all the public. I don't want that.

So my idea was to go into Civi's core, find out where this url is being created and change the index? part of the url to administrator. I am not sure where to find this. Does anyone know where this url is being constructed? If there is a better way of doing this, I would like to know as well.


texts: Why have all my custom Civi fields stopped showing up in Drupal view?

texts: Title says it all really. Sometimes, mostly after an upgrade in my experience, I will go to edit a View that uses CiviCRM Custom Fields and will find messages like 'broken handlers' etc. How can I fix this?


texts:
Recently found particpant 'contributions' using online CC payments were  missing trxn_id during a several hour period (Jan 31, 2019) - the civicrm_contribution and civicrm_financial_trxn rows were otherwise normal, so it appeared AuthorizeNet.php didn't return trxn_id in the result.
 AuthorizeNet returns errors if 1)it can't connect w/the payment gateway, 2)can't verify SSL, 3)verify the MD5 passcode, or if the payment is declined or CC # was wrong, but those errors would be surfaced in the UI (I think).
 Authorize did accept the payments and generated trxn_ids.  Is it possibly an SSL cert problem? I recently started using 'let's encrypt', anyone had a problem w/that?