Questions tagged [mysql]

The relational data management system that is used by CiviCRM. It is open source just as CiviCRM and the only database that is supported (Although the drop in replacement MariaDB works also fine). Minimal 5.1.x with INNODB support.

Filter by
Sorted by
Tagged with
2
votes
0answers
580 views

Does the 'timestamp mismatch' error cause any real problems?

I am getting the following error when I log in to CiviCRM: Timestamps reported by MySQL (eg "2015-11-06 13:44") and PHP (eg "2015-11-06 11:44" ) are mismatched. I have reported this separately ...
5
votes
5answers
604 views

Timestamp mismatch between MySQL and PHP

Every time I log in to CiviCRM I get the following error message: Timestamps reported by MySQL (eg "2015-11-06 13:44") and PHP (eg "2015-11-06 11:44" ) are mismatched. I am using CiviCRM 4.6.10 ...
9
votes
4answers
1k views

Error during Drupal installation: MySQL support not included in PHP

I am getting an error as show by the image above when attempting to install CiviCRM on drupal. What does this error message mean and how could I go about fixing it? The entire configuration report ...
10
votes
4answers
1k views

MyISAM database but all civicrm_ tables are INNODB… is this a problem?

I just upgraded a large site to 4.7 (without any issues in the upgrade process by the way). The new "System Status" admin screen gives a warning as follows: "Your database is configured to use the ...
3
votes
3answers
227 views

ER diagram for the latest Civicrm , Foreign key in Structure, test cases/plans

Where can I get the ER diagram for the latest CiviCRM? I need it for internal reporting purposes in our organization. I am able to download the Table structure from phpMyAdmin. However, it does not ...
3
votes
1answer
108 views

How do I modify a core CiviCRM file (to change a search order)?

Looks like one of core CiviCRM files (namely part of mySQL query at CRM/Contact/BAO/Query.php) has to be changed in order to achieve "Search results sort by Last Name". What would be the best (I mean, ...
5
votes
2answers
148 views

Why can't I save search preferences? Specifically 'Autocomplete Results'

On my 4.6.14 system I'd like to change the 'Autocomplete results' to (say) 15, but it won't save. This is in 'Administer/Customise Data and Screens/Search Preferences'. I've can change the 'Smart ...
4
votes
1answer
150 views

Suscpicious Database Errors

In my installation I firstly recognized database errors like described in CiviCRM issue CRM-19109: Draft mailings are not saved. In a fresh local installation (Ubuntu 16.04LTS, php 5.6, mysql 5.7.13, ...
2
votes
1answer
61 views

No such field: card_type, but exists

I've upgraded CiviCRM multiple times since we last ran an event which requires payments, and are now at 4.7.17 on Joomla 3.6.5 with MySQL 5.7.18. When many (not all) users try to register they ...
1
vote
1answer
90 views

Temporary table keeps showing up and throwing MYISAM error and Missing Log Tables error

One installation I help with keeps throwing a MYISAM error that is related to a temporary table, as well as a "Missing Log Tables" error (which I assume is related as they always appear together). If ...
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' ...
4
votes
1answer
217 views

MySQL Master-Master Replication on 2 servers

For our installation in a "Third World Country" we need 2 replicated Master-Master Mysql-Servers: one in a European data center to serve the public website and allow access from mobile devices to ...
5
votes
3answers
316 views

Performance Warning: Missing Indices. Mismatched Index Key

Just upgraded to 4.7.23 and am receiving a Performance Warning: Missing Indices. The warning states: The following tables have an index key with a mismatch in value. Please delete the key ...
3
votes
0answers
100 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
3answers
842 views

Is 1Gb memory enough for small server?

We have AmazonAWS t2.micro server (free tier). T2. micro has 1 Gb of ram and 1 vCPU. Only CiviCRM (4.7.14) is hosted there along with its Drupal. Currently the database is very small (less than 5000 ...
2
votes
4answers
80 views

Best way to integrate two sites with different security levels

We have a civi install that contains some sensitive data. We also have a public facing website. We would like to integrate them so that you can sign up for events, give donations etc on the website. ...
2
votes
1answer
252 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
1answer
45 views

CiviCRM Installer Errors - Can't change DB settings

I can't get past the install page (/wp-admin/admin.php?page=civicrm-install). The installer prepopulates to my WordPress DB settings and won't take the CiviCRM DB settings I put in. I input the MySQL ...
1
vote
2answers
104 views

One Database or two?

Is there a reason to use two separate databases for CiviCRM and Drupal, or can I use the same for both? What would be affected if I used the same for both?
0
votes
1answer
161 views

Advanced Search error after upgrade to 4.6.5

We upgraded from 4.5.8 to 4.6.5 today (on Drupal 7.38). The only known issue at this point is on the Advanced Search screen. Using the Relationship search field "Target Contact(s) in Group" results ...
0
votes
2answers
46 views

How do I set the value of external_id to be the same as a custom field?

Running Civi 4.7.13 with Drupal 7.52. I want to set the value of external_id in the Contacts table to be the same value as a custom field (using the API explorer, it seems this field is called ...