Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
17
votes
7answers
3k views

How to find and/or fix missing indices?

After upgrading to 4.7.19, I'm now getting a warning: You have missing indices on some tables. This may cause poor performance. How can I find which indices are missing and then, how can I create ...
15
votes
2answers
642 views

MySQL Tuning: Is Defragmenting Tables safe?

I like using MySQLTuner to check on things from time to time. It's as easy as: $: sudo apt-get install mysqltuner (CentOS: sudo yum install mysqltuner) $: sudo mysqltuner Also, besides 'top' ...
9
votes
1answer
501 views

What is the installation canary?

One of my CiviCRM instances database has the table civicrm_install_canary, another has not. In code it is marked as a mechanism that check whether the install has run before. But how does this ...
9
votes
3answers
306 views

How do I add a new table to my extension?

I have added tables to my database by writing SQL commands in a sql folder as specified in the given link. Add a database upgrader / Installer / uninstaller. What I am exactly looking for is a ...
9
votes
1answer
242 views

CiviCRM still creates MyISAM tables which results in Warning

CiviCRM 4.7.10 --- WordPress 4.6 The following warning message appeared in CiviCRM System Status: Your database is configured to use the MyISAM database engine. CiviCRM requires InnoDB. You will ...
8
votes
2answers
291 views

Data Protection / GDPR - deleting from logging tables

With the new GDPR legislation taking effect in a matter on months, it dawns on me... how can we delete people permanently from the logging tables? My understanding is that the table types are a ...
7
votes
3answers
110 views

Recommendations or Experiences on Archiving Mailing Data

We have an instance that has been using CiviMail extensively for years. The civicrm_mailing and civicrm_activiy tables far exceed the number of records of any other tables. It seems likely that these ...
7
votes
3answers
80 views

How does CiviCRM handle multiple users editing the same record simultaneously?

I'm assuming that the record is locked so that only one user - presumably the first - can edit, whilst others are locked out until the record has been saved. But I don't know, and a client has just ...
7
votes
1answer
243 views

MySql vs MariaDB

After some reading, it appears that MariaDB could be a better challenger to MySQL and it runs, apparently, without any problems with CiviCRM (cf CiviCRM on MariaDB instead of mySQL). But what about ...
7
votes
1answer
111 views

Can I pass a GROUP BY to an API call?

I'm trying to write an API call returning all contacts that are at one end of one or more active relationships of a certain type, and their names. I note that you can specify limit, offset (LIMIT) and ...
6
votes
2answers
241 views

Adding states to countries

Hello we are moving an old CRM into CiviCRM. We are a very international organization and we have found that CiviCRM is missing many states. How do we get this added to CiviCRM? Should we make ...
6
votes
3answers
134 views

How to migrate database without logs

I’d like to move my CiviCRM installation from one Drupal server to another. But I enabled logging in the current server and I don’t want that data to be transferred to the new server. How can I delete ...
5
votes
2answers
151 views

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

I am evaluating civiCRM to use as the CRM in the captive BPO setup of my non-profit. Need to know how many customer records civiCRM can handle, in the database of my beneficiaries. Can it support a ...
5
votes
4answers
338 views

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

So we lost 2/3 of our email and addresses on 6/15 around 1pm. Everything else seemed fine. I was able to get the civi log that pointed to a deletion command (DELETE FROM civicrm_location_type) around ...
5
votes
2answers
187 views

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

When setting up a Drupal 8 with separate CiviCRM database, the Drupal views cannot read the CiviCRM database: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxx.civicrm_contact' ...
5
votes
1answer
139 views

How to reduce database bloat for faster upgrading?

In order to speed up slow upgrades, experienced folk (1 2) recommend reducing the size of the database to facilitate testing. What is the best way to declutter the database?
5
votes
1answer
675 views

4.7.20 upgrade — missing indices warning, but index already exists? [duplicate]

