texts: Upgrading issues on Wordpress - Solution

texts:
This is for anyone having difficulties upgrading.

I spent a LONG time trying to upgrade the Wordpress version 4.4.4 of CiviCRM and had many problems.

I tried upgrading in small steps e.g. 4.4.4 > 4.5 > 4.6 > 4.7 but I could only get as far as 4.4.9.

I tried following the guide to rebuild a fresh database schema and import a data dump, but that failed.

When I used the built in upgrade facility I got errors such as:

ALTER TABLE civicrm_case DROP FOREIGN KEY FK_civicrm_case_case_type_id

So, here's what I had to do...

Follow the CiviCRM upgrade guide to BACKUP YOUR DATABASE, upload the latest version of Civi and your settings file.
Start the upgrade process by going to: admin.php?page=CiviCRM&q=civicrm/upgrade&reset=1
If the upgrade process throws an error, note which process was being done when the error happened. In my case it looked like this: [Error: Upgrade DB to 4.7.18: SQL]. This tells you which sql file has the error.
Find the corresponding sql file in civicrm/civicrm/CRM/Upgrade/Incremental/sql/ - in my case above it was: 4.7.18.mysql.sql
Back on the error page, copy the offending SQL code. In my case it was: ALTER TABLE civicrm_case DROP FOREIGN KEY FK_civicrm_case_case_type_id
Find that line of code in the sql file and comment it out.
Upload the file
Revert your database to your previous version and run the updater again

I had to repeat this process when upgrading from 4.4.4 > 4.5.0 and then from 4.6.31 > 4.7.23

I don't know if removing this step in the upgrade has any bad effects on CiviCRM but all seemed to work for me.

Could an expert let me know if this was an ok thing to do?


texts:
I have been working on my membership database on civicrm for the last 4 years and since March I have not been able to access it.
I normally type this on google https://hlpacivicrm.esptest.co.uk/cms/wp-admin
and I get a prompt to put username and password but I get an unrecognised message at the moment.


texts: Change Payment Method without creating additional transactions

texts:
A version of this has been asked before - but the answer was quite complex - so I am hoping for an ELI5.

Essentially - when manually adding contributions - sometimes people make mistakes.  when editing a contribution - from check to cash for example - a debit and a credit is processed.  See example below of a contribution that was entered as Check but was actually cash and was changed. While that's typically fine - when trying to find a specific contribution - these old records clutter the results.  Is there a way to make sure they do not appear in searches and reports - or is there a way to simply delete the old payment detail records - as really there was only supposed to be one in the first place.


texts:
We collect a number of monthly direct debit payments of £30 using SmartDebit. The breakdown is £25 fee + £5 VAT.

Although the SmartDebit report shows that we collected £30, in civi (under contributions) the total amount is showing as £36 (£30 + £6 VAT).

Is there a way of changing this so that the correct amounts appear. I am using civi 5.10.3 and SmartDebit version 1.30


texts:
Just wondering if anyone can direct me how I can configure webform and civicrm to send invoice to user when they submit the webform.

