Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [database]

The tag has no usage guidance.

2
votes
2answers
36 views

CiviCRM 5.9.1 Cannot Read Database Information

CiviCRM 5.9.1 WordPress 5.0.3 PHP 7.2 Upgraded after migration between servers from 4.7.29 w/o issue. When I went inside the CiviCRM it asked me to redo everything like a new install. I went to the ...
3
votes
2answers
33 views

Database Error - unsure what the issue is

this morning I started encountering database issues - the only thing I can think of is the upgrade to 5.9 that we did yesterday. First discovery was the Cron error - via log. Jan 17 10:15:02 [...
2
votes
3answers
55 views

DB Error: constraint violation on anonymous user event registration after 5.8.2 -> 5.9.0 update

After updating from 5.8.2 to 5.9.0, anonymous users suddenly get the above error when trying to register for an event. Anyone a good hint how to resolve that? Thanks Debug log shows Datenbank-...
2
votes
0answers
13 views

Multilingual and multidomain: “unknown column” DB error. How to set preferred language for child domains?

I am running CiviCRM v.5.4.0 in a WordPress (v.4.9.9) multisite. The WordPress main site is CiviCRM Domain_ID 1, and each WordPress child site has a different CiviCRM Domain_ID. This has been working ...
3
votes
1answer
43 views

How to get CiviCRM Views to work in Drupal 8 with separate CiviCRM database

When setting up a Drupal 8 with separate CiviCRM database, the Drupal views cannot read the CiviCRM database: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxx.civicrm_contact' ...
1
vote
3answers
27 views

Wordpress: MyISAM Database Engine Error after update

After update to Civicrm 5.8.0 I got a: MyISAM Database Engine Your database is configured to use the MyISAM database engine. CiviCRM requires InnoDB. You will need to convert any MyISAM tables in ...
0
votes
2answers
39 views

Hosting Provider for CiviCRM

I am trying to install my CiviCRM instance on my current drupal installation that is my website which is hosted by the webgo24.de. During installation I get an error „DB Error“ and after some emails ...
3
votes
1answer
42 views

Ran direct SQL update to bulk update contact names, changes not appearing until editing and saving

I'm finishing up a migration to CiviCRM from a homegrown Python application I wrote, and without going into too much detail as to the why, I needed to do a bulk update of all the contact name fields ...
1
vote
1answer
49 views

Completely lost. Help!

No one at our organization knows how to use Civi. The person who set it up is no longer on staff. How do we even get in touch with someone? We urgently need to get into our account on the Civi website ...
-5
votes
2answers
31 views

I would like a complete list of features via email please

My problem is asking for a list of features through this difficult portal. I hope the software isn't as user unfriendly as this portal. Please send list of features to my work email address = ...
2
votes
2answers
25 views

What is the best way for an end user to get all the contact and activity data from the database?

Our group is using CiviCRM to house membership data for a small food cooperative. We've lost our web developer and we're trying to get all of our data out of CiviCRM with only the user interface ...
0
votes
1answer
32 views

How will I maintain versioning of civicrm in github?

I customized a civicrm. I want to put on github.I cannot maintain a mysql database versioning. How can I do that?
1
vote
1answer
27 views

Could not create database trigger (AWS, RDS)

How can I fix this issue about database trigger. I attached the screenshot for the info. Thanks so much for the help]1
2
votes
1answer
42 views

Upgrade to CiviCRM 4.3 failing on DROP FOREIGN KEY

I have successfully upgraded many other CiviCRM installations over the years, but I've been unable to work my way through this issue so far. Ubuntu 14.04 MySQL 5.7.23 Apache/2.4.7 PHP Version 5.6....
1
vote
1answer
31 views

Error Upgrading DB to 4.7.18: SQL

[Error: Upgrade DB to 4.7.18: SQL] [nativecode=1062 ** Duplicate entry 'Chandigarh-1101' for key 'UI_name_country_id'] How can I fix the error as given below: INSERT INTO `civicrm_state_province` (...
1
vote
1answer
43 views

Wordpress CiviCRM site unusable after database upgrade from 5.4.0 to 5.5.1

I'm relatively new to CiviCRM and am trying to get a client set up with the platform. I like it overall, it seems much more usable than most I've touched in the past. All seemed to be going well ...
1
vote
1answer
32 views

Running 2 civicrm instances on 1 database

I have one mySQL database and one Apache webserver. Can I still run 2 separate wordpress/Civicrm environments (like staging and production)?
1
vote
2answers
29 views

Where is the developer documentation for making core CiviCRM database changes, to the schema and to the initial data?

I'm working on a (newer) PR for CRM-19751, which requires some database schema changes and addition of an option group with its options. Obviously I knew something about this when I created the ...
0
votes
1answer
31 views

Database in unexpected version (and we have no backup DB)

Applied the 5.3.2 patch to our WP site yesterday, and in so doing upgraded the database to 5.6.alpha1. After doing this, multiple components (Contributions, Events, Mailing) became unusable. Trying to ...
1
vote
1answer
31 views

Delete contacts from group

I'm tried to delete contacts group (basically entire contacts from the particular group), getting Gateway timed out error and only few contacts are getting deleted. So I'm planning to delete ...
-1
votes
1answer
33 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 ...
-1
votes
1answer
43 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
44 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
29 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
27 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
23 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
56 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
56 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
35 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
98 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
25 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
79 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 ...
0
votes
0answers
54 views

CiviCRM_API3_Exception: “DB Error: no such field”

After upgrading to version 5 (following the upgrade guide fully, migrations went through without errors), I now have an error when I am trying to edit (or create) my contribution pages : ...
1
vote
2answers
140 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
189 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
21 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
111 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
48 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
56 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
122 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/...
0
votes
0answers
87 views

Custom Field Set Creation yields Duplicate entry '0' for key 'PRIMARY'

When I try to create a custom field set, I get the following error when I save it. How do I correct this issue? DB Error: already exists Error Details Database Error Code: Duplicate entry '0' for ...
2
votes
0answers
32 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
44 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
149 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
34 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
49 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 ...
0
votes
0answers
22 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 ...
3
votes
1answer
23 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
28 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
85 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 ...