Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
18 views

How to change the date on an exported batch

I have exported a batch but the date in the title is not correct, so I need to change the date on the name of the batch, however I cannot seem to re-open the batch. Please can you help. Thanks in ...
0
votes
1answer
54 views

CiviCRM Database Upgrade from 4.7.16 to 4.7.28 is hanging

I am trying to upgrade my Joomla civiCRM database from 4.7.16 to 4.7.28. The component upgraded fine but when I try to upgrade the database after following all of the preparation steps, it hangs and ...
1
vote
1answer
76 views

Transferring Data Out of CiviCRM

Some time ago we transferred data from CiviCRM to a different CRM (YourMembership). However, it has become apparent that we have not collected all of the data. We have the web version CiviCRM 4.6.21. ...
1
vote
1answer
35 views

Unable to Update Search Preferences After Upgrading to CiviCRM 4.7.28

I have just upgraded from version 4.7.22 to 4.7.28 (with Drupal version 7.56) and am no longer able to save changes on the Search Preferences screen. When I try to save I get an error: "Save Failed - ...
2
votes
1answer
315 views

CiviCRM Wordpress Migration: Stumped by the Database

I am attempting to migrate an existing Wordpress CiviCRM installation to a new server, but am having some difficulty with the database part. The existing installation is Wordpress 3.8.1 and CiviCRM ...
1
vote
1answer
88 views

Rebuilding CiviCRM Database

Greetings CiviCRM Community, I am in need of rebuilding our organization CiviCRM DB. We are getting some odd issues when trying to create activities in CiviCRM. When I traced the error I got the ...
1
vote
2answers
44 views

CiviCRM Wordpress Installer Database Instructions incorrect?

Instructions were here: https://docs.civicrm.org/sysadmin/en/latest/install/wordpress/ I downloaded the zip to my local computer, then ftp uploaded it to my web server. I created the /wp-content/...
3
votes
1answer
123 views

How to Export full back up of entire database

I would like to export a full copy of the database contact details - all the details not just the primary. Short of selecting each individual field, how to I collect "all records' report?
1
vote
1answer
113 views

Select alias with dot is not returned from CRM_Core_DAO::executeQuery()

I've been playing around with the idea of using the custom group and field name as an alias when fetching data using the API. Because of this I've ended up with a situation where an alias can have a ...
17
votes
7answers
3k views

How to find and/or fix missing indices?

After upgrading to 4.7.19, I'm now getting a warning: You have missing indices on some tables. This may cause poor performance. How can I find which indices are missing and then, how can I create ...
1
vote
0answers
48 views

Update Indices fails with errno 150 on DROP INDEX UI_case_contact_id after upgrade from 4.6 to 4.7.27

Upgraded from 4.6.19 to 4.7.27 (on wordpress 4.8.3) and attempted to update indices. The table that fails is civicrm_case_contact, with the old index UI_case_contact_id. The error is identical to ...
2
votes
1answer
45 views

Drupal Views Filtering on Subtype

I have an instance of drupal 7 installed… and it is storing its data in database A I have then installed CiviCRM… and it is storing its data in database B I have placed the information shown at sites/...
2
votes
0answers
28 views

Update Canadian (or Australian) currency $ display

CiviCRM simply shows a $ to represent either Can$ (or australian dollars). This can become confusing when $ currencies mix. It keeps these symbols in the database. I suspect I can do something like ...
3
votes
1answer
105 views

How do user permissions work for multi-level organizations?

We are currently using Action Network for our CRM (even though it is not designed for that), marketing and digital mobilising tools. We moved to them because of their system of parent/sibling/child ...
0
votes
1answer
93 views

Switching from same-db to separate-db?

I'm using latest drupal 7 and civicrm. I have an existing drupal/civi install which uses the same database, and i'd like to switch to having separate databases - is that possible? The civi side is ...
3
votes
1answer
142 views

How cleanup civicrm database

