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
1
vote
1answer
29 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
79 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?
3
votes
5answers
498 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 ...
1
vote
2answers
619 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 ...
15
votes
2answers
646 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' ...
3
votes
2answers
66 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
79 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 ...
1
vote
2answers
380 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 ...
3
votes
1answer
36 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
256 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
75 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
47 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 ...
2
votes
2answers
37 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
154 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 ...
2
votes
2answers
189 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?...