-- execute("INSERT INTO freshbooks_expenses (expense_id, staff_id, category_id, client_id, project_id, vendor, account_id, fb_vendor_id, fb_staff_id, fb_category_id, fb_client_id, iacez_expense_id, date, notes, status, tax1_amount, tax1_percent, tax1_name, tax2_amount, tax2_percent, tax2_name, created_at, updated_at)\n SELECT expenses.fb_expense_id, expenses.fb_staff_id, expenses.fb_category_id, expenses.fb_client_id, expenses.fb_project_id, expenses.fb_vendor_name, freshbooks_accounts.id, freshbooks_vendors.id, freshbooks_staff.id, freshbooks_categories.id, freshbooks_clients.id, entries.id, expenses.date, expenses.notes, expenses.status, expenses.tax1_amount, expenses.tax1_percent, expenses.tax1_name, expenses.tax2_amount, expenses.tax2_percent, expenses.tax2_name, expenses.created_at, expenses.updated_at FROM expenses\n INNER JOIN freshbooks_accounts ON freshbooks_accounts.company_id = expenses.company_id\n INNER JOIN freshbooks_vendors ON freshbooks_vendors.account_id = freshbooks_accounts.id AND freshbooks_vendors.name = expenses.fb_vendor_name\n INNER JOIN freshbooks_staff ON freshbooks_staff.account_id = freshbooks_accounts.id AND freshbooks_staff.staff_id = expenses.fb_staff_id\n INNER JOIN freshbooks_categories ON freshbooks_categories.account_id = freshbooks_accounts.id AND freshbooks_categories.category_id = expenses.fb_category_id\n INNER JOIN freshbooks_clients ON freshbooks_clients.account_id = freshbooks_accounts.id AND freshbooks_clients.client_id = expenses.fb_client_id\n INNER JOIN entries ON entries.company_id = expenses.company_id AND entries.expense_id = expenses.id")
rake aborted!
An error has occurred, all later migrations canceled:
