Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

1
vote
1answer
23 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 ...
1
vote
1answer
46 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 ...
2
votes
0answers
20 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 ...
1
vote
2answers
29 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 ...
4
votes
1answer
39 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 ...
0
votes
1answer
127 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
86 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
24 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 ...
2
votes
1answer
39 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 ...
0
votes
2answers
60 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 ...
2
votes
2answers
42 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 ...
0
votes
3answers
79 views

How can I completely remove previous improperly uninstalled CiviVolunteer?

I'm trying to install the CiviVolunteer extension (Drupal 7, Civi 5), but am getting this error message in response: Field: name must be unique. An conflicting entity already exists - id: 186 It ...
1
vote
1answer
93 views

SQL Syntax Error - When starting civicrm with joomla

Please help, i have no idea what is wrong, all is fine until i open civicrm with joomla, it displays sql syntax error, then when I try to look at my db functions with phpmyadmin there will be a whole ...
4
votes
2answers
229 views

Issues with Migration - Cannot add foreign key constraint

I'm having multiple issues with a CiviCRM 4.7.17 on WordPress 4.9.5 which has encouraged me to make different attempts to migrate the site following the official SysAdmin Guide. The closest I've ...
3
votes
2answers
122 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/...
0
votes
1answer
12 views

Dokumente ablegen

gibt es in Civi eine Möglichkeit Dokumente, Bilder, Dateien abzulegen? In der Demo Version finde ich die Möglichkeit nicht. Vielen Dank für Eure Mühe. Beste Grüße Horst
3
votes
0answers
149 views

Wordpress V4.7.31 install - Cannot add or update a child row: a foreign key constraint fails

