jonnybarnes.uk/database/migrations
Repository files (latest commit first)
Filename Latest commit message Latest commit date
Jonny Barnes faf8e5c1ec
Fix CSRF exemption and array-input crash on revocation/introspection
An Opus code review of the branch caught two real bugs the test suite
structurally couldn't see:

- /revocation and /introspect were never added to bootstrap/app.php's
  CSRF except list, so both were fully broken (403) for any real
  external client, despite every feature test passing — CSRF
  verification is short-circuited entirely while running tests.
  Verified live against the running app before and after the fix, and
  added a regression test that asserts against the actual configured
  exemptions rather than relying on request-time behavior that tests
  can't exercise.

- An array-shaped `token` param (e.g. token[]=a&token[]=b) crashed
  both endpoints with a 500, since this app promotes PHP warnings
  ("Array to string conversion") to exceptions. Fixed at the shared
  root, MicropubToken::findActive(), which also closes the same latent
  hole in VerifyMicropubToken's access_token param that predates this
  branch. Verified live and covered with regression tests.

Also applied the review's lower-severity findings: added the missing
introspection_endpoint Link header and metadata test assertions,
removed the now-dead is_string($scopes) array branch in the Micropub
handlers and media controller (scope is unconditionally a string from
the DB now, this guarded against a JWT-array-claim shape that can no
longer occur), dropped a redundant #[Table] model attribute, sized
token_hash to its actual 64-char length, and removed a one-off inline
style in the admin view.

Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_014625MfkGZ7GVdbqKme4a8L
2026-08-13 17:03:43 +01:00
..
2023_04_11_115837_create_bios_table.php Switch bio to be stored in database 2023-04-11 17:37:42 +01:00
2023_05_19_131031_alter_article_column_lengths.php refactor: Update article schema for better flexibility. 2023-05-27 16:47:44 +01:00
2023_08_27_113904_create_passkeys.php feat: Add Passkey support 2023-10-27 20:22:40 +01:00
2024_03_23_204940_add_bluesky_syndication_column.php Setup support for syndicating to Bluesky 2024-03-23 21:19:54 +00:00
2025_12_31_110617_create_media_note_pivot_table.php Images can be uploaded with alt text 2026-01-04 10:07:25 +00:00
2026_03_14_000000_expand_webmentions_source_target_to_text.php Expand webmentions source and target columns to text 2026-03-14 16:32:22 +00:00
2026_08_13_120924_create_micropub_tokens_table.php Fix CSRF exemption and array-input crash on revocation/introspection 2026-08-13 17:03:43 +01:00