Skip to main content
Share Your Experience: Take the 2024 Developer Survey
17 votes
Accepted

Status page angular load error

We had one site that had 'lost' all it angular pages, eg CiviMail and System Status. In our case the angular cache files were returning 404 on the New Mailing page. (and 'inspector' was showing a lot ...
petednz - fuzion's user avatar
  • 28.3k
15 votes

How to find and/or fix missing indices?

Disclaimer, as with other answers, this is aimed at a fairly technical person who kinda understands what they're doing and has made lots of backups :-) As Sophie points out you can find the exact ...
artfulrobot's user avatar
  • 3,932
15 votes
Accepted

Moving existing CiviCRM to new Drupal instance + upgrade to Drupal 9

For the Drupal 7 to Drupal 9 part of the upgrade you are best to look for help with the Drupal Community. But sounds like you have this in hand. The CiviCRM specific part of the D7 -> D9 the things ...
Luke Stewart's user avatar
  • 1,890
11 votes
Accepted

Outgoing Mail Settings, CiviSMTP & PHP 5.6.x Problem

The recommended and least invasive fix is to resolve the underlying SSL issues. It was intentional that PHP5.6 tightened security here. If your hosting environment doesn't validate the SSL ...
Chris Burgess's user avatar
11 votes
Accepted

screen for composing a mail is blank

This may be related to Status page angular load error. Make sure that the following two items point to the same place: Image Upload URL at Administer > System Settings > Resource URLS Image Directory ...
Noah Miller's user avatar
  • 1,057
11 votes
Accepted

Update to 5.29.0 get frozen

We got this on one of the db upgrades. For us, it was due to few entries in civicrm_relationship table which were attached to permanently deleted contact ids. You can follow the below steps to ...
jitendra - fuzion's user avatar
10 votes

How to find and/or fix missing indices?

The pop-up message should have a link "View details and manage alerts" that takes you to the System Status page. That includes an Update Indices button (yes there is a typo in 4.7.19 but it doesn't ...
Aidan's user avatar
  • 13.5k
10 votes

Upgrade to 5.47.x fails with error: Exception: "API error: DB Error: constraint violation on ReportTemplate.create"

The problem here was the Extension Extended Reports - however it's possible that you have a different extension causing the problem. In 5.47.0 CiviGrant component was transferred to an extension. You ...
Luke Stewart's user avatar
  • 1,890
9 votes
Accepted

Problem fixing missing indexes after upgrade to 4.7

We have found that there are problems with both civicrm_option_value and civicrm_case_contact table indexes that have not been properly fixed by https://github.com/civicrm/civicrm-core/pull/10908 as ...
Joe Murray's user avatar
  • 6,741
9 votes

Status page angular load error

I was able to solve this, at least for now, on my WordPress 4.8/Civi 4.7.22 site using this suggestion from Tim Otten: another work-around should be going to "Administer => System Settings => ...
Noah Miller's user avatar
  • 1,057
9 votes
Accepted

What is the recommended upgrade increments to CiviCRM 5.7 from CiviCRM 5.0?

The 5.x series has a new point release every month, with a focus on stability (generally, large new features go into extensions). So upgrading 5.0 -> 5.7 is the equivalent of upgrading 4.7.20 -> 4.7....
Coleman's user avatar
  • 18.7k
8 votes
Accepted

How to update Drupal for CiviCRM?

It depends on the upgrade i.e from 6.x to 7.x to 8.x. If its a simple and internal version i.e 7.12 to 7.29 than you can perform update directly and you won't have problem in CiviCRM but if its from 6 ...
Pradeep Nayak's user avatar
8 votes
Accepted

Error: Failed to find key by ID or tag message

Thank you bgm, you got me on the right trail. It was an email issue. It was angry that it could not email the confirmation for the event to the registrant. The registrations were hitting the db as ...
Tim's user avatar
  • 171
7 votes

Why is CiviCRM Upgrade so Complex?

I have been dealing with upgrades a lot lately, and I have the process "down" so that it is very fast. I am impressed with how fast I can do an upgrade. The key is shell access - or something that ...
Rob Brandt's user avatar
7 votes
Accepted

CiviCRM 4.7 - DB Constraint Violation - possibly dashboard_id should possibly be marked as mandatory for this API

Maybe you can try to run the upgrade script again to go from 4.7.10 to 4.7.12 http://<your_wordpress_home>/wp-admin/admin.php?page=CiviCRM&q=civicrm/upgrade&reset=1 Documented on the ...
Kainuk - CiviCooP's user avatar
7 votes

How can I run extension DB updates?

The equivalent would be any of these: Navigate to civicrm/admin/extensions/upgrade?reset=1 Navigate to "System Status" or "Manage Extensions". Those pages will link to the above. On CLI, run cv ext:...
Tim Otten's user avatar
  • 5,684
7 votes
Accepted

Upgrade fails with CiviCRM_API3_Exception: "API error: Could not delete payment processor type"

This looks to be a problem with an entity_type row of PaymentProcessorType in the civicrm_managed table. To show the offending row: select * from civicrm_managed where entity_type='...
G H's user avatar
  • 1,146
7 votes
Accepted

CiviCRM core now includes Flexmailer: how to remove old flexmailer extension?

Here's how we handled this: From within your extensions directory: cv dis mosaicomsgtpl mosaico flexmailer rm -rf org.civicrm.flexmailer cv flush cv en flexmailer mosaico mosaicomsgtpl cv ext:up We'...
HomoTechsual's user avatar
  • 1,138
7 votes
Accepted

Mailing event queue error when upgrading from CiviCRM 5.66 to 5.67

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

Up to what version of CiviCRM is secure to upgrade on a Drupal 6 site?

Pete is right that even recent versions of CiviCRM (certainly in the 4.6.x series) work with Drupal 6 sites. The "no longer officially supports" issue is that the core team won't go out of their way ...
Andie Hunt's user avatar
  • 7,462
6 votes
Accepted

How do I debug "Could not find valid value for ct" error message

OK, turns out this was due to erroneous entries in the Drupal settings.php file. The following entries were causing cookies to be missed by Civi:- ini_set('session.cookie_lifetime', 2000000); ...
Darren's user avatar
  • 751
6 votes

How do I update CiviCRM following a security update?

First of all, I should say that this is a job for someone who is reasonably technically minded and comfortable with using the command line. If this doesn't sound like you, then I would suggest that ...
William Mortada's user avatar
6 votes

Should I disable extensions prior to upgrading CiviCRM?

In general, I'd recommend no. Some extensions - literally - may not be reinstallable if they aren't qualified for that version of Civi. My recommendation: TAKE BACKUPS!!! Then don't disable ...
JohnFF's user avatar
  • 2,343
6 votes
Accepted

How can I speed up a slow upgrade to 4.7?

The slowest part of upgrading on a large installation is usually the civicrm_mailing_event_* tables. That data is also often stale, so consider deleting it if you don't need to keep historical ...
Jon G - Megaphone Tech's user avatar
6 votes
Accepted

How to reduce database bloat for faster upgrading?

Best to review the tables which are largest in your DB, and also identify which queries during the upgrade take the longest. This is a chicken-and-egg problem, which means you might review the tables ...
Chris Burgess's user avatar
6 votes
Accepted

What is the Path for LTS? 4.7?

The LTS as you know it is the last one! Eileen explained the details here: https://civicrm.org/blog/eileen/the-lts-going-forwards Essentially the idea is that through better release/QA/testing we ...
KarinG - Semper IT's user avatar
6 votes

How to find and/or fix missing indices?

After upgrading to 4.7.19 I found that indices cannot be created automatically; you can look at your CiviCRM error log to see which database statement is causing a fatal error - you might see problems ...
mfb's user avatar
  • 96
6 votes

Issues with running Joomla 3.8 and Civi

The fix to the file CRM/Utils/System/Joomla.php suggested in the link https://github.com/civicrm/civicrm-core/pull/11062/files?diff=unified made the cron jobs run again for CiviCRM 4.7.25 and Joomla ...
Marcelo Mig's user avatar
6 votes
Accepted

Does Drupal's read-only mode module work for Civicrm too?

In short - no. Moreover, if it did, it would be dangerous, because the Drupal module can't know which database writes are part of the legitimate upgrade and which aren't. In my experience, only ...
Jon G - Megaphone Tech's user avatar
6 votes

Multilingual instances show 'no such field' errors after update

In the latest version, you can also rebuild the multilingual schema yourself by navigating to API Explorer http://www.site-name/civicrm/api#explorer Select Entity = System, Action = ...
jitendra - fuzion's user avatar

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