Upgraded to 4.7.20 today. As others on this thread have experienced in earlier release(s), I promptly got the "missing indices on some tables" warning. Of course, I tried the "Update Indices" button, ...
5
votes
1answer
595 views

WordPress: Creating new WP Users from Civi Contacts

I've seen some example posts here for other CMS', but I haven't seen it explained for a WordPress environment. My situation is I have an Individual DB of 2,500 Contacts in Civi, and I want to turn ...
5
votes
1answer
227 views

In Wordpress, I want to convert my installation from an external database to use the default database

I am using CiviCRM on WordPress and I am moving my hosting to WP Engine - where I have all of my other sites hosted. Unfortunately, I set this instance of CiviCRM to use a separate database, however, ...
5
votes
3answers
413 views

MyISAM vs InnoDB - WordPress Installation

We're running CiviCRM 4.6.8 on WordPress 4.3.1. I've been getting the following error message since the last CiviCRM upgrade: Warning Your database is configured to use the MyISAM database engine. ...
5
votes
2answers
97 views

When upgrading from 4.7.7 to 4.7.8 I get error “Specified key was too long”

I tried to upgrade my Joomla CiviCRM 4.7.7 to 4.7.8 and got the following error in the database upgrade: ALTER TABLE `civicrm_contact` CHANGE `image_URL` `image_URL` VARCHAR(512) CHARACTER SET utf8 ...
5
votes
3answers
234 views

Add custom field and populated with array/data from a non-civicrm table

newby here with a quick question about custom fields. Is it possible to set up a custom field that queries a non-civicrm table? Hoping to create an autocomplete dropdown menu that does a SELECT on a ...
4
votes
2answers
2k views

Database Trigger error message

Trying to install to WordPress and I get; "Could not create a database trigger." I have no idea how to resolve. Thank you!
4
votes
1answer
4k views

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

Civi: 4.7.11 Wordpress 4.7.2 Hi, I was working on my database today and munged something up. No problem (I thought)... I did a back up beforehand just in case. Unfortunately, after restoring the ...
4
votes
3answers
405 views

CiviCRM on MariaDB instead of mySQL

Has anyone run CiviCRM on MariaDB instead of mySQL https://mariadb.org/ Running CiviCRM on MariaDB could provide significant speed improvements.
4
votes
1answer
58 views

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

I'm finishing up a migration to CiviCRM from a homegrown Python application I wrote, and without going into too much detail as to the why, I needed to do a bulk update of all the contact name fields ...
4
votes
1answer
34 views

Insert and Get New ID in Extension

Within a new extension, in a form's postProcess function, I am inserting into a non-Civi table (separate mysql database/table). What is the proper way to execute a MySQL insert statement and retrieve ...
4
votes
2answers
1k views

Could not create a database trigger on AWS RDS

I am installing CiviCRM in Amazon AWS environment. User civicrm has full rights on civicrm database. I certainly see TRIGGER among all others in my phpMyAdmin console. Out of abundance of caution I ...
4
votes
1answer
73 views

Why are you allowed to set DB field length on Text fields?

I know the documentation says you should leave it the same, but suppose I know I want the text field to be only 3 characters every time? I can set it fine in custom fields, but when I go to enter ...
4
votes
2answers
388 views

drush civicrm-sql-dump dumps the drupal database - how do I get it to dump the civicrm database?

I've recently made some backup scripts to automate backup of my site and databases. One of the scripts uses drush to dump the drupal and civicrm databases with these commands: drush @myserveralias cc ...
4
votes
3answers
62 views

CiviCRM Raw Data Files

We use CiviCRM for our nonprofit, and we're trying to figure out how we can export our raw data in order to upload it into some custom apps. Any help would be very much appreciated! Cheers, Jillian
4
votes
2answers
78 views

What table and column contain the date a contact was added?

I'm trying to determine the correct table and column to check the data a contact was added to the civicrm-contact table. What is the best method for doing this?
4
votes
2answers
49 views

civiVolunteer database table creation?

