Problem with migration script 2023.06.14T00.00.00.update-file-paths.js

Questions and Answers Database-SQL
1
System Information
  • Strapi Version: 4.15.5
  • Operating System: ubuntu
  • Database: mysql:8.0
  • Node Version: 18
  • NPM Version: -
  • Yarn Version: -

Hello!
I’ve just updated Strapi to 4.15.5 and got this error:

MigrationError: Migration 2023.06.14T00.00.00.update-file-paths.js (up) failed: Original error: update `files` set `folder_path` = '/' where `folder_path` is null - ER_BAD_FIELD_ERROR: Unknown column 'folder_path' in 'where clause'

If I do not executing migration script then I see broken images in admin panel, exactly as described at

Please help!

2

Manually execute

UPDATE files SET folder_path = "/"

Now it is OK
see