# Question
Title: How to search for all contacts without a tag? Registered for event
I need to find all contacts that are in our system without a tag AND are Individuals AND registered for a specific event.

This is what I am doing:

* Contact -\> Contact Type = Individual
* Participant -\> Event Title = Event Name
* Contacts -\> Tags = Is Empty

Then I error out - the issue is with the tags - even if I choose *Is Null* \- I still get a ton of errors. If I chose Contacts -\> Tags -\> Not In -\> Select every tag. I still get a ton of errors.

PS: Is there a way to use search builder to find an event by Event ID instead of title?

CiviCRM 5.0.2 and Drupal 7

DB Error: No Such Field - Backtrace below.

---

```
    #0 /home/webname/www/www/sites/all/modules/civicrm/CRM/Core/Error.php(190): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/webname/www/www/sites/all/modules/civicrm/packages/PEAR.php(921): call_user_func((Array:2), Object(DB_Error))
#3 /home/webname/www/www/sites/all/modules/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: no such field", -19, 16, (Array:2), "SELECT contact_a.id as contact_id, contact_a.contact_type as `contact_type`, ...")
#4 /home/webname/www/www/sites/all/modules/civicrm/packages/PEAR.php(575): DB_Error->__construct(-19, 16, (Array:2), "SELECT contact_a.id as contact_id, contact_a.contact_type as `contact_type`, ...")
#5 [internal function](): PEAR->_raiseError(Object(DB_mysqli), NULL, -19, NULL, NULL, "SELECT contact_a.id as contact_id, contact_a.contact_type as `contact_type`, ...", "DB_Error", TRUE)
#6 /home/webname/www/www/sites/all/modules/civicrm/packages/PEAR.php(224): call_user_func_array((Array:2), (Array:8))
#7 /home/webname/www/www/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->__call("raiseError", (Array:7))
#8 /home/webname/www/www/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -19, NULL, NULL, "SELECT contact_a.id as contact_id, contact_a.contact_type as `contact_type`, ...", "DB_Error", TRUE)
#9 /home/webname/www/www/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'civicrm_tag.name' in 'field list'")
#10 /home/webname/www/www/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
#11 /home/webname/www/www/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("SELECT contact_a.id as contact_id, contact_a.contact_type as `contact_type`, ...")
#12 /home/webname/www/www/sites/all/modules/civicrm/packages/DB/DataObject.php(2446): DB_common->query("SELECT contact_a.id as contact_id, contact_a.contact_type as `contact_type`, ...")
#13 /home/webname/www/www/sites/all/modules/civicrm/packages/DB/DataObject.php(1635): DB_DataObject->_query("SELECT contact_a.id as contact_id, contact_a.contact_type as `contact_type`, ...")
#14 /home/webname/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php(392): DB_DataObject->query("SELECT contact_a.id as contact_id, contact_a.contact_type as `contact_type`, ...")
#15 /home/webname/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php(1348): CRM_Core_DAO->query("SELECT contact_a.id as contact_id, contact_a.contact_type as `contact_type`, ...", TRUE)
#16 /home/webname/www/www/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(4942): CRM_Core_DAO::executeQuery("SELECT contact_a.id as contact_id, contact_a.contact_type as `contact_type`, ...")
#17 /home/webname/www/www/sites/all/modules/civicrm/CRM/Contact/Selector.php(1181): CRM_Contact_BAO_Query->searchQuery(NULL, NULL, NULL, FALSE, FALSE, TRUE)
#18 /home/webname/www/www/sites/all/modules/civicrm/CRM/Utils/PagerAToZ.php(108): CRM_Contact_Selector->alphabetQuery()
#19 /home/webname/www/www/sites/all/modules/civicrm/CRM/Utils/PagerAToZ.php(136): CRM_Utils_PagerAToZ::getDynamicCharacters(Object(CRM_Contact_Selector), FALSE)
#20 /home/webname/www/www/sites/all/modules/civicrm/CRM/Utils/PagerAToZ.php(52): CRM_Utils_PagerAToZ::createLinks(Object(CRM_Contact_Selector), NULL, FALSE)
#21 /home/webname/www/www/sites/all/modules/civicrm/CRM/Contact/Form/Search.php(839): CRM_Utils_PagerAToZ::getAToZBar(Object(CRM_Contact_Selector), NULL)
#22 /home/webname/www/www/sites/all/modules/civicrm/CRM/Contact/Form/Search/Builder.php(414): CRM_Contact_Form_Search->postProcess()
#23 /home/webname/www/www/sites/all/modules/civicrm/CRM/Core/Form.php(447): CRM_Contact_Form_Search_Builder->postProcess()
#24 /home/webname/www/www/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Refresh.php(75): CRM_Core_Form->mainProcess()
#25 /home/webname/www/www/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Refresh->perform(Object(CRM_Contact_Form_Search_Builder), "refresh")
#26 /home/webname/www/www/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Search_Builder), "refresh")
#27 /home/webname/www/www/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("refresh")
#28 /home/webname/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(309): CRM_Core_Controller->run((Array:4), (Array:0))
#29 /home/webname/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:13))
#30 /home/webname/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#31 /home/webname/www/www/sites/all/modules/civicrm/drupal/civicrm.module(445): CRM_Core_Invoke::invoke((Array:4))
#32 [internal function](): civicrm_invoke("contact", "search", "builder")
#33 /home/webname/www/www/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:3))
#34 /home/webname/www/www/index.php(21): menu_execute_active_handler()
#35 {main}

```

# Answer
> 5 votes
While a code-level fix is obviously preferable, the quick solution is to create two groups:

* Everyone who attended the event who has the tag.
* Everyone who attended the event.

Then use the custom search **Include/Exclude by Group/Tag** to include group 2 and exclude group 1. Who's left is everyone who attended without the tag.

# Answer
> 2 votes
Thank you for your question that allowed me to test Jon's solution and now find an alternative solution that seems to me even simpler:

The new SearchKit allows you to do what you want easily. The simplest is to choose "Without" from the first drop-down menu and "Tag" from the second drop-down menu. Then we can combine tags to different criteria, like Individual. However, I did not test with events.

---
Tags: tags, search-builder
---


# Question
Title: Help with Searchkit query on Non members
Hopefully very easy but I want to build a search kit of people in a mailing group (Historic Event Attendees) who are NOT current members.

When I do Status = Empty, I get 378,

but when I do Status = Does not Include New, Current, Renewal, Grace, I only get 40!

