Upgrade to 1.0.0-rc849

SQLite enforces the schema's foreign keys, and a second writer waits

SQLite opened every connection with foreign_keys=OFF, so the ON DELETE CASCADE the schema declares did nothing: deleting a media or a user left its rows behind. The pragma is on now, and doctrine:schema:update turns it back off for its table rebuilds. A busy_timeout of 5 s comes with it, so a background task writing at the same time as a request queues instead of failing with database is locked.

Affects every SQLite site. Rows orphaned before the upgrade stay until you drop them — what the check reports is safe to delete:

php bin/console dbal:run-sql 'SELECT * FROM pragma_foreign_key_check()'

A flat file edited in the same second as a sync is no longer lost

filemtime() resolves to the second, so an edit landing in the second pw:flat:sync stamped the page tied instead of looking newer, and was skipped for good. Ties are decided on content now. Nothing to do — expect Imported to count only pages that really changed.

The link tool's style options are named in English

bouton, bouton outline and discret are now Button, Button outline and Discreet — labels the catalogue can translate, where the French ones showed through untranslated.

Affects sites shipping their own editorjs_widget.html.twig. Rename the availableDesigns keys in your copy, or its options stay in French:

availableDesigns: { Button: 'link-btn', 'Button outline': 'link-btn-outline', Discreet: 'ninja' },

pw:static workers no longer use an opcache file cache

Affects every site building with pw:static on more than one worker. The flags that kept compiled scripts across worker lives segfault the worker on some PHP builds, losing the build (Worker N failed (exit 139: Segmentation violation)). Dropped: a fresh pass is now ~18% slower and finishes. Nothing to configure — reclaim the disk the cache still holds:

rm -rf var/cache/opcache

Opting back in by hand, for a PHP that does not crash on it.

Link Improver counts each of a page's links once

The cap counts the links a page already holds. A link written absolute (https://example.tld/page) or carrying a #fragment was counted twice, so a page reached its cap with half the links it was allowed — some pages got none at all.

Affects sites with link_improver: true whose content links are written absolute. Those pages will now gain auto links up to the density link_improver_max_links names. Nothing to configure; review what changed before publishing:

php bin/console pw:link-improver --host example.tld