Skip to main content
CiviCRM

Questions tagged [sql]

Ask Question

The tag has no summary.

46 questions
Newest Active Bountied Unanswered
4 votes
1 answer
131 views

Doing some performance tuning so I turned on the slow query log and found this absolute beast taking 3 minutes: SELECT COUNT(*) FROM (SELECT ANY_VALUE(civicrm_case.id) as case_id, ANY_VALUE(...
naomi's user avatar
  • 1,321
0 votes
0 answers
75 views

Upgrading from 5.67.3 to 5.72.3 I get a warning that the relationship cache needs to be rebuilt. Very similar to this SE question, but different. The rebuild failed. I then used api4 to run the ...
Andy Clark's user avatar
  • 5,035
2 votes
1 answer
210 views

During the upgrade to MySQL 8.0, I encountered three different warnings related to CiviCRM tables and I want to take the correct steps in this regard. These warnings are listed below: Usage of db ...
Fatih ATEŞ's user avatar
  • 456
0 votes
1 answer
30 views

We are converting a number of D7 views (for reports) to D9 version. Is it possible to copy the sql query from a D7 view to use in a D9 view. The fields in Civi are the same.
Dave T's user avatar
  • 1,269
2 votes
1 answer
69 views

I'm needing a way to add 2 columns to contribution summary report, 1 for displaying "last contribution date" and 1 for "last contribution amount" in a CiviReport. Is there an easy ...
dsmith63's user avatar
  • 419
1 vote
0 answers
38 views

we encountered a problem when building searches using the "in" operator. While this should work as if making multiple where statements connected with or, we noticed that on one of our custom ...
user12885's user avatar
  • 11
1 vote
2 answers
127 views

The CiviCRM database stores multiple values as a varchar field (a string with separator characters). For example, the IDs 3, 9 and 15 are internally saved as #3#9#15# (where # is in fact the character ...
emma's user avatar
  • 513
1 vote
0 answers
104 views

I currently have CiviCRM 5.31.0 for Wordpress installed. I want to change the default language from EN_US to Dutch (NL). After a quick google i found a tutorial and did the following steps: ...
Max van Kekeren's user avatar
  • 11
0 votes
1 answer
26 views

Activity Search is failing every time for this install (Search/Find Activities) no matter what search parameters are used. The problem is the following SQL error: SELECT count( DISTINCT ( ...
Andy Clark's user avatar
  • 5,035
1 vote
2 answers
48 views

CiviCRM version: 5.19.4 CMS: Drupal 7.69 PHP version: 7.1 When trying to view the Mailing Details Report page, I get the following error: DB Error: Constraint violation Looking in the error logs, ...
Jade's user avatar
  • 694
2 votes
0 answers
70 views

I have a task where I need to clean up payment instrument data. The basic problem was caused by a custom payment instrument of TBD, which is somehow preventing contributions from updating correctly, ...
Kurt Leadley's user avatar
  • 371
3 votes
2 answers
154 views

EDIT: This question turned out to be, in practical terms, something different than I originally thought I was asking. I am changing the title so that others will find the answer more easily in the ...
Kotodharma's user avatar
  • 111
3 votes
2 answers
267 views

When we first installed CiviCRM - the installer was super eager to install using the existing WordPress database. We were just testing out CiviCRM at the time, so it was not a big deal - however we ...
themak's user avatar
  • 3,457
2 votes
2 answers
120 views

When you set a default value for a custom field, it only exists at the form level. Is there a practical way to enforce them at the database level? For instance, by altering the SQL table definition? ...
Jon G - Megaphone Tech's user avatar
  • 39.9k
4 votes
1 answer
97 views

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 ...
Matt Woodward's user avatar
  • 525

15 30 50 per page
1
2 3 4