# Question
Title: Which folder to put Caldera forms CiviCrm plugin in?
I'm not an IT person so please bear with me.

Trying to install Caldera Forms CiviCRM plugin but not sure which folder to locate it in. Have put it in

/wp-content/uploads/civicrm/ext

via FTP for now but it hasn't come up on the extensions list. But now I'm thinking maybe it should be in a WP folder instead of a Civi one as it links the Caldera form WP plugin to CiviCRM. So I put it in the WP ext folder but still no sign of it in the WP or Civi backend.

Where do I put it? Any ideas are much appreciated.

Just a small charity so trying to wing it on a zero bugdget as much as possible!

# Answer
> 3 votes
Caldera and Civi Caldera is a wprdpress plugin, you can locate them under wp-content/plugins/

---
Tags: caldera-forms
---


# Question
Title: How can I move my Form Processor configuration between two sites and/or reorder my actions?
I see an **Export** link when I go to **Administer menu » Automation » Form Processors**, but it seems like you need to write an extension to move the form between sites. Is this my only option?

As a related question, can I reorder my actions?

# Answer
> 4 votes
I deleted my old answer because there's a much simpler one now: Use the **Export** link next to the processor you want to copy, and use **Import Processor** on the other site to bring it in.

If you want to make a copy on the same site for testing purposes, open the exported file and change the *name* and *title* values at the top. Note that the *name* can only have lowercase letters and underscores, whereas the *title* can be whatever you want.

Reordering actions is a built-in feature now and doesn't require any trickery.

---
Tags: export, form-processor, action-provider
---


# Question
Title: Mosaico: Unable to drag and drop images into Versafix template
I'm running civiCRM 5.28.3 on Joomla 3.9.21 with Mosaico version 2.5.159...

When I try to drag an image into a content block, the dropzone in the content block resolves to a small square, and I cannot drop the image into the content block.

Here's a short video showing the issue: https://www.dropbox.com/s/v0wzy3ttw6crv1m/Mosaico%20images%202020-08-27\_15-24-53.MP4?dl=0

Anyone have some insights into how to resolve this (or how to debug it)?

# Answer
If you are in Joomla and want to edit the mosaico template, than make sure that you are logged in front end and backend of the website.

HTH

Pradeep
> 2 votes

# Answer
We found some sites where drag-and-drop stopped working post-upgrade started again once we did an extra cv flush (sorry if that is drupal speak - you can do via the UI too) - just in case it is as simple as that for you

(Edit) Hmm actually the above was for a separate post-upgrade Mosaico issue, the one relating to drag-drop images stopping was related to some path weirdness which resolved once we upgraded all other plugins (it was a WP site)
> 0 votes

---
Tags: mosaico
---


# Question
Title: DB Error: unknown error when sending CiviMail
I recently upgraded my WordPress CiviCRM from 5.25 to 5.28 and in doing so needed to migrate the SQL old 5.5 database to 5.7. The upgrades went fine, but I now have an error when trying to send group emails through CiviMail:

Error in call to Mailing\_send\_test : DB Error: unknown error

```
Aug 27 15:28:58  [error] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => exceptionHandler
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => CREATE TEMPORARY TABLE `civicrm_tmp_e_gccache_5999aedd9eade6251afdc6974a96b5b1` (contact_id int, group_id int, UNIQUE UI_contact_group (contact_id,group_id)) ENGINE=MEMORY DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1787 ** Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context.  These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions.]
    [type] => DB_Error
    [user_info] => CREATE TEMPORARY TABLE `civicrm_tmp_e_gccache_5999aedd9eade6251afdc6974a96b5b1` (contact_id int, group_id int, UNIQUE UI_contact_group (contact_id,group_id)) ENGINE=MEMORY DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1787 ** Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context.  These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions.]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="CREATE TEMPORARY TABLE `civicrm_tmp_e_gccache_5999aedd9eade6251afdc6974a96b5b1` (contact_id int, group_id int, UNIQUE UI_contact_group (contact_id,group_id)) ENGINE=MEMORY DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1787 ** Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context.  These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions.]"]
)

```

I've tried cleaning up caches but stumped for any other ideas. Please help.

Kind regards, Alex

# Answer
> 2 votes
Alex, Welcome to Civi stackexchange.

If the server is running with global transaction identifiers (GTIDs) enabled (gtid\_mode=ON), do not enable binary logging. Try turning it off

---
Tags: wordpress, civimail, mysql
---


title: Wrong tax calculation on donation pages

text:
# Question
Title: Wrong tax calculation on donation pages
When you have two items with tax, the total tax amount is calculated for the last item only. Has anyone faced this issue? Is there any configuration I am missing?

# Answer
This is core a bug and could replicate on https://dmaster.demo.civicrm.org/

Have submitted a fix for this, can you try the patch and post your comment on the PR to speedup the merge process?
> 1 votes

---
Tags: financial-accounts, taxes
---


# Question
Title: There is no valid default from email address configured for the domain
I have set Sendgrid up to send emails in Civi (smtp.sendgrid.net). I have set the from email address as my domain email address - john@johnsales.com.au. This is the same admin address set in WordPress. I have tried many different configurations. When I click Save and Send Test Email in Settings Outbound mail, I get "There is no valid default from email address configured for the domain. You can configure here ..." I have tried many things to rectify this but am not getting anywhere. Thank you.

# Answer
You would need to setup your FROM email by going to the menu item **Administer \> CiviMail \> From Email addresses**

Address format should be like

"My organization" myemail@myorganisation.com
> 1 votes

# Answer
The reason it says that it says that there is no valid from address is: You need to click the default option when you set up the from email address. I have done that and it now works. However, when I send a test email it is sending it to a domain that I mistyped. Hence it doesn't get delivered. I am trying to find out where the setting is for test emails.
> 0 votes

---
Tags: email, addresses, smtp
---


# Question
Title: D8 - can't view Contributions after upgrade to 5.28.x
When trying to View a Contribution (any Contribution) I'm getting this error on one of my D8 test sites.

```
Error: Class 'Brick\Money\Money' not found in CRM_Utils_Money::subtractCurrencies() (line 142 of /var/www/drupal/vendor/civicrm/civicrm-core/CRM/Utils/Money.php)

```

It's still at 5.28.2

# Answer
> 0 votes
I ran `root@94ecc520c552:/var/www/drupal# composer update --with-dependencies`  and it's happy now. I can see View Contribution. Not sure why - but all good again. Phew!

Detailed output copied below - nothing about brick / money -\> but this did work:

```
root@94ecc520c552:/var/www/drupal# composer update --with-dependencies
Loading composer repositories with package information
Updating dependencies (including require-dev)
Package operations: 0 installs, 7 updates, 0 removals
  - Updating civicrm/civicrm-core (5.28.2 => 5.28.3): Downloading (100%)
Download extra files for civicrm/civicrm-core
  - Installing civicrm/civicrm-core:angular (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:angular-bootstrap (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:angular-file-upload (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:angular-jquery-dialog-service (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:angular-mocks (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:angular-route (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:angular-sanitize (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:angular-ui-sortable (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:angular-ui-utils (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:angular-unsavedchanges (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:angular-xeditable (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:checklist-model (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:ckeditor (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:crossfilter-1.3.x (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:crossfilter2 (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:css-color-names (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:d3 (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:d3-3.5.x (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:datatables (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:dc-2.1.x (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:es6-promise (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:font-awesome (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:marked (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:google-code-prettify (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:jquery (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:jquery-ui (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:jquery-validation (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:jstree (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:lodash-compat (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:phantomjs-polyfill (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:select2 (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:js-yaml (5.28.3): Downloading (100%)
  - Installing civicrm/civicrm-core:smartmenus (5.28.3): Downloading (100%)
  - Updating civicrm/civicrm-drupal-8 (5.28.2 => 5.28.3): Loading from cache
  - Updating civicrm/civicrm-packages (5.28.2 => 5.28.3): Loading from cache
  - Updating drupal/smart_date (2.8.0 => 2.9.0): Downloading (100%)
  - Updating drupal/webform_civicrm (5.0.0-beta1 => 5.0.0-beta2): Downloading (100%)
  - Updating nikic/php-parser (v4.6.0 => v4.9.0): Downloading (100%)
  - Updating drush/drush (10.3.1 => 10.3.4): Downloading (100%)
Package container-interop/container-interop is abandoned, you should avoid using it. Use psr/container instead.
Writing lock file
Generating autoload files
  - CiviCRM asset map
33 packages you are using are looking for funding.
Use the `composer fund` command to find out more!
Scaffolding files for drupal/core:
  - Copy [web-root]/sites/default/default.settings.php from assets/scaffold/files/default.settings.php

```

Ran the database updates.

Oh and now I can see the View Contribution. Strange! Not sure what that could have been?

---
Tags: drupal-8
---


# Question
Title: Upgrading CiviCRM under Drupal 8: How can I get around this error?
I'm guessing that the upgrade process for CiviCRM under Drupal 8 is something like this:

