Gallery Sync Troubleshooting

Quick Test Commands

Production:

bash

curl -s "https://www.thelostandunfounds.com/api/gallery/sync?slug=last-night"

Local:

bash

curl -s "http://localhost:3001/api/gallery/sync?slug=last-night"

Cause: Private key newlines are not properly parsed from Vercel env vars.

Fix: Ensure key parsing in api/gallery/[...path].ts uses:

typescript

let GOOGLE_KEY = (rawKey || '')
    .replace(/\\n/g, '\n')  // Handle literal \n strings
    .replace(/"/g, '')
    .trim();

Re-upload key from local:

bash

source .env.local && echo "$GOOGLE_SERVICE_ACCOUNT_PRIVATE_KEY" | npx vercel env add GOOGLE_SERVICE_ACCOUNT_PRIVATE_KEY production --force

Cause: Service account email doesn't match the private key.

Fix:

bash

echo 'the-gallery-agent@the-lost-and-unf-1737406545588.iam.gserviceaccount.com' | npx vercel env add GOOGLE_SERVICE_ACCOUNT_EMAIL production --force

Cause: Environment variables not set in Vercel.

Verify with:

bash

npx vercel env ls production

Required vars:

Cause: Library doesn't exist in DB or missing google_drive_folder_id.

Check in Supabase:

sql

SELECT slug, google_drive_folder_id FROM photo_libraries;

Always trigger a redeploy:

bash

git commit --allow-empty -m "Trigger redeploy" && git push origin main