How to fix invite_not_found: Invite has expired or already been used in Supabase

// Using the Supabase Management API
import { createClient } from '@supabase/supabase-js'

const supabaseAdmin = createClient(
  process.env.SUPABASE_URL!,
  process.env.SUPABASE_SERVICE_ROLE_KEY!
)

// Resend invitation to user email
const { data, error } = await supabaseAdmin.auth.admin.inviteUserByEmail(
  '[email protected]',
  {
    redirectTo: 'https://yourapp.com/invite-accepted',
    data: { role: 'member' } // Optional metadata
  }
)

if (error) {
  console.error('Failed to resend invitation:', error)
} else {
  console.log('New invitation sent:', data)
}

// List all pending invitations
const { data: invitations, error } = await supabaseAdmin
  .from('auth.invitations') // Internal table name may vary
  .select('*')
  .eq('email', '[email protected]')
  .eq('status', 'pending')

if (error) {
  console.error('Error checking invitations:', error)
} else if (invitations.length === 0) {
  console.log('No pending invitations found')
} else {
  console.log('Found invitations:', invitations)

  // Check expiry
  invitations.forEach(invite => {
    const createdAt = new Date(invite.created_at)
    const now = new Date()
    const hoursDiff = (now.getTime() - createdAt.getTime()) / (1000 * 60 * 60)

    if (hoursDiff > 48) {
      console.log('Invitation expired ' + hoursDiff.toFixed(1) + ' hours ago')
    }
  })
}

-- If using custom invitation tracking
UPDATE auth.invitations
SET expires_at = NOW() + INTERVAL '7 days'
WHERE email = '[email protected]'
  AND status = 'pending';

-- For Supabase hosted, check project settings
-- Go to Project Settings → Authentication → Email Templates
-- Look for "Invitation validity period" or similar

// Frontend: disable button after click
function handleInviteAccept(inviteToken) {
  const acceptButton = document.getElementById('accept-invite')
  acceptButton.disabled = true
  acceptButton.textContent = 'Processing...'

  // Call Supabase accept endpoint
  fetch('https://' + process.env.NEXT_PUBLIC_SUPABASE_URL + '/auth/v1/invite/accept', {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json',
    },
    body: JSON.stringify({ token: inviteToken }),
  })
  .then(response => {
    if (!response.ok) {
      if (response.status === 400) {
        // Show user-friendly message
        showError('This invitation has already been used. Please contact an administrator for a new one.')
      }
      acceptButton.disabled = false
      acceptButton.textContent = 'Accept Invitation'
    }
    return response.json()
  })
}