I've submitted v4.0.1 of SNAP Affiliates to the Zen Cart plugin moderator for review; I'll post back here when it's available for download (https://www.zen-cart.com/downloads.php?do=file&id=1635).

This update contains the changes required for more recent/strict MySql versions, as the unpaid commissions' values' will cause MySql-generated errors.

PLEASE NOTE: This version has not been validated for Zen Cart 1.5.6 and later; there will be an updated version coming real-soon-now to provide an overall integration with those versions of Zen Cart.