Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
41 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
56 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
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
25 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
16 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
85 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 ...
3
votes
1answer
52 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
52 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
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
29 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
1answer
36 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. ...
1
vote
2answers
87 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
52 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. ...
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
49 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
0
votes
2answers
88 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
1answer
68 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
1answer
39 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
52 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
67 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
2answers
50 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 ...
2
votes
2answers
112 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
115 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
21 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
19 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 ...
5
votes
2answers
223 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
1answer
46 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 ...
2
votes
4answers
559 views

no such table when using civicrm

CiviCRM 4.6.10 Joomla 3.4.0 getting this error when going to events dashboard or trying to create event. Sorry but we are not able to provide this at the moment. DB Error: no such table Return to ...
0
votes
1answer
59 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
22 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
89 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 ...
0
votes
2answers
40 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
1answer
62 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
30 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
44 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
33 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 ...
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 ...
2
votes
1answer
35 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
49 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
84 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
129 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
177 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
28 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 ...
1
vote
3answers
40 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
55 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
59 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
53 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 ...
-6
votes
2answers
34 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
30 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 ...