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.

16 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
1answer
30 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?
3
votes
0answers
38 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 ...
3
votes
0answers
164 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
0answers
58 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 ...
3
votes
0answers
50 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 ...
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
0answers
598 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 ...
1
vote
1answer
16 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 ...
1
vote
0answers
66 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 ...
1
vote
0answers
37 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 ...
1
vote
1answer
52 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
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 ...
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 ...
1
vote
0answers
178 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
0answers
17 views

On update of civicrm_membership table, which are other tables which are affected?

I need to update the membership id and replace its value with that in the contact id's external identifier. So I followed the explaination here for CASCADE. https://stackoverflow.com/questions/...
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 ...