Skip to main content
7 votes
Accepted

Mailing event queue error when upgrading from CiviCRM 5.66 to 5.67

There are orphan data in civicrm_mailing_job table. Below query should return you the count SELECT count(*) FROM civicrm_mailing_job j LEFT JOIN civicrm_mailing m ON m.id = j.mailing_id WHERE m....
Pradeep Nayak's user avatar
5 votes
Accepted

How to make a FormBuilder form visible to visitors? (not logged-in users)

I have an FB form that's submitted by anonymous users. The 'Permission' on the form's settings page is set to 'Generic - Allow all users (including anonymous)' and on each contact page 'Security' is ...
Andy Clark's user avatar
  • 4,845
5 votes
Accepted

WordPress group sync - after migrating from Drupal

how do I deal with the leftover user IDs attached to contact records? Clear your civicrm_uf_match table except for your own record - i.e. the one that has your User ID and Contact ID. You'll then ...
Christian Wach's user avatar
4 votes

Add new custom field column

If you're talking about the contact basic and advanced search results, you can add the field to a profile and set that to be used at Administer > Customise Data and Screens > Search Preferences &...
Aidan's user avatar
  • 13.5k
4 votes
Accepted

Do strings used in API version 4 need to be escaped?

Yes, all strings will be escaped automatically by the CiviCRM code.
Pradeep Nayak's user avatar
4 votes

Front end forms for contacts?

You have several options. The oldest option is profiles (Administer > Customize Data and Screens > Profiles). These are basic in functionality, but are still my first choice for newsletter ...
Jon G - Megaphone Tech's user avatar
4 votes
Accepted

Populate a Contribution form custom field from a URL parameter

You can do something like below you can use API4 to get the exact machine names civicrm/api4#/explorer/CustomField/get?select=%5B"id"%5D&where=%5B%5B"name","%3D",&...
Pradeep Nayak's user avatar
4 votes
Accepted

Is there any way to embed a form created with FormBuilder in WordPress?

You can use shortcodes to embed afforms in a WordPress post or page [civicrm component="afform" name="afformQuickAddOrganization"] where afformQuickAddOrganization is the name of ...
Pradeep Nayak's user avatar
3 votes
Accepted

Invalid field 'contact_id.is_deceased' Apiv4

That backtrace seems to point to this change as the culprit, however after several attempts I've been unable to reproduce that error. We can continue discussion on this issue: https://lab.civicrm.org/...
Coleman's user avatar
  • 18.7k
3 votes
Accepted

civicrm_post hook not firing upon contact creation

The hooks run in php not javascript, so it won't log anything to the js console. If you want to log, use \Civi::log()->debug('hello'); and then look in the ConfigAndLog directory in the logs there. ...
Demerit's user avatar
  • 23.3k
3 votes

User creation feature is no longer visible

This is a Core regression bug, I have pushed a fix https://github.com/civicrm/civicrm-core/pull/28970 Can you please apply the [patch][1] and test? wget https://patch-diff.githubusercontent.com/raw/...
Pradeep Nayak's user avatar
3 votes
Accepted

How do you display searchkit results, tables, lists, on public pages?

You must change permissions on the search display and also on the form to allow anonymous access. Instructions are here: https://docs.civicrm.org/user/en/latest/searching/searchkit/example-membership-...
Coleman's user avatar
  • 18.7k
3 votes
Accepted

Civi Report Errors

The fix is available on the gitlab but the maintainer as not yet released it. You can download the code from the gitlab and copy the /vendor folder from older version into the downloaded version or ...
Pradeep Nayak's user avatar
3 votes

Change checkbox label in event form

You could use the Word Replacement feature with no code to change the string 'Public Event' to something else. Here's a link to the documentation: https://docs.civicrm.org/user/en/latest/initial-set-...
Coleman's user avatar
  • 18.7k
3 votes
Accepted

Base page shown instead of contribution page to public users

Problem solved: The Yoast SEO plugin was set to rewrite dynamic URLs under the Advanced -> Crawl Optimization settings. Disabling it fixed the issue.
Sarah's user avatar
  • 41
3 votes
Accepted

Can rename(AS) a column/field from SELECT using APIv4

