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
2
votes
1answer
51 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
319 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
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
1answer
55 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
53 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
87 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
243 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
43 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
115 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
99 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
62 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
65 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
390 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
880 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
481 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
143 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
477 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
479 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
46 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
407 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
115 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
102 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
462 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
28 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
285 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
61 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
64 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
254 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
46 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
30 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
92 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
476 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
248 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
328 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
83 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
159 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
95 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
28 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
34 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
200 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
252 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 ...