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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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&...
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 ...
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 ...
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....
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 ...
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
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.
(...
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 ...
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 ...
6
votes
Accepted
Where in the database is the note field for contributions?
civicrm_note
entity_table = 'civicrm_contribution'
entity_id = contributionID
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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='...
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, ...
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 ...
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 ...
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 ...
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 ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
database × 351wordpress × 67
upgrade × 50
error × 47
mysql × 32
installation × 25
drupal × 23
contacts × 22
custom-fields × 17
joomla × 16
update × 10
migration × 10
civicontribute × 9
extension × 8
settings × 8
performance × 8
civievent × 7
civimember × 7
php × 7
4.7 × 7
export × 7
issues × 7
civireport × 6
import × 6
acl × 6