I've got a civicrm database of 1.4 Go (information available in PhpMyAdmin) 1Go is used by civicrm_activity table I would like to know if have to clean, purge the database to reduce its size, cache or ...
3
votes
3answers
29 views

Notes - searching

How do I find a list of the notes I have added. I input a number of notes last week but neglected to grant permissions. how do I locate a list of those notes?
0
votes
1answer
126 views

New EU-DSGVO 2018 - Is a new agreement necessary?

Dear CiviCRM beta team, we as the NGO "Wissenschaftsladen hannover e.V" would like to know whether we need a new agreement concerning the new DSGVO (Datenschutzgrundverordnung). According to the new ...
1
vote
0answers
15 views

CiviCRM won't store Outbound email settings

I've just updated to 4.7.24. When I try to save Outbound email settings, I get an error with this backtrace: #0 /srv/website.com/public/htdocs/sites/all/modules/civicrm/CRM/Core/Error.php(187): ...
1
vote
2answers
45 views

Using an External (custom) Table in a Custom Report

I have several custom tables that I have created for use with extensions that I have built. I would like to use those tables in a custom report. What is the best approach for this? I checked the ...
5
votes
1answer
683 views

4.7.20 upgrade — missing indices warning, but index already exists? [duplicate]

Upgraded to 4.7.20 today. As others on this thread have experienced in earlier release(s), I promptly got the "missing indices on some tables" warning. Of course, I tried the "Update Indices" button, ...
1
vote
1answer
86 views

CiviCRM backup query

I want to make a weekly/fortnight backup of CiviCRM running on Wordpress. Two things I need to do: Backup on same machine Replicate the database on another machine. Looking for simple steps to ...
0
votes
1answer
55 views

Error: Sorry we are unable to provide this at the mom

CiviCRM 4.6 WordPress 4.8.1 This is a brand new installation with one record in the contacts table. When I did a search I got this error. There are no custom fields. More error details: Database ...
1
vote
1answer
24 views

How to get more debug info about “DB Error: no such field Return to home page”

I have created an event registration form, using a profile with a custom field. When I click Continue after filling in the form, I see Processing ... and then I get the confirmation screen, which ...
1
vote
1answer
190 views

DB Error: no such field

I have created an event registration form, using a profile with a custom field. When I click Continue after filling in the form, I see Processing ... and then I get the confirmation screen, which ...
1
vote
0answers
103 views

CiviCRM 4.7 with WordPress 4.8 : DB Constraint Violation - contact_id should possibly be marked as mandatory for DashboardContact,create API

This is on a completely fresh install of CiviCRM. I tried running the upgrade, but the message said I was already upgraded to the latest. Any idea how to fix this?
1
vote
1answer
64 views

Make phone type value “mobile” for every individual

We need to switch every individual contact's phone type to mobile. I have an SQL query that I could run manually, but for the civicrm_phone_before_update trigger using a function that doesn't get ...
1
vote
1answer
80 views

Where can I see the database upgrade script?

I want to see which indices were supposed to be created in the last upgrade I ran because I get a status report message saying that some indices are missing, but when I click "Update Indices" I get an ...
0
votes
3answers
55 views

Copying the CiviCRM installation in a different machine

I am trying to make a copy of my CiviCRM installation on WordPress in a different machine. I ma mainly trying this just as a practice for future upgrading of CiviCRM versions and also as a backup. I ...
2
votes
1answer
81 views

Manually adjusting a contribution in the database

I need to manually change a one-time Failed contribution in the database to a Completed contribution. (See How do I change an incorrect contribution status to Completed? for context). What tables ...
1
vote
1answer
35 views

Multi-client capability und data storage

One important question: Is your software solution able to deal with multi-clients, e.g. that data can be separated between different clients (companies) und security can be setup for this requirement? ...
3
votes
1answer
335 views

How can I fix this problem with duplicate index in 4.7.21?

