warning: Invalid argument supplied for foreach() in ... cod.module on line 120

MySQL ec_transaction table holds two entries for this one transaction. Please see attached.

Further, COD was set up to "Mark transaction as paid? = yes" and "Mark transaction workflow as completed? = yes", however the transaction status is Transaction received (under user's myfiles directory)", and why admin changed it to completed i got the following warning message:
user warning: Duplicate entry '' for key 2 query: INSERT INTO ec_customer (ecid, type, exid, token) VALUES (3, '', '', '21f7f2d42d14ec4d5867f9ebce0ae4c7') in C:\www\webroot\ec4\includes\database.mysql.inc on line 172.

Have test it with the latest dev (Oct 16) that supposedly have the fixed incorporated, and I'm afraid the issue persist.

Gordon, any idea where this stands? can you please point out where the issue might lie?

Have just downloaded the dev and the issue is current.

The "foreach() ... line 120" issue is solved. However, ec_transaction still holds two entries per transaction (please see attached in the 2nd post), is it by-design? in addition, although COD is set up to "Mark transaction as paid? = yes" and "Mark transaction workflow as completed? = yes", the transaction is Payments pending.

I believe the attached patch resolve the issue.