Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
2answers
705 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
119 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
275 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-" ...
2
votes
3answers
215 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 ...
5
votes
2answers
103 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 ...
0
votes
1answer
271 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 ...
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 ...
1
vote
1answer
192 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 ...
3
votes
1answer
92 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
0answers
26 views

Saving in any frame just churns

Every time I save in a frame I get the following error. Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame\n\n thrown in /var/www/html/sites/all/modules/...
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: ...
0
votes
1answer
63 views

Unrecognized database version from 4.6.16 to 4.7.7

Joomla 3.5.1, Linux, Php 5.6.20 Is there a "quick fix" I could make to a script to allow it to either recognize the database, or would it be OK to manually change the database version number only ...
7
votes
3answers
88 views

How does CiviCRM handle multiple users editing the same record simultaneously?

I'm assuming that the record is locked so that only one user - presumably the first - can edit, whilst others are locked out until the record has been saved. But I don't know, and a client has just ...
0
votes
1answer
194 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. ...
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 ...
1
vote
1answer
52 views

2 separate sites with the same php code

Is it possible with Drupal to have two sites, with 2 separate databases, sharing the same PHP code? For the future need of porting one database to another server, I don't want to use "Multi Site ...
3
votes
1answer
54 views

Is CiviCRM a 'master database' / 'master system'?

The membership organisation I work for currently has serious issues with it's membership databases. That information is currently split between a wordpress user database with an extension s2pro which ...
0
votes
1answer
200 views

How to run triggerRebuild URL

Apparently I am not allowed to ask for clarification in the post, so can someone please elaborate on this? Sounds good. To be sure, please execute ///civicrm/menu/rebuild?reset=1&triggerRebuild=1 ...
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
454 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 ...
6
votes
2answers
261 views

Adding states to countries

Hello we are moving an old CRM into CiviCRM. We are a very international organization and we have found that CiviCRM is missing many states. How do we get this added to CiviCRM? Should we make ...
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
2answers
33 views

Contact table: managing a new field

in my extension I have the need to manage a new contact information (I added a field in civicrm_contact, instead of using a custom field). Using the buildForm hook, I can show the input element in the ...
3
votes
2answers
57 views

Drush failing to build database during new installation

I am building a Docker container for CiviCRM, it is 99.9% done. Unfortunately, when I try to install the actual module via Drush, it spits out an error. I am fairly certain this isn't a Docker related ...
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....
2
votes
1answer
110 views

Connecting Civi to a previous install's database

During my update from Civi 4.2 to 4.7 I let it fill in database information that was not correct it connected to the cms database and not the Civi database from the previous install. Is there a file I ...
3
votes
2answers
110 views

MyISAM, Cron, ERROR

I get this error on installing the CiviCRM plugin for Wordpress (Wordpress version 4.4.2, CiviCRM 4.7.4) System Status: Error MyISAM Database Engine Cron Not Running Configure Default Mailbox ...
2
votes
1answer
518 views

DB Error: connect failed (code 24)

