[Solved] Upgrading to 3.1.0.1 unexplained error in occurs in removeCancelled ReviewAssignments function

Software Support
3

… and it was exactly it.

The reviewAssignment (edit: got two of these cases, now solved) was linked to one of the removed submissions I mention here: [Solved] Upgrading 3.0.2 to 3.1.01 moveReviewerFiles fails - #2 by ajnyga

So the issue above is solved, but:

@asmecher do you have handy some sql commands that would search for:

  1. all submissions that are connected to journals that do not exist anymore
  2. and a way to remove review_assignments and other related data connected to those submissions

I am hoping to clean up the database for future updates and similar situations. And maybe such sql’s could even by added to the upgrade script to prevent situations like mine from happening?