We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
64 views

DB Error: IP address hard-wired with MySQL user?

I have a local windows "mirror" using XAMPP of my live Wordpress 4.7.2 + CiviCRM 4.7.14 setup. I wanted to use the windows version to test exactly how deduping worked using Contacts > "Find and Merge ...
2
votes
1answer
142 views

DB Upgrade Fails when creating Getting Started Dashlet

CiviCRM 4.6.11 to 4.7.1 Update Joomla 3.4.8 Error page during DB upgrade utility: [Error: Add Getting Started dashlet] Error Field Error Value Type DB_Error Code -3 Message DB Error: constraint ...
1
vote
1answer
603 views

How do I create and access a database for civiCRM

I am trying to install CiviCRM in WordPress to see if the small NGO I work with might be able to use it. I got a domain name and installed WordPress through BlueHost.com and turned on the CiviCRM ...
5
votes
1answer
143 views

How to reduce database bloat for faster upgrading?

In order to speed up slow upgrades, experienced folk (1 2) recommend reducing the size of the database to facilitate testing. What is the best way to declutter the database?
0
votes
1answer
167 views

CiviMail DB Error: no database selected

Civi 4.6.15 Joomla 3.5.1 Previously I upgraded my civi version to 4.7, and somehow I corrupted my database. I reinstalled a clean 4.6.15 and restored my database from backup. It seemed to be working....
1
vote
1answer
278 views

DB Error: unknown error (Tablespace is missing for table .civicrm_setting)

