Questions tagged [database]
The database tag has no usage guidance.
377
questions
1
vote
1
answer
41
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 ...
0
votes
0
answers
26
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 ...
- 61
0
votes
1
answer
48
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 ...
- 71
0
votes
0
answers
8
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 ...
- 934
0
votes
1
answer
24
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 ...
- 91
2
votes
1
answer
49
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 ...
- 1,181
0
votes
0
answers
25
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 ...
- 101
0
votes
1
answer
10
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 ...
- 791
0
votes
3
answers
74
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 ...
- 406
1
vote
1
answer
53
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 ...
- 857
1
vote
1
answer
193
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 ...
- 13
1
vote
1
answer
67
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 ...
- 857
0
votes
1
answer
29
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:
...
- 3
0
votes
1
answer
44
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 ...
- 6,644
2
votes
1
answer
48
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 ...
- 6,644
1
vote
0
answers
37
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 ...
- 11
0
votes
2
answers
211
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....
- 778
1
vote
2
answers
45
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 ....
- 11
1
vote
1
answer
28
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 ...
- 11
2
votes
2
answers
93
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 ...
- 453
2
votes
1
answer
50
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:
...
- 53
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 ...
- 73
0
votes
1
answer
241
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 ...
- 791
3
votes
0
answers
72
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 ...
0
votes
2
answers
55
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 ...
- 495
1
vote
1
answer
33
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 ...
- 707
0
votes
1
answer
46
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+...
- 41
0
votes
1
answer
16
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 ...
0
votes
1
answer
55
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 ...
- 857
1
vote
0
answers
23
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 ...
- 161
0
votes
2
answers
176
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/...
- 131
0
votes
1
answer
44
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 ...
- 3,352
4
votes
3
answers
73
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.
- 41
3
votes
1
answer
60
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 ...
- 31
0
votes
2
answers
69
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 ...
1
vote
1
answer
63
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 ...
- 857
0
votes
1
answer
39
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, "...
- 857
2
votes
1
answer
44
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 ...
- 521
2
votes
1
answer
66
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 ...
- 1,231
2
votes
2
answers
54
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 ...
0
votes
1
answer
47
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 ...
- 1,278
2
votes
0
answers
39
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 ...
- 857
0
votes
1
answer
36
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....
1
vote
2
answers
86
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 ...
- 463
1
vote
1
answer
128
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 ...
- 11
2
votes
1
answer
141
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 ...
- 3,501
1
vote
0
answers
56
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:...
- 81
4
votes
1
answer
72
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" ...
- 41
3
votes
1
answer
69
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,114
3
votes
1
answer
96
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, ...
- 857