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.

up vote 3 down vote accepted

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

  • Thanks for the answer. It lead me in the right direction. 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. – Paul-Tahoe Sep 13 at 17:49
  • Added now to my answer – Pradeep Nayak Sep 14 at 12:10

Your Answer

 

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.