Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
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
63 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
79 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
102 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
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? ...
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 ...
2
votes
1answer
303 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
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.
3
votes
1answer
332 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
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 ...
1
vote
1answer
111 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
85 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 ...
0
votes
1answer
136 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
681 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
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 ...
2
votes
4answers
79 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
182 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
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 ...
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 ...
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 ...
3
votes
2answers
485 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 ...
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 ...
1
vote
1answer
32 views

hook_civicrm_postSave_table_name not called on table update

In Drupal, I'm using hook_civicrm_postSave_table_name to listen for CiviEvent registrations. I've implemented hook_civicrm_postSave_civicrm_participant($dao) where I test for certain status_id values ...
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 ...
2
votes
1answer
65 views

DB Error: IP address hard-wired with MySQL user?

I have a local windows "mirror" using XAMPP of my live Wordpress 4.7.2 + CiviCRM 4.7.14 setup. I wanted to use the windows version to test exactly how deduping worked using Contacts > "Find and Merge ...
1
vote
1answer
270 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 ...
2
votes
1answer
547 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:...
5
votes
1answer
144 views

How to reduce database bloat for faster upgrading?

In order to speed up slow upgrades, experienced folk (1 2) recommend reducing the size of the database to facilitate testing. What is the best way to declutter the database?
1
vote
5answers
105 views

Settings - Outbound Mail are not saved

please help, I have a Joomla 3.6.5 and CiviCRM 4.7.14 I just migrated from the dev site to the live site, and now when I check the Outbound Mail settings in CiviCRM, they are empty. Everytime I fill ...
1
vote
1answer
102 views

Syntax for drush command civicrm-sql-dump

My attempt to backup my civicrm database using mysqldump has failed after a very rocky CiviCRM upgrade process, or it is taking way too long, so I am trying the drush command, drush civicrm-sql-dump ...
1
vote
1answer
90 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
2answers
84 views

Older CiviCRM that does NOT require TRIGGER privileges?

As of title, I'm looking for a CiviCRM version that does not require trigger privileges, since the hosting service that I'm using does not support it, currently I'm on version CiviCRM 4.7.13 and ...
1
vote
0answers
68 views

Database upgrade error - 4.7.13

The process to upgrade my civiCRM database from 4.7.11 to 4.7.13 terminated with the following error: [Error: Upgrade DB to 4.7.13: SQL] Error Field Error Value Type DB_Error Code -19 Message ...
0
votes
2answers
84 views

What type of database does CiviCRM use?

I'm sure this is a very obvious question but what type of database does CiviCRM use? SQL Server, MYSQL, etc.
2
votes
1answer
285 views

Transfer Database to new location raised MySQL Error function already exists

I follow the instructions here https://wiki.civicrm.org/confluence/display/CRMDOC/Moving+the+database+using+phpMyAdmin I want to import the so called Old_without_five_tables.sql with phpmyadmin in ...
2
votes
2answers
121 views

Error creating Custom Data - DB Error: already exists

When I try to create Custom Data ( Administer-->Customize Data and Screens-->Custom Fields ), I get the following message. The query info is different depending on the type of Custom Data I am trying ...
0
votes
3answers
767 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
1answer
505 views

What is the installation canary?

One of my CiviCRM instances database has the table civicrm_install_canary, another has not. In code it is marked as a mechanism that check whether the install has run before. But how does this ...
2
votes
1answer
78 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 ...
2
votes
1answer
51 views

Do I need root access to my database to use CiviCRM? [duplicate]

After installing your plug in, I looked at the CiviCRM installer page and was shown an error which said "unable to create database triggers". I have shared hosting. Is it possible to still use this ...
0
votes
2answers
88 views

MyISAM engine error but the DB is all InnoDB

On my install CiviCRM runs in a separate database that is entirely InnoDB, but Civi throws up the MyISAM engine error anyway. The rest of wordpress lives in a DB that is InnoDB by default, although ...
4
votes
3answers
62 views

CiviCRM Raw Data Files

We use CiviCRM for our nonprofit, and we're trying to figure out how we can export our raw data in order to upload it into some custom apps. Any help would be very much appreciated! Cheers, Jillian
1
vote
0answers
29 views

Using Views with two sql servers

I am trying to set up Views on my CiviCRM 4.7.10 (Drupal 7.42). My Drupal database is on one SQL server. And my CiviCRM database is on another SQL server. Whenever I try to create a new view, I ...
0
votes
2answers
260 views

Who is 'backup_Mk047aB'@'%' from the error 'The user specified as a definer ('backup_Mk047aB'@'%') does not exist'

While the back-end is working - e.g. I can add fields to profiles, etc. -, I see form data perfectly fine when calling pages, I cannot modify or add contacts resulting in Sorry but we are not able ...