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 ...
9
votes
3answers
308 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
502 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 ...
5
votes
2answers
99 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
1answer
229 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, ...
1
vote
5answers
807 views

Ajax Error when trying to view relationships tab

Civicrm 4.7.1 Joomla 3.4.8 I'm unable to view data in the relationships tab. I get the following errors: "DataTables warning: table id=DataTables_Table_0 - Ajax error." And "DataTables warning: ...
5
votes
1answer
142 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?
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!
5
votes
2answers
210 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
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 ...
2
votes
1answer
59 views

Upgrade from 5.11.0 to 5.12. failing database update - solution found

I'm failing because mysql doesn't like characters in a city name: UPDATE civicrm_state_province INNER JOIN civicrm_country ON civicrm_state_province.country_id = civicrm_country.id SET ...
2
votes
0answers
116 views

DB Error after upgrading 4.7.x to 5.1 (Drupal)

After upgrading CiviCRM from v4.7.14 to 5.1 (or v4.7.31) which went seemingly well, CiviCRM encounters the following problem. UPDATE: Issue does not appear until 4.7.29 (including), and comes up only ...
15
votes
2answers
645 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' ...
2
votes
2answers
65 views

Unknown DB Error When Trying to Disable the Automatic Wildcard Option

We are trying to disable the automatic wildcard option in Civicrm (Wordpress 4.7.2). However, when we try to disable the option and save we get an error that says “Save Failed: DB Error: Unknown ...
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 ...
2
votes
1answer
142 views

DB Upgrade Fails when creating Getting Started Dashlet

CiviCRM 4.6.11 to 4.7.1 Update Joomla 3.4.8 Error page during DB upgrade utility: [Error: Add Getting Started dashlet] Error Field Error Value Type DB_Error Code -3 Message DB Error: constraint ...
2
votes
2answers
102 views

Database error when using CiviCRM admin UI: “Row size too large”

I'm helping on a site that is on a different server than usual and see this error regularly in the back end when trying to complete various tasks (e.g. clear caches, run database updates, etc.) [...
1
vote
3answers
508 views

4.6.10 to 4.7.1 upgrade woes

**UPDATE #5: See new answer at bottom. It's a fix! **UPDATE #4: Decided do a clean install of 4.7.1 and see if I can point it to a working 4.7.1 backup database. I suppose I need to follow Kurund's ...
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
3answers
415 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.
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
0answers
104 views

MyISAM Database Engine Error [duplicate]

I'm getting the MyISAM Database Engine error: Your database is configured to use the MyISAM database engine. CiviCRM requires InnoDB. You will need to convert any MyISAM tables in your database to ...
3
votes
2answers
626 views

Civix: Install error: API error: DB Error: already exists

According documentation I created a skeleton module with civix and answered yes to install it. It then gives an error response as in the Title. Afterwards is listed active in the extensions page. ...
3
votes
1answer
328 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 ...
2
votes
2answers
84 views

CiviCRM 5.9.1 Cannot Read Database Information

CiviCRM 5.9.1 WordPress 5.0.3 PHP 7.2 Upgraded after migration between servers from 4.7.29 w/o issue. When I went inside the CiviCRM it asked me to redo everything like a new install. I went to the ...
2
votes
1answer
32 views

Search Builder Smart Group with Latitude, Street Address criteria 1292 Truncated DB Error

CiviCRM 5.9.1. Issue has occurred since an upgrade from version 4.7.17. The Smart Group/Contact Group in question is built on two simple search builder criteria: Contacts Primary Street Address is ...
2
votes
1answer
254 views

Installation Issue - Database Triggers not allowed by hosting provider

After spending 3 months configuring and testing CiviCRM on a locally hosted/internal server (and being suitably impressed), I attempted to install onto our website which is hosted with GoDaddy. I ...
2
votes
3answers
158 views

DB Error: constraint violation on anonymous user event registration after 5.8.2 -> 5.9.0 update

