SQL query to help fix sites affected by this Pay By Check bug: https://github.com/strangerstudios/pmpro-pay-by-check/pull/131. Update total, subtotal, and membership_id accordingly.

fill_empty_check_order_toatals.sql

/*
Query to help sites affected by this PMPro Pay By Check bug:
https://github.com/strangerstudios/pmpro-pay-by-check/pull/131

This will set all $0 check orders for a specific level to have a specific total.
This will not account for variable pricing such as donations or discount code uses.

Before executing this query, set membership_id to the level that you would like to fix
and total and subtotal to the recurring price for that level.

Before running this query, make sure to back up your database in case anything goes wrong.
*/
UPDATE wp_pmpro_membership_orders
SET total = 100, subtotal = 100
WHERE total = 0 AND membership_id = 2 AND gateway = 'check';