1. Use `composer require` to get the latest version of the package.
2. Navigate to the database update URL through the browser (http://example.org/civicrm/upgrade?reset=1)

But trying this now, I see what appears to be a version conflict around the pear/log package:

```
$ composer require --update-with-dependencies civicrm/civicrm-core:5.28.3
./composer.json has been updated
Loading composer repositories with package information
Updating dependencies (including require-dev)
Your requirements could not be resolved to an installable set of packages.

  Problem 1
    - drupal/core-recommended 8.8.8 requires pear/pear_exception v1.0.0 -> satisfiable by pear/pear_exception[v1.0.0].
    - drupal/core-recommended 8.8.8 requires pear/pear_exception v1.0.0 -> satisfiable by pear/pear_exception[v1.0.0].
    - drupal/core-recommended 8.8.8 requires pear/pear_exception v1.0.0 -> satisfiable by pear/pear_exception[v1.0.0].
    - Can only install one of: pear/pear_exception[v1.0.1, v1.0.0].
    - Can only install one of: pear/pear_exception[v1.0.1, v1.0.0].
    - Can only install one of: pear/pear_exception[v1.0.1, v1.0.0].
    - pear/log 1.13.2 requires pear/pear_exception 1.0.1 -> satisfiable by pear/pear_exception[v1.0.1].
    - civicrm/civicrm-core 5.28.3 requires pear/log 1.13.2 -> satisfiable by pear/log[1.13.2].
    - Installation request for civicrm/civicrm-core 5.28.3 -> satisfiable by civicrm/civicrm-core[5.28.3].
    - Installation request for drupal/core-recommended (locked at 8.8.8, required as ^8.8) -> satisfiable by drupal/core-recommended[8.8.8].

Installation failed, reverting ./composer.json to its original content.

```

How can I get around this problem and upgrade CiviCRM under Drupal 8?

# Answer
> 2 votes
You can use:

(confirming this syntax)

```
karins-MBP:d8civicrm.local sysadmin$ composer require pear/pear_exception:'1.0.1 as 1.0.0'
./composer.json has been updated
Loading composer repositories with package information
Updating dependencies (including require-dev)
Package operations: 0 installs, 0 updates, 0 removals
Writing lock file
Generating autoload files
  - CiviCRM asset map
30 packages you are using are looking for funding.
Use the `composer fund` command to find out more!

```

Syntax in https://docs.civicrm.org/installation/en/latest/drupal8/ is wrong. Will put in an MR -\> https://lab.civicrm.org/documentation/docs/installation/-/merge\_requests/10

---
Tags: upgrade, drupal-8, composer
---


# Question
Title: Why does the sender not receive a bulk emailing they originate?
To test out CiviMail, I sent a message to the "administrators" mailing group, which has three members, including me. Only two emails were sent out, however. Even though I'm in the group, the mailing report only reports the two mailings to the other administrators and I did not received the message.

I do not have the "do not email" or any similar box checked in my profile.

Shouldn't bulk mailings go out to all group members, including the mailing originator?

Follow up:

This may be related: Here's an experiment.

I select my own contact and start a CiviMail mailing just to me:

(For privacy, I've omitted information here, but the email address is correct.)

I select "Email - schedule/send via CiviMail" from the pulldown.

But as you can see, CiviMail creates a "hidden smart group" that contains "No Recipients". There's nothing in my contact DB entry to prevent receipt of email.

What am I missing?

# Answer
I haven't found the cause, but I've found a fix that *seems* to work.

If I call up `Edit` on a contact and then `Save` it, even without making any changes, I am able to send that contact bulk email. I cannot be sure, but I suspect that the defective contact records were ones that were imported via CSV from another platform with an older CiviCRM release.

Yes, this seems mysterious and it doesn't exactly increase my confidence in CiviCRM. On the other hand, I'm a release or two behind on WordPress and CiviCRM, so maybe it's already been fixed.

So all I have to do now is `Edit`/`Save` all 1024 (coincidentally, I think, 2\**10) contacts in my database. Perhaps I'll make this a group project for my organization! B-)
> 1 votes

# Answer
My guess with this would be that your email is being caught by your spam rules. We normally see this issue with clients using a email gateway such as sparkpost and the email fails to be delivered to their own domain as the spam filter, or firewall, will stop emails with their domain which are not originating from their expected email gateway. My first point of call would be your networks admin to determine if this is the case, they should see the emails in the spam filters if it is and they would need to whitelist your email sending gateway (SMTP service) that CiviCRM is using.
> 0 votes

---
Tags: civimail, email
---


# Question
Title: cannot access /wp-admin/options-general.php?page=civicrm-install after installing 5.28.3
I have found it impossible to upgrade from CiviCRM 5.25 to 5.28 to get around the breakage caused by the WP upgrade from 5.4 to 5.5

My attempted solution has been to make a staging site, completely remove civiCRM and reinstall using the 5.28.3 zip file. All seems to go well including adding the UK i10n files until I go to ***/wp-admin/options-general.php?page=civicrm-install***

Where I get the message **Sorry, you are not allowed to access this page.**

As the only admin on the site, I find this strange. Any hints?

# Answer
> 3 votes
Is CiviCRM already installed?
Even if the DB is clean, does the `wp-content/uploads/civicrm` folder exist with the `civicrm.settings.php` file in it. The installer does not expect that to be there.

You shouldn't hit the install page on an upgrade. I'd expect you to go to http://example.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/upgrade&reset=1

Full docs are at https://docs.civicrm.org/sysadmin/en/latest/upgrade/wordpress/

---
Tags: wordpress, installation
---


# Question
Title: Where did my price field go? It's missing!
After a recent civicrm upgrade, one of my pricefields in a price set just 'disappeared'. There were no errors showing and the pricefield appeared to be correctly configured.

# Answer
> 3 votes
I solved this by looking in the civicrm\_price\_field table and noticed that the missing price field had an expiry date of '000-00-00 00:00:00' vs. NULL for other expiry dates. Setting the price field expiry to NULL allowed the price field to be redisplayed.

On the configuration screen, those two values both appear the same.

Conclusion: a '0000-00-00 00:00:00' in a price field row expiry field should be considered invalid/error.

---
Tags: civicontribute, price-sets
---


# Question
Title: Can webform-civicrm pre-select an event using Drupal Views?
The answer is (I hope) 'yes' but I can't get it to work - see How to select a default event in webform where event is repeating I'm pretty sure the Views side is working as it generated a url that when clicked gave me the webform with the correct event selected (this is on a Views screen). But when I run the webform I get '- None -' displayed in the event list box. Yes, I have checked "Allow events to be autoloaded from URL checked." Code is at the latest level - I went back to Webform 7.4.9 and Webform 7.4.11 to see if there had been a regression but no change.
So now I'm wondering if this is a bug in Webform-CiviCRM?

# Answer
> 0 votes
I believe this has been implemented now so that there is a setting on the Event section of the webform's civicrm tab so that you can 'allow events to be autoloaded from URL'

---
Tags: webform-civicrm, drupal-views
---


# Question
Title: WP Install: Event registration - registered by participant id
I'm sure I'm overlooking something obvious and hope someone can point me to the answer.

We had an event where people could purchase a ticket for themselves and guests (up to 3). That's all good. The thing is, I can't figure out how to run a report which shows the purchaser and who their guest/s is/are. I HAVE figured out how to see the "registered by participant ID" # (see below), but I'd love to see the name of the participant who registered the guest and I can't figure that out. I'd like to be able to see a report which shows the Registrant --\> Guest(s)

It's possible I set this up incorrectly from the get-go - I'm a Civi newbie - but I appreciate any guidance anyone can offer!

Thanks.

# Answer
> 2 votes
Late to the party here, I know - but we ended up writing code to extend the report to add a "Registered by Contact Name" column to the output here.

Happy to share this code if it's still useful.

Best Marcus

# Answer
> 1 votes
If I am not wrong you need to know the **"Registered by Participant ID"**

I guess you know to find the report from the following path (menu)

Reports =\> Event Reports =\> Attendee List OR Event Participants List

In both the reports you do have a option displaying **"columns"**

just select **"Registered by Participant ID"** which should display

I guess this helps !!!

# Answer
> 1 votes
If you are using Drupal then I would look in to building a Drupal View to deliver the required information - not having tried for this particular outcome therefore flagging that it may require views\_field\_view so that you can use that id as a Contextual filter in a related view to get that Contact's name etc

---
Tags: civievent, registration
---


# Question
Title: how to add "registered by" information to a guest that is being registered manually in the backend?
because of my workaround for this issue I occasionally need to add event participants with the role of "guest" via the admin backend. That's ok, but when I register a guest this way I'm not able to specify the "registered by" data that gets added automatically when an Attendee registers himself and multiple others using the frontend registration form. I'd like to have this info because I need to know which participant the guest belongs to.

I've been putting the name of the main Attendee into the "Participant Source" field just to capture the data, but this of course doesn't show up in the "Registered by" columns in reports.

Is there a hook I could use to copy that Participant Source field into the "registered by" field? Or am I missing a simpler solution?

Thanks! This is a Joomla 3.9.13 system with CiviCRM 5.18.2.

# Answer
Looking at the table "civicrm\_participant", I can see a field "registered\_by\_id", which is presumably the one you want.

I'd note that you're using the field in a way that isn't strictly what it was designed for - i.e. you're taking the person who registers someone else and using that as having a particular relationship to them.

So I can think of three solutions:

1. Reconsider your requirements/architecture - perhaps add a relationship or some other way of connecting the guest to the primary registrant.
2. Use an indirect way of filling the registered\_by\_id field, e.g. have custom registrant/participant field that is only exposed to administrators, and use rules or something like that to fill in registered\_by\_id when this custom field is filled.
3. Write an extension that exposes the field to the administrative form.

Short answer: no (no simpler solution).
> 1 votes

# Answer
Anyone solved this yet? It's always been a frustration that front end event bookings creates a link between the "Registered by" Contact and their Guests that can be reported on, but if an admin is then registering additional Guests for a Member, they cannot specify this same "Registered by" link to the lead Contact for the party.

This is particularly problematic for dinners, etc., where Civi admins need to put parties together on tables based on the lead event registrant.
> 0 votes

---
Tags: civievent, registration
---


title: Contribution Page Time to Submit

text:
# Question
Title: Contribution Page Time to Submit
Our contribution pages are not as fast as I would expect. What is the expected time people see to submit a CiviContribute page out of the box? Up until recently, it was reliably within 20-25s using Stripe which was at the outer limits of my expectations but serviceable.

Now contributions take from 30-35s. The increase seems to have occurred within the last month.

The factors I can see that are affecting submissions are:

* USPS standardization
* Google geocoding
* Deduping to a large database
* Stripe
* Cividesk Normalize

We also experience a cookies error intermittently after submitting a donation.

In other words, the donor does not get to the thank you page but gets the following error. The donation does succeed. This issue has persisted for a long-time. We have not seen any pattern for when it occurs. I would estimate that it occurs 10-20% of the time.

This is related: https://lab.civicrm.org/dev/core/-/issues/517 and says using PHP 7.2 resolved, but we are already on 7.2.

# Testing

* CiviCRM 5.28.3
* Processors: Stripe 6.4.2 / PayPal Standard / Authorize.net
* Browser: Chrome

Baseline time to submission: Using Stripe with USPS standardization, CiviDesk Normalize, Geocoding: 32 seconds.

Test 1 - Stripe: Disable Cividesk Normalize and USPS standardization: 35s

Test 2 - Stripe: Above and disabled Google Geocoding + Geofill: 29s

Test 3 - Authorize.net and enabled above extensions: 23s

Test 4 - Authorize.net and disabled above extensions: 23s

Test 5 - PayPal Standard and enabled above extensions: 17s

Test 6 - PayPal Standard and disabled above extensions: 17s

So it appears to be related to Stripe.

For reference civicrm.org runs Stripe and donating there it took 7s to confirmation page and 9s to submit.

**Update: The common factors of the slowness is WP + large database + Stripe.**

Ref: https://lab.civicrm.org/extensions/stripe/-/issues/246

# Answer
> 2 votes
17 seconds from pressing "Submit" to the thank-you page is still obscenely high. My only client who comes close to this has maybe 80 extensions installed. My guess is you have something going on already that's exacerbated by Stripe.

While it's not the easiest solution, doing an xdebug profiling session would be really helpful here. E.g. I once found a bug in the token processor that made contact creation take a long time - and when I added an extension with custom tokens, the problem got even worse. Something comparable may be happening here.

---
Tags: civicontribute, payment-processor, stripe
---


# Question
Title: Moving contribution from individual to organization
I have a contact in CiviCRM that is of contact-type Individual in CiviCRM. In real life, this is an organization.

I want to convert this contact from an Individual to an Organization. How do I do that?

(I could just delete the contact, and create a new contact, but I really want to keep the contribution history. So then I would need to move that from one contact to another. Using merge contacts only works within same contact-type. So this solution doesn’t seem to work either)

# Answer
Run below query in mysql

```
UPDATE civicrm_contact
SET contact_type = 'Organization',
organization_name = sort_name
WHERE id = 123;

```

123 is a contact id
> 4 votes

# Answer
Alternatively - you can try install/use:

https://civicrm.org/extensions/move-contribution
> 4 votes

---
Tags: duplicate-contacts, contact-types
---


# Question
Title: membershipTypeValues hook not updating membership price
On my civicrm contribution page I have a field that I want to use to calculate the membership price.

Currently Im trying to use the membershipTypeValues hook to edit the price after the contribution page has been submitted

Heres the code

```
add_filter('civicrm_membershipTypeValues', "updatePrice", 10, 2);

function updatePrice(&$form, &$membershipTypeValues) {
    $membershipTypeValues[14]['minimum_fee'] = "40.00";
}

```

Theoretically this should change the membership price to $40 but the price doesn't change on the conformation screen.

The code runs and if I print out the $membershipTypeValues array I can see the minimum fee has changed to $40

Any ideas on how to fix this would be great

Thank you

# Answer
I think you need to use hook\_civicrm\_buildAmount or hook\_civicrm\_buildForm hook to change the amount on front end contribution/event pages for priceset or line items.
> 2 votes

---
Tags: civicontribute, civimember, php, hooks
---


# Question
Title: Is there a way to create specific permissions for a tab of information?
Is there a way to add more permissions to custom tabs that we add to Civi? I would like certain tabs of information in a contact record viewable/editable to some users but not to other users. Thanks.

# Answer
> 2 votes
You can control the tabs on contact summary page via Contact Layout extension.

---
Tags: contacts, permissions
---


# Question
Title: How do I send an email to all event participants immediately?
I know you can schedule reminders, but you can't choose a date and time, only a date (when does it send if you choose the same day?), otherwise you have to choose a time before the event or after the event.

I just want to send an email right now and I don't want to have to create a group to do it. This is a basic feature in competing platforms - is there something obvious i am missing?

# Answer
If your event has more than 50 participants, then you could install the 'Transactional Email' extension, (nz.co.fuzion.transactional), which allows you to send emails using CiviMail to search results. We use this for many purposes.

It has really helped us to be able to send an email to event participants/members, using the full capabilities of CiviMail - draft emails, result tracking, spam protection, etc etc.

If people have booked on an event or a membership with your organisation then European GDPR rules allow you to email them, since they are deemed to be interested in you. (Providing, of course, that your email is actually about what they booked! :-) ).
> 3 votes

# Answer
Can you create a activity reminder of type event registration and send the reminder after 0 hour of activity date time?
> 2 votes

# Answer
You can go to where you see your event participants list, select the participants, click Actions and click Email - send now(to 50 or less).

Obviously you can only use this option properly if the number of participants is less than 50.
> 0 votes

# Answer
You can create a smart group of all participants, and then send a mailing to the group members.
> 0 votes

# Answer
You could probably set this up via CiviRules where the Trigger is 'registration activity' and the filters are for Event X and the Action is 'send email' (needs email api extension as well as civirules)
> 0 votes

---
Tags: civievent, civimail
---


# Question
Title: How to allow parents to register children but still record their own info
For class registrations, parents register their children, but they don't need to register themselves (because they won't be attending the class). Has anyone come up with a way to handle this, that allows us to capture the parent and students as regular contacts, vs resorting to a profile of custom participant fields?

