Symptoms

After upgrading to Crucible 2.3.x, viewing the diff of a patch file that's attached to a review will cause the diff to be reported as No Change.

Cause

The upgrade process updates the cru_stored_path table and adds unnecessary new line characters to the cru_path column.

Resolution

To resolve this issue please follow these steps:

1. Shut down Crucible.
2. Perform a backup of your database.

3. Login to the database and run the following SQL:

   UPDATE cru_stored_path SET cru_path = replace(cru_path, '\n', '');

4. Start Crucible and ensure your diff data for patch reviews have been restored.

This issue is also being tracked as a bug in CRUC-3710.