Ghost Release: 2.33.0

TL;DR

Ghost 2.33.0: Critical Bug Fixes for MySQL Migration and Bookmark Card

This release addresses two critical bugs: a MySQL migration issue that could cause data loss in version 2.32.0, and a 500 error when saving bookmark cards with unknown URLs. These fixes ensure database integrity for MySQL users and improve the stability of the bookmark card feature in the editor.

Highlight of the Release

• Fixed critical MySQL migration issue that could cause data loss in version 2.32.0
• Resolved 500 error when saving bookmark cards with unknown or unparseable URLs
• Improved database compatibility with MySQL InnoDB and utf8mb4 character set

Migration Guide

Migration from 2.32.0

If you're upgrading from Ghost 2.32.0, this release will automatically fix any database issues caused by the MySQL migration bug. No manual intervention is required.

For MySQL users who experienced issues with the members_stripe_customers table:

• The migration will correct the table structure
• Any incorrect tables created during the 2.32.0 upgrade will be fixed
• The customer_id column will be properly configured

No additional steps are needed as the migrations will run automatically during the upgrade process.

Upgrade Recommendations

Urgent Upgrade Recommended

This release fixes critical bugs that could result in data loss. All Ghost users, especially those running MySQL databases, should upgrade immediately.

If you're currently on version 2.32.0, upgrading to 2.33.0 is essential to prevent potential data corruption issues with the members_stripe_customers table.

The standard upgrade process applies:

1. Back up your database before upgrading
2. Follow the normal Ghost update procedure for your installation method
3. No additional configuration changes are required after upgrade

Bug Fixes

MySQL Migration Fix

Fixed a critical error during migration to 2.32.0 on MySQL installations (#11208). The issue was related to MySQL's limitation with InnoDB and utf8mb4, which doesn't allow unique keys with a length of more than 191 characters. The fix includes:

• Changed customer_id to a non-unique column
• Disabled the 2.32 members_stripe_customers migration
• Added a new migration to properly recreate the members_stripe_customers table
• Implemented a clean solution for both MySQL and SQLite databases

Bookmark Card Fix

Fixed a 500 error that occurred when saving posts with bookmark cards containing unknown or unparseable URLs (#11210). The issue was caused by:

• Attempting to access properties on payload.metadata when it didn't exist
• The bookmark card could be in an "unable to parse URL" state in the editor
• The fix adds proper checks for the existence of the payload.metadata object before performing URL transformations

New Features

No new features were introduced in this release. This is a bug fix release focused on addressing critical issues from the previous version.

Security Updates

No security fixes were included in this release.

Performance Improvements

No specific performance improvements were included in this release. The focus was on fixing critical bugs affecting data integrity and editor functionality.

Impact Summary

Ghost 2.33.0 is a critical bug fix release that addresses two important issues:

1. A MySQL migration bug in version 2.32.0 that could lead to data loss due to incompatibility with InnoDB's unique key length limitations when using utf8mb4 character sets. This affected the members_stripe_customers table and has been resolved with proper column configuration and table recreation.

2. A 500 error that occurred when saving posts containing bookmark cards with URLs that couldn't be parsed. This has been fixed by adding proper checks before accessing metadata properties.

These fixes significantly improve the stability and reliability of Ghost, particularly for MySQL users and content creators working with bookmark cards. The release contains no new features or breaking changes, focusing entirely on resolving these critical issues.

Full Release Notes