I've looked into the Youth Registration extension, but there are open issues stating that it isn't compatible with 4.4 (and we're on 4.5.8).

Edit: Webform-CiviCRM is Drupal-specific, so is not an option for this organization.

# Answer
I've gotten the desired result by creating a custom WP page to capture parent information and the jQuery Repeater plugin to capture unlimited students and registrations. It displays checkboxes for all future events of a given Event Type. The form posts to a PHP page that creates the contacts, relationships, and event registrations via the API. I'm still playing with it, but you can get the code here. The client takes deposits and multiple payments for the student camps, so there is no contribution or payment code involved at this point.
> 3 votes

# Answer
If you're using Drupal, Webform-CiviCRM Integration will handle your scenario pretty easily. It allows registering any number of participants for any number of events on a single form.

You may also want to e-mail Sarah Gladstone, the author of the Youth Registration extension, what she uses instead - but I'm pretty sure they use Webform-CiviCRM integration these days.
> 11 votes

# Answer
Contributing or sponsoring upgrades to the youth-registration extension seems like a good option for you. The extension has already been written and seems to need minimal maintenance to get it working with the latest version of CiviCRM.

Short of that, your current options are limited. You could set up your registration form in such a way that the child's information gets entered as the participant, with the parent's billing info and some custom data fields to enter parental and emergency contact info. This would not create contacts in the db for the adults but at least the information would exist.
> 7 votes

# Answer
I use WebForm-CiviCRM integration module (https://civicrm.org/extensions/webform-civicrm-integration) for my school/youth registration requirements. (I had sponsored the creation of the youth registration extension back when webform-civicrm integration was not as robust)
> 4 votes

# Answer
As you note, there is an open issue for the Youth Registration extension relating to 4.4.0. However, there was a PR merged in Sept 2014 to make it work on 4.4.6.

I don't know whether those changes are enough to make it work on 4.5.8, but if WebForm-CiviCRM is not an option for you, then it would be worth trying the current version.
> 3 votes

# Answer
In order to register children for a class, I added custom profiles, using custom fields in CiviCRM (See under 'Customize Data and Screens'). The core registrant data is the parent's (as they're paying for the class), and the custom profiles allow for up to 3 children's names, ages, gender, school they attend, etc.
> 3 votes

# Answer
Since this is a WordPress specific question I believe these sorts of forms can be built using the Caldera forms integration for CiviCRM.
> 0 votes

---
Tags: civievent, wordpress, webform-civicrm
---


# Question
Title: Contact Us form based on smart group list
I am getting started with Webforms on Drupal and am looking to create a Contact Us form.

I would like a single form that would allow the user to select the Send To field based on a Smart Group. The group has a list of committee members based on a range of Membership IDs.

A drop down or single selection list is what I would like the user to select from as one of the elements of the form.

Any help or suggestions would be appreciated.

# Answer
> 1 votes
You could try enabling 'Groups' on the Civi processing tab set to user select and then limit the options of groups on the Webform tab in the configuratation for the group component. Once that's done you can set the email to 'Value of "Group(s)'.

# Answer
> 0 votes
If I understand your use case correctly -\> I would suggest to:

1. create a View of Contacts -\> Filter by Group -\> expose the Filter so users can select the list of Contacts they would like to see
2. add a link in the View for each row/result -\> a button to a Contact form -\> pass in the Email address of the Contact to the Webform as an argument
3. in the Webform -\> receive the argument and make that the Email to field.
4. configure your webform to send an email to that Email to field.

---
Tags: webform-civicrm, drupal-8
---


title: civicrm upgrade access denied

text:
# Question
Title: civicrm upgrade access denied
I have upgraded drupal to 7.72 - (28/8/20). I wanted to update Civicrm from 5.9.1 to 5.10.0 but got "Access denied" after running http://mysite/civicrm/upgrade?reset=1. So I tried going to 5.28.3 but ended up with the same issue. I am logged in to Drupal on another tab and can log in to drupal.

# Answer
I used another browser (edge from chrome), I logged in to Drupal and then used the upgrade command in the same window and it worked.
> 0 votes

# Answer
Yes, Google Docs Offline, Google Keep Chrome Extension and IE Tab. A good thought for next time. Have you experienced something with these on this issue?
> 0 votes

---
Tags: drupal, upgrade, accessibility
---


title: Getting templates images on Mosaico

text:
# Question
Title: Getting templates images on Mosaico
in Mosaico templates the images the images can't be seen. I don't understand why they are uploaded through this link:

```
GET https://mydomain.com/mosaico/img/?method=placeholder&params=534,200

[HTTP/1.1 401 not found]

```

I think normally it should be `https://mydomain.com/civicrm/mosaico/img/?method=placeholder&params=534,200`, but both these url give me "401 not found" and CIVICRM\_CLEANURL is enabled.

This is my configuration:

CiviCRM Version: 5.28.0 on Wordpress
Mosaico 2.4.1592820024
Wordpress: 5.5

Thank you for your answers.

# Answer
> 1 votes
It turns out this is actually to do with the base page url - it should **not** have a trailing slash. @massetto knows this I think, because he created the GitHub issue where this is explained so this answer is really for anyone else looking at this later.

From Matt Wire of Veda:

> Check your CiviCRM paths/resource URLs and make sure that you are not overriding them if you don't need to.
>
> In CiviCRM make sure that "Wordpress Base Page" is setup as "civicrm" with no "/" - see civicrm/civicrm-core#18332 so this will be fixed in 5.29.
>
> In Wordpress make sure you have a CiviCRM base page (should be at https://yoursite.com/civicrm). Important: Go to Settings -\> Permalinks and click "Save Changes".
>
> Now Mosaico images should work and navigating to https://yoursite.com/civicrm/mosaico/img should give a 200 OK and a blank page.

v5.29 is available now, so sounds like upgrading to that should resolve the problem.

# Answer
> 0 votes
This is likely to be a permissions error in your `wp-content/uploads/civicrm/ext` directory. You can probably resolve this by assigning ownership to `www-data`.

e.g. if your site is installed at `/var/www/html` then you can fix this with:

```
chown -R www-data:www-data /var/www/html/wp-content/uploads/civicrm

```

I've often thought it would be easier if Mosaico stored images in the WordPress image library but presumably this isn't possible with a multi-CMS extension.

---
Tags: mosaico
---


title: Users denied unsubscribe function

text:
# Question
Title: Users denied unsubscribe function
Using CiviCRM generated URLs in the mandatory footer of a Civimail bulk mailing users are presented with error: CiviCRM You do not have permission to access this content.

The url form is: https://example.org.uk/civicrm/?civiwp=CiviCRM&q=civicrm%252Fmailing%252Funsubscribe&reset=1&jid=8909&qid=254938&h=7be20f8b9c9c9389

Why are users being denied access?

# Answer
> 2 votes
Welcome to civicrm SE, Can you make sure if you have 'CiviMail: access CiviMail subscribe/unsubscribe pages' permission set to anonymous and autheticated sure?

Can Check under CiviCRM \>\> Administer \>\> Users and Permissions \>\> Permissions (Access Control) \>\> WordPress Access Control

---
Tags: permissions
---


# Question
Title: Civicrm update failed - from 5.19.2 to 5.29.0 - Drupal7 error log - page not found
Update failed - Get initial upgrade screen with message template warnings & The database will be upgraded from 5.19.2 to 5.29.0.. ..see screenshot of following page when I click "Upgrade Now". Screen distorted (see below) and stops. Upgrade doesn't work.

Drupal error log - first of many messages - "page not found"

Example: LOCATION https://mysite.org/drupal//home/mysite/public\_html/drupal/sites/all/modules/civicrm/bower\_components/jquery-ui/themes/smoothness/jquery-ui.min.css REFERRER https://mysite.org/drupal/civicrm/upgrade?reset=1 MESSAGE home/mysite/public\_html/drupal/sites/all/modules/civicrm/bower\_components/jquery-ui/themes/smoothness/jquery-ui.min.css

# Answer
check you drupal directory path in your apache/nginx conf. If its different than 'home/mysite/public\_html/drupal' either you can change in apache/nginx conf or replace $civicrm\_root and template\_c path in civicrm.settings.php

Or add below line at the end of the file in civicrm.settings.php

```
global $civicrm_paths;
$civicrm_paths['civicrm.root']['url'] = CIVICRM_UF_BASEURL . 'sites/all/modules/civicrm/';

```

NOTE: make sure you have '/' at the end for CIVICRM\_UF\_BASEURL value.
> 2 votes

---
Tags: drupal, upgrade
---


# Question
Title: Missing more menu options three dots/vertical ellipsis (⋮) within administration interfaces
I've created some custom data and fields that I now need to delete, but I don't see any options for deletion- only the option to add. Also, I'm unable to edit a custom data group once it's created.

I've also noticed additional administration options are also missing in other CiviCRM administration interfaces e.g. membership renewal, delete, auto-renewal and billing detail options.

# Answer
If you have CiviCRM shoreditch extension enabled on your site than try adding below line in your theme css file

```
.crm-container span.btn-slide {
    display: unset !important;
}

```

Thanks Pradeep
> 5 votes

# Answer
Shoreditch is officially designed to work with 5.24.2 so expect issues when running it with the latest CiviCRM security release.

You may just want to disable it!
> 3 votes

---
Tags: custom-fields, admin
---


# Question
Title: CiviMobileAPI / CiviCRM WP REST API error, and possibly related: WordPress - Site Health reporting REST API errors
## Issue started when getting an error when trying to authenticate with CiviMobile - via phone. I msged the CiviMobile folk and they replied, copying me with this note:

## When we use any CIviCRM API (For example: https://chasethemusic.org/wp-json/civicrm/v3/rest?entity=Contact&action=get&api\_key=(\*KEY1\*)&key=(\*KEY2)&json={"sequential":1}) we have the next error: { "code": "rest\_not\_logged\_in", "message": "You are not currently logged in.", "data": { "status": 401 } } . But we still think the problem related with WordPress code (plugins, maybe Core code). You can also address issue about this error to developers of "CiviCRM WP REST API" plugin(https://github.com/mecachisenros/civicrm-wp-rest).

At this point, I noticed a Word Press Site Health error - The REST API request failed due to an error. Error: \[\] cURL error 28: Operation timed out after 10001 milliseconds with 0 bytes received

and also a loopback error - The loopback request to your site failed, this means features relying on them are not currently working as expected. Error encountered: (0) cURL error 28: Operation timed out after 10001 milliseconds with 0 bytes received\_

I disabled all WordPress plugins. Then, added them back. Turns out re-activating CiviCRM brings back these errors (which may be the cause of the problem with CiviMobile?).

WordPress Site Health contains critical errors unless CiviCRM is disabled makes it seem like the problem/error isn't real. So, maybe it's not related to the CiviMobile API / CiviCRM WP REST API situation? But???

I don't know if you have any other hints on where I should look.

CiviCRM 5.28.2 WP 5.5.1 PHP 7.4.9 CiviMobileAPI 5.3.0 CiviCRM WP REST API 0.1

THANKS! ..clark

# Answer
I was under the assumption that you do not require CiviCRM WP REST API plugin anymore if you are on 5.28.x

To ignore the Site Health error you install a small plugin that i have created.
> 1 votes

---
Tags: wordpress, rest, civimobile
---


# Question
Title: CiviCRM admin menu not visible in Wordpress
Hi I am running CiviCRM **5.29.0** on Wordpress **5.5.1**. Recently the admin menu for CiviCRM has disappeared which prevents me from managing the CiviCRM database. Any suggestions how to fix it.

I am running CiviCRM Admin Utilities v .0.7.3.

I tired clearing caches, rebuilding menu, clearing URL's but nothing appears to work.

Any ideas greatly appreciated.

# Answer
> 1 votes
Turns out the problem is related to the latest install of the **UK Gift Aid** extension v 3.4.4. Disabling the extension brings back the menus.

# Answer
> 0 votes
Kevin's suggestion to look at the browser console is a good suggestion - you do this by pressing "F12" on your keyboard and selecting the "Console" tab. Also check the "Network" tab for errors (you'll need to reload the page after selecting the tab). Updating the question with info you find there will help people troubleshoot.

Additionally, https://mysite.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/admin will bring you to a page with most of the options on the "Administer" menu, which you'll probably need to fix this. The most common cause of this problem is that your Resource URL is incorrect, or possibly your Directories settings.

This may be a problem caused by your webhost; you may need to check if they created "symlinks" or otherwise moved your file location. If so, you'll need to update the Directories settings to accommodate that (and use the non-symlink version if applicable).

---
Tags: wordpress, menu, admin
---


# Question
Title: What is the best way to collect and store event feedbacks?
I am looking for a solution where I could collect feedback with an automated email after the event. I figured, I could use schedule reminder for the emailing part.

But stuck with the step of collecting feedback in a way which could show a visual graph of the feedback submitted, as well as keeping the feedback record within contact record with event details (at least title & date).

I could create a set of custom field for contact as a table. This would allow me to keep multiple record of events feedback. Then add the custom fields to a profile and add checksum link to the scheduled reminder mail. But I cant get the event name pre-selected within the profile/custom field.

Has anyone tried any sort of work on this or any workaround? Any help would be very much appreciated. Thanks.

# Answer
I would use webform and on submission create a activity of type 'XYZ'.
> 1 votes

---
Tags: civievent, civicrm-event
---


# Question
Title: CSS problems on Contact Notes View modal dialog
When viewing or editing a note attached to a contact, the dialog window displays the note content shifted far to the right. This is a new problem, but I'm not sure if it's a result of installing a WP plugin, or upgrading to CiviCRM 5.27.3 or 5.28.0. The issue seems to be with the jQuery class **ui-dialog-content**.

Anyone else seeing this? Any suggestions for finding the cause of the problem? Thanks in advance.

Wordpress 5.5, CiviCRM 5.28.0

# Answer
Turns out it was a CSS conflict with the Woocommerce Event Manager plugin in WordPress. In fact it was affecting the formatting of many different modal dialog windows in CiviCRM, not just the Contact Notes dialog.

In case anyone's interested, I tracked it down by opening the misbehaving dialog in CiviCRM, then used Chrome -\> Developer Tools -\> Elements to identify the div with the right-shift problem. The CSS hierarchy for this element showed (in the 'Styles' pane) that the CSS heirarchy was interrupted (Jquery UI classes were struckthrough), and it gave the CSS filename, which gave a clue to the identity of the naughty WP plugin.

Of course, I could have just deactivated each WP plugin in turn...
> 1 votes

---
Tags: css, jquery
---


# Question
Title: Migrate from Drupal to WordPress - 'DB Error: no such table'
I'm following the methodology at https://docs.civicrm.org/sysadmin/en/latest/misc/switching-cms/drupal-to-wordpress/ to migrate from Drupal to WordPress. After importing the database tables to the WordPress site, I get the error `DB Error: no such table` in the browser when I try to access the CiviCRM front page.

In the `wp-content/uploads/civicrm/ConfigAndLog/CiviCRM.f00.log`, I see the following:

```
Sep 06 22:24:15  [error] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_setting (`component_id`,`contact_id`,`created_date`,`created_id`,`domain_id`,`id`,`is_domain`,`name`,`value`) VALUES
(NULL,NULL,"20200906222415",NULL,"1",NULL,"1","wpLoadPhp","s:34:\"/home/singersin/www/wp/wp-load.php\";")
 [nativecode=1146 ** Table 'singersin_wp1234.log_civicrm_setting' doesn't exist]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_setting (`component_id`,`contact_id`,`created_date`,`created_id`,`domain_id`,`id`,`is_domain`,`name`,`value`) VALUES
(NULL,NULL,"20200906222415",NULL,"1",NULL,"1","wpLoadPhp","s:34:\"/home/singersin/www/wp/wp-load.php\";")
 [nativecode=1146 ** Table 'singersin_wp1234.log_civicrm_setting' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_setting (`component_id`,`contact_id`,`created_date`,`created_id`,`domain_id`,`id`,`is_domain`,`name`,`value`) VALUES
(NULL,NULL,"20200906222415",NULL,"1",NULL,"1","wpLoadPhp","s:34:\"/home/singersin/www/wp/wp-load.php\";")
 [nativecode=1146 ** Table 'singersin_wp1234.log_civicrm_setting' doesn't exist]"]
)

```

What puzzles me: why is it looking for a table called `log_civicrm_setting` when it's doing `INSERT INTO civicrm_setting`? There is a table called `civicrm_setting`, all CiviCRM tables are prefixed with `civicrm_` in this installation.

# Answer
This is down to the fact that you probably have logging turned on in your Drupal environment. So the easiest thing to do would be to turn it off before you migrate and turn it back on in Wordpress (Administer -\> Misc -\> Logging). If you cant do that (or it still doesn't work) then you have a couple of 'hacks' to make get to the point that you can at least get to the settings, including dropping the database triggers on the settings table, and any subsequent tables, until you get to the home page and to the logging page. But I would turn off at the source, thats the easiest approach.
> 4 votes

---
Tags: wordpress, database, migration
---


title: Need historical address information

text:
# Question
Title: Need historical address information
I inadvertently changed an address on a contact and need to change it back to it's previous address. How do I find historical address information?

# Answer
This is only possible if you have "detailed logging" enabled. If not, you'll need to restore a backup copy of your database (to a test server!) and do a comparison.

You can check to see if you have detailed logging enabled at **Administer menu » System Settings » Misc**, under Logging (see screenshot). If you do NOT have this enabled, please read the logging documentation before enabling it. If you have shared hosting, you may not be allowed to turn this on; if you run CiviCRM on your own server or VPS, then you should have no problem.

If you DO have detailed logging enabled:

* Go to the contact record with the changed address.
* Click the **Change Log** tab.
* Find the change that corresponds to the date that the address was changed and click **Update** next to it.
* You should see before-and-after results.
> 4 votes

# Answer
We sometimes use a custom location type "Old address", so when we add a new address we set the previous as "Old address" and the new one as the "Home" + primary. Administer \> Customize Data and Screens \> Dropdown Options \> Location Types (Home, Work...).
> 2 votes

# Answer
I think this extension will help you for the future record.

https://lab.civicrm.org/extensions/formercommunicationdata
> 2 votes

# Answer
Might also want to consider using the "Future address changes" extension, https://github.com/CiviCooP/org.civicoop.futureaddress

Future address changes This extensions adds functionality to change an address in the future, the old address is archived as an activity in civicrm.
> 1 votes

# Answer
Wikimedia use the Advanced Report extension to provide a tab showing address history (rendering a report as a tab is an extended reports feature) (citing https://lab.civicrm.org/dev/core/-/issues/1021#note\_18644)
> 0 votes

---
Tags: addresses
---


# Question
Title: Could not find a valid session key when submitting Petition
Help needed. The error below is received when I click on the submit button for a petition (survey). This function has been working fine for several months. There are no customisations in place in this area. Wordpress was updated to 5.5.1. - The error only occurred since this last upgrade occurred. CiviCRM 5.27.1 PHP 7.3.17

```
(
    [message] => 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 />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 />Error type: Could not find a valid session key.
    [code] =>
)

Sep 04 14:04:55  [debug] $backTrace = #0 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(354): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(817): CRM_Core_Error::fatal("We can't load the requested web page. This page requires cookies to be enable...")
#2 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(812): CRM_Core_Controller->invalidKeyCommon()
#3 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(296): CRM_Core_Controller->invalidKey()
#4 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(190): CRM_Core_Controller->key("CRM_Campaign_Form_Petition_Signature", TRUE, FALSE)
#5 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller/Simple.php(50): CRM_Core_Controller->__construct("Sign Petition", TRUE, NULL, "CRM_Campaign_Form_Petition_Signature", TRUE, FALSE)
#6 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/Utils/Wrapper.php(62): CRM_Core_Controller_Simple->__construct("CRM_Campaign_Form_Petition_Signature", "Sign Petition", NULL, FALSE, FALSE, FALSE, FALSE)
#7 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(285): CRM_Utils_Wrapper->run("CRM_Campaign_Form_Petition_Signature", "Sign Petition", (Array:0))
#8 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(68): CRM_Core_Invoke::runItem((Array:14))
#9 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke((Array:3))
#10 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm.php(1537): CRM_Core_Invoke::invoke((Array:3))
#11 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/includes/civicrm.basepage.php(352): CiviCRM_For_WordPress->invoke()
#12 /home/cremorne/www/www/devwp2/wp-includes/class-wp-hook.php(287): CiviCRM_For_WordPress_Basepage->basepage_handler(Object(WP))
#13 /home/cremorne/www/www/devwp2/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters(NULL, (Array:1))
#14 /home/cremorne/www/www/devwp2/wp-includes/plugin.php(544): WP_Hook->do_action((Array:1))
#15 /home/cremorne/www/www/devwp2/wp-includes/class-wp.php(758): do_action_ref_array("wp", (Array:1))
#16 /home/cremorne/www/www/devwp2/wp-includes/functions.php(1285): WP->main("")
#17 /home/cremorne/www/www/devwp2/wp-blog-header.php(16): wp()
#18 /home/cremorne/www/www/devwp2/index.php(17): require("/home/cremorne/www/www/devwp2/wp-blog-header.php")
#19 {main}

```

# Answer
> 0 votes
Have been able to get over the session key error by installing a fresh install of WP and CiviCRM, then restoring Wordpress and CiviCRM DBs, repointing wp\_config.php and CiviCRM.settings.php. Also had to rename my table prefixes in wp\_config.php to match my restored tables. The caches get created once you start up CiviCRM and do things. Testing so far all functionality is working again. Hopefully this may help someone should you come across this issue which is pretty horrible.

---
Tags: wordpress, petition
---


# Question
Title: WP upgraded 5.5.1 and get Warning: session_destroy(): Trying to destroy uninitialized session
Wordpress 5.5.1 upgraded today and I now get a screen full of messages as below: CiviCRM is V 5.27.1 and PHP 7.3. Have cleared Civi cache. Any ideas please?

Warning: session\_destroy(): Trying to destroy uninitialized session in /home/cremorne/www/www/prodwp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php on line 490

Warning: Cannot modify header information - headers already sent by (output started at /home/cremorne/www/www/prodwp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php:490) in /home/cremorne/www/www/prodwp/wp-includes/pluggable.php on line 987

Warning: Cannot modify header information - headers already sent by (output started at /home/cremorne/www/www/prodwp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php:490) in /home/cremorne/www/www/prodwp/wp-includes/pluggable.php on line 988

Warning: Cannot modify header information - headers already sent by (output started at /home/cremorne/www/www/prodwp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php:490) in /home/cremorne/www/www/prodwp/wp-includes/pluggable.php on line 989

Warning: Cannot modify header information - headers already sent by (output started at /home/cremorne/www/www/prodwp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php:490) in /home/cremorne/www/www/prodwp/wp-includes/pluggable.php on line 990

Warning: Cannot modify header information - headers already sent by (output started at /home/cremorne/www/www/prodwp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php:490) in /home/cremorne/www/www/prodwp/wp-includes/pluggable.php on line 991

Warning: Cannot modify header information - headers already sent by (output started at /home/cremorne/www/www/prodwp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php:490) in /home/cremorne/www/www/prodwp/wp-includes/pluggable.php on line 992

Warning: Cannot modify header information - headers already sent by (output started at /home/cremorne/www/www/prodwp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php:490) in /home/cremorne/www/www/prodwp/wp-includes/pluggable.php on line 995

Warning: Cannot modify header information - headers already sent by (output started at /home/cremorne/www/www/prodwp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php:490) in /home/cremorne/www/www/prodwp/wp-includes/pluggable.php on line 996

Warning: Cannot modify header information - headers already sent by (output started at /home/cremorne/www/www/prodwp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php:490) in /home/cremorne/www/www/prodwp/wp-includes/pluggable.php on line 999

Warning: Cannot modify header information - headers already sent by (output started at /home/cremorne/www/www/prodwp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php:490) in /home/cremorne/www/www/prodwp/wp-includes/pluggable.php on line 1000

Warning: Cannot modify header information - headers already sent by (output started at /home/cremorne/www/www/prodwp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php:490) in /home/cremorne/www/www/prodwp/wp-includes/pluggable.php on line 1001

Warning: Cannot modify header information - headers already sent by (output started at /home/cremorne/www/www/prodwp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php:490) in /home/cremorne/www/www/prodwp/wp-includes/pluggable.php on line 1002

Warning: Cannot modify header information - headers already sent by (output started at /home/cremorne/www/www/prodwp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php:490) in /home/cremorne/www/www/prodwp/wp-includes/pluggable.php on line 1005

Warning: Cannot modify header information - headers already sent by (output started at /home/cremorne/www/www/prodwp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php:490) in /home/cremorne/www/www/prodwp/wp-includes/pluggable.php on line 1006

Warning: Cannot modify header information - headers already sent by (output started at /home/cremorne/www/www/prodwp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php:490) in /home/cremorne/www/www/prodwp/wp-includes/pluggable.php on line 1007

Warning: Cannot modify header information - headers already sent by (output started at /home/cremorne/www/www/prodwp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php:490) in /home/cremorne/www/www/prodwp/wp-includes/pluggable.php on line 1008

Warning: Cannot modify header information - headers already sent by (output started at /home/cremorne/www/www/prodwp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php:490) in /home/cremorne/www/www/prodwp/wp-includes/pluggable.php on line 1011

Warning: Cannot modify header information - headers already sent by (output started at /home/cremorne/www/www/prodwp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php:490) in /home/cremorne/www/www/prodwp/wp-includes/pluggable.php on line 1296

Warning: Cannot modify header information - headers already sent by (output started at /home/cremorne/www/www/prodwp/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/WordPress.php:490) in /home/cremorne/www/www/prodwp/wp-includes/pluggable.php on line 1299

Thank you for creating with WordPress.

Version 5.5.1

**Another error** Users reporting the following error when trying t respond to a petition. 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. 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.
Error type: Could not find a valid session key. Return to home page.

# Answer
I'd start by clearing CiviCRM Cache `https://yoururl.org/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fadmin%2Fsetting%2FupdateConfigBackend&reset=1`

I'd also refresh permalinks by visiting `https://yoururl.org//wp-admin/options-permalink.php`

Then double check that you have abase page set here and it is publicly visible `https://yoursiteurl.org/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fadmin%2Fsetting%2Fuf&reset=1`

Once that is complete, see if you still have any errors.
> 1 votes

# Answer
This all related to the session key issue. Have been able to get over the session key error by installing a fresh install of WP and CiviCRM, then restoring Wordpress and CiviCRM DBs, repointing wp\_config.php and CiviCRM.settings.php. Also had to rename my table prefixes in wp\_config.php to match my restored tables. The caches get created once you start up CiviCRM and do things. Testing so far all functionality is working again. Hopefully this may help someone should you come across this issue which is pretty horrible.
> 0 votes

---
Tags: wordpress
---


title: The menu bar doesn't load in Wordpress

text:
# Question
Title: The menu bar doesn't load in Wordpress
After transferring the website to a new URL, I can't get the Civi menu to appear.

I'm running the latest wordpress (5.5.1) and latest Civicrm plugin (5.28.0)

I've also noticed that there are javascript errors showing. These errors are caused by the absolute path being attached to the website path:
https://mysite.com/usr/home/xxxuser/public\_html/wp-content/uploads/civicrm/persist/

Not sure if the problem has something to do with the fact that all my URL's are HTTPS?

I have tried updating my $civicrm\_setting\['URL Preferences'\]\['userFrameworkResourceURL'\] in /wp-content/uploads/civicrm/civicrm.settings.php

I've read through various resources and tried many solutions including resetting my paths and clearing my caches 100's of times.

I've tried to install this plugin https://wordpress.org/plugins/civicrm-admin-utilities/ and rebuild the menu. But that didn't help.

The only way I have managed to fix this is by disabling asset caching
https://mysite.com/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fadmin%2Fsetting%2Fdebug&reset=1

Here are some of the resources I have tried:
Civi dashboard and menus won't display after install
https://forum.civicrm.org/index.php%3Ftopic=34290.0.html
Navigation Menu Gone after WordPress Site Transfer
After a CiviCRM update on WordPress the CiviCRM menu has disappeared
Menu bar is missing
Menu bar missing on fresh CiviCRM on Wordpress

I'm at my wits' end with CIVI and I haven't even started using it. If anyone can help, I'd really appreciate it!

# Answer
> 2 votes
check you wordpress directory path in your apache/nginx conf. If its different than '/usr/home/xxxuser/public\_html/' either you can change in apache/nginx conf or replace $civicrm\_root and template\_c path in civicrm.settings.php

Below line 242 in the file civicrm.settings.php

```
    global $civicrm_paths;
    $civicrm_paths['civicrm.root']['url'] = CIVICRM_UF_BASEURL . 'wp-content/plugins/civicrm/civicrm/';
    $civicrm_paths['civicrm.files']['url'] = CIVICRM_UF_BASEURL . 'wp-content/uploads/civicrm/';

```

NOTE: make sure you have '/' at the end for CIVICRM\_UF\_BASEURL value.

---
Tags: wordpress
---


# Question
Title: error when making contribution page - "No Contribution Price Sets have been configured"
I have two contribution price sets. When I try to make a Contribution Page I get an error on the second tab "Amounts". When I check the "Contribution Amounts section enabled" check box I get the error: "No Contribution Price Sets have been configured..." but I know I have two price sets.

What could be the problem?

# Answer
You need to select price set or Add amounts under 'Fixed Contribution Options'
> 0 votes

---
Tags: price-sets
---


# Question
Title: CiviEvent with Sub-events and Conference Slots - how to....?
I cannot find any good instructions on how to create sub-events. Basically I want to create a master/parent event that has 1 or 2 sub-events. I have found a few links about Conference Slots and have spent a day trying to work out how to use hem with no luck - any hints? Can it only be used with paid events because it is a shopping cart thing? Does it only work with online registrations? Can a staff member register a participant manually or does it only work with the online registration page?

Note that I'm using WordPress so the web-forms thing with Drupal is not an option.

thanks!

# Answer
> 2 votes
Sub-events and Conference Slots seem to be part of the Event Cart functionality. There is some documentation here: CiviEvent Cart Checkout

That page needs updating since CRM-8705 referenced there was closed in 4.2. New features were added in 4.7.10 - see CRM-16481 You may need to experiment and/or read the code to figure out exactly what is available.

From this comment of June 2015, the cart functionality wasn't regarded as supported by the core team even though it is in core. This might be a candidate for migrating to an extension. Anyone from core team care to comment on how the event cart functionality is regarded now?

Event Cart is one of the less travelled roads in Civi so proceed with caution. If you can update and improve the wiki page that would help others.

# Answer
> 1 votes
**Creating Parent Event and Sub Event** \- using conference Slot

* Create an Event and consider that as an parent Event - you need to enable online registration for parent event
* create another event consider this as a sub-event - In conference slot link the parent event and also create a slot and add to the slot - you don't need online registration for sub-event
* repeat the above step to create one more sub-event

Now you can use event info page from parent event and try to book the event - It should create all the three event against the register contact

---

**Regarding Paid Event**

I am not sure about booking an un-paid event - I will give a quick test and will let you know

---

**Regarding Off-line Registration**

To my knowledge - Conference Slot works can only be used for online registration screen

I guess this helps!!!

# Answer
> 1 votes
We have done some work on an extension which gives a UI as a custom event field where you can select the 'other' events that should be registered for along with the parent one. Works eg for a Series where you want user registered for each event separately, but for a single fee, but eg then allows for flexibility of recording that participant didn't show up on Week 3 Monday series and instead took a spare spot on the Week 3 Thursday series so they didn't miss out on a week.

---
Tags: civievent, registration
---


title: Configuring Repeated Events

text:
# Question
Title: Configuring Repeated Events
I can configure an event with regular repetition, and each instance stands as an isolated event.

Is there a way of configuring a series of related events, ie a course of n classes that users can sign up to x out of n classes.

Or would that be one event n weeks long with a price set field per class.

This is a speculative question, rather than searching for an immediate fix. I'm interested in if/how anyone else has configured events for similar scenarios.

# Answer
So it looks like the answer is.... It Depends!

In CiviEvent Component Settings you can set the site to use an event cart functionality, so instead of a register button events have an add to cart option.

It looks like this applies as a blanket to all events on the site so I don't know if that's the right way forward here.

Or I could build webforms for courses, the event booking tools on webforms allow you to be incredibly fine grained and pull in event id's into the url's. So if i have 6 events as part of 1 course I can configure a webform per course.

I think this can get complicated quite quickly. Wil need to estabilish paramteres with client before attempting a test form.

Will the user be allowed to book other participants onto the same events? If so, how many additional participants are you expecting the user to book on. (Looks like the webform maxes out at 9 participants per form) Also looks like form settings expect contact 1 to be the payee and the main partcipant throughout. So payee has to be a participant.

And then will need to configure the payment screen.

Con's here it looks like the initial set up will take aaaaaaages. But once done we can clone for future courses, or use one central form and find a way of rewriting the url link to include specific event id's.
> 0 votes

# Answer
We have done some work on an extension which gives a UI as a custom event field where you can select the 'other' events that should be registered for along with the parent one. Works eg for a Series where you want user registered for each event separately, but for a single fee, but eg then allows for flexibility of recording that participant didn't show up on Week 3 Monday series and instead took a spare spot on the Week 3 Thursday series so they didn't miss out on a week.
> 0 votes

---
Tags: civievent
---


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

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

Wordpress and CiviCRM Latest

# Answer
As I understand the price of the event is the same, regardless the classes the participant wants to attend. You can extend the participation with a custom field that registers to register the classes.
> 1 votes

# Answer
We have done some work on an extension which gives a UI as a custom event field where you can select the 'other' events that should be registered for along with the parent one. Works eg for a Series where you want user registered for each event separately, but for a single fee, but eg then allows for flexibility of recording that participant didn't show up on Week 3 Monday series and instead took a spare spot on the Week 3 Thursday series so they didn't miss out on a week.
> 1 votes

---
Tags: civievent, repeating-events
---


# Question
Title: How do I add a CiviCRM Contact as a User in Wordpress without them being a Member and using the WP Member Sync Plugin?
Our organisation has one Membership type in CiviCRM, and we have that syncing with a Group in Wordpress using the CiviCRM Wordpress Member Sync plugin. All is well.

We also have a Guest sign-up form (using a Civi Profile with WP account creation required) which adds them as a Contact in Civi and a User in WP, they also get added to a Civi Group (Guests) which is synced to a WP Group (Guests). All is well. \[Lapsed Members should also move to this WP Group (Guests) until they renew their membership when they should get removed. Yet to be tested\]

However, we sometimes need to manually add Contacts in CiviCRM ourselves (say VIP speaker for an event), and although we add these to the synced Guests group, they don't get added in WP, of course, as a WP User account is not created when we add the Contact manually in CiviCRM.

Is there a box to tick / dropdown to select for a Contact or multiple Contacts along the lines of: 'Create WP User Account from Contact'?

I have CiviCRM WordPress Profile Sync plugin installed.

I truly hope this is not a stupid question...

Cheers, Tracy

# Answer
Add the following to your wp-config.php file:

```
define( 'CIVICRM_WP_PROFILE_SYNC_BULK', true );

```

Then select some contacts and use the “Actions” dropdown to “Create WordPress Users from Contacts”.
> 5 votes

---
Tags: wordpress, civicontact
---


# Question
Title: How to enable Email Recipients to reply to all?
When you send an email (not a mailing) to the members of a Group, they all receive it in BCC, which makes it impossible for them to reply to all.

How can I change (or parameterize) that ? Is there any existing Extension ?

# Answer
We've run into the same issue, and couldn't find any extension to solve it.

We could develop something like a 'recipients public' flag on the "Email - send now" action, that would allow the reply-all option to work in any email client.

Is anyone else interested in this development? Let us know...
> 1 votes

---
Tags: email
---


# Question
Title: How can I resolve an issue with [civicrm.files] following an update to 5.29
Just updated my Civi 5.25 install running with Wordpress on a Cloudron LAMP stack to 5.29. Now Civi is generating lots of alerts about unknown extensions - it looks like it can't find my extension files, and in the Civi log I'm seeing lots of warnings stating "\[warning\] The system has data from both old+new conventions. Please use civicrm.settings.php to set civicrm.files explicitly."

How do I set civicrm.files explicitly in civicrm.settings.php?

I'm guessing these two issues are linked, and that if I can set civicrm.files explicitly then Civi will be able to find my extension files.

# Answer
The information provided in the docs at https://docs.civicrm.org/sysadmin/en/latest/customize/paths/ explains how to set civicrm.files in the civicrm.settings.php file.
> 1 votes

---
Tags: civicrm.settings.php, upgrade
---


# Question
Title: How to use the new Pdf.Createmulti in CiviRule?
Since version 2.9 recently released it is now possible to send multiple PDF but I can't find the option when setting a CiviRule 2.16? I can just select 'Send PDF'

but then there is no way to select multiple PDF.

Has anyone already succeeded?

EDIT: This question is related to these two other ones: Multiple PDF in one CiviRule and Share development costs

# Answer
> 2 votes
After asking Jaap from Civicoop, maintainer of the extension, it seems that the option of sending multiple pdf from a civirule is not yet possible. It's meant to be used from the API v3 interface. But with small additional development, it would be easy to have it as an option in CiviRule.

---
Tags: civirules, pdf
---


# Question
Title: Change the layout of CiviCRM > CiviCase Dashboard > Find Cases
I've only started trying to change some features of an existing CiviCRM database in a testsystem (using CiviCases). So I am still a beginner, I excuse myself if this is a silly question, and any hint will be appreciated :)

My goal is to change the layout of the search results in Find Cases. Specifically, I want to change the line height. I tried editing this in the CSS file but didn't succeed.

Do you have any hints for me?

Edit: In the civicrm.css, I tried setting the line height for example in this part (the class of the table lines is `even-row` or `odd-row`, among others):

```
.crm-container tr.even-row td,
.crm-container tr.odd-row td,
.crm-container table.display td,
.crm-container table.pagerDisplay td {
  border-color: #efefef;
  border-right: 1px solid #efefef;
  border-collapse: collapse;
}

```

# Answer
> 1 votes
This seems to work, but I wouldn't edit civicrm.css, I'd make an extension and add it as described in the dev docs

`table.caseSelector tr { line-height: 10em; }`

So e.g. in hook\_civicrm\_buildForm: `CRM_Core_Resources::singleton()->addStyle('table.caseSelector tr { line-height: 10em; }');`

But I don't think it's actually line-height you're looking for since wrapping in the cells would make that look weird. You maybe just want height:

`CRM_Core_Resources::singleton()->addStyle('table.caseSelector tr { height: 10em; }');`

But what exactly to use depends why you're trying to change it.

# Answer
> 1 votes
Did you try civicase v5 extension? It has got nice UI to manage cases.

---
Tags: civicase, display
---


# Question
Title: How to download a pdf instead of sending it per email?
I'm sending a membership certificate attached to an email template with Drupal 7 / CiviCRM using CiviRules and PdfApi but often the emails don't reach the recipients because of deliverability issues, even though I use a professional SMTP gateway.

I'm wondering about sending a link to the pdf instead of sending the pdf attached. Is this possible knowing that members don't have access to CiviCRM, they have no User account?

Any experience with this topic?

# Answer
> 1 votes
I would just create a page and based on cid, checksum and mid using pdfapi would recreate the pdf to download (via extension)

---
Tags: civimail, pdf
---


# Question
Title: How to display CiviCRM Custom Fields in a Drupal 8 View
I've been not very experienced with CiviCRM. I try to get CiviCRM custom fields displayed in Views. I've installed Drupal 8.9.3., CiviCRM 5.28.3, CiviCRM Entity 8.x-3.0-beta1.

Drupal and CiviCRM run on different databases on the same server with the same database user. In added the array with the links to the correct database to civicrm.settings.php as described in https://docs.civicrm.org/sysadmin/en/latest/integration/drupal/views/.

In Drupal 7, when I created a view(user) I was offered different CiviCRM fields. This doesn't happen in my Drupal 8 installation.

Besides when In try to create a view(contacts) I get the following error message:

```
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'usr_p550866_1.civicrm_contact' doesn't exist: SELECT civicrm_contact.id AS id FROM {civicrm_contact} civicrm_contact LIMIT 11 OFFSET 0; Array ( )

```

(usr\_p550866\_1 is the database for Drupal)

Is this a problem with Drupal 8 or do I anything wrong?

Your help would be appreciated very much.

# Answer
You need to add it in settings.php not civicrm.settings.php. once you add them in settings file clear Drupal cache
> 1 votes

---
Tags: drupal-views, drupal-8
---


# Question
Title: Database Error - unsure what the issue is
this morning I started encountering database issues - the only thing I can think of is the upgrade to 5.9 that we did yesterday.

First discovery was the Cron error - via log.

```
    Jan 17 10:15:02  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => TRUNCATE TABLE civicrm_acl_contact_cache [nativecode=1932 ** Table 'tarabnyc_wordpress.civicrm_acl_contact_cache' doesn't exist in engine]
    [type] => DB_Error
    [user_info] => TRUNCATE TABLE civicrm_acl_contact_cache [nativecode=1932 ** Table 'tarabnyc_wordpress.civicrm_acl_contact_cache' doesn't exist in engine]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="TRUNCATE TABLE civicrm_acl_contact_cache [nativecode=1932 ** Table 'tarabnyc_wordpress.civicrm_acl_contact_cache' doesn't exist in engine]"]
)

    Jan 17 10:15:02  [info] $backTrace = #0 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(232): CRM_Core_Error::backtrace("backTrace", TRUE)
    #1 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(921): CRM_Core_Error::handle(Object(DB_Error))
    #2 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: unknown error", -1, 16, (Array:2), "TRUNCATE TABLE civicrm_acl_contact_cache [nativecode=1932 ** Table 'tarabnyc_...")
    #3 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(575): DB_Error->__construct(-1, 16, (Array:2), "TRUNCATE TABLE civicrm_acl_contact_cache [nativecode=1932 ** Table 'tarabnyc_...")
    #4 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -1, 16, (Array:2), "TRUNCATE TABLE civicrm_acl_contact_cache [nativecode=1932 ** Table 'tarabnyc_...", "DB_Error", TRUE)
    #5 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1907): PEAR->__call("raiseError", (Array:7))
    #6 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-1, NULL, NULL, "TRUNCATE TABLE civicrm_acl_contact_cache [nativecode=1932 ** Table 'tarabnyc_...", "1932 ** Table 'tarabnyc_wordpress.civicrm_acl_contact_cache' doesn't exist in...")
    #7 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
    #8 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("TRUNCATE TABLE civicrm_acl_contact_cache")
    #9 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2415): DB_common->query("TRUNCATE TABLE civicrm_acl_contact_cache")
    #10 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query("TRUNCATE TABLE civicrm_acl_contact_cache")
    #11 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(438): DB_DataObject->query("TRUNCATE TABLE civicrm_acl_contact_cache")
    #12 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(1490): CRM_Core_DAO->query("TRUNCATE TABLE civicrm_acl_contact_cache", TRUE)
    #13 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/ACL/BAO/Cache.php(168): CRM_Core_DAO::singleValueQuery("TRUNCATE TABLE civicrm_acl_contact_cache")
    #14 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/Contact/Utils.php(926): CRM_ACL_BAO_Cache::resetCache()
    #15 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/bin/cli.class.php(116): CRM_Contact_BAO_Contact_Utils::clearContactCaches()
    #16 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/bin/cli.php(32): civicrm_cli->callApi()
    #17 {main}

```

Then the backtrace when trying to do anything.

```
pubic_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(190): CRM_Core_Error::backtrace()
#1 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(921): CRM_Core_Error::handle(Object(DB_Error))
#2 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: unknown error", -1, 16, (Array:2), "TRUNCATE TABLE civicrm_acl_contact_cache [nativecode=1932 ** Table 'tarabnyc_...")
#3 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(575): DB_Error->__construct(-1, 16, (Array:2), "TRUNCATE TABLE civicrm_acl_contact_cache [nativecode=1932 ** Table 'tarabnyc_...")
#4 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -1, 16, (Array:2), "TRUNCATE TABLE civicrm_acl_contact_cache [nativecode=1932 ** Table 'tarabnyc_...", "DB_Error", TRUE)
#5 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1907): PEAR->__call("raiseError", (Array:7))
#6 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-1, NULL, NULL, "TRUNCATE TABLE civicrm_acl_contact_cache [nativecode=1932 ** Table 'tarabnyc_...", "1932 ** Table 'tarabnyc_wordpress.civicrm_acl_contact_cache' doesn't exist in...")
#7 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
#8 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("TRUNCATE TABLE civicrm_acl_contact_cache")
#9 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2415): DB_common->query("TRUNCATE TABLE civicrm_acl_contact_cache")
#10 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query("TRUNCATE TABLE civicrm_acl_contact_cache")
#11 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(438): DB_DataObject->query("TRUNCATE TABLE civicrm_acl_contact_cache")
#12 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(1413): CRM_Core_DAO->query("TRUNCATE TABLE civicrm_acl_contact_cache", TRUE)
#13 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Config.php(362): CRM_Core_DAO::executeQuery("TRUNCATE TABLE civicrm_acl_contact_cache")
#14 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Admin/Form/Setting.php(145): CRM_Core_Config::clearDBCache()
#15 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Admin/Form/Setting.php(103): CRM_Admin_Form_Setting->commonProcess((Array:0))
#16 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(489): CRM_Admin_Form_Setting->postProcess()
#17 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/StateMachine.php(160): CRM_Core_Form->mainProcess()
#18 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php(61): CRM_Core_StateMachine->perform(Object(CRM_Admin_Form_Setting_Debugging), "next", "Next")
#19 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Admin_Form_Setting_Debugging), "next")
#20 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Admin_Form_Setting_Debugging), "next")
#21 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("next")
#22 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Wrapper.php(113): CRM_Core_Controller->run()
#23 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(282): CRM_Utils_Wrapper->run("CRM_Admin_Form_Setting_Debugging", "Debugging", (Array:0))
#24 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:15))
#25 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#26 /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm.php(1240): CRM_Core_Invoke::invoke((Array:4))
#27 /home5/tarabnyc/public_html/wp-includes/class-wp-hook.php(286): CiviCRM_For_WordPress->invoke("")
#28 /home5/tarabnyc/public_html/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters("", (Array:1))
#29 /home5/tarabnyc/public_html/wp-includes/plugin.php(453): WP_Hook->do_action((Array:1))
#30 /home5/tarabnyc/public_html/wp-admin/admin.php(224): do_action("toplevel_page_CiviCRM")

```

Lastly - when trying to upgrade from 5.9 to 5.9.1

```
Error: Finish Upgrade DB to 5.9.1]
Error Field Error Value
Type    DB_Error
Code    -1
Message DB Error: unknown error
Mode    16
UserInfo    TRUNCATE TABLE civicrm_acl_contact_cache [nativecode=1932 ** Table 'tarabnyc_wordpress.civicrm_acl_contact_cache' doesn't exist in engine]
DebugInfo   TRUNCATE TABLE civicrm_acl_contact_cache [nativecode=1932 ** Table 'tarabnyc_wordpress.civicrm_acl_contact_cache' doesn't exist in engine]
PEAR_Exception: DB Error: unknown error in /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php on line 921
- DB_Error: DB Error: unknown error in unknown on line unknown
Exception trace
#   Function    Location
0   CRM_Core_Error::exceptionHandler(Object(DB_Error))  /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php:921
1   PEAR_Error->__construct('DB Error: unknow…', -1, 16, Array, 'TRUNCATE TABLE c…')    /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/DB.php:985
2   DB_Error->__construct(-1, 16, Array, 'TRUNCATE TABLE c…')   /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php:575
3   PEAR->_raiseError(Object(DB_mysqli), null, -1, 16, Array, 'TRUNCATE TABLE c…', 'DB_Error', true)    /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php:223
4   PEAR->__call('raiseError', Array)   /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php:1907
5   DB_common->raiseError(-1, null, null, 'TRUNCATE TABLE c…', '1932 ** Table 't…') /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysqli.php:933
6   DB_mysqli->mysqliRaiseError()   /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysqli.php:403
7   DB_mysqli->simpleQuery('TRUNCATE TABLE c…') /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php:1216
8   DB_common->query('TRUNCATE TABLE c…')   /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php:2415
9   DB_DataObject->_query('TRUNCATE TABLE c…')  /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php:1607
10  DB_DataObject->query('TRUNCATE TABLE c…')   /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php:438
11  CRM_Core_DAO->query('TRUNCATE TABLE c…', true)  /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php:1490
12  CRM_Core_DAO::singleValueQuery('TRUNCATE TABLE c…') /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/ACL/BAO/Cache.php:168
13  CRM_ACL_BAO_Cache::resetCache() /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/System.php:1448
14  CRM_Utils_System::flushCache()  /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Form.php:721
15  CRM_Upgrade_Form::doIncrementalUpgradeFinish(Object(CRM_Queue_TaskContext), '5.9.1', '5.9.0', '5.9.1', '/tmp/civicrm-pos…') /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Queue/Task.php:88
16  CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))  /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Queue/Runner.php:214
17  CRM_Queue_Runner->runNext(true) /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Queue/Page/AJAX.php:52
18  CRM_Queue_Page_AJAX::{closure}()    /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Queue/ErrorPolicy.php:106
19  CRM_Queue_ErrorPolicy->call(Object(Closure))    /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Queue/Page/AJAX.php:54
20  CRM_Queue_Page_AJAX::runNext()  /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:275
21  CRM_Core_Invoke::runItem(Array) /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:84
22  CRM_Core_Invoke::_invoke(Array) /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:52
23  CRM_Core_Invoke::invoke(Array)  /home5/tarabnyc/public_html/wp-content/plugins/civicrm/civicrm.php:1240
24  CiviCRM_For_WordPress->invoke('')   /home5/tarabnyc/public_html/wp-includes/class-wp-hook.php:286
25  WP_Hook->apply_filters('', Array)   /home5/tarabnyc/public_html/wp-includes/class-wp-hook.php:310
26  WP_Hook->do_action(Array)   /home5/tarabnyc/public_html/wp-includes/plugin.php:453
    27  do_action('toplevel_page_Ci…')  /home5/tarabnyc/public_html/wp-admin/admin.php:224
28  {main}

```

# Answer
> 3 votes
As established from the comments on your original question, this appears to have been a corrupted MySQL table.

CiviCRM was reporting in the backtrace that a core table did not exist:

> TRUNCATE TABLE civicrm\_acl\_contact\_cache \[nativecode=1932 \** **Table 'example.civicrm\_acl\_contact\_cache' doesn't exist in engine**\]

You used MySQL to inspect the DB using `SHOW TABLES` (or `SHOW TABLES LIKE 'name_of_missing_table'`). MySQL reported the table was present. However, when you tried to drop the table, MySQL reported that the table was missing.

Since the table is a cache table which CiviCRM can regenerate from other data in the DB, it was possible to replace the corrupted table's disk files. The workaround I believe you used requires direct access to the files in the MySQL server's data directory - not an option for all sites.

# Answer
> 0 votes
Something has deleted your ibdata1 file where InnoDB keeps the dictionary. Definitely it's not MySQL who does it.

Cheers

Pradeep

# Answer
> 0 votes
**My solution is very noob, but it works:**
**1) backup the database first with myphpadmin, it will skip civicrm\_acl\_contact\_cache since its corrupted
2) drop and restore the current db, use old civicrm database sql backup** (if you don't have you can also create new civicrm and make new db backup)**, open the sql file with notepad** (I would use notepad++ or open sql workbench) **find civicrm\_acl\_contact\_cache
** **3) copy paste and run all civicrm\_acl\_contact\_cache SQL code in the SQL query box and there you go**

---
Tags: database
---


# Question
Title: CiviCase activities: cursor jumps in wrong order
Iam adding a new activity within a case, filling out only the fields A) subject B) details.