Upgraded from 4.7.17 to 4.7.21 and got the following message that I don't know how to fix. I don't have drush and the other answers to this problem don't include this index or don't fix this ...
2
votes
1answer
304 views

Update 4.7.22 : Operation failed: Update Indices DB Error: already exists

I'm just update to civicrm 4.7.22 on Drupal 7.56. After the update, I received a system status warning "Performance warning: Missing indices". I click to Update Indices and have these error: "...
3
votes
2answers
510 views

CiviCRM Can't Connect to Databases on Server, but WordPress Can

I've been trying to install CiviCRM on fresh WordPress 4.7.3 installations on my managed server, but I keep having database connection problems. When I try to install CiviCRM 4.7.17, the CiviCRM ...
1
vote
1answer
103 views

how to transfer data from one server to new one for Civi CRM on wordpress

we have data in wordpress based Civi CRM on one server and want to migrate to another server with wordpress. please guide us.
1
vote
1answer
43 views

Why is the CiviCRM installer unable to connect to the MySQL server?

I am using Drupal 7.56 and CiviCRM 4.7.21 on Ubuntu 16.04. The Apache and MySQL servers run on the same host. The Drupal and CiviCRM databases are stored on the same server, and are accessed with a ...
2
votes
1answer
30 views

prompted for password too often

I am trying to run civicrm in my machine and access it through LAN from other machines. So I made a change in word press general settings like below: WordPress Address (URL) http://myipaddress/...
0
votes
1answer
138 views

questions on External ID

Is External ID Unique? will it automatically check for a duplicate External ID when the attempt is made to enter into database? Can External ID be auto incremented whenever an individual gets added?
1
vote
2answers
67 views

Custom Database Triggers disappearing

One of the ways I have set up my system to auto-increment a value (registration number) in a custom table is by using a custom database trigger. They are quite straight forward - after insert, update ...
7
votes
3answers
83 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 ...
2
votes
4answers
80 views

Capacity Planning

We would like to propose the utilization of CiviCRM in a big organization. They have 140.000 contacts, that manage more then 1.000.000 activities each year (including mails, contributions, etc), and ...
1
vote
1answer
93 views

Setting up CiviCRM in WordPress - warning message and failure to connect to WP DB

So I'm trying to set up CiviCRM on my wordpress site hosted by GoDaddy. I called them to help get the plugin installed, which was fine. Once I go to our WP dashboard and begin the setup process for ...
2
votes
1answer
28 views

DB error on tag page after installation

I'm new to CiviCRM and just installed it (v. 4.7.17) on Wordpress 4.7.3 When I access the tag management page (wp-admin/admin.php?page=CiviCRM&q=civicrm%2Ftag&reset=1), I get a DB Error + a ...
3
votes
1answer
35 views

Is smart/fuzzy searching possible in CiviCRM?

I'm not sure what the feature is called, but Google seems to collapse all accented letters to their base character when indexing. So a search for "Nandor" will find a record "Nándor". But searching my ...
0
votes
3answers
774 views

CiviCRM 4.7 - DB Constraint Violation - possibly dashboard_id should possibly be marked as mandatory for this API

We have moved our hosting to new hosting provided (CiviHosting). CiviHosting installed a fresh installation of CiviCRM 4.7. We then imported our previous sql dump from our old site which also had ...
9
votes
3answers
318 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 ...
2
votes
1answer
557 views

DB error: No such field (Civi 4.7.15)

I've gotten No such field errors for no apparent reason since my first Civi installation, but one that I haven't been able to shake is preventing creation of any payment processors. It looks like this:...
1
vote
1answer
276 views

Upgrading CiviCRM from 4.6.25 to 4.7.15 fails on database upgrade

I am running a CiviCRM upgrade on Joomla from 4.6.25 to 4.7.15. The environment is: Joomla : 3.6.5 PHP : 5.5.9 Database 5.5.52 Apache 2.4.7 PHP Memory 512M Execution timeout 240 Installing the ...
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 ...
1
vote
5answers
819 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: ...