Questions tagged [database]
The database tag has no usage guidance.
1
vote
1answer
29 views
Database Syntax Error when attempting upgrade
I have a website that is on Drupal 7 and I am attempting to upgrade the version of Civi from 5.10 to 5.13 but when I attempt to upgrade it, I'm receiving the following error:
Database Error Code: ...
4
votes
1answer
32 views
Insert and Get New ID in Extension
Within a new extension, in a form's postProcess function, I am inserting into a non-Civi table (separate mysql database/table). What is the proper way to execute a MySQL insert statement and retrieve ...
0
votes
1answer
33 views
How to Export/Import all CiviCRM data from one website to another one
I am recreating my website on another server. So my big concern is how to move all CRM data to new server/website.
To do separately exporting/importing contacts, membership, activities etc. is not so ...
1
vote
1answer
18 views
What is the server IP in database trigger definitions?
We just did a MySQL server migration. I completely cleared out all the triggers and executed
https://test.sdcbcdream.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/menu/rebuild&reset=1&...
3
votes
1answer
48 views
Correct database collation recommendation
I now get the following warning under CiviCRM Status:
Future versions of CiviCRM may require MySQL utf8mb4 support. It is
recommended, though not yet required, to configure your MySQL server
...
2
votes
1answer
48 views
Upgrade from 5.11.0 to 5.12. failing database update - solution found
I'm failing because mysql doesn't like characters in a city name:
UPDATE civicrm_state_province INNER JOIN civicrm_country ON civicrm_state_province.country_id = civicrm_country.id SET ...
1
vote
2answers
29 views
Best practice for finishing a CiviCRM session? Close browser window? log out? does it matter?
When finished working in CiviCRM, is there a practical difference in terms of the health of my database between simply closing my Civi browser window vs explicitly logging out? We run on drupal...
2
votes
1answer
33 views
How do I use CiviCRM with LDAP?
I tried to get the CiviCRM LDAP integration working.
I used the LDAPcivi 'extension' (GitHub). And got it running quite quickly. But when I tried to connect with Thunderbird I ran into trouble. This ...
0
votes
1answer
27 views
Split Data from Wordpress Database
On my initial setup, I had installed CiviCRM onto the same database as the Wordpress installation.
Now I want to split this as I am migrating the website and would rather backup and have a copy of the ...
2
votes
1answer
42 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.
...
0
votes
2answers
38 views
Is there a best practice or recipe for migrating a two database CiviCRM installation into one database?
I am replicating a Drupal 7 CiviCRM installation into a Pantheon CiviCRM Kickstart site. I have gone through the tedious effort of moving the Drupal content and settings from a default Drupal profile ...
1
vote
2answers
32 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
1
vote
1answer
20 views
What is the purpose of the active / disabled buttons for campaigns?
I feel like this answer will be super obvious, but I'm unable to find an answer in Civi's documents. I feel like the campaign status sums up the state of the campaign so I'm just wondering what info ...
1
vote
1answer
42 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
24 views
Search Builder Smart Group with Latitude, Street Address criteria 1292 Truncated DB Error
CiviCRM 5.9.1. Issue has occurred since an upgrade from version 4.7.17. The Smart Group/Contact Group in question is built on two simple search builder criteria:
Contacts Primary Street Address is ...
1
vote
1answer
41 views
How can I safely revert to earlier version of CiviCRM without reverting the database?
I am using Drupal 7.64. Everything was working fine on my site with CiviCRM 5.10.2.
I upgraded to 5.10.3 and two days later discovered that it broke an event registration page that relies on the ...
2
votes
2answers
45 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
2answers
73 views
CiviCRM 5.9.1 Cannot Read Database Information
CiviCRM 5.9.1 WordPress 5.0.3 PHP 7.2
Upgraded after migration between servers from 4.7.29 w/o issue. When I went inside the CiviCRM it asked me to redo everything like a new install. I went to the ...
3
votes
2answers
65 views
Database Error - unsure what the issue is
this morning I started encountering database issues - the only thing I can think of is the upgrade to 5.9 that we did yesterday.
First discovery was the Cron error - via log.
Jan 17 10:15:02 [...
2
votes
3answers
106 views
DB Error: constraint violation on anonymous user event registration after 5.8.2 -> 5.9.0 update
After updating from 5.8.2 to 5.9.0, anonymous users suddenly get the above error when trying to register for an event.
Anyone a good hint how to resolve that? Thanks
Debug log shows
Datenbank-...
2
votes
0answers
22 views
Multilingual and multidomain: “unknown column” DB error. How to set preferred language for child domains?
I am running CiviCRM v.5.4.0 in a WordPress (v.4.9.9) multisite. The WordPress main site is CiviCRM Domain_ID 1, and each WordPress child site has a different CiviCRM Domain_ID. This has been working ...
3
votes
1answer
87 views
How to get CiviCRM Views to work in Drupal 8 with separate CiviCRM database
When setting up a Drupal 8 with separate CiviCRM database, the Drupal views cannot read the CiviCRM database:
SQLSTATE[42S02]: Base table or view not found: 1146 Table
'xxx.civicrm_contact' ...
1
vote
3answers
34 views
Wordpress: MyISAM Database Engine Error after update
After update to Civicrm 5.8.0 I got a:
MyISAM Database Engine
Your database is configured to use the MyISAM database engine. CiviCRM requires InnoDB. You will need to convert any MyISAM tables in ...
0
votes
2answers
49 views
Hosting Provider for CiviCRM
I am trying to install my CiviCRM instance on my current drupal installation that is my website which is hosted by the webgo24.de. During installation I get an error „DB Error“ and after some emails ...
4
votes
1answer
52 views
Ran direct SQL update to bulk update contact names, changes not appearing until editing and saving
I'm finishing up a migration to CiviCRM from a homegrown Python application I wrote, and without going into too much detail as to the why, I needed to do a bulk update of all the contact name fields ...
1
vote
1answer
52 views
Completely lost. Help!
No one at our organization knows how to use Civi. The person who set it up is no longer on staff. How do we even get in touch with someone? We urgently need to get into our account on the Civi website ...
-5
votes
2answers
33 views
I would like a complete list of features via email please
My problem is asking for a list of features through this difficult portal.
I hope the software isn't as user unfriendly as this portal.
Please send list of features to my work email address = ...
2
votes
2answers
27 views
What is the best way for an end user to get all the contact and activity data from the database?
Our group is using CiviCRM to house membership data for a small food cooperative. We've lost our web developer and we're trying to get all of our data out of CiviCRM with only the user interface ...
0
votes
1answer
34 views
How will I maintain versioning of civicrm in github?
I customized a civicrm. I want to put on github.I cannot maintain a mysql database versioning. How can I do that?
1
vote
1answer
62 views
Could not create database trigger (AWS, RDS)
How can I fix this issue about database trigger. I attached the screenshot for the info. Thanks so much for the help]1
2
votes
1answer
49 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
vote
1answer
38 views
Error Upgrading DB to 4.7.18: SQL
[Error: Upgrade DB to 4.7.18: SQL]
[nativecode=1062 ** Duplicate entry 'Chandigarh-1101' for key 'UI_name_country_id']
How can I fix the error as given below:
INSERT INTO `civicrm_state_province` (...
1
vote
1answer
47 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 ...
1
vote
1answer
36 views
Running 2 civicrm instances on 1 database
I have one mySQL database and one Apache webserver. Can I still run 2 separate wordpress/Civicrm environments (like staging and production)?
1
vote
2answers
34 views
Where is the developer documentation for making core CiviCRM database changes, to the schema and to the initial data?
I'm working on a (newer) PR for CRM-19751, which requires some database schema changes and addition of an option group with its options. Obviously I knew something about this when I created the ...
0
votes
1answer
42 views
Database in unexpected version (and we have no backup DB)
Applied the 5.3.2 patch to our WP site yesterday, and in so doing upgraded the database to 5.6.alpha1. After doing this, multiple components (Contributions, Events, Mailing) became unusable. Trying to ...
1
vote
1answer
33 views
Delete contacts from group
I'm tried to delete contacts group (basically entire contacts from the particular group), getting Gateway timed out error and only few contacts are getting deleted.
So I'm planning to delete ...
0
votes
1answer
38 views
Database update failing for CiviCRM upgrade in Joomla 2.5
I have installed Civi 4.2.19 in Joomla 2.5, to upgrade the 4.1.1 version. I cleared all cache and then tried to run the database update. I got this fatal error:
Fatal error: require_once(): Failed ...
0
votes
1answer
54 views
DB error missing field in contribution reports after upgrade to 5.4.0 (Drupal)
After upgrade to 5.4.0 (from 4.7) I'm seeing fatal DB errors ("no such field") when refreshing Contribution Detail & Summary reports. Debug log shows:
$Fatal Error Details = Array ( [callback] =...
2
votes
1answer
74 views
db error reinstalling CiviCRM
I'm just getting started with CiviCRM and trying to install on our WordPress site.
I completed the initial install once, but accidentally used the existing WordPress database - I would prefer to ...
3
votes
1answer
34 views
saving mapping fields
I have just saved fields for exporting to a new saved mapping field, but it is not coming up as an option when I go back into the database and try to export the same details for another group. I'm ...
2
votes
2answers
28 views
How can I find members
I would like to know if it is possible to find a person on the database only with the CIVI number, and how can I do it?
0
votes
1answer
29 views
When removing a group from a contact I get: Error - DB Constraint Violation - GroupContact, get API
[copied from https://issues.civicrm.org/jira/browse/CRM-20711
noted on CiviCRM version 4.7.27]
In the Contact record, when I try to remove or delete a contact from a group they've already been added ...
0
votes
2answers
74 views
Can I export full database and import it in a fresh newer CiviCRM version?
I am experiencing difficulties during CiviCRM upgrade from 4.7.14 to 4.7.31 or 5.1, namely, fields like contact.birth_date get broken. (More: DB Error after upgrading 4.7.x to 5.1 (Drupal))
I have ...
1
vote
1answer
63 views
Sorry but we are not able
I have tried to append a new contact
Contact saved
When I tried to search
this is the answer
1
vote
1answer
45 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,...
2
votes
0answers
112 views
DB Error after upgrading 4.7.x to 5.1 (Drupal)
After upgrading CiviCRM from v4.7.14 to 5.1 (or v4.7.31) which went seemingly well, CiviCRM encounters the following problem. UPDATE: Issue does not appear until 4.7.29 (including), and comes up only ...
-1
votes
1answer
27 views
duplicate database in civiCRM
Is it possible to duplicate the data base on Civi ? (contacts) Because i need to do it for my traineeship.I don't even know if it's possible but maybe does an alternativ way to do it. thanks and have ...
0
votes
3answers
133 views
How can I completely remove previous improperly uninstalled CiviVolunteer?
I'm trying to install the CiviVolunteer extension (Drupal 7, Civi 5), but am getting this error message in response:
Field: name must be unique. An conflicting entity already exists - id: 186
It ...
1
vote
2answers
153 views
CiviCRM Cannot add or update a child row: a foreign key constraint fails error after upgrading from 4.7.30 to 5.0.2
After running the command to upgrade the database I got a constraint violation error.
ERROR USERINFO: ALTER TABLE civicrm_case ADD CONSTRAINT FK_civicrm_case_case_type_id FOREIGN KEY (case_type_id) ...
