Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
41 views

Database update failing for CiviCRM upgrade in Joomla 2.5

I have installed Civi 4.2.19 in Joomla 2.5, to upgrade the 4.1.1 version. I cleared all cache and then tried to run the database update. I got this fatal error: Fatal error: require_once(): Failed ...
0
votes
1answer
57 views

DB error missing field in contribution reports after upgrade to 5.4.0 (Drupal)

After upgrade to 5.4.0 (from 4.7) I'm seeing fatal DB errors ("no such field") when refreshing Contribution Detail & Summary reports. Debug log shows: $Fatal Error Details = Array ( [callback] =...
2
votes
1answer
104 views

db error reinstalling CiviCRM

I'm just getting started with CiviCRM and trying to install on our WordPress site. I completed the initial install once, but accidentally used the existing WordPress database - I would prefer to ...
3
votes
1answer
39 views

saving mapping fields

I have just saved fields for exporting to a new saved mapping field, but it is not coming up as an option when I go back into the database and try to export the same details for another group. I'm ...
2
votes
2answers
29 views

How can I find members

I would like to know if it is possible to find a person on the database only with the CIVI number, and how can I do it?
0
votes
1answer
31 views

When removing a group from a contact I get: Error - DB Constraint Violation - GroupContact, get API

[copied from https://issues.civicrm.org/jira/browse/CRM-20711 noted on CiviCRM version 4.7.27] In the Contact record, when I try to remove or delete a contact from a group they've already been added ...
0
votes
2answers
109 views

Can I export full database and import it in a fresh newer CiviCRM version?

I am experiencing difficulties during CiviCRM upgrade from 4.7.14 to 4.7.31 or 5.1, namely, fields like contact.birth_date get broken. (More: DB Error after upgrading 4.7.x to 5.1 (Drupal)) I have ...
1
vote
1answer
68 views

Sorry but we are not able

I have tried to append a new contact Contact saved When I tried to search this is the answer
1
vote
1answer
66 views

Civicrm local db error

My Specs I migrated a production Drupal 7/Civicrm 7.x-4.7.9 site to my local machine. For my stack, I am running MAMP and PHP 5.6.32, the production server is on PHP 5.6.33 I downloaded all files,...
2
votes
0answers
117 views

DB Error after upgrading 4.7.x to 5.1 (Drupal)

After upgrading CiviCRM from v4.7.14 to 5.1 (or v4.7.31) which went seemingly well, CiviCRM encounters the following problem. UPDATE: Issue does not appear until 4.7.29 (including), and comes up only ...
-1
votes
1answer
27 views

duplicate database in civiCRM

Is it possible to duplicate the data base on Civi ? (contacts) Because i need to do it for my traineeship.I don't even know if it's possible but maybe does an alternativ way to do it. thanks and have ...
0
votes
3answers
196 views

How can I completely remove previous improperly uninstalled CiviVolunteer?

I'm trying to install the CiviVolunteer extension (Drupal 7, Civi 5), but am getting this error message in response: Field: name must be unique. An conflicting entity already exists - id: 186 It ...
1
vote
2answers
217 views

CiviCRM Cannot add or update a child row: a foreign key constraint fails error after upgrading from 4.7.30 to 5.0.2

After running the command to upgrade the database I got a constraint violation error. ERROR USERINFO: ALTER TABLE civicrm_case ADD CONSTRAINT FK_civicrm_case_case_type_id FOREIGN KEY (case_type_id) ...
2
votes
4answers
264 views

After upgrade to 5.0.2 from 4.7.30 getting “DB Error: No such field” on queries

Since updating my CiviCRM 4.7.30 on WordPress 4.9.5, I am getting "DB Error: No such field" when doing queries through Advanced Search or Search Builder. Some of the problems where when I was trying ...
0
votes
1answer
26 views

Implementations Basics (Costs, Timescales, etc)

We're looking for indicative figures with regards to migrating across an Access Database to CiviCRM. Early stages (but we need to migrate soon as our Access config is grinding to a halt) so any ideas ...
2
votes
2answers
237 views

API error: DB Constraint Violation - domain_id should possibly be marked as mandatory for Dashboard,create API. If so, please raise a bug report

I am running CiviCRM 5.0.0 on WordPress 4.9.5 and got a DB Constraint Violation each time I try to active/deactivate an extension (after the validation screen) or when I validate the WordPress Access ...
1
vote
2answers
50 views

Fixing the CiviCRM db when someone deleted “phone” from system dropdown menu options

Got a problem with how someone (I suspect) has gone in to CiviCRM » Administer CiviCRM » Option Groups » Phone Type Options and thought "hey, we don't need a dropdown item of "phone" because that's ...
1
vote
1answer
69 views

Illegal mix of collations

Using Joomla 3.8.6, CiviCRM 4.7.31, php 7.0.28, mysql 5.6.39 What should the database collation be for the CiviCRM tables? Mine are all utf8_general_ci. None of the tables in the database are ...
3
votes
2answers
178 views

DB Error: unknown error - [debug_info] => INSERT INTO civicrm_contact

it's fresh install of CiviCrm into my Joomla, run with UniserverZ (assume all Apps are in latest version) When I clicked CiviCRM, in Components, there was a DB Error: unknown error In the joomla/...
2
votes
0answers
43 views

CiviMail cannot create ACL recipient table after upgrading to CiviCRM 4.7.31

After upgrading to CiviCRM 4.7.31 I began to get several errors while initially trying to send a test e-mail using an ACL-based user. I noticed that these errors were not happening with the ...
4
votes
2answers
49 views

civiVolunteer database table creation?

When are civiVolunteer database tables created? When I run a search on volunteer opportunities and when a donation is made to our organization, we get database errors saying that tables ...
3
votes
2answers
240 views

Where is the civicrm database?

I recently took over a website and I have missing tables in the civicrm database (under wordpress). I want look at the civicrm database but I don't know where the database is stored. How can I find ...
2
votes
0answers
38 views

Fix for column names breaking the 64-character limit

I'm trying to generate a report using custom fields and I am getting nativecode=1166 ** Incorrect column name This happens when the report is trying to generate temp tables using an alias as the ...
0
votes
2answers
59 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
39 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
50 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
30 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
95 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 ...
8
votes
2answers
293 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
34 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
344 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
119 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
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
74 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
41 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
302 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
83 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
111 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
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
2answers
88 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
91 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
137 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
28 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?