| Index: civicrm/trunk/sites/all/bin/public_reporting/synchronize.sql |
| — | — | @@ -2,7 +2,7 @@ |
| 3 | 3 | DELETE FROM public_reporting; |
| 4 | 4 | INSERT INTO public_reporting (contribution_id, contact_id, name, converted_amount, original_currency, |
| 5 | 5 | original_amount, note, received) |
| 6 | | -SELECT cn.id, cn.id, IF(ct.do_not_trade, NULL, ct.display_name), cn.total_amount, |
| | 6 | +SELECT cn.id, ct.id, IF(ct.do_not_trade, NULL, ct.display_name), cn.total_amount, |
| 7 | 7 | SUBSTRING(cn.source, 1, 3), CONVERT(SUBSTRING(cn.source, 5), DECIMAL(20,2)), cn.note, UNIX_TIMESTAMP(cn.receive_date) |
| 8 | 8 | FROM civicrm_contribution cn |
| 9 | 9 | INNER JOIN civicrm_contact ct ON cn.contact_id = ct.id |