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
2
votes
1answer
297 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
82 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
39 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
102 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
108 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
104 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
90 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
136 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
27 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
125 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
44 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
678 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
173 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
100 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
60 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
77 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
54 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
76 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
328 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
302 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
469 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
102 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
42 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
134 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
65 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
80 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
78 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
89 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
27 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
760 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
308 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
531 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
266 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
48 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
807 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
94 views

Initialization Error when going to Civi CRM dashboard and adding pages/posts

I've had Civi CRM integrated in my website for a couple years no with no issues. However recently I've not been able to update any pages or posts or even go into the Civi CRM dashboard. All that shows ...
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 ...
1
vote
2answers
48 views

What tables are used for civicrm reports?

I need to know what tables and fields are used for the CiviCRM reports, I've been dealing for several weeks trying to see why an updated site from CiviCRM 4.2 to 4.7.16 on Joomla is not showing any ...
4
votes
1answer
4k views

SOLVED: 'DB Error: extension not found' after PHP upgrade to version 7.0

Civi: 4.7.11 Wordpress 4.7.2 Hi, I was working on my database today and munged something up. No problem (I thought)... I did a back up beforehand just in case. Unfortunately, after restoring the ...