We’re rewarding the question askers & reputations are being recalculated! Read more.

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
2answers
42 views

Change of custom field type to bigint

I have a custom group where one of its custom fields is of type varchar(64). This field is storing huge numbers only (something that I did not know during development) so I want to convert it into a ...
0
votes
1answer
32 views

Can I change a contribution's values for Financial Type and Campaign directly in SQL without danger?

When using "Import Contributions > Update Existing Contributions" I can import a Financial Type using the full name of an existing (and active) Financial Type. However, if I try to use the full name ...
0
votes
1answer
56 views

Multiple Entry Custom Values : Find modified ID?

Whenever custom data is written to the database you can use the module_custom() hook to determine what most of the parameters written were. However, I've been unable to find the 'id' of the write. ...
0
votes
0answers
32 views

Unknown column civicrm_relationship.is_active while child smart group edit (create temporary table fails)

There are a parent Smart Group which contains several "child" Smart Groups. All was working a while, until at some time point it starts throw an error, something like [debug_info] => CREATE ...
0
votes
1answer
11 views

Intermittent instances of duplicate participant rows created - is this a MySQL issue?

CiviCRM 4.4 install that has been running for ~ 2 years now, no update to code - in the past week I have seen 3 instances of duplicated participant rows (same contact_id, same event_id, fee, but ...
5
votes
3answers
235 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 ...
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 ...
1
vote
2answers
128 views

General Error 2006

I get the following error in various situations, detailed below. SQLSTATE[HY000]: General error: 2006 MySQL server has gone away DB Error: unknown error I get it consistently when trying to enter ...
0
votes
1answer
107 views

Joomla timezone mismatch

For some reason Civi is using UTC and not the Joomla time. The system, and php and mysql times are reporting correctly (Brisbane) . For Mysql I have run the following to get its time; SELECT NOW() ...
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 ...
3
votes
0answers
105 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 ...
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 ...
1
vote
2answers
40 views

non-asci characters ending up in database

Today we spent about 2 hours bashing our heads trying to get a string compare to work so we could run a query against contact sub type while setting up a new participant public listing. We started ...
2
votes
5answers
575 views

INSTALLER fails. Database can't “SELECT GET_LOCK” at civicrm/install/index.php(271)

After complete wipe and install new MYSQL 5.7.9 can't get fresh civi drupal up and running but existing drupal sites work fine. So I'd like to know if others can install on this combination or if a db ...
3
votes
2answers
59 views

1 hour discrepancy between created_date field in MySQL and CiviCRM report output

I hope I have a strange, but straight forward issue -- there's a 1 hour offset SOMETIMES in the created_date field in civicrm_contact table, and what gets outputted in a CiviCRM report (see the ...
3
votes
1answer
109 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, ...
2
votes
1answer
94 views

Getting error message upon installation

Getting this error message just as I am trying to set things up should I be worried? 0 <div id="crm-container" class="crm-container" lang="en" xml:lang="en"> <style type="text/css" media="...
2
votes
0answers
594 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
609 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 ...
4
votes
1answer
221 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 ...
2
votes
1answer
238 views

Migrating domain to new server. mysql migration Error 1881

Wordpress 4.3.1 CiviCRM 4.5.5 Old host: Apache 2.2.26 - PHP: 5.3.28 - MySQL: 5.1.73 New host: Apache 2.2.29 - PHP: 5.3.29 - MySQL: 5.6.23 My only export options on the old host are via phpMyAdmin ...
6
votes
2answers
171 views

CiviMail recipient count stuck on Estimating

I'm unable to send and/or produce test emails for large mailings. This seems to be a result of CiviMail not completing the recipient estimation process. Attempting a test email while it's stuck on "...
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. ...
3
votes
0answers
65 views

Deleting job log files on database

Is it safe to delete job log files? I currently have 504,742 lines in my civicrm_job_log table, which comes to 223MB.
2
votes
2answers
48 views

is there an easy local install method for civics and all dependent software

I'm investigating civicrm for a work use at the ngo where I work. We don't have in-house It team who can help install it. So I'm trying to do so myself. I have some experience using Ubuntu and basic ...
0
votes
2answers
70 views

Upgrade to 4.6.6 : how to configure mysql server?

I upgraded Civicrm to 4.6.6 (next 4.6.7) and had a lot of problems since then. My sql server has started consuming much more memory while everything was allright before the upgrade with 512M of RAM. ...
3
votes
1answer
125 views

What is the best way to avoid cartesian product on specific SELECT attributes?

I faced similar issue in some CiviReports where some of the Select attributes applied with Group function like SUM(), got affected due to LEFT JOINs. Let me provide further clarification on basis of ...
1
vote
1answer
81 views

Why is my MySql DB Connect failing on New Joomla install

When trying to install Civicrm 4.6.5 onto Joomla 3.4.3 I am getting the following error once the install is started from the install for directory option "Cannot open mysql://root:'rootpassword'@...
0
votes
1answer
162 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 ...
3
votes
5answers
497 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 ...
1
vote
1answer
41 views

Civi Database erased when upgrading from 4.6.3 to 4.6.4

I tried to upgrade from Civi version 4.6.3 to 4.6.4 but ended up having my crm database erased and filled with an empty civi database. I have tried to import my backup sql file in phpMyAdmin and get ...
3
votes
3answers
153 views

save contact with non numeric phone number gives access denied civicm_strip_non_numeric

I recently update civicrm till 4.6.2 till 4.6.4 on drupal 7.38, mariadb 5.5.41. When saving a contact with a non numeric phone number (+32 123456798) I got the error: Database foutcode: execute ...
4
votes
2answers
122 views

How can I prevent deduping from killing my server?

On a reasonably big data set (e.g. one with 70,000 individual contacts), it's not hard to kill your server with a naive manual de-duplication attempt. For example, if you don't specify a group, that ...
3
votes
1answer
23 views

What is the significance of event_queue_id in civicrm_mailing_event_delivered table?

I generally find that the event_queue_id and id values are same for all the tuples in the civicrm_mailing_event_delivered table. Why do we need a separate event_queue_id then? Can two tuples in this ...
1
vote
3answers
47 views

How do I find the mails belonging to a particular mailing by looking at the SQL tables?

I've the dump of civicrm_mailing_event_delivered table. It has 3 fields - id, event_queue_id and timestamp. By looking at this table, how do I find the mails belonging to one particular mailing? Why ...
2
votes
2answers
82 views

How can i match CiviCRM ID on two installations?

I have two instances of CiviCRM, not all the CiviCRM ID's match. How can i get the contacts on both databases to have the same CiviCRM ID (ie CiviCRM ID of contact A in db1 = CiviCRM ID of contact A ...
15
votes
2answers
646 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' ...
5
votes
1answer
287 views

How do I correct mismatched Timestamps for MySQL and PHP without access to server?

I'm using civiCRM 4.6.2 under Wordpress. The PHP and MySQL timezone settings are reported as incompatible, MySQL as 12:38 (which is the current clock time here in Zurich) and PHP as 10:38. However, ...
3
votes
2answers
93 views

Does this view error mean CiviCRM has lost some MySQL DB perms?

The last CiviCRM upgrade I was running, I received a couple of the same DB errors. Sanitized, minimally, the error was as follows: #7 /srv/www/sites/d1.orgname.org/www/sites/all/modules/civicrm/...
1
vote
2answers
61 views

What causes periodic database errors while using logging, and what should I do about it?

Running a Drupal site with CiviCRM Logging enabled. It seems like once a month we get a crash. On investigation one of the log tables is corrupted. Since the tables are type Archive MYSQL provides ...
11
votes
4answers
2k views

What is the easiest way to see the MySQL queries run by a CiviCRM page?

When debugging CiviCRM pages, is there a native way to emit the SQL statements being run, eg on a Search page? I'm looking for something easier than finding the code for the page and putting in a ...