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.
198
questions
1
vote
1
answer
50
views
Installation error (MySQL)
I am trying to install CiviCRM, but when I get to the point of installing it within WordPress, I get the following errors:
Severity (error) Section (Databases)
[Name + Details 1]: CiviCRM MySQL ...
0
votes
0
answers
6
views
SqlGroup: Failed to acquire lock on cache key
Got the "SqlGroup: Failed to acquire lock on cache key" and consequent "504 Gateway Timeout" trying to execute a simple API4 exercise:
$events = \Civi\Api4\Event::get(FALSE)
->...
3
votes
1
answer
21
views
"MySQL Timezone Problem" Status alert: what test is run to display this alert?
I look after a number of CiviCRM implementations. Some of them display the System Status alert about "MySQL Timezone Problem", and advise that timezone data needs to be loaded.
However when ...
1
vote
1
answer
45
views
Looking for Experienced & Knowledgeable CIVICRM Freelancer
Looking for referrals for a knowledgeable, experienced CIVICRM expert (not a consulting company) that freelances and that I could keep on retainer to assist with CIVICRM technical and application ...
0
votes
0
answers
25
views
Bad performance on CiviEvent Dashboard
We have a site that is fairly performant, around a second for most CiviCRM actions.
But the CiviEvent Dashboard is extremly slow, around 12 seconds. Over the years we have hosted a number of events ...
1
vote
1
answer
18
views
SQL error when installing Joomla add-on
I am trying to install the add-on for Joomla, but I get the following error message:
Cannot execute CREATE TABLE `civicrm_extension` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Local ...
0
votes
0
answers
22
views
Retrying after Database deadlock encountered hit on attempt 1 at query : INSERT INTO civicrm_mailing_recipients?
Drupal 10.2.3 , CiviCRM 5.70.0, PHP 8.2.13, MySQL: 10.6.16-MariaDB-0ubuntu0.22.04.1, nginx/1.18.0
Got the below in logs after almost each contribution (contributions status="Completed" ) :
...
2
votes
1
answer
120
views
Storage engine MEMORY is disabled with digitalocean managed database
I have this error:
Possibly unhandled rejection: {"error_code":-1,"sql":"CREATE TEMPORARY TABLE civicrm_tmp_e_exrecipient_dc8f2500b15714f5703ad66bc5a8bb37 (contact_id int ...
2
votes
1
answer
101
views
Database Upgrade from 5.65.0 to 5.67.0 throws WSOD and kills MySQL
On my local lando dev environment, I proceeded to composer update to get onto the latest stable/recommended Drupal 10.1.6 and Civi 5.67.0.
Post-upgrade state:
CiviCRM UI seems to work fine
CiviCRM ...
0
votes
0
answers
41
views
MySQL ERROR 3161 at Change Log on Contact pages after db migration
After db migration, Change Log tab on Contact pages doesn't load due to error about creating temporary tables using memory engine.
I could recreate the error with the following query:
mysql> CREATE ...
1
vote
1
answer
36
views
The mysql commands you need to run are stored in
Have got this after the most recent CiviCRM 5.58.1. update on Drupal 7 ( same udate went fine on WP sites ).
ConfigAndLog/CiviCRM.trigger63f7a62151e54WPFX4db1365ff9d7f93fb47a7eb13184cce6.sql contains, ...
0
votes
1
answer
27
views
MySQL OptionGroup values, retrieve in SELECT statement
Using Drupal 8.9.20 and CiviCRM 5.39.1 (on Ubuntu 18.04 LTS).
I need to write a query in MySQL to retrieve the values of an optiongroup.
The OptionGroup is used to assign keywords to a contact record ...
1
vote
1
answer
268
views
What issues are there when running with a database that "does not fully support timezones"
I recently installed CiviCRM 5.58.0 on wordpress, but under system status I am getting a warning that says:
The MySQL database does not fully support timezones. Please ask the
database administrator ...
0
votes
1
answer
62
views
DB Error: unknown error when trying to send mosaico civimail
For a recently updated CiviCRM 5.56.2 + Drupal 7 (using mariadb 10.3), I got the little black box with the message "DB Error: unknown error" popping up when trying to send a mosaico civimail ...
1
vote
0
answers
35
views
Cannot Add Contributions for Some Contacts
I have had and solved an error before where MySQL reports "Can't update table 'civicrm_contact' in stored function/trigger because it is already used by statement which invoked this stored ...