Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
2answers
66 views

Contacts not merged When creating Account on Event Page - DB Error: already exists

Running: CiviCRM 4.7.17, WordPress 4.9.4 When an anonymous visitor tries to register for an event, we have them required to sign in or create an account via Civi's profile settings to keep our ...
2
votes
1answer
40 views

Wrong database user

Maybe I've been staring at this too long and am missing something obvious. I do this duplicating of the live site onto the dev site often, but today it's broken. I created a copy of our site. It's on ...
2
votes
1answer
75 views

How can a pull a report with notes includes

We are trying to export a list with notes included. We are creating a prospect list for Employment Engagement team. We will add names to the database, this list is obtained from events that we host. ...
3
votes
2answers
31 views

How did my import result in the State for a different country to the one intended

How could a CiviCRM database have 2 Marylands with 2 different state_province_codes but both be identified with the same country_code? 1019 = Maryland 3497 = Maryland 1228 = United States I only was ...
1
vote
1answer
96 views

Error when installing civicrm-4.7.29-drupal on Drupal-7.56

when I install civicrm-4.7.29-drupal on Drupal-7.56 just using one database for drupal an civicrm the installation runs perfectly without any errors. If I use two databases for drupal and civicrm I ...
9
votes
2answers
301 views

Data Protection / GDPR - deleting from logging tables

With the new GDPR legislation taking effect in a matter on months, it dawns on me... how can we delete people permanently from the logging tables? My understanding is that the table types are a ...
0
votes
1answer
43 views

CiviCRM upgrade `civicrm`.log_civicrm_activity error

Upgrading a CiviCRM DB from 4.7.17 to 4.7.29 after moving from MySQL 5.1 (CentOS 6 install) to CentOS 7 with MariaDB 10.2. After the progress bar completes on the wp-admin/admin.php?page=CiviCRM&...
1
vote
4answers
452 views

Can I create triggers in the database?

We are trying to setup CiviCRM in Wordpress. Our Database is on GoDaddy, but we are running into a problem: "Could not create a database trigger." The Database Settings appear to be correct. Any ...
1
vote
2answers
1k views

How do I troubleshoot DB Error: connect failed on a new installation on Wordpress?

I am following the detailed instructions to install Civi under Wordpress. I am running a local development Wordpress site using MariaDB 10. I have downloaded and activated the CiviCRM plugin. The ...
1
vote
2answers
153 views

Database Schema check/fix

I am getting random errors when I first log into Civicrm on Wordpress. It seems to be related to the check of existing indexes versus required indexes. Warning: Invalid argument supplied for foreach(...
1
vote
1answer
20 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
81 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. ...
0
votes
1answer
42 views

CiviEvent Listing module in Joomla not finding database table

We are working on a long-needed update of our website. I thought I would take the opportunity to also follow what many say is best practice and move our Civi db out of a db shared with our Joomla CMS. ...
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
363 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
96 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
154 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
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
47 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
114 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
2answers
98 views

Initialization Error after any change

My website has member side and after adding a member to a site the site was broken and for members, Initialization Error occurs. so members couldn't access their own page on the website. and also ...
0
votes
1answer
96 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
175 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
34 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
133 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
46 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 ...
0
votes
1answer
57 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
66 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
84 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 ...
1
vote
0answers
111 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
37 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? ...
1
vote
1answer
92 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 ...
2
votes
1answer
309 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: "...
1
vote
1answer
107 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.
3
votes
1answer
353 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 ...
1
vote
1answer
45 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 ...
1
vote
1answer
125 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 ...
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/...
1
vote
2answers
106 views

Mapping database from Neon to Civi

Our organization is considering moving to CiviCRM after many years with Z2Systems Neon CRM and in downloading the MySQL database from Neon we note that there are 10 pages of table in the Neon database ...
1
vote
1answer
148 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?
5
votes
1answer
695 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
2answers
76 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 ...
2
votes
4answers
84 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
231 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
1answer
25 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 ...