Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
35 views

Why are my mailings failing with "DB Error: no database selected"

I am using CiviCRM 5.71.1 with WordPRess 6.4.3, but this issue has been going on for a long time and I am, as they say, "at Witt's end" (yes, that spelling :-) When I try to send a scheduled ...
The Amateur's user avatar
0 votes
0 answers
47 views

Log Detail Report - DB Error when viewing an update to a contact

Developer question. Civi 5.71.1 on Drupal 10 with a separate db for CiviCRM logs. Symptom I'm getting many "DB Error: no such field" errors when viewing "update" changes in the Log ...
Justin657's user avatar
  • 195
0 votes
0 answers
22 views

Database Upgrade 5.32 to 5.70.1 (Wordpress)

I have upgraded the program from 5.32 to 5.70.1 on WordPress 6.4.3 but the database will not upgrade. When I run the script( http://russisforus.com/wp-admin/admin.php?page=CiviCRM&q=civicrm/...
MRusty's user avatar
  • 1
0 votes
0 answers
17 views

Retrying after Database deadlock encountered hit on attempt 1 at query : INSERT INTO civicrm_mailing_recipients?

Drupal 10.2.3 , CiviCRM 5.70.0, PHP 8.2.13, MySQL: 10.6.16-MariaDB-0ubuntu0.22.04.1, nginx/1.18.0 Got the below in logs after almost each contribution (contributions status="Completed" ) : ...
yurg's user avatar
  • 2,005
2 votes
1 answer
75 views

Can I modify the Field Label name once the custom field has existing records?

Can I modify the Custom Field Label Name once the custom field has existing records? Will it cause any errors in the database, or are there any concerns that I should be aware of?
Chen Ya Yin's user avatar
0 votes
1 answer
27 views

Development site is connecting to production database (DB Error: insufficient permissions)

I updated CiviCRM on Drupal 7 to the latest version (5.70.0) in Production. I then copied the production environment into a development URL on the same server, and updated /sites/default/civicrm....
David W's user avatar
  • 157
0 votes
2 answers
56 views

Duplicate records in UFMatch

Wordpress 6.4.2, CiviCRM 5.69.2 Have got the "You have multiple records with the same uf_id in civicrm_uf_match. You need to manually fix this in the database so that uf_id is unique" but ...
yurg's user avatar
  • 2,005
1 vote
1 answer
42 views

Database error when exporting Activities: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535

I've reviewed the other related tickets here, but the solutions either don't seem applicable or are things we've already got in place - file format and character encoding are what they need to be I ...
zip's user avatar
  • 163
1 vote
1 answer
51 views

Database failures on activities after upgrade from 5.52 to 5.68.1

Upgraded from Civi 5.52 to Civi 5.68.1 on Drupal 7, PHP 7.3.13, Mysql 5.74. The errors are all revolving around activities. Anywhere in the UI that involves showing activities is returning a DB ...
richardsplayground's user avatar
0 votes
1 answer
50 views

CiviCRM Upgrade Fails Between 5.65.2 and 5.67.3

I am trying to upgrade between CiviCRM 5.65.2 and 5.67.3. My CMS is Drupal 9.5. During the upgrade I get the following error. Upgrade DB to 5.65.alpha1: SQL (CRM_Upgrade_Incremental_php_FiveSixtyFive::...
Josh's user avatar
  • 887
1 vote
1 answer
43 views

Basepage not showing

I recently installed civicrm on a wordpress install. I followed the installed and went through the installation. I thought I would see a log in page for civicrm on the /civicrm link. I am seeing a ...
Emily Reynolds's user avatar
0 votes
0 answers
27 views

Upgrading database to 5.67 and update button is not a button

I'm trying to upgrade from 5.66.1 to 5.67. I followed the instructions and visited the database upgrade link. The upgrade now button for the database is not a button or a link - its unclickable. I am ...
user15536's user avatar
0 votes
1 answer
59 views

Display Total Membership in Wordpress home page

We are running Wordpress 6.3.1 and Civicrm 5.65.1 We would like to dynamically display the Total Member count on our Wordpress home page. We have different member categories and would like to display ...
markd's user avatar
  • 71
0 votes
0 answers
14 views

Maria database temp files using up all server space

Our server is crashing on a regular basis, as much as once every few days. The problem is MariaDB is generating multiple large temp files, *.MAD and *.MAI files. This is happening even though we have ...
Ben's user avatar
  • 946
0 votes
1 answer
28 views

CIVICRM Upgrade in Joomla Environment - CRM updates but database aborts

I have a Joomla 3.11 environment running PHP 7.3 and CIVICRM 5.57. We have followed the steps to upgrade CIVICRM to 5.60/5.61 in Joomla. The CRM updates fine but it abends when trying to update the ...
Margaret's user avatar
  • 111
2 votes
1 answer
56 views

CiviCRM in a separate database keeps testing the Drupal database on update

I've installed Drupal (9) and CiviCRM (5.59) in separate databases using drush site:install and cv core:install in that order. The drupal database connection is set in settings.php, and the civi ...
commonpike's user avatar
  • 1,181
0 votes
0 answers
28 views

CiviCRM upgrade in Joomla failing

I have got a Joomla website running CiviCRM version 5.41.2 and we are migrating to a WordPress website running CiviCRM version 5.60.0 I have backed up the Joomla site and working on a dev environment ...
RustyIngles's user avatar
0 votes
1 answer
11 views

"Update indices" fails because of `foreign key constraint`

A site that was running fine on 5.60.0 for a week or so with no notices. I see today that there is a notice about missing indices: Ok. I can follow instructions. However on pressing the "Update ...
kapn's user avatar
  • 899
0 votes
3 answers
115 views

- Could not find valid value for id

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 performing when ...
Karen-Ann's user avatar
  • 406
1 vote
1 answer
71 views

Cannot Complete Upgrade

Earlier I wrote in with a question about a database upgrade failing because of date constraints (Upgrade to 5.57.1 Fails With Error executing task "Fix dangerous delete cascade"). I did not ...
Josh's user avatar
  • 887
1 vote
1 answer
241 views

What issues are there when running with a database that "does not fully support timezones"

I recently installed CiviCRM 5.58.0 on wordpress, but under system status I am getting a warning that says: The MySQL database does not fully support timezones. Please ask the database administrator ...
RobotToaster's user avatar
1 vote
1 answer
79 views

Upgrade to 5.57.1 Fails With Error executing task "Fix dangerous delete cascade"

I am trying to upgrade from CiviCRM 5.31.1 to 5.57.1 with Drupal 9. I am running MySQL 5.7.41. I downloaded the new version of CiviCRM with Composer. I then used CV to execute upgrade:db. The upgrade ...
Josh's user avatar
  • 887
0 votes
1 answer
30 views

Payment Shared (mjwshared) - Table 'civicrm_paymentprocessor_webhook' doesn't exist

Apologies if answered elsewhere/already (point me in the right direction please as I've not found it yet!). I inherited a Civi+WP installation which seems to be missing this table: ...
Femonic's user avatar
0 votes
1 answer
55 views

DB Error: unknown error when trying to send mosaico civimail

For a recently updated CiviCRM 5.56.2 + Drupal 7 (using mariadb 10.3), I got the little black box with the message "DB Error: unknown error" popping up when trying to send a mosaico civimail ...
Alan Dixon's user avatar
  • 6,841
2 votes
1 answer
51 views

All multilingual views are now MyISAM?

After the most recent CiviCRM security update to 5.56.2, a lot of my D7 sites (maybe all my multilingual ones?) are showing the old MyISAM Database Engine warning. I took one example and discovered ...
Alan Dixon's user avatar
  • 6,841
1 vote
0 answers
48 views

DataTables warning: table id=DataTables_Table_1 - Ajax error. For more information about this error, please see http://datatables.net/tn/7

I am facing DataTables warning: table id=DataTables_Table_1 - Ajax error. For more information about this error, please see http://datatables.net/tn/7 When I tried to load up the CiviCRM from Joomla ...
kelvin's user avatar
  • 11
0 votes
2 answers
355 views

Help with mariadb crash, out of memory error

I'm trying to track down the cause of an occasional mariadb crash on my server. The system is a Linode 4GB Ubuntu 22.04 instance running Wordpress 6.1.1, apache2 2.4.52, mariadb 10.6.11, and civicrm 5....
twowheeler's user avatar
1 vote
2 answers
54 views

Civicrm on Wordpress installer table doesnt exist

Using Ampp version 4.3 with Apache v2.4.54, MySQL v8.0.31, php version 7.4.32, Windows Every time I run the CiviCrm installer I get an error "Table 'civicrm.civicrm_worldregion' doesn't exist in ....
SaKa's user avatar
  • 11
1 vote
1 answer
33 views

Database security

I'm a CS grad student and curious about the security of the database beyond what is provided by the CiviCRM application. For example, the ACL can be used for more detailed access through the ...
Jason's user avatar
  • 11
2 votes
2 answers
123 views

Upgrading, received database error

On a (copy of a) Drupal 7.92 site, I'm attempting to upgrade CiviCRM from version 5.42.1 to 5.55.2. I did this by executing the following steps: cd /bitnami/drupal/modules/contrib rm -rf civicrm curl ...
Ken Williams's user avatar
2 votes
1 answer
57 views

Extensions require database update, Not able to use Mailing,

I'm on the latest versions of Drupal (9.4.8) and CiviCRM (5.55.1) and I'm using Composer to install/update. Although consulting data from CiviCRM is working fine, I do have a couple of issues: ...
Stefaan H's user avatar
0 votes
0 answers
20 views

5.51.3 to 5.54.0 - "DB_Error: DB Error: no such field in unknown on line unknown" for non-admins when running reports

We recently upgraded our CiviCRM instance from 5.51.3 to 5.54.0 to resolve some of the bugs that 5.54.0 resolves. Since then, non administrator users are not able to run any reports, and they get a ...
ben_fairless's user avatar
0 votes
1 answer
296 views

Resolving db error for unknown column in 'field list'"

Error: "Unknown column 'a_to_civicrm_value_reporting_doc_10.resource_2_67' in 'field list'" This is a follow-up question to one that started over here. From that thread, I am clear that this ...
kapn's user avatar
  • 899
4 votes
0 answers
85 views

reduce size civicrm_job_log?

I've read various articles about reducing the size of civicrm_job_log, but couldn't come to a conclusion. In This post : Truncate civicrm_job_log as often as you like - the data is only of very very ...
stackexchange user's user avatar
0 votes
2 answers
60 views

Upgrade to 5.52.0 - database won't reset

I upgraded to 5.52.0. The last step was to reset the database. I got an error message - " Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your ...
Ben Bachrach's user avatar
1 vote
1 answer
34 views

Cannot add new contributions anymore - DB Error: no such field

We are running CiviCRM 5.42.1 on Wordpress. We had no issues with adding contributions up until a week ago. We've not updated Civi recently - last update was more than 5 or 6 months ago. I get an ...
Sudesh's user avatar
  • 707
0 votes
1 answer
48 views

Upgrade issue moving from 5.49+ to 5.50*

In moving from 5.49 to 5.50 we seem to lose a table. All civimails generate a "DB missing table error" and the logs show the following. We get this error with all of the new versions of 50+...
breckenr's user avatar
0 votes
1 answer
20 views

Trying to edit Agenda tab in Events gives a DB error

CiviCRM 5.50.1, WordPress 6.0.1, 8.0.28. Someone recently tried to add an Agenda to an Event in CiviCRM, and kept getting a network error. I took a look, and yeah, going to the Agenda tab seems to ...
Michael Matthews's user avatar
0 votes
1 answer
62 views

Database Connection Only Works Some of the Time

I have a CiviCRM instance that has its database hosted in RDS Aurora. This has worked well for several years. Recently I needed to restore from a copy of the Aurora cluster and I changed the name of ...
Josh's user avatar
  • 887
1 vote
0 answers
26 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 ...
Richard Ellwood's user avatar
0 votes
2 answers
183 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/...
Steven James's user avatar
0 votes
1 answer
50 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 ...
themak's user avatar
  • 3,421
4 votes
3 answers
79 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.
CL_Usher's user avatar
3 votes
1 answer
61 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 ...
Tony Zeoli's user avatar
0 votes
2 answers
87 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 ...
Wade Keech's user avatar
1 vote
1 answer
78 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 ...
Josh's user avatar
  • 887
0 votes
1 answer
41 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, "...
Josh's user avatar
  • 887
2 votes
1 answer
48 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 ...
jsherk's user avatar
  • 573
2 votes
1 answer
73 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 ...
thoni56's user avatar
  • 1,231
2 votes
2 answers
57 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 ...
Dirkjan from AJO Amersfoort's user avatar

1
2 3 4 5
8