Questions tagged [database]
The database tag has no usage guidance.
285
questions
2
votes
3answers
32 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
23 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
26 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 ...
1
vote
1answer
28 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
40 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
22 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
32 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
61 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
38 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
40 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
28 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
41 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
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 ...
3
votes
1answer
67 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
32 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 ...
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
0
votes
2answers
60 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
75 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 ...
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
1answer
63 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
2answers
140 views
Database error when using CiviCRM admin UI: “Row size too large”
I'm helping on a site that is on a different server than usual and see this error regularly in the back end when trying to complete various tasks (e.g. clear caches, run database updates, etc.)
[...
7
votes
3answers
116 views
Recommendations or Experiences on Archiving Mailing Data
We have an instance that has been using CiviMail extensively for years.
The civicrm_mailing and civicrm_activiy tables far exceed the number of records of any other tables.
It seems likely that these ...
1
vote
0answers
23 views
Wordpress Civicrm_acl_contact_cache Table got Deleted
I am using CiviCRM wordpress version 5.12.3 - For some reason Civicrm_acl_contact_cache table got deleted
I am sure no one has Database access (apart from me). But still the table got deleted. Also, ...
1
vote
1answer
26 views
Where is 'Payment Method' stored in the database for a Contribution “Payment Details”?
Simple question! What table is this in, where do I find it? Latest Civi/Drupal
This is on a contribution detail page. I updated the payment_instrument_id in civicrm_contribute but it does not change ...
1
vote
1answer
52 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
35 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
92 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
26 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
106 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
65 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
33 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
54 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
35 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
67 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
44 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 ...
2
votes
2answers
59 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
24 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
2answers
107 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
40 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
53 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
59 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
88 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
159 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
218 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
36 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 ...
5
votes
2answers
326 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' ...
