Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
31 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
255 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
95 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
136 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
38 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
231 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
87 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
285 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
571 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
105 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
63 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
90 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
75 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
56 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
248 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
3answers
169 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
62 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
138 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
528 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
321 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
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. ...
2
votes
2answers
664 views

database connection fails, but only in cron

I moved a site - actually copied a production site to a development region. The site is working in the development region, including CiviCRM, but the CiviCRM cron job fails: Jun 29 16:33:02 [info] ...
2
votes
3answers
113 views

What's the best strategy for upgrading CiviCRM?

I use CiviCRM 4.5.8 with WordPress. I'd kinda like to try a newer version, but I don't want to mess up the production website. I used the WP plugin Duplicator to create a test site. I changed the ...
3
votes
1answer
260 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-" ...
2
votes
3answers
201 views

Storing Personally Identifiable Information

Is anyone storing Personally Identifiable Information (PII), such as Social Security Numbers (SSN), in their database? How would I encrypt such a field in the database? I'm expecting that it would ...
5
votes
2answers
99 views

When upgrading from 4.7.7 to 4.7.8 I get error “Specified key was too long”

I tried to upgrade my Joomla CiviCRM 4.7.7 to 4.7.8 and got the following error in the database upgrade: ALTER TABLE `civicrm_contact` CHANGE `image_URL` `image_URL` VARCHAR(512) CHARACTER SET utf8 ...
0
votes
1answer
252 views

Remote Database Connection

I apologize if I am asking this in the wrong place, but I've hit something I cannot figure out.. I have remote drupal and civicrm databases that I want to use for multiple developers. My question ...
2
votes
1answer
34 views

Adding new default components to the database

I have been working on to add a default header and footer to the system workflow emails. Most of the part is done but I am stuck at setting those components in the database by default so that whenever ...
1
vote
1answer
172 views

regen.sh - Call to undefined function db_query()

So I was following this doc to add a new setting which asked me to run bin/regen.sh script. But running the script failed with the following error: PHP Fatal error: Call to undefined function ...
3
votes
1answer
90 views

Is it OK to drop database triggers in order to run a process?

I've spotted at least one process in CiviCRM that drop triggers on certain tables in order to run a process. For example: https://github.com/civicrm/civicrm-core/blob/...
1
vote
0answers
26 views

Saving in any frame just churns

Every time I save in a frame I get the following error. Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame\n\n thrown in /var/www/html/sites/all/modules/...
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: ...
0
votes
1answer
61 views

Unrecognized database version from 4.6.16 to 4.7.7

Joomla 3.5.1, Linux, Php 5.6.20 Is there a "quick fix" I could make to a script to allow it to either recognize the database, or would it be OK to manually change the database version number only ...
7
votes
3answers
81 views

How does CiviCRM handle multiple users editing the same record simultaneously?

I'm assuming that the record is locked so that only one user - presumably the first - can edit, whilst others are locked out until the record has been saved. But I don't know, and a client has just ...
0
votes
1answer
168 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....
0
votes
0answers
32 views

Unknown column civicrm_relationship.is_active while child smart group edit (create temporary table fails)

There are a parent Smart Group which contains several "child" Smart Groups. All was working a while, until at some time point it starts throw an error, something like [debug_info] => CREATE ...
1
vote
1answer
52 views

2 separate sites with the same php code

Is it possible with Drupal to have two sites, with 2 separate databases, sharing the same PHP code? For the future need of porting one database to another server, I don't want to use "Multi Site ...
3
votes
1answer
53 views

Is CiviCRM a 'master database' / 'master system'?

The membership organisation I work for currently has serious issues with it's membership databases. That information is currently split between a wordpress user database with an extension s2pro which ...
0
votes
1answer
135 views

How to run triggerRebuild URL

Apparently I am not allowed to ask for clarification in the post, so can someone please elaborate on this? Sounds good. To be sure, please execute ///civicrm/menu/rebuild?reset=1&triggerRebuild=1 ...
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
399 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 ...
6
votes
2answers
243 views

Adding states to countries

Hello we are moving an old CRM into CiviCRM. We are a very international organization and we have found that CiviCRM is missing many states. How do we get this added to CiviCRM? Should we make ...
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
2answers
32 views

Contact table: managing a new field

in my extension I have the need to manage a new contact information (I added a field in civicrm_contact, instead of using a custom field). Using the buildForm hook, I can show the input element in the ...
3
votes
2answers
56 views

Drush failing to build database during new installation

I am building a Docker container for CiviCRM, it is 99.9% done. Unfortunately, when I try to install the actual module via Drush, it spits out an error. I am fairly certain this isn't a Docker related ...
0
votes
1answer
35 views

4.7 Install, Database Settings Correct. Still no Contacts

I have upgraded from CiviCrm 4.2 to 4.7 now that I finally have it working it will not bring up contacts from the old Civi database. I looked at the setting php file and all the information is correct....
2
votes
1answer
104 views

Connecting Civi to a previous install's database

During my update from Civi 4.2 to 4.7 I let it fill in database information that was not correct it connected to the cms database and not the Civi database from the previous install. Is there a file I ...
3
votes
2answers
104 views

MyISAM, Cron, ERROR

I get this error on installing the CiviCRM plugin for Wordpress (Wordpress version 4.4.2, CiviCRM 4.7.4) System Status: Error MyISAM Database Engine Cron Not Running Configure Default Mailbox ...