Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
16 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 ...
1
vote
1answer
47 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. &...
3
votes
1answer
106 views

SOLVED!! DB Error: no such table ERROR searching erroneous ACL table

I have read other related questions but I do not see a match with my mistake. Civicrm version 4.7.31 Drupal 7.67 MySQL 5.6.42 PHP7.1 After migrating from civicrm 4.5.8 and php5.6 everything works fine ...
2
votes
2answers
62 views

I get a WSOD when I use the search function on CiviCRM

CiviCRM was working fine until I downloaded an extension called CiviRules. I looked into the API for field UFMatch, clicked around in there, and pressed execute (got no warning that it was going to ...
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 ...
0
votes
0answers
11 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
31 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
2
votes
2answers
42 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 ...
1
vote
2answers
117 views

Your database settings don't appear to be correct. All green, but still error!

trying to install CiviCRM with Wordpress and I get the red DB error BUT all the line items are green. Any suggestions? Thanks! WP: 4.9.10 CiviCRM: 4.7.30 Wordpress Mysql: 5.7 on Azure Added ...
2
votes
1answer
78 views

CiviCRM database issue with views and the definer

We have a website using CiviCRM that was recently switched from Drupal to WordPress as well as to a new server. Everything on the website is working properly and they have had no issues with CiviCRM. ...
2
votes
1answer
31 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 ...
15
votes
2answers
698 views

MySQL Tuning: Is Defragmenting Tables safe?

I like using MySQLTuner to check on things from time to time. It's as easy as: $: sudo apt-get install mysqltuner (CentOS: sudo yum install mysqltuner) $: sudo mysqltuner Also, besides 'top' which ...
0
votes
0answers
12 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
0answers
12 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: ...
1
vote
1answer
47 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 ...
1
vote
1answer
89 views

Civicrm local db error

My Specs I migrated a production Drupal 7/Civicrm 7.x-4.7.9 site to my local machine. For my stack, I am running MAMP and PHP 5.6.32, the production server is on PHP 5.6.33 I downloaded all files,...
0
votes
0answers
18 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
14 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
55 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
0answers
21 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 ...
0
votes
1answer
42 views

CiviEvent Listing module in Joomla not finding database table

We are working on a long-needed update of our website. I thought I would take the opportunity to also follow what many say is best practice and move our Civi db out of a db shared with our Joomla CMS. ...
1
vote
1answer
62 views

Wordpress CiviCRM site unusable after database upgrade from 5.4.0 to 5.5.1

I'm relatively new to CiviCRM and am trying to get a client set up with the platform. I like it overall, it seems much more usable than most I've touched in the past. All seemed to be going well ...
3
votes
3answers
41 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 ...
5
votes
1answer
706 views

WordPress: Creating new WP Users from Civi Contacts

I've seen some example posts here for other CMS', but I haven't seen it explained for a WordPress environment. My situation is I have an Individual DB of 2,500 Contacts in Civi, and I want to turn ...
0
votes
2answers
30 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
31 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
1answer
42 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
24 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
34 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
74 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
43 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 ...
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 ...
0
votes
2answers
45 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 ...
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. ...
1
vote
1answer
38 views

Using Views with two sql servers

I am trying to set up Views on my CiviCRM 4.7.10 (Drupal 7.42). My Drupal database is on one SQL server. And my CiviCRM database is on another SQL server. Whenever I try to create a new view, I ...
2
votes
1answer
27 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 ...
0
votes
2answers
64 views

Database error when saving CiviCRM event: “Row size too large”

I'm using CiviCRM in multilingual mode. I can generally create events (and other objects) fine. However, I often run into update problems at some point. The interface will "spin" and never save. ...
3
votes
1answer
78 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 ...
0
votes
2answers
98 views

Initialization Error after any change

My website has member side and after adding a member to a site the site was broken and for members, Initialization Error occurs. so members couldn't access their own page on the website. and also ...
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
40 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
19 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
vote
2answers
106 views

Mapping database from Neon to Civi

Our organization is considering moving to CiviCRM after many years with Z2Systems Neon CRM and in downloading the MySQL database from Neon we note that there are 10 pages of table in the Neon database ...
2
votes
0answers
27 views

How to loop and update BAO objects

I was trying to be down with the cool kids and use DB_Object models for a looped database update. I've found somethning I thought should work, but doesn't so I must be doing/understanding something ...
0
votes
2answers
30 views

Created and Last Change Data

Created and where is the Last Change data held? Can I get information about the table location in SQL. System: Joomla! 3.9.10 CiviCRM 5.18.2
3
votes
2answers
29 views

Strange Text Appearing in Contact Address Area

My CiviCRM installation is showing weird text around the address area of each contact entry. The weird text disappears when I try to edit the address, but when I finish the edits the weird text ...
2
votes
2answers
62 views

URL Query String - Phone Number

How can I add a phone number in a URL query string in CiviCRM? Goal: To bring up all records associated with that number Thank you, Laurie
2
votes
1answer
40 views

Wrong database user

Maybe I've been staring at this too long and am missing something obvious. I do this duplicating of the live site onto the dev site often, but today it's broken. I created a copy of our site. It's on ...
2
votes
1answer
68 views

CiviCRM on Azure Not Finding the Server

I am trying to install CiviCRM on Azure using the Wordpress for Linux web app and it appears CiviCRM is failing to find the MYSQL server. I've checked many times to see if the database information, ...
2
votes
1answer
73 views

Upgrade to CiviCRM 4.3 failing on DROP FOREIGN KEY

I have successfully upgraded many other CiviCRM installations over the years, but I've been unable to work my way through this issue so far. Ubuntu 14.04 MySQL 5.7.23 Apache/2.4.7 PHP Version 5.6....

1
2 3 4 5 6