Please can you suggest what extra query I need to add to get this to show me people in the group who are NOT current members, as I should get more in the second query, as that would include those with status lapsed and cancelled.

Thanks

# Answer
You have made Join as 'With(optional)' and with status empty will give you contacts who never had membership

If you do OR clause then you should get 378+40 results approx with group by
> 1 votes

---
Tags: searchkit
---


# Question
Title: Relationships and Notes tabs are missing when viewing a Contact
I recently upgraded to Civi 5.70.2 from 5.50.1. PHP 8.2. Wordpress. I thought I finally had everything working but today I see the Relationships and Notes tabs are missing when viewing a Contact, similar to: Relationships not being displayed and view contact no relationship tab and note tab? I have the SearchKit installed. Oddly, it showed up on the Search Menu twice, but I was able to fix that with the Navigation Menu. I have the Packaged Searches for Relationships and Notes:

I have tried running those searches, to no avail. Here's what a sample Contact looks like:

Please advise...thanks!

# Answer
> 2 votes
Relationships and Notes tab are using FormBuilder in the most recent versions. My guess is that by updating from a version that old, it didn't enable them for whatever reason. Try going to **Administer menu » System Settings » Extensions** and enable "Form Core" and "SearchKit".

# Answer
> 1 votes
Since the one big upgrade didn't work, I had to do two smaller upgrades. That worked, so I guess the lesson is, don't wait too long between upgrades...do one every time there's a Security Release

# Answer
> 0 votes
Try running this:

```
cv ev 'CRM_Contact_BAO_RelationshipCache::rebuild();'

```

for the Relationships issue.

If you run into `PHP Deprecation` errors, then trying downgrading your PHP version to 8.0.

---
Tags: wordpress, relationships, notes
---


# Question
Title: Which "Payment Method" setting to use when supporting ACH payments? Authorize.net (eCheck.net)
Working on supporting ACH payments via eCheck.net. Which "Payment method" should I use?

# Answer
You can choose anything(its a reference used in Civi) or you can create new one at CiviCRM \>\> Administer \>\> CiviContribute \>\> Payment methods (/civicrm/admin/options/payment\_instrument?reset=1)
> 3 votes

---
Tags: payment, authorize.net, echeck.net
---


# Question
Title: How can I implement a select-or-other widget over a plain text field?
I have a field which normally expects a value selected from a managed list (e.g. a list of courses, a list of colleges). The client would like the visitor to be prompted with one of the managed list as they type in their entry, to promote consistency in spelling, etc., but not to restrict the value with this UI. In other words, it should allow any text entry.

So that means, I think I want a plain text field with an implementation of the select2 widget that doesn't require the entry of one of the select options.

Note that this isn't the same as the classic select-or-other where you have a select field followed by a hidden text field that becomes visible when other is selected, and in some ways seems like it should be easier.

This kind of UI is natively supported by the select2 widget

Any clues on implementation?

# Answer
> 1 votes
Assuming you are storing these as civi option values, you could do it the way civi does it with the wrench icon to add new options on-the-fly. There's a data-option you add to the wrench tag.

