Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
0 answers
14 views

Database error when attempting to add a contribution to a constituent's record

I'm getting an error screen when I try to add a donation to a constituent's record. I've pasted the error below. I think it comes down to Field 'amount_level' doesn't have a default value for the ...
user avatar
0 votes
1 answer
23 views

Error updating to civicrm 5.50.3 / Drupal 7.9

Attempting to update Civi to 5.50.3 [Drupal 7.9, updating from 5.47, PHP v7.3, Server version: 5.7.36-39-log - MySQL Community Server (GPL)] Run into PEAR related database update error. Any thoughts/...
user avatar
0 votes
1 answer
25 views

Possible Deleted Contact - Trying to Restore Records - Possible SQL Solution?

So here is the issue - that I think was caused by a merger of contacts without transferring the related fields to the new contact. I have a contact, that seems to be missing a large number of ...
user avatar
  • 3,122
4 votes
3 answers
61 views

Cleaning contacts

How do I identify the contacts who haven't opened any mailings in the last 3 years? I'm unsure which are the appropriate fields in the Advanced Search to make this process as easy as possible.
user avatar
3 votes
1 answer
38 views

Attempt Upgrade from 4.7 to 5.48 and database upgrade fails

I'm new to CiviCRM and am working for a client who's 4.7.x CiviCRM has issues where I'm unable to access tabs and I get an error when switching to some tabs in the menu system, so I'm trying to ...
user avatar
0 votes
0 answers
20 views

Getting Omnipay API error after Civicrm 5.47.3 upgrade (Wordpress)

I upgraded from Civicrm 5.46.x to 5.47.3 for Wordpress. When I ran Update, I got an error API error: DB Error: already exists on payment_processor_type.create( entity name ...
user avatar
0 votes
2 answers
47 views

Is CiviCRM the best platform for a very small nonprofit for data management?

Good Day, I am working with a small nonprofit with the mission of capacity building at food pantries and creating more access to health care initiatives. We are expanding and want to be able to track ...
user avatar
1 vote
1 answer
21 views

Minimum requirement: driver://host/database Error

My CiviCRM database cannot connect to my database server when it is loading a Drupal page that accesses CiviCRM through Views. We have been having all sorts of trouble with our Amazon Aurora instance ...
user avatar
  • 783
0 votes
1 answer
34 views

Cannot Load Civi - Unknown column in civicrm_cache Select

After making configuration changes to the Parameter Group for both the database and cluster of my Amazon Aurora database I can no longer access CiviCRM. I get the following error: Error code 19, "...
user avatar
  • 783
0 votes
0 answers
10 views

Error on "New Contact" after update to CiviCRM 5.45.1. System Status: OK (Joomla! 3.10.5)

The error is: Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were ...
user avatar
  • 91
2 votes
1 answer
34 views

Is there a search index that needs to be updated so CiviCRM Advanced search can find custom field data that was added directly to the database?

Is there a search index that needs to be updated so CiviCRM Advanced search can find custom field data that was added directly to the database? I created a custom field for Individuals (which is set ...
user avatar
  • 343
2 votes
1 answer
28 views

Do I need to change our database collations?

I just stumbled upon this problem, which was due to fields in some tables having conflicting collations. Thanks to the answer to that question I solved our immediate problem. But looking around I see ...
user avatar
  • 958
2 votes
2 answers
42 views

Move data from field to another field as a batch

I recently have taken over managing CiviCRM for an orchestra in Holland. Some fields have been used inconsistently, for example Nickname and First Name. I now need to copy all data in Nickname to ...
user avatar
0 votes
1 answer
26 views

Unable to import database dump - triggers

I had a problem importing a database dump because of some trigger errors. I'm not sure exactly what caused these errors (may have had something to do with custom case activities, which we use quite a ...
user avatar
  • 1,222
2 votes
0 answers
34 views

Database Errors When Recording Membership Contributions

I have an error happening in both my dev and production sites. I have attempted everything I can think of such as clearing the cache, rebuilding the menus, deleted and recreated triggers, upgradded to ...
user avatar
  • 783
0 votes
1 answer
26 views

WordPress Version 5.8.1, CiviCRM 5.18 plugin installed, but DB upgrade fails from civi 5.17.5 -> 5.18

I saved a backup and I can revert, but I'd like to go forward with this upgrade. Can anyone please tell me how to fix this? Thanks in advance. I am upgrading from 5.17.5 (the last patch of 5.17) to 5....
user avatar
1 vote
2 answers
53 views

How to split CiviCRM multiple database values with SQL?

The CiviCRM database stores multiple values as a varchar field (a string with separator characters). For example, the IDs 3, 9 and 15 are internally saved as #3#9#15# (where # is in fact the character ...
user avatar
  • 431
1 vote
1 answer
87 views

How to write update script

What I am trying to achieve - is to write a custom module(CiviCRM extension)/script, which should update( Run small SQL query to update about a missing "Module" ) Basically - what the script ...
user avatar
0 votes
0 answers
8 views

Contribution made "on behalf of an organization" leads to Warnings in DAO.php & DB Error: no such field

We have CiviCRM 5.39 and Wordpress 5.8 and have discovered a persistent issue arising in our contribution forms whenever we enable the donate "on behalf of an organization" option (Both when ...
user avatar
  • 21
2 votes
1 answer
79 views

Where are checksums stored in the database?

Where are checksums stored in the database? Is there any considerations to the limitations of how many checksums can be created at once in a mailing? If I send a checksum email to ~250,000 will that ...
user avatar
  • 2,914
1 vote
0 answers
27 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:...
user avatar
4 votes
1 answer
52 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" ...
user avatar
  • 41
3 votes
1 answer
41 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, ...
user avatar
  • 1,103
3 votes
1 answer
67 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, ...
user avatar
  • 783
0 votes
1 answer
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 ...
user avatar
1 vote
1 answer
43 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 ...
user avatar
0 votes
1 answer
64 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 ...
user avatar
4 votes
7 answers
329 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 ...
user avatar
  • 533
1 vote
1 answer
45 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 ...
user avatar
  • 11
1 vote
1 answer
38 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 ...
user avatar
1 vote
0 answers
48 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 ...
user avatar
4 votes
1 answer
54 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: ...
user avatar
1 vote
1 answer
46 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 ...
user avatar
0 votes
1 answer
30 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?
user avatar
1 vote
1 answer
40 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 ...
user avatar
1 vote
0 answers
28 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 ...
user avatar
  • 353
1 vote
1 answer
75 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 ...
user avatar
  • 1,012
0 votes
1 answer
34 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 ...
user avatar
1 vote
0 answers
44 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....
user avatar
  • 624
1 vote
1 answer
18 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. ...
user avatar
0 votes
2 answers
205 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 ...
user avatar
0 votes
0 answers
52 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 ...
user avatar
  • 783
1 vote
1 answer
47 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 ...
user avatar
1 vote
2 answers
98 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 ...
user avatar
  • 81
0 votes
1 answer
111 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 ...
user avatar
  • 31
0 votes
1 answer
52 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,...
user avatar
  • 867
3 votes
2 answers
55 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 ...
user avatar
2 votes
1 answer
58 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 '...
user avatar
  • 867
1 vote
1 answer
235 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. ...
user avatar
  • 21
0 votes
1 answer
39 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-...
user avatar

1
2 3 4 5
8