| Index: civicrm/trunk/sites/all/bin/public_reporting/triggers.sql |
| — | — | @@ -37,7 +37,7 @@ |
| 38 | 38 | UPDATE public_reporting pr |
| 39 | 39 | SET pr.contact_id = NEW.contact_id, pr.name = public_name, pr.converted_amount = NEW.total_amount, |
| 40 | 40 | pr.original_currency = SUBSTRING(NEW.source, 1, 3), pr.original_amount = SUBSTRING(NEW.source, 5), |
| 41 | | - pr.note = NEW.note, pr.received = UNIX_TIMESTAMP(NEW.receive_date) |
| | 41 | + pr.received = UNIX_TIMESTAMP(NEW.receive_date) |
| 42 | 42 | WHERE pr.contribution_id = NEW.id; |
| 43 | 43 | END IF; |
| 44 | 44 | END |