When are civiVolunteer database tables created? When I run a search on volunteer opportunities and when a donation is made to our organization, we get database errors saying that tables ...
4
votes
1answer
57 views

Civi Event - Event Title & Event Name with French accents not saving in correct encoding

Database/environment is set to UTF-8. This just started happening and we can't figure out why. In the example below, a French title and summary are given -- when saved, the Title appears to be saved ...
3
votes
5answers
1k views

Migration error: “The user specified as a definer does not exist”

I recently moved the site to a new server and changed from a remote to a local MySQL server with different credentials. Most things seem to be working fine, but even though I've flushed caches, ...
3
votes
5answers
492 views

I need to migrate data from one CiviCRM on Drupal instance to a clean one. HELP?

The person who was supposed to be maintaining my CiviCRM on Drupal instance flaked on my a while ago and my site has been sitting vulnerable. Due to hosting changes, I decided to just set up a clean ...
3
votes
1answer
95 views

How to Export full back up of entire database

I would like to export a full copy of the database contact details - all the details not just the primary. Short of selecting each individual field, how to I collect "all records' report?
3
votes
1answer
308 views

Change domain name (wordpress)

I have civi crm 4.7.8 on wordpress 4.5.3 and I've changed my website domain name. When I go to wp admin, i can see civicrm icon and go the taskboard, but I haven't civicrm menu. I supposed there are ...
3
votes
2answers
225 views

Where is the civicrm database?

I recently took over a website and I have missing tables in the civicrm database (under wordpress). I want look at the civicrm database but I don't know where the database is stored. How can I find ...
3
votes
1answer
53 views

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

The membership organisation I work for currently has serious issues with it's membership databases. That information is currently split between a wordpress user database with an extension s2pro which ...
3
votes
2answers
169 views

DB Error: unknown error - [debug_info] => INSERT INTO civicrm_contact

it's fresh install of CiviCrm into my Joomla, run with UniserverZ (assume all Apps are in latest version) When I clicked CiviCRM, in Components, there was a DB Error: unknown error In the joomla/...
3
votes
3answers
76 views

Settings values not showing

I am experiencing a strange issue with my CiviCRM (4.7.3) installation on Joomla (3.4.8). If I change some of the settings in one of the administration pages, they are correctly updated on the ...
3
votes
2answers
30 views

How did my import result in the State for a different country to the one intended

How could a CiviCRM database have 2 Marylands with 2 different state_province_codes but both be identified with the same country_code? 1019 = Maryland 3497 = Maryland 1228 = United States I only was ...
3
votes
1answer
103 views

How do user permissions work for multi-level organizations?

We are currently using Action Network for our CRM (even though it is not designed for that), marketing and digital mobilising tools. We moved to them because of their system of parent/sibling/child ...
3
votes
1answer
325 views

How can I fix this problem with duplicate index in 4.7.21?

Upgraded from 4.7.17 to 4.7.21 and got the following message that I don't know how to fix. I don't have drush and the other answers to this problem don't include this index or don't fix this ...
3
votes
2answers
29 views

Strange Text Appearing in Contact Address Area

My CiviCRM installation is showing weird text around the address area of each contact entry. The weird text disappears when I try to edit the address, but when I finish the edits the weird text ...
3
votes
2answers
109 views

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 [...
3
votes
3answers
26 views

Notes - searching

How do I find a list of the notes I have added. I input a number of notes last week but neglected to grant permissions. how do I locate a list of those notes?
3
votes
2answers
458 views

CiviCRM Can't Connect to Databases on Server, but WordPress Can

I've been trying to install CiviCRM on fresh WordPress 4.7.3 installations on my managed server, but I keep having database connection problems. When I try to install CiviCRM 4.7.17, the CiviCRM ...
3
votes
2answers
56 views

Drush failing to build database during new installation

I am building a Docker container for CiviCRM, it is 99.9% done. Unfortunately, when I try to install the actual module via Drush, it spits out an error. I am fairly certain this isn't a Docker related ...