Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
14 views

Can't connect to separate database

Trying a new install of CiviCRM 5.3.9 using a separate Wordpress database. Wordpress, MySQL and PHP are confirmed required versions. Path is definitely correct using mysql://USER:PASSWORD@localhost:...
3
votes
1answer
23 views

Event Calendar database error

I installed the Event Calendar extension on a Wordpress (5.7.2) site with CIVICRM 5.37.2. I followed the installation instructions and added the [event_calendar component="event-calendar" ...
3
votes
1answer
28 views

Will this solution safely reduce the disk size of my database

I need to reduce the size of my Civi database. I've done a bunch of reading and have found what looks like a solution. Please will someone step in to advise if this solution (below) is the way to go, ...
1
vote
1answer
25 views

Drupal 9 View Shows Permission Denied For CiviCRM Tables

I have my Drupal 9 database and my CiviCRM database in two separate databases on the same Amazon MySQL Aurora instance. The setup in our dev environment is identical and is working perfectly. However, ...
0
votes
1answer
13 views

Including contacts that have done multiple activities in one search

I'm trying to build a list of people who did one specific activity (which was send an email) that have done other activities as well (trying to find activists). How do I build this list? Trying to ...
0
votes
0answers
14 views

DB Error: no such field in pear-core-minimal after Civicrm Migration

After civicrm migration following https://docs.civicrm.org/sysadmin/en/latest/misc/switch-servers/ with Akeeba on Wordpress, civicrm breaks wordpress, the Apache error log says: see below. Can anybody ...
1
vote
1answer
37 views

Add a custom field as a column in relationship tab

I added a column in relationship tab, to do that I edited the civicrm/CRM/Contact/BAO/Relationship.php I already added columns with fields existing in the base of civicrm but now I'm trying to add a ...
0
votes
1answer
33 views

Corrupt installation during upgrade to 5.37.2 on Joomla 3.9.26

I have run into some trouble trying to upgrade from and old version of Civi to version 5.37.2 on Joomla 3.9.26 running on PHP 7.3.27 and MySql 5.7.32-35. The initial problem was that I could not get ...
0
votes
0answers
10 views

Schema check option

I just had a problem when some of my tables referenced another one with a foreign key which had no values in its column. This seems to me a corruption and fairly basic to check. Is there some ...
3
votes
6answers
160 views

database upgrade script failing: Call to undefined method CRM_Upgrade_Incremental_php_FourOne::getMajorMinor()

I'm trying to upgrade CiviCRM in a Joomla 3.9.26 environment from 5.25.0 to 5.37.0. I ran the file installation, cleared the media/template_c folder, then tried to run the database upgrade script. I ...
1
vote
1answer
40 views

Upgrade to version 5.37 - Database error

I have avoided upgrading for quite a while, but went ahead finally. Here is the error received below, and am completely unsure where to go to edit the field length. Or is the solution to rollback and ...
1
vote
1answer
35 views

Change Log Tab Excrutiatingly Slow - Poorly Performing Query and Fix (from 8 minutes down to 4 seconds)

The page takes about 8 minutes to return which is absurdly slow for anything expected to be remotely interactive. It is so slow that my client is referring to it as the "Triangle of Doom". I ...
1
vote
0answers
41 views

Poorly performing unindexed query on log tables

While investigating a CiviCRM performance issue, I came across this query: SELECT * FROM `civicrm`.`log_civicrm_activity_contact` WHERE log_conn_id = ? AND id = ? ORDER BY log_date DESC limit ...
4
votes
0answers
44 views

Redundant Indexes

It looks like there are several redundant or partly redundant indexes that civicrm creates on the database. Some of this may be storage engine specific (e.g. InnoDB), but some isn't. civicrm_contact: ...
0
votes
0answers
11 views

How to query data changes?

I'd love to query data changes in CiviCRM. I know many things are journalized, can this be queried ? How can it be queried ? I'm a french guy. I may not use the right words, I just hope you see what I ...
1
vote
1answer
35 views

One database table very large

Database table Table: civicrm_contact_push_notification_messages Is huge. 51GB to be precise. The main field is %display_name has created activity. Is this the table that shows up what emails have ...
0
votes
1answer
24 views

missing config_backend in civicrm_domain table, templates_c directory and Config.IDS.ini after migration

I didn't do the database dumps or file backups for this migration of CiviCRM on wordpress, so could it be a problem I can solve without going back to the old host?
1
vote
1answer
29 views

CiviCRM WordPress uninstall - db issue

Uninstall CiviCRM from WordPress, is creating me a big issue. I needed to uninstall CiviCRM (5.31.1) from a production site, saving all theme and others settings. CiviCRM went away without uninstall ...
1
vote
0answers
26 views

Merging much of a large well-used database to a new install… even possible?

Is it totally crazy to think of creating a new Civi install (have one set up in Drupal 9 already) and merging a well-used Civi database into it, table by table? We've had our Civi install since around ...
1
vote
1answer
59 views

How can I delete a custom field (other than GUI)?

I had a custom field group with a disabled field. When I tried to delete the field (ID=59), the Warning window froze with CRM logo rotating. When I tried to enable the field, it gave Error about DB ...
0
votes
1answer
33 views

Upgrade database URL loops to WP login screen but works on a cloned staging site

Experiencing a strange situation where the database upgrade url worked perfectly for a testing site but not for the live site. I successfully tested the upgrade with a cloned staging site without a ...
0
votes
0answers
24 views

What are your typical mail size batches and delviery times?

What are your typical mail sizes and time to complete mail job? Looking for comparisons... We are having lots of mail delivery problems on a new highly customised install of Civi v5.27.1 (MariaDB v10....
1
vote
1answer
14 views

DB error in 'civicrm_group_roles' module

When I log in to my site and I have the civicrm_group_roles module enabled, I'm getting this generic error in the browser: Error The website encountered an unexpected error. Please try again later. ...
0
votes
2answers
45 views

Database Issue: DB Error: no such field

There was a similar post recently about a similar issue but I'm not positive they are related. I am having issues when trying to add or work with any contact in the system. The error is: DB Error: no ...
0
votes
0answers
32 views

CiviCRM Cannot Connect To Aurora DB

I am trying to switch from RDS to Aurora DB for test site to see if it is viable. I am confused with the first problem I am running into and I am not sure why CiviCRM would have this issue. Drupal 8 ...
1
vote
1answer
45 views

CiviCRM database

I had a previous install of CiviCRM that was connected to a database that had to be changed for Wordpress site. Now, setting up CiviCRM again, I discover (in civicrm.settings.php) CiviCRM and the ...
1
vote
2answers
65 views

database error when finishing update to 5.32

I'm running CiviCRM in Wordpress 5.6 I tried upgrading from CiviCRM 5.21 to 5.32 following this process: https://docs.civicrm.org/sysadmin/en/latest/upgrade/wordpress/ Now, the last step is visiting ...
0
votes
1answer
55 views

DB: No such field! Error message

We're just a very small charity trying to put this together with limited experience. I had set up some custom fields for the database but some changes to those fields was requested which I made and ...
0
votes
1answer
29 views

utfmb4 conversion gone wrong - Some columns in the databse have utf8mb4_general_ci others utf8mb4_unicode_ci causing and Illegal mix of collations

I've recently run utf8mb conversion (through API explorer) on civi 5.28. Everything seemed OK, but now whenever I try to access events dashboard I get Illegal mix of collations (utf8mb4_general_ci,...
3
votes
2answers
43 views

“Find Respondents to Reserve” - DB Error: syntax error

System Info Wordpress ver. 5.5.3 SQL: 10.3.24-MariaDB-log-cll-lve - MariaDB Server Server: Cloudlinux 3.10.0-962.3.2.lve1.5.38.el7.x86_64 Apache 2.4.46 PHP 7.4 Issue is in both Civi ver 5.31.0 and ...
2
votes
1answer
51 views

DB error for sort_name when adding contacts with long names in 2 bytes UTF8 characters

The problem occurs when I try to add a contact (in the example it's an organization) with long name in Cyrillic (multiple words in it's name). I get the nativecode=1406 ** Data too long for column '...
1
vote
1answer
148 views

What does it mean to “configure your MySQL server for utf8mb4 support” when my database charset and collation are already utf8mb4?

I am about to run the CiviCRM installer, but I get the following warning: CiviCRM MySQL utf8mb4 Support: It is recommended, though not yet required, to configure your MySQL server for utf8mb4 support. ...
0
votes
1answer
31 views

Lost database on civicrm

I have been working on my membership database on civicrm for the last 4 years and since March I have not been able to access it. I normally type this on google https://hlpacivicrm.esptest.co.uk/cms/wp-...
4
votes
2answers
49 views

Preparing for move to utfbmb4 should I limit character length?

I'm looking into moving our database to utf8mb4 - as indicated will be required in the future. I've been trying to find information about the possible impact in doing so and I found this post: https://...
0
votes
0answers
10 views

CiviCRM membership Manual entry in joomla

I am facing very strange issue in CiviCRM. I have added the membership entry manual from the administrator but I wonder that record is not exist in the database. I searched into all tables but no ...
0
votes
0answers
85 views

How to migrate Civi DB from a Drupal 7 to a Drupal 8 site

I'm tasked with migrating a CiviCRM database from a Drupal 7 site to a Drupal 8 site. So far there's 2 approaches I've thought of. Copy the whole DB as standard and import it into the new D8 site. I'...
3
votes
1answer
45 views

Migrate from Drupal to WordPress - 'DB Error: no such table'

I'm following the methodology at https://docs.civicrm.org/sysadmin/en/latest/misc/switching-cms/drupal-to-wordpress/ to migrate from Drupal to WordPress. After importing the database tables to the ...
1
vote
2answers
71 views

CiviCRM on WordPress wont Install Issue

I'm brand new to CiviCRM and have been asked in stall in a test site and review how it works. I have the latest WP 5.5 installed. I've uploaded CiviCRM via ftp to the plug ins folder. I went to the ...
0
votes
1answer
47 views

Moving all contacts from CiviCRM to Kepla

my organisation is currently switching from CiviCRM to Kepla. I'm wondering about the best way to export all contacts information out of Civi and import it into Kepla. I have been able to export ...
2
votes
0answers
28 views

Different Schema / Database in Multisite

We're planning to use CiviCRM for a large number of voters (~10M voters). This questions is related to the one here. We were wondering if it's possible to split these 10M voters into different schemas....
3
votes
0answers
31 views

Using CiviCRM + S3 for ~10M contacts

We're planning to use CiviCRM for a large number of voters (~10M voters). Most of these voters will never be contacted and so we don't need all of them in CiviCRM. We'd like to store these contacts in ...
1
vote
0answers
33 views

moving DB to a new server - PHP errors

I have been attempting to move a civi install to a new site with little success. I know I have managed this before with another site, so I am especially mystified. I have reviewed the the guide at ...
0
votes
0answers
26 views

Reinstall Summary Fields Not Creating Triggers

I have uninstalled and reinstalled Summary Fields a couple of times trying to get the triggers to show up on the admin screen as having been recreated. I started looking into this because we have a ...
2
votes
1answer
43 views

'DB Error - No Such Table' — CiviCase in Drupal 7

I have a Drupal 7 + CiviCRM database with CiviCase. This is a fairly new install. I would say CiviCRM was installed fresh about 3-4 months ago. As of now, CiviCRM has been upgraded to the latest ...
0
votes
1answer
54 views

civicrm_contact_push_notification_messages table huge

We installed Civimobile as a test, and aren't yet using it. It does look great! We have noticed a file on our server of gigantic proportions: civicrm/civicrm_contact_push_notification_messages.ibd: ...
2
votes
1answer
27 views

When exporting data from CheckBox field, can value of be different from what is displayed?

When exporting data from a custom CheckBox field, can the value of the data exported be different from what is displayed? For example, the checkbox Multiple choice is labeled "Asked" but I would ...
1
vote
1answer
64 views

Civi is slowing down my website

Our website is hosted on Drupal 7 but is tied to our database in civi 5.14. We are experiencing a surge in new registrations which require people to fill out a full page of information that then gets ...
2
votes
2answers
39 views

How do I find the number of our association's members at the end of each calendar year?

I'm using Reports, Membership Reports, Membership Summary. In the filter section it seems to require "Member
0
votes
0answers
21 views

CiviCRM will not load the database [duplicate]

I am doing a fresh install of CiviCRM. Civi is using the WP database. When I use the Installer, I get the error "CiviCRM data from previous installation exists in 'db_WPyadayada'. Is there a way to ...
2
votes
1answer
79 views

When reinstalling CiviCRM, it will not allow connection to a database with preexisting data

I am reinstalling CiviCRM on Wordpress after Civi quit quit working. I deleted the folder civicrm in /plugins and also in /uploads. This allowed me to upload the new plugin version of Civi and took ...

1
2 3 4 5
7