craftcms/cms

[5.x]: Upgrade from Craft 4 deletes all text fields

LinneaHarts opened this issue · 4 comments

LinneaHarts commented

What happened?

Description

Upgrading from Craft 4.10.1, following the upgrade path, and all text fields in the CMS are empty

Steps to reproduce

  1. Starting with Craft 4.10.1, rebuild the project config, clear the cache
  2. Upgrade all of the plugins and craft version in composer.json
  3. Run composer update
  4. Set the craft db charsets to utf8mb3, etc. as noted in documentation
  5. Run php craft up
  6. Remove craft db charset settings
  7. Run php craft db/convert-charset
  8. Log in to CMS, and all text fields are empty, including in revisions

Expected behavior

Text fields should have values in them

Actual behavior

All text fields are empty

Craft CMS version

4.10.1 to 5.2.2

PHP version

8.2.18

Operating system and version

Mac

Database type and version

MariaDB

Image driver and version

No response

Installed plugins and versions

I've tried this with my full list of plugins, and also with an abbreviated list of plugins, and it's still happening, so I don't think it's a plugin problem

Plugins
CKEditor 4.1.0
Element API 4.1.0
Mix v1.7.1

Craft 5.2.2

brandonkelly commented

Any chance you can send us your Craft 4 database backup and your Craft 5 composer.json + composer.lock files? If so, please send them to support@craftcms.com and we can look into it from there.

ph1lb4 commented

Hi @brandonkelly we are seeing the same exact issue. All fields in our Entries are gone after upgrade. We had used MariaDB 11.0.2 prior to the upgrade, so we think we can rule out the utf8 change as the issue.

brandonkelly commented

@ph1lb4 Same question to you then. The more the merrier.

brandonkelly commented

This ended up being due to Yii 2.0.50 adding JSON column support for MariaDB – which I totally missed when reviewing the update 🤦 – which conflicted with Craft’s MariaDB/JSON column support.

Just released Craft 5.2.3 which fixes the bug.

  • 🎉1