Upgraded to 5.4, Donor Report fails with bad sql. Status_id is missing

Question

Upgraded from 4.6.38 to 5.4.0 in a test env. The Donor Report (Summary) and (Detail) both fail on this piece of sql

 SELECT id, title 
 FROM civicrm_batch 
 WHERE item_count >= 1 
 AND status_id != 
 ORDER BY title

Clearly the status_id is missing.

I then upgraded to 5.5.0 hoping maybe that would fix it, nope.

civicrm_batch has no rows so I'm guessing it queries it for some batch id gets back null and sticks that into the query.

I tried to create some batches both open and closed for all the possibilities I think there are. That didn't help.

Answer 1

This error will occur if you have missing/inactive Batch Status. To check navigate to CiviCRM >> Administer >> System Settings >> Option Groups. Search for Batch Status and then click on options link besides it.

You should see 'Data Entry' if not then you will need to add it as it is required by CiviCRM or enable it if its disabled.

Note from Paul: It existed and was enabled; however, it had a value of 0 as did Reopen and Export. I looked at a demo and saw they have other values. Just hitting the Edit in order Data Entry, Reopen, Export and saving caused them automatically have the right value. That fixed the issue. Add this info to your answer and I'll check it and up vote it.

HTH

Pradeep