i just restarted my PC which has a locally hosted dev version of CiviCRM in WordPress, and now get the following error on initialization... Initialization Error Array ( [callback] => Array ...
1
vote
1answer
99 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 ...
2
votes
2answers
90 views

DB table that exists says it doesn't

After upgrading to 4.7.10 from 4.7.9, I'm no longer able to edit/add price sets. I think that the DB changes related to https://issues.civicrm.org/jira/browse/CRM-12252 are biting me. (Multi-lingual ...
1
vote
1answer
30 views

Batch edit one contact field (source) with same information

I have over 50,000 contacts that I would like to batch-edit with the same contact "source" information. What is the best way to do this?
2
votes
2answers
84 views

Older CiviCRM that does NOT require TRIGGER privileges?

As of title, I'm looking for a CiviCRM version that does not require trigger privileges, since the hosting service that I'm using does not support it, currently I'm on version CiviCRM 4.7.13 and ...
2
votes
1answer
46 views

Detailed Contribution Info Not Displayed

CiviCRM Version: 4.6.15 CMS: Drupal 7.43 I'm running into a weird bug and I'm not sure how to track it down. All of our old contributions (Pre 2014) don't show when you click on the the [contact] > [...
1
vote
0answers
68 views

Database upgrade error - 4.7.13

The process to upgrade my civiCRM database from 4.7.11 to 4.7.13 terminated with the following error: [Error: Upgrade DB to 4.7.13: SQL] Error Field Error Value Type DB_Error Code -19 Message ...
0
votes
2answers
83 views

What type of database does CiviCRM use?

I'm sure this is a very obvious question but what type of database does CiviCRM use? SQL Server, MYSQL, etc.
2
votes
1answer
276 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
3answers
169 views

CiviCRM Upgrade Wordpress 4.4.5 to 4.7.10 DB Error: no such field

CiviCRM Upgrade Wordpress 4.4.5 to 4.7.10 DB Error: no such field. Site shows at bottom of screens: Powered by CiviCRM 4.4.5 Trying to upgrade to 4.7.10 and after pressing Upgrade button CiviCRM ...
1
vote
1answer
38 views

After server migration, cannot add contacts

Joomla vers 3.51 CiviCRM Vers 4.7.6 I´ve done a migration to a dedicated server. I did the copy of files and database with Akeeba Backup, then edited the usual files: /administrator/components/...
2
votes
1answer
394 views

CiviCRM Initalization Error: DB Error: extension not found

I've got CiviCRM installed within a WordPress context, and both are updated. The problem is that, with the last update that occurred, I can no longer get to CiviCRM. Instead, I get the following ...
4
votes
2answers
1k views

Could not create a database trigger on AWS RDS

I am installing CiviCRM in Amazon AWS environment. User civicrm has full rights on civicrm database. I certainly see TRIGGER among all others in my phpMyAdmin console. Out of abundance of caution I ...
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 ...
1
vote
1answer
54 views

Are custom Dedupe General rules working for anyone?

On CiviCRM 4.7.8/Joomla 3.5.1, I've experimented with variety and can't seem to get this to work. The preset reserved rules, import, inclusive in contact record and main dedupe rules are all working. ...
9
votes
1answer
503 views

What is the installation canary?

One of my CiviCRM instances database has the table civicrm_install_canary, another has not. In code it is marked as a mechanism that check whether the install has run before. But how does this ...
1
vote
1answer
75 views

Unable to Import, edit certain records and edit Group settings: DB Error: constraint violation

I am unable to make certain edits to CiviCRM; unable to edit certain records and unable to edit the visibility of groups. I think the problem is this: Cannot add or update a child row: a foreign key ...
4
votes
3answers
62 views

CiviCRM Raw Data Files

We use CiviCRM for our nonprofit, and we're trying to figure out how we can export our raw data in order to upload it into some custom apps. Any help would be very much appreciated! Cheers, Jillian
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 ...
0
votes
3answers
56 views

Recurring iATS contributions not creating civicrm_finanical_item records

We are ramping up for online donations and use the Accounting Batches CSV export to get our Civi contribution data into our 3rd party accounting software. A key piece of data from that report is the '...
1
vote
0answers
29 views

Using Views with two sql servers

I am trying to set up Views on my CiviCRM 4.7.10 (Drupal 7.42). My Drupal database is on one SQL server. And my CiviCRM database is on another SQL server. Whenever I try to create a new view, I ...
1
vote
1answer
2k views

Install Error DB Error: extension not found

Using "upload package file" or "install from folder" on a clean new Joomla 3.5.1 installation without any other extension I get this error : Cannot open mysql://XXX:YYY@localhost/XXX?new_link=true: ...
2
votes
0answers
27 views

Bug in Custom Searches - Date Added to CiviCRM

I'm fairly new to CiviCRM but have successfully imported over 3,100 contacts from our current PC based DB system. If an error occurs during the my imports I have found the Custom Search 'Date Added to ...
3
votes
1answer
256 views

Database name on Wordpress can't include hyphen, but our host has mandatory prefix-hyphen-name format

Is there any way we can work around this? Our Joomla install was quite happy to use a db of format xxnn-yyyyyy. When we create or rename db using phpMyAdmin we can only choose the yyyyyy. "xxnn-" ...
1
vote
1answer
104 views

What is the database schema for groups and parent groups?

I need to manually delete a group that is corrupt. Already tried a few things. This corrupt group assigned itself as the parent to other groups and continues to add additional children groups every ...
2
votes
3answers
135 views

Using civi for big data sets (1 million plus)

I love civi! But mainly i use it for small datasets of sub 10,000 I have the opportunity to suggest its use in an organisation with a voter pool of 1 million+ I know this is an open ended question ...
2
votes
2answers
230 views

unable to upgrade from 4.4.5 to 4.7.11 - 'DB Error: no such field' (Wordpress)

Trying to upgrade from CiviCRM 4.4.5 to 4.7.11 in Wordpress 4.5/4.4 (problem doesn't change for either WP version) because it stopped working and just printed this when trying to view /wp-admin/admin....
1
vote
0answers
137 views

How to connect with state and country table

We are using CiviCRM (4.7.9) with WordPress (4.5.3). We are pulling the data from the CiviCRM state and country tables into Gravity Forms using code in our function.php. But we are running into ...
0
votes
1answer
562 views

Copy old WAMP directory to new installation of WAMP

Can anyone assist with the following scenario please... -I had a local install of Wordpress and CiviCRM using WAMP. -PC died but I was able to retrieve the Hard Drive and install in another PC as a ...
0
votes
1answer
21 views

hook_civicrm_post - on creating event cannot update the record in `civicrm_event` table

I have a custom field in civicrm_event table which I want to update on creating event. However the hook_civicrm_post on creating event cannot update the record in civicrm_event table due to database ...
1
vote
1answer
49 views

Running a script from cli

How would I call CRM_Core_I18n_Schema::rebuildMultilingualSchema($locales, NULL); from the command line? Minor upgrade seems to have had an insignificant DB error and this line did not get called. ...
9
votes
1answer
247 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 ...
2
votes
1answer
521 views

getting error message “too many connections”

Getting an error message on public website regarding too many connections. We increased our SQL connections, but we don't have a lot of interaction going on between our website and CiviCRM. We have ...
1
vote
3answers
62 views

How do I scrape an old website into a .CSV file for data migration?

I'm organizing my data to prep for CiviCrm. One of the data banks we have is an online directory listing of hundreds of names, contact information and bios. NONE of this is organized into a ...
2
votes
1answer
34 views

Adding new default components to the database

I have been working on to add a default header and footer to the system workflow emails. Most of the part is done but I am stuck at setting those components in the database by default so that whenever ...
0
votes
1answer
35 views

4.7 Install, Database Settings Correct. Still no Contacts

I have upgraded from CiviCrm 4.2 to 4.7 now that I finally have it working it will not bring up contacts from the old Civi database. I looked at the setting php file and all the information is correct....
3
votes
1answer
315 views

Change domain name (wordpress)

I have civi crm 4.7.8 on wordpress 4.5.3 and I've changed my website domain name. When I go to wp admin, i can see civicrm icon and go the taskboard, but I haven't civicrm menu. I supposed there are ...
2
votes
1answer
109 views

Howto extend a civi db field's size (maxlength, varchar)

We are facing a problem with CiviCRM's default field length for organization names. Background: In our setup we handle big departments or organizational units as distinct contacts. Since the sole ...
1
vote
1answer
73 views

Settings values not showing up. Cache issue?

I am experiencing a strange issue with my CiviCRM (4.7.3) installation on Joomla (3.4.8) with MySQLi 5.6.28-76.1-log and PHP 5.6.18. If I change some of the settings in one of the administration ...
2
votes
2answers
647 views

database connection fails, but only in cron

I moved a site - actually copied a production site to a development region. The site is working in the development region, including CiviCRM, but the CiviCRM cron job fails: Jun 29 16:33:02 [info] ...
2
votes
3answers
113 views

What's the best strategy for upgrading CiviCRM?

I use CiviCRM 4.5.8 with WordPress. I'd kinda like to try a newer version, but I don't want to mess up the production website. I used the WP plugin Duplicator to create a test site. I changed the ...
3
votes
1answer
88 views

Is it OK to drop database triggers in order to run a process?

I've spotted at least one process in CiviCRM that drop triggers on certain tables in order to run a process. For example: https://github.com/civicrm/civicrm-core/blob/...
1
vote
1answer
169 views

regen.sh - Call to undefined function db_query()

So I was following this doc to add a new setting which asked me to run bin/regen.sh script. But running the script failed with the following error: PHP Fatal error: Call to undefined function ...
5
votes
2answers
99 views

When upgrading from 4.7.7 to 4.7.8 I get error “Specified key was too long”

I tried to upgrade my Joomla CiviCRM 4.7.7 to 4.7.8 and got the following error in the database upgrade: ALTER TABLE `civicrm_contact` CHANGE `image_URL` `image_URL` VARCHAR(512) CHARACTER SET utf8 ...
2
votes
3answers
197 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 ...