I knew there was a better way!
EDIT: While the old answer works... it is not how to do this. Instead do this:
- Go to the config section, and chose the differential group.
- Find the option differential.allow-reopen
- Set value to "Enable reopen" and save config entry.
- Navigate to closed differential review.
- Go to the bottom, and find the Leap Into Action section.
- Chose the action reopen and add a comment
- Press Clowncopterize and presto! Reopened!
No need to hack the database.
Also, take a look at the repository settings, to set up auto closing the way you want it.
- Go to the Repositories administration section
- Press edit for the repository you wish to manage
- Chose the tracking tab
- In the Application Configuration section you see two settings: Autoclose and Autoclose Branches.
I have set Autoclose to Enabled, and Autoclose Branches to master. That way only pushes to origin/master will autoclose a differential review.
---------OLD Answer--------
What sberry is suggesting is to SSH into your server, and open an MySql prompt:
mysql> USE phabricator_differential;
mysql> select status from differential_revision where id=5; (If your revision is D5 for example)
Notice that your status is not 0. It is most likely 3 for closed.
mysql> update differential_revision set status=0 where id=5;
Now your revision is open again.
I feel that this is quite cumbersome, but never the less it achieves the goal. I hope there is somebody who can suggest a better way to do it.