Anyone have any idea how I can fix this? Just done install and CiviCRM did not load (all OK on wizard) then nothing. Removed CiviCRM from the WordPress install and uploaded again (also removed ...
5
votes
3answers
255 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 ...
1
vote
1answer
74 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 ...
3
votes
3answers
76 views

Settings values not showing

I am experiencing a strange issue with my CiviCRM (4.7.3) installation on Joomla (3.4.8). If I change some of the settings in one of the administration pages, they are correctly updated on the ...
1
vote
3answers
85 views

CiviCRM component pointing to different database than Joomla CMS

We have a little bit of a strange issue and could use some input. We are using CiviCRM on Joomla. Started on Joomla 1.5 years ago, then upgraded to J2.5/CiviCRM 4.4 a couple years ago, then a few ...
2
votes
1answer
100 views

Importing phone/fax/mobile phone numbers from CSV…best practices?

I'm about to do my first import of contacts into a pre-existing CiviCRM database on WordPress. Client sent over the CSV but there are columns like this: Home Phone Home Fax Mobile Phone Work Phone ...
2
votes
2answers
66 views

Unknown DB Error When Trying to Disable the Automatic Wildcard Option

We are trying to disable the automatic wildcard option in Civicrm (Wordpress 4.7.2). However, when we try to disable the option and save we get an error that says “Save Failed: DB Error: Unknown ...
3
votes
1answer
118 views

Database scheme corrupt - foreign key relationships are missing in mysql

At a client of us we have a problem with the database scheme. CiviCRM is working normally except that when you want to merge contacts the Activities/Groups/Relationships etc.. are missing in the merge ...
2
votes
1answer
69 views

Calling images from a database with custom tokens in mass mailings

I was just wondering whether CiviCRM offers the ability to insert custom images into a mass mailing? So that each person receives a different image pulled from a server? The best described example I ...
1
vote
0answers
51 views

Export Fails when Merge Households Option Used

I get a DB Error when exporting contact search results using the "Merge Household Members into their Households" option (image below). Only this merge option causes the error. The others do not. I ...
0
votes
1answer
71 views

“no such field in civicrm_api3” after Upgrade from 4.6.4 to latest 4.7

I ran the database upgrade script and it showed me an error and didnt get finished.. since then I can't run the /civicrm/upgrade script and it always gives me the error: CiviCRM_API3_Exception: DB ...
2
votes
1answer
119 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
5answers
854 views

Ajax Error when trying to view relationships tab

Civicrm 4.7.1 Joomla 3.4.8 I'm unable to view data in the relationships tab. I get the following errors: "DataTables warning: table id=DataTables_Table_0 - Ajax error." And "DataTables warning: ...
1
vote
1answer
179 views

InnoDB is default, but can't install

Innodb IS default engine, but can't install. Error message is Unable to create InnoDB tables. MySQL InnoDB support is required for CiviCRM but is either not available or not enabled in this MySQL ...
1
vote
3answers
520 views

4.6.10 to 4.7.1 upgrade woes

**UPDATE #5: See new answer at bottom. It's a fix! **UPDATE #4: Decided do a clean install of 4.7.1 and see if I can point it to a working 4.7.1 backup database. I suppose I need to follow Kurund's ...
2
votes
1answer
146 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
164 views

Updating information in Custom fields within a tab not saving since update to 4.7.0

Civicrm 4.7.0 Joomla 3.4.8 When editing or adding information contained within a custom field within a tab, after hitting save, the information does not remain. Also receive the following error when ...
3
votes
0answers
115 views

MyISAM Database Engine Error [duplicate]

I'm getting the MyISAM Database Engine error: Your database is configured to use the MyISAM database engine. CiviCRM requires InnoDB. You will need to convert any MyISAM tables in your database to ...
5
votes
1answer
706 views

WordPress: Creating new WP Users from Civi Contacts

I've seen some example posts here for other CMS', but I haven't seen it explained for a WordPress environment. My situation is I have an Individual DB of 2,500 Contacts in Civi, and I want to turn ...
3
votes
5answers
1k views

Migration error: “The user specified as a definer does not exist”

I recently moved the site to a new server and changed from a remote to a local MySQL server with different credentials. Most things seem to be working fine, but even though I've flushed caches, ...
5
votes
2answers
167 views

What is the largest number of customer records that civicrm supports?

I am evaluating civiCRM to use as the CRM in the captive BPO setup of my non-profit. Need to know how many customer records civiCRM can handle, in the database of my beneficiaries. Can it support a ...
2
votes
1answer
389 views

Getting a DB Error: unknown error when entering and saving phone number

I see that there's a few threads out there around this topic. I've just installed a brand new instance of WordPress 4.4 with CiviCRM 4.6.10. I've got three other installs of CiviCRM with Drupal on ...
3
votes
2answers
38 views

How do we move our civicrm SQL database from the cloud to our network?

We are running our CiviCSM system on a vendor's host with our database in the cloud. We have a CiviCSM system built for our network that is not currently in use, but we want to move the database from ...