Ghost Release: 3.38.1

TL;DR

Ghost 3.38.1: Critical SQLite3 Migration Fix

This patch release fixes a critical bug in Ghost 3.38.0 that prevented installations using SQLite3 from starting up properly. The issue was related to a limitation in SQLite3 that allows a maximum of 999 variables in a query, causing migration failures. This is an important fix for local development environments and smaller Ghost installations that use SQLite3 as their database.

Highlight of the Release

• Fixed critical SQLite3 migration issue that prevented Ghost from starting
• Resolved variable limit constraint in SQLite3 queries
• Improved compatibility with SQLite3 database installations

Migration Guide

No special migration steps are required for this patch release. Simply update to Ghost 3.38.1 to resolve the SQLite3 migration issue.

If you were previously unable to start Ghost 3.38.0 due to SQLite3 migration errors, upgrading to 3.38.1 should resolve the issue automatically.

Upgrade Recommendations

This is a highly recommended upgrade for all Ghost installations using SQLite3, especially for:

• Local development environments
• Small blog installations using the default SQLite3 database
• Any installation that experienced startup failures after upgrading to 3.38.0

The upgrade process is standard and should not require any special steps. This patch release contains an important fix that resolves a critical issue preventing Ghost from starting up properly when using SQLite3.

Bug Fixes

SQLite3 Migration Fix

Fixed a critical bug in the database migration process for SQLite3 installations. The issue was caused by exceeding SQLite3's limit of 999 variables in a single query. Ghost was attempting to use too many variables in a WHERE IN clause during migration, causing the process to fail and preventing Ghost from starting up.

The fix properly accounts for SQLite3's limitation by ensuring that one variable is reserved for the SET value, leaving 998 variables available for the WHERE IN clause values.

This resolves the issue reported in the Ghost forum where users were unable to start Ghost 3.38.0 locally when using SQLite3.

New Features

No new features were introduced in this patch release. This is a bugfix release focused on resolving a critical SQLite3 migration issue.

Security Updates

No security fixes were included in this patch release.

Performance Improvements

No specific performance improvements were included in this patch release. The focus was on fixing the critical SQLite3 migration issue.

Impact Summary

This patch release addresses a critical compatibility issue with SQLite3 databases in Ghost 3.38.0. The bug prevented Ghost from starting up when using SQLite3 due to exceeding the database's limit of 999 variables in a query during migration.

The impact was primarily felt by developers running Ghost locally and smaller installations that use SQLite3 as their database. These users were unable to start Ghost after upgrading to version 3.38.0.

This fix is particularly important for the development workflow as many developers use SQLite3 for local testing and development. The patch ensures that Ghost properly respects SQLite3's variable limits during database migrations, allowing the CMS to start up successfully.

Additionally, the release includes a fix for the canary build process on release commits, ensuring that the Admin submodule is properly handled when there aren't any differences to commit.

Full Release Notes