Questions tagged [sql]

The tag has no usage guidance.

4 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
27 views

Updating Contribution payment instrument based on Financial Trxn payment instrument when there are multiple transactions

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, ...
1
vote
2answers
38 views

Custom field default values at database level, not form level?

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? ...
1
vote
0answers
21 views

Donation summary report (Repeat) gives error Incorrect integer value: 'text string' for column 'source' at row 1

Drupal 7, CiviCRM 4.7.27, using the standard report "Donation summary report (Repeat)", I'm getting an unexpected SQL error Incorrect integer value: 'my custom source string' for column 'source' at ...
1
vote
0answers
94 views

DB Error: syntax error in civicrm/contribute/transact

I'm getting the above error reported and I have no idea where to look to solve it. The URL generating the error is http://adpca.org/civicrm/contribute/transact?reset=1&id=3 The log / ...