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
1
vote
1answer
96 views

Can't find MySQL server on WordPress install with sockets

I am using Local by Flywheel which connects to MySQL with sockets. My socket is: /Users/efc/Library/Application Support/Local/run/Qv8NIbiue/mysqld.sock The MySQL server is localhost, database is ...
1
vote
1answer
12 views

How to update preferred language depending on a custom field in imported contacts?

I have imported hundreds of contacts having a custom field called "Langue" in set "ocsr" and having two possible values, 'F' and 'N'. I want to transfer this information into the field preferred ...
5
votes
1answer
37 views

Has anyone mapped the CiviCRM Schema to Classes in SQLAlchemy?

I would like to use Python and SQLalchemy to construct queries and create reports for Civicrm. Has anyone mapped the Classes and Relationships in order to use the ORM capabilities of SQLAlchemy?
15
votes
2answers
698 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' which ...
1
vote
2answers
44 views

Baffled by Views database error on new install

Hours-old install of CiviCRM 5.25 under Backdrop 1.9. I've gotten as far as putting in the Board of Directors with dummy bio information, which I was trying to use to generate a View with a page ...
1
vote
1answer
37 views

CIVICRM with MYSQL encrypted on ecryptfs

I managed to have CIVICRM (5.15.2 on WP 5.0.7 on Ubuntu 18) running on MySQL (5.7.28) from an encrypted mount via ecryptfs. Currently only the mysql files are in the encrypted mount and it's running ...
2
votes
1answer
55 views

Can't use activity table in join query for update

In our set-up we have custom fields associated to activities, the value of which is computed periodically by scheduled job. The job executes a query that reads something like: UPDATE ...
0
votes
0answers
14 views

Import Contacts to CiviCRM using SQL query

How to import contacts to CiviCRM using SQL query? It should include the Group name too. I have a huge database need to import in CiviCRM, currently getting timeout error if I upload more than 1000 ...
0
votes
0answers
21 views

I get an error “One of parameters (value: sort_name) is not of the type MysqlColumnNameOrAlias” when trying to access most of my data

Okay, I'm new at this - honestly, probably not skilled enough to be doing this, but my organization has no money, so, well, I'm it. I installed on WordPress last year, and everything generally went ...
2
votes
2answers
27 views

how to drop all civicrm tables using drush?

Civi is using it's own (not shared with Drupal) database. During a script to rebuild a dev/test site from production data I want to drop all the tables in the civi dev db. How do I do that? After ...
0
votes
1answer
20 views

Mailings advanced search error - Invalid mysql syntax

I'm on Drupal 7.69 and CiviCRM 5.20.0. As long as I remember I've been experiencing an error when I've tried to look up the bounced recipients of mailings through Advanced Search. I can't look up ...
2
votes
1answer
27 views

What information does log_civicrm_group keep? How is it useful?

Do you use the log_civicrm_group logs? Our log file is now about 300MB - quite crazy. Are records of removal and adding contacts to groups stored here? Thats information we would like to keep. How do ...
3
votes
0answers
29 views

CiviCRM with Master - Slave Replication

I'm interested to get some latest war stories on CiviCRM with Master - Slave replication. Does it work well or are there any known issues? I've seen that Master - Master has some work needed but most ...
2
votes
1answer
37 views

nativecode=1260 ** Row 60 was cut by GROUP_CONCAT()

After an upgrade from 5.7.x to 5.13.x, a standard contribution/detail report started failing. In the CiviCRM admin log, we see this sql error: nativecode=1260 ** Row 60 was cut by GROUP_CONCAT() ...
1
vote
2answers
36 views

Unsure if I just broke my database with a custom field

