Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
444 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
237 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
84 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
84 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
65 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
116 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
62 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
112 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
814 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
510 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
145 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
107 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
624 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
154 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
370 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
37 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 ...
4
votes
1answer
73 views

Why are you allowed to set DB field length on Text fields?

I know the documentation says you should leave it the same, but suppose I know I want the text field to be only 3 characters every time? I can set it fine in custom fields, but when I go to enter ...
1
vote
2answers
546 views

Initialization Error after restoring a Wordpress site from backup

This morning, a plugin update broke the website, so we did a restore from a backup from the previous day. CiviCRM was working properly at the time, but now when we try to access it, we get the ...
2
votes
1answer
28 views

postsave stop database update

User is adding a new email. Call to civicrm_pre detects a problem that requires that the update not happen. It hasn't actually happened by the time civicrm_post or post_save_civicrm_email is called. ...
1
vote
2answers
56 views

updated database from backend, issues when searching that field - Geocoding issue with Postal Code update

So I was playing with the contact mapping option for a search profile. I noticed that mapping did not work when the postal code was entered with a space in it. Example: "E1C E1C" rather than "E1CE1C" ...
2
votes
4answers
557 views

no such table when using civicrm

CiviCRM 4.6.10 Joomla 3.4.0 getting this error when going to events dashboard or trying to create event. Sorry but we are not able to provide this at the moment. DB Error: no such table Return to ...
0
votes
1answer
33 views

4.6.9 upgrade fails - DB_Error:already exists -5

I've attached a screenshot of the error I get when trying to upgrade from 4.6.8 to 4.6.9 I have the rest of the trace, but not sure if I should post all of it. Thanks in advance for your help.
1
vote
1answer
48 views

Database constraint error on enabling CiviCase

I'm running civicrm 4.4.20 on the latest Joomla 3.4.5. When I try to enable CiviCase I get an database constraint error (see below). [code] => -3 [message] => DB Error: constraint ...
2
votes
1answer
94 views

Getting error message upon installation

Getting this error message just as I am trying to set things up should I be worried? 0 <div id="crm-container" class="crm-container" lang="en" xml:lang="en"> <style type="text/css" media="...
3
votes
1answer
126 views

Is it safe / wize to empty civicrm_log table

Pretty similar to this question, we've moved LOG_tables to another database; however, there is civicrm_log table among "main" tables still (not sure why, since it keeps log records and, in theory, ...
6
votes
3answers
134 views

How to migrate database without logs

I’d like to move my CiviCRM installation from one Drupal server to another. But I enabled logging in the current server and I don’t want that data to be transferred to the new server. How can I delete ...
1
vote
1answer
52 views

Upgrade from 4.3.1 to 4.6.9 (Joomla) = fails; DB upgrade freezes

It reports (on DB upgrade screen): "[Executed: Finish Upgrade DB to 4.3.8]" We let it run for over over an hour; stayed stuck. A previous attempt got stuck at v.4.4.3. (This upgrade is being ...
7
votes
1answer
244 views

MySql vs MariaDB

After some reading, it appears that MariaDB could be a better challenger to MySQL and it runs, apparently, without any problems with CiviCRM (cf CiviCRM on MariaDB instead of mySQL). But what about ...
4
votes
3answers
417 views

CiviCRM on MariaDB instead of mySQL

Has anyone run CiviCRM on MariaDB instead of mySQL https://mariadb.org/ Running CiviCRM on MariaDB could provide significant speed improvements.
5
votes
1answer
231 views

In Wordpress, I want to convert my installation from an external database to use the default database

I am using CiviCRM on WordPress and I am moving my hosting to WP Engine - where I have all of my other sites hosted. Unfortunately, I set this instance of CiviCRM to use a separate database, however, ...
2
votes
4answers
123 views

How to create script to delete smart groups

I have 300-400 CiviCRM smart groups I want to delete. I will know the id for the group but need to know what other tables I need to delete that may be related. Also, is there any way to identify ...
4
votes
1answer
57 views

Civi Event - Event Title & Event Name with French accents not saving in correct encoding

Database/environment is set to UTF-8. This just started happening and we can't figure out why. In the example below, a French title and summary are given -- when saved, the Title appears to be saved ...
5
votes
3answers
415 views

MyISAM vs InnoDB - WordPress Installation

We're running CiviCRM 4.6.8 on WordPress 4.3.1. I've been getting the following error message since the last CiviCRM upgrade: Warning Your database is configured to use the MyISAM database engine. ...
3
votes
1answer
52 views

Is it possible to change custom group/custom field Entity Scope from just individuals to individuals and households (or ANY)?

I have an existing field for the donor name to show in printed materials. It was set up just for Individuals. The Custom Group has only this one field in it. Several reports/profiles/templates already ...
0
votes
1answer
43 views

Upgrade from 4.4.19 to 4.4.2 DB error

When I try to upgrade CIVICRM 4.4.19 to 4.4.2 I get the following error message: "Your database is marked with an unexpected version number: 4.4.19. The v4.4.2 codebase may not be compatible with your ...
1
vote
2answers
184 views

DB error with profiles

When I use a fill-in (sign-up) profile on a browser where I am logged in, there is no problem filling in the forms and saving. However, when I try the form on another browser where I am not logged in (...
3
votes
1answer
217 views

Is CiviCRM compatible with Postgres and Wordpress?

Is there a version of CiviCRM that's compatible with Postgres and Wordpress?
3
votes
2answers
635 views

Civix: Install error: API error: DB Error: already exists

According documentation I created a skeleton module with civix and answered yes to install it. It then gives an error response as in the Title. Afterwards is listed active in the extensions page. ...
0
votes
1answer
569 views

Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame

When a user tries to create a new membership from the front end we are getting this: DB Error: already exists Return to home page. Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity ...
1
vote
1answer
607 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 ...
1
vote
1answer
30 views

after i use api to update the database results not immediately showing

I'm running into an issue with the api. I use the following call to write to the relationships datatable $result = civicrm_api3('Relationship', 'create', array( 'sequential' => 1, '...
1
vote
1answer
40 views

Database Insertion and Deletion

I am looking for a best practice approach. I am working on a module extension, which involves creation, retrieval and deletion of an entity(object). I have created the DAO files for them, I am ...
4
votes
2answers
80 views

What table and column contain the date a contact was added?

I'm trying to determine the correct table and column to check the data a contact was added to the civicrm-contact table. What is the best method for doing this?