Then going to change the status and clicking in, the cursor jumps back to subject. If i change the flow, clicking in the akkordion "follow up" or others, the behaviour is as it should be, the cursor does not jump back to top.

Tried in different civicrm's 5.28.3. Anyone who can confirm that? I guess its coming with one of the latest update (at least 5.21.x or earlier).

# Answer
As a workaround you can turn off popups at Administer - Customize - Display Preferences, near the bottom there's a checkbox "Enable popup forms". The cursor doesn't jump then.
> 1 votes

---
Tags: civicase, activities
---


# Question
Title: Is there a Donate Now type button that I can just plug into my drupal site?
I am interested in creating a donate button that can be used on drupal8 as well as if someone wanted to add it to their own site.
I saw https://wiki.creativecommons.org/wiki/Single\_click\_donations\_with\_CiviCRM And I see https://civicrm.org/extensions/simple-donate
But they both appear quite old.
Is there some recommended button configs, especially as it relates to a credit card or other payment processor?

# Answer
If you are wanting to embed a form on another site then you should look at
> 1 votes

---
Tags: payment-processor, drupal-8, donations, button, simple-donate-form
---


# Question
Title: Exporting data (users) into another location?
is there a way to automatically export a file (with contacts information) outside of the CiviCRM installation to another location?

