Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
3
votes
1answer
38 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
571 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
29 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
35 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
51 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
5k 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
71 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
280 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
617 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
168 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
117 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
130 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
97 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
86 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
69 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
105 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
323 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
149 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
816 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
529 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
83 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
58 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
89 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
66 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
1answer
38 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
270 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 ...
1
vote
1answer
36 views

Batch edit one contact field (source) with same information

I have over 50,000 contacts that I would like to batch-edit with the same contact "source" information. What is the best way to do this?
2
votes
0answers
27 views

Bug in Custom Searches - Date Added to CiviCRM

I'm fairly new to CiviCRM but have successfully imported over 3,100 contacts from our current PC based DB system. If an error occurs during the my imports I have found the Custom Search 'Date Added to ...
2
votes
1answer
287 views

Installation Issue - Database Triggers not allowed by hosting provider

After spending 3 months configuring and testing CiviCRM on a locally hosted/internal server (and being suitably impressed), I attempted to install onto our website which is hosted with GoDaddy. I ...
1
vote
1answer
101 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
3answers
154 views

Using civi for big data sets (1 million plus)

I love civi! But mainly i use it for small datasets of sub 10,000 I have the opportunity to suggest its use in an organisation with a voter pool of 1 million+ I know this is an open ended question ...
1
vote
1answer
40 views

After server migration, cannot add contacts

Joomla vers 3.51 CiviCRM Vers 4.7.6 I´ve done a migration to a dedicated server. I did the copy of files and database with Akeeba Backup, then edited the usual files: /administrator/components/...
2
votes
2answers
236 views

unable to upgrade from 4.4.5 to 4.7.11 - 'DB Error: no such field' (Wordpress)

Trying to upgrade from CiviCRM 4.4.5 to 4.7.11 in Wordpress 4.5/4.4 (problem doesn't change for either WP version) because it stopped working and just printed this when trying to view /wp-admin/admin....
1
vote
1answer
91 views

Create new CiviCRM database…?

I just succesfully installed CiviCRM on our website (WordPress), I created a new DB but was not given the option to specify it during the installation process. It seems to have installed in a DB that ...
1
vote
1answer
372 views

DB Error: unknown error (Tablespace is missing for table .civicrm_setting)

i just restarted my PC which has a locally hosted dev version of CiviCRM in WordPress, and now get the following error on initialization... Initialization Error Array ( [callback] => Array ...
0
votes
1answer
647 views

Copy old WAMP directory to new installation of WAMP

Can anyone assist with the following scenario please... -I had a local install of Wordpress and CiviCRM using WAMP. -PC died but I was able to retrieve the Hard Drive and install in another PC as a ...
1
vote
1answer
116 views

What is the database schema for groups and parent groups?

I need to manually delete a group that is corrupt. Already tried a few things. This corrupt group assigned itself as the parent to other groups and continues to add additional children groups every ...
1
vote
1answer
79 views

Running a script from cli

How would I call CRM_Core_I18n_Schema::rebuildMultilingualSchema($locales, NULL); from the command line? Minor upgrade seems to have had an insignificant DB error and this line did not get called. ...
2
votes
2answers
96 views

DB table that exists says it doesn't

After upgrading to 4.7.10 from 4.7.9, I'm no longer able to edit/add price sets. I think that the DB changes related to https://issues.civicrm.org/jira/browse/CRM-12252 are biting me. (Multi-lingual ...
0
votes
1answer
22 views

hook_civicrm_post - on creating event cannot update the record in `civicrm_event` table

I have a custom field in civicrm_event table which I want to update on creating event. However the hook_civicrm_post on creating event cannot update the record in civicrm_event table due to database ...
1
vote
1answer
77 views

Unable to Import, edit certain records and edit Group settings: DB Error: constraint violation

I am unable to make certain edits to CiviCRM; unable to edit certain records and unable to edit the visibility of groups. I think the problem is this: Cannot add or update a child row: a foreign key ...
0
votes
3answers
59 views

Recurring iATS contributions not creating civicrm_finanical_item records

We are ramping up for online donations and use the Accounting Batches CSV export to get our Civi contribution data into our 3rd party accounting software. A key piece of data from that report is the '...
9
votes
1answer
255 views

CiviCRM still creates MyISAM tables which results in Warning

CiviCRM 4.7.10 --- WordPress 4.6 The following warning message appeared in CiviCRM System Status: Your database is configured to use the MyISAM database engine. CiviCRM requires InnoDB. You will ...
1
vote
2answers
178 views

CiviCRM Upgrade Wordpress 4.4.5 to 4.7.10 DB Error: no such field

CiviCRM Upgrade Wordpress 4.4.5 to 4.7.10 DB Error: no such field. Site shows at bottom of screens: Powered by CiviCRM 4.4.5 Trying to upgrade to 4.7.10 and after pressing Upgrade button CiviCRM ...
1
vote
3answers
63 views

How do I scrape an old website into a .CSV file for data migration?

I'm organizing my data to prep for CiviCrm. One of the data banks we have is an online directory listing of hundreds of names, contact information and bios. NONE of this is organized into a ...
1
vote
0answers
142 views

How to connect with state and country table

We are using CiviCRM (4.7.9) with WordPress (4.5.3). We are pulling the data from the CiviCRM state and country tables into Gravity Forms using code in our function.php. But we are running into ...
2
votes
1answer
554 views

getting error message “too many connections”

Getting an error message on public website regarding too many connections. We increased our SQL connections, but we don't have a lot of interaction going on between our website and CiviCRM. We have ...
3
votes
1answer
354 views

Change domain name (wordpress)

I have civi crm 4.7.8 on wordpress 4.5.3 and I've changed my website domain name. When I go to wp admin, i can see civicrm icon and go the taskboard, but I haven't civicrm menu. I supposed there are ...
1
vote
1answer
56 views

Are custom Dedupe General rules working for anyone?

On CiviCRM 4.7.8/Joomla 3.5.1, I've experimented with variety and can't seem to get this to work. The preset reserved rules, import, inclusive in contact record and main dedupe rules are all working. ...