Auto-fix for 0 page count books or 0 min videos

Natively Product Requests
1

Following discussion here:

Books with 0 total pages, or videos with 0 min runtime, can result in server errors when users try to update. This seems fixable with a 2 step approach:

  1. Set up a script that runs a query on the db, to change anything with Total Pgs/Min: 0 to Total Pgs/Min: 1 (or another arbitrary number), and then flags those items for Librarian review
  2. Librarians update page counts as they’re able

The two-step approach should help avoid overloading the Librarians, since the initial complication will be removed, this leaving the actual adjustments non-urgent.

2

Plus perhaps step 3 “check and fix/flag when any new record is added” so no new cases creep in again later.

3

I thought this idea felt familiar. :laughing:

4

:100:

Great minds think somewhat alike?

5

The system could as well allow to add zero pages/zero minutes. It’s not something impossible like a division by zero or such.

6

Updating progress when there was no progress, probably breaks the system’s brain. :see_no_evil: