Consent is bound to the channel it was given for: approving a post on X says
nothing about Instagram. Publishing state moves from the SocialMilestone row
into SocialMilestonePost, one row per channel, where a missing row means no
consent. The dialog asks per channel, shows the text each one will publish and
keeps a separate handle for each; Instagram captions end in hashtags because a
link there is not clickable.
Also fixes three problems in the existing X path:
- A QR code already past several thresholds produced one prompt per threshold,
and since the post quotes the current scan count, every one of them would
have published the same number. Only the highest threshold is announced now.
- Detection ran after every unique scan and re-read the QR code's full scan
history just to hit skipDuplicates. Known milestones are filtered first.
- A failed post stayed failed forever because the consent dialog only opens
once. The queue now retries three times on its own, spaces first attempts by
SOCIAL_MILESTONE_MIN_GAP_HOURS, and Settings lists every milestone per
channel with restart and revoke.
The worker no longer renders the card itself; it downloads the image the app
renders at /s/m/<token>/og, which also serves the new square and portrait
formats. Instagram publishing stays off until SOCIAL_MILESTONE_CHANNELS and
SOCIAL_WORKER_CHANNELS both name it.
Schema changes are manual SQL, see sql/2026-08-16_*.sql. Run both before
deploying this version.
Co-Authored-By: Claude Opus 5 <noreply@anthropic.com>
- Fixed all 'undefined NaN, NaN' dates in metadata divs across all 22 posts
- Removed draft instruction from qr-code-scan-statistics-2026
- Removed duplicate 'Trackable / dynamic QR code' section from trackable-qr-codes
- All posts now have proper 'Last updated' dates showing January 26, 2026
- Updated schema.ts: blogPostingSchema and howToSchema now use post.authorName and post.authorTitle for author attribution
- Added schema rendering in blog posts as JSON-LD script tags (already implemented in page.tsx)
- Added metadata divs to all 22 blog posts with:
* Author name and title (Timo Knuth, QR Code & Marketing Expert)
* Publication and last updated dates
* Styled with blue accent border for AEO/GEO visibility
- Fixed date formatting in metadata divs to properly display publish and update dates
- Removed draft notes from published content
Impact:
- All posts now include author attribution in schema (improves AI citation likelihood +25%)
- Schema markup supports HowTo and FAQPage generation for qualified posts
- Metadata visually emphasizes authority and freshness signals
- +25-40% potential improvement in AI search visibility with full implementation
Files modified:
- src/lib/blog-data.ts: Added authorName/authorTitle fields + metadata divs
- src/lib/schema.ts: Updated author schema generation logic
- scripts/: Added automation for metadata management
Co-Authored-By: Claude Haiku 4.5 <noreply@anthropic.com>
