Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
4
votes
2answers
395 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
626 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
112 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
505 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
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 ...
9
votes
3answers
314 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
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 ...
5
votes
4answers
338 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
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
258 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
50 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
650 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' ...
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
166 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
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
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
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 ...