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
3
votes
3answers
218 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
42 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
110 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
95 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
57 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 ...
3
votes
1answer
60 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
373 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
757 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
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
436 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 ...
2
votes
1answer
140 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 ...
2
votes
4answers
393 views

How to check if DB table exists?

Is there a built-in way to check to see if a DB table exists via PHP? I'd like to add that to my API call and create the table if necessary. Thanks!
0
votes
1answer
460 views

Site broken. How do I fix Couldn't repair table: civicrm.log_civicrm_status_pref?

On Drupal 7.52 and CiviCRM 4.7.13 Recently I discovered Civicrm couldn't connect to MySQL. This wonderful error popped up when registering someone for an event: DB Error: no database selected ...
0
votes
1answer
57 views

SQL to unlink contacts and drupal accounts

1) In what table/field of the CiviCRM database is the Drupal User ID stored? 2) What is the SQL statement to delete all rows in that table except User1? Due to the way we imported contacts and ...
0
votes
2answers
43 views

How do I set the value of external_id to be the same as a custom field?

Running Civi 4.7.13 with Drupal 7.52. I want to set the value of external_id in the Contacts table to be the same value as a custom field (using the API explorer, it seems this field is called ...
2
votes
1answer
345 views

Should I change mysql.connect_timeout variable in php.ini?

MySQL has been losing connection on me while trying to complete the upgrade. I am wondering if I should change the php.ini variable mysql.connect_timeout = 60 to a value of -1 (unlimited) and if this ...
3
votes
2answers
103 views

What are these big MySQL mailing tables for?

Tomorrow, I will again begin the process of updating CiviCRM. I know that as the upgrade process is going through 4.7.8, it upgrades mailing foreign key constraints in civicrm_mailing_event_queue and ...
1
vote
1answer
91 views

Syntax for drush command civicrm-sql-dump

My attempt to backup my civicrm database using mysqldump has failed after a very rocky CiviCRM upgrade process, or it is taking way too long, so I am trying the drush command, drush civicrm-sql-dump ...
3
votes
1answer
414 views

Need help solving unserialize():Error at offset

Thank you all for your continued patience with me. Since the past two updates, I keep getting the following error: Notice: unserialize(): Error at offset 0 of 8 bytes in Civi\Core\SettingsBag->...
1
vote
1answer
27 views

No run_time timestamp in civicrm_job_log

Currently, my civicrm_job_log is the largest table in our database. There was a post Can I safely trim civicrm_job_log and civicrm_log? that mentioned an extension that would keep this table trimmed ...
0
votes
1answer
23 views

CiviReport - Add days to Transaction Date for Estimated Deposit Date

Our Treasurer has asked for a report that will help him reconcile the monthly bank statement more efficiently. As with most financial services vendors, our vendor (iATS) has a delay between the ...
2
votes
1answer
252 views

Transfer Database to new location raised MySQL Error function already exists

I follow the instructions here https://wiki.civicrm.org/confluence/display/CRMDOC/Moving+the+database+using+phpMyAdmin I want to import the so called Old_without_five_tables.sql with phpmyadmin in ...
1
vote
2answers
2k views

“alter routine command denied to user” error when installing extensions?

I have installed civicrm 4.7 on drupal 7. Installing of extension failed with error: DROP FUNCTION IF EXISTS civicrm_strip_non_numeric [nativecode=1370 ** alter routine command denied to user '...
3
votes
1answer
60 views

Error on CiviCRM Installer Page

Warning: Invalid argument supplied for foreach() in /public_html/wp-content/plugins/civicrm/civicrm/install/index.php on line 769 I'm also receiving the following under PHP Configuration: MySQL ...
2
votes
1answer
50 views

Do I need root access to my database to use CiviCRM? [duplicate]

After installing your plug in, I looked at the CiviCRM installer page and was shown an error which said "unable to create database triggers". I have shared hosting. Is it possible to still use this ...
2
votes
1answer
127 views

“MySQL support not included in PHP error” in CiviCRM-4.7.10-wordpress

I'm getting the error "MySQL support not included in PHP" in the CiviCRM installer wordpress page. My setup is: Ubuntu 16.04 Wordpress 4.6.1 CiviCRM 4.7.10 php 7.0 with mysqli php extension ...
0
votes
2answers
63 views

MySQL errors when transferring database from one server to another

I am shifting my server for my DRUPAL7 + Civicrm website. I followed the process outlined here I have the drupal site working fine and a fresh install of Civicrm working fine. Now i just need to ...
2
votes
1answer
246 views

Installation Issue - Database Triggers not allowed by hosting provider

After spending 3 months configuring and testing CiviCRM on a locally hosted/internal server (and being suitably impressed), I attempted to install onto our website which is hosted with GoDaddy. I ...
2
votes
2answers
45 views

Complex multiple Selects in Custom Coded Reports

Following on from my query here How to write custom report SQL (CiviCRM 4.7 on WordPress) I built the SQL I needed as step 1, which works fine in mysql / phpmyadmin. I have used civix, to generate ...
2
votes
1answer
45 views

CiviCRM Installer Errors - Can't change DB settings

I can't get past the install page (/wp-admin/admin.php?page=civicrm-install). The installer prepopulates to my WordPress DB settings and won't take the CiviCRM DB settings I put in. I input the MySQL ...
1
vote
2answers
26 views

Upgrade from 4.6.20 to 4.6.21 fails with fatal error (sqlfile not found)

We're using D7 / Civi 4.6.20, attempted to upgrade to 4.6.21 following the Civi upgrade documentation. The upgrade errors out with this error: Exception: "A fatal error was triggered: sqlfile - 4.6....
1
vote
1answer
21 views

mySQL 5.1 to 5.5 upgrade - radio button data error

We have upgraded MySQL from 5.1 to 5.5 and now when we extract the data what was previously showing as yes/no is now showing as 1/null, in addition the first row of data is showing the correct yes/no ...
0
votes
1answer
90 views

MySQL to MySQLi

We have a 4.1 installation with PHP 5.3. The current PHP install uses MySQL, not MySQLi. I need to enable MySQLi to support a new application. Our hosting company says this will entail recompiling PHP ...
5
votes
1answer
449 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, ...
9
votes
1answer
240 views

CiviCRM still creates MyISAM tables which results in Warning

CiviCRM 4.7.10 --- WordPress 4.6 The following warning message appeared in CiviCRM System Status: Your database is configured to use the MyISAM database engine. CiviCRM requires InnoDB. You will ...
1
vote
4answers
317 views

CiviHosting and MySQL 5.7

CiviHosting has sent a notice to all their customers that they are upgrading all their servers to MySQL 5.7, despite their acknowledgement that CiviCRM prior to version 4.7.7 "may fail". They plan on ...
1
vote
4answers
75 views

Log table: nativecode=1118 ** Row size too large. You have to change some columns to TEXT or BLOBs

Pretty strange, since column mentioned is already of type TEXT. Full error message: [debug_info] => ALTER TABLE `civicrm_logs`.log_civicrm_value_grants_external_application_45 MODIFY `...
4
votes
1answer
147 views

Suscpicious Database Errors

In my installation I firstly recognized database errors like described in CiviCRM issue CRM-19109: Draft mailings are not saved. In a fresh local installation (Ubuntu 16.04LTS, php 5.6, mysql 5.7.13, ...
0
votes
1answer
89 views

Funky errors in 'drush cvup' / 'drush cvupdb'

I'm trying to upgrade from CiviCRM 4.7.4 to 4.7.9 for its security update. I'm doing this using 'drush' on my dev site. It seems to be hitting a couple different problems. Here's the first step: % ...
0
votes
1answer
26 views

Problem with imported case activities not appearing in the case record

Identical issue to: https://forum.civicrm.org/index.php?topic=32904.msg140249#msg140249 which was never solved. Manually inserted a case with all of the tables mentioned in the post, yet it doesn't ...
1
vote
1answer
33 views

Problem in civicrm upgrade 4.74 to 4.7.5 in drupal 7

When I Intented upgrade my site from civicrm 4.7.4 to 4.7.5 in drupal 7 one error appear and don't is possible continue. (sorry for my english) Could yo help me with this error? This is the error ...
2
votes
3answers
190 views

Storing Personally Identifiable Information

Is anyone storing Personally Identifiable Information (PII), such as Social Security Numbers (SSN), in their database? How would I encrypt such a field in the database? I'm expecting that it would ...
0
votes
1answer
242 views

Remote Database Connection

I apologize if I am asking this in the wrong place, but I've hit something I cannot figure out.. I have remote drupal and civicrm databases that I want to use for multiple developers. My question ...
5
votes
1answer
45 views

Dropping thousands of records into a batch via SQL

I have imported (tens of) thousands of historic contributions to a site that uses Accounting Batches regularly. They were starting to bog down the batch assignment page so I thought I would simply ...
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
30 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
31 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
228 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 ...