I can see from the URL (https://wiki.civicrm.org/confluence/display/CRMDOC/Webform+CiviCRM+Integration) that email receipt is possible using webform civicrm.

Email receipt - if enabled, these will be sent from the webform just as they would be from the real contribution page

Thanks in advance.


texts: Can't complete install CiviCRM in Drupal 7

texts:
Trying to complete Step 4 "Run the Installer" where I go to the index.php page.
Here is my page, I get no install screen -- LINK REMOVED --

Any help is greatly appreciated.


texts: Make CiviMail work with from address a Google Domain!

texts:
The email for my domain is provided by gmail. However, any time I try to send an email from my CiviServer to that domain only, the email isn't received, and I get:

250 2.1.0 ... Sender ok

      RCPT To:
      DATA
      550 5.1.1 ... User unknown
      503 5.0.0 Need RCPT (recipient)
      RSET
      250 2.0.0 Reset state

I read in this question on Stack Overflow (Sendmail returns error code 550 5.1.1, "User unknown") that the system thinks it needs to send it to itself, so it gets confused (if I've understood correctly).

My question is, what do I do about it? I still want my gmail domain to be my mail handler. But I still need my domain to be able to send emails that will hit my gmail domain inbox.

Should I change my domain name to [REDACTED] and not [REDACTED].com?


texts: How to hide old contacts from default search? (best practices for old contacts)

texts:
Deleting contacts causes problems because it removes their contribution records.

At the same time we don't want old contacts to show up unless they are explicitly requested (such as when searching for deleted contacts).

Is there any way to hide old contacts and exclude them from all queries? I know how to do this with advanced searches, but I don't want my basic user to have to deal with this.

Are there other ways to deal with old contacts and keep the database from becoming bloated?

I appreciate any help.


texts: Upgrading a Joint Membership to Joint Life on renewal leaves the subsidiary Joint Member with the old end date

texts:
Running Civi 5.8.2 under Drupal 7.63. The title says it all, really. Joint annual members converted to Joint Life during their membership period. This was entered as a renewal with "change membership type", and although the primary Member's End Date was set to Null, the End Date of the Member by relationship remained as before, the end of their annual membership. Fixed quite simply by editing the database record, but seems to be a fault.

Any ideas welcome.
Tom Crawshaw


texts:
So - here is the issue - link previews of CiviCRM pages have some issues. Any idea as to why this is?

Example: https://tarabnyc.org/civicrm/?page=CiviCRM&q=civicrm%2Fevent%2Finfo&reset=1&id=114

On wordpress block embed:

On Facebook Embed a bit better but the page title is still CiviCRM - when facebook feels like it - we can edit the title - which is great, but when other people share the page - its not so great.


texts:
Civix doesn't seem to work with Joomla! 3.9.3. According to this, Joomla! 3.9.3 doesn't allow loading of phar packed files. When I try to run civix, I get the following exception error in a red panel:

[TYPO3\PharStreamWrapper\Exception]
  Unexpected file extension in "phar:///usr/local/bin/civix/bin/api/class.api.php"

I reverted to Joomla! 3.9.2 and civix works again.


texts: Is it possible to have a user that's only capability is to work with Mosaico. Specifically to Create/modify templates

texts: I'm a one man show and this is my first excursion into setting ACLs. I have a volunteer that wants to work with me on creating & editing Mosaico email templates. At some point they may also be granted priv to send mailings. I've gone through the process of creating ACLs but, they don't seem to have any way to give someone just that 'Mosaico' privilege. Is this possible? Thanks in advance!


texts: How to setup CiviCRM to proper send authenticated (DKIM) emails?

texts:
i want to make sure that all emails send out through CiviCRM have the proper authentication (DKIM). Currently I use (ticket@yogamela.org) as email from address for online event registrations. The same email I created also as mailbox in CiviCRM. But tests show, that the mail is sent with wrong DKIM signature. How to configure it in the right way?
Is CiviCRM using the mailbox i configured for sending out the email if the email address is the same, or do i need to change anything else?

Mails send directly through using webmail have the proper DKIM signature.

Here the test result if the mail is send through Event Registration in CiviCRM:
https://www.mail-tester.com/test-fp3hn&reloaded=1

Could it be that i have the same problem like described here:
CiviMail DKIM signature failure

Or did i just set it up wrong?

UPDATE:

For now i try to setup one authenticated email. Later i may want to add more. In case so can I add them all as Outbount Mails?
Sitegound provides both email hosting and server hosting.

As suggested I setup now an new Outbount Mail using SMTP:
Administer --> Settings - Outbound Mail

ssl://c15801.sgvps.net    (i tried also without ssl://)

465    (i tried also 25 without ssl:// and authentication: no)

Authentication? Yes

ticket@yogamela.org

Then this error comes after clicking save and test:

The site administrator needs to enter a valid 'FROM Email Address' in Administer CiviCRM » Communications » FROM Email Addresses. The email address used may need to be a valid mail account with your email service provider.

In the FROM Email Addresses I just entered ticket@yogamela.org.

Is my smtp server setup wrong, or my FROM email setup? The email address / password is a valid email with sitegound the port and server (without the ssl:// part) is what siteground recommended to use.


texts: Nothing happens when selecting any "Actions" dropdown options

texts:
After upgrading to 5.12.1 (and then 5.12.3), none of the dropdown options under "Actions" work. For example, when conducting an Advanced Search and selecting, "Print/Merge Documents" or "Export Contacts," nothing happens.

Here is the console error:

main-menu.js?r=dBZqC:66 Uncaught TypeError: Cannot read property 'trim' of undefined
    at isQuickSearchOnGoing (main-menu.js?r=dBZqC:66)
    at HTMLDocument.<anonymous> (main-menu.js?r=dBZqC:99)
    at HTMLDocument.dispatch (jquery.min.js?r=dBZqC:3)
    at HTMLDocument.r.handle (jquery.min.js?r=dBZqC:3)
    at Object.trigger (jquery.min.js?r=dBZqC:3)
    at HTMLInputElement.<anonymous> (jquery.min.js?r=dBZqC:3)
    at Function.each (jquery.min.js?r=dBZqC:2)
    at n.fn.init.each (jquery.min.js?r=dBZqC:2)
    at n.fn.init.trigger (jquery.min.js?r=dBZqC:3)
    at n.fn.init.n.fn.<computed> [as click] (jquery.min.js?r=dBZqC:4)

Any insight would be greatly appreciated!


texts: I would like to change the membership type

texts: I have a member who signed up under the incorrect membership type. Can I change this? What if the member has already made her membership fee?


texts: Drupal 8 version of CiviVRM Membership Roles Sync?

texts: Is there a Drupal 8 version of the CiviCRM Membership Roles Sync module, or is one planned?  I can't see it, or any opportunity to configure an equivalent facility.


texts: PayPal Receipts Showing a Pending (Incomplete Transaction)

texts:
The confirmation is returned from Paypal and the Thank You page is displayed, however the db still shows Incomplete Transaction, and confirmation email is not sent.  I'm pretty sure this issue was introduced by an update in Feb 2016.  Anyone found a resolution yet please? (Joomla 3.5.1 currently)
Thank you


texts: Stop recur mails from sending out to users

texts:
Current civi behaviour is that whenever a recurring payment is made using a contribution page, two emails are sent.

Contribution Receipt AND
Recurring start notification.

Now, when the next scheduled date occurs, a contribution is recorded which additionally send an email to the user notifying about the recur payment.

We don't want this recur start, periodic emails and the end notification to be sent by CiviCRM.

We've written a small extension which is able to stop the start and end notification. Is there an existing way to stop periodic recur e-mails?

CiviCRM version 4.7.29.


texts: I need a developer for a custom extension where is the best place to ask?

texts: All is in the title. We have a client with specific need. We would like to hire a developer to build the extension the right way and share it with the community. Where's the place to do it ? Here ?


texts: What do I do when rebuild Smart Group Cache fails?

texts:
(Sorry, was hoping to not have to start a new Question but instead comment on another's but StackExchange doesn't allow it unless you have 50 points of privileges.)

CiviCRM 4.6.0
Joomla 3.4.1

I am getting errors on both manual use and cronjob:

Manual button in Groups:

    @import url(/administrator/components/com_civicrm/civicrm/css/civicrm.css); @import url(/administrator/components/com_civicrm/civicrm/bower_components/jquery-ui/themes/smoothness/jquery-ui.min.css);    Sorry but we are not able to provide this at the moment.  is not of the type Int Return to home page.    function toggle( element ) { var className = element.className; if ( className == 'crm-accordion-wrapper collapsed crm-fatal-error-details-block') { element.className = 'crm-accordion-wrapper crm-fatal-error-details-block'; } else { element.className = 'crm-accordion-wrapper collapsed crm-fatal-error-details-block'; } }

Scheduled Jobs (cronjob):

  Parameters raw (from db settings):
  limit=Number optional-Limit the number of smart groups rebuild

  Parameters parsed (and passed to API method):
  a:2:{s:7:"version";i:3;s:5:"limit";s:56:"Number optional-Limit the number of smart groups rebuild";}

  Full message:
  Finished execution of Rebuild Smart Group Cache with result: Failure, Error message: A fatal error was triggered:  is not of the type Int


texts: Import Contribution - last step no longer goes to 'Summary / Error' report

texts:
We recently updated to CiviCRM 5.23.1

In the prior version when running it would run through the 4 documented stages
 1. Upload Data
 2. Match fields
 3. Preview
 4. Summary

But in 5.23.1  the summary stage no longer displays

As Summary is still staged as Step 4 - this looks like a bug - is this the case, and is there a fix to it?


texts: CiviCRM for selection and subscription to paid online content

texts:
Consider this case:

We manage a very very long hiking trail across many states. It's divided in 20 sections.
To get the digital maps, section coordinator contacts, section emergency alerts, section online updates, right to access private land, people have to signup and select as many sections as they want during the signup process. For each section there will be specific email sent and online content available (1 page per section to start with, maybe a blog + forum + chat per section in the future). Some hikers might decide they need them all. Some only need a couple of the sections.

Hikers are then subscribed to the selected sections for 1 year, renewable.
There is a specific cost associated per section. They pay for the total + a national annual membership fee.

Can we use CiviCRM for this purpose? It's mostly online digital subscription which is close to the concept of membership, IMHO.
But I'm not clear on the data mapping and which entities to rely on.

Is each of the 20 section a different membership type? Or a different price in a price set? or a different priceset?

Should we use CiviRule to add contact to groups based on the membership types they selected (or priceset element?) Creating 20 membership types seems overkill, isn't it? Do I have to then create 20 organisations in CiviCRM to map the 20 sections?

I've used CiviCRM in the past for traditional NGO, so I'm keen to also reuse all the other features too. I have development background and will hire Drupal devs to help out.


texts: Manage Groups page not showing parent groups with nesting of child groups after upgrade

texts:
After upgrading to from 4.7.14 to 4.7.22 The layout of the Manage Groups page listing changed from:

Parent Group
-- Child 1
-- Child 2

Another Group

To:

Child 1 group
Child of: Parent Group
etc.

See attached picture for display

Is there a setting that controls how the nesting is displayed?

(There is also a database error when the page is first displayed and then the groups are displayed)

Not sure if this is a bug or a feature that needs to be changed.

Continued testing - see the second picture which shows the preferred layout.  the second layout resulted from using the browser back arrow and then the forward arrow.  Very strange.


texts: How to let CiviCRM not send a confirmation to a new Mailing Group member?

texts:
I added Groups to a Profile for a Contribution Page.

The public Mailing Group is nicely shown on the Contribution Page.
Can I prevent CiviCRM from sending a confirmation email?

It's on a Donation Contribution page with a IPN Payment Provider, so I can not use a webform for this page.


texts: In which file can I find and edit CiviPledge CSS styling to make the form look more in line with the rest of my site? Thanks!


texts: Permission(s) to edit cases created by the user

texts:
I want to restrict a role to be able to create cases in CiviCase and be able to edit them. The "access my cases and activities" permission allows the role to create cases, but not to add new activities to the case they created. "Access all cases and activities" permits the role to edit not just their cases, but every case.

In other words, I want the role to

be able to create new cases
be able to edit the cases the user created
not be able to edit other's cases

Running CiviCRM 4.6.8 on Wordpress 4.3.1. Is there any way to achieve this at the moment?

edit: Could it be that this behaviour is a bug, and the "access my cases and activities" permission is supposed to do exactly what I want?

edit2: Updated to CiviCRM 4.6.9, and now it seems that the "access my cases and activities" permission allows the role to create and edit all cases and activities. I don't think this is the intended outcome though, as that would make "Access all cases and activities" useless.

Could anyone confirm this?


texts: Webfaction hosting, behind a proxy - broken dashlet

texts:
Webfaction hosted servers are behind firewalls/proxies. Unlike standing up apache (i.e., socket:xxxx on localhost), their wordpress installation appears to simply be the wordpress code. Therefore, they appear to application route the WP requests vs. NAT/firewall the TCP.

I would guess the civicrm plugin doesn't pass "HOST:" http headers ...

yes, no, solutions? (see pict)

Note:specific menu items (e.g., Administer-> System Settings -> Option Groups) render fine. (and, that messed up CSS is probably due to the 404 page's css)


texts: eWAY payment processor not sending receipts on membership signup

texts:
When signing up for membership using contribution page, our eWAY payment processor is not generating a receipt for the end user. The Civi contact is created correctly, the Civi receipt is sent to the end user and the transaction is processed correctly through eWAY but eWAY receipt is not being sent.
If a membership is added to an existing Civi contact, the process works correctly, that is, membership created, Civi receipt sent and eWAY receipt sent.
We have been advised by eWAY that no email address is being submitted for these transactions.
Any help would be greatly appreciated.


texts: how to show all groups in user dashboard?

texts:
In our system, we have some groups that only a manager can add or remove people to, however we would still like the contacts to be able to see that they are included in those groups via their contact dashboard.  Any group membership that is listed as "user and user admin only" management settings are not showing up in the contact dashboard. While the "public pages" settings seem to be needed to have the group show up in the dashboard, we don't want the users to be able to unsubscribe from some key organizational roles.
Is there either a way for all subscribed groups to be shown in the user's contact dashboard? (preferred) or a way to limit showing the unsubscribe link on these (many) critical org roles?  Thanks much!
*using civi 5.2.2 and drupal 7


texts:
Trying to add NMI integration to my CiviCRM using OMNIPAY.

I added the GIT repository (tried https://github.com/mfauveau/omnipay-nmi and https://github.com/nerdmedia/omnipay-nmi) and added the required line that is listed in the readme.

I also created an MGD.PHP file for it and added it to the metadata folder (though not sure I did it correctly).

When uploading the whole folder to my CiviCRM extensions and installing the extension, I'm getting omnipay - NMI as a payment processor in CiviCRM but when trying to do a contribution I'm getting an error "class '\Omnipay\NMI\DirectPostGateway' not found"

Not sure if I'm missing something or doing something wrong.
Any help would be appreciated.


texts: I want Theme developer to have admin access to WP but not civicrm, is that possible?

texts:
I am using WP, and I have a theme developer helping me with a few issues in a buddypress forum, and then I have another plugin developer I would like to help me with another issue having to deal with super security. Anyway, I don't want so many people having access to my civicrm database as they don't need to touch civicrm in order to fix WP or plugin issues.

Is there a way to limit WP admin access to NOT allow access to civicrm?

Thanks?
If not, does anyone know a developer who knows WP, Civicrm, Thrive Theme, and BPS Security? I tried a Civi911 developer and they couldn't help me with all these WP plugin/theme/forum issues.


texts:
I have installed the api csv importer

https://civicrm.org/extensions/api-csv-import-gui

I cannot find where the start page is.

I have looked in read me which says civicrm/csvimporter/import

However I get an error message CRM_Core_Config::$maxImportFileSize.

I had this problem once before and managed via google to find the answer. Frustratingly I did not write it down and now cannot work out how to get round this. Has anyone got any tips?
Thanks
Caroline


texts: Wordpress - Civicrm 5.16 upgrade to 5.30 issue - Notice: Undefined index query in /wp-content/plugins/civicrm/civicrm.php on line 483

texts:
When upgrading our site from Civi 5.16 to the latest 5.30, when I point my browser to run the upgrade at:
http://example.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/upgrade&reset=1
I get the to the update page, which has the following:
The database will be upgraded from 5.16.0 to 5.30.0.
Then long list of warnings about default copies of message templates etc.
At the end of this, when I click on the "Upgrade Now" button, I get this message and nothing else happens:
Notice: Undefined index query in .../wp-content/plugins/civicrm/civicrm.php on line 483
I'm running Wordpress 4.9. No our site is down and I need help to resolve this upgrade issue.


texts: Can i retrieve an event that i have deleted?

texts: I have deleted an event and would like to retrieve it back.  Is it possible to retrieve it?  Please advise how to do it. tks


texts: How do I prepare for Developer Training in Denver?

texts: I am signed up for the developer training in Denver.  What do I need to bring to the training? Is there anything I should study before the training?


texts: Not be able to set up Membership Type and Payment Type

texts: We want to build similar form as described here :https://glos.us/civicrm/profile/create?gid=15&reset=1 , into our new site here: http://manningmedia.net/glos/test/, We are not be able to show Membership Type and Payment Type fields on our new website, from where can we setup that ? to show it above the form.


texts:
There have been multiple instances of this situation in multiple installations of CiviCRM. Details for the incident that has prompted this post:

CiviCRM 5.16.2 on Wordpress 5.2.3
Using Firefox 69 and Edge (can't find version)

Attempting to record a refund to a contribution and when pressing "Record Refund", the CiviCRM spinner runs forever and the refund is never saved. Attempts to complete the transaction in Edge and Chrome also fail in the same way. Would appreciate some guidance on where to look for problems.


texts:
We created a report to list the contacts without a contactsubtype.
Previously, it worked, since a recent update it no longer works.
The report is based on a filter "contacsubtype is not one of" followed by a list of all contactsubtypes in use.
What has changed?


texts: CiviCRM Shortcodes button no longer shows up on Wordpress

texts:
The CiviCRM shortcodes button on WordPress is no longer showing up on my install and I cannot determine why.

What could cause this functionality to disappear?


texts: CiviCRM Fatal error: Uncaught CRM_Core_Exception: [0: Found installation canary

texts:
If you can advise or solve my problem – please answer

I trying to install CiviCRM 4.7.14 for wordpress 4.7 on windows machine, all steps of installation based on official CiviCRM installation guide.
After step where i setup database connection and click install i got at left panel icon civicrm how it must be,
but after click on this button I got error about non correct path in civicrm.settings.php, after fixing double slashes to single slashes “/” in this file and update page I got next error that I can’t solve

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

All requirements are fine and I do not got any warning or errors at step with install.

Thank you in advance


texts:
In the framework of setting up our Data Processing Register, could you kindly provide us with your Data Privacy Policy, please ?
Thank you


texts: Choosing Payment Method disables Continue/Contribute buttons

texts:
Running CiviCRM 5.12.4 and Joomla 3.9.5.
I am having a continuing problem with the Payment Method on paid events and registrations. We use Paypal and Pay Later on both profiles/events.
Paypal is the default. Leaving that without changing the payment option, the Continue/Contribute button works as expected. If you make any change to the payment options, the Continue/Contribute button gets disabled.
For online registration I created two profiles, one for Paypal and another for Pay Later. Ok workaround. For the event I cannot do that as we have a maximum number of attendant spaces.
I think this might be Joomla related as I found mention using Drupal, but the workaround doesn't fix the problem.
This is our first paid event and fixing this is critical for us. Any help or suggestions would be greatly appreciated.
Thanks.
Edit: The following error was noted when switching from Paypal to Pay Later.

TypeError: CRM.loadPage is not a function[Learn More] index.php:835:7
buildPaymentBlock https://www.rbsportsboosters.com/index.php?option=com_civicrm&task=civicrm/event/register&Itemid=1129&id=33&reset=1:835

<anonymous> https://www.rbsportsboosters.com/index.php?option=com_civicrm&task=civicrm/event/register&Itemid=1129&id=33&reset=1:839

jQuery 2


texts: What is Best Approach When integrating custom payment gateway to CiviCRM/Wordpress

texts: When integrating custom payment gateway to CiviCRM/Wordpress what is the best approach to use so that when you update CiviCRM to newer versions your payment gateway integration files will not be affected?


texts: What happens to Wordpress user accounts after Civi contact merge?

texts: If you have 3 duplicate Civi contacts each linked to a WP user account, how does a contact merge effect the related WP user accounts, if at all?


texts:
Can anybody tell me what this means? When creating a new event with the new release of City Mobile API, it gives you the option to turn on QR code generation for that event. However, it has a strange warning note that's really confusing, it reads like this:

When generating QR Code tokens, use this Event
If enabled, the QR Code for this event will be used (you can only have one event enabled at a time, enabling this event will disable all other events).

When I read this, it sounds like if I enable QR code generation for one event all of my other events will also be disabled (is that QR code generation disabled, or the event itself will be disabled and not active).

I guess I'm just really confused by this new feature and there isn't any documentation talking about its behavior. It would seem strange to me that you can only have one event at a time generating QR codes considering most organizations would have multiple events scheduled and open for registration at one time.

Anyone have any thoughts on this?


texts: Should Manage Groups display the Smart Group contact count, or just display it as Unknown

texts:
When I run Manage Groups, the Smart Group contact count comes up as Unknown for each group.  Clicking the Update Smart Group Counts link appears refreshes the group list, but still returns Unknown. This is after running the Refresh Smart Group cache job manually. CRM-21583 refers to this issue, but has been resolved as Won't Do as it seemed to have been related to an addin.  We don't have that addin in our Joomla systems, but still have the issue.

My question is whether Update Smart Group Counts is supposed to update the counts displayed in Manage Groups or whether CRM-21583 should be resurrected?


texts: How to display more than 100 as a search result?

texts:
When doing a search, and getting a result of more than 100, it is not possible to display all at the same page. It is only limited to 25, 50 or 100.

How can I display more than 100 search results on the same page?


texts: CiviDiscount "Specify api string for advanced filter"

texts:
I'd like to use CiviDiscount to create an automatic discount based on a custom data field on the contact record.

Looking at the options for the Automatic Discount, there is a field called "Specify api string for advanced filter" but when I put a value into this field and save, it isn't actually saved. I'm not sure if this is because the strong is wrong, or something else.

I was testing with a group value as this using the same advanced value that is used when creating contact reference fields:

action=get&group=532


texts: Recurring iATS contributions not creating civicrm_finanical_item records

texts:
We are ramping up for online donations and use the Accounting Batches CSV export to get our Civi contribution data into our 3rd party accounting software.  A key piece of data from that report is the 'Credit Account' column since that tells our accounting software which fund the donation should go to.

We've recently started testing Recurring Contributions.  The contributions themselves are being processed correctly via iATS (we've done credit cards only thus far).  However, we did our first accounting batch export with recurring contributions yesterday, and the Credit Account column is blank for all subsequent recurring contributions.  The one-time donations and the initial recurring contribution for a contact show the Credit Account correctly.

After looking through the database to see where the disconnect might be, it appears that recurring contributions are not creating records in the civicrm_financial_item table.  I can track/match a completed recurring contribution through the civicrm_contribution, civicrm_entity_financial_trxn, civicrm_financial_trxn, and civicrm_line_item tables.  The civicrm_entity_financial_trxn table has the recurring transaction records with civicrm_contribution in the entity_table column, but that table does not have a corresponding record for the transaction with civicrm_financial_item in the entity_table column.

I found iATS Github Issue 134, but that was specifically asking about Civi 4.7, so I don't know if the same issue would apply (I'm going to cross post there as well).  I also don't know if I might have setup things incorrectly in the backend for accounting, so that's a possibility as well (and I'm not sure what to look for there).

According to CiviAccounts Data Flow:

  IPN payment processors processing a contribution do NOT create
  civicrm_financial_item, civicrm_financial_trxn, or
  civicrm_entity_financial_trxn records at the time the transaction is
  posted to the payment processor. They are only created at the time of
  the IPN call back.

Since iATS doesn't use IPN, I didn't know if that might be the reason for the lack of records in the civicrm_financial_item table.  The other tables in the above quote have records for subsequent recurring contributions, so I'm not sure if this applies to iATS.

For the sake of our Accounting Export, I don't see a way in the database to get the Credit Account for a contribution (civicrm_financial_account.accounting_code) for a recurring contribution without a record in the civicrm_financial_item table.

Does anyone knows how to either a) correct the recurring contributions not ending up in civicrm_financial_item table or b) how to query the database to get the Credit Account without the financial item record?  I'd sure appreciate the help!

Civi 4.6.14 (will be updating to 4.6.20 before go-live); Drupal 7.44; iATS Payments extension 1.5.3


texts:
I was very excited to test out the new capability that you can batch update cases but I'm not sure I'm testing it as intended. I was hoping to be able to use it to close multiple cases at once. Here is what's happeneing:

Even though I can update the case statuses to a 'closed' status like "Resolved" it doesn't record an activity (with the date that the case was closed).
If I add the case end date to the profile, a undefined notice pops up on the batch edit screen and I can only select today's date. Notice: Undefined index: formatType in CRM_Utils_Date::addDateMetadataToField() (line 1878 of /srv/buildkit/build/dmaster/sites/all/modules/civicrm/CRM/Utils/Date.php).
If I do process the update with today's date, I don't see anywhere that the date is referenced (aside from being able to search by end date, I don't see a reference inside the case itself.)

I'm assuming I'm expecting too much (mixing capabilities)? It is after all technically updating the case status and date.

(While I am currently in Civi 5.5.3 - I verified this behavior is also on the dmaster demo site.)


texts:
We've been trying to make bounce handling work but with no success so far.

The fact is that it used to work setting a gmail.com email address as in this forum thread (see below), but all of a sudden it stopped working and it has nothing to do with opening port 993, because it was already open.

http://forum.civicrm.org/index.php?topic=33637.0

Server   imap.gmail.com
Username   xxx@gmail.com
Password        (triple checked against gmail account)
Localpart   xxx+
Email Domain  gmail.com
Return-Path   (empty)
Protocol IMAP
Source   (empty)
Use SSL?   Y
Used For?    Bounce Processing

When sending a test mail to wrong email accounts CiviMail counts them as correct addresses.

Any clues?

Thank you very much for you help


texts: CIVI-SA-2015-010: VERSION INFORMATION DISCLOSURE

texts:
The announcement of this security advisory (https://civicrm.org/advisory/civi-sa-2015-010-version-information-disclosure) does not provide a patch that can be applied, and examining the CiviCRM git repository of the new versions (4.4.20, 4.6.10) the change(s) made are not apparent.

Can anyone shed light on the changes made for this security advisory?


texts: custom field set with multiple years of data

texts:
We are on WordPress4.3.1, civi 4.4.1.

I want to be able to track multiple years of data related to a group of our contacts.  Would I set this up within custom fields, with date being one of the fields?

I will need to produce reports with the history.  The documentation says that I won't be able search for these fields.

Is there a way that I can do this from within civi? Thanks


texts: Bug with WordPress CiviCRM 5.10.3 Remote Profiles HTML Form Snippet Form Action URL

texts:
Version: CiviCRM 5.10.3

Type: Bug

CMS: WordPress

With the update to CiviCRM 5.10.3, I noticed the form action URL in the HTML Form Snippet generated for Remote Profile submissions has changed, breaking the form submission functionality for anonymous users with all newly generated HTML Form Snippets.

This is the first time I have noticed this bug, which was definitely introduced sometime after version CiviCRM 5.7.2, the last time I generated an HTML Form Snippet that was used with a Remote Profile.

Previously, the HTML Form Snippet generated code with a form action URL that posted to the "create profile" URL, allowing form submissions from anonymous users:

<form  action="https://wpmaster.demo.civicrm.org/civicrm/?page=CiviCRM&amp;q=civicrm%2Fprofile%2Fcreate" method="post" name="Edit" id="Edit" class="CRM_Profile_Form_Edit" >

After the update, the code generated by the HTML Form Snippet includes a form action URL that posts to the default "admin group":

<form  action="https://wpmaster.demo.civicrm.org/civicrm/?page=CiviCRM&amp;q=civicrm%2Fadmin%2Fuf%2Fgroup" method="post" name="Edit" id="Edit" class="CRM_Profile_Form_Edit" >

With the above form action URL, anonymous uses see the following error when the user clicks the "Submit" button:

    You do not have permission to access this content.

Manually changing the code in the HTML Form Snippet to use a form action URL with the previous "create profile" version restores the functionality.

This bug is specifically related to the generate HTML Form Snippet code as Profiles work properly for anonymous users when inserted using the "Add CiviCRM Public Pages" button within WordPress, which inserts the code that includes the correct "create profile" form action URL.

I tested both WordPress and Drupal 7 demo sites and was able to replicate the bug with ONLY the WordPress demo site:

https://wpmaster.demo.civicrm.org/
https://dmaster.demo.civicrm.org/

Steps to Reproduce Bug with WordPress CiviCRM 5.10.3+:

Login
CiviCRM > Administer > System Settings > Misc (Undelete, PDFs, Limits, Logging, Captcha, etc.)
For the "Accept profile submissions from external sites" option, select "Yes" and then click "Save"
Administer > Custom Data and Screens > Profiles
For any Profile, generate the code by clicking: more > HTML Form Snippet
The code generated by the updated version includes a "post" action URL to the "admin group"


texts: How will I maintain versioning of civicrm in github?

texts: I customized a civicrm. I want to put on github.I cannot maintain a mysql database versioning. How can I do that?


texts: How can I create early bird fees with Webform CiviCRM?

texts: In native CiviCRM I would do this with a priceset; how do I do this with Webform CiviCRM?


texts: How can I emulate a CiviDiscount when using Webform CiviCRM?

texts: I want the user to be able to type a Discount code into a field and then I want that Discount code (if applied correctly) to result in a reduction of their Membership Fees;


texts: Input in Memo/Rich Text Editor custom field results in error "There is a validation error with your HTML input"

texts:
When I try to submit an HTML link in a custom field of the type Memo/Rich Text Editor, in some cases I get the error message:

There is a validation error with your HTML input. Your activity is a bit suspicious, hence aborting

The input is a hyperlink in the most simple form:

Link text

What's especially strange is that there are more fields of the same type in the same form that accept exactly the same HTML syntax.

I found no difference between using TinyMCE and CKEditor.

CiviCRM version is 4.4.19.

Any clues highly welcomed.


texts: Can I use membership information in a mail?

texts:
We are using Memberships including some custom fields to save additional information (e.g. the name of a specific beneficiary supported through that individual membership).

Mailings through CiviCRM can include Tokens to insert contact-specific information like name and address. However, there are no tokens available for membership information.

I guess this is technically more challenging because mail is sent to a contact and a contact can have more than one membership. Is there some feature, extension or workaround to send mail "to a membership" or otherwise insert individual membership information in the text?


texts: Database upgrade fails updating to CiviCRM 5.22.1 to 5.28.3

texts:
We were still running CiviCRM 5.22.1 when Wordpress updated to version 5.5, which broke our donation pages because of changes how wordpress redirects.  I updated to CiviCRM 5.28.3, but the database upgrade fails - all I see is blank dashboard page an empty pair of brackets and a 'retry' link that does nothing.
Does anyone know how to fix this other than perhaps installing a previous version of Wordpress and CiviCRM 5.22.1 on a development server, importing the current CiviCRM database tables, upgrading to CiviCRM 5.28.3, then importing upgraded CiviCRM database tables to the live server?


texts: Can i used different Database on remote server for civicrm logging?

texts:
Is it possible? Used the different database on remote server for civicrm logging.
Means: Currently i am using two databases one for drupal and second is using for Civicrm. Both are on different remote server.  Now i want to create a third server for civicrm logging database. It is showing error "DB Error: no such database". I already configured in civicrm.settings.php file.
define('CIVICRM_LOGGING_DSN',mysql://myserverdetail);


texts: How can I update a particular activity/case via a webform?

texts:
Here's the use case:

A user submits reports via a webform on a frequent basis. Each time they submit a report the webform creates a new case, and populate a custom activity type with the data that is submitted.

From time to time the administrator may want the user to re-submit a report (they may have made errors or not reached the required standard in the original submission).

What I want to do is enable the administrator to point the user to a webform where they can see all of the data they submitted originally, edit it and upload new versions of required documents, which then updates the data stored in Civi.

Can I get the webform to present the correct submission data to the user, and if so, how?

I can pass in some parameters to the webform via the url (e.g. case client), but as the user is the client of all the cases they submit that's not going to be enough to identify a particular case.


texts:
I need members to be approved by admin before they pay their membership. How do i do this?

I have setup membership levels and created the contribution page but I can not find any option for approve member before payment process. Do I need to create a free member and approve them? but then how do the system sends payment after I approve them? Do you know if there is anything that I can setup to do that?


texts: how to automatically creates a relationship

texts:
Is there a way to automatically create a relationship if 2 or more address in the DB is exactly the same?

I want to create the relationship if two or more people are living in same house.


texts: Create Report Showing The Notes Created for Organisations

texts:
I want to create a report that shows the most recent note that has been created for each organisation. When I looked at modifying one of the existing reports, I could not find in any of the reports, the option to include the standard notes field. Have I missed it or do I need to create a custom report?

I know I may be able to achieve this through Drupal Views but would rather create a report if necessary.

(I am using version 4.7.28)


texts: Can webform be used to terminate one Case Role and create a replacement?

texts:
Scenario:

A case has a Purchasing Partner role. Sometimes that needs to be changed and we want to do so via a webform (from a View with links containing whatever cid1 etc it needs).

My testing shows that if I try with just the cid1 (who is case client) and cid2 (who is existing PP) in the url and add a third cid for the new partner, when we submit the form we hope it will

terminate the Relationship between cid1 and cid2 (which seems to be how I can do this on a contacts record directly in civi itself and the only way i can approach this on the webform since there is no option to eg specify 'remove existing case role') and
create a Case Role for cid 3

the outcome is that

the original relationship between cid1 and cid2 remains untouched, and a new disabled (due to End Date) relationship is created between cid1 and 2
a new case role and relationship is created for cid 3

Should we be able to do this as webform code stands? Does adding the caseid=x help (i did test that but saw no difference)


texts: Check Payment processor is not working for CIVIEVENT

texts:
I am having an issue with my Check Payment Processor.
I am trying to setup the Check Payment method as a default payment processor for the registration of my events.

I have set only check as a payment processor. There is no other payment processor added yet. But when I try to register myself for the event, it asks me to add the credit/debit card option for the billing.

I have also set check payment as a default payment option.

Thanks in advance.


texts: Search on custom 'Yes or No' fields appears broken in 4.6.6

texts:
I've just updated our dev civicrm installation from 4.5.4 to 4.6.6.
Now, searches on custom fields of type 'Yes or No' are producing weird results.

Eg, In a custom dataset for some specific membership types we have a variety of Yes or No fields.
The database appears to have the correct data in it as compared between our updated dev and our live sites.

However, in the dev site, a search of memberships for 'display on website' produces 93 results for Yes, 93 for No and 93 for 'Yes or No'!! There are 861 results in the db according to phpMyAdmin!!! Yikes!

On the live site, the same search yields 892 for Yes, 91 for No and 983 for 'Yes or No'. There are 901 results in the db table according to phpMYAdmin. (The diff here could be some contacts are deleted, also we don't expect the dev site and live to be exactly the same.)

I've done the same membership search on a variety of custom boolean fields and they all show the same very weird results on the dev site; the same number for yes, for no and for 'yes or no'. In the db the field has many, many more results than the membership search.

Any help on this would be much appreciated!


texts: Upgrading from 4.7.12 to 5.1.2 on Wordpress

texts: Its been a while since we performed and update on our site. Would there be any issues upgrading to the latest version from such an old version?


texts: Path problem for webhooks and other internal resources

texts:
I suddenly have a path problem on one of the sites I look after. I just updated to Civi 5.28.3 and wordpress was already at 5.5. I can't swear that the problem occurred because of the upgrade though.
The problem manifests itself when some URLs are built. I can see it in the webhook paths (missing the host and directory path):
Stripe Webhook missing or needs update! Expected webhook path is: ?civiwp=CiviCRM&q=civicrm%2Fpayment%2Fipn%2F4

and I have noticed the same behaviour for various placeholders in the Mosaico extension when i use the inspector to look at the code sent to the browser.
I looked at the resource path settings and they all look ok and are a match for the same settings on a working civicrm site I have.

I have done a slow scroll through civicrm.settings.php, but have seen nothing that seems concerning. The site was seemingly working last week before the upgrade. I suppose I could roll back, but I'd rather not if I can simply find where the path is being set and fix that.
Any thoughts?
UPDATE:
I have, as suggested followed the threads in the post linked below, but all of my paths report correctly when viewed in the admin settings pages (see above) or when queried on the command line:
root@kaos01:/var/www/civi.sitename.org/wordpress# cv path -d [civicrm.files]
/var/www/civi.sitename.org/wordpress/wp-content/uploads/civicrm
root@kaos01:/var/www/civi.sitename.org/wordpress# cv url -d [civicrm.files]
"https://civi.sitename.org/wp-content/uploads/civicrm"

I have also explicitly set the civicrm.files path and url variables in civicrm.settings.php
$civicrm_paths['civicrm.files']['path'] = '/var/www/civi.sitename.org/wordpress/wp-content/uploads/civicrm';
$civicrm_paths['civicrm.files']['url'] = 'https://civi.sitename.org/wp-content/uploads/civicrm';

Certainly, it seems clear that the URL string is missing when needed, but I can't figure out where else to look.
I have now discovered the problem on a second site.
FURTHER UPDATE:
Though the problem is occurring in multiple places I'm focussing on the STripe plugin as it makes it very visible. The MJWshared extension uses CRM_Utils_System::url to assemble the needed webhook url. it seems clear that CRM_Utils_System::url is not finding the base part is needs, but it is not clear to me how that function goes about finding the bits it needs.


texts:
Dedupe rules are cool, and works well for Individuals, primarily because you have multiple fields to combine.

When it comes to organisations it is more difficult. We focus on individuals but want to register the organisations they work for, so in the profile we use for most on-line registrations (events, subscriptions, ...) we ask for organisation name.

This often leads to multiple organisation records with almost the same name. Typical name variations are

Somecompany Inc.
Somecompany International
Somecompany

Dedupe rules are of limited help here since the best I can do AFAIK is the length of the match.

In Sweden a very common pattern is

Ericsson
Ericsson AB

I would be extremely happy if there was a way to match the full length except for the last three characters... Or if the match was true if the shorter is a true substring of the longer. Documentation is kind of flakey here, it doesn't say anything about what happens when fields are of different lengths.

Another alternative would be to match to either to the organisation name or the legal name. This would handle most of the above cases and allow me to use the names as (I suppose) they where ment to be used, causal name vs. official/legal/full name.

Actually I have a hard time figuring out how to make the best use the 'length' part of dedupe rules. (I'm a regex guy, so I'm longing for a LIKE-like option, is there one?)

Any suggestions?


texts: Install error when generating a new extension module

texts:
I'm trying to generate a new extension module following instructions from the docs: https://docs.civicrm.org/dev/en/latest/extensions/civix/#generate-module
However, when I run the proposed command to generate the skeletal extension

$ civix generate:module "com.example.myextension" --license=AGPL-3.0

I get the following:

Initalize module com.example.myextension
Write com.example.myextension/info.xml
Write com.example.myextension/myextension.php
Write com.example.myextension/myextension.civix.php
Write com.example.myextension/LICENSE.txt
Write com.example.myextension/README.md
Write com.example.myextension/images/screenshot.png

Refresh extension list for "http://localhost/compucorp/"
Enable extension (com.example.myextension) in "http://localhost/compucorp/"? [Y/n] Y
Enable extension (com.example.myextension) in "http://localhost/compucorp/"
Install error: Unknown extension: com.example.myextension

The extensions directory is created on the root of the CMS (Drupal), and the new extension directory com.example.myextension is created successfully and seems to have right permissions.
What can be the problem?

I tried refreshing extensions list from the user interface of CiviCRM and the newly created extension does not appear on the list.

Thanks!


texts: Can I use different financial types for membership registrations and renewals without losing functionality?

texts:
This page
http://book.civicrm.org/user/current/contributions/setup/
mentions

  Be careful when editing core Financial Types or adding new types,
  because CiviCRM has useful built-in functionality that depends on the
  core Financial Types.

Does anyone know more details ?

More concrete question: my client uses different accounting codes for membership registration and membership renewal. Can I use a different financial type for membership registration (other than 'member dues') without losing functionality ?


texts: Paypal standard IPN not updating event participant status or fee contributions

texts:
Just wondering if anyone is aware of a bug or any reason why Paypal Standard IPN notifications have suddenly stopped updating our event participant status to registered and the associated contribution record to complete?

I can see the IPN from Paypal hitting the server in the access logs and it is receiving a '200' status.

The IPN history in Papyal shows everything ok.

I can see the entry in the civicrm table in the database.

Everything seems to be fine apart from the fact that the participant records are not being updated to registered and the contributions are still showing as 'Pending transaction'?

It seemed to stop only a few weeks ago - not 100% sure but I did upgrade the system to the latest 4.6.18 version around the same sort of time.

Any thoughts would be welcome.

Cheers,

Dave


texts:
I have a volunteer profile set up and it's working just fine. I need to send an email response with additional info to users who sign up.

I can't find any info on how to do this. Any help appreciated.

Thank you!

PS: Running Joomla 3.4 and the latest version of Civi
Edit: The profile in question was created by >>> Administer>>> Customize Data and Screens >>> Profile. It's run as a mailing list and stand-alone form on the site.

I did not use CiviVolunteer Extension although I do have it installed.


texts: Can't create new mailing. Just stop on “Initializing…”

texts:
I am running CiviCRM 4.7.13 with Drupal 7.52. We are using php 5.6.23.

When selecting "New Mailing" from the "Mailings" menu, just the message "Initializing... " displayed. Any suggestions ?
Thanks for your help.


texts: Is there any way to archive reports in CiviCRM so they are still available but no on the long list of reports?


texts: Menu problem when web host upgraded from CPanel to Site Tools

texts: Recently, my host provider Siteground upgraded the back-end of my site from using a classic CPanel to the new and improved Site Tools. Upon the upgrade, the main CiviCRM 5.34.0 menu no longer appeared in my Drupal 7.78 instance. Also, icons with ? showed up as unknown boxes. After getting assistance at chat.civicrm.org, the problem was solved...


texts: Change the default fields (columns) in contact search results

texts:
Very frequently I get users asking if we can remove Address/City/State/Postal/Country columns from the default search results table. Often they want to show some of our custom fields instead. Or to just remove clutter.

I know this is a common question, and I am aware of hook_civicrm_searchColumns and how to use profiles with advanced search.

But I am asking here to get verification that there is not a better way to simply remove some columns from the results of civicrm/contact/search


texts:
Is there a CiviCRM extension that supports the moneris payment gateway?

Thank you


texts: How to delete addresses (and only addresses) for multiple contacts?

texts:
I have a bunch of contacts with two addresses. Each of their addresses is a different type (home, main, billing, etc). For these contacts, the billing address is primary.

I'd like to delete the billing addresses from the system and have the remaining address for each contact be left as the primary address.

I know how to do this one-by-one, but with more than 1,000 records to do I'd like a way to automate this. I have ID numbers for every contact that needs this change. Any ideas?


texts: How can I find contribution pages or membership pages where Profiles are used?

texts:
I can see a list of all custom profiles
It says

Name: Membership Details
Type: Membership::: : : : : : : : Teaching Member-EATA
ID:   13
Used For:   Standalone Form or Directory

When I click on Find Members link from civicrm menu
i.e. https://www.example.com/civicrm/member/search?reset=1

In the image(of Find Members link given above) below I can see CTA Member,Teaching Member,Teaching member EATA as profile fields in member search link given above.
But I need to find where is this profile used in
like a contribution page id 24 or something else
Is there anyway I can to find out ?


texts:
I'm creating a Contribution Report, Contribution Details. I include check the boxes for both Date Received and Receipt Date. The results for both include the time as well as the date. When I export it to a CSV file, there's the Time tagged on. In my Excel file, the Time lurks. Formatting the column doesn't delete the data but merely hides it. When I create a Merge Document in Word, the time appears and I can't delete it.

I don't want the TIME. Anywhere!

I have gone under Administer, Customize Data and Screens, then to Date Format and deleted the Time codes and left the Day, Year and Month codes. And I've gone to Administer > Localization > Date Formats and deleted the various codes various Time - and SAVED. Returning to those screens shows that Time is turned off.

What can I do to delete Time from my report?

Peter Keller


texts:
After upgrading to 4.7.10 from 4.7.9, I'm no longer able to edit/add price sets.  I think that the DB changes related to https://issues.civicrm.org/jira/browse/CRM-12252 are biting me.  (Multi-lingual is enabled.)  I don't recall any problems with the upgrade.  However, now the DB error says:
    [debug_info] => UPDATE civicrm_price_field_value_en_US SET is_default = 0 WHERE  price_field_id = 27 [nativecode=1054 ** Unknown column 'help_pre_en_US' in 'field list']

I can reproduce this same error by editing any field for any record in the civicrm_price_field_value table and the civicrm_price_field_value_en_US view via phpMyAdmin.  The field does exist,  I've recreated the View, and dropped the column and recreated it. Other _en_US tables are unaffected.  (Yes, I've cleared CiviCRM caches, and run commands in Private windows to try to get away from cache poisoning.)

This is happening after the upgrade, with new data since the pre-upgrade backup on a live server.  Rolling back isn't really an option.  There must be something that needs to be refreshed, but I can't find it.  Any ideas?

Wordpress 4.6
CiviCRM 4.7.10

Another bit of weirdness that points toward a failed DB upgrade:  The COMMENT portion of the two new fields is not there, but both fields are decidedly there.


texts: "Failed to authenticate key" when posting to REST api

texts:
I used the API explorer to create a target url, but I cannot send a GET request with curl. The error is: "Failed to authenticate key".

Here are the steps I am following:

Create an url in the API explorer:

http://51.15.94.180/wp-content/plugins/civicrm/civicrm/extern/rest.php?entity=Contact&action=get&api_key=userkey&key=sitekey&json={"sequential":1}

Looked up the site key in civicrm.settings.php (under CIVICRM_SITE_KEY)
Used the "API Key" extention to add an API key to the "admin" contact (the one that is associated with the civicrm admin account).
I inserted my keys (which I change here for security reasons) to produce this expanded url:

http://51.15.94.180/wp-content/plugins/civicrm/civicrm/extern/rest.php?entity=Contact&action=get&api_key=uCMXIUhzpPv&key=VKtUrOkd&json={"sequential":1}

I curl this url, and get the mentioned error

Can anybody help?

UPDATE

I was able to stick a debug log statement into the authenticateKey function of System.php:

CRM_Core_Error::debug_var("req", $_REQUEST);
CRM_Core_Error::debug_var("req size", sizeof($_REQUEST));

The result of this is:

Mar 21 11:49:21  [info] $req = Array
(
    [entity] => Contact
)

Mar 21 11:49:21  [info] $req size = 1

So it seems only the first key/val pair of the request is received in _REQUEST. How can this happen?


texts: New install on WP 4.7.4, CiviCRM 4.7.18, System Status: Error

texts:
I am a newbie to CiviCRM. I have installed CiviCRM 4.7.18 on WordPress4.7.4 and it failed.
The db password for CiviCRM and wp admin password does not contain any special character.
Everything on installation page was green with green checks.
After I pressed "check requirements and install", I did see successful installation message then the page redirects to
/wp-admin/?page=CiviCRM&q=civicrm&reset=1
And I see the following:

CiviCRM Home
System Status: Error
Cron Not Running
Configure Default Mailbox
Complete Setup
View details and manage alerts
Configure Your Dashboard Refresh Dashboard Data
Welcome to your Home Dashboard
Your dashboard provides a one-screen view of the data that's most important to you. Graphical or tabular data is pulled from the reports you select, and is displayed in 'dashlets' (sections of the dashboard).
Access Keys:
Powered by CiviCRM 4.7.18. CiviCRM is openly available under the GNU AGPL License.
Download CiviCRM.     View issues and report bugs.     Online documentation."

Using my backup I made before installing CiviCrm I have tried again this time I changed permission for civicrm and files folder to 777 from 755, thought that was the problem.

Create the /wp-content/plugins/files/ directory and ensure it is writable. CiviCRM uses this directory for temporary and uploaded files. (Source: https://wiki.civicrm.org/confluence/display/CRMDOC/Installing+CiviCRM+for+WordPress#InstallingCiviCRMforWordPress-2.WordPressInstalled)

Since I have a backup I can restore to and also delete and re-create sql db/user, I do not mind going at it again, but I think I might be missing something and it's better to know what and try again with the possible solution.
Any help/suggestion is appreciated.
Thanks,
Usman


texts:
I am really finding it difficult in creating an extension in CiviCRM.

I just want to create a section in contacts Called DSearch like , when we click in contacts we get differeent sections like Address , Notes, Communication Preferences etc.


texts: How to show Days in Case in Drupal Views?

texts:
Trying to create a Drupal View that shows total number of days in a case.

There are two methods I'm considering:

First, I imagine if I could turn the case start date and end date into "Days Ago" within the view I could perform a math calculation of [end_date]-[start_date] to get the number.

The other method I thought may work would be to create an aggregate table through views that displayed a daily case load.  For example, on 1.1.15 list these 5 people that have ongoing cases.  On 1.2.15 list these 5 people that have an open case.  From there, I could group by contact name and count.

Anyone have any ideas or done something similar?


texts: Who can develop payment processor for Bank of America Merchant Services

texts:
Would anyone be able to develop a payment processor for the latest CiviCRM version to work with the Bank of America Merchant Services? Can you provide a quote? We're using Joomla but I believe most/all of the payment processors are CMS-agnostic.
(Sorry if this is not the forum to ask this question - happy to take it elsewhere ;-)
Thank you


texts: Dead links on events, donations, pretty much anything I create

texts:
I'm in the middle of an install and stuck on a couple issues.
I've been all over this StackExchange yet I can't seem to make basic CivicCRM links work in a couple of sections in the site I'm trying to deploy.

CiviCRM 5.27.0 running on Wordpress 5.4.2 on top of Ubuntu
Yes, my WP permalinks is set to "post name"
yes, I have an .htaccess and it looks like this:

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>

yes, Apache is set up to obey that .htaccess for this site

yes, my Administer -> System Settings -> CMS Database Integration is set, and it's set to https://crm.[siteiamdeploying].org/civicrm/

yes https://crm.[siteiamdeploying].org/civicrm/ is a page that exists and loads

... yet when I do things like:
a) Create an event, flesh out its details and see links like
TEST: https://crm.[siteiamdeploying].org/event/register/?reset=1&action=preview&id=98
LIVE: https://crm.[siteiamdeploying].org/civicrm/event/register/?reset=1&id=98
Or, for example, set up a DONATE page and then attempt to load that page by doing
Civicrm-> manage contribution pages -> set up a contribution page ->
... then use that pages "links -> Live page" or "links -> Test page" links to try and load those pages, i.e.
https://crm.[siteiamdeploying].org/civicrm/contribute/transact/?reset=1&id=4
... all I get on those links is the default WordPress "not found" page, i.e.
"Oops! That page can’t be found.
It looks like nothing was found at this location. Maybe try a search?"
And I can see these  404'ing/ erroring out in the Apache access logs like this
67.160.XX.XX - - [06/Oct/2020:02:15:54 +0000] "GET /civicrm/contribute/transact/?reset=1&id=4 HTTP/1.1" 404 60939 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:81.0) Gecko/20100101 Firefox/81.0"
Can somebody point me in the right direction and/or towards sensible debug logs or processes before I start throwing heavy things at my monitor?


texts: Send certain welcome message after subscription to certain mailing list

texts:
I think this is an obvious feature, but I can't find it anywhere.

I can set several custom "Welcome" Automated Messages but I would like to be able to assign certain custom "Welcome" automated messages to be sent after a user signs up for a certain mailing list.

For example:

User signs up for mailing list "dogs" and in the body message (sent after successfully double opt-in) is "Thanks for subscribing to Dogs!". But if the user subscribes to "cats" the message is sent containing "cats" in body text.

I've tried using CiviRules, but Civirules is not respecting double opt -in. It sends e-mail even if user won't confirm subscription.

Has anyone figured it out?


texts:
How would you recommend checking in participants (who have previously registered) at events so that those who attended have participant status changed from registered to attended? (And then, likely in a second step, those who didn't show have participant status changed to no-show). This seems so obvious- but I can't find it in the Civi documentation.

My thought is to use an advanced search with event name= [name], role = 'attendee' filters. After people have been checked off names when they come in to the event, use the 'update multiple contacts' feature. I created a profile with the field 'participant status', but it doesn't show up in the 'update multiple contacts' profile drop-down...and I'm wondering if this is even the best way to do this? Non-developer, just a user here. Thanks!


texts: Allowing users to update information without logging in

texts:
I have now followed all the instructions in the CiviCRM Cookbook (https://www.packtpub.com/web-development/civicrm-cookbook) as well as a similar post here on Stack (allow anonymous users to view profiles in WordPress?) but had no joy getting the URL right to get people to update their profile without having to log in.

The instructions state the following:

Using the CiviCRM checksum token in combination with a profile allows you to bypass the requirement to log in.

Create a profile you wish to use. The profile contains all the fields of information that
you want the user to complete.
Make a note of the profile ID.
Enable Profile Listings and Forms access for anonymous and authenticated users
in your CMS.
Now create a CiviMail mailing in the normal way.
You now need to use the {contact.checksum} token and the {contact.
contact_id} token to construct a link back to edit the profile you created:
http://www.myorganization.org/civicrm/profile/
edit?reset=1&gid=N&id={contact.contact_id}&{contact.checksum}
Substitute your website for http://www.myorganization.org.

Perhaps there was a print error in the book because I have tried numerous variable options to get this working without joy.

Any thoughts? Thanks

EDIT: Added example below.

https://crm.example.com/civicrm/profile/edit?reset=1&gid=1&id=2798&5fb7dfc93d6b855d75659da64805ac82_1503574955_179


texts: Civicase Dashboard - reordering case types

texts:
Running Wordpress 4.3 , and Civi 4.6.8.

My organisation currently has around a dozen Case types, and we will soon have more.
In the CiviCase Dashboard, these are listed under "Summary of Involvement" Table.
We would like to re-order the table to make it more logical for users to find the right one. The same issue applies to the Case Type Drop down when creating a new case.

My primary issue is - Can anyone suggest the best method for reordering these case-types?

Currently I cannot understand any logic to the order the they are listed - not by the order they were created, nor alphabetically, and not as i tried, by changing the 'weight' field as found in the db. (What even is this used for?)

Thanks


texts:
In CiviCRM > Administer CiviCRM > Display Preferences (/civicrm/admin/setting/preferences/display?reset=1) there's a Configure CKEditor button that does nothing.
CKEditor is stripping out certain style declarations. I want to be able to have simple declaration for adaptive images and the system won't let me.
Any ideas? Thanks in advance for any help...


texts:
I am trying to export about 2000 contacts (exporting primary fields only) and when I click continue I get this error:

  Sorry but we are not able to provide this at the moment. DB Error:
  unknown error Return to home page.

Not sure why its occurring and how to find out more info?

Thanks


texts: How to set a constant value for a field in webform (eg the prefered language)?

texts:
I'm creating several webforms in different languages to let people register to receive more information. I would like to set their preferred language to the language used in the form rather than the default (en_US).

I have similar needs for some custom fields.

How can I do that?


texts:
Working on custom enhancement, two text fields Parent and Child field.

Existing:-

Parent autocomplete - lists all existing contacts
Child autocomplete  - list all existing contacts

Required:-

Parent autocomplete - lists all existing contacts
Child autocomplete  - Parent specific

Using:- addEntityRef

 $form->addEntityRef('parenttwo_id', ts('Parent Contact'), array(
                    'placeholder' => ts('- select or create contact -'),
                    'create' => 'Parent_profile',
                    'api' => array('params' => array('contact_type' => 'Individual')),
                  ), FALSE);

 $form->addEntityRef('parenttwo_id', ts('Child Contact'), array(
                    'placeholder' => ts('- select or create contact -'),
                    'create' => 'Child_profile',
                    'api' => array('params' => array('contact_type' => 'Individual')),
                  ), FALSE);

Can't do below method because contact id must be dynamic one,
Means on searching of child contact field must lookup the relationship and fetch parent1's children.

 'api' => array('params' => array('contact_type' => 'Individual', 'contact_id' => '123123')

Can't do through simple textfield and ajax request because for contact creation profiles are being used.

Any other method available which can be used for this case?


texts: Can the External ID have multiple values

texts:
I would like to add multiple values in External ID.  Is this possible or would I have to create a new custom field?

Example
2 Duplicate contacts have different external IDs.  I want to merge them but keep both external ids.

Thanks


texts:
I'm setting up an association website integrated with CiviCRM (used for membership management among other features).

The wordpress site is a multisite install: a main site, where CiviCRM is active and showing, and a ecommerce subsite where CiviCRM is active but not showing (using the CiviCRM admin tool).

On the main site I'm using capabilities associated with membership types. For example, membership type 1 adds automatically to wordpress users the civimember_1 capability. Then I use this capabilities to restrict access to some special pages where only active members should be authorized to see.

While on the main site it works great, on the subsite dedicated to the store, those capabilities are not showing. There are a couple of civicrm-related capabilities showing on the groups plugin, but the membership-related capabilities don't and therefore I can't restrict some articles to active members.

How can I do in order to have the civicrm capabilities also on site 2?

From what I read I'm not interested in a multisite CiviCRM as different domains don't mean different groups or organisations, I just want CiviCRM to communicate specific capabilities to all my wordpress sites (they are using the same DB, of course).

Can anyone help?

Cheers
João


texts: How can I add login and registration page for members with civiCRM?

texts:
I would like to have registration and login page for my clients.by defining user and password and selecting their city.
Now I using Theme My Login plugin for registration, but I want to do this without using plugins? Is it possible? If yes how Can I do this?


texts: What's the recommended way to handle redirection after quickform submissions?

texts:
I often find myself writing calls to CRM_Utils_Redirect in my postProcess methods.

But in core code I don't see this. I see the use of methods like $session->replaceUserContext and postProcess functions that end seemingly without telling me where to go next.

I feel like CiviCRM is often clever enough to go to load different pages on form submission based on where you came from. I have no solid proof of that but lets give Civi the benefit of the doubt on that one :)

I'm guessing there is a structure somewhere that is telling CiviCRM what page to load next but I have failed to spot what that is.

I'm interested in the canonical way that CiviCRM does this (if there is a canoncial way) and knowing how legacy that is, and also what I should be doing.

If anyone could enlighten me, I'd be grateful :)

PS. I am not so interested in "you should write that in angular" enlightenment, at least not in the answer to this question.


texts: How to get rid of Â when exporting report to CSV file. running report


texts: How to display remaining available spots for an event on the public page

texts: We need to display how many spots are left for registration on the public event registration page. Is there a way to do this?


texts:
We have a multisite on WP that shares one db.

I am unclear if some settings are universal or if some are unique to each site. I'm referencing: administer > administrative console > configuration checklist.

So for instance, do I need to configure search or display settings for each site or will they inherit the network level site? And also for things like recaptcha and USPS address standardization.

Thanks!


texts: Update Indices fails with errno 150 on DROP INDEX UI_case_contact_id after upgrade from 4.6 to 4.7.27

texts:
Upgraded from 4.6.19 to 4.7.27 (on wordpress 4.8.3) and attempted to update indices.  The table that fails is civicrm_case_contact, with the old index UI_case_contact_id.  The error is identical to that reported in this question https://stackoverflow.com/questions/1451042/mysql-error-when-dropping-index-errno-150
There are a number of possibilities listed in the answers to that, but I'm a SQL newbie and the data structures should be familiar to developers following this forum.  Any ideas on what's the likeliest cause?
In our application we have not encountered cases and the table is empty.  Would it be best to disable CiviCase and delete relevant tables?  Or is that asking for more trouble?


texts: Why does From Email address '1' retain FIXME as its name in the db

texts:
On 4.6.4 I recently spotted a client where a Scheduled Reminder was be sent using  From Address = 1
In the UI this was clearly correct ie it had the clients email in it. But they were arriving in inboxes from FIXME.
Checking in the DB there is a Label field (which is all that is visible in the UI) and a Name field.
Should the Name field be being updated to match the Label when one saves? If not is my system incorrectly using the Name rather than the Label when sending out emails?
If not should the Name field be editable in the UI


texts: CiviEvent: Limitations for workshop as part of a conference

texts:
I created an event for a conference. The conference consists of a gernal part for every participant AND of workshops/panels with limited number of participants (each workshop/panel with its own limitations).

So I would like to
1) let participants chose which workshop/panel they would like to participate and
2) set those limitations so a workshop/panel will be set to "fully booked" (or something else) so only registrations to the waitinglis or no further registration for this whorkshop/panel will be accapted.

I know how to do the 1st part.
How to set up the 2nd part? I would be happy for any idea.

Thanks,

Zenon


texts:
I am importing contributions from my donors from a .csv file. I have tested the process using a simple .csv file with one row of data for a payment from a donor I have already added to contacts. The import was successful, matching the contribution to the donor. When I try to repeat this process using a spreadsheet with approximately 40 rows of data (including multiple contributions from some donors) all rows of the spreadsheet fail to import and have the error message 'Expected one Contribution but found 2'. I am using the email address to match to contact.

Any ideas what I am doing wrong?


texts:
I'm trying to use the Civi class to debug an extension with build kit,
but after I add this line:

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

to my class I get:

ampuser@58e3a823b9ee:/opt/buildkit/build/dmaster/sites/default/files/civicrm/ext/api4$ phpunit4
PHP Fatal error:  Class 'Civi\API\V4\Civi' not found in /opt/buildkit/build/dmaster/sites/default/files/civicrm/ext/api4/Civi/API/V4/Action.php on line 117

I feel like this ought to work out of the box... am I doing something wrong?

This feels like a variant of this and this question ... but different in that I'm looking for the pattern to call a core class


texts:
Yesterday I prepared a Mosaico mailing for approval. Today I was going to send it. But when I go to the mailing page, I get this error: "Mosaico cannot be displayed because this system does not meet all requirements. For details, check the System Status."

System Status has this warning:
"Graphics driver not available
Mosaico requires a graphics driver such as PHP-ImageMagick or PHP-GD. For more information, see Mosaico Settings.
Error: Failed to locate Mosaico graphics driver. Either "mosaico_graphics" is invalid or the autodetection failed."

Mosaico Settings gives me no options or useful information, which is weird:

I'm running on PHP 7.2, and my host's PHP extensions include ImageMagick for 7.2.

I have made no changes or updates to Civi or the host in the past 24 hours, so I am baffled as to what has broken Mosaico, but I need to get this mailing out ASAP!

Any advice out there?


texts: How to inherit data from Organization to contact?

texts:
I want to inherit custom fields from an organization contact to an individual contact with a relationship.
I'm asking if it's possible to do that or not.


texts: Upload of large files with ckeditor and imagick takes very long time

texts:
I have a custom text field where the user is allowed to link text with uploaded files via ckeditor (respectively kcfinder). Currently the upload of files does take a very long time. It's not a network issue because the actual request is sent after a few seconds. There seems to be an additional step afterwards, which delays the response for minutes (e.g. for a file with size of 4.7MB):

If I upload the file via a standard upload input (non ckeditor) the request is finished in seconds.

Here are some details about the request:

Using CiviCRM 4.7.23 with Drupal 7.56 on CentOS with Plesk, Apache and FastCGI.

I do not have this issue on my local dev machine, only on this server.

What could cause this delay? Are there any relevant CiviCRM or server settings?

UPDATE: After adding some error log calls including the current timestamp I could face down the function, which is causing the delay. It is $img = image::factory($this->imageDriver, $file['tmp_name']); where $this->imageDriver has the value imagick. It seems that the creation of the imagick object is taking way to long (the following image tasks are done quickly). Any idea what could cause this?

After disabling imagick and using gd instead the upload is finished in seconds.


texts: CiviCRM Installer doesn't find language files

texts:
I am trying to install CiviCRM 4.7.8 on WordPress 4.5.2.

I uploaded the l10n and sql folder to the civicrm folder, but the installer only offers "English (United States)" as an option for "Language of basic data:" :-(

I spent many hours to get this working, without any success :-( Is it a bug of CiviCRM???


texts:
Someone knows or has made some integration between Facebook Lead Ads and CiviCRM?

I'm looking for a custom integration as described on https://developers.facebook.com/docs/marketing-api/guides/lead-ads/


texts: Why do the contribution page amount labels now appear before the amounts?

texts:
All of a sudden in 4.6, contribution pages using the regular "fixed contribution options" (i.e. not using a price set) display the options as:

Donor - $25.00
Supporter - $50.00
Champion - $100.00

and so forth.  This is a sudden change that a client pointed out--the options used to appear as:

$25.00 Donor
$50.00 Supporter
$100.00 Champion

Both are reasonable, but does anyone know why it changed after working this way for years?


texts: CiviMail Mailing List opt-in checkboxes?

texts:
We're a political organisation running CiviCRM 4.6 looking to make public campaign pages about local issues.

On these pages a site visitor should be able to:
 - Enter their name, postcode, email address
 - Often fill out a personalised message
 - Opt in to a mailing list on this campaign

With all this data being stored in Civi.

This feels like a CiviPetition, although I am struggling with the implementation.

Is it possible to have a checkbox in a CiviCRM Profile/Webform that, if selected, will add someone to a Mailing List Group?

I assume something is possible with Rules but I do not want to have to make custom rules for each webform. Trying to make creation of new petitions/campaigns as easy as possible.


texts: Membership Management Customization: Assessment Sign up

texts:
Member sign up
I want a process that allows for association members to apply for membership, register and submit documentation related to their certifications .
These then need to be assessed and approved by administrators

Can the CiviCRM system accommodate that?

Regards
Andrew


texts: CiviVolunteer error after upgrade to Civi 5.11.0 on joomla

texts:
Running civicrm 5.11.0 with CiviVolunteer on joomla 3.9.5 PHP 7.1 (as well a second site with the same problem on PHP 7.0)
I am running API v4 version 4.3.0
CiviVolunteer 4.7.31-2.3.1

Since upgrading from civi 5.10.0 to 5.11.0 I receive the following error when running the Volunteer Report.

Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
DB Error: unknown error
Return to home page.

From the error_log file:
[28-Apr-2019 22:08:34 America/New_York] PHP Warning:  Declaration of CRM_Volunteer_Permission::check($permissions) should be compatible with CRM_Core_Permission::check($permissions, $contactId = NULL) in /home/[my account]/public_html/media/civicrm/ext/org.civicrm.volunteer/CRM/Volunteer/Permission.php on line 151


texts: DB Error: no such field on Profile/Page link

texts:
I'm making a public members directory using using Civi 4.7.6 on Joomla! 3.5.1. Member profiles includes 3 small sets of custom fields. One of those sets is  multivalue (civicrm_value_certifica_es_pmi_4) and other one includes a file field (foto_16). Everything is going fine until I added both a file AND an entry to the multivalue field and tried to drill down to the contact individual page from the directory/profile listing page. Then, I got a DB Error and looking at the Log I saw the following:

  [debug_info] => SELECT foto_16 FROM civicrm_value_dados_pessoais_2
  where entity_id = 563 AND civicrm_value_certifica_es_pmi_4.id = 3
  [nativecode=1054 ** Unknown column
  'civicrm_value_certifica_es_pmi_4.id' in 'where clause']

It looks like (I'm not a DB pro...) the SELECT is trying to use two tables (civicrm_value_dados_pessoais_2, civicrm_value_certifica_es_pmi_4), but only one (civicrm_value_dados_pessoais_2) was loaded in FROM statement.

Does it make sense?

If so, does it looks like a bug or can it be something I messed up?

Thank you!


texts: CKEditor Multi-Site Configuration Problem

texts:
After updating to 4.7.23 from 4.7.20, I can now use the CKeditor Configuration and the changes are saved based on the changes made at https://issues.civicrm.org/jira/browse/CRM-19303, but the wysiwyg doesn't show up. The Drupal log error message reports "page not found" and that it is looking for

http://staging.focusdc.org/sites/focus/sites/focusdc.org/modules/civicrm/js/wysiwyg/crm.ckeditor.js

when I believe it should be looking for

http://staging.focusdc.org/sites/focusdc.org/modules/civicrm/js/wysiwyg/crm.ckeditor.js

I'm not sure how to go about changing this.  Everything else seems to be working correctly as my Resource URL's and Upload Directories look correct.

Thanks in advance

8/15

After some further sleuthing I discovered my production site running 4.7.20 reports:
[civicrm.root]  https://focusdc.org/sites/focusdc.org/modules/civicrm/

whilte my staging server running 4.7.23 reports:
[civicrm.root] http://staging.focusdc.org/sites/focus/sites/focusdc.org/modules/civicrm/

They have identical civicrm.settings.php outside of the one having SSL and one referencing "staging".

Did the $civicrm_root settings change in civicrm.settings.php between 4.7.20 and 4.7.23? Any other thoughts?


texts: Field Mapping Not Saved When Importing Multi-Value Custom Data

texts:
I'm using the Import Multi-value Custom Data screen (civicrm/import/custom?_qf_MapField_display=true) and it does work, but it is not saving the field mapping. There is the following error:
Warning: Declaration of CRM_Custom_Import_Parser::run($fileName, $separator, &$mapper, $skipColumnHeader = false, $mode = self::MODE_PREVIEW, $contactType = self::CONTACT_INDIVIDUAL, $onDuplicate = self::DUPLICATE_SKIP) should be compatible with CRM_Contact_Import_Parser::run($tableName, $mapper = Array, $mode = self::MODE_PREVIEW, $contactType = self::CONTACT_INDIVIDUAL, $primaryKeyName = '_id', $statusFieldName = '_status', $onDuplicate = self::DUPLICATE_SKIP, $statusID = NULL, $totalRowCount = NULL, $doGeocodeAddress = false, $timeout = CRM_Contact_Import_Parser::DEFAULT_TIMEOUT, $contactSubType = NULL, $dedupeRuleGroupID = NULL) in require_once() (line 17 of /srv/buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Custom/Import/Parser.php).

There are also additional errors for each field used in the import:
Warning: Invalid argument supplied for foreach() in CRM_Custom_Import_Parser_Api->import() (line 180 of /srv/buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Custom/Import/Parser/Api.php).

I reproduced this error on the dmaster demo site and am using the errors from this site.


texts: How can I edit how CiviEvent pricing is displayed?

texts:
I have a strange issue when creating a CiviEvent; which did not appear in a pre-launch test event I created but does now. As you will see below, the first fee in the list appears off-set to the rest.

I have checked on the dmaster site and it does not react this way. Of course it may be something that is happening on the Drupal side. I am using D7.38 and Civi4.4.14


texts: Has anyone gotten GiveWP to work with CiviCRM

texts:
One of my associates wants to use GiveWP for donation forms. GiveWP has a plugin

https://shop.civivip.com/civi-plugins/give-donation-pages-integration/

The current version is called
civivip_give-0.3.0-beta

Does beta mean it is not released for production sites?


texts: How to remove an activity from a case or file an activity on several cases

texts:
I have an Email activity that I sent to several contacts.  Each of those contacts has an active case open.  My intention was to file that email on each contact's case so that I see it when I review the case history.  When I open the email activity, I see one email with 7 recipients.

After filing the e-mail on the first contact's case, it has disappeared from the activity view of all the other contacts.

My first inclination was to try to "un-file" it from the first contact's case.  But I don't see an un-file button when looking at the case.

So...questions:

Is it possible to un-file an activity from a case?  How?
Is it possible to file the same activity record against multiple cases?

Thank you!


texts: I need to omit soft credits from some reports. Financial reports currently double the amount of some contributions when the contributions include a soft credit. For example, matching donations are entered with soft credits to the original donor, but these matching donations should not be included in the report totals.


texts: Is there a way to set the autorenewal checkbox on a membership contribution page to be ticked by default?

texts:
We're running on Drupal 7.69 and Civi 5.13.x.

Is there a way to have the option to autorenew ticked by default through configuration?

See image below:


texts:
I keep trying to add a new participant status, but the page isn't letting me. I hit save, but nothing happens. I thought it was my browser, so I switched. I thought maybe a bug, so I upgraded to the latest CiviCRM. Still can't save it. I've tried clicking on Save as well as just hitting Enter when in one of the fields. Nothing.
Drupal 7, CiviCRM 5.27.0
Console shows the following error:
An invalid form control with name='visibility_id' is not focusable


texts:
I'm trying to create a simple spreadsheet to import event participants, and need to add the Participant Status codes to import.

Is there a list anywhere or which codes correspond to which statuses?

E.g. which code number for "Registered", "Attended", "On waitlist", "Cancelled", etc?

I'm sure this info must exist but I can't find it in the documentation...


texts:
HostGator has frozen their shared platforms at MySQL 5.6 with no plans to offer MySQL 5.7 to the shared packages, even though 5.6 went EOL on February 5th, 2021. They're pushing people to use their Virtual Private Server which is about 10x the cost of shared. So, if you're installing CiviCRM, DON'T host with HostGator.
We'd like to stay up-to-date on CiviCRM, at least the security fixes, but the only option seems to be to pay for Extended Security Release. Are there any alternatives for those who have been locked out by their hosting platforms?
cheers ... :) gn


texts: How do I get correct currency data to stripe.com from my CiviCRM transactions

texts:
Background: Wordpress site, CiviCRM 4.6.x, Stripe extension version 1.9.1 is reported, and the directory in my extensions folder is called com.drastikbydesign.stripe-4.6-dev (installed in June/July).

Civi is configured with GBP as the default currency, and GBP, USD and EUR are all set as available currencies. We have - at present - three contribution pages, one for each of the three currencies, and the currency is set in the configuration for each page.

CiviCRM is recording the transaction in the correct currency (USD). Stripe is recording the transaction, but is recording it in GBP. This is causing a major issue as you might expect. For example, we have a user who has donated USD20. CiviCRM tells us they have donated USD20, but Stripe has read this as GBP20, and taken USD31.64 from the user's credit card. Not good.

Looking at the events and logs data in the Stripe dashboard I can see that 'gbp' is being given everywhere as the currency.

I don't know if this is a bug in this extension or more generally in CiviCRM, but my guess - and it is a guess - is that the currency data is being taken from the default currency rather than from the currency that is set for the specific contribution page.

Here's a link to the issue in the extension repo: https://github.com/drastik/com.drastikbydesign.stripe/issues/91


texts: How to set the default Preferred Language

texts:
I think i must be missing something.

When I go to Option Groups /civicrm/admin/options?reset=1

and choose Language

/civicrm/admin/options?gid=75&reset=1

i see no value listed as Default, and no option when I click 'edit' on an option to set it as Default, yet if i look in the DB for values where option_group_id = 75 it shows en_US as default.

I set this to the desired value but where I am being blind in terms of doing this via the UI?


texts: How do I change date display from 2017-03-20 to March 20, 2017?

texts:
Writing "Please Renew" letters to membership. Template text includes a token for the expiration date {membership.end_date}. In pdf printout, date converts to number format (yr-mo-day), even though in the Membership summary the date reads in calendar format. Is there some way to change the setting for this?

How it reads: "Thank you for supporting our organization! Your Family Membership is expiring on 2017-03-20." What I want: "Thank you for supporting our organization! Your Family Membership is expiring on March 20, 2017"


texts: Added some custom fields but it'snot coming in advanced search

texts:
I have 4- 5 custom fields in CIVI CRM but I am not getting it in advanced search.
Please help me I want to search based on custom fields.


texts:
We have done a bit of searching and it looks like there is or was a just giving import by veda (https://github.com/veda-consulting/uk.co.vedaconsulting.module.justgivingImports) that looks to be out of date.

I am wondering what people are using to import their justgiving report data into civi? Is it just the basic import process or are people using the JG API? Looking for this to be as easy as possible and suspect other UK charities will have faced this but I do not seem to see anything active on google searches.

Appreciate any help or pointers.


texts: Participant Count and Capturing additional participant information

texts:
If I am using a Price Set field with a multiple participant count (Say, Five registrants for a discounted price of $550) will or can I also capture the additional registrant information.

to expound:

We have individual registration options, as well as a group registration option.  I was planning on doing
- 1 price field for General registrant (Participant count of 1)
- 1 price field for Student registrant (Participant count of 1)
- 1 price field for Group of Five (Participant count 5)

Do I need to activate the "Register additional participants" option in order to capture the additional participants names or will civi prompt for that info since the participant count is 5 for the Group of Five option.

If I do have to select the "Register additional participant" setting, would the registrant have to both select 4 from the Register Additional Participants drop down as well as select the "group of 5" option?  if this is the case, should the group of 5 participant count really be 1 instead of 5?

Thanks


texts:
How can I show the Users Profile Picture on a Civicrm Form please (in joomla)?

Thanks a lot,
Sri


texts:
How can I automatically display today's date in a pdf or email.
I tried the "thank you date" token but the date format is 12-31-15 12:30. I need December 31, 2015...
I tried plugging in this
{$smarty.now|date_format}
Still didn't work.
Any ideas?

Thanks


texts: Different membership receipts for 'New' and 'Active' members

texts:
We send our donors once a year an email and ask them to become members. The email contains a link with a contact checksum that directly leads them to a contribution page, where they can select their membership and do the payments.

And our existing members we send a similar email and ask them to renew.

Both pages generate an email receipt using the template Memberships - Receipt (on-line) Is it possible to make a difference between the new and the already active members?

The CiviCRM version is 4.7.26.


texts:
I'm using Joomla and CiviCRM 4.7 and I want to add custom fields to the Participant List that's available as menu item on Joomla. I've searched all of the tables but I don't know where to find the data in the civicrm database.

I have a custom group called Conference_Selections and one of the options is for participants to choose a workshop and a study group. I want to add those fields to the participant list report so my committee can access it on the front end without having to access the report from the back end.

Is this possible? If so, where is this data stored?

Thanks for your help!


texts:
I can't upgrade my database schema, I encounter error:
Found CiviCRM database version 5.29.alpha1.upgrade.
Found CiviCRM code version 5.29.0.
Cannot begin upgrade: The database indicates that an incomplete upgrade is pending. If you would like to resume, use --retry or --skip.
Retry or skip parameters doesn't change anything. How can I fix this db problem? I've tried some of the fix suggestions mostly about caches, from previous versions. Not helped.
It runs on Drupal8. Turns out the first problem occurs with:
Dropping SQL triggers...
Preparing upgrade...
Executing upgrade...
.......Error executing task: %s
[PEAR_Exception]
DB Error: no such table


texts: In Find contributions> actions: receipts print or email> how would I customise that wording / graphics for that choice


texts: Credit Card Contributions entered by staff listed as complete but never made it to authorizenet

texts:
recently taken over support for a very complex drupal 7/Civi 4.7.x site (which I'm happy to say was very well built by the initial team).

One of the issues that we've found reviewing things is that there are a number of contributions that were entered by the staff of the organization that are listed in civi as complete but do not show up anywhere in authorizenet. Other contributions entered by donors themselves were processed and paid but these have fallen into a void -- and these are some large donations.

As you can imagine this is causing a lot of stress. People thought they donated and never got billed; the org thinks it has money that was never processed so actually does not exist.

Has anyone seen anything like this in the past? I can't go back in time and fix the broken donations but what can I do to try to make sure this does not continue to happen?


texts: Can you disable or hide fields in the Individual window?


texts: How to convert/import participants with partial payments

texts:
I've tried importing participants in the standard way, then importing contributions for their event deposits (partial payments), then using API CSV import to connect them via a ParticipantPayment import. However, things don't seem to behave correctly afterward.

Bringing the data directly in via SQL on civicrm_participants, civicrm_contributions, and civicrm_participant_payments doesn't seem to work either.

What is the correct way to convert in the data so these participants will be connected with their deposits?