Health says the database is behind

An update has two halves: the app, and the database it reads. When the app is newer than the database, screens can say "This screen reads something the database does not have yet", and the Updates card on Health turns red.

Likely causes, in order

1. "The database is behind: run migration ... (and later, up to ...)". A release was installed but its database files were not all run. Run the ones it names, in number order, in the Supabase SQL editor. They are in the migrations folder of the install folder and in your copy of the code. See Install an update.
2. "The database skipped migration ...". One file in the middle was missed. Run each one it names, in order. What came after is in, but what the skipped one adds is missing.
3. A file was run but failed part way. The SQL editor shows an error and the number does not move. Copy the error and contact support before running anything else.
4. A newer release is waiting. Not an error. Each release under Updates says whether your database already has what it needs.

Good to know

• Each file records its own number when it finishes, so Settings, Tools, About shows the schema you are at.
• Never edit the numbered files. Your own changes, if you make any, are numbered 9000 and up.
• On a hosted plan, contact support rather than running anything yourself.