Why are invitations not being sent?

This usually occurs when certain background processes or database configurations are missing or incorrect.

To ensure invitations are picked up and processed correctly, follow these steps:

✅ Required Checks

  1. Cron Job:
    • Make sure the cron job is running correctly on the server.
    • If it's not enabled, the system won’t trigger the invitation process.
  1. `fw_invitations.sentdate` Field:
    • If the value is `0000-00-00`, invitations have not been marked as sent.
    • Compare this behavior with a working instance to identify discrepancies.
  1. Index on `sentdate`:
    • Go to the Structure > Indexes section of the `fw_invitations` table.
    • Ensure that `sentdate` has a BTREE index (e.g., `sentdate BTREE No No sentdate`).
    • If missing, add the index by referring to a working instance.

📌 Example Scenario

Invitations are queued, but none are being sent.
✔️ On checking `fw_invitations`, `sentdate` is `0000-00-00`, and no index exists on `sentdate`.
✔️ Compare with another working instance, add a BTREE index, and confirm cron is active.