Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
12 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
29 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 ...
1
vote
0answers
18 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 ...
2
votes
1answer
42 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
39 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
34 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
19 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
33 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
49 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
49 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
20 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
42 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
40 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'...
2
votes
1answer
28 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
48 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
34 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
23 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
26 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
31 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
25 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 ...
0
votes
0answers
17 views

How to troubleshoot DB Error: no database selected

I'm upgrading to Drupal 8. My database logins in civicrm.settings.php are correct but I continue to get this error. I'm just trying to load the dashboard at /civicrm. Is there a way to produce more ...
2
votes
1answer
40 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
0answers
13 views

CIVIRM CV TOOL 0.3.2 trying to upgrade dbase 4.6.10 to 5.25 (or at least 4.7.13)

So i have a clean joomla 3.9 install and 5.25 codebase installed, I put the 4.6.10 database on there and ran the cv tool: cv:upgrade db –test It showed codebase 5.25 and database verison 4.6.10 so ...
0
votes
1answer
33 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
21 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
55 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
19 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 ...
0
votes
0answers
21 views

Import Contacts to CiviCRM using SQL query

How to import contacts to CiviCRM using SQL query? It should include the Group name too. I have a huge database need to import in CiviCRM, currently getting timeout error if I upload more than 1000 ...
2
votes
1answer
67 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 ...
0
votes
1answer
71 views

I get an error “One of parameters (value: sort_name) is not of the type MysqlColumnNameOrAlias” when trying to access most of my data

Okay, I'm new at this - honestly, probably not skilled enough to be doing this, but my organization has no money, so, well, I'm it. I installed on WordPress last year, and everything generally went ...
3
votes
3answers
48 views

Create a Google Map showing positions for every contact in a group

we need to create a web page which shows a Google Map of an area, having pins of all contacts in that area. is there an extension that could manage the dataset creation? If not, what are the SQL ...
0
votes
2answers
38 views

Can't install CiviCRM on Wordpress (error Database)

I try a several times to install CiviCRM on my Wordpress. But the Check before show problems with the database. I checked everything a several times but no success. Wordpress is running on a hosting ...
0
votes
2answers
32 views

Upgrade to 5.15.alpha1 fails due to “Incorrect key file for table” database error

Trying to carry out an upgrade of civicrm. It fails when trying to upgrade the database to 5.15.alpha1 due to "Incorrect key file for table" when trying to create an index called index_all. The table ...
2
votes
2answers
46 views

CiviCRM Membership data to external Database

I'm new to Joomla, CiviCRM and PHP, but looking to help with a small project. I'm looking to grab the members data from CiviCRM and transfer (or update if users already exist) into a different ...
2
votes
1answer
52 views

SOLVED CiviMobile: DB Error in adding a Participant to an Event

I have an issue with the database for which I find no solution, even after intensive search on Internet. It now unables me to add a Participant to an Event. And even has consequences on adding ...
1
vote
1answer
25 views

CiviCRM Report - Sorting DB error

when I'm preparing a report (Event Participants) through CiviCRM Report module and I want to sort the results by anything (age, name, etc) I am getting a fatal error: DB ERROR: No such field I'm ...
2
votes
1answer
36 views

Deadlocks on a high load of contact inserts

We use CiviCRM 5.21.2 with Drupal 7.69 and Webform together with webform_civicrm to provide petitions. The petitions ask for address and email. So every petition signature creates a contact with email ...
1
vote
3answers
97 views

Issue exporting and importing Contacts / Membership data

first time posting and really hope someone can help me! We are trying to EXPORT our data from an old installation of CiviCRM on a drupal server IMPORTED into a new installation of CiviCRM on ...
1
vote
1answer
52 views

How do I safely export my database and import it on a new server? [duplicate]

I will move a CiviCRM installation to another server and realized some strange database issues: it was not possible to save contacts with phone number anymore. The problem are the triggers in the ...
1
vote
1answer
16 views

outgoing sms activity link to provider when using multiple providers?

I'm testing out multiple sms providers, and I'm using the api to do reads for reporting on the back end, but I can't seem to figure out how the system knows which sms provider sent a particular sms. ...
0
votes
2answers
48 views

Rebuild Drupal Civi from scratch in WordPress

My situation is I have an Individual database of 11,344 Contacts in Drupal Civi, and I want to turn them all into WP Users. I know I can convert Users into Contacts, but I want to do it the other way ...
2
votes
2answers
29 views

How do you make certain category options non-selectable (but still there/reportable)?

Is there an extension available that allows you to make certain category options (on a 'pick list') non-selectable, but are still there/reportable? And can you do this based upon a previous field ...
1
vote
1answer
53 views

CiviCRM_API3_Exception

When I enable or disable an extension I get the error that follows. Enabling or disabling still happens. Advice on resolving this would be gratefully received. This site is running 5.21.2 on Joomla. &...
2
votes
1answer
31 views

What information does log_civicrm_group keep? How is it useful?

Do you use the log_civicrm_group logs? Our log file is now about 300MB - quite crazy. Are records of removal and adding contacts to groups stored here? Thats information we would like to keep. How do ...
3
votes
1answer
93 views

Upgrade fails with CiviCRM_API3_Exception: “API error: Could not delete payment processor type”

In upgrading to 5.20+ an error occured while running the database Case upgrade scripts. Deletion Error There is a Payment Processor associated with selected Payment Processor type, hence it can not ...
1
vote
0answers
16 views

Field size job.run_frequency

Is it possible to make the size of the field run_frequency in the table job greater? It is now 8, but if would be 10 then the translation for 'daily' will not be truncated (not for me in this case).
1
vote
0answers
48 views

Trigger Rebuild Is Not Working

I am getting this error " [nativecode=1442 ** Can't update table 'civicrm_contact' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.]" ...
1
vote
0answers
20 views

How to fix transaction mistakes in CiviEvent & CiviContribute

In CiviEvent, had a user that mistook chargeback for refund then using the Line Item Edit extension made more mistakes. The result is that for one event payee shows $500 refund more than correct. Upon ...

1
2 3 4 5
7