Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
93 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
1answer
28 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 ...
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 ...
0
votes
3answers
785 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
3answers
324 views

How do I add a new table to my extension?

I have added tables to my database by writing SQL commands in a sql folder as specified in the given link. Add a database upgrader / Installer / uninstaller. What I am exactly looking for is a ...
2
votes
1answer
577 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:...
1
vote
1answer
279 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 ...
3
votes
1answer
55 views

Is it possible to change custom group/custom field Entity Scope from just individuals to individuals and households (or ANY)?

I have an existing field for the donor name to show in printed materials. It was set up just for Individuals. The Custom Group has only this one field in it. Several reports/profiles/templates already ...
1
vote
5answers
832 views

Ajax Error when trying to view relationships tab

Civicrm 4.7.1 Joomla 3.4.8 I'm unable to view data in the relationships tab. I get the following errors: "DataTables warning: table id=DataTables_Table_0 - Ajax error." And "DataTables warning: ...
1
vote
1answer
98 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
2answers
65 views

Unknown DB Error When Trying to Disable the Automatic Wildcard Option

We are trying to disable the automatic wildcard option in Civicrm (Wordpress 4.7.2). However, when we try to disable the option and save we get an error that says “Save Failed: DB Error: Unknown ...
1
vote
2answers
49 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
70 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 ...
2
votes
1answer
146 views

DB Upgrade Fails when creating Getting Started Dashlet

CiviCRM 4.6.11 to 4.7.1 Update Joomla 3.4.8 Error page during DB upgrade utility: [Error: Add Getting Started dashlet] Error Field Error Value Type DB_Error Code -3 Message DB Error: constraint ...
1
vote
1answer
635 views

How do I create and access a database for civiCRM

I am trying to install CiviCRM in WordPress to see if the small NGO I work with might be able to use it. I got a domain name and installed WordPress through BlueHost.com and turned on the CiviCRM ...
5
votes
1answer
149 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?
0
votes
1answer
173 views

CiviMail DB Error: no database selected

Civi 4.6.15 Joomla 3.5.1 Previously I upgraded my civi version to 4.7, and somehow I corrupted my database. I reinstalled a clean 4.6.15 and restored my database from backup. It seemed to be working....
1
vote
1answer
319 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 ...
1
vote
1answer
111 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 ...
2
votes
2answers
92 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 ...
1
vote
1answer
33 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
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 ...
2
votes
1answer
46 views

Detailed Contribution Info Not Displayed

CiviCRM Version: 4.6.15 CMS: Drupal 7.43 I'm running into a weird bug and I'm not sure how to track it down. All of our old contributions (Pre 2014) don't show when you click on the the [contact] > [...
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
93 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
296 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 ...
1
vote
2answers
173 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
1answer
39 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
1answer
420 views

CiviCRM Initalization Error: DB Error: extension not found

I've got CiviCRM installed within a WordPress context, and both are updated. The problem is that, with the last update that occurred, I can no longer get to CiviCRM. Instead, I get the following ...
4
votes
2answers
1k views

Could not create a database trigger on AWS RDS

I am installing CiviCRM in Amazon AWS environment. User civicrm has full rights on civicrm database. I certainly see TRIGGER among all others in my phpMyAdmin console. Out of abundance of caution I ...
2
votes
1answer
264 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
55 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. ...
9
votes
1answer
513 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 ...
1
vote
1answer
76 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 ...
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
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
3answers
58 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 '...
1
vote
1answer
2k views

Install Error DB Error: extension not found

Using "upload package file" or "install from folder" on a clean new Joomla 3.5.1 installation without any other extension I get this error : Cannot open mysql://XXX:YYY@localhost/XXX?new_link=true: ...
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 ...
3
votes
1answer
263 views

Database name on Wordpress can't include hyphen, but our host has mandatory prefix-hyphen-name format

Is there any way we can work around this? Our Joomla install was quite happy to use a db of format xxnn-yyyyyy. When we create or rename db using phpMyAdmin we can only choose the yyyyyy. "xxnn-" ...
1
vote
1answer
110 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 ...
2
votes
3answers
145 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 ...
2
votes
2answers
232 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
0answers
140 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 ...
0
votes
1answer
608 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 ...
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
72 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. ...
9
votes
1answer
250 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 ...
2
votes
1answer
541 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 ...