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 ...
user avatar
  • 3,688
11 votes
Accepted

What is the installation canary?

What is the installation canary? The civicrm_install_canary is fundamentally a test to see how well we control/understand the installation process. It's part of a bigger topic, so bear with me in ...
user avatar
  • 5,589
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 ...
user avatar
  • 11k
9 votes

Database Trigger error message

The problem is that the database user doesn't have some higher level privileges required for CiviCRM. Ask your ISP support or database administrator to run the following commands for you as the root ...
user avatar
  • 6,671
9 votes

MySQL Tuning: Is Defragmenting Tables safe?

Yes, running OPTIMIZE TABLES on a regular basis is beneficial. I don't think there is significant risk with it. I'd run it on a copy of the DB first. If you have the memory on your database server ...
user avatar
  • 3,803
9 votes
Accepted

SOLVED: 'DB Error: extension not found' after PHP upgrade to version 7.0

Summarising the above conversation: The upgrade of PHP to version made the PEAR DB extension unavailable. So the exception "DB Error: extension not found" was thrown. Changing to the database ...
user avatar
9 votes
Accepted

How to get CiviCRM Views to work in Drupal 8 with separate CiviCRM database

I had the same problem today, so I looked in the source code. In civicrm.install there's a function called _civicrm_get_db_config. It's looking in the $databases array for an element with a key ...
user avatar
9 votes
Accepted

How do I safely export my database and import it on a new server?

You can export the civicrm database without triggers and functions and After importing and making sure you have CiviCRM working, recreate the triggers by running 'civicrm/menu/rebuild?reset=1&...
user avatar
9 votes
Accepted

Where are checksums stored in the database?

The checksum is an md5 hash of the value in the database field civicrm_contact.hash, the Contact ID, the current timestamp and the life-span. Therefore, as long as the contact hash stays the same (it ...
user avatar
  • 3,131
8 votes

What is the largest number of customer records that civicrm supports?

See this question: Number of contacts vs. hosting space required Here is a thorough answer to that question: https://civicrm.stackexchange.com/a/3289/105. The short version: there is no formal limit ...
user avatar
8 votes
Accepted

Change domain name (wordpress)

Below are the simplified instructions taken from Moving an Existing Installation to a New Server or Location, but specific to answer your question. Open the file wp-content/plugins/civicrm/civicrm....
user avatar
  • 614
8 votes

How to Export full back up of entire database

Exports and backups serve different purposes: 'export' refers to an extract of data to use in another system, 'backup' refers to recovery in the event of system failure, recovery from bad user actions ...
user avatar
  • 11k
7 votes

Database Trigger error message

If you're using binary logging, you may need to add a line to your MySQL or MariaDB configuration (/etc/mysql/my.cnf) to proceed with the installation. log_bin_trust_function_creators = 1
user avatar
7 votes
Accepted

MySQL Tuning: Is Defragmenting Tables safe?

The suggestion to increase the join_buffer_size is a good one if your server can afford the 128K. The number of queries with joins on unindexed fields, which need more cache, is not insignificant. (...
user avatar
  • 6,671
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 ...
user avatar
6 votes

Where in the database is the note field for contributions?

You can retrieve contribution notes via the api using: civicrm_api3('Note', 'get', array( 'entity_table' => 'civicrm_contribution', 'entity_id' => $contributionID, )); Or see the api ...
user avatar
  • 16.2k
6 votes
Accepted

Where in the database is the note field for contributions?

civicrm_note entity_table = 'civicrm_contribution' entity_id = contributionID
user avatar
  • 3,803
6 votes

What can I do to fix my database that has been partially upgraded?

This is a tricky one to resolve yourself. You basically need to identify whereabouts in the upgrade it failed. For example it might have done all the tasks for a particular point version & failed ...
user avatar
  • 1,920
6 votes
Accepted

Is CiviCRM a 'master database' / 'master system'?

Yes, CiviCRM would be a great match for what you're describing. CiviCRM is a central 'master' information hub that has quite a bit of reach out of the box: membership data (What Is CiviMember? and ...
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 ...
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 ...
user avatar
  • 96
6 votes

Implementations Basics (Costs, Timescales, etc)

Honestly without a significant amount of detail regarding your current database, how you're going to use CiviCRM, what kind of site it is being connected to, etc, no one can give you anything but a ...
user avatar
6 votes
Accepted

Ran direct SQL update to bulk update contact names, changes not appearing until editing and saving

It sounds like you imported the first_name and last_name values - but the value at the top of the record is the display_name. You have two options: Use your SQL script to update the display_name ...
user avatar
6 votes

CiviCRM 5.9.1 Cannot Read Database Information

Your DB connection specifies mysql://, and you are using PHP7.2. The MySQL extension was deprecated in PHP 5.5 and removed in PHP 7.0. Try switching the two DB connect strings in civicrm.settings.php ...
user avatar
6 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='...
user avatar
  • 1,116
5 votes
Accepted

How do I add a new table to my extension?

What I did for the sepa extension is a bit of a hack, but worked ok: write the xml schema files, as you have them on the (development version) core and run xml/phpGencode.php to generate the dao, ...
user avatar
  • 10.1k
5 votes

What to do when upgrading from 4.3.4 to 4.6.0 is failing?

If I understand correctly, you first installed 4.6.0 and then loaded a DB dump for 4.3.4 on top of the 4.6.0 system. Doing so would put the database in an inconsistent state — some elements from ...
user avatar
  • 5,589
5 votes
Accepted

Why did we lose contact data after deleting the default location type "Home"?

This is a result of someone going in CiviCRM and deleting the Home location type, either through Administer > Customize Data and Screens > Dropdown Options > Location Types or clicking the wrench next ...
user avatar
  • 7,357
5 votes

MySql vs MariaDB

Don't overthink it, and don't go out on a limb without a worthwhile reason. So long as MariaDB is truly a drop-in replacement for MySQL, you're fine with that. If somehow MariaDB ceases to be ...
user avatar
  • 7,357
5 votes

What is the largest number of customer records that civicrm supports?

There's a difference between how many records a database can hold and how many users need to access the system simultaneously on a regular basis. For the latter it's a much harder question because it ...
user avatar
  • 17.9k

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