Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
4
votes
1answer
75 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
585 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
29 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
58 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
592 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
49 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
139 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
142 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
54 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
250 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
455 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
240 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
133 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
58 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
424 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
66 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
195 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
292 views

Is CiviCRM compatible with Postgres and Wordpress?

Is there a version of CiviCRM that's compatible with Postgres and Wordpress?
3
votes
2answers
678 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
614 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
662 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 ...
2
votes
1answer
31 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
82 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?
4
votes
2answers
411 views

drush civicrm-sql-dump dumps the drupal database - how do I get it to dump the civicrm database?

I've recently made some backup scripts to automate backup of my site and databases. One of the scripts uses drush to dump the drupal and civicrm databases with these commands: drush @myserveralias cc ...
1
vote
2answers
686 views

What can I do to fix my database that has been partially upgraded?

I have run into this problem on two of my websites that run Civicrm separately. Both are running version 4.5.8. When I run the automatic installer, the update process seems to freeze for an infinite ...
7
votes
1answer
118 views

Can I pass a GROUP BY to an API call?

I'm trying to write an API call returning all contacts that are at one end of one or more active relationships of a certain type, and their names. I note that you can specify limit, offset (LIMIT) and ...
3
votes
5answers
537 views

I need to migrate data from one CiviCRM on Drupal instance to a clean one. HELP?

The person who was supposed to be maintaining my CiviCRM on Drupal instance flaked on my a while ago and my site has been sitting vulnerable. Due to hosting changes, I decided to just set up a clean ...
3
votes
2answers
68 views

Are log tables updated during an upgrade?

If a CiviCRM upgrade amends the structure of existing tables, do you know if the same changes are applied to the equivalent logging tables? I've noticed in the column civicrm_line_item.label NULL is ...
1
vote
1answer
83 views

auto_increment_increment issue CRM-7923

My activation of CiviCRM WordPress plugin was halted by database error message: "An auto_increment_increment value greater than 1 is not currently supported. Please see issue CRM-7923 for ...
0
votes
2answers
109 views

Joomla CiviCRM Upgrade 4.3.9 to 4.4.x version

I am unable to upgrade 4.3.9 version into new version .. I am getting this error : Error: Consolidate activity contacts Type DB_Error Code -2 Message DB Error: syntax error Mode 16 UserInfo ...
9
votes
3answers
336 views

How do I add a new table to my extension?

I have added tables to my database by writing SQL commands in a sql folder as specified in the given link. Add a database upgrader / Installer / uninstaller. What I am exactly looking for is a ...
1
vote
2answers
389 views

DB Error: no such field : Assignee Contact Email

We had to restore a database from server crash to a newer version CiviCRM (4.6.3). We have gotten most of the data moved over but this one has us stumped. We have been getting the error "DB Error: no ...
5
votes
4answers
339 views

Why did we lose contact data after deleting the default location type “Home”?

So we lost 2/3 of our email and addresses on 6/15 around 1pm. Everything else seemed fine. I was able to get the civi log that pointed to a deletion command (DELETE FROM civicrm_location_type) around ...
3
votes
1answer
38 views

Is the cache field 'expired_date' no longer used?

After inspecting some cache entries in the civicrm_cache table I've come across the field called 'expired_date' which is set to NULL in all cases. The only reference to the field I can find anywhere ...
1
vote
1answer
265 views

Missing fields and reports in database after migrating to a new server

What's the best way to migrate CiviCRM to a new a server? I haven't been able to get it to work. I've been following this guide. Here are the steps I've been taking to for the migration. 1.) SQLDump ...
2
votes
1answer
80 views

Adding And Removing Fields To CiviCRM Tables

I had earlier added a new field to the civicrm_event table called "enable_tracking". I achieved this by adding a new field to the xml/schema/Event/Event.xml file. After this I ran the regen.sh script. ...
1
vote
3answers
51 views

How do I find the mails belonging to a particular mailing by looking at the SQL tables?

I've the dump of civicrm_mailing_event_delivered table. It has 3 fields - id, event_queue_id and timestamp. By looking at this table, how do I find the mails belonging to one particular mailing? Why ...
15
votes
2answers
698 views

MySQL Tuning: Is Defragmenting Tables safe?

I like using MySQLTuner to check on things from time to time. It's as easy as: $: sudo apt-get install mysqltuner (CentOS: sudo yum install mysqltuner) $: sudo mysqltuner Also, besides 'top' which ...
4
votes
2answers
2k views

Database Trigger error message

Trying to install to WordPress and I get; "Could not create a database trigger." I have no idea how to resolve. Thank you!
2
votes
3answers
167 views

Best way to create a new DB table in an extension with logging

In an extension, what is the best way to create a DB table that has a matching logging table? Do we just have to literally create a matching new table with triggers? There must be a better way?
2
votes
2answers
40 views

Should civicrm_participant.registered_by_id be an FK to civicrm_contact?

While troubleshooting for a different question, I noticed that civicrm_participant.registered_by_id is an FK back to civicrm_participant.id. Since it's a common use case for one contact to register ...
2
votes
2answers
190 views

Where in the database is the note field for contributions?

One can enter notes with a new contribution and they show up like this: Campaign Middleport Pottery, Steam Engine Receipt Sent April 10th, 2015 10:56 AM Note Where is the note field?...
2
votes
2answers
156 views

What to do when upgrading from 4.3.4 to 4.6.0 is failing?

I loaded a new 4.6.0 database with data dumped from a 4.3.4 database. The update ran okay to a certain point, when I got this message: *[Error: Upgrade DB to 4.6.alpha7] Error Field Error Value Type ...

1 2 3 4 5
6