I'm using CiviCRM on Drupal and before looking at Drupal's side, I'm wondering if this is possible with CiviCRM.

I want to connect to a Wordpress site to create users.

Any experience?

# Answer
You can achieve this using Drupal + views, and can include all the necessary fields of the contact.

From Civi you can use Civi reports and download them as csv using `reset=1&output=csv&force=1` in url.

Could also use getrows for reporttemplate entity rest api

You may need to check with user permission on both the options.

HTH

Pradeep
> 1 votes

---
Tags: export
---


# Question
Title: How would I expose weight for a custom select field to Drupal Views for sorting?
I have a custom select option field with about 35 options. I'd like to be able to sort the field in Drupal Views by weight instead of value or name.

I looked around for the views integration in the core files but couldn't find the section that exposes custom field option groups to views.

I would assume that it is in all/modules/civicrm/drupal/modules/views/components/civicrm.core.inc but I don't see any mention there.

Custom option groups appear to be exposed in all/modules/civicrm/drupal/modules/views/civicrm.views.inc but I don't see any mention of the option\_value table to add the weight column.

Any suggestions on how to expose the weight of individual custom select options in Views?

Thank you!

# Answer
You can use the Views CiviCRM Expose Tables module to join to CiviCRM tables and columns that aren't otherwise exposed.
> 0 votes

---
Tags: custom-fields, drupal-views, drupal-7
---