If you prefer it more like the contact entity refs with the "New" options, you can almost do it with addEntityRef, but it would need to support the "create" option in props, e.g. `$form->addEntityRef('gender_id', 'Gender', ['entity' => 'OptionValue', 'create' => TRUE, 'api' => ['params' => ['option_group_id' => 3]]]);` (the "create" doesn't work there). But you might be able to civix generate your own entity, and make that work. You want to validate it server-side, so it's not just a matter of setting the select2 "tags" option. (I'm sure you've seen the "an illegal choice has been detected" message in drupal.)

---
Tags: custom-fields, select2
---


# Question
Title: Online Event Registration - Guests vs. Members
Our live CIVICRM environment is CiviCRM 5.67.1, Joomla 4.4.2, PHP 8.1, hosted on Siteground.

Looking for ideas on how to handle this. Currently, we have events in CIVIEVENT that the public and/or members can register for. They do so by going to a Upcoming Events page, click on the event, and fill out the online registration page. The Duplicate Matching Rule on all events is Unsupervised.

What I am looking to do is to continue to allow the public/guests (non-members) to continue as-is: Go to the Upcoming Events page, find the event, and fill out the online registration page.
However, for members (who have an account on the system), I want to enforce the login into the system before they register for an event. In other words, if they login, great - they go to the Upcoming Events page, find the event, and find that most of their online registration fields are already populated from their account. If members do not login, however, they are directed to sign into their account before proceeding with registering for an event.
It seems like the Duplicate Matching Rule ought to play a part here, but I am not sure about that. I would love to hear your ideas about how to solve and execute this. Thanks in advance.

# Answer
> 1 votes
We have provided text messages on every event info and registration form for anonymous users to log in if they already have an account.

Also in some cases, we have checked for email addresses just before visiting the registration page. If the account exists for the email we have redirected the user to login page else to redirection page(This is via custom extension)

# Answer
> 1 votes
We trigger a modal popup, which opens some seconds after the users click on the event registration-button, asking them to login, if they alredy have an account, in order to shorten the process. The login-mask in the popup also holds links for forgotten usernames and passwords.

This helps a lot, we only have around 1-2% of users which have an account and "create" a new one through event registrations.

\*** EDIT \***
Forgot to mention: this is a custom coded solution.

---
Tags: civievent, user-account, online-registration
---


# Question
Title: Change date contribution or membership offers date of day but 10 years ago
We are facing a very strange problem. At the time of resuming a contribution or changing an end date, today we cannot choose a date beyond 2014. Automatically the date of the day fills the 3 fields but 10 years back ?!? However, when I click to renew membership, I do not encounter this problem (if only the date of accession is not up to date, neither will the date of automatic end of accession be correct). Then, when I resume membership, the date field offers me again the date of the day 10 years ago ?!?

Does anyone encounter this problem? What can we do to solve it?

CiviCRM 5.57.3 | Joomla! 4.4.3

# Answer
Looks like a bug for PH\* strict rule

This was fixed in Civi version 5.66. You can either apply the patch or upgrade Civi to the latest.
> 1 votes

---
Tags: joomla, contributions, dates
---


# Question
Title: 1142 INSERT command denied to user when accessing any page with a form
My Drupal 10 website hosted on OVH was working fine, but now, whenever I try to access a page with a form, I get an error on that page

The website encountered an unexpected error. Try again later. Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE\[42000\]: Syntax error or access violation: 1142 INSERT command denied to user 'xxxxxxx'@'xx.xx.xx.xx' for table 'watchdog': INSERT INTO "watchdog...

Any idea what the issue might be?

# Answer
Looks like a MySQL user permission issue. Check if the user has required permission to perform action on drupal db.

https://stackoverflow.com/a/5699061
> 1 votes

---
Tags: drupal
---


# Question
Title: Discount not applied on Event registration
Discounts stopped working on our website, is anyone having same issue recently?

We tried deleting all the codes and created new one with no success.

# Answer
> 3 votes
Looks like an issue on recent version of CiviCRM

Submitted PR at https://github.com/civicrm/civicrm-core/pull/29829

---
Tags: cividiscount
---


# Question
Title: HTML in Confirmation Screen Introductory Text
We have text that goes on the top of our Registration Screen Confirmation Screen, and our Thank You Screen. It's the exact same text - name and date of the event in big letters. It's working fine on the Registration Screen and the Thank You Screen; however, on the Confirmation Screen it's showing the HTML instead of processing it.

Everything was fine previously, but we just updated to the latest version of CiviCRM for D7 and now this is happening.

I removed all our custom template files, deleted the cache, etc just in case it was an issue with our custom templates. The problem persists.

# Answer
> 2 votes
If you change `escape` in this line to `purify`, does that fix it: https://github.com/civicrm/civicrm-core/commit/e33e2dee8fb57eac6a068629ec5224ab9d3576c4#diff-6f590560a3250af349b62a231b13cbfb124c191e07f69319d1b5aade2d688349R38

https://github.com/civicrm/civicrm-core/pull/29841

---
Tags: civievent
---


title: crmURL with selectedChild parameter?

text:
# Question
Title: crmURL with selectedChild parameter?
I'm trying to do something like the following in my extension's template:

```
{capture assign=contactUrl}{crmURL p='civicrm/contact/view' q="reset=1&id=`$contactId`&selectedChild=jobs" h=0}{/capture}
<a href="{$smarty.capture.contactUrl}">View Contact's Jobs</a>

```

But the selectedChild does not show up on the resulting URL. We do have a contact summary tab for Jobs in our case (part of the extension), and it does work if I hand type that parameter into the url. But not in smarty.

What is the right way to assign the correct crmURL (so the right URL works with any CMS) with the selectedChild parameter included? Or is this method no longer how we can direct to a specific tab on the contact summary page?

# Answer
> 1 votes
I think you can just use `$contactUrl` instead of `$smarty.capture.contactUrl`

Try replacing the last line with:

```
<a href="{$contactUrl}">View Contact's Jobs</a>

```

---
Tags: extension
---


# Question
Title: Send scheduled email to contact (parent) related to event participant (child)
We are using CiviCRM 5.70.2 on Drupal 10.2.4.

CiviCRM has contacts that are parents and contacts that are children, which have a relationship with each other. Parent contacts have an email. Children contacts do not have an email.

The children are registered for events, parents are not registered for the events. Some children are registered for multiple events. Some parents have registered more than on child for an event.

We want to send a scheduled reminder email to the parent 2 weeks before the start date of the event for which the child is registered. I know how to schedule a reminder an email to an event participant. I know how to create a group of contacts (parents) who have a child in a certain event. I can create such a group for each event and then use that group to **manually** send an email to the parent on X days before the child's event begins.

But, how can I schedule an automatic reminder email to the related parent of a child x days before the child's event begins? The schedule reminder function does not seem to have that option.

# Answer
Seems possible using civirules \+ emailapi extension -

Trigger: `Event Date reached`; Offset: `2 Week(s) before "Start Date"`

Action: `Send Email to a related contact`

An test rule setup might look like:
> 1 votes

---
Tags: relationships, scheduled-reminders, civicrm-event
---


# Question
Title: Is it possible to have webform-civicrm allow 'user select' for the Contribution page so user can select Currency?
We have a situation where we need folk to be able to choose currency. currently this means multiple Contribution pages.

I was hoping we could redo this using Webform-civicrm and set the Contribution Page as 'user selects'.

This is not currently a valid setting.

Any obvious reasons why this would be difficult to accomplish?

Or is there another way to offer 'currency' directly?

# Answer
> 0 votes
> Or is there another way to offer 'currency' directly?

On latest Webform CiviCRM 6.x, you get an option to select currency directly from Contribution Tab

---
Tags: webform-civicrm, contribution-page, currency
---


# Question
Title: People approved for events can't register
Folks who get the email with the confirmation link in it to go and register for an event are now getting a page that says this: You have not been added to the waiting list because there are spaces available for this event. We recommend registering yourself for an available space instead.

Process:

They get the email saying they have been approved with a link to confirm.

They click the link and get taken to a page with two options: cancel registration confirm registration

You click on "confirm registration".

The next page is the registration page for this event with all the fields filled in with what they'd already given.

Click the "review" button.

Next page says this at the top:

Please correct the following errors in the form fields below: You have not been added to the waiting list because there are spaces available for this event. We recommend registering yourself for an available space instead.

Using 5.71.1 on Drupal 7.

# Answer
Can you log this as a bug over at gitlab? https://lab.civicrm.org/dev/core/-/issues/new
> 0 votes

---
Tags: civievent, pending
---


# Question
Title: Updating from CiviCRM 5.38.0. to 5.71 on wordpress
Any help with how to update CiviCRM 5.38.0. to 5.71 on wordpress?

Currently my website says--\> System Status: Critical (which is obviously quite worrying!) I've downloaded the zip file from civiCRM but I'm stuck on the next step... Simple instructions would be greatly appreciated,as I'm not a tech pro.

# Answer
You can find details of how to upgrade in the SysAdmin guide:

https://docs.civicrm.org/sysadmin/en/latest/upgrade/
> 0 votes

# Answer
If you do not have anything custom, simply delete the old Civi folder, purge the templates\_c in the Uploads folder and then go here:

https://example.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/upgrade&reset=1

I have a the CiviCRM Admin Utilities plugin and does wonders as it automates a lot of stuff. You can trigger the Clean Cache, Rebuild on the fly, and trigger the upgrade there, as well.

**ALWAYS BACK UP!**
> 0 votes

---
Tags: wordpress, upgrade, installation
---


# Question
Title: getFieldValue failed when attempting dedup
I'm getting this error when attempting to dedup our contacts, on Civi 5.64.4, WP 6.4.3. Any pointers are appreciated.

```
***ERROR***
message:            getFieldValue failed
code:
exception:          CRM_Core_Exception Object
(
[errorData:CRM_Core_Exception:private] => Array
    (
        [error_code] => 0
    )

[cause:protected] =>
[_trace:PEAR_Exception:private] =>
[message:protected] => getFieldValue failed
[string:Exception:private] =>
[code:protected] => 0
[file:protected] => /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php
[line:protected] => 1417
[trace:Exception:private] => Array
    (
        [0] => Array
            (
                [file] => /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Dedupe/BAO/DedupeRuleGroup.php
                [line] => 594
                [function] => getFieldValue
                [class] => CRM_Core_DAO
                [type] => ::
            )

        [1] => Array
            (
                [file] => /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Dedupe/Merger.php
                [line] => 2249
                [function] => getContactTypeForRuleGroup
                [class] => CRM_Dedupe_BAO_DedupeRuleGroup
                [type] => ::
            )

        [2] => Array
            (
                [file] => /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Contact/Page/DedupeFind.php
                [line] => 98
                [function] => getMergeCacheKeyString
                [class] => CRM_Dedupe_Merger
                [type] => ::
            )

        [3] => Array
            (
                [file] => /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php
                [line] => 319
                [function] => run
                [class] => CRM_Contact_Page_DedupeFind
                [type] => ->
            )

        [4] => Array
            (
                [file] => /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php
                [line...

***LAST ERROR***

***LOGGED IN USER***
contact_id:         102
display_name:       twowheeler
email_id:           26354
email:              hideuser@thehcpac.org
id:                 102

REMOTE_ADDR: 172.70.111.132
HTTP_X_FORWARDED_FOR: 72.72.162.120
HTTP_USER_AGENT: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:124.0) Gecko/20100101 Firefox/124.0

***SERVER***
SERVER_SOFTWARE:    Apache/2.4.52 (Ubuntu)
REQUEST_URI:        /wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcontact%2Fdedupefind
HTTP_AUTHORIZATION:
HTTPS:              on
SSL_TLS_SNI:        thehcpac.org
HTTP_HOST:          thehcpac.org
HTTP_CONNECTION:    Keep-Alive
HTTP_ACCEPT_ENCODING:gzip, br
HTTP_X_FORWARDED_FOR:72.72.162.120
HTTP_CF_RAY:        868f40ceed581899-EWR
CONTENT_LENGTH:     356
HTTP_X_FORWARDED_PROTO:https
HTTP_CF_VISITOR:    {\"scheme\":\"https\"}
HTTP_USER_AGENT:    Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:124.0) Gecko/20100101 Firefox/124.0
HTTP_ACCEPT:        text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8
HTTP_ACCEPT_LANGUAGE:en-US,en;q=0.5
HTTP_REFERER:       https://thehcpac.org/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcontact%2Fdedupefind&reset=1&rgid=15&action=preview
CONTENT_TYPE:       application/x-www-form-urlencoded
HTTP_ORIGIN:        https://thehcpac.org
HTTP_UPGRADE_INSECURE_REQUESTS:1
HTTP_SEC_FETCH_DEST:document
HTTP_SEC_FETCH_MODE:navigate
HTTP_SEC_FETCH_SITE:same-origin
HTTP_SEC_FETCH_USER:?1
HTTP_SEC_GPC:       1
HTTP_COOKIE:        wordpress_sec_e339517222a676ebe445783c89e39752=hideuser%7C1711281978%7CHV1ERL3iRu6L2DRJNtIIYnTKgX84DFUZFF1VMszRUKX%7C4ecb97d47cf3373deadfee0dfb3c87d3e3c38f88b6d9c60752be29238fdb852b; cf_clearance=mdGH2Z_dfCvGnxH9iqiuJaBYYp5aJ7Daug9lUM.SU9o-1711205237-1.0.1.1-hh3GpIKge0NS8yzGC7vLt5YlsQ1WGjM8ur0wPTs5yfdeihHsCepPdekH6hKmiDtIEWqz0MEP1zdyFdYPQmzBzw; wp-settings-1=imgsize%3Dmedium%26ampeditor%3Dtinymce%26amplibraryContent%3Dbrowse%26ampurlbutton%3Dcustom%26ampadvImgDetails%3Dshow%26amppost_dfw%3Doff%26amphidetb%3D1%26ampalign%3Dleft%26ampeditor_plain_text_paste_warning%3D2%26ampmfold%3Do%26ampuploader%3D1%26ampcats%3Dpop%26libraryContent%3Dbrowse%26align%3Dleft%26editor%3Dtinymce%26urlbutton%3Dnone%26hidetb%3D1;
wp-settings-time-1=1710349956; PHPSESSID=m0ld981tur807gg20l0dtivldt; sbjs_migrations=1418474375998%3D1; sbjs_current_add=fd%3D2024-03-22%2021%3A22%3A52%7C%7C%7Cep%3Dhttps%3A%2F%2Fthehcpac.org%2Fnite-at-the-races%2F%7C%7C%7Crf%3Dhttps%3A%2F%2Fmail.google.com%2F; sbjs_first_add=fd%3D2024-03-20%2011%3A59%3A08%7C%7C%7Cep%3Dhttps%3A%2F%2Fthehcpac.org%2F%7C%7C%7Crf%3D%28none%29; sbjs_current=typ%3Dreferral%7C%7C%7Csrc%3Dmail.google.com%7C%7C%7Cmdm%3Dreferral%7C%7C%7Ccmp%3D%28none%29%7C%7C%7Ccnt%3D%2F%7C%7C%7Ctrm%3D%28none%29%7C%7C%7Cid%3D%28none%29; sbjs_first=typ%3Dtypein%7C%7C%7Csrc%3D%28direct%29%7C%7C%7Cmdm%3D%28none%29%7C%7C%7Ccmp%3D%28none%29%7C%7C%7Ccnt%3D%28none%29%7C%7C%7Ctrm%3D%28none%29%7C%7C%7Cid%3D%28none%29;
sbjs_udata=vst%3D5%7C%7C%7Cuip%3D%28none%29%7C%7C%7Cuag%3DMozilla%2F5.0%20%28X11%3B%20Ubuntu%3B%20Linux%20x86_64%3B%20rv%3A124.0%29%20Gecko%2F20100101%20Firefox%2F124.0; wordpress_logged_in_e339517222a676ebe445783c89e39752=hideuser%7C1711281978%7CHV1ERL3iRu6L2DRJNtIIYnTKgX84DFUZFF1VMszRUKX%7C0c47e5831cee1d9bd3bad211ef618a3c47507b31251e32dceb3a9d219a0cd856; po_assigned_roles[0]=administrator; tk_ai=woo%3A%2BJtu1CoogwOOrBj0lGBcT7Ei; wordpress_test_cookie=WP%20Cookie%20check; wp_lang=en_US; wp_woocommerce_session_e339517222a676ebe445783c89e39752=1%7C%7C17...
HTTP_CF_CONNECTING_IP:72.72.162.120
HTTP_CDN_LOOP:      cloudflare
HTTP_CF_IPCOUNTRY:  US
PATH:               /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin
SERVER_SIGNATURE:   <address>Apache/2.4.52 (Ubuntu) Server at thehcpac.org Port 443</address>

SERVER_NAME:        thehcpac.org
SERVER_ADDR:        45.56.101.158
SERVER_PORT:        443
REMOTE_ADDR:        172.70.111.132
DOCUMENT_ROOT:      /var/www/html
REQUEST_SCHEME:     https
CONTEXT_PREFIX:
CONTEXT_DOCUMENT_ROOT:/var/www/html
SERVER_ADMIN:       hideuser@thehcpac.org
SCRIPT_FILENAME:    /var/www/html/wp-admin/admin.php
REMOTE_PORT:        38674
GATEWAY_INTERFACE:  CGI/1.1
SERVER_PROTOCOL:    HTTP/1.1
REQUEST_METHOD:     POST
QUERY_STRING:       page=CiviCRM&q=civicrm%2Fcontact%2Fdedupefind
SCRIPT_NAME:        /wp-admin/admin.php
PHP_SELF:           /wp-admin/admin.php
REQUEST_TIME_FLOAT: 1711205629.2812
REQUEST_TIME:       1711205629

***BACKTRACE***
#0 /var/www/html/wp-content/uploads/civicrm/extensions/ca.bidon.reporterror/CRM/ReportError/Utils.php(31): reporterror_civicrm_generatereport("HCPAC", (Array:3), NULL, (Array:0))
#1 /var/www/html/wp-content/uploads/civicrm/extensions/ca.bidon.reporterror/CRM/ReportError/Handler/FormsNoReferer.php(58): CRM_ReportError_Utils::sendReport((Array:3), (Array:0))
#2 /var/www/html/wp-content/uploads/civicrm/extensions/ca.bidon.reporterror/reporterror.php(130): CRM_ReportError_Handler_FormsNoReferer::handler((Array:3), (Array:0))
#3 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(431): reporterror_civicrm_handler((Array:3))
#4 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(39): CRM_Core_Error::handleUnhandledException(Object(CRM_Core_Exception))
#5 /var/www/html/wp-content/plugins/civicrm/civicrm.php(1199): CRM_Core_Invoke::invoke((Array:3))
#6 /var/www/html/wp-includes/class-wp-hook.php(324): CiviCRM_For_WordPress->invoke("")
#7 /var/www/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters("", (Array:1))
#8 /var/www/html/wp-includes/plugin.php(517): WP_Hook->do_action((Array:1))
#9 /var/www/html/wp-admin/admin.php(259): do_action("toplevel_page_CiviCRM")
#10 {main}

```

# Answer
I found this was caused by a conflict with another plugin. Solved with the awesome "Freesoul Deactivate Plugins" to isolate them from each other.
> 1 votes

---
Tags: dedup, fatal
---


title: Civi Report Errors

text:
# Question
Title: Civi Report Errors
WordPress v6.4.3 CiviCRM v5.71.1 PHP 8.1

Happens on ALL reports when I click view, the report name, or try to print. I can download csv, pdf, etc. no problem.

Unable to load template 'file:CRM/Report/Form/Actions-civiexportexcel.tpl'

SmartyException: "Unable to load template 'file:CRM/Report/Form/Actions-civiexportexcel.tpl'"

#0 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/packages/smarty3/vendor/smarty/smarty/libs/sysplugins/smarty\_internal\_templatebase.php(232): Smarty\_Internal\_Template-\>render() #1 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/packages/smarty3/vendor/smarty/smarty/libs/sysplugins/smarty\_internal\_templatebase.php(116): Smarty\_Internal\_TemplateBase-\>\_execute() #2 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Region.php(81): Smarty\_Internal\_TemplateBase-\>fetch() #3 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Region.php(157): CRM\_Core\_Region-\>{closure}() #4 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Smarty/plugins/block.crmRegion.php(26): CRM\_Core\_Region-\>render() #5 /home/xxxxxxxxx/public\_html/wp-content/uploads/civicrm/templates\_c/en\_US/06/6f/27/066f273e3bc81941e52aa247976e0c98a8a879c5\_0.file.CMSPrint.tpl.php(107): smarty\_block\_crmRegion() #6 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/packages/smarty3/vendor/smarty/smarty/libs/sysplugins/smarty\_template\_resource\_base.php(123): content\_6606979e70f106\_96301231() #7 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/packages/smarty3/vendor/smarty/smarty/libs/sysplugins/smarty\_template\_compiled.php(114): Smarty\_Template\_Resource\_Base-\>getRenderedTemplateCode() #8 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/packages/smarty3/vendor/smarty/smarty/libs/sysplugins/smarty\_internal\_template.php(216): Smarty\_Template\_Compiled-\>render() #9 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/packages/smarty3/vendor/smarty/smarty/libs/sysplugins/smarty\_internal\_template.php(385): Smarty\_Internal\_Template-\>render() #10 /home/xxxxxxxxx/public\_html/wp-content/uploads/civicrm/templates\_c/en\_US/5d/90/9f/5d909f92961b431fc2d54bee9fae0a5ba90bcd2f\_0.file.wordpress.tpl.php(31): Smarty\_Internal\_Template-\>\_subTemplateRender() #11 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/packages/smarty3/vendor/smarty/smarty/libs/sysplugins/smarty\_template\_resource\_base.php(123): content\_6606979e6fd910\_59616770() #12 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/packages/smarty3/vendor/smarty/smarty/libs/sysplugins/smarty\_template\_compiled.php(114): Smarty\_Template\_Resource\_Base-\>getRenderedTemplateCode() #13 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/packages/smarty3/vendor/smarty/smarty/libs/sysplugins/smarty\_internal\_template.php(216): Smarty\_Template\_Compiled-\>render() #14 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/packages/smarty3/vendor/smarty/smarty/libs/sysplugins/smarty\_internal\_templatebase.php(232): Smarty\_Internal\_Template-\>render() #15 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/packages/smarty3/vendor/smarty/smarty/libs/sysplugins/smarty\_internal\_templatebase.php(116): Smarty\_Internal\_TemplateBase-\>\_execute() #16 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php(117): Smarty\_Internal\_TemplateBase-\>fetch() #17 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php(83): CRM\_Core\_QuickForm\_Action\_Display-\>renderForm() #18 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM\_Core\_QuickForm\_Action\_Display-\>perform() #19 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML\_QuickForm\_Controller-\>handle() #20 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(355): HTML\_QuickForm\_Page-\>handle() #21 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Wrapper.php(98): CRM\_Core\_Controller-\>run() #22 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Report/Page/Instance.php(75): CRM\_Utils\_Wrapper-\>run() #23 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(323): CRM\_Report\_Page\_Instance-\>run() #24 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(69): CRM\_Core\_Invoke::runItem() #25 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(36): CRM\_Core\_Invoke::\_invoke() #26 /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm.php(1231): CRM\_Core\_Invoke::invoke() #27 /home/xxxxxxxxx/public\_html/wp-includes/class-wp-hook.php(324): CiviCRM\_For\_WordPress-\>invoke() #28 /home/xxxxxxxxx/public\_html/wp-includes/class-wp-hook.php(348): WP\_Hook-\>apply\_filters() #29 /home/xxxxxxxxx/public\_html/wp-includes/plugin.php(517): WP\_Hook-\>do\_action() #30 /home/xxxxxxxxx/public\_html/wp-admin/admin.php(259): do\_action() #31 {main}

Print Error

Type DB\_Error Code -1 Message DB Error: unknown error Mode 16 UserInfo INSERT IGNORE INTO civicrm\_tmp\_e\_logsummary\_f95db9d2fbd26ef6a252e33c2c3825e4 SELECT entity\_log\_civireport.id as log\_civicrm\_entity\_id, 1, entity\_log\_civireport.log\_action as log\_civicrm\_entity\_log\_action, 'log\_civicrm\_value\_contact\_areas' as log\_civicrm\_entity\_log\_type, entity\_log\_civireport.log\_user\_id as log\_civicrm\_entity\_log\_user\_id, entity\_log\_civireport.log\_date as log\_civicrm\_entity\_log\_date, modified\_contact\_civireport.display\_name as log\_civicrm\_entity\_altered\_contact, modified\_contact\_civireport.id as log\_civicrm\_entity\_altered\_contact\_id, entity\_log\_civireport.log\_conn\_id as log\_civicrm\_entity\_log\_conn\_id, modified\_contact\_civireport.is\_deleted as log\_civicrm\_entity\_is\_deleted, altered\_by\_contact\_civireport.display\_name as altered\_by\_contact\_display\_name FROM `xxxxxxxxx_wp2`.log\_civicrm\_value\_contact\_areas entity\_log\_civireport INNER JOIN civicrm\_contact modified\_contact\_civireport ON (entity\_log\_civireport.entity\_id = modified\_contact\_civireport.id ) LEFT JOIN civicrm\_contact altered\_by\_contact\_civireport ON (entity\_log\_civireport.log\_user\_id = altered\_by\_contact\_civireport.id) WHERE ( 1 ) AND (entity\_log\_civireport.log\_action != 'Initialization') GROUP BY entity\_log\_civireport.log\_conn\_id, entity\_log\_civireport.log\_user\_id, EXTRACT(DAY\_MICROSECOND FROM entity\_log\_civireport.log\_date), entity\_log\_civireport.id ORDER BY entity\_log\_civireport.log\_date DESC \[nativecode=1114 \** The table 'civicrm\_tmp\_e\_logsummary\_f95db9d2fbd26ef6a252e33c2c3825e4' is full\] DebugInfo INSERT IGNORE INTO civicrm\_tmp\_e\_logsummary\_f95db9d2fbd26ef6a252e33c2c3825e4 SELECT entity\_log\_civireport.id as log\_civicrm\_entity\_id, 1, entity\_log\_civireport.log\_action as log\_civicrm\_entity\_log\_action, 'log\_civicrm\_value\_contact\_areas' as log\_civicrm\_entity\_log\_type, entity\_log\_civireport.log\_user\_id as log\_civicrm\_entity\_log\_user\_id, entity\_log\_civireport.log\_date as log\_civicrm\_entity\_log\_date, modified\_contact\_civireport.display\_name as log\_civicrm\_entity\_altered\_contact, modified\_contact\_civireport.id as log\_civicrm\_entity\_altered\_contact\_id, entity\_log\_civireport.log\_conn\_id as log\_civicrm\_entity\_log\_conn\_id, modified\_contact\_civireport.is\_deleted as log\_civicrm\_entity\_is\_deleted, altered\_by\_contact\_civireport.display\_name as altered\_by\_contact\_display\_name FROM `xxxxxxxxx_wp2`.log\_civicrm\_value\_contact\_areas entity\_log\_civireport INNER JOIN civicrm\_contact modified\_contact\_civireport ON (entity\_log\_civireport.entity\_id = modified\_contact\_civireport.id ) LEFT JOIN civicrm\_contact altered\_by\_contact\_civireport ON (entity\_log\_civireport.log\_user\_id = altered\_by\_contact\_civireport.id) WHERE ( 1 ) AND (entity\_log\_civireport.log\_action != 'Initialization') GROUP BY entity\_log\_civireport.log\_conn\_id, entity\_log\_civireport.log\_user\_id, EXTRACT(DAY\_MICROSECOND FROM entity\_log\_civireport.log\_date), entity\_log\_civireport.id ORDER BY entity\_log\_civireport.log\_date DESC \[nativecode=1114 \** The table 'civicrm\_tmp\_e\_logsummary\_f95db9d2fbd26ef6a252e33c2c3825e4' is full\] Civi\Core\Exception\DBQueryException: DB Error: unknown error in /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php on line 945

* DB\_Error: DB Error: unknown error in unknown on line unknown Exception trace

# Function Location

0 CRM\_Core\_Error::exceptionHandler() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:945 1 PEAR\_Error-\>\__construct() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB.php:1001 2 DB\_Error-\>\__construct() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:575 3 PEAR::\_raiseError() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:223 4 PEAR-\>\__call() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/common.php:1952 5 DB\_common-\>raiseError() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/mysqli.php:966 6 DB\_mysqli-\>mysqliRaiseError() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/mysqli.php:413 7 DB\_mysqli-\>simpleQuery() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/common.php:1241 8 DB\_common-\>query() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php:2696 9 DB\_DataObject-\>\_query() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php:1829 10 DB\_DataObject-\>query() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php:507 11 CRM\_Core\_DAO-\>query() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php:1764 12 CRM\_Core\_DAO::executeQuery() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Logging/ReportSummary.php:385 13 CRM\_Logging\_ReportSummary-\>buildTemporaryTables() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Logging/ReportSummary.php:428 14 CRM\_Logging\_ReportSummary-\>beginPostProcessCommon() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Report/Form.php:3064 15 CRM\_Report\_Form-\>beginPostProcess() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Report/Form.php:3661 16 CRM\_Report\_Form-\>postProcess() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Report/Form.php:976 17 CRM\_Report\_Form-\>preProcess() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php:748 18 CRM\_Core\_Form-\>buildForm() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php:76 19 CRM\_Core\_QuickForm\_Action\_Display-\>perform() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php:203 20 HTML\_QuickForm\_Controller-\>handle() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php:103 21 HTML\_QuickForm\_Page-\>handle() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php:355 22 CRM\_Core\_Controller-\>run() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Wrapper.php:98 23 CRM\_Utils\_Wrapper-\>run() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Report/Page/Instance.php:75 24 CRM\_Report\_Page\_Instance-\>run() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:323 25 CRM\_Core\_Invoke::runItem() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:69 26 CRM\_Core\_Invoke::\_invoke() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:36 27 CRM\_Core\_Invoke::invoke() /home/xxxxxxxxx/public\_html/wp-content/plugins/civicrm/civicrm.php:1231 28 CiviCRM\_For\_WordPress-\>invoke() /home/xxxxxxxxx/public\_html/wp-includes/class-wp-hook.php:324 29 WP\_Hook-\>apply\_filters() /home/xxxxxxxxx/public\_html/wp-includes/class-wp-hook.php:348 30 WP\_Hook-\>do\_action() /home/xxxxxxxxx/public\_html/wp-includes/plugin.php:517 31 do\_action() /home/xxxxxxxxx/public\_html/wp-admin/admin.php:259 32 {main}

# Answer
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 run composer install inside the extension folder
> 1 votes

# Answer
The fix for me was simply to disable the CiviCRM Export to Excel. Reports work perfect now. It is similar to the issue here:

https://lab.civicrm.org/extensions/civiexportexcel/-/issues/21

But different in that I am pretty well updated and it didn't fix the errors on the Extension.

I can convert on the fly so will check back on the extension down the road.
> 0 votes

---
Tags: wordpress
---


# Question
Title: Getting strange error after Activating CiviCRM in WordPress
**Note:** Search below for the '==========' pattern to jump to updates on this ticket.

I just downloaded and activated CiviCRM (Version 5.70.2) for WordPress, and I noticed a "System Status: Warning" on the CiviCRM Home Page.

* I clicked on the "View Details and Manage Alerts" link to view the "CiviCRM System Status" page.
* In the "Organization Setup" section of that page it asked me to "Please enter your organization's **name**, primary address and default FROM Email Address (for system-generated emails)."
* I clicked on **name** and this took me to the "Organization Address and Contact Info" page.
* I filled in the required fields on that page and clicked "Save" at the bottom.
* This results in an error that ends with "Could not find a valid session key." (full message below)

This is very easy to reproduce.

I poked around a bit and found a log, specifically: ./wp-content /uploads /civicrm /ConfigAndLog /**CiviCRM.1.f41ba7ebd6ad6ac9b22ac471.log**

Here is the stack trace in that log file every time I reproduce this issue:

```
 trace: {
      /home4/uvfousor/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php:872 {
        CRM_Core_Controller->invalidKeyCommon()
        >   $msg = ts("We can't load the requested web page. This page requires cookies to be enabled in your browser settings. Please check this setting and enable cookies (if they are not enabled). Then try again. If this error persists, contact the site administrator for assistance.") . '<br /><br />' . ts('Site Administrators: This error may indicate that users are accessing this page using a domain or URL other than the configured Base URL. EXAMPLE: Base URL is http://example.org, but some users are accessing the page via http://www.example.org or a domain alias like http://myotherexample.org.') . '<br /><br />' . ts('Error type: Could not find a valid session key.');
        >   throw new CRM_Core_Exception($msg);
        > }
      }
      /home4/uvfousor/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php:867 { ...}
      /home4/uvfousor/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php:316 { ...}
      /home4/uvfousor/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php:193 { ...}
      /home4/uvfousor/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller/Simple.php:49 { ...}
      /home4/uvfousor/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Wrapper.php:61 { ...}
      /home4/uvfousor/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:292 { ...}
      /home4/uvfousor/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:69 { ...}
      /home4/uvfousor/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:36 { ...}
      /home4/uvfousor/public_html/wp-content/plugins/civicrm/civicrm.php:1231 { ...}
      /home4/uvfousor/public_html/wp-includes/class-wp-hook.php:324 { ...}
      /home4/uvfousor/public_html/wp-includes/class-wp-hook.php:348 { ...}
      /home4/uvfousor/public_html/wp-includes/plugin.php:517 { ...}
      /home4/uvfousor/public_html/wp-admin/admin.php:259 { ...}
    }
  }

```

Please let me know what I need to do to resolve this issue. Thanks!

==============
Friday - Mar08: While waiting for a response from @Aidan (or anyone else) I made an attempt to gain some insight on what might be the root cause.

I initially tried to enable debugging via "Administer menu \> System Settings \> Debugging and Error Handling" - but after clicking "Save" I get the same "Could not find a valid session key" error.

So, instead, I added some debug statements using the CRM\_Core\_Error::debug\_log\_message() method. I sprinkled these debug statements in civicrm/CRM/Core/Controller.php and civicrm/CRM/Core/Key.php.

Essentially, this is what I see...

* When I click on "**name**", I see a call to the Key.php::sign() method with name=CRM\_Contact\_Form\_Domain key=...CYQ==
* I then see a composite key saved at Line Controller.php::319 that uses that "...CYQ==" key.
* When I click SAVE, I see another call to sign() with name=CRM\_Contact\_Controller\_Search, but with a different privateKey=...oKq==. This appears to overwrite the previous value.
* In the same step, I see it retrieve the composite key and call the Key.php::validate() method.
* However, I believe (this is a guess) that method is trying to validate against the most recent key (...oKq==) when it should use the "...CYQ==" key?

Hopefully, the above observations will trigger a memory for someone on this forum.

In the meantime, I am repeating my response to @Aidan (because the formatting is better in this area):

1. Yes, cookies are enabled in my browser.
2. Yes, I verified the 'CIVICRM\_UF\_BASEURL' at all steps above match the value in civicrm.settings.php.

==============
Sunday - Mar10: I don't believe this is a client issue as the same problem occurs on different PCs and different browsers. So, there must be something unique in my environment on the "https://uv4sor.org" wordpress server to explain why no one else sees this issue. **CIVICRM experts** \- What can I collect to help identify the root cause?

==============
Monday - Mar11: I chatted with Bluehost support and they said "most of the plugins works in an older version of PHP", so as an experiment they downgraded PHP Version 8.2 to Version 7.4.

Interestingly, this got me past my original strange error and I was able to update the "Organization Address and Contact Info" page.

Bluehost also tried PHP Version 8.1 but this also shows the strange error, so they put it back to Version 7.4.

This experiment suggests there is some software on the host that CiviCRM requires, but that software fails with PHP8.2 and works with PHP7.4.

Perhaps that software needs to be updated on the host, but I have no clue on how to identify it.

Does anyone on this forum have a suggestion?

==============
Tuesday - Mar12: While on PHP7.4 I successfully enabled debugging to check if it reports anything interesting. I then switched to PHP8.1 and ran my test to generate the error with debug information. It seems to report the same information described in the original error, so not to helpful. I returned PHP back to 7.4.

Thanks to @Aidan for suggesting two other experiments to check if cookies are being sent but are not getting through - which is where a firewall or caching might affect things.

* First, I set WP "Cache Level" to "Off" and tested again with PHP8.2. I then ran the test again and verified the error is still there. I returned PHP back to 7.4.
* Second, I change WordFence "Web Application Firewall Status" from "Enabled and Protecting" to "Disabled" and tested again with PHP8.2. I then ran the test again and verified the error is still there. I returned PHP back to 7.4.

Unfortunately, no progress with identifying the root cause. Please let me know if anyone has another test I can run to help explain why Civi works with PHP7.4 but fails with PHP8.x.

==============
Thursday - Mar14: We thought we had something when we saw following error:

```
[13-Mar-2024 00:02:33 UTC] PHP Warning:  session_start(): Failed to read session data: files (path: /var/cpanel/php/sessions/ea-php81) in /home4/uvfousor/public_html/wp-content/plugins/civicrm/civicrm.php on line 494

```

We wondered if Civi needs access to the "/var/cpanel" directory. Currently, that directory is owned by 'root' and not readable by 'others', specifically:

```
uvfousor@uv4sor.org [~]# ls -ld /var/cpanel
drwx--x--x 125 root root 12288 Mar 12 19:44 /var/cpanel/

```

However, I checked with the cPanel forum and they report that directory "should be the 711 root:root like you are seeing."

I am curious to learn why civicrm.php is trying to access that directory. Perhaps that will lead to the root cause.

I am interested in digging deeper with instrumenting Civi code with debug statements. Can anyone suggest a good place to start to help identify the root cause?

==============
Wednesday - Mar20: Thanks to @Aidan for suggesting something is wrong with the "save\_path" variable in the PHP8.1 environment, and suggesting I play with the **session\_save\_path()** function. I added a session\_save\_path('path/to/writable/directory') in CiviCRM's **maybe\_start\_session()** function, and my test is NOW passing.

The next step is to learn who (or what) is responsible for managing the "save\_path" variable.

# Answer
The "save\_path" value is fine which specifies the directory for the PHP session cache. The problem is that directory does not exist on the Bluehost server.

I brought this to Bluehost's attention but they initially refused to fix the issue. They eventually did correct their server after several arduous chats with Bluehost.

While waiting for Bluehost to finally fix this issue, the workaround described in my "Mar20" update allowed us to proceed.
> 1 votes

# Answer
Welcome to SE. The message says:

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

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

1. Are cookies enabled in your browser?
2. Are you using the same url to access the page as is configured in your civicrm.settings.php?
> 0 votes

---
Tags: wordpress, error
---


# Question
Title: Why would the "civicrm_queue.runner" property be missing?
I am trying to import contacts and getting the following errors:

Cannot execute queue "user\_job\_6". The "civicrm\_queue.runner" property is missing.

Any idea why?

5.61.4 wordpress

Edit: this issue fixed itself after 24 hours - using same dataset.

# Answer
I've come across a similar issue. Looking in the database I could see a row in the `civicrm_queue` table with the same name but `NULL` for `runner`.

I fixed the issue by deleting that row in the table and performing the import again. The import then worked as normal.

I have a suspicion that there may be a bug with CiviCRM core and I've created an issue for this:

https://lab.civicrm.org/dev/core/-/issues/4554

The reason that it may work sometimes and not others is that CiviCRM will choose a different job number for each import. It depends whether that particular job number has an entry in the `civicrm_queue` table as to whether the import works or not.

**Update**: this bug was fixed in CiviCRM 5.68 by https://github.com/civicrm/civicrm-core/pull/28051.
> 3 votes

# Answer
I also replicated the "civicrm\_queue.runner property be missing" issue using external ID's using the API CSV Importer. On another post Laryn points out external ID's failed, so simply do a CID to external ID mapping pre-processing first.

Sample data format
> 1 votes

# Answer
Update - got it to run, as alluded to above - to get this import to run, I repeatedly started it, noting the user\_task\_xx was different each time, and I was getting these task numbers in roughly increasing numerical order - I continued until the job number was one of those that did NOT have Null in the runner name column. So now I feel sure that those records are the issue. Does anyone know whether the records for user job can be deleted for those where the Runner Column has "null" instead of "task"? (and no, I don't know why this is bolded!)

========================

I am having this same problem with trying to import "do not email" flag for a batch of contacts. This worked fine a few days ago, but failed multiple times today. I have cut down the file to small batches and finally to one record and then eventually to just two columns ("contact ID" and "Do Not Email") and keep getting the same error. Looking at the civicrm\_queue table, I see 54 records in the civicrm\_queue table, with each row having a Name of "user\_job\_xx" where xx is a number from 1 to 59. The jobs names are in ascending order with a few numbers skipped, up to 48, which is then followed by one of the skipped numbers. So all the sequential queues have a value of "null" for the column "Name - name of the task runner". After the break in the increasing numbers, the job 7 has a runner name of "task" and all the rest also have that name. Is it possible this table is corrupted, and could some records be deleted? The post above indicates that a task number is chosen at random, so this might work next time I try it?
> 0 votes

---
Tags: import, data-import
---