There was a long discussion about this at https://lab.civicrm.org/dev/core/-/issues/3738 which resulted in a new $result->rekey() method added to the next beta (5.74). See https://github.com/...
Coleman's user avatar
  • 18.7k
3 votes
Accepted

Warning after upgrade to 5.72.1 wordpress re Deprecation Permission 'view payment tokens'

I have submitted a PR for the fix, you can apply the patch or wait for the maintainer to merge and release a new version. HTH Pradeep
Pradeep Nayak's user avatar
3 votes

Tracking links in mailings redirect to login screen

Alright nevermind, I found the problem : it was my Wordpress extension Authorizer that was blocking any non logged-in access to CiviCRM. Solved now.
Mowgli's user avatar
  • 31
2 votes
Accepted

Civicrm 5.57.0 Error on Contact Notes View

I found a fix: I found out that this error is related to CiviMobileAPI. If this extension is deactivated everything works again. I found this error message regarding this: [php:warn] [pid 235173] [...
Bernd's user avatar
  • 41
2 votes
Accepted

Get uploaded file full URL via API v4

With the help of Lars SG's links. I created a, PHP 8, helper function to get a URL based on a file ID provided by the API. function se_45209_get_entity_image_url( int $entity_id, int $file_id ): ...
Michael Bragg's user avatar
2 votes
Accepted

Easy way of one word translation?

Following on from comments, if this is custom code then you can use CRM.config.locale and hardcode the translation there, e.g. var text = 'banana'; if (CRM.config.locale == 'fr_FR') { text = 'banane'...
Demerit's user avatar
  • 23.3k
2 votes

Can't get cron.php to run using the commands

One thought is that the you are not running the cli version of php on the command line. Different hosts have different settings, and I don't know IONOS. I use the following to be sure I get the php ...
Kevin Cristiano's user avatar
2 votes
Accepted

Event Registration Error on Wordpress 6.3.1 Civi 5.63.4 "Could not find valid value for id"

Finally solved this one... The Nginx conf was doing a "Drupally" rewrite which was upsetting WordPress. try_files was appending args in this way:- try_files $uri $uri/ /index.php?q=$uri&$...
Darren's user avatar
  • 761
2 votes
Accepted

CiviEvent generates invalid link

Instead of setting the event link path to the relative path civicrm/event/info/?reset=1&id=[id], use the absolute path https://mysite.com/civicrm/event/info/?reset=1&id=[id].
Torben Gundtofte-Bruun's user avatar
2 votes

Display Total Membership in Wordpress home page

You can create a Search kit to display number for Memberships and use shortcode to display on pages or widget Search kit import: [ [ "SavedSearch", "save", { &...
Pradeep Nayak's user avatar
2 votes

Civicrm German Language not displaying even when set to German after upgrade to 5.65.2

First message: Possible solution - will be tested here - : disable in the admin interface all except language EN remove the installed language files in /l10n/ and /sql/ ... (to check what is inside ...
Laura's user avatar
  • 21
2 votes

What's the best way to provide Profile Edit and Create forms in latest WordPress and CiviCRM?

I would rate the combination of FormBuilder and FormProcessor as the most robust, future-proof and secure variant. However, in my opinion there are still quite a few functions missing (see, for ...
Andreas's user avatar
  • 323
2 votes
Accepted

5.64.0 seems to break ContributePage

5.64 moves a whole bunch of stuff into extensions and if the upgrade doesn't go smoothly there can be a mismatch between components and extensions. Check that both civicontribute component and the ...
Demerit's user avatar
  • 23.3k
2 votes
Accepted

How to show courses (events) as a table listing in WordPress?

The current way to achieve this would be with SearchKit. It can allow you to customize your own Upcoming Events screen. Once you've created the search and embedded it in FormBuilder, you are ready to ...
Coleman's user avatar
  • 18.7k
2 votes

How can I set up automated monthly email reports?

On the report, click the Email Delivery tab, fill out the details there and set up a Scheduled Job to send it monthly (you'll find instructions if you click the little ? icon beside Email Delivery ...
Lars SG's user avatar
  • 4,083

Only top scored, non community-wiki answers of a minimum length are eligible