installation fails with a bunch of the same errors. Summary below: DB_Error object ( [error_message_prefix] => [MODE] => 1 [level] => 1024 [code] => -3 [MESSAGE] => db ERROR: ...
3
votes
1answer
123 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 ...
1
vote
1answer
42 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 ...
1
vote
2answers
817 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 ...
0
votes
1answer
16 views

Fixing null sort and display names

In one of the systems we support there are some contacts with NULL display and sort names. This means they don't show up in searches. How do we fix these?
3
votes
0answers
50 views

Activity Tab takes much time to load on civi 4.7.29

The activity tab on the contact summary page takes much time to load and list the activities. Below is the time-consuming query which takes around 20-25 sec each for the contacts having ~50 activity ...
1
vote
2answers
71 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
3answers
59 views

migrating civi database from current hosting to civihosting.com

We recently signed up for shared hosting at civihosting.com and want to move our current site there. Both sites are running CiviCRM 4.7.29 and WordPress 4.9.1. I cannot get into the CiviCRM ...
2
votes
1answer
180 views

CiviCRM Wordpress Migration: Stumped by the Database

I am attempting to migrate an existing Wordpress CiviCRM installation to a new server, but am having some difficulty with the database part. The existing installation is Wordpress 3.8.1 and CiviCRM ...
0
votes
0answers
55 views

CRON JOB fails because a mysql table not found

Have recently upgraded from CIVCRM 4.1.xx to 4.7.25. Now running in Wordpress (but 4.1.xx was a Joomla 2.5 site). Most things work but one issue is running the master CRON job. I get an error saying ...
1
vote
3answers
52 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 "...
1
vote
0answers
32 views

Should I be worried about granting select on civicrm tables to drupal user?

To use drupal views to display civicrm data, you need to grant SELECT on the relevant tables in the civicrm database to the drupal user. I want to start creating some views because they offer so much ...
2
votes
0answers
45 views

Too many tables - MySQL limitation - CiviCRM API errors

On CiviCRM 4.6.31 We have seen CiviCRM errors with SQL LEFT JOINs relating to custom data sets. It appears there is a MySQL limitation on how many tables can be joined. This impacts on a number of ...
1
vote
0answers
19 views

CiviReport - how do I return NULL values for Participant Report with Membership Details

I have created several custom reports for CiviReport. To create the SQL for these reports I have used 'Toad for MySQL' to visualise the proposed end-result. In my latest report I am trying to return ...
3
votes
1answer
34 views

What character is VALUE_SEPARATOR?

I need to run a MySQL query to split the values in the fee_level field of the civicrm_participant table. I just can't determine what character to use as the delimiter. When I look at VALUE_SEPARATOR ...
1
vote
2answers
31 views

Using an External (custom) Table in a Custom Report

I have several custom tables that I have created for use with extensions that I have built. I would like to use those tables in a custom report. What is the best approach for this? I checked the ...
2
votes
1answer
41 views

Call to undefined function mysql_error() when install extension CiviHR for CiviCRM

I'm using Joomla 3.7.5 and CiviCRM version 4.7.12. I access to "CiviCRM » Administer » System settings » Extensions » Add new" to install CiviHR extension but CiviHR not in the native list. So I do it ...
5
votes
3answers
265 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 ...
1
vote
0answers
122 views

Duplicate Entry UI_External_Identifier MySQL Error

Everytime I try to import a backup of my CiviCRM sql database, I always get an error: #1062 - Duplicate entry '' for key 'UI_external_identifier' in phpmyadmin (4.7.0, PHP version: 7.1.4, mysql 5). I ...
0
votes
1answer
45 views

Error: Sorry we are unable to provide this at the mom

CiviCRM 4.6 WordPress 4.8.1 This is a brand new installation with one record in the contacts table. When I did a search I got this error. There are no custom fields. More error details: Database ...
1
vote
1answer
45 views

Scheduled Reminders DB Error v 4.7 under Drupal

After upgrading to v 4.7.16 in May, the scheduled reminders do not run. I get "DB Error: syntax error" Here's the query from the log. I cut & pasted so I hope I got all the information someone ...
2
votes
4answers
71 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. ...
3
votes
3answers
170 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 ...
1
vote
1answer
39 views

Why is the CiviCRM installer unable to connect to the MySQL server?

I am using Drupal 7.56 and CiviCRM 4.7.21 on Ubuntu 16.04. The Apache and MySQL servers run on the same host. The Drupal and CiviCRM databases are stored on the same server, and are accessed with a ...
2
votes
2answers
100 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
1answer
80 views

Table for Custom Fields

I'm using Joomla and CiviCRM 4.7 and I want to add custom fields to the Participant List that's available as menu item on Joomla. I've searched all of the tables but I don't know where to find the ...
2
votes
1answer
48 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 ...
2
votes
1answer
49 views

What is required to run CiviCRM on Amazon RDS?

Amazon have scalable MySQL/MariaDB offerings in Amazon RDS for MySQL (and Amazon RDS for MariaDB). CiviCRM uses MySQL functionality extensively, so it would be interesting to see if the two work well ...
1
vote
1answer
329 views

how to copy data from one custom field to another (text to textarea)

I created a custom data field of type text (alphanumeric) for use in a profile, but now realize it should have been a textarea (primarily to support line/paragraph breaks). A number of the these text ...
3
votes
3answers
468 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 ...
0
votes
0answers
42 views

MySQL code coming up on reportpage

On both the Donation Summary Report Organization and Household pages, this code is coming up on the screen. There are two things I have done lately that could have caused this - 1 is I updated to the ...
0
votes
1answer
18 views

Legacy SQL Activity and Contacts Dump Transfer

Because of the excessive problem that happened to me on SQL, I had to create a new CiviCRM installation. How can I transfer the existing Individual profiles and Activities in the old CiviCRM database ...
3
votes
2answers
346 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
1answer
133 views

Drupal - MySQL support not included in PHP

I am getting the following error on install of CiviCRM: PHP Configuration MySQL support MySQL support not included in PHP. I am running: CENTOS 6.8 Apache 2.4.18 Drupal 7.54 CiviCRM 4.7.16 ...