I added a custom field for authenticated users to add a bio on their profile page (and if there's an existing field I should use for this, please let me know). Not knowing how long I should make this ...
3
votes
2answers
40 views

Update DB Query fails sporadically when saving contact; nativecode=1205 ** Lock wait timeout exceeded

The exact query and issue is below. UPDATE civicrm_contact SET contact_type = 'Individual' , contact_sub_type = NULL , sort_name = 'XXXXXX XXXXXX' , display_name = 'XXXXXX XXXXXX' , first_name = ...
2
votes
1answer
51 views

CiviCRM on Debian 10 gives warning about PHP MySQL Driver (libmysqlclient)

Recently moved my CiviCRM install to a server running Debain 10 which brings: php7.3 MariaDB 10.3.17 Everything seems to be working fine, except that in the system checks I'm now seeing this error/...
3
votes
1answer
25 views

Is it 'better' to use mysql_dsn rather than mysql_ram_disk with buildkit and amp config?

I've successfully set up a drupal-clean test build on my Ubuntu 19.04 machine using buildkit, amp config and amp test and chose mysql_ram_disk rather than mysql_dsn. My intent was to have a semi-...
2
votes
1answer
54 views

mysql_dsn error on amp config - why am I getting “access denied”?

I'm trying to install buildkit on my Ubuntu 19.04 laptop, per the instructions at https://docs.civicrm.org/dev/en/latest/tools/buildkit/#config I've used curl to run the script, successfully - ...
2
votes
1answer
23 views

Everything In CRM is Slow - Errors With CRM_Contact_BAO_GroupContactCache

After a database was corrupted and reloaded from a backup. Looking at the error log this appears to be where CiviCRM is hanging. CRM_Contact_BAO_GroupContactCache::load(Object(CRM_Core_DAO)) Here ...
1
vote
2answers
58 views

Where is the developer documentation for making core CiviCRM database changes, to the schema and to the initial data?

I'm working on a (newer) PR for CRM-19751, which requires some database schema changes and addition of an option group with its options. Obviously I knew something about this when I created the ...
1
vote
2answers
35 views

Unable to enable CiviCase [duplicate]

When I try to enable CiviCase I get a white screen of death and the following msg: "A fatal error was triggered: Could not create the MySQL views for CiviCase. Your mysql user needs to have the '...
2
votes
2answers
82 views

Does civicrm support mysql sockets?

My wordpress is installed and uses localhost:/run/mysqld/mysqld/socket but civicrm only works if I point to localhost Is there a way to install civicrm through file socket ?
3
votes
2answers
61 views

How do you separate wordpress and civicrm tables?

When we first installed CiviCRM - the installer was super eager to install using the existing WordPress database. We were just testing out CiviCRM at the time, so it was not a big deal - however we ...
3
votes
1answer
93 views

SSL-encypted Database connection for CiviCRM?

I am in the middle of deploying a CiviCRM instance and have decided for scalability and security reasons to separate my web server and database server. I have a set of self-signed certificates ...
6
votes
1answer
248 views

When will MySQL utf8mb4 support be mandatory?

With recent upgrade, CiviCRM showed me this message Future versions of CiviCRM may require MySQL utf8mb4 support. It is recommended, though not yet required, to configure your MySQL server for ...
3
votes
2answers
76 views

Trouble saving changes to a report

EDIT: This question turned out to be, in practical terms, something different than I originally thought I was asking. I am changing the title so that others will find the answer more easily in the ...
1
vote
2answers
77 views

Drush sql-sync and civicrm issue

I wanted to quickly pull all the data (contacts, custom types, etc) from one Drupal CiviCRM install to another. I got a little too clever for myself and used Drush sql-sync to do it. It failed. As I ...
2
votes
1answer
88 views

Error: more than 'max_user_connections' active connections

Several times a day on our Civi site (CiviCRM 5.11.0 with Drupal 7.64) we are experiencing the following error: PDOException: SQLSTATE[HY000] [1203] User xxx already has more than '...
2
votes
1answer
73 views

Is there a process to tidy the tables created by logging?

I've successfully improved the performance of the 'Change Log' by taking Eileen's advice here, converting 5 tables to InnoDB and adding indexes. In so doing, I almost blew the space limit on the host ...
3
votes
1answer
23 views

How to set super-user privileges in CiviCRM for MySQL? CiviCRM requesting for multilanguage support

I have properly installed CiviCRM 10.0, PHP version 7.2, in Joomla 3.6.5 on Linux shared hosting. Works perfectly! Now that we have configure the Spanish language in Joomla and in CiviCRM set to "...
2
votes
0answers
107 views

ETA on Support for MySQL 8?

I'm running CiviCRM 5.10.3 on the Bitnami WordPress stack (WP has been upgraded to 5.1), and the version of the Bitnami stakc I'm currently on uses PHP 7.0.30, so I'm getting warnings that as of the ...
4
votes
2answers
79 views

how to get an autoincrementing membership id with existing membership numbers

I've imported our membership list with existing membership numbers into CiviCRM. The old membership numbers are currently under external ID. I'd like an autoincrementing membership number. The best ...
2
votes
2answers
44 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 ...
2
votes
2answers
51 views

WordPress installation with MySql connection problem

I've been trying to install the lastest version, 5.9.1, on a new WordPress 5.0.3 site. Requirement checks all passed but when I clicked "Check Requirements and Install CiviCRM" button I got this error:...
3
votes
3answers
282 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 ...
2
votes
2answers
56 views

What could trigger a transaction rollback on contact save?

I have a few contacts in CiviCRM 4.7.27 for which changes in the "edit contact" form are not saving. The update queries are being sent to MySQL correctly, but they're in a transaction which is being ...
3
votes
3answers
1k 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 ...
1
vote
1answer
102 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 ...
3
votes
1answer
366 views

timestamp mismatch

I have a host running in a different time-zone from where I am operation and unless I set the website time zone to the hosting time zone I get the following error in CiviCRM: Timestamps reported by ...
3
votes
0answers
49 views

Civivolunteer - Can't upgrade or install

I'm running CiviCRM 5.5.3 on Drupal 7.59. I installed CiviVolunteer a long time ago, but had disabled it, because no one wanted to use it at the time. Now, there is interest in using it. So, I ...
2
votes
2answers
122 views

Difficulties generating an entity's DAO and SQL for a new extension

I have been trying to generate DAO and SQL files for an entity I created with civix generate:entity ... according to the documentation ("Add a new entity" - 4.d.). Using the latest civicrm-core clone ...
1
vote
2answers
999 views

Database Error Code: Access denied for user 'civi'@'localhost' (using password: YES), 1045

I encounter a really weird issue. I'm moving my CiviCRM install from an Ubuntu 14.04 server to an Ubuntu 16.04 server. Mysql is now 5.7.21. CiviCRM version is the latest 4.7.30 The default SQL mode ...
1
vote
1answer
1k views

High-load situation produces “Deadlock found when trying to get lock; try restarting transaction”

Each year we go through an enrollment process, where we have groups of up to 60 users at a time registering for our site simultaneously on our one-CPU, 3GB virtual machine running the latest CiviCRM ...
2
votes
1answer
166 views

Issue with MySQL support

Attempting to install CiviCRM 4.6.38 in Wordpress 4.9.8, PHP 7.2.5, MariaDB 10.3.8, Nginx 1.14.0, Amazon Linux 2. Getting "MySQL support not included in PHP". PHPinfo shows mysqli and mysqlnd enabled.
1
vote
0answers
42 views

Three minute payment confirmation url response delay for payment processor

I have a coop.symbiotic.moneticoclassique payment-processor set up and right now everything but the response to the payment gateway works. The user pays for an item and is redirected to the payment ...
5
votes
1answer
556 views

Tweaking my.cnf for performance

Over the last year, with the help of mysqltuner, I've adjusted my.cnf to improve the performance of the 7 CiviCRM installations on my VPS. But in the last few days, as I upgraded my sites to 4.7.10, ...
2
votes
1answer
45 views

How can I restrict access to some CiviCRM tables at the database user level?

I have a Drupal multisite setup with two sites connected to the same civicrm database. One site needs access to all of the data as usual. But I would like to hide some data from the other site, so ...
1
vote
3answers
66 views

My hosting company does not support SUPER privilege - can I use CiviCRM with them?

I finally after a week and 3 tickets got CiviCRM/Joomla to install on my Startlogic hosted server, but I can't add anything to the database. The final response I got from Startlogic support was "...
0
votes
2answers
158 views

Foreign Key issues when restoring db

When we export our db and try restoring to another server we get the foreign key issue below so cant progress. Is it safe to Disable foreign key checks when importing into the new server? (we tried to ...