Drupal Release: 7.89

TL;DR

Drupal 7.89 focuses on PHP 8.1 compatibility and PostgreSQL database fixes. This release addresses several deprecated function warnings in PHP 8.1 and resolves multiple PostgreSQL-specific issues that were causing test failures. The update is primarily maintenance-focused, ensuring Drupal 7 continues to work properly with newer PHP versions and PostgreSQL databases.

Highlight of the Release

• Full PHP 8.1 compatibility with fixes for deprecated function warnings
• Comprehensive PostgreSQL database driver improvements
• Fixed issues with PostgreSQL identifier length limitations
• Resolved multiple test failures specific to PostgreSQL environments

Migration Guide

No specific migration steps are required for this update. This is a standard maintenance release that can be applied following the normal Drupal update process:

1. Back up your database and site files
2. Put your site into maintenance mode
3. Update your Drupal core codebase
4. Run the update script by visiting /update.php
5. Take your site out of maintenance mode

If you are specifically upgrading to PHP 8.1 alongside this Drupal update, be sure to test your site thoroughly, including any contributed modules that may have their own PHP 8.1 compatibility issues.

Upgrade Recommendations

This update is recommended for all Drupal 7 sites, especially those:

• Planning to upgrade to PHP 8.1
• Using PostgreSQL as their database backend
• Experiencing any of the specific issues fixed in this release

The update contains important compatibility fixes that will prevent deprecated function warnings when running on PHP 8.1 and resolves several PostgreSQL-specific issues. While not security-related, these fixes ensure continued smooth operation of Drupal 7 sites on modern hosting environments.

As always with any update, make a complete backup of your site and database before upgrading.

Bug Fixes

PHP 8.1 Compatibility Fixes

• Fixed deprecated function warning when passing null to check_plain() function
• Resolved issue with str_replace() receiving null parameter in system_modules()
• Fixed undefined array key "sequence_name" error in PostgreSQL driver
• Addressed deprecated warning when passing null to fwrite() in InsertQuery_pgsql->execute()
• Fixed deprecated warning when passing null to strlen() in theme_file_upload_help()

PostgreSQL Specific Fixes

• Ensured database identifiers don't exceed PostgreSQL's 63-character limit
• Fixed issue with uppercase test table names causing PostgreSQL tests to fail
• Corrected fully qualified table name handling in PostgreSQL tests
• Fixed node creation test failures specific to PostgreSQL
• Resolved invalid input syntax for integer in PollCreateTestCase on PostgreSQL
• Fixed inconsistent array order causing test failures in AggregatorUpdatePathTestCase
• Addressed inconsistent result order in DatabaseSelectTestCase::testUnion on PostgreSQL
• Added proper skipping of upgrade tests for PostgreSQL
• Fixed assertion failures on affected row counts in DatabaseUpdateTestCase::testExpressionUpdate
• Corrected key name checking in BasicMinimalUpdatePath::testBasicMinimalUpdate for PostgreSQL
• Fixed array order issues in FieldInfoTestCase::testFieldMap on PostgreSQL
• Resolved missing upload form in FileFieldWidgetTestCase::testMultiValuedWidget on PostgreSQL

New Features

No significant new features were added in this release. This update focuses primarily on compatibility improvements for PHP 8.1 and bug fixes for PostgreSQL database support.

Security Updates

No security fixes are included in this release. The changes are focused on compatibility with PHP 8.1 and PostgreSQL database improvements.

Performance Improvements

This release does not include specific performance improvements. The focus was on compatibility and bug fixes rather than performance enhancements.

Impact Summary

Drupal 7.89 is primarily a maintenance release focused on PHP 8.1 compatibility and PostgreSQL database improvements. The impact is most significant for sites running on PHP 8.1 or using PostgreSQL databases.

For PHP 8.1 users, this release eliminates several deprecated function warnings that would otherwise appear in logs, providing a cleaner operation without constant warnings. The fixes address issues with null parameters being passed to various core functions like check_plain(), str_replace(), fwrite(), and strlen().

For PostgreSQL users, this release represents a substantial improvement in database handling. It fixes long-standing issues with identifier length limitations, table naming, and test failures specific to PostgreSQL. These changes ensure more consistent behavior between MySQL and PostgreSQL database drivers, making PostgreSQL a more reliable option for Drupal 7 sites.

While this release doesn't add new features or security fixes, it's an important maintenance update that helps Drupal 7 remain compatible with modern hosting environments as PHP continues to evolve.