After updating from 5.8.2 to 5.9.0, anonymous users suddenly get the above error when trying to register for an event. Anyone a good hint how to resolve that? Thanks Debug log shows Datenbank-...
2
votes
1answer
394 views

CiviCRM Initalization Error: DB Error: extension not found

I've got CiviCRM installed within a WordPress context, and both are updated. The problem is that, with the last update that occurred, I can no longer get to CiviCRM. Instead, I get the following ...
2
votes
4answers
258 views

After upgrade to 5.0.2 from 4.7.30 getting “DB Error: No such field” on queries

Since updating my CiviCRM 4.7.30 on WordPress 4.9.5, I am getting "DB Error: No such field" when doing queries through Advanced Search or Search Builder. Some of the problems where when I was trying ...
2
votes
1answer
51 views

CiviCRM on Azure Not Finding the Server

I am trying to install CiviCRM on Azure using the Wordpress for Linux web app and it appears CiviCRM is failing to find the MYSQL server. I've checked many times to see if the database information, ...
2
votes
3answers
135 views

Using civi for big data sets (1 million plus)

I love civi! But mainly i use it for small datasets of sub 10,000 I have the opportunity to suggest its use in an organisation with a voter pool of 1 million+ I know this is an open ended question ...
2
votes
4answers
78 views

Capacity Planning

We would like to propose the utilization of CiviCRM in a big organization. They have 140.000 contacts, that manage more then 1.000.000 activities each year (including mails, contributions, etc), and ...
2
votes
1answer
437 views

DB Error: connect failed (code 24)

Anyone have any idea how I can fix this? Just done install and CiviCRM did not load (all OK on wizard) then nothing. Removed CiviCRM from the WordPress install and uploaded again (also removed ...
1
vote
0answers
48 views

Update Indices fails with errno 150 on DROP INDEX UI_case_contact_id after upgrade from 4.6 to 4.7.27

Upgraded from 4.6.19 to 4.7.27 (on wordpress 4.8.3) and attempted to update indices. The table that fails is civicrm_case_contact, with the old index UI_case_contact_id. The error is identical to ...
1
vote
1answer
178 views

InnoDB is default, but can't install

Innodb IS default engine, but can't install. Error message is Unable to create InnoDB tables. MySQL InnoDB support is required for CiviCRM but is either not available or not enabled in this MySQL ...
1
vote
1answer
169 views

regen.sh - Call to undefined function db_query()

So I was following this doc to add a new setting which asked me to run bin/regen.sh script. But running the script failed with the following error: PHP Fatal error: Call to undefined function ...
1
vote
2answers
48 views

What tables are used for civicrm reports?

I need to know what tables and fields are used for the CiviCRM reports, I've been dealing for several weeks trying to see why an updated site from CiviCRM 4.2 to 4.7.16 on Joomla is not showing any ...
1
vote
2answers
85 views

Your database settings don't appear to be correct. All green, but still error!

trying to install CiviCRM with Wordpress and I get the red DB error BUT all the line items are green. Any suggestions? Thanks! WP: 4.9.10 CiviCRM: 4.7.30 Wordpress Mysql: 5.7 on Azure Added ...
0
votes
2answers
59 views

Contacts not merged When creating Account on Event Page - DB Error: already exists

Running: CiviCRM 4.7.17, WordPress 4.9.4 When an anonymous visitor tries to register for an event, we have them required to sign in or create an account via Civi's profile settings to keep our ...
0
votes
3answers
56 views

Recurring iATS contributions not creating civicrm_finanical_item records

We are ramping up for online donations and use the Accounting Batches CSV export to get our Civi contribution data into our 3rd party accounting software. A key piece of data from that report is the '...
0
votes
3answers
757 views

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

We have moved our hosting to new hosting provided (CiviHosting). CiviHosting installed a fresh installation of CiviCRM 4.7. We then imported our previous sql dump from our old site which also had ...