Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error in civicrm 4.4 and drupal 7 #1

Open
dkguru opened this issue Mar 28, 2014 · 0 comments
Open

Error in civicrm 4.4 and drupal 7 #1

dkguru opened this issue Mar 28, 2014 · 0 comments

Comments

@dkguru
Copy link

dkguru commented Mar 28, 2014

Error in module line 138 when generating receipts due to reference to non standard ministry projects database.

Fixed by changing line 129+ to:

$sql = "SELECT contact_id,display_name,total_amount,
DATE_FORMAT(receive_date,'%b %d, %Y') as gift_date
FROM civicrm_contribution ccontr
LEFT JOIN civicrm_contact cc ON cc.id = ccontr.contact_id
WHERE receive_date BETWEEN '$begin_date 00:00:00' AND '$end_date 23:59:59'
AND contact_id = {$cid}";
// Join with 'civicrm_value_ministry_projects_3' removed since it's not standard
// LEFT JOIN civicrm_value_ministry_projects_3 cvmp ON cvmp.entity_id = ccontr.id

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant